Error: The UPDATE statement conflicted with the CHECK constraint "CK_BATCHMEMBERSHIPDUES_VALIDEXPIRATION". The conflict occurred in database "21227P_bb4d3a2b-97f0-4c6d-98d4-5525ad2c4927", table "dbo.BATCHMEMBERSHIPDUES" when committing membership batches

Error: The UPDATE statement conflicted with the CHECK constraint "CK_BATCHMEMBERSHIPDUES_VALIDEXPIRATION". The conflict occurred in database "21227P_bb4d3a2b-97f0-4c6d-98d4-5525ad2c4927", table "dbo.BATCHMEMBERSHIPDUES" when committing membership batches with transactions that are downloaded from BBIS.  These transactions came from members with existing memberships and the batch will not allow users to change the memberships to a rejoin.   
Download and install the latest patch which contains all fixes from previous patches. If you are running an older version, download and install the latest version and then the patch.

Environment

 Blackbaud CRM
 3.0
 3.0
 Service Pack 13
 3.0.516.69

Was this article helpful?