Error: Error in Main Page Load 'C:\Program Files (x86)\Blackbaud\The Raisers Edge 7\AXDocs\tabBanks.vbd' when clicking Financial Institutions

Users may receive the follow message when clicking Financial Institutions in Config after they have sorted by a specific column then removed that column.

Error in Main Page Load
The Raiser's Edge was unable to load this page.

Please try accessing the page again.  If you still encounter an error, Please note the following error and contact Blackbaud support.

Error in Main Page Load 'C:\Program Files (x86)\Blackbaud\The Raisers Edge 7\AXDocs\tabBanks.vbd'
Error number : -2147211486
Error description : 'General ODBC Error: [Microsoft][ODBC SQL Server Driver][SQL Server]A constant expression was encountered in the ORDER BY list, position 1.
Native error:408
[Microsoft][ODBC SQL Server Driver][SQL Server]The cursor was not declared.
Native error:16945


The user cannot access Financial Institutions without the error occurring.
 
This is resolved in 7.96 patch 13, released in September - October 2018 and applied to databases in Blackbaud Hosting Services. If your database is installed locally, download and install the latest version and patch, if applicable. 

In previous versions:

Steps to Duplicate

  1. Go to Config> Financial Institutions
  2. Click the Header to a column, such as Branch Name, to sort based on the column
  3. Right-click, Columns
  4. In the Columns window, remove the column that was used to sort
  5. Click OK
  6. Navigate away from Config> Financial Institutions, and then return
  7. Error occurrs

Environment

 Raiser's Edge
 7.93
 7.96
 13

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.