[jira] [Commented] (OFBIZ-9243) load demo data failure

[Nicolas Malin (Jira)]

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

Deepak Dixit commented on OFBIZ-9243:
-------------------------------------

This is due to data dependency,
{code}
2017-03-03 14:02:36,208 |main                 |GenericDelegator              |E| Failure in create operation for entity [ProductCategoryMember]: org.apache.ofbiz.entity.GenericEntityException: Error while inserting: [GenericEntity:ProductCategoryMember][createdStamp,2017-03-03 14:02:36.163(java.sql.Timestamp)][createdTxStamp,2017-03-03 14:02:35.741(java.sql.Timestamp)][fromDate,2009-11-05 12:15:00.0(java.sql.Timestamp)][lastUpdatedStamp,2017-03-03 14:02:36.163(java.sql.Timestamp)][lastUpdatedTxStamp,2017-03-03 14:02:35.741(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-03-03 14:02:36,208 |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-03-03 14:02:36.163(java.sql.Timestamp)][createdTxStamp,2017-03-03 14:02:35.741(java.sql.Timestamp)][fromDate,2009-11-05 12:15:00.0(java.sql.Timestamp)][lastUpdatedStamp,2017-03-03 14:02:36.163(java.sql.Timestamp)][lastUpdatedTxStamp,2017-03-03 14:02:35.741(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}

productId GZ-1001 is define in ecommerce component and ecommerce is loading after ebay
{code}
2017-03-03 13:58:06,151 |main                 |ComponentContainer            |I| Auto-Loading component directory : [/Users/deepakdixit/sandbox/plain_ofbiz/plugins]
2017-03-03 13:58:06,172 |main                 |ComponentContainer            |I| Added class path for component : [assetmaint]
2017-03-03 13:58:06,223 |main                 |ComponentContainer            |I| Added class path for component : [bi]
2017-03-03 13:58:06,253 |main                 |ComponentContainer            |I| Added class path for component : [birt]
2017-03-03 13:58:06,316 |main                 |ComponentContainer            |W| Location '/Users/deepakdixit/sandbox/plain_ofbiz/plugins/cmssite/build/lib' does not exist
2017-03-03 13:58:06,316 |main                 |ComponentContainer            |I| Added class path for component : [cmssite]
2017-03-03 13:58:06,332 |main                 |ComponentContainer            |I| Added class path for component : [ebay]
2017-03-03 13:58:06,352 |main                 |ComponentContainer            |I| Not loading component [ebaystore] because it is disabled
2017-03-03 13:58:06,369 |main                 |ComponentContainer            |I| Added class path for component : [ecommerce]
2017-03-03 13:58:06,414 |main                 |ComponentContainer            |I| Added class path for component : [example]
2017-03-03 13:58:06,432 |main                 |ComponentContainer            |I| Added class path for component : [exampleext]
2017-03-03 13:58:06,472 |main                 |ComponentContainer            |I| Added class path for component : [hhfacility]
2017-03-03 13:58:06,503 |main                 |ComponentContainer            |I| Added class path for component : [ldap]
2017-03-03 13:58:06,520 |main                 |ComponentContainer            |I| Added class path for component : [lucene]
2017-03-03 13:58:06,538 |main                 |ComponentContainer            |I| Added class path for component : [myportal]
2017-03-03 13:58:06,559 |main                 |ComponentContainer            |I| Added class path for component : [passport]
2017-03-03 13:58:06,579 |main                 |ComponentContainer            |I| Added class path for component : [pricat]
2017-03-03 13:58:06,636 |main                 |ComponentContainer            |I| Added class path for component : [projectmgr]
2017-03-03 13:58:06,660 |main                 |ComponentContainer            |I| Added class path for component : [scrum]
2017-03-03 13:58:06,702 |main                 |ComponentContainer            |I| Added class path for component : [solr]
2017-03-03 13:58:06,744 |main                 |ComponentContainer            |I| Added class path for component : [webpos]
{code}

I think we need to remove data dependency among plugins component.

> load demo data failure
> ----------------------
>
>                 Key: OFBIZ-9243
>                 URL: https://issues.apache.org/jira/browse/OFBIZ-9243
>             Project: OFBiz
>          Issue Type: Bug
>          Components: ALL COMPONENTS
>    Affects Versions: Trunk
>            Reporter: Wai
>
> checkout latest ofbiz-framework and ofbiz-plugins
> $ gradlew cleanAll build
> $ gradlew loadDefault...using derby
> console output...
> 2017-03-02 17:18:32,143 |main                 |EntityDataLoadContainer       |I| 00040 of 17229 from file:/ofbiz-framework/plugins/webpos/data/PosSyncSettings.xml
> 2017-03-02 17:18:32,143 |main                 |EntityDataLoadContainer       |I| The following errors occurred in the data load:
> 2017-03-02 17:18:32,143 |main                 |EntityDataLoadContainer       |I| [loadData]: Error loading XML Resource "file:/ofbiz-framework/plugins/ebay/data/DemoEbayData.xml"; Error was: A transaction error occurred reading data
> 2017-03-02 17:18:32,144 |main                 |EntityDataLoadContainer       |I| [loadData]: Error loading XML Resource "file:/ofbiz-framework/plugins/myportal/data/MyPortalDemoData.xml"; Error was: A transaction error occurred reading data
> 2017-03-02 17:18:32,144 |main                 |EntityDataLoadContainer       |I| =-=-=-=-=-=-= Finished the data load with 17229 rows changed.
> }}

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