Error: The DELETE statement conflicted with the REFERENCE constraint FK_BATCHCONSTITUENT_PRIMARYBUSINESSID" - when merging records"

When attempting to merge constituents we receive the following exception message: 

The DELETE statement conflicted with the REFERENCE constraint "FK_BATCHCONSTITUENT_PRIMARYBUSINESSID". The conflict occurred in database "database", table "dbo.BATCHCONSTITUENT", column 'PRIMARYBUSINESSID'.
The statement has been terminated.

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
 3.0.516, Service Pack 8

Was this article helpful?