Hitachi Vantara Pentaho Community Forums
Results 1 to 2 of 2

Thread: File download issues

  1. #1
    Join Date
    Jul 2010
    Posts
    16

    Question File download issues

    I am facing below issues with my file download job.

    1. If I pass the wildcard then the file download is not showing any error but not downloading any files but the job is running infinite. I have to manually stop the job to exit.

    2. If I don't pass the wildcard then the files are downloaded successfully but the job is running infinite. I have to manually stop the job to exit.

    Note: I set the variables for the wildcard and the value of it is looking good. Even explicit file is not working. I am using get file with FTPS and i don't have any connection issues.

    I would appreciate any help on this regard.

    Thanks
    Murali

  2. #2
    Join Date
    Nov 2010
    Posts
    3

    Default

    An update to the following. I originally had the connection set to "Implicit TLS" and "Implicit SSL". Both of those produced the results below. However, after re-reading the other posts about this problem I changed the connection type to
    "Implicit TLS with crypted FTP connection" and that allowed the file transfer to work. This worked using wildcards and specifying the file name exactly.


    I am experiencing a similar problem with the "Get a file with FTPS" function.

    When I configure the job entry, the connection tests ok and the directory is found. Occasionally the job will terminate on its own without ever retrieving the file, but often I will have to terminate the Spoon session. The following is the debugging output from a sample run (addresses, directories and userid have been changed):
    2010/12/03 10:17:23 - Spoon - Starting job...
    2010/12/03 10:17:23 - LocalXEconnectionBeardsleee - Start of job execution
    2010/12/03 10:17:23 - LocalXEconnectionBeardsleee - exec(0, 0, START.0)
    2010/12/03 10:17:23 - START - Starting job entry
    2010/12/03 10:17:23 - LocalXEconnectionBeardsleee - Starting entry [Get a file with FTPS]
    2010/12/03 10:17:23 - LocalXEconnectionBeardsleee - exec(1, 0, Get a file with FTPS.0)
    2010/12/03 10:17:23 - Get a file with FTPS - Starting job entry
    2010/12/03 10:17:23 - Get a file with FTPS - Started FTPS job to xxx.xxx.xxx
    2010/12/03 10:17:23 - Get a file with FTPS - Start of FTPS job entry
    2010/12/03 10:17:23 - Get a file with FTPS - Opened FTPS connection to server [xxxx.xxx.xxx]
    2010/12/03 10:17:23 - Get a file with FTPS - set passive FTPS connection mode
    2010/12/03 10:17:23 - Get a file with FTPS - set timeout to 0
    2010/12/03 10:17:24 - Get a file with FTPS - logged in with user myuserid
    2010/12/03 10:17:24 - Get a file with FTPS - Current directory [/]
    2010/12/03 10:17:24 - Get a file with FTPS - Changed to directory [/XX/YYY/ZZ/out]
    2010/12/03 10:18:34 - Get a file with FTPS - ERROR (version 4.1.0-stable, build 14410 from 2010-11-16 16.43.28 by buildguy) : Error getting files from FTPS :
    2010/12/03 10:18:34 - Get a file with FTPS - ERROR (version 4.1.0-stable, build 14410 from 2010-11-16 16.43.28 by buildguy) : java.net.SocketException: Connection reset
    2010/12/03 10:18:34 - Get a file with FTPS - ERROR (version 4.1.0-stable, build 14410 from 2010-11-16 16.43.28 by buildguy) : Connection reset
    2010/12/03 10:18:34 - Get a file with FTPS - ERROR (version 4.1.0-stable, build 14410 from 2010-11-16 16.43.28 by buildguy) : Error quiting FTPS connection: null
    2010/12/03 10:18:34 - Get a file with FTPS - =======================================
    2010/12/03 10:18:34 - Get a file with FTPS - Nr errors : 1
    2010/12/03 10:18:34 - Get a file with FTPS - Nr files downloaded : 0
    2010/12/03 10:18:34 - Get a file with FTPS - =======================================
    2010/12/03 10:18:34 - LocalXEconnectionBeardsleee - Finished job entry [Get a file with FTPS] (result=[false])
    2010/12/03 10:18:34 - LocalXEconnectionBeardsleee - Job execution finished
    2010/12/03 10:18:34 - Spoon - Job has ended.

    Gene
    Last edited by beardsleee; 12-10-2010 at 01:26 PM.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Privacy Policy | Legal Notices | Safe Harbor Privacy Policy

Copyright © 2005 - 2019 Hitachi Vantara Corporation. All Rights Reserved.