You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@ofbiz.apache.org by "Nicolas Malin (JIRA)" <ji...@apache.org> on 2015/01/07 22:33:34 UTC
[jira] [Commented] (OFBIZ-5924) Error message thrown during
assigning party roles in catalog manager needs some clarity
[ https://issues.apache.org/jira/browse/OFBIZ-5924?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14268285#comment-14268285 ]
Nicolas Malin commented on OFBIZ-5924:
--------------------------------------
No pb Ejaz,
As said your contribution is welcome ! ;)
> 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)