Error: Data could not be saved. Cannot insert duplicate key row in object 'dbo.SPONSORSHIPCOMMITMENT' with unique index 'UIX_SPONSORSHIPCOMMITMENT_CONSTITUENTID_COMMITMENTSEQUENCE'. The duplicate key value is (GUID, 1).

When attempting to merge two constituents, a user may receive Error: Data could not be saved.   Cannot insert duplicate key row in object 'dbo.SPONSORSHIPCOMMITMENT' with unique index 'UIX_SPONSORSHIPCOMMITMENT_CONSTITUENTID_COMMITMENTSEQUENCE'. The duplicate key value is (GUID, 1).
We're currently evaluating this issue for a fix in a future patch or service pack.  

Steps to Duplicate

1.  Login to 4.0.
2.  Go to Constituents, Duplicates, Merge Two constituents.
Source Constituent:  ID
Target Constituent:  ID
Merge Configuration:  Default
Delete source constituent
3.  Click Merge.  

Receive Error:  Data could not be saved.  
Cannot insert duplicate key row in object 'dbo.SPONSORSHIPCOMMITMENT' with unique index 'UIX_SPONSORSHIPCOMMITMENT_CONSTITUENTID_COMMITMENTSEQUENCE'. The duplicate key value is (GUID, 1).

Environment

 Blackbaud CRM
 4.0

Was this article helpful?