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

Support/help with CloverETL (4.9) and CloverDX (5.0 or newer) implementation problems

jagan
Posts: 12
Joined: Tue Aug 19, 2014 2:33 pm

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

Postby jagan » Wed Oct 14, 2015 7:44 am

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:[email protected]/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:[email protected]/Test/PjcTx ... bor_18.zip
Cannot obtain connection input stream for URL 'ftp://username:[email protected]/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.

cholastal
Posts: 137
Joined: Tue Sep 01, 2015 1:22 pm

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

Postby cholastal » Thu Oct 15, 2015 8:25 am

Hi Jagan

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

Code: Select all

zip:(ftp://user:[email protected]: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

---
Lukas Cholasta
CloverCARE Support
CloverDX

Visit us online at http://www.cloverdx.com

jagan
Posts: 12
Joined: Tue Aug 19, 2014 2:33 pm

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

Postby jagan » Thu Oct 15, 2015 10:15 am

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:[email protected]/Test/PjcT ... bor_18.zip


but when I using FTP server it is getting error with same file.

ftp://username:[email protected]/Test/PjcTx ... bor_18.zip



Please do the needful.

Thanks,
Jagan.
Attachments
Untitled.png
Untitled.png (68.2 KiB) Viewed 4935 times

cholastal
Posts: 137
Joined: Tue Sep 01, 2015 1:22 pm

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

Postby cholastal » Thu Oct 15, 2015 1:36 pm

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.

---
Lukas Cholasta
CloverCARE Support
CloverDX

Visit us online at http://www.cloverdx.com

jagan
Posts: 12
Joined: Tue Aug 19, 2014 2:33 pm

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

Postby jagan » Fri Oct 16, 2015 7:28 am

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.
Attachments
Test.grf
(2.61 KiB) Downloaded 239 times

cholastal
Posts: 137
Joined: Tue Sep 01, 2015 1:22 pm

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

Postby cholastal » Mon Oct 19, 2015 9:20 am

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.

---
Lukas Cholasta
CloverCARE Support
CloverDX

Visit us online at http://www.cloverdx.com


cron