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)