Error: General ODBC Error: The DELETE statement conflict with the REFERENCE constraint FK_PAYMENTHEADERS7_ RECEIPTADDRESSID" when merging records."

When merging two duplicate records, the following error appears on the Merge Records control report, records are not merged:
Error: General ODBC Error: The DELETE statement conflict with the REFERENCE constraint "FK_PAYMENTHEADERS7_RECEIPTADDRESSID". The conflict occurred in database "EE_1137", table "dbo.PAYMENTHEADERS7", column 'RECEIPTADDRESSID'.
Native error: 547
[Microsoft][ODBC SQL Server Drive][SQL Sever]The statement has been terminated.
Native error: 3621
Contact Support and reference this article. 

Environment

 7.82.104, patch 18

Was this article helpful?