AggregateQueryRecordLimit exceeded. Cannot perform this operation.

AggregateQueryRecordLimit exceeded. Cannot perform this operation.

Issue: 

I was getting the above error in my RetrieveMultiple call in case if the number of records returned were more than 50000.

Solution:

This limit is governed by ‘AggregrateQueryRecordLimit’ column value of Deployment Properties table in MSCRM_CONFIG database.

update DeploymentProperties

set IntColumn = 100000

where ColumnName = ‘AggregateQueryRecordLimit’

Updating it resolved the issue for me. (Remember this is unsupported customization)

Quick Find Query Record Limit exceeded. Cannot perform this operation in CRM

QuickFindQueryRecordLimit exceeded. Cannot perform this operation in MSCRM.

Issue:

When the user is searching for a Text in Contact’s Home Page grid view. getting below error -

Exception information: 

    Exception type: CrmException
    Exception message: QuickFindQueryRecordLimit exceeded. Cannot perform this operation.

Cause:

User is searching for a Text in Contact’s Home Page grid view and there are having more than 10,000 records.

Due to this limitation in CRM for Quick Find Search, CRM Platform is throwing this issue.

Solution:

Go to Settings -> Administration -> System Settings

Change the Enable Quick Find record limits under Set up Quick Find to No and click on OK.

Now you can search the required Text without any issues.