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: Displayed BAM portal results may not contain the latest records in BizTalk Server 2010

FIX: Displayed BAM portal results may not contain the latest records in BizTalk Server 2010

View products that this article applies to.

Symptoms

When you view results in the Business Activity Monitoring (BAM) portal on a computer that is running BizTalk Server 2010, the displayed results may not contain the latest records.

↑ Back to the top

Cause

This issue occurs because an underlying query retrieves only the top records that are sorted by the valueof the activityID database column. If the number of returned database rows is more than the specified maximum number of rows for results, the latest records may not be displayed.

Note The default setting for the maximum number of rows for results is 2000.

↑ Back to the top

Resolution

Cumulative update information

The hotfix that resolves this issue is included in cumulative update package 3 for BizTalk Server 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:
2617149 Cumulative update package 3 for BizTalk Server 2010
Note After you apply this cumulative update, you can configure the sorting feature to use the value of the LastModifiedDate database column instead of the value of the activityID database column. When the value of the LastModifiedDate database column is used to sort the results, the latest records are displayed first in the results.

Note For more information about how to configure the sorting feature, visit the following Microsoft website to contact Microsoft Customer Support Services:
http://support.microsoft.com/contactus/?ws=support

↑ 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

Workaround

To work around this issue, update the Web.config file to increase the value of the MaxResultRowssetting. For example, update the default value in the following code from 2000 to 5000.
<add key="MaxResultRows" value="2000"/>
Note This workaround does not work if the results have more rows than the number that is set in the MaxResultRows setting. Additionally, slow performance may occur when a larger dataset is returned.

↑ Back to the top

References

For more information about how to update references to the BAM primary import database name and connection string, visit the following MSDN website:
How to update references to the BAM primary import database name and connection string
For more information about how to customize the BAM portal configuration, visit the following TechNet website:
How to customize the BAM portal configuration
For information about the service packs and cumulative update list for BizTalk Server, click the following article number to view the article in the Microsoft Knowledge Base:

2555976 Service pack and cumulative update list for BizTalk Server
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, kb

↑ Back to the top

Article Info
Article ID : 2625919
Revision : 1
Created on : 1/7/2017
Published on : 12/9/2011
Exists online : False
Views : 362