The DELETE statement conflicted with the REFERENCE constraint FK_USR_CAMPAIGNPARTICIPATION_CONSTITUENTID". This references a custom USR table

 Users may receive the following error message when attempting to merge constituents: 

"Data could not be saved.
The DELETE statement conflicted with the REFERENCE constraint "FK_USR_CAMPAIGNPARTICIPATION_CONSTITUENTID". The conflict occurred in database "DB_NAME", table "dbo.USR_CAMPAIGNPARTICIPATION", column 'CONSTITUENTID'. Uncommittable transaction is detected at the end of the batch. The transaction is rolled back.

This can occur for various custom tables that begin with USR and include constituent IDs.
In the out-of-box merge process, custom components (such as custom fields, attributes or information stored in a custom table) will not carry over from the source to the target constituent. The last part of the out-of-box merge process is to delete the source constituent, and this error will be thrown when the merge process attempts to delete the source constituent with its custom component.

To merge constituents with a custom component, use SDK or Blackbaud Professional Services to create a custom Merge Task Spec. This spec should merge constituents with the custom component. Load and test this spec in a test environment before adding it to Production. Create a new Merge process from this spec. With the custom Merge process referencing the custom component of the Constituent, the error will not appear. The custom Merge process can be added to a Workflow if needed.

Steps to Duplicate

  1.        Go to Constituents
  2.        Select Duplicates
  3.        Select Merge 2 Constituents
  4.        Search for the Source Constituent
  5.        Search for the Target Constituent
  6.        Select the Configuration
  7.        Select to mark source inactive with an inactive reason
  8.        Select Merge and receive error
  9.        The DELETE statement conflicted with the REFERENCE constraint "FK_USR_CAMPAIGNPARTICIPATION_CONSTITUENTID". The conflict occurred in database "DB_NAME", table "dbo.USR_CAMPAIGNPARTICIPATION", column 'CONSTITUENTID'.

Environment

 Blackbaud CRM
 3.0
 3.0
 3.0.516.41

Was this article helpful?