Crystal Enterprise 10 - Timeout Error

We are getting following two errors when we are trying to preview report using Crystal Enterprise Admin/User Launchpad.

  1. The request timed out because there has been no reply from the server for 600,000 milliseconds - This error comes when we use Advanced DHTML viewer

  2. The Page Server you are trying to connect to is not accessible. Please contact system Administrator [on cache/page server: servername]. - This error comes when we use Activex Viewer.

We are using Crystal Enterprise 10, installed on AIX, and having Websphere as Application server.

Any help will be greatly appreciated.

Regards.
Error Snapshot.doc (53.0 KB)


godgift :india: (BOB member since 2004-07-09)

Moved from “General Discussion” to “Building Reports” ==> Legacy Crystal Products.

All discussions of Crystal versions before XI should take place in that forum.


Anita Craig :us: (BOB member since 2002-06-17)

I take it that your page server is virtual? Is your page server caching reports when you try to print? I found it useful to problem solve these types of issues step by step - ensure that in the CMC your page server is enabled etc


Decisys :de: (BOB member since 2004-05-21)

Could you please help me to understabr what it means - ‘page server is virtual’. And how to check, if page server is caching report or not

Page server and cache servers are both up and running. Still I am getting this error.

Any help.

Thanks


godgift :india: (BOB member since 2004-07-09)

“Virtual” meaning -in this case - that it´s a folder on a Drive which has similar properties to a server but isn´t a physical server - Browse your Crystal Decisions folder on the server to locate the Page Server folder. If your page server is cacheing, you should be able to see recent files in the page server folder - you may have multiple page server folders.

  1. Are the page serves and cache servers enabled in the Crystal Management Console (note: CMC is not CCM the latter being Crystal Configuration Manager)? In the Config Manager your page and cache servers may be running but if they are not enabled in Console Management, you may get print errors.

  2. Do you have any info to share with respect to “Event Management”?


Decisys :de: (BOB member since 2004-05-21)

Hi
I its similar error for me… i am getting error
Request time out because there was no reply from the server for 600000 milliseconds.

Idle time on all the file server page server and cache sever has been set up to 30 mins.

. Where else do we need to set up the time out parameter apart from CMC ?

In cache server i am getting

Any suggestions will be highly appreciated
Arvind


arvindsetty (BOB member since 2009-03-12)

Hi guys,

If any body has solved the issue plz post here.
I have changed each 600000 entry in registry to 24000000, and also checked in clientSDKOptions.xml
I have also changed the parameter from CrystalReportEngine-config.xml file
from 10
to
300 , restarted the computer and all enterprize services in crystal configuration manager but the problem is still there.

Plz help me as I have to solve this problem urgently.


faisal (BOB member since 2009-12-08)

It sounds to me like a badly written / HUGE report that is too large to be run under View-On-Demand.

Just for a test, please SCHEDULE this report to PDF format with the same parameters as you other tests and see how long it takes to run and how many records/pages it returns.


MJRBIM :canada: (BOB member since 2007-03-23)

Yes. the report is very huge as it gets data from multiple tables and one of the tables has rows more than 5 lacs.
I have generated the report from crystal developer edition and it takes almost 30 min to 1 hour to generate.

There are a number of other reports that are getting generated from the same reporting module because they fetch less data.

Is there a limitation to running larger reports under view-on-demand.
I am using Enterprise server 10 for reports.
If I switch to Enterprise 11 version would this problem be solved.

Please explain


faisal (BOB member since 2009-12-08)

If it takes 30 min to 1 hour to generate on the desktop, it would take at least that long to run as View-On-Demand within Enterprise…and almost all web applications will “die” if the browser has to wait that long for a response.

Your only solutions are to (a) improve the report on the dekstop so that response-time is under a minute [if possible], or (b) use the SCHEDULE function in InfoView to generate an instance of the report to the PDF format that will more easily support large page-counts [eg. 1,000+].

My own rule of thumb for View-on-Demand is under a minute, and under 500 pages - otherwise we schedule an instance.


MJRBIM :canada: (BOB member since 2007-03-23)

MJRBIM

Thank you sir for your time and the information. We are already under the process of optimizing the reports for faster processing and decrease the response time.

I dont have any idea about the SCHEDULE function of InfoView. If you have any good info than Plz post the links. I will also search for this option.


faisal (BOB member since 2009-12-08)