Error: Data could not be saved. The UPDATE statement conflicted with the CHECK constraint 'CK_PHONE_PRIMARYCOUNT'. The conflict occurred in database "3763_99e697f0-ed0c-434c-9dc8-f66d5480b7a", table 'dbo.PHONE".--when syncing a record in ResearchPoint

Some users receive the following error when syncing a record in ResearchPoint to Raiser's Edge: 
Error: Data could not be saved. The UPDATE statement conflicted with the CHECK constraint 'CK_PHONE_PRIMARYCOUNT'. The conflict occurred in database "3763_99e697f0-ed0c-434c-9dc8-f66d5480b7a", table 'dbo.PHONE".
Try the following steps in order until the issue is resolved:

1) If the records has multiple phones and/or emails, make sure that one is marked as Primary in RE
2) Make sure that all of the phone types from the record in RE are listed as active Phone and Email types in the Code table in RP
3) If the above steps do not resolve the issue, take a screenshot of all contact information from the RE record (or otherwise save the contact information so that it is not lost), then :
  1. delete all phones, emails, etc. from the record in Raiser's Edge, then Save and Close the record
  2. Sync the record in ResearchPoint
  3. Add the Phone/Email information back onto the Raiser's Edge record and Sync again in ResearchPoint

Environment

 ResearchPoint

Was this article helpful?