Workflow not handling errors like it should

Good morning or good evening folks,
I have a major issue and I will tag a @retool @expert here
I 've Created a workflow at https://ecommfox.retool.com/workflows/c4e0d650-f0df-4e4a-b539-03c68f0cafc2

What I'm trying to build ;

A workflow chaining queries to an API endpoint for each row of a table /
Paginated data and processing each 500 rows in a new run.

When a new run is created a 'task' is created in the database ;

There is only one iteration block and I changed settings of the error handler to Error - Continue so that it continues to the task history update query .

But impossible to connect another block to the error handler / AS a result the flow is exiting and I am unable to update the task in "Pending" Status and even worse can not retrieve error message to understand why api query failed .

I think there is a bug because changing setting doesn't change anything and when I try to connect a block to onFailure handle it automatically disconnects .

I really need you help on this one @retool any help please?

Hello @Ecommfox! It sounds like the error handler is designated as a Global Error handler in your workflow and would explain why you cannot connect nodes to it.

For your workflow and the loop block, are you looping over sets of 500 rows or is each workflow run 500 rows only? Would you also mind sharing a screenshot of your loop block setup? We aren't able to access each others workflows via a shared link but I think I have a good understanding of what you are trying to do.

I recently wrote a post about using functions and loop blocks to catch errors in a more meaningful way which might help you derive a solution: