Hi folks,

I’ve been given details to an SFTP server, and I can successfully connect to it using Winscp on my laptop:

I tried to setup connection in ONE desktop:

I put workflow task:

But I get an error:

14.11.2024 15:15:21 2INFO]     Using following licenses:
14.11.2024 15:15:21 2INFO]       C:\Users\mkwok\license_hamilton_USER_v14_subscription_2025-01-29.plf
14.11.2024 15:15:21 2INFO]     ============================================================
14.11.2024 15:15:21 2INFO]     This is a subscription USER license for developers' laptops for "Hamilton". It expires on 2025-01-29.
14.11.2024 15:15:21 2INFO]     ============================================================
2024-11-14 15:15:21 2INFO]    com.ataccama.lib.securityutil.javaencryption.DefaultEncryptionEngine messageId=createDefaultKeyProvider reason=the 'properties.encryption.keystore' property not specified
2024-11-14 15:15:21 2INFO]    com.ataccama.lib.securityutil.javaencryption.DefaultEncryptionEngine messageId=createDefaultKeyProvider reason=the 'internal.encryption.keystore' property not specified
14.11.2024 15:15:22 2INFO]     Processor started
14.11.2024 15:15:22 2INFO]     Task 'SFTP Download File' : IN_QUEUE
14.11.2024 15:15:22 2INFO]     Task 'SFTP Download File' : RUNNING
com.ataccama.adt.internal.core.runtime.EwfRuntimeException: Error downloading /pcs-data-sftp-prod/PCSHAM/out/ toc:\Ataccama\14.5.3\workspace\sandbox\flatcat\download - JSch error: java.net.UnknownHostException: sftp
com.jcraft.jsch.JSchException: java.net.UnknownHostException: sftp
	at com.jcraft.jsch.Util.createSocket(Util.java:379)
	at com.jcraft.jsch.Session.connect(Session.java:217)
	at com.jcraft.jsch.Session.connect(Session.java:187)
	at com.ataccama.adt.tools.SFTPClient.download(SFTPClient.java:230)
	at com.ataccama.adt.task.exec.SFTPDownloadFile$EwfCustomStep.run(SFTPDownloadFile.java:142)
	at com.ataccama.adt.internal.core.runtime.EwfTaskProcessor$ThreadSlot.run(EwfTaskProcessor.java:372)
Caused by: java.net.UnknownHostException: sftp
	at java.base/sun.nio.ch.NioSocketImpl.connect(NioSocketImpl.java:567)
	at java.base/java.net.SocksSocketImpl.connect(SocksSocketImpl.java:327)
	at java.base/java.net.Socket.connect(Socket.java:633)
	at java.base/java.net.Socket.connect(Socket.java:583)
	at java.base/java.net.Socket.<init>(Socket.java:507)
	at java.base/java.net.Socket.<init>(Socket.java:287)
	at com.jcraft.jsch.Util.createSocket(Util.java:375)
	... 5 more

Cause: java.net.UnknownHostException: sftp
	at java.base/sun.nio.ch.NioSocketImpl.connect(NioSocketImpl.java:567)
	at java.base/java.net.SocksSocketImpl.connect(SocksSocketImpl.java:327)
	at java.base/java.net.Socket.connect(Socket.java:633)
	at java.base/java.net.Socket.connect(Socket.java:583)
	at java.base/java.net.Socket.<init>(Socket.java:507)
	at java.base/java.net.Socket.<init>(Socket.java:287)
	at com.jcraft.jsch.Util.createSocket(Util.java:375)
	at com.jcraft.jsch.Session.connect(Session.java:217)
	at com.jcraft.jsch.Session.connect(Session.java:187)
	at com.ataccama.adt.tools.SFTPClient.download(SFTPClient.java:230)
	at com.ataccama.adt.task.exec.SFTPDownloadFile$EwfCustomStep.run(SFTPDownloadFile.java:142)
	at com.ataccama.adt.internal.core.runtime.EwfTaskProcessor$ThreadSlot.run(EwfTaskProcessor.java:372)

	at com.ataccama.adt.task.exec.SFTPDownloadFile$EwfCustomStep.run(SFTPDownloadFile.java:144)
	at com.ataccama.adt.internal.core.runtime.EwfTaskProcessor$ThreadSlot.run(EwfTaskProcessor.java:372)
14.11.2024 15:15:24 2INFO]     Task 'SFTP Download File' : failed with exception: Error downloading /pcs-data-sftp-prod/PCSHAM/out/ toc:\Ataccama\14.5.3\workspace\sandbox\flatcat\download - JSch error: java.net.UnknownHostException: sftp
com.jcraft.jsch.JSchException: java.net.UnknownHostException: sftp
	at com.jcraft.jsch.Util.createSocket(Util.java:379)
	at com.jcraft.jsch.Session.connect(Session.java:217)
	at com.jcraft.jsch.Session.connect(Session.java:187)
	at com.ataccama.adt.tools.SFTPClient.download(SFTPClient.java:230)
	at com.ataccama.adt.task.exec.SFTPDownloadFile$EwfCustomStep.run(SFTPDownloadFile.java:142)
	at com.ataccama.adt.internal.core.runtime.EwfTaskProcessor$ThreadSlot.run(EwfTaskProcessor.java:372)
Caused by: java.net.UnknownHostException: sftp
	at java.base/sun.nio.ch.NioSocketImpl.connect(NioSocketImpl.java:567)
	at java.base/java.net.SocksSocketImpl.connect(SocksSocketImpl.java:327)
	at java.base/java.net.Socket.connect(Socket.java:633)
	at java.base/java.net.Socket.connect(Socket.java:583)
	at java.base/java.net.Socket.<init>(Socket.java:507)
	at java.base/java.net.Socket.<init>(Socket.java:287)
	at com.jcraft.jsch.Util.createSocket(Util.java:375)
	... 5 more

Cause: java.net.UnknownHostException: sftp
	at java.base/sun.nio.ch.NioSocketImpl.connect(NioSocketImpl.java:567)
	at java.base/java.net.SocksSocketImpl.connect(SocksSocketImpl.java:327)
	at java.base/java.net.Socket.connect(Socket.java:633)
	at java.base/java.net.Socket.connect(Socket.java:583)
	at java.base/java.net.Socket.<init>(Socket.java:507)
	at java.base/java.net.Socket.<init>(Socket.java:287)
	at com.jcraft.jsch.Util.createSocket(Util.java:375)
	at com.jcraft.jsch.Session.connect(Session.java:217)
	at com.jcraft.jsch.Session.connect(Session.java:187)
	at com.ataccama.adt.tools.SFTPClient.download(SFTPClient.java:230)
	at com.ataccama.adt.task.exec.SFTPDownloadFile$EwfCustomStep.run(SFTPDownloadFile.java:142)
	at com.ataccama.adt.internal.core.runtime.EwfTaskProcessor$ThreadSlot.run(EwfTaskProcessor.java:372)

14.11.2024 15:15:24 2INFO]     --- Stop initiated ---
14.11.2024 15:15:24 2INFO]     Processor has finished with state: FINISHED_FAILURE

Open workflow state file

Any ideas? Is it the syntax of the server connection setup? I’ve tried various adding / removing ports and slashes but still get similar error messages.