Re: Error at "Associate Party to Product" screen

Jacques Le Roux Mon, 30 Aug 2010 08:39:02 -0700

Not sure which domain is https://demo-trunk.businessesnetwork.com/
This depends of the party and his/her/its roles. For instance it works for 
DemoCustomer and  Bill-To Customer
So you have to set before the role you want to use, for the party you select...


Jacques
PS : ha yes got it, businessesnetwork is BJ's domain :o)

From: "Mansour Al Akeel" <[email protected]>

Hello Jacques:
Yes, I just tried it and I got the same results on the demo server.
Go to this url and fill the values, to see the error.
https://demo-trunk.businessesnetwork.com/catalog/control/EditProductParties?productId=GZ-BASKET-PICK




On Mon Aug 30,2010 05:06 pm, Jacques Le Roux wrote:

Do you reproduce on demo server?

Jacques

From: "Mansour Al Akeel" <[email protected]>
>When I try to associate a party to a screen, I get this error:
>
>
>The Following Errors Occurred:
>
>ERROR: Could not complete the Add Party to Product
>[file:/home/mansour/workspace/src/ofbiz/applications/product/script/org/ofbiz/product/product/ProductServices.xml#addPartyToProduct]
>process [problem creating the newEntity value: Error while
>inserting: [GenericEntity:ProductRole][comments,test
>association(java.lang.String)][createdStamp,2010-08-30
>17:25:23.522(java.sql.Timestamp)][createdTxStamp,2010-08-30
>17:25:23.476(java.sql.Timestamp)][fromDate,2010-08-01
>17:24:53.799(java.sql.Timestamp)][lastUpdatedStamp,2010-08-30
>17:25:23.522(java.sql.Timestamp)][lastUpdatedTxStamp,2010-08-30
>17:25:23.476(java.sql.Timestamp)][partyId,BigSupplier(java.lang.String)][productId,GZ-BASKET-PICK(java.lang.String)][roleTypeId,ACCOUNT(java.lang.String)][sequenceNum,0(java.lang.Long)][thruDate,2010-08-31
>17:25:01.153(java.sql.Timestamp)] (SQL Exception while executing the
>following:INSERT INTO OFBIZ.PRODUCT_ROLE (PRODUCT_ID, PARTY_ID,
>ROLE_TYPE_ID, FROM_DATE, THRU_DATE, SEQUENCE_NUM, COMMENTS,
>LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP,
>CREATED_TX_STAMP) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) (INSERT
>on table 'PRODUCT_ROLE' caused a violation of foreign key
>constraint
>'PROD_RLE_PTYRLE' for key (BigSupplier,ACCOUNT). The statement has been rolled 
back.))]
>
>
>
>I am not sure what is the reason, and couldn't figure it out. I want to
>add parties to be able to associate a product with a manuffacturer.
>
>Any help ?
>
>

Re: Error at "Associate Party to Product" screen

Reply via email to