Tuesday, 4 March 2014

Fix Chart Error: There was an error while retrieving the data from Microsoft Dynamics CRM

Chart is great feature for CRM 2011 to visualize data. But, do yu know that if your data is more than 50000 records, it will give you an error message :

There was an error while retrieving the data from Microsoft Dynamics CRM
in the chart :



I often face this problem when my Organization has many data and I want to show all of the data through CRM 2011 Chart.

So here is the resolution :

Execute this query.

(set IntColumn to your total records)

USE MSCRM_CONFIG
Update DeploymentProperties Set IntColumn='99999'
where ColumnName='AggregateQueryRecordLimit'



Before you have done this, to make sure current number, please use select statement first.


USE MSCRM_CONFIG
Select IntColumn
from DeploymentProperties
where ColumnName='AggregateQueryRecordLimit'
Please be remember that when you enable this feature, the performance will be also slowly because load many data when first login or first seeing the chart in the Dashboard.
Hope it helps.
Thanks.

1 comment:

My Name is..