OFBiz › OFBiz - User

Error loading Data

‹ Previous Topic Next Topic ›
 
classic Classic list List threaded Threaded
♦
♦
 3 messages Options
Jacques Le Roux
Reply | Threaded
Open this post in threaded view
♦
♦
|

Error loading Data

Jacques Le Roux
Administrator
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

David E Jones-2
Reply | Threaded
Open this post in threaded view
♦
♦
|

Re: Error loading Data

David E Jones-2

Which version/revision of OFBiz are you using? This was fixed just a  
few weeks ago, and is done through a new attribute on the datasource  
entry in the entityengine.xml file, which should be set as:

use-binary-type-for-blob="true"

It is in there by default for the localpostgres datasource if you  
have the version that supports this.

-David


On Sep 4, 2006, at 1:52 PM, Jacques Le Roux wrote:

> 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
>

Jacques Le Roux
Reply | Threaded
Open this post in threaded view
♦
♦
|

Re: Error loading Data

Jacques Le Roux
Administrator
Thanks David,

I had an error in my entityEngine indeed. I suspect a merge but I'm not sure.

I got this

            result-fetch-size="50">
            use-binary-type-for-blob="true">
            <!-- use this attribute to make the EntityListIterator more effective for pgjdbc 7.5devel and later:
                result-fetch-size="50"
            -->
            result-fetch-size="50"

in place of that

            use-binary-type-for-blob="true">
            <!-- use this attribute to make the EntityListIterator more effective for pgjdbc 7.5devel and later:
                result-fetch-size="50"
            -->

And I have only added by hand the last line in the first block, weird...

BTW, is that normal that readers in <datasource name="localderbyodbc" section are not there anymore ?

Jacques
   

>
> Which version/revision of OFBiz are you using? This was fixed just a  
> few weeks ago, and is done through a new attribute on the datasource  
> entry in the entityengine.xml file, which should be set as:
>
> use-binary-type-for-blob="true"
>
> It is in there by default for the localpostgres datasource if you  
> have the version that supports this.
>
> -David
>
>
> On Sep 4, 2006, at 1:52 PM, Jacques Le Roux wrote:
>
> > 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
> >
Free forum by Nabble Edit this page