Virtual Happy Hour is canceled this month (March) due to Good Friday.
Virtual Happy Hour is canceled this month (March) due to Good Friday.
EPiServer.CMS.Core 7.0.586.0
EPiServer.CMS.Core 10.1.0
Aug 12, 2016
Jun 27, 2018
CMS Core
Closed, Fixed and tested
Steps to reproduce
*Workaround: * Assign NextExecution, then reload from database before executing to make sure NextExecutionUTC is assigned.
Exception:
"SqlDateTime overflow. Must be between 1/1/1753 12:00:00 AM and 12/31/9999 11:59:59 PM"
System.Data.SqlClient.TdsParser.TdsExecuteRPC(SqlCommand cmd, _SqlRPC[] rpcArray, Int32 timeout, Boolean inSchema, SqlNotificationRequest notificationRequest, TdsParserStateObject stateObj, Boolean isCommandProc, Boolean sync, TaskCompletionSource`1 completion, Int32 startRpc, Int32 startParam) +9211
System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, SqlDataReader ds, Boolean describeParameterEncryptionRequest) +3114
System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean asyncWrite) +554
System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method) +98
System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method) +202
System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) +206
System.Data.Common.DbDataAdapter.Fill(DataTable[] dataTables, Int32 startRecord, Int32 maxRecords, IDbCommand command, CommandBehavior behavior) +475
System.Data.Common.DbDataAdapter.Fill(DataTable dataTable) +145
EPiServer.DataAccess.<>c_DisplayClass8_0.<MarkEIForExecution>b_0() in C:\xxxxx\AppData\Local\JetBrains\Shared\v04\DecompilerCache\decompiler\41A44A69-D053-44F0-BFA6-E1E6C0445FD0\19\3d765dff\SchedulerDB.cs:196
EPiServer.Data.Providers.<>c_DisplayClass30_0`1.<ExecuteTransaction>b_0() +196
EPiServer.Data.Providers.SqlTransientErrorsRetryPolicy.Execute(Func`1 method) +66
EPiServer.DataAccess.SchedulerDB.MarkEIForExecution(Guid id, DateTime nextExec, TimeSpan pingTime) in C:\xxxxx\AppData\Local\JetBrains\Shared\v04\DecompilerCache\decompiler\41A44A69-D053-44F0-BFA6-E1E6C0445FD0\19\3d765dff\SchedulerDB.cs:188
EPiServer.DataAbstraction.ScheduledJobRepository.TryMarkForExecution(Guid id, DateTime validateUtcDate, TimeSpan pingTime) in C:\xxxxx\AppData\Local\JetBrains\Shared\v04\DecompilerCache\decompiler\41A44A69-D053-44F0-BFA6-E1E6C0445FD0\4c\b3af7661\ScheduledJobRepository.cs:259
EPiServer.DataAbstraction.ScheduledJob.Execute(Boolean startThread, DateTime validateUtcDate) in C:\xxxxx\AppData\Local\JetBrains\Shared\v04\DecompilerCache\decompiler\41A44A69-D053-44F0-BFA6-E1E6C0445FD0\7e\d84a090b\ScheduledJob.cs:733