Re: POI Out of memory error

[Justin Taylor <jtaylor.0ab@xxxxxxxxx>]

You'll need to set a JVM envvar before starting the JVM:
-Xmx00000M;
Where the zeroes represent the memory in MB.

The envvar is QIBM_RPG_JAVA_PROPERTIES.

Check out the InfoCenter for more details.


HTH


On Thu, Sep 25, 2025 at 12:21 PM DEnglander--- via MIDRANGE-L <
midrange-l@xxxxxxxxxxxxxxxxxx> wrote:

> I am using POI to create a spreadsheet. This is a large spreadsheet, about
> 375,000 rows and 15 columns.
>
> The job crashes with this message in the joblog.
>
>
> JVMDUMP055I Processing dump event "systhrow", detail
>   "java/lang/OutOfMemoryError", exception "Java heap space" at 2025/09/25
>   11:51:58 - please wait.
>
>
> Is it possible to increase the heap space when running POI? I'd like to
> increase it just for this job, if possible. The program uses
> ss_begin_object_group  with a parameter value of  3,000,000  when it
> starts to create the spreadsheet.
>
> No matter how much this parameter value increases, I still get the crash
> at the approximate same row.
>
> We're running POI 3.12
>
> Any ideas?
>
> Thank you,
>
> Doug