Discussions
Categories
Groups
Community Home
Categories
INTERNAL ENABLEMENT
POPULAR
THRUST SERVICES & TOOLS
CLOUD EDITIONS
Quick Links
MY LINKS
HELPFUL TIPS
Back to website
Home
Intelligence (Analytics)
Out Of Memory Error
joeguzman1
Hello,<br />
The database table I am retrieving contains over 8 million rows.<br />
<br />
<strong class='bbc'>Eclipse Indigo 3.7.1.r37x_v20110810-0800-7b7qFVtFEx2XnmZ4jlM5mjM </strong><br />
Build id: M20110909-1335<br />
eclipse.ini<br />
--launcher.XXMaxPermSize<br />
768m<br />
<br />
<strong class='bbc'>BIRT 3.7.1.v20110905-4607w31221A16</strong><br />
Build id: v20110913-1734<br />
<br />
<strong class='bbc'>BIRT JDBC Data Source</strong><br />
File: jtds-1.2.5.jar<br />
Driver Class: net.sourceforge.jtds.jdbc.Driver (v1.2)<br />
<br />
I created a simple report that just binds the data set to the List control <br />
<br />
<strong class='bbc'>Query</strong><br />
select JOBNAME<br />
from HISTORY<br />
<br />
<strong class='bbc'>Error</strong><br />
<strong class='bbc'><em class='bbc'>java.lang.ClassCastException: java.lang.OutOfMemoryError cannot be cast to java.lang.Exception</em></strong><br />
<br />
<strong class='bbc'>Is there a solution or a way to trap the memory error?</strong><br />
Limiting the Max number or rows to fetch from the data source is not an option.<br />
<br />
Thank you.
Find more posts tagged with
Comments
averma
What type of out of memory error are you getting - Heap or Maxperm gen?
joeguzman1
<strong class='bbc'>I have the Heap memory issue </strong><br />
<br />
I have changed eclipse.ini to:<br />
-Xmx1024m<br />
-XX:MaxPermSize=256m<br />
<br />
I have 70 reports. Only this report is causing this issue (<em class='bbc'>see attachment</em>)<br />
<br />
This report contains over 8 million rows.<br />
<br />
<strong class='bbc'>How can I make BIRT cache the dataset to improve memory usage?</strong>
averma
You may want to try suggestions in the following post:
http://www.eclipse.org/forums/index.php/mv/msg/197361/629285/#msg_629285
joeguzman1
<span style='font-size: 14px;'><strong class='bbc'>Memory Leak Detected!</strong></span><br />
<br />
Here's is proof that BIRT engine is leaking memory (<em class='bbc'>click on link below</em>). We already made some changes in the ReportGen to allow BIRT to consume more memory. If possible please provide a workaround until this bug is fixed. <br />
<br />
<a class='bbc_url' href='
https://bugs.eclipse.org/bugs/show_bug.cgi?id=371814'>https://bugs.eclipse.org/bugs/show_bug.cgi?id=371814</a><br
/>
<br />
Thank you
averma
Hi joeguzman1,
The bug was reported yesterday and I believe it is being looked into, appreciate your patience.
Ashwini
MarkW
I have also ran into a memory issue. I created a huge report using various datasets, javascript and embedded tables and charts per row. I then found the report was taking longer and longer to run as I kept adding more to the report. At that point is when I found tomcat memory running at about 2Gig. So I restarted tomcat and reran report and it shot up in resident memory. So then I back tracked. I started removing items from the report until all I had was a simple table that was loaded based on a simple query. I restarted tomcat and although it took running the report alot (since it is smaller now), the memory kept growing and never shrank.
