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

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
WSyahirah21
Creator
Creator

Check File Exists in Remote Server

I am currently trying to check if a file is exists in my remote dev server or not. For job execution, I set the Target Exe to my dev server already, instead of localhost. My task should be:

checkFileExists:

if not exist --> create file

if exists--> do something

 

I know I can use component tFTPFileExist in TOS to check the file in dev server. However, i need to bypass the ProxyJump first before can access the dev server, saying:

ProxyJump IP: 1.1.1.2 port 2000

dev server ip : 1.1.1.3 port 2000

 

Im so confused if I can use

tFTPFileExist to complete this task and which IP should I use to do so. Ive tried using dev server Ip however it returns the following error.

 

java.net.ConnectException: Connection refused (Connection refused)

 

I also tried to use the existing connection setting for tFTPFileExist as the TOS ald connected to dev server so I assume it can directly use the connection, however the component list is empty so Im unable to do so.

 

0695b00000N3QYmAAN.png

Labels (6)
2 Replies
Anonymous
Not applicable

Hello,

The tFTPFileExists component works with directories since V 7.0.1.

Here is an external Java article about: Java FTP Check if a directory or file exists on server

Let us know if that helps for your use case.

https://www.codejava.net/java-se/ftp/determine-if-a-directory-or-file-exists-on-ftp-server

Best regards

Sabrina

WSyahirah21
Creator
Creator
Author

Hi Sabrina. thanks, does it works with proxyHost? I need to use the proxyHost first before setting it up to Hostname of server. However, now I received this error -> tFTPFileExist_1 - Can't create connection: Reply from SOCKS server has bad version.

 

Is there any articles or documentation that refers to the connection of tFTPFileExists to proxyHost?