level: Error

severity: ERROR

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


stackTrace:
System.NullReferenceException: Object reference not set to an instance of an object.
   at IncidentReporter.NotificationSender.DAL.Events.Notifier.SendTaskOpenDetailsToSiteEHS(Int64 taskId, Int64 orgId) in C:\Gitlab-Runner\builds\pmbcEkqkx\0\incident-reporter\incident-reporter-api\IncidentReporter\IncidentReporter.NotificationSender\DAL\Events\Notifier.cs:line 9593
   at IncidentReporter.NotificationSender.DAL.Events.EventHandler.HandleMessage(IMessage message) in C:\Gitlab-Runner\builds\pmbcEkqkx\0\incident-reporter\incident-reporter-api\IncidentReporter\IncidentReporter.NotificationSender\DAL\Events\EventHandler.cs:line 1271


stackTrace:
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\pmbcEkqkx\0\incident-reporter\incident-reporter-api\IncidentReporter\IncidentReporter.NotificationSender\DAL\Events\Notifier.cs:line 3721
   at IncidentReporter.NotificationSender.DAL.Events.EventHandler.HandleMessage(IMessage message) in C:\Gitlab-Runner\builds\pmbcEkqkx\0\incident-reporter\incident-reporter-api\IncidentReporter\IncidentReporter.NotificationSender\DAL\Events\EventHandler.cs:line 516


stackTrace:
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\pmbcEkqkx\1\incident-reporter\incident-reporter-api\IncidentReporter\IncidentReporter.NotificationSender\DAL\Events\Notifier.cs:line 3721
   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 516


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:
MySql.Data.MySqlClient.MySqlException (0x80004005): You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'created_by, modified_by, created_on, modified_on, status)
                VALUE' at line 3
   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.ExecuteScalar()
   at Dapper.SqlMapper.ExecuteScalarImpl[T](IDbConnection cnn, CommandDefinition& command)
   at Dapper.SqlMapper.ExecuteScalar[T](IDbConnection cnn, String sql, Object param, IDbTransaction transaction, Nullable`1 commandTimeout, Nullable`1 commandType)
   at IncidentReporter.DAL.Repositories.NotificationsRepo.InsertModuleNotification(ModuleNotificationDBO notification) in C:\Gitlab-Runner\builds\pmbcEkqkx\1\incident-reporter\incident-reporter-api\IncidentReporter\IncidentReporter.DAL\Repositories\NotificationsRepo.cs:line 779
   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\pmbcEkqkx\1\incident-reporter\incident-reporter-api\IncidentReporter\IncidentReporter.NotificationSender\Helpers\AddUserModuleNotificationHelper.cs:line 83


stackTrace:
MySql.Data.MySqlClient.MySqlException (0x80004005): You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'created_by, modified_by, created_on, modified_on, status)
                VALUE' at line 3
   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.ExecuteScalar()
   at Dapper.SqlMapper.ExecuteScalarImpl[T](IDbConnection cnn, CommandDefinition& command)
   at Dapper.SqlMapper.ExecuteScalar[T](IDbConnection cnn, String sql, Object param, IDbTransaction transaction, Nullable`1 commandTimeout, Nullable`1 commandType)
   at IncidentReporter.DAL.Repositories.NotificationsRepo.InsertModuleNotification(ModuleNotificationDBO notification) in C:\Gitlab-Runner\builds\pmbcEkqkx\1\incident-reporter\incident-reporter-api\IncidentReporter\IncidentReporter.DAL\Repositories\NotificationsRepo.cs:line 779
   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\pmbcEkqkx\1\incident-reporter\incident-reporter-api\IncidentReporter\IncidentReporter.NotificationSender\Helpers\AddUserModuleNotificationHelper.cs:line 125
   at IncidentReporter.NotificationSender.DAL.Events.Notifier.SendNotificationForWorkPermitCreation(String approverIdsJson, String workPermitId, String organisationName, String siteName, String createdByUserName, String workPermitUid, Int64 orgId) in C:\Gitlab-Runner\builds\pmbcEkqkx\1\incident-reporter\incident-reporter-api\IncidentReporter\IncidentReporter.NotificationSender\DAL\Events\Notifier.cs:line 10749
   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 1364


message:
You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'created_by, modified_by, created_on, modified_on, status)
                VALUE' at line 3


stackTrace:
MySql.Data.MySqlClient.MySqlException (0x80004005): You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'created_by, modified_by, created_on, modified_on, status)
                VALUE' at line 3
   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.ExecuteScalar()
   at Dapper.SqlMapper.ExecuteScalarImpl[T](IDbConnection cnn, CommandDefinition& command)
   at Dapper.SqlMapper.ExecuteScalar[T](IDbConnection cnn, String sql, Object param, IDbTransaction transaction, Nullable`1 commandTimeout, Nullable`1 commandType)
   at IncidentReporter.DAL.Repositories.NotificationsRepo.InsertModuleNotification(ModuleNotificationDBO notification) in C:\Gitlab-Runner\builds\pmbcEkqkx\1\incident-reporter\incident-reporter-api\IncidentReporter\IncidentReporter.DAL\Repositories\NotificationsRepo.cs:line 779
   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\pmbcEkqkx\1\incident-reporter\incident-reporter-api\IncidentReporter\IncidentReporter.NotificationSender\Helpers\AddUserModuleNotificationHelper.cs:line 125
   at IncidentReporter.NotificationSender.DAL.Events.Notifier.SendNotificationToTaskAssignees(Int64 taskId, Int64 orgId, String taskUid, String taskPriority, String taskDescription, String dueDate, String assigneeUserDetails) in C:\Gitlab-Runner\builds\pmbcEkqkx\1\incident-reporter\incident-reporter-api\IncidentReporter\IncidentReporter.NotificationSender\DAL\Events\Notifier.cs:line 5883
   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 778


stackTrace:
MySql.Data.MySqlClient.MySqlException (0x80004005): You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'created_by, modified_by, created_on, modified_on, status)
                VALUE' at line 3
   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.ExecuteScalar()
   at Dapper.SqlMapper.ExecuteScalarImpl[T](IDbConnection cnn, CommandDefinition& command)
   at Dapper.SqlMapper.ExecuteScalar[T](IDbConnection cnn, String sql, Object param, IDbTransaction transaction, Nullable`1 commandTimeout, Nullable`1 commandType)
   at IncidentReporter.DAL.Repositories.NotificationsRepo.InsertModuleNotification(ModuleNotificationDBO notification) in C:\Gitlab-Runner\builds\pmbcEkqkx\1\incident-reporter\incident-reporter-api\IncidentReporter\IncidentReporter.DAL\Repositories\NotificationsRepo.cs:line 779
   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\pmbcEkqkx\1\incident-reporter\incident-reporter-api\IncidentReporter\IncidentReporter.NotificationSender\Helpers\AddUserModuleNotificationHelper.cs:line 125
   at IncidentReporter.NotificationSender.DAL.Events.Notifier.<SendIncidentClosureNotification>d__116.MoveNext() in C:\Gitlab-Runner\builds\pmbcEkqkx\1\incident-reporter\incident-reporter-api\IncidentReporter\IncidentReporter.NotificationSender\DAL\Events\Notifier.cs:line 8944
--- 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()