level: Error

severity: ERROR

stackTrace:
System.InvalidCastException: Unable to cast object of type 'System.Int64' to type 'System.String'.
   at IncidentReporter.NotificationSender.Models.Event.Get[T](String strKey) in C:\Gitlab-Runner\builds\pmbcEkqkx\1\incident-reporter\incident-reporter-api\IncidentReporter\IncidentReporter.NotificationSender\Models\Event.cs:line 71
   at IncidentReporter.NotificationSender.DAL.Events.EventHandler.HandleMessage(IMessage message) in C:\Gitlab-Runner\builds\pmbcEkqkx\1\incident-reporter\incident-reporter-api\IncidentReporter\IncidentReporter.NotificationSender\DAL\Events\EventHandler.cs:line 805


message: Unable to cast object of type 'System.Int64' to type 'System.String'.


stackTrace:
MySql.Data.MySqlClient.MySqlException (0x80004005): Fatal error encountered during command execution. ---> MySql.Data.MySqlClient.MySqlException (0x80004005): Parameter '@TicketStatusName' must be defined.
   at MySql.Data.MySqlClient.Statement.SerializeParameter(MySqlParameterCollection parameters, MySqlPacket packet, String parmName, Int32 parameterIndex)
   at MySql.Data.MySqlClient.Statement.InternalBindParameters(String sql, MySqlParameterCollection parameters, MySqlPacket packet)
   at MySql.Data.MySqlClient.Statement.BindParameters()
   at MySql.Data.MySqlClient.PreparableStatement.Execute()
   at MySql.Data.MySqlClient.MySqlCommand.ExecuteReader(CommandBehavior behavior)
   at MySql.Data.MySqlClient.MySqlCommand.ExecuteReader(CommandBehavior behavior)
   at MySql.Data.MySqlClient.MySqlCommand.ExecuteDbDataReader(CommandBehavior behavior)
   at System.Data.Common.DbCommand.System.Data.IDbCommand.ExecuteReader(CommandBehavior behavior)
   at Dapper.SqlMapper.ExecuteReaderWithFlagsFallback(IDbCommand cmd, Boolean wasClosed, CommandBehavior behavior)
   at Dapper.SqlMapper.<QueryImpl>d__138`1.MoveNext()
   at System.Collections.Generic.List`1..ctor(IEnumerable`1 collection)
   at System.Linq.Enumerable.ToList[TSource](IEnumerable`1 source)
   at Dapper.SqlMapper.Query[T](IDbConnection cnn, String sql, Object param, IDbTransaction transaction, Boolean buffered, Nullable`1 commandTimeout, Nullable`1 commandType)
   at IncidentReporter.DAL.Repositories.TaskRepo.GetValidationUsersFromPreferences(Int32 orgId, Int32 moduleId, String taskStatusName, Int32 siteId) in C:\Gitlab-Runner\builds\pmbcEkqkx\1\incident-reporter\incident-reporter-api\IncidentReporter\IncidentReporter.DAL\Repositories\TaskRepo.cs:line 4591
   at IncidentReporter.NotificationSender.DAL.Events.Notifier.SendTaskOpenDetailsToSiteEHS(Int64 taskId, Int64 orgId) in C:\Gitlab-Runner\builds\pmbcEkqkx\1\incident-reporter\incident-reporter-api\IncidentReporter\IncidentReporter.NotificationSender\DAL\Events\Notifier.cs:line 9623
   at IncidentReporter.NotificationSender.DAL.Events.EventHandler.HandleMessage(IMessage message) in C:\Gitlab-Runner\builds\pmbcEkqkx\1\incident-reporter\incident-reporter-api\IncidentReporter\IncidentReporter.NotificationSender\DAL\Events\EventHandler.cs:line 1271


