No announcement yet.

Advanced Pack: Report Export Failures

  • Filter
  • Time
  • Show
Clear All
new posts

  • Advanced Pack: Report Export Failures

    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 :-)

  • #2
    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:, 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.