2025-12-30 00:04:12.7149 AlertProcessor ProcessorAlertData: started 2025-12-30 00:04:16.3399 DFramework.Database.NullableDataReader Data reader open for 278 at System.Environment.GetStackTrace(Exception e, Boolean needFileInfo) at System.Environment.get_StackTrace() at DFramework.Database.NullableDataReader.Dispose(Boolean disposing) in D:\Spraxa\Framework\DFramework\Database\NullableDataReader.cs:line 33 at DFramework.Database.NullableDataReader.Dispose() in D:\Spraxa\Framework\DFramework\Database\NullableDataReader.cs:line 44 at CoolR.Tasks.ProcessAlertData.Execute() in D:\Spraxa\CoolR-Group\portal\CoolR.Tasks\ProcessAlertData.cs:line 47 at DFramework.Scheduler.TaskBase.Run() in D:\Spraxa\Framework\DFramework.Scheduler\TaskBase.cs:line 176 at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx) at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx) at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state) at System.Threading.ThreadHelper.ThreadStart() 2025-12-30 00:04:18.6056 AlertProcessor ProcessorAlertData: Stopped 2025-12-30 00:09:12.7327 AlertProcessor ProcessorAlertData: started 2025-12-30 00:09:13.9984 DFramework.Database.Query /* Time Taken: 556*/ DECLARE @TableName AnsiString(8000) SET @TableName = 'MissingShelf' DECLARE @CurrentRecordId Int32 SET @CurrentRecordId = '3675341' dbo.GetValidDeviceForAlertProcessData 2025-12-30 00:09:18.5765 AlertProcessor ProcessorAlertData: Stopped 2025-12-30 00:14:12.7506 AlertProcessor ProcessorAlertData: started 2025-12-30 00:14:13.3131 DFramework.Database.Query /* Time Taken: 519*/ DECLARE @StatusId Int32 SET @StatusId = '1' DECLARE @AlertId Int32 SET @AlertId = '7571914' SELECT TOP 10000 Alert.AlertId, Alert.LocationId, Alert.RecordId, ISNULL(AlertDefinition.Name, Alert.AlertText) Name, Alert.AlertTypeId, Alert.AlertText, ISNULL(Location.Name, '') AS LocationName, AlertDefinition.ClientId, AlertRecipient.RoleId, CASE WHEN Alert.AlertTypeId IN (6,7) THEN CONVERT(VARCHAR(10), CAST(AlertAt AS DATE), 101) ELSE AlertAt END AS AlertAt, AlertType, Asset.SerialNumber, ISNULL(LocationAttribute.FirstRepId, 0) RepId, ClientUser.PrimaryPhone AS SalesRepPhone, ClientUser.PrimaryEmail AS SalesRepEmail, FirstName, LastName, PreferedNotificationTypeIds, AlertRecipientId, AlertRecipientAddress, AlertRecipientText, Alert.Tags, AlertRecipientTypeId, NotificationContactTypeId, TemplateId, AlertDefinition.AlertAgeThreshold, LastUpdatedOn, AlertRecipient.AlertAge, CASE WHEN Location.TimeZoneId IS NOT NULL AND Location.TimeZoneId > 0 THEN Location.TimeZoneId ELSE Client.TimeZoneId END AS TimeZoneId, AlertDefinition.IsSummarize, Alert.ClosedOn, AssetType.IsChestCooler, AlertDefinition.SnoozeForHours, Alert.SnoozeDateTime FROM Alert LEFT OUTER JOIN Asset ON Alert.AssetId = Asset.AssetId LEFT OUTER JOIN AlertType ON Alert.AlertTypeId = AlertType.AlertTypeId LEFT OUTER JOIN AlertDefinition ON Alert.AlertDefinitionId = AlertDefinition.AlertDefinitionId LEFT OUTER JOIN Location ON Location.LocationId = Alert.LocationId LEFT OUTER JOIN LocationAttribute ON LocationAttribute.LocationId = dbo.Location.LocationId LEFT OUTER JOIN ClientUser ON LocationAttribute.FirstRepId = ClientUser.ClientUserId AND ClientUser.IsDeleted = 0 LEFT OUTER JOIN AlertRecipient ON Alert.AlertDefinitionId = AlertRecipient.AlertDefinitionId AND AlertRecipient.IsDeleted= 0 LEFT OUTER JOIN Client ON Client.ClientId = Alert.ClientId LEFT OUTER JOIN AssetType ON dbo.Asset.AssetTypeId = dbo.AssetType.AssetTypeId WHERE (NOT EXISTS(SELECT 1 FROM dbo.EmailQueue INNER JOIN dbo.EmailRecipient ON EmailRecipient.EmailQueueId = EmailQueue.EmailQueueId WHERE AlertId = Alert.AlertId AND EmailRecipient.RecipientId = AlertRecipient.AlertRecipientId) OR (Alert.SnoozeDateTime IS NOT NULL AND Alert.SnoozeDateTime <= GETUTCDATE() AND AlertDefinition.SnoozeForHours > 0 AND Alert.StatusId = @StatusId)) AND Alert.AlertId > @AlertId AND Alert.AlertAt >= DATEADD(DAY, -120, GETDATE()) AND AlertRecipient.IsDeleted = 0 AND Alert.IsActive = 1 AND Alert.IsDeleted = 0 AND AlertRecipient.IsActive = 1 AND AlertRecipient.IsDeleted = 0 AND AlertRecipient.StartDate <= Alert.CreatedOn AND Alert.CreatedOn < DATEADD(hh, 23, AlertRecipient.EndDate) AND (Alert.LocationId != 0 OR NotificationWithoutLocation = 1) AND AlertType.IsSystemAlert = 0 AND Alert.EmailQueuedOn IS NULL AND AlertDefinition.IsActive = 1 2025-12-30 00:14:13.3444 DFramework.Database.Query /* Time Taken: 598*/ DECLARE @TableName AnsiString(8000) SET @TableName = 'TagAlert' DECLARE @CurrentRecordId Int32 SET @CurrentRecordId = '0' dbo.GetValidDeviceForAlertProcessData 2025-12-30 00:14:13.8600 DFramework.Database.Query /* Time Taken: 1163*/ [dbo].GenerateSystemAlerts 2025-12-30 00:14:19.0475 AlertProcessor ProcessorAlertData: Stopped 2025-12-30 00:14:28.7351 DFramework.Scheduler.TaskBase /* Time Taken: 16078.2538*/ Opportunity Out Of Stock By Outlet 2025-12-30 00:19:12.7685 AlertProcessor ProcessorAlertData: started 2025-12-30 00:19:18.5342 AlertProcessor ProcessorAlertData: Stopped 2025-12-30 00:24:12.7864 AlertProcessor ProcessorAlertData: started 2025-12-30 00:24:18.4583 AlertProcessor ProcessorAlertData: Stopped 2025-12-30 00:29:12.7885 AlertProcessor ProcessorAlertData: started 2025-12-30 00:29:13.8042 DFramework.Database.Query /* Time Taken: 1089*/ [dbo].GenerateSystemAlerts 2025-12-30 00:29:18.9448 AlertProcessor ProcessorAlertData: Stopped 2025-12-30 00:29:28.6168 DFramework.Scheduler.TaskBase /* Time Taken: 15953.2538*/ Opportunity Out Of Stock By Outlet 2025-12-30 00:34:12.7908 AlertProcessor ProcessorAlertData: started 2025-12-30 00:34:13.5720 DFramework.Database.Query /* Time Taken: 706*/ DECLARE @OrderStatusId Int32 SET @OrderStatusId = '5485' UPDATE Location SET ScheduledOrderId = 0, OrderStatusId = 0 from ScheduledOrder INNER JOIN Location ON Location.ScheduledOrderId = ScheduledOrder.ScheduledOrderId AND Location.OrderStatusId = @OrderStatusId INNER JOIN CLient On Client.ClientId = Location.ClientId AND Client.HoursToMoveScheduled > 0 WHERE DATEADD(HOUR, Client.HoursToMoveScheduled, ScheduledOrder.ModifiedOn) < GETUTCDATE() AND ScheduledOrder.StatusId = @OrderStatusId ANd Location.IsDeleted = 0 AND ScheduledOrder.IsDeleted = 0 2025-12-30 00:34:13.7595 MoveToReorder Running task for ClientId : 286 and ClientName = India Office QA and Slot: 12/30/2025 2:00:00 PM And LastExecutedOn: 12/30/2025 1:04:13 PM 2025-12-30 00:34:14.3377 DFramework.Database.Query /* Time Taken: 513*/ DECLARE @OrderStatusId Int32 SET @OrderStatusId = '0' DECLARE @ClientId Int32 SET @ClientId = '286' dbo.GetOrderDetailsByClientId 2025-12-30 00:34:18.0252 DFramework.Database.Query /* Time Taken: 1214*/ DECLARE @TableName AnsiString(8000) SET @TableName = 'OpportunityLowStock' DECLARE @CurrentRecordId Int32 SET @CurrentRecordId = '3675341' dbo.GetValidDeviceForAlertProcessData 2025-12-30 00:34:18.6815 DFramework.Database.Query /* Time Taken: 553*/ DECLARE @TableName AnsiString(8000) SET @TableName = 'AssetStockProductCategoryWise' DECLARE @CurrentRecordId Int32 SET @CurrentRecordId = '3675341' dbo.GetValidDeviceForAlertProcessData 2025-12-30 00:34:19.8377 AlertProcessor ProcessorAlertData: Stopped 2025-12-30 00:34:54.3848 DFramework.Database.NullableDataReader Data reader open for 39972 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-30 00:34:54.4161 MoveToReorder Task executed successfully for ClientId : 286 Client Name:India Office QA, Slot: 12/30/2025 2:00:00 PM and Total Order Suggested: 123 Out Of: 123 2025-12-30 00:34:55.3848 DFramework.Scheduler.TaskBase /* Time Taken: 42656.5262*/ Move To Re-Order 2025-12-30 00:39:12.8086 AlertProcessor ProcessorAlertData: started 2025-12-30 00:39:14.5899 DFramework.Database.Query /* Time Taken: 504*/ DECLARE @TableName AnsiString(8000) SET @TableName = 'AdditionalShelf' DECLARE @CurrentRecordId Int32 SET @CurrentRecordId = '3675341' dbo.GetValidDeviceForAlertProcessData 2025-12-30 00:39:16.3243 DFramework.Database.Query /* Time Taken: 736*/ DECLARE @TableName AnsiString(8000) SET @TableName = 'AssetStockProductWiseConsolidate' DECLARE @CurrentRecordId Int32 SET @CurrentRecordId = '3675341' dbo.GetValidDeviceForAlertProcessData 2025-12-30 00:39:18.9337 AlertProcessor ProcessorAlertData: Stopped 2025-12-30 00:44:12.8264 AlertProcessor ProcessorAlertData: started 2025-12-30 00:44:13.4046 DFramework.Database.Query /* Time Taken: 604*/ 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-30 00:44:13.4202 DFramework.Database.Query /* Time Taken: 579*/ DECLARE @TableName AnsiString(8000) SET @TableName = 'TagAlert' DECLARE @CurrentRecordId Int32 SET @CurrentRecordId = '0' dbo.GetValidDeviceForAlertProcessData 2025-12-30 00:44:13.4202 DFramework.Database.Query /* Time Taken: 516*/ DECLARE @StatusId Int32 SET @StatusId = '1' DECLARE @AlertId Int32 SET @AlertId = '7571914' SELECT TOP 10000 Alert.AlertId, Alert.LocationId, Alert.RecordId, ISNULL(AlertDefinition.Name, Alert.AlertText) Name, Alert.AlertTypeId, Alert.AlertText, ISNULL(Location.Name, '') AS LocationName, AlertDefinition.ClientId, AlertRecipient.RoleId, CASE WHEN Alert.AlertTypeId IN (6,7) THEN CONVERT(VARCHAR(10), CAST(AlertAt AS DATE), 101) ELSE AlertAt END AS AlertAt, AlertType, Asset.SerialNumber, ISNULL(LocationAttribute.FirstRepId, 0) RepId, ClientUser.PrimaryPhone AS SalesRepPhone, ClientUser.PrimaryEmail AS SalesRepEmail, FirstName, LastName, PreferedNotificationTypeIds, AlertRecipientId, AlertRecipientAddress, AlertRecipientText, Alert.Tags, AlertRecipientTypeId, NotificationContactTypeId, TemplateId, AlertDefinition.AlertAgeThreshold, LastUpdatedOn, AlertRecipient.AlertAge, CASE WHEN Location.TimeZoneId IS NOT NULL AND Location.TimeZoneId > 0 THEN Location.TimeZoneId ELSE Client.TimeZoneId END AS TimeZoneId, AlertDefinition.IsSummarize, Alert.ClosedOn, AssetType.IsChestCooler, AlertDefinition.SnoozeForHours, Alert.SnoozeDateTime FROM Alert LEFT OUTER JOIN Asset ON Alert.AssetId = Asset.AssetId LEFT OUTER JOIN AlertType ON Alert.AlertTypeId = AlertType.AlertTypeId LEFT OUTER JOIN AlertDefinition ON Alert.AlertDefinitionId = AlertDefinition.AlertDefinitionId LEFT OUTER JOIN Location ON Location.LocationId = Alert.LocationId LEFT OUTER JOIN LocationAttribute ON LocationAttribute.LocationId = dbo.Location.LocationId LEFT OUTER JOIN ClientUser ON LocationAttribute.FirstRepId = ClientUser.ClientUserId AND ClientUser.IsDeleted = 0 LEFT OUTER JOIN AlertRecipient ON Alert.AlertDefinitionId = AlertRecipient.AlertDefinitionId AND AlertRecipient.IsDeleted= 0 LEFT OUTER JOIN Client ON Client.ClientId = Alert.ClientId LEFT OUTER JOIN AssetType ON dbo.Asset.AssetTypeId = dbo.AssetType.AssetTypeId WHERE (NOT EXISTS(SELECT 1 FROM dbo.EmailQueue INNER JOIN dbo.EmailRecipient ON EmailRecipient.EmailQueueId = EmailQueue.EmailQueueId WHERE AlertId = Alert.AlertId AND EmailRecipient.RecipientId = AlertRecipient.AlertRecipientId) OR (Alert.SnoozeDateTime IS NOT NULL AND Alert.SnoozeDateTime <= GETUTCDATE() AND AlertDefinition.SnoozeForHours > 0 AND Alert.StatusId = @StatusId)) AND Alert.AlertId > @AlertId AND Alert.AlertAt >= DATEADD(DAY, -120, GETDATE()) AND AlertRecipient.IsDeleted = 0 AND Alert.IsActive = 1 AND Alert.IsDeleted = 0 AND AlertRecipient.IsActive = 1 AND AlertRecipient.IsDeleted = 0 AND AlertRecipient.StartDate <= Alert.CreatedOn AND Alert.CreatedOn < DATEADD(hh, 23, AlertRecipient.EndDate) AND (Alert.LocationId != 0 OR NotificationWithoutLocation = 1) AND AlertType.IsSystemAlert = 0 AND Alert.EmailQueuedOn IS NULL AND AlertDefinition.IsActive = 1 2025-12-30 00:44:13.9983 DFramework.Database.Query /* Time Taken: 1261*/ [dbo].GenerateSystemAlerts 2025-12-30 00:44:19.1234 AlertProcessor ProcessorAlertData: Stopped 2025-12-30 00:44:28.8891 DFramework.Scheduler.TaskBase /* Time Taken: 16218.8667*/ Opportunity Out Of Stock By Outlet 2025-12-30 00:49:12.8443 AlertProcessor ProcessorAlertData: started 2025-12-30 00:49:18.5474 AlertProcessor ProcessorAlertData: Stopped 2025-12-30 00:54:12.8621 AlertProcessor ProcessorAlertData: started 2025-12-30 00:54:18.4402 AlertProcessor ProcessorAlertData: Stopped 2025-12-30 00:59:12.8799 AlertProcessor ProcessorAlertData: started 2025-12-30 00:59:13.8174 DFramework.Database.Query /* Time Taken: 1057*/ [dbo].GenerateSystemAlerts 2025-12-30 00:59:14.6143 DFramework.Database.Query /* Time Taken: 795*/ DECLARE @TableName AnsiString(8000) SET @TableName = 'MissingShelf' DECLARE @CurrentRecordId Int32 SET @CurrentRecordId = '3675341' dbo.GetValidDeviceForAlertProcessData 2025-12-30 00:59:19.1299 AlertProcessor ProcessorAlertData: Stopped 2025-12-30 00:59:28.5050 DFramework.Scheduler.TaskBase /* Time Taken: 15812.6235*/ Opportunity Out Of Stock By Outlet 2025-12-30 01:04:12.8976 AlertProcessor ProcessorAlertData: started 2025-12-30 01:04:18.5227 AlertProcessor ProcessorAlertData: Stopped 2025-12-30 01:09:12.9152 AlertProcessor ProcessorAlertData: started 2025-12-30 01:09:18.5871 AlertProcessor ProcessorAlertData: Stopped 2025-12-30 01:14:12.9329 AlertProcessor ProcessorAlertData: started 2025-12-30 01:14:13.4485 DFramework.Database.Query /* Time Taken: 513*/ DECLARE @TableName AnsiString(8000) SET @TableName = 'TagAlert' DECLARE @CurrentRecordId Int32 SET @CurrentRecordId = '0' dbo.GetValidDeviceForAlertProcessData 2025-12-30 01:14:14.0423 DFramework.Database.Query /* Time Taken: 1254*/ [dbo].GenerateSystemAlerts 2025-12-30 01:14:18.9017 AlertProcessor ProcessorAlertData: Stopped 2025-12-30 01:14:28.6986 DFramework.Scheduler.TaskBase /* Time Taken: 16000.1104*/ Opportunity Out Of Stock By Outlet 2025-12-30 01:19:12.9507 AlertProcessor ProcessorAlertData: started 2025-12-30 01:19:18.5445 AlertProcessor ProcessorAlertData: Stopped 2025-12-30 01:24:12.9685 AlertProcessor ProcessorAlertData: started 2025-12-30 01:24:18.7342 AlertProcessor ProcessorAlertData: Stopped 2025-12-30 01:29:12.9863 AlertProcessor ProcessorAlertData: started 2025-12-30 01:29:13.9082 DFramework.Database.Query /* Time Taken: 1094*/ [dbo].GenerateSystemAlerts 2025-12-30 01:29:18.8926 AlertProcessor ProcessorAlertData: Stopped 2025-12-30 01:29:28.4865 DFramework.Scheduler.TaskBase /* Time Taken: 15765.7416*/ Opportunity Out Of Stock By Outlet 2025-12-30 01:34:13.0042 AlertProcessor ProcessorAlertData: started 2025-12-30 01:34:13.1448 MoveToReorder Running task for ClientId : 286 and ClientName = India Office QA and Slot: 12/30/2025 3:00:00 PM And LastExecutedOn: 12/30/2025 2:04:13 PM 2025-12-30 01:34:13.8323 DFramework.Database.Query /* Time Taken: 614*/ DECLARE @OrderStatusId Int32 SET @OrderStatusId = '0' DECLARE @ClientId Int32 SET @ClientId = '286' dbo.GetOrderDetailsByClientId 2025-12-30 01:34:13.8635 MoveToReorder Task executed successfully for ClientId : 286 Client Name:India Office QA, Slot: 12/30/2025 3:00:00 PM But No Order found to suggest 2025-12-30 01:34:14.4885 DFramework.Database.Query /* Time Taken: 659*/ DECLARE @TableName AnsiString(8000) SET @TableName = 'MissingShelf' DECLARE @CurrentRecordId Int32 SET @CurrentRecordId = '3675341' dbo.GetValidDeviceForAlertProcessData 2025-12-30 01:34:18.8323 AlertProcessor ProcessorAlertData: Stopped 2025-12-30 01:39:13.0220 AlertProcessor ProcessorAlertData: started 2025-12-30 01:39:18.5220 AlertProcessor ProcessorAlertData: Stopped 2025-12-30 01:44:13.0398 AlertProcessor ProcessorAlertData: started 2025-12-30 01:44:13.7742 DFramework.Database.Query /* Time Taken: 938*/ [dbo].GenerateSystemAlerts 2025-12-30 01:44:13.7742 DFramework.Database.Query /* Time Taken: 728*/ DECLARE @TableName AnsiString(8000) SET @TableName = 'TagAlert' DECLARE @CurrentRecordId Int32 SET @CurrentRecordId = '0' dbo.GetValidDeviceForAlertProcessData 2025-12-30 01:44:15.3680 DFramework.Database.Query /* Time Taken: 714*/ DECLARE @TableName AnsiString(8000) SET @TableName = 'AdditionalShelf' DECLARE @CurrentRecordId Int32 SET @CurrentRecordId = '3675341' dbo.GetValidDeviceForAlertProcessData 2025-12-30 01:44:19.3993 AlertProcessor ProcessorAlertData: Stopped 2025-12-30 01:44:28.8212 DFramework.Scheduler.TaskBase /* Time Taken: 16078.2361*/ Opportunity Out Of Stock By Outlet 2025-12-30 01:49:13.0577 AlertProcessor ProcessorAlertData: started 2025-12-30 01:49:18.6671 AlertProcessor ProcessorAlertData: Stopped 2025-12-30 01:54:13.0755 AlertProcessor ProcessorAlertData: started 2025-12-30 01:54:18.7630 AlertProcessor ProcessorAlertData: Stopped 2025-12-30 01:59:13.0789 AlertProcessor ProcessorAlertData: started 2025-12-30 01:59:13.6727 DFramework.Database.Query /* Time Taken: 821*/ [dbo].GenerateSystemAlerts 2025-12-30 01:59:16.4227 DFramework.Database.Query /* Time Taken: 504*/ DECLARE @TableName AnsiString(8000) SET @TableName = 'AssetStockProductWiseConsolidate' DECLARE @CurrentRecordId Int32 SET @CurrentRecordId = '3675341' dbo.GetValidDeviceForAlertProcessData 2025-12-30 01:59:19.1415 AlertProcessor ProcessorAlertData: Stopped 2025-12-30 01:59:28.6103 DFramework.Scheduler.TaskBase /* Time Taken: 15843.9065*/ Opportunity Out Of Stock By Outlet 2025-12-30 02:04:13.0972 AlertProcessor ProcessorAlertData: started 2025-12-30 02:04:18.7535 AlertProcessor ProcessorAlertData: Stopped 2025-12-30 02:09:13.1151 AlertProcessor ProcessorAlertData: started 2025-12-30 02:09:18.7714 AlertProcessor ProcessorAlertData: Stopped 2025-12-30 02:14:13.1323 AlertProcessor ProcessorAlertData: started 2025-12-30 02:14:13.7261 DFramework.Database.Query /* Time Taken: 603*/ 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-30 02:14:13.9136 DFramework.Database.Query /* Time Taken: 1044*/ [dbo].GenerateSystemAlerts 2025-12-30 02:14:18.9761 AlertProcessor ProcessorAlertData: Stopped 2025-12-30 02:14:28.6480 DFramework.Scheduler.TaskBase /* Time Taken: 15859.4447*/ Opportunity Out Of Stock By Outlet 2025-12-30 02:19:13.1496 AlertProcessor ProcessorAlertData: started 2025-12-30 02:19:18.8528 DFramework.Database.Query /* Time Taken: 529*/ DECLARE @TableName AnsiString(8000) SET @TableName = 'ProductStockLevel' DECLARE @CurrentRecordId Int32 SET @CurrentRecordId = '3675341' dbo.GetValidDeviceForAlertProcessData 2025-12-30 02:19:18.9153 AlertProcessor ProcessorAlertData: Stopped 2025-12-30 02:24:13.1673 AlertProcessor ProcessorAlertData: started 2025-12-30 02:24:19.0423 DFramework.Database.Query /* Time Taken: 503*/ DECLARE @TableName AnsiString(8000) SET @TableName = 'ProductStockLevel' DECLARE @CurrentRecordId Int32 SET @CurrentRecordId = '3675341' dbo.GetValidDeviceForAlertProcessData 2025-12-30 02:24:19.0892 AlertProcessor ProcessorAlertData: Stopped 2025-12-30 02:29:13.1851 AlertProcessor ProcessorAlertData: started 2025-12-30 02:29:13.7163 DFramework.Database.Query /* Time Taken: 815*/ [dbo].GenerateSystemAlerts 2025-12-30 02:29:16.4039 DFramework.Database.Query /* Time Taken: 570*/ DECLARE @TableName AnsiString(8000) SET @TableName = 'AssetStockProductWiseConsolidate' DECLARE @CurrentRecordId Int32 SET @CurrentRecordId = '3675341' dbo.GetValidDeviceForAlertProcessData 2025-12-30 02:29:17.0132 DFramework.Database.Query /* Time Taken: 516*/ DECLARE @TableName AnsiString(8000) SET @TableName = 'AssetStockProductWise' DECLARE @CurrentRecordId Int32 SET @CurrentRecordId = '3675341' dbo.GetValidDeviceForAlertProcessData 2025-12-30 02:29:19.5601 DFramework.Database.Query /* Time Taken: 506*/ DECLARE @TableName AnsiString(8000) SET @TableName = 'ProductStockLevel' DECLARE @CurrentRecordId Int32 SET @CurrentRecordId = '3675341' dbo.GetValidDeviceForAlertProcessData 2025-12-30 02:29:19.6226 AlertProcessor ProcessorAlertData: Stopped 2025-12-30 02:29:28.6227 DFramework.Scheduler.TaskBase /* Time Taken: 15812.6152*/ Opportunity Out Of Stock By Outlet 2025-12-30 02:34:13.2029 AlertProcessor ProcessorAlertData: started 2025-12-30 02:34:13.2185 MoveToReorder Running task for ClientId : 286 and ClientName = India Office QA and Slot: 12/30/2025 4:00:00 PM And LastExecutedOn: 12/30/2025 3:04:13 PM 2025-12-30 02:34:13.8592 DFramework.Database.Query /* Time Taken: 591*/ DECLARE @OrderStatusId Int32 SET @OrderStatusId = '0' DECLARE @ClientId Int32 SET @ClientId = '286' dbo.GetOrderDetailsByClientId 2025-12-30 02:34:14.7029 DFramework.Database.Query /* Time Taken: 771*/ DECLARE @TableName AnsiString(8000) SET @TableName = 'MissingShelf' DECLARE @CurrentRecordId Int32 SET @CurrentRecordId = '3675341' dbo.GetValidDeviceForAlertProcessData 2025-12-30 02:34:14.7185 DFramework.Database.NullableDataReader Data reader open for 816 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-30 02:34:14.7498 MoveToReorder Task executed successfully for ClientId : 286 Client Name:India Office QA, Slot: 12/30/2025 4:00:00 PM and Total Order Suggested: 1 Out Of: 1 2025-12-30 02:34:15.8123 DFramework.Database.Query /* Time Taken: 1058*/ DECLARE @TableName AnsiString(8000) SET @TableName = 'AdditionalShelf' DECLARE @CurrentRecordId Int32 SET @CurrentRecordId = '3675341' dbo.GetValidDeviceForAlertProcessData 2025-12-30 02:34:19.9061 DFramework.Database.Query /* Time Taken: 530*/ DECLARE @TableName AnsiString(8000) SET @TableName = 'ProductStockLevel' DECLARE @CurrentRecordId Int32 SET @CurrentRecordId = '3675341' dbo.GetValidDeviceForAlertProcessData 2025-12-30 02:34:19.9530 AlertProcessor ProcessorAlertData: Stopped 2025-12-30 02:39:13.2208 AlertProcessor ProcessorAlertData: started 2025-12-30 02:39:18.9239 AlertProcessor ProcessorAlertData: Stopped 2025-12-30 02:44:13.2230 AlertProcessor ProcessorAlertData: started 2025-12-30 02:44:13.9417 DFramework.Database.Query /* Time Taken: 1028*/ [dbo].GenerateSystemAlerts 2025-12-30 02:44:19.3011 AlertProcessor ProcessorAlertData: Stopped 2025-12-30 02:44:28.6606 DFramework.Scheduler.TaskBase /* Time Taken: 15828.2411*/ Opportunity Out Of Stock By Outlet 2025-12-30 02:49:13.2409 AlertProcessor ProcessorAlertData: started 2025-12-30 02:49:17.7097 DFramework.Database.Query /* Time Taken: 523*/ DECLARE @TableName AnsiString(8000) SET @TableName = 'OpportunityLowStock' DECLARE @CurrentRecordId Int32 SET @CurrentRecordId = '3675341' dbo.GetValidDeviceForAlertProcessData 2025-12-30 02:49:19.1629 AlertProcessor ProcessorAlertData: Stopped 2025-12-30 02:54:13.2588 AlertProcessor ProcessorAlertData: started 2025-12-30 02:54:18.8526 AlertProcessor ProcessorAlertData: Stopped 2025-12-30 02:59:13.2767 AlertProcessor ProcessorAlertData: started 2025-12-30 02:59:13.7767 DFramework.Database.Query /* Time Taken: 837*/ [dbo].GenerateSystemAlerts 2025-12-30 02:59:13.7923 DFramework.Database.Query /* Time Taken: 503*/ DECLARE @TableName AnsiString(8000) SET @TableName = 'TagAlert' DECLARE @CurrentRecordId Int32 SET @CurrentRecordId = '0' dbo.GetValidDeviceForAlertProcessData 2025-12-30 02:59:15.4173 DFramework.Database.Query /* Time Taken: 764*/ DECLARE @TableName AnsiString(8000) SET @TableName = 'AdditionalShelf' DECLARE @CurrentRecordId Int32 SET @CurrentRecordId = '3675341' dbo.GetValidDeviceForAlertProcessData 2025-12-30 02:59:19.3705 AlertProcessor ProcessorAlertData: Stopped 2025-12-30 02:59:28.6518 DFramework.Scheduler.TaskBase /* Time Taken: 15796.9798*/ Opportunity Out Of Stock By Outlet 2025-12-30 03:04:13.2789 AlertProcessor ProcessorAlertData: started 2025-12-30 03:04:14.2477 DFramework.Database.Query /* Time Taken: 779*/ DECLARE @OrderStatusId Int32 SET @OrderStatusId = '5485' Select * from vwScheduledOrderItemList where ScheduledOrderId IN (SELECT ScheduledOrder.ScheduledOrderId FROM ScheduledOrder INNER JOIN Location ON Location.ScheduledOrderId = ScheduledOrder.ScheduledOrderId AND Location.OrderStatusId = @OrderStatusId AND Location.IsDeleted = 0 INNER JOIN CLient On Client.ClientId = Location.ClientId AND Client.HoursToMoveIgnored > 0 WHERE DATEADD(HOUR, Client.HoursToMoveScheduled, ScheduledOrder.ModifiedOn) < GETUTCDATE() AND ScheduledOrder.StatusId = @OrderStatusId AND ScheduledOrder.IsDeleted = 0) 2025-12-30 03:04:19.4040 AlertProcessor ProcessorAlertData: Stopped 2025-12-30 03:09:13.2969 AlertProcessor ProcessorAlertData: started 2025-12-30 03:09:14.3438 DFramework.Database.Query /* Time Taken: 1053*/ 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-30 03:09:14.3907 DFramework.Database.Query /* Time Taken: 1088*/ DECLARE @TableName AnsiString(8000) SET @TableName = 'TagAlert' DECLARE @CurrentRecordId Int32 SET @CurrentRecordId = '0' dbo.GetValidDeviceForAlertProcessData 2025-12-30 03:09:16.1094 DFramework.Database.Query /* Time Taken: 1331*/ DECLARE @TableName AnsiString(8000) SET @TableName = 'MissingShelf' DECLARE @CurrentRecordId Int32 SET @CurrentRecordId = '3675341' dbo.GetValidDeviceForAlertProcessData 2025-12-30 03:09:16.9219 DFramework.Database.Query /* Time Taken: 756*/ DECLARE @TableName AnsiString(8000) SET @TableName = 'AdditionalShelf' DECLARE @CurrentRecordId Int32 SET @CurrentRecordId = '3675341' dbo.GetValidDeviceForAlertProcessData 2025-12-30 03:09:17.5782 DFramework.Database.Query /* Time Taken: 592*/ DECLARE @TableName AnsiString(8000) SET @TableName = 'OpportunityOutOfStock' DECLARE @CurrentRecordId Int32 SET @CurrentRecordId = '3675341' dbo.GetValidDeviceForAlertProcessData 2025-12-30 03:09:18.2188 DFramework.Database.Query /* Time Taken: 584*/ DECLARE @TableName AnsiString(8000) SET @TableName = 'PlanogramComplianceConsolidate' DECLARE @CurrentRecordId Int32 SET @CurrentRecordId = '3675341' dbo.GetValidDeviceForAlertProcessData 2025-12-30 03:09:18.8751 DFramework.Database.Query /* Time Taken: 595*/ DECLARE @TableName AnsiString(8000) SET @TableName = 'OpportunityOutOfStockConsolidate' DECLARE @CurrentRecordId Int32 SET @CurrentRecordId = '3675341' dbo.GetValidDeviceForAlertProcessData 2025-12-30 03:09:20.3282 DFramework.Database.Query /* Time Taken: 1386*/ DECLARE @TableName AnsiString(8000) SET @TableName = 'AssetStockProductWiseConsolidate' DECLARE @CurrentRecordId Int32 SET @CurrentRecordId = '3675341' dbo.GetValidDeviceForAlertProcessData 2025-12-30 03:09:21.9845 DFramework.Database.Query /* Time Taken: 539*/ DECLARE @TableName AnsiString(8000) SET @TableName = 'AssetPurity' DECLARE @CurrentRecordId Int32 SET @CurrentRecordId = '3675341' dbo.GetValidDeviceForAlertProcessData 2025-12-30 03:09:25.0782 DFramework.Database.Query /* Time Taken: 1040*/ DECLARE @TableName AnsiString(8000) SET @TableName = 'ProductStockLevel' DECLARE @CurrentRecordId Int32 SET @CurrentRecordId = '3675341' dbo.GetValidDeviceForAlertProcessData 2025-12-30 03:09:25.1407 AlertProcessor ProcessorAlertData: Stopped 2025-12-30 03:09:25.1407 DFramework.Scheduler.TaskBase /* Time Taken: 11843.8369*/ Process Alert Record 2025-12-30 03:14:13.3147 AlertProcessor ProcessorAlertData: started 2025-12-30 03:14:13.8460 DFramework.Database.Query /* Time Taken: 517*/ DECLARE @TableName AnsiString(8000) SET @TableName = 'TagAlert' DECLARE @CurrentRecordId Int32 SET @CurrentRecordId = '0' dbo.GetValidDeviceForAlertProcessData 2025-12-30 03:14:14.2366 DFramework.Database.Query /* Time Taken: 1271*/ [dbo].GenerateSystemAlerts 2025-12-30 03:14:16.0179 DFramework.Database.Query /* Time Taken: 787*/ DECLARE @TableName AnsiString(8000) SET @TableName = 'OpportunityOutOfStock' DECLARE @CurrentRecordId Int32 SET @CurrentRecordId = '3675341' dbo.GetValidDeviceForAlertProcessData 2025-12-30 03:14:17.1585 DFramework.Database.Query /* Time Taken: 3999*/ DECLARE @OrderStatusId Int32 SET @OrderStatusId = '5485' Select * from vwScheduledOrderItemList where ScheduledOrderId IN (SELECT ScheduledOrder.ScheduledOrderId FROM ScheduledOrder INNER JOIN Location ON Location.ScheduledOrderId = ScheduledOrder.ScheduledOrderId AND Location.OrderStatusId = @OrderStatusId AND Location.IsDeleted = 0 INNER JOIN CLient On Client.ClientId = Location.ClientId AND Client.HoursToMoveIgnored > 0 WHERE DATEADD(HOUR, Client.HoursToMoveScheduled, ScheduledOrder.ModifiedOn) < GETUTCDATE() AND ScheduledOrder.StatusId = @OrderStatusId AND ScheduledOrder.IsDeleted = 0) 2025-12-30 03:14:19.6742 AlertProcessor ProcessorAlertData: Stopped 2025-12-30 03:14:28.9867 DFramework.Scheduler.TaskBase /* Time Taken: 16109.4896*/ Opportunity Out Of Stock By Outlet 2025-12-30 03:19:13.3326 AlertProcessor ProcessorAlertData: started 2025-12-30 03:19:18.6920 AlertProcessor ProcessorAlertData: Stopped 2025-12-30 03:24:13.3505 AlertProcessor ProcessorAlertData: started 2025-12-30 03:24:19.1631 DFramework.Database.Query /* Time Taken: 729*/ DECLARE @TableName AnsiString(8000) SET @TableName = 'ProductStockLevel' DECLARE @CurrentRecordId Int32 SET @CurrentRecordId = '3675341' dbo.GetValidDeviceForAlertProcessData 2025-12-30 03:24:19.2100 AlertProcessor ProcessorAlertData: Stopped 2025-12-30 03:29:13.3684 AlertProcessor ProcessorAlertData: started 2025-12-30 03:29:14.0090 DFramework.Database.Query /* Time Taken: 636*/ DECLARE @TableName AnsiString(8000) SET @TableName = 'TagAlert' DECLARE @CurrentRecordId Int32 SET @CurrentRecordId = '0' dbo.GetValidDeviceForAlertProcessData 2025-12-30 03:29:14.1809 DFramework.Database.Query /* Time Taken: 1192*/ [dbo].GenerateSystemAlerts 2025-12-30 03:29:14.9778 DFramework.Database.Query /* Time Taken: 514*/ DECLARE @TableName AnsiString(8000) SET @TableName = 'MissingShelf' DECLARE @CurrentRecordId Int32 SET @CurrentRecordId = '3675341' dbo.GetValidDeviceForAlertProcessData 2025-12-30 03:29:16.9153 DFramework.Database.Query /* Time Taken: 507*/ DECLARE @TableName AnsiString(8000) SET @TableName = 'AssetStockProductWiseConsolidate' DECLARE @CurrentRecordId Int32 SET @CurrentRecordId = '3675341' dbo.GetValidDeviceForAlertProcessData 2025-12-30 03:29:19.5559 AlertProcessor ProcessorAlertData: Stopped 2025-12-30 03:29:29.1966 DFramework.Scheduler.TaskBase /* Time Taken: 16296.9914*/ Opportunity Out Of Stock By Outlet 2025-12-30 03:34:13.3706 AlertProcessor ProcessorAlertData: started 2025-12-30 03:34:13.7144 DFramework.Database.Query /* Time Taken: 713*/ 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-30 03:34:14.2925 DFramework.Database.Query /* Time Taken: 579*/ 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-30 03:34:16.4644 DFramework.Database.Query /* Time Taken: 3099*/ 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-30 03:34:17.6519 DFramework.Database.Query /* Time Taken: 4267*/ DECLARE @TableName AnsiString(8000) SET @TableName = 'TagAlert' DECLARE @CurrentRecordId Int32 SET @CurrentRecordId = '0' dbo.GetValidDeviceForAlertProcessData 2025-12-30 03:34:20.4957 DFramework.Database.Query /* Time Taken: 2303*/ DECLARE @TableName AnsiString(8000) SET @TableName = 'MissingShelf' DECLARE @CurrentRecordId Int32 SET @CurrentRecordId = '3675341' dbo.GetValidDeviceForAlertProcessData 2025-12-30 03:34:21.2457 DFramework.Database.Query /* Time Taken: 692*/ DECLARE @TableName AnsiString(8000) SET @TableName = 'AdditionalShelf' DECLARE @CurrentRecordId Int32 SET @CurrentRecordId = '3675341' dbo.GetValidDeviceForAlertProcessData 2025-12-30 03:34:24.2457 DFramework.Database.Query /* Time Taken: 1987*/ DECLARE @TableName AnsiString(8000) SET @TableName = 'AssetStockProductWiseConsolidate' DECLARE @CurrentRecordId Int32 SET @CurrentRecordId = '3675341' dbo.GetValidDeviceForAlertProcessData 2025-12-30 03:34:28.0738 DFramework.Database.Query /* Time Taken: 1350*/ DECLARE @TableName AnsiString(8000) SET @TableName = 'ProductStockLevel' DECLARE @CurrentRecordId Int32 SET @CurrentRecordId = '3675341' dbo.GetValidDeviceForAlertProcessData 2025-12-30 03:34:28.1363 AlertProcessor ProcessorAlertData: Stopped 2025-12-30 03:34:28.1363 DFramework.Scheduler.TaskBase /* Time Taken: 14765.7364*/ Process Alert Record 2025-12-30 03:34:33.6208 DFramework.Database.Query /* Time Taken: 19329*/ DECLARE @OrderStatusId Int32 SET @OrderStatusId = '5485' Select * from vwScheduledOrderItemList where ScheduledOrderId IN (SELECT ScheduledOrder.ScheduledOrderId FROM ScheduledOrder INNER JOIN Location ON Location.ScheduledOrderId = ScheduledOrder.ScheduledOrderId AND Location.OrderStatusId = @OrderStatusId AND Location.IsDeleted = 0 INNER JOIN CLient On Client.ClientId = Location.ClientId AND Client.HoursToMoveIgnored > 0 WHERE DATEADD(HOUR, Client.HoursToMoveScheduled, ScheduledOrder.ModifiedOn) < GETUTCDATE() AND ScheduledOrder.StatusId = @OrderStatusId AND ScheduledOrder.IsDeleted = 0) 2025-12-30 03:34:33.9645 MoveToReorder Running task for ClientId : 286 and ClientName = India Office QA and Slot: 12/30/2025 5:00:00 PM And LastExecutedOn: 12/30/2025 4:04:13 PM 2025-12-30 03:35:36.7150 DFramework.Database.NullableDataReader Data reader open for 62276 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-30 03:35:36.7775 MoveToReorder Task executed successfully for ClientId : 286 Client Name:India Office QA, Slot: 12/30/2025 5:00:00 PM and Total Order Suggested: 122 Out Of: 122 2025-12-30 03:35:37.9181 DFramework.Database.Query /* Time Taken: 1139*/ DECLARE @ClientId Int32 SET @ClientId = '286' dbo.GetMoveToReOrderList 2025-12-30 03:35:40.1525 DFramework.Database.Query /* Time Taken: 513*/ 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-30 03:35:40.1525 DFramework.Scheduler.TaskBase /* Time Taken: 87141.26*/ Move To Re-Order 2025-12-30 03:39:13.3885 AlertProcessor ProcessorAlertData: started 2025-12-30 03:39:18.0604 AlertProcessor Replace Tags updated for the Image Id: 3675351 2025-12-30 03:39:18.2167 DFramework.Database.NullableDataReader Data reader open for 253 at System.Environment.GetStackTrace(Exception e, Boolean needFileInfo) at System.Environment.get_StackTrace() at DFramework.Database.NullableDataReader.Dispose(Boolean disposing) in D:\Spraxa\Framework\DFramework\Database\NullableDataReader.cs:line 33 at DFramework.Database.NullableDataReader.Dispose() in D:\Spraxa\Framework\DFramework\Database\NullableDataReader.cs:line 44 at CoolR.Tasks.ProcessAlertData.Execute() in D:\Spraxa\CoolR-Group\portal\CoolR.Tasks\ProcessAlertData.cs:line 47 at DFramework.Scheduler.TaskBase.Run() in D:\Spraxa\Framework\DFramework.Scheduler\TaskBase.cs:line 176 at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx) at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx) at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state) at System.Threading.ThreadHelper.ThreadStart() 2025-12-30 03:39:18.8260 DFramework.Database.NullableDataReader Data reader open for 253 at System.Environment.GetStackTrace(Exception e, Boolean needFileInfo) at System.Environment.get_StackTrace() at DFramework.Database.NullableDataReader.Dispose(Boolean disposing) in D:\Spraxa\Framework\DFramework\Database\NullableDataReader.cs:line 33 at DFramework.Database.NullableDataReader.Dispose() in D:\Spraxa\Framework\DFramework\Database\NullableDataReader.cs:line 44 at CoolR.Tasks.ProcessAlertData.Execute() in D:\Spraxa\CoolR-Group\portal\CoolR.Tasks\ProcessAlertData.cs:line 47 at DFramework.Scheduler.TaskBase.Run() in D:\Spraxa\Framework\DFramework.Scheduler\TaskBase.cs:line 176 at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx) at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx) at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state) at System.Threading.ThreadHelper.ThreadStart() 2025-12-30 03:39:18.8885 DFramework.Database.NullableDataReader Data reader open for 336 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-30 03:39:19.7323 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-30 03:39:21.6229 DFramework.Database.NullableDataReader Data reader open for 747 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-30 03:39:21.6854 DFramework.Database.NullableDataReader Data reader open for 830 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-30 03:39:21.7167 AlertProcessor ProcessorAlertData: Stopped 2025-12-30 03:44:13.4063 AlertProcessor ProcessorAlertData: started 2025-12-30 03:44:14.0782 DFramework.Database.Query /* Time Taken: 1068*/ [dbo].GenerateSystemAlerts 2025-12-30 03:44:19.2033 AlertProcessor ProcessorAlertData: Stopped 2025-12-30 03:44:29.0159 DFramework.Scheduler.TaskBase /* Time Taken: 16093.8957*/ Opportunity Out Of Stock By Outlet 2025-12-30 03:49:13.4242 AlertProcessor ProcessorAlertData: started 2025-12-30 03:49:18.6586 AlertProcessor ProcessorAlertData: Stopped 2025-12-30 03:54:13.4264 AlertProcessor ProcessorAlertData: started 2025-12-30 03:54:18.8483 AlertProcessor ProcessorAlertData: Stopped 2025-12-30 03:59:13.4287 AlertProcessor ProcessorAlertData: started 2025-12-30 03:59:13.5850 DFramework.Database.Query /* Time Taken: 546*/ [dbo].GenerateSystemAlerts 2025-12-30 03:59:18.6788 DFramework.Database.Query /* Time Taken: 514*/ DECLARE @TableName AnsiString(8000) SET @TableName = 'ProductStockLevel' DECLARE @CurrentRecordId Int32 SET @CurrentRecordId = '3675351' dbo.GetValidDeviceForAlertProcessData 2025-12-30 03:59:18.7256 AlertProcessor ProcessorAlertData: Stopped 2025-12-30 03:59:28.8976 DFramework.Scheduler.TaskBase /* Time Taken: 15953.2424*/ Opportunity Out Of Stock By Outlet 2025-12-30 04:04:13.4465 AlertProcessor ProcessorAlertData: started 2025-12-30 04:04:16.3528 DFramework.Database.Query /* Time Taken: 583*/ DECLARE @TableName AnsiString(8000) SET @TableName = 'AssetStockProductWiseConsolidate' DECLARE @CurrentRecordId Int32 SET @CurrentRecordId = '3675351' dbo.GetValidDeviceForAlertProcessData 2025-12-30 04:04:18.7435 AlertProcessor ProcessorAlertData: Stopped 2025-12-30 04:09:13.4644 AlertProcessor ProcessorAlertData: started 2025-12-30 04:09:18.7613 AlertProcessor ProcessorAlertData: Stopped 2025-12-30 04:14:13.4823 AlertProcessor ProcessorAlertData: started 2025-12-30 04:14:14.0292 DFramework.Database.Query /* Time Taken: 971*/ [dbo].GenerateSystemAlerts 2025-12-30 04:14:19.4824 AlertProcessor ProcessorAlertData: Stopped 2025-12-30 04:14:28.8418 DFramework.Scheduler.TaskBase /* Time Taken: 15875.1374*/ Opportunity Out Of Stock By Outlet 2025-12-30 04:19:13.5002 AlertProcessor ProcessorAlertData: started 2025-12-30 04:19:18.9846 AlertProcessor ProcessorAlertData: Stopped 2025-12-30 04:24:13.5180 AlertProcessor ProcessorAlertData: started 2025-12-30 04:24:18.9555 AlertProcessor ProcessorAlertData: Stopped 2025-12-30 04:29:13.5359 AlertProcessor ProcessorAlertData: started 2025-12-30 04:29:14.8953 DFramework.Database.Query /* Time Taken: 708*/ DECLARE @TableName AnsiString(8000) SET @TableName = 'MissingShelf' DECLARE @CurrentRecordId Int32 SET @CurrentRecordId = '3675351' dbo.GetValidDeviceForAlertProcessData 2025-12-30 04:29:19.3328 AlertProcessor ProcessorAlertData: Stopped 2025-12-30 04:29:29.0516 DFramework.Scheduler.TaskBase /* Time Taken: 16062.6304*/ Opportunity Out Of Stock By Outlet 2025-12-30 04:34:13.3976 MoveToReorder Running task for ClientId : 286 and ClientName = India Office QA and Slot: 12/30/2025 6:00:00 PM And LastExecutedOn: 12/30/2025 5:04:33 PM 2025-12-30 04:34:13.5539 AlertProcessor ProcessorAlertData: started 2025-12-30 04:34:13.9757 DFramework.Database.NullableDataReader Data reader open for 252 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-30 04:34:14.0070 MoveToReorder Task executed successfully for ClientId : 286 Client Name:India Office QA, Slot: 12/30/2025 6:00:00 PM and Total Order Suggested: 1 Out Of: 1 2025-12-30 04:34:14.6320 DFramework.Database.NullableDataReader Data reader open for 338 at System.Environment.GetStackTrace(Exception e, Boolean needFileInfo) at System.Environment.get_StackTrace() at DFramework.Database.NullableDataReader.Dispose(Boolean disposing) in D:\Spraxa\Framework\DFramework\Database\NullableDataReader.cs:line 33 at DFramework.Database.NullableDataReader.Dispose() in D:\Spraxa\Framework\DFramework\Database\NullableDataReader.cs:line 44 at CoolR.Tasks.ProcessAlertData.Execute() in D:\Spraxa\CoolR-Group\portal\CoolR.Tasks\ProcessAlertData.cs:line 47 at DFramework.Scheduler.TaskBase.Run() in D:\Spraxa\Framework\DFramework.Scheduler\TaskBase.cs:line 176 at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx) at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx) at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state) at System.Threading.ThreadHelper.ThreadStart() 2025-12-30 04:34:14.6945 DFramework.Database.NullableDataReader Data reader open for 422 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-30 04:34:15.3664 DFramework.Database.Query /* Time Taken: 674*/ DECLARE @TableName AnsiString(8000) SET @TableName = 'MissingShelf' DECLARE @CurrentRecordId Int32 SET @CurrentRecordId = '3675358' dbo.GetValidDeviceForAlertProcessData 2025-12-30 04:34:16.4914 DFramework.Database.NullableDataReader Data reader open for 230 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-30 04:34:16.5383 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-30 04:34:17.0383 DFramework.Database.NullableDataReader Data reader open for 225 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-30 04:34:17.0851 DFramework.Database.NullableDataReader Data reader open for 307 at System.Environment.GetStackTrace(Exception e, Boolean needFileInfo) at System.Environment.get_StackTrace() at DFramework.Database.NullableDataReader.Dispose(Boolean disposing) in D:\Spraxa\Framework\DFramework\Database\NullableDataReader.cs:line 33 at DFramework.Database.NullableDataReader.Dispose() in D:\Spraxa\Framework\DFramework\Database\NullableDataReader.cs:line 44 at CoolR.Tasks.ProcessAlertData.Execute() in D:\Spraxa\CoolR-Group\portal\CoolR.Tasks\ProcessAlertData.cs:line 47 at DFramework.Scheduler.TaskBase.Run() in D:\Spraxa\Framework\DFramework.Scheduler\TaskBase.cs:line 176 at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx) at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx) at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state) at System.Threading.ThreadHelper.ThreadStart() 2025-12-30 04:34:17.7101 DFramework.Database.NullableDataReader Data reader open for 356 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-30 04:34:17.7726 DFramework.Database.NullableDataReader Data reader open for 439 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-30 04:34:18.7570 DFramework.Database.NullableDataReader Data reader open for 242 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-30 04:34:19.0851 AlertProcessor Replace Tags updated for the Image Id: 3675358 2025-12-30 04:34:19.7102 DFramework.Database.NullableDataReader Data reader open for 251 at System.Environment.GetStackTrace(Exception e, Boolean needFileInfo) at System.Environment.get_StackTrace() at DFramework.Database.NullableDataReader.Dispose(Boolean disposing) in D:\Spraxa\Framework\DFramework\Database\NullableDataReader.cs:line 33 at DFramework.Database.NullableDataReader.Dispose() in D:\Spraxa\Framework\DFramework\Database\NullableDataReader.cs:line 44 at CoolR.Tasks.ProcessAlertData.Execute() in D:\Spraxa\CoolR-Group\portal\CoolR.Tasks\ProcessAlertData.cs:line 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-30 04:34:19.7570 DFramework.Database.NullableDataReader Data reader open for 334 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-30 04:34:20.7102 DFramework.Database.NullableDataReader Data reader open for 221 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-30 04:34:21.5383 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-30 04:34:22.7571 DFramework.Database.NullableDataReader Data reader open for 795 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-30 04:34:22.8195 DFramework.Database.NullableDataReader Data reader open for 878 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-30 04:34:22.8508 AlertProcessor ProcessorAlertData: Stopped 2025-12-30 04:39:13.5717 AlertProcessor ProcessorAlertData: started 2025-12-30 04:39:14.6342 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-30 04:39:14.6811 DFramework.Database.NullableDataReader Data reader open for 397 at System.Environment.GetStackTrace(Exception e, Boolean needFileInfo) at System.Environment.get_StackTrace() at DFramework.Database.NullableDataReader.Dispose(Boolean disposing) in D:\Spraxa\Framework\DFramework\Database\NullableDataReader.cs:line 33 at DFramework.Database.NullableDataReader.Dispose() in D:\Spraxa\Framework\DFramework\Database\NullableDataReader.cs:line 44 at CoolR.Tasks.ProcessAlertData.Execute() in D:\Spraxa\CoolR-Group\portal\CoolR.Tasks\ProcessAlertData.cs:line 47 at DFramework.Scheduler.TaskBase.Run() in D:\Spraxa\Framework\DFramework.Scheduler\TaskBase.cs:line 176 at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx) at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx) at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state) at System.Threading.ThreadHelper.ThreadStart() 2025-12-30 04:39:16.4936 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-30 04:39:16.9780 DFramework.Database.NullableDataReader Data reader open for 224 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-30 04:39:17.0405 DFramework.Database.NullableDataReader Data reader open for 308 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-30 04:39:17.5874 DFramework.Database.NullableDataReader Data reader open for 285 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-30 04:39:17.6499 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-30 04:39:18.6811 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-30 04:39:18.7436 DFramework.Database.NullableDataReader Data reader open for 357 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-30 04:39:19.0405 AlertProcessor Replace Tags updated for the Image Id: 3675359 2025-12-30 04:39:19.7124 DFramework.Database.NullableDataReader Data reader open for 253 at System.Environment.GetStackTrace(Exception e, Boolean needFileInfo) at System.Environment.get_StackTrace() at DFramework.Database.NullableDataReader.Dispose(Boolean disposing) in D:\Spraxa\Framework\DFramework\Database\NullableDataReader.cs:line 33 at DFramework.Database.NullableDataReader.Dispose() in D:\Spraxa\Framework\DFramework\Database\NullableDataReader.cs:line 44 at CoolR.Tasks.ProcessAlertData.Execute() in D:\Spraxa\CoolR-Group\portal\CoolR.Tasks\ProcessAlertData.cs:line 47 at DFramework.Scheduler.TaskBase.Run() in D:\Spraxa\Framework\DFramework.Scheduler\TaskBase.cs:line 176 at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx) at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx) at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state) at System.Threading.ThreadHelper.ThreadStart() 2025-12-30 04:39:19.7592 DFramework.Database.NullableDataReader Data reader open for 336 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-30 04:39:20.6030 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-30 04:39:21.6811 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-30 04:39:22.8843 DFramework.Database.NullableDataReader Data reader open for 734 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-30 04:39:22.9312 DFramework.Database.NullableDataReader Data reader open for 818 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-30 04:39:22.9624 AlertProcessor ProcessorAlertData: Stopped 2025-12-30 04:44:13.5895 AlertProcessor ProcessorAlertData: started 2025-12-30 04:44:13.6677 DFramework.Database.Query /* Time Taken: 590*/ [dbo].GenerateSystemAlerts 2025-12-30 04:44:16.5271 DFramework.Database.Query /* Time Taken: 592*/ DECLARE @TableName AnsiString(8000) SET @TableName = 'AssetStockProductWiseConsolidate' DECLARE @CurrentRecordId Int32 SET @CurrentRecordId = '3675359' dbo.GetValidDeviceForAlertProcessData 2025-12-30 04:44:19.0271 AlertProcessor ProcessorAlertData: Stopped 2025-12-30 04:44:28.9178 DFramework.Scheduler.TaskBase /* Time Taken: 15906.3654*/ Opportunity Out Of Stock By Outlet 2025-12-30 04:49:13.6075 AlertProcessor ProcessorAlertData: started 2025-12-30 04:49:18.7794 AlertProcessor ProcessorAlertData: Stopped 2025-12-30 04:54:13.6253 AlertProcessor ProcessorAlertData: started 2025-12-30 04:54:19.3285 AlertProcessor ProcessorAlertData: Stopped 2025-12-30 04:59:13.6431 AlertProcessor ProcessorAlertData: started 2025-12-30 04:59:14.6900 DFramework.Database.NullableDataReader Data reader open for 321 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-30 04:59:14.7525 DFramework.Database.NullableDataReader Data reader open for 407 at System.Environment.GetStackTrace(Exception e, Boolean needFileInfo) at System.Environment.get_StackTrace() at DFramework.Database.NullableDataReader.Dispose(Boolean disposing) in D:\Spraxa\Framework\DFramework\Database\NullableDataReader.cs:line 33 at DFramework.Database.NullableDataReader.Dispose() in D:\Spraxa\Framework\DFramework\Database\NullableDataReader.cs:line 44 at CoolR.Tasks.ProcessAlertData.Execute() in D:\Spraxa\CoolR-Group\portal\CoolR.Tasks\ProcessAlertData.cs:line 47 at DFramework.Scheduler.TaskBase.Run() in D:\Spraxa\Framework\DFramework.Scheduler\TaskBase.cs:line 176 at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx) at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx) at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state) at System.Threading.ThreadHelper.ThreadStart() 2025-12-30 04:59:16.3150 DFramework.Database.NullableDataReader Data reader open for 281 at System.Environment.GetStackTrace(Exception e, Boolean needFileInfo) at System.Environment.get_StackTrace() at DFramework.Database.NullableDataReader.Dispose(Boolean disposing) in D:\Spraxa\Framework\DFramework\Database\NullableDataReader.cs:line 33 at DFramework.Database.NullableDataReader.Dispose() in D:\Spraxa\Framework\DFramework\Database\NullableDataReader.cs:line 44 at CoolR.Tasks.ProcessAlertData.Execute() in D:\Spraxa\CoolR-Group\portal\CoolR.Tasks\ProcessAlertData.cs:line 47 at DFramework.Scheduler.TaskBase.Run() in D:\Spraxa\Framework\DFramework.Scheduler\TaskBase.cs:line 176 at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx) at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx) at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state) at System.Threading.ThreadHelper.ThreadStart() 2025-12-30 04:59:16.7994 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-30 04:59:16.8463 DFramework.Database.NullableDataReader Data reader open for 307 at System.Environment.GetStackTrace(Exception e, Boolean needFileInfo) at System.Environment.get_StackTrace() at DFramework.Database.NullableDataReader.Dispose(Boolean disposing) in D:\Spraxa\Framework\DFramework\Database\NullableDataReader.cs:line 33 at DFramework.Database.NullableDataReader.Dispose() in D:\Spraxa\Framework\DFramework\Database\NullableDataReader.cs:line 44 at CoolR.Tasks.ProcessAlertData.Execute() in D:\Spraxa\CoolR-Group\portal\CoolR.Tasks\ProcessAlertData.cs:line 47 at DFramework.Scheduler.TaskBase.Run() in D:\Spraxa\Framework\DFramework.Scheduler\TaskBase.cs:line 176 at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx) at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx) at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state) at System.Threading.ThreadHelper.ThreadStart() 2025-12-30 04:59:17.3932 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-30 04:59:17.4557 DFramework.Database.NullableDataReader Data reader open for 366 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-30 04:59:18.5963 DFramework.Database.NullableDataReader Data reader open for 220 at System.Environment.GetStackTrace(Exception e, Boolean needFileInfo) at System.Environment.get_StackTrace() at DFramework.Database.NullableDataReader.Dispose(Boolean disposing) in D:\Spraxa\Framework\DFramework\Database\NullableDataReader.cs:line 33 at DFramework.Database.NullableDataReader.Dispose() in D:\Spraxa\Framework\DFramework\Database\NullableDataReader.cs:line 44 at CoolR.Tasks.ProcessAlertData.Execute() in D:\Spraxa\CoolR-Group\portal\CoolR.Tasks\ProcessAlertData.cs:line 47 at DFramework.Scheduler.TaskBase.Run() in D:\Spraxa\Framework\DFramework.Scheduler\TaskBase.cs:line 176 at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx) at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx) at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state) at System.Threading.ThreadHelper.ThreadStart() 2025-12-30 04:59:18.9088 AlertProcessor Replace Tags updated for the Image Id: 3675360 2025-12-30 04:59:19.7369 DFramework.Database.NullableDataReader Data reader open for 468 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-30 04:59:19.7838 DFramework.Database.NullableDataReader Data reader open for 551 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-30 04:59:20.5494 DFramework.Database.NullableDataReader Data reader open for 223 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-30 04:59:21.3776 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-30 04:59:22.4244 DFramework.Database.NullableDataReader Data reader open for 619 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-30 04:59:22.4713 DFramework.Database.NullableDataReader Data reader open for 702 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-30 04:59:22.5026 AlertProcessor ProcessorAlertData: Stopped 2025-12-30 04:59:28.8151 DFramework.Scheduler.TaskBase /* Time Taken: 15781.3222*/ Opportunity Out Of Stock By Outlet 2025-12-30 05:04:13.6610 AlertProcessor ProcessorAlertData: started 2025-12-30 05:04:18.8485 AlertProcessor ProcessorAlertData: Stopped 2025-12-30 05:09:13.6788 AlertProcessor ProcessorAlertData: started 2025-12-30 05:09:18.8976 AlertProcessor ProcessorAlertData: Stopped 2025-12-30 05:14:13.6341 DFramework.Database.Query /* Time Taken: 525*/ [dbo].GenerateSystemAlerts 2025-12-30 05:14:13.6966 AlertProcessor ProcessorAlertData: started 2025-12-30 05:14:18.7592 AlertProcessor ProcessorAlertData: Stopped 2025-12-30 05:14:28.8374 DFramework.Scheduler.TaskBase /* Time Taken: 15781.3665*/ Opportunity Out Of Stock By Outlet 2025-12-30 05:19:13.7144 AlertProcessor ProcessorAlertData: started 2025-12-30 05:19:18.7770 AlertProcessor ProcessorAlertData: Stopped 2025-12-30 05:24:13.7323 AlertProcessor ProcessorAlertData: started 2025-12-30 05:24:18.7635 AlertProcessor ProcessorAlertData: Stopped 2025-12-30 05:29:13.7501 AlertProcessor ProcessorAlertData: started 2025-12-30 05:29:18.9689 AlertProcessor ProcessorAlertData: Stopped 2025-12-30 05:29:28.8440 DFramework.Scheduler.TaskBase /* Time Taken: 15765.7578*/ Opportunity Out Of Stock By Outlet 2025-12-30 05:34:13.4867 MoveToReorder Running task for ClientId : 286 and ClientName = India Office QA and Slot: 12/30/2025 7:00:00 PM And LastExecutedOn: 12/30/2025 6:04:13 PM 2025-12-30 05:34:13.7679 AlertProcessor ProcessorAlertData: started 2025-12-30 05:34:14.2679 DFramework.Database.NullableDataReader Data reader open for 542 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-30 05:34:14.3148 MoveToReorder Task executed successfully for ClientId : 286 Client Name:India Office QA, Slot: 12/30/2025 7:00:00 PM and Total Order Suggested: 1 Out Of: 1 2025-12-30 05:34:19.1742 AlertProcessor ProcessorAlertData: Stopped 2025-12-30 05:39:13.7858 AlertProcessor ProcessorAlertData: started 2025-12-30 05:39:18.8327 AlertProcessor ProcessorAlertData: Stopped 2025-12-30 05:44:13.7256 DFramework.Database.Query /* Time Taken: 576*/ [dbo].GenerateSystemAlerts 2025-12-30 05:44:13.8037 AlertProcessor ProcessorAlertData: started 2025-12-30 05:44:19.2569 DFramework.Database.Query /* Time Taken: 521*/ DECLARE @TableName AnsiString(8000) SET @TableName = 'ProductStockLevel' DECLARE @CurrentRecordId Int32 SET @CurrentRecordId = '3675360' dbo.GetValidDeviceForAlertProcessData 2025-12-30 05:44:19.3038 AlertProcessor ProcessorAlertData: Stopped 2025-12-30 05:44:29.0226 DFramework.Scheduler.TaskBase /* Time Taken: 15921.9901*/ Opportunity Out Of Stock By Outlet 2025-12-30 05:49:13.8215 AlertProcessor ProcessorAlertData: started 2025-12-30 05:49:19.0247 AlertProcessor ProcessorAlertData: Stopped 2025-12-30 05:54:13.8393 AlertProcessor ProcessorAlertData: started 2025-12-30 05:54:18.9331 AlertProcessor ProcessorAlertData: Stopped 2025-12-30 05:59:13.8568 AlertProcessor ProcessorAlertData: started 2025-12-30 05:59:18.9663 AlertProcessor ProcessorAlertData: Stopped 2025-12-30 05:59:28.8882 DFramework.Scheduler.TaskBase /* Time Taken: 15765.725*/ Opportunity Out Of Stock By Outlet 2025-12-30 06:04:13.8590 AlertProcessor ProcessorAlertData: started 2025-12-30 06:04:19.1559 AlertProcessor ProcessorAlertData: Stopped 2025-12-30 06:09:13.8768 AlertProcessor ProcessorAlertData: started 2025-12-30 06:09:19.0956 AlertProcessor ProcessorAlertData: Stopped 2025-12-30 06:14:13.7068 DFramework.Database.Query /* Time Taken: 524*/ [dbo].GenerateSystemAlerts 2025-12-30 06:14:13.8943 AlertProcessor ProcessorAlertData: started 2025-12-30 06:14:19.5193 AlertProcessor ProcessorAlertData: Stopped 2025-12-30 06:14:29.0038 DFramework.Scheduler.TaskBase /* Time Taken: 15875.1032*/ Opportunity Out Of Stock By Outlet 2025-12-30 06:19:13.9120 AlertProcessor ProcessorAlertData: started 2025-12-30 06:19:15.5526 DFramework.Database.Query /* Time Taken: 535*/ DECLARE @TableName AnsiString(8000) SET @TableName = 'AdditionalShelf' DECLARE @CurrentRecordId Int32 SET @CurrentRecordId = '3675360' dbo.GetValidDeviceForAlertProcessData 2025-12-30 06:19:19.4589 AlertProcessor ProcessorAlertData: Stopped 2025-12-30 06:24:13.9298 AlertProcessor ProcessorAlertData: started 2025-12-30 06:24:19.1329 AlertProcessor ProcessorAlertData: Stopped 2025-12-30 06:29:13.6974 DFramework.Database.Query /* Time Taken: 504*/ [dbo].GenerateSystemAlerts 2025-12-30 06:29:13.9474 AlertProcessor ProcessorAlertData: started 2025-12-30 06:29:18.8381 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-30 06:29:19.2912 AlertProcessor ProcessorAlertData: Stopped 2025-12-30 06:29:28.9006 DFramework.Scheduler.TaskBase /* Time Taken: 15750.0922*/ Opportunity Out Of Stock By Outlet 2025-12-30 06:34:13.5900 MoveToReorder Running task for ClientId : 286 and ClientName = India Office QA and Slot: 12/30/2025 8:00:00 PM And LastExecutedOn: 12/30/2025 7:04:13 PM 2025-12-30 06:34:13.9493 AlertProcessor ProcessorAlertData: started 2025-12-30 06:34:14.9337 DFramework.Database.Query /* Time Taken: 633*/ DECLARE @TableName AnsiString(8000) SET @TableName = 'VoidAlert' DECLARE @CurrentRecordId Int32 SET @CurrentRecordId = '3675360' dbo.GetValidDeviceForAlertProcessData 2025-12-30 06:34:19.6681 AlertProcessor ProcessorAlertData: Stopped 2025-12-30 06:34:52.7465 DFramework.Database.NullableDataReader Data reader open for 38847 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-30 06:34:52.7621 MoveToReorder Task executed successfully for ClientId : 286 Client Name:India Office QA, Slot: 12/30/2025 8:00:00 PM and Total Order Suggested: 122 Out Of: 122 2025-12-30 06:34:53.7777 DFramework.Scheduler.TaskBase /* Time Taken: 40500.28*/ Move To Re-Order 2025-12-30 06:39:13.9515 AlertProcessor ProcessorAlertData: started 2025-12-30 06:39:19.0765 DFramework.Database.Query /* Time Taken: 527*/ DECLARE @TableName AnsiString(8000) SET @TableName = 'ProductStockLevel' DECLARE @CurrentRecordId Int32 SET @CurrentRecordId = '3675360' dbo.GetValidDeviceForAlertProcessData 2025-12-30 06:39:19.1234 AlertProcessor ProcessorAlertData: Stopped 2025-12-30 06:44:13.7661 DFramework.Database.Query /* Time Taken: 559*/ [dbo].GenerateSystemAlerts 2025-12-30 06:44:13.9693 AlertProcessor ProcessorAlertData: started 2025-12-30 06:44:19.2506 AlertProcessor ProcessorAlertData: Stopped 2025-12-30 06:44:29.0788 DFramework.Scheduler.TaskBase /* Time Taken: 15906.3682*/ Opportunity Out Of Stock By Outlet 2025-12-30 06:49:13.9869 AlertProcessor ProcessorAlertData: started 2025-12-30 06:49:19.0650 AlertProcessor ProcessorAlertData: Stopped 2025-12-30 06:54:14.0046 AlertProcessor ProcessorAlertData: started 2025-12-30 06:54:19.1140 AlertProcessor ProcessorAlertData: Stopped 2025-12-30 06:59:13.8037 DFramework.Database.Query /* Time Taken: 563*/ [dbo].GenerateSystemAlerts 2025-12-30 06:59:14.0224 AlertProcessor ProcessorAlertData: started 2025-12-30 06:59:19.1318 AlertProcessor ProcessorAlertData: Stopped 2025-12-30 06:59:28.9444 DFramework.Scheduler.TaskBase /* Time Taken: 15750.1175*/ Opportunity Out Of Stock By Outlet 2025-12-30 07:04:14.0401 AlertProcessor ProcessorAlertData: started 2025-12-30 07:04:19.4307 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-30 07:04:19.4307 AlertProcessor ProcessorAlertData: Stopped 2025-12-30 07:09:14.0578 AlertProcessor ProcessorAlertData: started 2025-12-30 07:09:15.2296 DFramework.Database.Query /* Time Taken: 528*/ DECLARE @TableName AnsiString(8000) SET @TableName = 'MissingShelf' DECLARE @CurrentRecordId Int32 SET @CurrentRecordId = '3675360' dbo.GetValidDeviceForAlertProcessData 2025-12-30 07:09:19.4172 AlertProcessor ProcessorAlertData: Stopped 2025-12-30 07:14:13.8568 DFramework.Database.Query /* Time Taken: 607*/ [dbo].GenerateSystemAlerts 2025-12-30 07:14:14.0755 AlertProcessor ProcessorAlertData: started 2025-12-30 07:14:19.4193 AlertProcessor ProcessorAlertData: Stopped 2025-12-30 07:14:29.0913 DFramework.Scheduler.TaskBase /* Time Taken: 15875.1145*/ Opportunity Out Of Stock By Outlet 2025-12-30 07:19:14.0932 AlertProcessor ProcessorAlertData: started 2025-12-30 07:19:15.2651 DFramework.Database.Query /* Time Taken: 505*/ DECLARE @TableName AnsiString(8000) SET @TableName = 'MissingShelf' DECLARE @CurrentRecordId Int32 SET @CurrentRecordId = '3675360' dbo.GetValidDeviceForAlertProcessData 2025-12-30 07:19:17.1401 DFramework.Database.Query /* Time Taken: 503*/ DECLARE @TableName AnsiString(8000) SET @TableName = 'AssetStockProductWiseConsolidate' DECLARE @CurrentRecordId Int32 SET @CurrentRecordId = '3675360' dbo.GetValidDeviceForAlertProcessData 2025-12-30 07:19:19.6870 AlertProcessor ProcessorAlertData: Stopped 2025-12-30 07:24:14.1103 AlertProcessor ProcessorAlertData: started 2025-12-30 07:24:19.5166 AlertProcessor ProcessorAlertData: Stopped 2025-12-30 07:29:13.8466 DFramework.Database.Query /* Time Taken: 566*/ [dbo].GenerateSystemAlerts 2025-12-30 07:29:14.1279 AlertProcessor ProcessorAlertData: started 2025-12-30 07:29:19.3310 AlertProcessor ProcessorAlertData: Stopped 2025-12-30 07:29:29.3623 DFramework.Scheduler.TaskBase /* Time Taken: 16125.11*/ Opportunity Out Of Stock By Outlet 2025-12-30 07:34:13.6769 MoveToReorder Running task for ClientId : 286 and ClientName = India Office QA and Slot: 12/30/2025 9:00:00 PM And LastExecutedOn: 12/30/2025 8:04:13 PM 2025-12-30 07:34:13.9269 MoveToReorder Task executed successfully for ClientId : 286 Client Name:India Office QA, Slot: 12/30/2025 9:00:00 PM But No Order found to suggest 2025-12-30 07:34:14.1456 AlertProcessor ProcessorAlertData: started 2025-12-30 07:34:19.4582 AlertProcessor ProcessorAlertData: Stopped 2025-12-30 07:39:14.1477 AlertProcessor ProcessorAlertData: started 2025-12-30 07:39:19.2415 AlertProcessor ProcessorAlertData: Stopped 2025-12-30 07:44:13.8686 DFramework.Database.Query /* Time Taken: 563*/ [dbo].GenerateSystemAlerts 2025-12-30 07:44:14.1654 AlertProcessor ProcessorAlertData: started 2025-12-30 07:44:17.0561 DFramework.Database.Query /* Time Taken: 571*/ DECLARE @TableName AnsiString(8000) SET @TableName = 'AssetStockProductWiseConsolidate' DECLARE @CurrentRecordId Int32 SET @CurrentRecordId = '3675360' dbo.GetValidDeviceForAlertProcessData 2025-12-30 07:44:19.4624 AlertProcessor ProcessorAlertData: Stopped 2025-12-30 07:44:29.0562 DFramework.Scheduler.TaskBase /* Time Taken: 15796.9907*/ Opportunity Out Of Stock By Outlet 2025-12-30 07:49:14.1833 AlertProcessor ProcessorAlertData: started 2025-12-30 07:49:19.2770 AlertProcessor ProcessorAlertData: Stopped 2025-12-30 07:54:14.2011 AlertProcessor ProcessorAlertData: started 2025-12-30 07:54:19.3573 AlertProcessor ProcessorAlertData: Stopped 2025-12-30 07:59:14.2189 AlertProcessor ProcessorAlertData: started 2025-12-30 07:59:18.5002 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-30 07:59:19.5314 AlertProcessor ProcessorAlertData: Stopped 2025-12-30 07:59:29.0784 DFramework.Scheduler.TaskBase /* Time Taken: 15796.9963*/ Opportunity Out Of Stock By Outlet 2025-12-30 08:04:14.2367 AlertProcessor ProcessorAlertData: started 2025-12-30 08:04:19.2836 AlertProcessor ProcessorAlertData: Stopped 2025-12-30 08:09:14.2545 AlertProcessor ProcessorAlertData: started 2025-12-30 08:09:19.3795 AlertProcessor ProcessorAlertData: Stopped 2025-12-30 08:14:13.8661 DFramework.Database.Query /* Time Taken: 525*/ [dbo].GenerateSystemAlerts 2025-12-30 08:14:14.2724 AlertProcessor ProcessorAlertData: started 2025-12-30 08:14:19.3818 AlertProcessor ProcessorAlertData: Stopped 2025-12-30 08:14:29.0850 DFramework.Scheduler.TaskBase /* Time Taken: 15796.9813*/ Opportunity Out Of Stock By Outlet 2025-12-30 08:19:14.2902 AlertProcessor ProcessorAlertData: started 2025-12-30 08:19:19.8061 AlertProcessor ProcessorAlertData: Stopped 2025-12-30 08:24:14.3081 AlertProcessor ProcessorAlertData: started 2025-12-30 08:24:19.8393 AlertProcessor ProcessorAlertData: Stopped 2025-12-30 08:29:13.9041 DFramework.Database.Query /* Time Taken: 546*/ [dbo].GenerateSystemAlerts 2025-12-30 08:29:14.3260 AlertProcessor ProcessorAlertData: started 2025-12-30 08:29:19.9198 AlertProcessor ProcessorAlertData: Stopped 2025-12-30 08:29:29.1230 DFramework.Scheduler.TaskBase /* Time Taken: 15812.6299*/ Opportunity Out Of Stock By Outlet 2025-12-30 08:34:13.7502 MoveToReorder Running task for ClientId : 286 and ClientName = India Office QA and Slot: 12/30/2025 10:00:00 PM And LastExecutedOn: 12/30/2025 9:04:13 PM 2025-12-30 08:34:14.3439 AlertProcessor ProcessorAlertData: started 2025-12-30 08:34:14.6408 DFramework.Database.NullableDataReader Data reader open for 688 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-30 08:34:14.6720 MoveToReorder Task executed successfully for ClientId : 286 Client Name:India Office QA, Slot: 12/30/2025 10:00:00 PM and Total Order Suggested: 1 Out Of: 1 2025-12-30 08:34:15.8127 DFramework.Database.Query /* Time Taken: 595*/ DECLARE @TableName AnsiString(8000) SET @TableName = 'MissingShelf' DECLARE @CurrentRecordId Int32 SET @CurrentRecordId = '3675360' dbo.GetValidDeviceForAlertProcessData 2025-12-30 08:34:20.5315 DFramework.Database.Query /* Time Taken: 664*/ DECLARE @TableName AnsiString(8000) SET @TableName = 'ProductStockLevel' DECLARE @CurrentRecordId Int32 SET @CurrentRecordId = '3675360' dbo.GetValidDeviceForAlertProcessData 2025-12-30 08:34:20.5940 AlertProcessor ProcessorAlertData: Stopped 2025-12-30 08:39:14.3618 AlertProcessor ProcessorAlertData: started 2025-12-30 08:39:20.1431 AlertProcessor ProcessorAlertData: Stopped 2025-12-30 08:44:13.9733 DFramework.Database.Query /* Time Taken: 601*/ [dbo].GenerateSystemAlerts 2025-12-30 08:44:14.3796 AlertProcessor ProcessorAlertData: started 2025-12-30 08:44:16.2077 DFramework.Database.Query /* Time Taken: 640*/ DECLARE @TableName AnsiString(8000) SET @TableName = 'AdditionalShelf' DECLARE @CurrentRecordId Int32 SET @CurrentRecordId = '3675360' dbo.GetValidDeviceForAlertProcessData 2025-12-30 08:44:20.2546 AlertProcessor ProcessorAlertData: Stopped 2025-12-30 08:44:29.1766 DFramework.Scheduler.TaskBase /* Time Taken: 15843.858*/ Opportunity Out Of Stock By Outlet 2025-12-30 08:49:14.3974 AlertProcessor ProcessorAlertData: started 2025-12-30 08:49:19.9755 AlertProcessor ProcessorAlertData: Stopped 2025-12-30 08:54:14.4152 AlertProcessor ProcessorAlertData: started 2025-12-30 08:54:20.0246 AlertProcessor ProcessorAlertData: Stopped 2025-12-30 08:59:13.9486 DFramework.Database.Query /* Time Taken: 558*/ [dbo].GenerateSystemAlerts 2025-12-30 08:59:14.4330 AlertProcessor ProcessorAlertData: started 2025-12-30 08:59:20.0580 AlertProcessor ProcessorAlertData: Stopped 2025-12-30 08:59:29.1675 DFramework.Scheduler.TaskBase /* Time Taken: 15812.6184*/ Opportunity Out Of Stock By Outlet 2025-12-30 09:04:14.4344 AlertProcessor ProcessorAlertData: started 2025-12-30 09:04:20.2000 AlertProcessor ProcessorAlertData: Stopped 2025-12-30 09:09:14.4360 AlertProcessor ProcessorAlertData: started 2025-12-30 09:09:20.0142 AlertProcessor ProcessorAlertData: Stopped 2025-12-30 09:14:14.0786 DFramework.Database.Query /* Time Taken: 661*/ [dbo].GenerateSystemAlerts 2025-12-30 09:14:14.4537 AlertProcessor ProcessorAlertData: started 2025-12-30 09:14:20.3131 AlertProcessor ProcessorAlertData: Stopped 2025-12-30 09:14:29.2194 DFramework.Scheduler.TaskBase /* Time Taken: 15843.8211*/ Opportunity Out Of Stock By Outlet 2025-12-30 09:19:14.4712 AlertProcessor ProcessorAlertData: started 2025-12-30 09:19:20.1743 AlertProcessor ProcessorAlertData: Stopped 2025-12-30 09:24:14.4882 AlertProcessor ProcessorAlertData: started 2025-12-30 09:24:20.0663 AlertProcessor ProcessorAlertData: Stopped 2025-12-30 09:29:13.9901 DFramework.Database.Query /* Time Taken: 560*/ [dbo].GenerateSystemAlerts 2025-12-30 09:29:14.5058 AlertProcessor ProcessorAlertData: started 2025-12-30 09:29:20.1464 AlertProcessor ProcessorAlertData: Stopped 2025-12-30 09:29:29.1934 DFramework.Scheduler.TaskBase /* Time Taken: 15797.0209*/ Opportunity Out Of Stock By Outlet 2025-12-30 09:34:14.5235 AlertProcessor ProcessorAlertData: started 2025-12-30 09:34:20.1329 AlertProcessor ProcessorAlertData: Stopped 2025-12-30 09:39:14.5251 AlertProcessor ProcessorAlertData: started 2025-12-30 09:39:20.1345 AlertProcessor ProcessorAlertData: Stopped 2025-12-30 09:44:14.0426 DFramework.Database.Query /* Time Taken: 579*/ [dbo].GenerateSystemAlerts 2025-12-30 09:44:14.5426 AlertProcessor ProcessorAlertData: started 2025-12-30 09:44:20.1989 AlertProcessor ProcessorAlertData: Stopped 2025-12-30 09:44:29.2302 DFramework.Scheduler.TaskBase /* Time Taken: 15828.234*/ Opportunity Out Of Stock By Outlet 2025-12-30 09:49:14.5604 AlertProcessor ProcessorAlertData: started 2025-12-30 09:49:16.3104 DFramework.Database.Query /* Time Taken: 586*/ DECLARE @TableName AnsiString(8000) SET @TableName = 'AdditionalShelf' DECLARE @CurrentRecordId Int32 SET @CurrentRecordId = '3675360' dbo.GetValidDeviceForAlertProcessData 2025-12-30 09:49:20.3729 AlertProcessor ProcessorAlertData: Stopped 2025-12-30 09:54:14.5778 AlertProcessor ProcessorAlertData: started 2025-12-30 09:54:20.2184 AlertProcessor ProcessorAlertData: Stopped 2025-12-30 09:59:14.0169 DFramework.Database.Query /* Time Taken: 535*/ [dbo].GenerateSystemAlerts 2025-12-30 09:59:14.5950 AlertProcessor ProcessorAlertData: started 2025-12-30 09:59:20.2669 AlertProcessor ProcessorAlertData: Stopped 2025-12-30 09:59:29.2826 DFramework.Scheduler.TaskBase /* Time Taken: 15875.1024*/ Opportunity Out Of Stock By Outlet 2025-12-30 10:04:14.6126 AlertProcessor ProcessorAlertData: started 2025-12-30 10:04:20.3939 AlertProcessor ProcessorAlertData: Stopped 2025-12-30 10:09:14.6304 AlertProcessor ProcessorAlertData: started 2025-12-30 10:09:20.2398 AlertProcessor ProcessorAlertData: Stopped 2025-12-30 10:14:14.1475 DFramework.Database.Query /* Time Taken: 649*/ [dbo].GenerateSystemAlerts 2025-12-30 10:14:14.6475 AlertProcessor ProcessorAlertData: started 2025-12-30 10:14:20.3351 AlertProcessor ProcessorAlertData: Stopped 2025-12-30 10:14:29.3976 DFramework.Scheduler.TaskBase /* Time Taken: 15968.8471*/ Opportunity Out Of Stock By Outlet 2025-12-30 10:19:14.6651 AlertProcessor ProcessorAlertData: started 2025-12-30 10:19:20.2276 AlertProcessor ProcessorAlertData: Stopped 2025-12-30 10:24:14.6672 AlertProcessor ProcessorAlertData: started 2025-12-30 10:24:20.2454 AlertProcessor ProcessorAlertData: Stopped 2025-12-30 10:29:14.1219 DFramework.Database.Query /* Time Taken: 616*/ [dbo].GenerateSystemAlerts 2025-12-30 10:29:14.6845 AlertProcessor ProcessorAlertData: started 2025-12-30 10:29:20.4345 AlertProcessor ProcessorAlertData: Stopped 2025-12-30 10:29:29.4189 DFramework.Scheduler.TaskBase /* Time Taken: 15968.8187*/ Opportunity Out Of Stock By Outlet 2025-12-30 10:34:14.7018 AlertProcessor ProcessorAlertData: started 2025-12-30 10:34:20.2956 AlertProcessor ProcessorAlertData: Stopped 2025-12-30 10:39:14.7194 AlertProcessor ProcessorAlertData: started 2025-12-30 10:39:20.5320 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-30 10:39:20.5476 AlertProcessor ProcessorAlertData: Stopped 2025-12-30 10:44:14.0808 DFramework.Database.Query /* Time Taken: 551*/ [dbo].GenerateSystemAlerts 2025-12-30 10:44:14.7370 AlertProcessor ProcessorAlertData: started 2025-12-30 10:44:16.1746 DFramework.Database.Query /* Time Taken: 715*/ DECLARE @TableName AnsiString(8000) SET @TableName = 'MissingShelf' DECLARE @CurrentRecordId Int32 SET @CurrentRecordId = '3675360' dbo.GetValidDeviceForAlertProcessData 2025-12-30 10:44:20.5808 AlertProcessor ProcessorAlertData: Stopped 2025-12-30 10:44:29.3309 DFramework.Scheduler.TaskBase /* Time Taken: 15859.4303*/ Opportunity Out Of Stock By Outlet 2025-12-30 10:49:14.7542 AlertProcessor ProcessorAlertData: started 2025-12-30 10:49:20.4261 AlertProcessor ProcessorAlertData: Stopped 2025-12-30 10:54:14.7717 AlertProcessor ProcessorAlertData: started 2025-12-30 10:54:20.3968 AlertProcessor ProcessorAlertData: Stopped 2025-12-30 10:59:14.2113 DFramework.Database.Query /* Time Taken: 664*/ [dbo].GenerateSystemAlerts 2025-12-30 10:59:14.7895 AlertProcessor ProcessorAlertData: started 2025-12-30 10:59:20.3833 AlertProcessor ProcessorAlertData: Stopped 2025-12-30 10:59:29.4146 DFramework.Scheduler.TaskBase /* Time Taken: 15937.6106*/ Opportunity Out Of Stock By Outlet 2025-12-30 11:04:14.8066 AlertProcessor ProcessorAlertData: started 2025-12-30 11:04:20.4785 AlertProcessor ProcessorAlertData: Stopped 2025-12-30 11:09:14.8240 AlertProcessor ProcessorAlertData: started 2025-12-30 11:09:20.3710 AlertProcessor ProcessorAlertData: Stopped 2025-12-30 11:14:14.1542 DFramework.Database.Query /* Time Taken: 607*/ [dbo].GenerateSystemAlerts 2025-12-30 11:14:14.8417 AlertProcessor ProcessorAlertData: started 2025-12-30 11:14:20.6386 AlertProcessor ProcessorAlertData: Stopped 2025-12-30 11:14:29.3262 DFramework.Scheduler.TaskBase /* Time Taken: 15828.2373*/ Opportunity Out Of Stock By Outlet 2025-12-30 11:19:14.8592 AlertProcessor ProcessorAlertData: started 2025-12-30 11:19:20.5624 AlertProcessor ProcessorAlertData: Stopped 2025-12-30 11:24:14.8609 AlertProcessor ProcessorAlertData: started 2025-12-30 11:24:20.4859 AlertProcessor ProcessorAlertData: Stopped 2025-12-30 11:29:14.2067 DFramework.Database.Query /* Time Taken: 651*/ [dbo].GenerateSystemAlerts 2025-12-30 11:29:14.8785 AlertProcessor ProcessorAlertData: started 2025-12-30 11:29:20.4411 AlertProcessor ProcessorAlertData: Stopped 2025-12-30 11:29:29.4568 DFramework.Scheduler.TaskBase /* Time Taken: 15937.6141*/ Opportunity Out Of Stock By Outlet 2025-12-30 11:34:14.8963 AlertProcessor ProcessorAlertData: started 2025-12-30 11:34:20.5213 AlertProcessor ProcessorAlertData: Stopped 2025-12-30 11:39:14.9134 AlertProcessor ProcessorAlertData: started 2025-12-30 11:39:20.4447 AlertProcessor ProcessorAlertData: Stopped 2025-12-30 11:44:14.1653 DFramework.Database.Query /* Time Taken: 581*/ [dbo].GenerateSystemAlerts 2025-12-30 11:44:14.9309 AlertProcessor ProcessorAlertData: started 2025-12-30 11:44:20.5715 AlertProcessor ProcessorAlertData: Stopped 2025-12-30 11:44:29.4310 DFramework.Scheduler.TaskBase /* Time Taken: 15890.7305*/ Opportunity Out Of Stock By Outlet 2025-12-30 11:49:14.9486 AlertProcessor ProcessorAlertData: started 2025-12-30 11:49:20.5267 AlertProcessor ProcessorAlertData: Stopped 2025-12-30 11:54:14.9659 AlertProcessor ProcessorAlertData: started 2025-12-30 11:54:20.5754 AlertProcessor ProcessorAlertData: Stopped 2025-12-30 11:59:13.9052 DFramework.Database.NullableDataReader Data reader open for 320 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-30 11:59:14.2333 DFramework.Database.Query /* Time Taken: 626*/ [dbo].GenerateSystemAlerts 2025-12-30 11:59:14.9677 AlertProcessor ProcessorAlertData: started 2025-12-30 11:59:20.5459 AlertProcessor ProcessorAlertData: Stopped 2025-12-30 11:59:29.7022 DFramework.Scheduler.TaskBase /* Time Taken: 16140.7202*/ Opportunity Out Of Stock By Outlet 2025-12-30 12:04:14.9854 AlertProcessor ProcessorAlertData: started 2025-12-30 12:04:20.6260 AlertProcessor ProcessorAlertData: Stopped 2025-12-30 12:09:15.0030 AlertProcessor ProcessorAlertData: started 2025-12-30 12:09:20.5968 AlertProcessor ProcessorAlertData: Stopped 2025-12-30 12:14:14.2075 DFramework.Database.Query /* Time Taken: 579*/ [dbo].GenerateSystemAlerts 2025-12-30 12:14:15.0044 AlertProcessor ProcessorAlertData: started 2025-12-30 12:14:20.6138 AlertProcessor ProcessorAlertData: Stopped 2025-12-30 12:14:29.4107 DFramework.Scheduler.TaskBase /* Time Taken: 15828.2172*/ Opportunity Out Of Stock By Outlet 2025-12-30 12:19:15.0219 AlertProcessor ProcessorAlertData: started 2025-12-30 12:19:20.6314 AlertProcessor ProcessorAlertData: Stopped 2025-12-30 12:24:15.0396 AlertProcessor ProcessorAlertData: started 2025-12-30 12:24:20.6491 AlertProcessor ProcessorAlertData: Stopped 2025-12-30 12:29:14.1975 DFramework.Database.Query /* Time Taken: 561*/ [dbo].GenerateSystemAlerts 2025-12-30 12:29:15.0568 AlertProcessor ProcessorAlertData: started 2025-12-30 12:29:20.6819 AlertProcessor ProcessorAlertData: Stopped 2025-12-30 12:29:29.4319 DFramework.Scheduler.TaskBase /* Time Taken: 15828.2097*/ Opportunity Out Of Stock By Outlet 2025-12-30 12:34:15.0743 AlertProcessor ProcessorAlertData: started 2025-12-30 12:34:20.5899 AlertProcessor ProcessorAlertData: Stopped 2025-12-30 12:39:15.0919 AlertProcessor ProcessorAlertData: started 2025-12-30 12:39:20.6701 AlertProcessor ProcessorAlertData: Stopped 2025-12-30 12:44:14.2344 DFramework.Database.Query /* Time Taken: 576*/ [dbo].GenerateSystemAlerts 2025-12-30 12:44:15.0938 AlertProcessor ProcessorAlertData: started 2025-12-30 12:44:20.6564 AlertProcessor ProcessorAlertData: Stopped 2025-12-30 12:44:29.5470 DFramework.Scheduler.TaskBase /* Time Taken: 15921.9386*/ Opportunity Out Of Stock By Outlet 2025-12-30 12:49:15.1112 AlertProcessor ProcessorAlertData: started 2025-12-30 12:49:20.6581 AlertProcessor ProcessorAlertData: Stopped 2025-12-30 12:54:15.1288 AlertProcessor ProcessorAlertData: started 2025-12-30 12:54:16.5507 DFramework.Database.Query /* Time Taken: 720*/ DECLARE @TableName AnsiString(8000) SET @TableName = 'MissingShelf' DECLARE @CurrentRecordId Int32 SET @CurrentRecordId = '3675360' dbo.GetValidDeviceForAlertProcessData 2025-12-30 12:54:21.0195 AlertProcessor ProcessorAlertData: Stopped 2025-12-30 12:59:15.1465 AlertProcessor ProcessorAlertData: started 2025-12-30 12:59:20.2715 AlertProcessor ProcessorAlertData: Stopped 2025-12-30 12:59:29.3966 DFramework.Scheduler.TaskBase /* Time Taken: 15750.1078*/ Opportunity Out Of Stock By Outlet 2025-12-30 13:04:15.1636 AlertProcessor ProcessorAlertData: started 2025-12-30 13:04:20.9292 AlertProcessor ProcessorAlertData: Stopped 2025-12-30 13:09:15.1654 AlertProcessor ProcessorAlertData: started 2025-12-30 13:09:18.3373 DFramework.Database.Query /* Time Taken: 513*/ DECLARE @TableName AnsiString(8000) SET @TableName = 'AssetStockProductWiseConsolidate' DECLARE @CurrentRecordId Int32 SET @CurrentRecordId = '3675360' dbo.GetValidDeviceForAlertProcessData 2025-12-30 13:09:21.0248 AlertProcessor ProcessorAlertData: Stopped 2025-12-30 13:14:14.3237 DFramework.Database.Query /* Time Taken: 622*/ [dbo].GenerateSystemAlerts 2025-12-30 13:14:15.1831 AlertProcessor ProcessorAlertData: started 2025-12-30 13:14:18.3550 DFramework.Database.Query /* Time Taken: 560*/ DECLARE @TableName AnsiString(8000) SET @TableName = 'AssetStockProductWiseConsolidate' DECLARE @CurrentRecordId Int32 SET @CurrentRecordId = '3675360' dbo.GetValidDeviceForAlertProcessData 2025-12-30 13:14:21.0112 AlertProcessor ProcessorAlertData: Stopped 2025-12-30 13:14:29.4644 DFramework.Scheduler.TaskBase /* Time Taken: 15796.9896*/ Opportunity Out Of Stock By Outlet 2025-12-30 13:19:15.2004 AlertProcessor ProcessorAlertData: started 2025-12-30 13:19:20.7161 AlertProcessor ProcessorAlertData: Stopped 2025-12-30 13:24:15.2177 AlertProcessor ProcessorAlertData: started 2025-12-30 13:24:18.3896 DFramework.Database.Query /* Time Taken: 619*/ DECLARE @TableName AnsiString(8000) SET @TableName = 'AssetStockProductWiseConsolidate' DECLARE @CurrentRecordId Int32 SET @CurrentRecordId = '3675360' dbo.GetValidDeviceForAlertProcessData 2025-12-30 13:24:21.0146 AlertProcessor ProcessorAlertData: Stopped 2025-12-30 13:29:14.2666 DFramework.Database.Query /* Time Taken: 541*/ [dbo].GenerateSystemAlerts 2025-12-30 13:29:15.2353 AlertProcessor ProcessorAlertData: started 2025-12-30 13:29:20.9698 AlertProcessor ProcessorAlertData: Stopped 2025-12-30 13:29:29.5948 DFramework.Scheduler.TaskBase /* Time Taken: 15906.3621*/ Opportunity Out Of Stock By Outlet 2025-12-30 13:34:15.2531 AlertProcessor ProcessorAlertData: started 2025-12-30 13:34:19.5656 DFramework.Database.NullableDataReader Data reader open for 281 at System.Environment.GetStackTrace(Exception e, Boolean needFileInfo) at System.Environment.get_StackTrace() at DFramework.Database.NullableDataReader.Dispose(Boolean disposing) in D:\Spraxa\Framework\DFramework\Database\NullableDataReader.cs:line 33 at DFramework.Database.NullableDataReader.Dispose() in D:\Spraxa\Framework\DFramework\Database\NullableDataReader.cs:line 44 at CoolR.Tasks.ProcessAlertData.Execute() in D:\Spraxa\CoolR-Group\portal\CoolR.Tasks\ProcessAlertData.cs:line 47 at DFramework.Scheduler.TaskBase.Run() in D:\Spraxa\Framework\DFramework.Scheduler\TaskBase.cs:line 176 at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx) at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx) at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state) at System.Threading.ThreadHelper.ThreadStart() 2025-12-30 13:34:21.2375 AlertProcessor ProcessorAlertData: Stopped 2025-12-30 13:39:15.2702 AlertProcessor ProcessorAlertData: started 2025-12-30 13:39:16.5202 DFramework.Database.Query /* Time Taken: 547*/ DECLARE @TableName AnsiString(8000) SET @TableName = 'MissingShelf' DECLARE @CurrentRecordId Int32 SET @CurrentRecordId = '3675360' dbo.GetValidDeviceForAlertProcessData 2025-12-30 13:39:20.9733 AlertProcessor ProcessorAlertData: Stopped 2025-12-30 13:44:14.3502 DFramework.Database.Query /* Time Taken: 605*/ [dbo].GenerateSystemAlerts 2025-12-30 13:44:15.2877 AlertProcessor ProcessorAlertData: started 2025-12-30 13:44:21.0690 AlertProcessor ProcessorAlertData: Stopped 2025-12-30 13:44:29.5066 DFramework.Scheduler.TaskBase /* Time Taken: 15796.9822*/ Opportunity Out Of Stock By Outlet 2025-12-30 13:49:15.3054 AlertProcessor ProcessorAlertData: started 2025-12-30 13:49:18.4773 DFramework.Database.Query /* Time Taken: 591*/ DECLARE @TableName AnsiString(8000) SET @TableName = 'AssetStockProductWiseConsolidate' DECLARE @CurrentRecordId Int32 SET @CurrentRecordId = '3675360' dbo.GetValidDeviceForAlertProcessData 2025-12-30 13:49:21.0555 AlertProcessor ProcessorAlertData: Stopped 2025-12-30 13:54:15.3226 AlertProcessor ProcessorAlertData: started 2025-12-30 13:54:20.9008 AlertProcessor ProcessorAlertData: Stopped 2025-12-30 13:59:14.2931 DFramework.Database.Query /* Time Taken: 526*/ [dbo].GenerateSystemAlerts 2025-12-30 13:59:15.3400 AlertProcessor ProcessorAlertData: started 2025-12-30 13:59:20.9338 AlertProcessor ProcessorAlertData: Stopped 2025-12-30 13:59:29.4807 DFramework.Scheduler.TaskBase /* Time Taken: 15750.0998*/ Opportunity Out Of Stock By Outlet 2025-12-30 14:04:15.3576 AlertProcessor ProcessorAlertData: started 2025-12-30 14:04:20.9983 AlertProcessor ProcessorAlertData: Stopped 2025-12-30 14:09:15.3751 AlertProcessor ProcessorAlertData: started 2025-12-30 14:09:20.8908 AlertProcessor ProcessorAlertData: Stopped 2025-12-30 14:14:14.3767 DFramework.Database.Query /* Time Taken: 578*/ [dbo].GenerateSystemAlerts 2025-12-30 14:14:15.3923 AlertProcessor ProcessorAlertData: started 2025-12-30 14:14:20.9549 AlertProcessor ProcessorAlertData: Stopped 2025-12-30 14:14:29.5487 DFramework.Scheduler.TaskBase /* Time Taken: 15796.967*/ Opportunity Out Of Stock By Outlet 2025-12-30 14:19:15.4099 AlertProcessor ProcessorAlertData: started 2025-12-30 14:19:20.9568 AlertProcessor ProcessorAlertData: Stopped 2025-12-30 14:24:15.4276 AlertProcessor ProcessorAlertData: started 2025-12-30 14:24:21.0526 AlertProcessor ProcessorAlertData: Stopped 2025-12-30 14:29:14.3511 DFramework.Database.Query /* Time Taken: 537*/ [dbo].GenerateSystemAlerts 2025-12-30 14:29:15.4292 AlertProcessor ProcessorAlertData: started 2025-12-30 14:29:20.7886 AlertProcessor ProcessorAlertData: Stopped 2025-12-30 14:29:29.6793 DFramework.Scheduler.TaskBase /* Time Taken: 15906.3369*/ Opportunity Out Of Stock By Outlet 2025-12-30 14:34:15.4467 AlertProcessor ProcessorAlertData: started 2025-12-30 14:34:21.0874 AlertProcessor ProcessorAlertData: Stopped 2025-12-30 14:39:15.4644 AlertProcessor ProcessorAlertData: started 2025-12-30 14:39:21.0425 AlertProcessor ProcessorAlertData: Stopped 2025-12-30 14:44:14.4193 DFramework.Database.Query /* Time Taken: 582*/ [dbo].GenerateSystemAlerts 2025-12-30 14:44:15.4818 AlertProcessor ProcessorAlertData: started 2025-12-30 14:44:21.0599 AlertProcessor ProcessorAlertData: Stopped 2025-12-30 14:44:29.5912 DFramework.Scheduler.TaskBase /* Time Taken: 15812.5736*/ Opportunity Out Of Stock By Outlet 2025-12-30 14:49:15.4834 AlertProcessor ProcessorAlertData: started 2025-12-30 14:49:21.1085 AlertProcessor ProcessorAlertData: Stopped 2025-12-30 14:54:15.5010 AlertProcessor ProcessorAlertData: started 2025-12-30 14:54:21.0792 AlertProcessor ProcessorAlertData: Stopped 2025-12-30 14:59:14.4093 DFramework.Database.Query /* Time Taken: 547*/ [dbo].GenerateSystemAlerts 2025-12-30 14:59:15.5187 AlertProcessor ProcessorAlertData: started 2025-12-30 14:59:21.1281 AlertProcessor ProcessorAlertData: Stopped 2025-12-30 14:59:29.5969 DFramework.Scheduler.TaskBase /* Time Taken: 15796.964*/ Opportunity Out Of Stock By Outlet 2025-12-30 15:04:15.5203 AlertProcessor ProcessorAlertData: started 2025-12-30 15:04:21.1141 AlertProcessor ProcessorAlertData: Stopped 2025-12-30 15:09:15.5222 AlertProcessor ProcessorAlertData: started 2025-12-30 15:09:21.0379 AlertProcessor ProcessorAlertData: Stopped 2025-12-30 15:14:14.4462 DFramework.Database.Query /* Time Taken: 575*/ [dbo].GenerateSystemAlerts 2025-12-30 15:14:15.5399 AlertProcessor ProcessorAlertData: started 2025-12-30 15:14:21.1962 AlertProcessor ProcessorAlertData: Stopped 2025-12-30 15:14:29.6338 DFramework.Scheduler.TaskBase /* Time Taken: 15812.6075*/ Opportunity Out Of Stock By Outlet 2025-12-30 15:19:15.5572 AlertProcessor ProcessorAlertData: started 2025-12-30 15:19:21.0885 AlertProcessor ProcessorAlertData: Stopped 2025-12-30 15:24:15.5746 AlertProcessor ProcessorAlertData: started 2025-12-30 15:24:21.1215 AlertProcessor ProcessorAlertData: Stopped 2025-12-30 15:29:14.4516 DFramework.Database.Query /* Time Taken: 557*/ [dbo].GenerateSystemAlerts 2025-12-30 15:29:15.5923 AlertProcessor ProcessorAlertData: started 2025-12-30 15:29:21.2173 AlertProcessor ProcessorAlertData: Stopped 2025-12-30 15:29:29.6705 DFramework.Scheduler.TaskBase /* Time Taken: 15828.2301*/ Opportunity Out Of Stock By Outlet 2025-12-30 15:34:15.6099 AlertProcessor ProcessorAlertData: started 2025-12-30 15:34:21.0943 AlertProcessor ProcessorAlertData: Stopped 2025-12-30 15:39:15.6270 AlertProcessor ProcessorAlertData: started 2025-12-30 15:39:21.2365 AlertProcessor ProcessorAlertData: Stopped 2025-12-30 15:44:14.5040 DFramework.Database.Query /* Time Taken: 593*/ [dbo].GenerateSystemAlerts 2025-12-30 15:44:15.6446 AlertProcessor ProcessorAlertData: started 2025-12-30 15:44:21.1290 AlertProcessor ProcessorAlertData: Stopped 2025-12-30 15:44:29.6447 DFramework.Scheduler.TaskBase /* Time Taken: 15781.3672*/ Opportunity Out Of Stock By Outlet 2025-12-30 15:49:15.6623 AlertProcessor ProcessorAlertData: started 2025-12-30 15:49:21.3029 AlertProcessor ProcessorAlertData: Stopped 2025-12-30 15:54:15.6639 AlertProcessor ProcessorAlertData: started 2025-12-30 15:54:21.1795 AlertProcessor ProcessorAlertData: Stopped 2025-12-30 15:59:14.4625 DFramework.Database.Query /* Time Taken: 535*/ [dbo].GenerateSystemAlerts 2025-12-30 15:59:15.6813 AlertProcessor ProcessorAlertData: started 2025-12-30 15:59:21.3220 AlertProcessor ProcessorAlertData: Stopped 2025-12-30 15:59:29.7127 DFramework.Scheduler.TaskBase /* Time Taken: 15828.2298*/ Opportunity Out Of Stock By Outlet 2025-12-30 16:04:15.6989 AlertProcessor ProcessorAlertData: started 2025-12-30 16:04:21.3084 AlertProcessor ProcessorAlertData: Stopped 2025-12-30 16:09:15.7164 AlertProcessor ProcessorAlertData: started 2025-12-30 16:09:21.3726 AlertProcessor ProcessorAlertData: Stopped 2025-12-30 16:14:14.5304 DFramework.Database.Query /* Time Taken: 592*/ [dbo].GenerateSystemAlerts 2025-12-30 16:14:15.7335 AlertProcessor ProcessorAlertData: started 2025-12-30 16:14:21.3898 AlertProcessor ProcessorAlertData: Stopped 2025-12-30 16:14:29.7024 DFramework.Scheduler.TaskBase /* Time Taken: 15812.5922*/ Opportunity Out Of Stock By Outlet 2025-12-30 16:19:15.7511 AlertProcessor ProcessorAlertData: started 2025-12-30 16:19:21.3449 AlertProcessor ProcessorAlertData: Stopped 2025-12-30 16:24:15.7688 AlertProcessor ProcessorAlertData: started 2025-12-30 16:24:21.3938 AlertProcessor ProcessorAlertData: Stopped 2025-12-30 16:29:14.5048 DFramework.Database.Query /* Time Taken: 539*/ [dbo].GenerateSystemAlerts 2025-12-30 16:29:15.7861 AlertProcessor ProcessorAlertData: started 2025-12-30 16:29:21.4736 AlertProcessor ProcessorAlertData: Stopped 2025-12-30 16:29:29.7549 DFramework.Scheduler.TaskBase /* Time Taken: 15843.8473*/ Opportunity Out Of Stock By Outlet 2025-12-30 16:34:15.8036 AlertProcessor ProcessorAlertData: started 2025-12-30 16:34:21.3037 AlertProcessor ProcessorAlertData: Stopped 2025-12-30 16:39:15.8213 AlertProcessor ProcessorAlertData: started 2025-12-30 16:39:21.2588 AlertProcessor ProcessorAlertData: Stopped 2025-12-30 16:44:14.6042 DFramework.Database.Query /* Time Taken: 616*/ [dbo].GenerateSystemAlerts 2025-12-30 16:44:15.8386 AlertProcessor ProcessorAlertData: started 2025-12-30 16:44:21.2762 AlertProcessor ProcessorAlertData: Stopped 2025-12-30 16:44:29.7449 DFramework.Scheduler.TaskBase /* Time Taken: 15812.5775*/ Opportunity Out Of Stock By Outlet 2025-12-30 16:49:15.8559 AlertProcessor ProcessorAlertData: started 2025-12-30 16:49:21.4497 AlertProcessor ProcessorAlertData: Stopped 2025-12-30 16:54:15.8735 AlertProcessor ProcessorAlertData: started 2025-12-30 16:54:21.4829 AlertProcessor ProcessorAlertData: Stopped 2025-12-30 16:59:14.5630 DFramework.Database.Query /* Time Taken: 558*/ [dbo].GenerateSystemAlerts 2025-12-30 16:59:15.8755 AlertProcessor ProcessorAlertData: started 2025-12-30 16:59:21.5475 AlertProcessor ProcessorAlertData: Stopped 2025-12-30 16:59:29.7506 DFramework.Scheduler.TaskBase /* Time Taken: 15796.9298*/ Opportunity Out Of Stock By Outlet 2025-12-30 17:04:15.8927 AlertProcessor ProcessorAlertData: started 2025-12-30 17:04:21.6271 AlertProcessor ProcessorAlertData: Stopped 2025-12-30 17:09:15.9102 AlertProcessor ProcessorAlertData: started 2025-12-30 17:09:21.5821 AlertProcessor ProcessorAlertData: Stopped 2025-12-30 17:14:14.6153 DFramework.Database.Query /* Time Taken: 582*/ [dbo].GenerateSystemAlerts 2025-12-30 17:14:15.9278 AlertProcessor ProcessorAlertData: started 2025-12-30 17:14:21.6310 AlertProcessor ProcessorAlertData: Stopped 2025-12-30 17:14:29.8185 DFramework.Scheduler.TaskBase /* Time Taken: 15843.845*/ Opportunity Out Of Stock By Outlet 2025-12-30 17:19:15.9451 AlertProcessor ProcessorAlertData: started 2025-12-30 17:19:21.4920 AlertProcessor ProcessorAlertData: Stopped 2025-12-30 17:24:15.9626 AlertProcessor ProcessorAlertData: started 2025-12-30 17:24:21.6190 AlertProcessor ProcessorAlertData: Stopped 2025-12-30 17:29:14.5895 DFramework.Database.Query /* Time Taken: 543*/ [dbo].GenerateSystemAlerts 2025-12-30 17:29:15.9802 AlertProcessor ProcessorAlertData: started 2025-12-30 17:29:21.5271 AlertProcessor ProcessorAlertData: Stopped 2025-12-30 17:29:29.8240 DFramework.Scheduler.TaskBase /* Time Taken: 15828.232*/ Opportunity Out Of Stock By Outlet 2025-12-30 17:34:15.9977 AlertProcessor ProcessorAlertData: started 2025-12-30 17:34:21.5289 AlertProcessor ProcessorAlertData: Stopped 2025-12-30 17:39:16.0149 AlertProcessor ProcessorAlertData: started 2025-12-30 17:39:21.5149 AlertProcessor ProcessorAlertData: Stopped 2025-12-30 17:44:14.6574 DFramework.Database.Query /* Time Taken: 583*/ [dbo].GenerateSystemAlerts 2025-12-30 17:44:16.0324 AlertProcessor ProcessorAlertData: started 2025-12-30 17:44:21.6106 AlertProcessor ProcessorAlertData: Stopped 2025-12-30 17:44:29.7982 DFramework.Scheduler.TaskBase /* Time Taken: 15781.352*/ Opportunity Out Of Stock By Outlet 2025-12-30 17:49:16.0501 AlertProcessor ProcessorAlertData: started 2025-12-30 17:49:21.6126 AlertProcessor ProcessorAlertData: Stopped 2025-12-30 17:54:16.0673 AlertProcessor ProcessorAlertData: started 2025-12-30 17:54:21.6299 AlertProcessor ProcessorAlertData: Stopped 2025-12-30 17:59:14.6161 DFramework.Database.Query /* Time Taken: 546*/ [dbo].GenerateSystemAlerts 2025-12-30 17:59:16.0849 AlertProcessor ProcessorAlertData: started 2025-12-30 17:59:21.7255 AlertProcessor ProcessorAlertData: Stopped 2025-12-30 17:59:29.8193 DFramework.Scheduler.TaskBase /* Time Taken: 15781.3546*/ Opportunity Out Of Stock By Outlet 2025-12-30 18:04:16.0868 AlertProcessor ProcessorAlertData: started 2025-12-30 18:04:21.7744 AlertProcessor ProcessorAlertData: Stopped 2025-12-30 18:09:16.1043 AlertProcessor ProcessorAlertData: started 2025-12-30 18:09:21.7137 AlertProcessor ProcessorAlertData: Stopped 2025-12-30 18:14:14.6998 DFramework.Database.Query /* Time Taken: 600*/ [dbo].GenerateSystemAlerts 2025-12-30 18:14:16.1217 AlertProcessor ProcessorAlertData: started 2025-12-30 18:14:21.7155 AlertProcessor ProcessorAlertData: Stopped 2025-12-30 18:14:29.8249 DFramework.Scheduler.TaskBase /* Time Taken: 15765.7251*/ Opportunity Out Of Stock By Outlet 2025-12-30 18:19:16.1393 AlertProcessor ProcessorAlertData: started 2025-12-30 18:19:21.7487 AlertProcessor ProcessorAlertData: Stopped 2025-12-30 18:24:16.1569 AlertProcessor ProcessorAlertData: started 2025-12-30 18:24:21.5163 AlertProcessor ProcessorAlertData: Stopped 2025-12-30 18:29:14.6739 DFramework.Database.Query /* Time Taken: 550*/ [dbo].GenerateSystemAlerts 2025-12-30 18:29:16.1739 AlertProcessor ProcessorAlertData: started 2025-12-30 18:29:21.6583 AlertProcessor ProcessorAlertData: Stopped 2025-12-30 18:29:29.8615 DFramework.Scheduler.TaskBase /* Time Taken: 15781.3384*/ Opportunity Out Of Stock By Outlet 2025-12-30 18:34:14.6757 MoveToReorder Running task for ClientId : 286 and ClientName = India Office QA and Slot: 12/31/2025 8:00:00 AM And LastExecutedOn: 12/30/2025 10:04:13 PM 2025-12-30 18:34:16.1914 AlertProcessor ProcessorAlertData: started 2025-12-30 18:34:22.0977 AlertProcessor ProcessorAlertData: Stopped 2025-12-30 18:34:55.0979 DFramework.Database.NullableDataReader Data reader open for 40058 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-30 18:34:55.1291 MoveToReorder Task executed successfully for ClientId : 286 Client Name:India Office QA, Slot: 12/31/2025 8:00:00 AM and Total Order Suggested: 124 Out Of: 124 2025-12-30 18:34:56.0823 DFramework.Scheduler.TaskBase /* Time Taken: 41734.6186*/ Move To Re-Order 2025-12-30 18:39:16.2090 AlertProcessor ProcessorAlertData: started 2025-12-30 18:39:21.7559 AlertProcessor ProcessorAlertData: Stopped 2025-12-30 18:44:14.9450 DFramework.Database.Query /* Time Taken: 797*/ [dbo].GenerateSystemAlerts 2025-12-30 18:44:16.2262 AlertProcessor ProcessorAlertData: started 2025-12-30 18:44:21.9450 AlertProcessor ProcessorAlertData: Stopped 2025-12-30 18:44:29.8825 DFramework.Scheduler.TaskBase /* Time Taken: 15781.3254*/ Opportunity Out Of Stock By Outlet 2025-12-30 18:49:16.2280 AlertProcessor ProcessorAlertData: started 2025-12-30 18:49:21.8217 AlertProcessor ProcessorAlertData: Stopped 2025-12-30 18:54:16.2455 AlertProcessor ProcessorAlertData: started 2025-12-30 18:54:17.2924 DFramework.Database.Query /* Time Taken: 621*/ DECLARE @TableName AnsiString(8000) SET @TableName = 'VoidAlert' DECLARE @CurrentRecordId Int32 SET @CurrentRecordId = '3675360' dbo.GetValidDeviceForAlertProcessData 2025-12-30 18:54:22.1830 AlertProcessor ProcessorAlertData: Stopped 2025-12-30 18:59:14.7005 DFramework.Database.Query /* Time Taken: 540*/ [dbo].GenerateSystemAlerts 2025-12-30 18:59:16.2630 AlertProcessor ProcessorAlertData: started 2025-12-30 18:59:21.8412 AlertProcessor ProcessorAlertData: Stopped 2025-12-30 18:59:29.9662 DFramework.Scheduler.TaskBase /* Time Taken: 15843.824*/ Opportunity Out Of Stock By Outlet 2025-12-30 19:04:16.2803 AlertProcessor ProcessorAlertData: started 2025-12-30 19:04:22.1241 AlertProcessor ProcessorAlertData: Stopped 2025-12-30 19:09:16.2978 AlertProcessor ProcessorAlertData: started 2025-12-30 19:09:21.7041 AlertProcessor ProcessorAlertData: Stopped 2025-12-30 19:14:14.7686 DFramework.Database.Query /* Time Taken: 588*/ [dbo].GenerateSystemAlerts 2025-12-30 19:14:16.2999 AlertProcessor ProcessorAlertData: started 2025-12-30 19:14:21.8624 AlertProcessor ProcessorAlertData: Stopped 2025-12-30 19:14:29.9406 DFramework.Scheduler.TaskBase /* Time Taken: 15796.9407*/ Opportunity Out Of Stock By Outlet 2025-12-30 19:19:16.3170 AlertProcessor ProcessorAlertData: started 2025-12-30 19:19:21.9107 AlertProcessor ProcessorAlertData: Stopped 2025-12-30 19:24:16.3344 AlertProcessor ProcessorAlertData: started 2025-12-30 19:24:21.8969 AlertProcessor ProcessorAlertData: Stopped 2025-12-30 19:29:14.7425 DFramework.Database.Query /* Time Taken: 543*/ [dbo].GenerateSystemAlerts 2025-12-30 19:29:16.3519 AlertProcessor ProcessorAlertData: started 2025-12-30 19:29:21.9770 AlertProcessor ProcessorAlertData: Stopped 2025-12-30 19:29:29.9927 DFramework.Scheduler.TaskBase /* Time Taken: 15828.2362*/ Opportunity Out Of Stock By Outlet 2025-12-30 19:34:14.7600 MoveToReorder Running task for ClientId : 286 and ClientName = India Office QA and Slot: 12/31/2025 9:00:00 AM And LastExecutedOn: 12/31/2025 8:04:14 AM 2025-12-30 19:34:15.2287 DFramework.Database.NullableDataReader Data reader open for 244 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-30 19:34:15.2600 MoveToReorder Task executed successfully for ClientId : 286 Client Name:India Office QA, Slot: 12/31/2025 9:00:00 AM and Total Order Suggested: 1 Out Of: 1 2025-12-30 19:34:16.3694 AlertProcessor ProcessorAlertData: started 2025-12-30 19:34:22.2600 AlertProcessor ProcessorAlertData: Stopped 2025-12-30 19:39:16.3867 AlertProcessor ProcessorAlertData: started 2025-12-30 19:39:21.9649 AlertProcessor ProcessorAlertData: Stopped 2025-12-30 19:44:14.8105 DFramework.Database.Query /* Time Taken: 592*/ [dbo].GenerateSystemAlerts 2025-12-30 19:44:16.4043 AlertProcessor ProcessorAlertData: started 2025-12-30 19:44:20.2480 DFramework.Database.NullableDataReader Data reader open for 278 at System.Environment.GetStackTrace(Exception e, Boolean needFileInfo) at System.Environment.get_StackTrace() at DFramework.Database.NullableDataReader.Dispose(Boolean disposing) in D:\Spraxa\Framework\DFramework\Database\NullableDataReader.cs:line 33 at DFramework.Database.NullableDataReader.Dispose() in D:\Spraxa\Framework\DFramework\Database\NullableDataReader.cs:line 44 at CoolR.Tasks.ProcessAlertData.Execute() in D:\Spraxa\CoolR-Group\portal\CoolR.Tasks\ProcessAlertData.cs:line 47 at DFramework.Scheduler.TaskBase.Run() in D:\Spraxa\Framework\DFramework.Scheduler\TaskBase.cs:line 176 at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx) at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx) at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state) at System.Threading.ThreadHelper.ThreadStart() 2025-12-30 19:44:22.1855 AlertProcessor ProcessorAlertData: Stopped 2025-12-30 19:44:29.9668 DFramework.Scheduler.TaskBase /* Time Taken: 15781.3532*/ Opportunity Out Of Stock By Outlet 2025-12-30 19:49:16.4219 AlertProcessor ProcessorAlertData: started 2025-12-30 19:49:22.0938 AlertProcessor ProcessorAlertData: Stopped 2025-12-30 19:54:16.4391 AlertProcessor ProcessorAlertData: started 2025-12-30 19:54:22.0485 AlertProcessor ProcessorAlertData: Stopped 2025-12-30 19:59:14.8003 DFramework.Database.Query /* Time Taken: 551*/ [dbo].GenerateSystemAlerts 2025-12-30 19:59:16.4565 AlertProcessor ProcessorAlertData: started 2025-12-30 19:59:22.2222 AlertProcessor ProcessorAlertData: Stopped 2025-12-30 19:59:30.0035 DFramework.Scheduler.TaskBase /* Time Taken: 15796.9451*/ Opportunity Out Of Stock By Outlet 2025-12-30 20:04:16.4742 AlertProcessor ProcessorAlertData: started 2025-12-30 20:04:19.6304 DFramework.Database.Query /* Time Taken: 523*/ DECLARE @TableName AnsiString(8000) SET @TableName = 'AssetStockProductWiseConsolidate' DECLARE @CurrentRecordId Int32 SET @CurrentRecordId = '3675360' dbo.GetValidDeviceForAlertProcessData 2025-12-30 20:04:22.2398 AlertProcessor ProcessorAlertData: Stopped 2025-12-30 20:09:16.4759 AlertProcessor ProcessorAlertData: started 2025-12-30 20:09:22.3040 AlertProcessor ProcessorAlertData: Stopped 2025-12-30 20:14:14.8683 DFramework.Database.Query /* Time Taken: 597*/ [dbo].GenerateSystemAlerts 2025-12-30 20:14:16.4933 AlertProcessor ProcessorAlertData: started 2025-12-30 20:14:20.3839 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-30 20:14:22.3683 AlertProcessor ProcessorAlertData: Stopped 2025-12-30 20:14:30.0247 DFramework.Scheduler.TaskBase /* Time Taken: 15796.9922*/ Opportunity Out Of Stock By Outlet 2025-12-30 20:19:16.5109 AlertProcessor ProcessorAlertData: started 2025-12-30 20:19:22.2453 AlertProcessor ProcessorAlertData: Stopped 2025-12-30 20:24:16.5128 AlertProcessor ProcessorAlertData: started 2025-12-30 20:24:22.3097 DFramework.Database.Query /* Time Taken: 530*/ DECLARE @TableName AnsiString(8000) SET @TableName = 'ProductStockLevel' DECLARE @CurrentRecordId Int32 SET @CurrentRecordId = '3675360' dbo.GetValidDeviceForAlertProcessData 2025-12-30 20:24:22.3566 AlertProcessor ProcessorAlertData: Stopped 2025-12-30 20:29:14.8581 DFramework.Database.Query /* Time Taken: 574*/ [dbo].GenerateSystemAlerts 2025-12-30 20:29:16.5144 AlertProcessor ProcessorAlertData: started 2025-12-30 20:29:22.1082 AlertProcessor ProcessorAlertData: Stopped 2025-12-30 20:29:30.0770 DFramework.Scheduler.TaskBase /* Time Taken: 15828.2201*/ Opportunity Out Of Stock By Outlet 2025-12-30 20:34:14.8912 MoveToReorder Running task for ClientId : 286 and ClientName = India Office QA and Slot: 12/31/2025 10:00:00 AM And LastExecutedOn: 12/31/2025 9:04:14 AM 2025-12-30 20:34:15.1100 MoveToReorder Task executed successfully for ClientId : 286 Client Name:India Office QA, Slot: 12/31/2025 10:00:00 AM But No Order found to suggest 2025-12-30 20:34:16.5319 AlertProcessor ProcessorAlertData: started 2025-12-30 20:34:17.7350 DFramework.Database.Query /* Time Taken: 1138*/ DECLARE AlertTypeIds Object SET AlertTypeIds = 'DFramework.Database.Adapters.SQL+d__24' [dbo].GetAlertSummaryData 2025-12-30 20:34:19.5788 DFramework.Database.Query /* Time Taken: 1835*/ DECLARE @AlertTypeIds AnsiString(8000) SET @AlertTypeIds = '46,37,59,73,57' DECLARE @ClientIds AnsiString(8000) SET @ClientIds = '213,286,1494,114,180,183,299,300,314,316,331,332,333,349,415,451,207,224,291,306,308,325,342,296,301,303,305,328,335,70,134,188,227,295,320,336,338,395,337,360,385,421,469,471,1480,1496,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-30 20:34:22.4069 AlertProcessor ProcessorAlertData: Stopped 2025-12-30 20:39:16.5495 AlertProcessor ProcessorAlertData: started 2025-12-30 20:39:22.0964 AlertProcessor ProcessorAlertData: Stopped 2025-12-30 20:44:14.8949 DFramework.Database.Query /* Time Taken: 581*/ [dbo].GenerateSystemAlerts 2025-12-30 20:44:16.5668 AlertProcessor ProcessorAlertData: started 2025-12-30 20:44:19.6918 DFramework.Database.Query /* Time Taken: 569*/ DECLARE @TableName AnsiString(8000) SET @TableName = 'AssetStockProductWiseConsolidate' DECLARE @CurrentRecordId Int32 SET @CurrentRecordId = '3675360' dbo.GetValidDeviceForAlertProcessData 2025-12-30 20:44:22.3638 AlertProcessor ProcessorAlertData: Stopped 2025-12-30 20:44:30.1450 DFramework.Scheduler.TaskBase /* Time Taken: 15875.0566*/ Opportunity Out Of Stock By Outlet 2025-12-30 20:49:16.5842 AlertProcessor ProcessorAlertData: started 2025-12-30 20:49:22.0842 AlertProcessor ProcessorAlertData: Stopped 2025-12-30 20:54:16.6018 AlertProcessor ProcessorAlertData: started 2025-12-30 20:54:22.1018 AlertProcessor ProcessorAlertData: Stopped 2025-12-30 20:59:14.8849 DFramework.Database.Query /* Time Taken: 553*/ [dbo].GenerateSystemAlerts 2025-12-30 20:59:16.6192 AlertProcessor ProcessorAlertData: started 2025-12-30 20:59:22.2286 AlertProcessor ProcessorAlertData: Stopped 2025-12-30 20:59:30.1037 DFramework.Scheduler.TaskBase /* Time Taken: 15812.569*/ Opportunity Out Of Stock By Outlet 2025-12-30 21:04:16.6365 AlertProcessor ProcessorAlertData: started 2025-12-30 21:04:22.6365 AlertProcessor ProcessorAlertData: Stopped 2025-12-30 21:09:16.6540 AlertProcessor ProcessorAlertData: started 2025-12-30 21:09:22.1072 DFramework.Database.Query /* Time Taken: 534*/ DECLARE @TableName AnsiString(8000) SET @TableName = 'ProductStockLevel' DECLARE @CurrentRecordId Int32 SET @CurrentRecordId = '3675360' dbo.GetValidDeviceForAlertProcessData 2025-12-30 21:09:22.1697 AlertProcessor ProcessorAlertData: Stopped 2025-12-30 21:14:15.0935 DFramework.Database.Query /* Time Taken: 734*/ [dbo].GenerateSystemAlerts 2025-12-30 21:14:16.6716 AlertProcessor ProcessorAlertData: started 2025-12-30 21:14:22.3279 AlertProcessor ProcessorAlertData: Stopped 2025-12-30 21:14:30.4061 DFramework.Scheduler.TaskBase /* Time Taken: 16093.8547*/ Opportunity Out Of Stock By Outlet 2025-12-30 21:19:16.6889 AlertProcessor ProcessorAlertData: started 2025-12-30 21:19:22.2982 AlertProcessor ProcessorAlertData: Stopped 2025-12-30 21:24:16.7063 AlertProcessor ProcessorAlertData: started 2025-12-30 21:24:17.3000 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-30 21:24:22.3938 AlertProcessor ProcessorAlertData: Stopped 2025-12-30 21:29:14.9270 DFramework.Database.Query /* Time Taken: 550*/ [dbo].GenerateSystemAlerts 2025-12-30 21:29:16.7239 AlertProcessor ProcessorAlertData: started 2025-12-30 21:29:22.3020 AlertProcessor ProcessorAlertData: Stopped 2025-12-30 21:29:30.1302 DFramework.Scheduler.TaskBase /* Time Taken: 15796.9827*/ Opportunity Out Of Stock By Outlet 2025-12-30 21:34:14.9913 MoveToReorder Running task for ClientId : 286 and ClientName = India Office QA and Slot: 12/31/2025 11:00:00 AM And LastExecutedOn: 12/31/2025 10:04:14 AM 2025-12-30 21:34:16.7413 AlertProcessor ProcessorAlertData: started 2025-12-30 21:34:22.3820 AlertProcessor ProcessorAlertData: Stopped 2025-12-30 21:34:55.2728 DFramework.Database.NullableDataReader Data reader open for 39960 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-30 21:34:55.3040 MoveToReorder Task executed successfully for ClientId : 286 Client Name:India Office QA, Slot: 12/31/2025 11:00:00 AM and Total Order Suggested: 124 Out Of: 124 2025-12-30 21:34:56.2259 DFramework.Scheduler.TaskBase /* Time Taken: 41562.7127*/ Move To Re-Order 2025-12-30 21:39:16.7587 AlertProcessor ProcessorAlertData: started 2025-12-30 21:39:22.1494 AlertProcessor ProcessorAlertData: Stopped 2025-12-30 21:44:15.1044 DFramework.Database.Query /* Time Taken: 717*/ [dbo].GenerateSystemAlerts 2025-12-30 21:44:16.7607 AlertProcessor ProcessorAlertData: started 2025-12-30 21:44:22.3388 AlertProcessor ProcessorAlertData: Stopped 2025-12-30 21:44:30.3389 DFramework.Scheduler.TaskBase /* Time Taken: 15984.4554*/ Opportunity Out Of Stock By Outlet 2025-12-30 21:49:16.7626 AlertProcessor ProcessorAlertData: started 2025-12-30 21:49:22.4814 AlertProcessor ProcessorAlertData: Stopped 2025-12-30 21:54:16.7799 AlertProcessor ProcessorAlertData: started 2025-12-30 21:54:22.3268 AlertProcessor ProcessorAlertData: Stopped 2025-12-30 21:59:15.1568 DFramework.Database.Query /* Time Taken: 745*/ [dbo].GenerateSystemAlerts 2025-12-30 21:59:16.7974 AlertProcessor ProcessorAlertData: started 2025-12-30 21:59:19.9380 DFramework.Database.Query /* Time Taken: 566*/ DECLARE @TableName AnsiString(8000) SET @TableName = 'AssetStockProductWiseConsolidate' DECLARE @CurrentRecordId Int32 SET @CurrentRecordId = '3675360' dbo.GetValidDeviceForAlertProcessData 2025-12-30 21:59:22.5474 AlertProcessor ProcessorAlertData: Stopped 2025-12-30 21:59:30.3600 DFramework.Scheduler.TaskBase /* Time Taken: 15984.4771*/ Opportunity Out Of Stock By Outlet 2025-12-30 22:04:16.8150 AlertProcessor ProcessorAlertData: started 2025-12-30 22:04:22.3150 AlertProcessor ProcessorAlertData: Stopped 2025-12-30 22:09:16.8323 AlertProcessor ProcessorAlertData: started 2025-12-30 22:09:22.3167 AlertProcessor ProcessorAlertData: Stopped 2025-12-30 22:14:15.0841 DFramework.Database.Query /* Time Taken: 641*/ [dbo].GenerateSystemAlerts 2025-12-30 22:14:16.8497 AlertProcessor ProcessorAlertData: started 2025-12-30 22:14:22.4591 AlertProcessor ProcessorAlertData: Stopped 2025-12-30 22:14:30.2873 DFramework.Scheduler.TaskBase /* Time Taken: 15890.7317*/ Opportunity Out Of Stock By Outlet 2025-12-30 22:19:16.8673 AlertProcessor ProcessorAlertData: started 2025-12-30 22:19:22.5079 AlertProcessor ProcessorAlertData: Stopped 2025-12-30 22:24:16.8848 AlertProcessor ProcessorAlertData: started 2025-12-30 22:24:22.4785 AlertProcessor ProcessorAlertData: Stopped 2025-12-30 22:29:15.0270 DFramework.Database.Query /* Time Taken: 568*/ [dbo].GenerateSystemAlerts 2025-12-30 22:29:16.9020 AlertProcessor ProcessorAlertData: started 2025-12-30 22:29:22.5739 AlertProcessor ProcessorAlertData: Stopped 2025-12-30 22:29:30.2615 DFramework.Scheduler.TaskBase /* Time Taken: 15843.8479*/ Opportunity Out Of Stock By Outlet 2025-12-30 22:34:15.0758 MoveToReorder Running task for ClientId : 286 and ClientName = India Office QA and Slot: 12/31/2025 12:00:00 PM And LastExecutedOn: 12/31/2025 11:04:14 AM 2025-12-30 22:34:15.6852 DFramework.Database.NullableDataReader Data reader open for 267 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-30 22:34:15.7320 MoveToReorder Task executed successfully for ClientId : 286 Client Name:India Office QA, Slot: 12/31/2025 12:00:00 PM and Total Order Suggested: 1 Out Of: 1 2025-12-30 22:34:16.9039 AlertProcessor ProcessorAlertData: started 2025-12-30 22:34:17.4196 DFramework.Database.Query /* Time Taken: 528*/ 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-30 22:34:17.4664 DFramework.Database.Query /* Time Taken: 1012*/ DECLARE @ClientId Int32 SET @ClientId = '286' DECLARE @OrderStatusId Int32 SET @OrderStatusId = '5485' SELECT * FROM vwScheduledOrderExportInfoList WHERE [ClientId] = @ClientId AND [OrderStatusId] = @OrderStatusId ORDER BY [LocationId] 2025-12-30 22:34:17.4664 DFramework.Database.Query /* Time Taken: 575*/ DECLARE @TableName AnsiString(8000) SET @TableName = 'TagAlert' DECLARE @CurrentRecordId Int32 SET @CurrentRecordId = '0' dbo.GetValidDeviceForAlertProcessData 2025-12-30 22:34:23.0915 AlertProcessor ProcessorAlertData: Stopped 2025-12-30 22:39:16.9215 AlertProcessor ProcessorAlertData: started 2025-12-30 22:39:22.4684 AlertProcessor ProcessorAlertData: Stopped 2025-12-30 22:44:15.0481 DFramework.Database.Query /* Time Taken: 572*/ [dbo].GenerateSystemAlerts 2025-12-30 22:44:16.9388 AlertProcessor ProcessorAlertData: started 2025-12-30 22:44:22.4544 AlertProcessor ProcessorAlertData: Stopped 2025-12-30 22:44:30.2201 DFramework.Scheduler.TaskBase /* Time Taken: 15781.3378*/ Opportunity Out Of Stock By Outlet 2025-12-30 22:49:16.9562 AlertProcessor ProcessorAlertData: started 2025-12-30 22:49:22.7375 AlertProcessor ProcessorAlertData: Stopped 2025-12-30 22:54:16.9738 AlertProcessor ProcessorAlertData: started 2025-12-30 22:54:22.5988 AlertProcessor ProcessorAlertData: Stopped 2025-12-30 22:59:15.0381 DFramework.Database.Query /* Time Taken: 537*/ [dbo].GenerateSystemAlerts 2025-12-30 22:59:16.9912 AlertProcessor ProcessorAlertData: started 2025-12-30 22:59:19.9912 DFramework.Database.Query /* Time Taken: 506*/ DECLARE @TableName AnsiString(8000) SET @TableName = 'AssetStockProductWiseConsolidate' DECLARE @CurrentRecordId Int32 SET @CurrentRecordId = '3675360' dbo.GetValidDeviceForAlertProcessData 2025-12-30 22:59:22.5694 AlertProcessor ProcessorAlertData: Stopped 2025-12-30 22:59:30.2882 DFramework.Scheduler.TaskBase /* Time Taken: 15828.2029*/ Opportunity Out Of Stock By Outlet 2025-12-30 23:04:17.0087 AlertProcessor ProcessorAlertData: started 2025-12-30 23:04:22.6649 AlertProcessor ProcessorAlertData: Stopped 2025-12-30 23:09:17.0262 AlertProcessor ProcessorAlertData: started 2025-12-30 23:09:20.1356 DFramework.Database.Query /* Time Taken: 604*/ DECLARE @TableName AnsiString(8000) SET @TableName = 'AssetStockProductWiseConsolidate' DECLARE @CurrentRecordId Int32 SET @CurrentRecordId = '3675360' dbo.GetValidDeviceForAlertProcessData 2025-12-30 23:09:22.7606 AlertProcessor ProcessorAlertData: Stopped 2025-12-30 23:14:15.1688 DFramework.Database.Query /* Time Taken: 642*/ [dbo].GenerateSystemAlerts 2025-12-30 23:14:17.0438 AlertProcessor ProcessorAlertData: started 2025-12-30 23:14:22.6845 AlertProcessor ProcessorAlertData: Stopped 2025-12-30 23:14:30.3252 DFramework.Scheduler.TaskBase /* Time Taken: 15843.8612*/ Opportunity Out Of Stock By Outlet 2025-12-30 23:19:17.0611 AlertProcessor ProcessorAlertData: started 2025-12-30 23:19:17.6079 DFramework.Database.NullableDataReader Data reader open for 208 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-30 23:19:18.2798 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-30 23:19:18.3267 DFramework.Database.NullableDataReader Data reader open for 464 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-30 23:19:19.9986 DFramework.Database.NullableDataReader Data reader open for 242 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-30 23:19:20.0455 DFramework.Database.NullableDataReader Data reader open for 328 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-30 23:19:20.6080 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-30 23:19:20.6705 DFramework.Database.NullableDataReader Data reader open for 386 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-30 23:19:21.3267 DFramework.Database.NullableDataReader Data reader open for 380 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-30 23:19:21.3892 DFramework.Database.NullableDataReader Data reader open for 465 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-30 23:19:22.0455 DFramework.Database.Query /* Time Taken: 661*/ DECLARE @TableName AnsiString(8000) SET @TableName = 'AssetStockProductWiseConsolidate' DECLARE @CurrentRecordId Int32 SET @CurrentRecordId = '3675360' dbo.GetValidDeviceForAlertProcessData 2025-12-30 23:19:22.6549 DFramework.Database.NullableDataReader Data reader open for 245 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-30 23:19:22.7174 DFramework.Database.NullableDataReader Data reader open for 330 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-30 23:19:23.0455 AlertProcessor Replace Tags updated for the Image Id: 3675314 2025-12-30 23:19:23.7017 DFramework.Database.NullableDataReader Data reader open for 253 at System.Environment.GetStackTrace(Exception e, Boolean needFileInfo) at System.Environment.get_StackTrace() at DFramework.Database.NullableDataReader.Dispose(Boolean disposing) in D:\Spraxa\Framework\DFramework\Database\NullableDataReader.cs:line 33 at DFramework.Database.NullableDataReader.Dispose() in D:\Spraxa\Framework\DFramework\Database\NullableDataReader.cs:line 44 at CoolR.Tasks.ProcessAlertData.Execute() in D:\Spraxa\CoolR-Group\portal\CoolR.Tasks\ProcessAlertData.cs:line 47 at DFramework.Scheduler.TaskBase.Run() in D:\Spraxa\Framework\DFramework.Scheduler\TaskBase.cs:line 176 at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx) at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx) at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state) at System.Threading.ThreadHelper.ThreadStart() 2025-12-30 23:19:23.7486 DFramework.Database.NullableDataReader Data reader open for 338 at System.Environment.GetStackTrace(Exception e, Boolean needFileInfo) at System.Environment.get_StackTrace() at DFramework.Database.NullableDataReader.Dispose(Boolean disposing) in D:\Spraxa\Framework\DFramework\Database\NullableDataReader.cs:line 33 at DFramework.Database.NullableDataReader.Dispose() in D:\Spraxa\Framework\DFramework\Database\NullableDataReader.cs:line 44 at CoolR.Tasks.ProcessAlertData.Execute() in D:\Spraxa\CoolR-Group\portal\CoolR.Tasks\ProcessAlertData.cs:line 47 at DFramework.Scheduler.TaskBase.Run() in D:\Spraxa\Framework\DFramework.Scheduler\TaskBase.cs:line 176 at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx) at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx) at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state) at System.Threading.ThreadHelper.ThreadStart() 2025-12-30 23:19:24.5767 DFramework.Database.NullableDataReader Data reader open for 218 at System.Environment.GetStackTrace(Exception e, Boolean needFileInfo) at System.Environment.get_StackTrace() at DFramework.Database.NullableDataReader.Dispose(Boolean disposing) in D:\Spraxa\Framework\DFramework\Database\NullableDataReader.cs:line 33 at DFramework.Database.NullableDataReader.Dispose() in D:\Spraxa\Framework\DFramework\Database\NullableDataReader.cs:line 44 at CoolR.Tasks.ProcessAlertData.Execute() in D:\Spraxa\CoolR-Group\portal\CoolR.Tasks\ProcessAlertData.cs:line 47 at DFramework.Scheduler.TaskBase.Run() in D:\Spraxa\Framework\DFramework.Scheduler\TaskBase.cs:line 176 at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx) at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx) at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state) at System.Threading.ThreadHelper.ThreadStart() 2025-12-30 23:19:24.6392 DFramework.Database.NullableDataReader Data reader open for 303 at System.Environment.GetStackTrace(Exception e, Boolean needFileInfo) at System.Environment.get_StackTrace() at DFramework.Database.NullableDataReader.Dispose(Boolean disposing) in D:\Spraxa\Framework\DFramework\Database\NullableDataReader.cs:line 33 at DFramework.Database.NullableDataReader.Dispose() in D:\Spraxa\Framework\DFramework\Database\NullableDataReader.cs:line 44 at CoolR.Tasks.ProcessAlertData.Execute() in D:\Spraxa\CoolR-Group\portal\CoolR.Tasks\ProcessAlertData.cs:line 47 at DFramework.Scheduler.TaskBase.Run() in D:\Spraxa\Framework\DFramework.Scheduler\TaskBase.cs:line 176 at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx) at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx) at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state) at System.Threading.ThreadHelper.ThreadStart() 2025-12-30 23:19:25.4986 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-30 23:19:26.1549 AlertProcessor ProcessorAlertData: Stopped 2025-12-30 23:24:17.0786 AlertProcessor ProcessorAlertData: started 2025-12-30 23:24:22.9067 DFramework.Database.Query /* Time Taken: 669*/ DECLARE @TableName AnsiString(8000) SET @TableName = 'ProductStockLevel' DECLARE @CurrentRecordId Int32 SET @CurrentRecordId = '3675360' dbo.GetValidDeviceForAlertProcessData 2025-12-30 23:24:22.9692 AlertProcessor ProcessorAlertData: Stopped 2025-12-30 23:29:15.2055 DFramework.Database.Query /* Time Taken: 664*/ [dbo].GenerateSystemAlerts 2025-12-30 23:29:17.0961 AlertProcessor ProcessorAlertData: started 2025-12-30 23:29:18.3930 DFramework.Database.Query /* Time Taken: 512*/ DECLARE @TableName AnsiString(8000) SET @TableName = 'MissingShelf' DECLARE @CurrentRecordId Int32 SET @CurrentRecordId = '3675360' dbo.GetValidDeviceForAlertProcessData 2025-12-30 23:29:19.1899 DFramework.Database.Query /* Time Taken: 738*/ DECLARE @TableName AnsiString(8000) SET @TableName = 'AdditionalShelf' DECLARE @CurrentRecordId Int32 SET @CurrentRecordId = '3675360' dbo.GetValidDeviceForAlertProcessData 2025-12-30 23:29:23.3306 AlertProcessor ProcessorAlertData: Stopped 2025-12-30 23:29:30.7369 DFramework.Scheduler.TaskBase /* Time Taken: 16234.4878*/ Opportunity Out Of Stock By Outlet 2025-12-30 23:34:15.2541 MoveToReorder Running task for ClientId : 286 and ClientName = India Office QA and Slot: 12/31/2025 1:00:00 PM And LastExecutedOn: 12/31/2025 12:04:15 PM 2025-12-30 23:34:15.8009 MoveToReorder Task executed successfully for ClientId : 286 Client Name:India Office QA, Slot: 12/31/2025 1:00:00 PM and Total Order Suggested: 1 Out Of: 1 2025-12-30 23:34:17.1135 AlertProcessor ProcessorAlertData: started 2025-12-30 23:34:20.6447 DFramework.Database.Query /* Time Taken: 527*/ DECLARE @TableName AnsiString(8000) SET @TableName = 'AssetStockProductWiseConsolidate' DECLARE @CurrentRecordId Int32 SET @CurrentRecordId = '3675360' dbo.GetValidDeviceForAlertProcessData 2025-12-30 23:34:23.2697 AlertProcessor ProcessorAlertData: Stopped 2025-12-30 23:39:17.1308 AlertProcessor ProcessorAlertData: started 2025-12-30 23:39:20.5058 DFramework.Database.Query /* Time Taken: 835*/ DECLARE @TableName AnsiString(8000) SET @TableName = 'AssetStockProductWiseConsolidate' DECLARE @CurrentRecordId Int32 SET @CurrentRecordId = '3675360' dbo.GetValidDeviceForAlertProcessData 2025-12-30 23:39:23.3340 AlertProcessor ProcessorAlertData: Stopped 2025-12-30 23:44:15.3827 DFramework.Database.Query /* Time Taken: 818*/ [dbo].GenerateSystemAlerts 2025-12-30 23:44:17.1484 AlertProcessor ProcessorAlertData: started 2025-12-30 23:44:22.6484 AlertProcessor ProcessorAlertData: Stopped 2025-12-30 23:44:30.5547 DFramework.Scheduler.TaskBase /* Time Taken: 16046.9778*/ Opportunity Out Of Stock By Outlet 2025-12-30 23:49:17.1659 AlertProcessor ProcessorAlertData: started 2025-12-30 23:49:21.0721 DFramework.Database.Query /* Time Taken: 877*/ DECLARE @TableName AnsiString(8000) SET @TableName = 'AssetStockProductWiseConsolidate' DECLARE @CurrentRecordId Int32 SET @CurrentRecordId = '3675360' dbo.GetValidDeviceForAlertProcessData 2025-12-30 23:49:23.7909 AlertProcessor ProcessorAlertData: Stopped 2025-12-30 23:54:17.1831 AlertProcessor ProcessorAlertData: started 2025-12-30 23:54:18.6831 DFramework.Database.Query /* Time Taken: 748*/ DECLARE @TableName AnsiString(8000) SET @TableName = 'MissingShelf' DECLARE @CurrentRecordId Int32 SET @CurrentRecordId = '3675360' dbo.GetValidDeviceForAlertProcessData 2025-12-30 23:54:23.1518 AlertProcessor ProcessorAlertData: Stopped 2025-12-30 23:59:15.2943 DFramework.Database.Query /* Time Taken: 717*/ [dbo].GenerateSystemAlerts 2025-12-30 23:59:17.2005 AlertProcessor ProcessorAlertData: started 2025-12-30 23:59:20.2318 DFramework.Database.Query /* Time Taken: 521*/ DECLARE @TableName AnsiString(8000) SET @TableName = 'AssetStockProductWiseConsolidate' DECLARE @CurrentRecordId Int32 SET @CurrentRecordId = '3675360' dbo.GetValidDeviceForAlertProcessData 2025-12-30 23:59:22.9662 DFramework.Database.Query /* Time Taken: 591*/ DECLARE @TableName AnsiString(8000) SET @TableName = 'ProductStockLevel' DECLARE @CurrentRecordId Int32 SET @CurrentRecordId = '3675360' dbo.GetValidDeviceForAlertProcessData 2025-12-30 23:59:23.0287 AlertProcessor ProcessorAlertData: Stopped 2025-12-30 23:59:30.6537 DFramework.Scheduler.TaskBase /* Time Taken: 16125.1031*/ Opportunity Out Of Stock By Outlet