2025-12-26 00:00:24.6105 AlertProcessor ProcessorAlertData: started 2025-12-26 00:00:26.0324 DFramework.Database.Query /* Time Taken: 574*/ DECLARE @TableName AnsiString(8000) SET @TableName = 'MissingShelf' DECLARE @CurrentRecordId Int32 SET @CurrentRecordId = '3675104' dbo.GetValidDeviceForAlertProcessData 2025-12-26 00:00:26.6886 DFramework.Database.Query /* Time Taken: 594*/ DECLARE @TableName AnsiString(8000) SET @TableName = 'AdditionalShelf' DECLARE @CurrentRecordId Int32 SET @CurrentRecordId = '3675104' dbo.GetValidDeviceForAlertProcessData 2025-12-26 00:00:26.7199 DFramework.Database.Query /* Time Taken: 1843*/ [dbo].GenerateSystemAlerts 2025-12-26 00:00:28.3293 DFramework.Database.Query /* Time Taken: 648*/ DECLARE @TableName AnsiString(8000) SET @TableName = 'AssetStockProductWiseConsolidate' DECLARE @CurrentRecordId Int32 SET @CurrentRecordId = '3675104' dbo.GetValidDeviceForAlertProcessData 2025-12-26 00:00:31.0012 AlertProcessor ProcessorAlertData: Stopped 2025-12-26 00:00:40.2981 DFramework.Scheduler.TaskBase /* Time Taken: 15796.9799*/ Opportunity Out Of Stock By Outlet 2025-12-26 00:05:24.6285 AlertProcessor ProcessorAlertData: started 2025-12-26 00:05:30.3160 AlertProcessor ProcessorAlertData: Stopped 2025-12-26 00:10:24.6465 AlertProcessor ProcessorAlertData: started 2025-12-26 00:10:30.1934 AlertProcessor ProcessorAlertData: Stopped 2025-12-26 00:15:24.6642 AlertProcessor ProcessorAlertData: started 2025-12-26 00:15:25.5861 DFramework.Database.Query /* Time Taken: 578*/ 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-26 00:15:26.2736 DFramework.Database.Query /* Time Taken: 642*/ DECLARE @TableName AnsiString(8000) SET @TableName = 'MissingShelf' DECLARE @CurrentRecordId Int32 SET @CurrentRecordId = '3675104' dbo.GetValidDeviceForAlertProcessData 2025-12-26 00:15:26.8673 DFramework.Database.Query /* Time Taken: 542*/ DECLARE @TableName AnsiString(8000) SET @TableName = 'AdditionalShelf' DECLARE @CurrentRecordId Int32 SET @CurrentRecordId = '3675104' dbo.GetValidDeviceForAlertProcessData 2025-12-26 00:15:26.9142 DFramework.Database.Query /* Time Taken: 2000*/ [dbo].GenerateSystemAlerts 2025-12-26 00:15:31.3986 AlertProcessor ProcessorAlertData: Stopped 2025-12-26 00:15:40.3987 DFramework.Scheduler.TaskBase /* Time Taken: 15890.723*/ Opportunity Out Of Stock By Outlet 2025-12-26 00:20:24.6818 AlertProcessor ProcessorAlertData: started 2025-12-26 00:20:30.3537 AlertProcessor ProcessorAlertData: Stopped 2025-12-26 00:25:24.7001 AlertProcessor ProcessorAlertData: started 2025-12-26 00:25:30.3876 AlertProcessor ProcessorAlertData: Stopped 2025-12-26 00:30:24.7179 AlertProcessor ProcessorAlertData: started 2025-12-26 00:30:26.1085 DFramework.Database.Query /* Time Taken: 598*/ DECLARE @TableName AnsiString(8000) SET @TableName = 'MissingShelf' DECLARE @CurrentRecordId Int32 SET @CurrentRecordId = '3675104' dbo.GetValidDeviceForAlertProcessData 2025-12-26 00:30:26.7023 DFramework.Database.Query /* Time Taken: 544*/ DECLARE @TableName AnsiString(8000) SET @TableName = 'AdditionalShelf' DECLARE @CurrentRecordId Int32 SET @CurrentRecordId = '3675104' dbo.GetValidDeviceForAlertProcessData 2025-12-26 00:30:27.0148 DFramework.Database.Query /* Time Taken: 2088*/ [dbo].GenerateSystemAlerts 2025-12-26 00:30:28.1867 DFramework.Database.Query /* Time Taken: 506*/ DECLARE @TableName AnsiString(8000) SET @TableName = 'AssetStockProductWiseConsolidate' DECLARE @CurrentRecordId Int32 SET @CurrentRecordId = '3675104' dbo.GetValidDeviceForAlertProcessData 2025-12-26 00:30:28.8585 DFramework.Database.Query /* Time Taken: 612*/ DECLARE @TableName AnsiString(8000) SET @TableName = 'AssetStockProductWise' DECLARE @CurrentRecordId Int32 SET @CurrentRecordId = '3675104' dbo.GetValidDeviceForAlertProcessData 2025-12-26 00:30:31.1242 AlertProcessor ProcessorAlertData: Stopped 2025-12-26 00:30:40.2492 DFramework.Scheduler.TaskBase /* Time Taken: 15718.8562*/ Opportunity Out Of Stock By Outlet 2025-12-26 00:35:24.7355 AlertProcessor ProcessorAlertData: started 2025-12-26 00:35:25.3293 MoveToReorder Running task for ClientId : 286 and ClientName = India Office QA and Slot: 12/26/2025 2:00:00 PM And LastExecutedOn: 12/26/2025 1:05:25 PM 2025-12-26 00:35:26.0793 DFramework.Database.Query /* Time Taken: 678*/ DECLARE @OrderStatusId Int32 SET @OrderStatusId = '0' DECLARE @ClientId Int32 SET @ClientId = '286' dbo.GetOrderDetailsByClientId 2025-12-26 00:35:26.0793 DFramework.Database.Query /* Time Taken: 584*/ DECLARE @TableName AnsiString(8000) SET @TableName = 'MissingShelf' DECLARE @CurrentRecordId Int32 SET @CurrentRecordId = '3675104' dbo.GetValidDeviceForAlertProcessData 2025-12-26 00:35:26.7043 DFramework.Database.Query /* Time Taken: 1626*/ DECLARE @StatusId Int32 SET @StatusId = '1' DECLARE @AlertId Int32 SET @AlertId = '7571914' SELECT TOP 10000 Alert.AlertId, Alert.LocationId, Alert.RecordId, ISNULL(AlertDefinition.Name, Alert.AlertText) Name, Alert.AlertTypeId, Alert.AlertText, ISNULL(Location.Name, '') AS LocationName, AlertDefinition.ClientId, AlertRecipient.RoleId, CASE WHEN Alert.AlertTypeId IN (6,7) THEN CONVERT(VARCHAR(10), CAST(AlertAt AS DATE), 101) ELSE AlertAt END AS AlertAt, AlertType, Asset.SerialNumber, ISNULL(LocationAttribute.FirstRepId, 0) RepId, ClientUser.PrimaryPhone AS SalesRepPhone, ClientUser.PrimaryEmail AS SalesRepEmail, FirstName, LastName, PreferedNotificationTypeIds, AlertRecipientId, AlertRecipientAddress, AlertRecipientText, Alert.Tags, AlertRecipientTypeId, NotificationContactTypeId, TemplateId, AlertDefinition.AlertAgeThreshold, LastUpdatedOn, AlertRecipient.AlertAge, CASE WHEN Location.TimeZoneId IS NOT NULL AND Location.TimeZoneId > 0 THEN Location.TimeZoneId ELSE Client.TimeZoneId END AS TimeZoneId, AlertDefinition.IsSummarize, Alert.ClosedOn, AssetType.IsChestCooler, AlertDefinition.SnoozeForHours, Alert.SnoozeDateTime FROM Alert LEFT OUTER JOIN Asset ON Alert.AssetId = Asset.AssetId LEFT OUTER JOIN AlertType ON Alert.AlertTypeId = AlertType.AlertTypeId LEFT OUTER JOIN AlertDefinition ON Alert.AlertDefinitionId = AlertDefinition.AlertDefinitionId LEFT OUTER JOIN Location ON Location.LocationId = Alert.LocationId LEFT OUTER JOIN LocationAttribute ON LocationAttribute.LocationId = dbo.Location.LocationId LEFT OUTER JOIN ClientUser ON LocationAttribute.FirstRepId = ClientUser.ClientUserId AND ClientUser.IsDeleted = 0 LEFT OUTER JOIN AlertRecipient ON Alert.AlertDefinitionId = AlertRecipient.AlertDefinitionId AND AlertRecipient.IsDeleted= 0 LEFT OUTER JOIN Client ON Client.ClientId = Alert.ClientId LEFT OUTER JOIN AssetType ON dbo.Asset.AssetTypeId = dbo.AssetType.AssetTypeId WHERE (NOT EXISTS(SELECT 1 FROM dbo.EmailQueue INNER JOIN dbo.EmailRecipient ON EmailRecipient.EmailQueueId = EmailQueue.EmailQueueId WHERE AlertId = Alert.AlertId AND EmailRecipient.RecipientId = AlertRecipient.AlertRecipientId) OR (Alert.SnoozeDateTime IS NOT NULL AND Alert.SnoozeDateTime <= GETUTCDATE() AND AlertDefinition.SnoozeForHours > 0 AND Alert.StatusId = @StatusId)) AND Alert.AlertId > @AlertId AND Alert.AlertAt >= DATEADD(DAY, -120, GETDATE()) AND AlertRecipient.IsDeleted = 0 AND Alert.IsActive = 1 AND Alert.IsDeleted = 0 AND AlertRecipient.IsActive = 1 AND AlertRecipient.IsDeleted = 0 AND AlertRecipient.StartDate <= Alert.CreatedOn AND Alert.CreatedOn < DATEADD(hh, 23, AlertRecipient.EndDate) AND (Alert.LocationId != 0 OR NotificationWithoutLocation = 1) AND AlertType.IsSystemAlert = 0 AND Alert.EmailQueuedOn IS NULL AND AlertDefinition.IsActive = 1 2025-12-26 00:35:26.7043 DFramework.Database.Query /* Time Taken: 570*/ DECLARE @TableName AnsiString(8000) SET @TableName = 'AdditionalShelf' DECLARE @CurrentRecordId Int32 SET @CurrentRecordId = '3675104' dbo.GetValidDeviceForAlertProcessData 2025-12-26 00:35:30.9543 AlertProcessor ProcessorAlertData: Stopped 2025-12-26 00:36:06.9233 DFramework.Database.NullableDataReader Data reader open for 40747 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-26 00:36:06.9545 MoveToReorder Task executed successfully for ClientId : 286 Client Name:India Office QA, Slot: 12/26/2025 2:00:00 PM and Total Order Suggested: 128 Out Of: 128 2025-12-26 00:36:08.5171 DFramework.Scheduler.TaskBase /* Time Taken: 43609.6634*/ Move To Re-Order 2025-12-26 00:40:24.7538 AlertProcessor ProcessorAlertData: started 2025-12-26 00:40:27.3164 DFramework.Database.Query /* Time Taken: 651*/ DECLARE @TableName AnsiString(8000) SET @TableName = 'OpportunityOutOfStock' DECLARE @CurrentRecordId Int32 SET @CurrentRecordId = '3675104' dbo.GetValidDeviceForAlertProcessData 2025-12-26 00:40:30.9570 AlertProcessor ProcessorAlertData: Stopped 2025-12-26 00:45:24.7719 AlertProcessor ProcessorAlertData: started 2025-12-26 00:45:26.3032 DFramework.Database.Query /* Time Taken: 589*/ DECLARE @TableName AnsiString(8000) SET @TableName = 'MissingShelf' DECLARE @CurrentRecordId Int32 SET @CurrentRecordId = '3675104' dbo.GetValidDeviceForAlertProcessData 2025-12-26 00:45:26.9594 DFramework.Database.Query /* Time Taken: 593*/ DECLARE @TableName AnsiString(8000) SET @TableName = 'AdditionalShelf' DECLARE @CurrentRecordId Int32 SET @CurrentRecordId = '3675104' dbo.GetValidDeviceForAlertProcessData 2025-12-26 00:45:27.8969 DFramework.Database.Query /* Time Taken: 2937*/ [dbo].GenerateSystemAlerts 2025-12-26 00:45:28.4594 DFramework.Database.Query /* Time Taken: 530*/ DECLARE @TableName AnsiString(8000) SET @TableName = 'AssetStockProductWiseConsolidate' DECLARE @CurrentRecordId Int32 SET @CurrentRecordId = '3675104' dbo.GetValidDeviceForAlertProcessData 2025-12-26 00:45:31.0845 AlertProcessor ProcessorAlertData: Stopped 2025-12-26 00:45:40.6002 DFramework.Scheduler.TaskBase /* Time Taken: 16046.9886*/ Opportunity Out Of Stock By Outlet 2025-12-26 00:50:24.7896 AlertProcessor ProcessorAlertData: started 2025-12-26 00:50:30.4459 AlertProcessor ProcessorAlertData: Stopped 2025-12-26 00:55:24.8074 AlertProcessor ProcessorAlertData: started 2025-12-26 00:55:30.2137 DFramework.Database.Query /* Time Taken: 506*/ DECLARE @TableName AnsiString(8000) SET @TableName = 'ProductStockLevel' DECLARE @CurrentRecordId Int32 SET @CurrentRecordId = '3675104' dbo.GetValidDeviceForAlertProcessData 2025-12-26 00:55:30.2762 AlertProcessor ProcessorAlertData: Stopped 2025-12-26 01:00:24.8253 AlertProcessor ProcessorAlertData: started 2025-12-26 01:00:25.3409 DFramework.Database.Query /* Time Taken: 505*/ DECLARE @TableName AnsiString(8000) SET @TableName = 'TagAlert' DECLARE @CurrentRecordId Int32 SET @CurrentRecordId = '0' dbo.GetValidDeviceForAlertProcessData 2025-12-26 01:00:25.4347 DFramework.Database.Query /* Time Taken: 716*/ DECLARE @ClientId Int32 SET @ClientId = '213' 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 = '8/28/2025 12:00:00 AM' dbo.GetOpportunityOutOfStockDataByOutlet 2025-12-26 01:00:26.6690 DFramework.Database.Query /* Time Taken: 717*/ DECLARE @TableName AnsiString(8000) SET @TableName = 'MissingShelf' DECLARE @CurrentRecordId Int32 SET @CurrentRecordId = '3675104' dbo.GetValidDeviceForAlertProcessData 2025-12-26 01:00:27.3878 DFramework.Database.Query /* Time Taken: 669*/ DECLARE @TableName AnsiString(8000) SET @TableName = 'AdditionalShelf' DECLARE @CurrentRecordId Int32 SET @CurrentRecordId = '3675104' dbo.GetValidDeviceForAlertProcessData 2025-12-26 01:00:28.0909 DFramework.Database.Query /* Time Taken: 628*/ DECLARE @TableName AnsiString(8000) SET @TableName = 'OpportunityOutOfStock' DECLARE @CurrentRecordId Int32 SET @CurrentRecordId = '3675104' dbo.GetValidDeviceForAlertProcessData 2025-12-26 01:00:29.1691 DFramework.Database.Query /* Time Taken: 516*/ DECLARE @TableName AnsiString(8000) SET @TableName = 'OpportunityOutOfStockConsolidate' DECLARE @CurrentRecordId Int32 SET @CurrentRecordId = '3675104' dbo.GetValidDeviceForAlertProcessData 2025-12-26 01:00:29.8878 DFramework.Database.Query /* Time Taken: 657*/ DECLARE @TableName AnsiString(8000) SET @TableName = 'AssetStockProductWiseConsolidate' DECLARE @CurrentRecordId Int32 SET @CurrentRecordId = '3675104' dbo.GetValidDeviceForAlertProcessData 2025-12-26 01:00:30.4816 DFramework.Database.Query /* Time Taken: 5515*/ [dbo].GenerateSystemAlerts 2025-12-26 01:00:32.6691 AlertProcessor ProcessorAlertData: Stopped 2025-12-26 01:00:40.8410 DFramework.Scheduler.TaskBase /* Time Taken: 16265.7415*/ Opportunity Out Of Stock By Outlet 2025-12-26 01:05:24.8430 AlertProcessor ProcessorAlertData: started 2025-12-26 01:05:30.1399 AlertProcessor ProcessorAlertData: Stopped 2025-12-26 01:10:24.8606 AlertProcessor ProcessorAlertData: started 2025-12-26 01:10:29.3450 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-26 01:10:30.3763 AlertProcessor ProcessorAlertData: Stopped 2025-12-26 01:15:24.8787 AlertProcessor ProcessorAlertData: started 2025-12-26 01:15:26.4255 DFramework.Database.Query /* Time Taken: 570*/ DECLARE @TableName AnsiString(8000) SET @TableName = 'MissingShelf' DECLARE @CurrentRecordId Int32 SET @CurrentRecordId = '3675104' dbo.GetValidDeviceForAlertProcessData 2025-12-26 01:15:28.4881 DFramework.Database.Query /* Time Taken: 3487*/ [dbo].GenerateSystemAlerts 2025-12-26 01:15:30.7849 AlertProcessor ProcessorAlertData: Stopped 2025-12-26 01:15:40.4569 DFramework.Scheduler.TaskBase /* Time Taken: 15875.1225*/ Opportunity Out Of Stock By Outlet 2025-12-26 01:20:24.8965 AlertProcessor ProcessorAlertData: started 2025-12-26 01:20:30.3965 AlertProcessor ProcessorAlertData: Stopped 2025-12-26 01:25:24.9141 AlertProcessor ProcessorAlertData: started 2025-12-26 01:25:30.4766 AlertProcessor ProcessorAlertData: Stopped 2025-12-26 01:30:24.9164 AlertProcessor ProcessorAlertData: started 2025-12-26 01:30:26.3852 DFramework.Database.Query /* Time Taken: 639*/ DECLARE @TableName AnsiString(8000) SET @TableName = 'MissingShelf' DECLARE @CurrentRecordId Int32 SET @CurrentRecordId = '3675104' dbo.GetValidDeviceForAlertProcessData 2025-12-26 01:30:26.9789 DFramework.Database.Query /* Time Taken: 535*/ DECLARE @TableName AnsiString(8000) SET @TableName = 'AdditionalShelf' DECLARE @CurrentRecordId Int32 SET @CurrentRecordId = '3675104' dbo.GetValidDeviceForAlertProcessData 2025-12-26 01:30:27.1352 DFramework.Database.Query /* Time Taken: 2434*/ DECLARE @ClientId Int32 SET @ClientId = '213' 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 = '8/28/2025 12:00:00 AM' dbo.GetOpportunityOutOfStockDataByOutlet 2025-12-26 01:30:27.1508 DFramework.Database.Query /* Time Taken: 2134*/ [dbo].GenerateSystemAlerts 2025-12-26 01:30:30.3071 DFramework.Database.Query /* Time Taken: 501*/ DECLARE @TableName AnsiString(8000) SET @TableName = 'AssetStockProductCategoryWise' DECLARE @CurrentRecordId Int32 SET @CurrentRecordId = '3675104' dbo.GetValidDeviceForAlertProcessData 2025-12-26 01:30:31.4790 AlertProcessor ProcessorAlertData: Stopped 2025-12-26 01:30:42.5572 DFramework.Scheduler.TaskBase /* Time Taken: 17953.2994*/ Opportunity Out Of Stock By Outlet 2025-12-26 01:35:24.9345 AlertProcessor ProcessorAlertData: started 2025-12-26 01:35:25.8408 MoveToReorder Running task for ClientId : 286 and ClientName = India Office QA and Slot: 12/26/2025 3:00:00 PM And LastExecutedOn: 12/26/2025 2:05:25 PM 2025-12-26 01:35:26.6064 DFramework.Database.Query /* Time Taken: 698*/ DECLARE @OrderStatusId Int32 SET @OrderStatusId = '0' DECLARE @ClientId Int32 SET @ClientId = '286' dbo.GetOrderDetailsByClientId 2025-12-26 01:35:26.6377 MoveToReorder Task executed successfully for ClientId : 286 Client Name:India Office QA, Slot: 12/26/2025 3:00:00 PM But No Order found to suggest 2025-12-26 01:35:30.7627 DFramework.Database.Query /* Time Taken: 614*/ DECLARE @TableName AnsiString(8000) SET @TableName = 'ProductStockLevel' DECLARE @CurrentRecordId Int32 SET @CurrentRecordId = '3675104' dbo.GetValidDeviceForAlertProcessData 2025-12-26 01:35:30.8252 AlertProcessor ProcessorAlertData: Stopped 2025-12-26 01:40:24.9523 AlertProcessor ProcessorAlertData: started 2025-12-26 01:40:30.4367 AlertProcessor ProcessorAlertData: Stopped 2025-12-26 01:45:24.9699 AlertProcessor ProcessorAlertData: started 2025-12-26 01:45:26.7512 DFramework.Database.Query /* Time Taken: 779*/ DECLARE @TableName AnsiString(8000) SET @TableName = 'MissingShelf' DECLARE @CurrentRecordId Int32 SET @CurrentRecordId = '3675104' dbo.GetValidDeviceForAlertProcessData 2025-12-26 01:45:26.9856 DFramework.Database.Query /* Time Taken: 1937*/ [dbo].GenerateSystemAlerts 2025-12-26 01:45:31.1106 AlertProcessor ProcessorAlertData: Stopped 2025-12-26 01:45:40.3294 DFramework.Scheduler.TaskBase /* Time Taken: 15703.2256*/ Opportunity Out Of Stock By Outlet 2025-12-26 01:50:24.9882 AlertProcessor ProcessorAlertData: started 2025-12-26 01:50:30.4882 AlertProcessor ProcessorAlertData: Stopped 2025-12-26 01:55:25.0060 AlertProcessor ProcessorAlertData: started 2025-12-26 01:55:30.4279 AlertProcessor ProcessorAlertData: Stopped 2025-12-26 02:00:25.0237 AlertProcessor ProcessorAlertData: started 2025-12-26 02:00:26.5081 DFramework.Database.Query /* Time Taken: 571*/ DECLARE @TableName AnsiString(8000) SET @TableName = 'MissingShelf' DECLARE @CurrentRecordId Int32 SET @CurrentRecordId = '3675104' dbo.GetValidDeviceForAlertProcessData 2025-12-26 02:00:27.2268 DFramework.Database.Query /* Time Taken: 2178*/ [dbo].GenerateSystemAlerts 2025-12-26 02:00:31.4300 AlertProcessor ProcessorAlertData: Stopped 2025-12-26 02:00:40.7113 DFramework.Scheduler.TaskBase /* Time Taken: 16078.2295*/ Opportunity Out Of Stock By Outlet 2025-12-26 02:05:25.0417 AlertProcessor ProcessorAlertData: started 2025-12-26 02:05:26.1042 DFramework.Database.Query /* Time Taken: 689*/ DECLARE @TableName AnsiString(8000) SET @TableName = 'VoidAlert' DECLARE @CurrentRecordId Int32 SET @CurrentRecordId = '3675104' dbo.GetValidDeviceForAlertProcessData 2025-12-26 02:05:26.7292 DFramework.Database.Query /* Time Taken: 571*/ DECLARE @TableName AnsiString(8000) SET @TableName = 'MissingShelf' DECLARE @CurrentRecordId Int32 SET @CurrentRecordId = '3675104' dbo.GetValidDeviceForAlertProcessData 2025-12-26 02:05:27.2292 DFramework.Database.Query /* Time Taken: 1969*/ 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-26 02:05:31.3855 DFramework.Database.Query /* Time Taken: 608*/ DECLARE @TableName AnsiString(8000) SET @TableName = 'ProductStockLevel' DECLARE @CurrentRecordId Int32 SET @CurrentRecordId = '3675104' dbo.GetValidDeviceForAlertProcessData 2025-12-26 02:05:31.4324 AlertProcessor ProcessorAlertData: Stopped 2025-12-26 02:10:25.0597 AlertProcessor ProcessorAlertData: started 2025-12-26 02:10:30.7628 AlertProcessor ProcessorAlertData: Stopped 2025-12-26 02:15:25.0618 AlertProcessor ProcessorAlertData: started 2025-12-26 02:15:26.5774 DFramework.Database.Query /* Time Taken: 511*/ DECLARE @TableName AnsiString(8000) SET @TableName = 'MissingShelf' DECLARE @CurrentRecordId Int32 SET @CurrentRecordId = '3675104' dbo.GetValidDeviceForAlertProcessData 2025-12-26 02:15:27.1555 DFramework.Database.Query /* Time Taken: 530*/ DECLARE @TableName AnsiString(8000) SET @TableName = 'AdditionalShelf' DECLARE @CurrentRecordId Int32 SET @CurrentRecordId = '3675104' dbo.GetValidDeviceForAlertProcessData 2025-12-26 02:15:27.8899 DFramework.Database.Query /* Time Taken: 2839*/ [dbo].GenerateSystemAlerts 2025-12-26 02:15:28.8587 DFramework.Database.Query /* Time Taken: 671*/ DECLARE @TableName AnsiString(8000) SET @TableName = 'AssetStockProductWiseConsolidate' DECLARE @CurrentRecordId Int32 SET @CurrentRecordId = '3675104' dbo.GetValidDeviceForAlertProcessData 2025-12-26 02:15:29.4680 DFramework.Database.Query /* Time Taken: 546*/ DECLARE @TableName AnsiString(8000) SET @TableName = 'AssetStockProductWise' DECLARE @CurrentRecordId Int32 SET @CurrentRecordId = '3675104' dbo.GetValidDeviceForAlertProcessData 2025-12-26 02:15:31.7806 AlertProcessor ProcessorAlertData: Stopped 2025-12-26 02:15:40.4994 DFramework.Scheduler.TaskBase /* Time Taken: 15843.855*/ Opportunity Out Of Stock By Outlet 2025-12-26 02:20:25.0796 AlertProcessor ProcessorAlertData: started 2025-12-26 02:20:30.6889 AlertProcessor ProcessorAlertData: Stopped 2025-12-26 02:25:25.0821 AlertProcessor ProcessorAlertData: started 2025-12-26 02:25:30.6915 AlertProcessor ProcessorAlertData: Stopped 2025-12-26 02:30:25.0999 AlertProcessor ProcessorAlertData: started 2025-12-26 02:30:26.5999 DFramework.Database.Query /* Time Taken: 524*/ DECLARE @TableName AnsiString(8000) SET @TableName = 'MissingShelf' DECLARE @CurrentRecordId Int32 SET @CurrentRecordId = '3675104' dbo.GetValidDeviceForAlertProcessData 2025-12-26 02:30:27.9905 DFramework.Database.Query /* Time Taken: 2932*/ [dbo].GenerateSystemAlerts 2025-12-26 02:30:31.1312 AlertProcessor ProcessorAlertData: Stopped 2025-12-26 02:30:40.3969 DFramework.Scheduler.TaskBase /* Time Taken: 15718.8598*/ Opportunity Out Of Stock By Outlet 2025-12-26 02:35:39.0551 AlertProcessor ProcessorAlertData: started 2025-12-26 02:35:39.8520 DFramework.Database.Query /* Time Taken: 758*/ DECLARE @TableName AnsiString(8000) SET @TableName = 'TagAlert' DECLARE @CurrentRecordId Int32 SET @CurrentRecordId = '0' dbo.GetValidDeviceForAlertProcessData 2025-12-26 02:35:39.8676 DFramework.Database.Query /* Time Taken: 777*/ DECLARE @IsFileProcessed Int32 SET @IsFileProcessed = '0' DECLARE @TaskNumber Int32 SET @TaskNumber = '0' DECLARE @IsDeleted Int32 SET @IsDeleted = '0' SELECT TOP 1000 IncomingFileId, GatewayId,GatewayMac,RawFileName,AzureContainerName,StartIndex,Tries, CreatedOn FROM IncomingFile WHERE [IsFileProcessed] = @IsFileProcessed AND [TaskNumber] = @TaskNumber AND [IsDeleted] = @IsDeleted 2025-12-26 02:35:39.9145 DFramework.Database.Query /* Time Taken: 812*/ DECLARE @IsFileProcessed Int32 SET @IsFileProcessed = '0' DECLARE @TaskNumber Int32 SET @TaskNumber = '1' DECLARE @IsDeleted Int32 SET @IsDeleted = '0' SELECT TOP 1000 IncomingFileId, GatewayId,GatewayMac,RawFileName,AzureContainerName,StartIndex,Tries, CreatedOn FROM IncomingFile WHERE [IsFileProcessed] = @IsFileProcessed AND [TaskNumber] = @TaskNumber AND [IsDeleted] = @IsDeleted 2025-12-26 02:35:39.9458 DFramework.Database.Query /* Time Taken: 849*/ DECLARE @IsFileProcessed Int32 SET @IsFileProcessed = '0' DECLARE @TaskNumber Int32 SET @TaskNumber = '4' DECLARE @IsDeleted Int32 SET @IsDeleted = '0' SELECT TOP 1000 IncomingFileId, GatewayId,GatewayMac,RawFileName,AzureContainerName,StartIndex,Tries, CreatedOn FROM IncomingFile WHERE [IsFileProcessed] = @IsFileProcessed AND [TaskNumber] = @TaskNumber AND [IsDeleted] = @IsDeleted 2025-12-26 02:35:39.9770 DFramework.Database.Query /* Time Taken: 877*/ DECLARE @IsFileProcessed Int32 SET @IsFileProcessed = '0' DECLARE @TaskNumber Int32 SET @TaskNumber = '3' DECLARE @IsDeleted Int32 SET @IsDeleted = '0' SELECT TOP 1000 IncomingFileId, GatewayId,GatewayMac,RawFileName,AzureContainerName,StartIndex,Tries, CreatedOn FROM IncomingFile WHERE [IsFileProcessed] = @IsFileProcessed AND [TaskNumber] = @TaskNumber AND [IsDeleted] = @IsDeleted 2025-12-26 02:35:40.1020 DFramework.Database.Query /* Time Taken: 999*/ DECLARE @IsFileProcessed Int32 SET @IsFileProcessed = '0' DECLARE @TaskNumber Int32 SET @TaskNumber = '2' DECLARE @IsDeleted Int32 SET @IsDeleted = '0' SELECT TOP 1000 IncomingFileId, GatewayId,GatewayMac,RawFileName,AzureContainerName,StartIndex,Tries, CreatedOn FROM IncomingFile WHERE [IsFileProcessed] = @IsFileProcessed AND [TaskNumber] = @TaskNumber AND [IsDeleted] = @IsDeleted 2025-12-26 02:35:40.1176 DFramework.Database.Query /* Time Taken: 1012*/ DECLARE @AlertDefinition_IsActive Int32 SET @AlertDefinition_IsActive = '1' DECLARE @AlertDefinition_ClientId Int32 SET @AlertDefinition_ClientId = '213' DECLARE @AlertDefinition_AlertTypeId Int32 SET @AlertDefinition_AlertTypeId = '67' DECLARE @AlertDefinition_IsDeleted Int32 SET @AlertDefinition_IsDeleted = '0' DECLARE @AlertDefinition_StartDate DateTime2 SET @AlertDefinition_StartDate = '12/26/2025 10:35:39 AM' SELECT TOP 1 AlertDefinitionId, PriorityId FROM AlertDefinition WHERE AlertDefinition.IsActive = @AlertDefinition_IsActive AND AlertDefinition.ClientId = @AlertDefinition_ClientId AND AlertDefinition.AlertTypeId = @AlertDefinition_AlertTypeId AND AlertDefinition.IsDeleted = @AlertDefinition_IsDeleted AND AlertDefinition.StartDate <= @AlertDefinition_StartDate 2025-12-26 02:35:40.1333 DFramework.Database.Query /* Time Taken: 1022*/ 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-26 02:35:40.1645 DFramework.Database.Query /* Time Taken: 1047*/ DECLARE @CreatedOn DateTime2 SET @CreatedOn = '12/26/2025 12:00:00 AM' DECLARE @EventId Int32 SET @EventId = '-12' SELECT COUNT(1) FROM EmailQueue WHERE [CreatedOn] >= @CreatedOn AND [EventId] = @EventId 2025-12-26 02:35:40.1958 DFramework.Database.Query /* Time Taken: 1078*/ DECLARE @IsComplete Int32 SET @IsComplete = '0' SELECT TOP 1 ProductMergeTempId, PrimaryProductId, SecondaryProductId, dbo.Product.ClientId, dbo.ProductMergeTemp.UserId, [Product] AS ProductName FROM dbo.ProductMergeTemp INNER JOIN dbo.Product ON dbo.Product.ProductId = dbo.ProductMergeTemp.PrimaryProductId AND dbo.Product.ClientId = dbo.ProductMergeTemp.ClientId AND dbo.Product.IsDeleted = 0 WHERE [IsComplete] = @IsComplete 2025-12-26 02:35:40.2270 DFramework.Database.Query /* Time Taken: 1106*/ DECLARE @IsActive Int32 SET @IsActive = '1' DECLARE @FtpTypeId Int32 SET @FtpTypeId = '7766' DECLARE @ClientId Int32 SET @ClientId = '213' Select * from vwFTPClientList WHERE [IsActive] = @IsActive AND [FtpTypeId] = @FtpTypeId AND [ClientId] = @ClientId ORDER BY [ClientFtpId] 2025-12-26 02:35:40.2583 DFramework.Database.Query /* Time Taken: 924*/ DECLARE @AlertDefinitionId Int32 SET @AlertDefinitionId = '99' DECLARE @IsDeleted Boolean SET @IsDeleted = 'False' SELECT ProductId FROM AlertDefinitionProduct WHERE [AlertDefinitionId] = @AlertDefinitionId AND IsDeleted = @IsDeleted 2025-12-26 02:35:40.3364 DFramework.Database.Query /* Time Taken: 798*/ DECLARE @AssetKPIData Object SET @AssetKPIData = '' [dbo].BulkUpsertAssetDayKPI 2025-12-26 02:35:40.3676 DFramework.Database.Query /* Time Taken: 508*/ DECLARE @TableName AnsiString(8000) SET @TableName = 'TagAlert' SELECT TableName FROM AlertProcessor WHERE [TableName] = @TableName 2025-12-26 02:35:40.4301 DFramework.Database.NullableDataReader Data reader open for 571 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-26 02:35:40.4614 DFramework.Database.NullableDataReader Data reader open for 1118 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.ProcessOutletAlertData.GetAlertDefinitions() in D:\Spraxa\CoolR-Group\portal\CoolR.Tasks\OpportunityOutOfStockByOutlet.cs:line 490 at CoolR.Tasks.ProcessOutletAlertData.Execute() in D:\Spraxa\CoolR-Group\portal\CoolR.Tasks\OpportunityOutOfStockByOutlet.cs:line 72 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-26 02:35:40.4926 DFramework.Database.Query /* Time Taken: 1385*/ 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-26 02:35:40.6645 DFramework.Database.Query /* Time Taken: 529*/ DECLARE @ClientId Int32 SET @ClientId = '213' DECLARE @TaskName AnsiString(8000) SET @TaskName = 'PhotoIngestionAlertTask' SELECT TOP 1 Settings, TaskId, TaskName FROM dbo.Task WHERE [ClientId] = @ClientId AND [TaskName] = @TaskName ORDER BY [TaskId] DESC 2025-12-26 02:35:40.9926 DFramework.Database.Query /* Time Taken: 533*/ DECLARE @ClientId Int32 SET @ClientId = '213' 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 = '8/28/2025 12:00:00 AM' dbo.GetOpportunityOutOfStockDataByOutlet 2025-12-26 02:35:41.0083 MoveToReorder Running task for ClientId : 286 and ClientName = India Office QA and Slot: 12/26/2025 4:00:00 PM And LastExecutedOn: 12/26/2025 3:05:25 PM 2025-12-26 02:35:41.0083 DFramework.Database.Query /* Time Taken: 590*/ DECLARE @TableName AnsiString(8000) SET @TableName = 'VoidAlert' DECLARE @CurrentRecordId Int32 SET @CurrentRecordId = '3675104' dbo.GetValidDeviceForAlertProcessData 2025-12-26 02:35:41.6333 DFramework.Database.Query /* Time Taken: 553*/ DECLARE @TableName AnsiString(8000) SET @TableName = 'MissingShelf' DECLARE @CurrentRecordId Int32 SET @CurrentRecordId = '3675104' dbo.GetValidDeviceForAlertProcessData 2025-12-26 02:35:41.7426 DFramework.Database.Query /* Time Taken: 658*/ DECLARE @OrderStatusId Int32 SET @OrderStatusId = '0' DECLARE @ClientId Int32 SET @ClientId = '286' dbo.GetOrderDetailsByClientId 2025-12-26 02:35:42.5864 DFramework.Database.Query /* Time Taken: 3469*/ [dbo].GenerateSystemAlerts 2025-12-26 02:35:45.1802 DFramework.Database.Query /* Time Taken: 1589*/ DECLARE @TableName AnsiString(8000) SET @TableName = 'AssetStockProductWiseConsolidate' DECLARE @CurrentRecordId Int32 SET @CurrentRecordId = '3675104' dbo.GetValidDeviceForAlertProcessData 2025-12-26 02:35:47.8364 AlertProcessor ProcessorAlertData: Stopped 2025-12-26 02:35:56.4146 DFramework.Scheduler.TaskBase /* Time Taken: 17375.1186*/ Opportunity Out Of Stock By Outlet 2025-12-26 02:35:58.6959 DFramework.Database.NullableDataReader Data reader open for 16907 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-26 02:35:58.7271 MoveToReorder Task executed successfully for ClientId : 286 Client Name:India Office QA, Slot: 12/26/2025 4:00:00 PM and Total Order Suggested: 36 Out Of: 36 2025-12-26 02:35:59.5396 DFramework.Scheduler.TaskBase /* Time Taken: 20437.6423*/ Move To Re-Order 2025-12-26 02:40:39.0577 AlertProcessor ProcessorAlertData: started 2025-12-26 02:40:40.6202 DFramework.Database.Query /* Time Taken: 620*/ DECLARE @TableName AnsiString(8000) SET @TableName = 'MissingShelf' DECLARE @CurrentRecordId Int32 SET @CurrentRecordId = '3675104' dbo.GetValidDeviceForAlertProcessData 2025-12-26 02:40:41.2765 DFramework.Database.Query /* Time Taken: 593*/ DECLARE @TableName AnsiString(8000) SET @TableName = 'AdditionalShelf' DECLARE @CurrentRecordId Int32 SET @CurrentRecordId = '3675104' dbo.GetValidDeviceForAlertProcessData 2025-12-26 02:40:45.2140 AlertProcessor ProcessorAlertData: Stopped 2025-12-26 02:44:32.7782 AlertProcessor ProcessorAlertData: started 2025-12-26 02:44:33.5283 DFramework.Database.Query /* Time Taken: 723*/ DECLARE @TableName AnsiString(8000) SET @TableName = 'TagAlert' DECLARE @CurrentRecordId Int32 SET @CurrentRecordId = '0' dbo.GetValidDeviceForAlertProcessData 2025-12-26 02:44:33.5595 DFramework.Database.Query /* Time Taken: 746*/ DECLARE @IsFileProcessed Int32 SET @IsFileProcessed = '0' DECLARE @TaskNumber Int32 SET @TaskNumber = '0' DECLARE @IsDeleted Int32 SET @IsDeleted = '0' SELECT TOP 1000 IncomingFileId, GatewayId,GatewayMac,RawFileName,AzureContainerName,StartIndex,Tries, CreatedOn FROM IncomingFile WHERE [IsFileProcessed] = @IsFileProcessed AND [TaskNumber] = @TaskNumber AND [IsDeleted] = @IsDeleted 2025-12-26 02:44:33.5908 DFramework.Database.Query /* Time Taken: 774*/ DECLARE @IsFileProcessed Int32 SET @IsFileProcessed = '0' DECLARE @TaskNumber Int32 SET @TaskNumber = '1' DECLARE @IsDeleted Int32 SET @IsDeleted = '0' SELECT TOP 1000 IncomingFileId, GatewayId,GatewayMac,RawFileName,AzureContainerName,StartIndex,Tries, CreatedOn FROM IncomingFile WHERE [IsFileProcessed] = @IsFileProcessed AND [TaskNumber] = @TaskNumber AND [IsDeleted] = @IsDeleted 2025-12-26 02:44:33.6064 DFramework.Database.Query /* Time Taken: 801*/ DECLARE @IsFileProcessed Int32 SET @IsFileProcessed = '0' DECLARE @TaskNumber Int32 SET @TaskNumber = '3' DECLARE @IsDeleted Int32 SET @IsDeleted = '0' SELECT TOP 1000 IncomingFileId, GatewayId,GatewayMac,RawFileName,AzureContainerName,StartIndex,Tries, CreatedOn FROM IncomingFile WHERE [IsFileProcessed] = @IsFileProcessed AND [TaskNumber] = @TaskNumber AND [IsDeleted] = @IsDeleted 2025-12-26 02:44:33.6376 DFramework.Database.Query /* Time Taken: 829*/ DECLARE @IsFileProcessed Int32 SET @IsFileProcessed = '0' DECLARE @TaskNumber Int32 SET @TaskNumber = '4' DECLARE @IsDeleted Int32 SET @IsDeleted = '0' SELECT TOP 1000 IncomingFileId, GatewayId,GatewayMac,RawFileName,AzureContainerName,StartIndex,Tries, CreatedOn FROM IncomingFile WHERE [IsFileProcessed] = @IsFileProcessed AND [TaskNumber] = @TaskNumber AND [IsDeleted] = @IsDeleted 2025-12-26 02:44:33.7783 DFramework.Database.Query /* Time Taken: 950*/ 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-26 02:44:33.7783 DFramework.Database.Query /* Time Taken: 971*/ DECLARE @IsFileProcessed Int32 SET @IsFileProcessed = '0' DECLARE @TaskNumber Int32 SET @TaskNumber = '2' DECLARE @IsDeleted Int32 SET @IsDeleted = '0' SELECT TOP 1000 IncomingFileId, GatewayId,GatewayMac,RawFileName,AzureContainerName,StartIndex,Tries, CreatedOn FROM IncomingFile WHERE [IsFileProcessed] = @IsFileProcessed AND [TaskNumber] = @TaskNumber AND [IsDeleted] = @IsDeleted 2025-12-26 02:44:33.7939 DFramework.Database.Query /* Time Taken: 974*/ DECLARE @AlertDefinition_IsActive Int32 SET @AlertDefinition_IsActive = '1' DECLARE @AlertDefinition_ClientId Int32 SET @AlertDefinition_ClientId = '213' DECLARE @AlertDefinition_AlertTypeId Int32 SET @AlertDefinition_AlertTypeId = '67' DECLARE @AlertDefinition_IsDeleted Int32 SET @AlertDefinition_IsDeleted = '0' DECLARE @AlertDefinition_StartDate DateTime2 SET @AlertDefinition_StartDate = '12/26/2025 10:44:32 AM' SELECT TOP 1 AlertDefinitionId, PriorityId FROM AlertDefinition WHERE AlertDefinition.IsActive = @AlertDefinition_IsActive AND AlertDefinition.ClientId = @AlertDefinition_ClientId AND AlertDefinition.AlertTypeId = @AlertDefinition_AlertTypeId AND AlertDefinition.IsDeleted = @AlertDefinition_IsDeleted AND AlertDefinition.StartDate <= @AlertDefinition_StartDate 2025-12-26 02:44:33.8095 DFramework.Database.Query /* Time Taken: 984*/ DECLARE @CreatedOn DateTime2 SET @CreatedOn = '12/26/2025 12:00:00 AM' DECLARE @EventId Int32 SET @EventId = '-12' SELECT COUNT(1) FROM EmailQueue WHERE [CreatedOn] >= @CreatedOn AND [EventId] = @EventId 2025-12-26 02:44:33.8564 DFramework.Database.Query /* Time Taken: 1031*/ DECLARE @IsComplete Int32 SET @IsComplete = '0' SELECT TOP 1 ProductMergeTempId, PrimaryProductId, SecondaryProductId, dbo.Product.ClientId, dbo.ProductMergeTemp.UserId, [Product] AS ProductName FROM dbo.ProductMergeTemp INNER JOIN dbo.Product ON dbo.Product.ProductId = dbo.ProductMergeTemp.PrimaryProductId AND dbo.Product.ClientId = dbo.ProductMergeTemp.ClientId AND dbo.Product.IsDeleted = 0 WHERE [IsComplete] = @IsComplete 2025-12-26 02:44:33.8876 DFramework.Database.Query /* Time Taken: 1058*/ DECLARE @IsActive Int32 SET @IsActive = '1' DECLARE @FtpTypeId Int32 SET @FtpTypeId = '7766' DECLARE @ClientId Int32 SET @ClientId = '213' Select * from vwFTPClientList WHERE [IsActive] = @IsActive AND [FtpTypeId] = @FtpTypeId AND [ClientId] = @ClientId ORDER BY [ClientFtpId] 2025-12-26 02:44:33.9814 DFramework.Database.Query /* Time Taken: 932*/ DECLARE @AlertDefinitionId Int32 SET @AlertDefinitionId = '99' DECLARE @IsDeleted Boolean SET @IsDeleted = 'False' SELECT ProductId FROM AlertDefinitionProduct WHERE [AlertDefinitionId] = @AlertDefinitionId AND IsDeleted = @IsDeleted 2025-12-26 02:44:34.1064 DFramework.Database.NullableDataReader Data reader open for 570 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-26 02:44:34.1220 DFramework.Database.Query /* Time Taken: 1304*/ 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-26 02:44:34.1376 DFramework.Database.NullableDataReader Data reader open for 1094 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.ProcessOutletAlertData.GetAlertDefinitions() in D:\Spraxa\CoolR-Group\portal\CoolR.Tasks\OpportunityOutOfStockByOutlet.cs:line 490 at CoolR.Tasks.ProcessOutletAlertData.Execute() in D:\Spraxa\CoolR-Group\portal\CoolR.Tasks\OpportunityOutOfStockByOutlet.cs:line 72 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-26 02:44:34.3251 DFramework.Database.Query /* Time Taken: 1052*/ DECLARE @AssetKPIData Object SET @AssetKPIData = '' [dbo].BulkUpsertAssetDayKPI 2025-12-26 02:44:35.1689 DFramework.Database.Query /* Time Taken: 546*/ DECLARE @TableName AnsiString(8000) SET @TableName = 'MissingShelf' DECLARE @CurrentRecordId Int32 SET @CurrentRecordId = '3675104' dbo.GetValidDeviceForAlertProcessData 2025-12-26 02:44:35.5751 DFramework.Database.Query /* Time Taken: 2742*/ [dbo].GenerateSystemAlerts 2025-12-26 02:44:37.6064 DFramework.Database.Query /* Time Taken: 540*/ DECLARE @TableName AnsiString(8000) SET @TableName = 'AssetStockProductWise' DECLARE @CurrentRecordId Int32 SET @CurrentRecordId = '3675104' dbo.GetValidDeviceForAlertProcessData 2025-12-26 02:44:39.7627 AlertProcessor ProcessorAlertData: Stopped 2025-12-26 02:44:49.9190 DFramework.Scheduler.TaskBase /* Time Taken: 17156.3732*/ Opportunity Out Of Stock By Outlet 2025-12-26 02:49:32.7803 AlertProcessor ProcessorAlertData: started 2025-12-26 02:49:37.8273 AlertProcessor ProcessorAlertData: Stopped 2025-12-26 02:54:32.7981 AlertProcessor ProcessorAlertData: started 2025-12-26 02:54:38.3138 AlertProcessor ProcessorAlertData: Stopped 2025-12-26 02:59:32.8163 AlertProcessor ProcessorAlertData: started 2025-12-26 02:59:33.4101 DFramework.Database.Query /* Time Taken: 515*/ DECLARE @ClientId Int32 SET @ClientId = '213' 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 = '8/28/2025 12:00:00 AM' dbo.GetOpportunityOutOfStockDataByOutlet 2025-12-26 02:59:35.5976 DFramework.Database.Query /* Time Taken: 2775*/ [dbo].GenerateSystemAlerts 2025-12-26 02:59:38.4257 AlertProcessor ProcessorAlertData: Stopped 2025-12-26 02:59:48.8789 DFramework.Scheduler.TaskBase /* Time Taken: 16093.8714*/ Opportunity Out Of Stock By Outlet 2025-12-26 03:04:32.8341 AlertProcessor ProcessorAlertData: started 2025-12-26 03:04:33.3497 DFramework.Database.Query /* Time Taken: 522*/ DECLARE @TableName AnsiString(8000) SET @TableName = 'TagAlert' DECLARE @CurrentRecordId Int32 SET @CurrentRecordId = '0' dbo.GetValidDeviceForAlertProcessData 2025-12-26 03:04:38.4279 AlertProcessor ProcessorAlertData: Stopped 2025-12-26 03:09:32.8361 AlertProcessor ProcessorAlertData: started 2025-12-26 03:09:37.9456 AlertProcessor ProcessorAlertData: Stopped 2025-12-26 03:14:32.8543 AlertProcessor ProcessorAlertData: started 2025-12-26 03:14:33.4011 DFramework.Database.Query /* Time Taken: 549*/ DECLARE @TableName AnsiString(8000) SET @TableName = 'TagAlert' DECLARE @CurrentRecordId Int32 SET @CurrentRecordId = '0' dbo.GetValidDeviceForAlertProcessData 2025-12-26 03:14:35.5105 DFramework.Database.Query /* Time Taken: 2670*/ [dbo].GenerateSystemAlerts 2025-12-26 03:14:38.6668 AlertProcessor ProcessorAlertData: Stopped 2025-12-26 03:14:48.9169 DFramework.Scheduler.TaskBase /* Time Taken: 16109.5068*/ Opportunity Out Of Stock By Outlet 2025-12-26 03:24:37.4837 AlertProcessor ProcessorAlertData: started 2025-12-26 03:24:38.0305 DFramework.Database.Query /* Time Taken: 519*/ DECLARE @TableName AnsiString(8000) SET @TableName = 'TagAlert' DECLARE @CurrentRecordId Int32 SET @CurrentRecordId = '0' dbo.GetValidDeviceForAlertProcessData 2025-12-26 03:24:38.6868 DFramework.Database.Query /* Time Taken: 1155*/ DECLARE @AlertDefinitionId Int32 SET @AlertDefinitionId = '99' DECLARE @IsDeleted Boolean SET @IsDeleted = 'False' SELECT ProductId FROM AlertDefinitionProduct WHERE [AlertDefinitionId] = @AlertDefinitionId AND IsDeleted = @IsDeleted 2025-12-26 03:24:38.7024 DFramework.Database.Query /* Time Taken: 1173*/ 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-26 03:24:38.7180 DFramework.Database.Query /* Time Taken: 1179*/ DECLARE @IsActive Int32 SET @IsActive = '1' DECLARE @FtpTypeId Int32 SET @FtpTypeId = '7766' DECLARE @ClientId Int32 SET @ClientId = '213' Select * from vwFTPClientList WHERE [IsActive] = @IsActive AND [FtpTypeId] = @FtpTypeId AND [ClientId] = @ClientId ORDER BY [ClientFtpId] 2025-12-26 03:24:38.7493 DFramework.Database.Query /* Time Taken: 1208*/ DECLARE @CreatedOn DateTime2 SET @CreatedOn = '12/26/2025 12:00:00 AM' DECLARE @EventId Int32 SET @EventId = '-12' SELECT COUNT(1) FROM EmailQueue WHERE [CreatedOn] >= @CreatedOn AND [EventId] = @EventId 2025-12-26 03:24:38.7493 DFramework.Database.Query /* Time Taken: 1210*/ DECLARE @AlertDefinition_IsActive Int32 SET @AlertDefinition_IsActive = '1' DECLARE @AlertDefinition_ClientId Int32 SET @AlertDefinition_ClientId = '213' DECLARE @AlertDefinition_AlertTypeId Int32 SET @AlertDefinition_AlertTypeId = '67' DECLARE @AlertDefinition_IsDeleted Int32 SET @AlertDefinition_IsDeleted = '0' DECLARE @AlertDefinition_StartDate DateTime2 SET @AlertDefinition_StartDate = '12/26/2025 11:24:37 AM' SELECT TOP 1 AlertDefinitionId, PriorityId FROM AlertDefinition WHERE AlertDefinition.IsActive = @AlertDefinition_IsActive AND AlertDefinition.ClientId = @AlertDefinition_ClientId AND AlertDefinition.AlertTypeId = @AlertDefinition_AlertTypeId AND AlertDefinition.IsDeleted = @AlertDefinition_IsDeleted AND AlertDefinition.StartDate <= @AlertDefinition_StartDate 2025-12-26 03:24:38.7805 DFramework.Database.Query /* Time Taken: 1239*/ DECLARE @IsFileProcessed Int32 SET @IsFileProcessed = '0' DECLARE @TaskNumber Int32 SET @TaskNumber = '1' DECLARE @IsDeleted Int32 SET @IsDeleted = '0' SELECT TOP 1000 IncomingFileId, GatewayId,GatewayMac,RawFileName,AzureContainerName,StartIndex,Tries, CreatedOn FROM IncomingFile WHERE [IsFileProcessed] = @IsFileProcessed AND [TaskNumber] = @TaskNumber AND [IsDeleted] = @IsDeleted 2025-12-26 03:24:38.8118 DFramework.Database.Query /* Time Taken: 1271*/ DECLARE @IsFileProcessed Int32 SET @IsFileProcessed = '0' DECLARE @TaskNumber Int32 SET @TaskNumber = '3' DECLARE @IsDeleted Int32 SET @IsDeleted = '0' SELECT TOP 1000 IncomingFileId, GatewayId,GatewayMac,RawFileName,AzureContainerName,StartIndex,Tries, CreatedOn FROM IncomingFile WHERE [IsFileProcessed] = @IsFileProcessed AND [TaskNumber] = @TaskNumber AND [IsDeleted] = @IsDeleted 2025-12-26 03:24:38.8899 DFramework.Database.Query /* Time Taken: 1348*/ DECLARE @IsFileProcessed Int32 SET @IsFileProcessed = '0' DECLARE @TaskNumber Int32 SET @TaskNumber = '2' DECLARE @IsDeleted Int32 SET @IsDeleted = '0' SELECT TOP 1000 IncomingFileId, GatewayId,GatewayMac,RawFileName,AzureContainerName,StartIndex,Tries, CreatedOn FROM IncomingFile WHERE [IsFileProcessed] = @IsFileProcessed AND [TaskNumber] = @TaskNumber AND [IsDeleted] = @IsDeleted 2025-12-26 03:24:38.9212 DFramework.Database.Query /* Time Taken: 1381*/ DECLARE @IsFileProcessed Int32 SET @IsFileProcessed = '0' DECLARE @TaskNumber Int32 SET @TaskNumber = '4' DECLARE @IsDeleted Int32 SET @IsDeleted = '0' SELECT TOP 1000 IncomingFileId, GatewayId,GatewayMac,RawFileName,AzureContainerName,StartIndex,Tries, CreatedOn FROM IncomingFile WHERE [IsFileProcessed] = @IsFileProcessed AND [TaskNumber] = @TaskNumber AND [IsDeleted] = @IsDeleted 2025-12-26 03:24:38.9524 DFramework.Database.Query /* Time Taken: 1416*/ DECLARE @IsComplete Int32 SET @IsComplete = '0' SELECT TOP 1 ProductMergeTempId, PrimaryProductId, SecondaryProductId, dbo.Product.ClientId, dbo.ProductMergeTemp.UserId, [Product] AS ProductName FROM dbo.ProductMergeTemp INNER JOIN dbo.Product ON dbo.Product.ProductId = dbo.ProductMergeTemp.PrimaryProductId AND dbo.Product.ClientId = dbo.ProductMergeTemp.ClientId AND dbo.Product.IsDeleted = 0 WHERE [IsComplete] = @IsComplete 2025-12-26 03:24:38.9680 DFramework.Database.Query /* Time Taken: 931*/ DECLARE @TableName AnsiString(8000) SET @TableName = 'TagAlert' SELECT TableName FROM AlertProcessor WHERE [TableName] = @TableName 2025-12-26 03:24:38.9993 DFramework.Database.Query /* Time Taken: 1007*/ DECLARE @AssetKPIData Object SET @AssetKPIData = '' [dbo].BulkUpsertAssetDayKPI 2025-12-26 03:24:39.1399 DFramework.Database.NullableDataReader Data reader open for 1090 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-26 03:24:39.1712 DFramework.Database.NullableDataReader Data reader open for 1651 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.ProcessOutletAlertData.GetAlertDefinitions() in D:\Spraxa\CoolR-Group\portal\CoolR.Tasks\OpportunityOutOfStockByOutlet.cs:line 490 at CoolR.Tasks.ProcessOutletAlertData.Execute() in D:\Spraxa\CoolR-Group\portal\CoolR.Tasks\OpportunityOutOfStockByOutlet.cs:line 72 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-26 03:24:39.1868 DFramework.Database.Query /* Time Taken: 1640*/ DECLARE @IsFileProcessed Int32 SET @IsFileProcessed = '0' DECLARE @TaskNumber Int32 SET @TaskNumber = '0' DECLARE @IsDeleted Int32 SET @IsDeleted = '0' SELECT TOP 1000 IncomingFileId, GatewayId,GatewayMac,RawFileName,AzureContainerName,StartIndex,Tries, CreatedOn FROM IncomingFile WHERE [IsFileProcessed] = @IsFileProcessed AND [TaskNumber] = @TaskNumber AND [IsDeleted] = @IsDeleted 2025-12-26 03:24:39.2024 DFramework.Database.Query /* Time Taken: 509*/ 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-26 03:24:39.6243 DFramework.Database.Query /* Time Taken: 2108*/ 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-26 03:24:40.2805 DFramework.Database.Query /* Time Taken: 589*/ DECLARE @TableName AnsiString(8000) SET @TableName = 'MissingShelf' DECLARE @CurrentRecordId Int32 SET @CurrentRecordId = '3675104' dbo.GetValidDeviceForAlertProcessData 2025-12-26 03:24:40.9056 DFramework.Database.Query /* Time Taken: 555*/ DECLARE @TableName AnsiString(8000) SET @TableName = 'AdditionalShelf' DECLARE @CurrentRecordId Int32 SET @CurrentRecordId = '3675104' dbo.GetValidDeviceForAlertProcessData 2025-12-26 03:24:41.6087 DFramework.Database.Query /* Time Taken: 4060*/ [dbo].GenerateSystemAlerts 2025-12-26 03:24:44.6868 AlertProcessor ProcessorAlertData: Stopped 2025-12-26 03:24:55.0932 DFramework.Scheduler.TaskBase /* Time Taken: 17843.8659*/ Opportunity Out Of Stock By Outlet 2025-12-26 03:29:37.2671 AlertProcessor ProcessorAlertData: started 2025-12-26 03:29:38.5484 DFramework.Database.Query /* Time Taken: 598*/ DECLARE @TableName AnsiString(8000) SET @TableName = 'MissingShelf' DECLARE @CurrentRecordId Int32 SET @CurrentRecordId = '3675104' dbo.GetValidDeviceForAlertProcessData 2025-12-26 03:29:42.7047 AlertProcessor ProcessorAlertData: Stopped 2025-12-26 03:34:37.2852 AlertProcessor ProcessorAlertData: started 2025-12-26 03:34:38.0664 MoveToReorder Running task for ClientId : 286 and ClientName = India Office QA and Slot: 12/26/2025 5:00:00 PM And LastExecutedOn: 12/26/2025 4:05:40 PM 2025-12-26 03:34:38.9258 DFramework.Database.Query /* Time Taken: 776*/ DECLARE @OrderStatusId Int32 SET @OrderStatusId = '0' DECLARE @ClientId Int32 SET @ClientId = '286' dbo.GetOrderDetailsByClientId 2025-12-26 03:34:42.9258 AlertProcessor ProcessorAlertData: Stopped 2025-12-26 03:35:04.9104 DFramework.Database.NullableDataReader Data reader open for 25929 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-26 03:35:04.9416 MoveToReorder Task executed successfully for ClientId : 286 Client Name:India Office QA, Slot: 12/26/2025 5:00:00 PM and Total Order Suggested: 92 Out Of: 92 2025-12-26 03:35:05.9416 DFramework.Scheduler.TaskBase /* Time Taken: 28406.4568*/ Move To Re-Order 2025-12-26 03:39:37.3029 AlertProcessor ProcessorAlertData: started 2025-12-26 03:39:38.9279 DFramework.Database.Query /* Time Taken: 849*/ DECLARE @TableName AnsiString(8000) SET @TableName = 'MissingShelf' DECLARE @CurrentRecordId Int32 SET @CurrentRecordId = '3675104' dbo.GetValidDeviceForAlertProcessData 2025-12-26 03:39:39.9436 DFramework.Database.Query /* Time Taken: 2402*/ [dbo].GenerateSystemAlerts 2025-12-26 03:39:42.7092 DFramework.Database.Query /* Time Taken: 2379*/ DECLARE @TableName AnsiString(8000) SET @TableName = 'AssetStockProductWiseConsolidate' DECLARE @CurrentRecordId Int32 SET @CurrentRecordId = '3675104' dbo.GetValidDeviceForAlertProcessData 2025-12-26 03:39:45.1936 AlertProcessor ProcessorAlertData: Stopped 2025-12-26 03:39:53.3030 DFramework.Scheduler.TaskBase /* Time Taken: 16031.3595*/ Opportunity Out Of Stock By Outlet 2025-12-26 03:44:37.3049 AlertProcessor ProcessorAlertData: started 2025-12-26 03:44:38.0706 DFramework.Database.Query /* Time Taken: 519*/ 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-26 03:44:42.6487 AlertProcessor ProcessorAlertData: Stopped 2025-12-26 03:49:37.3076 AlertProcessor ProcessorAlertData: started 2025-12-26 03:49:38.5732 DFramework.Database.Query /* Time Taken: 545*/ DECLARE @TableName AnsiString(8000) SET @TableName = 'MissingShelf' DECLARE @CurrentRecordId Int32 SET @CurrentRecordId = '3675104' dbo.GetValidDeviceForAlertProcessData 2025-12-26 03:49:39.2139 DFramework.Database.Query /* Time Taken: 581*/ DECLARE @TableName AnsiString(8000) SET @TableName = 'AdditionalShelf' DECLARE @CurrentRecordId Int32 SET @CurrentRecordId = '3675104' dbo.GetValidDeviceForAlertProcessData 2025-12-26 03:49:43.1201 AlertProcessor ProcessorAlertData: Stopped 2025-12-26 03:54:37.3153 AlertProcessor ProcessorAlertData: started 2025-12-26 03:54:37.9403 DFramework.Database.Query /* Time Taken: 550*/ DECLARE @ClientId Int32 SET @ClientId = '213' 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 = '8/28/2025 12:00:00 AM' dbo.GetOpportunityOutOfStockDataByOutlet 2025-12-26 03:54:39.0497 DFramework.Database.Query /* Time Taken: 801*/ DECLARE @TableName AnsiString(8000) SET @TableName = 'MissingShelf' DECLARE @CurrentRecordId Int32 SET @CurrentRecordId = '3675104' dbo.GetValidDeviceForAlertProcessData 2025-12-26 03:54:40.6591 DFramework.Database.Query /* Time Taken: 3104*/ [dbo].GenerateSystemAlerts 2025-12-26 03:54:43.2372 AlertProcessor ProcessorAlertData: Stopped 2025-12-26 03:54:53.2842 DFramework.Scheduler.TaskBase /* Time Taken: 16000.1154*/ Opportunity Out Of Stock By Outlet 2025-12-26 03:59:37.3330 AlertProcessor ProcessorAlertData: started 2025-12-26 03:59:37.9268 DFramework.Database.NullableDataReader Data reader open for 237 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-26 03:59:40.1143 DFramework.Database.NullableDataReader Data reader open for 407 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-26 03:59:40.1768 DFramework.Database.NullableDataReader Data reader open for 492 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-26 03:59:40.6612 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 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-26 03:59:41.4268 DFramework.Database.NullableDataReader Data reader open for 518 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-26 03:59:41.4893 DFramework.Database.NullableDataReader Data reader open for 603 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-26 03:59:43.0830 DFramework.Database.NullableDataReader Data reader open for 855 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-26 03:59:43.1455 DFramework.Database.NullableDataReader Data reader open for 941 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-26 03:59:43.4737 AlertProcessor Replace Tags updated for the Image Id: 3675191 2025-12-26 03:59:43.6299 DFramework.Database.NullableDataReader Data reader open for 241 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-26 03:59:44.7549 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.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-26 03:59:44.8018 DFramework.Database.NullableDataReader Data reader open for 284 at System.Environment.GetStackTrace(Exception e, Boolean needFileInfo) at System.Environment.get_StackTrace() at DFramework.Database.NullableDataReader.Dispose(Boolean disposing) in D:\Spraxa\Framework\DFramework\Database\NullableDataReader.cs:line 33 at DFramework.Database.NullableDataReader.Dispose() in D:\Spraxa\Framework\DFramework\Database\NullableDataReader.cs:line 44 at CoolR.Tasks.ProcessAlertData.Execute() in D:\Spraxa\CoolR-Group\portal\CoolR.Tasks\ProcessAlertData.cs:line 47 at DFramework.Scheduler.TaskBase.Run() in D:\Spraxa\Framework\DFramework.Scheduler\TaskBase.cs:line 176 at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx) at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx) at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state) at System.Threading.ThreadHelper.ThreadStart() 2025-12-26 03:59:45.5518 DFramework.Database.NullableDataReader Data reader open for 220 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-26 03:59:46.0987 AlertProcessor ProcessorAlertData: Stopped 2025-12-26 04:04:37.3357 AlertProcessor ProcessorAlertData: started 2025-12-26 04:04:37.8357 DFramework.Database.NullableDataReader Data reader open for 259 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-26 04:04:38.7732 DFramework.Database.NullableDataReader Data reader open for 402 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 DFramework.Business.BusinessListBase`1.Fetch(Query query) in D:\Spraxa\Framework\DFramework\Business\BusinessListBase.cs:line 87 at DFramework.Business.BusinessListBase`1.Load(Query query) in D:\Spraxa\Framework\DFramework\Business\BusinessListBase.cs:line 58 at CoolR.Business.Product.GetProducts(HashSet`1 productIds) in D:\Spraxa\CoolR-Group\portal\CoolR.Business\Product.cs:line 109 at CoolR.Business.Vision.Planogram.CreatePlanogram(String[][] data, Byte[][] depths, Boolean isAddEmptyProduct) in D:\Spraxa\CoolR-Group\portal\CoolR.Business\Vision\Planogram.cs:line 51 at CoolR.Business.Vision.Planogram.CreatePlanogram(Int32 assetShelves, Byte assetColumns, Int32 assetPlanogramId, Int32 assetPurityPlanogramId, Boolean ignoreClientFilter, Int32 assetId, Boolean isImageFromStoreBuddy, Boolean bindSinbling) in D:\Spraxa\CoolR-Group\portal\CoolR.Business\Vision\Planogram.cs:line 260 at CoolR.Business.Common.BusinessHelper.ProductDetail(Int32 assetPurityId, Int32 assetShelves, Byte assetColumns, Int32 assetPlanogramId, Int32 assetPurityPlanogramId, Int32 assetLatestProcessedPurityId, Boolean includePlanogramProducts) in D:\Spraxa\CoolR-Group\portal\CoolR.Business\Common\BusinessHelper.cs:line 2319 at CoolR.Business.Common.BusinessHelper.ProductDetail(Int32 assetPurityId, Boolean includePlanogramProducts) in D:\Spraxa\CoolR-Group\portal\CoolR.Business\Common\BusinessHelper.cs:line 2295 at CoolR.Tasks.SendAlertNotification.Execute() in D:\Spraxa\CoolR-Group\portal\CoolR.Tasks\SendAlertNotification.cs:line 346 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-26 04:04:39.4607 DFramework.Database.Query /* Time Taken: 663*/ DECLARE @TableName AnsiString(8000) SET @TableName = 'AdditionalShelf' DECLARE @CurrentRecordId Int32 SET @CurrentRecordId = '3675192' dbo.GetValidDeviceForAlertProcessData 2025-12-26 04:04:39.8201 DFramework.Database.NullableDataReader Data reader open for 962 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 DFramework.Business.BusinessListBase`1.Fetch(Query query) in D:\Spraxa\Framework\DFramework\Business\BusinessListBase.cs:line 87 at DFramework.Business.BusinessListBase`1.Load(Query query) in D:\Spraxa\Framework\DFramework\Business\BusinessListBase.cs:line 58 at CoolR.Business.Product.GetProducts(HashSet`1 productIds) in D:\Spraxa\CoolR-Group\portal\CoolR.Business\Product.cs:line 109 at CoolR.Business.Vision.Planogram.CreatePlanogram(Int32[][] data, Byte[][] depths, Boolean isAddEmptyProduct) in D:\Spraxa\CoolR-Group\portal\CoolR.Business\Vision\Planogram.cs:line 108 at CoolR.Business.Vision.Planogram.CreateFacingsPlanogram(Planogram basePlanogram, Int32 assetShelves, Byte assetColumns, Int32 assetLatestProcessedPurityId, AssetPurity assetPurity, Int32 assetPurityId, Boolean isAddEmptyProduct, Boolean ignoreClientFilter) in D:\Spraxa\CoolR-Group\portal\CoolR.Business\Vision\Planogram.cs:line 282 at CoolR.Business.Common.BusinessHelper.ProductDetail(Int32 assetPurityId, Int32 assetShelves, Byte assetColumns, Int32 assetPlanogramId, Int32 assetPurityPlanogramId, Int32 assetLatestProcessedPurityId, Boolean includePlanogramProducts) in D:\Spraxa\CoolR-Group\portal\CoolR.Business\Common\BusinessHelper.cs:line 2320 at CoolR.Business.Common.BusinessHelper.ProductDetail(Int32 assetPurityId, Boolean includePlanogramProducts) in D:\Spraxa\CoolR-Group\portal\CoolR.Business\Common\BusinessHelper.cs:line 2295 at CoolR.Tasks.SendAlertNotification.Execute() in D:\Spraxa\CoolR-Group\portal\CoolR.Tasks\SendAlertNotification.cs:line 346 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-26 04:04:40.1014 DFramework.Database.NullableDataReader Data reader open for 235 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-26 04:04:40.1482 DFramework.Database.NullableDataReader Data reader open for 318 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-26 04:04:40.6014 DFramework.Database.NullableDataReader Data reader open for 220 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-26 04:04:41.1951 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-26 04:04:41.2576 DFramework.Database.NullableDataReader Data reader open for 427 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-26 04:04:42.7733 DFramework.Database.NullableDataReader Data reader open for 788 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-26 04:04:42.8358 DFramework.Database.NullableDataReader Data reader open for 871 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-26 04:04:43.1326 AlertProcessor Replace Tags updated for the Image Id: 3675192 2025-12-26 04:04:43.2889 DFramework.Database.NullableDataReader Data reader open for 227 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-26 04:04:44.6483 DFramework.Database.NullableDataReader Data reader open for 277 at System.Environment.GetStackTrace(Exception e, Boolean needFileInfo) at System.Environment.get_StackTrace() at DFramework.Database.NullableDataReader.Dispose(Boolean disposing) in D:\Spraxa\Framework\DFramework\Database\NullableDataReader.cs:line 33 at DFramework.Database.NullableDataReader.Dispose() in D:\Spraxa\Framework\DFramework\Database\NullableDataReader.cs:line 44 at CoolR.Tasks.ProcessAlertData.Execute() in D:\Spraxa\CoolR-Group\portal\CoolR.Tasks\ProcessAlertData.cs:line 47 at DFramework.Scheduler.TaskBase.Run() in D:\Spraxa\Framework\DFramework.Scheduler\TaskBase.cs:line 176 at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx) at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx) at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state) at System.Threading.ThreadHelper.ThreadStart() 2025-12-26 04:04:45.3827 DFramework.Database.NullableDataReader Data reader open for 218 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-26 04:04:45.9296 AlertProcessor ProcessorAlertData: Stopped 2025-12-26 04:09:37.3533 AlertProcessor ProcessorAlertData: started 2025-12-26 04:09:38.1189 DFramework.Database.Query /* Time Taken: 710*/ DECLARE @ClientId Int32 SET @ClientId = '213' 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 = '8/28/2025 12:00:00 AM' dbo.GetOpportunityOutOfStockDataByOutlet 2025-12-26 04:09:42.5252 DFramework.Database.Query /* Time Taken: 4952*/ [dbo].GenerateSystemAlerts 2025-12-26 04:09:43.1658 AlertProcessor ProcessorAlertData: Stopped 2025-12-26 04:09:54.0565 DFramework.Scheduler.TaskBase /* Time Taken: 16750.1193*/ Opportunity Out Of Stock By Outlet 2025-12-26 04:14:37.3710 AlertProcessor ProcessorAlertData: started 2025-12-26 04:14:42.7148 AlertProcessor ProcessorAlertData: Stopped 2025-12-26 04:19:37.3887 AlertProcessor ProcessorAlertData: started 2025-12-26 04:19:42.4981 AlertProcessor ProcessorAlertData: Stopped 2025-12-26 04:24:37.3911 AlertProcessor ProcessorAlertData: started 2025-12-26 04:24:37.9224 DFramework.Database.Query /* Time Taken: 523*/ DECLARE @TableName AnsiString(8000) SET @TableName = 'TagAlert' DECLARE @CurrentRecordId Int32 SET @CurrentRecordId = '0' dbo.GetValidDeviceForAlertProcessData 2025-12-26 04:24:38.9536 DFramework.Database.Query /* Time Taken: 629*/ DECLARE @TableName AnsiString(8000) SET @TableName = 'MissingShelf' DECLARE @CurrentRecordId Int32 SET @CurrentRecordId = '3675192' dbo.GetValidDeviceForAlertProcessData 2025-12-26 04:24:39.5318 DFramework.Database.Query /* Time Taken: 522*/ DECLARE @TableName AnsiString(8000) SET @TableName = 'AdditionalShelf' DECLARE @CurrentRecordId Int32 SET @CurrentRecordId = '3675192' dbo.GetValidDeviceForAlertProcessData 2025-12-26 04:24:39.5787 DFramework.Database.Query /* Time Taken: 1971*/ [dbo].GenerateSystemAlerts 2025-12-26 04:24:43.2506 AlertProcessor ProcessorAlertData: Stopped 2025-12-26 04:24:53.1569 DFramework.Scheduler.TaskBase /* Time Taken: 15828.2436*/ Opportunity Out Of Stock By Outlet 2025-12-26 04:29:37.4089 AlertProcessor ProcessorAlertData: started 2025-12-26 04:29:42.6433 DFramework.Database.Query /* Time Taken: 562*/ DECLARE @TableName AnsiString(8000) SET @TableName = 'ProductStockLevel' DECLARE @CurrentRecordId Int32 SET @CurrentRecordId = '3675192' dbo.GetValidDeviceForAlertProcessData 2025-12-26 04:29:42.6902 AlertProcessor ProcessorAlertData: Stopped 2025-12-26 04:34:37.4266 AlertProcessor ProcessorAlertData: started 2025-12-26 04:34:38.1766 MoveToReorder Running task for ClientId : 286 and ClientName = India Office QA and Slot: 12/26/2025 6:00:00 PM And LastExecutedOn: 12/26/2025 5:04:38 PM 2025-12-26 04:34:39.0360 DFramework.Database.NullableDataReader Data reader open for 473 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-26 04:34:39.0829 MoveToReorder Task executed successfully for ClientId : 286 Client Name:India Office QA, Slot: 12/26/2025 6:00:00 PM and Total Order Suggested: 1 Out Of: 1 2025-12-26 04:34:39.5829 DFramework.Database.Query /* Time Taken: 579*/ DECLARE @TableName AnsiString(8000) SET @TableName = 'OpportunityOutOfStock' DECLARE @CurrentRecordId Int32 SET @CurrentRecordId = '3675192' dbo.GetValidDeviceForAlertProcessData 2025-12-26 04:34:39.7235 DFramework.Database.Query /* Time Taken: 653*/ DECLARE @ClientId Int32 SET @ClientId = '286' dbo.GetMoveToReOrderList 2025-12-26 04:34:43.0985 AlertProcessor ProcessorAlertData: Stopped 2025-12-26 04:39:37.4447 AlertProcessor ProcessorAlertData: started 2025-12-26 04:39:37.9759 DFramework.Database.Query /* Time Taken: 526*/ DECLARE @ClientId Int32 SET @ClientId = '213' 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 = '8/28/2025 12:00:00 AM' dbo.GetOpportunityOutOfStockDataByOutlet 2025-12-26 04:39:38.8041 DFramework.Database.Query /* Time Taken: 513*/ DECLARE @TableName AnsiString(8000) SET @TableName = 'MissingShelf' DECLARE @CurrentRecordId Int32 SET @CurrentRecordId = '3675192' dbo.GetValidDeviceForAlertProcessData 2025-12-26 04:39:39.8978 DFramework.Database.Query /* Time Taken: 2270*/ [dbo].GenerateSystemAlerts 2025-12-26 04:39:40.8822 DFramework.Database.Query /* Time Taken: 533*/ DECLARE @TableName AnsiString(8000) SET @TableName = 'AssetStockProductWiseConsolidate' DECLARE @CurrentRecordId Int32 SET @CurrentRecordId = '3675192' dbo.GetValidDeviceForAlertProcessData 2025-12-26 04:39:43.3041 AlertProcessor ProcessorAlertData: Stopped 2025-12-26 04:39:53.3823 DFramework.Scheduler.TaskBase /* Time Taken: 16031.3843*/ Opportunity Out Of Stock By Outlet 2025-12-26 04:44:37.4625 AlertProcessor ProcessorAlertData: started 2025-12-26 04:44:38.8219 DFramework.Database.Query /* Time Taken: 930*/ 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-26 04:44:38.9000 DFramework.Database.Query /* Time Taken: 561*/ DECLARE @TableName AnsiString(8000) SET @TableName = 'MissingShelf' DECLARE @CurrentRecordId Int32 SET @CurrentRecordId = '3675192' dbo.GetValidDeviceForAlertProcessData 2025-12-26 04:44:39.3532 DFramework.Database.Query /* Time Taken: 1618*/ 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-26 04:44:43.4938 AlertProcessor ProcessorAlertData: Stopped 2025-12-26 04:49:37.4803 AlertProcessor ProcessorAlertData: started 2025-12-26 04:49:42.5272 AlertProcessor ProcessorAlertData: Stopped 2025-12-26 04:54:37.4981 AlertProcessor ProcessorAlertData: started 2025-12-26 04:54:38.0138 DFramework.Database.Query /* Time Taken: 514*/ DECLARE @TableName AnsiString(8000) SET @TableName = 'TagAlert' DECLARE @CurrentRecordId Int32 SET @CurrentRecordId = '0' dbo.GetValidDeviceForAlertProcessData 2025-12-26 04:54:39.0450 DFramework.Database.Query /* Time Taken: 550*/ DECLARE @TableName AnsiString(8000) SET @TableName = 'MissingShelf' DECLARE @CurrentRecordId Int32 SET @CurrentRecordId = '3675192' dbo.GetValidDeviceForAlertProcessData 2025-12-26 04:54:39.6232 DFramework.Database.Query /* Time Taken: 526*/ DECLARE @TableName AnsiString(8000) SET @TableName = 'AdditionalShelf' DECLARE @CurrentRecordId Int32 SET @CurrentRecordId = '3675192' dbo.GetValidDeviceForAlertProcessData 2025-12-26 04:54:39.7013 DFramework.Database.Query /* Time Taken: 2074*/ [dbo].GenerateSystemAlerts 2025-12-26 04:54:43.4669 AlertProcessor ProcessorAlertData: Stopped 2025-12-26 04:54:53.3264 DFramework.Scheduler.TaskBase /* Time Taken: 15953.2701*/ Opportunity Out Of Stock By Outlet 2025-12-26 04:59:37.5163 AlertProcessor ProcessorAlertData: started 2025-12-26 04:59:42.6569 AlertProcessor ProcessorAlertData: Stopped 2025-12-26 05:04:37.5340 AlertProcessor ProcessorAlertData: started 2025-12-26 05:04:42.7528 AlertProcessor ProcessorAlertData: Stopped 2025-12-26 05:09:37.5378 AlertProcessor ProcessorAlertData: started 2025-12-26 05:09:38.0378 DFramework.Database.Query /* Time Taken: 543*/ DECLARE @ClientId Int32 SET @ClientId = '213' 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 = '8/28/2025 12:00:00 AM' dbo.GetOpportunityOutOfStockDataByOutlet 2025-12-26 05:09:38.5222 DFramework.Database.Query /* Time Taken: 716*/ 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-26 05:09:39.0534 DFramework.Database.Query /* Time Taken: 556*/ DECLARE @TableName AnsiString(8000) SET @TableName = 'MissingShelf' DECLARE @CurrentRecordId Int32 SET @CurrentRecordId = '3675192' dbo.GetValidDeviceForAlertProcessData 2025-12-26 05:09:39.8034 DFramework.Database.Query /* Time Taken: 701*/ DECLARE @TableName AnsiString(8000) SET @TableName = 'AdditionalShelf' DECLARE @CurrentRecordId Int32 SET @CurrentRecordId = '3675192' dbo.GetValidDeviceForAlertProcessData 2025-12-26 05:09:43.1316 DFramework.Database.Query /* Time Taken: 5495*/ [dbo].GenerateSystemAlerts 2025-12-26 05:09:43.5847 DFramework.Database.Query /* Time Taken: 537*/ DECLARE @ClientId Int32 SET @ClientId = '286' 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 = '11/1/2025 12:00:00 AM' dbo.GetOpportunityOutOfStockDataByOutlet 2025-12-26 05:09:43.8348 AlertProcessor ProcessorAlertData: Stopped 2025-12-26 05:09:53.9442 DFramework.Scheduler.TaskBase /* Time Taken: 16562.612*/ Opportunity Out Of Stock By Outlet 2025-12-26 05:14:37.5559 AlertProcessor ProcessorAlertData: started 2025-12-26 05:14:40.9622 DFramework.Database.NullableDataReader Data reader open for 271 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-26 05:14:42.9622 AlertProcessor ProcessorAlertData: Stopped 2025-12-26 05:19:37.5737 AlertProcessor ProcessorAlertData: started 2025-12-26 05:19:42.6675 AlertProcessor ProcessorAlertData: Stopped 2025-12-26 05:20:57.1993 DFramework.Database.Query /* Time Taken: 519*/ DECLARE @IsFileProcessed Int32 SET @IsFileProcessed = '0' DECLARE @TaskNumber Int32 SET @TaskNumber = '4' DECLARE @IsDeleted Int32 SET @IsDeleted = '0' SELECT TOP 1000 IncomingFileId, GatewayId,GatewayMac,RawFileName,AzureContainerName,StartIndex,Tries, CreatedOn FROM IncomingFile WHERE [IsFileProcessed] = @IsFileProcessed AND [TaskNumber] = @TaskNumber AND [IsDeleted] = @IsDeleted 2025-12-26 05:24:37.5914 AlertProcessor ProcessorAlertData: started 2025-12-26 05:24:38.2165 DFramework.Database.Query /* Time Taken: 520*/ DECLARE @AssetKPIData Object SET @AssetKPIData = '' [dbo].BulkUpsertAssetDayKPI 2025-12-26 05:24:38.2633 DFramework.Database.Query /* Time Taken: 753*/ DECLARE @ClientId Int32 SET @ClientId = '213' 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 = '8/28/2025 12:00:00 AM' dbo.GetOpportunityOutOfStockDataByOutlet 2025-12-26 05:24:38.2789 DFramework.Database.Query /* Time Taken: 673*/ DECLARE @TableName AnsiString(8000) SET @TableName = 'TagAlert' DECLARE @CurrentRecordId Int32 SET @CurrentRecordId = '0' dbo.GetValidDeviceForAlertProcessData 2025-12-26 05:24:39.7008 DFramework.Database.Query /* Time Taken: 952*/ DECLARE @TableName AnsiString(8000) SET @TableName = 'MissingShelf' DECLARE @CurrentRecordId Int32 SET @CurrentRecordId = '3675192' dbo.GetValidDeviceForAlertProcessData 2025-12-26 05:24:39.7477 DFramework.Database.Query /* Time Taken: 2099*/ [dbo].GenerateSystemAlerts 2025-12-26 05:24:43.7790 AlertProcessor ProcessorAlertData: Stopped 2025-12-26 05:24:53.6072 DFramework.Scheduler.TaskBase /* Time Taken: 16203.2579*/ Opportunity Out Of Stock By Outlet 2025-12-26 05:29:37.6094 AlertProcessor ProcessorAlertData: started 2025-12-26 05:29:41.3282 DFramework.Database.Query /* Time Taken: 1376*/ DECLARE @TableName AnsiString(8000) SET @TableName = 'AssetStockProductWiseConsolidate' DECLARE @CurrentRecordId Int32 SET @CurrentRecordId = '3675192' dbo.GetValidDeviceForAlertProcessData 2025-12-26 05:29:43.4688 DFramework.Database.NullableDataReader Data reader open for 269 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-26 05:29:43.9063 AlertProcessor ProcessorAlertData: Stopped 2025-12-26 05:34:37.6274 AlertProcessor ProcessorAlertData: started 2025-12-26 05:34:38.3149 MoveToReorder Running task for ClientId : 286 and ClientName = India Office QA and Slot: 12/26/2025 7:00:00 PM And LastExecutedOn: 12/26/2025 6:04:38 PM 2025-12-26 05:34:38.9243 DFramework.Database.Query /* Time Taken: 547*/ DECLARE @OrderStatusId Int32 SET @OrderStatusId = '0' DECLARE @ClientId Int32 SET @ClientId = '286' dbo.GetOrderDetailsByClientId 2025-12-26 05:34:43.2524 AlertProcessor ProcessorAlertData: Stopped 2025-12-26 05:34:54.1588 DFramework.Database.NullableDataReader Data reader open for 15030 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-26 05:34:54.1900 MoveToReorder Task executed successfully for ClientId : 286 Client Name:India Office QA, Slot: 12/26/2025 7:00:00 PM and Total Order Suggested: 36 Out Of: 36 2025-12-26 05:34:55.7838 DFramework.Scheduler.TaskBase /* Time Taken: 18078.2602*/ Move To Re-Order 2025-12-26 05:39:37.6452 AlertProcessor ProcessorAlertData: started 2025-12-26 05:39:38.9889 DFramework.Database.Query /* Time Taken: 1313*/ [dbo].GenerateSystemAlerts 2025-12-26 05:39:39.0045 DFramework.Database.Query /* Time Taken: 563*/ DECLARE @TableName AnsiString(8000) SET @TableName = 'MissingShelf' DECLARE @CurrentRecordId Int32 SET @CurrentRecordId = '3675192' dbo.GetValidDeviceForAlertProcessData 2025-12-26 05:39:43.0983 AlertProcessor ProcessorAlertData: Stopped 2025-12-26 05:39:53.3328 DFramework.Scheduler.TaskBase /* Time Taken: 15906.3597*/ Opportunity Out Of Stock By Outlet 2025-12-26 05:44:37.6628 AlertProcessor ProcessorAlertData: started 2025-12-26 05:44:42.8816 AlertProcessor ProcessorAlertData: Stopped 2025-12-26 05:49:37.6811 AlertProcessor ProcessorAlertData: started 2025-12-26 05:49:42.7437 AlertProcessor ProcessorAlertData: Stopped 2025-12-26 05:54:37.6833 AlertProcessor ProcessorAlertData: started 2025-12-26 05:54:38.0740 DFramework.Database.Query /* Time Taken: 522*/ DECLARE @ClientId Int32 SET @ClientId = '213' 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 = '8/28/2025 12:00:00 AM' dbo.GetOpportunityOutOfStockDataByOutlet 2025-12-26 05:54:39.1833 DFramework.Database.Query /* Time Taken: 1514*/ [dbo].GenerateSystemAlerts 2025-12-26 05:54:42.6834 DFramework.Database.NullableDataReader Data reader open for 266 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-26 05:54:43.5740 AlertProcessor ProcessorAlertData: Stopped 2025-12-26 05:54:53.4491 DFramework.Scheduler.TaskBase /* Time Taken: 16000.1125*/ Opportunity Out Of Stock By Outlet 2025-12-26 05:59:37.7011 AlertProcessor ProcessorAlertData: started 2025-12-26 05:59:42.8417 AlertProcessor ProcessorAlertData: Stopped 2025-12-26 06:04:37.7191 AlertProcessor ProcessorAlertData: started 2025-12-26 06:04:42.8285 AlertProcessor ProcessorAlertData: Stopped 2025-12-26 06:09:37.7214 AlertProcessor ProcessorAlertData: started 2025-12-26 06:09:38.7058 DFramework.Database.Query /* Time Taken: 1014*/ [dbo].GenerateSystemAlerts 2025-12-26 06:09:43.1745 AlertProcessor ProcessorAlertData: Stopped 2025-12-26 06:09:53.2996 DFramework.Scheduler.TaskBase /* Time Taken: 15828.2436*/ Opportunity Out Of Stock By Outlet 2025-12-26 06:14:37.7391 AlertProcessor ProcessorAlertData: started 2025-12-26 06:14:42.9423 AlertProcessor ProcessorAlertData: Stopped 2025-12-26 06:19:37.7569 AlertProcessor ProcessorAlertData: started 2025-12-26 06:19:42.9288 AlertProcessor ProcessorAlertData: Stopped 2025-12-26 06:24:37.7751 AlertProcessor ProcessorAlertData: started 2025-12-26 06:24:38.8844 DFramework.Database.Query /* Time Taken: 1167*/ [dbo].GenerateSystemAlerts 2025-12-26 06:24:43.4001 AlertProcessor ProcessorAlertData: Stopped 2025-12-26 06:24:53.1189 DFramework.Scheduler.TaskBase /* Time Taken: 15625.1215*/ Opportunity Out Of Stock By Outlet 2025-12-26 06:29:37.7929 AlertProcessor ProcessorAlertData: started 2025-12-26 06:29:42.9023 AlertProcessor ProcessorAlertData: Stopped 2025-12-26 06:34:37.8106 AlertProcessor ProcessorAlertData: started 2025-12-26 06:34:38.3262 MoveToReorder Running task for ClientId : 286 and ClientName = India Office QA and Slot: 12/26/2025 8:00:00 PM And LastExecutedOn: 12/26/2025 7:04:38 PM 2025-12-26 06:34:43.2325 DFramework.Database.Query /* Time Taken: 659*/ DECLARE @TableName AnsiString(8000) SET @TableName = 'ProductStockLevel' DECLARE @CurrentRecordId Int32 SET @CurrentRecordId = '3675192' dbo.GetValidDeviceForAlertProcessData 2025-12-26 06:34:43.2794 AlertProcessor ProcessorAlertData: Stopped 2025-12-26 06:35:05.2327 DFramework.Database.NullableDataReader Data reader open for 26412 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-26 06:35:05.2639 MoveToReorder Task executed successfully for ClientId : 286 Client Name:India Office QA, Slot: 12/26/2025 8:00:00 PM and Total Order Suggested: 92 Out Of: 92 2025-12-26 06:35:06.3889 DFramework.Scheduler.TaskBase /* Time Taken: 28578.3186*/ Move To Re-Order 2025-12-26 06:39:37.8286 AlertProcessor ProcessorAlertData: started 2025-12-26 06:39:38.7974 DFramework.Database.Query /* Time Taken: 962*/ DECLARE @TableName AnsiString(8000) SET @TableName = 'TagAlert' DECLARE @CurrentRecordId Int32 SET @CurrentRecordId = '0' dbo.GetValidDeviceForAlertProcessData 2025-12-26 06:39:38.9536 DFramework.Database.Query /* Time Taken: 1225*/ [dbo].GenerateSystemAlerts 2025-12-26 06:39:39.8755 DFramework.Database.Query /* Time Taken: 660*/ DECLARE @TableName AnsiString(8000) SET @TableName = 'MissingShelf' DECLARE @CurrentRecordId Int32 SET @CurrentRecordId = '3675192' dbo.GetValidDeviceForAlertProcessData 2025-12-26 06:39:41.7662 DFramework.Database.Query /* Time Taken: 614*/ DECLARE @TableName AnsiString(8000) SET @TableName = 'AssetStockProductWiseConsolidate' DECLARE @CurrentRecordId Int32 SET @CurrentRecordId = '3675192' dbo.GetValidDeviceForAlertProcessData 2025-12-26 06:39:43.4537 DFramework.Database.Query /* Time Taken: 514*/ DECLARE @ClientId Int32 SET @ClientId = '286' 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 = '11/1/2025 12:00:00 AM' dbo.GetOpportunityOutOfStockDataByOutlet 2025-12-26 06:39:44.1412 AlertProcessor ProcessorAlertData: Stopped 2025-12-26 06:39:53.7350 DFramework.Scheduler.TaskBase /* Time Taken: 16218.875*/ Opportunity Out Of Stock By Outlet 2025-12-26 06:44:37.8308 AlertProcessor ProcessorAlertData: started 2025-12-26 06:44:43.2059 AlertProcessor ProcessorAlertData: Stopped 2025-12-26 06:49:37.8486 AlertProcessor ProcessorAlertData: started 2025-12-26 06:49:43.5048 DFramework.Database.Query /* Time Taken: 747*/ DECLARE @TableName AnsiString(8000) SET @TableName = 'ProductStockLevel' DECLARE @CurrentRecordId Int32 SET @CurrentRecordId = '3675192' dbo.GetValidDeviceForAlertProcessData 2025-12-26 06:49:43.5674 AlertProcessor ProcessorAlertData: Stopped 2025-12-26 06:54:37.8509 AlertProcessor ProcessorAlertData: started 2025-12-26 06:54:38.4447 DFramework.Database.Query /* Time Taken: 589*/ DECLARE @TableName AnsiString(8000) SET @TableName = 'TagAlert' DECLARE @CurrentRecordId Int32 SET @CurrentRecordId = '0' dbo.GetValidDeviceForAlertProcessData 2025-12-26 06:54:38.8822 DFramework.Database.Query /* Time Taken: 1134*/ [dbo].GenerateSystemAlerts 2025-12-26 06:54:43.3978 AlertProcessor ProcessorAlertData: Stopped 2025-12-26 06:54:53.2573 DFramework.Scheduler.TaskBase /* Time Taken: 15718.8934*/ Opportunity Out Of Stock By Outlet 2025-12-26 06:59:37.8690 AlertProcessor ProcessorAlertData: started 2025-12-26 06:59:39.0877 DFramework.Database.Query /* Time Taken: 503*/ DECLARE @TableName AnsiString(8000) SET @TableName = 'MissingShelf' DECLARE @CurrentRecordId Int32 SET @CurrentRecordId = '3675192' dbo.GetValidDeviceForAlertProcessData 2025-12-26 06:59:43.1503 AlertProcessor ProcessorAlertData: Stopped 2025-12-26 07:04:37.8711 AlertProcessor ProcessorAlertData: started 2025-12-26 07:04:39.5274 DFramework.Database.Query /* Time Taken: 676*/ DECLARE @TableName AnsiString(8000) SET @TableName = 'MissingShelf' DECLARE @CurrentRecordId Int32 SET @CurrentRecordId = '3675192' dbo.GetValidDeviceForAlertProcessData 2025-12-26 07:04:43.6837 AlertProcessor ProcessorAlertData: Stopped 2025-12-26 07:09:37.8732 AlertProcessor ProcessorAlertData: started 2025-12-26 07:09:39.2170 DFramework.Database.Query /* Time Taken: 537*/ DECLARE @TableName AnsiString(8000) SET @TableName = 'MissingShelf' DECLARE @CurrentRecordId Int32 SET @CurrentRecordId = '3675192' dbo.GetValidDeviceForAlertProcessData 2025-12-26 07:09:39.2795 DFramework.Database.Query /* Time Taken: 1514*/ [dbo].GenerateSystemAlerts 2025-12-26 07:09:43.4826 AlertProcessor ProcessorAlertData: Stopped 2025-12-26 07:09:53.4671 DFramework.Scheduler.TaskBase /* Time Taken: 15906.3574*/ Opportunity Out Of Stock By Outlet 2025-12-26 07:14:37.8913 AlertProcessor ProcessorAlertData: started 2025-12-26 07:14:43.0320 AlertProcessor ProcessorAlertData: Stopped 2025-12-26 07:19:37.9092 AlertProcessor ProcessorAlertData: started 2025-12-26 07:19:43.0186 AlertProcessor ProcessorAlertData: Stopped 2025-12-26 07:24:37.9113 AlertProcessor ProcessorAlertData: started 2025-12-26 07:24:38.8800 DFramework.Database.Query /* Time Taken: 1092*/ [dbo].GenerateSystemAlerts 2025-12-26 07:24:43.5832 AlertProcessor ProcessorAlertData: Stopped 2025-12-26 07:24:53.4270 DFramework.Scheduler.TaskBase /* Time Taken: 15843.8555*/ Opportunity Out Of Stock By Outlet 2025-12-26 07:29:37.9292 AlertProcessor ProcessorAlertData: started 2025-12-26 07:29:42.9918 AlertProcessor ProcessorAlertData: Stopped 2025-12-26 07:34:37.9315 AlertProcessor ProcessorAlertData: started 2025-12-26 07:34:38.6815 MoveToReorder Running task for ClientId : 286 and ClientName = India Office QA and Slot: 12/26/2025 9:00:00 PM And LastExecutedOn: 12/26/2025 8:04:38 PM 2025-12-26 07:34:39.1346 MoveToReorder Task executed successfully for ClientId : 286 Client Name:India Office QA, Slot: 12/26/2025 9:00:00 PM But No Order found to suggest 2025-12-26 07:34:43.4940 AlertProcessor ProcessorAlertData: Stopped 2025-12-26 07:39:37.9336 AlertProcessor ProcessorAlertData: started 2025-12-26 07:39:38.8867 DFramework.Database.Query /* Time Taken: 1070*/ [dbo].GenerateSystemAlerts 2025-12-26 07:39:40.1211 DFramework.Database.Query /* Time Taken: 2430*/ DECLARE @ClientId Int32 SET @ClientId = '213' 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 = '8/28/2025 12:00:00 AM' dbo.GetOpportunityOutOfStockDataByOutlet 2025-12-26 07:39:43.4493 AlertProcessor ProcessorAlertData: Stopped 2025-12-26 07:39:55.4650 DFramework.Scheduler.TaskBase /* Time Taken: 17875.1246*/ Opportunity Out Of Stock By Outlet 2025-12-26 07:44:37.9514 AlertProcessor ProcessorAlertData: started 2025-12-26 07:44:38.8889 DFramework.Database.Query /* Time Taken: 502*/ DECLARE @TableName AnsiString(8000) SET @TableName = 'VoidAlert' DECLARE @CurrentRecordId Int32 SET @CurrentRecordId = '3675192' dbo.GetValidDeviceForAlertProcessData 2025-12-26 07:44:43.3577 AlertProcessor ProcessorAlertData: Stopped 2025-12-26 07:49:37.9695 AlertProcessor ProcessorAlertData: started 2025-12-26 07:49:43.0320 AlertProcessor ProcessorAlertData: Stopped 2025-12-26 07:54:37.9717 AlertProcessor ProcessorAlertData: started 2025-12-26 07:54:38.8467 DFramework.Database.Query /* Time Taken: 553*/ 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-26 07:54:39.3467 DFramework.Database.Query /* Time Taken: 515*/ DECLARE @TableName AnsiString(8000) SET @TableName = 'MissingShelf' DECLARE @CurrentRecordId Int32 SET @CurrentRecordId = '3675192' dbo.GetValidDeviceForAlertProcessData 2025-12-26 07:54:39.4717 DFramework.Database.Query /* Time Taken: 1626*/ [dbo].GenerateSystemAlerts 2025-12-26 07:54:43.4249 AlertProcessor ProcessorAlertData: Stopped 2025-12-26 07:54:53.2530 DFramework.Scheduler.TaskBase /* Time Taken: 15656.3596*/ Opportunity Out Of Stock By Outlet 2025-12-26 07:59:37.9894 AlertProcessor ProcessorAlertData: started 2025-12-26 07:59:42.8176 DFramework.Database.NullableDataReader Data reader open for 271 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-26 07:59:43.2863 AlertProcessor ProcessorAlertData: Stopped 2025-12-26 08:04:38.0074 AlertProcessor ProcessorAlertData: started 2025-12-26 08:04:43.2106 AlertProcessor ProcessorAlertData: Stopped 2025-12-26 08:09:38.0253 AlertProcessor ProcessorAlertData: started 2025-12-26 08:09:38.6347 DFramework.Database.Query /* Time Taken: 791*/ [dbo].GenerateSystemAlerts 2025-12-26 08:09:43.3535 AlertProcessor ProcessorAlertData: Stopped 2025-12-26 08:09:53.1817 DFramework.Scheduler.TaskBase /* Time Taken: 15562.6123*/ Opportunity Out Of Stock By Outlet 2025-12-26 08:14:38.0430 AlertProcessor ProcessorAlertData: started 2025-12-26 08:14:43.1212 AlertProcessor ProcessorAlertData: Stopped 2025-12-26 08:19:38.0609 AlertProcessor ProcessorAlertData: started 2025-12-26 08:19:43.3891 AlertProcessor ProcessorAlertData: Stopped 2025-12-26 08:24:38.0789 AlertProcessor ProcessorAlertData: started 2025-12-26 08:24:38.9696 DFramework.Database.Query /* Time Taken: 1109*/ [dbo].GenerateSystemAlerts 2025-12-26 08:24:44.0009 AlertProcessor ProcessorAlertData: Stopped 2025-12-26 08:24:53.2509 DFramework.Scheduler.TaskBase /* Time Taken: 15609.4862*/ Opportunity Out Of Stock By Outlet 2025-12-26 08:29:38.0967 AlertProcessor ProcessorAlertData: started 2025-12-26 08:29:43.3937 AlertProcessor ProcessorAlertData: Stopped 2025-12-26 08:34:38.1145 AlertProcessor ProcessorAlertData: started 2025-12-26 08:34:38.5519 MoveToReorder Running task for ClientId : 286 and ClientName = India Office QA and Slot: 12/26/2025 10:00:00 PM And LastExecutedOn: 12/26/2025 9:04:38 PM 2025-12-26 08:34:38.7238 DFramework.Database.Query /* Time Taken: 605*/ DECLARE @TableName AnsiString(8000) SET @TableName = 'TagAlert' DECLARE @CurrentRecordId Int32 SET @CurrentRecordId = '0' dbo.GetValidDeviceForAlertProcessData 2025-12-26 08:34:43.0832 DFramework.Database.Query /* Time Taken: 837*/ DECLARE @TableName AnsiString(8000) SET @TableName = 'AssetPurity' DECLARE @CurrentRecordId Int32 SET @CurrentRecordId = '3675192' dbo.GetValidDeviceForAlertProcessData 2025-12-26 08:34:43.7239 DFramework.Database.Query /* Time Taken: 581*/ DECLARE @TableName AnsiString(8000) SET @TableName = 'OpportunityLowStock' DECLARE @CurrentRecordId Int32 SET @CurrentRecordId = '3675192' dbo.GetValidDeviceForAlertProcessData 2025-12-26 08:34:45.1770 AlertProcessor ProcessorAlertData: Stopped 2025-12-26 08:34:54.7083 DFramework.Database.NullableDataReader Data reader open for 15648 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-26 08:34:54.7396 MoveToReorder Task executed successfully for ClientId : 286 Client Name:India Office QA, Slot: 12/26/2025 10:00:00 PM and Total Order Suggested: 36 Out Of: 36 2025-12-26 08:34:55.8021 DFramework.Scheduler.TaskBase /* Time Taken: 17781.3701*/ Move To Re-Order 2025-12-26 08:39:38.1170 AlertProcessor ProcessorAlertData: started 2025-12-26 08:39:38.9295 DFramework.Database.Query /* Time Taken: 1054*/ [dbo].GenerateSystemAlerts 2025-12-26 08:39:40.2420 DFramework.Database.Query /* Time Taken: 684*/ DECLARE @TableName AnsiString(8000) SET @TableName = 'AdditionalShelf' DECLARE @CurrentRecordId Int32 SET @CurrentRecordId = '3675192' dbo.GetValidDeviceForAlertProcessData 2025-12-26 08:39:44.2108 AlertProcessor ProcessorAlertData: Stopped 2025-12-26 08:39:53.2734 DFramework.Scheduler.TaskBase /* Time Taken: 15609.4995*/ Opportunity Out Of Stock By Outlet 2025-12-26 08:44:38.1349 AlertProcessor ProcessorAlertData: started 2025-12-26 08:44:43.8537 AlertProcessor ProcessorAlertData: Stopped 2025-12-26 08:49:38.1526 AlertProcessor ProcessorAlertData: started 2025-12-26 08:49:43.7151 AlertProcessor ProcessorAlertData: Stopped 2025-12-26 08:54:38.1706 AlertProcessor ProcessorAlertData: started 2025-12-26 08:54:38.8893 DFramework.Database.Query /* Time Taken: 993*/ [dbo].GenerateSystemAlerts 2025-12-26 08:54:43.9675 AlertProcessor ProcessorAlertData: Stopped 2025-12-26 08:54:53.2801 DFramework.Scheduler.TaskBase /* Time Taken: 15593.8776*/ Opportunity Out Of Stock By Outlet 2025-12-26 08:59:38.1886 AlertProcessor ProcessorAlertData: started 2025-12-26 08:59:43.7823 AlertProcessor ProcessorAlertData: Stopped 2025-12-26 09:04:38.2063 AlertProcessor ProcessorAlertData: started 2025-12-26 09:04:43.8470 AlertProcessor ProcessorAlertData: Stopped 2025-12-26 09:09:38.2241 AlertProcessor ProcessorAlertData: started 2025-12-26 09:09:38.7710 DFramework.Database.Query /* Time Taken: 852*/ [dbo].GenerateSystemAlerts 2025-12-26 09:09:44.1304 AlertProcessor ProcessorAlertData: Stopped 2025-12-26 09:09:53.3024 DFramework.Scheduler.TaskBase /* Time Taken: 15593.8929*/ Opportunity Out Of Stock By Outlet 2025-12-26 09:14:38.2421 AlertProcessor ProcessorAlertData: started 2025-12-26 09:14:43.8672 AlertProcessor ProcessorAlertData: Stopped 2025-12-26 09:19:38.2599 AlertProcessor ProcessorAlertData: started 2025-12-26 09:19:43.9787 AlertProcessor ProcessorAlertData: Stopped 2025-12-26 09:24:38.2620 AlertProcessor ProcessorAlertData: started 2025-12-26 09:24:38.8871 DFramework.Database.Query /* Time Taken: 939*/ [dbo].GenerateSystemAlerts 2025-12-26 09:24:44.3246 AlertProcessor ProcessorAlertData: Stopped 2025-12-26 09:24:53.4965 DFramework.Scheduler.TaskBase /* Time Taken: 15765.7376*/ Opportunity Out Of Stock By Outlet 2025-12-26 09:29:38.2644 AlertProcessor ProcessorAlertData: started 2025-12-26 09:29:43.7644 AlertProcessor ProcessorAlertData: Stopped 2025-12-26 09:34:38.2823 AlertProcessor ProcessorAlertData: started 2025-12-26 09:34:43.7667 AlertProcessor ProcessorAlertData: Stopped 2025-12-26 09:39:38.2844 AlertProcessor ProcessorAlertData: started 2025-12-26 09:39:38.8313 DFramework.Database.Query /* Time Taken: 547*/ DECLARE @TableName AnsiString(8000) SET @TableName = 'TagAlert' DECLARE @CurrentRecordId Int32 SET @CurrentRecordId = '0' dbo.GetValidDeviceForAlertProcessData 2025-12-26 09:39:38.9094 DFramework.Database.Query /* Time Taken: 939*/ [dbo].GenerateSystemAlerts 2025-12-26 09:39:43.9719 AlertProcessor ProcessorAlertData: Stopped 2025-12-26 09:39:53.3314 DFramework.Scheduler.TaskBase /* Time Taken: 15578.2315*/ Opportunity Out Of Stock By Outlet 2025-12-26 09:44:38.3023 AlertProcessor ProcessorAlertData: started 2025-12-26 09:44:38.8179 DFramework.Database.Query /* Time Taken: 508*/ DECLARE @TableName AnsiString(8000) SET @TableName = 'TagAlert' DECLARE @CurrentRecordId Int32 SET @CurrentRecordId = '0' dbo.GetValidDeviceForAlertProcessData 2025-12-26 09:44:44.1149 AlertProcessor ProcessorAlertData: Stopped 2025-12-26 09:49:38.3205 AlertProcessor ProcessorAlertData: started 2025-12-26 09:49:39.5080 DFramework.Database.Query /* Time Taken: 529*/ DECLARE @TableName AnsiString(8000) SET @TableName = 'MissingShelf' DECLARE @CurrentRecordId Int32 SET @CurrentRecordId = '3675192' dbo.GetValidDeviceForAlertProcessData 2025-12-26 09:49:43.9299 AlertProcessor ProcessorAlertData: Stopped 2025-12-26 09:54:38.3383 AlertProcessor ProcessorAlertData: started 2025-12-26 09:54:38.8696 DFramework.Database.Query /* Time Taken: 879*/ [dbo].GenerateSystemAlerts 2025-12-26 09:54:44.1508 AlertProcessor ProcessorAlertData: Stopped 2025-12-26 09:54:53.3540 DFramework.Scheduler.TaskBase /* Time Taken: 15578.2389*/ Opportunity Out Of Stock By Outlet 2025-12-26 09:59:38.3560 AlertProcessor ProcessorAlertData: started 2025-12-26 09:59:41.3561 DFramework.Database.Query /* Time Taken: 511*/ DECLARE @TableName AnsiString(8000) SET @TableName = 'AssetStockProductWiseConsolidate' DECLARE @CurrentRecordId Int32 SET @CurrentRecordId = '3675192' dbo.GetValidDeviceForAlertProcessData 2025-12-26 09:59:43.9498 AlertProcessor ProcessorAlertData: Stopped 2025-12-26 10:04:38.3740 AlertProcessor ProcessorAlertData: started 2025-12-26 10:04:44.1396 AlertProcessor ProcessorAlertData: Stopped 2025-12-26 10:09:38.3761 AlertProcessor ProcessorAlertData: started 2025-12-26 10:09:38.8292 DFramework.Database.Query /* Time Taken: 824*/ [dbo].GenerateSystemAlerts 2025-12-26 10:09:44.2512 AlertProcessor ProcessorAlertData: Stopped 2025-12-26 10:09:53.4544 DFramework.Scheduler.TaskBase /* Time Taken: 15656.3665*/ Opportunity Out Of Stock By Outlet 2025-12-26 10:14:38.3939 AlertProcessor ProcessorAlertData: started 2025-12-26 10:14:44.0502 DFramework.Database.Query /* Time Taken: 540*/ DECLARE @TableName AnsiString(8000) SET @TableName = 'ProductStockLevel' DECLARE @CurrentRecordId Int32 SET @CurrentRecordId = '3675192' dbo.GetValidDeviceForAlertProcessData 2025-12-26 10:14:44.1127 AlertProcessor ProcessorAlertData: Stopped 2025-12-26 10:19:38.4118 AlertProcessor ProcessorAlertData: started 2025-12-26 10:19:43.9588 AlertProcessor ProcessorAlertData: Stopped 2025-12-26 10:24:38.4142 AlertProcessor ProcessorAlertData: started 2025-12-26 10:24:38.9611 DFramework.Database.Query /* Time Taken: 926*/ [dbo].GenerateSystemAlerts 2025-12-26 10:24:44.2737 AlertProcessor ProcessorAlertData: Stopped 2025-12-26 10:24:53.4456 DFramework.Scheduler.TaskBase /* Time Taken: 15625.1166*/ Opportunity Out Of Stock By Outlet 2025-12-26 10:29:38.4164 AlertProcessor ProcessorAlertData: started 2025-12-26 10:29:43.9633 AlertProcessor ProcessorAlertData: Stopped 2025-12-26 10:34:38.4341 AlertProcessor ProcessorAlertData: started 2025-12-26 10:34:43.9967 AlertProcessor ProcessorAlertData: Stopped 2025-12-26 10:39:38.4522 AlertProcessor ProcessorAlertData: started 2025-12-26 10:39:38.9678 DFramework.Database.Query /* Time Taken: 907*/ [dbo].GenerateSystemAlerts 2025-12-26 10:39:38.9834 DFramework.Database.Query /* Time Taken: 529*/ DECLARE @TableName AnsiString(8000) SET @TableName = 'TagAlert' DECLARE @CurrentRecordId Int32 SET @CurrentRecordId = '0' dbo.GetValidDeviceForAlertProcessData 2025-12-26 10:39:44.2491 AlertProcessor ProcessorAlertData: Stopped 2025-12-26 10:39:53.4523 DFramework.Scheduler.TaskBase /* Time Taken: 15609.4908*/ Opportunity Out Of Stock By Outlet 2025-12-26 10:44:38.4700 AlertProcessor ProcessorAlertData: started 2025-12-26 10:44:44.5638 AlertProcessor ProcessorAlertData: Stopped 2025-12-26 10:49:38.4721 AlertProcessor ProcessorAlertData: started 2025-12-26 10:49:44.0971 AlertProcessor ProcessorAlertData: Stopped 2025-12-26 10:54:38.4743 AlertProcessor ProcessorAlertData: started 2025-12-26 10:54:38.9587 DFramework.Database.Query /* Time Taken: 875*/ [dbo].GenerateSystemAlerts 2025-12-26 10:54:44.3025 AlertProcessor ProcessorAlertData: Stopped 2025-12-26 10:54:53.4744 DFramework.Scheduler.TaskBase /* Time Taken: 15609.4908*/ Opportunity Out Of Stock By Outlet 2025-12-26 10:59:38.4921 AlertProcessor ProcessorAlertData: started 2025-12-26 10:59:41.7109 DFramework.Database.NullableDataReader Data reader open for 275 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-26 10:59:44.2421 AlertProcessor ProcessorAlertData: Stopped 2025-12-26 11:04:38.4942 AlertProcessor ProcessorAlertData: started 2025-12-26 11:04:44.2130 AlertProcessor ProcessorAlertData: Stopped 2025-12-26 11:09:38.2310 DFramework.Database.NullableDataReader Data reader open for 318 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.ProcessOutletAlertData.GetAlertDefinitions() in D:\Spraxa\CoolR-Group\portal\CoolR.Tasks\OpportunityOutOfStockByOutlet.cs:line 490 at CoolR.Tasks.ProcessOutletAlertData.Execute() in D:\Spraxa\CoolR-Group\portal\CoolR.Tasks\OpportunityOutOfStockByOutlet.cs:line 72 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-26 11:09:38.5123 AlertProcessor ProcessorAlertData: started 2025-12-26 11:09:38.9498 DFramework.Database.Query /* Time Taken: 843*/ [dbo].GenerateSystemAlerts 2025-12-26 11:09:44.3092 AlertProcessor ProcessorAlertData: Stopped 2025-12-26 11:09:53.8406 DFramework.Scheduler.TaskBase /* Time Taken: 15953.3866*/ Opportunity Out Of Stock By Outlet 2025-12-26 11:14:38.5316 AlertProcessor ProcessorAlertData: started 2025-12-26 11:14:44.1566 AlertProcessor ProcessorAlertData: Stopped 2025-12-26 11:19:38.5341 AlertProcessor ProcessorAlertData: started 2025-12-26 11:19:44.2061 AlertProcessor ProcessorAlertData: Stopped 2025-12-26 11:24:38.5364 AlertProcessor ProcessorAlertData: started 2025-12-26 11:24:39.0051 DFramework.Database.Query /* Time Taken: 883*/ [dbo].GenerateSystemAlerts 2025-12-26 11:24:44.4427 AlertProcessor ProcessorAlertData: Stopped 2025-12-26 11:24:53.5521 DFramework.Scheduler.TaskBase /* Time Taken: 15640.7391*/ Opportunity Out Of Stock By Outlet 2025-12-26 11:29:38.5533 AlertProcessor ProcessorAlertData: started 2025-12-26 11:29:41.6470 DFramework.Database.Query /* Time Taken: 515*/ DECLARE @TableName AnsiString(8000) SET @TableName = 'AssetStockProductWiseConsolidate' DECLARE @CurrentRecordId Int32 SET @CurrentRecordId = '3675192' dbo.GetValidDeviceForAlertProcessData 2025-12-26 11:29:44.2564 AlertProcessor ProcessorAlertData: Stopped 2025-12-26 11:34:38.5706 AlertProcessor ProcessorAlertData: started 2025-12-26 11:34:42.1487 DFramework.Database.NullableDataReader Data reader open for 277 at System.Environment.GetStackTrace(Exception e, Boolean needFileInfo) at System.Environment.get_StackTrace() at DFramework.Database.NullableDataReader.Dispose(Boolean disposing) in D:\Spraxa\Framework\DFramework\Database\NullableDataReader.cs:line 33 at DFramework.Database.NullableDataReader.Dispose() in D:\Spraxa\Framework\DFramework\Database\NullableDataReader.cs:line 44 at CoolR.Tasks.ProcessAlertData.Execute() in D:\Spraxa\CoolR-Group\portal\CoolR.Tasks\ProcessAlertData.cs:line 47 at DFramework.Scheduler.TaskBase.Run() in D:\Spraxa\Framework\DFramework.Scheduler\TaskBase.cs:line 176 at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx) at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx) at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state) at System.Threading.ThreadHelper.ThreadStart() 2025-12-26 11:34:44.4300 AlertProcessor ProcessorAlertData: Stopped 2025-12-26 11:39:38.5726 AlertProcessor ProcessorAlertData: started 2025-12-26 11:39:38.7757 DFramework.Database.Query /* Time Taken: 637*/ [dbo].GenerateSystemAlerts 2025-12-26 11:39:44.1351 AlertProcessor ProcessorAlertData: Stopped 2025-12-26 11:39:53.5570 DFramework.Scheduler.TaskBase /* Time Taken: 15625.1075*/ Opportunity Out Of Stock By Outlet 2025-12-26 11:44:38.5747 AlertProcessor ProcessorAlertData: started 2025-12-26 11:44:44.1060 AlertProcessor ProcessorAlertData: Stopped 2025-12-26 11:49:38.5924 AlertProcessor ProcessorAlertData: started 2025-12-26 11:49:44.3112 AlertProcessor ProcessorAlertData: Stopped 2025-12-26 11:54:38.6102 AlertProcessor ProcessorAlertData: started 2025-12-26 11:54:38.8133 DFramework.Database.Query /* Time Taken: 643*/ [dbo].GenerateSystemAlerts 2025-12-26 11:54:44.3758 AlertProcessor ProcessorAlertData: Stopped 2025-12-26 11:54:53.5791 DFramework.Scheduler.TaskBase /* Time Taken: 15625.1824*/ Opportunity Out Of Stock By Outlet 2025-12-26 11:59:38.6279 AlertProcessor ProcessorAlertData: started 2025-12-26 11:59:44.1123 AlertProcessor ProcessorAlertData: Stopped 2025-12-26 12:04:38.6458 AlertProcessor ProcessorAlertData: started 2025-12-26 12:04:44.3490 AlertProcessor ProcessorAlertData: Stopped 2025-12-26 12:09:38.6636 AlertProcessor ProcessorAlertData: started 2025-12-26 12:09:38.9136 DFramework.Database.Query /* Time Taken: 720*/ [dbo].GenerateSystemAlerts 2025-12-26 12:09:44.3823 AlertProcessor ProcessorAlertData: Stopped 2025-12-26 12:09:53.6012 DFramework.Scheduler.TaskBase /* Time Taken: 15625.1059*/ Opportunity Out Of Stock By Outlet 2025-12-26 12:14:38.6813 AlertProcessor ProcessorAlertData: started 2025-12-26 12:14:44.2282 AlertProcessor ProcessorAlertData: Stopped 2025-12-26 12:19:38.6993 AlertProcessor ProcessorAlertData: started 2025-12-26 12:19:44.2619 AlertProcessor ProcessorAlertData: Stopped 2025-12-26 12:24:38.7173 AlertProcessor ProcessorAlertData: started 2025-12-26 12:24:38.8423 DFramework.Database.Query /* Time Taken: 624*/ [dbo].GenerateSystemAlerts 2025-12-26 12:24:41.8736 DFramework.Database.Query /* Time Taken: 511*/ DECLARE @TableName AnsiString(8000) SET @TableName = 'AssetStockProductWiseConsolidate' DECLARE @CurrentRecordId Int32 SET @CurrentRecordId = '3675192' dbo.GetValidDeviceForAlertProcessData 2025-12-26 12:24:44.4986 AlertProcessor ProcessorAlertData: Stopped 2025-12-26 12:24:53.6236 DFramework.Scheduler.TaskBase /* Time Taken: 15625.113*/ Opportunity Out Of Stock By Outlet 2025-12-26 12:29:38.7351 AlertProcessor ProcessorAlertData: started 2025-12-26 12:29:44.3445 AlertProcessor ProcessorAlertData: Stopped 2025-12-26 12:34:38.7372 AlertProcessor ProcessorAlertData: started 2025-12-26 12:34:44.3466 AlertProcessor ProcessorAlertData: Stopped 2025-12-26 12:39:38.7553 AlertProcessor ProcessorAlertData: started 2025-12-26 12:39:38.7709 DFramework.Database.Query /* Time Taken: 534*/ [dbo].GenerateSystemAlerts 2025-12-26 12:39:44.5365 AlertProcessor ProcessorAlertData: Stopped 2025-12-26 12:39:53.6772 DFramework.Scheduler.TaskBase /* Time Taken: 15656.3673*/ Opportunity Out Of Stock By Outlet 2025-12-26 12:44:38.7731 AlertProcessor ProcessorAlertData: started 2025-12-26 12:44:44.2418 AlertProcessor ProcessorAlertData: Stopped 2025-12-26 12:49:38.7908 AlertProcessor ProcessorAlertData: started 2025-12-26 12:49:44.3221 DFramework.Database.Query /* Time Taken: 502*/ DECLARE @TableName AnsiString(8000) SET @TableName = 'ProductStockLevel' DECLARE @CurrentRecordId Int32 SET @CurrentRecordId = '3675192' dbo.GetValidDeviceForAlertProcessData 2025-12-26 12:49:44.3846 AlertProcessor ProcessorAlertData: Stopped 2025-12-26 12:54:38.8089 AlertProcessor ProcessorAlertData: started 2025-12-26 12:54:38.8714 DFramework.Database.Query /* Time Taken: 619*/ [dbo].GenerateSystemAlerts 2025-12-26 12:54:44.5433 DFramework.Database.Query /* Time Taken: 558*/ DECLARE @TableName AnsiString(8000) SET @TableName = 'ProductStockLevel' DECLARE @CurrentRecordId Int32 SET @CurrentRecordId = '3675192' dbo.GetValidDeviceForAlertProcessData 2025-12-26 12:54:44.6058 AlertProcessor ProcessorAlertData: Stopped 2025-12-26 12:54:53.6215 DFramework.Scheduler.TaskBase /* Time Taken: 15578.2384*/ Opportunity Out Of Stock By Outlet 2025-12-26 12:59:38.8268 AlertProcessor ProcessorAlertData: started 2025-12-26 12:59:44.3737 AlertProcessor ProcessorAlertData: Stopped 2025-12-26 13:04:38.8289 AlertProcessor ProcessorAlertData: started 2025-12-26 13:04:44.3602 AlertProcessor ProcessorAlertData: Stopped 2025-12-26 13:09:38.8312 DFramework.Database.Query /* Time Taken: 546*/ [dbo].GenerateSystemAlerts 2025-12-26 13:09:38.8468 AlertProcessor ProcessorAlertData: started 2025-12-26 13:09:44.4562 AlertProcessor ProcessorAlertData: Stopped 2025-12-26 13:09:53.7219 DFramework.Scheduler.TaskBase /* Time Taken: 15656.3819*/ Opportunity Out Of Stock By Outlet 2025-12-26 13:14:38.8648 AlertProcessor ProcessorAlertData: started 2025-12-26 13:14:44.3961 AlertProcessor ProcessorAlertData: Stopped 2025-12-26 13:19:38.8826 AlertProcessor ProcessorAlertData: started 2025-12-26 13:19:44.4295 AlertProcessor ProcessorAlertData: Stopped 2025-12-26 13:24:38.8706 DFramework.Database.Query /* Time Taken: 582*/ [dbo].GenerateSystemAlerts 2025-12-26 13:24:38.8862 AlertProcessor ProcessorAlertData: started 2025-12-26 13:24:44.7144 AlertProcessor ProcessorAlertData: Stopped 2025-12-26 13:24:53.6832 DFramework.Scheduler.TaskBase /* Time Taken: 15609.4839*/ Opportunity Out Of Stock By Outlet 2025-12-26 13:29:38.9042 AlertProcessor ProcessorAlertData: started 2025-12-26 13:29:44.4199 AlertProcessor ProcessorAlertData: Stopped 2025-12-26 13:34:38.9065 AlertProcessor ProcessorAlertData: started 2025-12-26 13:34:44.4690 AlertProcessor ProcessorAlertData: Stopped 2025-12-26 13:39:38.8461 DFramework.Database.Query /* Time Taken: 531*/ [dbo].GenerateSystemAlerts 2025-12-26 13:39:38.9243 AlertProcessor ProcessorAlertData: started 2025-12-26 13:39:44.5649 AlertProcessor ProcessorAlertData: Stopped 2025-12-26 13:39:53.7369 DFramework.Scheduler.TaskBase /* Time Taken: 15640.736*/ Opportunity Out Of Stock By Outlet 2025-12-26 13:44:38.9422 AlertProcessor ProcessorAlertData: started 2025-12-26 13:44:44.4891 AlertProcessor ProcessorAlertData: Stopped 2025-12-26 13:46:23.6306 DFramework.Database.Query /* Time Taken: 593*/ DECLARE @IsFileProcessed Int32 SET @IsFileProcessed = '0' DECLARE @TaskNumber Int32 SET @TaskNumber = '3' DECLARE @IsDeleted Int32 SET @IsDeleted = '0' SELECT TOP 1000 IncomingFileId, GatewayId,GatewayMac,RawFileName,AzureContainerName,StartIndex,Tries, CreatedOn FROM IncomingFile WHERE [IsFileProcessed] = @IsFileProcessed AND [TaskNumber] = @TaskNumber AND [IsDeleted] = @IsDeleted 2025-12-26 13:46:23.6306 DFramework.Database.Query /* Time Taken: 595*/ DECLARE @IsFileProcessed Int32 SET @IsFileProcessed = '0' DECLARE @TaskNumber Int32 SET @TaskNumber = '4' DECLARE @IsDeleted Int32 SET @IsDeleted = '0' SELECT TOP 1000 IncomingFileId, GatewayId,GatewayMac,RawFileName,AzureContainerName,StartIndex,Tries, CreatedOn FROM IncomingFile WHERE [IsFileProcessed] = @IsFileProcessed AND [TaskNumber] = @TaskNumber AND [IsDeleted] = @IsDeleted 2025-12-26 13:46:23.6306 DFramework.Database.Query /* Time Taken: 594*/ DECLARE @IsFileProcessed Int32 SET @IsFileProcessed = '0' DECLARE @TaskNumber Int32 SET @TaskNumber = '2' DECLARE @IsDeleted Int32 SET @IsDeleted = '0' SELECT TOP 1000 IncomingFileId, GatewayId,GatewayMac,RawFileName,AzureContainerName,StartIndex,Tries, CreatedOn FROM IncomingFile WHERE [IsFileProcessed] = @IsFileProcessed AND [TaskNumber] = @TaskNumber AND [IsDeleted] = @IsDeleted 2025-12-26 13:46:23.6306 DFramework.Database.Query /* Time Taken: 595*/ DECLARE @IsFileProcessed Int32 SET @IsFileProcessed = '0' DECLARE @TaskNumber Int32 SET @TaskNumber = '1' DECLARE @IsDeleted Int32 SET @IsDeleted = '0' SELECT TOP 1000 IncomingFileId, GatewayId,GatewayMac,RawFileName,AzureContainerName,StartIndex,Tries, CreatedOn FROM IncomingFile WHERE [IsFileProcessed] = @IsFileProcessed AND [TaskNumber] = @TaskNumber AND [IsDeleted] = @IsDeleted 2025-12-26 13:49:38.9602 AlertProcessor ProcessorAlertData: started 2025-12-26 13:49:44.8508 AlertProcessor ProcessorAlertData: Stopped 2025-12-26 13:54:38.8998 DFramework.Database.Query /* Time Taken: 572*/ [dbo].GenerateSystemAlerts 2025-12-26 13:54:38.9780 AlertProcessor ProcessorAlertData: started 2025-12-26 13:54:44.7749 AlertProcessor ProcessorAlertData: Stopped 2025-12-26 13:54:53.7750 DFramework.Scheduler.TaskBase /* Time Taken: 15656.3484*/ Opportunity Out Of Stock By Outlet 2025-12-26 13:59:38.9958 AlertProcessor ProcessorAlertData: started 2025-12-26 13:59:44.9021 AlertProcessor ProcessorAlertData: Stopped 2025-12-26 14:04:39.0138 AlertProcessor ProcessorAlertData: started 2025-12-26 14:04:44.8576 AlertProcessor ProcessorAlertData: Stopped 2025-12-26 14:09:38.9066 DFramework.Database.Query /* Time Taken: 546*/ [dbo].GenerateSystemAlerts 2025-12-26 14:09:39.0316 AlertProcessor ProcessorAlertData: started 2025-12-26 14:09:44.8285 AlertProcessor ProcessorAlertData: Stopped 2025-12-26 14:09:53.8442 DFramework.Scheduler.TaskBase /* Time Taken: 15718.8632*/ Opportunity Out Of Stock By Outlet 2025-12-26 14:14:39.0494 AlertProcessor ProcessorAlertData: started 2025-12-26 14:14:44.9088 AlertProcessor ProcessorAlertData: Stopped 2025-12-26 14:19:39.0517 AlertProcessor ProcessorAlertData: started 2025-12-26 14:19:43.7861 DFramework.Database.NullableDataReader Data reader open for 275 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-26 14:19:44.8642 AlertProcessor ProcessorAlertData: Stopped 2025-12-26 14:24:38.9446 DFramework.Database.Query /* Time Taken: 576*/ [dbo].GenerateSystemAlerts 2025-12-26 14:24:39.0540 AlertProcessor ProcessorAlertData: started 2025-12-26 14:24:40.5384 DFramework.Database.Query /* Time Taken: 675*/ DECLARE @TableName AnsiString(8000) SET @TableName = 'MissingShelf' DECLARE @CurrentRecordId Int32 SET @CurrentRecordId = '3675192' dbo.GetValidDeviceForAlertProcessData 2025-12-26 14:24:45.2259 AlertProcessor ProcessorAlertData: Stopped 2025-12-26 14:24:53.8353 DFramework.Scheduler.TaskBase /* Time Taken: 15687.618*/ Opportunity Out Of Stock By Outlet 2025-12-26 14:29:39.0717 AlertProcessor ProcessorAlertData: started 2025-12-26 14:29:44.7905 AlertProcessor ProcessorAlertData: Stopped 2025-12-26 14:34:39.0896 AlertProcessor ProcessorAlertData: started 2025-12-26 14:34:44.9021 AlertProcessor ProcessorAlertData: Stopped 2025-12-26 14:39:38.9201 DFramework.Database.Query /* Time Taken: 543*/ [dbo].GenerateSystemAlerts 2025-12-26 14:39:39.0919 AlertProcessor ProcessorAlertData: started 2025-12-26 14:39:44.8263 AlertProcessor ProcessorAlertData: Stopped 2025-12-26 14:39:53.7952 DFramework.Scheduler.TaskBase /* Time Taken: 15625.1155*/ Opportunity Out Of Stock By Outlet 2025-12-26 14:44:39.1097 AlertProcessor ProcessorAlertData: started 2025-12-26 14:44:44.7816 AlertProcessor ProcessorAlertData: Stopped 2025-12-26 14:49:39.1275 AlertProcessor ProcessorAlertData: started 2025-12-26 14:49:44.8932 AlertProcessor ProcessorAlertData: Stopped 2025-12-26 14:54:38.9736 DFramework.Database.Query /* Time Taken: 566*/ [dbo].GenerateSystemAlerts 2025-12-26 14:54:39.1455 AlertProcessor ProcessorAlertData: started 2025-12-26 14:54:44.8643 AlertProcessor ProcessorAlertData: Stopped 2025-12-26 14:54:53.8956 DFramework.Scheduler.TaskBase /* Time Taken: 15703.2459*/ Opportunity Out Of Stock By Outlet 2025-12-26 14:59:39.1634 AlertProcessor ProcessorAlertData: started 2025-12-26 14:59:44.9134 AlertProcessor ProcessorAlertData: Stopped 2025-12-26 15:04:39.1811 AlertProcessor ProcessorAlertData: started 2025-12-26 15:04:44.9780 AlertProcessor ProcessorAlertData: Stopped 2025-12-26 15:09:38.9803 DFramework.Database.Query /* Time Taken: 549*/ [dbo].GenerateSystemAlerts 2025-12-26 15:09:39.1990 AlertProcessor ProcessorAlertData: started 2025-12-26 15:09:44.9178 AlertProcessor ProcessorAlertData: Stopped 2025-12-26 15:09:53.9336 DFramework.Scheduler.TaskBase /* Time Taken: 15718.8827*/ Opportunity Out Of Stock By Outlet 2025-12-26 15:14:39.2014 AlertProcessor ProcessorAlertData: started 2025-12-26 15:14:44.9983 AlertProcessor ProcessorAlertData: Stopped 2025-12-26 15:19:39.2192 AlertProcessor ProcessorAlertData: started 2025-12-26 15:19:44.9536 AlertProcessor ProcessorAlertData: Stopped 2025-12-26 15:24:39.0182 DFramework.Database.Query /* Time Taken: 574*/ [dbo].GenerateSystemAlerts 2025-12-26 15:24:39.2370 AlertProcessor ProcessorAlertData: started 2025-12-26 15:24:39.7839 DFramework.Database.Query /* Time Taken: 546*/ DECLARE @TableName AnsiString(8000) SET @TableName = 'TagAlert' DECLARE @CurrentRecordId Int32 SET @CurrentRecordId = '0' dbo.GetValidDeviceForAlertProcessData 2025-12-26 15:24:45.2214 AlertProcessor ProcessorAlertData: Stopped 2025-12-26 15:24:53.8621 DFramework.Scheduler.TaskBase /* Time Taken: 15625.1077*/ Opportunity Out Of Stock By Outlet 2025-12-26 15:29:39.2393 AlertProcessor ProcessorAlertData: started 2025-12-26 15:29:44.9269 AlertProcessor ProcessorAlertData: Stopped 2025-12-26 15:34:39.2415 AlertProcessor ProcessorAlertData: started 2025-12-26 15:34:44.7416 AlertProcessor ProcessorAlertData: Stopped 2025-12-26 15:39:39.0249 DFramework.Database.Query /* Time Taken: 552*/ [dbo].GenerateSystemAlerts 2025-12-26 15:39:39.2437 AlertProcessor ProcessorAlertData: started 2025-12-26 15:39:44.8687 AlertProcessor ProcessorAlertData: Stopped 2025-12-26 15:39:53.8688 DFramework.Scheduler.TaskBase /* Time Taken: 15609.4845*/ Opportunity Out Of Stock By Outlet 2025-12-26 15:44:39.2617 AlertProcessor ProcessorAlertData: started 2025-12-26 15:44:44.8086 AlertProcessor ProcessorAlertData: Stopped 2025-12-26 15:49:39.2796 AlertProcessor ProcessorAlertData: started 2025-12-26 15:49:44.7953 AlertProcessor ProcessorAlertData: Stopped 2025-12-26 15:54:39.0474 DFramework.Database.Query /* Time Taken: 554*/ [dbo].GenerateSystemAlerts 2025-12-26 15:54:39.2974 AlertProcessor ProcessorAlertData: started 2025-12-26 15:54:44.8443 AlertProcessor ProcessorAlertData: Stopped 2025-12-26 15:54:53.8756 DFramework.Scheduler.TaskBase /* Time Taken: 15593.8442*/ Opportunity Out Of Stock By Outlet 2025-12-26 15:59:39.2995 AlertProcessor ProcessorAlertData: started 2025-12-26 15:59:44.8777 AlertProcessor ProcessorAlertData: Stopped 2025-12-26 16:04:39.3019 AlertProcessor ProcessorAlertData: started 2025-12-26 16:04:44.9739 AlertProcessor ProcessorAlertData: Stopped 2025-12-26 16:09:39.0385 DFramework.Database.Query /* Time Taken: 530*/ [dbo].GenerateSystemAlerts 2025-12-26 16:09:39.3198 AlertProcessor ProcessorAlertData: started 2025-12-26 16:09:44.8354 AlertProcessor ProcessorAlertData: Stopped 2025-12-26 16:09:53.9605 DFramework.Scheduler.TaskBase /* Time Taken: 15656.3718*/ Opportunity Out Of Stock By Outlet 2025-12-26 16:14:39.3375 AlertProcessor ProcessorAlertData: started 2025-12-26 16:14:44.8063 AlertProcessor ProcessorAlertData: Stopped 2025-12-26 16:19:39.3555 AlertProcessor ProcessorAlertData: started 2025-12-26 16:19:44.9024 AlertProcessor ProcessorAlertData: Stopped 2025-12-26 16:24:39.3734 AlertProcessor ProcessorAlertData: started 2025-12-26 16:24:39.4359 DFramework.Database.Query /* Time Taken: 898*/ [dbo].GenerateSystemAlerts 2025-12-26 16:24:44.9984 AlertProcessor ProcessorAlertData: Stopped 2025-12-26 16:24:54.0141 DFramework.Scheduler.TaskBase /* Time Taken: 15687.6158*/ Opportunity Out Of Stock By Outlet 2025-12-26 16:29:39.3911 AlertProcessor ProcessorAlertData: started 2025-12-26 16:29:44.8912 AlertProcessor ProcessorAlertData: Stopped 2025-12-26 16:34:39.3934 AlertProcessor ProcessorAlertData: started 2025-12-26 16:34:45.0185 AlertProcessor ProcessorAlertData: Stopped 2025-12-26 16:39:39.1146 DFramework.Database.Query /* Time Taken: 551*/ [dbo].GenerateSystemAlerts 2025-12-26 16:39:39.4115 AlertProcessor ProcessorAlertData: started 2025-12-26 16:39:45.0209 AlertProcessor ProcessorAlertData: Stopped 2025-12-26 16:39:53.9897 DFramework.Scheduler.TaskBase /* Time Taken: 15640.7409*/ Opportunity Out Of Stock By Outlet 2025-12-26 16:44:39.4137 AlertProcessor ProcessorAlertData: started 2025-12-26 16:44:44.9918 AlertProcessor ProcessorAlertData: Stopped 2025-12-26 16:49:39.4315 AlertProcessor ProcessorAlertData: started 2025-12-26 16:49:44.9471 AlertProcessor ProcessorAlertData: Stopped 2025-12-26 16:54:39.1526 DFramework.Database.Query /* Time Taken: 567*/ [dbo].GenerateSystemAlerts 2025-12-26 16:54:39.4495 AlertProcessor ProcessorAlertData: started 2025-12-26 16:54:45.0902 AlertProcessor ProcessorAlertData: Stopped 2025-12-26 16:54:53.9652 DFramework.Scheduler.TaskBase /* Time Taken: 15593.8632*/ Opportunity Out Of Stock By Outlet 2025-12-26 16:59:39.4674 AlertProcessor ProcessorAlertData: started 2025-12-26 16:59:41.2643 DFramework.Database.Query /* Time Taken: 560*/ DECLARE @TableName AnsiString(8000) SET @TableName = 'AdditionalShelf' DECLARE @CurrentRecordId Int32 SET @CurrentRecordId = '3675192' dbo.GetValidDeviceForAlertProcessData 2025-12-26 16:59:45.1237 AlertProcessor ProcessorAlertData: Stopped 2025-12-26 17:04:39.4852 AlertProcessor ProcessorAlertData: started 2025-12-26 17:04:45.0477 AlertProcessor ProcessorAlertData: Stopped 2025-12-26 17:09:39.1437 DFramework.Database.Query /* Time Taken: 544*/ [dbo].GenerateSystemAlerts 2025-12-26 17:09:39.5031 AlertProcessor ProcessorAlertData: started 2025-12-26 17:09:45.1750 AlertProcessor ProcessorAlertData: Stopped 2025-12-26 17:09:53.9719 DFramework.Scheduler.TaskBase /* Time Taken: 15578.2503*/ Opportunity Out Of Stock By Outlet 2025-12-26 17:14:39.5209 AlertProcessor ProcessorAlertData: started 2025-12-26 17:14:45.1616 AlertProcessor ProcessorAlertData: Stopped 2025-12-26 17:19:39.5387 AlertProcessor ProcessorAlertData: started 2025-12-26 17:19:45.3044 AlertProcessor ProcessorAlertData: Stopped 2025-12-26 17:24:39.2128 DFramework.Database.Query /* Time Taken: 580*/ [dbo].GenerateSystemAlerts 2025-12-26 17:24:39.5409 AlertProcessor ProcessorAlertData: started 2025-12-26 17:24:40.0409 DFramework.Database.Query /* Time Taken: 511*/ DECLARE @TableName AnsiString(8000) SET @TableName = 'TagAlert' DECLARE @CurrentRecordId Int32 SET @CurrentRecordId = '0' dbo.GetValidDeviceForAlertProcessData 2025-12-26 17:24:42.8378 DFramework.Database.Query /* Time Taken: 517*/ DECLARE @TableName AnsiString(8000) SET @TableName = 'AssetStockProductWiseConsolidate' DECLARE @CurrentRecordId Int32 SET @CurrentRecordId = '3675192' dbo.GetValidDeviceForAlertProcessData 2025-12-26 17:24:45.6347 DFramework.Database.Query /* Time Taken: 530*/ DECLARE @TableName AnsiString(8000) SET @TableName = 'ProductStockLevel' DECLARE @CurrentRecordId Int32 SET @CurrentRecordId = '3675192' dbo.GetValidDeviceForAlertProcessData 2025-12-26 17:24:45.6972 AlertProcessor ProcessorAlertData: Stopped 2025-12-26 17:24:54.0723 DFramework.Scheduler.TaskBase /* Time Taken: 15656.374*/ Opportunity Out Of Stock By Outlet 2025-12-26 17:29:39.5589 AlertProcessor ProcessorAlertData: started 2025-12-26 17:29:45.1371 AlertProcessor ProcessorAlertData: Stopped 2025-12-26 17:34:39.5768 AlertProcessor ProcessorAlertData: started 2025-12-26 17:34:45.1549 AlertProcessor ProcessorAlertData: Stopped 2025-12-26 17:39:39.1883 DFramework.Database.Query /* Time Taken: 532*/ [dbo].GenerateSystemAlerts 2025-12-26 17:39:39.5946 AlertProcessor ProcessorAlertData: started 2025-12-26 17:39:45.2040 AlertProcessor ProcessorAlertData: Stopped 2025-12-26 17:39:54.0322 DFramework.Scheduler.TaskBase /* Time Taken: 15593.8601*/ Opportunity Out Of Stock By Outlet 2025-12-26 17:44:39.6125 AlertProcessor ProcessorAlertData: started 2025-12-26 17:44:44.9251 AlertProcessor ProcessorAlertData: Stopped 2025-12-26 17:49:39.6305 AlertProcessor ProcessorAlertData: started 2025-12-26 17:49:45.1461 AlertProcessor ProcessorAlertData: Stopped 2025-12-26 17:54:39.2264 DFramework.Database.Query /* Time Taken: 550*/ [dbo].GenerateSystemAlerts 2025-12-26 17:54:39.6483 AlertProcessor ProcessorAlertData: started 2025-12-26 17:54:45.1639 AlertProcessor ProcessorAlertData: Stopped 2025-12-26 17:54:54.0390 DFramework.Scheduler.TaskBase /* Time Taken: 15578.2399*/ Opportunity Out Of Stock By Outlet 2025-12-26 17:59:39.6661 AlertProcessor ProcessorAlertData: started 2025-12-26 17:59:45.2287 AlertProcessor ProcessorAlertData: Stopped 2025-12-26 18:04:39.6841 AlertProcessor ProcessorAlertData: started 2025-12-26 18:04:40.5122 DFramework.Database.Query /* Time Taken: 828*/ DECLARE @TableName AnsiString(8000) SET @TableName = 'TagAlert' DECLARE @CurrentRecordId Int32 SET @CurrentRecordId = '0' dbo.GetValidDeviceForAlertProcessData 2025-12-26 18:04:40.5904 DFramework.Database.Query /* Time Taken: 517*/ 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-26 18:04:41.6216 DFramework.Database.Query /* Time Taken: 691*/ DECLARE @TableName AnsiString(8000) SET @TableName = 'MissingShelf' DECLARE @CurrentRecordId Int32 SET @CurrentRecordId = '3675192' dbo.GetValidDeviceForAlertProcessData 2025-12-26 18:04:43.6060 DFramework.Database.Query /* Time Taken: 609*/ DECLARE @TableName AnsiString(8000) SET @TableName = 'AssetStockProductWiseConsolidate' DECLARE @CurrentRecordId Int32 SET @CurrentRecordId = '3675192' dbo.GetValidDeviceForAlertProcessData 2025-12-26 18:04:46.1685 AlertProcessor ProcessorAlertData: Stopped 2025-12-26 18:09:39.6863 AlertProcessor ProcessorAlertData: started 2025-12-26 18:09:40.0457 DFramework.Database.Query /* Time Taken: 1352*/ [dbo].GenerateSystemAlerts 2025-12-26 18:09:45.4520 AlertProcessor ProcessorAlertData: Stopped 2025-12-26 18:09:54.3270 DFramework.Scheduler.TaskBase /* Time Taken: 15843.8662*/ Opportunity Out Of Stock By Outlet 2025-12-26 18:14:39.7041 AlertProcessor ProcessorAlertData: started 2025-12-26 18:14:45.3448 AlertProcessor ProcessorAlertData: Stopped 2025-12-26 18:16:08.6891 DFramework.Database.Query /* Time Taken: 735*/ DECLARE @IsFileProcessed Int32 SET @IsFileProcessed = '0' DECLARE @TaskNumber Int32 SET @TaskNumber = '2' DECLARE @IsDeleted Int32 SET @IsDeleted = '0' SELECT TOP 1000 IncomingFileId, GatewayId,GatewayMac,RawFileName,AzureContainerName,StartIndex,Tries, CreatedOn FROM IncomingFile WHERE [IsFileProcessed] = @IsFileProcessed AND [TaskNumber] = @TaskNumber AND [IsDeleted] = @IsDeleted 2025-12-26 18:19:39.7064 AlertProcessor ProcessorAlertData: started 2025-12-26 18:19:43.8158 DFramework.Database.NullableDataReader Data reader open for 280 at System.Environment.GetStackTrace(Exception e, Boolean needFileInfo) at System.Environment.get_StackTrace() at DFramework.Database.NullableDataReader.Dispose(Boolean disposing) in D:\Spraxa\Framework\DFramework\Database\NullableDataReader.cs:line 33 at DFramework.Database.NullableDataReader.Dispose() in D:\Spraxa\Framework\DFramework\Database\NullableDataReader.cs:line 44 at CoolR.Tasks.ProcessAlertData.Execute() in D:\Spraxa\CoolR-Group\portal\CoolR.Tasks\ProcessAlertData.cs:line 47 at DFramework.Scheduler.TaskBase.Run() in D:\Spraxa\Framework\DFramework.Scheduler\TaskBase.cs:line 176 at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx) at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx) at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state) at System.Threading.ThreadHelper.ThreadStart() 2025-12-26 18:19:45.4721 AlertProcessor ProcessorAlertData: Stopped 2025-12-26 18:24:39.2868 DFramework.Database.Query /* Time Taken: 565*/ [dbo].GenerateSystemAlerts 2025-12-26 18:24:39.7399 AlertProcessor ProcessorAlertData: started 2025-12-26 18:24:45.4899 AlertProcessor ProcessorAlertData: Stopped 2025-12-26 18:24:54.1150 DFramework.Scheduler.TaskBase /* Time Taken: 15609.4921*/ Opportunity Out Of Stock By Outlet 2025-12-26 18:29:39.7421 AlertProcessor ProcessorAlertData: started 2025-12-26 18:29:45.2890 AlertProcessor ProcessorAlertData: Stopped 2025-12-26 18:34:39.4630 MoveToReorder Running task for ClientId : 286 and ClientName = India Office QA and Slot: 12/27/2025 8:00:00 AM And LastExecutedOn: 12/26/2025 10:04:38 PM 2025-12-26 18:34:39.7442 AlertProcessor ProcessorAlertData: started 2025-12-26 18:34:40.6193 DFramework.Database.Query /* Time Taken: 1104*/ DECLARE @OrderStatusId Int32 SET @OrderStatusId = '0' DECLARE @ClientId Int32 SET @ClientId = '286' dbo.GetOrderDetailsByClientId 2025-12-26 18:34:45.8849 AlertProcessor ProcessorAlertData: Stopped 2025-12-26 18:35:23.1196 DFramework.Database.NullableDataReader Data reader open for 42219 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-26 18:35:23.1508 MoveToReorder Task executed successfully for ClientId : 286 Client Name:India Office QA, Slot: 12/27/2025 8:00:00 AM and Total Order Suggested: 127 Out Of: 127 2025-12-26 18:35:23.8227 DFramework.Database.Query /* Time Taken: 674*/ DECLARE @ClientId Int32 SET @ClientId = '286' dbo.GetMoveToReOrderList 2025-12-26 18:35:24.8539 DFramework.Database.Query /* Time Taken: 622*/ 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-26 18:35:25.0883 DFramework.Scheduler.TaskBase /* Time Taken: 46031.5868*/ Move To Re-Order 2025-12-26 18:37:52.8394 DFramework.Database.Query /* Time Taken: 1346*/ DECLARE @IsFileProcessed Int32 SET @IsFileProcessed = '0' DECLARE @TaskNumber Int32 SET @TaskNumber = '3' DECLARE @IsDeleted Int32 SET @IsDeleted = '0' SELECT TOP 1000 IncomingFileId, GatewayId,GatewayMac,RawFileName,AzureContainerName,StartIndex,Tries, CreatedOn FROM IncomingFile WHERE [IsFileProcessed] = @IsFileProcessed AND [TaskNumber] = @TaskNumber AND [IsDeleted] = @IsDeleted 2025-12-26 18:37:52.8394 DFramework.Database.Query /* Time Taken: 1348*/ DECLARE @IsFileProcessed Int32 SET @IsFileProcessed = '0' DECLARE @TaskNumber Int32 SET @TaskNumber = '4' DECLARE @IsDeleted Int32 SET @IsDeleted = '0' SELECT TOP 1000 IncomingFileId, GatewayId,GatewayMac,RawFileName,AzureContainerName,StartIndex,Tries, CreatedOn FROM IncomingFile WHERE [IsFileProcessed] = @IsFileProcessed AND [TaskNumber] = @TaskNumber AND [IsDeleted] = @IsDeleted 2025-12-26 18:37:57.0113 DFramework.Database.Query /* Time Taken: 508*/ DECLARE @IsFileProcessed Int32 SET @IsFileProcessed = '0' DECLARE @TaskNumber Int32 SET @TaskNumber = '4' DECLARE @IsDeleted Int32 SET @IsDeleted = '0' SELECT TOP 1000 IncomingFileId, GatewayId,GatewayMac,RawFileName,AzureContainerName,StartIndex,Tries, CreatedOn FROM IncomingFile WHERE [IsFileProcessed] = @IsFileProcessed AND [TaskNumber] = @TaskNumber AND [IsDeleted] = @IsDeleted 2025-12-26 18:37:57.0425 DFramework.Database.Query /* Time Taken: 531*/ DECLARE @IsFileProcessed Int32 SET @IsFileProcessed = '0' DECLARE @TaskNumber Int32 SET @TaskNumber = '3' DECLARE @IsDeleted Int32 SET @IsDeleted = '0' SELECT TOP 1000 IncomingFileId, GatewayId,GatewayMac,RawFileName,AzureContainerName,StartIndex,Tries, CreatedOn FROM IncomingFile WHERE [IsFileProcessed] = @IsFileProcessed AND [TaskNumber] = @TaskNumber AND [IsDeleted] = @IsDeleted 2025-12-26 18:38:05.1832 DFramework.Database.Query /* Time Taken: 3668*/ DECLARE @IsFileProcessed Int32 SET @IsFileProcessed = '0' DECLARE @TaskNumber Int32 SET @TaskNumber = '3' DECLARE @IsDeleted Int32 SET @IsDeleted = '0' SELECT TOP 1000 IncomingFileId, GatewayId,GatewayMac,RawFileName,AzureContainerName,StartIndex,Tries, CreatedOn FROM IncomingFile WHERE [IsFileProcessed] = @IsFileProcessed AND [TaskNumber] = @TaskNumber AND [IsDeleted] = @IsDeleted 2025-12-26 18:39:39.2776 DFramework.Database.Query /* Time Taken: 539*/ [dbo].GenerateSystemAlerts 2025-12-26 18:39:39.7620 AlertProcessor ProcessorAlertData: started 2025-12-26 18:39:45.3558 AlertProcessor ProcessorAlertData: Stopped 2025-12-26 18:39:54.1996 DFramework.Scheduler.TaskBase /* Time Taken: 15671.9888*/ Opportunity Out Of Stock By Outlet 2025-12-26 18:44:39.7798 AlertProcessor ProcessorAlertData: started 2025-12-26 18:44:45.3892 AlertProcessor ProcessorAlertData: Stopped 2025-12-26 18:49:39.7976 AlertProcessor ProcessorAlertData: started 2025-12-26 18:49:45.3289 AlertProcessor ProcessorAlertData: Stopped 2025-12-26 18:54:39.3311 DFramework.Database.Query /* Time Taken: 564*/ [dbo].GenerateSystemAlerts 2025-12-26 18:54:39.8155 AlertProcessor ProcessorAlertData: started 2025-12-26 18:54:45.3468 AlertProcessor ProcessorAlertData: Stopped 2025-12-26 18:54:54.1281 DFramework.Scheduler.TaskBase /* Time Taken: 15578.2478*/ Opportunity Out Of Stock By Outlet 2025-12-26 18:59:39.8176 AlertProcessor ProcessorAlertData: started 2025-12-26 18:59:45.4896 AlertProcessor ProcessorAlertData: Stopped 2025-12-26 19:04:39.8355 AlertProcessor ProcessorAlertData: started 2025-12-26 19:04:45.4136 AlertProcessor ProcessorAlertData: Stopped 2025-12-26 19:09:39.3064 DFramework.Database.Query /* Time Taken: 528*/ [dbo].GenerateSystemAlerts 2025-12-26 19:09:39.8376 AlertProcessor ProcessorAlertData: started 2025-12-26 19:09:45.4627 AlertProcessor ProcessorAlertData: Stopped 2025-12-26 19:09:54.1971 DFramework.Scheduler.TaskBase /* Time Taken: 15640.7405*/ Opportunity Out Of Stock By Outlet 2025-12-26 19:14:39.8554 AlertProcessor ProcessorAlertData: started 2025-12-26 19:14:45.4023 AlertProcessor ProcessorAlertData: Stopped 2025-12-26 19:19:39.8732 AlertProcessor ProcessorAlertData: started 2025-12-26 19:19:45.3576 AlertProcessor ProcessorAlertData: Stopped 2025-12-26 19:24:39.4068 DFramework.Database.Query /* Time Taken: 597*/ [dbo].GenerateSystemAlerts 2025-12-26 19:24:39.8912 AlertProcessor ProcessorAlertData: started 2025-12-26 19:24:45.7819 AlertProcessor ProcessorAlertData: Stopped 2025-12-26 19:24:54.2508 DFramework.Scheduler.TaskBase /* Time Taken: 15672.1189*/ Opportunity Out Of Stock By Outlet 2025-12-26 19:29:39.9106 AlertProcessor ProcessorAlertData: started 2025-12-26 19:29:45.4575 AlertProcessor ProcessorAlertData: Stopped 2025-12-26 19:34:39.4444 MoveToReorder Running task for ClientId : 286 and ClientName = India Office QA and Slot: 12/27/2025 9:00:00 AM And LastExecutedOn: 12/27/2025 8:04:39 AM 2025-12-26 19:34:39.6632 MoveToReorder Task executed successfully for ClientId : 286 Client Name:India Office QA, Slot: 12/27/2025 9:00:00 AM But No Order found to suggest 2025-12-26 19:34:39.9288 AlertProcessor ProcessorAlertData: started 2025-12-26 19:34:43.1007 DFramework.Database.Query /* Time Taken: 509*/ DECLARE @TableName AnsiString(8000) SET @TableName = 'AssetStockProductWiseConsolidate' DECLARE @CurrentRecordId Int32 SET @CurrentRecordId = '3675192' dbo.GetValidDeviceForAlertProcessData 2025-12-26 19:34:45.6789 AlertProcessor ProcessorAlertData: Stopped 2025-12-26 19:39:39.3530 DFramework.Database.Query /* Time Taken: 525*/ [dbo].GenerateSystemAlerts 2025-12-26 19:39:39.9467 AlertProcessor ProcessorAlertData: started 2025-12-26 19:39:45.4624 AlertProcessor ProcessorAlertData: Stopped 2025-12-26 19:39:54.1968 DFramework.Scheduler.TaskBase /* Time Taken: 15593.8652*/ Opportunity Out Of Stock By Outlet 2025-12-26 19:44:39.9634 AlertProcessor ProcessorAlertData: started 2025-12-26 19:44:45.6197 AlertProcessor ProcessorAlertData: Stopped 2025-12-26 19:49:39.9806 AlertProcessor ProcessorAlertData: started 2025-12-26 19:49:45.6681 AlertProcessor ProcessorAlertData: Stopped 2025-12-26 19:54:39.4826 DFramework.Database.Query /* Time Taken: 634*/ [dbo].GenerateSystemAlerts 2025-12-26 19:54:39.9982 AlertProcessor ProcessorAlertData: started 2025-12-26 19:54:45.6389 AlertProcessor ProcessorAlertData: Stopped 2025-12-26 19:54:54.3889 DFramework.Scheduler.TaskBase /* Time Taken: 15781.3569*/ Opportunity Out Of Stock By Outlet 2025-12-26 19:59:40.0160 AlertProcessor ProcessorAlertData: started 2025-12-26 19:59:45.6566 AlertProcessor ProcessorAlertData: Stopped 2025-12-26 20:04:40.0338 AlertProcessor ProcessorAlertData: started 2025-12-26 20:04:45.5651 AlertProcessor ProcessorAlertData: Stopped 2025-12-26 20:09:39.3797 DFramework.Database.Query /* Time Taken: 518*/ [dbo].GenerateSystemAlerts 2025-12-26 20:09:40.0516 AlertProcessor ProcessorAlertData: started 2025-12-26 20:09:45.5516 AlertProcessor ProcessorAlertData: Stopped 2025-12-26 20:09:54.2079 DFramework.Scheduler.TaskBase /* Time Taken: 15578.233*/ Opportunity Out Of Stock By Outlet 2025-12-26 20:14:40.0693 AlertProcessor ProcessorAlertData: started 2025-12-26 20:14:45.6006 AlertProcessor ProcessorAlertData: Stopped 2025-12-26 20:19:40.0872 AlertProcessor ProcessorAlertData: started 2025-12-26 20:19:45.6185 AlertProcessor ProcessorAlertData: Stopped 2025-12-26 20:24:39.4331 DFramework.Database.Query /* Time Taken: 574*/ [dbo].GenerateSystemAlerts 2025-12-26 20:24:40.1050 AlertProcessor ProcessorAlertData: started 2025-12-26 20:24:41.4644 DFramework.Database.Query /* Time Taken: 546*/ DECLARE @TableName AnsiString(8000) SET @TableName = 'MissingShelf' DECLARE @CurrentRecordId Int32 SET @CurrentRecordId = '3675192' dbo.GetValidDeviceForAlertProcessData 2025-12-26 20:24:45.9800 AlertProcessor ProcessorAlertData: Stopped 2025-12-26 20:24:54.2614 DFramework.Scheduler.TaskBase /* Time Taken: 15609.4881*/ Opportunity Out Of Stock By Outlet 2025-12-26 20:29:40.1228 AlertProcessor ProcessorAlertData: started 2025-12-26 20:29:45.7479 AlertProcessor ProcessorAlertData: Stopped 2025-12-26 20:34:39.5626 MoveToReorder Running task for ClientId : 286 and ClientName = India Office QA and Slot: 12/27/2025 10:00:00 AM And LastExecutedOn: 12/27/2025 9:04:39 AM 2025-12-26 20:34:39.7813 MoveToReorder Task executed successfully for ClientId : 286 Client Name:India Office QA, Slot: 12/27/2025 10:00:00 AM But No Order found to suggest 2025-12-26 20:34:40.1251 AlertProcessor ProcessorAlertData: started 2025-12-26 20:34:40.6876 DFramework.Database.Query /* Time Taken: 560*/ DECLARE @TableName AnsiString(8000) SET @TableName = 'TagAlert' DECLARE @CurrentRecordId Int32 SET @CurrentRecordId = '0' dbo.GetValidDeviceForAlertProcessData 2025-12-26 20:34:41.7970 DFramework.Database.Query /* Time Taken: 680*/ DECLARE @TableName AnsiString(8000) SET @TableName = 'MissingShelf' DECLARE @CurrentRecordId Int32 SET @CurrentRecordId = '3675192' dbo.GetValidDeviceForAlertProcessData 2025-12-26 20:34:42.4845 DFramework.Database.Query /* Time Taken: 616*/ DECLARE @TableName AnsiString(8000) SET @TableName = 'AdditionalShelf' DECLARE @CurrentRecordId Int32 SET @CurrentRecordId = '3675192' dbo.GetValidDeviceForAlertProcessData 2025-12-26 20:34:44.9689 DFramework.Database.Query /* Time Taken: 868*/ DECLARE @TableName AnsiString(8000) SET @TableName = 'AssetStockProductWiseConsolidate' DECLARE @CurrentRecordId Int32 SET @CurrentRecordId = '3675192' dbo.GetValidDeviceForAlertProcessData 2025-12-26 20:34:45.8127 DFramework.Database.Query /* Time Taken: 4754*/ DECLARE @AlertTypeIds AnsiString(8000) SET @AlertTypeIds = '42,31,44,18,58,52,64,61,46,73,59,65,69,72,60,74,68,39,51,56,32,55,38,63,77,76' DECLARE @ClientIds AnsiString(8000) SET @ClientIds = '213,286,395,360,1494,70,291,452,335' 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-26 20:34:48.0471 AlertProcessor ProcessorAlertData: Stopped 2025-12-26 20:34:50.8752 DFramework.Database.Query /* Time Taken: 4554*/ 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 = '1494,286,395,430,471,349,414,360,213,70,296,301,303,305,328,335,295,320,336,338,134,188,227,207,224,291,306,308,325,342,337,385,421,469,1480,1496,114,180,183,299,300,314,316,331,332,333,415,451,229,124,222,289,322,1476,1481,221,355,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-26 20:34:51.5939 DFramework.Scheduler.TaskBase /* Time Taken: 11062.5856*/ Alert Summary Mail 2025-12-26 20:39:39.4555 DFramework.Database.Query /* Time Taken: 568*/ [dbo].GenerateSystemAlerts 2025-12-26 20:39:40.1274 AlertProcessor ProcessorAlertData: started 2025-12-26 20:39:45.7368 AlertProcessor ProcessorAlertData: Stopped 2025-12-26 20:39:54.2993 DFramework.Scheduler.TaskBase /* Time Taken: 15625.1155*/ Opportunity Out Of Stock By Outlet 2025-12-26 20:44:40.1452 AlertProcessor ProcessorAlertData: started 2025-12-26 20:44:43.3796 DFramework.Database.Query /* Time Taken: 579*/ DECLARE @TableName AnsiString(8000) SET @TableName = 'AssetStockProductWiseConsolidate' DECLARE @CurrentRecordId Int32 SET @CurrentRecordId = '3675192' dbo.GetValidDeviceForAlertProcessData 2025-12-26 20:44:45.9577 AlertProcessor ProcessorAlertData: Stopped 2025-12-26 20:49:40.1630 AlertProcessor ProcessorAlertData: started 2025-12-26 20:49:45.6318 AlertProcessor ProcessorAlertData: Stopped 2025-12-26 20:54:39.4624 DFramework.Database.Query /* Time Taken: 555*/ [dbo].GenerateSystemAlerts 2025-12-26 20:54:40.1811 AlertProcessor ProcessorAlertData: started 2025-12-26 20:54:45.8218 AlertProcessor ProcessorAlertData: Stopped 2025-12-26 20:54:54.3219 DFramework.Scheduler.TaskBase /* Time Taken: 15640.7466*/ Opportunity Out Of Stock By Outlet 2025-12-26 20:59:40.1834 AlertProcessor ProcessorAlertData: started 2025-12-26 20:59:44.4490 AlertProcessor Replace Tags updated for the Image Id: 3675158 2025-12-26 20:59:44.6990 DFramework.Database.NullableDataReader Data reader open for 324 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-26 20:59:44.7615 DFramework.Database.NullableDataReader Data reader open for 407 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-26 20:59:45.9803 DFramework.Database.NullableDataReader Data reader open for 213 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-26 20:59:46.0272 DFramework.Database.NullableDataReader Data reader open for 295 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-26 20:59:47.2772 AlertProcessor ProcessorAlertData: Stopped 2025-12-26 21:04:40.2012 AlertProcessor ProcessorAlertData: started 2025-12-26 21:04:46.1075 AlertProcessor ProcessorAlertData: Stopped 2025-12-26 21:09:39.4848 DFramework.Database.Query /* Time Taken: 548*/ [dbo].GenerateSystemAlerts 2025-12-26 21:09:40.2192 AlertProcessor ProcessorAlertData: started 2025-12-26 21:09:40.7974 DFramework.Database.Query /* Time Taken: 577*/ DECLARE @TableName AnsiString(8000) SET @TableName = 'TagAlert' DECLARE @CurrentRecordId Int32 SET @CurrentRecordId = '0' dbo.GetValidDeviceForAlertProcessData 2025-12-26 21:09:46.5787 AlertProcessor ProcessorAlertData: Stopped 2025-12-26 21:09:54.3443 DFramework.Scheduler.TaskBase /* Time Taken: 15656.375*/ Opportunity Out Of Stock By Outlet 2025-12-26 21:14:40.2372 AlertProcessor ProcessorAlertData: started 2025-12-26 21:14:41.6434 DFramework.Database.Query /* Time Taken: 564*/ DECLARE @TableName AnsiString(8000) SET @TableName = 'MissingShelf' DECLARE @CurrentRecordId Int32 SET @CurrentRecordId = '3675192' dbo.GetValidDeviceForAlertProcessData 2025-12-26 21:14:44.5028 AlertProcessor Replace Tags updated for the Image Id: 3675157 2025-12-26 21:14:44.6434 DFramework.Database.NullableDataReader Data reader open for 228 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-26 21:14:45.8935 DFramework.Database.NullableDataReader Data reader open for 275 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-26 21:14:46.3935 DFramework.Database.Query /* Time Taken: 506*/ DECLARE @TableName AnsiString(8000) SET @TableName = 'LowInventoryConsolidate' DECLARE @CurrentRecordId Int32 SET @CurrentRecordId = '3675192' dbo.GetValidDeviceForAlertProcessData 2025-12-26 21:14:47.4091 AlertProcessor ProcessorAlertData: Stopped 2025-12-26 21:19:40.2394 AlertProcessor ProcessorAlertData: started 2025-12-26 21:19:42.1612 DFramework.Database.Query /* Time Taken: 551*/ DECLARE @TableName AnsiString(8000) SET @TableName = 'AdditionalShelf' DECLARE @CurrentRecordId Int32 SET @CurrentRecordId = '3675192' dbo.GetValidDeviceForAlertProcessData 2025-12-26 21:19:44.5988 AlertProcessor Replace Tags updated for the Image Id: 3675145 2025-12-26 21:19:44.7550 DFramework.Database.NullableDataReader Data reader open for 228 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-26 21:19:45.9738 DFramework.Database.NullableDataReader Data reader open for 278 at System.Environment.GetStackTrace(Exception e, Boolean needFileInfo) at System.Environment.get_StackTrace() at DFramework.Database.NullableDataReader.Dispose(Boolean disposing) in D:\Spraxa\Framework\DFramework\Database\NullableDataReader.cs:line 33 at DFramework.Database.NullableDataReader.Dispose() in D:\Spraxa\Framework\DFramework\Database\NullableDataReader.cs:line 44 at CoolR.Tasks.ProcessAlertData.Execute() in D:\Spraxa\CoolR-Group\portal\CoolR.Tasks\ProcessAlertData.cs:line 47 at DFramework.Scheduler.TaskBase.Run() in D:\Spraxa\Framework\DFramework.Scheduler\TaskBase.cs:line 176 at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx) at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx) at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state) at System.Threading.ThreadHelper.ThreadStart() 2025-12-26 21:19:47.3175 DFramework.Database.Query /* Time Taken: 503*/ DECLARE @TableName AnsiString(8000) SET @TableName = 'ProductStockLevel' DECLARE @CurrentRecordId Int32 SET @CurrentRecordId = '3675192' dbo.GetValidDeviceForAlertProcessData 2025-12-26 21:19:47.4738 AlertProcessor ProcessorAlertData: Stopped 2025-12-26 21:24:39.5853 DFramework.Database.Query /* Time Taken: 636*/ [dbo].GenerateSystemAlerts 2025-12-26 21:24:40.2572 AlertProcessor ProcessorAlertData: started 2025-12-26 21:24:41.6165 DFramework.Database.NullableDataReader Data reader open for 222 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-26 21:24:42.2415 DFramework.Database.NullableDataReader Data reader open for 220 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-26 21:24:46.4135 AlertProcessor ProcessorAlertData: Stopped 2025-12-26 21:24:54.4135 DFramework.Scheduler.TaskBase /* Time Taken: 15718.866*/ Opportunity Out Of Stock By Outlet 2025-12-26 21:29:40.2750 AlertProcessor ProcessorAlertData: started 2025-12-26 21:29:43.4469 DFramework.Database.Query /* Time Taken: 502*/ DECLARE @TableName AnsiString(8000) SET @TableName = 'AssetStockProductWiseConsolidate' DECLARE @CurrentRecordId Int32 SET @CurrentRecordId = '3675192' dbo.GetValidDeviceForAlertProcessData 2025-12-26 21:29:46.0875 AlertProcessor ProcessorAlertData: Stopped 2025-12-26 21:34:39.6678 MoveToReorder Running task for ClientId : 286 and ClientName = India Office QA and Slot: 12/27/2025 11:00:00 AM And LastExecutedOn: 12/27/2025 10:04:39 AM 2025-12-26 21:34:40.2928 AlertProcessor ProcessorAlertData: started 2025-12-26 21:34:43.9178 DFramework.Database.Query /* Time Taken: 707*/ DECLARE @TableName AnsiString(8000) SET @TableName = 'AssetStockProductWiseConsolidate' DECLARE @CurrentRecordId Int32 SET @CurrentRecordId = '3675192' dbo.GetValidDeviceForAlertProcessData 2025-12-26 21:34:44.6834 AlertProcessor Replace Tags updated for the Image Id: 3675156 2025-12-26 21:34:44.8397 DFramework.Database.NullableDataReader Data reader open for 236 at System.Environment.GetStackTrace(Exception e, Boolean needFileInfo) at System.Environment.get_StackTrace() at DFramework.Database.NullableDataReader.Dispose(Boolean disposing) in D:\Spraxa\Framework\DFramework\Database\NullableDataReader.cs:line 33 at DFramework.Database.NullableDataReader.Dispose() in D:\Spraxa\Framework\DFramework\Database\NullableDataReader.cs:line 44 at CoolR.Tasks.ProcessAlertData.Execute() in D:\Spraxa\CoolR-Group\portal\CoolR.Tasks\ProcessAlertData.cs:line 47 at DFramework.Scheduler.TaskBase.Run() in D:\Spraxa\Framework\DFramework.Scheduler\TaskBase.cs:line 176 at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx) at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx) at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state) at System.Threading.ThreadHelper.ThreadStart() 2025-12-26 21:34:44.8866 DFramework.Database.NullableDataReader Data reader open for 318 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-26 21:34:46.1210 DFramework.Database.NullableDataReader Data reader open for 277 at System.Environment.GetStackTrace(Exception e, Boolean needFileInfo) at System.Environment.get_StackTrace() at DFramework.Database.NullableDataReader.Dispose(Boolean disposing) in D:\Spraxa\Framework\DFramework\Database\NullableDataReader.cs:line 33 at DFramework.Database.NullableDataReader.Dispose() in D:\Spraxa\Framework\DFramework\Database\NullableDataReader.cs:line 44 at CoolR.Tasks.ProcessAlertData.Execute() in D:\Spraxa\CoolR-Group\portal\CoolR.Tasks\ProcessAlertData.cs:line 47 at DFramework.Scheduler.TaskBase.Run() in D:\Spraxa\Framework\DFramework.Scheduler\TaskBase.cs:line 176 at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx) at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx) at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state) at System.Threading.ThreadHelper.ThreadStart() 2025-12-26 21:34:47.3866 AlertProcessor ProcessorAlertData: Stopped 2025-12-26 21:35:19.4806 DFramework.Database.NullableDataReader Data reader open for 39529 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-26 21:35:19.5274 MoveToReorder Task executed successfully for ClientId : 286 Client Name:India Office QA, Slot: 12/27/2025 11:00:00 AM and Total Order Suggested: 127 Out Of: 127 2025-12-26 21:35:20.2774 DFramework.Database.Query /* Time Taken: 742*/ DECLARE @ClientId Int32 SET @ClientId = '286' dbo.GetMoveToReOrderList 2025-12-26 21:35:21.2150 DFramework.Database.Query /* Time Taken: 582*/ 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-26 21:35:21.4493 DFramework.Scheduler.TaskBase /* Time Taken: 42109.674*/ Move To Re-Order 2025-12-26 21:39:39.5137 DFramework.Database.Query /* Time Taken: 538*/ [dbo].GenerateSystemAlerts 2025-12-26 21:39:40.2950 AlertProcessor ProcessorAlertData: started 2025-12-26 21:39:45.9981 AlertProcessor ProcessorAlertData: Stopped 2025-12-26 21:39:54.4357 DFramework.Scheduler.TaskBase /* Time Taken: 15718.8551*/ Opportunity Out Of Stock By Outlet 2025-12-26 21:44:40.2974 AlertProcessor ProcessorAlertData: started 2025-12-26 21:44:45.8130 AlertProcessor ProcessorAlertData: Stopped 2025-12-26 21:49:40.3152 AlertProcessor ProcessorAlertData: started 2025-12-26 21:49:45.8621 AlertProcessor ProcessorAlertData: Stopped 2025-12-26 21:54:39.5830 DFramework.Database.Query /* Time Taken: 590*/ [dbo].GenerateSystemAlerts 2025-12-26 21:54:40.3330 AlertProcessor ProcessorAlertData: started 2025-12-26 21:54:45.8956 AlertProcessor ProcessorAlertData: Stopped 2025-12-26 21:54:54.4425 DFramework.Scheduler.TaskBase /* Time Taken: 15703.2366*/ Opportunity Out Of Stock By Outlet 2025-12-26 21:59:40.3353 AlertProcessor ProcessorAlertData: started 2025-12-26 21:59:45.9447 AlertProcessor ProcessorAlertData: Stopped 2025-12-26 22:04:40.3532 AlertProcessor ProcessorAlertData: started 2025-12-26 22:04:45.9782 AlertProcessor ProcessorAlertData: Stopped 2025-12-26 22:09:39.5585 DFramework.Database.Query /* Time Taken: 540*/ [dbo].GenerateSystemAlerts 2025-12-26 22:09:40.3710 AlertProcessor ProcessorAlertData: started 2025-12-26 22:09:46.0273 AlertProcessor ProcessorAlertData: Stopped 2025-12-26 22:09:54.5430 DFramework.Scheduler.TaskBase /* Time Taken: 15781.3663*/ Opportunity Out Of Stock By Outlet 2025-12-26 22:14:40.3888 AlertProcessor ProcessorAlertData: started 2025-12-26 22:14:41.6231 DFramework.Database.Query /* Time Taken: 520*/ DECLARE @TableName AnsiString(8000) SET @TableName = 'MissingShelf' DECLARE @CurrentRecordId Int32 SET @CurrentRecordId = '3675192' dbo.GetValidDeviceForAlertProcessData 2025-12-26 22:14:46.0294 AlertProcessor ProcessorAlertData: Stopped 2025-12-26 22:19:40.3911 AlertProcessor ProcessorAlertData: started 2025-12-26 22:19:45.9380 AlertProcessor ProcessorAlertData: Stopped 2025-12-26 22:24:39.5964 DFramework.Database.Query /* Time Taken: 557*/ [dbo].GenerateSystemAlerts 2025-12-26 22:24:40.4089 AlertProcessor ProcessorAlertData: started 2025-12-26 22:24:43.6746 DFramework.Database.Query /* Time Taken: 659*/ DECLARE @TableName AnsiString(8000) SET @TableName = 'AssetStockProductWiseConsolidate' DECLARE @CurrentRecordId Int32 SET @CurrentRecordId = '3675192' dbo.GetValidDeviceForAlertProcessData 2025-12-26 22:24:46.2996 AlertProcessor ProcessorAlertData: Stopped 2025-12-26 22:24:54.5496 DFramework.Scheduler.TaskBase /* Time Taken: 15765.7413*/ Opportunity Out Of Stock By Outlet 2025-12-26 22:29:40.4267 AlertProcessor ProcessorAlertData: started 2025-12-26 22:29:46.0049 AlertProcessor ProcessorAlertData: Stopped 2025-12-26 22:34:39.7729 MoveToReorder Running task for ClientId : 286 and ClientName = India Office QA and Slot: 12/27/2025 12:00:00 PM And LastExecutedOn: 12/27/2025 11:04:39 AM 2025-12-26 22:34:39.9916 MoveToReorder Task executed successfully for ClientId : 286 Client Name:India Office QA, Slot: 12/27/2025 12:00:00 PM But No Order found to suggest 2025-12-26 22:34:40.4291 AlertProcessor ProcessorAlertData: started 2025-12-26 22:34:46.1323 AlertProcessor ProcessorAlertData: Stopped 2025-12-26 22:39:39.6502 DFramework.Database.Query /* Time Taken: 585*/ [dbo].GenerateSystemAlerts 2025-12-26 22:39:40.4471 AlertProcessor ProcessorAlertData: started 2025-12-26 22:39:46.1190 AlertProcessor ProcessorAlertData: Stopped 2025-12-26 22:39:54.5722 DFramework.Scheduler.TaskBase /* Time Taken: 15765.7453*/ Opportunity Out Of Stock By Outlet 2025-12-26 22:44:40.4649 AlertProcessor ProcessorAlertData: started 2025-12-26 22:44:46.0275 AlertProcessor ProcessorAlertData: Stopped 2025-12-26 22:49:40.4828 AlertProcessor ProcessorAlertData: started 2025-12-26 22:49:45.9829 AlertProcessor ProcessorAlertData: Stopped 2025-12-26 22:54:39.7821 DFramework.Database.Query /* Time Taken: 696*/ [dbo].GenerateSystemAlerts 2025-12-26 22:54:40.5008 AlertProcessor ProcessorAlertData: started 2025-12-26 22:54:46.0321 AlertProcessor ProcessorAlertData: Stopped 2025-12-26 22:54:54.5321 DFramework.Scheduler.TaskBase /* Time Taken: 15718.8686*/ Opportunity Out Of Stock By Outlet 2025-12-26 22:59:40.5186 AlertProcessor ProcessorAlertData: started 2025-12-26 22:59:46.0186 AlertProcessor ProcessorAlertData: Stopped 2025-12-26 23:04:40.5364 AlertProcessor ProcessorAlertData: started 2025-12-26 23:04:46.1459 AlertProcessor ProcessorAlertData: Stopped 2025-12-26 23:09:39.6324 DFramework.Database.Query /* Time Taken: 530*/ [dbo].GenerateSystemAlerts 2025-12-26 23:09:40.5543 AlertProcessor ProcessorAlertData: started 2025-12-26 23:09:42.2731 DFramework.Database.Query /* Time Taken: 552*/ DECLARE @TableName AnsiString(8000) SET @TableName = 'AdditionalShelf' DECLARE @CurrentRecordId Int32 SET @CurrentRecordId = '3675192' dbo.GetValidDeviceForAlertProcessData 2025-12-26 23:09:46.2575 AlertProcessor ProcessorAlertData: Stopped 2025-12-26 23:09:54.5232 DFramework.Scheduler.TaskBase /* Time Taken: 15703.2431*/ Opportunity Out Of Stock By Outlet 2025-12-26 23:14:40.5721 AlertProcessor ProcessorAlertData: started 2025-12-26 23:14:46.2441 AlertProcessor ProcessorAlertData: Stopped 2025-12-26 23:19:40.5900 AlertProcessor ProcessorAlertData: started 2025-12-26 23:19:46.1994 AlertProcessor ProcessorAlertData: Stopped 2025-12-26 23:24:39.7017 DFramework.Database.Query /* Time Taken: 564*/ [dbo].GenerateSystemAlerts 2025-12-26 23:24:40.6079 AlertProcessor ProcessorAlertData: started 2025-12-26 23:24:42.4673 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-26 23:24:46.6861 AlertProcessor ProcessorAlertData: Stopped 2025-12-26 23:24:54.6549 DFramework.Scheduler.TaskBase /* Time Taken: 15812.6212*/ Opportunity Out Of Stock By Outlet 2025-12-26 23:29:40.6259 AlertProcessor ProcessorAlertData: started 2025-12-26 23:29:46.2197 AlertProcessor ProcessorAlertData: Stopped 2025-12-26 23:34:39.8781 MoveToReorder Running task for ClientId : 286 and ClientName = India Office QA and Slot: 12/27/2025 1:00:00 PM And LastExecutedOn: 12/27/2025 12:04:39 PM 2025-12-26 23:34:40.3938 DFramework.Database.NullableDataReader Data reader open for 299 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-26 23:34:40.4250 MoveToReorder Task executed successfully for ClientId : 286 Client Name:India Office QA, Slot: 12/27/2025 1:00:00 PM and Total Order Suggested: 1 Out Of: 1 2025-12-26 23:34:40.6281 AlertProcessor ProcessorAlertData: started 2025-12-26 23:34:43.9094 DFramework.Database.Query /* Time Taken: 728*/ DECLARE @TableName AnsiString(8000) SET @TableName = 'AssetStockProductWiseConsolidate' DECLARE @CurrentRecordId Int32 SET @CurrentRecordId = '3675192' dbo.GetValidDeviceForAlertProcessData 2025-12-26 23:34:46.5501 AlertProcessor ProcessorAlertData: Stopped 2025-12-26 23:39:39.6616 DFramework.Database.Query /* Time Taken: 522*/ [dbo].GenerateSystemAlerts 2025-12-26 23:39:40.6460 AlertProcessor ProcessorAlertData: started 2025-12-26 23:39:46.1304 AlertProcessor ProcessorAlertData: Stopped 2025-12-26 23:39:54.5523 DFramework.Scheduler.TaskBase /* Time Taken: 15703.2511*/ Opportunity Out Of Stock By Outlet 2025-12-26 23:44:40.6640 AlertProcessor ProcessorAlertData: started 2025-12-26 23:44:46.4765 AlertProcessor ProcessorAlertData: Stopped 2025-12-26 23:49:40.6819 AlertProcessor ProcessorAlertData: started 2025-12-26 23:49:46.3069 AlertProcessor ProcessorAlertData: Stopped 2025-12-26 23:54:39.7466 DFramework.Database.Query /* Time Taken: 578*/ [dbo].GenerateSystemAlerts 2025-12-26 23:54:40.6997 AlertProcessor ProcessorAlertData: started 2025-12-26 23:54:41.9966 DFramework.Database.Query /* Time Taken: 582*/ DECLARE @TableName AnsiString(8000) SET @TableName = 'MissingShelf' DECLARE @CurrentRecordId Int32 SET @CurrentRecordId = '3675192' dbo.GetValidDeviceForAlertProcessData 2025-12-26 23:54:46.5122 AlertProcessor ProcessorAlertData: Stopped 2025-12-26 23:54:54.5904 DFramework.Scheduler.TaskBase /* Time Taken: 15718.8756*/ Opportunity Out Of Stock By Outlet 2025-12-26 23:59:40.7176 AlertProcessor ProcessorAlertData: started 2025-12-26 23:59:46.2957 AlertProcessor ProcessorAlertData: Stopped