Error when Merging two constituents

Error: Data could not be saved.
The UPDATE statement conflicted with the CHECK constraint "CK_GROUPMEMBER_PRIMARYCOUNT". The conflict occurred in database...table "dbo.GROUPMEMBER".
Committable transaction is detected at the end of the batch. The transaction is rolled back.
 
The records are unable to merge without correcting the issue because the records are converted.
To correct the issue.
1. Select the Relationships tab on the constituent record
2. Then select Group Member (notice the current group memberships)
3. Select the Group
4. Select the Members
5. Remove the membership and the history for the member that is not primary
6. Then merge the constituent records
 

Steps to Duplicate

This error occurs when merging constituents in batch or through the duplicate constituent merge in CRM.

Environment

 Blackbaud CRM
 4.0

Was this article helpful?