Error: The UPDATE statement conflicted with the CHECK constraint CK_ADDRESS_FORMERADDRESSCANNOTBEPRIMARY". The conflict occurred in database "xxxx", table "dbo.ADDRESS"."

When committing an AddressFinder update, the following error message is received on some of the records

Error The UPDATE statement conflicted with the CHECK constraint "CK_ADDRESS_FORMERADDRESSCANNOTBEPRIMARY". 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

 4.0.138, patch 2 ; 3.0.516, Service Pack 10

Was this article helpful?