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

Pradeep Choudhary edited comment on OFBIZ-12106 at 12/26/20, 11:28 AM:
-----------------------------------------------------------------------

Reverified 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.


was (Author: pradeep.choudhary1994):
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)

Reply via email to