Error message when you click the Refresh list button on a grid of a view in Microsoft Dynamics CRM 4.0: "Order by columns do not match those in paging"

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

SYMPTOMS

When you click the Refresh list button on a grid of a view that contains a custom picklist attribute in Microsoft Dynamics CRM 4.0, you receive the following error message:
Platform Error
=====================================
Error Number: 0x80041129
Error Message: Order by columns do not match those in paging cookie.
Error Details: Order by columns do not match those in paging cookie.
Source File: Not available
Line Number: Not available
Request URL: http://URL
Stack Trace Info: [CrmException: Order by columns do not match those in paging cookie.] at Microsoft.Crm.BusinessEntities.PagingHelper._AddRepeatFiltering(OrderExpressionCollection orderCollection, FilterExpression filterExpression, Hashtable orderNameValuePairs) at Microsoft.Crm.BusinessEntities.PagingHelper.AddPagingFilters(EntityExpression entityExpression) at Microsoft.Crm.BusinessEntities.QueryProcessObject.RetrieveDataQueryAsResultXml(EntityExpression entityExpression, QueryStrategyType strategyType, ExecutionContext context) at Microsoft.Crm.BusinessEntities.QueryProcessObject.RetrieveQueryAsResultXml(EntityExpression entityExpression, QueryStrategyType strategyType, ExecutionContext context) at Microsoft.Crm.ObjectModel.SavedQueryService.Execute(String fetchXml, ExecutionContext context)
User Error
=====================================
"An error has occurred. Try this action again. If the problem continues, check the Microsoft Dynamics CRM Community for solutions or contact your organization's Microsoft Dynamics CRM Administrator. Finally, you can contact Microsoft Support."

CAUSE

This problem occurs because Microsoft Dynamics CRM compares an incorrect attribute name when Microsoft Dynamics CRM compares the paging cookie of the grid to the query's order expression. For example, if a picklist attribute exists that is named new_testpl, Microsoft Dynamics CRM compares the new_testplname attribute in the paging cookie and the new_testpl attribute in the query expression. Because the attribute names are different, an exception occurs.

RESOLUTION

This problem is fixed in the latest cumulative update rollup for Microsoft Dynamics CRM 4.0. For more information, click the following article number to view the article in the Microsoft Knowledge Base:
949256 Microsoft Dynamics CRM 4.0 updates and hotfixes

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 software update terminology, click the following article number to view the article in the Microsoft Knowledge Base:
824684 Description of the standard terminology that is used to describe Microsoft software updates
887283 Microsoft Business Solutions CRM software hotfix and update package naming standards

Properties

Article ID: 952311 - Last Review: January 20, 2012 - Revision: 3.2
APPLIES TO
  • Microsoft Dynamics CRM 4.0
Keywords: 
kberrmsg kbexpertiseinter kbfix kbautohotfix kbmbsmigrate kbqfe kbhotfixserver KB952311

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