KB30538: "[Error:FetchScroll failed. [Adaptive Server IQ]When Force_No_Scroll_Cursors = ON, scrolling cursor operations are not supported by Sybase IQ]" error message appears with Sybase IQ database on MicroStrategy 10.x

SYMPTOM:
 Users who have Sybase IQ as a data warehouse may encounter the following error during report execution:
 

 
 
Error: QueryEngine encountered error: FetchScroll failed.
Error type: Odbc error. Odbc operation attempted: SQLFetchScroll. When Force_No_Scroll_Cursors = ON, scrolling cursor operations are not supported by Sybase IQ
 
 
CAUSE:
This error is related to the change in the ODBC version used from  Strategy version 9 onwards.  By default, Strategy 10.x  will use the 3.x ODBC calls during SQL execution for existing Sybase IQ database instances.  When a database instance is set to use 3.x ODBC calls the Strategy query engine uses the SQLFetchScroll function to fetch back data from the database.  The SQLFetchScroll function is not supported by SybaseIQ when the Force_No_Scroll_Cursors option is enabled.
 
ACTION:
There are 3 options to make the report execute without the error message:
 

• Change the database by setting to OFF the Force_No_Scroll_Cursors option.  By default this option is turned ON.  Ask the Sybase IQ database administrator to change the option to Force_No_Scroll_Cursors = OFF.
• Set the option to OFF via a Sybase IQ set statement using the Strategy VLDB setting for Pre/Post Statements ’Report Pre Statement 1’.  The set statement to use is “set temporary option Force_No_Scroll_Cursors = OFF”.

• Change the Database Instance to use 2.0 ODBC calls instead of the default value of 3.x.