IBM Support

Streams with Excel export nodes fail with Insufficient memory for JVM

Technote (troubleshooting)


Problem(Abstract)

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"

Related information

Need more help? Our Modeler forum is Live!

Document information

More support for: SPSS Modeler
Modeler

Software version: Not Applicable

Operating system(s): Windows

Reference #: 1666158

Modified date: 07 September 2016