Re: Java exception "java.lang.OutOfMemoryError: Java heap space" when calling ...

The number of rows required is less than the maximum allowed for an xlsx
workbook.

I reduced the selection criteria and checked the count with SQL and there
were 697,975 records.

I should not need to put these in multiple worksheets ?

Here is the error report produced by the job;

JVMDUMP039I Processing dump event "systhrow", detail
"java/lang/OutOfMemoryError" at 2017/09/13 18:41:08 - please wait.
JVMDUMP032I JVM requested System dump using
'//core.20170913.184108.49719.0001.dmp' in response to an event
JVMDUMP010I System dump written to //core.20170913.184108.49719.0001.dmp

JVMDUMP032I JVM requested Heap dump using
'//heapdump.20170913.184108.49719.0002.phd' in response to an event
JVMDUMP010I Heap dump written to //heapdump.20170913.184108.49719.0002.phd

JVMDUMP032I JVM requested Java dump using
'//javacore.20170913.184108.49719.0003.txt' in response to an event
JVMDUMP010I Java dump written to //javacore.20170913.184108.49719.0003.txt

JVMDUMP032I JVM requested Snap dump using
'//Snap.20170913.184108.49719.0004.trc' in response to an event
JVMDUMP039I Processing dump event "systhrow", detail
"java/lang/OutOfMemoryError" at 2017/09/13 18:43:12 - please wait.
JVMDUMP010I Snap dump written to //Snap.20170913.184108.49719.0004.trc

JVMDUMP013I Processed dump event "systhrow", detail
"java/lang/OutOfMemoryError".
JVMDUMP032I JVM requested Heap dump using
'//heapdump.20170913.184312.49719.0005.phd' in response to an event
JVMDUMP010I Heap dump written to //heapdump.20170913.184312.49719.0005.phd

JVMDUMP032I JVM requested Java dump using
'//javacore.20170913.184312.49719.0006.txt' in response to an event
JVMDUMP010I Java dump written to //javacore.20170913.184312.49719.0006.txt

JVMDUMP032I JVM requested Snap dump using
'//Snap.20170913.184312.49719.0007.trc' in response to an event
JVMDUMP010I Snap dump written to //Snap.20170913.184312.49719.0007.trc

JVMDUMP013I Processed dump event "systhrow", detail
"java/lang/OutOfMemoryError".

Thanks for your input.

Don Brown





From: "Jack Woehr" <jwoehr@xxxxxxxxxxxxxxxxxxxxxxxx>
To: "Midrange Systems Technical Discussion" <midrange-l@xxxxxxxxxxxx>
Date: 13/09/2017 10:30 PM
Subject: Re: Java exception "java.lang.OutOfMemoryError: Java heap
space" when calling ...
Sent by: "MIDRANGE-L" <midrange-l-bounces@xxxxxxxxxxxx>



*java -Xms4g -Xmx4g *... etc

On Wed, Sep 13, 2017 at 5:39 AM, Steve Pitcher <SPitcher@xxxxxxxxxxxx>
wrote:

Check the recovery parameter. You should be able to split the workbook
into multiple sheets to get past the error.



Steve Pitcher
iTech Solutions
Office: (203) 744-7854 Ext. 176
Mobile: (902) 301-0810
http://www.itechsol.com
http://www.iInTheCloud.com


-----Original Message-----
From: MIDRANGE-L [mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of
Don Brown
Sent: Wednesday, September 13, 2017 5:19 AM
To: Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxx>
Subject: Java exception "java.lang.OutOfMemoryError: Java heap space"

when

calling ...

V7R2 and current on PTF's

Using HSSFR4 with POI version 3.8 creating .xlsx spreadsheet

Getting a java out of memory error.

Spreadsheet contains approximately 1,000,000 records.

I believe I need to increase the default heap size for the JVM but so

far

google has failed me.

Has anyone come across this and solved it ?

Thank you


Don Brown

--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing
list To post a message email: MIDRANGE-L@xxxxxxxxxxxx To subscribe,
unsubscribe, or change list options,
visit: https://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx Before posting, please take a
moment to review the archives at https://archive.midrange.com/midrange-l

.

Please contact support@xxxxxxxxxxxx for any subscription related
questions.

Help support midrange.com by shopping at amazon.com with our affiliate
link: http://amzn.to/2dEadiD
--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing

list

To post a message email: MIDRANGE-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: https://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at https://archive.midrange.com/midrange-l.

Please contact support@xxxxxxxxxxxx for any subscription related
questions.

Help support midrange.com by shopping at amazon.com with our affiliate
link: http://amzn.to/2dEadiD