Error: “Data could not be saved. The UPDATE statement conflicted with the REFERENCE constraint ‘FK_MKTFINDERNUMBERCONSTITUENTAPPEAL_CONSTITUENTID’. The conflict occurred in database ‘xxxx’, table ‘dbo.MKTFINDERNUMBERCONSTITUENTAPPEAL’, column ‘CONSTITUENT

Two constituent records can be merged together.  Choosing a target record (merge into) and source record (merge from), and a merge configuration, the record information can be combined and the extraneous record made inactive or deleted.  When merging certain records, the following error occurs:

Error: “Data could not be saved. The UPDATE statement conflicted with the REFERENCE constraint ‘FK_MKTFINDERNUMBERCONSTITUENTAPPEAL_CONSTITUENTID’. The conflict occurred in database ‘xxxx’, table ‘dbo.MKTFINDERNUMBERCONSTITUENTAPPEAL’, column ‘CONSTITUENTID’.”
We're currently evaluating this issue for a fix in a future patch or service pack. 

Steps to Duplicate

  1. Go to Constituent functional area
  2. Select Duplicates
  3. Select merge two constituents
  4. Enter Source constituent (8-15376171)
  5. Enter target constituent (8-13365845
  6. Select Merge configuration Default HPI Merge
  7. Click Merge
  8. Observe error

Environment

 Blackbaud CRM
 4.0

Was this article helpful?