[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
?
Solved

Microsoft CRM Exporting reports

Posted on 2004-11-18
5
Medium Priority
?
1,123 Views
Last Modified: 2013-11-24
We have run across a situation where we are no long able to export reports to MS Word or MS Excel. In contact with MS CRM tech support and they to reload CRM, That is totally an unacceptable answer. We are using crystal reports to pull the info from the SQL DB.

Is there way to fix this issue without having to reload?

We get the following error msg:

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

 


--------------------------------------------------------------------------------
Version Information: Microsoft .NET Framework Version:1.0.3705.288; ASP.NET Version:1.0.3705.288

Any suggestions?

Regards
0
Comment
Question by:Kenneth_Canova
  • 4
5 Comments
 
LVL 6

Expert Comment

by:preitmeyer
ID: 12625313
The error happens because of a timeout with the IIS server, I'll have to look and see what needs to be edited, but I am pretty positive it is in the web.config on the CRM server, bear with me for a few minutes and I will get you what you need. This is a very common CRM error in 1.0 and 1.2
0
 
LVL 6

Accepted Solution

by:
preitmeyer earned 1000 total points
ID: 12625400
Here we go:


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.
0
 
LVL 6

Expert Comment

by:preitmeyer
ID: 12625416
I recommend using Methods #1, and especially Method #5
Ive done all methods I believe, but 1 and 5 should take care of your problem.
-Paul
0
 

Author Comment

by:Kenneth_Canova
ID: 12627064
All five methods were helpful, but as you sugested methods 1 and 5 healed our problem. I wish I could double the points.

Thanks Much,
0
 
LVL 6

Expert Comment

by:preitmeyer
ID: 12627076
Not a problem man,
Glad to be of service
-Paul
0

Featured Post

Hire Technology Freelancers with Gigs

Work with freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely, and get projects done right.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Oracle Apps Profiles option: A user profile is a set of shifting options that alter the way one runs an application. A value is set for each option under the user's profile when the Oracle application user logs on to any responsibility or changes…
Salesforce.com is a cloud-based customer relationship management (CRM) system. In this article, you will learn how to add and map custom lead and contact fields to your Salesforce instance.
Whether it be Exchange Server Crash Issues, Dirty Shutdown Errors or Failed to mount error, Stellar Phoenix Mailbox Exchange Recovery has always got your back. With the help of its easy to understand user interface and 3 simple steps recovery proced…
As many of you are aware about Scanpst.exe utility which is owned by Microsoft itself to repair inaccessible or damaged PST files, but the question is do you really think Scanpst.exe is capable to repair all sorts of PST related corruption issues?
Suggested Courses

872 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question