Uploaded image for project: 'Creative Pro by Nuxeo'
  1. Creative Pro by Nuxeo
  2. NBM-421

Dataset is not deploying under qa environment

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Resolved
    • Priority: Blocker
    • Resolution: Fixed
    • Affects Version/s: None
    • Fix Version/s: 0.1
    • Component/s: NBM App setup
    • Tags:
    • Sprint:
      nxL2IT 0.1-7

      Description

      When starting our qa environment with the current dataset installed; startup failed with following error:

      2018-03-29 16:31:45,166 ERROR [EventServiceImpl] Exception during deliverableItemLifecycleListener sync listener execution, continuing to run other listeners
      org.nuxeo.ecm.core.api.ConcurrentUpdateException: java.sql.BatchUpdateException: Batch entry 0 INSERT INTO "hierarchy" ("id", "parentid", "pos", "name", "isproperty", "primarytype", "mixintypes", "ischeckedin", "baseversionid", "majorversion", "minorversion", "isversion", "isretentionactive", "systemchangetoken", "changetoken") VALUES ('b2177a4a-d837-4ff8-a547-f644e1b0d6b8', '2253a8a8-0dbf-4965-aa16-f2a38f9e32ee', NULL, 'deliverableItem', 'FALSE', 'DeliverableItem', NULL, NULL, NULL, 0, 0, NULL, NULL, 0, 0) was aborted: ERROR: duplicate key value violates unique constraint "hierarchy_unique_child"
        Detail: Key (parentid, name)=(2253a8a8-0dbf-4965-aa16-f2a38f9e32ee, deliverableItem) already exists.  Call getNextException to see other errors in the batch.
      	at org.nuxeo.ecm.core.storage.sql.jdbc.JDBCConnection.checkConcurrentUpdate(JDBCConnection.java:184)
      	at org.nuxeo.ecm.core.storage.sql.jdbc.JDBCRowMapper.insertSimpleRows(JDBCRowMapper.java:561)
      	at org.nuxeo.ecm.core.storage.sql.jdbc.JDBCRowMapper.writeCreates(JDBCRowMapper.java:471)
      	at org.nuxeo.ecm.core.storage.sql.jdbc.JDBCRowMapper.write(JDBCRowMapper.java:444)
      ...
      	at com.nuxeo.brand.management.adapters.ProjectDeliverable.addDeliverableItem(ProjectDeliverable.java:79)
      	at com.nuxeo.brand.management.operations.CreateProjectDeliverable.lambda$addDeliverable$0(CreateProjectDeliverable.java:62)
      ...
      

        Attachments

          Activity

            People

            • Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved:

                Time Tracking

                Estimated:
                Original Estimate - Not Specified
                Not Specified
                Remaining:
                Remaining Estimate - 0 minutes
                0m
                Logged:
                Time Spent - 1 hour
                1h