MS Dynamics CRM 2011 Maximum record limit is exceeded. Reduce the number of records.

This is happens if the number of records happens to fetch is more than 50,000, it has been set in the DB as the max size.
So if you will get the exception , When we open a chart in CRM2011 we get an error “Maximum record limit is exceeded. Reduce the number of records”.
Then it can be managed by increasing the 50,000 to more value as per your scenario, and it can be set in the DB only, to do so please follow this.

Set AggregateQueryRecordLimit to 99,999,999(your expected value) in the DeploymentProperties table in the MSCRM_CONFIG database.

If required make a restart of the services or iis restart. then it should work fine. When you open a chart in CRM 2011 and get this error “Maximum record limit is exceeded. Reduce the number of records”, it’s because the number of records to fetch is more than 50.000.

Leave a Reply

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

WordPress.com Logo

You are commenting using your WordPress.com 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 )

Google+ photo

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

Connecting to %s


%d bloggers like this: