On database queries or API requests. All of my blocks fail when trying to run them individually, however if I run the script as a whole, it seems to work just fine
I'm encountering an issue with a workflow that had a resource query, retool database, using SQL. Since today, I'm getting the following error: {"data":null,"metadata":{},"error":"Internal Error running a block: Error: Internal server error"}
Previously to notice this error I did these changes:
I added a new column called segmentation to one of my tables and updated my SQL query to include this column.
What I've tried to fix this:
Created a new workflow and reran the query.
Removed and re-added the block that runs the query.
Reverted my query to the previous version (without the new column).
Interestingly, the same SQL query runs perfectly fine from the query library, so I don't think it's a syntax issue:
We were able to identify an issue with the advance rollout of cloud version 3.89 and have reverted anybody affected back to version 3.87, so this should be resolved!