You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@ofbiz.apache.org by Mansour Al Akeel <ma...@gmail.com> on 2010/08/30 16:26:56 UTC
Error at "Associate Party to Product" screen
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 ?
Re: Error at "Associate Party to Product" screen
Posted by Mansour Al Akeel <ma...@gmail.com>.
Jacques:
I thought about it.
This question has been answered, and I mentioned this, and thanked you
for it. Another question here, has no answer yet, and no documentaion
related to it !
The question can be found here:
http://markmail.org/thread/2riretiltgvl6dtg
On Tue Aug 31,2010 02:37 pm, Jacques Le Roux wrote:
> 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" <ma...@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" <ma...@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"<ma...@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 ?
> >>>>>>>
> >>>>>>>
> >>>>>>
> >>>>>>
> >>>>>
> >>>>
> >>>
> >>
> >>
> >
>
>
Re: Error at "Associate Party to Product" screen
Posted by Jacques Le Roux <ja...@les7arts.com>.
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" <ma...@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" <ma...@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"<ma...@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 ?
>> >>>>>
>> >>>>>
>> >>>>
>> >>>>
>> >>>
>> >>
>> >
>>
>>
>
Re: Error at "Associate Party to Product" screen
Posted by Mansour Al Akeel <ma...@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" <ma...@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"<ma...@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 ?
> >>>>>
> >>>>>
> >>>>
> >>>>
> >>>
> >>
> >
>
>
Re: Error at "Associate Party to Product" screen
Posted by Jacques Le Roux <ja...@les7arts.com>.
Actually the official site is (unsurprinsingly) http://ofbiz.apache.org/
Just try ofbiz in google...
Jacques
From: "Mansour Al Akeel" <ma...@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"<ma...@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 ?
>> >>>
>> >>>
>> >>
>> >>
>> >
>>
>
Re: Error at "Associate Party to Product" screen
Posted by Mansour Al Akeel <ma...@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"<ma...@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 ?
> >>>
> >>>
> >>
> >>
> >
>
Re: Error at "Associate Party to Product" screen
Posted by BJ Freeman <bj...@free-man.net>.
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"<ma...@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 ?
>>>
>>>
>>
>>
>
Re: Error at "Associate Party to Product" screen
Posted by Mansour Al Akeel <ma...@gmail.com>.
I tried it and it worked. Thank you.
Is there a way to filter parties based on the role, to avoid this error
message ?
On Mon Aug 30,2010 05:38 pm, Jacques Le Roux wrote:
> Not sure which domain is https://demo-trunk.businessesnetwork.com/
> This depends of the party and his/her/its roles. For instance it works for DemoCustomer and Bill-To Customer
> So you have to set before the role you want to use, for the party you select...
>
> Jacques
> PS : ha yes got it, businessesnetwork is BJ's domain :o)
>
> From: "Mansour Al Akeel" <ma...@gmail.com>
> >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" <ma...@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 ?
> >>>
> >>>
> >>
> >>
> >
>
>
Re: Error at "Associate Party to Product" screen
Posted by Jacques Le Roux <ja...@les7arts.com>.
Not sure which domain is https://demo-trunk.businessesnetwork.com/
This depends of the party and his/her/its roles. For instance it works for DemoCustomer and Bill-To Customer
So you have to set before the role you want to use, for the party you select...
Jacques
PS : ha yes got it, businessesnetwork is BJ's domain :o)
From: "Mansour Al Akeel" <ma...@gmail.com>
> 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" <ma...@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 ?
>> >
>> >
>>
>>
>
Re: Error at "Associate Party to Product" screen
Posted by Mansour Al Akeel <ma...@gmail.com>.
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" <ma...@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 ?
> >
> >
>
>
Re: Error at "Associate Party to Product" screen
Posted by Jacques Le Roux <ja...@les7arts.com>.
Do you reproduce on demo server?
Jacques
From: "Mansour Al Akeel" <ma...@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 ?
>
>