Microsoft KB Archive/829886

= Viewing or printing reports that contain more than 20,000 records may fail =

Article ID: 829886

Article Last Modified on 10/25/2005

-

APPLIES TO


 * Microsoft Business Solutions CRM 1.0

-



SYMPTOMS
When you run a report on a computer that is running Microsoft Business Solutions CRM and that has many records in the database, the report retrieves many records. However, you may receive one or more of the following error messages:

Error message 1:

Error encountered by Crystal PageServer

The error message returned is:

Get last page number failed. File b643028beae2140.rpt. [On Cache/Page Server: .pageserver]

Error message 2:

Error encountered by Crystal PageServer

The error message returned is:

&quot;Max processing time/Max records limit reached&quot; [On Cache/Page Server: .pageserver]

Error message 3:

Server Error in &quot;/&quot; Application

Request timed out.

Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.Web.HttpException: Request timed out.

Source Error:

An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.

Stack Trace:

[HttpException (0x80004005): Request timed out.]



CAUSE
This behavior may occur if there is a built-in limit on the Crystal Enterprise 9 Page Server service that permits the server to process no more than 20,000 records. If the server processes this many records, the Page Server service may stop, and you may receive an error message.

The &quot;Server Error in '/' Application&quot; error message may appear if you pull more data into a report than Microsoft CRM can process in the default ASP.NET timeout value of 90 seconds.



RESOLUTION
To resolve this behavior, use these methods in the order they are presented until your issue is resolved.

Method 1: Reconfigure the Crystal Page Server service
If you receive any one of the Crystal Page Server service error messages that are described earlier in this article, reconfigure the Crystal Page Server service. To do this, follow these steps:  Click Start, point to Programs, point to Crystal Enterprise 9, and then click Crystal Configuration Manager. Stop the Page Server service. Right-click Crystal Page Server, click Properties, and then examine the Command field. If maxDBResultRecords 0 is not included in the command, add the following to the end of this command text:

-maxDBResultRecords 0

 Restart Crystal Page Server.</ol>

Method 2: Install the Microsoft CRM 1.0 Reporting Engine update
If you receive the &quot;Server Error in '/' Application&quot; error message that is described earlier in this article, install the Microsoft CRM 1.0 reporting engine update.

Installation Information
To obtain this update, visit the following Microsoft Web site:

http://www.microsoft.com/downloads/details.aspx?FamilyID=034f541d-d841-4620-b0d7-5a604d68c8ef&DisplayLang=en

Install this update on the Microsoft CRM server. Make sure that the Microsoft Business Solutions CRM Deployment Manager is closed before you install this update. This update supports the following Setup switches:
 * /?: Display the list of installation switches.
 * /u: Use Unattended mode.
 * /f: Force other programs to quit when the computer shuts down.
 * /z: Do not restart when the installation is complete.
 * /q: Use Quiet mode (no user interaction).
 * /x: Extract the files without running Setup.

For example, to install the update without any user intervention, use the following command line:

CRM1.0-KB829886-Server-Windows2000.exe /u /q

To verify that the update is installed on your computer, confirm that the following registry key exists:

Removal Information
You cannot remove this update.

Restart Requirement
You do not have to restart your computer after you install this update.

File Information
The English version of this hotfix has the file attributes (or later file attributes) that are listed in the following table. The dates and times for these files are listed in Coordinated Universal Time (UTC). When you view the file information, it is converted to local time. To find the difference between UTC and local time, use the Time Zone tab in the Date and Time tool in Control Panel. <pre class="fixed_text">  Date         Time   Version     Size     File name --  07-Nov-2003  17:04  1.0.3017.1  178,736  CRMQueryRecordset.dll 06-Nov-2003 10:36  8.7.0.22    467,044  Crmscrmbridge.dll 06-Nov-2003 10:38  8.7.0.22    290,819  Crmscrmconnector.dll 06-Nov-2003 10:46  8.7.0.22     90,219  Crmscrmstatus_res_en.dll 14-Oct-2003 11:27  1.0.3017.2   39,512  Microsoft.CRM.Pages.Reports.dll 06-Nov-2003 10:38  8.7.0.22     36,666  P2smscrm.dll 24-Oct-2003 15:50  8.6.1.815   684,089  Exlate85.dll

