468,761 Members | 1,731 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 468,761 developers. It's quick & easy.

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

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
1 2712
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.

Similar topics

1 post views Thread by DotNet Guerrilla | last post: by
5 posts views Thread by Loane Sharp | last post: by
4 posts views Thread by chuckdfoster | last post: by
17 posts views Thread by Peter Proost | last post: by
reply views Thread by Chris | last post: by
2 posts views Thread by Fred Flintstone | last post: by
reply views Thread by Bryan | last post: by
reply views Thread by zhoujie | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.