Error: General ODBC Error: [Microsoft][ODBC SQL Server Driver][SQL Server]DELETE statement conflicted with COLUMN REFERENCE constraint 'FK_CONSTIT_RELATIONSHIPS_14'. The conflict occurred in database '[database name]', table 'CONSTIT_RELATIONSHIPS', colu

Error: General ODBC Error: [Microsoft][ODBC SQL Server Driver][SQL Server]DELETE statement conflicted with COLUMN REFERENCE constraint 'FK_CONSTIT_RELATIONSHIPS_14'. The conflict occurred in database 'Hugh', table 'CONSTIT_RELATIONSHIPS', column 'CONSTIT_ADDRESS_ID'.Native error:547

Note: Before you proceed with the following instructions, back up the database. If your organization integrates multiple Blackbaud products, refer to the Additional Requirements section of the backup solution.

Download and run the Fix Non-Primary Business Addresses plug-in, which repairs corruption in the address data for non-primary business relationships. The plug-in is compatible with The Raiser's Edge version 7.70.874.

Note: Print and read all of the following instructions before running the plug-in.

To run the plug-in, follow these steps:

  1. Log in to the workstation as a Local Administrator
  2. Download FixNonPrimaryBusRelAddresses_770.exe
  3. Save FixNonPrimaryBusRelAddresses_770.exe to the local hard drive of any Raiser's Edge 7 workstation
  4. Double-click FixNonPrimaryBusRelAddresses_770.exe
  5. When prompted, unzip the files into the \Plugins folder on the workstation. FixNonPrimaryBusRelAddresses_770.exe is a self-extracting zip file that contains the plug-in files: dobFixNPBRelAdds.vbd and FixNPBRelAddresses.dll
  6. Register FixNPBRelAddresses.dll on the workstation.
  7. Have all other users exit and sign out of The Raiser's Edge 7
  8. Log into The Raiser's Edge 7
  9. Click Plug-Ins from the Raiser's Edge Bar. The Plug-Ins screen appears.
  10. Select Fix Non-Primary Business Addresses
  11. Follow the prompts

Environment

 Duplicated in version 7.61.790

Was this article helpful?