tFTPPut is giving the following error: Exception in component tFTPPut_1 (job_name) 2: The message [/remote_directory/fileName_20180921.csv] is not extractable!

Highlighted
Five Stars

tFTPPut is giving the following error: Exception in component tFTPPut_1 (job_name) 2: The message [/remote_directory/fileName_20180921.csv] is not extractable!

I have a simple job that

1. Gets data from our database turns it into a delimited file

2. Puts that file in a local directory

3. Takes the file in the local directory and sends it to an SFTP site using tFTPPut

 

However, in the tFTPPut component I'm getting the following error:


[statistics] connected
Exception in component tFTPPut_1 (job_name)
2: The message [/remote_directory/fileName_20180921.csv] is not extractable!
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)

So far I haven't been able to find a solution. Has anyone else had this problem? What causes it?

Employee

Re: tFTPPut is giving the following error: Exception in component tFTPPut_1 (job_name) 2: The message [/remote_directory/fileName_20180921.csv] is not extractable!

Hi,

 

     For debugging purpose, could you please try to do the SFTP using Unix commands and see whether its working?

 

     I also saw a similar issue in github. Could you please refer the SFTP configuration details and it may not be a Talend issue. 

 

https://github.com/paramiko/paramiko/issues/194

 

Warm Regards,

 

Nikhil Thampi

Five Stars

Re: tFTPPut is giving the following error: Exception in component tFTPPut_1 (job_name) 2: The message [/remote_directory/fileName_20180921.csv] is not extractable!

@nikhilthampi, thanks for replying.

I used the command prompt to send the file and didn't receive an error, however, I am unable to check if the file was actually posted to the SFTP since they have a process on their side that automatically ingests files place there. My SFTP connection is through a public key. I'm not sure if that makes a difference

 

Employee

Re: tFTPPut is giving the following error: Exception in component tFTPPut_1 (job_name) 2: The message [/remote_directory/fileName_20180921.csv] is not extractable!

Hi,

 

     Could you please cross verify with the team handling the target system whether the file has reached the target server when you posted the file through manual SFTP? Based on the results, we will take the next step.

 

Warm Regards,

 

Nikhil Thampi

Five Stars

Re: tFTPPut is giving the following error: Exception in component tFTPPut_1 (job_name) 2: The message [/remote_directory/fileName_20180921.csv] is not extractable!

Hey @nikhilthampi,

 

It seems they are receiving the file. I'm guessing since they have a process on their side that automatically consumes the file Talend had no way to check that it was placed there.

Forteen Stars

Re: tFTPPut is giving the following error: Exception in component tFTPPut_1 (job_name) 2: The message [/remote_directory/fileName_20180921.csv] is not extractable!

@caelbu,can you check the user which you were using has all permissions to place file in remote directory? and also make sure that remote directory is present?

Manohar B
Don't forget to give kudos/accept the solution when a replay is helpful.
Employee

Re: tFTPPut is giving the following error: Exception in component tFTPPut_1 (job_name) 2: The message [/remote_directory/fileName_20180921.csv] is not extractable!

I agree @manodwhb.

 

The issue seems to be with user privileges. I hope you are trying with same user id which you are using to do manual FTP.

 

Warm Regards,

 

Nikhil Thampi

Five Stars

Re: tFTPPut is giving the following error: Exception in component tFTPPut_1 (job_name) 2: The message [/remote_directory/fileName_20180921.csv] is not extractable!

@manodwhb,

Yes, the directory exists and the user has the correct permissions. I'm able to use Winscp and manually add the file. (To confirm that the file was received I have to reach out to them since the automatically process it and removes it from the SFTP)


When I run the job I'm still getting the same error saying the file is not extractable but I was able to get them to confirm that they are receiving the file. So it seems that the job does work.
Forteen Stars

Re: tFTPPut is giving the following error: Exception in component tFTPPut_1 (job_name) 2: The message [/remote_directory/fileName_20180921.csv] is not extractable!

@caelbu,if the same file name are you trying to place in remote directory through talend ,remove the file,which is placed manually and execute the Talend Job.

Manohar B
Don't forget to give kudos/accept the solution when a replay is helpful.

2019 GARNER 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

What’s New for Talend Summer ’19

Watch the recorded webinar!

Watch Now

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

Best Practices for Using Context Variables with Talend – Part 4

Pick up some tips and tricks with Context Variables

Blog