Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
See why IDC MarketScape names Qlik a 2025 Leader! Read more
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

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
Labels (4)
7 Replies
Anonymous
Not applicable
Author

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

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
Anonymous
Not applicable
Author

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


0683p000009MBKn.png    0683p000009MBDn.png     0683p000009MBDn.png    0683p000009MBCg.png
Anonymous
Not applicable
Author

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);
Anonymous
Not applicable
Author

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.
Anonymous
Not applicable
Author

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
Anonymous
Not applicable
Author

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

Massimo