Uploaded image for project: 'OFBiz'
  1. OFBiz
  2. OFBIZ-12106

Data load error for 'Help Root' content data in initial project setup

    XMLWordPrintableJSON

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Major
    • Resolution: Invalid
    • Affects Version/s: Trunk
    • Fix Version/s: None
    • Component/s: content
    • Labels:
      None

      Description

      Getting foreign key violation error in data setup for HELP_ROOT content data.

      2020-12-26 15:34:11,789 |main                 |TransactionUtil               |W| Calling transaction setRollbackOnly; this stack trace shows where this is happening:2020-12-26 15:34:11,789 |main                 |TransactionUtil               |W| Calling transaction setRollbackOnly; this stack trace shows where this is happening:java.lang.Exception: rollback called in Entity Engine SQLProcessor at org.apache.ofbiz.entity.transaction.TransactionUtil.setRollbackOnly(TransactionUtil.java:372) [main/:?] at org.apache.ofbiz.entity.jdbc.SQLProcessor.rollback(SQLProcessor.java:198) [main/:?] at org.apache.ofbiz.entity.datasource.GenericDAO.insert(GenericDAO.java:117) [main/:?] at org.apache.ofbiz.entity.datasource.GenericHelperDAO.create(GenericHelperDAO.java:68) [main/:?] at org.apache.ofbiz.entity.GenericDelegator.create(GenericDelegator.java:897) [main/:?] at org.apache.ofbiz.entity.GenericDelegator.storeAll(GenericDelegator.java:1357) [main/:?] at org.apache.ofbiz.entity.util.EntitySaxReader.writeValues(EntitySaxReader.java:314) [main/:?] at org.apache.ofbiz.entity.util.EntitySaxReader.parse(EntitySaxReader.java:284) [main/:?] at org.apache.ofbiz.entity.util.EntitySaxReader.parse(EntitySaxReader.java:261) [main/:?] at org.apache.ofbiz.entity.util.EntityDataLoader.loadData(EntityDataLoader.java:273) [main/:?] at org.apache.ofbiz.entityext.data.EntityDataLoadContainer.loadData(EntityDataLoadContainer.java:432) [main/:?] at org.apache.ofbiz.entityext.data.EntityDataLoadContainer.loadDataForDelegator(EntityDataLoadContainer.java:184) [main/:?] at org.apache.ofbiz.entityext.data.EntityDataLoadContainer.init(EntityDataLoadContainer.java:115) [main/:?] at org.apache.ofbiz.base.container.ContainerLoader.loadContainer(ContainerLoader.java:140) [main/:?] at org.apache.ofbiz.base.container.ContainerLoader.loadContainersFromConfigurations(ContainerLoader.java:104) [main/:?] at org.apache.ofbiz.base.container.ContainerLoader.load(ContainerLoader.java:74) [main/:?] at org.apache.ofbiz.base.start.StartupControlPanel.loadContainers(StartupControlPanel.java:146) [main/:?] at org.apache.ofbiz.base.start.StartupControlPanel.start(StartupControlPanel.java:70) [main/:?] at org.apache.ofbiz.base.start.Start.main(Start.java:89) [main/:?]2020-12-26 15:34:11,796 |main                 |GenericDelegator              |E| Failure in create operation for entity [ContentAssoc]: org.apache.ofbiz.entity.GenericEntityException: Error while inserting: [GenericEntity:ContentAssoc][contentAssocTypeId,TREE_CHILD(java.lang.String)][contentId,HELP_ROOT(java.lang.String)][contentIdTo,HELP_BIRT(java.lang.String)][createdStamp,2020-12-26 15:34:11.788(java.sql.Timestamp)][createdTxStamp,2020-12-26 15:34:11.653(java.sql.Timestamp)][fromDate,2006-01-12 01:01:01.0(java.sql.Timestamp)][lastUpdatedStamp,2020-12-26 15:34:11.788(java.sql.Timestamp)][lastUpdatedTxStamp,2020-12-26 15:34:11.653(java.sql.Timestamp)][mapKey,BIRT_main(java.lang.String)] (SQL Exception while executing the following:null (INSERT on table 'CONTENT_ASSOC' caused a violation of foreign key constraint 'CONTENTASSC_FROM' for key (HELP_ROOT).  The statement has been rolled back.)). Rolling back transaction.2020-12-26 15:34:11,796 |main                 |TransactionUtil               |I| Transaction rollback only not set, rollback only is already set.

        Attachments

          Activity

            People

            • Assignee:
              Unassigned
              Reporter:
              pradeep.choudhary1994 Pradeep Choudhary
            • Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: