I am having trouble receiving/downloading files from a remote server via ftps adapter..

The server supports, AUTH TLS. The files to be downloaded from server (ftp.weather.biz) are located at ftp.weather.biz\days.

I have configured the adapter as shown in the image below,

I am able to enable the receive location without any errors and below is the content in the log file,

< 220 Service ready for new user.
> AUTH TLS
< 234 Security exchange completed.

Problem is that that I don't see any files getting downloaded nor do I see any error/warning messages in the event log.

Is there anything that I am missing to configure in order for me to download files??

Thanks..

• Edited by Kakko72 Tuesday, October 08, 2013 5:17 PM updated image

Hi,

I looked for an explanation of that error and I get:

234 Security data exchange complete

Host SSL/FTP going into SSL mode and requesting client certificate

So it seems to say or imply that BizTalk has a problem finding the correct Client certificate. However I would have expected a better error if that was the case. There are lots of ways you can fail to provide a certificate. Remember that it is the Host instance account that has to find that certificate, just because you can it doesn't mean the service account can. Perhaps the certificate is not in the correct store? Perhaps the hash is wrong? Perhaps the proxy the BizTalk service is using is not the same as yours?

Try logging in with the service account and see if Core FTP can still connect. 

You are correct about host service account logic. We have already coreftp using the service account that the adapter uses.

Now the adapter throws not valid hash error if we specify wrong thumbprint. We tested that and that's true.

But in this case, we have put the correct thumbprint and the adapter does not complain about any hash or cert errors.

The adapter does not log any error in the event log nor in the log file..

ok did some progress this weekend... I see some more logging in the log file...

Had to use another certificate and of course gave the service account access to private key..

But I am still not seeing any files being downloaded..

See the log below,

< 220 Service ready for new user.
> AUTH TLS
< 234 Security exchange completed.
> PBSZ 0
< 200 Command OK.
> PROT C
< 200 Command OK.
> USER Occidental
< 331 User name okay, need password.
> PASS xxxx
< 230 User logged in, proceed.
> PWD
< 257 "/"
> PWD
< 257 "/"
> PWD
< 257 "/"
> SYST
< 215 Unix DataType: L8
> PWD
< 257 "/"
> CWD days
< 250 File operation OK.
> PWD
< 257 "/days/"
> TYPE A
< 200 Command OK.
> PASV
< 227 (10,151,3,5,136,185)
> QUIT
< 221 Service closing control connection.

Anyone knows what to do next to get the files downloaded (at least one for now)???

Hi,

so close and yet so far ...

Did you try using the Before Get and After Get to add a file listing. Would that be? LS

Hopefully it will be in your trace and you can see if there are any files there (from the BizTalk client perspective).

 

Hi all,

The adapter seems to connect fine to the server but wont be able to perform further ftps functions as the server requires the client to issue certain ftp commands for channel and command security.

Inshort, its a bit custom ftps connection where the bts adapter wont support it.

So wrote a little custom ftps .net client to get away with our requirement.

Thanks....

• Marked as answer by Kakko72 Saturday, January 11, 2014 5:17 PM