Error: The UPDATE statement conflicted with the CHECK constraint “CK_ADDRESS_PRIMARYCOUNT”. The conflict occurred in database “[DATABASE NAME]”. Table “dbo.ADDRESS” - when committing a Constituent Address Update Batch

When using a Constituent Address Update Batch to update a constituent's address, upon committing the batch, users may receive the error:

The UPDATE statement conflicted with the CHECK constraint “CK_ADDRESS_PRIMARYCOUNT”. The conflict occurred in database “[DATABASE NAME]”. Table “dbo.ADDRESS”.
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

 2.94 Patch 52
 3.0.516, Service Pack 2 ; 2.94.1524, patch 70 ; 2.91.1535, patch 117

Was this article helpful?