Error: General ODBC Error: [Microsoft][ODBC SQL Server Driver][SQL Server]The multi-part identifier ".Constit_ID" could not be bound. Native error:4104 [Microsoft][ODBC SQL Server Driver][SQL Server]The cursor was not declared. Native error:16945

When running the Recent Gifts Dashboard, filtering on constituency codes, users report receiving the following error.

General ODBC Error: [Microsoft][ODBC SQL Server Driver][SQL Server]The multi-part identifier ".Constit_ID" could not be bound. Native error:4104 [Microsoft][ODBC SQL Server Driver][SQL Server]The cursor was not declared. Native error:16945
 
We are currently evaluating this issue and will update this article when we have more information. 

Alternative Solution:

Only filter on the constituency codes in the query. 

Steps to Duplicate

1. Log into The Raiser's Edge.
2. Navigate to Dashboards.
3. Create a Recent Gifts Dashboard.
4. Set the properties to filter on constituency code.
5. Refresh Dashboard
6. Error received. 

Environment

 Raiser's Edge

Was this article helpful?