Discussions
Categories
Groups
Community Home
Categories
INTERNAL ENABLEMENT
POPULAR
PUBLIC CLOUD
PRIVATE CLOUD
Quick Links
MY LINKS
HELPFUL TIPS
Back to website
Home
Intelligence (Analytics)
Concurrent birt reports generation slow
ricofernan
I'm having a problem with concurrent birt reports generation in a JBoss environment. Sometimes, when more than a user generates reports at the same time (even when the report designs are different), reports take a very long time to complete. Reports that usually completes in less than 5 seconds lasts 2 minutes or more! Taking a dump of the threads currently running, I've noticed something strange:
org.eclipse.birt.report.engine.data.dte.ReportQueryBuilder.build(ReportQueryBuilder.java:256)
- locked <0x45a228> (a org.eclipse.birt.report.engine.ir.Report)
org.eclipse.birt.report.engine.data.dte.ReportQueryBuilder.build(ReportQueryBuilder.java:237)
- locked <0x45a228> (a org.eclipse.birt.report.engine.ir.Report)
could this be the cause of it? If yes, how can I deal with it?
thanks a lot!
Find more posts tagged with
Comments
vavesw
Just out of curiosity.
Are you sharing the same report engine instances?
We have the same requirement. We have started development and we are looking for design issues that might be caused due to this concurrent running of reports using the same engine instance.
Or are you creating a separate engine for each of the report instance
johnw
Are you using the BIRT Example Web Viewer, or are you integrating the report engine in a custom application?
vavesw
<blockquote class='ipsBlockquote' data-author="'johnw'" data-cid="76272" data-time="1303856471" data-date="26 April 2011 - 03:21 PM"><p>
Are you using the BIRT Example Web Viewer, or are you integrating the report engine in a custom application?<br /></p></blockquote>
<br />
We are using BIRT Viewer
dalepraneeth
i am also getting the same issue ...<br />
<br />
I am having 2 applications using the same report engine ....<br />
<br />
<strong class='bbc'>org.eclipse.birt.report.engine.api.EngineException</strong>: Error happened while running the report.<br />
at org.eclipse.birt.report.engine.api.impl.RunAndRenderTask.doRun(RunAndRenderTask.java:196)<br />
at org.eclipse.birt.report.engine.api.impl.RunAndRenderTask.run(RunAndRenderTask.java:77)<br />
<br />
<strong class='bbc'>Caused by: java.lang.NullPointerException<br />
at org.eclipse.birt.report.engine.data.dte.ReportQueryBuilder$QueryBuilderVisitor.createParamBindings(ReportQueryBuilder.java:1670)</strong> at org.eclipse.birt.report.engine.data.dte.ReportQueryBuilder$QueryBuilderVisitor.addParamBinding(ReportQueryBuilder.java:1592)<br />
at org.eclipse.birt.report.engine.data.dte.ReportQueryBuilder$QueryBuilderVisitor.createQuery(ReportQueryBuilder.java:1420)<br />
at org.eclipse.birt.report.engine.data.dte.ReportQueryBuilder$QueryBuilderVisitor.visitTableItem(ReportQueryBuilder.java:913)<br />
at org.eclipse.birt.report.engine.ir.TableItemDesign.accept(TableItemDesign.java:53)<br />
at org.eclipse.birt.report.engine.data.dte.ReportQueryBuilder.build(ReportQueryBuilder.java:256)<br />
at org.eclipse.birt.report.engine.data.dte.ReportQueryBuilder.build(ReportQueryBuilder.java:237)<br />
at org.eclipse.birt.report.engine.data.dte.AbstractDataEngine.prepare(AbstractDataEngine.java:180)<br />
at org.eclipse.birt.report.engine.executor.ReportExecutor.execute(ReportExecutor.java:122)<br />
at org.eclipse.birt.report.engine.internal.executor.wrap.WrappedReportExecutor.execute(WrappedReportExecutor.java:60)<br />
at org.eclipse.birt.report.engine.internal.executor.dup.SuppressDuplciateReportExecutor.execute(SuppressDuplciateReportExecutor.java:42)<br />
at org.eclipse.birt.report.engine.internal.executor.wrap.WrappedReportExecutor.execute(WrappedReportExecutor.java:60)<br />
at org.eclipse.birt.report.engine.internal.executor.l18n.LocalizedReportExecutor.execute(LocalizedReportExecutor.java:61)<br />
at org.eclipse.birt.report.engine.api.impl.RunAndRenderTask.doRun(RunAndRenderTask.java:178)