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) 3 1569
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 thread has been closed and replies have been disabled. Please start a new discussion. Similar topics
by: David MacQuigg |
last post by:
I'm setting up a large hierarchy of module packages and using a
variable to select which of many alternative packages to import. For
example, the variable 'config.modsel' points to a particular...
|
by: Pmb |
last post by:
I'm confused as to what the compiler error message I'm getting is refering
to. Can someone take a gander and let me know what I did wrong? The program
is below. When I compile it I get the...
|
by: Shelly |
last post by:
(posted previously on comp.lang.php but no response received. Cross-posted
in the dreamweaver forum)
I am confused about what goes on with method POST. Here is an overview of a
my code,...
|
by: Bazza Formez |
last post by:
Hi,
Unlike some people I have read about in this news group, I am having trouble
turning off debug.... but the error message seems to indicate the opposite.
When I set debug="false" in...
|
by: d3vkit |
last post by:
Okay so I can NOT get my while loop to work. It's the most confusing thing I've ever come across. It was working fine and then suddenly, nothing. No error. The page just dies.
I am using PHP5 with...
|
by: Wilson |
last post by:
Hi, while writing a simplified version of a program i created the
following class, however when i went to compile and run the program
there was an error saying
"multiple types in one...
|
by: Nyx18 |
last post by:
ok so i got my class to work now im having confusing errors with this:
void sort(Student stu, int parameter, int count)
{
Student temp;
bool finished = false;
while (!finished)
...
|
by: Andy B |
last post by:
I saw this in the set accessor of a property:
Set(ByVal value As DataSet)
What exactly does the stuff in the () mean? VS complained about it not being
there when I took it out not knowing...
|
by: Luna Moon |
last post by:
Hi all,
I just couldn't get myself clear about the usage of "const" in front
of and/or behind variables, pointers, classes, objects and
functions...
It's too confusing... any good clear...
|
by: Lloyd Sheen |
last post by:
In design view of an aspx page I have an Ajax Toolkit
ToolkitScriptManager control. The markup for this is
<%@ Register Assembly="AjaxControlToolkit"
Namespace="AjaxControlToolkit"...
|
by: Charles Arthur |
last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
|
by: ryjfgjl |
last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
|
by: emmanuelkatto |
last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud.
Please let me know.
Thanks!
Emmanuel
|
by: BarryA |
last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
|
by: nemocccc |
last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
|
by: Sonnysonu |
last post by:
This is the data of csv file
1 2 3
1 2 3
1 2 3
1 2 3
2 3
2 3
3
the lengths should be different i have to store the data by column-wise with in the specific length.
suppose the i have to...
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
|
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
|
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers,...
| |