Pentaho Data Integration: Increasing the memory limit


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


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


Pentaho Data Integration on Windows OS


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.
Have more questions? Submit a request


Article is closed for comments.