2024-04-29 11:02:56.545 +05:30 36ead0ef-c69b-439a-a293-b7b7b9d560d1 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-04-29 11:02:56.799 +05:30 3eb0c10c-6601-4588-a60c-675c831fa44a 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-04-29 11:02:56.888 +05:30 09aa5b60-17e0-4b5c-8a7d-15d9132b4c24 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-04-29 11:02:57.013 +05:30 78e63e5a-914c-41dc-a8f2-fe49babb3078 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-04-29 11:20:06.579 +05:30 05b01b4e-01c5-481c-a406-b783770be742 ERR Incorrect syntax near 'Sch'. Unclosed quotation mark after the character string ' and isnull(istatus,0)=0 order by sName'. 2024-04-29 11:20:06.606 +05:30 05b01b4e-01c5-481c-a406-b783770be742 ERR Incorrect syntax near 'Sch'. Unclosed quotation mark after the character string ' and isnull(istatus,0)=0 order by sName'. 2024-04-29 11:20:06.617 +05:30 05b01b4e-01c5-481c-a406-b783770be742 ERR Database connection error: Incorrect syntax near 'Sch'. Unclosed quotation mark after the character string ' and isnull(istatus,0)=0 order by sName'. 2024-04-29 11:20:06.686 +05:30 05b01b4e-01c5-481c-a406-b783770be742 ERR Getting Master Data for Master failed System.Exception: Database connection error: Incorrect syntax near 'Sch'. Unclosed quotation mark after the character string ' and isnull(istatus,0)=0 order by sName'. ---> System.Data.SqlClient.SqlException (0x80131904): Incorrect syntax near 'Sch'. Unclosed quotation mark after the character string ' 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.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.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:4e8ea8d2-2d67-4fe2-85fd-c685332a092e 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 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-04-29 11:20:17.770 +05:30 316b2b26-85e6-4628-868e-cceaa5f54edf ERR Incorrect syntax near 'Sch'. Unclosed quotation mark after the character string ' and isnull(istatus,0)=0 order by sName'. 2024-04-29 11:20:17.929 +05:30 316b2b26-85e6-4628-868e-cceaa5f54edf ERR Incorrect syntax near 'Sch'. Unclosed quotation mark after the character string ' and isnull(istatus,0)=0 order by sName'. 2024-04-29 11:20:17.930 +05:30 316b2b26-85e6-4628-868e-cceaa5f54edf ERR Database connection error: Incorrect syntax near 'Sch'. Unclosed quotation mark after the character string ' and isnull(istatus,0)=0 order by sName'. 2024-04-29 11:20:17.935 +05:30 316b2b26-85e6-4628-868e-cceaa5f54edf ERR Getting Master Data for Master failed System.Exception: Database connection error: Incorrect syntax near 'Sch'. Unclosed quotation mark after the character string ' and isnull(istatus,0)=0 order by sName'. ---> System.Data.SqlClient.SqlException (0x80131904): Incorrect syntax near 'Sch'. Unclosed quotation mark after the character string ' 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.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.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() --- 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:4558fad8-219a-45cd-9419-f69754e28ae3 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 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-04-29 11:21:28.284 +05:30 ff94e71d-e80c-432c-908b-f824c32c5e50 ERR Incorrect syntax near 'Sch'. Unclosed quotation mark after the character string ' and isnull(istatus,0)=0 order by sName'. 2024-04-29 11:21:28.287 +05:30 ff94e71d-e80c-432c-908b-f824c32c5e50 ERR Incorrect syntax near 'Sch'. Unclosed quotation mark after the character string ' and isnull(istatus,0)=0 order by sName'. 2024-04-29 11:21:28.288 +05:30 ff94e71d-e80c-432c-908b-f824c32c5e50 ERR Database connection error: Incorrect syntax near 'Sch'. Unclosed quotation mark after the character string ' and isnull(istatus,0)=0 order by sName'. 2024-04-29 11:21:28.293 +05:30 ff94e71d-e80c-432c-908b-f824c32c5e50 ERR Getting Master Data for Master failed System.Exception: Database connection error: Incorrect syntax near 'Sch'. Unclosed quotation mark after the character string ' and isnull(istatus,0)=0 order by sName'. ---> System.Data.SqlClient.SqlException (0x80131904): Incorrect syntax near 'Sch'. Unclosed quotation mark after the character string ' 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.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.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() --- 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:4558fad8-219a-45cd-9419-f69754e28ae3 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 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-04-29 11:22:27.321 +05:30 1aa25440-343a-41af-bcda-a4a24fe00e68 ERR Incorrect syntax near 'Sch'. Unclosed quotation mark after the character string ' and isnull(istatus,0)=0 order by sName'. 2024-04-29 11:22:27.324 +05:30 1aa25440-343a-41af-bcda-a4a24fe00e68 ERR Incorrect syntax near 'Sch'. Unclosed quotation mark after the character string ' and isnull(istatus,0)=0 order by sName'. 2024-04-29 11:22:27.324 +05:30 1aa25440-343a-41af-bcda-a4a24fe00e68 ERR Database connection error: Incorrect syntax near 'Sch'. Unclosed quotation mark after the character string ' and isnull(istatus,0)=0 order by sName'. 2024-04-29 11:22:27.328 +05:30 1aa25440-343a-41af-bcda-a4a24fe00e68 ERR Getting Master Data for Master failed System.Exception: Database connection error: Incorrect syntax near 'Sch'. Unclosed quotation mark after the character string ' and isnull(istatus,0)=0 order by sName'. ---> System.Data.SqlClient.SqlException (0x80131904): Incorrect syntax near 'Sch'. Unclosed quotation mark after the character string ' 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.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.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() --- 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:4558fad8-219a-45cd-9419-f69754e28ae3 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 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-04-29 11:22:40.708 +05:30 6bb8388f-2b89-4810-84bc-ee22bb43807c ERR Incorrect syntax near 'Sch'. Unclosed quotation mark after the character string ' and isnull(istatus,0)=0 order by sName'. 2024-04-29 11:22:40.711 +05:30 6bb8388f-2b89-4810-84bc-ee22bb43807c ERR Incorrect syntax near 'Sch'. Unclosed quotation mark after the character string ' and isnull(istatus,0)=0 order by sName'. 2024-04-29 11:22:40.711 +05:30 6bb8388f-2b89-4810-84bc-ee22bb43807c ERR Database connection error: Incorrect syntax near 'Sch'. Unclosed quotation mark after the character string ' and isnull(istatus,0)=0 order by sName'. 2024-04-29 11:22:40.715 +05:30 6bb8388f-2b89-4810-84bc-ee22bb43807c ERR Getting Master Data for Master failed System.Exception: Database connection error: Incorrect syntax near 'Sch'. Unclosed quotation mark after the character string ' and isnull(istatus,0)=0 order by sName'. ---> System.Data.SqlClient.SqlException (0x80131904): Incorrect syntax near 'Sch'. Unclosed quotation mark after the character string ' 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.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.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() --- 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:4558fad8-219a-45cd-9419-f69754e28ae3 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 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-04-29 11:32:14.475 +05:30 121067af-ac1f-4464-b404-0404bebe7c50 ERR Incorrect syntax near 'Sch'. Unclosed quotation mark after the character string ' and isnull(istatus,0)=0 order by sName'. 2024-04-29 11:32:14.482 +05:30 121067af-ac1f-4464-b404-0404bebe7c50 ERR Incorrect syntax near 'Sch'. Unclosed quotation mark after the character string ' and isnull(istatus,0)=0 order by sName'. 2024-04-29 11:32:14.482 +05:30 121067af-ac1f-4464-b404-0404bebe7c50 ERR Database connection error: Incorrect syntax near 'Sch'. Unclosed quotation mark after the character string ' and isnull(istatus,0)=0 order by sName'. 2024-04-29 11:32:14.486 +05:30 121067af-ac1f-4464-b404-0404bebe7c50 ERR Getting Master Data for Master failed System.Exception: Database connection error: Incorrect syntax near 'Sch'. Unclosed quotation mark after the character string ' and isnull(istatus,0)=0 order by sName'. ---> System.Data.SqlClient.SqlException (0x80131904): Incorrect syntax near 'Sch'. Unclosed quotation mark after the character string ' 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.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.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() --- 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:e87c0725-bbfe-49e2-a3bd-1faeedc354d3 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 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-04-29 11:33:35.982 +05:30 eb96f909-8ea2-496d-a1da-9bacfceadeec ERR Incorrect syntax near 'Sch'. Unclosed quotation mark after the character string ' and isnull(istatus,0)=0 order by sName'. 2024-04-29 11:33:35.990 +05:30 eb96f909-8ea2-496d-a1da-9bacfceadeec ERR Incorrect syntax near 'Sch'. Unclosed quotation mark after the character string ' and isnull(istatus,0)=0 order by sName'. 2024-04-29 11:33:35.991 +05:30 eb96f909-8ea2-496d-a1da-9bacfceadeec ERR Database connection error: Incorrect syntax near 'Sch'. Unclosed quotation mark after the character string ' and isnull(istatus,0)=0 order by sName'. 2024-04-29 11:33:35.995 +05:30 eb96f909-8ea2-496d-a1da-9bacfceadeec ERR Getting Master Data for Master failed System.Exception: Database connection error: Incorrect syntax near 'Sch'. Unclosed quotation mark after the character string ' and isnull(istatus,0)=0 order by sName'. ---> System.Data.SqlClient.SqlException (0x80131904): Incorrect syntax near 'Sch'. Unclosed quotation mark after the character string ' 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.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.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() --- 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:e87c0725-bbfe-49e2-a3bd-1faeedc354d3 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 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-04-29 11:35:36.390 +05:30 3b60e130-e2f1-4c19-96f8-906525e5db53 ERR Incorrect syntax near 'Sch'. Unclosed quotation mark after the character string ' and isnull(istatus,0)=0 order by sName'. 2024-04-29 11:35:36.392 +05:30 3b60e130-e2f1-4c19-96f8-906525e5db53 ERR Incorrect syntax near 'Sch'. Unclosed quotation mark after the character string ' and isnull(istatus,0)=0 order by sName'. 2024-04-29 11:35:36.393 +05:30 3b60e130-e2f1-4c19-96f8-906525e5db53 ERR Database connection error: Incorrect syntax near 'Sch'. Unclosed quotation mark after the character string ' and isnull(istatus,0)=0 order by sName'. 2024-04-29 11:35:36.395 +05:30 3b60e130-e2f1-4c19-96f8-906525e5db53 ERR Getting Master Data for Master failed System.Exception: Database connection error: Incorrect syntax near 'Sch'. Unclosed quotation mark after the character string ' and isnull(istatus,0)=0 order by sName'. ---> System.Data.SqlClient.SqlException (0x80131904): Incorrect syntax near 'Sch'. Unclosed quotation mark after the character string ' 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.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.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() --- 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:7aacd2ac-15f5-47fa-ba90-502c5d84c7af 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 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-04-29 11:51:58.432 +05:30 2f862a2d-8ebe-4d17-a6c2-79504c10766b ERR Incorrect syntax near 'Sch'. Unclosed quotation mark after the character string ' and isnull(istatus,0)=0 order by sName'. 2024-04-29 11:51:58.490 +05:30 2f862a2d-8ebe-4d17-a6c2-79504c10766b ERR Incorrect syntax near 'Sch'. Unclosed quotation mark after the character string ' and isnull(istatus,0)=0 order by sName'. 2024-04-29 11:51:58.491 +05:30 2f862a2d-8ebe-4d17-a6c2-79504c10766b ERR Database connection error: Incorrect syntax near 'Sch'. Unclosed quotation mark after the character string ' and isnull(istatus,0)=0 order by sName'. 2024-04-29 11:51:58.514 +05:30 2f862a2d-8ebe-4d17-a6c2-79504c10766b ERR Getting Master Data for Master failed System.Exception: Database connection error: Incorrect syntax near 'Sch'. Unclosed quotation mark after the character string ' and isnull(istatus,0)=0 order by sName'. ---> System.Data.SqlClient.SqlException (0x80131904): Incorrect syntax near 'Sch'. Unclosed quotation mark after the character string ' 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.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.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:ae812c4b-b97f-4f8f-a631-e9a8e35b6fb2 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 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-04-29 11:53:13.569 +05:30 50ef165e-207a-4205-845a-6772fa282be6 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-04-29 11:56:58.457 +05:30 47b12106-b129-4f77-963b-bc141378fc48 ERR Incorrect syntax near 'Sch'. Unclosed quotation mark after the character string ' and isnull(istatus,0)=0 order by sName'. 2024-04-29 11:56:58.462 +05:30 47b12106-b129-4f77-963b-bc141378fc48 ERR Incorrect syntax near 'Sch'. Unclosed quotation mark after the character string ' and isnull(istatus,0)=0 order by sName'. 2024-04-29 11:56:58.462 +05:30 47b12106-b129-4f77-963b-bc141378fc48 ERR Database connection error: Incorrect syntax near 'Sch'. Unclosed quotation mark after the character string ' and isnull(istatus,0)=0 order by sName'. 2024-04-29 11:56:58.469 +05:30 47b12106-b129-4f77-963b-bc141378fc48 ERR Getting Master Data for Master failed System.Exception: Database connection error: Incorrect syntax near 'Sch'. Unclosed quotation mark after the character string ' and isnull(istatus,0)=0 order by sName'. ---> System.Data.SqlClient.SqlException (0x80131904): Incorrect syntax near 'Sch'. Unclosed quotation mark after the character string ' 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.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.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() --- 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:d69e5d4f-38a0-4df5-a5fc-583f2197a12c 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 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-04-29 11:57:06.611 +05:30 ec1c5911-4c6a-4515-a9ce-3d263665a0ed ERR Incorrect syntax near 'Sch'. Unclosed quotation mark after the character string ' and isnull(istatus,0)=0 order by sName'. 2024-04-29 11:57:06.619 +05:30 ec1c5911-4c6a-4515-a9ce-3d263665a0ed ERR Incorrect syntax near 'Sch'. Unclosed quotation mark after the character string ' and isnull(istatus,0)=0 order by sName'. 2024-04-29 11:57:06.619 +05:30 ec1c5911-4c6a-4515-a9ce-3d263665a0ed ERR Database connection error: Incorrect syntax near 'Sch'. Unclosed quotation mark after the character string ' and isnull(istatus,0)=0 order by sName'. 2024-04-29 11:57:06.621 +05:30 ec1c5911-4c6a-4515-a9ce-3d263665a0ed ERR Getting Master Data for Master failed System.Exception: Database connection error: Incorrect syntax near 'Sch'. Unclosed quotation mark after the character string ' and isnull(istatus,0)=0 order by sName'. ---> System.Data.SqlClient.SqlException (0x80131904): Incorrect syntax near 'Sch'. Unclosed quotation mark after the character string ' 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.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.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() --- 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:0c36c051-3ea0-47c2-9ab1-2ccc6f681dcf 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 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-04-29 11:58:21.215 +05:30 f94532b6-547a-424b-9f01-68753b891d29 ERR Incorrect syntax near 'Sch'. Unclosed quotation mark after the character string ' and isnull(istatus,0)=0 order by sName'. 2024-04-29 11:58:21.217 +05:30 f94532b6-547a-424b-9f01-68753b891d29 ERR Incorrect syntax near 'Sch'. Unclosed quotation mark after the character string ' and isnull(istatus,0)=0 order by sName'. 2024-04-29 11:58:21.217 +05:30 f94532b6-547a-424b-9f01-68753b891d29 ERR Database connection error: Incorrect syntax near 'Sch'. Unclosed quotation mark after the character string ' and isnull(istatus,0)=0 order by sName'. 2024-04-29 11:58:21.220 +05:30 f94532b6-547a-424b-9f01-68753b891d29 ERR Getting Master Data for Master failed System.Exception: Database connection error: Incorrect syntax near 'Sch'. Unclosed quotation mark after the character string ' and isnull(istatus,0)=0 order by sName'. ---> System.Data.SqlClient.SqlException (0x80131904): Incorrect syntax near 'Sch'. Unclosed quotation mark after the character string ' 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.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.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() --- 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:15a6dfd2-c438-4970-b27a-0d13cddb62e9 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 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-04-29 11:58:32.965 +05:30 a3fd5b6b-a7d8-4987-b531-899b3378704e ERR Incorrect syntax near 'Sch'. Unclosed quotation mark after the character string ' and isnull(istatus,0)=0 order by sName'. 2024-04-29 11:58:32.970 +05:30 a3fd5b6b-a7d8-4987-b531-899b3378704e ERR Incorrect syntax near 'Sch'. Unclosed quotation mark after the character string ' and isnull(istatus,0)=0 order by sName'. 2024-04-29 11:58:32.971 +05:30 a3fd5b6b-a7d8-4987-b531-899b3378704e ERR Database connection error: Incorrect syntax near 'Sch'. Unclosed quotation mark after the character string ' and isnull(istatus,0)=0 order by sName'. 2024-04-29 11:58:32.974 +05:30 a3fd5b6b-a7d8-4987-b531-899b3378704e ERR Getting Master Data for Master failed System.Exception: Database connection error: Incorrect syntax near 'Sch'. Unclosed quotation mark after the character string ' and isnull(istatus,0)=0 order by sName'. ---> System.Data.SqlClient.SqlException (0x80131904): Incorrect syntax near 'Sch'. Unclosed quotation mark after the character string ' 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.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.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() --- 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:15a6dfd2-c438-4970-b27a-0d13cddb62e9 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 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-04-29 12:11:37.469 +05:30 b0c6724a-f145-4799-b3ff-772c714b4705 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-04-29 12:11:37.615 +05:30 4745d976-f901-4cd0-91ff-b009f38b6bd1 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-04-29 12:11:37.694 +05:30 ca5085a7-f3ce-444a-96ad-18c70601a9f9 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-04-29 12:11:37.763 +05:30 afbcea07-61c7-4f43-a4a5-b7332460c935 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-04-29 12:13:07.525 +05:30 d84b9084-8b48-437e-af8e-2f4f16eec49b ERR Incorrect syntax near 'Sch'. Unclosed quotation mark after the character string ' and isnull(istatus,0)=0 order by sName'. 2024-04-29 12:13:07.527 +05:30 d84b9084-8b48-437e-af8e-2f4f16eec49b ERR Incorrect syntax near 'Sch'. Unclosed quotation mark after the character string ' and isnull(istatus,0)=0 order by sName'. 2024-04-29 12:13:07.528 +05:30 d84b9084-8b48-437e-af8e-2f4f16eec49b ERR Database connection error: Incorrect syntax near 'Sch'. Unclosed quotation mark after the character string ' and isnull(istatus,0)=0 order by sName'. 2024-04-29 12:13:07.535 +05:30 d84b9084-8b48-437e-af8e-2f4f16eec49b ERR Getting Master Data for Master failed System.Exception: Database connection error: Incorrect syntax near 'Sch'. Unclosed quotation mark after the character string ' and isnull(istatus,0)=0 order by sName'. ---> System.Data.SqlClient.SqlException (0x80131904): Incorrect syntax near 'Sch'. Unclosed quotation mark after the character string ' 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.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.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:fa20e642-5085-4fde-b788-7861d106155b 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 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-04-29 12:13:17.396 +05:30 c3af0023-8a71-421a-82b5-13bc3a5d63eb ERR Incorrect syntax near 'Sch'. Unclosed quotation mark after the character string ' and isnull(istatus,0)=0 order by sName'. 2024-04-29 12:13:17.399 +05:30 c3af0023-8a71-421a-82b5-13bc3a5d63eb ERR Incorrect syntax near 'Sch'. Unclosed quotation mark after the character string ' and isnull(istatus,0)=0 order by sName'. 2024-04-29 12:13:17.399 +05:30 c3af0023-8a71-421a-82b5-13bc3a5d63eb ERR Database connection error: Incorrect syntax near 'Sch'. Unclosed quotation mark after the character string ' and isnull(istatus,0)=0 order by sName'. 2024-04-29 12:13:17.402 +05:30 c3af0023-8a71-421a-82b5-13bc3a5d63eb ERR Getting Master Data for Master failed System.Exception: Database connection error: Incorrect syntax near 'Sch'. Unclosed quotation mark after the character string ' and isnull(istatus,0)=0 order by sName'. ---> System.Data.SqlClient.SqlException (0x80131904): Incorrect syntax near 'Sch'. Unclosed quotation mark after the character string ' 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.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.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() --- 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:fa20e642-5085-4fde-b788-7861d106155b 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 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-04-29 12:13:43.162 +05:30 f39507a9-f0f3-477a-8d48-54205b6a6e9f ERR Incorrect syntax near 'Sch'. Unclosed quotation mark after the character string ' and isnull(istatus,0)=0 order by sName'. 2024-04-29 12:13:43.164 +05:30 f39507a9-f0f3-477a-8d48-54205b6a6e9f ERR Incorrect syntax near 'Sch'. Unclosed quotation mark after the character string ' and isnull(istatus,0)=0 order by sName'. 2024-04-29 12:13:43.164 +05:30 f39507a9-f0f3-477a-8d48-54205b6a6e9f ERR Database connection error: Incorrect syntax near 'Sch'. Unclosed quotation mark after the character string ' and isnull(istatus,0)=0 order by sName'. 2024-04-29 12:13:43.167 +05:30 f39507a9-f0f3-477a-8d48-54205b6a6e9f ERR Getting Master Data for Master failed System.Exception: Database connection error: Incorrect syntax near 'Sch'. Unclosed quotation mark after the character string ' and isnull(istatus,0)=0 order by sName'. ---> System.Data.SqlClient.SqlException (0x80131904): Incorrect syntax near 'Sch'. Unclosed quotation mark after the character string ' 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.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.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() --- 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:fa20e642-5085-4fde-b788-7861d106155b 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 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-04-29 13:00:16.485 +05:30 c41c3ffc-ae79-472e-99a1-480dad2eae7c 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-04-29 13:00:17.053 +05:30 d90e44a3-ecfa-4fe5-b52d-74328ac314bb 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-04-29 13:00:18.455 +05:30 1ed5553a-5fe2-45fe-b737-ed4a509d9d73 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-04-29 13:00:18.485 +05:30 7e5e651b-22c3-4000-93c3-e27bd4f5d311 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-04-29 13:00:57.335 +05:30 eab34e99-6774-44de-bbf7-680402ae42bd ERR Incorrect syntax near 'Sch'. Unclosed quotation mark after the character string ' and isnull(istatus,0)=0 order by sName'. 2024-04-29 13:00:57.339 +05:30 eab34e99-6774-44de-bbf7-680402ae42bd ERR Incorrect syntax near 'Sch'. Unclosed quotation mark after the character string ' and isnull(istatus,0)=0 order by sName'. 2024-04-29 13:00:57.343 +05:30 eab34e99-6774-44de-bbf7-680402ae42bd ERR Database connection error: Incorrect syntax near 'Sch'. Unclosed quotation mark after the character string ' and isnull(istatus,0)=0 order by sName'. 2024-04-29 13:00:57.362 +05:30 eab34e99-6774-44de-bbf7-680402ae42bd ERR Getting Master Data for Master failed System.Exception: Database connection error: Incorrect syntax near 'Sch'. Unclosed quotation mark after the character string ' and isnull(istatus,0)=0 order by sName'. ---> System.Data.SqlClient.SqlException (0x80131904): Incorrect syntax near 'Sch'. Unclosed quotation mark after the character string ' 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.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.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:86214ff6-424d-4d68-adba-f38dbe3a8050 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 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-04-29 13:01:18.110 +05:30 7837e039-4d42-4a29-998e-87bb92a8143c ERR Incorrect syntax near 'Sch'. Unclosed quotation mark after the character string ' and isnull(istatus,0)=0 order by sName'. 2024-04-29 13:01:18.113 +05:30 7837e039-4d42-4a29-998e-87bb92a8143c ERR Incorrect syntax near 'Sch'. Unclosed quotation mark after the character string ' and isnull(istatus,0)=0 order by sName'. 2024-04-29 13:01:18.114 +05:30 7837e039-4d42-4a29-998e-87bb92a8143c ERR Database connection error: Incorrect syntax near 'Sch'. Unclosed quotation mark after the character string ' and isnull(istatus,0)=0 order by sName'. 2024-04-29 13:01:18.117 +05:30 7837e039-4d42-4a29-998e-87bb92a8143c ERR Getting Master Data for Master failed System.Exception: Database connection error: Incorrect syntax near 'Sch'. Unclosed quotation mark after the character string ' and isnull(istatus,0)=0 order by sName'. ---> System.Data.SqlClient.SqlException (0x80131904): Incorrect syntax near 'Sch'. Unclosed quotation mark after the character string ' 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.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.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:ea85af85-ae97-439c-9ea0-6ed65a879b03 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 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-04-29 13:04:53.287 +05:30 acddb689-e928-4f53-aeac-b470fdee954d 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-04-29 13:38:57.840 +05:30 1772bb7d-07f6-4eba-b88d-3d4116172a94 ERR Invalid database name. 2024-04-29 14:10:40.910 +05:30 b2f6f557-97f1-4193-a650-1f82c443f946 ERR The INSERT statement conflicted with the FOREIGN KEY constraint "fk_iMenuId_t_s_RolesExtraRights". The conflict occurred in database "SANG_01", table "dbo.t_m_Menu", column 'iId'. The INSERT statement conflicted with the FOREIGN KEY constraint "fk_iMenuId_t_s_RolesExtraRights". The conflict occurred in database "SANG_01", table "dbo.t_m_Menu", column 'iId'. The statement has been terminated. The statement has been terminated. 2024-04-29 14:10:40.915 +05:30 b2f6f557-97f1-4193-a650-1f82c443f946 ERR The INSERT statement conflicted with the FOREIGN KEY constraint "fk_iMenuId_t_s_RolesExtraRights". The conflict occurred in database "SANG_01", table "dbo.t_m_Menu", column 'iId'. The INSERT statement conflicted with the FOREIGN KEY constraint "fk_iMenuId_t_s_RolesExtraRights". The conflict occurred in database "SANG_01", table "dbo.t_m_Menu", column 'iId'. The statement has been terminated. The statement has been terminated. 2024-04-29 14:10:40.917 +05:30 b2f6f557-97f1-4193-a650-1f82c443f946 ERR Database connection error: The INSERT statement conflicted with the FOREIGN KEY constraint "fk_iMenuId_t_s_RolesExtraRights". The conflict occurred in database "SANG_01", table "dbo.t_m_Menu", column 'iId'. The INSERT statement conflicted with the FOREIGN KEY constraint "fk_iMenuId_t_s_RolesExtraRights". The conflict occurred in database "SANG_01", table "dbo.t_m_Menu", column 'iId'. The statement has been terminated. The statement has been terminated. 2024-04-29 14:10:40.974 +05:30 b2f6f557-97f1-4193-a650-1f82c443f946 ERR Upserting Role Failed System.Exception: Database connection error: The INSERT statement conflicted with the FOREIGN KEY constraint "fk_iMenuId_t_s_RolesExtraRights". The conflict occurred in database "SANG_01", table "dbo.t_m_Menu", column 'iId'. The INSERT statement conflicted with the FOREIGN KEY constraint "fk_iMenuId_t_s_RolesExtraRights". The conflict occurred in database "SANG_01", table "dbo.t_m_Menu", column 'iId'. The statement has been terminated. The statement has been terminated. ---> System.Data.SqlClient.SqlException (0x80131904): The INSERT statement conflicted with the FOREIGN KEY constraint "fk_iMenuId_t_s_RolesExtraRights". The conflict occurred in database "SANG_01", table "dbo.t_m_Menu", column 'iId'. The INSERT statement conflicted with the FOREIGN KEY constraint "fk_iMenuId_t_s_RolesExtraRights". The conflict occurred in database "SANG_01", table "dbo.t_m_Menu", column 'iId'. The statement has been terminated. 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.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__DisplayClass15_0.<b__0>d.MoveNext() in D:\SOURCECODE\Sang.WebApi\Sang.Security.WebApi\Repositories\RoleRepository.cs:line 338 --- 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:1229afac-c3c1-4c25-973e-c56a249a7ae8 Error Number:547,State:0,Class:16 --- 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.UpsertRole(Int32 roleId, String roleName, String profileId, RoleTransRightsTableType transRights, List`1 roleMaster, List`1 menuActionAddition, List`1 menuActionExclusion) in D:\SOURCECODE\Sang.WebApi\Sang.Security.WebApi\Repositories\RoleRepository.cs:line 290 at Sang.Security.WebApi.Services.RoleService.UpsertRole(Int32 roleId, String roleName, String profileId, RoleTransRightsTableType transRights, List`1 roleMaster, List`1 menuActionAddition, List`1 menuActionExclusion) in D:\SOURCECODE\Sang.WebApi\Sang.Security.WebApi\Services\RoleService.cs:line 50 at Sang.Security.WebApi.Controllers.RoleController.UpsertRole(RoleDetails roleDetails) in D:\SOURCECODE\Sang.WebApi\Sang.Security.WebApi\Controllers\RoleController.cs:line 253 2024-04-29 14:11:36.972 +05:30 f6f38c0a-524a-4411-8f06-15d5b56bf358 ERR The INSERT statement conflicted with the FOREIGN KEY constraint "fk_iMenuId_t_s_RolesExtraRights". The conflict occurred in database "SANG_01", table "dbo.t_m_Menu", column 'iId'. The INSERT statement conflicted with the FOREIGN KEY constraint "fk_iMenuId_t_s_RolesExtraRights". The conflict occurred in database "SANG_01", table "dbo.t_m_Menu", column 'iId'. The statement has been terminated. The statement has been terminated. 2024-04-29 14:11:36.977 +05:30 f6f38c0a-524a-4411-8f06-15d5b56bf358 ERR The INSERT statement conflicted with the FOREIGN KEY constraint "fk_iMenuId_t_s_RolesExtraRights". The conflict occurred in database "SANG_01", table "dbo.t_m_Menu", column 'iId'. The INSERT statement conflicted with the FOREIGN KEY constraint "fk_iMenuId_t_s_RolesExtraRights". The conflict occurred in database "SANG_01", table "dbo.t_m_Menu", column 'iId'. The statement has been terminated. The statement has been terminated. 2024-04-29 14:11:36.979 +05:30 f6f38c0a-524a-4411-8f06-15d5b56bf358 ERR Database connection error: The INSERT statement conflicted with the FOREIGN KEY constraint "fk_iMenuId_t_s_RolesExtraRights". The conflict occurred in database "SANG_01", table "dbo.t_m_Menu", column 'iId'. The INSERT statement conflicted with the FOREIGN KEY constraint "fk_iMenuId_t_s_RolesExtraRights". The conflict occurred in database "SANG_01", table "dbo.t_m_Menu", column 'iId'. The statement has been terminated. The statement has been terminated. 2024-04-29 14:11:36.986 +05:30 f6f38c0a-524a-4411-8f06-15d5b56bf358 ERR Upserting Role Failed System.Exception: Database connection error: The INSERT statement conflicted with the FOREIGN KEY constraint "fk_iMenuId_t_s_RolesExtraRights". The conflict occurred in database "SANG_01", table "dbo.t_m_Menu", column 'iId'. The INSERT statement conflicted with the FOREIGN KEY constraint "fk_iMenuId_t_s_RolesExtraRights". The conflict occurred in database "SANG_01", table "dbo.t_m_Menu", column 'iId'. The statement has been terminated. The statement has been terminated. ---> System.Data.SqlClient.SqlException (0x80131904): The INSERT statement conflicted with the FOREIGN KEY constraint "fk_iMenuId_t_s_RolesExtraRights". The conflict occurred in database "SANG_01", table "dbo.t_m_Menu", column 'iId'. The INSERT statement conflicted with the FOREIGN KEY constraint "fk_iMenuId_t_s_RolesExtraRights". The conflict occurred in database "SANG_01", table "dbo.t_m_Menu", column 'iId'. The statement has been terminated. 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.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__DisplayClass15_0.<b__0>d.MoveNext() in D:\SOURCECODE\Sang.WebApi\Sang.Security.WebApi\Repositories\RoleRepository.cs:line 338 --- 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:1229afac-c3c1-4c25-973e-c56a249a7ae8 Error Number:547,State:0,Class:16 --- 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.UpsertRole(Int32 roleId, String roleName, String profileId, RoleTransRightsTableType transRights, List`1 roleMaster, List`1 menuActionAddition, List`1 menuActionExclusion) in D:\SOURCECODE\Sang.WebApi\Sang.Security.WebApi\Repositories\RoleRepository.cs:line 290 at Sang.Security.WebApi.Services.RoleService.UpsertRole(Int32 roleId, String roleName, String profileId, RoleTransRightsTableType transRights, List`1 roleMaster, List`1 menuActionAddition, List`1 menuActionExclusion) in D:\SOURCECODE\Sang.WebApi\Sang.Security.WebApi\Services\RoleService.cs:line 50 at Sang.Security.WebApi.Controllers.RoleController.UpsertRole(RoleDetails roleDetails) in D:\SOURCECODE\Sang.WebApi\Sang.Security.WebApi\Controllers\RoleController.cs:line 253 2024-04-29 14:13:50.749 +05:30 04dbea11-bbc8-42aa-979e-47bee4338cdb ERR The INSERT statement conflicted with the FOREIGN KEY constraint "fk_iMenuId_t_s_RolesExtraRights". The conflict occurred in database "SANG_01", table "dbo.t_m_Menu", column 'iId'. The INSERT statement conflicted with the FOREIGN KEY constraint "fk_iMenuId_t_s_RolesExtraRights". The conflict occurred in database "SANG_01", table "dbo.t_m_Menu", column 'iId'. The statement has been terminated. The statement has been terminated. 2024-04-29 14:13:50.751 +05:30 04dbea11-bbc8-42aa-979e-47bee4338cdb ERR The INSERT statement conflicted with the FOREIGN KEY constraint "fk_iMenuId_t_s_RolesExtraRights". The conflict occurred in database "SANG_01", table "dbo.t_m_Menu", column 'iId'. The INSERT statement conflicted with the FOREIGN KEY constraint "fk_iMenuId_t_s_RolesExtraRights". The conflict occurred in database "SANG_01", table "dbo.t_m_Menu", column 'iId'. The statement has been terminated. The statement has been terminated. 2024-04-29 14:13:50.751 +05:30 04dbea11-bbc8-42aa-979e-47bee4338cdb ERR Database connection error: The INSERT statement conflicted with the FOREIGN KEY constraint "fk_iMenuId_t_s_RolesExtraRights". The conflict occurred in database "SANG_01", table "dbo.t_m_Menu", column 'iId'. The INSERT statement conflicted with the FOREIGN KEY constraint "fk_iMenuId_t_s_RolesExtraRights". The conflict occurred in database "SANG_01", table "dbo.t_m_Menu", column 'iId'. The statement has been terminated. The statement has been terminated. 2024-04-29 14:13:50.755 +05:30 04dbea11-bbc8-42aa-979e-47bee4338cdb ERR Upserting Role Failed System.Exception: Database connection error: The INSERT statement conflicted with the FOREIGN KEY constraint "fk_iMenuId_t_s_RolesExtraRights". The conflict occurred in database "SANG_01", table "dbo.t_m_Menu", column 'iId'. The INSERT statement conflicted with the FOREIGN KEY constraint "fk_iMenuId_t_s_RolesExtraRights". The conflict occurred in database "SANG_01", table "dbo.t_m_Menu", column 'iId'. The statement has been terminated. The statement has been terminated. ---> System.Data.SqlClient.SqlException (0x80131904): The INSERT statement conflicted with the FOREIGN KEY constraint "fk_iMenuId_t_s_RolesExtraRights". The conflict occurred in database "SANG_01", table "dbo.t_m_Menu", column 'iId'. The INSERT statement conflicted with the FOREIGN KEY constraint "fk_iMenuId_t_s_RolesExtraRights". The conflict occurred in database "SANG_01", table "dbo.t_m_Menu", column 'iId'. The statement has been terminated. 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.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__DisplayClass15_0.<b__0>d.MoveNext() in D:\SOURCECODE\Sang.WebApi\Sang.Security.WebApi\Repositories\RoleRepository.cs:line 338 --- 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:1229afac-c3c1-4c25-973e-c56a249a7ae8 Error Number:547,State:0,Class:16 --- 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.UpsertRole(Int32 roleId, String roleName, String profileId, RoleTransRightsTableType transRights, List`1 roleMaster, List`1 menuActionAddition, List`1 menuActionExclusion) in D:\SOURCECODE\Sang.WebApi\Sang.Security.WebApi\Repositories\RoleRepository.cs:line 290 at Sang.Security.WebApi.Services.RoleService.UpsertRole(Int32 roleId, String roleName, String profileId, RoleTransRightsTableType transRights, List`1 roleMaster, List`1 menuActionAddition, List`1 menuActionExclusion) in D:\SOURCECODE\Sang.WebApi\Sang.Security.WebApi\Services\RoleService.cs:line 50 at Sang.Security.WebApi.Controllers.RoleController.UpsertRole(RoleDetails roleDetails) in D:\SOURCECODE\Sang.WebApi\Sang.Security.WebApi\Controllers\RoleController.cs:line 253 2024-04-29 14:14:24.496 +05:30 63a80c21-8253-4d2d-a806-40925e9ba681 ERR The INSERT statement conflicted with the FOREIGN KEY constraint "fk_iMenuId_t_s_RolesExtraRights". The conflict occurred in database "SANG_01", table "dbo.t_m_Menu", column 'iId'. The INSERT statement conflicted with the FOREIGN KEY constraint "fk_iMenuId_t_s_RolesExtraRights". The conflict occurred in database "SANG_01", table "dbo.t_m_Menu", column 'iId'. The statement has been terminated. The statement has been terminated. 2024-04-29 14:14:24.503 +05:30 63a80c21-8253-4d2d-a806-40925e9ba681 ERR The INSERT statement conflicted with the FOREIGN KEY constraint "fk_iMenuId_t_s_RolesExtraRights". The conflict occurred in database "SANG_01", table "dbo.t_m_Menu", column 'iId'. The INSERT statement conflicted with the FOREIGN KEY constraint "fk_iMenuId_t_s_RolesExtraRights". The conflict occurred in database "SANG_01", table "dbo.t_m_Menu", column 'iId'. The statement has been terminated. The statement has been terminated. 2024-04-29 14:14:24.503 +05:30 63a80c21-8253-4d2d-a806-40925e9ba681 ERR Database connection error: The INSERT statement conflicted with the FOREIGN KEY constraint "fk_iMenuId_t_s_RolesExtraRights". The conflict occurred in database "SANG_01", table "dbo.t_m_Menu", column 'iId'. The INSERT statement conflicted with the FOREIGN KEY constraint "fk_iMenuId_t_s_RolesExtraRights". The conflict occurred in database "SANG_01", table "dbo.t_m_Menu", column 'iId'. The statement has been terminated. The statement has been terminated. 2024-04-29 14:14:24.508 +05:30 63a80c21-8253-4d2d-a806-40925e9ba681 ERR Upserting Role Failed System.Exception: Database connection error: The INSERT statement conflicted with the FOREIGN KEY constraint "fk_iMenuId_t_s_RolesExtraRights". The conflict occurred in database "SANG_01", table "dbo.t_m_Menu", column 'iId'. The INSERT statement conflicted with the FOREIGN KEY constraint "fk_iMenuId_t_s_RolesExtraRights". The conflict occurred in database "SANG_01", table "dbo.t_m_Menu", column 'iId'. The statement has been terminated. The statement has been terminated. ---> System.Data.SqlClient.SqlException (0x80131904): The INSERT statement conflicted with the FOREIGN KEY constraint "fk_iMenuId_t_s_RolesExtraRights". The conflict occurred in database "SANG_01", table "dbo.t_m_Menu", column 'iId'. The INSERT statement conflicted with the FOREIGN KEY constraint "fk_iMenuId_t_s_RolesExtraRights". The conflict occurred in database "SANG_01", table "dbo.t_m_Menu", column 'iId'. The statement has been terminated. 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.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__DisplayClass15_0.<b__0>d.MoveNext() in D:\SOURCECODE\Sang.WebApi\Sang.Security.WebApi\Repositories\RoleRepository.cs:line 338 --- 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:1229afac-c3c1-4c25-973e-c56a249a7ae8 Error Number:547,State:0,Class:16 --- 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.UpsertRole(Int32 roleId, String roleName, String profileId, RoleTransRightsTableType transRights, List`1 roleMaster, List`1 menuActionAddition, List`1 menuActionExclusion) in D:\SOURCECODE\Sang.WebApi\Sang.Security.WebApi\Repositories\RoleRepository.cs:line 290 at Sang.Security.WebApi.Services.RoleService.UpsertRole(Int32 roleId, String roleName, String profileId, RoleTransRightsTableType transRights, List`1 roleMaster, List`1 menuActionAddition, List`1 menuActionExclusion) in D:\SOURCECODE\Sang.WebApi\Sang.Security.WebApi\Services\RoleService.cs:line 50 at Sang.Security.WebApi.Controllers.RoleController.UpsertRole(RoleDetails roleDetails) in D:\SOURCECODE\Sang.WebApi\Sang.Security.WebApi\Controllers\RoleController.cs:line 253 2024-04-29 14:15:22.911 +05:30 a2d70021-6818-47c2-9fd4-2556bb120d35 ERR The INSERT statement conflicted with the FOREIGN KEY constraint "fk_iMenuId_t_s_RolesExtraRights". The conflict occurred in database "SANG_01", table "dbo.t_m_Menu", column 'iId'. The INSERT statement conflicted with the FOREIGN KEY constraint "fk_iMenuId_t_s_RolesExtraRights". The conflict occurred in database "SANG_01", table "dbo.t_m_Menu", column 'iId'. The statement has been terminated. The statement has been terminated. 2024-04-29 14:15:22.916 +05:30 a2d70021-6818-47c2-9fd4-2556bb120d35 ERR The INSERT statement conflicted with the FOREIGN KEY constraint "fk_iMenuId_t_s_RolesExtraRights". The conflict occurred in database "SANG_01", table "dbo.t_m_Menu", column 'iId'. The INSERT statement conflicted with the FOREIGN KEY constraint "fk_iMenuId_t_s_RolesExtraRights". The conflict occurred in database "SANG_01", table "dbo.t_m_Menu", column 'iId'. The statement has been terminated. The statement has been terminated. 2024-04-29 14:15:22.917 +05:30 a2d70021-6818-47c2-9fd4-2556bb120d35 ERR Database connection error: The INSERT statement conflicted with the FOREIGN KEY constraint "fk_iMenuId_t_s_RolesExtraRights". The conflict occurred in database "SANG_01", table "dbo.t_m_Menu", column 'iId'. The INSERT statement conflicted with the FOREIGN KEY constraint "fk_iMenuId_t_s_RolesExtraRights". The conflict occurred in database "SANG_01", table "dbo.t_m_Menu", column 'iId'. The statement has been terminated. The statement has been terminated. 2024-04-29 14:15:22.921 +05:30 a2d70021-6818-47c2-9fd4-2556bb120d35 ERR Upserting Role Failed System.Exception: Database connection error: The INSERT statement conflicted with the FOREIGN KEY constraint "fk_iMenuId_t_s_RolesExtraRights". The conflict occurred in database "SANG_01", table "dbo.t_m_Menu", column 'iId'. The INSERT statement conflicted with the FOREIGN KEY constraint "fk_iMenuId_t_s_RolesExtraRights". The conflict occurred in database "SANG_01", table "dbo.t_m_Menu", column 'iId'. The statement has been terminated. The statement has been terminated. ---> System.Data.SqlClient.SqlException (0x80131904): The INSERT statement conflicted with the FOREIGN KEY constraint "fk_iMenuId_t_s_RolesExtraRights". The conflict occurred in database "SANG_01", table "dbo.t_m_Menu", column 'iId'. The INSERT statement conflicted with the FOREIGN KEY constraint "fk_iMenuId_t_s_RolesExtraRights". The conflict occurred in database "SANG_01", table "dbo.t_m_Menu", column 'iId'. The statement has been terminated. 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.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__DisplayClass15_0.<b__0>d.MoveNext() in D:\SOURCECODE\Sang.WebApi\Sang.Security.WebApi\Repositories\RoleRepository.cs:line 338 --- 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:1229afac-c3c1-4c25-973e-c56a249a7ae8 Error Number:547,State:0,Class:16 --- 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.UpsertRole(Int32 roleId, String roleName, String profileId, RoleTransRightsTableType transRights, List`1 roleMaster, List`1 menuActionAddition, List`1 menuActionExclusion) in D:\SOURCECODE\Sang.WebApi\Sang.Security.WebApi\Repositories\RoleRepository.cs:line 290 at Sang.Security.WebApi.Services.RoleService.UpsertRole(Int32 roleId, String roleName, String profileId, RoleTransRightsTableType transRights, List`1 roleMaster, List`1 menuActionAddition, List`1 menuActionExclusion) in D:\SOURCECODE\Sang.WebApi\Sang.Security.WebApi\Services\RoleService.cs:line 50 at Sang.Security.WebApi.Controllers.RoleController.UpsertRole(RoleDetails roleDetails) in D:\SOURCECODE\Sang.WebApi\Sang.Security.WebApi\Controllers\RoleController.cs:line 253 2024-04-29 14:15:56.965 +05:30 c568d5b8-a12c-4375-83c2-efc4dc5db089 ERR The INSERT statement conflicted with the FOREIGN KEY constraint "fk_iMenuId_t_s_RolesExtraRights". The conflict occurred in database "SANG_01", table "dbo.t_m_Menu", column 'iId'. The INSERT statement conflicted with the FOREIGN KEY constraint "fk_iMenuId_t_s_RolesExtraRights". The conflict occurred in database "SANG_01", table "dbo.t_m_Menu", column 'iId'. The statement has been terminated. The statement has been terminated. 2024-04-29 14:15:56.968 +05:30 c568d5b8-a12c-4375-83c2-efc4dc5db089 ERR The INSERT statement conflicted with the FOREIGN KEY constraint "fk_iMenuId_t_s_RolesExtraRights". The conflict occurred in database "SANG_01", table "dbo.t_m_Menu", column 'iId'. The INSERT statement conflicted with the FOREIGN KEY constraint "fk_iMenuId_t_s_RolesExtraRights". The conflict occurred in database "SANG_01", table "dbo.t_m_Menu", column 'iId'. The statement has been terminated. The statement has been terminated. 2024-04-29 14:15:56.969 +05:30 c568d5b8-a12c-4375-83c2-efc4dc5db089 ERR Database connection error: The INSERT statement conflicted with the FOREIGN KEY constraint "fk_iMenuId_t_s_RolesExtraRights". The conflict occurred in database "SANG_01", table "dbo.t_m_Menu", column 'iId'. The INSERT statement conflicted with the FOREIGN KEY constraint "fk_iMenuId_t_s_RolesExtraRights". The conflict occurred in database "SANG_01", table "dbo.t_m_Menu", column 'iId'. The statement has been terminated. The statement has been terminated. 2024-04-29 14:15:56.973 +05:30 c568d5b8-a12c-4375-83c2-efc4dc5db089 ERR Upserting Role Failed System.Exception: Database connection error: The INSERT statement conflicted with the FOREIGN KEY constraint "fk_iMenuId_t_s_RolesExtraRights". The conflict occurred in database "SANG_01", table "dbo.t_m_Menu", column 'iId'. The INSERT statement conflicted with the FOREIGN KEY constraint "fk_iMenuId_t_s_RolesExtraRights". The conflict occurred in database "SANG_01", table "dbo.t_m_Menu", column 'iId'. The statement has been terminated. The statement has been terminated. ---> System.Data.SqlClient.SqlException (0x80131904): The INSERT statement conflicted with the FOREIGN KEY constraint "fk_iMenuId_t_s_RolesExtraRights". The conflict occurred in database "SANG_01", table "dbo.t_m_Menu", column 'iId'. The INSERT statement conflicted with the FOREIGN KEY constraint "fk_iMenuId_t_s_RolesExtraRights". The conflict occurred in database "SANG_01", table "dbo.t_m_Menu", column 'iId'. The statement has been terminated. 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.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__DisplayClass15_0.<b__0>d.MoveNext() in D:\SOURCECODE\Sang.WebApi\Sang.Security.WebApi\Repositories\RoleRepository.cs:line 338 --- 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:1229afac-c3c1-4c25-973e-c56a249a7ae8 Error Number:547,State:0,Class:16 --- 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.UpsertRole(Int32 roleId, String roleName, String profileId, RoleTransRightsTableType transRights, List`1 roleMaster, List`1 menuActionAddition, List`1 menuActionExclusion) in D:\SOURCECODE\Sang.WebApi\Sang.Security.WebApi\Repositories\RoleRepository.cs:line 290 at Sang.Security.WebApi.Services.RoleService.UpsertRole(Int32 roleId, String roleName, String profileId, RoleTransRightsTableType transRights, List`1 roleMaster, List`1 menuActionAddition, List`1 menuActionExclusion) in D:\SOURCECODE\Sang.WebApi\Sang.Security.WebApi\Services\RoleService.cs:line 50 at Sang.Security.WebApi.Controllers.RoleController.UpsertRole(RoleDetails roleDetails) in D:\SOURCECODE\Sang.WebApi\Sang.Security.WebApi\Controllers\RoleController.cs:line 253 2024-04-29 14:17:44.534 +05:30 a0040f5f-b32f-45d6-a6c5-5202ca36756b ERR The INSERT statement conflicted with the FOREIGN KEY constraint "fk_iMenuId_t_s_RolesExtraRights". The conflict occurred in database "SANG_01", table "dbo.t_m_Menu", column 'iId'. The INSERT statement conflicted with the FOREIGN KEY constraint "fk_iMenuId_t_s_RolesExtraRights". The conflict occurred in database "SANG_01", table "dbo.t_m_Menu", column 'iId'. The statement has been terminated. The statement has been terminated. 2024-04-29 14:17:44.537 +05:30 a0040f5f-b32f-45d6-a6c5-5202ca36756b ERR The INSERT statement conflicted with the FOREIGN KEY constraint "fk_iMenuId_t_s_RolesExtraRights". The conflict occurred in database "SANG_01", table "dbo.t_m_Menu", column 'iId'. The INSERT statement conflicted with the FOREIGN KEY constraint "fk_iMenuId_t_s_RolesExtraRights". The conflict occurred in database "SANG_01", table "dbo.t_m_Menu", column 'iId'. The statement has been terminated. The statement has been terminated. 2024-04-29 14:17:44.538 +05:30 a0040f5f-b32f-45d6-a6c5-5202ca36756b ERR Database connection error: The INSERT statement conflicted with the FOREIGN KEY constraint "fk_iMenuId_t_s_RolesExtraRights". The conflict occurred in database "SANG_01", table "dbo.t_m_Menu", column 'iId'. The INSERT statement conflicted with the FOREIGN KEY constraint "fk_iMenuId_t_s_RolesExtraRights". The conflict occurred in database "SANG_01", table "dbo.t_m_Menu", column 'iId'. The statement has been terminated. The statement has been terminated. 2024-04-29 14:17:44.541 +05:30 a0040f5f-b32f-45d6-a6c5-5202ca36756b ERR Upserting Role Failed System.Exception: Database connection error: The INSERT statement conflicted with the FOREIGN KEY constraint "fk_iMenuId_t_s_RolesExtraRights". The conflict occurred in database "SANG_01", table "dbo.t_m_Menu", column 'iId'. The INSERT statement conflicted with the FOREIGN KEY constraint "fk_iMenuId_t_s_RolesExtraRights". The conflict occurred in database "SANG_01", table "dbo.t_m_Menu", column 'iId'. The statement has been terminated. The statement has been terminated. ---> System.Data.SqlClient.SqlException (0x80131904): The INSERT statement conflicted with the FOREIGN KEY constraint "fk_iMenuId_t_s_RolesExtraRights". The conflict occurred in database "SANG_01", table "dbo.t_m_Menu", column 'iId'. The INSERT statement conflicted with the FOREIGN KEY constraint "fk_iMenuId_t_s_RolesExtraRights". The conflict occurred in database "SANG_01", table "dbo.t_m_Menu", column 'iId'. The statement has been terminated. 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.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__DisplayClass15_0.<b__0>d.MoveNext() in D:\SOURCECODE\Sang.WebApi\Sang.Security.WebApi\Repositories\RoleRepository.cs:line 338 --- 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:1229afac-c3c1-4c25-973e-c56a249a7ae8 Error Number:547,State:0,Class:16 --- 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.UpsertRole(Int32 roleId, String roleName, String profileId, RoleTransRightsTableType transRights, List`1 roleMaster, List`1 menuActionAddition, List`1 menuActionExclusion) in D:\SOURCECODE\Sang.WebApi\Sang.Security.WebApi\Repositories\RoleRepository.cs:line 290 at Sang.Security.WebApi.Services.RoleService.UpsertRole(Int32 roleId, String roleName, String profileId, RoleTransRightsTableType transRights, List`1 roleMaster, List`1 menuActionAddition, List`1 menuActionExclusion) in D:\SOURCECODE\Sang.WebApi\Sang.Security.WebApi\Services\RoleService.cs:line 50 at Sang.Security.WebApi.Controllers.RoleController.UpsertRole(RoleDetails roleDetails) in D:\SOURCECODE\Sang.WebApi\Sang.Security.WebApi\Controllers\RoleController.cs:line 253 2024-04-29 14:48:43.752 +05:30 199d4f3f-5abf-4cac-a3d1-5bf30e456411 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-04-29 14:48:44.021 +05:30 b96db451-0601-436a-a885-53d875fe1b1a 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-04-29 14:48:44.169 +05:30 46a3c0d4-a925-4387-9628-d939b8c8997b 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-04-29 14:48:44.330 +05:30 a6bab8e7-5aff-484a-b1d7-9b20c4cf0433 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-04-29 14:49:17.282 +05:30 21049b7a-ea94-42a9-b4b0-c17ef40bb01a ERR Incorrect syntax near 'Sch'. Unclosed quotation mark after the character string ' and isnull(istatus,0)=0 order by sName'. 2024-04-29 14:49:17.282 +05:30 fbc7e071-2b2a-4d0f-a7f9-4d3fb1ccee29 ERR Incorrect syntax near 'Sch'. Unclosed quotation mark after the character string ' and isnull(istatus,0)=0 order by sName'. 2024-04-29 14:49:17.285 +05:30 21049b7a-ea94-42a9-b4b0-c17ef40bb01a ERR Incorrect syntax near 'Sch'. Unclosed quotation mark after the character string ' and isnull(istatus,0)=0 order by sName'. 2024-04-29 14:49:17.285 +05:30 fbc7e071-2b2a-4d0f-a7f9-4d3fb1ccee29 ERR Incorrect syntax near 'Sch'. Unclosed quotation mark after the character string ' and isnull(istatus,0)=0 order by sName'. 2024-04-29 14:49:17.285 +05:30 21049b7a-ea94-42a9-b4b0-c17ef40bb01a ERR Database connection error: Incorrect syntax near 'Sch'. Unclosed quotation mark after the character string ' and isnull(istatus,0)=0 order by sName'. 2024-04-29 14:49:17.285 +05:30 fbc7e071-2b2a-4d0f-a7f9-4d3fb1ccee29 ERR Database connection error: Incorrect syntax near 'Sch'. Unclosed quotation mark after the character string ' and isnull(istatus,0)=0 order by sName'. 2024-04-29 14:49:17.298 +05:30 21049b7a-ea94-42a9-b4b0-c17ef40bb01a ERR Getting Master Data for Master failed System.Exception: Database connection error: Incorrect syntax near 'Sch'. Unclosed quotation mark after the character string ' and isnull(istatus,0)=0 order by sName'. ---> System.Data.SqlClient.SqlException (0x80131904): Incorrect syntax near 'Sch'. Unclosed quotation mark after the character string ' 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:5ec3ea19-c389-42ae-a04f-fca274e70265 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 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-04-29 14:49:17.298 +05:30 fbc7e071-2b2a-4d0f-a7f9-4d3fb1ccee29 ERR Getting Master Data for Master failed System.Exception: Database connection error: Incorrect syntax near 'Sch'. Unclosed quotation mark after the character string ' and isnull(istatus,0)=0 order by sName'. ---> System.Data.SqlClient.SqlException (0x80131904): Incorrect syntax near 'Sch'. Unclosed quotation mark after the character string ' 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:efa3dcca-762c-4dc2-b0be-0e08ea1b98f0 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 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-04-29 14:51:22.450 +05:30 ba5986b0-b9da-4993-a6ce-42083016f80a ERR Incorrect syntax near 'Sch'. Unclosed quotation mark after the character string ' and isnull(istatus,0)=0 order by sName'. 2024-04-29 14:51:22.451 +05:30 ba5986b0-b9da-4993-a6ce-42083016f80a ERR Incorrect syntax near 'Sch'. Unclosed quotation mark after the character string ' and isnull(istatus,0)=0 order by sName'. 2024-04-29 14:51:22.451 +05:30 ba5986b0-b9da-4993-a6ce-42083016f80a ERR Database connection error: Incorrect syntax near 'Sch'. Unclosed quotation mark after the character string ' and isnull(istatus,0)=0 order by sName'. 2024-04-29 14:51:22.455 +05:30 ba5986b0-b9da-4993-a6ce-42083016f80a ERR Getting Master Data for Master failed System.Exception: Database connection error: Incorrect syntax near 'Sch'. Unclosed quotation mark after the character string ' and isnull(istatus,0)=0 order by sName'. ---> System.Data.SqlClient.SqlException (0x80131904): Incorrect syntax near 'Sch'. Unclosed quotation mark after the character string ' 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.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.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:5ec3ea19-c389-42ae-a04f-fca274e70265 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 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-04-29 14:51:22.505 +05:30 31f8da31-bcca-420e-b77d-e7c6c0570200 ERR Incorrect syntax near 'Sch'. Unclosed quotation mark after the character string ' and isnull(istatus,0)=0 order by sName'. 2024-04-29 14:51:22.506 +05:30 31f8da31-bcca-420e-b77d-e7c6c0570200 ERR Incorrect syntax near 'Sch'. Unclosed quotation mark after the character string ' and isnull(istatus,0)=0 order by sName'. 2024-04-29 14:51:22.506 +05:30 31f8da31-bcca-420e-b77d-e7c6c0570200 ERR Database connection error: Incorrect syntax near 'Sch'. Unclosed quotation mark after the character string ' and isnull(istatus,0)=0 order by sName'. 2024-04-29 14:51:22.508 +05:30 31f8da31-bcca-420e-b77d-e7c6c0570200 ERR Getting Master Data for Master failed System.Exception: Database connection error: Incorrect syntax near 'Sch'. Unclosed quotation mark after the character string ' and isnull(istatus,0)=0 order by sName'. ---> System.Data.SqlClient.SqlException (0x80131904): Incorrect syntax near 'Sch'. Unclosed quotation mark after the character string ' 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.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.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:5ec3ea19-c389-42ae-a04f-fca274e70265 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 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-04-29 14:51:56.520 +05:30 f57799ab-8ddb-44aa-b577-30201020779e ERR Incorrect syntax near 'Sch'. Unclosed quotation mark after the character string ' and isnull(istatus,0)=0 order by sName'. 2024-04-29 14:51:56.522 +05:30 df6a6922-af3e-41d3-a3a3-bc109bec2dfa ERR Incorrect syntax near 'Sch'. Unclosed quotation mark after the character string ' and isnull(istatus,0)=0 order by sName'. 2024-04-29 14:51:56.522 +05:30 f57799ab-8ddb-44aa-b577-30201020779e ERR Incorrect syntax near 'Sch'. Unclosed quotation mark after the character string ' and isnull(istatus,0)=0 order by sName'. 2024-04-29 14:51:56.522 +05:30 f57799ab-8ddb-44aa-b577-30201020779e ERR Database connection error: Incorrect syntax near 'Sch'. Unclosed quotation mark after the character string ' and isnull(istatus,0)=0 order by sName'. 2024-04-29 14:51:56.523 +05:30 df6a6922-af3e-41d3-a3a3-bc109bec2dfa ERR Incorrect syntax near 'Sch'. Unclosed quotation mark after the character string ' and isnull(istatus,0)=0 order by sName'. 2024-04-29 14:51:56.523 +05:30 df6a6922-af3e-41d3-a3a3-bc109bec2dfa ERR Database connection error: Incorrect syntax near 'Sch'. Unclosed quotation mark after the character string ' and isnull(istatus,0)=0 order by sName'. 2024-04-29 14:51:56.525 +05:30 df6a6922-af3e-41d3-a3a3-bc109bec2dfa ERR Getting Master Data for Master failed System.Exception: Database connection error: Incorrect syntax near 'Sch'. Unclosed quotation mark after the character string ' and isnull(istatus,0)=0 order by sName'. ---> System.Data.SqlClient.SqlException (0x80131904): Incorrect syntax near 'Sch'. Unclosed quotation mark after the character string ' 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.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.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:49b106f8-2d4d-4351-a818-fcaf2701589d 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 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-04-29 14:51:56.525 +05:30 f57799ab-8ddb-44aa-b577-30201020779e ERR Getting Master Data for Master failed System.Exception: Database connection error: Incorrect syntax near 'Sch'. Unclosed quotation mark after the character string ' and isnull(istatus,0)=0 order by sName'. ---> System.Data.SqlClient.SqlException (0x80131904): Incorrect syntax near 'Sch'. Unclosed quotation mark after the character string ' 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.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.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:6843f3df-2e21-4665-b1c7-907b5ba22a33 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 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-04-29 14:51:56.536 +05:30 b010705e-8c03-43f1-822a-6f785a408bf4 ERR Incorrect syntax near 'Sch'. Unclosed quotation mark after the character string ' and isnull(istatus,0)=0 order by sName'. 2024-04-29 14:51:56.538 +05:30 b010705e-8c03-43f1-822a-6f785a408bf4 ERR Incorrect syntax near 'Sch'. Unclosed quotation mark after the character string ' and isnull(istatus,0)=0 order by sName'. 2024-04-29 14:51:56.538 +05:30 b010705e-8c03-43f1-822a-6f785a408bf4 ERR Database connection error: Incorrect syntax near 'Sch'. Unclosed quotation mark after the character string ' and isnull(istatus,0)=0 order by sName'. 2024-04-29 14:51:56.539 +05:30 b010705e-8c03-43f1-822a-6f785a408bf4 ERR Getting Master Data for Master failed System.Exception: Database connection error: Incorrect syntax near 'Sch'. Unclosed quotation mark after the character string ' and isnull(istatus,0)=0 order by sName'. ---> System.Data.SqlClient.SqlException (0x80131904): Incorrect syntax near 'Sch'. Unclosed quotation mark after the character string ' 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.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.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:49b106f8-2d4d-4351-a818-fcaf2701589d 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 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-04-29 14:54:16.582 +05:30 e7c38508-3e12-4d45-9511-9b5b69ec1c1d ERR Incorrect syntax near 'Sch'. Unclosed quotation mark after the character string ' and isnull(istatus,0)=0 order by sName'. 2024-04-29 14:54:16.587 +05:30 e7c38508-3e12-4d45-9511-9b5b69ec1c1d ERR Incorrect syntax near 'Sch'. Unclosed quotation mark after the character string ' and isnull(istatus,0)=0 order by sName'. 2024-04-29 14:54:16.588 +05:30 e7c38508-3e12-4d45-9511-9b5b69ec1c1d ERR Database connection error: Incorrect syntax near 'Sch'. Unclosed quotation mark after the character string ' and isnull(istatus,0)=0 order by sName'. 2024-04-29 14:54:16.592 +05:30 e7c38508-3e12-4d45-9511-9b5b69ec1c1d ERR Getting Master Data for Master failed System.Exception: Database connection error: Incorrect syntax near 'Sch'. Unclosed quotation mark after the character string ' and isnull(istatus,0)=0 order by sName'. ---> System.Data.SqlClient.SqlException (0x80131904): Incorrect syntax near 'Sch'. Unclosed quotation mark after the character string ' 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.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.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:efa3dcca-762c-4dc2-b0be-0e08ea1b98f0 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 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-04-29 14:54:16.936 +05:30 5c65f3f9-00f1-46b0-a709-56097d4cec1d ERR Incorrect syntax near 'Sch'. Unclosed quotation mark after the character string ' and isnull(istatus,0)=0 order by sName'. 2024-04-29 14:54:16.938 +05:30 5c65f3f9-00f1-46b0-a709-56097d4cec1d ERR Incorrect syntax near 'Sch'. Unclosed quotation mark after the character string ' and isnull(istatus,0)=0 order by sName'. 2024-04-29 14:54:16.938 +05:30 5c65f3f9-00f1-46b0-a709-56097d4cec1d ERR Database connection error: Incorrect syntax near 'Sch'. Unclosed quotation mark after the character string ' and isnull(istatus,0)=0 order by sName'. 2024-04-29 14:54:16.940 +05:30 5c65f3f9-00f1-46b0-a709-56097d4cec1d ERR Getting Master Data for Master failed System.Exception: Database connection error: Incorrect syntax near 'Sch'. Unclosed quotation mark after the character string ' and isnull(istatus,0)=0 order by sName'. ---> System.Data.SqlClient.SqlException (0x80131904): Incorrect syntax near 'Sch'. Unclosed quotation mark after the character string ' 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.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.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:efa3dcca-762c-4dc2-b0be-0e08ea1b98f0 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 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-04-29 15:10:34.000 +05:30 c3583033-9a09-4def-939e-e7a263d459c1 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-04-29 15:11:05.466 +05:30 4bf894aa-aaf8-4440-824b-51ed06253481 ERR Incorrect syntax near 'Sch'. Unclosed quotation mark after the character string ' and isnull(istatus,0)=0 order by sName'. 2024-04-29 15:11:05.469 +05:30 4bf894aa-aaf8-4440-824b-51ed06253481 ERR Incorrect syntax near 'Sch'. Unclosed quotation mark after the character string ' and isnull(istatus,0)=0 order by sName'. 2024-04-29 15:11:05.469 +05:30 4bf894aa-aaf8-4440-824b-51ed06253481 ERR Database connection error: Incorrect syntax near 'Sch'. Unclosed quotation mark after the character string ' and isnull(istatus,0)=0 order by sName'. 2024-04-29 15:11:05.476 +05:30 4bf894aa-aaf8-4440-824b-51ed06253481 ERR Getting Master Data for Master failed System.Exception: Database connection error: Incorrect syntax near 'Sch'. Unclosed quotation mark after the character string ' and isnull(istatus,0)=0 order by sName'. ---> System.Data.SqlClient.SqlException (0x80131904): Incorrect syntax near 'Sch'. Unclosed quotation mark after the character string ' 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:f3eb72fa-fe06-4231-99b5-9c62d74ac294 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 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-04-29 15:11:05.634 +05:30 647dab71-43ac-4c44-bf0c-bc9a4188ca55 ERR Incorrect syntax near 'Sch'. Unclosed quotation mark after the character string ' and isnull(istatus,0)=0 order by sName'. 2024-04-29 15:11:05.635 +05:30 647dab71-43ac-4c44-bf0c-bc9a4188ca55 ERR Incorrect syntax near 'Sch'. Unclosed quotation mark after the character string ' and isnull(istatus,0)=0 order by sName'. 2024-04-29 15:11:05.636 +05:30 647dab71-43ac-4c44-bf0c-bc9a4188ca55 ERR Database connection error: Incorrect syntax near 'Sch'. Unclosed quotation mark after the character string ' and isnull(istatus,0)=0 order by sName'. 2024-04-29 15:11:05.638 +05:30 647dab71-43ac-4c44-bf0c-bc9a4188ca55 ERR Getting Master Data for Master failed System.Exception: Database connection error: Incorrect syntax near 'Sch'. Unclosed quotation mark after the character string ' and isnull(istatus,0)=0 order by sName'. ---> System.Data.SqlClient.SqlException (0x80131904): Incorrect syntax near 'Sch'. Unclosed quotation mark after the character string ' 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:f3eb72fa-fe06-4231-99b5-9c62d74ac294 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 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-04-29 15:14:40.462 +05:30 dc1ffb74-5c40-48d4-a7bc-fd352c945cbf ERR Incorrect syntax near 'Sch'. Unclosed quotation mark after the character string ' and isnull(istatus,0)=0 order by sName'. 2024-04-29 15:14:40.463 +05:30 dc1ffb74-5c40-48d4-a7bc-fd352c945cbf ERR Incorrect syntax near 'Sch'. Unclosed quotation mark after the character string ' and isnull(istatus,0)=0 order by sName'. 2024-04-29 15:14:40.464 +05:30 dc1ffb74-5c40-48d4-a7bc-fd352c945cbf ERR Database connection error: Incorrect syntax near 'Sch'. Unclosed quotation mark after the character string ' and isnull(istatus,0)=0 order by sName'. 2024-04-29 15:14:40.467 +05:30 dc1ffb74-5c40-48d4-a7bc-fd352c945cbf ERR Getting Master Data for Master failed System.Exception: Database connection error: Incorrect syntax near 'Sch'. Unclosed quotation mark after the character string ' and isnull(istatus,0)=0 order by sName'. ---> System.Data.SqlClient.SqlException (0x80131904): Incorrect syntax near 'Sch'. Unclosed quotation mark after the character string ' 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.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.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:f3eb72fa-fe06-4231-99b5-9c62d74ac294 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 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-04-29 15:14:40.599 +05:30 776a1a06-c476-40f6-aa59-6aa1b355df72 ERR Incorrect syntax near 'Sch'. Unclosed quotation mark after the character string ' and isnull(istatus,0)=0 order by sName'. 2024-04-29 15:14:40.600 +05:30 776a1a06-c476-40f6-aa59-6aa1b355df72 ERR Incorrect syntax near 'Sch'. Unclosed quotation mark after the character string ' and isnull(istatus,0)=0 order by sName'. 2024-04-29 15:14:40.600 +05:30 776a1a06-c476-40f6-aa59-6aa1b355df72 ERR Database connection error: Incorrect syntax near 'Sch'. Unclosed quotation mark after the character string ' and isnull(istatus,0)=0 order by sName'. 2024-04-29 15:14:40.601 +05:30 776a1a06-c476-40f6-aa59-6aa1b355df72 ERR Getting Master Data for Master failed System.Exception: Database connection error: Incorrect syntax near 'Sch'. Unclosed quotation mark after the character string ' and isnull(istatus,0)=0 order by sName'. ---> System.Data.SqlClient.SqlException (0x80131904): Incorrect syntax near 'Sch'. Unclosed quotation mark after the character string ' 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.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.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:f3eb72fa-fe06-4231-99b5-9c62d74ac294 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 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-04-29 15:36:38.715 +05:30 fc095417-95a3-4fa8-8816-8f342c56b43c 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-04-29 15:36:39.224 +05:30 b822ee67-ed11-4583-a7c0-046b9a549474 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-04-29 15:36:39.454 +05:30 cc8f188f-8440-4170-b5ec-3f82eaf8b884 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-04-29 15:36:39.663 +05:30 db3b9a4d-ff48-4642-800c-57468e024376 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-04-29 15:45:26.636 +05:30 1abb12b2-f84c-4d76-816a-07fca414fa72 ERR Incorrect syntax near 'Sch'. Unclosed quotation mark after the character string ' and isnull(istatus,0)=0 order by sName'. 2024-04-29 15:45:26.640 +05:30 1abb12b2-f84c-4d76-816a-07fca414fa72 ERR Incorrect syntax near 'Sch'. Unclosed quotation mark after the character string ' and isnull(istatus,0)=0 order by sName'. 2024-04-29 15:45:26.640 +05:30 1abb12b2-f84c-4d76-816a-07fca414fa72 ERR Database connection error: Incorrect syntax near 'Sch'. Unclosed quotation mark after the character string ' and isnull(istatus,0)=0 order by sName'. 2024-04-29 15:45:26.653 +05:30 1abb12b2-f84c-4d76-816a-07fca414fa72 ERR Getting Master Data for Master failed System.Exception: Database connection error: Incorrect syntax near 'Sch'. Unclosed quotation mark after the character string ' and isnull(istatus,0)=0 order by sName'. ---> System.Data.SqlClient.SqlException (0x80131904): Incorrect syntax near 'Sch'. Unclosed quotation mark after the character string ' 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.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.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:9d25cd55-88c9-42e1-88aa-5ea6c03d1afa 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 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-04-29 15:45:28.889 +05:30 ee902223-69f0-4c1c-8fcd-5c604840274a ERR Incorrect syntax near 'Sch'. Unclosed quotation mark after the character string ' and isnull(istatus,0)=0 order by sName'. 2024-04-29 15:45:28.890 +05:30 ee902223-69f0-4c1c-8fcd-5c604840274a ERR Incorrect syntax near 'Sch'. Unclosed quotation mark after the character string ' and isnull(istatus,0)=0 order by sName'. 2024-04-29 15:45:28.890 +05:30 ee902223-69f0-4c1c-8fcd-5c604840274a ERR Database connection error: Incorrect syntax near 'Sch'. Unclosed quotation mark after the character string ' and isnull(istatus,0)=0 order by sName'. 2024-04-29 15:45:28.892 +05:30 ee902223-69f0-4c1c-8fcd-5c604840274a ERR Getting Master Data for Master failed System.Exception: Database connection error: Incorrect syntax near 'Sch'. Unclosed quotation mark after the character string ' and isnull(istatus,0)=0 order by sName'. ---> System.Data.SqlClient.SqlException (0x80131904): Incorrect syntax near 'Sch'. Unclosed quotation mark after the character string ' 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.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.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:9d25cd55-88c9-42e1-88aa-5ea6c03d1afa 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 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-04-29 15:45:34.587 +05:30 06b250f2-6662-4c7f-b6c9-066698c36975 ERR Incorrect syntax near 'Sch'. Unclosed quotation mark after the character string ' and isnull(istatus,0)=0 order by sName'. 2024-04-29 15:45:34.589 +05:30 06b250f2-6662-4c7f-b6c9-066698c36975 ERR Incorrect syntax near 'Sch'. Unclosed quotation mark after the character string ' and isnull(istatus,0)=0 order by sName'. 2024-04-29 15:45:34.589 +05:30 06b250f2-6662-4c7f-b6c9-066698c36975 ERR Database connection error: Incorrect syntax near 'Sch'. Unclosed quotation mark after the character string ' and isnull(istatus,0)=0 order by sName'. 2024-04-29 15:45:34.591 +05:30 06b250f2-6662-4c7f-b6c9-066698c36975 ERR Getting Master Data for Master failed System.Exception: Database connection error: Incorrect syntax near 'Sch'. Unclosed quotation mark after the character string ' and isnull(istatus,0)=0 order by sName'. ---> System.Data.SqlClient.SqlException (0x80131904): Incorrect syntax near 'Sch'. Unclosed quotation mark after the character string ' 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.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.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:958a7845-e36c-43bf-9083-af0130405dad 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 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-04-29 16:02:01.372 +05:30 cde2b78b-9dbb-40c8-a32c-03f1c2b810b9 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-04-29 16:19:41.828 +05:30 96bcacfe-9c9d-49be-b51b-ee98a07ef10e ERR Incorrect syntax near 'Sch'. Unclosed quotation mark after the character string ' and isnull(istatus,0)=0 order by sName'. 2024-04-29 16:19:41.894 +05:30 96bcacfe-9c9d-49be-b51b-ee98a07ef10e ERR Incorrect syntax near 'Sch'. Unclosed quotation mark after the character string ' and isnull(istatus,0)=0 order by sName'. 2024-04-29 16:19:41.896 +05:30 96bcacfe-9c9d-49be-b51b-ee98a07ef10e ERR Database connection error: Incorrect syntax near 'Sch'. Unclosed quotation mark after the character string ' and isnull(istatus,0)=0 order by sName'. 2024-04-29 16:19:41.922 +05:30 96bcacfe-9c9d-49be-b51b-ee98a07ef10e ERR Getting Master Data for Master failed System.Exception: Database connection error: Incorrect syntax near 'Sch'. Unclosed quotation mark after the character string ' and isnull(istatus,0)=0 order by sName'. ---> System.Data.SqlClient.SqlException (0x80131904): Incorrect syntax near 'Sch'. Unclosed quotation mark after the character string ' 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.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.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 260 --- 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:494138f8-d923-4148-954b-a4f69ee8c39a 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 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-04-29 16:19:48.157 +05:30 64f25e15-77b6-48dd-8264-44d3bdfa3e0f ERR Incorrect syntax near 'Sch'. Unclosed quotation mark after the character string ' and isnull(istatus,0)=0 order by sName'. 2024-04-29 16:19:48.164 +05:30 64f25e15-77b6-48dd-8264-44d3bdfa3e0f ERR Incorrect syntax near 'Sch'. Unclosed quotation mark after the character string ' and isnull(istatus,0)=0 order by sName'. 2024-04-29 16:19:48.164 +05:30 64f25e15-77b6-48dd-8264-44d3bdfa3e0f ERR Database connection error: Incorrect syntax near 'Sch'. Unclosed quotation mark after the character string ' and isnull(istatus,0)=0 order by sName'. 2024-04-29 16:19:48.166 +05:30 64f25e15-77b6-48dd-8264-44d3bdfa3e0f ERR Getting Master Data for Master failed System.Exception: Database connection error: Incorrect syntax near 'Sch'. Unclosed quotation mark after the character string ' and isnull(istatus,0)=0 order by sName'. ---> System.Data.SqlClient.SqlException (0x80131904): Incorrect syntax near 'Sch'. Unclosed quotation mark after the character string ' 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.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.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 260 --- 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:494138f8-d923-4148-954b-a4f69ee8c39a 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 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-04-29 16:54:04.432 +05:30 da15da9b-95e0-4365-bdde-672ff70f1d75 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-04-29 16:54:04.758 +05:30 a18fb1b9-4087-4b76-8fe8-e7c162ab429f 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-04-29 16:54:04.998 +05:30 ef903a03-356f-4fb7-bf24-a430f92d635f 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-04-29 16:54:05.177 +05:30 a46650cc-a105-4b18-a535-321604794235 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-04-29 17:01:20.109 +05:30 1a1eb380-0241-4eb3-a460-cb5022133e1c ERR Incorrect syntax near 'Sch'. Unclosed quotation mark after the character string ' and isnull(istatus,0)=0 order by sName'. 2024-04-29 17:01:20.114 +05:30 1a1eb380-0241-4eb3-a460-cb5022133e1c ERR Incorrect syntax near 'Sch'. Unclosed quotation mark after the character string ' and isnull(istatus,0)=0 order by sName'. 2024-04-29 17:01:20.115 +05:30 1a1eb380-0241-4eb3-a460-cb5022133e1c ERR Database connection error: Incorrect syntax near 'Sch'. Unclosed quotation mark after the character string ' and isnull(istatus,0)=0 order by sName'. 2024-04-29 17:01:20.129 +05:30 1a1eb380-0241-4eb3-a460-cb5022133e1c ERR Getting Master Data for Master failed System.Exception: Database connection error: Incorrect syntax near 'Sch'. Unclosed quotation mark after the character string ' and isnull(istatus,0)=0 order by sName'. ---> System.Data.SqlClient.SqlException (0x80131904): Incorrect syntax near 'Sch'. Unclosed quotation mark after the character string ' 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:985638ba-e1db-4632-9c82-bbbcc76e2ccc 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 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-04-29 17:19:33.170 +05:30 634ddde6-1d11-4977-8c17-786ce68dd581 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-04-29 17:19:33.501 +05:30 dfd86c00-541f-4165-a428-159db0c3f932 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-04-29 17:19:33.693 +05:30 93bfc609-ac51-4e1f-bb2e-3e87401cb578 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-04-29 17:19:33.778 +05:30 824974c0-c078-4430-842c-e4497440644a 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-04-29 22:32:07.819 +05:30 1678fca9-5e07-407c-97d8-969854d02117 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-04-29 22:32:08.106 +05:30 025b5927-fd48-40bb-a91e-d766a3db5b64 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-04-29 22:33:21.702 +05:30 9199494c-bf8e-4fd5-a2c5-03a0c845ec21 ERR Incorrect syntax near 'Sch'. Unclosed quotation mark after the character string ' and isnull(istatus,0)=0 order by sName'. 2024-04-29 22:33:21.706 +05:30 9199494c-bf8e-4fd5-a2c5-03a0c845ec21 ERR Incorrect syntax near 'Sch'. Unclosed quotation mark after the character string ' and isnull(istatus,0)=0 order by sName'. 2024-04-29 22:33:21.707 +05:30 9199494c-bf8e-4fd5-a2c5-03a0c845ec21 ERR Database connection error: Incorrect syntax near 'Sch'. Unclosed quotation mark after the character string ' and isnull(istatus,0)=0 order by sName'. 2024-04-29 22:33:21.713 +05:30 9199494c-bf8e-4fd5-a2c5-03a0c845ec21 ERR Getting Master Data for Master failed System.Exception: Database connection error: Incorrect syntax near 'Sch'. Unclosed quotation mark after the character string ' and isnull(istatus,0)=0 order by sName'. ---> System.Data.SqlClient.SqlException (0x80131904): Incorrect syntax near 'Sch'. Unclosed quotation mark after the character string ' 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.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.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:4b982107-e6dd-4867-9877-a3cbee8b1108 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 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-04-29 22:38:46.826 +05:30 aa2e2f58-2a2e-4e7e-be03-be843bd97317 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-04-29 22:38:46.949 +05:30 7d7854d7-961d-4586-87bf-8584493e7350 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-04-29 22:38:47.067 +05:30 e1e750a7-5fcc-44ee-b643-3cea58bff5fe 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-04-29 23:56:50.762 +05:30 496cd2db-fe43-4cf1-8aed-118e54ebacd1 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-04-29 23:56:51.004 +05:30 900c7401-1e2c-4bc7-972f-7e09e8e1f886 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-04-29 23:56:51.183 +05:30 c3556bde-56f7-4509-b2ce-d028da2cf551 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-04-29 23:56:51.564 +05:30 bde78c70-432d-4d47-9b66-f05ec34b7f92 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