Sign in Register
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
    dillorscroft
    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
    dillorscroft
    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
    dillorscroft
    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

  • This forum is in read-only mode while we transition to the new forum.

    You can continue this topic on the new forum by tapping the "Continue discussion" link below.

Please Sign in or register to post replies