You are currently offline, waiting for your internet to reconnect

FIX: Statement in the PollStatement property incorrectly runs if a receive location uses WCF-based BizTalk Adapter for SQL Server


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 have a computer that is running Microsoft BizTalk Server 2006 R2, Microsoft BizTalk Server 2009 or Microsoft BizTalk Server 2010.  
  • You create a receive location that uses a Windows Communication Foundation (WCF) LOB Adapter SDK-based SQL adapter to receive messages in a Microsoft SQL Server database.

    For example, you use a custom adapter that has the sqlBinding binding type selected, or you use WCF-based BizTalk Adapter for SQL Server from Microsoft BizTalk Adapter Pack 2.0 or BizTalk Adapter Pack 2010.
  • You specify a statement in the PolledDataAvailableStatement property to return a non-positive value.

In this scenario, a statement that is specified in the PollStatement property may incorrectly run.
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.
REFERENCES
For more information about how to receive polling-based data changed messages from SQL Server by using the WCF channel model, visit the following MSDN website: For more information about BizTalk Server hotfixes, click the following article number to view the article in the Microsoft Knowledge Base:
2003907 Information on BizTalk Server hotfixes
BAP2010
Properties

Article ID: 2522459 - Last Review: 05/31/2011 02:49:00 - Revision: 2.0

  • kbqfe kbfix kbexpertiseadvanced kbsurveynew kbbtsadapters KB2522459
Feedback
html>