Error: The conversion to version 7.82 R1 has failed (Update ID: 1340). Please report the following error: Error Number: 2147211486. General ODBC Error: [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid object name 'sys.check_constraints'.

This error occurs while updating The Financial Edge\The Education Edge\Blackbaud Student Information Systems after the patch update is complete and you are using SQL Server 2000 to run your database.  When logging into your database the first time after patch 11 has been installed, the system  then returns a prompt saying that the database needs to be updated. This error occurs when the database update is running.
 
On March 31, 2010, Blackbaud ended support on Microsoft SQL Server 2000.  End of support means we no longer test software releases or address product issues with Microsoft SQL Server 2000, but we will answer your software questions with versions that are compatible with SQL Server 2000.  To resolve the error, either:
 
  • Update or install SQL Server 2005* or 2008*, restore to a backup of your database before the patch was installed, and then install patch 11 again.

    Or
     
  • Download patch11mdb.exe (12.0M), double click the file, and extract the afnsys7.mdb file to the SysDB folder [default location:<install>\Blackbaud\The Financial Edge\SysDB] on the machine running the database revisions.

    Note:  If you are still using any version 6 products, such as Student Billing 6 or Payroll 6, you must restore to a backup and continue to use SQL Server 2000 SP4 as version 6 products are not compatible with SQL Server 2005 or SQL Server 2008.

*For more details on supported SQL Server versions, please see our system requirements.

Environment

 7.82.104, Patch 11

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.