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
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);
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.
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