Hi,
I have a set of crystal reports that I need to let the users view on ASP pages. Therefore I used the Crystal Smart Viewer. It has been working well, until recently, about 3 days back, the user keep experiencing "User Session has expired" when trying to retrieve the pages.
I thought that there may be some issues with the database, so I rebooted it, and it works well for a while, before the "User session has expired" thingy turns up again.
If I run the crystal report directly without going through the ASP page, the report can be displayed.
Can someone help me with why and how can I resolve this problem? Thanks!
I'm using Crystal Report 7, MS SQL database.
This Question has been solved and asker verified All Experts Exchange premium technology solutions are available to subscription members.
Experts Exchange has been collecting answers to technology questions since 1996…3 million and counting! If you have a question, chances are we already have your answer.
If you can't find the exact answer you're looking for, ask our exclusive community of 50,000 experts. You’ll get a personalized answer from a trusted professional.
Thousands of free tech tips, tricks, how-to’s and tutorials are available in our peer reviewed articles section. See for yourself how smart our experts are, no login required.
Save solutions to your questions, answers you’ve discovered through searching plus helpful articles in your personal knowledgebase for easy future access.
Access the answers to your technology questions today.
30-day free trial. Register in 60 seconds.
Members of the expert community talk about why the experience at Experts Exchange is different than what you will find anywhere else.
Try it out and discover for yourself.
30-day free trial. Register in 60 seconds.
Join the community of experts here and help other tech pros by answering question in your area of expertise. You can earn FREE access to all Experts Exchange's premium features and resources.
Hi,
I include the connection part for one of the reports:
--------------------------
Dim vReportName
vReportName = "Handover Confirmation Report.rpt"
If Not IsObject (Session("oApp")) Then
Set Session("oApp") = Server.CreateObject("Cryst
End If
Dim vPath, iLen
vPath = Request.ServerVariables("P
While (Right(vPath, 1) <> "\" And Len(vPath) <> 0)
iLen = Len(vPath) - 1
vPath = Left(vPath, iLen)
Wend
session("oApp").LogonServe
Set Session("oRpt") = Session("oApp").OpenReport
set Session("oRptOptions") = Session("oRpt").Options
Session("oRptOptions").Mor
set Session("ParamCollection")
Dim Param1, Param2, Param3, Param4, Param5, Param6
set Param1 = Session("ParamCollection")
set Param2 = Session("ParamCollection")
set Param3 = Session("ParamCollection")
Dim ParamValue1, ParamValue2, ParamValue3, ParamValue4, ParamValue5, ParamValue6
ParamValue1 = Session("strUserID")
ParamValue2 = Request.Form("select1")
ParamValue3 = Request.Form("select2")
Call Param1.SetCurrentValue (CStr(ParamValue1), 12)
Call Param2.SetCurrentValue (CStr(ParamValue2), 12)
Call Param3.SetCurrentValue (CDbl(ParamValue3), 7)
On Error Resume Next
Session("oRpt").ReadRecord
If Err.Number <> 0 Then
Response.Write ("Error returned: " & err.number & " meaning: " & err.description)
Else
If IsObject (Session("oPageEngine")) Then
set Session("oPageEngine") = nothing
end if
set Session("oPageEngine") = Session("oRpt").PageEngine
End If
<HTML>
<HEAD>
<TITLE>Seagate Crystal Smart Viewer for ActiveX</TITLE>
</HEAD>
<BODY BGCOLOR=C6C6C6 LANGUAGE=VBScript ONLOAD="Page_Initialize">
<OBJECT ID="CRViewer"
CLASSID="CLSID:C4847596-97
WIDTH=100% HEIGHT=95%
codebase="/viewer/activeXV
<PARAM NAME="EnableRefreshButton"
<PARAM NAME="EnableGroupTree" VALUE=0>
<PARAM NAME="DisplayGroupTree" VALUE=0>
<PARAM NAME="EnablePrintButton" VALUE=1>
<PARAM NAME="EnableExportButton" VALUE=1>
<PARAM NAME="EnableDrillDown" VALUE=1>
<PARAM NAME="EnableSearchControl"
<PARAM NAME="EnableAnimationContr
<PARAM NAME="EnableZoomControl" VALUE=1>
</OBJECT>
<SCRIPT LANGUAGE="VBScript">
<!--
Sub Page_Initialize
On Error Resume Next
Dim webBroker
Set webBroker = CreateObject("WebReportBro
if ScriptEngineMajorVersion < 2 then
window.alert "IE 3.02 users on NT4 need to get the latest version of VBScript or install IE 4.01 SP1. IE 3.02 users on Win95 need DCOM95 and latest version of VBScript, or install IE 4.01 SP1. These files are available at Microsoft's web site."
CRViewer.ReportName = Location.Protocol + "//" + Location.Host +"/scrreports/rptserver.as
else
Dim webSource
Set webSource = CreateObject("WebReportSou
webSource.ReportSource = webBroker
webSource.URL = Location.Protocol + "//" + Location.Host + "/scrreports/rptserver.asp
webSource.PromptOnRefresh = True
CRViewer.ReportSource = webSource
end if
CRViewer.ViewReport
End Sub
-->
</SCRIPT>
</BODY>
</HTML>
<%End If%>
<%
Set objCatRecord = Nothing
Set objCatResponse = Nothing
Set objCat = Nothing
%>
One of the causes of the 20534 is invalid logon information
session("oApp").LogonServe
I don't know ASP that well but is SESSION needed before each string?
Is it retrieving the correct information?
mlmcc
Hi,
I don't know ASP that well either, so I can't comment why is "session" required. :( I inherited this set of codes.
The codes have been running well for 2 years, so I don't think it's likely that it suddenly pick up the wrong values. Anyway, I need try hardcoding the values into:
session("oApp").LogonServe
(assuming the above are my actual values.)
But the error still occurs.
The interesting thing is, once I reboot my app server and database server, it will run for sometime, and after a while, stop working...
Business Accounts
Answer for Membership
by: mlmccPosted on 2003-11-02 at 20:17:39ID: 9668663
Look at
http://support.crystaldeci
http://support.crystaldeci
http://support.crystaldeci
mlmcc