I've used the (OFBiz) pre-configured sets for an xml export of product
data, and am getting foreign key errors. I created the files using
Product Part 1, followed by parts 2, 3 and 4. Dropped all the files into
a single directory and then attempted to import them into another
instance of OFBiz.
I get errors, as below.
The files created are numbered, and my assumption was that the numbering
would control the sequence in which they were loaded. Is this incorrect?
What is the correct sequence?
--snip errors (note: this is a partial snippet of the errors produced)--
2007-07-06 16:24:15,535 (main) [ TransactionUtil.java:291:WARN ] ----
exception report
----------------------------------------------------------
[TransactionUtil.setRollbackOnly] Calling transaction setRollbackOnly;
this stack trace shows where this is happening: Exception:
java.lang.Exception Message: Failure in create operation for entity
[ProductPromoCategory]: org.ofbiz.entity.GenericEntityException:
Exception while inserting the following entity:
[GenericEntity:ProductPromoCategory][andGroupId,_NA_(java.lang.String)][createdStamp,2007-07-06
16:24:15.472(java.sql.Timestamp)][createdTxStamp,2007-07-06
16:24:15.285(java.sql.Timestamp)][includeSubCategories,Y(java.lang.String)][lastUpdatedStamp,2007-07-06
16:24:15.472(java.sql.Timestamp)][lastUpdatedTxStamp,2007-07-06
16:24:15.285(java.sql.Timestamp)][productCategoryId,SuperSaver(java.lang.String)][productPromoActionSeqId,_NA_(java.lang.String)][productPromoApplEnumId,PPPA_INCLUDE(java.lang.String)][productPromoCondSeqId,01(java.lang.String)][productPromoId,10020(java.lang.String)][productPromoRuleId,01(java.lang.String)]
(while inserting:
[GenericEntity:ProductPromoCategory][andGroupId,_NA_(java.lang.String)][createdStamp,2007-07-06
16:24:15.472(java.sql.Timestamp)][createdTxStamp,2007-07-06
16:24:15.285(java.sql.Timestamp)][includeSubCategories,Y(java.lang.String)][lastUpdatedStamp,2007-07-06
16:24:15.472(java.sql.Timestamp)][lastUpdatedTxStamp,2007-07-06
16:24:15.285(java.sql.Timestamp)][productCategoryId,SuperSaver(java.lang.String)][productPromoActionSeqId,_NA_(java.lang.String)][productPromoApplEnumId,PPPA_INCLUDE(java.lang.String)][productPromoCondSeqId,01(java.lang.String)][productPromoId,10020(java.lang.String)][productPromoRuleId,01(java.lang.String)]
(SQL Exception while executing the following:INSERT INTO
OFBIZ.PRODUCT_PROMO_CATEGORY (PRODUCT_PROMO_ID, PRODUCT_PROMO_RULE_ID,
PRODUCT_PROMO_ACTION_SEQ_ID, PRODUCT_PROMO_COND_SEQ_ID,
PRODUCT_CATEGORY_ID, AND_GROUP_ID, PRODUCT_PROMO_APPL_ENUM_ID,
INCLUDE_SUB_CATEGORIES, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP,
CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
?, ?) (INSERT on table 'PRODUCT_PROMO_CATEGORY' caused a violation of
foreign key constraint 'PROD_PRCAT_PROMO' for key (10020). The statement
has been rolled back.))). Rolling back transaction. ---- stack trace
---------------------------------------------------------------
java.lang.Exception: Failure in create operation for entity
[ProductPromoCategory]: org.ofbiz.entity.GenericEntityException:
Exception while inserting the following entity:
[GenericEntity:ProductPromoCategory][andGroupId,_NA_(java.lang.String)][createdStamp,2007-07-06
16:24:15.472(java.sql.Timestamp)][createdTxStamp,2007-07-06
16:24:15.285(java.sql.Timestamp)][includeSubCategories,Y(java.lang.String)][lastUpdatedStamp,2007-07-06
16:24:15.472(java.sql.Timestamp)][lastUpdatedTxStamp,2007-07-06
16:24:15.285(java.sql.Timestamp)][productCategoryId,SuperSaver(java.lang.String)][productPromoActionSeqId,_NA_(java.lang.String)][productPromoApplEnumId,PPPA_INCLUDE(java.lang.String)][productPromoCondSeqId,01(java.lang.String)][productPromoId,10020(java.lang.String)][productPromoRuleId,01(java.lang.String)]
(while inserting:
[GenericEntity:ProductPromoCategory][andGroupId,_NA_(java.lang.String)][createdStamp,2007-07-06
16:24:15.472(java.sql.Timestamp)][createdTxStamp,2007-07-06
16:24:15.285(java.sql.Timestamp)][includeSubCategories,Y(java.lang.String)][lastUpdatedStamp,2007-07-06
16:24:15.472(java.sql.Timestamp)][lastUpdatedTxStamp,2007-07-06
16:24:15.285(java.sql.Timestamp)][productCategoryId,SuperSaver(java.lang.String)][productPromoActionSeqId,_NA_(java.lang.String)][productPromoApplEnumId,PPPA_INCLUDE(java.lang.String)][productPromoCondSeqId,01(java.lang.String)][productPromoId,10020(java.lang.String)][productPromoRuleId,01(java.lang.String)]
(SQL Exception while executing the following:INSERT INTO
OFBIZ.PRODUCT_PROMO_CATEGORY (PRODUCT_PROMO_ID, PRODUCT_PROMO_RULE_ID,
PRODUCT_PROMO_ACTION_SEQ_ID, PRODUCT_PROMO_COND_SEQ_ID,
PRODUCT_CATEGORY_ID, AND_GROUP_ID, PRODUCT_PROMO_APPL_ENUM_ID,
INCLUDE_SUB_CATEGORIES, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP,
CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
?, ?) (INSERT on table 'PRODUCT_PROMO_CATEGORY' caused a violation of
foreign key constraint 'PROD_PRCAT_PROMO' for key (10020). The statement
has been rolled back.))). Rolling back transaction.
org.ofbiz.entity.transaction.TransactionUtil.setRollbackOnly(TransactionUtil.java:291)
org.ofbiz.entity.transaction.TransactionUtil.rollback(TransactionUtil.java:238)
org.ofbiz.entity.GenericDelegator.create(GenericDelegator.java:580)
org.ofbiz.entity.GenericDelegator.storeAll(GenericDelegator.java:1097)
org.ofbiz.entity.util.EntitySaxReader.writeValues(EntitySaxReader.java:257)
org.ofbiz.entity.util.EntitySaxReader.parse(EntitySaxReader.java:239)
org.ofbiz.entity.util.EntitySaxReader.parse(EntitySaxReader.java:196)
org.ofbiz.entity.util.EntityDataLoader.loadData(EntityDataLoader.java:223)
org.ofbiz.entityext.data.EntityDataLoadContainer.start(EntityDataLoadContainer.java:266)
org.ofbiz.base.container.ContainerLoader.start(ContainerLoader.java:82)
org.ofbiz.base.start.Start.startStartLoaders(Start.java:263)
org.ofbiz.base.start.Start.startServer(Start.java:314)
org.ofbiz.base.start.Start.start(Start.java:318)
org.ofbiz.base.start.Start.main(Start.java:404)
--------------------------------------------------------------------------------
2007-07-06 16:24:15,535 (main) [ GenericDelegator.java:1131:ERROR] ----
exception report
---------------------------------------------------------- Failure in
storeAll operation: org.ofbiz.entity.GenericEntityException: Exception
while inserting the following entity:
[GenericEntity:ProductPromoCategory][andGroupId,_NA_(java.lang.String)][createdStamp,2007-07-06
16:24:15.472(java.sql.Timestamp)][createdTxStamp,2007-07-06
16:24:15.285(java.sql.Timestamp)][includeSubCategories,Y(java.lang.String)][lastUpdatedStamp,2007-07-06
16:24:15.472(java.sql.Timestamp)][lastUpdatedTxStamp,2007-07-06
16:24:15.285(java.sql.Timestamp)][productCategoryId,SuperSaver(java.lang.String)][productPromoActionSeqId,_NA_(java.lang.String)][productPromoApplEnumId,PPPA_INCLUDE(java.lang.String)][productPromoCondSeqId,01(java.lang.String)][productPromoId,10020(java.lang.String)][productPromoRuleId,01(java.lang.String)]
(while inserting:
[GenericEntity:ProductPromoCategory][andGroupId,_NA_(java.lang.String)][createdStamp,2007-07-06
16:24:15.472(java.sql.Timestamp)][createdTxStamp,2007-07-06
16:24:15.285(java.sql.Timestamp)][includeSubCategories,Y(java.lang.String)][lastUpdatedStamp,2007-07-06
16:24:15.472(java.sql.Timestamp)][lastUpdatedTxStamp,2007-07-06
16:24:15.285(java.sql.Timestamp)][productCategoryId,SuperSaver(java.lang.String)][productPromoActionSeqId,_NA_(java.lang.String)][productPromoApplEnumId,PPPA_INCLUDE(java.lang.String)][productPromoCondSeqId,01(java.lang.String)][productPromoId,10020(java.lang.String)][productPromoRuleId,01(java.lang.String)]
(SQL Exception while executing the following:INSERT INTO
OFBIZ.PRODUCT_PROMO_CATEGORY (PRODUCT_PROMO_ID, PRODUCT_PROMO_RULE_ID,
PRODUCT_PROMO_ACTION_SEQ_ID, PRODUCT_PROMO_COND_SEQ_ID,
PRODUCT_CATEGORY_ID, AND_GROUP_ID, PRODUCT_PROMO_APPL_ENUM_ID,
INCLUDE_SUB_CATEGORIES, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP,
CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
?, ?) (INSERT on table 'PRODUCT_PROMO_CATEGORY' caused a violation of
foreign key constraint 'PROD_PRCAT_PROMO' for key (10020). The statement
has been rolled back.))). Rolling back transaction. Exception:
org.ofbiz.entity.GenericEntityException Message: Exception while
inserting the following entity:
[GenericEntity:ProductPromoCategory][andGroupId,_NA_(java.lang.String)][createdStamp,2007-07-06
16:24:15.472(java.sql.Timestamp)][createdTxStamp,2007-07-06
16:24:15.285(java.sql.Timestamp)][includeSubCategories,Y(java.lang.String)][lastUpdatedStamp,2007-07-06
16:24:15.472(java.sql.Timestamp)][lastUpdatedTxStamp,2007-07-06
16:24:15.285(java.sql.Timestamp)][productCategoryId,SuperSaver(java.lang.String)][productPromoActionSeqId,_NA_(java.lang.String)][productPromoApplEnumId,PPPA_INCLUDE(java.lang.String)][productPromoCondSeqId,01(java.lang.String)][productPromoId,10020(java.lang.String)][productPromoRuleId,01(java.lang.String)]
(while inserting:
[GenericEntity:ProductPromoCategory][andGroupId,_NA_(java.lang.String)][createdStamp,2007-07-06
16:24:15.472(java.sql.Timestamp)][createdTxStamp,2007-07-06
16:24:15.285(java.sql.Timestamp)][includeSubCategories,Y(java.lang.String)][lastUpdatedStamp,2007-07-06
16:24:15.472(java.sql.Timestamp)][lastUpdatedTxStamp,2007-07-06
16:24:15.285(java.sql.Timestamp)][productCategoryId,SuperSaver(java.lang.String)][productPromoActionSeqId,_NA_(java.lang.String)][productPromoApplEnumId,PPPA_INCLUDE(java.lang.String)][productPromoCondSeqId,01(java.lang.String)][productPromoId,10020(java.lang.String)][productPromoRuleId,01(java.lang.String)]
(SQL Exception while executing the following:INSERT INTO
OFBIZ.PRODUCT_PROMO_CATEGORY (PRODUCT_PROMO_ID, PRODUCT_PROMO_RULE_ID,
PRODUCT_PROMO_ACTION_SEQ_ID, PRODUCT_PROMO_COND_SEQ_ID,
PRODUCT_CATEGORY_ID, AND_GROUP_ID, PRODUCT_PROMO_APPL_ENUM_ID,
INCLUDE_SUB_CATEGORIES, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP,
CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
?, ?) (INSERT on table 'PRODUCT_PROMO_CATEGORY' caused a violation of
foreign key constraint 'PROD_PRCAT_PROMO' for key (10020). The statement
has been rolled back.))) ---- stack trace
---------------------------------------------------------------
org.ofbiz.entity.GenericEntityException: Exception while inserting the
following entity:
[GenericEntity:ProductPromoCategory][andGroupId,_NA_(java.lang.String)][createdStamp,2007-07-06
16:24:15.472(java.sql.Timestamp)][createdTxStamp,2007-07-06
16:24:15.285(java.sql.Timestamp)][includeSubCategories,Y(java.lang.String)][lastUpdatedStamp,2007-07-06
16:24:15.472(java.sql.Timestamp)][lastUpdatedTxStamp,2007-07-06
16:24:15.285(java.sql.Timestamp)][productCategoryId,SuperSaver(java.lang.String)][productPromoActionSeqId,_NA_(java.lang.String)][productPromoApplEnumId,PPPA_INCLUDE(java.lang.String)][productPromoCondSeqId,01(java.lang.String)][productPromoId,10020(java.lang.String)][productPromoRuleId,01(java.lang.String)]
(while inserting:
[GenericEntity:ProductPromoCategory][andGroupId,_NA_(java.lang.String)][createdStamp,2007-07-06
16:24:15.472(java.sql.Timestamp)][createdTxStamp,2007-07-06
16:24:15.285(java.sql.Timestamp)][includeSubCategories,Y(java.lang.String)][lastUpdatedStamp,2007-07-06
16:24:15.472(java.sql.Timestamp)][lastUpdatedTxStamp,2007-07-06
16:24:15.285(java.sql.Timestamp)][productCategoryId,SuperSaver(java.lang.String)][productPromoActionSeqId,_NA_(java.lang.String)][productPromoApplEnumId,PPPA_INCLUDE(java.lang.String)][productPromoCondSeqId,01(java.lang.String)][productPromoId,10020(java.lang.String)][productPromoRuleId,01(java.lang.String)]
(SQL Exception while executing the following:INSERT INTO
OFBIZ.PRODUCT_PROMO_CATEGORY (PRODUCT_PROMO_ID, PRODUCT_PROMO_RULE_ID,
PRODUCT_PROMO_ACTION_SEQ_ID, PRODUCT_PROMO_COND_SEQ_ID,
PRODUCT_CATEGORY_ID, AND_GROUP_ID, PRODUCT_PROMO_APPL_ENUM_ID,
INCLUDE_SUB_CATEGORIES, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP,
CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
?, ?) (INSERT on table 'PRODUCT_PROMO_CATEGORY' caused a violation of
foreign key constraint 'PROD_PRCAT_PROMO' for key (10020). The statement
has been rolled back.)))
org.ofbiz.entity.datasource.GenericDAO.insert(GenericDAO.java:116)
org.ofbiz.entity.datasource.GenericHelperDAO.create(GenericHelperDAO.java:65)
--end snip
--
Dave Tenerowicz
[EMAIL PROTECTED]
Office: 303.493.6727
Mobile 303.906.6116
Fax 303.814.8330
Visit us at http://www.salmonllc.com
