Select the product you need help with
- Internet Explorer
- Windows Phone
- More products
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 ID: 952311 - View products that this article applies to.
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:
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)
"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."
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.
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:
(http://support.microsoft.com/kb/949256/ )Microsoft Dynamics CRM 4.0 updates and hotfixes
Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section.
For more information about software update terminology, click the following article number to view the article in the Microsoft Knowledge Base:
(http://support.microsoft.com/kb/824684/LN/ )Description of the standard terminology that is used to describe Microsoft software updates
(http://support.microsoft.com/kb/887283/ )Microsoft Business Solutions CRM software hotfix and update package naming standards