Error loading Data
Posted by Jacques Le Roux on
URL: http://ofbiz.116.s1.nabble.com/Error-loading-Data-tp141670.html
I have noticed some errors while loading data (run-instal). I don't know if it's related with my DB configuration (PostGres 8.1 UTF8
on XP) because on Ubuntu 5.1 with Postgres 7.4 UNICODE I have not these problems.
Or perhpas I need to install hot-deploy or specialised applications (DemoCustCompany seems missing) ?
Here they are. If needed I may copy a complete log.
[...]
[java] 2006-09-04 17:17:59,906 (main) [ GenericDelegator.java:579:ERROR]
[java] ---- exception report ----------------------------------------------------------
[java] Failure in create operation for entity [AgreementItem]: org.ofbiz.entity.GenericEntityException: Exception while
inserting the following entity: [GenericEntity:AgreementItem][agreementId,9000(java
.lang.String)][agreementItemSeqId,0001(java.lang.String)][agreementItemTypeId,AGREEMENT_COMMISSION(java.lang.String)][agreementText,
Commission in USD(java.lang.String)][createdStamp,2006-09-04 17:17:59.843(ja
va.sql.Timestamp)][createdTxStamp,2006-09-04
17:17:59.562(java.sql.Timestamp)][currencyUomId,USD(java.lang.String)][lastUpdatedStamp,2006-09-04
17:17:59.843(java.sql.Timestamp)][lastUpdatedTxStamp,2006-09-04
17:17:59.562(java.sql.Timestamp)] (while inserting:
[GenericEntity:AgreementItem][agreementId,9000(java.lang.String)][agreementItemSeqId,0001(java.lang.String)][agreementItemTypeId,AGR
EEMENT_COMMISSION(java.l
ang.String)][agreementText,Commission in USD(java.lang.String)][createdStamp,2006-09-04
17:17:59.843(java.sql.Timestamp)][createdTxStamp,2006-09-04 17:17:59.562(java.sql.Timestamp)][currencyUomId,USD(java.lan
g.String)][lastUpdatedStamp,2006-09-04 17:17:59.843(java.sql.Timestamp)][lastUpdatedTxStamp,2006-09-04
17:17:59.562(java.sql.Timestamp)] (SQL Exception while executing the following:INSERT INTO public.AGREEME
NT_ITEM (AGREEMENT_ID, AGREEMENT_ITEM_SEQ_ID, AGREEMENT_ITEM_TYPE_ID, CURRENCY_UOM_ID, AGREEMENT_TEXT, AGREEMENT_IMAGE,
LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?
, ?, ?, ?, ?, ?, ?, ?, ?) (ERROR: column "agreement_image" is of type bytea but expression is of type oid))). Rolling back
transaction.
[java] Exception: org.ofbiz.entity.GenericEntityException
[...]
[java] ---- exception report ----------------------------------------------------------
[java] Failure in create operation for entity [ContactListParty]: org.ofbiz.entity.GenericEntityException: Exception while
inserting the following entity: [GenericEntity:ContactListParty][contactListId,9
000(java.lang.String)][createdStamp,2006-09-04 17:18:00.453(java.sql.Timestamp)][createdTxStamp,2006-09-04
17:18:00.093(java.sql.Timestamp)][fromDate,2001-05-13 00:00:00.0(java.sql.Timestamp)][lastUpdatedStam
p,2006-09-04 17:18:00.453(java.sql.Timestamp)][lastUpdatedTxStamp,2006-09-04
17:18:00.093(java.sql.Timestamp)][partyId,DemoCustCompany(java.lang.String)][preferredContactMechId,9021(java.lang.String)][statusI
d,CLPT_ACCEPTED(java.lang.String)] (while inserting:
[GenericEntity:ContactListParty][contactListId,9000(java.lang.String)][createdStamp,2006-09-04
17:18:00.453(java.sql.Timestamp)][createdTxStamp,2006-09-04
17:18:00.093(java.sql.Timestamp)][fromDate,2001-05-13 00:00:00.0(java.sql.Timestamp)][lastUpdatedStamp,2006-09-04
17:18:00.453(java.sql.Timestamp)][lastUpdatedTxStamp,2006-09-04 17:18:00.093(java.sql.Timestam
p)][partyId,DemoCustCompany(java.lang.String)][preferredContactMechId,9021(java.lang.String)][statusId,CLPT_ACCEPTED(java.lang.Strin
g)] (SQL Exception while executing the following:INSERT INTO public.CONTACT_
LIST_PARTY (CONTACT_LIST_ID, PARTY_ID, FROM_DATE, THRU_DATE, STATUS_ID, PREFERRED_CONTACT_MECH_ID, LAST_UPDATED_STAMP,
LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?
, ?) (ERROR: insert or update on table "contact_list_party" violates foreign key constraint "cnct_lstpty_pty"
[java] Dtail: Key (party_id)=(DemoCustCompany) is not present in table "party".))). Rolling back transaction.
[java] Exception: org.ofbiz.entity.GenericEntityException
[...]
[java] ---- exception report ----------------------------------------------------------
[java] [install.loadData]: Error loading XML Resource
"file:/D:/WorkspaceNew/ofbiz/applications/ecommerce/data/DemoMarketing.xml"; Error was: A transaction error occurred reading data
[java] Exception: org.xml.sax.SAXException
[java] Message: A transaction error occurred reading data
[java] ---- stack trace ---------------------------------------------------------------
[java] org.ofbiz.entity.GenericEntityException: Exception while inserting the following entity:
[GenericEntity:ContactListParty][contactListId,9000(java.lang.String)][createdStamp,2006-09-04 17:18:00.453
(java.sql.Timestamp)][createdTxStamp,2006-09-04 17:18:00.093(java.sql.Timestamp)][fromDate,2001-05-13
00:00:00.0(java.sql.Timestamp)][lastUpdatedStamp,2006-09-04 17:18:00.453(java.sql.Timestamp)][lastUpdatedT
xStamp,2006-09-04
17:18:00.093(java.sql.Timestamp)][partyId,DemoCustCompany(java.lang.String)][preferredContactMechId,9021(java.lang.String)][statusId
,CLPT_ACCEPTED(java.lang.String)] (while inserting: [Gener
icEntity:ContactListParty][contactListId,9000(java.lang.String)][createdStamp,2006-09-04
17:18:00.453(java.sql.Timestamp)][createdTxStamp,2006-09-04 17:18:00.093(java.sql.Timestamp)][fromDate,2001-05-13 00:00
:00.0(java.sql.Timestamp)][lastUpdatedStamp,2006-09-04 17:18:00.453(java.sql.Timestamp)][lastUpdatedTxStamp,2006-09-04
17:18:00.093(java.sql.Timestamp)][partyId,DemoCustCompany(java.lang.String)][preferredCon
tactMechId,9021(java.lang.String)][statusId,CLPT_ACCEPTED(java.lang.String)] (SQL Exception while executing the following:INSERT
INTO public.CONTACT_LIST_PARTY (CONTACT_LIST_ID, PARTY_ID, FROM_DATE, THRU_DATE
, STATUS_ID, PREFERRED_CONTACT_MECH_ID, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?, ?,
?, ?, ?, ?, ?, ?, ?) (ERROR: insert or update on table "contact_list_party"
violates foreign key constraint "cnct_lstpty_pty"
[java] Dtail: Key (party_id)=(DemoCustCompany) is not present in table "party".)))
[...]
[java] 2006-09-04 17:18:03,546 (main) [EntityDataLoadContainer.java:271:INFO ] [install.loadData]: Error loading XML Resource
"file:/D:/WorkspaceNew/ofbiz/applications/ecommerce/data/DemoOrderPeopleData.
xml"; Error was: A transaction error occurred reading data
[java] 2006-09-04 17:18:03,546 (main) [EntityDataLoadContainer.java:271:INFO ] [install.loadData]: Error loading XML Resource
"file:/D:/WorkspaceNew/ofbiz/applications/ecommerce/data/DemoMarketing.xml";
Error was: A transaction error occurred reading data
[java] 2006-09-04 17:18:03,546 (main) [EntityDataLoadContainer.java:271:INFO ] [install.loadData]: Error loading XML Resource
"file:/D:/WorkspaceNew/ofbiz/applications/ecommerce/data/DemoPurchasing.xml";
Error was: A transaction error occurred reading data
[java] 2006-09-04 17:18:03,546 (main) [EntityDataLoadContainer.java:275:INFO ] =-=-=-=-=-=-= Finished the data load with 7389
rows changed.
Thanks
Jacques