Thursday, July 12, 2012

Mawimum record limit is exceeded in CRM 2011, Reduce the number of records

this is happens if the number of records happens to fetch is more than 50,000.
cuz 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.
note: if required make a restart of the services or iis restart. then it should work fine.

thanks,
Sudhanshu

2 comments:

  1. Microsoft Dynamics CRM training will help you manage and prioritize your business goals, customize.we teach MS Dynamics CRM training and class available at Hyderabad.
    Microsoft Dynamics CRM training in Hyderabad | Microsoft Dynamics CRM online training

    ReplyDelete
  2. Arrowsol Training offers on online Learning courses and manuals are optimized to help you and your team gain in-depth knowledge of your deployment
    Microsoft Dynamics Training | Microsoft Dynamics online Training | Microsoft Dynamics Training online

    ReplyDelete