FIX: The WCF-SQL adapter from BizTalk Adapter Pack 2.0 or from BizTalk Adapter Pack 2010 does not write enough useful error information

Article ID: 2478956 - View products that this article applies to.
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
Expand all | Collapse all

On This Page

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: 5750

Description:

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)
Back to the top | Give Feedback

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
(http://support.microsoft.com/kb/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
(http://support.microsoft.com/kb/2531605/ )
Cumulative update package 2 for BizTalk Adapter Pack 2.0
Back to the top | Give Feedback

STATUS

Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section.
Back to the top | Give Feedback

MORE INFORMATION

For more information about BizTalk Server hotfixes, click the following article number to view the article in the Microsoft Knowledge Base:
2003907
(http://support.microsoft.com/kb/2003907/ )
Information about BizTalk Server hotfixes

Back to the top | Give Feedback

Properties

Article ID: 2478956 - Last Review: May 31, 2011 - Revision: 2.0
APPLIES TO
  • Microsoft BizTalk Server Developer 2010
  • Microsoft BizTalk Server Enterprise 2010
  • Microsoft BizTalk Server Standard 2010
  • Microsoft BizTalk Server 2009 Developer
  • Microsoft BizTalk Server 2009 Enterprise
  • Microsoft BizTalk Server 2009 Standard
  • Microsoft BizTalk Server 2006 R2 Branch Edition
  • Microsoft BizTalk Server 2006 R2 Developer Edition
  • Microsoft BizTalk Server 2006 R2 Enterprise Edition
  • Microsoft BizTalk Server 2006 R2 Standard Edition
Keywords: 
kbqfe kbfix kbexpertiseadvanced kbsurveynew kbbtsadapters KB2478956
Back to the top | Give Feedback

Give Feedback

 
Back to the topBack to the top