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

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.

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.

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:

Status

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

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.

References

For more information about how to update references to the BAM primary import database name and connection string, visit the following MSDN website:For more information about how to customize the BAM portal configuration, visit the following TechNet website: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
Properties

Article ID: 2625919 - Last Review: Dec 9, 2011 - Revision: 1

Feedback