Assigning Party to catalog

[Alexander1893]

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

[Rashko Rejmer]

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.
>