Error received when deleting a constituent record

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. 
  1. Remove the Address Processing fields from the output.
  2. Save the Query.
  3. Log out of The Raiser's Edge and Log back in.
  4. Delete the Constituent Record. 

Environment

 Raiser's Edge
 7.95

Was this article helpful?