TFTPPUT error in SFTP mode

One Star

TFTPPUT error in SFTP mode

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
One Star

Re: TFTPPUT error in SFTP mode

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

Re: TFTPPUT error in SFTP mode

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
----------------------------------------------------------
Talend | Data Agility for Modern Business
One Star

Re: TFTPPUT error in SFTP mode

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


          
Community Manager

Re: TFTPPUT error in SFTP mode

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);
----------------------------------------------------------
Talend | Data Agility for Modern Business
One Star

Re: TFTPPUT error in SFTP mode

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.
Community Manager

Re: TFTPPUT error in SFTP mode

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
----------------------------------------------------------
Talend | Data Agility for Modern Business
Four Stars

Re: TFTPPUT error in SFTP mode

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

Massimo