Eclipse Community Forums: BIRT » BIRT Does not respond

Help

Home

Home » Archived » BIRT » BIRT Does not respond(Execute BIRT standalone no WL - it hangs)

Show: Today's Messages :: Show Polls :: Message Navigator

BIRT Does not respond [message #1095208]

Mon, 26 August 2013 19:49

Eclipse Beginner

Messages: 23
Registered: September 2011

Junior Member

Hi,

Need some help:
I am running some report designs through BIRT runtime, but it hangs randomly. Sometime it returns and sometimes it just hangs and sits for hours. Unix truss shows process sleeping and there are no active DB connections. How can I debug it and find what it is doing ?

TIA
J

Report message to a moderator

Re: BIRT Does not respond [message #1095962 is a reply to message #1095208]

Tue, 27 August 2013 19:39

Michael Williams

Messages: 1925
Registered: July 2009

Senior Member

What is your BIRT version? Any way you can send me a set of reports that I can run and your Java class you're using to run the reports with that you're getting this issue with? This way I can try to see if I'm getting the issue too?

Michael

Developer Evangelist, Silanis

Report message to a moderator

Re: BIRT Does not respond [message #1095965 is a reply to message #1095962]

Tue, 27 August 2013 19:41

Michael Williams

Messages: 1925
Registered: July 2009

Senior Member

You could always write out to the console from within the report and within your Java class to try to find where your hangup is, too.

Michael

Developer Evangelist, Silanis

Report message to a moderator

Re: BIRT Does not respond [message #1096744 is a reply to message #1095965]

Wed, 28 August 2013 20:20

Eclipse Beginner

Messages: 23
Registered: September 2011

Junior Member

Thanks Michael (as always).
Can you please help me on how to put these messages in the report design itself ?

I am trying to restructure the design so that i can share it with you (give me a day or 2), but as I see, it can only be re-produced when there is large number of groups (say > 100)coupled with large amount of data. I will publish the design at the earliest for you to take a look at.
In addition, Java class is simply creating objects and running RunAndRenderTask; are there any parameters or attributes that I can set for performance ? I explored the forum but looks like all the attributes are preset - confused

Report message to a moderator

Re: BIRT Does not respond [message #1096955 is a reply to message #1096744]

Thu, 29 August 2013 04:05

Michael Williams

Messages: 1925
Registered: July 2009

Senior Member

There are lots of different script methods in the report. You could use System.out.println() to print to the command prompt when you reach a certain method in the report. This would give you an idea of where it's hanging up based on the last script method that you encounter. You might also look at the log files to see if there is anything in there that will help you figure out where it's running into issues.

Michael

Developer Evangelist, Silanis

Report message to a moderator

Re: BIRT Does not respond [message #1097351 is a reply to message #1096955]

Thu, 29 August 2013 15:35

Eclipse Beginner

Messages: 23
Registered: September 2011

Junior Member

cool, btw I timed it. I let the process go on and it returned in ~10 hours generating a report of around 5 MB. My analysis says 2 things - one spudsoft appears to have some lower hand on performance than the earlier BIRT (I might be wrong) and second, xlsx grouping function.
I opened one xlsx and it has a heavy grouping function in it. Is there a way to disable the grouping function ? I believe arctorus does that. Thoughts please...

Report message to a moderator

Re: BIRT Does not respond [message #1097501 is a reply to message #1097351]

Thu, 29 August 2013 20:28

Michael Williams

Messages: 1925
Registered: July 2009

Senior Member

Can you attach a sample report that shows your issue with the grouping function? Thanks! Smile

Michael

Developer Evangelist, Silanis

Report message to a moderator

Re: BIRT Does not respond [message #1098189 is a reply to message #1097501]

Fri, 30 August 2013 18:59

Eclipse Beginner

Messages: 23
Registered: September 2011

Junior Member

Here you go. If you open this sample you will see that excel groups it by itself.
But I got around it using ExcelEmitters.DisableGroup. Unfortunately it did not help with performance. I see there are too many calls like below, and when I time it against a small dataset the time shown in ODI query execution just goes 4 times and more....

I am new to this so am not able to make much sense out of below.. is there any thing that you can suggest I should try ? The same design works good with smaller datasets but as it grows it becomes very sad ..

Aug 30, 2013 1:47:19 PM org.eclipse.birt.data.engine.executor.cache.SmartCacheHelper populateData
INFO: MemoryCache is used
Aug 30, 2013 1:47:19 PM org.eclipse.birt.data.engine.executor.cache.SmartCacheHelper populateData
INFO: Time consumed by cache is: 0 second
Aug 30, 2013 1:47:19 PM org.eclipse.birt.data.engine.impl.QueryResults getResultIterator
INFO: ODI query execution: 143 ms

Attachment: sample report.xlsx
(Size: 8.91KB, Downloaded 183 times)

Report message to a moderator

Re: BIRT Does not respond [message #1098193 is a reply to message #1097501]

Fri, 30 August 2013 19:03

Eclipse Beginner

Messages: 23
Registered: September 2011

Junior Member

and my apologies, I think I have reached the same point which we are discussing on another thread: http://www.eclipse.org/forums/index.php/t/513229/

I did not realize that these will cross. So perhaps we can merge the two or the way you feel okay with..

Report message to a moderator