Talend Connect
Virtual Summit
JOIN US!
And visit the Customer
& Community Lounge.
May 27-28, wherever you are.

tFTPPut problem in 6.1.1

Highlighted
Six Stars
Six Stars

tFTPPut problem in 6.1.1

Hi all, we're hitting a problem when we try to do even simple file puts using the tFTPPut component.
I'm able to pull a file from a vendor in the FTPGet, but when I reference the exact same filemask entries I get an exception.


Exception in component tFTPPut_1

2: The system cannot find the file specified. 
at com.jcraft.jsch.ChannelSftp.throwStatusError(ChannelSftp.java:2846)
at com.jcraft.jsch.ChannelSftp._stat(ChannelSftp.java:2198)
at com.jcraft.jsch.ChannelSftp._stat(ChannelSftp.java:2215)
at com.jcraft.jsch.ChannelSftp.stat(ChannelSftp.java:2172)
at [...].tFTPPut_1Process(Illinois.java:1412)
at [...].tFTPGet_1Process(Illinois.java:1201)
at [...].tCheckpoint_1Process(Illinois.java:887)
at [...].runJobInTOS(Illinois.java:4689)
at [...].main(Illinois.java:4512)


Does anyone have any suggestions? I know the sftp connection is open, I've got it as a prejob before the main job checkpoint.

Highlighted
Moderator

Re: tFTPPut problem in 6.1.1

Hi,
The error indicates that it can't find the specified files in the path. How did you set remote directory in FTPPut component? It seems there is something wrong with remote directory.
Best regards
Sabrina
--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.
Highlighted
Six Stars
Six Stars

Re: tFTPPut problem in 6.1.1

Hi Sabrina, thank you for your reply.
We ended up walking through the Java and performing the sftp steps. The problem is the vendor monitors the directory and pulls the file before Talend has a chance to go in and rename the file to what is listed in the filemask. The component produces and error due to the vendor having already pulled the file, thus triggering the ComponentError path.
Since there is no option to skip the attempt to rename, we are simply going to keep additional backup copies of the files we are sending and assume the ComponentError and ComponentOk are both OK.
Highlighted
Moderator

Re: tFTPPut problem in 6.1.1

Hi,
Thanks for your feedback and sharing the solution with us.
Best regards
Sabrina
--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.

2019 GARTNER MAGIC QUADRANT FOR DATA INTEGRATION TOOL

Talend named a Leader.

Get your copy

OPEN STUDIO FOR DATA INTEGRATION

Kickstart your first data integration and ETL projects.

Download now

Best Practices for Using Context Variables with Talend – Part 2

Part 2 of a series on Context Variables

Blog

Best Practices for Using Context Variables with Talend – Part 1

Learn how to do cool things with Context Variables

Blog

Migrate Data from one Database to another with one Job using the Dynamic Schema

Find out how to migrate from one database to another using the Dynamic schema

Blog