DemoPurchasing.xml and DemoStandardCosting.xml data loading pb

[Jacques Le Roux]

With last revision, I get (on a newly created derby DB)

     [java] 2007-02-21 05:01:52,187 (main) [    EntitySaxReader.java:194:INFO ] Beginning import from URL:
file:/D:/WorkspaceNew/ofbiz/applications/ecommerce/data/DemoPurchasing.xml
     [java] 2007-02-21 05:01:52,187 (main) [    EntitySaxReader.java:232:INFO ] Transaction Timeout set to 2 hours (7200 seconds)
     [java] 2007-02-21 05:01:55,515 (main) [   GenericDelegator.java:577:ERROR]
     [java] ---- exception report ----------------------------------------------------------
     [java] Failure in create operation for entity [AgreementTerm]: org.ofbiz.entity.GenericEntityException: Exception while
inserting the following entity: [GenericEntity:AgreementTerm][agreementId,AGR_TEST(
java.lang.String)][agreementTermId,1003(java.lang.String)][createdStamp,2007-02-21
05:01:55.486(java.sql.Timestamp)][createdTxStamp,2007-02-21 05:01:52.187(java.sql.Timestamp)][description,OPEN-001(java.lang.
String)][lastUpdatedStamp,2007-02-21 05:01:55.486(java.sql.Timestamp)][lastUpdatedTxStamp,2007-02-21
05:01:52.187(java.sql.Timestamp)][termTypeId,PURCH_VENDOR_ID(java.lang.String)] (while inserting: [GenericE
ntity:AgreementTerm][agreementId,AGR_TEST(java.lang.String)][agreementTermId,1003(java.lang.String)][createdStamp,2007-02-21
05:01:55.486(java.sql.Timestamp)][createdTxStamp,2007-02-21 05:01:52.187(java.sql.T
imestamp)][description,OPEN-001(java.lang.String)][lastUpdatedStamp,2007-02-21
05:01:55.486(java.sql.Timestamp)][lastUpdatedTxStamp,2007-02-21 05:01:52.187(java.sql.Timestamp)][termTypeId,PURCH_VENDOR_ID(java
.lang.String)] (SQL Exception while executing the following:INSERT INTO OFBIZ.AGREEMENT_TERM (AGREEMENT_TERM_ID, TERM_TYPE_ID,
AGREEMENT_ID, AGREEMENT_ITEM_SEQ_ID, INVOICE_ITEM_TYPE_ID, FROM_DATE, THRU_DATE,
TERM_VALUE, TERM_DAYS, DESCRIPTION, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?, ?, ?,
?, ?, ?, ?, ?, ?, ?, ?, ?, ?) (INSERT sur la table 'AGREEMENT_TERM' a entra
n la violation de la contrainte de cl externe 'AGRMNT_TERM_TTYP' pour la cl (PURCH_VENDOR_ID). L'instruction a t annule.))). Rolling
back transaction.
     [java] Exception: org.ofbiz.entity.GenericEntityException
     [java] Message: Exception while inserting the following entity:
[GenericEntity:AgreementTerm][agreementId,AGR_TEST(java.lang.String)][agreementTermId,1003(java.lang.String)][createdStamp,2007-02-2
1 05:01
:55.486(java.sql.Timestamp)][createdTxStamp,2007-02-21
05:01:52.187(java.sql.Timestamp)][description,OPEN-001(java.lang.String)][lastUpdatedStamp,2007-02-21
05:01:55.486(java.sql.Timestamp)][lastUpdatedTxStam
p,2007-02-21 05:01:52.187(java.sql.Timestamp)][termTypeId,PURCH_VENDOR_ID(java.lang.String)] (while inserting:
[GenericEntity:AgreementTerm][agreementId,AGR_TEST(java.lang.String)][agreementTermId,1003(java.l
ang.String)][createdStamp,2007-02-21 05:01:55.486(java.sql.Timestamp)][createdTxStamp,2007-02-21
05:01:52.187(java.sql.Timestamp)][description,OPEN-001(java.lang.String)][lastUpdatedStamp,2007-02-21 05:01:55.
486(java.sql.Timestamp)][lastUpdatedTxStamp,2007-02-21
05:01:52.187(java.sql.Timestamp)][termTypeId,PURCH_VENDOR_ID(java.lang.String)] (SQL Exception while executing the following:INSERT
INTO OFBIZ.AGREEMENT_
TERM (AGREEMENT_TERM_ID, TERM_TYPE_ID, AGREEMENT_ID, AGREEMENT_ITEM_SEQ_ID, INVOICE_ITEM_TYPE_ID, FROM_DATE, THRU_DATE, TERM_VALUE,
TERM_DAYS, DESCRIPTION, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_S
TAMP, CREATED_TX_STAMP) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) (INSERT sur la table 'AGREEMENT_TERM' a entran la
violation de la contrainte de cl externe 'AGRMNT_TERM_TTYP' pour la cl (PURCH_VE
NDOR_ID). L'instruction a t annule.)))

Also a pb on

     [java] 2007-02-21 05:01:56,468 (main) [    EntitySaxReader.java:194:INFO ] Beginning import from URL:
file:/D:/WorkspaceNew/ofbiz/applications/ecommerce/data/DemoStandardCosting.xml
     [java] 2007-02-21 05:01:56,468 (main) [    EntitySaxReader.java:232:INFO ] Transaction Timeout set to 2 hours (7200 seconds)
     [java] 2007-02-21 05:01:59,531 (main) [   GenericDelegator.java:577:ERROR]
     [java] ---- exception report ----------------------------------------------------------
     [java] Failure in create operation for entity [SupplierProduct]: org.ofbiz.entity.GenericEntityException: Exception while
inserting the following entity: [GenericEntity:SupplierProduct][availableFromDate
,2005-01-01 00:00:00.0(java.sql.Timestamp)][createdStamp,2007-02-21 05:01:59.531(java.sql.Timestamp)][createdTxStamp,2007-02-21
05:01:56.468(java.sql.Timestamp)][currencyUomId,USD(java.lang.String)][lastPrice
,9.0(java.lang.Double)][lastUpdatedStamp,2007-02-21 05:01:59.531(java.sql.Timestamp)][lastUpdatedTxStamp,2007-02-21
05:01:56.468(java.sql.Timestamp)][minimumOrderQuantity,0.0(java.lang.Double)][partyId,DemoSu
pplier(java.lang.String)][productId,MAT_A_COST(java.lang.String)][supplierPrefOrderId,10_MAIN_SUPPL(java.lang.String)][supplierProdu
ctId,MAT_A(java.lang.String)][supplierProductName,Material A(java.lang.Strin
g)] (while inserting: [GenericEntity:SupplierProduct][availableFromDate,2005-01-01
00:00:00.0(java.sql.Timestamp)][createdStamp,2007-02-21 05:01:59.531(java.sql.Timestamp)][createdTxStamp,2007-02-21 05:01:56.
468(java.sql.Timestamp)][currencyUomId,USD(java.lang.String)][lastPrice,9.0(java.lang.Double)][lastUpdatedStamp,2007-02-21
05:01:59.531(java.sql.Timestamp)][lastUpdatedTxStamp,2007-02-21 05:01:56.468(java.sql
.Timestamp)][minimumOrderQuantity,0.0(java.lang.Double)][partyId,DemoSupplier(java.lang.String)][productId,MAT_A_COST(java.lang.Stri
ng)][supplierPrefOrderId,10_MAIN_SUPPL(java.lang.String)][supplierProductId,
MAT_A(java.lang.String)][supplierProductName,Material A(java.lang.String)] (SQL Exception while executing the following:INSERT INTO
OFBIZ.SUPPLIER_PRODUCT (PRODUCT_ID, PARTY_ID, AVAILABLE_FROM_DATE, AVAILABLE
_THRU_DATE, SUPPLIER_PREF_ORDER_ID, SUPPLIER_RATING_TYPE_ID, STANDARD_LEAD_TIME_DAYS, MINIMUM_ORDER_QUANTITY, ORDER_QTY_INCREMENTS,
UNITS_INCLUDED, QUANTITY_UOM_ID, LAST_PRICE, CURRENCY_UOM_ID, SUPPLIER_PRODU
CT_NAME, SUPPLIER_PRODUCT_ID, CAN_DROP_SHIP, SUPPLIER_COMMISSION_PERC, COMMENTS, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP,
CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?
, ?, ?, ?, ?, ?, ?, ?) (INSERT sur la table 'SUPPLIER_PRODUCT' a entran la violation de la contrainte de cl externe
'SUPPL_PROD_PARTY' pour la cl (DemoSupplier). L'instruction a t annule.))). Rolling b
ack transaction.

No time to look at it yet...

Jacques

[Jacques Le Roux]

Sorry for duplication an error from my SMTP provider

Jacques