ofbiz-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Mansour Al Akeel <mansour.alak...@gmail.com>
Subject Re: Error at "Associate Party to Product" screen
Date Mon, 30 Aug 2010 16:47:34 GMT
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"<mansour.alakeel@gmail.com>
> >>>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 ?
> >>>
> >>>
> >>
> >>
> >
> 

Mime
View raw message