random sqlhelperexception errors

Press Ctrl / CMD + C to copy this to your clipboard.

Copied to clipboard

Flag this post as spam?

This post will be reported to the moderators as potential spam to be looked at

dillorscroft 198 posts 192 karma points

Apr 21, 2010 @ 22:27

0

Random SQLHelperException Errors

I've been doing quite a lot of API based work recently and stepping through the code when deleting or publishing nodes via Visual Studio.

Periodically I'm getting errors bubbling up from the SQLHelper object that I have traced back to SQL calls that will always fail e.g. ;

Select [value] from cmsDataTypeprevalues where id in ()

Have I corrupted the database somehow or is this a bug in v4.0.3?

The site actually work fine if I'm not debugging it i.e. attaching to the w3p.exe process as soon as I step through I see the errors.

Any thoughts?

DC

Copy Link
dillorscroft 198 posts 192 karma points

Apr 28, 2010 @ 10:17

0

Anyone? I thought it could be an event handler erroring but I cant see anything that would cause a problem.

Bit of a worry this one....

DC

Copy Link
dillorscroft 198 posts 192 karma points

Apr 28, 2010 @ 10:29

0

I'm getting this in the stack trace

umbraco.DataLayer.SqlHelperException was unhandled by user code

  Message=Umbraco Exception (DataLayer): SQL helper exception in ExecuteReader

  Source=umbraco.DataLayer

  StackTrace:

   at umbraco.DataLayer.SqlHelper`1.ExecuteReader(String commandText, IParameter[] parameters) in d:\TeamCity\buildAgent\work\7380c184e9fcd3ea\umbraco\datalayer\SqlHelper.cs:line 246

   at umbraco.editorControls.DefaultDataKeyValue.ToXMl(XmlDocument d)

  InnerException: System.Data.SqlClient.SqlException

   Message=Incorrect syntax near ')'.

   Source=.Net SqlClient Data Provider

   ErrorCode=-2146232060

   Class=15

   LineNumber=1

   Number=102

   Procedure=""

   Server=Texas

   State=1

   StackTrace:

   at System.Data.SqlClient.SqlConnection.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.ConsumeMetaData()

   at System.Data.SqlClient.SqlDataReader.get_MetaData()

   at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString)

   at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async)

   at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result)

   at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method)

   at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method)

   at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior)

   at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteReader(SqlConnection connection, SqlTransaction transaction, CommandType commandType, String commandText, SqlParameter[] commandParameters, SqlConnectionOwnership connectionOwnership)

   at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteReader(String connectionString, CommandType commandType, String commandText, SqlParameter[] commandParameters)

   at umbraco.DataLayer.SqlHelpers.SqlServer.SqlServerHelper.ExecuteReader(String commandText, SqlParameter[] parameters) in d:\TeamCity\buildAgent\work\7380c184e9fcd3ea\umbraco\datalayer\SqlHelpers\SqlServer\SqlServerHelper.cs:line 77

   at umbraco.DataLayer.SqlHelper`1.ExecuteReader(String commandText, IParameter[] parameters) in d:\TeamCity\buildAgent\work\7380c184e9fcd3ea\umbraco\datalayer\SqlHelper.cs:line 240

   InnerException:

Copy Link
is working on a reply...

Please Sign in or register to post replies

Flag this post as spam?