2025-12-22 00:01:10.0960 AlertProcessor ProcessorAlertData: started 2025-12-22 00:01:10.8616 DFramework.Database.Query /* Time Taken: 763*/ DECLARE @TableName AnsiString(8000) SET @TableName = 'TagAlert' DECLARE @CurrentRecordId Int32 SET @CurrentRecordId = '0' dbo.GetValidDeviceForAlertProcessData 2025-12-22 00:01:16.1897 AlertProcessor ProcessorAlertData: Stopped 2025-12-22 00:06:06.1447 DFramework.Database.Query /* Time Taken: 4255*/ 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-22 00:06:06.3947 DFramework.Database.Query /* Time Taken: 6248*/ [dbo].GenerateSystemAlerts 2025-12-22 00:06:10.1135 AlertProcessor ProcessorAlertData: started 2025-12-22 00:06:15.2385 DFramework.Scheduler.TaskBase /* Time Taken: 15734.4782*/ Opportunity Out Of Stock By Outlet 2025-12-22 00:06:15.5042 AlertProcessor ProcessorAlertData: Stopped 2025-12-22 00:11:10.1310 AlertProcessor ProcessorAlertData: started 2025-12-22 00:11:15.5686 AlertProcessor ProcessorAlertData: Stopped 2025-12-22 00:16:10.1483 AlertProcessor ProcessorAlertData: started 2025-12-22 00:16:11.0702 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-22 00:16:15.7421 AlertProcessor ProcessorAlertData: Stopped 2025-12-22 00:21:02.7907 DFramework.Database.Query /* Time Taken: 2618*/ [dbo].GenerateSystemAlerts 2025-12-22 00:21:10.1658 AlertProcessor ProcessorAlertData: started 2025-12-22 00:21:12.6658 DFramework.Database.Query /* Time Taken: 1359*/ 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-22 00:21:15.1814 DFramework.Scheduler.TaskBase /* Time Taken: 15656.3533*/ Opportunity Out Of Stock By Outlet 2025-12-22 00:21:15.9158 AlertProcessor ProcessorAlertData: Stopped 2025-12-22 00:26:10.1833 AlertProcessor ProcessorAlertData: started 2025-12-22 00:26:10.7146 DFramework.Database.Query /* Time Taken: 518*/ DECLARE @TableName AnsiString(8000) SET @TableName = 'TagAlert' DECLARE @CurrentRecordId Int32 SET @CurrentRecordId = '0' dbo.GetValidDeviceForAlertProcessData 2025-12-22 00:26:15.6990 AlertProcessor ProcessorAlertData: Stopped 2025-12-22 00:31:10.2008 AlertProcessor ProcessorAlertData: started 2025-12-22 00:31:11.4352 DFramework.Database.NullableDataReader Data reader open for 338 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-22 00:31:12.1227 DFramework.Database.NullableDataReader Data reader open for 345 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-22 00:31:16.2946 AlertProcessor ProcessorAlertData: Stopped 2025-12-22 00:36:02.3901 MoveToReorder Running task for ClientId : 286 and ClientName = India Office QA and Slot: 12/22/2025 2:00:00 PM And LastExecutedOn: 12/22/2025 1:06:02 PM 2025-12-22 00:36:02.7651 DFramework.Database.Query /* Time Taken: 2565*/ [dbo].GenerateSystemAlerts 2025-12-22 00:36:10.2027 AlertProcessor ProcessorAlertData: started 2025-12-22 00:36:15.2965 DFramework.Scheduler.TaskBase /* Time Taken: 15750.0994*/ Opportunity Out Of Stock By Outlet 2025-12-22 00:36:15.6402 AlertProcessor ProcessorAlertData: Stopped 2025-12-22 00:36:43.6404 DFramework.Database.NullableDataReader Data reader open for 40786 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-22 00:36:43.6717 MoveToReorder Task executed successfully for ClientId : 286 Client Name:India Office QA, Slot: 12/22/2025 2:00:00 PM and Total Order Suggested: 123 Out Of: 123 2025-12-22 00:36:44.4217 DFramework.Scheduler.TaskBase /* Time Taken: 42484.6429*/ Move To Re-Order 2025-12-22 00:41:10.2203 AlertProcessor ProcessorAlertData: started 2025-12-22 00:41:15.5796 AlertProcessor ProcessorAlertData: Stopped 2025-12-22 00:46:10.2378 AlertProcessor ProcessorAlertData: started 2025-12-22 00:46:15.3941 DFramework.Database.NullableDataReader Data reader open for 262 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 251 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-22 00:46:16.0972 AlertProcessor ProcessorAlertData: Stopped 2025-12-22 00:51:03.0519 DFramework.Database.Query /* Time Taken: 2852*/ [dbo].GenerateSystemAlerts 2025-12-22 00:51:10.2551 AlertProcessor ProcessorAlertData: started 2025-12-22 00:51:15.1770 DFramework.Scheduler.TaskBase /* Time Taken: 15609.47*/ Opportunity Out Of Stock By Outlet 2025-12-22 00:51:15.8332 DFramework.Database.Query /* Time Taken: 504*/ DECLARE @TableName AnsiString(8000) SET @TableName = 'TargetPortfolioComplianceConsolidate' DECLARE @CurrentRecordId Int32 SET @CurrentRecordId = '3674785' dbo.GetValidDeviceForAlertProcessData 2025-12-22 00:51:16.4426 AlertProcessor ProcessorAlertData: Stopped 2025-12-22 00:56:10.2726 AlertProcessor ProcessorAlertData: started 2025-12-22 00:56:12.0694 DFramework.Database.Query /* Time Taken: 604*/ DECLARE @TableName AnsiString(8000) SET @TableName = 'OpportunityOutOfStock' DECLARE @CurrentRecordId Int32 SET @CurrentRecordId = '3674785' dbo.GetValidDeviceForAlertProcessData 2025-12-22 00:56:15.9913 AlertProcessor ProcessorAlertData: Stopped 2025-12-22 01:01:10.2901 AlertProcessor ProcessorAlertData: started 2025-12-22 01:01:13.0870 DFramework.Database.Query /* Time Taken: 577*/ DECLARE @TableName AnsiString(8000) SET @TableName = 'AssetStockProductWiseConsolidate' DECLARE @CurrentRecordId Int32 SET @CurrentRecordId = '3674791' dbo.GetValidDeviceForAlertProcessData 2025-12-22 01:01:16.0870 AlertProcessor ProcessorAlertData: Stopped 2025-12-22 01:06:03.8700 DFramework.Database.Query /* Time Taken: 3640*/ [dbo].GenerateSystemAlerts 2025-12-22 01:06:10.3075 AlertProcessor ProcessorAlertData: started 2025-12-22 01:06:12.9638 DFramework.Database.Query /* Time Taken: 945*/ DECLARE @TableName AnsiString(8000) SET @TableName = 'PlanogramComplianceConsolidate' DECLARE @CurrentRecordId Int32 SET @CurrentRecordId = '3674791' dbo.GetValidDeviceForAlertProcessData 2025-12-22 01:06:15.2294 DFramework.Scheduler.TaskBase /* Time Taken: 15640.7159*/ Opportunity Out Of Stock By Outlet 2025-12-22 01:06:16.5419 AlertProcessor ProcessorAlertData: Stopped 2025-12-22 01:11:10.3250 AlertProcessor ProcessorAlertData: started 2025-12-22 01:11:15.7000 AlertProcessor ProcessorAlertData: Stopped 2025-12-22 01:16:10.3425 AlertProcessor ProcessorAlertData: started 2025-12-22 01:16:15.6707 AlertProcessor ProcessorAlertData: Stopped 2025-12-22 01:21:01.3912 DFramework.Database.Query /* Time Taken: 1145*/ [dbo].GenerateSystemAlerts 2025-12-22 01:21:10.3601 AlertProcessor ProcessorAlertData: started 2025-12-22 01:21:15.2976 DFramework.Scheduler.TaskBase /* Time Taken: 15703.2204*/ Opportunity Out Of Stock By Outlet 2025-12-22 01:21:15.8601 AlertProcessor ProcessorAlertData: Stopped 2025-12-22 01:26:10.3775 AlertProcessor ProcessorAlertData: started 2025-12-22 01:26:15.9713 AlertProcessor ProcessorAlertData: Stopped 2025-12-22 01:31:10.3951 AlertProcessor ProcessorAlertData: started 2025-12-22 01:31:18.1451 DFramework.Database.Query /* Time Taken: 529*/ DECLARE @TableName AnsiString(8000) SET @TableName = 'ProductStockLevel' DECLARE @CurrentRecordId Int32 SET @CurrentRecordId = '3674791' dbo.GetValidDeviceForAlertProcessData 2025-12-22 01:31:18.2233 AlertProcessor ProcessorAlertData: Stopped 2025-12-22 01:36:01.3657 DFramework.Database.Query /* Time Taken: 1105*/ [dbo].GenerateSystemAlerts 2025-12-22 01:36:02.4126 MoveToReorder Running task for ClientId : 286 and ClientName = India Office QA and Slot: 12/22/2025 3:00:00 PM And LastExecutedOn: 12/22/2025 2:06:02 PM 2025-12-22 01:36:02.6782 MoveToReorder Task executed successfully for ClientId : 286 Client Name:India Office QA, Slot: 12/22/2025 3:00:00 PM But No Order found to suggest 2025-12-22 01:36:10.4126 AlertProcessor ProcessorAlertData: started 2025-12-22 01:36:15.2095 DFramework.Scheduler.TaskBase /* Time Taken: 15593.8462*/ Opportunity Out Of Stock By Outlet 2025-12-22 01:36:15.8345 AlertProcessor ProcessorAlertData: Stopped 2025-12-22 01:41:10.4301 AlertProcessor ProcessorAlertData: started 2025-12-22 01:41:15.6957 AlertProcessor ProcessorAlertData: Stopped 2025-12-22 01:46:10.4319 AlertProcessor ProcessorAlertData: started 2025-12-22 01:46:15.7289 AlertProcessor ProcessorAlertData: Stopped 2025-12-22 01:51:01.6057 DFramework.Database.Query /* Time Taken: 1339*/ [dbo].GenerateSystemAlerts 2025-12-22 01:51:10.4339 AlertProcessor ProcessorAlertData: started 2025-12-22 01:51:12.1370 DFramework.Database.Query /* Time Taken: 511*/ DECLARE @TableName AnsiString(8000) SET @TableName = 'OpportunityOutOfStock' DECLARE @CurrentRecordId Int32 SET @CurrentRecordId = '3674791' dbo.GetValidDeviceForAlertProcessData 2025-12-22 01:51:12.9651 DFramework.Database.Query /* Time Taken: 1411*/ 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-22 01:51:15.2308 DFramework.Scheduler.TaskBase /* Time Taken: 15593.8446*/ Opportunity Out Of Stock By Outlet 2025-12-22 01:51:16.2464 AlertProcessor ProcessorAlertData: Stopped 2025-12-22 01:56:10.4516 AlertProcessor ProcessorAlertData: started 2025-12-22 01:56:15.9204 AlertProcessor ProcessorAlertData: Stopped 2025-12-22 02:01:10.4694 AlertProcessor ProcessorAlertData: started 2025-12-22 02:01:15.8444 AlertProcessor ProcessorAlertData: Stopped 2025-12-22 02:06:01.6431 DFramework.Database.Query /* Time Taken: 1365*/ [dbo].GenerateSystemAlerts 2025-12-22 02:06:10.4870 AlertProcessor ProcessorAlertData: started 2025-12-22 02:06:15.2526 DFramework.Scheduler.TaskBase /* Time Taken: 15593.8498*/ Opportunity Out Of Stock By Outlet 2025-12-22 02:06:16.1901 AlertProcessor ProcessorAlertData: Stopped 2025-12-22 02:11:10.5045 AlertProcessor ProcessorAlertData: started 2025-12-22 02:11:16.0046 AlertProcessor ProcessorAlertData: Stopped 2025-12-22 02:16:10.5227 AlertProcessor ProcessorAlertData: started 2025-12-22 02:16:12.5696 DFramework.Database.Query /* Time Taken: 561*/ DECLARE @TableName AnsiString(8000) SET @TableName = 'PlanogramComplianceConsolidate' DECLARE @CurrentRecordId Int32 SET @CurrentRecordId = '3674791' dbo.GetValidDeviceForAlertProcessData 2025-12-22 02:16:16.0852 AlertProcessor ProcessorAlertData: Stopped 2025-12-22 02:21:01.3841 DFramework.Database.Query /* Time Taken: 1090*/ [dbo].GenerateSystemAlerts 2025-12-22 02:21:10.5405 AlertProcessor ProcessorAlertData: started 2025-12-22 02:21:13.9155 DFramework.Database.Query /* Time Taken: 543*/ DECLARE @TableName AnsiString(8000) SET @TableName = 'AssetStock' DECLARE @CurrentRecordId Int32 SET @CurrentRecordId = '3674791' dbo.GetValidDeviceForAlertProcessData 2025-12-22 02:21:15.2436 DFramework.Scheduler.TaskBase /* Time Taken: 15562.6038*/ Opportunity Out Of Stock By Outlet 2025-12-22 02:21:16.2280 AlertProcessor ProcessorAlertData: Stopped 2025-12-22 02:26:10.5580 AlertProcessor ProcessorAlertData: started 2025-12-22 02:26:15.9175 AlertProcessor ProcessorAlertData: Stopped 2025-12-22 02:31:10.5761 AlertProcessor ProcessorAlertData: started 2025-12-22 02:31:15.9512 AlertProcessor ProcessorAlertData: Stopped 2025-12-22 02:36:01.5003 DFramework.Database.Query /* Time Taken: 1172*/ [dbo].GenerateSystemAlerts 2025-12-22 02:36:02.4378 MoveToReorder Running task for ClientId : 286 and ClientName = India Office QA and Slot: 12/22/2025 4:00:00 PM And LastExecutedOn: 12/22/2025 3:06:02 PM 2025-12-22 02:36:02.6097 MoveToReorder Task executed successfully for ClientId : 286 Client Name:India Office QA, Slot: 12/22/2025 4:00:00 PM But No Order found to suggest 2025-12-22 02:36:10.5785 AlertProcessor ProcessorAlertData: started 2025-12-22 02:36:15.2972 DFramework.Scheduler.TaskBase /* Time Taken: 15593.8589*/ Opportunity Out Of Stock By Outlet 2025-12-22 02:36:15.9848 DFramework.Database.Query /* Time Taken: 534*/ DECLARE @TableName AnsiString(8000) SET @TableName = 'TargetPortfolioComplianceConsolidate' DECLARE @CurrentRecordId Int32 SET @CurrentRecordId = '3674791' dbo.GetValidDeviceForAlertProcessData 2025-12-22 02:36:16.3910 AlertProcessor ProcessorAlertData: Stopped 2025-12-22 02:41:10.5961 AlertProcessor ProcessorAlertData: started 2025-12-22 02:41:16.0024 AlertProcessor ProcessorAlertData: Stopped 2025-12-22 02:46:10.6138 AlertProcessor ProcessorAlertData: started 2025-12-22 02:46:12.9732 DFramework.Database.Query /* Time Taken: 560*/ DECLARE @TableName AnsiString(8000) SET @TableName = 'OpportunityOutOfStockConsolidate' DECLARE @CurrentRecordId Int32 SET @CurrentRecordId = '3674791' dbo.GetValidDeviceForAlertProcessData 2025-12-22 02:46:16.1920 AlertProcessor ProcessorAlertData: Stopped 2025-12-22 02:51:01.4601 DFramework.Database.Query /* Time Taken: 1133*/ [dbo].GenerateSystemAlerts 2025-12-22 02:51:10.6320 AlertProcessor ProcessorAlertData: started 2025-12-22 02:51:14.5852 DFramework.Database.Query /* Time Taken: 509*/ DECLARE @TableName AnsiString(8000) SET @TableName = 'AssetPurity' DECLARE @CurrentRecordId Int32 SET @CurrentRecordId = '3674791' dbo.GetValidDeviceForAlertProcessData 2025-12-22 02:51:15.3039 DFramework.Scheduler.TaskBase /* Time Taken: 15593.8617*/ Opportunity Out Of Stock By Outlet 2025-12-22 02:51:16.6321 AlertProcessor ProcessorAlertData: Stopped 2025-12-22 02:56:10.6498 AlertProcessor ProcessorAlertData: started 2025-12-22 02:56:11.3060 DFramework.Database.Query /* Time Taken: 669*/ DECLARE @TableName AnsiString(8000) SET @TableName = 'TagAlert' DECLARE @CurrentRecordId Int32 SET @CurrentRecordId = '0' dbo.GetValidDeviceForAlertProcessData 2025-12-22 02:56:11.9466 DFramework.Database.Query /* Time Taken: 570*/ DECLARE @TableName AnsiString(8000) SET @TableName = 'VoidAlert' DECLARE @CurrentRecordId Int32 SET @CurrentRecordId = '3674791' dbo.GetValidDeviceForAlertProcessData 2025-12-22 02:56:16.8529 AlertProcessor ProcessorAlertData: Stopped 2025-12-22 03:01:10.6674 AlertProcessor ProcessorAlertData: started 2025-12-22 03:01:16.0736 AlertProcessor ProcessorAlertData: Stopped 2025-12-22 03:06:03.8571 DFramework.Database.Query /* Time Taken: 3518*/ [dbo].GenerateSystemAlerts 2025-12-22 03:06:10.6852 AlertProcessor ProcessorAlertData: started 2025-12-22 03:06:15.4040 DFramework.Scheduler.TaskBase /* Time Taken: 15671.9905*/ Opportunity Out Of Stock By Outlet 2025-12-22 03:06:16.1228 AlertProcessor ProcessorAlertData: Stopped 2025-12-22 03:11:10.7029 AlertProcessor ProcessorAlertData: started 2025-12-22 03:11:11.5779 DFramework.Database.Query /* Time Taken: 874*/ DECLARE @TableName AnsiString(8000) SET @TableName = 'TagAlert' DECLARE @CurrentRecordId Int32 SET @CurrentRecordId = '0' dbo.GetValidDeviceForAlertProcessData 2025-12-22 03:11:12.2967 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-22 03:11:12.6405 DFramework.Database.Query /* Time Taken: 604*/ DECLARE @TableName AnsiString(8000) SET @TableName = 'MissingShelf' DECLARE @CurrentRecordId Int32 SET @CurrentRecordId = '3674791' dbo.GetValidDeviceForAlertProcessData 2025-12-22 03:11:14.5936 DFramework.Database.Query /* Time Taken: 698*/ DECLARE @TableName AnsiString(8000) SET @TableName = 'AssetStockProductWiseConsolidate' DECLARE @CurrentRecordId Int32 SET @CurrentRecordId = '3674791' dbo.GetValidDeviceForAlertProcessData 2025-12-22 03:11:17.4842 AlertProcessor ProcessorAlertData: Stopped 2025-12-22 03:16:10.7206 AlertProcessor ProcessorAlertData: started 2025-12-22 03:16:14.2987 DFramework.Database.Query /* Time Taken: 555*/ DECLARE @TableName AnsiString(8000) SET @TableName = 'AssetStockProductWiseConsolidate' DECLARE @CurrentRecordId Int32 SET @CurrentRecordId = '3674791' dbo.GetValidDeviceForAlertProcessData 2025-12-22 03:16:18.1112 DFramework.Database.Query /* Time Taken: 561*/ DECLARE @TableName AnsiString(8000) SET @TableName = 'ProductStockLevel' DECLARE @CurrentRecordId Int32 SET @CurrentRecordId = '3674791' dbo.GetValidDeviceForAlertProcessData 2025-12-22 03:16:18.1581 AlertProcessor ProcessorAlertData: Stopped 2025-12-22 03:21:04.9726 DFramework.Database.Query /* Time Taken: 4608*/ [dbo].GenerateSystemAlerts 2025-12-22 03:21:10.7227 AlertProcessor ProcessorAlertData: started 2025-12-22 03:21:12.5196 DFramework.Database.Query /* Time Taken: 600*/ DECLARE @TableName AnsiString(8000) SET @TableName = 'OpportunityOutOfStock' DECLARE @CurrentRecordId Int32 SET @CurrentRecordId = '3674791' dbo.GetValidDeviceForAlertProcessData 2025-12-22 03:21:13.0821 DFramework.Database.Query /* Time Taken: 1287*/ 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-22 03:21:15.6446 DFramework.Scheduler.TaskBase /* Time Taken: 15906.3929*/ Opportunity Out Of Stock By Outlet 2025-12-22 03:21:16.5665 AlertProcessor ProcessorAlertData: Stopped 2025-12-22 03:26:10.7249 AlertProcessor ProcessorAlertData: started 2025-12-22 03:26:16.5531 AlertProcessor ProcessorAlertData: Stopped 2025-12-22 03:31:10.7270 AlertProcessor ProcessorAlertData: started 2025-12-22 03:31:15.1176 DFramework.Database.Query /* Time Taken: 506*/ DECLARE @TableName AnsiString(8000) SET @TableName = 'AssetPlanogram' DECLARE @CurrentRecordId Int32 SET @CurrentRecordId = '3674791' dbo.GetValidDeviceForAlertProcessData 2025-12-22 03:31:16.4614 AlertProcessor ProcessorAlertData: Stopped 2025-12-22 03:36:02.2289 DFramework.Database.Query /* Time Taken: 1846*/ [dbo].GenerateSystemAlerts 2025-12-22 03:36:02.5570 MoveToReorder Running task for ClientId : 286 and ClientName = India Office QA and Slot: 12/22/2025 5:00:00 PM And LastExecutedOn: 12/22/2025 4:06:02 PM 2025-12-22 03:36:10.7446 AlertProcessor ProcessorAlertData: started 2025-12-22 03:36:10.7446 DFramework.Database.Query /* Time Taken: 539*/ DECLARE @ClientId Int32 SET @ClientId = '1494' DECLARE @MarketId Int32 SET @MarketId = '0' DECLARE @ClassificationId Int32 SET @ClassificationId = '0' DECLARE @LocationId Int32 SET @LocationId = '0' DECLARE @LocationTypeId Int32 SET @LocationTypeId = '0' DECLARE @StartDate DateTime2 SET @StartDate = '6/14/2025 12:00:00 AM' dbo.GetOpportunityOutOfStockDataByOutlet 2025-12-22 03:36:13.7446 DFramework.Database.Query /* Time Taken: 757*/ DECLARE @TableName AnsiString(8000) SET @TableName = 'AssetStockProductWiseConsolidate' DECLARE @CurrentRecordId Int32 SET @CurrentRecordId = '3674791' dbo.GetValidDeviceForAlertProcessData 2025-12-22 03:36:15.9008 DFramework.Scheduler.TaskBase /* Time Taken: 16140.7347*/ Opportunity Out Of Stock By Outlet 2025-12-22 03:36:16.6977 AlertProcessor ProcessorAlertData: Stopped 2025-12-22 03:36:43.5104 DFramework.Database.NullableDataReader Data reader open for 40498 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-22 03:36:43.5416 MoveToReorder Task executed successfully for ClientId : 286 Client Name:India Office QA, Slot: 12/22/2025 5:00:00 PM and Total Order Suggested: 123 Out Of: 123 2025-12-22 03:36:44.1198 DFramework.Database.Query /* Time Taken: 579*/ DECLARE @ClientId Int32 SET @ClientId = '286' dbo.GetMoveToReOrderList 2025-12-22 03:36:44.9166 DFramework.Database.Query /* Time Taken: 502*/ DECLARE @ClientId Int32 SET @ClientId = '286' DECLARE @OrderStatusId Int32 SET @OrderStatusId = '5485' SELECT * FROM vwScheduledOrderExportInfoList WHERE [ClientId] = @ClientId AND [OrderStatusId] = @OrderStatusId ORDER BY [LocationId] 2025-12-22 03:36:45.1510 DFramework.Scheduler.TaskBase /* Time Taken: 42906.5234*/ Move To Re-Order 2025-12-22 03:41:10.7468 AlertProcessor ProcessorAlertData: started 2025-12-22 03:41:16.1531 AlertProcessor ProcessorAlertData: Stopped 2025-12-22 03:46:10.7489 AlertProcessor ProcessorAlertData: started 2025-12-22 03:46:16.4677 AlertProcessor ProcessorAlertData: Stopped 2025-12-22 03:51:03.2821 DFramework.Database.Query /* Time Taken: 2882*/ [dbo].GenerateSystemAlerts 2025-12-22 03:51:10.7665 AlertProcessor ProcessorAlertData: started 2025-12-22 03:51:15.5790 DFramework.Scheduler.TaskBase /* Time Taken: 15796.9792*/ Opportunity Out Of Stock By Outlet 2025-12-22 03:51:16.0165 AlertProcessor ProcessorAlertData: Stopped 2025-12-22 03:56:10.7844 AlertProcessor ProcessorAlertData: started 2025-12-22 03:56:16.2219 AlertProcessor ProcessorAlertData: Stopped 2025-12-22 04:01:10.7865 AlertProcessor ProcessorAlertData: started 2025-12-22 04:01:15.8803 AlertProcessor ProcessorAlertData: Stopped 2025-12-22 04:06:02.8978 DFramework.Database.Query /* Time Taken: 2479*/ [dbo].GenerateSystemAlerts 2025-12-22 04:06:10.8041 AlertProcessor ProcessorAlertData: started 2025-12-22 04:06:10.8666 DFramework.Database.Query /* Time Taken: 662*/ DECLARE @ClientId Int32 SET @ClientId = '1494' DECLARE @MarketId Int32 SET @MarketId = '0' DECLARE @ClassificationId Int32 SET @ClassificationId = '0' DECLARE @LocationId Int32 SET @LocationId = '0' DECLARE @LocationTypeId Int32 SET @LocationTypeId = '0' DECLARE @StartDate DateTime2 SET @StartDate = '6/14/2025 12:00:00 AM' dbo.GetOpportunityOutOfStockDataByOutlet 2025-12-22 04:06:16.0073 DFramework.Scheduler.TaskBase /* Time Taken: 16203.2245*/ Opportunity Out Of Stock By Outlet 2025-12-22 04:06:16.4760 AlertProcessor ProcessorAlertData: Stopped 2025-12-22 04:11:10.8218 AlertProcessor ProcessorAlertData: started 2025-12-22 04:11:15.9156 AlertProcessor ProcessorAlertData: Stopped 2025-12-22 04:16:10.8398 AlertProcessor ProcessorAlertData: started 2025-12-22 04:16:16.1211 AlertProcessor ProcessorAlertData: Stopped 2025-12-22 04:21:01.6387 DFramework.Database.Query /* Time Taken: 1197*/ [dbo].GenerateSystemAlerts 2025-12-22 04:21:10.8575 AlertProcessor ProcessorAlertData: started 2025-12-22 04:21:15.4513 DFramework.Scheduler.TaskBase /* Time Taken: 15625.1017*/ Opportunity Out Of Stock By Outlet 2025-12-22 04:21:16.2169 DFramework.Database.NullableDataReader Data reader open for 282 at System.Environment.GetStackTrace(Exception e, Boolean needFileInfo) at System.Environment.get_StackTrace() at DFramework.Database.NullableDataReader.Dispose(Boolean disposing) in D:\Spraxa\Framework\DFramework\Database\NullableDataReader.cs:line 33 at DFramework.Database.NullableDataReader.Dispose() in D:\Spraxa\Framework\DFramework\Database\NullableDataReader.cs:line 44 at CoolR.Tasks.ProcessAlertData.Execute() in D:\Spraxa\CoolR-Group\portal\CoolR.Tasks\ProcessAlertData.cs:line 47 at DFramework.Scheduler.TaskBase.Run() in D:\Spraxa\Framework\DFramework.Scheduler\TaskBase.cs:line 176 at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx) at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx) at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state) at System.Threading.ThreadHelper.ThreadStart() 2025-12-22 04:21:16.5607 AlertProcessor ProcessorAlertData: Stopped 2025-12-22 04:26:10.8751 AlertProcessor ProcessorAlertData: started 2025-12-22 04:26:16.5626 AlertProcessor ProcessorAlertData: Stopped 2025-12-22 04:31:10.8773 AlertProcessor ProcessorAlertData: started 2025-12-22 04:31:14.5648 DFramework.Database.Query /* Time Taken: 561*/ DECLARE @TableName AnsiString(8000) SET @TableName = 'AssetPurity' DECLARE @CurrentRecordId Int32 SET @CurrentRecordId = '3674791' dbo.GetValidDeviceForAlertProcessData 2025-12-22 04:31:16.4867 AlertProcessor ProcessorAlertData: Stopped 2025-12-22 04:36:04.1136 DFramework.Database.Query /* Time Taken: 1544*/ DECLARE @OrderStatusId Int32 SET @OrderStatusId = '5485' 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.HoursToMoveScheduled > 0 WHERE DATEADD(HOUR, Client.HoursToMoveScheduled, ScheduledOrder.ModifiedOn) < GETUTCDATE() AND ScheduledOrder.StatusId = @OrderStatusId ANd Location.IsDeleted = 0 AND ScheduledOrder.IsDeleted = 0 2025-12-22 04:36:04.3011 DFramework.Database.Query /* Time Taken: 3833*/ [dbo].GenerateSystemAlerts 2025-12-22 04:36:10.8793 AlertProcessor ProcessorAlertData: started 2025-12-22 04:36:11.7387 DFramework.Database.Query /* Time Taken: 851*/ DECLARE @TableName AnsiString(8000) SET @TableName = 'TagAlert' DECLARE @CurrentRecordId Int32 SET @CurrentRecordId = '0' dbo.GetValidDeviceForAlertProcessData 2025-12-22 04:36:16.0200 DFramework.Scheduler.TaskBase /* Time Taken: 16171.9604*/ Opportunity Out Of Stock By Outlet 2025-12-22 04:36:17.0981 AlertProcessor ProcessorAlertData: Stopped 2025-12-22 04:41:10.8969 AlertProcessor ProcessorAlertData: started 2025-12-22 04:41:11.3969 DFramework.Database.Query /* Time Taken: 502*/ DECLARE @TableName AnsiString(8000) SET @TableName = 'TagAlert' DECLARE @CurrentRecordId Int32 SET @CurrentRecordId = '0' dbo.GetValidDeviceForAlertProcessData 2025-12-22 04:41:16.8813 AlertProcessor ProcessorAlertData: Stopped 2025-12-22 04:46:02.6958 MoveToReorder Running task for ClientId : 286 and ClientName = India Office QA and Slot: 12/22/2025 6:00:00 PM And LastExecutedOn: 12/22/2025 5:06:02 PM 2025-12-22 04:46:03.1021 DFramework.Database.NullableDataReader Data reader open for 201 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-22 04:46:03.1333 MoveToReorder Task executed successfully for ClientId : 286 Client Name:India Office QA, Slot: 12/22/2025 6:00:00 PM and Total Order Suggested: 1 Out Of: 1 2025-12-22 04:46:10.9146 AlertProcessor ProcessorAlertData: started 2025-12-22 04:46:16.3209 AlertProcessor ProcessorAlertData: Stopped 2025-12-22 04:51:02.6355 DFramework.Database.Query /* Time Taken: 2164*/ [dbo].GenerateSystemAlerts 2025-12-22 04:51:10.9324 AlertProcessor ProcessorAlertData: started 2025-12-22 04:51:13.4325 DFramework.Database.Query /* Time Taken: 1336*/ 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-22 04:51:15.6512 DFramework.Scheduler.TaskBase /* Time Taken: 15781.3509*/ Opportunity Out Of Stock By Outlet 2025-12-22 04:51:16.0106 AlertProcessor ProcessorAlertData: Stopped 2025-12-22 04:56:10.9345 AlertProcessor ProcessorAlertData: started 2025-12-22 04:56:16.1845 AlertProcessor ProcessorAlertData: Stopped 2025-12-22 05:01:10.9520 AlertProcessor ProcessorAlertData: started 2025-12-22 05:01:15.9208 AlertProcessor ProcessorAlertData: Stopped 2025-12-22 05:06:03.8772 DFramework.Database.Query /* Time Taken: 3400*/ [dbo].GenerateSystemAlerts 2025-12-22 05:06:10.9710 AlertProcessor ProcessorAlertData: started 2025-12-22 05:06:13.6116 DFramework.Database.Query /* Time Taken: 574*/ DECLARE @TableName AnsiString(8000) SET @TableName = 'AssetStockProductWiseConsolidate' DECLARE @CurrentRecordId Int32 SET @CurrentRecordId = '3674826' dbo.GetValidDeviceForAlertProcessData 2025-12-22 05:06:15.5491 DFramework.Scheduler.TaskBase /* Time Taken: 15656.4008*/ Opportunity Out Of Stock By Outlet 2025-12-22 05:06:16.2680 AlertProcessor ProcessorAlertData: Stopped 2025-12-22 05:11:10.9891 AlertProcessor ProcessorAlertData: started 2025-12-22 05:11:16.2236 AlertProcessor ProcessorAlertData: Stopped 2025-12-22 05:16:10.9913 AlertProcessor ProcessorAlertData: started 2025-12-22 05:16:16.3038 AlertProcessor ProcessorAlertData: Stopped 2025-12-22 05:21:01.7898 DFramework.Database.Query /* Time Taken: 1281*/ [dbo].GenerateSystemAlerts 2025-12-22 05:21:11.0086 AlertProcessor ProcessorAlertData: started 2025-12-22 05:21:15.6336 DFramework.Scheduler.TaskBase /* Time Taken: 15718.8386*/ Opportunity Out Of Stock By Outlet 2025-12-22 05:21:16.3836 AlertProcessor ProcessorAlertData: Stopped 2025-12-22 05:26:11.0259 AlertProcessor ProcessorAlertData: started 2025-12-22 05:26:12.4478 DFramework.Database.Query /* Time Taken: 906*/ DECLARE @TableName AnsiString(8000) SET @TableName = 'VoidAlert' DECLARE @CurrentRecordId Int32 SET @CurrentRecordId = '3674826' dbo.GetValidDeviceForAlertProcessData 2025-12-22 05:26:14.1665 DFramework.Database.Query /* Time Taken: 555*/ DECLARE @TableName AnsiString(8000) SET @TableName = 'PlanogramComplianceConsolidate' DECLARE @CurrentRecordId Int32 SET @CurrentRecordId = '3674826' dbo.GetValidDeviceForAlertProcessData 2025-12-22 05:26:14.7447 DFramework.Database.Query /* Time Taken: 529*/ DECLARE @TableName AnsiString(8000) SET @TableName = 'OpportunityOutOfStockConsolidate' DECLARE @CurrentRecordId Int32 SET @CurrentRecordId = '3674826' dbo.GetValidDeviceForAlertProcessData 2025-12-22 05:26:15.3384 DFramework.Database.Query /* Time Taken: 554*/ DECLARE @TableName AnsiString(8000) SET @TableName = 'AssetStockProductWiseConsolidate' DECLARE @CurrentRecordId Int32 SET @CurrentRecordId = '3674826' dbo.GetValidDeviceForAlertProcessData 2025-12-22 05:26:19.2916 AlertProcessor ProcessorAlertData: Stopped 2025-12-22 05:31:11.0434 AlertProcessor ProcessorAlertData: started 2025-12-22 05:31:16.6528 AlertProcessor ProcessorAlertData: Stopped 2025-12-22 05:36:01.9359 DFramework.Database.Query /* Time Taken: 1419*/ [dbo].GenerateSystemAlerts 2025-12-22 05:36:02.8734 MoveToReorder Running task for ClientId : 286 and ClientName = India Office QA and Slot: 12/22/2025 7:00:00 PM And LastExecutedOn: 12/22/2025 6:16:02 PM 2025-12-22 05:36:03.1234 MoveToReorder Task executed successfully for ClientId : 286 Client Name:India Office QA, Slot: 12/22/2025 7:00:00 PM But No Order found to suggest 2025-12-22 05:36:11.0610 AlertProcessor ProcessorAlertData: started 2025-12-22 05:36:15.5297 DFramework.Scheduler.TaskBase /* Time Taken: 15593.8499*/ Opportunity Out Of Stock By Outlet 2025-12-22 05:36:16.4673 AlertProcessor ProcessorAlertData: Stopped 2025-12-22 05:41:11.0765 AlertProcessor ProcessorAlertData: started 2025-12-22 05:41:16.5765 AlertProcessor ProcessorAlertData: Stopped 2025-12-22 05:46:11.0934 AlertProcessor ProcessorAlertData: started 2025-12-22 05:46:16.4841 DFramework.Database.Query /* Time Taken: 527*/ DECLARE @TableName AnsiString(8000) SET @TableName = 'TargetPortfolioComplianceConsolidate' DECLARE @CurrentRecordId Int32 SET @CurrentRecordId = '3674829' dbo.GetValidDeviceForAlertProcessData 2025-12-22 05:46:16.8747 AlertProcessor ProcessorAlertData: Stopped 2025-12-22 05:51:02.7670 DFramework.Database.Query /* Time Taken: 2224*/ [dbo].GenerateSystemAlerts 2025-12-22 05:51:11.1108 AlertProcessor ProcessorAlertData: started 2025-12-22 05:51:15.7514 DFramework.Scheduler.TaskBase /* Time Taken: 15796.9752*/ Opportunity Out Of Stock By Outlet 2025-12-22 05:51:16.5327 AlertProcessor ProcessorAlertData: Stopped 2025-12-22 05:56:11.1301 AlertProcessor ProcessorAlertData: started 2025-12-22 05:56:16.5051 AlertProcessor ProcessorAlertData: Stopped 2025-12-22 06:01:11.1489 AlertProcessor ProcessorAlertData: started 2025-12-22 06:01:15.2114 DFramework.Database.Query /* Time Taken: 638*/ DECLARE @TableName AnsiString(8000) SET @TableName = 'OpportunityLowStock' DECLARE @CurrentRecordId Int32 SET @CurrentRecordId = '3674829' dbo.GetValidDeviceForAlertProcessData 2025-12-22 06:01:16.9302 AlertProcessor ProcessorAlertData: Stopped 2025-12-22 06:06:03.1512 DFramework.Database.Query /* Time Taken: 2591*/ [dbo].GenerateSystemAlerts 2025-12-22 06:06:11.1668 AlertProcessor ProcessorAlertData: started 2025-12-22 06:06:11.8075 DFramework.Database.Query /* Time Taken: 647*/ DECLARE @TableName AnsiString(8000) SET @TableName = 'TagAlert' DECLARE @CurrentRecordId Int32 SET @CurrentRecordId = '0' dbo.GetValidDeviceForAlertProcessData 2025-12-22 06:06:16.0106 DFramework.Scheduler.TaskBase /* Time Taken: 16046.9871*/ Opportunity Out Of Stock By Outlet 2025-12-22 06:06:16.8544 AlertProcessor ProcessorAlertData: Stopped 2025-12-22 06:11:11.1847 AlertProcessor ProcessorAlertData: started 2025-12-22 06:11:16.5754 AlertProcessor ProcessorAlertData: Stopped 2025-12-22 06:16:11.1872 AlertProcessor ProcessorAlertData: started 2025-12-22 06:16:16.6091 AlertProcessor ProcessorAlertData: Stopped 2025-12-22 06:21:03.8143 DFramework.Database.Query /* Time Taken: 3227*/ [dbo].GenerateSystemAlerts 2025-12-22 06:21:11.1893 AlertProcessor ProcessorAlertData: started 2025-12-22 06:21:12.3456 DFramework.Database.Query /* Time Taken: 1166*/ DECLARE @TableName AnsiString(8000) SET @TableName = 'TagAlert' DECLARE @CurrentRecordId Int32 SET @CurrentRecordId = '0' dbo.GetValidDeviceForAlertProcessData 2025-12-22 06:21:13.7831 DFramework.Database.Query /* Time Taken: 1362*/ 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-22 06:21:16.0800 DFramework.Scheduler.TaskBase /* Time Taken: 16109.4876*/ Opportunity Out Of Stock By Outlet 2025-12-22 06:21:17.0956 DFramework.Database.Query /* Time Taken: 570*/ DECLARE @TableName AnsiString(8000) SET @TableName = 'AssetPlanogram' DECLARE @CurrentRecordId Int32 SET @CurrentRecordId = '3674833' dbo.GetValidDeviceForAlertProcessData 2025-12-22 06:21:18.3769 AlertProcessor ProcessorAlertData: Stopped 2025-12-22 06:26:11.2070 AlertProcessor ProcessorAlertData: started 2025-12-22 06:26:13.1445 DFramework.Database.Query /* Time Taken: 710*/ 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-22 06:26:13.1601 DFramework.Database.Query /* Time Taken: 617*/ DECLARE @TableName AnsiString(8000) SET @TableName = 'OpportunityOutOfStock' DECLARE @CurrentRecordId Int32 SET @CurrentRecordId = '3674833' dbo.GetValidDeviceForAlertProcessData 2025-12-22 06:26:16.9570 AlertProcessor ProcessorAlertData: Stopped 2025-12-22 06:31:11.2251 AlertProcessor ProcessorAlertData: started 2025-12-22 06:31:14.0376 DFramework.Database.Query /* Time Taken: 502*/ DECLARE @TableName AnsiString(8000) SET @TableName = 'AssetStockProductWiseConsolidate' DECLARE @CurrentRecordId Int32 SET @CurrentRecordId = '3674833' dbo.GetValidDeviceForAlertProcessData 2025-12-22 06:31:16.9283 AlertProcessor ProcessorAlertData: Stopped 2025-12-22 06:36:02.9148 MoveToReorder Running task for ClientId : 286 and ClientName = India Office QA and Slot: 12/22/2025 8:00:00 PM And LastExecutedOn: 12/22/2025 7:06:02 PM 2025-12-22 06:36:03.0554 DFramework.Database.Query /* Time Taken: 2459*/ [dbo].GenerateSystemAlerts 2025-12-22 06:36:11.2429 AlertProcessor ProcessorAlertData: started 2025-12-22 06:36:15.4617 DFramework.Database.Query /* Time Taken: 1002*/ DECLARE @TableName AnsiString(8000) SET @TableName = 'AssetStock' DECLARE @CurrentRecordId Int32 SET @CurrentRecordId = '3674833' dbo.GetValidDeviceForAlertProcessData 2025-12-22 06:36:15.7899 DFramework.Scheduler.TaskBase /* Time Taken: 15796.9806*/ Opportunity Out Of Stock By Outlet 2025-12-22 06:36:16.6492 DFramework.Database.Query /* Time Taken: 1115*/ DECLARE @TableName AnsiString(8000) SET @TableName = 'AssetPurity' DECLARE @CurrentRecordId Int32 SET @CurrentRecordId = '3674833' dbo.GetValidDeviceForAlertProcessData 2025-12-22 06:36:17.6024 DFramework.Database.Query /* Time Taken: 885*/ DECLARE @TableName AnsiString(8000) SET @TableName = 'OpportunityLowStock' DECLARE @CurrentRecordId Int32 SET @CurrentRecordId = '3674833' dbo.GetValidDeviceForAlertProcessData 2025-12-22 06:36:19.2743 AlertProcessor ProcessorAlertData: Stopped 2025-12-22 06:36:49.1651 DFramework.Database.NullableDataReader Data reader open for 45972 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-22 06:36:49.1963 MoveToReorder Task executed successfully for ClientId : 286 Client Name:India Office QA, Slot: 12/22/2025 8:00:00 PM and Total Order Suggested: 123 Out Of: 123 2025-12-22 06:36:50.2276 DFramework.Scheduler.TaskBase /* Time Taken: 47687.8491*/ Move To Re-Order 2025-12-22 06:41:11.2606 AlertProcessor ProcessorAlertData: started 2025-12-22 06:41:16.7138 AlertProcessor ProcessorAlertData: Stopped 2025-12-22 06:46:11.2784 AlertProcessor ProcessorAlertData: started 2025-12-22 06:46:14.4660 DFramework.Database.Query /* Time Taken: 577*/ DECLARE @TableName AnsiString(8000) SET @TableName = 'AssetStockProductWise' DECLARE @CurrentRecordId Int32 SET @CurrentRecordId = '3674833' dbo.GetValidDeviceForAlertProcessData 2025-12-22 06:46:17.0129 AlertProcessor ProcessorAlertData: Stopped 2025-12-22 06:51:02.6869 DFramework.Database.Query /* Time Taken: 2064*/ [dbo].GenerateSystemAlerts 2025-12-22 06:51:11.2807 AlertProcessor ProcessorAlertData: started 2025-12-22 06:51:15.6870 DFramework.Scheduler.TaskBase /* Time Taken: 15671.9821*/ Opportunity Out Of Stock By Outlet 2025-12-22 06:51:16.6558 DFramework.Database.NullableDataReader Data reader open for 294 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 251 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-22 06:51:17.3276 AlertProcessor ProcessorAlertData: Stopped 2025-12-22 06:56:11.2984 AlertProcessor ProcessorAlertData: started 2025-12-22 06:56:16.5484 AlertProcessor ProcessorAlertData: Stopped 2025-12-22 07:01:11.3160 AlertProcessor ProcessorAlertData: started 2025-12-22 07:01:16.8473 AlertProcessor ProcessorAlertData: Stopped 2025-12-22 07:06:03.9435 DFramework.Database.Query /* Time Taken: 3320*/ [dbo].GenerateSystemAlerts 2025-12-22 07:06:11.3185 AlertProcessor ProcessorAlertData: started 2025-12-22 07:06:15.6936 DFramework.Scheduler.TaskBase /* Time Taken: 15656.3633*/ Opportunity Out Of Stock By Outlet 2025-12-22 07:06:16.5217 AlertProcessor ProcessorAlertData: Stopped 2025-12-22 07:11:11.3207 AlertProcessor ProcessorAlertData: started 2025-12-22 07:11:16.6020 AlertProcessor ProcessorAlertData: Stopped 2025-12-22 07:16:11.3383 AlertProcessor ProcessorAlertData: started 2025-12-22 07:16:17.1352 AlertProcessor ProcessorAlertData: Stopped 2025-12-22 07:21:02.0124 DFramework.Database.Query /* Time Taken: 1371*/ [dbo].GenerateSystemAlerts 2025-12-22 07:21:11.3406 AlertProcessor ProcessorAlertData: started 2025-12-22 07:21:15.6375 DFramework.Scheduler.TaskBase /* Time Taken: 15593.8668*/ Opportunity Out Of Stock By Outlet 2025-12-22 07:21:16.6063 AlertProcessor ProcessorAlertData: Stopped 2025-12-22 07:26:11.3584 AlertProcessor ProcessorAlertData: started 2025-12-22 07:26:17.0616 AlertProcessor ProcessorAlertData: Stopped 2025-12-22 07:31:11.3761 AlertProcessor ProcessorAlertData: started 2025-12-22 07:31:16.5480 AlertProcessor ProcessorAlertData: Stopped 2025-12-22 07:36:01.7218 DFramework.Database.Query /* Time Taken: 1051*/ [dbo].GenerateSystemAlerts 2025-12-22 07:36:02.9875 MoveToReorder Running task for ClientId : 286 and ClientName = India Office QA and Slot: 12/22/2025 9:00:00 PM And LastExecutedOn: 12/22/2025 8:06:02 PM 2025-12-22 07:36:03.3781 MoveToReorder Task executed successfully for ClientId : 286 Client Name:India Office QA, Slot: 12/22/2025 9:00:00 PM But No Order found to suggest 2025-12-22 07:36:11.3782 AlertProcessor ProcessorAlertData: started 2025-12-22 07:36:15.6126 DFramework.Scheduler.TaskBase /* Time Taken: 15547.0198*/ Opportunity Out Of Stock By Outlet 2025-12-22 07:36:16.6282 AlertProcessor ProcessorAlertData: Stopped 2025-12-22 07:41:11.3806 AlertProcessor ProcessorAlertData: started 2025-12-22 07:41:16.6931 AlertProcessor ProcessorAlertData: Stopped 2025-12-22 07:46:11.3827 AlertProcessor ProcessorAlertData: started 2025-12-22 07:46:16.5077 AlertProcessor ProcessorAlertData: Stopped 2025-12-22 07:51:02.3847 DFramework.Database.Query /* Time Taken: 1694*/ [dbo].GenerateSystemAlerts 2025-12-22 07:51:11.4003 AlertProcessor ProcessorAlertData: started 2025-12-22 07:51:13.9629 DFramework.Database.Query /* Time Taken: 1278*/ 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-22 07:51:15.7285 DFramework.Scheduler.TaskBase /* Time Taken: 15640.7322*/ Opportunity Out Of Stock By Outlet 2025-12-22 07:51:16.7597 AlertProcessor ProcessorAlertData: Stopped 2025-12-22 07:56:11.4183 AlertProcessor ProcessorAlertData: started 2025-12-22 07:56:16.2465 AlertProcessor ProcessorAlertData: Stopped 2025-12-22 08:01:11.4362 AlertProcessor ProcessorAlertData: started 2025-12-22 08:01:16.3893 AlertProcessor ProcessorAlertData: Stopped 2025-12-22 08:06:02.2506 DFramework.Database.Query /* Time Taken: 1537*/ [dbo].GenerateSystemAlerts 2025-12-22 08:06:11.4538 AlertProcessor ProcessorAlertData: started 2025-12-22 08:06:15.6257 DFramework.Scheduler.TaskBase /* Time Taken: 15515.7238*/ Opportunity Out Of Stock By Outlet 2025-12-22 08:06:16.5632 AlertProcessor ProcessorAlertData: Stopped 2025-12-22 08:11:11.4716 AlertProcessor ProcessorAlertData: started 2025-12-22 08:11:16.2529 AlertProcessor ProcessorAlertData: Stopped 2025-12-22 08:16:11.4740 AlertProcessor ProcessorAlertData: started 2025-12-22 08:16:16.3021 AlertProcessor ProcessorAlertData: Stopped 2025-12-22 08:21:02.1010 DFramework.Database.Query /* Time Taken: 1361*/ [dbo].GenerateSystemAlerts 2025-12-22 08:21:11.4917 AlertProcessor ProcessorAlertData: started 2025-12-22 08:21:15.6792 DFramework.Scheduler.TaskBase /* Time Taken: 15546.9805*/ Opportunity Out Of Stock By Outlet 2025-12-22 08:21:16.8824 AlertProcessor ProcessorAlertData: Stopped 2025-12-22 08:26:11.5093 AlertProcessor ProcessorAlertData: started 2025-12-22 08:26:16.7750 AlertProcessor ProcessorAlertData: Stopped 2025-12-22 08:31:11.5274 AlertProcessor ProcessorAlertData: started 2025-12-22 08:31:16.8400 AlertProcessor ProcessorAlertData: Stopped 2025-12-22 08:36:01.8889 DFramework.Database.Query /* Time Taken: 1131*/ [dbo].GenerateSystemAlerts 2025-12-22 08:36:03.0452 MoveToReorder Running task for ClientId : 286 and ClientName = India Office QA and Slot: 12/22/2025 10:00:00 PM And LastExecutedOn: 12/22/2025 9:06:02 PM 2025-12-22 08:36:03.3577 MoveToReorder Task executed successfully for ClientId : 286 Client Name:India Office QA, Slot: 12/22/2025 10:00:00 PM But No Order found to suggest 2025-12-22 08:36:11.5296 AlertProcessor ProcessorAlertData: started 2025-12-22 08:36:15.7172 DFramework.Scheduler.TaskBase /* Time Taken: 15562.605*/ Opportunity Out Of Stock By Outlet 2025-12-22 08:36:16.4672 AlertProcessor ProcessorAlertData: Stopped 2025-12-22 08:41:11.5473 AlertProcessor ProcessorAlertData: started 2025-12-22 08:41:17.0786 AlertProcessor ProcessorAlertData: Stopped 2025-12-22 08:46:11.5653 AlertProcessor ProcessorAlertData: started 2025-12-22 08:46:16.8622 AlertProcessor ProcessorAlertData: Stopped 2025-12-22 08:51:01.9895 DFramework.Database.Query /* Time Taken: 1210*/ [dbo].GenerateSystemAlerts 2025-12-22 08:51:11.5677 AlertProcessor ProcessorAlertData: started 2025-12-22 08:51:15.6927 DFramework.Scheduler.TaskBase /* Time Taken: 15515.7497*/ Opportunity Out Of Stock By Outlet 2025-12-22 08:51:16.8646 AlertProcessor ProcessorAlertData: Stopped 2025-12-22 08:56:11.5854 AlertProcessor ProcessorAlertData: started 2025-12-22 08:56:16.8979 AlertProcessor ProcessorAlertData: Stopped 2025-12-22 09:01:11.6031 AlertProcessor ProcessorAlertData: started 2025-12-22 09:01:16.9157 AlertProcessor ProcessorAlertData: Stopped 2025-12-22 09:06:02.0282 DFramework.Database.Query /* Time Taken: 1228*/ [dbo].GenerateSystemAlerts 2025-12-22 09:06:11.6221 AlertProcessor ProcessorAlertData: started 2025-12-22 09:06:15.7471 DFramework.Scheduler.TaskBase /* Time Taken: 15547.0079*/ Opportunity Out Of Stock By Outlet 2025-12-22 09:06:17.0440 AlertProcessor ProcessorAlertData: Stopped 2025-12-22 09:11:11.6401 AlertProcessor ProcessorAlertData: started 2025-12-22 09:11:16.8745 AlertProcessor ProcessorAlertData: Stopped 2025-12-22 09:16:11.6578 AlertProcessor ProcessorAlertData: started 2025-12-22 09:16:17.1735 AlertProcessor ProcessorAlertData: Stopped 2025-12-22 09:21:02.6596 DFramework.Database.Query /* Time Taken: 1841*/ [dbo].GenerateSystemAlerts 2025-12-22 09:21:11.6753 AlertProcessor ProcessorAlertData: started 2025-12-22 09:21:15.0034 DFramework.Database.Query /* Time Taken: 2033*/ 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-22 09:21:15.7691 DFramework.Scheduler.TaskBase /* Time Taken: 15546.9665*/ Opportunity Out Of Stock By Outlet 2025-12-22 09:21:17.4566 AlertProcessor ProcessorAlertData: Stopped 2025-12-22 09:26:11.6928 AlertProcessor ProcessorAlertData: started 2025-12-22 09:26:17.0210 AlertProcessor ProcessorAlertData: Stopped 2025-12-22 09:31:11.7105 AlertProcessor ProcessorAlertData: started 2025-12-22 09:31:16.9605 AlertProcessor ProcessorAlertData: Stopped 2025-12-22 09:36:02.5874 DFramework.Database.Query /* Time Taken: 1744*/ [dbo].GenerateSystemAlerts 2025-12-22 09:36:11.7281 AlertProcessor ProcessorAlertData: started 2025-12-22 09:36:15.9000 DFramework.Scheduler.TaskBase /* Time Taken: 15656.3635*/ Opportunity Out Of Stock By Outlet 2025-12-22 09:36:17.0563 AlertProcessor ProcessorAlertData: Stopped 2025-12-22 09:41:11.7459 AlertProcessor ProcessorAlertData: started 2025-12-22 09:41:17.0740 AlertProcessor ProcessorAlertData: Stopped 2025-12-22 09:46:11.7635 AlertProcessor ProcessorAlertData: started 2025-12-22 09:46:17.0760 AlertProcessor ProcessorAlertData: Stopped 2025-12-22 09:51:02.2186 DFramework.Database.Query /* Time Taken: 1369*/ [dbo].GenerateSystemAlerts 2025-12-22 09:51:11.7812 AlertProcessor ProcessorAlertData: started 2025-12-22 09:51:15.8749 DFramework.Scheduler.TaskBase /* Time Taken: 15609.4783*/ Opportunity Out Of Stock By Outlet 2025-12-22 09:51:17.4687 AlertProcessor ProcessorAlertData: Stopped 2025-12-22 09:56:11.7993 AlertProcessor ProcessorAlertData: started 2025-12-22 09:56:17.1275 AlertProcessor ProcessorAlertData: Stopped 2025-12-22 10:01:11.8171 AlertProcessor ProcessorAlertData: started 2025-12-22 10:01:17.1453 AlertProcessor ProcessorAlertData: Stopped 2025-12-22 10:06:01.9285 DFramework.Database.Query /* Time Taken: 1054*/ [dbo].GenerateSystemAlerts 2025-12-22 10:06:11.8192 AlertProcessor ProcessorAlertData: started 2025-12-22 10:06:15.8349 DFramework.Scheduler.TaskBase /* Time Taken: 15546.9791*/ Opportunity Out Of Stock By Outlet 2025-12-22 10:06:17.1786 AlertProcessor ProcessorAlertData: Stopped 2025-12-22 10:11:11.8371 AlertProcessor ProcessorAlertData: started 2025-12-22 10:11:17.1652 AlertProcessor ProcessorAlertData: Stopped 2025-12-22 10:16:11.8550 AlertProcessor ProcessorAlertData: started 2025-12-22 10:16:17.1050 AlertProcessor ProcessorAlertData: Stopped 2025-12-22 10:21:01.9664 DFramework.Database.Query /* Time Taken: 1075*/ [dbo].GenerateSystemAlerts 2025-12-22 10:21:11.8727 AlertProcessor ProcessorAlertData: started 2025-12-22 10:21:15.8571 DFramework.Scheduler.TaskBase /* Time Taken: 15562.6099*/ Opportunity Out Of Stock By Outlet 2025-12-22 10:21:17.2009 AlertProcessor ProcessorAlertData: Stopped 2025-12-22 10:26:11.8904 AlertProcessor ProcessorAlertData: started 2025-12-22 10:26:17.4060 AlertProcessor ProcessorAlertData: Stopped 2025-12-22 10:31:11.9084 AlertProcessor ProcessorAlertData: started 2025-12-22 10:31:16.1272 DFramework.Database.NullableDataReader Data reader open for 251 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 251 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-22 10:31:17.3928 AlertProcessor ProcessorAlertData: Stopped 2025-12-22 10:36:02.0667 DFramework.Database.Query /* Time Taken: 1143*/ [dbo].GenerateSystemAlerts 2025-12-22 10:36:11.9262 AlertProcessor ProcessorAlertData: started 2025-12-22 10:36:15.8481 DFramework.Scheduler.TaskBase /* Time Taken: 15531.3579*/ Opportunity Out Of Stock By Outlet 2025-12-22 10:36:17.2231 AlertProcessor ProcessorAlertData: Stopped 2025-12-22 10:41:11.9438 AlertProcessor ProcessorAlertData: started 2025-12-22 10:41:17.3032 AlertProcessor ProcessorAlertData: Stopped 2025-12-22 10:46:11.9618 AlertProcessor ProcessorAlertData: started 2025-12-22 10:46:17.6649 AlertProcessor ProcessorAlertData: Stopped 2025-12-22 10:51:02.3546 DFramework.Database.Query /* Time Taken: 1408*/ [dbo].GenerateSystemAlerts 2025-12-22 10:51:11.9640 AlertProcessor ProcessorAlertData: started 2025-12-22 10:51:14.7453 DFramework.Database.Query /* Time Taken: 1592*/ 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-22 10:51:15.8859 DFramework.Scheduler.TaskBase /* Time Taken: 15546.9853*/ Opportunity Out Of Stock By Outlet 2025-12-22 10:51:17.5422 AlertProcessor ProcessorAlertData: Stopped 2025-12-22 10:56:11.9817 AlertProcessor ProcessorAlertData: started 2025-12-22 10:56:18.6693 DFramework.Database.Query /* Time Taken: 819*/ DECLARE @TableName AnsiString(8000) SET @TableName = 'ProductStockLevel' DECLARE @CurrentRecordId Int32 SET @CurrentRecordId = '3674833' dbo.GetValidDeviceForAlertProcessData 2025-12-22 10:56:18.7318 AlertProcessor ProcessorAlertData: Stopped 2025-12-22 11:01:11.9994 AlertProcessor ProcessorAlertData: started 2025-12-22 11:01:14.9994 DFramework.Database.NullableDataReader Data reader open for 253 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 251 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-22 11:01:17.4838 AlertProcessor ProcessorAlertData: Stopped 2025-12-22 11:06:03.5484 DFramework.Database.Query /* Time Taken: 2589*/ [dbo].GenerateSystemAlerts 2025-12-22 11:06:12.0173 AlertProcessor ProcessorAlertData: started 2025-12-22 11:06:16.0798 DFramework.Scheduler.TaskBase /* Time Taken: 15734.4951*/ Opportunity Out Of Stock By Outlet 2025-12-22 11:06:17.3454 AlertProcessor ProcessorAlertData: Stopped 2025-12-22 11:11:12.0349 AlertProcessor ProcessorAlertData: started 2025-12-22 11:11:17.3319 AlertProcessor ProcessorAlertData: Stopped 2025-12-22 11:16:12.0526 AlertProcessor ProcessorAlertData: started 2025-12-22 11:16:17.2871 AlertProcessor ProcessorAlertData: Stopped 2025-12-22 11:21:02.3985 DFramework.Database.Query /* Time Taken: 1417*/ [dbo].GenerateSystemAlerts 2025-12-22 11:21:12.0548 AlertProcessor ProcessorAlertData: started 2025-12-22 11:21:16.0080 DFramework.Scheduler.TaskBase /* Time Taken: 15656.3672*/ Opportunity Out Of Stock By Outlet 2025-12-22 11:21:17.6799 AlertProcessor ProcessorAlertData: Stopped 2025-12-22 11:26:12.0725 AlertProcessor ProcessorAlertData: started 2025-12-22 11:26:17.3382 AlertProcessor ProcessorAlertData: Stopped 2025-12-22 11:31:12.0902 AlertProcessor ProcessorAlertData: started 2025-12-22 11:31:17.4028 AlertProcessor ProcessorAlertData: Stopped 2025-12-22 11:36:04.0612 DFramework.Database.Query /* Time Taken: 3051*/ [dbo].GenerateSystemAlerts 2025-12-22 11:36:12.1081 AlertProcessor ProcessorAlertData: started 2025-12-22 11:36:16.0300 DFramework.Scheduler.TaskBase /* Time Taken: 15672.0114*/ Opportunity Out Of Stock By Outlet 2025-12-22 11:36:17.5457 AlertProcessor ProcessorAlertData: Stopped 2025-12-22 11:41:12.1105 AlertProcessor ProcessorAlertData: started 2025-12-22 11:41:17.2668 AlertProcessor ProcessorAlertData: Stopped 2025-12-22 11:46:12.1282 AlertProcessor ProcessorAlertData: started 2025-12-22 11:46:17.3470 AlertProcessor ProcessorAlertData: Stopped 2025-12-22 11:51:04.5209 DFramework.Database.Query /* Time Taken: 3484*/ [dbo].GenerateSystemAlerts 2025-12-22 11:51:12.1460 AlertProcessor ProcessorAlertData: started 2025-12-22 11:51:16.0991 DFramework.Scheduler.TaskBase /* Time Taken: 15734.4546*/ Opportunity Out Of Stock By Outlet 2025-12-22 11:51:17.3335 AlertProcessor ProcessorAlertData: Stopped 2025-12-22 11:56:12.1639 AlertProcessor ProcessorAlertData: started 2025-12-22 11:56:17.3671 AlertProcessor ProcessorAlertData: Stopped 2025-12-22 12:01:12.1661 AlertProcessor ProcessorAlertData: started 2025-12-22 12:01:17.2911 AlertProcessor ProcessorAlertData: Stopped 2025-12-22 12:06:02.4181 DFramework.Database.Query /* Time Taken: 1361*/ [dbo].GenerateSystemAlerts 2025-12-22 12:06:12.1682 AlertProcessor ProcessorAlertData: started 2025-12-22 12:06:15.9338 DFramework.Scheduler.TaskBase /* Time Taken: 15547.009*/ Opportunity Out Of Stock By Outlet 2025-12-22 12:06:17.3869 AlertProcessor ProcessorAlertData: Stopped 2025-12-22 12:11:12.1860 AlertProcessor ProcessorAlertData: started 2025-12-22 12:11:17.6236 AlertProcessor ProcessorAlertData: Stopped 2025-12-22 12:16:12.2039 AlertProcessor ProcessorAlertData: started 2025-12-22 12:16:17.3602 AlertProcessor ProcessorAlertData: Stopped 2025-12-22 12:21:02.7215 DFramework.Database.Query /* Time Taken: 1652*/ [dbo].GenerateSystemAlerts 2025-12-22 12:21:12.2060 AlertProcessor ProcessorAlertData: started 2025-12-22 12:21:15.0185 DFramework.Database.Query /* Time Taken: 515*/ DECLARE @TableName AnsiString(8000) SET @TableName = 'AssetStockProductWiseConsolidate' DECLARE @CurrentRecordId Int32 SET @CurrentRecordId = '3674833' dbo.GetValidDeviceForAlertProcessData 2025-12-22 12:21:15.4404 DFramework.Database.Query /* Time Taken: 1980*/ 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-22 12:21:16.1748 DFramework.Scheduler.TaskBase /* Time Taken: 15765.7183*/ Opportunity Out Of Stock By Outlet 2025-12-22 12:21:17.8935 AlertProcessor ProcessorAlertData: Stopped 2025-12-22 12:26:12.2081 AlertProcessor ProcessorAlertData: started 2025-12-22 12:26:17.5206 AlertProcessor ProcessorAlertData: Stopped 2025-12-22 12:31:12.2261 AlertProcessor ProcessorAlertData: started 2025-12-22 12:31:17.3823 AlertProcessor ProcessorAlertData: Stopped 2025-12-22 12:36:02.9312 DFramework.Database.Query /* Time Taken: 1858*/ [dbo].GenerateSystemAlerts 2025-12-22 12:36:12.2438 AlertProcessor ProcessorAlertData: started 2025-12-22 12:36:15.9626 DFramework.Scheduler.TaskBase /* Time Taken: 15531.3568*/ Opportunity Out Of Stock By Outlet 2025-12-22 12:36:17.4001 AlertProcessor ProcessorAlertData: Stopped 2025-12-22 12:41:12.2615 AlertProcessor ProcessorAlertData: started 2025-12-22 12:41:17.4803 AlertProcessor ProcessorAlertData: Stopped 2025-12-22 12:46:12.2795 AlertProcessor ProcessorAlertData: started 2025-12-22 12:46:17.5608 AlertProcessor ProcessorAlertData: Stopped 2025-12-22 12:51:02.1722 DFramework.Database.Query /* Time Taken: 1073*/ [dbo].GenerateSystemAlerts 2025-12-22 12:51:12.2973 AlertProcessor ProcessorAlertData: started 2025-12-22 12:51:15.9692 DFramework.Scheduler.TaskBase /* Time Taken: 15531.3548*/ Opportunity Out Of Stock By Outlet 2025-12-22 12:51:17.7505 AlertProcessor ProcessorAlertData: Stopped 2025-12-22 12:56:12.3150 AlertProcessor ProcessorAlertData: started 2025-12-22 12:56:17.7213 AlertProcessor ProcessorAlertData: Stopped 2025-12-22 13:01:12.3329 AlertProcessor ProcessorAlertData: started 2025-12-22 13:01:17.4579 AlertProcessor ProcessorAlertData: Stopped 2025-12-22 13:06:02.1789 DFramework.Database.Query /* Time Taken: 1058*/ [dbo].GenerateSystemAlerts 2025-12-22 13:06:12.3352 AlertProcessor ProcessorAlertData: started 2025-12-22 13:06:16.1790 DFramework.Scheduler.TaskBase /* Time Taken: 15734.4816*/ Opportunity Out Of Stock By Outlet 2025-12-22 13:06:17.6165 AlertProcessor ProcessorAlertData: Stopped 2025-12-22 13:11:12.3529 AlertProcessor ProcessorAlertData: started 2025-12-22 13:11:17.5561 AlertProcessor ProcessorAlertData: Stopped 2025-12-22 13:16:12.3550 AlertProcessor ProcessorAlertData: started 2025-12-22 13:16:17.5894 AlertProcessor ProcessorAlertData: Stopped 2025-12-22 13:21:02.5135 DFramework.Database.Query /* Time Taken: 1369*/ [dbo].GenerateSystemAlerts 2025-12-22 13:21:12.3730 AlertProcessor ProcessorAlertData: started 2025-12-22 13:21:16.0605 DFramework.Scheduler.TaskBase /* Time Taken: 15609.4818*/ Opportunity Out Of Stock By Outlet 2025-12-22 13:21:18.0136 AlertProcessor ProcessorAlertData: Stopped 2025-12-22 13:26:12.3907 AlertProcessor ProcessorAlertData: started 2025-12-22 13:26:17.6720 AlertProcessor ProcessorAlertData: Stopped 2025-12-22 13:31:12.4084 AlertProcessor ProcessorAlertData: started 2025-12-22 13:31:17.5803 AlertProcessor ProcessorAlertData: Stopped 2025-12-22 13:36:02.2231 DFramework.Database.Query /* Time Taken: 1059*/ [dbo].GenerateSystemAlerts 2025-12-22 13:36:12.4106 AlertProcessor ProcessorAlertData: started 2025-12-22 13:36:16.0669 DFramework.Scheduler.TaskBase /* Time Taken: 15593.869*/ Opportunity Out Of Stock By Outlet 2025-12-22 13:36:17.8326 AlertProcessor ProcessorAlertData: Stopped 2025-12-22 13:41:12.4128 AlertProcessor ProcessorAlertData: started 2025-12-22 13:41:17.7254 AlertProcessor ProcessorAlertData: Stopped 2025-12-22 13:46:12.4305 AlertProcessor ProcessorAlertData: started 2025-12-22 13:46:17.6650 AlertProcessor ProcessorAlertData: Stopped 2025-12-22 13:51:02.6200 DFramework.Database.Query /* Time Taken: 1424*/ [dbo].GenerateSystemAlerts 2025-12-22 13:51:12.4482 AlertProcessor ProcessorAlertData: started 2025-12-22 13:51:16.0889 DFramework.Scheduler.TaskBase /* Time Taken: 15593.8641*/ Opportunity Out Of Stock By Outlet 2025-12-22 13:51:17.3545 DFramework.Database.Query /* Time Taken: 3634*/ 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-22 13:51:18.0420 AlertProcessor ProcessorAlertData: Stopped 2025-12-22 13:56:12.4663 AlertProcessor ProcessorAlertData: started 2025-12-22 13:56:13.6381 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-22 13:56:18.0288 AlertProcessor ProcessorAlertData: Stopped 2025-12-22 14:01:12.4840 AlertProcessor ProcessorAlertData: started 2025-12-22 14:01:17.6091 AlertProcessor ProcessorAlertData: Stopped 2025-12-22 14:06:02.8141 DFramework.Database.Query /* Time Taken: 1607*/ [dbo].GenerateSystemAlerts 2025-12-22 14:06:12.5017 AlertProcessor ProcessorAlertData: started 2025-12-22 14:06:16.0330 DFramework.Scheduler.TaskBase /* Time Taken: 15515.7292*/ Opportunity Out Of Stock By Outlet 2025-12-22 14:06:17.6892 AlertProcessor ProcessorAlertData: Stopped 2025-12-22 14:11:12.5198 AlertProcessor ProcessorAlertData: started 2025-12-22 14:11:17.8792 AlertProcessor ProcessorAlertData: Stopped 2025-12-22 14:16:12.5378 AlertProcessor ProcessorAlertData: started 2025-12-22 14:16:17.7410 AlertProcessor ProcessorAlertData: Stopped 2025-12-22 14:21:02.4148 DFramework.Database.Query /* Time Taken: 1171*/ [dbo].GenerateSystemAlerts 2025-12-22 14:21:12.5555 AlertProcessor ProcessorAlertData: started 2025-12-22 14:21:16.1493 DFramework.Scheduler.TaskBase /* Time Taken: 15625.1073*/ Opportunity Out Of Stock By Outlet 2025-12-22 14:21:17.7431 AlertProcessor ProcessorAlertData: Stopped 2025-12-22 14:26:12.5734 AlertProcessor ProcessorAlertData: started 2025-12-22 14:26:17.8703 AlertProcessor ProcessorAlertData: Stopped 2025-12-22 14:31:12.5914 AlertProcessor ProcessorAlertData: started 2025-12-22 14:31:17.9040 AlertProcessor ProcessorAlertData: Stopped 2025-12-22 14:36:02.4685 DFramework.Database.Query /* Time Taken: 1203*/ [dbo].GenerateSystemAlerts 2025-12-22 14:36:12.6092 AlertProcessor ProcessorAlertData: started 2025-12-22 14:36:16.2186 DFramework.Scheduler.TaskBase /* Time Taken: 15671.9888*/ Opportunity Out Of Stock By Outlet 2025-12-22 14:36:17.7186 AlertProcessor ProcessorAlertData: Stopped 2025-12-22 14:41:12.6269 AlertProcessor ProcessorAlertData: started 2025-12-22 14:41:17.7988 AlertProcessor ProcessorAlertData: Stopped 2025-12-22 14:46:12.6449 AlertProcessor ProcessorAlertData: started 2025-12-22 14:46:17.9887 AlertProcessor ProcessorAlertData: Stopped 2025-12-22 14:51:02.6315 DFramework.Database.Query /* Time Taken: 1343*/ [dbo].GenerateSystemAlerts 2025-12-22 14:51:12.6471 AlertProcessor ProcessorAlertData: started 2025-12-22 14:51:16.3347 DFramework.Scheduler.TaskBase /* Time Taken: 15765.7302*/ Opportunity Out Of Stock By Outlet 2025-12-22 14:51:17.8503 AlertProcessor ProcessorAlertData: Stopped 2025-12-22 14:56:12.6492 AlertProcessor ProcessorAlertData: started 2025-12-22 14:56:18.0086 AlertProcessor ProcessorAlertData: Stopped 2025-12-22 15:01:12.6515 AlertProcessor ProcessorAlertData: started 2025-12-22 15:01:17.8859 AlertProcessor ProcessorAlertData: Stopped 2025-12-22 15:06:02.3412 DFramework.Database.Query /* Time Taken: 1046*/ [dbo].GenerateSystemAlerts 2025-12-22 15:06:12.6694 AlertProcessor ProcessorAlertData: started 2025-12-22 15:06:16.1069 DFramework.Scheduler.TaskBase /* Time Taken: 15515.734*/ Opportunity Out Of Stock By Outlet 2025-12-22 15:06:18.1538 AlertProcessor ProcessorAlertData: Stopped 2025-12-22 15:11:12.6872 AlertProcessor ProcessorAlertData: started 2025-12-22 15:11:17.9528 AlertProcessor ProcessorAlertData: Stopped 2025-12-22 15:16:12.7049 AlertProcessor ProcessorAlertData: started 2025-12-22 15:16:17.8924 AlertProcessor ProcessorAlertData: Stopped 2025-12-22 15:21:02.7697 DFramework.Database.Query /* Time Taken: 1451*/ [dbo].GenerateSystemAlerts 2025-12-22 15:21:12.7073 AlertProcessor ProcessorAlertData: started 2025-12-22 15:21:15.4886 DFramework.Database.Query /* Time Taken: 1549*/ 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-22 15:21:16.2386 DFramework.Scheduler.TaskBase /* Time Taken: 15625.118*/ Opportunity Out Of Stock By Outlet 2025-12-22 15:21:18.3167 AlertProcessor ProcessorAlertData: Stopped 2025-12-22 15:26:12.7095 AlertProcessor ProcessorAlertData: started 2025-12-22 15:26:18.0220 AlertProcessor ProcessorAlertData: Stopped 2025-12-22 15:31:12.7272 AlertProcessor ProcessorAlertData: started 2025-12-22 15:31:17.9147 AlertProcessor ProcessorAlertData: Stopped 2025-12-22 15:36:03.5889 DFramework.Database.Query /* Time Taken: 2253*/ [dbo].GenerateSystemAlerts 2025-12-22 15:36:12.7453 AlertProcessor ProcessorAlertData: started 2025-12-22 15:36:16.1828 DFramework.Scheduler.TaskBase /* Time Taken: 15547.0055*/ Opportunity Out Of Stock By Outlet 2025-12-22 15:36:18.0266 AlertProcessor ProcessorAlertData: Stopped 2025-12-22 15:41:12.7632 AlertProcessor ProcessorAlertData: started 2025-12-22 15:41:18.0445 AlertProcessor ProcessorAlertData: Stopped 2025-12-22 15:46:12.7653 AlertProcessor ProcessorAlertData: started 2025-12-22 15:46:17.9060 AlertProcessor ProcessorAlertData: Stopped 2025-12-22 15:51:03.5643 DFramework.Database.Query /* Time Taken: 2212*/ [dbo].GenerateSystemAlerts 2025-12-22 15:51:12.7831 AlertProcessor ProcessorAlertData: started 2025-12-22 15:51:16.2363 DFramework.Scheduler.TaskBase /* Time Taken: 15578.2783*/ Opportunity Out Of Stock By Outlet 2025-12-22 15:51:17.9863 AlertProcessor ProcessorAlertData: Stopped 2025-12-22 15:56:12.8012 AlertProcessor ProcessorAlertData: started 2025-12-22 15:56:18.1137 AlertProcessor ProcessorAlertData: Stopped 2025-12-22 16:01:12.8033 AlertProcessor ProcessorAlertData: started 2025-12-22 16:01:18.0065 AlertProcessor ProcessorAlertData: Stopped 2025-12-22 16:06:02.5710 DFramework.Database.Query /* Time Taken: 1194*/ [dbo].GenerateSystemAlerts 2025-12-22 16:06:12.8210 AlertProcessor ProcessorAlertData: started 2025-12-22 16:06:16.2273 DFramework.Scheduler.TaskBase /* Time Taken: 15546.981*/ Opportunity Out Of Stock By Outlet 2025-12-22 16:06:18.0242 AlertProcessor ProcessorAlertData: Stopped 2025-12-22 16:11:12.8233 AlertProcessor ProcessorAlertData: started 2025-12-22 16:11:18.1202 AlertProcessor ProcessorAlertData: Stopped 2025-12-22 16:16:12.8411 AlertProcessor ProcessorAlertData: started 2025-12-22 16:16:18.0911 AlertProcessor ProcessorAlertData: Stopped 2025-12-22 16:21:03.2024 DFramework.Database.Query /* Time Taken: 1805*/ [dbo].GenerateSystemAlerts 2025-12-22 16:21:12.8588 AlertProcessor ProcessorAlertData: started 2025-12-22 16:21:16.2182 DFramework.Scheduler.TaskBase /* Time Taken: 15531.3551*/ Opportunity Out Of Stock By Outlet 2025-12-22 16:21:18.0151 AlertProcessor ProcessorAlertData: Stopped 2025-12-22 16:26:12.8768 AlertProcessor ProcessorAlertData: started 2025-12-22 16:26:18.1737 AlertProcessor ProcessorAlertData: Stopped 2025-12-22 16:31:12.8949 AlertProcessor ProcessorAlertData: started 2025-12-22 16:31:18.1449 AlertProcessor ProcessorAlertData: Stopped 2025-12-22 16:36:02.9127 DFramework.Database.Query /* Time Taken: 1508*/ [dbo].GenerateSystemAlerts 2025-12-22 16:36:12.9127 AlertProcessor ProcessorAlertData: started 2025-12-22 16:36:16.2409 DFramework.Scheduler.TaskBase /* Time Taken: 15546.9778*/ Opportunity Out Of Stock By Outlet 2025-12-22 16:36:18.1315 AlertProcessor ProcessorAlertData: Stopped 2025-12-22 16:41:12.9148 AlertProcessor ProcessorAlertData: started 2025-12-22 16:41:18.0711 AlertProcessor ProcessorAlertData: Stopped 2025-12-22 16:46:12.9331 AlertProcessor ProcessorAlertData: started 2025-12-22 16:46:18.1832 AlertProcessor ProcessorAlertData: Stopped 2025-12-22 16:51:02.8416 DFramework.Database.Query /* Time Taken: 1420*/ [dbo].GenerateSystemAlerts 2025-12-22 16:51:12.9510 AlertProcessor ProcessorAlertData: started 2025-12-22 16:51:15.6073 DFramework.Database.Query /* Time Taken: 1418*/ 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-22 16:51:16.2636 DFramework.Scheduler.TaskBase /* Time Taken: 15546.9751*/ Opportunity Out Of Stock By Outlet 2025-12-22 16:51:18.5604 AlertProcessor ProcessorAlertData: Stopped 2025-12-22 16:56:12.9688 AlertProcessor ProcessorAlertData: started 2025-12-22 16:56:18.2345 AlertProcessor ProcessorAlertData: Stopped 2025-12-22 17:01:12.9866 AlertProcessor ProcessorAlertData: started 2025-12-22 17:01:18.1429 AlertProcessor ProcessorAlertData: Stopped 2025-12-22 17:06:03.2075 DFramework.Database.Query /* Time Taken: 1758*/ [dbo].GenerateSystemAlerts 2025-12-22 17:06:13.0044 AlertProcessor ProcessorAlertData: started 2025-12-22 17:06:16.2544 DFramework.Scheduler.TaskBase /* Time Taken: 15531.3602*/ Opportunity Out Of Stock By Outlet 2025-12-22 17:06:18.1607 AlertProcessor ProcessorAlertData: Stopped 2025-12-22 17:11:13.0222 AlertProcessor ProcessorAlertData: started 2025-12-22 17:11:18.2097 AlertProcessor ProcessorAlertData: Stopped 2025-12-22 17:16:13.0399 AlertProcessor ProcessorAlertData: started 2025-12-22 17:16:18.2900 AlertProcessor ProcessorAlertData: Stopped 2025-12-22 17:21:02.6671 DFramework.Database.Query /* Time Taken: 1207*/ [dbo].GenerateSystemAlerts 2025-12-22 17:21:13.0579 AlertProcessor ProcessorAlertData: started 2025-12-22 17:21:16.2297 DFramework.Scheduler.TaskBase /* Time Taken: 15500.1116*/ Opportunity Out Of Stock By Outlet 2025-12-22 17:21:18.1985 AlertProcessor ProcessorAlertData: Stopped 2025-12-22 17:26:13.0756 AlertProcessor ProcessorAlertData: started 2025-12-22 17:26:18.3413 AlertProcessor ProcessorAlertData: Stopped 2025-12-22 17:31:13.0934 AlertProcessor ProcessorAlertData: started 2025-12-22 17:31:18.4059 AlertProcessor ProcessorAlertData: Stopped 2025-12-22 17:36:02.6114 DFramework.Database.Query /* Time Taken: 1155*/ [dbo].GenerateSystemAlerts 2025-12-22 17:36:13.0958 AlertProcessor ProcessorAlertData: started 2025-12-22 17:36:16.3771 DFramework.Scheduler.TaskBase /* Time Taken: 15625.1288*/ Opportunity Out Of Stock By Outlet 2025-12-22 17:36:18.3459 AlertProcessor ProcessorAlertData: Stopped 2025-12-22 17:41:13.0981 AlertProcessor ProcessorAlertData: started 2025-12-22 17:41:18.2857 AlertProcessor ProcessorAlertData: Stopped 2025-12-22 17:46:13.1003 AlertProcessor ProcessorAlertData: started 2025-12-22 17:46:18.3972 AlertProcessor ProcessorAlertData: Stopped 2025-12-22 17:51:02.6805 DFramework.Database.Query /* Time Taken: 1199*/ [dbo].GenerateSystemAlerts 2025-12-22 17:51:13.1025 AlertProcessor ProcessorAlertData: started 2025-12-22 17:51:16.3056 DFramework.Scheduler.TaskBase /* Time Taken: 15531.3781*/ Opportunity Out Of Stock By Outlet 2025-12-22 17:51:18.4150 AlertProcessor ProcessorAlertData: Stopped 2025-12-22 17:56:13.1204 AlertProcessor ProcessorAlertData: started 2025-12-22 17:56:18.3861 AlertProcessor ProcessorAlertData: Stopped 2025-12-22 18:01:13.1382 AlertProcessor ProcessorAlertData: started 2025-12-22 18:01:13.6695 DFramework.Database.Query /* Time Taken: 535*/ DECLARE @TableName AnsiString(8000) SET @TableName = 'TagAlert' DECLARE @CurrentRecordId Int32 SET @CurrentRecordId = '0' dbo.GetValidDeviceForAlertProcessData 2025-12-22 18:01:16.7320 DFramework.Database.Query /* Time Taken: 503*/ DECLARE @TableName AnsiString(8000) SET @TableName = 'AssetStockProductWiseConsolidate' DECLARE @CurrentRecordId Int32 SET @CurrentRecordId = '3674833' dbo.GetValidDeviceForAlertProcessData 2025-12-22 18:01:20.2945 AlertProcessor ProcessorAlertData: Stopped 2025-12-22 18:06:05.1090 DFramework.Database.Query /* Time Taken: 3598*/ [dbo].GenerateSystemAlerts 2025-12-22 18:06:13.1560 AlertProcessor ProcessorAlertData: started 2025-12-22 18:06:16.6872 DFramework.Scheduler.TaskBase /* Time Taken: 15890.7369*/ Opportunity Out Of Stock By Outlet 2025-12-22 18:06:18.4216 AlertProcessor ProcessorAlertData: Stopped 2025-12-22 18:11:13.1739 AlertProcessor ProcessorAlertData: started 2025-12-22 18:11:18.4395 AlertProcessor ProcessorAlertData: Stopped 2025-12-22 18:16:13.1760 AlertProcessor ProcessorAlertData: started 2025-12-22 18:16:18.3323 AlertProcessor ProcessorAlertData: Stopped 2025-12-22 18:21:03.1781 DFramework.Database.Query /* Time Taken: 1640*/ [dbo].GenerateSystemAlerts 2025-12-22 18:21:13.1938 AlertProcessor ProcessorAlertData: started 2025-12-22 18:21:15.6313 DFramework.Database.Query /* Time Taken: 1243*/ 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-22 18:21:16.3969 DFramework.Scheduler.TaskBase /* Time Taken: 15578.2346*/ Opportunity Out Of Stock By Outlet 2025-12-22 18:21:18.7407 AlertProcessor ProcessorAlertData: Stopped 2025-12-22 18:26:13.2116 AlertProcessor ProcessorAlertData: started 2025-12-22 18:26:18.3523 AlertProcessor ProcessorAlertData: Stopped 2025-12-22 18:31:13.2294 AlertProcessor ProcessorAlertData: started 2025-12-22 18:31:18.5264 AlertProcessor ProcessorAlertData: Stopped 2025-12-22 18:36:03.0752 DFramework.Database.Query /* Time Taken: 1524*/ [dbo].GenerateSystemAlerts 2025-12-22 18:36:04.1221 MoveToReorder Running task for ClientId : 286 and ClientName = India Office QA and Slot: 12/23/2025 8:00:00 AM And LastExecutedOn: 12/22/2025 10:06:03 PM 2025-12-22 18:36:13.2472 AlertProcessor ProcessorAlertData: started 2025-12-22 18:36:16.0128 DFramework.Database.Query /* Time Taken: 605*/ DECLARE @TableName AnsiString(8000) SET @TableName = 'AssetStockProductWiseConsolidate' DECLARE @CurrentRecordId Int32 SET @CurrentRecordId = '3674833' dbo.GetValidDeviceForAlertProcessData 2025-12-22 18:36:16.3722 DFramework.Scheduler.TaskBase /* Time Taken: 15531.3562*/ Opportunity Out Of Stock By Outlet 2025-12-22 18:36:18.8253 AlertProcessor ProcessorAlertData: Stopped 2025-12-22 18:36:43.5912 DFramework.Database.NullableDataReader Data reader open for 38810 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-22 18:36:43.6224 MoveToReorder Task executed successfully for ClientId : 286 Client Name:India Office QA, Slot: 12/23/2025 8:00:00 AM and Total Order Suggested: 120 Out Of: 120 2025-12-22 18:36:44.8099 DFramework.Database.Query /* Time Taken: 553*/ DECLARE @ClientId Int32 SET @ClientId = '286' DECLARE @OrderStatusId Int32 SET @OrderStatusId = '5485' SELECT * FROM vwScheduledOrderExportInfoList WHERE [ClientId] = @ClientId AND [OrderStatusId] = @OrderStatusId ORDER BY [LocationId] 2025-12-22 18:36:45.0443 DFramework.Scheduler.TaskBase /* Time Taken: 41375.3196*/ Move To Re-Order 2025-12-22 18:41:13.2493 AlertProcessor ProcessorAlertData: started 2025-12-22 18:41:18.4525 AlertProcessor ProcessorAlertData: Stopped 2025-12-22 18:46:13.2673 AlertProcessor ProcessorAlertData: started 2025-12-22 18:46:18.4548 AlertProcessor ProcessorAlertData: Stopped 2025-12-22 18:51:02.8162 DFramework.Database.Query /* Time Taken: 1244*/ [dbo].GenerateSystemAlerts 2025-12-22 18:51:13.2850 AlertProcessor ProcessorAlertData: started 2025-12-22 18:51:16.3788 DFramework.Scheduler.TaskBase /* Time Taken: 15531.3589*/ Opportunity Out Of Stock By Outlet 2025-12-22 18:55:09.7555 AlertProcessor ProcessorAlertData: Stopped 2025-12-22 18:55:09.7555 DFramework.Scheduler.TaskBase /* Time Taken: 236470.4323*/ Process Alert Record 2025-12-22 18:56:13.3028 AlertProcessor ProcessorAlertData: started 2025-12-22 19:00:09.7264 AlertProcessor ProcessorAlertData: Stopped 2025-12-22 19:00:09.7264 DFramework.Scheduler.TaskBase /* Time Taken: 236423.5991*/ Process Alert Record 2025-12-22 19:01:13.3050 AlertProcessor ProcessorAlertData: started 2025-12-22 19:05:09.6348 AlertProcessor ProcessorAlertData: Stopped 2025-12-22 19:05:09.6348 DFramework.Scheduler.TaskBase /* Time Taken: 236329.8326*/ Process Alert Record 2025-12-22 19:06:02.9164 DFramework.Database.Query /* Time Taken: 1313*/ [dbo].GenerateSystemAlerts 2025-12-22 19:06:13.3071 AlertProcessor ProcessorAlertData: started 2025-12-22 19:06:16.3853 DFramework.Scheduler.TaskBase /* Time Taken: 15515.7378*/ Opportunity Out Of Stock By Outlet 2025-12-22 19:10:09.8088 AlertProcessor ProcessorAlertData: Stopped 2025-12-22 19:10:09.8088 DFramework.Scheduler.TaskBase /* Time Taken: 236501.6812*/ Process Alert Record 2025-12-22 19:11:13.3093 AlertProcessor ProcessorAlertData: started 2025-12-22 19:15:09.7640 AlertProcessor ProcessorAlertData: Stopped 2025-12-22 19:15:09.7640 DFramework.Scheduler.TaskBase /* Time Taken: 236454.7798*/ Process Alert Record 2025-12-22 19:16:13.3270 AlertProcessor ProcessorAlertData: started 2025-12-22 19:20:09.9070 AlertProcessor ProcessorAlertData: Stopped 2025-12-22 19:20:09.9070 DFramework.Scheduler.TaskBase /* Time Taken: 236579.9226*/ Process Alert Record 2025-12-22 19:21:02.7824 DFramework.Database.Query /* Time Taken: 1163*/ [dbo].GenerateSystemAlerts 2025-12-22 19:21:13.3449 AlertProcessor ProcessorAlertData: started 2025-12-22 19:21:16.7512 DFramework.Scheduler.TaskBase /* Time Taken: 15859.4962*/ Opportunity Out Of Stock By Outlet 2025-12-22 19:25:09.9872 AlertProcessor ProcessorAlertData: Stopped 2025-12-22 19:25:09.9872 DFramework.Scheduler.TaskBase /* Time Taken: 236642.3117*/ Process Alert Record 2025-12-22 19:26:13.3627 AlertProcessor ProcessorAlertData: started 2025-12-22 19:30:09.8644 AlertProcessor ProcessorAlertData: Stopped 2025-12-22 19:30:09.8644 DFramework.Scheduler.TaskBase /* Time Taken: 236501.6899*/ Process Alert Record 2025-12-22 19:31:13.3648 AlertProcessor ProcessorAlertData: started 2025-12-22 19:35:09.9448 AlertProcessor ProcessorAlertData: Stopped 2025-12-22 19:35:09.9448 DFramework.Scheduler.TaskBase /* Time Taken: 236579.9363*/ Process Alert Record 2025-12-22 19:36:02.7264 DFramework.Database.Query /* Time Taken: 1085*/ [dbo].GenerateSystemAlerts 2025-12-22 19:36:04.0858 MoveToReorder Running task for ClientId : 286 and ClientName = India Office QA and Slot: 12/23/2025 9:00:00 AM And LastExecutedOn: 12/23/2025 8:06:04 AM 2025-12-22 19:36:04.2733 MoveToReorder Task executed successfully for ClientId : 286 Client Name:India Office QA, Slot: 12/23/2025 9:00:00 AM But No Order found to suggest 2025-12-22 19:36:13.3671 AlertProcessor ProcessorAlertData: started 2025-12-22 19:36:16.4296 DFramework.Scheduler.TaskBase /* Time Taken: 15531.3638*/ Opportunity Out Of Stock By Outlet 2025-12-22 19:40:09.9470 AlertProcessor ProcessorAlertData: Stopped 2025-12-22 19:40:09.9470 DFramework.Scheduler.TaskBase /* Time Taken: 236579.8438*/ Process Alert Record 2025-12-22 19:41:13.3693 AlertProcessor ProcessorAlertData: started 2025-12-22 19:45:10.1991 AlertProcessor ProcessorAlertData: Stopped 2025-12-22 19:45:10.1991 DFramework.Scheduler.TaskBase /* Time Taken: 236829.7922*/ Process Alert Record 2025-12-22 19:46:13.3870 AlertProcessor ProcessorAlertData: started 2025-12-22 19:50:10.0450 AlertProcessor ProcessorAlertData: Stopped 2025-12-22 19:50:10.0450 DFramework.Scheduler.TaskBase /* Time Taken: 236657.9807*/ Process Alert Record 2025-12-22 19:51:02.9829 DFramework.Database.Query /* Time Taken: 1318*/ [dbo].GenerateSystemAlerts 2025-12-22 19:51:13.3893 AlertProcessor ProcessorAlertData: started 2025-12-22 19:51:16.3424 DFramework.Database.Query /* Time Taken: 1660*/ 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-22 19:51:16.4362 DFramework.Scheduler.TaskBase /* Time Taken: 15531.3563*/ Opportunity Out Of Stock By Outlet 2025-12-22 19:55:10.1099 AlertProcessor ProcessorAlertData: Stopped 2025-12-22 19:55:10.1099 DFramework.Scheduler.TaskBase /* Time Taken: 236720.5745*/ Process Alert Record 2025-12-22 19:56:13.4072 AlertProcessor ProcessorAlertData: started 2025-12-22 20:00:09.9089 AlertProcessor ProcessorAlertData: Stopped 2025-12-22 20:00:09.9089 DFramework.Scheduler.TaskBase /* Time Taken: 236501.694*/ Process Alert Record 2025-12-22 20:01:13.4093 AlertProcessor ProcessorAlertData: started 2025-12-22 20:05:09.8485 AlertProcessor ProcessorAlertData: Stopped 2025-12-22 20:05:09.8485 DFramework.Scheduler.TaskBase /* Time Taken: 236439.1547*/ Process Alert Record 2025-12-22 20:06:02.9583 DFramework.Database.Query /* Time Taken: 1280*/ [dbo].GenerateSystemAlerts 2025-12-22 20:06:13.4271 AlertProcessor ProcessorAlertData: started 2025-12-22 20:06:16.4584 DFramework.Scheduler.TaskBase /* Time Taken: 15531.3552*/ Opportunity Out Of Stock By Outlet 2025-12-22 20:10:09.9290 AlertProcessor ProcessorAlertData: Stopped 2025-12-22 20:10:09.9290 DFramework.Scheduler.TaskBase /* Time Taken: 236501.895*/ Process Alert Record 2025-12-22 20:11:13.4451 AlertProcessor ProcessorAlertData: started 2025-12-22 20:15:09.9937 AlertProcessor ProcessorAlertData: Stopped 2025-12-22 20:15:09.9937 DFramework.Scheduler.TaskBase /* Time Taken: 236548.6108*/ Process Alert Record 2025-12-22 20:16:13.4629 AlertProcessor ProcessorAlertData: started 2025-12-22 20:20:09.9490 AlertProcessor ProcessorAlertData: Stopped 2025-12-22 20:20:09.9490 DFramework.Scheduler.TaskBase /* Time Taken: 236486.0388*/ Process Alert Record 2025-12-22 20:21:02.7462 DFramework.Database.Query /* Time Taken: 1042*/ [dbo].GenerateSystemAlerts 2025-12-22 20:21:13.4806 AlertProcessor ProcessorAlertData: started 2025-12-22 20:21:16.4650 DFramework.Scheduler.TaskBase /* Time Taken: 15515.7296*/ Opportunity Out Of Stock By Outlet 2025-12-22 20:22:19.6061 DFramework.Database.NullableDataReader Data reader open for 250 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 251 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-22 20:25:10.2012 AlertProcessor ProcessorAlertData: Stopped 2025-12-22 20:25:10.2012 DFramework.Scheduler.TaskBase /* Time Taken: 236720.5876*/ Process Alert Record 2025-12-22 20:26:13.4986 AlertProcessor ProcessorAlertData: started 2025-12-22 20:30:10.2036 AlertProcessor ProcessorAlertData: Stopped 2025-12-22 20:30:10.2036 DFramework.Scheduler.TaskBase /* Time Taken: 236704.9573*/ Process Alert Record 2025-12-22 20:31:13.5166 AlertProcessor ProcessorAlertData: started 2025-12-22 20:31:16.5478 DFramework.Database.Query /* Time Taken: 693*/ 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,1494,430,286,414,395,471,360,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-22 20:32:39.3297 DFramework.Scheduler.TaskBase /* Time Taken: 84531.863*/ Alert Summary Mail 2025-12-22 20:35:51.6436 AlertProcessor ProcessorAlertData: Stopped 2025-12-22 20:35:51.6436 DFramework.Scheduler.TaskBase /* Time Taken: 278126.9941*/ Process Alert Record 2025-12-22 20:36:02.7843 DFramework.Database.Query /* Time Taken: 1047*/ [dbo].GenerateSystemAlerts 2025-12-22 20:36:04.1905 MoveToReorder Running task for ClientId : 286 and ClientName = India Office QA and Slot: 12/23/2025 10:00:00 AM And LastExecutedOn: 12/23/2025 9:06:04 AM 2025-12-22 20:36:04.5030 MoveToReorder Task executed successfully for ClientId : 286 Client Name:India Office QA, Slot: 12/23/2025 10:00:00 AM But No Order found to suggest 2025-12-22 20:36:13.5187 AlertProcessor ProcessorAlertData: started 2025-12-22 20:36:16.6437 DFramework.Scheduler.TaskBase /* Time Taken: 15671.9813*/ Opportunity Out Of Stock By Outlet 2025-12-22 20:40:10.1297 AlertProcessor ProcessorAlertData: Stopped 2025-12-22 20:40:10.1297 DFramework.Scheduler.TaskBase /* Time Taken: 236611.0297*/ Process Alert Record 2025-12-22 20:41:13.5208 AlertProcessor ProcessorAlertData: started 2025-12-22 20:45:09.8664 AlertProcessor ProcessorAlertData: Stopped 2025-12-22 20:45:09.8664 DFramework.Scheduler.TaskBase /* Time Taken: 236345.5683*/ Process Alert Record 2025-12-22 20:46:13.5387 AlertProcessor ProcessorAlertData: started 2025-12-22 20:50:10.0092 AlertProcessor ProcessorAlertData: Stopped 2025-12-22 20:50:10.0092 DFramework.Scheduler.TaskBase /* Time Taken: 236470.4462*/ Process Alert Record 2025-12-22 20:51:02.7596 DFramework.Database.Query /* Time Taken: 1017*/ [dbo].GenerateSystemAlerts 2025-12-22 20:51:13.5565 AlertProcessor ProcessorAlertData: started 2025-12-22 20:51:16.4940 DFramework.Scheduler.TaskBase /* Time Taken: 15515.7333*/ Opportunity Out Of Stock By Outlet 2025-12-22 20:55:10.0113 AlertProcessor ProcessorAlertData: Stopped 2025-12-22 20:55:10.0113 DFramework.Scheduler.TaskBase /* Time Taken: 236454.7776*/ Process Alert Record 2025-12-22 20:56:13.5586 AlertProcessor ProcessorAlertData: started 2025-12-22 21:00:09.9508 AlertProcessor ProcessorAlertData: Stopped 2025-12-22 21:00:09.9508 DFramework.Scheduler.TaskBase /* Time Taken: 236392.1592*/ Process Alert Record 2025-12-22 21:01:13.5605 AlertProcessor ProcessorAlertData: started 2025-12-22 21:05:10.0309 AlertProcessor ProcessorAlertData: Stopped 2025-12-22 21:05:10.0309 DFramework.Scheduler.TaskBase /* Time Taken: 236470.3355*/ Process Alert Record 2025-12-22 21:06:02.7969 DFramework.Database.Query /* Time Taken: 1043*/ [dbo].GenerateSystemAlerts 2025-12-22 21:06:13.5626 AlertProcessor ProcessorAlertData: started 2025-12-22 21:06:16.5157 DFramework.Scheduler.TaskBase /* Time Taken: 15531.3514*/ Opportunity Out Of Stock By Outlet 2025-12-22 21:10:09.8611 AlertProcessor ProcessorAlertData: Stopped 2025-12-22 21:10:09.8611 DFramework.Scheduler.TaskBase /* Time Taken: 236298.5278*/ Process Alert Record 2025-12-22 21:11:13.5647 AlertProcessor ProcessorAlertData: started 2025-12-22 21:15:10.0195 AlertProcessor ProcessorAlertData: Stopped 2025-12-22 21:15:10.0195 DFramework.Scheduler.TaskBase /* Time Taken: 236454.8263*/ Process Alert Record 2025-12-22 21:16:13.5670 AlertProcessor ProcessorAlertData: started 2025-12-22 21:19:27.4126 DFramework.Database.NullableDataReader Data reader open for 251 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 251 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-22 21:20:10.1004 AlertProcessor ProcessorAlertData: Stopped 2025-12-22 21:20:10.1004 DFramework.Scheduler.TaskBase /* Time Taken: 236533.3863*/ Process Alert Record 2025-12-22 21:21:03.0696 DFramework.Database.Query /* Time Taken: 1296*/ [dbo].GenerateSystemAlerts 2025-12-22 21:21:13.5853 AlertProcessor ProcessorAlertData: started 2025-12-22 21:21:16.5228 DFramework.Scheduler.TaskBase /* Time Taken: 15531.3736*/ Opportunity Out Of Stock By Outlet 2025-12-22 21:25:09.9465 AlertProcessor ProcessorAlertData: Stopped 2025-12-22 21:25:09.9465 DFramework.Scheduler.TaskBase /* Time Taken: 236361.159*/ Process Alert Record 2025-12-22 21:26:13.6032 AlertProcessor ProcessorAlertData: started 2025-12-22 21:30:10.0736 AlertProcessor ProcessorAlertData: Stopped 2025-12-22 21:30:10.0736 DFramework.Scheduler.TaskBase /* Time Taken: 236470.442*/ Process Alert Record 2025-12-22 21:31:13.6210 AlertProcessor ProcessorAlertData: started 2025-12-22 21:31:58.0744 DFramework.Database.Query /* Time Taken: 537*/ DECLARE @TableName AnsiString(8000) SET @TableName = 'OpportunityOutOfStockConsolidate' DECLARE @CurrentRecordId Int32 SET @CurrentRecordId = '3674833' dbo.GetValidDeviceForAlertProcessData 2025-12-22 21:35:10.6541 AlertProcessor ProcessorAlertData: Stopped 2025-12-22 21:35:10.6541 DFramework.Scheduler.TaskBase /* Time Taken: 237033.1575*/ Process Alert Record 2025-12-22 21:36:03.4514 DFramework.Database.Query /* Time Taken: 1649*/ [dbo].GenerateSystemAlerts 2025-12-22 21:36:04.8733 MoveToReorder Running task for ClientId : 286 and ClientName = India Office QA and Slot: 12/23/2025 11:00:00 AM And LastExecutedOn: 12/23/2025 10:06:04 AM 2025-12-22 21:36:13.6390 AlertProcessor ProcessorAlertData: started 2025-12-22 21:36:15.8577 DFramework.Database.Query /* Time Taken: 902*/ 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-22 21:36:15.9515 DFramework.Database.Query /* Time Taken: 1032*/ DECLARE @TableName AnsiString(8000) SET @TableName = 'OpportunityOutOfStock' DECLARE @CurrentRecordId Int32 SET @CurrentRecordId = '3674833' dbo.GetValidDeviceForAlertProcessData 2025-12-22 21:36:16.5765 DFramework.Scheduler.TaskBase /* Time Taken: 15562.6166*/ Opportunity Out Of Stock By Outlet 2025-12-22 21:36:37.5610 DFramework.Database.Query /* Time Taken: 527*/ DECLARE @TableName AnsiString(8000) SET @TableName = 'PlanogramComplianceConsolidate' DECLARE @CurrentRecordId Int32 SET @CurrentRecordId = '3674833' dbo.GetValidDeviceForAlertProcessData 2025-12-22 21:36:44.4673 DFramework.Database.NullableDataReader Data reader open for 39287 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-22 21:36:44.4986 MoveToReorder Task executed successfully for ClientId : 286 Client Name:India Office QA, Slot: 12/23/2025 11:00:00 AM and Total Order Suggested: 120 Out Of: 120 2025-12-22 21:36:45.2173 DFramework.Scheduler.TaskBase /* Time Taken: 41265.9377*/ Move To Re-Order 2025-12-22 21:40:11.4064 AlertProcessor ProcessorAlertData: Stopped 2025-12-22 21:40:11.4064 DFramework.Scheduler.TaskBase /* Time Taken: 237767.3904*/ Process Alert Record 2025-12-22 21:41:13.6568 AlertProcessor ProcessorAlertData: started 2025-12-22 21:45:10.2991 AlertProcessor ProcessorAlertData: Stopped 2025-12-22 21:45:10.2991 DFramework.Scheduler.TaskBase /* Time Taken: 236642.3341*/ Process Alert Record 2025-12-22 21:46:04.5652 DFramework.Database.Query /* Time Taken: 604*/ 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-22 21:46:13.6746 AlertProcessor ProcessorAlertData: started 2025-12-22 21:50:10.3014 AlertProcessor ProcessorAlertData: Stopped 2025-12-22 21:50:10.3014 DFramework.Scheduler.TaskBase /* Time Taken: 236626.7531*/ Process Alert Record 2025-12-22 21:51:03.7549 DFramework.Database.Query /* Time Taken: 1936*/ [dbo].GenerateSystemAlerts 2025-12-22 21:51:13.6769 AlertProcessor ProcessorAlertData: started 2025-12-22 21:51:16.5988 DFramework.Scheduler.TaskBase /* Time Taken: 15562.6186*/ Opportunity Out Of Stock By Outlet 2025-12-22 21:55:10.4755 AlertProcessor ProcessorAlertData: Stopped 2025-12-22 21:55:10.4755 DFramework.Scheduler.TaskBase /* Time Taken: 236798.6606*/ Process Alert Record 2025-12-22 21:56:13.6947 AlertProcessor ProcessorAlertData: started 2025-12-22 22:00:10.4621 AlertProcessor ProcessorAlertData: Stopped 2025-12-22 22:00:10.4621 DFramework.Scheduler.TaskBase /* Time Taken: 236767.3153*/ Process Alert Record 2025-12-22 22:01:13.7125 AlertProcessor ProcessorAlertData: started 2025-12-22 22:05:10.4486 AlertProcessor ProcessorAlertData: Stopped 2025-12-22 22:05:10.4486 DFramework.Scheduler.TaskBase /* Time Taken: 236736.0557*/ Process Alert Record 2025-12-22 22:06:03.7615 DFramework.Database.Query /* Time Taken: 1917*/ [dbo].GenerateSystemAlerts 2025-12-22 22:06:13.7147 AlertProcessor ProcessorAlertData: started 2025-12-22 22:06:16.8084 DFramework.Scheduler.TaskBase /* Time Taken: 15750.1191*/ Opportunity Out Of Stock By Outlet 2025-12-22 22:08:02.5749 DFramework.Database.Query /* Time Taken: 610*/ DECLARE @TableName AnsiString(8000) SET @TableName = 'AssetPurity' DECLARE @CurrentRecordId Int32 SET @CurrentRecordId = '3674833' dbo.GetValidDeviceForAlertProcessData 2025-12-22 22:10:10.6697 AlertProcessor ProcessorAlertData: Stopped 2025-12-22 22:10:10.6697 DFramework.Scheduler.TaskBase /* Time Taken: 236954.9917*/ Process Alert Record 2025-12-22 22:11:13.7326 AlertProcessor ProcessorAlertData: started 2025-12-22 22:15:10.2969 AlertProcessor ProcessorAlertData: Stopped 2025-12-22 22:15:10.2969 DFramework.Scheduler.TaskBase /* Time Taken: 236564.2547*/ Process Alert Record 2025-12-22 22:16:13.7504 AlertProcessor ProcessorAlertData: started 2025-12-22 22:20:10.4709 AlertProcessor ProcessorAlertData: Stopped 2025-12-22 22:20:10.4709 DFramework.Scheduler.TaskBase /* Time Taken: 236720.4654*/ Process Alert Record 2025-12-22 22:21:03.9244 DFramework.Database.Query /* Time Taken: 2061*/ [dbo].GenerateSystemAlerts 2025-12-22 22:21:13.7682 AlertProcessor ProcessorAlertData: started 2025-12-22 22:21:16.7995 DFramework.Scheduler.TaskBase /* Time Taken: 15718.8609*/ Opportunity Out Of Stock By Outlet 2025-12-22 22:25:10.4886 AlertProcessor ProcessorAlertData: Stopped 2025-12-22 22:25:10.4886 DFramework.Scheduler.TaskBase /* Time Taken: 236720.432*/ Process Alert Record 2025-12-22 22:26:13.7703 AlertProcessor ProcessorAlertData: started 2025-12-22 22:30:10.2251 AlertProcessor ProcessorAlertData: Stopped 2025-12-22 22:30:10.2251 DFramework.Scheduler.TaskBase /* Time Taken: 236454.8058*/ Process Alert Record 2025-12-22 22:31:13.7881 AlertProcessor ProcessorAlertData: started 2025-12-22 22:35:10.4773 AlertProcessor ProcessorAlertData: Stopped 2025-12-22 22:35:10.4773 DFramework.Scheduler.TaskBase /* Time Taken: 236689.1796*/ Process Alert Record 2025-12-22 22:36:04.4152 MoveToReorder Running task for ClientId : 286 and ClientName = India Office QA and Slot: 12/23/2025 12:00:00 PM And LastExecutedOn: 12/23/2025 11:06:04 AM 2025-12-22 22:36:04.6495 MoveToReorder Task executed successfully for ClientId : 286 Client Name:India Office QA, Slot: 12/23/2025 12:00:00 PM But No Order found to suggest 2025-12-22 22:36:05.1183 DFramework.Database.Query /* Time Taken: 3222*/ [dbo].GenerateSystemAlerts 2025-12-22 22:36:13.7902 AlertProcessor ProcessorAlertData: started 2025-12-22 22:36:16.7277 DFramework.Scheduler.TaskBase /* Time Taken: 15625.113*/ Opportunity Out Of Stock By Outlet 2025-12-22 22:40:10.2763 AlertProcessor ProcessorAlertData: Stopped 2025-12-22 22:40:10.2763 DFramework.Scheduler.TaskBase /* Time Taken: 236486.0544*/ Process Alert Record 2025-12-22 22:41:13.7924 AlertProcessor ProcessorAlertData: started 2025-12-22 22:45:10.3566 AlertProcessor ProcessorAlertData: Stopped 2025-12-22 22:45:10.3566 DFramework.Scheduler.TaskBase /* Time Taken: 236564.1798*/ Process Alert Record 2025-12-22 22:46:13.8101 AlertProcessor ProcessorAlertData: started 2025-12-22 22:50:10.3274 AlertProcessor ProcessorAlertData: Stopped 2025-12-22 22:50:10.3274 DFramework.Scheduler.TaskBase /* Time Taken: 236517.3038*/ Process Alert Record 2025-12-22 22:51:04.8122 DFramework.Database.Query /* Time Taken: 2918*/ [dbo].GenerateSystemAlerts 2025-12-22 22:51:13.8279 AlertProcessor ProcessorAlertData: started 2025-12-22 22:51:16.2654 DFramework.Database.Query /* Time Taken: 1069*/ 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-22 22:51:16.7967 DFramework.Scheduler.TaskBase /* Time Taken: 15687.6136*/ Opportunity Out Of Stock By Outlet 2025-12-22 22:55:10.3764 AlertProcessor ProcessorAlertData: Stopped 2025-12-22 22:55:10.3764 DFramework.Scheduler.TaskBase /* Time Taken: 236548.5591*/ Process Alert Record 2025-12-22 22:56:13.8300 AlertProcessor ProcessorAlertData: started 2025-12-22 23:00:10.1286 AlertProcessor ProcessorAlertData: Stopped 2025-12-22 23:00:10.1286 DFramework.Scheduler.TaskBase /* Time Taken: 236298.5566*/ Process Alert Record 2025-12-22 23:01:13.8322 AlertProcessor ProcessorAlertData: started 2025-12-22 23:05:10.4901 AlertProcessor ProcessorAlertData: Stopped 2025-12-22 23:05:10.4901 DFramework.Scheduler.TaskBase /* Time Taken: 236657.9185*/ Process Alert Record 2025-12-22 23:06:07.0999 DFramework.Database.Query /* Time Taken: 2850*/ DECLARE @OrderStatusId Int32 SET @OrderStatusId = '5484' 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.HoursToMoveInTransit > 0 WHERE DATEADD(HOUR, Client.HoursToMoveInTransit, ScheduledOrder.ModifiedOn) < GETUTCDATE() AND ScheduledOrder.StatusId = @OrderStatusId ANd Location.IsDeleted = 0 AND ScheduledOrder.IsDeleted = 0 2025-12-22 23:06:07.2717 DFramework.Database.Query /* Time Taken: 5343*/ [dbo].GenerateSystemAlerts 2025-12-22 23:06:13.8499 AlertProcessor ProcessorAlertData: started 2025-12-22 23:06:16.8499 DFramework.Scheduler.TaskBase /* Time Taken: 15734.483*/ Opportunity Out Of Stock By Outlet 2025-12-22 23:06:28.2250 DFramework.Scheduler.TaskBase /* Time Taken: 24109.5459*/ Move To Re-Order 2025-12-22 23:10:23.1329 AlertProcessor ProcessorAlertData: Stopped 2025-12-22 23:10:23.1329 DFramework.Scheduler.TaskBase /* Time Taken: 249283.0182*/ Process Alert Record 2025-12-22 23:11:13.8677 AlertProcessor ProcessorAlertData: started 2025-12-22 23:12:19.1337 DFramework.Database.Query /* Time Taken: 525*/ DECLARE @TableName AnsiString(8000) SET @TableName = 'PlanogramComplianceConsolidate' DECLARE @CurrentRecordId Int32 SET @CurrentRecordId = '3674850' dbo.GetValidDeviceForAlertProcessData 2025-12-22 23:16:34.9013 AlertProcessor ProcessorAlertData: Stopped 2025-12-22 23:17:17.0266 DFramework.Scheduler.TaskBase /* Time Taken: 363158.987*/ Process Alert Record 2025-12-22 23:21:03.8252 DFramework.Database.Query /* Time Taken: 1877*/ [dbo].GenerateSystemAlerts 2025-12-22 23:21:13.8878 AlertProcessor ProcessorAlertData: started 2025-12-22 23:21:17.0597 DFramework.Scheduler.TaskBase /* Time Taken: 15937.6181*/ Opportunity Out Of Stock By Outlet 2025-12-22 23:26:34.7338 AlertProcessor ProcessorAlertData: Stopped 2025-12-22 23:27:16.8748 DFramework.Scheduler.TaskBase /* Time Taken: 362986.9892*/ Process Alert Record 2025-12-22 23:31:13.9077 AlertProcessor ProcessorAlertData: started 2025-12-22 23:35:10.7688 AlertProcessor ProcessorAlertData: Stopped 2025-12-22 23:35:10.7688 DFramework.Scheduler.TaskBase /* Time Taken: 236861.0766*/ Process Alert Record 2025-12-22 23:36:04.2848 DFramework.Database.Query /* Time Taken: 2321*/ [dbo].GenerateSystemAlerts 2025-12-22 23:36:04.5192 MoveToReorder Running task for ClientId : 286 and ClientName = India Office QA and Slot: 12/23/2025 1:00:00 PM And LastExecutedOn: 12/23/2025 12:06:04 PM 2025-12-22 23:36:04.7379 MoveToReorder Task executed successfully for ClientId : 286 Client Name:India Office QA, Slot: 12/23/2025 1:00:00 PM But No Order found to suggest 2025-12-22 23:36:13.9255 AlertProcessor ProcessorAlertData: started 2025-12-22 23:36:16.8943 DFramework.Scheduler.TaskBase /* Time Taken: 15765.7361*/ Opportunity Out Of Stock By Outlet 2025-12-22 23:40:10.5834 AlertProcessor ProcessorAlertData: Stopped 2025-12-22 23:40:10.5834 DFramework.Scheduler.TaskBase /* Time Taken: 236657.9593*/ Process Alert Record 2025-12-22 23:41:13.9276 AlertProcessor ProcessorAlertData: started 2025-12-22 23:45:10.4606 AlertProcessor ProcessorAlertData: Stopped 2025-12-22 23:45:10.4606 DFramework.Scheduler.TaskBase /* Time Taken: 236532.9424*/ Process Alert Record 2025-12-22 23:46:13.9454 AlertProcessor ProcessorAlertData: started 2025-12-22 23:50:10.4629 AlertProcessor ProcessorAlertData: Stopped 2025-12-22 23:50:10.4629 DFramework.Scheduler.TaskBase /* Time Taken: 236517.4887*/ Process Alert Record 2025-12-22 23:51:03.7758 DFramework.Database.Query /* Time Taken: 1789*/ [dbo].GenerateSystemAlerts 2025-12-22 23:51:13.9634 AlertProcessor ProcessorAlertData: started 2025-12-22 23:51:15.9009 DFramework.Database.Query /* Time Taken: 516*/ 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-22 23:51:15.9634 DFramework.Database.Query /* Time Taken: 703*/ DECLARE @TableName AnsiString(8000) SET @TableName = 'OpportunityOutOfStock' DECLARE @CurrentRecordId Int32 SET @CurrentRecordId = '3674851' dbo.GetValidDeviceForAlertProcessData 2025-12-22 23:51:16.9478 DFramework.Scheduler.TaskBase /* Time Taken: 15812.6292*/ Opportunity Out Of Stock By Outlet 2025-12-22 23:55:10.8247 AlertProcessor ProcessorAlertData: Stopped 2025-12-22 23:55:10.8403 DFramework.Scheduler.TaskBase /* Time Taken: 236876.8576*/ Process Alert Record 2025-12-22 23:56:13.9814 AlertProcessor ProcessorAlertData: started