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.

BizTalk Adapter for Host Files does not process Receive Location UPDATE or DELETE statements


View products that this article applies to.

Symptoms

The BizTalk Adapter for Host Files doesn't process BizTalk Receive Location SELECT statements together with UPDATE or DELETE statements. This causes BizTalk Server to log the following entry in the Application log: 

↑ Back to the top


Cause

This problem occurs because the BizTalk Adapter for Host Files requires a specific way to write select and update statement. If this process is not implemented correctly, the Receive handler does not process UPDATE or DELETE statements.

↑ Back to the top


Resolution

Cumulative update information

The fix for this problem is included in cumulative update package 5 for Host Integration Server 2013. For more information about how to get the cumulative update package, see Cumulative update package 5 for Host Integration Server 2013.

↑ 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

The Microsoft BizTalk Adapter for Host Files runtime and Microsoft DDM Client for Host Files have been corrected to set access intent for UPDATE or DELETE when it processes a SELECT statement together with a positioned UPDATE or DELETE operation.

↑ Back to the top


Keywords: kbfix, kb

↑ Back to the top

Article Info
Article ID : 4040161
Revision : 6
Created on : 3/31/2018
Published on : 6/28/2018
Exists online : False
Views : 261