KB44701: “Invalid operation. Attempted to fetch an empty result.” error message appears when retrieving large result set for reports or while publishing large cubes on MicroStrategy 9.x against Amazon Redshift.

SYMPTOM
The following error message appears when retrieving a large result set for reports or while publishing large cubes on Strategy 9.x against Amazon Redshift.
 

Error type: Invalid operation. Attempted to fetch an empty result.

 
CAUSE
Amazon Redshift versions below 1.0.662 are unable to retrieve large result sets via ODBC.
 
ACTION
1) Check if Amazon Redshift instance’s version is below 1.0.662, using below SQL query from Strategy DB Query Tool:

select version();

 
The output from the above query may appear something like below: 
 

PostgreSQL 8.0.2 on i686-pc-linux-gnu, compiled by GCC gcc (GCC) 3.4.2 20041017 (Red Hat 3.4.2-6.fc3), Redshift 1.0.662

 
2) If Amazon Redshift instance is below version 1.0.662 then contact Amazon support to upgrade the database instance.
 
3) If the instance version is 1.0.662 or above then set Redshift (postgresSQL) ODBC driver to “use fetch” as explained below.
 
Navigate to “ODBC Administrator (32 bit)” > “Configure” > “Datasource”