CODEWITHSUNDEEP
pentahokettle
tester
tester

Reputation: 223

Unable to open excel (.xlsx) file in pentaho spoon

I have an excel sheet (.xlsx format). But when I try opening it using "ExcelInput", I get

Unable to opendialog for this step.
java.lang.OutOfMemoryError: GC overhead limit exceeded error

error. I have enabled the "Excel 2007 XLSX (Apache POI)" in content as well.

Upvotes: 0

Views: 7053

Answers (2)

Pantelis Natsiavas
Pantelis Natsiavas

Reputation: 5369

If you use the Spoon client (i.e. the default application used when running the Pentaho Data Integration - PDI), you can change the parameters in Spoon.bat (if you use windows) or Spoon.sh (if you use unix). The java memory parameters are Xms and Xmx. You would find them in a statement like the following:

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

After changing the value, you should restart spoon.

Upvotes: 2

Rishu S
Rishu S

Reputation: 3968

java.lang.OutOfMemoryError: GC overhead limit exceeded error

This error occurs especially when the process is out of Memory. It means that Garbage Collection(GC) has been trying to free the memory but is unable to do so. Check this article for more.

The possible solution is to increase the memory size of the application, Kettle in this case. You can do so by editing the "kitchen.sh / pan.sh" or "kitchen.bat / pan.bat" file located inside the "../pentaho/design-tools/data-integration". Increase the JAVAMAXMEM number to larger number maybe 1024.

Check the image as below:

enter image description here

Hoping this might help you in reading the excel file :)

Upvotes: 3

Related Questions