Error: Query too complex. General ODBC Error: [Microsoft][ODBC SQL Server Driver][SQL Server]Arithmetic overflow error converting expression to data type int. Native error:8115 [Microsoft][ODBC SQL Server Driver][SQL Server]The cursor was not declared. N

When trying to view the Results tab or clicking Run Now in a constituent query with the criteria of Prospect Ratings Category not blank and the output of Prospect Ratings Description, users may experience the following error message:

Error: Query too complex. General ODBC Error: [Microsoft][ODBC SQL Server Driver][SQL Server]Arithmetic overflow error converting expression to data type int. Native error:8115 [Microsoft][ODBC SQL Server Driver][SQL Server]The cursor was not declared. Native error:16945
 

This issue is a result of Ratings whose Category data type is Currency, and whose Description exceeds the max allowed for the field: 2,147,483,647. 

To identify these fields:

  1. Create an import file of the Ratings included in the query: How to create an import data file (export) using Import, including both Category and Description.
  2. Remove all rows without Category of Currency. 
  3. Sort the results by the Description column. 
  4. For any value over 2,147,483,647, edit the record and store this value in the Notes field. 

We have evaluated this issue as a bug and we have determined it will not be addressed in the program in its current state.  In this case, we believe the risks and challenges outweigh the potential benefit of resolving this issue. We strive to select the most impactful changes and issues to address with each release to accelerate the rate at which we deliver new features while sustaining the highest level of quality for our customers.

 

We recommend adding any program suggestions to our Ideas Community page. Our developers check here first when building program enhancements to see what our users are most interested in seeing implemented.

Environment

 7.93.5782.8

Was this article helpful?