topic Problem with tFTPGET (STAT ERROR) in Talend Studio

Problem with tFTPGET (STAT ERROR)

Hamza011 — Mon, 15 Jul 2024 13:12:19 GMT

i have an issue with tFTPGet when moving files from SFTP to local directory, it works for the first iterate but it doesnt work for the second, i got this error :

Exception in component tFTPGet_1
3: STAT error
at com.jcraft.jsch.ChannelSftp.throwStatusError(ChannelSftp.java:2827)
at com.jcraft.jsch.ChannelSftp._stat(ChannelSftp.java:2195)
at com.jcraft.jsch.ChannelSftp.cd(ChannelSftp.java:344)

Re: Problem with tFTPGET (STAT ERROR)

Hamza011 — Mon, 29 Jul 2024 15:52:39 GMT

please some support for this issue

Re: Problem with tFTPGET (STAT ERROR)

Xiaodi_Shi — Tue, 30 Jul 2024 06:11:40 GMT

Hello,

From your error message printed on console, we see you introduced tJava component in your workflow and got java.lang.NullPointerException issue.

Please go to the 'Code' tab to see if there will be the line with the red error. You can inspect the generated Java code there.

Best regards

Sabrina

Re: Problem with tFTPGET (STAT ERROR)

Shicong_Hong — Tue, 30 Jul 2024 07:37:23 GMT

@Hamza011 can you share a screenshot of basic settings of tFTPGet? For debugging, only keep tFTPList--iterate--tFTPGet, deactivate other components to see if the problem still exists?

Re: Problem with tFTPGET (STAT ERROR)

Hamza011 — Tue, 30 Jul 2024 09:36:57 GMT

the issue still exists :

Re: Problem with tFTPGET (STAT ERROR)

jlolling — Wed, 31 Jul 2024 11:06:08 GMT

A STAT error means the file or directory which should be downloaded does not exists anymore on the server. You change to a directory and it looks like this directory does not exist. Perhaps it is a problem from where you are coming and how to reach your desired folder.

Or do you have checked no other process is working with your server files and potentially moves the away?

Re: Problem with tFTPGET (STAT ERROR)

jlolling — Wed, 31 Jul 2024 11:11:39 GMT

One strange thing is also the tFTPFileList component. Please take care the option "File detail" is unchecked. Unfortunately this option cause the file name delivered by the return value CURRENT_FILE to become the file string with file rights and attributes + file name itself. Clearly this cannot be used later as file name to download.

Talend had set this option to be checked per default in a former update and damaged this way a lot of jobs.