Qlik FTP/SFTP Connection Issue

[Mahaboob_Syed]

Hello Community

I'm facing attached error while trying to fetch some files using SFTP over. The web connector is configured as service on the server.

Any inputs please ?

Thanks in advance

Best Regards

Syed

[stevedark]

Hi @Mahaboob_Syed 

Getting the private key to play ball can be fiddly. Also, I've not tried downloading multiple files in this way (typically I will list and enumerate).

Have you tried a simple list files connection to just pull back a list of the files in a SFTP folder, in order to test the connection, prior to trying a download?

Have you validated all of the settings using a different FTP client on the same server?

Steve

[chrisbrain]

Agree with Steve's comments here to perform a simpler test first and using a different table to first enumerate the files and download them one by one as I don't think that * syntax is supported.

[Mahaboob_Syed]

Thank you @chrisbrain @stevedark 

The issue was related to the access rights to the folder where the .ppk file was residing and qlik user had to be given the access since the web connector was running as service on our reload node.

Now its working. 

The next part is while copying the code to the qliksense document and creating a new connection , this is where am I struck now.

[stevedark]

Hi @Mahaboob_Syed 

You are probably going to want to be creating a REST connection and pass in parameters using WITH CONNECTION.

There are some notes on doing this on the tabs which appear after a successful run in the QWC portal.

Are QWC and Sense Enterprise (or Desktop) running on the same server? If not you will need to ensure that QWC is configured to allow connections from other IP addresses and the firewall is open to allow traffic on 5555.

Hope that helps.

Steve

[Mahaboob_Syed]

Hello @stevedark 

Thank you for the above.

Yes, the web connector is as an  service on same server where we have our Qliksense Reload node.

As you mentioned, yes I'm following up the notes as below attached. I'm trying to create a connection. All of our odbc connections are on reload node

Best Regards

Syed

[chrisbrain]

@Mahaboob_Syed Regarding "The service is unavailable" message. A few suggestions:

- Check the Qlik Web Connectors log files for any entries around the time you triggered this message.
- Try running the URL you are pasting in in a browser on the same machine where the qlik server is running.
- If QWC and Qlik are on the same machine, I think you should just be able to use 'localhost:5555' as the address - might be worth trying this too.