Error: Data could not be saved. The UPDATE statement conflicted with the CHECK constraint "CK_CONSTITUENCY_ISUNIQUE" when processing Add user-defined constituency global change

An error occurred before executing the process 'Global Change Process' : Data could not be saved. The UPDATE statement conflicted with the CHECK constraint "CK_CONSTITUENCY_ISUNIQUE". The conflict occurred in database "DATABASE", table "dbo.CONSTITUENCY". 

The error occurs when processing the add user-defined constituency and a constituent record has two of the same constituencies without overlapping dates. 
Workaround:
Remove the constituent from the selection being used in the global change
OR
Delete one of the duplicate constituencies from the constituent's record

Steps to Duplicate

  1. Go to a constituent record
  2. Select Personal Info > Constituencies
  3. Add two Constituencies that are the same and ensure the dates do not overlap
  4. Go to Administration> Global Change
  5. Add a new add user-defined constituency global change
  6. Create a selection that includes the record
  7. Select the same constituencies and dates that do not overlap with whats's on the record
  8. Mark both boxes at the bottom
  9. Select Save and Process the global change-see error

Environment

 Blackbaud CRM
 4.0
 Version 4.0.141.19

Was this article helpful?