Solved

Crystal Reports XI: 100% of cpu usage (w3wp.exe) when viewing reports

Posted on 2008-06-23
13
2,385 Views
Last Modified: 2013-12-09
Dear Experts,

I have an asp.net (VS 2003) app with reports in CR XI . The problem is the performance in the web server. My web server is a Pentium D with 4 Gb RAM - Windows 2003 Server Standard Edition - SQL Server 2000 Standard Edition - IIS 6.0 - .NET Framework 1.1.

The app runs fast but when the user click to view a report, the performance slow down and takes 30-60 seconds to show the Crystal Reports Viewer. I've checked the task manager and the CPU usage for the w3wp.exe processor going to 100% and stay there until the report appear on the viewer!! That is a problem because I have 20-30 users using the app at the same time.

My questions:
1)      How can I reduce this time ?
2)      This amount of CPU usage is normal for the w3wp.exe when CR starts the report ?
3)      Can I get the report without the viewer ? I tried to export direct to pdf but the time was the same. It's better viewing in the pdf viewer because when paginate, search, etc... the processing is doing on the local machine.
4)       Have anyone update to CR XI R2 ? It's faster then CR XI R1 ?

Can anyone help ? Thanks !

Pablo Braga
0
Comment
Question by:Pablo_Braga
  • 6
  • 5
13 Comments
 
LVL 100

Accepted Solution

by:
mlmcc earned 480 total points
ID: 21849739
Question 4 first
Release 2 was developed to handle changes with VS 2005.  (Basically .Net 2.0).  See
http://support.businessobjects.com/downloads/service_packs/crxir2.asp

Is the machine using the same printer that the report was built with?

Are you using the same database?

mlmcc
0
 

Author Comment

by:Pablo_Braga
ID: 21849937
Hi mlmcc, thanks for reply !

Question 4: OK. I understand.

>> Is the machine using the same printer that the report was built with?
No. The machine is a web server and I don't have any printer installed there.

>> Are you using the same database?
What do you mean ? The databases are in other machine. I have 30 databases (the structure are equal, but is 1 database per client) with different names.

Pablo
0
 
LVL 100

Assisted Solution

by:mlmcc
mlmcc earned 480 total points
ID: 21850129
Crystal looks for the printer when it tries to render the report.

You might try adding a dummy printer driver to the web server.

Crystal will sometimes look for the original database thus slowing report generation down.

mlmcc
0
 

Author Comment

by:Pablo_Braga
ID: 21850877
I have just installed a Generic Printer in the server, but time and cpu usage are very similar... and more: the format of report was changed ! Before the report had 611 pages and with the generic printer goes to 759 pages. I deleted the generic printer.
Do you have other clue for that ?

>> Crystal will sometimes look for the original database thus slowing report generation down.
Sorry, but I don't understand this point. How CR do that ? And why "sometimes" ?

Thanks,

Pablo

PS: I checked the Event Viewer of the server and look what I have found. Do you have any idea ? There is a lot of entries like that...

The description for Event ID ( 4352 ) in Source ( Crystal Reports ) cannot be found. The local computer may not have the necessary registry information or message DLL files to display messages from a remote computer. You may be able to use the /AUXSOURCE= flag to retrieve this description; see Help and Support for details. The following information is part of the event: A Crystal Reports job was delayed 8 seconds waiting for a free license to become available. More licenses can be purchased direct from Business Objects or through the Business Objects Online Store.
0
 
LVL 100

Assisted Solution

by:mlmcc
mlmcc earned 480 total points
ID: 21851361
Install the same printer dirver as you have on the development machine.  The printer doesn't have to exist, since you won't print to it.

Database comment.  The sometimes is just that.  In some cases it seems to search for the original database.  In others the change takes effect and it doesn't search.  I don't know the reason for that.

mlmcc
0
 

Author Comment

by:Pablo_Braga
ID: 21851657
OK. I will install the printer driver and test the performance. Thanks for the clue.

And what about the questions 1, 2 and 3. Can anyone help me ?

Pablo
0
Do You Know the 4 Main Threat Actor Types?

Do you know the main threat actor types? Most attackers fall into one of four categories, each with their own favored tactics, techniques, and procedures.

 
LVL 100

Assisted Solution

by:mlmcc
mlmcc earned 480 total points
ID: 21851949
3.  Export - Yes you can export directly to pdf but the report is generated using the same method as the viewer.  Only the destination has changed, thus there is no difference in timing.  Export still uses the printer driver to do the export.

If you never need to print the report from Crystal you can set the NO PRINTER optionin PAGE SETUP.  That optimizes the report for display.  That might speed it up.

Does the report pull a lot of data and filter it in the report?

mlmcc
0
 

Author Comment

by:Pablo_Braga
ID: 21855760
Hi,

Question 3: OK !

I will test this option (set NO PRINTER) and see if speeds the report.
>> Does the report pull a lot of data and filter it in the report?
No. All the data is filtered directly by stored procedure in SQL Server. I use CR only to print the data.

Thanks.
0
 
LVL 100

Assisted Solution

by:mlmcc
mlmcc earned 480 total points
ID: 21857564
Are there any complex calculations?

ARe the tables linked on indexed fields?

mlmcc
0
 

Assisted Solution

by:K2NS
K2NS earned 20 total points
ID: 21860003
I am having a very similar issue; Crystal Reports 2008.
The CPU load for CRW32.exe pins to 99% if the report is foreground. Even if I open the the OPTIONS windows, the CPU load for drops to 2%. The report window has a 'flicker' to it like it is in constant refresh. I have tried the above suggestions without success.

Keith
0
 

Author Comment

by:Pablo_Braga
ID: 21900484
Hi,

I've made more tests and the behavior is the same.

The reports don't have complex calculations and there are no linked tables. I've made a test using a single report (with no data) and the cpu usage is still 100%.

I don't know what to do at this time. I'll try to migrate to VS 2005 and then use the R2 version.
0
 
LVL 100

Assisted Solution

by:mlmcc
mlmcc earned 480 total points
ID: 21956334
YOu asked multiple questions and several of them were answered.  The experts involved should get credit.

mlmcc
0

Featured Post

How to run any project with ease

Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
- Combine task lists, docs, spreadsheets, and chat in one
- View and edit from mobile/offline
- Cut down on emails

Join & Write a Comment

Suggested Solutions

In my previous two articles we discussed Binary Serialization (http://www.experts-exchange.com/A_4362.html) and XML Serialization (http://www.experts-exchange.com/A_4425.html). In this article we will try to know more about SOAP (Simple Object Acces…
A long time ago (May 2011), I have written an article showing you how to create a DLL using Visual Studio 2005 to be hosted in SQL Server 2005. That was valid at that time and it is still valid if you are still using these versions. You can still re…
Sending a Secure fax is easy with eFax Corporate (http://www.enterprise.efax.com). First, Just open a new email message.  In the To field, type your recipient's fax number @efaxsend.com. You can even send a secure international fax — just include t…
Internet Business Fax to Email Made Easy - With eFax Corporate (http://www.enterprise.efax.com), you'll receive a dedicated online fax number, which is used the same way as a typical analog fax number. You'll receive secure faxes in your email, fr…

746 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

Need Help in Real-Time?

Connect with top rated Experts

13 Experts available now in Live!

Get 1:1 Help Now