Report Hangs

[AndyNova]

I am using ASP to call a report that is based on a Stored Procedure, using CR8 and SQL 2000/IIS5.

All reports will run fine then one will be selected from the ASP page and the report simply hangs. The ActiveX viewer does not even appear.

It hangs on this line of code, when it is trying to open the report.

Set session("oRpt&quot = session("oApp&quot.OpenReport(basePath & "myreport.rpt", 1)

All the reports hang and the only way to get them back up and working is to reboot the web server. Once that is done they all work well again for a while then the problem occurs again.

Any suggestions ?

 

[Guest_imported]

I'm having the same problem with NT4 and Oracle. :-( But I've found that I don't have to reboot the server. Issue the MTXSTOP command from a command line. It may be different for COM+ in Win2000 though...

 

[mthakershi]

Wild guess but I hope you guys have correct paths in SmartViewerActiveX.asp file.

For example your site name is XXYYZZ and there is folder named "Reports" in which there are all reports, SmartViewerActiveX.asp, rptServer and report.asp file.

Things to check are the codebase points to correct location of ActiveXViewer.cab file.

Then CRViewer.ReportName and CRViewer.ReportSource should also point to correct location of RptServer.asp file.

Don't think this is the problem with you guys because first post says, reports work fine for sometimes and then they suddenly start hanging.

Tell me if you guys got solution or some other way so you don't have to reboot the server.

Keep Smiling,
Malay M. Thakershi
mthakershi@yahoo.co.in