Error: The UPDATE statement conflicted with the CHECK constraint CK_MEMBERSHIPCARD_VALIDNUMBEROFCARDS - when merging duplicate records

When merging duplicate records, you may receive an error that looks like this and the merge won't process: "The UPDATE statement conflicted with the CHECK constraint "CK_MEMBERSHIPCARD_VALIDNUMBEROFCARDS".The conflict occurred in database "47914_0e89f810-9fe9-4715-ab74-266829aa3c20", table "dbo.MEMBERSHIPCARD", column 'MEMBERID'.

This error is caused when you are trying to merge a constituent with a membership that has more cards than the membership level allows.

Article Number: 92053

Products:

Altru_Arts_Cultural

To correct this error, you have two options:

Option 1: Increase the number of cards allowed on the membership level before merging

Go to Memberships and click on the hyperlinked name of your membership program
Go to the Levels or Terms and Levels Tab
Click Edit to Edit the Levels
Change the number of cards allowed to the number that exists on the duplicate record.
Click Save
Process the merge again.

Option 2: Delete one of the member cards on the membership so that it does not exceed the number of cards allowed.

Go to the Constituent Record
Go to the Member Tab
Click on the hyperlinked name of the membership program to go to the constituent's membership record
Under Member Cards, click the drop down arrow beside one of the cards. Click Delete.
Process the merge again.

Blackbaud Community

Connect and collaborate with fellow Blackbaud users.

Chat with Support

Chat with our experienced staff to receive help right away.

Connect

The Blackbaud team is online and ready to connect with you!