Why would running certain reports terminates the ASP session

[jupiter8]

After running certain reports the ASP session is terminated, so that when a user clicks on a link to go back to the site, they are forced to log in again as the session I use for tracking who's logged in has been terminated.

Now this only appears to happen when I start including more than 3 or 4 subreports, and incidentally the reports all work fine.

I'm using Crystal Enterprise 8.0 on a WIN2K sp3 and calling the reports via the URL method, but I have not at this pointed added any service packs.

Is this a know issue, because I never seen it mentioned anywhere?

 

[TedLiu]

If you are using asp page to call it, you will have a cleanup.asp same folder as rptserver.asp, in cleanup.asp, it will abondon all the sessions for checking concurrent user issue. Since your are using Win2k, you can simply change it into remove session seperately.

Hope it helps!

Ted

 

[jupiter8]

I call the report by redirecting to the rpt file and passing in the parameters via the URL, which I guess is not quite the same thing as above. I certainly do not have the files mentioned anywhere on the server.

 

[TedLiu]

Seems you are using URL reporting, but as soon as you are not using Crystal Enterprise CSP pages, which is different with crystal report, CR needs to clean up session after each report session finished to control concurrent user licenses (5 only).

Hope it will give you some hints.

 

[skkoh]

Hi,

I also find the problem on asp that when i am using the cleanup.asp and all the session is kill and use will need
to logon again. If any can help me pls.


hi TedLiu,

I am using W2k how remove session seperately?

tks/skkoh

 

[TedLiu]

Hi skkoh,

If you are using IIS 5.0 and asp 3.0, then you can just destroy session by session.item("sessionname&quot.remove, this is not available for asp 2.0 with IIS 4.0

Ted