Error: Cannot insert duplicate key row in object 'dbo.SPONSORSHIPCOMMITMENT' with unique index 'UIX_SPONSORSHIPCOMMITMENT_CONSTITUENTID_COMMITMENTSEQUENCE'. - when merging records with sponsorship's

When merging two constituents that contain sponsorship's users have found that the out of box code is throwing the following error: 
Data could not be saved. Cannot insert duplicate key row in object 'dbo.SPONSORSHIPCOMMITMENT' with unique index 'UIX_SPONSORSHIPCOMMITMENT_CONSTITUENTID_COMMITMENTSEQUENCE'.
We're currently evaluating this issue for a fix in a future patch or service pack.
 

Steps to Duplicate

1. Navigate to the Constituents functional area.
2. Click the Merge two constituents process. 
3. Enter the Source and Target Constituents: 
4. Click 'Delete source constituent'.
5. Click Merge. 
6: Note, users receive the following error: 
Data could not be saved. Cannot insert duplicate key row in object 'dbo.SPONSORSHIPCOMMITMENT' with unique index 'UIX_SPONSORSHIPCOMMITMENT_CONSTITUENTID_COMMITMENTSEQUENCE

Environment

 Blackbaud CRM
 4.0
 4.0.172.0

Was this article helpful?