IBM Support

Streams with Excel export nodes fail with Insufficient memory for JVM

Troubleshooting


Problem

Attempts to run a stream with a script and Excel export nodes using IBM SPSS Modeler results in the error "Insufficient memory for JVM - please increase in jvm.cfg" Or sometimes you will see an error like this: Error: Internal error: JNI call failed: "AttachCurrentThread"

Symptom

Insufficient memory for JVM - please increase in jvm.cfg

Cause

The Excel export node is set to export 2003 formatted files but the script file exported the file with the extension of xlsx. Since many of these files are larger than an xls file will hold the balance appeared to be stored into the jvm memory and creating heapdump files.

Diagnosing The Problem

Evaluate stream fro Excel export nodes and scripts.

Resolving The Problem

Ensure that the Modeler script and the Excel Export node have matching file types.

Another option is to increase the JVM size in the jvm.cfg file.

The jvm.cfg file is by default found here:



C:\Program Files\IBM\SPSS\Modeler\<MODELER_VERSION_NUMBER>\config\jvm.cfg

First make sure that Modeler is not running and that you have permissions to edit the file.
Open jvm.cfg in a text editor and look for this line:

options, "-Xmx256m"

Change the numeric value in there to be something like 512 or 1024. For example like this:

options, "-Xmx512m"

[{"Product":{"code":"SS3RA7","label":"IBM SPSS Modeler"},"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Component":"Modeler","Platform":[{"code":"PF033","label":"Windows"}],"Version":"Not Applicable","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
16 June 2018

UID

swg21666158