topic Re: TFTPPUT error in SFTP mode in Talend Studio

TFTPPUT error in SFTP mode

Anonymous — Sat, 16 Nov 2024 11:27:40 GMT

hi all,
when trying to put and rename a csv file from m computer to a remote sftp server i get the error below:
Exception in component tFTPPut_2
2: No such file
at com.jcraft.jsch.ChannelSftp.throwStatusError(ChannelSftp.java:2297)
at com.jcraft.jsch.ChannelSftp._stat(ChannelSftp.java:1750)
at com.jcraft.jsch.ChannelSftp._stat(ChannelSftp.java:1767)
at com.jcraft.jsch.ChannelSftp.stat(ChannelSftp.java:1724)
at alta_2409.exportcustomformedenred_0_1.exportCustomFormEdenred.tFTPPut_2Process(exportCustomFormEdenred.java:2116)
at alta_2409.exportcustomformedenred_0_1.exportCustomFormEdenred.tMysqlInput_1Process(exportCustomFormEdenred.java:1816)
at alta_2409.exportcustomformedenred_0_1.exportCustomFormEdenred.runJobInTOS(exportCustomFormEdenred.java:2861)
at alta_2409.exportcustomformedenred_0_1.exportCustomFormEdenred.main(exportCustomFormEdenred.java:2673)
What could be the reason ?
Best Regards

Re: TFTPPUT error in SFTP mode

Anonymous — Tue, 21 Oct 2014 10:31:12 GMT

Just to add that the tftpconnection with sftp mode is working the issue is only on the tftpput !

Re: TFTPPUT error in SFTP mode

Anonymous — Tue, 21 Oct 2014 10:34:35 GMT

Can you please upload some screenshots of your job? that might be helpful for us to find out the cause of the issue.
Best regards
Shong

Re: TFTPPUT error in SFTP mode

Anonymous — Tue, 21 Oct 2014 10:42:56 GMT

Hi shong,
please find the screenshots with a focus on each key component: tftpconnection, tfileoutputdelimieted and tftpput
regards

Re: TFTPPUT error in SFTP mode

Anonymous — Tue, 21 Oct 2014 12:54:54 GMT

Hi
To debug the problem, use a tFileList to iterate the csv files in the specified directory and print the file name before tFTPPut component to check if there really exists files, for example:
...tFileOutputDelimited
|
onsubjobok
|
tFlieList--iterate-->tJava
on tjava:
String filename=((String)globalMap.get("tFileList_1_CURRENT_FILE"));
System.out.println(filename);

Re: TFTPPUT error in SFTP mode

Anonymous — Tue, 21 Oct 2014 13:24:33 GMT

Hi shong,
the file exists in the directory, here is the result of the job execution:
Démarrage du job exportCustomFormEdenred a 14:23 21/10/2014.
connecting to socket on port 3425
connected
SFTP tFTPconnection ok
export1610.csv
disconnected
Job exportCustomFormEdenred terminé à 14:23 21/10/2014.

Re: TFTPPUT error in SFTP mode

Anonymous — Fri, 24 Oct 2014 11:30:54 GMT

Hi sofbar
Which version are you using? I have no idea why it can't find the file right now, would you mind sending me your job for further investigation?
Best regards
Shong

Re: TFTPPUT error in SFTP mode

Anonymous — Thu, 11 Dec 2014 10:52:27 GMT

I also have this problem, have you found an alternative solution?

Massimo