java.io.FileNotFoundException: file:\shared_drive\folder name\test.xlsx file:\shared_drive\folder name\test.xlsx

Pentaho BI Platform Tracking | Dizzy | 2 years ago
  1. 0

    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

    Pentaho BI Platform Tracking | 2 years ago | Dizzy
    java.io.FileNotFoundException: file:\shared_drive\folder name\test.xlsx file:\shared_drive\folder name\test.xlsx
  2. 0

    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

    Pentaho BI Platform Tracking | 2 years ago | Dizzy
    test.xlsx
  3. 0

    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

    Pentaho BI Platform Tracking | 3 years ago | felipe matheus rosa
    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
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    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

    Pentaho BI Platform Tracking | 3 years ago | felipe matheus rosa
    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
  6. 0

    Could not find Main Class [Résolu]

    commentcamarche.net | 5 months ago
    java.io.FileNotFoundException: CableType.xls

    1 unregistered visitors
    Not finding the right solution?
    Take a tour to get the most out of Samebug.

    Tired of useless tips?

    Automated exception search integrated into your IDE

    Root Cause Analysis

    1. java.io.FileNotFoundException

      file:\shared_drive\folder name\test.xlsx

      at org.apache.poi.ss.usermodel.WorkbookFactory.create()
    2. POI
      WorkbookFactory.create
      1. org.apache.poi.ss.usermodel.WorkbookFactory.create(WorkbookFactory.java:83)
      1 frame
    3. org.pentaho.di
      ExcelInputDialog$17.widgetSelected
      1. org.pentaho.di.trans.steps.excelinput.poi.PoiWorkbook.<init>(PoiWorkbook.java:69)
      2. org.pentaho.di.trans.steps.excelinput.WorkbookFactory.getWorkbook(WorkbookFactory.java:41)
      3. org.pentaho.di.ui.trans.steps.excelinput.ExcelInputDialog.getSheets(ExcelInputDialog.java:1886)
      4. org.pentaho.di.ui.trans.steps.excelinput.ExcelInputDialog$17.widgetSelected(ExcelInputDialog.java:1156)
      4 frames
    4. RWT
      Display.readAndDispatch
      1. org.eclipse.swt.widgets.TypedListener.handleEvent(Unknown Source)
      2. org.eclipse.swt.widgets.EventTable.sendEvent(Unknown Source)
      3. org.eclipse.swt.widgets.Widget.sendEvent(Unknown Source)
      4. org.eclipse.swt.widgets.Display.runDeferredEvents(Unknown Source)
      5. org.eclipse.swt.widgets.Display.readAndDispatch(Unknown Source)
      5 frames
    5. org.pentaho.di
      TransGraph.mouseDoubleClick
      1. org.pentaho.di.ui.trans.steps.excelinput.ExcelInputDialog.open(ExcelInputDialog.java:1184)
      2. org.pentaho.di.ui.spoon.delegates.SpoonStepsDelegate.editStep(SpoonStepsDelegate.java:124)
      3. org.pentaho.di.ui.spoon.Spoon.editStep(Spoon.java:8797)
      4. org.pentaho.di.ui.spoon.trans.TransGraph.editStep(TransGraph.java:3027)
      5. org.pentaho.di.ui.spoon.trans.TransGraph.mouseDoubleClick(TransGraph.java:744)
      5 frames
    6. RWT
      Display.readAndDispatch
      1. org.eclipse.swt.widgets.TypedListener.handleEvent(Unknown Source)
      2. org.eclipse.swt.widgets.EventTable.sendEvent(Unknown Source)
      3. org.eclipse.swt.widgets.Widget.sendEvent(Unknown Source)
      4. org.eclipse.swt.widgets.Display.runDeferredEvents(Unknown Source)
      5. org.eclipse.swt.widgets.Display.readAndDispatch(Unknown Source)
      5 frames
    7. org.pentaho.di
      Spoon.main
      1. org.pentaho.di.ui.spoon.Spoon.readAndDispatch(Spoon.java:1316)
      2. org.pentaho.di.ui.spoon.Spoon.waitForDispose(Spoon.java:7979)
      3. org.pentaho.di.ui.spoon.Spoon.start(Spoon.java:9310)
      4. org.pentaho.di.ui.spoon.Spoon.main(Spoon.java:654)
      4 frames
    8. Java RT
      Method.invoke
      1. sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
      2. sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
      3. sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
      4. java.lang.reflect.Method.invoke(Unknown Source)
      4 frames
    9. org.pentaho.commons
      Launcher.main
      1. org.pentaho.commons.launcher.Launcher.main(Launcher.java:92)
      1 frame