Wrox Programmer Forums
|
Pro VB 6 For advanced Visual Basic coders working in version 6 (not .NET). Beginning-level questions will be redirected to other forums, including Beginning VB 6.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Pro VB 6 section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old July 29th, 2006, 11:11 PM
Registered User
 
Join Date: Jul 2006
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts
Default Session time out issue

Kindly help me out of session time_out.How true is the statement below.Very eagerly waiting to hear for a quick help,please.

As per the details, there are two web servers in load balancing. Suppose, first time a request goes to Server1 for login validation, login is validated and sessions are created. Now when user clicks on topic for assessment, request goes to Server 2 on this occasion but it will not find any sessions (as session is created on Server 1) and hence it will throw an exception for session time out.

And Here is the log file details getting generated:
Stack Trace :
   at System.Web.UI.Page.HandleError(Exception e)
   at System.Web.UI.Page.ProcessRequestMain()
   at System.Web.UI.Page.ProcessRequest()
   at System.Web.UI.Page.ProcessRequest(HttpContext context)
   at System.Web.CallHandlerExecutionStep.System.Web.Htt pApplication+IExecutionStep.Execute()
   at System.Web.HttpApplication.ExecuteStep(IExecutionS tep step, Boolean& completedSynchronously)

Error Description :
System.Web.HttpUnhandledException: Exception of type System.Web.HttpUnhandledException was thrown. ---> System.Data.SqlClient.SqlException: Prepared statement '(@TopicID bigint,@UserID nvarchar(4000))SET DATEFORMAT 'dmy';Upd' expects parameter @TopicID, which was not supplied.
   at System.Data.SqlClient.SqlCommand.ExecuteReader(Com mandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream)
   at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
   at PSG.clsDatabaseLayer.SimpleQueryN(eQueryObjectType e, String strQuery, Object[] ParamValueList)
   at PSG.completecourse.Page_Load(Object sender, EventArgs e)
   at System.Web.UI.Control.OnLoad(EventArgs e)
   at System.Web.UI.Control.LoadRecursive()
   at System.Web.UI.Page.ProcessRequestMain()
   --- End of inner exception stack trace ---
   at System.Web.UI.Page.HandleError(Exception e)
   at System.Web.UI.Page.ProcessRequestMain()
   at System.Web.UI.Page.ProcessRequest()
   at System.Web.UI.Page.ProcessRequest(HttpContext context)
   at System.Web.CallHandlerExecutionStep.System.Web.Htt pApplication+IExecutionStep.Execute()
   at System.Web.HttpApplication.ExecuteStep(IExecutionS tep step, Boolean& completedSynchronously)

Kindly guide me through this.
Thanks
 
Old July 31st, 2006, 11:29 AM
Friend of Wrox
 
Join Date: Nov 2004
Posts: 1,621
Thanks: 1
Thanked 3 Times in 3 Posts
Default

What is the internet server software? Is it IIS?





Similar Threads
Thread Thread Starter Forum Replies Last Post
Session Related Issue asmii Beginning PHP 3 October 5th, 2008 07:07 PM
Session issue with VWD Bob Bedell ASP.NET 2.0 Professional 3 December 26th, 2007 04:20 AM
ASP.NET Applications and Session Issue ricardoghunter Classic ASP Basics 0 September 13th, 2004 04:40 PM
session time out lily611 General .NET 10 August 9th, 2004 08:51 AM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.