2025-12-21 00:01:06.0996 AlertProcessor ProcessorAlertData: started 2025-12-21 00:01:11.3809 AlertProcessor ProcessorAlertData: Stopped 2025-12-21 00:05:59.4299 DFramework.Database.Query /* Time Taken: 1043*/ [dbo].GenerateSystemAlerts 2025-12-21 00:06:06.1174 AlertProcessor ProcessorAlertData: started 2025-12-21 00:06:11.4299 AlertProcessor ProcessorAlertData: Stopped 2025-12-21 00:06:13.3675 DFramework.Scheduler.TaskBase /* Time Taken: 15515.7368*/ Opportunity Out Of Stock By Outlet 2025-12-21 00:11:06.1196 AlertProcessor ProcessorAlertData: started 2025-12-21 00:11:11.4165 AlertProcessor ProcessorAlertData: Stopped 2025-12-21 00:16:06.1217 AlertProcessor ProcessorAlertData: started 2025-12-21 00:16:11.3249 AlertProcessor ProcessorAlertData: Stopped 2025-12-21 00:20:59.7177 DFramework.Database.Query /* Time Taken: 1311*/ [dbo].GenerateSystemAlerts 2025-12-21 00:21:06.1241 AlertProcessor ProcessorAlertData: started 2025-12-21 00:21:09.0772 DFramework.Database.Query /* Time Taken: 1681*/ DECLARE @StatusId Int32 SET @StatusId = '1' DECLARE @AlertId Int32 SET @AlertId = '7571914' SELECT TOP 10000 Alert.AlertId, Alert.LocationId, Alert.RecordId, ISNULL(AlertDefinition.Name, Alert.AlertText) Name, Alert.AlertTypeId, Alert.AlertText, ISNULL(Location.Name, '') AS LocationName, AlertDefinition.ClientId, AlertRecipient.RoleId, CASE WHEN Alert.AlertTypeId IN (6,7) THEN CONVERT(VARCHAR(10), CAST(AlertAt AS DATE), 101) ELSE AlertAt END AS AlertAt, AlertType, Asset.SerialNumber, ISNULL(LocationAttribute.FirstRepId, 0) RepId, ClientUser.PrimaryPhone AS SalesRepPhone, ClientUser.PrimaryEmail AS SalesRepEmail, FirstName, LastName, PreferedNotificationTypeIds, AlertRecipientId, AlertRecipientAddress, AlertRecipientText, Alert.Tags, AlertRecipientTypeId, NotificationContactTypeId, TemplateId, AlertDefinition.AlertAgeThreshold, LastUpdatedOn, AlertRecipient.AlertAge, CASE WHEN Location.TimeZoneId IS NOT NULL AND Location.TimeZoneId > 0 THEN Location.TimeZoneId ELSE Client.TimeZoneId END AS TimeZoneId, AlertDefinition.IsSummarize, Alert.ClosedOn, AssetType.IsChestCooler, AlertDefinition.SnoozeForHours, Alert.SnoozeDateTime FROM Alert LEFT OUTER JOIN Asset ON Alert.AssetId = Asset.AssetId LEFT OUTER JOIN AlertType ON Alert.AlertTypeId = AlertType.AlertTypeId LEFT OUTER JOIN AlertDefinition ON Alert.AlertDefinitionId = AlertDefinition.AlertDefinitionId LEFT OUTER JOIN Location ON Location.LocationId = Alert.LocationId LEFT OUTER JOIN LocationAttribute ON LocationAttribute.LocationId = dbo.Location.LocationId LEFT OUTER JOIN ClientUser ON LocationAttribute.FirstRepId = ClientUser.ClientUserId AND ClientUser.IsDeleted = 0 LEFT OUTER JOIN AlertRecipient ON Alert.AlertDefinitionId = AlertRecipient.AlertDefinitionId AND AlertRecipient.IsDeleted= 0 LEFT OUTER JOIN Client ON Client.ClientId = Alert.ClientId LEFT OUTER JOIN AssetType ON dbo.Asset.AssetTypeId = dbo.AssetType.AssetTypeId WHERE (NOT EXISTS(SELECT 1 FROM dbo.EmailQueue INNER JOIN dbo.EmailRecipient ON EmailRecipient.EmailQueueId = EmailQueue.EmailQueueId WHERE AlertId = Alert.AlertId AND EmailRecipient.RecipientId = AlertRecipient.AlertRecipientId) OR (Alert.SnoozeDateTime IS NOT NULL AND Alert.SnoozeDateTime <= GETUTCDATE() AND AlertDefinition.SnoozeForHours > 0 AND Alert.StatusId = @StatusId)) AND Alert.AlertId > @AlertId AND Alert.AlertAt >= DATEADD(DAY, -120, GETDATE()) AND AlertRecipient.IsDeleted = 0 AND Alert.IsActive = 1 AND Alert.IsDeleted = 0 AND AlertRecipient.IsActive = 1 AND AlertRecipient.IsDeleted = 0 AND AlertRecipient.StartDate <= Alert.CreatedOn AND Alert.CreatedOn < DATEADD(hh, 23, AlertRecipient.EndDate) AND (Alert.LocationId != 0 OR NotificationWithoutLocation = 1) AND AlertType.IsSystemAlert = 0 AND Alert.EmailQueuedOn IS NULL AND AlertDefinition.IsActive = 1 2025-12-21 00:21:11.9366 AlertProcessor ProcessorAlertData: Stopped 2025-12-21 00:21:13.4679 DFramework.Scheduler.TaskBase /* Time Taken: 15593.8753*/ Opportunity Out Of Stock By Outlet 2025-12-21 00:26:06.1263 AlertProcessor ProcessorAlertData: started 2025-12-21 00:26:11.2982 AlertProcessor ProcessorAlertData: Stopped 2025-12-21 00:31:06.1285 AlertProcessor ProcessorAlertData: started 2025-12-21 00:31:11.4879 AlertProcessor ProcessorAlertData: Stopped 2025-12-21 00:35:59.8025 DFramework.Database.Query /* Time Taken: 1384*/ [dbo].GenerateSystemAlerts 2025-12-21 00:36:06.1307 AlertProcessor ProcessorAlertData: started 2025-12-21 00:36:11.3964 AlertProcessor ProcessorAlertData: Stopped 2025-12-21 00:36:13.6933 DFramework.Scheduler.TaskBase /* Time Taken: 15797.0001*/ Opportunity Out Of Stock By Outlet 2025-12-21 00:41:06.1330 AlertProcessor ProcessorAlertData: started 2025-12-21 00:41:11.4299 AlertProcessor ProcessorAlertData: Stopped 2025-12-21 00:46:06.1352 AlertProcessor ProcessorAlertData: started 2025-12-21 00:46:11.2914 AlertProcessor ProcessorAlertData: Stopped 2025-12-21 00:50:59.4967 DFramework.Database.Query /* Time Taken: 1049*/ [dbo].GenerateSystemAlerts 2025-12-21 00:51:06.1530 AlertProcessor ProcessorAlertData: started 2025-12-21 00:51:11.3249 AlertProcessor ProcessorAlertData: Stopped 2025-12-21 00:51:13.4655 DFramework.Scheduler.TaskBase /* Time Taken: 15546.9855*/ Opportunity Out Of Stock By Outlet 2025-12-21 00:56:06.1552 AlertProcessor ProcessorAlertData: started 2025-12-21 00:56:11.5303 AlertProcessor ProcessorAlertData: Stopped 2025-12-21 01:01:06.1574 AlertProcessor ProcessorAlertData: started 2025-12-21 01:01:11.4075 AlertProcessor ProcessorAlertData: Stopped 2025-12-21 01:05:59.4721 DFramework.Database.Query /* Time Taken: 1001*/ [dbo].GenerateSystemAlerts 2025-12-21 01:06:06.1596 AlertProcessor ProcessorAlertData: started 2025-12-21 01:06:11.2222 AlertProcessor ProcessorAlertData: Stopped 2025-12-21 01:06:13.5659 DFramework.Scheduler.TaskBase /* Time Taken: 15625.1121*/ Opportunity Out Of Stock By Outlet 2025-12-21 01:11:06.1775 AlertProcessor ProcessorAlertData: started 2025-12-21 01:11:11.4432 AlertProcessor ProcessorAlertData: Stopped 2025-12-21 01:16:06.1955 AlertProcessor ProcessorAlertData: started 2025-12-21 01:16:11.4299 AlertProcessor ProcessorAlertData: Stopped 2025-12-21 01:20:59.5414 DFramework.Database.Query /* Time Taken: 1056*/ [dbo].GenerateSystemAlerts 2025-12-21 01:21:06.2133 AlertProcessor ProcessorAlertData: started 2025-12-21 01:21:11.5259 AlertProcessor ProcessorAlertData: Stopped 2025-12-21 01:21:13.7446 DFramework.Scheduler.TaskBase /* Time Taken: 15781.3625*/ Opportunity Out Of Stock By Outlet 2025-12-21 01:26:06.2311 AlertProcessor ProcessorAlertData: started 2025-12-21 01:26:11.5437 AlertProcessor ProcessorAlertData: Stopped 2025-12-21 01:31:06.2484 AlertProcessor ProcessorAlertData: started 2025-12-21 01:31:06.8422 DFramework.Database.Query /* Time Taken: 587*/ DECLARE @TableName AnsiString(8000) SET @TableName = 'TagAlert' DECLARE @CurrentRecordId Int32 SET @CurrentRecordId = '0' dbo.GetValidDeviceForAlertProcessData 2025-12-21 01:31:13.4984 DFramework.Database.Query /* Time Taken: 512*/ DECLARE @TableName AnsiString(8000) SET @TableName = 'ProductStockLevel' DECLARE @CurrentRecordId Int32 SET @CurrentRecordId = '3674617' dbo.GetValidDeviceForAlertProcessData 2025-12-21 01:31:13.5453 AlertProcessor ProcessorAlertData: Stopped 2025-12-21 01:35:59.7660 DFramework.Database.Query /* Time Taken: 1263*/ [dbo].GenerateSystemAlerts 2025-12-21 01:36:06.2660 AlertProcessor ProcessorAlertData: started 2025-12-21 01:36:11.6411 AlertProcessor ProcessorAlertData: Stopped 2025-12-21 01:36:13.5161 DFramework.Scheduler.TaskBase /* Time Taken: 15531.3651*/ Opportunity Out Of Stock By Outlet 2025-12-21 01:41:06.2838 AlertProcessor ProcessorAlertData: started 2025-12-21 01:41:11.5494 AlertProcessor ProcessorAlertData: Stopped 2025-12-21 01:46:06.2855 AlertProcessor ProcessorAlertData: started 2025-12-21 01:46:11.4418 AlertProcessor ProcessorAlertData: Stopped 2025-12-21 01:50:59.8185 DFramework.Database.Query /* Time Taken: 1284*/ [dbo].GenerateSystemAlerts 2025-12-21 01:51:06.3029 AlertProcessor ProcessorAlertData: started 2025-12-21 01:51:08.1623 DFramework.Database.Query /* Time Taken: 545*/ DECLARE @StatusId Int32 SET @StatusId = '1' DECLARE @AlertId Int32 SET @AlertId = '7571914' SELECT TOP 10000 Alert.AlertId, Alert.LocationId, Alert.RecordId, ISNULL(AlertDefinition.Name, Alert.AlertText) Name, Alert.AlertTypeId, Alert.AlertText, ISNULL(Location.Name, '') AS LocationName, AlertDefinition.ClientId, AlertRecipient.RoleId, CASE WHEN Alert.AlertTypeId IN (6,7) THEN CONVERT(VARCHAR(10), CAST(AlertAt AS DATE), 101) ELSE AlertAt END AS AlertAt, AlertType, Asset.SerialNumber, ISNULL(LocationAttribute.FirstRepId, 0) RepId, ClientUser.PrimaryPhone AS SalesRepPhone, ClientUser.PrimaryEmail AS SalesRepEmail, FirstName, LastName, PreferedNotificationTypeIds, AlertRecipientId, AlertRecipientAddress, AlertRecipientText, Alert.Tags, AlertRecipientTypeId, NotificationContactTypeId, TemplateId, AlertDefinition.AlertAgeThreshold, LastUpdatedOn, AlertRecipient.AlertAge, CASE WHEN Location.TimeZoneId IS NOT NULL AND Location.TimeZoneId > 0 THEN Location.TimeZoneId ELSE Client.TimeZoneId END AS TimeZoneId, AlertDefinition.IsSummarize, Alert.ClosedOn, AssetType.IsChestCooler, AlertDefinition.SnoozeForHours, Alert.SnoozeDateTime FROM Alert LEFT OUTER JOIN Asset ON Alert.AssetId = Asset.AssetId LEFT OUTER JOIN AlertType ON Alert.AlertTypeId = AlertType.AlertTypeId LEFT OUTER JOIN AlertDefinition ON Alert.AlertDefinitionId = AlertDefinition.AlertDefinitionId LEFT OUTER JOIN Location ON Location.LocationId = Alert.LocationId LEFT OUTER JOIN LocationAttribute ON LocationAttribute.LocationId = dbo.Location.LocationId LEFT OUTER JOIN ClientUser ON LocationAttribute.FirstRepId = ClientUser.ClientUserId AND ClientUser.IsDeleted = 0 LEFT OUTER JOIN AlertRecipient ON Alert.AlertDefinitionId = AlertRecipient.AlertDefinitionId AND AlertRecipient.IsDeleted= 0 LEFT OUTER JOIN Client ON Client.ClientId = Alert.ClientId LEFT OUTER JOIN AssetType ON dbo.Asset.AssetTypeId = dbo.AssetType.AssetTypeId WHERE (NOT EXISTS(SELECT 1 FROM dbo.EmailQueue INNER JOIN dbo.EmailRecipient ON EmailRecipient.EmailQueueId = EmailQueue.EmailQueueId WHERE AlertId = Alert.AlertId AND EmailRecipient.RecipientId = AlertRecipient.AlertRecipientId) OR (Alert.SnoozeDateTime IS NOT NULL AND Alert.SnoozeDateTime <= GETUTCDATE() AND AlertDefinition.SnoozeForHours > 0 AND Alert.StatusId = @StatusId)) AND Alert.AlertId > @AlertId AND Alert.AlertAt >= DATEADD(DAY, -120, GETDATE()) AND AlertRecipient.IsDeleted = 0 AND Alert.IsActive = 1 AND Alert.IsDeleted = 0 AND AlertRecipient.IsActive = 1 AND AlertRecipient.IsDeleted = 0 AND AlertRecipient.StartDate <= Alert.CreatedOn AND Alert.CreatedOn < DATEADD(hh, 23, AlertRecipient.EndDate) AND (Alert.LocationId != 0 OR NotificationWithoutLocation = 1) AND AlertType.IsSystemAlert = 0 AND Alert.EmailQueuedOn IS NULL AND AlertDefinition.IsActive = 1 2025-12-21 01:51:11.6467 AlertProcessor ProcessorAlertData: Stopped 2025-12-21 01:51:13.5999 DFramework.Scheduler.TaskBase /* Time Taken: 15593.854*/ Opportunity Out Of Stock By Outlet 2025-12-21 01:56:06.3206 AlertProcessor ProcessorAlertData: started 2025-12-21 01:56:11.4300 AlertProcessor ProcessorAlertData: Stopped 2025-12-21 02:01:06.3383 AlertProcessor ProcessorAlertData: started 2025-12-21 02:01:11.5414 AlertProcessor ProcessorAlertData: Stopped 2025-12-21 02:05:59.9180 DFramework.Database.Query /* Time Taken: 1363*/ [dbo].GenerateSystemAlerts 2025-12-21 02:06:06.3556 AlertProcessor ProcessorAlertData: started 2025-12-21 02:06:09.1837 DFramework.Database.Query /* Time Taken: 516*/ DECLARE @TableName AnsiString(8000) SET @TableName = 'AssetStockProductWiseConsolidate' DECLARE @CurrentRecordId Int32 SET @CurrentRecordId = '3674617' dbo.GetValidDeviceForAlertProcessData 2025-12-21 02:06:12.0119 AlertProcessor ProcessorAlertData: Stopped 2025-12-21 02:06:13.6681 DFramework.Scheduler.TaskBase /* Time Taken: 15640.7297*/ Opportunity Out Of Stock By Outlet 2025-12-21 02:11:06.3732 AlertProcessor ProcessorAlertData: started 2025-12-21 02:11:11.7795 AlertProcessor ProcessorAlertData: Stopped 2025-12-21 02:16:06.3910 AlertProcessor ProcessorAlertData: started 2025-12-21 02:16:08.7191 DFramework.Database.NullableDataReader Data reader open for 280 at System.Environment.GetStackTrace(Exception e, Boolean needFileInfo) at System.Environment.get_StackTrace() at DFramework.Database.NullableDataReader.Dispose(Boolean disposing) in D:\Spraxa\Framework\DFramework\Database\NullableDataReader.cs:line 33 at DFramework.Database.NullableDataReader.Dispose() in D:\Spraxa\Framework\DFramework\Database\NullableDataReader.cs:line 44 at CoolR.Tasks.ProcessAlertData.Execute() in D:\Spraxa\CoolR-Group\portal\CoolR.Tasks\ProcessAlertData.cs:line 47 at DFramework.Scheduler.TaskBase.Run() in D:\Spraxa\Framework\DFramework.Scheduler\TaskBase.cs:line 176 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.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state) at System.Threading.ThreadHelper.ThreadStart() 2025-12-21 02:16:11.8442 AlertProcessor ProcessorAlertData: Stopped 2025-12-21 02:20:59.6424 DFramework.Database.Query /* Time Taken: 1067*/ [dbo].GenerateSystemAlerts 2025-12-21 02:21:06.3924 AlertProcessor ProcessorAlertData: started 2025-12-21 02:21:11.6268 AlertProcessor ProcessorAlertData: Stopped 2025-12-21 02:21:13.6268 DFramework.Scheduler.TaskBase /* Time Taken: 15578.1991*/ Opportunity Out Of Stock By Outlet 2025-12-21 02:26:06.3942 AlertProcessor ProcessorAlertData: started 2025-12-21 02:26:11.6755 AlertProcessor ProcessorAlertData: Stopped 2025-12-21 02:31:06.4119 AlertProcessor ProcessorAlertData: started 2025-12-21 02:31:11.5994 AlertProcessor ProcessorAlertData: Stopped 2025-12-21 02:35:59.7575 DFramework.Database.Query /* Time Taken: 1156*/ [dbo].GenerateSystemAlerts 2025-12-21 02:36:06.4294 AlertProcessor ProcessorAlertData: started 2025-12-21 02:36:11.7263 AlertProcessor ProcessorAlertData: Stopped 2025-12-21 02:36:13.6325 DFramework.Scheduler.TaskBase /* Time Taken: 15578.1924*/ Opportunity Out Of Stock By Outlet 2025-12-21 02:41:06.4467 AlertProcessor ProcessorAlertData: started 2025-12-21 02:41:11.7592 AlertProcessor ProcessorAlertData: Stopped 2025-12-21 02:46:06.4487 AlertProcessor ProcessorAlertData: started 2025-12-21 02:46:11.8394 AlertProcessor ProcessorAlertData: Stopped 2025-12-21 02:50:59.6695 DFramework.Database.Query /* Time Taken: 1059*/ [dbo].GenerateSystemAlerts 2025-12-21 02:51:06.4508 AlertProcessor ProcessorAlertData: started 2025-12-21 02:51:11.8259 AlertProcessor ProcessorAlertData: Stopped 2025-12-21 02:51:13.7009 DFramework.Scheduler.TaskBase /* Time Taken: 15640.7329*/ Opportunity Out Of Stock By Outlet 2025-12-21 02:56:06.4680 AlertProcessor ProcessorAlertData: started 2025-12-21 02:56:11.7804 AlertProcessor ProcessorAlertData: Stopped 2025-12-21 03:01:06.4854 AlertProcessor ProcessorAlertData: started 2025-12-21 03:01:11.9386 AlertProcessor ProcessorAlertData: Stopped 2025-12-21 03:05:59.8312 DFramework.Database.Query /* Time Taken: 1193*/ [dbo].GenerateSystemAlerts 2025-12-21 03:06:06.5031 AlertProcessor ProcessorAlertData: started 2025-12-21 03:06:11.4250 AlertProcessor ProcessorAlertData: Stopped 2025-12-21 03:06:13.5969 DFramework.Scheduler.TaskBase /* Time Taken: 15515.7412*/ Opportunity Out Of Stock By Outlet 2025-12-21 03:11:06.5205 AlertProcessor ProcessorAlertData: started 2025-12-21 03:11:11.6142 AlertProcessor ProcessorAlertData: Stopped 2025-12-21 03:16:06.5378 AlertProcessor ProcessorAlertData: started 2025-12-21 03:16:07.5691 DFramework.Database.Query /* Time Taken: 630*/ DECLARE @TableName AnsiString(8000) SET @TableName = 'VoidAlert' DECLARE @CurrentRecordId Int32 SET @CurrentRecordId = '3674617' dbo.GetValidDeviceForAlertProcessData 2025-12-21 03:16:11.8816 AlertProcessor ProcessorAlertData: Stopped 2025-12-21 03:20:59.9304 DFramework.Database.Query /* Time Taken: 1273*/ [dbo].GenerateSystemAlerts 2025-12-21 03:21:06.5398 AlertProcessor ProcessorAlertData: started 2025-12-21 03:21:09.4461 DFramework.Database.Query /* Time Taken: 1626*/ DECLARE @StatusId Int32 SET @StatusId = '1' DECLARE @AlertId Int32 SET @AlertId = '7571914' SELECT TOP 10000 Alert.AlertId, Alert.LocationId, Alert.RecordId, ISNULL(AlertDefinition.Name, Alert.AlertText) Name, Alert.AlertTypeId, Alert.AlertText, ISNULL(Location.Name, '') AS LocationName, AlertDefinition.ClientId, AlertRecipient.RoleId, CASE WHEN Alert.AlertTypeId IN (6,7) THEN CONVERT(VARCHAR(10), CAST(AlertAt AS DATE), 101) ELSE AlertAt END AS AlertAt, AlertType, Asset.SerialNumber, ISNULL(LocationAttribute.FirstRepId, 0) RepId, ClientUser.PrimaryPhone AS SalesRepPhone, ClientUser.PrimaryEmail AS SalesRepEmail, FirstName, LastName, PreferedNotificationTypeIds, AlertRecipientId, AlertRecipientAddress, AlertRecipientText, Alert.Tags, AlertRecipientTypeId, NotificationContactTypeId, TemplateId, AlertDefinition.AlertAgeThreshold, LastUpdatedOn, AlertRecipient.AlertAge, CASE WHEN Location.TimeZoneId IS NOT NULL AND Location.TimeZoneId > 0 THEN Location.TimeZoneId ELSE Client.TimeZoneId END AS TimeZoneId, AlertDefinition.IsSummarize, Alert.ClosedOn, AssetType.IsChestCooler, AlertDefinition.SnoozeForHours, Alert.SnoozeDateTime FROM Alert LEFT OUTER JOIN Asset ON Alert.AssetId = Asset.AssetId LEFT OUTER JOIN AlertType ON Alert.AlertTypeId = AlertType.AlertTypeId LEFT OUTER JOIN AlertDefinition ON Alert.AlertDefinitionId = AlertDefinition.AlertDefinitionId LEFT OUTER JOIN Location ON Location.LocationId = Alert.LocationId LEFT OUTER JOIN LocationAttribute ON LocationAttribute.LocationId = dbo.Location.LocationId LEFT OUTER JOIN ClientUser ON LocationAttribute.FirstRepId = ClientUser.ClientUserId AND ClientUser.IsDeleted = 0 LEFT OUTER JOIN AlertRecipient ON Alert.AlertDefinitionId = AlertRecipient.AlertDefinitionId AND AlertRecipient.IsDeleted= 0 LEFT OUTER JOIN Client ON Client.ClientId = Alert.ClientId LEFT OUTER JOIN AssetType ON dbo.Asset.AssetTypeId = dbo.AssetType.AssetTypeId WHERE (NOT EXISTS(SELECT 1 FROM dbo.EmailQueue INNER JOIN dbo.EmailRecipient ON EmailRecipient.EmailQueueId = EmailQueue.EmailQueueId WHERE AlertId = Alert.AlertId AND EmailRecipient.RecipientId = AlertRecipient.AlertRecipientId) OR (Alert.SnoozeDateTime IS NOT NULL AND Alert.SnoozeDateTime <= GETUTCDATE() AND AlertDefinition.SnoozeForHours > 0 AND Alert.StatusId = @StatusId)) AND Alert.AlertId > @AlertId AND Alert.AlertAt >= DATEADD(DAY, -120, GETDATE()) AND AlertRecipient.IsDeleted = 0 AND Alert.IsActive = 1 AND Alert.IsDeleted = 0 AND AlertRecipient.IsActive = 1 AND AlertRecipient.IsDeleted = 0 AND AlertRecipient.StartDate <= Alert.CreatedOn AND Alert.CreatedOn < DATEADD(hh, 23, AlertRecipient.EndDate) AND (Alert.LocationId != 0 OR NotificationWithoutLocation = 1) AND AlertType.IsSystemAlert = 0 AND Alert.EmailQueuedOn IS NULL AND AlertDefinition.IsActive = 1 2025-12-21 03:21:12.2742 AlertProcessor ProcessorAlertData: Stopped 2025-12-21 03:21:13.7118 DFramework.Scheduler.TaskBase /* Time Taken: 15609.4869*/ Opportunity Out Of Stock By Outlet 2025-12-21 03:26:06.5575 AlertProcessor ProcessorAlertData: started 2025-12-21 03:26:12.0107 AlertProcessor ProcessorAlertData: Stopped 2025-12-21 03:31:06.5747 AlertProcessor ProcessorAlertData: started 2025-12-21 03:31:11.6216 AlertProcessor ProcessorAlertData: Stopped 2025-12-21 03:36:00.1704 DFramework.Database.Query /* Time Taken: 1486*/ [dbo].GenerateSystemAlerts 2025-12-21 03:36:06.5767 AlertProcessor ProcessorAlertData: started 2025-12-21 03:36:11.4830 AlertProcessor ProcessorAlertData: Stopped 2025-12-21 03:36:13.6392 DFramework.Scheduler.TaskBase /* Time Taken: 15515.7305*/ Opportunity Out Of Stock By Outlet 2025-12-21 03:41:06.5788 AlertProcessor ProcessorAlertData: started 2025-12-21 03:41:11.5163 AlertProcessor ProcessorAlertData: Stopped 2025-12-21 03:46:06.5804 AlertProcessor ProcessorAlertData: started 2025-12-21 03:46:11.3773 AlertProcessor ProcessorAlertData: Stopped 2025-12-21 03:50:59.6135 DFramework.Database.Query /* Time Taken: 909*/ [dbo].GenerateSystemAlerts 2025-12-21 03:51:06.5979 AlertProcessor ProcessorAlertData: started 2025-12-21 03:51:11.4729 AlertProcessor ProcessorAlertData: Stopped 2025-12-21 03:51:13.6761 DFramework.Scheduler.TaskBase /* Time Taken: 15546.9664*/ Opportunity Out Of Stock By Outlet 2025-12-21 03:56:06.6156 AlertProcessor ProcessorAlertData: started 2025-12-21 03:56:11.4906 AlertProcessor ProcessorAlertData: Stopped 2025-12-21 04:01:06.6331 AlertProcessor ProcessorAlertData: started 2025-12-21 04:01:11.5550 AlertProcessor ProcessorAlertData: Stopped 2025-12-21 04:05:59.7129 DFramework.Database.Query /* Time Taken: 1000*/ [dbo].GenerateSystemAlerts 2025-12-21 04:06:06.6504 AlertProcessor ProcessorAlertData: started 2025-12-21 04:06:11.3849 AlertProcessor ProcessorAlertData: Stopped 2025-12-21 04:06:13.6661 DFramework.Scheduler.TaskBase /* Time Taken: 15515.7223*/ Opportunity Out Of Stock By Outlet 2025-12-21 04:11:06.6681 AlertProcessor ProcessorAlertData: started 2025-12-21 04:11:11.9337 AlertProcessor ProcessorAlertData: Stopped 2025-12-21 04:16:06.6858 AlertProcessor ProcessorAlertData: started 2025-12-21 04:16:11.5608 AlertProcessor ProcessorAlertData: Stopped 2025-12-21 04:20:59.8590 DFramework.Database.Query /* Time Taken: 1140*/ [dbo].GenerateSystemAlerts 2025-12-21 04:21:06.7028 AlertProcessor ProcessorAlertData: started 2025-12-21 04:21:11.8747 AlertProcessor ProcessorAlertData: Stopped 2025-12-21 04:21:13.7497 DFramework.Scheduler.TaskBase /* Time Taken: 15578.2074*/ Opportunity Out Of Stock By Outlet 2025-12-21 04:26:06.7202 AlertProcessor ProcessorAlertData: started 2025-12-21 04:26:12.0953 DFramework.Database.NullableDataReader Data reader open for 277 at System.Environment.GetStackTrace(Exception e, Boolean needFileInfo) at System.Environment.get_StackTrace() at DFramework.Database.NullableDataReader.Dispose(Boolean disposing) in D:\Spraxa\Framework\DFramework\Database\NullableDataReader.cs:line 33 at DFramework.Database.NullableDataReader.Dispose() in D:\Spraxa\Framework\DFramework\Database\NullableDataReader.cs:line 44 at CoolR.Tasks.ProcessAlertData.Execute() in D:\Spraxa\CoolR-Group\portal\CoolR.Tasks\ProcessAlertData.cs:line 47 at DFramework.Scheduler.TaskBase.Run() in D:\Spraxa\Framework\DFramework.Scheduler\TaskBase.cs:line 176 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.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state) at System.Threading.ThreadHelper.ThreadStart() 2025-12-21 04:26:12.0953 AlertProcessor ProcessorAlertData: Stopped 2025-12-21 04:31:06.7223 AlertProcessor ProcessorAlertData: started 2025-12-21 04:31:11.5661 AlertProcessor ProcessorAlertData: Stopped 2025-12-21 04:35:59.7553 DFramework.Database.Query /* Time Taken: 1016*/ [dbo].GenerateSystemAlerts 2025-12-21 04:36:06.7398 AlertProcessor ProcessorAlertData: started 2025-12-21 04:36:11.8804 AlertProcessor ProcessorAlertData: Stopped 2025-12-21 04:36:13.6929 DFramework.Scheduler.TaskBase /* Time Taken: 15500.0837*/ Opportunity Out Of Stock By Outlet 2025-12-21 04:41:06.7572 AlertProcessor ProcessorAlertData: started 2025-12-21 04:41:11.9760 AlertProcessor ProcessorAlertData: Stopped 2025-12-21 04:46:06.7749 AlertProcessor ProcessorAlertData: started 2025-12-21 04:46:11.8843 AlertProcessor ProcessorAlertData: Stopped 2025-12-21 04:50:59.9019 DFramework.Database.Query /* Time Taken: 1153*/ [dbo].GenerateSystemAlerts 2025-12-21 04:51:06.7770 AlertProcessor ProcessorAlertData: started 2025-12-21 04:51:11.6676 AlertProcessor ProcessorAlertData: Stopped 2025-12-21 04:51:13.7458 DFramework.Scheduler.TaskBase /* Time Taken: 15546.983*/ Opportunity Out Of Stock By Outlet 2025-12-21 04:56:06.7786 AlertProcessor ProcessorAlertData: started 2025-12-21 04:56:12.1537 AlertProcessor ProcessorAlertData: Stopped 2025-12-21 05:01:06.7962 AlertProcessor ProcessorAlertData: started 2025-12-21 05:01:11.4994 AlertProcessor ProcessorAlertData: Stopped 2025-12-21 05:05:59.9858 DFramework.Database.Query /* Time Taken: 1216*/ [dbo].GenerateSystemAlerts 2025-12-21 05:06:06.8139 AlertProcessor ProcessorAlertData: started 2025-12-21 05:06:11.6421 AlertProcessor ProcessorAlertData: Stopped 2025-12-21 05:06:13.7359 DFramework.Scheduler.TaskBase /* Time Taken: 15515.7349*/ Opportunity Out Of Stock By Outlet 2025-12-21 05:11:06.8312 AlertProcessor ProcessorAlertData: started 2025-12-21 05:11:11.8156 AlertProcessor ProcessorAlertData: Stopped 2025-12-21 05:16:06.8486 AlertProcessor ProcessorAlertData: started 2025-12-21 05:16:11.7549 AlertProcessor ProcessorAlertData: Stopped 2025-12-21 05:20:59.8350 DFramework.Database.Query /* Time Taken: 1031*/ [dbo].GenerateSystemAlerts 2025-12-21 05:21:06.8663 AlertProcessor ProcessorAlertData: started 2025-12-21 05:21:11.8820 AlertProcessor ProcessorAlertData: Stopped 2025-12-21 05:21:13.7570 DFramework.Scheduler.TaskBase /* Time Taken: 15515.744*/ Opportunity Out Of Stock By Outlet 2025-12-21 05:26:06.8683 AlertProcessor ProcessorAlertData: started 2025-12-21 05:26:12.0402 AlertProcessor ProcessorAlertData: Stopped 2025-12-21 05:31:06.8857 AlertProcessor ProcessorAlertData: started 2025-12-21 05:31:11.6357 AlertProcessor ProcessorAlertData: Stopped 2025-12-21 05:35:59.7314 DFramework.Database.Query /* Time Taken: 921*/ [dbo].GenerateSystemAlerts 2025-12-21 05:36:06.9033 AlertProcessor ProcessorAlertData: started 2025-12-21 05:36:11.6533 AlertProcessor ProcessorAlertData: Stopped 2025-12-21 05:36:13.8252 DFramework.Scheduler.TaskBase /* Time Taken: 15578.2362*/ Opportunity Out Of Stock By Outlet 2025-12-21 05:41:06.9210 AlertProcessor ProcessorAlertData: started 2025-12-21 05:41:11.7648 AlertProcessor ProcessorAlertData: Stopped 2025-12-21 05:46:06.9383 AlertProcessor ProcessorAlertData: started 2025-12-21 05:46:11.7196 AlertProcessor ProcessorAlertData: Stopped 2025-12-21 05:50:59.7839 DFramework.Database.Query /* Time Taken: 938*/ [dbo].GenerateSystemAlerts 2025-12-21 05:51:06.9402 AlertProcessor ProcessorAlertData: started 2025-12-21 05:51:11.7372 AlertProcessor ProcessorAlertData: Stopped 2025-12-21 05:51:13.8309 DFramework.Scheduler.TaskBase /* Time Taken: 15562.6051*/ Opportunity Out Of Stock By Outlet 2025-12-21 05:56:06.9579 AlertProcessor ProcessorAlertData: started 2025-12-21 05:56:11.7704 AlertProcessor ProcessorAlertData: Stopped 2025-12-21 06:01:06.9753 AlertProcessor ProcessorAlertData: started 2025-12-21 06:01:11.8035 AlertProcessor ProcessorAlertData: Stopped 2025-12-21 06:05:59.8051 DFramework.Database.Query /* Time Taken: 939*/ [dbo].GenerateSystemAlerts 2025-12-21 06:06:06.9926 AlertProcessor ProcessorAlertData: started 2025-12-21 06:06:11.8520 AlertProcessor ProcessorAlertData: Stopped 2025-12-21 06:06:13.8052 DFramework.Scheduler.TaskBase /* Time Taken: 15515.7203*/ Opportunity Out Of Stock By Outlet 2025-12-21 06:11:07.0102 AlertProcessor ProcessorAlertData: started 2025-12-21 06:11:11.8853 AlertProcessor ProcessorAlertData: Stopped 2025-12-21 06:16:07.0123 AlertProcessor ProcessorAlertData: started 2025-12-21 06:16:11.8092 AlertProcessor ProcessorAlertData: Stopped 2025-12-21 06:21:00.0761 DFramework.Database.Query /* Time Taken: 1196*/ [dbo].GenerateSystemAlerts 2025-12-21 06:21:07.0137 AlertProcessor ProcessorAlertData: started 2025-12-21 06:21:08.8730 DFramework.Database.Query /* Time Taken: 639*/ DECLARE @StatusId Int32 SET @StatusId = '1' DECLARE @AlertId Int32 SET @AlertId = '7571914' SELECT TOP 10000 Alert.AlertId, Alert.LocationId, Alert.RecordId, ISNULL(AlertDefinition.Name, Alert.AlertText) Name, Alert.AlertTypeId, Alert.AlertText, ISNULL(Location.Name, '') AS LocationName, AlertDefinition.ClientId, AlertRecipient.RoleId, CASE WHEN Alert.AlertTypeId IN (6,7) THEN CONVERT(VARCHAR(10), CAST(AlertAt AS DATE), 101) ELSE AlertAt END AS AlertAt, AlertType, Asset.SerialNumber, ISNULL(LocationAttribute.FirstRepId, 0) RepId, ClientUser.PrimaryPhone AS SalesRepPhone, ClientUser.PrimaryEmail AS SalesRepEmail, FirstName, LastName, PreferedNotificationTypeIds, AlertRecipientId, AlertRecipientAddress, AlertRecipientText, Alert.Tags, AlertRecipientTypeId, NotificationContactTypeId, TemplateId, AlertDefinition.AlertAgeThreshold, LastUpdatedOn, AlertRecipient.AlertAge, CASE WHEN Location.TimeZoneId IS NOT NULL AND Location.TimeZoneId > 0 THEN Location.TimeZoneId ELSE Client.TimeZoneId END AS TimeZoneId, AlertDefinition.IsSummarize, Alert.ClosedOn, AssetType.IsChestCooler, AlertDefinition.SnoozeForHours, Alert.SnoozeDateTime FROM Alert LEFT OUTER JOIN Asset ON Alert.AssetId = Asset.AssetId LEFT OUTER JOIN AlertType ON Alert.AlertTypeId = AlertType.AlertTypeId LEFT OUTER JOIN AlertDefinition ON Alert.AlertDefinitionId = AlertDefinition.AlertDefinitionId LEFT OUTER JOIN Location ON Location.LocationId = Alert.LocationId LEFT OUTER JOIN LocationAttribute ON LocationAttribute.LocationId = dbo.Location.LocationId LEFT OUTER JOIN ClientUser ON LocationAttribute.FirstRepId = ClientUser.ClientUserId AND ClientUser.IsDeleted = 0 LEFT OUTER JOIN AlertRecipient ON Alert.AlertDefinitionId = AlertRecipient.AlertDefinitionId AND AlertRecipient.IsDeleted= 0 LEFT OUTER JOIN Client ON Client.ClientId = Alert.ClientId LEFT OUTER JOIN AssetType ON dbo.Asset.AssetTypeId = dbo.AssetType.AssetTypeId WHERE (NOT EXISTS(SELECT 1 FROM dbo.EmailQueue INNER JOIN dbo.EmailRecipient ON EmailRecipient.EmailQueueId = EmailQueue.EmailQueueId WHERE AlertId = Alert.AlertId AND EmailRecipient.RecipientId = AlertRecipient.AlertRecipientId) OR (Alert.SnoozeDateTime IS NOT NULL AND Alert.SnoozeDateTime <= GETUTCDATE() AND AlertDefinition.SnoozeForHours > 0 AND Alert.StatusId = @StatusId)) AND Alert.AlertId > @AlertId AND Alert.AlertAt >= DATEADD(DAY, -120, GETDATE()) AND AlertRecipient.IsDeleted = 0 AND Alert.IsActive = 1 AND Alert.IsDeleted = 0 AND AlertRecipient.IsActive = 1 AND AlertRecipient.IsDeleted = 0 AND AlertRecipient.StartDate <= Alert.CreatedOn AND Alert.CreatedOn < DATEADD(hh, 23, AlertRecipient.EndDate) AND (Alert.LocationId != 0 OR NotificationWithoutLocation = 1) AND AlertType.IsSystemAlert = 0 AND Alert.EmailQueuedOn IS NULL AND AlertDefinition.IsActive = 1 2025-12-21 06:21:12.2168 AlertProcessor ProcessorAlertData: Stopped 2025-12-21 06:21:13.9200 DFramework.Scheduler.TaskBase /* Time Taken: 15609.4263*/ Opportunity Out Of Stock By Outlet 2025-12-21 06:26:07.0155 AlertProcessor ProcessorAlertData: started 2025-12-21 06:26:08.8280 DFramework.Database.Query /* Time Taken: 565*/ DECLARE @StatusId Int32 SET @StatusId = '1' DECLARE @AlertId Int32 SET @AlertId = '7571914' SELECT TOP 10000 Alert.AlertId, Alert.LocationId, Alert.RecordId, ISNULL(AlertDefinition.Name, Alert.AlertText) Name, Alert.AlertTypeId, Alert.AlertText, ISNULL(Location.Name, '') AS LocationName, AlertDefinition.ClientId, AlertRecipient.RoleId, CASE WHEN Alert.AlertTypeId IN (6,7) THEN CONVERT(VARCHAR(10), CAST(AlertAt AS DATE), 101) ELSE AlertAt END AS AlertAt, AlertType, Asset.SerialNumber, ISNULL(LocationAttribute.FirstRepId, 0) RepId, ClientUser.PrimaryPhone AS SalesRepPhone, ClientUser.PrimaryEmail AS SalesRepEmail, FirstName, LastName, PreferedNotificationTypeIds, AlertRecipientId, AlertRecipientAddress, AlertRecipientText, Alert.Tags, AlertRecipientTypeId, NotificationContactTypeId, TemplateId, AlertDefinition.AlertAgeThreshold, LastUpdatedOn, AlertRecipient.AlertAge, CASE WHEN Location.TimeZoneId IS NOT NULL AND Location.TimeZoneId > 0 THEN Location.TimeZoneId ELSE Client.TimeZoneId END AS TimeZoneId, AlertDefinition.IsSummarize, Alert.ClosedOn, AssetType.IsChestCooler, AlertDefinition.SnoozeForHours, Alert.SnoozeDateTime FROM Alert LEFT OUTER JOIN Asset ON Alert.AssetId = Asset.AssetId LEFT OUTER JOIN AlertType ON Alert.AlertTypeId = AlertType.AlertTypeId LEFT OUTER JOIN AlertDefinition ON Alert.AlertDefinitionId = AlertDefinition.AlertDefinitionId LEFT OUTER JOIN Location ON Location.LocationId = Alert.LocationId LEFT OUTER JOIN LocationAttribute ON LocationAttribute.LocationId = dbo.Location.LocationId LEFT OUTER JOIN ClientUser ON LocationAttribute.FirstRepId = ClientUser.ClientUserId AND ClientUser.IsDeleted = 0 LEFT OUTER JOIN AlertRecipient ON Alert.AlertDefinitionId = AlertRecipient.AlertDefinitionId AND AlertRecipient.IsDeleted= 0 LEFT OUTER JOIN Client ON Client.ClientId = Alert.ClientId LEFT OUTER JOIN AssetType ON dbo.Asset.AssetTypeId = dbo.AssetType.AssetTypeId WHERE (NOT EXISTS(SELECT 1 FROM dbo.EmailQueue INNER JOIN dbo.EmailRecipient ON EmailRecipient.EmailQueueId = EmailQueue.EmailQueueId WHERE AlertId = Alert.AlertId AND EmailRecipient.RecipientId = AlertRecipient.AlertRecipientId) OR (Alert.SnoozeDateTime IS NOT NULL AND Alert.SnoozeDateTime <= GETUTCDATE() AND AlertDefinition.SnoozeForHours > 0 AND Alert.StatusId = @StatusId)) AND Alert.AlertId > @AlertId AND Alert.AlertAt >= DATEADD(DAY, -120, GETDATE()) AND AlertRecipient.IsDeleted = 0 AND Alert.IsActive = 1 AND Alert.IsDeleted = 0 AND AlertRecipient.IsActive = 1 AND AlertRecipient.IsDeleted = 0 AND AlertRecipient.StartDate <= Alert.CreatedOn AND Alert.CreatedOn < DATEADD(hh, 23, AlertRecipient.EndDate) AND (Alert.LocationId != 0 OR NotificationWithoutLocation = 1) AND AlertType.IsSystemAlert = 0 AND Alert.EmailQueuedOn IS NULL AND AlertDefinition.IsActive = 1 2025-12-21 06:26:11.8124 AlertProcessor ProcessorAlertData: Stopped 2025-12-21 06:31:07.0175 AlertProcessor ProcessorAlertData: started 2025-12-21 06:31:11.7363 AlertProcessor ProcessorAlertData: Stopped 2025-12-21 06:36:00.3632 DFramework.Database.Query /* Time Taken: 1472*/ [dbo].GenerateSystemAlerts 2025-12-21 06:36:07.0351 AlertProcessor ProcessorAlertData: started 2025-12-21 06:36:11.8164 AlertProcessor ProcessorAlertData: Stopped 2025-12-21 06:36:13.8477 DFramework.Scheduler.TaskBase /* Time Taken: 15515.725*/ Opportunity Out Of Stock By Outlet 2025-12-21 06:41:07.0527 AlertProcessor ProcessorAlertData: started 2025-12-21 06:41:11.9121 AlertProcessor ProcessorAlertData: Stopped 2025-12-21 06:46:07.0704 AlertProcessor ProcessorAlertData: started 2025-12-21 06:46:11.9923 AlertProcessor ProcessorAlertData: Stopped 2025-12-21 06:50:59.8849 DFramework.Database.Query /* Time Taken: 968*/ [dbo].GenerateSystemAlerts 2025-12-21 06:51:07.0881 AlertProcessor ProcessorAlertData: started 2025-12-21 06:51:11.7756 AlertProcessor ProcessorAlertData: Stopped 2025-12-21 06:51:13.8537 DFramework.Scheduler.TaskBase /* Time Taken: 15515.6908*/ Opportunity Out Of Stock By Outlet 2025-12-21 06:56:07.1053 AlertProcessor ProcessorAlertData: started 2025-12-21 06:56:11.9647 AlertProcessor ProcessorAlertData: Stopped 2025-12-21 07:01:07.1229 AlertProcessor ProcessorAlertData: started 2025-12-21 07:01:11.9666 AlertProcessor ProcessorAlertData: Stopped 2025-12-21 07:05:59.9374 DFramework.Database.Query /* Time Taken: 1011*/ [dbo].GenerateSystemAlerts 2025-12-21 07:06:07.1405 AlertProcessor ProcessorAlertData: started 2025-12-21 07:06:11.8593 AlertProcessor ProcessorAlertData: Stopped 2025-12-21 07:06:13.8750 DFramework.Scheduler.TaskBase /* Time Taken: 15531.3558*/ Opportunity Out Of Stock By Outlet 2025-12-21 07:11:07.1577 AlertProcessor ProcessorAlertData: started 2025-12-21 07:11:12.1265 AlertProcessor ProcessorAlertData: Stopped 2025-12-21 07:16:07.1752 AlertProcessor ProcessorAlertData: started 2025-12-21 07:16:11.9721 AlertProcessor ProcessorAlertData: Stopped 2025-12-21 07:20:59.9115 DFramework.Database.Query /* Time Taken: 956*/ [dbo].GenerateSystemAlerts 2025-12-21 07:21:07.1928 AlertProcessor ProcessorAlertData: started 2025-12-21 07:21:11.9897 AlertProcessor ProcessorAlertData: Stopped 2025-12-21 07:21:13.9116 DFramework.Scheduler.TaskBase /* Time Taken: 15546.9831*/ Opportunity Out Of Stock By Outlet 2025-12-21 07:26:07.2103 AlertProcessor ProcessorAlertData: started 2025-12-21 07:26:11.8823 AlertProcessor ProcessorAlertData: Stopped 2025-12-21 07:31:07.2277 AlertProcessor ProcessorAlertData: started 2025-12-21 07:31:12.0247 AlertProcessor ProcessorAlertData: Stopped 2025-12-21 07:35:59.9485 DFramework.Database.Query /* Time Taken: 971*/ [dbo].GenerateSystemAlerts 2025-12-21 07:36:07.2454 AlertProcessor ProcessorAlertData: started 2025-12-21 07:36:12.0423 AlertProcessor ProcessorAlertData: Stopped 2025-12-21 07:36:13.9329 DFramework.Scheduler.TaskBase /* Time Taken: 15546.9945*/ Opportunity Out Of Stock By Outlet 2025-12-21 07:41:07.2631 AlertProcessor ProcessorAlertData: started 2025-12-21 07:41:12.0600 AlertProcessor ProcessorAlertData: Stopped 2025-12-21 07:46:07.2647 AlertProcessor ProcessorAlertData: started 2025-12-21 07:46:11.9991 AlertProcessor ProcessorAlertData: Stopped 2025-12-21 07:51:00.1728 DFramework.Database.Query /* Time Taken: 1176*/ [dbo].GenerateSystemAlerts 2025-12-21 07:51:07.2823 AlertProcessor ProcessorAlertData: started 2025-12-21 07:51:09.9698 DFramework.Database.Query /* Time Taken: 1456*/ DECLARE @StatusId Int32 SET @StatusId = '1' DECLARE @AlertId Int32 SET @AlertId = '7571914' SELECT TOP 10000 Alert.AlertId, Alert.LocationId, Alert.RecordId, ISNULL(AlertDefinition.Name, Alert.AlertText) Name, Alert.AlertTypeId, Alert.AlertText, ISNULL(Location.Name, '') AS LocationName, AlertDefinition.ClientId, AlertRecipient.RoleId, CASE WHEN Alert.AlertTypeId IN (6,7) THEN CONVERT(VARCHAR(10), CAST(AlertAt AS DATE), 101) ELSE AlertAt END AS AlertAt, AlertType, Asset.SerialNumber, ISNULL(LocationAttribute.FirstRepId, 0) RepId, ClientUser.PrimaryPhone AS SalesRepPhone, ClientUser.PrimaryEmail AS SalesRepEmail, FirstName, LastName, PreferedNotificationTypeIds, AlertRecipientId, AlertRecipientAddress, AlertRecipientText, Alert.Tags, AlertRecipientTypeId, NotificationContactTypeId, TemplateId, AlertDefinition.AlertAgeThreshold, LastUpdatedOn, AlertRecipient.AlertAge, CASE WHEN Location.TimeZoneId IS NOT NULL AND Location.TimeZoneId > 0 THEN Location.TimeZoneId ELSE Client.TimeZoneId END AS TimeZoneId, AlertDefinition.IsSummarize, Alert.ClosedOn, AssetType.IsChestCooler, AlertDefinition.SnoozeForHours, Alert.SnoozeDateTime FROM Alert LEFT OUTER JOIN Asset ON Alert.AssetId = Asset.AssetId LEFT OUTER JOIN AlertType ON Alert.AlertTypeId = AlertType.AlertTypeId LEFT OUTER JOIN AlertDefinition ON Alert.AlertDefinitionId = AlertDefinition.AlertDefinitionId LEFT OUTER JOIN Location ON Location.LocationId = Alert.LocationId LEFT OUTER JOIN LocationAttribute ON LocationAttribute.LocationId = dbo.Location.LocationId LEFT OUTER JOIN ClientUser ON LocationAttribute.FirstRepId = ClientUser.ClientUserId AND ClientUser.IsDeleted = 0 LEFT OUTER JOIN AlertRecipient ON Alert.AlertDefinitionId = AlertRecipient.AlertDefinitionId AND AlertRecipient.IsDeleted= 0 LEFT OUTER JOIN Client ON Client.ClientId = Alert.ClientId LEFT OUTER JOIN AssetType ON dbo.Asset.AssetTypeId = dbo.AssetType.AssetTypeId WHERE (NOT EXISTS(SELECT 1 FROM dbo.EmailQueue INNER JOIN dbo.EmailRecipient ON EmailRecipient.EmailQueueId = EmailQueue.EmailQueueId WHERE AlertId = Alert.AlertId AND EmailRecipient.RecipientId = AlertRecipient.AlertRecipientId) OR (Alert.SnoozeDateTime IS NOT NULL AND Alert.SnoozeDateTime <= GETUTCDATE() AND AlertDefinition.SnoozeForHours > 0 AND Alert.StatusId = @StatusId)) AND Alert.AlertId > @AlertId AND Alert.AlertAt >= DATEADD(DAY, -120, GETDATE()) AND AlertRecipient.IsDeleted = 0 AND Alert.IsActive = 1 AND Alert.IsDeleted = 0 AND AlertRecipient.IsActive = 1 AND AlertRecipient.IsDeleted = 0 AND AlertRecipient.StartDate <= Alert.CreatedOn AND Alert.CreatedOn < DATEADD(hh, 23, AlertRecipient.EndDate) AND (Alert.LocationId != 0 OR NotificationWithoutLocation = 1) AND AlertType.IsSystemAlert = 0 AND Alert.EmailQueuedOn IS NULL AND AlertDefinition.IsActive = 1 2025-12-21 07:51:12.5323 AlertProcessor ProcessorAlertData: Stopped 2025-12-21 07:51:14.1417 DFramework.Scheduler.TaskBase /* Time Taken: 15750.1052*/ Opportunity Out Of Stock By Outlet 2025-12-21 07:56:07.2999 AlertProcessor ProcessorAlertData: started 2025-12-21 07:56:12.2062 AlertProcessor ProcessorAlertData: Stopped 2025-12-21 08:01:07.3017 AlertProcessor ProcessorAlertData: started 2025-12-21 08:01:12.0361 AlertProcessor ProcessorAlertData: Stopped 2025-12-21 08:06:00.1628 DFramework.Database.Query /* Time Taken: 1155*/ [dbo].GenerateSystemAlerts 2025-12-21 08:06:07.3035 AlertProcessor ProcessorAlertData: started 2025-12-21 08:06:12.1472 AlertProcessor ProcessorAlertData: Stopped 2025-12-21 08:06:13.9754 DFramework.Scheduler.TaskBase /* Time Taken: 15562.609*/ Opportunity Out Of Stock By Outlet 2025-12-21 08:11:07.3055 AlertProcessor ProcessorAlertData: started 2025-12-21 08:11:12.1961 AlertProcessor ProcessorAlertData: Stopped 2025-12-21 08:16:07.3231 AlertProcessor ProcessorAlertData: started 2025-12-21 08:16:09.2450 DFramework.Database.NullableDataReader Data reader open for 284 at System.Environment.GetStackTrace(Exception e, Boolean needFileInfo) at System.Environment.get_StackTrace() at DFramework.Database.NullableDataReader.Dispose(Boolean disposing) in D:\Spraxa\Framework\DFramework\Database\NullableDataReader.cs:line 33 at DFramework.Database.NullableDataReader.Dispose() in D:\Spraxa\Framework\DFramework\Database\NullableDataReader.cs:line 44 at CoolR.Tasks.ProcessAlertData.Execute() in D:\Spraxa\CoolR-Group\portal\CoolR.Tasks\ProcessAlertData.cs:line 47 at DFramework.Scheduler.TaskBase.Run() in D:\Spraxa\Framework\DFramework.Scheduler\TaskBase.cs:line 176 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.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state) at System.Threading.ThreadHelper.ThreadStart() 2025-12-21 08:16:12.4325 AlertProcessor ProcessorAlertData: Stopped 2025-12-21 08:21:00.0903 DFramework.Database.Query /* Time Taken: 1059*/ [dbo].GenerateSystemAlerts 2025-12-21 08:21:07.3404 AlertProcessor ProcessorAlertData: started 2025-12-21 08:21:12.3247 AlertProcessor ProcessorAlertData: Stopped 2025-12-21 08:21:13.9810 DFramework.Scheduler.TaskBase /* Time Taken: 15546.9703*/ Opportunity Out Of Stock By Outlet 2025-12-21 08:26:07.3579 AlertProcessor ProcessorAlertData: started 2025-12-21 08:26:12.5454 AlertProcessor ProcessorAlertData: Stopped 2025-12-21 08:31:07.3756 AlertProcessor ProcessorAlertData: started 2025-12-21 08:31:12.4537 AlertProcessor ProcessorAlertData: Stopped 2025-12-21 08:36:00.2054 DFramework.Database.Query /* Time Taken: 1142*/ [dbo].GenerateSystemAlerts 2025-12-21 08:36:07.3929 AlertProcessor ProcessorAlertData: started 2025-12-21 08:36:12.7835 AlertProcessor ProcessorAlertData: Stopped 2025-12-21 08:36:14.2211 DFramework.Scheduler.TaskBase /* Time Taken: 15781.3621*/ Opportunity Out Of Stock By Outlet 2025-12-21 08:41:07.4103 AlertProcessor ProcessorAlertData: started 2025-12-21 08:41:12.7073 AlertProcessor ProcessorAlertData: Stopped 2025-12-21 08:46:07.4123 AlertProcessor ProcessorAlertData: started 2025-12-21 08:46:12.7093 AlertProcessor ProcessorAlertData: Stopped 2025-12-21 08:51:00.4455 DFramework.Database.Query /* Time Taken: 1371*/ [dbo].GenerateSystemAlerts 2025-12-21 08:51:07.4299 AlertProcessor ProcessorAlertData: started 2025-12-21 08:51:12.7268 AlertProcessor ProcessorAlertData: Stopped 2025-12-21 08:51:14.0862 DFramework.Scheduler.TaskBase /* Time Taken: 15625.0708*/ Opportunity Out Of Stock By Outlet 2025-12-21 08:56:07.4471 AlertProcessor ProcessorAlertData: started 2025-12-21 08:56:12.7284 AlertProcessor ProcessorAlertData: Stopped 2025-12-21 09:01:07.4647 AlertProcessor ProcessorAlertData: started 2025-12-21 09:01:12.6991 AlertProcessor ProcessorAlertData: Stopped 2025-12-21 09:06:00.1542 DFramework.Database.Query /* Time Taken: 1060*/ [dbo].GenerateSystemAlerts 2025-12-21 09:06:07.4824 AlertProcessor ProcessorAlertData: started 2025-12-21 09:06:12.8261 AlertProcessor ProcessorAlertData: Stopped 2025-12-21 09:06:14.0761 DFramework.Scheduler.TaskBase /* Time Taken: 15593.8622*/ Opportunity Out Of Stock By Outlet 2025-12-21 09:11:07.4997 AlertProcessor ProcessorAlertData: started 2025-12-21 09:11:12.7966 AlertProcessor ProcessorAlertData: Stopped 2025-12-21 09:16:07.5172 AlertProcessor ProcessorAlertData: started 2025-12-21 09:16:12.7360 AlertProcessor ProcessorAlertData: Stopped 2025-12-21 09:21:00.4254 DFramework.Database.Query /* Time Taken: 1300*/ [dbo].GenerateSystemAlerts 2025-12-21 09:21:07.5348 AlertProcessor ProcessorAlertData: started 2025-12-21 09:21:10.4567 DFramework.Database.Query /* Time Taken: 1784*/ DECLARE @StatusId Int32 SET @StatusId = '1' DECLARE @AlertId Int32 SET @AlertId = '7571914' SELECT TOP 10000 Alert.AlertId, Alert.LocationId, Alert.RecordId, ISNULL(AlertDefinition.Name, Alert.AlertText) Name, Alert.AlertTypeId, Alert.AlertText, ISNULL(Location.Name, '') AS LocationName, AlertDefinition.ClientId, AlertRecipient.RoleId, CASE WHEN Alert.AlertTypeId IN (6,7) THEN CONVERT(VARCHAR(10), CAST(AlertAt AS DATE), 101) ELSE AlertAt END AS AlertAt, AlertType, Asset.SerialNumber, ISNULL(LocationAttribute.FirstRepId, 0) RepId, ClientUser.PrimaryPhone AS SalesRepPhone, ClientUser.PrimaryEmail AS SalesRepEmail, FirstName, LastName, PreferedNotificationTypeIds, AlertRecipientId, AlertRecipientAddress, AlertRecipientText, Alert.Tags, AlertRecipientTypeId, NotificationContactTypeId, TemplateId, AlertDefinition.AlertAgeThreshold, LastUpdatedOn, AlertRecipient.AlertAge, CASE WHEN Location.TimeZoneId IS NOT NULL AND Location.TimeZoneId > 0 THEN Location.TimeZoneId ELSE Client.TimeZoneId END AS TimeZoneId, AlertDefinition.IsSummarize, Alert.ClosedOn, AssetType.IsChestCooler, AlertDefinition.SnoozeForHours, Alert.SnoozeDateTime FROM Alert LEFT OUTER JOIN Asset ON Alert.AssetId = Asset.AssetId LEFT OUTER JOIN AlertType ON Alert.AlertTypeId = AlertType.AlertTypeId LEFT OUTER JOIN AlertDefinition ON Alert.AlertDefinitionId = AlertDefinition.AlertDefinitionId LEFT OUTER JOIN Location ON Location.LocationId = Alert.LocationId LEFT OUTER JOIN LocationAttribute ON LocationAttribute.LocationId = dbo.Location.LocationId LEFT OUTER JOIN ClientUser ON LocationAttribute.FirstRepId = ClientUser.ClientUserId AND ClientUser.IsDeleted = 0 LEFT OUTER JOIN AlertRecipient ON Alert.AlertDefinitionId = AlertRecipient.AlertDefinitionId AND AlertRecipient.IsDeleted= 0 LEFT OUTER JOIN Client ON Client.ClientId = Alert.ClientId LEFT OUTER JOIN AssetType ON dbo.Asset.AssetTypeId = dbo.AssetType.AssetTypeId WHERE (NOT EXISTS(SELECT 1 FROM dbo.EmailQueue INNER JOIN dbo.EmailRecipient ON EmailRecipient.EmailQueueId = EmailQueue.EmailQueueId WHERE AlertId = Alert.AlertId AND EmailRecipient.RecipientId = AlertRecipient.AlertRecipientId) OR (Alert.SnoozeDateTime IS NOT NULL AND Alert.SnoozeDateTime <= GETUTCDATE() AND AlertDefinition.SnoozeForHours > 0 AND Alert.StatusId = @StatusId)) AND Alert.AlertId > @AlertId AND Alert.AlertAt >= DATEADD(DAY, -120, GETDATE()) AND AlertRecipient.IsDeleted = 0 AND Alert.IsActive = 1 AND Alert.IsDeleted = 0 AND AlertRecipient.IsActive = 1 AND AlertRecipient.IsDeleted = 0 AND AlertRecipient.StartDate <= Alert.CreatedOn AND Alert.CreatedOn < DATEADD(hh, 23, AlertRecipient.EndDate) AND (Alert.LocationId != 0 OR NotificationWithoutLocation = 1) AND AlertType.IsSystemAlert = 0 AND Alert.EmailQueuedOn IS NULL AND AlertDefinition.IsActive = 1 2025-12-21 09:21:13.3161 AlertProcessor ProcessorAlertData: Stopped 2025-12-21 09:21:14.3005 DFramework.Scheduler.TaskBase /* Time Taken: 15796.9777*/ Opportunity Out Of Stock By Outlet 2025-12-21 09:26:07.5522 AlertProcessor ProcessorAlertData: started 2025-12-21 09:26:13.0991 AlertProcessor ProcessorAlertData: Stopped 2025-12-21 09:31:07.5695 AlertProcessor ProcessorAlertData: started 2025-12-21 09:31:13.0852 AlertProcessor ProcessorAlertData: Stopped 2025-12-21 09:36:00.8840 DFramework.Database.Query /* Time Taken: 1736*/ [dbo].GenerateSystemAlerts 2025-12-21 09:36:07.5871 AlertProcessor ProcessorAlertData: started 2025-12-21 09:36:12.9465 AlertProcessor ProcessorAlertData: Stopped 2025-12-21 09:36:14.1028 DFramework.Scheduler.TaskBase /* Time Taken: 15593.8525*/ Opportunity Out Of Stock By Outlet 2025-12-21 09:41:07.6048 AlertProcessor ProcessorAlertData: started 2025-12-21 09:41:12.9330 AlertProcessor ProcessorAlertData: Stopped 2025-12-21 09:46:07.6221 AlertProcessor ProcessorAlertData: started 2025-12-21 09:46:12.7940 AlertProcessor ProcessorAlertData: Stopped 2025-12-21 09:51:00.3116 DFramework.Database.Query /* Time Taken: 1146*/ [dbo].GenerateSystemAlerts 2025-12-21 09:51:07.6397 AlertProcessor ProcessorAlertData: started 2025-12-21 09:51:12.8116 AlertProcessor ProcessorAlertData: Stopped 2025-12-21 09:51:14.1241 DFramework.Scheduler.TaskBase /* Time Taken: 15609.487*/ Opportunity Out Of Stock By Outlet 2025-12-21 09:56:07.6574 AlertProcessor ProcessorAlertData: started 2025-12-21 09:56:12.8449 AlertProcessor ProcessorAlertData: Stopped 2025-12-21 10:01:07.6746 AlertProcessor ProcessorAlertData: started 2025-12-21 10:01:08.5809 DFramework.Database.Query /* Time Taken: 535*/ DECLARE @TableName AnsiString(8000) SET @TableName = 'VoidAlert' DECLARE @CurrentRecordId Int32 SET @CurrentRecordId = '3674617' dbo.GetValidDeviceForAlertProcessData 2025-12-21 10:01:13.1434 AlertProcessor ProcessorAlertData: Stopped 2025-12-21 10:06:00.3169 DFramework.Database.Query /* Time Taken: 1132*/ [dbo].GenerateSystemAlerts 2025-12-21 10:06:07.6920 AlertProcessor ProcessorAlertData: started 2025-12-21 10:06:10.0513 DFramework.Database.NullableDataReader Data reader open for 280 at System.Environment.GetStackTrace(Exception e, Boolean needFileInfo) at System.Environment.get_StackTrace() at DFramework.Database.NullableDataReader.Dispose(Boolean disposing) in D:\Spraxa\Framework\DFramework\Database\NullableDataReader.cs:line 33 at DFramework.Database.NullableDataReader.Dispose() in D:\Spraxa\Framework\DFramework\Database\NullableDataReader.cs:line 44 at CoolR.Tasks.ProcessAlertData.Execute() in D:\Spraxa\CoolR-Group\portal\CoolR.Tasks\ProcessAlertData.cs:line 47 at DFramework.Scheduler.TaskBase.Run() in D:\Spraxa\Framework\DFramework.Scheduler\TaskBase.cs:line 176 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.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state) at System.Threading.ThreadHelper.ThreadStart() 2025-12-21 10:06:13.1607 AlertProcessor ProcessorAlertData: Stopped 2025-12-21 10:06:14.1295 DFramework.Scheduler.TaskBase /* Time Taken: 15593.8462*/ Opportunity Out Of Stock By Outlet 2025-12-21 10:11:07.6939 AlertProcessor ProcessorAlertData: started 2025-12-21 10:11:13.1002 AlertProcessor ProcessorAlertData: Stopped 2025-12-21 10:16:07.7115 AlertProcessor ProcessorAlertData: started 2025-12-21 10:16:12.9303 AlertProcessor ProcessorAlertData: Stopped 2025-12-21 10:21:00.2913 DFramework.Database.Query /* Time Taken: 1093*/ [dbo].GenerateSystemAlerts 2025-12-21 10:21:07.7289 AlertProcessor ProcessorAlertData: started 2025-12-21 10:21:13.0414 AlertProcessor ProcessorAlertData: Stopped 2025-12-21 10:21:14.1195 DFramework.Scheduler.TaskBase /* Time Taken: 15562.582*/ Opportunity Out Of Stock By Outlet 2025-12-21 10:26:07.7465 AlertProcessor ProcessorAlertData: started 2025-12-21 10:26:12.9652 AlertProcessor ProcessorAlertData: Stopped 2025-12-21 10:31:07.7485 AlertProcessor ProcessorAlertData: started 2025-12-21 10:31:12.9048 AlertProcessor ProcessorAlertData: Stopped 2025-12-21 10:36:00.3283 DFramework.Database.Query /* Time Taken: 1115*/ [dbo].GenerateSystemAlerts 2025-12-21 10:36:07.7658 AlertProcessor ProcessorAlertData: started 2025-12-21 10:36:13.1096 AlertProcessor ProcessorAlertData: Stopped 2025-12-21 10:36:14.1408 DFramework.Scheduler.TaskBase /* Time Taken: 15562.5964*/ Opportunity Out Of Stock By Outlet 2025-12-21 10:41:07.7833 AlertProcessor ProcessorAlertData: started 2025-12-21 10:41:13.0021 AlertProcessor ProcessorAlertData: Stopped 2025-12-21 10:46:07.7853 AlertProcessor ProcessorAlertData: started 2025-12-21 10:46:12.9885 AlertProcessor ProcessorAlertData: Stopped 2025-12-21 10:51:00.5683 DFramework.Database.Query /* Time Taken: 1340*/ [dbo].GenerateSystemAlerts 2025-12-21 10:51:07.7871 AlertProcessor ProcessorAlertData: started 2025-12-21 10:51:09.7090 DFramework.Database.Query /* Time Taken: 798*/ DECLARE @StatusId Int32 SET @StatusId = '1' DECLARE @AlertId Int32 SET @AlertId = '7571914' SELECT TOP 10000 Alert.AlertId, Alert.LocationId, Alert.RecordId, ISNULL(AlertDefinition.Name, Alert.AlertText) Name, Alert.AlertTypeId, Alert.AlertText, ISNULL(Location.Name, '') AS LocationName, AlertDefinition.ClientId, AlertRecipient.RoleId, CASE WHEN Alert.AlertTypeId IN (6,7) THEN CONVERT(VARCHAR(10), CAST(AlertAt AS DATE), 101) ELSE AlertAt END AS AlertAt, AlertType, Asset.SerialNumber, ISNULL(LocationAttribute.FirstRepId, 0) RepId, ClientUser.PrimaryPhone AS SalesRepPhone, ClientUser.PrimaryEmail AS SalesRepEmail, FirstName, LastName, PreferedNotificationTypeIds, AlertRecipientId, AlertRecipientAddress, AlertRecipientText, Alert.Tags, AlertRecipientTypeId, NotificationContactTypeId, TemplateId, AlertDefinition.AlertAgeThreshold, LastUpdatedOn, AlertRecipient.AlertAge, CASE WHEN Location.TimeZoneId IS NOT NULL AND Location.TimeZoneId > 0 THEN Location.TimeZoneId ELSE Client.TimeZoneId END AS TimeZoneId, AlertDefinition.IsSummarize, Alert.ClosedOn, AssetType.IsChestCooler, AlertDefinition.SnoozeForHours, Alert.SnoozeDateTime FROM Alert LEFT OUTER JOIN Asset ON Alert.AssetId = Asset.AssetId LEFT OUTER JOIN AlertType ON Alert.AlertTypeId = AlertType.AlertTypeId LEFT OUTER JOIN AlertDefinition ON Alert.AlertDefinitionId = AlertDefinition.AlertDefinitionId LEFT OUTER JOIN Location ON Location.LocationId = Alert.LocationId LEFT OUTER JOIN LocationAttribute ON LocationAttribute.LocationId = dbo.Location.LocationId LEFT OUTER JOIN ClientUser ON LocationAttribute.FirstRepId = ClientUser.ClientUserId AND ClientUser.IsDeleted = 0 LEFT OUTER JOIN AlertRecipient ON Alert.AlertDefinitionId = AlertRecipient.AlertDefinitionId AND AlertRecipient.IsDeleted= 0 LEFT OUTER JOIN Client ON Client.ClientId = Alert.ClientId LEFT OUTER JOIN AssetType ON dbo.Asset.AssetTypeId = dbo.AssetType.AssetTypeId WHERE (NOT EXISTS(SELECT 1 FROM dbo.EmailQueue INNER JOIN dbo.EmailRecipient ON EmailRecipient.EmailQueueId = EmailQueue.EmailQueueId WHERE AlertId = Alert.AlertId AND EmailRecipient.RecipientId = AlertRecipient.AlertRecipientId) OR (Alert.SnoozeDateTime IS NOT NULL AND Alert.SnoozeDateTime <= GETUTCDATE() AND AlertDefinition.SnoozeForHours > 0 AND Alert.StatusId = @StatusId)) AND Alert.AlertId > @AlertId AND Alert.AlertAt >= DATEADD(DAY, -120, GETDATE()) AND AlertRecipient.IsDeleted = 0 AND Alert.IsActive = 1 AND Alert.IsDeleted = 0 AND AlertRecipient.IsActive = 1 AND AlertRecipient.IsDeleted = 0 AND AlertRecipient.StartDate <= Alert.CreatedOn AND Alert.CreatedOn < DATEADD(hh, 23, AlertRecipient.EndDate) AND (Alert.LocationId != 0 OR NotificationWithoutLocation = 1) AND AlertType.IsSystemAlert = 0 AND Alert.EmailQueuedOn IS NULL AND AlertDefinition.IsActive = 1 2025-12-21 10:51:13.2090 AlertProcessor ProcessorAlertData: Stopped 2025-12-21 10:51:14.1622 DFramework.Scheduler.TaskBase /* Time Taken: 15578.1962*/ Opportunity Out Of Stock By Outlet 2025-12-21 10:56:07.8044 AlertProcessor ProcessorAlertData: started 2025-12-21 10:56:13.2107 AlertProcessor ProcessorAlertData: Stopped 2025-12-21 11:01:07.8220 AlertProcessor ProcessorAlertData: started 2025-12-21 11:01:12.6814 DFramework.Database.NullableDataReader Data reader open for 281 at System.Environment.GetStackTrace(Exception e, Boolean needFileInfo) at System.Environment.get_StackTrace() at DFramework.Database.NullableDataReader.Dispose(Boolean disposing) in D:\Spraxa\Framework\DFramework\Database\NullableDataReader.cs:line 33 at DFramework.Database.NullableDataReader.Dispose() in D:\Spraxa\Framework\DFramework\Database\NullableDataReader.cs:line 44 at CoolR.Tasks.ProcessAlertData.Execute() in D:\Spraxa\CoolR-Group\portal\CoolR.Tasks\ProcessAlertData.cs:line 47 at DFramework.Scheduler.TaskBase.Run() in D:\Spraxa\Framework\DFramework.Scheduler\TaskBase.cs:line 176 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.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state) at System.Threading.ThreadHelper.ThreadStart() 2025-12-21 11:01:13.3377 AlertProcessor ProcessorAlertData: Stopped 2025-12-21 11:06:00.6052 DFramework.Database.Query /* Time Taken: 1343*/ [dbo].GenerateSystemAlerts 2025-12-21 11:06:07.8396 AlertProcessor ProcessorAlertData: started 2025-12-21 11:06:13.1366 AlertProcessor ProcessorAlertData: Stopped 2025-12-21 11:06:14.1678 DFramework.Scheduler.TaskBase /* Time Taken: 15578.2178*/ Opportunity Out Of Stock By Outlet 2025-12-21 11:11:07.8570 AlertProcessor ProcessorAlertData: started 2025-12-21 11:11:13.1226 AlertProcessor ProcessorAlertData: Stopped 2025-12-21 11:16:07.8745 AlertProcessor ProcessorAlertData: started 2025-12-21 11:16:13.0933 AlertProcessor ProcessorAlertData: Stopped 2025-12-21 11:21:00.3452 DFramework.Database.Query /* Time Taken: 1074*/ [dbo].GenerateSystemAlerts 2025-12-21 11:21:07.8765 AlertProcessor ProcessorAlertData: started 2025-12-21 11:21:13.1109 AlertProcessor ProcessorAlertData: Stopped 2025-12-21 11:21:14.1578 DFramework.Scheduler.TaskBase /* Time Taken: 15562.6045*/ Opportunity Out Of Stock By Outlet 2025-12-21 11:26:07.8939 AlertProcessor ProcessorAlertData: started 2025-12-21 11:26:13.0189 AlertProcessor ProcessorAlertData: Stopped 2025-12-21 11:31:07.9113 AlertProcessor ProcessorAlertData: started 2025-12-21 11:31:13.1301 AlertProcessor ProcessorAlertData: Stopped 2025-12-21 11:36:00.3351 DFramework.Database.Query /* Time Taken: 1046*/ [dbo].GenerateSystemAlerts 2025-12-21 11:36:07.9289 AlertProcessor ProcessorAlertData: started 2025-12-21 11:36:13.2258 AlertProcessor ProcessorAlertData: Stopped 2025-12-21 11:36:14.3352 DFramework.Scheduler.TaskBase /* Time Taken: 15718.8374*/ Opportunity Out Of Stock By Outlet 2025-12-21 11:41:07.9465 AlertProcessor ProcessorAlertData: started 2025-12-21 11:41:13.3840 AlertProcessor ProcessorAlertData: Stopped 2025-12-21 11:46:07.9636 AlertProcessor ProcessorAlertData: started 2025-12-21 11:46:13.3699 AlertProcessor ProcessorAlertData: Stopped 2025-12-21 11:51:00.3561 DFramework.Database.Query /* Time Taken: 1042*/ [dbo].GenerateSystemAlerts 2025-12-21 11:51:07.9811 AlertProcessor ProcessorAlertData: started 2025-12-21 11:51:13.1843 AlertProcessor ProcessorAlertData: Stopped 2025-12-21 11:51:14.2312 DFramework.Scheduler.TaskBase /* Time Taken: 15593.8293*/ Opportunity Out Of Stock By Outlet 2025-12-21 11:56:07.9988 AlertProcessor ProcessorAlertData: started 2025-12-21 11:56:13.2800 AlertProcessor ProcessorAlertData: Stopped 2025-12-21 12:01:08.0160 AlertProcessor ProcessorAlertData: started 2025-12-21 12:01:14.2661 AlertProcessor ProcessorAlertData: Stopped 2025-12-21 12:06:00.3928 DFramework.Database.Query /* Time Taken: 1059*/ [dbo].GenerateSystemAlerts 2025-12-21 12:06:08.0178 AlertProcessor ProcessorAlertData: started 2025-12-21 12:06:13.2366 AlertProcessor ProcessorAlertData: Stopped 2025-12-21 12:06:14.2679 DFramework.Scheduler.TaskBase /* Time Taken: 15609.46*/ Opportunity Out Of Stock By Outlet 2025-12-21 12:11:08.0198 AlertProcessor ProcessorAlertData: started 2025-12-21 12:11:13.2699 AlertProcessor ProcessorAlertData: Stopped 2025-12-21 12:16:08.0217 AlertProcessor ProcessorAlertData: started 2025-12-21 12:16:13.2248 AlertProcessor ProcessorAlertData: Stopped 2025-12-21 12:21:00.7733 DFramework.Database.Query /* Time Taken: 1406*/ [dbo].GenerateSystemAlerts 2025-12-21 12:21:08.0234 AlertProcessor ProcessorAlertData: started 2025-12-21 12:21:09.7109 DFramework.Database.Query /* Time Taken: 531*/ DECLARE @StatusId Int32 SET @StatusId = '1' DECLARE @AlertId Int32 SET @AlertId = '7571914' SELECT TOP 10000 Alert.AlertId, Alert.LocationId, Alert.RecordId, ISNULL(AlertDefinition.Name, Alert.AlertText) Name, Alert.AlertTypeId, Alert.AlertText, ISNULL(Location.Name, '') AS LocationName, AlertDefinition.ClientId, AlertRecipient.RoleId, CASE WHEN Alert.AlertTypeId IN (6,7) THEN CONVERT(VARCHAR(10), CAST(AlertAt AS DATE), 101) ELSE AlertAt END AS AlertAt, AlertType, Asset.SerialNumber, ISNULL(LocationAttribute.FirstRepId, 0) RepId, ClientUser.PrimaryPhone AS SalesRepPhone, ClientUser.PrimaryEmail AS SalesRepEmail, FirstName, LastName, PreferedNotificationTypeIds, AlertRecipientId, AlertRecipientAddress, AlertRecipientText, Alert.Tags, AlertRecipientTypeId, NotificationContactTypeId, TemplateId, AlertDefinition.AlertAgeThreshold, LastUpdatedOn, AlertRecipient.AlertAge, CASE WHEN Location.TimeZoneId IS NOT NULL AND Location.TimeZoneId > 0 THEN Location.TimeZoneId ELSE Client.TimeZoneId END AS TimeZoneId, AlertDefinition.IsSummarize, Alert.ClosedOn, AssetType.IsChestCooler, AlertDefinition.SnoozeForHours, Alert.SnoozeDateTime FROM Alert LEFT OUTER JOIN Asset ON Alert.AssetId = Asset.AssetId LEFT OUTER JOIN AlertType ON Alert.AlertTypeId = AlertType.AlertTypeId LEFT OUTER JOIN AlertDefinition ON Alert.AlertDefinitionId = AlertDefinition.AlertDefinitionId LEFT OUTER JOIN Location ON Location.LocationId = Alert.LocationId LEFT OUTER JOIN LocationAttribute ON LocationAttribute.LocationId = dbo.Location.LocationId LEFT OUTER JOIN ClientUser ON LocationAttribute.FirstRepId = ClientUser.ClientUserId AND ClientUser.IsDeleted = 0 LEFT OUTER JOIN AlertRecipient ON Alert.AlertDefinitionId = AlertRecipient.AlertDefinitionId AND AlertRecipient.IsDeleted= 0 LEFT OUTER JOIN Client ON Client.ClientId = Alert.ClientId LEFT OUTER JOIN AssetType ON dbo.Asset.AssetTypeId = dbo.AssetType.AssetTypeId WHERE (NOT EXISTS(SELECT 1 FROM dbo.EmailQueue INNER JOIN dbo.EmailRecipient ON EmailRecipient.EmailQueueId = EmailQueue.EmailQueueId WHERE AlertId = Alert.AlertId AND EmailRecipient.RecipientId = AlertRecipient.AlertRecipientId) OR (Alert.SnoozeDateTime IS NOT NULL AND Alert.SnoozeDateTime <= GETUTCDATE() AND AlertDefinition.SnoozeForHours > 0 AND Alert.StatusId = @StatusId)) AND Alert.AlertId > @AlertId AND Alert.AlertAt >= DATEADD(DAY, -120, GETDATE()) AND AlertRecipient.IsDeleted = 0 AND Alert.IsActive = 1 AND Alert.IsDeleted = 0 AND AlertRecipient.IsActive = 1 AND AlertRecipient.IsDeleted = 0 AND AlertRecipient.StartDate <= Alert.CreatedOn AND Alert.CreatedOn < DATEADD(hh, 23, AlertRecipient.EndDate) AND (Alert.LocationId != 0 OR NotificationWithoutLocation = 1) AND AlertType.IsSystemAlert = 0 AND Alert.EmailQueuedOn IS NULL AND AlertDefinition.IsActive = 1 2025-12-21 12:21:13.4765 AlertProcessor ProcessorAlertData: Stopped 2025-12-21 12:21:14.2109 DFramework.Scheduler.TaskBase /* Time Taken: 15531.3379*/ Opportunity Out Of Stock By Outlet 2025-12-21 12:26:08.0409 AlertProcessor ProcessorAlertData: started 2025-12-21 12:26:13.3379 AlertProcessor ProcessorAlertData: Stopped 2025-12-21 12:31:08.0586 AlertProcessor ProcessorAlertData: started 2025-12-21 12:31:13.3399 AlertProcessor ProcessorAlertData: Stopped 2025-12-21 12:36:00.7009 DFramework.Database.Query /* Time Taken: 1333*/ [dbo].GenerateSystemAlerts 2025-12-21 12:36:08.0759 AlertProcessor ProcessorAlertData: started 2025-12-21 12:36:13.3415 AlertProcessor ProcessorAlertData: Stopped 2025-12-21 12:36:14.2947 DFramework.Scheduler.TaskBase /* Time Taken: 15593.8396*/ Opportunity Out Of Stock By Outlet 2025-12-21 12:41:08.0934 AlertProcessor ProcessorAlertData: started 2025-12-21 12:41:13.3903 AlertProcessor ProcessorAlertData: Stopped 2025-12-21 12:46:08.1110 AlertProcessor ProcessorAlertData: started 2025-12-21 12:46:13.2986 AlertProcessor ProcessorAlertData: Stopped 2025-12-21 12:51:00.4566 DFramework.Database.Query /* Time Taken: 1070*/ [dbo].GenerateSystemAlerts 2025-12-21 12:51:08.1285 AlertProcessor ProcessorAlertData: started 2025-12-21 12:51:13.3941 AlertProcessor ProcessorAlertData: Stopped 2025-12-21 12:51:14.2691 DFramework.Scheduler.TaskBase /* Time Taken: 15546.948*/ Opportunity Out Of Stock By Outlet 2025-12-21 12:56:08.1303 AlertProcessor ProcessorAlertData: started 2025-12-21 12:56:13.3178 AlertProcessor ProcessorAlertData: Stopped 2025-12-21 13:01:08.1478 AlertProcessor ProcessorAlertData: started 2025-12-21 13:01:13.3510 AlertProcessor ProcessorAlertData: Stopped 2025-12-21 13:06:00.4623 DFramework.Database.Query /* Time Taken: 1058*/ [dbo].GenerateSystemAlerts 2025-12-21 13:06:08.1655 AlertProcessor ProcessorAlertData: started 2025-12-21 13:06:13.4311 AlertProcessor ProcessorAlertData: Stopped 2025-12-21 13:06:14.2749 DFramework.Scheduler.TaskBase /* Time Taken: 15531.3365*/ Opportunity Out Of Stock By Outlet 2025-12-21 13:11:08.1827 AlertProcessor ProcessorAlertData: started 2025-12-21 13:11:13.4796 AlertProcessor ProcessorAlertData: Stopped 2025-12-21 13:16:08.1846 AlertProcessor ProcessorAlertData: started 2025-12-21 13:16:13.4346 AlertProcessor ProcessorAlertData: Stopped 2025-12-21 13:21:00.4834 DFramework.Database.Query /* Time Taken: 1059*/ [dbo].GenerateSystemAlerts 2025-12-21 13:21:08.2022 AlertProcessor ProcessorAlertData: started 2025-12-21 13:21:13.4523 AlertProcessor ProcessorAlertData: Stopped 2025-12-21 13:21:14.3116 DFramework.Scheduler.TaskBase /* Time Taken: 15546.9817*/ Opportunity Out Of Stock By Outlet 2025-12-21 13:26:08.2038 AlertProcessor ProcessorAlertData: started 2025-12-21 13:26:12.5007 DFramework.Database.Query /* Time Taken: 543*/ DECLARE @TableName AnsiString(8000) SET @TableName = 'AssetPlanogram' DECLARE @CurrentRecordId Int32 SET @CurrentRecordId = '3674617' dbo.GetValidDeviceForAlertProcessData 2025-12-21 13:26:13.8601 AlertProcessor ProcessorAlertData: Stopped 2025-12-21 13:31:08.2212 AlertProcessor ProcessorAlertData: started 2025-12-21 13:31:13.4243 AlertProcessor ProcessorAlertData: Stopped 2025-12-21 13:36:00.5043 DFramework.Database.Query /* Time Taken: 1059*/ [dbo].GenerateSystemAlerts 2025-12-21 13:36:08.2231 AlertProcessor ProcessorAlertData: started 2025-12-21 13:36:13.4575 AlertProcessor ProcessorAlertData: Stopped 2025-12-21 13:36:14.3169 DFramework.Scheduler.TaskBase /* Time Taken: 15546.9669*/ Opportunity Out Of Stock By Outlet 2025-12-21 13:41:08.2408 AlertProcessor ProcessorAlertData: started 2025-12-21 13:41:13.5219 AlertProcessor ProcessorAlertData: Stopped 2025-12-21 13:46:08.2424 AlertProcessor ProcessorAlertData: started 2025-12-21 13:46:13.4769 AlertProcessor ProcessorAlertData: Stopped 2025-12-21 13:51:01.0412 DFramework.Database.Query /* Time Taken: 1562*/ [dbo].GenerateSystemAlerts 2025-12-21 13:51:08.2600 AlertProcessor ProcessorAlertData: started 2025-12-21 13:51:10.1038 DFramework.Database.Query /* Time Taken: 657*/ DECLARE @StatusId Int32 SET @StatusId = '1' DECLARE @AlertId Int32 SET @AlertId = '7571914' SELECT TOP 10000 Alert.AlertId, Alert.LocationId, Alert.RecordId, ISNULL(AlertDefinition.Name, Alert.AlertText) Name, Alert.AlertTypeId, Alert.AlertText, ISNULL(Location.Name, '') AS LocationName, AlertDefinition.ClientId, AlertRecipient.RoleId, CASE WHEN Alert.AlertTypeId IN (6,7) THEN CONVERT(VARCHAR(10), CAST(AlertAt AS DATE), 101) ELSE AlertAt END AS AlertAt, AlertType, Asset.SerialNumber, ISNULL(LocationAttribute.FirstRepId, 0) RepId, ClientUser.PrimaryPhone AS SalesRepPhone, ClientUser.PrimaryEmail AS SalesRepEmail, FirstName, LastName, PreferedNotificationTypeIds, AlertRecipientId, AlertRecipientAddress, AlertRecipientText, Alert.Tags, AlertRecipientTypeId, NotificationContactTypeId, TemplateId, AlertDefinition.AlertAgeThreshold, LastUpdatedOn, AlertRecipient.AlertAge, CASE WHEN Location.TimeZoneId IS NOT NULL AND Location.TimeZoneId > 0 THEN Location.TimeZoneId ELSE Client.TimeZoneId END AS TimeZoneId, AlertDefinition.IsSummarize, Alert.ClosedOn, AssetType.IsChestCooler, AlertDefinition.SnoozeForHours, Alert.SnoozeDateTime FROM Alert LEFT OUTER JOIN Asset ON Alert.AssetId = Asset.AssetId LEFT OUTER JOIN AlertType ON Alert.AlertTypeId = AlertType.AlertTypeId LEFT OUTER JOIN AlertDefinition ON Alert.AlertDefinitionId = AlertDefinition.AlertDefinitionId LEFT OUTER JOIN Location ON Location.LocationId = Alert.LocationId LEFT OUTER JOIN LocationAttribute ON LocationAttribute.LocationId = dbo.Location.LocationId LEFT OUTER JOIN ClientUser ON LocationAttribute.FirstRepId = ClientUser.ClientUserId AND ClientUser.IsDeleted = 0 LEFT OUTER JOIN AlertRecipient ON Alert.AlertDefinitionId = AlertRecipient.AlertDefinitionId AND AlertRecipient.IsDeleted= 0 LEFT OUTER JOIN Client ON Client.ClientId = Alert.ClientId LEFT OUTER JOIN AssetType ON dbo.Asset.AssetTypeId = dbo.AssetType.AssetTypeId WHERE (NOT EXISTS(SELECT 1 FROM dbo.EmailQueue INNER JOIN dbo.EmailRecipient ON EmailRecipient.EmailQueueId = EmailQueue.EmailQueueId WHERE AlertId = Alert.AlertId AND EmailRecipient.RecipientId = AlertRecipient.AlertRecipientId) OR (Alert.SnoozeDateTime IS NOT NULL AND Alert.SnoozeDateTime <= GETUTCDATE() AND AlertDefinition.SnoozeForHours > 0 AND Alert.StatusId = @StatusId)) AND Alert.AlertId > @AlertId AND Alert.AlertAt >= DATEADD(DAY, -120, GETDATE()) AND AlertRecipient.IsDeleted = 0 AND Alert.IsActive = 1 AND Alert.IsDeleted = 0 AND AlertRecipient.IsActive = 1 AND AlertRecipient.IsDeleted = 0 AND AlertRecipient.StartDate <= Alert.CreatedOn AND Alert.CreatedOn < DATEADD(hh, 23, AlertRecipient.EndDate) AND (Alert.LocationId != 0 OR NotificationWithoutLocation = 1) AND AlertType.IsSystemAlert = 0 AND Alert.EmailQueuedOn IS NULL AND AlertDefinition.IsActive = 1 2025-12-21 13:51:13.5569 AlertProcessor ProcessorAlertData: Stopped 2025-12-21 13:51:14.3226 DFramework.Scheduler.TaskBase /* Time Taken: 15531.3598*/ Opportunity Out Of Stock By Outlet 2025-12-21 13:56:08.2777 AlertProcessor ProcessorAlertData: started 2025-12-21 13:56:13.5433 AlertProcessor ProcessorAlertData: Stopped 2025-12-21 14:01:08.2793 AlertProcessor ProcessorAlertData: started 2025-12-21 14:01:13.5450 AlertProcessor ProcessorAlertData: Stopped 2025-12-21 14:06:00.7811 DFramework.Database.Query /* Time Taken: 1311*/ [dbo].GenerateSystemAlerts 2025-12-21 14:06:08.2968 AlertProcessor ProcessorAlertData: started 2025-12-21 14:06:13.6250 AlertProcessor ProcessorAlertData: Stopped 2025-12-21 14:06:14.3437 DFramework.Scheduler.TaskBase /* Time Taken: 15531.3549*/ Opportunity Out Of Stock By Outlet 2025-12-21 14:11:08.3144 AlertProcessor ProcessorAlertData: started 2025-12-21 14:11:13.5957 AlertProcessor ProcessorAlertData: Stopped 2025-12-21 14:16:08.3318 AlertProcessor ProcessorAlertData: started 2025-12-21 14:16:13.6131 AlertProcessor ProcessorAlertData: Stopped 2025-12-21 14:21:00.6304 DFramework.Database.Query /* Time Taken: 1154*/ [dbo].GenerateSystemAlerts 2025-12-21 14:21:08.3492 AlertProcessor ProcessorAlertData: started 2025-12-21 14:21:13.5836 AlertProcessor ProcessorAlertData: Stopped 2025-12-21 14:21:14.3961 DFramework.Scheduler.TaskBase /* Time Taken: 15578.2307*/ Opportunity Out Of Stock By Outlet 2025-12-21 14:26:08.3674 AlertProcessor ProcessorAlertData: started 2025-12-21 14:26:13.6487 AlertProcessor ProcessorAlertData: Stopped 2025-12-21 14:31:08.3850 AlertProcessor ProcessorAlertData: started 2025-12-21 14:31:13.5569 AlertProcessor ProcessorAlertData: Stopped 2025-12-21 14:36:00.8397 DFramework.Database.Query /* Time Taken: 1345*/ [dbo].GenerateSystemAlerts 2025-12-21 14:36:08.4022 AlertProcessor ProcessorAlertData: started 2025-12-21 14:36:13.6991 AlertProcessor ProcessorAlertData: Stopped 2025-12-21 14:36:14.4022 DFramework.Scheduler.TaskBase /* Time Taken: 15578.2166*/ Opportunity Out Of Stock By Outlet 2025-12-21 14:41:08.4197 AlertProcessor ProcessorAlertData: started 2025-12-21 14:41:13.7009 AlertProcessor ProcessorAlertData: Stopped 2025-12-21 14:46:08.4373 AlertProcessor ProcessorAlertData: started 2025-12-21 14:46:13.7654 AlertProcessor ProcessorAlertData: Stopped 2025-12-21 14:51:00.7202 DFramework.Database.Query /* Time Taken: 1214*/ [dbo].GenerateSystemAlerts 2025-12-21 14:51:08.4390 AlertProcessor ProcessorAlertData: started 2025-12-21 14:51:13.7203 AlertProcessor ProcessorAlertData: Stopped 2025-12-21 14:51:14.4234 DFramework.Scheduler.TaskBase /* Time Taken: 15593.839*/ Opportunity Out Of Stock By Outlet 2025-12-21 14:56:08.4564 AlertProcessor ProcessorAlertData: started 2025-12-21 14:56:13.7533 AlertProcessor ProcessorAlertData: Stopped 2025-12-21 15:01:08.4740 AlertProcessor ProcessorAlertData: started 2025-12-21 15:01:13.6146 DFramework.Database.Query /* Time Taken: 530*/ DECLARE @TableName AnsiString(8000) SET @TableName = 'TargetPortfolioComplianceConsolidate' DECLARE @CurrentRecordId Int32 SET @CurrentRecordId = '3674617' dbo.GetValidDeviceForAlertProcessData 2025-12-21 15:01:14.0053 AlertProcessor ProcessorAlertData: Stopped 2025-12-21 15:06:00.8040 DFramework.Database.Query /* Time Taken: 1276*/ [dbo].GenerateSystemAlerts 2025-12-21 15:06:08.4915 AlertProcessor ProcessorAlertData: started 2025-12-21 15:06:13.7572 AlertProcessor ProcessorAlertData: Stopped 2025-12-21 15:06:14.5072 DFramework.Scheduler.TaskBase /* Time Taken: 15656.3196*/ Opportunity Out Of Stock By Outlet 2025-12-21 15:11:08.5088 AlertProcessor ProcessorAlertData: started 2025-12-21 15:11:13.7432 AlertProcessor ProcessorAlertData: Stopped 2025-12-21 15:16:08.5263 AlertProcessor ProcessorAlertData: started 2025-12-21 15:16:13.3076 DFramework.Database.NullableDataReader Data reader open for 283 at System.Environment.GetStackTrace(Exception e, Boolean needFileInfo) at System.Environment.get_StackTrace() at DFramework.Database.NullableDataReader.Dispose(Boolean disposing) in D:\Spraxa\Framework\DFramework\Database\NullableDataReader.cs:line 33 at DFramework.Database.NullableDataReader.Dispose() in D:\Spraxa\Framework\DFramework\Database\NullableDataReader.cs:line 44 at CoolR.Tasks.ProcessAlertData.Execute() in D:\Spraxa\CoolR-Group\portal\CoolR.Tasks\ProcessAlertData.cs:line 47 at DFramework.Scheduler.TaskBase.Run() in D:\Spraxa\Framework\DFramework.Scheduler\TaskBase.cs:line 176 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.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state) at System.Threading.ThreadHelper.ThreadStart() 2025-12-21 15:16:13.9482 AlertProcessor ProcessorAlertData: Stopped 2025-12-21 15:21:00.8876 DFramework.Database.Query /* Time Taken: 1350*/ [dbo].GenerateSystemAlerts 2025-12-21 15:21:08.5439 AlertProcessor ProcessorAlertData: started 2025-12-21 15:21:13.8095 AlertProcessor ProcessorAlertData: Stopped 2025-12-21 15:21:14.4189 DFramework.Scheduler.TaskBase /* Time Taken: 15546.9702*/ Opportunity Out Of Stock By Outlet 2025-12-21 15:26:08.5457 AlertProcessor ProcessorAlertData: started 2025-12-21 15:26:13.9989 AlertProcessor ProcessorAlertData: Stopped 2025-12-21 15:31:08.5633 AlertProcessor ProcessorAlertData: started 2025-12-21 15:31:13.7821 AlertProcessor ProcessorAlertData: Stopped 2025-12-21 15:36:01.0027 DFramework.Database.Query /* Time Taken: 1442*/ [dbo].GenerateSystemAlerts 2025-12-21 15:36:08.5809 AlertProcessor ProcessorAlertData: started 2025-12-21 15:36:13.7841 AlertProcessor ProcessorAlertData: Stopped 2025-12-21 15:36:14.4560 DFramework.Scheduler.TaskBase /* Time Taken: 15562.6012*/ Opportunity Out Of Stock By Outlet 2025-12-21 15:41:08.5984 AlertProcessor ProcessorAlertData: started 2025-12-21 15:41:14.0516 AlertProcessor ProcessorAlertData: Stopped 2025-12-21 15:46:08.6158 AlertProcessor ProcessorAlertData: started 2025-12-21 15:46:13.8815 AlertProcessor ProcessorAlertData: Stopped 2025-12-21 15:51:00.6333 DFramework.Database.Query /* Time Taken: 1050*/ [dbo].GenerateSystemAlerts 2025-12-21 15:51:08.6333 AlertProcessor ProcessorAlertData: started 2025-12-21 15:51:13.9146 AlertProcessor ProcessorAlertData: Stopped 2025-12-21 15:51:14.4459 DFramework.Scheduler.TaskBase /* Time Taken: 15531.3579*/ Opportunity Out Of Stock By Outlet 2025-12-21 15:56:08.6509 AlertProcessor ProcessorAlertData: started 2025-12-21 15:56:13.9479 AlertProcessor ProcessorAlertData: Stopped 2025-12-21 16:01:08.6682 AlertProcessor ProcessorAlertData: started 2025-12-21 16:01:14.0745 AlertProcessor ProcessorAlertData: Stopped 2025-12-21 16:06:00.7794 DFramework.Database.Query /* Time Taken: 1174*/ [dbo].GenerateSystemAlerts 2025-12-21 16:06:08.6857 AlertProcessor ProcessorAlertData: started 2025-12-21 16:06:14.1701 AlertProcessor ProcessorAlertData: Stopped 2025-12-21 16:06:14.5451 DFramework.Scheduler.TaskBase /* Time Taken: 15609.4646*/ Opportunity Out Of Stock By Outlet 2025-12-21 16:11:08.7033 AlertProcessor ProcessorAlertData: started 2025-12-21 16:11:14.0158 AlertProcessor ProcessorAlertData: Stopped 2025-12-21 16:16:08.7207 AlertProcessor ProcessorAlertData: started 2025-12-21 16:16:13.9551 AlertProcessor ProcessorAlertData: Stopped 2025-12-21 16:21:00.6600 DFramework.Database.Query /* Time Taken: 1034*/ [dbo].GenerateSystemAlerts 2025-12-21 16:21:08.7225 AlertProcessor ProcessorAlertData: started 2025-12-21 16:21:14.1132 AlertProcessor ProcessorAlertData: Stopped 2025-12-21 16:21:14.5038 DFramework.Scheduler.TaskBase /* Time Taken: 15562.5927*/ Opportunity Out Of Stock By Outlet 2025-12-21 16:26:08.7401 AlertProcessor ProcessorAlertData: started 2025-12-21 16:26:13.9902 AlertProcessor ProcessorAlertData: Stopped 2025-12-21 16:31:08.7577 AlertProcessor ProcessorAlertData: started 2025-12-21 16:31:13.9921 AlertProcessor ProcessorAlertData: Stopped 2025-12-21 16:36:00.6969 DFramework.Database.Query /* Time Taken: 1048*/ [dbo].GenerateSystemAlerts 2025-12-21 16:36:08.7750 AlertProcessor ProcessorAlertData: started 2025-12-21 16:36:14.1032 AlertProcessor ProcessorAlertData: Stopped 2025-12-21 16:36:14.6813 DFramework.Scheduler.TaskBase /* Time Taken: 15718.8409*/ Opportunity Out Of Stock By Outlet 2025-12-21 16:41:08.7769 AlertProcessor ProcessorAlertData: started 2025-12-21 16:41:14.0426 AlertProcessor ProcessorAlertData: Stopped 2025-12-21 16:46:08.7946 AlertProcessor ProcessorAlertData: started 2025-12-21 16:46:13.9821 AlertProcessor ProcessorAlertData: Stopped 2025-12-21 16:51:01.0462 DFramework.Database.Query /* Time Taken: 1402*/ [dbo].GenerateSystemAlerts 2025-12-21 16:51:08.8119 AlertProcessor ProcessorAlertData: started 2025-12-21 16:51:10.4525 DFramework.Database.Query /* Time Taken: 556*/ DECLARE @StatusId Int32 SET @StatusId = '1' DECLARE @AlertId Int32 SET @AlertId = '7571914' SELECT TOP 10000 Alert.AlertId, Alert.LocationId, Alert.RecordId, ISNULL(AlertDefinition.Name, Alert.AlertText) Name, Alert.AlertTypeId, Alert.AlertText, ISNULL(Location.Name, '') AS LocationName, AlertDefinition.ClientId, AlertRecipient.RoleId, CASE WHEN Alert.AlertTypeId IN (6,7) THEN CONVERT(VARCHAR(10), CAST(AlertAt AS DATE), 101) ELSE AlertAt END AS AlertAt, AlertType, Asset.SerialNumber, ISNULL(LocationAttribute.FirstRepId, 0) RepId, ClientUser.PrimaryPhone AS SalesRepPhone, ClientUser.PrimaryEmail AS SalesRepEmail, FirstName, LastName, PreferedNotificationTypeIds, AlertRecipientId, AlertRecipientAddress, AlertRecipientText, Alert.Tags, AlertRecipientTypeId, NotificationContactTypeId, TemplateId, AlertDefinition.AlertAgeThreshold, LastUpdatedOn, AlertRecipient.AlertAge, CASE WHEN Location.TimeZoneId IS NOT NULL AND Location.TimeZoneId > 0 THEN Location.TimeZoneId ELSE Client.TimeZoneId END AS TimeZoneId, AlertDefinition.IsSummarize, Alert.ClosedOn, AssetType.IsChestCooler, AlertDefinition.SnoozeForHours, Alert.SnoozeDateTime FROM Alert LEFT OUTER JOIN Asset ON Alert.AssetId = Asset.AssetId LEFT OUTER JOIN AlertType ON Alert.AlertTypeId = AlertType.AlertTypeId LEFT OUTER JOIN AlertDefinition ON Alert.AlertDefinitionId = AlertDefinition.AlertDefinitionId LEFT OUTER JOIN Location ON Location.LocationId = Alert.LocationId LEFT OUTER JOIN LocationAttribute ON LocationAttribute.LocationId = dbo.Location.LocationId LEFT OUTER JOIN ClientUser ON LocationAttribute.FirstRepId = ClientUser.ClientUserId AND ClientUser.IsDeleted = 0 LEFT OUTER JOIN AlertRecipient ON Alert.AlertDefinitionId = AlertRecipient.AlertDefinitionId AND AlertRecipient.IsDeleted= 0 LEFT OUTER JOIN Client ON Client.ClientId = Alert.ClientId LEFT OUTER JOIN AssetType ON dbo.Asset.AssetTypeId = dbo.AssetType.AssetTypeId WHERE (NOT EXISTS(SELECT 1 FROM dbo.EmailQueue INNER JOIN dbo.EmailRecipient ON EmailRecipient.EmailQueueId = EmailQueue.EmailQueueId WHERE AlertId = Alert.AlertId AND EmailRecipient.RecipientId = AlertRecipient.AlertRecipientId) OR (Alert.SnoozeDateTime IS NOT NULL AND Alert.SnoozeDateTime <= GETUTCDATE() AND AlertDefinition.SnoozeForHours > 0 AND Alert.StatusId = @StatusId)) AND Alert.AlertId > @AlertId AND Alert.AlertAt >= DATEADD(DAY, -120, GETDATE()) AND AlertRecipient.IsDeleted = 0 AND Alert.IsActive = 1 AND Alert.IsDeleted = 0 AND AlertRecipient.IsActive = 1 AND AlertRecipient.IsDeleted = 0 AND AlertRecipient.StartDate <= Alert.CreatedOn AND Alert.CreatedOn < DATEADD(hh, 23, AlertRecipient.EndDate) AND (Alert.LocationId != 0 OR NotificationWithoutLocation = 1) AND AlertType.IsSystemAlert = 0 AND Alert.EmailQueuedOn IS NULL AND AlertDefinition.IsActive = 1 2025-12-21 16:51:14.3588 AlertProcessor ProcessorAlertData: Stopped 2025-12-21 16:51:14.5931 DFramework.Scheduler.TaskBase /* Time Taken: 15609.4559*/ Opportunity Out Of Stock By Outlet 2025-12-21 16:56:08.8293 AlertProcessor ProcessorAlertData: started 2025-12-21 16:56:14.2356 AlertProcessor ProcessorAlertData: Stopped 2025-12-21 17:01:08.8468 AlertProcessor ProcessorAlertData: started 2025-12-21 17:01:14.1125 AlertProcessor ProcessorAlertData: Stopped 2025-12-21 17:06:01.0206 DFramework.Database.Query /* Time Taken: 1361*/ [dbo].GenerateSystemAlerts 2025-12-21 17:06:08.8643 AlertProcessor ProcessorAlertData: started 2025-12-21 17:06:14.1300 AlertProcessor ProcessorAlertData: Stopped 2025-12-21 17:06:14.5988 DFramework.Scheduler.TaskBase /* Time Taken: 15609.446*/ Opportunity Out Of Stock By Outlet 2025-12-21 17:11:08.8660 AlertProcessor ProcessorAlertData: started 2025-12-21 17:11:14.1161 AlertProcessor ProcessorAlertData: Stopped 2025-12-21 17:16:08.8836 AlertProcessor ProcessorAlertData: started 2025-12-21 17:16:14.0711 AlertProcessor ProcessorAlertData: Stopped 2025-12-21 17:21:00.7136 DFramework.Database.Query /* Time Taken: 1034*/ [dbo].GenerateSystemAlerts 2025-12-21 17:21:08.9012 AlertProcessor ProcessorAlertData: started 2025-12-21 17:21:14.1199 AlertProcessor ProcessorAlertData: Stopped 2025-12-21 17:21:14.6043 DFramework.Scheduler.TaskBase /* Time Taken: 15593.8578*/ Opportunity Out Of Stock By Outlet 2025-12-21 17:26:08.9188 AlertProcessor ProcessorAlertData: started 2025-12-21 17:26:14.1532 AlertProcessor ProcessorAlertData: Stopped 2025-12-21 17:31:08.9364 AlertProcessor ProcessorAlertData: started 2025-12-21 17:31:14.3270 AlertProcessor ProcessorAlertData: Stopped 2025-12-21 17:36:00.7508 DFramework.Database.Query /* Time Taken: 1060*/ [dbo].GenerateSystemAlerts 2025-12-21 17:36:08.9540 AlertProcessor ProcessorAlertData: started 2025-12-21 17:36:14.3134 AlertProcessor ProcessorAlertData: Stopped 2025-12-21 17:36:14.6103 DFramework.Scheduler.TaskBase /* Time Taken: 15578.2507*/ Opportunity Out Of Stock By Outlet 2025-12-21 17:41:08.9713 AlertProcessor ProcessorAlertData: started 2025-12-21 17:41:14.2213 AlertProcessor ProcessorAlertData: Stopped 2025-12-21 17:46:08.9885 AlertProcessor ProcessorAlertData: started 2025-12-21 17:46:14.3792 DFramework.Database.NullableDataReader Data reader open for 280 at System.Environment.GetStackTrace(Exception e, Boolean needFileInfo) at System.Environment.get_StackTrace() at DFramework.Database.NullableDataReader.Dispose(Boolean disposing) in D:\Spraxa\Framework\DFramework\Database\NullableDataReader.cs:line 33 at DFramework.Database.NullableDataReader.Dispose() in D:\Spraxa\Framework\DFramework\Database\NullableDataReader.cs:line 44 at CoolR.Tasks.ProcessAlertData.Execute() in D:\Spraxa\CoolR-Group\portal\CoolR.Tasks\ProcessAlertData.cs:line 47 at DFramework.Scheduler.TaskBase.Run() in D:\Spraxa\Framework\DFramework.Scheduler\TaskBase.cs:line 176 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.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state) at System.Threading.ThreadHelper.ThreadStart() 2025-12-21 17:46:14.3792 AlertProcessor ProcessorAlertData: Stopped 2025-12-21 17:51:00.9435 DFramework.Database.Query /* Time Taken: 1233*/ [dbo].GenerateSystemAlerts 2025-12-21 17:51:09.0060 AlertProcessor ProcessorAlertData: started 2025-12-21 17:51:14.1936 AlertProcessor ProcessorAlertData: Stopped 2025-12-21 17:51:14.6311 DFramework.Scheduler.TaskBase /* Time Taken: 15578.2266*/ Opportunity Out Of Stock By Outlet 2025-12-21 17:56:09.0080 AlertProcessor ProcessorAlertData: started 2025-12-21 17:56:14.2737 AlertProcessor ProcessorAlertData: Stopped 2025-12-21 18:01:09.0095 AlertProcessor ProcessorAlertData: started 2025-12-21 18:01:11.3845 DFramework.Database.NullableDataReader Data reader open for 284 at System.Environment.GetStackTrace(Exception e, Boolean needFileInfo) at System.Environment.get_StackTrace() at DFramework.Database.NullableDataReader.Dispose(Boolean disposing) in D:\Spraxa\Framework\DFramework\Database\NullableDataReader.cs:line 33 at DFramework.Database.NullableDataReader.Dispose() in D:\Spraxa\Framework\DFramework\Database\NullableDataReader.cs:line 44 at CoolR.Tasks.ProcessAlertData.Execute() in D:\Spraxa\CoolR-Group\portal\CoolR.Tasks\ProcessAlertData.cs:line 47 at DFramework.Scheduler.TaskBase.Run() in D:\Spraxa\Framework\DFramework.Scheduler\TaskBase.cs:line 176 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.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state) at System.Threading.ThreadHelper.ThreadStart() 2025-12-21 18:01:15.0720 AlertProcessor ProcessorAlertData: Stopped 2025-12-21 18:06:01.2925 DFramework.Database.Query /* Time Taken: 1548*/ [dbo].GenerateSystemAlerts 2025-12-21 18:06:09.0270 AlertProcessor ProcessorAlertData: started 2025-12-21 18:06:14.3239 AlertProcessor ProcessorAlertData: Stopped 2025-12-21 18:06:14.7926 DFramework.Scheduler.TaskBase /* Time Taken: 15734.4769*/ Opportunity Out Of Stock By Outlet 2025-12-21 18:11:09.0445 AlertProcessor ProcessorAlertData: started 2025-12-21 18:11:14.5446 AlertProcessor ProcessorAlertData: Stopped 2025-12-21 18:16:09.0620 AlertProcessor ProcessorAlertData: started 2025-12-21 18:16:14.4057 AlertProcessor ProcessorAlertData: Stopped 2025-12-21 18:21:01.2513 DFramework.Database.Query /* Time Taken: 1484*/ [dbo].GenerateSystemAlerts 2025-12-21 18:21:09.0795 AlertProcessor ProcessorAlertData: started 2025-12-21 18:21:11.8138 DFramework.Database.Query /* Time Taken: 1626*/ DECLARE @StatusId Int32 SET @StatusId = '1' DECLARE @AlertId Int32 SET @AlertId = '7571914' SELECT TOP 10000 Alert.AlertId, Alert.LocationId, Alert.RecordId, ISNULL(AlertDefinition.Name, Alert.AlertText) Name, Alert.AlertTypeId, Alert.AlertText, ISNULL(Location.Name, '') AS LocationName, AlertDefinition.ClientId, AlertRecipient.RoleId, CASE WHEN Alert.AlertTypeId IN (6,7) THEN CONVERT(VARCHAR(10), CAST(AlertAt AS DATE), 101) ELSE AlertAt END AS AlertAt, AlertType, Asset.SerialNumber, ISNULL(LocationAttribute.FirstRepId, 0) RepId, ClientUser.PrimaryPhone AS SalesRepPhone, ClientUser.PrimaryEmail AS SalesRepEmail, FirstName, LastName, PreferedNotificationTypeIds, AlertRecipientId, AlertRecipientAddress, AlertRecipientText, Alert.Tags, AlertRecipientTypeId, NotificationContactTypeId, TemplateId, AlertDefinition.AlertAgeThreshold, LastUpdatedOn, AlertRecipient.AlertAge, CASE WHEN Location.TimeZoneId IS NOT NULL AND Location.TimeZoneId > 0 THEN Location.TimeZoneId ELSE Client.TimeZoneId END AS TimeZoneId, AlertDefinition.IsSummarize, Alert.ClosedOn, AssetType.IsChestCooler, AlertDefinition.SnoozeForHours, Alert.SnoozeDateTime FROM Alert LEFT OUTER JOIN Asset ON Alert.AssetId = Asset.AssetId LEFT OUTER JOIN AlertType ON Alert.AlertTypeId = AlertType.AlertTypeId LEFT OUTER JOIN AlertDefinition ON Alert.AlertDefinitionId = AlertDefinition.AlertDefinitionId LEFT OUTER JOIN Location ON Location.LocationId = Alert.LocationId LEFT OUTER JOIN LocationAttribute ON LocationAttribute.LocationId = dbo.Location.LocationId LEFT OUTER JOIN ClientUser ON LocationAttribute.FirstRepId = ClientUser.ClientUserId AND ClientUser.IsDeleted = 0 LEFT OUTER JOIN AlertRecipient ON Alert.AlertDefinitionId = AlertRecipient.AlertDefinitionId AND AlertRecipient.IsDeleted= 0 LEFT OUTER JOIN Client ON Client.ClientId = Alert.ClientId LEFT OUTER JOIN AssetType ON dbo.Asset.AssetTypeId = dbo.AssetType.AssetTypeId WHERE (NOT EXISTS(SELECT 1 FROM dbo.EmailQueue INNER JOIN dbo.EmailRecipient ON EmailRecipient.EmailQueueId = EmailQueue.EmailQueueId WHERE AlertId = Alert.AlertId AND EmailRecipient.RecipientId = AlertRecipient.AlertRecipientId) OR (Alert.SnoozeDateTime IS NOT NULL AND Alert.SnoozeDateTime <= GETUTCDATE() AND AlertDefinition.SnoozeForHours > 0 AND Alert.StatusId = @StatusId)) AND Alert.AlertId > @AlertId AND Alert.AlertAt >= DATEADD(DAY, -120, GETDATE()) AND AlertRecipient.IsDeleted = 0 AND Alert.IsActive = 1 AND Alert.IsDeleted = 0 AND AlertRecipient.IsActive = 1 AND AlertRecipient.IsDeleted = 0 AND AlertRecipient.StartDate <= Alert.CreatedOn AND Alert.CreatedOn < DATEADD(hh, 23, AlertRecipient.EndDate) AND (Alert.LocationId != 0 OR NotificationWithoutLocation = 1) AND AlertType.IsSystemAlert = 0 AND Alert.EmailQueuedOn IS NULL AND AlertDefinition.IsActive = 1 2025-12-21 18:21:14.7357 AlertProcessor ProcessorAlertData: Stopped 2025-12-21 18:21:14.7670 DFramework.Scheduler.TaskBase /* Time Taken: 15687.6035*/ Opportunity Out Of Stock By Outlet 2025-12-21 18:26:09.0970 AlertProcessor ProcessorAlertData: started 2025-12-21 18:26:14.3783 AlertProcessor ProcessorAlertData: Stopped 2025-12-21 18:31:09.1146 AlertProcessor ProcessorAlertData: started 2025-12-21 18:31:14.3802 AlertProcessor ProcessorAlertData: Stopped 2025-12-21 18:36:01.1319 DFramework.Database.Query /* Time Taken: 1351*/ [dbo].GenerateSystemAlerts 2025-12-21 18:36:01.7569 MoveToReorder Running task for ClientId : 286 and ClientName = India Office QA and Slot: 12/22/2025 8:00:00 AM And LastExecutedOn: 12/20/2025 10:05:58 PM 2025-12-21 18:36:09.1319 AlertProcessor ProcessorAlertData: started 2025-12-21 18:36:12.1007 DFramework.Database.Query /* Time Taken: 1060*/ DECLARE @TableName AnsiString(8000) SET @TableName = 'OpportunityOutOfStockConsolidate' DECLARE @CurrentRecordId Int32 SET @CurrentRecordId = '3674617' dbo.GetValidDeviceForAlertProcessData 2025-12-21 18:36:12.7413 DFramework.Database.Query /* Time Taken: 594*/ DECLARE @TableName AnsiString(8000) SET @TableName = 'AssetStockProductWiseConsolidate' DECLARE @CurrentRecordId Int32 SET @CurrentRecordId = '3674617' dbo.GetValidDeviceForAlertProcessData 2025-12-21 18:36:14.9132 DFramework.Scheduler.TaskBase /* Time Taken: 15828.2255*/ Opportunity Out Of Stock By Outlet 2025-12-21 18:36:15.5694 AlertProcessor ProcessorAlertData: Stopped 2025-12-21 18:36:44.6634 DFramework.Database.NullableDataReader Data reader open for 42487 at System.Environment.GetStackTrace(Exception e, Boolean needFileInfo) at System.Environment.get_StackTrace() at DFramework.Database.NullableDataReader.Dispose(Boolean disposing) in D:\Spraxa\Framework\DFramework\Database\NullableDataReader.cs:line 33 at DFramework.Database.NullableDataReader.Dispose() in D:\Spraxa\Framework\DFramework\Database\NullableDataReader.cs:line 44 at CoolR.Tasks.MoveToReorder.Execute() in D:\Spraxa\CoolR-Group\portal\CoolR.Tasks\MoveToReorder.cs:line 44 at DFramework.Scheduler.TaskBase.Run() in D:\Spraxa\Framework\DFramework.Scheduler\TaskBase.cs:line 176 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.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state) at System.Threading.ThreadHelper.ThreadStart() 2025-12-21 18:36:44.6946 MoveToReorder Task executed successfully for ClientId : 286 Client Name:India Office QA, Slot: 12/22/2025 8:00:00 AM and Total Order Suggested: 123 Out Of: 123 2025-12-21 18:36:45.8978 DFramework.Database.Query /* Time Taken: 671*/ DECLARE @ClientId Int32 SET @ClientId = '286' DECLARE @OrderStatusId Int32 SET @OrderStatusId = '5485' SELECT * FROM vwScheduledOrderExportInfoList WHERE [ClientId] = @ClientId AND [OrderStatusId] = @OrderStatusId ORDER BY [LocationId] 2025-12-21 18:36:46.1478 DFramework.Scheduler.TaskBase /* Time Taken: 44719.027*/ Move To Re-Order 2025-12-21 18:41:09.1495 AlertProcessor ProcessorAlertData: started 2025-12-21 18:41:14.4776 AlertProcessor ProcessorAlertData: Stopped 2025-12-21 18:46:09.1514 AlertProcessor ProcessorAlertData: started 2025-12-21 18:46:14.7452 AlertProcessor ProcessorAlertData: Stopped 2025-12-21 18:51:01.0592 DFramework.Database.Query /* Time Taken: 1253*/ [dbo].GenerateSystemAlerts 2025-12-21 18:51:09.1530 AlertProcessor ProcessorAlertData: started 2025-12-21 18:51:14.4812 AlertProcessor ProcessorAlertData: Stopped 2025-12-21 18:51:14.6531 DFramework.Scheduler.TaskBase /* Time Taken: 15546.9609*/ Opportunity Out Of Stock By Outlet 2025-12-21 18:56:09.1704 AlertProcessor ProcessorAlertData: started 2025-12-21 18:56:14.6549 AlertProcessor ProcessorAlertData: Stopped 2025-12-21 19:01:09.1880 AlertProcessor ProcessorAlertData: started 2025-12-21 19:01:10.4693 DFramework.Database.NullableDataReader Data reader open for 397 at System.Environment.GetStackTrace(Exception e, Boolean needFileInfo) at System.Environment.get_StackTrace() at DFramework.Database.NullableDataReader.Dispose(Boolean disposing) in D:\Spraxa\Framework\DFramework\Database\NullableDataReader.cs:line 33 at DFramework.Database.NullableDataReader.Dispose() in D:\Spraxa\Framework\DFramework\Database\NullableDataReader.cs:line 44 at CoolR.Tasks.ProcessAlertData.Execute() in D:\Spraxa\CoolR-Group\portal\CoolR.Tasks\ProcessAlertData.cs:line 47 at DFramework.Scheduler.TaskBase.Run() in D:\Spraxa\Framework\DFramework.Scheduler\TaskBase.cs:line 176 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.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state) at System.Threading.ThreadHelper.ThreadStart() 2025-12-21 19:01:14.9381 AlertProcessor ProcessorAlertData: Stopped 2025-12-21 19:06:01.2680 DFramework.Database.Query /* Time Taken: 1439*/ [dbo].GenerateSystemAlerts 2025-12-21 19:06:09.2055 AlertProcessor ProcessorAlertData: started 2025-12-21 19:06:14.4556 AlertProcessor ProcessorAlertData: Stopped 2025-12-21 19:06:14.6587 DFramework.Scheduler.TaskBase /* Time Taken: 15531.3362*/ Opportunity Out Of Stock By Outlet 2025-12-21 19:11:09.2231 AlertProcessor ProcessorAlertData: started 2025-12-21 19:11:14.4887 AlertProcessor ProcessorAlertData: Stopped 2025-12-21 19:16:09.2250 AlertProcessor ProcessorAlertData: started 2025-12-21 19:16:14.4126 AlertProcessor ProcessorAlertData: Stopped 2025-12-21 19:21:00.9301 DFramework.Database.Query /* Time Taken: 1078*/ [dbo].GenerateSystemAlerts 2025-12-21 19:21:09.2426 AlertProcessor ProcessorAlertData: started 2025-12-21 19:21:14.5083 AlertProcessor ProcessorAlertData: Stopped 2025-12-21 19:21:14.6958 DFramework.Scheduler.TaskBase /* Time Taken: 15546.9815*/ Opportunity Out Of Stock By Outlet 2025-12-21 19:26:09.2597 AlertProcessor ProcessorAlertData: started 2025-12-21 19:26:14.4160 AlertProcessor ProcessorAlertData: Stopped 2025-12-21 19:31:09.2771 AlertProcessor ProcessorAlertData: started 2025-12-21 19:31:14.4646 AlertProcessor ProcessorAlertData: Stopped 2025-12-21 19:36:00.9352 DFramework.Database.Query /* Time Taken: 1064*/ [dbo].GenerateSystemAlerts 2025-12-21 19:36:01.8415 MoveToReorder Running task for ClientId : 286 and ClientName = India Office QA and Slot: 12/22/2025 9:00:00 AM And LastExecutedOn: 12/22/2025 8:06:01 AM 2025-12-21 19:36:01.9977 MoveToReorder Task executed successfully for ClientId : 286 Client Name:India Office QA, Slot: 12/22/2025 9:00:00 AM But No Order found to suggest 2025-12-21 19:36:09.2947 AlertProcessor ProcessorAlertData: started 2025-12-21 19:36:14.7166 AlertProcessor ProcessorAlertData: Stopped 2025-12-21 19:36:14.8572 DFramework.Scheduler.TaskBase /* Time Taken: 15687.5924*/ Opportunity Out Of Stock By Outlet 2025-12-21 19:41:09.3118 AlertProcessor ProcessorAlertData: started 2025-12-21 19:41:14.6555 AlertProcessor ProcessorAlertData: Stopped 2025-12-21 19:46:09.3288 AlertProcessor ProcessorAlertData: started 2025-12-21 19:46:14.4538 AlertProcessor ProcessorAlertData: Stopped 2025-12-21 19:51:01.3150 DFramework.Database.Query /* Time Taken: 1429*/ [dbo].GenerateSystemAlerts 2025-12-21 19:51:09.3462 AlertProcessor ProcessorAlertData: started 2025-12-21 19:51:11.9556 DFramework.Database.Query /* Time Taken: 1526*/ DECLARE @StatusId Int32 SET @StatusId = '1' DECLARE @AlertId Int32 SET @AlertId = '7571914' SELECT TOP 10000 Alert.AlertId, Alert.LocationId, Alert.RecordId, ISNULL(AlertDefinition.Name, Alert.AlertText) Name, Alert.AlertTypeId, Alert.AlertText, ISNULL(Location.Name, '') AS LocationName, AlertDefinition.ClientId, AlertRecipient.RoleId, CASE WHEN Alert.AlertTypeId IN (6,7) THEN CONVERT(VARCHAR(10), CAST(AlertAt AS DATE), 101) ELSE AlertAt END AS AlertAt, AlertType, Asset.SerialNumber, ISNULL(LocationAttribute.FirstRepId, 0) RepId, ClientUser.PrimaryPhone AS SalesRepPhone, ClientUser.PrimaryEmail AS SalesRepEmail, FirstName, LastName, PreferedNotificationTypeIds, AlertRecipientId, AlertRecipientAddress, AlertRecipientText, Alert.Tags, AlertRecipientTypeId, NotificationContactTypeId, TemplateId, AlertDefinition.AlertAgeThreshold, LastUpdatedOn, AlertRecipient.AlertAge, CASE WHEN Location.TimeZoneId IS NOT NULL AND Location.TimeZoneId > 0 THEN Location.TimeZoneId ELSE Client.TimeZoneId END AS TimeZoneId, AlertDefinition.IsSummarize, Alert.ClosedOn, AssetType.IsChestCooler, AlertDefinition.SnoozeForHours, Alert.SnoozeDateTime FROM Alert LEFT OUTER JOIN Asset ON Alert.AssetId = Asset.AssetId LEFT OUTER JOIN AlertType ON Alert.AlertTypeId = AlertType.AlertTypeId LEFT OUTER JOIN AlertDefinition ON Alert.AlertDefinitionId = AlertDefinition.AlertDefinitionId LEFT OUTER JOIN Location ON Location.LocationId = Alert.LocationId LEFT OUTER JOIN LocationAttribute ON LocationAttribute.LocationId = dbo.Location.LocationId LEFT OUTER JOIN ClientUser ON LocationAttribute.FirstRepId = ClientUser.ClientUserId AND ClientUser.IsDeleted = 0 LEFT OUTER JOIN AlertRecipient ON Alert.AlertDefinitionId = AlertRecipient.AlertDefinitionId AND AlertRecipient.IsDeleted= 0 LEFT OUTER JOIN Client ON Client.ClientId = Alert.ClientId LEFT OUTER JOIN AssetType ON dbo.Asset.AssetTypeId = dbo.AssetType.AssetTypeId WHERE (NOT EXISTS(SELECT 1 FROM dbo.EmailQueue INNER JOIN dbo.EmailRecipient ON EmailRecipient.EmailQueueId = EmailQueue.EmailQueueId WHERE AlertId = Alert.AlertId AND EmailRecipient.RecipientId = AlertRecipient.AlertRecipientId) OR (Alert.SnoozeDateTime IS NOT NULL AND Alert.SnoozeDateTime <= GETUTCDATE() AND AlertDefinition.SnoozeForHours > 0 AND Alert.StatusId = @StatusId)) AND Alert.AlertId > @AlertId AND Alert.AlertAt >= DATEADD(DAY, -120, GETDATE()) AND AlertRecipient.IsDeleted = 0 AND Alert.IsActive = 1 AND Alert.IsDeleted = 0 AND AlertRecipient.IsActive = 1 AND AlertRecipient.IsDeleted = 0 AND AlertRecipient.StartDate <= Alert.CreatedOn AND Alert.CreatedOn < DATEADD(hh, 23, AlertRecipient.EndDate) AND (Alert.LocationId != 0 OR NotificationWithoutLocation = 1) AND AlertType.IsSystemAlert = 0 AND Alert.EmailQueuedOn IS NULL AND AlertDefinition.IsActive = 1 2025-12-21 19:51:14.7682 DFramework.Scheduler.TaskBase /* Time Taken: 15578.2282*/ Opportunity Out Of Stock By Outlet 2025-12-21 19:51:15.1275 AlertProcessor ProcessorAlertData: Stopped 2025-12-21 19:56:09.3638 AlertProcessor ProcessorAlertData: started 2025-12-21 19:56:14.6295 AlertProcessor ProcessorAlertData: Stopped 2025-12-21 20:01:09.3817 AlertProcessor ProcessorAlertData: started 2025-12-21 20:01:14.6161 AlertProcessor ProcessorAlertData: Stopped 2025-12-21 20:06:01.2587 DFramework.Database.Query /* Time Taken: 1363*/ [dbo].GenerateSystemAlerts 2025-12-21 20:06:09.3994 AlertProcessor ProcessorAlertData: started 2025-12-21 20:06:14.6181 AlertProcessor ProcessorAlertData: Stopped 2025-12-21 20:06:14.8369 DFramework.Scheduler.TaskBase /* Time Taken: 15625.0979*/ Opportunity Out Of Stock By Outlet 2025-12-21 20:11:09.4013 AlertProcessor ProcessorAlertData: started 2025-12-21 20:11:14.6826 AlertProcessor ProcessorAlertData: Stopped 2025-12-21 20:16:09.4187 AlertProcessor ProcessorAlertData: started 2025-12-21 20:16:14.8406 AlertProcessor ProcessorAlertData: Stopped 2025-12-21 20:21:00.9829 DFramework.Database.Query /* Time Taken: 1074*/ [dbo].GenerateSystemAlerts 2025-12-21 20:21:09.4361 AlertProcessor ProcessorAlertData: started 2025-12-21 20:21:14.8424 AlertProcessor ProcessorAlertData: Stopped 2025-12-21 20:21:14.8580 DFramework.Scheduler.TaskBase /* Time Taken: 15625.0763*/ Opportunity Out Of Stock By Outlet 2025-12-21 20:26:09.4537 AlertProcessor ProcessorAlertData: started 2025-12-21 20:26:14.6412 AlertProcessor ProcessorAlertData: Stopped 2025-12-21 20:31:09.4556 AlertProcessor ProcessorAlertData: started 2025-12-21 20:31:11.5649 DFramework.Database.Query /* Time Taken: 529*/ DECLARE @AlertTypeIds AnsiString(8000) SET @AlertTypeIds = '42,31,44,18,58,52,64,61,46,73,59,65,69,72,60,74,68,39,51,56,32,55,38,63,77,76' DECLARE @ClientIds AnsiString(8000) SET @ClientIds = '360,1494,213,286,395,70,291,335,452' DECLARE @StatusId Int32 SET @StatusId = '1' SELECT ClientName, AlertType, AlertText, Location.Name AS [Location], Location.Code AS LocationCode, Asset.SerialNumber AS AssetSerialNumber, COALESCE(SmartDevice.SerialNumber, SD.SerialNumber) AS SmartDeviceSerial, AlertAt, AccountCoordinators.PrimaryEmail AS AccountCoordinator, AccountDirectors.PrimaryEmail AS AccountDirector, Alert.ClientId FROM Alert LEFT OUTER JOIN Client ON Client.ClientId = Alert.ClientId LEFT OUTER JOIN AlertType ON AlertType.AlertTypeId = Alert.AlertTypeId LEFT OUTER JOIN Location ON Location.LocationId = Alert.LocationId LEFT OUTER JOIN Asset ON Asset.AssetId = Alert.AssetId LEFT OUTER JOIN SmartDevice ON SmartDevice.SmartDeviceId = Alert.SmartDeviceId AND SmartDevice.IsGatewayDevice = 0 LEFT OUTER JOIN vwSmartDeviceExceptSmartHubList AS SD ON dbo.Alert.AssetId = SD.LinkedAssetId AND SD.LinkedAssetId <> 0 LEFT OUTER JOIN dbo.Security_User AS AccountDirectors ON Client.AccountDirectorId = AccountDirectors.UserId AND AccountDirectors.IsDeleted = 0 LEFT OUTER JOIN dbo.Security_User AS AccountCoordinators ON Client.AccountCoordinatorId = AccountCoordinators.UserId AND AccountCoordinators.IsDeleted = 0 WHERE Alert.IsDeleted = 0 AND Alert.AlertTypeId IN (SELECT * FROM CsvToInt(@AlertTypeIds)) AND Alert.ClientId IN (SELECT * FROM CsvToInt(@ClientIds)) AND Alert.StatusId = @StatusId ORDER BY Alert.ClientId 2025-12-21 20:31:13.2993 DFramework.Database.Query /* Time Taken: 1249*/ DECLARE @AlertTypeIds AnsiString(8000) SET @AlertTypeIds = '73,59,57,66,65,70,9,72,60,74,68,56,55,61,67,64,44,18,58,69,52,38,31,51,49,12,46,28,41,19,76' DECLARE @ClientIds AnsiString(8000) SET @ClientIds = '349,286,430,395,414,471,360,1494,213,70,415,134,451,207,385,188,224,421,333,291,227,114,306,1480,180,308,1496,295,183,325,469,299,342,221,229,300,320,296,336,314,338,301,316,303,331,305,332,328,335,337,1476,322,355,124,1481,289,222,452' DECLARE @StatusId Int32 SET @StatusId = '1' SELECT ClientName, AlertType, AlertText, Location.Name AS [Location], Location.Code AS LocationCode, Asset.SerialNumber AS AssetSerialNumber, COALESCE(SmartDevice.SerialNumber, SD.SerialNumber) AS SmartDeviceSerial, AlertAt, AccountCoordinators.PrimaryEmail AS AccountCoordinator, AccountDirectors.PrimaryEmail AS AccountDirector, Alert.ClientId FROM Alert LEFT OUTER JOIN Client ON Client.ClientId = Alert.ClientId LEFT OUTER JOIN AlertType ON AlertType.AlertTypeId = Alert.AlertTypeId LEFT OUTER JOIN Location ON Location.LocationId = Alert.LocationId LEFT OUTER JOIN Asset ON Asset.AssetId = Alert.AssetId LEFT OUTER JOIN SmartDevice ON SmartDevice.SmartDeviceId = Alert.SmartDeviceId AND SmartDevice.IsGatewayDevice = 0 LEFT OUTER JOIN vwSmartDeviceExceptSmartHubList AS SD ON dbo.Alert.AssetId = SD.LinkedAssetId AND SD.LinkedAssetId <> 0 LEFT OUTER JOIN dbo.Security_User AS AccountDirectors ON Client.AccountDirectorId = AccountDirectors.UserId AND AccountDirectors.IsDeleted = 0 LEFT OUTER JOIN dbo.Security_User AS AccountCoordinators ON Client.AccountCoordinatorId = AccountCoordinators.UserId AND AccountCoordinators.IsDeleted = 0 WHERE Alert.IsDeleted = 0 AND Alert.AlertTypeId IN (SELECT * FROM CsvToInt(@AlertTypeIds)) AND Alert.ClientId IN (SELECT * FROM CsvToInt(@ClientIds)) AND Alert.StatusId = @StatusId ORDER BY Alert.ClientId 2025-12-21 20:31:15.0337 AlertProcessor ProcessorAlertData: Stopped 2025-12-21 20:36:01.0042 DFramework.Database.Query /* Time Taken: 1074*/ [dbo].GenerateSystemAlerts 2025-12-21 20:36:02.2854 MoveToReorder Running task for ClientId : 286 and ClientName = India Office QA and Slot: 12/22/2025 10:00:00 AM And LastExecutedOn: 12/22/2025 9:06:01 AM 2025-12-21 20:36:02.5198 MoveToReorder Task executed successfully for ClientId : 286 Client Name:India Office QA, Slot: 12/22/2025 10:00:00 AM But No Order found to suggest 2025-12-21 20:36:09.4730 AlertProcessor ProcessorAlertData: started 2025-12-21 20:36:14.6918 AlertProcessor ProcessorAlertData: Stopped 2025-12-21 20:36:14.8793 DFramework.Scheduler.TaskBase /* Time Taken: 15625.0973*/ Opportunity Out Of Stock By Outlet 2025-12-21 20:41:09.4905 AlertProcessor ProcessorAlertData: started 2025-12-21 20:41:14.6937 AlertProcessor ProcessorAlertData: Stopped 2025-12-21 20:46:09.5081 AlertProcessor ProcessorAlertData: started 2025-12-21 20:46:14.7269 AlertProcessor ProcessorAlertData: Stopped 2025-12-21 20:51:01.0410 DFramework.Database.Query /* Time Taken: 1085*/ [dbo].GenerateSystemAlerts 2025-12-21 20:51:09.5254 AlertProcessor ProcessorAlertData: started 2025-12-21 20:51:14.8536 DFramework.Scheduler.TaskBase /* Time Taken: 15578.2192*/ Opportunity Out Of Stock By Outlet 2025-12-21 20:51:14.9317 AlertProcessor ProcessorAlertData: Stopped 2025-12-21 20:56:09.5429 AlertProcessor ProcessorAlertData: started 2025-12-21 20:56:14.9179 AlertProcessor ProcessorAlertData: Stopped 2025-12-21 21:01:09.5605 AlertProcessor ProcessorAlertData: started 2025-12-21 21:01:12.5605 DFramework.Database.NullableDataReader Data reader open for 303 at System.Environment.GetStackTrace(Exception e, Boolean needFileInfo) at System.Environment.get_StackTrace() at DFramework.Database.NullableDataReader.Dispose(Boolean disposing) in D:\Spraxa\Framework\DFramework\Database\NullableDataReader.cs:line 33 at DFramework.Database.NullableDataReader.Dispose() in D:\Spraxa\Framework\DFramework\Database\NullableDataReader.cs:line 44 at CoolR.Tasks.ProcessAlertData.Execute() in D:\Spraxa\CoolR-Group\portal\CoolR.Tasks\ProcessAlertData.cs:line 47 at DFramework.Scheduler.TaskBase.Run() in D:\Spraxa\Framework\DFramework.Scheduler\TaskBase.cs:line 176 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.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state) at System.Threading.ThreadHelper.ThreadStart() 2025-12-21 21:01:15.1230 AlertProcessor ProcessorAlertData: Stopped 2025-12-21 21:06:01.0473 DFramework.Database.Query /* Time Taken: 1087*/ [dbo].GenerateSystemAlerts 2025-12-21 21:06:09.5786 AlertProcessor ProcessorAlertData: started 2025-12-21 21:06:14.8912 DFramework.Scheduler.TaskBase /* Time Taken: 15593.9116*/ Opportunity Out Of Stock By Outlet 2025-12-21 21:06:14.9068 AlertProcessor ProcessorAlertData: Stopped 2025-12-21 21:11:09.5968 AlertProcessor ProcessorAlertData: started 2025-12-21 21:11:14.8781 AlertProcessor ProcessorAlertData: Stopped 2025-12-21 21:16:09.6146 AlertProcessor ProcessorAlertData: started 2025-12-21 21:16:14.7396 DFramework.Database.NullableDataReader Data reader open for 284 at System.Environment.GetStackTrace(Exception e, Boolean needFileInfo) at System.Environment.get_StackTrace() at DFramework.Database.NullableDataReader.Dispose(Boolean disposing) in D:\Spraxa\Framework\DFramework\Database\NullableDataReader.cs:line 33 at DFramework.Database.NullableDataReader.Dispose() in D:\Spraxa\Framework\DFramework\Database\NullableDataReader.cs:line 44 at CoolR.Tasks.ProcessAlertData.Execute() in D:\Spraxa\CoolR-Group\portal\CoolR.Tasks\ProcessAlertData.cs:line 47 at DFramework.Scheduler.TaskBase.Run() in D:\Spraxa\Framework\DFramework.Scheduler\TaskBase.cs:line 176 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.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state) at System.Threading.ThreadHelper.ThreadStart() 2025-12-21 21:16:15.0678 AlertProcessor ProcessorAlertData: Stopped 2025-12-21 21:21:01.5228 DFramework.Database.Query /* Time Taken: 1545*/ [dbo].GenerateSystemAlerts 2025-12-21 21:21:09.6322 AlertProcessor ProcessorAlertData: started 2025-12-21 21:21:11.3197 DFramework.Database.Query /* Time Taken: 576*/ DECLARE @StatusId Int32 SET @StatusId = '1' DECLARE @AlertId Int32 SET @AlertId = '7571914' SELECT TOP 10000 Alert.AlertId, Alert.LocationId, Alert.RecordId, ISNULL(AlertDefinition.Name, Alert.AlertText) Name, Alert.AlertTypeId, Alert.AlertText, ISNULL(Location.Name, '') AS LocationName, AlertDefinition.ClientId, AlertRecipient.RoleId, CASE WHEN Alert.AlertTypeId IN (6,7) THEN CONVERT(VARCHAR(10), CAST(AlertAt AS DATE), 101) ELSE AlertAt END AS AlertAt, AlertType, Asset.SerialNumber, ISNULL(LocationAttribute.FirstRepId, 0) RepId, ClientUser.PrimaryPhone AS SalesRepPhone, ClientUser.PrimaryEmail AS SalesRepEmail, FirstName, LastName, PreferedNotificationTypeIds, AlertRecipientId, AlertRecipientAddress, AlertRecipientText, Alert.Tags, AlertRecipientTypeId, NotificationContactTypeId, TemplateId, AlertDefinition.AlertAgeThreshold, LastUpdatedOn, AlertRecipient.AlertAge, CASE WHEN Location.TimeZoneId IS NOT NULL AND Location.TimeZoneId > 0 THEN Location.TimeZoneId ELSE Client.TimeZoneId END AS TimeZoneId, AlertDefinition.IsSummarize, Alert.ClosedOn, AssetType.IsChestCooler, AlertDefinition.SnoozeForHours, Alert.SnoozeDateTime FROM Alert LEFT OUTER JOIN Asset ON Alert.AssetId = Asset.AssetId LEFT OUTER JOIN AlertType ON Alert.AlertTypeId = AlertType.AlertTypeId LEFT OUTER JOIN AlertDefinition ON Alert.AlertDefinitionId = AlertDefinition.AlertDefinitionId LEFT OUTER JOIN Location ON Location.LocationId = Alert.LocationId LEFT OUTER JOIN LocationAttribute ON LocationAttribute.LocationId = dbo.Location.LocationId LEFT OUTER JOIN ClientUser ON LocationAttribute.FirstRepId = ClientUser.ClientUserId AND ClientUser.IsDeleted = 0 LEFT OUTER JOIN AlertRecipient ON Alert.AlertDefinitionId = AlertRecipient.AlertDefinitionId AND AlertRecipient.IsDeleted= 0 LEFT OUTER JOIN Client ON Client.ClientId = Alert.ClientId LEFT OUTER JOIN AssetType ON dbo.Asset.AssetTypeId = dbo.AssetType.AssetTypeId WHERE (NOT EXISTS(SELECT 1 FROM dbo.EmailQueue INNER JOIN dbo.EmailRecipient ON EmailRecipient.EmailQueueId = EmailQueue.EmailQueueId WHERE AlertId = Alert.AlertId AND EmailRecipient.RecipientId = AlertRecipient.AlertRecipientId) OR (Alert.SnoozeDateTime IS NOT NULL AND Alert.SnoozeDateTime <= GETUTCDATE() AND AlertDefinition.SnoozeForHours > 0 AND Alert.StatusId = @StatusId)) AND Alert.AlertId > @AlertId AND Alert.AlertAt >= DATEADD(DAY, -120, GETDATE()) AND AlertRecipient.IsDeleted = 0 AND Alert.IsActive = 1 AND Alert.IsDeleted = 0 AND AlertRecipient.IsActive = 1 AND AlertRecipient.IsDeleted = 0 AND AlertRecipient.StartDate <= Alert.CreatedOn AND Alert.CreatedOn < DATEADD(hh, 23, AlertRecipient.EndDate) AND (Alert.LocationId != 0 OR NotificationWithoutLocation = 1) AND AlertType.IsSystemAlert = 0 AND Alert.EmailQueuedOn IS NULL AND AlertDefinition.IsActive = 1 2025-12-21 21:21:14.9448 DFramework.Scheduler.TaskBase /* Time Taken: 15625.097*/ Opportunity Out Of Stock By Outlet 2025-12-21 21:21:15.1166 AlertProcessor ProcessorAlertData: Stopped 2025-12-21 21:26:09.6485 AlertProcessor ProcessorAlertData: started 2025-12-21 21:26:15.1016 AlertProcessor ProcessorAlertData: Stopped 2025-12-21 21:31:09.6656 AlertProcessor ProcessorAlertData: started 2025-12-21 21:31:13.6188 DFramework.Database.Query /* Time Taken: 535*/ DECLARE @TableName AnsiString(8000) SET @TableName = 'OpportunityLowStock' DECLARE @CurrentRecordId Int32 SET @CurrentRecordId = '3674617' dbo.GetValidDeviceForAlertProcessData 2025-12-21 21:31:15.2594 AlertProcessor ProcessorAlertData: Stopped 2025-12-21 21:36:01.4018 DFramework.Database.Query /* Time Taken: 1401*/ [dbo].GenerateSystemAlerts 2025-12-21 21:36:02.0268 MoveToReorder Running task for ClientId : 286 and ClientName = India Office QA and Slot: 12/22/2025 11:00:00 AM And LastExecutedOn: 12/22/2025 10:06:02 AM 2025-12-21 21:36:09.6831 AlertProcessor ProcessorAlertData: started 2025-12-21 21:36:10.2456 DFramework.Database.Query /* Time Taken: 563*/ DECLARE @TableName AnsiString(8000) SET @TableName = 'TagAlert' DECLARE @CurrentRecordId Int32 SET @CurrentRecordId = '0' dbo.GetValidDeviceForAlertProcessData 2025-12-21 21:36:15.1050 DFramework.Scheduler.TaskBase /* Time Taken: 15765.741*/ Opportunity Out Of Stock By Outlet 2025-12-21 21:36:15.2144 DFramework.Database.Query /* Time Taken: 723*/ DECLARE @TableName AnsiString(8000) SET @TableName = 'LowInventoryConsolidate' DECLARE @CurrentRecordId Int32 SET @CurrentRecordId = '3674617' dbo.GetValidDeviceForAlertProcessData 2025-12-21 21:36:16.6362 DFramework.Database.Query /* Time Taken: 1327*/ DECLARE @TableName AnsiString(8000) SET @TableName = 'TargetPortfolioComplianceConsolidate' DECLARE @CurrentRecordId Int32 SET @CurrentRecordId = '3674617' dbo.GetValidDeviceForAlertProcessData 2025-12-21 21:36:17.2144 AlertProcessor ProcessorAlertData: Stopped 2025-12-21 21:36:46.5270 DFramework.Database.NullableDataReader Data reader open for 44275 at System.Environment.GetStackTrace(Exception e, Boolean needFileInfo) at System.Environment.get_StackTrace() at DFramework.Database.NullableDataReader.Dispose(Boolean disposing) in D:\Spraxa\Framework\DFramework\Database\NullableDataReader.cs:line 33 at DFramework.Database.NullableDataReader.Dispose() in D:\Spraxa\Framework\DFramework\Database\NullableDataReader.cs:line 44 at CoolR.Tasks.MoveToReorder.Execute() in D:\Spraxa\CoolR-Group\portal\CoolR.Tasks\MoveToReorder.cs:line 44 at DFramework.Scheduler.TaskBase.Run() in D:\Spraxa\Framework\DFramework.Scheduler\TaskBase.cs:line 176 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.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state) at System.Threading.ThreadHelper.ThreadStart() 2025-12-21 21:36:46.5583 MoveToReorder Task executed successfully for ClientId : 286 Client Name:India Office QA, Slot: 12/22/2025 11:00:00 AM and Total Order Suggested: 123 Out Of: 123 2025-12-21 21:36:47.2927 DFramework.Scheduler.TaskBase /* Time Taken: 45578.4114*/ Move To Re-Order 2025-12-21 21:41:09.7004 AlertProcessor ProcessorAlertData: started 2025-12-21 21:41:15.2786 AlertProcessor ProcessorAlertData: Stopped 2025-12-21 21:46:09.7179 AlertProcessor ProcessorAlertData: started 2025-12-21 21:46:15.1554 AlertProcessor ProcessorAlertData: Stopped 2025-12-21 21:51:01.1885 DFramework.Database.Query /* Time Taken: 1156*/ [dbo].GenerateSystemAlerts 2025-12-21 21:51:09.7354 AlertProcessor ProcessorAlertData: started 2025-12-21 21:51:14.9073 DFramework.Scheduler.TaskBase /* Time Taken: 15546.9604*/ Opportunity Out Of Stock By Outlet 2025-12-21 21:51:15.2198 AlertProcessor ProcessorAlertData: Stopped 2025-12-21 21:56:09.7529 AlertProcessor ProcessorAlertData: started 2025-12-21 21:56:15.4873 AlertProcessor ProcessorAlertData: Stopped 2025-12-21 22:01:09.7702 AlertProcessor ProcessorAlertData: started 2025-12-21 22:01:15.2703 AlertProcessor ProcessorAlertData: Stopped 2025-12-21 22:06:01.2408 DFramework.Database.Query /* Time Taken: 1205*/ [dbo].GenerateSystemAlerts 2025-12-21 22:06:09.7721 AlertProcessor ProcessorAlertData: started 2025-12-21 22:06:10.9752 DFramework.Database.Query /* Time Taken: 506*/ DECLARE @TableName AnsiString(8000) SET @TableName = 'MissingShelf' DECLARE @CurrentRecordId Int32 SET @CurrentRecordId = '3674617' dbo.GetValidDeviceForAlertProcessData 2025-12-21 22:06:14.9284 DFramework.Scheduler.TaskBase /* Time Taken: 15546.9758*/ Opportunity Out Of Stock By Outlet 2025-12-21 22:06:15.4753 AlertProcessor ProcessorAlertData: Stopped 2025-12-21 22:11:09.7897 AlertProcessor ProcessorAlertData: started 2025-12-21 22:11:10.7741 DFramework.Database.Query /* Time Taken: 535*/ DECLARE @TableName AnsiString(8000) SET @TableName = 'VoidAlert' DECLARE @CurrentRecordId Int32 SET @CurrentRecordId = '3674617' dbo.GetValidDeviceForAlertProcessData 2025-12-21 22:11:15.4772 AlertProcessor ProcessorAlertData: Stopped 2025-12-21 22:16:09.8070 AlertProcessor ProcessorAlertData: started 2025-12-21 22:16:15.3383 AlertProcessor ProcessorAlertData: Stopped 2025-12-21 22:21:01.1057 DFramework.Database.Query /* Time Taken: 1061*/ [dbo].GenerateSystemAlerts 2025-12-21 22:21:09.8088 AlertProcessor ProcessorAlertData: started 2025-12-21 22:21:14.9495 DFramework.Scheduler.TaskBase /* Time Taken: 15546.9571*/ Opportunity Out Of Stock By Outlet 2025-12-21 22:21:15.4808 AlertProcessor ProcessorAlertData: Stopped 2025-12-21 22:26:09.8264 AlertProcessor ProcessorAlertData: started 2025-12-21 22:26:15.1858 AlertProcessor ProcessorAlertData: Stopped 2025-12-21 22:31:09.8439 AlertProcessor ProcessorAlertData: started 2025-12-21 22:31:15.1095 AlertProcessor ProcessorAlertData: Stopped 2025-12-21 22:36:02.2206 MoveToReorder Running task for ClientId : 286 and ClientName = India Office QA and Slot: 12/22/2025 12:00:00 PM And LastExecutedOn: 12/22/2025 11:06:01 AM 2025-12-21 22:36:02.3769 DFramework.Database.Query /* Time Taken: 2296*/ [dbo].GenerateSystemAlerts 2025-12-21 22:36:02.6113 MoveToReorder Task executed successfully for ClientId : 286 Client Name:India Office QA, Slot: 12/22/2025 12:00:00 PM But No Order found to suggest 2025-12-21 22:36:09.8613 AlertProcessor ProcessorAlertData: started 2025-12-21 22:36:15.2051 AlertProcessor ProcessorAlertData: Stopped 2025-12-21 22:36:15.2364 DFramework.Scheduler.TaskBase /* Time Taken: 15828.25*/ Opportunity Out Of Stock By Outlet 2025-12-21 22:41:09.8788 AlertProcessor ProcessorAlertData: started 2025-12-21 22:41:15.1445 AlertProcessor ProcessorAlertData: Stopped 2025-12-21 22:46:09.8964 AlertProcessor ProcessorAlertData: started 2025-12-21 22:46:15.0995 AlertProcessor ProcessorAlertData: Stopped 2025-12-21 22:51:01.8043 DFramework.Database.Query /* Time Taken: 1718*/ [dbo].GenerateSystemAlerts 2025-12-21 22:51:09.9138 AlertProcessor ProcessorAlertData: started 2025-12-21 22:51:12.2888 DFramework.Database.Query /* Time Taken: 1289*/ DECLARE @StatusId Int32 SET @StatusId = '1' DECLARE @AlertId Int32 SET @AlertId = '7571914' SELECT TOP 10000 Alert.AlertId, Alert.LocationId, Alert.RecordId, ISNULL(AlertDefinition.Name, Alert.AlertText) Name, Alert.AlertTypeId, Alert.AlertText, ISNULL(Location.Name, '') AS LocationName, AlertDefinition.ClientId, AlertRecipient.RoleId, CASE WHEN Alert.AlertTypeId IN (6,7) THEN CONVERT(VARCHAR(10), CAST(AlertAt AS DATE), 101) ELSE AlertAt END AS AlertAt, AlertType, Asset.SerialNumber, ISNULL(LocationAttribute.FirstRepId, 0) RepId, ClientUser.PrimaryPhone AS SalesRepPhone, ClientUser.PrimaryEmail AS SalesRepEmail, FirstName, LastName, PreferedNotificationTypeIds, AlertRecipientId, AlertRecipientAddress, AlertRecipientText, Alert.Tags, AlertRecipientTypeId, NotificationContactTypeId, TemplateId, AlertDefinition.AlertAgeThreshold, LastUpdatedOn, AlertRecipient.AlertAge, CASE WHEN Location.TimeZoneId IS NOT NULL AND Location.TimeZoneId > 0 THEN Location.TimeZoneId ELSE Client.TimeZoneId END AS TimeZoneId, AlertDefinition.IsSummarize, Alert.ClosedOn, AssetType.IsChestCooler, AlertDefinition.SnoozeForHours, Alert.SnoozeDateTime FROM Alert LEFT OUTER JOIN Asset ON Alert.AssetId = Asset.AssetId LEFT OUTER JOIN AlertType ON Alert.AlertTypeId = AlertType.AlertTypeId LEFT OUTER JOIN AlertDefinition ON Alert.AlertDefinitionId = AlertDefinition.AlertDefinitionId LEFT OUTER JOIN Location ON Location.LocationId = Alert.LocationId LEFT OUTER JOIN LocationAttribute ON LocationAttribute.LocationId = dbo.Location.LocationId LEFT OUTER JOIN ClientUser ON LocationAttribute.FirstRepId = ClientUser.ClientUserId AND ClientUser.IsDeleted = 0 LEFT OUTER JOIN AlertRecipient ON Alert.AlertDefinitionId = AlertRecipient.AlertDefinitionId AND AlertRecipient.IsDeleted= 0 LEFT OUTER JOIN Client ON Client.ClientId = Alert.ClientId LEFT OUTER JOIN AssetType ON dbo.Asset.AssetTypeId = dbo.AssetType.AssetTypeId WHERE (NOT EXISTS(SELECT 1 FROM dbo.EmailQueue INNER JOIN dbo.EmailRecipient ON EmailRecipient.EmailQueueId = EmailQueue.EmailQueueId WHERE AlertId = Alert.AlertId AND EmailRecipient.RecipientId = AlertRecipient.AlertRecipientId) OR (Alert.SnoozeDateTime IS NOT NULL AND Alert.SnoozeDateTime <= GETUTCDATE() AND AlertDefinition.SnoozeForHours > 0 AND Alert.StatusId = @StatusId)) AND Alert.AlertId > @AlertId AND Alert.AlertAt >= DATEADD(DAY, -120, GETDATE()) AND AlertRecipient.IsDeleted = 0 AND Alert.IsActive = 1 AND Alert.IsDeleted = 0 AND AlertRecipient.IsActive = 1 AND AlertRecipient.IsDeleted = 0 AND AlertRecipient.StartDate <= Alert.CreatedOn AND Alert.CreatedOn < DATEADD(hh, 23, AlertRecipient.EndDate) AND (Alert.LocationId != 0 OR NotificationWithoutLocation = 1) AND AlertType.IsSystemAlert = 0 AND Alert.EmailQueuedOn IS NULL AND AlertDefinition.IsActive = 1 2025-12-21 22:51:14.9450 DFramework.Scheduler.TaskBase /* Time Taken: 15531.3413*/ Opportunity Out Of Stock By Outlet 2025-12-21 22:51:15.9763 AlertProcessor ProcessorAlertData: Stopped 2025-12-21 22:56:09.9157 AlertProcessor ProcessorAlertData: started 2025-12-21 22:56:15.4469 AlertProcessor ProcessorAlertData: Stopped 2025-12-21 23:01:09.9332 AlertProcessor ProcessorAlertData: started 2025-12-21 23:01:14.9957 AlertProcessor ProcessorAlertData: Stopped 2025-12-21 23:06:02.2631 DFramework.Database.Query /* Time Taken: 2159*/ [dbo].GenerateSystemAlerts 2025-12-21 23:06:09.9506 AlertProcessor ProcessorAlertData: started 2025-12-21 23:06:15.0132 DFramework.Scheduler.TaskBase /* Time Taken: 15578.2343*/ Opportunity Out Of Stock By Outlet 2025-12-21 23:06:15.5132 AlertProcessor ProcessorAlertData: Stopped 2025-12-21 23:11:09.9681 AlertProcessor ProcessorAlertData: started 2025-12-21 23:11:15.0619 DFramework.Database.Query /* Time Taken: 603*/ DECLARE @TableName AnsiString(8000) SET @TableName = 'LowInventoryConsolidate' DECLARE @CurrentRecordId Int32 SET @CurrentRecordId = '3674617' dbo.GetValidDeviceForAlertProcessData 2025-12-21 23:11:15.7806 AlertProcessor ProcessorAlertData: Stopped 2025-12-21 23:16:09.9700 AlertProcessor ProcessorAlertData: started 2025-12-21 23:16:12.4232 DFramework.Database.NullableDataReader Data reader open for 282 at System.Environment.GetStackTrace(Exception e, Boolean needFileInfo) at System.Environment.get_StackTrace() at DFramework.Database.NullableDataReader.Dispose(Boolean disposing) in D:\Spraxa\Framework\DFramework\Database\NullableDataReader.cs:line 33 at DFramework.Database.NullableDataReader.Dispose() in D:\Spraxa\Framework\DFramework\Database\NullableDataReader.cs:line 44 at CoolR.Tasks.ProcessAlertData.Execute() in D:\Spraxa\CoolR-Group\portal\CoolR.Tasks\ProcessAlertData.cs:line 47 at DFramework.Scheduler.TaskBase.Run() in D:\Spraxa\Framework\DFramework.Scheduler\TaskBase.cs:line 176 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.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state) at System.Threading.ThreadHelper.ThreadStart() 2025-12-21 23:16:15.6107 AlertProcessor ProcessorAlertData: Stopped 2025-12-21 23:21:01.6281 DFramework.Database.Query /* Time Taken: 1509*/ [dbo].GenerateSystemAlerts 2025-12-21 23:21:09.9875 AlertProcessor ProcessorAlertData: started 2025-12-21 23:21:14.9876 DFramework.Scheduler.TaskBase /* Time Taken: 15531.3218*/ Opportunity Out Of Stock By Outlet 2025-12-21 23:21:15.2844 AlertProcessor ProcessorAlertData: Stopped 2025-12-21 23:26:10.0049 AlertProcessor ProcessorAlertData: started 2025-12-21 23:26:15.6768 AlertProcessor ProcessorAlertData: Stopped 2025-12-21 23:31:10.0224 AlertProcessor ProcessorAlertData: started 2025-12-21 23:31:14.7412 DFramework.Database.NullableDataReader Data reader open for 283 at System.Environment.GetStackTrace(Exception e, Boolean needFileInfo) at System.Environment.get_StackTrace() at DFramework.Database.NullableDataReader.Dispose(Boolean disposing) in D:\Spraxa\Framework\DFramework\Database\NullableDataReader.cs:line 33 at DFramework.Database.NullableDataReader.Dispose() in D:\Spraxa\Framework\DFramework\Database\NullableDataReader.cs:line 44 at CoolR.Tasks.ProcessAlertData.Execute() in D:\Spraxa\CoolR-Group\portal\CoolR.Tasks\ProcessAlertData.cs:line 47 at DFramework.Scheduler.TaskBase.Run() in D:\Spraxa\Framework\DFramework.Scheduler\TaskBase.cs:line 176 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.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state) at System.Threading.ThreadHelper.ThreadStart() 2025-12-21 23:31:15.6943 AlertProcessor ProcessorAlertData: Stopped 2025-12-21 23:36:01.6024 DFramework.Database.Query /* Time Taken: 1483*/ [dbo].GenerateSystemAlerts 2025-12-21 23:36:02.2118 MoveToReorder Running task for ClientId : 286 and ClientName = India Office QA and Slot: 12/22/2025 1:00:00 PM And LastExecutedOn: 12/22/2025 12:06:02 PM 2025-12-21 23:36:02.4618 MoveToReorder Task executed successfully for ClientId : 286 Client Name:India Office QA, Slot: 12/22/2025 1:00:00 PM But No Order found to suggest 2025-12-21 23:36:10.0400 AlertProcessor ProcessorAlertData: started 2025-12-21 23:36:15.1338 DFramework.Scheduler.TaskBase /* Time Taken: 15656.3548*/ Opportunity Out Of Stock By Outlet 2025-12-21 23:36:15.5712 AlertProcessor ProcessorAlertData: Stopped 2025-12-21 23:41:10.0573 AlertProcessor ProcessorAlertData: started 2025-12-21 23:41:15.5261 AlertProcessor ProcessorAlertData: Stopped 2025-12-21 23:46:10.0591 AlertProcessor ProcessorAlertData: started 2025-12-21 23:46:15.3404 AlertProcessor ProcessorAlertData: Stopped 2025-12-21 23:51:02.2172 DFramework.Database.Query /* Time Taken: 2064*/ [dbo].GenerateSystemAlerts 2025-12-21 23:51:10.0610 AlertProcessor ProcessorAlertData: started 2025-12-21 23:51:10.5923 DFramework.Database.Query /* Time Taken: 532*/ DECLARE @TableName AnsiString(8000) SET @TableName = 'TagAlert' DECLARE @CurrentRecordId Int32 SET @CurrentRecordId = '0' dbo.GetValidDeviceForAlertProcessData 2025-12-21 23:51:15.3736 DFramework.Scheduler.TaskBase /* Time Taken: 15890.7304*/ Opportunity Out Of Stock By Outlet 2025-12-21 23:51:15.8267 AlertProcessor ProcessorAlertData: Stopped 2025-12-21 23:56:10.0785 AlertProcessor ProcessorAlertData: started 2025-12-21 23:56:11.1410 DFramework.Database.Query /* Time Taken: 1049*/ DECLARE @TableName AnsiString(8000) SET @TableName = 'TagAlert' DECLARE @CurrentRecordId Int32 SET @CurrentRecordId = '0' dbo.GetValidDeviceForAlertProcessData 2025-12-21 23:56:13.0004 DFramework.Database.Query /* Time Taken: 732*/ DECLARE @TableName AnsiString(8000) SET @TableName = 'OpportunityOutOfStock' DECLARE @CurrentRecordId Int32 SET @CurrentRecordId = '3674617' dbo.GetValidDeviceForAlertProcessData 2025-12-21 23:56:17.5317 AlertProcessor ProcessorAlertData: Stopped