[jira] [Created] (OFBIZ-5924) Error message thrown during assigning party roles in catalog manager needs some clarity

[Nicolas Malin (Jira)]

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)