Eclipse Community Forums: BIRT » Slow concurrent report generation

Home » Archived » BIRT » Slow concurrent report generation(Very slow generation of reports in a concurrent environment)

Slow concurrent report generation [message #663379]

Mon, 04 April 2011 15:53

Eclipse User

I've a web application running in Jboss that have lots of concurrent users. At a given time, lots of reports are generated.

In this scenario, sometimes reports run very slow! They appear to be waiting for something and then continue. I'm using a Servlet (almost equal to the reference servlet) to handle report generation.

Taking a dump of the threads running, I've noticed something strange:

org.eclipse.birt.report.engine.data.dte.ReportQueryBuilder.b uild(ReportQueryBuilder.java:256)
- locked <0x45a228> (a org.eclipse.birt.report.engine.ir.Report)
org.eclipse.birt.report.engine.data.dte.ReportQueryBuilder.b uild(ReportQueryBuilder.java:237)
- locked <0x45a228> (a org.eclipse.birt.report.engine.ir.Report)

Do you think there's anything related to this? The 'locked' keyword took my attention, but I don't know what could be causing this! Any clues?

thanks a lot in advance, Ricardo

Re: Slow concurrent report generation [message #663648 is a reply to message #663379]

Tue, 05 April 2011 22:49

Eclipse User

Ricardo,

Are all tasks being closed? Are you using runandrender task or run task
followed by render task?

Jason

On 4/4/2011 3:53 PM, Ricardo Fernandes wrote:
> I've a web application running in Jboss that have lots of concurrent
> users. At a given time, lots of reports are generated.
>
> In this scenario, sometimes reports run very slow! They appear to be
> waiting for something and then continue. I'm using a Servlet (almost
> equal to the reference servlet) to handle report generation.
>
> Taking a dump of the threads running, I've noticed something strange:
>
> org.eclipse.birt.report.engine.data.dte.ReportQueryBuilder.b
> uild(ReportQueryBuilder.java:256)
> - locked <0x45a228> (a org.eclipse.birt.report.engine.ir.Report)
> org.eclipse.birt.report.engine.data.dte.ReportQueryBuilder.b
> uild(ReportQueryBuilder.java:237)
> - locked <0x45a228> (a org.eclipse.birt.report.engine.ir.Report)
>
> Do you think there's anything related to this? The 'locked' keyword took
> my attention, but I don't know what could be causing this! Any clues?
>
> thanks a lot in advance, Ricardo

Re: Slow concurrent report generation [message #663730 is a reply to message #663648]

Wed, 06 April 2011 07:04

Eclipse User

Hi, Jason,

All tasks are being closed and I'm using runandrender. Should I try run, then render?

thanks in advance!

Re: Slow concurrent report generation [message #663980 is a reply to message #663730]

Thu, 07 April 2011 01:03

Eclipse User

Are you using the Graphical query builder in your datasources or the
normal jdbc datasource. I think this error message needs to be logged
as a bugzilla entry. Any chance you could do that?

Jason

On 4/6/2011 7:04 AM, Ricardo Fernandes wrote:
> Hi, Jason,
>
> All tasks are being closed and I'm using runandrender. Should I try run,
> then render?
>
> thanks in advance!

Re: Slow concurrent report generation [message #664423 is a reply to message #663980]

Fri, 08 April 2011 14:21

Eclipse User

I'm using the normal jdbc datasource, providing a JNDI url. I'm opening an entry in Bugzilla. thanks!

Re: Slow concurrent report generation [message #664735 is a reply to message #664423]

Mon, 11 April 2011 14:42

Eclipse User

Bugzilla entry:

https://bugs.eclipse.org/bugs/show_bug.cgi?id=342325

The problem persists. After a while, reports run very slow. I tested through the same database using another instance and they run fine (there are no locks in the DB).

I'm very frustated with that, because I have to restart every day the app. server. After restarting, everything becomes alright. Memory and CPU utilization is OK during that.

thanks in advance!

Re: Slow concurrent report generation [message #664736 is a reply to message #664735]

Mon, 11 April 2011 14:45

Eclipse User

Another info: looking at the thread dump, I've noticed there are lots of threads related to birt that are in "Runnable" state.

Re: Slow concurrent report generation [message #664836 is a reply to message #664736]

Tue, 12 April 2011 05:09

Eclipse User

Can you post the code you are using? Are you using runandrender task or
separate run and then render task?

Jason

On 4/11/2011 2:45 PM, Ricardo Fernandes wrote:
> Another info: looking at the thread dump, I've noticed there are lots of
> threads related to birt that are in "Runnable" state.

Re: Slow concurrent report generation [message #757826 is a reply to message #664836]

Mon, 21 November 2011 14:26

Eclipse User

Ricardo,

Have you solved this problem?

Thanks

Re: Slow concurrent report generation [message #758104 is a reply to message #757826]

Mon, 21 November 2011 16:30

Eclipse User

Gustavo

Are you having this issue?
This looks to me like task where not being closed or the rptdocument not
being closed.

Jason

On 11/21/2011 2:26 PM, Gustavo Lanna wrote:
> Ricardo,
>
> Have you solved this problem?
>
> Thanks

Re: Slow concurrent report generation [message #758826 is a reply to message #758104]

Thu, 24 November 2011 11:21

Eclipse User

Jason,

Thank you for reply! I'm using birt runtime WebViewer, and I do not close taks and rptdocuments. There is a way to do this in WebViewer?

Gustavo

Re: Slow concurrent report generation [message #759488 is a reply to message #758826]

Mon, 28 November 2011 14:35

Eclipse User

If you are using the WebViwer the documents should be getting closed
automatically.

Jason

On 11/24/2011 11:21 AM, Gustavo Lanna wrote:
> Jason,
>
> Thank you for reply! I'm using birt runtime WebViewer, and I do not
> close taks and rptdocuments. There is a way to do this in WebViewer?
>
>
> Gustavo

Previous Topic:	Integration with Active Directory?
Next Topic:	Specifying only the JNDI details for report template?

Goto Forum:

-=] Back to Top [=-

Current Time: Tue Jul 01 18:40:16 EDT 2025

.:: Contact :: Home ::.

Breadcrumbs

Sign up to our Newsletter