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

Reply via email to