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 translations Article translations
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)

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

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

Give Feedback

 

Contact us for more help

Contact us for more help
Connect with Answer Desk for expert help.
Get more support from smallbusiness.support.microsoft.com