Tag: Tips & Tricks

25Apr

CRM 2013 – Aggregate Query Record Limit Exceeded

If you are using my CRM Data Detective or trying to perform aggregate queries against your CRM database, you may occasionally see an obscure error message.

CRM 2013 - Aggregate Query Record Limit exceeded

CRM 2013 – Aggregate Query Record Limit Exceeded

 

The specific message is:

AggregateQueryRecordLimit exceeded.  Cannot perform this operation.

 

CRM 2011 and CRM 2013 by default are limited to performing aggregate queries on less than 50,000 records.  With online, you cannot change this value; however, with on premise or partner hosted you can.  I’d recommend modifying this value to 250,000.

In my experience, CRM easily handles 250,000 records as long as you’re following the hardware specs Microsoft recommends.

Modifying the On Premise Settings

Warning!  If you are unfamiliar with making these changes, ask someone who is familiar for help.  Whenever you are making advanced setting changes, use caution.

To increase the limit, you’ll need to modify:

Database: MSCRM_CONFIG
Table: Deployment Properties
Column: AggregateQueryRecordLimit

To query the current value:

To modify:

 

Here’s an MSDN reference for using C# and/or PowerShell: http://msdn.microsoft.com/en-us/library/gg328128.aspx

 

If you are interested in other limits CRM has, take a look at this:

http://social.technet.microsoft.com/wiki/contents/articles/12601.crm-2011-timeouts-and-limits.aspx

 

I hope you enjoy!

17Feb

CRM 2013 – Copying a Process

Within CRM 2013, processes are incredible.  Since they are great time savers for users, I typically get a lot of positive feedback regarding them.

One feature missing from CRM 2013 is the ability to copy an existing process; however, there is a nice work-around we’ll explore today.  If you are like me and create some fairly in-depth processes, then copying a process should hopefully save you some time.  Let’s walk through how to copy a process:

Copying a Process Step-by-Step

  • First, open the Process you want to duplicate:
    Copying a Process: Opening the Process to Duplicate

    Notice the “Activate As” field

    Read More »

11Feb

CRM 2013 – Start Users on a Dashboard vs Personal Wall

Microsoft Dynamics CRM 2013 offers by default a “What’s New” landing page known as the Personal Wall.  The “what’s new” page is a great place to start and is part of the social add-ins Microsoft introduced with CRM 2011.

Personal Wall

Checking out the social aspects of the Personal Wall

 

Although the Personal Wall is great, I often like to start users on a custom dashboard:

Here's an example of dashboard that launches to various entities and summarizes data specific to the user.  A different approach to the Personal Wall.

Here’s an example of dashboard that launches to various entities and summarizes data specific to the user

A dashboard customized around the users day-to-day needs allows for users to quickly see and get to pertinent information.  In my case, my team mainly focuses on the companies, projects and tasks assigned to us individually.

Read More »

© Copyright 2012-2014, All Rights Reserved