Request failed with status code 413

Questions
1

Hi,

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.

Maybe anyone know to increase the Upload Limit?

grafik
grafik1905×360 33.8 KB

2

Welcome to the community @Basti!

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.

3

Hi Jan,

thank you for your fast reply!
I limited the Statement to 10k the workflow generating now following error :

There was a problem executing the workflow:
"Workflow execution process did crash for an unknown reason!"

If the rowcount is under 8k it works, thanks :slight_smile:

So the 413 error is a webserver error? any ideas to increase the limit? for nginx a client_max_body_size parameter exists to change that.

4

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.

5

Okay thank you very much for your effort :slight_smile:

6

Sure, have fun!