2025-12-20 00:01:02.4686 AlertProcessor ProcessorAlertData: started 2025-12-20 00:01:08.0937 AlertProcessor ProcessorAlertData: Stopped 2025-12-20 00:05:57.5645 DFramework.Database.Query /* Time Taken: 1079*/ [dbo].GenerateSystemAlerts 2025-12-20 00:06:02.4864 AlertProcessor ProcessorAlertData: started 2025-12-20 00:06:05.3146 DFramework.Database.Query /* Time Taken: 617*/ DECLARE @TableName AnsiString(8000) SET @TableName = 'AssetStockProductWiseConsolidate' DECLARE @CurrentRecordId Int32 SET @CurrentRecordId = '3674560' dbo.GetValidDeviceForAlertProcessData 2025-12-20 00:06:08.2052 AlertProcessor ProcessorAlertData: Stopped 2025-12-20 00:06:11.9552 DFramework.Scheduler.TaskBase /* Time Taken: 15812.6127*/ Opportunity Out Of Stock By Outlet 2025-12-20 00:11:02.4887 AlertProcessor ProcessorAlertData: started 2025-12-20 00:11:07.8168 AlertProcessor ProcessorAlertData: Stopped 2025-12-20 00:16:02.5065 AlertProcessor ProcessorAlertData: started 2025-12-20 00:16:07.7252 AlertProcessor ProcessorAlertData: Stopped 2025-12-20 00:20:57.7742 DFramework.Database.Query /* Time Taken: 1278*/ [dbo].GenerateSystemAlerts 2025-12-20 00:21:02.5242 AlertProcessor ProcessorAlertData: started 2025-12-20 00:21:04.0243 DFramework.Database.Query /* Time Taken: 574*/ 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-20 00:21:07.8212 AlertProcessor ProcessorAlertData: Stopped 2025-12-20 00:21:11.6337 DFramework.Scheduler.TaskBase /* Time Taken: 15468.8604*/ Opportunity Out Of Stock By Outlet 2025-12-20 00:26:02.5421 AlertProcessor ProcessorAlertData: started 2025-12-20 00:26:07.7922 AlertProcessor ProcessorAlertData: Stopped 2025-12-20 00:31:02.5601 AlertProcessor ProcessorAlertData: started 2025-12-20 00:31:07.7945 AlertProcessor ProcessorAlertData: Stopped 2025-12-20 00:35:57.9216 MoveToReorder Running task for ClientId : 286 and ClientName = India Office QA and Slot: 12/20/2025 2:00:00 PM And LastExecutedOn: 12/20/2025 1:05:57 PM 2025-12-20 00:35:58.0935 DFramework.Database.Query /* Time Taken: 1584*/ [dbo].GenerateSystemAlerts 2025-12-20 00:36:02.5779 AlertProcessor ProcessorAlertData: started 2025-12-20 00:36:05.9685 DFramework.Database.Query /* Time Taken: 1659*/ DECLARE @TableName AnsiString(8000) SET @TableName = 'PlanogramComplianceConsolidate' DECLARE @CurrentRecordId Int32 SET @CurrentRecordId = '3674560' dbo.GetValidDeviceForAlertProcessData 2025-12-20 00:36:09.4529 AlertProcessor ProcessorAlertData: Stopped 2025-12-20 00:36:11.6873 DFramework.Scheduler.TaskBase /* Time Taken: 15515.7653*/ Opportunity Out Of Stock By Outlet 2025-12-20 00:36:40.9063 DFramework.Database.NullableDataReader Data reader open for 42741 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-20 00:36:40.9375 MoveToReorder Task executed successfully for ClientId : 286 Client Name:India Office QA, Slot: 12/20/2025 2:00:00 PM and Total Order Suggested: 122 Out Of: 122 2025-12-20 00:36:41.6875 DFramework.Scheduler.TaskBase /* Time Taken: 44156.5741*/ Move To Re-Order 2025-12-20 00:41:02.5957 AlertProcessor ProcessorAlertData: started 2025-12-20 00:41:07.9238 AlertProcessor ProcessorAlertData: Stopped 2025-12-20 00:46:02.6136 AlertProcessor ProcessorAlertData: started 2025-12-20 00:46:07.9262 AlertProcessor ProcessorAlertData: Stopped 2025-12-20 00:50:57.5689 DFramework.Database.Query /* Time Taken: 1039*/ [dbo].GenerateSystemAlerts 2025-12-20 00:51:02.6315 AlertProcessor ProcessorAlertData: started 2025-12-20 00:51:08.0534 AlertProcessor ProcessorAlertData: Stopped 2025-12-20 00:51:11.8190 DFramework.Scheduler.TaskBase /* Time Taken: 15625.1146*/ Opportunity Out Of Stock By Outlet 2025-12-20 00:56:02.6336 AlertProcessor ProcessorAlertData: started 2025-12-20 00:56:08.0087 AlertProcessor ProcessorAlertData: Stopped 2025-12-20 01:01:02.6359 AlertProcessor ProcessorAlertData: started 2025-12-20 01:01:07.9953 AlertProcessor ProcessorAlertData: Stopped 2025-12-20 01:05:57.6537 DFramework.Database.Query /* Time Taken: 1108*/ [dbo].GenerateSystemAlerts 2025-12-20 01:06:02.6381 AlertProcessor ProcessorAlertData: started 2025-12-20 01:06:08.1850 AlertProcessor ProcessorAlertData: Stopped 2025-12-20 01:06:11.7163 DFramework.Scheduler.TaskBase /* Time Taken: 15500.1129*/ Opportunity Out Of Stock By Outlet 2025-12-20 01:11:02.6558 AlertProcessor ProcessorAlertData: started 2025-12-20 01:11:07.9996 AlertProcessor ProcessorAlertData: Stopped 2025-12-20 01:16:02.6736 AlertProcessor ProcessorAlertData: started 2025-12-20 01:16:07.9393 AlertProcessor ProcessorAlertData: Stopped 2025-12-20 01:20:57.7228 DFramework.Database.Query /* Time Taken: 1145*/ [dbo].GenerateSystemAlerts 2025-12-20 01:21:02.6916 AlertProcessor ProcessorAlertData: started 2025-12-20 01:21:07.9729 AlertProcessor ProcessorAlertData: Stopped 2025-12-20 01:21:11.7385 DFramework.Scheduler.TaskBase /* Time Taken: 15500.1165*/ Opportunity Out Of Stock By Outlet 2025-12-20 01:26:02.6938 AlertProcessor ProcessorAlertData: started 2025-12-20 01:26:03.4750 DFramework.Database.Query /* Time Taken: 786*/ DECLARE @TableName AnsiString(8000) SET @TableName = 'TagAlert' DECLARE @CurrentRecordId Int32 SET @CurrentRecordId = '0' dbo.GetValidDeviceForAlertProcessData 2025-12-20 01:26:08.8032 AlertProcessor ProcessorAlertData: Stopped 2025-12-20 01:31:02.6959 AlertProcessor ProcessorAlertData: started 2025-12-20 01:31:09.7741 AlertProcessor ProcessorAlertData: Stopped 2025-12-20 01:35:57.9639 DFramework.Database.Query /* Time Taken: 1362*/ [dbo].GenerateSystemAlerts 2025-12-20 01:35:57.9795 MoveToReorder Running task for ClientId : 286 and ClientName = India Office QA and Slot: 12/20/2025 3:00:00 PM And LastExecutedOn: 12/20/2025 2:05:57 PM 2025-12-20 01:35:58.5108 DFramework.Database.NullableDataReader Data reader open for 355 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-20 01:35:58.5420 MoveToReorder Task executed successfully for ClientId : 286 Client Name:India Office QA, Slot: 12/20/2025 3:00:00 PM and Total Order Suggested: 1 Out Of: 1 2025-12-20 01:36:02.7139 AlertProcessor ProcessorAlertData: started 2025-12-20 01:36:03.4014 DFramework.Database.Query /* Time Taken: 696*/ DECLARE @TableName AnsiString(8000) SET @TableName = 'TagAlert' DECLARE @CurrentRecordId Int32 SET @CurrentRecordId = '0' dbo.GetValidDeviceForAlertProcessData 2025-12-20 01:36:08.4796 AlertProcessor ProcessorAlertData: Stopped 2025-12-20 01:36:11.7921 DFramework.Scheduler.TaskBase /* Time Taken: 15531.376*/ Opportunity Out Of Stock By Outlet 2025-12-20 01:41:02.7318 AlertProcessor ProcessorAlertData: started 2025-12-20 01:41:07.9506 AlertProcessor ProcessorAlertData: Stopped 2025-12-20 01:46:02.7496 AlertProcessor ProcessorAlertData: started 2025-12-20 01:46:07.8590 AlertProcessor ProcessorAlertData: Stopped 2025-12-20 01:50:57.8924 DFramework.Database.Query /* Time Taken: 1274*/ [dbo].GenerateSystemAlerts 2025-12-20 01:51:02.7674 AlertProcessor ProcessorAlertData: started 2025-12-20 01:51:05.6425 DFramework.Database.Query /* Time Taken: 1935*/ 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-20 01:51:08.4550 AlertProcessor ProcessorAlertData: Stopped 2025-12-20 01:51:11.7675 DFramework.Scheduler.TaskBase /* Time Taken: 15484.493*/ Opportunity Out Of Stock By Outlet 2025-12-20 01:56:02.7697 AlertProcessor ProcessorAlertData: started 2025-12-20 01:56:08.0979 AlertProcessor ProcessorAlertData: Stopped 2025-12-20 02:01:02.7875 AlertProcessor ProcessorAlertData: started 2025-12-20 02:01:08.2407 AlertProcessor ProcessorAlertData: Stopped 2025-12-20 02:06:00.8365 DFramework.Database.Query /* Time Taken: 2709*/ DECLARE @OrderStatusId Int32 SET @OrderStatusId = '5485' DECLARE @InTransitOrderStatusId Int32 SET @InTransitOrderStatusId = '5484' UPDATE Location SET OrderStatusId = @InTransitOrderStatusId FROM ScheduledOrder INNER JOIN Location ON Location.ScheduledOrderId = ScheduledOrder.ScheduledOrderId INNER JOIN CLient On Client.ClientId = Location.ClientId AND Client.HoursMoveScheduledToInTransit > -1 WHERE DATEADD(HOUR, Client.HoursMoveScheduledToInTransit, ScheduledOrder.ModifiedOn) < GETUTCDATE() AND ScheduledOrder.StatusId = @OrderStatusId AND Location.IsDeleted = 0 AND ScheduledOrder.IsDeleted = 0 AND Location.OrderStatusId = @OrderStatusId 2025-12-20 02:06:00.9459 DFramework.Database.Query /* Time Taken: 4310*/ [dbo].GenerateSystemAlerts 2025-12-20 02:06:02.7896 AlertProcessor ProcessorAlertData: started 2025-12-20 02:06:08.6178 AlertProcessor ProcessorAlertData: Stopped 2025-12-20 02:06:11.9772 DFramework.Scheduler.TaskBase /* Time Taken: 15671.985*/ Opportunity Out Of Stock By Outlet 2025-12-20 02:11:02.7920 AlertProcessor ProcessorAlertData: started 2025-12-20 02:11:08.1671 AlertProcessor ProcessorAlertData: Stopped 2025-12-20 02:16:02.8099 AlertProcessor ProcessorAlertData: started 2025-12-20 02:16:08.1381 AlertProcessor ProcessorAlertData: Stopped 2025-12-20 02:20:58.1245 DFramework.Database.Query /* Time Taken: 1454*/ [dbo].GenerateSystemAlerts 2025-12-20 02:21:02.8277 AlertProcessor ProcessorAlertData: started 2025-12-20 02:21:04.4839 DFramework.Database.Query /* Time Taken: 693*/ DECLARE @TableName AnsiString(8000) SET @TableName = 'MissingShelf' DECLARE @CurrentRecordId Int32 SET @CurrentRecordId = '3674560' dbo.GetValidDeviceForAlertProcessData 2025-12-20 02:21:09.2340 AlertProcessor ProcessorAlertData: Stopped 2025-12-20 02:21:11.9371 DFramework.Scheduler.TaskBase /* Time Taken: 15609.4908*/ Opportunity Out Of Stock By Outlet 2025-12-20 02:26:02.8456 AlertProcessor ProcessorAlertData: started 2025-12-20 02:26:08.2519 AlertProcessor ProcessorAlertData: Stopped 2025-12-20 02:31:02.8479 AlertProcessor ProcessorAlertData: started 2025-12-20 02:31:08.4104 AlertProcessor ProcessorAlertData: Stopped 2025-12-20 02:35:58.5844 DFramework.Database.Query /* Time Taken: 884*/ DECLARE @OrderStatusId Int32 SET @OrderStatusId = '5486' UPDATE Location SET ScheduledOrderId = 0, OrderStatusId = 0 from ScheduledOrder INNER JOIN Location ON Location.ScheduledOrderId = ScheduledOrder.ScheduledOrderId AND Location.OrderStatusId = @OrderStatusId INNER JOIN CLient On Client.ClientId = Location.ClientId AND Client.HoursToMoveIgnored > 0 WHERE DATEADD(HOUR, Client.HoursToMoveIgnored, ScheduledOrder.ModifiedOn) < GETUTCDATE() AND ScheduledOrder.StatusId = @OrderStatusId ANd Location.IsDeleted = 0 AND ScheduledOrder.IsDeleted = 0 2025-12-20 02:35:58.6938 DFramework.Database.Query /* Time Taken: 2009*/ [dbo].GenerateSystemAlerts 2025-12-20 02:36:02.8657 AlertProcessor ProcessorAlertData: started 2025-12-20 02:36:06.9126 DFramework.Database.Query /* Time Taken: 673*/ DECLARE @TableName AnsiString(8000) SET @TableName = 'OpportunityLowStock' DECLARE @CurrentRecordId Int32 SET @CurrentRecordId = '3674560' dbo.GetValidDeviceForAlertProcessData 2025-12-20 02:36:08.6001 AlertProcessor ProcessorAlertData: Stopped 2025-12-20 02:36:12.0376 DFramework.Scheduler.TaskBase /* Time Taken: 15687.6032*/ Opportunity Out Of Stock By Outlet 2025-12-20 02:41:02.8834 AlertProcessor ProcessorAlertData: started 2025-12-20 02:41:08.3522 AlertProcessor ProcessorAlertData: Stopped 2025-12-20 02:45:58.0575 MoveToReorder Running task for ClientId : 286 and ClientName = India Office QA and Slot: 12/20/2025 4:00:00 PM And LastExecutedOn: 12/20/2025 3:05:57 PM 2025-12-20 02:46:02.9013 AlertProcessor ProcessorAlertData: started 2025-12-20 02:46:04.1201 DFramework.Database.Query /* Time Taken: 1222*/ DECLARE @TableName AnsiString(8000) SET @TableName = 'TagAlert' DECLARE @CurrentRecordId Int32 SET @CurrentRecordId = '0' dbo.GetValidDeviceForAlertProcessData 2025-12-20 02:46:09.3857 DFramework.Database.Query /* Time Taken: 501*/ DECLARE @TableName AnsiString(8000) SET @TableName = 'ProductStockLevel' DECLARE @CurrentRecordId Int32 SET @CurrentRecordId = '3674560' dbo.GetValidDeviceForAlertProcessData 2025-12-20 02:46:09.4482 AlertProcessor ProcessorAlertData: Stopped 2025-12-20 02:46:39.1360 DFramework.Database.NullableDataReader Data reader open for 40787 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-20 02:46:39.1828 MoveToReorder Task executed successfully for ClientId : 286 Client Name:India Office QA, Slot: 12/20/2025 4:00:00 PM and Total Order Suggested: 122 Out Of: 122 2025-12-20 02:46:40.1672 DFramework.Scheduler.TaskBase /* Time Taken: 42437.8127*/ Move To Re-Order 2025-12-20 02:50:57.9034 DFramework.Database.Query /* Time Taken: 1192*/ [dbo].GenerateSystemAlerts 2025-12-20 02:51:02.9035 AlertProcessor ProcessorAlertData: started 2025-12-20 02:51:08.4504 AlertProcessor ProcessorAlertData: Stopped 2025-12-20 02:51:11.8879 DFramework.Scheduler.TaskBase /* Time Taken: 15515.7407*/ Opportunity Out Of Stock By Outlet 2025-12-20 02:56:02.9213 AlertProcessor ProcessorAlertData: started 2025-12-20 02:56:08.2963 AlertProcessor ProcessorAlertData: Stopped 2025-12-20 03:01:02.9393 AlertProcessor ProcessorAlertData: started 2025-12-20 03:01:08.3925 AlertProcessor ProcessorAlertData: Stopped 2025-12-20 03:05:57.8166 DFramework.Database.Query /* Time Taken: 1084*/ [dbo].GenerateSystemAlerts 2025-12-20 03:06:02.9416 AlertProcessor ProcessorAlertData: started 2025-12-20 03:06:07.8479 AlertProcessor ProcessorAlertData: Stopped 2025-12-20 03:06:12.0511 DFramework.Scheduler.TaskBase /* Time Taken: 15656.3659*/ Opportunity Out Of Stock By Outlet 2025-12-20 03:11:02.9438 AlertProcessor ProcessorAlertData: started 2025-12-20 03:11:07.9439 AlertProcessor ProcessorAlertData: Stopped 2025-12-20 03:16:02.9616 AlertProcessor ProcessorAlertData: started 2025-12-20 03:16:07.7898 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-20 03:16:08.4304 AlertProcessor ProcessorAlertData: Stopped 2025-12-20 03:20:58.1514 DFramework.Database.Query /* Time Taken: 1397*/ [dbo].GenerateSystemAlerts 2025-12-20 03:21:02.9796 AlertProcessor ProcessorAlertData: started 2025-12-20 03:21:05.0577 DFramework.Database.Query /* Time Taken: 1062*/ 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-20 03:21:08.4640 AlertProcessor ProcessorAlertData: Stopped 2025-12-20 03:21:11.9484 DFramework.Scheduler.TaskBase /* Time Taken: 15531.3633*/ Opportunity Out Of Stock By Outlet 2025-12-20 03:26:02.9974 AlertProcessor ProcessorAlertData: started 2025-12-20 03:26:08.4037 AlertProcessor ProcessorAlertData: Stopped 2025-12-20 03:31:02.9995 AlertProcessor ProcessorAlertData: started 2025-12-20 03:31:08.2652 AlertProcessor ProcessorAlertData: Stopped 2025-12-20 03:35:58.0799 DFramework.Database.Query /* Time Taken: 1310*/ [dbo].GenerateSystemAlerts 2025-12-20 03:35:58.1581 MoveToReorder Running task for ClientId : 286 and ClientName = India Office QA and Slot: 12/20/2025 5:00:00 PM And LastExecutedOn: 12/20/2025 4:15:57 PM 2025-12-20 03:35:58.3299 MoveToReorder Task executed successfully for ClientId : 286 Client Name:India Office QA, Slot: 12/20/2025 5:00:00 PM But No Order found to suggest 2025-12-20 03:36:03.0018 AlertProcessor ProcessorAlertData: started 2025-12-20 03:36:08.1894 AlertProcessor ProcessorAlertData: Stopped 2025-12-20 03:36:11.9707 DFramework.Scheduler.TaskBase /* Time Taken: 15531.3666*/ Opportunity Out Of Stock By Outlet 2025-12-20 03:41:03.0041 AlertProcessor ProcessorAlertData: started 2025-12-20 03:41:07.9260 AlertProcessor ProcessorAlertData: Stopped 2025-12-20 03:46:03.0219 AlertProcessor ProcessorAlertData: started 2025-12-20 03:46:07.9750 AlertProcessor ProcessorAlertData: Stopped 2025-12-20 03:50:57.8053 DFramework.Database.Query /* Time Taken: 1004*/ [dbo].GenerateSystemAlerts 2025-12-20 03:51:03.0397 AlertProcessor ProcessorAlertData: started 2025-12-20 03:51:03.6647 DFramework.Database.Query /* Time Taken: 618*/ DECLARE @TableName AnsiString(8000) SET @TableName = 'TagAlert' DECLARE @CurrentRecordId Int32 SET @CurrentRecordId = '0' dbo.GetValidDeviceForAlertProcessData 2025-12-20 03:51:08.3054 AlertProcessor ProcessorAlertData: Stopped 2025-12-20 03:51:11.9304 DFramework.Scheduler.TaskBase /* Time Taken: 15468.8686*/ Opportunity Out Of Stock By Outlet 2025-12-20 03:56:03.0576 AlertProcessor ProcessorAlertData: started 2025-12-20 03:56:07.8079 AlertProcessor ProcessorAlertData: Stopped 2025-12-20 04:01:03.0754 AlertProcessor ProcessorAlertData: started 2025-12-20 04:01:07.7942 AlertProcessor ProcessorAlertData: Stopped 2025-12-20 04:05:57.8119 DFramework.Database.Query /* Time Taken: 984*/ [dbo].GenerateSystemAlerts 2025-12-20 04:06:03.0932 AlertProcessor ProcessorAlertData: started 2025-12-20 04:06:07.9057 AlertProcessor ProcessorAlertData: Stopped 2025-12-20 04:06:11.9682 DFramework.Scheduler.TaskBase /* Time Taken: 15500.1027*/ Opportunity Out Of Stock By Outlet 2025-12-20 04:11:03.0955 AlertProcessor ProcessorAlertData: started 2025-12-20 04:11:07.9393 AlertProcessor ProcessorAlertData: Stopped 2025-12-20 04:16:03.0977 AlertProcessor ProcessorAlertData: started 2025-12-20 04:16:08.0196 AlertProcessor ProcessorAlertData: Stopped 2025-12-20 04:20:57.8030 DFramework.Database.Query /* Time Taken: 959*/ [dbo].GenerateSystemAlerts 2025-12-20 04:21:03.1155 AlertProcessor ProcessorAlertData: started 2025-12-20 04:21:08.0687 AlertProcessor ProcessorAlertData: Stopped 2025-12-20 04:21:11.9437 DFramework.Scheduler.TaskBase /* Time Taken: 15453.2361*/ Opportunity Out Of Stock By Outlet 2025-12-20 04:26:03.1179 AlertProcessor ProcessorAlertData: started 2025-12-20 04:26:07.9148 AlertProcessor ProcessorAlertData: Stopped 2025-12-20 04:31:03.1358 AlertProcessor ProcessorAlertData: started 2025-12-20 04:31:07.9483 AlertProcessor ProcessorAlertData: Stopped 2025-12-20 04:35:57.8254 DFramework.Database.Query /* Time Taken: 978*/ [dbo].GenerateSystemAlerts 2025-12-20 04:35:58.2317 MoveToReorder Running task for ClientId : 286 and ClientName = India Office QA and Slot: 12/20/2025 6:00:00 PM And LastExecutedOn: 12/20/2025 5:05:58 PM 2025-12-20 04:35:58.7629 DFramework.Database.NullableDataReader Data reader open for 364 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-20 04:35:58.7942 MoveToReorder Task executed successfully for ClientId : 286 Client Name:India Office QA, Slot: 12/20/2025 6:00:00 PM and Total Order Suggested: 1 Out Of: 1 2025-12-20 04:36:03.1536 AlertProcessor ProcessorAlertData: started 2025-12-20 04:36:08.0286 AlertProcessor ProcessorAlertData: Stopped 2025-12-20 04:36:11.9349 DFramework.Scheduler.TaskBase /* Time Taken: 15437.6181*/ Opportunity Out Of Stock By Outlet 2025-12-20 04:41:03.1558 AlertProcessor ProcessorAlertData: started 2025-12-20 04:41:07.9214 AlertProcessor ProcessorAlertData: Stopped 2025-12-20 04:46:03.1581 AlertProcessor ProcessorAlertData: started 2025-12-20 04:46:04.2050 DFramework.Database.NullableDataReader Data reader open for 270 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-20 04:46:08.1425 AlertProcessor ProcessorAlertData: Stopped 2025-12-20 04:50:58.0040 DFramework.Database.Query /* Time Taken: 1147*/ [dbo].GenerateSystemAlerts 2025-12-20 04:51:03.1760 AlertProcessor ProcessorAlertData: started 2025-12-20 04:51:04.8947 DFramework.Database.Query /* Time Taken: 658*/ 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-20 04:51:08.0979 AlertProcessor ProcessorAlertData: Stopped 2025-12-20 04:51:11.9729 DFramework.Scheduler.TaskBase /* Time Taken: 15453.2371*/ Opportunity Out Of Stock By Outlet 2025-12-20 04:56:03.1781 AlertProcessor ProcessorAlertData: started 2025-12-20 04:56:08.0063 AlertProcessor ProcessorAlertData: Stopped 2025-12-20 05:01:03.1960 AlertProcessor ProcessorAlertData: started 2025-12-20 05:01:07.9460 AlertProcessor ProcessorAlertData: Stopped 2025-12-20 05:06:02.7606 DFramework.Database.Query /* Time Taken: 4863*/ DECLARE @OrderStatusId Int32 SET @OrderStatusId = '5486' UPDATE Location SET ScheduledOrderId = 0, OrderStatusId = 0 from ScheduledOrder INNER JOIN Location ON Location.ScheduledOrderId = ScheduledOrder.ScheduledOrderId AND Location.OrderStatusId = @OrderStatusId INNER JOIN CLient On Client.ClientId = Location.ClientId AND Client.HoursToMoveIgnored > 0 WHERE DATEADD(HOUR, Client.HoursToMoveIgnored, ScheduledOrder.ModifiedOn) < GETUTCDATE() AND ScheduledOrder.StatusId = @OrderStatusId ANd Location.IsDeleted = 0 AND ScheduledOrder.IsDeleted = 0 2025-12-20 05:06:02.8544 DFramework.Database.Query /* Time Taken: 5990*/ [dbo].GenerateSystemAlerts 2025-12-20 05:06:03.2137 AlertProcessor ProcessorAlertData: started 2025-12-20 05:06:08.0888 AlertProcessor ProcessorAlertData: Stopped 2025-12-20 05:06:12.0107 DFramework.Scheduler.TaskBase /* Time Taken: 15468.8609*/ Opportunity Out Of Stock By Outlet 2025-12-20 05:11:03.2315 AlertProcessor ProcessorAlertData: started 2025-12-20 05:11:08.1691 AlertProcessor ProcessorAlertData: Stopped 2025-12-20 05:16:03.2494 AlertProcessor ProcessorAlertData: started 2025-12-20 05:16:08.1244 AlertProcessor ProcessorAlertData: Stopped 2025-12-20 05:20:57.8141 DFramework.Database.Query /* Time Taken: 927*/ [dbo].GenerateSystemAlerts 2025-12-20 05:21:03.2516 AlertProcessor ProcessorAlertData: started 2025-12-20 05:21:08.1579 AlertProcessor ProcessorAlertData: Stopped 2025-12-20 05:21:12.0329 DFramework.Scheduler.TaskBase /* Time Taken: 15468.8588*/ Opportunity Out Of Stock By Outlet 2025-12-20 05:26:03.2538 AlertProcessor ProcessorAlertData: started 2025-12-20 05:26:08.1445 AlertProcessor ProcessorAlertData: Stopped 2025-12-20 05:31:03.2560 AlertProcessor ProcessorAlertData: started 2025-12-20 05:31:08.2248 AlertProcessor ProcessorAlertData: Stopped 2025-12-20 05:35:58.0396 DFramework.Database.Query /* Time Taken: 1128*/ [dbo].GenerateSystemAlerts 2025-12-20 05:35:58.2896 MoveToReorder Running task for ClientId : 286 and ClientName = India Office QA and Slot: 12/20/2025 7:00:00 PM And LastExecutedOn: 12/20/2025 6:05:58 PM 2025-12-20 05:36:03.2583 AlertProcessor ProcessorAlertData: started 2025-12-20 05:36:08.4303 AlertProcessor ProcessorAlertData: Stopped 2025-12-20 05:36:12.1178 DFramework.Scheduler.TaskBase /* Time Taken: 15531.3647*/ Opportunity Out Of Stock By Outlet 2025-12-20 05:36:38.1024 DFramework.Database.NullableDataReader Data reader open for 39607 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-20 05:36:38.1180 MoveToReorder Task executed successfully for ClientId : 286 Client Name:India Office QA, Slot: 12/20/2025 7:00:00 PM and Total Order Suggested: 122 Out Of: 122 2025-12-20 05:36:38.8836 DFramework.Scheduler.TaskBase /* Time Taken: 40953.4264*/ Move To Re-Order 2025-12-20 05:41:03.2606 AlertProcessor ProcessorAlertData: started 2025-12-20 05:41:08.1356 AlertProcessor ProcessorAlertData: Stopped 2025-12-20 05:46:03.2784 AlertProcessor ProcessorAlertData: started 2025-12-20 05:46:08.2940 AlertProcessor ProcessorAlertData: Stopped 2025-12-20 05:50:57.9681 DFramework.Database.Query /* Time Taken: 1039*/ [dbo].GenerateSystemAlerts 2025-12-20 05:51:03.2807 AlertProcessor ProcessorAlertData: started 2025-12-20 05:51:08.0463 AlertProcessor ProcessorAlertData: Stopped 2025-12-20 05:51:12.1089 DFramework.Scheduler.TaskBase /* Time Taken: 15500.1211*/ Opportunity Out Of Stock By Outlet 2025-12-20 05:56:03.2986 AlertProcessor ProcessorAlertData: started 2025-12-20 05:56:08.0330 AlertProcessor ProcessorAlertData: Stopped 2025-12-20 06:01:03.3164 AlertProcessor ProcessorAlertData: started 2025-12-20 06:01:08.3477 AlertProcessor ProcessorAlertData: Stopped 2025-12-20 06:05:57.9123 DFramework.Database.Query /* Time Taken: 976*/ [dbo].GenerateSystemAlerts 2025-12-20 06:06:03.3342 AlertProcessor ProcessorAlertData: started 2025-12-20 06:06:08.2249 AlertProcessor ProcessorAlertData: Stopped 2025-12-20 06:06:12.0999 DFramework.Scheduler.TaskBase /* Time Taken: 15468.8897*/ Opportunity Out Of Stock By Outlet 2025-12-20 06:11:03.3522 AlertProcessor ProcessorAlertData: started 2025-12-20 06:11:08.3366 AlertProcessor ProcessorAlertData: Stopped 2025-12-20 06:16:03.3701 AlertProcessor ProcessorAlertData: started 2025-12-20 06:16:08.1670 AlertProcessor ProcessorAlertData: Stopped 2025-12-20 06:20:58.1222 DFramework.Database.Query /* Time Taken: 1169*/ [dbo].GenerateSystemAlerts 2025-12-20 06:21:03.3723 AlertProcessor ProcessorAlertData: started 2025-12-20 06:21:06.0129 DFramework.Database.Query /* Time Taken: 1506*/ 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-20 06:21:08.7317 AlertProcessor ProcessorAlertData: Stopped 2025-12-20 06:21:12.2005 DFramework.Scheduler.TaskBase /* Time Taken: 15546.9889*/ Opportunity Out Of Stock By Outlet 2025-12-20 06:26:03.3902 AlertProcessor ProcessorAlertData: started 2025-12-20 06:26:08.2964 AlertProcessor ProcessorAlertData: Stopped 2025-12-20 06:31:03.4080 AlertProcessor ProcessorAlertData: started 2025-12-20 06:31:08.3299 AlertProcessor ProcessorAlertData: Stopped 2025-12-20 06:35:58.3476 MoveToReorder Running task for ClientId : 286 and ClientName = India Office QA and Slot: 12/20/2025 8:00:00 PM And LastExecutedOn: 12/20/2025 7:05:58 PM 2025-12-20 06:35:58.5351 DFramework.Database.Query /* Time Taken: 1549*/ [dbo].GenerateSystemAlerts 2025-12-20 06:35:58.6914 MoveToReorder Task executed successfully for ClientId : 286 Client Name:India Office QA, Slot: 12/20/2025 8:00:00 PM But No Order found to suggest 2025-12-20 06:36:03.4258 AlertProcessor ProcessorAlertData: started 2025-12-20 06:36:08.1602 AlertProcessor ProcessorAlertData: Stopped 2025-12-20 06:36:12.2227 DFramework.Scheduler.TaskBase /* Time Taken: 15562.6098*/ Opportunity Out Of Stock By Outlet 2025-12-20 06:41:03.4436 AlertProcessor ProcessorAlertData: started 2025-12-20 06:41:04.0218 DFramework.Database.NullableDataReader Data reader open for 327 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-20 06:41:08.4906 AlertProcessor ProcessorAlertData: Stopped 2025-12-20 06:46:03.4616 AlertProcessor ProcessorAlertData: started 2025-12-20 06:46:08.2585 AlertProcessor ProcessorAlertData: Stopped 2025-12-20 06:50:57.9950 DFramework.Database.Query /* Time Taken: 984*/ [dbo].GenerateSystemAlerts 2025-12-20 06:51:03.4794 AlertProcessor ProcessorAlertData: started 2025-12-20 06:51:04.1044 DFramework.Database.Query /* Time Taken: 623*/ DECLARE @TableName AnsiString(8000) SET @TableName = 'TagAlert' DECLARE @CurrentRecordId Int32 SET @CurrentRecordId = '0' dbo.GetValidDeviceForAlertProcessData 2025-12-20 06:51:08.6357 AlertProcessor ProcessorAlertData: Stopped 2025-12-20 06:51:12.1669 DFramework.Scheduler.TaskBase /* Time Taken: 15500.1114*/ Opportunity Out Of Stock By Outlet 2025-12-20 06:56:03.4972 AlertProcessor ProcessorAlertData: started 2025-12-20 06:56:08.4191 AlertProcessor ProcessorAlertData: Stopped 2025-12-20 07:01:03.4995 AlertProcessor ProcessorAlertData: started 2025-12-20 07:01:08.3433 AlertProcessor ProcessorAlertData: Stopped 2025-12-20 07:05:57.9391 DFramework.Database.Query /* Time Taken: 930*/ [dbo].GenerateSystemAlerts 2025-12-20 07:06:03.5173 AlertProcessor ProcessorAlertData: started 2025-12-20 07:06:05.9861 DFramework.Database.Query /* Time Taken: 525*/ DECLARE @TableName AnsiString(8000) SET @TableName = 'AssetStockProductWiseConsolidate' DECLARE @CurrentRecordId Int32 SET @CurrentRecordId = '3674560' dbo.GetValidDeviceForAlertProcessData 2025-12-20 07:06:08.6267 AlertProcessor ProcessorAlertData: Stopped 2025-12-20 07:06:12.1736 DFramework.Scheduler.TaskBase /* Time Taken: 15500.114*/ Opportunity Out Of Stock By Outlet 2025-12-20 07:11:03.5195 AlertProcessor ProcessorAlertData: started 2025-12-20 07:11:08.5508 AlertProcessor ProcessorAlertData: Stopped 2025-12-20 07:16:03.5218 AlertProcessor ProcessorAlertData: started 2025-12-20 07:16:08.3031 AlertProcessor ProcessorAlertData: Stopped 2025-12-20 07:20:57.9773 DFramework.Database.Query /* Time Taken: 948*/ [dbo].GenerateSystemAlerts 2025-12-20 07:21:03.5398 AlertProcessor ProcessorAlertData: started 2025-12-20 07:21:08.2742 AlertProcessor ProcessorAlertData: Stopped 2025-12-20 07:21:12.1649 DFramework.Scheduler.TaskBase /* Time Taken: 15468.8719*/ Opportunity Out Of Stock By Outlet 2025-12-20 07:26:03.5577 AlertProcessor ProcessorAlertData: started 2025-12-20 07:26:08.3546 AlertProcessor ProcessorAlertData: Stopped 2025-12-20 07:31:03.5755 AlertProcessor ProcessorAlertData: started 2025-12-20 07:31:04.5755 DFramework.Database.NullableDataReader Data reader open for 236 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-20 07:31:08.5599 AlertProcessor ProcessorAlertData: Stopped 2025-12-20 07:35:57.9839 DFramework.Database.Query /* Time Taken: 927*/ [dbo].GenerateSystemAlerts 2025-12-20 07:35:58.3433 MoveToReorder Running task for ClientId : 286 and ClientName = India Office QA and Slot: 12/20/2025 9:00:00 PM And LastExecutedOn: 12/20/2025 8:05:58 PM 2025-12-20 07:35:58.9527 DFramework.Database.NullableDataReader Data reader open for 384 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-20 07:35:58.9839 MoveToReorder Task executed successfully for ClientId : 286 Client Name:India Office QA, Slot: 12/20/2025 9:00:00 PM and Total Order Suggested: 1 Out Of: 1 2025-12-20 07:36:03.5933 AlertProcessor ProcessorAlertData: started 2025-12-20 07:36:08.7027 AlertProcessor ProcessorAlertData: Stopped 2025-12-20 07:36:12.2809 DFramework.Scheduler.TaskBase /* Time Taken: 15562.6123*/ Opportunity Out Of Stock By Outlet 2025-12-20 07:41:03.6111 AlertProcessor ProcessorAlertData: started 2025-12-20 07:41:08.5018 AlertProcessor ProcessorAlertData: Stopped 2025-12-20 07:46:03.6133 AlertProcessor ProcessorAlertData: started 2025-12-20 07:46:08.4258 AlertProcessor ProcessorAlertData: Stopped 2025-12-20 07:50:58.3186 DFramework.Database.Query /* Time Taken: 1248*/ [dbo].GenerateSystemAlerts 2025-12-20 07:51:03.6311 AlertProcessor ProcessorAlertData: started 2025-12-20 07:51:06.5843 DFramework.Database.Query /* Time Taken: 1834*/ 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-20 07:51:08.9124 AlertProcessor ProcessorAlertData: Stopped 2025-12-20 07:51:12.3031 DFramework.Scheduler.TaskBase /* Time Taken: 15562.613*/ Opportunity Out Of Stock By Outlet 2025-12-20 07:56:03.6489 AlertProcessor ProcessorAlertData: started 2025-12-20 07:56:08.4615 AlertProcessor ProcessorAlertData: Stopped 2025-12-20 08:01:03.6668 AlertProcessor ProcessorAlertData: started 2025-12-20 08:01:08.4168 AlertProcessor ProcessorAlertData: Stopped 2025-12-20 08:05:58.7003 DFramework.Database.Query /* Time Taken: 1608*/ [dbo].GenerateSystemAlerts 2025-12-20 08:06:03.6847 AlertProcessor ProcessorAlertData: started 2025-12-20 08:06:04.7473 DFramework.Database.Query /* Time Taken: 622*/ DECLARE @TableName AnsiString(8000) SET @TableName = 'VoidAlert' DECLARE @CurrentRecordId Int32 SET @CurrentRecordId = '3674560' dbo.GetValidDeviceForAlertProcessData 2025-12-20 08:06:09.0598 AlertProcessor ProcessorAlertData: Stopped 2025-12-20 08:06:12.3411 DFramework.Scheduler.TaskBase /* Time Taken: 15578.3075*/ Opportunity Out Of Stock By Outlet 2025-12-20 08:11:03.7033 AlertProcessor ProcessorAlertData: started 2025-12-20 08:11:08.5159 AlertProcessor ProcessorAlertData: Stopped 2025-12-20 08:16:03.7057 AlertProcessor ProcessorAlertData: started 2025-12-20 08:16:08.4714 AlertProcessor ProcessorAlertData: Stopped 2025-12-20 08:20:58.1766 DFramework.Database.Query /* Time Taken: 1057*/ [dbo].GenerateSystemAlerts 2025-12-20 08:21:03.7236 AlertProcessor ProcessorAlertData: started 2025-12-20 08:21:08.8330 AlertProcessor ProcessorAlertData: Stopped 2025-12-20 08:21:12.3642 DFramework.Scheduler.TaskBase /* Time Taken: 15578.2353*/ Opportunity Out Of Stock By Outlet 2025-12-20 08:26:03.7425 AlertProcessor ProcessorAlertData: started 2025-12-20 08:26:08.6175 AlertProcessor ProcessorAlertData: Stopped 2025-12-20 08:31:03.7609 AlertProcessor ProcessorAlertData: started 2025-12-20 08:31:08.7140 AlertProcessor ProcessorAlertData: Stopped 2025-12-20 08:35:58.4350 DFramework.Database.Query /* Time Taken: 1285*/ [dbo].GenerateSystemAlerts 2025-12-20 08:35:58.5600 MoveToReorder Running task for ClientId : 286 and ClientName = India Office QA and Slot: 12/20/2025 10:00:00 PM And LastExecutedOn: 12/20/2025 9:05:58 PM 2025-12-20 08:36:03.7788 AlertProcessor ProcessorAlertData: started 2025-12-20 08:36:08.1226 DFramework.Database.Query /* Time Taken: 526*/ DECLARE @TableName AnsiString(8000) SET @TableName = 'AssetPlanogram' DECLARE @CurrentRecordId Int32 SET @CurrentRecordId = '3674560' dbo.GetValidDeviceForAlertProcessData 2025-12-20 08:36:09.5445 AlertProcessor ProcessorAlertData: Stopped 2025-12-20 08:36:12.4976 DFramework.Scheduler.TaskBase /* Time Taken: 15687.6189*/ Opportunity Out Of Stock By Outlet 2025-12-20 08:36:39.8103 DFramework.Database.NullableDataReader Data reader open for 41002 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-20 08:36:39.8416 MoveToReorder Task executed successfully for ClientId : 286 Client Name:India Office QA, Slot: 12/20/2025 10:00:00 PM and Total Order Suggested: 122 Out Of: 122 2025-12-20 08:36:40.6541 DFramework.Scheduler.TaskBase /* Time Taken: 42531.5699*/ Move To Re-Order 2025-12-20 08:41:03.7959 AlertProcessor ProcessorAlertData: started 2025-12-20 08:41:09.0772 AlertProcessor ProcessorAlertData: Stopped 2025-12-20 08:46:03.8126 AlertProcessor ProcessorAlertData: started 2025-12-20 08:46:09.1095 AlertProcessor ProcessorAlertData: Stopped 2025-12-20 08:50:58.2363 DFramework.Database.Query /* Time Taken: 1063*/ [dbo].GenerateSystemAlerts 2025-12-20 08:51:03.8300 AlertProcessor ProcessorAlertData: started 2025-12-20 08:51:09.0176 AlertProcessor ProcessorAlertData: Stopped 2025-12-20 08:51:12.4239 DFramework.Scheduler.TaskBase /* Time Taken: 15593.858*/ Opportunity Out Of Stock By Outlet 2025-12-20 08:56:03.8478 AlertProcessor ProcessorAlertData: started 2025-12-20 08:56:09.1290 AlertProcessor ProcessorAlertData: Stopped 2025-12-20 09:01:03.8499 AlertProcessor ProcessorAlertData: started 2025-12-20 09:01:09.1468 AlertProcessor ProcessorAlertData: Stopped 2025-12-20 09:05:58.2739 DFramework.Database.Query /* Time Taken: 1085*/ [dbo].GenerateSystemAlerts 2025-12-20 09:06:03.8521 AlertProcessor ProcessorAlertData: started 2025-12-20 09:06:09.4927 AlertProcessor ProcessorAlertData: Stopped 2025-12-20 09:06:12.4146 DFramework.Scheduler.TaskBase /* Time Taken: 15562.6006*/ Opportunity Out Of Stock By Outlet 2025-12-20 09:11:03.8699 AlertProcessor ProcessorAlertData: started 2025-12-20 09:11:09.4793 AlertProcessor ProcessorAlertData: Stopped 2025-12-20 09:16:03.8877 AlertProcessor ProcessorAlertData: started 2025-12-20 09:16:09.6533 DFramework.Database.Query /* Time Taken: 717*/ DECLARE @TableName AnsiString(8000) SET @TableName = 'ProductStockLevel' DECLARE @CurrentRecordId Int32 SET @CurrentRecordId = '3674560' dbo.GetValidDeviceForAlertProcessData 2025-12-20 09:16:09.7158 AlertProcessor ProcessorAlertData: Stopped 2025-12-20 09:20:58.5148 DFramework.Database.Query /* Time Taken: 1306*/ [dbo].GenerateSystemAlerts 2025-12-20 09:21:03.9055 AlertProcessor ProcessorAlertData: started 2025-12-20 09:21:06.3586 DFramework.Database.Query /* Time Taken: 1395*/ 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-20 09:21:09.5774 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-20 09:21:09.9368 AlertProcessor ProcessorAlertData: Stopped 2025-12-20 09:21:12.4524 DFramework.Scheduler.TaskBase /* Time Taken: 15593.8542*/ Opportunity Out Of Stock By Outlet 2025-12-20 09:26:03.9077 AlertProcessor ProcessorAlertData: started 2025-12-20 09:26:09.2827 AlertProcessor ProcessorAlertData: Stopped 2025-12-20 09:31:03.9255 AlertProcessor ProcessorAlertData: started 2025-12-20 09:31:05.9099 DFramework.Database.NullableDataReader Data reader open for 279 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-20 09:31:09.3162 AlertProcessor ProcessorAlertData: Stopped 2025-12-20 09:35:58.5998 DFramework.Database.Query /* Time Taken: 1369*/ [dbo].GenerateSystemAlerts 2025-12-20 09:36:03.9436 AlertProcessor ProcessorAlertData: started 2025-12-20 09:36:09.3499 AlertProcessor ProcessorAlertData: Stopped 2025-12-20 09:36:12.7405 DFramework.Scheduler.TaskBase /* Time Taken: 15875.1202*/ Opportunity Out Of Stock By Outlet 2025-12-20 09:41:03.9614 AlertProcessor ProcessorAlertData: started 2025-12-20 09:41:09.3677 AlertProcessor ProcessorAlertData: Stopped 2025-12-20 09:46:03.9792 AlertProcessor ProcessorAlertData: started 2025-12-20 09:46:09.2449 AlertProcessor ProcessorAlertData: Stopped 2025-12-20 09:50:58.3877 DFramework.Database.Query /* Time Taken: 1125*/ [dbo].GenerateSystemAlerts 2025-12-20 09:51:03.9971 AlertProcessor ProcessorAlertData: started 2025-12-20 09:51:04.6378 DFramework.Database.Query /* Time Taken: 635*/ DECLARE @TableName AnsiString(8000) SET @TableName = 'TagAlert' DECLARE @CurrentRecordId Int32 SET @CurrentRecordId = '0' dbo.GetValidDeviceForAlertProcessData 2025-12-20 09:51:09.7159 AlertProcessor ProcessorAlertData: Stopped 2025-12-20 09:51:12.4191 DFramework.Scheduler.TaskBase /* Time Taken: 15546.9887*/ Opportunity Out Of Stock By Outlet 2025-12-20 09:56:04.0149 AlertProcessor ProcessorAlertData: started 2025-12-20 09:56:09.2494 AlertProcessor ProcessorAlertData: Stopped 2025-12-20 10:01:04.0328 AlertProcessor ProcessorAlertData: started 2025-12-20 10:01:09.2985 AlertProcessor ProcessorAlertData: Stopped 2025-12-20 10:05:58.3475 DFramework.Database.Query /* Time Taken: 1077*/ [dbo].GenerateSystemAlerts 2025-12-20 10:06:04.0506 AlertProcessor ProcessorAlertData: started 2025-12-20 10:06:09.4101 AlertProcessor ProcessorAlertData: Stopped 2025-12-20 10:06:12.4882 DFramework.Scheduler.TaskBase /* Time Taken: 15609.4958*/ Opportunity Out Of Stock By Outlet 2025-12-20 10:11:04.0529 AlertProcessor ProcessorAlertData: started 2025-12-20 10:11:09.3342 AlertProcessor ProcessorAlertData: Stopped 2025-12-20 10:16:04.0551 AlertProcessor ProcessorAlertData: started 2025-12-20 10:16:09.4458 AlertProcessor ProcessorAlertData: Stopped 2025-12-20 10:20:58.4010 DFramework.Database.Query /* Time Taken: 1095*/ [dbo].GenerateSystemAlerts 2025-12-20 10:21:04.0573 AlertProcessor ProcessorAlertData: started 2025-12-20 10:21:09.3698 AlertProcessor ProcessorAlertData: Stopped 2025-12-20 10:21:12.4949 DFramework.Scheduler.TaskBase /* Time Taken: 15609.5103*/ Opportunity Out Of Stock By Outlet 2025-12-20 10:26:04.0752 AlertProcessor ProcessorAlertData: started 2025-12-20 10:26:09.5753 AlertProcessor ProcessorAlertData: Stopped 2025-12-20 10:31:04.0930 AlertProcessor ProcessorAlertData: started 2025-12-20 10:31:09.4056 AlertProcessor ProcessorAlertData: Stopped 2025-12-20 10:35:58.3764 DFramework.Database.Query /* Time Taken: 1075*/ [dbo].GenerateSystemAlerts 2025-12-20 10:36:04.1109 AlertProcessor ProcessorAlertData: started 2025-12-20 10:36:09.3296 AlertProcessor ProcessorAlertData: Stopped 2025-12-20 10:36:12.4859 DFramework.Scheduler.TaskBase /* Time Taken: 15593.8463*/ Opportunity Out Of Stock By Outlet 2025-12-20 10:41:04.1288 AlertProcessor ProcessorAlertData: started 2025-12-20 10:41:09.4257 AlertProcessor ProcessorAlertData: Stopped 2025-12-20 10:46:04.1467 AlertProcessor ProcessorAlertData: started 2025-12-20 10:46:09.3498 AlertProcessor ProcessorAlertData: Stopped 2025-12-20 10:50:58.7582 DFramework.Database.Query /* Time Taken: 1424*/ [dbo].GenerateSystemAlerts 2025-12-20 10:51:04.1489 AlertProcessor ProcessorAlertData: started 2025-12-20 10:51:07.3364 DFramework.Database.Query /* Time Taken: 656*/ DECLARE @TableName AnsiString(8000) SET @TableName = 'AssetStockProductWiseConsolidate' DECLARE @CurrentRecordId Int32 SET @CurrentRecordId = '3674560' dbo.GetValidDeviceForAlertProcessData 2025-12-20 10:51:07.7270 DFramework.Database.Query /* Time Taken: 2502*/ 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-20 10:51:10.2427 AlertProcessor ProcessorAlertData: Stopped 2025-12-20 10:51:12.4614 DFramework.Scheduler.TaskBase /* Time Taken: 15562.6044*/ Opportunity Out Of Stock By Outlet 2025-12-20 10:56:04.1511 AlertProcessor ProcessorAlertData: started 2025-12-20 10:56:09.4480 AlertProcessor ProcessorAlertData: Stopped 2025-12-20 11:01:04.1533 AlertProcessor ProcessorAlertData: started 2025-12-20 11:01:09.4658 AlertProcessor ProcessorAlertData: Stopped 2025-12-20 11:05:58.8273 DFramework.Database.Query /* Time Taken: 1470*/ [dbo].GenerateSystemAlerts 2025-12-20 11:06:04.1555 AlertProcessor ProcessorAlertData: started 2025-12-20 11:06:09.3743 AlertProcessor ProcessorAlertData: Stopped 2025-12-20 11:06:12.5462 DFramework.Scheduler.TaskBase /* Time Taken: 15625.1177*/ Opportunity Out Of Stock By Outlet 2025-12-20 11:11:04.1733 AlertProcessor ProcessorAlertData: started 2025-12-20 11:11:09.5015 AlertProcessor ProcessorAlertData: Stopped 2025-12-20 11:16:04.1756 AlertProcessor ProcessorAlertData: started 2025-12-20 11:16:09.3788 AlertProcessor ProcessorAlertData: Stopped 2025-12-20 11:20:58.4434 DFramework.Database.Query /* Time Taken: 1075*/ [dbo].GenerateSystemAlerts 2025-12-20 11:21:04.1934 AlertProcessor ProcessorAlertData: started 2025-12-20 11:21:09.5216 AlertProcessor ProcessorAlertData: Stopped 2025-12-20 11:21:12.4904 DFramework.Scheduler.TaskBase /* Time Taken: 15546.9951*/ Opportunity Out Of Stock By Outlet 2025-12-20 11:26:04.2113 AlertProcessor ProcessorAlertData: started 2025-12-20 11:26:09.4457 AlertProcessor ProcessorAlertData: Stopped 2025-12-20 11:31:04.2135 AlertProcessor ProcessorAlertData: started 2025-12-20 11:31:09.3854 AlertProcessor ProcessorAlertData: Stopped 2025-12-20 11:35:58.8406 DFramework.Database.Query /* Time Taken: 1455*/ [dbo].GenerateSystemAlerts 2025-12-20 11:36:04.2157 AlertProcessor ProcessorAlertData: started 2025-12-20 11:36:09.3407 AlertProcessor ProcessorAlertData: Stopped 2025-12-20 11:36:12.7470 DFramework.Scheduler.TaskBase /* Time Taken: 15781.3634*/ Opportunity Out Of Stock By Outlet 2025-12-20 11:41:04.2335 AlertProcessor ProcessorAlertData: started 2025-12-20 11:41:09.4835 AlertProcessor ProcessorAlertData: Stopped 2025-12-20 11:46:04.2513 AlertProcessor ProcessorAlertData: started 2025-12-20 11:46:09.4232 AlertProcessor ProcessorAlertData: Stopped 2025-12-20 11:50:58.4410 DFramework.Database.Query /* Time Taken: 1052*/ [dbo].GenerateSystemAlerts 2025-12-20 11:51:04.2692 AlertProcessor ProcessorAlertData: started 2025-12-20 11:51:04.8474 DFramework.Database.Query /* Time Taken: 574*/ DECLARE @TableName AnsiString(8000) SET @TableName = 'TagAlert' DECLARE @CurrentRecordId Int32 SET @CurrentRecordId = '0' dbo.GetValidDeviceForAlertProcessData 2025-12-20 11:51:09.8943 AlertProcessor ProcessorAlertData: Stopped 2025-12-20 11:51:12.5193 DFramework.Scheduler.TaskBase /* Time Taken: 15546.9907*/ Opportunity Out Of Stock By Outlet 2025-12-20 11:56:04.2870 AlertProcessor ProcessorAlertData: started 2025-12-20 11:56:09.5527 AlertProcessor ProcessorAlertData: Stopped 2025-12-20 12:01:04.3049 AlertProcessor ProcessorAlertData: started 2025-12-20 12:01:04.9455 DFramework.Database.Query /* Time Taken: 627*/ DECLARE @TableName AnsiString(8000) SET @TableName = 'TagAlert' DECLARE @CurrentRecordId Int32 SET @CurrentRecordId = '0' dbo.GetValidDeviceForAlertProcessData 2025-12-20 12:01:10.9612 AlertProcessor ProcessorAlertData: Stopped 2025-12-20 12:05:58.4642 DFramework.Database.Query /* Time Taken: 1058*/ [dbo].GenerateSystemAlerts 2025-12-20 12:06:04.3236 AlertProcessor ProcessorAlertData: started 2025-12-20 12:06:09.6206 AlertProcessor ProcessorAlertData: Stopped 2025-12-20 12:06:12.4800 DFramework.Scheduler.TaskBase /* Time Taken: 15500.2211*/ Opportunity Out Of Stock By Outlet 2025-12-20 12:11:04.3426 AlertProcessor ProcessorAlertData: started 2025-12-20 12:11:09.5927 AlertProcessor ProcessorAlertData: Stopped 2025-12-20 12:16:04.3608 AlertProcessor ProcessorAlertData: started 2025-12-20 12:16:09.6734 AlertProcessor ProcessorAlertData: Stopped 2025-12-20 12:20:58.8631 DFramework.Database.Query /* Time Taken: 1429*/ [dbo].GenerateSystemAlerts 2025-12-20 12:21:04.3631 AlertProcessor ProcessorAlertData: started 2025-12-20 12:21:06.6756 DFramework.Database.Query /* Time Taken: 1276*/ 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-20 12:21:09.8475 AlertProcessor ProcessorAlertData: Stopped 2025-12-20 12:21:12.5194 DFramework.Scheduler.TaskBase /* Time Taken: 15531.3631*/ Opportunity Out Of Stock By Outlet 2025-12-20 12:26:04.3794 AlertProcessor ProcessorAlertData: started 2025-12-20 12:26:09.7544 AlertProcessor ProcessorAlertData: Stopped 2025-12-20 12:31:04.3967 AlertProcessor ProcessorAlertData: started 2025-12-20 12:31:09.8186 AlertProcessor ProcessorAlertData: Stopped 2025-12-20 12:35:59.0706 DFramework.Database.Query /* Time Taken: 1628*/ [dbo].GenerateSystemAlerts 2025-12-20 12:36:04.4143 AlertProcessor ProcessorAlertData: started 2025-12-20 12:36:09.8675 AlertProcessor ProcessorAlertData: Stopped 2025-12-20 12:36:12.4925 DFramework.Scheduler.TaskBase /* Time Taken: 15484.4845*/ Opportunity Out Of Stock By Outlet 2025-12-20 12:41:04.4165 AlertProcessor ProcessorAlertData: started 2025-12-20 12:41:09.6978 AlertProcessor ProcessorAlertData: Stopped 2025-12-20 12:46:04.4187 AlertProcessor ProcessorAlertData: started 2025-12-20 12:46:09.6375 AlertProcessor ProcessorAlertData: Stopped 2025-12-20 12:50:58.4833 DFramework.Database.Query /* Time Taken: 1043*/ [dbo].GenerateSystemAlerts 2025-12-20 12:51:04.4365 AlertProcessor ProcessorAlertData: started 2025-12-20 12:51:09.7803 AlertProcessor ProcessorAlertData: Stopped 2025-12-20 12:51:12.5772 DFramework.Scheduler.TaskBase /* Time Taken: 15546.9955*/ Opportunity Out Of Stock By Outlet 2025-12-20 12:56:04.4543 AlertProcessor ProcessorAlertData: started 2025-12-20 12:56:09.6575 AlertProcessor ProcessorAlertData: Stopped 2025-12-20 13:01:04.4722 AlertProcessor ProcessorAlertData: started 2025-12-20 13:01:09.7066 AlertProcessor ProcessorAlertData: Stopped 2025-12-20 13:05:58.5056 DFramework.Database.Query /* Time Taken: 1031*/ [dbo].GenerateSystemAlerts 2025-12-20 13:06:04.4900 AlertProcessor ProcessorAlertData: started 2025-12-20 13:06:09.7401 AlertProcessor ProcessorAlertData: Stopped 2025-12-20 13:06:12.5995 DFramework.Scheduler.TaskBase /* Time Taken: 15546.9908*/ Opportunity Out Of Stock By Outlet 2025-12-20 13:11:04.5078 AlertProcessor ProcessorAlertData: started 2025-12-20 13:11:09.8985 AlertProcessor ProcessorAlertData: Stopped 2025-12-20 13:16:04.5101 AlertProcessor ProcessorAlertData: started 2025-12-20 13:16:09.8227 AlertProcessor ProcessorAlertData: Stopped 2025-12-20 13:20:58.5592 DFramework.Database.Query /* Time Taken: 1063*/ [dbo].GenerateSystemAlerts 2025-12-20 13:21:04.5124 AlertProcessor ProcessorAlertData: started 2025-12-20 13:21:09.8249 AlertProcessor ProcessorAlertData: Stopped 2025-12-20 13:21:12.6218 DFramework.Scheduler.TaskBase /* Time Taken: 15546.9874*/ Opportunity Out Of Stock By Outlet 2025-12-20 13:26:04.5146 AlertProcessor ProcessorAlertData: started 2025-12-20 13:26:09.7490 AlertProcessor ProcessorAlertData: Stopped 2025-12-20 13:31:04.5168 AlertProcessor ProcessorAlertData: started 2025-12-20 13:31:09.7512 AlertProcessor ProcessorAlertData: Stopped 2025-12-20 13:35:58.7690 DFramework.Database.Query /* Time Taken: 1259*/ [dbo].GenerateSystemAlerts 2025-12-20 13:36:04.5190 AlertProcessor ProcessorAlertData: started 2025-12-20 13:36:09.7847 AlertProcessor ProcessorAlertData: Stopped 2025-12-20 13:36:12.5816 DFramework.Scheduler.TaskBase /* Time Taken: 15484.4854*/ Opportunity Out Of Stock By Outlet 2025-12-20 13:41:04.5212 AlertProcessor ProcessorAlertData: started 2025-12-20 13:41:09.7869 AlertProcessor ProcessorAlertData: Stopped 2025-12-20 13:46:04.5234 AlertProcessor ProcessorAlertData: started 2025-12-20 13:46:09.8984 AlertProcessor ProcessorAlertData: Stopped 2025-12-20 13:50:58.8538 DFramework.Database.Query /* Time Taken: 1312*/ [dbo].GenerateSystemAlerts 2025-12-20 13:51:04.5413 AlertProcessor ProcessorAlertData: started 2025-12-20 13:51:06.1663 DFramework.Database.Query /* Time Taken: 513*/ 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-20 13:51:10.0258 AlertProcessor ProcessorAlertData: Stopped 2025-12-20 13:51:12.6820 DFramework.Scheduler.TaskBase /* Time Taken: 15562.6178*/ Opportunity Out Of Stock By Outlet 2025-12-20 13:56:04.5592 AlertProcessor ProcessorAlertData: started 2025-12-20 13:56:09.7467 AlertProcessor ProcessorAlertData: Stopped 2025-12-20 14:01:04.5770 AlertProcessor ProcessorAlertData: started 2025-12-20 14:01:06.2645 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-20 14:01:09.9989 AlertProcessor ProcessorAlertData: Stopped 2025-12-20 14:05:58.8917 DFramework.Database.Query /* Time Taken: 1350*/ [dbo].GenerateSystemAlerts 2025-12-20 14:06:04.5949 AlertProcessor ProcessorAlertData: started 2025-12-20 14:06:09.9231 AlertProcessor ProcessorAlertData: Stopped 2025-12-20 14:06:12.6731 DFramework.Scheduler.TaskBase /* Time Taken: 15531.3689*/ Opportunity Out Of Stock By Outlet 2025-12-20 14:11:04.6128 AlertProcessor ProcessorAlertData: started 2025-12-20 14:11:09.8784 AlertProcessor ProcessorAlertData: Stopped 2025-12-20 14:16:04.6306 AlertProcessor ProcessorAlertData: started 2025-12-20 14:16:09.8338 AlertProcessor ProcessorAlertData: Stopped 2025-12-20 14:20:58.6015 DFramework.Database.Query /* Time Taken: 1046*/ [dbo].GenerateSystemAlerts 2025-12-20 14:21:04.6484 AlertProcessor ProcessorAlertData: started 2025-12-20 14:21:09.9766 AlertProcessor ProcessorAlertData: Stopped 2025-12-20 14:21:12.7110 DFramework.Scheduler.TaskBase /* Time Taken: 15546.9953*/ Opportunity Out Of Stock By Outlet 2025-12-20 14:26:04.6663 AlertProcessor ProcessorAlertData: started 2025-12-20 14:26:10.0413 AlertProcessor ProcessorAlertData: Stopped 2025-12-20 14:31:04.6685 AlertProcessor ProcessorAlertData: started 2025-12-20 14:31:09.9498 AlertProcessor ProcessorAlertData: Stopped 2025-12-20 14:36:00.4519 DFramework.Database.Query /* Time Taken: 1745*/ DECLARE @OrderStatusId Int32 SET @OrderStatusId = '5486' UPDATE Location SET ScheduledOrderId = 0, OrderStatusId = 0 from ScheduledOrder INNER JOIN Location ON Location.ScheduledOrderId = ScheduledOrder.ScheduledOrderId AND Location.OrderStatusId = @OrderStatusId INNER JOIN CLient On Client.ClientId = Location.ClientId AND Client.HoursToMoveIgnored > 0 WHERE DATEADD(HOUR, Client.HoursToMoveIgnored, ScheduledOrder.ModifiedOn) < GETUTCDATE() AND ScheduledOrder.StatusId = @OrderStatusId ANd Location.IsDeleted = 0 AND ScheduledOrder.IsDeleted = 0 2025-12-20 14:36:00.5612 DFramework.Database.Query /* Time Taken: 2971*/ [dbo].GenerateSystemAlerts 2025-12-20 14:36:04.6863 AlertProcessor ProcessorAlertData: started 2025-12-20 14:36:09.9676 AlertProcessor ProcessorAlertData: Stopped 2025-12-20 14:36:12.7020 DFramework.Scheduler.TaskBase /* Time Taken: 15531.3642*/ Opportunity Out Of Stock By Outlet 2025-12-20 14:41:04.7041 AlertProcessor ProcessorAlertData: started 2025-12-20 14:41:10.0323 AlertProcessor ProcessorAlertData: Stopped 2025-12-20 14:46:04.7219 AlertProcessor ProcessorAlertData: started 2025-12-20 14:46:09.9876 AlertProcessor ProcessorAlertData: Stopped 2025-12-20 14:50:58.7553 DFramework.Database.Query /* Time Taken: 1140*/ [dbo].GenerateSystemAlerts 2025-12-20 14:51:04.7241 AlertProcessor ProcessorAlertData: started 2025-12-20 14:51:10.4273 AlertProcessor ProcessorAlertData: Stopped 2025-12-20 14:51:12.7242 DFramework.Scheduler.TaskBase /* Time Taken: 15546.9895*/ Opportunity Out Of Stock By Outlet 2025-12-20 14:56:04.7263 AlertProcessor ProcessorAlertData: started 2025-12-20 14:56:09.9920 AlertProcessor ProcessorAlertData: Stopped 2025-12-20 15:01:04.7441 AlertProcessor ProcessorAlertData: started 2025-12-20 15:01:06.1035 DFramework.Database.Query /* Time Taken: 576*/ DECLARE @TableName AnsiString(8000) SET @TableName = 'MissingShelf' DECLARE @CurrentRecordId Int32 SET @CurrentRecordId = '3674560' dbo.GetValidDeviceForAlertProcessData 2025-12-20 15:01:10.4473 AlertProcessor ProcessorAlertData: Stopped 2025-12-20 15:05:58.6994 DFramework.Database.Query /* Time Taken: 1075*/ [dbo].GenerateSystemAlerts 2025-12-20 15:06:04.7619 AlertProcessor ProcessorAlertData: started 2025-12-20 15:06:10.4807 AlertProcessor ProcessorAlertData: Stopped 2025-12-20 15:06:12.6995 DFramework.Scheduler.TaskBase /* Time Taken: 15500.1123*/ Opportunity Out Of Stock By Outlet 2025-12-20 15:11:04.7641 AlertProcessor ProcessorAlertData: started 2025-12-20 15:11:07.4985 DFramework.Database.Query /* Time Taken: 548*/ DECLARE @TableName AnsiString(8000) SET @TableName = 'AssetStockProductWiseConsolidate' DECLARE @CurrentRecordId Int32 SET @CurrentRecordId = '3674560' dbo.GetValidDeviceForAlertProcessData 2025-12-20 15:11:10.4985 AlertProcessor ProcessorAlertData: Stopped 2025-12-20 15:16:04.7818 AlertProcessor ProcessorAlertData: started 2025-12-20 15:16:10.1881 AlertProcessor ProcessorAlertData: Stopped 2025-12-20 15:20:58.9401 DFramework.Database.Query /* Time Taken: 1307*/ [dbo].GenerateSystemAlerts 2025-12-20 15:21:04.7995 AlertProcessor ProcessorAlertData: started 2025-12-20 15:21:10.3777 DFramework.Database.Query /* Time Taken: 521*/ DECLARE @TableName AnsiString(8000) SET @TableName = 'ProductStockLevel' DECLARE @CurrentRecordId Int32 SET @CurrentRecordId = '3674560' dbo.GetValidDeviceForAlertProcessData 2025-12-20 15:21:10.4402 AlertProcessor ProcessorAlertData: Stopped 2025-12-20 15:21:12.7371 DFramework.Scheduler.TaskBase /* Time Taken: 15531.345*/ Opportunity Out Of Stock By Outlet 2025-12-20 15:26:04.8174 AlertProcessor ProcessorAlertData: started 2025-12-20 15:26:10.1299 AlertProcessor ProcessorAlertData: Stopped 2025-12-20 15:31:04.8195 AlertProcessor ProcessorAlertData: started 2025-12-20 15:31:10.0383 AlertProcessor ProcessorAlertData: Stopped 2025-12-20 15:35:59.3528 DFramework.Database.Query /* Time Taken: 1715*/ [dbo].GenerateSystemAlerts 2025-12-20 15:36:04.8216 AlertProcessor ProcessorAlertData: started 2025-12-20 15:36:10.1029 AlertProcessor ProcessorAlertData: Stopped 2025-12-20 15:36:12.7123 DFramework.Scheduler.TaskBase /* Time Taken: 15484.4857*/ Opportunity Out Of Stock By Outlet 2025-12-20 15:41:04.8238 AlertProcessor ProcessorAlertData: started 2025-12-20 15:41:10.0582 AlertProcessor ProcessorAlertData: Stopped 2025-12-20 15:46:04.8260 AlertProcessor ProcessorAlertData: started 2025-12-20 15:46:10.1542 AlertProcessor ProcessorAlertData: Stopped 2025-12-20 15:50:58.6875 DFramework.Database.Query /* Time Taken: 1030*/ [dbo].GenerateSystemAlerts 2025-12-20 15:51:04.8438 AlertProcessor ProcessorAlertData: started 2025-12-20 15:51:10.2032 AlertProcessor ProcessorAlertData: Stopped 2025-12-20 15:51:12.7345 DFramework.Scheduler.TaskBase /* Time Taken: 15484.4907*/ Opportunity Out Of Stock By Outlet 2025-12-20 15:56:04.8616 AlertProcessor ProcessorAlertData: started 2025-12-20 15:56:10.1585 AlertProcessor ProcessorAlertData: Stopped 2025-12-20 16:01:04.8794 AlertProcessor ProcessorAlertData: started 2025-12-20 16:01:10.1138 AlertProcessor ProcessorAlertData: Stopped 2025-12-20 16:05:58.7409 DFramework.Database.Query /* Time Taken: 1053*/ [dbo].GenerateSystemAlerts 2025-12-20 16:06:04.8972 AlertProcessor ProcessorAlertData: started 2025-12-20 16:06:10.1629 AlertProcessor ProcessorAlertData: Stopped 2025-12-20 16:06:12.7566 DFramework.Scheduler.TaskBase /* Time Taken: 15500.122*/ Opportunity Out Of Stock By Outlet 2025-12-20 16:11:04.9150 AlertProcessor ProcessorAlertData: started 2025-12-20 16:11:10.1494 AlertProcessor ProcessorAlertData: Stopped 2025-12-20 16:16:04.9172 AlertProcessor ProcessorAlertData: started 2025-12-20 16:16:09.4328 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-20 16:16:10.3703 AlertProcessor ProcessorAlertData: Stopped 2025-12-20 16:20:58.8725 DFramework.Database.Query /* Time Taken: 1160*/ [dbo].GenerateSystemAlerts 2025-12-20 16:21:04.9194 AlertProcessor ProcessorAlertData: started 2025-12-20 16:21:10.2475 AlertProcessor ProcessorAlertData: Stopped 2025-12-20 16:21:12.7632 DFramework.Scheduler.TaskBase /* Time Taken: 15500.1148*/ Opportunity Out Of Stock By Outlet 2025-12-20 16:26:04.9216 AlertProcessor ProcessorAlertData: started 2025-12-20 16:26:10.2341 AlertProcessor ProcessorAlertData: Stopped 2025-12-20 16:31:04.9238 AlertProcessor ProcessorAlertData: started 2025-12-20 16:31:10.2050 AlertProcessor ProcessorAlertData: Stopped 2025-12-20 16:35:58.7697 DFramework.Database.Query /* Time Taken: 1032*/ [dbo].GenerateSystemAlerts 2025-12-20 16:36:04.9416 AlertProcessor ProcessorAlertData: started 2025-12-20 16:36:10.3635 AlertProcessor ProcessorAlertData: Stopped 2025-12-20 16:36:12.8479 DFramework.Scheduler.TaskBase /* Time Taken: 15562.6128*/ Opportunity Out Of Stock By Outlet 2025-12-20 16:41:04.9593 AlertProcessor ProcessorAlertData: started 2025-12-20 16:41:10.2250 AlertProcessor ProcessorAlertData: Stopped 2025-12-20 16:46:04.9771 AlertProcessor ProcessorAlertData: started 2025-12-20 16:46:10.1334 AlertProcessor ProcessorAlertData: Stopped 2025-12-20 16:50:59.3074 DFramework.Database.Query /* Time Taken: 1561*/ [dbo].GenerateSystemAlerts 2025-12-20 16:51:04.9793 AlertProcessor ProcessorAlertData: started 2025-12-20 16:51:07.9168 DFramework.Database.Query /* Time Taken: 577*/ DECLARE @TableName AnsiString(8000) SET @TableName = 'AssetStockProductWiseConsolidate' DECLARE @CurrentRecordId Int32 SET @CurrentRecordId = '3674560' dbo.GetValidDeviceForAlertProcessData 2025-12-20 16:51:07.9949 DFramework.Database.Query /* Time Taken: 1895*/ 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-20 16:51:10.7606 AlertProcessor ProcessorAlertData: Stopped 2025-12-20 16:51:12.8543 DFramework.Scheduler.TaskBase /* Time Taken: 15562.6146*/ Opportunity Out Of Stock By Outlet 2025-12-20 16:56:04.9971 AlertProcessor ProcessorAlertData: started 2025-12-20 16:56:10.2158 AlertProcessor ProcessorAlertData: Stopped 2025-12-20 17:01:05.0148 AlertProcessor ProcessorAlertData: started 2025-12-20 17:01:10.2336 AlertProcessor ProcessorAlertData: Stopped 2025-12-20 17:05:59.2670 DFramework.Database.Query /* Time Taken: 1499*/ [dbo].GenerateSystemAlerts 2025-12-20 17:06:05.0326 AlertProcessor ProcessorAlertData: started 2025-12-20 17:06:10.4077 AlertProcessor ProcessorAlertData: Stopped 2025-12-20 17:06:12.8452 DFramework.Scheduler.TaskBase /* Time Taken: 15531.3638*/ Opportunity Out Of Stock By Outlet 2025-12-20 17:11:05.0348 AlertProcessor ProcessorAlertData: started 2025-12-20 17:11:10.3005 AlertProcessor ProcessorAlertData: Stopped 2025-12-20 17:16:05.0369 AlertProcessor ProcessorAlertData: started 2025-12-20 17:16:10.3182 AlertProcessor ProcessorAlertData: Stopped 2025-12-20 17:20:58.9922 DFramework.Database.Query /* Time Taken: 1193*/ [dbo].GenerateSystemAlerts 2025-12-20 17:21:05.0547 AlertProcessor ProcessorAlertData: started 2025-12-20 17:21:10.2735 AlertProcessor ProcessorAlertData: Stopped 2025-12-20 17:21:12.8829 DFramework.Scheduler.TaskBase /* Time Taken: 15546.991*/ Opportunity Out Of Stock By Outlet 2025-12-20 17:26:05.0726 AlertProcessor ProcessorAlertData: started 2025-12-20 17:26:10.3226 AlertProcessor ProcessorAlertData: Stopped 2025-12-20 17:31:05.0747 AlertProcessor ProcessorAlertData: started 2025-12-20 17:31:10.2935 AlertProcessor ProcessorAlertData: Stopped 2025-12-20 17:35:59.4206 DFramework.Database.Query /* Time Taken: 1599*/ [dbo].GenerateSystemAlerts 2025-12-20 17:36:05.0925 AlertProcessor ProcessorAlertData: started 2025-12-20 17:36:10.4050 AlertProcessor ProcessorAlertData: Stopped 2025-12-20 17:36:12.9207 DFramework.Scheduler.TaskBase /* Time Taken: 15562.613*/ Opportunity Out Of Stock By Outlet 2025-12-20 17:41:05.1103 AlertProcessor ProcessorAlertData: started 2025-12-20 17:41:10.4697 AlertProcessor ProcessorAlertData: Stopped 2025-12-20 17:46:05.1281 AlertProcessor ProcessorAlertData: started 2025-12-20 17:46:10.4719 AlertProcessor ProcessorAlertData: Stopped 2025-12-20 17:50:58.9114 DFramework.Database.Query /* Time Taken: 1070*/ [dbo].GenerateSystemAlerts 2025-12-20 17:51:05.1458 AlertProcessor ProcessorAlertData: started 2025-12-20 17:51:10.4271 AlertProcessor ProcessorAlertData: Stopped 2025-12-20 17:51:12.9428 DFramework.Scheduler.TaskBase /* Time Taken: 15562.6174*/ Opportunity Out Of Stock By Outlet 2025-12-20 17:56:05.1637 AlertProcessor ProcessorAlertData: started 2025-12-20 17:56:10.4606 AlertProcessor ProcessorAlertData: Stopped 2025-12-20 18:01:05.1815 AlertProcessor ProcessorAlertData: started 2025-12-20 18:01:08.6503 DFramework.Database.Query /* Time Taken: 537*/ DECLARE @TableName AnsiString(8000) SET @TableName = 'AssetStockProductWiseConsolidate' DECLARE @CurrentRecordId Int32 SET @CurrentRecordId = '3674560' dbo.GetValidDeviceForAlertProcessData 2025-12-20 18:01:12.3378 AlertProcessor ProcessorAlertData: Stopped 2025-12-20 18:06:02.0273 DFramework.Database.Query /* Time Taken: 4161*/ [dbo].GenerateSystemAlerts 2025-12-20 18:06:05.1992 AlertProcessor ProcessorAlertData: started 2025-12-20 18:06:10.6836 AlertProcessor ProcessorAlertData: Stopped 2025-12-20 18:06:13.4493 DFramework.Scheduler.TaskBase /* Time Taken: 16046.9887*/ Opportunity Out Of Stock By Outlet 2025-12-20 18:11:05.2170 AlertProcessor ProcessorAlertData: started 2025-12-20 18:11:10.5920 AlertProcessor ProcessorAlertData: Stopped 2025-12-20 18:16:05.2192 AlertProcessor ProcessorAlertData: started 2025-12-20 18:16:10.5005 AlertProcessor ProcessorAlertData: Stopped 2025-12-20 18:20:59.4244 DFramework.Database.Query /* Time Taken: 1534*/ [dbo].GenerateSystemAlerts 2025-12-20 18:21:05.2213 AlertProcessor ProcessorAlertData: started 2025-12-20 18:21:07.5963 DFramework.Database.Query /* Time Taken: 1212*/ 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-20 18:21:10.8776 AlertProcessor ProcessorAlertData: Stopped 2025-12-20 18:21:12.9713 DFramework.Scheduler.TaskBase /* Time Taken: 15546.9767*/ Opportunity Out Of Stock By Outlet 2025-12-20 18:26:05.2233 AlertProcessor ProcessorAlertData: started 2025-12-20 18:26:10.5046 AlertProcessor ProcessorAlertData: Stopped 2025-12-20 18:31:05.2412 AlertProcessor ProcessorAlertData: started 2025-12-20 18:31:10.4443 AlertProcessor ProcessorAlertData: Stopped 2025-12-20 18:35:59.3526 DFramework.Database.Query /* Time Taken: 1448*/ [dbo].GenerateSystemAlerts 2025-12-20 18:36:05.2589 AlertProcessor ProcessorAlertData: started 2025-12-20 18:36:07.9777 DFramework.Database.NullableDataReader Data reader open for 306 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-20 18:36:10.7590 AlertProcessor ProcessorAlertData: Stopped 2025-12-20 18:36:12.9934 DFramework.Scheduler.TaskBase /* Time Taken: 15546.9891*/ Opportunity Out Of Stock By Outlet 2025-12-20 18:41:05.2766 AlertProcessor ProcessorAlertData: started 2025-12-20 18:41:10.6048 AlertProcessor ProcessorAlertData: Stopped 2025-12-20 18:46:05.2944 AlertProcessor ProcessorAlertData: started 2025-12-20 18:46:10.8256 AlertProcessor ProcessorAlertData: Stopped 2025-12-20 18:50:59.0621 DFramework.Database.Query /* Time Taken: 1128*/ [dbo].GenerateSystemAlerts 2025-12-20 18:51:05.3122 AlertProcessor ProcessorAlertData: started 2025-12-20 18:51:10.8435 AlertProcessor ProcessorAlertData: Stopped 2025-12-20 18:51:12.9997 DFramework.Scheduler.TaskBase /* Time Taken: 15531.3639*/ Opportunity Out Of Stock By Outlet 2025-12-20 18:56:05.3298 AlertProcessor ProcessorAlertData: started 2025-12-20 18:56:10.8142 AlertProcessor ProcessorAlertData: Stopped 2025-12-20 19:01:05.3318 AlertProcessor ProcessorAlertData: started 2025-12-20 19:01:10.5975 AlertProcessor ProcessorAlertData: Stopped 2025-12-20 19:05:59.0214 DFramework.Database.Query /* Time Taken: 1067*/ [dbo].GenerateSystemAlerts 2025-12-20 19:06:05.3340 AlertProcessor ProcessorAlertData: started 2025-12-20 19:06:10.5840 AlertProcessor ProcessorAlertData: Stopped 2025-12-20 19:06:13.0528 DFramework.Scheduler.TaskBase /* Time Taken: 15562.6108*/ Opportunity Out Of Stock By Outlet 2025-12-20 19:11:05.3517 AlertProcessor ProcessorAlertData: started 2025-12-20 19:11:10.6018 AlertProcessor ProcessorAlertData: Stopped 2025-12-20 19:16:05.3695 AlertProcessor ProcessorAlertData: started 2025-12-20 19:16:10.4946 AlertProcessor ProcessorAlertData: Stopped 2025-12-20 19:20:59.1216 DFramework.Database.Query /* Time Taken: 1154*/ [dbo].GenerateSystemAlerts 2025-12-20 19:21:05.3717 AlertProcessor ProcessorAlertData: started 2025-12-20 19:21:10.6686 AlertProcessor ProcessorAlertData: Stopped 2025-12-20 19:21:13.0280 DFramework.Scheduler.TaskBase /* Time Taken: 15531.3654*/ Opportunity Out Of Stock By Outlet 2025-12-20 19:26:05.3895 AlertProcessor ProcessorAlertData: started 2025-12-20 19:26:10.6551 AlertProcessor ProcessorAlertData: Stopped 2025-12-20 19:31:05.3914 AlertProcessor ProcessorAlertData: started 2025-12-20 19:31:10.6883 AlertProcessor ProcessorAlertData: Stopped 2025-12-20 19:35:59.4402 DFramework.Database.Query /* Time Taken: 1452*/ [dbo].GenerateSystemAlerts 2025-12-20 19:36:05.4090 AlertProcessor ProcessorAlertData: started 2025-12-20 19:36:10.6278 AlertProcessor ProcessorAlertData: Stopped 2025-12-20 19:36:12.9872 DFramework.Scheduler.TaskBase /* Time Taken: 15484.485*/ Opportunity Out Of Stock By Outlet 2025-12-20 19:41:05.4268 AlertProcessor ProcessorAlertData: started 2025-12-20 19:41:10.6456 AlertProcessor ProcessorAlertData: Stopped 2025-12-20 19:46:05.4446 AlertProcessor ProcessorAlertData: started 2025-12-20 19:46:10.6946 AlertProcessor ProcessorAlertData: Stopped 2025-12-20 19:50:59.4310 DFramework.Database.Query /* Time Taken: 1407*/ [dbo].GenerateSystemAlerts 2025-12-20 19:51:05.4623 AlertProcessor ProcessorAlertData: started 2025-12-20 19:51:07.3217 DFramework.Database.Query /* Time Taken: 692*/ 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-20 19:51:10.7905 AlertProcessor ProcessorAlertData: Stopped 2025-12-20 19:51:13.0405 DFramework.Scheduler.TaskBase /* Time Taken: 15531.3626*/ Opportunity Out Of Stock By Outlet 2025-12-20 19:56:05.4801 AlertProcessor ProcessorAlertData: started 2025-12-20 19:56:10.8083 AlertProcessor ProcessorAlertData: Stopped 2025-12-20 20:01:05.4979 AlertProcessor ProcessorAlertData: started 2025-12-20 20:01:10.8729 AlertProcessor ProcessorAlertData: Stopped 2025-12-20 20:05:59.4219 DFramework.Database.Query /* Time Taken: 1374*/ [dbo].GenerateSystemAlerts 2025-12-20 20:06:05.5157 AlertProcessor ProcessorAlertData: started 2025-12-20 20:06:11.1251 AlertProcessor ProcessorAlertData: Stopped 2025-12-20 20:06:13.0470 DFramework.Scheduler.TaskBase /* Time Taken: 15515.7289*/ Opportunity Out Of Stock By Outlet 2025-12-20 20:11:05.5178 AlertProcessor ProcessorAlertData: started 2025-12-20 20:11:10.9866 AlertProcessor ProcessorAlertData: Stopped 2025-12-20 20:16:05.5356 AlertProcessor ProcessorAlertData: started 2025-12-20 20:16:10.9419 AlertProcessor ProcessorAlertData: Stopped 2025-12-20 20:20:59.1001 DFramework.Database.Query /* Time Taken: 1041*/ [dbo].GenerateSystemAlerts 2025-12-20 20:21:05.5533 AlertProcessor ProcessorAlertData: started 2025-12-20 20:21:10.9439 AlertProcessor ProcessorAlertData: Stopped 2025-12-20 20:21:13.1002 DFramework.Scheduler.TaskBase /* Time Taken: 15546.9532*/ Opportunity Out Of Stock By Outlet 2025-12-20 20:26:05.5552 AlertProcessor ProcessorAlertData: started 2025-12-20 20:26:10.9146 AlertProcessor ProcessorAlertData: Stopped 2025-12-20 20:31:05.5730 AlertProcessor ProcessorAlertData: started 2025-12-20 20:31:07.2918 DFramework.Database.Query /* Time Taken: 532*/ 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-20 20:31:07.4480 DFramework.Database.Query /* Time Taken: 604*/ DECLARE AlertTypeIds Object SET AlertTypeIds = 'DFramework.Database.Adapters.SQL+d__24' [dbo].GetAlertSummaryData 2025-12-20 20:31:08.0418 DFramework.Database.Query /* Time Taken: 589*/ 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-20 20:31:09.5418 DFramework.Database.Query /* Time Taken: 1018*/ 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-20 20:31:11.1043 DFramework.Database.Query /* Time Taken: 538*/ DECLARE @TableName AnsiString(8000) SET @TableName = 'TargetPortfolioComplianceConsolidate' DECLARE @CurrentRecordId Int32 SET @CurrentRecordId = '3674560' dbo.GetValidDeviceForAlertProcessData 2025-12-20 20:31:11.5105 AlertProcessor ProcessorAlertData: Stopped 2025-12-20 20:35:59.2470 DFramework.Database.Query /* Time Taken: 1162*/ [dbo].GenerateSystemAlerts 2025-12-20 20:36:05.5752 AlertProcessor ProcessorAlertData: started 2025-12-20 20:36:10.9346 AlertProcessor ProcessorAlertData: Stopped 2025-12-20 20:36:13.0596 DFramework.Scheduler.TaskBase /* Time Taken: 15484.485*/ Opportunity Out Of Stock By Outlet 2025-12-20 20:41:05.5927 AlertProcessor ProcessorAlertData: started 2025-12-20 20:41:11.0927 AlertProcessor ProcessorAlertData: Stopped 2025-12-20 20:46:05.6104 AlertProcessor ProcessorAlertData: started 2025-12-20 20:46:11.0167 AlertProcessor ProcessorAlertData: Stopped 2025-12-20 20:50:59.1750 DFramework.Database.Query /* Time Taken: 1063*/ [dbo].GenerateSystemAlerts 2025-12-20 20:51:05.6282 AlertProcessor ProcessorAlertData: started 2025-12-20 20:51:10.9720 AlertProcessor ProcessorAlertData: Stopped 2025-12-20 20:51:13.1438 DFramework.Scheduler.TaskBase /* Time Taken: 15546.9887*/ Opportunity Out Of Stock By Outlet 2025-12-20 20:56:05.6299 AlertProcessor ProcessorAlertData: started 2025-12-20 20:56:11.1456 DFramework.Database.NullableDataReader Data reader open for 278 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-20 20:56:11.1456 AlertProcessor ProcessorAlertData: Stopped 2025-12-20 21:01:05.6474 AlertProcessor ProcessorAlertData: started 2025-12-20 21:01:10.9444 AlertProcessor ProcessorAlertData: Stopped 2025-12-20 21:05:59.2120 DFramework.Database.Query /* Time Taken: 1082*/ [dbo].GenerateSystemAlerts 2025-12-20 21:06:05.6652 AlertProcessor ProcessorAlertData: started 2025-12-20 21:06:11.0246 AlertProcessor ProcessorAlertData: Stopped 2025-12-20 21:06:13.1184 DFramework.Scheduler.TaskBase /* Time Taken: 15515.7497*/ Opportunity Out Of Stock By Outlet 2025-12-20 21:11:05.6829 AlertProcessor ProcessorAlertData: started 2025-12-20 21:11:06.7610 DFramework.Database.NullableDataReader Data reader open for 215 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-20 21:11:11.3860 DFramework.Database.Query /* Time Taken: 543*/ DECLARE @TableName AnsiString(8000) SET @TableName = 'ProductStockLevel' DECLARE @CurrentRecordId Int32 SET @CurrentRecordId = '3674560' dbo.GetValidDeviceForAlertProcessData 2025-12-20 21:11:11.4642 AlertProcessor ProcessorAlertData: Stopped 2025-12-20 21:16:05.6848 AlertProcessor ProcessorAlertData: started 2025-12-20 21:16:11.0911 AlertProcessor ProcessorAlertData: Stopped 2025-12-20 21:20:59.5462 DFramework.Database.Query /* Time Taken: 1396*/ [dbo].GenerateSystemAlerts 2025-12-20 21:21:05.7025 AlertProcessor ProcessorAlertData: started 2025-12-20 21:21:07.7182 DFramework.Database.Query /* Time Taken: 807*/ 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-20 21:21:11.2182 AlertProcessor ProcessorAlertData: Stopped 2025-12-20 21:21:13.1401 DFramework.Scheduler.TaskBase /* Time Taken: 15515.734*/ Opportunity Out Of Stock By Outlet 2025-12-20 21:26:05.7203 AlertProcessor ProcessorAlertData: started 2025-12-20 21:26:06.9391 DFramework.Database.NullableDataReader Data reader open for 364 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-20 21:26:07.4860 DFramework.Database.NullableDataReader Data reader open for 305 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-20 21:26:12.1579 AlertProcessor ProcessorAlertData: Stopped 2025-12-20 21:31:05.7379 AlertProcessor ProcessorAlertData: started 2025-12-20 21:31:06.8942 DFramework.Database.NullableDataReader Data reader open for 307 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-20 21:31:07.4411 DFramework.Database.NullableDataReader Data reader open for 304 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-20 21:31:10.1286 DFramework.Database.Query /* Time Taken: 506*/ DECLARE @TableName AnsiString(8000) SET @TableName = 'OpportunityLowStock' DECLARE @CurrentRecordId Int32 SET @CurrentRecordId = '3674597' dbo.GetValidDeviceForAlertProcessData 2025-12-20 21:31:11.8005 AlertProcessor ProcessorAlertData: Stopped 2025-12-20 21:35:59.5994 DFramework.Database.Query /* Time Taken: 1423*/ [dbo].GenerateSystemAlerts 2025-12-20 21:36:05.7557 AlertProcessor ProcessorAlertData: started 2025-12-20 21:36:06.6932 DFramework.Database.Query /* Time Taken: 610*/ DECLARE @TableName AnsiString(8000) SET @TableName = 'VoidAlert' DECLARE @CurrentRecordId Int32 SET @CurrentRecordId = '3674597' dbo.GetValidDeviceForAlertProcessData 2025-12-20 21:36:11.5369 AlertProcessor ProcessorAlertData: Stopped 2025-12-20 21:36:13.2401 DFramework.Scheduler.TaskBase /* Time Taken: 15593.8631*/ Opportunity Out Of Stock By Outlet 2025-12-20 21:41:05.7734 AlertProcessor ProcessorAlertData: started 2025-12-20 21:41:07.1328 DFramework.Database.NullableDataReader Data reader open for 479 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-20 21:41:07.7109 DFramework.Database.NullableDataReader Data reader open for 384 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-20 21:41:11.7578 AlertProcessor ProcessorAlertData: Stopped 2025-12-20 21:46:05.7754 AlertProcessor ProcessorAlertData: started 2025-12-20 21:46:08.1192 DFramework.Database.Query /* Time Taken: 509*/ DECLARE @TableName AnsiString(8000) SET @TableName = 'OpportunityOutOfStockConsolidate' DECLARE @CurrentRecordId Int32 SET @CurrentRecordId = '3674617' dbo.GetValidDeviceForAlertProcessData 2025-12-20 21:46:11.3223 AlertProcessor ProcessorAlertData: Stopped 2025-12-20 21:50:59.3242 DFramework.Database.Query /* Time Taken: 1124*/ [dbo].GenerateSystemAlerts 2025-12-20 21:51:05.7773 AlertProcessor ProcessorAlertData: started 2025-12-20 21:51:11.0430 AlertProcessor ProcessorAlertData: Stopped 2025-12-20 21:51:13.2617 DFramework.Scheduler.TaskBase /* Time Taken: 15593.8588*/ Opportunity Out Of Stock By Outlet 2025-12-20 21:56:05.7950 AlertProcessor ProcessorAlertData: started 2025-12-20 21:56:11.4513 AlertProcessor ProcessorAlertData: Stopped 2025-12-20 22:01:05.8128 AlertProcessor ProcessorAlertData: started 2025-12-20 22:01:10.0941 DFramework.Database.Query /* Time Taken: 537*/ DECLARE @TableName AnsiString(8000) SET @TableName = 'AssetPlanogram' DECLARE @CurrentRecordId Int32 SET @CurrentRecordId = '3674617' dbo.GetValidDeviceForAlertProcessData 2025-12-20 22:01:11.5316 AlertProcessor ProcessorAlertData: Stopped 2025-12-20 22:05:59.2992 DFramework.Database.Query /* Time Taken: 1078*/ [dbo].GenerateSystemAlerts 2025-12-20 22:06:05.8149 AlertProcessor ProcessorAlertData: started 2025-12-20 22:06:11.1430 AlertProcessor ProcessorAlertData: Stopped 2025-12-20 22:06:13.2837 DFramework.Scheduler.TaskBase /* Time Taken: 15593.8596*/ Opportunity Out Of Stock By Outlet 2025-12-20 22:11:05.8170 AlertProcessor ProcessorAlertData: started 2025-12-20 22:11:11.0046 AlertProcessor ProcessorAlertData: Stopped 2025-12-20 22:16:05.8348 AlertProcessor ProcessorAlertData: started 2025-12-20 22:16:11.1317 AlertProcessor ProcessorAlertData: Stopped 2025-12-20 22:20:59.3057 DFramework.Database.Query /* Time Taken: 1062*/ [dbo].GenerateSystemAlerts 2025-12-20 22:21:05.8370 AlertProcessor ProcessorAlertData: started 2025-12-20 22:21:11.3058 AlertProcessor ProcessorAlertData: Stopped 2025-12-20 22:21:13.2433 DFramework.Scheduler.TaskBase /* Time Taken: 15531.3621*/ Opportunity Out Of Stock By Outlet 2025-12-20 22:26:05.8548 AlertProcessor ProcessorAlertData: started 2025-12-20 22:26:11.2142 AlertProcessor ProcessorAlertData: Stopped 2025-12-20 22:31:05.8726 AlertProcessor ProcessorAlertData: started 2025-12-20 22:31:11.2476 AlertProcessor ProcessorAlertData: Stopped 2025-12-20 22:35:59.6872 DFramework.Database.Query /* Time Taken: 1422*/ [dbo].GenerateSystemAlerts 2025-12-20 22:36:05.8748 AlertProcessor ProcessorAlertData: started 2025-12-20 22:36:11.2029 AlertProcessor ProcessorAlertData: Stopped 2025-12-20 22:36:13.3279 DFramework.Scheduler.TaskBase /* Time Taken: 15593.8571*/ Opportunity Out Of Stock By Outlet 2025-12-20 22:41:05.8769 AlertProcessor ProcessorAlertData: started 2025-12-20 22:41:11.2050 AlertProcessor ProcessorAlertData: Stopped 2025-12-20 22:46:05.8946 AlertProcessor ProcessorAlertData: started 2025-12-20 22:46:11.1603 AlertProcessor ProcessorAlertData: Stopped 2025-12-20 22:50:59.5843 DFramework.Database.Query /* Time Taken: 1305*/ [dbo].GenerateSystemAlerts 2025-12-20 22:51:05.9124 AlertProcessor ProcessorAlertData: started 2025-12-20 22:51:07.8031 DFramework.Database.Query /* Time Taken: 620*/ 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-20 22:51:11.3187 AlertProcessor ProcessorAlertData: Stopped 2025-12-20 22:51:13.2875 DFramework.Scheduler.TaskBase /* Time Taken: 15531.3626*/ Opportunity Out Of Stock By Outlet 2025-12-20 22:56:05.9302 AlertProcessor ProcessorAlertData: started 2025-12-20 22:56:11.1959 AlertProcessor ProcessorAlertData: Stopped 2025-12-20 23:01:05.9324 AlertProcessor ProcessorAlertData: started 2025-12-20 23:01:11.1512 AlertProcessor ProcessorAlertData: Stopped 2025-12-20 23:05:59.6533 DFramework.Database.Query /* Time Taken: 1355*/ [dbo].GenerateSystemAlerts 2025-12-20 23:06:05.9502 AlertProcessor ProcessorAlertData: started 2025-12-20 23:06:11.2315 AlertProcessor ProcessorAlertData: Stopped 2025-12-20 23:06:13.4034 DFramework.Scheduler.TaskBase /* Time Taken: 15625.1128*/ Opportunity Out Of Stock By Outlet 2025-12-20 23:11:05.9680 AlertProcessor ProcessorAlertData: started 2025-12-20 23:11:11.3743 AlertProcessor ProcessorAlertData: Stopped 2025-12-20 23:16:05.9703 AlertProcessor ProcessorAlertData: started 2025-12-20 23:16:11.1578 AlertProcessor ProcessorAlertData: Stopped 2025-12-20 23:20:59.3630 DFramework.Database.Query /* Time Taken: 1041*/ [dbo].GenerateSystemAlerts 2025-12-20 23:21:05.9881 AlertProcessor ProcessorAlertData: started 2025-12-20 23:21:11.2694 AlertProcessor ProcessorAlertData: Stopped 2025-12-20 23:21:13.3788 DFramework.Scheduler.TaskBase /* Time Taken: 15578.2352*/ Opportunity Out Of Stock By Outlet 2025-12-20 23:26:06.0059 AlertProcessor ProcessorAlertData: started 2025-12-20 23:26:11.2403 AlertProcessor ProcessorAlertData: Stopped 2025-12-20 23:31:06.0237 AlertProcessor ProcessorAlertData: started 2025-12-20 23:31:11.2738 AlertProcessor ProcessorAlertData: Stopped 2025-12-20 23:35:59.3852 DFramework.Database.Query /* Time Taken: 1032*/ [dbo].GenerateSystemAlerts 2025-12-20 23:36:06.0259 AlertProcessor ProcessorAlertData: started 2025-12-20 23:36:11.2916 AlertProcessor ProcessorAlertData: Stopped 2025-12-20 23:36:13.3384 DFramework.Scheduler.TaskBase /* Time Taken: 15515.7387*/ Opportunity Out Of Stock By Outlet 2025-12-20 23:41:06.0281 AlertProcessor ProcessorAlertData: started 2025-12-20 23:41:11.3250 AlertProcessor ProcessorAlertData: Stopped 2025-12-20 23:46:06.0460 AlertProcessor ProcessorAlertData: started 2025-12-20 23:46:11.3273 AlertProcessor ProcessorAlertData: Stopped 2025-12-20 23:50:59.5014 DFramework.Database.Query /* Time Taken: 1136*/ [dbo].GenerateSystemAlerts 2025-12-20 23:51:06.0640 AlertProcessor ProcessorAlertData: started 2025-12-20 23:51:11.2984 AlertProcessor ProcessorAlertData: Stopped 2025-12-20 23:51:13.3922 DFramework.Scheduler.TaskBase /* Time Taken: 15562.6218*/ Opportunity Out Of Stock By Outlet 2025-12-20 23:56:06.0818 AlertProcessor ProcessorAlertData: started 2025-12-20 23:56:11.3631 AlertProcessor ProcessorAlertData: Stopped