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 ?
