Solved

intranet reports stopping Crystal Reports v8

Posted on 2004-08-06
10
499 Views
Last Modified: 2008-02-01
Hello,

I have an intermittent problem with crystal reports v8. Once in a while when using the intranet to view reports from a database, the report viewer will just sit there with an egg timer instead of refreshing. Eventually we have to re-boot the server to get it going again which is a real pain. (NT4.0 sp6).
The error log shows "the page server you are trying to connect to is not accessible". The stack dump inludes "c:\program files\seagate software\wcs\webcompserver.exe". Reports that do not use the database link such as word documents etc work fine.

Ive been told that we do not have a maximum number of concurrent users. Any help on how to restart the beast without a server shutdown, or how to cure the problem would be greatly appreciated. Being a novice i'm stumped

Geoff
0
Comment
Question by:GEOFF
  • 3
  • 2
  • 2
  • +1
10 Comments
 
LVL 19

Expert Comment

by:GJParker
ID: 11733813
This could have something to do with the Pagefile size on the server, This document will explain more

http://support.businessobjects.com/library/kbase/articles/c2007401.asp

HTH

Gary
0
 

Author Comment

by:GEOFF
ID: 11733885
Checked out the pagefile size, unfortunatley the settings are correct 267MB recommended and 267MB are set.
0
 
LVL 19

Expert Comment

by:GJParker
ID: 11733945
Sorry I couldn't help, I've seen this mentioned on a few other forums but couldn't find any resolutions. May be one of the other experst may be able to help.

Rather than rebooting the server have you tried just stopping and starting the services.

Good Luck

Gary
0
 

Author Comment

by:GEOFF
ID: 11733967
tried stopping the services and the old faithfull access denied appeared.

Thanks for trying

Geoff
0
Highfive + Dolby Voice = No More Audio Complaints!

Poor audio quality is one of the top reasons people don’t use video conferencing. Get the crispest, clearest audio powered by Dolby Voice in every meeting. Highfive and Dolby Voice deliver the best video conferencing and audio experience for every meeting and every room.

 
LVL 100

Accepted Solution

by:
mlmcc earned 250 total points
ID: 11734771
0
 
LVL 42

Expert Comment

by:frodoman
ID: 11734787
Have you looked at the database to see if the problem lies there?  Perhaps you have a concurrent users issue on your db not on Crystal?  Perhaps a db service has frozen?  The crystal viewer could freeze up because it's waiting for a response from the db and the db itself is locked up.

If you're getting an access denied message when stopping the services then I'm guessing you're trying to do it w/out full admin rights?  You can try restarting the db services if it seems possible that the db may be the cause.  Otherwise you should be able to restart Crystal services w/out a problem (no guarentee it'll resolve your crash of course) with admin rights.

frodoman
0
 

Author Comment

by:GEOFF
ID: 11735455
The db source is a live informix db, and it had'nt frozen. I tried to stop the services logged on to the server as the Administrator with full rights. This is not my lucky day. Also although we use crystal v8.0 localy i think its v6 on the server even though the head of it says not. He has been known to be wrong before.
0
 
LVL 42

Assisted Solution

by:frodoman
frodoman earned 250 total points
ID: 11735900
That certainly could be a problem!  CR8 is supposed to work on WinNT4 ( http://support.businessobjects.com/library/kbase/articles/c2006833.asp ) but I don't think CR6 was ever officially tested - unfortunately I can't find any documentation to confirm that.

Can you check the version to determine for certain which you have?  Also, if both versions 6 & 8 are on the machine that too can lead to problems ( http://support.businessobjects.com/library/kbase/articles/c2002466.asp ) so removing the older one is recommended.

frodoman
0

Featured Post

Threat Intelligence Starter Resources

Integrating threat intelligence can be challenging, and not all companies are ready. These resources can help you build awareness and prepare for defense.

Join & Write a Comment

I hate sub reports and always consider them the last resort in any reporting solution.  The negative effect on performance and maintainability is just not worth the easy ride they give the report writer.  Nine times out of ten reporting requirements…
Hello everyone, Hope you find this as helpful as we did. We have on the company I work for an application built in Delphi V with Crystal Reports 8. We all know that Crystal & Delphi can be temperamental sometimes and the worst thing is, nearly…
Excel styles will make formatting consistent and let you apply and change formatting faster. In this tutorial, you'll learn how to use Excel's built-in styles, how to modify styles, and how to create your own. You'll also learn how to use your custo…
Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…

705 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

19 Experts available now in Live!

Get 1:1 Help Now