[jira] [Updated] (OFBIZ-6553) ant load-extseed cause exception
[ https://issues.apache.org/jira/browse/OFBIZ-6553?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jacques Le Roux updated OFBIZ-6553: --- Fix Version/s: Upcoming Branch Description: $ ant load-extseed on a fresh database [java] 2015-07-07 16:15:06,249 |main |EntitySaxReader |I| Transaction Timeout set to 2 hours (7200 seconds) [java] 2015-07-07 16:15:06,298 |main |EntitySaxReader |I| Finished 3 values from file:/ofbiz-trunk/specialpurpose/passport/data/OAuth2CommonSeedData.xml [java] 2015-07-07 16:15:06,298 |main |EntitySaxReader |I| Beginning import from URL: file:/ofbiz-trunk/specialpurpose/passport/data/OAuth2LinkedInSeedData.xml [java] 2015-07-07 16:15:06,298 |main |EntitySaxReader |I| Transaction Timeout set to 2 hours (7200 seconds) [java] 2015-07-07 16:15:06,309 |main |GenericDelegator |E| Failure in create operation for entity [ThirdPartyLogin]: org.ofbiz.entity.GenericEntityException: Error while inserting: [GenericEntity:ThirdPartyLogin][createdStamp,2015-07-07 16:15:06.306(java.sql.Timestamp)][createdTxStamp,2015-07-07 16:15:06.298(java.sql.Timestamp)][fromDate,2011-01-01 00:00:00.0(java.sql.Timestamp)][lastUpdatedStamp,2015-07-07 16:15:06.306(java.sql.Timestamp)][lastUpdatedTxStamp,2015-07-07 16:15:06.298(java.sql.Timestamp)][loginMethTypeId,OAuth2(java.lang.String)][loginProviderId,LinkedIn(java.lang.String)][productStoreId,9000(java.lang.String)] (SQL Exception while executing the following:INSERT INTO public.THIRD_PARTY_LOGIN (PRODUCT_STORE_ID, LOGIN_METH_TYPE_ID, LOGIN_PROVIDER_ID, FROM_DATE, THRU_DATE, SEQUENCE_NUM, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?) (ERROR: insert or update on table "third_party_login" violates foreign key constraint "prod_store_logins" [java] Detail: Key (product_store_id)=(9000) is not present in table "product_store".)). Rolling back transaction. [java] 2015-07-07 16:15:06,309 |main |TransactionUtil |W| Calling transaction setRollbackOnly; this stack trace shows where this is happening: [java] java.lang.Exception: Failure in create operation for entity [ThirdPartyLogin]: org.ofbiz.entity.GenericEntityException: Error while inserting: [GenericEntity:ThirdPartyLogin][createdStamp,2015-07-07 16:15:06.306(java.sql.Timestamp)][createdTxStamp,2015-07-07 16:15:06.298(java.sql.Timestamp)][fromDate,2011-01-01 00:00:00.0(java.sql.Timestamp)][lastUpdatedStamp,2015-07-07 16:15:06.306(java.sql.Timestamp)][lastUpdatedTxStamp,2015-07-07 16:15:06.298(java.sql.Timestamp)][loginMethTypeId,OAuth2(java.lang.String)][loginProviderId,LinkedIn(java.lang.String)][productStoreId,9000(java.lang.String)] (SQL Exception while executing the following:INSERT INTO public.THIRD_PARTY_LOGIN (PRODUCT_STORE_ID, LOGIN_METH_TYPE_ID, LOGIN_PROVIDER_ID, FROM_DATE, THRU_DATE, SEQUENCE_NUM, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?) (ERROR: insert or update on table "third_party_login" violates foreign key constraint "prod_store_logins" [java] Detail: Key (product_store_id)=(9000) is not present in table "product_store".)). Rolling back transaction. [java] at org.ofbiz.entity.transaction.TransactionUtil.setRollbackOnly(TransactionUtil.java:374) [ofbiz-entity.jar:?] [java] at org.ofbiz.entity.transaction.TransactionUtil.rollback(TransactionUtil.java:313) [ofbiz-entity.jar:?] [java] at org.ofbiz.entity.GenericDelegator.create(GenericDelegator.java:925) [ofbiz-entity.jar:?] was: $ ant load-extseed on a fresh database [java] 2015-07-07 16:15:06,249 |main |EntitySaxReader |I| Transaction Timeout set to 2 hours (7200 seconds) [java] 2015-07-07 16:15:06,298 |main |EntitySaxReader |I| Finished 3 values from file:/ofbiz-trunk/specialpurpose/passport/data/OAuth2CommonSeedData.xml [java] 2015-07-07 16:15:06,298 |main |EntitySaxReader |I| Beginning import from URL: file:/ofbiz-trunk/specialpurpose/passport/data/OAuth2LinkedInSeedData.xml [java] 2015-07-07 16:15:06,298 |main |EntitySaxReader |I| Transaction Timeout set to 2 hours (7200 seconds) [java] 2015-07-07 16:15:06,309 |main |GenericDelegator |E| Failure in create operation for entity [ThirdPartyLogin]: org.ofbiz.entity.GenericEntityException: Error while inserting: [GenericEntity:ThirdPartyLogin][createdStamp,2015-07-07 16:15:06.306(java.sql.Timestamp)][createdTxStamp,2015-07-07 16:15:06.298(java.sql.Timestamp)][fromDate,2011-01-01 00:00:00.0(java.sql.Timestamp)][la
[jira] [Updated] (OFBIZ-6553) ant load-extseed cause exception
[ https://issues.apache.org/jira/browse/OFBIZ-6553?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Wai updated OFBIZ-6553: --- Description: $ ant load-extseed on a fresh database [java] 2015-07-07 16:15:06,249 |main |EntitySaxReader |I| Transaction Timeout set to 2 hours (7200 seconds) [java] 2015-07-07 16:15:06,298 |main |EntitySaxReader |I| Finished 3 values from file:/ofbiz-trunk/specialpurpose/passport/data/OAuth2CommonSeedData.xml [java] 2015-07-07 16:15:06,298 |main |EntitySaxReader |I| Beginning import from URL: file:/ofbiz-trunk/specialpurpose/passport/data/OAuth2LinkedInSeedData.xml [java] 2015-07-07 16:15:06,298 |main |EntitySaxReader |I| Transaction Timeout set to 2 hours (7200 seconds) [java] 2015-07-07 16:15:06,309 |main |GenericDelegator |E| Failure in create operation for entity [ThirdPartyLogin]: org.ofbiz.entity.GenericEntityException: Error while inserting: [GenericEntity:ThirdPartyLogin][createdStamp,2015-07-07 16:15:06.306(java.sql.Timestamp)][createdTxStamp,2015-07-07 16:15:06.298(java.sql.Timestamp)][fromDate,2011-01-01 00:00:00.0(java.sql.Timestamp)][lastUpdatedStamp,2015-07-07 16:15:06.306(java.sql.Timestamp)][lastUpdatedTxStamp,2015-07-07 16:15:06.298(java.sql.Timestamp)][loginMethTypeId,OAuth2(java.lang.String)][loginProviderId,LinkedIn(java.lang.String)][productStoreId,9000(java.lang.String)] (SQL Exception while executing the following:INSERT INTO public.THIRD_PARTY_LOGIN (PRODUCT_STORE_ID, LOGIN_METH_TYPE_ID, LOGIN_PROVIDER_ID, FROM_DATE, THRU_DATE, SEQUENCE_NUM, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?) (ERROR: insert or update on table "third_party_login" violates foreign key constraint "prod_store_logins" [java] Detail: Key (product_store_id)=(9000) is not present in table "product_store".)). Rolling back transaction. [java] 2015-07-07 16:15:06,309 |main |TransactionUtil |W| Calling transaction setRollbackOnly; this stack trace shows where this is happening: [java] java.lang.Exception: Failure in create operation for entity [ThirdPartyLogin]: org.ofbiz.entity.GenericEntityException: Error while inserting: [GenericEntity:ThirdPartyLogin][createdStamp,2015-07-07 16:15:06.306(java.sql.Timestamp)][createdTxStamp,2015-07-07 16:15:06.298(java.sql.Timestamp)][fromDate,2011-01-01 00:00:00.0(java.sql.Timestamp)][lastUpdatedStamp,2015-07-07 16:15:06.306(java.sql.Timestamp)][lastUpdatedTxStamp,2015-07-07 16:15:06.298(java.sql.Timestamp)][loginMethTypeId,OAuth2(java.lang.String)][loginProviderId,LinkedIn(java.lang.String)][productStoreId,9000(java.lang.String)] (SQL Exception while executing the following:INSERT INTO public.THIRD_PARTY_LOGIN (PRODUCT_STORE_ID, LOGIN_METH_TYPE_ID, LOGIN_PROVIDER_ID, FROM_DATE, THRU_DATE, SEQUENCE_NUM, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?) (ERROR: insert or update on table "third_party_login" violates foreign key constraint "prod_store_logins" [java] Detail: Key (product_store_id)=(9000) is not present in table "product_store".)). Rolling back transaction. [java] at org.ofbiz.entity.transaction.TransactionUtil.setRollbackOnly(TransactionUtil.java:374) [ofbiz-entity.jar:?] [java] at org.ofbiz.entity.transaction.TransactionUtil.rollback(TransactionUtil.java:313) [ofbiz-entity.jar:?] [java] at org.ofbiz.entity.GenericDelegator.create(GenericDelegator.java:925) [ofbiz-entity.jar:?] was: $ ant load-extseed causes exception [java] 2015-07-07 16:15:06,249 |main |EntitySaxReader |I| Transaction Timeout set to 2 hours (7200 seconds) [java] 2015-07-07 16:15:06,298 |main |EntitySaxReader |I| Finished 3 values from file:/ofbiz-trunk/specialpurpose/passport/data/OAuth2CommonSeedData.xml [java] 2015-07-07 16:15:06,298 |main |EntitySaxReader |I| Beginning import from URL: file:/ofbiz-trunk/specialpurpose/passport/data/OAuth2LinkedInSeedData.xml [java] 2015-07-07 16:15:06,298 |main |EntitySaxReader |I| Transaction Timeout set to 2 hours (7200 seconds) [java] 2015-07-07 16:15:06,309 |main |GenericDelegator |E| Failure in create operation for entity [ThirdPartyLogin]: org.ofbiz.entity.GenericEntityException: Error while inserting: [GenericEntity:ThirdPartyLogin][createdStamp,2015-07-07 16:15:06.306(java.sql.Timestamp)][createdTxStamp,2015-07-07 16:15:06.298(java.sql.Timestamp)][fromDate,2011-01-01 00:00:00.0(java.sql.Timestamp)][lastUpdatedStamp,2015-07-07 16:15:06.306(java.sql.Timestamp)][las
