Hello,
It appears that when trying to save a product list view in the backend DW10 UI, an error occurs as shown below. This has been consistently reproduced in two separate DW10 solutions. To reproduce:
- Navigate to the Products module
- Modify the list view by clicking Actions > Manage columns (e.g., add or remove a column and click 'Save')
- Save the list view by clicking Actions > Save view
- Enter a name for the view and click Save
- Note the error:
An unhandled error occurred: SqlDateTime overflow. Must be between 1/1/1753 12:00:00 AM and 12/31/9999 11:59:59 PM.
To see the details about the error, inspect the event log using the given Trace ID.
Trace ID: 00-eccc9093ab325a2c3170e1ff7fe9d7d9-bfa0b62a9df74854-00
2025-06-13 04:35:49.2153: Management API request failed. Trace ID: 00-eccc9093ab325a2c3170e1ff7fe9d7d9-bfa0b62a9df74854-00. System.Data.SqlTypes.SqlTypeException: SqlDateTime overflow. Must be between 1/1/1753 12:00:00 AM and 12/31/9999 11:59:59 PM.
at System.Data.SqlTypes.SqlDateTime.FromTimeSpan(TimeSpan value)
at System.Data.SqlTypes.SqlDateTime.FromDateTime(DateTime value)
at System.Data.SqlClient.MetaType.FromDateTime(DateTime dateTime, Byte cb)
at System.Data.SqlClient.TdsParser.WriteUnterminatedValue(Object value, MetaType type, Byte scale, Int32 actualLength, Int32 encodingByteSize, Int32 offset, TdsParserStateObject stateObj, Int32 paramSize, Boolean isDataFeed)
at System.Data.SqlClient.TdsParser.TDSExecuteRPCAddParameter(TdsParserStateObject stateObj, SqlParameter param, MetaType mt, Byte options)
at System.Data.SqlClient.TdsParser.TdsExecuteRPC(_SqlRPC[] rpcArray, Int32 timeout, Boolean inSchema, SqlNotificationRequest notificationRequest, TdsParserStateObject stateObj, Boolean isCommandProc, Boolean sync, TaskCompletionSource`1 completion, Int32 startRpc, Int32 startParam)
at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, SqlDataReader ds)
at System.Data.SqlClient.SqlCommand.ExecuteScalar()
at Dynamicweb.Data.Database.ExecuteScalar(IDbCommand command)
at Dynamicweb.Data.Database.ExecuteScalar(CommandBuilder commandBuilder, IDbConnection connection, IDbTransaction transaction)
at Dynamicweb.CoreUI.Data.ScreenConfiguration.ScreenPresetRepository.SaveScreenPreset(ScreenPreset preset, IDbConnection connection, IDbTransaction transaction)
at Dynamicweb.CoreUI.Data.ScreenConfiguration.ScreenPresetRepository.SaveScreenPreset(ScreenPreset preset, Nullable`1 type)
at Dynamicweb.CoreUI.Data.ScreenConfiguration.ScreenPresetService.SaveScreenPreset(ScreenPreset screenPreset, Nullable`1 type)
at Dynamicweb.CoreUI.Data.ScreenConfiguration.ScreenPresetRenameCommand.Handle()
at Dynamicweb.Management.Api.Controllers.Api.DataController.GetCommandResult(Type commandType, Type queryType, String body)
at Dynamicweb.Management.Api.Controllers.Api.DataController.Post(String command, Object body)
at lambda_method163(Closure, Object)
at Microsoft.AspNetCore.Mvc.Infrastructure.ActionMethodExecutor.AwaitableObjectResultExecutor.Execute(ActionContext actionContext, IActionResultTypeMapper mapper, ObjectMethodExecutor executor, Object controller, Object[] arguments)
at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.<InvokeActionMethodAsync>g__Awaited|12_0(ControllerActionInvoker invoker, ValueTask`1 actionResultValueTask)
at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.<InvokeNextActionFilterAsync>g__Awaited|10_0(ControllerActionInvoker invoker, Task lastTask, State next, Scope scope, Object state, Boolean isCompleted)
at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.Rethrow(ActionExecutedContextSealed context)
at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.Next(State& next, Scope& scope, Object& state, Boolean& isCompleted)
at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.InvokeInnerFilterAsync()
--- End of stack trace from previous location ---
at Microsoft.AspNetCore.Mvc.Infrastructure.ResourceInvoker.<InvokeNextResourceFilter>g__Awaited|25_0(ResourceInvoker invoker, Task lastTask, State next, Scope scope, Object state, Boolean isCompleted)
at Microsoft.AspNetCore.Mvc.Infrastructure.ResourceInvoker.Rethrow(ResourceExecutedContextSealed context)
at Microsoft.AspNetCore.Mvc.Infrastructure.ResourceInvoker.Next(State& next, Scope& scope, Object& state, Boolean& isCompleted)
at Microsoft.AspNetCore.Mvc.Infrastructure.ResourceInvoker.InvokeFilterPipelineAsync()
--- End of stack trace from previous location ---
at Microsoft.AspNetCore.Mvc.Infrastructure.ResourceInvoker.<InvokeAsync>g__Logged|17_1(ResourceInvoker invoker)
at Microsoft.AspNetCore.Mvc.Infrastructure.ResourceInvoker.<InvokeAsync>g__Logged|17_1(ResourceInvoker invoker)
at Microsoft.AspNetCore.Routing.EndpointMiddleware.<Invoke>g__AwaitRequestTask|7_0(Endpoint endpoint, Task requestTask, ILogger logger)
at Microsoft.AspNetCore.Authorization.AuthorizationMiddleware.Invoke(HttpContext context)
at Microsoft.AspNetCore.Authentication.AuthenticationMiddleware.Invoke(HttpContext context)
at Microsoft.AspNetCore.Diagnostics.ExceptionHandlerMiddlewareImpl.<Invoke>g__Awaited|10_0(ExceptionHandlerMiddlewareImpl middleware, HttpContext context, Task task)
2025-06-13 04:35:49.2270: Request headers: [
"Accept",
"Accept-Encoding",
"Accept-Language",
"Authorization",
"Connection",
"Content-Length",
"Content-Type",
"Cookie",
"Host",
"Referer",
"User-Agent",
"sec-ch-ua-platform",
"sec-ch-ua",
"sec-ch-ua-mobile",
"origin",
"sec-fetch-site",
"sec-fetch-mode",
"sec-fetch-dest",
"priority"
]
2025-06-13 04:35:49.2273: Request item keys: [
"DW_Current_ExecutionTable"
]
2025-06-13 04:35:49.2276: Request form: []
Please let me know if additional information is needed.
Thank you,
Melissa B.
