Microsoft KB Archive Search

Notice: This website is an unofficial Microsoft Knowledge Base (hereinafter KB) archive and is intended to provide a reliable access to deleted content from Microsoft KB. All KB articles are owned by Microsoft Corporation. Read full disclaimer for more details.

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

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

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

↑ Back to the top

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

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

↑ Back to the top

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

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

↑ Back to the top

Keywords: kbqfe, kbfix, kbexpertiseadvanced, kbsurveynew, kbbtsadapters, kb

↑ Back to the top

Article Info
Article ID : 2478956
Revision : 2
Created on : 9/11/2018
Published on : 9/11/2018
Exists online : False
Views : 209