[jira] [Commented] (OFBIZ-12106) Data load error for 'Help Root' content data in initial project setup

[Nicolas Malin (Jira)]

    [ https://issues.apache.org/jira/browse/OFBIZ-12106?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17255002#comment-17255002 ]

Pradeep Choudhary commented on OFBIZ-12106:
-------------------------------------------

Reverified the data on the latest code branches, corresponding data is removed which causing the mentioned error. Updated directories on latest code version and rechecked.

This is not regenerating. Sorry for the noise.

Nothing to change. CLosing this ticket.

> 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)