CRM 2011 graph display error message: Maximum Record Limit is exceeded

Problem:  when chart is displayed in CRM 2011 we get an error message.

Solution:

Sometimes when chart get displayed in CRM 2011 you get error message indicating that “Maximum record limit is exceeded. Reduce the number of records."

This error is because in SQL Server there is max record limit set for charts to display data. This means, query that you placed for charts is grabbing more data than max record limit and so you end up getting this error.

To resolve this issue either you need to change your query to grab lesser data or if that is not possible you need to increase the max record limit in SQL Server.

If you want to increase the max record limit in SQL Server than you need to update Deployment Properties table in MSCRM_CONFIG database.

you can execute following query:

update MSCRM_CONFIG.dbo.DeploymentProperties

set IntColumn = 10000000

where ColumnName = 'AggregateQueryRecordLimit'

  

Thanks,