Troubleshooting

Re: Errors In ASP .NET App

tomkmvp — Tue, 14 Jul 2009 18:25:02 GMT

Someone over at http://forums.asp.net/ should be able to answer that.

Re: Errors In ASP .NET App

dsheldon — Tue, 14 Jul 2009 18:17:36 GMT

Thanks to all for the help with this one. As it turns out, the connection was static. I modified my code to use local connections that do not reside in a module and the problems seem to have gone away. I don't know what exactly is going on under the hood, but I do agree with tomkmvp that the data from a previous user was somehow being preserved.

Again thanks for the help. I appreciate it!!

Re: Errors In ASP .NET App

tomkmvp — Mon, 13 Jul 2009 19:13:29 GMT

It's not so much about modules and session state as it is about connections. Does the problem go away if you remove that bit of connection checking logic? Seems to me like the connection is held open between requests and it's preserving the data from previous requests.

Re: Errors In ASP .NET App

Paul Lynch — Mon, 13 Jul 2009 19:01:52 GMT

Hi,

See if this helps at all :

Fast, Scalable, and Secure Session State Management for Your Web Applications

Retrieving User Specific Data With ASP.NET Membership and Session Variable

Regards,

Re: Errors In ASP .NET App

dsheldon — Mon, 13 Jul 2009 18:23:52 GMT

Below is the code for initializing cnn. This is done in a module. I wonder if you may be on to something there. This is my first ASP .NET app and as I am used to Windows forms development I never had to worry about session state and static variables.(Listen to me all full of excuses hey?? :-) Anyway, my question is ' Does ASP .NET handle anything coded in modules as static code?'. If so , I think I have my answer. Thanks to tomkmvp and Paul Lynch for the help.

Friend cnn As New SqlClient.SqlConnection(ConfigurationManager.ConnectionStrings("ConnectionString").ConnectionString)

Re: Errors In ASP .NET App

tomkmvp — Mon, 13 Jul 2009 17:42:27 GMT

dsheldon:
If Not cnn.State = ConnectionState.Open Then cnn.Open()

Hmm ... where does cnn get initialized? Does the porblem go away if you remove the "if then" logic and just open the connection everytime?

Re: Errors In ASP .NET App

Paul Lynch — Mon, 13 Jul 2009 16:58:27 GMT

dsheldon:
We also noticed that if there are multiple users, when a user opens the login form, the employee number that is prepopulated will be the number of the employee that accessed the form before them.

That sounds like the user is being allocated the session of the previously logged-on user. How does this application manage session state exactly ?

Re: Errors In ASP .NET App

dsheldon — Mon, 13 Jul 2009 15:41:04 GMT

Below is the code that fills the employee number text box. It is very simple code and really leaves no room for error. Thanks for your help.

Private Sub Page_PreRender(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.PreRender

'FILL THE EMPLOYEE NUMBER BOX WITH THE EMPLOYEE LOGGED IN TO THE PC

Try

Dim user As String = HttpContext.Current.User.Identity.Name.ToString()

If user.IndexOf("\") >= 0 Then

user = user.Substring(user.IndexOf("\") + 1, user.Length - user.IndexOf("\") - 1)

End If

If user <> "" And Not user = Nothing Then

Try

'GET THE EMPLOYEE'S ID NUMBER FROM THE EMPLOYEE DATABASE

Dim da As New SqlDataAdapter("SELECT EmployeeID FROM Employee.dbo.tblEmployee WHERE UserName = @User", cnn)

da.SelectCommand.CommandType = CommandType.Text

da.SelectCommand.Parameters.AddWithValue("@User", user)

Dim ds As New DataSet

If Not cnn.State = ConnectionState.Open Then cnn.Open()

da.Fill(ds)

If ds.Tables(0).Rows.Count > 0 Then

txtEmpNumber.Text = ds.Tables(0).Rows(0).Item("EmployeeID").ToString

txtPassword.Focus()

Else

txtEmpNumber.Focus()

End If

Catch ex As Exception

lblError.Text = ex.Message ' & vbNewLine & ex.StackTrace

lblError.Visible = True

Finally

cnn.Close()

End Try

End If

Catch ex As Exception

txtEmpNumber.Text = ""

End Try

End Sub

Re: Errors In ASP .NET App

tomkmvp — Mon, 13 Jul 2009 15:31:13 GMT

dsheldon:
I know that this is not an issue with the code.

I'm not so sure of that.

dsheldon:
We also noticed that if there are multiple users, when a user opens the login form, the employee number that is prepopulated will be the number of the employee that accessed the form before them.

Please share this code.

Errors In ASP .NET App

dsheldon — Mon, 13 Jul 2009 15:07:00 GMT

I am having a problem in an ASP .NET application that we are finishing up that is only now rearing it's ugly head. We have deployed the app to several departments for testing and now that there are multiple users on the system strange things are happening.

The app is running in IIS 6 on a Windows 2003 server. It was developed in Visual Studio 2008 targetting .NET 3.5. There is a login form that prepopulates with an employee number determined by the Windows user that is accessing the site. We have a centralized employee database that is a combination of AD information and employee data from our Accounting package and we tie into it using the Windows login account. IIS and SQL are on the same server and the IIIS App Pool that this application uses runs under the context of a domain account that has been assigned the dbo role on the database. I have even tried other IIS servers and other SQL boxes for the database.

Anyway, if only 1 person accesses the site at a time it works great. As soon as a second person logs in we start seeing errors appear. Most of them appear to be related to code that manipulates SQL data(ie 'Table 0 does not exist' or 'Column or property EmployeeID does not belong to table Table'). We also noticed that if there are multiple users, when a user opens the login form, the employee number that is prepopulated will be the number of the employee that accessed the form before them.

Like I said, we have moved the app and database to differrent servers with no luck. I know that this is not an issue with the code. It works fine in development and when used by only 1 user, but anything past that and it goes nuts. I have turned off our antivirus software, changed the App Pool, changed the identity that the App Pool runs under and republished multiple times but I feel like I'm spinning my wheels. I don't know if this is an issue with ASP .NET state management or if there is a limit on the number of allowed connections somewhere or what the problem may be, but it sure is giving us fits. Any help that you could give would be greatly appreciated!!