Error: "The update statement conflicted with the CHECK constraint 'CK_RELATIONSHIPJOBINFO_ISUNIQUE'. The conflict occurred in database '[name]', table 'dbo.RELATIONSHIPJOBINFO'" - When merging constituents

When merging two constituents, you might encounter the error, "Data could not be saved. The update statement conflicted with the CHECK constraint 'CK_RELATIONSHIPJOBINFO_ISUNIQUE'. The conflict occurred in database '[name]', table 'dbo.RELATIONSHIPJOBINFO'".
This error is caused by both constituents having a relationship with the same organization. Try deleting the relationship from either the source or the target constituent then attempting the merge again.

Steps to Duplicate

1) Go to Constituents > Duplicates > Merge two constituents
2) Fill out the form then click Merge
3) Encounter the error "Data could not be saved. The update statement conflicted with the CHECK constraint 'CK_RELATIONSHIPJOBINFO_ISUNIQUE'. The conflict occurred in database '[name]', table 'dbo.RELATIONSHIPJOBINFO'"

Was this article helpful?