Ejaz Ahmed created OFBIZ-5924: --------------------------------- Summary: 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 Reporter: Ejaz Ahmed
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)