{ "timestamp": "2026-01-06 06:18:43.5595", "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 D:\\osmosys\\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 IncidentReporter.API.BLL.PPEBLL.<GetAllPPEItems>d__8.MoveNext() in D:\\osmosys\\oqsha\\incident-reporter-api\\IncidentReporter\\IncidentReporter.API\\BLL\\PPEBLL.cs:line 185" }
{ "timestamp": "2026-01-06 06:18:43.7996", "level": "Error", "severity": "ERROR" }
{ "timestamp": "2026-01-06 06:19:25.9536", "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 D:\\osmosys\\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 IncidentReporter.API.BLL.PPEBLL.<GetAllPPEItems>d__8.MoveNext() in D:\\osmosys\\oqsha\\incident-reporter-api\\IncidentReporter\\IncidentReporter.API\\BLL\\PPEBLL.cs:line 185" }
{ "timestamp": "2026-01-06 06:19:25.9610", "level": "Error", "severity": "ERROR" }
{ "timestamp": "2026-01-06 06:23:38.6447", "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 D:\\osmosys\\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 IncidentReporter.API.BLL.PPEBLL.<GetAllPPEItems>d__8.MoveNext() in D:\\osmosys\\oqsha\\incident-reporter-api\\IncidentReporter\\IncidentReporter.API\\BLL\\PPEBLL.cs:line 185" }
{ "timestamp": "2026-01-06 06:23:38.6655", "level": "Error", "severity": "ERROR" }
{ "timestamp": "2026-01-06 06:23:42.1984", "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 D:\\osmosys\\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 IncidentReporter.API.BLL.PPEBLL.<GetAllPPEItems>d__8.MoveNext() in D:\\osmosys\\oqsha\\incident-reporter-api\\IncidentReporter\\IncidentReporter.API\\BLL\\PPEBLL.cs:line 185" }
{ "timestamp": "2026-01-06 06:23:42.2044", "level": "Error", "severity": "ERROR" }
{ "timestamp": "2026-01-06 06:24:19.9040", "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 D:\\osmosys\\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 IncidentReporter.API.BLL.PPEBLL.<GetAllPPEItems>d__8.MoveNext() in D:\\osmosys\\oqsha\\incident-reporter-api\\IncidentReporter\\IncidentReporter.API\\BLL\\PPEBLL.cs:line 185" }
{ "timestamp": "2026-01-06 06:24:19.9040", "level": "Error", "severity": "ERROR" }
{ "timestamp": "2026-01-06 06:24:33.2478", "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 IncidentReporter.DAL.Repositories.PPERepo.<GetAllPPEItems>d__7.MoveNext() in D:\\osmosys\\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 IncidentReporter.API.BLL.PPEBLL.<GetAllPPEItems>d__8.MoveNext() in D:\\osmosys\\oqsha\\incident-reporter-api\\IncidentReporter\\IncidentReporter.API\\BLL\\PPEBLL.cs:line 185" }
{ "timestamp": "2026-01-06 06:24:33.2478", "level": "Error", "severity": "ERROR" }
{ "timestamp": "2026-01-06 06:24:36.9087", "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 IncidentReporter.DAL.Repositories.PPERepo.<GetAllPPEItems>d__7.MoveNext() in D:\\osmosys\\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 IncidentReporter.API.BLL.PPEBLL.<GetAllPPEItems>d__8.MoveNext() in D:\\osmosys\\oqsha\\incident-reporter-api\\IncidentReporter\\IncidentReporter.API\\BLL\\PPEBLL.cs:line 185" }
{ "timestamp": "2026-01-06 06:24:36.9087", "level": "Error", "severity": "ERROR" }
{ "timestamp": "2026-01-06 06:24:53.3627", "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 D:\\osmosys\\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 IncidentReporter.API.BLL.PPEBLL.<GetAllPPEItems>d__8.MoveNext() in D:\\osmosys\\oqsha\\incident-reporter-api\\IncidentReporter\\IncidentReporter.API\\BLL\\PPEBLL.cs:line 185" }
{ "timestamp": "2026-01-06 06:24:53.3627", "level": "Error", "severity": "ERROR" }
{ "timestamp": "2026-01-06 06:25:11.7110", "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 IncidentReporter.DAL.Repositories.PPERepo.<GetAllPPEItems>d__7.MoveNext() in D:\\osmosys\\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 IncidentReporter.API.BLL.PPEBLL.<GetAllPPEItems>d__8.MoveNext() in D:\\osmosys\\oqsha\\incident-reporter-api\\IncidentReporter\\IncidentReporter.API\\BLL\\PPEBLL.cs:line 185" }
{ "timestamp": "2026-01-06 06:25:11.7177", "level": "Error", "severity": "ERROR" }
{ "timestamp": "2026-01-06 06:34:03.2683", "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 D:\\osmosys\\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 IncidentReporter.API.BLL.PPEBLL.<GetAllPPEItems>d__8.MoveNext() in D:\\osmosys\\oqsha\\incident-reporter-api\\IncidentReporter\\IncidentReporter.API\\BLL\\PPEBLL.cs:line 185" }
{ "timestamp": "2026-01-06 06:34:03.2843", "level": "Error", "severity": "ERROR", "message": "Unknown column 'ii.ppe_due_date' in 'field list'", "stackTrace": "MySql.Data.MySqlClient.MySqlException (0x80004005): Unknown column 'ii.ppe_due_date' 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.GetPpeIssuedItemsByPpeIssuanceId(Int32 ppeIssuanceId) in D:\\osmosys\\oqsha\\incident-reporter-api\\IncidentReporter\\IncidentReporter.DAL\\Repositories\\PPERepo.cs:line 1719\r\n   at IncidentReporter.API.BLL.PPEBLL.<GetPPEIssueById>d__12.MoveNext() in D:\\osmosys\\oqsha\\incident-reporter-api\\IncidentReporter\\IncidentReporter.API\\BLL\\PPEBLL.cs:line 577" }
{ "timestamp": "2026-01-06 06:34:03.2843", "level": "Error", "severity": "ERROR" }
{ "timestamp": "2026-01-06 06:34:03.2843", "level": "Error", "severity": "ERROR" }
{ "timestamp": "2026-01-06 06:34:35.9829", "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 D:\\osmosys\\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 IncidentReporter.API.BLL.PPEBLL.<GetAllPPEItems>d__8.MoveNext() in D:\\osmosys\\oqsha\\incident-reporter-api\\IncidentReporter\\IncidentReporter.API\\BLL\\PPEBLL.cs:line 185" }
{ "timestamp": "2026-01-06 06:34:35.9878", "level": "Error", "severity": "ERROR", "message": "Unknown column 'ii.ppe_due_date' in 'field list'", "stackTrace": "MySql.Data.MySqlClient.MySqlException (0x80004005): Unknown column 'ii.ppe_due_date' 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.GetPpeIssuedItemsByPpeIssuanceId(Int32 ppeIssuanceId) in D:\\osmosys\\oqsha\\incident-reporter-api\\IncidentReporter\\IncidentReporter.DAL\\Repositories\\PPERepo.cs:line 1719\r\n   at IncidentReporter.API.BLL.PPEBLL.<GetPPEIssueById>d__12.MoveNext() in D:\\osmosys\\oqsha\\incident-reporter-api\\IncidentReporter\\IncidentReporter.API\\BLL\\PPEBLL.cs:line 577" }
{ "timestamp": "2026-01-06 06:34:35.9878", "level": "Error", "severity": "ERROR" }
{ "timestamp": "2026-01-06 06:34:35.9878", "level": "Error", "severity": "ERROR" }
{ "timestamp": "2026-01-06 06:34:44.4156", "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 D:\\osmosys\\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 IncidentReporter.API.BLL.PPEBLL.<GetAllPPEItems>d__8.MoveNext() in D:\\osmosys\\oqsha\\incident-reporter-api\\IncidentReporter\\IncidentReporter.API\\BLL\\PPEBLL.cs:line 185" }
{ "timestamp": "2026-01-06 06:34:44.4156", "level": "Error", "severity": "ERROR", "message": "Unknown column 'ii.ppe_due_date' in 'field list'", "stackTrace": "MySql.Data.MySqlClient.MySqlException (0x80004005): Unknown column 'ii.ppe_due_date' 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.GetPpeIssuedItemsByPpeIssuanceId(Int32 ppeIssuanceId) in D:\\osmosys\\oqsha\\incident-reporter-api\\IncidentReporter\\IncidentReporter.DAL\\Repositories\\PPERepo.cs:line 1719\r\n   at IncidentReporter.API.BLL.PPEBLL.<GetPPEIssueById>d__12.MoveNext() in D:\\osmosys\\oqsha\\incident-reporter-api\\IncidentReporter\\IncidentReporter.API\\BLL\\PPEBLL.cs:line 577" }
{ "timestamp": "2026-01-06 06:34:44.4156", "level": "Error", "severity": "ERROR" }
{ "timestamp": "2026-01-06 06:34:44.4288", "level": "Error", "severity": "ERROR" }
{ "timestamp": "2026-01-06 06:35:03.3502", "level": "Error", "severity": "ERROR", "message": "Unknown column 'ii.ppe_due_date' in 'field list'", "stackTrace": "MySql.Data.MySqlClient.MySqlException (0x80004005): Unknown column 'ii.ppe_due_date' 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.GetPpeIssuedItemsByPpeIssuanceId(Int32 ppeIssuanceId) in D:\\osmosys\\oqsha\\incident-reporter-api\\IncidentReporter\\IncidentReporter.DAL\\Repositories\\PPERepo.cs:line 1719\r\n   at IncidentReporter.API.BLL.PPEBLL.<GetPPEIssueById>d__12.MoveNext() in D:\\osmosys\\oqsha\\incident-reporter-api\\IncidentReporter\\IncidentReporter.API\\BLL\\PPEBLL.cs:line 577" }
{ "timestamp": "2026-01-06 06:35:03.3502", "level": "Error", "severity": "ERROR" }
{ "timestamp": "2026-01-06 06:35:03.4396", "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 D:\\osmosys\\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 IncidentReporter.API.BLL.PPEBLL.<GetAllPPEItems>d__8.MoveNext() in D:\\osmosys\\oqsha\\incident-reporter-api\\IncidentReporter\\IncidentReporter.API\\BLL\\PPEBLL.cs:line 185" }
{ "timestamp": "2026-01-06 06:35:03.4396", "level": "Error", "severity": "ERROR" }
{ "timestamp": "2026-01-06 06:42:23.2340", "level": "Error", "severity": "ERROR", "message": "Unknown column 'ii.ppe_due_date' in 'field list'", "stackTrace": "MySql.Data.MySqlClient.MySqlException (0x80004005): Unknown column 'ii.ppe_due_date' 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.GetPpeIssuedItemsByPpeIssuanceId(Int32 ppeIssuanceId) in D:\\osmosys\\oqsha\\incident-reporter-api\\IncidentReporter\\IncidentReporter.DAL\\Repositories\\PPERepo.cs:line 1719\r\n   at IncidentReporter.API.BLL.PPEBLL.<GetPPEIssueById>d__12.MoveNext() in D:\\osmosys\\oqsha\\incident-reporter-api\\IncidentReporter\\IncidentReporter.API\\BLL\\PPEBLL.cs:line 577" }
{ "timestamp": "2026-01-06 06:42:23.2511", "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 D:\\osmosys\\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 IncidentReporter.API.BLL.PPEBLL.<GetAllPPEItems>d__8.MoveNext() in D:\\osmosys\\oqsha\\incident-reporter-api\\IncidentReporter\\IncidentReporter.API\\BLL\\PPEBLL.cs:line 185" }
{ "timestamp": "2026-01-06 06:42:23.2511", "level": "Error", "severity": "ERROR" }
{ "timestamp": "2026-01-06 06:42:23.2591", "level": "Error", "severity": "ERROR" }
{ "timestamp": "2026-01-06 06:43:49.6222", "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 D:\\osmosys\\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 IncidentReporter.API.BLL.PPEBLL.<GetAllPPEItems>d__8.MoveNext() in D:\\osmosys\\oqsha\\incident-reporter-api\\IncidentReporter\\IncidentReporter.API\\BLL\\PPEBLL.cs:line 185" }
{ "timestamp": "2026-01-06 06:43:49.6222", "level": "Error", "severity": "ERROR", "message": "Unknown column 'ii.ppe_due_date' in 'field list'", "stackTrace": "MySql.Data.MySqlClient.MySqlException (0x80004005): Unknown column 'ii.ppe_due_date' 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.GetPpeIssuedItemsByPpeIssuanceId(Int32 ppeIssuanceId) in D:\\osmosys\\oqsha\\incident-reporter-api\\IncidentReporter\\IncidentReporter.DAL\\Repositories\\PPERepo.cs:line 1719\r\n   at IncidentReporter.API.BLL.PPEBLL.<GetPPEIssueById>d__12.MoveNext() in D:\\osmosys\\oqsha\\incident-reporter-api\\IncidentReporter\\IncidentReporter.API\\BLL\\PPEBLL.cs:line 577" }
{ "timestamp": "2026-01-06 06:43:49.6222", "level": "Error", "severity": "ERROR" }
{ "timestamp": "2026-01-06 06:43:49.6344", "level": "Error", "severity": "ERROR" }
{ "timestamp": "2026-01-06 06:44:08.0686", "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 D:\\osmosys\\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 IncidentReporter.API.BLL.PPEBLL.<GetAllPPEItems>d__8.MoveNext() in D:\\osmosys\\oqsha\\incident-reporter-api\\IncidentReporter\\IncidentReporter.API\\BLL\\PPEBLL.cs:line 185" }
{ "timestamp": "2026-01-06 06:44:08.0766", "level": "Error", "severity": "ERROR" }
{ "timestamp": "2026-01-06 06:44:08.0766", "level": "Error", "severity": "ERROR", "message": "Unknown column 'ii.ppe_due_date' in 'field list'", "stackTrace": "MySql.Data.MySqlClient.MySqlException (0x80004005): Unknown column 'ii.ppe_due_date' 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.GetPpeIssuedItemsByPpeIssuanceId(Int32 ppeIssuanceId) in D:\\osmosys\\oqsha\\incident-reporter-api\\IncidentReporter\\IncidentReporter.DAL\\Repositories\\PPERepo.cs:line 1719\r\n   at IncidentReporter.API.BLL.PPEBLL.<GetPPEIssueById>d__12.MoveNext() in D:\\osmosys\\oqsha\\incident-reporter-api\\IncidentReporter\\IncidentReporter.API\\BLL\\PPEBLL.cs:line 577" }
{ "timestamp": "2026-01-06 06:44:08.0766", "level": "Error", "severity": "ERROR" }
{ "timestamp": "2026-01-06 06:44:15.0467", "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 D:\\osmosys\\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 IncidentReporter.API.BLL.PPEBLL.<GetAllPPEItems>d__8.MoveNext() in D:\\osmosys\\oqsha\\incident-reporter-api\\IncidentReporter\\IncidentReporter.API\\BLL\\PPEBLL.cs:line 185" }
{ "timestamp": "2026-01-06 06:44:15.0467", "level": "Error", "severity": "ERROR", "message": "Unknown column 'ii.ppe_due_date' in 'field list'", "stackTrace": "MySql.Data.MySqlClient.MySqlException (0x80004005): Unknown column 'ii.ppe_due_date' 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.GetPpeIssuedItemsByPpeIssuanceId(Int32 ppeIssuanceId) in D:\\osmosys\\oqsha\\incident-reporter-api\\IncidentReporter\\IncidentReporter.DAL\\Repositories\\PPERepo.cs:line 1719\r\n   at IncidentReporter.API.BLL.PPEBLL.<GetPPEIssueById>d__12.MoveNext() in D:\\osmosys\\oqsha\\incident-reporter-api\\IncidentReporter\\IncidentReporter.API\\BLL\\PPEBLL.cs:line 577" }
{ "timestamp": "2026-01-06 06:44:15.0541", "level": "Error", "severity": "ERROR" }
{ "timestamp": "2026-01-06 06:44:15.0541", "level": "Error", "severity": "ERROR" }
{ "timestamp": "2026-01-06 06:44:26.6935", "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 D:\\osmosys\\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 IncidentReporter.API.BLL.PPEBLL.<GetAllPPEItems>d__8.MoveNext() in D:\\osmosys\\oqsha\\incident-reporter-api\\IncidentReporter\\IncidentReporter.API\\BLL\\PPEBLL.cs:line 185" }
{ "timestamp": "2026-01-06 06:44:26.6977", "level": "Error", "severity": "ERROR", "message": "Unknown column 'ii.ppe_due_date' in 'field list'", "stackTrace": "MySql.Data.MySqlClient.MySqlException (0x80004005): Unknown column 'ii.ppe_due_date' 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.GetPpeIssuedItemsByPpeIssuanceId(Int32 ppeIssuanceId) in D:\\osmosys\\oqsha\\incident-reporter-api\\IncidentReporter\\IncidentReporter.DAL\\Repositories\\PPERepo.cs:line 1719\r\n   at IncidentReporter.API.BLL.PPEBLL.<GetPPEIssueById>d__12.MoveNext() in D:\\osmosys\\oqsha\\incident-reporter-api\\IncidentReporter\\IncidentReporter.API\\BLL\\PPEBLL.cs:line 577" }
{ "timestamp": "2026-01-06 06:44:26.6977", "level": "Error", "severity": "ERROR" }
{ "timestamp": "2026-01-06 06:44:26.7210", "level": "Error", "severity": "ERROR" }
{ "timestamp": "2026-01-06 06:45:10.2460", "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 D:\\osmosys\\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 IncidentReporter.API.BLL.PPEBLL.<GetAllPPEItems>d__8.MoveNext() in D:\\osmosys\\oqsha\\incident-reporter-api\\IncidentReporter\\IncidentReporter.API\\BLL\\PPEBLL.cs:line 185" }
{ "timestamp": "2026-01-06 06:45:10.2460", "level": "Error", "severity": "ERROR", "message": "Unknown column 'ii.ppe_due_date' in 'field list'", "stackTrace": "MySql.Data.MySqlClient.MySqlException (0x80004005): Unknown column 'ii.ppe_due_date' 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.GetPpeIssuedItemsByPpeIssuanceId(Int32 ppeIssuanceId) in D:\\osmosys\\oqsha\\incident-reporter-api\\IncidentReporter\\IncidentReporter.DAL\\Repositories\\PPERepo.cs:line 1719\r\n   at IncidentReporter.API.BLL.PPEBLL.<GetPPEIssueById>d__12.MoveNext() in D:\\osmosys\\oqsha\\incident-reporter-api\\IncidentReporter\\IncidentReporter.API\\BLL\\PPEBLL.cs:line 577" }
{ "timestamp": "2026-01-06 06:45:10.2460", "level": "Error", "severity": "ERROR" }
{ "timestamp": "2026-01-06 06:45:10.2592", "level": "Error", "severity": "ERROR" }
{ "timestamp": "2026-01-06 06:55:17.0686", "level": "Error", "severity": "ERROR", "message": "Unknown column 'ii.ppe_due_date' in 'field list'", "stackTrace": "MySql.Data.MySqlClient.MySqlException (0x80004005): Unknown column 'ii.ppe_due_date' 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.GetPpeIssuedItemsByPpeIssuanceId(Int32 ppeIssuanceId) in D:\\osmosys\\oqsha\\incident-reporter-api\\IncidentReporter\\IncidentReporter.DAL\\Repositories\\PPERepo.cs:line 1719\r\n   at IncidentReporter.API.BLL.PPEBLL.<GetPPEIssueById>d__12.MoveNext() in D:\\osmosys\\oqsha\\incident-reporter-api\\IncidentReporter\\IncidentReporter.API\\BLL\\PPEBLL.cs:line 577" }
{ "timestamp": "2026-01-06 06:55:17.0758", "level": "Error", "severity": "ERROR" }
{ "timestamp": "2026-01-06 06:55:17.0758", "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 D:\\osmosys\\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 IncidentReporter.API.BLL.PPEBLL.<GetAllPPEItems>d__8.MoveNext() in D:\\osmosys\\oqsha\\incident-reporter-api\\IncidentReporter\\IncidentReporter.API\\BLL\\PPEBLL.cs:line 185" }
{ "timestamp": "2026-01-06 06:55:17.0758", "level": "Error", "severity": "ERROR" }
{ "timestamp": "2026-01-06 07:01:07.1334", "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-06 07:43:11.9766", "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.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.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-06 07:43:21.4425", "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 D:\\osmosys\\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 IncidentReporter.API.BLL.PPEBLL.<GetAllPPEItems>d__8.MoveNext() in D:\\osmosys\\oqsha\\incident-reporter-api\\IncidentReporter\\IncidentReporter.API\\BLL\\PPEBLL.cs:line 185" }
{ "timestamp": "2026-01-06 07:43:21.4425", "level": "Error", "severity": "ERROR", "message": "Unknown column 'ii.ppe_due_date' in 'field list'", "stackTrace": "MySql.Data.MySqlClient.MySqlException (0x80004005): Unknown column 'ii.ppe_due_date' 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.GetPpeIssuedItemsByPpeIssuanceId(Int32 ppeIssuanceId) in D:\\osmosys\\oqsha\\incident-reporter-api\\IncidentReporter\\IncidentReporter.DAL\\Repositories\\PPERepo.cs:line 1719\r\n   at IncidentReporter.API.BLL.PPEBLL.<GetPPEIssueById>d__12.MoveNext() in D:\\osmosys\\oqsha\\incident-reporter-api\\IncidentReporter\\IncidentReporter.API\\BLL\\PPEBLL.cs:line 577" }
{ "timestamp": "2026-01-06 07:43:21.4742", "level": "Error", "severity": "ERROR" }
{ "timestamp": "2026-01-06 07:43:21.4742", "level": "Error", "severity": "ERROR" }
{ "timestamp": "2026-01-06 07:43:40.4512", "level": "Error", "severity": "ERROR", "message": "Unknown column 'ii.ppe_due_date' in 'field list'", "stackTrace": "MySql.Data.MySqlClient.MySqlException (0x80004005): Unknown column 'ii.ppe_due_date' 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.GetPpeIssuedItemsByPpeIssuanceId(Int32 ppeIssuanceId) in D:\\osmosys\\oqsha\\incident-reporter-api\\IncidentReporter\\IncidentReporter.DAL\\Repositories\\PPERepo.cs:line 1719\r\n   at IncidentReporter.API.BLL.PPEBLL.<GetPPEIssueById>d__12.MoveNext() in D:\\osmosys\\oqsha\\incident-reporter-api\\IncidentReporter\\IncidentReporter.API\\BLL\\PPEBLL.cs:line 577" }
{ "timestamp": "2026-01-06 07:43:40.4591", "level": "Error", "severity": "ERROR" }
{ "timestamp": "2026-01-06 07:43:40.5055", "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 D:\\osmosys\\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 IncidentReporter.API.BLL.PPEBLL.<GetAllPPEItems>d__8.MoveNext() in D:\\osmosys\\oqsha\\incident-reporter-api\\IncidentReporter\\IncidentReporter.API\\BLL\\PPEBLL.cs:line 185" }
{ "timestamp": "2026-01-06 07:43:40.5055", "level": "Error", "severity": "ERROR" }
{ "timestamp": "2026-01-06 09:13:13.8535", "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 D:\\osmosys\\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 IncidentReporter.API.BLL.PPEBLL.<GetAllPPEItems>d__8.MoveNext() in D:\\osmosys\\oqsha\\incident-reporter-api\\IncidentReporter\\IncidentReporter.API\\BLL\\PPEBLL.cs:line 185" }
{ "timestamp": "2026-01-06 09:13:13.8615", "level": "Error", "severity": "ERROR", "message": "Unknown column 'ii.ppe_due_date' in 'field list'", "stackTrace": "MySql.Data.MySqlClient.MySqlException (0x80004005): Unknown column 'ii.ppe_due_date' 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.GetPpeIssuedItemsByPpeIssuanceId(Int32 ppeIssuanceId) in D:\\osmosys\\oqsha\\incident-reporter-api\\IncidentReporter\\IncidentReporter.DAL\\Repositories\\PPERepo.cs:line 1719\r\n   at IncidentReporter.API.BLL.PPEBLL.<GetPPEIssueById>d__12.MoveNext() in D:\\osmosys\\oqsha\\incident-reporter-api\\IncidentReporter\\IncidentReporter.API\\BLL\\PPEBLL.cs:line 577" }
{ "timestamp": "2026-01-06 09:13:13.8615", "level": "Error", "severity": "ERROR" }
{ "timestamp": "2026-01-06 09:13:13.8839", "level": "Error", "severity": "ERROR" }
{ "timestamp": "2026-01-06 14:31:00.9843", "level": "Error", "severity": "ERROR", "message": "A generic error occurred in GDI+.", "stackTrace": "System.Runtime.InteropServices.ExternalException (0x80004005): A generic error occurred in GDI+.\r\n   at System.Drawing.Image.Save(String filename, ImageCodecInfo encoder, EncoderParameters encoderParams)\r\n   at IncidentReporter.API.BLL.AssetsBLL.QrCodeImageGenration(Int32 assetId, List`1 locationIds, Int32 orgId, Int32 assetType) in D:\\osmosys\\oqsha\\incident-reporter-api\\IncidentReporter\\IncidentReporter.API\\BLL\\AssetsBLL.cs:line 586\r\n   at IncidentReporter.API.BLL.AssetsBLL.<CreateAssets>d__8.MoveNext() in D:\\osmosys\\oqsha\\incident-reporter-api\\IncidentReporter\\IncidentReporter.API\\BLL\\AssetsBLL.cs:line 0" }
{ "timestamp": "2026-01-06 14:31:01.0144", "level": "Error", "severity": "ERROR" }