Streams with Excel export nodes fail with Insufficient memory for JVM
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"
Insufficient memory for JVM - please increase in jvm.cfg
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:
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:
Change the numeric value in there to be something like 512 or 1024. For example like this: