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

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Showing results for 
Search instead for 
Did you mean: 
Sanjay5
Contributor III
Contributor III

Question on tFTPPut

I am trying to transfer a file to FTP location:
Files on SFT servers are stored with a Unique tracking number which will be attached with the file with format filename#<trackingid>. 

  • Now i am trying to transfer a file to server, "DECRYPT.FILE"

  • Server is automatically changing the name of the file to "DECRYPT.FILE#ABC1111"

  • Even though transfer is successful, I receive below error in Talend job 

[ERROR]: filecomponenttesting.sftp_connectivity_0_

1.sFTP_Connectivity - tFTPPut_2 - File transfer fail./inbox/DECRYPT.FILE is not a valid file path
Exception in component tFTPPut_2

2: /inbox/DECRYPT.FILE is not a valid file path

 

I think after successful transfer, Job is checking for the file "DECRYPT.FILE" in FTP server and not able to find the file and it is throwing error.

Any idea how to resolve this issue?

Labels (2)
1 Solution

Accepted Solutions
Anonymous
Not applicable

Hi
Move tFTPPut to a child job, use a tRunJob to call this child job in the main job, uncheck the 'die on error' option on tRunJob. In this case, the main job always returns success status even though child job has error.

Regards
Shong

View solution in original post

10 Replies
cterenzi
Specialist
Specialist

It sounds like you're transferring files to a Managed File Transfer site, which can handle incoming files in this manner.  Since what you're seeing is expected behavior on the part of the destination server, you'd have to catch the exception and do your own validation that the file transferred successfully.

Sanjay5
Contributor III
Contributor III
Author

Thanks for the response,

 

If job is running in TAC, it would always say that job is "failed".

 

Do you have any suggestion, how can I manage that failure.

cterenzi
Specialist
Specialist

You can configure a tLogCatcher component to catch Java exceptions, but I'm not familiar with how that interacts with job status in TAC.

Sanjay5
Contributor III
Contributor III
Author

Thanks,

 

I will check if I can work to catch the exception.

 

 

Anonymous
Not applicable

Hello,

Could you please indicate what's talend build version you are using? Can you execute your FTP job successfully in studio? Does this job only fail in TAC? Screenshots of job setting will be preferred.

Best regards

Sabrina

Sanjay5
Contributor III
Contributor III
Author

I am using enterprise version of Big Data 6.2.1

Job is failing in both Studio and TAC.

Please find attached Screen shot

 

 


Error Message.docx
Sanjay5
Contributor III
Contributor III
Author

Uploaded the job setting screenshot as well


Error Message.docx
Anonymous
Not applicable


stamrake wrote:

Exception in component tFTPPut_2

2: /inbox/DECRYPT.FILE is not a valid file path

 

I think after successful transfer, Job is checking for the file "DECRYPT.FILE" in FTP server and not able to find the file and it is throwing error.

Any idea how to resolve this issue?


Hi stamrake 

The file has been transferred successfully to FTP server, it seems the component program is still trying to read the old file name on server and throws the error because the file name has been renamed to a new one by the server. If you are a Java developer, you can debug the Job code and check which line throws the error.

 
Does this error affect your business logic or the next step?
Do you want the job to ignore this error and return the status as success? If so, you can eliminate it by redesign the job.
 

Shong

Sanjay5
Contributor III
Contributor III
Author

Thanks Shong for the response,

 

The only issue I would face is my job would fail in TAC.

If I want to ignore this error and return the status a success, what could be the change in the job?

 

Regards,

Sanjay