U4-3011 - Found the Error in Umbraco

Created by Bug Reporter 28 Aug 2013, 11:49:57 Updated by Shannon Deminick 21 Jun 2017, 07:58:15

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.

Find the stack trace and an screenshot attached: Thanks Martin 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, Action1 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, TaskCompletionSource1\ completion, Int32 timeout, Task& task, Boolean asyncWrite) bei System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource1\ 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.SqlHelper1.ExecuteNonQuery(String commandText, IParameter[]\ parameters)

Comments

Shannon Deminick 21 Jun 2017, 07:58:15

Closing issue due to inactivity - see blog post for details https://umbraco.com/blog/issue-tracker-cleanup/


Priority: Normal

Type: Bug

State: Closed

Assignee:

Difficulty:

Category:

Backwards Compatible: True

Fix Submitted:

Affected versions:

Due in version:

Sprint:

Story Points:

Cycle: