2024-04-26 08:47:52.956 +05:30 745de926-753a-4fd1-955b-5039963bc954 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-26 08:47:53.424 +05:30 fd013c8c-e63a-48bf-9c30-4103be4026f1 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-26 08:47:53.586 +05:30 c3a5305a-963a-4b51-ae1b-cf57eb3366dd 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-26 08:47:53.727 +05:30 6f278578-df19-41ea-bc18-ff883d2c1f18 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-26 09:14:01.583 +05:30 7d5b152d-9e2b-4297-aad7-8de122c311ce ERR Token Regeneration failed Microsoft.IdentityModel.Tokens.SecurityTokenExpiredException: Refresh token has expired at Sang.Security.WebApi.Validators.TokenValidator.ValidateToken(String token, String TokenKey) in C:\SOURCECODE\MainFull\Sang.WebApi\Sang.Security.WebApi\Validators\TokenValidator.cs:line 38 at Sang.Security.WebApi.Authentication.TokenService.RefreshToken(String refershToken) in C:\SOURCECODE\MainFull\Sang.WebApi\Sang.Security.WebApi\Authentication\TokenService.cs:line 39 at Sang.Security.WebApi.Controllers.SecurityController.RegenerateTokens(String refershToken) in C:\SOURCECODE\MainFull\Sang.WebApi\Sang.Security.WebApi\Controllers\SecurityController.cs:line 39 2024-04-26 09:14:01.844 +05:30 39783abe-96a5-4e39-844e-62fff5bb3064 ERR Token Regeneration failed Microsoft.IdentityModel.Tokens.SecurityTokenExpiredException: Refresh token has expired at Sang.Security.WebApi.Validators.TokenValidator.ValidateToken(String token, String TokenKey) in C:\SOURCECODE\MainFull\Sang.WebApi\Sang.Security.WebApi\Validators\TokenValidator.cs:line 38 at Sang.Security.WebApi.Authentication.TokenService.RefreshToken(String refershToken) in C:\SOURCECODE\MainFull\Sang.WebApi\Sang.Security.WebApi\Authentication\TokenService.cs:line 39 at Sang.Security.WebApi.Controllers.SecurityController.RegenerateTokens(String refershToken) in C:\SOURCECODE\MainFull\Sang.WebApi\Sang.Security.WebApi\Controllers\SecurityController.cs:line 39 2024-04-26 09:14:02.037 +05:30 c9f5430c-e24d-48dc-a141-afc287a0ad1e ERR Token Regeneration failed Microsoft.IdentityModel.Tokens.SecurityTokenExpiredException: Refresh token has expired at Sang.Security.WebApi.Validators.TokenValidator.ValidateToken(String token, String TokenKey) in C:\SOURCECODE\MainFull\Sang.WebApi\Sang.Security.WebApi\Validators\TokenValidator.cs:line 38 at Sang.Security.WebApi.Authentication.TokenService.RefreshToken(String refershToken) in C:\SOURCECODE\MainFull\Sang.WebApi\Sang.Security.WebApi\Authentication\TokenService.cs:line 39 at Sang.Security.WebApi.Controllers.SecurityController.RegenerateTokens(String refershToken) in C:\SOURCECODE\MainFull\Sang.WebApi\Sang.Security.WebApi\Controllers\SecurityController.cs:line 39 2024-04-26 09:14:02.177 +05:30 c4e62c2a-3b46-463a-89c2-1d6cfd73a2d9 ERR Token Regeneration failed Microsoft.IdentityModel.Tokens.SecurityTokenExpiredException: Refresh token has expired at Sang.Security.WebApi.Validators.TokenValidator.ValidateToken(String token, String TokenKey) in C:\SOURCECODE\MainFull\Sang.WebApi\Sang.Security.WebApi\Validators\TokenValidator.cs:line 38 at Sang.Security.WebApi.Authentication.TokenService.RefreshToken(String refershToken) in C:\SOURCECODE\MainFull\Sang.WebApi\Sang.Security.WebApi\Authentication\TokenService.cs:line 39 at Sang.Security.WebApi.Controllers.SecurityController.RegenerateTokens(String refershToken) in C:\SOURCECODE\MainFull\Sang.WebApi\Sang.Security.WebApi\Controllers\SecurityController.cs:line 39 2024-04-26 09:14:02.317 +05:30 4b17666d-8096-4cf2-9fca-614d08c00fb9 ERR Token Regeneration failed Microsoft.IdentityModel.Tokens.SecurityTokenExpiredException: Refresh token has expired at Sang.Security.WebApi.Validators.TokenValidator.ValidateToken(String token, String TokenKey) in C:\SOURCECODE\MainFull\Sang.WebApi\Sang.Security.WebApi\Validators\TokenValidator.cs:line 38 at Sang.Security.WebApi.Authentication.TokenService.RefreshToken(String refershToken) in C:\SOURCECODE\MainFull\Sang.WebApi\Sang.Security.WebApi\Authentication\TokenService.cs:line 39 at Sang.Security.WebApi.Controllers.SecurityController.RegenerateTokens(String refershToken) in C:\SOURCECODE\MainFull\Sang.WebApi\Sang.Security.WebApi\Controllers\SecurityController.cs:line 39 2024-04-26 09:14:02.492 +05:30 4410b5d4-8b83-44db-b622-ef9ff49c69d5 ERR Token Regeneration failed Microsoft.IdentityModel.Tokens.SecurityTokenExpiredException: Refresh token has expired at Sang.Security.WebApi.Validators.TokenValidator.ValidateToken(String token, String TokenKey) in C:\SOURCECODE\MainFull\Sang.WebApi\Sang.Security.WebApi\Validators\TokenValidator.cs:line 38 at Sang.Security.WebApi.Authentication.TokenService.RefreshToken(String refershToken) in C:\SOURCECODE\MainFull\Sang.WebApi\Sang.Security.WebApi\Authentication\TokenService.cs:line 39 at Sang.Security.WebApi.Controllers.SecurityController.RegenerateTokens(String refershToken) in C:\SOURCECODE\MainFull\Sang.WebApi\Sang.Security.WebApi\Controllers\SecurityController.cs:line 39 2024-04-26 09:15:25.061 +05:30 544c59ed-a202-4802-bdde-5c64084fa99b ERR Incorrect syntax near 'Sch'. Unclosed quotation mark after the character string ' and isnull(istatus,0)=0 order by sName'. 2024-04-26 09:15:25.064 +05:30 544c59ed-a202-4802-bdde-5c64084fa99b ERR Incorrect syntax near 'Sch'. Unclosed quotation mark after the character string ' and isnull(istatus,0)=0 order by sName'. 2024-04-26 09:15:25.064 +05:30 544c59ed-a202-4802-bdde-5c64084fa99b 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-26 09:15:25.073 +05:30 544c59ed-a202-4802-bdde-5c64084fa99b 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 C:\SOURCECODE\MainFull\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 C:\SOURCECODE\MainFull\Sang.WebApi\Sang.Security.WebApi\CommonService\DbTransactionService.cs:line 31 ClientConnectionId:87555a95-0c6e-49b7-b301-3b83d9359d12 Error Number:102,State:1,Class:15 --- End of inner exception stack trace --- at Sang.Security.WebApi.CommonService.DbTransactionService.ExecuteTransactionAsync(Func`3 transactionAction) in C:\SOURCECODE\MainFull\Sang.WebApi\Sang.Security.WebApi\CommonService\DbTransactionService.cs:line 45 at Sang.Security.WebApi.Repositories.RoleRepository.GetMasterData(Int32 masterId, String condition, Int32 typeId) in C:\SOURCECODE\MainFull\Sang.WebApi\Sang.Security.WebApi\Repositories\RoleRepository.cs:line 258 at Sang.Security.WebApi.Services.RoleService.GetMasterData(Int32 masterId, String condition, Int32 typeId) in C:\SOURCECODE\MainFull\Sang.WebApi\Sang.Security.WebApi\Services\RoleService.cs:line 44 at Sang.Security.WebApi.Controllers.RoleController.GetMasterData(Int32 masterId, Int32 typeId, String searchCondition) in C:\SOURCECODE\MainFull\Sang.WebApi\Sang.Security.WebApi\Controllers\RoleController.cs:line 179 2024-04-26 09:25:26.557 +05:30 427f110f-2bbc-496e-8966-1504333c3243 ERR Incorrect syntax near 'Sch'. Unclosed quotation mark after the character string ' and isnull(istatus,0)=0 order by sName'. 2024-04-26 09:25:26.559 +05:30 427f110f-2bbc-496e-8966-1504333c3243 ERR Incorrect syntax near 'Sch'. Unclosed quotation mark after the character string ' and isnull(istatus,0)=0 order by sName'. 2024-04-26 09:25:26.559 +05:30 427f110f-2bbc-496e-8966-1504333c3243 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-26 09:25:26.562 +05:30 427f110f-2bbc-496e-8966-1504333c3243 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 C:\SOURCECODE\MainFull\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 C:\SOURCECODE\MainFull\Sang.WebApi\Sang.Security.WebApi\CommonService\DbTransactionService.cs:line 31 ClientConnectionId:d28820e6-5b81-428a-90f4-898ffe686ffd Error Number:102,State:1,Class:15 --- End of inner exception stack trace --- at Sang.Security.WebApi.CommonService.DbTransactionService.ExecuteTransactionAsync(Func`3 transactionAction) in C:\SOURCECODE\MainFull\Sang.WebApi\Sang.Security.WebApi\CommonService\DbTransactionService.cs:line 45 at Sang.Security.WebApi.Repositories.RoleRepository.GetMasterData(Int32 masterId, String condition, Int32 typeId) in C:\SOURCECODE\MainFull\Sang.WebApi\Sang.Security.WebApi\Repositories\RoleRepository.cs:line 258 at Sang.Security.WebApi.Services.RoleService.GetMasterData(Int32 masterId, String condition, Int32 typeId) in C:\SOURCECODE\MainFull\Sang.WebApi\Sang.Security.WebApi\Services\RoleService.cs:line 44 at Sang.Security.WebApi.Controllers.RoleController.GetMasterData(Int32 masterId, Int32 typeId, String searchCondition) in C:\SOURCECODE\MainFull\Sang.WebApi\Sang.Security.WebApi\Controllers\RoleController.cs:line 179 2024-04-26 09:25:41.229 +05:30 99f49686-07f2-464f-a84e-116a1b650ff7 ERR Incorrect syntax near 'Sch'. Unclosed quotation mark after the character string ' and isnull(istatus,0)=0 order by sName'. 2024-04-26 09:25:41.232 +05:30 99f49686-07f2-464f-a84e-116a1b650ff7 ERR Incorrect syntax near 'Sch'. Unclosed quotation mark after the character string ' and isnull(istatus,0)=0 order by sName'. 2024-04-26 09:25:41.233 +05:30 99f49686-07f2-464f-a84e-116a1b650ff7 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-26 09:25:41.236 +05:30 99f49686-07f2-464f-a84e-116a1b650ff7 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 C:\SOURCECODE\MainFull\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 C:\SOURCECODE\MainFull\Sang.WebApi\Sang.Security.WebApi\CommonService\DbTransactionService.cs:line 31 ClientConnectionId:324d80c2-3812-4a41-b10d-538e78ddabe6 Error Number:102,State:1,Class:15 --- End of inner exception stack trace --- at Sang.Security.WebApi.CommonService.DbTransactionService.ExecuteTransactionAsync(Func`3 transactionAction) in C:\SOURCECODE\MainFull\Sang.WebApi\Sang.Security.WebApi\CommonService\DbTransactionService.cs:line 45 at Sang.Security.WebApi.Repositories.RoleRepository.GetMasterData(Int32 masterId, String condition, Int32 typeId) in C:\SOURCECODE\MainFull\Sang.WebApi\Sang.Security.WebApi\Repositories\RoleRepository.cs:line 258 at Sang.Security.WebApi.Services.RoleService.GetMasterData(Int32 masterId, String condition, Int32 typeId) in C:\SOURCECODE\MainFull\Sang.WebApi\Sang.Security.WebApi\Services\RoleService.cs:line 44 at Sang.Security.WebApi.Controllers.RoleController.GetMasterData(Int32 masterId, Int32 typeId, String searchCondition) in C:\SOURCECODE\MainFull\Sang.WebApi\Sang.Security.WebApi\Controllers\RoleController.cs:line 179 2024-04-26 09:44:43.443 +05:30 1fd8ab2f-3d7d-432f-b535-9ca2c96adf22 ERR Token Regeneration failed Microsoft.IdentityModel.Tokens.SecurityTokenExpiredException: Refresh token has expired at Sang.Security.WebApi.Validators.TokenValidator.ValidateToken(String token, String TokenKey) in C:\SOURCECODE\MainFull\Sang.WebApi\Sang.Security.WebApi\Validators\TokenValidator.cs:line 38 at Sang.Security.WebApi.Authentication.TokenService.RefreshToken(String refershToken) in C:\SOURCECODE\MainFull\Sang.WebApi\Sang.Security.WebApi\Authentication\TokenService.cs:line 39 at Sang.Security.WebApi.Controllers.SecurityController.RegenerateTokens(String refershToken) in C:\SOURCECODE\MainFull\Sang.WebApi\Sang.Security.WebApi\Controllers\SecurityController.cs:line 39 2024-04-26 09:48:56.823 +05:30 40c16035-e984-4ddd-bef9-fbed36551aca ERR Incorrect syntax near 'Sch'. Unclosed quotation mark after the character string ' and isnull(istatus,0)=0 order by sName'. 2024-04-26 09:48:56.825 +05:30 40c16035-e984-4ddd-bef9-fbed36551aca ERR Incorrect syntax near 'Sch'. Unclosed quotation mark after the character string ' and isnull(istatus,0)=0 order by sName'. 2024-04-26 09:48:56.825 +05:30 40c16035-e984-4ddd-bef9-fbed36551aca 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-26 09:48:56.829 +05:30 40c16035-e984-4ddd-bef9-fbed36551aca 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 C:\SOURCECODE\MainFull\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 C:\SOURCECODE\MainFull\Sang.WebApi\Sang.Security.WebApi\CommonService\DbTransactionService.cs:line 31 ClientConnectionId:303e3241-23e0-4268-b8a9-7c6b686cd38f Error Number:102,State:1,Class:15 --- End of inner exception stack trace --- at Sang.Security.WebApi.CommonService.DbTransactionService.ExecuteTransactionAsync(Func`3 transactionAction) in C:\SOURCECODE\MainFull\Sang.WebApi\Sang.Security.WebApi\CommonService\DbTransactionService.cs:line 45 at Sang.Security.WebApi.Repositories.RoleRepository.GetMasterData(Int32 masterId, String condition, Int32 typeId) in C:\SOURCECODE\MainFull\Sang.WebApi\Sang.Security.WebApi\Repositories\RoleRepository.cs:line 258 at Sang.Security.WebApi.Services.RoleService.GetMasterData(Int32 masterId, String condition, Int32 typeId) in C:\SOURCECODE\MainFull\Sang.WebApi\Sang.Security.WebApi\Services\RoleService.cs:line 44 at Sang.Security.WebApi.Controllers.RoleController.GetMasterData(Int32 masterId, Int32 typeId, String searchCondition) in C:\SOURCECODE\MainFull\Sang.WebApi\Sang.Security.WebApi\Controllers\RoleController.cs:line 179 2024-04-26 09:49:36.058 +05:30 7af3b28f-df36-44be-b16f-55187662f989 ERR Incorrect syntax near 'Sch'. Unclosed quotation mark after the character string ' and isnull(istatus,0)=0 order by sName'. 2024-04-26 09:49:36.059 +05:30 7af3b28f-df36-44be-b16f-55187662f989 ERR Incorrect syntax near 'Sch'. Unclosed quotation mark after the character string ' and isnull(istatus,0)=0 order by sName'. 2024-04-26 09:49:36.060 +05:30 7af3b28f-df36-44be-b16f-55187662f989 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-26 09:49:36.062 +05:30 7af3b28f-df36-44be-b16f-55187662f989 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 C:\SOURCECODE\MainFull\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 C:\SOURCECODE\MainFull\Sang.WebApi\Sang.Security.WebApi\CommonService\DbTransactionService.cs:line 31 ClientConnectionId:4be88a83-0f2b-4feb-8219-3603eecbf0a8 Error Number:102,State:1,Class:15 --- End of inner exception stack trace --- at Sang.Security.WebApi.CommonService.DbTransactionService.ExecuteTransactionAsync(Func`3 transactionAction) in C:\SOURCECODE\MainFull\Sang.WebApi\Sang.Security.WebApi\CommonService\DbTransactionService.cs:line 45 at Sang.Security.WebApi.Repositories.RoleRepository.GetMasterData(Int32 masterId, String condition, Int32 typeId) in C:\SOURCECODE\MainFull\Sang.WebApi\Sang.Security.WebApi\Repositories\RoleRepository.cs:line 258 at Sang.Security.WebApi.Services.RoleService.GetMasterData(Int32 masterId, String condition, Int32 typeId) in C:\SOURCECODE\MainFull\Sang.WebApi\Sang.Security.WebApi\Services\RoleService.cs:line 44 at Sang.Security.WebApi.Controllers.RoleController.GetMasterData(Int32 masterId, Int32 typeId, String searchCondition) in C:\SOURCECODE\MainFull\Sang.WebApi\Sang.Security.WebApi\Controllers\RoleController.cs:line 179 2024-04-26 09:57:06.515 +05:30 0878fc82-b0b2-46b4-8fdf-0c3e8647f1e5 ERR Incorrect syntax near 'Sch'. Unclosed quotation mark after the character string ' and isnull(istatus,0)=0 order by sName'. 2024-04-26 09:57:06.516 +05:30 0878fc82-b0b2-46b4-8fdf-0c3e8647f1e5 ERR Incorrect syntax near 'Sch'. Unclosed quotation mark after the character string ' and isnull(istatus,0)=0 order by sName'. 2024-04-26 09:57:06.519 +05:30 0878fc82-b0b2-46b4-8fdf-0c3e8647f1e5 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-26 09:57:06.527 +05:30 0878fc82-b0b2-46b4-8fdf-0c3e8647f1e5 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 C:\SOURCECODE\MainFull\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 C:\SOURCECODE\MainFull\Sang.WebApi\Sang.Security.WebApi\CommonService\DbTransactionService.cs:line 31 ClientConnectionId:32089ac3-f9a3-4f8b-b6e6-267c7a8886ba Error Number:102,State:1,Class:15 --- End of inner exception stack trace --- at Sang.Security.WebApi.CommonService.DbTransactionService.ExecuteTransactionAsync(Func`3 transactionAction) in C:\SOURCECODE\MainFull\Sang.WebApi\Sang.Security.WebApi\CommonService\DbTransactionService.cs:line 45 at Sang.Security.WebApi.Repositories.RoleRepository.GetMasterData(Int32 masterId, String condition, Int32 typeId) in C:\SOURCECODE\MainFull\Sang.WebApi\Sang.Security.WebApi\Repositories\RoleRepository.cs:line 258 at Sang.Security.WebApi.Services.RoleService.GetMasterData(Int32 masterId, String condition, Int32 typeId) in C:\SOURCECODE\MainFull\Sang.WebApi\Sang.Security.WebApi\Services\RoleService.cs:line 44 at Sang.Security.WebApi.Controllers.RoleController.GetMasterData(Int32 masterId, Int32 typeId, String searchCondition) in C:\SOURCECODE\MainFull\Sang.WebApi\Sang.Security.WebApi\Controllers\RoleController.cs:line 179 2024-04-26 09:58:14.759 +05:30 7b72ae69-1645-45fa-9372-1478bc3a237b ERR Incorrect syntax near 'Sch'. Unclosed quotation mark after the character string ' and isnull(istatus,0)=0 order by sName'. 2024-04-26 09:58:14.761 +05:30 7b72ae69-1645-45fa-9372-1478bc3a237b ERR Incorrect syntax near 'Sch'. Unclosed quotation mark after the character string ' and isnull(istatus,0)=0 order by sName'. 2024-04-26 09:58:14.761 +05:30 7b72ae69-1645-45fa-9372-1478bc3a237b 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-26 09:58:14.763 +05:30 7b72ae69-1645-45fa-9372-1478bc3a237b 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 C:\SOURCECODE\MainFull\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 C:\SOURCECODE\MainFull\Sang.WebApi\Sang.Security.WebApi\CommonService\DbTransactionService.cs:line 31 ClientConnectionId:47ebfd9a-074f-4eaa-88eb-84ecd67bda15 Error Number:102,State:1,Class:15 --- End of inner exception stack trace --- at Sang.Security.WebApi.CommonService.DbTransactionService.ExecuteTransactionAsync(Func`3 transactionAction) in C:\SOURCECODE\MainFull\Sang.WebApi\Sang.Security.WebApi\CommonService\DbTransactionService.cs:line 45 at Sang.Security.WebApi.Repositories.RoleRepository.GetMasterData(Int32 masterId, String condition, Int32 typeId) in C:\SOURCECODE\MainFull\Sang.WebApi\Sang.Security.WebApi\Repositories\RoleRepository.cs:line 258 at Sang.Security.WebApi.Services.RoleService.GetMasterData(Int32 masterId, String condition, Int32 typeId) in C:\SOURCECODE\MainFull\Sang.WebApi\Sang.Security.WebApi\Services\RoleService.cs:line 44 at Sang.Security.WebApi.Controllers.RoleController.GetMasterData(Int32 masterId, Int32 typeId, String searchCondition) in C:\SOURCECODE\MainFull\Sang.WebApi\Sang.Security.WebApi\Controllers\RoleController.cs:line 179 2024-04-26 10:02:22.744 +05:30 945fa51e-23c9-492c-901d-70e9891abd04 ERR Token Regeneration failed Microsoft.IdentityModel.Tokens.SecurityTokenExpiredException: Refresh token has expired at Sang.Security.WebApi.Validators.TokenValidator.ValidateToken(String token, String TokenKey) in C:\SOURCECODE\MainFull\Sang.WebApi\Sang.Security.WebApi\Validators\TokenValidator.cs:line 38 at Sang.Security.WebApi.Authentication.TokenService.RefreshToken(String refershToken) in C:\SOURCECODE\MainFull\Sang.WebApi\Sang.Security.WebApi\Authentication\TokenService.cs:line 39 at Sang.Security.WebApi.Controllers.SecurityController.RegenerateTokens(String refershToken) in C:\SOURCECODE\MainFull\Sang.WebApi\Sang.Security.WebApi\Controllers\SecurityController.cs:line 39 2024-04-26 10:07:02.227 +05:30 077a524e-c54b-4886-acd6-557549531a1f ERR Token Regeneration failed Microsoft.IdentityModel.Tokens.SecurityTokenExpiredException: Refresh token has expired at Sang.Security.WebApi.Validators.TokenValidator.ValidateToken(String token, String TokenKey) in C:\SOURCECODE\MainFull\Sang.WebApi\Sang.Security.WebApi\Validators\TokenValidator.cs:line 38 at Sang.Security.WebApi.Authentication.TokenService.RefreshToken(String refershToken) in C:\SOURCECODE\MainFull\Sang.WebApi\Sang.Security.WebApi\Authentication\TokenService.cs:line 39 at Sang.Security.WebApi.Controllers.SecurityController.RegenerateTokens(String refershToken) in C:\SOURCECODE\MainFull\Sang.WebApi\Sang.Security.WebApi\Controllers\SecurityController.cs:line 39 2024-04-26 10:07:02.357 +05:30 67618dda-4651-47a7-8182-5ae23fe06a29 ERR Token Regeneration failed Microsoft.IdentityModel.Tokens.SecurityTokenExpiredException: Refresh token has expired at Sang.Security.WebApi.Validators.TokenValidator.ValidateToken(String token, String TokenKey) in C:\SOURCECODE\MainFull\Sang.WebApi\Sang.Security.WebApi\Validators\TokenValidator.cs:line 38 at Sang.Security.WebApi.Authentication.TokenService.RefreshToken(String refershToken) in C:\SOURCECODE\MainFull\Sang.WebApi\Sang.Security.WebApi\Authentication\TokenService.cs:line 39 at Sang.Security.WebApi.Controllers.SecurityController.RegenerateTokens(String refershToken) in C:\SOURCECODE\MainFull\Sang.WebApi\Sang.Security.WebApi\Controllers\SecurityController.cs:line 39 2024-04-26 10:31:02.124 +05:30 0144f01b-d86f-4951-8f19-9d05bc9b5ebd ERR Incorrect syntax near 'Sch'. Unclosed quotation mark after the character string ' and isnull(istatus,0)=0 order by sName'. 2024-04-26 10:31:02.128 +05:30 0144f01b-d86f-4951-8f19-9d05bc9b5ebd ERR Incorrect syntax near 'Sch'. Unclosed quotation mark after the character string ' and isnull(istatus,0)=0 order by sName'. 2024-04-26 10:31:02.129 +05:30 0144f01b-d86f-4951-8f19-9d05bc9b5ebd 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-26 10:31:02.135 +05:30 0144f01b-d86f-4951-8f19-9d05bc9b5ebd 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 C:\SOURCECODE\MainFull\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 C:\SOURCECODE\MainFull\Sang.WebApi\Sang.Security.WebApi\CommonService\DbTransactionService.cs:line 31 ClientConnectionId:0fe25a52-58a3-4b02-a046-0b94833fc5c7 Error Number:102,State:1,Class:15 --- End of inner exception stack trace --- at Sang.Security.WebApi.CommonService.DbTransactionService.ExecuteTransactionAsync(Func`3 transactionAction) in C:\SOURCECODE\MainFull\Sang.WebApi\Sang.Security.WebApi\CommonService\DbTransactionService.cs:line 45 at Sang.Security.WebApi.Repositories.RoleRepository.GetMasterData(Int32 masterId, String condition, Int32 typeId) in C:\SOURCECODE\MainFull\Sang.WebApi\Sang.Security.WebApi\Repositories\RoleRepository.cs:line 258 at Sang.Security.WebApi.Services.RoleService.GetMasterData(Int32 masterId, String condition, Int32 typeId) in C:\SOURCECODE\MainFull\Sang.WebApi\Sang.Security.WebApi\Services\RoleService.cs:line 44 at Sang.Security.WebApi.Controllers.RoleController.GetMasterData(Int32 masterId, Int32 typeId, String searchCondition) in C:\SOURCECODE\MainFull\Sang.WebApi\Sang.Security.WebApi\Controllers\RoleController.cs:line 179 2024-04-26 10:31:07.919 +05:30 b7f5783b-fb75-4e4e-bc3b-ff8920c04dff ERR Incorrect syntax near 'Sch'. Unclosed quotation mark after the character string ' and isnull(istatus,0)=0 order by sName'. 2024-04-26 10:31:07.920 +05:30 b7f5783b-fb75-4e4e-bc3b-ff8920c04dff ERR Incorrect syntax near 'Sch'. Unclosed quotation mark after the character string ' and isnull(istatus,0)=0 order by sName'. 2024-04-26 10:31:07.920 +05:30 b7f5783b-fb75-4e4e-bc3b-ff8920c04dff 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-26 10:31:07.922 +05:30 b7f5783b-fb75-4e4e-bc3b-ff8920c04dff 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 C:\SOURCECODE\MainFull\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 C:\SOURCECODE\MainFull\Sang.WebApi\Sang.Security.WebApi\CommonService\DbTransactionService.cs:line 31 ClientConnectionId:e952874d-a326-4992-a5a9-3e0e36d6612d Error Number:102,State:1,Class:15 --- End of inner exception stack trace --- at Sang.Security.WebApi.CommonService.DbTransactionService.ExecuteTransactionAsync(Func`3 transactionAction) in C:\SOURCECODE\MainFull\Sang.WebApi\Sang.Security.WebApi\CommonService\DbTransactionService.cs:line 45 at Sang.Security.WebApi.Repositories.RoleRepository.GetMasterData(Int32 masterId, String condition, Int32 typeId) in C:\SOURCECODE\MainFull\Sang.WebApi\Sang.Security.WebApi\Repositories\RoleRepository.cs:line 258 at Sang.Security.WebApi.Services.RoleService.GetMasterData(Int32 masterId, String condition, Int32 typeId) in C:\SOURCECODE\MainFull\Sang.WebApi\Sang.Security.WebApi\Services\RoleService.cs:line 44 at Sang.Security.WebApi.Controllers.RoleController.GetMasterData(Int32 masterId, Int32 typeId, String searchCondition) in C:\SOURCECODE\MainFull\Sang.WebApi\Sang.Security.WebApi\Controllers\RoleController.cs:line 179 2024-04-26 10:34:36.410 +05:30 ffb54d7f-bce9-46ac-9f58-b36a190a7786 ERR Incorrect syntax near 'Sch'. Unclosed quotation mark after the character string ' and isnull(istatus,0)=0 order by sName'. 2024-04-26 10:34:36.411 +05:30 ffb54d7f-bce9-46ac-9f58-b36a190a7786 ERR Incorrect syntax near 'Sch'. Unclosed quotation mark after the character string ' and isnull(istatus,0)=0 order by sName'. 2024-04-26 10:34:36.412 +05:30 ffb54d7f-bce9-46ac-9f58-b36a190a7786 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-26 10:34:36.421 +05:30 ffb54d7f-bce9-46ac-9f58-b36a190a7786 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 C:\SOURCECODE\MainFull\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 C:\SOURCECODE\MainFull\Sang.WebApi\Sang.Security.WebApi\CommonService\DbTransactionService.cs:line 31 ClientConnectionId:eba1ff35-76ba-45e9-8a69-d78c6db322f2 Error Number:102,State:1,Class:15 --- End of inner exception stack trace --- at Sang.Security.WebApi.CommonService.DbTransactionService.ExecuteTransactionAsync(Func`3 transactionAction) in C:\SOURCECODE\MainFull\Sang.WebApi\Sang.Security.WebApi\CommonService\DbTransactionService.cs:line 45 at Sang.Security.WebApi.Repositories.RoleRepository.GetMasterData(Int32 masterId, String condition, Int32 typeId) in C:\SOURCECODE\MainFull\Sang.WebApi\Sang.Security.WebApi\Repositories\RoleRepository.cs:line 258 at Sang.Security.WebApi.Services.RoleService.GetMasterData(Int32 masterId, String condition, Int32 typeId) in C:\SOURCECODE\MainFull\Sang.WebApi\Sang.Security.WebApi\Services\RoleService.cs:line 44 at Sang.Security.WebApi.Controllers.RoleController.GetMasterData(Int32 masterId, Int32 typeId, String searchCondition) in C:\SOURCECODE\MainFull\Sang.WebApi\Sang.Security.WebApi\Controllers\RoleController.cs:line 179 2024-04-26 10:38:03.626 +05:30 651bbdcc-27a1-4811-a34a-36e17618aacc ERR Token Regeneration failed Microsoft.IdentityModel.Tokens.SecurityTokenExpiredException: Refresh token has expired at Sang.Security.WebApi.Validators.TokenValidator.ValidateToken(String token, String TokenKey) in C:\SOURCECODE\MainFull\Sang.WebApi\Sang.Security.WebApi\Validators\TokenValidator.cs:line 38 at Sang.Security.WebApi.Authentication.TokenService.RefreshToken(String refershToken) in C:\SOURCECODE\MainFull\Sang.WebApi\Sang.Security.WebApi\Authentication\TokenService.cs:line 39 at Sang.Security.WebApi.Controllers.SecurityController.RegenerateTokens(String refershToken) in C:\SOURCECODE\MainFull\Sang.WebApi\Sang.Security.WebApi\Controllers\SecurityController.cs:line 39 2024-04-26 10:48:20.819 +05:30 fedfb716-9eb2-46c1-b3cb-3f5e488ae8f2 ERR Incorrect syntax near 'Sch'. Unclosed quotation mark after the character string ' and isnull(istatus,0)=0 order by sName'. 2024-04-26 10:48:20.820 +05:30 fedfb716-9eb2-46c1-b3cb-3f5e488ae8f2 ERR Incorrect syntax near 'Sch'. Unclosed quotation mark after the character string ' and isnull(istatus,0)=0 order by sName'. 2024-04-26 10:48:20.821 +05:30 fedfb716-9eb2-46c1-b3cb-3f5e488ae8f2 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-26 10:48:20.824 +05:30 fedfb716-9eb2-46c1-b3cb-3f5e488ae8f2 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 C:\SOURCECODE\MainFull\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 C:\SOURCECODE\MainFull\Sang.WebApi\Sang.Security.WebApi\CommonService\DbTransactionService.cs:line 31 ClientConnectionId:e9303c7c-5bb2-4a8f-8721-8299d693c560 Error Number:102,State:1,Class:15 --- End of inner exception stack trace --- at Sang.Security.WebApi.CommonService.DbTransactionService.ExecuteTransactionAsync(Func`3 transactionAction) in C:\SOURCECODE\MainFull\Sang.WebApi\Sang.Security.WebApi\CommonService\DbTransactionService.cs:line 45 at Sang.Security.WebApi.Repositories.RoleRepository.GetMasterData(Int32 masterId, String condition, Int32 typeId) in C:\SOURCECODE\MainFull\Sang.WebApi\Sang.Security.WebApi\Repositories\RoleRepository.cs:line 258 at Sang.Security.WebApi.Services.RoleService.GetMasterData(Int32 masterId, String condition, Int32 typeId) in C:\SOURCECODE\MainFull\Sang.WebApi\Sang.Security.WebApi\Services\RoleService.cs:line 44 at Sang.Security.WebApi.Controllers.RoleController.GetMasterData(Int32 masterId, Int32 typeId, String searchCondition) in C:\SOURCECODE\MainFull\Sang.WebApi\Sang.Security.WebApi\Controllers\RoleController.cs:line 179 2024-04-26 10:48:25.716 +05:30 b0011559-ecc0-4e15-89a3-c88e852d6653 ERR Incorrect syntax near 'Sch'. Unclosed quotation mark after the character string ' and isnull(istatus,0)=0 order by sName'. 2024-04-26 10:48:25.723 +05:30 b0011559-ecc0-4e15-89a3-c88e852d6653 ERR Incorrect syntax near 'Sch'. Unclosed quotation mark after the character string ' and isnull(istatus,0)=0 order by sName'. 2024-04-26 10:48:25.724 +05:30 b0011559-ecc0-4e15-89a3-c88e852d6653 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-26 10:48:25.732 +05:30 b0011559-ecc0-4e15-89a3-c88e852d6653 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 C:\SOURCECODE\MainFull\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 C:\SOURCECODE\MainFull\Sang.WebApi\Sang.Security.WebApi\CommonService\DbTransactionService.cs:line 31 ClientConnectionId:e9303c7c-5bb2-4a8f-8721-8299d693c560 Error Number:102,State:1,Class:15 --- End of inner exception stack trace --- at Sang.Security.WebApi.CommonService.DbTransactionService.ExecuteTransactionAsync(Func`3 transactionAction) in C:\SOURCECODE\MainFull\Sang.WebApi\Sang.Security.WebApi\CommonService\DbTransactionService.cs:line 45 at Sang.Security.WebApi.Repositories.RoleRepository.GetMasterData(Int32 masterId, String condition, Int32 typeId) in C:\SOURCECODE\MainFull\Sang.WebApi\Sang.Security.WebApi\Repositories\RoleRepository.cs:line 258 at Sang.Security.WebApi.Services.RoleService.GetMasterData(Int32 masterId, String condition, Int32 typeId) in C:\SOURCECODE\MainFull\Sang.WebApi\Sang.Security.WebApi\Services\RoleService.cs:line 44 at Sang.Security.WebApi.Controllers.RoleController.GetMasterData(Int32 masterId, Int32 typeId, String searchCondition) in C:\SOURCECODE\MainFull\Sang.WebApi\Sang.Security.WebApi\Controllers\RoleController.cs:line 179 2024-04-26 10:48:34.870 +05:30 32cb535c-ae90-4405-81b0-a3f49d43fb07 ERR Incorrect syntax near 'Sch'. Unclosed quotation mark after the character string ' and isnull(istatus,0)=0 order by sName'. 2024-04-26 10:48:34.871 +05:30 32cb535c-ae90-4405-81b0-a3f49d43fb07 ERR Incorrect syntax near 'Sch'. Unclosed quotation mark after the character string ' and isnull(istatus,0)=0 order by sName'. 2024-04-26 10:48:34.872 +05:30 32cb535c-ae90-4405-81b0-a3f49d43fb07 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-26 10:48:34.874 +05:30 32cb535c-ae90-4405-81b0-a3f49d43fb07 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 C:\SOURCECODE\MainFull\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 C:\SOURCECODE\MainFull\Sang.WebApi\Sang.Security.WebApi\CommonService\DbTransactionService.cs:line 31 ClientConnectionId:e9303c7c-5bb2-4a8f-8721-8299d693c560 Error Number:102,State:1,Class:15 --- End of inner exception stack trace --- at Sang.Security.WebApi.CommonService.DbTransactionService.ExecuteTransactionAsync(Func`3 transactionAction) in C:\SOURCECODE\MainFull\Sang.WebApi\Sang.Security.WebApi\CommonService\DbTransactionService.cs:line 45 at Sang.Security.WebApi.Repositories.RoleRepository.GetMasterData(Int32 masterId, String condition, Int32 typeId) in C:\SOURCECODE\MainFull\Sang.WebApi\Sang.Security.WebApi\Repositories\RoleRepository.cs:line 258 at Sang.Security.WebApi.Services.RoleService.GetMasterData(Int32 masterId, String condition, Int32 typeId) in C:\SOURCECODE\MainFull\Sang.WebApi\Sang.Security.WebApi\Services\RoleService.cs:line 44 at Sang.Security.WebApi.Controllers.RoleController.GetMasterData(Int32 masterId, Int32 typeId, String searchCondition) in C:\SOURCECODE\MainFull\Sang.WebApi\Sang.Security.WebApi\Controllers\RoleController.cs:line 179 2024-04-26 10:48:37.256 +05:30 c640c50f-8c86-43e1-b924-4753816ca650 ERR Incorrect syntax near 'Sch'. Unclosed quotation mark after the character string ' and isnull(istatus,0)=0 order by sName'. 2024-04-26 10:48:37.257 +05:30 c640c50f-8c86-43e1-b924-4753816ca650 ERR Incorrect syntax near 'Sch'. Unclosed quotation mark after the character string ' and isnull(istatus,0)=0 order by sName'. 2024-04-26 10:48:37.257 +05:30 c640c50f-8c86-43e1-b924-4753816ca650 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-26 10:48:37.258 +05:30 c640c50f-8c86-43e1-b924-4753816ca650 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 C:\SOURCECODE\MainFull\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 C:\SOURCECODE\MainFull\Sang.WebApi\Sang.Security.WebApi\CommonService\DbTransactionService.cs:line 31 ClientConnectionId:dbd22f7e-7c95-4a69-ab05-b606f821ec1d Error Number:102,State:1,Class:15 --- End of inner exception stack trace --- at Sang.Security.WebApi.CommonService.DbTransactionService.ExecuteTransactionAsync(Func`3 transactionAction) in C:\SOURCECODE\MainFull\Sang.WebApi\Sang.Security.WebApi\CommonService\DbTransactionService.cs:line 45 at Sang.Security.WebApi.Repositories.RoleRepository.GetMasterData(Int32 masterId, String condition, Int32 typeId) in C:\SOURCECODE\MainFull\Sang.WebApi\Sang.Security.WebApi\Repositories\RoleRepository.cs:line 258 at Sang.Security.WebApi.Services.RoleService.GetMasterData(Int32 masterId, String condition, Int32 typeId) in C:\SOURCECODE\MainFull\Sang.WebApi\Sang.Security.WebApi\Services\RoleService.cs:line 44 at Sang.Security.WebApi.Controllers.RoleController.GetMasterData(Int32 masterId, Int32 typeId, String searchCondition) in C:\SOURCECODE\MainFull\Sang.WebApi\Sang.Security.WebApi\Controllers\RoleController.cs:line 179 2024-04-26 10:50:02.082 +05:30 c9b30e1f-23c9-4648-b4f1-a24c2fe957f6 ERR Incorrect syntax near 'Sch'. Unclosed quotation mark after the character string ' and isnull(istatus,0)=0 order by sName'. 2024-04-26 10:50:02.100 +05:30 c9b30e1f-23c9-4648-b4f1-a24c2fe957f6 ERR Incorrect syntax near 'Sch'. Unclosed quotation mark after the character string ' and isnull(istatus,0)=0 order by sName'. 2024-04-26 10:50:02.100 +05:30 c9b30e1f-23c9-4648-b4f1-a24c2fe957f6 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-26 10:50:02.108 +05:30 c9b30e1f-23c9-4648-b4f1-a24c2fe957f6 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 C:\SOURCECODE\MainFull\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 C:\SOURCECODE\MainFull\Sang.WebApi\Sang.Security.WebApi\CommonService\DbTransactionService.cs:line 31 ClientConnectionId:94e71567-76ee-418c-b2d3-df60723e1cbd Error Number:102,State:1,Class:15 --- End of inner exception stack trace --- at Sang.Security.WebApi.CommonService.DbTransactionService.ExecuteTransactionAsync(Func`3 transactionAction) in C:\SOURCECODE\MainFull\Sang.WebApi\Sang.Security.WebApi\CommonService\DbTransactionService.cs:line 45 at Sang.Security.WebApi.Repositories.RoleRepository.GetMasterData(Int32 masterId, String condition, Int32 typeId) in C:\SOURCECODE\MainFull\Sang.WebApi\Sang.Security.WebApi\Repositories\RoleRepository.cs:line 258 at Sang.Security.WebApi.Services.RoleService.GetMasterData(Int32 masterId, String condition, Int32 typeId) in C:\SOURCECODE\MainFull\Sang.WebApi\Sang.Security.WebApi\Services\RoleService.cs:line 44 at Sang.Security.WebApi.Controllers.RoleController.GetMasterData(Int32 masterId, Int32 typeId, String searchCondition) in C:\SOURCECODE\MainFull\Sang.WebApi\Sang.Security.WebApi\Controllers\RoleController.cs:line 179 2024-04-26 10:50:14.105 +05:30 04230785-2f5e-4b90-8da5-66f5d6777c1e ERR Incorrect syntax near 'Sch'. Unclosed quotation mark after the character string ' and isnull(istatus,0)=0 order by sName'. 2024-04-26 10:50:14.106 +05:30 04230785-2f5e-4b90-8da5-66f5d6777c1e ERR Incorrect syntax near 'Sch'. Unclosed quotation mark after the character string ' and isnull(istatus,0)=0 order by sName'. 2024-04-26 10:50:14.106 +05:30 04230785-2f5e-4b90-8da5-66f5d6777c1e 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-26 10:50:14.109 +05:30 04230785-2f5e-4b90-8da5-66f5d6777c1e 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 C:\SOURCECODE\MainFull\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 C:\SOURCECODE\MainFull\Sang.WebApi\Sang.Security.WebApi\CommonService\DbTransactionService.cs:line 31 ClientConnectionId:94e71567-76ee-418c-b2d3-df60723e1cbd Error Number:102,State:1,Class:15 --- End of inner exception stack trace --- at Sang.Security.WebApi.CommonService.DbTransactionService.ExecuteTransactionAsync(Func`3 transactionAction) in C:\SOURCECODE\MainFull\Sang.WebApi\Sang.Security.WebApi\CommonService\DbTransactionService.cs:line 45 at Sang.Security.WebApi.Repositories.RoleRepository.GetMasterData(Int32 masterId, String condition, Int32 typeId) in C:\SOURCECODE\MainFull\Sang.WebApi\Sang.Security.WebApi\Repositories\RoleRepository.cs:line 258 at Sang.Security.WebApi.Services.RoleService.GetMasterData(Int32 masterId, String condition, Int32 typeId) in C:\SOURCECODE\MainFull\Sang.WebApi\Sang.Security.WebApi\Services\RoleService.cs:line 44 at Sang.Security.WebApi.Controllers.RoleController.GetMasterData(Int32 masterId, Int32 typeId, String searchCondition) in C:\SOURCECODE\MainFull\Sang.WebApi\Sang.Security.WebApi\Controllers\RoleController.cs:line 179 2024-04-26 10:52:17.404 +05:30 44a8dc4c-8ec0-4790-ad4d-535d488c6fd2 ERR Incorrect syntax near 'Sch'. Unclosed quotation mark after the character string ' and isnull(istatus,0)=0 order by sName'. 2024-04-26 10:52:17.405 +05:30 44a8dc4c-8ec0-4790-ad4d-535d488c6fd2 ERR Incorrect syntax near 'Sch'. Unclosed quotation mark after the character string ' and isnull(istatus,0)=0 order by sName'. 2024-04-26 10:52:17.406 +05:30 44a8dc4c-8ec0-4790-ad4d-535d488c6fd2 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-26 10:52:17.409 +05:30 44a8dc4c-8ec0-4790-ad4d-535d488c6fd2 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 C:\SOURCECODE\MainFull\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 C:\SOURCECODE\MainFull\Sang.WebApi\Sang.Security.WebApi\CommonService\DbTransactionService.cs:line 31 ClientConnectionId:94e71567-76ee-418c-b2d3-df60723e1cbd Error Number:102,State:1,Class:15 --- End of inner exception stack trace --- at Sang.Security.WebApi.CommonService.DbTransactionService.ExecuteTransactionAsync(Func`3 transactionAction) in C:\SOURCECODE\MainFull\Sang.WebApi\Sang.Security.WebApi\CommonService\DbTransactionService.cs:line 45 at Sang.Security.WebApi.Repositories.RoleRepository.GetMasterData(Int32 masterId, String condition, Int32 typeId) in C:\SOURCECODE\MainFull\Sang.WebApi\Sang.Security.WebApi\Repositories\RoleRepository.cs:line 258 at Sang.Security.WebApi.Services.RoleService.GetMasterData(Int32 masterId, String condition, Int32 typeId) in C:\SOURCECODE\MainFull\Sang.WebApi\Sang.Security.WebApi\Services\RoleService.cs:line 44 at Sang.Security.WebApi.Controllers.RoleController.GetMasterData(Int32 masterId, Int32 typeId, String searchCondition) in C:\SOURCECODE\MainFull\Sang.WebApi\Sang.Security.WebApi\Controllers\RoleController.cs:line 179 2024-04-26 10:52:23.162 +05:30 96d83def-25d3-4f85-a29d-f36f95a9a09a ERR Incorrect syntax near 'Sch'. Unclosed quotation mark after the character string ' and isnull(istatus,0)=0 order by sName'. 2024-04-26 10:52:23.162 +05:30 96d83def-25d3-4f85-a29d-f36f95a9a09a ERR Incorrect syntax near 'Sch'. Unclosed quotation mark after the character string ' and isnull(istatus,0)=0 order by sName'. 2024-04-26 10:52:23.162 +05:30 96d83def-25d3-4f85-a29d-f36f95a9a09a 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-26 10:52:23.165 +05:30 96d83def-25d3-4f85-a29d-f36f95a9a09a 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 C:\SOURCECODE\MainFull\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 C:\SOURCECODE\MainFull\Sang.WebApi\Sang.Security.WebApi\CommonService\DbTransactionService.cs:line 31 ClientConnectionId:94e71567-76ee-418c-b2d3-df60723e1cbd Error Number:102,State:1,Class:15 --- End of inner exception stack trace --- at Sang.Security.WebApi.CommonService.DbTransactionService.ExecuteTransactionAsync(Func`3 transactionAction) in C:\SOURCECODE\MainFull\Sang.WebApi\Sang.Security.WebApi\CommonService\DbTransactionService.cs:line 45 at Sang.Security.WebApi.Repositories.RoleRepository.GetMasterData(Int32 masterId, String condition, Int32 typeId) in C:\SOURCECODE\MainFull\Sang.WebApi\Sang.Security.WebApi\Repositories\RoleRepository.cs:line 258 at Sang.Security.WebApi.Services.RoleService.GetMasterData(Int32 masterId, String condition, Int32 typeId) in C:\SOURCECODE\MainFull\Sang.WebApi\Sang.Security.WebApi\Services\RoleService.cs:line 44 at Sang.Security.WebApi.Controllers.RoleController.GetMasterData(Int32 masterId, Int32 typeId, String searchCondition) in C:\SOURCECODE\MainFull\Sang.WebApi\Sang.Security.WebApi\Controllers\RoleController.cs:line 179 2024-04-26 10:54:27.799 +05:30 54cddddb-b22b-4962-becd-1044113b2b0a ERR Incorrect syntax near 'Sch'. Unclosed quotation mark after the character string ' and isnull(istatus,0)=0 order by sName'. 2024-04-26 10:54:27.803 +05:30 54cddddb-b22b-4962-becd-1044113b2b0a ERR Incorrect syntax near 'Sch'. Unclosed quotation mark after the character string ' and isnull(istatus,0)=0 order by sName'. 2024-04-26 10:54:27.803 +05:30 54cddddb-b22b-4962-becd-1044113b2b0a 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-26 10:54:27.807 +05:30 54cddddb-b22b-4962-becd-1044113b2b0a 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 C:\SOURCECODE\MainFull\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 C:\SOURCECODE\MainFull\Sang.WebApi\Sang.Security.WebApi\CommonService\DbTransactionService.cs:line 31 ClientConnectionId:94e71567-76ee-418c-b2d3-df60723e1cbd Error Number:102,State:1,Class:15 --- End of inner exception stack trace --- at Sang.Security.WebApi.CommonService.DbTransactionService.ExecuteTransactionAsync(Func`3 transactionAction) in C:\SOURCECODE\MainFull\Sang.WebApi\Sang.Security.WebApi\CommonService\DbTransactionService.cs:line 45 at Sang.Security.WebApi.Repositories.RoleRepository.GetMasterData(Int32 masterId, String condition, Int32 typeId) in C:\SOURCECODE\MainFull\Sang.WebApi\Sang.Security.WebApi\Repositories\RoleRepository.cs:line 258 at Sang.Security.WebApi.Services.RoleService.GetMasterData(Int32 masterId, String condition, Int32 typeId) in C:\SOURCECODE\MainFull\Sang.WebApi\Sang.Security.WebApi\Services\RoleService.cs:line 44 at Sang.Security.WebApi.Controllers.RoleController.GetMasterData(Int32 masterId, Int32 typeId, String searchCondition) in C:\SOURCECODE\MainFull\Sang.WebApi\Sang.Security.WebApi\Controllers\RoleController.cs:line 179 2024-04-26 10:54:31.368 +05:30 08885ec4-0277-4c9c-a3e9-97187ffe2c8d ERR Incorrect syntax near 'Sch'. Unclosed quotation mark after the character string ' and isnull(istatus,0)=0 order by sName'. 2024-04-26 10:54:31.369 +05:30 08885ec4-0277-4c9c-a3e9-97187ffe2c8d ERR Incorrect syntax near 'Sch'. Unclosed quotation mark after the character string ' and isnull(istatus,0)=0 order by sName'. 2024-04-26 10:54:31.369 +05:30 08885ec4-0277-4c9c-a3e9-97187ffe2c8d 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-26 10:54:31.371 +05:30 08885ec4-0277-4c9c-a3e9-97187ffe2c8d 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 C:\SOURCECODE\MainFull\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 C:\SOURCECODE\MainFull\Sang.WebApi\Sang.Security.WebApi\CommonService\DbTransactionService.cs:line 31 ClientConnectionId:94e71567-76ee-418c-b2d3-df60723e1cbd Error Number:102,State:1,Class:15 --- End of inner exception stack trace --- at Sang.Security.WebApi.CommonService.DbTransactionService.ExecuteTransactionAsync(Func`3 transactionAction) in C:\SOURCECODE\MainFull\Sang.WebApi\Sang.Security.WebApi\CommonService\DbTransactionService.cs:line 45 at Sang.Security.WebApi.Repositories.RoleRepository.GetMasterData(Int32 masterId, String condition, Int32 typeId) in C:\SOURCECODE\MainFull\Sang.WebApi\Sang.Security.WebApi\Repositories\RoleRepository.cs:line 258 at Sang.Security.WebApi.Services.RoleService.GetMasterData(Int32 masterId, String condition, Int32 typeId) in C:\SOURCECODE\MainFull\Sang.WebApi\Sang.Security.WebApi\Services\RoleService.cs:line 44 at Sang.Security.WebApi.Controllers.RoleController.GetMasterData(Int32 masterId, Int32 typeId, String searchCondition) in C:\SOURCECODE\MainFull\Sang.WebApi\Sang.Security.WebApi\Controllers\RoleController.cs:line 179 2024-04-26 11:04:24.703 +05:30 1e00f56c-3abf-4d28-a44e-6047780cedfd ERR Incorrect syntax near 'Sch'. Unclosed quotation mark after the character string ' and isnull(istatus,0)=0 order by sName'. 2024-04-26 11:04:24.704 +05:30 1e00f56c-3abf-4d28-a44e-6047780cedfd ERR Incorrect syntax near 'Sch'. Unclosed quotation mark after the character string ' and isnull(istatus,0)=0 order by sName'. 2024-04-26 11:04:24.704 +05:30 1e00f56c-3abf-4d28-a44e-6047780cedfd 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-26 11:04:24.710 +05:30 1e00f56c-3abf-4d28-a44e-6047780cedfd 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 C:\SOURCECODE\MainFull\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 C:\SOURCECODE\MainFull\Sang.WebApi\Sang.Security.WebApi\CommonService\DbTransactionService.cs:line 31 ClientConnectionId:bedd87a5-96ce-421b-a9af-fdfc1a61fd4f Error Number:102,State:1,Class:15 --- End of inner exception stack trace --- at Sang.Security.WebApi.CommonService.DbTransactionService.ExecuteTransactionAsync(Func`3 transactionAction) in C:\SOURCECODE\MainFull\Sang.WebApi\Sang.Security.WebApi\CommonService\DbTransactionService.cs:line 45 at Sang.Security.WebApi.Repositories.RoleRepository.GetMasterData(Int32 masterId, String condition, Int32 typeId) in C:\SOURCECODE\MainFull\Sang.WebApi\Sang.Security.WebApi\Repositories\RoleRepository.cs:line 258 at Sang.Security.WebApi.Services.RoleService.GetMasterData(Int32 masterId, String condition, Int32 typeId) in C:\SOURCECODE\MainFull\Sang.WebApi\Sang.Security.WebApi\Services\RoleService.cs:line 44 at Sang.Security.WebApi.Controllers.RoleController.GetMasterData(Int32 masterId, Int32 typeId, String searchCondition) in C:\SOURCECODE\MainFull\Sang.WebApi\Sang.Security.WebApi\Controllers\RoleController.cs:line 179 2024-04-26 11:04:35.794 +05:30 81a1ab18-caec-451c-a54a-99ed9da014d7 ERR Incorrect syntax near 'Sch'. Unclosed quotation mark after the character string ' and isnull(istatus,0)=0 order by sName'. 2024-04-26 11:04:35.796 +05:30 81a1ab18-caec-451c-a54a-99ed9da014d7 ERR Incorrect syntax near 'Sch'. Unclosed quotation mark after the character string ' and isnull(istatus,0)=0 order by sName'. 2024-04-26 11:04:35.796 +05:30 81a1ab18-caec-451c-a54a-99ed9da014d7 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-26 11:04:35.798 +05:30 81a1ab18-caec-451c-a54a-99ed9da014d7 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 C:\SOURCECODE\MainFull\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 C:\SOURCECODE\MainFull\Sang.WebApi\Sang.Security.WebApi\CommonService\DbTransactionService.cs:line 31 ClientConnectionId:4de00e15-cdff-42a9-b177-d01613a2ba33 Error Number:102,State:1,Class:15 --- End of inner exception stack trace --- at Sang.Security.WebApi.CommonService.DbTransactionService.ExecuteTransactionAsync(Func`3 transactionAction) in C:\SOURCECODE\MainFull\Sang.WebApi\Sang.Security.WebApi\CommonService\DbTransactionService.cs:line 45 at Sang.Security.WebApi.Repositories.RoleRepository.GetMasterData(Int32 masterId, String condition, Int32 typeId) in C:\SOURCECODE\MainFull\Sang.WebApi\Sang.Security.WebApi\Repositories\RoleRepository.cs:line 258 at Sang.Security.WebApi.Services.RoleService.GetMasterData(Int32 masterId, String condition, Int32 typeId) in C:\SOURCECODE\MainFull\Sang.WebApi\Sang.Security.WebApi\Services\RoleService.cs:line 44 at Sang.Security.WebApi.Controllers.RoleController.GetMasterData(Int32 masterId, Int32 typeId, String searchCondition) in C:\SOURCECODE\MainFull\Sang.WebApi\Sang.Security.WebApi\Controllers\RoleController.cs:line 179 2024-04-26 11:05:06.748 +05:30 b0015b28-1566-4193-83b5-c1942129fa59 ERR Incorrect syntax near 'Sch'. Unclosed quotation mark after the character string ' and isnull(istatus,0)=0 order by sName'. 2024-04-26 11:05:06.749 +05:30 b0015b28-1566-4193-83b5-c1942129fa59 ERR Incorrect syntax near 'Sch'. Unclosed quotation mark after the character string ' and isnull(istatus,0)=0 order by sName'. 2024-04-26 11:05:06.750 +05:30 b0015b28-1566-4193-83b5-c1942129fa59 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-26 11:05:06.753 +05:30 b0015b28-1566-4193-83b5-c1942129fa59 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 C:\SOURCECODE\MainFull\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 C:\SOURCECODE\MainFull\Sang.WebApi\Sang.Security.WebApi\CommonService\DbTransactionService.cs:line 31 ClientConnectionId:4de00e15-cdff-42a9-b177-d01613a2ba33 Error Number:102,State:1,Class:15 --- End of inner exception stack trace --- at Sang.Security.WebApi.CommonService.DbTransactionService.ExecuteTransactionAsync(Func`3 transactionAction) in C:\SOURCECODE\MainFull\Sang.WebApi\Sang.Security.WebApi\CommonService\DbTransactionService.cs:line 45 at Sang.Security.WebApi.Repositories.RoleRepository.GetMasterData(Int32 masterId, String condition, Int32 typeId) in C:\SOURCECODE\MainFull\Sang.WebApi\Sang.Security.WebApi\Repositories\RoleRepository.cs:line 258 at Sang.Security.WebApi.Services.RoleService.GetMasterData(Int32 masterId, String condition, Int32 typeId) in C:\SOURCECODE\MainFull\Sang.WebApi\Sang.Security.WebApi\Services\RoleService.cs:line 44 at Sang.Security.WebApi.Controllers.RoleController.GetMasterData(Int32 masterId, Int32 typeId, String searchCondition) in C:\SOURCECODE\MainFull\Sang.WebApi\Sang.Security.WebApi\Controllers\RoleController.cs:line 179 2024-04-26 11:05:15.162 +05:30 3bc7d80c-eb07-47cd-b634-8aaf1ff8f4be ERR Incorrect syntax near 'Sch'. Unclosed quotation mark after the character string ' and isnull(istatus,0)=0 order by sName'. 2024-04-26 11:05:15.163 +05:30 3bc7d80c-eb07-47cd-b634-8aaf1ff8f4be ERR Incorrect syntax near 'Sch'. Unclosed quotation mark after the character string ' and isnull(istatus,0)=0 order by sName'. 2024-04-26 11:05:15.164 +05:30 3bc7d80c-eb07-47cd-b634-8aaf1ff8f4be 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-26 11:05:15.165 +05:30 3bc7d80c-eb07-47cd-b634-8aaf1ff8f4be 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 C:\SOURCECODE\MainFull\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 C:\SOURCECODE\MainFull\Sang.WebApi\Sang.Security.WebApi\CommonService\DbTransactionService.cs:line 31 ClientConnectionId:bedd87a5-96ce-421b-a9af-fdfc1a61fd4f Error Number:102,State:1,Class:15 --- End of inner exception stack trace --- at Sang.Security.WebApi.CommonService.DbTransactionService.ExecuteTransactionAsync(Func`3 transactionAction) in C:\SOURCECODE\MainFull\Sang.WebApi\Sang.Security.WebApi\CommonService\DbTransactionService.cs:line 45 at Sang.Security.WebApi.Repositories.RoleRepository.GetMasterData(Int32 masterId, String condition, Int32 typeId) in C:\SOURCECODE\MainFull\Sang.WebApi\Sang.Security.WebApi\Repositories\RoleRepository.cs:line 258 at Sang.Security.WebApi.Services.RoleService.GetMasterData(Int32 masterId, String condition, Int32 typeId) in C:\SOURCECODE\MainFull\Sang.WebApi\Sang.Security.WebApi\Services\RoleService.cs:line 44 at Sang.Security.WebApi.Controllers.RoleController.GetMasterData(Int32 masterId, Int32 typeId, String searchCondition) in C:\SOURCECODE\MainFull\Sang.WebApi\Sang.Security.WebApi\Controllers\RoleController.cs:line 179 2024-04-26 11:18:34.781 +05:30 0301b67b-cb50-46a2-8a77-787251b0b039 ERR Incorrect syntax near 'Sch'. Unclosed quotation mark after the character string ' and isnull(istatus,0)=0 order by sName'. 2024-04-26 11:18:34.782 +05:30 0301b67b-cb50-46a2-8a77-787251b0b039 ERR Incorrect syntax near 'Sch'. Unclosed quotation mark after the character string ' and isnull(istatus,0)=0 order by sName'. 2024-04-26 11:18:34.783 +05:30 0301b67b-cb50-46a2-8a77-787251b0b039 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-26 11:18:34.786 +05:30 0301b67b-cb50-46a2-8a77-787251b0b039 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 C:\SOURCECODE\MainFull\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 C:\SOURCECODE\MainFull\Sang.WebApi\Sang.Security.WebApi\CommonService\DbTransactionService.cs:line 31 ClientConnectionId:bedd87a5-96ce-421b-a9af-fdfc1a61fd4f Error Number:102,State:1,Class:15 --- End of inner exception stack trace --- at Sang.Security.WebApi.CommonService.DbTransactionService.ExecuteTransactionAsync(Func`3 transactionAction) in C:\SOURCECODE\MainFull\Sang.WebApi\Sang.Security.WebApi\CommonService\DbTransactionService.cs:line 45 at Sang.Security.WebApi.Repositories.RoleRepository.GetMasterData(Int32 masterId, String condition, Int32 typeId) in C:\SOURCECODE\MainFull\Sang.WebApi\Sang.Security.WebApi\Repositories\RoleRepository.cs:line 258 at Sang.Security.WebApi.Services.RoleService.GetMasterData(Int32 masterId, String condition, Int32 typeId) in C:\SOURCECODE\MainFull\Sang.WebApi\Sang.Security.WebApi\Services\RoleService.cs:line 44 at Sang.Security.WebApi.Controllers.RoleController.GetMasterData(Int32 masterId, Int32 typeId, String searchCondition) in C:\SOURCECODE\MainFull\Sang.WebApi\Sang.Security.WebApi\Controllers\RoleController.cs:line 179 2024-04-26 11:18:42.581 +05:30 f59129b5-881f-4755-a273-ca2a95094d9e ERR Incorrect syntax near 'Sch'. Unclosed quotation mark after the character string ' and isnull(istatus,0)=0 order by sName'. 2024-04-26 11:18:42.582 +05:30 f59129b5-881f-4755-a273-ca2a95094d9e ERR Incorrect syntax near 'Sch'. Unclosed quotation mark after the character string ' and isnull(istatus,0)=0 order by sName'. 2024-04-26 11:18:42.582 +05:30 f59129b5-881f-4755-a273-ca2a95094d9e 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-26 11:18:42.583 +05:30 f59129b5-881f-4755-a273-ca2a95094d9e 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 C:\SOURCECODE\MainFull\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 C:\SOURCECODE\MainFull\Sang.WebApi\Sang.Security.WebApi\CommonService\DbTransactionService.cs:line 31 ClientConnectionId:bedd87a5-96ce-421b-a9af-fdfc1a61fd4f Error Number:102,State:1,Class:15 --- End of inner exception stack trace --- at Sang.Security.WebApi.CommonService.DbTransactionService.ExecuteTransactionAsync(Func`3 transactionAction) in C:\SOURCECODE\MainFull\Sang.WebApi\Sang.Security.WebApi\CommonService\DbTransactionService.cs:line 45 at Sang.Security.WebApi.Repositories.RoleRepository.GetMasterData(Int32 masterId, String condition, Int32 typeId) in C:\SOURCECODE\MainFull\Sang.WebApi\Sang.Security.WebApi\Repositories\RoleRepository.cs:line 258 at Sang.Security.WebApi.Services.RoleService.GetMasterData(Int32 masterId, String condition, Int32 typeId) in C:\SOURCECODE\MainFull\Sang.WebApi\Sang.Security.WebApi\Services\RoleService.cs:line 44 at Sang.Security.WebApi.Controllers.RoleController.GetMasterData(Int32 masterId, Int32 typeId, String searchCondition) in C:\SOURCECODE\MainFull\Sang.WebApi\Sang.Security.WebApi\Controllers\RoleController.cs:line 179 2024-04-26 11:20:14.275 +05:30 542e7cb1-2ac3-4020-96c4-e5b6e6a581ee ERR Token Regeneration failed Microsoft.IdentityModel.Tokens.SecurityTokenExpiredException: Refresh token has expired at Sang.Security.WebApi.Validators.TokenValidator.ValidateToken(String token, String TokenKey) in C:\SOURCECODE\MainFull\Sang.WebApi\Sang.Security.WebApi\Validators\TokenValidator.cs:line 38 at Sang.Security.WebApi.Authentication.TokenService.RefreshToken(String refershToken) at Sang.Security.WebApi.Controllers.SecurityController.RegenerateTokens(String refershToken) in C:\SOURCECODE\MainFull\Sang.WebApi\Sang.Security.WebApi\Controllers\SecurityController.cs:line 39 2024-04-26 12:11:41.682 +05:30 89daea33-ac62-4be3-91cc-9b51f6615e1f ERR Token Regeneration failed Microsoft.IdentityModel.Tokens.SecurityTokenExpiredException: Refresh token has expired at Sang.Security.WebApi.Validators.TokenValidator.ValidateToken(String token, String TokenKey) in C:\SOURCECODE\MainFull\Sang.WebApi\Sang.Security.WebApi\Validators\TokenValidator.cs:line 38 at Sang.Security.WebApi.Authentication.TokenService.RefreshToken(String refershToken) at Sang.Security.WebApi.Controllers.SecurityController.RegenerateTokens(String refershToken) in C:\SOURCECODE\MainFull\Sang.WebApi\Sang.Security.WebApi\Controllers\SecurityController.cs:line 39 2024-04-26 12:11:41.847 +05:30 deb6488a-c50f-4481-a51b-49875b66cc97 ERR Token Regeneration failed Microsoft.IdentityModel.Tokens.SecurityTokenExpiredException: Refresh token has expired at Sang.Security.WebApi.Validators.TokenValidator.ValidateToken(String token, String TokenKey) in C:\SOURCECODE\MainFull\Sang.WebApi\Sang.Security.WebApi\Validators\TokenValidator.cs:line 38 at Sang.Security.WebApi.Authentication.TokenService.RefreshToken(String refershToken) at Sang.Security.WebApi.Controllers.SecurityController.RegenerateTokens(String refershToken) in C:\SOURCECODE\MainFull\Sang.WebApi\Sang.Security.WebApi\Controllers\SecurityController.cs:line 39 2024-04-26 12:11:42.082 +05:30 4aba9ad6-1c49-4a33-8755-87ca1a270c67 ERR Token Regeneration failed Microsoft.IdentityModel.Tokens.SecurityTokenExpiredException: Refresh token has expired at Sang.Security.WebApi.Validators.TokenValidator.ValidateToken(String token, String TokenKey) in C:\SOURCECODE\MainFull\Sang.WebApi\Sang.Security.WebApi\Validators\TokenValidator.cs:line 38 at Sang.Security.WebApi.Authentication.TokenService.RefreshToken(String refershToken) at Sang.Security.WebApi.Controllers.SecurityController.RegenerateTokens(String refershToken) in C:\SOURCECODE\MainFull\Sang.WebApi\Sang.Security.WebApi\Controllers\SecurityController.cs:line 39 2024-04-26 12:35:20.449 +05:30 67ff5a53-109e-4e95-b00b-beb289d8abf3 ERR Incorrect syntax near 'Sch'. Unclosed quotation mark after the character string ' and isnull(istatus,0)=0 order by sName'. 2024-04-26 12:35:20.510 +05:30 67ff5a53-109e-4e95-b00b-beb289d8abf3 ERR Incorrect syntax near 'Sch'. Unclosed quotation mark after the character string ' and isnull(istatus,0)=0 order by sName'. 2024-04-26 12:35:20.511 +05:30 67ff5a53-109e-4e95-b00b-beb289d8abf3 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-26 12:35:20.535 +05:30 67ff5a53-109e-4e95-b00b-beb289d8abf3 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:2b3c056e-a855-4ba4-9c16-fe83142c93b7 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-26 12:35:28.757 +05:30 388f9cbb-d974-48fd-aa30-8e2f099fe20f ERR Incorrect syntax near 'Sch'. Unclosed quotation mark after the character string ' and isnull(istatus,0)=0 order by sName'. 2024-04-26 12:35:28.758 +05:30 388f9cbb-d974-48fd-aa30-8e2f099fe20f ERR Incorrect syntax near 'Sch'. Unclosed quotation mark after the character string ' and isnull(istatus,0)=0 order by sName'. 2024-04-26 12:35:28.759 +05:30 388f9cbb-d974-48fd-aa30-8e2f099fe20f 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-26 12:35:28.761 +05:30 388f9cbb-d974-48fd-aa30-8e2f099fe20f 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:2b3c056e-a855-4ba4-9c16-fe83142c93b7 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-26 12:39:34.203 +05:30 b21b12a1-12d4-48ca-ad06-a5aff2393ed8 ERR Incorrect syntax near 'Sch'. Unclosed quotation mark after the character string ' and isnull(istatus,0)=0 order by sName'. 2024-04-26 12:39:34.205 +05:30 b21b12a1-12d4-48ca-ad06-a5aff2393ed8 ERR Incorrect syntax near 'Sch'. Unclosed quotation mark after the character string ' and isnull(istatus,0)=0 order by sName'. 2024-04-26 12:39:34.206 +05:30 b21b12a1-12d4-48ca-ad06-a5aff2393ed8 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-26 12:39:34.209 +05:30 b21b12a1-12d4-48ca-ad06-a5aff2393ed8 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:c13b149c-5fcd-4f6e-9e7c-0f074c87b7ea 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-26 12:45:13.632 +05:30 093c1fcf-bc7f-433b-92d3-092bfde7bbab 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) at Sang.Security.WebApi.Controllers.SecurityController.RegenerateTokens(String refershToken) in D:\SOURCECODE\Sang.WebApi\Sang.Security.WebApi\Controllers\SecurityController.cs:line 39 2024-04-26 12:46:38.552 +05:30 b50f8c21-d328-4623-96e4-1c01a9eee2da ERR Incorrect syntax near 'Sch'. Unclosed quotation mark after the character string ' and isnull(istatus,0)=0 order by sName'. 2024-04-26 12:46:38.557 +05:30 b50f8c21-d328-4623-96e4-1c01a9eee2da ERR Incorrect syntax near 'Sch'. Unclosed quotation mark after the character string ' and isnull(istatus,0)=0 order by sName'. 2024-04-26 12:46:38.557 +05:30 b50f8c21-d328-4623-96e4-1c01a9eee2da 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-26 12:46:38.561 +05:30 b50f8c21-d328-4623-96e4-1c01a9eee2da 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:c13b149c-5fcd-4f6e-9e7c-0f074c87b7ea 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-26 12:53:48.814 +05:30 58f27538-d61b-45aa-a969-0314a7e9778b ERR Incorrect syntax near 'Sch'. Unclosed quotation mark after the character string ' and isnull(istatus,0)=0 order by sName'. 2024-04-26 12:53:48.817 +05:30 58f27538-d61b-45aa-a969-0314a7e9778b ERR Incorrect syntax near 'Sch'. Unclosed quotation mark after the character string ' and isnull(istatus,0)=0 order by sName'. 2024-04-26 12:53:48.818 +05:30 58f27538-d61b-45aa-a969-0314a7e9778b 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-26 12:53:48.822 +05:30 58f27538-d61b-45aa-a969-0314a7e9778b 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:dfb7510b-6e54-4fab-8a74-6cdd893f0892 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-26 12:54:02.596 +05:30 c020d222-813c-4262-ba0e-f633f990a7e8 ERR Incorrect syntax near 'Sch'. Unclosed quotation mark after the character string ' and isnull(istatus,0)=0 order by sName'. 2024-04-26 12:54:02.600 +05:30 c020d222-813c-4262-ba0e-f633f990a7e8 ERR Incorrect syntax near 'Sch'. Unclosed quotation mark after the character string ' and isnull(istatus,0)=0 order by sName'. 2024-04-26 12:54:02.603 +05:30 c020d222-813c-4262-ba0e-f633f990a7e8 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-26 12:54:02.614 +05:30 c020d222-813c-4262-ba0e-f633f990a7e8 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:24d0d43f-c2fb-4143-ae87-7ee52cd95ea0 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-26 12:54:12.181 +05:30 56ee3be5-5d23-4316-bab9-20f6aec5f629 ERR Incorrect syntax near 'Sch'. Unclosed quotation mark after the character string ' and isnull(istatus,0)=0 order by sName'. 2024-04-26 12:54:12.182 +05:30 56ee3be5-5d23-4316-bab9-20f6aec5f629 ERR Incorrect syntax near 'Sch'. Unclosed quotation mark after the character string ' and isnull(istatus,0)=0 order by sName'. 2024-04-26 12:54:12.183 +05:30 56ee3be5-5d23-4316-bab9-20f6aec5f629 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-26 12:54:12.184 +05:30 56ee3be5-5d23-4316-bab9-20f6aec5f629 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:24d0d43f-c2fb-4143-ae87-7ee52cd95ea0 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-26 12:58:17.226 +05:30 431c214f-4489-4094-9205-2d713e72ddc8 ERR Incorrect syntax near 'Sch'. Unclosed quotation mark after the character string ' and isnull(istatus,0)=0 order by sName'. 2024-04-26 12:58:17.233 +05:30 431c214f-4489-4094-9205-2d713e72ddc8 ERR Incorrect syntax near 'Sch'. Unclosed quotation mark after the character string ' and isnull(istatus,0)=0 order by sName'. 2024-04-26 12:58:17.233 +05:30 431c214f-4489-4094-9205-2d713e72ddc8 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-26 12:58:17.252 +05:30 431c214f-4489-4094-9205-2d713e72ddc8 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:24d0d43f-c2fb-4143-ae87-7ee52cd95ea0 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-26 13:01:20.200 +05:30 dadd1aca-c189-4d80-ad4f-9dc10d2ecee2 ERR Incorrect syntax near 'Sch'. Unclosed quotation mark after the character string ' and isnull(istatus,0)=0 order by sName'. 2024-04-26 13:01:20.204 +05:30 dadd1aca-c189-4d80-ad4f-9dc10d2ecee2 ERR Incorrect syntax near 'Sch'. Unclosed quotation mark after the character string ' and isnull(istatus,0)=0 order by sName'. 2024-04-26 13:01:20.204 +05:30 dadd1aca-c189-4d80-ad4f-9dc10d2ecee2 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-26 13:01:20.210 +05:30 dadd1aca-c189-4d80-ad4f-9dc10d2ecee2 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:24d0d43f-c2fb-4143-ae87-7ee52cd95ea0 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-26 13:01:54.943 +05:30 9be31c1e-c810-4522-8190-4f68d1e59e49 ERR Incorrect syntax near 'Sch'. Unclosed quotation mark after the character string ' and isnull(istatus,0)=0 order by sName'. 2024-04-26 13:01:54.944 +05:30 9be31c1e-c810-4522-8190-4f68d1e59e49 ERR Incorrect syntax near 'Sch'. Unclosed quotation mark after the character string ' and isnull(istatus,0)=0 order by sName'. 2024-04-26 13:01:54.944 +05:30 9be31c1e-c810-4522-8190-4f68d1e59e49 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-26 13:01:54.946 +05:30 9be31c1e-c810-4522-8190-4f68d1e59e49 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:24d0d43f-c2fb-4143-ae87-7ee52cd95ea0 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-26 13:02:02.400 +05:30 b7258021-d534-4984-85a2-9dfb8de8dcc2 ERR Incorrect syntax near 'Sch'. Unclosed quotation mark after the character string ' and isnull(istatus,0)=0 order by sName'. 2024-04-26 13:02:02.404 +05:30 b7258021-d534-4984-85a2-9dfb8de8dcc2 ERR Incorrect syntax near 'Sch'. Unclosed quotation mark after the character string ' and isnull(istatus,0)=0 order by sName'. 2024-04-26 13:02:02.405 +05:30 b7258021-d534-4984-85a2-9dfb8de8dcc2 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-26 13:02:02.407 +05:30 b7258021-d534-4984-85a2-9dfb8de8dcc2 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:24d0d43f-c2fb-4143-ae87-7ee52cd95ea0 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-26 13:02:07.879 +05:30 afc23874-b6f8-47c0-9210-fbe82470d94b ERR Incorrect syntax near 'Sch'. Unclosed quotation mark after the character string ' and isnull(istatus,0)=0 order by sName'. 2024-04-26 13:02:07.880 +05:30 afc23874-b6f8-47c0-9210-fbe82470d94b ERR Incorrect syntax near 'Sch'. Unclosed quotation mark after the character string ' and isnull(istatus,0)=0 order by sName'. 2024-04-26 13:02:07.881 +05:30 afc23874-b6f8-47c0-9210-fbe82470d94b 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-26 13:02:07.882 +05:30 afc23874-b6f8-47c0-9210-fbe82470d94b 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:24d0d43f-c2fb-4143-ae87-7ee52cd95ea0 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-26 13:02:18.469 +05:30 007e03ab-7a57-483c-ac77-0b961fe23069 ERR Incorrect syntax near 'Sch'. Unclosed quotation mark after the character string ' and isnull(istatus,0)=0 order by sName'. 2024-04-26 13:02:18.470 +05:30 007e03ab-7a57-483c-ac77-0b961fe23069 ERR Incorrect syntax near 'Sch'. Unclosed quotation mark after the character string ' and isnull(istatus,0)=0 order by sName'. 2024-04-26 13:02:18.470 +05:30 007e03ab-7a57-483c-ac77-0b961fe23069 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-26 13:02:18.472 +05:30 007e03ab-7a57-483c-ac77-0b961fe23069 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:24d0d43f-c2fb-4143-ae87-7ee52cd95ea0 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-26 13:02:24.575 +05:30 a10c73a6-d405-42d4-b39c-fe4bc436ee1a ERR Incorrect syntax near 'Sch'. Unclosed quotation mark after the character string ' and isnull(istatus,0)=0 order by sName'. 2024-04-26 13:02:24.576 +05:30 a10c73a6-d405-42d4-b39c-fe4bc436ee1a ERR Incorrect syntax near 'Sch'. Unclosed quotation mark after the character string ' and isnull(istatus,0)=0 order by sName'. 2024-04-26 13:02:24.577 +05:30 a10c73a6-d405-42d4-b39c-fe4bc436ee1a 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-26 13:02:24.578 +05:30 a10c73a6-d405-42d4-b39c-fe4bc436ee1a 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:24d0d43f-c2fb-4143-ae87-7ee52cd95ea0 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-26 13:02:30.040 +05:30 d4deb23c-4c04-43f1-b4b1-ce1a65f8503e ERR Incorrect syntax near 'Sch'. Unclosed quotation mark after the character string ' and isnull(istatus,0)=0 order by sName'. 2024-04-26 13:02:30.041 +05:30 d4deb23c-4c04-43f1-b4b1-ce1a65f8503e ERR Incorrect syntax near 'Sch'. Unclosed quotation mark after the character string ' and isnull(istatus,0)=0 order by sName'. 2024-04-26 13:02:30.042 +05:30 d4deb23c-4c04-43f1-b4b1-ce1a65f8503e 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-26 13:02:30.044 +05:30 d4deb23c-4c04-43f1-b4b1-ce1a65f8503e 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:dfb7510b-6e54-4fab-8a74-6cdd893f0892 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-26 13:02:35.694 +05:30 70013748-d62a-41a4-9ab0-c166f4bb3fcf ERR Incorrect syntax near 'Sch'. Unclosed quotation mark after the character string ' and isnull(istatus,0)=0 order by sName'. 2024-04-26 13:02:35.699 +05:30 70013748-d62a-41a4-9ab0-c166f4bb3fcf ERR Incorrect syntax near 'Sch'. Unclosed quotation mark after the character string ' and isnull(istatus,0)=0 order by sName'. 2024-04-26 13:02:35.700 +05:30 70013748-d62a-41a4-9ab0-c166f4bb3fcf 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-26 13:02:35.701 +05:30 70013748-d62a-41a4-9ab0-c166f4bb3fcf 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:6079ee11-3a93-4e8a-9bb3-a421b46e249c 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-26 13:02:45.637 +05:30 0c253700-7d4b-4b8f-857a-04d58c68d1de ERR Incorrect syntax near 'Sch'. Unclosed quotation mark after the character string ' and isnull(istatus,0)=0 order by sName'. 2024-04-26 13:02:45.638 +05:30 0c253700-7d4b-4b8f-857a-04d58c68d1de ERR Incorrect syntax near 'Sch'. Unclosed quotation mark after the character string ' and isnull(istatus,0)=0 order by sName'. 2024-04-26 13:02:45.638 +05:30 0c253700-7d4b-4b8f-857a-04d58c68d1de 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-26 13:02:45.642 +05:30 0c253700-7d4b-4b8f-857a-04d58c68d1de 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:24d0d43f-c2fb-4143-ae87-7ee52cd95ea0 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-26 13:19:07.278 +05:30 986bbc23-1a4f-448f-8b91-11e1fa93e667 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-26 13:19:07.599 +05:30 a2986ce9-93c4-4b5d-92b1-067622521551 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-26 13:19:33.778 +05:30 f6977e4e-8910-4773-9d01-b61d33b276a2 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-26 13:50:34.910 +05:30 cf959877-a80f-483f-9581-b85e8ab0f22c 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-26 13:50:35.058 +05:30 d484043b-7011-4a07-9160-0fe7b71b73c8 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-26 13:50:35.193 +05:30 d807681b-bf2e-449a-94f3-d30391130dde 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-26 14:03:02.964 +05:30 07dc0dbe-77dc-4142-82d5-f2ecfd0c6115 ERR Incorrect syntax near 'Sch'. Unclosed quotation mark after the character string ' and isnull(istatus,0)=0 order by sName'. 2024-04-26 14:03:02.967 +05:30 07dc0dbe-77dc-4142-82d5-f2ecfd0c6115 ERR Incorrect syntax near 'Sch'. Unclosed quotation mark after the character string ' and isnull(istatus,0)=0 order by sName'. 2024-04-26 14:03:02.968 +05:30 07dc0dbe-77dc-4142-82d5-f2ecfd0c6115 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-26 14:03:02.980 +05:30 07dc0dbe-77dc-4142-82d5-f2ecfd0c6115 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:e4882ebf-8d86-4680-aed7-e2c04f1411ed 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-26 14:33:12.599 +05:30 b584c415-b81a-4a03-952d-3e9d04c8dc6e 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-26 14:33:12.844 +05:30 36d4b5da-8ef2-42ad-95df-6f4c311b4c69 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-26 14:33:12.993 +05:30 1709eff4-6ef5-488d-a55d-428de677ab45 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-26 14:33:13.192 +05:30 2db86933-d2a6-464c-a8ef-08a7ce57c990 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-26 15:31:27.396 +05:30 b3e01599-3361-4646-9309-2a3baca8eb47 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-26 15:31:27.645 +05:30 29d6f2b8-83ad-47f8-aadd-29563bf8532d 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-26 15:31:27.844 +05:30 1c335d85-fb7e-487a-befd-c2029f4be68c 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-26 15:31:28.037 +05:30 166ff637-3c5e-4154-9b6b-416a50c1d0c8 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-26 15:43:32.996 +05:30 e3736421-c3a1-48a2-b39e-22d535e12102 ERR Incorrect syntax near 'Sch'. Unclosed quotation mark after the character string ' and isnull(istatus,0)=0 order by sName'. 2024-04-26 15:43:32.999 +05:30 e3736421-c3a1-48a2-b39e-22d535e12102 ERR Incorrect syntax near 'Sch'. Unclosed quotation mark after the character string ' and isnull(istatus,0)=0 order by sName'. 2024-04-26 15:43:33.000 +05:30 e3736421-c3a1-48a2-b39e-22d535e12102 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-26 15:43:33.013 +05:30 e3736421-c3a1-48a2-b39e-22d535e12102 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:41d6692c-d696-44e9-ae17-f0221476fc13 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-26 17:44:09.437 +05:30 dbdedb8e-a6e3-409c-ae6c-1ae0ed2b2ac1 ERR Invalid database name. 2024-04-26 19:38:26.306 +05:30 aee97504-6b9f-40d5-85a3-e28deae6e082 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-26 20:14:11.737 +05:30 003e085b-b77f-4889-b5b5-7c33956c34e7 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-26 20:52:26.904 +05:30 70795b41-55ab-456f-ae97-38e3275018e6 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-26 21:14:12.478 +05:30 2e090dcf-f709-4d7d-bcd6-a0f2eb45e85c 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-26 21:14:12.697 +05:30 ee81cd8c-0b82-4a59-89e0-ba492ab71902 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-26 21:18:24.314 +05:30 121a7589-1ce7-4fe9-9977-415bab801629 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-26 21:18:24.457 +05:30 ef528de5-de46-4060-b7f1-a182b524e6b7 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-26 21:18:24.599 +05:30 bff1898e-c9f5-465b-bbea-ae09fc955394 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-26 21:18:24.747 +05:30 0d44996a-9189-4ca3-b233-5157de52f1b7 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-26 21:23:50.625 +05:30 a3947575-cf35-46ec-91a0-5d72a4fbdb39 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-26 21:23:50.773 +05:30 6928a132-11d6-4a1d-9a88-fe7b31f82b12 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-26 21:23:50.928 +05:30 eea0b016-8594-48c6-8f08-793b23560e73 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-26 21:39:17.997 +05:30 c1bb6789-33ff-4376-9e8a-a280f2738ba3 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-26 21:56:30.756 +05:30 e9d58ae6-c460-431a-bfe7-930f1a2e7383 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-26 21:56:30.927 +05:30 ec4a4e0d-161d-446e-9778-8e0586129476 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-26 21:56:31.116 +05:30 59d20d89-3338-4866-bf09-b12bf1cd57a9 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-26 23:16:33.008 +05:30 d9b0abd9-5ffd-4407-bdf0-526b933ae2e7 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-26 23:16:33.278 +05:30 d7160cee-7ac4-49f0-901d-15d4281e9d76 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-26 23:16:33.465 +05:30 128835be-ba7e-43dd-a431-4bcb6af9bd1b 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-26 23:16:33.644 +05:30 9b1ea64e-0929-4e61-9694-479b29f13886 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