Solved

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

Posted on 2008-06-23
13
2,432 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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
Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 

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

DevOps Toolchain Recommendations

Read this Gartner Research Note and discover how your IT organization can automate and optimize DevOps processes using a toolchain architecture.

Question has a verified solution.

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

As cyber crime continues to grow in both numbers and sophistication, a troubling trend of optimization has emerged over the last year.
Nobody understands Phishing better than an anti-spam company. That’s why we are providing Phishing Awareness Training to our customers. According to a report by Verizon, only 3% of targeted users report malicious emails to management. With compan…
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …

710 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