Error: Data could not be saved. The DELETE statement conflicted with the REFERENCE constraint FK_CONSTITUENTRECOGNITIONDECLINEDLEVEL_CONSTITUENTID". - when merging two constituents"

Unable to merge two constituents where the source constituent has a value for Constituent recognition declined level.  Users may receive the error:

Data could not be saved. The DELETE statement conflicted with the REFERENCE constraint "FK_CONSTITUENTRECOGNITIONDECLINEDLEVEL_CONSTITUENTID". The conflict occurred in database "[database name]", table "dbo.CONSTITUENTRECOGNITIONDECLINEDLEVEL", column 'CONSTITUENTID'

Download and install the latest patch, which contains all fixes from previous patches. If you are running an older version, download and install the latest version and then the patch. 

Environment

 3.0.516, patch 20
 3.0.516, Service Pack 10 ; 4.0.138, patch 2

Was this article helpful?