2024-05-02 09:21:40.836 +05:30 cbf30620-f32a-4773-ba33-7f2424b92b58 ERR Token Regeneration failed Microsoft.IdentityModel.Tokens.SecurityTokenExpiredException: Refresh token has expired at Sang.Security.WebApi.Validators.TokenValidator.ValidateToken(String token, String TokenKey) in D:\SOURCECODE\Sang.WebApi\Sang.Security.WebApi\Validators\TokenValidator.cs:line 38 at Sang.Security.WebApi.Authentication.TokenService.RefreshToken(String refershToken) in D:\SOURCECODE\Sang.WebApi\Sang.Security.WebApi\Authentication\TokenService.cs:line 39 at Sang.Security.WebApi.Controllers.SecurityController.RegenerateTokens(String refershToken) in D:\SOURCECODE\Sang.WebApi\Sang.Security.WebApi\Controllers\SecurityController.cs:line 39 2024-05-02 09:21:40.970 +05:30 d6429438-dad6-4524-8434-9d13fdc4cb54 ERR Token Regeneration failed Microsoft.IdentityModel.Tokens.SecurityTokenExpiredException: Refresh token has expired at Sang.Security.WebApi.Validators.TokenValidator.ValidateToken(String token, String TokenKey) in D:\SOURCECODE\Sang.WebApi\Sang.Security.WebApi\Validators\TokenValidator.cs:line 38 at Sang.Security.WebApi.Authentication.TokenService.RefreshToken(String refershToken) in D:\SOURCECODE\Sang.WebApi\Sang.Security.WebApi\Authentication\TokenService.cs:line 39 at Sang.Security.WebApi.Controllers.SecurityController.RegenerateTokens(String refershToken) in D:\SOURCECODE\Sang.WebApi\Sang.Security.WebApi\Controllers\SecurityController.cs:line 39 2024-05-02 09:23:40.284 +05:30 e3c7f932-f79b-44b2-a8a7-5ffcb62588ad ERR Unclosed quotation mark after the character string ' and isnull(istatus,0)=0 order by sName'. Incorrect syntax near ' and isnull(istatus,0)=0 order by sName'. 2024-05-02 09:23:40.287 +05:30 e3c7f932-f79b-44b2-a8a7-5ffcb62588ad ERR Unclosed quotation mark after the character string ' and isnull(istatus,0)=0 order by sName'. Incorrect syntax near ' and isnull(istatus,0)=0 order by sName'. 2024-05-02 09:23:40.288 +05:30 e3c7f932-f79b-44b2-a8a7-5ffcb62588ad ERR Database connection error: Unclosed quotation mark after the character string ' and isnull(istatus,0)=0 order by sName'. Incorrect syntax near ' and isnull(istatus,0)=0 order by sName'. 2024-05-02 09:23:40.296 +05:30 e3c7f932-f79b-44b2-a8a7-5ffcb62588ad ERR Getting Master Data for Master failed System.Exception: Database connection error: Unclosed quotation mark after the character string ' and isnull(istatus,0)=0 order by sName'. Incorrect syntax near ' and isnull(istatus,0)=0 order by sName'. ---> System.Data.SqlClient.SqlException (0x80131904): Unclosed quotation mark after the character string ' and isnull(istatus,0)=0 order by sName'. Incorrect syntax near ' and isnull(istatus,0)=0 order by sName'. 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.Security.WebApi.CommonService.CommonEntityService.ExecuteAndFetchDataTable(SqlConnection connection, SqlTransaction transaction, String procedureName, SqlParameter[] parameters) in D:\SOURCECODE\Sang.WebApi\Sang.Security.WebApi\CommonService\CommonEntityService.cs:line 186 at Sang.Security.WebApi.Repositories.RoleRepository.<>c__DisplayClass14_0.<b__0>d.MoveNext() in D:\SOURCECODE\Sang.WebApi\Sang.Security.WebApi\Repositories\RoleRepository.cs:line 267 --- End of stack trace from previous location --- at Sang.Security.WebApi.CommonService.DbTransactionService.ExecuteTransactionAsync(Func`3 transactionAction) in D:\SOURCECODE\Sang.WebApi\Sang.Security.WebApi\CommonService\DbTransactionService.cs:line 31 ClientConnectionId:b9eb8b20-48dd-4218-a16d-812e41172237 Error Number:105,State:1,Class:15 --- End of inner exception stack trace --- at Sang.Security.WebApi.CommonService.DbTransactionService.ExecuteTransactionAsync(Func`3 transactionAction) in D:\SOURCECODE\Sang.WebApi\Sang.Security.WebApi\CommonService\DbTransactionService.cs:line 45 at Sang.Security.WebApi.Repositories.RoleRepository.GetMasterData(Int32 masterId, String condition, Int32 typeId) in D:\SOURCECODE\Sang.WebApi\Sang.Security.WebApi\Repositories\RoleRepository.cs:line 258 at Sang.Security.WebApi.Services.RoleService.GetMasterData(Int32 masterId, String condition, Int32 typeId) in D:\SOURCECODE\Sang.WebApi\Sang.Security.WebApi\Services\RoleService.cs:line 44 at Sang.Security.WebApi.Controllers.RoleController.GetMasterData(Int32 masterId, Int32 typeId, String searchCondition) in D:\SOURCECODE\Sang.WebApi\Sang.Security.WebApi\Controllers\RoleController.cs:line 179 2024-05-02 09:23:41.641 +05:30 80ff329e-884d-43e2-bd9a-a6df61763b4d ERR Unclosed quotation mark after the character string ' and isnull(istatus,0)=0 order by sName'. Incorrect syntax near ' and isnull(istatus,0)=0 order by sName'. 2024-05-02 09:23:41.642 +05:30 80ff329e-884d-43e2-bd9a-a6df61763b4d ERR Unclosed quotation mark after the character string ' and isnull(istatus,0)=0 order by sName'. Incorrect syntax near ' and isnull(istatus,0)=0 order by sName'. 2024-05-02 09:23:41.643 +05:30 80ff329e-884d-43e2-bd9a-a6df61763b4d ERR Database connection error: Unclosed quotation mark after the character string ' and isnull(istatus,0)=0 order by sName'. Incorrect syntax near ' and isnull(istatus,0)=0 order by sName'. 2024-05-02 09:23:41.645 +05:30 80ff329e-884d-43e2-bd9a-a6df61763b4d ERR Getting Master Data for Master failed System.Exception: Database connection error: Unclosed quotation mark after the character string ' and isnull(istatus,0)=0 order by sName'. Incorrect syntax near ' and isnull(istatus,0)=0 order by sName'. ---> System.Data.SqlClient.SqlException (0x80131904): Unclosed quotation mark after the character string ' and isnull(istatus,0)=0 order by sName'. Incorrect syntax near ' and isnull(istatus,0)=0 order by sName'. 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.Security.WebApi.CommonService.CommonEntityService.ExecuteAndFetchDataTable(SqlConnection connection, SqlTransaction transaction, String procedureName, SqlParameter[] parameters) in D:\SOURCECODE\Sang.WebApi\Sang.Security.WebApi\CommonService\CommonEntityService.cs:line 186 at Sang.Security.WebApi.Repositories.RoleRepository.<>c__DisplayClass14_0.<b__0>d.MoveNext() in D:\SOURCECODE\Sang.WebApi\Sang.Security.WebApi\Repositories\RoleRepository.cs:line 267 --- End of stack trace from previous location --- at Sang.Security.WebApi.CommonService.DbTransactionService.ExecuteTransactionAsync(Func`3 transactionAction) in D:\SOURCECODE\Sang.WebApi\Sang.Security.WebApi\CommonService\DbTransactionService.cs:line 31 ClientConnectionId:b9eb8b20-48dd-4218-a16d-812e41172237 Error Number:105,State:1,Class:15 --- End of inner exception stack trace --- at Sang.Security.WebApi.CommonService.DbTransactionService.ExecuteTransactionAsync(Func`3 transactionAction) in D:\SOURCECODE\Sang.WebApi\Sang.Security.WebApi\CommonService\DbTransactionService.cs:line 45 at Sang.Security.WebApi.Repositories.RoleRepository.GetMasterData(Int32 masterId, String condition, Int32 typeId) in D:\SOURCECODE\Sang.WebApi\Sang.Security.WebApi\Repositories\RoleRepository.cs:line 258 at Sang.Security.WebApi.Services.RoleService.GetMasterData(Int32 masterId, String condition, Int32 typeId) in D:\SOURCECODE\Sang.WebApi\Sang.Security.WebApi\Services\RoleService.cs:line 44 at Sang.Security.WebApi.Controllers.RoleController.GetMasterData(Int32 masterId, Int32 typeId, String searchCondition) in D:\SOURCECODE\Sang.WebApi\Sang.Security.WebApi\Controllers\RoleController.cs:line 179 2024-05-02 09:23:43.307 +05:30 b7c650a2-c386-4cd0-a648-bc16c5aee53a ERR Unclosed quotation mark after the character string ' and isnull(istatus,0)=0 order by sName'. Incorrect syntax near ' and isnull(istatus,0)=0 order by sName'. 2024-05-02 09:23:43.308 +05:30 b7c650a2-c386-4cd0-a648-bc16c5aee53a ERR Unclosed quotation mark after the character string ' and isnull(istatus,0)=0 order by sName'. Incorrect syntax near ' and isnull(istatus,0)=0 order by sName'. 2024-05-02 09:23:43.308 +05:30 b7c650a2-c386-4cd0-a648-bc16c5aee53a ERR Database connection error: Unclosed quotation mark after the character string ' and isnull(istatus,0)=0 order by sName'. Incorrect syntax near ' and isnull(istatus,0)=0 order by sName'. 2024-05-02 09:23:43.311 +05:30 b7c650a2-c386-4cd0-a648-bc16c5aee53a ERR Getting Master Data for Master failed System.Exception: Database connection error: Unclosed quotation mark after the character string ' and isnull(istatus,0)=0 order by sName'. Incorrect syntax near ' and isnull(istatus,0)=0 order by sName'. ---> System.Data.SqlClient.SqlException (0x80131904): Unclosed quotation mark after the character string ' and isnull(istatus,0)=0 order by sName'. Incorrect syntax near ' and isnull(istatus,0)=0 order by sName'. 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.Security.WebApi.CommonService.CommonEntityService.ExecuteAndFetchDataTable(SqlConnection connection, SqlTransaction transaction, String procedureName, SqlParameter[] parameters) in D:\SOURCECODE\Sang.WebApi\Sang.Security.WebApi\CommonService\CommonEntityService.cs:line 186 at Sang.Security.WebApi.Repositories.RoleRepository.<>c__DisplayClass14_0.<b__0>d.MoveNext() in D:\SOURCECODE\Sang.WebApi\Sang.Security.WebApi\Repositories\RoleRepository.cs:line 267 --- End of stack trace from previous location --- at Sang.Security.WebApi.CommonService.DbTransactionService.ExecuteTransactionAsync(Func`3 transactionAction) in D:\SOURCECODE\Sang.WebApi\Sang.Security.WebApi\CommonService\DbTransactionService.cs:line 31 ClientConnectionId:b9eb8b20-48dd-4218-a16d-812e41172237 Error Number:105,State:1,Class:15 --- End of inner exception stack trace --- at Sang.Security.WebApi.CommonService.DbTransactionService.ExecuteTransactionAsync(Func`3 transactionAction) in D:\SOURCECODE\Sang.WebApi\Sang.Security.WebApi\CommonService\DbTransactionService.cs:line 45 at Sang.Security.WebApi.Repositories.RoleRepository.GetMasterData(Int32 masterId, String condition, Int32 typeId) in D:\SOURCECODE\Sang.WebApi\Sang.Security.WebApi\Repositories\RoleRepository.cs:line 258 at Sang.Security.WebApi.Services.RoleService.GetMasterData(Int32 masterId, String condition, Int32 typeId) in D:\SOURCECODE\Sang.WebApi\Sang.Security.WebApi\Services\RoleService.cs:line 44 at Sang.Security.WebApi.Controllers.RoleController.GetMasterData(Int32 masterId, Int32 typeId, String searchCondition) in D:\SOURCECODE\Sang.WebApi\Sang.Security.WebApi\Controllers\RoleController.cs:line 179 2024-05-02 09:23:44.609 +05:30 623a5d0a-e58a-4022-85f5-67a60d5d05e9 ERR Unclosed quotation mark after the character string ' and isnull(istatus,0)=0 order by sName'. Incorrect syntax near ' and isnull(istatus,0)=0 order by sName'. 2024-05-02 09:23:44.610 +05:30 623a5d0a-e58a-4022-85f5-67a60d5d05e9 ERR Unclosed quotation mark after the character string ' and isnull(istatus,0)=0 order by sName'. Incorrect syntax near ' and isnull(istatus,0)=0 order by sName'. 2024-05-02 09:23:44.611 +05:30 623a5d0a-e58a-4022-85f5-67a60d5d05e9 ERR Database connection error: Unclosed quotation mark after the character string ' and isnull(istatus,0)=0 order by sName'. Incorrect syntax near ' and isnull(istatus,0)=0 order by sName'. 2024-05-02 09:23:44.613 +05:30 623a5d0a-e58a-4022-85f5-67a60d5d05e9 ERR Getting Master Data for Master failed System.Exception: Database connection error: Unclosed quotation mark after the character string ' and isnull(istatus,0)=0 order by sName'. Incorrect syntax near ' and isnull(istatus,0)=0 order by sName'. ---> System.Data.SqlClient.SqlException (0x80131904): Unclosed quotation mark after the character string ' and isnull(istatus,0)=0 order by sName'. Incorrect syntax near ' and isnull(istatus,0)=0 order by sName'. 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.Security.WebApi.CommonService.CommonEntityService.ExecuteAndFetchDataTable(SqlConnection connection, SqlTransaction transaction, String procedureName, SqlParameter[] parameters) in D:\SOURCECODE\Sang.WebApi\Sang.Security.WebApi\CommonService\CommonEntityService.cs:line 186 at Sang.Security.WebApi.Repositories.RoleRepository.<>c__DisplayClass14_0.<b__0>d.MoveNext() in D:\SOURCECODE\Sang.WebApi\Sang.Security.WebApi\Repositories\RoleRepository.cs:line 267 --- End of stack trace from previous location --- at Sang.Security.WebApi.CommonService.DbTransactionService.ExecuteTransactionAsync(Func`3 transactionAction) in D:\SOURCECODE\Sang.WebApi\Sang.Security.WebApi\CommonService\DbTransactionService.cs:line 31 ClientConnectionId:b9eb8b20-48dd-4218-a16d-812e41172237 Error Number:105,State:1,Class:15 --- End of inner exception stack trace --- at Sang.Security.WebApi.CommonService.DbTransactionService.ExecuteTransactionAsync(Func`3 transactionAction) in D:\SOURCECODE\Sang.WebApi\Sang.Security.WebApi\CommonService\DbTransactionService.cs:line 45 at Sang.Security.WebApi.Repositories.RoleRepository.GetMasterData(Int32 masterId, String condition, Int32 typeId) in D:\SOURCECODE\Sang.WebApi\Sang.Security.WebApi\Repositories\RoleRepository.cs:line 258 at Sang.Security.WebApi.Services.RoleService.GetMasterData(Int32 masterId, String condition, Int32 typeId) in D:\SOURCECODE\Sang.WebApi\Sang.Security.WebApi\Services\RoleService.cs:line 44 at Sang.Security.WebApi.Controllers.RoleController.GetMasterData(Int32 masterId, Int32 typeId, String searchCondition) in D:\SOURCECODE\Sang.WebApi\Sang.Security.WebApi\Controllers\RoleController.cs:line 179 2024-05-02 15:11:22.289 +05:30 9a272afd-4ca2-4530-aa51-eafcdfaec8d5 ERR Incorrect syntax near '1'. 2024-05-02 15:11:22.351 +05:30 9a272afd-4ca2-4530-aa51-eafcdfaec8d5 ERR Incorrect syntax near '1'. 2024-05-02 15:11:22.351 +05:30 9a272afd-4ca2-4530-aa51-eafcdfaec8d5 ERR Database connection error: Incorrect syntax near '1'. 2024-05-02 15:11:22.386 +05:30 9a272afd-4ca2-4530-aa51-eafcdfaec8d5 ERR Getting Master Data for Master failed System.Exception: Database connection error: Incorrect syntax near '1'. ---> System.Data.SqlClient.SqlException (0x80131904): Incorrect syntax near '1'. 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.Security.WebApi.CommonService.CommonEntityService.ExecuteAndFetchDataTable(SqlConnection connection, SqlTransaction transaction, String procedureName, SqlParameter[] parameters) in D:\SOURCECODE\Sang.WebApi\Sang.Security.WebApi\CommonService\CommonEntityService.cs:line 186 at Sang.Security.WebApi.Repositories.RoleRepository.<>c__DisplayClass14_0.<b__0>d.MoveNext() in D:\SOURCECODE\Sang.WebApi\Sang.Security.WebApi\Repositories\RoleRepository.cs:line 274 --- End of stack trace from previous location --- at Sang.Security.WebApi.CommonService.DbTransactionService.ExecuteTransactionAsync(Func`3 transactionAction) in D:\SOURCECODE\Sang.WebApi\Sang.Security.WebApi\CommonService\DbTransactionService.cs:line 31 ClientConnectionId:5e1c754e-935b-450e-b8a2-14c64b9e2bef Error Number:102,State:1,Class:15 --- End of inner exception stack trace --- at Sang.Security.WebApi.CommonService.DbTransactionService.ExecuteTransactionAsync(Func`3 transactionAction) in D:\SOURCECODE\Sang.WebApi\Sang.Security.WebApi\CommonService\DbTransactionService.cs:line 45 at Sang.Security.WebApi.Repositories.RoleRepository.GetMasterData(Int32 masterId, String condition, Int32 typeId) in D:\SOURCECODE\Sang.WebApi\Sang.Security.WebApi\Repositories\RoleRepository.cs:line 265 at Sang.Security.WebApi.Services.RoleService.GetMasterData(Int32 masterId, String condition, Int32 typeId) in D:\SOURCECODE\Sang.WebApi\Sang.Security.WebApi\Services\RoleService.cs:line 45 at Sang.Security.WebApi.Controllers.RoleController.GetMasterData(Int32 masterId, Int32 typeId, String searchCondition) in D:\SOURCECODE\Sang.WebApi\Sang.Security.WebApi\Controllers\RoleController.cs:line 180 2024-05-02 15:11:52.226 +05:30 26f05831-1a52-4139-824e-42f4781b7d62 ERR Incorrect syntax near '1'. 2024-05-02 15:11:52.228 +05:30 26f05831-1a52-4139-824e-42f4781b7d62 ERR Incorrect syntax near '1'. 2024-05-02 15:11:52.228 +05:30 26f05831-1a52-4139-824e-42f4781b7d62 ERR Database connection error: Incorrect syntax near '1'. 2024-05-02 15:11:52.231 +05:30 26f05831-1a52-4139-824e-42f4781b7d62 ERR Getting Master Data for Master failed System.Exception: Database connection error: Incorrect syntax near '1'. ---> System.Data.SqlClient.SqlException (0x80131904): Incorrect syntax near '1'. 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.Security.WebApi.CommonService.CommonEntityService.ExecuteAndFetchDataTable(SqlConnection connection, SqlTransaction transaction, String procedureName, SqlParameter[] parameters) in D:\SOURCECODE\Sang.WebApi\Sang.Security.WebApi\CommonService\CommonEntityService.cs:line 186 at Sang.Security.WebApi.Repositories.RoleRepository.<>c__DisplayClass14_0.<b__0>d.MoveNext() in D:\SOURCECODE\Sang.WebApi\Sang.Security.WebApi\Repositories\RoleRepository.cs:line 274 --- End of stack trace from previous location --- at Sang.Security.WebApi.CommonService.DbTransactionService.ExecuteTransactionAsync(Func`3 transactionAction) in D:\SOURCECODE\Sang.WebApi\Sang.Security.WebApi\CommonService\DbTransactionService.cs:line 31 ClientConnectionId:5e1c754e-935b-450e-b8a2-14c64b9e2bef Error Number:102,State:1,Class:15 --- End of inner exception stack trace --- at Sang.Security.WebApi.CommonService.DbTransactionService.ExecuteTransactionAsync(Func`3 transactionAction) in D:\SOURCECODE\Sang.WebApi\Sang.Security.WebApi\CommonService\DbTransactionService.cs:line 45 at Sang.Security.WebApi.Repositories.RoleRepository.GetMasterData(Int32 masterId, String condition, Int32 typeId) in D:\SOURCECODE\Sang.WebApi\Sang.Security.WebApi\Repositories\RoleRepository.cs:line 265 at Sang.Security.WebApi.Services.RoleService.GetMasterData(Int32 masterId, String condition, Int32 typeId) in D:\SOURCECODE\Sang.WebApi\Sang.Security.WebApi\Services\RoleService.cs:line 45 at Sang.Security.WebApi.Controllers.RoleController.GetMasterData(Int32 masterId, Int32 typeId, String searchCondition) in D:\SOURCECODE\Sang.WebApi\Sang.Security.WebApi\Controllers\RoleController.cs:line 180 2024-05-02 22:38:03.177 +05:30 dea1b311-f032-4baa-948d-3b2fd8617e45 ERR Token Regeneration failed Microsoft.IdentityModel.Tokens.SecurityTokenExpiredException: Refresh token has expired at Sang.Security.WebApi.Validators.TokenValidator.ValidateToken(String token, String TokenKey) in D:\SOURCECODE\Sang.WebApi\Sang.Security.WebApi\Validators\TokenValidator.cs:line 38 at Sang.Security.WebApi.Authentication.TokenService.RefreshToken(String refershToken) in D:\SOURCECODE\Sang.WebApi\Sang.Security.WebApi\Authentication\TokenService.cs:line 39 at Sang.Security.WebApi.Controllers.SecurityController.RegenerateTokens(String refershToken) in D:\SOURCECODE\Sang.WebApi\Sang.Security.WebApi\Controllers\SecurityController.cs:line 39