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:

http://support.microsoft.com/contactus/?ws=support

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:

How to update references to the BAM primary import database name and connection stringFor more information about how to customize the BAM portal configuration, visit the following TechNet website:

How to customize the BAM portal configurationFor 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

Need more help?

Expand your skills
Explore Training
Get new features first
Join Microsoft Insiders

Was this information helpful?

What affected your experience?

Thank you for your feedback!

×