Hi,
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)
update DeploymentProperties
set IntColumn = 100000
where ColumnName = ‘AggregateQueryRecordLimit’
Hope it helps.
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.
Thanks
LikeLike
Try breaking the query to smaller part and then combining the results
https://www.beringer.net/beringerblog/aggregatequeryrecordlimit-exceeded-exception-microsoft-crm/
LikeLike
The supported way to do this is issue an UpdateAdvancedSettingsRequest-
http://msdn.microsoft.com/en-us/library/2a4061cd-e6b4-4672-8c44-20a27c523718#use_powershell_advanced
LikeLike
What is the concrete exception type that retrievemultiple throws? I mean what do I put for in catch( e)
LikeLike