I've been trying to setup a simple workflow to migrate some data from our mongodb to a retool database, I have three steps.
Clear the retool database
Query our MongoDB
Loop and Insert rows with values.
With very small datasets (1,000 rows) there is no issue, however once I attempt to do a dataset like 20,000 rows it instantly returns the error Runtime error: exited workflow with code 139. Here is the loop that's failing. The mongo query populates in a few seconds, but every time I attempt to use the loop action it
Is there more context for this error? Should I open a support ticket or is there something I'm missing? I understand Retool may not be the best resource to migrate data from noSQL to SQL, but I figured for a smaller dataset this wouldn't be too much.
Sorry to hear you are running into the same issue. Are any batches able to run or is it failing on the first batch? Also how large are the batches you are looping through?
There has been a bug request made for our engineering team to fix this as well as generate more useful error code messages for debugging purposes but it is still in the issue queue.
I can add in your +1 to the bug report to hopefully get some more traction on it.
If you could provide more details or come to office hours we can help troubleshoot further as to if the error is being caused by something we can fix