I have often used Retool workflows to translate data between two systems, for example by calling up a table in SQL, then looping through each row to import into another system using their API. A simple example workflow is shown below.
However, starting this week, I am suddenly getting this error on my loop blocks:
"Internal Error running a block: Error: An internal server error occurred"
This happens immediately whenever I seem to go above even 3000 or so items in my initial query. It's not just with sql, this has happened when I've done a large GET from another API as well and then tried to loop through it. You can see the error in the picture as well.
I know this is not a timeout issue because I have the timeout on my loop blocks set to 10 minutes (600000 ms) and this error pops up after only a few seconds when a click play on the block.
This issue has also only been happening this week, as I've been able to use loops in Workflows for much larger sets of data in the past.
Does anybody know what this error is and how to avoid it? If I'm going to timeout (which I don't believe I would), then that's one thing, but I feel like the workflow shouldn't be deciding for me whether that's going to happen or not before I get the chance to test it myself.