Re: XML Data export using pre-configured sets

Fri, 13 Jul 2007 11:10:24 -0700 


"OFBiz" doesn't check foreign key constraints, it creates foreign keys in the 
database so the database can do it.

What do you mean by what you said, BTW? I don't get it because 
"PROD_PRCAT_PROMO" is not a table, it's the name of a foreign key constraint.

-David


Dave Tenerowicz wrote:

Rodrigo-
Thanks for the response. I find that there are indeed 2 rows in PROD_PRCAT_PROMO with an ID of 10020. What I do not understand is why OFBiz allowed this in the first place. If this violates a foreign key constraint on import, why do I not see errors in the operating instance from which I created the XML Export files??? 
Anyone understand why OFBiz allowed this in the first place?

-Dave

Rodrigo Souza wrote:

Error:
caused a violation of foreign key constraint 'PROD_PRCAT_PROMO' for key (10020) 

See 10020 duplicated key in table, or, remove the
constraint.


2007/7/12, Dave Tenerowicz <[EMAIL PROTECTED]>:

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

Reply via email to