Azure BizTalk Services – The underlying connection was closed: The connection was closed unexpectedly.

Posted: October 2, 2013  |  Categories: Azure BizTalk Uncategorized
Tags: WABS

I got this error when I attempted to deploy the second tutorial , “Using Azure BizTalk Bridges to Insert Flat File Messages into an On-premises SQL server”.  I had successfully completed the first tutorial after dealing with some deployment errors here and was on a roll but got stuck on this sucker. The full deployment error is;

“OrdersSource deployment failed at ‘https://markbribtservices.biztalk.windows.net/default/XmlOneWayBridge2/sources/OrdersSource’.
The underlying connection was closed: The connection was closed unexpectedly.”

The error is to do with how the FTP source is configured. My deployment configuration is (I have deleted some of the server IP address details);

image

I do not get the deployment error if I set the initial status to Stop.

I set this ftp server up on a VM in Azure for my test. I can connect and  ftp a file from the command line on the same server that i am trying to do my deployment as shown below;

F:\>ftp 65.52.122.78
Connected to 65.52.122.78.
220-Microsoft FTP Service
220 Welcome to FTP tester Dr
User (65.52.122.78:(none)): TheBoss
331 Password required
Password:
230-Welcome to FTP tester Dr
230 User logged in.
ftp> pwd
257 “/TheBoss” is current directory.
ftp> ls
200 PORT command successful.
125 Data connection already open; Transfer starting.
MessageToContoso
226 Transfer complete.
ftp: 18 bytes received in 0.00Seconds 18000.00Kbytes/sec.
ftp> put Orders.txt
200 PORT command successful.
125 Data connection already open; Transfer starting.
226 Transfer complete.
ftp>

I logged on to the FTP server while I attempted to do a deployment. I see a connection from my deployment client which then closes after 20 seconds.

2013-10-01 22:43:20 138.01.94.194 – 100.70.46.102 21 ControlChannelOpened – – 0 0 bf215ebb-72ce-4856-99ec-2e4a8fa332f7 –
2013-10-01 22:43:20 138.01.94.194 – 100.70.46.102 21 USER TheBoss 331 0 0 bf215ebb-72ce-4856-99ec-2e4a8fa332f7 –
2013-10-01 22:43:20 138.01.94.194 FTPTESTSERVER\TheBoss 100.70.46.102 21 PASS *** 230 0 0 bf215ebb-72ce-4856-99ec-2e4a8fa332f7 /TheBoss
2013-10-01 22:43:20 138.01.94.194 FTPTESTSERVER\TheBoss 100.70.46.102 21 OPTS utf8+on 200 0 0 bf215ebb-72ce-4856-99ec-2e4a8fa332f7 –
2013-10-01 22:43:20 138.01.94.194 FTPTESTSERVER\TheBoss 100.70.46.102 21 PWD – 257 0 0 bf215ebb-72ce-4856-99ec-2e4a8fa332f7 –
2013-10-01 22:43:20 138.01.94.194 FTPTESTSERVER\TheBoss 100.70.46.102 21 CWD MessageToContoso 250 0 0 bf215ebb-72ce-4856-99ec-2e4a8fa332f7 /TheBoss/MessageToContoso
2013-10-01 22:43:20 138.01.94.194 FTPTESTSERVER\TheBoss 100.70.46.102 21 TYPE I 200 0 0 bf215ebb-72ce-4856-99ec-2e4a8fa332f7 –
2013-10-01 22:43:20 138.01.94.194 FTPTESTSERVER\TheBoss 100.70.46.102 21 PASV – 227 0 0 bf215ebb-72ce-4856-99ec-2e4a8fa332f7 –
2013-10-01 22:43:41 – FTPTESTSERVER\TheBoss 100.70.46.102 49188 DataChannelClosed – – 0 0 bf215ebb-72ce-4856-99ec-2e4a8fa332f7 –
2013-10-01 22:43:41 138.01.94.194 FTPTESTSERVER\TheBoss 100.70.46.102 21 ControlChannelClosed – – 0 0 bf215ebb-72ce-4856-99ec-2e4a8fa332f7 –

This tells me that my deployment client can connect to the FTP server but then loses the connection. Christopher A. Martin has just reported the same problem on the MDSN forums “Starting Bridge Source”. I sure hope someone responds on this forum with what the problem is because it has got me beat.

 

turbo360

Back to Top