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

Announcements
Write Table now available in Qlik Cloud Analytics: Read Blog
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?