Copied to clipboard

Flag this post as spam?

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


  • Claire Botman 48 posts 77 karma points
    Apr 26, 2010 @ 02:21
    Claire Botman
    0

    Something is breaking my concierge

    I'm having trouble with running concierge on an IIS7 site & getting a strange sql error (below) unless I disable courier by renaming the 2 courier .dlls to .dll.old, as a consequence I can't use concierge at all.  This site is a largish site with a lot of extra functionality, dlls & a custom datalayer, but the umbraco installation itself is untouched apart from some installed packages.  I don't have a lot of time at the moment to try & isolate the problem so I've disabled courier for now, but I'm posting the error message below in the hope that someone has seen it before & can help.  I see this message when trying to edit content nodes in the backend.  The front end seems fine.

    System.Data.SqlClient.SqlException: Incorrect syntax near '0x29ea'.
    Generated: Sun, 25 Apr 2010 17:24:32 GMT
    
    System.Web.HttpUnhandledException: Exception of type 'System.Web.HttpUnhandledException' was thrown. ---> umbraco.DataLayer.SqlHelperException: Umbraco Exception (DataLayer): SQL helper exception in ExecuteScalar ---> System.Data.SqlClient.SqlException: Incorrect syntax near '0x29ea'.
       at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
       at System.Data.SqlClient.SqlInternalConnection.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.ExecuteScalar()
       at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteScalar(SqlConnection connection, CommandType commandType, String commandText, SqlParameter[] commandParameters)
       at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteScalar(String connectionString, CommandType commandType, String commandText, SqlParameter[] commandParameters)
       at umbraco.DataLayer.SqlHelpers.SqlServer.SqlServerHelper.ExecuteScalar(String commandText, SqlParameter[] parameters)
       at umbraco.DataLayer.SqlHelper`1.ExecuteScalar[T](String commandText, IParameter[] parameters)
       --- End of inner exception stack trace ---
       at umbraco.DataLayer.SqlHelper`1.ExecuteScalar[T](String commandText, IParameter[] parameters)
       at Umbraco.Concierge.LockUnLock.BusinessLogic.Ticket.GetTicketFromNode(Int32 NodeID)
       at Umbraco.Concierge.LockUnLock.Events.ValidateLockUnLock.a(ContentControl b, ContentControlLoadEventArgs b)
       at umbraco.controls.ContentControl.FireBeforeContentControlLoad(ContentControlLoadEventArgs e)
       at umbraco.controls.ContentControl.OnInit(EventArgs e)
       at System.Web.UI.Control.InitRecursive(Control namingContainer)
       at System.Web.UI.Control.AddedControl(Control control, Int32 index)
       at System.Web.UI.ControlCollection.Add(Control child)
       at umbraco.cms.presentation.editContent.OnInit(EventArgs e)
       at System.Web.UI.Control.InitRecursive(Control namingContainer)
       at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)
       --- End of inner exception stack trace ---
       at System.Web.UI.Page.HandleError(Exception e)
       at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)
       at System.Web.UI.Page.ProcessRequest(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)
       at System.Web.UI.Page.ProcessRequest()
       at System.Web.UI.Page.ProcessRequestWithNoAssert(HttpContext context)
       at System.Web.UI.Page.ProcessRequest(HttpContext context)
       at ASP.umbraco_editcontent_aspx.ProcessRequest(HttpContext context)
       at System.Web.HttpApplication.CallHandlerExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute()
       at System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously)
    
  • Evan Jardine 108 posts 168 karma points
    Jun 17, 2010 @ 23:34
    Evan Jardine
    0

    Hi Claire

    I'm having a similar problem...and I'm not having much luck solving it either.

    For me whenever the worker process gets recycled it seems to trigger the error.  I am also getting an Execute Reader exception as shown in the below stack trace.

    This problem is happening on all instances of umbraco that I have running on this server so at the moment I think it may have been cased by some server updates that were done earlier in the week.

    Stack trace

    At /umbraco/dashboard.aspx?app=concierge (Referred by: http://www.mysite.com/umbraco/umbraco.aspx): umbraco.DataLayer.SqlHelperException: Umbraco Exception (DataLayer): SQL helper exception in ExecuteReader ---> System.Data.SqlClient.SqlException: Incorrect syntax near ''.
    at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
    at System.Data.SqlClient.SqlInternalConnection.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
    --- End of inner exception stack trace ---
    at umbraco.DataLayer.SqlHelper`1.ExecuteReader(String commandText, IParameter[] parameters) in d:\TeamCity\buildAgent\work\7380c184e9fcd3ea\umbraco\datalayer\SqlHelper.cs:line 244
    at Umbraco.Concierge.plugins.Concierge.dashboard.e()
    at Umbraco.Concierge.plugins.Concierge.dashboard.Page_Load(Object sender, EventArgs e)
    at System.Web.Util.CalliHelper.EventArgFunctionCaller(IntPtr fp, Object o, Object t, EventArgs e)
    at System.Web.Util.CalliEventHandlerDelegateProxy.Callback(Object sender, EventArgs e)
    at System.Web.UI.Control.OnLoad(EventArgs e)

     

    Cheers
    Evan

  • Evan Jardine 108 posts 168 karma points
    Jun 17, 2010 @ 23:52
    Evan Jardine
    0

    Disabling Concierge by renaming the two dlls,

    • Umbraco.Concierge.LockUnLock.dll
    • Umbraco.Concierge.dll

    has stoped the error.

    Site Details

    Umbraco 4.0.4.1

    Concierge 2.0

    Server2003 R2

    .NET 3.5

    Did you ever resolve your problem and have Concierge working?

    Cheers

    Evan

  • Evan Jardine 108 posts 168 karma points
    Jul 06, 2010 @ 00:52
    Evan Jardine
    0

    I still haven't found a solution to this one... Anyone else??

     

  • Per Ploug 865 posts 3491 karma points MVP admin
    Jul 12, 2010 @ 21:07
    Per Ploug
    0

    Hi Evan and Claire

    I'm looking into this right now to see what is causing this and to see if a hotfix is needed to resolve the issue, if it is, we will release it asap

    /per

  • Evan Jardine 108 posts 168 karma points
    Jul 13, 2010 @ 00:18
    Evan Jardine
    0

    Thanks Per

    As a temporary solution, removing  .NET 4 Framework completely from the server resolved the issue.  The site was running under 3.5 but for some reason it was the 4 Framework causing issues.

    Cheers
    Evan

  • Kevon K. Hayes 255 posts 280 karma points
    Jul 16, 2010 @ 22:15
    Kevon K. Hayes
    0

    Same issue here, I recently install .NET 4 for UMB v4.5 and I then reverted back to the 3.5 Install and now have this issue.  I'll be uninstalling .NET 4 as well.

  • Claire Botman 48 posts 77 karma points
    Jul 17, 2010 @ 02:26
    Claire Botman
    0

    Oh, well I was hoping to upgrade to .NET 4 soon!  Haven't looked in on this thread for a while but glad to hear Per's looking into it :-)

  • Angad Bhat 22 posts 42 karma points
    Jun 02, 2011 @ 11:28
    Angad Bhat
    0

    Did you solve this problem? I am having the same problem. One of my users uploaded an excel file and this error showed up. The error is on content, media and concierge nodes.

    The live site is working fine but staging site is giving this error. Both servers have got .NET framework 4 installed.

  • Claire Botman 48 posts 77 karma points
    Jun 02, 2011 @ 23:59
    Claire Botman
    0

    No, that site's still on 3.5 but if both your servers have 4 installed then maybe it's a different prob?  I would have hoped the new version of concierge wouldn't have this problem.

  • Evan Jardine 108 posts 168 karma points
    Jun 03, 2011 @ 01:29
    Evan Jardine
    0

    I'm running the latest nightly build of Concierge 2.0.2 with umbraco 4.7 and running .NET 4 on both our staging and live servers.

    http://nightly.umbraco.org/UmbracoConcierge/2.0.2/

    I can't remeber if it was the update to Concierge that fixed the problem...

    Regards

    Evan

     

Please Sign in or register to post replies

Write your reply to:

Draft