Session Variables Cleared afer Server.Execute

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: Phil Grimpo (PGrimpo)
Date: 01/27/05 

Date: Thu, 27 Jan 2005 00:10:59 -0600

I have a very odd situation here. I have an administration page, where
based on a users permissions, a recordset is called from the SQL server
which has a list of paths to "Module Menus". Each of these menus are then
placed into the page by calling Server.Execute(rs_Modules("ModulePath")).
This works fine for up to 15 "menus" After that, the session variables that
were set (not including those called by Global.ASA) are no longer set.

For example, when the site launches, Global.ASA sets a bunch of session
variables. Then when the user logs in more authentication session variables
are set ( I have a page where I can view all these). If the user only have
15 module menus available, all is well. Any more than that and when I check
the session variables, only those set in Global.asa are still there. This
means that when the user tries to click on a menu, the authentication
variables are gone, so they are re-directed to the login page. If I remove
some menus for the user, all is well again.

I'm also getting the following in the System Event Log:

A process serving application pool 'DefaultAppPool' suffered a fatal
communication error with the World Wide Web Publishing Service. The process
id was '3048'. The data field contains the error number.

After so many tries, the IIS server will hang and have to be restarted.

I have looked up some things on the web that say I can adjust Script Caching
and that will work, but that hasn't helped. Any idea A) why this is
happening and B) how I can fix it? It's a real show stopper.

Thanks!

-Phil

Relevant Pages

  • Session Variables Cleared afer Server.Execute
    ... a recordset is called from the SQL server ... which has a list of paths to "Module Menus". ... Then when the user logs in more authentication session variables ... communication error with the World Wide Web Publishing Service. ...
    (microsoft.public.inetserver.iis)
  • Re: Why do I get "name LocalSqlServer was not found" when my app uses MySQL?
    ... do if it doesn't have a sql server to stash session variables in ... ... clear the default provider and specify a custom provider: ... for sample access code to MySql using ASP.NET 2.0. ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: REPOST: window.open() causes session context to be lost?
    ... a web farm. ... being served up by the other server where session variables were different. ... Here is an article for how to configure sessions to run on a sql server: ... EnterpriseSession and InfoStore objects) that were populated in another ...
    (microsoft.public.dotnet.framework.aspnet)
  • Session state can only be used when enableSessionState is set to true, either in a configuration fil
    ... I use session variables. ... I have also tried page directives. ... I am using SQL Server on a Windows 2000 server and the website is on ... Windows 2000 Pro development computer. ...
    (microsoft.public.dotnet.languages.vb)
  • Re: Missing Menus
    ... The menus are missing from all templates. ... >> There are no such differences with SQL Server and WMSDE. ... >> WSS FAQ at http://wss.collutions.com ...
    (microsoft.public.sharepoint.windowsservices)