EasyBi Report generation is not working

[Bani]

Hi everyone 

I described a report parameters which will show spent hours for all the projects .  it was working fine till October . Report from month November  is not getting generated .

I checked the system events in Easybi settings and there is following error is coming :

:Error: org.olap4j.OlapException: Mondrian Error:Query timeout of 60 seconds reached

root_cause_backtrace": [
    "root cause: mondrian.olap.QueryTimeoutException: Mondrian Error:Query timeout of 60 seconds reached",
    "root cause:   mondrian.resource.MondrianResource$_Def13.ex(MondrianResource.java:1214)",
    "root cause:   mondrian.server.Execution.checkCancelOrTimeout(Execution.java:252)",
    "root cause:   mondrian.rolap.RolapResultShepherd.shepherdExecution(RolapResultShepherd.java:171)",
    "root cause:   mondrian.rolap.RolapConnection.execute(RolapConnection.java:607)",
    "root cause:   mondrian.olap4j.MondrianOlap4jCellSet.execute(MondrianOlap4jCellSet.java:87)",
    "root cause:   mondrian.olap4j.MondrianOlap4jStatement.executeOlapQueryInternal(MondrianOlap4jStatement.java:415)",
    "root cause:   mondrian.olap4j.MondrianOlap4jPreparedStatement.executeQuery(MondrianOlap4jPreparedStatement.java:72)",
    "root cause:   mondrian.olap4j.MondrianOlap4jPreparedStatement.executeQuery(MondrianOlap4jPreparedStatement.java:42)",
    "root cause:   sun.reflect.GeneratedMethodAccessor6434.invoke(Unknown Source)",
    "root cause:   sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)",
    "mondrian/olap4j/mondrian/olap4j/MondrianOlap4jConnection.java:858:in `createException'",
    "mondrian/olap4j/mondrian/olap4j/MondrianOlap4jStatement.java:420:in `executeOlapQueryInternal'",
    "mondrian/olap4j/mondrian/olap4j/MondrianOlap4jPreparedStatement.java:72:in `executeQuery'",
    "mondrian/olap4j/mondrian/olap4j/MondrianOlap4jPreparedStatement.java:42:in `executeQuery'",
    "C:/JIRA_H~1/plugins/OSGI-P~1/felix/FELIX-~1/BUEDA8~1/version0.0/PLUGIN~2.JAR/0/META-INF/rails.root/vendor/gems/mondrian-olap/lib/mondrian/olap/connection.rb:81:in `execute'"
  ],
  "exception": [
    "Mondrian::OLAP::Error",
    "org.olap4j.OlapException: Mondrian Error:Query timeout of 60 seconds reached"
  ]

Thanks 

[Sir Mārtiņš Vanags]

Hi,

The increasing timeout can be challenging as now users would wait longer for the report.
The best way would be to optimize reports as much as possible.

See "Best practices" on how to create eazyBI reports.

https://docs.eazybi.com/eazybijira/analyze-and-visualize/best-practices-for-report-creation

You can also send your slow-performing report definition (exported to text files) to the eazyBI support team and we will try to help you with some recommendations.

Martins / eazyBI support

[matrix DevOps]

See

https://docs.eazybi.com/eazybijira/set-up-and-administer/set-up-and-administer-for-jira-server/advanced-settings#Advancedsettings-Increasequerytimeout

[张洪洋]

I had the same problem

[Gonchik Tsymzhitov]

Hi! 

Any other indicator in the atlassian-jira.log ? 

Have oyou tried to reach into this community

https://community.eazybi.com/

Cheers,

Gonchik Tsymzhitov