2025-12-03 09:34:31.951 +05:30 ff0cf08e-18de-419c-8dec-d7afa62e3d84 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.SqlTypes.SqlDateTime..ctor(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.WriteValue(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.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean asyncWrite, String method) at System.Data.SqlClient.SqlCommand.BeginExecuteReader(AsyncCallback callback, Object stateObject, CommandBehavior behavior) at System.Data.SqlClient.SqlCommand.<>c__DisplayClass130_0.b__1(CommandBehavior commandBehavior, AsyncCallback callback, Object stateObject) 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.Threading.Tasks.TaskFactory`1.FromAsync[TArg1](Func`4 beginMethod, Func`2 endMethod, TArg1 arg1, Object state) 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-03 09:34:31.961 +05:30 ff0cf08e-18de-419c-8dec-d7afa62e3d84 ERR SqlDateTime overflow. Must be between 1/1/1753 12:00:00 AM and 12/31/9999 11:59:59 PM. 2025-12-03 09:34:31.969 +05:30 ff0cf08e-18de-419c-8dec-d7afa62e3d84 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.SqlTypes.SqlDateTime..ctor(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.WriteValue(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.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean asyncWrite, String method) at System.Data.SqlClient.SqlCommand.BeginExecuteReader(AsyncCallback callback, Object stateObject, CommandBehavior behavior) at System.Data.SqlClient.SqlCommand.<>c__DisplayClass130_0.b__1(CommandBehavior commandBehavior, AsyncCallback callback, Object stateObject) 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.Threading.Tasks.TaskFactory`1.FromAsync[TArg1](Func`4 beginMethod, Func`2 endMethod, TArg1 arg1, Object state) 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) in C:\SOURCECODE\Apps\Sang.TimeMonitor.Api\Sang.TimeMonitor.Api\Repositories\JobRepository.cs:line 78 at Sang.TimeMonitor.Api.Services.JobService.<>c__DisplayClass5_0.<b__0>d.MoveNext() in C:\SOURCECODE\Apps\Sang.TimeMonitor.Api\Sang.TimeMonitor.Api\Services\JobService.cs:line 43 --- 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-03 09:34:31.970 +05:30 ff0cf08e-18de-419c-8dec-d7afa62e3d84 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.SqlTypes.SqlDateTime..ctor(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.WriteValue(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.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean asyncWrite, String method) at System.Data.SqlClient.SqlCommand.BeginExecuteReader(AsyncCallback callback, Object stateObject, CommandBehavior behavior) at System.Data.SqlClient.SqlCommand.<>c__DisplayClass130_0.b__1(CommandBehavior commandBehavior, AsyncCallback callback, Object stateObject) 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.Threading.Tasks.TaskFactory`1.FromAsync[TArg1](Func`4 beginMethod, Func`2 endMethod, TArg1 arg1, Object state) 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) in C:\SOURCECODE\Apps\Sang.TimeMonitor.Api\Sang.TimeMonitor.Api\Repositories\JobRepository.cs:line 78 at Sang.TimeMonitor.Api.Services.JobService.<>c__DisplayClass5_0.<b__0>d.MoveNext() in C:\SOURCECODE\Apps\Sang.TimeMonitor.Api\Sang.TimeMonitor.Api\Services\JobService.cs:line 43 --- 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) in C:\SOURCECODE\Apps\Sang.TimeMonitor.Api\Sang.TimeMonitor.Api\Services\JobService.cs:line 42 at Sang.TimeMonitor.Api.Controllers.JobController.GetJobSummary(JobSummaryRequest summaryRequest) in C:\SOURCECODE\Apps\Sang.TimeMonitor.Api\Sang.TimeMonitor.Api\Controllers\JobController.cs:line 75 2025-12-03 09:34:34.094 +05:30 a3728e70-df45-43e1-ae9f-7e03ed8bb777 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.SqlTypes.SqlDateTime..ctor(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.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean asyncWrite, String method) at System.Data.SqlClient.SqlCommand.BeginExecuteReader(AsyncCallback callback, Object stateObject, CommandBehavior behavior) at System.Data.SqlClient.SqlCommand.<>c__DisplayClass130_0.b__1(CommandBehavior commandBehavior, AsyncCallback callback, Object stateObject) 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.Threading.Tasks.TaskFactory`1.FromAsync[TArg1](Func`4 beginMethod, Func`2 endMethod, TArg1 arg1, Object state) 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-03 09:34:34.095 +05:30 a3728e70-df45-43e1-ae9f-7e03ed8bb777 ERR SqlDateTime overflow. Must be between 1/1/1753 12:00:00 AM and 12/31/9999 11:59:59 PM. 2025-12-03 09:34:34.096 +05:30 a3728e70-df45-43e1-ae9f-7e03ed8bb777 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.SqlTypes.SqlDateTime..ctor(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.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean asyncWrite, String method) at System.Data.SqlClient.SqlCommand.BeginExecuteReader(AsyncCallback callback, Object stateObject, CommandBehavior behavior) at System.Data.SqlClient.SqlCommand.<>c__DisplayClass130_0.b__1(CommandBehavior commandBehavior, AsyncCallback callback, Object stateObject) 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.Threading.Tasks.TaskFactory`1.FromAsync[TArg1](Func`4 beginMethod, Func`2 endMethod, TArg1 arg1, Object state) 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) in C:\SOURCECODE\Apps\Sang.TimeMonitor.Api\Sang.TimeMonitor.Api\Repositories\JobRepository.cs:line 78 at Sang.TimeMonitor.Api.Services.JobService.<>c__DisplayClass5_0.<b__0>d.MoveNext() in C:\SOURCECODE\Apps\Sang.TimeMonitor.Api\Sang.TimeMonitor.Api\Services\JobService.cs:line 43 --- 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-03 09:34:34.097 +05:30 a3728e70-df45-43e1-ae9f-7e03ed8bb777 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.SqlTypes.SqlDateTime..ctor(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.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean asyncWrite, String method) at System.Data.SqlClient.SqlCommand.BeginExecuteReader(AsyncCallback callback, Object stateObject, CommandBehavior behavior) at System.Data.SqlClient.SqlCommand.<>c__DisplayClass130_0.b__1(CommandBehavior commandBehavior, AsyncCallback callback, Object stateObject) 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.Threading.Tasks.TaskFactory`1.FromAsync[TArg1](Func`4 beginMethod, Func`2 endMethod, TArg1 arg1, Object state) 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) in C:\SOURCECODE\Apps\Sang.TimeMonitor.Api\Sang.TimeMonitor.Api\Repositories\JobRepository.cs:line 78 at Sang.TimeMonitor.Api.Services.JobService.<>c__DisplayClass5_0.<b__0>d.MoveNext() in C:\SOURCECODE\Apps\Sang.TimeMonitor.Api\Sang.TimeMonitor.Api\Services\JobService.cs:line 43 --- 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) in C:\SOURCECODE\Apps\Sang.TimeMonitor.Api\Sang.TimeMonitor.Api\Services\JobService.cs:line 42 at Sang.TimeMonitor.Api.Controllers.JobController.GetJobSummary(JobSummaryRequest summaryRequest) in C:\SOURCECODE\Apps\Sang.TimeMonitor.Api\Sang.TimeMonitor.Api\Controllers\JobController.cs:line 75 2025-12-03 09:34:34.293 +05:30 48033d7a-d3d1-4a58-9b32-e61345d92b65 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.SqlTypes.SqlDateTime..ctor(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.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean asyncWrite, String method) at System.Data.SqlClient.SqlCommand.BeginExecuteReader(AsyncCallback callback, Object stateObject, CommandBehavior behavior) at System.Data.SqlClient.SqlCommand.<>c__DisplayClass130_0.b__1(CommandBehavior commandBehavior, AsyncCallback callback, Object stateObject) 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.Threading.Tasks.TaskFactory`1.FromAsync[TArg1](Func`4 beginMethod, Func`2 endMethod, TArg1 arg1, Object state) 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-03 09:34:34.293 +05:30 48033d7a-d3d1-4a58-9b32-e61345d92b65 ERR SqlDateTime overflow. Must be between 1/1/1753 12:00:00 AM and 12/31/9999 11:59:59 PM. 2025-12-03 09:34:34.294 +05:30 48033d7a-d3d1-4a58-9b32-e61345d92b65 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.SqlTypes.SqlDateTime..ctor(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.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean asyncWrite, String method) at System.Data.SqlClient.SqlCommand.BeginExecuteReader(AsyncCallback callback, Object stateObject, CommandBehavior behavior) at System.Data.SqlClient.SqlCommand.<>c__DisplayClass130_0.b__1(CommandBehavior commandBehavior, AsyncCallback callback, Object stateObject) 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.Threading.Tasks.TaskFactory`1.FromAsync[TArg1](Func`4 beginMethod, Func`2 endMethod, TArg1 arg1, Object state) 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) in C:\SOURCECODE\Apps\Sang.TimeMonitor.Api\Sang.TimeMonitor.Api\Repositories\JobRepository.cs:line 78 at Sang.TimeMonitor.Api.Services.JobService.<>c__DisplayClass5_0.<b__0>d.MoveNext() in C:\SOURCECODE\Apps\Sang.TimeMonitor.Api\Sang.TimeMonitor.Api\Services\JobService.cs:line 43 --- 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-03 09:34:34.295 +05:30 48033d7a-d3d1-4a58-9b32-e61345d92b65 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.SqlTypes.SqlDateTime..ctor(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.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean asyncWrite, String method) at System.Data.SqlClient.SqlCommand.BeginExecuteReader(AsyncCallback callback, Object stateObject, CommandBehavior behavior) at System.Data.SqlClient.SqlCommand.<>c__DisplayClass130_0.b__1(CommandBehavior commandBehavior, AsyncCallback callback, Object stateObject) 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.Threading.Tasks.TaskFactory`1.FromAsync[TArg1](Func`4 beginMethod, Func`2 endMethod, TArg1 arg1, Object state) 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) in C:\SOURCECODE\Apps\Sang.TimeMonitor.Api\Sang.TimeMonitor.Api\Repositories\JobRepository.cs:line 78 at Sang.TimeMonitor.Api.Services.JobService.<>c__DisplayClass5_0.<b__0>d.MoveNext() in C:\SOURCECODE\Apps\Sang.TimeMonitor.Api\Sang.TimeMonitor.Api\Services\JobService.cs:line 43 --- 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) in C:\SOURCECODE\Apps\Sang.TimeMonitor.Api\Sang.TimeMonitor.Api\Services\JobService.cs:line 42 at Sang.TimeMonitor.Api.Controllers.JobController.GetJobSummary(JobSummaryRequest summaryRequest) in C:\SOURCECODE\Apps\Sang.TimeMonitor.Api\Sang.TimeMonitor.Api\Controllers\JobController.cs:line 75 2025-12-03 09:34:34.466 +05:30 2933944f-d80c-4b40-9077-8bb398c746d2 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.SqlTypes.SqlDateTime..ctor(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.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean asyncWrite, String method) at System.Data.SqlClient.SqlCommand.BeginExecuteReader(AsyncCallback callback, Object stateObject, CommandBehavior behavior) at System.Data.SqlClient.SqlCommand.<>c__DisplayClass130_0.b__1(CommandBehavior commandBehavior, AsyncCallback callback, Object stateObject) 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.Threading.Tasks.TaskFactory`1.FromAsync[TArg1](Func`4 beginMethod, Func`2 endMethod, TArg1 arg1, Object state) 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-03 09:34:34.466 +05:30 2933944f-d80c-4b40-9077-8bb398c746d2 ERR SqlDateTime overflow. Must be between 1/1/1753 12:00:00 AM and 12/31/9999 11:59:59 PM. 2025-12-03 09:34:34.467 +05:30 2933944f-d80c-4b40-9077-8bb398c746d2 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.SqlTypes.SqlDateTime..ctor(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.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean asyncWrite, String method) at System.Data.SqlClient.SqlCommand.BeginExecuteReader(AsyncCallback callback, Object stateObject, CommandBehavior behavior) at System.Data.SqlClient.SqlCommand.<>c__DisplayClass130_0.b__1(CommandBehavior commandBehavior, AsyncCallback callback, Object stateObject) 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.Threading.Tasks.TaskFactory`1.FromAsync[TArg1](Func`4 beginMethod, Func`2 endMethod, TArg1 arg1, Object state) 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) in C:\SOURCECODE\Apps\Sang.TimeMonitor.Api\Sang.TimeMonitor.Api\Repositories\JobRepository.cs:line 78 at Sang.TimeMonitor.Api.Services.JobService.<>c__DisplayClass5_0.<b__0>d.MoveNext() in C:\SOURCECODE\Apps\Sang.TimeMonitor.Api\Sang.TimeMonitor.Api\Services\JobService.cs:line 43 --- 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-03 09:34:34.468 +05:30 2933944f-d80c-4b40-9077-8bb398c746d2 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.SqlTypes.SqlDateTime..ctor(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.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean asyncWrite, String method) at System.Data.SqlClient.SqlCommand.BeginExecuteReader(AsyncCallback callback, Object stateObject, CommandBehavior behavior) at System.Data.SqlClient.SqlCommand.<>c__DisplayClass130_0.b__1(CommandBehavior commandBehavior, AsyncCallback callback, Object stateObject) 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.Threading.Tasks.TaskFactory`1.FromAsync[TArg1](Func`4 beginMethod, Func`2 endMethod, TArg1 arg1, Object state) 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) in C:\SOURCECODE\Apps\Sang.TimeMonitor.Api\Sang.TimeMonitor.Api\Repositories\JobRepository.cs:line 78 at Sang.TimeMonitor.Api.Services.JobService.<>c__DisplayClass5_0.<b__0>d.MoveNext() in C:\SOURCECODE\Apps\Sang.TimeMonitor.Api\Sang.TimeMonitor.Api\Services\JobService.cs:line 43 --- 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) in C:\SOURCECODE\Apps\Sang.TimeMonitor.Api\Sang.TimeMonitor.Api\Services\JobService.cs:line 42 at Sang.TimeMonitor.Api.Controllers.JobController.GetJobSummary(JobSummaryRequest summaryRequest) in C:\SOURCECODE\Apps\Sang.TimeMonitor.Api\Sang.TimeMonitor.Api\Controllers\JobController.cs:line 75 2025-12-03 09:44:53.995 +05:30 9c36f7fe-75cd-4615-aa38-906ced230ad0 ERR SqlDateTime overflow. Must be between 1/1/1753 12:00:00 AM and 12/31/9999 11:59:59 PM. 2025-12-03 09:44:53.995 +05:30 9c36f7fe-75cd-4615-aa38-906ced230ad0 ERR SqlDateTime overflow. Must be between 1/1/1753 12:00:00 AM and 12/31/9999 11:59:59 PM. 2025-12-03 09:44:53.998 +05:30 9c36f7fe-75cd-4615-aa38-906ced230ad0 ERR Upserting Job 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.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method) at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior) at System.Data.SqlClient.SqlCommand.ExecuteDbDataReader(CommandBehavior behavior) at System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) at System.Data.Common.DbDataAdapter.Fill(DataTable[] dataTables, Int32 startRecord, Int32 maxRecords, IDbCommand command, CommandBehavior behavior) at System.Data.Common.DbDataAdapter.Fill(DataTable dataTable) at Sang.Service.Common.CommonService.CommonEntityService.ExecuteProcedureWithResult(String procedureName, SqlParameter[] parameters) at Sang.TimeMonitor.Api.Repositories.JobRepository.UpsertJob(JobRequest request) in C:\SOURCECODE\Apps\Sang.TimeMonitor.Api\Sang.TimeMonitor.Api\Repositories\JobRepository.cs:line 136 at Sang.TimeMonitor.Api.Services.JobService.UpsertJob(JobRequest request) in C:\SOURCECODE\Apps\Sang.TimeMonitor.Api\Sang.TimeMonitor.Api\Services\JobService.cs:line 55 at Sang.TimeMonitor.Api.Controllers.JobController.UpsertJob(JobRequest request) in C:\SOURCECODE\Apps\Sang.TimeMonitor.Api\Sang.TimeMonitor.Api\Controllers\JobController.cs:line 139 2025-12-03 09:51:16.567 +05:30 fcf1b350-48f8-4b93-b73d-440f432ef155 ERR SqlDateTime overflow. Must be between 1/1/1753 12:00:00 AM and 12/31/9999 11:59:59 PM. 2025-12-03 09:51:16.568 +05:30 fcf1b350-48f8-4b93-b73d-440f432ef155 ERR SqlDateTime overflow. Must be between 1/1/1753 12:00:00 AM and 12/31/9999 11:59:59 PM. 2025-12-03 09:51:16.570 +05:30 fcf1b350-48f8-4b93-b73d-440f432ef155 ERR Upserting Job 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.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method) at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior) at System.Data.SqlClient.SqlCommand.ExecuteDbDataReader(CommandBehavior behavior) at System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) at System.Data.Common.DbDataAdapter.Fill(DataTable[] dataTables, Int32 startRecord, Int32 maxRecords, IDbCommand command, CommandBehavior behavior) at System.Data.Common.DbDataAdapter.Fill(DataTable dataTable) at Sang.Service.Common.CommonService.CommonEntityService.ExecuteProcedureWithResult(String procedureName, SqlParameter[] parameters) at Sang.TimeMonitor.Api.Repositories.JobRepository.UpsertJob(JobRequest request) in C:\SOURCECODE\Apps\Sang.TimeMonitor.Api\Sang.TimeMonitor.Api\Repositories\JobRepository.cs:line 136 at Sang.TimeMonitor.Api.Services.JobService.UpsertJob(JobRequest request) in C:\SOURCECODE\Apps\Sang.TimeMonitor.Api\Sang.TimeMonitor.Api\Services\JobService.cs:line 55 at Sang.TimeMonitor.Api.Controllers.JobController.UpsertJob(JobRequest request) in C:\SOURCECODE\Apps\Sang.TimeMonitor.Api\Sang.TimeMonitor.Api\Controllers\JobController.cs:line 139 2025-12-03 09:54:18.281 +05:30 3038f68b-c05b-4ccc-8067-b35f0a2a923e ERR SqlDateTime overflow. Must be between 1/1/1753 12:00:00 AM and 12/31/9999 11:59:59 PM. 2025-12-03 09:54:18.282 +05:30 3038f68b-c05b-4ccc-8067-b35f0a2a923e ERR SqlDateTime overflow. Must be between 1/1/1753 12:00:00 AM and 12/31/9999 11:59:59 PM. 2025-12-03 09:54:18.283 +05:30 3038f68b-c05b-4ccc-8067-b35f0a2a923e ERR Upserting Job 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.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method) at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior) at System.Data.SqlClient.SqlCommand.ExecuteDbDataReader(CommandBehavior behavior) at System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) at System.Data.Common.DbDataAdapter.Fill(DataTable[] dataTables, Int32 startRecord, Int32 maxRecords, IDbCommand command, CommandBehavior behavior) at System.Data.Common.DbDataAdapter.Fill(DataTable dataTable) at Sang.Service.Common.CommonService.CommonEntityService.ExecuteProcedureWithResult(String procedureName, SqlParameter[] parameters) at Sang.TimeMonitor.Api.Repositories.JobRepository.UpsertJob(JobRequest request) in C:\SOURCECODE\Apps\Sang.TimeMonitor.Api\Sang.TimeMonitor.Api\Repositories\JobRepository.cs:line 136 at Sang.TimeMonitor.Api.Services.JobService.UpsertJob(JobRequest request) in C:\SOURCECODE\Apps\Sang.TimeMonitor.Api\Sang.TimeMonitor.Api\Services\JobService.cs:line 55 at Sang.TimeMonitor.Api.Controllers.JobController.UpsertJob(JobRequest request) in C:\SOURCECODE\Apps\Sang.TimeMonitor.Api\Sang.TimeMonitor.Api\Controllers\JobController.cs:line 139 2025-12-03 10:05:23.280 +05:30 7744c22f-339b-4a33-a9cc-f23c3b55633c ERR Database error occurred: The datepart day is not supported by date function dateadd for data type time. 2025-12-03 10:08:02.657 +05:30 03494e78-d776-48bb-8257-ca16c8f0d41a ERR Database error occurred: The datepart day is not supported by date function dateadd for data type time. 2025-12-03 10:08:58.456 +05:30 03e957c0-e63d-4243-84ba-25800e3e56b0 ERR Database error occurred: The datepart day is not supported by date function dateadd for data type time. 2025-12-03 10:17:25.537 +05:30 c5e6e307-5889-4a85-91c6-4f5811dfdcce ERR Invalid column name 'Machine_Name'. 2025-12-03 10:17:25.538 +05:30 c5e6e307-5889-4a85-91c6-4f5811dfdcce ERR Invalid column name 'Machine_Name'. 2025-12-03 10:17:25.546 +05:30 c5e6e307-5889-4a85-91c6-4f5811dfdcce ERR SQL Exception occurred System.Data.SqlClient.SqlException (0x80131904): Invalid column name 'Machine_Name'. at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) at System.Data.SqlClient.SqlDataReader.TryConsumeMetaData() at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString) 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.ExecuteReader(CommandBehavior behavior) at System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet) at Sang.Service.Common.CommonService.CommonEntityService.ExecuteAndFetchDataset(String procedureName, SqlParameter[] parameters, Boolean useExtendedTimeout) at Sang.TimeMonitor.Api.Repositories.ReportRepository.GetReport(ReportRequest report) in C:\SOURCECODE\Apps\Sang.TimeMonitor.Api\Sang.TimeMonitor.Api\Repositories\ReportRepository.cs:line 42 at Sang.TimeMonitor.Api.Services.ReportService.GetReport(ReportRequest report) in C:\SOURCECODE\Apps\Sang.TimeMonitor.Api\Sang.TimeMonitor.Api\Services\ReportService.cs:line 29 at Sang.TimeMonitor.Api.Controllers.ReportController.GetReport(ReportRequest report) in C:\SOURCECODE\Apps\Sang.TimeMonitor.Api\Sang.TimeMonitor.Api\Controllers\ReportController.cs:line 43 ClientConnectionId:72519ed1-6011-44f6-9802-49b37ae1b731 Error Number:207,State:1,Class:16 2025-12-03 11:35:46.835 +05:30 0e7ddf20-a182-4609-a4ee-b810c875df9d ERR Login failed for user ''. 2025-12-03 11:35:46.850 +05:30 0e7ddf20-a182-4609-a4ee-b810c875df9d 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) in C:\SOURCECODE\Apps\Sang.TimeMonitor.Api\Sang.TimeMonitor.Api\Controllers\LoginController.cs:line 155 ClientConnectionId:9d57e53b-7407-49e8-a8fc-3a421a33880c Error Number:18456,State:1,Class:14 2025-12-03 11:52:38.551 +05:30 1273586d-cfba-4e14-9029-0a122e00a8b7 ERR String or binary data would be truncated in table 'tempdb.dbo.#BC4CD338', column 'IdleRemarks'. Truncated value: 'Time sheet remarks adddedTime sheet remarks adddedTime sheet remarks adddedTime sheet remarks addded'. The data for table-valued parameter "@t_type_TimeSheetDetails" doesn't conform to the table type of the parameter. SQL Server error is: 2628, state: 1 The statement has been terminated. 2025-12-03 11:52:38.552 +05:30 1273586d-cfba-4e14-9029-0a122e00a8b7 ERR String or binary data would be truncated in table 'tempdb.dbo.#BC4CD338', column 'IdleRemarks'. Truncated value: 'Time sheet remarks adddedTime sheet remarks adddedTime sheet remarks adddedTime sheet remarks addded'. The data for table-valued parameter "@t_type_TimeSheetDetails" doesn't conform to the table type of the parameter. SQL Server error is: 2628, state: 1 The statement has been terminated. 2025-12-03 11:52:38.560 +05:30 1273586d-cfba-4e14-9029-0a122e00a8b7 ERR SQL Exception occurred System.Data.SqlClient.SqlException (0x80131904): String or binary data would be truncated in table 'tempdb.dbo.#BC4CD338', column 'IdleRemarks'. Truncated value: 'Time sheet remarks adddedTime sheet remarks adddedTime sheet remarks adddedTime sheet remarks addded'. The data for table-valued parameter "@t_type_TimeSheetDetails" doesn't conform to the table type of the parameter. SQL Server error is: 2628, state: 1 The statement has been terminated. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) at System.Data.SqlClient.SqlDataReader.TryConsumeMetaData() at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString) 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.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method) at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior) at System.Data.SqlClient.SqlCommand.ExecuteDbDataReader(CommandBehavior behavior) at System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) at System.Data.Common.DbDataAdapter.Fill(DataTable[] dataTables, Int32 startRecord, Int32 maxRecords, IDbCommand command, CommandBehavior behavior) at System.Data.Common.DbDataAdapter.Fill(DataTable dataTable) at Sang.Service.Common.CommonService.CommonEntityService.ExecuteProcedureWithResult(String procedureName, SqlParameter[] parameters) at Sang.TimeMonitor.Api.Repositories.TimeSheetRepository.UpsertTimeSheet(TimeSheetRequest request) in C:\SOURCECODE\Apps\Sang.TimeMonitor.Api\Sang.TimeMonitor.Api\Repositories\TimeSheetRepository.cs:line 86 at Sang.TimeMonitor.Api.Services.TimeSheetService.UpsertTimeSheet(TimeSheetRequest request) in C:\SOURCECODE\Apps\Sang.TimeMonitor.Api\Sang.TimeMonitor.Api\Services\TimeSheetService.cs:line 21 at Sang.TimeMonitor.Api.Controllers.TimeSheetController.UpsertTimeSheet(TimeSheetRequest request) in C:\SOURCECODE\Apps\Sang.TimeMonitor.Api\Sang.TimeMonitor.Api\Controllers\TimeSheetController.cs:line 78 ClientConnectionId:98adec24-2657-4bc2-bded-30d43c195bc6 Error Number:2628,State:1,Class:16 2025-12-03 11:58:57.272 +05:30 360619aa-e063-4852-8dc5-4b072b94d45e ERR String or binary data would be truncated in table 'tempdb.dbo.#BC4CD338', column 'IdleRemarks'. Truncated value: 'The oldest classical British and Latin writings had little or no space between words and could be wr'. The data for table-valued parameter "@t_type_TimeSheetDetails" doesn't conform to the table type of the parameter. SQL Server error is: 2628, state: 1 The statement has been terminated. 2025-12-03 11:58:57.273 +05:30 360619aa-e063-4852-8dc5-4b072b94d45e ERR String or binary data would be truncated in table 'tempdb.dbo.#BC4CD338', column 'IdleRemarks'. Truncated value: 'The oldest classical British and Latin writings had little or no space between words and could be wr'. The data for table-valued parameter "@t_type_TimeSheetDetails" doesn't conform to the table type of the parameter. SQL Server error is: 2628, state: 1 The statement has been terminated. 2025-12-03 11:58:57.277 +05:30 360619aa-e063-4852-8dc5-4b072b94d45e ERR SQL Exception occurred System.Data.SqlClient.SqlException (0x80131904): String or binary data would be truncated in table 'tempdb.dbo.#BC4CD338', column 'IdleRemarks'. Truncated value: 'The oldest classical British and Latin writings had little or no space between words and could be wr'. The data for table-valued parameter "@t_type_TimeSheetDetails" doesn't conform to the table type of the parameter. SQL Server error is: 2628, state: 1 The statement has been terminated. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) at System.Data.SqlClient.SqlDataReader.TryConsumeMetaData() at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString) 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.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method) at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior) at System.Data.SqlClient.SqlCommand.ExecuteDbDataReader(CommandBehavior behavior) at System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) at System.Data.Common.DbDataAdapter.Fill(DataTable[] dataTables, Int32 startRecord, Int32 maxRecords, IDbCommand command, CommandBehavior behavior) at System.Data.Common.DbDataAdapter.Fill(DataTable dataTable) at Sang.Service.Common.CommonService.CommonEntityService.ExecuteProcedureWithResult(String procedureName, SqlParameter[] parameters) at Sang.TimeMonitor.Api.Repositories.TimeSheetRepository.UpsertTimeSheet(TimeSheetRequest request) in C:\SOURCECODE\Apps\Sang.TimeMonitor.Api\Sang.TimeMonitor.Api\Repositories\TimeSheetRepository.cs:line 86 at Sang.TimeMonitor.Api.Services.TimeSheetService.UpsertTimeSheet(TimeSheetRequest request) in C:\SOURCECODE\Apps\Sang.TimeMonitor.Api\Sang.TimeMonitor.Api\Services\TimeSheetService.cs:line 21 at Sang.TimeMonitor.Api.Controllers.TimeSheetController.UpsertTimeSheet(TimeSheetRequest request) in C:\SOURCECODE\Apps\Sang.TimeMonitor.Api\Sang.TimeMonitor.Api\Controllers\TimeSheetController.cs:line 78 ClientConnectionId:98adec24-2657-4bc2-bded-30d43c195bc6 Error Number:2628,State:1,Class:16 2025-12-03 12:02:25.827 +05:30 95d98203-c8f9-4319-b24d-2cf566441140 ERR String or binary data would be truncated in table 'tempdb.dbo.#BC4CD338', column 'IdleRemarks'. Truncated value: 'The oldest classical British and Latin writings had little or no space between words and could be wr'. The data for table-valued parameter "@t_type_TimeSheetDetails" doesn't conform to the table type of the parameter. SQL Server error is: 2628, state: 1 The statement has been terminated. 2025-12-03 12:02:25.828 +05:30 95d98203-c8f9-4319-b24d-2cf566441140 ERR String or binary data would be truncated in table 'tempdb.dbo.#BC4CD338', column 'IdleRemarks'. Truncated value: 'The oldest classical British and Latin writings had little or no space between words and could be wr'. The data for table-valued parameter "@t_type_TimeSheetDetails" doesn't conform to the table type of the parameter. SQL Server error is: 2628, state: 1 The statement has been terminated. 2025-12-03 12:02:25.834 +05:30 95d98203-c8f9-4319-b24d-2cf566441140 ERR SQL Exception occurred System.Data.SqlClient.SqlException (0x80131904): String or binary data would be truncated in table 'tempdb.dbo.#BC4CD338', column 'IdleRemarks'. Truncated value: 'The oldest classical British and Latin writings had little or no space between words and could be wr'. The data for table-valued parameter "@t_type_TimeSheetDetails" doesn't conform to the table type of the parameter. SQL Server error is: 2628, state: 1 The statement has been terminated. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) at System.Data.SqlClient.SqlDataReader.TryConsumeMetaData() at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString) 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.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method) at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior) at System.Data.SqlClient.SqlCommand.ExecuteDbDataReader(CommandBehavior behavior) at System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) at System.Data.Common.DbDataAdapter.Fill(DataTable[] dataTables, Int32 startRecord, Int32 maxRecords, IDbCommand command, CommandBehavior behavior) at System.Data.Common.DbDataAdapter.Fill(DataTable dataTable) at Sang.Service.Common.CommonService.CommonEntityService.ExecuteProcedureWithResult(String procedureName, SqlParameter[] parameters) at Sang.TimeMonitor.Api.Repositories.TimeSheetRepository.UpsertTimeSheet(TimeSheetRequest request) in C:\SOURCECODE\Apps\Sang.TimeMonitor.Api\Sang.TimeMonitor.Api\Repositories\TimeSheetRepository.cs:line 86 at Sang.TimeMonitor.Api.Services.TimeSheetService.UpsertTimeSheet(TimeSheetRequest request) in C:\SOURCECODE\Apps\Sang.TimeMonitor.Api\Sang.TimeMonitor.Api\Services\TimeSheetService.cs:line 21 at Sang.TimeMonitor.Api.Controllers.TimeSheetController.UpsertTimeSheet(TimeSheetRequest request) in C:\SOURCECODE\Apps\Sang.TimeMonitor.Api\Sang.TimeMonitor.Api\Controllers\TimeSheetController.cs:line 78 ClientConnectionId:98adec24-2657-4bc2-bded-30d43c195bc6 Error Number:2628,State:1,Class:16 2025-12-03 12:03:03.192 +05:30 b6566368-5ada-45bc-bff2-8ffe333cb34d ERR String or binary data would be truncated in table 'tempdb.dbo.#BC4CD338', column 'IdleRemarks'. Truncated value: 'The oldest classical British and Latin writings had little or no space between words and could be wr'. The data for table-valued parameter "@t_type_TimeSheetDetails" doesn't conform to the table type of the parameter. SQL Server error is: 2628, state: 1 The statement has been terminated. 2025-12-03 12:03:03.194 +05:30 b6566368-5ada-45bc-bff2-8ffe333cb34d ERR String or binary data would be truncated in table 'tempdb.dbo.#BC4CD338', column 'IdleRemarks'. Truncated value: 'The oldest classical British and Latin writings had little or no space between words and could be wr'. The data for table-valued parameter "@t_type_TimeSheetDetails" doesn't conform to the table type of the parameter. SQL Server error is: 2628, state: 1 The statement has been terminated. 2025-12-03 12:03:03.202 +05:30 b6566368-5ada-45bc-bff2-8ffe333cb34d ERR SQL Exception occurred System.Data.SqlClient.SqlException (0x80131904): String or binary data would be truncated in table 'tempdb.dbo.#BC4CD338', column 'IdleRemarks'. Truncated value: 'The oldest classical British and Latin writings had little or no space between words and could be wr'. The data for table-valued parameter "@t_type_TimeSheetDetails" doesn't conform to the table type of the parameter. SQL Server error is: 2628, state: 1 The statement has been terminated. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) at System.Data.SqlClient.SqlDataReader.TryConsumeMetaData() at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString) 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.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method) at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior) at System.Data.SqlClient.SqlCommand.ExecuteDbDataReader(CommandBehavior behavior) at System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) at System.Data.Common.DbDataAdapter.Fill(DataTable[] dataTables, Int32 startRecord, Int32 maxRecords, IDbCommand command, CommandBehavior behavior) at System.Data.Common.DbDataAdapter.Fill(DataTable dataTable) at Sang.Service.Common.CommonService.CommonEntityService.ExecuteProcedureWithResult(String procedureName, SqlParameter[] parameters) at Sang.TimeMonitor.Api.Repositories.TimeSheetRepository.UpsertTimeSheet(TimeSheetRequest request) in C:\SOURCECODE\Apps\Sang.TimeMonitor.Api\Sang.TimeMonitor.Api\Repositories\TimeSheetRepository.cs:line 86 at Sang.TimeMonitor.Api.Services.TimeSheetService.UpsertTimeSheet(TimeSheetRequest request) in C:\SOURCECODE\Apps\Sang.TimeMonitor.Api\Sang.TimeMonitor.Api\Services\TimeSheetService.cs:line 21 at Sang.TimeMonitor.Api.Controllers.TimeSheetController.UpsertTimeSheet(TimeSheetRequest request) in C:\SOURCECODE\Apps\Sang.TimeMonitor.Api\Sang.TimeMonitor.Api\Controllers\TimeSheetController.cs:line 78 ClientConnectionId:98adec24-2657-4bc2-bded-30d43c195bc6 Error Number:2628,State:1,Class:16 2025-12-03 12:27:14.603 +05:30 96069ffd-9066-4693-8520-e79fc60ae695 ERR String or binary data would be truncated in table 'tempdb.dbo.#BC4CD338', column 'IdleRemarks'. Truncated value: 'The oldest classical British and Latin writings had little or no space between words and could be wr'. The data for table-valued parameter "@t_type_TimeSheetDetails" doesn't conform to the table type of the parameter. SQL Server error is: 2628, state: 1 The statement has been terminated. 2025-12-03 12:27:14.603 +05:30 96069ffd-9066-4693-8520-e79fc60ae695 ERR String or binary data would be truncated in table 'tempdb.dbo.#BC4CD338', column 'IdleRemarks'. Truncated value: 'The oldest classical British and Latin writings had little or no space between words and could be wr'. The data for table-valued parameter "@t_type_TimeSheetDetails" doesn't conform to the table type of the parameter. SQL Server error is: 2628, state: 1 The statement has been terminated. 2025-12-03 12:27:14.606 +05:30 96069ffd-9066-4693-8520-e79fc60ae695 ERR SQL Exception occurred System.Data.SqlClient.SqlException (0x80131904): String or binary data would be truncated in table 'tempdb.dbo.#BC4CD338', column 'IdleRemarks'. Truncated value: 'The oldest classical British and Latin writings had little or no space between words and could be wr'. The data for table-valued parameter "@t_type_TimeSheetDetails" doesn't conform to the table type of the parameter. SQL Server error is: 2628, state: 1 The statement has been terminated. at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) at System.Data.SqlClient.SqlDataReader.TryConsumeMetaData() at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString) 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.ExecuteReader(CommandBehavior behavior) at System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) at System.Data.Common.DbDataAdapter.Fill(DataTable[] dataTables, Int32 startRecord, Int32 maxRecords, IDbCommand command, CommandBehavior behavior) at System.Data.Common.DbDataAdapter.Fill(DataTable dataTable) at Sang.Service.Common.CommonService.CommonEntityService.ExecuteProcedureWithResult(String procedureName, SqlParameter[] parameters) at Sang.TimeMonitor.Api.Repositories.TimeSheetRepository.UpsertTimeSheet(TimeSheetRequest request) in C:\SOURCECODE\Apps\Sang.TimeMonitor.Api\Sang.TimeMonitor.Api\Repositories\TimeSheetRepository.cs:line 86 at Sang.TimeMonitor.Api.Services.TimeSheetService.UpsertTimeSheet(TimeSheetRequest request) in C:\SOURCECODE\Apps\Sang.TimeMonitor.Api\Sang.TimeMonitor.Api\Services\TimeSheetService.cs:line 21 at Sang.TimeMonitor.Api.Controllers.TimeSheetController.UpsertTimeSheet(TimeSheetRequest request) in C:\SOURCECODE\Apps\Sang.TimeMonitor.Api\Sang.TimeMonitor.Api\Controllers\TimeSheetController.cs:line 78 ClientConnectionId:796a0f2b-f2f0-47e1-91f1-5c0288ab0125 Error Number:2628,State:1,Class:16 2025-12-03 13:45:43.360 +05:30 ad59143e-a8f3-4c92-821d-72b59de04908 ERR Login failed for user ''. 2025-12-03 13:45:43.382 +05:30 ad59143e-a8f3-4c92-821d-72b59de04908 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) in C:\SOURCECODE\Apps\Sang.TimeMonitor.Api\Sang.TimeMonitor.Api\Controllers\LoginController.cs:line 155 ClientConnectionId:5cf18f90-cd29-48a8-9e65-38ced0bb9def Error Number:18456,State:1,Class:14 2025-12-03 14:21:05.568 +05:30 9980c8c7-fd5c-4626-8e47-09a24c4632c6 ERR Invalid column name 'sEstimatedTime'. 2025-12-03 14:21:05.576 +05:30 9980c8c7-fd5c-4626-8e47-09a24c4632c6 ERR Invalid column name 'sEstimatedTime'. 2025-12-03 14:21:05.584 +05:30 9980c8c7-fd5c-4626-8e47-09a24c4632c6 ERR SQL Exception occurred System.Data.SqlClient.SqlException (0x80131904): Invalid column name 'sEstimatedTime'. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) at System.Data.SqlClient.SqlDataReader.TryConsumeMetaData() at System.Data.SqlClient.SqlDataReader.get_MetaData() at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString) 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.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean asyncWrite, String method) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method) at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior) at System.Data.SqlClient.SqlCommand.ExecuteDbDataReader(CommandBehavior behavior) at System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) at System.Data.Common.DbDataAdapter.Fill(DataTable[] dataTables, Int32 startRecord, Int32 maxRecords, IDbCommand command, CommandBehavior behavior) at System.Data.Common.DbDataAdapter.Fill(DataTable dataTable) at Sang.Service.Common.CommonService.CommonEntityService.ExecuteProcedureWithResult(String procedureName, SqlParameter[] parameters) at Sang.TimeMonitor.Api.Repositories.JobRepository.UpdateJobLink(JobLinkRequest request) in C:\SOURCECODE\Apps\Sang.TimeMonitor.Api\Sang.TimeMonitor.Api\Repositories\JobRepository.cs:line 180 at Sang.TimeMonitor.Api.Services.JobService.UpdateJobLink(JobLinkRequest request) in C:\SOURCECODE\Apps\Sang.TimeMonitor.Api\Sang.TimeMonitor.Api\Services\JobService.cs:line 60 at Sang.TimeMonitor.Api.Controllers.JobController.UpdateJobLink(JobLinkRequest request) in C:\SOURCECODE\Apps\Sang.TimeMonitor.Api\Sang.TimeMonitor.Api\Controllers\JobController.cs:line 234 ClientConnectionId:dc8a6dab-0674-4a37-8344-3093f4214f4d Error Number:207,State:1,Class:16 2025-12-03 14:57:57.667 +05:30 a5af777c-c6e4-420f-8695-3d56de5f39ab ERR Login failed for user ''. 2025-12-03 14:57:57.688 +05:30 a5af777c-c6e4-420f-8695-3d56de5f39ab 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) in C:\SOURCECODE\Apps\Sang.TimeMonitor.Api\Sang.TimeMonitor.Api\Controllers\LoginController.cs:line 155 ClientConnectionId:426a89f0-959c-47a1-b7e8-24e0ed78ed8f Error Number:18456,State:1,Class:14 2025-12-03 15:20:55.890 +05:30 20feee7e-6e6a-4782-afd9-220d916e5977 ERR Error converting data type numeric to numeric. 2025-12-03 15:20:55.891 +05:30 20feee7e-6e6a-4782-afd9-220d916e5977 ERR Error converting data type numeric to numeric. 2025-12-03 15:20:55.898 +05:30 20feee7e-6e6a-4782-afd9-220d916e5977 ERR SQL Exception occurred System.Data.SqlClient.SqlException (0x80131904): Error converting data type numeric to numeric. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) at System.Data.SqlClient.SqlDataReader.TryConsumeMetaData() at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString) 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.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method) at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior) at System.Data.SqlClient.SqlCommand.ExecuteDbDataReader(CommandBehavior behavior) at System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) at System.Data.Common.DbDataAdapter.Fill(DataTable[] dataTables, Int32 startRecord, Int32 maxRecords, IDbCommand command, CommandBehavior behavior) at System.Data.Common.DbDataAdapter.Fill(DataTable dataTable) at Sang.Service.Common.CommonService.CommonEntityService.ExecuteProcedureWithResult(String procedureName, SqlParameter[] parameters) at Sang.TimeMonitor.Api.Repositories.TimeSheetRepository.UpsertTimeSheet(TimeSheetRequest request) in C:\SOURCECODE\Apps\Sang.TimeMonitor.Api\Sang.TimeMonitor.Api\Repositories\TimeSheetRepository.cs:line 86 at Sang.TimeMonitor.Api.Services.TimeSheetService.UpsertTimeSheet(TimeSheetRequest request) in C:\SOURCECODE\Apps\Sang.TimeMonitor.Api\Sang.TimeMonitor.Api\Services\TimeSheetService.cs:line 21 at Sang.TimeMonitor.Api.Controllers.TimeSheetController.UpsertTimeSheet(TimeSheetRequest request) in C:\SOURCECODE\Apps\Sang.TimeMonitor.Api\Sang.TimeMonitor.Api\Controllers\TimeSheetController.cs:line 78 ClientConnectionId:ce7b43a0-cbdb-49c2-a6f0-de83e28363fb Error Number:8114,State:1,Class:16 2025-12-03 16:52:10.598 +05:30 289c889f-a4b1-40b2-bd45-50f0bbd0bd52 ERR Login failed for user ''. 2025-12-03 16:52:10.615 +05:30 289c889f-a4b1-40b2-bd45-50f0bbd0bd52 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:1da370d4-6b3d-4d5e-9aa7-333e05caed95 Error Number:18456,State:1,Class:14