{ "timestamp": "2026-06-02 12:00:55.5854", "level": "Debug", "severity": "DEBUG", "message": "Process started." }
{ "timestamp": "2026-06-02 12:00:55.5854", "level": "Debug", "severity": "DEBUG", "message": "Process started." }
{ "timestamp": "2026-06-02 12:00:55.6004", "level": "Debug", "severity": "DEBUG", "message": "Processing command line argsMIDNIGHT_EXECUTE" }
{ "timestamp": "2026-06-02 12:00:55.6022", "level": "Debug", "severity": "DEBUG", "message": "Processing command line argsBATCH_ATTENDANCE_CRON" }
{ "timestamp": "2026-06-02 12:00:55.6022", "level": "Info", "severity": "INFO", "message": "Starting Batch Attendance OCR background job" }
{ "timestamp": "2026-06-02 12:00:55.6246", "level": "Info", "severity": "INFO", "message": "INSPECTION_NEXT_DUE_DATE_NOTIFICATION - Fetching inspection reminders for current timestamp..." }
{ "timestamp": "2026-06-02 12:01:10.6724", "level": "Error", "severity": "ERROR", "message": "Error while executing InspectionReminderExecuteAsync", "stackTrace": "MySql.Data.MySqlClient.MySqlException (0x80004005): Unable to connect to any of the specified MySQL hosts. ---> MySql.Data.MySqlClient.MySqlException (0x80004005): Timeout expired.  The timeout period elapsed prior to completion of the operation or the server is not responding. ---> System.TimeoutException: The operation has timed out.\r\n   at MySql.Data.Common.StreamCreator.GetTcpStream(MySqlConnectionStringBuilder settings, MyNetworkStream& networkStream)\r\n   at MySql.Data.Common.StreamCreator.GetStream(MySqlConnectionStringBuilder settings, MyNetworkStream& networkStream)\r\n   at MySql.Data.MySqlClient.NativeDriver.Open()\r\n   at MySql.Data.MySqlClient.NativeDriver.Open()\r\n   at MySql.Data.MySqlClient.Driver.Open()\r\n   at MySql.Data.MySqlClient.Driver.Create(MySqlConnectionStringBuilder settings)\r\n   at MySql.Data.MySqlClient.MySqlPool.CreateNewPooledConnection()\r\n   at MySql.Data.MySqlClient.MySqlPool.GetPooledConnection()\r\n   at MySql.Data.MySqlClient.MySqlPool.TryToGetDriver()\r\n   at MySql.Data.MySqlClient.MySqlPool.GetConnection()\r\n   at MySql.Data.MySqlClient.MySqlConnection.Open()\r\n   at IncidentReporter.DAL.Repositories.BaseRepo.OpenConnection() in C:\\GitLab-Runner\\builds\\27n6lYj0J\\0\\incident-reporter\\incident-reporter-api\\IncidentReporter\\IncidentReporter.DAL\\Repositories\\BaseRepo.cs:line 26\r\n   at IncidentReporter.DAL.Repositories.OrganisationRepo.GetAllActiveOrganisations() in C:\\GitLab-Runner\\builds\\27n6lYj0J\\0\\incident-reporter\\incident-reporter-api\\IncidentReporter\\IncidentReporter.DAL\\Repositories\\OrganisationRepo.cs:line 4133\r\n   at IncidentReporter.RenewalReminder.Helpers.InspectionNextDueDateReminderHelper.<InspectionNextDueDateReminderExecuteAsync>d__4.MoveNext() in C:\\GitLab-Runner\\builds\\27n6lYj0J\\0\\incident-reporter\\incident-reporter-api\\IncidentReporter\\IncidentReporter.RenewalReminder\\Helpers\\InspectionNextDueDateReminderHelper.cs:line 48" }
{ "timestamp": "2026-06-02 12:01:10.7073", "level": "Debug", "severity": "DEBUG", "message": "## Started Batch Scheduler Execution ##" }
{ "timestamp": "2026-06-02 12:01:10.6704", "level": "Error", "severity": "ERROR", "message": "Fatal error in OCR background job", "stackTrace": "MySql.Data.MySqlClient.MySqlException (0x80004005): Unable to connect to any of the specified MySQL hosts. ---> MySql.Data.MySqlClient.MySqlException (0x80004005): Timeout expired.  The timeout period elapsed prior to completion of the operation or the server is not responding. ---> System.TimeoutException: The operation has timed out.\r\n   at MySql.Data.Common.StreamCreator.GetTcpStream(MySqlConnectionStringBuilder settings, MyNetworkStream& networkStream)\r\n   at MySql.Data.Common.StreamCreator.GetStream(MySqlConnectionStringBuilder settings, MyNetworkStream& networkStream)\r\n   at MySql.Data.MySqlClient.NativeDriver.Open()\r\n   at MySql.Data.MySqlClient.NativeDriver.Open()\r\n   at MySql.Data.MySqlClient.Driver.Open()\r\n   at MySql.Data.MySqlClient.Driver.Create(MySqlConnectionStringBuilder settings)\r\n   at MySql.Data.MySqlClient.MySqlPool.CreateNewPooledConnection()\r\n   at MySql.Data.MySqlClient.MySqlPool.GetPooledConnection()\r\n   at MySql.Data.MySqlClient.MySqlPool.TryToGetDriver()\r\n   at MySql.Data.MySqlClient.MySqlPool.GetConnection()\r\n   at MySql.Data.MySqlClient.MySqlConnection.Open()\r\n   at IncidentReporter.DAL.Repositories.BaseRepo.OpenConnection() in C:\\GitLab-Runner\\builds\\27n6lYj0J\\0\\incident-reporter\\incident-reporter-api\\IncidentReporter\\IncidentReporter.DAL\\Repositories\\BaseRepo.cs:line 26\r\n   at IncidentReporter.DAL.Repositories.CoursesRepo.GetPendingDocumentExtractorJobs(Int32 limit) in C:\\GitLab-Runner\\builds\\27n6lYj0J\\0\\incident-reporter\\incident-reporter-api\\IncidentReporter\\IncidentReporter.DAL\\Repositories\\CoursesRepo.cs:line 8547\r\n   at IncidentReporter.RenewalReminder.Helpers.BatchAttendanceOcrBackgroundHelper.<ProcessBatchAttendanceAsync>d__3.MoveNext() in C:\\GitLab-Runner\\builds\\27n6lYj0J\\0\\incident-reporter\\incident-reporter-api\\IncidentReporter\\IncidentReporter.RenewalReminder\\Helpers\\BatchAttendanceOcrBackgroundHelper.cs:line 41" }
{ "timestamp": "2026-06-02 12:01:25.7134", "level": "Error", "severity": "ERROR", "message": "Could not process batch schedule execution" }
{ "timestamp": "2026-06-02 12:01:25.7623", "level": "Info", "severity": "INFO", "message": "## Started User Attendance Stats Execution ##" }
{ "timestamp": "2026-06-02 12:01:40.7981", "level": "Error", "severity": "ERROR", "message": "{\r\n  \"MethodName\": \"GetDistinctUserIds\",\r\n  \"Message\": \"Error retrieving distinct user IDs: Unable to connect to any of the specified MySQL hosts.\",\r\n  \"AdditionalData\": {\r\n    \"EntryPoint\": \"RenewalReminder\",\r\n    \"InputData\": null\r\n  }\r\n}" }
{ "timestamp": "2026-06-02 12:01:40.8961", "level": "Info", "severity": "INFO", "message": "## Found 0 unique users ##" }
{ "timestamp": "2026-06-02 12:01:40.8961", "level": "Info", "severity": "INFO", "message": "## Completed User Attendance Stats Execution ##" }
{ "timestamp": "2026-06-02 12:01:40.8961", "level": "Info", "severity": "INFO", "message": "NEXT_INSPECTION_CREATION_NOTIFICATION - Fetching inspection reminders for current timestamp..." }
{ "timestamp": "2026-06-02 12:01:55.9065", "level": "Error", "severity": "ERROR", "message": "Error while executing NextInspectionCreationReminderExecuteAsync", "stackTrace": "MySql.Data.MySqlClient.MySqlException (0x80004005): Unable to connect to any of the specified MySQL hosts. ---> MySql.Data.MySqlClient.MySqlException (0x80004005): Timeout expired.  The timeout period elapsed prior to completion of the operation or the server is not responding. ---> System.TimeoutException: The operation has timed out.\r\n   at MySql.Data.Common.StreamCreator.GetTcpStream(MySqlConnectionStringBuilder settings, MyNetworkStream& networkStream)\r\n   at MySql.Data.Common.StreamCreator.GetStream(MySqlConnectionStringBuilder settings, MyNetworkStream& networkStream)\r\n   at MySql.Data.MySqlClient.NativeDriver.Open()\r\n   at MySql.Data.MySqlClient.NativeDriver.Open()\r\n   at MySql.Data.MySqlClient.Driver.Open()\r\n   at MySql.Data.MySqlClient.Driver.Create(MySqlConnectionStringBuilder settings)\r\n   at MySql.Data.MySqlClient.MySqlPool.CreateNewPooledConnection()\r\n   at MySql.Data.MySqlClient.MySqlPool.GetPooledConnection()\r\n   at MySql.Data.MySqlClient.MySqlPool.TryToGetDriver()\r\n   at MySql.Data.MySqlClient.MySqlPool.GetConnection()\r\n   at MySql.Data.MySqlClient.MySqlConnection.Open()\r\n   at IncidentReporter.DAL.Repositories.BaseRepo.OpenConnection() in C:\\GitLab-Runner\\builds\\27n6lYj0J\\0\\incident-reporter\\incident-reporter-api\\IncidentReporter\\IncidentReporter.DAL\\Repositories\\BaseRepo.cs:line 26\r\n   at IncidentReporter.DAL.Repositories.OrganisationRepo.GetAllActiveOrganisations() in C:\\GitLab-Runner\\builds\\27n6lYj0J\\0\\incident-reporter\\incident-reporter-api\\IncidentReporter\\IncidentReporter.DAL\\Repositories\\OrganisationRepo.cs:line 4133\r\n   at IncidentReporter.RenewalReminder.Helpers.InspectionNextDueDateReminderHelper.<NextInspectionCreationReminderExecuteAsync>d__8.MoveNext() in C:\\GitLab-Runner\\builds\\27n6lYj0J\\0\\incident-reporter\\incident-reporter-api\\IncidentReporter\\IncidentReporter.RenewalReminder\\Helpers\\InspectionNextDueDateReminderHelper.cs:line 401" }
{ "timestamp": "2026-06-02 12:01:55.9389", "level": "Info", "severity": "INFO", "message": "AUTO_INSPECTION_CREATION - Fetching inspection creation for current timestamp..." }
{ "timestamp": "2026-06-02 12:02:10.9442", "level": "Error", "severity": "ERROR", "message": "Error while executing AutoInspectionCreationAsync", "stackTrace": "MySql.Data.MySqlClient.MySqlException (0x80004005): Unable to connect to any of the specified MySQL hosts. ---> MySql.Data.MySqlClient.MySqlException (0x80004005): Timeout expired.  The timeout period elapsed prior to completion of the operation or the server is not responding. ---> System.TimeoutException: The operation has timed out.\r\n   at MySql.Data.Common.StreamCreator.GetTcpStream(MySqlConnectionStringBuilder settings, MyNetworkStream& networkStream)\r\n   at MySql.Data.Common.StreamCreator.GetStream(MySqlConnectionStringBuilder settings, MyNetworkStream& networkStream)\r\n   at MySql.Data.MySqlClient.NativeDriver.Open()\r\n   at MySql.Data.MySqlClient.NativeDriver.Open()\r\n   at MySql.Data.MySqlClient.Driver.Open()\r\n   at MySql.Data.MySqlClient.Driver.Create(MySqlConnectionStringBuilder settings)\r\n   at MySql.Data.MySqlClient.MySqlPool.CreateNewPooledConnection()\r\n   at MySql.Data.MySqlClient.MySqlPool.GetPooledConnection()\r\n   at MySql.Data.MySqlClient.MySqlPool.TryToGetDriver()\r\n   at MySql.Data.MySqlClient.MySqlPool.GetConnection()\r\n   at MySql.Data.MySqlClient.MySqlConnection.Open()\r\n   at IncidentReporter.DAL.Repositories.BaseRepo.OpenConnection() in C:\\GitLab-Runner\\builds\\27n6lYj0J\\0\\incident-reporter\\incident-reporter-api\\IncidentReporter\\IncidentReporter.DAL\\Repositories\\BaseRepo.cs:line 26\r\n   at IncidentReporter.DAL.Repositories.OrganisationRepo.GetAllActiveOrganisations() in C:\\GitLab-Runner\\builds\\27n6lYj0J\\0\\incident-reporter\\incident-reporter-api\\IncidentReporter\\IncidentReporter.DAL\\Repositories\\OrganisationRepo.cs:line 4133\r\n   at IncidentReporter.RenewalReminder.Helpers.InspectionNextDueDateReminderHelper.<AutoInspectionCreationAsync>d__10.MoveNext() in C:\\GitLab-Runner\\builds\\27n6lYj0J\\0\\incident-reporter\\incident-reporter-api\\IncidentReporter\\IncidentReporter.RenewalReminder\\Helpers\\InspectionNextDueDateReminderHelper.cs:line 602" }