{ "timestamp": "2026-06-12 06:53:18.1628", "level": "Error", "severity": "ERROR", "message": "An unexpected error occurred.", "stackTrace": "IncidentReporter.DAL.Exceptions.UpstreamServiceException: An unexpected error occurred.\r\n   at IncidentReporter.API.Handlers.EntityStateWorkflowHandler.<GetStateTypesAsync>d__7.MoveNext() in C:\\GitLab-Runner\\builds\\27n6lYj0J\\0\\incident-reporter\\incident-reporter-api\\IncidentReporter\\IncidentReporter.API\\Handlers\\EntityStateWorkflowHandler.cs:line 337\r\n--- End of stack trace from previous location where exception was thrown ---\r\n   at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task)\r\n   at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)\r\n   at IncidentReporter.RenewalReminder.Helpers.WorkPermitV2AutoCloseHelper.WorkPermitV2AutoCloseExecution() in C:\\GitLab-Runner\\builds\\27n6lYj0J\\0\\incident-reporter\\incident-reporter-api\\IncidentReporter\\IncidentReporter.RenewalReminder\\Helpers\\WorkPermitV2AutoCloseHelper.cs:line 61" }
{ "timestamp": "2026-06-12 06:53:18.2290", "level": "Error", "severity": "ERROR" }
{ "timestamp": "2026-06-12 06:53:18.2347", "level": "Error", "severity": "ERROR", "message": "Fatal error encountered during command execution.", "stackTrace": "MySql.Data.MySqlClient.MySqlException (0x80004005): Fatal error encountered during command execution. ---> MySql.Data.MySqlClient.MySqlException (0x80004005): Parameter '@OrgIds' must be defined.\r\n   at MySql.Data.MySqlClient.Statement.SerializeParameter(MySqlParameterCollection parameters, MySqlPacket packet, String parmName, Int32 parameterIndex)\r\n   at MySql.Data.MySqlClient.Statement.InternalBindParameters(String sql, MySqlParameterCollection parameters, MySqlPacket packet)\r\n   at MySql.Data.MySqlClient.Statement.BindParameters()\r\n   at MySql.Data.MySqlClient.PreparableStatement.Execute()\r\n   at MySql.Data.MySqlClient.MySqlCommand.ExecuteReader(CommandBehavior behavior)\r\n   at MySql.Data.MySqlClient.MySqlCommand.ExecuteReader(CommandBehavior behavior)\r\n   at MySql.Data.MySqlClient.MySqlCommand.ExecuteDbDataReader(CommandBehavior behavior)\r\n   at System.Data.Common.DbCommand.System.Data.IDbCommand.ExecuteReader(CommandBehavior behavior)\r\n   at Dapper.SqlMapper.ExecuteReaderWithFlagsFallback(IDbCommand cmd, Boolean wasClosed, CommandBehavior behavior)\r\n   at Dapper.SqlMapper.<QueryImpl>d__138`1.MoveNext()\r\n   at System.Collections.Generic.List`1..ctor(IEnumerable`1 collection)\r\n   at System.Linq.Enumerable.ToList[TSource](IEnumerable`1 source)\r\n   at Dapper.SqlMapper.Query[T](IDbConnection cnn, String sql, Object param, IDbTransaction transaction, Boolean buffered, Nullable`1 commandTimeout, Nullable`1 commandType)\r\n   at IncidentReporter.DAL.Repositories.PtwRepo.GetPermitToWorkExceedingAutoUpdateInterval(List`1 orgIds) in C:\\GitLab-Runner\\builds\\27n6lYj0J\\0\\incident-reporter\\incident-reporter-api\\IncidentReporter\\IncidentReporter.DAL\\Repositories\\PtwRepo.cs:line 4724\r\n   at IncidentReporter.RenewalReminder.Helpers.PTWAutoStatusChangeHelper.PTWAutoStatusChangeExecution() in C:\\GitLab-Runner\\builds\\27n6lYj0J\\0\\incident-reporter\\incident-reporter-api\\IncidentReporter\\IncidentReporter.RenewalReminder\\Helpers\\PTWAutoStatusChangeHelper.cs:line 45" }
{ "timestamp": "2026-06-12 06:53:18.2513", "level": "Error", "severity": "ERROR" }
{ "timestamp": "2026-06-12 07:10:42.2195", "level": "Error", "severity": "ERROR", "message": "Fatal error encountered during command execution.", "stackTrace": "MySql.Data.MySqlClient.MySqlException (0x80004005): Fatal error encountered during command execution. ---> MySql.Data.MySqlClient.MySqlException (0x80004005): Parameter '@OrgIds' must be defined.\r\n   at MySql.Data.MySqlClient.Statement.SerializeParameter(MySqlParameterCollection parameters, MySqlPacket packet, String parmName, Int32 parameterIndex)\r\n   at MySql.Data.MySqlClient.Statement.InternalBindParameters(String sql, MySqlParameterCollection parameters, MySqlPacket packet)\r\n   at MySql.Data.MySqlClient.Statement.BindParameters()\r\n   at MySql.Data.MySqlClient.PreparableStatement.Execute()\r\n   at MySql.Data.MySqlClient.MySqlCommand.ExecuteReader(CommandBehavior behavior)\r\n   at MySql.Data.MySqlClient.MySqlCommand.ExecuteReader(CommandBehavior behavior)\r\n   at MySql.Data.MySqlClient.MySqlCommand.ExecuteDbDataReader(CommandBehavior behavior)\r\n   at System.Data.Common.DbCommand.System.Data.IDbCommand.ExecuteReader(CommandBehavior behavior)\r\n   at Dapper.SqlMapper.ExecuteReaderWithFlagsFallback(IDbCommand cmd, Boolean wasClosed, CommandBehavior behavior)\r\n   at Dapper.SqlMapper.<QueryImpl>d__138`1.MoveNext()\r\n   at System.Collections.Generic.List`1..ctor(IEnumerable`1 collection)\r\n   at System.Linq.Enumerable.ToList[TSource](IEnumerable`1 source)\r\n   at Dapper.SqlMapper.Query[T](IDbConnection cnn, String sql, Object param, IDbTransaction transaction, Boolean buffered, Nullable`1 commandTimeout, Nullable`1 commandType)\r\n   at IncidentReporter.DAL.Repositories.PtwRepo.GetPermitToWorkExceedingAutoUpdateInterval(List`1 orgIds) in C:\\GitLab-Runner\\builds\\27n6lYj0J\\0\\incident-reporter\\incident-reporter-api\\IncidentReporter\\IncidentReporter.DAL\\Repositories\\PtwRepo.cs:line 4724\r\n   at IncidentReporter.RenewalReminder.Helpers.PTWAutoStatusChangeHelper.PTWAutoStatusChangeExecution() in C:\\GitLab-Runner\\builds\\27n6lYj0J\\0\\incident-reporter\\incident-reporter-api\\IncidentReporter\\IncidentReporter.RenewalReminder\\Helpers\\PTWAutoStatusChangeHelper.cs:line 45" }
{ "timestamp": "2026-06-12 07:10:42.2820", "level": "Error", "severity": "ERROR" }
{ "timestamp": "2026-06-12 08:04:10.4452", "level": "Error", "severity": "ERROR", "message": "Fatal error encountered during command execution.", "stackTrace": "MySql.Data.MySqlClient.MySqlException (0x80004005): Fatal error encountered during command execution. ---> MySql.Data.MySqlClient.MySqlException (0x80004005): Parameter '@OrgIds' must be defined.\r\n   at MySql.Data.MySqlClient.Statement.SerializeParameter(MySqlParameterCollection parameters, MySqlPacket packet, String parmName, Int32 parameterIndex)\r\n   at MySql.Data.MySqlClient.Statement.InternalBindParameters(String sql, MySqlParameterCollection parameters, MySqlPacket packet)\r\n   at MySql.Data.MySqlClient.Statement.BindParameters()\r\n   at MySql.Data.MySqlClient.PreparableStatement.Execute()\r\n   at MySql.Data.MySqlClient.MySqlCommand.ExecuteReader(CommandBehavior behavior)\r\n   at MySql.Data.MySqlClient.MySqlCommand.ExecuteReader(CommandBehavior behavior)\r\n   at MySql.Data.MySqlClient.MySqlCommand.ExecuteDbDataReader(CommandBehavior behavior)\r\n   at System.Data.Common.DbCommand.System.Data.IDbCommand.ExecuteReader(CommandBehavior behavior)\r\n   at Dapper.SqlMapper.ExecuteReaderWithFlagsFallback(IDbCommand cmd, Boolean wasClosed, CommandBehavior behavior)\r\n   at Dapper.SqlMapper.<QueryImpl>d__138`1.MoveNext()\r\n   at System.Collections.Generic.List`1..ctor(IEnumerable`1 collection)\r\n   at System.Linq.Enumerable.ToList[TSource](IEnumerable`1 source)\r\n   at Dapper.SqlMapper.Query[T](IDbConnection cnn, String sql, Object param, IDbTransaction transaction, Boolean buffered, Nullable`1 commandTimeout, Nullable`1 commandType)\r\n   at IncidentReporter.DAL.Repositories.PtwRepo.GetPermitToWorkExceedingAutoUpdateInterval(List`1 orgIds) in C:\\GitLab-Runner\\builds\\27n6lYj0J\\0\\incident-reporter\\incident-reporter-api\\IncidentReporter\\IncidentReporter.DAL\\Repositories\\PtwRepo.cs:line 4724\r\n   at IncidentReporter.RenewalReminder.Helpers.PTWAutoStatusChangeHelper.PTWAutoStatusChangeExecution() in C:\\GitLab-Runner\\builds\\27n6lYj0J\\0\\incident-reporter\\incident-reporter-api\\IncidentReporter\\IncidentReporter.RenewalReminder\\Helpers\\PTWAutoStatusChangeHelper.cs:line 45" }
{ "timestamp": "2026-06-12 08:04:10.5121", "level": "Error", "severity": "ERROR" }
{ "timestamp": "2026-06-12 10:08:40.8453", "level": "Error", "severity": "ERROR", "message": "Fatal error encountered during command execution.", "stackTrace": "MySql.Data.MySqlClient.MySqlException (0x80004005): Fatal error encountered during command execution. ---> MySql.Data.MySqlClient.MySqlException (0x80004005): Parameter '@OrgIds' must be defined.\r\n   at MySql.Data.MySqlClient.Statement.SerializeParameter(MySqlParameterCollection parameters, MySqlPacket packet, String parmName, Int32 parameterIndex)\r\n   at MySql.Data.MySqlClient.Statement.InternalBindParameters(String sql, MySqlParameterCollection parameters, MySqlPacket packet)\r\n   at MySql.Data.MySqlClient.Statement.BindParameters()\r\n   at MySql.Data.MySqlClient.PreparableStatement.Execute()\r\n   at MySql.Data.MySqlClient.MySqlCommand.ExecuteReader(CommandBehavior behavior)\r\n   at MySql.Data.MySqlClient.MySqlCommand.ExecuteReader(CommandBehavior behavior)\r\n   at MySql.Data.MySqlClient.MySqlCommand.ExecuteDbDataReader(CommandBehavior behavior)\r\n   at System.Data.Common.DbCommand.System.Data.IDbCommand.ExecuteReader(CommandBehavior behavior)\r\n   at Dapper.SqlMapper.ExecuteReaderWithFlagsFallback(IDbCommand cmd, Boolean wasClosed, CommandBehavior behavior)\r\n   at Dapper.SqlMapper.<QueryImpl>d__138`1.MoveNext()\r\n   at System.Collections.Generic.List`1..ctor(IEnumerable`1 collection)\r\n   at System.Linq.Enumerable.ToList[TSource](IEnumerable`1 source)\r\n   at Dapper.SqlMapper.Query[T](IDbConnection cnn, String sql, Object param, IDbTransaction transaction, Boolean buffered, Nullable`1 commandTimeout, Nullable`1 commandType)\r\n   at IncidentReporter.DAL.Repositories.PtwRepo.GetPermitToWorkExceedingAutoUpdateInterval(List`1 orgIds) in C:\\GitLab-Runner\\builds\\27n6lYj0J\\0\\incident-reporter\\incident-reporter-api\\IncidentReporter\\IncidentReporter.DAL\\Repositories\\PtwRepo.cs:line 4724\r\n   at IncidentReporter.RenewalReminder.Helpers.PTWAutoStatusChangeHelper.PTWAutoStatusChangeExecution() in C:\\GitLab-Runner\\builds\\27n6lYj0J\\0\\incident-reporter\\incident-reporter-api\\IncidentReporter\\IncidentReporter.RenewalReminder\\Helpers\\PTWAutoStatusChangeHelper.cs:line 45" }
{ "timestamp": "2026-06-12 10:08:40.9121", "level": "Error", "severity": "ERROR" }
{ "timestamp": "2026-06-12 10:45:06.0248", "level": "Error", "severity": "ERROR", "message": "Fatal error encountered during command execution.", "stackTrace": "MySql.Data.MySqlClient.MySqlException (0x80004005): Fatal error encountered during command execution. ---> MySql.Data.MySqlClient.MySqlException (0x80004005): Parameter '@OrgIds' must be defined.\r\n   at MySql.Data.MySqlClient.Statement.SerializeParameter(MySqlParameterCollection parameters, MySqlPacket packet, String parmName, Int32 parameterIndex)\r\n   at MySql.Data.MySqlClient.Statement.InternalBindParameters(String sql, MySqlParameterCollection parameters, MySqlPacket packet)\r\n   at MySql.Data.MySqlClient.Statement.BindParameters()\r\n   at MySql.Data.MySqlClient.PreparableStatement.Execute()\r\n   at MySql.Data.MySqlClient.MySqlCommand.ExecuteReader(CommandBehavior behavior)\r\n   at MySql.Data.MySqlClient.MySqlCommand.ExecuteReader(CommandBehavior behavior)\r\n   at MySql.Data.MySqlClient.MySqlCommand.ExecuteDbDataReader(CommandBehavior behavior)\r\n   at System.Data.Common.DbCommand.System.Data.IDbCommand.ExecuteReader(CommandBehavior behavior)\r\n   at Dapper.SqlMapper.ExecuteReaderWithFlagsFallback(IDbCommand cmd, Boolean wasClosed, CommandBehavior behavior)\r\n   at Dapper.SqlMapper.<QueryImpl>d__138`1.MoveNext()\r\n   at System.Collections.Generic.List`1..ctor(IEnumerable`1 collection)\r\n   at System.Linq.Enumerable.ToList[TSource](IEnumerable`1 source)\r\n   at Dapper.SqlMapper.Query[T](IDbConnection cnn, String sql, Object param, IDbTransaction transaction, Boolean buffered, Nullable`1 commandTimeout, Nullable`1 commandType)\r\n   at IncidentReporter.DAL.Repositories.PtwRepo.GetPermitToWorkExceedingAutoUpdateInterval(List`1 orgIds) in C:\\GitLab-Runner\\builds\\27n6lYj0J\\0\\incident-reporter\\incident-reporter-api\\IncidentReporter\\IncidentReporter.DAL\\Repositories\\PtwRepo.cs:line 4724\r\n   at IncidentReporter.RenewalReminder.Helpers.PTWAutoStatusChangeHelper.PTWAutoStatusChangeExecution() in C:\\GitLab-Runner\\builds\\27n6lYj0J\\0\\incident-reporter\\incident-reporter-api\\IncidentReporter\\IncidentReporter.RenewalReminder\\Helpers\\PTWAutoStatusChangeHelper.cs:line 45" }
{ "timestamp": "2026-06-12 10:45:06.0920", "level": "Error", "severity": "ERROR" }
