ThreadAbortException when trying to fill a dataset

Hi all,
Hoping someone can shed some light. I am trying to track down an issue that
I see on an off in our logs. I get a System.Threading.ThreadAbortException
that occurs down in the SNINativeMethodWrapper.SNIPacketGetConnection method
(Stack trace at the bottom of post. Could this be a timeout error being
thrown back by SQL? Or could a heavy server load cause the wrapper being
unable to GetConnection to the server? The latter is my WAG of what might be
going on but I would like confirmation.

Thanks,

John

<StackTrace> at SNINativeMethodWrapper.SNIPacketGetConnection(IntPtr
packet)
at System.Data.SqlClient.TdsParserStateObject.ProcessSniPacket(IntPtr
packet, UInt32 error)
at System.Data.SqlClient.TdsParserStateObject.ReadSni(DbAsyncResult
asyncResult, TdsParserStateObject stateObj)
at System.Data.SqlClient.TdsParserStateObject.ReadPacket(Int32
bytesExpected)
at System.Data.SqlClient.TdsParserStateObject.ReadBuffer()
at System.Data.SqlClient.TdsParserStateObject.ReadByte()
at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior,
SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet
bulkCopyHandler, TdsParserStateObject stateObj)
at System.Data.SqlClient.SqlDataReader.ConsumeMetaData()
at System.Data.SqlClient.SqlDataReader.get_MetaData()
at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds,
RunBehavior runBehavior, String resetOptionsString)
at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior
cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async)
at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior
cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method,
DbAsyncResult result)
at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior
cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method)
at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior
behavior, String method)
at System.Data.SqlClient.SqlCommand.ExecuteDbDataReader(CommandBehavior
behavior)
at
System.Data.Common.DbCommand.System.Data.IDbCommand.ExecuteReader(CommandBehavior behavior)
at System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset,
DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable,
IDbCommand command, CommandBehavior behavior)
at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32
startRecord, Int32 maxRecords, String srcTable, IDbCommand command,
CommandBehavior behavior)
at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet)
at
Microsoft.Practices.EnterpriseLibrary.Data.Database.DoLoadDataSet(DbCommand
command, DataSet dataSet, String[] tableNames)
at
Microsoft.Practices.EnterpriseLibrary.Data.Database.LoadDataSet(DbCommand
command, DataSet dataSet, String[] tableNames)
at
Microsoft.Practices.EnterpriseLibrary.Data.Database.LoadDataSet(DbCommand
command, DataSet dataSet, String tableName)
at
Microsoft.Practices.EnterpriseLibrary.Data.Database.ExecuteDataSet(DbCommand
command)
at
XXXXX.XXX.LPT.DataAccess.Profile.SearchProfileCriteria(ProfileSearchCriteria
profileSearchCriteria)
at
XXXXX.XXX.LPT.BusinessComponents.Profile.SearchProfileCriteria(ProfileSearchCriteria profileSearchCriteria)
at
XXXXX.XXX.LPT.BusinessFacade.ProfileManager.SearchProfileCriteria(ProfileSearchCriteria profileSearchCriteria)</StackTrace>
</InnerException>
.

Relevant Pages

  • RE: Error in DataList test query - aspnet 2.0
    ... exception, Boolean breakConnection) +68 ... System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand ... RunBehavior runBehavior, String resetOptionsString) +294 ... IDbCommand command, CommandBehavior behavior) +139 ...
    (microsoft.public.dotnet.framework.aspnet.webcontrols)
  • Re: Help - Procedure expects parameter - Its There!!!
    ... Public Property FKJobIDAs String ... here is the sql command from DataAccess.vb that is trying to get ... Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand ... command, CommandBehavior behavior) ...
    (microsoft.public.dotnet.framework.windowsforms)
  • Re: ASP.NET SQL Timeout! help!
    ... > Exception Details: System.Data.SqlClient.SqlException: Timeout expired. ... > startRecord, Int32 maxRecords, String srcTable, IDbCommand command, ... > Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior ...
    (microsoft.public.dotnet.framework.aspnet)
  • ASP.NET SQL Timeout! help!
    ... Increasing timeouts on IIS 5.0 ... use the "Connection Timeout=2400" string in the SqlConnection connections ... Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior ...
    (microsoft.public.dotnet.framework.aspnet)
  • TIP #185: Null Handling
    ... nulls, and command modifications for manipulating them. ... Tcl deals with strings, the universal medium for representing data. ... is know and it is an empty string, but if a respondent forgets to give ...
    (comp.lang.tcl)