weekly build seed data problems

[Si Chen-2]

Hi everybody -

Just wanted to point out that it seems like we have some seed data  
problems in the SVN with the ForumDemoData.xml and the  
DemoCategoriesI18nData.xml:

      [java] 2006-10-06 11:49:35,941 (main) [    EntitySaxReader.java:
196:INFO ] Beginning import from URL: file:/var/sambashare/testing/
ofbiz_opentaps_453703/applications/content/data/ForumDemoData.xml
      [java] 2006-10-06 11:49:35,942 (main) [    EntitySaxReader.java:
234:INFO ] Transaction Timeout set to 2 hours (7200 seconds)
      [java] 2006-10-06 11:49:35,965 (main) [    EntitySaxReader.java:
527:WARN ] Ignoring invalid field name [ownerContentId] found for the  
entity: DataResource with value=GIZMOS
      [java] 2006-10-06 11:49:36,263 (main) [    EntitySaxReader.java:
253:INFO ] Finished 35 values from file:/var/sambashare/testing/
ofbiz_opentaps_453703/applications/content/data/ForumDemoData.xml
      [java] 2006-10-06 11:49:36,263 (main) [    EntitySaxReader.java:
196:INFO ] Beginning import from URL: file:/var/sambashare/testing/
ofbiz_opentaps_453703/applications/content/data/
DemoCategoriesI18nData.xml
      [java] 2006-10-06 11:49:36,264 (main) [    EntitySaxReader.java:
234:INFO ] Transaction Timeout set to 2 hours (7200 seconds)
      [java] 2006-10-06 11:49:36,553 (main) [   GenericDelegator.java:
579:ERROR]
      [java] ---- exception report  
----------------------------------------------------------
      [java] Failure in create operation for entity  
[ProductCategoryContent]: org.ofbiz.entity.GenericEntityException:  
Exception while inserting the following entity:  
[GenericEntity:ProductCategoryContent][contentId,C100DESC
(java.lang.String)][createdStamp,2006-10-06 11:49:36.397
(java.sql.Timestamp)][createdTxStamp,2006-10-06 11:49:36.264
(java.sql.Timestamp)][fromDate,2006-09-22 00:00:00.0
(java.sql.Timestamp)][lastUpdatedStamp,2006-10-06 11:49:36.397
(java.sql.Timestamp)][lastUpdatedTxStamp,2006-10-06 11:49:36.264
(java.sql.Timestamp)][prodCatContentTypeId,DESCRIPTION
(java.lang.String)][productCategoryId,100(java.lang.String)] (while  
inserting: [GenericEntity:ProductCategoryContent][contentId,C100DESC
(java.lang.String)][createdStamp,2006-10-06 11:49:36.397
(java.sql.Timestamp)][createdTxStamp,2006-10-06 11:49:36.264
(java.sql.Timestamp)][fromDate,2006-09-22 00:00:00.0
(java.sql.Timestamp)][lastUpdatedStamp,2006-10-06 11:49:36.397
(java.sql.Timestamp)][lastUpdatedTxStamp,2006-10-06 11:49:36.264
(java.sql.Timestamp)][prodCatContentTypeId,DESCRIPTION
(java.lang.String)][productCategoryId,100(java.lang.String)] (SQL  
Exception while executing the following:INSERT INTO  
OFBIZ.PRODUCT_CATEGORY_CONTENT (PRODUCT_CATEGORY_ID, CONTENT_ID,  
PROD_CAT_CONTENT_TYPE_ID, FROM_DATE, THRU_DATE, PURCHASE_FROM_DATE,  
PURCHASE_THRU_DATE, USE_COUNT_LIMIT, USE_DAYS_LIMIT,  
LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP,  
CREATED_TX_STAMP) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)  
(INSERT on table 'PRODUCT_CATEGORY_CONTENT' caused a violation of  
foreign key constraint 'PRDCAT_CNT_PRDCAT' for key (100).  The  
statement has been rolled back.))). Rolling back transaction.
      [java] Exception: org.ofbiz.entity.GenericEntityException
      [java] Message: Exception while inserting the following entity:  
