Campaign Classic - SFTP Download issue

This article addresses the issue of failing to download files from an SFTP repository after a build upgrade despite having a successful connection to the server.

Description description

Environment

Campaign Classic

Issue/Symptoms

After a build upgrade, we noticed that the actual connection to SFTP works, but it is not possible to download files from remote repositories via SFTP.

File download log (error message):
29/06/2020 09:59:43 fileTransfer CRL-290002 Download error in cURL

29/06/2020 09:59:43 fileTransfer Remote file not found

29/06/2020 09:59:43 fileTransfer * Connection #0 to host *****.***.*** left intact

29/06/2020 09:59:43 fileTransfer * Could not open directory for reading: No such file or directory

29/06/2020 09:59:42 fileTransfer * Authentication complete

29/06/2020 09:59:42 fileTransfer * Initialized SSH public key authentication

29/06/2020 09:59:42 fileTransfer * Using SSH private key file ‘/usr/local/neolane/.ssh/id_rsa’

29/06/2020 09:59:42 fileTransfer * Using SSH public key file ‘/usr/local/neolane/.ssh/id_rsa.pub’

29/06/2020 09:59:42 fileTransfer * SSH authentication methods available: publickey,password

29/06/2020 09:59:42 fileTransfer * SSH MD5 fingerprint: ******************************

29/06/2020 09:59:42 fileTransfer * Connected to ******.***.*** (xxx.xxx.xxx.xx) port 22 (#0)

29/06/2020 09:59:42 fileTransfer * TCP_NODELAY set

29/06/2020 09:59:42 fileTransfer * Trying xxx.xxx.xxx.xx…

29/06/2020 09:59:42 fileTransfer Starting file listing ‘sftp://*****.***.***:22/Outgoing/FILENAME.CSV’

29/06/2020 09:59:42 Starting workflow (operator ‘Administrator (admin)’)

29/06/2020 09:59:42 Workflow ‘WKF1747’ is being run

Resolution resolution

The fix will be available from the release 20.3.1 of Adobe Campaign Classic onwards.
Cause
In some SFTP actions, we expect the remote server to be a Unix SFTP server and add ~/ to the path if the path is not absolute.
This does not work if the remote SFTP server is on windows and *~/*has no meaning.