Hon
Wed Dec 03 19:14:59 CST 2003
Thanks for posting this out guys.
The hotfix for the Crystal Reports saved my project... which means I only
had to proceed to Method 2. Didn't get a chance (and hopefully not) to
proceed with the rest.... :)
Oh yes - you will need to sign a document to get hold of the hotfix (at
least that was my procedure). It is protected by a password that is time
controlled...
Good luck!
"John O'Donnell" <csharpconsulting@nospam-hotmail.com-nospam> wrote in
message news:uXDifVbuDHA.2492@TK2MSFTNGP12.phx.gbl...
> here is the article - thanks for the heads up sebastiano
>
>
> TechKnowledge
> Error "Server Error in "/" Application Request timed out"
occurs
> when you run reports in Microsoft CRM
>
>
> Return to previous page
>
> Document ID: 33881
> Date Created: 11/21/2003
> Date Last Modified: 12/1/2003 3:20:31 PM
> Language: English - United States
> Country: USA
> Product: Microsoft CRM
> Versions: 1.0
> Modules: Microsoft CRM Reports
>
> The information in this article applies to:
>
> - Microsoft CRM 1.0
>
> SYMPTOMS
>
> When you run a report on a Microsoft Business Solutions
> CRM-based computer that has many records in the database, while the report
> that you run retrieves many records, 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: <SERVERNAME>.pageserver]
>
> Error message 2:
>
> Error encountered by Crystal PageServer
> The error message returned is:
> "Max processing time/Max records limit reached" [On Cache/Page
> Server: <SERVERNAME>.pageserver]
>
> Error message 3:
>
> Server Error in "/" 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
> PageServer service that permits it to process no more than 20,000 records.
> If the server processes this many records, the Crystal Enterprise
PageServer
> service may stop, and you may receive one of the error messages that are
> described in this article.
>
> The "Server Error in '/' Application" 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 Enterprise PageServer
Service
>
> If you receive the Crystal PageServer errors that are
described
> in this article, reconfigure the Crystal Enterprise PageServer. To do so,
> follow these steps:
>
> 1. Open the Crystal Configuration Manager. To do so, click
> Start, point to Programs, point to Crystal Enterprise and then click
Crystal
> Configuration Manager.
>
> 2. Stop Crystal PageServer. To do so, click Start, point to
> Administrative Tools, click Services, right-click Crystal Page Server and
> then click Stop.
>
> 3. Right-click Crystal Page Server, click Properties and then
> confirm that the Path to Executable box contains the following line:
>
> -maxDBResultRecords 0
>
> 4. If -maxDBResultRecords 0 does not appear in the Path to
> Executable box, at the end of the text, type:
>
> -maxDBResultRecords 0
>
> 5. Restart the PageServer.
>
> Method 2: Install the Microsoft CRM 1.0 Reporting Engine
Hotfix
>
> If you receive the "Server Error in '/' Application" error
> message that is described in this article, install the Microsoft CRM 1.0
> Reporting Engine Hotfix.
>
> Installation Information
>
> To obtain this hotfix, visit the following Microsoft Web site:
>
>
>
http://download.microsoft.com/download/1/d/4/1d486253-1c19-4106-bf9a-e796f9118e18/CRM1.0-KB829886-Server-Windows2000.exe
>
> Install this hotfix on the Microsoft CRM server. Make sure
that
> the Microsoft Business Solutions CRM Deployment Manager is closed before
you
> install this hotfix. This hotfix 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 hotfix without any user
> intervention, use the following command line:
>
> CRM1.0-KB829886-Server-Windows2000.exe /u /q
>
> To make sure that the hotfix is installed on your computer,
> confirm that the following registry key exists:
>
> HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Updates\Microsoft
> CRM\1.0\Server\SP0\KB829886
>
> Removal Information
>
> You cannot remove this hotfix.
>
> Restart Requirement
>
> You do not have to restart your computer after you install
this
> hotfix.
>
> File Information
>
> The English version of this hotfix has the file attributes (or
> later) 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.
>
> 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 Hotfix
>
> If you still receive the "Server Error in '/' Application"
error
> message after you install the reports hotfix KB829886 that is described in
> Method 2, install the Microsoft CRM 1.0 Reports Hotfix KB829888 (a set of
> rewritten reports). To obtain this hotfix, visit the following Microsoft
Web
> site:
>
> www.microsoft.com/downloads/
>
> Note If you have customized reports by the same name, back up
> your customized reports, replace them with the reports that are included
> with hotfix 829888 and then re-apply 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 "Server Error in '/' Application"
error
> message after you install the Reporting Engine Hotfix KB829886 that is
> described in Method 2 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 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, add a "Record Selection
> Formula" to the report. The following example discusses the "Account List
By
> Territory" report. This report lists all the Accounts by Territory. Use a
> record selection formula to break this report into each Territory.
>
> For example, if you have four Territories: Northern, Southern,
> Eastern, and Western, create four reports from the existing "Account List
By
> Territory" report. Limit each new report to the four Territories. To do
so,
> edit the report in Crystal Reports Designer:
>
> 1. Turn off the Grouptree option.
>
> 2. Add a record selection formula that is similar to the
> following record selection formula to the report:
>
> {Account.TerritoryIDName}="Northern"
>
> 3. Save the report as "Account List By Northern Territory" or
> other name.
>
> 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 Hotfix, 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:
>
> Create a Web.config file
>
> 1. Click Start, click Run and then in the Open box, type:
>
> notepad C:\inetpub\wwwroot\Reports\web.config
>
> 2. Click OK and then click Yes.
> 3. Copy and paste the following lines:
>
> <?xml version="1.0" encoding="utf-8"?>
> <configuration>
> <system.web>
> <httpRuntime executionTimeout="600"/>
> </system.web>
> </configuration>
>
> 4. On the File menu, click Save and then click Exit.
>
>
>
>
>
> "Sebastiano Castrini" <[remove this]castrini@libero.it> wrote in message
> news:ueF%2317auDHA.1760@TK2MSFTNGP10.phx.gbl...
> > I discovered the solution last nigth.
> > You can find it in partnersource / techknowledge
> > documenti id = 33881
> >
> > It works !
> > Sebastiano.
> >
> >
> >
> > "Hon" <hon@businessprocess.com.sg> ha scritto nel messaggio
> > news:OIPCaVZuDHA.3496@TK2MSFTNGP11.phx.gbl...
> > > To all out there who are having timeout problems with Crystal Reports
> > within
> > > MSCRM and as a result, unable to sleep at night....
> > >
> > > There is a fix from Microsoft which strangely enough is not in
> > > Partnersource. Do ask for it from your local MBS support....
> > >
> > > Hon
> > >
> > >
> >
> >
>
>