stackTrace:
System.ArgumentNullException: Value cannot be null.
Parameter name: path4
   at System.IO.Path.Combine(String path1, String path2, String path3, String path4)
   at IncidentReporter.API.Helpers.ExportTrainingCertificateHelper.ExportCertificate(TrainingCertificateDTO participant, String outputAbsoluteFilePath, Int32 orgId) in C:\Gitlab-Runner\builds\pmbcEkqkx\1\incident-reporter\incident-reporter-api\IncidentReporter\IncidentReporter.API\Helpers\ExportTrainingCertificateHelper.cs:line 25
   at IncidentReporter.API.Helpers.ExportTrainingCertificateHelper.ExportCertificatePDFAsByteArray(TrainingCertificateDTO participant, Int32 orgId, Int32 batchId, Int32 participantId) in C:\Gitlab-Runner\builds\pmbcEkqkx\1\incident-reporter\incident-reporter-api\IncidentReporter\IncidentReporter.API\Helpers\ExportTrainingCertificateHelper.cs:line 103
   at IncidentReporter.NotificationSender.DAL.Events.Notifier.SendNotificationToBatchParticipantsForCompletedStatus(Int64 batchId) in C:\Gitlab-Runner\builds\pmbcEkqkx\1\incident-reporter\incident-reporter-api\IncidentReporter\IncidentReporter.NotificationSender\DAL\Events\Notifier.cs:line 3221
   at IncidentReporter.NotificationSender.DAL.Events.EventHandler.HandleMessage(IMessage message) in C:\Gitlab-Runner\builds\pmbcEkqkx\1\incident-reporter\incident-reporter-api\IncidentReporter\IncidentReporter.NotificationSender\DAL\Events\EventHandler.cs:line 474


stackTrace:
System.ArgumentNullException: Value cannot be null.
Parameter name: path2
   at System.IO.Path.Combine(String path1, String path2, String path3)
   at IncidentReporter.API.Helpers.ExportTrainingCertificateHelper.ExportCertificate(TrainingCertificateDTO participant, String outputAbsoluteFilePath, Int32 orgId) in C:\Gitlab-Runner\builds\pmbcEkqkx\1\incident-reporter\incident-reporter-api\IncidentReporter\IncidentReporter.API\Helpers\ExportTrainingCertificateHelper.cs:line 35
   at IncidentReporter.API.Helpers.ExportTrainingCertificateHelper.ExportCertificatePDFAsByteArray(TrainingCertificateDTO participant, Int32 orgId, Int32 batchId, Int32 participantId) in C:\Gitlab-Runner\builds\pmbcEkqkx\1\incident-reporter\incident-reporter-api\IncidentReporter\IncidentReporter.API\Helpers\ExportTrainingCertificateHelper.cs:line 103
   at IncidentReporter.NotificationSender.DAL.Events.Notifier.SendNotificationToBatchParticipantsForCompletedStatus(Int64 batchId) in C:\Gitlab-Runner\builds\pmbcEkqkx\1\incident-reporter\incident-reporter-api\IncidentReporter\IncidentReporter.NotificationSender\DAL\Events\Notifier.cs:line 3221
   at IncidentReporter.NotificationSender.DAL.Events.EventHandler.HandleMessage(IMessage message) in C:\Gitlab-Runner\builds\pmbcEkqkx\1\incident-reporter\incident-reporter-api\IncidentReporter\IncidentReporter.NotificationSender\DAL\Events\EventHandler.cs:line 474


stackTrace:
System.InvalidCastException: Unable to cast object of type 'System.Int64' to type 'System.String'.
   at IncidentReporter.NotificationSender.Models.Event.Get[T](String strKey) in C:\Gitlab-Runner\builds\pmbcEkqkx\1\incident-reporter\incident-reporter-api\IncidentReporter\IncidentReporter.NotificationSender\Models\Event.cs:line 71
   at IncidentReporter.NotificationSender.DAL.Events.EventHandler.HandleMessage(IMessage message) in C:\Gitlab-Runner\builds\pmbcEkqkx\1\incident-reporter\incident-reporter-api\IncidentReporter\IncidentReporter.NotificationSender\DAL\Events\EventHandler.cs:line 851


