OutOfMemory error while expanding JQL query

We have updated JQL query in eazyBI (Source Data > Jira import options > Additional options > Additional filter) from created > -365d to created > -730d.
After that we have these errors in our reports:

There was error when performing your request.
Please retry or go to other page.

Failed to execute query. Error message:
OutOfMemory used=660603344, max=716177408

From the logs:
2019-08-13 13:59:32 +0500 ERROR: [7BBDD3BC:46a695e0] *** ChildProcessProxy request failed: {:body=>"
{" ":“Failed to execute query. Error message:\nOutOfMemory used=683026864, max=716177408\n”}
", :content_type=>“application/json”, :status=>500}

What should we do to fix that?

Hi @kseniya.trushnikova,

From the error, it looks like you have assigned 700MB of memory to the eazyBI child process. The default (leaving the configuration field empty) is 1GB.
In larger instances, this is not enough. Increasing the heap memory to 2GB is absolutely necessary, but if your server allows it, you should increase the eazyBI child process JVM heap memory to 4GB (-Xmx4g).

If the above suggestion does not help, could you please also share the report definition for the report that is giving the error (https://docs.eazybi.com/display/EAZYBI/Create+reports#Createreports-Exportandimportreportdefinitions)?

Kind regards,
Roberts // eazyBI support

1 Like

Thanks a lot! Increasing the heap memory to 4GB resolved the problem.

1 Like