When deleting Constituent records, users may see the following error message:
Error: General ODBC Error: [Microsoft] [ODBC SQL Server Driver][SQL Server] The DELETE statement conflicted with the REFERENCE constraint. e“FK_QADDRESSPROCESSING_2”. The conflict occurred in database “RE7_16432”, table “dbo.QADDRESSPROCESSING”, column ‘ADDRESS_JD’. Native error:547 [Microsoft][ODBC SQL Server Driver][SQL Server} The statement has been terminated. Native error:3621
This error message prevents the Constituent record from being deleted.
This error will occur if the record that is being deleted is included in any saved query with Address Processing fields selected in the Output. Follow these steps to resolve the error.
Remove the Address Processing fields from the output.