topic Re: Problems using tFTPConnection in Talend Studio

Problems using tFTPConnection

Anonymous — Mon, 05 Aug 2019 05:42:31 GMT

Talend Version = 7.2.1

OS = Windows 10

Hello Experts out there,

I am trying to connect to a file server with using sftp over port 21. I am able to do it on various FTP Clients like FileZilla and WinSCP, (It connects in less than 5 seconds there.) While in Talend, it is taking 300 seconds to connect.

After connecting to FTP, I also need a tFTPGet and then I am closing the FTP connection. But it is throwing nullpointer exception in tFTPGet.

I am attaching the screenshot of my Job Design. Please help.

Thanks,

Jvalant.

Re: Problems using tFTPConnection

navds — Mon, 05 Aug 2019 12:07:12 GMT

Hi Jvalant,
It would be more helpful if you show screenshots of component configs.

Re: Problems using tFTPConnection

Anonymous — Mon, 05 Aug 2019 12:17:01 GMT

Attached here the tftpconnection component screenshot.

Untitled-1.png

Re: Problems using tFTPConnection

Anonymous — Wed, 07 Aug 2019 04:25:50 GMT

Hi,

You are getting Null pointer exception in Get component but you have provided the screen shot of the connection component.

Could you please cross check whether you have given values to all mandatory parameters in Get component? If you are not able to identify the null value, a screenshot of this component will be appreciated to do further analysis.

Warm Regards,
Nikhil Thampi

Please appreciate our Talend community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved

Re: Problems using tFTPConnection

Anonymous — Wed, 07 Aug 2019 05:14:26 GMT

Hi,

I would say there might be mistakes in tftpget component. That I can solve even later. Problem here is the tftpconnection taking 300 seconds to connect, whereas I am able to connect in less than 5 seconds from any ftp client.

Appreciate your help.

Thanks,

Jvalant.

Re: Problems using tFTPConnection

Anonymous — Wed, 07 Aug 2019 15:38:02 GMT

Hi,

Ideally it should connect within the same time frame like any other FTP clients. Are you using the same user to connect from other FTP clients? Unfortunately we will not be able to validate the steps over community considering the confidential nature related to server connectivity.

I would recommend you to raise a support case so that support team can check the steps you have followed in your job using remote sessions.

Warm Regards,
Nikhil Thampi

Please appreciate our Talend community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved

Re: Problems using tFTPConnection

Anonymous — Fri, 09 Aug 2019 10:31:12 GMT

Hi Nikhil,

I am recently told that the FTP connection I am using is FPTS (FTP over TLS). While I am able to login to FTPS with port 22 on my ftp client without any key file, Talend is asking for key files which I do not have, for FTPS connection.

Also I am told that I can generate key files via Java CAPS, I do not have it installed or either I am not able to install it on my PC.

Any help regarding how to generate FTPS keys would be appreciated.

Thanks,

Jvalant.

Re: Problems using tFTPConnection

Anonymous — Fri, 09 Aug 2019 15:09:20 GMT

Hi,

Could you please refer below Talend KB article?

https://community.talend.com/t5/Design-and-Development/Specifying-a-keystore-file-of-a-tFTPConnection-with-FTPS-support/ta-p/36645

Warm Regards,
Nikhil Thampi

Please appreciate our Talend community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved