SqlException i don't know what to do with

[Dan Holmes]

I don't know how to troubleshoot this one. src is after the error.

"System.Data.SqlClient.SqlException: XML parsing: line 1, character 698,
illegal qualified name character\r\n at
System.Data.SqlClient.SqlConnection.OnError(SqlExc eption exception,
Boolean breakConnection)\r\n at
System.Data.SqlClient.SqlInternalConnection.OnErro r(SqlException
exception, Boolean breakConnection)\r\n at
System.Data.SqlClient.TdsParser.ThrowExceptionAndW arning(TdsParserStateObject
stateObj)\r\n at System.Data.SqlClient.TdsParser.Run(RunBehavior
runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream,
BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject
stateObj)\r\n at
System.Data.SqlClient.SqlCommand.FinishExecuteRead er(SqlDataReader ds,
RunBehavior runBehavior, String resetOptionsString)\r\n at
System.Data.SqlClient.SqlCommand.RunExecuteReaderT ds(CommandBehavior
cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean
async)\r\n at
System.Data.SqlClient.SqlCommand.RunExecuteReader( CommandBehavior
cmdBehavior, RunBehavior runBehavior, Boolean returnStream,
String method, DbAsyncResult result)\r\n at
System.Data.SqlClient.SqlCommand.InternalExecuteNo nQuery(DbAsyncResult
result, String methodName, Boolean sendToPipe)\r\n at
System.Data.SqlClient.SqlCommand.ExecuteNonQuery() \r\n at
Microsoft.Practices.EnterpriseLibrary.Data.Databas e.DoExecuteNonQuery(DbCommand
command)\r\n at
Microsoft.Practices.EnterpriseLibrary.Data.Databas e.ExecuteNonQuery(DbCommand
command)\r\n at
IVS.Framework.Logging.ErrorService.InsertError(Ide ntity id, ErrorInfo
ed) in
C:\\SandBox\\IAF.NET\\IAF\\trunk\\src\\BOs\\Error\ \Server\\ServerError.cs:line
256"

cmd = db.GetStoredProcCommand("InsertError");
db.AddInParameter(cmd, "userid", System.Data.DbType.String, ed.UserID);
db.AddInParameter(cmd, "CurrentDate", System.Data.DbType.DateTime,
ed.CreateDate);
db.AddInParameter(cmd, "IVSError", System.Data.DbType.String,
ed.IAFError ? "Y" : "N");
db.AddInParameter(cmd, "PrimaryComponentID", System.Data.DbType.String,
ed.PrimaryComponentID);
db.AddInParameter(cmd, "PrimaryFunctionID", System.Data.DbType.String,
ed.PrimaryMethodName);
db.AddInParameter(cmd, "PrimaryAssemblyName", System.Data.DbType.String,
ed.PrimaryAssemblyName);
db.AddInParameter(cmd, "PCID", System.Data.DbType.String, ed.PCID);
db.AddInParameter(cmd, "DeviceID", System.Data.DbType.String, ed.DeviceID);
db.AddInParameter(cmd, "ExceptionType", System.Data.DbType.String,
ed.ExceptionType);
db.AddInParameter(cmd, "StackTrace", System.Data.DbType.String,
ed.StackTrace);
db.AddInParameter(cmd, "Message", System.Data.DbType.String, ed.Message);
db.AddInParameter(cmd, "Data", System.Data.DbType.Xml, ed.Data);
db.AddParameter(cmd, "RetVal", System.Data.DbType.Int32,
System.Data.ParameterDirection.ReturnValue, "",
System.Data.DataRowVersion.Current, null);
if ((int)db.ExecuteNonQuery(cmd) 0)
i = (int)db.GetParameterValue(cmd, "RetVal");

[=?Utf-8?B?UGV0ZXIgQnJvbWJlcmcgW0MjIE1WUF0=?=]

Looks like your "Data" parameter of type XML is not well-formed or legal XML.
Peter

