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

Issues with downloading files using step - "Get a file with SFTP"

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Closed
    • Severity: Unknown
    • Resolution: Not a Bug
    • Affects Version/s: 4.4.0 GA (4.8.0 GA Suite Release)
    • Fix Version/s: None
    • Component/s: Job, Job Entry
    • 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.
    • Operating System/s:
      Windows Server 2008 R2 (64-bit)
    • Steps to Reproduce:
      Hide

      1. give sftp details to download files
      2. test connection
      3. try to download files without checking the option for "copy previous result to args"

      Show
      1. give sftp details to download files 2. test connection 3. try to download files without checking the option for "copy previous result to args"

      Description

      I am trying to download files from sftp location. I am getting following ERROR messages,

      2015/09/01 18:17:49 - Spoon - Starting job...
      2015/09/01 18:17:49 - get XML files from SFTP - Start of job execution
      2015/09/01 18:17:49 - get XML files from SFTP - Starting entry [Get a file with SFTP]
      2015/09/01 18:17:54 - Get a file with SFTP - ERROR (version 4.4.0-stable, build 17588 from 2012-11-21 16.02.21 by buildguy) : Error getting files from SFTP : 
      2015/09/01 18:17:54 - Get a file with SFTP - ERROR (version 4.4.0-stable, build 17588 from 2012-11-21 16.02.21 by buildguy) : 4: 
      2015/09/01 18:17:54 - Get a file with SFTP - ERROR (version 4.4.0-stable, build 17588 from 2012-11-21 16.02.21 by buildguy) : org.pentaho.di.core.exception.KettleJobException: 
      2015/09/01 18:17:54 - Get a file with SFTP - ERROR (version 4.4.0-stable, build 17588 from 2012-11-21 16.02.21 by buildguy) : 4: 
      2015/09/01 18:17:54 - Get a file with SFTP - ERROR (version 4.4.0-stable, build 17588 from 2012-11-21 16.02.21 by buildguy) : 
      2015/09/01 18:17:54 - Get a file with SFTP - ERROR (version 4.4.0-stable, build 17588 from 2012-11-21 16.02.21 by buildguy) : 
      2015/09/01 18:17:54 - Get a file with SFTP - ERROR (version 4.4.0-stable, build 17588 from 2012-11-21 16.02.21 by buildguy) : 	at org.pentaho.di.job.entries.sftp.SFTPClient.get(SFTPClient.java:212)
      2015/09/01 18:17:54 - Get a file with SFTP - ERROR (version 4.4.0-stable, build 17588 from 2012-11-21 16.02.21 by buildguy) : 	at org.pentaho.di.job.entries.sftp.JobEntrySFTP.execute(JobEntrySFTP.java:691)
      2015/09/01 18:17:54 - Get a file with SFTP - ERROR (version 4.4.0-stable, build 17588 from 2012-11-21 16.02.21 by buildguy) : 	at org.pentaho.di.job.Job.execute(Job.java:589)
      2015/09/01 18:17:54 - Get a file with SFTP - ERROR (version 4.4.0-stable, build 17588 from 2012-11-21 16.02.21 by buildguy) : 	at org.pentaho.di.job.Job.execute(Job.java:728)
      2015/09/01 18:17:54 - Get a file with SFTP - ERROR (version 4.4.0-stable, build 17588 from 2012-11-21 16.02.21 by buildguy) : 	at org.pentaho.di.job.Job.execute(Job.java:443)
      2015/09/01 18:17:54 - Get a file with SFTP - ERROR (version 4.4.0-stable, build 17588 from 2012-11-21 16.02.21 by buildguy) : 	at org.pentaho.di.job.Job.run(Job.java:363)
      2015/09/01 18:17:54 - Get a file with SFTP - ERROR (version 4.4.0-stable, build 17588 from 2012-11-21 16.02.21 by buildguy) : Caused by: 4: 
      2015/09/01 18:17:54 - Get a file with SFTP - ERROR (version 4.4.0-stable, build 17588 from 2012-11-21 16.02.21 by buildguy) : 	at com.jcraft.jsch.ChannelSftp.get(ChannelSftp.java:853)
      2015/09/01 18:17:54 - Get a file with SFTP - ERROR (version 4.4.0-stable, build 17588 from 2012-11-21 16.02.21 by buildguy) : 	at org.pentaho.di.job.entries.sftp.SFTPClient.get(SFTPClient.java:210)
      2015/09/01 18:17:54 - Get a file with SFTP - ERROR (version 4.4.0-stable, build 17588 from 2012-11-21 16.02.21 by buildguy) : 	... 5 more
      2015/09/01 18:17:54 - Get a file with SFTP - ERROR (version 4.4.0-stable, build 17588 from 2012-11-21 16.02.21 by buildguy) : Caused by: java.io.FileNotFoundException: C:\Program Files\Adaptive Data Agent\pdirunner\lib\null\test.txt (The system cannot find the path specified)
      2015/09/01 18:17:54 - Get a file with SFTP - ERROR (version 4.4.0-stable, build 17588 from 2012-11-21 16.02.21 by buildguy) : 	at java.io.FileOutputStream.open(Native Method)
      2015/09/01 18:17:54 - Get a file with SFTP - ERROR (version 4.4.0-stable, build 17588 from 2012-11-21 16.02.21 by buildguy) : 	at java.io.FileOutputStream.<init>(Unknown Source)
      2015/09/01 18:17:54 - Get a file with SFTP - ERROR (version 4.4.0-stable, build 17588 from 2012-11-21 16.02.21 by buildguy) : 	at java.io.FileOutputStream.<init>(Unknown Source)
      2015/09/01 18:17:54 - Get a file with SFTP - ERROR (version 4.4.0-stable, build 17588 from 2012-11-21 16.02.21 by buildguy) : 	at com.jcraft.jsch.ChannelSftp.get(ChannelSftp.java:829)
      2015/09/01 18:17:54 - Get a file with SFTP - ERROR (version 4.4.0-stable, build 17588 from 2012-11-21 16.02.21 by buildguy) : 	... 6 more
      2015/09/01 18:17:54 - get XML files from SFTP - Finished job entry [Get a file with SFTP] (result=[false])
      2015/09/01 18:17:54 - get XML files from SFTP - Job execution finished
      2015/09/01 18:17:54 - Spoon - Job has ended.
      

        Attachments

          Activity

            People

            Assignee:
            project admin Triage
            Reporter:
            kpanwala@adaptiveinisghts.com Kinjal Panwala
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

              Dates

              Created:
              Updated:
              Resolved: