By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
428,978 Members | 1,467 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 428,978 IT Pros & Developers. It's quick & easy.

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

P: n/a
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%2 0Client(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,

Sep 14 '06 #1
Share this Question
Share on Google+
1 Reply


P: n/a
On 14 Sep 2006 13:15:48 -0700, pm***********@gmx.net wrote:
>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%2 0Client(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..
Sep 15 '06 #2

This discussion thread is closed

Replies have been disabled for this discussion.