I was getting the above error in my RetrieveMultiple call in case if the number of records returned were more than 50000.
This limit is governed by ‘AggregrateQueryRecordLimit’ column value of Deployment Properties table in MSCRM_CONFIG database.
Updating it resolved the issue for me. (Remember this is unsupported customization)
set IntColumn = 100000
where ColumnName = ‘AggregateQueryRecordLimit’
Hope it helps.
5 thoughts on “Fixed – AggregateQueryRecordLimit exceeded. Cannot perform this operation.”
Is there any other way as you suggest this is not the supported customization.And what might be the issue if I go with this solution.
Try breaking the query to smaller part and then combining the results
The supported way to do this is issue an UpdateAdvancedSettingsRequest-
What is the concrete exception type that retrievemultiple throws? I mean what do I put for in catch( e)