[jira] [Commented] (OFBIZ-7249) Error on removing scrum members

[Nicolas Malin (Jira)]

    [ https://issues.apache.org/jira/browse/OFBIZ-7249?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17188326#comment-17188326 ]

ASF subversion and git services commented on OFBIZ-7249:
--------------------------------------------------------

Commit 39494e6a5720535328ae1809ec6e7aed0a370e8d in ofbiz-plugins's branch refs/heads/release17.12 from Akash Jain
[ https://gitbox.apache.org/repos/asf?p=ofbiz-plugins.git;h=39494e6 ]

Fixed: Error on removing scrum members (OFBIZ-7249)

Thanks, Anurag Chandak for report.

> Error on removing scrum members
> -------------------------------
>
>                 Key: OFBIZ-7249
>                 URL: https://issues.apache.org/jira/browse/OFBIZ-7249
>             Project: OFBiz
>          Issue Type: Bug
>          Components: scrum
>    Affects Versions: Release Branch 14.12, Release Branch 15.12, Trunk
>            Reporter: Anurag Chandak
>            Assignee: Akash Jain
>            Priority: Major
>         Attachments: OFBIZ-7249.patch, OFBIZ-7249.patch
>
>
> Steps to regenerate:
> - Go to Scrum --> Administration --> Scrum Members
> - Try to remove only those scrum members whose party and role type are similar to product members
> - The following error is shown:
> {code}
> The Following Errors Occurred:
> Error:Error doing entity-auto operation for entity PartyRole in service deletePartyRole: org.ofbiz.entity.GenericEntityException: org.ofbiz.entity.GenericDataSourceException: Exception while deleting the following entity: [GenericEntity:PartyRole][partyId,SCRUMASTER(java.lang.String)][roleTypeId,SCRUM_MASTER(java.lang.String)] (SQL Exception while executing the following:DELETE FROM OFBIZ.PARTY_ROLE WHERE PARTY_ID=? AND ROLE_TYPE_ID=? (DELETE on table 'PARTY_ROLE' caused a violation of foreign key constraint 'PROD_RLE_PTYRLE' for key (SCRUMASTER,SCRUM_MASTER). The statement has been rolled back.)) (Exception while deleting the following entity: [GenericEntity:PartyRole][partyId,SCRUMASTER(java.lang.String)][roleTypeId,SCRUM_MASTER(java.lang.String)] (SQL Exception while executing the following:DELETE FROM OFBIZ.PARTY_ROLE WHERE PARTY_ID=? AND ROLE_TYPE_ID=? (DELETE on table 'PARTY_ROLE' caused a violation of foreign key constraint 'PROD_RLE_PTYRLE' for key (SCRUMASTER,SCRUM_MASTER). The statement has been rolled back.)))
> {code}

--
This message was sent by Atlassian Jira
(v8.3.4#803005)