================================================== DateTime : 2026-09-06 10:59:28 AppStartupPath : /api/Auth/UpdateFcmToken Database : MagicDwell UserID : Anonymous UserIP : 27.59.87.247 MachineName : AVIDCLAN Source : Core Microsoft SqlClient Data Provider ErrorMessage : The INSERT statement conflicted with the FOREIGN KEY constraint "FK_Sessions_UserId". The conflict occurred in database "MagicDwell", table "dbo.AspNetUsers", column 'Id'. The statement has been terminated. StackTrace : at Microsoft.Data.SqlClient.SqlCommand.<>c.b__195_0(Task`1 result) at System.Threading.Tasks.ContinuationResultTaskFromResultTask`2.InnerInvoke() at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state) --- End of stack trace from previous location --- at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state) at System.Threading.Tasks.Task.ExecuteWithThreadLocal(Task& currentTaskSlot, Thread threadPoolThread) --- End of stack trace from previous location --- at Dapper.SqlMapper.QueryRowAsync[T](IDbConnection cnn, Row row, Type effectiveType, CommandDefinition command) in /_/Dapper/SqlMapper.Async.cs:line 489 at MagicDwell.Common.Helper.Dapper.DapperSQLManager`1.ExecuteAndLogAsync[T](Func`3 dbOperation, String storedProcedure, Object parameters, IDbTransaction transaction, String connectionStringOverride) in D:\Harsh\Project\DotNet\MagicDwell\src\MagicDwell.Common\Helper\Dapper\DapperSQLManager.cs:line 254 at MagicDwell.DAL.Services.Implementation.UserSessionService.UpdateFcmTokenAsync(String deviceId, String fcmToken, Nullable`1 appUserTypeId, String userId) in D:\Harsh\Project\DotNet\MagicDwell\src\MagicDwell.DAL\Services\Implementation\UserSessionService.cs:line 32 at MagicDwell.Api.Controller.AuthController.UpdateFcmToken(UpdateFcmTokenInput input) in D:\Harsh\Project\DotNet\MagicDwell\src\MagicDwell.Api\Controller\AuthController.cs:line 95 at lambda_method92(Closure, Object) at Microsoft.AspNetCore.Mvc.Infrastructure.ActionMethodExecutor.AwaitableObjectResultExecutor.Execute(ActionContext actionContext, IActionResultTypeMapper mapper, ObjectMethodExecutor executor, Object controller, Object[] arguments) at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.g__Awaited|12_0(ControllerActionInvoker invoker, ValueTask`1 actionResultValueTask) at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.g__Awaited|10_0(ControllerActionInvoker invoker, Task lastTask, State next, Scope scope, Object state, Boolean isCompleted) at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.Rethrow(ActionExecutedContextSealed context) at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.Next(State& next, Scope& scope, Object& state, Boolean& isCompleted) at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.g__Awaited|13_0(ControllerActionInvoker invoker, Task lastTask, State next, Scope scope, Object state, Boolean isCompleted) at Microsoft.AspNetCore.Mvc.Infrastructure.ResourceInvoker.g__Awaited|20_0(ResourceInvoker invoker, Task lastTask, State next, Scope scope, Object state, Boolean isCompleted) at Microsoft.AspNetCore.Mvc.Infrastructure.ResourceInvoker.g__Awaited|17_0(ResourceInvoker invoker, Task task, IDisposable scope) at Microsoft.AspNetCore.Mvc.Infrastructure.ResourceInvoker.g__Awaited|17_0(ResourceInvoker invoker, Task task, IDisposable scope) at MagicDwell.Api.Middlewares.ReqErrLoggingMiddleware.InvokeAsync(HttpContext context) in D:\Harsh\Project\DotNet\MagicDwell\src\MagicDwell.Api\Middlewares\ReqErrLoggingMiddleware.cs:line 90 Parameters : ================================================== ================================================== DateTime : 2026-09-06 10:59:37 AppStartupPath : /api/Auth/UpdateFcmToken Database : MagicDwell UserID : Anonymous UserIP : 27.59.87.247 MachineName : AVIDCLAN Source : Core Microsoft SqlClient Data Provider ErrorMessage : The INSERT statement conflicted with the FOREIGN KEY constraint "FK_Sessions_UserId". The conflict occurred in database "MagicDwell", table "dbo.AspNetUsers", column 'Id'. The statement has been terminated. StackTrace : at Microsoft.Data.SqlClient.SqlCommand.<>c.b__195_0(Task`1 result) at System.Threading.Tasks.ContinuationResultTaskFromResultTask`2.InnerInvoke() at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state) --- End of stack trace from previous location --- at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state) at System.Threading.Tasks.Task.ExecuteWithThreadLocal(Task& currentTaskSlot, Thread threadPoolThread) --- End of stack trace from previous location --- at Dapper.SqlMapper.QueryRowAsync[T](IDbConnection cnn, Row row, Type effectiveType, CommandDefinition command) in /_/Dapper/SqlMapper.Async.cs:line 489 at MagicDwell.Common.Helper.Dapper.DapperSQLManager`1.ExecuteAndLogAsync[T](Func`3 dbOperation, String storedProcedure, Object parameters, IDbTransaction transaction, String connectionStringOverride) in D:\Harsh\Project\DotNet\MagicDwell\src\MagicDwell.Common\Helper\Dapper\DapperSQLManager.cs:line 254 at MagicDwell.DAL.Services.Implementation.UserSessionService.UpdateFcmTokenAsync(String deviceId, String fcmToken, Nullable`1 appUserTypeId, String userId) in D:\Harsh\Project\DotNet\MagicDwell\src\MagicDwell.DAL\Services\Implementation\UserSessionService.cs:line 32 at MagicDwell.Api.Controller.AuthController.UpdateFcmToken(UpdateFcmTokenInput input) in D:\Harsh\Project\DotNet\MagicDwell\src\MagicDwell.Api\Controller\AuthController.cs:line 95 at lambda_method92(Closure, Object) at Microsoft.AspNetCore.Mvc.Infrastructure.ActionMethodExecutor.AwaitableObjectResultExecutor.Execute(ActionContext actionContext, IActionResultTypeMapper mapper, ObjectMethodExecutor executor, Object controller, Object[] arguments) at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.g__Awaited|12_0(ControllerActionInvoker invoker, ValueTask`1 actionResultValueTask) at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.g__Awaited|10_0(ControllerActionInvoker invoker, Task lastTask, State next, Scope scope, Object state, Boolean isCompleted) at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.Rethrow(ActionExecutedContextSealed context) at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.Next(State& next, Scope& scope, Object& state, Boolean& isCompleted) at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.g__Awaited|13_0(ControllerActionInvoker invoker, Task lastTask, State next, Scope scope, Object state, Boolean isCompleted) at Microsoft.AspNetCore.Mvc.Infrastructure.ResourceInvoker.g__Awaited|20_0(ResourceInvoker invoker, Task lastTask, State next, Scope scope, Object state, Boolean isCompleted) at Microsoft.AspNetCore.Mvc.Infrastructure.ResourceInvoker.g__Awaited|17_0(ResourceInvoker invoker, Task task, IDisposable scope) at Microsoft.AspNetCore.Mvc.Infrastructure.ResourceInvoker.g__Awaited|17_0(ResourceInvoker invoker, Task task, IDisposable scope) at MagicDwell.Api.Middlewares.ReqErrLoggingMiddleware.InvokeAsync(HttpContext context) in D:\Harsh\Project\DotNet\MagicDwell\src\MagicDwell.Api\Middlewares\ReqErrLoggingMiddleware.cs:line 90 Parameters : ================================================== ================================================== DateTime : 2026-09-06 10:59:46 AppStartupPath : /api/Auth/UpdateFcmToken Database : MagicDwell UserID : Anonymous UserIP : 27.59.87.247 MachineName : AVIDCLAN Source : Core Microsoft SqlClient Data Provider ErrorMessage : The INSERT statement conflicted with the FOREIGN KEY constraint "FK_Sessions_UserId". The conflict occurred in database "MagicDwell", table "dbo.AspNetUsers", column 'Id'. The statement has been terminated. StackTrace : at System.Threading.Tasks.ContinuationResultTaskFromResultTask`2.InnerInvoke() at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state) --- End of stack trace from previous location --- at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state) at System.Threading.Tasks.Task.ExecuteWithThreadLocal(Task& currentTaskSlot, Thread threadPoolThread) --- End of stack trace from previous location --- at Dapper.SqlMapper.QueryRowAsync[T](IDbConnection cnn, Row row, Type effectiveType, CommandDefinition command) in /_/Dapper/SqlMapper.Async.cs:line 489 at MagicDwell.Common.Helper.Dapper.DapperSQLManager`1.ExecuteAndLogAsync[T](Func`3 dbOperation, String storedProcedure, Object parameters, IDbTransaction transaction, String connectionStringOverride) at MagicDwell.DAL.Services.Implementation.UserSessionService.UpdateFcmTokenAsync(String deviceId, String fcmToken, Nullable`1 appUserTypeId, String userId) in D:\Harsh\Project\DotNet\MagicDwell\src\MagicDwell.DAL\Services\Implementation\UserSessionService.cs:line 32 at MagicDwell.Api.Controller.AuthController.UpdateFcmToken(UpdateFcmTokenInput input) in D:\Harsh\Project\DotNet\MagicDwell\src\MagicDwell.Api\Controller\AuthController.cs:line 95 at lambda_method92(Closure, Object) at Microsoft.AspNetCore.Mvc.Infrastructure.ActionMethodExecutor.AwaitableObjectResultExecutor.Execute(ActionContext actionContext, IActionResultTypeMapper mapper, ObjectMethodExecutor executor, Object controller, Object[] arguments) at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.g__Awaited|12_0(ControllerActionInvoker invoker, ValueTask`1 actionResultValueTask) at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.g__Awaited|10_0(ControllerActionInvoker invoker, Task lastTask, State next, Scope scope, Object state, Boolean isCompleted) at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.Rethrow(ActionExecutedContextSealed context) at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.Next(State& next, Scope& scope, Object& state, Boolean& isCompleted) at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.g__Awaited|13_0(ControllerActionInvoker invoker, Task lastTask, State next, Scope scope, Object state, Boolean isCompleted) at Microsoft.AspNetCore.Mvc.Infrastructure.ResourceInvoker.g__Awaited|20_0(ResourceInvoker invoker, Task lastTask, State next, Scope scope, Object state, Boolean isCompleted) at Microsoft.AspNetCore.Mvc.Infrastructure.ResourceInvoker.g__Awaited|17_0(ResourceInvoker invoker, Task task, IDisposable scope) at Microsoft.AspNetCore.Mvc.Infrastructure.ResourceInvoker.g__Awaited|17_0(ResourceInvoker invoker, Task task, IDisposable scope) at MagicDwell.Api.Middlewares.ReqErrLoggingMiddleware.InvokeAsync(HttpContext context) in D:\Harsh\Project\DotNet\MagicDwell\src\MagicDwell.Api\Middlewares\ReqErrLoggingMiddleware.cs:line 90 Parameters : ================================================== ================================================== DateTime : 2026-09-06 11:00:15 AppStartupPath : /api/Auth/UpdateFcmToken Database : MagicDwell UserID : Anonymous UserIP : 27.59.87.247 MachineName : AVIDCLAN Source : Core Microsoft SqlClient Data Provider ErrorMessage : The INSERT statement conflicted with the FOREIGN KEY constraint "FK_Sessions_UserId". The conflict occurred in database "MagicDwell", table "dbo.AspNetUsers", column 'Id'. The statement has been terminated. StackTrace : at System.Threading.Tasks.ContinuationResultTaskFromResultTask`2.InnerInvoke() at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state) --- End of stack trace from previous location --- at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state) at System.Threading.Tasks.Task.ExecuteWithThreadLocal(Task& currentTaskSlot, Thread threadPoolThread) --- End of stack trace from previous location --- at Dapper.SqlMapper.QueryRowAsync[T](IDbConnection cnn, Row row, Type effectiveType, CommandDefinition command) in /_/Dapper/SqlMapper.Async.cs:line 489 at MagicDwell.Common.Helper.Dapper.DapperSQLManager`1.ExecuteAndLogAsync[T](Func`3 dbOperation, String storedProcedure, Object parameters, IDbTransaction transaction, String connectionStringOverride) at MagicDwell.DAL.Services.Implementation.UserSessionService.UpdateFcmTokenAsync(String deviceId, String fcmToken, Nullable`1 appUserTypeId, String userId) in D:\Harsh\Project\DotNet\MagicDwell\src\MagicDwell.DAL\Services\Implementation\UserSessionService.cs:line 32 at MagicDwell.Api.Controller.AuthController.UpdateFcmToken(UpdateFcmTokenInput input) in D:\Harsh\Project\DotNet\MagicDwell\src\MagicDwell.Api\Controller\AuthController.cs:line 95 at lambda_method92(Closure, Object) at Microsoft.AspNetCore.Mvc.Infrastructure.ActionMethodExecutor.AwaitableObjectResultExecutor.Execute(ActionContext actionContext, IActionResultTypeMapper mapper, ObjectMethodExecutor executor, Object controller, Object[] arguments) at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.g__Awaited|12_0(ControllerActionInvoker invoker, ValueTask`1 actionResultValueTask) at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.g__Awaited|10_0(ControllerActionInvoker invoker, Task lastTask, State next, Scope scope, Object state, Boolean isCompleted) at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.Rethrow(ActionExecutedContextSealed context) at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.Next(State& next, Scope& scope, Object& state, Boolean& isCompleted) at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.g__Awaited|13_0(ControllerActionInvoker invoker, Task lastTask, State next, Scope scope, Object state, Boolean isCompleted) at Microsoft.AspNetCore.Mvc.Infrastructure.ResourceInvoker.g__Awaited|20_0(ResourceInvoker invoker, Task lastTask, State next, Scope scope, Object state, Boolean isCompleted) at Microsoft.AspNetCore.Mvc.Infrastructure.ResourceInvoker.g__Awaited|17_0(ResourceInvoker invoker, Task task, IDisposable scope) at Microsoft.AspNetCore.Mvc.Infrastructure.ResourceInvoker.g__Awaited|17_0(ResourceInvoker invoker, Task task, IDisposable scope) at MagicDwell.Api.Middlewares.ReqErrLoggingMiddleware.InvokeAsync(HttpContext context) in D:\Harsh\Project\DotNet\MagicDwell\src\MagicDwell.Api\Middlewares\ReqErrLoggingMiddleware.cs:line 90 Parameters : ================================================== ================================================== DateTime : 2026-09-06 11:01:11 AppStartupPath : /api/Event/SendOTP Database : MagicDwell UserID : Anonymous UserIP : 27.59.87.247 MachineName : AVIDCLAN Source : Core Microsoft SqlClient Data Provider ErrorMessage : The INSERT statement conflicted with the FOREIGN KEY constraint "FK_tbl_SMSLogs_UserId". The conflict occurred in database "MagicDwell", table "dbo.AspNetUsers", column 'Id'. The statement has been terminated. StackTrace : at Microsoft.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at Microsoft.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at Microsoft.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, SqlCommand command, Boolean callerHasConnectionLock, Boolean asyncClose) at Microsoft.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) at Microsoft.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString, Boolean isInternal, Boolean forDescribeParameterEncryption, Boolean shouldCacheForAlwaysEncrypted) at Microsoft.Data.SqlClient.SqlCommand.CompleteAsyncExecuteReader(Boolean isInternal, Boolean forDescribeParameterEncryption) at Microsoft.Data.SqlClient.SqlCommand.InternalEndExecuteNonQuery(IAsyncResult asyncResult, Boolean isInternal, String endMethod) at Microsoft.Data.SqlClient.SqlCommand.EndExecuteNonQueryInternal(IAsyncResult asyncResult) at Microsoft.Data.SqlClient.SqlCommand.EndExecuteNonQueryAsync(IAsyncResult asyncResult) at Microsoft.Data.SqlClient.SqlCommand.<>c.b__193_1(IAsyncResult asyncResult) at System.Threading.Tasks.TaskFactory`1.FromAsyncCoreLogic(IAsyncResult iar, Func`2 endFunction, Action`1 endAction, Task`1 promise, Boolean requiresSynchronization) --- End of stack trace from previous location --- at Dapper.SqlMapper.ExecuteImplAsync(IDbConnection cnn, CommandDefinition command, Object param) in /_/Dapper/SqlMapper.Async.cs:line 662 at MagicDwell.Common.Helper.Dapper.DapperSQLManager`1.ExecuteAndLogAsync[T](Func`3 dbOperation, String storedProcedure, Object parameters, IDbTransaction transaction, String connectionStringOverride) in D:\Harsh\Project\DotNet\MagicDwell\src\MagicDwell.Common\Helper\Dapper\DapperSQLManager.cs:line 254 at MagicDwell.Common.Helper.Dapper.DapperSQLManager`1.MultiAddEditAsync(List`1 steps, CommandType commandType) in D:\Harsh\Project\DotNet\MagicDwell\src\MagicDwell.Common\Helper\Dapper\DapperSQLManager.cs:line 193 at MagicDwell.Notification.Services.Implementation.EventPersistenceHelper.SaveWithOutputsAsync(String spName, Object model, String[] outputParams) in D:\Harsh\Project\DotNet\MagicDwell\src\MagicDwell.Notification\Services\Implementation\EventPersistenceHelper.cs:line 16 at MagicDwell.Notification.Services.SMS.Implementation.SMSService.SendSMS(SMSModuleNameEnum moduleName, String mobileNo) in D:\Harsh\Project\DotNet\MagicDwell\src\MagicDwell.Notification\Services\SMS\Implementation\SMSService.cs:line 137 at MagicDwell.Api.Controller.EventController.SendOTP(SendOTPRequestDto request) in D:\Harsh\Project\DotNet\MagicDwell\src\MagicDwell.Api\Controller\EventController.cs:line 58 at lambda_method380(Closure, Object) at Microsoft.AspNetCore.Mvc.Infrastructure.ActionMethodExecutor.AwaitableObjectResultExecutor.Execute(ActionContext actionContext, IActionResultTypeMapper mapper, ObjectMethodExecutor executor, Object controller, Object[] arguments) at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.g__Awaited|12_0(ControllerActionInvoker invoker, ValueTask`1 actionResultValueTask) at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.g__Awaited|10_0(ControllerActionInvoker invoker, Task lastTask, State next, Scope scope, Object state, Boolean isCompleted) at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.Rethrow(ActionExecutedContextSealed context) at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.Next(State& next, Scope& scope, Object& state, Boolean& isCompleted) at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.g__Awaited|13_0(ControllerActionInvoker invoker, Task lastTask, State next, Scope scope, Object state, Boolean isCompleted) at Microsoft.AspNetCore.Mvc.Infrastructure.ResourceInvoker.g__Awaited|20_0(ResourceInvoker invoker, Task lastTask, State next, Scope scope, Object state, Boolean isCompleted) at Microsoft.AspNetCore.Mvc.Infrastructure.ResourceInvoker.g__Awaited|17_0(ResourceInvoker invoker, Task task, IDisposable scope) at Microsoft.AspNetCore.Mvc.Infrastructure.ResourceInvoker.g__Awaited|17_0(ResourceInvoker invoker, Task task, IDisposable scope) at MagicDwell.Api.Middlewares.ReqErrLoggingMiddleware.InvokeAsync(HttpContext context) in D:\Harsh\Project\DotNet\MagicDwell\src\MagicDwell.Api\Middlewares\ReqErrLoggingMiddleware.cs:line 90 Parameters : ================================================== ================================================== DateTime : 2026-09-06 11:01:27 AppStartupPath : /api/Event/SendOTP Database : MagicDwell UserID : Anonymous UserIP : 27.59.87.247 MachineName : AVIDCLAN Source : Core Microsoft SqlClient Data Provider ErrorMessage : The INSERT statement conflicted with the FOREIGN KEY constraint "FK_tbl_SMSLogs_UserId". The conflict occurred in database "MagicDwell", table "dbo.AspNetUsers", column 'Id'. The statement has been terminated. StackTrace : at Microsoft.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at Microsoft.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at Microsoft.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, SqlCommand command, Boolean callerHasConnectionLock, Boolean asyncClose) at Microsoft.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) at Microsoft.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString, Boolean isInternal, Boolean forDescribeParameterEncryption, Boolean shouldCacheForAlwaysEncrypted) at Microsoft.Data.SqlClient.SqlCommand.CompleteAsyncExecuteReader(Boolean isInternal, Boolean forDescribeParameterEncryption) at Microsoft.Data.SqlClient.SqlCommand.InternalEndExecuteNonQuery(IAsyncResult asyncResult, Boolean isInternal, String endMethod) at Microsoft.Data.SqlClient.SqlCommand.EndExecuteNonQueryInternal(IAsyncResult asyncResult) at Microsoft.Data.SqlClient.SqlCommand.EndExecuteNonQueryAsync(IAsyncResult asyncResult) at Microsoft.Data.SqlClient.SqlCommand.<>c.b__193_1(IAsyncResult asyncResult) at System.Threading.Tasks.TaskFactory`1.FromAsyncCoreLogic(IAsyncResult iar, Func`2 endFunction, Action`1 endAction, Task`1 promise, Boolean requiresSynchronization) --- End of stack trace from previous location --- at Dapper.SqlMapper.ExecuteImplAsync(IDbConnection cnn, CommandDefinition command, Object param) in /_/Dapper/SqlMapper.Async.cs:line 662 at MagicDwell.Common.Helper.Dapper.DapperSQLManager`1.ExecuteAndLogAsync[T](Func`3 dbOperation, String storedProcedure, Object parameters, IDbTransaction transaction, String connectionStringOverride) in D:\Harsh\Project\DotNet\MagicDwell\src\MagicDwell.Common\Helper\Dapper\DapperSQLManager.cs:line 254 at MagicDwell.Common.Helper.Dapper.DapperSQLManager`1.MultiAddEditAsync(List`1 steps, CommandType commandType) in D:\Harsh\Project\DotNet\MagicDwell\src\MagicDwell.Common\Helper\Dapper\DapperSQLManager.cs:line 193 at MagicDwell.Notification.Services.Implementation.EventPersistenceHelper.SaveWithOutputsAsync(String spName, Object model, String[] outputParams) in D:\Harsh\Project\DotNet\MagicDwell\src\MagicDwell.Notification\Services\Implementation\EventPersistenceHelper.cs:line 16 at MagicDwell.Notification.Services.SMS.Implementation.SMSService.SendSMS(SMSModuleNameEnum moduleName, String mobileNo) in D:\Harsh\Project\DotNet\MagicDwell\src\MagicDwell.Notification\Services\SMS\Implementation\SMSService.cs:line 137 at MagicDwell.Api.Controller.EventController.SendOTP(SendOTPRequestDto request) in D:\Harsh\Project\DotNet\MagicDwell\src\MagicDwell.Api\Controller\EventController.cs:line 58 at lambda_method380(Closure, Object) at Microsoft.AspNetCore.Mvc.Infrastructure.ActionMethodExecutor.AwaitableObjectResultExecutor.Execute(ActionContext actionContext, IActionResultTypeMapper mapper, ObjectMethodExecutor executor, Object controller, Object[] arguments) at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.g__Awaited|12_0(ControllerActionInvoker invoker, ValueTask`1 actionResultValueTask) at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.g__Awaited|10_0(ControllerActionInvoker invoker, Task lastTask, State next, Scope scope, Object state, Boolean isCompleted) at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.Rethrow(ActionExecutedContextSealed context) at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.Next(State& next, Scope& scope, Object& state, Boolean& isCompleted) at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.g__Awaited|13_0(ControllerActionInvoker invoker, Task lastTask, State next, Scope scope, Object state, Boolean isCompleted) at Microsoft.AspNetCore.Mvc.Infrastructure.ResourceInvoker.g__Awaited|20_0(ResourceInvoker invoker, Task lastTask, State next, Scope scope, Object state, Boolean isCompleted) at Microsoft.AspNetCore.Mvc.Infrastructure.ResourceInvoker.g__Awaited|17_0(ResourceInvoker invoker, Task task, IDisposable scope) at Microsoft.AspNetCore.Mvc.Infrastructure.ResourceInvoker.g__Awaited|17_0(ResourceInvoker invoker, Task task, IDisposable scope) at MagicDwell.Api.Middlewares.ReqErrLoggingMiddleware.InvokeAsync(HttpContext context) in D:\Harsh\Project\DotNet\MagicDwell\src\MagicDwell.Api\Middlewares\ReqErrLoggingMiddleware.cs:line 90 Parameters : ================================================== ================================================== DateTime : 2026-09-06 11:01:37 AppStartupPath : /api/Event/SendOTP Database : MagicDwell UserID : Anonymous UserIP : 27.59.87.247 MachineName : AVIDCLAN Source : Core Microsoft SqlClient Data Provider ErrorMessage : The INSERT statement conflicted with the FOREIGN KEY constraint "FK_tbl_SMSLogs_UserId". The conflict occurred in database "MagicDwell", table "dbo.AspNetUsers", column 'Id'. The statement has been terminated. StackTrace : at Microsoft.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at Microsoft.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at Microsoft.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, SqlCommand command, Boolean callerHasConnectionLock, Boolean asyncClose) at Microsoft.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) at Microsoft.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString, Boolean isInternal, Boolean forDescribeParameterEncryption, Boolean shouldCacheForAlwaysEncrypted) at Microsoft.Data.SqlClient.SqlCommand.CompleteAsyncExecuteReader(Boolean isInternal, Boolean forDescribeParameterEncryption) at Microsoft.Data.SqlClient.SqlCommand.InternalEndExecuteNonQuery(IAsyncResult asyncResult, Boolean isInternal, String endMethod) at Microsoft.Data.SqlClient.SqlCommand.EndExecuteNonQueryInternal(IAsyncResult asyncResult) at Microsoft.Data.SqlClient.SqlCommand.EndExecuteNonQueryAsync(IAsyncResult asyncResult) at Microsoft.Data.SqlClient.SqlCommand.<>c.b__193_1(IAsyncResult asyncResult) at System.Threading.Tasks.TaskFactory`1.FromAsyncCoreLogic(IAsyncResult iar, Func`2 endFunction, Action`1 endAction, Task`1 promise, Boolean requiresSynchronization) --- End of stack trace from previous location --- at Dapper.SqlMapper.ExecuteImplAsync(IDbConnection cnn, CommandDefinition command, Object param) in /_/Dapper/SqlMapper.Async.cs:line 662 at MagicDwell.Common.Helper.Dapper.DapperSQLManager`1.ExecuteAndLogAsync[T](Func`3 dbOperation, String storedProcedure, Object parameters, IDbTransaction transaction, String connectionStringOverride) in D:\Harsh\Project\DotNet\MagicDwell\src\MagicDwell.Common\Helper\Dapper\DapperSQLManager.cs:line 254 at MagicDwell.Common.Helper.Dapper.DapperSQLManager`1.MultiAddEditAsync(List`1 steps, CommandType commandType) in D:\Harsh\Project\DotNet\MagicDwell\src\MagicDwell.Common\Helper\Dapper\DapperSQLManager.cs:line 193 at MagicDwell.Notification.Services.Implementation.EventPersistenceHelper.SaveWithOutputsAsync(String spName, Object model, String[] outputParams) in D:\Harsh\Project\DotNet\MagicDwell\src\MagicDwell.Notification\Services\Implementation\EventPersistenceHelper.cs:line 16 at MagicDwell.Notification.Services.SMS.Implementation.SMSService.SendSMS(SMSModuleNameEnum moduleName, String mobileNo) in D:\Harsh\Project\DotNet\MagicDwell\src\MagicDwell.Notification\Services\SMS\Implementation\SMSService.cs:line 137 at MagicDwell.Api.Controller.EventController.SendOTP(SendOTPRequestDto request) in D:\Harsh\Project\DotNet\MagicDwell\src\MagicDwell.Api\Controller\EventController.cs:line 58 at lambda_method380(Closure, Object) at Microsoft.AspNetCore.Mvc.Infrastructure.ActionMethodExecutor.AwaitableObjectResultExecutor.Execute(ActionContext actionContext, IActionResultTypeMapper mapper, ObjectMethodExecutor executor, Object controller, Object[] arguments) at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.g__Awaited|12_0(ControllerActionInvoker invoker, ValueTask`1 actionResultValueTask) at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.g__Awaited|10_0(ControllerActionInvoker invoker, Task lastTask, State next, Scope scope, Object state, Boolean isCompleted) at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.Rethrow(ActionExecutedContextSealed context) at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.Next(State& next, Scope& scope, Object& state, Boolean& isCompleted) at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.g__Awaited|13_0(ControllerActionInvoker invoker, Task lastTask, State next, Scope scope, Object state, Boolean isCompleted) at Microsoft.AspNetCore.Mvc.Infrastructure.ResourceInvoker.g__Awaited|20_0(ResourceInvoker invoker, Task lastTask, State next, Scope scope, Object state, Boolean isCompleted) at Microsoft.AspNetCore.Mvc.Infrastructure.ResourceInvoker.g__Awaited|17_0(ResourceInvoker invoker, Task task, IDisposable scope) at Microsoft.AspNetCore.Mvc.Infrastructure.ResourceInvoker.g__Awaited|17_0(ResourceInvoker invoker, Task task, IDisposable scope) at MagicDwell.Api.Middlewares.ReqErrLoggingMiddleware.InvokeAsync(HttpContext context) in D:\Harsh\Project\DotNet\MagicDwell\src\MagicDwell.Api\Middlewares\ReqErrLoggingMiddleware.cs:line 90 Parameters : ================================================== ================================================== DateTime : 2026-09-06 11:01:43 AppStartupPath : /api/Auth/UpdateFcmToken Database : MagicDwell UserID : Anonymous UserIP : 27.59.87.247 MachineName : AVIDCLAN Source : Core Microsoft SqlClient Data Provider ErrorMessage : The INSERT statement conflicted with the FOREIGN KEY constraint "FK_Sessions_UserId". The conflict occurred in database "MagicDwell", table "dbo.AspNetUsers", column 'Id'. The statement has been terminated. StackTrace : at System.Threading.Tasks.ContinuationResultTaskFromResultTask`2.InnerInvoke() at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state) --- End of stack trace from previous location --- at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state) at System.Threading.Tasks.Task.ExecuteWithThreadLocal(Task& currentTaskSlot, Thread threadPoolThread) --- End of stack trace from previous location --- at Dapper.SqlMapper.QueryRowAsync[T](IDbConnection cnn, Row row, Type effectiveType, CommandDefinition command) in /_/Dapper/SqlMapper.Async.cs:line 489 at MagicDwell.Common.Helper.Dapper.DapperSQLManager`1.ExecuteAndLogAsync[T](Func`3 dbOperation, String storedProcedure, Object parameters, IDbTransaction transaction, String connectionStringOverride) at MagicDwell.DAL.Services.Implementation.UserSessionService.UpdateFcmTokenAsync(String deviceId, String fcmToken, Nullable`1 appUserTypeId, String userId) in D:\Harsh\Project\DotNet\MagicDwell\src\MagicDwell.DAL\Services\Implementation\UserSessionService.cs:line 32 at MagicDwell.Api.Controller.AuthController.UpdateFcmToken(UpdateFcmTokenInput input) in D:\Harsh\Project\DotNet\MagicDwell\src\MagicDwell.Api\Controller\AuthController.cs:line 95 at lambda_method92(Closure, Object) at Microsoft.AspNetCore.Mvc.Infrastructure.ActionMethodExecutor.AwaitableObjectResultExecutor.Execute(ActionContext actionContext, IActionResultTypeMapper mapper, ObjectMethodExecutor executor, Object controller, Object[] arguments) at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.g__Awaited|12_0(ControllerActionInvoker invoker, ValueTask`1 actionResultValueTask) at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.g__Awaited|10_0(ControllerActionInvoker invoker, Task lastTask, State next, Scope scope, Object state, Boolean isCompleted) at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.Rethrow(ActionExecutedContextSealed context) at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.Next(State& next, Scope& scope, Object& state, Boolean& isCompleted) at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.g__Awaited|13_0(ControllerActionInvoker invoker, Task lastTask, State next, Scope scope, Object state, Boolean isCompleted) at Microsoft.AspNetCore.Mvc.Infrastructure.ResourceInvoker.g__Awaited|20_0(ResourceInvoker invoker, Task lastTask, State next, Scope scope, Object state, Boolean isCompleted) at Microsoft.AspNetCore.Mvc.Infrastructure.ResourceInvoker.g__Awaited|17_0(ResourceInvoker invoker, Task task, IDisposable scope) at Microsoft.AspNetCore.Mvc.Infrastructure.ResourceInvoker.g__Awaited|17_0(ResourceInvoker invoker, Task task, IDisposable scope) at MagicDwell.Api.Middlewares.ReqErrLoggingMiddleware.InvokeAsync(HttpContext context) in D:\Harsh\Project\DotNet\MagicDwell\src\MagicDwell.Api\Middlewares\ReqErrLoggingMiddleware.cs:line 90 Parameters : ================================================== ================================================== DateTime : 2026-09-06 11:03:33 AppStartupPath : /api/Auth/UpdateFcmToken Database : MagicDwell UserID : Anonymous UserIP : 27.59.87.247 MachineName : AVIDCLAN Source : Core Microsoft SqlClient Data Provider ErrorMessage : The INSERT statement conflicted with the FOREIGN KEY constraint "FK_Sessions_UserId". The conflict occurred in database "MagicDwell", table "dbo.AspNetUsers", column 'Id'. The statement has been terminated. StackTrace : at System.Threading.Tasks.ContinuationResultTaskFromResultTask`2.InnerInvoke() at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state) --- End of stack trace from previous location --- at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state) at System.Threading.Tasks.Task.ExecuteWithThreadLocal(Task& currentTaskSlot, Thread threadPoolThread) --- End of stack trace from previous location --- at Dapper.SqlMapper.QueryRowAsync[T](IDbConnection cnn, Row row, Type effectiveType, CommandDefinition command) in /_/Dapper/SqlMapper.Async.cs:line 489 at MagicDwell.Common.Helper.Dapper.DapperSQLManager`1.ExecuteAndLogAsync[T](Func`3 dbOperation, String storedProcedure, Object parameters, IDbTransaction transaction, String connectionStringOverride) at MagicDwell.DAL.Services.Implementation.UserSessionService.UpdateFcmTokenAsync(String deviceId, String fcmToken, Nullable`1 appUserTypeId, String userId) in D:\Harsh\Project\DotNet\MagicDwell\src\MagicDwell.DAL\Services\Implementation\UserSessionService.cs:line 32 at MagicDwell.Api.Controller.AuthController.UpdateFcmToken(UpdateFcmTokenInput input) in D:\Harsh\Project\DotNet\MagicDwell\src\MagicDwell.Api\Controller\AuthController.cs:line 95 at lambda_method92(Closure, Object) at Microsoft.AspNetCore.Mvc.Infrastructure.ActionMethodExecutor.AwaitableObjectResultExecutor.Execute(ActionContext actionContext, IActionResultTypeMapper mapper, ObjectMethodExecutor executor, Object controller, Object[] arguments) at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.g__Awaited|12_0(ControllerActionInvoker invoker, ValueTask`1 actionResultValueTask) at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.g__Awaited|10_0(ControllerActionInvoker invoker, Task lastTask, State next, Scope scope, Object state, Boolean isCompleted) at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.Rethrow(ActionExecutedContextSealed context) at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.Next(State& next, Scope& scope, Object& state, Boolean& isCompleted) at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.g__Awaited|13_0(ControllerActionInvoker invoker, Task lastTask, State next, Scope scope, Object state, Boolean isCompleted) at Microsoft.AspNetCore.Mvc.Infrastructure.ResourceInvoker.g__Awaited|20_0(ResourceInvoker invoker, Task lastTask, State next, Scope scope, Object state, Boolean isCompleted) at Microsoft.AspNetCore.Mvc.Infrastructure.ResourceInvoker.g__Awaited|17_0(ResourceInvoker invoker, Task task, IDisposable scope) at Microsoft.AspNetCore.Mvc.Infrastructure.ResourceInvoker.g__Awaited|17_0(ResourceInvoker invoker, Task task, IDisposable scope) at MagicDwell.Api.Middlewares.ReqErrLoggingMiddleware.InvokeAsync(HttpContext context) in D:\Harsh\Project\DotNet\MagicDwell\src\MagicDwell.Api\Middlewares\ReqErrLoggingMiddleware.cs:line 90 Parameters : ==================================================