Getting error to read file from FTP server using universal data reader

jagan

• October 14, 2015 00:00

• Answered

Follow

Hi Team,

I am trying to read file from FTP server but i am getting below error,

I have used below command to connect to FTP server,

ftp://username:password@server/path/filename.txt

--------------------------------------------------------------------------- Error details -----------------------------------------------------------------------------
Component [Read Statement ZIP File:READ_STATEMENT_ZIP_FILE] finished with status ERROR. (Out0: 0 recs)
Component pre-execute initialization failed.
File is unreachable: ftp://username:password@host/Test/PjcTx ... bor_18.zip
Cannot obtain connection input stream for URL 'ftp://username:password@host/Test/PjcTxnXfaceStageAll_labor_18.zip'. Make sure the URL is valid.
Connection timed out: connect
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------
ERROR [main] - Execution of graph failed !

I really appreciated your help.

Thanks,
Jagan.

• 

  Lukas Cholasta

  • October 15, 2015 07:25

  0

  Comment actions Permalink

  Hi Jagan
  
  In case you want to read some specific file in the zip, please use the following URL.
  

  zip:(ftp://user:pass@host:21/dir/file.zip)#some_file.txt

  
  More information on this topic can be found here.
  
  It is also advisable to use a port number as shown in the example above. If you are performing some other action with the zip and/or these solutions don't help you, please send me your graph (without passwords) and full log containing the error, preferably at debug level. Also, please describe what exactly you want to do with the zip.
  
  Best regards
• 

  jagan

  • October 15, 2015 09:15

  0

  Comment actions Permalink

  Hi Lukas Cholasta,
  
  I want to read the entire zip file.
  
  I am able to read the zip file from SFTP server by using below URL,
  
  sftp://username:password@host/Test/PjcT ... bor_18.zip
  
  
  but when I using FTP server it is getting error with same file.
  
  ftp://username:password@host/Test/PjcTx ... bor_18.zip
  
  
  
  Please do the needful.
  
  Thanks,
  Jagan.

  • Untitled.png
• 

  Lukas Cholasta

  • October 15, 2015 12:36

  0

  Comment actions Permalink

  Dear Jagan
  
  Thank you for the screenshot, however could you please send me the graph file itself (*.grf)? Also, please try to add the port number to the URL, so we can disprove it as the reason of this issue. But please, make sure you are using the correct port number.
  
  Thank you.
• 

  jagan

  • October 16, 2015 06:28

  0

  Comment actions Permalink

  Hi Lukas Cholasta,
  
  I have attached the .grf.
  
  Manually I am able to select the file from the server using clover etl but when I executing it is getting error.
  
  Thanks for your help.
  
  Thanks,
  Jagan.

  • Test.grf
• 

  Lukas Cholasta

  • October 19, 2015 08:20

  0

  Comment actions Permalink

  Hi Jagan
  
  This resembles a known Synology server issue. Can you confirm that you are using some Synology FTP solution? If so, then I can assure you it will be fixed in one of our future updates. If this is not your case, please let me know.
  
  I apologize for any inconvenience.

Please sign in to leave a comment.