i try to do some ETL processes in a workflow, my first run with 1000 rows runs smoothly and fine.
After that i changed the Limit in the SQL Statement and run the same Workflow with (46000 rows) and the workflow generating following error:
Problem running workflow
There was a problem running the workflow: Request failed with status code 413
My Workflow is only a SQL Statement and a Functionsitem Block with one Javascript Regex Function.
Status code 413 means Payload Too Large. So 46k rows are apparently simply too much data. In this case you would have to split it into multiple runs with fewer rows per execution.
Sorry actually do not know where that error comes from. If from n8n (so Node.js) or the reverse proxy. But considering that apparently n8n crashes even with 10k rows, as it probably runs out of memory, does increasing the request limit not really help anyway.