none
BizTalk Receive Location The semaphore timeout period has expired RRS feed

  • Question

  • Hi!

    I have a receive location that gets disabled every other day and there is no activity on this receive location, it is polling sql using WCF SQL adapter. Any clue why I'm getting this error?

    The receive location "Rcv-WCF-SQL" with URL "mssql://SQLDEV//Tran?InboundId=TranPoll" is shutting down. Details:"System.Data.SqlClient.SqlException (0x80131904): A transport-level error has occurred when receiving results from the server. (provider: TCP Provider, error: 0 - The semaphore timeout period has expired.) ---> System.ComponentModel.Win32Exception (0x80004005): The semaphore timeout period has expired

    Friday, September 11, 2015 1:24 PM

Answers

  • Hi Chris,

    The semaphore timeout period has expired.

    Are you using SQL Database and is it installed on different server ?

    This issue occurs when not able to access the SQL Server. Please test distributed transactions across firewalls or against networks and use this tool for help.

    DTCPing.exe

    This tool helps to test distributed transactions across firewalls or against networks.


    Thanks, If my reply is helpful please mark as answer or vote as helpful.

    • Marked as answer by Chris7887 Friday, September 11, 2015 2:08 PM
    Friday, September 11, 2015 1:46 PM
    Moderator
  • Hi,

    True!! 

    This error occurs when there is some issue with the connectivity between SQL Server and BizTalk Server. You can check some of the things like:

    • Your network Configuration and if something is not correct.
    • All the required Inbound and Outbound ports are opened up between the 2 servers.

    Check these links:

    High Performing BizTalk Server 2009 /BizTalk Server 2010 Server Setup

    Troubleshooting SQL connectivity issues

    Rahul

    • Marked as answer by Chris7887 Friday, September 11, 2015 2:20 PM
    Friday, September 11, 2015 2:06 PM

All replies

  • Hi Chris,

    The semaphore timeout period has expired.

    Are you using SQL Database and is it installed on different server ?

    This issue occurs when not able to access the SQL Server. Please test distributed transactions across firewalls or against networks and use this tool for help.

    DTCPing.exe

    This tool helps to test distributed transactions across firewalls or against networks.


    Thanks, If my reply is helpful please mark as answer or vote as helpful.

    • Marked as answer by Chris7887 Friday, September 11, 2015 2:08 PM
    Friday, September 11, 2015 1:46 PM
    Moderator
  • Hi,

    True!! 

    This error occurs when there is some issue with the connectivity between SQL Server and BizTalk Server. You can check some of the things like:

    • Your network Configuration and if something is not correct.
    • All the required Inbound and Outbound ports are opened up between the 2 servers.

    Check these links:

    High Performing BizTalk Server 2009 /BizTalk Server 2010 Server Setup

    Troubleshooting SQL connectivity issues

    Rahul

    • Marked as answer by Chris7887 Friday, September 11, 2015 2:20 PM
    Friday, September 11, 2015 2:06 PM