[
https://issues.apache.org/jira/browse/OFBIZ-7249?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15322218#comment-15322218
]
Jacques Le Roux commented on OFBIZ-7249:
----------------------------------------
I think Nicolas pretty summed it up, notably for audit reasons it's always
better to keep data in DBs...
> 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)
