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:

Blackbaud_Altru

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.

Was this article helpful?

Thanks for your feedback! Did this solve your issue?

Comments (optional):

Thanks for your feedback!

We're glad it was helpful but sorry it didn’t solve your issue. If you need assistance, click Chat with Support below.

We’re sorry to hear that. Please tell us why.

I don't like how this works.

The answer is confusing.

The answer didn't match what I was searching for.

Additional Comments (optional):

Thanks for your feedback! If you need assistance, click Chat with Support below.

Thanks for your feedback. Help us make our products even better by sharing details in our Idea Banks or our online Community.

Thanks for letting us know. We'll work on clarifying the information in the article. If you need assistance, click Chat with Support below.

Thanks for letting us know. We'll work on updating the search engine to return more relevant results.

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!