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

CloverDX Platform
1

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.

2

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

3

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.

4

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.

5

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.

6

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.