Hi community. Hoping you can help.
I upgraded redash instance using the script and now saved queries fail to run.
During upgrade I ran into another separate issue and resolved it as pointed out here: [SOLVED] Problems during upgrade from 2.0.1 to 3.00.
But this issue continues.
Description of issue:
All my queries that are saved (published or not) fail to run and throw an error. However copy pasting the same sql code into a new query returns the results as expected just like before the upgrade.
- Open a saved querry
- Click execute
- Read error “Error running query: No data was returned.”
- Copy the SQL
- Click New Querry
- Paste and execute
- Read results = all Ok.
So any ideas what is causing the issue that saved queries will not run and throw an error?
I have tried rebooting the whole machine and it is still the same. I am not sure if there are more detailed logs stored somewhere that might give a hint.
Thanks for the help.