AnsweredAssumed Answered

Unable to access network folder using UNC

Question asked by saket Maheshwary on Nov 26, 2018

I am using PDI 8.1 CE in Windows environment. I am trying to access some network folders using UNC but getting below error:

File is there but PDI is not able to see it. One thing that I have observed is that where we get error java.io.FileNotFoundException instead of accessing the location with \\ at the beginning we have only one slash file:\servername not sure why PDI is doing that.

 

Searching through the web I have found that, this seems to be an issue in earlier versions of PDI but should have been fixed with PDI 5.0 stable version. Anyone else having this issue and knows how to get around it?

 

2018/11/26 07:09:21 - /Transformations/TestAnything - Dispatching started for transformation [/Transformations/TestAnything]

2018/11/26 07:09:21 - Microsoft Excel Input.0 - ERROR (version 8.1.0.0-365, build 8.1.0.0-365 from 2018-04-30 09.42.24 by buildguy) : Error processing row from Excel file [file:////servername/share/Development/Willow/HD-415_NYTax/AA_TEST_QA2_00968132.xls] : java.io.FileNotFoundException: file:\servername\share\Development\Willow\HD-415_NYTax\AA_TEST_QA2_00968132.xls (The filename, directory name, or volume label syntax is incorrect)

2018/11/26 07:09:21 - Microsoft Excel Input.0 - ERROR (version 8.1.0.0-365, build 8.1.0.0-365 from 2018-04-30 09.42.24 by buildguy) : java.io.FileNotFoundException: file:\servername\share\Development\Willow\HD-415_NYTax\AA_TEST_QA2_00968132.xls (The filename, directory name, or volume label syntax is incorrect)

2018/11/26 07:09:21 - Microsoft Excel Input.0 -     at java.io.FileInputStream.open0(Native Method)

2018/11/26 07:09:21 - Microsoft Excel Input.0 -     at java.io.FileInputStream.open(Unknown Source)

2018/11/26 07:09:21 - Microsoft Excel Input.0 -     at java.io.FileInputStream.<init>(Unknown Source)

2018/11/26 07:09:21 - Microsoft Excel Input.0 -     at java.io.FileInputStream.<init>(Unknown Source)

2018/11/26 07:09:21 - Microsoft Excel Input.0 -     at org.pentaho.di.trans.steps.excelinput.ExcelInput.getRowFromWorkbooks(ExcelInput.java:557)

2018/11/26 07:09:21 - Microsoft Excel Input.0 -     at org.pentaho.di.trans.steps.excelinput.ExcelInput.processRow(ExcelInput.java:435)

2018/11/26 07:09:21 - Microsoft Excel Input.0 -     at org.pentaho.di.trans.step.RunThread.run(RunThread.java:62)

2018/11/26 07:09:21 - Microsoft Excel Input.0 -     at java.lang.Thread.run(Unknown Source)

2018/11/26 07:09:21 - Microsoft Excel Input.0 - Finished processing (I=0, O=0, R=0, W=0, U=0, E=1)

2018/11/26 07:09:21 - /Transformations/TestAnything - Transformation detected one or more steps with errors.

2018/11/26 07:09:21 - /Transformations/TestAnything - Transformation is killing the other steps!

Outcomes