with our reporting tool newreleic we can find an error in every portal. It looks like that this SQL exception is coming from umbraco. It says: Error with converting a nvarchar into a datetime.
Stack trace: System.Data.SqlClient.SqlException: Bei der Konvertierung eines nvarchar-Datentyps in einen datetime-Datentyp liegt der Wert außerhalb des gültigen Bereichs. Die Anweisung wurde beendet. Stack trace bei System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean\ breakConnection, Action`1 wrapCloseInAction) bei System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject\ stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) bei System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand\ cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler,\ TdsParserStateObject stateObj, Boolean& dataReady) bei System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds,\ RunBehavior runBehavior, String resetOptionsString) bei System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior,\ RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task&\ task, Boolean asyncWrite) bei System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior,\ RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1\ completion, Int32 timeout, Task& task, Boolean asyncWrite) bei System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1\ completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean asyncWrite) bei System.Data.SqlClient.SqlCommand.ExecuteNonQuery() bei Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteNonQuery(SqlConnection\ connection, CommandType commandType, String commandText, SqlParameter[] commandParameters)\ in D:\PaySmard\PaySmardCoreRepo\P_Germany\FamilaPortal\app\Microsoft.ApplicationBlocks.Data\Microsoft.ApplicationBlocks.Data\SQLHelper.cs:Zeile 335. bei Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteNonQuery(String connectionString,\ CommandType commandType, String commandText, SqlParameter[] commandParameters)\ in D:\PaySmard\PaySmardCoreRepo\P_Germany\FamilaPortal\app\Microsoft.ApplicationBlocks.Data\Microsoft.ApplicationBlocks.Data\SQLHelper.cs:Zeile 252. bei umbraco.DataLayer.SqlHelper`1.ExecuteNonQuery(String commandText, IParameter[]\ parameters)
I'm a bit confused about the above - is it a question about why the error happens or is it a statement of fact?
If you need some help figuring this out then please provide some more information - Unfortunately I'm not that good at german and it would be nice to have some more context than just the stack trace above.
sql Error/ Umbraco
with our reporting tool newreleic we can find an error in every portal.
It looks like that this SQL exception is coming from umbraco.
It says: Error with converting a nvarchar into a datetime.
Stack trace:
System.Data.SqlClient.SqlException: Bei der Konvertierung eines nvarchar-Datentyps in einen datetime-Datentyp liegt der Wert außerhalb des gültigen Bereichs. Die Anweisung wurde beendet.
Stack trace
bei System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean\ breakConnection, Action`1 wrapCloseInAction)
bei System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject\ stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)
bei System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand\ cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler,\ TdsParserStateObject stateObj, Boolean& dataReady)
bei System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds,\ RunBehavior runBehavior, String resetOptionsString)
bei System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior,\ RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task&\ task, Boolean asyncWrite)
bei System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior,\ RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1\ completion, Int32 timeout, Task& task, Boolean asyncWrite)
bei System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1\ completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean asyncWrite)
bei System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
bei Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteNonQuery(SqlConnection\ connection, CommandType commandType, String commandText, SqlParameter[] commandParameters)\ in D:\PaySmard\PaySmardCoreRepo\P_Germany\FamilaPortal\app\Microsoft.ApplicationBlocks.Data\Microsoft.ApplicationBlocks.Data\SQLHelper.cs:Zeile 335.
bei Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteNonQuery(String connectionString,\ CommandType commandType, String commandText, SqlParameter[] commandParameters)\ in D:\PaySmard\PaySmardCoreRepo\P_Germany\FamilaPortal\app\Microsoft.ApplicationBlocks.Data\Microsoft.ApplicationBlocks.Data\SQLHelper.cs:Zeile 252.
bei umbraco.DataLayer.SqlHelper`1.ExecuteNonQuery(String commandText, IParameter[]\ parameters)
Hi Atul and welcome to our :)
I'm a bit confused about the above - is it a question about why the error happens or is it a statement of fact?
If you need some help figuring this out then please provide some more information - Unfortunately I'm not that good at german and it would be nice to have some more context than just the stack trace above.
Looking forward to receive more information.
Cheers,
Jan
Hi,
with the newrelic tool we find that this error is constant, and error generates when it is late night and perhaps none is surfing the website.
SELECT *
FROM [cmsDocument]
INNER JOIN [cmsContentVersion]
ON [cmsDocument].[versionId] = [cmsContentVersion].[VersionId]
INNER JOIN [cmsContent]
ON [cmsContentVersion].[ContentId] = [cmsContent].[nodeId]
INNER JOIN [umbracoNode]
ON [cmsContent].[nodeId] = [umbracoNode].[id]
WHERE ([umbracoNode].[nodeObjectType] = 'c66ba18e-eaf3-4cff-8a22-41b16d66a972')
AND ([cmsDocument].[published] = 'False' AND [cmsDocument].[releaseDate] <= '09/16/2013 12:56:03')
AND ([cmsDocument].[newest]=1)
ORDER BY [cmsContentVersion].[VersionDate] DESC
, [umbracoNode].[sortOrder]
i have to know that from where this query is send from umbraco.
is working on a reply...