Error: Donor Name has been linked to The Raiser's Edge with constituent ID ####. Data could not be saved. The INSERT statement conflicted with the CHECK constraint "CK_COUNTRY_ABBREVIATION." The conflict occurred in database "53951

When trying to link and sync records between The Raiser's Edge and ResearchPoint, client may receive the notification: 

Donor Name has been linked to The Raiser's Edge with constituent ID REConstituentID

Data could not be saved.
The INSERT statement conflicted with the CHECK constraint "CK_COUNTRY_ABBREVIATION."
The conflict occurred in database "53951_7f6b76d3-1829-4928-8497-2ce991310f4c", table "dbo.COUNTRY", column 'ABBREVIATION'.
To resolve this issue please make the following change to the users settings.
  1. Log into The Raiser's Edge
  2. Click Tools > User Options
  3. Select the General tab
  4. Mark Use long description for display and data entry as shown below:
    User-added image

Steps to Duplicate

1. Log into an integrated ResearchPoint
2. Enter record in ResearchPoint
3. Log into integrated The Raiser's Edge
4. Enter record for the same person in The Raiser's Edge
5. Try to link the two records

Was this article helpful?