Hi,
I'm customizing, acutally, an OFBiz ecommerce site. For my specific needs, I
want to associates Categories and products with parties. Basically, I add a
party like customerA (partyId = 10000) and I want that this customer can only
visualize (and buy) the categories and products which are associated to him.
I saw that in the Catalog Manager Application when I browsed my categories and
click on one, there is a parties menu. I thought that can do my need but when I
want to associate party to category (I select customer for the type), I had
this error :
The Following Errors Occurred:
ERROR:
Could not complete the Add Party to Category
[file:/C:/Projets_Eclipse/ofbiz-mars/applications/product/script/org/ofbiz/product/category/CategoryServices.xml#addPartyToCategory]
process [problem creating the newEntity value: Error while inserting:
[GenericEntity:ProductCategoryRole][createdStamp,2008-07-17
14:25:46.005(java.sql.Timestamp)][createdTxStamp,2008-07-17
14:25:44.453(java.sql.Timestamp)][fromDate,2008-07-17
14:25:46.005(java.sql.Timestamp)][lastUpdatedStamp,2008-07-17
14:25:46.005(java.sql.Timestamp)][lastUpdatedTxStamp,2008-07-17
14:25:44.453(java.sql.Timestamp)][partyId,10000(java.lang.String)][productCategoryId,snackfood_fr(java.lang.String)][roleTypeId,CUSTOMER(java.lang.String)]
(SQL Exception while executing the following:INSERT INTO
OFBIZ.PRODUCT_CATEGORY_ROLE (PRODUCT_CATEGORY_ID, PARTY_ID,
ROLE_TYPE_ID, FROM_DATE, THRU_DATE, COMMENTS, LAST_UPDATED_STAMP,
LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?,
?, ?, ?, ?, ?, ?, ?, ?) (INSERT on table 'PRODUCT_CATEGORY_ROLE' caused
a violation of foreign key constraint 'PROD_CRLE_PTYRLE' for key
(10000,CUSTOMER). The statement has been rolled back.))]
Did I forgot something to do this association betwwen my categories and parties
?
Regards,
Amine
_________________________________________________________________
Votre correspondant a choisi Hotmail, un e-mail ultra sécurisé. Créez le votre
gratuitement !
http://www.windowslive.fr/hotmail/default.asp
