Error: General ODBC Error:[Microsoft] [ODBC SQL Server Driver] [SQL Server] The DELETE statement conflicted with the REFERENCE constraint FK_QADDRESSPROCESSING_2". The conflict occurred in database "RE7", table "dbo.QADDRESSPROCESSING", column "ADDRESS_

Error received when deleting constituent records:

Error: General ODBC Error:[Microsoft] [ODBC SQL Server Driver] [SQL Server] The DELETE statement conflicted with the REFERENCE constraint "FK_QADDRESSPROCESSING_2". The conflict occurred in database "RE7", table "dbo.QADDRESSPROCESSING", column "ADDRESS_ID". Native Error:547 [Microsoft][ODBC SQL Server Driver][SQL Server] The statement has been terminated. Native Error:3621

1. Delete the affected query

2. Recreate the query

3. Delete the necessary constituent records.

Environment

 7.83.1622 patch 0 ; 7.85.5026 patch 6

Was this article helpful?