View Single Post
  #1 (permalink)  
Old January 15th, 2007, 02:40 PM
bunnyhopper bunnyhopper is offline
Registered User
 
Join Date: Jan 2007
Location: Sopron, Györ-Moson-Sopron megye, Hungary.
Posts: 8
Thanks: 0
Thanked 0 Times in 0 Posts
Default Strange trouble with ADO.NET

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