Crystal Web ASP hangs on W2003 server, but had worked before.

P

pmkconsulting

Hello,
I am using an asp script that uses rptserver.asp to display some
reports over http. It worked fine previously but now the webpages with
the report display just hang. I tried switching from the activex viewer
to java viewer and still the same. I don't know what changed, except I
do the Windows updates. Can anyone tell me the best way to trouble ASP
problems. The page just stays blank forever and that status bar slowly
progresses. No errors in the event log on the server. The HTTPerr log
has the following errors:

2006-09-14 19:13:14 x.x.x.133 30531 x.x.x.5 80 HTTP/1.1 GET
/webreport/reports.asp?Report=Project%20List%20Detailed%20w%20Client(P).rpt
- 1 Connection_Dropped ReportsPool

No entries for this in the W3SVC log.

This started hanging my other web app on the server, until I put it in
a separate Application pool.

Here is the reports.asp code:

<%@ LANGUAGE="VBSCRIPT" %>

<%
'=======================================================================
' WORKING WITH THE REPORT DESIGNER COMPONENT AND ASP TO PREVIEW A
REPORT
'=======================================================================
'
' CONCEPT
'
' ALWAYS REQUIRED STEPS (contained in AlwaysRequiredSteps.asp)
' - create the application object
' - create the report object
' - open the report
'
' MORE ALWAYS REQUIRED STEPS (contained in MoreRequiredSteps.asp)
' - retreive the records
' - create the page engine
'
' DISPLAY THE REPORT
' - display the report using a smart viewer
'==================================================================
%>

<%
' This line creates a string variable called reportname that we will
use to pass
' the Crystal Report filename (.rpt file) to the OpenReport method
contained in
' the AlwaysRequiredSteps.asp.

reportname = Trim(Request("Report"))


%>

<%
'==================================================================
' ALWAYS REQUIRED STEPS
'
' Include the file AlwaysRequiredSteps.asp which contains the code
' for steps:
' - create the application object
' - create the report object
' - open the report
'==================================================================
%>
<!-- #include file="AlwaysRequiredSteps.asp" -->

<%
'==================================================================
'
' MORE ALWAYS REQUIRED STEPS
'
' Include the file MoreRequiredSteps.asp which contains the code
' for the steps:
' - retreive the records
' - create the page engine
' - create the smart viewer and point it to rptserver.asp
'
'==================================================================
%>
<!-- #include file="MoreRequiredSteps.asp" -->

<%
' INSTANTIATE THE REPORT VIEWER
'
'When using the Crystal Reports in an ASP environment, we use
'the same page-on-demand Report Viewers used with the Crystal Web
Component Server.
'There are six Report Viewers:
'
%>
<!-- #include file="SmartViewerActiveX.asp" -->

The other scritps are not modified from the crystal example.

Thank you,
 
T

Turkbear

Hello,
I am using an asp script that uses rptserver.asp to display some
reports over http. It worked fine previously but now the webpages with
the report display just hang. I tried switching from the activex viewer
to java viewer and still the same. I don't know what changed, except I
do the Windows updates. Can anyone tell me the best way to trouble ASP
problems. The page just stays blank forever and that status bar slowly
progresses. No errors in the event log on the server. The HTTPerr log
has the following errors:

2006-09-14 19:13:14 x.x.x.133 30531 x.x.x.5 80 HTTP/1.1 GET
/webreport/reports.asp?Report=Project%20List%20Detailed%20w%20Client(P).rpt
- 1 Connection_Dropped ReportsPool

No entries for this in the W3SVC log.

This started hanging my other web app on the server, until I put it in
a separate Application pool.
TRIMMED
Thank you,
What data connection is being used?
Try Installing CR designer on the web server and try the report(s) from there..You could be facing a timeout if the
report returns data slowly..
Check the query the report creates directly against the datasource..see how long it runs..
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Members online

No members online now.

Forum statistics

Threads
473,744
Messages
2,569,482
Members
44,901
Latest member
Noble71S45

Latest Threads

Top