java.io.FileNotFoundException

There are no available Samebug tips for this exception. Do you have an idea how to solve this issue? A short tip would help users who saw this issue last week.

  • PDI fails to load any Excel input .xlsx file from a network share with the following example error message. The step with the same file IS working on version 4.4.0 and we had to rollback version because of this. 2014/01/07 15:38:37 - origem_fvd_mail.0 - ERROR (version 5.0.1-stable, build 1 from 2013-11-15_16-08-58 by buildguy) : org.pentaho.di.core.exception.KettleException: 2014/01/07 15:38:37 - origem_fvd_mail.0 - java.io.FileNotFoundException: file:\vlo-srvv-fs\publico\Comercial\IM\Nova Organização\Comum\Curva\CURVA.xlsx 2014/01/07 15:38:37 - origem_fvd_mail.0 - file:\vlo-srvv-fs\publico\Comercial\IM\Nova Organização\Comum\Curva\CURVA.xlsx 2014/01/07 15:38:37 - origem_fvd_mail.0 - 2014/01/07 15:38:37 - origem_fvd_mail.0 - at org.pentaho.di.trans.steps.excelinput.poi.PoiWorkbook.<init>(PoiWorkbook.java:78) 2014/01/07 15:38:37 - origem_fvd_mail.0 - at org.pentaho.di.trans.steps.excelinput.WorkbookFactory.getWorkbook(WorkbookFactory.java:38) 2014/01/07 15:38:37 - origem_fvd_mail.0 - at org.pentaho.di.trans.steps.excelinput.ExcelInput.getRowFromWorkbooks(ExcelInput.java:603) 2014/01/07 15:38:37 - origem_fvd_mail.0 - at org.pentaho.di.trans.steps.excelinput.ExcelInput.processRow(ExcelInput.java:471) 2014/01/07 15:38:37 - origem_fvd_mail.0 - at org.pentaho.di.trans.step.RunThread.run(RunThread.java:60) 2014/01/07 15:38:37 - origem_fvd_mail.0 - at java.lang.Thread.run(Thread.java:722) 2014/01/07 15:38:37 - origem_fvd_mail.0 - Caused by: java.io.FileNotFoundException: file:\vlo-srvv-fs\publico\Comercial\IM\Nova Organização\Comum\Curva\CURVA.xlsx 2014/01/07 15:38:37 - origem_fvd_mail.0 - at org.apache.poi.ss.usermodel.WorkbookFactory.create(WorkbookFactory.java:83) 2014/01/07 15:38:37 - origem_fvd_mail.0 - at org.pentaho.di.trans.steps.excelinput.poi.PoiWorkbook.<init>(PoiWorkbook.java:70) 2014/01/07 15:38:37 - origem_fvd_mail.0 - ... 5 more
    via by felipe matheus rosa,
  • PDI fails to load any Excel input .xlsx file from a network share with the following example error message. The step with the same file IS working on version 4.4.0 and we had to rollback version because of this. 2014/01/07 15:38:37 - origem_fvd_mail.0 - ERROR (version 5.0.1-stable, build 1 from 2013-11-15_16-08-58 by buildguy) : org.pentaho.di.core.exception.KettleException: 2014/01/07 15:38:37 - origem_fvd_mail.0 - java.io.FileNotFoundException: file:\vlo-srvv-fs\publico\Comercial\IM\Nova Organização\Comum\Curva\CURVA.xlsx 2014/01/07 15:38:37 - origem_fvd_mail.0 - file:\vlo-srvv-fs\publico\Comercial\IM\Nova Organização\Comum\Curva\CURVA.xlsx 2014/01/07 15:38:37 - origem_fvd_mail.0 - 2014/01/07 15:38:37 - origem_fvd_mail.0 - at org.pentaho.di.trans.steps.excelinput.poi.PoiWorkbook.<init>(PoiWorkbook.java:78) 2014/01/07 15:38:37 - origem_fvd_mail.0 - at org.pentaho.di.trans.steps.excelinput.WorkbookFactory.getWorkbook(WorkbookFactory.java:38) 2014/01/07 15:38:37 - origem_fvd_mail.0 - at org.pentaho.di.trans.steps.excelinput.ExcelInput.getRowFromWorkbooks(ExcelInput.java:603) 2014/01/07 15:38:37 - origem_fvd_mail.0 - at org.pentaho.di.trans.steps.excelinput.ExcelInput.processRow(ExcelInput.java:471) 2014/01/07 15:38:37 - origem_fvd_mail.0 - at org.pentaho.di.trans.step.RunThread.run(RunThread.java:60) 2014/01/07 15:38:37 - origem_fvd_mail.0 - at java.lang.Thread.run(Thread.java:722) 2014/01/07 15:38:37 - origem_fvd_mail.0 - Caused by: java.io.FileNotFoundException: file:\vlo-srvv-fs\publico\Comercial\IM\Nova Organização\Comum\Curva\CURVA.xlsx 2014/01/07 15:38:37 - origem_fvd_mail.0 - at org.apache.poi.ss.usermodel.WorkbookFactory.create(WorkbookFactory.java:83) 2014/01/07 15:38:37 - origem_fvd_mail.0 - at org.pentaho.di.trans.steps.excelinput.poi.PoiWorkbook.<init>(PoiWorkbook.java:70) 2014/01/07 15:38:37 - origem_fvd_mail.0 - ... 5 more
    via by felipe matheus rosa,
  • While using Microsoft Excel Input with Apache POI engine, if file location is on shared drive, eg. "\\shared drive\folder name\test.xlsx", after selecting input file and searching for sheets (get sheetnames), an error is thrown. It suggests the file is missing, but exactly the same file on the same location but saved as previous excel vercion - xls reads fine after changing engine to JXL org.pentaho.di.core.exception.KettleException: java.io.FileNotFoundException: file:\shared_drive\folder name\test.xlsx file:\shared_drive\folder name\test.xlsx at org.pentaho.di.trans.steps.excelinput.poi.PoiWorkbook.<init>(PoiWorkbook.java:77) at org.pentaho.di.trans.steps.excelinput.WorkbookFactory.getWorkbook(WorkbookFactory.java:41) at org.pentaho.di.ui.trans.steps.excelinput.ExcelInputDialog.getSheets(ExcelInputDialog.java:1886) at org.pentaho.di.ui.trans.steps.excelinput.ExcelInputDialog$17.widgetSelected(ExcelInputDialog.java:1156) at org.eclipse.swt.widgets.TypedListener.handleEvent(Unknown Source) at org.eclipse.swt.widgets.EventTable.sendEvent(Unknown Source) at org.eclipse.swt.widgets.Widget.sendEvent(Unknown Source) at org.eclipse.swt.widgets.Display.runDeferredEvents(Unknown Source) at org.eclipse.swt.widgets.Display.readAndDispatch(Unknown Source) at org.pentaho.di.ui.trans.steps.excelinput.ExcelInputDialog.open(ExcelInputDialog.java:1184) at org.pentaho.di.ui.spoon.delegates.SpoonStepsDelegate.editStep(SpoonStepsDelegate.java:124) at org.pentaho.di.ui.spoon.Spoon.editStep(Spoon.java:8797) at org.pentaho.di.ui.spoon.trans.TransGraph.editStep(TransGraph.java:3027) at org.pentaho.di.ui.spoon.trans.TransGraph.mouseDoubleClick(TransGraph.java:744) at org.eclipse.swt.widgets.TypedListener.handleEvent(Unknown Source) at org.eclipse.swt.widgets.EventTable.sendEvent(Unknown Source) at org.eclipse.swt.widgets.Widget.sendEvent(Unknown Source) at org.eclipse.swt.widgets.Display.runDeferredEvents(Unknown Source) at org.eclipse.swt.widgets.Display.readAndDispatch(Unknown Source) at org.pentaho.di.ui.spoon.Spoon.readAndDispatch(Spoon.java:1316) at org.pentaho.di.ui.spoon.Spoon.waitForDispose(Spoon.java:7979) at org.pentaho.di.ui.spoon.Spoon.start(Spoon.java:9310) at org.pentaho.di.ui.spoon.Spoon.main(Spoon.java:654) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source) at java.lang.reflect.Method.invoke(Unknown Source) at org.pentaho.commons.launcher.Launcher.main(Launcher.java:92) Caused by: java.io.FileNotFoundException: file:\shared_drive\folder name\test.xlsx at org.apache.poi.ss.usermodel.WorkbookFactory.create(WorkbookFactory.java:83) at org.pentaho.di.trans.steps.excelinput.poi.PoiWorkbook.<init>(PoiWorkbook.java:69) ... 27 more
    via by Dizzy,
  • While using Microsoft Excel Input with Apache POI engine, if file location is on shared drive, eg. "\\shared drive\folder name\test.xlsx", after selecting input file and searching for sheets (get sheetnames), an error is thrown. It suggests the file is missing, but exactly the same file on the same location but saved as previous excel vercion - xls reads fine after changing engine to JXL org.pentaho.di.core.exception.KettleException: java.io.FileNotFoundException: file:\shared_drive\folder name\test.xlsx file:\shared_drive\folder name\test.xlsx at org.pentaho.di.trans.steps.excelinput.poi.PoiWorkbook.<init>(PoiWorkbook.java:77) at org.pentaho.di.trans.steps.excelinput.WorkbookFactory.getWorkbook(WorkbookFactory.java:41) at org.pentaho.di.ui.trans.steps.excelinput.ExcelInputDialog.getSheets(ExcelInputDialog.java:1886) at org.pentaho.di.ui.trans.steps.excelinput.ExcelInputDialog$17.widgetSelected(ExcelInputDialog.java:1156) at org.eclipse.swt.widgets.TypedListener.handleEvent(Unknown Source) at org.eclipse.swt.widgets.EventTable.sendEvent(Unknown Source) at org.eclipse.swt.widgets.Widget.sendEvent(Unknown Source) at org.eclipse.swt.widgets.Display.runDeferredEvents(Unknown Source) at org.eclipse.swt.widgets.Display.readAndDispatch(Unknown Source) at org.pentaho.di.ui.trans.steps.excelinput.ExcelInputDialog.open(ExcelInputDialog.java:1184) at org.pentaho.di.ui.spoon.delegates.SpoonStepsDelegate.editStep(SpoonStepsDelegate.java:124) at org.pentaho.di.ui.spoon.Spoon.editStep(Spoon.java:8797) at org.pentaho.di.ui.spoon.trans.TransGraph.editStep(TransGraph.java:3027) at org.pentaho.di.ui.spoon.trans.TransGraph.mouseDoubleClick(TransGraph.java:744) at org.eclipse.swt.widgets.TypedListener.handleEvent(Unknown Source) at org.eclipse.swt.widgets.EventTable.sendEvent(Unknown Source) at org.eclipse.swt.widgets.Widget.sendEvent(Unknown Source) at org.eclipse.swt.widgets.Display.runDeferredEvents(Unknown Source) at org.eclipse.swt.widgets.Display.readAndDispatch(Unknown Source) at org.pentaho.di.ui.spoon.Spoon.readAndDispatch(Spoon.java:1316) at org.pentaho.di.ui.spoon.Spoon.waitForDispose(Spoon.java:7979) at org.pentaho.di.ui.spoon.Spoon.start(Spoon.java:9310) at org.pentaho.di.ui.spoon.Spoon.main(Spoon.java:654) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source) at java.lang.reflect.Method.invoke(Unknown Source) at org.pentaho.commons.launcher.Launcher.main(Launcher.java:92) Caused by: java.io.FileNotFoundException: file:\shared_drive\folder name\test.xlsx at org.apache.poi.ss.usermodel.WorkbookFactory.create(WorkbookFactory.java:83) at org.pentaho.di.trans.steps.excelinput.poi.PoiWorkbook.<init>(PoiWorkbook.java:69) ... 27 more
    via by Dizzy,
  • Could not find Main Class [Résolu]
    via by Unknown author,
    • java.io.FileNotFoundException: file:\vlo-srvv-fs\publico\Comercial\IM\Nova Organização\Comum\Curva\CURVA.xlsx file:\vlo-srvv-fs\publico\Comercial\IM\Nova Organização\Comum\Curva\CURVA.xlsx at org.pentaho.di.trans.steps.excelinput.poi.PoiWorkbook.<init>(PoiWorkbook.java:78) at org.pentaho.di.trans.steps.excelinput.WorkbookFactory.getWorkbook(WorkbookFactory.java:38) at org.pentaho.di.trans.steps.excelinput.ExcelInput.getRowFromWorkbooks(ExcelInput.java:603) at org.pentaho.di.trans.steps.excelinput.ExcelInput.processRow(ExcelInput.java:471) at org.pentaho.di.trans.step.RunThread.run(RunThread.java:60) at java.lang.Thread.run(Thread.java:722) Caused by: java.io.FileNotFoundException: file:\vlo-srvv-fs\publico\Comercial\IM\Nova Organização\Comum\Curva\CURVA.xlsx at org.apache.poi.ss.usermodel.WorkbookFactory.create(WorkbookFactory.java:83) at org.pentaho.di.trans.steps.excelinput.poi.PoiWorkbook.<init>(PoiWorkbook.java:70) ... 5 more

    Users with the same issue

    Unknown visitor
    Unknown visitor1 times, last one,