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: WMI query returns incorrect results when a service instance ID is used in BizTalk Server


View products that this article applies to.

Symptoms

Assume that you run a Windows Management Instrumentation (WMI) query on a computer that is running BizTalk Server 2006 R2, BizTalk Server 2010, or BizTalk Server 2013. If the query uses a service instance ID against the MSBTS_MessageInstance WMI class, the query may return an incorrect result.

For example, assume that you use the following code to create a WMI query in a given service instance ID. If the service instance contains two messages, only one message is returned.

using System.Management; 
ManagementScope mgmtScope = new ManagementScope();
mgmtScope.Path.NamespacePath = "root\\MicrosoftBizTalkServer";
ManagementObjectSearcher objectSearcher = new ManagementObjectSearcher(mgmtScope, new SelectQuery("MSBTS_MessageInstance", "ServiceInstanceId = \"{" + SERVICE_INSTANCE_ID + "}\""));
objectSearcher.Options.EnsureLocatable = true;
ManagementObjectCollection coll = objectSearcher.Get();
Note SERVICE_INSTANCE_ID is a string representation of the service instance ID (GUID).

↑ Back to the top


Cause

This issue occurs because of an error in the msgbox_application_logic.sql script.

↑ Back to the top


Resolution

Cumulative update information

This issue was first fixed in the following cumulative update of BizTalk Server:

↑ 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 the MSBTS_ServiceInstance WMI class, visit the following MSDN website:

↑ Back to the top


Keywords: kb, kbqfe, kbfix, kbexpertiseadvanced, kbsurveynew

↑ Back to the top

Article Info
Article ID : 2629481
Revision : 1
Created on : 1/7/2017
Published on : 10/10/2015
Exists online : False
Views : 462