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)
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)
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.
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.
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.
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.
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.
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
Disabling Concierge by renaming the two dlls,
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
I still haven't found a solution to this one... Anyone else??
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
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
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.
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 :-)
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.
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.
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
is working on a reply...