I am using Pentaho 8.2. In one of my transformation step, I am trying to read an Excel file from a remote shared path on another server. However, I am encountering the following error:
ERROR (version 8.2.0.0-342, build 8.2.0.0-342 from 2018-11-14 10.30.55 by
buildguy): Error processing row from Excel file
[file://///shared/excel/test.XLSX]:
org.pentaho.di.core.exception.KettleException:
java.io.FileNotFoundException: file:\shared/excel/test.XLSX
I have checked the shared path and it is correct. I am getting this error only for Excel files; files in .csv and .txt format are working fine with the same file path.
Am I missing a .jar file or is there something else I should check?