Error: Data could not be saved. The UPDATE statement conflicted with the CHECK constraint "CK_INTERACTION_ISADDITIONALFUNDRAISER". The conflict occurred in database "[database name]", table "dbo.INTERACTION" - when merging duplicate records

When merging records that have prospect data included you may encounter an error message that prevents the merge from completing successfully:

Data could not be saved. The UPDATE statement conflicted with the CHECK constraint "CK_INTERACTION_ISADDITIONALFUNDRAISER". The conflict occurred in database "[database name]", table "dbo.INTERACTION"
We're currently evaluating this issue for a fix in a future patch or service pack.  

Steps to Duplicate

1. Go to Constituents > Duplicates> Merge two constituents
2. Choose constituents by lookup IDs
3. Choose the Merge configuration that includes merging prospect data
4. Keep the check box for Deleting the source record marked

Environment

 Blackbaud CRM
 4.0

Was this article helpful?