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)
