How to edit knime.in file to change the memory

[sgilmour]

Hi,
I added the XLS Cell Formatter to my workflow so I could wrap the data which I believe the wrap option is the same as wrap text in Excel. When I execute the XLS Formatter (apply) node workflow I am getting a execute failed: Java heap space error.
I did some reading in the forum and it was recommended to change the memory to write table to disc.
I did that and it didn’t work. The only other option I read was to edit the KNIME.IN file. How would I go about doing that or is there another option I should explore first.

[quaeler]

Your .ini file should look mostly like this:

algebraic:~ loki$ more /Applications/KNIME\ 4.1.0.app/Contents/Eclipse/Knime.ini 
-startup
../Eclipse/plugins/org.eclipse.equinox.launcher_1.4.0.v20161219-1356.jar
--launcher.library
../Eclipse/plugins/org.eclipse.equinox.launcher.cocoa.macosx.x86_64_1.1.551.v20171108-1834
-vm
../Eclipse/plugins/org.knime.binary.jre.macosx.x86_64_1.8.0.202-b08/jre/Home/lib/jli/libjli.dylib
-vmargs
-server
-Dsun.java2d.d3d=false
-Dosgi.classloader.lock=classname
-XX:+UnlockDiagnosticVMOptions
-XX:+UnsyncloadClass
-XX:+UseG1GC
-Dsun.net.client.defaultReadTimeout=0
-XX:CompileCommand=exclude,javax/swing/text/GlyphView,getBreakSpot
-Xmx2048m
-XstartOnFirstThread
-Xdock:icon=../Resources/Knime.icns
-Dorg.eclipse.swt.internal.carbon.smallFonts
algebraic:~ loki$ 

The line you’re interested in is the one starting -Xmx - in the above example it is allocating 2048MB. You can use either m or g in your specification (to denote MB or GB.)