Create
cancel
Showing results for 
Search instead for 
Did you mean: 
Sign up Log in

It's not the same without you

Join the community to find out what other Atlassian users are discussing, debating and creating.

Atlassian Community Hero Image Collage

EasyBi Report generation is not working

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

 

4 answers

0 votes

Hi! 

Any other indicator in the atlassian-jira.log ? 

Have oyou tried to reach into this community

https://community.eazybi.com/

 

Cheers,

Gonchik Tsymzhitov

I had the same problem

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

Suggest an answer

Log in or Sign up to answer
TAGS

Community Events

Connect with like-minded Atlassian users at free events near you!

Find an event

Connect with like-minded Atlassian users at free events near you!

Unfortunately there are no Community Events near you at the moment.

Host an event

You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events

Events near you