[ https://issues.apache.org/jira/browse/OFBIZ-12106?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Pradeep Choudhary closed OFBIZ-12106. ------------------------------------- Resolution: Invalid > Data load error for 'Help Root' content data in initial project setup > --------------------------------------------------------------------- > > Key: OFBIZ-12106 > URL: https://issues.apache.org/jira/browse/OFBIZ-12106 > Project: OFBiz > Issue Type: Bug > Components: content > Affects Versions: Trunk > Reporter: Pradeep Choudhary > Priority: Major > > Getting foreign key violation error in data setup for HELP_ROOT content data. > {code:java} > 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.{code} -- This message was sent by Atlassian Jira (v8.3.4#803005)