AggregateQueryRecordLimit exceeded. Cannot perform this operation.


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.

Author: Nishant Rana

I love working in and sharing everything about Microsoft.NET technology !

5 thoughts on “AggregateQueryRecordLimit exceeded. Cannot perform this operation.”

  1. 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.



Please share your thoughts

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.