Error Merging Two Constituents

Alexa WhiteRayborn

I'm getting this error message when I try to merge this specific duplicate constituent pair.

I've been able to merge every other duplicate constituent pair without any issue, either through the auto merge or the manual, and this one won't work either way.

Anyone know what the problem might be? Or what the “check constraint” “database 50807” and “table dbo.REGISTRANT” are even referring to?

Amy Barker

@Alexa WhiteRayborn they are probably both registered for the same event.

Here's a knowledgebase article about a similar issue that talks about the fix.
Error: Data could not be saved. The UPDATE statement conflicted with the CHECK constraint "CK_REGISTRANT_VALIDWILLNOTATTEND". The conflict occurred in database "XXX", table "dbo.REGISTRANT" - when merging two constituents (blackbaud.com)

Joe Killian

@Alexa WhiteRayborn

Amy Barker's post is on the nose. One quick fix you can try is simply swap the Target and Source.