Confusing error message

John J. Hughes II

I have a SqlDataAdapter.Fill filling a standard dataset and my code is
returning the below error. The "Error Loading data" is just a message my
code displays. "Error:" is the Exception.Message message and then below
that is the stack trace. The strange part is the "Error:" data is data
from the SQL database and obviously not an error so I don't see how or why
it is there. Any clues for determining why the code is throwing an
expection from this would be helpful.

Note being a little short sighted I don't trap the SqlException just the
Exception but normally that is more meaningful then this.

Error Loading data
Error:
71:
RP:09603ppppppppX!8op%&6#3' ppppppppX+pppppppp$)!pppp %&<])pppppppp\pppp
Stack:
at System.Data.SqlClient.SqlConnection.OnError(SqlExc eption exception,
Boolean breakConnection)
at System.Data.SqlClient.SqlInternalConnection.OnErro r(SqlException
exception, Boolean breakConnection)
at
System.Data.SqlClient.TdsParser.ThrowExceptionAndW arning(TdsParserStateObject
stateObj)
at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior,
SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet
bulkCopyHandler, TdsParserStateObject stateObj)
at System.Data.SqlClient.SqlDataReader.HasMoreRows()
at System.Data.SqlClient.SqlDataReader.ReadInternal(B oolean setTimeout)
at System.Data.SqlClient.SqlDataReader.Read()
at System.Data.Common.DataAdapter.FillLoadDataRow(Sch emaMapping mapping)
at System.Data.Common.DataAdapter.FillFromReader(Data Set dataset,
DataTable datatable, String srcTable, DataReaderContainer dataReader, Int32
startRecord, Int32 maxRecords, DataColumn parentChapterColumn, Object
parentChapterValue)
at System.Data.Common.DataAdapter.Fill(DataSet dataSet, String srcTable,
IDataReader dataReader, Int32 startRecord, Int32 maxRecords)
at System.Data.Common.DbDataAdapter.FillInternal(Data Set 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 Utils.dbFunc.LoadData(Form frm, SqlConnection cn, SqlDataAdapter ad,
DataSet ds, String msg)

Sep 22 '06 #1

Daniel

looks like your sql statement has a problem in it. Debug and stop when the
sql is about to execute. Take the sql statement and put it in Query Analyser
and run it direct, see if it works. If it does you can scrub the sql
statement as a possible issue, but i think you'll find your sql statement
throws an error ;)

"John J. Hughes II" <no@invalid.comwrote in message
news:OO*************@TK2MSFTNGP06.phx.gbl...

>I have a SqlDataAdapter.Fill filling a standard dataset and my code is
returning the below error. The "Error Loading data" is just a message my
code displays. "Error:" is the Exception.Message message and then below
that is the stack trace. The strange part is the "Error:" data is data
from the SQL database and obviously not an error so I don't see how or why
it is there. Any clues for determining why the code is throwing an
expection from this would be helpful.

Note being a little short sighted I don't trap the SqlException just the
Exception but normally that is more meaningful then this.

Error Loading data
Error:
71:
RP:09603ppppppppX!8op%&6#3' ppppppppX+pppppppp$)!pppp %&<])pppppppp\pppp
Stack:
at System.Data.SqlClient.SqlConnection.OnError(SqlExc eption exception,
Boolean breakConnection)
at System.Data.SqlClient.SqlInternalConnection.OnErro r(SqlException
exception, Boolean breakConnection)
at
System.Data.SqlClient.TdsParser.ThrowExceptionAndW arning(TdsParserStateObject
stateObj)
at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior,
SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet
bulkCopyHandler, TdsParserStateObject stateObj)
at System.Data.SqlClient.SqlDataReader.HasMoreRows()
at System.Data.SqlClient.SqlDataReader.ReadInternal(B oolean setTimeout)
at System.Data.SqlClient.SqlDataReader.Read()
at System.Data.Common.DataAdapter.FillLoadDataRow(Sch emaMapping mapping)
at System.Data.Common.DataAdapter.FillFromReader(Data Set dataset,
DataTable datatable, String srcTable, DataReaderContainer dataReader,
Int32 startRecord, Int32 maxRecords, DataColumn parentChapterColumn,
Object parentChapterValue)
at System.Data.Common.DataAdapter.Fill(DataSet dataSet, String srcTable,
IDataReader dataReader, Int32 startRecord, Int32 maxRecords)
at System.Data.Common.DbDataAdapter.FillInternal(Data Set 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 Utils.dbFunc.LoadData(Form frm, SqlConnection cn, SqlDataAdapter ad,
DataSet ds, String msg)

Sep 22 '06 #2

John J. Hughes II

Thanks for the response... Unlikely the SQL statement, its a stored
procedure on a live system that has been running form months now. I might
suspect the stored procedure got modified in someway but it's my
understanding it happens infrequently. I am guessing a timeout issue but
normally a timeout would show a timeout which is why I am confused. It
almost looks like a buffer overrun in the adaptor but that is a wild guess.

Regards,
John

"Daniel" <Da*****@vestryonline.comwrote in message
news:OE**************@TK2MSFTNGP06.phx.gbl...

looks like your sql statement has a problem in it. Debug and stop when the
sql is about to execute. Take the sql statement and put it in Query
Analyser and run it direct, see if it works. If it does you can scrub the
sql statement as a possible issue, but i think you'll find your sql
statement throws an error ;)

"John J. Hughes II" <no@invalid.comwrote in message
news:OO*************@TK2MSFTNGP06.phx.gbl...

