[OFBIZ-7249] Error on removing scrum members

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Affects Version/s: Release Branch 14.12, Release Branch 15.12, Trunk
• Fix Version/s: 17.12.05, 18.12.01
• Component/s: scrum
• Sprint: Community Day 2 - 2016
• Assignee: Akash Jain
• Reporter: Anurag Chandak
• Created: 08/Jun/16 13:19
• Updated: 01/Sep/20 09:53
• Resolved: 01/Sep/20 09:53

Description

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:

  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.)))