This article applies to the following product:

  • Microsoft BizTalk Adapter Pack 2.0

  • Microsoft BizTalk Adapter Pack 2010

  • Standalone WCF-based BizTalk Adapter for SQL Server

Symptoms

Consider the following scenario:

  • You create several Microsoft BizTalk Server receive locations or send ports.

  • The receive locations or send ports use the WCF-SQL adapter from Microsoft BizTalk Adapter Pack 2.0 or from BizTalk Adapter Pack 2010 to access data in a Microsoft SQL Server database.

  • An error occurs in the WCF-SQL adapter.

In this scenario, the event log entry does not include useful information such as the following:

  • The name of the receive location or of the send port

  • The name of an instance of SQL Server

  • A database name

This makes it difficult to locate the receive location or send port that is causing the problem. For example, a stored procedure that is called in a receive location raises an exception, and the WCF-SQL Adapter writes the following event log:

Event Type: Error Event Source: <BizTalk Server version> Event Category: <BizTalk Server version> Event ID: 5750Description: The adapter "WCF-SQL" raised an error message. Details :System.Data.SqlClient.SqlException: Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)

Resolution

Cumulative update information

BizTalk Adapter Pack 2010

The hotfix that resolves this issue is included in Cumulative Update 1 for BizTalk Adapter Pack 2010. For more information about how to obtain the cumulative update package, click the following article number to view the article in the Microsoft Knowledge Base:2539794 Cumulative update package 1 for BizTalk Adapter Pack 2010

BizTalk Adapter Pack 2.0

The hotfix that resolves this issue is included in Cumulative Update 2 for BizTalk Adapter Pack 2.0. For more information about how to obtain the cumulative update package, click the following article number to view the article in the Microsoft Knowledge Base:

2531605 Cumulative update package 2 for BizTalk Adapter Pack 2.0

Status

Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section.

More Information

For more information about BizTalk Server hotfixes, click the following article number to view the article in the Microsoft Knowledge Base:

2003907 Information about BizTalk Server hotfixes

Need more help?

Want more options?

Explore subscription benefits, browse training courses, learn how to secure your device, and more.

Communities help you ask and answer questions, give feedback, and hear from experts with rich knowledge.