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 ? |
Administrator
|
Do you reproduce on demo server?
Jacques From: "Mansour Al Akeel" <[hidden email]> > 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 ? > > |
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" <[hidden email]> > >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 ? > > > > > > |
Administrator
|
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" <[hidden email]> > 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" <[hidden email]> >> >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 ? >> > >> > >> >> > |
In reply to this post by Mansour
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"<[hidden email]> >>> 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 ? >>> >>> >> >> > |
In reply to this post by Jacques Le Roux
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" <[hidden email]> > >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" <[hidden email]> > >>>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 ? > >>> > >>> > >> > >> > > > > |
In reply to this post by BJ Freeman
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"<[hidden email]> > >>>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 ? > >>> > >>> > >> > >> > > > |
Administrator
|
Actually the official site is (unsurprinsingly) http://ofbiz.apache.org/
Just try ofbiz in google... Jacques From: "Mansour Al Akeel" <[hidden email]> > 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"<[hidden email]> >> >>>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 ? >> >>> >> >>> >> >> >> >> >> > >> > |
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" <[hidden email]> > >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"<[hidden email]> > >>>>>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 ? > >>>>> > >>>>> > >>>> > >>>> > >>> > >> > > > > |
Administrator
|
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" <[hidden email]> > 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" <[hidden email]> >> >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"<[hidden email]> >> >>>>>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 ? >> >>>>> >> >>>>> >> >>>> >> >>>> >> >>> >> >> >> > >> >> > |
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" <[hidden email]> > >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" <[hidden email]> > >>>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"<[hidden email]> > >>>>>>>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 ? > >>>>>>> > >>>>>>> > >>>>>> > >>>>>> > >>>>> > >>>> > >>> > >> > >> > > > > |
Free forum by Nabble | Edit this page |