System.NullReferenceException: Object reference not set to an instance of an object.
   at IncidentReporter.NotificationSender.DAL.Events.Notifier.SendUpdateIncidentNotification(Int64 incidentId, Int64 incidentHistoryId, Boolean isTicketAssigned) in C:\GitLab-Runner\builds\27n6lYj0J\0\incident-reporter\incident-reporter-api\IncidentReporter\IncidentReporter.NotificationSender\DAL\Events\Notifier.cs:line 2879
   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 456


System.NullReferenceException: Object reference not set to an instance of an object.
   at IncidentReporter.NotificationSender.DAL.Events.Notifier.<SendIncidentReopenNotification>d__117.MoveNext() in C:\GitLab-Runner\builds\27n6lYj0J\0\incident-reporter\incident-reporter-api\IncidentReporter\IncidentReporter.NotificationSender\DAL\Events\Notifier.cs:line 9105
--- End of stack trace from previous location where exception was thrown ---
   at System.Runtime.CompilerServices.AsyncMethodBuilderCore.<>c.<ThrowAsync>b__6_1(Object state)
   at System.Threading.QueueUserWorkItemCallback.WaitCallback_Context(Object state)
   at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)
   at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)
   at System.Threading.QueueUserWorkItemCallback.System.Threading.IThreadPoolWorkItem.ExecuteWorkItem()
   at System.Threading.ThreadPoolWorkQueue.Dispatch()
   at System.Threading._ThreadPoolWaitCallback.PerformWaitCallback()


System.NullReferenceException: Object reference not set to an instance of an object.
   at IncidentReporter.NotificationSender.DAL.Events.Notifier.SendNotificationToEitherReviewerOrApprover(Int64 ptwId, Int64 orgId, String stringUserIds, 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 3889
   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 553


Nullable object must have a value.

System.InvalidOperationException: Nullable object must have a value.
   at System.ThrowHelper.ThrowInvalidOperationException(ExceptionResource resource)
   at IncidentReporter.API.BLL.IncidentsBLL.GetConvertedTimeZone(IncidentDBO incident) in C:\GitLab-Runner\builds\27n6lYj0J\0\incident-reporter\incident-reporter-api\IncidentReporter\IncidentReporter.API\BLL\IncidentsBLL.cs:line 3525
   at IncidentReporter.NotificationSender.DAL.Events.Notifier.SendUpdateIncidentNotification(Int64 incidentId, Int64 incidentHistoryId, Boolean isTicketAssigned) in C:\GitLab-Runner\builds\27n6lYj0J\0\incident-reporter\incident-reporter-api\IncidentReporter\IncidentReporter.NotificationSender\DAL\Events\Notifier.cs:line 2727
   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 455


Nullable object must have a value.


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\27n6lYj0J\0\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\27n6lYj0J\0\incident-reporter\incident-reporter-api\IncidentReporter\IncidentReporter.NotificationSender\DAL\Events\EventHandler.cs:line 1106


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 802
   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


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 802
   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.<SendSafetyAlertEscalationNotification>d__234.MoveNext() in C:\GitLab-Runner\builds\27n6lYj0J\0\incident-reporter\incident-reporter-api\IncidentReporter\IncidentReporter.NotificationSender\DAL\Events\Notifier.cs:line 0


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 811
   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


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 811
   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.<SendSafetyAlertEscalationNotification>d__240.MoveNext() in C:\GitLab-Runner\builds\27n6lYj0J\0\incident-reporter\incident-reporter-api\IncidentReporter\IncidentReporter.NotificationSender\DAL\Events\Notifier.cs:line 0


System.Net.WebException: The remote server returned an error: (401) Unauthorized.
   at System.Net.HttpWebRequest.GetResponse()
   at IncidentReporter.NotificationSender.Helpers.WhatsappHelper.SendOsmoXMessage(String apiBody) in C:\GitLab-Runner\builds\27n6lYj0J\0\incident-reporter\incident-reporter-api\IncidentReporter\IncidentReporter.NotificationSender\Helpers\WhatsappHelper.cs:line 250