Uploaded image for project: 'Pentaho Data Integration - Kettle'
  1. Pentaho Data Integration - Kettle
  2. PDI-18303

Transformation Step: Get Sub folder names fails to retrieve any folders if user does not have access to a sub folder

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Closed
    • Severity: High
    • Resolution: Fixed
    • Affects Version/s: 8.3.0 GA
    • Fix Version/s: 9.2.0 GA
    • Component/s: Step
    • Labels:
    • Story Points:
      0
    • PDI Sub-component:
    • Notice:
      When an issue is open, the "Fix Version/s" field conveys a target, not necessarily a commitment. When an issue is closed, the "Fix Version/s" field conveys the version that the issue was fixed in.
    • Sprint Team:
      Tatooine (Maint)
    • Steps to Reproduce:
      Hide
      1. Setup Spoon 8.3
      2. Create a new transformation
      3. Add the Get Subfolder Names to the canvas
      4. Browse to your Documents folder
      5. Click on Add
      6. Click on Preview Rows
      7. Notice no rows are returned
      8. Check the Spoon log and notice the error

      Actual Results: no folders are displayed at all
      Expected Results: All sub-folders the user has access to should be returned

      Show
      Setup Spoon 8.3 Create a new transformation Add the Get Subfolder Names to the canvas Browse to your Documents folder Click on Add Click on Preview Rows Notice no rows are returned Check the Spoon log and notice the error Actual Results: no folders are displayed at all Expected Results: All sub-folders the user has access to should be returned

      Description

      When using the Get Subfolder Names step to retrieve folder names fails if one of the subfolders contains a space on its name has permissions denying access to the folder. The result is that you get an error, and no folders are displayed
      Customer gets Sorry no rows to preview but in the Spoon.log you can see the following stacktrace

      2019/08/20 12:44:13 - C:\Users\carlopez\Desktop\CASES_IN_PROGRESS\91049\GetSubFolderNames.ktr : GetSubFolderNames - Dispatching started for transformation [C:\Users\carlopez\Desktop\CASES_IN_PROGRESS\91049\GetSubFolderNames.ktr : GetSubFolderNames]
      2019/08/20 12:44:13 - FileInputList - ERROR (version 8.3.0.1-442, build 8.3.0.1-442 from 2019-07-26 04.28.57 by buildguy) : org.apache.commons.vfs2.FileSystemException: Could not find files in "file:///C:/Users/carlopezx/Documents".
      2019/08/20 12:44:13 - FileInputList - 	at org.apache.commons.vfs2.provider.AbstractFileObject.findFiles(AbstractFileObject.java:946)
      2019/08/20 12:44:13 - FileInputList - 	at org.apache.commons.vfs2.provider.AbstractFileObject.listFiles(AbstractFileObject.java:1560)
      2019/08/20 12:44:13 - FileInputList - 	at org.apache.commons.vfs2.provider.AbstractFileObject.findFiles(AbstractFileObject.java:921)
      2019/08/20 12:44:13 - FileInputList - 	at org.pentaho.di.core.fileinput.FileInputList.createFolderList(FileInputList.java:313)
      2019/08/20 12:44:13 - FileInputList - 	at org.pentaho.di.trans.steps.getsubfolders.GetSubFoldersMeta.getFolderList(GetSubFoldersMeta.java:427)
      2019/08/20 12:44:13 - FileInputList - 	at org.pentaho.di.trans.steps.getsubfolders.GetSubFolders.processRow(GetSubFolders.java:121)
      2019/08/20 12:44:13 - FileInputList - 	at org.pentaho.di.trans.step.RunThread.run(RunThread.java:62)
      2019/08/20 12:44:13 - FileInputList - 	at java.lang.Thread.run(Unknown Source)
      2019/08/20 12:44:13 - FileInputList - Caused by: org.apache.commons.vfs2.FileNotFolderException: Could not list the contents of "file:///C:/Users/carlopezx/Documents/My Music" because it is not a folder.
      2019/08/20 12:44:13 - FileInputList - 	at org.apache.commons.vfs2.provider.AbstractFileObject.getChildren(AbstractFileObject.java:1036)
      2019/08/20 12:44:13 - FileInputList - 	at org.apache.commons.vfs2.provider.AbstractFileObject.traverse(AbstractFileObject.java:121)
      2019/08/20 12:44:13 - FileInputList - 	at org.apache.commons.vfs2.provider.AbstractFileObject.traverse(AbstractFileObject.java:124)
      2019/08/20 12:44:13 - FileInputList - 	at org.apache.commons.vfs2.provider.AbstractFileObject.findFiles(AbstractFileObject.java:943)
      2019/08/20 12:44:13 - FileInputList - 	... 7 more
      

        Attachments

          Issue Links

            Activity

              People

              Assignee:
              vasco.marques Vasco Marques
              Reporter:
              clopez Carlos Lopez
              Votes:
              0 Vote for this issue
              Watchers:
              9 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved: