[ https://issues.apache.org/jira/browse/OFBIZ-5924?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Nicolas Malin resolved OFBIZ-5924. ---------------------------------- Resolution: Not a Problem Hello Ejaz The error message is a foreign key because you need add the role to your party before associate on the catalog. A screen improvement would be interested to list only the role associate to the party, and all contribution on this way will be appreciate ;) > Error message thrown during assigning party roles in catalog manager needs > some clarity > --------------------------------------------------------------------------------------- > > Key: OFBIZ-5924 > URL: https://issues.apache.org/jira/browse/OFBIZ-5924 > Project: OFBiz > Issue Type: Improvement > Components: product > Affects Versions: Trunk > Reporter: Ejaz Ahmed > Assignee: Nicolas Malin > > When we assign a party role for a particular party in Catalog manager for a > particular party, following error message appears: > {code} > The Following Errors Occurred: > Exception thrown while creating the "newEntity" GenericValue: > org.ofbiz.entity.GenericEntityException: Error while inserting: > [GenericEntity:ProdCatalogRole][createdStamp,2014-12-22 > 19:30:57.557(java.sql.Timestamp)][createdTxStamp,2014-12-22 > 19:30:57.516(java.sql.Timestamp)][fromDate,2014-12-22 > 19:30:57.557(java.sql.Timestamp)][lastUpdatedStamp,2014-12-22 > 19:30:57.557(java.sql.Timestamp)][lastUpdatedTxStamp,2014-12-22 > 19:30:57.516(java.sql.Timestamp)][partyId,BLOG_ADMIN(java.lang.String)][prodCatalogId,EATestCatalog(java.lang.String)][roleTypeId,BUYER(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 (BLOG_ADMIN,BUYER). The statement has > been rolled back.)) (Error while inserting: > [GenericEntity:ProdCatalogRole][createdStamp,2014-12-22 > 19:30:57.557(java.sql.Timestamp)][createdTxStamp,2014-12-22 > 19:30:57.516(java.sql.Timestamp)][fromDate,2014-12-22 > 19:30:57.557(java.sql.Timestamp)][lastUpdatedStamp,2014-12-22 > 19:30:57.557(java.sql.Timestamp)][lastUpdatedTxStamp,2014-12-22 > 19:30:57.516(java.sql.Timestamp)][partyId,BLOG_ADMIN(java.lang.String)][prodCatalogId,EATestCatalog(java.lang.String)][roleTypeId,BUYER(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 (BLOG_ADMIN,BUYER). The statement has > been rolled back.))) > {code} > This was generated by attempting to assign Buyer role to blog admin for a > test catalog. The actual constraint is that Blog admin first should have role > defined as Buyer before being assigned this role for a catalog. The error > message shown above should have this particular information or a warning must > be there as UiLabel to warn that the role being assigned here must be defined > for a particular pary in party manager. -- This message was sent by Atlassian JIRA (v6.3.4#6332)