See exception: The UPDATE statement conflicted with the CHECK constraint CK_PHONE_ENDDATEINVALIDIFPRIMARY". The conflict occurred in database "40733P_e8339591-6685-44d8-ab89-"

When merging constituent records, users see the following errors:

"See exception: The UPDATE statement conflicted with the CHECK constraint "CK_PHONE_ENDDATEINVALIDIFPRIMARY". The conflict occurred in database "40733P_e8339591-6685-44d8-ab89-"

 
"The DELETE statement conflicted with the REFERENCE constraint ""FK_BATCHPHONEFINDER_CONSTITUENTID"". The conflict occurred in database ""40733P_e8339591-6685-44d8-ab89-4e4e3d43335b"", table ""dbo.BATCHPHONEFINDER"", column 'CONSTITUENTID'.
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.1524
 2.94.1524, patch 107

Was this article helpful?