[jira] [Commented] (OFBIZ-9211) load demo data shows error loading xml files

[Nicolas Malin (Jira)]

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

Jacques Le Roux commented on OFBIZ-9211:
----------------------------------------

The logs clearly show where the problem is, but not sure why this happens now, actually not sure when it began.
{code}
2017-02-11 09:49:59,838 |main                 |EntitySaxReader               |I| Finished 4 values from file:/C:/projectASF-Mars/ofbiz/plugins/ebay/data/EbaySecurityGroupDemoData.xml
2017-02-11 09:49:59,838 |main                 |EntitySaxReader               |I| Beginning import from URL: file:/C:/projectASF-Mars/ofbiz/plugins/ebay/data/DemoEbayData.xml
2017-02-11 09:49:59,845 |main                 |EntitySaxReader               |I| Transaction Timeout set to 2 hours (7200 seconds)
2017-02-11 09:49:59,918 |main                 |EntityEcaRule                 |I| Running Entity ECA Service: indexProductsFromCategory, triggered by rule on Entity: ProdCatalogCategory
2017-02-11 09:49:59,927 |main                 |ServiceDispatcher             |T| Sync service [entity-default/indexProductsFromCategory] finished in [9] milliseconds
2017-02-11 09:49:59,930 |main                 |EntityEcaRule                 |I| Running Entity ECA Service: indexProductsFromCategory, triggered by rule on Entity: ProductCategoryRollup
2017-02-11 09:49:59,936 |main                 |EntityEcaRule                 |I| Running Entity ECA Service: indexProduct, triggered by rule on Entity: ProductCategoryMember
2017-02-11 09:49:59,942 |main                 |GenericDelegator              |E| Failure in create operation for entity [ProductCategoryMember]: org.apache.ofbiz.entity.GenericEntityException: Error while inserting: [GenericEntity:ProductCategoryMember][createdStamp,2017-02-11 09:49:59.936(java.sql.Timestamp)][createdTxStamp,2017-02-11 09:49:59.845(java.sql.Timestamp)][fromDate,2009-11-05 12:15:00.0(java.sql.Timestamp)][lastUpdatedStamp,2017-02-11 09:49:59.936(java.sql.Timestamp)][lastUpdatedTxStamp,2017-02-11 09:49:59.845(java.sql.Timestamp)][productCategoryId,eBay_ECom_Category(java.lang.String)][productId,GZ-1001(java.lang.String)] (SQL Exception while executing the following:INSERT INTO OFBIZ.PRODUCT_CATEGORY_MEMBER (PRODUCT_CATEGORY_ID, PRODUCT_ID, FROM_DATE, THRU_DATE, COMMENTS, SEQUENCE_NUM, QUANTITY, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) (INSERT on table 'PRODUCT_CATEGORY_MEMBER' caused a violation of foreign key constraint 'PROD_CMBR_PRODUCT' for key (GZ-1001).  The statement has been rolled back.)). Rolling back transaction.
2017-02-11 09:49:59,942 |main                 |TransactionUtil               |W| Calling transaction setRollbackOnly; this stack trace shows where this is happening:
java.lang.Exception: Failure in create operation for entity [ProductCategoryMember]: org.apache.ofbiz.entity.GenericEntityException: Error while inserting: [GenericEntity:ProductCategoryMember][createdStamp,2017-02-11 09:49:59.936(java.sql.Timestamp)][createdTxStamp,2017-02-11 09:49:59.845(java.sql.Timestamp)][fromDate,2009-11-05 12:15:00.0(java.sql.Timestamp)][lastUpdatedStamp,2017-02-11 09:49:59.936(java.sql.Timestamp)][lastUpdatedTxStamp,2017-02-11 09:49:59.845(java.sql.Timestamp)][productCategoryId,eBay_ECom_Category(java.lang.String)][productId,GZ-1001(java.lang.String)] (SQL Exception while executing the following:INSERT INTO OFBIZ.PRODUCT_CATEGORY_MEMBER (PRODUCT_CATEGORY_ID, PRODUCT_ID, FROM_DATE, THRU_DATE, COMMENTS, SEQUENCE_NUM, QUANTITY, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) (INSERT on table 'PRODUCT_CATEGORY_MEMBER' caused a violation of foreign key constraint 'PROD_CMBR_PRODUCT' for key (GZ-1001).  The statement has been rolled back.)). Rolling back transaction.
{code}

> load demo data shows error loading xml files
> --------------------------------------------
>
>                 Key: OFBIZ-9211
>                 URL: https://issues.apache.org/jira/browse/OFBIZ-9211
>             Project: OFBiz
>          Issue Type: Bug
>          Components: base
>    Affects Versions: Trunk
>            Reporter: Wai
>
> ran "gradlew loadDefault"
> found the following error...
> 2017-02-09 23:30:19,274 |main                 |EntityDataLoadContainer       |I| The following errors occurred in the data load:
> 2017-02-09 23:30:19,274 |main                 |EntityDataLoadContainer       |I| [loadData]: Error loading XML Resource "file:/ofbiz-trunk/plugins/ebay/data/DemoEbayData.xml"; Error was: A transaction error occurred reading data
> 2017-02-09 23:30:19,274 |main                 |EntityDataLoadContainer       |I| [loadData]: Error loading XML Resource "file:/ofbiz-trunk/plugins/myportal/data/MyPortalDemoData.xml"; Error was: A transaction error occurred reading data

--
This message was sent by Atlassian JIRA
(v6.3.15#6346)