End user symptoms

When you try to view sales information for an account in Microsoft CRM, you receive the following error message:If you are using Microsoft SQL Server 2000 Service Pack 3 (SP3) build 8.00.760 or 8.00.818, you may receive the following error message:

Developer symptoms

If you have enabled the DevErrors mode in the Web.config file so that you can see detailed error messages, you receive the following error message:

Microsoft CRM Server application event log error

When you view the Microsoft CRM Server application event log, you see the following error message:

MSCRM Platform Error Report: -------------------------------------------------------------------------------------------------------- Error: Internal Query Processor Error: The query processor ran out of stack space during query optimization.

Error Message: Internal Query Processor Error: The query processor ran out of stack space during query optimization.

Error Details: Details on this error have not been provided by the platform.

Source File: Not available

Line Number: Not available
Stack Trace Info: at System.Web.UI.Page.HandleError(Exception e)
at System.Web.UI.Page.ProcessRequestMain()
at System.Web.UI.Page.ProcessRequest()
at System.Web.UI.Page.ProcessRequest(HttpContext context)
at System.Web.CallHandlerExecutionStep.System.Web.HttpApplication+IExecutionStep.Execute() at System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously)

For more information, see Help and Support Center at http://support.microsoft.com.

This problem occurs if more than 8,000 contacts are associated with an account.

You cannot see the associated views for the opportunities, the quotes, the orders, and the invoices for a single account that has more than 8,000 contacts. However, you can use one of the following workarounds to work around this problem.

Workaround 1

Use alternative data entry points to create, to update, and to delete opportunities, quotes, orders, and invoices for any account record that has more than 8,000 contacts. Alternative data entry points include the following:

• The Opportunity form
• The Quote form
• The Order form
• The Microsoft CRM Invoice form

For reporting, you can use the order reports, the quote reports, the opportunity reports, and the invoice reports in the Microsoft CRM application.

Workaround 2

Set up multiple accounts for the account that has more than 8,000 contacts. For example, if you have an account that is named Company_A, you can create accounts that are named Company_A1, Company_A2, and Company_A3. For better reporting, you can use the first account (Company_A1 in this example) as the parent account for the other CRM accounts for this company. After you establish the additional accounts and the parent/child relationship or relationships, you must move a subset of the contacts from the parent account into each child account. You can then delete the account that has over 8,000 contacts. To avoid the problem that this article describes, make sure that no account has more than 8,000 contacts.

Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section.This issue is scheduled to be corrected in Microsoft CRM 2005.

Steps to reproduce the behavior

1. Open an account that has more than 8,000 contacts.
2. In the left pane, click Sales.

You receive the error message that is mentioned in the "Symptoms" section.

For additional information about DevErrors mode, click the following article number to view the article in the Microsoft Knowledge Base: