level: Error

severity: ERROR

message: Nullable object must have a value.

stackTrace:
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 3321
   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 2679
   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 441


message: Nullable object must have a value.

stackTrace:
System.InvalidOperationException: Nullable object must have a value.
   at System.ThrowHelper.ThrowInvalidOperationException(ExceptionResource resource)
   at IncidentReporter.NotificationSender.DAL.Events.Notifier.<SendIncidentClosureNotification>d__116.MoveNext() in C:\GitLab-Runner\builds\27n6lYj0J\0\incident-reporter\incident-reporter-api\IncidentReporter\IncidentReporter.NotificationSender\DAL\Events\Notifier.cs:line 0
--- 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()


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:
System.IO.FileNotFoundException: Could not find file 'D:\App-Data\iis\api-qa-staging.oqsha.com\api-qa-staging.oqsha.com\Apps\NotificationSender\PssrAssignmentEmail.html'.
File name: 'D:\App-Data\iis\api-qa-staging.oqsha.com\api-qa-staging.oqsha.com\Apps\NotificationSender\PssrAssignmentEmail.html'
   at System.IO.__Error.WinIOError(Int32 errorCode, String maybeFullPath)
   at System.IO.FileStream.Init(String path, FileMode mode, FileAccess access, Int32 rights, Boolean useRights, FileShare share, Int32 bufferSize, FileOptions options, SECURITY_ATTRIBUTES secAttrs, String msgPath, Boolean bFromProxy, Boolean useLongPath, Boolean checkHost)
   at System.IO.FileStream..ctor(String path, FileMode mode, FileAccess access, FileShare share, Int32 bufferSize, FileOptions options, String msgPath, Boolean bFromProxy, Boolean useLongPath, Boolean checkHost)
   at System.IO.StreamReader..ctor(String path, Encoding encoding, Boolean detectEncodingFromByteOrderMarks, Int32 bufferSize, Boolean checkHost)
   at System.IO.File.InternalReadAllText(String path, Encoding encoding, Boolean checkHost)
   at System.IO.File.ReadAllText(String path)
   at IncidentReporter.NotificationSender.EmailHelper.ReadFile(String template, String rootEmailTemplatePath) in C:\GitLab-Runner\builds\27n6lYj0J\0\incident-reporter\incident-reporter-api\IncidentReporter\IncidentReporter.NotificationSender\Helpers\EmailHelper.cs:line 183
   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 57


message: Could not find file 'D:\App-Data\iis\api-qa-staging.oqsha.com\api-qa-staging.oqsha.com\Apps\NotificationSender\PssrAssignmentEmail.html'.


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


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 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.SendPssrAssignmentEmail(PssrAssignmentEmailContext context) in C:\GitLab-Runner\builds\27n6lYj0J\0\incident-reporter\incident-reporter-api\IncidentReporter\IncidentReporter.NotificationSender\DAL\Events\Notifier.cs:line 16120
   at IncidentReporter.NotificationSender.DAL.Events.Notifier.NotifyUserAsync(PssrAssignmentNotificationContext context) in C:\GitLab-Runner\builds\27n6lYj0J\0\incident-reporter\incident-reporter-api\IncidentReporter\IncidentReporter.NotificationSender\DAL\Events\Notifier.cs:line 16067
   at IncidentReporter.NotificationSender.DAL.Events.Notifier.<SendNotificationForPssrAssignmentAsync>d__209.MoveNext() in C:\GitLab-Runner\builds\27n6lYj0J\0\incident-reporter\incident-reporter-api\IncidentReporter\IncidentReporter.NotificationSender\DAL\Events\Notifier.cs:line 15987
--- End of stack trace from previous location where exception was thrown ---
   at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task)
   at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
   at System.Runtime.CompilerServices.TaskAwaiter.GetResult()
   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 2184


message: Column 'notification_body' cannot be null