--
Site: http://www.eggheadcafe.com
UnBlog: http://petesbloggerama.blogspot.com
Short urls & more: http://ittyurl.net


"Dan Holmes" wrote:

I don't know how to troubleshoot this one. src is after the error.

"System.Data.SqlClient.SqlException: XML parsing: line 1, character 698,
illegal qualified name character\r\n at
System.Data.SqlClient.SqlConnection.OnError(SqlExc eption exception,
Boolean breakConnection)\r\n at
System.Data.SqlClient.SqlInternalConnection.OnErro r(SqlException
exception, Boolean breakConnection)\r\n at
System.Data.SqlClient.TdsParser.ThrowExceptionAndW arning(TdsParserStateObject
stateObj)\r\n at System.Data.SqlClient.TdsParser.Run(RunBehavior
runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream,
BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject
stateObj)\r\n at
System.Data.SqlClient.SqlCommand.FinishExecuteRead er(SqlDataReader ds,
RunBehavior runBehavior, String resetOptionsString)\r\n at
System.Data.SqlClient.SqlCommand.RunExecuteReaderT ds(CommandBehavior
cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean
async)\r\n at
System.Data.SqlClient.SqlCommand.RunExecuteReader( CommandBehavior
cmdBehavior, RunBehavior runBehavior, Boolean returnStream,
String method, DbAsyncResult result)\r\n at
System.Data.SqlClient.SqlCommand.InternalExecuteNo nQuery(DbAsyncResult
result, String methodName, Boolean sendToPipe)\r\n at
System.Data.SqlClient.SqlCommand.ExecuteNonQuery() \r\n at
Microsoft.Practices.EnterpriseLibrary.Data.Databas e.DoExecuteNonQuery(DbCommand
command)\r\n at
Microsoft.Practices.EnterpriseLibrary.Data.Databas e.ExecuteNonQuery(DbCommand
command)\r\n at
IVS.Framework.Logging.ErrorService.InsertError(Ide ntity id, ErrorInfo
ed) in
C:\\SandBox\\IAF.NET\\IAF\\trunk\\src\\BOs\\Error\ \Server\\ServerError.cs:line
256"

cmd = db.GetStoredProcCommand("InsertError");
db.AddInParameter(cmd, "userid", System.Data.DbType.String, ed.UserID);
db.AddInParameter(cmd, "CurrentDate", System.Data.DbType.DateTime,
ed.CreateDate);
db.AddInParameter(cmd, "IVSError", System.Data.DbType.String,
ed.IAFError ? "Y" : "N");
db.AddInParameter(cmd, "PrimaryComponentID", System.Data.DbType.String,
ed.PrimaryComponentID);
db.AddInParameter(cmd, "PrimaryFunctionID", System.Data.DbType.String,
ed.PrimaryMethodName);
db.AddInParameter(cmd, "PrimaryAssemblyName", System.Data.DbType.String,
ed.PrimaryAssemblyName);
db.AddInParameter(cmd, "PCID", System.Data.DbType.String, ed.PCID);
db.AddInParameter(cmd, "DeviceID", System.Data.DbType.String, ed.DeviceID);
db.AddInParameter(cmd, "ExceptionType", System.Data.DbType.String,
ed.ExceptionType);
db.AddInParameter(cmd, "StackTrace", System.Data.DbType.String,
ed.StackTrace);
db.AddInParameter(cmd, "Message", System.Data.DbType.String, ed.Message);
db.AddInParameter(cmd, "Data", System.Data.DbType.Xml, ed.Data);
db.AddParameter(cmd, "RetVal", System.Data.DbType.Int32,
System.Data.ParameterDirection.ReturnValue, "",
System.Data.DataRowVersion.Current, null);
if ((int)db.ExecuteNonQuery(cmd) 0)
i = (int)db.GetParameterValue(cmd, "RetVal");

