2026-01-16 05:42:56.6613 AlertProcessor    ProcessorAlertData: started 
2026-01-16 05:42:57.2092 DFramework.Database.Query    /* Time Taken: 504*/
DECLARE @IsComplete Int32
SET @IsComplete = '0'
SELECT TOP 1 ProductMergeTempId, PrimaryProductId, SecondaryProductId, dbo.Product.ClientId, dbo.ProductMergeTemp.UserId, [Product] AS ProductName FROM dbo.ProductMergeTemp 
				INNER JOIN dbo.Product ON dbo.Product.ProductId = dbo.ProductMergeTemp.PrimaryProductId AND dbo.Product.ClientId = dbo.ProductMergeTemp.ClientId AND dbo.Product.IsDeleted = 0
 WHERE [IsComplete] = @IsComplete
 
2026-01-16 05:42:57.3501 DFramework.Database.Query    /* Time Taken: 663*/
DECLARE @OrderStatusId Int32
SET @OrderStatusId = '5486'
DECLARE @CurrentUtcDateTime DateTime2
SET @CurrentUtcDateTime = '1/16/2026 1:42:56 PM'
UPDATE Location SET ScheduledOrderId = 0, OrderStatusId = 0 FROM dbo.ScheduledOrder 
										INNER JOIN dbo.Location ON Location.ScheduledOrderId = ScheduledOrder.ScheduledOrderId AND Location.OrderStatusId = @OrderStatusId
										INNER JOIN dbo.Client On Client.ClientId = Location.ClientId
										WHERE ScheduledOrder.ModifiedOn < DATEADD(HOUR, -Client.HoursToMoveIgnored, @CurrentUtcDateTime) AND ScheduledOrder.StatusId = @OrderStatusId AND Client.HoursToMoveIgnored > 0
 
2026-01-16 05:42:57.3814 DFramework.Database.Query    /* Time Taken: 643*/
DECLARE @AlertDefinition_IsActive Int32
SET @AlertDefinition_IsActive = '1'
DECLARE @AlertDefinition_ClientId Int32
SET @AlertDefinition_ClientId = '213'
DECLARE @AlertDefinition_AlertTypeId Int32
SET @AlertDefinition_AlertTypeId = '67'
DECLARE @AlertDefinition_IsDeleted Int32
SET @AlertDefinition_IsDeleted = '0'
DECLARE @AlertDefinition_StartDate Date
SET @AlertDefinition_StartDate = '1/16/2026 1:42:56 PM'
SELECT TOP 1 AlertDefinitionId, PriorityId FROM AlertDefinition
 WHERE AlertDefinition.IsActive = @AlertDefinition_IsActive AND AlertDefinition.ClientId = @AlertDefinition_ClientId AND AlertDefinition.AlertTypeId = @AlertDefinition_AlertTypeId AND AlertDefinition.IsDeleted = @AlertDefinition_IsDeleted AND AlertDefinition.StartDate <= @AlertDefinition_StartDate
 
2026-01-16 05:42:57.4282 DFramework.Database.Query    /* Time Taken: 738*/
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 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-16 05:42:57.4595 DFramework.Database.Query    /* Time Taken: 738*/
DECLARE @IsActive Int32
SET @IsActive = '1'
DECLARE @FtpTypeId Int32
SET @FtpTypeId = '7766'
DECLARE @ClientId Int32
SET @ClientId = '213'
Select * from vwFTPClientList

 WHERE [IsActive] = @IsActive AND [FtpTypeId] = @FtpTypeId AND [ClientId] = @ClientId
 ORDER BY [ClientFtpId] 
2026-01-16 05:42:57.6314 DFramework.Database.Query    /* Time Taken: 962*/
DECLARE @Client_IsDeleted Int32
SET @Client_IsDeleted = '0'
DECLARE @AlertType_IsActive Int32
SET @AlertType_IsActive = '1'
DECLARE @AlertType_IsDeleted Int32
SET @AlertType_IsDeleted = '0'
DECLARE @AlertDefinition_IsActive Int32
SET @AlertDefinition_IsActive = '1'
DECLARE @AlertDefinition_IsDeleted Int32
SET @AlertDefinition_IsDeleted = '0'
DECLARE @AlertDefinition_StartDate Date
SET @AlertDefinition_StartDate = '1/16/2026 1:42:56 PM'
DECLARE @ClientTypeId0 Int32
SET @ClientTypeId0 = '5512'
DECLARE @ClientTypeId1 Int32
SET @ClientTypeId1 = '5515'
DECLARE @AlertDefinition_AlertTypeId Int32
SET @AlertDefinition_AlertTypeId = '75'
SELECT AlertDefinitionId, AlertDefinition.AlertTypeId, Name, AlertBody, AlertDefinition.ClientId, MarketId, ClassificationId, LocationTypeId, LocationId,
														StartDate, PriorityId, LastImageThreshold, ProductCount
														FROM dbo.AlertDefinition
														INNER JOIN dbo.AlertType ON dbo.AlertType.AlertTypeId = dbo.AlertDefinition.AlertTypeId
														INNER JOIN dbo.Client ON dbo.Client.ClientId = dbo.AlertDefinition.ClientId
 WHERE Client.IsDeleted = @Client_IsDeleted AND AlertType.IsActive = @AlertType_IsActive AND AlertType.IsDeleted = @AlertType_IsDeleted AND AlertDefinition.IsActive = @AlertDefinition_IsActive AND AlertDefinition.IsDeleted = @AlertDefinition_IsDeleted AND AlertDefinition.StartDate <= @AlertDefinition_StartDate AND dbo.Client.ClientTypeId IN ( @ClientTypeId0, @ClientTypeId1 ) AND AlertDefinition.AlertTypeId = @AlertDefinition_AlertTypeId
 
2026-01-16 05:42:57.8970 DFramework.Database.Query    /* Time Taken: 1165*/
DECLARE @CreatedOn Date
SET @CreatedOn = '1/16/2026 12:00:00 AM'
DECLARE @EventId Int32
SET @EventId = '-12'
SELECT COUNT(1) FROM EmailQueue
 WHERE [CreatedOn] >= @CreatedOn AND [EventId] = @EventId
 
2026-01-16 05:42:58.0064 DFramework.Database.Query    /* Time Taken: 735*/
DECLARE @AssetKPIData Object
SET @AssetKPIData = ''
[dbo].BulkUpsertAssetDayKPI 
2026-01-16 05:42:58.0689 DFramework.Database.Query    /* Time Taken: 716*/
DECLARE @OrderStatusId Int32
SET @OrderStatusId = '5484'
DECLARE @CurrentUtcDateTime DateTime2
SET @CurrentUtcDateTime = '1/16/2026 1:42:57 PM'
UPDATE Location SET ScheduledOrderId = 0, OrderStatusId = 0 FROM dbo.ScheduledOrder 
										INNER JOIN dbo.Location ON Location.ScheduledOrderId = ScheduledOrder.ScheduledOrderId AND Location.OrderStatusId = @OrderStatusId
										INNER JOIN dbo.Client On Client.ClientId = Location.ClientId
										WHERE ScheduledOrder.ModifiedOn < DATEADD(HOUR, -Client.HoursToMoveInTransit, @CurrentUtcDateTime) AND ScheduledOrder.StatusId = @OrderStatusId AND Client.HoursToMoveInTransit > 0
 
2026-01-16 05:42:58.1011 DFramework.Database.Query    /* Time Taken: 719*/
DECLARE @ClientId Int32
SET @ClientId = '213'
DECLARE @TaskName AnsiString(8000)
SET @TaskName = 'PhotoIngestionAlertTask'
SELECT TOP 1 Settings, TaskId, TaskName FROM dbo.Task
 WHERE [ClientId] = @ClientId AND [TaskName] = @TaskName
 ORDER BY [TaskId] DESC 
2026-01-16 05:42:58.2107 DFramework.Database.Query    /* Time Taken: 731*/
DECLARE @AppConfigId Int32
SET @AppConfigId = '1'
SELECT * FROM AppConfig

 WHERE [AppConfigId] = @AppConfigId
 ORDER BY [AppConfigId] 
2026-01-16 05:42:58.2512 DFramework.Database.Query    /* Time Taken: 603*/
DECLARE @AlertDefinitionId Int32
SET @AlertDefinitionId = '99'
DECLARE @IsDeleted Boolean
SET @IsDeleted = 'False'
SELECT ProductId FROM AlertDefinitionProduct
 WHERE [AlertDefinitionId] = @AlertDefinitionId AND IsDeleted = @IsDeleted
 
2026-01-16 05:42:58.2593 DFramework.Database.Query    /* Time Taken: 1013*/
DECLARE @SecondaryProductId Int32
SET @SecondaryProductId = '39415'
DECLARE @ClientId Int32
SET @ClientId = '286'
SELECT AssetPurityId, PurityStatus, TagStatus FROM AssetPurity WHERE AssetPurityId IN (SELECT DISTINCT TOP 100 AssetPurityId FROM AssetPurityProduct WHERE ProductId = @SecondaryProductId) AND ClientId = @ClientId
 