Method 3: Install the Microsoft CRM 1.0 Reports update
If you still receive the &quot;Server Error in '/' Application&quot; error message after you install the reports update KB829886 that is described in &quot;Method 2&quot;, install the Microsoft CRM 1.0 reports update KB829888 (a set of rewritten reports). To obtain this update, visit the following Microsoft Web site:

http://www.microsoft.com/downloads/details.aspx?FamilyID=034f541d-d841-4620-b0d7-5a604d68c8ef&DisplayLang=en

Note If you have customized reports by the same name, back up your customized reports, replace them with the reports that are included with update 829888, and then reapply your customizations to the new reports as required.

Method 4: Customize the Default Microsoft CRM 1.0 Reports to Limit the Record Set Received
If you still receive the &quot;Server Error in '/' Application&quot; error message after you install the reporting engine update KB829886 that is described in &quot;Method 2&quot; earlier in this article, customize the default Microsoft CRM 1.0 reports to limit the retrieved record set.

When you run reports that have very large datasets, data retrieval can sometimes be slow. Retrieval speed depends on dataset size and hardware and network configuration. If the speed of the data retrieval results in a timeout, you may want to customize your reports to access a smaller dataset. This action decreases the retrieval time and avoids the timeout.

To reduce the number of records, you can add a &quot;Record Selection Formula&quot; to the report. The following example discusses the &quot;Account List By Territory&quot; report. This report lists all the accounts by territory. You can use a record selection formula to break this report into each territory.

For example, if you have four territories: Northern, Southern, Eastern, and Western, you can create four reports from the existing &quot;Account List By Territory&quot; report. You can limit each new report to the four territories. To do so, edit the report in Crystal Reports Designer: <ol> Turn off the Grouptree option.</li> Add a record selection formula that is similar to the following record selection formula to the report:

{account. }=&quot;Northern&quot;

</li> Save the report as &quot;Account List By Northern Territory&quot; or other name.</li></ol>

Method 5: Extend the Timeout Value
If you still have timeout issues, extend the timeout value. By default, the timeout value is 90 seconds. If you experience timeouts because of the number of records that are retrieved after you install the reporting engine update, install the enhanced reports, and limit the record sets that the reports retrieve, incrementally increase the reporting engine's timeout value. To do so, specify that timeout value in a Web.config file in the Inetpub\Wwwroot\Reports folder. (See the procedure below to create the Web.config file).This Web.config file increases the timeout value for the reporting engine to 10 minutes (600 seconds) without affecting the timeout values for the CRM Web application or other .NET applications that run on the server that hosts Microsoft CRM.

To create a Web.config file in the Inetpub\Wwwroot\Reports folder, follow these steps: <ol> Click Start, click Run, and then in the Open box, type:

notepad C:\inetpub\wwwroot\Reports\web.config

</li> Click OK, and then click Yes.</li> Copy and paste the following lines:

<?xml version=&quot;1.0&quot; encoding=&quot;utf-8&quot;?>

<system.web>

<httpRuntime executionTimeout=&quot;600&quot;/>

</system.web>

</li> On the File menu, click Save, and then click Exit.</li></ol>

Method 6: Write parameter-driven reports
To improve the performance of reports, parameters limit the amount of data that the report includes. Therefore, parameter-driven reports help provide reports that give you only the data that you need. For more information about how to write parameter-driven reports for Microsoft CRM 1.2, click the following article number to view the article in the Microsoft Knowledge Base:

834790 How to use Crystal Reports 9 to write parameter-driven reports for Microsoft CRM 1.2

Keywords: kberrmsg kbqfe kbmbsmigrate kbhotfixserver kbmbsreports KB829886

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.