Another Out Of Memory Isue

[Jacob J Steijn <js...@csc.com>]

I have a spreadsheet generated by Excel 2003 that reliably triggers POI 
HSSF to ask for all the memory my JVM has to give and then asks for more, 
causing a heap dump etc.  I have not seen this in bugtrack or on the user 
lists - for small sheets - and wonder if perhaps this is a unique error.

My spreadsheet is only 22 records, and about 11 columns. All data is 
general or text format. My application is running under Java 1.4, a 2GB 
JVM on a quad processor server with 8 GB of physical memory. No other 
applications on the server. The application is IBM Maximo Asset Manager 
6.2 on a Websphere 6.0.2_27  application server.

Bugtrack  has many complaints about how HSSF needs lots of memory and runs 
out of memory when processing large sheets, but 22 lines with 9 to 11 
columns? That is rather small.

I can provide the sheet or a hex format dump if that is useful to anyone 
who would like to look into this more deeply. I doubt that it is usefule 
to attach the file and send to the list.

Jacob Steijn
Application Specialist
CSC
400 Commerce Dr. Newark DE 19713 USA
GTS  |  office: 302.391.7712 |  mobile: 302.359.4058 |  AIM: cscjjs | 
email: jsteijn@csc.com  | www.csc.com



This is a PRIVATE message. If you are not the intended recipient, please 
delete without copying and kindly advise us by e-mail of the mistake in 
delivery. 
NOTE: Regardless of content, this e-mail shall not operate to bind CSC to 
any order or other contract unless pursuant to explicit written agreement 
or government initiative expressly permitting the use of e-mail for such 
purpose.

Re: Another Out Of Memory Isue

[Josh Micich <jo...@gmail.com>]

There was a bug fixed recently that sounded similar to this:
https://issues.apache.org/bugzilla/show_bug.cgi?id=48085

However, in that case the file could not even be opened by Excel.  It
sounds like your file can be opened by Excel OK. (Is this correct?)

> I can provide the sheet or a hex format dump if that is useful to anyone
> who would like to look into this more deeply. I doubt that it is usefule
> to attach the file and send to the list.

Sure - an XLS file that reproduces the problem would be very useful.
A hex dump is way less so, but a stack trace would be handy.  You can
add these to a new bugzilla entry.

-cheers
Josh

---------------------------------------------------------------------
To unsubscribe, e-mail: user-unsubscribe@poi.apache.org
For additional commands, e-mail: user-help@poi.apache.org