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

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

On This Page

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: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

Properties

Article ID: 2625919 - Last Review: December 9, 2011 - Revision: 2.0
APPLIES TO
  • 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 KB2625919

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