You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@ofbiz.apache.org by Si Chen <si...@opensourcestrategies.com> on 2006/10/07 00:00:32 UTC
weekly build seed data problems
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
sichen@opensourcestrategies.com
Re: weekly build seed data problems
Posted by Jacques Le Roux <ja...@les7arts.com>.
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: