I use an execution that gets multiple records from SQL, then searches for a matching ones in Airtable. This operation is done on all records taken from SQL database, so the search is done more than 600 times. At about 400th one, the execution stops working due to unknown reasons. If a tab with workflow is opened when this happens, a network error is shown. When I check the execution history, despite there being an error displayed on the executions history list, opening this individual execution shows only one SQL record being received (instead of 600), and that it was properly checked in airtable. What happened to the remaining 400 records? Why is the error that occurred not shown in details in history? Is this a known issue?
Welcome to the community @stanislawgrzybol
You need to batch your operations instead of processing all 600 records at once.
you can use batching with Loop Nodes
1 Like