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

Announcements
Want to see what's currently in public preview? We've pulled it all together in one place. Check it out here
cancel
Showing results for 
Search instead for 
Did you mean: 
Mara_mamaco
Partner - Contributor II
Partner - Contributor II

SFTP-Server Connection stops after several downloads

Dear Qlik Community,

ee have set up a working SFTP connection in our Qlik Cloud.
Downloading individual CSV files works without any problems, but when downloading with *, the download breaks off after a while with the following error message:

Mara_mamaco_0-1767967915623.png

 

According to the server administrator, there are no restrictions on downloads set on the server. In the data connection settings (SFTP), I cannot specify/change any settings regarding downloads.

Does anyone have any experience with this?

Thanks in advance for any help!

Mara Lemmermann
www.mamaconsulting.de
Labels (1)
1 Solution

Accepted Solutions
marcus_sommer
MVP
MVP

FTP doesn't support wildcards on the file-layer or file-functions like filetime(). Workarounds may be:

  • enabling any batch-logic on the FTP-side to write the existing files into a list which is then used into a loop
  • looping against assumed files - especially if the file-names differ on period-information with/without applying an appropriate error-handling (ERRORMODE)
  • copy & paste the FTP content to a local storage per mget command and then all "native" file-features could be used

 

View solution in original post

1 Reply
marcus_sommer
MVP
MVP

FTP doesn't support wildcards on the file-layer or file-functions like filetime(). Workarounds may be:

  • enabling any batch-logic on the FTP-side to write the existing files into a list which is then used into a loop
  • looping against assumed files - especially if the file-names differ on period-information with/without applying an appropriate error-handling (ERRORMODE)
  • copy & paste the FTP content to a local storage per mget command and then all "native" file-features could be used