0

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?

Improve this question
3
  • Might the issue not be in another part of you path? for example the extention in uppercase? Doesn't seem to me that your missing a jar. Then you would not get an IO-error like this. Commented Feb 19, 2024 at 12:44
  • Seems like Pentaho cannot process remote .xlsx files. The only workaround that worked for me was to copy the .xlsx to the server where Pentaho is installed. Commented Feb 20, 2024 at 14:50
  • Pentaho (PDI) can easily handle excel files on other servers... Commented Feb 26, 2024 at 8:53
Related questions
0
How to delete remote file using Kettle Pentaho
0
How to copy files in local folder to sftp using pentaho copy file step
0
How do I do my Pentaho Report take the Excel datasource file along to BA/BI Server?
Load 6 more related questions Show fewer related questions

0

Reset to default

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.