[GenericEntity:ProductCategoryContent][contentId,C100DESC
(java.lang.String)][createdStamp,2006-10-06 11:49:36.397
(java.sql.Timestamp)][createdTxStamp,2006-10-06 11:49:36.264
(java.sql.Timestamp)][fromDate,2006-09-22 00:00:00.0
(java.sql.Timestamp)][lastUpdatedStamp,2006-10-06 11:49:36.397
(java.sql.Timestamp)][lastUpdatedTxStamp,2006-10-06 11:49:36.264
(java.sql.Timestamp)][prodCatContentTypeId,DESCRIPTION
(java.lang.String)][productCategoryId,100(java.lang.String)] (while  
inserting: [GenericEntity:ProductCategoryContent][contentId,C100DESC
(java.lang.String)][createdStamp,2006-10-06 11:49:36.397
(java.sql.Timestamp)][createdTxStamp,2006-10-06 11:49:36.264
(java.sql.Timestamp)][fromDate,2006-09-22 00:00:00.0
(java.sql.Timestamp)][lastUpdatedStamp,2006-10-06 11:49:36.397
(java.sql.Timestamp)][lastUpdatedTxStamp,2006-10-06 11:49:36.264
(java.sql.Timestamp)][prodCatContentTypeId,DESCRIPTION
(java.lang.String)][productCategoryId,100(java.lang.String)] (SQL  
Exception while executing the following:INSERT INTO  
OFBIZ.PRODUCT_CATEGORY_CONTENT (PRODUCT_CATEGORY_ID, CONTENT_ID,  
PROD_CAT_CONTENT_TYPE_ID, FROM_DATE, THRU_DATE, PURCHASE_FROM_DATE,  
PURCHASE_THRU_DATE, USE_COUNT_LIMIT, USE_DAYS_LIMIT,  
LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP,  
CREATED_TX_STAMP) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)  
(INSERT on table 'PRODUCT_CATEGORY_CONTENT' caused a violation of  
foreign key constraint 'PRDCAT_CNT_PRDCAT' for key (100).  The  
statement has been rolled back.)))
      [java] ---- stack trace  
---------------------------------------------------------------
      [java] org.ofbiz.entity.GenericEntityException: Exception while  
inserting the following entity: [GenericEntity:ProductCategoryContent]
[contentId,C100DESC(java.lang.String)][createdStamp,2006-10-06  
11:49:36.397(java.sql.Timestamp)][createdTxStamp,2006-10-06  
11:49:36.264(java.sql.Timestamp)][fromDate,2006-09-22 00:00:00.0
(java.sql.Timestamp)][lastUpdatedStamp,2006-10-06 11:49:36.397
(java.sql.Timestamp)][lastUpdatedTxStamp,2006-10-06 11:49:36.264
(java.sql.Timestamp)][prodCatContentTypeId,DESCRIPTION
(java.lang.String)][productCategoryId,100(java.lang.String)] (while  
inserting: [GenericEntity:ProductCategoryContent][contentId,C100DESC
(java.lang.String)][createdStamp,2006-10-06 11:49:36.397
(java.sql.Timestamp)][createdTxStamp,2006-10-06 11:49:36.264
(java.sql.Timestamp)][fromDate,2006-09-22 00:00:00.0
(java.sql.Timestamp)][lastUpdatedStamp,2006-10-06 11:49:36.397
(java.sql.Timestamp)][lastUpdatedTxStamp,2006-10-06 11:49:36.264
(java.sql.Timestamp)][prodCatContentTypeId,DESCRIPTION
(java.lang.String)][productCategoryId,100(java.lang.String)] (SQL  
Exception while executing the following:INSERT INTO  
OFBIZ.PRODUCT_CATEGORY_CONTENT (PRODUCT_CATEGORY_ID, CONTENT_ID,  
PROD_CAT_CONTENT_TYPE_ID, FROM_DATE, THRU_DATE, PURCHASE_FROM_DATE,  
PURCHASE_THRU_DATE, USE_COUNT_LIMIT, USE_DAYS_LIMIT,  
LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP,  
CREATED_TX_STAMP) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)  
(INSERT on table 'PRODUCT_CATEGORY_CONTENT' caused a violation of  
foreign key constraint 'PRDCAT_CNT_PRDCAT' for key (100).  The  
statement has been rolled back.)))
      [java] org.ofbiz.entity.datasource.GenericDAO.insert
(GenericDAO.java:121)
      [java] org.ofbiz.entity.datasource.GenericHelperDAO.create
(GenericHelperDAO.java:66)
      [java] org.ofbiz.entity.GenericDelegator.create
(GenericDelegator.java:561)
      [java] org.ofbiz.entity.GenericDelegator.storeAll
(GenericDelegator.java:1100)
      [java] org.ofbiz.entity.util.EntitySaxReader.writeValues
(EntitySaxReader.java:258)
      [java] org.ofbiz.entity.util.EntitySaxReader.endElement
(EntitySaxReader.java:389)


Best Regards,

Si
[hidden email]

[Jacques Le Roux]

Hi Si,

Thanks for the reminder.  I moved
  applications/product/data/DemoCategoriesI18nData.xml
to
  applications/ecommerce/data/DemoProductCategoriesI18nData.xml
and it's ok now.

Jacques

> Hi everybody -
>
> Just wanted to point out that it seems like we have some seed data  
> problems in the SVN with the ForumDemoData.xml and the  
> DemoCategoriesI18nData.xml: