Mansour:
businessesnetwork.com is not the official Demo for ofbiz.
it is not a pure ofbiz demo and has modification. We are working on
a new theme that shows it is different.
demo-trunk.ofbiz.apache.org is the official site
=========================
BJ Freeman <http://bjfreeman.elance.com>
Strategic Power Office with Supplier Automation
<http://www.businessesnetwork.com/automation/viewforum.php?f=52>
Specialtymarket.com <http://www.specialtymarket.com/>
Systems Integrator-- Glad to Assist
Chat Y! messenger: bjfr33man
Mansour Al Akeel sent the following on 8/30/2010 8:13 AM:
>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 ?
>>>
>>>
>>
>>
>
