[
https://issues.apache.org/jira/browse/OFBIZ-5924?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15105235#comment-15105235
]
Jacques Le Roux commented on OFBIZ-5924:
----------------------------------------
Bump!
> 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
> Priority: Minor
>
> 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)
