2025-12-29 00:04:49.0647 AlertProcessor ProcessorAlertData: started 2025-12-29 00:04:54.6741 AlertProcessor ProcessorAlertData: Stopped 2025-12-29 00:09:49.0825 AlertProcessor ProcessorAlertData: started 2025-12-29 00:09:54.6138 AlertProcessor ProcessorAlertData: Stopped 2025-12-29 00:09:58.4107 DFramework.Scheduler.TaskBase /* Time Taken: 15718.8632*/ Opportunity Out Of Stock By Outlet 2025-12-29 00:14:49.0848 AlertProcessor ProcessorAlertData: started 2025-12-29 00:14:54.8504 AlertProcessor ProcessorAlertData: Stopped 2025-12-29 00:19:49.1025 AlertProcessor ProcessorAlertData: started 2025-12-29 00:19:51.7744 DFramework.Database.NullableDataReader Data reader open for 283 at System.Environment.GetStackTrace(Exception e, Boolean needFileInfo) at System.Environment.get_StackTrace() at DFramework.Database.NullableDataReader.Dispose(Boolean disposing) in D:\Spraxa\Framework\DFramework\Database\NullableDataReader.cs:line 33 at DFramework.Database.NullableDataReader.Dispose() in D:\Spraxa\Framework\DFramework\Database\NullableDataReader.cs:line 44 at CoolR.Tasks.ProcessAlertData.Execute() in D:\Spraxa\CoolR-Group\portal\CoolR.Tasks\ProcessAlertData.cs:line 47 at DFramework.Scheduler.TaskBase.Run() in D:\Spraxa\Framework\DFramework.Scheduler\TaskBase.cs:line 176 at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx) at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx) at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state) at System.Threading.ThreadHelper.ThreadStart() 2025-12-29 00:19:55.3526 AlertProcessor ProcessorAlertData: Stopped 2025-12-29 00:24:49.1203 AlertProcessor ProcessorAlertData: started 2025-12-29 00:24:54.8391 AlertProcessor ProcessorAlertData: Stopped 2025-12-29 00:24:58.5110 DFramework.Scheduler.TaskBase /* Time Taken: 15796.9885*/ Opportunity Out Of Stock By Outlet 2025-12-29 00:29:49.1382 AlertProcessor ProcessorAlertData: started 2025-12-29 00:29:54.9663 AlertProcessor ProcessorAlertData: Stopped 2025-12-29 00:34:44.7810 MoveToReorder Running task for ClientId : 286 and ClientName = India Office QA and Slot: 12/29/2025 2:00:00 PM And LastExecutedOn: 12/29/2025 1:04:44 PM 2025-12-29 00:34:49.1560 AlertProcessor ProcessorAlertData: started 2025-12-29 00:34:53.8748 DFramework.Database.Query /* Time Taken: 1980*/ DECLARE @TableName AnsiString(8000) SET @TableName = 'AssetStockProductWiseConsolidate' DECLARE @CurrentRecordId Int32 SET @CurrentRecordId = '3675242' dbo.GetValidDeviceForAlertProcessData 2025-12-29 00:34:56.4842 AlertProcessor ProcessorAlertData: Stopped 2025-12-29 00:35:27.5625 DFramework.Database.NullableDataReader Data reader open for 42498 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-29 00:35:27.5938 MoveToReorder Task executed successfully for ClientId : 286 Client Name:India Office QA, Slot: 12/29/2025 2:00:00 PM and Total Order Suggested: 127 Out Of: 127 2025-12-29 00:35:28.7813 DFramework.Scheduler.TaskBase /* Time Taken: 44312.8343*/ Move To Re-Order 2025-12-29 00:39:49.1739 AlertProcessor ProcessorAlertData: started 2025-12-29 00:39:54.8145 AlertProcessor ProcessorAlertData: Stopped 2025-12-29 00:39:58.5645 DFramework.Scheduler.TaskBase /* Time Taken: 15843.8652*/ Opportunity Out Of Stock By Outlet 2025-12-29 00:44:49.1917 AlertProcessor ProcessorAlertData: started 2025-12-29 00:44:54.7074 AlertProcessor ProcessorAlertData: Stopped 2025-12-29 00:49:49.2095 AlertProcessor ProcessorAlertData: started 2025-12-29 00:49:54.8190 AlertProcessor ProcessorAlertData: Stopped 2025-12-29 00:54:43.6648 DFramework.Database.Query /* Time Taken: 623*/ [dbo].GenerateSystemAlerts 2025-12-29 00:54:49.2274 AlertProcessor ProcessorAlertData: started 2025-12-29 00:54:54.7743 AlertProcessor ProcessorAlertData: Stopped 2025-12-29 00:54:58.6962 DFramework.Scheduler.TaskBase /* Time Taken: 15953.2406*/ Opportunity Out Of Stock By Outlet 2025-12-29 00:59:49.2452 AlertProcessor ProcessorAlertData: started 2025-12-29 00:59:54.7453 AlertProcessor ProcessorAlertData: Stopped 2025-12-29 01:06:39.8413 AlertProcessor ProcessorAlertData: started 2025-12-29 01:06:40.6225 DFramework.Database.Query /* Time Taken: 748*/ DECLARE @TableName AnsiString(8000) SET @TableName = 'TagAlert' DECLARE @CurrentRecordId Int32 SET @CurrentRecordId = '0' dbo.GetValidDeviceForAlertProcessData 2025-12-29 01:06:40.6381 DFramework.Database.Query /* Time Taken: 687*/ 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-29 01:06:40.6694 DFramework.Database.Query /* Time Taken: 718*/ 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-29 01:06:40.7163 DFramework.Database.Query /* Time Taken: 764*/ 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-29 01:06:40.7475 DFramework.Database.Query /* Time Taken: 791*/ 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-29 01:06:40.8882 DFramework.Database.Query /* Time Taken: 935*/ 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-29 01:06:40.9038 DFramework.Database.Query /* Time Taken: 929*/ 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-29 01:06:40.9194 DFramework.Database.Query /* Time Taken: 940*/ 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-29 01:06:40.9194 DFramework.Database.Query /* Time Taken: 946*/ 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-29 01:06:40.9663 DFramework.Database.Query /* Time Taken: 984*/ 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/29/2025 9:06: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-29 01:06:40.9975 DFramework.Database.Query /* Time Taken: 1013*/ DECLARE @CreatedOn DateTime2 SET @CreatedOn = '12/29/2025 12:00:00 AM' DECLARE @EventId Int32 SET @EventId = '-12' SELECT COUNT(1) FROM EmailQueue WHERE [CreatedOn] >= @CreatedOn AND [EventId] = @EventId 2025-12-29 01:06:41.0288 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-29 01:06:41.2163 DFramework.Database.NullableDataReader Data reader open for 576 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-29 01:06:41.2475 DFramework.Database.Query /* Time Taken: 1267*/ 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-29 01:06:41.4194 DFramework.Database.NullableDataReader Data reader open for 1333 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-29 01:06:41.7788 DFramework.Database.Query /* Time Taken: 560*/ DECLARE @TableName AnsiString(8000) SET @TableName = 'VoidAlert' DECLARE @CurrentRecordId Int32 SET @CurrentRecordId = '3675242' dbo.GetValidDeviceForAlertProcessData 2025-12-29 01:06:41.9507 DFramework.Database.Query /* Time Taken: 1964*/ [dbo].GenerateSystemAlerts 2025-12-29 01:06:41.9507 DFramework.Database.Query /* Time Taken: 520*/ 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-29 01:06:46.7632 AlertProcessor ProcessorAlertData: Stopped 2025-12-29 01:06:57.4351 DFramework.Scheduler.TaskBase /* Time Taken: 17672.0089*/ Opportunity Out Of Stock By Outlet 2025-12-29 01:11:39.7809 AlertProcessor ProcessorAlertData: started 2025-12-29 01:11:45.3435 AlertProcessor ProcessorAlertData: Stopped 2025-12-29 01:16:39.7830 AlertProcessor ProcessorAlertData: started 2025-12-29 01:16:45.4393 AlertProcessor ProcessorAlertData: Stopped 2025-12-29 01:21:39.7852 AlertProcessor ProcessorAlertData: started 2025-12-29 01:21:41.2228 DFramework.Database.Query /* Time Taken: 1247*/ [dbo].GenerateSystemAlerts 2025-12-29 01:21:41.2384 DFramework.Database.Query /* Time Taken: 653*/ DECLARE @TableName AnsiString(8000) SET @TableName = 'MissingShelf' DECLARE @CurrentRecordId Int32 SET @CurrentRecordId = '3675242' dbo.GetValidDeviceForAlertProcessData 2025-12-29 01:21:45.7853 AlertProcessor ProcessorAlertData: Stopped 2025-12-29 01:21:55.7854 DFramework.Scheduler.TaskBase /* Time Taken: 16000.1197*/ Opportunity Out Of Stock By Outlet 2025-12-29 01:26:39.8031 AlertProcessor ProcessorAlertData: started 2025-12-29 01:26:40.5531 DFramework.Database.Query /* Time Taken: 572*/ 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-29 01:26:45.5219 AlertProcessor ProcessorAlertData: Stopped 2025-12-29 01:31:39.8208 AlertProcessor ProcessorAlertData: started 2025-12-29 01:31:44.4459 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-29 01:31:45.8209 AlertProcessor ProcessorAlertData: Stopped 2025-12-29 01:36:39.8230 AlertProcessor ProcessorAlertData: started 2025-12-29 01:36:40.5730 DFramework.Database.NullableDataReader Data reader open for 431 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-29 01:36:40.6199 MoveToReorder Running task for ClientId : 286 and ClientName = India Office QA and Slot: 12/29/2025 3:00:00 PM And LastExecutedOn: 12/29/2025 2:04:44 PM 2025-12-29 01:36:41.1824 DFramework.Database.Query /* Time Taken: 1200*/ [dbo].GenerateSystemAlerts 2025-12-29 01:36:41.2137 DFramework.Database.Query /* Time Taken: 526*/ DECLARE @OrderStatusId Int32 SET @OrderStatusId = '0' DECLARE @ClientId Int32 SET @ClientId = '286' dbo.GetOrderDetailsByClientId 2025-12-29 01:36:41.2605 MoveToReorder Task executed successfully for ClientId : 286 Client Name:India Office QA, Slot: 12/29/2025 3:00:00 PM But No Order found to suggest 2025-12-29 01:36:46.1356 DFramework.Database.Query /* Time Taken: 537*/ DECLARE @TableName AnsiString(8000) SET @TableName = 'ProductStockLevel' DECLARE @CurrentRecordId Int32 SET @CurrentRecordId = '3675242' dbo.GetValidDeviceForAlertProcessData 2025-12-29 01:36:46.1981 AlertProcessor ProcessorAlertData: Stopped 2025-12-29 01:36:55.9325 DFramework.Scheduler.TaskBase /* Time Taken: 16125.1164*/ Opportunity Out Of Stock By Outlet 2025-12-29 01:41:39.8253 AlertProcessor ProcessorAlertData: started 2025-12-29 01:41:45.4034 AlertProcessor ProcessorAlertData: Stopped 2025-12-29 01:46:39.8274 AlertProcessor ProcessorAlertData: started 2025-12-29 01:46:42.8431 DFramework.Database.Query /* Time Taken: 752*/ DECLARE @TableName AnsiString(8000) SET @TableName = 'PlanogramComplianceConsolidate' DECLARE @CurrentRecordId Int32 SET @CurrentRecordId = '3675242' dbo.GetValidDeviceForAlertProcessData 2025-12-29 01:46:46.4056 AlertProcessor ProcessorAlertData: Stopped 2025-12-29 01:51:39.8296 AlertProcessor ProcessorAlertData: started 2025-12-29 01:51:41.2672 DFramework.Database.Query /* Time Taken: 1257*/ [dbo].GenerateSystemAlerts 2025-12-29 01:51:41.3921 DFramework.Database.Query /* Time Taken: 681*/ DECLARE @TableName AnsiString(8000) SET @TableName = 'MissingShelf' DECLARE @CurrentRecordId Int32 SET @CurrentRecordId = '3675242' dbo.GetValidDeviceForAlertProcessData 2025-12-29 01:51:46.1265 AlertProcessor ProcessorAlertData: Stopped 2025-12-29 01:51:55.7829 DFramework.Scheduler.TaskBase /* Time Taken: 15953.2397*/ Opportunity Out Of Stock By Outlet 2025-12-29 01:56:39.8318 AlertProcessor ProcessorAlertData: started 2025-12-29 01:56:45.6600 AlertProcessor ProcessorAlertData: Stopped 2025-12-29 02:01:39.8496 AlertProcessor ProcessorAlertData: started 2025-12-29 02:01:42.9590 DFramework.Database.Query /* Time Taken: 513*/ DECLARE @TableName AnsiString(8000) SET @TableName = 'AssetStockProductWiseConsolidate' DECLARE @CurrentRecordId Int32 SET @CurrentRecordId = '3675242' dbo.GetValidDeviceForAlertProcessData 2025-12-29 02:01:45.5684 AlertProcessor ProcessorAlertData: Stopped 2025-12-29 02:06:39.8517 AlertProcessor ProcessorAlertData: started 2025-12-29 02:06:41.1486 DFramework.Database.Query /* Time Taken: 1127*/ [dbo].GenerateSystemAlerts 2025-12-29 02:06:41.3361 DFramework.Database.Query /* Time Taken: 505*/ DECLARE @TableName AnsiString(8000) SET @TableName = 'MissingShelf' DECLARE @CurrentRecordId Int32 SET @CurrentRecordId = '3675242' dbo.GetValidDeviceForAlertProcessData 2025-12-29 02:06:45.9142 AlertProcessor ProcessorAlertData: Stopped 2025-12-29 02:06:55.7893 DFramework.Scheduler.TaskBase /* Time Taken: 15937.6103*/ Opportunity Out Of Stock By Outlet 2025-12-29 02:11:39.8695 AlertProcessor ProcessorAlertData: started 2025-12-29 02:11:41.8070 DFramework.Database.Query /* Time Taken: 673*/ DECLARE @TableName AnsiString(8000) SET @TableName = 'AdditionalShelf' DECLARE @CurrentRecordId Int32 SET @CurrentRecordId = '3675242' dbo.GetValidDeviceForAlertProcessData 2025-12-29 02:11:45.8851 AlertProcessor ProcessorAlertData: Stopped 2025-12-29 02:16:39.8873 AlertProcessor ProcessorAlertData: started 2025-12-29 02:16:45.6842 DFramework.Database.Query /* Time Taken: 577*/ DECLARE @TableName AnsiString(8000) SET @TableName = 'ProductStockLevel' DECLARE @CurrentRecordId Int32 SET @CurrentRecordId = '3675242' dbo.GetValidDeviceForAlertProcessData 2025-12-29 02:16:45.7311 AlertProcessor ProcessorAlertData: Stopped 2025-12-29 02:21:39.8893 AlertProcessor ProcessorAlertData: started 2025-12-29 02:21:41.3112 DFramework.Database.Query /* Time Taken: 618*/ DECLARE @TableName AnsiString(8000) SET @TableName = 'MissingShelf' DECLARE @CurrentRecordId Int32 SET @CurrentRecordId = '3675242' dbo.GetValidDeviceForAlertProcessData 2025-12-29 02:21:41.3268 DFramework.Database.Query /* Time Taken: 1288*/ [dbo].GenerateSystemAlerts 2025-12-29 02:21:45.8112 AlertProcessor ProcessorAlertData: Stopped 2025-12-29 02:21:55.8582 DFramework.Scheduler.TaskBase /* Time Taken: 15984.4786*/ Opportunity Out Of Stock By Outlet 2025-12-29 02:26:39.9070 AlertProcessor ProcessorAlertData: started 2025-12-29 02:26:46.1102 AlertProcessor ProcessorAlertData: Stopped 2025-12-29 02:31:39.9249 AlertProcessor ProcessorAlertData: started 2025-12-29 02:31:41.3780 DFramework.Database.Query /* Time Taken: 760*/ DECLARE @TableName AnsiString(8000) SET @TableName = 'MissingShelf' DECLARE @CurrentRecordId Int32 SET @CurrentRecordId = '3675242' dbo.GetValidDeviceForAlertProcessData 2025-12-29 02:31:41.9405 DFramework.Database.Query /* Time Taken: 503*/ DECLARE @TableName AnsiString(8000) SET @TableName = 'AdditionalShelf' DECLARE @CurrentRecordId Int32 SET @CurrentRecordId = '3675242' dbo.GetValidDeviceForAlertProcessData 2025-12-29 02:31:45.9405 AlertProcessor ProcessorAlertData: Stopped 2025-12-29 02:36:39.9427 AlertProcessor ProcessorAlertData: started 2025-12-29 02:36:40.4740 DFramework.Database.Query /* Time Taken: 534*/ DECLARE @TableName AnsiString(8000) SET @TableName = 'TagAlert' DECLARE @CurrentRecordId Int32 SET @CurrentRecordId = '0' dbo.GetValidDeviceForAlertProcessData 2025-12-29 02:36:40.6459 DFramework.Database.Query /* Time Taken: 647*/ 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-29 02:36:40.9584 MoveToReorder Running task for ClientId : 286 and ClientName = India Office QA and Slot: 12/29/2025 4:00:00 PM And LastExecutedOn: 12/29/2025 3:06:40 PM 2025-12-29 02:36:41.4740 DFramework.Database.Query /* Time Taken: 1418*/ [dbo].GenerateSystemAlerts 2025-12-29 02:36:41.5521 DFramework.Database.Query /* Time Taken: 537*/ DECLARE @OrderStatusId Int32 SET @OrderStatusId = '0' DECLARE @ClientId Int32 SET @ClientId = '286' dbo.GetOrderDetailsByClientId 2025-12-29 02:36:41.6302 DFramework.Database.Query /* Time Taken: 640*/ DECLARE @TableName AnsiString(8000) SET @TableName = 'MissingShelf' DECLARE @CurrentRecordId Int32 SET @CurrentRecordId = '3675242' dbo.GetValidDeviceForAlertProcessData 2025-12-29 02:36:43.2865 DFramework.Database.Query /* Time Taken: 1081*/ DECLARE @TableName AnsiString(8000) SET @TableName = 'OpportunityOutOfStock' DECLARE @CurrentRecordId Int32 SET @CurrentRecordId = '3675242' dbo.GetValidDeviceForAlertProcessData 2025-12-29 02:36:44.5521 DFramework.Database.Query /* Time Taken: 503*/ DECLARE @TableName AnsiString(8000) SET @TableName = 'AssetStockProductWiseConsolidate' DECLARE @CurrentRecordId Int32 SET @CurrentRecordId = '3675242' dbo.GetValidDeviceForAlertProcessData 2025-12-29 02:36:47.4272 AlertProcessor ProcessorAlertData: Stopped 2025-12-29 02:36:56.1928 DFramework.Scheduler.TaskBase /* Time Taken: 16296.9961*/ Opportunity Out Of Stock By Outlet 2025-12-29 02:37:22.0680 DFramework.Database.NullableDataReader Data reader open for 40433 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-29 02:37:22.0993 MoveToReorder Task executed successfully for ClientId : 286 Client Name:India Office QA, Slot: 12/29/2025 4:00:00 PM and Total Order Suggested: 126 Out Of: 126 2025-12-29 02:37:23.4743 DFramework.Scheduler.TaskBase /* Time Taken: 43375.3165*/ Move To Re-Order 2025-12-29 02:41:39.9606 AlertProcessor ProcessorAlertData: started 2025-12-29 02:41:41.8043 DFramework.Database.Query /* Time Taken: 621*/ DECLARE @TableName AnsiString(8000) SET @TableName = 'AdditionalShelf' DECLARE @CurrentRecordId Int32 SET @CurrentRecordId = '3675242' dbo.GetValidDeviceForAlertProcessData 2025-12-29 02:41:46.0231 AlertProcessor ProcessorAlertData: Stopped 2025-12-29 02:46:39.9784 AlertProcessor ProcessorAlertData: started 2025-12-29 02:46:45.6191 AlertProcessor ProcessorAlertData: Stopped 2025-12-29 02:51:39.9963 AlertProcessor ProcessorAlertData: started 2025-12-29 02:51:40.5275 DFramework.Database.Query /* Time Taken: 527*/ DECLARE @TableName AnsiString(8000) SET @TableName = 'TagAlert' DECLARE @CurrentRecordId Int32 SET @CurrentRecordId = '0' dbo.GetValidDeviceForAlertProcessData 2025-12-29 02:51:41.4494 DFramework.Database.Query /* Time Taken: 1360*/ [dbo].GenerateSystemAlerts 2025-12-29 02:51:41.6056 DFramework.Database.Query /* Time Taken: 526*/ DECLARE @TableName AnsiString(8000) SET @TableName = 'MissingShelf' DECLARE @CurrentRecordId Int32 SET @CurrentRecordId = '3675242' dbo.GetValidDeviceForAlertProcessData 2025-12-29 02:51:46.2151 AlertProcessor ProcessorAlertData: Stopped 2025-12-29 02:51:55.9183 DFramework.Scheduler.TaskBase /* Time Taken: 16015.744*/ Opportunity Out Of Stock By Outlet 2025-12-29 02:56:40.0139 AlertProcessor ProcessorAlertData: started 2025-12-29 02:56:45.7639 AlertProcessor ProcessorAlertData: Stopped 2025-12-29 03:01:40.0317 AlertProcessor ProcessorAlertData: started 2025-12-29 03:01:45.8130 AlertProcessor ProcessorAlertData: Stopped 2025-12-29 03:06:40.0339 AlertProcessor ProcessorAlertData: started 2025-12-29 03:06:40.5964 DFramework.Database.Query /* Time Taken: 562*/ DECLARE @TableName AnsiString(8000) SET @TableName = 'TagAlert' DECLARE @CurrentRecordId Int32 SET @CurrentRecordId = '0' dbo.GetValidDeviceForAlertProcessData 2025-12-29 03:06:41.3308 DFramework.Database.Query /* Time Taken: 1220*/ [dbo].GenerateSystemAlerts 2025-12-29 03:06:41.6902 DFramework.Database.Query /* Time Taken: 524*/ DECLARE @TableName AnsiString(8000) SET @TableName = 'MissingShelf' DECLARE @CurrentRecordId Int32 SET @CurrentRecordId = '3675242' dbo.GetValidDeviceForAlertProcessData 2025-12-29 03:06:46.2058 AlertProcessor ProcessorAlertData: Stopped 2025-12-29 03:06:55.7996 DFramework.Scheduler.TaskBase /* Time Taken: 15875.1079*/ Opportunity Out Of Stock By Outlet 2025-12-29 03:11:40.0514 AlertProcessor ProcessorAlertData: started 2025-12-29 03:11:45.7233 AlertProcessor ProcessorAlertData: Stopped 2025-12-29 03:16:40.0689 AlertProcessor ProcessorAlertData: started 2025-12-29 03:16:46.4909 DFramework.Database.Query /* Time Taken: 648*/ DECLARE @TableName AnsiString(8000) SET @TableName = 'ProductStockLevel' DECLARE @CurrentRecordId Int32 SET @CurrentRecordId = '3675242' dbo.GetValidDeviceForAlertProcessData 2025-12-29 03:16:46.5534 AlertProcessor ProcessorAlertData: Stopped 2025-12-29 03:21:40.0867 AlertProcessor ProcessorAlertData: started 2025-12-29 03:21:40.8055 DFramework.Database.Query /* Time Taken: 712*/ DECLARE @TableName AnsiString(8000) SET @TableName = 'TagAlert' DECLARE @CurrentRecordId Int32 SET @CurrentRecordId = '0' dbo.GetValidDeviceForAlertProcessData 2025-12-29 03:21:40.8992 DFramework.Database.Query /* Time Taken: 590*/ 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-29 03:21:41.4617 DFramework.Database.Query /* Time Taken: 1331*/ [dbo].GenerateSystemAlerts 2025-12-29 03:21:41.8211 DFramework.Database.Query /* Time Taken: 523*/ DECLARE @TableName AnsiString(8000) SET @TableName = 'MissingShelf' DECLARE @CurrentRecordId Int32 SET @CurrentRecordId = '3675242' dbo.GetValidDeviceForAlertProcessData 2025-12-29 03:21:43.7899 DFramework.Database.Query /* Time Taken: 528*/ DECLARE @TableName AnsiString(8000) SET @TableName = 'AssetStockProductWiseConsolidate' DECLARE @CurrentRecordId Int32 SET @CurrentRecordId = '3675242' dbo.GetValidDeviceForAlertProcessData 2025-12-29 03:21:46.3524 AlertProcessor ProcessorAlertData: Stopped 2025-12-29 03:21:56.0712 DFramework.Scheduler.TaskBase /* Time Taken: 16125.1241*/ Opportunity Out Of Stock By Outlet 2025-12-29 03:26:40.1045 AlertProcessor ProcessorAlertData: started 2025-12-29 03:26:40.8545 DFramework.Database.Query /* Time Taken: 739*/ DECLARE @TableName AnsiString(8000) SET @TableName = 'TagAlert' DECLARE @CurrentRecordId Int32 SET @CurrentRecordId = '0' dbo.GetValidDeviceForAlertProcessData 2025-12-29 03:26:40.9170 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-29 03:26:43.6670 DFramework.Database.Query /* Time Taken: 507*/ DECLARE @TableName AnsiString(8000) SET @TableName = 'AssetStockProductWiseConsolidate' DECLARE @CurrentRecordId Int32 SET @CurrentRecordId = '3675242' dbo.GetValidDeviceForAlertProcessData 2025-12-29 03:26:46.2764 AlertProcessor ProcessorAlertData: Stopped 2025-12-29 03:31:40.1217 AlertProcessor ProcessorAlertData: started 2025-12-29 03:31:43.2936 DFramework.Database.Query /* Time Taken: 601*/ DECLARE @TableName AnsiString(8000) SET @TableName = 'AssetStockProductWiseConsolidate' DECLARE @CurrentRecordId Int32 SET @CurrentRecordId = '3675242' dbo.GetValidDeviceForAlertProcessData 2025-12-29 03:31:44.5748 DFramework.Database.NullableDataReader Data reader open for 288 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-29 03:31:46.2623 AlertProcessor ProcessorAlertData: Stopped 2025-12-29 03:36:40.1237 AlertProcessor ProcessorAlertData: started 2025-12-29 03:36:40.9362 DFramework.Database.Query /* Time Taken: 839*/ 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-29 03:36:41.2956 MoveToReorder Running task for ClientId : 286 and ClientName = India Office QA and Slot: 12/29/2025 5:00:00 PM And LastExecutedOn: 12/29/2025 4:06:40 PM 2025-12-29 03:36:41.3112 DFramework.Database.Query /* Time Taken: 941*/ 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-29 03:36:41.3425 DFramework.Database.Query /* Time Taken: 1220*/ DECLARE @TableName AnsiString(8000) SET @TableName = 'TagAlert' DECLARE @CurrentRecordId Int32 SET @CurrentRecordId = '0' dbo.GetValidDeviceForAlertProcessData 2025-12-29 03:36:42.0143 DFramework.Database.Query /* Time Taken: 601*/ DECLARE @TableName AnsiString(8000) SET @TableName = 'VoidAlert' DECLARE @CurrentRecordId Int32 SET @CurrentRecordId = '3675242' dbo.GetValidDeviceForAlertProcessData 2025-12-29 03:36:42.0300 DFramework.Database.Query /* Time Taken: 1875*/ [dbo].GenerateSystemAlerts 2025-12-29 03:36:42.0300 DFramework.Database.Query /* Time Taken: 689*/ DECLARE @OrderStatusId Int32 SET @OrderStatusId = '0' DECLARE @ClientId Int32 SET @ClientId = '286' dbo.GetOrderDetailsByClientId 2025-12-29 03:36:42.0612 MoveToReorder Task executed successfully for ClientId : 286 Client Name:India Office QA, Slot: 12/29/2025 5:00:00 PM But No Order found to suggest 2025-12-29 03:36:42.7175 DFramework.Database.Query /* Time Taken: 653*/ DECLARE @TableName AnsiString(8000) SET @TableName = 'MissingShelf' DECLARE @CurrentRecordId Int32 SET @CurrentRecordId = '3675242' dbo.GetValidDeviceForAlertProcessData 2025-12-29 03:36:43.4050 DFramework.Database.Query /* Time Taken: 627*/ DECLARE @TableName AnsiString(8000) SET @TableName = 'AdditionalShelf' DECLARE @CurrentRecordId Int32 SET @CurrentRecordId = '3675242' dbo.GetValidDeviceForAlertProcessData 2025-12-29 03:36:43.7488 DFramework.Database.Query /* Time Taken: 1689*/ DECLARE @OrderStatusId Int32 SET @OrderStatusId = '5485' DECLARE @InTransitOrderStatusId Int32 SET @InTransitOrderStatusId = '5484' UPDATE Location SET OrderStatusId = @InTransitOrderStatusId FROM ScheduledOrder INNER JOIN Location ON Location.ScheduledOrderId = ScheduledOrder.ScheduledOrderId INNER JOIN CLient On Client.ClientId = Location.ClientId AND Client.HoursMoveScheduledToInTransit > -1 WHERE DATEADD(HOUR, Client.HoursMoveScheduledToInTransit, ScheduledOrder.ModifiedOn) < GETUTCDATE() AND ScheduledOrder.StatusId = @OrderStatusId AND Location.IsDeleted = 0 AND ScheduledOrder.IsDeleted = 0 AND Location.OrderStatusId = @OrderStatusId 2025-12-29 03:36:44.2644 DFramework.Database.Query /* Time Taken: 517*/ DECLARE @OrderStatusId Int32 SET @OrderStatusId = '5485' DECLARE @InTransitOrderStatusId Int32 SET @InTransitOrderStatusId = '5484' UPDATE ScheduledOrder SET StatusId = @InTransitOrderStatusId, ModifiedOn = GETUTCDATE() FROM ScheduledOrder INNER JOIN Location ON Location.ScheduledOrderId = ScheduledOrder.ScheduledOrderId INNER JOIN CLient On Client.ClientId = Location.ClientId AND Client.HoursMoveScheduledToInTransit > -1 WHERE DATEADD(HOUR, Client.HoursMoveScheduledToInTransit, ScheduledOrder.ModifiedOn) < GETUTCDATE() AND ScheduledOrder.StatusId = @OrderStatusId AND Location.IsDeleted = 0 AND ScheduledOrder.IsDeleted = 0 AND Location.OrderStatusId <> @OrderStatusId 2025-12-29 03:36:44.9362 DFramework.Database.Query /* Time Taken: 539*/ DECLARE @TableName AnsiString(8000) SET @TableName = 'AssetStockProductWiseConsolidate' DECLARE @CurrentRecordId Int32 SET @CurrentRecordId = '3675242' dbo.GetValidDeviceForAlertProcessData 2025-12-29 03:36:48.2331 AlertProcessor ProcessorAlertData: Stopped 2025-12-29 03:36:56.4363 DFramework.Scheduler.TaskBase /* Time Taken: 16468.8632*/ Opportunity Out Of Stock By Outlet 2025-12-29 03:41:40.1415 AlertProcessor ProcessorAlertData: started 2025-12-29 03:41:46.0790 DFramework.Database.Query /* Time Taken: 678*/ DECLARE @TableName AnsiString(8000) SET @TableName = 'ProductStockLevel' DECLARE @CurrentRecordId Int32 SET @CurrentRecordId = '3675242' dbo.GetValidDeviceForAlertProcessData 2025-12-29 03:41:46.1415 AlertProcessor ProcessorAlertData: Stopped 2025-12-29 03:46:40.1587 AlertProcessor ProcessorAlertData: started 2025-12-29 03:46:42.0805 DFramework.Database.Query /* Time Taken: 507*/ DECLARE @TableName AnsiString(8000) SET @TableName = 'AdditionalShelf' DECLARE @CurrentRecordId Int32 SET @CurrentRecordId = '3675242' dbo.GetValidDeviceForAlertProcessData 2025-12-29 03:46:42.9243 DFramework.Database.Query /* Time Taken: 503*/ DECLARE @TableName AnsiString(8000) SET @TableName = 'PlanogramComplianceConsolidate' DECLARE @CurrentRecordId Int32 SET @CurrentRecordId = '3675242' dbo.GetValidDeviceForAlertProcessData 2025-12-29 03:46:46.3462 AlertProcessor ProcessorAlertData: Stopped 2025-12-29 03:51:40.1761 AlertProcessor ProcessorAlertData: started 2025-12-29 03:51:41.5823 DFramework.Database.Query /* Time Taken: 1413*/ [dbo].GenerateSystemAlerts 2025-12-29 03:51:41.6605 DFramework.Database.Query /* Time Taken: 544*/ DECLARE @TableName AnsiString(8000) SET @TableName = 'MissingShelf' DECLARE @CurrentRecordId Int32 SET @CurrentRecordId = '3675242' dbo.GetValidDeviceForAlertProcessData 2025-12-29 03:51:46.2542 AlertProcessor ProcessorAlertData: Stopped 2025-12-29 03:51:55.9262 DFramework.Scheduler.TaskBase /* Time Taken: 15937.598*/ Opportunity Out Of Stock By Outlet 2025-12-29 03:56:40.1938 AlertProcessor ProcessorAlertData: started 2025-12-29 03:56:45.8501 AlertProcessor ProcessorAlertData: Stopped 2025-12-29 04:01:40.2114 AlertProcessor ProcessorAlertData: started 2025-12-29 04:01:45.5552 AlertProcessor ProcessorAlertData: Stopped 2025-12-29 04:06:40.2289 AlertProcessor ProcessorAlertData: started 2025-12-29 04:06:40.7445 DFramework.Database.Query /* Time Taken: 626*/ 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-29 04:06:41.1820 DFramework.Database.Query /* Time Taken: 950*/ DECLARE @TableName AnsiString(8000) SET @TableName = 'TagAlert' DECLARE @CurrentRecordId Int32 SET @CurrentRecordId = '0' dbo.GetValidDeviceForAlertProcessData 2025-12-29 04:06:41.1976 DFramework.Database.Query /* Time Taken: 754*/ 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-29 04:06:41.8070 DFramework.Database.Query /* Time Taken: 1622*/ [dbo].GenerateSystemAlerts 2025-12-29 04:06:42.1507 DFramework.Database.Query /* Time Taken: 529*/ DECLARE @TableName AnsiString(8000) SET @TableName = 'MissingShelf' DECLARE @CurrentRecordId Int32 SET @CurrentRecordId = '3675242' dbo.GetValidDeviceForAlertProcessData 2025-12-29 04:06:46.3695 AlertProcessor ProcessorAlertData: Stopped 2025-12-29 04:06:56.5571 DFramework.Scheduler.TaskBase /* Time Taken: 16546.9806*/ Opportunity Out Of Stock By Outlet 2025-12-29 04:11:40.2309 AlertProcessor ProcessorAlertData: started 2025-12-29 04:11:40.7466 DFramework.Database.Query /* Time Taken: 510*/ DECLARE @TableName AnsiString(8000) SET @TableName = 'TagAlert' DECLARE @CurrentRecordId Int32 SET @CurrentRecordId = '0' dbo.GetValidDeviceForAlertProcessData 2025-12-29 04:11:42.1216 DFramework.Database.Query /* Time Taken: 804*/ DECLARE @TableName AnsiString(8000) SET @TableName = 'MissingShelf' DECLARE @CurrentRecordId Int32 SET @CurrentRecordId = '3675242' dbo.GetValidDeviceForAlertProcessData 2025-12-29 04:11:46.3091 AlertProcessor ProcessorAlertData: Stopped 2025-12-29 04:16:40.2331 AlertProcessor ProcessorAlertData: started 2025-12-29 04:16:45.9988 AlertProcessor ProcessorAlertData: Stopped 2025-12-29 04:21:40.2340 AlertProcessor ProcessorAlertData: started 2025-12-29 04:21:41.5153 DFramework.Database.Query /* Time Taken: 1309*/ [dbo].GenerateSystemAlerts 2025-12-29 04:21:43.7340 DFramework.Database.Query /* Time Taken: 678*/ DECLARE @TableName AnsiString(8000) SET @TableName = 'AssetStockProductWiseConsolidate' DECLARE @CurrentRecordId Int32 SET @CurrentRecordId = '3675242' dbo.GetValidDeviceForAlertProcessData 2025-12-29 04:21:46.3434 AlertProcessor ProcessorAlertData: Stopped 2025-12-29 04:21:51.5153 DFramework.Database.Query /* Time Taken: 713*/ DECLARE @ClientId Int32 SET @ClientId = '1494' DECLARE @MarketId Int32 SET @MarketId = '0' DECLARE @ClassificationId Int32 SET @ClassificationId = '0' DECLARE @LocationId Int32 SET @LocationId = '0' DECLARE @LocationTypeId Int32 SET @LocationTypeId = '0' DECLARE @StartDate DateTime2 SET @StartDate = '6/14/2025 12:00:00 AM' dbo.GetOpportunityOutOfStockDataByOutlet 2025-12-29 04:21:56.7653 DFramework.Scheduler.TaskBase /* Time Taken: 16734.4402*/ Opportunity Out Of Stock By Outlet 2025-12-29 04:26:40.2357 AlertProcessor ProcessorAlertData: started 2025-12-29 04:26:43.6420 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-29 04:26:46.4232 AlertProcessor ProcessorAlertData: Stopped 2025-12-29 04:31:40.2534 AlertProcessor ProcessorAlertData: started 2025-12-29 04:31:45.8003 AlertProcessor ProcessorAlertData: Stopped 2025-12-29 04:36:40.2714 AlertProcessor ProcessorAlertData: started 2025-12-29 04:36:40.8340 MoveToReorder Running task for ClientId : 286 and ClientName = India Office QA and Slot: 12/29/2025 6:00:00 PM And LastExecutedOn: 12/29/2025 5:06:41 PM 2025-12-29 04:36:41.1465 DFramework.Database.Query /* Time Taken: 618*/ 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-29 04:36:41.3652 MoveToReorder Task executed successfully for ClientId : 286 Client Name:India Office QA, Slot: 12/29/2025 6:00:00 PM But No Order found to suggest 2025-12-29 04:36:41.6621 DFramework.Database.Query /* Time Taken: 1436*/ [dbo].GenerateSystemAlerts 2025-12-29 04:36:41.7871 DFramework.Database.Query /* Time Taken: 560*/ DECLARE @TableName AnsiString(8000) SET @TableName = 'MissingShelf' DECLARE @CurrentRecordId Int32 SET @CurrentRecordId = '3675242' dbo.GetValidDeviceForAlertProcessData 2025-12-29 04:36:46.4590 AlertProcessor ProcessorAlertData: Stopped 2025-12-29 04:36:56.0997 DFramework.Scheduler.TaskBase /* Time Taken: 16047.02*/ Opportunity Out Of Stock By Outlet 2025-12-29 04:41:40.2896 AlertProcessor ProcessorAlertData: started 2025-12-29 04:41:46.2428 DFramework.Database.Query /* Time Taken: 823*/ DECLARE @TableName AnsiString(8000) SET @TableName = 'ProductStockLevel' DECLARE @CurrentRecordId Int32 SET @CurrentRecordId = '3675242' dbo.GetValidDeviceForAlertProcessData 2025-12-29 04:41:46.2896 AlertProcessor ProcessorAlertData: Stopped 2025-12-29 04:46:40.3075 AlertProcessor ProcessorAlertData: started 2025-12-29 04:46:42.0575 DFramework.Database.Query /* Time Taken: 644*/ DECLARE @TableName AnsiString(8000) SET @TableName = 'AdditionalShelf' DECLARE @CurrentRecordId Int32 SET @CurrentRecordId = '3675242' dbo.GetValidDeviceForAlertProcessData 2025-12-29 04:46:45.7138 AlertProcessor ProcessorAlertData: Stopped 2025-12-29 04:51:40.3253 AlertProcessor ProcessorAlertData: started 2025-12-29 04:51:41.1847 DFramework.Database.Query /* Time Taken: 930*/ [dbo].GenerateSystemAlerts 2025-12-29 04:51:45.6378 AlertProcessor ProcessorAlertData: Stopped 2025-12-29 04:51:55.8879 DFramework.Scheduler.TaskBase /* Time Taken: 15812.6159*/ Opportunity Out Of Stock By Outlet 2025-12-29 04:56:40.3431 AlertProcessor ProcessorAlertData: started 2025-12-29 04:56:45.4369 AlertProcessor ProcessorAlertData: Stopped 2025-12-29 05:01:40.3609 AlertProcessor ProcessorAlertData: started 2025-12-29 05:01:45.7828 AlertProcessor ProcessorAlertData: Stopped 2025-12-29 05:06:40.3787 AlertProcessor ProcessorAlertData: started 2025-12-29 05:06:41.1131 DFramework.Database.Query /* Time Taken: 838*/ [dbo].GenerateSystemAlerts 2025-12-29 05:06:45.7538 AlertProcessor ProcessorAlertData: Stopped 2025-12-29 05:06:55.8320 DFramework.Scheduler.TaskBase /* Time Taken: 15734.4922*/ Opportunity Out Of Stock By Outlet 2025-12-29 05:11:40.3963 AlertProcessor ProcessorAlertData: started 2025-12-29 05:11:45.8026 AlertProcessor ProcessorAlertData: Stopped 2025-12-29 05:16:40.4139 AlertProcessor ProcessorAlertData: started 2025-12-29 05:16:45.6014 AlertProcessor ProcessorAlertData: Stopped 2025-12-29 05:21:40.4317 AlertProcessor ProcessorAlertData: started 2025-12-29 05:21:40.9161 DFramework.Database.Query /* Time Taken: 631*/ [dbo].GenerateSystemAlerts 2025-12-29 05:21:45.6349 AlertProcessor ProcessorAlertData: Stopped 2025-12-29 05:21:55.8068 DFramework.Scheduler.TaskBase /* Time Taken: 15687.6114*/ Opportunity Out Of Stock By Outlet 2025-12-29 05:26:40.4495 AlertProcessor ProcessorAlertData: started 2025-12-29 05:26:45.6995 AlertProcessor ProcessorAlertData: Stopped 2025-12-29 05:31:40.4673 AlertProcessor ProcessorAlertData: started 2025-12-29 05:31:43.9674 DFramework.Database.NullableDataReader Data reader open for 272 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-29 05:31:45.7642 AlertProcessor ProcessorAlertData: Stopped 2025-12-29 05:36:40.4851 AlertProcessor ProcessorAlertData: started 2025-12-29 05:36:40.7664 MoveToReorder Running task for ClientId : 286 and ClientName = India Office QA and Slot: 12/29/2025 7:00:00 PM And LastExecutedOn: 12/29/2025 6:06:40 PM 2025-12-29 05:36:41.7508 DFramework.Database.Query /* Time Taken: 1445*/ [dbo].GenerateSystemAlerts 2025-12-29 05:36:41.8758 DFramework.Database.Query /* Time Taken: 514*/ DECLARE @TableName AnsiString(8000) SET @TableName = 'MissingShelf' DECLARE @CurrentRecordId Int32 SET @CurrentRecordId = '3675242' dbo.GetValidDeviceForAlertProcessData 2025-12-29 05:36:46.3914 AlertProcessor ProcessorAlertData: Stopped 2025-12-29 05:36:56.1727 DFramework.Scheduler.TaskBase /* Time Taken: 16031.3696*/ Opportunity Out Of Stock By Outlet 2025-12-29 05:37:22.2511 DFramework.Database.NullableDataReader Data reader open for 40868 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-29 05:37:22.2823 MoveToReorder Task executed successfully for ClientId : 286 Client Name:India Office QA, Slot: 12/29/2025 7:00:00 PM and Total Order Suggested: 126 Out Of: 126 2025-12-29 05:37:23.3292 DFramework.Scheduler.TaskBase /* Time Taken: 43015.9472*/ Move To Re-Order 2025-12-29 05:41:40.5029 AlertProcessor ProcessorAlertData: started 2025-12-29 05:41:45.7217 AlertProcessor ProcessorAlertData: Stopped 2025-12-29 05:46:40.5204 AlertProcessor ProcessorAlertData: started 2025-12-29 05:46:43.5048 DFramework.Database.Query /* Time Taken: 638*/ DECLARE @TableName AnsiString(8000) SET @TableName = 'AssetStockProductWiseConsolidate' DECLARE @CurrentRecordId Int32 SET @CurrentRecordId = '3675242' dbo.GetValidDeviceForAlertProcessData 2025-12-29 05:46:45.9111 AlertProcessor ProcessorAlertData: Stopped 2025-12-29 05:51:40.5225 AlertProcessor ProcessorAlertData: started 2025-12-29 05:51:41.2881 DFramework.Database.Query /* Time Taken: 965*/ [dbo].GenerateSystemAlerts 2025-12-29 05:51:46.0694 AlertProcessor ProcessorAlertData: Stopped 2025-12-29 05:51:55.9601 DFramework.Scheduler.TaskBase /* Time Taken: 15796.9885*/ Opportunity Out Of Stock By Outlet 2025-12-29 05:56:40.5402 AlertProcessor ProcessorAlertData: started 2025-12-29 05:56:45.8372 AlertProcessor ProcessorAlertData: Stopped 2025-12-29 06:01:40.5580 AlertProcessor ProcessorAlertData: started 2025-12-29 06:01:45.7768 AlertProcessor ProcessorAlertData: Stopped 2025-12-29 06:06:40.5757 AlertProcessor ProcessorAlertData: started 2025-12-29 06:06:41.4038 DFramework.Database.Query /* Time Taken: 1052*/ [dbo].GenerateSystemAlerts 2025-12-29 06:06:44.8257 AlertProcessor Replace Tags updated for the Image Id: 3675308 2025-12-29 06:06:45.0132 DFramework.Database.NullableDataReader Data reader open for 273 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-29 06:06:45.6695 DFramework.Database.NullableDataReader Data reader open for 404 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-29 06:06:45.7164 DFramework.Database.NullableDataReader Data reader open for 488 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-29 06:06:47.4664 AlertProcessor ProcessorAlertData: Stopped 2025-12-29 06:06:56.0602 DFramework.Scheduler.TaskBase /* Time Taken: 15890.7485*/ Opportunity Out Of Stock By Outlet 2025-12-29 06:11:40.5935 AlertProcessor ProcessorAlertData: started 2025-12-29 06:11:45.9060 AlertProcessor ProcessorAlertData: Stopped 2025-12-29 06:16:40.6113 AlertProcessor ProcessorAlertData: started 2025-12-29 06:16:46.2364 AlertProcessor ProcessorAlertData: Stopped 2025-12-29 06:21:40.6132 AlertProcessor ProcessorAlertData: started 2025-12-29 06:21:41.3007 DFramework.Database.Query /* Time Taken: 921*/ [dbo].GenerateSystemAlerts 2025-12-29 06:21:46.6132 DFramework.Database.Query /* Time Taken: 606*/ DECLARE @TableName AnsiString(8000) SET @TableName = 'ProductStockLevel' DECLARE @CurrentRecordId Int32 SET @CurrentRecordId = '3675308' dbo.GetValidDeviceForAlertProcessData 2025-12-29 06:21:46.8789 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-29 06:21:46.8789 AlertProcessor ProcessorAlertData: Stopped 2025-12-29 06:21:56.0352 DFramework.Scheduler.TaskBase /* Time Taken: 15843.8506*/ Opportunity Out Of Stock By Outlet 2025-12-29 06:26:40.6153 AlertProcessor ProcessorAlertData: started 2025-12-29 06:26:45.8966 AlertProcessor ProcessorAlertData: Stopped 2025-12-29 06:31:40.6175 AlertProcessor ProcessorAlertData: started 2025-12-29 06:31:46.2738 AlertProcessor ProcessorAlertData: Stopped 2025-12-29 06:36:40.6196 AlertProcessor ProcessorAlertData: started 2025-12-29 06:36:40.7758 MoveToReorder Running task for ClientId : 286 and ClientName = India Office QA and Slot: 12/29/2025 8:00:00 PM And LastExecutedOn: 12/29/2025 7:06:40 PM 2025-12-29 06:36:41.3852 DFramework.Database.Query /* Time Taken: 545*/ DECLARE @OrderStatusId Int32 SET @OrderStatusId = '0' DECLARE @ClientId Int32 SET @ClientId = '286' dbo.GetOrderDetailsByClientId 2025-12-29 06:36:41.4165 MoveToReorder Task executed successfully for ClientId : 286 Client Name:India Office QA, Slot: 12/29/2025 8:00:00 PM But No Order found to suggest 2025-12-29 06:36:42.0884 DFramework.Database.Query /* Time Taken: 591*/ DECLARE @TableName AnsiString(8000) SET @TableName = 'MissingShelf' DECLARE @CurrentRecordId Int32 SET @CurrentRecordId = '3675308' dbo.GetValidDeviceForAlertProcessData 2025-12-29 06:36:42.4477 DFramework.Database.Query /* Time Taken: 2048*/ [dbo].GenerateSystemAlerts 2025-12-29 06:36:46.5103 AlertProcessor ProcessorAlertData: Stopped 2025-12-29 06:36:56.2760 DFramework.Scheduler.TaskBase /* Time Taken: 16062.6161*/ Opportunity Out Of Stock By Outlet 2025-12-29 06:41:40.6374 AlertProcessor ProcessorAlertData: started 2025-12-29 06:41:41.1842 DFramework.Database.Query /* Time Taken: 542*/ DECLARE @TableName AnsiString(8000) SET @TableName = 'TagAlert' DECLARE @CurrentRecordId Int32 SET @CurrentRecordId = '0' dbo.GetValidDeviceForAlertProcessData 2025-12-29 06:41:46.1999 AlertProcessor ProcessorAlertData: Stopped 2025-12-29 06:46:40.6552 AlertProcessor ProcessorAlertData: started 2025-12-29 06:46:41.9677 DFramework.Database.Query /* Time Taken: 601*/ DECLARE @TableName AnsiString(8000) SET @TableName = 'MissingShelf' DECLARE @CurrentRecordId Int32 SET @CurrentRecordId = '3675316' dbo.GetValidDeviceForAlertProcessData 2025-12-29 06:46:44.4833 AlertProcessor Replace Tags updated for the Image Id: 3675316 2025-12-29 06:46:44.6552 DFramework.Database.NullableDataReader Data reader open for 270 at System.Environment.GetStackTrace(Exception e, Boolean needFileInfo) at System.Environment.get_StackTrace() at DFramework.Database.NullableDataReader.Dispose(Boolean disposing) in D:\Spraxa\Framework\DFramework\Database\NullableDataReader.cs:line 33 at DFramework.Database.NullableDataReader.Dispose() in D:\Spraxa\Framework\DFramework\Database\NullableDataReader.cs:line 44 at CoolR.Tasks.ProcessAlertData.Execute() in D:\Spraxa\CoolR-Group\portal\CoolR.Tasks\ProcessAlertData.cs:line 47 at DFramework.Scheduler.TaskBase.Run() in D:\Spraxa\Framework\DFramework.Scheduler\TaskBase.cs:line 176 at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx) at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx) at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state) at System.Threading.ThreadHelper.ThreadStart() 2025-12-29 06:46:45.1865 DFramework.Database.NullableDataReader Data reader open for 294 at System.Environment.GetStackTrace(Exception e, Boolean needFileInfo) at System.Environment.get_StackTrace() at DFramework.Database.NullableDataReader.Dispose(Boolean disposing) in D:\Spraxa\Framework\DFramework\Database\NullableDataReader.cs:line 33 at DFramework.Database.NullableDataReader.Dispose() in D:\Spraxa\Framework\DFramework\Database\NullableDataReader.cs:line 44 at CoolR.Tasks.ProcessAlertData.Execute() in D:\Spraxa\CoolR-Group\portal\CoolR.Tasks\ProcessAlertData.cs:line 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-29 06:46:45.2490 DFramework.Database.NullableDataReader Data reader open for 378 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-29 06:46:47.0615 DFramework.Database.Query /* Time Taken: 565*/ DECLARE @TableName AnsiString(8000) SET @TableName = 'ProductStockLevel' DECLARE @CurrentRecordId Int32 SET @CurrentRecordId = '3675316' dbo.GetValidDeviceForAlertProcessData 2025-12-29 06:46:47.1396 AlertProcessor ProcessorAlertData: Stopped 2025-12-29 06:51:40.6729 AlertProcessor ProcessorAlertData: started 2025-12-29 06:51:41.5011 DFramework.Database.Query /* Time Taken: 1078*/ [dbo].GenerateSystemAlerts 2025-12-29 06:51:46.0011 AlertProcessor ProcessorAlertData: Stopped 2025-12-29 06:51:56.1261 DFramework.Scheduler.TaskBase /* Time Taken: 15890.7067*/ Opportunity Out Of Stock By Outlet 2025-12-29 06:56:40.6748 AlertProcessor ProcessorAlertData: started 2025-12-29 06:56:45.8779 AlertProcessor ProcessorAlertData: Stopped 2025-12-29 07:01:40.6925 AlertProcessor ProcessorAlertData: started 2025-12-29 07:01:46.0988 AlertProcessor ProcessorAlertData: Stopped 2025-12-29 07:06:40.7103 AlertProcessor ProcessorAlertData: started 2025-12-29 07:06:41.2884 DFramework.Database.Query /* Time Taken: 851*/ [dbo].GenerateSystemAlerts 2025-12-29 07:06:42.5697 DFramework.Database.Query /* Time Taken: 1739*/ DECLARE @OrderStatusId Int32 SET @OrderStatusId = '5485' DECLARE @InTransitOrderStatusId Int32 SET @InTransitOrderStatusId = '5484' UPDATE Location SET OrderStatusId = @InTransitOrderStatusId FROM ScheduledOrder INNER JOIN Location ON Location.ScheduledOrderId = ScheduledOrder.ScheduledOrderId INNER JOIN CLient On Client.ClientId = Location.ClientId AND Client.HoursMoveScheduledToInTransit > -1 WHERE DATEADD(HOUR, Client.HoursMoveScheduledToInTransit, ScheduledOrder.ModifiedOn) < GETUTCDATE() AND ScheduledOrder.StatusId = @OrderStatusId AND Location.IsDeleted = 0 AND ScheduledOrder.IsDeleted = 0 AND Location.OrderStatusId = @OrderStatusId 2025-12-29 07:06:46.0072 AlertProcessor ProcessorAlertData: Stopped 2025-12-29 07:06:56.1948 DFramework.Scheduler.TaskBase /* Time Taken: 15937.6193*/ Opportunity Out Of Stock By Outlet 2025-12-29 07:11:40.7123 AlertProcessor ProcessorAlertData: started 2025-12-29 07:11:45.9467 AlertProcessor ProcessorAlertData: Stopped 2025-12-29 07:16:40.7300 AlertProcessor ProcessorAlertData: started 2025-12-29 07:16:45.6363 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-29 07:16:46.1207 AlertProcessor ProcessorAlertData: Stopped 2025-12-29 07:21:40.7478 AlertProcessor ProcessorAlertData: started 2025-12-29 07:21:41.5447 DFramework.Database.Query /* Time Taken: 1077*/ [dbo].GenerateSystemAlerts 2025-12-29 07:21:46.4666 AlertProcessor ProcessorAlertData: Stopped 2025-12-29 07:21:56.2167 DFramework.Scheduler.TaskBase /* Time Taken: 15937.6111*/ Opportunity Out Of Stock By Outlet 2025-12-29 07:26:40.7654 AlertProcessor ProcessorAlertData: started 2025-12-29 07:26:45.9217 AlertProcessor ProcessorAlertData: Stopped 2025-12-29 07:31:40.7829 AlertProcessor ProcessorAlertData: started 2025-12-29 07:31:45.8767 AlertProcessor ProcessorAlertData: Stopped 2025-12-29 07:36:40.8006 AlertProcessor ProcessorAlertData: started 2025-12-29 07:36:40.8788 MoveToReorder Running task for ClientId : 286 and ClientName = India Office QA and Slot: 12/29/2025 9:00:00 PM And LastExecutedOn: 12/29/2025 8:06:40 PM 2025-12-29 07:36:41.3631 DFramework.Database.Query /* Time Taken: 563*/ DECLARE @TableName AnsiString(8000) SET @TableName = 'TagAlert' DECLARE @CurrentRecordId Int32 SET @CurrentRecordId = '0' dbo.GetValidDeviceForAlertProcessData 2025-12-29 07:36:41.5506 DFramework.Database.Query /* Time Taken: 602*/ DECLARE @OrderStatusId Int32 SET @OrderStatusId = '0' DECLARE @ClientId Int32 SET @ClientId = '286' dbo.GetOrderDetailsByClientId 2025-12-29 07:36:41.5663 DFramework.Database.Query /* Time Taken: 1093*/ [dbo].GenerateSystemAlerts 2025-12-29 07:36:41.5819 MoveToReorder Task executed successfully for ClientId : 286 Client Name:India Office QA, Slot: 12/29/2025 9:00:00 PM But No Order found to suggest 2025-12-29 07:36:46.4726 AlertProcessor ProcessorAlertData: Stopped 2025-12-29 07:36:56.1601 DFramework.Scheduler.TaskBase /* Time Taken: 15859.4877*/ Opportunity Out Of Stock By Outlet 2025-12-29 07:41:40.8184 AlertProcessor ProcessorAlertData: started 2025-12-29 07:41:45.8810 AlertProcessor ProcessorAlertData: Stopped 2025-12-29 07:46:40.8359 AlertProcessor ProcessorAlertData: started 2025-12-29 07:46:41.7265 DFramework.Database.Query /* Time Taken: 555*/ DECLARE @TableName AnsiString(8000) SET @TableName = 'VoidAlert' DECLARE @CurrentRecordId Int32 SET @CurrentRecordId = '3675316' dbo.GetValidDeviceForAlertProcessData 2025-12-29 07:46:46.3984 AlertProcessor ProcessorAlertData: Stopped 2025-12-29 07:51:40.8536 AlertProcessor ProcessorAlertData: started 2025-12-29 07:51:42.5098 DFramework.Database.Query /* Time Taken: 580*/ DECLARE @TableName AnsiString(8000) SET @TableName = 'AdditionalShelf' DECLARE @CurrentRecordId Int32 SET @CurrentRecordId = '3675316' dbo.GetValidDeviceForAlertProcessData 2025-12-29 07:51:46.1349 AlertProcessor ProcessorAlertData: Stopped 2025-12-29 07:51:55.9943 DFramework.Scheduler.TaskBase /* Time Taken: 15671.9936*/ Opportunity Out Of Stock By Outlet 2025-12-29 07:56:40.8714 AlertProcessor ProcessorAlertData: started 2025-12-29 07:56:45.9808 AlertProcessor ProcessorAlertData: Stopped 2025-12-29 08:01:40.8890 AlertProcessor ProcessorAlertData: started 2025-12-29 08:01:46.0609 AlertProcessor ProcessorAlertData: Stopped 2025-12-29 08:06:40.9066 AlertProcessor ProcessorAlertData: started 2025-12-29 08:06:46.0629 AlertProcessor ProcessorAlertData: Stopped 2025-12-29 08:06:56.0786 DFramework.Scheduler.TaskBase /* Time Taken: 15734.4826*/ Opportunity Out Of Stock By Outlet 2025-12-29 08:11:40.9243 AlertProcessor ProcessorAlertData: started 2025-12-29 08:11:45.9556 AlertProcessor ProcessorAlertData: Stopped 2025-12-29 08:16:40.9265 AlertProcessor ProcessorAlertData: started 2025-12-29 08:16:46.0984 AlertProcessor ProcessorAlertData: Stopped 2025-12-29 08:21:40.9440 AlertProcessor ProcessorAlertData: started 2025-12-29 08:21:46.0690 AlertProcessor ProcessorAlertData: Stopped 2025-12-29 08:21:56.0535 DFramework.Scheduler.TaskBase /* Time Taken: 15687.6174*/ Opportunity Out Of Stock By Outlet 2025-12-29 08:26:40.9617 AlertProcessor ProcessorAlertData: started 2025-12-29 08:26:45.9774 AlertProcessor ProcessorAlertData: Stopped 2025-12-29 08:31:40.9639 AlertProcessor ProcessorAlertData: started 2025-12-29 08:31:46.5733 AlertProcessor ProcessorAlertData: Stopped 2025-12-29 08:36:40.9658 AlertProcessor ProcessorAlertData: started 2025-12-29 08:36:40.9815 MoveToReorder Running task for ClientId : 286 and ClientName = India Office QA and Slot: 12/29/2025 10:00:00 PM And LastExecutedOn: 12/29/2025 9:06:40 PM 2025-12-29 08:36:41.7002 DFramework.Database.Query /* Time Taken: 652*/ DECLARE @OrderStatusId Int32 SET @OrderStatusId = '0' DECLARE @ClientId Int32 SET @ClientId = '286' dbo.GetOrderDetailsByClientId 2025-12-29 08:36:46.8721 AlertProcessor ProcessorAlertData: Stopped 2025-12-29 08:36:56.1534 DFramework.Scheduler.TaskBase /* Time Taken: 15781.3486*/ Opportunity Out Of Stock By Outlet 2025-12-29 08:37:23.2005 DFramework.Database.NullableDataReader Data reader open for 41243 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-29 08:37:23.2317 MoveToReorder Task executed successfully for ClientId : 286 Client Name:India Office QA, Slot: 12/29/2025 10:00:00 PM and Total Order Suggested: 126 Out Of: 126 2025-12-29 08:37:24.1224 DFramework.Scheduler.TaskBase /* Time Taken: 43515.9078*/ Move To Re-Order 2025-12-29 08:41:40.9835 AlertProcessor ProcessorAlertData: started 2025-12-29 08:41:46.5460 AlertProcessor ProcessorAlertData: Stopped 2025-12-29 08:46:41.0013 AlertProcessor ProcessorAlertData: started 2025-12-29 08:46:46.7201 AlertProcessor ProcessorAlertData: Stopped 2025-12-29 08:51:41.0190 AlertProcessor ProcessorAlertData: started 2025-12-29 08:51:41.2847 DFramework.Database.Query /* Time Taken: 720*/ [dbo].GenerateSystemAlerts 2025-12-29 08:51:46.8003 AlertProcessor ProcessorAlertData: Stopped 2025-12-29 08:51:56.1441 DFramework.Scheduler.TaskBase /* Time Taken: 15765.7362*/ Opportunity Out Of Stock By Outlet 2025-12-29 08:56:41.0368 AlertProcessor ProcessorAlertData: started 2025-12-29 08:56:44.6306 DFramework.Database.Query /* Time Taken: 684*/ DECLARE @TableName AnsiString(8000) SET @TableName = 'AssetStockProductWiseConsolidate' DECLARE @CurrentRecordId Int32 SET @CurrentRecordId = '3675322' dbo.GetValidDeviceForAlertProcessData 2025-12-29 08:56:45.3962 AlertProcessor Replace Tags updated for the Image Id: 3675322 2025-12-29 08:56:45.5681 DFramework.Database.NullableDataReader Data reader open for 264 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-29 08:56:46.1462 DFramework.Database.NullableDataReader Data reader open for 313 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-29 08:56:46.2087 DFramework.Database.NullableDataReader Data reader open for 396 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-29 08:56:47.0212 DFramework.Database.NullableDataReader Data reader open for 238 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-29 08:56:48.6462 DFramework.Database.NullableDataReader Data reader open for 486 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-29 08:56:48.7087 DFramework.Database.NullableDataReader Data reader open for 569 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-29 08:56:48.7400 AlertProcessor ProcessorAlertData: Stopped 2025-12-29 09:01:41.0546 AlertProcessor ProcessorAlertData: started 2025-12-29 09:01:46.6327 AlertProcessor ProcessorAlertData: Stopped 2025-12-29 09:06:41.0724 AlertProcessor ProcessorAlertData: started 2025-12-29 09:06:41.1036 DFramework.Database.Query /* Time Taken: 528*/ [dbo].GenerateSystemAlerts 2025-12-29 09:06:46.8380 AlertProcessor ProcessorAlertData: Stopped 2025-12-29 09:06:56.2287 DFramework.Scheduler.TaskBase /* Time Taken: 15843.8674*/ Opportunity Out Of Stock By Outlet 2025-12-29 09:11:41.0899 AlertProcessor ProcessorAlertData: started 2025-12-29 09:11:44.1680 DFramework.Database.Query /* Time Taken: 547*/ DECLARE @TableName AnsiString(8000) SET @TableName = 'AssetStockProductWiseConsolidate' DECLARE @CurrentRecordId Int32 SET @CurrentRecordId = '3675322' dbo.GetValidDeviceForAlertProcessData 2025-12-29 09:11:46.8399 AlertProcessor ProcessorAlertData: Stopped 2025-12-29 09:16:41.1076 AlertProcessor ProcessorAlertData: started 2025-12-29 09:16:41.7014 DFramework.Database.Query /* Time Taken: 592*/ DECLARE @TableName AnsiString(8000) SET @TableName = 'TagAlert' DECLARE @CurrentRecordId Int32 SET @CurrentRecordId = '0' dbo.GetValidDeviceForAlertProcessData 2025-12-29 09:16:47.1701 DFramework.Database.Query /* Time Taken: 576*/ DECLARE @TableName AnsiString(8000) SET @TableName = 'ProductStockLevel' DECLARE @CurrentRecordId Int32 SET @CurrentRecordId = '3675322' dbo.GetValidDeviceForAlertProcessData 2025-12-29 09:16:47.2326 AlertProcessor ProcessorAlertData: Stopped 2025-12-29 09:21:41.1098 DFramework.Database.Query /* Time Taken: 502*/ [dbo].GenerateSystemAlerts 2025-12-29 09:21:41.1254 AlertProcessor ProcessorAlertData: started 2025-12-29 09:21:46.7035 AlertProcessor ProcessorAlertData: Stopped 2025-12-29 09:21:56.1880 DFramework.Scheduler.TaskBase /* Time Taken: 15781.3605*/ Opportunity Out Of Stock By Outlet 2025-12-29 09:26:41.1432 AlertProcessor ProcessorAlertData: started 2025-12-29 09:26:46.6432 AlertProcessor ProcessorAlertData: Stopped 2025-12-29 09:31:41.1453 AlertProcessor ProcessorAlertData: started 2025-12-29 09:31:46.8172 AlertProcessor ProcessorAlertData: Stopped 2025-12-29 09:36:41.1475 AlertProcessor ProcessorAlertData: started 2025-12-29 09:36:41.2412 DFramework.Database.Query /* Time Taken: 637*/ [dbo].GenerateSystemAlerts 2025-12-29 09:36:46.7100 AlertProcessor ProcessorAlertData: Stopped 2025-12-29 09:36:56.2882 DFramework.Scheduler.TaskBase /* Time Taken: 15859.4924*/ Opportunity Out Of Stock By Outlet 2025-12-29 09:41:41.1653 AlertProcessor ProcessorAlertData: started 2025-12-29 09:41:46.7591 AlertProcessor ProcessorAlertData: Stopped 2025-12-29 09:46:41.1830 AlertProcessor ProcessorAlertData: started 2025-12-29 09:46:46.7924 AlertProcessor ProcessorAlertData: Stopped 2025-12-29 09:51:41.1539 DFramework.Database.Query /* Time Taken: 517*/ [dbo].GenerateSystemAlerts 2025-12-29 09:51:41.2007 AlertProcessor ProcessorAlertData: started 2025-12-29 09:51:46.8570 AlertProcessor ProcessorAlertData: Stopped 2025-12-29 09:51:56.2633 DFramework.Scheduler.TaskBase /* Time Taken: 15812.6114*/ Opportunity Out Of Stock By Outlet 2025-12-29 09:56:41.2185 AlertProcessor ProcessorAlertData: started 2025-12-29 09:56:46.9217 AlertProcessor ProcessorAlertData: Stopped 2025-12-29 10:01:41.2363 AlertProcessor ProcessorAlertData: started 2025-12-29 10:01:46.9238 AlertProcessor ProcessorAlertData: Stopped 2025-12-29 10:06:41.2541 AlertProcessor ProcessorAlertData: started 2025-12-29 10:06:41.5041 DFramework.Database.Query /* Time Taken: 858*/ [dbo].GenerateSystemAlerts 2025-12-29 10:06:47.0354 AlertProcessor ProcessorAlertData: Stopped 2025-12-29 10:06:56.4417 DFramework.Scheduler.TaskBase /* Time Taken: 15968.8617*/ Opportunity Out Of Stock By Outlet 2025-12-29 10:11:41.2719 AlertProcessor ProcessorAlertData: started 2025-12-29 10:11:44.3344 DFramework.Database.Query /* Time Taken: 516*/ DECLARE @TableName AnsiString(8000) SET @TableName = 'AssetStockProductWiseConsolidate' DECLARE @CurrentRecordId Int32 SET @CurrentRecordId = '3675322' dbo.GetValidDeviceForAlertProcessData 2025-12-29 10:11:46.9594 AlertProcessor ProcessorAlertData: Stopped 2025-12-29 10:16:41.2897 AlertProcessor ProcessorAlertData: started 2025-12-29 10:16:44.8053 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-29 10:16:47.0397 AlertProcessor ProcessorAlertData: Stopped 2025-12-29 10:21:41.2918 AlertProcessor ProcessorAlertData: started 2025-12-29 10:21:46.9012 AlertProcessor ProcessorAlertData: Stopped 2025-12-29 10:21:56.2138 DFramework.Scheduler.TaskBase /* Time Taken: 15718.866*/ Opportunity Out Of Stock By Outlet 2025-12-29 10:26:41.2940 AlertProcessor ProcessorAlertData: started 2025-12-29 10:26:46.8878 AlertProcessor ProcessorAlertData: Stopped 2025-12-29 10:31:41.2961 AlertProcessor ProcessorAlertData: started 2025-12-29 10:31:42.4993 DFramework.Database.Query /* Time Taken: 524*/ DECLARE @TableName AnsiString(8000) SET @TableName = 'MissingShelf' DECLARE @CurrentRecordId Int32 SET @CurrentRecordId = '3675322' dbo.GetValidDeviceForAlertProcessData 2025-12-29 10:31:46.9680 AlertProcessor ProcessorAlertData: Stopped 2025-12-29 10:36:41.2670 DFramework.Database.Query /* Time Taken: 560*/ [dbo].GenerateSystemAlerts 2025-12-29 10:36:41.2983 AlertProcessor ProcessorAlertData: started 2025-12-29 10:36:46.9077 AlertProcessor ProcessorAlertData: Stopped 2025-12-29 10:36:56.2828 DFramework.Scheduler.TaskBase /* Time Taken: 15765.737*/ Opportunity Out Of Stock By Outlet 2025-12-29 10:41:41.3004 AlertProcessor ProcessorAlertData: started 2025-12-29 10:41:46.9255 AlertProcessor ProcessorAlertData: Stopped 2025-12-29 10:46:41.3182 AlertProcessor ProcessorAlertData: started 2025-12-29 10:46:47.1151 DFramework.Database.Query /* Time Taken: 510*/ DECLARE @TableName AnsiString(8000) SET @TableName = 'ProductStockLevel' DECLARE @CurrentRecordId Int32 SET @CurrentRecordId = '3675322' dbo.GetValidDeviceForAlertProcessData 2025-12-29 10:46:47.1777 AlertProcessor ProcessorAlertData: Stopped 2025-12-29 10:51:41.3360 AlertProcessor ProcessorAlertData: started 2025-12-29 10:51:46.9298 AlertProcessor ProcessorAlertData: Stopped 2025-12-29 10:51:56.2580 DFramework.Scheduler.TaskBase /* Time Taken: 15718.8625*/ Opportunity Out Of Stock By Outlet 2025-12-29 10:56:41.3538 AlertProcessor ProcessorAlertData: started 2025-12-29 10:56:46.9476 AlertProcessor ProcessorAlertData: Stopped 2025-12-29 11:01:41.3716 AlertProcessor ProcessorAlertData: started 2025-12-29 11:01:47.0591 AlertProcessor ProcessorAlertData: Stopped 2025-12-29 11:06:41.2800 DFramework.Database.Query /* Time Taken: 532*/ [dbo].GenerateSystemAlerts 2025-12-29 11:06:41.3894 AlertProcessor ProcessorAlertData: started 2025-12-29 11:06:47.0300 AlertProcessor ProcessorAlertData: Stopped 2025-12-29 11:06:56.3270 DFramework.Scheduler.TaskBase /* Time Taken: 15765.7387*/ Opportunity Out Of Stock By Outlet 2025-12-29 11:11:41.4069 AlertProcessor ProcessorAlertData: started 2025-12-29 11:11:44.4694 DFramework.Database.Query /* Time Taken: 502*/ DECLARE @TableName AnsiString(8000) SET @TableName = 'AssetStockProductWiseConsolidate' DECLARE @CurrentRecordId Int32 SET @CurrentRecordId = '3675322' dbo.GetValidDeviceForAlertProcessData 2025-12-29 11:11:47.0319 AlertProcessor ProcessorAlertData: Stopped 2025-12-29 11:16:41.4246 AlertProcessor ProcessorAlertData: started 2025-12-29 11:16:47.0652 AlertProcessor ProcessorAlertData: Stopped 2025-12-29 11:21:41.4423 AlertProcessor ProcessorAlertData: started 2025-12-29 11:21:47.0674 AlertProcessor ProcessorAlertData: Stopped 2025-12-29 11:21:56.3331 DFramework.Scheduler.TaskBase /* Time Taken: 15765.7349*/ Opportunity Out Of Stock By Outlet 2025-12-29 11:26:41.4600 AlertProcessor ProcessorAlertData: started 2025-12-29 11:26:47.2569 AlertProcessor ProcessorAlertData: Stopped 2025-12-29 11:31:41.4777 AlertProcessor ProcessorAlertData: started 2025-12-29 11:31:43.4777 DFramework.Database.Query /* Time Taken: 726*/ DECLARE @TableName AnsiString(8000) SET @TableName = 'AdditionalShelf' DECLARE @CurrentRecordId Int32 SET @CurrentRecordId = '3675322' dbo.GetValidDeviceForAlertProcessData 2025-12-29 11:31:47.6340 AlertProcessor ProcessorAlertData: Stopped 2025-12-29 11:36:41.3393 DFramework.Database.Query /* Time Taken: 549*/ [dbo].GenerateSystemAlerts 2025-12-29 11:36:41.4955 AlertProcessor ProcessorAlertData: started 2025-12-29 11:36:47.1831 AlertProcessor ProcessorAlertData: Stopped 2025-12-29 11:36:56.4488 DFramework.Scheduler.TaskBase /* Time Taken: 15859.4969*/ Opportunity Out Of Stock By Outlet 2025-12-29 11:41:41.5133 AlertProcessor ProcessorAlertData: started 2025-12-29 11:41:47.2165 DFramework.Database.Query /* Time Taken: 523*/ DECLARE @TableName AnsiString(8000) SET @TableName = 'ProductStockLevel' DECLARE @CurrentRecordId Int32 SET @CurrentRecordId = '3675322' dbo.GetValidDeviceForAlertProcessData 2025-12-29 11:41:47.2634 AlertProcessor ProcessorAlertData: Stopped 2025-12-29 11:46:41.5311 AlertProcessor ProcessorAlertData: started 2025-12-29 11:46:47.1249 AlertProcessor ProcessorAlertData: Stopped 2025-12-29 11:51:41.5489 AlertProcessor ProcessorAlertData: started 2025-12-29 11:51:47.1739 AlertProcessor ProcessorAlertData: Stopped 2025-12-29 11:51:56.4084 DFramework.Scheduler.TaskBase /* Time Taken: 15796.9883*/ Opportunity Out Of Stock By Outlet 2025-12-29 11:56:41.5667 AlertProcessor ProcessorAlertData: started 2025-12-29 11:56:47.1917 AlertProcessor ProcessorAlertData: Stopped 2025-12-29 12:01:41.5845 AlertProcessor ProcessorAlertData: started 2025-12-29 12:01:47.1939 AlertProcessor ProcessorAlertData: Stopped 2025-12-29 12:06:41.3210 DFramework.Database.Query /* Time Taken: 504*/ [dbo].GenerateSystemAlerts 2025-12-29 12:06:41.5867 AlertProcessor ProcessorAlertData: started 2025-12-29 12:06:47.2117 AlertProcessor ProcessorAlertData: Stopped 2025-12-29 12:06:56.4149 DFramework.Scheduler.TaskBase /* Time Taken: 15781.3736*/ Opportunity Out Of Stock By Outlet 2025-12-29 12:11:41.6045 AlertProcessor ProcessorAlertData: started 2025-12-29 12:11:47.1826 AlertProcessor ProcessorAlertData: Stopped 2025-12-29 12:16:41.6222 AlertProcessor ProcessorAlertData: started 2025-12-29 12:16:47.2473 AlertProcessor ProcessorAlertData: Stopped 2025-12-29 12:21:41.6400 AlertProcessor ProcessorAlertData: started 2025-12-29 12:21:47.2494 AlertProcessor ProcessorAlertData: Stopped 2025-12-29 12:21:56.3745 DFramework.Scheduler.TaskBase /* Time Taken: 15718.8581*/ Opportunity Out Of Stock By Outlet 2025-12-29 12:26:41.6578 AlertProcessor ProcessorAlertData: started 2025-12-29 12:26:47.3453 AlertProcessor ProcessorAlertData: Stopped 2025-12-29 12:31:41.6756 AlertProcessor ProcessorAlertData: started 2025-12-29 12:31:47.4725 DFramework.Database.NullableDataReader Data reader open for 282 at System.Environment.GetStackTrace(Exception e, Boolean needFileInfo) at System.Environment.get_StackTrace() at DFramework.Database.NullableDataReader.Dispose(Boolean disposing) in D:\Spraxa\Framework\DFramework\Database\NullableDataReader.cs:line 33 at DFramework.Database.NullableDataReader.Dispose() in D:\Spraxa\Framework\DFramework\Database\NullableDataReader.cs:line 44 at CoolR.Tasks.ProcessAlertData.Execute() in D:\Spraxa\CoolR-Group\portal\CoolR.Tasks\ProcessAlertData.cs:line 47 at DFramework.Scheduler.TaskBase.Run() in D:\Spraxa\Framework\DFramework.Scheduler\TaskBase.cs:line 176 at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx) at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx) at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state) at System.Threading.ThreadHelper.ThreadStart() 2025-12-29 12:31:47.4725 AlertProcessor ProcessorAlertData: Stopped 2025-12-29 12:36:41.3966 DFramework.Database.Query /* Time Taken: 551*/ [dbo].GenerateSystemAlerts 2025-12-29 12:36:41.6935 AlertProcessor ProcessorAlertData: started 2025-12-29 12:36:47.2560 AlertProcessor ProcessorAlertData: Stopped 2025-12-29 12:36:56.4904 DFramework.Scheduler.TaskBase /* Time Taken: 15812.6189*/ Opportunity Out Of Stock By Outlet 2025-12-29 12:41:41.6957 AlertProcessor ProcessorAlertData: started 2025-12-29 12:41:47.2426 AlertProcessor ProcessorAlertData: Stopped 2025-12-29 12:46:41.7135 AlertProcessor ProcessorAlertData: started 2025-12-29 12:46:47.3541 AlertProcessor ProcessorAlertData: Stopped 2025-12-29 12:51:41.7313 AlertProcessor ProcessorAlertData: started 2025-12-29 12:51:45.8719 DFramework.Database.NullableDataReader Data reader open for 283 at System.Environment.GetStackTrace(Exception e, Boolean needFileInfo) at System.Environment.get_StackTrace() at DFramework.Database.NullableDataReader.Dispose(Boolean disposing) in D:\Spraxa\Framework\DFramework\Database\NullableDataReader.cs:line 33 at DFramework.Database.NullableDataReader.Dispose() in D:\Spraxa\Framework\DFramework\Database\NullableDataReader.cs:line 44 at CoolR.Tasks.ProcessAlertData.Execute() in D:\Spraxa\CoolR-Group\portal\CoolR.Tasks\ProcessAlertData.cs:line 47 at DFramework.Scheduler.TaskBase.Run() in D:\Spraxa\Framework\DFramework.Scheduler\TaskBase.cs:line 176 at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx) at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx) at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state) at System.Threading.ThreadHelper.ThreadStart() 2025-12-29 12:51:47.6219 AlertProcessor ProcessorAlertData: Stopped 2025-12-29 12:51:56.4970 DFramework.Scheduler.TaskBase /* Time Taken: 15796.9899*/ Opportunity Out Of Stock By Outlet 2025-12-29 12:56:41.7334 AlertProcessor ProcessorAlertData: started 2025-12-29 12:56:47.3897 AlertProcessor ProcessorAlertData: Stopped 2025-12-29 13:01:41.7356 AlertProcessor ProcessorAlertData: started 2025-12-29 13:01:47.3762 AlertProcessor ProcessorAlertData: Stopped 2025-12-29 13:06:41.7534 AlertProcessor ProcessorAlertData: started 2025-12-29 13:06:47.3940 AlertProcessor ProcessorAlertData: Stopped 2025-12-29 13:06:56.4410 DFramework.Scheduler.TaskBase /* Time Taken: 15718.8716*/ Opportunity Out Of Stock By Outlet 2025-12-29 13:11:41.7712 AlertProcessor ProcessorAlertData: started 2025-12-29 13:11:47.4744 AlertProcessor ProcessorAlertData: Stopped 2025-12-29 13:16:41.7890 AlertProcessor ProcessorAlertData: started 2025-12-29 13:16:47.4609 AlertProcessor ProcessorAlertData: Stopped 2025-12-29 13:21:41.8068 AlertProcessor ProcessorAlertData: started 2025-12-29 13:21:47.4631 AlertProcessor ProcessorAlertData: Stopped 2025-12-29 13:21:56.5100 DFramework.Scheduler.TaskBase /* Time Taken: 15765.7349*/ Opportunity Out Of Stock By Outlet 2025-12-29 13:26:41.8245 AlertProcessor ProcessorAlertData: started 2025-12-29 13:26:47.4027 AlertProcessor ProcessorAlertData: Stopped 2025-12-29 13:31:41.8423 AlertProcessor ProcessorAlertData: started 2025-12-29 13:31:47.6705 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-29 13:31:47.6705 AlertProcessor ProcessorAlertData: Stopped 2025-12-29 13:36:41.8601 AlertProcessor ProcessorAlertData: started 2025-12-29 13:36:47.4383 AlertProcessor ProcessorAlertData: Stopped 2025-12-29 13:36:56.5633 DFramework.Scheduler.TaskBase /* Time Taken: 15796.9884*/ Opportunity Out Of Stock By Outlet 2025-12-29 13:41:41.8779 AlertProcessor ProcessorAlertData: started 2025-12-29 13:41:47.4873 AlertProcessor ProcessorAlertData: Stopped 2025-12-29 13:46:41.8800 AlertProcessor ProcessorAlertData: started 2025-12-29 13:46:47.5207 AlertProcessor ProcessorAlertData: Stopped 2025-12-29 13:51:41.8822 AlertProcessor ProcessorAlertData: started 2025-12-29 13:51:47.4760 AlertProcessor ProcessorAlertData: Stopped 2025-12-29 13:51:56.6010 DFramework.Scheduler.TaskBase /* Time Taken: 15812.6146*/ Opportunity Out Of Stock By Outlet 2025-12-29 13:56:41.8999 AlertProcessor ProcessorAlertData: started 2025-12-29 13:56:43.7593 DFramework.Database.Query /* Time Taken: 699*/ DECLARE @TableName AnsiString(8000) SET @TableName = 'AdditionalShelf' DECLARE @CurrentRecordId Int32 SET @CurrentRecordId = '3675322' dbo.GetValidDeviceForAlertProcessData 2025-12-29 13:56:47.7281 AlertProcessor ProcessorAlertData: Stopped 2025-12-29 14:01:41.9176 AlertProcessor ProcessorAlertData: started 2025-12-29 14:01:47.6208 AlertProcessor ProcessorAlertData: Stopped 2025-12-29 14:06:41.4823 DFramework.Database.Query /* Time Taken: 515*/ [dbo].GenerateSystemAlerts 2025-12-29 14:06:41.9354 AlertProcessor ProcessorAlertData: started 2025-12-29 14:06:47.5136 AlertProcessor ProcessorAlertData: Stopped 2025-12-29 14:06:56.5292 DFramework.Scheduler.TaskBase /* Time Taken: 15718.8621*/ Opportunity Out Of Stock By Outlet 2025-12-29 14:11:41.9532 AlertProcessor ProcessorAlertData: started 2025-12-29 14:11:47.5939 AlertProcessor ProcessorAlertData: Stopped 2025-12-29 14:16:41.9709 AlertProcessor ProcessorAlertData: started 2025-12-29 14:16:47.6115 AlertProcessor ProcessorAlertData: Stopped 2025-12-29 14:21:41.4885 DFramework.Database.Query /* Time Taken: 511*/ [dbo].GenerateSystemAlerts 2025-12-29 14:21:41.9885 AlertProcessor ProcessorAlertData: started 2025-12-29 14:21:47.7230 AlertProcessor ProcessorAlertData: Stopped 2025-12-29 14:21:56.6605 DFramework.Scheduler.TaskBase /* Time Taken: 15828.2339*/ Opportunity Out Of Stock By Outlet 2025-12-29 14:26:42.0063 AlertProcessor ProcessorAlertData: started 2025-12-29 14:26:47.5689 AlertProcessor ProcessorAlertData: Stopped 2025-12-29 14:31:42.0241 AlertProcessor ProcessorAlertData: started 2025-12-29 14:31:47.6023 AlertProcessor ProcessorAlertData: Stopped 2025-12-29 14:36:41.5729 DFramework.Database.Query /* Time Taken: 588*/ [dbo].GenerateSystemAlerts 2025-12-29 14:36:42.0416 AlertProcessor ProcessorAlertData: started 2025-12-29 14:36:47.6198 AlertProcessor ProcessorAlertData: Stopped 2025-12-29 14:36:56.6355 DFramework.Scheduler.TaskBase /* Time Taken: 15781.3569*/ Opportunity Out Of Stock By Outlet 2025-12-29 14:41:42.0593 AlertProcessor ProcessorAlertData: started 2025-12-29 14:41:47.7937 AlertProcessor ProcessorAlertData: Stopped 2025-12-29 14:46:42.0771 AlertProcessor ProcessorAlertData: started 2025-12-29 14:46:45.1865 DFramework.Database.Query /* Time Taken: 533*/ DECLARE @TableName AnsiString(8000) SET @TableName = 'AssetStockProductWiseConsolidate' DECLARE @CurrentRecordId Int32 SET @CurrentRecordId = '3675322' dbo.GetValidDeviceForAlertProcessData 2025-12-29 14:46:47.7959 AlertProcessor ProcessorAlertData: Stopped 2025-12-29 14:51:42.0793 AlertProcessor ProcessorAlertData: started 2025-12-29 14:51:47.8450 AlertProcessor ProcessorAlertData: Stopped 2025-12-29 14:51:56.5951 DFramework.Scheduler.TaskBase /* Time Taken: 15718.87*/ Opportunity Out Of Stock By Outlet 2025-12-29 14:56:42.0971 AlertProcessor ProcessorAlertData: started 2025-12-29 14:56:47.7378 AlertProcessor ProcessorAlertData: Stopped 2025-12-29 15:01:42.0993 AlertProcessor ProcessorAlertData: started 2025-12-29 15:01:45.2087 DFramework.Database.Query /* Time Taken: 557*/ DECLARE @TableName AnsiString(8000) SET @TableName = 'AssetStockProductWiseConsolidate' DECLARE @CurrentRecordId Int32 SET @CurrentRecordId = '3675322' dbo.GetValidDeviceForAlertProcessData 2025-12-29 15:01:47.7869 AlertProcessor ProcessorAlertData: Stopped 2025-12-29 15:06:41.5546 DFramework.Database.Query /* Time Taken: 528*/ [dbo].GenerateSystemAlerts 2025-12-29 15:06:42.1171 AlertProcessor ProcessorAlertData: started 2025-12-29 15:06:47.8359 AlertProcessor ProcessorAlertData: Stopped 2025-12-29 15:06:56.6797 DFramework.Scheduler.TaskBase /* Time Taken: 15781.3642*/ Opportunity Out Of Stock By Outlet 2025-12-29 15:11:42.1350 AlertProcessor ProcessorAlertData: started 2025-12-29 15:11:47.6819 AlertProcessor ProcessorAlertData: Stopped 2025-12-29 15:16:42.1528 AlertProcessor ProcessorAlertData: started 2025-12-29 15:16:45.1528 DFramework.Database.Query /* Time Taken: 502*/ DECLARE @TableName AnsiString(8000) SET @TableName = 'AssetStockProductWiseConsolidate' DECLARE @CurrentRecordId Int32 SET @CurrentRecordId = '3675322' dbo.GetValidDeviceForAlertProcessData 2025-12-29 15:16:47.7153 AlertProcessor ProcessorAlertData: Stopped 2025-12-29 15:21:42.1706 AlertProcessor ProcessorAlertData: started 2025-12-29 15:21:47.7644 AlertProcessor ProcessorAlertData: Stopped 2025-12-29 15:21:56.6238 DFramework.Scheduler.TaskBase /* Time Taken: 15703.2396*/ Opportunity Out Of Stock By Outlet 2025-12-29 15:26:42.1728 AlertProcessor ProcessorAlertData: started 2025-12-29 15:26:47.7666 AlertProcessor ProcessorAlertData: Stopped 2025-12-29 15:31:42.1906 AlertProcessor ProcessorAlertData: started 2025-12-29 15:31:47.8938 AlertProcessor ProcessorAlertData: Stopped 2025-12-29 15:36:41.6303 DFramework.Database.Query /* Time Taken: 548*/ [dbo].GenerateSystemAlerts 2025-12-29 15:36:42.2084 AlertProcessor ProcessorAlertData: started 2025-12-29 15:36:43.9272 DFramework.Database.Query /* Time Taken: 541*/ DECLARE @TableName AnsiString(8000) SET @TableName = 'AdditionalShelf' DECLARE @CurrentRecordId Int32 SET @CurrentRecordId = '3675322' dbo.GetValidDeviceForAlertProcessData 2025-12-29 15:36:47.8803 AlertProcessor ProcessorAlertData: Stopped 2025-12-29 15:36:56.6929 DFramework.Scheduler.TaskBase /* Time Taken: 15765.7374*/ Opportunity Out Of Stock By Outlet 2025-12-29 15:41:42.2263 AlertProcessor ProcessorAlertData: started 2025-12-29 15:41:47.8514 AlertProcessor ProcessorAlertData: Stopped 2025-12-29 15:46:42.2443 AlertProcessor ProcessorAlertData: started 2025-12-29 15:46:47.8537 AlertProcessor ProcessorAlertData: Stopped 2025-12-29 15:51:42.2621 AlertProcessor ProcessorAlertData: started 2025-12-29 15:51:47.8403 AlertProcessor ProcessorAlertData: Stopped 2025-12-29 15:51:56.6841 DFramework.Scheduler.TaskBase /* Time Taken: 15750.1168*/ Opportunity Out Of Stock By Outlet 2025-12-29 15:56:42.2799 AlertProcessor ProcessorAlertData: started 2025-12-29 15:56:47.9362 AlertProcessor ProcessorAlertData: Stopped 2025-12-29 16:01:42.2978 AlertProcessor ProcessorAlertData: started 2025-12-29 16:01:48.0010 AlertProcessor ProcessorAlertData: Stopped 2025-12-29 16:06:41.6437 DFramework.Database.Query /* Time Taken: 524*/ [dbo].GenerateSystemAlerts 2025-12-29 16:06:42.3156 AlertProcessor ProcessorAlertData: started 2025-12-29 16:06:47.9250 AlertProcessor ProcessorAlertData: Stopped 2025-12-29 16:06:56.7689 DFramework.Scheduler.TaskBase /* Time Taken: 15812.6243*/ Opportunity Out Of Stock By Outlet 2025-12-29 16:11:42.3178 AlertProcessor ProcessorAlertData: started 2025-12-29 16:11:47.9116 AlertProcessor ProcessorAlertData: Stopped 2025-12-29 16:16:42.3358 AlertProcessor ProcessorAlertData: started 2025-12-29 16:16:47.9764 AlertProcessor ProcessorAlertData: Stopped 2025-12-29 16:21:42.3381 AlertProcessor ProcessorAlertData: started 2025-12-29 16:21:48.0100 AlertProcessor ProcessorAlertData: Stopped 2025-12-29 16:21:56.7132 DFramework.Scheduler.TaskBase /* Time Taken: 15750.1118*/ Opportunity Out Of Stock By Outlet 2025-12-29 16:26:42.3559 AlertProcessor ProcessorAlertData: started 2025-12-29 16:26:44.2621 DFramework.Database.Query /* Time Taken: 681*/ DECLARE @TableName AnsiString(8000) SET @TableName = 'AdditionalShelf' DECLARE @CurrentRecordId Int32 SET @CurrentRecordId = '3675322' dbo.GetValidDeviceForAlertProcessData 2025-12-29 16:26:48.3715 AlertProcessor ProcessorAlertData: Stopped 2025-12-29 16:31:42.3737 AlertProcessor ProcessorAlertData: started 2025-12-29 16:31:48.0769 AlertProcessor ProcessorAlertData: Stopped 2025-12-29 16:36:41.6729 DFramework.Database.Query /* Time Taken: 514*/ [dbo].GenerateSystemAlerts 2025-12-29 16:36:42.3761 AlertProcessor ProcessorAlertData: started 2025-12-29 16:36:47.7355 DFramework.Database.NullableDataReader Data reader open for 276 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-29 16:36:48.2511 AlertProcessor ProcessorAlertData: Stopped 2025-12-29 16:36:56.7356 DFramework.Scheduler.TaskBase /* Time Taken: 15750.1164*/ Opportunity Out Of Stock By Outlet 2025-12-29 16:41:42.3783 AlertProcessor ProcessorAlertData: started 2025-12-29 16:41:47.9096 AlertProcessor ProcessorAlertData: Stopped 2025-12-29 16:46:42.3805 AlertProcessor ProcessorAlertData: started 2025-12-29 16:46:45.6774 DFramework.Database.Query /* Time Taken: 734*/ DECLARE @TableName AnsiString(8000) SET @TableName = 'AssetStockProductWiseConsolidate' DECLARE @CurrentRecordId Int32 SET @CurrentRecordId = '3675322' dbo.GetValidDeviceForAlertProcessData 2025-12-29 16:46:48.2555 AlertProcessor ProcessorAlertData: Stopped 2025-12-29 16:51:42.3984 AlertProcessor ProcessorAlertData: started 2025-12-29 16:51:45.4609 DFramework.Database.Query /* Time Taken: 509*/ DECLARE @TableName AnsiString(8000) SET @TableName = 'AssetStockProductWiseConsolidate' DECLARE @CurrentRecordId Int32 SET @CurrentRecordId = '3675322' dbo.GetValidDeviceForAlertProcessData 2025-12-29 16:51:48.0078 AlertProcessor ProcessorAlertData: Stopped 2025-12-29 16:51:56.7266 DFramework.Scheduler.TaskBase /* Time Taken: 15718.8696*/ Opportunity Out Of Stock By Outlet 2025-12-29 16:56:42.4162 AlertProcessor ProcessorAlertData: started 2025-12-29 16:56:48.0569 AlertProcessor ProcessorAlertData: Stopped 2025-12-29 17:01:42.4340 AlertProcessor ProcessorAlertData: started 2025-12-29 17:01:47.9809 AlertProcessor ProcessorAlertData: Stopped 2025-12-29 17:06:42.4519 AlertProcessor ProcessorAlertData: started 2025-12-29 17:06:48.2801 AlertProcessor ProcessorAlertData: Stopped 2025-12-29 17:06:56.7958 DFramework.Scheduler.TaskBase /* Time Taken: 15765.7533*/ Opportunity Out Of Stock By Outlet 2025-12-29 17:11:42.4698 AlertProcessor ProcessorAlertData: started 2025-12-29 17:11:43.7042 DFramework.Database.Query /* Time Taken: 536*/ DECLARE @TableName AnsiString(8000) SET @TableName = 'MissingShelf' DECLARE @CurrentRecordId Int32 SET @CurrentRecordId = '3675322' dbo.GetValidDeviceForAlertProcessData 2025-12-29 17:11:48.1418 AlertProcessor ProcessorAlertData: Stopped 2025-12-29 17:16:42.4876 AlertProcessor ProcessorAlertData: started 2025-12-29 17:16:48.1439 AlertProcessor ProcessorAlertData: Stopped 2025-12-29 17:21:42.5054 AlertProcessor ProcessorAlertData: started 2025-12-29 17:21:45.5523 DFramework.Database.Query /* Time Taken: 508*/ DECLARE @TableName AnsiString(8000) SET @TableName = 'AssetStockProductWiseConsolidate' DECLARE @CurrentRecordId Int32 SET @CurrentRecordId = '3675322' dbo.GetValidDeviceForAlertProcessData 2025-12-29 17:21:48.1305 AlertProcessor ProcessorAlertData: Stopped 2025-12-29 17:21:56.7556 DFramework.Scheduler.TaskBase /* Time Taken: 15703.2411*/ Opportunity Out Of Stock By Outlet 2025-12-29 17:26:42.5234 AlertProcessor ProcessorAlertData: started 2025-12-29 17:26:48.2110 AlertProcessor ProcessorAlertData: Stopped 2025-12-29 17:31:42.5413 AlertProcessor ProcessorAlertData: started 2025-12-29 17:31:48.3851 AlertProcessor ProcessorAlertData: Stopped 2025-12-29 17:36:42.5435 AlertProcessor ProcessorAlertData: started 2025-12-29 17:36:48.1060 AlertProcessor ProcessorAlertData: Stopped 2025-12-29 17:36:56.8717 DFramework.Scheduler.TaskBase /* Time Taken: 15796.9892*/ Opportunity Out Of Stock By Outlet 2025-12-29 17:41:42.5614 AlertProcessor ProcessorAlertData: started 2025-12-29 17:41:48.0614 AlertProcessor ProcessorAlertData: Stopped 2025-12-29 17:46:42.5793 AlertProcessor ProcessorAlertData: started 2025-12-29 17:46:48.1105 AlertProcessor ProcessorAlertData: Stopped 2025-12-29 17:51:42.5971 AlertProcessor ProcessorAlertData: started 2025-12-29 17:51:48.1596 AlertProcessor ProcessorAlertData: Stopped 2025-12-29 17:51:56.8159 DFramework.Scheduler.TaskBase /* Time Taken: 15718.8553*/ Opportunity Out Of Stock By Outlet 2025-12-29 17:56:42.6149 AlertProcessor ProcessorAlertData: started 2025-12-29 17:56:48.1462 AlertProcessor ProcessorAlertData: Stopped 2025-12-29 18:01:42.6329 AlertProcessor ProcessorAlertData: started 2025-12-29 18:01:48.2423 AlertProcessor ProcessorAlertData: Stopped 2025-12-29 18:06:42.2133 DFramework.Database.Query /* Time Taken: 921*/ [dbo].GenerateSystemAlerts 2025-12-29 18:06:42.6508 AlertProcessor ProcessorAlertData: started 2025-12-29 18:06:48.2133 AlertProcessor ProcessorAlertData: Stopped 2025-12-29 18:06:57.1978 DFramework.Scheduler.TaskBase /* Time Taken: 16078.2584*/ Opportunity Out Of Stock By Outlet 2025-12-29 18:11:42.6686 AlertProcessor ProcessorAlertData: started 2025-12-29 18:11:48.2311 AlertProcessor ProcessorAlertData: Stopped 2025-12-29 18:16:42.6864 AlertProcessor ProcessorAlertData: started 2025-12-29 18:16:48.3270 AlertProcessor ProcessorAlertData: Stopped 2025-12-29 18:21:42.6885 AlertProcessor ProcessorAlertData: started 2025-12-29 18:21:48.2667 AlertProcessor ProcessorAlertData: Stopped 2025-12-29 18:21:56.9387 DFramework.Scheduler.TaskBase /* Time Taken: 15797.0128*/ Opportunity Out Of Stock By Outlet 2025-12-29 18:26:40.7064 DFramework.Database.Query /* Time Taken: 589*/ 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-29 18:26:40.7064 DFramework.Database.Query /* Time Taken: 590*/ 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-29 18:26:42.0657 DFramework.Database.Query /* Time Taken: 592*/ 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/30/2025 2:26:41 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-29 18:26:42.6907 AlertProcessor ProcessorAlertData: started 2025-12-29 18:26:43.6282 DFramework.Database.Query /* Time Taken: 542*/ 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-29 18:26:46.6907 DFramework.Database.Query /* Time Taken: 1557*/ 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-29 18:26:52.5970 DFramework.Database.Query /* Time Taken: 9616*/ DECLARE @TableName AnsiString(8000) SET @TableName = 'TagAlert' DECLARE @ClientId Int32 SET @ClientId = '0' DECLARE @Table AnsiString(8000) SET @Table = 'TagAlert' DECLARE @PrimaryKey Int32 SET @PrimaryKey = '3675322' UPDATE dbo.AlertProcessor SET ClientId = @ClientId, TableName = @Table, PrimaryKey = @PrimaryKey WHERE [TableName] = @TableName AND (ClientId <> @ClientId OR TableName <> @Table OR PrimaryKey <> @PrimaryKey) 2025-12-29 18:26:52.5970 DFramework.Database.NullableDataReader Data reader open for 9646 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-29 18:26:57.8783 AlertProcessor ProcessorAlertData: Stopped 2025-12-29 18:26:57.8783 DFramework.Scheduler.TaskBase /* Time Taken: 15187.6124*/ Process Alert Record 2025-12-29 18:31:42.7085 AlertProcessor ProcessorAlertData: started 2025-12-29 18:31:48.3179 AlertProcessor ProcessorAlertData: Stopped 2025-12-29 18:36:41.8669 MoveToReorder Running task for ClientId : 286 and ClientName = India Office QA and Slot: 12/30/2025 8:00:00 AM And LastExecutedOn: 12/29/2025 10:06:40 PM 2025-12-29 18:36:41.8825 DFramework.Database.Query /* Time Taken: 534*/ [dbo].GenerateSystemAlerts 2025-12-29 18:36:42.7263 AlertProcessor ProcessorAlertData: started 2025-12-29 18:36:43.7263 DFramework.Database.Query /* Time Taken: 613*/ 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-29 18:36:43.8357 DFramework.Database.Query /* Time Taken: 1109*/ DECLARE @TableName AnsiString(8000) SET @TableName = 'TagAlert' DECLARE @CurrentRecordId Int32 SET @CurrentRecordId = '0' dbo.GetValidDeviceForAlertProcessData 2025-12-29 18:36:50.4763 DFramework.Database.Query /* Time Taken: 1758*/ DECLARE @TableName AnsiString(8000) SET @TableName = 'ProductStockLevel' DECLARE @CurrentRecordId Int32 SET @CurrentRecordId = '3675322' dbo.GetValidDeviceForAlertProcessData 2025-12-29 18:36:50.5232 AlertProcessor ProcessorAlertData: Stopped 2025-12-29 18:36:56.9451 DFramework.Scheduler.TaskBase /* Time Taken: 15781.3637*/ Opportunity Out Of Stock By Outlet 2025-12-29 18:37:23.8203 DFramework.Database.NullableDataReader Data reader open for 41426 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-29 18:37:23.8516 MoveToReorder Task executed successfully for ClientId : 286 Client Name:India Office QA, Slot: 12/30/2025 8:00:00 AM and Total Order Suggested: 127 Out Of: 127 2025-12-29 18:37:25.2735 DFramework.Scheduler.TaskBase /* Time Taken: 43797.2035*/ Move To Re-Order 2025-12-29 18:41:42.7284 AlertProcessor ProcessorAlertData: started 2025-12-29 18:41:48.3222 AlertProcessor ProcessorAlertData: Stopped 2025-12-29 18:46:42.7306 AlertProcessor ProcessorAlertData: started 2025-12-29 18:46:48.3088 AlertProcessor ProcessorAlertData: Stopped 2025-12-29 18:51:42.7328 AlertProcessor ProcessorAlertData: started 2025-12-29 18:51:48.3578 AlertProcessor ProcessorAlertData: Stopped 2025-12-29 18:51:56.9829 DFramework.Scheduler.TaskBase /* Time Taken: 15796.9918*/ Opportunity Out Of Stock By Outlet 2025-12-29 18:56:42.7506 AlertProcessor ProcessorAlertData: started 2025-12-29 18:56:48.4225 AlertProcessor ProcessorAlertData: Stopped 2025-12-29 19:01:42.7684 AlertProcessor ProcessorAlertData: started 2025-12-29 19:01:48.3778 AlertProcessor ProcessorAlertData: Stopped 2025-12-29 19:06:41.9737 DFramework.Database.Query /* Time Taken: 579*/ [dbo].GenerateSystemAlerts 2025-12-29 19:06:42.7705 AlertProcessor ProcessorAlertData: started 2025-12-29 19:06:48.3487 AlertProcessor ProcessorAlertData: Stopped 2025-12-29 19:06:56.9269 DFramework.Scheduler.TaskBase /* Time Taken: 15718.8669*/ Opportunity Out Of Stock By Outlet 2025-12-29 19:11:42.7883 AlertProcessor ProcessorAlertData: started 2025-12-29 19:11:48.3352 AlertProcessor ProcessorAlertData: Stopped 2025-12-29 19:16:42.8061 AlertProcessor ProcessorAlertData: started 2025-12-29 19:16:48.4781 AlertProcessor ProcessorAlertData: Stopped 2025-12-29 19:21:42.8239 AlertProcessor ProcessorAlertData: started 2025-12-29 19:21:48.4177 AlertProcessor ProcessorAlertData: Stopped 2025-12-29 19:21:56.9490 DFramework.Scheduler.TaskBase /* Time Taken: 15718.8621*/ Opportunity Out Of Stock By Outlet 2025-12-29 19:26:42.8261 AlertProcessor ProcessorAlertData: started 2025-12-29 19:26:48.6074 AlertProcessor ProcessorAlertData: Stopped 2025-12-29 19:31:42.8439 AlertProcessor ProcessorAlertData: started 2025-12-29 19:31:48.4534 AlertProcessor ProcessorAlertData: Stopped 2025-12-29 19:36:42.0024 DFramework.Database.Query /* Time Taken: 583*/ [dbo].GenerateSystemAlerts 2025-12-29 19:36:42.0649 MoveToReorder Running task for ClientId : 286 and ClientName = India Office QA and Slot: 12/30/2025 9:00:00 AM And LastExecutedOn: 12/30/2025 8:06:41 AM 2025-12-29 19:36:42.2836 MoveToReorder Task executed successfully for ClientId : 286 Client Name:India Office QA, Slot: 12/30/2025 9:00:00 AM But No Order found to suggest 2025-12-29 19:36:42.8617 AlertProcessor ProcessorAlertData: started 2025-12-29 19:36:46.0805 DFramework.Database.Query /* Time Taken: 685*/ DECLARE @TableName AnsiString(8000) SET @TableName = 'AssetStockProductWiseConsolidate' DECLARE @CurrentRecordId Int32 SET @CurrentRecordId = '3675322' dbo.GetValidDeviceForAlertProcessData 2025-12-29 19:36:48.7524 AlertProcessor ProcessorAlertData: Stopped 2025-12-29 19:36:57.0025 DFramework.Scheduler.TaskBase /* Time Taken: 15750.116*/ Opportunity Out Of Stock By Outlet 2025-12-29 19:41:42.8796 AlertProcessor ProcessorAlertData: started 2025-12-29 19:41:48.5671 AlertProcessor ProcessorAlertData: Stopped 2025-12-29 19:46:42.8974 AlertProcessor ProcessorAlertData: started 2025-12-29 19:46:48.5068 AlertProcessor ProcessorAlertData: Stopped 2025-12-29 19:51:41.9308 DFramework.Database.Query /* Time Taken: 511*/ [dbo].GenerateSystemAlerts 2025-12-29 19:51:42.9152 AlertProcessor ProcessorAlertData: started 2025-12-29 19:51:44.1496 DFramework.Database.Query /* Time Taken: 522*/ DECLARE @TableName AnsiString(8000) SET @TableName = 'MissingShelf' DECLARE @CurrentRecordId Int32 SET @CurrentRecordId = '3675322' dbo.GetValidDeviceForAlertProcessData 2025-12-29 19:51:48.6027 AlertProcessor ProcessorAlertData: Stopped 2025-12-29 19:51:57.0247 DFramework.Scheduler.TaskBase /* Time Taken: 15750.1232*/ Opportunity Out Of Stock By Outlet 2025-12-29 19:56:42.9330 AlertProcessor ProcessorAlertData: started 2025-12-29 19:56:48.5893 AlertProcessor ProcessorAlertData: Stopped 2025-12-29 20:01:42.9508 AlertProcessor ProcessorAlertData: started 2025-12-29 20:01:46.0289 DFramework.Database.Query /* Time Taken: 526*/ DECLARE @TableName AnsiString(8000) SET @TableName = 'AssetStockProductWiseConsolidate' DECLARE @CurrentRecordId Int32 SET @CurrentRecordId = '3675322' dbo.GetValidDeviceForAlertProcessData 2025-12-29 20:01:48.7633 AlertProcessor ProcessorAlertData: Stopped 2025-12-29 20:06:42.0311 DFramework.Database.Query /* Time Taken: 589*/ [dbo].GenerateSystemAlerts 2025-12-29 20:06:42.9685 AlertProcessor ProcessorAlertData: started 2025-12-29 20:06:48.5468 AlertProcessor ProcessorAlertData: Stopped 2025-12-29 20:06:57.0155 DFramework.Scheduler.TaskBase /* Time Taken: 15718.8604*/ Opportunity Out Of Stock By Outlet 2025-12-29 20:11:42.9707 AlertProcessor ProcessorAlertData: started 2025-12-29 20:11:48.5020 AlertProcessor ProcessorAlertData: Stopped 2025-12-29 20:16:42.9886 AlertProcessor ProcessorAlertData: started 2025-12-29 20:16:48.6605 AlertProcessor ProcessorAlertData: Stopped 2025-12-29 20:21:41.9751 DFramework.Database.Query /* Time Taken: 501*/ [dbo].GenerateSystemAlerts 2025-12-29 20:21:43.0064 AlertProcessor ProcessorAlertData: started 2025-12-29 20:21:48.5377 AlertProcessor ProcessorAlertData: Stopped 2025-12-29 20:21:57.0690 DFramework.Scheduler.TaskBase /* Time Taken: 15765.7322*/ Opportunity Out Of Stock By Outlet 2025-12-29 20:26:43.0242 AlertProcessor ProcessorAlertData: started 2025-12-29 20:26:48.6961 AlertProcessor ProcessorAlertData: Stopped 2025-12-29 20:31:43.0421 AlertProcessor ProcessorAlertData: started 2025-12-29 20:31:44.1046 DFramework.Database.Query /* Time Taken: 588*/ DECLARE AlertTypeIds Object SET AlertTypeIds = 'DFramework.Database.Adapters.SQL+d__24' [dbo].GetAlertSummaryData 2025-12-29 20:31:47.0265 DFramework.Database.Query /* Time Taken: 2917*/ DECLARE @AlertTypeIds AnsiString(8000) SET @AlertTypeIds = '42,31,44,18,58,52,64,61,46,73,59,65,69,72,60,74,68,39,51,56,32,55,38,63,77,76' DECLARE @ClientIds AnsiString(8000) SET @ClientIds = '360,213,286,1494,395,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-29 20:31:48.9640 AlertProcessor ProcessorAlertData: Stopped 2025-12-29 20:31:51.3078 DFramework.Database.Query /* Time Taken: 3862*/ 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 = '430,471,1494,286,395,349,414,360,213,70,295,320,336,338,134,188,227,114,180,183,299,300,314,316,331,332,333,415,451,207,224,291,306,308,325,342,296,301,303,305,328,335,337,385,421,469,1480,1496,1481,124,222,289,322,1476,229,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-29 20:36:42.0287 MoveToReorder Running task for ClientId : 286 and ClientName = India Office QA and Slot: 12/30/2025 10:00:00 AM And LastExecutedOn: 12/30/2025 9:06:42 AM 2025-12-29 20:36:42.0444 DFramework.Database.Query /* Time Taken: 553*/ [dbo].GenerateSystemAlerts 2025-12-29 20:36:42.6069 DFramework.Database.NullableDataReader Data reader open for 347 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-29 20:36:42.6225 MoveToReorder Task executed successfully for ClientId : 286 Client Name:India Office QA, Slot: 12/30/2025 10:00:00 AM and Total Order Suggested: 1 Out Of: 1 2025-12-29 20:36:43.0600 AlertProcessor ProcessorAlertData: started 2025-12-29 20:36:49.0600 AlertProcessor ProcessorAlertData: Stopped 2025-12-29 20:36:57.1695 DFramework.Scheduler.TaskBase /* Time Taken: 15843.8661*/ Opportunity Out Of Stock By Outlet 2025-12-29 20:41:43.0622 AlertProcessor ProcessorAlertData: started 2025-12-29 20:41:46.0935 DFramework.Database.Query /* Time Taken: 508*/ DECLARE @TableName AnsiString(8000) SET @TableName = 'AssetStockProductWiseConsolidate' DECLARE @CurrentRecordId Int32 SET @CurrentRecordId = '3675322' dbo.GetValidDeviceForAlertProcessData 2025-12-29 20:41:48.7497 AlertProcessor ProcessorAlertData: Stopped 2025-12-29 20:46:43.0643 AlertProcessor ProcessorAlertData: started 2025-12-29 20:46:46.2675 DFramework.Database.Query /* Time Taken: 585*/ DECLARE @TableName AnsiString(8000) SET @TableName = 'AssetStockProductWiseConsolidate' DECLARE @CurrentRecordId Int32 SET @CurrentRecordId = '3675322' dbo.GetValidDeviceForAlertProcessData 2025-12-29 20:46:48.8613 AlertProcessor ProcessorAlertData: Stopped 2025-12-29 20:51:43.0665 AlertProcessor ProcessorAlertData: started 2025-12-29 20:51:48.6916 AlertProcessor ProcessorAlertData: Stopped 2025-12-29 20:51:57.1135 DFramework.Scheduler.TaskBase /* Time Taken: 15765.7383*/ Opportunity Out Of Stock By Outlet 2025-12-29 20:56:43.0687 AlertProcessor ProcessorAlertData: started 2025-12-29 20:56:48.6156 AlertProcessor ProcessorAlertData: Stopped 2025-12-29 21:01:43.0709 AlertProcessor ProcessorAlertData: started 2025-12-29 21:01:48.8990 AlertProcessor ProcessorAlertData: Stopped 2025-12-29 21:06:42.0731 DFramework.Database.Query /* Time Taken: 537*/ [dbo].GenerateSystemAlerts 2025-12-29 21:06:43.0887 AlertProcessor ProcessorAlertData: started 2025-12-29 21:06:48.6825 AlertProcessor ProcessorAlertData: Stopped 2025-12-29 21:06:57.1357 DFramework.Scheduler.TaskBase /* Time Taken: 15765.7422*/ Opportunity Out Of Stock By Outlet 2025-12-29 21:11:43.1065 AlertProcessor ProcessorAlertData: started 2025-12-29 21:11:48.6065 AlertProcessor ProcessorAlertData: Stopped 2025-12-29 21:16:43.1243 AlertProcessor ProcessorAlertData: started 2025-12-29 21:16:44.2493 DFramework.Database.Query /* Time Taken: 1137*/ DECLARE @TableName AnsiString(8000) SET @TableName = 'TagAlert' DECLARE @CurrentRecordId Int32 SET @CurrentRecordId = '0' dbo.GetValidDeviceForAlertProcessData 2025-12-29 21:16:44.8743 DFramework.Database.Query /* Time Taken: 552*/ DECLARE @TableName AnsiString(8000) SET @TableName = 'VoidAlert' DECLARE @CurrentRecordId Int32 SET @CurrentRecordId = '3675322' dbo.GetValidDeviceForAlertProcessData 2025-12-29 21:16:45.6243 DFramework.Database.Query /* Time Taken: 701*/ DECLARE @TableName AnsiString(8000) SET @TableName = 'MissingShelf' DECLARE @CurrentRecordId Int32 SET @CurrentRecordId = '3675322' dbo.GetValidDeviceForAlertProcessData 2025-12-29 21:16:46.6087 DFramework.Database.Query /* Time Taken: 911*/ DECLARE @TableName AnsiString(8000) SET @TableName = 'AdditionalShelf' DECLARE @CurrentRecordId Int32 SET @CurrentRecordId = '3675322' dbo.GetValidDeviceForAlertProcessData 2025-12-29 21:16:49.0931 DFramework.Database.Query /* Time Taken: 875*/ DECLARE @TableName AnsiString(8000) SET @TableName = 'AssetStockProductWiseConsolidate' DECLARE @CurrentRecordId Int32 SET @CurrentRecordId = '3675322' dbo.GetValidDeviceForAlertProcessData 2025-12-29 21:16:52.3587 AlertProcessor ProcessorAlertData: Stopped 2025-12-29 21:21:42.2046 DFramework.Database.Query /* Time Taken: 646*/ [dbo].GenerateSystemAlerts 2025-12-29 21:21:43.1265 AlertProcessor ProcessorAlertData: started 2025-12-29 21:21:44.4234 DFramework.Database.Query /* Time Taken: 604*/ DECLARE @TableName AnsiString(8000) SET @TableName = 'MissingShelf' DECLARE @CurrentRecordId Int32 SET @CurrentRecordId = '3675322' dbo.GetValidDeviceForAlertProcessData 2025-12-29 21:21:45.0015 DFramework.Database.Query /* Time Taken: 527*/ DECLARE @TableName AnsiString(8000) SET @TableName = 'AdditionalShelf' DECLARE @CurrentRecordId Int32 SET @CurrentRecordId = '3675322' dbo.GetValidDeviceForAlertProcessData 2025-12-29 21:21:48.9703 AlertProcessor ProcessorAlertData: Stopped 2025-12-29 21:21:57.3454 DFramework.Scheduler.TaskBase /* Time Taken: 15953.2658*/ Opportunity Out Of Stock By Outlet 2025-12-29 21:26:43.1445 AlertProcessor ProcessorAlertData: started 2025-12-29 21:26:48.7696 AlertProcessor ProcessorAlertData: Stopped 2025-12-29 21:31:43.1624 AlertProcessor ProcessorAlertData: started 2025-12-29 21:31:48.7249 AlertProcessor ProcessorAlertData: Stopped 2025-12-29 21:36:42.1021 DFramework.Database.Query /* Time Taken: 532*/ [dbo].GenerateSystemAlerts 2025-12-29 21:36:42.1646 MoveToReorder Running task for ClientId : 286 and ClientName = India Office QA and Slot: 12/30/2025 11:00:00 AM And LastExecutedOn: 12/30/2025 10:06:41 AM 2025-12-29 21:36:43.1802 AlertProcessor ProcessorAlertData: started 2025-12-29 21:36:46.3990 DFramework.Database.Query /* Time Taken: 700*/ DECLARE @TableName AnsiString(8000) SET @TableName = 'AssetStockProductWiseConsolidate' DECLARE @CurrentRecordId Int32 SET @CurrentRecordId = '3675322' dbo.GetValidDeviceForAlertProcessData 2025-12-29 21:36:49.0084 AlertProcessor ProcessorAlertData: Stopped 2025-12-29 21:36:57.2116 DFramework.Scheduler.TaskBase /* Time Taken: 15797.0052*/ Opportunity Out Of Stock By Outlet 2025-12-29 21:37:22.7118 DFramework.Database.NullableDataReader Data reader open for 40272 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-29 21:37:22.7430 MoveToReorder Task executed successfully for ClientId : 286 Client Name:India Office QA, Slot: 12/30/2025 11:00:00 AM and Total Order Suggested: 125 Out Of: 125 2025-12-29 21:37:23.7899 DFramework.Scheduler.TaskBase /* Time Taken: 42031.5561*/ Move To Re-Order 2025-12-29 21:41:43.1825 AlertProcessor ProcessorAlertData: started 2025-12-29 21:41:48.7606 AlertProcessor ProcessorAlertData: Stopped 2025-12-29 21:46:43.2003 AlertProcessor ProcessorAlertData: started 2025-12-29 21:46:48.9035 AlertProcessor ProcessorAlertData: Stopped 2025-12-29 21:51:43.2181 AlertProcessor ProcessorAlertData: started 2025-12-29 21:51:45.0150 DFramework.Database.Query /* Time Taken: 523*/ DECLARE @TableName AnsiString(8000) SET @TableName = 'AdditionalShelf' DECLARE @CurrentRecordId Int32 SET @CurrentRecordId = '3675322' dbo.GetValidDeviceForAlertProcessData 2025-12-29 21:51:48.9838 AlertProcessor ProcessorAlertData: Stopped 2025-12-29 21:51:57.1870 DFramework.Scheduler.TaskBase /* Time Taken: 15750.1161*/ Opportunity Out Of Stock By Outlet 2025-12-29 21:56:42.4078 DFramework.Database.Query /* Time Taken: 634*/ 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-29 21:56:43.2360 AlertProcessor ProcessorAlertData: started 2025-12-29 21:56:44.6735 DFramework.Database.Query /* Time Taken: 2264*/ 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-29 21:56:44.6891 DFramework.Database.Query /* Time Taken: 736*/ DECLARE @TableName AnsiString(8000) SET @TableName = 'MissingShelf' DECLARE @CurrentRecordId Int32 SET @CurrentRecordId = '3675322' dbo.GetValidDeviceForAlertProcessData 2025-12-29 21:56:45.2829 DFramework.Database.Query /* Time Taken: 523*/ DECLARE @TableName AnsiString(8000) SET @TableName = 'AdditionalShelf' DECLARE @CurrentRecordId Int32 SET @CurrentRecordId = '3675322' dbo.GetValidDeviceForAlertProcessData 2025-12-29 21:56:47.6579 DFramework.Database.Query /* Time Taken: 1218*/ DECLARE @TableName AnsiString(8000) SET @TableName = 'AssetStockProductWiseConsolidate' DECLARE @CurrentRecordId Int32 SET @CurrentRecordId = '3675322' dbo.GetValidDeviceForAlertProcessData 2025-12-29 21:56:48.3766 DFramework.Database.Query /* Time Taken: 658*/ DECLARE @TableName AnsiString(8000) SET @TableName = 'AssetStockProductWise' DECLARE @CurrentRecordId Int32 SET @CurrentRecordId = '3675322' dbo.GetValidDeviceForAlertProcessData 2025-12-29 21:56:49.0798 DFramework.Database.Query /* Time Taken: 654*/ DECLARE @TableName AnsiString(8000) SET @TableName = 'AssetStock' DECLARE @CurrentRecordId Int32 SET @CurrentRecordId = '3675322' dbo.GetValidDeviceForAlertProcessData 2025-12-29 21:56:49.7516 DFramework.Database.Query /* Time Taken: 612*/ DECLARE @TableName AnsiString(8000) SET @TableName = 'AssetPurity' DECLARE @CurrentRecordId Int32 SET @CurrentRecordId = '3675322' dbo.GetValidDeviceForAlertProcessData 2025-12-29 21:56:50.4235 DFramework.Database.Query /* Time Taken: 618*/ DECLARE @TableName AnsiString(8000) SET @TableName = 'OpportunityLowStock' DECLARE @CurrentRecordId Int32 SET @CurrentRecordId = '3675322' dbo.GetValidDeviceForAlertProcessData 2025-12-29 21:56:51.0954 DFramework.Database.Query /* Time Taken: 612*/ DECLARE @TableName AnsiString(8000) SET @TableName = 'AssetStockProductCategoryWise' DECLARE @CurrentRecordId Int32 SET @CurrentRecordId = '3675322' dbo.GetValidDeviceForAlertProcessData 2025-12-29 21:56:53.0017 DFramework.Database.Query /* Time Taken: 852*/ DECLARE @TableName AnsiString(8000) SET @TableName = 'ProductStockLevel' DECLARE @CurrentRecordId Int32 SET @CurrentRecordId = '3675322' dbo.GetValidDeviceForAlertProcessData 2025-12-29 21:56:53.0642 AlertProcessor ProcessorAlertData: Stopped 2025-12-29 22:01:43.2538 AlertProcessor ProcessorAlertData: started 2025-12-29 22:01:48.8632 AlertProcessor ProcessorAlertData: Stopped 2025-12-29 22:06:42.3341 DFramework.Database.Query /* Time Taken: 744*/ [dbo].GenerateSystemAlerts 2025-12-29 22:06:43.2716 AlertProcessor ProcessorAlertData: started 2025-12-29 22:06:49.0841 AlertProcessor ProcessorAlertData: Stopped 2025-12-29 22:06:57.4748 DFramework.Scheduler.TaskBase /* Time Taken: 16015.7336*/ Opportunity Out Of Stock By Outlet 2025-12-29 22:11:43.2894 AlertProcessor ProcessorAlertData: started 2025-12-29 22:11:48.8832 AlertProcessor ProcessorAlertData: Stopped 2025-12-29 22:16:43.3074 AlertProcessor ProcessorAlertData: started 2025-12-29 22:16:49.1199 AlertProcessor ProcessorAlertData: Stopped 2025-12-29 22:21:42.4190 DFramework.Database.Query /* Time Taken: 801*/ [dbo].GenerateSystemAlerts 2025-12-29 22:21:43.3252 AlertProcessor ProcessorAlertData: started 2025-12-29 22:21:48.9190 AlertProcessor ProcessorAlertData: Stopped 2025-12-29 22:21:57.4347 DFramework.Scheduler.TaskBase /* Time Taken: 15953.229*/ Opportunity Out Of Stock By Outlet 2025-12-29 22:26:43.3278 AlertProcessor ProcessorAlertData: started 2025-12-29 22:26:43.9056 DFramework.Database.Query /* Time Taken: 579*/ DECLARE @TableName AnsiString(8000) SET @TableName = 'TagAlert' DECLARE @CurrentRecordId Int32 SET @CurrentRecordId = '0' dbo.GetValidDeviceForAlertProcessData 2025-12-29 22:26:49.2494 AlertProcessor ProcessorAlertData: Stopped 2025-12-29 22:31:43.3453 AlertProcessor ProcessorAlertData: started 2025-12-29 22:31:44.6734 DFramework.Database.Query /* Time Taken: 603*/ DECLARE @TableName AnsiString(8000) SET @TableName = 'MissingShelf' DECLARE @CurrentRecordId Int32 SET @CurrentRecordId = '3675322' dbo.GetValidDeviceForAlertProcessData 2025-12-29 22:31:45.2359 DFramework.Database.Query /* Time Taken: 502*/ DECLARE @TableName AnsiString(8000) SET @TableName = 'AdditionalShelf' DECLARE @CurrentRecordId Int32 SET @CurrentRecordId = '3675322' dbo.GetValidDeviceForAlertProcessData 2025-12-29 22:31:45.8141 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-29 22:31:49.4391 AlertProcessor ProcessorAlertData: Stopped 2025-12-29 22:36:42.2225 DFramework.Database.Query /* Time Taken: 585*/ [dbo].GenerateSystemAlerts 2025-12-29 22:36:42.2850 MoveToReorder Running task for ClientId : 286 and ClientName = India Office QA and Slot: 12/30/2025 12:00:00 PM And LastExecutedOn: 12/30/2025 11:06:42 AM 2025-12-29 22:36:42.5819 MoveToReorder Task executed successfully for ClientId : 286 Client Name:India Office QA, Slot: 12/30/2025 12:00:00 PM But No Order found to suggest 2025-12-29 22:36:43.3631 AlertProcessor ProcessorAlertData: started 2025-12-29 22:36:49.2538 AlertProcessor ProcessorAlertData: Stopped 2025-12-29 22:36:57.5820 DFramework.Scheduler.TaskBase /* Time Taken: 16078.2441*/ Opportunity Out Of Stock By Outlet 2025-12-29 22:41:43.3810 AlertProcessor ProcessorAlertData: started 2025-12-29 22:41:49.1779 AlertProcessor ProcessorAlertData: Stopped 2025-12-29 22:46:43.3832 AlertProcessor ProcessorAlertData: started 2025-12-29 22:46:49.2738 AlertProcessor ProcessorAlertData: Stopped 2025-12-29 22:51:42.1825 DFramework.Database.Query /* Time Taken: 525*/ [dbo].GenerateSystemAlerts 2025-12-29 22:51:43.4013 AlertProcessor ProcessorAlertData: started 2025-12-29 22:51:46.5576 DFramework.Database.Query /* Time Taken: 548*/ DECLARE @TableName AnsiString(8000) SET @TableName = 'AssetStockProductWiseConsolidate' DECLARE @CurrentRecordId Int32 SET @CurrentRecordId = '3675322' dbo.GetValidDeviceForAlertProcessData 2025-12-29 22:51:49.1670 AlertProcessor ProcessorAlertData: Stopped 2025-12-29 22:51:57.2920 DFramework.Scheduler.TaskBase /* Time Taken: 15765.749*/ Opportunity Out Of Stock By Outlet 2025-12-29 22:56:43.4192 AlertProcessor ProcessorAlertData: started 2025-12-29 22:56:49.0599 AlertProcessor ProcessorAlertData: Stopped 2025-12-29 23:01:43.4214 AlertProcessor ProcessorAlertData: started 2025-12-29 23:01:49.1402 AlertProcessor ProcessorAlertData: Stopped 2025-12-29 23:06:42.2362 DFramework.Database.Query /* Time Taken: 546*/ [dbo].GenerateSystemAlerts 2025-12-29 23:06:43.4393 AlertProcessor ProcessorAlertData: started 2025-12-29 23:06:46.5175 DFramework.Database.Query /* Time Taken: 558*/ DECLARE @TableName AnsiString(8000) SET @TableName = 'AssetStockProductWiseConsolidate' DECLARE @CurrentRecordId Int32 SET @CurrentRecordId = '3675322' dbo.GetValidDeviceForAlertProcessData 2025-12-29 23:06:49.1269 AlertProcessor ProcessorAlertData: Stopped 2025-12-29 23:06:57.3301 DFramework.Scheduler.TaskBase /* Time Taken: 15781.3735*/ Opportunity Out Of Stock By Outlet 2025-12-29 23:11:43.4572 AlertProcessor ProcessorAlertData: started 2025-12-29 23:11:49.1135 AlertProcessor ProcessorAlertData: Stopped 2025-12-29 23:14:12.5833 AlertProcessor ProcessorAlertData: started 2025-12-29 23:14:13.4114 DFramework.Database.Query /* Time Taken: 791*/ DECLARE @TableName AnsiString(8000) SET @TableName = 'TagAlert' DECLARE @CurrentRecordId Int32 SET @CurrentRecordId = '0' dbo.GetValidDeviceForAlertProcessData 2025-12-29 23:14:13.4271 DFramework.Database.Query /* Time Taken: 812*/ 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-29 23:14:13.4583 DFramework.Database.Query /* Time Taken: 839*/ 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-29 23:14:13.4896 DFramework.Database.Query /* Time Taken: 866*/ 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-29 23:14:13.5052 DFramework.Database.Query /* Time Taken: 893*/ 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-29 23:14:13.6458 DFramework.Database.Query /* Time Taken: 1027*/ 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-29 23:14:13.6614 DFramework.Database.Query /* Time Taken: 1047*/ 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-29 23:14:13.6771 DFramework.Database.Query /* Time Taken: 1047*/ 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-29 23:14:13.6927 DFramework.Database.Query /* Time Taken: 1058*/ 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/30/2025 7:14:12 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-29 23:14:13.7239 DFramework.Database.Query /* Time Taken: 1083*/ 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-29 23:14:13.7552 DFramework.Database.Query /* Time Taken: 1110*/ 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-29 23:14:13.7864 DFramework.Database.Query /* Time Taken: 908*/ DECLARE @AlertDefinitionId Int32 SET @AlertDefinitionId = '99' DECLARE @IsDeleted Boolean SET @IsDeleted = 'False' SELECT ProductId FROM AlertDefinitionProduct WHERE [AlertDefinitionId] = @AlertDefinitionId AND IsDeleted = @IsDeleted 2025-12-29 23:14:13.9896 DFramework.Database.Query /* Time Taken: 1360*/ DECLARE @CreatedOn DateTime2 SET @CreatedOn = '12/30/2025 12:00:00 AM' DECLARE @EventId Int32 SET @EventId = '-12' SELECT COUNT(1) FROM EmailQueue WHERE [CreatedOn] >= @CreatedOn AND [EventId] = @EventId 2025-12-29 23:14:14.0208 DFramework.Database.NullableDataReader Data reader open for 613 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-29 23:14:14.0521 DFramework.Database.NullableDataReader Data reader open for 1172 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-29 23:14:14.5989 DFramework.Database.Query /* Time Taken: 574*/ DECLARE @TableName AnsiString(8000) SET @TableName = 'VoidAlert' DECLARE @CurrentRecordId Int32 SET @CurrentRecordId = '3675322' dbo.GetValidDeviceForAlertProcessData 2025-12-29 23:14:14.6458 DFramework.Database.Query /* Time Taken: 2014*/ [dbo].GenerateSystemAlerts 2025-12-29 23:14:19.5521 AlertProcessor ProcessorAlertData: Stopped 2025-12-29 23:14:29.8022 DFramework.Scheduler.TaskBase /* Time Taken: 17218.8831*/ Opportunity Out Of Stock By Outlet 2025-12-29 23:19:12.5855 AlertProcessor ProcessorAlertData: started 2025-12-29 23:19:14.3355 DFramework.Database.Query /* Time Taken: 520*/ DECLARE @TableName AnsiString(8000) SET @TableName = 'AdditionalShelf' DECLARE @CurrentRecordId Int32 SET @CurrentRecordId = '3675322' dbo.GetValidDeviceForAlertProcessData 2025-12-29 23:19:18.6481 AlertProcessor ProcessorAlertData: Stopped 2025-12-29 23:24:12.6035 AlertProcessor ProcessorAlertData: started 2025-12-29 23:24:18.5723 AlertProcessor ProcessorAlertData: Stopped 2025-12-29 23:29:12.6058 AlertProcessor ProcessorAlertData: started 2025-12-29 23:29:13.6995 DFramework.Database.Query /* Time Taken: 1049*/ [dbo].GenerateSystemAlerts 2025-12-29 23:29:18.6683 AlertProcessor ProcessorAlertData: Stopped 2025-12-29 23:29:28.5434 DFramework.Scheduler.TaskBase /* Time Taken: 15937.6155*/ Opportunity Out Of Stock By Outlet 2025-12-29 23:34:12.6236 AlertProcessor ProcessorAlertData: started 2025-12-29 23:34:13.2486 DFramework.Database.NullableDataReader Data reader open for 258 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-29 23:34:13.3580 MoveToReorder Running task for ClientId : 286 and ClientName = India Office QA and Slot: 12/30/2025 1:00:00 PM And LastExecutedOn: 12/30/2025 12:06:42 PM 2025-12-29 23:34:13.8580 DFramework.Database.Query /* Time Taken: 599*/ DECLARE @TableName AnsiString(8000) SET @TableName = 'VoidAlert' DECLARE @CurrentRecordId Int32 SET @CurrentRecordId = '3675340' dbo.GetValidDeviceForAlertProcessData 2025-12-29 23:34:13.9674 DFramework.Database.Query /* Time Taken: 533*/ DECLARE @OrderStatusId Int32 SET @OrderStatusId = '0' DECLARE @ClientId Int32 SET @ClientId = '286' dbo.GetOrderDetailsByClientId 2025-12-29 23:34:14.2642 DFramework.Database.NullableDataReader Data reader open for 369 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-29 23:34:14.3111 DFramework.Database.NullableDataReader Data reader open for 457 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-29 23:34:14.4361 DFramework.Database.NullableDataReader Data reader open for 435 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-29 23:34:14.4674 MoveToReorder Task executed successfully for ClientId : 286 Client Name:India Office QA, Slot: 12/30/2025 1:00:00 PM and Total Order Suggested: 1 Out Of: 1 2025-12-29 23:34:15.9986 DFramework.Database.NullableDataReader Data reader open for 248 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-29 23:34:16.0768 DFramework.Database.NullableDataReader Data reader open for 343 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-29 23:34:16.8424 DFramework.Database.NullableDataReader Data reader open for 389 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-29 23:34:16.8893 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.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-29 23:34:17.7018 DFramework.Database.NullableDataReader Data reader open for 523 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-29 23:34:17.7487 DFramework.Database.NullableDataReader Data reader open for 607 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-29 23:34:18.9830 DFramework.Database.NullableDataReader Data reader open for 231 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-29 23:34:19.0299 DFramework.Database.NullableDataReader Data reader open for 315 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-29 23:34:19.3737 AlertProcessor Replace Tags updated for the Image Id: 3675340 2025-12-29 23:34:19.5299 DFramework.Database.NullableDataReader Data reader open for 216 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-29 23:34:19.5924 DFramework.Database.NullableDataReader Data reader open for 301 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-29 23:34:20.1237 DFramework.Database.NullableDataReader Data reader open for 254 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-29 23:34:20.1862 DFramework.Database.NullableDataReader Data reader open for 337 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-29 23:34:21.3112 DFramework.Database.NullableDataReader Data reader open for 524 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-29 23:34:21.3580 DFramework.Database.NullableDataReader Data reader open for 607 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-29 23:34:22.2799 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-29 23:34:22.3424 DFramework.Database.NullableDataReader Data reader open for 379 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-29 23:34:23.4987 DFramework.Database.NullableDataReader Data reader open for 689 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-29 23:34:23.5612 DFramework.Database.NullableDataReader Data reader open for 775 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-29 23:34:23.5924 AlertProcessor ProcessorAlertData: Stopped 2025-12-29 23:34:23.6862 DFramework.Scheduler.TaskBase /* Time Taken: 11062.5865*/ Process Alert Record 2025-12-29 23:39:12.6414 AlertProcessor ProcessorAlertData: started 2025-12-29 23:39:14.7196 DFramework.Database.Query /* Time Taken: 841*/ DECLARE @TableName AnsiString(8000) SET @TableName = 'AdditionalShelf' DECLARE @CurrentRecordId Int32 SET @CurrentRecordId = '3675341' dbo.GetValidDeviceForAlertProcessData 2025-12-29 23:39:15.3133 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-29 23:39:15.8290 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-29 23:39:15.8758 DFramework.Database.NullableDataReader Data reader open for 305 at System.Environment.GetStackTrace(Exception e, Boolean needFileInfo) at System.Environment.get_StackTrace() at DFramework.Database.NullableDataReader.Dispose(Boolean disposing) in D:\Spraxa\Framework\DFramework\Database\NullableDataReader.cs:line 33 at DFramework.Database.NullableDataReader.Dispose() in D:\Spraxa\Framework\DFramework\Database\NullableDataReader.cs:line 44 at CoolR.Tasks.ProcessAlertData.Execute() in D:\Spraxa\CoolR-Group\portal\CoolR.Tasks\ProcessAlertData.cs:line 47 at DFramework.Scheduler.TaskBase.Run() in D:\Spraxa\Framework\DFramework.Scheduler\TaskBase.cs:line 176 at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx) at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx) at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state) at System.Threading.ThreadHelper.ThreadStart() 2025-12-29 23:39:16.5008 DFramework.Database.NullableDataReader Data reader open for 349 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-29 23:39:16.5477 DFramework.Database.NullableDataReader Data reader open for 432 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-29 23:39:17.5946 DFramework.Database.NullableDataReader Data reader open for 276 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-29 23:39:17.9384 AlertProcessor Replace Tags updated for the Image Id: 3675341 2025-12-29 23:39:18.0790 DFramework.Database.NullableDataReader Data reader open for 226 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-29 23:39:18.6102 DFramework.Database.NullableDataReader Data reader open for 250 at System.Environment.GetStackTrace(Exception e, Boolean needFileInfo) at System.Environment.get_StackTrace() at DFramework.Database.NullableDataReader.Dispose(Boolean disposing) in D:\Spraxa\Framework\DFramework\Database\NullableDataReader.cs:line 33 at DFramework.Database.NullableDataReader.Dispose() in D:\Spraxa\Framework\DFramework\Database\NullableDataReader.cs:line 44 at CoolR.Tasks.ProcessAlertData.Execute() in D:\Spraxa\CoolR-Group\portal\CoolR.Tasks\ProcessAlertData.cs:line 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-29 23:39:18.6727 DFramework.Database.NullableDataReader Data reader open for 333 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-29 23:39:19.7977 DFramework.Database.NullableDataReader Data reader open for 369 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-29 23:39:19.8602 DFramework.Database.NullableDataReader Data reader open for 451 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-29 23:39:20.7196 DFramework.Database.NullableDataReader Data reader open for 276 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-29 23:39:21.2353 AlertProcessor ProcessorAlertData: Stopped 2025-12-29 23:44:12.6436 AlertProcessor ProcessorAlertData: started 2025-12-29 23:44:13.3311 DFramework.Database.Query /* Time Taken: 684*/ DECLARE @TableName AnsiString(8000) SET @TableName = 'TagAlert' DECLARE @CurrentRecordId Int32 SET @CurrentRecordId = '0' dbo.GetValidDeviceForAlertProcessData 2025-12-29 23:44:13.6436 DFramework.Database.Query /* Time Taken: 938*/ 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-29 23:44:14.0343 DFramework.Database.Query /* Time Taken: 1368*/ [dbo].GenerateSystemAlerts 2025-12-29 23:44:19.5968 AlertProcessor ProcessorAlertData: Stopped 2025-12-29 23:44:28.7531 DFramework.Scheduler.TaskBase /* Time Taken: 16125.1165*/ Opportunity Out Of Stock By Outlet 2025-12-29 23:49:12.6614 AlertProcessor ProcessorAlertData: started 2025-12-29 23:49:15.8958 DFramework.Database.Query /* Time Taken: 633*/ DECLARE @TableName AnsiString(8000) SET @TableName = 'AssetStockProductWiseConsolidate' DECLARE @CurrentRecordId Int32 SET @CurrentRecordId = '3675341' dbo.GetValidDeviceForAlertProcessData 2025-12-29 23:49:18.5834 AlertProcessor ProcessorAlertData: Stopped 2025-12-29 23:54:12.6793 AlertProcessor ProcessorAlertData: started 2025-12-29 23:54:14.0386 DFramework.Database.Query /* Time Taken: 540*/ DECLARE @TableName AnsiString(8000) SET @TableName = 'MissingShelf' DECLARE @CurrentRecordId Int32 SET @CurrentRecordId = '3675341' dbo.GetValidDeviceForAlertProcessData 2025-12-29 23:54:18.5543 AlertProcessor ProcessorAlertData: Stopped 2025-12-29 23:59:12.6971 AlertProcessor ProcessorAlertData: started 2025-12-29 23:59:13.7596 DFramework.Database.Query /* Time Taken: 1076*/ [dbo].GenerateSystemAlerts 2025-12-29 23:59:15.0409 DFramework.Database.Query /* Time Taken: 2281*/ 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-29 23:59:18.5721 AlertProcessor ProcessorAlertData: Stopped 2025-12-29 23:59:30.5254 DFramework.Scheduler.TaskBase /* Time Taken: 17875.1283*/ Opportunity Out Of Stock By Outlet