Confusing error message

J

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(SqlException exception,
Boolean breakConnection)
at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException
exception, Boolean breakConnection)
at
System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(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(Boolean setTimeout)
at System.Data.SqlClient.SqlDataReader.Read()
at System.Data.Common.DataAdapter.FillLoadDataRow(SchemaMapping mapping)
at System.Data.Common.DataAdapter.FillFromReader(DataSet 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(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 Utils.dbFunc.LoadData(Form frm, SqlConnection cn, SqlDataAdapter ad,
DataSet ds, String msg)
 
D

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 ;)
 
J

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 said:
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 said:
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(SqlException exception,
Boolean breakConnection)
at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException
exception, Boolean breakConnection)
at
System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(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(Boolean setTimeout)
at System.Data.SqlClient.SqlDataReader.Read()
at System.Data.Common.DataAdapter.FillLoadDataRow(SchemaMapping
mapping)
at System.Data.Common.DataAdapter.FillFromReader(DataSet 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(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 Utils.dbFunc.LoadData(Form frm, SqlConnection cn, SqlDataAdapter ad,
DataSet ds, String msg)
Click to expand...
Click to expand...
 
D

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 said:
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 said:
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 said:
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(SqlException exception,
Boolean breakConnection)
at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException
exception, Boolean breakConnection)
at
System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(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(Boolean
setTimeout)
at System.Data.SqlClient.SqlDataReader.Read()
at System.Data.Common.DataAdapter.FillLoadDataRow(SchemaMapping
mapping)
at System.Data.Common.DataAdapter.FillFromReader(DataSet 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(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 Utils.dbFunc.LoadData(Form frm, SqlConnection cn, SqlDataAdapter
ad, DataSet ds, String msg)
Click to expand...
Click to expand...
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How do I best fix this error 4
Elusive randomly occuring exceptions 10
Trying to debug an exception 4
Transaction Error on None-Transaction Query 16
C# 2.0 + MS Access == Error 5
System.OutOfMemoryException in DataAdapter 4
SqlDataAdapter.Fill problems 0
View timed out every now and then 5

Top