Advanced Pack: Report Export Failures

[AgentT]

If I try to export a large report with 20k+ rows and 10+ columns, the export fails with an "Error 500", but no logs can be found anywhere about the failure.

Why does it fail? Is it a memory issue or a timeout issue? What is a workaround for the problem?

Thanks :-)

[AgentT]

Update: Found nginx logs where there is an error like:

PHP message: PHP Fatal error: Allowed memory size of 536870912 bytes exhausted (tried to allocate 12288 bytes)

This does not make sense, I have 512MB as the memory limit, and the program tries to allocate just 12KB and the job fails.

Anyway, I increased the memory limit to 2048MB, but now there is a timeout error:

upstream timed out (110: Operation timed out) while reading response header from upstream, client: 172.17.0.1, server: _, request: "POST /api/v1/Report/action/exportList HTTP/1.1"

After some 5 min after the timeout, the XLSX file was found under the "Attachments" entity with the full data that I want. This is annoying especially for non tech savvy end users, who will not know where to look.