You are viewing a plain text version of this content. The canonical link for it is here.

Posted to user@ofbiz.apache.org by Alexander1893 <al...@familie-schweizer.net> on 2009/10/11 16:24:01 UTC

Assigning Party to catalog

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.

Re: Assigning Party to catalog

Posted by Rashko Rejmer <rr...@iguanait.com>.

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