FIX: WMI query returns incorrect results when a service instance ID is used in BizTalk Server 2006 R2

Article ID: 2629481 - View products that this article applies to.
Expand all | Collapse all

On This Page

SYMPTOMS

Assume that you run a Windows Management Instrumentation (WMI) query on a computer that is running BizTalk Server 2006 R2. 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).

CAUSE

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

RESOLUTION

Cumulative update information

BizTalk Server 2006

The hotfix that resolves this issue is included in cumulative update package 4 for BizTalk Server 2006 R2 Service Pack 1 (SP1).

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:
2682056 Cumulative update package 4 for BizTalk Server 2006 R2 SP1

STATUS

Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section.

MORE INFORMATION

For more information about the MSBTS_ServiceInstance WMI class, visit the following MSDN website:
General information about the MSBTS_ServiceInstance WMI class

Properties

Article ID: 2629481 - Last Review: May 14, 2012 - Revision: 2.0
APPLIES TO
  • Microsoft BizTalk Server 2006 R2 Branch Edition
  • Microsoft BizTalk Server 2006 R2 Developer Edition
  • Microsoft BizTalk Server 2006 R2 Enterprise Edition
  • Microsoft BizTalk Server 2006 R2 Service Pack 1
  • Microsoft BizTalk Server 2006 R2 Standard Edition
  • Microsoft BizTalk Server Branch 2010
  • Microsoft BizTalk Server Developer 2010
  • Microsoft BizTalk Server Enterprise 2010
  • Microsoft BizTalk Server Standard 2010
Keywords: 
kbqfe kbfix kbexpertiseadvanced kbsurveynew KB2629481

Give Feedback

 

Contact us for more help

Contact us for more help
Connect with Answer Desk for expert help.
Get more support from smallbusiness.support.microsoft.com