2025-12-04 09:55:49.552 +05:30 1ee23d4a-8469-4c57-811d-3c81f1c0b575 ERR Database error occurred: The datepart day is not supported by date function dateadd for data type time. 2025-12-04 11:42:45.338 +05:30 eedf0374-75ea-4322-a471-8a035753ad2a ERR Error occurred while excecuting procedure:xsp_t_Worksheet_GS: 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.BeginExecuteReader(AsyncCallback callback, Object stateObject, CommandBehavior behavior) at System.Threading.Tasks.TaskFactory`1.FromAsyncImpl[TArg1](Func`4 beginMethod, Func`2 endFunction, Action`1 endAction, TArg1 arg1, Object state, TaskCreationOptions creationOptions) at System.Data.SqlClient.SqlCommand.ExecuteReaderAsync(CommandBehavior behavior, CancellationToken cancellationToken) --- End of stack trace from previous location --- at Sang.Service.Common.CommonService.CommonEntityService.FetchDataTableFromProcedure(String procedureName, SqlParameter[] parameters, Boolean useExtendedTimeout) at Sang.Service.Common.CommonService.CommonEntityService.FetchDataTableFromProcedure(String procedureName, SqlParameter[] parameters, Boolean useExtendedTimeout) at Sang.Service.Common.CommonService.CommonEntityService.FetchDataTableFromProcedure(String procedureName, SqlParameter[] parameters, Boolean useExtendedTimeout) 2025-12-04 11:42:45.341 +05:30 eedf0374-75ea-4322-a471-8a035753ad2a ERR SqlDateTime overflow. Must be between 1/1/1753 12:00:00 AM and 12/31/9999 11:59:59 PM. 2025-12-04 11:42:45.354 +05:30 eedf0374-75ea-4322-a471-8a035753ad2a ERR Error Getting JobList from database 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.BeginExecuteReader(AsyncCallback callback, Object stateObject, CommandBehavior behavior) at System.Threading.Tasks.TaskFactory`1.FromAsyncImpl[TArg1](Func`4 beginMethod, Func`2 endFunction, Action`1 endAction, TArg1 arg1, Object state, TaskCreationOptions creationOptions) at System.Data.SqlClient.SqlCommand.ExecuteReaderAsync(CommandBehavior behavior, CancellationToken cancellationToken) --- End of stack trace from previous location --- at Sang.Service.Common.CommonService.CommonEntityService.FetchDataTableFromProcedure(String procedureName, SqlParameter[] parameters, Boolean useExtendedTimeout) at Sang.Service.Common.CommonService.CommonEntityService.FetchDataTableFromProcedure(String procedureName, SqlParameter[] parameters, Boolean useExtendedTimeout) at Sang.Service.Common.CommonService.CommonEntityService.FetchDataTableFromProcedure(String procedureName, SqlParameter[] parameters, Boolean useExtendedTimeout) at Sang.TimeMonitor.Api.Repositories.JobRepository.GetJobSummary(JobSummaryRequest summaryRequest) at Sang.TimeMonitor.Api.Services.JobService.<>c__DisplayClass5_0.<b__0>d.MoveNext() --- End of stack trace from previous location --- at Sang.Service.Common.CommonService.MemoryRequestCache.GetOrExecuteWithSorting[T](String key, Func`1 action, Int32 pageNumber, Int32 pageSize, Int32 cacheEntryLifeTime, String column, String sortColumn, Boolean isAscending, String searchString) 2025-12-04 11:42:45.357 +05:30 eedf0374-75ea-4322-a471-8a035753ad2a ERR Getting Job Summary Failed 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.BeginExecuteReader(AsyncCallback callback, Object stateObject, CommandBehavior behavior) at System.Threading.Tasks.TaskFactory`1.FromAsyncImpl[TArg1](Func`4 beginMethod, Func`2 endFunction, Action`1 endAction, TArg1 arg1, Object state, TaskCreationOptions creationOptions) at System.Data.SqlClient.SqlCommand.ExecuteReaderAsync(CommandBehavior behavior, CancellationToken cancellationToken) --- End of stack trace from previous location --- at Sang.Service.Common.CommonService.CommonEntityService.FetchDataTableFromProcedure(String procedureName, SqlParameter[] parameters, Boolean useExtendedTimeout) at Sang.Service.Common.CommonService.CommonEntityService.FetchDataTableFromProcedure(String procedureName, SqlParameter[] parameters, Boolean useExtendedTimeout) at Sang.Service.Common.CommonService.CommonEntityService.FetchDataTableFromProcedure(String procedureName, SqlParameter[] parameters, Boolean useExtendedTimeout) at Sang.TimeMonitor.Api.Repositories.JobRepository.GetJobSummary(JobSummaryRequest summaryRequest) at Sang.TimeMonitor.Api.Services.JobService.<>c__DisplayClass5_0.<b__0>d.MoveNext() --- End of stack trace from previous location --- at Sang.Service.Common.CommonService.MemoryRequestCache.GetOrExecuteWithSorting[T](String key, Func`1 action, Int32 pageNumber, Int32 pageSize, Int32 cacheEntryLifeTime, String column, String sortColumn, Boolean isAscending, String searchString) at Sang.TimeMonitor.Api.Services.JobService.GetJobSummary(JobSummaryRequest summaryRequest) at Sang.TimeMonitor.Api.Controllers.JobController.GetJobSummary(JobSummaryRequest summaryRequest) 2025-12-04 11:42:46.015 +05:30 51dcb4bc-1813-4e66-8259-2f1c13e207d1 ERR Error occurred while excecuting procedure:xsp_t_Worksheet_GS: 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.BeginExecuteReader(AsyncCallback callback, Object stateObject, CommandBehavior behavior) at System.Threading.Tasks.TaskFactory`1.FromAsyncImpl[TArg1](Func`4 beginMethod, Func`2 endFunction, Action`1 endAction, TArg1 arg1, Object state, TaskCreationOptions creationOptions) at System.Data.SqlClient.SqlCommand.ExecuteReaderAsync(CommandBehavior behavior, CancellationToken cancellationToken) --- End of stack trace from previous location --- at Sang.Service.Common.CommonService.CommonEntityService.FetchDataTableFromProcedure(String procedureName, SqlParameter[] parameters, Boolean useExtendedTimeout) at Sang.Service.Common.CommonService.CommonEntityService.FetchDataTableFromProcedure(String procedureName, SqlParameter[] parameters, Boolean useExtendedTimeout) at Sang.Service.Common.CommonService.CommonEntityService.FetchDataTableFromProcedure(String procedureName, SqlParameter[] parameters, Boolean useExtendedTimeout) 2025-12-04 11:42:46.015 +05:30 51dcb4bc-1813-4e66-8259-2f1c13e207d1 ERR SqlDateTime overflow. Must be between 1/1/1753 12:00:00 AM and 12/31/9999 11:59:59 PM. 2025-12-04 11:42:46.016 +05:30 51dcb4bc-1813-4e66-8259-2f1c13e207d1 ERR Error Getting JobList from database 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.BeginExecuteReader(AsyncCallback callback, Object stateObject, CommandBehavior behavior) at System.Threading.Tasks.TaskFactory`1.FromAsyncImpl[TArg1](Func`4 beginMethod, Func`2 endFunction, Action`1 endAction, TArg1 arg1, Object state, TaskCreationOptions creationOptions) at System.Data.SqlClient.SqlCommand.ExecuteReaderAsync(CommandBehavior behavior, CancellationToken cancellationToken) --- End of stack trace from previous location --- at Sang.Service.Common.CommonService.CommonEntityService.FetchDataTableFromProcedure(String procedureName, SqlParameter[] parameters, Boolean useExtendedTimeout) at Sang.Service.Common.CommonService.CommonEntityService.FetchDataTableFromProcedure(String procedureName, SqlParameter[] parameters, Boolean useExtendedTimeout) at Sang.Service.Common.CommonService.CommonEntityService.FetchDataTableFromProcedure(String procedureName, SqlParameter[] parameters, Boolean useExtendedTimeout) at Sang.TimeMonitor.Api.Repositories.JobRepository.GetJobSummary(JobSummaryRequest summaryRequest) at Sang.TimeMonitor.Api.Services.JobService.<>c__DisplayClass5_0.<b__0>d.MoveNext() --- End of stack trace from previous location --- at Sang.Service.Common.CommonService.MemoryRequestCache.GetOrExecuteWithSorting[T](String key, Func`1 action, Int32 pageNumber, Int32 pageSize, Int32 cacheEntryLifeTime, String column, String sortColumn, Boolean isAscending, String searchString) 2025-12-04 11:42:46.017 +05:30 51dcb4bc-1813-4e66-8259-2f1c13e207d1 ERR Getting Job Summary Failed 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.BeginExecuteReader(AsyncCallback callback, Object stateObject, CommandBehavior behavior) at System.Threading.Tasks.TaskFactory`1.FromAsyncImpl[TArg1](Func`4 beginMethod, Func`2 endFunction, Action`1 endAction, TArg1 arg1, Object state, TaskCreationOptions creationOptions) at System.Data.SqlClient.SqlCommand.ExecuteReaderAsync(CommandBehavior behavior, CancellationToken cancellationToken) --- End of stack trace from previous location --- at Sang.Service.Common.CommonService.CommonEntityService.FetchDataTableFromProcedure(String procedureName, SqlParameter[] parameters, Boolean useExtendedTimeout) at Sang.Service.Common.CommonService.CommonEntityService.FetchDataTableFromProcedure(String procedureName, SqlParameter[] parameters, Boolean useExtendedTimeout) at Sang.Service.Common.CommonService.CommonEntityService.FetchDataTableFromProcedure(String procedureName, SqlParameter[] parameters, Boolean useExtendedTimeout) at Sang.TimeMonitor.Api.Repositories.JobRepository.GetJobSummary(JobSummaryRequest summaryRequest) at Sang.TimeMonitor.Api.Services.JobService.<>c__DisplayClass5_0.<b__0>d.MoveNext() --- End of stack trace from previous location --- at Sang.Service.Common.CommonService.MemoryRequestCache.GetOrExecuteWithSorting[T](String key, Func`1 action, Int32 pageNumber, Int32 pageSize, Int32 cacheEntryLifeTime, String column, String sortColumn, Boolean isAscending, String searchString) at Sang.TimeMonitor.Api.Services.JobService.GetJobSummary(JobSummaryRequest summaryRequest) at Sang.TimeMonitor.Api.Controllers.JobController.GetJobSummary(JobSummaryRequest summaryRequest) 2025-12-04 11:42:46.625 +05:30 d0d0acb6-f0d4-4a5e-aa85-747058580769 ERR Error occurred while excecuting procedure:xsp_t_Worksheet_GS: 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.BeginExecuteReader(AsyncCallback callback, Object stateObject, CommandBehavior behavior) at System.Threading.Tasks.TaskFactory`1.FromAsyncImpl[TArg1](Func`4 beginMethod, Func`2 endFunction, Action`1 endAction, TArg1 arg1, Object state, TaskCreationOptions creationOptions) at System.Data.SqlClient.SqlCommand.ExecuteReaderAsync(CommandBehavior behavior, CancellationToken cancellationToken) --- End of stack trace from previous location --- at Sang.Service.Common.CommonService.CommonEntityService.FetchDataTableFromProcedure(String procedureName, SqlParameter[] parameters, Boolean useExtendedTimeout) at Sang.Service.Common.CommonService.CommonEntityService.FetchDataTableFromProcedure(String procedureName, SqlParameter[] parameters, Boolean useExtendedTimeout) at Sang.Service.Common.CommonService.CommonEntityService.FetchDataTableFromProcedure(String procedureName, SqlParameter[] parameters, Boolean useExtendedTimeout) 2025-12-04 11:42:46.625 +05:30 d0d0acb6-f0d4-4a5e-aa85-747058580769 ERR SqlDateTime overflow. Must be between 1/1/1753 12:00:00 AM and 12/31/9999 11:59:59 PM. 2025-12-04 11:42:46.626 +05:30 d0d0acb6-f0d4-4a5e-aa85-747058580769 ERR Error Getting JobList from database 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.BeginExecuteReader(AsyncCallback callback, Object stateObject, CommandBehavior behavior) at System.Threading.Tasks.TaskFactory`1.FromAsyncImpl[TArg1](Func`4 beginMethod, Func`2 endFunction, Action`1 endAction, TArg1 arg1, Object state, TaskCreationOptions creationOptions) at System.Data.SqlClient.SqlCommand.ExecuteReaderAsync(CommandBehavior behavior, CancellationToken cancellationToken) --- End of stack trace from previous location --- at Sang.Service.Common.CommonService.CommonEntityService.FetchDataTableFromProcedure(String procedureName, SqlParameter[] parameters, Boolean useExtendedTimeout) at Sang.Service.Common.CommonService.CommonEntityService.FetchDataTableFromProcedure(String procedureName, SqlParameter[] parameters, Boolean useExtendedTimeout) at Sang.Service.Common.CommonService.CommonEntityService.FetchDataTableFromProcedure(String procedureName, SqlParameter[] parameters, Boolean useExtendedTimeout) at Sang.TimeMonitor.Api.Repositories.JobRepository.GetJobSummary(JobSummaryRequest summaryRequest) at Sang.TimeMonitor.Api.Services.JobService.<>c__DisplayClass5_0.<b__0>d.MoveNext() --- End of stack trace from previous location --- at Sang.Service.Common.CommonService.MemoryRequestCache.GetOrExecuteWithSorting[T](String key, Func`1 action, Int32 pageNumber, Int32 pageSize, Int32 cacheEntryLifeTime, String column, String sortColumn, Boolean isAscending, String searchString) 2025-12-04 11:42:46.627 +05:30 d0d0acb6-f0d4-4a5e-aa85-747058580769 ERR Getting Job Summary Failed 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.BeginExecuteReader(AsyncCallback callback, Object stateObject, CommandBehavior behavior) at System.Threading.Tasks.TaskFactory`1.FromAsyncImpl[TArg1](Func`4 beginMethod, Func`2 endFunction, Action`1 endAction, TArg1 arg1, Object state, TaskCreationOptions creationOptions) at System.Data.SqlClient.SqlCommand.ExecuteReaderAsync(CommandBehavior behavior, CancellationToken cancellationToken) --- End of stack trace from previous location --- at Sang.Service.Common.CommonService.CommonEntityService.FetchDataTableFromProcedure(String procedureName, SqlParameter[] parameters, Boolean useExtendedTimeout) at Sang.Service.Common.CommonService.CommonEntityService.FetchDataTableFromProcedure(String procedureName, SqlParameter[] parameters, Boolean useExtendedTimeout) at Sang.Service.Common.CommonService.CommonEntityService.FetchDataTableFromProcedure(String procedureName, SqlParameter[] parameters, Boolean useExtendedTimeout) at Sang.TimeMonitor.Api.Repositories.JobRepository.GetJobSummary(JobSummaryRequest summaryRequest) at Sang.TimeMonitor.Api.Services.JobService.<>c__DisplayClass5_0.<b__0>d.MoveNext() --- End of stack trace from previous location --- at Sang.Service.Common.CommonService.MemoryRequestCache.GetOrExecuteWithSorting[T](String key, Func`1 action, Int32 pageNumber, Int32 pageSize, Int32 cacheEntryLifeTime, String column, String sortColumn, Boolean isAscending, String searchString) at Sang.TimeMonitor.Api.Services.JobService.GetJobSummary(JobSummaryRequest summaryRequest) at Sang.TimeMonitor.Api.Controllers.JobController.GetJobSummary(JobSummaryRequest summaryRequest) 2025-12-04 11:43:36.656 +05:30 75fb1bd5-23a5-4474-be5d-9b4fc17d0f8b ERR Error occurred while excecuting procedure:xsp_t_Worksheet_GS: 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.BeginExecuteReader(AsyncCallback callback, Object stateObject, CommandBehavior behavior) at System.Threading.Tasks.TaskFactory`1.FromAsyncImpl[TArg1](Func`4 beginMethod, Func`2 endFunction, Action`1 endAction, TArg1 arg1, Object state, TaskCreationOptions creationOptions) at System.Data.SqlClient.SqlCommand.ExecuteReaderAsync(CommandBehavior behavior, CancellationToken cancellationToken) --- End of stack trace from previous location --- at Sang.Service.Common.CommonService.CommonEntityService.FetchDataTableFromProcedure(String procedureName, SqlParameter[] parameters, Boolean useExtendedTimeout) at Sang.Service.Common.CommonService.CommonEntityService.FetchDataTableFromProcedure(String procedureName, SqlParameter[] parameters, Boolean useExtendedTimeout) at Sang.Service.Common.CommonService.CommonEntityService.FetchDataTableFromProcedure(String procedureName, SqlParameter[] parameters, Boolean useExtendedTimeout) 2025-12-04 11:43:36.657 +05:30 75fb1bd5-23a5-4474-be5d-9b4fc17d0f8b ERR SqlDateTime overflow. Must be between 1/1/1753 12:00:00 AM and 12/31/9999 11:59:59 PM. 2025-12-04 11:43:36.658 +05:30 75fb1bd5-23a5-4474-be5d-9b4fc17d0f8b ERR Error Getting JobList from database 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.BeginExecuteReader(AsyncCallback callback, Object stateObject, CommandBehavior behavior) at System.Threading.Tasks.TaskFactory`1.FromAsyncImpl[TArg1](Func`4 beginMethod, Func`2 endFunction, Action`1 endAction, TArg1 arg1, Object state, TaskCreationOptions creationOptions) at System.Data.SqlClient.SqlCommand.ExecuteReaderAsync(CommandBehavior behavior, CancellationToken cancellationToken) --- End of stack trace from previous location --- at Sang.Service.Common.CommonService.CommonEntityService.FetchDataTableFromProcedure(String procedureName, SqlParameter[] parameters, Boolean useExtendedTimeout) at Sang.Service.Common.CommonService.CommonEntityService.FetchDataTableFromProcedure(String procedureName, SqlParameter[] parameters, Boolean useExtendedTimeout) at Sang.Service.Common.CommonService.CommonEntityService.FetchDataTableFromProcedure(String procedureName, SqlParameter[] parameters, Boolean useExtendedTimeout) at Sang.TimeMonitor.Api.Repositories.JobRepository.GetJobSummary(JobSummaryRequest summaryRequest) at Sang.TimeMonitor.Api.Services.JobService.<>c__DisplayClass5_0.<b__0>d.MoveNext() --- End of stack trace from previous location --- at Sang.Service.Common.CommonService.MemoryRequestCache.GetOrExecuteWithSorting[T](String key, Func`1 action, Int32 pageNumber, Int32 pageSize, Int32 cacheEntryLifeTime, String column, String sortColumn, Boolean isAscending, String searchString) 2025-12-04 11:43:36.660 +05:30 75fb1bd5-23a5-4474-be5d-9b4fc17d0f8b ERR Getting Job Summary Failed 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.BeginExecuteReader(AsyncCallback callback, Object stateObject, CommandBehavior behavior) at System.Threading.Tasks.TaskFactory`1.FromAsyncImpl[TArg1](Func`4 beginMethod, Func`2 endFunction, Action`1 endAction, TArg1 arg1, Object state, TaskCreationOptions creationOptions) at System.Data.SqlClient.SqlCommand.ExecuteReaderAsync(CommandBehavior behavior, CancellationToken cancellationToken) --- End of stack trace from previous location --- at Sang.Service.Common.CommonService.CommonEntityService.FetchDataTableFromProcedure(String procedureName, SqlParameter[] parameters, Boolean useExtendedTimeout) at Sang.Service.Common.CommonService.CommonEntityService.FetchDataTableFromProcedure(String procedureName, SqlParameter[] parameters, Boolean useExtendedTimeout) at Sang.Service.Common.CommonService.CommonEntityService.FetchDataTableFromProcedure(String procedureName, SqlParameter[] parameters, Boolean useExtendedTimeout) at Sang.TimeMonitor.Api.Repositories.JobRepository.GetJobSummary(JobSummaryRequest summaryRequest) at Sang.TimeMonitor.Api.Services.JobService.<>c__DisplayClass5_0.<b__0>d.MoveNext() --- End of stack trace from previous location --- at Sang.Service.Common.CommonService.MemoryRequestCache.GetOrExecuteWithSorting[T](String key, Func`1 action, Int32 pageNumber, Int32 pageSize, Int32 cacheEntryLifeTime, String column, String sortColumn, Boolean isAscending, String searchString) at Sang.TimeMonitor.Api.Services.JobService.GetJobSummary(JobSummaryRequest summaryRequest) at Sang.TimeMonitor.Api.Controllers.JobController.GetJobSummary(JobSummaryRequest summaryRequest) 2025-12-04 11:43:37.175 +05:30 659a88fe-54a9-4180-b341-5551fca75363 ERR Error occurred while excecuting procedure:xsp_t_Worksheet_GS: 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.BeginExecuteReader(AsyncCallback callback, Object stateObject, CommandBehavior behavior) at System.Threading.Tasks.TaskFactory`1.FromAsyncImpl[TArg1](Func`4 beginMethod, Func`2 endFunction, Action`1 endAction, TArg1 arg1, Object state, TaskCreationOptions creationOptions) at System.Data.SqlClient.SqlCommand.ExecuteReaderAsync(CommandBehavior behavior, CancellationToken cancellationToken) --- End of stack trace from previous location --- at Sang.Service.Common.CommonService.CommonEntityService.FetchDataTableFromProcedure(String procedureName, SqlParameter[] parameters, Boolean useExtendedTimeout) at Sang.Service.Common.CommonService.CommonEntityService.FetchDataTableFromProcedure(String procedureName, SqlParameter[] parameters, Boolean useExtendedTimeout) at Sang.Service.Common.CommonService.CommonEntityService.FetchDataTableFromProcedure(String procedureName, SqlParameter[] parameters, Boolean useExtendedTimeout) 2025-12-04 11:43:37.176 +05:30 659a88fe-54a9-4180-b341-5551fca75363 ERR SqlDateTime overflow. Must be between 1/1/1753 12:00:00 AM and 12/31/9999 11:59:59 PM. 2025-12-04 11:43:37.177 +05:30 659a88fe-54a9-4180-b341-5551fca75363 ERR Error Getting JobList from database 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.BeginExecuteReader(AsyncCallback callback, Object stateObject, CommandBehavior behavior) at System.Threading.Tasks.TaskFactory`1.FromAsyncImpl[TArg1](Func`4 beginMethod, Func`2 endFunction, Action`1 endAction, TArg1 arg1, Object state, TaskCreationOptions creationOptions) at System.Data.SqlClient.SqlCommand.ExecuteReaderAsync(CommandBehavior behavior, CancellationToken cancellationToken) --- End of stack trace from previous location --- at Sang.Service.Common.CommonService.CommonEntityService.FetchDataTableFromProcedure(String procedureName, SqlParameter[] parameters, Boolean useExtendedTimeout) at Sang.Service.Common.CommonService.CommonEntityService.FetchDataTableFromProcedure(String procedureName, SqlParameter[] parameters, Boolean useExtendedTimeout) at Sang.Service.Common.CommonService.CommonEntityService.FetchDataTableFromProcedure(String procedureName, SqlParameter[] parameters, Boolean useExtendedTimeout) at Sang.TimeMonitor.Api.Repositories.JobRepository.GetJobSummary(JobSummaryRequest summaryRequest) at Sang.TimeMonitor.Api.Services.JobService.<>c__DisplayClass5_0.<b__0>d.MoveNext() --- End of stack trace from previous location --- at Sang.Service.Common.CommonService.MemoryRequestCache.GetOrExecuteWithSorting[T](String key, Func`1 action, Int32 pageNumber, Int32 pageSize, Int32 cacheEntryLifeTime, String column, String sortColumn, Boolean isAscending, String searchString) 2025-12-04 11:43:37.178 +05:30 659a88fe-54a9-4180-b341-5551fca75363 ERR Getting Job Summary Failed 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.BeginExecuteReader(AsyncCallback callback, Object stateObject, CommandBehavior behavior) at System.Threading.Tasks.TaskFactory`1.FromAsyncImpl[TArg1](Func`4 beginMethod, Func`2 endFunction, Action`1 endAction, TArg1 arg1, Object state, TaskCreationOptions creationOptions) at System.Data.SqlClient.SqlCommand.ExecuteReaderAsync(CommandBehavior behavior, CancellationToken cancellationToken) --- End of stack trace from previous location --- at Sang.Service.Common.CommonService.CommonEntityService.FetchDataTableFromProcedure(String procedureName, SqlParameter[] parameters, Boolean useExtendedTimeout) at Sang.Service.Common.CommonService.CommonEntityService.FetchDataTableFromProcedure(String procedureName, SqlParameter[] parameters, Boolean useExtendedTimeout) at Sang.Service.Common.CommonService.CommonEntityService.FetchDataTableFromProcedure(String procedureName, SqlParameter[] parameters, Boolean useExtendedTimeout) at Sang.TimeMonitor.Api.Repositories.JobRepository.GetJobSummary(JobSummaryRequest summaryRequest) at Sang.TimeMonitor.Api.Services.JobService.<>c__DisplayClass5_0.<b__0>d.MoveNext() --- End of stack trace from previous location --- at Sang.Service.Common.CommonService.MemoryRequestCache.GetOrExecuteWithSorting[T](String key, Func`1 action, Int32 pageNumber, Int32 pageSize, Int32 cacheEntryLifeTime, String column, String sortColumn, Boolean isAscending, String searchString) at Sang.TimeMonitor.Api.Services.JobService.GetJobSummary(JobSummaryRequest summaryRequest) at Sang.TimeMonitor.Api.Controllers.JobController.GetJobSummary(JobSummaryRequest summaryRequest) 2025-12-04 11:43:37.618 +05:30 26e64ffd-a02e-4da9-b07c-eca868e32a82 ERR Error occurred while excecuting procedure:xsp_t_Worksheet_GS: 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.BeginExecuteReader(AsyncCallback callback, Object stateObject, CommandBehavior behavior) at System.Threading.Tasks.TaskFactory`1.FromAsyncImpl[TArg1](Func`4 beginMethod, Func`2 endFunction, Action`1 endAction, TArg1 arg1, Object state, TaskCreationOptions creationOptions) at System.Data.SqlClient.SqlCommand.ExecuteReaderAsync(CommandBehavior behavior, CancellationToken cancellationToken) --- End of stack trace from previous location --- at Sang.Service.Common.CommonService.CommonEntityService.FetchDataTableFromProcedure(String procedureName, SqlParameter[] parameters, Boolean useExtendedTimeout) at Sang.Service.Common.CommonService.CommonEntityService.FetchDataTableFromProcedure(String procedureName, SqlParameter[] parameters, Boolean useExtendedTimeout) at Sang.Service.Common.CommonService.CommonEntityService.FetchDataTableFromProcedure(String procedureName, SqlParameter[] parameters, Boolean useExtendedTimeout) 2025-12-04 11:43:37.618 +05:30 26e64ffd-a02e-4da9-b07c-eca868e32a82 ERR SqlDateTime overflow. Must be between 1/1/1753 12:00:00 AM and 12/31/9999 11:59:59 PM. 2025-12-04 11:43:37.619 +05:30 26e64ffd-a02e-4da9-b07c-eca868e32a82 ERR Error Getting JobList from database 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.BeginExecuteReader(AsyncCallback callback, Object stateObject, CommandBehavior behavior) at System.Threading.Tasks.TaskFactory`1.FromAsyncImpl[TArg1](Func`4 beginMethod, Func`2 endFunction, Action`1 endAction, TArg1 arg1, Object state, TaskCreationOptions creationOptions) at System.Data.SqlClient.SqlCommand.ExecuteReaderAsync(CommandBehavior behavior, CancellationToken cancellationToken) --- End of stack trace from previous location --- at Sang.Service.Common.CommonService.CommonEntityService.FetchDataTableFromProcedure(String procedureName, SqlParameter[] parameters, Boolean useExtendedTimeout) at Sang.Service.Common.CommonService.CommonEntityService.FetchDataTableFromProcedure(String procedureName, SqlParameter[] parameters, Boolean useExtendedTimeout) at Sang.Service.Common.CommonService.CommonEntityService.FetchDataTableFromProcedure(String procedureName, SqlParameter[] parameters, Boolean useExtendedTimeout) at Sang.TimeMonitor.Api.Repositories.JobRepository.GetJobSummary(JobSummaryRequest summaryRequest) at Sang.TimeMonitor.Api.Services.JobService.<>c__DisplayClass5_0.<b__0>d.MoveNext() --- End of stack trace from previous location --- at Sang.Service.Common.CommonService.MemoryRequestCache.GetOrExecuteWithSorting[T](String key, Func`1 action, Int32 pageNumber, Int32 pageSize, Int32 cacheEntryLifeTime, String column, String sortColumn, Boolean isAscending, String searchString) 2025-12-04 11:43:37.620 +05:30 26e64ffd-a02e-4da9-b07c-eca868e32a82 ERR Getting Job Summary Failed 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.BeginExecuteReader(AsyncCallback callback, Object stateObject, CommandBehavior behavior) at System.Threading.Tasks.TaskFactory`1.FromAsyncImpl[TArg1](Func`4 beginMethod, Func`2 endFunction, Action`1 endAction, TArg1 arg1, Object state, TaskCreationOptions creationOptions) at System.Data.SqlClient.SqlCommand.ExecuteReaderAsync(CommandBehavior behavior, CancellationToken cancellationToken) --- End of stack trace from previous location --- at Sang.Service.Common.CommonService.CommonEntityService.FetchDataTableFromProcedure(String procedureName, SqlParameter[] parameters, Boolean useExtendedTimeout) at Sang.Service.Common.CommonService.CommonEntityService.FetchDataTableFromProcedure(String procedureName, SqlParameter[] parameters, Boolean useExtendedTimeout) at Sang.Service.Common.CommonService.CommonEntityService.FetchDataTableFromProcedure(String procedureName, SqlParameter[] parameters, Boolean useExtendedTimeout) at Sang.TimeMonitor.Api.Repositories.JobRepository.GetJobSummary(JobSummaryRequest summaryRequest) at Sang.TimeMonitor.Api.Services.JobService.<>c__DisplayClass5_0.<b__0>d.MoveNext() --- End of stack trace from previous location --- at Sang.Service.Common.CommonService.MemoryRequestCache.GetOrExecuteWithSorting[T](String key, Func`1 action, Int32 pageNumber, Int32 pageSize, Int32 cacheEntryLifeTime, String column, String sortColumn, Boolean isAscending, String searchString) at Sang.TimeMonitor.Api.Services.JobService.GetJobSummary(JobSummaryRequest summaryRequest) at Sang.TimeMonitor.Api.Controllers.JobController.GetJobSummary(JobSummaryRequest summaryRequest) 2025-12-04 12:04:41.509 +05:30 68c80836-685e-4ff0-ba4b-fcf282090be9 ERR SqlDateTime overflow. Must be between 1/1/1753 12:00:00 AM and 12/31/9999 11:59:59 PM. 2025-12-04 12:04:41.510 +05:30 68c80836-685e-4ff0-ba4b-fcf282090be9 ERR SqlDateTime overflow. Must be between 1/1/1753 12:00:00 AM and 12/31/9999 11:59:59 PM. 2025-12-04 12:04:41.514 +05:30 68c80836-685e-4ff0-ba4b-fcf282090be9 ERR Getting Dashboard Details failed 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.BeginExecuteReader(AsyncCallback callback, Object stateObject, CommandBehavior behavior) at System.Threading.Tasks.TaskFactory`1.FromAsyncImpl[TArg1](Func`4 beginMethod, Func`2 endFunction, Action`1 endAction, TArg1 arg1, Object state, TaskCreationOptions creationOptions) at System.Data.SqlClient.SqlCommand.ExecuteReaderAsync(CommandBehavior behavior, CancellationToken cancellationToken) --- End of stack trace from previous location --- at Sang.Service.Common.CommonService.CommonEntityService.ExecuteScalar[T](String procedureName, SqlParameter[] parameters, Boolean useExtendedTimeout) at Sang.TimeMonitor.Api.Repositories.DashBoardRepository.GetDashBoardDetails(DashBoardRequest request) at Sang.TimeMonitor.Api.Services.DashBoardService.GetDashBoardDetails(DashBoardRequest request) at Sang.TimeMonitor.Api.Controllers.DashBoardController.GetDashBoardDetails(DashBoardRequest request) 2025-12-04 12:04:57.516 +05:30 a927bcf1-a5a5-473d-bb8b-186b4aaf247e ERR SqlDateTime overflow. Must be between 1/1/1753 12:00:00 AM and 12/31/9999 11:59:59 PM. 2025-12-04 12:04:57.516 +05:30 a927bcf1-a5a5-473d-bb8b-186b4aaf247e ERR SqlDateTime overflow. Must be between 1/1/1753 12:00:00 AM and 12/31/9999 11:59:59 PM. 2025-12-04 12:04:57.519 +05:30 a927bcf1-a5a5-473d-bb8b-186b4aaf247e ERR Getting Dashboard Details failed 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.BeginExecuteReader(AsyncCallback callback, Object stateObject, CommandBehavior behavior) at System.Threading.Tasks.TaskFactory`1.FromAsyncImpl[TArg1](Func`4 beginMethod, Func`2 endFunction, Action`1 endAction, TArg1 arg1, Object state, TaskCreationOptions creationOptions) at System.Data.SqlClient.SqlCommand.ExecuteReaderAsync(CommandBehavior behavior, CancellationToken cancellationToken) --- End of stack trace from previous location --- at Sang.Service.Common.CommonService.CommonEntityService.ExecuteScalar[T](String procedureName, SqlParameter[] parameters, Boolean useExtendedTimeout) at Sang.TimeMonitor.Api.Repositories.DashBoardRepository.GetDashBoardDetails(DashBoardRequest request) at Sang.TimeMonitor.Api.Services.DashBoardService.GetDashBoardDetails(DashBoardRequest request) at Sang.TimeMonitor.Api.Controllers.DashBoardController.GetDashBoardDetails(DashBoardRequest request) 2025-12-04 12:05:59.169 +05:30 4f685f06-3d0f-4df8-b7b7-1b044a5b9bbe ERR Database error occurred: The datepart day is not supported by date function dateadd for data type time. 2025-12-04 12:09:51.137 +05:30 40167be4-c969-4650-b7d1-db89844dbe1d ERR Database error occurred: The datepart day is not supported by date function dateadd for data type time. 2025-12-04 12:12:53.733 +05:30 9a952138-01d0-43fe-a5c1-41e8de4feb1a ERR Database error occurred: The datepart day is not supported by date function dateadd for data type time. 2025-12-04 12:21:14.980 +05:30 0f02c2b1-292c-445a-a167-e9aeec69868f ERR Database error occurred: The datepart day is not supported by date function dateadd for data type time. 2025-12-04 12:24:47.969 +05:30 db16cbc6-58c9-4534-b0cd-b46dea70864a ERR Database error occurred: The datepart day is not supported by date function dateadd for data type time. 2025-12-04 12:52:42.802 +05:30 3c72306d-eb51-4e5c-9e4d-9de0c9164e51 ERR Error occurred while excecuting procedure:xsp_t_Worksheet_GS: 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.BeginExecuteReader(AsyncCallback callback, Object stateObject, CommandBehavior behavior) at System.Threading.Tasks.TaskFactory`1.FromAsyncImpl[TArg1](Func`4 beginMethod, Func`2 endFunction, Action`1 endAction, TArg1 arg1, Object state, TaskCreationOptions creationOptions) at System.Data.SqlClient.SqlCommand.ExecuteReaderAsync(CommandBehavior behavior, CancellationToken cancellationToken) --- End of stack trace from previous location --- at Sang.Service.Common.CommonService.CommonEntityService.FetchDataTableFromProcedure(String procedureName, SqlParameter[] parameters, Boolean useExtendedTimeout) at Sang.Service.Common.CommonService.CommonEntityService.FetchDataTableFromProcedure(String procedureName, SqlParameter[] parameters, Boolean useExtendedTimeout) at Sang.Service.Common.CommonService.CommonEntityService.FetchDataTableFromProcedure(String procedureName, SqlParameter[] parameters, Boolean useExtendedTimeout) 2025-12-04 12:52:42.804 +05:30 3c72306d-eb51-4e5c-9e4d-9de0c9164e51 ERR SqlDateTime overflow. Must be between 1/1/1753 12:00:00 AM and 12/31/9999 11:59:59 PM. 2025-12-04 12:52:42.806 +05:30 3c72306d-eb51-4e5c-9e4d-9de0c9164e51 ERR Error Getting JobList from database 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.BeginExecuteReader(AsyncCallback callback, Object stateObject, CommandBehavior behavior) at System.Threading.Tasks.TaskFactory`1.FromAsyncImpl[TArg1](Func`4 beginMethod, Func`2 endFunction, Action`1 endAction, TArg1 arg1, Object state, TaskCreationOptions creationOptions) at System.Data.SqlClient.SqlCommand.ExecuteReaderAsync(CommandBehavior behavior, CancellationToken cancellationToken) --- End of stack trace from previous location --- at Sang.Service.Common.CommonService.CommonEntityService.FetchDataTableFromProcedure(String procedureName, SqlParameter[] parameters, Boolean useExtendedTimeout) at Sang.Service.Common.CommonService.CommonEntityService.FetchDataTableFromProcedure(String procedureName, SqlParameter[] parameters, Boolean useExtendedTimeout) at Sang.Service.Common.CommonService.CommonEntityService.FetchDataTableFromProcedure(String procedureName, SqlParameter[] parameters, Boolean useExtendedTimeout) at Sang.TimeMonitor.Api.Repositories.JobRepository.GetJobSummary(JobSummaryRequest summaryRequest) at Sang.TimeMonitor.Api.Services.JobService.<>c__DisplayClass5_0.<b__0>d.MoveNext() --- End of stack trace from previous location --- at Sang.Service.Common.CommonService.MemoryRequestCache.GetOrExecuteWithSorting[T](String key, Func`1 action, Int32 pageNumber, Int32 pageSize, Int32 cacheEntryLifeTime, String column, String sortColumn, Boolean isAscending, String searchString) 2025-12-04 12:52:42.808 +05:30 3c72306d-eb51-4e5c-9e4d-9de0c9164e51 ERR Getting Job Summary Failed 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.BeginExecuteReader(AsyncCallback callback, Object stateObject, CommandBehavior behavior) at System.Threading.Tasks.TaskFactory`1.FromAsyncImpl[TArg1](Func`4 beginMethod, Func`2 endFunction, Action`1 endAction, TArg1 arg1, Object state, TaskCreationOptions creationOptions) at System.Data.SqlClient.SqlCommand.ExecuteReaderAsync(CommandBehavior behavior, CancellationToken cancellationToken) --- End of stack trace from previous location --- at Sang.Service.Common.CommonService.CommonEntityService.FetchDataTableFromProcedure(String procedureName, SqlParameter[] parameters, Boolean useExtendedTimeout) at Sang.Service.Common.CommonService.CommonEntityService.FetchDataTableFromProcedure(String procedureName, SqlParameter[] parameters, Boolean useExtendedTimeout) at Sang.Service.Common.CommonService.CommonEntityService.FetchDataTableFromProcedure(String procedureName, SqlParameter[] parameters, Boolean useExtendedTimeout) at Sang.TimeMonitor.Api.Repositories.JobRepository.GetJobSummary(JobSummaryRequest summaryRequest) at Sang.TimeMonitor.Api.Services.JobService.<>c__DisplayClass5_0.<b__0>d.MoveNext() --- End of stack trace from previous location --- at Sang.Service.Common.CommonService.MemoryRequestCache.GetOrExecuteWithSorting[T](String key, Func`1 action, Int32 pageNumber, Int32 pageSize, Int32 cacheEntryLifeTime, String column, String sortColumn, Boolean isAscending, String searchString) at Sang.TimeMonitor.Api.Services.JobService.GetJobSummary(JobSummaryRequest summaryRequest) at Sang.TimeMonitor.Api.Controllers.JobController.GetJobSummary(JobSummaryRequest summaryRequest) 2025-12-04 12:52:43.481 +05:30 333b2079-0469-4ba4-a4da-11e9364adb24 ERR Error occurred while excecuting procedure:xsp_t_Worksheet_GS: 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.BeginExecuteReader(AsyncCallback callback, Object stateObject, CommandBehavior behavior) at System.Threading.Tasks.TaskFactory`1.FromAsyncImpl[TArg1](Func`4 beginMethod, Func`2 endFunction, Action`1 endAction, TArg1 arg1, Object state, TaskCreationOptions creationOptions) at System.Data.SqlClient.SqlCommand.ExecuteReaderAsync(CommandBehavior behavior, CancellationToken cancellationToken) --- End of stack trace from previous location --- at Sang.Service.Common.CommonService.CommonEntityService.FetchDataTableFromProcedure(String procedureName, SqlParameter[] parameters, Boolean useExtendedTimeout) at Sang.Service.Common.CommonService.CommonEntityService.FetchDataTableFromProcedure(String procedureName, SqlParameter[] parameters, Boolean useExtendedTimeout) at Sang.Service.Common.CommonService.CommonEntityService.FetchDataTableFromProcedure(String procedureName, SqlParameter[] parameters, Boolean useExtendedTimeout) 2025-12-04 12:52:43.482 +05:30 333b2079-0469-4ba4-a4da-11e9364adb24 ERR SqlDateTime overflow. Must be between 1/1/1753 12:00:00 AM and 12/31/9999 11:59:59 PM. 2025-12-04 12:52:43.483 +05:30 333b2079-0469-4ba4-a4da-11e9364adb24 ERR Error Getting JobList from database 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.BeginExecuteReader(AsyncCallback callback, Object stateObject, CommandBehavior behavior) at System.Threading.Tasks.TaskFactory`1.FromAsyncImpl[TArg1](Func`4 beginMethod, Func`2 endFunction, Action`1 endAction, TArg1 arg1, Object state, TaskCreationOptions creationOptions) at System.Data.SqlClient.SqlCommand.ExecuteReaderAsync(CommandBehavior behavior, CancellationToken cancellationToken) --- End of stack trace from previous location --- at Sang.Service.Common.CommonService.CommonEntityService.FetchDataTableFromProcedure(String procedureName, SqlParameter[] parameters, Boolean useExtendedTimeout) at Sang.Service.Common.CommonService.CommonEntityService.FetchDataTableFromProcedure(String procedureName, SqlParameter[] parameters, Boolean useExtendedTimeout) at Sang.Service.Common.CommonService.CommonEntityService.FetchDataTableFromProcedure(String procedureName, SqlParameter[] parameters, Boolean useExtendedTimeout) at Sang.TimeMonitor.Api.Repositories.JobRepository.GetJobSummary(JobSummaryRequest summaryRequest) at Sang.TimeMonitor.Api.Services.JobService.<>c__DisplayClass5_0.<b__0>d.MoveNext() --- End of stack trace from previous location --- at Sang.Service.Common.CommonService.MemoryRequestCache.GetOrExecuteWithSorting[T](String key, Func`1 action, Int32 pageNumber, Int32 pageSize, Int32 cacheEntryLifeTime, String column, String sortColumn, Boolean isAscending, String searchString) 2025-12-04 12:52:43.484 +05:30 333b2079-0469-4ba4-a4da-11e9364adb24 ERR Getting Job Summary Failed 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.BeginExecuteReader(AsyncCallback callback, Object stateObject, CommandBehavior behavior) at System.Threading.Tasks.TaskFactory`1.FromAsyncImpl[TArg1](Func`4 beginMethod, Func`2 endFunction, Action`1 endAction, TArg1 arg1, Object state, TaskCreationOptions creationOptions) at System.Data.SqlClient.SqlCommand.ExecuteReaderAsync(CommandBehavior behavior, CancellationToken cancellationToken) --- End of stack trace from previous location --- at Sang.Service.Common.CommonService.CommonEntityService.FetchDataTableFromProcedure(String procedureName, SqlParameter[] parameters, Boolean useExtendedTimeout) at Sang.Service.Common.CommonService.CommonEntityService.FetchDataTableFromProcedure(String procedureName, SqlParameter[] parameters, Boolean useExtendedTimeout) at Sang.Service.Common.CommonService.CommonEntityService.FetchDataTableFromProcedure(String procedureName, SqlParameter[] parameters, Boolean useExtendedTimeout) at Sang.TimeMonitor.Api.Repositories.JobRepository.GetJobSummary(JobSummaryRequest summaryRequest) at Sang.TimeMonitor.Api.Services.JobService.<>c__DisplayClass5_0.<b__0>d.MoveNext() --- End of stack trace from previous location --- at Sang.Service.Common.CommonService.MemoryRequestCache.GetOrExecuteWithSorting[T](String key, Func`1 action, Int32 pageNumber, Int32 pageSize, Int32 cacheEntryLifeTime, String column, String sortColumn, Boolean isAscending, String searchString) at Sang.TimeMonitor.Api.Services.JobService.GetJobSummary(JobSummaryRequest summaryRequest) at Sang.TimeMonitor.Api.Controllers.JobController.GetJobSummary(JobSummaryRequest summaryRequest) 2025-12-04 12:52:44.028 +05:30 9839d5b7-8a33-402b-9e36-4be3a8e99920 ERR Error occurred while excecuting procedure:xsp_t_Worksheet_GS: 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.BeginExecuteReader(AsyncCallback callback, Object stateObject, CommandBehavior behavior) at System.Threading.Tasks.TaskFactory`1.FromAsyncImpl[TArg1](Func`4 beginMethod, Func`2 endFunction, Action`1 endAction, TArg1 arg1, Object state, TaskCreationOptions creationOptions) at System.Data.SqlClient.SqlCommand.ExecuteReaderAsync(CommandBehavior behavior, CancellationToken cancellationToken) --- End of stack trace from previous location --- at Sang.Service.Common.CommonService.CommonEntityService.FetchDataTableFromProcedure(String procedureName, SqlParameter[] parameters, Boolean useExtendedTimeout) at Sang.Service.Common.CommonService.CommonEntityService.FetchDataTableFromProcedure(String procedureName, SqlParameter[] parameters, Boolean useExtendedTimeout) at Sang.Service.Common.CommonService.CommonEntityService.FetchDataTableFromProcedure(String procedureName, SqlParameter[] parameters, Boolean useExtendedTimeout) 2025-12-04 12:52:44.028 +05:30 9839d5b7-8a33-402b-9e36-4be3a8e99920 ERR SqlDateTime overflow. Must be between 1/1/1753 12:00:00 AM and 12/31/9999 11:59:59 PM. 2025-12-04 12:52:44.029 +05:30 9839d5b7-8a33-402b-9e36-4be3a8e99920 ERR Error Getting JobList from database 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.BeginExecuteReader(AsyncCallback callback, Object stateObject, CommandBehavior behavior) at System.Threading.Tasks.TaskFactory`1.FromAsyncImpl[TArg1](Func`4 beginMethod, Func`2 endFunction, Action`1 endAction, TArg1 arg1, Object state, TaskCreationOptions creationOptions) at System.Data.SqlClient.SqlCommand.ExecuteReaderAsync(CommandBehavior behavior, CancellationToken cancellationToken) --- End of stack trace from previous location --- at Sang.Service.Common.CommonService.CommonEntityService.FetchDataTableFromProcedure(String procedureName, SqlParameter[] parameters, Boolean useExtendedTimeout) at Sang.Service.Common.CommonService.CommonEntityService.FetchDataTableFromProcedure(String procedureName, SqlParameter[] parameters, Boolean useExtendedTimeout) at Sang.Service.Common.CommonService.CommonEntityService.FetchDataTableFromProcedure(String procedureName, SqlParameter[] parameters, Boolean useExtendedTimeout) at Sang.TimeMonitor.Api.Repositories.JobRepository.GetJobSummary(JobSummaryRequest summaryRequest) at Sang.TimeMonitor.Api.Services.JobService.<>c__DisplayClass5_0.<b__0>d.MoveNext() --- End of stack trace from previous location --- at Sang.Service.Common.CommonService.MemoryRequestCache.GetOrExecuteWithSorting[T](String key, Func`1 action, Int32 pageNumber, Int32 pageSize, Int32 cacheEntryLifeTime, String column, String sortColumn, Boolean isAscending, String searchString) 2025-12-04 12:52:44.030 +05:30 9839d5b7-8a33-402b-9e36-4be3a8e99920 ERR Getting Job Summary Failed 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.BeginExecuteReader(AsyncCallback callback, Object stateObject, CommandBehavior behavior) at System.Threading.Tasks.TaskFactory`1.FromAsyncImpl[TArg1](Func`4 beginMethod, Func`2 endFunction, Action`1 endAction, TArg1 arg1, Object state, TaskCreationOptions creationOptions) at System.Data.SqlClient.SqlCommand.ExecuteReaderAsync(CommandBehavior behavior, CancellationToken cancellationToken) --- End of stack trace from previous location --- at Sang.Service.Common.CommonService.CommonEntityService.FetchDataTableFromProcedure(String procedureName, SqlParameter[] parameters, Boolean useExtendedTimeout) at Sang.Service.Common.CommonService.CommonEntityService.FetchDataTableFromProcedure(String procedureName, SqlParameter[] parameters, Boolean useExtendedTimeout) at Sang.Service.Common.CommonService.CommonEntityService.FetchDataTableFromProcedure(String procedureName, SqlParameter[] parameters, Boolean useExtendedTimeout) at Sang.TimeMonitor.Api.Repositories.JobRepository.GetJobSummary(JobSummaryRequest summaryRequest) at Sang.TimeMonitor.Api.Services.JobService.<>c__DisplayClass5_0.<b__0>d.MoveNext() --- End of stack trace from previous location --- at Sang.Service.Common.CommonService.MemoryRequestCache.GetOrExecuteWithSorting[T](String key, Func`1 action, Int32 pageNumber, Int32 pageSize, Int32 cacheEntryLifeTime, String column, String sortColumn, Boolean isAscending, String searchString) at Sang.TimeMonitor.Api.Services.JobService.GetJobSummary(JobSummaryRequest summaryRequest) at Sang.TimeMonitor.Api.Controllers.JobController.GetJobSummary(JobSummaryRequest summaryRequest) 2025-12-04 12:59:19.422 +05:30 2be8f180-a7dd-47ca-981c-2e033c16e15e ERR Database error occurred: The datepart day is not supported by date function dateadd for data type time. 2025-12-04 14:21:16.764 +05:30 f0e29380-54fc-48a2-82df-940051b5cac7 ERR Login failed for user ''. 2025-12-04 14:21:16.788 +05:30 f0e29380-54fc-48a2-82df-940051b5cac7 ERR Token Regeneration failed System.Data.SqlClient.SqlException (0x80131904): Login failed for user ''. at System.Data.SqlClient.SqlInternalConnectionTds..ctor(DbConnectionPoolIdentity identity, SqlConnectionString connectionOptions, SqlCredential credential, Object providerInfo, String newPassword, SecureString newSecurePassword, Boolean redirectedUserInstance, SqlConnectionString userConnectionOptions, SessionData reconnectSessionData, Boolean applyTransientFaultHandling, String accessToken) at System.Data.SqlClient.SqlConnectionFactory.CreateConnection(DbConnectionOptions options, DbConnectionPoolKey poolKey, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningConnection, DbConnectionOptions userOptions) at System.Data.ProviderBase.DbConnectionFactory.CreatePooledConnection(DbConnectionPool pool, DbConnection owningObject, DbConnectionOptions options, DbConnectionPoolKey poolKey, DbConnectionOptions userOptions) at System.Data.ProviderBase.DbConnectionPool.CreateObject(DbConnection owningObject, DbConnectionOptions userOptions, DbConnectionInternal oldConnection) at System.Data.ProviderBase.DbConnectionPool.UserCreateRequest(DbConnection owningObject, DbConnectionOptions userOptions, DbConnectionInternal oldConnection) at System.Data.ProviderBase.DbConnectionPool.TryGetConnection(DbConnection owningObject, UInt32 waitForMultipleObjectsTimeout, Boolean allowCreate, Boolean onlyOneCheckConnection, DbConnectionOptions userOptions, DbConnectionInternal& connection) at System.Data.ProviderBase.DbConnectionPool.WaitForPendingOpen() --- End of stack trace from previous location --- at Sang.Service.Common.CommonService.CommonEntityService.ExecuteProcedureWithResult(String procedureName, SqlParameter[] parameters) at Sang.Service.Common.Authentication.TokenService.RegenerateTokens(String refershToken) at Sang.TimeMonitor.Api.Controllers.LoginController.RegenerateTokens(String refreshToken) ClientConnectionId:5b7b9777-1a6f-472b-b7e1-a10538a2e46f Error Number:18456,State:1,Class:14 2025-12-04 15:48:54.753 +05:30 3ccb3599-49d6-4bf5-9580-14456c55a038 ERR An error occurred while generating the PDF for IdleTime.System.IO.FileNotFoundException: IdleTime Template not found File name: 'Resources/IdleTime.rdl' at Sang.TimeMonitor.Api.Services.ReportService.GeneratePdfFromRdl(DocType docType, DataSet data, Dictionary`2 parameters, String pdfName) 2025-12-04 15:48:54.756 +05:30 3ccb3599-49d6-4bf5-9580-14456c55a038 ERR Generating IdleTime PDF Failed System.IO.FileNotFoundException: IdleTime Template not found File name: 'Resources/IdleTime.rdl' at Sang.TimeMonitor.Api.Services.ReportService.GeneratePdfFromRdl(DocType docType, DataSet data, Dictionary`2 parameters, String pdfName) at Sang.TimeMonitor.Api.Services.ReportService.GeneratePdf(ReportRequest report) at Sang.TimeMonitor.Api.Controllers.ReportController.GeneratePdf(ReportRequest report)