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.

FIX: WCF-based SQL Adapter stops polling data when daylight saving time ends


View products that this article applies to.

This article applies to Microsoft BizTalk Adapter Pack 2010.

↑ Back to the top


Symptoms

Consider the following scenario:
  • You use a receive location to poll data on a Microsoft BizTalk Windows Communication Foundation (WCF)-based SQL adapter. 
  • You define a SQL statement in the PolledDataAvailableStatement binding property. Additionally, you define a polling time interval in the PollingIntervalInSeconds binding property.
  • Daylight saving time will end when the SQL statement is running.
In this scenario, the SQL statement stops running for one hour when clocks are rolled back for the end of daylight saving time. 

For example, you change the time zone of the system to US & Canada Central Time. Then, you change the system time to November 4, 1:58 AM. After two minutes, daylight saving time ends and the system time is rolled back one hour. In this situation, the SQL statement stops running for one hour.

↑ Back to the top


Resolution

Cumulative update package information

For BizTalk Adapter Pack 2010

The hotfix that resolves this issue is included in cumulative update package 3 for BizTalk Adapter Pack 2010.

For more information about how to obtain this cumulative update package, click the following article number to view the article in the Microsoft Knowledge Base:
2617150 Cumulative update package 3 for BizTalk Adapter Pack 2010


↑ 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 : 2800376
Revision : 2
Created on : 9/25/2018
Published on : 9/25/2018
Exists online : False
Views : 265