2024-06-21 11:24:50.607 +05:30 0f9301c7-ef6e-402d-863e-016a8098fd64 ERR Procedure or function 'xsp_s_Role_AM' expects parameter '@Parent', which was not supplied. 2024-06-21 11:24:50.645 +05:30 0f9301c7-ef6e-402d-863e-016a8098fd64 ERR Database connection error: System.Data.SqlClient.SqlException (0x80131904): Procedure or function 'xsp_s_Role_AM' expects parameter '@Parent', which was not supplied. 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.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString) at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, SqlDataReader ds) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean asyncWrite, String method) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, Boolean sendToPipe, Int32 timeout, Boolean asyncWrite, String methodName) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at Sang.Service.Common.CommonService.CommonEntityService.ExecuteAndFetchOutput(SqlConnection connection, SqlTransaction transaction, String procedureName, SqlParameter[] parameters) at Sang.Security.Api.Repositories.RoleRepository.<>c__DisplayClass16_0.<b__0>d.MoveNext() in C:\SOURCECODE\Apps\Sang.Security.Api\Sang.Security.Api\Repositories\RoleRepository.cs:line 363 --- End of stack trace from previous location --- at Sang.Service.Common.CommonService.DbTransactionService.ExecuteTransactionAsync(Func`3 transactionAction) ClientConnectionId:2ce78bf8-d9c2-4900-9003-144d3558a51e Error Number:201,State:4,Class:16 2024-06-21 11:24:50.646 +05:30 0f9301c7-ef6e-402d-863e-016a8098fd64 ERR Procedure or function 'xsp_s_Role_AM' expects parameter '@Parent', which was not supplied. 2024-06-21 11:24:50.649 +05:30 0f9301c7-ef6e-402d-863e-016a8098fd64 ERR Role Upsertion failed.System.Data.SqlClient.SqlException (0x80131904): Procedure or function 'xsp_s_Role_AM' expects parameter '@Parent', which was not supplied. 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.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString) at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, SqlDataReader ds) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean asyncWrite, String method) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, Boolean sendToPipe, Int32 timeout, Boolean asyncWrite, String methodName) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at Sang.Service.Common.CommonService.CommonEntityService.ExecuteAndFetchOutput(SqlConnection connection, SqlTransaction transaction, String procedureName, SqlParameter[] parameters) at Sang.Security.Api.Repositories.RoleRepository.<>c__DisplayClass16_0.<b__0>d.MoveNext() in C:\SOURCECODE\Apps\Sang.Security.Api\Sang.Security.Api\Repositories\RoleRepository.cs:line 363 --- End of stack trace from previous location --- at Sang.Service.Common.CommonService.DbTransactionService.ExecuteTransactionAsync(Func`3 transactionAction) at Sang.Security.Api.Repositories.RoleRepository.UpsertRole(RoleRequest role) in C:\SOURCECODE\Apps\Sang.Security.Api\Sang.Security.Api\Repositories\RoleRepository.cs:line 323 at Sang.Security.Api.Services.RoleService.UpsertRole(RoleRequest role) in C:\SOURCECODE\Apps\Sang.Security.Api\Sang.Security.Api\Services\RoleService.cs:line 49 at Sang.Security.Api.Controllers.RoleController.UpsertRole(RoleRequest roleDetails) in C:\SOURCECODE\Apps\Sang.Security.Api\Sang.Security.Api\Controllers\RoleController.cs:line 292 ClientConnectionId:2ce78bf8-d9c2-4900-9003-144d3558a51e Error Number:201,State:4,Class:16