This project is read-only.
1

Closed

Record limit?

description

Hi,

The tool works great for me now (apologies for the slow turnaround to re-test. However, I have a hunch it has an issue where you are trying to look at an entity with more than 5000 records. I suspect it's 5000+ but can't be sure. When I click on an entity with more than 5000 records the screen just doesn't refresh/no results appear. The most I've had returned is an entity with 4247.

Regards
Rob
Closed Nov 1, 2013 at 2:42 PM by paulway

comments

rboyers wrote Oct 4, 2013 at 8:53 AM

Just checked my Lead entity and it has 5908 records so there's definitely a 5000 limit.

rboyers wrote Oct 4, 2013 at 9:14 AM

It would be cool / a possible workaround (if this is a fetch xml aggregation issue) to be able to optionally select a system view to apply to each entity to enable the user to use a view which returns less than 5000 records.

paulway wrote Oct 5, 2013 at 4:15 PM

Rob,

What update rollup are you on? It uses aggregates, so by default the system should limit you to 50,000 records.

Here are some examples of modifying your on premise environment:

http://www.anjep.com/?p=417

http://nishantrana.wordpress.com/2012/09/06/aggregatequeryrecordlimit-exceeded-cannot-perform-this-operation/

Thanks,
Paul

paulway wrote Oct 5, 2013 at 4:20 PM

Rob,

Sorry, I meant to say here are links not to necessarily change your environment but to find your CRM's aggregate query limit.

5k is the default limit for normal fetch queries and 50k is the default limit for aggregates. The data detective only uses aggregates, so I'm wondering if your aggregate limit is lower than it probably should be.

Thanks,
Paul