level: Error

severity: ERROR

stackTrace:
System.NullReferenceException: Object reference not set to an instance of an object.
   at IncidentReporter.NotificationSender.EmailHelper.SendEmail(String template, String subject, Object args, String toAddress, String ccAddress, List`1 reportAttachments, List`1 additionalAttachmentsFilePath, String rootEmailTemplatePath, OrganisationFromConfig organisationFromAddress) in C:\GitLab-Runner\builds\27n6lYj0J\0\incident-reporter\incident-reporter-api\IncidentReporter\IncidentReporter.NotificationSender\Helpers\EmailHelper.cs:line 39


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


stackTrace:
MySql.Data.MySqlClient.MySqlException (0x80004005): Column 'notification_body' cannot be null
   at MySql.Data.MySqlClient.MySqlStream.ReadPacket()
   at MySql.Data.MySqlClient.NativeDriver.GetResult(Int32& affectedRow, Int64& insertedId)
   at MySql.Data.MySqlClient.Driver.GetResult(Int32 statementId, Int32& affectedRows, Int64& insertedId)
   at MySql.Data.MySqlClient.Driver.NextResult(Int32 statementId, Boolean force)
   at MySql.Data.MySqlClient.MySqlDataReader.NextResult()
   at MySql.Data.MySqlClient.MySqlCommand.ExecuteReader(CommandBehavior behavior)
   at MySql.Data.MySqlClient.MySqlCommand.ExecuteNonQuery()
   at Dapper.SqlMapper.ExecuteImpl(IDbConnection cnn, CommandDefinition& command)
   at IncidentReporter.DAL.Repositories.NotificationsRepo.BulkInsertUserModuleNotification(IEnumerable`1 userNotifications) in C:\GitLab-Runner\builds\27n6lYj0J\0\incident-reporter\incident-reporter-api\IncidentReporter\IncidentReporter.DAL\Repositories\NotificationsRepo.cs:line 1041
   at IncidentReporter.NotificationSender.Helpers.AddUserModuleNotificationHelper.AddUserModuleNotification(Int32 orgId, Int32 entityId, List`1 userIds, Dictionary`2 userTemplateContent, Int32 acmModuleId, UserModuleNotificationType notificationType, Int32 createdById, String conn, String viewLink) in C:\GitLab-Runner\builds\27n6lYj0J\0\incident-reporter\incident-reporter-api\IncidentReporter\IncidentReporter.NotificationSender\Helpers\AddUserModuleNotificationHelper.cs:line 120


stackTrace:
MySql.Data.MySqlClient.MySqlException (0x80004005): Column 'notification_body' cannot be null
   at MySql.Data.MySqlClient.MySqlStream.ReadPacket()
   at MySql.Data.MySqlClient.NativeDriver.GetResult(Int32& affectedRow, Int64& insertedId)
   at MySql.Data.MySqlClient.Driver.GetResult(Int32 statementId, Int32& affectedRows, Int64& insertedId)
   at MySql.Data.MySqlClient.Driver.NextResult(Int32 statementId, Boolean force)
   at MySql.Data.MySqlClient.MySqlDataReader.NextResult()
   at MySql.Data.MySqlClient.MySqlCommand.ExecuteReader(CommandBehavior behavior)
   at MySql.Data.MySqlClient.MySqlCommand.ExecuteNonQuery()
   at Dapper.SqlMapper.ExecuteImpl(IDbConnection cnn, CommandDefinition& command)
   at IncidentReporter.DAL.Repositories.NotificationsRepo.BulkInsertUserModuleNotification(IEnumerable`1 userNotifications) in C:\GitLab-Runner\builds\27n6lYj0J\0\incident-reporter\incident-reporter-api\IncidentReporter\IncidentReporter.DAL\Repositories\NotificationsRepo.cs:line 1041
   at IncidentReporter.NotificationSender.Helpers.AddUserModuleNotificationHelper.AddUserModuleNotification(Int32 orgId, Int32 entityId, List`1 userIds, Dictionary`2 userTemplateContent, Int32 acmModuleId, UserModuleNotificationType notificationType, Int32 createdById, String conn, String viewLink) in C:\GitLab-Runner\builds\27n6lYj0J\0\incident-reporter\incident-reporter-api\IncidentReporter\IncidentReporter.NotificationSender\Helpers\AddUserModuleNotificationHelper.cs:line 125
   at IncidentReporter.NotificationSender.DAL.Events.Notifier.SendWorkPermitApprovedInformToRolesNotification(String eventName, String userId, String workPermitId, String workPermitUid, String siteName, String organisationName, String approvedOn, Int64 orgId) in C:\GitLab-Runner\builds\27n6lYj0J\0\incident-reporter\incident-reporter-api\IncidentReporter\IncidentReporter.NotificationSender\DAL\Events\Notifier.cs:line 15205
   at IncidentReporter.NotificationSender.DAL.Events.EventHandler.HandleMessage(IMessage message) in C:\GitLab-Runner\builds\27n6lYj0J\0\incident-reporter\incident-reporter-api\IncidentReporter\IncidentReporter.NotificationSender\DAL\Events\EventHandler.cs:line 1839


stackTrace:
System.NullReferenceException: Object reference not set to an instance of an object.
   at IncidentReporter.NotificationSender.DAL.Events.Notifier.SendNotificationToEitherReviewerOrApprover(String eventName, Int64 ptwId, Int64 orgId, String stringUserIds, String stringPrevStateUserIds, String stringReceieveAllPtwUserIds, String workPermitStatus, String jobType, String statusChangeUserDisplayName, String permitToWorkUId, String startDate, String statusChangedTime, String workLocation, String assignToUserDisplayName, String nextStatus, String siteName, String modeOfNotifications, String customStatusJson, String companyUsersEmails) in C:\GitLab-Runner\builds\27n6lYj0J\0\incident-reporter\incident-reporter-api\IncidentReporter\IncidentReporter.NotificationSender\DAL\Events\Notifier.cs:line 4196
   at IncidentReporter.NotificationSender.DAL.Events.EventHandler.HandleMessage(IMessage message) in C:\GitLab-Runner\builds\27n6lYj0J\0\incident-reporter\incident-reporter-api\IncidentReporter\IncidentReporter.NotificationSender\DAL\Events\EventHandler.cs:line 589