Hi all, I tried to assign a party as a "vendor" to a catalog using "Add Product Catalog Parties" under "catalog > parties". This is what I get:
The Following Errors Occurred: ERROR: Could not complete the Add ProdCatalog To Party [file:/#:/##/##/ofbiz/ofbiz-trunk/applications/product/script/org/ofbiz/product/catalog/CatalogServices.xml#addProdCatalogToParty] process [problem creating the newEntity value: Error while inserting: [GenericEntity:ProdCatalogRole][createdStamp,2009-10-11 16:19:50.484(java.sql.Timestamp)][createdTxStamp,2009-10-11 16:19:50.421(java.sql.Timestamp)][fromDate,2009-10-11 16:19:50.484(java.sql.Timestamp)][lastUpdatedStamp,2009-10-11 16:19:50.484(java.sql.Timestamp)][lastUpdatedTxStamp,2009-10-11 16:19:50.421(java.sql.Timestamp)][partyId,10011(java.lang.String)][prodCatalogId,pixelfiles_fotos(java.lang.String)][roleTypeId,VENDOR(java.lang.String)][sequenceNum,null()][thruDate,null()] (SQL Exception while executing the following:INSERT INTO OFBIZ.PROD_CATALOG_ROLE (PARTY_ID, ROLE_TYPE_ID, PROD_CATALOG_ID, FROM_DATE, THRU_DATE, SEQUENCE_NUM, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?) (INSERT on table 'PROD_CATALOG_ROLE' caused a violation of foreign key constraint 'PCATRLE_PTYRLE' for key (10011,VENDOR). The statement has been rolled back.))] Can anyone help? Thanks in advance. Alexander -- View this message in context: http://www.nabble.com/Assigning-Party-to-catalog-tp25843806p25843806.html Sent from the OFBiz - User mailing list archive at Nabble.com.
