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

Announcements
Join us in NYC Sept 4th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

[resolved] ERROR in FTP to local drive transfer (tFTPGet)

Hi, 
May be a newbie question but I am just getting started with Talend Open Studio. I am trying to FTP a file from a remote ftp server to my local drive. The job completes with error code = 0 (success). However I see an error tag on the tFTPGet component. Also the file does not get copied over from remote server to local drive. 
What am I doing wrong ? Screenshots attached.
Labels (2)
1 Solution

Accepted Solutions
Anonymous
Not applicable
Author

I downloaded the file successfully after "Pause Protection" on the Kaspersky Internet Security 2017. Kaspersky network protection blocks active ftp mode from Talend. Wierdly enough it allows from filezilla or filezilla implements it differently. Not sure. 
I'll now adjust kaspersky to allow active on 21 and re-enable protection. 
Thanks all for your time

View solution in original post

3 Replies
vapukov
Master II
Master II

in which mode You connect to this FTP normally?
is it FTP(port 21) or sFTP(port 22)?
if plain ftp:
- think ascii mode for binary file it is not right mode, change it
- is Your file really located in ROOT folder? (/game_bakup_1.db)
Anonymous
Not applicable
Author

in which mode You connect to this FTP normally?
is it FTP(port 21) or sFTP(port 22)?
if plain ftp:
- think ascii mode for binary file it is not right mode, change it
- is Your file really located in ROOT folder? (/game_bakup_1.db)


I am trying in ACTIVE mode and FTP (21)
I tried both in binary and ascii. It should be in Binary as i have BLOBs in the db file
My FTP user has a ftp home to blablablabla/backup set on user level thus for my user the home directory contains the file i am trying to ftp over to local. on Filezilla it looks like screenshot i attached.

I tried to check box "print error message" in ftp get. I see it says ACTIVE mode is not supported please use passive. However, I am connected to ftp server via filezilla using active(passive wont work). Passive is not supported by server due to security issues (number of ports open)
Anonymous
Not applicable
Author

I downloaded the file successfully after "Pause Protection" on the Kaspersky Internet Security 2017. Kaspersky network protection blocks active ftp mode from Talend. Wierdly enough it allows from filezilla or filezilla implements it differently. Not sure. 
I'll now adjust kaspersky to allow active on 21 and re-enable protection. 
Thanks all for your time