Microsoft KB Archive Search

Notice: This website is an unofficial Microsoft Knowledge Base (hereinafter KB) archive and is intended to provide a reliable access to deleted content from Microsoft KB. All KB articles are owned by Microsoft Corporation. Read full disclaimer for more details.

  1. Home
  2. The number of search results that is returned is 5,000 when you set the "Count" attribute to 20,000 in Microsoft Dynamics CRM

The number of search results that is returned is 5,000 when you set the "Count" attribute to 20,000 in Microsoft Dynamics CRM

View products that this article applies to.

Important This article contains information about how to modify the registry. Make sure that you back up the registry before you modify it. Make sure that you know how to restore the registry if a problem occurs. For more information about how to back up, restore, and modify the registry, click the following article number to view the article in the Microsoft Knowledge Base:
322756 How to back up and restore the registry in Windows

↑ Back to the top

Symptoms

You use the Count attribute in the FetchXml schema to create a query against the Microsoft Dynamics CRM database. Then, you set the Count attribute to 20,000. In this scenario, the number of search results that is returned is 5,000. Additionally, the SELECT statement in the SQL language is always SELECT TOP 5001 regardless of what is set for the Count attribute and for the Paging attribute.

↑ Back to the top

Cause

This issue occurs when you use the FetchXml schema to retrieve a resulting search set and when the moreRecords attribute is set to 1. The value of 1 indicates that more than 5,000 records are available. In Microsoft Dynamics CRM, the Paging attribute has a page limit of 5,000.

↑ Back to the top

Resolution

Microsoft provides programming examples for illustration only, without warranty either expressed or implied. This includes, but is not limited to, the implied warranties of merchantability or fitness for a particular purpose. This article assumes that you are familiar with the programming language that is being demonstrated and with the tools that are used to create and to debug procedures. Microsoft support engineers can help explain the functionality of a particular procedure. However, they will not modify these examples to provide added functionality or construct procedures to meet your specific requirements.

To resolve this issue, use the Paging attribute to retrieve records. Then, use the moreRecords attribute in the resulting search set to determine whether the next page should be returned.

For example, the following code demonstrates how to resolve this issue.
moreRecords = true;
i = 0;
while(moreRecords)
{
get page i
if(result has more records)
i++
else
moreRecords = false
}

↑ Back to the top

More Information

Warning Serious problems might occur if you modify the registry incorrectly by using Registry Editor or by using another method. These problems might require that you reinstall the operating system. Microsoft cannot guarantee that these problems can be solved. Modify the registry at your own risk.

To adjust the page limit to a value that is less than 5,000, add the MaxRowsPerPage DWORD Value to the registry. To do this, follow these steps:
  1. Click Start, click Run, type regedit in the Open box, and then click OK.
  2. Locate and then select the following registry subkey:
    HKEY_LOCAL_MACHINE\Software\Microsoft\MSCRM
  3. On the Edit menu, point to New, and then click DWORD Value.
  4. Type MaxRowsPerPage, and then press ENTER.
  5. Right-click MaxRowsPerPage, and then click Modify.
  6. Type a number that is less than or equal to 5,000 in the Value data box, and then click OK.
  7. On the File menu, click Exit.
To turn off the paging feature and then ignore the MaxRowsPerPage parameter of 5,000, add the TurnOffFetchThrottling DWORD Value to the registry. To do this, follow these steps.

Note Performing these steps may cause performance issues on your computer.
  1. Click Start, click Run, type regedit in the Open box, and then click OK.
  2. Locate and then select the following registry subkey:
    HKEY_LOCAL_MACHINE\Software\Microsoft\MSCRM
  3. On the Edit menu, point to New, and then click DWORD Value.
  4. Type TurnOffFetchThrottling, and then press ENTER.
  5. Right-click TurnOffFetchThrottling, and then click Modify.
  6. Type a number other than 0 in the Value data box, and then click OK.

    Note Step 6 lets you retrieve the number of records specified in the Count attribute of your fetch statement.
  7. On the File menu, click Exit.

↑ Back to the top

Keywords: kbmbspartner, kbsurveynew, kbprb, kbmbsmigrate, kbfreshness2007, kbtshoot, kb, kbmbscrm40, kbexpertiseinter

↑ Back to the top

Article Info
Article ID : 911510
Revision : 1
Created on : 1/7/2017
Published on : 1/27/2011
Exists online : False
Views : 291