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 and higher.
If your database is hosted by Blackbaud, you can skip to step #7.

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?


Thanks for your feedback! Did this solve your issue?

Comments (optional):


Thanks for your feedback!
We're glad it was helpful but sorry it didn’t solve your issue. If you need assistance, click Chat with Support below.
We’re sorry to hear that. Please tell us why.

 I don't like how this works.

 The answer is confusing.

 The answer didn't match what I was searching for.

Additional Comments (optional):


Thanks for your feedback! If you need assistance, click Chat with Support below.
Thanks for your feedback. Help us make our products even better by sharing details in our Idea Banks or our online Community.
Thanks for letting us know. We'll work on clarifying the information in the article. If you need assistance, click Chat with Support below.
Thanks for letting us know. We'll work on updating the search engine to return more relevant results.