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:
Exception in component tFTPPut_1 (job_name)
2: The message [/remote_directory/fileName_20180921.csv] is not extractable!
So far I haven't been able to find a solution. Has anyone else had this problem? What causes it?
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.
@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
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.
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.
@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?
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.
@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.
Talend named a Leader.
Kickstart your first data integration and ETL projects.
Part 2 of a series on Context Variables
Learn how to do cool things with Context Variables
Find out how to migrate from one database to another using the Dynamic schema