After upgrading to Strategy ONE March 2024, users encounter ‘Fetch failed. Error type: Invalid operation. Attempted to fetch an empty result.’ error while attempting to run reports. This issue is associated with reports created on Amazon Redshift Database.
After investigation, the root cause of this issue was identified to be a defect in Amazon Redshift Driver. The Driver version responsible for this error is 8.00.2183. A malfunction in performing database operations with this specific driver version results in fetching an empty result, thereby triggering the error message.
To resolve this error, it is recommended to replace the faulty Amazon Redshift Driver version 8.00.2183 with version 8.00.00.739.
It is advised to take a backup of your database and necessary configurations before performing this change.