>>I have a SqlDataAdapter.Fill filling a standard dataset and my code is
returning the below error. The "Error Loading data" is just a message my
code displays. "Error:" is the Exception.Message message and then below
that is the stack trace. The strange part is the "Error:" data is data
from the SQL database and obviously not an error so I don't see how or why
it is there. Any clues for determining why the code is throwing an
expection from this would be helpful.

Note being a little short sighted I don't trap the SqlException just the
Exception but normally that is more meaningful then this.

Error Loading data
Error:
71:
RP:09603ppppppppX!8op%&6#3' ppppppppX+pppppppp$)!ppp p%&<])pppppppp\pppp
Stack:
at System.Data.SqlClient.SqlConnection.OnError(SqlExc eption exception,
Boolean breakConnection)
at System.Data.SqlClient.SqlInternalConnection.OnErro r(SqlException
exception, Boolean breakConnection)
at
System.Data.SqlClient.TdsParser.ThrowExceptionAnd Warning(TdsParserStateObject
stateObj)
at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior,
SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet
bulkCopyHandler, TdsParserStateObject stateObj)
at System.Data.SqlClient.SqlDataReader.HasMoreRows()
at System.Data.SqlClient.SqlDataReader.ReadInternal(B oolean setTimeout)
at System.Data.SqlClient.SqlDataReader.Read()
at System.Data.Common.DataAdapter.FillLoadDataRow(Sch emaMapping
mapping)
at System.Data.Common.DataAdapter.FillFromReader(Data Set dataset,
DataTable datatable, String srcTable, DataReaderContainer dataReader,
Int32 startRecord, Int32 maxRecords, DataColumn parentChapterColumn,
Object parentChapterValue)
at System.Data.Common.DataAdapter.Fill(DataSet dataSet, String
srcTable, IDataReader dataReader, Int32 startRecord, Int32 maxRecords)
at System.Data.Common.DbDataAdapter.FillInternal(Data Set 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 Utils.dbFunc.LoadData(Form frm, SqlConnection cn, SqlDataAdapter ad,
DataSet ds, String msg)

Sep 22 '06 #3

Daniel

It would take you second to check the stored procedure. At least check it so
you can get it off your list of things it could be. The procedure might have
never changed, doesnt mean (assuming it takes parameters) the values of the
parameters arent causing this.
"John J. Hughes II" <no@invalid.comwrote in message
news:%2****************@TK2MSFTNGP03.phx.gbl...

Thanks for the response... Unlikely the SQL statement, its a stored
procedure on a live system that has been running form months now. I
might suspect the stored procedure got modified in someway but it's my
understanding it happens infrequently. I am guessing a timeout issue but
normally a timeout would show a timeout which is why I am confused. It
almost looks like a buffer overrun in the adaptor but that is a wild
guess.

Regards,
John

"Daniel" <Da*****@vestryonline.comwrote in message
news:OE**************@TK2MSFTNGP06.phx.gbl...

>looks like your sql statement has a problem in it. Debug and stop when
the sql is about to execute. Take the sql statement and put it in Query
Analyser and run it direct, see if it works. If it does you can scrub the
sql statement as a possible issue, but i think you'll find your sql
statement throws an error ;)

"John J. Hughes II" <no@invalid.comwrote in message
news:OO*************@TK2MSFTNGP06.phx.gbl...

>>>I have a SqlDataAdapter.Fill filling a standard dataset and my code is
returning the below error. The "Error Loading data" is just a message
my code displays. "Error:" is the Exception.Message message and then
below that is the stack trace. The strange part is the "Error:" data is
data from the SQL database and obviously not an error so I don't see how
or why it is there. Any clues for determining why the code is throwing
an expection from this would be helpful.

Note being a little short sighted I don't trap the SqlException just the
Exception but normally that is more meaningful then this.

Error Loading data
Error:
71:
RP:09603ppppppppX!8op%&6#3' ppppppppX+pppppppp$)!ppp p%&<])pppppppp\pppp
Stack:
at System.Data.SqlClient.SqlConnection.OnError(SqlExc eption exception,
Boolean breakConnection)
at System.Data.SqlClient.SqlInternalConnection.OnErro r(SqlException
exception, Boolean breakConnection)
at
System.Data.SqlClient.TdsParser.ThrowExceptionAn dWarning(TdsParserStateObject
stateObj)
at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior,
SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet
bulkCopyHandler, TdsParserStateObject stateObj)
at System.Data.SqlClient.SqlDataReader.HasMoreRows()
at System.Data.SqlClient.SqlDataReader.ReadInternal(B oolean
setTimeout)
at System.Data.SqlClient.SqlDataReader.Read()
at System.Data.Common.DataAdapter.FillLoadDataRow(Sch emaMapping
mapping)
at System.Data.Common.DataAdapter.FillFromReader(Data Set dataset,
DataTable datatable, String srcTable, DataReaderContainer dataReader,
Int32 startRecord, Int32 maxRecords, DataColumn parentChapterColumn,
Object parentChapterValue)
at System.Data.Common.DataAdapter.Fill(DataSet dataSet, String
srcTable, IDataReader dataReader, Int32 startRecord, Int32 maxRecords)
at System.Data.Common.DbDataAdapter.FillInternal(Data Set 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 Utils.dbFunc.LoadData(Form frm, SqlConnection cn, SqlDataAdapter
ad, DataSet ds, String msg)

Sep 22 '06 #4