SQL and C#: Exception handling and making sense of messages from an exception dialog box

[EDN Admin]

Hello All,
My C# application, which operates from a Windows Form, periodically calls 8 different SqlCommand queries (one at a time). Ive set the CommandTimeout to 1000 for each, thinking that this will be more than enough time for the query to execute over
a large database table of over 22,000,000 decimal values.
After running the application overnight, on each of the past few days, Ive been getting the same exception message, and for me and my limited experience, the messages are quite indecipherable.
Here is what the exception messages are (from an exception message box that was thrown):
See the end of this message for details on invoking <br/>
just-in-time (JIT) debugging instead of this dialog box.
************** Exception Text **************<br/>
System.Data.SqlClient.SqlException (0x80131904): Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding.<br/>
at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)<br/>
at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning()<br/>
at System.Data.SqlClient.TdsParserStateObject.ReadSniError(TdsParserStateObject stateObj, UInt32 error)<br/>
at System.Data.SqlClient.TdsParserStateObject.ReadSni(DbAsyncResult asyncResult, TdsParserStateObject stateObj)<br/>
at System.Data.SqlClient.TdsParserStateObject.ReadNetworkPacket()<br/>
at System.Data.SqlClient.TdsParserStateObject.ReadBuffer()<br/>
at System.Data.SqlClient.TdsParserStateObject.ReadByte()<br/>
at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)<br/>
at System.Data.SqlClient.SqlInternalConnectionTds.CompleteLogin(Boolean enlistOK)<br/>
at System.Data.SqlClient.SqlInternalConnectionTds.AttemptOneLogin(ServerInfo serverInfo, String newPassword, Boolean ignoreSniOpenTimeout, TimeoutTimer timeout, SqlConnection owningObject)<br/>
at System.Data.SqlClient.SqlInternalConnectionTds.LoginNoFailover(ServerInfo serverInfo, String newPassword, Boolean redirectedUserInstance, SqlConnection owningObject, SqlConnectionString connectionOptions, TimeoutTimer timeout)<br/>
at System.Data.SqlClient.SqlInternalConnectionTds.OpenLoginEnlist(SqlConnection owningObject, TimeoutTimer timeout, SqlConnectionString connectionOptions, String newPassword, Boolean redirectedUserInstance)<br/>
at System.Data.SqlClient.SqlInternalConnectionTds..ctor(DbConnectionPoolIdentity identity, SqlConnectionString connectionOptions, Object providerInfo, String newPassword, SqlConnection owningObject, Boolean redirectedUserInstance)<br/>
at System.Data.SqlClient.SqlConnectionFactory.CreateConnection(DbConnectionOptions options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningConnection)<br/>
at System.Data.ProviderBase.DbConnectionFactory.CreatePooledConnection(DbConnection owningConnection, DbConnectionPool pool, DbConnectionOptions options)<br/>
at System.Data.ProviderBase.DbConnectionPool.CreateObject(DbConnection owningObject)<br/>
at System.Data.ProviderBase.DbConnectionPool.UserCreateRequest(DbConnection owningObject)<br/>
at System.Data.ProviderBase.DbConnectionPool.GetConnection(DbConnection owningObject)<br/>
at System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection)<br/>
at System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory)<br/>
at System.Data.SqlClient.SqlConnection.Open()<br/>
at GUI.Migrate.TrackMovements(Double startLocfromChoose) in E:TO FLASHGUIGUIMigrate.cs:line 231<br/>
at GUI.Migrate.ChooseStart() in E:TO FLASHGUIGUIMigrate.cs:line 132<br/>
at GUI.Migrate.Entry(Int32 numberofpaths) in E:TO FLASHGUIGUIMigrate.cs:line 79<br/>
at GUI.Form1.button5_Click(Object sender, EventArgs e) in E:TO FLASHGUIGUIForm1.cs:line 131<br/>
at System.Windows.Forms.Control.OnClick(EventArgs e)<br/>
at System.Windows.Forms.Button.OnClick(EventArgs e)<br/>
at System.Windows.Forms.Button.PerformClick()<br/>
at System.Windows.Forms.Form.ProcessDialogKey(Keys keyData)<br/>
at System.Windows.Forms.Control.ProcessDialogKey(Keys keyData)<br/>
at System.Windows.Forms.Control.PreProcessMessage(Message& msg)<br/>
at System.Windows.Forms.Control.PreProcessControlMessageInternal(Control target, Message& msg)<br/>
at System.Windows.Forms.Application.ThreadContext.PreTranslateMessage(MSG& msg)
<br/>
************** Loaded Assemblies **************<br/>
mscorlib<br/>
Assembly Version: 4.0.0.0<br/>
Win32 Version: 4.0.30319.296 (RTMGDR.030319-2900)<br/>
CodeBase: file:///C:/Windows/Microsoft.NET/Framework/v4.0.30319/mscorlib.dll
file:///C:/Windows/Microsoft.NET/Framework/v4.0.30319/mscorlib.dll <br/>
----------------------------------------<br/>
GUI<br/>
Assembly Version: 1.1.0.0<br/>
Win32 Version: 1.0.0.0<br/>
CodeBase: file:///E:/TO%20FLASH/GUI/GUI/bin/Debug/GUI.exe
file:///E:/TO%20FLASH/GUI/GUI/bin/Debug/GUI.exe <br/>
----------------------------------------<br/>
System.Windows.Forms<br/>
Assembly Version: 4.0.0.0<br/>
Win32 Version: 4.0.30319.278 built by: RTMGDR<br/>
CodeBase: file:///C:/Windows/Microsoft.Net/assembly/GAC_MSIL/System.Windows.Forms/v4.0_4.0.0.0__b77a5c561934e089/System.Windows.Forms.dll
file:///C:/Windows/Microsoft.Net/assembly/GAC_MSIL/System.Windows.Forms/v4.0_4.0.0.0__b77a5c561934e089/System.Windows.Forms.dll <br/>
----------------------------------------<br/>
System.Drawing<br/>
Assembly Version: 4.0.0.0<br/>
Win32 Version: 4.0.30319.282 built by: RTMGDR<br/>
CodeBase: file:///C:/Windows/Microsoft.Net/assembly/GAC_MSIL/System.Drawing/v4.0_4.0.0.0__b03f5f7f11d50a3a/System.Drawing.dll
file:///C:/Windows/Microsoft.Net/assembly/GAC_MSIL/System.Drawing/v4.0_4.0.0.0__b03f5f7f11d50a3a/System.Drawing.dll <br/>
----------------------------------------<br/>
System<br/>
Assembly Version: 4.0.0.0<br/>
Win32 Version: 4.0.30319.296 built by: RTMGDR<br/>
CodeBase: file:///C:/Windows/Microsoft.Net/assembly/GAC_MSIL/System/v4.0_4.0.0.0__b77a5c561934e089/System.dll
file:///C:/Windows/Microsoft.Net/assembly/GAC_MSIL/System/v4.0_4.0.0.0__b77a5c561934e089/System.dll <br/>
----------------------------------------<br/>
System.Configuration<br/>
Assembly Version: 4.0.0.0<br/>
Win32 Version: 4.0.30319.1 (RTMRel.030319-0100)<br/>
CodeBase: file:///C:/Windows/Microsoft.Net/assembly/GAC_MSIL/System.Configuration/v4.0_4.0.0.0__b03f5f7f11d50a3a/System.Configuration.dll
file:///C:/Windows/Microsoft.Net/assembly/GAC_MSIL/System.Configuration/v4.0_4.0.0.0__b03f5f7f11d50a3a/System.Configuration.dll <br/>
----------------------------------------<br/>
System.Xml<br/>
Assembly Version: 4.0.0.0<br/>
Win32 Version: 4.0.30319.233 built by: RTMGDR<br/>
CodeBase: file:///C:/Windows/Microsoft.Net/assembly/GAC_MSIL/System.Xml/v4.0_4.0.0.0__b77a5c561934e089/System.Xml.dll
file:///C:/Windows/Microsoft.Net/assembly/GAC_MSIL/System.Xml/v4.0_4.0.0.0__b77a5c561934e089/System.Xml.dll <br/>
----------------------------------------<br/>
System.Core<br/>
Assembly Version: 4.0.0.0<br/>
Win32 Version: 4.0.30319.233 built by: RTMGDR<br/>
CodeBase: file:///C:/Windows/Microsoft.Net/assembly/GAC_MSIL/System.Core/v4.0_4.0.0.0__b77a5c561934e089/System.Core.dll
file:///C:/Windows/Microsoft.Net/assembly/GAC_MSIL/System.Core/v4.0_4.0.0.0__b77a5c561934e089/System.Core.dll <br/>
----------------------------------------<br/>
System.Data<br/>
Assembly Version: 4.0.0.0<br/>
Win32 Version: 4.0.30319.245 (RTMGDR.030319-2400)<br/>
CodeBase: file:///C:/Windows/Microsoft.Net/assembly/GAC_32/System.Data/v4.0_4.0.0.0__b77a5c561934e089/System.Data.dll
file:///C:/Windows/Microsoft.Net/assembly/GAC_32/System.Data/v4.0_4.0.0.0__b77a5c561934e089/System.Data.dll <br/>
----------------------------------------<br/>
System.Transactions<br/>
Assembly Version: 4.0.0.0<br/>
Win32 Version: 4.0.30319.1 (RTMRel.030319-0100)<br/>
CodeBase: file:///C:/Windows/Microsoft.Net/assembly/GAC_32/System.Transactions/v4.0_4.0.0.0__b77a5c561934e089/System.Transactions.dll
file:///C:/Windows/Microsoft.Net/assembly/GAC_32/System.Transactions/v4.0_4.0.0.0__b77a5c561934e089/System.Transactions.dll <br/>
----------------------------------------<br/>
System.EnterpriseServices<br/>
Assembly Version: 4.0.0.0<br/>
Win32 Version: 4.0.30319.1 (RTMRel.030319-0100)<br/>
CodeBase: file:///C:/Windows/Microsoft.Net/assembly/GAC_32/System.EnterpriseServices/v4.0_4.0.0.0__b03f5f7f11d50a3a/System.EnterpriseServices.dll
file:///C:/Windows/Microsoft.Net/assembly/GAC_32/System.EnterpriseServices/v4.0_4.0.0.0__b03f5f7f11d50a3a/System.EnterpriseServices.dll <br/>
----------------------------------------
************** JIT Debugging **************<br/>
To enable just-in-time (JIT) debugging, the .config file for this<br/>
application or computer (machine.config) must have the<br/>
jitDebugging value set in the system.windows.forms section.<br/>
The application must also be compiled with debugging<br/>
enabled.
For example:
<configuration><br/>
<system.windows.forms jitDebugging="true" /><br/>
</configuration>
When JIT debugging is enabled, any unhandled exception<br/>
will be sent to the JIT debugger registered on the computer<br/>
rather than be handled by this dialog box.
************** Exception Text **************
Can someone help me make sense of these messages? Does this have to deal with the CommandTimeout or the ConnectionTimeout?
Thank you in advance.
-AD-

<
AndrewDen

View the full article