How to get total aggregate records count if records is having more than 50000 records - for Online instance only

(0) Share

Report

Posted on by Ashish D Manatkar

Guys i would like to get total aggregate records count using fetch XML if records having more than 50,000 for online instance only, please suggest how to get.

I have tried using below fetch XML

but i am getting error "Maximum limit is exceeded record. Reduce the number of records" .
Table name: ma_externalactions

Available Records : 75000 +

Please suggest.

*This post is locked for comments

I have the same question (0)

All responses (7)

Answers (0)

Suggested answer

Bruno Lucas 5,421 on at

Like (0)

Report

You may want to try paging

msdn.microsoft.com/.../gg328046.aspx

Was this reply helpful? Yes No
Ashish D Manatkar on at

Like (0)

Report

Bruno,

I am talking about aggregate records count, i agree 5000 records get without aggregate fetch xml query.

Was this reply helpful? Yes No
Suggested answer

Bruno Lucas 5,421 on at

Like (0)

Report

I see,

there is this setting

social.technet.microsoft.com/.../12601.crm-2011-timeouts-and-limits.aspx

msdn.microsoft.com/.../gg328128.aspx

but note the message "You should use the advanced settings only when indicated to do so by the Microsoft Dynamics CRM customer support representatives."

this is probably change this on the database

paul-way.com/crm-2013-aggregate-query-record-limit-exceeded

it may affect performance.

Was this reply helpful? Yes No
Ashish D Manatkar on at

Like (0)

Report

Bruno,

This settings only for On-Premises instance. I am looking for online instance.

Was this reply helpful? Yes No
Suggested answer

Bruno Lucas 5,421 on at

Like (0)

Report

For online there is no way to remove the 50000 limit for aggregate

www.linkedin.com/.../Possible-limitation-in-MS-CRM-21231.S.269446834

I don't know what you are trying to accomplish, but if you just need to count a field you can use my first suggestion and simulate the "count" inside the loop.

otherwise you will need to have something to pull the data to another database where you can use SQL

Was this reply helpful? Yes No
Ashish D Manatkar on at

Like (0)

Report

According your first reply we are getting data which i don't want, i just want the count of records nothing else. I don't want to retrieve data and count inside the loop.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

It is pretty painful to get a record count on an entity. I ended up building a web resource that lists out all the entities in the org, then pages over them counting each page. It works, but for an entity that contains around 800,000 records it takes 2-3 minutes to page the entire table not to mention I'm bringing back several megs of data when all I want is a number.

Was this reply helpful? Yes No