Thanks David. That clarifies things.
As far as PROD_PRCAT_PROMO - I just cut and pasted from Rodrigo's
response, assuming everyone would understand . The actual table was
ProductPromoCategory. There were multiple rows with id of 10020,
although they did have different productPromoCondSeqID 's so I would not
have thought they would cause a problem.
What is the naming convention for foreign key constraints, btw?
-Dave
David E Jones wrote:
>
> "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
>>>>
>>>>
>>>
>>>
>>
>
>
--
Dave Tenerowicz
[EMAIL PROTECTED]
Office: 303.493.6727
Mobile 303.906.6116
Fax 303.814.8330
Visit us at http://www.salmonllc.com
