|
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) | |
Share:
|
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) | | |
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) | | |
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) | | This discussion thread is closed Replies have been disabled for this discussion. Similar topics
2 posts
views
Thread by David MacQuigg |
last post: by
|
65 posts
views
Thread by Pmb |
last post: by
|
16 posts
views
Thread by Shelly |
last post: by
|
4 posts
views
Thread by Bazza Formez |
last post: by
| |
12 posts
views
Thread by Wilson |
last post: by
| |
7 posts
views
Thread by Andy B |
last post: by
|
7 posts
views
Thread by Luna Moon |
last post: by
|
reply
views
Thread by Lloyd Sheen |
last post: by
| | | | | | | | | | |