Hi Alexander,
I suppose that you get this error because the party that you are
trying to associate to pixelfiles_fotos catalog is missing Vendor
role. You have to add this role to the party before you try to assign
it to the catalog.
Go to party profile and assign Vendor role to it.
https://demo.ofbiz.org/partymgr/control/viewroles?partyId=10011
Regards,
Rashko Rejmer
On 11 Oct 2009, at 17:24, Alexander1893 wrote:
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.
