{ "timestamp": "2026-01-09 07:27:46.9795", "level": "Error", "severity": "ERROR", "message": "Unknown column 'pi.return_period_years' in 'field list'", "stackTrace": "MySql.Data.MySqlClient.MySqlException (0x80004005): Unknown column 'pi.return_period_years' in 'field list'\r\n   at MySql.Data.MySqlClient.MySqlStream.ReadPacket()\r\n   at MySql.Data.MySqlClient.NativeDriver.GetResult(Int32& affectedRow, Int64& insertedId)\r\n   at MySql.Data.MySqlClient.Driver.NextResult(Int32 statementId, Boolean force)\r\n   at MySql.Data.MySqlClient.MySqlDataReader.NextResult()\r\n   at MySql.Data.MySqlClient.MySqlCommand.ExecuteReader(CommandBehavior behavior)\r\n   at Dapper.SqlMapper.ExecuteReaderWithFlagsFallback(IDbCommand cmd, Boolean wasClosed, CommandBehavior behavior)\r\n   at Dapper.SqlMapper.<QueryImpl>d__138`1.MoveNext()\r\n   at System.Collections.Generic.List`1..ctor(IEnumerable`1 collection)\r\n   at System.Linq.Enumerable.ToList[TSource](IEnumerable`1 source)\r\n   at Dapper.SqlMapper.Query[T](IDbConnection cnn, String sql, Object param, IDbTransaction transaction, Boolean buffered, Nullable`1 commandTimeout, Nullable`1 commandType)\r\n   at IncidentReporter.DAL.Repositories.PPERepo.<GetAllPPEItems>d__7.MoveNext() in C:\\lakhanWork\\OQSHA\\incident-reporter-api\\IncidentReporter\\IncidentReporter.DAL\\Repositories\\PPERepo.cs:line 325\r\n--- End of stack trace from previous location where exception was thrown ---\r\n   at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()\r\n   at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)\r\n   at System.Runtime.CompilerServices.TaskAwaiter`1.GetResult()\r\n   at IncidentReporter.API.BLL.PPEBLL.<GetAllPPEItems>d__8.MoveNext() in C:\\lakhanWork\\OQSHA\\incident-reporter-api\\IncidentReporter\\IncidentReporter.API\\BLL\\PPEBLL.cs:line 186" }
{ "timestamp": "2026-01-09 07:27:47.0215", "level": "Error", "severity": "ERROR" }
{ "timestamp": "2026-01-09 07:27:49.4681", "level": "Error", "severity": "ERROR", "message": "Unknown column 'pi.return_period_years' in 'field list'", "stackTrace": "MySql.Data.MySqlClient.MySqlException (0x80004005): Unknown column 'pi.return_period_years' in 'field list'\r\n   at MySql.Data.MySqlClient.MySqlStream.ReadPacket()\r\n   at MySql.Data.MySqlClient.NativeDriver.GetResult(Int32& affectedRow, Int64& insertedId)\r\n   at MySql.Data.MySqlClient.Driver.NextResult(Int32 statementId, Boolean force)\r\n   at MySql.Data.MySqlClient.MySqlDataReader.NextResult()\r\n   at MySql.Data.MySqlClient.MySqlCommand.ExecuteReader(CommandBehavior behavior)\r\n   at Dapper.SqlMapper.ExecuteReaderWithFlagsFallback(IDbCommand cmd, Boolean wasClosed, CommandBehavior behavior)\r\n   at Dapper.SqlMapper.<QueryImpl>d__138`1.MoveNext()\r\n   at System.Collections.Generic.List`1..ctor(IEnumerable`1 collection)\r\n   at System.Linq.Enumerable.ToList[TSource](IEnumerable`1 source)\r\n   at Dapper.SqlMapper.Query[T](IDbConnection cnn, String sql, Object param, IDbTransaction transaction, Boolean buffered, Nullable`1 commandTimeout, Nullable`1 commandType)\r\n   at IncidentReporter.DAL.Repositories.PPERepo.<GetAllPPEItems>d__7.MoveNext() in C:\\lakhanWork\\OQSHA\\incident-reporter-api\\IncidentReporter\\IncidentReporter.DAL\\Repositories\\PPERepo.cs:line 325\r\n--- End of stack trace from previous location where exception was thrown ---\r\n   at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()\r\n   at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)\r\n   at System.Runtime.CompilerServices.TaskAwaiter`1.GetResult()\r\n   at IncidentReporter.API.BLL.PPEBLL.<GetAllPPEItems>d__8.MoveNext() in C:\\lakhanWork\\OQSHA\\incident-reporter-api\\IncidentReporter\\IncidentReporter.API\\BLL\\PPEBLL.cs:line 186" }
{ "timestamp": "2026-01-09 07:27:49.4681", "level": "Error", "severity": "ERROR" }
{ "timestamp": "2026-01-09 07:28:07.4457", "level": "Error", "severity": "ERROR", "message": "Unknown column 'pi.return_period_years' in 'field list'", "stackTrace": "MySql.Data.MySqlClient.MySqlException (0x80004005): Unknown column 'pi.return_period_years' in 'field list'\r\n   at MySql.Data.MySqlClient.MySqlStream.ReadPacket()\r\n   at MySql.Data.MySqlClient.NativeDriver.GetResult(Int32& affectedRow, Int64& insertedId)\r\n   at MySql.Data.MySqlClient.Driver.NextResult(Int32 statementId, Boolean force)\r\n   at MySql.Data.MySqlClient.MySqlDataReader.NextResult()\r\n   at MySql.Data.MySqlClient.MySqlCommand.ExecuteReader(CommandBehavior behavior)\r\n   at System.Data.Common.DbCommand.ExecuteDbDataReaderAsync(CommandBehavior behavior, CancellationToken cancellationToken)\r\n--- End of stack trace from previous location where exception was thrown ---\r\n   at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()\r\n   at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)\r\n   at Dapper.SqlMapper.<QueryMultipleAsync>d__57.MoveNext()\r\n--- End of stack trace from previous location where exception was thrown ---\r\n   at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()\r\n   at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)\r\n   at System.Runtime.CompilerServices.TaskAwaiter`1.GetResult()\r\n   at IncidentReporter.DAL.Repositories.PPERepo.<GetAllPPEItems>d__7.MoveNext() in C:\\lakhanWork\\OQSHA\\incident-reporter-api\\IncidentReporter\\IncidentReporter.DAL\\Repositories\\PPERepo.cs:line 318\r\n--- End of stack trace from previous location where exception was thrown ---\r\n   at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()\r\n   at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)\r\n   at System.Runtime.CompilerServices.TaskAwaiter`1.GetResult()\r\n   at IncidentReporter.API.BLL.PPEBLL.<GetAllPPEItems>d__8.MoveNext() in C:\\lakhanWork\\OQSHA\\incident-reporter-api\\IncidentReporter\\IncidentReporter.API\\BLL\\PPEBLL.cs:line 186" }
{ "timestamp": "2026-01-09 07:28:07.4527", "level": "Error", "severity": "ERROR" }
{ "timestamp": "2026-01-09 07:34:48.7120", "level": "Error", "severity": "ERROR", "message": "Unknown column 'pi.return_period_years' in 'field list'", "stackTrace": "MySql.Data.MySqlClient.MySqlException (0x80004005): Unknown column 'pi.return_period_years' in 'field list'\r\n   at MySql.Data.MySqlClient.MySqlStream.ReadPacket()\r\n   at MySql.Data.MySqlClient.NativeDriver.GetResult(Int32& affectedRow, Int64& insertedId)\r\n   at MySql.Data.MySqlClient.Driver.NextResult(Int32 statementId, Boolean force)\r\n   at MySql.Data.MySqlClient.MySqlDataReader.NextResult()\r\n   at MySql.Data.MySqlClient.MySqlCommand.ExecuteReader(CommandBehavior behavior)\r\n   at System.Data.Common.DbCommand.ExecuteDbDataReaderAsync(CommandBehavior behavior, CancellationToken cancellationToken)\r\n--- End of stack trace from previous location where exception was thrown ---\r\n   at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()\r\n   at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)\r\n   at Dapper.SqlMapper.<QueryMultipleAsync>d__57.MoveNext()\r\n--- End of stack trace from previous location where exception was thrown ---\r\n   at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()\r\n   at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)\r\n   at System.Runtime.CompilerServices.TaskAwaiter`1.GetResult()\r\n   at IncidentReporter.DAL.Repositories.PPERepo.<GetAllPPEItems>d__7.MoveNext() in C:\\lakhanWork\\OQSHA\\incident-reporter-api\\IncidentReporter\\IncidentReporter.DAL\\Repositories\\PPERepo.cs:line 318\r\n--- End of stack trace from previous location where exception was thrown ---\r\n   at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()\r\n   at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)\r\n   at System.Runtime.CompilerServices.TaskAwaiter`1.GetResult()\r\n   at IncidentReporter.API.BLL.PPEBLL.<GetAllPPEItems>d__8.MoveNext() in C:\\lakhanWork\\OQSHA\\incident-reporter-api\\IncidentReporter\\IncidentReporter.API\\BLL\\PPEBLL.cs:line 186" }
{ "timestamp": "2026-01-09 07:34:48.7318", "level": "Error", "severity": "ERROR" }
{ "timestamp": "2026-01-09 07:36:13.8179", "level": "Error", "severity": "ERROR", "message": "Unknown column 'pi.return_period_years' in 'field list'", "stackTrace": "MySql.Data.MySqlClient.MySqlException (0x80004005): Unknown column 'pi.return_period_years' in 'field list'\r\n   at MySql.Data.MySqlClient.MySqlStream.ReadPacket()\r\n   at MySql.Data.MySqlClient.NativeDriver.GetResult(Int32& affectedRow, Int64& insertedId)\r\n   at MySql.Data.MySqlClient.Driver.NextResult(Int32 statementId, Boolean force)\r\n   at MySql.Data.MySqlClient.MySqlDataReader.NextResult()\r\n   at MySql.Data.MySqlClient.MySqlCommand.ExecuteReader(CommandBehavior behavior)\r\n   at System.Data.Common.DbCommand.ExecuteDbDataReaderAsync(CommandBehavior behavior, CancellationToken cancellationToken)\r\n--- End of stack trace from previous location where exception was thrown ---\r\n   at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()\r\n   at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)\r\n   at Dapper.SqlMapper.<QueryMultipleAsync>d__57.MoveNext()\r\n--- End of stack trace from previous location where exception was thrown ---\r\n   at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()\r\n   at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)\r\n   at System.Runtime.CompilerServices.TaskAwaiter`1.GetResult()\r\n   at IncidentReporter.DAL.Repositories.PPERepo.<GetAllPPEItems>d__7.MoveNext() in C:\\lakhanWork\\OQSHA\\incident-reporter-api\\IncidentReporter\\IncidentReporter.DAL\\Repositories\\PPERepo.cs:line 318\r\n--- End of stack trace from previous location where exception was thrown ---\r\n   at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()\r\n   at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)\r\n   at System.Runtime.CompilerServices.TaskAwaiter`1.GetResult()\r\n   at IncidentReporter.API.BLL.PPEBLL.<GetAllPPEItems>d__8.MoveNext() in C:\\lakhanWork\\OQSHA\\incident-reporter-api\\IncidentReporter\\IncidentReporter.API\\BLL\\PPEBLL.cs:line 186" }
{ "timestamp": "2026-01-09 07:36:13.8185", "level": "Error", "severity": "ERROR" }
{ "timestamp": "2026-01-09 07:44:06.7632", "level": "Error", "severity": "ERROR", "message": "Unknown column 'pi.return_period_years' in 'field list'", "stackTrace": "MySql.Data.MySqlClient.MySqlException (0x80004005): Unknown column 'pi.return_period_years' in 'field list'\r\n   at MySql.Data.MySqlClient.MySqlStream.ReadPacket()\r\n   at MySql.Data.MySqlClient.NativeDriver.GetResult(Int32& affectedRow, Int64& insertedId)\r\n   at MySql.Data.MySqlClient.Driver.NextResult(Int32 statementId, Boolean force)\r\n   at MySql.Data.MySqlClient.MySqlDataReader.NextResult()\r\n   at MySql.Data.MySqlClient.MySqlCommand.ExecuteReader(CommandBehavior behavior)\r\n   at System.Data.Common.DbCommand.ExecuteDbDataReaderAsync(CommandBehavior behavior, CancellationToken cancellationToken)\r\n--- End of stack trace from previous location where exception was thrown ---\r\n   at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()\r\n   at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)\r\n   at Dapper.SqlMapper.<QueryMultipleAsync>d__57.MoveNext()\r\n--- End of stack trace from previous location where exception was thrown ---\r\n   at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()\r\n   at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)\r\n   at System.Runtime.CompilerServices.TaskAwaiter`1.GetResult()\r\n   at IncidentReporter.DAL.Repositories.PPERepo.<GetAllPPEItems>d__7.MoveNext() in C:\\lakhanWork\\OQSHA\\incident-reporter-api\\IncidentReporter\\IncidentReporter.DAL\\Repositories\\PPERepo.cs:line 318\r\n--- End of stack trace from previous location where exception was thrown ---\r\n   at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()\r\n   at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)\r\n   at System.Runtime.CompilerServices.TaskAwaiter`1.GetResult()\r\n   at IncidentReporter.API.BLL.PPEBLL.<GetAllPPEItems>d__8.MoveNext() in C:\\lakhanWork\\OQSHA\\incident-reporter-api\\IncidentReporter\\IncidentReporter.API\\BLL\\PPEBLL.cs:line 186" }
{ "timestamp": "2026-01-09 07:44:06.7843", "level": "Error", "severity": "ERROR" }
{ "timestamp": "2026-01-09 10:17:59.5654", "level": "Error", "severity": "ERROR", "message": "The operation was canceled.", "stackTrace": "System.OperationCanceledException: The operation was canceled.\r\n   at System.Threading.CancellationToken.ThrowOperationCanceledException()\r\n   at System.Web.Http.Filters.ActionFilterAttribute.<CallOnActionExecutedAsync>d__5.MoveNext()\r\n--- End of stack trace from previous location where exception was thrown ---\r\n   at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()\r\n   at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task)\r\n   at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)\r\n   at System.Web.Http.Filters.ActionFilterAttribute.<ExecuteActionFilterAsyncCore>d__0.MoveNext()\r\n--- End of stack trace from previous location where exception was thrown ---\r\n   at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()\r\n   at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task)\r\n   at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)\r\n   at System.Web.Http.Controllers.ActionFilterResult.<ExecuteAsync>d__2.MoveNext()\r\n--- End of stack trace from previous location where exception was thrown ---\r\n   at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()\r\n   at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task)\r\n   at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)\r\n   at System.Web.Http.Controllers.ExceptionFilterResult.<ExecuteAsync>d__0.MoveNext()" }
{ "timestamp": "2026-01-09 16:35:12.7791", "level": "Error", "severity": "ERROR", "message": "Value cannot be null.\r\nParameter name: Invalid request: Missing parameters.", "stackTrace": "System.ArgumentNullException: Value cannot be null.\r\nParameter name: Invalid request: Missing parameters.\r\n   at IncidentReporter.API.BLL.WhatsAppBll.HandleIncomingMessage(NameValueCollection formData) in D:\\osmosys\\oqsha\\incident-reporter-api\\IncidentReporter\\IncidentReporter.API\\BLL\\WhatsAppBll.cs:line 108" }
{ "timestamp": "2026-01-09 16:35:12.8728", "level": "Error", "severity": "ERROR" }
{ "timestamp": "2026-01-09 16:35:20.5197", "level": "Error", "severity": "ERROR", "message": "Value cannot be null.\r\nParameter name: Invalid request: Missing parameters.", "stackTrace": "System.ArgumentNullException: Value cannot be null.\r\nParameter name: Invalid request: Missing parameters.\r\n   at IncidentReporter.API.BLL.WhatsAppBll.HandleIncomingMessage(NameValueCollection formData) in D:\\osmosys\\oqsha\\incident-reporter-api\\IncidentReporter\\IncidentReporter.API\\BLL\\WhatsAppBll.cs:line 108" }
{ "timestamp": "2026-01-09 16:35:20.5197", "level": "Error", "severity": "ERROR" }