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".
In order for phone numbers to be sent over from Raiser's Edge to ResearchPoint, the following is required:
  • All records with a phone number must have one designated as "Primary," even if there is only one phone number
  • All records with an email address must have one designated as "Primary," even if there is only one email address
  • The phone and email types in Raiser's Edge must exist in the code tables in ResearchPoint and must be set to active.
For single records having the issue, try the following steps in Raiser's Edge, 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 Raiser's Edge
  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 :
    • delete all phones, emails, etc. from the record in Raiser's Edge, then Save and Close the record
    • Sync the record in ResearchPoint
    • Add the Phone/Email information back onto the Raiser's Edge record and Sync again in ResearchPoint
If you find that there are many records returning this error, such as when trying to sync a list, you may also turn off the phone number sync in the Integration settings.
  1. From the Home screen in ResearchPoint, click "The Raiser's Edge Integration"
  2. Click the "Configure Fields" tab
  3. Click the "Sync from The Raiser's Edge" tab
  4. Uncheck "Phone Information"
  5. Click Save

 

Environment

 ResearchPoint

Was this article helpful?