Re: Error at "Associate Party to Product" screen

[Jacques Le Roux]

I think I answered it here http://markmail.org/message/lrqpjig32xayli76
Then you have to think a bit about it...

Jacques

From: "Mansour Al Akeel" <mansour.alak...@gmail.com>

Coooool advice.
But the main issue has nothing to do with how to use google. A simple
missunderstanding about which demo is the official one, doens't imply the
lack of the skills of how to use google.

It would be more helpful to the community , if I got an answer to the
unanswered question.

Thank you for the advice anyway!


On Mon Aug 30,2010 07:13 pm, Jacques Le Roux wrote:

Actually the official site is (unsurprinsingly) http://ofbiz.apache.org/
Just try ofbiz in google...

Jacques

From: "Mansour Al Akeel" <mansour.alak...@gmail.com>
>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.alak...@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 ?
>>>>>
>>>>>
>>>>
>>>>
>>>
>>
>