Error: The UPDATE statement conflicted with the CHECK constraint CK_PHONE_ENDDATEINVALIDIFPRIMARY". The conflict occurred in database "SMP_EC_30", table "dbo.PHONE" when adding a new phone number via batch"

When a phone number is added to a constituent's record via batch they can generate the following Error:  The UPDATE statement conflicted with the CHECK constraint "CK_PHONE_ENDDATEINVALIDIFPRIMARY". The conflict occurred in database "SMP_EC_30", table "dbo.PHONE".
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

 3.0.516, patch 34
 3.0.516, Service Pack 10

Was this article helpful?