Pentaho Data Integration: Increasing the memory limit

Question 

When running our Pentaho Standard Sync we're seeing the following error message:

 Java.Lang.OutOfMemory 

Is it possible to change the memory limit of the process?

Environment

Pentaho Data Integration on Windows OS

Answer

Yes, you can increase the memory limit by updating the spoon.bat file.

To increase the Pentaho Data Integration memory limit:

1. In the <pentaho directory>/data-integration folder, select the spoon.bat file.
2. Locate the following line:

   if "%PENTAHO_DI_JAVA_OPTIONS%"=="" set PENTAHO_DI_JAVA_OPTIONS="-Xms1024m" "-Xmx2048m" "-XX:MaxPermSize=256m"

3. Double the Xms and Xmx values.
   • You can increase by more if needed and if there are enough system resources, but doubling is usually a good start.
4. Save and close the file.