{"Timestamp":"2025-01-07T00:53:14.7030180+00:00","Level":"Information","MessageTemplate":" Background Task: Refresh Session Booking Status Started {@Timestamp}","Properties":{"Timestamp":"2025-01-07T00:53:14.7030020Z"}} {"Timestamp":"2025-01-07T00:53:14.7101959+00:00","Level":"Information","MessageTemplate":" Background Task: Refresh Session Booking Status Completed {@Timestamp}","Properties":{"Timestamp":"2025-01-07T00:53:14.7101845Z"}} {"Timestamp":"2025-01-07T01:53:14.7170054+00:00","Level":"Information","MessageTemplate":" Background Task: Refresh Session Booking Status Started {@Timestamp}","Properties":{"Timestamp":"2025-01-07T01:53:14.7169863Z"}} {"Timestamp":"2025-01-07T01:53:14.7254869+00:00","Level":"Information","MessageTemplate":" Background Task: Refresh Session Booking Status Completed {@Timestamp}","Properties":{"Timestamp":"2025-01-07T01:53:14.7254642Z"}} {"Timestamp":"2025-01-07T02:53:14.7074565+00:00","Level":"Information","MessageTemplate":" Background Task: Refresh Session Booking Status Started {@Timestamp}","Properties":{"Timestamp":"2025-01-07T02:53:14.7074415Z"}} {"Timestamp":"2025-01-07T02:53:14.7158009+00:00","Level":"Information","MessageTemplate":" Background Task: Refresh Session Booking Status Completed {@Timestamp}","Properties":{"Timestamp":"2025-01-07T02:53:14.7157793Z"}} {"Timestamp":"2025-01-07T03:53:14.7045103+00:00","Level":"Information","MessageTemplate":" Background Task: Refresh Session Booking Status Started {@Timestamp}","Properties":{"Timestamp":"2025-01-07T03:53:14.7044957Z"}} {"Timestamp":"2025-01-07T03:53:14.7118983+00:00","Level":"Information","MessageTemplate":" Background Task: Refresh Session Booking Status Completed {@Timestamp}","Properties":{"Timestamp":"2025-01-07T03:53:14.7118772Z"}} {"Timestamp":"2025-01-07T04:53:14.7063884+00:00","Level":"Information","MessageTemplate":" Background Task: Refresh Session Booking Status Started {@Timestamp}","Properties":{"Timestamp":"2025-01-07T04:53:14.7063731Z"}} {"Timestamp":"2025-01-07T04:53:14.7151907+00:00","Level":"Information","MessageTemplate":" Background Task: Refresh Session Booking Status Completed {@Timestamp}","Properties":{"Timestamp":"2025-01-07T04:53:14.7151693Z"}} {"Timestamp":"2025-01-07T05:53:14.7047585+00:00","Level":"Information","MessageTemplate":" Background Task: Refresh Session Booking Status Started {@Timestamp}","Properties":{"Timestamp":"2025-01-07T05:53:14.7047429Z"}} {"Timestamp":"2025-01-07T05:53:14.7126814+00:00","Level":"Information","MessageTemplate":" Background Task: Refresh Session Booking Status Completed {@Timestamp}","Properties":{"Timestamp":"2025-01-07T05:53:14.7126674Z"}} {"Timestamp":"2025-01-07T06:53:14.7097215+00:00","Level":"Information","MessageTemplate":" Background Task: Refresh Session Booking Status Started {@Timestamp}","Properties":{"Timestamp":"2025-01-07T06:53:14.7097065Z"}} {"Timestamp":"2025-01-07T06:53:14.7181365+00:00","Level":"Information","MessageTemplate":" Background Task: Refresh Session Booking Status Completed {@Timestamp}","Properties":{"Timestamp":"2025-01-07T06:53:14.7181201Z"}} {"Timestamp":"2025-01-07T07:53:14.7278213+00:00","Level":"Information","MessageTemplate":" Background Task: Refresh Session Booking Status Started {@Timestamp}","Properties":{"Timestamp":"2025-01-07T07:53:14.7278049Z"}} {"Timestamp":"2025-01-07T07:53:14.7362660+00:00","Level":"Information","MessageTemplate":" Background Task: Refresh Session Booking Status Completed {@Timestamp}","Properties":{"Timestamp":"2025-01-07T07:53:14.7362451Z"}} {"Timestamp":"2025-01-07T08:20:29.7887088+00:00","Level":"Information","MessageTemplate":"User Signed in Successfully:{@Username}, {@Email} ,{@TimestampUTC} ","TraceId":"4991acaf127d3e37237507e7a0a89a58","SpanId":"7ca82f9739d69481","Properties":{"Username":"patient test","Email":"patient@gmail.com","TimestampUTC":"2025-01-07T08:20:29.7886866Z","ActionName":"UserController.Signin ","RequestPath":"/api/User/Signin"}} {"Timestamp":"2025-01-07T08:20:29.7906762+00:00","Level":"Error","MessageTemplate":"Failed executing DbCommand ({elapsed}ms) [Parameters=[{parameters}], CommandType='{commandType}', CommandTimeout='{commandTimeout}']{newLine}{commandText}","TraceId":"4991acaf127d3e37237507e7a0a89a58","SpanId":"7ca82f9739d69481","Properties":{"elapsed":"93","parameters":"@__user_Id_0='?' (Size = 255)","commandType":"Text","commandTimeout":30,"newLine":"\n","commandText":"SELECT `a`.`Id`, `a`.`ClaimType`, `a`.`ClaimValue`, `a`.`UserId`\nFROM `AspNetUserClaims` AS `a`\nWHERE `a`.`UserId` = @__user_Id_0","EventId":{"Id":20102,"Name":"Microsoft.EntityFrameworkCore.Database.Command.CommandError"},"ActionName":"UserController.Signin ","RequestPath":"/api/User/Signin"}} {"Timestamp":"2025-01-07T08:20:29.7920061+00:00","Level":"Error","MessageTemplate":"An exception occurred while iterating over the results of a query for context type '{contextType}'.{newline}{error}","TraceId":"4991acaf127d3e37237507e7a0a89a58","SpanId":"7ca82f9739d69481","Exception":"System.NullReferenceException: Object reference not set to an instance of an object.\n at MySqlConnector.MySqlDataReader.ActivateResultSet(CancellationToken cancellationToken) in /_/src/MySqlConnector/MySqlDataReader.cs:line 133\n at MySqlConnector.MySqlDataReader.CreateAsync(CommandListPosition commandListPosition, ICommandPayloadCreator payloadCreator, IDictionary`2 cachedProcedures, IMySqlCommand command, CommandBehavior behavior, Activity activity, IOBehavior ioBehavior, CancellationToken cancellationToken) in /_/src/MySqlConnector/MySqlDataReader.cs:line 493\n at MySqlConnector.Core.CommandExecutor.ExecuteReaderAsync(IReadOnlyList`1 commands, ICommandPayloadCreator payloadCreator, CommandBehavior behavior, Activity activity, IOBehavior ioBehavior, CancellationToken cancellationToken) in /_/src/MySqlConnector/Core/CommandExecutor.cs:line 77\n at MySqlConnector.MySqlCommand.ExecuteReaderAsync(CommandBehavior behavior, IOBehavior ioBehavior, CancellationToken cancellationToken) in /_/src/MySqlConnector/MySqlCommand.cs:line 345\n at MySqlConnector.MySqlCommand.ExecuteDbDataReaderAsync(CommandBehavior behavior, CancellationToken cancellationToken) in /_/src/MySqlConnector/MySqlCommand.cs:line 337\n at Microsoft.EntityFrameworkCore.Storage.RelationalCommand.ExecuteReaderAsync(RelationalCommandParameterObject parameterObject, CancellationToken cancellationToken)\n at Microsoft.EntityFrameworkCore.Storage.RelationalCommand.ExecuteReaderAsync(RelationalCommandParameterObject parameterObject, CancellationToken cancellationToken)\n at Microsoft.EntityFrameworkCore.Query.Internal.SingleQueryingEnumerable`1.AsyncEnumerator.InitializeReaderAsync(AsyncEnumerator enumerator, CancellationToken cancellationToken)\n at Pomelo.EntityFrameworkCore.MySql.Storage.Internal.MySqlExecutionStrategy.ExecuteAsync[TState,TResult](TState state, Func`4 operation, Func`4 verifySucceeded, CancellationToken cancellationToken)\n at Microsoft.EntityFrameworkCore.Query.Internal.SingleQueryingEnumerable`1.AsyncEnumerator.MoveNextAsync()","Properties":{"contextType":"OnlineClinic.DAL.OC_DBContext","newline":"\n","error":"System.NullReferenceException: Object reference not set to an instance of an object.\n at MySqlConnector.MySqlDataReader.ActivateResultSet(CancellationToken cancellationToken) in /_/src/MySqlConnector/MySqlDataReader.cs:line 133\n at MySqlConnector.MySqlDataReader.CreateAsync(CommandListPosition commandListPosition, ICommandPayloadCreator payloadCreator, IDictionary`2 cachedProcedures, IMySqlCommand command, CommandBehavior behavior, Activity activity, IOBehavior ioBehavior, CancellationToken cancellationToken) in /_/src/MySqlConnector/MySqlDataReader.cs:line 493\n at MySqlConnector.Core.CommandExecutor.ExecuteReaderAsync(IReadOnlyList`1 commands, ICommandPayloadCreator payloadCreator, CommandBehavior behavior, Activity activity, IOBehavior ioBehavior, CancellationToken cancellationToken) in /_/src/MySqlConnector/Core/CommandExecutor.cs:line 77\n at MySqlConnector.MySqlCommand.ExecuteReaderAsync(CommandBehavior behavior, IOBehavior ioBehavior, CancellationToken cancellationToken) in /_/src/MySqlConnector/MySqlCommand.cs:line 345\n at MySqlConnector.MySqlCommand.ExecuteDbDataReaderAsync(CommandBehavior behavior, CancellationToken cancellationToken) in /_/src/MySqlConnector/MySqlCommand.cs:line 337\n at Microsoft.EntityFrameworkCore.Storage.RelationalCommand.ExecuteReaderAsync(RelationalCommandParameterObject parameterObject, CancellationToken cancellationToken)\n at Microsoft.EntityFrameworkCore.Storage.RelationalCommand.ExecuteReaderAsync(RelationalCommandParameterObject parameterObject, CancellationToken cancellationToken)\n at Microsoft.EntityFrameworkCore.Query.Internal.SingleQueryingEnumerable`1.AsyncEnumerator.InitializeReaderAsync(AsyncEnumerator enumerator, CancellationToken cancellationToken)\n at Pomelo.EntityFrameworkCore.MySql.Storage.Internal.MySqlExecutionStrategy.ExecuteAsync[TState,TResult](TState state, Func`4 operation, Func`4 verifySucceeded, CancellationToken cancellationToken)\n at Microsoft.EntityFrameworkCore.Query.Internal.SingleQueryingEnumerable`1.AsyncEnumerator.MoveNextAsync()","EventId":{"Id":10100,"Name":"Microsoft.EntityFrameworkCore.Query.QueryIterationFailed"},"ActionName":"UserController.Signin ","RequestPath":"/api/User/Signin"}} {"Timestamp":"2025-01-07T08:53:14.7083732+00:00","Level":"Information","MessageTemplate":" Background Task: Refresh Session Booking Status Started {@Timestamp}","Properties":{"Timestamp":"2025-01-07T08:53:14.7083556Z"}} {"Timestamp":"2025-01-07T08:53:14.7162844+00:00","Level":"Information","MessageTemplate":" Background Task: Refresh Session Booking Status Completed {@Timestamp}","Properties":{"Timestamp":"2025-01-07T08:53:14.7162674Z"}} {"Timestamp":"2025-01-07T09:53:14.6746696+00:00","Level":"Information","MessageTemplate":" Background Task: Refresh Session Booking Status Started {@Timestamp}","Properties":{"Timestamp":"2025-01-07T09:53:14.6746480Z"}} {"Timestamp":"2025-01-07T09:53:14.6802512+00:00","Level":"Information","MessageTemplate":" Background Task: Refresh Session Booking Status Completed {@Timestamp}","Properties":{"Timestamp":"2025-01-07T09:53:14.6802358Z"}} {"Timestamp":"2025-01-07T10:53:14.7104307+00:00","Level":"Information","MessageTemplate":" Background Task: Refresh Session Booking Status Started {@Timestamp}","Properties":{"Timestamp":"2025-01-07T10:53:14.7104155Z"}} {"Timestamp":"2025-01-07T10:53:14.7185714+00:00","Level":"Information","MessageTemplate":" Background Task: Refresh Session Booking Status Completed {@Timestamp}","Properties":{"Timestamp":"2025-01-07T10:53:14.7185553Z"}} {"Timestamp":"2025-01-07T10:59:46.2776445+00:00","Level":"Information","MessageTemplate":"User Signed in Successfully:{@Username}, {@Email} ,{@TimestampUTC} ","TraceId":"319c2bf56639951d9f8ea0cbaf67d0f4","SpanId":"e7bfeccdb394f3d3","Properties":{"Username":"patient test","Email":"patient@gmail.com","TimestampUTC":"2025-01-07T10:59:46.2776210Z","ActionName":"UserController.Signin ","RequestPath":"/api/User/Signin"}} {"Timestamp":"2025-01-07T10:59:46.2798912+00:00","Level":"Error","MessageTemplate":"Failed executing DbCommand ({elapsed}ms) [Parameters=[{parameters}], CommandType='{commandType}', CommandTimeout='{commandTimeout}']{newLine}{commandText}","TraceId":"319c2bf56639951d9f8ea0cbaf67d0f4","SpanId":"e7bfeccdb394f3d3","Properties":{"elapsed":"71","parameters":"@__user_Id_0='?' (Size = 255)","commandType":"Text","commandTimeout":30,"newLine":"\n","commandText":"SELECT `a`.`Id`, `a`.`ClaimType`, `a`.`ClaimValue`, `a`.`UserId`\nFROM `AspNetUserClaims` AS `a`\nWHERE `a`.`UserId` = @__user_Id_0","EventId":{"Id":20102,"Name":"Microsoft.EntityFrameworkCore.Database.Command.CommandError"},"ActionName":"UserController.Signin ","RequestPath":"/api/User/Signin"}} {"Timestamp":"2025-01-07T10:59:46.2809527+00:00","Level":"Error","MessageTemplate":"An exception occurred while iterating over the results of a query for context type '{contextType}'.{newline}{error}","TraceId":"319c2bf56639951d9f8ea0cbaf67d0f4","SpanId":"e7bfeccdb394f3d3","Exception":"System.NullReferenceException: Object reference not set to an instance of an object.\n at MySqlConnector.MySqlDataReader.ActivateResultSet(CancellationToken cancellationToken) in /_/src/MySqlConnector/MySqlDataReader.cs:line 133\n at MySqlConnector.MySqlDataReader.CreateAsync(CommandListPosition commandListPosition, ICommandPayloadCreator payloadCreator, IDictionary`2 cachedProcedures, IMySqlCommand command, CommandBehavior behavior, Activity activity, IOBehavior ioBehavior, CancellationToken cancellationToken) in /_/src/MySqlConnector/MySqlDataReader.cs:line 493\n at MySqlConnector.Core.CommandExecutor.ExecuteReaderAsync(IReadOnlyList`1 commands, ICommandPayloadCreator payloadCreator, CommandBehavior behavior, Activity activity, IOBehavior ioBehavior, CancellationToken cancellationToken) in /_/src/MySqlConnector/Core/CommandExecutor.cs:line 77\n at MySqlConnector.MySqlCommand.ExecuteReaderAsync(CommandBehavior behavior, IOBehavior ioBehavior, CancellationToken cancellationToken) in /_/src/MySqlConnector/MySqlCommand.cs:line 345\n at MySqlConnector.MySqlCommand.ExecuteDbDataReaderAsync(CommandBehavior behavior, CancellationToken cancellationToken) in /_/src/MySqlConnector/MySqlCommand.cs:line 337\n at Microsoft.EntityFrameworkCore.Storage.RelationalCommand.ExecuteReaderAsync(RelationalCommandParameterObject parameterObject, CancellationToken cancellationToken)\n at Microsoft.EntityFrameworkCore.Storage.RelationalCommand.ExecuteReaderAsync(RelationalCommandParameterObject parameterObject, CancellationToken cancellationToken)\n at Microsoft.EntityFrameworkCore.Query.Internal.SingleQueryingEnumerable`1.AsyncEnumerator.InitializeReaderAsync(AsyncEnumerator enumerator, CancellationToken cancellationToken)\n at Pomelo.EntityFrameworkCore.MySql.Storage.Internal.MySqlExecutionStrategy.ExecuteAsync[TState,TResult](TState state, Func`4 operation, Func`4 verifySucceeded, CancellationToken cancellationToken)\n at Microsoft.EntityFrameworkCore.Query.Internal.SingleQueryingEnumerable`1.AsyncEnumerator.MoveNextAsync()","Properties":{"contextType":"OnlineClinic.DAL.OC_DBContext","newline":"\n","error":"System.NullReferenceException: Object reference not set to an instance of an object.\n at MySqlConnector.MySqlDataReader.ActivateResultSet(CancellationToken cancellationToken) in /_/src/MySqlConnector/MySqlDataReader.cs:line 133\n at MySqlConnector.MySqlDataReader.CreateAsync(CommandListPosition commandListPosition, ICommandPayloadCreator payloadCreator, IDictionary`2 cachedProcedures, IMySqlCommand command, CommandBehavior behavior, Activity activity, IOBehavior ioBehavior, CancellationToken cancellationToken) in /_/src/MySqlConnector/MySqlDataReader.cs:line 493\n at MySqlConnector.Core.CommandExecutor.ExecuteReaderAsync(IReadOnlyList`1 commands, ICommandPayloadCreator payloadCreator, CommandBehavior behavior, Activity activity, IOBehavior ioBehavior, CancellationToken cancellationToken) in /_/src/MySqlConnector/Core/CommandExecutor.cs:line 77\n at MySqlConnector.MySqlCommand.ExecuteReaderAsync(CommandBehavior behavior, IOBehavior ioBehavior, CancellationToken cancellationToken) in /_/src/MySqlConnector/MySqlCommand.cs:line 345\n at MySqlConnector.MySqlCommand.ExecuteDbDataReaderAsync(CommandBehavior behavior, CancellationToken cancellationToken) in /_/src/MySqlConnector/MySqlCommand.cs:line 337\n at Microsoft.EntityFrameworkCore.Storage.RelationalCommand.ExecuteReaderAsync(RelationalCommandParameterObject parameterObject, CancellationToken cancellationToken)\n at Microsoft.EntityFrameworkCore.Storage.RelationalCommand.ExecuteReaderAsync(RelationalCommandParameterObject parameterObject, CancellationToken cancellationToken)\n at Microsoft.EntityFrameworkCore.Query.Internal.SingleQueryingEnumerable`1.AsyncEnumerator.InitializeReaderAsync(AsyncEnumerator enumerator, CancellationToken cancellationToken)\n at Pomelo.EntityFrameworkCore.MySql.Storage.Internal.MySqlExecutionStrategy.ExecuteAsync[TState,TResult](TState state, Func`4 operation, Func`4 verifySucceeded, CancellationToken cancellationToken)\n at Microsoft.EntityFrameworkCore.Query.Internal.SingleQueryingEnumerable`1.AsyncEnumerator.MoveNextAsync()","EventId":{"Id":10100,"Name":"Microsoft.EntityFrameworkCore.Query.QueryIterationFailed"},"ActionName":"UserController.Signin ","RequestPath":"/api/User/Signin"}} {"Timestamp":"2025-01-07T10:59:46.2795272+00:00","Level":"Error","MessageTemplate":"Connection id \"{ConnectionId}\", Request id \"{TraceIdentifier}\": An unhandled exception was thrown by the application.","TraceId":"319c2bf56639951d9f8ea0cbaf67d0f4","SpanId":"e7bfeccdb394f3d3","Exception":"System.NullReferenceException: Object reference not set to an instance of an object.\n at MySqlConnector.MySqlConnection.FinishQuerying(Boolean hasWarnings) in /_/src/MySqlConnector/MySqlConnection.cs:line 906\n at MySqlConnector.MySqlDataReader.DisposeAsync(IOBehavior ioBehavior, CancellationToken cancellationToken) in /_/src/MySqlConnector/MySqlDataReader.cs:line 639\n at MySqlConnector.MySqlConnection.CloseDatabaseAsync(IOBehavior ioBehavior, CancellationToken cancellationToken) in /_/src/MySqlConnector/MySqlConnection.cs:line 1101\n at MySqlConnector.MySqlConnection.DoCloseAsync(Boolean changeState, IOBehavior ioBehavior) in /_/src/MySqlConnector/MySqlConnection.cs:line 1075\n at MySqlConnector.MySqlConnection.DoCloseAsync(Boolean changeState, IOBehavior ioBehavior) in /_/src/MySqlConnector/MySqlConnection.cs:line 1094\n at MySqlConnector.MySqlConnection.CloseAsync(Boolean changeState, IOBehavior ioBehavior) in /_/src/MySqlConnector/MySqlConnection.cs:line 1026\n at MySqlConnector.MySqlConnection.DisposeAsync() in /_/src/MySqlConnector/MySqlConnection.cs:line 704\n at Microsoft.EntityFrameworkCore.Storage.RelationalConnection.DisposeDbConnectionAsync()\n at Microsoft.EntityFrameworkCore.Storage.RelationalConnection.ResetStateAsync(Boolean disposeDbConnection)\n at Microsoft.Extensions.DependencyInjection.ServiceLookup.ServiceProviderEngineScope.g__Await|26_0(Int32 i, ValueTask vt, List`1 toDispose)\n at Microsoft.EntityFrameworkCore.DbContext.DisposeAsync()\n at Microsoft.Extensions.DependencyInjection.ServiceLookup.ServiceProviderEngineScope.g__Await|26_0(Int32 i, ValueTask vt, List`1 toDispose)\n at Microsoft.AspNetCore.Http.Features.RequestServicesFeature.g__Awaited|9_0(RequestServicesFeature servicesFeature, ValueTask vt)\n at Microsoft.AspNetCore.Server.Kestrel.Core.Internal.Http.HttpProtocol.g__ProcessEvents|242_0(HttpProtocol protocol, Stack`1 events)","Properties":{"TraceIdentifier":"0HN8FNHIBIOGL:00000004","EventId":{"Id":13,"Name":"ApplicationError"},"RequestPath":"/api/User/Signin"}} {"Timestamp":"2025-01-07T11:53:14.7124638+00:00","Level":"Information","MessageTemplate":" Background Task: Refresh Session Booking Status Started {@Timestamp}","Properties":{"Timestamp":"2025-01-07T11:53:14.7124475Z"}} {"Timestamp":"2025-01-07T11:53:14.7207220+00:00","Level":"Information","MessageTemplate":" Background Task: Refresh Session Booking Status Completed {@Timestamp}","Properties":{"Timestamp":"2025-01-07T11:53:14.7207034Z"}} {"Timestamp":"2025-01-07T12:53:14.7080351+00:00","Level":"Information","MessageTemplate":" Background Task: Refresh Session Booking Status Started {@Timestamp}","Properties":{"Timestamp":"2025-01-07T12:53:14.7080167Z"}} {"Timestamp":"2025-01-07T12:53:14.7195209+00:00","Level":"Information","MessageTemplate":" Background Task: Refresh Session Booking Status Completed {@Timestamp}","Properties":{"Timestamp":"2025-01-07T12:53:14.7194984Z"}} {"Timestamp":"2025-01-07T13:53:14.7117541+00:00","Level":"Information","MessageTemplate":" Background Task: Refresh Session Booking Status Started {@Timestamp}","Properties":{"Timestamp":"2025-01-07T13:53:14.7117387Z"}} {"Timestamp":"2025-01-07T13:53:14.7197588+00:00","Level":"Information","MessageTemplate":" Background Task: Refresh Session Booking Status Completed {@Timestamp}","Properties":{"Timestamp":"2025-01-07T13:53:14.7197429Z"}} {"Timestamp":"2025-01-07T14:53:14.7183847+00:00","Level":"Information","MessageTemplate":" Background Task: Refresh Session Booking Status Started {@Timestamp}","Properties":{"Timestamp":"2025-01-07T14:53:14.7183661Z"}} {"Timestamp":"2025-01-07T14:53:14.7273989+00:00","Level":"Information","MessageTemplate":" Background Task: Refresh Session Booking Status Completed {@Timestamp}","Properties":{"Timestamp":"2025-01-07T14:53:14.7273801Z"}} {"Timestamp":"2025-01-07T15:53:14.7082977+00:00","Level":"Information","MessageTemplate":" Background Task: Refresh Session Booking Status Started {@Timestamp}","Properties":{"Timestamp":"2025-01-07T15:53:14.7082806Z"}} {"Timestamp":"2025-01-07T15:53:14.7170037+00:00","Level":"Information","MessageTemplate":" Background Task: Refresh Session Booking Status Completed {@Timestamp}","Properties":{"Timestamp":"2025-01-07T15:53:14.7169862Z"}} {"Timestamp":"2025-01-07T16:53:14.7189463+00:00","Level":"Information","MessageTemplate":" Background Task: Refresh Session Booking Status Started {@Timestamp}","Properties":{"Timestamp":"2025-01-07T16:53:14.7189295Z"}} {"Timestamp":"2025-01-07T16:53:14.7272204+00:00","Level":"Information","MessageTemplate":" Background Task: Refresh Session Booking Status Completed {@Timestamp}","Properties":{"Timestamp":"2025-01-07T16:53:14.7272010Z"}} {"Timestamp":"2025-01-07T17:53:14.7087340+00:00","Level":"Information","MessageTemplate":" Background Task: Refresh Session Booking Status Started {@Timestamp}","Properties":{"Timestamp":"2025-01-07T17:53:14.7087178Z"}} {"Timestamp":"2025-01-07T17:53:14.7173854+00:00","Level":"Information","MessageTemplate":" Background Task: Refresh Session Booking Status Completed {@Timestamp}","Properties":{"Timestamp":"2025-01-07T17:53:14.7173470Z"}} {"Timestamp":"2025-01-07T18:53:14.7170373+00:00","Level":"Information","MessageTemplate":" Background Task: Refresh Session Booking Status Started {@Timestamp}","Properties":{"Timestamp":"2025-01-07T18:53:14.7170220Z"}} {"Timestamp":"2025-01-07T18:53:14.7273186+00:00","Level":"Information","MessageTemplate":" Background Task: Refresh Session Booking Status Completed {@Timestamp}","Properties":{"Timestamp":"2025-01-07T18:53:14.7272949Z"}} {"Timestamp":"2025-01-07T19:53:14.7174399+00:00","Level":"Information","MessageTemplate":" Background Task: Refresh Session Booking Status Started {@Timestamp}","Properties":{"Timestamp":"2025-01-07T19:53:14.7174226Z"}} {"Timestamp":"2025-01-07T19:53:14.7258649+00:00","Level":"Information","MessageTemplate":" Background Task: Refresh Session Booking Status Completed {@Timestamp}","Properties":{"Timestamp":"2025-01-07T19:53:14.7258483Z"}} {"Timestamp":"2025-01-07T20:53:14.6718165+00:00","Level":"Information","MessageTemplate":" Background Task: Refresh Session Booking Status Started {@Timestamp}","Properties":{"Timestamp":"2025-01-07T20:53:14.6717982Z"}} {"Timestamp":"2025-01-07T20:53:14.6787722+00:00","Level":"Information","MessageTemplate":" Background Task: Refresh Session Booking Status Completed {@Timestamp}","Properties":{"Timestamp":"2025-01-07T20:53:14.6787518Z"}} {"Timestamp":"2025-01-07T21:53:14.7222148+00:00","Level":"Information","MessageTemplate":" Background Task: Refresh Session Booking Status Started {@Timestamp}","Properties":{"Timestamp":"2025-01-07T21:53:14.7221956Z"}} {"Timestamp":"2025-01-07T21:53:14.7311860+00:00","Level":"Information","MessageTemplate":" Background Task: Refresh Session Booking Status Completed {@Timestamp}","Properties":{"Timestamp":"2025-01-07T21:53:14.7311666Z"}} {"Timestamp":"2025-01-07T22:10:08.7189793+00:00","Level":"Information","MessageTemplate":"Email Sent Successfully :{@Reciever}, {@Subject}, {@Timestamp}","TraceId":"b7dba9fcba5ed31fc0a29b2286fc9054","SpanId":"09de191e544e7c17","Properties":{"Reciever":"yayasmine97@gmail.com","Subject":"Confirm Code","Timestamp":"2025-01-07T22:10:08.7189386Z","ActionName":"UserController.CreatePatient ","RequestPath":"/api/User/CreatePatient"}} {"Timestamp":"2025-01-07T22:10:08.9384464+00:00","Level":"Information","MessageTemplate":"New Patient Added To DB , Confirmation Pending: {@Email} ,{@TimestampUTC} ","TraceId":"b7dba9fcba5ed31fc0a29b2286fc9054","SpanId":"09de191e544e7c17","Properties":{"Email":"yayasmine97@gmail.com","TimestampUTC":"2025-01-07T22:10:08.9384040Z","ActionName":"UserController.CreatePatient ","RequestPath":"/api/User/CreatePatient"}} {"Timestamp":"2025-01-07T22:10:39.0973162+00:00","Level":"Information","MessageTemplate":"Patient Confirmed and Active: {@Email} ,{@TimestampUTC} ","TraceId":"f43a009c1911f7ee5abc950183fb776a","SpanId":"6802b536dd072bad","Properties":{"Email":"yayasmine97@gmail.com","TimestampUTC":"2025-01-07T22:10:39.0972933Z","ActionName":"UserController.ConfirmCode ","RequestPath":"/api/User/ConfirmCode"}} {"Timestamp":"2025-01-07T22:10:39.1665763+00:00","Level":"Information","MessageTemplate":"User Signed in Successfully:{@Username}, {@Email} ,{@TimestampUTC} ","TraceId":"f43a009c1911f7ee5abc950183fb776a","SpanId":"6802b536dd072bad","Properties":{"Username":"Koky","Email":"yayasmine97@gmail.com","TimestampUTC":"2025-01-07T22:10:39.1665508Z","ActionName":"UserController.ConfirmCode ","RequestPath":"/api/User/ConfirmCode"}} {"Timestamp":"2025-01-07T22:10:39.1683720+00:00","Level":"Error","MessageTemplate":"Failed executing DbCommand ({elapsed}ms) [Parameters=[{parameters}], CommandType='{commandType}', CommandTimeout='{commandTimeout}']{newLine}{commandText}","TraceId":"f43a009c1911f7ee5abc950183fb776a","SpanId":"6802b536dd072bad","Properties":{"elapsed":"76","parameters":"@__user_Id_0='?' (Size = 255)","commandType":"Text","commandTimeout":30,"newLine":"\n","commandText":"SELECT `a`.`Id`, `a`.`ClaimType`, `a`.`ClaimValue`, `a`.`UserId`\nFROM `AspNetUserClaims` AS `a`\nWHERE `a`.`UserId` = @__user_Id_0","EventId":{"Id":20102,"Name":"Microsoft.EntityFrameworkCore.Database.Command.CommandError"},"ActionName":"UserController.ConfirmCode ","RequestPath":"/api/User/ConfirmCode"}} {"Timestamp":"2025-01-07T22:10:39.1694168+00:00","Level":"Error","MessageTemplate":"An exception occurred while iterating over the results of a query for context type '{contextType}'.{newline}{error}","TraceId":"f43a009c1911f7ee5abc950183fb776a","SpanId":"6802b536dd072bad","Exception":"System.NullReferenceException: Object reference not set to an instance of an object.\n at MySqlConnector.MySqlDataReader.ActivateResultSet(CancellationToken cancellationToken) in /_/src/MySqlConnector/MySqlDataReader.cs:line 133\n at MySqlConnector.MySqlDataReader.CreateAsync(CommandListPosition commandListPosition, ICommandPayloadCreator payloadCreator, IDictionary`2 cachedProcedures, IMySqlCommand command, CommandBehavior behavior, Activity activity, IOBehavior ioBehavior, CancellationToken cancellationToken) in /_/src/MySqlConnector/MySqlDataReader.cs:line 493\n at MySqlConnector.Core.CommandExecutor.ExecuteReaderAsync(IReadOnlyList`1 commands, ICommandPayloadCreator payloadCreator, CommandBehavior behavior, Activity activity, IOBehavior ioBehavior, CancellationToken cancellationToken) in /_/src/MySqlConnector/Core/CommandExecutor.cs:line 77\n at MySqlConnector.MySqlCommand.ExecuteReaderAsync(CommandBehavior behavior, IOBehavior ioBehavior, CancellationToken cancellationToken) in /_/src/MySqlConnector/MySqlCommand.cs:line 345\n at MySqlConnector.MySqlCommand.ExecuteDbDataReaderAsync(CommandBehavior behavior, CancellationToken cancellationToken) in /_/src/MySqlConnector/MySqlCommand.cs:line 337\n at Microsoft.EntityFrameworkCore.Storage.RelationalCommand.ExecuteReaderAsync(RelationalCommandParameterObject parameterObject, CancellationToken cancellationToken)\n at Microsoft.EntityFrameworkCore.Storage.RelationalCommand.ExecuteReaderAsync(RelationalCommandParameterObject parameterObject, CancellationToken cancellationToken)\n at Microsoft.EntityFrameworkCore.Query.Internal.SingleQueryingEnumerable`1.AsyncEnumerator.InitializeReaderAsync(AsyncEnumerator enumerator, CancellationToken cancellationToken)\n at Pomelo.EntityFrameworkCore.MySql.Storage.Internal.MySqlExecutionStrategy.ExecuteAsync[TState,TResult](TState state, Func`4 operation, Func`4 verifySucceeded, CancellationToken cancellationToken)\n at Microsoft.EntityFrameworkCore.Query.Internal.SingleQueryingEnumerable`1.AsyncEnumerator.MoveNextAsync()","Properties":{"contextType":"OnlineClinic.DAL.OC_DBContext","newline":"\n","error":"System.NullReferenceException: Object reference not set to an instance of an object.\n at MySqlConnector.MySqlDataReader.ActivateResultSet(CancellationToken cancellationToken) in /_/src/MySqlConnector/MySqlDataReader.cs:line 133\n at MySqlConnector.MySqlDataReader.CreateAsync(CommandListPosition commandListPosition, ICommandPayloadCreator payloadCreator, IDictionary`2 cachedProcedures, IMySqlCommand command, CommandBehavior behavior, Activity activity, IOBehavior ioBehavior, CancellationToken cancellationToken) in /_/src/MySqlConnector/MySqlDataReader.cs:line 493\n at MySqlConnector.Core.CommandExecutor.ExecuteReaderAsync(IReadOnlyList`1 commands, ICommandPayloadCreator payloadCreator, CommandBehavior behavior, Activity activity, IOBehavior ioBehavior, CancellationToken cancellationToken) in /_/src/MySqlConnector/Core/CommandExecutor.cs:line 77\n at MySqlConnector.MySqlCommand.ExecuteReaderAsync(CommandBehavior behavior, IOBehavior ioBehavior, CancellationToken cancellationToken) in /_/src/MySqlConnector/MySqlCommand.cs:line 345\n at MySqlConnector.MySqlCommand.ExecuteDbDataReaderAsync(CommandBehavior behavior, CancellationToken cancellationToken) in /_/src/MySqlConnector/MySqlCommand.cs:line 337\n at Microsoft.EntityFrameworkCore.Storage.RelationalCommand.ExecuteReaderAsync(RelationalCommandParameterObject parameterObject, CancellationToken cancellationToken)\n at Microsoft.EntityFrameworkCore.Storage.RelationalCommand.ExecuteReaderAsync(RelationalCommandParameterObject parameterObject, CancellationToken cancellationToken)\n at Microsoft.EntityFrameworkCore.Query.Internal.SingleQueryingEnumerable`1.AsyncEnumerator.InitializeReaderAsync(AsyncEnumerator enumerator, CancellationToken cancellationToken)\n at Pomelo.EntityFrameworkCore.MySql.Storage.Internal.MySqlExecutionStrategy.ExecuteAsync[TState,TResult](TState state, Func`4 operation, Func`4 verifySucceeded, CancellationToken cancellationToken)\n at Microsoft.EntityFrameworkCore.Query.Internal.SingleQueryingEnumerable`1.AsyncEnumerator.MoveNextAsync()","EventId":{"Id":10100,"Name":"Microsoft.EntityFrameworkCore.Query.QueryIterationFailed"},"ActionName":"UserController.ConfirmCode ","RequestPath":"/api/User/ConfirmCode"}} {"Timestamp":"2025-01-07T22:10:40.6276264+00:00","Level":"Error","MessageTemplate":"An error occurred using the connection to database '{database}' on server '{server}'.","TraceId":"31d51285c588014d39fdadb376696847","SpanId":"a689f1593aefa25e","Properties":{"database":"sokoun","server":"localhost","EventId":{"Id":20004,"Name":"Microsoft.EntityFrameworkCore.Database.Connection.ConnectionError"},"ActionName":"UserController.ConfirmCode ","RequestPath":"/api/User/ConfirmCode"}} {"Timestamp":"2025-01-07T22:10:40.6287310+00:00","Level":"Error","MessageTemplate":"An exception occurred while iterating over the results of a query for context type '{contextType}'.{newline}{error}","TraceId":"31d51285c588014d39fdadb376696847","SpanId":"a689f1593aefa25e","Exception":"MySqlConnector.MySqlProtocolException: Packet received out-of-order. Expected 1; got 2.\n at MySqlConnector.Protocol.Serialization.ProtocolUtility.g__AddContinuation|5_0(ValueTask`1 readPacketTask, BufferedByteReader bufferedByteReader, IByteHandler byteHandler, Func`1 getNextSequenceNumber, ArraySegmentHolder`1 previousPayloads, ProtocolErrorBehavior protocolErrorBehavior, IOBehavior ioBehavior) in /_/src/MySqlConnector/Protocol/Serialization/ProtocolUtility.cs:line 498\n at MySqlConnector.Core.ServerSession.ReceiveReplyAsyncAwaited(ValueTask`1 task) in /_/src/MySqlConnector/Core/ServerSession.cs:line 964\n at MySqlConnector.Core.ServerSession.TryResetConnectionAsync(ConnectionSettings cs, MySqlConnection connection, IOBehavior ioBehavior, CancellationToken cancellationToken) in /_/src/MySqlConnector/Core/ServerSession.cs:line 696\n at MySqlConnector.Core.ConnectionPool.GetSessionAsync(MySqlConnection connection, Int32 startTickCount, Activity activity, IOBehavior ioBehavior, CancellationToken cancellationToken) in /_/src/MySqlConnector/Core/ConnectionPool.cs:line 130\n at MySqlConnector.Core.ConnectionPool.GetSessionAsync(MySqlConnection connection, Int32 startTickCount, Activity activity, IOBehavior ioBehavior, CancellationToken cancellationToken) in /_/src/MySqlConnector/Core/ConnectionPool.cs:line 130\n at MySqlConnector.MySqlConnection.CreateSessionAsync(ConnectionPool pool, Int32 startTickCount, Activity activity, Nullable`1 ioBehavior, CancellationToken cancellationToken) in /_/src/MySqlConnector/MySqlConnection.cs:line 966\n at MySqlConnector.MySqlConnection.OpenAsync(Nullable`1 ioBehavior, CancellationToken cancellationToken) in /_/src/MySqlConnector/MySqlConnection.cs:line 457\n at MySqlConnector.MySqlConnection.Open() in /_/src/MySqlConnector/MySqlConnection.cs:line 382\n at Microsoft.EntityFrameworkCore.Storage.RelationalConnection.OpenInternal(Boolean errorsExpected)\n at Microsoft.EntityFrameworkCore.Storage.RelationalConnection.Open(Boolean errorsExpected)\n at Pomelo.EntityFrameworkCore.MySql.Storage.Internal.MySqlRelationalConnection.Open(Boolean errorsExpected)\n at Microsoft.EntityFrameworkCore.Storage.RelationalCommand.ExecuteReader(RelationalCommandParameterObject parameterObject)\n at Microsoft.EntityFrameworkCore.Query.Internal.SingleQueryingEnumerable`1.Enumerator.InitializeReader(Enumerator enumerator)\n at Pomelo.EntityFrameworkCore.MySql.Storage.Internal.MySqlExecutionStrategy.Execute[TState,TResult](TState state, Func`3 operation, Func`3 verifySucceeded)\n at Microsoft.EntityFrameworkCore.Query.Internal.SingleQueryingEnumerable`1.Enumerator.MoveNext()","Properties":{"contextType":"OnlineClinic.DAL.OC_DBContext","newline":"\n","error":"MySqlConnector.MySqlProtocolException: Packet received out-of-order. Expected 1; got 2.\n at MySqlConnector.Protocol.Serialization.ProtocolUtility.g__AddContinuation|5_0(ValueTask`1 readPacketTask, BufferedByteReader bufferedByteReader, IByteHandler byteHandler, Func`1 getNextSequenceNumber, ArraySegmentHolder`1 previousPayloads, ProtocolErrorBehavior protocolErrorBehavior, IOBehavior ioBehavior) in /_/src/MySqlConnector/Protocol/Serialization/ProtocolUtility.cs:line 498\n at MySqlConnector.Core.ServerSession.ReceiveReplyAsyncAwaited(ValueTask`1 task) in /_/src/MySqlConnector/Core/ServerSession.cs:line 964\n at MySqlConnector.Core.ServerSession.TryResetConnectionAsync(ConnectionSettings cs, MySqlConnection connection, IOBehavior ioBehavior, CancellationToken cancellationToken) in /_/src/MySqlConnector/Core/ServerSession.cs:line 696\n at MySqlConnector.Core.ConnectionPool.GetSessionAsync(MySqlConnection connection, Int32 startTickCount, Activity activity, IOBehavior ioBehavior, CancellationToken cancellationToken) in /_/src/MySqlConnector/Core/ConnectionPool.cs:line 130\n at MySqlConnector.Core.ConnectionPool.GetSessionAsync(MySqlConnection connection, Int32 startTickCount, Activity activity, IOBehavior ioBehavior, CancellationToken cancellationToken) in /_/src/MySqlConnector/Core/ConnectionPool.cs:line 130\n at MySqlConnector.MySqlConnection.CreateSessionAsync(ConnectionPool pool, Int32 startTickCount, Activity activity, Nullable`1 ioBehavior, CancellationToken cancellationToken) in /_/src/MySqlConnector/MySqlConnection.cs:line 966\n at MySqlConnector.MySqlConnection.OpenAsync(Nullable`1 ioBehavior, CancellationToken cancellationToken) in /_/src/MySqlConnector/MySqlConnection.cs:line 457\n at MySqlConnector.MySqlConnection.Open() in /_/src/MySqlConnector/MySqlConnection.cs:line 382\n at Microsoft.EntityFrameworkCore.Storage.RelationalConnection.OpenInternal(Boolean errorsExpected)\n at Microsoft.EntityFrameworkCore.Storage.RelationalConnection.Open(Boolean errorsExpected)\n at Pomelo.EntityFrameworkCore.MySql.Storage.Internal.MySqlRelationalConnection.Open(Boolean errorsExpected)\n at Microsoft.EntityFrameworkCore.Storage.RelationalCommand.ExecuteReader(RelationalCommandParameterObject parameterObject)\n at Microsoft.EntityFrameworkCore.Query.Internal.SingleQueryingEnumerable`1.Enumerator.InitializeReader(Enumerator enumerator)\n at Pomelo.EntityFrameworkCore.MySql.Storage.Internal.MySqlExecutionStrategy.Execute[TState,TResult](TState state, Func`3 operation, Func`3 verifySucceeded)\n at Microsoft.EntityFrameworkCore.Query.Internal.SingleQueryingEnumerable`1.Enumerator.MoveNext()","EventId":{"Id":10100,"Name":"Microsoft.EntityFrameworkCore.Query.QueryIterationFailed"},"ActionName":"UserController.ConfirmCode ","RequestPath":"/api/User/ConfirmCode"}} {"Timestamp":"2025-01-07T22:53:14.7052119+00:00","Level":"Information","MessageTemplate":" Background Task: Refresh Session Booking Status Started {@Timestamp}","Properties":{"Timestamp":"2025-01-07T22:53:14.7051950Z"}} {"Timestamp":"2025-01-07T22:53:14.7135775+00:00","Level":"Information","MessageTemplate":" Background Task: Refresh Session Booking Status Completed {@Timestamp}","Properties":{"Timestamp":"2025-01-07T22:53:14.7135605Z"}} {"Timestamp":"2025-01-07T23:53:14.7094107+00:00","Level":"Information","MessageTemplate":" Background Task: Refresh Session Booking Status Started {@Timestamp}","Properties":{"Timestamp":"2025-01-07T23:53:14.7093954Z"}} {"Timestamp":"2025-01-07T23:53:14.7187800+00:00","Level":"Information","MessageTemplate":" Background Task: Refresh Session Booking Status Completed {@Timestamp}","Properties":{"Timestamp":"2025-01-07T23:53:14.7187607Z"}}