[Ignacio Machin \( .NET/ C# MVP \)]

Hi,

IT seems that the XML file is not well formed, apparentely there is a \r\n
sequence somewhere where is not valid

"Dan Holmes" <da*******@bigfoot.comwrote in message
news:em**************@TK2MSFTNGP02.phx.gbl...

>I don't know how to troubleshoot this one. src is after the error.

"System.Data.SqlClient.SqlException: XML parsing: line 1, character 698,
illegal qualified name character\r\n at
System.Data.SqlClient.SqlConnection.OnError(SqlExc eption exception,
Boolean breakConnection)\r\n at
System.Data.SqlClient.SqlInternalConnection.OnErro r(SqlException
exception, Boolean breakConnection)\r\n at
System.Data.SqlClient.TdsParser.ThrowExceptionAndW arning(TdsParserStateObject
stateObj)\r\n at System.Data.SqlClient.TdsParser.Run(RunBehavior
runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream,
BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject
stateObj)\r\n at
System.Data.SqlClient.SqlCommand.FinishExecuteRead er(SqlDataReader ds,
RunBehavior runBehavior, String resetOptionsString)\r\n at
System.Data.SqlClient.SqlCommand.RunExecuteReaderT ds(CommandBehavior
cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean
async)\r\n at
System.Data.SqlClient.SqlCommand.RunExecuteReader( CommandBehavior
cmdBehavior, RunBehavior runBehavior, Boolean returnStream,
String method, DbAsyncResult result)\r\n at
System.Data.SqlClient.SqlCommand.InternalExecuteNo nQuery(DbAsyncResult
result, String methodName, Boolean sendToPipe)\r\n at
System.Data.SqlClient.SqlCommand.ExecuteNonQuery() \r\n at
Microsoft.Practices.EnterpriseLibrary.Data.Databas e.DoExecuteNonQuery(DbCommand
command)\r\n at
Microsoft.Practices.EnterpriseLibrary.Data.Databas e.ExecuteNonQuery(DbCommand
command)\r\n at IVS.Framework.Logging.ErrorService.InsertError(Ide ntity
id, ErrorInfo ed) in
C:\\SandBox\\IAF.NET\\IAF\\trunk\\src\\BOs\\Error\ \Server\\ServerError.cs:line
256"

cmd = db.GetStoredProcCommand("InsertError");
db.AddInParameter(cmd, "userid", System.Data.DbType.String, ed.UserID);
db.AddInParameter(cmd, "CurrentDate", System.Data.DbType.DateTime,
ed.CreateDate);
db.AddInParameter(cmd, "IVSError", System.Data.DbType.String, ed.IAFError
? "Y" : "N");
db.AddInParameter(cmd, "PrimaryComponentID", System.Data.DbType.String,
ed.PrimaryComponentID);
db.AddInParameter(cmd, "PrimaryFunctionID", System.Data.DbType.String,
ed.PrimaryMethodName);
db.AddInParameter(cmd, "PrimaryAssemblyName", System.Data.DbType.String,
ed.PrimaryAssemblyName);
db.AddInParameter(cmd, "PCID", System.Data.DbType.String, ed.PCID);
db.AddInParameter(cmd, "DeviceID", System.Data.DbType.String,
ed.DeviceID);
db.AddInParameter(cmd, "ExceptionType", System.Data.DbType.String,
ed.ExceptionType);
db.AddInParameter(cmd, "StackTrace", System.Data.DbType.String,
ed.StackTrace);
db.AddInParameter(cmd, "Message", System.Data.DbType.String, ed.Message);
db.AddInParameter(cmd, "Data", System.Data.DbType.Xml, ed.Data);
db.AddParameter(cmd, "RetVal", System.Data.DbType.Int32,
System.Data.ParameterDirection.ReturnValue, "",
System.Data.DataRowVersion.Current, null);
if ((int)db.ExecuteNonQuery(cmd) 0)
i = (int)db.GetParameterValue(cmd, "RetVal");