Hi forum members,
I developed a ASP.NET application (a Content Management System) that is online by now. It can be used by around 500 registered users at the same time. There is a feature I implemented which sends me automatic error messages (via e-mail) whenever an error occurs in the application (while a user is working).
Unfortunately I keep getting these strange error messages each having something to do with ADO.NET (I'm running SQL-Server 2000 on a seperate database server).
This is one of the strange error I'm getting:
Code:
SqlCommand-Object: (CommandText=member_select_PrivilegesById)(CommandType=StoredProcedure)(Connection=server=192.168.100.20; uid=bikenet;database=bikenet; Connection Timeout=60; Min Pool Size=10; Max Pool Size=2000)
SqlDataAdapter-Object: (SelectCommand<>null)
Object reference not set to an instance of an object. at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream)
at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior)
at System.Data.SqlClient.SqlCommand.System.Data.IDbCommand.ExecuteReader(CommandBehavior behavior)
at System.Data.Common.DbDataAdapter.FillFromCommand(Object data, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior)
at System.Data.Common.DbDataAdapter.Fill(DataTable dataTable, IDbCommand command, CommandBehavior behavior)
at System.Data.Common.DbDataAdapter.Fill(DataTable dataTable)
at index_red.DB_Abfrage.ReturnDataTable() in c:\inetpub\wwwroot\index_red\db_abfrage.cs:line 108
at index_red.DB_Abfrage.ReturnDataTable() in c:\inetpub\wwwroot\index_red\db_abfrage.cs:line 116
at index_red.UserFuncs.GetUserMode(Int32 member_id) in c:\inetpub\wwwroot\index_red\auxiliaries.cs:line 293
at index_red.UserFuncs.GetBaseFile(HttpSessionState Session) in c:\inetpub\wwwroot\index_red\auxiliaries.cs:line 333
at index_red.sa_gebraucht_main.lbtnListe_Click(Object sender, EventArgs e) in C:\Inetpub\wwwroot\index_red\sa_gebraucht_main.ascx.cs:line 105
at System.Web.UI.WebControls.LinkButton.OnClick(EventArgs e)
at System.Web.UI.WebControls.LinkButton.System.Web.UI.IPostBackEventHandler.RaisePostBackEvent(String eventArgument)
at System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler sourceControl, String eventArgument)
at System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData)
at System.Web.UI.Page.ProcessRequestMain()
The first few lines are inserted by the error handling method just to make sure everything is fine. However my SqlCommand-Object seems to be valid (with a valid connection). Something goes wrong with the SqlDataAdapter.
Another error message I sometimes get is:
Code:
Internal connection fatal error. at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream)
at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior)
at System.Data.SqlClient.SqlCommand.System.Data.IDbCommand.ExecuteReader(CommandBehavior behavior)
at System.Data.Common.DbDataAdapter.FillFromCommand(Object data, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior)
at System.Data.Common.DbDataAdapter.Fill(DataTable dataTable, IDbCommand command, CommandBehavior behavior)
at System.Data.Common.DbDataAdapter.Fill(DataTable dataTable)
or
Code:
Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding.
at System.Data.SqlClient.SqlDataReader.InternalClose(Boolean closeReader)
at System.Data.SqlClient.SqlDataReader.Close()
at System.Data.SqlClient.SqlConnection.CloseReader()
at System.Data.SqlClient.SqlConnection.Close()
These error happen around 10 to 20 times a day randomly for random users. I have no idea what's wrong. I can post my database class if you need it.
Regards,
Krisztian