I am getting this error since upgrading to Umbraco 6. It is filling up UmbracoTrace file even though trace is switched off and I have no idea what is causing. It's being added to almost every second. Any ideas anyone please?
2013-02-18 14:44:55,395 [5] INFO Umbraco.Core.Publishing.PublishingStrategy - [Thread 13] Content 'Test' with Id '11525' has been published.
2013-02-18 14:44:55,848 [5] ERROR umbraco.DataLayer.SqlHelper`1[[System.Data.SqlClient.SqlParameter, System.Data, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089]] - [Thread 13] Error executing query Select [value] from cmsDataTypeprevalues where id in ()
System.Data.SqlClient.SqlException (0x80131904): 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()
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(String connectionString, CommandType commandType, String commandText, SqlParameter[] commandParameters)
at umbraco.DataLayer.SqlHelpers.SqlServer.SqlServerHelper.ExecuteReader(String commandText, SqlParameter[] parameters) in c:\Program Files (x86)\teamcity\buildAgent\work\e145e9ed82478b40\src\umbraco.datalayer\SqlHelpers\SqlServer\SqlServerHelper.cs:line 93
at umbraco.DataLayer.SqlHelper`1.ExecuteReader(String commandText, IParameter[] parameters) in c:\Program Files (x86)\teamcity\buildAgent\work\e145e9ed82478b40\src\umbraco.datalayer\SqlHelper.cs:line 250
2013-02-18 14:44:55,910 [5] ERROR umbraco.DataLayer.SqlHelper`1[[System.Data.SqlClient.SqlParameter, System.Data, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089]] - [Thread 13] Error executing query Select [value] from cmsDataTypeprevalues where id in ()
System.Data.SqlClient.SqlException (0x80131904): 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()
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(String connectionString, CommandType commandType, String commandText, SqlParameter[] commandParameters)
at umbraco.DataLayer.SqlHelpers.SqlServer.SqlServerHelper.ExecuteReader(String commandText, SqlParameter[] parameters) in c:\Program Files (x86)\teamcity\buildAgent\work\e145e9ed82478b40\src\umbraco.datalayer\SqlHelpers\SqlServer\SqlServerHelper.cs:line 93
at umbraco.DataLayer.SqlHelper`1.ExecuteReader(String commandText, IParameter[] parameters) in c:\Program Files (x86)\teamcity\buildAgent\work\e145e9ed82478b40\src\umbraco.datalayer\SqlHelper.cs:line 250
2013-02-18 14:44:56,253 [5] ERROR umbraco.DataLayer.SqlHelper`1[[System.Data.SqlClient.SqlParameter, System.Data, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089]] - [Thread 13] Error executing query Select [value] from cmsDataTypeprevalues where id in ()
System.Data.SqlClient.SqlException (0x80131904): 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()
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(String connectionString, CommandType commandType, String commandText, SqlParameter[] commandParameters)
at umbraco.DataLayer.SqlHelpers.SqlServer.SqlServerHelper.ExecuteReader(String commandText, SqlParameter[] parameters) in c:\Program Files (x86)\teamcity\buildAgent\work\e145e9ed82478b40\src\umbraco.datalayer\SqlHelpers\SqlServer\SqlServerHelper.cs:line 93
at umbraco.DataLayer.SqlHelper`1.ExecuteReader(String commandText, IParameter[] parameters) in c:\Program Files (x86)\teamcity\buildAgent\work\e145e9ed82478b40\src\umbraco.datalayer\SqlHelper.cs:line 250
I followed the full upgrade path through every release. Not sure what's going on but it's killing my server because it's constantly logging exceptions with every page visit.
Hi, I had this error in v4.11.4 when a page was published and I'm pretty sure it was related to not having Courier installed correctly. Did you have Courier installed before upgrade?
I've got this issue as well, it appears to be only happening on a single node for me (although other nodes of the same type are working fine). I'm running 6.0.0.
Does anyone have uBlogsy installed? I've just discovered that for the uBlogsyPost data type/template the cmsDocument table has thousands of rows for each node of that type. I can't look at audit history in the UI as I get a timeout. I guess because of the number of entries. It doesn't seem to be republishing but something must be getting updated somehow.
Umbraco 6 upgrade - UmbracoTrace constant error
Hi Michael
What version of Umbraco did you upgrade from? And how did you do the upgrade?
/Jan
I'm having the same problem. Log files are filling up (~300MB a day) even if I specified FATAL in log4net config.
I've upgraded from 4.7 and every release up to 6.0.0 (included 6.0.0 RC).
2013-02-19 12:03:32,935 [52] ERROR umbraco.DataLayer.SqlHelper`1[[System.Data.SqlClient.SqlParameter, System.Data, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089]] - [Thread 66] Error executing query Select [value] from cmsDataTypeprevalues where id in ()
System.Data.SqlClient.SqlException (0x80131904): Incorrect syntax near ')'.
at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)
at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)
at System.Data.SqlClient.SqlDataReader.TryConsumeMetaData()
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, Int32 timeout, Task& task, Boolean asyncWrite)
at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean asyncWrite)
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(String connectionString, CommandType commandType, String commandText, SqlParameter[] commandParameters)
at umbraco.DataLayer.SqlHelpers.SqlServer.SqlServerHelper.ExecuteReader(String commandText, SqlParameter[] parameters)
at umbraco.DataLayer.SqlHelper`1.ExecuteReader(String commandText, IParameter[] parameters)
ClientConnectionId:b8720394-08db-4d1c-b5cc-8f6d3f84fbbd
2013-02-19 12:03:32,999 [52] ERROR umbraco.content - [Thread 66] Error adding node to Sitemap Provider in PublishNodeDo(): 1237
System.ArgumentNullException: Value cannot be null.
Parameter name: umbracoContext
at Umbraco.Web.UmbracoHelper..ctor(UmbracoContext umbracoContext)
at umbraco.content.PublishNodeDo(Document d, XmlDocument xmlContentCopy, Boolean updateSitemapProvider)
I followed the full upgrade path through every release. Not sure what's going on but it's killing my server because it's constantly logging exceptions with every page visit.
Using umbDebugShowTrace reveals no errors either.
Hi, I had this error in v4.11.4 when a page was published and I'm pretty sure it was related to not having Courier installed correctly. Did you have Courier installed before upgrade?
No, I've never had Courier installed.
I've got this issue as well, it appears to be only happening on a single node for me (although other nodes of the same type are working fine). I'm running 6.0.0.
Hey,
Does anyone have uBlogsy installed? I've just discovered that for the uBlogsyPost data type/template the cmsDocument table has thousands of rows for each node of that type. I can't look at audit history in the UI as I get a timeout. I guess because of the number of entries. It doesn't seem to be republishing but something must be getting updated somehow.
Anybody got any ideas what might be going on?
Thanks
Mike
is working on a reply...