[jira] [Updated] (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:all-tabpanel ]

Anurag Chandak updated OFBIZ-7249:
----------------------------------
    Attachment: OFBIZ-7249.patch

I am attaching the patch which removes the product role first and then deletes party role for avoiding this error.

Not sure whether we have to delete product role or not, before deleting party role, may be any best solution exists for this.

> Error on removing scrum members
> -------------------------------
>
>                 Key: OFBIZ-7249
>                 URL: https://issues.apache.org/jira/browse/OFBIZ-7249
>             Project: OFBiz
>          Issue Type: Bug
>          Components: specialpurpose/scrum
>    Affects Versions: Release Branch 13.07, Release Branch 14.12, Trunk, Release Branch 15.12
>            Reporter: Anurag Chandak
>            Assignee: Anurag Chandak
>             Fix For: Upcoming Branch
>
>         Attachments: 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
(v6.3.4#6332)