HTML report download fails if XML exceeds 1,05MB

Please help!

We use BIRT for a long time and found that HTML report loading fails if the resulting XML returned by BIRT exceeds 1,05MB. For some unknown reason the XML is fully downloaded, but browser is still waiting for something, and then after script max wait time ends Chrome shows empty page, and IE / Mozilla shows the report. Attached is a Network monitoring screenshot #1.

When searching for a solution, I recently found a report (http://www.hgsc.bcm.tmc.edu/y-chromosome-report/run?__report=report/Y-Chr_report.rptdesign). It is deployed on Tomcat, and it is working )) see screenshot #2.

I also found one more difference in reports behavoir. When browser is loading our report, the Network statistics is frozen till the end of the download - and then instantly it shows the downloaded size. In second case the number of downloaded bytes is gradually increasing.

I tried to:
- switch from BIRT 2.6 both to 4.2 and 2.3;
- switch from Tomcat 6 to Tomcat 7;
- setup Tomcat on Windows station (localhost);
- switch from Tomcat to Glassfish.

Nothing helps - just as the XML file size for HTML report exceeds 1,05MB, Chrome fails to show it, and any browser hangs tills script max execution time ends.

Please help! should you do any special settings for Tomcat / Java?

Find more posts tagged with

Comments

JasonW

Do you get anything in the tomcat logs? BTW do you have MaxPermGen set on the tomcat install. Take a look at the responses to this question for details.

http://stackoverflow.com/questions/6843893/birt-outofmemoryerror-permgen-space

Jason

r.bojur

Thanx for the reply, Jason 
 
<blockquote class='ipsBlockquote' data-author="'JasonW'" data-cid="107384" data-time="1342798430" data-date="20 July 2012 - 08:33 AM">
Do you get anything in the tomcat logs? </blockquote>
 
Nope, I was tailf-ing catalina.out, and no error is thrown when the report XML doesn't loading. The same thing with BIRT ReportEngine_*.log. 
 
BTW, on the 1,05MB limit - how I found it. I took a one-table report with a relatively large dataset and then gradually decreased it adding limit 3000... limit 2000... limit 1500... limit 1750 etc. When the resulting XML exceeds 1.05MB - browser fails loading it. It doesn't depend on report, deployment system (used both Windows localhost and Debian server), and even app server (Tomcat / Glassfish). 
 
<blockquote class='ipsBlockquote' data-author="'JasonW'" data-cid="107384" data-time="1342798430" data-date="20 July 2012 - 08:33 AM">
BTW do you have MaxPermGen set on the tomcat install. Take a look at the responses to this question for details. 
<a class='bbc_url' href='http://stackoverflow.com/questions/6843893/birt-outofmemoryerror-permgen-space'>http://stackoverflow.com/questions/6843893/birt-outofmemoryerror-permgen-space</a> </blockquote>
 
grepping MaxPermSize doesn't yield any results. I hardly think that it is an out of memory error - because the resulting XML is full and correct, IE and Firefox finally shows the full report. It seems that the problem is somewhere in the web server / HTTP session that is not ending correctly. 
 
And you know what the funniest thing is? When I preview the report in the RCP designer version the reposrt is showing ok, and really quickly (using Win=IE libraries I suppose). And when I right-click the preview and see its properties, I see something the following url: 
 
<a class='bbc_url' href='http://127.0.0.1:49749/viewer/run?__report=C:\glassfish3\glassfish\domains\birt\applications\birt-4.2\ab_list.rptdesign&__format=html&__svg=false&__locale=ru_RU&__timezone=Europe/Moscow&__masterpage=true&__rtl=false&__maxrows=2000&__maxrowlevels=50&__maxcolumnlevels=50&__cubememsize=10&__resourceFolder=C:\glassfish3\glassfish\domains\birt\applications\birt-4.2&__dpi=96&1040671600'>http://127.0.0.1:49749/viewer/run?__report=C:\glassfish3\glassfish\domains\birt\applications\birt-4.2\ab_list.rptdesign&__format=html&__svg=false&__locale=ru_RU&__timezone=Europe/Moscow&__masterpage=true&__rtl=false&__maxrows=2000&__maxrowlevels=50&__maxcolumnlevels=50&__cubememsize=10&__resourceFolder=C:\glassfish3\glassfish\domains\birt\applications\birt-4.2&__dpi=96&1040671600</a> 
 
And when I put that url to Chrome - it is working ok! that means that Eclipse internal web-server open at port 49749 is working, and has no such 1.05MB problem. Also that means that the problem is not in the BIRT itself.

JasonW

When you preview in the designer, all the data is not returned. There is a peference in birt preferences to control this. I am not sure why this is happening and I have not seen this error before. Can you post the report design? BTW I set that perm space on tomcat on every installation as it has been known to cause some weird issues in certain deployments.

Jason

r.bojur

<blockquote class='ipsBlockquote' data-author="'JasonW'" data-cid="107401" data-time="1342817285" data-date="20 July 2012 - 01:48 PM">
When you preview in the designer, all the data is not returned. There is a peference in birt preferences to control this. I am not sure why this is happening and I have not seen this error before. Can you post the report design? BTW I set that perm space on tomcat on every installation as it has been known to cause some weird issues in certain deployments. </blockquote>
 
Still nothing helps ((( Resetting JAVA_OPTS and adding MaxPermGen brought nothing. 
 
I attach the report, it is Oracle-based. But actually I have about 50 reports in a pool, and ALL (about 10) of them for which the XML returned by Ajax exceeds 1,05MB are not showing in Chrome.

JasonW

Are you able to test with a newer version of BIRT? Also can you log a bugzilla entry for this. Some of the devs may have an idea on what is happening.

Jason