{ "timestamp": "2026-05-13 04:18:39.1375", "level": "Error", "severity": "ERROR", "message": "Value cannot be null.\r\nParameter name: path3", "stackTrace": "System.ArgumentNullException: Value cannot be null.\r\nParameter name: path3\r\n   at System.IO.Path.Combine(String path1, String path2, String path3)\r\n   at InspectionV2PDFHelper.<ExportInspectionV2PDFAsync>d__1.MoveNext() in C:\\GitLab-Runner\\builds\\27n6lYj0J\\0\\incident-reporter\\incident-reporter-api\\IncidentReporter\\IncidentReporter.API\\Helpers\\InspectionV2PDFHelper.cs:line 32\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.InspectionV2Bll.<ExportInspectionV2PDFAsync>d__8.MoveNext() in C:\\GitLab-Runner\\builds\\27n6lYj0J\\0\\incident-reporter\\incident-reporter-api\\IncidentReporter\\IncidentReporter.API\\BLL\\InspectionV2Bll.cs:line 762" }
{ "timestamp": "2026-05-13 04:18:39.3822", "level": "Error", "severity": "ERROR" }
{ "timestamp": "2026-05-13 04:18:45.2249", "level": "Error", "severity": "ERROR", "message": "Value cannot be null.\r\nParameter name: path3", "stackTrace": "System.ArgumentNullException: Value cannot be null.\r\nParameter name: path3\r\n   at System.IO.Path.Combine(String path1, String path2, String path3)\r\n   at InspectionV2PDFHelper.<ExportInspectionV2PDFAsync>d__1.MoveNext() in C:\\GitLab-Runner\\builds\\27n6lYj0J\\0\\incident-reporter\\incident-reporter-api\\IncidentReporter\\IncidentReporter.API\\Helpers\\InspectionV2PDFHelper.cs:line 32\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.InspectionV2Bll.<ExportInspectionV2PDFAsync>d__8.MoveNext() in C:\\GitLab-Runner\\builds\\27n6lYj0J\\0\\incident-reporter\\incident-reporter-api\\IncidentReporter\\IncidentReporter.API\\BLL\\InspectionV2Bll.cs:line 762" }
{ "timestamp": "2026-05-13 04:18:45.2249", "level": "Error", "severity": "ERROR" }
{ "timestamp": "2026-05-13 04:23:36.4649", "level": "Error", "severity": "ERROR" }
{ "timestamp": "2026-05-13 04:37:34.9594", "level": "Error", "severity": "ERROR" }
{ "timestamp": "2026-05-13 04:59:56.0253", "level": "Error", "severity": "ERROR" }
{ "timestamp": "2026-05-13 05:00:34.4706", "level": "Error", "severity": "ERROR" }
{ "timestamp": "2026-05-13 05:01:29.4987", "level": "Error", "severity": "ERROR" }
{ "timestamp": "2026-05-13 05:11:42.1564", "level": "Error", "severity": "ERROR" }
{ "timestamp": "2026-05-13 05:12:07.6003", "level": "Error", "severity": "ERROR" }
{ "timestamp": "2026-05-13 05:13:01.4318", "level": "Error", "severity": "ERROR" }
{ "timestamp": "2026-05-13 05:35:55.7800", "level": "Error", "severity": "ERROR" }
{ "timestamp": "2026-05-13 05:47:01.5382", "level": "Error", "severity": "ERROR" }
{ "timestamp": "2026-05-13 05:48:21.7852", "level": "Error", "severity": "ERROR" }
{ "timestamp": "2026-05-13 05:48:35.0753", "level": "Error", "severity": "ERROR" }
{ "timestamp": "2026-05-13 05:48:41.2518", "level": "Error", "severity": "ERROR" }
{ "timestamp": "2026-05-13 05:52:52.0092", "level": "Error", "severity": "ERROR", "message": "Could not find file 'D:\\App-Data\\iis\\api.incidentreporter365.com\\Templates\\ExportInvestigationV2PDFTemplate.html'.", "stackTrace": "System.IO.FileNotFoundException: Could not find file 'D:\\App-Data\\iis\\api.incidentreporter365.com\\Templates\\ExportInvestigationV2PDFTemplate.html'.\r\nFile name: 'D:\\App-Data\\iis\\api.incidentreporter365.com\\Templates\\ExportInvestigationV2PDFTemplate.html'\r\n   at System.IO.__Error.WinIOError(Int32 errorCode, String maybeFullPath)\r\n   at System.IO.FileStream.Init(String path, FileMode mode, FileAccess access, Int32 rights, Boolean useRights, FileShare share, Int32 bufferSize, FileOptions options, SECURITY_ATTRIBUTES secAttrs, String msgPath, Boolean bFromProxy, Boolean useLongPath, Boolean checkHost)\r\n   at System.IO.FileStream..ctor(String path, FileMode mode, FileAccess access, FileShare share, Int32 bufferSize, FileOptions options, String msgPath, Boolean bFromProxy, Boolean useLongPath, Boolean checkHost)\r\n   at System.IO.StreamReader..ctor(String path, Encoding encoding, Boolean detectEncodingFromByteOrderMarks, Int32 bufferSize, Boolean checkHost)\r\n   at System.IO.File.InternalReadAllText(String path, Encoding encoding, Boolean checkHost)\r\n   at IncidentReporter.API.Helpers.ExportInvestigationsPdfHelper.<ExportInvestigationPDFAsync>d__3.MoveNext() in C:\\GitLab-Runner\\builds\\27n6lYj0J\\0\\incident-reporter\\incident-reporter-api\\IncidentReporter\\IncidentReporter.API\\Helpers\\ExportInvestigationsPdfHelper.cs:line 71\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.InvestigationsBll.<ExportInvestigationPDFAsync>d__14.MoveNext() in C:\\GitLab-Runner\\builds\\27n6lYj0J\\0\\incident-reporter\\incident-reporter-api\\IncidentReporter\\IncidentReporter.API\\BLL\\InvestigationsBll.cs:line 1165" }
{ "timestamp": "2026-05-13 05:52:52.0465", "level": "Error", "severity": "ERROR" }
{ "timestamp": "2026-05-13 05:52:54.9825", "level": "Error", "severity": "ERROR", "message": "Could not find file 'D:\\App-Data\\iis\\api.incidentreporter365.com\\Templates\\ExportInvestigationV2PDFTemplate.html'.", "stackTrace": "System.IO.FileNotFoundException: Could not find file 'D:\\App-Data\\iis\\api.incidentreporter365.com\\Templates\\ExportInvestigationV2PDFTemplate.html'.\r\nFile name: 'D:\\App-Data\\iis\\api.incidentreporter365.com\\Templates\\ExportInvestigationV2PDFTemplate.html'\r\n   at System.IO.__Error.WinIOError(Int32 errorCode, String maybeFullPath)\r\n   at System.IO.FileStream.Init(String path, FileMode mode, FileAccess access, Int32 rights, Boolean useRights, FileShare share, Int32 bufferSize, FileOptions options, SECURITY_ATTRIBUTES secAttrs, String msgPath, Boolean bFromProxy, Boolean useLongPath, Boolean checkHost)\r\n   at System.IO.FileStream..ctor(String path, FileMode mode, FileAccess access, FileShare share, Int32 bufferSize, FileOptions options, String msgPath, Boolean bFromProxy, Boolean useLongPath, Boolean checkHost)\r\n   at System.IO.StreamReader..ctor(String path, Encoding encoding, Boolean detectEncodingFromByteOrderMarks, Int32 bufferSize, Boolean checkHost)\r\n   at System.IO.File.InternalReadAllText(String path, Encoding encoding, Boolean checkHost)\r\n   at IncidentReporter.API.Helpers.ExportInvestigationsPdfHelper.<ExportInvestigationPDFAsync>d__3.MoveNext() in C:\\GitLab-Runner\\builds\\27n6lYj0J\\0\\incident-reporter\\incident-reporter-api\\IncidentReporter\\IncidentReporter.API\\Helpers\\ExportInvestigationsPdfHelper.cs:line 71\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.InvestigationsBll.<ExportInvestigationPDFAsync>d__14.MoveNext() in C:\\GitLab-Runner\\builds\\27n6lYj0J\\0\\incident-reporter\\incident-reporter-api\\IncidentReporter\\IncidentReporter.API\\BLL\\InvestigationsBll.cs:line 1165" }
{ "timestamp": "2026-05-13 05:52:54.9825", "level": "Error", "severity": "ERROR" }
{ "timestamp": "2026-05-13 05:53:01.6895", "level": "Error", "severity": "ERROR", "message": "Could not find file 'D:\\App-Data\\iis\\api.incidentreporter365.com\\Templates\\ExportInvestigationV2PDFTemplate.html'.", "stackTrace": "System.IO.FileNotFoundException: Could not find file 'D:\\App-Data\\iis\\api.incidentreporter365.com\\Templates\\ExportInvestigationV2PDFTemplate.html'.\r\nFile name: 'D:\\App-Data\\iis\\api.incidentreporter365.com\\Templates\\ExportInvestigationV2PDFTemplate.html'\r\n   at System.IO.__Error.WinIOError(Int32 errorCode, String maybeFullPath)\r\n   at System.IO.FileStream.Init(String path, FileMode mode, FileAccess access, Int32 rights, Boolean useRights, FileShare share, Int32 bufferSize, FileOptions options, SECURITY_ATTRIBUTES secAttrs, String msgPath, Boolean bFromProxy, Boolean useLongPath, Boolean checkHost)\r\n   at System.IO.FileStream..ctor(String path, FileMode mode, FileAccess access, FileShare share, Int32 bufferSize, FileOptions options, String msgPath, Boolean bFromProxy, Boolean useLongPath, Boolean checkHost)\r\n   at System.IO.StreamReader..ctor(String path, Encoding encoding, Boolean detectEncodingFromByteOrderMarks, Int32 bufferSize, Boolean checkHost)\r\n   at System.IO.File.InternalReadAllText(String path, Encoding encoding, Boolean checkHost)\r\n   at IncidentReporter.API.Helpers.ExportInvestigationsPdfHelper.<ExportInvestigationPDFAsync>d__3.MoveNext() in C:\\GitLab-Runner\\builds\\27n6lYj0J\\0\\incident-reporter\\incident-reporter-api\\IncidentReporter\\IncidentReporter.API\\Helpers\\ExportInvestigationsPdfHelper.cs:line 71\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.InvestigationsBll.<ExportInvestigationPDFAsync>d__14.MoveNext() in C:\\GitLab-Runner\\builds\\27n6lYj0J\\0\\incident-reporter\\incident-reporter-api\\IncidentReporter\\IncidentReporter.API\\BLL\\InvestigationsBll.cs:line 1165" }
{ "timestamp": "2026-05-13 05:53:01.6895", "level": "Error", "severity": "ERROR" }
{ "timestamp": "2026-05-13 05:53:50.0099", "level": "Error", "severity": "ERROR", "message": "Could not find file 'D:\\App-Data\\iis\\api.incidentreporter365.com\\Templates\\ExportInvestigationV2PDFTemplate.html'.", "stackTrace": "System.IO.FileNotFoundException: Could not find file 'D:\\App-Data\\iis\\api.incidentreporter365.com\\Templates\\ExportInvestigationV2PDFTemplate.html'.\r\nFile name: 'D:\\App-Data\\iis\\api.incidentreporter365.com\\Templates\\ExportInvestigationV2PDFTemplate.html'\r\n   at System.IO.__Error.WinIOError(Int32 errorCode, String maybeFullPath)\r\n   at System.IO.FileStream.Init(String path, FileMode mode, FileAccess access, Int32 rights, Boolean useRights, FileShare share, Int32 bufferSize, FileOptions options, SECURITY_ATTRIBUTES secAttrs, String msgPath, Boolean bFromProxy, Boolean useLongPath, Boolean checkHost)\r\n   at System.IO.FileStream..ctor(String path, FileMode mode, FileAccess access, FileShare share, Int32 bufferSize, FileOptions options, String msgPath, Boolean bFromProxy, Boolean useLongPath, Boolean checkHost)\r\n   at System.IO.StreamReader..ctor(String path, Encoding encoding, Boolean detectEncodingFromByteOrderMarks, Int32 bufferSize, Boolean checkHost)\r\n   at System.IO.File.InternalReadAllText(String path, Encoding encoding, Boolean checkHost)\r\n   at IncidentReporter.API.Helpers.ExportInvestigationsPdfHelper.<ExportInvestigationPDFAsync>d__3.MoveNext() in C:\\GitLab-Runner\\builds\\27n6lYj0J\\0\\incident-reporter\\incident-reporter-api\\IncidentReporter\\IncidentReporter.API\\Helpers\\ExportInvestigationsPdfHelper.cs:line 71\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.InvestigationsBll.<ExportInvestigationPDFAsync>d__14.MoveNext() in C:\\GitLab-Runner\\builds\\27n6lYj0J\\0\\incident-reporter\\incident-reporter-api\\IncidentReporter\\IncidentReporter.API\\BLL\\InvestigationsBll.cs:line 1165" }
{ "timestamp": "2026-05-13 05:53:50.0099", "level": "Error", "severity": "ERROR" }
{ "timestamp": "2026-05-13 05:55:05.2355", "level": "Error", "severity": "ERROR", "message": "Could not find file 'D:\\App-Data\\iis\\api.incidentreporter365.com\\Templates\\ExportInvestigationV2PDFTemplate.html'.", "stackTrace": "System.IO.FileNotFoundException: Could not find file 'D:\\App-Data\\iis\\api.incidentreporter365.com\\Templates\\ExportInvestigationV2PDFTemplate.html'.\r\nFile name: 'D:\\App-Data\\iis\\api.incidentreporter365.com\\Templates\\ExportInvestigationV2PDFTemplate.html'\r\n   at System.IO.__Error.WinIOError(Int32 errorCode, String maybeFullPath)\r\n   at System.IO.FileStream.Init(String path, FileMode mode, FileAccess access, Int32 rights, Boolean useRights, FileShare share, Int32 bufferSize, FileOptions options, SECURITY_ATTRIBUTES secAttrs, String msgPath, Boolean bFromProxy, Boolean useLongPath, Boolean checkHost)\r\n   at System.IO.FileStream..ctor(String path, FileMode mode, FileAccess access, FileShare share, Int32 bufferSize, FileOptions options, String msgPath, Boolean bFromProxy, Boolean useLongPath, Boolean checkHost)\r\n   at System.IO.StreamReader..ctor(String path, Encoding encoding, Boolean detectEncodingFromByteOrderMarks, Int32 bufferSize, Boolean checkHost)\r\n   at System.IO.File.InternalReadAllText(String path, Encoding encoding, Boolean checkHost)\r\n   at IncidentReporter.API.Helpers.ExportInvestigationsPdfHelper.<ExportInvestigationPDFAsync>d__3.MoveNext() in C:\\GitLab-Runner\\builds\\27n6lYj0J\\0\\incident-reporter\\incident-reporter-api\\IncidentReporter\\IncidentReporter.API\\Helpers\\ExportInvestigationsPdfHelper.cs:line 71\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.InvestigationsBll.<ExportInvestigationPDFAsync>d__14.MoveNext() in C:\\GitLab-Runner\\builds\\27n6lYj0J\\0\\incident-reporter\\incident-reporter-api\\IncidentReporter\\IncidentReporter.API\\BLL\\InvestigationsBll.cs:line 1165" }
{ "timestamp": "2026-05-13 05:55:05.2355", "level": "Error", "severity": "ERROR" }
{ "timestamp": "2026-05-13 05:57:48.2446", "level": "Error", "severity": "ERROR", "message": "Could not find file 'D:\\App-Data\\iis\\api.incidentreporter365.com\\Templates\\ExportInvestigationV2PDFTemplate.html'.", "stackTrace": "System.IO.FileNotFoundException: Could not find file 'D:\\App-Data\\iis\\api.incidentreporter365.com\\Templates\\ExportInvestigationV2PDFTemplate.html'.\r\nFile name: 'D:\\App-Data\\iis\\api.incidentreporter365.com\\Templates\\ExportInvestigationV2PDFTemplate.html'\r\n   at System.IO.__Error.WinIOError(Int32 errorCode, String maybeFullPath)\r\n   at System.IO.FileStream.Init(String path, FileMode mode, FileAccess access, Int32 rights, Boolean useRights, FileShare share, Int32 bufferSize, FileOptions options, SECURITY_ATTRIBUTES secAttrs, String msgPath, Boolean bFromProxy, Boolean useLongPath, Boolean checkHost)\r\n   at System.IO.FileStream..ctor(String path, FileMode mode, FileAccess access, FileShare share, Int32 bufferSize, FileOptions options, String msgPath, Boolean bFromProxy, Boolean useLongPath, Boolean checkHost)\r\n   at System.IO.StreamReader..ctor(String path, Encoding encoding, Boolean detectEncodingFromByteOrderMarks, Int32 bufferSize, Boolean checkHost)\r\n   at System.IO.File.InternalReadAllText(String path, Encoding encoding, Boolean checkHost)\r\n   at IncidentReporter.API.Helpers.ExportInvestigationsPdfHelper.<ExportInvestigationPDFAsync>d__3.MoveNext() in C:\\GitLab-Runner\\builds\\27n6lYj0J\\0\\incident-reporter\\incident-reporter-api\\IncidentReporter\\IncidentReporter.API\\Helpers\\ExportInvestigationsPdfHelper.cs:line 71\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.InvestigationsBll.<ExportInvestigationPDFAsync>d__14.MoveNext() in C:\\GitLab-Runner\\builds\\27n6lYj0J\\0\\incident-reporter\\incident-reporter-api\\IncidentReporter\\IncidentReporter.API\\BLL\\InvestigationsBll.cs:line 1165" }
{ "timestamp": "2026-05-13 05:57:48.2446", "level": "Error", "severity": "ERROR" }
{ "timestamp": "2026-05-13 06:01:40.2732", "level": "Error", "severity": "ERROR" }
{ "timestamp": "2026-05-13 06:08:59.2020", "level": "Error", "severity": "ERROR" }
{ "timestamp": "2026-05-13 06:10:55.8105", "level": "Error", "severity": "ERROR" }
{ "timestamp": "2026-05-13 06:11:48.7119", "level": "Error", "severity": "ERROR" }
{ "timestamp": "2026-05-13 06:35:37.0724", "level": "Error", "severity": "ERROR", "message": "User details not found for the given user and organisation.", "stackTrace": "System.Exception: User details not found for the given user and organisation." }
{ "timestamp": "2026-05-13 06:35:37.0873", "level": "Error", "severity": "ERROR" }
{ "timestamp": "2026-05-13 06:35:37.1985", "level": "Error", "severity": "ERROR", "message": "User details not found for the given user and organisation.", "stackTrace": "System.Exception: User details not found for the given user and organisation." }
{ "timestamp": "2026-05-13 06:35:37.1985", "level": "Error", "severity": "ERROR" }
{ "timestamp": "2026-05-13 06:35:59.6919", "level": "Error", "severity": "ERROR" }
{ "timestamp": "2026-05-13 06:36:37.3123", "level": "Error", "severity": "ERROR" }
{ "timestamp": "2026-05-13 06:37:51.5236", "level": "Error", "severity": "ERROR" }
{ "timestamp": "2026-05-13 06:39:41.0879", "level": "Error", "severity": "ERROR" }
{ "timestamp": "2026-05-13 06:39:41.2705", "level": "Error", "severity": "ERROR" }
{ "timestamp": "2026-05-13 06:39:42.2271", "level": "Error", "severity": "ERROR" }
{ "timestamp": "2026-05-13 06:44:17.1754", "level": "Error", "severity": "ERROR" }
{ "timestamp": "2026-05-13 06:44:58.8000", "level": "Error", "severity": "ERROR" }
{ "timestamp": "2026-05-13 06:52:57.4528", "level": "Error", "severity": "ERROR" }
{ "timestamp": "2026-05-13 06:55:34.3808", "level": "Error", "severity": "ERROR" }
{ "timestamp": "2026-05-13 06:57:04.6615", "level": "Error", "severity": "ERROR" }
{ "timestamp": "2026-05-13 06:57:09.7536", "level": "Error", "severity": "ERROR", "message": "Object reference not set to an instance of an object.", "stackTrace": "System.NullReferenceException: Object reference not set to an instance of an object.\r\n   at IncidentReporter.API.BLL.ActionTrackersBll.<GetActionTrackerByIdAsync>d__8.MoveNext() in C:\\GitLab-Runner\\builds\\27n6lYj0J\\0\\incident-reporter\\incident-reporter-api\\IncidentReporter\\IncidentReporter.API\\BLL\\ActionTrackersBll.cs:line 989" }
{ "timestamp": "2026-05-13 06:57:09.7536", "level": "Error", "severity": "ERROR" }
{ "timestamp": "2026-05-13 07:00:10.3040", "level": "Error", "severity": "ERROR" }
{ "timestamp": "2026-05-13 07:00:16.2269", "level": "Error", "severity": "ERROR" }
{ "timestamp": "2026-05-13 07:00:27.7164", "level": "Error", "severity": "ERROR" }
{ "timestamp": "2026-05-13 07:00:36.5651", "level": "Error", "severity": "ERROR" }
{ "timestamp": "2026-05-13 07:04:12.0991", "level": "Error", "severity": "ERROR" }
{ "timestamp": "2026-05-13 07:04:21.4649", "level": "Error", "severity": "ERROR" }
{ "timestamp": "2026-05-13 07:05:23.9916", "level": "Error", "severity": "ERROR" }
{ "timestamp": "2026-05-13 07:05:31.2669", "level": "Error", "severity": "ERROR" }
{ "timestamp": "2026-05-13 07:05:37.1487", "level": "Error", "severity": "ERROR" }
{ "timestamp": "2026-05-13 07:14:36.4335", "level": "Error", "severity": "ERROR" }
{ "timestamp": "2026-05-13 07:44:34.2848", "level": "Error", "severity": "ERROR" }
{ "timestamp": "2026-05-13 07:44:51.4320", "level": "Error", "severity": "ERROR" }
{ "timestamp": "2026-05-13 08:14:40.5540", "level": "Error", "severity": "ERROR", "message": "Cannot delete or update a parent row: a foreign key constraint fails (`qa_stg_oqsha_4`.`entity_tasks`, CONSTRAINT `fk_entity_tasks_task_id` FOREIGN KEY (`task_id`) REFERENCES `tasks` (`id`))", "stackTrace": "MySql.Data.MySqlClient.MySqlException (0x80004005): Cannot delete or update a parent row: a foreign key constraint fails (`qa_stg_oqsha_4`.`entity_tasks`, CONSTRAINT `fk_entity_tasks_task_id` FOREIGN KEY (`task_id`) REFERENCES `tasks` (`id`))\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 MySql.Data.MySqlClient.MySqlCommand.ExecuteNonQuery()\r\n   at Dapper.SqlMapper.ExecuteCommand(IDbConnection cnn, CommandDefinition& command, Action`2 paramReader)\r\n   at Dapper.SqlMapper.ExecuteImpl(IDbConnection cnn, CommandDefinition& command)\r\n   at Dapper.SqlMapper.Execute(IDbConnection cnn, String sql, Object param, IDbTransaction transaction, Nullable`1 commandTimeout, Nullable`1 commandType)\r\n   at IncidentReporter.DAL.Repositories.TaskRepo.HardDeleteTaskById(Int32 taskId, Int32 organisationId) in C:\\GitLab-Runner\\builds\\27n6lYj0J\\0\\incident-reporter\\incident-reporter-api\\IncidentReporter\\IncidentReporter.DAL\\Repositories\\TaskRepo.cs:line 160\r\n   at IncidentReporter.API.BLL.TaskBLL.<DeleteTaskAsync>d__75.MoveNext() in C:\\GitLab-Runner\\builds\\27n6lYj0J\\0\\incident-reporter\\incident-reporter-api\\IncidentReporter\\IncidentReporter.API\\BLL\\TaskBLL.cs:line 5814" }
{ "timestamp": "2026-05-13 08:14:40.6157", "level": "Error", "severity": "ERROR" }
{ "timestamp": "2026-05-13 08:14:50.1988", "level": "Error", "severity": "ERROR", "message": "Cannot delete or update a parent row: a foreign key constraint fails (`qa_stg_oqsha_4`.`entity_tasks`, CONSTRAINT `fk_entity_tasks_task_id` FOREIGN KEY (`task_id`) REFERENCES `tasks` (`id`))", "stackTrace": "MySql.Data.MySqlClient.MySqlException (0x80004005): Cannot delete or update a parent row: a foreign key constraint fails (`qa_stg_oqsha_4`.`entity_tasks`, CONSTRAINT `fk_entity_tasks_task_id` FOREIGN KEY (`task_id`) REFERENCES `tasks` (`id`))\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 MySql.Data.MySqlClient.MySqlCommand.ExecuteNonQuery()\r\n   at Dapper.SqlMapper.ExecuteCommand(IDbConnection cnn, CommandDefinition& command, Action`2 paramReader)\r\n   at Dapper.SqlMapper.ExecuteImpl(IDbConnection cnn, CommandDefinition& command)\r\n   at Dapper.SqlMapper.Execute(IDbConnection cnn, String sql, Object param, IDbTransaction transaction, Nullable`1 commandTimeout, Nullable`1 commandType)\r\n   at IncidentReporter.DAL.Repositories.TaskRepo.HardDeleteTaskById(Int32 taskId, Int32 organisationId) in C:\\GitLab-Runner\\builds\\27n6lYj0J\\0\\incident-reporter\\incident-reporter-api\\IncidentReporter\\IncidentReporter.DAL\\Repositories\\TaskRepo.cs:line 160\r\n   at IncidentReporter.API.BLL.TaskBLL.<DeleteTaskAsync>d__75.MoveNext() in C:\\GitLab-Runner\\builds\\27n6lYj0J\\0\\incident-reporter\\incident-reporter-api\\IncidentReporter\\IncidentReporter.API\\BLL\\TaskBLL.cs:line 5814" }
{ "timestamp": "2026-05-13 08:14:50.1988", "level": "Error", "severity": "ERROR" }
{ "timestamp": "2026-05-13 08:16:59.2986", "level": "Error", "severity": "ERROR" }
{ "timestamp": "2026-05-13 08:18:17.7021", "level": "Error", "severity": "ERROR" }
{ "timestamp": "2026-05-13 08:29:35.2855", "level": "Error", "severity": "ERROR" }
{ "timestamp": "2026-05-13 08:39:53.3460", "level": "Error", "severity": "ERROR" }
{ "timestamp": "2026-05-13 08:48:19.8547", "level": "Error", "severity": "ERROR" }
{ "timestamp": "2026-05-13 08:50:29.3659", "level": "Error", "severity": "ERROR" }
{ "timestamp": "2026-05-13 08:52:36.6385", "level": "Error", "severity": "ERROR" }
{ "timestamp": "2026-05-13 08:53:40.6917", "level": "Error", "severity": "ERROR" }
{ "timestamp": "2026-05-13 08:54:35.1760", "level": "Error", "severity": "ERROR" }
{ "timestamp": "2026-05-13 08:58:58.1833", "level": "Error", "severity": "ERROR" }
{ "timestamp": "2026-05-13 08:59:33.7983", "level": "Error", "severity": "ERROR" }
{ "timestamp": "2026-05-13 08:59:33.8851", "level": "Error", "severity": "ERROR" }
{ "timestamp": "2026-05-13 08:59:41.1198", "level": "Error", "severity": "ERROR" }
{ "timestamp": "2026-05-13 08:59:54.0856", "level": "Error", "severity": "ERROR" }
{ "timestamp": "2026-05-13 09:01:46.4220", "level": "Error", "severity": "ERROR" }
{ "timestamp": "2026-05-13 09:02:03.3057", "level": "Error", "severity": "ERROR", "message": "Object reference not set to an instance of an object.", "stackTrace": "System.NullReferenceException: Object reference not set to an instance of an object.\r\n   at IncidentReporter.API.BLL.InspectionsBLL.<CreateInspection>d__7.MoveNext() in C:\\GitLab-Runner\\builds\\27n6lYj0J\\0\\incident-reporter\\incident-reporter-api\\IncidentReporter\\IncidentReporter.API\\BLL\\InspectionsBLL.cs:line 671\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.Controllers.InspectionsController.<CreateInspection>d__0.MoveNext() in C:\\GitLab-Runner\\builds\\27n6lYj0J\\0\\incident-reporter\\incident-reporter-api\\IncidentReporter\\IncidentReporter.API\\Controllers\\InspectionsController.cs:line 23\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.Threading.Tasks.TaskHelpersExtensions.<CastToObject>d__3`1.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.Web.Http.Controllers.ApiControllerActionInvoker.<InvokeActionAsyncCore>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.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.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.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.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.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.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.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.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.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.HandleNonSuccessAndDebuggerNotification(Task task)\r\n   at System.Web.Http.Controllers.ExceptionFilterResult.<ExecuteAsync>d__0.MoveNext()" }
{ "timestamp": "2026-05-13 09:02:45.9635", "level": "Error", "severity": "ERROR" }
{ "timestamp": "2026-05-13 09:03:26.8543", "level": "Error", "severity": "ERROR" }
{ "timestamp": "2026-05-13 09:03:51.0202", "level": "Error", "severity": "ERROR" }
{ "timestamp": "2026-05-13 09:04:27.0175", "level": "Error", "severity": "ERROR" }
{ "timestamp": "2026-05-13 09:05:45.2382", "level": "Error", "severity": "ERROR" }
{ "timestamp": "2026-05-13 09:06:38.7190", "level": "Error", "severity": "ERROR" }
{ "timestamp": "2026-05-13 09:07:57.5100", "level": "Error", "severity": "ERROR" }
{ "timestamp": "2026-05-13 09:08:20.6843", "level": "Error", "severity": "ERROR" }
{ "timestamp": "2026-05-13 09:12:44.2331", "level": "Error", "severity": "ERROR", "message": "Cannot delete or update a parent row: a foreign key constraint fails (`qa_stg_oqsha_4`.`entity_tasks`, CONSTRAINT `fk_entity_tasks_task_id` FOREIGN KEY (`task_id`) REFERENCES `tasks` (`id`))", "stackTrace": "MySql.Data.MySqlClient.MySqlException (0x80004005): Cannot delete or update a parent row: a foreign key constraint fails (`qa_stg_oqsha_4`.`entity_tasks`, CONSTRAINT `fk_entity_tasks_task_id` FOREIGN KEY (`task_id`) REFERENCES `tasks` (`id`))\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 MySql.Data.MySqlClient.MySqlCommand.ExecuteNonQuery()\r\n   at Dapper.SqlMapper.ExecuteCommand(IDbConnection cnn, CommandDefinition& command, Action`2 paramReader)\r\n   at Dapper.SqlMapper.ExecuteImpl(IDbConnection cnn, CommandDefinition& command)\r\n   at Dapper.SqlMapper.Execute(IDbConnection cnn, String sql, Object param, IDbTransaction transaction, Nullable`1 commandTimeout, Nullable`1 commandType)\r\n   at IncidentReporter.DAL.Repositories.TaskRepo.HardDeleteTaskById(Int32 taskId, Int32 organisationId) in C:\\GitLab-Runner\\builds\\27n6lYj0J\\0\\incident-reporter\\incident-reporter-api\\IncidentReporter\\IncidentReporter.DAL\\Repositories\\TaskRepo.cs:line 160\r\n   at IncidentReporter.API.BLL.TaskBLL.<DeleteTaskAsync>d__75.MoveNext() in C:\\GitLab-Runner\\builds\\27n6lYj0J\\0\\incident-reporter\\incident-reporter-api\\IncidentReporter\\IncidentReporter.API\\BLL\\TaskBLL.cs:line 5814" }
{ "timestamp": "2026-05-13 09:12:44.5763", "level": "Error", "severity": "ERROR" }
{ "timestamp": "2026-05-13 09:18:57.1428", "level": "Error", "severity": "ERROR" }
{ "timestamp": "2026-05-13 09:19:06.2634", "level": "Error", "severity": "ERROR", "message": "Cannot delete or update a parent row: a foreign key constraint fails (`qa_stg_oqsha_4`.`entity_tasks`, CONSTRAINT `fk_entity_tasks_task_id` FOREIGN KEY (`task_id`) REFERENCES `tasks` (`id`))", "stackTrace": "MySql.Data.MySqlClient.MySqlException (0x80004005): Cannot delete or update a parent row: a foreign key constraint fails (`qa_stg_oqsha_4`.`entity_tasks`, CONSTRAINT `fk_entity_tasks_task_id` FOREIGN KEY (`task_id`) REFERENCES `tasks` (`id`))\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 MySql.Data.MySqlClient.MySqlCommand.ExecuteNonQuery()\r\n   at Dapper.SqlMapper.ExecuteCommand(IDbConnection cnn, CommandDefinition& command, Action`2 paramReader)\r\n   at Dapper.SqlMapper.ExecuteImpl(IDbConnection cnn, CommandDefinition& command)\r\n   at Dapper.SqlMapper.Execute(IDbConnection cnn, String sql, Object param, IDbTransaction transaction, Nullable`1 commandTimeout, Nullable`1 commandType)\r\n   at IncidentReporter.DAL.Repositories.TaskRepo.HardDeleteTaskById(Int32 taskId, Int32 organisationId) in C:\\GitLab-Runner\\builds\\27n6lYj0J\\0\\incident-reporter\\incident-reporter-api\\IncidentReporter\\IncidentReporter.DAL\\Repositories\\TaskRepo.cs:line 160\r\n   at IncidentReporter.API.BLL.TaskBLL.<DeleteTaskAsync>d__75.MoveNext() in C:\\GitLab-Runner\\builds\\27n6lYj0J\\0\\incident-reporter\\incident-reporter-api\\IncidentReporter\\IncidentReporter.API\\BLL\\TaskBLL.cs:line 5814" }
{ "timestamp": "2026-05-13 09:19:06.2634", "level": "Error", "severity": "ERROR" }
{ "timestamp": "2026-05-13 09:19:08.8672", "level": "Error", "severity": "ERROR", "message": "Unknown column 'sa.resolved_on' in 'SELECT'", "stackTrace": "MySql.Data.MySqlClient.MySqlException (0x80004005): Unknown column 'sa.resolved_on' in 'SELECT'\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.<QueryRowAsync>d__34`1.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.SafetyAlertsRepo.<>c__DisplayClass15_0.<<GetSafetyAlertsDetailsByIdAsync>b__0>d.MoveNext() in C:\\GitLab-Runner\\builds\\27n6lYj0J\\0\\incident-reporter\\incident-reporter-api\\IncidentReporter\\IncidentReporter.DAL\\Repositories\\SafetyAlertsRepo.cs:line 515\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.BaseRepo.<ExecuteQueryAsync>d__7`1.MoveNext() in C:\\GitLab-Runner\\builds\\27n6lYj0J\\0\\incident-reporter\\incident-reporter-api\\IncidentReporter\\IncidentReporter.DAL\\Repositories\\BaseRepo.cs:line 0\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.SafetyAlertsRepo.<GetSafetyAlertsDetailsByIdAsync>d__15.MoveNext() in C:\\GitLab-Runner\\builds\\27n6lYj0J\\0\\incident-reporter\\incident-reporter-api\\IncidentReporter\\IncidentReporter.DAL\\Repositories\\SafetyAlertsRepo.cs:line 513\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.SafetyAlertsBll.<GetSafetyAlertByIdAsync>d__10.MoveNext() in C:\\GitLab-Runner\\builds\\27n6lYj0J\\0\\incident-reporter\\incident-reporter-api\\IncidentReporter\\IncidentReporter.API\\BLL\\SafetyAlertsBll.cs:line 1016" }
{ "timestamp": "2026-05-13 09:19:08.8672", "level": "Error", "severity": "ERROR" }
{ "timestamp": "2026-05-13 09:19:55.9868", "level": "Error", "severity": "ERROR" }
{ "timestamp": "2026-05-13 09:19:56.0985", "level": "Error", "severity": "ERROR" }
{ "timestamp": "2026-05-13 09:20:07.4992", "level": "Error", "severity": "ERROR" }
{ "timestamp": "2026-05-13 09:20:07.5747", "level": "Error", "severity": "ERROR" }
{ "timestamp": "2026-05-13 09:21:02.5562", "level": "Error", "severity": "ERROR", "message": "A potentially dangerous Request.Path value was detected from the client (:).", "stackTrace": "System.Web.HttpException (0x80004005): A potentially dangerous Request.Path value was detected from the client (:).\r\n   at System.Web.HttpRequest.ValidateInputIfRequiredByConfig()\r\n   at System.Web.HttpApplication.PipelineStepManager.ValidateHelper(HttpContext context)" }
{ "timestamp": "2026-05-13 09:25:00.1770", "level": "Error", "severity": "ERROR" }
{ "timestamp": "2026-05-13 09:25:19.1829", "level": "Error", "severity": "ERROR", "message": "Cannot delete or update a parent row: a foreign key constraint fails (`qa_stg_oqsha_4`.`entity_tasks`, CONSTRAINT `fk_entity_tasks_task_id` FOREIGN KEY (`task_id`) REFERENCES `tasks` (`id`))", "stackTrace": "MySql.Data.MySqlClient.MySqlException (0x80004005): Cannot delete or update a parent row: a foreign key constraint fails (`qa_stg_oqsha_4`.`entity_tasks`, CONSTRAINT `fk_entity_tasks_task_id` FOREIGN KEY (`task_id`) REFERENCES `tasks` (`id`))\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 MySql.Data.MySqlClient.MySqlCommand.ExecuteNonQuery()\r\n   at Dapper.SqlMapper.ExecuteCommand(IDbConnection cnn, CommandDefinition& command, Action`2 paramReader)\r\n   at Dapper.SqlMapper.ExecuteImpl(IDbConnection cnn, CommandDefinition& command)\r\n   at Dapper.SqlMapper.Execute(IDbConnection cnn, String sql, Object param, IDbTransaction transaction, Nullable`1 commandTimeout, Nullable`1 commandType)\r\n   at IncidentReporter.DAL.Repositories.TaskRepo.HardDeleteTaskById(Int32 taskId, Int32 organisationId) in C:\\GitLab-Runner\\builds\\27n6lYj0J\\0\\incident-reporter\\incident-reporter-api\\IncidentReporter\\IncidentReporter.DAL\\Repositories\\TaskRepo.cs:line 160\r\n   at IncidentReporter.API.BLL.TaskBLL.<DeleteTaskAsync>d__75.MoveNext() in C:\\GitLab-Runner\\builds\\27n6lYj0J\\0\\incident-reporter\\incident-reporter-api\\IncidentReporter\\IncidentReporter.API\\BLL\\TaskBLL.cs:line 5814" }
{ "timestamp": "2026-05-13 09:25:19.1829", "level": "Error", "severity": "ERROR" }
{ "timestamp": "2026-05-13 09:28:36.8086", "level": "Error", "severity": "ERROR" }
{ "timestamp": "2026-05-13 09:28:45.9729", "level": "Error", "severity": "ERROR" }
{ "timestamp": "2026-05-13 09:29:41.1860", "level": "Error", "severity": "ERROR", "message": "Unknown column 'sa.resolved_on' in 'SELECT'", "stackTrace": "MySql.Data.MySqlClient.MySqlException (0x80004005): Unknown column 'sa.resolved_on' in 'SELECT'\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.<QueryRowAsync>d__34`1.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.SafetyAlertsRepo.<>c__DisplayClass15_0.<<GetSafetyAlertsDetailsByIdAsync>b__0>d.MoveNext() in C:\\GitLab-Runner\\builds\\27n6lYj0J\\0\\incident-reporter\\incident-reporter-api\\IncidentReporter\\IncidentReporter.DAL\\Repositories\\SafetyAlertsRepo.cs:line 515\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.BaseRepo.<ExecuteQueryAsync>d__7`1.MoveNext() in C:\\GitLab-Runner\\builds\\27n6lYj0J\\0\\incident-reporter\\incident-reporter-api\\IncidentReporter\\IncidentReporter.DAL\\Repositories\\BaseRepo.cs:line 0\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.SafetyAlertsRepo.<GetSafetyAlertsDetailsByIdAsync>d__15.MoveNext() in C:\\GitLab-Runner\\builds\\27n6lYj0J\\0\\incident-reporter\\incident-reporter-api\\IncidentReporter\\IncidentReporter.DAL\\Repositories\\SafetyAlertsRepo.cs:line 513\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.SafetyAlertsBll.<GetSafetyAlertByIdAsync>d__10.MoveNext() in C:\\GitLab-Runner\\builds\\27n6lYj0J\\0\\incident-reporter\\incident-reporter-api\\IncidentReporter\\IncidentReporter.API\\BLL\\SafetyAlertsBll.cs:line 1016" }
{ "timestamp": "2026-05-13 09:29:41.1860", "level": "Error", "severity": "ERROR" }
{ "timestamp": "2026-05-13 09:29:44.3589", "level": "Error", "severity": "ERROR" }
{ "timestamp": "2026-05-13 09:29:52.8479", "level": "Error", "severity": "ERROR" }
{ "timestamp": "2026-05-13 09:29:56.6161", "level": "Error", "severity": "ERROR", "message": "Unknown column 'sa.resolved_on' in 'SELECT'", "stackTrace": "MySql.Data.MySqlClient.MySqlException (0x80004005): Unknown column 'sa.resolved_on' in 'SELECT'\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.<QueryRowAsync>d__34`1.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.SafetyAlertsRepo.<>c__DisplayClass15_0.<<GetSafetyAlertsDetailsByIdAsync>b__0>d.MoveNext() in C:\\GitLab-Runner\\builds\\27n6lYj0J\\0\\incident-reporter\\incident-reporter-api\\IncidentReporter\\IncidentReporter.DAL\\Repositories\\SafetyAlertsRepo.cs:line 515\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.BaseRepo.<ExecuteQueryAsync>d__7`1.MoveNext() in C:\\GitLab-Runner\\builds\\27n6lYj0J\\0\\incident-reporter\\incident-reporter-api\\IncidentReporter\\IncidentReporter.DAL\\Repositories\\BaseRepo.cs:line 0\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.SafetyAlertsRepo.<GetSafetyAlertsDetailsByIdAsync>d__15.MoveNext() in C:\\GitLab-Runner\\builds\\27n6lYj0J\\0\\incident-reporter\\incident-reporter-api\\IncidentReporter\\IncidentReporter.DAL\\Repositories\\SafetyAlertsRepo.cs:line 513\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.SafetyAlertsBll.<GetSafetyAlertByIdAsync>d__10.MoveNext() in C:\\GitLab-Runner\\builds\\27n6lYj0J\\0\\incident-reporter\\incident-reporter-api\\IncidentReporter\\IncidentReporter.API\\BLL\\SafetyAlertsBll.cs:line 1016" }
{ "timestamp": "2026-05-13 09:29:56.6161", "level": "Error", "severity": "ERROR" }
{ "timestamp": "2026-05-13 09:29:58.5975", "level": "Error", "severity": "ERROR", "message": "Unknown column 'sa.resolved_on' in 'SELECT'", "stackTrace": "MySql.Data.MySqlClient.MySqlException (0x80004005): Unknown column 'sa.resolved_on' in 'SELECT'\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.<QueryRowAsync>d__34`1.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.SafetyAlertsRepo.<>c__DisplayClass15_0.<<GetSafetyAlertsDetailsByIdAsync>b__0>d.MoveNext() in C:\\GitLab-Runner\\builds\\27n6lYj0J\\0\\incident-reporter\\incident-reporter-api\\IncidentReporter\\IncidentReporter.DAL\\Repositories\\SafetyAlertsRepo.cs:line 515\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.BaseRepo.<ExecuteQueryAsync>d__7`1.MoveNext() in C:\\GitLab-Runner\\builds\\27n6lYj0J\\0\\incident-reporter\\incident-reporter-api\\IncidentReporter\\IncidentReporter.DAL\\Repositories\\BaseRepo.cs:line 0\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.SafetyAlertsRepo.<GetSafetyAlertsDetailsByIdAsync>d__15.MoveNext() in C:\\GitLab-Runner\\builds\\27n6lYj0J\\0\\incident-reporter\\incident-reporter-api\\IncidentReporter\\IncidentReporter.DAL\\Repositories\\SafetyAlertsRepo.cs:line 513\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.SafetyAlertsBll.<GetSafetyAlertByIdAsync>d__10.MoveNext() in C:\\GitLab-Runner\\builds\\27n6lYj0J\\0\\incident-reporter\\incident-reporter-api\\IncidentReporter\\IncidentReporter.API\\BLL\\SafetyAlertsBll.cs:line 1016" }
{ "timestamp": "2026-05-13 09:29:58.5975", "level": "Error", "severity": "ERROR" }
{ "timestamp": "2026-05-13 09:30:00.1257", "level": "Error", "severity": "ERROR", "message": "Unknown column 'sa.resolved_on' in 'SELECT'", "stackTrace": "MySql.Data.MySqlClient.MySqlException (0x80004005): Unknown column 'sa.resolved_on' in 'SELECT'\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.<QueryRowAsync>d__34`1.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.SafetyAlertsRepo.<>c__DisplayClass15_0.<<GetSafetyAlertsDetailsByIdAsync>b__0>d.MoveNext() in C:\\GitLab-Runner\\builds\\27n6lYj0J\\0\\incident-reporter\\incident-reporter-api\\IncidentReporter\\IncidentReporter.DAL\\Repositories\\SafetyAlertsRepo.cs:line 515\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.BaseRepo.<ExecuteQueryAsync>d__7`1.MoveNext() in C:\\GitLab-Runner\\builds\\27n6lYj0J\\0\\incident-reporter\\incident-reporter-api\\IncidentReporter\\IncidentReporter.DAL\\Repositories\\BaseRepo.cs:line 0\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.SafetyAlertsRepo.<GetSafetyAlertsDetailsByIdAsync>d__15.MoveNext() in C:\\GitLab-Runner\\builds\\27n6lYj0J\\0\\incident-reporter\\incident-reporter-api\\IncidentReporter\\IncidentReporter.DAL\\Repositories\\SafetyAlertsRepo.cs:line 513\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.SafetyAlertsBll.<GetSafetyAlertByIdAsync>d__10.MoveNext() in C:\\GitLab-Runner\\builds\\27n6lYj0J\\0\\incident-reporter\\incident-reporter-api\\IncidentReporter\\IncidentReporter.API\\BLL\\SafetyAlertsBll.cs:line 1016" }
{ "timestamp": "2026-05-13 09:30:00.1257", "level": "Error", "severity": "ERROR" }
{ "timestamp": "2026-05-13 09:30:01.5673", "level": "Error", "severity": "ERROR", "message": "Unknown column 'sa.resolved_on' in 'SELECT'", "stackTrace": "MySql.Data.MySqlClient.MySqlException (0x80004005): Unknown column 'sa.resolved_on' in 'SELECT'\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.<QueryRowAsync>d__34`1.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.SafetyAlertsRepo.<>c__DisplayClass15_0.<<GetSafetyAlertsDetailsByIdAsync>b__0>d.MoveNext() in C:\\GitLab-Runner\\builds\\27n6lYj0J\\0\\incident-reporter\\incident-reporter-api\\IncidentReporter\\IncidentReporter.DAL\\Repositories\\SafetyAlertsRepo.cs:line 515\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.BaseRepo.<ExecuteQueryAsync>d__7`1.MoveNext() in C:\\GitLab-Runner\\builds\\27n6lYj0J\\0\\incident-reporter\\incident-reporter-api\\IncidentReporter\\IncidentReporter.DAL\\Repositories\\BaseRepo.cs:line 0\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.SafetyAlertsRepo.<GetSafetyAlertsDetailsByIdAsync>d__15.MoveNext() in C:\\GitLab-Runner\\builds\\27n6lYj0J\\0\\incident-reporter\\incident-reporter-api\\IncidentReporter\\IncidentReporter.DAL\\Repositories\\SafetyAlertsRepo.cs:line 513\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.SafetyAlertsBll.<GetSafetyAlertByIdAsync>d__10.MoveNext() in C:\\GitLab-Runner\\builds\\27n6lYj0J\\0\\incident-reporter\\incident-reporter-api\\IncidentReporter\\IncidentReporter.API\\BLL\\SafetyAlertsBll.cs:line 1016" }
{ "timestamp": "2026-05-13 09:30:01.5673", "level": "Error", "severity": "ERROR" }
{ "timestamp": "2026-05-13 09:30:02.8616", "level": "Error", "severity": "ERROR", "message": "Unknown column 'sa.resolved_on' in 'SELECT'", "stackTrace": "MySql.Data.MySqlClient.MySqlException (0x80004005): Unknown column 'sa.resolved_on' in 'SELECT'\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.<QueryRowAsync>d__34`1.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.SafetyAlertsRepo.<>c__DisplayClass15_0.<<GetSafetyAlertsDetailsByIdAsync>b__0>d.MoveNext() in C:\\GitLab-Runner\\builds\\27n6lYj0J\\0\\incident-reporter\\incident-reporter-api\\IncidentReporter\\IncidentReporter.DAL\\Repositories\\SafetyAlertsRepo.cs:line 515\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.BaseRepo.<ExecuteQueryAsync>d__7`1.MoveNext() in C:\\GitLab-Runner\\builds\\27n6lYj0J\\0\\incident-reporter\\incident-reporter-api\\IncidentReporter\\IncidentReporter.DAL\\Repositories\\BaseRepo.cs:line 0\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.SafetyAlertsRepo.<GetSafetyAlertsDetailsByIdAsync>d__15.MoveNext() in C:\\GitLab-Runner\\builds\\27n6lYj0J\\0\\incident-reporter\\incident-reporter-api\\IncidentReporter\\IncidentReporter.DAL\\Repositories\\SafetyAlertsRepo.cs:line 513\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.SafetyAlertsBll.<GetSafetyAlertByIdAsync>d__10.MoveNext() in C:\\GitLab-Runner\\builds\\27n6lYj0J\\0\\incident-reporter\\incident-reporter-api\\IncidentReporter\\IncidentReporter.API\\BLL\\SafetyAlertsBll.cs:line 1016" }
{ "timestamp": "2026-05-13 09:30:02.8616", "level": "Error", "severity": "ERROR" }
{ "timestamp": "2026-05-13 09:30:04.5424", "level": "Error", "severity": "ERROR", "message": "Unknown column 'sa.resolved_on' in 'SELECT'", "stackTrace": "MySql.Data.MySqlClient.MySqlException (0x80004005): Unknown column 'sa.resolved_on' in 'SELECT'\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.<QueryRowAsync>d__34`1.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.SafetyAlertsRepo.<>c__DisplayClass15_0.<<GetSafetyAlertsDetailsByIdAsync>b__0>d.MoveNext() in C:\\GitLab-Runner\\builds\\27n6lYj0J\\0\\incident-reporter\\incident-reporter-api\\IncidentReporter\\IncidentReporter.DAL\\Repositories\\SafetyAlertsRepo.cs:line 515\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.BaseRepo.<ExecuteQueryAsync>d__7`1.MoveNext() in C:\\GitLab-Runner\\builds\\27n6lYj0J\\0\\incident-reporter\\incident-reporter-api\\IncidentReporter\\IncidentReporter.DAL\\Repositories\\BaseRepo.cs:line 0\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.SafetyAlertsRepo.<GetSafetyAlertsDetailsByIdAsync>d__15.MoveNext() in C:\\GitLab-Runner\\builds\\27n6lYj0J\\0\\incident-reporter\\incident-reporter-api\\IncidentReporter\\IncidentReporter.DAL\\Repositories\\SafetyAlertsRepo.cs:line 513\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.SafetyAlertsBll.<GetSafetyAlertByIdAsync>d__10.MoveNext() in C:\\GitLab-Runner\\builds\\27n6lYj0J\\0\\incident-reporter\\incident-reporter-api\\IncidentReporter\\IncidentReporter.API\\BLL\\SafetyAlertsBll.cs:line 1016" }
{ "timestamp": "2026-05-13 09:30:04.5480", "level": "Error", "severity": "ERROR" }
{ "timestamp": "2026-05-13 09:30:10.1147", "level": "Error", "severity": "ERROR" }
{ "timestamp": "2026-05-13 09:30:10.6507", "level": "Error", "severity": "ERROR", "message": "Unknown column 'sa.resolved_on' in 'SELECT'", "stackTrace": "MySql.Data.MySqlClient.MySqlException (0x80004005): Unknown column 'sa.resolved_on' in 'SELECT'\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.<QueryRowAsync>d__34`1.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.SafetyAlertsRepo.<>c__DisplayClass15_0.<<GetSafetyAlertsDetailsByIdAsync>b__0>d.MoveNext() in C:\\GitLab-Runner\\builds\\27n6lYj0J\\0\\incident-reporter\\incident-reporter-api\\IncidentReporter\\IncidentReporter.DAL\\Repositories\\SafetyAlertsRepo.cs:line 515\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.BaseRepo.<ExecuteQueryAsync>d__7`1.MoveNext() in C:\\GitLab-Runner\\builds\\27n6lYj0J\\0\\incident-reporter\\incident-reporter-api\\IncidentReporter\\IncidentReporter.DAL\\Repositories\\BaseRepo.cs:line 0\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.SafetyAlertsRepo.<GetSafetyAlertsDetailsByIdAsync>d__15.MoveNext() in C:\\GitLab-Runner\\builds\\27n6lYj0J\\0\\incident-reporter\\incident-reporter-api\\IncidentReporter\\IncidentReporter.DAL\\Repositories\\SafetyAlertsRepo.cs:line 513\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.SafetyAlertsBll.<GetSafetyAlertByIdAsync>d__10.MoveNext() in C:\\GitLab-Runner\\builds\\27n6lYj0J\\0\\incident-reporter\\incident-reporter-api\\IncidentReporter\\IncidentReporter.API\\BLL\\SafetyAlertsBll.cs:line 1016" }
{ "timestamp": "2026-05-13 09:30:10.6507", "level": "Error", "severity": "ERROR" }
{ "timestamp": "2026-05-13 09:30:37.6131", "level": "Error", "severity": "ERROR" }
{ "timestamp": "2026-05-13 09:30:37.6944", "level": "Error", "severity": "ERROR" }
{ "timestamp": "2026-05-13 09:30:45.2078", "level": "Error", "severity": "ERROR" }
{ "timestamp": "2026-05-13 09:30:55.7535", "level": "Error", "severity": "ERROR", "message": "Cannot delete or update a parent row: a foreign key constraint fails (`qa_stg_oqsha_4`.`entity_tasks`, CONSTRAINT `fk_entity_tasks_task_id` FOREIGN KEY (`task_id`) REFERENCES `tasks` (`id`))", "stackTrace": "MySql.Data.MySqlClient.MySqlException (0x80004005): Cannot delete or update a parent row: a foreign key constraint fails (`qa_stg_oqsha_4`.`entity_tasks`, CONSTRAINT `fk_entity_tasks_task_id` FOREIGN KEY (`task_id`) REFERENCES `tasks` (`id`))\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 MySql.Data.MySqlClient.MySqlCommand.ExecuteNonQuery()\r\n   at Dapper.SqlMapper.ExecuteCommand(IDbConnection cnn, CommandDefinition& command, Action`2 paramReader)\r\n   at Dapper.SqlMapper.ExecuteImpl(IDbConnection cnn, CommandDefinition& command)\r\n   at Dapper.SqlMapper.Execute(IDbConnection cnn, String sql, Object param, IDbTransaction transaction, Nullable`1 commandTimeout, Nullable`1 commandType)\r\n   at IncidentReporter.DAL.Repositories.TaskRepo.HardDeleteTaskById(Int32 taskId, Int32 organisationId) in C:\\GitLab-Runner\\builds\\27n6lYj0J\\0\\incident-reporter\\incident-reporter-api\\IncidentReporter\\IncidentReporter.DAL\\Repositories\\TaskRepo.cs:line 160\r\n   at IncidentReporter.API.BLL.TaskBLL.<DeleteTaskAsync>d__75.MoveNext() in C:\\GitLab-Runner\\builds\\27n6lYj0J\\0\\incident-reporter\\incident-reporter-api\\IncidentReporter\\IncidentReporter.API\\BLL\\TaskBLL.cs:line 5814" }
{ "timestamp": "2026-05-13 09:30:55.7535", "level": "Error", "severity": "ERROR" }
{ "timestamp": "2026-05-13 09:30:59.7706", "level": "Error", "severity": "ERROR", "message": "Unknown column 'sa.resolved_on' in 'SELECT'", "stackTrace": "MySql.Data.MySqlClient.MySqlException (0x80004005): Unknown column 'sa.resolved_on' in 'SELECT'\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.<QueryRowAsync>d__34`1.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.SafetyAlertsRepo.<>c__DisplayClass15_0.<<GetSafetyAlertsDetailsByIdAsync>b__0>d.MoveNext() in C:\\GitLab-Runner\\builds\\27n6lYj0J\\0\\incident-reporter\\incident-reporter-api\\IncidentReporter\\IncidentReporter.DAL\\Repositories\\SafetyAlertsRepo.cs:line 515\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.BaseRepo.<ExecuteQueryAsync>d__7`1.MoveNext() in C:\\GitLab-Runner\\builds\\27n6lYj0J\\0\\incident-reporter\\incident-reporter-api\\IncidentReporter\\IncidentReporter.DAL\\Repositories\\BaseRepo.cs:line 0\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.SafetyAlertsRepo.<GetSafetyAlertsDetailsByIdAsync>d__15.MoveNext() in C:\\GitLab-Runner\\builds\\27n6lYj0J\\0\\incident-reporter\\incident-reporter-api\\IncidentReporter\\IncidentReporter.DAL\\Repositories\\SafetyAlertsRepo.cs:line 513\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.SafetyAlertsBll.<GetSafetyAlertByIdAsync>d__10.MoveNext() in C:\\GitLab-Runner\\builds\\27n6lYj0J\\0\\incident-reporter\\incident-reporter-api\\IncidentReporter\\IncidentReporter.API\\BLL\\SafetyAlertsBll.cs:line 1016" }
{ "timestamp": "2026-05-13 09:30:59.7706", "level": "Error", "severity": "ERROR" }
{ "timestamp": "2026-05-13 09:33:22.9095", "level": "Error", "severity": "ERROR" }
{ "timestamp": "2026-05-13 09:35:32.0642", "level": "Error", "severity": "ERROR" }
{ "timestamp": "2026-05-13 09:37:35.7067", "level": "Error", "severity": "ERROR", "message": "Cannot delete or update a parent row: a foreign key constraint fails (`qa_stg_oqsha_4`.`entity_tasks`, CONSTRAINT `fk_entity_tasks_task_id` FOREIGN KEY (`task_id`) REFERENCES `tasks` (`id`))", "stackTrace": "MySql.Data.MySqlClient.MySqlException (0x80004005): Cannot delete or update a parent row: a foreign key constraint fails (`qa_stg_oqsha_4`.`entity_tasks`, CONSTRAINT `fk_entity_tasks_task_id` FOREIGN KEY (`task_id`) REFERENCES `tasks` (`id`))\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 MySql.Data.MySqlClient.MySqlCommand.ExecuteNonQuery()\r\n   at Dapper.SqlMapper.ExecuteCommand(IDbConnection cnn, CommandDefinition& command, Action`2 paramReader)\r\n   at Dapper.SqlMapper.ExecuteImpl(IDbConnection cnn, CommandDefinition& command)\r\n   at Dapper.SqlMapper.Execute(IDbConnection cnn, String sql, Object param, IDbTransaction transaction, Nullable`1 commandTimeout, Nullable`1 commandType)\r\n   at IncidentReporter.DAL.Repositories.TaskRepo.HardDeleteTaskById(Int32 taskId, Int32 organisationId) in C:\\GitLab-Runner\\builds\\27n6lYj0J\\0\\incident-reporter\\incident-reporter-api\\IncidentReporter\\IncidentReporter.DAL\\Repositories\\TaskRepo.cs:line 160\r\n   at IncidentReporter.API.BLL.TaskBLL.<DeleteTaskAsync>d__75.MoveNext() in C:\\GitLab-Runner\\builds\\27n6lYj0J\\0\\incident-reporter\\incident-reporter-api\\IncidentReporter\\IncidentReporter.API\\BLL\\TaskBLL.cs:line 5814" }
{ "timestamp": "2026-05-13 09:37:35.7125", "level": "Error", "severity": "ERROR" }
{ "timestamp": "2026-05-13 09:37:59.4059", "level": "Error", "severity": "ERROR" }
{ "timestamp": "2026-05-13 09:37:59.5173", "level": "Error", "severity": "ERROR" }
{ "timestamp": "2026-05-13 09:38:13.9436", "level": "Error", "severity": "ERROR" }
{ "timestamp": "2026-05-13 09:47:40.2350", "level": "Error", "severity": "ERROR" }
{ "timestamp": "2026-05-13 09:48:12.0946", "level": "Error", "severity": "ERROR" }
{ "timestamp": "2026-05-13 09:48:21.0920", "level": "Error", "severity": "ERROR" }
{ "timestamp": "2026-05-13 09:48:55.6998", "level": "Error", "severity": "ERROR", "message": "Cannot delete or update a parent row: a foreign key constraint fails (`qa_stg_oqsha_4`.`entity_tasks`, CONSTRAINT `fk_entity_tasks_task_id` FOREIGN KEY (`task_id`) REFERENCES `tasks` (`id`))", "stackTrace": "MySql.Data.MySqlClient.MySqlException (0x80004005): Cannot delete or update a parent row: a foreign key constraint fails (`qa_stg_oqsha_4`.`entity_tasks`, CONSTRAINT `fk_entity_tasks_task_id` FOREIGN KEY (`task_id`) REFERENCES `tasks` (`id`))\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 MySql.Data.MySqlClient.MySqlCommand.ExecuteNonQuery()\r\n   at Dapper.SqlMapper.ExecuteCommand(IDbConnection cnn, CommandDefinition& command, Action`2 paramReader)\r\n   at Dapper.SqlMapper.ExecuteImpl(IDbConnection cnn, CommandDefinition& command)\r\n   at Dapper.SqlMapper.Execute(IDbConnection cnn, String sql, Object param, IDbTransaction transaction, Nullable`1 commandTimeout, Nullable`1 commandType)\r\n   at IncidentReporter.DAL.Repositories.TaskRepo.HardDeleteTaskById(Int32 taskId, Int32 organisationId) in C:\\GitLab-Runner\\builds\\27n6lYj0J\\0\\incident-reporter\\incident-reporter-api\\IncidentReporter\\IncidentReporter.DAL\\Repositories\\TaskRepo.cs:line 160\r\n   at IncidentReporter.API.BLL.TaskBLL.<DeleteTaskAsync>d__75.MoveNext() in C:\\GitLab-Runner\\builds\\27n6lYj0J\\0\\incident-reporter\\incident-reporter-api\\IncidentReporter\\IncidentReporter.API\\BLL\\TaskBLL.cs:line 5814" }
{ "timestamp": "2026-05-13 09:48:55.6998", "level": "Error", "severity": "ERROR" }
{ "timestamp": "2026-05-13 09:51:49.2241", "level": "Error", "severity": "ERROR" }
{ "timestamp": "2026-05-13 09:51:49.2826", "level": "Error", "severity": "ERROR" }
{ "timestamp": "2026-05-13 09:52:00.2353", "level": "Error", "severity": "ERROR" }
{ "timestamp": "2026-05-13 09:52:00.3533", "level": "Error", "severity": "ERROR" }
{ "timestamp": "2026-05-13 09:52:09.4112", "level": "Error", "severity": "ERROR" }
{ "timestamp": "2026-05-13 09:52:09.6944", "level": "Error", "severity": "ERROR" }
{ "timestamp": "2026-05-13 09:52:09.9567", "level": "Error", "severity": "ERROR" }
{ "timestamp": "2026-05-13 09:52:10.8265", "level": "Error", "severity": "ERROR" }
{ "timestamp": "2026-05-13 09:52:10.9141", "level": "Error", "severity": "ERROR" }
{ "timestamp": "2026-05-13 09:57:57.8439", "level": "Error", "severity": "ERROR" }
{ "timestamp": "2026-05-13 09:58:17.3010", "level": "Error", "severity": "ERROR" }
{ "timestamp": "2026-05-13 09:59:23.2357", "level": "Error", "severity": "ERROR" }
{ "timestamp": "2026-05-13 10:00:06.3440", "level": "Error", "severity": "ERROR" }
{ "timestamp": "2026-05-13 10:00:16.7197", "level": "Error", "severity": "ERROR" }
{ "timestamp": "2026-05-13 10:00:34.4415", "level": "Error", "severity": "ERROR" }
{ "timestamp": "2026-05-13 10:00:40.1652", "level": "Error", "severity": "ERROR" }
{ "timestamp": "2026-05-13 10:00:40.7922", "level": "Error", "severity": "ERROR", "message": "Cannot delete or update a parent row: a foreign key constraint fails (`qa_stg_oqsha_4`.`entity_tasks`, CONSTRAINT `fk_entity_tasks_task_id` FOREIGN KEY (`task_id`) REFERENCES `tasks` (`id`))", "stackTrace": "MySql.Data.MySqlClient.MySqlException (0x80004005): Cannot delete or update a parent row: a foreign key constraint fails (`qa_stg_oqsha_4`.`entity_tasks`, CONSTRAINT `fk_entity_tasks_task_id` FOREIGN KEY (`task_id`) REFERENCES `tasks` (`id`))\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 MySql.Data.MySqlClient.MySqlCommand.ExecuteNonQuery()\r\n   at Dapper.SqlMapper.ExecuteCommand(IDbConnection cnn, CommandDefinition& command, Action`2 paramReader)\r\n   at Dapper.SqlMapper.ExecuteImpl(IDbConnection cnn, CommandDefinition& command)\r\n   at Dapper.SqlMapper.Execute(IDbConnection cnn, String sql, Object param, IDbTransaction transaction, Nullable`1 commandTimeout, Nullable`1 commandType)\r\n   at IncidentReporter.DAL.Repositories.TaskRepo.HardDeleteTaskById(Int32 taskId, Int32 organisationId) in C:\\GitLab-Runner\\builds\\27n6lYj0J\\0\\incident-reporter\\incident-reporter-api\\IncidentReporter\\IncidentReporter.DAL\\Repositories\\TaskRepo.cs:line 160\r\n   at IncidentReporter.API.BLL.TaskBLL.<DeleteTaskAsync>d__75.MoveNext() in C:\\GitLab-Runner\\builds\\27n6lYj0J\\0\\incident-reporter\\incident-reporter-api\\IncidentReporter\\IncidentReporter.API\\BLL\\TaskBLL.cs:line 5814" }
{ "timestamp": "2026-05-13 10:00:40.8553", "level": "Error", "severity": "ERROR" }
{ "timestamp": "2026-05-13 10:01:07.5845", "level": "Error", "severity": "ERROR" }
{ "timestamp": "2026-05-13 10:01:14.3723", "level": "Error", "severity": "ERROR", "message": "Cannot delete or update a parent row: a foreign key constraint fails (`qa_stg_oqsha_4`.`entity_tasks`, CONSTRAINT `fk_entity_tasks_task_id` FOREIGN KEY (`task_id`) REFERENCES `tasks` (`id`))", "stackTrace": "MySql.Data.MySqlClient.MySqlException (0x80004005): Cannot delete or update a parent row: a foreign key constraint fails (`qa_stg_oqsha_4`.`entity_tasks`, CONSTRAINT `fk_entity_tasks_task_id` FOREIGN KEY (`task_id`) REFERENCES `tasks` (`id`))\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 MySql.Data.MySqlClient.MySqlCommand.ExecuteNonQuery()\r\n   at Dapper.SqlMapper.ExecuteCommand(IDbConnection cnn, CommandDefinition& command, Action`2 paramReader)\r\n   at Dapper.SqlMapper.ExecuteImpl(IDbConnection cnn, CommandDefinition& command)\r\n   at Dapper.SqlMapper.Execute(IDbConnection cnn, String sql, Object param, IDbTransaction transaction, Nullable`1 commandTimeout, Nullable`1 commandType)\r\n   at IncidentReporter.DAL.Repositories.TaskRepo.HardDeleteTaskById(Int32 taskId, Int32 organisationId) in C:\\GitLab-Runner\\builds\\27n6lYj0J\\0\\incident-reporter\\incident-reporter-api\\IncidentReporter\\IncidentReporter.DAL\\Repositories\\TaskRepo.cs:line 160\r\n   at IncidentReporter.API.BLL.TaskBLL.<DeleteTaskAsync>d__75.MoveNext() in C:\\GitLab-Runner\\builds\\27n6lYj0J\\0\\incident-reporter\\incident-reporter-api\\IncidentReporter\\IncidentReporter.API\\BLL\\TaskBLL.cs:line 5814" }
{ "timestamp": "2026-05-13 10:01:14.3723", "level": "Error", "severity": "ERROR" }
{ "timestamp": "2026-05-13 10:04:42.5083", "level": "Error", "severity": "ERROR", "message": "Cannot delete or update a parent row: a foreign key constraint fails (`qa_stg_oqsha_4`.`entity_tasks`, CONSTRAINT `fk_entity_tasks_task_id` FOREIGN KEY (`task_id`) REFERENCES `tasks` (`id`))", "stackTrace": "MySql.Data.MySqlClient.MySqlException (0x80004005): Cannot delete or update a parent row: a foreign key constraint fails (`qa_stg_oqsha_4`.`entity_tasks`, CONSTRAINT `fk_entity_tasks_task_id` FOREIGN KEY (`task_id`) REFERENCES `tasks` (`id`))\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 MySql.Data.MySqlClient.MySqlCommand.ExecuteNonQuery()\r\n   at Dapper.SqlMapper.ExecuteCommand(IDbConnection cnn, CommandDefinition& command, Action`2 paramReader)\r\n   at Dapper.SqlMapper.ExecuteImpl(IDbConnection cnn, CommandDefinition& command)\r\n   at Dapper.SqlMapper.Execute(IDbConnection cnn, String sql, Object param, IDbTransaction transaction, Nullable`1 commandTimeout, Nullable`1 commandType)\r\n   at IncidentReporter.DAL.Repositories.TaskRepo.HardDeleteTaskById(Int32 taskId, Int32 organisationId) in C:\\GitLab-Runner\\builds\\27n6lYj0J\\0\\incident-reporter\\incident-reporter-api\\IncidentReporter\\IncidentReporter.DAL\\Repositories\\TaskRepo.cs:line 160\r\n   at IncidentReporter.API.BLL.TaskBLL.<DeleteTaskAsync>d__75.MoveNext() in C:\\GitLab-Runner\\builds\\27n6lYj0J\\0\\incident-reporter\\incident-reporter-api\\IncidentReporter\\IncidentReporter.API\\BLL\\TaskBLL.cs:line 5814" }
{ "timestamp": "2026-05-13 10:04:42.5083", "level": "Error", "severity": "ERROR" }
{ "timestamp": "2026-05-13 10:05:25.3587", "level": "Error", "severity": "ERROR", "message": "Cannot delete or update a parent row: a foreign key constraint fails (`qa_stg_oqsha_4`.`entity_tasks`, CONSTRAINT `fk_entity_tasks_task_id` FOREIGN KEY (`task_id`) REFERENCES `tasks` (`id`))", "stackTrace": "MySql.Data.MySqlClient.MySqlException (0x80004005): Cannot delete or update a parent row: a foreign key constraint fails (`qa_stg_oqsha_4`.`entity_tasks`, CONSTRAINT `fk_entity_tasks_task_id` FOREIGN KEY (`task_id`) REFERENCES `tasks` (`id`))\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 MySql.Data.MySqlClient.MySqlCommand.ExecuteNonQuery()\r\n   at Dapper.SqlMapper.ExecuteCommand(IDbConnection cnn, CommandDefinition& command, Action`2 paramReader)\r\n   at Dapper.SqlMapper.ExecuteImpl(IDbConnection cnn, CommandDefinition& command)\r\n   at Dapper.SqlMapper.Execute(IDbConnection cnn, String sql, Object param, IDbTransaction transaction, Nullable`1 commandTimeout, Nullable`1 commandType)\r\n   at IncidentReporter.DAL.Repositories.TaskRepo.HardDeleteTaskById(Int32 taskId, Int32 organisationId) in C:\\GitLab-Runner\\builds\\27n6lYj0J\\0\\incident-reporter\\incident-reporter-api\\IncidentReporter\\IncidentReporter.DAL\\Repositories\\TaskRepo.cs:line 160\r\n   at IncidentReporter.API.BLL.TaskBLL.<DeleteTaskAsync>d__75.MoveNext() in C:\\GitLab-Runner\\builds\\27n6lYj0J\\0\\incident-reporter\\incident-reporter-api\\IncidentReporter\\IncidentReporter.API\\BLL\\TaskBLL.cs:line 5814" }
{ "timestamp": "2026-05-13 10:05:25.3587", "level": "Error", "severity": "ERROR" }
{ "timestamp": "2026-05-13 10:07:00.9980", "level": "Error", "severity": "ERROR", "message": "Cannot delete or update a parent row: a foreign key constraint fails (`qa_stg_oqsha_4`.`entity_tasks`, CONSTRAINT `fk_entity_tasks_task_id` FOREIGN KEY (`task_id`) REFERENCES `tasks` (`id`))", "stackTrace": "MySql.Data.MySqlClient.MySqlException (0x80004005): Cannot delete or update a parent row: a foreign key constraint fails (`qa_stg_oqsha_4`.`entity_tasks`, CONSTRAINT `fk_entity_tasks_task_id` FOREIGN KEY (`task_id`) REFERENCES `tasks` (`id`))\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 MySql.Data.MySqlClient.MySqlCommand.ExecuteNonQuery()\r\n   at Dapper.SqlMapper.ExecuteCommand(IDbConnection cnn, CommandDefinition& command, Action`2 paramReader)\r\n   at Dapper.SqlMapper.ExecuteImpl(IDbConnection cnn, CommandDefinition& command)\r\n   at Dapper.SqlMapper.Execute(IDbConnection cnn, String sql, Object param, IDbTransaction transaction, Nullable`1 commandTimeout, Nullable`1 commandType)\r\n   at IncidentReporter.DAL.Repositories.TaskRepo.HardDeleteTaskById(Int32 taskId, Int32 organisationId) in C:\\GitLab-Runner\\builds\\27n6lYj0J\\0\\incident-reporter\\incident-reporter-api\\IncidentReporter\\IncidentReporter.DAL\\Repositories\\TaskRepo.cs:line 160\r\n   at IncidentReporter.API.BLL.TaskBLL.<DeleteTaskAsync>d__75.MoveNext() in C:\\GitLab-Runner\\builds\\27n6lYj0J\\0\\incident-reporter\\incident-reporter-api\\IncidentReporter\\IncidentReporter.API\\BLL\\TaskBLL.cs:line 5814" }
{ "timestamp": "2026-05-13 10:07:01.0160", "level": "Error", "severity": "ERROR" }
{ "timestamp": "2026-05-13 10:08:02.9110", "level": "Error", "severity": "ERROR", "message": "Unknown column 'sa.resolved_on' in 'SELECT'", "stackTrace": "MySql.Data.MySqlClient.MySqlException (0x80004005): Unknown column 'sa.resolved_on' in 'SELECT'\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.<QueryRowAsync>d__34`1.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.SafetyAlertsRepo.<>c__DisplayClass15_0.<<GetSafetyAlertsDetailsByIdAsync>b__0>d.MoveNext() in C:\\GitLab-Runner\\builds\\27n6lYj0J\\0\\incident-reporter\\incident-reporter-api\\IncidentReporter\\IncidentReporter.DAL\\Repositories\\SafetyAlertsRepo.cs:line 515\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.BaseRepo.<ExecuteQueryAsync>d__7`1.MoveNext() in C:\\GitLab-Runner\\builds\\27n6lYj0J\\0\\incident-reporter\\incident-reporter-api\\IncidentReporter\\IncidentReporter.DAL\\Repositories\\BaseRepo.cs:line 0\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.SafetyAlertsRepo.<GetSafetyAlertsDetailsByIdAsync>d__15.MoveNext() in C:\\GitLab-Runner\\builds\\27n6lYj0J\\0\\incident-reporter\\incident-reporter-api\\IncidentReporter\\IncidentReporter.DAL\\Repositories\\SafetyAlertsRepo.cs:line 513\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.SafetyAlertsBll.<GetSafetyAlertByIdAsync>d__10.MoveNext() in C:\\GitLab-Runner\\builds\\27n6lYj0J\\0\\incident-reporter\\incident-reporter-api\\IncidentReporter\\IncidentReporter.API\\BLL\\SafetyAlertsBll.cs:line 1016" }
{ "timestamp": "2026-05-13 10:08:02.9119", "level": "Error", "severity": "ERROR" }
{ "timestamp": "2026-05-13 10:09:02.2831", "level": "Error", "severity": "ERROR", "message": "Cannot delete or update a parent row: a foreign key constraint fails (`qa_stg_oqsha_4`.`entity_tasks`, CONSTRAINT `fk_entity_tasks_task_id` FOREIGN KEY (`task_id`) REFERENCES `tasks` (`id`))", "stackTrace": "MySql.Data.MySqlClient.MySqlException (0x80004005): Cannot delete or update a parent row: a foreign key constraint fails (`qa_stg_oqsha_4`.`entity_tasks`, CONSTRAINT `fk_entity_tasks_task_id` FOREIGN KEY (`task_id`) REFERENCES `tasks` (`id`))\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 MySql.Data.MySqlClient.MySqlCommand.ExecuteNonQuery()\r\n   at Dapper.SqlMapper.ExecuteCommand(IDbConnection cnn, CommandDefinition& command, Action`2 paramReader)\r\n   at Dapper.SqlMapper.ExecuteImpl(IDbConnection cnn, CommandDefinition& command)\r\n   at Dapper.SqlMapper.Execute(IDbConnection cnn, String sql, Object param, IDbTransaction transaction, Nullable`1 commandTimeout, Nullable`1 commandType)\r\n   at IncidentReporter.DAL.Repositories.TaskRepo.HardDeleteTaskById(Int32 taskId, Int32 organisationId) in C:\\GitLab-Runner\\builds\\27n6lYj0J\\0\\incident-reporter\\incident-reporter-api\\IncidentReporter\\IncidentReporter.DAL\\Repositories\\TaskRepo.cs:line 160\r\n   at IncidentReporter.API.BLL.TaskBLL.<DeleteTaskAsync>d__75.MoveNext() in C:\\GitLab-Runner\\builds\\27n6lYj0J\\0\\incident-reporter\\incident-reporter-api\\IncidentReporter\\IncidentReporter.API\\BLL\\TaskBLL.cs:line 5814" }
{ "timestamp": "2026-05-13 10:09:02.2938", "level": "Error", "severity": "ERROR" }
{ "timestamp": "2026-05-13 10:09:47.7757", "level": "Error", "severity": "ERROR", "message": "Cannot delete or update a parent row: a foreign key constraint fails (`qa_stg_oqsha_4`.`entity_tasks`, CONSTRAINT `fk_entity_tasks_task_id` FOREIGN KEY (`task_id`) REFERENCES `tasks` (`id`))", "stackTrace": "MySql.Data.MySqlClient.MySqlException (0x80004005): Cannot delete or update a parent row: a foreign key constraint fails (`qa_stg_oqsha_4`.`entity_tasks`, CONSTRAINT `fk_entity_tasks_task_id` FOREIGN KEY (`task_id`) REFERENCES `tasks` (`id`))\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 MySql.Data.MySqlClient.MySqlCommand.ExecuteNonQuery()\r\n   at Dapper.SqlMapper.ExecuteCommand(IDbConnection cnn, CommandDefinition& command, Action`2 paramReader)\r\n   at Dapper.SqlMapper.ExecuteImpl(IDbConnection cnn, CommandDefinition& command)\r\n   at Dapper.SqlMapper.Execute(IDbConnection cnn, String sql, Object param, IDbTransaction transaction, Nullable`1 commandTimeout, Nullable`1 commandType)\r\n   at IncidentReporter.DAL.Repositories.TaskRepo.HardDeleteTaskById(Int32 taskId, Int32 organisationId) in C:\\GitLab-Runner\\builds\\27n6lYj0J\\0\\incident-reporter\\incident-reporter-api\\IncidentReporter\\IncidentReporter.DAL\\Repositories\\TaskRepo.cs:line 160\r\n   at IncidentReporter.API.BLL.TaskBLL.<DeleteTaskAsync>d__75.MoveNext() in C:\\GitLab-Runner\\builds\\27n6lYj0J\\0\\incident-reporter\\incident-reporter-api\\IncidentReporter\\IncidentReporter.API\\BLL\\TaskBLL.cs:line 5814" }
{ "timestamp": "2026-05-13 10:09:47.7757", "level": "Error", "severity": "ERROR" }
{ "timestamp": "2026-05-13 10:10:23.6376", "level": "Error", "severity": "ERROR", "message": "Cannot delete or update a parent row: a foreign key constraint fails (`qa_stg_oqsha_4`.`entity_tasks`, CONSTRAINT `fk_entity_tasks_task_id` FOREIGN KEY (`task_id`) REFERENCES `tasks` (`id`))", "stackTrace": "MySql.Data.MySqlClient.MySqlException (0x80004005): Cannot delete or update a parent row: a foreign key constraint fails (`qa_stg_oqsha_4`.`entity_tasks`, CONSTRAINT `fk_entity_tasks_task_id` FOREIGN KEY (`task_id`) REFERENCES `tasks` (`id`))\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 MySql.Data.MySqlClient.MySqlCommand.ExecuteNonQuery()\r\n   at Dapper.SqlMapper.ExecuteCommand(IDbConnection cnn, CommandDefinition& command, Action`2 paramReader)\r\n   at Dapper.SqlMapper.ExecuteImpl(IDbConnection cnn, CommandDefinition& command)\r\n   at Dapper.SqlMapper.Execute(IDbConnection cnn, String sql, Object param, IDbTransaction transaction, Nullable`1 commandTimeout, Nullable`1 commandType)\r\n   at IncidentReporter.DAL.Repositories.TaskRepo.HardDeleteTaskById(Int32 taskId, Int32 organisationId) in C:\\GitLab-Runner\\builds\\27n6lYj0J\\0\\incident-reporter\\incident-reporter-api\\IncidentReporter\\IncidentReporter.DAL\\Repositories\\TaskRepo.cs:line 160\r\n   at IncidentReporter.API.BLL.TaskBLL.<DeleteTaskAsync>d__75.MoveNext() in C:\\GitLab-Runner\\builds\\27n6lYj0J\\0\\incident-reporter\\incident-reporter-api\\IncidentReporter\\IncidentReporter.API\\BLL\\TaskBLL.cs:line 5814" }
{ "timestamp": "2026-05-13 10:10:23.6376", "level": "Error", "severity": "ERROR" }
{ "timestamp": "2026-05-13 10:12:04.9508", "level": "Error", "severity": "ERROR", "message": "Cannot delete or update a parent row: a foreign key constraint fails (`qa_stg_oqsha_4`.`entity_tasks`, CONSTRAINT `fk_entity_tasks_task_id` FOREIGN KEY (`task_id`) REFERENCES `tasks` (`id`))", "stackTrace": "MySql.Data.MySqlClient.MySqlException (0x80004005): Cannot delete or update a parent row: a foreign key constraint fails (`qa_stg_oqsha_4`.`entity_tasks`, CONSTRAINT `fk_entity_tasks_task_id` FOREIGN KEY (`task_id`) REFERENCES `tasks` (`id`))\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 MySql.Data.MySqlClient.MySqlCommand.ExecuteNonQuery()\r\n   at Dapper.SqlMapper.ExecuteCommand(IDbConnection cnn, CommandDefinition& command, Action`2 paramReader)\r\n   at Dapper.SqlMapper.ExecuteImpl(IDbConnection cnn, CommandDefinition& command)\r\n   at Dapper.SqlMapper.Execute(IDbConnection cnn, String sql, Object param, IDbTransaction transaction, Nullable`1 commandTimeout, Nullable`1 commandType)\r\n   at IncidentReporter.DAL.Repositories.TaskRepo.HardDeleteTaskById(Int32 taskId, Int32 organisationId) in C:\\GitLab-Runner\\builds\\27n6lYj0J\\0\\incident-reporter\\incident-reporter-api\\IncidentReporter\\IncidentReporter.DAL\\Repositories\\TaskRepo.cs:line 160\r\n   at IncidentReporter.API.BLL.TaskBLL.<DeleteTaskAsync>d__75.MoveNext() in C:\\GitLab-Runner\\builds\\27n6lYj0J\\0\\incident-reporter\\incident-reporter-api\\IncidentReporter\\IncidentReporter.API\\BLL\\TaskBLL.cs:line 5814" }
{ "timestamp": "2026-05-13 10:12:04.9542", "level": "Error", "severity": "ERROR" }
{ "timestamp": "2026-05-13 10:12:52.5243", "level": "Error", "severity": "ERROR" }
{ "timestamp": "2026-05-13 10:12:52.6516", "level": "Error", "severity": "ERROR" }
{ "timestamp": "2026-05-13 10:12:58.0169", "level": "Error", "severity": "ERROR", "message": "Cannot delete or update a parent row: a foreign key constraint fails (`qa_stg_oqsha_4`.`entity_tasks`, CONSTRAINT `fk_entity_tasks_task_id` FOREIGN KEY (`task_id`) REFERENCES `tasks` (`id`))", "stackTrace": "MySql.Data.MySqlClient.MySqlException (0x80004005): Cannot delete or update a parent row: a foreign key constraint fails (`qa_stg_oqsha_4`.`entity_tasks`, CONSTRAINT `fk_entity_tasks_task_id` FOREIGN KEY (`task_id`) REFERENCES `tasks` (`id`))\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 MySql.Data.MySqlClient.MySqlCommand.ExecuteNonQuery()\r\n   at Dapper.SqlMapper.ExecuteCommand(IDbConnection cnn, CommandDefinition& command, Action`2 paramReader)\r\n   at Dapper.SqlMapper.ExecuteImpl(IDbConnection cnn, CommandDefinition& command)\r\n   at Dapper.SqlMapper.Execute(IDbConnection cnn, String sql, Object param, IDbTransaction transaction, Nullable`1 commandTimeout, Nullable`1 commandType)\r\n   at IncidentReporter.DAL.Repositories.TaskRepo.HardDeleteTaskById(Int32 taskId, Int32 organisationId) in C:\\GitLab-Runner\\builds\\27n6lYj0J\\0\\incident-reporter\\incident-reporter-api\\IncidentReporter\\IncidentReporter.DAL\\Repositories\\TaskRepo.cs:line 160\r\n   at IncidentReporter.API.BLL.TaskBLL.<DeleteTaskAsync>d__75.MoveNext() in C:\\GitLab-Runner\\builds\\27n6lYj0J\\0\\incident-reporter\\incident-reporter-api\\IncidentReporter\\IncidentReporter.API\\BLL\\TaskBLL.cs:line 5814" }
{ "timestamp": "2026-05-13 10:12:58.0169", "level": "Error", "severity": "ERROR" }
{ "timestamp": "2026-05-13 10:28:55.3063", "level": "Error", "severity": "ERROR" }
{ "timestamp": "2026-05-13 10:29:03.9868", "level": "Error", "severity": "ERROR" }
{ "timestamp": "2026-05-13 11:02:53.6835", "level": "Error", "severity": "ERROR", "message": "Cannot delete or update a parent row: a foreign key constraint fails (`qa_stg_oqsha_4`.`entity_tasks`, CONSTRAINT `fk_entity_tasks_task_id` FOREIGN KEY (`task_id`) REFERENCES `tasks` (`id`))", "stackTrace": "MySql.Data.MySqlClient.MySqlException (0x80004005): Cannot delete or update a parent row: a foreign key constraint fails (`qa_stg_oqsha_4`.`entity_tasks`, CONSTRAINT `fk_entity_tasks_task_id` FOREIGN KEY (`task_id`) REFERENCES `tasks` (`id`))\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 MySql.Data.MySqlClient.MySqlCommand.ExecuteNonQuery()\r\n   at Dapper.SqlMapper.ExecuteCommand(IDbConnection cnn, CommandDefinition& command, Action`2 paramReader)\r\n   at Dapper.SqlMapper.ExecuteImpl(IDbConnection cnn, CommandDefinition& command)\r\n   at Dapper.SqlMapper.Execute(IDbConnection cnn, String sql, Object param, IDbTransaction transaction, Nullable`1 commandTimeout, Nullable`1 commandType)\r\n   at IncidentReporter.DAL.Repositories.TaskRepo.HardDeleteTaskById(Int32 taskId, Int32 organisationId) in C:\\GitLab-Runner\\builds\\27n6lYj0J\\0\\incident-reporter\\incident-reporter-api\\IncidentReporter\\IncidentReporter.DAL\\Repositories\\TaskRepo.cs:line 160\r\n   at IncidentReporter.API.BLL.TaskBLL.<DeleteTaskAsync>d__75.MoveNext() in C:\\GitLab-Runner\\builds\\27n6lYj0J\\0\\incident-reporter\\incident-reporter-api\\IncidentReporter\\IncidentReporter.API\\BLL\\TaskBLL.cs:line 5814" }
{ "timestamp": "2026-05-13 11:02:53.7563", "level": "Error", "severity": "ERROR" }
{ "timestamp": "2026-05-13 11:14:25.6801", "level": "Error", "severity": "ERROR" }
{ "timestamp": "2026-05-13 11:40:35.8260", "level": "Error", "severity": "ERROR", "message": "A potentially dangerous Request.Path value was detected from the client (:).", "stackTrace": "System.Web.HttpException (0x80004005): A potentially dangerous Request.Path value was detected from the client (:).\r\n   at System.Web.HttpRequest.ValidateInputIfRequiredByConfig()\r\n   at System.Web.HttpApplication.PipelineStepManager.ValidateHelper(HttpContext context)" }
{ "timestamp": "2026-05-13 12:17:16.2577", "level": "Error", "severity": "ERROR", "message": "An unexpected error occurred.", "stackTrace": "System.Exception: An unexpected error occurred.\r\n   at IncidentReporter.API.BLL.IotDevicesBLL.<GetUnassociatedIotDeviceById>d__26.MoveNext() in C:\\GitLab-Runner\\builds\\27n6lYj0J\\0\\incident-reporter\\incident-reporter-api\\IncidentReporter\\IncidentReporter.API\\BLL\\IotDevicesBLL.cs:line 1299" }
{ "timestamp": "2026-05-13 12:17:16.2577", "level": "Error", "severity": "ERROR" }
{ "timestamp": "2026-05-13 12:27:13.6398", "level": "Error", "severity": "ERROR" }
{ "timestamp": "2026-05-13 12:29:29.3211", "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-05-13 12:30:38.4498", "level": "Error", "severity": "ERROR" }
{ "timestamp": "2026-05-13 12:30:38.6108", "level": "Error", "severity": "ERROR" }
{ "timestamp": "2026-05-13 12:30:39.5090", "level": "Error", "severity": "ERROR" }
{ "timestamp": "2026-05-13 12:30:56.0784", "level": "Error", "severity": "ERROR" }
{ "timestamp": "2026-05-13 12:38:08.3156", "level": "Error", "severity": "ERROR" }
{ "timestamp": "2026-05-13 12:38:23.0192", "level": "Error", "severity": "ERROR" }
{ "timestamp": "2026-05-13 12:38:23.1046", "level": "Error", "severity": "ERROR" }
{ "timestamp": "2026-05-13 12:38:41.5525", "level": "Error", "severity": "ERROR" }
{ "timestamp": "2026-05-13 12:38:41.6220", "level": "Error", "severity": "ERROR" }
{ "timestamp": "2026-05-13 12:38:42.4907", "level": "Error", "severity": "ERROR" }
{ "timestamp": "2026-05-13 12:38:56.3098", "level": "Error", "severity": "ERROR" }
{ "timestamp": "2026-05-13 12:53:59.0967", "level": "Error", "severity": "ERROR" }
{ "timestamp": "2026-05-13 12:54:16.9668", "level": "Error", "severity": "ERROR" }
{ "timestamp": "2026-05-13 12:55:39.8259", "level": "Error", "severity": "ERROR" }
{ "timestamp": "2026-05-13 12:56:25.2720", "level": "Error", "severity": "ERROR" }
{ "timestamp": "2026-05-13 12:57:30.5701", "level": "Error", "severity": "ERROR" }
{ "timestamp": "2026-05-13 13:00:30.7537", "level": "Error", "severity": "ERROR" }
{ "timestamp": "2026-05-13 13:00:53.0076", "level": "Error", "severity": "ERROR" }
{ "timestamp": "2026-05-13 13:01:02.1040", "level": "Error", "severity": "ERROR" }
{ "timestamp": "2026-05-13 13:01:16.0533", "level": "Error", "severity": "ERROR" }
{ "timestamp": "2026-05-13 13:03:23.1011", "level": "Error", "severity": "ERROR" }
{ "timestamp": "2026-05-13 13:03:57.2608", "level": "Error", "severity": "ERROR" }
{ "timestamp": "2026-05-13 13:05:57.0546", "level": "Error", "severity": "ERROR" }
{ "timestamp": "2026-05-13 13:06:01.7227", "level": "Error", "severity": "ERROR" }
{ "timestamp": "2026-05-13 13:06:16.6461", "level": "Error", "severity": "ERROR" }
{ "timestamp": "2026-05-13 13:26:19.8017", "level": "Error", "severity": "ERROR" }
{ "timestamp": "2026-05-13 13:26:44.9382", "level": "Error", "severity": "ERROR" }
{ "timestamp": "2026-05-13 13:26:51.2814", "level": "Error", "severity": "ERROR" }
{ "timestamp": "2026-05-13 14:26:40.7632", "level": "Error", "severity": "ERROR", "message": "Could not find file 'D:\\App-Data\\iis\\api.incidentreporter365.com\\Templates\\ExportSafetyAlert.html'.", "stackTrace": "System.IO.FileNotFoundException: Could not find file 'D:\\App-Data\\iis\\api.incidentreporter365.com\\Templates\\ExportSafetyAlert.html'.\r\nFile name: 'D:\\App-Data\\iis\\api.incidentreporter365.com\\Templates\\ExportSafetyAlert.html'\r\n   at System.IO.__Error.WinIOError(Int32 errorCode, String maybeFullPath)\r\n   at System.IO.FileStream.Init(String path, FileMode mode, FileAccess access, Int32 rights, Boolean useRights, FileShare share, Int32 bufferSize, FileOptions options, SECURITY_ATTRIBUTES secAttrs, String msgPath, Boolean bFromProxy, Boolean useLongPath, Boolean checkHost)\r\n   at System.IO.FileStream..ctor(String path, FileMode mode, FileAccess access, FileShare share, Int32 bufferSize, FileOptions options, String msgPath, Boolean bFromProxy, Boolean useLongPath, Boolean checkHost)\r\n   at System.IO.StreamReader..ctor(String path, Encoding encoding, Boolean detectEncodingFromByteOrderMarks, Int32 bufferSize, Boolean checkHost)\r\n   at System.IO.File.InternalReadAllText(String path, Encoding encoding, Boolean checkHost)\r\n   at IncidentReporter.API.Helpers.SafetyAlertPDFHelper.<ExportSafetyAlertPDFAsync>d__3.MoveNext() in C:\\GitLab-Runner\\builds\\27n6lYj0J\\0\\incident-reporter\\incident-reporter-api\\IncidentReporter\\IncidentReporter.API\\Helpers\\SafetyAlertPDFHelper.cs:line 86\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.SafetyAlertsBll.<ExportSafetyAlertPDFAsync>d__13.MoveNext() in C:\\GitLab-Runner\\builds\\27n6lYj0J\\0\\incident-reporter\\incident-reporter-api\\IncidentReporter\\IncidentReporter.API\\BLL\\SafetyAlertsBll.cs:line 1347" }
{ "timestamp": "2026-05-13 14:26:41.1952", "level": "Error", "severity": "ERROR" }
{ "timestamp": "2026-05-13 14:26:48.1223", "level": "Error", "severity": "ERROR", "message": "Could not find file 'D:\\App-Data\\iis\\api.incidentreporter365.com\\Templates\\ExportSafetyAlert.html'.", "stackTrace": "System.IO.FileNotFoundException: Could not find file 'D:\\App-Data\\iis\\api.incidentreporter365.com\\Templates\\ExportSafetyAlert.html'.\r\nFile name: 'D:\\App-Data\\iis\\api.incidentreporter365.com\\Templates\\ExportSafetyAlert.html'\r\n   at System.IO.__Error.WinIOError(Int32 errorCode, String maybeFullPath)\r\n   at System.IO.FileStream.Init(String path, FileMode mode, FileAccess access, Int32 rights, Boolean useRights, FileShare share, Int32 bufferSize, FileOptions options, SECURITY_ATTRIBUTES secAttrs, String msgPath, Boolean bFromProxy, Boolean useLongPath, Boolean checkHost)\r\n   at System.IO.FileStream..ctor(String path, FileMode mode, FileAccess access, FileShare share, Int32 bufferSize, FileOptions options, String msgPath, Boolean bFromProxy, Boolean useLongPath, Boolean checkHost)\r\n   at System.IO.StreamReader..ctor(String path, Encoding encoding, Boolean detectEncodingFromByteOrderMarks, Int32 bufferSize, Boolean checkHost)\r\n   at System.IO.File.InternalReadAllText(String path, Encoding encoding, Boolean checkHost)\r\n   at IncidentReporter.API.Helpers.SafetyAlertPDFHelper.<ExportSafetyAlertPDFAsync>d__3.MoveNext() in C:\\GitLab-Runner\\builds\\27n6lYj0J\\0\\incident-reporter\\incident-reporter-api\\IncidentReporter\\IncidentReporter.API\\Helpers\\SafetyAlertPDFHelper.cs:line 86\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.SafetyAlertsBll.<ExportSafetyAlertPDFAsync>d__13.MoveNext() in C:\\GitLab-Runner\\builds\\27n6lYj0J\\0\\incident-reporter\\incident-reporter-api\\IncidentReporter\\IncidentReporter.API\\BLL\\SafetyAlertsBll.cs:line 1347" }
{ "timestamp": "2026-05-13 14:26:48.1223", "level": "Error", "severity": "ERROR" }
{ "timestamp": "2026-05-13 14:45:20.7016", "level": "Error", "severity": "ERROR" }
{ "timestamp": "2026-05-13 14:45:20.8535", "level": "Error", "severity": "ERROR" }
{ "timestamp": "2026-05-13 16:21:07.8832", "level": "Error", "severity": "ERROR", "message": "User details not found for the given user and organisation.", "stackTrace": "System.Exception: User details not found for the given user and organisation." }
{ "timestamp": "2026-05-13 16:21:07.9224", "level": "Error", "severity": "ERROR" }
{ "timestamp": "2026-05-13 16:21:08.0301", "level": "Error", "severity": "ERROR", "message": "User details not found for the given user and organisation.", "stackTrace": "System.Exception: User details not found for the given user and organisation." }
{ "timestamp": "2026-05-13 16:21:08.0301", "level": "Error", "severity": "ERROR" }
{ "timestamp": "2026-05-13 18:22:35.9773", "level": "Error", "severity": "ERROR" }
{ "timestamp": "2026-05-13 18:22:57.7059", "level": "Error", "severity": "ERROR" }
