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: Statement in the PollStatement property incorrectly runs if a receive location uses WCF-based BizTalk Adapter for SQL Server

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

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 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.

↑ 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

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:
How to receive polling-based data changed messages from SQL Server by using the WCF channel model
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

↑ Back to the top

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

↑ Back to the top

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