Microsoft KB Archive/891192

= You receive the &quot;An error has occurred. For more information, contact your system administrator&quot; error message when you try to view sales information for an account in Microsoft CRM =

Article ID: 891192

Article Last Modified on 9/20/2006

-

APPLIES TO


 * Microsoft CRM 1.2
 * Microsoft Business Solutions CRM 1.0

-





End user symptoms
When you try to view sales information for an account in Microsoft CRM, you receive the following error message:

Error:

An error has occurred. For more information, contact your system administrator.

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:

Server encountered a stack overflow error message during compile time

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:

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.

Error Number:

0x80040E14

Source File:

Not Available

Line Number:

Not Available

Query String: /_grid/grid_data.aspxsortCol=name&sorDir=ascend&viewed={00000000-0000-0000-00AA-000010001203}&api=CRMAccount.RetrieveAllOpportunities&filter=&oId={598F7FC6-10BD-4674-9D3E-E941D7F07AA6}&oType=1&pageNum=1

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.



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



WORKAROUND
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.



STATUS
Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the &quot;Applies to&quot; 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 &quot;Symptoms&quot; section.

