BJ: Thank you for the pointer. I will start using the official demo site.
On Mon Aug 30,2010 09:08 am, BJ Freeman wrote: > > 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 ? > >>> > >>> > >> > >> > > >
