2026-01-04 00:04:33.8834 AlertProcessor ProcessorAlertData: started 2026-01-04 00:04:39.3210 AlertProcessor ProcessorAlertData: Stopped 2026-01-04 00:09:33.9013 AlertProcessor ProcessorAlertData: started 2026-01-04 00:09:39.2920 AlertProcessor ProcessorAlertData: Stopped 2026-01-04 00:14:33.9192 AlertProcessor ProcessorAlertData: started 2026-01-04 00:14:37.6067 DFramework.Scheduler.TaskBase /* Time Taken: 15546.9918*/ Opportunity Out Of Stock By Outlet 2026-01-04 00:14:39.2786 AlertProcessor ProcessorAlertData: Stopped 2026-01-04 00:19:33.9372 AlertProcessor ProcessorAlertData: started 2026-01-04 00:19:39.3747 AlertProcessor ProcessorAlertData: Stopped 2026-01-04 00:24:33.9551 AlertProcessor ProcessorAlertData: started 2026-01-04 00:24:39.3770 AlertProcessor ProcessorAlertData: Stopped 2026-01-04 00:29:22.5979 DFramework.Database.Query /* Time Taken: 523*/ [dbo].GenerateSystemAlerts 2026-01-04 00:29:33.9730 AlertProcessor ProcessorAlertData: started 2026-01-04 00:29:37.6605 DFramework.Scheduler.TaskBase /* Time Taken: 15578.2396*/ Opportunity Out Of Stock By Outlet 2026-01-04 00:29:39.3324 AlertProcessor ProcessorAlertData: Stopped 2026-01-04 00:34:33.9908 AlertProcessor ProcessorAlertData: started 2026-01-04 00:34:39.3503 AlertProcessor ProcessorAlertData: Stopped 2026-01-04 00:39:33.9931 AlertProcessor ProcessorAlertData: started 2026-01-04 00:39:39.2744 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() 2026-01-04 00:39:39.8056 AlertProcessor ProcessorAlertData: Stopped 2026-01-04 00:44:33.9953 AlertProcessor ProcessorAlertData: started 2026-01-04 00:44:37.6672 DFramework.Scheduler.TaskBase /* Time Taken: 15562.617*/ Opportunity Out Of Stock By Outlet 2026-01-04 00:44:39.4173 AlertProcessor ProcessorAlertData: Stopped 2026-01-04 00:49:34.0133 AlertProcessor ProcessorAlertData: started 2026-01-04 00:49:39.4195 AlertProcessor ProcessorAlertData: Stopped 2026-01-04 00:54:34.0312 AlertProcessor ProcessorAlertData: started 2026-01-04 00:54:39.2031 AlertProcessor ProcessorAlertData: Stopped 2026-01-04 00:59:22.6740 DFramework.Database.Query /* Time Taken: 548*/ [dbo].GenerateSystemAlerts 2026-01-04 00:59:34.0491 AlertProcessor ProcessorAlertData: started 2026-01-04 00:59:37.6898 DFramework.Scheduler.TaskBase /* Time Taken: 15562.6201*/ Opportunity Out Of Stock By Outlet 2026-01-04 00:59:39.4554 AlertProcessor ProcessorAlertData: Stopped 2026-01-04 01:04:34.0670 AlertProcessor ProcessorAlertData: started 2026-01-04 01:04:39.5358 AlertProcessor ProcessorAlertData: Stopped 2026-01-04 01:09:34.0850 AlertProcessor ProcessorAlertData: started 2026-01-04 01:09:39.3662 AlertProcessor ProcessorAlertData: Stopped 2026-01-04 01:14:22.6809 DFramework.Database.Query /* Time Taken: 536*/ [dbo].GenerateSystemAlerts 2026-01-04 01:14:34.1029 AlertProcessor ProcessorAlertData: started 2026-01-04 01:14:37.7591 DFramework.Scheduler.TaskBase /* Time Taken: 15609.4898*/ Opportunity Out Of Stock By Outlet 2026-01-04 01:14:39.4935 AlertProcessor ProcessorAlertData: Stopped 2026-01-04 01:19:34.1207 AlertProcessor ProcessorAlertData: started 2026-01-04 01:19:39.5270 AlertProcessor ProcessorAlertData: Stopped 2026-01-04 01:24:34.1387 AlertProcessor ProcessorAlertData: started 2026-01-04 01:24:39.4825 AlertProcessor ProcessorAlertData: Stopped 2026-01-04 01:29:22.7346 DFramework.Database.Query /* Time Taken: 574*/ [dbo].GenerateSystemAlerts 2026-01-04 01:29:34.1566 AlertProcessor ProcessorAlertData: started 2026-01-04 01:29:37.7973 DFramework.Scheduler.TaskBase /* Time Taken: 15625.1249*/ Opportunity Out Of Stock By Outlet 2026-01-04 01:29:39.5473 AlertProcessor ProcessorAlertData: Stopped 2026-01-04 01:34:34.1745 AlertProcessor ProcessorAlertData: started 2026-01-04 01:34:39.5027 AlertProcessor ProcessorAlertData: Stopped 2026-01-04 01:39:34.1768 AlertProcessor ProcessorAlertData: started 2026-01-04 01:39:39.5362 DFramework.Database.Query /* Time Taken: 507*/ DECLARE @TableName AnsiString(8000) SET @TableName = 'ProductStockLevel' DECLARE @CurrentRecordId Int32 SET @CurrentRecordId = '3675525' dbo.GetValidDeviceForAlertProcessData 2026-01-04 01:39:39.5987 AlertProcessor ProcessorAlertData: Stopped 2026-01-04 01:44:34.1947 AlertProcessor ProcessorAlertData: started 2026-01-04 01:44:37.7416 DFramework.Scheduler.TaskBase /* Time Taken: 15562.5815*/ Opportunity Out Of Stock By Outlet 2026-01-04 01:44:39.5698 AlertProcessor ProcessorAlertData: Stopped 2026-01-04 01:49:34.2126 AlertProcessor ProcessorAlertData: started 2026-01-04 01:49:39.6033 AlertProcessor ProcessorAlertData: Stopped 2026-01-04 01:54:34.2305 AlertProcessor ProcessorAlertData: started 2026-01-04 01:54:37.1524 DFramework.Database.Query /* Time Taken: 505*/ DECLARE @TableName AnsiString(8000) SET @TableName = 'AssetStockProductWiseConsolidate' DECLARE @CurrentRecordId Int32 SET @CurrentRecordId = '3675525' dbo.GetValidDeviceForAlertProcessData 2026-01-04 01:54:39.6212 AlertProcessor ProcessorAlertData: Stopped 2026-01-04 01:59:34.2328 AlertProcessor ProcessorAlertData: started 2026-01-04 01:59:37.7641 DFramework.Scheduler.TaskBase /* Time Taken: 15562.6204*/ Opportunity Out Of Stock By Outlet 2026-01-04 01:59:39.6235 AlertProcessor ProcessorAlertData: Stopped 2026-01-04 02:04:34.2507 AlertProcessor ProcessorAlertData: started 2026-01-04 02:04:39.6726 AlertProcessor ProcessorAlertData: Stopped 2026-01-04 02:09:34.2686 AlertProcessor ProcessorAlertData: started 2026-01-04 02:09:39.6280 AlertProcessor ProcessorAlertData: Stopped 2026-01-04 02:14:34.2865 AlertProcessor ProcessorAlertData: started 2026-01-04 02:14:37.7865 DFramework.Scheduler.TaskBase /* Time Taken: 15562.6135*/ Opportunity Out Of Stock By Outlet 2026-01-04 02:14:39.8334 AlertProcessor ProcessorAlertData: Stopped 2026-01-04 02:19:34.3044 AlertProcessor ProcessorAlertData: started 2026-01-04 02:19:39.6950 AlertProcessor ProcessorAlertData: Stopped 2026-01-04 02:24:34.3223 AlertProcessor ProcessorAlertData: started 2026-01-04 02:24:39.7598 AlertProcessor ProcessorAlertData: Stopped 2026-01-04 02:29:22.7932 DFramework.Database.Query /* Time Taken: 560*/ [dbo].GenerateSystemAlerts 2026-01-04 02:29:34.3401 AlertProcessor ProcessorAlertData: started 2026-01-04 02:29:37.7933 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() 2026-01-04 02:29:37.8089 DFramework.Scheduler.TaskBase /* Time Taken: 15562.6227*/ Opportunity Out Of Stock By Outlet 2026-01-04 02:29:39.9808 AlertProcessor ProcessorAlertData: Stopped 2026-01-04 02:34:34.3581 AlertProcessor ProcessorAlertData: started 2026-01-04 02:34:39.7019 AlertProcessor ProcessorAlertData: Stopped 2026-01-04 02:39:34.3760 AlertProcessor ProcessorAlertData: started 2026-01-04 02:39:39.7823 AlertProcessor ProcessorAlertData: Stopped 2026-01-04 02:44:22.9095 DFramework.Database.Query /* Time Taken: 652*/ [dbo].GenerateSystemAlerts 2026-01-04 02:44:34.3783 AlertProcessor ProcessorAlertData: started 2026-01-04 02:44:37.8783 DFramework.Scheduler.TaskBase /* Time Taken: 15609.4935*/ Opportunity Out Of Stock By Outlet 2026-01-04 02:44:39.9409 AlertProcessor ProcessorAlertData: Stopped 2026-01-04 02:49:34.3806 AlertProcessor ProcessorAlertData: started 2026-01-04 02:49:39.9275 AlertProcessor ProcessorAlertData: Stopped 2026-01-04 02:54:34.3828 AlertProcessor ProcessorAlertData: started 2026-01-04 02:54:39.8829 AlertProcessor ProcessorAlertData: Stopped 2026-01-04 02:59:22.8069 DFramework.Database.Query /* Time Taken: 520*/ [dbo].GenerateSystemAlerts 2026-01-04 02:59:34.3851 AlertProcessor ProcessorAlertData: started 2026-01-04 02:59:37.9164 DFramework.Scheduler.TaskBase /* Time Taken: 15625.1238*/ Opportunity Out Of Stock By Outlet 2026-01-04 02:59:39.7758 AlertProcessor ProcessorAlertData: Stopped 2026-01-04 03:04:34.4030 AlertProcessor ProcessorAlertData: started 2026-01-04 03:04:39.7624 AlertProcessor ProcessorAlertData: Stopped 2026-01-04 03:09:34.4210 AlertProcessor ProcessorAlertData: started 2026-01-04 03:09:39.4054 AlertProcessor ProcessorAlertData: Stopped 2026-01-04 03:14:34.4389 AlertProcessor ProcessorAlertData: started 2026-01-04 03:14:37.9233 DFramework.Scheduler.TaskBase /* Time Taken: 15609.4939*/ Opportunity Out Of Stock By Outlet 2026-01-04 03:14:39.5952 AlertProcessor ProcessorAlertData: Stopped 2026-01-04 03:19:34.4412 AlertProcessor ProcessorAlertData: started 2026-01-04 03:19:39.3944 AlertProcessor ProcessorAlertData: Stopped 2026-01-04 03:24:34.4435 AlertProcessor ProcessorAlertData: started 2026-01-04 03:24:39.9748 AlertProcessor ProcessorAlertData: Stopped 2026-01-04 03:29:34.4614 AlertProcessor ProcessorAlertData: started 2026-01-04 03:29:37.8833 DFramework.Scheduler.TaskBase /* Time Taken: 15546.9813*/ Opportunity Out Of Stock By Outlet 2026-01-04 03:29:39.6958 AlertProcessor ProcessorAlertData: Stopped 2026-01-04 03:34:34.4793 AlertProcessor ProcessorAlertData: started 2026-01-04 03:34:39.6981 AlertProcessor ProcessorAlertData: Stopped 2026-01-04 03:39:34.4972 AlertProcessor ProcessorAlertData: started 2026-01-04 03:39:39.9191 AlertProcessor ProcessorAlertData: Stopped 2026-01-04 03:44:22.8588 DFramework.Database.Query /* Time Taken: 503*/ [dbo].GenerateSystemAlerts 2026-01-04 03:44:34.5151 AlertProcessor ProcessorAlertData: started 2026-01-04 03:44:37.9683 DFramework.Scheduler.TaskBase /* Time Taken: 15609.4934*/ Opportunity Out Of Stock By Outlet 2026-01-04 03:44:39.7495 AlertProcessor ProcessorAlertData: Stopped 2026-01-04 03:49:34.5330 AlertProcessor ProcessorAlertData: started 2026-01-04 03:49:39.6112 AlertProcessor ProcessorAlertData: Stopped 2026-01-04 03:54:34.5509 AlertProcessor ProcessorAlertData: started 2026-01-04 03:54:39.5041 AlertProcessor ProcessorAlertData: Stopped 2026-01-04 03:59:34.5688 AlertProcessor ProcessorAlertData: started 2026-01-04 03:59:37.9282 DFramework.Scheduler.TaskBase /* Time Taken: 15562.6164*/ Opportunity Out Of Stock By Outlet 2026-01-04 03:59:39.6001 AlertProcessor ProcessorAlertData: Stopped 2026-01-04 04:04:34.5867 AlertProcessor ProcessorAlertData: started 2026-01-04 04:04:39.7430 AlertProcessor ProcessorAlertData: Stopped 2026-01-04 04:09:34.6046 AlertProcessor ProcessorAlertData: started 2026-01-04 04:09:39.6203 AlertProcessor ProcessorAlertData: Stopped 2026-01-04 04:14:22.8881 DFramework.Database.Query /* Time Taken: 520*/ [dbo].GenerateSystemAlerts 2026-01-04 04:14:34.6225 AlertProcessor ProcessorAlertData: started 2026-01-04 04:14:37.9507 DFramework.Scheduler.TaskBase /* Time Taken: 15578.2456*/ Opportunity Out Of Stock By Outlet 2026-01-04 04:14:40.0601 AlertProcessor ProcessorAlertData: Stopped 2026-01-04 04:19:34.6405 AlertProcessor ProcessorAlertData: started 2026-01-04 04:19:40.0311 AlertProcessor ProcessorAlertData: Stopped 2026-01-04 04:24:34.6427 AlertProcessor ProcessorAlertData: started 2026-01-04 04:24:39.8771 AlertProcessor ProcessorAlertData: Stopped 2026-01-04 04:29:34.6606 AlertProcessor ProcessorAlertData: started 2026-01-04 04:29:37.9575 DFramework.Scheduler.TaskBase /* Time Taken: 15562.6206*/ Opportunity Out Of Stock By Outlet 2026-01-04 04:29:40.0044 AlertProcessor ProcessorAlertData: Stopped 2026-01-04 04:34:34.6785 AlertProcessor ProcessorAlertData: started 2026-01-04 04:34:39.9442 AlertProcessor ProcessorAlertData: Stopped 2026-01-04 04:39:34.6808 AlertProcessor ProcessorAlertData: started 2026-01-04 04:39:39.7589 AlertProcessor ProcessorAlertData: Stopped 2026-01-04 04:44:34.6831 AlertProcessor ProcessorAlertData: started 2026-01-04 04:44:37.9800 DFramework.Scheduler.TaskBase /* Time Taken: 15562.6194*/ Opportunity Out Of Stock By Outlet 2026-01-04 04:44:39.6518 AlertProcessor ProcessorAlertData: Stopped 2026-01-04 04:49:34.6854 AlertProcessor ProcessorAlertData: started 2026-01-04 04:49:39.6854 AlertProcessor ProcessorAlertData: Stopped 2026-01-04 04:54:34.7033 AlertProcessor ProcessorAlertData: started 2026-01-04 04:54:39.6252 AlertProcessor ProcessorAlertData: Stopped 2026-01-04 04:59:34.7212 AlertProcessor ProcessorAlertData: started 2026-01-04 04:59:38.0024 DFramework.Scheduler.TaskBase /* Time Taken: 15562.6183*/ Opportunity Out Of Stock By Outlet 2026-01-04 04:59:39.6900 AlertProcessor ProcessorAlertData: Stopped 2026-01-04 05:04:34.7391 AlertProcessor ProcessorAlertData: started 2026-01-04 05:04:39.7079 AlertProcessor ProcessorAlertData: Stopped 2026-01-04 05:09:34.7413 AlertProcessor ProcessorAlertData: started 2026-01-04 05:09:39.7101 AlertProcessor ProcessorAlertData: Stopped 2026-01-04 05:14:34.7593 AlertProcessor ProcessorAlertData: started 2026-01-04 05:14:38.0093 DFramework.Scheduler.TaskBase /* Time Taken: 15562.617*/ Opportunity Out Of Stock By Outlet 2026-01-04 05:14:39.7124 AlertProcessor ProcessorAlertData: Stopped 2026-01-04 05:19:34.7772 AlertProcessor ProcessorAlertData: started 2026-01-04 05:19:39.9022 AlertProcessor ProcessorAlertData: Stopped 2026-01-04 05:24:34.7794 AlertProcessor ProcessorAlertData: started 2026-01-04 05:24:39.7482 AlertProcessor ProcessorAlertData: Stopped 2026-01-04 05:29:34.7973 AlertProcessor ProcessorAlertData: started 2026-01-04 05:29:38.0317 DFramework.Scheduler.TaskBase /* Time Taken: 15578.2481*/ Opportunity Out Of Stock By Outlet 2026-01-04 05:29:39.8754 AlertProcessor ProcessorAlertData: Stopped 2026-01-04 05:34:34.8151 AlertProcessor ProcessorAlertData: started 2026-01-04 05:34:39.7058 AlertProcessor ProcessorAlertData: Stopped 2026-01-04 05:39:34.8330 AlertProcessor ProcessorAlertData: started 2026-01-04 05:39:39.7393 AlertProcessor ProcessorAlertData: Stopped 2026-01-04 05:44:34.8353 AlertProcessor ProcessorAlertData: started 2026-01-04 05:44:37.9915 DFramework.Scheduler.TaskBase /* Time Taken: 15515.7347*/ Opportunity Out Of Stock By Outlet 2026-01-04 05:44:39.7728 AlertProcessor ProcessorAlertData: Stopped 2026-01-04 05:49:34.8531 AlertProcessor ProcessorAlertData: started 2026-01-04 05:49:39.8063 AlertProcessor ProcessorAlertData: Stopped 2026-01-04 05:54:34.8710 AlertProcessor ProcessorAlertData: started 2026-01-04 05:54:39.8242 AlertProcessor ProcessorAlertData: Stopped 2026-01-04 05:59:34.8889 AlertProcessor ProcessorAlertData: started 2026-01-04 05:59:38.0139 DFramework.Scheduler.TaskBase /* Time Taken: 15515.7438*/ Opportunity Out Of Stock By Outlet 2026-01-04 05:59:39.9202 AlertProcessor ProcessorAlertData: Stopped 2026-01-04 06:04:34.9068 AlertProcessor ProcessorAlertData: started 2026-01-04 06:04:39.8756 AlertProcessor ProcessorAlertData: Stopped 2026-01-04 06:09:34.9247 AlertProcessor ProcessorAlertData: started 2026-01-04 06:09:39.9560 AlertProcessor ProcessorAlertData: Stopped 2026-01-04 06:14:34.9426 AlertProcessor ProcessorAlertData: started 2026-01-04 06:14:38.1145 DFramework.Scheduler.TaskBase /* Time Taken: 15593.8803*/ Opportunity Out Of Stock By Outlet 2026-01-04 06:14:39.8802 AlertProcessor ProcessorAlertData: Stopped 2026-01-04 06:19:34.9607 AlertProcessor ProcessorAlertData: started 2026-01-04 06:19:39.9138 AlertProcessor ProcessorAlertData: Stopped 2026-01-04 06:24:34.9786 AlertProcessor ProcessorAlertData: started 2026-01-04 06:24:39.9786 AlertProcessor ProcessorAlertData: Stopped 2026-01-04 06:29:34.9965 AlertProcessor ProcessorAlertData: started 2026-01-04 06:29:38.1059 DFramework.Scheduler.TaskBase /* Time Taken: 15578.2446*/ Opportunity Out Of Stock By Outlet 2026-01-04 06:29:39.9340 AlertProcessor ProcessorAlertData: Stopped 2026-01-04 06:34:35.0144 AlertProcessor ProcessorAlertData: started 2026-01-04 06:34:39.9988 AlertProcessor ProcessorAlertData: Stopped 2026-01-04 06:39:35.0323 AlertProcessor ProcessorAlertData: started 2026-01-04 06:39:35.7980 DFramework.Database.Query /* Time Taken: 778*/ 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 2026-01-04 06:39:40.5168 AlertProcessor ProcessorAlertData: Stopped 2026-01-04 06:44:23.5189 DFramework.Database.Query /* Time Taken: 971*/ [dbo].GenerateSystemAlerts 2026-01-04 06:44:35.0503 AlertProcessor ProcessorAlertData: started 2026-01-04 06:44:38.0971 DFramework.Scheduler.TaskBase /* Time Taken: 15546.9938*/ Opportunity Out Of Stock By Outlet 2026-01-04 06:44:40.0190 AlertProcessor ProcessorAlertData: Stopped 2026-01-04 06:49:35.0682 AlertProcessor ProcessorAlertData: started 2026-01-04 06:49:40.0213 AlertProcessor ProcessorAlertData: Stopped 2026-01-04 06:54:35.0861 AlertProcessor ProcessorAlertData: started 2026-01-04 06:54:40.0861 AlertProcessor ProcessorAlertData: Stopped 2026-01-04 06:59:35.0883 AlertProcessor ProcessorAlertData: started 2026-01-04 06:59:38.1509 DFramework.Scheduler.TaskBase /* Time Taken: 15578.2467*/ Opportunity Out Of Stock By Outlet 2026-01-04 06:59:40.0415 AlertProcessor ProcessorAlertData: Stopped 2026-01-04 07:04:35.1062 AlertProcessor ProcessorAlertData: started 2026-01-04 07:04:40.1063 AlertProcessor ProcessorAlertData: Stopped 2026-01-04 07:09:35.1241 AlertProcessor ProcessorAlertData: started 2026-01-04 07:09:40.1242 AlertProcessor ProcessorAlertData: Stopped 2026-01-04 07:14:35.1420 AlertProcessor ProcessorAlertData: started 2026-01-04 07:14:38.1577 DFramework.Scheduler.TaskBase /* Time Taken: 15562.6187*/ Opportunity Out Of Stock By Outlet 2026-01-04 07:14:40.0327 AlertProcessor ProcessorAlertData: Stopped 2026-01-04 07:19:35.1443 AlertProcessor ProcessorAlertData: started 2026-01-04 07:19:40.0662 AlertProcessor ProcessorAlertData: Stopped 2026-01-04 07:24:35.1622 AlertProcessor ProcessorAlertData: started 2026-01-04 07:24:40.0841 AlertProcessor ProcessorAlertData: Stopped 2026-01-04 07:29:35.1801 AlertProcessor ProcessorAlertData: started 2026-01-04 07:29:38.1333 DFramework.Scheduler.TaskBase /* Time Taken: 15515.7412*/ Opportunity Out Of Stock By Outlet 2026-01-04 07:29:40.1177 AlertProcessor ProcessorAlertData: Stopped 2026-01-04 07:34:35.1980 AlertProcessor ProcessorAlertData: started 2026-01-04 07:34:40.1512 AlertProcessor ProcessorAlertData: Stopped 2026-01-04 07:39:35.2159 AlertProcessor ProcessorAlertData: started 2026-01-04 07:39:40.1534 AlertProcessor ProcessorAlertData: Stopped 2026-01-04 07:44:23.1555 DFramework.Database.Query /* Time Taken: 518*/ [dbo].GenerateSystemAlerts 2026-01-04 07:44:35.2337 AlertProcessor ProcessorAlertData: started 2026-01-04 07:44:38.2338 DFramework.Scheduler.TaskBase /* Time Taken: 15593.8685*/ Opportunity Out Of Stock By Outlet 2026-01-04 07:44:40.2025 AlertProcessor ProcessorAlertData: Stopped 2026-01-04 07:49:35.2516 AlertProcessor ProcessorAlertData: started 2026-01-04 07:49:40.2204 AlertProcessor ProcessorAlertData: Stopped 2026-01-04 07:54:35.2695 AlertProcessor ProcessorAlertData: started 2026-01-04 07:54:40.1758 AlertProcessor ProcessorAlertData: Stopped 2026-01-04 07:59:35.2718 AlertProcessor ProcessorAlertData: started 2026-01-04 07:59:38.1781 DFramework.Scheduler.TaskBase /* Time Taken: 15515.7515*/ Opportunity Out Of Stock By Outlet 2026-01-04 07:59:40.2563 AlertProcessor ProcessorAlertData: Stopped 2026-01-04 08:04:35.2742 AlertProcessor ProcessorAlertData: started 2026-01-04 08:04:40.3523 AlertProcessor ProcessorAlertData: Stopped 2026-01-04 08:09:35.2921 AlertProcessor ProcessorAlertData: started 2026-01-04 08:09:40.3077 AlertProcessor ProcessorAlertData: Stopped 2026-01-04 08:14:35.3100 AlertProcessor ProcessorAlertData: started 2026-01-04 08:14:38.2319 DFramework.Scheduler.TaskBase /* Time Taken: 15546.9942*/ Opportunity Out Of Stock By Outlet 2026-01-04 08:14:40.3569 AlertProcessor ProcessorAlertData: Stopped 2026-01-04 08:19:35.3279 AlertProcessor ProcessorAlertData: started 2026-01-04 08:19:40.4685 AlertProcessor ProcessorAlertData: Stopped 2026-01-04 08:24:35.3302 AlertProcessor ProcessorAlertData: started 2026-01-04 08:24:40.3771 AlertProcessor ProcessorAlertData: Stopped 2026-01-04 08:29:35.3481 AlertProcessor ProcessorAlertData: started 2026-01-04 08:29:38.3012 DFramework.Scheduler.TaskBase /* Time Taken: 15593.8776*/ Opportunity Out Of Stock By Outlet 2026-01-04 08:29:40.3794 AlertProcessor ProcessorAlertData: Stopped 2026-01-04 08:34:35.3660 AlertProcessor ProcessorAlertData: started 2026-01-04 08:34:40.7098 AlertProcessor ProcessorAlertData: Stopped 2026-01-04 08:39:35.3839 AlertProcessor ProcessorAlertData: started 2026-01-04 08:39:40.8527 AlertProcessor ProcessorAlertData: Stopped 2026-01-04 08:44:35.4018 AlertProcessor ProcessorAlertData: started 2026-01-04 08:44:37.7768 DFramework.Database.NullableDataReader Data reader open for 275 at System.Environment.GetStackTrace(Exception e, Boolean needFileInfo) at System.Environment.get_StackTrace() at DFramework.Database.NullableDataReader.Dispose(Boolean disposing) in D:\Spraxa\Framework\DFramework\Database\NullableDataReader.cs:line 33 at DFramework.Database.NullableDataReader.Dispose() in D:\Spraxa\Framework\DFramework\Database\NullableDataReader.cs:line 44 at CoolR.Tasks.ProcessAlertData.Execute() in D:\Spraxa\CoolR-Group\portal\CoolR.Tasks\ProcessAlertData.cs:line 47 at DFramework.Scheduler.TaskBase.Run() in D:\Spraxa\Framework\DFramework.Scheduler\TaskBase.cs:line 176 at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx) at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx) at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state) at System.Threading.ThreadHelper.ThreadStart() 2026-01-04 08:44:38.2924 DFramework.Scheduler.TaskBase /* Time Taken: 15562.6173*/ Opportunity Out Of Stock By Outlet 2026-01-04 08:44:40.9800 AlertProcessor ProcessorAlertData: Stopped 2026-01-04 08:49:35.4197 AlertProcessor ProcessorAlertData: started 2026-01-04 08:49:40.8103 AlertProcessor ProcessorAlertData: Stopped 2026-01-04 08:54:35.4376 AlertProcessor ProcessorAlertData: started 2026-01-04 08:54:40.8595 AlertProcessor ProcessorAlertData: Stopped 2026-01-04 08:59:23.2835 DFramework.Database.Query /* Time Taken: 534*/ [dbo].GenerateSystemAlerts 2026-01-04 08:59:35.4555 AlertProcessor ProcessorAlertData: started 2026-01-04 08:59:38.3774 DFramework.Scheduler.TaskBase /* Time Taken: 15625.1134*/ Opportunity Out Of Stock By Outlet 2026-01-04 08:59:40.9243 AlertProcessor ProcessorAlertData: Stopped 2026-01-04 09:04:35.4734 AlertProcessor ProcessorAlertData: started 2026-01-04 09:04:40.8953 AlertProcessor ProcessorAlertData: Stopped 2026-01-04 09:09:35.4757 AlertProcessor ProcessorAlertData: started 2026-01-04 09:09:40.9601 AlertProcessor ProcessorAlertData: Stopped 2026-01-04 09:14:35.4779 AlertProcessor ProcessorAlertData: started 2026-01-04 09:14:38.3373 DFramework.Scheduler.TaskBase /* Time Taken: 15578.2419*/ Opportunity Out Of Stock By Outlet 2026-01-04 09:14:40.9467 AlertProcessor ProcessorAlertData: Stopped 2026-01-04 09:19:35.4958 AlertProcessor ProcessorAlertData: started 2026-01-04 09:19:40.9959 AlertProcessor ProcessorAlertData: Stopped 2026-01-04 09:24:35.5136 AlertProcessor ProcessorAlertData: started 2026-01-04 09:24:41.0293 AlertProcessor ProcessorAlertData: Stopped 2026-01-04 09:29:35.5159 AlertProcessor ProcessorAlertData: started 2026-01-04 09:29:38.3284 DFramework.Scheduler.TaskBase /* Time Taken: 15562.6135*/ Opportunity Out Of Stock By Outlet 2026-01-04 09:29:40.8284 AlertProcessor ProcessorAlertData: Stopped 2026-01-04 09:34:35.5181 AlertProcessor ProcessorAlertData: started 2026-01-04 09:34:41.0181 AlertProcessor ProcessorAlertData: Stopped 2026-01-04 09:39:35.5205 AlertProcessor ProcessorAlertData: started 2026-01-04 09:39:40.8486 AlertProcessor ProcessorAlertData: Stopped 2026-01-04 09:44:23.2728 DFramework.Database.Query /* Time Taken: 505*/ [dbo].GenerateSystemAlerts 2026-01-04 09:44:35.5385 AlertProcessor ProcessorAlertData: started 2026-01-04 09:44:38.3354 DFramework.Scheduler.TaskBase /* Time Taken: 15562.6152*/ Opportunity Out Of Stock By Outlet 2026-01-04 09:44:40.9135 AlertProcessor ProcessorAlertData: Stopped 2026-01-04 09:49:35.5564 AlertProcessor ProcessorAlertData: started 2026-01-04 09:49:40.9315 AlertProcessor ProcessorAlertData: Stopped 2026-01-04 09:54:35.5743 AlertProcessor ProcessorAlertData: started 2026-01-04 09:54:40.9337 AlertProcessor ProcessorAlertData: Stopped 2026-01-04 09:59:35.5766 AlertProcessor ProcessorAlertData: started 2026-01-04 09:59:38.3579 DFramework.Scheduler.TaskBase /* Time Taken: 15562.6205*/ Opportunity Out Of Stock By Outlet 2026-01-04 09:59:41.0767 AlertProcessor ProcessorAlertData: Stopped 2026-01-04 10:04:35.5789 AlertProcessor ProcessorAlertData: started 2026-01-04 10:04:40.9696 AlertProcessor ProcessorAlertData: Stopped 2026-01-04 10:09:35.5968 AlertProcessor ProcessorAlertData: started 2026-01-04 10:09:41.0344 AlertProcessor ProcessorAlertData: Stopped 2026-01-04 10:14:23.3490 DFramework.Database.Query /* Time Taken: 555*/ [dbo].GenerateSystemAlerts 2026-01-04 10:14:35.6147 AlertProcessor ProcessorAlertData: started 2026-01-04 10:14:38.4429 DFramework.Scheduler.TaskBase /* Time Taken: 15640.7437*/ Opportunity Out Of Stock By Outlet 2026-01-04 10:14:41.0835 AlertProcessor ProcessorAlertData: Stopped 2026-01-04 10:19:35.6326 AlertProcessor ProcessorAlertData: started 2026-01-04 10:19:40.9920 AlertProcessor ProcessorAlertData: Stopped 2026-01-04 10:24:35.6505 AlertProcessor ProcessorAlertData: started 2026-01-04 10:24:41.1193 AlertProcessor ProcessorAlertData: Stopped 2026-01-04 10:29:23.3246 DFramework.Database.Query /* Time Taken: 502*/ [dbo].GenerateSystemAlerts 2026-01-04 10:29:35.6684 AlertProcessor ProcessorAlertData: started 2026-01-04 10:29:38.3872 DFramework.Scheduler.TaskBase /* Time Taken: 15562.6164*/ Opportunity Out Of Stock By Outlet 2026-01-04 10:29:41.0278 AlertProcessor ProcessorAlertData: Stopped 2026-01-04 10:34:35.6863 AlertProcessor ProcessorAlertData: started 2026-01-04 10:34:41.1395 AlertProcessor ProcessorAlertData: Stopped 2026-01-04 10:39:35.7042 AlertProcessor ProcessorAlertData: started 2026-01-04 10:39:41.0480 AlertProcessor ProcessorAlertData: Stopped 2026-01-04 10:44:35.7221 AlertProcessor ProcessorAlertData: started 2026-01-04 10:44:38.4097 DFramework.Scheduler.TaskBase /* Time Taken: 15562.6198*/ Opportunity Out Of Stock By Outlet 2026-01-04 10:44:41.1128 AlertProcessor ProcessorAlertData: Stopped 2026-01-04 10:49:35.7399 AlertProcessor ProcessorAlertData: started 2026-01-04 10:49:41.2087 AlertProcessor ProcessorAlertData: Stopped 2026-01-04 10:54:35.7577 AlertProcessor ProcessorAlertData: started 2026-01-04 10:54:41.1640 AlertProcessor ProcessorAlertData: Stopped 2026-01-04 10:59:35.7756 AlertProcessor ProcessorAlertData: started 2026-01-04 10:59:38.4319 DFramework.Scheduler.TaskBase /* Time Taken: 15562.6191*/ Opportunity Out Of Stock By Outlet 2026-01-04 10:59:41.2444 AlertProcessor ProcessorAlertData: Stopped 2026-01-04 11:04:35.7779 AlertProcessor ProcessorAlertData: started 2026-01-04 11:04:41.0279 AlertProcessor ProcessorAlertData: Stopped 2026-01-04 11:09:35.7959 AlertProcessor ProcessorAlertData: started 2026-01-04 11:09:41.2959 AlertProcessor ProcessorAlertData: Stopped 2026-01-04 11:14:35.8138 AlertProcessor ProcessorAlertData: started 2026-01-04 11:14:38.4545 DFramework.Scheduler.TaskBase /* Time Taken: 15562.6184*/ Opportunity Out Of Stock By Outlet 2026-01-04 11:14:41.1889 AlertProcessor ProcessorAlertData: Stopped 2026-01-04 11:19:35.8161 AlertProcessor ProcessorAlertData: started 2026-01-04 11:19:41.2536 AlertProcessor ProcessorAlertData: Stopped 2026-01-04 11:24:35.8184 AlertProcessor ProcessorAlertData: started 2026-01-04 11:24:41.2872 AlertProcessor ProcessorAlertData: Stopped 2026-01-04 11:29:23.4456 DFramework.Database.Query /* Time Taken: 531*/ [dbo].GenerateSystemAlerts 2026-01-04 11:29:35.8207 AlertProcessor ProcessorAlertData: started 2026-01-04 11:29:38.5394 DFramework.Scheduler.TaskBase /* Time Taken: 15625.1235*/ Opportunity Out Of Stock By Outlet 2026-01-04 11:29:41.1488 AlertProcessor ProcessorAlertData: Stopped 2026-01-04 11:34:35.8386 AlertProcessor ProcessorAlertData: started 2026-01-04 11:34:41.2448 AlertProcessor ProcessorAlertData: Stopped 2026-01-04 11:39:35.8565 AlertProcessor ProcessorAlertData: started 2026-01-04 11:39:41.2002 AlertProcessor ProcessorAlertData: Stopped 2026-01-04 11:44:35.8743 AlertProcessor ProcessorAlertData: started 2026-01-04 11:44:38.5462 DFramework.Scheduler.TaskBase /* Time Taken: 15609.4947*/ Opportunity Out Of Stock By Outlet 2026-01-04 11:44:41.2650 AlertProcessor ProcessorAlertData: Stopped 2026-01-04 11:49:35.8766 AlertProcessor ProcessorAlertData: started 2026-01-04 11:49:41.2985 AlertProcessor ProcessorAlertData: Stopped 2026-01-04 11:54:35.8788 AlertProcessor ProcessorAlertData: started 2026-01-04 11:54:41.2382 AlertProcessor ProcessorAlertData: Stopped 2026-01-04 11:59:23.4747 DFramework.Database.Query /* Time Taken: 517*/ [dbo].GenerateSystemAlerts 2026-01-04 11:59:35.8811 AlertProcessor ProcessorAlertData: started 2026-01-04 11:59:38.5686 DFramework.Scheduler.TaskBase /* Time Taken: 15609.4904*/ Opportunity Out Of Stock By Outlet 2026-01-04 11:59:41.3186 AlertProcessor ProcessorAlertData: Stopped 2026-01-04 12:04:35.8989 AlertProcessor ProcessorAlertData: started 2026-01-04 12:04:41.3052 AlertProcessor ProcessorAlertData: Stopped 2026-01-04 12:09:35.9168 AlertProcessor ProcessorAlertData: started 2026-01-04 12:09:41.4325 AlertProcessor ProcessorAlertData: Stopped 2026-01-04 12:14:23.4815 DFramework.Database.Query /* Time Taken: 524*/ [dbo].GenerateSystemAlerts 2026-01-04 12:14:35.9348 AlertProcessor ProcessorAlertData: started 2026-01-04 12:14:38.5754 DFramework.Scheduler.TaskBase /* Time Taken: 15609.4975*/ Opportunity Out Of Stock By Outlet 2026-01-04 12:14:41.4504 AlertProcessor ProcessorAlertData: Stopped 2026-01-04 12:19:35.9371 AlertProcessor ProcessorAlertData: started 2026-01-04 12:19:41.4527 AlertProcessor ProcessorAlertData: Stopped 2026-01-04 12:24:35.9550 AlertProcessor ProcessorAlertData: started 2026-01-04 12:24:41.5019 DFramework.Database.Query /* Time Taken: 551*/ DECLARE @TableName AnsiString(8000) SET @TableName = 'ProductStockLevel' DECLARE @CurrentRecordId Int32 SET @CurrentRecordId = '3675525' dbo.GetValidDeviceForAlertProcessData 2026-01-04 12:24:41.5644 AlertProcessor ProcessorAlertData: Stopped 2026-01-04 12:29:35.9729 AlertProcessor ProcessorAlertData: started 2026-01-04 12:29:38.5354 DFramework.Scheduler.TaskBase /* Time Taken: 15562.6156*/ Opportunity Out Of Stock By Outlet 2026-01-04 12:29:41.4261 AlertProcessor ProcessorAlertData: Stopped 2026-01-04 12:34:35.9752 AlertProcessor ProcessorAlertData: started 2026-01-04 12:34:41.4440 AlertProcessor ProcessorAlertData: Stopped 2026-01-04 12:39:35.9931 AlertProcessor ProcessorAlertData: started 2026-01-04 12:39:41.3682 AlertProcessor ProcessorAlertData: Stopped 2026-01-04 12:44:23.5109 DFramework.Database.Query /* Time Taken: 533*/ [dbo].GenerateSystemAlerts 2026-01-04 12:44:36.0110 AlertProcessor ProcessorAlertData: started 2026-01-04 12:44:38.6048 DFramework.Scheduler.TaskBase /* Time Taken: 15625.1318*/ Opportunity Out Of Stock By Outlet 2026-01-04 12:44:41.4642 AlertProcessor ProcessorAlertData: Stopped 2026-01-04 12:49:36.0289 AlertProcessor ProcessorAlertData: started 2026-01-04 12:49:41.3102 AlertProcessor ProcessorAlertData: Stopped 2026-01-04 12:54:36.0312 AlertProcessor ProcessorAlertData: started 2026-01-04 12:54:39.0000 DFramework.Database.Query /* Time Taken: 521*/ DECLARE @TableName AnsiString(8000) SET @TableName = 'AssetStockProductWiseConsolidate' DECLARE @CurrentRecordId Int32 SET @CurrentRecordId = '3675525' dbo.GetValidDeviceForAlertProcessData 2026-01-04 12:54:41.5000 AlertProcessor ProcessorAlertData: Stopped 2026-01-04 12:59:36.0335 AlertProcessor ProcessorAlertData: started 2026-01-04 12:59:38.5648 DFramework.Scheduler.TaskBase /* Time Taken: 15562.6238*/ Opportunity Out Of Stock By Outlet 2026-01-04 12:59:41.4085 AlertProcessor ProcessorAlertData: Stopped 2026-01-04 13:04:36.0358 AlertProcessor ProcessorAlertData: started 2026-01-04 13:04:41.4108 AlertProcessor ProcessorAlertData: Stopped 2026-01-04 13:09:36.0381 AlertProcessor ProcessorAlertData: started 2026-01-04 13:09:41.5381 AlertProcessor ProcessorAlertData: Stopped 2026-01-04 13:14:23.5402 DFramework.Database.Query /* Time Taken: 521*/ [dbo].GenerateSystemAlerts 2026-01-04 13:14:36.0560 AlertProcessor ProcessorAlertData: started 2026-01-04 13:14:38.6341 DFramework.Scheduler.TaskBase /* Time Taken: 15609.4942*/ Opportunity Out Of Stock By Outlet 2026-01-04 13:14:41.3998 AlertProcessor ProcessorAlertData: Stopped 2026-01-04 13:19:36.0739 AlertProcessor ProcessorAlertData: started 2026-01-04 13:19:41.5583 AlertProcessor ProcessorAlertData: Stopped 2026-01-04 13:24:36.0916 AlertProcessor ProcessorAlertData: started 2026-01-04 13:24:39.1229 DFramework.Database.Query /* Time Taken: 582*/ DECLARE @TableName AnsiString(8000) SET @TableName = 'AssetStockProductWiseConsolidate' DECLARE @CurrentRecordId Int32 SET @CurrentRecordId = '3675525' dbo.GetValidDeviceForAlertProcessData 2026-01-04 13:24:41.6385 AlertProcessor ProcessorAlertData: Stopped 2026-01-04 13:29:36.1095 AlertProcessor ProcessorAlertData: started 2026-01-04 13:29:38.6095 DFramework.Scheduler.TaskBase /* Time Taken: 15562.6156*/ Opportunity Out Of Stock By Outlet 2026-01-04 13:29:41.4689 AlertProcessor ProcessorAlertData: Stopped 2026-01-04 13:34:36.1273 AlertProcessor ProcessorAlertData: started 2026-01-04 13:34:41.4711 AlertProcessor ProcessorAlertData: Stopped 2026-01-04 13:39:36.1453 AlertProcessor ProcessorAlertData: started 2026-01-04 13:39:41.6453 AlertProcessor ProcessorAlertData: Stopped 2026-01-04 13:44:36.1632 AlertProcessor ProcessorAlertData: started 2026-01-04 13:44:38.6164 DFramework.Scheduler.TaskBase /* Time Taken: 15562.6331*/ Opportunity Out Of Stock By Outlet 2026-01-04 13:44:41.6320 AlertProcessor ProcessorAlertData: Stopped 2026-01-04 13:49:36.1812 AlertProcessor ProcessorAlertData: started 2026-01-04 13:49:41.5093 AlertProcessor ProcessorAlertData: Stopped 2026-01-04 13:54:36.1991 AlertProcessor ProcessorAlertData: started 2026-01-04 13:54:39.1366 DFramework.Database.Query /* Time Taken: 526*/ DECLARE @TableName AnsiString(8000) SET @TableName = 'AssetStockProductWiseConsolidate' DECLARE @CurrentRecordId Int32 SET @CurrentRecordId = '3675525' dbo.GetValidDeviceForAlertProcessData 2026-01-04 13:54:41.6522 AlertProcessor ProcessorAlertData: Stopped 2026-01-04 13:59:23.5762 DFramework.Database.Query /* Time Taken: 528*/ [dbo].GenerateSystemAlerts 2026-01-04 13:59:36.2170 AlertProcessor ProcessorAlertData: started 2026-01-04 13:59:38.6857 DFramework.Scheduler.TaskBase /* Time Taken: 15625.1185*/ Opportunity Out Of Stock By Outlet 2026-01-04 13:59:41.6858 AlertProcessor ProcessorAlertData: Stopped 2026-01-04 14:04:36.2349 AlertProcessor ProcessorAlertData: started 2026-01-04 14:04:41.7193 AlertProcessor ProcessorAlertData: Stopped 2026-01-04 14:06:06.7043 DFramework.Database.Query /* Time Taken: 1198*/ DECLARE @IsFileProcessed Int32 SET @IsFileProcessed = '0' DECLARE @TaskNumber Int32 SET @TaskNumber = '3' DECLARE @IsDeleted Int32 SET @IsDeleted = '0' SELECT TOP 1000 IncomingFileId, GatewayId,GatewayMac,RawFileName,AzureContainerName,StartIndex,Tries, CreatedOn FROM IncomingFile WHERE [IsFileProcessed] = @IsFileProcessed AND [TaskNumber] = @TaskNumber AND [IsDeleted] = @IsDeleted 2026-01-04 14:09:36.2528 AlertProcessor ProcessorAlertData: started 2026-01-04 14:09:41.7528 AlertProcessor ProcessorAlertData: Stopped 2026-01-04 14:14:36.2707 AlertProcessor ProcessorAlertData: started 2026-01-04 14:14:37.1613 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() 2026-01-04 14:14:38.6457 DFramework.Scheduler.TaskBase /* Time Taken: 15562.6198*/ Opportunity Out Of Stock By Outlet 2026-01-04 14:14:41.8645 AlertProcessor ProcessorAlertData: Stopped 2026-01-04 14:19:36.2885 AlertProcessor ProcessorAlertData: started 2026-01-04 14:19:41.7886 AlertProcessor ProcessorAlertData: Stopped 2026-01-04 14:24:36.3064 AlertProcessor ProcessorAlertData: started 2026-01-04 14:24:41.6502 AlertProcessor ProcessorAlertData: Stopped 2026-01-04 14:29:36.3243 AlertProcessor ProcessorAlertData: started 2026-01-04 14:29:38.6681 DFramework.Scheduler.TaskBase /* Time Taken: 15562.6185*/ Opportunity Out Of Stock By Outlet 2026-01-04 14:29:41.7150 AlertProcessor ProcessorAlertData: Stopped 2026-01-04 14:34:36.3265 AlertProcessor ProcessorAlertData: started 2026-01-04 14:34:41.6859 AlertProcessor ProcessorAlertData: Stopped 2026-01-04 14:39:36.3444 AlertProcessor ProcessorAlertData: started 2026-01-04 14:39:41.7038 AlertProcessor ProcessorAlertData: Stopped 2026-01-04 14:44:36.3623 AlertProcessor ProcessorAlertData: started 2026-01-04 14:44:38.6904 DFramework.Scheduler.TaskBase /* Time Taken: 15562.6148*/ Opportunity Out Of Stock By Outlet 2026-01-04 14:44:41.7217 AlertProcessor ProcessorAlertData: Stopped 2026-01-04 14:49:36.3802 AlertProcessor ProcessorAlertData: started 2026-01-04 14:49:41.7553 AlertProcessor ProcessorAlertData: Stopped 2026-01-04 14:54:36.3825 AlertProcessor ProcessorAlertData: started 2026-01-04 14:54:41.8357 AlertProcessor ProcessorAlertData: Stopped 2026-01-04 14:59:23.6659 DFramework.Database.Query /* Time Taken: 530*/ [dbo].GenerateSystemAlerts 2026-01-04 14:59:36.3848 AlertProcessor ProcessorAlertData: started 2026-01-04 14:59:38.7598 DFramework.Scheduler.TaskBase /* Time Taken: 15609.505*/ Opportunity Out Of Stock By Outlet 2026-01-04 14:59:41.8536 AlertProcessor ProcessorAlertData: Stopped 2026-01-04 15:04:36.4027 AlertProcessor ProcessorAlertData: started 2026-01-04 15:04:41.8558 AlertProcessor ProcessorAlertData: Stopped 2026-01-04 15:09:36.4205 AlertProcessor ProcessorAlertData: started 2026-01-04 15:09:41.8893 AlertProcessor ProcessorAlertData: Stopped 2026-01-04 15:14:23.6883 DFramework.Database.Query /* Time Taken: 517*/ [dbo].GenerateSystemAlerts 2026-01-04 15:14:36.4228 AlertProcessor ProcessorAlertData: started 2026-01-04 15:14:38.7978 DFramework.Scheduler.TaskBase /* Time Taken: 15625.1103*/ Opportunity Out Of Stock By Outlet 2026-01-04 15:14:41.7353 AlertProcessor ProcessorAlertData: Stopped 2026-01-04 15:19:36.4250 AlertProcessor ProcessorAlertData: started 2026-01-04 15:19:41.9094 AlertProcessor ProcessorAlertData: Stopped 2026-01-04 15:24:36.4429 AlertProcessor ProcessorAlertData: started 2026-01-04 15:24:41.8179 AlertProcessor ProcessorAlertData: Stopped 2026-01-04 15:29:23.6950 DFramework.Database.Query /* Time Taken: 526*/ [dbo].GenerateSystemAlerts 2026-01-04 15:29:36.4607 AlertProcessor ProcessorAlertData: started 2026-01-04 15:29:38.7889 DFramework.Scheduler.TaskBase /* Time Taken: 15609.4946*/ Opportunity Out Of Stock By Outlet 2026-01-04 15:29:41.9295 AlertProcessor ProcessorAlertData: Stopped 2026-01-04 15:34:36.4630 AlertProcessor ProcessorAlertData: started 2026-01-04 15:34:41.8849 AlertProcessor ProcessorAlertData: Stopped 2026-01-04 15:39:36.4810 AlertProcessor ProcessorAlertData: started 2026-01-04 15:39:41.7467 AlertProcessor ProcessorAlertData: Stopped 2026-01-04 15:44:23.7020 DFramework.Database.Query /* Time Taken: 530*/ [dbo].GenerateSystemAlerts 2026-01-04 15:44:36.4990 AlertProcessor ProcessorAlertData: started 2026-01-04 15:44:38.8115 DFramework.Scheduler.TaskBase /* Time Taken: 15625.1183*/ Opportunity Out Of Stock By Outlet 2026-01-04 15:44:41.9053 AlertProcessor ProcessorAlertData: Stopped 2026-01-04 15:49:36.5013 AlertProcessor ProcessorAlertData: started 2026-01-04 15:49:41.9701 AlertProcessor ProcessorAlertData: Stopped 2026-01-04 15:54:36.5191 AlertProcessor ProcessorAlertData: started 2026-01-04 15:54:41.9254 AlertProcessor ProcessorAlertData: Stopped 2026-01-04 15:59:36.5369 AlertProcessor ProcessorAlertData: started 2026-01-04 15:59:38.7557 DFramework.Scheduler.TaskBase /* Time Taken: 15562.6156*/ Opportunity Out Of Stock By Outlet 2026-01-04 15:59:41.9276 AlertProcessor ProcessorAlertData: Stopped 2026-01-04 16:04:36.5548 AlertProcessor ProcessorAlertData: started 2026-01-04 16:04:42.0080 AlertProcessor ProcessorAlertData: Stopped 2026-01-04 16:09:36.5727 AlertProcessor ProcessorAlertData: started 2026-01-04 16:09:41.9790 AlertProcessor ProcessorAlertData: Stopped 2026-01-04 16:14:23.7311 DFramework.Database.Query /* Time Taken: 533*/ [dbo].GenerateSystemAlerts 2026-01-04 16:14:36.5749 AlertProcessor ProcessorAlertData: started 2026-01-04 16:14:38.8250 DFramework.Scheduler.TaskBase /* Time Taken: 15625.1169*/ Opportunity Out Of Stock By Outlet 2026-01-04 16:14:41.8875 AlertProcessor ProcessorAlertData: Stopped 2026-01-04 16:19:36.5772 AlertProcessor ProcessorAlertData: started 2026-01-04 16:19:41.9835 AlertProcessor ProcessorAlertData: Stopped 2026-01-04 16:24:36.5951 AlertProcessor ProcessorAlertData: started 2026-01-04 16:24:42.0170 AlertProcessor ProcessorAlertData: Stopped 2026-01-04 16:29:23.7535 DFramework.Database.Query /* Time Taken: 548*/ [dbo].GenerateSystemAlerts 2026-01-04 16:29:36.6130 AlertProcessor ProcessorAlertData: started 2026-01-04 16:29:38.8317 DFramework.Scheduler.TaskBase /* Time Taken: 15625.1186*/ Opportunity Out Of Stock By Outlet 2026-01-04 16:29:42.0505 AlertProcessor ProcessorAlertData: Stopped 2026-01-04 16:34:36.6309 AlertProcessor ProcessorAlertData: started 2026-01-04 16:34:42.0841 AlertProcessor ProcessorAlertData: Stopped 2026-01-04 16:39:36.6332 AlertProcessor ProcessorAlertData: started 2026-01-04 16:39:42.0239 AlertProcessor ProcessorAlertData: Stopped 2026-01-04 16:44:36.6355 AlertProcessor ProcessorAlertData: started 2026-01-04 16:44:38.7917 DFramework.Scheduler.TaskBase /* Time Taken: 15562.6204*/ Opportunity Out Of Stock By Outlet 2026-01-04 16:44:42.0574 AlertProcessor ProcessorAlertData: Stopped 2026-01-04 16:49:36.6378 AlertProcessor ProcessorAlertData: started 2026-01-04 16:49:42.0597 AlertProcessor ProcessorAlertData: Stopped 2026-01-04 16:54:36.6401 AlertProcessor ProcessorAlertData: started 2026-01-04 16:54:42.1245 AlertProcessor ProcessorAlertData: Stopped 2026-01-04 16:59:23.7672 DFramework.Database.Query /* Time Taken: 530*/ [dbo].GenerateSystemAlerts 2026-01-04 16:59:36.6423 AlertProcessor ProcessorAlertData: started 2026-01-04 16:59:38.8767 DFramework.Scheduler.TaskBase /* Time Taken: 15625.12*/ Opportunity Out Of Stock By Outlet 2026-01-04 16:59:42.0486 AlertProcessor ProcessorAlertData: Stopped 2026-01-04 17:04:36.6446 AlertProcessor ProcessorAlertData: started 2026-01-04 17:04:42.1134 AlertProcessor ProcessorAlertData: Stopped 2026-01-04 17:09:36.6626 AlertProcessor ProcessorAlertData: started 2026-01-04 17:09:42.1783 AlertProcessor ProcessorAlertData: Stopped 2026-01-04 17:14:23.8054 DFramework.Database.Query /* Time Taken: 540*/ [dbo].GenerateSystemAlerts 2026-01-04 17:14:36.6805 AlertProcessor ProcessorAlertData: started 2026-01-04 17:14:38.8993 DFramework.Scheduler.TaskBase /* Time Taken: 15625.1366*/ Opportunity Out Of Stock By Outlet 2026-01-04 17:14:42.2118 AlertProcessor ProcessorAlertData: Stopped 2026-01-04 17:19:36.6984 AlertProcessor ProcessorAlertData: started 2026-01-04 17:19:42.1047 AlertProcessor ProcessorAlertData: Stopped 2026-01-04 17:24:36.7164 AlertProcessor ProcessorAlertData: started 2026-01-04 17:24:42.1851 AlertProcessor ProcessorAlertData: Stopped 2026-01-04 17:29:23.8279 DFramework.Database.Query /* Time Taken: 546*/ [dbo].GenerateSystemAlerts 2026-01-04 17:29:36.7343 AlertProcessor ProcessorAlertData: started 2026-01-04 17:29:38.8749 DFramework.Scheduler.TaskBase /* Time Taken: 15593.8708*/ Opportunity Out Of Stock By Outlet 2026-01-04 17:29:42.1093 AlertProcessor ProcessorAlertData: Stopped 2026-01-04 17:34:36.7366 AlertProcessor ProcessorAlertData: started 2026-01-04 17:34:42.0960 AlertProcessor ProcessorAlertData: Stopped 2026-01-04 17:39:36.7388 AlertProcessor ProcessorAlertData: started 2026-01-04 17:39:41.9732 AlertProcessor ProcessorAlertData: Stopped 2026-01-04 17:44:23.8035 DFramework.Database.Query /* Time Taken: 525*/ [dbo].GenerateSystemAlerts 2026-01-04 17:44:36.7411 AlertProcessor ProcessorAlertData: started 2026-01-04 17:44:38.8974 DFramework.Scheduler.TaskBase /* Time Taken: 15609.4919*/ Opportunity Out Of Stock By Outlet 2026-01-04 17:44:42.2255 AlertProcessor ProcessorAlertData: Stopped 2026-01-04 17:49:36.7434 AlertProcessor ProcessorAlertData: started 2026-01-04 17:49:42.1653 AlertProcessor ProcessorAlertData: Stopped 2026-01-04 17:54:36.7613 AlertProcessor ProcessorAlertData: started 2026-01-04 17:54:42.5270 AlertProcessor ProcessorAlertData: Stopped 2026-01-04 17:59:23.8260 DFramework.Database.Query /* Time Taken: 525*/ [dbo].GenerateSystemAlerts 2026-01-04 17:59:36.7792 AlertProcessor ProcessorAlertData: started 2026-01-04 17:59:38.9667 DFramework.Scheduler.TaskBase /* Time Taken: 15656.373*/ Opportunity Out Of Stock By Outlet 2026-01-04 17:59:42.2324 AlertProcessor ProcessorAlertData: Stopped 2026-01-04 18:04:36.7971 AlertProcessor ProcessorAlertData: started 2026-01-04 18:04:42.2503 AlertProcessor ProcessorAlertData: Stopped 2026-01-04 18:09:36.7994 AlertProcessor ProcessorAlertData: started 2026-01-04 18:09:42.2057 AlertProcessor ProcessorAlertData: Stopped 2026-01-04 18:14:36.8173 AlertProcessor ProcessorAlertData: started 2026-01-04 18:14:38.8954 DFramework.Scheduler.TaskBase /* Time Taken: 15562.6224*/ Opportunity Out Of Stock By Outlet 2026-01-04 18:14:42.1767 AlertProcessor ProcessorAlertData: Stopped 2026-01-04 18:19:36.8195 AlertProcessor ProcessorAlertData: started 2026-01-04 18:19:42.2727 AlertProcessor ProcessorAlertData: Stopped 2026-01-04 18:24:36.8375 AlertProcessor ProcessorAlertData: started 2026-01-04 18:24:42.2750 AlertProcessor ProcessorAlertData: Stopped 2026-01-04 18:29:36.8553 AlertProcessor ProcessorAlertData: started 2026-01-04 18:29:38.9179 DFramework.Scheduler.TaskBase /* Time Taken: 15562.6184*/ Opportunity Out Of Stock By Outlet 2026-01-04 18:29:42.3398 AlertProcessor ProcessorAlertData: Stopped 2026-01-04 18:34:26.9826 MoveToReorder Running task for ClientId : 286 and ClientName = India Office QA and Slot: 1/5/2026 8:00:00 AM And LastExecutedOn: 1/3/2026 10:04:23 PM 2026-01-04 18:34:36.8732 AlertProcessor ProcessorAlertData: started 2026-01-04 18:34:42.5139 AlertProcessor ProcessorAlertData: Stopped 2026-01-04 18:35:07.6079 DFramework.Database.NullableDataReader Data reader open for 40206 at System.Environment.GetStackTrace(Exception e, Boolean needFileInfo) at System.Environment.get_StackTrace() at DFramework.Database.NullableDataReader.Dispose(Boolean disposing) in D:\Spraxa\Framework\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() 2026-01-04 18:35:07.6391 MoveToReorder Task executed successfully for ClientId : 286 Client Name:India Office QA, Slot: 1/5/2026 8:00:00 AM and Total Order Suggested: 127 Out Of: 127 2026-01-04 18:35:09.0610 DFramework.Scheduler.TaskBase /* Time Taken: 42390.9441*/ Move To Re-Order 2026-01-04 18:39:36.8912 AlertProcessor ProcessorAlertData: started 2026-01-04 18:39:42.4068 AlertProcessor ProcessorAlertData: Stopped 2026-01-04 18:44:36.9090 AlertProcessor ProcessorAlertData: started 2026-01-04 18:44:38.5340 DFramework.Database.Query /* Time Taken: 505*/ DECLARE @TableName AnsiString(8000) SET @TableName = 'AdditionalShelf' DECLARE @CurrentRecordId Int32 SET @CurrentRecordId = '3675525' dbo.GetValidDeviceForAlertProcessData 2026-01-04 18:44:38.9403 DFramework.Scheduler.TaskBase /* Time Taken: 15562.6119*/ Opportunity Out Of Stock By Outlet 2026-01-04 18:44:42.3309 AlertProcessor ProcessorAlertData: Stopped 2026-01-04 18:49:36.9268 AlertProcessor ProcessorAlertData: started 2026-01-04 18:49:42.2862 AlertProcessor ProcessorAlertData: Stopped 2026-01-04 18:54:36.9447 AlertProcessor ProcessorAlertData: started 2026-01-04 18:54:42.3979 AlertProcessor ProcessorAlertData: Stopped 2026-01-04 18:59:23.9000 DFramework.Database.Query /* Time Taken: 516*/ [dbo].GenerateSystemAlerts 2026-01-04 18:59:36.9626 AlertProcessor ProcessorAlertData: started 2026-01-04 18:59:38.9939 DFramework.Scheduler.TaskBase /* Time Taken: 15609.5001*/ Opportunity Out Of Stock By Outlet 2026-01-04 18:59:42.4626 AlertProcessor ProcessorAlertData: Stopped 2026-01-04 19:04:36.9805 AlertProcessor ProcessorAlertData: started 2026-01-04 19:04:42.4336 AlertProcessor ProcessorAlertData: Stopped 2026-01-04 19:09:36.9984 AlertProcessor ProcessorAlertData: started 2026-01-04 19:09:42.4515 AlertProcessor ProcessorAlertData: Stopped 2026-01-04 19:14:23.9536 DFramework.Database.Query /* Time Taken: 560*/ [dbo].GenerateSystemAlerts 2026-01-04 19:14:37.0162 AlertProcessor ProcessorAlertData: started 2026-01-04 19:14:39.0319 DFramework.Scheduler.TaskBase /* Time Taken: 15625.1234*/ Opportunity Out Of Stock By Outlet 2026-01-04 19:14:42.3288 AlertProcessor ProcessorAlertData: Stopped 2026-01-04 19:19:37.0341 AlertProcessor ProcessorAlertData: started 2026-01-04 19:19:42.3154 AlertProcessor ProcessorAlertData: Stopped 2026-01-04 19:24:37.0364 AlertProcessor ProcessorAlertData: started 2026-01-04 19:24:42.4583 AlertProcessor ProcessorAlertData: Stopped 2026-01-04 19:29:37.0386 AlertProcessor ProcessorAlertData: started 2026-01-04 19:29:38.9761 DFramework.Scheduler.TaskBase /* Time Taken: 15562.6164*/ Opportunity Out Of Stock By Outlet 2026-01-04 19:29:42.4293 AlertProcessor ProcessorAlertData: Stopped 2026-01-04 19:34:27.0877 MoveToReorder Running task for ClientId : 286 and ClientName = India Office QA and Slot: 1/5/2026 9:00:00 AM And LastExecutedOn: 1/5/2026 8:04:26 AM 2026-01-04 19:34:27.2908 MoveToReorder Task executed successfully for ClientId : 286 Client Name:India Office QA, Slot: 1/5/2026 9:00:00 AM But No Order found to suggest 2026-01-04 19:34:37.0565 AlertProcessor ProcessorAlertData: started 2026-01-04 19:34:42.3534 AlertProcessor ProcessorAlertData: Stopped 2026-01-04 19:39:37.0744 AlertProcessor ProcessorAlertData: started 2026-01-04 19:39:42.5745 AlertProcessor ProcessorAlertData: Stopped 2026-01-04 19:44:37.0923 AlertProcessor ProcessorAlertData: started 2026-01-04 19:44:38.9830 DFramework.Scheduler.TaskBase /* Time Taken: 15562.6166*/ Opportunity Out Of Stock By Outlet 2026-01-04 19:44:42.4830 AlertProcessor ProcessorAlertData: Stopped 2026-01-04 19:49:37.1103 AlertProcessor ProcessorAlertData: started 2026-01-04 19:49:42.4697 AlertProcessor ProcessorAlertData: Stopped 2026-01-04 19:54:37.1281 AlertProcessor ProcessorAlertData: started 2026-01-04 19:54:42.3938 AlertProcessor ProcessorAlertData: Stopped 2026-01-04 19:59:23.9272 DFramework.Database.Query /* Time Taken: 511*/ [dbo].GenerateSystemAlerts 2026-01-04 19:59:37.1460 AlertProcessor ProcessorAlertData: started 2026-01-04 19:59:39.0523 DFramework.Scheduler.TaskBase /* Time Taken: 15625.1247*/ Opportunity Out Of Stock By Outlet 2026-01-04 19:59:42.5992 AlertProcessor ProcessorAlertData: Stopped 2026-01-04 20:04:37.1639 AlertProcessor ProcessorAlertData: started 2026-01-04 20:04:42.6795 AlertProcessor ProcessorAlertData: Stopped 2026-01-04 20:09:37.1818 AlertProcessor ProcessorAlertData: started 2026-01-04 20:09:42.6037 AlertProcessor ProcessorAlertData: Stopped 2026-01-04 20:14:23.9652 DFramework.Database.Query /* Time Taken: 518*/ [dbo].GenerateSystemAlerts 2026-01-04 20:14:37.1996 AlertProcessor ProcessorAlertData: started 2026-01-04 20:14:39.0590 DFramework.Scheduler.TaskBase /* Time Taken: 15609.4893*/ Opportunity Out Of Stock By Outlet 2026-01-04 20:14:42.5747 AlertProcessor ProcessorAlertData: Stopped 2026-01-04 20:19:37.2175 AlertProcessor ProcessorAlertData: started 2026-01-04 20:19:42.7488 AlertProcessor ProcessorAlertData: Stopped 2026-01-04 20:24:37.2354 AlertProcessor ProcessorAlertData: started 2026-01-04 20:24:42.6729 AlertProcessor ProcessorAlertData: Stopped 2026-01-04 20:29:37.2377 AlertProcessor ProcessorAlertData: started 2026-01-04 20:29:39.0345 DFramework.Scheduler.TaskBase /* Time Taken: 15562.6209*/ Opportunity Out Of Stock By Outlet 2026-01-04 20:29:42.7377 AlertProcessor ProcessorAlertData: Stopped 2026-01-04 20:34:27.1617 MoveToReorder Running task for ClientId : 286 and ClientName = India Office QA and Slot: 1/5/2026 10:00:00 AM And LastExecutedOn: 1/5/2026 9:04:27 AM 2026-01-04 20:34:27.3648 MoveToReorder Task executed successfully for ClientId : 286 Client Name:India Office QA, Slot: 1/5/2026 10:00:00 AM But No Order found to suggest 2026-01-04 20:34:37.2399 AlertProcessor ProcessorAlertData: started 2026-01-04 20:34:37.8962 DFramework.Database.Query /* Time Taken: 589*/ DECLARE AlertTypeIds Object SET AlertTypeIds = 'DFramework.Database.Adapters.SQL+d__24' [dbo].GetAlertSummaryData 2026-01-04 20:34:40.3962 DFramework.Database.Query /* Time Taken: 2496*/ 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,296,301,303,305,328,335,70,134,188,227,295,320,336,338,395,337,360,385,421,469,471,1480,207,224,291,306,308,325,342,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 2026-01-04 20:34:42.8806 AlertProcessor ProcessorAlertData: Stopped 2026-01-04 20:39:37.2422 AlertProcessor ProcessorAlertData: started 2026-01-04 20:39:42.7891 AlertProcessor ProcessorAlertData: Stopped 2026-01-04 20:44:24.0100 DFramework.Database.Query /* Time Taken: 521*/ [dbo].GenerateSystemAlerts 2026-01-04 20:44:37.2601 AlertProcessor ProcessorAlertData: started 2026-01-04 20:44:39.1038 DFramework.Scheduler.TaskBase /* Time Taken: 15609.4971*/ Opportunity Out Of Stock By Outlet 2026-01-04 20:44:42.6195 AlertProcessor ProcessorAlertData: Stopped 2026-01-04 20:49:37.2780 AlertProcessor ProcessorAlertData: started 2026-01-04 20:49:42.7468 AlertProcessor ProcessorAlertData: Stopped 2026-01-04 20:54:37.2959 AlertProcessor ProcessorAlertData: started 2026-01-04 20:54:42.7804 AlertProcessor ProcessorAlertData: Stopped 2026-01-04 20:59:24.0481 DFramework.Database.Query /* Time Taken: 542*/ [dbo].GenerateSystemAlerts 2026-01-04 20:59:37.3138 AlertProcessor ProcessorAlertData: started 2026-01-04 20:59:39.1576 DFramework.Scheduler.TaskBase /* Time Taken: 15640.7435*/ Opportunity Out Of Stock By Outlet 2026-01-04 20:59:42.7670 AlertProcessor ProcessorAlertData: Stopped 2026-01-04 21:04:37.3318 AlertProcessor ProcessorAlertData: started 2026-01-04 21:04:42.7849 AlertProcessor ProcessorAlertData: Stopped 2026-01-04 21:09:37.3497 AlertProcessor ProcessorAlertData: started 2026-01-04 21:09:42.8497 AlertProcessor ProcessorAlertData: Stopped 2026-01-04 21:14:24.0394 DFramework.Database.Query /* Time Taken: 507*/ [dbo].GenerateSystemAlerts 2026-01-04 21:14:37.3520 AlertProcessor ProcessorAlertData: started 2026-01-04 21:14:39.1176 DFramework.Scheduler.TaskBase /* Time Taken: 15578.2412*/ Opportunity Out Of Stock By Outlet 2026-01-04 21:14:42.8208 AlertProcessor ProcessorAlertData: Stopped 2026-01-04 21:19:37.3699 AlertProcessor ProcessorAlertData: started 2026-01-04 21:19:42.8699 AlertProcessor ProcessorAlertData: Stopped 2026-01-04 21:24:37.3878 AlertProcessor ProcessorAlertData: started 2026-01-04 21:24:42.7941 AlertProcessor ProcessorAlertData: Stopped 2026-01-04 21:29:24.0775 DFramework.Database.Query /* Time Taken: 526*/ [dbo].GenerateSystemAlerts 2026-01-04 21:29:37.4057 AlertProcessor ProcessorAlertData: started 2026-01-04 21:29:39.1713 DFramework.Scheduler.TaskBase /* Time Taken: 15609.493*/ Opportunity Out Of Stock By Outlet 2026-01-04 21:29:42.8745 AlertProcessor ProcessorAlertData: Stopped 2026-01-04 21:34:27.2516 MoveToReorder Running task for ClientId : 286 and ClientName = India Office QA and Slot: 1/5/2026 11:00:00 AM And LastExecutedOn: 1/5/2026 10:04:27 AM 2026-01-04 21:34:37.4236 AlertProcessor ProcessorAlertData: started 2026-01-04 21:34:42.9236 AlertProcessor ProcessorAlertData: Stopped 2026-01-04 21:35:06.1738 DFramework.Database.NullableDataReader Data reader open for 38677 at System.Environment.GetStackTrace(Exception e, Boolean needFileInfo) at System.Environment.get_StackTrace() at DFramework.Database.NullableDataReader.Dispose(Boolean disposing) in D:\Spraxa\Framework\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() 2026-01-04 21:35:06.2050 MoveToReorder Task executed successfully for ClientId : 286 Client Name:India Office QA, Slot: 1/5/2026 11:00:00 AM and Total Order Suggested: 127 Out Of: 127 2026-01-04 21:35:07.0332 DFramework.Scheduler.TaskBase /* Time Taken: 40094.0269*/ Move To Re-Order 2026-01-04 21:39:37.4413 AlertProcessor ProcessorAlertData: started 2026-01-04 21:39:42.9101 AlertProcessor ProcessorAlertData: Stopped 2026-01-04 21:44:24.0841 DFramework.Database.Query /* Time Taken: 519*/ [dbo].GenerateSystemAlerts 2026-01-04 21:44:37.4592 AlertProcessor ProcessorAlertData: started 2026-01-04 21:44:39.1780 DFramework.Scheduler.TaskBase /* Time Taken: 15609.4982*/ Opportunity Out Of Stock By Outlet 2026-01-04 21:44:42.9124 AlertProcessor ProcessorAlertData: Stopped 2026-01-04 21:49:37.4771 AlertProcessor ProcessorAlertData: started 2026-01-04 21:49:38.0240 DFramework.Database.NullableDataReader Data reader open for 226 at System.Environment.GetStackTrace(Exception e, Boolean needFileInfo) at System.Environment.get_StackTrace() at DFramework.Database.NullableDataReader.Dispose(Boolean disposing) in D:\Spraxa\Framework\DFramework\Database\NullableDataReader.cs:line 33 at DFramework.Database.NullableDataReader.Dispose() in D:\Spraxa\Framework\DFramework\Database\NullableDataReader.cs:line 44 at CoolR.Tasks.ProcessAlertData.Execute() in D:\Spraxa\CoolR-Group\portal\CoolR.Tasks\ProcessAlertData.cs:line 47 at DFramework.Scheduler.TaskBase.Run() in D:\Spraxa\Framework\DFramework.Scheduler\TaskBase.cs:line 176 at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx) at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx) at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state) at System.Threading.ThreadHelper.ThreadStart() 2026-01-04 21:49:38.6959 DFramework.Database.NullableDataReader Data reader open for 372 at System.Environment.GetStackTrace(Exception e, Boolean needFileInfo) at System.Environment.get_StackTrace() at DFramework.Database.NullableDataReader.Dispose(Boolean disposing) in D:\Spraxa\Framework\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() 2026-01-04 21:49:38.7427 DFramework.Database.NullableDataReader Data reader open for 458 at System.Environment.GetStackTrace(Exception e, Boolean needFileInfo) at System.Environment.get_StackTrace() at DFramework.Database.NullableDataReader.Dispose(Boolean disposing) in D:\Spraxa\Framework\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() 2026-01-04 21:49:40.4302 DFramework.Database.NullableDataReader Data reader open for 211 at System.Environment.GetStackTrace(Exception e, Boolean needFileInfo) at System.Environment.get_StackTrace() at DFramework.Database.NullableDataReader.Dispose(Boolean disposing) in D:\Spraxa\Framework\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() 2026-01-04 21:49:40.4927 DFramework.Database.NullableDataReader Data reader open for 296 at System.Environment.GetStackTrace(Exception e, Boolean needFileInfo) at System.Environment.get_StackTrace() at DFramework.Database.NullableDataReader.Dispose(Boolean disposing) in D:\Spraxa\Framework\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() 2026-01-04 21:49:42.3209 DFramework.Database.NullableDataReader Data reader open for 226 at System.Environment.GetStackTrace(Exception e, Boolean needFileInfo) at System.Environment.get_StackTrace() at DFramework.Database.NullableDataReader.Dispose(Boolean disposing) in D:\Spraxa\Framework\DFramework\Database\NullableDataReader.cs:line 33 at DFramework.Database.NullableDataReader.Dispose() in D:\Spraxa\Framework\DFramework\Database\NullableDataReader.cs:line 44 at CoolR.Tasks.ProcessAlertData.Execute() in D:\Spraxa\CoolR-Group\portal\CoolR.Tasks\ProcessAlertData.cs:line 47 at DFramework.Scheduler.TaskBase.Run() in D:\Spraxa\Framework\DFramework.Scheduler\TaskBase.cs:line 176 at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx) at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx) at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state) at System.Threading.ThreadHelper.ThreadStart() 2026-01-04 21:49:42.3834 DFramework.Database.NullableDataReader Data reader open for 310 at System.Environment.GetStackTrace(Exception e, Boolean needFileInfo) at System.Environment.get_StackTrace() at DFramework.Database.NullableDataReader.Dispose(Boolean disposing) in D:\Spraxa\Framework\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() 2026-01-04 21:49:42.7115 AlertProcessor Replace Tags updated for the Image Id: 3675538 2026-01-04 21:49:42.8521 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() 2026-01-04 21:49:42.9146 DFramework.Database.NullableDataReader Data reader open for 293 at System.Environment.GetStackTrace(Exception e, Boolean needFileInfo) at System.Environment.get_StackTrace() at DFramework.Database.NullableDataReader.Dispose(Boolean disposing) in D:\Spraxa\Framework\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() 2026-01-04 21:49:44.1803 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() 2026-01-04 21:49:45.6178 AlertProcessor ProcessorAlertData: Stopped 2026-01-04 21:54:37.4795 AlertProcessor ProcessorAlertData: started 2026-01-04 21:54:42.9483 AlertProcessor ProcessorAlertData: Stopped 2026-01-04 21:59:37.4975 AlertProcessor ProcessorAlertData: started 2026-01-04 21:59:38.0288 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() 2026-01-04 21:59:38.6851 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.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() 2026-01-04 21:59:38.7475 DFramework.Database.NullableDataReader Data reader open for 406 at System.Environment.GetStackTrace(Exception e, Boolean needFileInfo) at System.Environment.get_StackTrace() at DFramework.Database.NullableDataReader.Dispose(Boolean disposing) in D:\Spraxa\Framework\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() 2026-01-04 21:59:39.1538 DFramework.Scheduler.TaskBase /* Time Taken: 15562.6132*/ Opportunity Out Of Stock By Outlet 2026-01-04 21:59:40.3882 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() 2026-01-04 21:59:42.2320 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() 2026-01-04 21:59:42.2788 DFramework.Database.NullableDataReader Data reader open for 305 at System.Environment.GetStackTrace(Exception e, Boolean needFileInfo) at System.Environment.get_StackTrace() at DFramework.Database.NullableDataReader.Dispose(Boolean disposing) in D:\Spraxa\Framework\DFramework\Database\NullableDataReader.cs:line 33 at DFramework.Database.NullableDataReader.Dispose() in D:\Spraxa\Framework\DFramework\Database\NullableDataReader.cs:line 44 at CoolR.Tasks.ProcessAlertData.Execute() in D:\Spraxa\CoolR-Group\portal\CoolR.Tasks\ProcessAlertData.cs:line 47 at DFramework.Scheduler.TaskBase.Run() in D:\Spraxa\Framework\DFramework.Scheduler\TaskBase.cs:line 176 at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx) at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx) at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state) at System.Threading.ThreadHelper.ThreadStart() 2026-01-04 21:59:42.6070 AlertProcessor Replace Tags updated for the Image Id: 3675541 2026-01-04 21:59:42.8101 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() 2026-01-04 21:59:44.0601 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() 2026-01-04 21:59:45.4195 AlertProcessor ProcessorAlertData: Stopped 2026-01-04 22:04:37.5155 AlertProcessor ProcessorAlertData: started 2026-01-04 22:04:42.9999 AlertProcessor ProcessorAlertData: Stopped 2026-01-04 22:09:37.5334 AlertProcessor ProcessorAlertData: started 2026-01-04 22:09:42.9709 AlertProcessor ProcessorAlertData: Stopped 2026-01-04 22:14:24.1449 DFramework.Database.Query /* Time Taken: 537*/ [dbo].GenerateSystemAlerts 2026-01-04 22:14:37.5513 AlertProcessor ProcessorAlertData: started 2026-01-04 22:14:39.2075 DFramework.Scheduler.TaskBase /* Time Taken: 15593.8779*/ Opportunity Out Of Stock By Outlet 2026-01-04 22:14:42.8638 AlertProcessor ProcessorAlertData: Stopped 2026-01-04 22:19:37.5692 AlertProcessor ProcessorAlertData: started 2026-01-04 22:19:42.9598 AlertProcessor ProcessorAlertData: Stopped 2026-01-04 22:24:15.9150 DFramework.Database.Query /* Time Taken: 556*/ DECLARE @IsFileProcessed Int32 SET @IsFileProcessed = '0' DECLARE @TaskNumber Int32 SET @TaskNumber = '3' DECLARE @IsDeleted Int32 SET @IsDeleted = '0' SELECT TOP 1000 IncomingFileId, GatewayId,GatewayMac,RawFileName,AzureContainerName,StartIndex,Tries, CreatedOn FROM IncomingFile WHERE [IsFileProcessed] = @IsFileProcessed AND [TaskNumber] = @TaskNumber AND [IsDeleted] = @IsDeleted 2026-01-04 22:24:15.9306 DFramework.Database.Query /* Time Taken: 569*/ DECLARE @IsFileProcessed Int32 SET @IsFileProcessed = '0' DECLARE @TaskNumber Int32 SET @TaskNumber = '4' DECLARE @IsDeleted Int32 SET @IsDeleted = '0' SELECT TOP 1000 IncomingFileId, GatewayId,GatewayMac,RawFileName,AzureContainerName,StartIndex,Tries, CreatedOn FROM IncomingFile WHERE [IsFileProcessed] = @IsFileProcessed AND [TaskNumber] = @TaskNumber AND [IsDeleted] = @IsDeleted 2026-01-04 22:24:16.0713 DFramework.Database.Query /* Time Taken: 713*/ DECLARE @IsFileProcessed Int32 SET @IsFileProcessed = '0' DECLARE @TaskNumber Int32 SET @TaskNumber = '2' DECLARE @IsDeleted Int32 SET @IsDeleted = '0' SELECT TOP 1000 IncomingFileId, GatewayId,GatewayMac,RawFileName,AzureContainerName,StartIndex,Tries, CreatedOn FROM IncomingFile WHERE [IsFileProcessed] = @IsFileProcessed AND [TaskNumber] = @TaskNumber AND [IsDeleted] = @IsDeleted 2026-01-04 22:24:28.2120 DFramework.Database.Query /* Time Taken: 1192*/ 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 2026-01-04 22:24:37.5871 AlertProcessor ProcessorAlertData: started 2026-01-04 22:24:38.1027 DFramework.Database.Query /* Time Taken: 519*/ DECLARE @TableName AnsiString(8000) SET @TableName = 'TagAlert' DECLARE @CurrentRecordId Int32 SET @CurrentRecordId = '0' dbo.GetValidDeviceForAlertProcessData 2026-01-04 22:24:38.6652 DFramework.Database.Query /* Time Taken: 503*/ DECLARE @TableName AnsiString(8000) SET @TableName = 'VoidAlert' DECLARE @CurrentRecordId Int32 SET @CurrentRecordId = '3675541' dbo.GetValidDeviceForAlertProcessData 2026-01-04 22:24:39.4308 DFramework.Database.Query /* Time Taken: 702*/ DECLARE @TableName AnsiString(8000) SET @TableName = 'MissingShelf' DECLARE @CurrentRecordId Int32 SET @CurrentRecordId = '3675541' dbo.GetValidDeviceForAlertProcessData 2026-01-04 22:24:40.1652 DFramework.Database.Query /* Time Taken: 676*/ DECLARE @TableName AnsiString(8000) SET @TableName = 'AdditionalShelf' DECLARE @CurrentRecordId Int32 SET @CurrentRecordId = '3675541' dbo.GetValidDeviceForAlertProcessData 2026-01-04 22:24:44.2434 AlertProcessor ProcessorAlertData: Stopped 2026-01-04 22:29:24.2923 DFramework.Database.Query /* Time Taken: 680*/ [dbo].GenerateSystemAlerts 2026-01-04 22:29:37.5893 AlertProcessor ProcessorAlertData: started 2026-01-04 22:29:39.3393 DFramework.Scheduler.TaskBase /* Time Taken: 15718.8652*/ Opportunity Out Of Stock By Outlet 2026-01-04 22:29:42.9488 AlertProcessor ProcessorAlertData: Stopped 2026-01-04 22:34:27.3571 MoveToReorder Running task for ClientId : 286 and ClientName = India Office QA and Slot: 1/5/2026 12:00:00 PM And LastExecutedOn: 1/5/2026 11:04:27 AM 2026-01-04 22:34:27.7009 MoveToReorder Task executed successfully for ClientId : 286 Client Name:India Office QA, Slot: 1/5/2026 12:00:00 PM But No Order found to suggest 2026-01-04 22:34:37.6072 AlertProcessor ProcessorAlertData: started 2026-01-04 22:34:42.9979 AlertProcessor ProcessorAlertData: Stopped 2026-01-04 22:38:48.5154 DFramework.Database.Query /* Time Taken: 15845*/ DECLARE @IsFileProcessed Int32 SET @IsFileProcessed = '0' DECLARE @TaskNumber Int32 SET @TaskNumber = '2' DECLARE @IsDeleted Int32 SET @IsDeleted = '0' SELECT TOP 1000 IncomingFileId, GatewayId,GatewayMac,RawFileName,AzureContainerName,StartIndex,Tries, CreatedOn FROM IncomingFile WHERE [IsFileProcessed] = @IsFileProcessed AND [TaskNumber] = @TaskNumber AND [IsDeleted] = @IsDeleted 2026-01-04 22:38:48.5154 DFramework.Scheduler.TaskBase /* Time Taken: 15843.8702*/ ProcessSQLUnprocessedFiles 2026-01-04 22:38:48.5154 DFramework.Database.Query /* Time Taken: 15846*/ DECLARE @IsFileProcessed Int32 SET @IsFileProcessed = '0' DECLARE @TaskNumber Int32 SET @TaskNumber = '3' DECLARE @IsDeleted Int32 SET @IsDeleted = '0' SELECT TOP 1000 IncomingFileId, GatewayId,GatewayMac,RawFileName,AzureContainerName,StartIndex,Tries, CreatedOn FROM IncomingFile WHERE [IsFileProcessed] = @IsFileProcessed AND [TaskNumber] = @TaskNumber AND [IsDeleted] = @IsDeleted 2026-01-04 22:38:48.5154 DFramework.Scheduler.TaskBase /* Time Taken: 15843.8702*/ ProcessSQLUnprocessedFiles 2026-01-04 22:38:48.5154 DFramework.Database.Query /* Time Taken: 15846*/ DECLARE @IsFileProcessed Int32 SET @IsFileProcessed = '0' DECLARE @TaskNumber Int32 SET @TaskNumber = '0' DECLARE @IsDeleted Int32 SET @IsDeleted = '0' SELECT TOP 1000 IncomingFileId, GatewayId,GatewayMac,RawFileName,AzureContainerName,StartIndex,Tries, CreatedOn FROM IncomingFile WHERE [IsFileProcessed] = @IsFileProcessed AND [TaskNumber] = @TaskNumber AND [IsDeleted] = @IsDeleted 2026-01-04 22:38:48.5154 DFramework.Scheduler.TaskBase /* Time Taken: 15843.8702*/ ProcessSQLUnprocessedFiles 2026-01-04 22:38:48.5310 DFramework.Database.Query /* Time Taken: 15857*/ DECLARE @IsFileProcessed Int32 SET @IsFileProcessed = '0' DECLARE @TaskNumber Int32 SET @TaskNumber = '1' DECLARE @IsDeleted Int32 SET @IsDeleted = '0' SELECT TOP 1000 IncomingFileId, GatewayId,GatewayMac,RawFileName,AzureContainerName,StartIndex,Tries, CreatedOn FROM IncomingFile WHERE [IsFileProcessed] = @IsFileProcessed AND [TaskNumber] = @TaskNumber AND [IsDeleted] = @IsDeleted 2026-01-04 22:38:48.5310 DFramework.Scheduler.TaskBase /* Time Taken: 15859.4918*/ ProcessSQLUnprocessedFiles 2026-01-04 22:38:48.5310 DFramework.Database.Query /* Time Taken: 15867*/ DECLARE @IsFileProcessed Int32 SET @IsFileProcessed = '0' DECLARE @TaskNumber Int32 SET @TaskNumber = '4' DECLARE @IsDeleted Int32 SET @IsDeleted = '0' SELECT TOP 1000 IncomingFileId, GatewayId,GatewayMac,RawFileName,AzureContainerName,StartIndex,Tries, CreatedOn FROM IncomingFile WHERE [IsFileProcessed] = @IsFileProcessed AND [TaskNumber] = @TaskNumber AND [IsDeleted] = @IsDeleted 2026-01-04 22:38:48.5310 DFramework.Scheduler.TaskBase /* Time Taken: 15859.4918*/ ProcessSQLUnprocessedFiles 2026-01-04 22:39:37.6251 AlertProcessor ProcessorAlertData: started 2026-01-04 22:39:38.1408 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 2026-01-04 22:39:43.2658 AlertProcessor ProcessorAlertData: Stopped 2026-01-04 22:44:24.1741 DFramework.Database.Query /* Time Taken: 544*/ [dbo].GenerateSystemAlerts 2026-01-04 22:44:37.6430 AlertProcessor ProcessorAlertData: started 2026-01-04 22:44:39.2367 DFramework.Scheduler.TaskBase /* Time Taken: 15593.8582*/ Opportunity Out Of Stock By Outlet 2026-01-04 22:44:42.9867 AlertProcessor ProcessorAlertData: Stopped 2026-01-04 22:49:37.6608 AlertProcessor ProcessorAlertData: started 2026-01-04 22:49:43.0202 AlertProcessor ProcessorAlertData: Stopped 2026-01-04 22:54:37.6786 AlertProcessor ProcessorAlertData: started 2026-01-04 22:54:43.1631 AlertProcessor ProcessorAlertData: Stopped 2026-01-04 22:59:24.1652 DFramework.Database.Query /* Time Taken: 502*/ [dbo].GenerateSystemAlerts 2026-01-04 22:59:37.6809 AlertProcessor ProcessorAlertData: started 2026-01-04 22:59:39.2278 DFramework.Scheduler.TaskBase /* Time Taken: 15562.618*/ Opportunity Out Of Stock By Outlet 2026-01-04 22:59:43.1184 AlertProcessor ProcessorAlertData: Stopped 2026-01-04 23:04:37.6832 AlertProcessor ProcessorAlertData: started 2026-01-04 23:04:43.1989 AlertProcessor ProcessorAlertData: Stopped 2026-01-04 23:09:37.7012 AlertProcessor ProcessorAlertData: started 2026-01-04 23:09:43.1543 AlertProcessor ProcessorAlertData: Stopped 2026-01-04 23:14:24.2814 DFramework.Database.Query /* Time Taken: 593*/ [dbo].GenerateSystemAlerts 2026-01-04 23:14:37.7191 AlertProcessor ProcessorAlertData: started 2026-01-04 23:14:39.2347 DFramework.Database.Query /* Time Taken: 501*/ DECLARE @TableName AnsiString(8000) SET @TableName = 'MissingShelf' DECLARE @CurrentRecordId Int32 SET @CurrentRecordId = '3675541' dbo.GetValidDeviceForAlertProcessData 2026-01-04 23:14:39.2659 DFramework.Scheduler.TaskBase /* Time Taken: 15578.243*/ Opportunity Out Of Stock By Outlet 2026-01-04 23:14:43.6253 AlertProcessor ProcessorAlertData: Stopped 2026-01-04 23:19:37.7370 AlertProcessor ProcessorAlertData: started 2026-01-04 23:19:43.1276 AlertProcessor ProcessorAlertData: Stopped 2026-01-04 23:24:37.7549 AlertProcessor ProcessorAlertData: started 2026-01-04 23:24:40.6924 DFramework.Database.Query /* Time Taken: 513*/ DECLARE @TableName AnsiString(8000) SET @TableName = 'AssetStockProductWiseConsolidate' DECLARE @CurrentRecordId Int32 SET @CurrentRecordId = '3675541' dbo.GetValidDeviceForAlertProcessData 2026-01-04 23:24:43.1924 AlertProcessor ProcessorAlertData: Stopped 2026-01-04 23:29:37.7728 AlertProcessor ProcessorAlertData: started 2026-01-04 23:29:39.2884 DFramework.Scheduler.TaskBase /* Time Taken: 15578.2416*/ Opportunity Out Of Stock By Outlet 2026-01-04 23:29:43.1478 AlertProcessor ProcessorAlertData: Stopped 2026-01-04 23:34:27.6656 MoveToReorder Running task for ClientId : 286 and ClientName = India Office QA and Slot: 1/5/2026 1:00:00 PM And LastExecutedOn: 1/5/2026 12:04:27 PM 2026-01-04 23:34:29.4625 DFramework.Database.Query /* Time Taken: 1730*/ DECLARE @OrderStatusId Int32 SET @OrderStatusId = '0' DECLARE @ClientId Int32 SET @ClientId = '286' dbo.GetOrderDetailsByClientId 2026-01-04 23:34:29.4937 MoveToReorder Task executed successfully for ClientId : 286 Client Name:India Office QA, Slot: 1/5/2026 1:00:00 PM But No Order found to suggest 2026-01-04 23:34:37.7750 AlertProcessor ProcessorAlertData: started 2026-01-04 23:34:43.2751 DFramework.Database.Query /* Time Taken: 5501*/ DECLARE @TableName AnsiString(8000) SET @TableName = 'TagAlert' DECLARE @CurrentRecordId Int32 SET @CurrentRecordId = '0' dbo.GetValidDeviceForAlertProcessData 2026-01-04 23:34:47.7751 DFramework.Database.Query /* Time Taken: 4493*/ DECLARE @AlertDefinition_IsDeleted Int32 SET @AlertDefinition_IsDeleted = '0' DECLARE @AlertType_IsDeleted Int32 SET @AlertType_IsDeleted = '0' DECLARE @AlertDefinition_IsActive Int32 SET @AlertDefinition_IsActive = '1' DECLARE @AlertType_IsActive Int32 SET @AlertType_IsActive = '1' DECLARE @AssetId0 Int32 SET @AssetId0 = '0' DECLARE @AssetId1 Int32 SET @AssetId1 = '118446' DECLARE @AlertDefinition_ClientId0 Int32 SET @AlertDefinition_ClientId0 = '0' DECLARE @AlertDefinition_ClientId1 Int32 SET @AlertDefinition_ClientId1 = '286' DECLARE @AssetModelId0 Int32 SET @AssetModelId0 = '0' DECLARE @AssetModelId1 Int32 SET @AssetModelId1 = '2450' DECLARE @MarketId0 Int32 SET @MarketId0 = '0' DECLARE @MarketId1 Int32 SET @MarketId1 = '0' DECLARE @ClassificationId0 Int32 SET @ClassificationId0 = '0' DECLARE @ClassificationId1 Int32 SET @ClassificationId1 = '128' DECLARE @LocationTypeId0 Int32 SET @LocationTypeId0 = '0' DECLARE @LocationTypeId1 Int32 SET @LocationTypeId1 = '434' DECLARE @LocationId0 Int32 SET @LocationId0 = '0' DECLARE @LocationId1 Int32 SET @LocationId1 = '434054' DECLARE @AlertDefinition_AlertTypeId Int32 SET @AlertDefinition_AlertTypeId = '48' SELECT AlertDefinitionId, AlertDefinition.AlertTypeId, Name, AlertBody, TemperatureAbove, TemperatureBelow, MinLight, MaxLight, PowerOffDuration,CombineThreshold, MovementDetected, DoorOpenDuration, DisconnectThreshold, AlertAgeThreshold, DoorOpeningLessThan, DoorOpeningGreaterThan, BatteryThreshold, LaneThreshold, ProductCount, StockThreshold, PurityThreshold, PlanogramThreshold, NoDataThreshold, BatteryCloseThreshold, GPSThreshold, StartDate, MovementCountThreshold, PriorityId, ColasThreshold, FlavoursThreshold, DataUsageThreshold, IsAlertForAllProduct, OnlyWithUPC, ManufacturerIds, LastImageThreshold, TargetPortfolioThreshold FROM AlertDefinition INNER JOIN AlertType ON AlertType.AlertTypeId = AlertDefinition.AlertTypeId WHERE AlertDefinition.IsDeleted = @AlertDefinition_IsDeleted AND AlertType.IsDeleted = @AlertType_IsDeleted AND AlertDefinition.IsActive = @AlertDefinition_IsActive AND AlertType.IsActive = @AlertType_IsActive AND AssetId IN ( @AssetId0, @AssetId1 ) AND AlertDefinition.ClientId IN ( @AlertDefinition_ClientId0, @AlertDefinition_ClientId1 ) AND AssetModelId IN ( @AssetModelId0, @AssetModelId1 ) AND MarketId IN ( @MarketId0, @MarketId1 ) AND ClassificationId IN ( @ClassificationId0, @ClassificationId1 ) AND LocationTypeId IN ( @LocationTypeId0, @LocationTypeId1 ) AND LocationId IN ( @LocationId0, @LocationId1 ) AND AlertDefinition.AlertTypeId = @AlertDefinition_AlertTypeId 2026-01-04 23:34:48.6657 DFramework.Database.Query /* Time Taken: 894*/ DECLARE @AlertDefinitionId Int32 SET @AlertDefinitionId = '71' DECLARE @AssetId Int32 SET @AssetId = '118446' DECLARE @IsDeleted Boolean SET @IsDeleted = 'False' SELECT TOP 1 AlertId, ClosedOn FROM dbo.Alert WHERE [AlertDefinitionId] = @AlertDefinitionId AND [AssetId] = @AssetId AND IsDeleted = @IsDeleted ORDER BY [AlertId] DESC 2026-01-04 23:34:49.7907 DFramework.Database.Query /* Time Taken: 12024*/ 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 2026-01-04 23:34:49.7907 DFramework.Scheduler.TaskBase /* Time Taken: 12015.7056*/ Email AlertNotification 2026-01-04 23:34:50.2907 DFramework.Database.Query /* Time Taken: 1197*/ DECLARE @StatusId Int32 SET @StatusId = '255' DECLARE @ClosedOn DateTime2 SET @ClosedOn = '1/5/2026 1:02:38 PM' DECLARE @LastUpdatedOn DateTime2 SET @LastUpdatedOn = '1/5/2026 1:02:38 PM' DECLARE @ModifiedOn DateTime2 SET @ModifiedOn = '1/5/2026 7:34:49 AM' DECLARE @AlertId Int32 SET @AlertId = '13775104' UPDATE dbo.[Alert] SET StatusId = @StatusId, ClosedOn = @ClosedOn, LastUpdatedOn = @LastUpdatedOn, ModifiedOn = @ModifiedOn WHERE [AlertId] = @AlertId 2026-01-04 23:34:50.2907 DFramework.Database.NullableDataReader Data reader open for 2521 at System.Environment.GetStackTrace(Exception e, Boolean needFileInfo) at System.Environment.get_StackTrace() at DFramework.Database.NullableDataReader.Dispose(Boolean disposing) in D:\Spraxa\Framework\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() 2026-01-04 23:34:50.3689 DFramework.Database.NullableDataReader Data reader open for 7083 at System.Environment.GetStackTrace(Exception e, Boolean needFileInfo) at System.Environment.get_StackTrace() at DFramework.Database.NullableDataReader.Dispose(Boolean disposing) in D:\Spraxa\Framework\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() 2026-01-04 23:34:51.2126 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() 2026-01-04 23:34:51.2907 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() 2026-01-04 23:34:51.9470 DFramework.Database.Query /* Time Taken: 655*/ DECLARE @TableName AnsiString(8000) SET @TableName = 'MissingShelf' DECLARE @CurrentRecordId Int32 SET @CurrentRecordId = '3675619' dbo.GetValidDeviceForAlertProcessData 2026-01-04 23:34:52.1657 DFramework.Database.NullableDataReader Data reader open for 219 at System.Environment.GetStackTrace(Exception e, Boolean needFileInfo) at System.Environment.get_StackTrace() at DFramework.Database.NullableDataReader.Dispose(Boolean disposing) in D:\Spraxa\Framework\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() 2026-01-04 23:34:52.7908 DFramework.Database.Query /* Time Taken: 620*/ DECLARE @TableName AnsiString(8000) SET @TableName = 'AdditionalShelf' DECLARE @CurrentRecordId Int32 SET @CurrentRecordId = '3675619' dbo.GetValidDeviceForAlertProcessData 2026-01-04 23:34:53.0564 DFramework.Database.NullableDataReader Data reader open for 262 at System.Environment.GetStackTrace(Exception e, Boolean needFileInfo) at System.Environment.get_StackTrace() at DFramework.Database.NullableDataReader.Dispose(Boolean disposing) in D:\Spraxa\Framework\DFramework\Database\NullableDataReader.cs:line 33 at DFramework.Database.NullableDataReader.Dispose() in D:\Spraxa\Framework\DFramework\Database\NullableDataReader.cs:line 44 at CoolR.Tasks.ProcessAlertData.Execute() in D:\Spraxa\CoolR-Group\portal\CoolR.Tasks\ProcessAlertData.cs:line 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() 2026-01-04 23:34:53.7126 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() 2026-01-04 23:34:53.7595 DFramework.Database.NullableDataReader Data reader open for 370 at System.Environment.GetStackTrace(Exception e, Boolean needFileInfo) at System.Environment.get_StackTrace() at DFramework.Database.NullableDataReader.Dispose(Boolean disposing) in D:\Spraxa\Framework\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() 2026-01-04 23:34:54.9470 DFramework.Database.NullableDataReader Data reader open for 823 at System.Environment.GetStackTrace(Exception e, Boolean needFileInfo) at System.Environment.get_StackTrace() at DFramework.Database.NullableDataReader.Dispose(Boolean disposing) in D:\Spraxa\Framework\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() 2026-01-04 23:34:55.0095 DFramework.Database.NullableDataReader Data reader open for 919 at System.Environment.GetStackTrace(Exception e, Boolean needFileInfo) at System.Environment.get_StackTrace() at DFramework.Database.NullableDataReader.Dispose(Boolean disposing) in D:\Spraxa\Framework\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() 2026-01-04 23:34:55.8689 DFramework.Database.NullableDataReader Data reader open for 568 at System.Environment.GetStackTrace(Exception e, Boolean needFileInfo) at System.Environment.get_StackTrace() at DFramework.Database.NullableDataReader.Dispose(Boolean disposing) in D:\Spraxa\Framework\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() 2026-01-04 23:34:55.9314 DFramework.Database.NullableDataReader Data reader open for 660 at System.Environment.GetStackTrace(Exception e, Boolean needFileInfo) at System.Environment.get_StackTrace() at DFramework.Database.NullableDataReader.Dispose(Boolean disposing) in D:\Spraxa\Framework\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() 2026-01-04 23:34:57.0252 DFramework.Database.NullableDataReader Data reader open for 258 at System.Environment.GetStackTrace(Exception e, Boolean needFileInfo) at System.Environment.get_StackTrace() at DFramework.Database.NullableDataReader.Dispose(Boolean disposing) in D:\Spraxa\Framework\DFramework\Database\NullableDataReader.cs:line 33 at DFramework.Database.NullableDataReader.Dispose() in D:\Spraxa\Framework\DFramework\Database\NullableDataReader.cs:line 44 at CoolR.Tasks.ProcessAlertData.Execute() in D:\Spraxa\CoolR-Group\portal\CoolR.Tasks\ProcessAlertData.cs:line 47 at DFramework.Scheduler.TaskBase.Run() in D:\Spraxa\Framework\DFramework.Scheduler\TaskBase.cs:line 176 at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx) at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx) at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state) at System.Threading.ThreadHelper.ThreadStart() 2026-01-04 23:34:57.0877 DFramework.Database.NullableDataReader Data reader open for 352 at System.Environment.GetStackTrace(Exception e, Boolean needFileInfo) at System.Environment.get_StackTrace() at DFramework.Database.NullableDataReader.Dispose(Boolean disposing) in D:\Spraxa\Framework\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() 2026-01-04 23:34:57.4314 AlertProcessor Replace Tags updated for the Image Id: 3675619 2026-01-04 23:34:57.6033 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() 2026-01-04 23:34:57.6658 DFramework.Database.NullableDataReader Data reader open for 333 at System.Environment.GetStackTrace(Exception e, Boolean needFileInfo) at System.Environment.get_StackTrace() at DFramework.Database.NullableDataReader.Dispose(Boolean disposing) in D:\Spraxa\Framework\DFramework\Database\NullableDataReader.cs:line 33 at DFramework.Database.NullableDataReader.Dispose() in D:\Spraxa\Framework\DFramework\Database\NullableDataReader.cs:line 44 at CoolR.Tasks.ProcessAlertData.Execute() in D:\Spraxa\CoolR-Group\portal\CoolR.Tasks\ProcessAlertData.cs:line 47 at DFramework.Scheduler.TaskBase.Run() in D:\Spraxa\Framework\DFramework.Scheduler\TaskBase.cs:line 176 at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx) at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx) at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state) at System.Threading.ThreadHelper.ThreadStart() 2026-01-04 23:34:58.3064 DFramework.Database.NullableDataReader Data reader open for 362 at System.Environment.GetStackTrace(Exception e, Boolean needFileInfo) at System.Environment.get_StackTrace() at DFramework.Database.NullableDataReader.Dispose(Boolean disposing) in D:\Spraxa\Framework\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() 2026-01-04 23:34:58.3533 DFramework.Database.NullableDataReader Data reader open for 449 at System.Environment.GetStackTrace(Exception e, Boolean needFileInfo) at System.Environment.get_StackTrace() at DFramework.Database.NullableDataReader.Dispose(Boolean disposing) in D:\Spraxa\Framework\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() 2026-01-04 23:34:59.2595 DFramework.Database.NullableDataReader Data reader open for 201 at System.Environment.GetStackTrace(Exception e, Boolean needFileInfo) at System.Environment.get_StackTrace() at DFramework.Database.NullableDataReader.Dispose(Boolean disposing) in D:\Spraxa\Framework\DFramework\Database\NullableDataReader.cs:line 33 at DFramework.Database.NullableDataReader.Dispose() in D:\Spraxa\Framework\DFramework\Database\NullableDataReader.cs:line 44 at CoolR.Tasks.ProcessAlertData.Execute() in D:\Spraxa\CoolR-Group\portal\CoolR.Tasks\ProcessAlertData.cs:line 47 at DFramework.Scheduler.TaskBase.Run() in D:\Spraxa\Framework\DFramework.Scheduler\TaskBase.cs:line 176 at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx) at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx) at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state) at System.Threading.ThreadHelper.ThreadStart() 2026-01-04 23:34:59.3377 DFramework.Database.NullableDataReader Data reader open for 300 at System.Environment.GetStackTrace(Exception e, Boolean needFileInfo) at System.Environment.get_StackTrace() at DFramework.Database.NullableDataReader.Dispose(Boolean disposing) in D:\Spraxa\Framework\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() 2026-01-04 23:35:00.3221 DFramework.Database.NullableDataReader Data reader open for 256 at System.Environment.GetStackTrace(Exception e, Boolean needFileInfo) at System.Environment.get_StackTrace() at DFramework.Database.NullableDataReader.Dispose(Boolean disposing) in D:\Spraxa\Framework\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() 2026-01-04 23:35:00.3846 DFramework.Database.NullableDataReader Data reader open for 347 at System.Environment.GetStackTrace(Exception e, Boolean needFileInfo) at System.Environment.get_StackTrace() at DFramework.Database.NullableDataReader.Dispose(Boolean disposing) in D:\Spraxa\Framework\DFramework\Database\NullableDataReader.cs:line 33 at DFramework.Database.NullableDataReader.Dispose() in D:\Spraxa\Framework\DFramework\Database\NullableDataReader.cs:line 44 at CoolR.Tasks.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() 2026-01-04 23:35:01.5721 DFramework.Database.Query /* Time Taken: 557*/ DECLARE @ParentAssetId Int32 SET @ParentAssetId = '118446' SELECT APPF.ProductId, APPF.AssetPurityId, APPF.PlanogramFacings, AssetPurity.PlanogramId, AssetPurity.TagStatus, AssetPurity.PurityDateTime FROM AssetPurity LEFT OUTER JOIN AssetPurityProductFacings APPF ON APPF.AssetPurityId = AssetPurity.AssetPurityId INNER JOIN AssetAttribute ON AssetAttribute.LatestProcessedPurityId = AssetPurity.AssetPurityId INNER JOIN Asset ON Asset.AssetId = AssetAttribute.AssetId LEFT OUTER JOIN Location ON Location.LocationId = AssetPurity.LocationId WHERE Asset.CalculatedParentAssetId = (SELECT TOP 1 CalculatedParentAssetId FROM Asset WHERE AssetId = @ParentAssetId) AND AssetPurity.IsDeleted = 0 2026-01-04 23:35:01.9314 DFramework.Database.NullableDataReader Data reader open for 1048 at System.Environment.GetStackTrace(Exception e, Boolean needFileInfo) at System.Environment.get_StackTrace() at DFramework.Database.NullableDataReader.Dispose(Boolean disposing) in D:\Spraxa\Framework\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() 2026-01-04 23:35:01.9940 DFramework.Database.NullableDataReader Data reader open for 1137 at System.Environment.GetStackTrace(Exception e, Boolean needFileInfo) at System.Environment.get_StackTrace() at DFramework.Database.NullableDataReader.Dispose(Boolean disposing) in D:\Spraxa\Framework\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() 2026-01-04 23:35:02.0252 AlertProcessor ProcessorAlertData: Stopped 2026-01-04 23:35:02.0252 DFramework.Scheduler.TaskBase /* Time Taken: 24250.1626*/ Process Alert Record 2026-01-04 23:39:37.7772 AlertProcessor ProcessorAlertData: started 2026-01-04 23:39:43.1366 AlertProcessor ProcessorAlertData: Stopped 2026-01-04 23:44:24.3105 DFramework.Database.Query /* Time Taken: 581*/ [dbo].GenerateSystemAlerts 2026-01-04 23:44:28.8887 DFramework.Database.Query /* Time Taken: 573*/ DECLARE @IsFileProcessed Int32 SET @IsFileProcessed = '0' DECLARE @IsDeleted Boolean SET @IsDeleted = 'False' SELECT TOP 500 CSVDataId, TDLinx, BeforeAfterImage, ImageUrl, FileName FROM CSVData WHERE [IsFileProcessed] = @IsFileProcessed AND IsDeleted = @IsDeleted ORDER BY [CSVDataId] 2026-01-04 23:44:29.1387 DFramework.Database.Query /* Time Taken: 619*/ DECLARE @IsFileProcessed Int32 SET @IsFileProcessed = '0' DECLARE @TaskNumber Int32 SET @TaskNumber = '0' DECLARE @IsDeleted Int32 SET @IsDeleted = '0' SELECT TOP 1000 IncomingFileId, GatewayId,GatewayMac,RawFileName,AzureContainerName,StartIndex,Tries, CreatedOn FROM IncomingFile WHERE [IsFileProcessed] = @IsFileProcessed AND [TaskNumber] = @TaskNumber AND [IsDeleted] = @IsDeleted 2026-01-04 23:44:33.1075 DFramework.Database.Query /* Time Taken: 5961*/ 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 2026-01-04 23:44:37.7950 AlertProcessor ProcessorAlertData: started 2026-01-04 23:44:40.1075 DFramework.Database.Query /* Time Taken: 1237*/ DECLARE @TableName AnsiString(8000) SET @TableName = 'MissingShelf' DECLARE @CurrentRecordId Int32 SET @CurrentRecordId = '3675619' dbo.GetValidDeviceForAlertProcessData 2026-01-04 23:44:41.3732 DFramework.Database.Query /* Time Taken: 1108*/ DECLARE @TableName AnsiString(8000) SET @TableName = 'AdditionalShelf' DECLARE @CurrentRecordId Int32 SET @CurrentRecordId = '3675619' dbo.GetValidDeviceForAlertProcessData 2026-01-04 23:44:42.4201 DFramework.Database.Query /* Time Taken: 9305*/ 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 2026-01-04 23:44:42.4982 DFramework.Database.Query /* Time Taken: 13366*/ DECLARE @ClientId Int32 SET @ClientId = '286' DECLARE @MarketId Int32 SET @MarketId = '0' DECLARE @ClassificationId Int32 SET @ClassificationId = '0' DECLARE @LocationId Int32 SET @LocationId = '0' DECLARE @LocationTypeId Int32 SET @LocationTypeId = '0' DECLARE @StartDate DateTime2 SET @StartDate = '11/1/2025 12:00:00 AM' dbo.GetOpportunityOutOfStockDataByOutlet 2026-01-04 23:44:42.9044 DFramework.Database.Query /* Time Taken: 607*/ DECLARE @TableName AnsiString(8000) SET @TableName = 'AssetStockProductWiseConsolidate' DECLARE @CurrentRecordId Int32 SET @CurrentRecordId = '3675619' dbo.GetValidDeviceForAlertProcessData 2026-01-04 23:44:43.3888 DFramework.Scheduler.TaskBase /* Time Taken: 16234.4952*/ Move To Re-Order 2026-01-04 23:44:45.6701 DFramework.Database.Query /* Time Taken: 506*/ DECLARE @TableName AnsiString(8000) SET @TableName = 'ProductStockLevel' DECLARE @CurrentRecordId Int32 SET @CurrentRecordId = '3675619' dbo.GetValidDeviceForAlertProcessData 2026-01-04 23:44:45.7326 AlertProcessor ProcessorAlertData: Stopped 2026-01-04 23:44:52.7483 DFramework.Scheduler.TaskBase /* Time Taken: 29015.8443*/ Opportunity Out Of Stock By Outlet 2026-01-04 23:49:37.8129 AlertProcessor ProcessorAlertData: started 2026-01-04 23:49:43.1723 AlertProcessor ProcessorAlertData: Stopped 2026-01-04 23:54:37.8241 AlertProcessor ProcessorAlertData: started 2026-01-04 23:54:40.4972 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() 2026-01-04 23:54:43.4191 AlertProcessor ProcessorAlertData: Stopped 2026-01-04 23:59:37.8325 AlertProcessor ProcessorAlertData: started 2026-01-04 23:59:39.3169 DFramework.Scheduler.TaskBase /* Time Taken: 15562.6148*/ Opportunity Out Of Stock By Outlet 2026-01-04 23:59:43.2857 AlertProcessor ProcessorAlertData: Stopped