2026-01-16 05:42:58.2593 CoolR.Tasks.MergeProductsTask    AssetPurity related Tables are updated for primaryProductid: 24456 
2026-01-16 05:42:58.3390 DFramework.Database.Query    /* Time Taken: 1595*/
[dbo].GenerateSystemAlerts 
2026-01-16 05:42:58.3741 CoolR.Tasks.MergeProductsTask    Planogram updated with Primary ProductId: 24456, POG Counts: 0 
2026-01-16 05:42:58.3939 DFramework.Database.NullableDataReader    Data reader open for 724
   at System.Environment.GetStackTrace(Exception e, Boolean needFileInfo)
   at System.Environment.get_StackTrace()
   at DFramework.Database.NullableDataReader.Dispose(Boolean disposing) in C:\CoolR-Group\Framework\DFramework\Database\NullableDataReader.cs:line 33
   at DFramework.Database.NullableDataReader.Dispose() in C:\CoolR-Group\Framework\DFramework\Database\NullableDataReader.cs:line 44
   at CoolR.Tasks.ProcessOutletAlertData.GetAlertDefinitions() in C:\CoolR-Group\portal\CoolR.Tasks\OpportunityOutOfStockByOutlet.cs:line 490
   at CoolR.Tasks.ProcessOutletAlertData.Execute() in C:\CoolR-Group\portal\CoolR.Tasks\OpportunityOutOfStockByOutlet.cs:line 72
   at DFramework.Scheduler.TaskBase.Run() in E:\Forked\Framework\DFramework.Scheduler\TaskBase.cs:line 176
   at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)
   at System.Threading.ExecutionContext.Run(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-16 05:42:58.4065 DFramework.Database.Query    /* Time Taken: 1687*/
DECLARE @TableName AnsiString(8000)
SET @TableName = 'TagAlert'
DECLARE @CurrentRecordId Int32
SET @CurrentRecordId = '0'
dbo.GetValidDeviceForAlertProcessData 
2026-01-16 05:42:58.5925 DFramework.Database.Query    /* Time Taken: 526*/
DECLARE @AssetKPIData Object
SET @AssetKPIData = ''
[dbo].BulkUpsertAssetDayKPI 
2026-01-16 05:42:58.6295 CoolR.Tasks.MergeProductsTask    Other tables are updated for primaryProductid: 24456 
2026-01-16 05:42:58.6869 DFramework.Database.NullableDataReader    Data reader open for 250
   at System.Environment.GetStackTrace(Exception e, Boolean needFileInfo)
   at System.Environment.get_StackTrace()
   at DFramework.Database.NullableDataReader.Dispose(Boolean disposing) in C:\CoolR-Group\Framework\DFramework\Database\NullableDataReader.cs:line 33
   at DFramework.Database.NullableDataReader.Dispose() in C:\CoolR-Group\Framework\DFramework\Database\NullableDataReader.cs:line 44
   at CoolR.Tasks.ProcessAlertData.Execute() in C:\CoolR-Group\portal\CoolR.Tasks\ProcessAlertData.cs:line 47
   at DFramework.Scheduler.TaskBase.Run() in E:\Forked\Framework\DFramework.Scheduler\TaskBase.cs:line 176
   at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)
   at System.Threading.ExecutionContext.Run(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-16 05:42:58.7187 CoolR.Tasks.MergeProductsTask    MergeProduct SP executed with Primary ProductId: 24456 
2026-01-16 05:42:58.7812 CoolR.Tasks.MergeProductsTask    Secondary Product marked Deleted for Primary ProductId: 24456 
2026-01-16 05:42:58.7968 DFramework.Database.NullableDataReader    Data reader open for 393
   at System.Environment.GetStackTrace(Exception e, Boolean needFileInfo)
   at System.Environment.get_StackTrace()
   at DFramework.Database.NullableDataReader.Dispose(Boolean disposing) in C:\CoolR-Group\Framework\DFramework\Database\NullableDataReader.cs:line 33
   at DFramework.Database.NullableDataReader.Dispose() in C:\CoolR-Group\Framework\DFramework\Database\NullableDataReader.cs:line 44
   at CoolR.Tasks.ProcessAlertData.Execute() in C:\CoolR-Group\portal\CoolR.Tasks\ProcessAlertData.cs:line 47
   at DFramework.Scheduler.TaskBase.Run() in E:\Forked\Framework\DFramework.Scheduler\TaskBase.cs:line 176
   at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)
   at System.Threading.ExecutionContext.Run(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-16 05:42:59.3759 DFramework.Database.Query    /* Time Taken: 575*/
DECLARE @TableName AnsiString(8000)
SET @TableName = 'VoidAlert'
DECLARE @CurrentRecordId Int32
SET @CurrentRecordId = '3676248'
dbo.GetValidDeviceForAlertProcessData 
2026-01-16 05:42:59.7387 DFramework.Database.NullableDataReader    Data reader open for 337
   at System.Environment.GetStackTrace(Exception e, Boolean needFileInfo)
   at System.Environment.get_StackTrace()
   at DFramework.Database.NullableDataReader.Dispose(Boolean disposing) in C:\CoolR-Group\Framework\DFramework\Database\NullableDataReader.cs:line 33
   at DFramework.Database.NullableDataReader.Dispose() in C:\CoolR-Group\Framework\DFramework\Database\NullableDataReader.cs:line 44
   at CoolR.Tasks.ProcessAlertData.Execute() in C:\CoolR-Group\portal\CoolR.Tasks\ProcessAlertData.cs:line 47
   at DFramework.Scheduler.TaskBase.Run() in E:\Forked\Framework\DFramework.Scheduler\TaskBase.cs:line 176
   at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)
   at System.Threading.ExecutionContext.Run(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-16 05:42:59.8012 DFramework.Database.NullableDataReader    Data reader open for 430
   at System.Environment.GetStackTrace(Exception e, Boolean needFileInfo)
   at System.Environment.get_StackTrace()
   at DFramework.Database.NullableDataReader.Dispose(Boolean disposing) in C:\CoolR-Group\Framework\DFramework\Database\NullableDataReader.cs:line 33
   at DFramework.Database.NullableDataReader.Dispose() in C:\CoolR-Group\Framework\DFramework\Database\NullableDataReader.cs:line 44
   at CoolR.Tasks.ProcessAlertData.Execute() in C:\CoolR-Group\portal\CoolR.Tasks\ProcessAlertData.cs:line 47
   at DFramework.Scheduler.TaskBase.Run() in E:\Forked\Framework\DFramework.Scheduler\TaskBase.cs:line 176
   at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)
   at System.Threading.ExecutionContext.Run(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-16 05:43:00.3491 DFramework.Database.Query    /* Time Taken: 553*/
DECLARE @TableName AnsiString(8000)
SET @TableName = 'MissingShelf'
DECLARE @CurrentRecordId Int32
SET @CurrentRecordId = '3676248'
dbo.GetValidDeviceForAlertProcessData 
2026-01-16 05:43:00.8771 DFramework.Database.NullableDataReader    Data reader open for 515
   at System.Environment.GetStackTrace(Exception e, Boolean needFileInfo)
   at System.Environment.get_StackTrace()
   at DFramework.Database.NullableDataReader.Dispose(Boolean disposing) in C:\CoolR-Group\Framework\DFramework\Database\NullableDataReader.cs:line 33
   at DFramework.Database.NullableDataReader.Dispose() in C:\CoolR-Group\Framework\DFramework\Database\NullableDataReader.cs:line 44
   at CoolR.Tasks.ProcessAlertData.Execute() in C:\CoolR-Group\portal\CoolR.Tasks\ProcessAlertData.cs:line 47
   at DFramework.Scheduler.TaskBase.Run() in E:\Forked\Framework\DFramework.Scheduler\TaskBase.cs:line 176
   at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)
   at System.Threading.ExecutionContext.Run(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-16 05:43:01.5063 DFramework.Database.Query    /* Time Taken: 642*/
DECLARE @TableName AnsiString(8000)
SET @TableName = 'AdditionalShelf'
DECLARE @CurrentRecordId Int32
SET @CurrentRecordId = '3676248'
dbo.GetValidDeviceForAlertProcessData 
2026-01-16 05:43:02.0376 DFramework.Database.NullableDataReader    Data reader open for 521
   at System.Environment.GetStackTrace(Exception e, Boolean needFileInfo)
   at System.Environment.get_StackTrace()
   at DFramework.Database.NullableDataReader.Dispose(Boolean disposing) in C:\CoolR-Group\Framework\DFramework\Database\NullableDataReader.cs:line 33
   at DFramework.Database.NullableDataReader.Dispose() in C:\CoolR-Group\Framework\DFramework\Database\NullableDataReader.cs:line 44
   at CoolR.Tasks.ProcessAlertData.Execute() in C:\CoolR-Group\portal\CoolR.Tasks\ProcessAlertData.cs:line 47
   at DFramework.Scheduler.TaskBase.Run() in E:\Forked\Framework\DFramework.Scheduler\TaskBase.cs:line 176
   at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)
   at System.Threading.ExecutionContext.Run(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-16 05:43:02.6162 DFramework.Database.NullableDataReader    Data reader open for 209
   at System.Environment.GetStackTrace(Exception e, Boolean needFileInfo)
   at System.Environment.get_StackTrace()
   at DFramework.Database.NullableDataReader.Dispose(Boolean disposing) in C:\CoolR-Group\Framework\DFramework\Database\NullableDataReader.cs:line 33
   at DFramework.Database.NullableDataReader.Dispose() in C:\CoolR-Group\Framework\DFramework\Database\NullableDataReader.cs:line 44
   at CoolR.Tasks.ProcessAlertData.Execute() in C:\CoolR-Group\portal\CoolR.Tasks\ProcessAlertData.cs:line 47
   at DFramework.Scheduler.TaskBase.Run() in E:\Forked\Framework\DFramework.Scheduler\TaskBase.cs:line 176
   at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)
   at System.Threading.ExecutionContext.Run(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-16 05:43:02.7100 DFramework.Database.NullableDataReader    Data reader open for 332
   at System.Environment.GetStackTrace(Exception e, Boolean needFileInfo)
   at System.Environment.get_StackTrace()
   at DFramework.Database.NullableDataReader.Dispose(Boolean disposing) in C:\CoolR-Group\Framework\DFramework\Database\NullableDataReader.cs:line 33
   at DFramework.Database.NullableDataReader.Dispose() in C:\CoolR-Group\Framework\DFramework\Database\NullableDataReader.cs:line 44
   at CoolR.Tasks.ProcessAlertData.Execute() in C:\CoolR-Group\portal\CoolR.Tasks\ProcessAlertData.cs:line 47
   at DFramework.Scheduler.TaskBase.Run() in E:\Forked\Framework\DFramework.Scheduler\TaskBase.cs:line 176
   at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)
   at System.Threading.ExecutionContext.Run(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-16 05:43:03.3065 DFramework.Database.NullableDataReader    Data reader open for 239
   at System.Environment.GetStackTrace(Exception e, Boolean needFileInfo)
   at System.Environment.get_StackTrace()
   at DFramework.Database.NullableDataReader.Dispose(Boolean disposing) in C:\CoolR-Group\Framework\DFramework\Database\NullableDataReader.cs:line 33
   at DFramework.Database.NullableDataReader.Dispose() in C:\CoolR-Group\Framework\DFramework\Database\NullableDataReader.cs:line 44
   at CoolR.Tasks.ProcessAlertData.Execute() in C:\CoolR-Group\portal\CoolR.Tasks\ProcessAlertData.cs:line 47
   at DFramework.Scheduler.TaskBase.Run() in E:\Forked\Framework\DFramework.Scheduler\TaskBase.cs:line 176
   at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)
   at System.Threading.ExecutionContext.Run(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-16 05:43:03.4021 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 C:\CoolR-Group\Framework\DFramework\Database\NullableDataReader.cs:line 33
   at DFramework.Database.NullableDataReader.Dispose() in C:\CoolR-Group\Framework\DFramework\Database\NullableDataReader.cs:line 44
   at CoolR.Tasks.ProcessAlertData.Execute() in C:\CoolR-Group\portal\CoolR.Tasks\ProcessAlertData.cs:line 47
   at DFramework.Scheduler.TaskBase.Run() in E:\Forked\Framework\DFramework.Scheduler\TaskBase.cs:line 176
   at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)
   at System.Threading.ExecutionContext.Run(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-16 05:43:04.1216 DFramework.Database.NullableDataReader    Data reader open for 336
   at System.Environment.GetStackTrace(Exception e, Boolean needFileInfo)
   at System.Environment.get_StackTrace()
   at DFramework.Database.NullableDataReader.Dispose(Boolean disposing) in C:\CoolR-Group\Framework\DFramework\Database\NullableDataReader.cs:line 33
   at DFramework.Database.NullableDataReader.Dispose() in C:\CoolR-Group\Framework\DFramework\Database\NullableDataReader.cs:line 44
   at CoolR.Tasks.ProcessAlertData.Execute() in C:\CoolR-Group\portal\CoolR.Tasks\ProcessAlertData.cs:line 47
   at DFramework.Scheduler.TaskBase.Run() in E:\Forked\Framework\DFramework.Scheduler\TaskBase.cs:line 176
   at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)
   at System.Threading.ExecutionContext.Run(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-16 05:43:04.2081 DFramework.Database.NullableDataReader    Data reader open for 450
   at System.Environment.GetStackTrace(Exception e, Boolean needFileInfo)
   at System.Environment.get_StackTrace()
   at DFramework.Database.NullableDataReader.Dispose(Boolean disposing) in C:\CoolR-Group\Framework\DFramework\Database\NullableDataReader.cs:line 33
   at DFramework.Database.NullableDataReader.Dispose() in C:\CoolR-Group\Framework\DFramework\Database\NullableDataReader.cs:line 44
   at CoolR.Tasks.ProcessAlertData.Execute() in C:\CoolR-Group\portal\CoolR.Tasks\ProcessAlertData.cs:line 47
   at DFramework.Scheduler.TaskBase.Run() in E:\Forked\Framework\DFramework.Scheduler\TaskBase.cs:line 176
   at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)
   at System.Threading.ExecutionContext.Run(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-16 05:43:04.7788 DFramework.Database.Query    /* Time Taken: 579*/
DECLARE @TableName AnsiString(8000)
SET @TableName = 'AssetStockProductWiseConsolidate'
DECLARE @CurrentRecordId Int32
SET @CurrentRecordId = '3676248'
dbo.GetValidDeviceForAlertProcessData 
2026-01-16 05:43:13.9407 DFramework.Scheduler.TaskBase    /* Time Taken: 17295.0265*/
Opportunity Out Of Stock By Outlet 
2026-01-16 05:52:56.7555 CoolR.Tasks.MergeProductsTask    AssetPurity related Tables are updated for primaryProductid: 24456 
2026-01-16 05:52:56.8492 CoolR.Tasks.MergeProductsTask    Planogram updated with Primary ProductId: 24456, POG Counts: 0 
2026-01-16 05:52:57.0367 CoolR.Tasks.MergeProductsTask    Other tables are updated for primaryProductid: 24456 
2026-01-16 05:52:57.1461 CoolR.Tasks.MergeProductsTask    MergeProduct SP executed with Primary ProductId: 24456 
2026-01-16 05:52:57.2086 CoolR.Tasks.MergeProductsTask    Secondary Product marked Deleted for Primary ProductId: 24456 
2026-01-16 05:57:57.2427 DFramework.Database.Query    /* Time Taken: 511*/
[dbo].GenerateSystemAlerts 
2026-01-16 05:58:12.3943 DFramework.Scheduler.TaskBase    /* Time Taken: 15730.3603*/
Opportunity Out Of Stock By Outlet 
2026-01-16 06:02:56.7395 CoolR.Tasks.MergeProductsTask    AssetPurity related Tables are updated for primaryProductid: 24456 
2026-01-16 06:02:56.8645 CoolR.Tasks.MergeProductsTask    Planogram updated with Primary ProductId: 24456, POG Counts: 0 
2026-01-16 06:02:57.0677 CoolR.Tasks.MergeProductsTask    Other tables are updated for primaryProductid: 24456 
2026-01-16 06:02:57.1614 CoolR.Tasks.MergeProductsTask    MergeProduct SP executed with Primary ProductId: 24456 
2026-01-16 06:02:57.2335 CoolR.Tasks.MergeProductsTask    Secondary Product marked Deleted for Primary ProductId: 24456 
2026-01-16 06:12:57.1763 CoolR.Tasks.MergeProductsTask    AssetPurity related Tables are updated for primaryProductid: 24456 
2026-01-16 06:12:57.2075 DFramework.Database.NullableDataReader    Data reader open for 493
   at System.Environment.GetStackTrace(Exception e, Boolean needFileInfo)
   at System.Environment.get_StackTrace()
   at DFramework.Database.NullableDataReader.Dispose(Boolean disposing) in C:\CoolR-Group\Framework\DFramework\Database\NullableDataReader.cs:line 33
   at DFramework.Database.NullableDataReader.Dispose() in C:\CoolR-Group\Framework\DFramework\Database\NullableDataReader.cs:line 44
   at CoolR.Tasks.ProcessOutletAlertData.GetAlertDefinitions() in C:\CoolR-Group\portal\CoolR.Tasks\OpportunityOutOfStockByOutlet.cs:line 490
   at CoolR.Tasks.ProcessOutletAlertData.Execute() in C:\CoolR-Group\portal\CoolR.Tasks\OpportunityOutOfStockByOutlet.cs:line 72
   at DFramework.Scheduler.TaskBase.Run() in E:\Forked\Framework\DFramework.Scheduler\TaskBase.cs:line 176
   at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)
   at System.Threading.ExecutionContext.Run(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-16 06:12:57.2546 CoolR.Tasks.MergeProductsTask    Planogram updated with Primary ProductId: 24456, POG Counts: 0 
2026-01-16 06:12:57.4734 CoolR.Tasks.MergeProductsTask    Other tables are updated for primaryProductid: 24456 
2026-01-16 06:12:57.5359 DFramework.Database.Query    /* Time Taken: 788*/
[dbo].GenerateSystemAlerts 
2026-01-16 06:12:57.5671 CoolR.Tasks.MergeProductsTask    MergeProduct SP executed with Primary ProductId: 24456 
2026-01-16 06:12:57.6296 CoolR.Tasks.MergeProductsTask    Secondary Product marked Deleted for Primary ProductId: 24456 
2026-01-16 06:13:12.8079 DFramework.Scheduler.TaskBase    /* Time Taken: 16116.4889*/
Opportunity Out Of Stock By Outlet 
2026-01-16 06:22:56.7724 CoolR.Tasks.MergeProductsTask    AssetPurity related Tables are updated for primaryProductid: 24456 
2026-01-16 06:22:56.8349 CoolR.Tasks.MergeProductsTask    Planogram updated with Primary ProductId: 24456, POG Counts: 0 
2026-01-16 06:22:57.0700 CoolR.Tasks.MergeProductsTask    Other tables are updated for primaryProductid: 24456 
2026-01-16 06:22:57.1638 CoolR.Tasks.MergeProductsTask    MergeProduct SP executed with Primary ProductId: 24456 
2026-01-16 06:22:57.2107 CoolR.Tasks.MergeProductsTask    Secondary Product marked Deleted for Primary ProductId: 24456 
2026-01-16 06:27:57.1795 DFramework.Database.NullableDataReader    Data reader open for 450
   at System.Environment.GetStackTrace(Exception e, Boolean needFileInfo)
   at System.Environment.get_StackTrace()
   at DFramework.Database.NullableDataReader.Dispose(Boolean disposing) in C:\CoolR-Group\Framework\DFramework\Database\NullableDataReader.cs:line 33
   at DFramework.Database.NullableDataReader.Dispose() in C:\CoolR-Group\Framework\DFramework\Database\NullableDataReader.cs:line 44
   at CoolR.Tasks.ProcessOutletAlertData.GetAlertDefinitions() in C:\CoolR-Group\portal\CoolR.Tasks\OpportunityOutOfStockByOutlet.cs:line 490
   at CoolR.Tasks.ProcessOutletAlertData.Execute() in C:\CoolR-Group\portal\CoolR.Tasks\OpportunityOutOfStockByOutlet.cs:line 72
   at DFramework.Scheduler.TaskBase.Run() in E:\Forked\Framework\DFramework.Scheduler\TaskBase.cs:line 176
   at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)
   at System.Threading.ExecutionContext.Run(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-16 06:27:57.2890 DFramework.Database.Query    /* Time Taken: 516*/
[dbo].GenerateSystemAlerts 
2026-01-16 06:27:57.3046 DFramework.Database.Query    /* Time Taken: 533*/
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 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-16 06:28:12.6628 DFramework.Scheduler.TaskBase    /* Time Taken: 15952.0652*/
Opportunity Out Of Stock By Outlet 
2026-01-16 06:32:56.7799 CoolR.Tasks.MergeProductsTask    AssetPurity related Tables are updated for primaryProductid: 24456 
2026-01-16 06:32:56.8268 CoolR.Tasks.MergeProductsTask    Planogram updated with Primary ProductId: 24456, POG Counts: 0 
2026-01-16 06:32:57.0461 CoolR.Tasks.MergeProductsTask    Other tables are updated for primaryProductid: 24456 
2026-01-16 06:32:57.0930 MoveToReorder    Running task for ClientId : 286 and ClientName = India Office QA and Slot: 1/16/2026 8:00:00 PM And LastExecutedOn: 1/16/2026 7:05:45 PM 
2026-01-16 06:32:57.1555 CoolR.Tasks.MergeProductsTask    MergeProduct SP executed with Primary ProductId: 24456 
2026-01-16 06:32:57.2653 CoolR.Tasks.MergeProductsTask    Secondary Product marked Deleted for Primary ProductId: 24456 
2026-01-16 06:33:39.8458 DFramework.Database.NullableDataReader    Data reader open for 42296
   at System.Environment.GetStackTrace(Exception e, Boolean needFileInfo)
   at System.Environment.get_StackTrace()
   at DFramework.Database.NullableDataReader.Dispose(Boolean disposing) in C:\CoolR-Group\Framework\DFramework\Database\NullableDataReader.cs:line 33
   at DFramework.Database.NullableDataReader.Dispose() in C:\CoolR-Group\Framework\DFramework\Database\NullableDataReader.cs:line 44
   at CoolR.Tasks.MoveToReorder.Execute() in C:\CoolR-Group\portal\CoolR.Tasks\MoveToReorder.cs:line 44
   at DFramework.Scheduler.TaskBase.Run() in E:\Forked\Framework\DFramework.Scheduler\TaskBase.cs:line 176
   at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)
   at System.Threading.ExecutionContext.Run(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-16 06:33:39.8771 MoveToReorder    Task executed successfully for ClientId : 286 Client Name:India Office QA, Slot: 1/16/2026 8:00:00 PM and Total Order Suggested: 126 Out Of: 126 
2026-01-16 06:33:41.3934 DFramework.Scheduler.TaskBase    /* Time Taken: 44660.3359*/
Move To Re-Order 
2026-01-16 06:42:56.8421 CoolR.Tasks.MergeProductsTask    AssetPurity related Tables are updated for primaryProductid: 24456 
2026-01-16 06:42:57.0766 CoolR.Tasks.MergeProductsTask    Planogram updated with Primary ProductId: 24456, POG Counts: 0 
2026-01-16 06:42:57.2016 DFramework.Database.NullableDataReader    Data reader open for 448
   at System.Environment.GetStackTrace(Exception e, Boolean needFileInfo)
   at System.Environment.get_StackTrace()
   at DFramework.Database.NullableDataReader.Dispose(Boolean disposing) in C:\CoolR-Group\Framework\DFramework\Database\NullableDataReader.cs:line 33
   at DFramework.Database.NullableDataReader.Dispose() in C:\CoolR-Group\Framework\DFramework\Database\NullableDataReader.cs:line 44
   at CoolR.Tasks.ProcessOutletAlertData.GetAlertDefinitions() in C:\CoolR-Group\portal\CoolR.Tasks\OpportunityOutOfStockByOutlet.cs:line 490
   at CoolR.Tasks.ProcessOutletAlertData.Execute() in C:\CoolR-Group\portal\CoolR.Tasks\OpportunityOutOfStockByOutlet.cs:line 72
   at DFramework.Scheduler.TaskBase.Run() in E:\Forked\Framework\DFramework.Scheduler\TaskBase.cs:line 176
   at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)
   at System.Threading.ExecutionContext.Run(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-16 06:42:57.3109 DFramework.Database.Query    /* Time Taken: 501*/
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 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-16 06:42:57.3266 DFramework.Database.Query    /* Time Taken: 551*/
[dbo].GenerateSystemAlerts 
2026-01-16 06:42:57.3891 CoolR.Tasks.MergeProductsTask    Other tables are updated for primaryProductid: 24456 
2026-01-16 06:42:57.4984 CoolR.Tasks.MergeProductsTask    MergeProduct SP executed with Primary ProductId: 24456 
2026-01-16 06:42:57.5609 CoolR.Tasks.MergeProductsTask    Secondary Product marked Deleted for Primary ProductId: 24456 
2026-01-16 06:43:12.9769 DFramework.Scheduler.TaskBase    /* Time Taken: 16244.2313*/
Opportunity Out Of Stock By Outlet 
2026-01-16 06:52:56.8156 CoolR.Tasks.MergeProductsTask    AssetPurity related Tables are updated for primaryProductid: 24456 
2026-01-16 06:52:56.9093 CoolR.Tasks.MergeProductsTask    Planogram updated with Primary ProductId: 24456, POG Counts: 0 
2026-01-16 06:52:57.1598 CoolR.Tasks.MergeProductsTask    Other tables are updated for primaryProductid: 24456 
2026-01-16 06:52:57.2692 CoolR.Tasks.MergeProductsTask    MergeProduct SP executed with Primary ProductId: 24456 
2026-01-16 06:52:57.3317 CoolR.Tasks.MergeProductsTask    Secondary Product marked Deleted for Primary ProductId: 24456 
2026-01-16 06:57:57.4801 DFramework.Database.Query    /* Time Taken: 697*/
[dbo].GenerateSystemAlerts 
2026-01-16 06:58:12.5297 DFramework.Scheduler.TaskBase    /* Time Taken: 15784.6616*/
Opportunity Out Of Stock By Outlet 
2026-01-16 07:02:56.8229 CoolR.Tasks.MergeProductsTask    AssetPurity related Tables are updated for primaryProductid: 24456 
2026-01-16 07:02:56.8854 CoolR.Tasks.MergeProductsTask    Planogram updated with Primary ProductId: 24456, POG Counts: 0 
2026-01-16 07:02:57.1200 CoolR.Tasks.MergeProductsTask    Other tables are updated for primaryProductid: 24456 
2026-01-16 07:02:57.2451 CoolR.Tasks.MergeProductsTask    MergeProduct SP executed with Primary ProductId: 24456 
2026-01-16 07:02:57.3075 CoolR.Tasks.MergeProductsTask    Secondary Product marked Deleted for Primary ProductId: 24456 
2026-01-16 07:12:57.4132 DFramework.Database.Query    /* Time Taken: 588*/
DECLARE @IsActive Int32
SET @IsActive = '1'
DECLARE @FtpTypeId Int32
SET @FtpTypeId = '7766'
DECLARE @ClientId Int32
SET @ClientId = '213'
Select * from vwFTPClientList

 WHERE [IsActive] = @IsActive AND [FtpTypeId] = @FtpTypeId AND [ClientId] = @ClientId
 ORDER BY [ClientFtpId] 
2026-01-16 07:12:57.5071 DFramework.Database.NullableDataReader    Data reader open for 711
   at System.Environment.GetStackTrace(Exception e, Boolean needFileInfo)
   at System.Environment.get_StackTrace()
   at DFramework.Database.NullableDataReader.Dispose(Boolean disposing) in C:\CoolR-Group\Framework\DFramework\Database\NullableDataReader.cs:line 33
   at DFramework.Database.NullableDataReader.Dispose() in C:\CoolR-Group\Framework\DFramework\Database\NullableDataReader.cs:line 44
   at CoolR.Tasks.ProcessOutletAlertData.GetAlertDefinitions() in C:\CoolR-Group\portal\CoolR.Tasks\OpportunityOutOfStockByOutlet.cs:line 490
   at CoolR.Tasks.ProcessOutletAlertData.Execute() in C:\CoolR-Group\portal\CoolR.Tasks\OpportunityOutOfStockByOutlet.cs:line 72
   at DFramework.Scheduler.TaskBase.Run() in E:\Forked\Framework\DFramework.Scheduler\TaskBase.cs:line 176
   at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)
   at System.Threading.ExecutionContext.Run(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-16 07:12:57.7416 DFramework.Database.Query    /* Time Taken: 652*/
DECLARE @SecondaryProductId Int32
SET @SecondaryProductId = '39415'
DECLARE @ClientId Int32
SET @ClientId = '286'
SELECT AssetPurityId, PurityStatus, TagStatus FROM AssetPurity WHERE AssetPurityId IN (SELECT DISTINCT TOP 100 AssetPurityId FROM AssetPurityProduct WHERE ProductId = @SecondaryProductId) AND ClientId = @ClientId
 
2026-01-16 07:12:57.7416 CoolR.Tasks.MergeProductsTask    AssetPurity related Tables are updated for primaryProductid: 24456 
2026-01-16 07:12:57.8197 CoolR.Tasks.MergeProductsTask    Planogram updated with Primary ProductId: 24456, POG Counts: 0 
2026-01-16 07:12:58.0232 CoolR.Tasks.MergeProductsTask    Other tables are updated for primaryProductid: 24456 
2026-01-16 07:12:58.2425 CoolR.Tasks.MergeProductsTask    MergeProduct SP executed with Primary ProductId: 24456 
2026-01-16 07:12:58.3067 CoolR.Tasks.MergeProductsTask    Secondary Product marked Deleted for Primary ProductId: 24456 
2026-01-16 07:12:58.4811 DFramework.Database.Query    /* Time Taken: 1683*/
[dbo].GenerateSystemAlerts 
2026-01-16 07:13:13.1787 DFramework.Scheduler.TaskBase    /* Time Taken: 16406.459*/
Opportunity Out Of Stock By Outlet 
2026-01-16 07:22:56.8468 CoolR.Tasks.MergeProductsTask    AssetPurity related Tables are updated for primaryProductid: 24456 
2026-01-16 07:22:56.9093 CoolR.Tasks.MergeProductsTask    Planogram updated with Primary ProductId: 24456, POG Counts: 0 
2026-01-16 07:22:57.1594 CoolR.Tasks.MergeProductsTask    Other tables are updated for primaryProductid: 24456 
2026-01-16 07:22:57.2844 CoolR.Tasks.MergeProductsTask    MergeProduct SP executed with Primary ProductId: 24456 
2026-01-16 07:22:57.3469 CoolR.Tasks.MergeProductsTask    Secondary Product marked Deleted for Primary ProductId: 24456 
2026-01-16 07:27:57.0451 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 C:\CoolR-Group\Framework\DFramework\Database\NullableDataReader.cs:line 33
   at DFramework.Database.NullableDataReader.Dispose() in C:\CoolR-Group\Framework\DFramework\Database\NullableDataReader.cs:line 44
   at CoolR.Tasks.ProcessOutletAlertData.GetAlertDefinitions() in C:\CoolR-Group\portal\CoolR.Tasks\OpportunityOutOfStockByOutlet.cs:line 490
   at CoolR.Tasks.ProcessOutletAlertData.Execute() in C:\CoolR-Group\portal\CoolR.Tasks\OpportunityOutOfStockByOutlet.cs:line 72
   at DFramework.Scheduler.TaskBase.Run() in E:\Forked\Framework\DFramework.Scheduler\TaskBase.cs:line 176
   at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)
   at System.Threading.ExecutionContext.Run(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-16 07:27:57.5605 DFramework.Database.Query    /* Time Taken: 758*/
[dbo].GenerateSystemAlerts 
2026-01-16 07:28:13.2693 DFramework.Scheduler.TaskBase    /* Time Taken: 16474.5876*/
Opportunity Out Of Stock By Outlet 
2026-01-16 07:32:56.8634 CoolR.Tasks.MergeProductsTask    AssetPurity related Tables are updated for primaryProductid: 24456 
2026-01-16 07:32:56.9103 CoolR.Tasks.MergeProductsTask    Planogram updated with Primary ProductId: 24456, POG Counts: 0 
2026-01-16 07:32:57.0827 CoolR.Tasks.MergeProductsTask    Other tables are updated for primaryProductid: 24456 
2026-01-16 07:32:57.1769 CoolR.Tasks.MergeProductsTask    MergeProduct SP executed with Primary ProductId: 24456 
2026-01-16 07:32:57.2238 CoolR.Tasks.MergeProductsTask    Secondary Product marked Deleted for Primary ProductId: 24456 
2026-01-16 07:32:57.2394 MoveToReorder    Running task for ClientId : 286 and ClientName = India Office QA and Slot: 1/16/2026 9:00:00 PM And LastExecutedOn: 1/16/2026 8:02:57 PM 
2026-01-16 07:32:57.4743 MoveToReorder    Task executed successfully for ClientId : 286 Client Name:India Office QA, Slot: 1/16/2026 9:00:00 PM But No Order found to suggest 
2026-01-16 07:42:57.0972 CoolR.Tasks.MergeProductsTask    AssetPurity related Tables are updated for primaryProductid: 24456 
2026-01-16 07:42:57.2725 CoolR.Tasks.MergeProductsTask    Planogram updated with Primary ProductId: 24456, POG Counts: 0 
2026-01-16 07:42:57.3006 DFramework.Database.NullableDataReader    Data reader open for 473
   at System.Environment.GetStackTrace(Exception e, Boolean needFileInfo)
   at System.Environment.get_StackTrace()
   at DFramework.Database.NullableDataReader.Dispose(Boolean disposing) in C:\CoolR-Group\Framework\DFramework\Database\NullableDataReader.cs:line 33
   at DFramework.Database.NullableDataReader.Dispose() in C:\CoolR-Group\Framework\DFramework\Database\NullableDataReader.cs:line 44
   at CoolR.Tasks.ProcessOutletAlertData.GetAlertDefinitions() in C:\CoolR-Group\portal\CoolR.Tasks\OpportunityOutOfStockByOutlet.cs:line 490
   at CoolR.Tasks.ProcessOutletAlertData.Execute() in C:\CoolR-Group\portal\CoolR.Tasks\OpportunityOutOfStockByOutlet.cs:line 72
   at DFramework.Scheduler.TaskBase.Run() in E:\Forked\Framework\DFramework.Scheduler\TaskBase.cs:line 176
   at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)
   at System.Threading.ExecutionContext.Run(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-16 07:42:57.3949 DFramework.Database.Query    /* Time Taken: 567*/
[dbo].GenerateSystemAlerts 
2026-01-16 07:42:57.5042 CoolR.Tasks.MergeProductsTask    Other tables are updated for primaryProductid: 24456 
2026-01-16 07:42:57.6136 CoolR.Tasks.MergeProductsTask    MergeProduct SP executed with Primary ProductId: 24456 
2026-01-16 07:42:57.6761 CoolR.Tasks.MergeProductsTask    Secondary Product marked Deleted for Primary ProductId: 24456 
2026-01-16 07:43:12.8613 DFramework.Scheduler.TaskBase    /* Time Taken: 16060.9821*/
Opportunity Out Of Stock By Outlet 
2026-01-16 07:52:56.8944 CoolR.Tasks.MergeProductsTask    AssetPurity related Tables are updated for primaryProductid: 24456 
2026-01-16 07:52:56.9413 CoolR.Tasks.MergeProductsTask    Planogram updated with Primary ProductId: 24456, POG Counts: 0 
2026-01-16 07:52:57.3798 CoolR.Tasks.MergeProductsTask    Other tables are updated for primaryProductid: 24456 
2026-01-16 07:52:57.4892 CoolR.Tasks.MergeProductsTask    MergeProduct SP executed with Primary ProductId: 24456 
2026-01-16 07:52:57.5517 CoolR.Tasks.MergeProductsTask    Secondary Product marked Deleted for Primary ProductId: 24456 
2026-01-16 07:57:57.3418 DFramework.Database.Query    /* Time Taken: 505*/
[dbo].GenerateSystemAlerts 
2026-01-16 07:58:12.6045 DFramework.Scheduler.TaskBase    /* Time Taken: 15778.5162*/
Opportunity Out Of Stock By Outlet 
2026-01-16 08:02:56.9104 CoolR.Tasks.MergeProductsTask    AssetPurity related Tables are updated for primaryProductid: 24456 
2026-01-16 08:02:56.9755 CoolR.Tasks.MergeProductsTask    Planogram updated with Primary ProductId: 24456, POG Counts: 0 
2026-01-16 08:02:57.1917 CoolR.Tasks.MergeProductsTask    Other tables are updated for primaryProductid: 24456 
2026-01-16 08:02:57.2854 CoolR.Tasks.MergeProductsTask    MergeProduct SP executed with Primary ProductId: 24456 
2026-01-16 08:02:57.3479 CoolR.Tasks.MergeProductsTask    Secondary Product marked Deleted for Primary ProductId: 24456 
2026-01-16 08:12:57.2974 DFramework.Database.NullableDataReader    Data reader open for 430
   at System.Environment.GetStackTrace(Exception e, Boolean needFileInfo)
   at System.Environment.get_StackTrace()
   at DFramework.Database.NullableDataReader.Dispose(Boolean disposing) in C:\CoolR-Group\Framework\DFramework\Database\NullableDataReader.cs:line 33
   at DFramework.Database.NullableDataReader.Dispose() in C:\CoolR-Group\Framework\DFramework\Database\NullableDataReader.cs:line 44
   at CoolR.Tasks.ProcessOutletAlertData.GetAlertDefinitions() in C:\CoolR-Group\portal\CoolR.Tasks\OpportunityOutOfStockByOutlet.cs:line 490
   at CoolR.Tasks.ProcessOutletAlertData.Execute() in C:\CoolR-Group\portal\CoolR.Tasks\OpportunityOutOfStockByOutlet.cs:line 72
   at DFramework.Scheduler.TaskBase.Run() in E:\Forked\Framework\DFramework.Scheduler\TaskBase.cs:line 176
   at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)
   at System.Threading.ExecutionContext.Run(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-16 08:12:57.3130 CoolR.Tasks.MergeProductsTask    AssetPurity related Tables are updated for primaryProductid: 24456 
2026-01-16 08:12:57.3722 CoolR.Tasks.MergeProductsTask    Planogram updated with Primary ProductId: 24456, POG Counts: 0 
2026-01-16 08:12:57.5789 CoolR.Tasks.MergeProductsTask    Other tables are updated for primaryProductid: 24456 
2026-01-16 08:12:57.6414 DFramework.Database.Query    /* Time Taken: 529*/
DECLARE @OrderStatusId Int32
SET @OrderStatusId = '5485'
DECLARE @CurrentUtcDateTime DateTime2
SET @CurrentUtcDateTime = '1/16/2026 4:12:57 PM'
Select * FROM vwScheduledOrderItemList WHERE ScheduledOrderId IN (SELECT ScheduledOrder.ScheduledOrderId FROM dbo.ScheduledOrder
							INNER JOIN dbo.Location ON Location.ScheduledOrderId = ScheduledOrder.ScheduledOrderId AND Location.OrderStatusId = @OrderStatusId AND Location.IsDeleted = 0
							INNER JOIN dbo.Client On Client.ClientId = Location.ClientId
							WHERE ScheduledOrder.ModifiedOn < DATEADD(HOUR, -Client.HoursToMoveIgnored, @CurrentUtcDateTime) AND ScheduledOrder.StatusId = @OrderStatusId AND Client.HoursToMoveIgnored > 0)
 
2026-01-16 08:12:57.7351 DFramework.Database.Query    /* Time Taken: 877*/
[dbo].GenerateSystemAlerts 
2026-01-16 08:12:57.8132 CoolR.Tasks.MergeProductsTask    MergeProduct SP executed with Primary ProductId: 24456 
2026-01-16 08:12:57.8601 CoolR.Tasks.MergeProductsTask    Secondary Product marked Deleted for Primary ProductId: 24456 
2026-01-16 08:13:12.9495 DFramework.Scheduler.TaskBase    /* Time Taken: 16105.3568*/
Opportunity Out Of Stock By Outlet 
2026-01-16 08:22:56.9488 CoolR.Tasks.MergeProductsTask    AssetPurity related Tables are updated for primaryProductid: 24456 
2026-01-16 08:22:57.0269 CoolR.Tasks.MergeProductsTask    Planogram updated with Primary ProductId: 24456, POG Counts: 0 
2026-01-16 08:22:57.2613 CoolR.Tasks.MergeProductsTask    Other tables are updated for primaryProductid: 24456 
2026-01-16 08:22:57.3551 CoolR.Tasks.MergeProductsTask    MergeProduct SP executed with Primary ProductId: 24456 
2026-01-16 08:22:57.4176 CoolR.Tasks.MergeProductsTask    Secondary Product marked Deleted for Primary ProductId: 24456 
2026-01-16 08:27:57.6223 DFramework.Database.Query    /* Time Taken: 763*/
[dbo].GenerateSystemAlerts 
2026-01-16 08:28:12.6659 DFramework.Scheduler.TaskBase    /* Time Taken: 15809.2034*/
Opportunity Out Of Stock By Outlet 
2026-01-16 08:32:56.9587 CoolR.Tasks.MergeProductsTask    AssetPurity related Tables are updated for primaryProductid: 24456 
2026-01-16 08:32:57.0055 CoolR.Tasks.MergeProductsTask    Planogram updated with Primary ProductId: 24456, POG Counts: 0 
2026-01-16 08:32:57.1782 CoolR.Tasks.MergeProductsTask    Other tables are updated for primaryProductid: 24456 
2026-01-16 08:32:57.2564 MoveToReorder    Running task for ClientId : 286 and ClientName = India Office QA and Slot: 1/16/2026 10:00:00 PM And LastExecutedOn: 1/16/2026 9:02:57 PM 
2026-01-16 08:32:57.2876 CoolR.Tasks.MergeProductsTask    MergeProduct SP executed with Primary ProductId: 24456 
2026-01-16 08:32:57.3501 CoolR.Tasks.MergeProductsTask    Secondary Product marked Deleted for Primary ProductId: 24456 
2026-01-16 08:32:57.3814 CoolR.Tasks.MergeProductsTask    ProductPricing updated with Primary ProductId: 24456 
2026-01-16 08:32:57.4126 CoolR.Tasks.MergeProductsTask    LocationProduct updated with Primary ProductId: 24456 
2026-01-16 08:32:57.5376 MoveToReorder    Task executed successfully for ClientId : 286 Client Name:India Office QA, Slot: 1/16/2026 10:00:00 PM But No Order found to suggest 
2026-01-16 08:42:57.7292 DFramework.Database.Query    /* Time Taken: 850*/
[dbo].GenerateSystemAlerts 
2026-01-16 08:43:12.6154 DFramework.Scheduler.TaskBase    /* Time Taken: 15746.4729*/
Opportunity Out Of Stock By Outlet 
2026-01-16 08:57:57.7202 DFramework.Database.Query    /* Time Taken: 830*/
[dbo].GenerateSystemAlerts 
2026-01-16 08:58:12.6859 DFramework.Scheduler.TaskBase    /* Time Taken: 15809.5702*/
Opportunity Out Of Stock By Outlet 
2026-01-16 09:12:57.1849 DFramework.Database.NullableDataReader    Data reader open for 282
   at System.Environment.GetStackTrace(Exception e, Boolean needFileInfo)
   at System.Environment.get_StackTrace()
   at DFramework.Database.NullableDataReader.Dispose(Boolean disposing) in C:\CoolR-Group\Framework\DFramework\Database\NullableDataReader.cs:line 33
   at DFramework.Database.NullableDataReader.Dispose() in C:\CoolR-Group\Framework\DFramework\Database\NullableDataReader.cs:line 44
   at CoolR.Tasks.ProcessOutletAlertData.GetAlertDefinitions() in C:\CoolR-Group\portal\CoolR.Tasks\OpportunityOutOfStockByOutlet.cs:line 490
   at CoolR.Tasks.ProcessOutletAlertData.Execute() in C:\CoolR-Group\portal\CoolR.Tasks\OpportunityOutOfStockByOutlet.cs:line 72
   at DFramework.Scheduler.TaskBase.Run() in E:\Forked\Framework\DFramework.Scheduler\TaskBase.cs:line 176
   at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)
   at System.Threading.ExecutionContext.Run(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-16 09:12:57.8569 DFramework.Database.Query    /* Time Taken: 958*/
[dbo].GenerateSystemAlerts 
2026-01-16 09:13:12.9620 DFramework.Scheduler.TaskBase    /* Time Taken: 16074.0006*/
Opportunity Out Of Stock By Outlet 
2026-01-16 09:27:57.9713 DFramework.Database.Query    /* Time Taken: 1060*/
[dbo].GenerateSystemAlerts 
2026-01-16 09:28:12.7508 DFramework.Scheduler.TaskBase    /* Time Taken: 15842.7558*/
Opportunity Out Of Stock By Outlet 
2026-01-16 09:42:57.3331 DFramework.Database.NullableDataReader    Data reader open for 390
   at System.Environment.GetStackTrace(Exception e, Boolean needFileInfo)
   at System.Environment.get_StackTrace()
   at DFramework.Database.NullableDataReader.Dispose(Boolean disposing) in C:\CoolR-Group\Framework\DFramework\Database\NullableDataReader.cs:line 33
   at DFramework.Database.NullableDataReader.Dispose() in C:\CoolR-Group\Framework\DFramework\Database\NullableDataReader.cs:line 44
   at CoolR.Tasks.ProcessOutletAlertData.GetAlertDefinitions() in C:\CoolR-Group\portal\CoolR.Tasks\OpportunityOutOfStockByOutlet.cs:line 490
   at CoolR.Tasks.ProcessOutletAlertData.Execute() in C:\CoolR-Group\portal\CoolR.Tasks\OpportunityOutOfStockByOutlet.cs:line 72
   at DFramework.Scheduler.TaskBase.Run() in E:\Forked\Framework\DFramework.Scheduler\TaskBase.cs:line 176
   at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)
   at System.Threading.ExecutionContext.Run(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-16 09:42:57.5680 DFramework.Database.Query    /* Time Taken: 625*/
[dbo].GenerateSystemAlerts 
2026-01-16 09:43:12.9208 DFramework.Scheduler.TaskBase    /* Time Taken: 15994.6647*/
Opportunity Out Of Stock By Outlet 
2026-01-16 09:57:57.8369 DFramework.Database.Query    /* Time Taken: 888*/
[dbo].GenerateSystemAlerts 
2026-01-16 09:58:12.7929 DFramework.Scheduler.TaskBase    /* Time Taken: 15846.79*/
Opportunity Out Of Stock By Outlet 
2026-01-16 10:12:57.5604 DFramework.Database.NullableDataReader    Data reader open for 291
   at System.Environment.GetStackTrace(Exception e, Boolean needFileInfo)
   at System.Environment.get_StackTrace()
   at DFramework.Database.NullableDataReader.Dispose(Boolean disposing) in C:\CoolR-Group\Framework\DFramework\Database\NullableDataReader.cs:line 33
   at DFramework.Database.NullableDataReader.Dispose() in C:\CoolR-Group\Framework\DFramework\Database\NullableDataReader.cs:line 44
   at CoolR.Tasks.ProcessOutletAlertData.GetAlertDefinitions() in C:\CoolR-Group\portal\CoolR.Tasks\OpportunityOutOfStockByOutlet.cs:line 490
   at CoolR.Tasks.ProcessOutletAlertData.Execute() in C:\CoolR-Group\portal\CoolR.Tasks\OpportunityOutOfStockByOutlet.cs:line 72
   at DFramework.Scheduler.TaskBase.Run() in E:\Forked\Framework\DFramework.Scheduler\TaskBase.cs:line 176
   at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)
   at System.Threading.ExecutionContext.Run(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-16 10:12:57.5760 DFramework.Database.Query    /* Time Taken: 593*/
[dbo].GenerateSystemAlerts 
2026-01-16 10:13:13.1377 DFramework.Scheduler.TaskBase    /* Time Taken: 16155.4121*/
Opportunity Out Of Stock By Outlet 
2026-01-16 10:27:57.5318 DFramework.Database.Query    /* Time Taken: 533*/
[dbo].GenerateSystemAlerts 
2026-01-16 10:28:12.6803 DFramework.Scheduler.TaskBase    /* Time Taken: 15680.2551*/
Opportunity Out Of Stock By Outlet 
2026-01-16 10:42:57.6304 DFramework.Database.NullableDataReader    Data reader open for 331
   at System.Environment.GetStackTrace(Exception e, Boolean needFileInfo)
   at System.Environment.get_StackTrace()
   at DFramework.Database.NullableDataReader.Dispose(Boolean disposing) in C:\CoolR-Group\Framework\DFramework\Database\NullableDataReader.cs:line 33
   at DFramework.Database.NullableDataReader.Dispose() in C:\CoolR-Group\Framework\DFramework\Database\NullableDataReader.cs:line 44
   at CoolR.Tasks.ProcessOutletAlertData.GetAlertDefinitions() in C:\CoolR-Group\portal\CoolR.Tasks\OpportunityOutOfStockByOutlet.cs:line 490
   at CoolR.Tasks.ProcessOutletAlertData.Execute() in C:\CoolR-Group\portal\CoolR.Tasks\OpportunityOutOfStockByOutlet.cs:line 72
   at DFramework.Scheduler.TaskBase.Run() in E:\Forked\Framework\DFramework.Scheduler\TaskBase.cs:line 176
   at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)
   at System.Threading.ExecutionContext.Run(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-16 10:42:57.6460 DFramework.Database.Query    /* Time Taken: 630*/
[dbo].GenerateSystemAlerts 
2026-01-16 10:43:13.1912 DFramework.Scheduler.TaskBase    /* Time Taken: 16170.3402*/
Opportunity Out Of Stock By Outlet 
2026-01-16 10:57:57.6053 DFramework.Database.Query    /* Time Taken: 570*/
[dbo].GenerateSystemAlerts 
2026-01-16 10:57:57.6365 DFramework.Database.NullableDataReader    Data reader open for 339
   at System.Environment.GetStackTrace(Exception e, Boolean needFileInfo)
   at System.Environment.get_StackTrace()
   at DFramework.Database.NullableDataReader.Dispose(Boolean disposing) in C:\CoolR-Group\Framework\DFramework\Database\NullableDataReader.cs:line 33
   at DFramework.Database.NullableDataReader.Dispose() in C:\CoolR-Group\Framework\DFramework\Database\NullableDataReader.cs:line 44
   at CoolR.Tasks.ProcessOutletAlertData.GetAlertDefinitions() in C:\CoolR-Group\portal\CoolR.Tasks\OpportunityOutOfStockByOutlet.cs:line 490
   at CoolR.Tasks.ProcessOutletAlertData.Execute() in C:\CoolR-Group\portal\CoolR.Tasks\OpportunityOutOfStockByOutlet.cs:line 72
   at DFramework.Scheduler.TaskBase.Run() in E:\Forked\Framework\DFramework.Scheduler\TaskBase.cs:line 176
   at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)
   at System.Threading.ExecutionContext.Run(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-16 10:58:13.2362 DFramework.Scheduler.TaskBase    /* Time Taken: 16192.9116*/
Opportunity Out Of Stock By Outlet 
2026-01-16 11:12:57.6164 DFramework.Database.Query    /* Time Taken: 571*/
[dbo].GenerateSystemAlerts 
2026-01-16 11:13:13.3438 DFramework.Scheduler.TaskBase    /* Time Taken: 16290.3731*/
Opportunity Out Of Stock By Outlet 
2026-01-16 11:27:57.5647 DFramework.Database.Query    /* Time Taken: 509*/
[dbo].GenerateSystemAlerts 
2026-01-16 11:28:12.6927 DFramework.Scheduler.TaskBase    /* Time Taken: 15627.9812*/
Opportunity Out Of Stock By Outlet 
2026-01-16 11:42:57.4809 DFramework.Database.NullableDataReader    Data reader open for 384
   at System.Environment.GetStackTrace(Exception e, Boolean needFileInfo)
   at System.Environment.get_StackTrace()
   at DFramework.Database.NullableDataReader.Dispose(Boolean disposing) in C:\CoolR-Group\Framework\DFramework\Database\NullableDataReader.cs:line 33
   at DFramework.Database.NullableDataReader.Dispose() in C:\CoolR-Group\Framework\DFramework\Database\NullableDataReader.cs:line 44
   at CoolR.Tasks.ProcessOutletAlertData.GetAlertDefinitions() in C:\CoolR-Group\portal\CoolR.Tasks\OpportunityOutOfStockByOutlet.cs:line 490
   at CoolR.Tasks.ProcessOutletAlertData.Execute() in C:\CoolR-Group\portal\CoolR.Tasks\OpportunityOutOfStockByOutlet.cs:line 72
   at DFramework.Scheduler.TaskBase.Run() in E:\Forked\Framework\DFramework.Scheduler\TaskBase.cs:line 176
   at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)
   at System.Threading.ExecutionContext.Run(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-16 11:42:57.9037 DFramework.Database.Query    /* Time Taken: 840*/
[dbo].GenerateSystemAlerts 
2026-01-16 11:43:13.1667 DFramework.Scheduler.TaskBase    /* Time Taken: 16092.5903*/
Opportunity Out Of Stock By Outlet 
2026-01-16 11:55:25.7084 DFramework.Database.Query    /* Time Taken: 584*/
DECLARE @AssetPurityId Int32
SET @AssetPurityId = '3676247'
DECLARE @AssetId Int32
SET @AssetId = '118196'
DECLARE @StatusId Int32
SET @StatusId = '2'
DECLARE @PurityDateTime Date
SET @PurityDateTime = '1/16/2026 6:44:56 PM'
SELECT TOP 1 PurityDateTime, AssetPurityId, PlanogramId, Shelves, PurityStatus, AssetId, ImageReceivedFrom FROM AssetPurity
 WHERE [AssetPurityId] <= @AssetPurityId AND [AssetId] = @AssetId AND [StatusId] = @StatusId AND [PurityDateTime] > @PurityDateTime
 ORDER BY [PurityDateTime] DESC 
2026-01-16 11:57:28.5995 DFramework.Database.Query    /* Time Taken: 584*/
DECLARE @AssetPurityId Int32
SET @AssetPurityId = '3676247'
DECLARE @AssetId Int32
SET @AssetId = '118196'
DECLARE @StatusId Int32
SET @StatusId = '2'
DECLARE @PurityDateTime Date
SET @PurityDateTime = '1/16/2026 6:44:56 PM'
SELECT TOP 1 PurityDateTime, AssetPurityId, PlanogramId, Shelves, PurityStatus, AssetId, ImageReceivedFrom FROM AssetPurity
 WHERE [AssetPurityId] <= @AssetPurityId AND [AssetId] = @AssetId AND [StatusId] = @StatusId AND [PurityDateTime] > @PurityDateTime
 ORDER BY [PurityDateTime] DESC 
2026-01-16 11:57:57.6743 DFramework.Database.NullableDataReader    Data reader open for 312
   at System.Environment.GetStackTrace(Exception e, Boolean needFileInfo)
   at System.Environment.get_StackTrace()
   at DFramework.Database.NullableDataReader.Dispose(Boolean disposing) in C:\CoolR-Group\Framework\DFramework\Database\NullableDataReader.cs:line 33
   at DFramework.Database.NullableDataReader.Dispose() in C:\CoolR-Group\Framework\DFramework\Database\NullableDataReader.cs:line 44
   at CoolR.Tasks.ProcessOutletAlertData.GetAlertDefinitions() in C:\CoolR-Group\portal\CoolR.Tasks\OpportunityOutOfStockByOutlet.cs:line 490
   at CoolR.Tasks.ProcessOutletAlertData.Execute() in C:\CoolR-Group\portal\CoolR.Tasks\OpportunityOutOfStockByOutlet.cs:line 72
   at DFramework.Scheduler.TaskBase.Run() in E:\Forked\Framework\DFramework.Scheduler\TaskBase.cs:line 176
   at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)
   at System.Threading.ExecutionContext.Run(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-16 11:57:57.6899 DFramework.Database.Query    /* Time Taken: 602*/
[dbo].GenerateSystemAlerts 
2026-01-16 11:58:13.2196 DFramework.Scheduler.TaskBase    /* Time Taken: 16123.8107*/
Opportunity Out Of Stock By Outlet 
2026-01-16 12:12:57.7191 DFramework.Database.Query    /* Time Taken: 619*/
[dbo].GenerateSystemAlerts 
2026-01-16 12:13:13.1142 DFramework.Scheduler.TaskBase    /* Time Taken: 16004.9827*/
Opportunity Out Of Stock By Outlet 
2026-01-16 12:27:57.8152 DFramework.Database.Query    /* Time Taken: 689*/
[dbo].GenerateSystemAlerts 
2026-01-16 12:28:12.8924 DFramework.Scheduler.TaskBase    /* Time Taken: 15765.5308*/
Opportunity Out Of Stock By Outlet 
2026-01-16 12:42:57.7158 DFramework.Database.Query    /* Time Taken: 587*/
[dbo].GenerateSystemAlerts 
2026-01-16 12:43:12.9607 DFramework.Scheduler.TaskBase    /* Time Taken: 15823.4146*/
Opportunity Out Of Stock By Outlet 
2026-01-16 12:57:57.7102 DFramework.Database.Query    /* Time Taken: 556*/
[dbo].GenerateSystemAlerts 
2026-01-16 12:57:57.7415 DFramework.Database.NullableDataReader    Data reader open for 332
   at System.Environment.GetStackTrace(Exception e, Boolean needFileInfo)
   at System.Environment.get_StackTrace()
   at DFramework.Database.NullableDataReader.Dispose(Boolean disposing) in C:\CoolR-Group\Framework\DFramework\Database\NullableDataReader.cs:line 33
   at DFramework.Database.NullableDataReader.Dispose() in C:\CoolR-Group\Framework\DFramework\Database\NullableDataReader.cs:line 44
   at CoolR.Tasks.ProcessOutletAlertData.GetAlertDefinitions() in C:\CoolR-Group\portal\CoolR.Tasks\OpportunityOutOfStockByOutlet.cs:line 490
   at CoolR.Tasks.ProcessOutletAlertData.Execute() in C:\CoolR-Group\portal\CoolR.Tasks\OpportunityOutOfStockByOutlet.cs:line 72
   at DFramework.Scheduler.TaskBase.Run() in E:\Forked\Framework\DFramework.Scheduler\TaskBase.cs:line 176
   at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)
   at System.Threading.ExecutionContext.Run(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-16 12:58:13.2612 DFramework.Scheduler.TaskBase    /* Time Taken: 16098.3534*/
Opportunity Out Of Stock By Outlet 
2026-01-16 13:12:57.7458 DFramework.Database.Query    /* Time Taken: 569*/
[dbo].GenerateSystemAlerts 
2026-01-16 13:12:57.9333 DFramework.Database.NullableDataReader    Data reader open for 477
   at System.Environment.GetStackTrace(Exception e, Boolean needFileInfo)
   at System.Environment.get_StackTrace()
   at DFramework.Database.NullableDataReader.Dispose(Boolean disposing) in C:\CoolR-Group\Framework\DFramework\Database\NullableDataReader.cs:line 33
   at DFramework.Database.NullableDataReader.Dispose() in C:\CoolR-Group\Framework\DFramework\Database\NullableDataReader.cs:line 44
   at CoolR.Tasks.ProcessOutletAlertData.GetAlertDefinitions() in C:\CoolR-Group\portal\CoolR.Tasks\OpportunityOutOfStockByOutlet.cs:line 490
   at CoolR.Tasks.ProcessOutletAlertData.Execute() in C:\CoolR-Group\portal\CoolR.Tasks\OpportunityOutOfStockByOutlet.cs:line 72
   at DFramework.Scheduler.TaskBase.Run() in E:\Forked\Framework\DFramework.Scheduler\TaskBase.cs:line 176
   at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)
   at System.Threading.ExecutionContext.Run(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-16 13:13:13.4489 DFramework.Scheduler.TaskBase    /* Time Taken: 16265.9133*/
Opportunity Out Of Stock By Outlet 
2026-01-16 13:28:12.8488 DFramework.Scheduler.TaskBase    /* Time Taken: 15655.7148*/
Opportunity Out Of Stock By Outlet 
2026-01-16 13:42:57.7917 DFramework.Database.Query    /* Time Taken: 592*/
[dbo].GenerateSystemAlerts 
2026-01-16 13:43:13.2337 DFramework.Scheduler.TaskBase    /* Time Taken: 16020.1977*/
Opportunity Out Of Stock By Outlet 
2026-01-16 13:57:57.8051 DFramework.Database.NullableDataReader    Data reader open for 337
   at System.Environment.GetStackTrace(Exception e, Boolean needFileInfo)
   at System.Environment.get_StackTrace()
   at DFramework.Database.NullableDataReader.Dispose(Boolean disposing) in C:\CoolR-Group\Framework\DFramework\Database\NullableDataReader.cs:line 33
   at DFramework.Database.NullableDataReader.Dispose() in C:\CoolR-Group\Framework\DFramework\Database\NullableDataReader.cs:line 44
   at CoolR.Tasks.ProcessOutletAlertData.GetAlertDefinitions() in C:\CoolR-Group\portal\CoolR.Tasks\OpportunityOutOfStockByOutlet.cs:line 490
   at CoolR.Tasks.ProcessOutletAlertData.Execute() in C:\CoolR-Group\portal\CoolR.Tasks\OpportunityOutOfStockByOutlet.cs:line 72
   at DFramework.Scheduler.TaskBase.Run() in E:\Forked\Framework\DFramework.Scheduler\TaskBase.cs:line 176
   at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)
   at System.Threading.ExecutionContext.Run(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-16 13:58:13.3226 DFramework.Scheduler.TaskBase    /* Time Taken: 16095.9235*/
Opportunity Out Of Stock By Outlet 
2026-01-16 14:12:57.7502 DFramework.Database.NullableDataReader    Data reader open for 214
   at System.Environment.GetStackTrace(Exception e, Boolean needFileInfo)
   at System.Environment.get_StackTrace()
   at DFramework.Database.NullableDataReader.Dispose(Boolean disposing) in C:\CoolR-Group\Framework\DFramework\Database\NullableDataReader.cs:line 33
   at DFramework.Database.NullableDataReader.Dispose() in C:\CoolR-Group\Framework\DFramework\Database\NullableDataReader.cs:line 44
   at CoolR.Tasks.ProcessOutletAlertData.GetAlertDefinitions() in C:\CoolR-Group\portal\CoolR.Tasks\OpportunityOutOfStockByOutlet.cs:line 490
   at CoolR.Tasks.ProcessOutletAlertData.Execute() in C:\CoolR-Group\portal\CoolR.Tasks\OpportunityOutOfStockByOutlet.cs:line 72
   at DFramework.Scheduler.TaskBase.Run() in E:\Forked\Framework\DFramework.Scheduler\TaskBase.cs:line 176
   at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)
   at System.Threading.ExecutionContext.Run(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-16 14:12:57.8283 DFramework.Database.Query    /* Time Taken: 590*/
[dbo].GenerateSystemAlerts 
2026-01-16 14:13:13.2639 DFramework.Scheduler.TaskBase    /* Time Taken: 16012.2854*/
Opportunity Out Of Stock By Outlet 
2026-01-16 14:27:57.8800 DFramework.Database.Query    /* Time Taken: 617*/
[dbo].GenerateSystemAlerts 
2026-01-16 14:28:13.0358 DFramework.Scheduler.TaskBase    /* Time Taken: 15765.6168*/
Opportunity Out Of Stock By Outlet 
2026-01-16 14:42:58.0078 DFramework.Database.Query    /* Time Taken: 729*/
[dbo].GenerateSystemAlerts 
2026-01-16 14:43:13.1500 DFramework.Scheduler.TaskBase    /* Time Taken: 15861.1121*/
Opportunity Out Of Stock By Outlet 
2026-01-16 14:57:57.8536 DFramework.Database.Query    /* Time Taken: 560*/
[dbo].GenerateSystemAlerts 
2026-01-16 14:57:57.8848 DFramework.Database.NullableDataReader    Data reader open for 318
   at System.Environment.GetStackTrace(Exception e, Boolean needFileInfo)
   at System.Environment.get_StackTrace()
   at DFramework.Database.NullableDataReader.Dispose(Boolean disposing) in C:\CoolR-Group\Framework\DFramework\Database\NullableDataReader.cs:line 33
   at DFramework.Database.NullableDataReader.Dispose() in C:\CoolR-Group\Framework\DFramework\Database\NullableDataReader.cs:line 44
   at CoolR.Tasks.ProcessOutletAlertData.GetAlertDefinitions() in C:\CoolR-Group\portal\CoolR.Tasks\OpportunityOutOfStockByOutlet.cs:line 490
   at CoolR.Tasks.ProcessOutletAlertData.Execute() in C:\CoolR-Group\portal\CoolR.Tasks\OpportunityOutOfStockByOutlet.cs:line 72
   at DFramework.Scheduler.TaskBase.Run() in E:\Forked\Framework\DFramework.Scheduler\TaskBase.cs:line 176
   at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)
   at System.Threading.ExecutionContext.Run(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-16 14:58:13.4200 DFramework.Scheduler.TaskBase    /* Time Taken: 16113.331*/
Opportunity Out Of Stock By Outlet 
2026-01-16 15:12:57.6862 DFramework.Database.NullableDataReader    Data reader open for 346
   at System.Environment.GetStackTrace(Exception e, Boolean needFileInfo)
   at System.Environment.get_StackTrace()
   at DFramework.Database.NullableDataReader.Dispose(Boolean disposing) in C:\CoolR-Group\Framework\DFramework\Database\NullableDataReader.cs:line 33
   at DFramework.Database.NullableDataReader.Dispose() in C:\CoolR-Group\Framework\DFramework\Database\NullableDataReader.cs:line 44
   at CoolR.Tasks.ProcessOutletAlertData.GetAlertDefinitions() in C:\CoolR-Group\portal\CoolR.Tasks\OpportunityOutOfStockByOutlet.cs:line 490
   at CoolR.Tasks.ProcessOutletAlertData.Execute() in C:\CoolR-Group\portal\CoolR.Tasks\OpportunityOutOfStockByOutlet.cs:line 72
   at DFramework.Scheduler.TaskBase.Run() in E:\Forked\Framework\DFramework.Scheduler\TaskBase.cs:line 176
   at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)
   at System.Threading.ExecutionContext.Run(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-16 15:12:57.9211 DFramework.Database.Query    /* Time Taken: 607*/
[dbo].GenerateSystemAlerts 
2026-01-16 15:13:13.2503 DFramework.Scheduler.TaskBase    /* Time Taken: 15923.9907*/
Opportunity Out Of Stock By Outlet 
2026-01-16 15:27:57.9514 DFramework.Database.Query    /* Time Taken: 623*/
[dbo].GenerateSystemAlerts 
2026-01-16 15:28:13.0814 DFramework.Scheduler.TaskBase    /* Time Taken: 15739.4178*/
Opportunity Out Of Stock By Outlet 
2026-01-16 15:42:57.8996 DFramework.Database.Query    /* Time Taken: 554*/
[dbo].GenerateSystemAlerts 
2026-01-16 15:42:58.1101 DFramework.Database.NullableDataReader    Data reader open for 507
   at System.Environment.GetStackTrace(Exception e, Boolean needFileInfo)
   at System.Environment.get_StackTrace()
   at DFramework.Database.NullableDataReader.Dispose(Boolean disposing) in C:\CoolR-Group\Framework\DFramework\Database\NullableDataReader.cs:line 33
   at DFramework.Database.NullableDataReader.Dispose() in C:\CoolR-Group\Framework\DFramework\Database\NullableDataReader.cs:line 44
   at CoolR.Tasks.ProcessOutletAlertData.GetAlertDefinitions() in C:\CoolR-Group\portal\CoolR.Tasks\OpportunityOutOfStockByOutlet.cs:line 490
   at CoolR.Tasks.ProcessOutletAlertData.Execute() in C:\CoolR-Group\portal\CoolR.Tasks\OpportunityOutOfStockByOutlet.cs:line 72
   at DFramework.Scheduler.TaskBase.Run() in E:\Forked\Framework\DFramework.Scheduler\TaskBase.cs:line 176
   at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)
   at System.Threading.ExecutionContext.Run(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-16 15:43:13.6680 DFramework.Scheduler.TaskBase    /* Time Taken: 16315.2784*/
Opportunity Out Of Stock By Outlet 
2026-01-16 15:57:57.9382 DFramework.Database.NullableDataReader    Data reader open for 321
   at System.Environment.GetStackTrace(Exception e, Boolean needFileInfo)
   at System.Environment.get_StackTrace()
   at DFramework.Database.NullableDataReader.Dispose(Boolean disposing) in C:\CoolR-Group\Framework\DFramework\Database\NullableDataReader.cs:line 33
   at DFramework.Database.NullableDataReader.Dispose() in C:\CoolR-Group\Framework\DFramework\Database\NullableDataReader.cs:line 44
   at CoolR.Tasks.ProcessOutletAlertData.GetAlertDefinitions() in C:\CoolR-Group\portal\CoolR.Tasks\OpportunityOutOfStockByOutlet.cs:line 490
   at CoolR.Tasks.ProcessOutletAlertData.Execute() in C:\CoolR-Group\portal\CoolR.Tasks\OpportunityOutOfStockByOutlet.cs:line 72
   at DFramework.Scheduler.TaskBase.Run() in E:\Forked\Framework\DFramework.Scheduler\TaskBase.cs:line 176
   at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)
   at System.Threading.ExecutionContext.Run(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-16 15:58:13.4677 DFramework.Scheduler.TaskBase    /* Time Taken: 16092.019*/
Opportunity Out Of Stock By Outlet 
2026-01-16 16:12:57.7762 DFramework.Database.NullableDataReader    Data reader open for 374
   at System.Environment.GetStackTrace(Exception e, Boolean needFileInfo)
   at System.Environment.get_StackTrace()
   at DFramework.Database.NullableDataReader.Dispose(Boolean disposing) in C:\CoolR-Group\Framework\DFramework\Database\NullableDataReader.cs:line 33
   at DFramework.Database.NullableDataReader.Dispose() in C:\CoolR-Group\Framework\DFramework\Database\NullableDataReader.cs:line 44
   at CoolR.Tasks.ProcessOutletAlertData.GetAlertDefinitions() in C:\CoolR-Group\portal\CoolR.Tasks\OpportunityOutOfStockByOutlet.cs:line 490
   at CoolR.Tasks.ProcessOutletAlertData.Execute() in C:\CoolR-Group\portal\CoolR.Tasks\OpportunityOutOfStockByOutlet.cs:line 72
   at DFramework.Scheduler.TaskBase.Run() in E:\Forked\Framework\DFramework.Scheduler\TaskBase.cs:line 176
   at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)
   at System.Threading.ExecutionContext.Run(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-16 16:12:57.9637 DFramework.Database.Query    /* Time Taken: 587*/
[dbo].GenerateSystemAlerts 
2026-01-16 16:13:13.3408 DFramework.Scheduler.TaskBase    /* Time Taken: 15955.2659*/
Opportunity Out Of Stock By Outlet 
2026-01-16 16:27:57.7433 DFramework.Database.NullableDataReader    Data reader open for 314
   at System.Environment.GetStackTrace(Exception e, Boolean needFileInfo)
   at System.Environment.get_StackTrace()
   at DFramework.Database.NullableDataReader.Dispose(Boolean disposing) in C:\CoolR-Group\Framework\DFramework\Database\NullableDataReader.cs:line 33
   at DFramework.Database.NullableDataReader.Dispose() in C:\CoolR-Group\Framework\DFramework\Database\NullableDataReader.cs:line 44
   at CoolR.Tasks.ProcessOutletAlertData.GetAlertDefinitions() in C:\CoolR-Group\portal\CoolR.Tasks\OpportunityOutOfStockByOutlet.cs:line 490
   at CoolR.Tasks.ProcessOutletAlertData.Execute() in C:\CoolR-Group\portal\CoolR.Tasks\OpportunityOutOfStockByOutlet.cs:line 72
   at DFramework.Scheduler.TaskBase.Run() in E:\Forked\Framework\DFramework.Scheduler\TaskBase.cs:line 176
   at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)
   at System.Threading.ExecutionContext.Run(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-16 16:27:58.0083 DFramework.Database.Query    /* Time Taken: 619*/
[dbo].GenerateSystemAlerts 
2026-01-16 16:28:13.3209 DFramework.Scheduler.TaskBase    /* Time Taken: 15921.3506*/
Opportunity Out Of Stock By Outlet 
2026-01-16 16:42:58.5152 DFramework.Database.Query    /* Time Taken: 1103*/
[dbo].GenerateSystemAlerts 
2026-01-16 16:43:13.2340 DFramework.Scheduler.TaskBase    /* Time Taken: 15815.48*/
Opportunity Out Of Stock By Outlet 
2026-01-16 16:57:57.9896 DFramework.Database.NullableDataReader    Data reader open for 313
   at System.Environment.GetStackTrace(Exception e, Boolean needFileInfo)
   at System.Environment.get_StackTrace()
   at DFramework.Database.NullableDataReader.Dispose(Boolean disposing) in C:\CoolR-Group\Framework\DFramework\Database\NullableDataReader.cs:line 33
   at DFramework.Database.NullableDataReader.Dispose() in C:\CoolR-Group\Framework\DFramework\Database\NullableDataReader.cs:line 44
   at CoolR.Tasks.ProcessOutletAlertData.GetAlertDefinitions() in C:\CoolR-Group\portal\CoolR.Tasks\OpportunityOutOfStockByOutlet.cs:line 490
   at CoolR.Tasks.ProcessOutletAlertData.Execute() in C:\CoolR-Group\portal\CoolR.Tasks\OpportunityOutOfStockByOutlet.cs:line 72
   at DFramework.Scheduler.TaskBase.Run() in E:\Forked\Framework\DFramework.Scheduler\TaskBase.cs:line 176
   at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)
   at System.Threading.ExecutionContext.Run(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-16 16:57:57.9896 DFramework.Database.Query    /* Time Taken: 569*/
[dbo].GenerateSystemAlerts 
2026-01-16 16:58:13.4903 DFramework.Scheduler.TaskBase    /* Time Taken: 16063.5058*/
Opportunity Out Of Stock By Outlet 
2026-01-16 17:12:57.8780 DFramework.Database.NullableDataReader    Data reader open for 414
   at System.Environment.GetStackTrace(Exception e, Boolean needFileInfo)
   at System.Environment.get_StackTrace()
   at DFramework.Database.NullableDataReader.Dispose(Boolean disposing) in C:\CoolR-Group\Framework\DFramework\Database\NullableDataReader.cs:line 33
   at DFramework.Database.NullableDataReader.Dispose() in C:\CoolR-Group\Framework\DFramework\Database\NullableDataReader.cs:line 44
   at CoolR.Tasks.ProcessOutletAlertData.GetAlertDefinitions() in C:\CoolR-Group\portal\CoolR.Tasks\OpportunityOutOfStockByOutlet.cs:line 490
   at CoolR.Tasks.ProcessOutletAlertData.Execute() in C:\CoolR-Group\portal\CoolR.Tasks\OpportunityOutOfStockByOutlet.cs:line 72
   at DFramework.Scheduler.TaskBase.Run() in E:\Forked\Framework\DFramework.Scheduler\TaskBase.cs:line 176
   at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)
   at System.Threading.ExecutionContext.Run(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-16 17:12:58.1123 DFramework.Database.Query    /* Time Taken: 671*/
[dbo].GenerateSystemAlerts 
2026-01-16 17:13:13.4603 DFramework.Scheduler.TaskBase    /* Time Taken: 16019.86*/
Opportunity Out Of Stock By Outlet 
2026-01-16 17:27:57.7843 DFramework.Database.NullableDataReader    Data reader open for 309
   at System.Environment.GetStackTrace(Exception e, Boolean needFileInfo)
   at System.Environment.get_StackTrace()
   at DFramework.Database.NullableDataReader.Dispose(Boolean disposing) in C:\CoolR-Group\Framework\DFramework\Database\NullableDataReader.cs:line 33
   at DFramework.Database.NullableDataReader.Dispose() in C:\CoolR-Group\Framework\DFramework\Database\NullableDataReader.cs:line 44
   at CoolR.Tasks.ProcessOutletAlertData.GetAlertDefinitions() in C:\CoolR-Group\portal\CoolR.Tasks\OpportunityOutOfStockByOutlet.cs:line 490
   at CoolR.Tasks.ProcessOutletAlertData.Execute() in C:\CoolR-Group\portal\CoolR.Tasks\OpportunityOutOfStockByOutlet.cs:line 72
   at DFramework.Scheduler.TaskBase.Run() in E:\Forked\Framework\DFramework.Scheduler\TaskBase.cs:line 176
   at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)
   at System.Threading.ExecutionContext.Run(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-16 17:27:57.9874 DFramework.Database.Query    /* Time Taken: 542*/
[dbo].GenerateSystemAlerts 
2026-01-16 17:28:13.3450 DFramework.Scheduler.TaskBase    /* Time Taken: 15889.3389*/
Opportunity Out Of Stock By Outlet 
2026-01-16 17:42:58.0507 DFramework.Database.NullableDataReader    Data reader open for 325
   at System.Environment.GetStackTrace(Exception e, Boolean needFileInfo)
   at System.Environment.get_StackTrace()
   at DFramework.Database.NullableDataReader.Dispose(Boolean disposing) in C:\CoolR-Group\Framework\DFramework\Database\NullableDataReader.cs:line 33
   at DFramework.Database.NullableDataReader.Dispose() in C:\CoolR-Group\Framework\DFramework\Database\NullableDataReader.cs:line 44
   at CoolR.Tasks.ProcessOutletAlertData.GetAlertDefinitions() in C:\CoolR-Group\portal\CoolR.Tasks\OpportunityOutOfStockByOutlet.cs:line 490
   at CoolR.Tasks.ProcessOutletAlertData.Execute() in C:\CoolR-Group\portal\CoolR.Tasks\OpportunityOutOfStockByOutlet.cs:line 72
   at DFramework.Scheduler.TaskBase.Run() in E:\Forked\Framework\DFramework.Scheduler\TaskBase.cs:line 176
   at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)
   at System.Threading.ExecutionContext.Run(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-16 17:43:13.5508 DFramework.Scheduler.TaskBase    /* Time Taken: 16078.2418*/
Opportunity Out Of Stock By Outlet 
2026-01-16 17:57:58.0699 DFramework.Database.NullableDataReader    Data reader open for 324
   at System.Environment.GetStackTrace(Exception e, Boolean needFileInfo)
   at System.Environment.get_StackTrace()
   at DFramework.Database.NullableDataReader.Dispose(Boolean disposing) in C:\CoolR-Group\Framework\DFramework\Database\NullableDataReader.cs:line 33
   at DFramework.Database.NullableDataReader.Dispose() in C:\CoolR-Group\Framework\DFramework\Database\NullableDataReader.cs:line 44
   at CoolR.Tasks.ProcessOutletAlertData.GetAlertDefinitions() in C:\CoolR-Group\portal\CoolR.Tasks\OpportunityOutOfStockByOutlet.cs:line 490
   at CoolR.Tasks.ProcessOutletAlertData.Execute() in C:\CoolR-Group\portal\CoolR.Tasks\OpportunityOutOfStockByOutlet.cs:line 72
   at DFramework.Scheduler.TaskBase.Run() in E:\Forked\Framework\DFramework.Scheduler\TaskBase.cs:line 176
   at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)
   at System.Threading.ExecutionContext.Run(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-16 17:58:13.5995 DFramework.Scheduler.TaskBase    /* Time Taken: 16107.6638*/
Opportunity Out Of Stock By Outlet 
2026-01-16 18:12:57.8358 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 C:\CoolR-Group\Framework\DFramework\Database\NullableDataReader.cs:line 33
   at DFramework.Database.NullableDataReader.Dispose() in C:\CoolR-Group\Framework\DFramework\Database\NullableDataReader.cs:line 44
   at CoolR.Tasks.ProcessOutletAlertData.GetAlertDefinitions() in C:\CoolR-Group\portal\CoolR.Tasks\OpportunityOutOfStockByOutlet.cs:line 490
   at CoolR.Tasks.ProcessOutletAlertData.Execute() in C:\CoolR-Group\portal\CoolR.Tasks\OpportunityOutOfStockByOutlet.cs:line 72
   at DFramework.Scheduler.TaskBase.Run() in E:\Forked\Framework\DFramework.Scheduler\TaskBase.cs:line 176
   at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)
   at System.Threading.ExecutionContext.Run(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-16 18:12:58.1961 DFramework.Database.Query    /* Time Taken: 691*/
[dbo].GenerateSystemAlerts 
2026-01-16 18:13:13.4730 DFramework.Scheduler.TaskBase    /* Time Taken: 15965.3127*/
Opportunity Out Of Stock By Outlet 
2026-01-16 18:27:58.0792 DFramework.Database.NullableDataReader    Data reader open for 304
   at System.Environment.GetStackTrace(Exception e, Boolean needFileInfo)
   at System.Environment.get_StackTrace()
   at DFramework.Database.NullableDataReader.Dispose(Boolean disposing) in C:\CoolR-Group\Framework\DFramework\Database\NullableDataReader.cs:line 33
   at DFramework.Database.NullableDataReader.Dispose() in C:\CoolR-Group\Framework\DFramework\Database\NullableDataReader.cs:line 44
   at CoolR.Tasks.ProcessOutletAlertData.GetAlertDefinitions() in C:\CoolR-Group\portal\CoolR.Tasks\OpportunityOutOfStockByOutlet.cs:line 490
   at CoolR.Tasks.ProcessOutletAlertData.Execute() in C:\CoolR-Group\portal\CoolR.Tasks\OpportunityOutOfStockByOutlet.cs:line 72
   at DFramework.Scheduler.TaskBase.Run() in E:\Forked\Framework\DFramework.Scheduler\TaskBase.cs:line 176
   at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)
   at System.Threading.ExecutionContext.Run(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-16 18:28:13.6099 DFramework.Scheduler.TaskBase    /* Time Taken: 16078.2445*/
Opportunity Out Of Stock By Outlet 
2026-01-16 18:32:58.2582 MoveToReorder    Running task for ClientId : 286 and ClientName = India Office QA and Slot: 1/17/2026 8:00:00 AM And LastExecutedOn: 1/16/2026 10:02:57 PM 
2026-01-16 18:33:38.1486 DFramework.Database.NullableDataReader    Data reader open for 39603
   at System.Environment.GetStackTrace(Exception e, Boolean needFileInfo)
   at System.Environment.get_StackTrace()
   at DFramework.Database.NullableDataReader.Dispose(Boolean disposing) in C:\CoolR-Group\Framework\DFramework\Database\NullableDataReader.cs:line 33
   at DFramework.Database.NullableDataReader.Dispose() in C:\CoolR-Group\Framework\DFramework\Database\NullableDataReader.cs:line 44
   at CoolR.Tasks.MoveToReorder.Execute() in C:\CoolR-Group\portal\CoolR.Tasks\MoveToReorder.cs:line 44
   at DFramework.Scheduler.TaskBase.Run() in E:\Forked\Framework\DFramework.Scheduler\TaskBase.cs:line 176
   at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)
   at System.Threading.ExecutionContext.Run(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-16 18:33:38.1643 MoveToReorder    Task executed successfully for ClientId : 286 Client Name:India Office QA, Slot: 1/17/2026 8:00:00 AM and Total Order Suggested: 127 Out Of: 127 
2026-01-16 18:33:39.2625 DFramework.Scheduler.TaskBase    /* Time Taken: 41394.8534*/
Move To Re-Order 
2026-01-16 18:42:58.0699 DFramework.Database.Query    /* Time Taken: 534*/
[dbo].GenerateSystemAlerts 
2026-01-16 18:42:58.1637 DFramework.Database.NullableDataReader    Data reader open for 321
   at System.Environment.GetStackTrace(Exception e, Boolean needFileInfo)
   at System.Environment.get_StackTrace()
   at DFramework.Database.NullableDataReader.Dispose(Boolean disposing) in C:\CoolR-Group\Framework\DFramework\Database\NullableDataReader.cs:line 33
   at DFramework.Database.NullableDataReader.Dispose() in C:\CoolR-Group\Framework\DFramework\Database\NullableDataReader.cs:line 44
   at CoolR.Tasks.ProcessOutletAlertData.GetAlertDefinitions() in C:\CoolR-Group\portal\CoolR.Tasks\OpportunityOutOfStockByOutlet.cs:line 490
   at CoolR.Tasks.ProcessOutletAlertData.Execute() in C:\CoolR-Group\portal\CoolR.Tasks\OpportunityOutOfStockByOutlet.cs:line 72
   at DFramework.Scheduler.TaskBase.Run() in E:\Forked\Framework\DFramework.Scheduler\TaskBase.cs:line 176
   at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)
   at System.Threading.ExecutionContext.Run(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-16 18:43:13.6884 DFramework.Scheduler.TaskBase    /* Time Taken: 16149.8805*/
Opportunity Out Of Stock By Outlet 
2026-01-16 18:57:58.1447 DFramework.Database.NullableDataReader    Data reader open for 315
   at System.Environment.GetStackTrace(Exception e, Boolean needFileInfo)
   at System.Environment.get_StackTrace()
   at DFramework.Database.NullableDataReader.Dispose(Boolean disposing) in C:\CoolR-Group\Framework\DFramework\Database\NullableDataReader.cs:line 33
   at DFramework.Database.NullableDataReader.Dispose() in C:\CoolR-Group\Framework\DFramework\Database\NullableDataReader.cs:line 44
   at CoolR.Tasks.ProcessOutletAlertData.GetAlertDefinitions() in C:\CoolR-Group\portal\CoolR.Tasks\OpportunityOutOfStockByOutlet.cs:line 490
   at CoolR.Tasks.ProcessOutletAlertData.Execute() in C:\CoolR-Group\portal\CoolR.Tasks\OpportunityOutOfStockByOutlet.cs:line 72
   at DFramework.Scheduler.TaskBase.Run() in E:\Forked\Framework\DFramework.Scheduler\TaskBase.cs:line 176
   at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)
   at System.Threading.ExecutionContext.Run(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-16 18:58:13.6425 DFramework.Scheduler.TaskBase    /* Time Taken: 16076.8849*/
Opportunity Out Of Stock By Outlet 
2026-01-16 19:12:57.9022 DFramework.Database.NullableDataReader    Data reader open for 309
   at System.Environment.GetStackTrace(Exception e, Boolean needFileInfo)
   at System.Environment.get_StackTrace()
   at DFramework.Database.NullableDataReader.Dispose(Boolean disposing) in C:\CoolR-Group\Framework\DFramework\Database\NullableDataReader.cs:line 33
   at DFramework.Database.NullableDataReader.Dispose() in C:\CoolR-Group\Framework\DFramework\Database\NullableDataReader.cs:line 44
   at CoolR.Tasks.ProcessOutletAlertData.GetAlertDefinitions() in C:\CoolR-Group\portal\CoolR.Tasks\OpportunityOutOfStockByOutlet.cs:line 490
   at CoolR.Tasks.ProcessOutletAlertData.Execute() in C:\CoolR-Group\portal\CoolR.Tasks\OpportunityOutOfStockByOutlet.cs:line 72
   at DFramework.Scheduler.TaskBase.Run() in E:\Forked\Framework\DFramework.Scheduler\TaskBase.cs:line 176
   at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)
   at System.Threading.ExecutionContext.Run(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-16 19:12:58.1836 DFramework.Database.Query    /* Time Taken: 619*/
[dbo].GenerateSystemAlerts 
2026-01-16 19:13:13.4641 DFramework.Scheduler.TaskBase    /* Time Taken: 15890.0806*/
Opportunity Out Of Stock By Outlet 
2026-01-16 19:27:58.1699 DFramework.Database.NullableDataReader    Data reader open for 313
   at System.Environment.GetStackTrace(Exception e, Boolean needFileInfo)
   at System.Environment.get_StackTrace()
   at DFramework.Database.NullableDataReader.Dispose(Boolean disposing) in C:\CoolR-Group\Framework\DFramework\Database\NullableDataReader.cs:line 33
   at DFramework.Database.NullableDataReader.Dispose() in C:\CoolR-Group\Framework\DFramework\Database\NullableDataReader.cs:line 44
   at CoolR.Tasks.ProcessOutletAlertData.GetAlertDefinitions() in C:\CoolR-Group\portal\CoolR.Tasks\OpportunityOutOfStockByOutlet.cs:line 490
   at CoolR.Tasks.ProcessOutletAlertData.Execute() in C:\CoolR-Group\portal\CoolR.Tasks\OpportunityOutOfStockByOutlet.cs:line 72
   at DFramework.Scheduler.TaskBase.Run() in E:\Forked\Framework\DFramework.Scheduler\TaskBase.cs:line 176
   at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)
   at System.Threading.ExecutionContext.Run(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-16 19:28:13.6717 DFramework.Scheduler.TaskBase    /* Time Taken: 16064.327*/
Opportunity Out Of Stock By Outlet 
2026-01-16 19:32:58.3450 MoveToReorder    Running task for ClientId : 286 and ClientName = India Office QA and Slot: 1/17/2026 9:00:00 AM And LastExecutedOn: 1/17/2026 8:02:58 AM 
2026-01-16 19:32:58.5964 MoveToReorder    Task executed successfully for ClientId : 286 Client Name:India Office QA, Slot: 1/17/2026 9:00:00 AM But No Order found to suggest 
2026-01-16 19:42:58.2009 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 C:\CoolR-Group\Framework\DFramework\Database\NullableDataReader.cs:line 33
   at DFramework.Database.NullableDataReader.Dispose() in C:\CoolR-Group\Framework\DFramework\Database\NullableDataReader.cs:line 44
   at CoolR.Tasks.ProcessOutletAlertData.GetAlertDefinitions() in C:\CoolR-Group\portal\CoolR.Tasks\OpportunityOutOfStockByOutlet.cs:line 490
   at CoolR.Tasks.ProcessOutletAlertData.Execute() in C:\CoolR-Group\portal\CoolR.Tasks\OpportunityOutOfStockByOutlet.cs:line 72
   at DFramework.Scheduler.TaskBase.Run() in E:\Forked\Framework\DFramework.Scheduler\TaskBase.cs:line 176
   at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)
   at System.Threading.ExecutionContext.Run(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-16 19:43:13.7019 DFramework.Scheduler.TaskBase    /* Time Taken: 16079.089*/
Opportunity Out Of Stock By Outlet 
2026-01-16 19:57:57.9725 DFramework.Database.NullableDataReader    Data reader open for 312
   at System.Environment.GetStackTrace(Exception e, Boolean needFileInfo)
   at System.Environment.get_StackTrace()
   at DFramework.Database.NullableDataReader.Dispose(Boolean disposing) in C:\CoolR-Group\Framework\DFramework\Database\NullableDataReader.cs:line 33
   at DFramework.Database.NullableDataReader.Dispose() in C:\CoolR-Group\Framework\DFramework\Database\NullableDataReader.cs:line 44
   at CoolR.Tasks.ProcessOutletAlertData.GetAlertDefinitions() in C:\CoolR-Group\portal\CoolR.Tasks\OpportunityOutOfStockByOutlet.cs:line 490
   at CoolR.Tasks.ProcessOutletAlertData.Execute() in C:\CoolR-Group\portal\CoolR.Tasks\OpportunityOutOfStockByOutlet.cs:line 72
   at DFramework.Scheduler.TaskBase.Run() in E:\Forked\Framework\DFramework.Scheduler\TaskBase.cs:line 176
   at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)
   at System.Threading.ExecutionContext.Run(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-16 19:57:58.2068 DFramework.Database.Query    /* Time Taken: 576*/
[dbo].GenerateSystemAlerts 
2026-01-16 19:58:13.5629 DFramework.Scheduler.TaskBase    /* Time Taken: 15918.6431*/
Opportunity Out Of Stock By Outlet 
2026-01-16 20:12:57.9882 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 C:\CoolR-Group\Framework\DFramework\Database\NullableDataReader.cs:line 33
   at DFramework.Database.NullableDataReader.Dispose() in C:\CoolR-Group\Framework\DFramework\Database\NullableDataReader.cs:line 44
   at CoolR.Tasks.ProcessOutletAlertData.GetAlertDefinitions() in C:\CoolR-Group\portal\CoolR.Tasks\OpportunityOutOfStockByOutlet.cs:line 490
   at CoolR.Tasks.ProcessOutletAlertData.Execute() in C:\CoolR-Group\portal\CoolR.Tasks\OpportunityOutOfStockByOutlet.cs:line 72
   at DFramework.Scheduler.TaskBase.Run() in E:\Forked\Framework\DFramework.Scheduler\TaskBase.cs:line 176
   at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)
   at System.Threading.ExecutionContext.Run(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-16 20:12:58.1913 DFramework.Database.Query    /* Time Taken: 540*/
[dbo].GenerateSystemAlerts 
2026-01-16 20:13:13.6458 DFramework.Scheduler.TaskBase    /* Time Taken: 15985.5551*/
Opportunity Out Of Stock By Outlet 
2026-01-16 20:27:58.2404 DFramework.Database.NullableDataReader    Data reader open for 315
   at System.Environment.GetStackTrace(Exception e, Boolean needFileInfo)
   at System.Environment.get_StackTrace()
   at DFramework.Database.NullableDataReader.Dispose(Boolean disposing) in C:\CoolR-Group\Framework\DFramework\Database\NullableDataReader.cs:line 33
   at DFramework.Database.NullableDataReader.Dispose() in C:\CoolR-Group\Framework\DFramework\Database\NullableDataReader.cs:line 44
   at CoolR.Tasks.ProcessOutletAlertData.GetAlertDefinitions() in C:\CoolR-Group\portal\CoolR.Tasks\OpportunityOutOfStockByOutlet.cs:line 490
   at CoolR.Tasks.ProcessOutletAlertData.Execute() in C:\CoolR-Group\portal\CoolR.Tasks\OpportunityOutOfStockByOutlet.cs:line 72
   at DFramework.Scheduler.TaskBase.Run() in E:\Forked\Framework\DFramework.Scheduler\TaskBase.cs:line 176
   at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)
   at System.Threading.ExecutionContext.Run(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-16 20:28:13.7428 DFramework.Scheduler.TaskBase    /* Time Taken: 16065.1592*/
Opportunity Out Of Stock By Outlet 
2026-01-16 20:32:58.4277 MoveToReorder    Running task for ClientId : 286 and ClientName = India Office QA and Slot: 1/17/2026 10:00:00 AM And LastExecutedOn: 1/17/2026 9:02:58 AM 
2026-01-16 20:32:58.6643 MoveToReorder    Task executed successfully for ClientId : 286 Client Name:India Office QA, Slot: 1/17/2026 10:00:00 AM But No Order found to suggest 
2026-01-16 20:42:58.3551 DFramework.Database.Query    /* Time Taken: 656*/
[dbo].GenerateSystemAlerts 
2026-01-16 20:42:58.3741 DFramework.Database.NullableDataReader    Data reader open for 422
   at System.Environment.GetStackTrace(Exception e, Boolean needFileInfo)
   at System.Environment.get_StackTrace()
   at DFramework.Database.NullableDataReader.Dispose(Boolean disposing) in C:\CoolR-Group\Framework\DFramework\Database\NullableDataReader.cs:line 33
   at DFramework.Database.NullableDataReader.Dispose() in C:\CoolR-Group\Framework\DFramework\Database\NullableDataReader.cs:line 44
   at CoolR.Tasks.ProcessOutletAlertData.GetAlertDefinitions() in C:\CoolR-Group\portal\CoolR.Tasks\OpportunityOutOfStockByOutlet.cs:line 490
   at CoolR.Tasks.ProcessOutletAlertData.Execute() in C:\CoolR-Group\portal\CoolR.Tasks\OpportunityOutOfStockByOutlet.cs:line 72
   at DFramework.Scheduler.TaskBase.Run() in E:\Forked\Framework\DFramework.Scheduler\TaskBase.cs:line 176
   at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)
   at System.Threading.ExecutionContext.Run(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-16 20:43:13.9633 DFramework.Scheduler.TaskBase    /* Time Taken: 16264.5001*/
Opportunity Out Of Stock By Outlet 
2026-01-16 20:58:13.3661 DFramework.Scheduler.TaskBase    /* Time Taken: 15640.1876*/
Opportunity Out Of Stock By Outlet 
2026-01-16 21:12:58.0770 DFramework.Database.NullableDataReader    Data reader open for 306
   at System.Environment.GetStackTrace(Exception e, Boolean needFileInfo)
   at System.Environment.get_StackTrace()
   at DFramework.Database.NullableDataReader.Dispose(Boolean disposing) in C:\CoolR-Group\Framework\DFramework\Database\NullableDataReader.cs:line 33
   at DFramework.Database.NullableDataReader.Dispose() in C:\CoolR-Group\Framework\DFramework\Database\NullableDataReader.cs:line 44
   at CoolR.Tasks.ProcessOutletAlertData.GetAlertDefinitions() in C:\CoolR-Group\portal\CoolR.Tasks\OpportunityOutOfStockByOutlet.cs:line 490
   at CoolR.Tasks.ProcessOutletAlertData.Execute() in C:\CoolR-Group\portal\CoolR.Tasks\OpportunityOutOfStockByOutlet.cs:line 72
   at DFramework.Scheduler.TaskBase.Run() in E:\Forked\Framework\DFramework.Scheduler\TaskBase.cs:line 176
   at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)
   at System.Threading.ExecutionContext.Run(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-16 21:12:58.3653 DFramework.Database.Query    /* Time Taken: 618*/
[dbo].GenerateSystemAlerts 
2026-01-16 21:13:13.7059 DFramework.Scheduler.TaskBase    /* Time Taken: 15957.0375*/
Opportunity Out Of Stock By Outlet 
2026-01-16 21:27:58.3295 DFramework.Database.NullableDataReader    Data reader open for 314
   at System.Environment.GetStackTrace(Exception e, Boolean needFileInfo)
   at System.Environment.get_StackTrace()
   at DFramework.Database.NullableDataReader.Dispose(Boolean disposing) in C:\CoolR-Group\Framework\DFramework\Database\NullableDataReader.cs:line 33
   at DFramework.Database.NullableDataReader.Dispose() in C:\CoolR-Group\Framework\DFramework\Database\NullableDataReader.cs:line 44
   at CoolR.Tasks.ProcessOutletAlertData.GetAlertDefinitions() in C:\CoolR-Group\portal\CoolR.Tasks\OpportunityOutOfStockByOutlet.cs:line 490
   at CoolR.Tasks.ProcessOutletAlertData.Execute() in C:\CoolR-Group\portal\CoolR.Tasks\OpportunityOutOfStockByOutlet.cs:line 72
   at DFramework.Scheduler.TaskBase.Run() in E:\Forked\Framework\DFramework.Scheduler\TaskBase.cs:line 176
   at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)
   at System.Threading.ExecutionContext.Run(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-16 21:28:13.8483 DFramework.Scheduler.TaskBase    /* Time Taken: 16081.569*/
Opportunity Out Of Stock By Outlet 
2026-01-16 21:32:58.4588 MoveToReorder    Running task for ClientId : 286 and ClientName = India Office QA and Slot: 1/17/2026 11:00:00 AM And LastExecutedOn: 1/17/2026 10:02:58 AM 
2026-01-16 21:33:37.4108 DFramework.Database.NullableDataReader    Data reader open for 38676
   at System.Environment.GetStackTrace(Exception e, Boolean needFileInfo)
   at System.Environment.get_StackTrace()
   at DFramework.Database.NullableDataReader.Dispose(Boolean disposing) in C:\CoolR-Group\Framework\DFramework\Database\NullableDataReader.cs:line 33
   at DFramework.Database.NullableDataReader.Dispose() in C:\CoolR-Group\Framework\DFramework\Database\NullableDataReader.cs:line 44
   at CoolR.Tasks.MoveToReorder.Execute() in C:\CoolR-Group\portal\CoolR.Tasks\MoveToReorder.cs:line 44
   at DFramework.Scheduler.TaskBase.Run() in E:\Forked\Framework\DFramework.Scheduler\TaskBase.cs:line 176
   at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)
   at System.Threading.ExecutionContext.Run(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-16 21:33:37.4420 MoveToReorder    Task executed successfully for ClientId : 286 Client Name:India Office QA, Slot: 1/17/2026 11:00:00 AM and Total Order Suggested: 126 Out Of: 126 
2026-01-16 21:33:38.5547 DFramework.Scheduler.TaskBase    /* Time Taken: 40422.8587*/
Move To Re-Order 
2026-01-16 21:42:58.3592 DFramework.Database.NullableDataReader    Data reader open for 324
   at System.Environment.GetStackTrace(Exception e, Boolean needFileInfo)
   at System.Environment.get_StackTrace()
   at DFramework.Database.NullableDataReader.Dispose(Boolean disposing) in C:\CoolR-Group\Framework\DFramework\Database\NullableDataReader.cs:line 33
   at DFramework.Database.NullableDataReader.Dispose() in C:\CoolR-Group\Framework\DFramework\Database\NullableDataReader.cs:line 44
   at CoolR.Tasks.ProcessOutletAlertData.GetAlertDefinitions() in C:\CoolR-Group\portal\CoolR.Tasks\OpportunityOutOfStockByOutlet.cs:line 490
   at CoolR.Tasks.ProcessOutletAlertData.Execute() in C:\CoolR-Group\portal\CoolR.Tasks\OpportunityOutOfStockByOutlet.cs:line 72
   at DFramework.Scheduler.TaskBase.Run() in E:\Forked\Framework\DFramework.Scheduler\TaskBase.cs:line 176
   at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)
   at System.Threading.ExecutionContext.Run(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-16 21:43:13.8943 DFramework.Scheduler.TaskBase    /* Time Taken: 16114.3834*/
Opportunity Out Of Stock By Outlet 
2026-01-16 21:57:58.4004 DFramework.Database.Query    /* Time Taken: 607*/
[dbo].GenerateSystemAlerts 
2026-01-16 21:58:13.5756 DFramework.Scheduler.TaskBase    /* Time Taken: 15769.4879*/
Opportunity Out Of Stock By Outlet 
2026-01-16 22:12:58.1551 DFramework.Database.NullableDataReader    Data reader open for 304
   at System.Environment.GetStackTrace(Exception e, Boolean needFileInfo)
   at System.Environment.get_StackTrace()
   at DFramework.Database.NullableDataReader.Dispose(Boolean disposing) in C:\CoolR-Group\Framework\DFramework\Database\NullableDataReader.cs:line 33
   at DFramework.Database.NullableDataReader.Dispose() in C:\CoolR-Group\Framework\DFramework\Database\NullableDataReader.cs:line 44
   at CoolR.Tasks.ProcessOutletAlertData.GetAlertDefinitions() in C:\CoolR-Group\portal\CoolR.Tasks\OpportunityOutOfStockByOutlet.cs:line 490
   at CoolR.Tasks.ProcessOutletAlertData.Execute() in C:\CoolR-Group\portal\CoolR.Tasks\OpportunityOutOfStockByOutlet.cs:line 72
   at DFramework.Scheduler.TaskBase.Run() in E:\Forked\Framework\DFramework.Scheduler\TaskBase.cs:line 176
   at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)
   at System.Threading.ExecutionContext.Run(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-16 22:12:58.4834 DFramework.Database.Query    /* Time Taken: 658*/
[dbo].GenerateSystemAlerts 
2026-01-16 22:13:13.7479 DFramework.Scheduler.TaskBase    /* Time Taken: 15920.8664*/
Opportunity Out Of Stock By Outlet 
2026-01-16 22:27:58.4227 DFramework.Database.NullableDataReader    Data reader open for 315
   at System.Environment.GetStackTrace(Exception e, Boolean needFileInfo)
   at System.Environment.get_StackTrace()
   at DFramework.Database.NullableDataReader.Dispose(Boolean disposing) in C:\CoolR-Group\Framework\DFramework\Database\NullableDataReader.cs:line 33
   at DFramework.Database.NullableDataReader.Dispose() in C:\CoolR-Group\Framework\DFramework\Database\NullableDataReader.cs:line 44
   at CoolR.Tasks.ProcessOutletAlertData.GetAlertDefinitions() in C:\CoolR-Group\portal\CoolR.Tasks\OpportunityOutOfStockByOutlet.cs:line 490
   at CoolR.Tasks.ProcessOutletAlertData.Execute() in C:\CoolR-Group\portal\CoolR.Tasks\OpportunityOutOfStockByOutlet.cs:line 72
   at DFramework.Scheduler.TaskBase.Run() in E:\Forked\Framework\DFramework.Scheduler\TaskBase.cs:line 176
   at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)
   at System.Threading.ExecutionContext.Run(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-16 22:28:13.9461 DFramework.Scheduler.TaskBase    /* Time Taken: 16085.9637*/
Opportunity Out Of Stock By Outlet 
2026-01-16 22:32:58.5220 MoveToReorder    Running task for ClientId : 286 and ClientName = India Office QA and Slot: 1/17/2026 12:00:00 PM And LastExecutedOn: 1/17/2026 11:02:58 AM 
2026-01-16 22:32:58.9805 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 C:\CoolR-Group\Framework\DFramework\Database\NullableDataReader.cs:line 33
   at DFramework.Database.NullableDataReader.Dispose() in C:\CoolR-Group\Framework\DFramework\Database\NullableDataReader.cs:line 44
   at CoolR.Tasks.MoveToReorder.Execute() in C:\CoolR-Group\portal\CoolR.Tasks\MoveToReorder.cs:line 44
   at DFramework.Scheduler.TaskBase.Run() in E:\Forked\Framework\DFramework.Scheduler\TaskBase.cs:line 176
   at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)
   at System.Threading.ExecutionContext.Run(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-16 22:32:59.0118 MoveToReorder    Task executed successfully for ClientId : 286 Client Name:India Office QA, Slot: 1/17/2026 12:00:00 PM and Total Order Suggested: 1 Out Of: 1 
2026-01-16 22:42:58.4415 DFramework.Database.Query    /* Time Taken: 562*/
[dbo].GenerateSystemAlerts 
2026-01-16 22:42:58.4571 DFramework.Database.NullableDataReader    Data reader open for 314
   at System.Environment.GetStackTrace(Exception e, Boolean needFileInfo)
   at System.Environment.get_StackTrace()
   at DFramework.Database.NullableDataReader.Dispose(Boolean disposing) in C:\CoolR-Group\Framework\DFramework\Database\NullableDataReader.cs:line 33
   at DFramework.Database.NullableDataReader.Dispose() in C:\CoolR-Group\Framework\DFramework\Database\NullableDataReader.cs:line 44
   at CoolR.Tasks.ProcessOutletAlertData.GetAlertDefinitions() in C:\CoolR-Group\portal\CoolR.Tasks\OpportunityOutOfStockByOutlet.cs:line 490
   at CoolR.Tasks.ProcessOutletAlertData.Execute() in C:\CoolR-Group\portal\CoolR.Tasks\OpportunityOutOfStockByOutlet.cs:line 72
   at DFramework.Scheduler.TaskBase.Run() in E:\Forked\Framework\DFramework.Scheduler\TaskBase.cs:line 176
   at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)
   at System.Threading.ExecutionContext.Run(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-16 22:43:13.9733 DFramework.Scheduler.TaskBase    /* Time Taken: 16094.2889*/
Opportunity Out Of Stock By Outlet 
2026-01-16 22:57:58.2214 DFramework.Database.NullableDataReader    Data reader open for 306
   at System.Environment.GetStackTrace(Exception e, Boolean needFileInfo)
   at System.Environment.get_StackTrace()
   at DFramework.Database.NullableDataReader.Dispose(Boolean disposing) in C:\CoolR-Group\Framework\DFramework\Database\NullableDataReader.cs:line 33
   at DFramework.Database.NullableDataReader.Dispose() in C:\CoolR-Group\Framework\DFramework\Database\NullableDataReader.cs:line 44
   at CoolR.Tasks.ProcessOutletAlertData.GetAlertDefinitions() in C:\CoolR-Group\portal\CoolR.Tasks\OpportunityOutOfStockByOutlet.cs:line 490
   at CoolR.Tasks.ProcessOutletAlertData.Execute() in C:\CoolR-Group\portal\CoolR.Tasks\OpportunityOutOfStockByOutlet.cs:line 72
   at DFramework.Scheduler.TaskBase.Run() in E:\Forked\Framework\DFramework.Scheduler\TaskBase.cs:line 176
   at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)
   at System.Threading.ExecutionContext.Run(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-16 22:57:58.3935 DFramework.Database.Query    /* Time Taken: 501*/
[dbo].GenerateSystemAlerts 
2026-01-16 22:58:13.7626 DFramework.Scheduler.TaskBase    /* Time Taken: 15869.3614*/
Opportunity Out Of Stock By Outlet 
2026-01-16 23:12:58.5014 DFramework.Database.NullableDataReader    Data reader open for 326
   at System.Environment.GetStackTrace(Exception e, Boolean needFileInfo)
   at System.Environment.get_StackTrace()
   at DFramework.Database.NullableDataReader.Dispose(Boolean disposing) in C:\CoolR-Group\Framework\DFramework\Database\NullableDataReader.cs:line 33
   at DFramework.Database.NullableDataReader.Dispose() in C:\CoolR-Group\Framework\DFramework\Database\NullableDataReader.cs:line 44
   at CoolR.Tasks.ProcessOutletAlertData.GetAlertDefinitions() in C:\CoolR-Group\portal\CoolR.Tasks\OpportunityOutOfStockByOutlet.cs:line 490
   at CoolR.Tasks.ProcessOutletAlertData.Execute() in C:\CoolR-Group\portal\CoolR.Tasks\OpportunityOutOfStockByOutlet.cs:line 72
   at DFramework.Scheduler.TaskBase.Run() in E:\Forked\Framework\DFramework.Scheduler\TaskBase.cs:line 176
   at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)
   at System.Threading.ExecutionContext.Run(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-16 23:13:14.0078 DFramework.Scheduler.TaskBase    /* Time Taken: 16084.937*/
Opportunity Out Of Stock By Outlet 
2026-01-16 23:27:58.5038 DFramework.Database.NullableDataReader    Data reader open for 311
   at System.Environment.GetStackTrace(Exception e, Boolean needFileInfo)
   at System.Environment.get_StackTrace()
   at DFramework.Database.NullableDataReader.Dispose(Boolean disposing) in C:\CoolR-Group\Framework\DFramework\Database\NullableDataReader.cs:line 33
   at DFramework.Database.NullableDataReader.Dispose() in C:\CoolR-Group\Framework\DFramework\Database\NullableDataReader.cs:line 44
   at CoolR.Tasks.ProcessOutletAlertData.GetAlertDefinitions() in C:\CoolR-Group\portal\CoolR.Tasks\OpportunityOutOfStockByOutlet.cs:line 490
   at CoolR.Tasks.ProcessOutletAlertData.Execute() in C:\CoolR-Group\portal\CoolR.Tasks\OpportunityOutOfStockByOutlet.cs:line 72
   at DFramework.Scheduler.TaskBase.Run() in E:\Forked\Framework\DFramework.Scheduler\TaskBase.cs:line 176
   at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)
   at System.Threading.ExecutionContext.Run(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-16 23:28:14.0244 DFramework.Scheduler.TaskBase    /* Time Taken: 16084.0877*/
Opportunity Out Of Stock By Outlet 
2026-01-16 23:32:58.6577 MoveToReorder    Running task for ClientId : 286 and ClientName = India Office QA and Slot: 1/17/2026 1:00:00 PM And LastExecutedOn: 1/17/2026 12:02:58 PM 
2026-01-16 23:32:59.2425 MoveToReorder    Task executed successfully for ClientId : 286 Client Name:India Office QA, Slot: 1/17/2026 1:00:00 PM But No Order found to suggest 
2026-01-16 23:42:58.5038 DFramework.Database.Query    /* Time Taken: 555*/
[dbo].GenerateSystemAlerts 
2026-01-16 23:42:58.5350 DFramework.Database.NullableDataReader    Data reader open for 337
   at System.Environment.GetStackTrace(Exception e, Boolean needFileInfo)
   at System.Environment.get_StackTrace()
   at DFramework.Database.NullableDataReader.Dispose(Boolean disposing) in C:\CoolR-Group\Framework\DFramework\Database\NullableDataReader.cs:line 33
   at DFramework.Database.NullableDataReader.Dispose() in C:\CoolR-Group\Framework\DFramework\Database\NullableDataReader.cs:line 44
   at CoolR.Tasks.ProcessOutletAlertData.GetAlertDefinitions() in C:\CoolR-Group\portal\CoolR.Tasks\OpportunityOutOfStockByOutlet.cs:line 490
   at CoolR.Tasks.ProcessOutletAlertData.Execute() in C:\CoolR-Group\portal\CoolR.Tasks\OpportunityOutOfStockByOutlet.cs:line 72
   at DFramework.Scheduler.TaskBase.Run() in E:\Forked\Framework\DFramework.Scheduler\TaskBase.cs:line 176
   at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)
   at System.Threading.ExecutionContext.Run(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-16 23:43:14.2468 DFramework.Scheduler.TaskBase    /* Time Taken: 16290.8715*/
Opportunity Out Of Stock By Outlet 
2026-01-16 23:57:58.3100 DFramework.Database.NullableDataReader    Data reader open for 329
   at System.Environment.GetStackTrace(Exception e, Boolean needFileInfo)
   at System.Environment.get_StackTrace()
   at DFramework.Database.NullableDataReader.Dispose(Boolean disposing) in C:\CoolR-Group\Framework\DFramework\Database\NullableDataReader.cs:line 33
   at DFramework.Database.NullableDataReader.Dispose() in C:\CoolR-Group\Framework\DFramework\Database\NullableDataReader.cs:line 44
   at CoolR.Tasks.ProcessOutletAlertData.GetAlertDefinitions() in C:\CoolR-Group\portal\CoolR.Tasks\OpportunityOutOfStockByOutlet.cs:line 490
   at CoolR.Tasks.ProcessOutletAlertData.Execute() in C:\CoolR-Group\portal\CoolR.Tasks\OpportunityOutOfStockByOutlet.cs:line 72
   at DFramework.Scheduler.TaskBase.Run() in E:\Forked\Framework\DFramework.Scheduler\TaskBase.cs:line 176
   at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)
   at System.Threading.ExecutionContext.Run(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-16 23:57:58.5132 DFramework.Database.Query    /* Time Taken: 548*/
[dbo].GenerateSystemAlerts 
2026-01-16 23:58:13.8626 DFramework.Scheduler.TaskBase    /* Time Taken: 15896.3589*/
Opportunity Out Of Stock By Outlet