This project has moved and is read-only. For the latest updates, please go here.

[BizTalk - SFTP Adapter] Execution error

Aug 28, 2009 at 10:11 AM

Hi all,

I've encountered some problems to configure the SFTP Adapter in my Biztalk context.

Here is the error i found in the EventViewer :

Method: Blogical.Shared.Adapters.Sftp.SharpSsh.Sftp.connect

Error: Unable to connect to Sftp host [sftp://myhost:22/path/]

------------------------------

Information:

Type: System.Exception

Target:

Message: Unable to connect to Sftp host [sftp://myhost:22/path/]

Stacktrace:

------------------------------

Type: Tamir.SharpSsh.jsch.JSchException

Target: Void connect(Int32)

Message: System.Net.Sockets.SocketException: The requested name is valid, but no data of the requested type was found

at System.Net.Dns.InternalGetHostByName(String hostName, Boolean includeIPv6)

at System.Net.Dns.GetHostByName(String hostName)

at Tamir.SharpSsh.java.net.Socket..ctor(String host, Int32 port)

at Tamir.SharpSsh.jsch.Util.createSocket(String host, Int32 port, Int32 timeout)

Stacktrace:

at Tamir.SharpSsh.jsch.Session.connect(Int32 connectTimeout)

at Tamir.SharpSsh.SshBase.ConnectSession(Int32 tcpPort)

at Tamir.SharpSsh.SshBase.Connect(Int32 tcpPort)

at Blogical.Shared.Adapters.Sftp.SharpSsh.Sftp.connect(Boolean force)

In my message assignement shape, i've wrote the following code :

msg_TransformOut(BTS.OutboundTransportType) = "SFTP";

msg_TransformOut(Blogical.Shared.Adapters.Sftp.Schemas.host) = msg_PlannedTask.SFTPHost;

msg_TransformOut(Blogical.Shared.Adapters.Sftp.Schemas.portno) = msg_PlannedTask.SFTPPort;

msg_TransformOut(Blogical.Shared.Adapters.Sftp.Schemas.user) = msg_PlannedTask.SFTPUser;

msg_TransformOut(Blogical.Shared.Adapters.Sftp.Schemas.password) = msg_PlannedTask.SFTPPwd;

 

msg_TransformOut(Blogical.Shared.Adapters.Sftp.Schemas.remotefile) = "test.txt";

and the send port assignement is :

 

snd_SFTPPort(Microsoft.XLANGs.BaseTypes.Address) = msg_PlannedTask.OutDirectory;

I really don't understand where is the problem. Could somebody help me ?

Antonin

 

 

 

Sep 5, 2009 at 7:57 PM

Does it work using a none dynamic sendport?

//Mikael

Nov 17, 2010 at 10:50 AM
Edited Nov 17, 2010 at 11:12 AM

Hi,

I have configured a Receive Location and Send Port that both use the adapter.  They connect to two different folders on the same SFTP server but both use the same User Name and Password.

The Receive Location downloads files as expected with no exceptions.  The Send Port throws the exception stated by 'abrachet' above.  I have successfully uploaded the file using FileZilla so there is no problem with the connection.  Am I missing something?

Many thanks

Jimbob

Nov 17, 2010 at 7:05 PM

Does it work using a static port?

//Mikael