stackTrace:
System.NullReferenceException: Object reference not set to an instance of an object.
   at IncidentReporter.API.Helpers.ExportTrainingCertificateHelper.ExportCertificate(TrainingCertificateDTO participant, String outputAbsoluteFilePath, Int32 orgId) in C:\Gitlab-Runner\builds\pmbcEkqkx\1\incident-reporter\incident-reporter-api\IncidentReporter\IncidentReporter.API\Helpers\ExportTrainingCertificateHelper.cs:line 64
   at IncidentReporter.API.Helpers.ExportTrainingCertificateHelper.ExportCertificatePDFAsByteArray(TrainingCertificateDTO participant, Int32 orgId, Int32 batchId, Int32 participantId) in C:\Gitlab-Runner\builds\pmbcEkqkx\1\incident-reporter\incident-reporter-api\IncidentReporter\IncidentReporter.API\Helpers\ExportTrainingCertificateHelper.cs:line 103
   at IncidentReporter.NotificationSender.DAL.Events.Notifier.SendNotificationToBatchParticipantsForCompletedStatus(Int64 batchId) in C:\Gitlab-Runner\builds\pmbcEkqkx\1\incident-reporter\incident-reporter-api\IncidentReporter\IncidentReporter.NotificationSender\DAL\Events\Notifier.cs:line 3221
   at IncidentReporter.NotificationSender.DAL.Events.EventHandler.HandleMessage(IMessage message) in C:\Gitlab-Runner\builds\pmbcEkqkx\1\incident-reporter\incident-reporter-api\IncidentReporter\IncidentReporter.NotificationSender\DAL\Events\EventHandler.cs:line 474


message: Object reference not set to an instance of an object.


stackTrace:
System.InvalidCastException: Unable to cast object of type 'System.Int64' to type 'System.String'.
   at IncidentReporter.NotificationSender.Models.Event.Get[T](String strKey) in C:\Gitlab-Runner\builds\pmbcEkqkx\1\incident-reporter\incident-reporter-api\IncidentReporter\IncidentReporter.NotificationSender\Models\Event.cs:line 71
   at IncidentReporter.NotificationSender.DAL.Events.EventHandler.HandleMessage(IMessage message) in C:\Gitlab-Runner\builds\pmbcEkqkx\1\incident-reporter\incident-reporter-api\IncidentReporter\IncidentReporter.NotificationSender\DAL\Events\EventHandler.cs:line 1041


stackTrace:
System.ArgumentNullException: Value cannot be null.
Parameter name: format
   at System.String.FormatHelper(IFormatProvider provider, String format, ParamsArray args)
   at System.String.Format(String format, Object arg0, Object arg1)
   at IncidentReporter.NotificationSender.DAL.Events.Notifier.SendNotificationToBatchParticipantsForCompletedStatus(Int64 batchId) in C:\Gitlab-Runner\builds\pmbcEkqkx\1\incident-reporter\incident-reporter-api\IncidentReporter\IncidentReporter.NotificationSender\DAL\Events\Notifier.cs:line 3253
   at IncidentReporter.NotificationSender.DAL.Events.EventHandler.HandleMessage(IMessage message) in C:\Gitlab-Runner\builds\pmbcEkqkx\1\incident-reporter\incident-reporter-api\IncidentReporter\IncidentReporter.NotificationSender\DAL\Events\EventHandler.cs:line 474


message: Nullable object must have a value.

stackTrace:
System.InvalidOperationException: Nullable object must have a value.
   at System.ThrowHelper.ThrowInvalidOperationException(ExceptionResource resource)
   at System.Nullable`1.get_Value()
   at IncidentReporter.NotificationSender.DAL.Events.Notifier.SendNotificationToBatchParticipantsForCompletedStatus(Int64 batchId) in C:\Gitlab-Runner\builds\pmbcEkqkx\1\incident-reporter\incident-reporter-api\IncidentReporter\IncidentReporter.NotificationSender\DAL\Events\Notifier.cs:line 3182
   at IncidentReporter.NotificationSender.DAL.Events.EventHandler.HandleMessage(IMessage message) in C:\Gitlab-Runner\builds\pmbcEkqkx\1\incident-reporter\incident-reporter-api\IncidentReporter\IncidentReporter.NotificationSender\DAL\Events\EventHandler.cs:line 474


stackTrace:
System.InvalidCastException: Unable to cast object of type 'System.Int64' to type 'System.String'.
   at IncidentReporter.NotificationSender.Models.Event.Get[T](String strKey) in C:\Gitlab-Runner\builds\pmbcEkqkx\1\incident-reporter\incident-reporter-api\IncidentReporter\IncidentReporter.NotificationSender\Models\Event.cs:line 71
   at IncidentReporter.NotificationSender.DAL.Events.EventHandler.HandleMessage(IMessage message) in C:\Gitlab-Runner\builds\pmbcEkqkx\1\incident-reporter\incident-reporter-api\IncidentReporter\IncidentReporter.NotificationSender\DAL\Events\EventHandler.cs:line 1040