2026-01-19 00:03:49.7185 DFramework.Database.Query    /* Time Taken: 543*/
[dbo].GenerateSystemAlerts 
2026-01-19 00:03:59.6280 DFramework.Scheduler.TaskBase    /* Time Taken: 10597.425*/
Opportunity Out Of Stock By Outlet 
2026-01-19 00:18:49.7463 DFramework.Database.Query    /* Time Taken: 558*/
[dbo].GenerateSystemAlerts 
2026-01-19 00:18:49.8558 DFramework.Database.Query    /* Time Taken: 507*/
DECLARE @AlertDefinitionId Int32
SET @AlertDefinitionId = '311'
DECLARE @IsDeleted Boolean
SET @IsDeleted = 'False'
SELECT ProductId FROM AlertDefinitionProduct
 WHERE [AlertDefinitionId] = @AlertDefinitionId AND IsDeleted = @IsDeleted
 
2026-01-19 00:18:49.8558 DFramework.Database.NullableDataReader    Data reader open for 791
   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-19 00:19:00.2843 DFramework.Scheduler.TaskBase    /* Time Taken: 11241.0561*/
Opportunity Out Of Stock By Outlet 
2026-01-19 00:33:49.5429 DFramework.Database.NullableDataReader    Data reader open for 459
   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-19 00:33:49.7461 DFramework.Database.Query    /* Time Taken: 534*/
[dbo].GenerateSystemAlerts 
2026-01-19 00:33:59.9522 DFramework.Scheduler.TaskBase    /* Time Taken: 10894.9087*/
Opportunity Out Of Stock By Outlet 
2026-01-19 00:38:49.5539 MoveToReorder    Running task for ClientId : 286 and ClientName = India Office QA and Slot: 1/19/2026 2:00:00 PM And LastExecutedOn: 1/19/2026 1:04:19 PM 
2026-01-19 00:39:29.9070 DFramework.Database.NullableDataReader    Data reader open for 40058
   at System.Environment.GetStackTrace(Exception e, Boolean needFileInfo)
   at System.Environment.get_StackTrace()
   at DFramework.Database.NullableDataReader.Dispose(Boolean disposing) in 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-19 00:39:29.9320 MoveToReorder    Task executed successfully for ClientId : 286 Client Name:India Office QA, Slot: 1/19/2026 2:00:00 PM and Total Order Suggested: 127 Out Of: 127 
2026-01-19 00:39:31.2674 DFramework.Scheduler.TaskBase    /* Time Taken: 42041.6124*/
Move To Re-Order 
2026-01-19 00:42:37.9320 DFramework.Database.NullableDataReader    Data reader open for 3222451
   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 306
   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-19 00:42:37.9476 DFramework.Database.NullableDataReader    Data reader open for 3222482
   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 306
   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-19 00:42:38.2601 DFramework.Scheduler.TaskBase    /* Time Taken: 3229248.2504*/
Process Alert Record 
2026-01-19 00:42:40.1200 AlertProcessor    ProcessorAlertData: started 
2026-01-19 00:42:40.9098 DFramework.Database.Query    /* Time Taken: 706*/
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-19 00:42:41.0261 DFramework.Database.Query    /* Time Taken: 843*/
DECLARE @OrderStatusId Int32
SET @OrderStatusId = '5486'
DECLARE @CurrentUtcDateTime DateTime2
SET @CurrentUtcDateTime = '1/19/2026 8:42:40 AM'
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-19 00:42:41.0261 DFramework.Database.Query    /* Time Taken: 870*/
DECLARE @TableName AnsiString(8000)
SET @TableName = 'TagAlert'
DECLARE @CurrentRecordId Int32
SET @CurrentRecordId = '0'
dbo.GetValidDeviceForAlertProcessData 
2026-01-19 00:42:41.0261 AlertProcessor    ProcessorAlertData: table: TagAlert, maxRecordId: 3676436, assetId: 87751 
2026-01-19 00:42:41.0261 AlertProcessor    ProcessorAlertData: recordTable: TagAlert, alertTypeId: 48 
2026-01-19 00:42:41.0572 DFramework.Database.Query    /* Time Taken: 936*/
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/19/2026 8:42:40 AM'
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-19 00:42:41.4319 DFramework.Database.Query    /* Time Taken: 1265*/
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-19 00:42:41.4632 DFramework.Database.Query    /* Time Taken: 812*/
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-19 00:42:41.5257 DFramework.Database.Query    /* Time Taken: 840*/
DECLARE @AssetKPIData Object
SET @AssetKPIData = ''
[dbo].BulkUpsertAssetDayKPI 
2026-01-19 00:42:41.5569 DFramework.Database.Query    /* Time Taken: 627*/
DECLARE @AppConfigId Int32
SET @AppConfigId = '1'
SELECT * FROM AppConfig

 WHERE [AppConfigId] = @AppConfigId
 ORDER BY [AppConfigId] 
2026-01-19 00:42:41.6200 DFramework.Database.Query    /* Time Taken: 590*/
DECLARE @OrderStatusId Int32
SET @OrderStatusId = '5484'
DECLARE @CurrentUtcDateTime DateTime2
SET @CurrentUtcDateTime = '1/19/2026 8:42:41 AM'
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-19 00:42:41.6361 DFramework.Database.Query    /* Time Taken: 1424*/
DECLARE @CreatedOn Date
SET @CreatedOn = '1/19/2026 12:00:00 AM'
DECLARE @EventId Int32
SET @EventId = '-12'
SELECT COUNT(1) FROM EmailQueue
 WHERE [CreatedOn] >= @CreatedOn AND [EventId] = @EventId
 
2026-01-19 00:42:41.6511 DFramework.Database.Query    /* Time Taken: 585*/
DECLARE @AlertDefinitionId Int32
SET @AlertDefinitionId = '99'
DECLARE @IsDeleted Boolean
SET @IsDeleted = 'False'
SELECT ProductId FROM AlertDefinitionProduct
 WHERE [AlertDefinitionId] = @AlertDefinitionId AND IsDeleted = @IsDeleted
 
2026-01-19 00:42:41.6823 DFramework.Database.Query    /* Time Taken: 1472*/
[dbo].GenerateSystemAlerts 
2026-01-19 00:42:41.7134 DFramework.Database.NullableDataReader    Data reader open for 647
   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-19 00:42:41.8695 DFramework.Database.Query    /* Time Taken: 844*/
DECLARE @AlertDefinition_IsDeleted Int32
SET @AlertDefinition_IsDeleted = '0'
DECLARE @AlertType_IsDeleted Int32
SET @AlertType_IsDeleted = '0'
DECLARE @AlertDefinition_IsActive Int32
SET @AlertDefinition_IsActive = '1'
DECLARE @AlertType_IsActive Int32
SET @AlertType_IsActive = '1'
DECLARE @AssetId0 Int32
SET @AssetId0 = '0'
DECLARE @AssetId1 Int32
SET @AssetId1 = '87751'
DECLARE @AlertDefinition_ClientId0 Int32
SET @AlertDefinition_ClientId0 = '0'
DECLARE @AlertDefinition_ClientId1 Int32
SET @AlertDefinition_ClientId1 = '286'
DECLARE @AssetModelId0 Int32
SET @AssetModelId0 = '0'
DECLARE @AssetModelId1 Int32
SET @AssetModelId1 = '2795'
DECLARE @MarketId0 Int32
SET @MarketId0 = '0'
DECLARE @MarketId1 Int32
SET @MarketId1 = '200'
DECLARE @ClassificationId0 Int32
SET @ClassificationId0 = '0'
DECLARE @ClassificationId1 Int32
SET @ClassificationId1 = '0'
DECLARE @LocationTypeId0 Int32
SET @LocationTypeId0 = '0'
DECLARE @LocationTypeId1 Int32
SET @LocationTypeId1 = '0'
DECLARE @LocationId0 Int32
SET @LocationId0 = '0'
DECLARE @LocationId1 Int32
SET @LocationId1 = '422576'
DECLARE @AlertDefinition_AlertTypeId Int32
SET @AlertDefinition_AlertTypeId = '48'
SELECT AlertDefinitionId, AlertDefinition.AlertTypeId, Name, AlertBody, TemperatureAbove, TemperatureBelow, MinLight, MaxLight, PowerOffDuration,CombineThreshold,
														MovementDetected, DoorOpenDuration, DisconnectThreshold, AlertAgeThreshold, DoorOpeningLessThan, DoorOpeningGreaterThan, BatteryThreshold, LaneThreshold, ProductCount,
														StockThreshold, PurityThreshold, PlanogramThreshold, NoDataThreshold, BatteryCloseThreshold, GPSThreshold, StartDate, MovementCountThreshold, PriorityId, ColasThreshold, 
														FlavoursThreshold, DataUsageThreshold, IsAlertForAllProduct, OnlyWithUPC, ManufacturerIds, LastImageThreshold, TargetPortfolioThreshold
															FROM AlertDefinition
														INNER JOIN AlertType ON AlertType.AlertTypeId = AlertDefinition.AlertTypeId
 WHERE AlertDefinition.IsDeleted = @AlertDefinition_IsDeleted AND AlertType.IsDeleted = @AlertType_IsDeleted AND AlertDefinition.IsActive = @AlertDefinition_IsActive AND AlertType.IsActive = @AlertType_IsActive AND AssetId IN ( @AssetId0, @AssetId1 ) AND AlertDefinition.ClientId IN ( @AlertDefinition_ClientId0, @AlertDefinition_ClientId1 ) AND AssetModelId IN ( @AssetModelId0, @AssetModelId1 ) AND MarketId IN ( @MarketId0, @MarketId1 ) AND ClassificationId IN ( @ClassificationId0, @ClassificationId1 ) AND LocationTypeId IN ( @LocationTypeId0, @LocationTypeId1 ) AND LocationId IN ( @LocationId0, @LocationId1 ) AND AlertDefinition.AlertTypeId = @AlertDefinition_AlertTypeId
 
2026-01-19 00:42:41.9789 AlertProcessor    ProcessorAlertData: recordTable: TagAlert, alertTypeId: 48, AlertDefinitionCount: 2 
2026-01-19 00:42:41.9789 AlertProcessor    ProcessorAlertData: table: TagAlert, maxRecordId: 3676436, assetId: 118196 
2026-01-19 00:42:41.9789 AlertProcessor    ProcessorAlertData: recordTable: TagAlert, alertTypeId: 48 
2026-01-19 00:42:42.0882 AlertProcessor    ProcessorAlertData: recordTable: TagAlert, alertTypeId: 48, AlertDefinitionCount: 2 
2026-01-19 00:42:42.1507 DFramework.Database.NullableDataReader    Data reader open for 1128
   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-19 00:42:42.4789 AlertProcessor    ProcessorAlertData: table: VoidAlert, maxRecordId: 3676436, assetId: 87751 
2026-01-19 00:42:42.4789 AlertProcessor    ProcessorAlertData: recordTable: VoidAlert, alertTypeId: 49 
2026-01-19 00:42:42.8401 AlertProcessor    ProcessorAlertData: recordTable: VoidAlert, alertTypeId: 49, AlertDefinitionCount: 2 
2026-01-19 00:42:42.8401 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-19 00:42:42.8401 AlertProcessor    ProcessorAlertData: table: VoidAlert, maxRecordId: 3676436, assetId: 118196 
2026-01-19 00:42:42.8401 AlertProcessor    ProcessorAlertData: recordTable: VoidAlert, alertTypeId: 49 
2026-01-19 00:42:43.0572 AlertProcessor    ProcessorAlertData: recordTable: VoidAlert, alertTypeId: 49, AlertDefinitionCount: 2 
2026-01-19 00:42:43.1196 DFramework.Database.NullableDataReader    Data reader open for 640
   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-19 00:42:43.4712 AlertProcessor    ProcessorAlertData: table: OpportunityOutOfStock, maxRecordId: 3676436, assetId: 118196 
2026-01-19 00:42:43.4712 AlertProcessor    ProcessorAlertData: recordTable: OpportunityOutOfStock, alertTypeId: 28 
2026-01-19 00:42:43.7082 AlertProcessor    ProcessorAlertData: recordTable: OpportunityOutOfStock, alertTypeId: 28, AlertDefinitionCount: 2 
2026-01-19 00:42:43.7082 DFramework.Database.NullableDataReader    Data reader open for 220
   at System.Environment.GetStackTrace(Exception e, Boolean needFileInfo)
   at System.Environment.get_StackTrace()
   at DFramework.Database.NullableDataReader.Dispose(Boolean disposing) in 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-19 00:42:43.7243 AlertProcessor    ProcessorAlertData: table: OpportunityOutOfStock, maxRecordId: 3676436, assetId: 87751 
2026-01-19 00:42:43.7243 AlertProcessor    ProcessorAlertData: recordTable: OpportunityOutOfStock, alertTypeId: 28 
2026-01-19 00:42:43.9633 AlertProcessor    ProcessorAlertData: recordTable: OpportunityOutOfStock, alertTypeId: 28, AlertDefinitionCount: 2 
2026-01-19 00:42:43.9633 DFramework.Database.NullableDataReader    Data reader open for 216
   at System.Environment.GetStackTrace(Exception e, Boolean needFileInfo)
   at System.Environment.get_StackTrace()
   at DFramework.Database.NullableDataReader.Dispose(Boolean disposing) in 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-19 00:42:44.0262 DFramework.Database.NullableDataReader    Data reader open for 555
   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-19 00:42:44.3852 AlertProcessor    ProcessorAlertData: table: PlanogramComplianceConsolidate, maxRecordId: 3676436, assetId: 118196 
2026-01-19 00:42:44.4008 AlertProcessor    ProcessorAlertData: recordTable: PlanogramComplianceConsolidate, alertTypeId: 64 
2026-01-19 00:42:44.6664 AlertProcessor    ProcessorAlertData: recordTable: PlanogramComplianceConsolidate, alertTypeId: 64, AlertDefinitionCount: 2 
2026-01-19 00:42:44.6664 DFramework.Database.NullableDataReader    Data reader open for 247
   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-19 00:42:44.6664 AlertProcessor    ProcessorAlertData: table: PlanogramComplianceConsolidate, maxRecordId: 3676436, assetId: 87751 
2026-01-19 00:42:44.6820 AlertProcessor    ProcessorAlertData: recordTable: PlanogramComplianceConsolidate, alertTypeId: 64 
2026-01-19 00:42:44.9320 AlertProcessor    ProcessorAlertData: recordTable: PlanogramComplianceConsolidate, alertTypeId: 64, AlertDefinitionCount: 2 
2026-01-19 00:42:44.9476 DFramework.Database.NullableDataReader    Data reader open for 235
   at System.Environment.GetStackTrace(Exception e, Boolean needFileInfo)
   at System.Environment.get_StackTrace()
   at DFramework.Database.NullableDataReader.Dispose(Boolean disposing) in 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-19 00:42:45.0101 DFramework.Database.NullableDataReader    Data reader open for 626
   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-19 00:42:45.5964 DFramework.Database.Query    /* Time Taken: 587*/
DECLARE @TableName AnsiString(8000)
SET @TableName = 'OpportunityOutOfStockConsolidate'
DECLARE @CurrentRecordId Int32
SET @CurrentRecordId = '3676436'
dbo.GetValidDeviceForAlertProcessData 
2026-01-19 00:42:45.6196 AlertProcessor    ProcessorAlertData: table: OpportunityOutOfStockConsolidate, maxRecordId: 3676436, assetId: 118196 
2026-01-19 00:42:45.6196 AlertProcessor    ProcessorAlertData: recordTable: OpportunityOutOfStockConsolidate, alertTypeId: 44 
2026-01-19 00:42:45.9766 AlertProcessor    ProcessorAlertData: recordTable: OpportunityOutOfStockConsolidate, alertTypeId: 44, AlertDefinitionCount: 2 
2026-01-19 00:42:45.9922 DFramework.Database.NullableDataReader    Data reader open for 343
   at System.Environment.GetStackTrace(Exception e, Boolean needFileInfo)
   at System.Environment.get_StackTrace()
   at DFramework.Database.NullableDataReader.Dispose(Boolean disposing) in 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-19 00:42:45.9922 AlertProcessor    ProcessorAlertData: table: OpportunityOutOfStockConsolidate, maxRecordId: 3676436, assetId: 87751 
2026-01-19 00:42:45.9922 AlertProcessor    ProcessorAlertData: recordTable: OpportunityOutOfStockConsolidate, alertTypeId: 44 
2026-01-19 00:42:46.3539 AlertProcessor    ProcessorAlertData: recordTable: OpportunityOutOfStockConsolidate, alertTypeId: 44, AlertDefinitionCount: 2 
2026-01-19 00:42:46.3539 DFramework.Database.NullableDataReader    Data reader open for 323
   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-19 00:42:46.4008 DFramework.Database.NullableDataReader    Data reader open for 801
   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-19 00:42:47.0414 DFramework.Database.Query    /* Time Taken: 637*/
DECLARE @TableName AnsiString(8000)
SET @TableName = 'AssetStockProductWiseConsolidate'
DECLARE @CurrentRecordId Int32
SET @CurrentRecordId = '3676436'
dbo.GetValidDeviceForAlertProcessData 
2026-01-19 00:42:47.0414 AlertProcessor    ProcessorAlertData: table: AssetStockProductWiseConsolidate, maxRecordId: 3676436, assetId: 87751 
2026-01-19 00:42:47.0414 AlertProcessor    ProcessorAlertData: recordTable: AssetStockProductWiseConsolidate, alertTypeId: 41 
2026-01-19 00:42:47.0727 AlertProcessor    ProcessorAlertData: recordTable: AssetStockProductWiseConsolidate, alertTypeId: 41, AlertDefinitionCount: 1 
2026-01-19 00:42:47.0727 AlertProcessor    ProcessorAlertData: table: AssetStockProductWiseConsolidate, maxRecordId: 3676436, assetId: 118196 
2026-01-19 00:42:47.0727 AlertProcessor    ProcessorAlertData: recordTable: AssetStockProductWiseConsolidate, alertTypeId: 41 
2026-01-19 00:42:47.1039 AlertProcessor    ProcessorAlertData: recordTable: AssetStockProductWiseConsolidate, alertTypeId: 41, AlertDefinitionCount: 1 
2026-01-19 00:42:47.5102 AlertProcessor    ProcessorAlertData: table: AssetStockProductWise, maxRecordId: 3676436, assetId: 118196 
2026-01-19 00:42:47.5102 AlertProcessor    ProcessorAlertData: recordTable: AssetStockProductWise, alertTypeId: 21 
2026-01-19 00:42:52.1180 DFramework.Scheduler.TaskBase    /* Time Taken: 12006.0654*/
Opportunity Out Of Stock By Outlet 
2026-01-19 00:57:40.8094 DFramework.Database.Query    /* Time Taken: 580*/
[dbo].GenerateSystemAlerts 
2026-01-19 00:57:50.7072 DFramework.Scheduler.TaskBase    /* Time Taken: 10573.4873*/
Opportunity Out Of Stock By Outlet 
2026-01-19 01:02:39.1599 DFramework.Database.NullableDataReader    Data reader open for 1191620
   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 306
   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-19 01:02:39.1599 DFramework.Database.NullableDataReader    Data reader open for 1191651
   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 306
   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-19 01:02:39.4255 DFramework.Scheduler.TaskBase    /* Time Taken: 1199313.5982*/
Process Alert Record 
2026-01-19 01:04:55.7654 AlertProcessor    ProcessorAlertData: started 
2026-01-19 01:04:56.4689 DFramework.Database.Query    /* Time Taken: 667*/
DECLARE @OrderStatusId Int32
SET @OrderStatusId = '5486'
DECLARE @CurrentUtcDateTime DateTime2
SET @CurrentUtcDateTime = '1/19/2026 9:04:55 AM'
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-19 01:04:56.5470 DFramework.Database.Query    /* Time Taken: 711*/
DECLARE @CreatedOn Date
SET @CreatedOn = '1/19/2026 12:00:00 AM'
DECLARE @EventId Int32
SET @EventId = '-12'
SELECT COUNT(1) FROM EmailQueue
 WHERE [CreatedOn] >= @CreatedOn AND [EventId] = @EventId
 
2026-01-19 01:04:56.5783 DFramework.Database.Query    /* Time Taken: 744*/
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/19/2026 9:04:55 AM'
SELECT TOP 1 AlertDefinitionId, PriorityId FROM AlertDefinition
 WHERE AlertDefinition.IsActive = @AlertDefinition_IsActive AND AlertDefinition.ClientId = @AlertDefinition_ClientId AND AlertDefinition.AlertTypeId = @AlertDefinition_AlertTypeId AND AlertDefinition.IsDeleted = @AlertDefinition_IsDeleted AND AlertDefinition.StartDate <= @AlertDefinition_StartDate
 
2026-01-19 01:04:56.6408 DFramework.Database.Query    /* Time Taken: 799*/
[dbo].GenerateSystemAlerts 
2026-01-19 01:04:56.6720 DFramework.Database.Query    /* Time Taken: 894*/
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/19/2026 9:04:55 AM'
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-19 01:04:56.6720 DFramework.Database.Query    /* Time Taken: 835*/
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-19 01:04:56.7814 DFramework.Database.Query    /* Time Taken: 994*/
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-19 01:04:57.0314 DFramework.Database.Query    /* Time Taken: 721*/
DECLARE @AssetKPIData Object
SET @AssetKPIData = ''
[dbo].BulkUpsertAssetDayKPI 
2026-01-19 01:04:57.1252 DFramework.Database.Query    /* Time Taken: 1319*/
DECLARE @TableName AnsiString(8000)
SET @TableName = 'TagAlert'
DECLARE @CurrentRecordId Int32
SET @CurrentRecordId = '0'
dbo.GetValidDeviceForAlertProcessData 
2026-01-19 01:04:57.1252 AlertProcessor    ProcessorAlertData-7: table: TagAlert, maxRecordId: 3676436, assetId: 87751 
2026-01-19 01:04:57.1252 AlertProcessor    ProcessorAlertData-8: recordTable: TagAlert, alertTypeId: 48 
2026-01-19 01:04:57.2819 DFramework.Database.NullableDataReader    Data reader open for 606
   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 D:\Spraxa\CoolR-Portal\CoolR.Tasks\OpportunityOutOfStockByOutlet.cs:line 490
   at CoolR.Tasks.ProcessOutletAlertData.Execute() in D:\Spraxa\CoolR-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-19 01:04:57.6262 AlertProcessor    ProcessorAlertData-9: recordTable: TagAlert, alertTypeId: 48, AlertDefinitionCount: 2 
2026-01-19 01:04:57.6262 DFramework.Database.NullableDataReader    Data reader open for 475
   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 D:\Spraxa\CoolR-Portal\CoolR.Tasks\ProcessAlertData.cs:line 42
   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-19 01:04:57.6262 AlertProcessor    ProcessorAlertData-7: table: TagAlert, maxRecordId: 3676436, assetId: 118196 
2026-01-19 01:04:57.6262 AlertProcessor    ProcessorAlertData-8: recordTable: TagAlert, alertTypeId: 48 
2026-01-19 01:04:57.7512 AlertProcessor    ProcessorAlertData-9: recordTable: TagAlert, alertTypeId: 48, AlertDefinitionCount: 2 
2026-01-19 01:04:57.7512 AlertProcessor    ProcessorAlertData-10: table: TagAlert, currentRecordId: 3676436 
2026-01-19 01:04:57.7981 DFramework.Database.NullableDataReader    Data reader open for 682
   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 D:\Spraxa\CoolR-Portal\CoolR.Tasks\ProcessAlertData.cs:line 42
   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-19 01:04:58.1278 AlertProcessor    ProcessorAlertData-7: table: VoidAlert, maxRecordId: 3676436, assetId: 87751 
2026-01-19 01:04:58.1278 AlertProcessor    ProcessorAlertData-8: recordTable: VoidAlert, alertTypeId: 49 
2026-01-19 01:04:58.4878 AlertProcessor    ProcessorAlertData-9: recordTable: VoidAlert, alertTypeId: 49, AlertDefinitionCount: 2 
2026-01-19 01:04:58.4878 DFramework.Database.NullableDataReader    Data reader open for 333
   at System.Environment.GetStackTrace(Exception e, Boolean needFileInfo)
   at System.Environment.get_StackTrace()
   at DFramework.Database.NullableDataReader.Dispose(Boolean disposing) in 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 D:\Spraxa\CoolR-Portal\CoolR.Tasks\ProcessAlertData.cs:line 42
   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-19 01:04:58.4878 AlertProcessor    ProcessorAlertData-7: table: VoidAlert, maxRecordId: 3676436, assetId: 118196 
2026-01-19 01:04:58.4878 AlertProcessor    ProcessorAlertData-8: recordTable: VoidAlert, alertTypeId: 49 
2026-01-19 01:04:58.7535 AlertProcessor    ProcessorAlertData-9: recordTable: VoidAlert, alertTypeId: 49, AlertDefinitionCount: 2 
2026-01-19 01:04:58.7535 DFramework.Database.NullableDataReader    Data reader open for 236
   at System.Environment.GetStackTrace(Exception e, Boolean needFileInfo)
   at System.Environment.get_StackTrace()
   at DFramework.Database.NullableDataReader.Dispose(Boolean disposing) in 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 D:\Spraxa\CoolR-Portal\CoolR.Tasks\ProcessAlertData.cs:line 42
   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-19 01:04:58.7535 AlertProcessor    ProcessorAlertData-10: table: VoidAlert, currentRecordId: 3676436 
2026-01-19 01:04:58.8003 DFramework.Database.NullableDataReader    Data reader open for 686
   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 D:\Spraxa\CoolR-Portal\CoolR.Tasks\ProcessAlertData.cs:line 42
   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-19 01:04:59.1909 AlertProcessor    ProcessorAlertData-7: table: OpportunityOutOfStock, maxRecordId: 3676436, assetId: 118196 
2026-01-19 01:04:59.1909 AlertProcessor    ProcessorAlertData-8: recordTable: OpportunityOutOfStock, alertTypeId: 28 
2026-01-19 01:04:59.4256 AlertProcessor    ProcessorAlertData-9: recordTable: OpportunityOutOfStock, alertTypeId: 28, AlertDefinitionCount: 2 
2026-01-19 01:04:59.4256 DFramework.Database.NullableDataReader    Data reader open for 207
   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 D:\Spraxa\CoolR-Portal\CoolR.Tasks\ProcessAlertData.cs:line 42
   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-19 01:04:59.4256 AlertProcessor    ProcessorAlertData-7: table: OpportunityOutOfStock, maxRecordId: 3676436, assetId: 87751 
2026-01-19 01:04:59.4256 AlertProcessor    ProcessorAlertData-8: recordTable: OpportunityOutOfStock, alertTypeId: 28 
2026-01-19 01:04:59.6605 AlertProcessor    ProcessorAlertData-9: recordTable: OpportunityOutOfStock, alertTypeId: 28, AlertDefinitionCount: 2 
2026-01-19 01:04:59.6605 DFramework.Database.NullableDataReader    Data reader open for 205
   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 D:\Spraxa\CoolR-Portal\CoolR.Tasks\ProcessAlertData.cs:line 42
   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-19 01:04:59.6605 AlertProcessor    ProcessorAlertData-10: table: OpportunityOutOfStock, currentRecordId: 3676436 
2026-01-19 01:04:59.7230 DFramework.Database.NullableDataReader    Data reader open for 527
   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 D:\Spraxa\CoolR-Portal\CoolR.Tasks\ProcessAlertData.cs:line 42
   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-19 01:05:00.0866 AlertProcessor    ProcessorAlertData-7: table: PlanogramComplianceConsolidate, maxRecordId: 3676436, assetId: 118196 
2026-01-19 01:05:00.0866 AlertProcessor    ProcessorAlertData-8: recordTable: PlanogramComplianceConsolidate, alertTypeId: 64 
2026-01-19 01:05:00.3379 AlertProcessor    ProcessorAlertData-9: recordTable: PlanogramComplianceConsolidate, alertTypeId: 64, AlertDefinitionCount: 2 
2026-01-19 01:05:00.3535 DFramework.Database.NullableDataReader    Data reader open for 235
   at System.Environment.GetStackTrace(Exception e, Boolean needFileInfo)
   at System.Environment.get_StackTrace()
   at DFramework.Database.NullableDataReader.Dispose(Boolean disposing) in 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 D:\Spraxa\CoolR-Portal\CoolR.Tasks\ProcessAlertData.cs:line 42
   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-19 01:05:00.3535 AlertProcessor    ProcessorAlertData-7: table: PlanogramComplianceConsolidate, maxRecordId: 3676436, assetId: 87751 
2026-01-19 01:05:00.3535 AlertProcessor    ProcessorAlertData-8: recordTable: PlanogramComplianceConsolidate, alertTypeId: 64 
2026-01-19 01:05:00.6041 AlertProcessor    ProcessorAlertData-9: recordTable: PlanogramComplianceConsolidate, alertTypeId: 64, AlertDefinitionCount: 2 
2026-01-19 01:05:00.6041 DFramework.Database.NullableDataReader    Data reader open for 227
   at System.Environment.GetStackTrace(Exception e, Boolean needFileInfo)
   at System.Environment.get_StackTrace()
   at DFramework.Database.NullableDataReader.Dispose(Boolean disposing) in 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 D:\Spraxa\CoolR-Portal\CoolR.Tasks\ProcessAlertData.cs:line 42
   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-19 01:05:00.6041 AlertProcessor    ProcessorAlertData-10: table: PlanogramComplianceConsolidate, currentRecordId: 3676436 
2026-01-19 01:05:00.6510 DFramework.Database.NullableDataReader    Data reader open for 577
   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 D:\Spraxa\CoolR-Portal\CoolR.Tasks\ProcessAlertData.cs:line 42
   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-19 01:05:01.0105 AlertProcessor    ProcessorAlertData-7: table: OpportunityOutOfStockConsolidate, maxRecordId: 3676436, assetId: 118196 
2026-01-19 01:05:01.0105 AlertProcessor    ProcessorAlertData-8: recordTable: OpportunityOutOfStockConsolidate, alertTypeId: 44 
2026-01-19 01:05:01.3862 AlertProcessor    ProcessorAlertData-9: recordTable: OpportunityOutOfStockConsolidate, alertTypeId: 44, AlertDefinitionCount: 2 
2026-01-19 01:05:01.3862 DFramework.Database.NullableDataReader    Data reader open for 340
   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 D:\Spraxa\CoolR-Portal\CoolR.Tasks\ProcessAlertData.cs:line 42
   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-19 01:05:01.3862 AlertProcessor    ProcessorAlertData-7: table: OpportunityOutOfStockConsolidate, maxRecordId: 3676436, assetId: 87751 
2026-01-19 01:05:01.3862 AlertProcessor    ProcessorAlertData-8: recordTable: OpportunityOutOfStockConsolidate, alertTypeId: 44 
2026-01-19 01:05:01.7931 AlertProcessor    ProcessorAlertData-9: recordTable: OpportunityOutOfStockConsolidate, alertTypeId: 44, AlertDefinitionCount: 2 
2026-01-19 01:05:01.7931 DFramework.Database.NullableDataReader    Data reader open for 388
   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 D:\Spraxa\CoolR-Portal\CoolR.Tasks\ProcessAlertData.cs:line 42
   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-19 01:05:01.7931 AlertProcessor    ProcessorAlertData-10: table: OpportunityOutOfStockConsolidate, currentRecordId: 3676436 
2026-01-19 01:05:01.8556 DFramework.Database.NullableDataReader    Data reader open for 844
   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 D:\Spraxa\CoolR-Portal\CoolR.Tasks\ProcessAlertData.cs:line 42
   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-19 01:05:03.1535 DFramework.Database.Query    /* Time Taken: 1301*/
DECLARE @TableName AnsiString(8000)
SET @TableName = 'AssetStockProductWiseConsolidate'
DECLARE @CurrentRecordId Int32
SET @CurrentRecordId = '3676436'
dbo.GetValidDeviceForAlertProcessData 
2026-01-19 01:05:03.1535 AlertProcessor    ProcessorAlertData-7: table: AssetStockProductWiseConsolidate, maxRecordId: 3676436, assetId: 87751 
2026-01-19 01:05:03.1535 AlertProcessor    ProcessorAlertData-8: recordTable: AssetStockProductWiseConsolidate, alertTypeId: 41 
2026-01-19 01:05:03.1847 AlertProcessor    ProcessorAlertData-9: recordTable: AssetStockProductWiseConsolidate, alertTypeId: 41, AlertDefinitionCount: 1 
2026-01-19 01:05:03.1847 AlertProcessor    ProcessorAlertData-7: table: AssetStockProductWiseConsolidate, maxRecordId: 3676436, assetId: 118196 
2026-01-19 01:05:03.1847 AlertProcessor    ProcessorAlertData-8: recordTable: AssetStockProductWiseConsolidate, alertTypeId: 41 
2026-01-19 01:05:03.2160 AlertProcessor    ProcessorAlertData-9: recordTable: AssetStockProductWiseConsolidate, alertTypeId: 41, AlertDefinitionCount: 1 
2026-01-19 01:05:03.2160 AlertProcessor    ProcessorAlertData-10: table: AssetStockProductWiseConsolidate, currentRecordId: 3676436 
2026-01-19 01:05:03.8731 DFramework.Database.Query    /* Time Taken: 602*/
DECLARE @TableName AnsiString(8000)
SET @TableName = 'AssetStockProductWise'
DECLARE @CurrentRecordId Int32
SET @CurrentRecordId = '3676436'
dbo.GetValidDeviceForAlertProcessData 
2026-01-19 01:05:03.8731 AlertProcessor    ProcessorAlertData-7: table: AssetStockProductWise, maxRecordId: 3676436, assetId: 118196 
2026-01-19 01:05:03.8731 AlertProcessor    ProcessorAlertData-8: recordTable: AssetStockProductWise, alertTypeId: 21 
2026-01-19 01:05:07.8017 DFramework.Scheduler.TaskBase    /* Time Taken: 12036.3237*/
Opportunity Out Of Stock By Outlet 
2026-01-19 01:19:56.4214 DFramework.Database.Query    /* Time Taken: 572*/
[dbo].GenerateSystemAlerts 
2026-01-19 01:20:06.4609 DFramework.Scheduler.TaskBase    /* Time Taken: 10680.5567*/
Opportunity Out Of Stock By Outlet 
2026-01-19 01:34:56.1961 DFramework.Database.NullableDataReader    Data reader open for 387
   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 D:\Spraxa\CoolR-Portal\CoolR.Tasks\OpportunityOutOfStockByOutlet.cs:line 490
   at CoolR.Tasks.ProcessOutletAlertData.Execute() in D:\Spraxa\CoolR-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-19 01:34:56.5091 MoveToReorder    Running task for ClientId : 286 and ClientName = India Office QA and Slot: 1/19/2026 3:00:00 PM And LastExecutedOn: 1/19/2026 2:08:49 PM 
2026-01-19 01:34:56.6184 DFramework.Database.Query    /* Time Taken: 754*/
[dbo].GenerateSystemAlerts 
2026-01-19 01:34:56.8216 MoveToReorder    Task executed successfully for ClientId : 286 Client Name:India Office QA, Slot: 1/19/2026 3:00:00 PM But No Order found to suggest 
2026-01-19 01:35:06.6380 DFramework.Scheduler.TaskBase    /* Time Taken: 10848.5118*/
Opportunity Out Of Stock By Outlet 
2026-01-19 01:49:56.1439 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 D:\Spraxa\CoolR-Portal\CoolR.Tasks\OpportunityOutOfStockByOutlet.cs:line 490
   at CoolR.Tasks.ProcessOutletAlertData.Execute() in D:\Spraxa\CoolR-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-19 01:49:56.7856 DFramework.Database.Query    /* Time Taken: 628*/
DECLARE @ClientId Int32
SET @ClientId = '213'
DECLARE @MarketId Int32
SET @MarketId = '0'
DECLARE @ClassificationId Int32
SET @ClassificationId = '0'
DECLARE @LocationId Int32
SET @LocationId = '0'
DECLARE @LocationTypeId Int32
SET @LocationTypeId = '0'
DECLARE @StartDate DateTime2
SET @StartDate = '8/28/2025 12:00:00 AM'
dbo.GetOpportunityOutOfStockDataByOutlet 
2026-01-19 01:49:56.8481 DFramework.Database.Query    /* Time Taken: 972*/
[dbo].GenerateSystemAlerts 
2026-01-19 01:50:06.9934 DFramework.Scheduler.TaskBase    /* Time Taken: 11194.0637*/
Opportunity Out Of Stock By Outlet 
2026-01-19 02:04:56.4423 DFramework.Database.Query    /* Time Taken: 561*/
[dbo].GenerateSystemAlerts 
2026-01-19 02:05:06.3549 DFramework.Scheduler.TaskBase    /* Time Taken: 10538.4282*/
Opportunity Out Of Stock By Outlet 
2026-01-19 02:19:56.6164 DFramework.Database.Query    /* Time Taken: 706*/
[dbo].GenerateSystemAlerts 
2026-01-19 02:20:06.2897 DFramework.Scheduler.TaskBase    /* Time Taken: 10456.2798*/
Opportunity Out Of Stock By Outlet 
2026-01-19 02:34:56.4184 DFramework.Database.NullableDataReader    Data reader open for 548
   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 D:\Spraxa\CoolR-Portal\CoolR.Tasks\OpportunityOutOfStockByOutlet.cs:line 490
   at CoolR.Tasks.ProcessOutletAlertData.Execute() in D:\Spraxa\CoolR-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-19 02:34:56.6377 DFramework.Database.Query    /* Time Taken: 651*/
DECLARE @AssetPurityId Int32
SET @AssetPurityId = '3676436'
DECLARE @AssetId Int32
SET @AssetId = '118196'
DECLARE @StatusId Int32
SET @StatusId = '2'
DECLARE @PurityDateTime Date
SET @PurityDateTime = '1/19/2026 1:25:46 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-19 02:34:56.7314 MoveToReorder    Running task for ClientId : 286 and ClientName = India Office QA and Slot: 1/19/2026 4:00:00 PM And LastExecutedOn: 1/19/2026 3:04:56 PM 
2026-01-19 02:34:56.7627 DFramework.Database.Query    /* Time Taken: 830*/
[dbo].GenerateSystemAlerts 
2026-01-19 02:34:57.4663 DFramework.Database.Query    /* Time Taken: 670*/
DECLARE @OrderStatusId Int32
SET @OrderStatusId = '0'
DECLARE @ClientId Int32
SET @ClientId = '286'
dbo.GetOrderDetailsByClientId 
2026-01-19 02:34:57.4976 MoveToReorder    Task executed successfully for ClientId : 286 Client Name:India Office QA, Slot: 1/19/2026 4:00:00 PM But No Order found to suggest 
2026-01-19 02:35:06.9583 DFramework.Scheduler.TaskBase    /* Time Taken: 11103.0032*/
Opportunity Out Of Stock By Outlet 
2026-01-19 02:49:56.3953 DFramework.Database.NullableDataReader    Data reader open for 498
   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 D:\Spraxa\CoolR-Portal\CoolR.Tasks\OpportunityOutOfStockByOutlet.cs:line 490
   at CoolR.Tasks.ProcessOutletAlertData.Execute() in D:\Spraxa\CoolR-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-19 02:49:56.4578 DFramework.Database.Query    /* Time Taken: 507*/
DECLARE @AssetPurityId Int32
SET @AssetPurityId = '3676436'
DECLARE @AssetId Int32
SET @AssetId = '118196'
DECLARE @StatusId Int32
SET @StatusId = '2'
DECLARE @PurityDateTime Date
SET @PurityDateTime = '1/19/2026 1:25:46 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-19 02:49:56.8181 DFramework.Database.Query    /* Time Taken: 882*/
[dbo].GenerateSystemAlerts 
2026-01-19 02:50:06.9177 DFramework.Scheduler.TaskBase    /* Time Taken: 11038.7739*/
Opportunity Out Of Stock By Outlet 
2026-01-19 03:01:19.0465 DFramework.Database.NullableDataReader    Data reader open for 6975089
   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 D:\Spraxa\CoolR-Portal\CoolR.Tasks\ProcessAlertData.cs:line 301
   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-19 03:01:19.0465 DFramework.Database.NullableDataReader    Data reader open for 6975123
   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 D:\Spraxa\CoolR-Portal\CoolR.Tasks\ProcessAlertData.cs:line 301
   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-19 03:01:19.3433 DFramework.Scheduler.TaskBase    /* Time Taken: 6983577.9582*/
Process Alert Record 
2026-01-19 03:02:19.7035 AlertProcessor    ProcessorAlertData: started 
2026-01-19 03:02:20.5529 DFramework.Database.Query    /* Time Taken: 844*/
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-19 03:02:20.6154 DFramework.Database.Query    /* Time Taken: 862*/
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-19 03:02:20.6466 DFramework.Database.Query    /* Time Taken: 897*/
DECLARE @CreatedOn Date
SET @CreatedOn = '1/19/2026 12:00:00 AM'
DECLARE @EventId Int32
SET @EventId = '-12'
SELECT COUNT(1) FROM EmailQueue
 WHERE [CreatedOn] >= @CreatedOn AND [EventId] = @EventId
 
2026-01-19 03:02:20.6622 DFramework.Database.Query    /* Time Taken: 938*/
DECLARE @OrderStatusId Int32
SET @OrderStatusId = '5486'
DECLARE @CurrentUtcDateTime DateTime2
SET @CurrentUtcDateTime = '1/19/2026 11:02:19 AM'
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-19 03:02:20.6935 DFramework.Database.Query    /* Time Taken: 987*/
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/19/2026 11:02:19 AM'
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-19 03:02:20.9446 DFramework.Database.Query    /* Time Taken: 1201*/
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/19/2026 11:02:19 AM'
SELECT TOP 1 AlertDefinitionId, PriorityId FROM AlertDefinition
 WHERE AlertDefinition.IsActive = @AlertDefinition_IsActive AND AlertDefinition.ClientId = @AlertDefinition_ClientId AND AlertDefinition.AlertTypeId = @AlertDefinition_AlertTypeId AND AlertDefinition.IsDeleted = @AlertDefinition_IsDeleted AND AlertDefinition.StartDate <= @AlertDefinition_StartDate
 
2026-01-19 03:02:20.9759 DFramework.Database.Query    /* Time Taken: 1228*/
DECLARE @TableName AnsiString(8000)
SET @TableName = 'TagAlert'
DECLARE @CurrentRecordId Int32
SET @CurrentRecordId = '0'
dbo.GetValidDeviceForAlertProcessData 
2026-01-19 03:02:20.9759 AlertProcessor    ProcessorAlertData-7: table: TagAlert, maxRecordId: 3676436, assetId: 87751 
2026-01-19 03:02:20.9759 AlertProcessor    ProcessorAlertData-8: recordTable: TagAlert, alertTypeId: 48 
2026-01-19 03:02:21.2102 DFramework.Database.Query    /* Time Taken: 957*/
DECLARE @AssetKPIData Object
SET @AssetKPIData = ''
[dbo].BulkUpsertAssetDayKPI 
2026-01-19 03:02:21.3196 DFramework.Database.NullableDataReader    Data reader open for 615
   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 D:\Spraxa\CoolR-Portal\CoolR.Tasks\OpportunityOutOfStockByOutlet.cs:line 490
   at CoolR.Tasks.ProcessOutletAlertData.Execute() in D:\Spraxa\CoolR-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-19 03:02:21.3326 DFramework.Database.Query    /* Time Taken: 1571*/
[dbo].GenerateSystemAlerts 
2026-01-19 03:02:21.5063 AlertProcessor    ProcessorAlertData-9: recordTable: TagAlert, alertTypeId: 48, AlertDefinitionCount: 2 
2026-01-19 03:02:21.5063 DFramework.Database.NullableDataReader    Data reader open for 355
   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 D:\Spraxa\CoolR-Portal\CoolR.Tasks\ProcessAlertData.cs:line 42
   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-19 03:02:21.5063 AlertProcessor    ProcessorAlertData-7: table: TagAlert, maxRecordId: 3676436, assetId: 118196 
2026-01-19 03:02:21.5063 AlertProcessor    ProcessorAlertData-8: recordTable: TagAlert, alertTypeId: 48 
2026-01-19 03:02:21.6186 AlertProcessor    ProcessorAlertData-9: recordTable: TagAlert, alertTypeId: 48, AlertDefinitionCount: 2 
2026-01-19 03:02:21.6186 AlertProcessor    ProcessorAlertData-10: table: TagAlert, currentRecordId: 3676436 
2026-01-19 03:02:21.6811 DFramework.Database.NullableDataReader    Data reader open for 702
   at System.Environment.GetStackTrace(Exception e, Boolean needFileInfo)
   at System.Environment.get_StackTrace()
   at DFramework.Database.NullableDataReader.Dispose(Boolean disposing) in 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 D:\Spraxa\CoolR-Portal\CoolR.Tasks\ProcessAlertData.cs:line 42
   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-19 03:02:22.0098 AlertProcessor    ProcessorAlertData-7: table: VoidAlert, maxRecordId: 3676436, assetId: 87751 
2026-01-19 03:02:22.0098 AlertProcessor    ProcessorAlertData-8: recordTable: VoidAlert, alertTypeId: 49 
2026-01-19 03:02:22.3692 AlertProcessor    ProcessorAlertData-9: recordTable: VoidAlert, alertTypeId: 49, AlertDefinitionCount: 2 
2026-01-19 03:02:22.3692 DFramework.Database.NullableDataReader    Data reader open for 328
   at System.Environment.GetStackTrace(Exception e, Boolean needFileInfo)
   at System.Environment.get_StackTrace()
   at DFramework.Database.NullableDataReader.Dispose(Boolean disposing) in 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 D:\Spraxa\CoolR-Portal\CoolR.Tasks\ProcessAlertData.cs:line 42
   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-19 03:02:22.3692 AlertProcessor    ProcessorAlertData-7: table: VoidAlert, maxRecordId: 3676436, assetId: 118196 
2026-01-19 03:02:22.3692 AlertProcessor    ProcessorAlertData-8: recordTable: VoidAlert, alertTypeId: 49 
2026-01-19 03:02:22.5879 AlertProcessor    ProcessorAlertData-9: recordTable: VoidAlert, alertTypeId: 49, AlertDefinitionCount: 2 
2026-01-19 03:02:22.5879 AlertProcessor    ProcessorAlertData-10: table: VoidAlert, currentRecordId: 3676436 
2026-01-19 03:02:22.6348 DFramework.Database.NullableDataReader    Data reader open for 633
   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 D:\Spraxa\CoolR-Portal\CoolR.Tasks\ProcessAlertData.cs:line 42
   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-19 03:02:22.9795 AlertProcessor    ProcessorAlertData-7: table: OpportunityOutOfStock, maxRecordId: 3676436, assetId: 118196 
2026-01-19 03:02:22.9795 AlertProcessor    ProcessorAlertData-8: recordTable: OpportunityOutOfStock, alertTypeId: 28 
2026-01-19 03:02:23.2139 AlertProcessor    ProcessorAlertData-9: recordTable: OpportunityOutOfStock, alertTypeId: 28, AlertDefinitionCount: 2 
2026-01-19 03:02:23.2139 DFramework.Database.NullableDataReader    Data reader open for 206
   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 D:\Spraxa\CoolR-Portal\CoolR.Tasks\ProcessAlertData.cs:line 42
   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-19 03:02:23.2139 AlertProcessor    ProcessorAlertData-7: table: OpportunityOutOfStock, maxRecordId: 3676436, assetId: 87751 
2026-01-19 03:02:23.2139 AlertProcessor    ProcessorAlertData-8: recordTable: OpportunityOutOfStock, alertTypeId: 28 
2026-01-19 03:02:23.4483 AlertProcessor    ProcessorAlertData-9: recordTable: OpportunityOutOfStock, alertTypeId: 28, AlertDefinitionCount: 2 
2026-01-19 03:02:23.4483 DFramework.Database.NullableDataReader    Data reader open for 202
   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 D:\Spraxa\CoolR-Portal\CoolR.Tasks\ProcessAlertData.cs:line 42
   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-19 03:02:23.4483 AlertProcessor    ProcessorAlertData-10: table: OpportunityOutOfStock, currentRecordId: 3676436 
2026-01-19 03:02:23.5012 DFramework.Database.NullableDataReader    Data reader open for 522
   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 D:\Spraxa\CoolR-Portal\CoolR.Tasks\ProcessAlertData.cs:line 42
   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-19 03:02:23.8236 AlertProcessor    ProcessorAlertData-7: table: PlanogramComplianceConsolidate, maxRecordId: 3676436, assetId: 118196 
2026-01-19 03:02:23.8236 AlertProcessor    ProcessorAlertData-8: recordTable: PlanogramComplianceConsolidate, alertTypeId: 64 
2026-01-19 03:02:24.0737 AlertProcessor    ProcessorAlertData-9: recordTable: PlanogramComplianceConsolidate, alertTypeId: 64, AlertDefinitionCount: 2 
2026-01-19 03:02:24.0737 DFramework.Database.NullableDataReader    Data reader open for 227
   at System.Environment.GetStackTrace(Exception e, Boolean needFileInfo)
   at System.Environment.get_StackTrace()
   at DFramework.Database.NullableDataReader.Dispose(Boolean disposing) in 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 D:\Spraxa\CoolR-Portal\CoolR.Tasks\ProcessAlertData.cs:line 42
   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-19 03:02:24.0737 AlertProcessor    ProcessorAlertData-7: table: PlanogramComplianceConsolidate, maxRecordId: 3676436, assetId: 87751 
2026-01-19 03:02:24.0737 AlertProcessor    ProcessorAlertData-8: recordTable: PlanogramComplianceConsolidate, alertTypeId: 64 
2026-01-19 03:02:24.3237 AlertProcessor    ProcessorAlertData-9: recordTable: PlanogramComplianceConsolidate, alertTypeId: 64, AlertDefinitionCount: 2 
2026-01-19 03:02:24.3237 DFramework.Database.NullableDataReader    Data reader open for 224
   at System.Environment.GetStackTrace(Exception e, Boolean needFileInfo)
   at System.Environment.get_StackTrace()
   at DFramework.Database.NullableDataReader.Dispose(Boolean disposing) in 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 D:\Spraxa\CoolR-Portal\CoolR.Tasks\ProcessAlertData.cs:line 42
   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-19 03:02:24.3237 AlertProcessor    ProcessorAlertData-10: table: PlanogramComplianceConsolidate, currentRecordId: 3676436 
2026-01-19 03:02:24.3862 DFramework.Database.NullableDataReader    Data reader open for 565
   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 D:\Spraxa\CoolR-Portal\CoolR.Tasks\ProcessAlertData.cs:line 42
   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-19 03:02:24.7296 AlertProcessor    ProcessorAlertData-7: table: OpportunityOutOfStockConsolidate, maxRecordId: 3676436, assetId: 118196 
2026-01-19 03:02:24.7296 AlertProcessor    ProcessorAlertData-8: recordTable: OpportunityOutOfStockConsolidate, alertTypeId: 44 
2026-01-19 03:02:25.0899 AlertProcessor    ProcessorAlertData-9: recordTable: OpportunityOutOfStockConsolidate, alertTypeId: 44, AlertDefinitionCount: 2 
2026-01-19 03:02:25.0899 DFramework.Database.NullableDataReader    Data reader open for 334
   at System.Environment.GetStackTrace(Exception e, Boolean needFileInfo)
   at System.Environment.get_StackTrace()
   at DFramework.Database.NullableDataReader.Dispose(Boolean disposing) in 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 D:\Spraxa\CoolR-Portal\CoolR.Tasks\ProcessAlertData.cs:line 42
   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-19 03:02:25.0899 AlertProcessor    ProcessorAlertData-7: table: OpportunityOutOfStockConsolidate, maxRecordId: 3676436, assetId: 87751 
2026-01-19 03:02:25.0899 AlertProcessor    ProcessorAlertData-8: recordTable: OpportunityOutOfStockConsolidate, alertTypeId: 44 
2026-01-19 03:02:25.4214 AlertProcessor    ProcessorAlertData-9: recordTable: OpportunityOutOfStockConsolidate, alertTypeId: 44, AlertDefinitionCount: 2 
2026-01-19 03:02:25.4371 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.ProcessAlertData.Execute() in D:\Spraxa\CoolR-Portal\CoolR.Tasks\ProcessAlertData.cs:line 42
   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-19 03:02:25.4371 AlertProcessor    ProcessorAlertData-10: table: OpportunityOutOfStockConsolidate, currentRecordId: 3676436 
2026-01-19 03:02:25.4848 DFramework.Database.NullableDataReader    Data reader open for 764
   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 D:\Spraxa\CoolR-Portal\CoolR.Tasks\ProcessAlertData.cs:line 42
   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-19 03:02:26.8148 DFramework.Database.Query    /* Time Taken: 1324*/
DECLARE @TableName AnsiString(8000)
SET @TableName = 'AssetStockProductWiseConsolidate'
DECLARE @CurrentRecordId Int32
SET @CurrentRecordId = '3676436'
dbo.GetValidDeviceForAlertProcessData 
2026-01-19 03:02:26.8148 AlertProcessor    ProcessorAlertData-7: table: AssetStockProductWiseConsolidate, maxRecordId: 3676436, assetId: 87751 
2026-01-19 03:02:26.8148 AlertProcessor    ProcessorAlertData-8: recordTable: AssetStockProductWiseConsolidate, alertTypeId: 41 
2026-01-19 03:02:26.8460 AlertProcessor    ProcessorAlertData-9: recordTable: AssetStockProductWiseConsolidate, alertTypeId: 41, AlertDefinitionCount: 1 
2026-01-19 03:02:26.8460 AlertProcessor    ProcessorAlertData-7: table: AssetStockProductWiseConsolidate, maxRecordId: 3676436, assetId: 118196 
2026-01-19 03:02:26.8460 AlertProcessor    ProcessorAlertData-8: recordTable: AssetStockProductWiseConsolidate, alertTypeId: 41 
2026-01-19 03:02:26.8777 AlertProcessor    ProcessorAlertData-9: recordTable: AssetStockProductWiseConsolidate, alertTypeId: 41, AlertDefinitionCount: 1 
2026-01-19 03:02:26.8777 AlertProcessor    ProcessorAlertData-10: table: AssetStockProductWiseConsolidate, currentRecordId: 3676436 
2026-01-19 03:02:27.2846 AlertProcessor    ProcessorAlertData-10: table: AssetStockProductWise, currentRecordId: 3676436 
2026-01-19 03:02:27.6600 AlertProcessor    ProcessorAlertData-10: table: AssetStock, currentRecordId: 3676436 
2026-01-19 03:02:28.0361 AlertProcessor    ProcessorAlertData-10: table: AssetPurity, currentRecordId: 3676436 
2026-01-19 03:02:28.4276 AlertProcessor    ProcessorAlertData-10: table: OpportunityLowStock, currentRecordId: 3676436 
2026-01-19 03:02:28.8031 AlertProcessor    ProcessorAlertData-10: table: AssetStockProductCategoryWise, currentRecordId: 3676436 
2026-01-19 03:02:29.2100 AlertProcessor    ProcessorAlertData-10: table: LowInventoryConsolidate, currentRecordId: 3676436 
2026-01-19 03:02:29.5694 AlertProcessor    ProcessorAlertData-10: table: TargetPortfolioComplianceConsolidate, currentRecordId: 3676436 
2026-01-19 03:02:30.2284 DFramework.Database.Query    /* Time Taken: 594*/
DECLARE @TableName AnsiString(8000)
SET @TableName = 'ProductStockLevel'
DECLARE @CurrentRecordId Int32
SET @CurrentRecordId = '3676436'
dbo.GetValidDeviceForAlertProcessData 
2026-01-19 03:02:30.2284 AlertProcessor    ProcessorAlertData-10: table: ProductStockLevel, currentRecordId: 3676436 
2026-01-19 03:02:30.2764 AlertProcessor    ProcessorAlertData-11: Updating LastProcessedImageId 
2026-01-19 03:02:30.2764 AlertProcessor    ProcessorAlertData-11: Updating LastProcessedImageId, AssetId: 87751 
2026-01-19 03:02:30.3111 AlertProcessor    ProcessorAlertData-11: Updating LastProcessedImageId, AssetId: 118196 
2026-01-19 03:02:30.3378 AlertProcessor    ProcessorAlertData: Stopped 
2026-01-19 03:02:30.3378 AlertProcessor    ProcessorAlertData: Alerts Generated: 2 
2026-01-19 03:02:30.5125 AlertProcessor    ProcessorAlertData: Alerts Generated: 2, Bulk Insert Completed!!! 
2026-01-19 03:02:30.5125 DFramework.Scheduler.TaskBase    /* Time Taken: 10824.6671*/
Process Alert Record 
2026-01-19 03:02:31.8261 DFramework.Scheduler.TaskBase    /* Time Taken: 12138.1749*/
Opportunity Out Of Stock By Outlet 
2026-01-19 03:02:40.0294 AlertProcessor    ProcessorAlertData: started 
2026-01-19 03:02:40.5976 DFramework.Database.Query    /* Time Taken: 522*/
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-19 03:02:40.6601 DFramework.Database.Query    /* Time Taken: 549*/
DECLARE @CreatedOn Date
SET @CreatedOn = '1/19/2026 12:00:00 AM'
DECLARE @EventId Int32
SET @EventId = '-12'
SELECT COUNT(1) FROM EmailQueue
 WHERE [CreatedOn] >= @CreatedOn AND [EventId] = @EventId
 
2026-01-19 03:02:41.1300 DFramework.Database.Query    /* Time Taken: 1014*/
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-19 03:02:41.2238 DFramework.Database.Query    /* Time Taken: 1149*/
DECLARE @OrderStatusId Int32
SET @OrderStatusId = '5486'
DECLARE @CurrentUtcDateTime DateTime2
SET @CurrentUtcDateTime = '1/19/2026 11:02:40 AM'
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-19 03:02:41.2550 DFramework.Database.Query    /* Time Taken: 1136*/
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/19/2026 11:02:40 AM'
SELECT TOP 1 AlertDefinitionId, PriorityId FROM AlertDefinition
 WHERE AlertDefinition.IsActive = @AlertDefinition_IsActive AND AlertDefinition.ClientId = @AlertDefinition_ClientId AND AlertDefinition.AlertTypeId = @AlertDefinition_AlertTypeId AND AlertDefinition.IsDeleted = @AlertDefinition_IsDeleted AND AlertDefinition.StartDate <= @AlertDefinition_StartDate
 
2026-01-19 03:02:41.3175 DFramework.Database.Query    /* Time Taken: 707*/
DECLARE @AssetKPIData Object
SET @AssetKPIData = ''
[dbo].BulkUpsertAssetDayKPI 
2026-01-19 03:02:41.4113 DFramework.Database.Query    /* Time Taken: 1370*/
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/19/2026 11:02:40 AM'
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-19 03:02:41.4425 DFramework.Database.Query    /* Time Taken: 1383*/
DECLARE @TableName AnsiString(8000)
SET @TableName = 'TagAlert'
DECLARE @CurrentRecordId Int32
SET @CurrentRecordId = '0'
dbo.GetValidDeviceForAlertProcessData 
2026-01-19 03:02:41.4581 AlertProcessor    ProcessorAlertData-10: table: TagAlert, currentRecordId: 3676436 
2026-01-19 03:02:41.6623 DFramework.Database.NullableDataReader    Data reader open for 238
   at System.Environment.GetStackTrace(Exception e, Boolean needFileInfo)
   at System.Environment.get_StackTrace()
   at DFramework.Database.NullableDataReader.Dispose(Boolean disposing) in 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 D:\Spraxa\CoolR-Portal\CoolR.Tasks\OpportunityOutOfStockByOutlet.cs:line 490
   at CoolR.Tasks.ProcessOutletAlertData.Execute() in D:\Spraxa\CoolR-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-19 03:02:41.6623 DFramework.Database.NullableDataReader    Data reader open for 215
   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 D:\Spraxa\CoolR-Portal\CoolR.Tasks\ProcessAlertData.cs:line 42
   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-19 03:02:41.6779 DFramework.Database.Query    /* Time Taken: 1563*/
[dbo].GenerateSystemAlerts 
2026-01-19 03:02:42.0856 AlertProcessor    ProcessorAlertData-10: table: VoidAlert, currentRecordId: 3676436 
2026-01-19 03:02:42.4919 AlertProcessor    ProcessorAlertData-10: table: OpportunityOutOfStock, currentRecordId: 3676436 
2026-01-19 03:02:42.8677 AlertProcessor    ProcessorAlertData-10: table: PlanogramComplianceConsolidate, currentRecordId: 3676436 
2026-01-19 03:02:43.2755 AlertProcessor    ProcessorAlertData-10: table: OpportunityOutOfStockConsolidate, currentRecordId: 3676436 
2026-01-19 03:02:43.9154 DFramework.Database.Query    /* Time Taken: 586*/
DECLARE @TableName AnsiString(8000)
SET @TableName = 'AssetStockProductWiseConsolidate'
DECLARE @CurrentRecordId Int32
SET @CurrentRecordId = '3676436'
dbo.GetValidDeviceForAlertProcessData 
2026-01-19 03:02:43.9154 AlertProcessor    ProcessorAlertData-10: table: AssetStockProductWiseConsolidate, currentRecordId: 3676436 
2026-01-19 03:02:44.3069 AlertProcessor    ProcessorAlertData-10: table: AssetStockProductWise, currentRecordId: 3676436 
2026-01-19 03:02:44.6975 AlertProcessor    ProcessorAlertData-10: table: AssetStock, currentRecordId: 3676436 
2026-01-19 03:02:45.0887 AlertProcessor    ProcessorAlertData-10: table: AssetPurity, currentRecordId: 3676436 
2026-01-19 03:02:45.4979 AlertProcessor    ProcessorAlertData-10: table: OpportunityLowStock, currentRecordId: 3676436 
2026-01-19 03:02:46.1243 DFramework.Database.Query    /* Time Taken: 576*/
DECLARE @TableName AnsiString(8000)
SET @TableName = 'AssetStockProductCategoryWise'
DECLARE @CurrentRecordId Int32
SET @CurrentRecordId = '3676436'
dbo.GetValidDeviceForAlertProcessData 
2026-01-19 03:02:46.1243 AlertProcessor    ProcessorAlertData-10: table: AssetStockProductCategoryWise, currentRecordId: 3676436 
2026-01-19 03:02:46.5625 AlertProcessor    ProcessorAlertData-10: table: LowInventoryConsolidate, currentRecordId: 3676436 
2026-01-19 03:02:47.0471 AlertProcessor    ProcessorAlertData-10: table: TargetPortfolioComplianceConsolidate, currentRecordId: 3676436 
2026-01-19 03:02:47.7668 DFramework.Database.Query    /* Time Taken: 651*/
DECLARE @TableName AnsiString(8000)
SET @TableName = 'ProductStockLevel'
DECLARE @CurrentRecordId Int32
SET @CurrentRecordId = '3676436'
dbo.GetValidDeviceForAlertProcessData 
2026-01-19 03:02:47.7668 AlertProcessor    ProcessorAlertData-10: table: ProductStockLevel, currentRecordId: 3676436 
2026-01-19 03:02:47.8141 AlertProcessor    ProcessorAlertData-11: Updating LastProcessedImageId 
2026-01-19 03:02:47.8141 AlertProcessor    ProcessorAlertData: Stopped 
2026-01-19 03:02:52.2153 DFramework.Scheduler.TaskBase    /* Time Taken: 12185.8783*/
Opportunity Out Of Stock By Outlet 
2026-01-19 03:10:35.6001 AlertProcessor    ProcessorAlertData: started 
2026-01-19 03:10:36.6960 DFramework.Database.Query    /* Time Taken: 1008*/
DECLARE @CreatedOn Date
SET @CreatedOn = '1/19/2026 12:00:00 AM'
DECLARE @EventId Int32
SET @EventId = '-12'
SELECT COUNT(1) FROM EmailQueue
 WHERE [CreatedOn] >= @CreatedOn AND [EventId] = @EventId
 
2026-01-19 03:10:36.7181 DFramework.Database.Query    /* Time Taken: 1078*/
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-19 03:10:36.7276 DFramework.Database.Query    /* Time Taken: 1111*/
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/19/2026 11:10:35 AM'
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-19 03:10:36.7493 DFramework.Database.Query    /* Time Taken: 1104*/
DECLARE @TableName AnsiString(8000)
SET @TableName = 'TagAlert'
DECLARE @CurrentRecordId Int32
SET @CurrentRecordId = '0'
dbo.GetValidDeviceForAlertProcessData 
2026-01-19 03:10:36.7493 AlertProcessor    ProcessorAlertData-10: table: TagAlert, currentRecordId: 3676436 
2026-01-19 03:10:36.7750 DFramework.Database.Query    /* Time Taken: 1124*/
DECLARE @OrderStatusId Int32
SET @OrderStatusId = '5486'
DECLARE @CurrentUtcDateTime DateTime2
SET @CurrentUtcDateTime = '1/19/2026 11:10:35 AM'
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-19 03:10:36.8066 DFramework.Database.Query    /* Time Taken: 1110*/
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/19/2026 11:10:35 AM'
SELECT TOP 1 AlertDefinitionId, PriorityId FROM AlertDefinition
 WHERE AlertDefinition.IsActive = @AlertDefinition_IsActive AND AlertDefinition.ClientId = @AlertDefinition_ClientId AND AlertDefinition.AlertTypeId = @AlertDefinition_AlertTypeId AND AlertDefinition.IsDeleted = @AlertDefinition_IsDeleted AND AlertDefinition.StartDate <= @AlertDefinition_StartDate
 
2026-01-19 03:10:36.8227 DFramework.Database.Query    /* Time Taken: 700*/
DECLARE @AppConfigId Int32
SET @AppConfigId = '1'
SELECT * FROM AppConfig

 WHERE [AppConfigId] = @AppConfigId
 ORDER BY [AppConfigId] 
2026-01-19 03:10:36.8861 DFramework.Database.Query    /* Time Taken: 728*/
DECLARE @AssetKPIData Object
SET @AssetKPIData = ''
[dbo].BulkUpsertAssetDayKPI 
2026-01-19 03:10:37.2493 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.ProcessOutletAlertData.GetAlertDefinitions() in D:\Spraxa\CoolR-Portal\CoolR.Tasks\OpportunityOutOfStockByOutlet.cs:line 490
   at CoolR.Tasks.ProcessOutletAlertData.Execute() in D:\Spraxa\CoolR-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-19 03:10:37.4055 DFramework.Database.NullableDataReader    Data reader open for 658
   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 D:\Spraxa\CoolR-Portal\CoolR.Tasks\ProcessAlertData.cs:line 42
   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-19 03:10:37.5461 DFramework.Database.Query    /* Time Taken: 1853*/
[dbo].GenerateSystemAlerts 
2026-01-19 03:10:37.8273 AlertProcessor    ProcessorAlertData-10: table: VoidAlert, currentRecordId: 3676436 
2026-01-19 03:10:38.2493 AlertProcessor    ProcessorAlertData-10: table: OpportunityOutOfStock, currentRecordId: 3676436 
2026-01-19 03:10:38.6399 AlertProcessor    ProcessorAlertData-10: table: PlanogramComplianceConsolidate, currentRecordId: 3676436 
2026-01-19 03:10:39.0461 AlertProcessor    ProcessorAlertData-10: table: OpportunityOutOfStockConsolidate, currentRecordId: 3676436 
2026-01-19 03:10:39.7336 DFramework.Database.Query    /* Time Taken: 632*/
DECLARE @TableName AnsiString(8000)
SET @TableName = 'AssetStockProductWiseConsolidate'
DECLARE @CurrentRecordId Int32
SET @CurrentRecordId = '3676436'
dbo.GetValidDeviceForAlertProcessData 
2026-01-19 03:10:39.7336 AlertProcessor    ProcessorAlertData-10: table: AssetStockProductWiseConsolidate, currentRecordId: 3676436 
2026-01-19 03:10:40.1263 AlertProcessor    ProcessorAlertData-10: table: AssetStockProductWise, currentRecordId: 3676436 
2026-01-19 03:10:40.5658 AlertProcessor    ProcessorAlertData-10: table: AssetStock, currentRecordId: 3676436 
2026-01-19 03:10:40.9681 AlertProcessor    ProcessorAlertData-10: table: AssetPurity, currentRecordId: 3676436 
2026-01-19 03:10:41.3865 AlertProcessor    ProcessorAlertData-10: table: OpportunityLowStock, currentRecordId: 3676436 
2026-01-19 03:10:41.9740 DFramework.Database.Query    /* Time Taken: 541*/
DECLARE @TableName AnsiString(8000)
SET @TableName = 'AssetStockProductCategoryWise'
DECLARE @CurrentRecordId Int32
SET @CurrentRecordId = '3676436'
dbo.GetValidDeviceForAlertProcessData 
2026-01-19 03:10:41.9740 AlertProcessor    ProcessorAlertData-10: table: AssetStockProductCategoryWise, currentRecordId: 3676436 
2026-01-19 03:10:42.3855 AlertProcessor    ProcessorAlertData-10: table: LowInventoryConsolidate, currentRecordId: 3676436 
2026-01-19 03:10:42.7805 AlertProcessor    ProcessorAlertData-10: table: TargetPortfolioComplianceConsolidate, currentRecordId: 3676436 
2026-01-19 03:10:43.4739 DFramework.Database.Query    /* Time Taken: 631*/
DECLARE @TableName AnsiString(8000)
SET @TableName = 'ProductStockLevel'
DECLARE @CurrentRecordId Int32
SET @CurrentRecordId = '3676436'
dbo.GetValidDeviceForAlertProcessData 
2026-01-19 03:10:43.4739 AlertProcessor    ProcessorAlertData-10: table: ProductStockLevel, currentRecordId: 3676436 
2026-01-19 03:10:43.5155 AlertProcessor    ProcessorAlertData-11: Updating LastProcessedImageId 
2026-01-19 03:10:43.5155 AlertProcessor    ProcessorAlertData: Stopped 
2026-01-19 03:10:47.7210 DFramework.Scheduler.TaskBase    /* Time Taken: 12120.9105*/
Opportunity Out Of Stock By Outlet 
2026-01-19 03:10:51.5788 AlertProcessor    ProcessorAlertData: started 
2026-01-19 03:10:52.2824 DFramework.Database.Query    /* Time Taken: 632*/
DECLARE @CreatedOn Date
SET @CreatedOn = '1/19/2026 12:00:00 AM'
DECLARE @EventId Int32
SET @EventId = '-12'
SELECT COUNT(1) FROM EmailQueue
 WHERE [CreatedOn] >= @CreatedOn AND [EventId] = @EventId
 
2026-01-19 03:10:52.3293 DFramework.Database.Query    /* Time Taken: 729*/
DECLARE @OrderStatusId Int32
SET @OrderStatusId = '5486'
DECLARE @CurrentUtcDateTime DateTime2
SET @CurrentUtcDateTime = '1/19/2026 11:10:51 AM'
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-19 03:10:52.3606 DFramework.Database.Query    /* Time Taken: 779*/
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/19/2026 11:10:51 AM'
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-19 03:10:52.5012 DFramework.Database.Query    /* Time Taken: 907*/
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-19 03:10:52.5325 DFramework.Database.Query    /* Time Taken: 878*/
[dbo].GenerateSystemAlerts 
2026-01-19 03:10:52.5637 DFramework.Database.Query    /* Time Taken: 919*/
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/19/2026 11:10:51 AM'
SELECT TOP 1 AlertDefinitionId, PriorityId FROM AlertDefinition
 WHERE AlertDefinition.IsActive = @AlertDefinition_IsActive AND AlertDefinition.ClientId = @AlertDefinition_ClientId AND AlertDefinition.AlertTypeId = @AlertDefinition_AlertTypeId AND AlertDefinition.IsDeleted = @AlertDefinition_IsDeleted AND AlertDefinition.StartDate <= @AlertDefinition_StartDate
 
2026-01-19 03:10:52.6266 DFramework.Database.Query    /* Time Taken: 507*/
DECLARE @AssetKPIData Object
SET @AssetKPIData = ''
[dbo].BulkUpsertAssetDayKPI 
2026-01-19 03:10:52.7530 DFramework.Database.Query    /* Time Taken: 1103*/
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-19 03:10:52.8118 DFramework.Database.NullableDataReader    Data reader open for 433
   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 D:\Spraxa\CoolR-Portal\CoolR.Tasks\OpportunityOutOfStockByOutlet.cs:line 490
   at CoolR.Tasks.ProcessOutletAlertData.Execute() in D:\Spraxa\CoolR-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-19 03:10:52.9115 DFramework.Database.Query    /* Time Taken: 1292*/
DECLARE @TableName AnsiString(8000)
SET @TableName = 'TagAlert'
DECLARE @CurrentRecordId Int32
SET @CurrentRecordId = '0'
dbo.GetValidDeviceForAlertProcessData 
2026-01-19 03:10:52.9115 AlertProcessor    ProcessorAlertData-10: table: TagAlert, currentRecordId: 3676436 
2026-01-19 03:10:53.3547 AlertProcessor    ProcessorAlertData-10: table: VoidAlert, currentRecordId: 3676436 
2026-01-19 03:10:53.7181 AlertProcessor    ProcessorAlertData-10: table: OpportunityOutOfStock, currentRecordId: 3676436 
2026-01-19 03:10:54.1400 AlertProcessor    ProcessorAlertData-10: table: PlanogramComplianceConsolidate, currentRecordId: 3676436 
2026-01-19 03:10:54.5306 AlertProcessor    ProcessorAlertData-10: table: OpportunityOutOfStockConsolidate, currentRecordId: 3676436 
2026-01-19 03:10:55.1894 DFramework.Database.Query    /* Time Taken: 603*/
DECLARE @TableName AnsiString(8000)
SET @TableName = 'AssetStockProductWiseConsolidate'
DECLARE @CurrentRecordId Int32
SET @CurrentRecordId = '3676436'
dbo.GetValidDeviceForAlertProcessData 
2026-01-19 03:10:55.1894 AlertProcessor    ProcessorAlertData-10: table: AssetStockProductWiseConsolidate, currentRecordId: 3676436 
2026-01-19 03:10:55.5853 AlertProcessor    ProcessorAlertData-10: table: AssetStockProductWise, currentRecordId: 3676436 
2026-01-19 03:10:55.9814 AlertProcessor    ProcessorAlertData-10: table: AssetStock, currentRecordId: 3676436 
2026-01-19 03:10:56.3743 AlertProcessor    ProcessorAlertData-10: table: AssetPurity, currentRecordId: 3676436 
2026-01-19 03:10:56.9841 DFramework.Database.Query    /* Time Taken: 555*/
DECLARE @TableName AnsiString(8000)
SET @TableName = 'OpportunityLowStock'
DECLARE @CurrentRecordId Int32
SET @CurrentRecordId = '3676436'
dbo.GetValidDeviceForAlertProcessData 
2026-01-19 03:10:56.9841 AlertProcessor    ProcessorAlertData-10: table: OpportunityLowStock, currentRecordId: 3676436 
2026-01-19 03:10:57.3744 AlertProcessor    ProcessorAlertData-10: table: AssetStockProductCategoryWise, currentRecordId: 3676436 
2026-01-19 03:10:57.7494 AlertProcessor    ProcessorAlertData-10: table: LowInventoryConsolidate, currentRecordId: 3676436 
2026-01-19 03:10:58.1400 AlertProcessor    ProcessorAlertData-10: table: TargetPortfolioComplianceConsolidate, currentRecordId: 3676436 
2026-01-19 03:10:58.7806 DFramework.Database.Query    /* Time Taken: 584*/
DECLARE @TableName AnsiString(8000)
SET @TableName = 'ProductStockLevel'
DECLARE @CurrentRecordId Int32
SET @CurrentRecordId = '3676436'
dbo.GetValidDeviceForAlertProcessData 
2026-01-19 03:10:58.7806 AlertProcessor    ProcessorAlertData-10: table: ProductStockLevel, currentRecordId: 3676436 
2026-01-19 03:10:58.8431 AlertProcessor    ProcessorAlertData-11: Updating LastProcessedImageId 
2026-01-19 03:10:58.8431 AlertProcessor    ProcessorAlertData: Stopped 
2026-01-19 03:11:03.2026 DFramework.Scheduler.TaskBase    /* Time Taken: 11623.8499*/
Opportunity Out Of Stock By Outlet 
2026-01-19 03:12:00.3206 AlertProcessor    ProcessorAlertData: started 
2026-01-19 03:12:01.5349 DFramework.Database.Query    /* Time Taken: 1176*/
DECLARE @OrderStatusId Int32
SET @OrderStatusId = '5486'
DECLARE @CurrentUtcDateTime DateTime2
SET @CurrentUtcDateTime = '1/19/2026 11:12:00 AM'
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-19 03:12:01.6612 DFramework.Database.Query    /* Time Taken: 1316*/
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-19 03:12:01.7086 DFramework.Database.Query    /* Time Taken: 1315*/
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/19/2026 11:12:00 AM'
SELECT TOP 1 AlertDefinitionId, PriorityId FROM AlertDefinition
 WHERE AlertDefinition.IsActive = @AlertDefinition_IsActive AND AlertDefinition.ClientId = @AlertDefinition_ClientId AND AlertDefinition.AlertTypeId = @AlertDefinition_AlertTypeId AND AlertDefinition.IsDeleted = @AlertDefinition_IsDeleted AND AlertDefinition.StartDate <= @AlertDefinition_StartDate
 
2026-01-19 03:12:01.7498 DFramework.Database.Query    /* Time Taken: 1358*/
DECLARE @CreatedOn Date
SET @CreatedOn = '1/19/2026 12:00:00 AM'
DECLARE @EventId Int32
SET @EventId = '-12'
SELECT COUNT(1) FROM EmailQueue
 WHERE [CreatedOn] >= @CreatedOn AND [EventId] = @EventId
 
2026-01-19 03:12:01.7719 DFramework.Database.Query    /* Time Taken: 1426*/
DECLARE @TableName AnsiString(8000)
SET @TableName = 'TagAlert'
DECLARE @CurrentRecordId Int32
SET @CurrentRecordId = '0'
dbo.GetValidDeviceForAlertProcessData 
2026-01-19 03:12:01.7719 AlertProcessor    ProcessorAlertData-10: table: TagAlert, currentRecordId: 3676436 
2026-01-19 03:12:01.7719 DFramework.Database.Query    /* Time Taken: 962*/
DECLARE @AlertDefinitionId Int32
SET @AlertDefinitionId = '99'
DECLARE @IsDeleted Boolean
SET @IsDeleted = 'False'
SELECT ProductId FROM AlertDefinitionProduct
 WHERE [AlertDefinitionId] = @AlertDefinitionId AND IsDeleted = @IsDeleted
 
2026-01-19 03:12:01.7880 DFramework.Database.Query    /* Time Taken: 1399*/
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-19 03:12:01.8197 DFramework.Database.Query    /* Time Taken: 1422*/
[dbo].GenerateSystemAlerts 
2026-01-19 03:12:01.8751 DFramework.Database.NullableDataReader    Data reader open for 1061
   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 D:\Spraxa\CoolR-Portal\CoolR.Tasks\OpportunityOutOfStockByOutlet.cs:line 490
   at CoolR.Tasks.ProcessOutletAlertData.Execute() in D:\Spraxa\CoolR-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-19 03:12:02.0732 DFramework.Database.Query    /* Time Taken: 1211*/
DECLARE @AssetKPIData Object
SET @AssetKPIData = ''
[dbo].BulkUpsertAssetDayKPI 
2026-01-19 03:12:02.5157 DFramework.Database.Query    /* Time Taken: 628*/
DECLARE @TableName AnsiString(8000)
SET @TableName = 'VoidAlert'
DECLARE @CurrentRecordId Int32
SET @CurrentRecordId = '3676436'
dbo.GetValidDeviceForAlertProcessData 
2026-01-19 03:12:02.5157 AlertProcessor    ProcessorAlertData-10: table: VoidAlert, currentRecordId: 3676436 
2026-01-19 03:12:02.9062 AlertProcessor    ProcessorAlertData-10: table: OpportunityOutOfStock, currentRecordId: 3676436 
2026-01-19 03:12:03.3124 AlertProcessor    ProcessorAlertData-10: table: PlanogramComplianceConsolidate, currentRecordId: 3676436 
2026-01-19 03:12:03.7063 AlertProcessor    ProcessorAlertData-10: table: OpportunityOutOfStockConsolidate, currentRecordId: 3676436 
2026-01-19 03:12:04.3748 DFramework.Database.Query    /* Time Taken: 608*/
DECLARE @TableName AnsiString(8000)
SET @TableName = 'AssetStockProductWiseConsolidate'
DECLARE @CurrentRecordId Int32
SET @CurrentRecordId = '3676436'
dbo.GetValidDeviceForAlertProcessData 
2026-01-19 03:12:04.3748 AlertProcessor    ProcessorAlertData-10: table: AssetStockProductWiseConsolidate, currentRecordId: 3676436 
2026-01-19 03:12:04.7498 AlertProcessor    ProcessorAlertData-10: table: AssetStockProductWise, currentRecordId: 3676436 
2026-01-19 03:12:05.1570 AlertProcessor    ProcessorAlertData-10: table: AssetStock, currentRecordId: 3676436 
2026-01-19 03:12:05.5537 AlertProcessor    ProcessorAlertData-10: table: AssetPurity, currentRecordId: 3676436 
2026-01-19 03:12:05.9374 AlertProcessor    ProcessorAlertData-10: table: OpportunityLowStock, currentRecordId: 3676436 
2026-01-19 03:12:06.3322 AlertProcessor    ProcessorAlertData-10: table: AssetStockProductCategoryWise, currentRecordId: 3676436 
2026-01-19 03:12:06.6911 AlertProcessor    ProcessorAlertData-10: table: LowInventoryConsolidate, currentRecordId: 3676436 
2026-01-19 03:12:07.2813 DFramework.Database.Query    /* Time Taken: 526*/
DECLARE @TableName AnsiString(8000)
SET @TableName = 'TargetPortfolioComplianceConsolidate'
DECLARE @CurrentRecordId Int32
SET @CurrentRecordId = '3676436'
dbo.GetValidDeviceForAlertProcessData 
2026-01-19 03:12:07.2813 AlertProcessor    ProcessorAlertData-10: table: TargetPortfolioComplianceConsolidate, currentRecordId: 3676436 
2026-01-19 03:12:07.9373 DFramework.Database.Query    /* Time Taken: 600*/
DECLARE @TableName AnsiString(8000)
SET @TableName = 'ProductStockLevel'
DECLARE @CurrentRecordId Int32
SET @CurrentRecordId = '3676436'
dbo.GetValidDeviceForAlertProcessData 
2026-01-19 03:12:07.9373 AlertProcessor    ProcessorAlertData-10: table: ProductStockLevel, currentRecordId: 3676436 
2026-01-19 03:12:08.0037 AlertProcessor    ProcessorAlertData-11: Updating LastProcessedImageId 
2026-01-19 03:12:08.0037 AlertProcessor    ProcessorAlertData: Stopped 
2026-01-19 03:12:12.4386 DFramework.Scheduler.TaskBase    /* Time Taken: 12118.5571*/
Opportunity Out Of Stock By Outlet 
2026-01-19 03:12:17.3776 AlertProcessor    ProcessorAlertData: started 
2026-01-19 03:12:17.9267 DFramework.Database.Query    /* Time Taken: 516*/
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-19 03:12:18.0829 DFramework.Database.Query    /* Time Taken: 687*/
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-19 03:12:18.1298 DFramework.Database.Query    /* Time Taken: 734*/
DECLARE @OrderStatusId Int32
SET @OrderStatusId = '5486'
DECLARE @CurrentUtcDateTime DateTime2
SET @CurrentUtcDateTime = '1/19/2026 11:12:17 AM'
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-19 03:12:18.1611 DFramework.Database.Query    /* Time Taken: 744*/
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/19/2026 11:12:17 AM'
SELECT TOP 1 AlertDefinitionId, PriorityId FROM AlertDefinition
 WHERE AlertDefinition.IsActive = @AlertDefinition_IsActive AND AlertDefinition.ClientId = @AlertDefinition_ClientId AND AlertDefinition.AlertTypeId = @AlertDefinition_AlertTypeId AND AlertDefinition.IsDeleted = @AlertDefinition_IsDeleted AND AlertDefinition.StartDate <= @AlertDefinition_StartDate
 
2026-01-19 03:12:18.1923 DFramework.Database.Query    /* Time Taken: 805*/
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/19/2026 11:12:17 AM'
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-19 03:12:18.6485 DFramework.Database.Query    /* Time Taken: 742*/
DECLARE @AssetKPIData Object
SET @AssetKPIData = ''
[dbo].BulkUpsertAssetDayKPI 
2026-01-19 03:12:18.7279 DFramework.Database.Query    /* Time Taken: 601*/
DECLARE @OrderStatusId Int32
SET @OrderStatusId = '5484'
DECLARE @CurrentUtcDateTime DateTime2
SET @CurrentUtcDateTime = '1/19/2026 11:12:18 AM'
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-19 03:12:18.7596 DFramework.Database.Query    /* Time Taken: 600*/
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-19 03:12:18.7752 DFramework.Database.Query    /* Time Taken: 1347*/
DECLARE @TableName AnsiString(8000)
SET @TableName = 'TagAlert'
DECLARE @CurrentRecordId Int32
SET @CurrentRecordId = '0'
dbo.GetValidDeviceForAlertProcessData 
2026-01-19 03:12:18.7752 AlertProcessor    ProcessorAlertData-10: table: TagAlert, currentRecordId: 3676436 
2026-01-19 03:12:18.8437 DFramework.Database.Query    /* Time Taken: 1422*/
[dbo].GenerateSystemAlerts 
2026-01-19 03:12:18.8548 DFramework.Database.Query    /* Time Taken: 659*/
DECLARE @AlertDefinitionId Int32
SET @AlertDefinitionId = '99'
DECLARE @IsDeleted Boolean
SET @IsDeleted = 'False'
SELECT ProductId FROM AlertDefinitionProduct
 WHERE [AlertDefinitionId] = @AlertDefinitionId AND IsDeleted = @IsDeleted
 
2026-01-19 03:12:18.8864 DFramework.Database.Query    /* Time Taken: 928*/
DECLARE @AppConfigId Int32
SET @AppConfigId = '1'
SELECT * FROM AppConfig

 WHERE [AppConfigId] = @AppConfigId
 ORDER BY [AppConfigId] 
2026-01-19 03:12:18.9181 DFramework.Database.NullableDataReader    Data reader open for 710
   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 D:\Spraxa\CoolR-Portal\CoolR.Tasks\OpportunityOutOfStockByOutlet.cs:line 490
   at CoolR.Tasks.ProcessOutletAlertData.Execute() in D:\Spraxa\CoolR-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-19 03:12:19.2033 DFramework.Database.NullableDataReader    Data reader open for 428
   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 D:\Spraxa\CoolR-Portal\CoolR.Tasks\ProcessAlertData.cs:line 42
   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-19 03:12:19.5311 AlertProcessor    ProcessorAlertData-10: table: VoidAlert, currentRecordId: 3676436 
2026-01-19 03:12:19.9061 AlertProcessor    ProcessorAlertData-10: table: OpportunityOutOfStock, currentRecordId: 3676436 
2026-01-19 03:12:20.3125 AlertProcessor    ProcessorAlertData-10: table: PlanogramComplianceConsolidate, currentRecordId: 3676436 
2026-01-19 03:12:20.6874 AlertProcessor    ProcessorAlertData-10: table: OpportunityOutOfStockConsolidate, currentRecordId: 3676436 
2026-01-19 03:12:21.3626 DFramework.Database.Query    /* Time Taken: 622*/
DECLARE @TableName AnsiString(8000)
SET @TableName = 'AssetStockProductWiseConsolidate'
DECLARE @CurrentRecordId Int32
SET @CurrentRecordId = '3676436'
dbo.GetValidDeviceForAlertProcessData 
2026-01-19 03:12:21.3626 AlertProcessor    ProcessorAlertData-10: table: AssetStockProductWiseConsolidate, currentRecordId: 3676436 
2026-01-19 03:12:21.7502 AlertProcessor    ProcessorAlertData-10: table: AssetStockProductWise, currentRecordId: 3676436 
2026-01-19 03:12:22.3871 DFramework.Database.Query    /* Time Taken: 581*/
DECLARE @TableName AnsiString(8000)
SET @TableName = 'AssetStock'
DECLARE @CurrentRecordId Int32
SET @CurrentRecordId = '3676436'
dbo.GetValidDeviceForAlertProcessData 
2026-01-19 03:12:22.3871 AlertProcessor    ProcessorAlertData-10: table: AssetStock, currentRecordId: 3676436 
2026-01-19 03:12:22.7510 AlertProcessor    ProcessorAlertData-10: table: AssetPurity, currentRecordId: 3676436 
2026-01-19 03:12:23.1475 AlertProcessor    ProcessorAlertData-10: table: OpportunityLowStock, currentRecordId: 3676436 
2026-01-19 03:12:23.5428 AlertProcessor    ProcessorAlertData-10: table: AssetStockProductCategoryWise, currentRecordId: 3676436 
2026-01-19 03:12:23.9218 AlertProcessor    ProcessorAlertData-10: table: LowInventoryConsolidate, currentRecordId: 3676436 
2026-01-19 03:12:24.3280 AlertProcessor    ProcessorAlertData-10: table: TargetPortfolioComplianceConsolidate, currentRecordId: 3676436 
2026-01-19 03:12:24.9687 DFramework.Database.Query    /* Time Taken: 579*/
DECLARE @TableName AnsiString(8000)
SET @TableName = 'ProductStockLevel'
DECLARE @CurrentRecordId Int32
SET @CurrentRecordId = '3676436'
dbo.GetValidDeviceForAlertProcessData 
2026-01-19 03:12:24.9687 AlertProcessor    ProcessorAlertData-10: table: ProductStockLevel, currentRecordId: 3676436 
2026-01-19 03:12:25.0312 AlertProcessor    ProcessorAlertData-11: Updating LastProcessedImageId 
2026-01-19 03:12:25.0312 AlertProcessor    ProcessorAlertData: Stopped 
2026-01-19 03:12:29.4199 DFramework.Scheduler.TaskBase    /* Time Taken: 12042.2878*/
Opportunity Out Of Stock By Outlet 
2026-01-19 03:16:03.8895 AlertProcessor    ProcessorAlertData: started 
2026-01-19 03:16:04.5222 DFramework.Database.Query    /* Time Taken: 626*/
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-19 03:16:04.8347 DFramework.Database.Query    /* Time Taken: 888*/
DECLARE @CreatedOn Date
SET @CreatedOn = '1/19/2026 12:00:00 AM'
DECLARE @EventId Int32
SET @EventId = '-12'
SELECT COUNT(1) FROM EmailQueue
 WHERE [CreatedOn] >= @CreatedOn AND [EventId] = @EventId
 
2026-01-19 03:16:04.8660 DFramework.Database.Query    /* Time Taken: 917*/
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/19/2026 11:16:03 AM'
SELECT TOP 1 AlertDefinitionId, PriorityId FROM AlertDefinition
 WHERE AlertDefinition.IsActive = @AlertDefinition_IsActive AND AlertDefinition.ClientId = @AlertDefinition_ClientId AND AlertDefinition.AlertTypeId = @AlertDefinition_AlertTypeId AND AlertDefinition.IsDeleted = @AlertDefinition_IsDeleted AND AlertDefinition.StartDate <= @AlertDefinition_StartDate
 
2026-01-19 03:16:04.9598 DFramework.Database.Query    /* Time Taken: 1054*/
DECLARE @OrderStatusId Int32
SET @OrderStatusId = '5486'
DECLARE @CurrentUtcDateTime DateTime2
SET @CurrentUtcDateTime = '1/19/2026 11:16:03 AM'
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-19 03:16:04.9911 DFramework.Database.Query    /* Time Taken: 582*/
DECLARE @AppConfigId Int32
SET @AppConfigId = '1'
SELECT * FROM AppConfig

 WHERE [AppConfigId] = @AppConfigId
 ORDER BY [AppConfigId] 
2026-01-19 03:16:05.0692 DFramework.Database.Query    /* Time Taken: 659*/
DECLARE @AssetKPIData Object
SET @AssetKPIData = ''
[dbo].BulkUpsertAssetDayKPI 
2026-01-19 03:16:05.0848 DFramework.Database.Query    /* Time Taken: 1163*/
DECLARE @TableName AnsiString(8000)
SET @TableName = 'TagAlert'
DECLARE @CurrentRecordId Int32
SET @CurrentRecordId = '0'
dbo.GetValidDeviceForAlertProcessData 
2026-01-19 03:16:05.0848 AlertProcessor    ProcessorAlertData-10: table: TagAlert, currentRecordId: 3676436 
2026-01-19 03:16:05.1005 DFramework.Database.Query    /* Time Taken: 1209*/
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/19/2026 11:16:03 AM'
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-19 03:16:05.2911 DFramework.Database.Query    /* Time Taken: 1334*/
[dbo].GenerateSystemAlerts 
2026-01-19 03:16:05.3225 DFramework.Database.NullableDataReader    Data reader open for 230
   at System.Environment.GetStackTrace(Exception e, Boolean needFileInfo)
   at System.Environment.get_StackTrace()
   at DFramework.Database.NullableDataReader.Dispose(Boolean disposing) in 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 D:\Spraxa\CoolR-Portal\CoolR.Tasks\ProcessAlertData.cs:line 42
   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-19 03:16:05.3382 DFramework.Database.NullableDataReader    Data reader open for 235
   at System.Environment.GetStackTrace(Exception e, Boolean needFileInfo)
   at System.Environment.get_StackTrace()
   at DFramework.Database.NullableDataReader.Dispose(Boolean disposing) in 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 D:\Spraxa\CoolR-Portal\CoolR.Tasks\OpportunityOutOfStockByOutlet.cs:line 490
   at CoolR.Tasks.ProcessOutletAlertData.Execute() in D:\Spraxa\CoolR-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-19 03:16:05.3538 DFramework.Database.Query    /* Time Taken: 825*/
DECLARE @TemplateId Int32
SET @TemplateId = '71'
DECLARE @EventId Int32
SET @EventId = '32'
DECLARE @IsHtml Boolean
SET @IsHtml = 'False'
DECLARE @Subject AnsiString(8000)
SET @Subject = ''
DECLARE @Body AnsiString(8000)
SET @Body = ''
DECLARE @FromName AnsiString(8000)
SET @FromName = ''
DECLARE @FromEmailAddress AnsiString(8000)
SET @FromEmailAddress = ''
DECLARE @AddlTo AnsiString(8000)
SET @AddlTo = ''
DECLARE @AddlCc AnsiString(8000)
SET @AddlCc = ''
DECLARE @AddlBcc AnsiString(8000)
SET @AddlBcc = ''
DECLARE @Tags String(4000)
SET @Tags = '{"EventTime":"01/19/2026 16:43:10","Asset":"Dev test 1000","ImageId":"3676462","Location":"SH test outlet 2","AlertType":"New Stitched Image Alert","imageName":"r6imtdih5lual.jpg","UniqueGuid":"hi2a2iq0cw1gq","AlertId":"13786525"}'
DECLARE @StatusId Byte
SET @StatusId = '0'
INSERT INTO EmailQueue (TemplateId,EventId,IsHtml,Subject,Body,FromName,FromEmailAddress,AddlTo,AddlCc,AddlBcc,Tags,StatusId) VALUES (@TemplateId,@EventId,@IsHtml,@Subject,@Body,@FromName,@FromEmailAddress,@AddlTo,@AddlCc,@AddlBcc,@Tags,@StatusId)

;

SELECT NewId = SCOPE_IDENTITY()

 
2026-01-19 03:16:05.8921 DFramework.Database.Query    /* Time Taken: 570*/
DECLARE @TableName AnsiString(8000)
SET @TableName = 'VoidAlert'
DECLARE @CurrentRecordId Int32
SET @CurrentRecordId = '3676436'
dbo.GetValidDeviceForAlertProcessData 
2026-01-19 03:16:05.8921 AlertProcessor    ProcessorAlertData-10: table: VoidAlert, currentRecordId: 3676436 
2026-01-19 03:16:06.3080 AlertProcessor    ProcessorAlertData-10: table: OpportunityOutOfStock, currentRecordId: 3676436 
2026-01-19 03:16:06.7155 AlertProcessor    ProcessorAlertData-10: table: PlanogramComplianceConsolidate, currentRecordId: 3676436 
2026-01-19 03:16:07.1219 AlertProcessor    ProcessorAlertData-10: table: OpportunityOutOfStockConsolidate, currentRecordId: 3676436 
2026-01-19 03:16:08.0448 DFramework.Database.Query    /* Time Taken: 869*/
DECLARE @TableName AnsiString(8000)
SET @TableName = 'AssetStockProductWiseConsolidate'
DECLARE @CurrentRecordId Int32
SET @CurrentRecordId = '3676436'
dbo.GetValidDeviceForAlertProcessData 
2026-01-19 03:16:08.0448 AlertProcessor    ProcessorAlertData-10: table: AssetStockProductWiseConsolidate, currentRecordId: 3676436 
2026-01-19 03:16:08.4986 AlertProcessor    ProcessorAlertData-10: table: AssetStockProductWise, currentRecordId: 3676436 
2026-01-19 03:16:08.9519 AlertProcessor    ProcessorAlertData-10: table: AssetStock, currentRecordId: 3676436 
2026-01-19 03:16:09.4121 AlertProcessor    ProcessorAlertData-10: table: AssetPurity, currentRecordId: 3676436 
2026-01-19 03:16:09.8436 AlertProcessor    ProcessorAlertData-10: table: OpportunityLowStock, currentRecordId: 3676436 
2026-01-19 03:16:10.2806 AlertProcessor    ProcessorAlertData-10: table: AssetStockProductCategoryWise, currentRecordId: 3676436 
2026-01-19 03:16:10.8349 DFramework.Database.Query    /* Time Taken: 511*/
DECLARE @TableName AnsiString(8000)
SET @TableName = 'LowInventoryConsolidate'
DECLARE @CurrentRecordId Int32
SET @CurrentRecordId = '3676436'
dbo.GetValidDeviceForAlertProcessData 
2026-01-19 03:16:10.8349 AlertProcessor    ProcessorAlertData-10: table: LowInventoryConsolidate, currentRecordId: 3676436 
2026-01-19 03:16:11.2886 AlertProcessor    ProcessorAlertData-10: table: TargetPortfolioComplianceConsolidate, currentRecordId: 3676436 
2026-01-19 03:16:11.9939 DFramework.Database.Query    /* Time Taken: 649*/
DECLARE @TableName AnsiString(8000)
SET @TableName = 'ProductStockLevel'
DECLARE @CurrentRecordId Int32
SET @CurrentRecordId = '3676436'
dbo.GetValidDeviceForAlertProcessData 
2026-01-19 03:16:11.9939 AlertProcessor    ProcessorAlertData-10: table: ProductStockLevel, currentRecordId: 3676436 
2026-01-19 03:16:12.0415 AlertProcessor    ProcessorAlertData-11: Updating LastProcessedImageId 
2026-01-19 03:16:12.0415 AlertProcessor    ProcessorAlertData: Stopped 
2026-01-19 03:16:15.8316 DFramework.Scheduler.TaskBase    /* Time Taken: 11947.3742*/
Opportunity Out Of Stock By Outlet 
2026-01-19 03:16:50.5850 AlertProcessor    ProcessorAlertData: started 
2026-01-19 03:16:51.2263 DFramework.Database.Query    /* Time Taken: 625*/
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-19 03:16:51.2575 DFramework.Database.Query    /* Time Taken: 647*/
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/19/2026 11:16:50 AM'
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-19 03:16:51.8364 DFramework.Database.Query    /* Time Taken: 1208*/
DECLARE @TableName AnsiString(8000)
SET @TableName = 'TagAlert'
DECLARE @CurrentRecordId Int32
SET @CurrentRecordId = '0'
dbo.GetValidDeviceForAlertProcessData 
2026-01-19 03:16:51.8364 AlertProcessor    ProcessorAlertData-10: table: TagAlert, currentRecordId: 3676436 
2026-01-19 03:16:51.8677 DFramework.Database.Query    /* Time Taken: 1271*/
DECLARE @OrderStatusId Int32
SET @OrderStatusId = '5486'
DECLARE @CurrentUtcDateTime DateTime2
SET @CurrentUtcDateTime = '1/19/2026 11:16:50 AM'
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-19 03:16:51.9302 DFramework.Database.Query    /* Time Taken: 816*/
DECLARE @AssetKPIData Object
SET @AssetKPIData = ''
[dbo].BulkUpsertAssetDayKPI 
2026-01-19 03:16:51.9614 DFramework.Database.Query    /* Time Taken: 823*/
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-19 03:16:51.9927 DFramework.Database.Query    /* Time Taken: 731*/
DECLARE @AlertDefinitionId Int32
SET @AlertDefinitionId = '99'
DECLARE @IsDeleted Boolean
SET @IsDeleted = 'False'
SELECT ProductId FROM AlertDefinitionProduct
 WHERE [AlertDefinitionId] = @AlertDefinitionId AND IsDeleted = @IsDeleted
 
2026-01-19 03:16:52.1025 DFramework.Database.Query    /* Time Taken: 1019*/
DECLARE @AppConfigId Int32
SET @AppConfigId = '1'
SELECT * FROM AppConfig

 WHERE [AppConfigId] = @AppConfigId
 ORDER BY [AppConfigId] 
2026-01-19 03:16:52.1338 DFramework.Database.NullableDataReader    Data reader open for 299
   at System.Environment.GetStackTrace(Exception e, Boolean needFileInfo)
   at System.Environment.get_StackTrace()
   at DFramework.Database.NullableDataReader.Dispose(Boolean disposing) in 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 D:\Spraxa\CoolR-Portal\CoolR.Tasks\ProcessAlertData.cs:line 42
   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-19 03:16:52.2432 DFramework.Database.Query    /* Time Taken: 1591*/
[dbo].GenerateSystemAlerts 
2026-01-19 03:16:52.3369 DFramework.Database.NullableDataReader    Data reader open for 1076
   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 D:\Spraxa\CoolR-Portal\CoolR.Tasks\OpportunityOutOfStockByOutlet.cs:line 490
   at CoolR.Tasks.ProcessOutletAlertData.Execute() in D:\Spraxa\CoolR-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-19 03:16:52.6807 DFramework.Database.Query    /* Time Taken: 551*/
DECLARE @TableName AnsiString(8000)
SET @TableName = 'VoidAlert'
DECLARE @CurrentRecordId Int32
SET @CurrentRecordId = '3676436'
dbo.GetValidDeviceForAlertProcessData 
2026-01-19 03:16:52.6963 AlertProcessor    ProcessorAlertData-10: table: VoidAlert, currentRecordId: 3676436 
2026-01-19 03:16:53.3690 DFramework.Database.Query    /* Time Taken: 631*/
DECLARE @TableName AnsiString(8000)
SET @TableName = 'OpportunityOutOfStock'
DECLARE @CurrentRecordId Int32
SET @CurrentRecordId = '3676436'
dbo.GetValidDeviceForAlertProcessData 
2026-01-19 03:16:53.3690 AlertProcessor    ProcessorAlertData-10: table: OpportunityOutOfStock, currentRecordId: 3676436 
2026-01-19 03:16:53.8064 AlertProcessor    ProcessorAlertData-10: table: PlanogramComplianceConsolidate, currentRecordId: 3676436 
2026-01-19 03:16:54.2286 AlertProcessor    ProcessorAlertData-10: table: OpportunityOutOfStockConsolidate, currentRecordId: 3676436 
2026-01-19 03:16:54.9515 DFramework.Database.Query    /* Time Taken: 665*/
DECLARE @TableName AnsiString(8000)
SET @TableName = 'AssetStockProductWiseConsolidate'
DECLARE @CurrentRecordId Int32
SET @CurrentRecordId = '3676436'
dbo.GetValidDeviceForAlertProcessData 
2026-01-19 03:16:54.9635 AlertProcessor    ProcessorAlertData-10: table: AssetStockProductWiseConsolidate, currentRecordId: 3676436 
2026-01-19 03:16:55.3896 AlertProcessor    ProcessorAlertData-10: table: AssetStockProductWise, currentRecordId: 3676436 
2026-01-19 03:16:55.8124 AlertProcessor    ProcessorAlertData-10: table: AssetStock, currentRecordId: 3676436 
2026-01-19 03:16:56.2352 AlertProcessor    ProcessorAlertData-10: table: AssetPurity, currentRecordId: 3676436 
2026-01-19 03:16:56.6420 AlertProcessor    ProcessorAlertData-10: table: OpportunityLowStock, currentRecordId: 3676436 
2026-01-19 03:16:57.0641 AlertProcessor    ProcessorAlertData-10: table: AssetStockProductCategoryWise, currentRecordId: 3676436 
2026-01-19 03:16:57.4548 AlertProcessor    ProcessorAlertData-10: table: LowInventoryConsolidate, currentRecordId: 3676436 
2026-01-19 03:16:57.8782 AlertProcessor    ProcessorAlertData-10: table: TargetPortfolioComplianceConsolidate, currentRecordId: 3676436 
2026-01-19 03:16:58.5828 DFramework.Database.Query    /* Time Taken: 636*/
DECLARE @TableName AnsiString(8000)
SET @TableName = 'ProductStockLevel'
DECLARE @CurrentRecordId Int32
SET @CurrentRecordId = '3676436'
dbo.GetValidDeviceForAlertProcessData 
2026-01-19 03:16:58.5828 AlertProcessor    ProcessorAlertData-10: table: ProductStockLevel, currentRecordId: 3676436 
2026-01-19 03:16:58.6297 AlertProcessor    ProcessorAlertData-11: Updating LastProcessedImageId 
2026-01-19 03:16:58.6297 AlertProcessor    ProcessorAlertData: Stopped 
2026-01-19 03:17:02.9072 DFramework.Scheduler.TaskBase    /* Time Taken: 12322.1697*/
Opportunity Out Of Stock By Outlet 
2026-01-19 03:21:50.5947 AlertProcessor    ProcessorAlertData: started 
2026-01-19 03:21:50.9230 AlertProcessor    ProcessorAlertData-10: table: TagAlert, currentRecordId: 3676436 
2026-01-19 03:21:51.3407 AlertProcessor    ProcessorAlertData-10: table: VoidAlert, currentRecordId: 3676436 
2026-01-19 03:21:51.7540 AlertProcessor    ProcessorAlertData-10: table: OpportunityOutOfStock, currentRecordId: 3676436 
2026-01-19 03:21:52.1602 AlertProcessor    ProcessorAlertData-10: table: PlanogramComplianceConsolidate, currentRecordId: 3676436 
2026-01-19 03:21:52.6136 AlertProcessor    ProcessorAlertData-10: table: OpportunityOutOfStockConsolidate, currentRecordId: 3676436 
2026-01-19 03:21:53.3024 DFramework.Database.Query    /* Time Taken: 630*/
DECLARE @TableName AnsiString(8000)
SET @TableName = 'AssetStockProductWiseConsolidate'
DECLARE @CurrentRecordId Int32
SET @CurrentRecordId = '3676436'
dbo.GetValidDeviceForAlertProcessData 
2026-01-19 03:21:53.3024 AlertProcessor    ProcessorAlertData-10: table: AssetStockProductWiseConsolidate, currentRecordId: 3676436 
2026-01-19 03:21:53.7092 AlertProcessor    ProcessorAlertData-10: table: AssetStockProductWise, currentRecordId: 3676436 
2026-01-19 03:21:54.1159 AlertProcessor    ProcessorAlertData-10: table: AssetStock, currentRecordId: 3676436 
2026-01-19 03:21:54.5222 AlertProcessor    ProcessorAlertData-10: table: AssetPurity, currentRecordId: 3676436 
2026-01-19 03:21:54.9289 AlertProcessor    ProcessorAlertData-10: table: OpportunityLowStock, currentRecordId: 3676436 
2026-01-19 03:21:55.3695 AlertProcessor    ProcessorAlertData-10: table: AssetStockProductCategoryWise, currentRecordId: 3676436 
2026-01-19 03:21:55.8868 AlertProcessor    ProcessorAlertData-10: table: LowInventoryConsolidate, currentRecordId: 3676436 
2026-01-19 03:21:56.3087 AlertProcessor    ProcessorAlertData-10: table: TargetPortfolioComplianceConsolidate, currentRecordId: 3676436 
2026-01-19 03:21:56.9810 DFramework.Database.Query    /* Time Taken: 613*/
DECLARE @TableName AnsiString(8000)
SET @TableName = 'ProductStockLevel'
DECLARE @CurrentRecordId Int32
SET @CurrentRecordId = '3676436'
dbo.GetValidDeviceForAlertProcessData 
2026-01-19 03:21:56.9810 AlertProcessor    ProcessorAlertData-10: table: ProductStockLevel, currentRecordId: 3676436 
2026-01-19 03:21:57.0279 AlertProcessor    ProcessorAlertData-11: Updating LastProcessedImageId 
2026-01-19 03:21:57.0279 AlertProcessor    ProcessorAlertData: Stopped 
2026-01-19 03:26:50.5981 AlertProcessor    ProcessorAlertData: started 
2026-01-19 03:26:51.0983 DFramework.Database.Query    /* Time Taken: 507*/
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-19 03:26:51.6627 DFramework.Database.Query    /* Time Taken: 1075*/
DECLARE @TableName AnsiString(8000)
SET @TableName = 'TagAlert'
DECLARE @CurrentRecordId Int32
SET @CurrentRecordId = '0'
dbo.GetValidDeviceForAlertProcessData 
2026-01-19 03:26:51.6627 AlertProcessor    ProcessorAlertData-10: table: TagAlert, currentRecordId: 3676436 
2026-01-19 03:26:51.6939 DFramework.Database.Query    /* Time Taken: 1039*/
DECLARE @CreatedOn Date
SET @CreatedOn = '1/19/2026 12:00:00 AM'
DECLARE @EventId Int32
SET @EventId = '-12'
SELECT COUNT(1) FROM EmailQueue
 WHERE [CreatedOn] >= @CreatedOn AND [EventId] = @EventId
 
2026-01-19 03:26:51.9910 DFramework.Database.Query    /* Time Taken: 1337*/
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-19 03:26:52.0691 AlertProcessor    ProcessorAlertData-10: table: VoidAlert, currentRecordId: 3676436 
2026-01-19 03:26:52.4600 AlertProcessor    ProcessorAlertData-10: table: OpportunityOutOfStock, currentRecordId: 3676436 
2026-01-19 03:26:52.8507 AlertProcessor    ProcessorAlertData-10: table: PlanogramComplianceConsolidate, currentRecordId: 3676436 
2026-01-19 03:26:53.1323 DFramework.Database.NullableDataReader    Data reader open for 273
   at System.Environment.GetStackTrace(Exception e, Boolean needFileInfo)
   at System.Environment.get_StackTrace()
   at DFramework.Database.NullableDataReader.Dispose(Boolean disposing) in 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 D:\Spraxa\CoolR-Portal\CoolR.Tasks\ProcessAlertData.cs:line 42
   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-19 03:26:53.4780 AlertProcessor    ProcessorAlertData-10: table: OpportunityOutOfStockConsolidate, currentRecordId: 3676436 
2026-01-19 03:26:54.1174 DFramework.Database.Query    /* Time Taken: 590*/
DECLARE @TableName AnsiString(8000)
SET @TableName = 'AssetStockProductWiseConsolidate'
DECLARE @CurrentRecordId Int32
SET @CurrentRecordId = '3676436'
dbo.GetValidDeviceForAlertProcessData 
2026-01-19 03:26:54.1174 AlertProcessor    ProcessorAlertData-10: table: AssetStockProductWiseConsolidate, currentRecordId: 3676436 
2026-01-19 03:26:54.5080 AlertProcessor    ProcessorAlertData-10: table: AssetStockProductWise, currentRecordId: 3676436 
2026-01-19 03:26:54.8839 AlertProcessor    ProcessorAlertData-10: table: AssetStock, currentRecordId: 3676436 
2026-01-19 03:26:55.2761 AlertProcessor    ProcessorAlertData-10: table: AssetPurity, currentRecordId: 3676436 
2026-01-19 03:26:55.6532 AlertProcessor    ProcessorAlertData-10: table: OpportunityLowStock, currentRecordId: 3676436 
2026-01-19 03:26:56.0283 AlertProcessor    ProcessorAlertData-10: table: AssetStockProductCategoryWise, currentRecordId: 3676436 
2026-01-19 03:26:56.4193 AlertProcessor    ProcessorAlertData-10: table: LowInventoryConsolidate, currentRecordId: 3676436 
2026-01-19 03:26:56.7949 AlertProcessor    ProcessorAlertData-10: table: TargetPortfolioComplianceConsolidate, currentRecordId: 3676436 
2026-01-19 03:26:57.4670 DFramework.Database.Query    /* Time Taken: 609*/
DECLARE @TableName AnsiString(8000)
SET @TableName = 'ProductStockLevel'
DECLARE @CurrentRecordId Int32
SET @CurrentRecordId = '3676436'
dbo.GetValidDeviceForAlertProcessData 
2026-01-19 03:26:57.4670 AlertProcessor    ProcessorAlertData-10: table: ProductStockLevel, currentRecordId: 3676436 
2026-01-19 03:26:57.5138 AlertProcessor    ProcessorAlertData-11: Updating LastProcessedImageId 
2026-01-19 03:26:57.5138 AlertProcessor    ProcessorAlertData: Stopped 
2026-01-19 03:29:41.7792 AlertProcessor    ProcessorAlertData: started 
2026-01-19 03:29:42.3897 DFramework.Database.Query    /* Time Taken: 530*/
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/19/2026 11:29:41 AM'
SELECT TOP 1 AlertDefinitionId, PriorityId FROM AlertDefinition
 WHERE AlertDefinition.IsActive = @AlertDefinition_IsActive AND AlertDefinition.ClientId = @AlertDefinition_ClientId AND AlertDefinition.AlertTypeId = @AlertDefinition_AlertTypeId AND AlertDefinition.IsDeleted = @AlertDefinition_IsDeleted AND AlertDefinition.StartDate <= @AlertDefinition_StartDate
 
2026-01-19 03:29:42.4209 DFramework.Database.Query    /* Time Taken: 631*/
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/19/2026 11:29:41 AM'
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-19 03:29:42.9526 DFramework.Database.Query    /* Time Taken: 1135*/
DECLARE @OrderStatusId Int32
SET @OrderStatusId = '5486'
DECLARE @CurrentUtcDateTime DateTime2
SET @CurrentUtcDateTime = '1/19/2026 11:29:41 AM'
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-19 03:29:43.0315 DFramework.Database.Query    /* Time Taken: 698*/
DECLARE @AssetKPIData Object
SET @AssetKPIData = ''
[dbo].BulkUpsertAssetDayKPI 
2026-01-19 03:29:43.0784 DFramework.Database.Query    /* Time Taken: 705*/
DECLARE @AppConfigId Int32
SET @AppConfigId = '1'
SELECT * FROM AppConfig

 WHERE [AppConfigId] = @AppConfigId
 ORDER BY [AppConfigId] 
2026-01-19 03:29:43.1096 DFramework.Database.Query    /* Time Taken: 715*/
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-19 03:29:43.1409 DFramework.Database.Query    /* Time Taken: 715*/
DECLARE @AlertDefinitionId Int32
SET @AlertDefinitionId = '99'
DECLARE @IsDeleted Boolean
SET @IsDeleted = 'False'
SELECT ProductId FROM AlertDefinitionProduct
 WHERE [AlertDefinitionId] = @AlertDefinitionId AND IsDeleted = @IsDeleted
 
2026-01-19 03:29:43.2034 DFramework.Database.Query    /* Time Taken: 1343*/
[dbo].GenerateSystemAlerts 
2026-01-19 03:29:43.2507 DFramework.Database.Query    /* Time Taken: 1403*/
DECLARE @CreatedOn Date
SET @CreatedOn = '1/19/2026 12:00:00 AM'
DECLARE @EventId Int32
SET @EventId = '-12'
SELECT COUNT(1) FROM EmailQueue
 WHERE [CreatedOn] >= @CreatedOn AND [EventId] = @EventId
 
2026-01-19 03:29:43.2663 DFramework.Database.Query    /* Time Taken: 1446*/
DECLARE @TableName AnsiString(8000)
SET @TableName = 'TagAlert'
DECLARE @CurrentRecordId Int32
SET @CurrentRecordId = '0'
dbo.GetValidDeviceForAlertProcessData 
2026-01-19 03:29:43.2663 AlertProcessor    ProcessorAlertData-10: table: TagAlert, currentRecordId: 3676436 
2026-01-19 03:29:43.4991 DFramework.Database.NullableDataReader    Data reader open for 1065
   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 D:\Spraxa\CoolR-Portal\CoolR.Tasks\OpportunityOutOfStockByOutlet.cs:line 490
   at CoolR.Tasks.ProcessOutletAlertData.Execute() in D:\Spraxa\CoolR-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-19 03:29:43.8134 AlertProcessor    ProcessorAlertData-10: table: VoidAlert, currentRecordId: 3676436 
2026-01-19 03:29:44.2050 AlertProcessor    ProcessorAlertData-10: table: OpportunityOutOfStock, currentRecordId: 3676436 
2026-01-19 03:29:44.6430 AlertProcessor    ProcessorAlertData-10: table: PlanogramComplianceConsolidate, currentRecordId: 3676436 
2026-01-19 03:29:45.2119 DFramework.Database.Query    /* Time Taken: 511*/
DECLARE @TableName AnsiString(8000)
SET @TableName = 'OpportunityOutOfStockConsolidate'
DECLARE @CurrentRecordId Int32
SET @CurrentRecordId = '3676436'
dbo.GetValidDeviceForAlertProcessData 
2026-01-19 03:29:45.2119 AlertProcessor    ProcessorAlertData-10: table: OpportunityOutOfStockConsolidate, currentRecordId: 3676436 
2026-01-19 03:29:45.8978 DFramework.Database.Query    /* Time Taken: 625*/
DECLARE @TableName AnsiString(8000)
SET @TableName = 'AssetStockProductWiseConsolidate'
DECLARE @CurrentRecordId Int32
SET @CurrentRecordId = '3676436'
dbo.GetValidDeviceForAlertProcessData 
2026-01-19 03:29:45.8978 AlertProcessor    ProcessorAlertData-10: table: AssetStockProductWiseConsolidate, currentRecordId: 3676436 
2026-01-19 03:29:46.3042 AlertProcessor    ProcessorAlertData-10: table: AssetStockProductWise, currentRecordId: 3676436 
2026-01-19 03:29:46.6954 AlertProcessor    ProcessorAlertData-10: table: AssetStock, currentRecordId: 3676436 
2026-01-19 03:29:47.1025 AlertProcessor    ProcessorAlertData-10: table: AssetPurity, currentRecordId: 3676436 
2026-01-19 03:29:47.4932 AlertProcessor    ProcessorAlertData-10: table: OpportunityLowStock, currentRecordId: 3676436 
2026-01-19 03:29:47.9014 AlertProcessor    ProcessorAlertData-10: table: AssetStockProductCategoryWise, currentRecordId: 3676436 
2026-01-19 03:29:48.2922 AlertProcessor    ProcessorAlertData-10: table: LowInventoryConsolidate, currentRecordId: 3676436 
2026-01-19 03:29:48.7142 AlertProcessor    ProcessorAlertData-10: table: TargetPortfolioComplianceConsolidate, currentRecordId: 3676436 
2026-01-19 03:29:49.4955 DFramework.Database.Query    /* Time Taken: 733*/
DECLARE @TableName AnsiString(8000)
SET @TableName = 'ProductStockLevel'
DECLARE @CurrentRecordId Int32
SET @CurrentRecordId = '3676436'
dbo.GetValidDeviceForAlertProcessData 
2026-01-19 03:29:49.4955 AlertProcessor    ProcessorAlertData-10: table: ProductStockLevel, currentRecordId: 3676436 
2026-01-19 03:29:49.5580 AlertProcessor    ProcessorAlertData-11: Updating LastProcessedImageId 
2026-01-19 03:29:49.5580 AlertProcessor    ProcessorAlertData: Stopped 
2026-01-19 03:29:54.0972 DFramework.Scheduler.TaskBase    /* Time Taken: 12318.0456*/
Opportunity Out Of Stock By Outlet 
2026-01-19 03:34:41.7904 AlertProcessor    ProcessorAlertData: started 
2026-01-19 03:34:42.1045 AlertProcessor    ProcessorAlertData-10: table: TagAlert, currentRecordId: 3676436 
2026-01-19 03:34:42.4327 AlertProcessor    ProcessorAlertData-10: table: VoidAlert, currentRecordId: 3676436 
2026-01-19 03:34:42.8233 AlertProcessor    ProcessorAlertData-10: table: OpportunityOutOfStock, currentRecordId: 3676436 
2026-01-19 03:34:43.2186 AlertProcessor    ProcessorAlertData-10: table: PlanogramComplianceConsolidate, currentRecordId: 3676436 
2026-01-19 03:34:43.5978 AlertProcessor    ProcessorAlertData-10: table: OpportunityOutOfStockConsolidate, currentRecordId: 3676436 
2026-01-19 03:34:44.2286 DFramework.Database.Query    /* Time Taken: 578*/
DECLARE @TableName AnsiString(8000)
SET @TableName = 'AssetStockProductWiseConsolidate'
DECLARE @CurrentRecordId Int32
SET @CurrentRecordId = '3676436'
dbo.GetValidDeviceForAlertProcessData 
2026-01-19 03:34:44.2286 AlertProcessor    ProcessorAlertData-10: table: AssetStockProductWiseConsolidate, currentRecordId: 3676436 
2026-01-19 03:34:44.6035 AlertProcessor    ProcessorAlertData-10: table: AssetStockProductWise, currentRecordId: 3676436 
2026-01-19 03:34:44.9942 AlertProcessor    ProcessorAlertData-10: table: AssetStock, currentRecordId: 3676436 
2026-01-19 03:34:45.6119 DFramework.Database.Query    /* Time Taken: 560*/
DECLARE @TableName AnsiString(8000)
SET @TableName = 'AssetPurity'
DECLARE @CurrentRecordId Int32
SET @CurrentRecordId = '3676436'
dbo.GetValidDeviceForAlertProcessData 
2026-01-19 03:34:45.6119 AlertProcessor    ProcessorAlertData-10: table: AssetPurity, currentRecordId: 3676436 
2026-01-19 03:34:45.9924 AlertProcessor    ProcessorAlertData-10: table: OpportunityLowStock, currentRecordId: 3676436 
2026-01-19 03:34:46.3698 AlertProcessor    ProcessorAlertData-10: table: AssetStockProductCategoryWise, currentRecordId: 3676436 
2026-01-19 03:34:46.7335 AlertProcessor    ProcessorAlertData-10: table: LowInventoryConsolidate, currentRecordId: 3676436 
2026-01-19 03:34:47.1133 AlertProcessor    ProcessorAlertData-10: table: TargetPortfolioComplianceConsolidate, currentRecordId: 3676436 
2026-01-19 03:34:47.7442 DFramework.Database.Query    /* Time Taken: 574*/
DECLARE @TableName AnsiString(8000)
SET @TableName = 'ProductStockLevel'
DECLARE @CurrentRecordId Int32
SET @CurrentRecordId = '3676436'
dbo.GetValidDeviceForAlertProcessData 
2026-01-19 03:34:47.7442 AlertProcessor    ProcessorAlertData-10: table: ProductStockLevel, currentRecordId: 3676436 
2026-01-19 03:34:47.8067 AlertProcessor    ProcessorAlertData-11: Updating LastProcessedImageId 
2026-01-19 03:34:47.8067 AlertProcessor    ProcessorAlertData: Stopped 
2026-01-19 03:37:54.6394 AlertProcessor    ProcessorAlertData: started 
2026-01-19 03:37:55.2986 DFramework.Database.Query    /* Time Taken: 614*/
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-19 03:37:55.3449 DFramework.Database.Query    /* Time Taken: 653*/
DECLARE @OrderStatusId Int32
SET @OrderStatusId = '5486'
DECLARE @CurrentUtcDateTime DateTime2
SET @CurrentUtcDateTime = '1/19/2026 11:37:54 AM'
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-19 03:37:55.3761 DFramework.Database.Query    /* Time Taken: 644*/
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/19/2026 11:37:54 AM'
SELECT TOP 1 AlertDefinitionId, PriorityId FROM AlertDefinition
 WHERE AlertDefinition.IsActive = @AlertDefinition_IsActive AND AlertDefinition.ClientId = @AlertDefinition_ClientId AND AlertDefinition.AlertTypeId = @AlertDefinition_AlertTypeId AND AlertDefinition.IsDeleted = @AlertDefinition_IsDeleted AND AlertDefinition.StartDate <= @AlertDefinition_StartDate
 
2026-01-19 03:37:55.5813 DFramework.Database.Query    /* Time Taken: 934*/
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/19/2026 11:37:54 AM'
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-19 03:37:55.9096 DFramework.Database.Query    /* Time Taken: 749*/
DECLARE @AppConfigId Int32
SET @AppConfigId = '1'
SELECT * FROM AppConfig

 WHERE [AppConfigId] = @AppConfigId
 ORDER BY [AppConfigId] 
2026-01-19 03:37:55.9564 DFramework.Database.Query    /* Time Taken: 619*/
DECLARE @OrderStatusId Int32
SET @OrderStatusId = '5484'
DECLARE @CurrentUtcDateTime DateTime2
SET @CurrentUtcDateTime = '1/19/2026 11:37:55 AM'
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-19 03:37:56.0033 DFramework.Database.Query    /* Time Taken: 621*/
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-19 03:37:56.1283 DFramework.Database.NullableDataReader    Data reader open for 548
   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 D:\Spraxa\CoolR-Portal\CoolR.Tasks\OpportunityOutOfStockByOutlet.cs:line 490
   at CoolR.Tasks.ProcessOutletAlertData.Execute() in D:\Spraxa\CoolR-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-19 03:37:56.1283 DFramework.Database.Query    /* Time Taken: 1459*/
DECLARE @TableName AnsiString(8000)
SET @TableName = 'TagAlert'
DECLARE @CurrentRecordId Int32
SET @CurrentRecordId = '0'
dbo.GetValidDeviceForAlertProcessData 
2026-01-19 03:37:56.1439 AlertProcessor    ProcessorAlertData-10: table: TagAlert, currentRecordId: 3676436 
2026-01-19 03:37:56.1908 DFramework.Database.Query    /* Time Taken: 1008*/
DECLARE @AssetKPIData Object
SET @AssetKPIData = ''
[dbo].BulkUpsertAssetDayKPI 
2026-01-19 03:37:56.3627 DFramework.Database.Query    /* Time Taken: 1631*/
[dbo].GenerateSystemAlerts 
2026-01-19 03:37:56.6756 AlertProcessor    ProcessorAlertData-10: table: VoidAlert, currentRecordId: 3676436 
2026-01-19 03:37:56.7225 MoveToReorder    Running task for ClientId : 286 and ClientName = India Office QA and Slot: 1/19/2026 5:00:00 PM And LastExecutedOn: 1/19/2026 4:04:56 PM 
2026-01-19 03:37:57.0667 AlertProcessor    ProcessorAlertData-10: table: OpportunityOutOfStock, currentRecordId: 3676436 
2026-01-19 03:37:57.5043 AlertProcessor    ProcessorAlertData-10: table: PlanogramComplianceConsolidate, currentRecordId: 3676436 
2026-01-19 03:37:57.8799 AlertProcessor    ProcessorAlertData-10: table: OpportunityOutOfStockConsolidate, currentRecordId: 3676436 
2026-01-19 03:37:58.5522 DFramework.Database.Query    /* Time Taken: 626*/
DECLARE @TableName AnsiString(8000)
SET @TableName = 'AssetStockProductWiseConsolidate'
DECLARE @CurrentRecordId Int32
SET @CurrentRecordId = '3676436'
dbo.GetValidDeviceForAlertProcessData 
2026-01-19 03:37:58.5522 AlertProcessor    ProcessorAlertData-10: table: AssetStockProductWiseConsolidate, currentRecordId: 3676436 
2026-01-19 03:37:58.9273 AlertProcessor    ProcessorAlertData-10: table: AssetStockProductWise, currentRecordId: 3676436 
2026-01-19 03:37:59.3335 AlertProcessor    ProcessorAlertData-10: table: AssetStock, currentRecordId: 3676436 
2026-01-19 03:37:59.7085 AlertProcessor    ProcessorAlertData-10: table: AssetPurity, currentRecordId: 3676436 
2026-01-19 03:38:00.1007 AlertProcessor    ProcessorAlertData-10: table: OpportunityLowStock, currentRecordId: 3676436 
2026-01-19 03:38:00.4960 AlertProcessor    ProcessorAlertData-10: table: AssetStockProductCategoryWise, currentRecordId: 3676436 
2026-01-19 03:38:01.1070 DFramework.Database.Query    /* Time Taken: 558*/
DECLARE @TableName AnsiString(8000)
SET @TableName = 'LowInventoryConsolidate'
DECLARE @CurrentRecordId Int32
SET @CurrentRecordId = '3676436'
dbo.GetValidDeviceForAlertProcessData 
2026-01-19 03:38:01.1070 AlertProcessor    ProcessorAlertData-10: table: LowInventoryConsolidate, currentRecordId: 3676436 
2026-01-19 03:38:01.4988 AlertProcessor    ProcessorAlertData-10: table: TargetPortfolioComplianceConsolidate, currentRecordId: 3676436 
2026-01-19 03:38:02.1564 DFramework.Database.Query    /* Time Taken: 591*/
DECLARE @TableName AnsiString(8000)
SET @TableName = 'ProductStockLevel'
DECLARE @CurrentRecordId Int32
SET @CurrentRecordId = '3676436'
dbo.GetValidDeviceForAlertProcessData 
2026-01-19 03:38:02.1564 AlertProcessor    ProcessorAlertData-10: table: ProductStockLevel, currentRecordId: 3676436 
2026-01-19 03:38:02.2032 AlertProcessor    ProcessorAlertData-11: Updating LastProcessedImageId 
2026-01-19 03:38:02.2032 AlertProcessor    ProcessorAlertData: Stopped 
2026-01-19 03:38:06.6168 DFramework.Scheduler.TaskBase    /* Time Taken: 11992.9829*/
Opportunity Out Of Stock By Outlet 
2026-01-19 03:38:36.2140 DFramework.Database.NullableDataReader    Data reader open for 39207
   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 D:\Spraxa\CoolR-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-19 03:38:36.2457 MoveToReorder    Task executed successfully for ClientId : 286 Client Name:India Office QA, Slot: 1/19/2026 5:00:00 PM and Total Order Suggested: 127 Out Of: 127 
2026-01-19 03:38:38.0288 DFramework.Scheduler.TaskBase    /* Time Taken: 43342.5084*/
Move To Re-Order 
2026-01-19 03:42:01.1732 AlertProcessor    ProcessorAlertData: started 
2026-01-19 03:42:01.7525 DFramework.Database.Query    /* Time Taken: 514*/
DECLARE @CreatedOn Date
SET @CreatedOn = '1/19/2026 12:00:00 AM'
DECLARE @EventId Int32
SET @EventId = '-12'
SELECT COUNT(1) FROM EmailQueue
 WHERE [CreatedOn] >= @CreatedOn AND [EventId] = @EventId
 
2026-01-19 03:42:01.8150 DFramework.Database.Query    /* Time Taken: 632*/
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-19 03:42:01.8306 DFramework.Database.Query    /* Time Taken: 650*/
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/19/2026 11:42:01 AM'
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-19 03:42:01.8619 DFramework.Database.Query    /* Time Taken: 663*/
DECLARE @OrderStatusId Int32
SET @OrderStatusId = '5486'
DECLARE @CurrentUtcDateTime DateTime2
SET @CurrentUtcDateTime = '1/19/2026 11:42:01 AM'
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-19 03:42:02.1542 DFramework.Database.Query    /* Time Taken: 910*/
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/19/2026 11:42:01 AM'
SELECT TOP 1 AlertDefinitionId, PriorityId FROM AlertDefinition
 WHERE AlertDefinition.IsActive = @AlertDefinition_IsActive AND AlertDefinition.ClientId = @AlertDefinition_ClientId AND AlertDefinition.AlertTypeId = @AlertDefinition_AlertTypeId AND AlertDefinition.IsDeleted = @AlertDefinition_IsDeleted AND AlertDefinition.StartDate <= @AlertDefinition_StartDate
 
2026-01-19 03:42:02.2374 DFramework.Database.Query    /* Time Taken: 515*/
DECLARE @AssetKPIData Object
SET @AssetKPIData = ''
[dbo].BulkUpsertAssetDayKPI 
2026-01-19 03:42:02.2843 DFramework.Database.Query    /* Time Taken: 1068*/
DECLARE @TableName AnsiString(8000)
SET @TableName = 'TagAlert'
DECLARE @CurrentRecordId Int32
SET @CurrentRecordId = '0'
dbo.GetValidDeviceForAlertProcessData 
2026-01-19 03:42:02.2843 AlertProcessor    ProcessorAlertData-7: table: TagAlert, maxRecordId: 3676459, assetId: 118196 
2026-01-19 03:42:02.2843 AlertProcessor    ProcessorAlertData-8: recordTable: TagAlert, alertTypeId: 48 
2026-01-19 03:42:02.3781 DFramework.Database.Query    /* Time Taken: 511*/
DECLARE @OrderStatusId Int32
SET @OrderStatusId = '5484'
DECLARE @CurrentUtcDateTime DateTime2
SET @CurrentUtcDateTime = '1/19/2026 11:42:01 AM'
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-19 03:42:02.4406 DFramework.Database.NullableDataReader    Data reader open for 601
   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 D:\Spraxa\CoolR-Portal\CoolR.Tasks\OpportunityOutOfStockByOutlet.cs:line 490
   at CoolR.Tasks.ProcessOutletAlertData.Execute() in D:\Spraxa\CoolR-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-19 03:42:02.9407 AlertProcessor    ProcessorAlertData-9: recordTable: TagAlert, alertTypeId: 48, AlertDefinitionCount: 2 
2026-01-19 03:42:02.9407 DFramework.Database.NullableDataReader    Data reader open for 464
   at System.Environment.GetStackTrace(Exception e, Boolean needFileInfo)
   at System.Environment.get_StackTrace()
   at DFramework.Database.NullableDataReader.Dispose(Boolean disposing) in 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 D:\Spraxa\CoolR-Portal\CoolR.Tasks\ProcessAlertData.cs:line 42
   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-19 03:42:02.9407 AlertProcessor    ProcessorAlertData-10: table: TagAlert, currentRecordId: 3676459 
2026-01-19 03:42:03.0034 DFramework.Database.NullableDataReader    Data reader open for 722
   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 D:\Spraxa\CoolR-Portal\CoolR.Tasks\ProcessAlertData.cs:line 42
   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-19 03:42:03.0659 DFramework.Database.Query    /* Time Taken: 1820*/
[dbo].GenerateSystemAlerts 
2026-01-19 03:42:03.3478 AlertProcessor    ProcessorAlertData-7: table: VoidAlert, maxRecordId: 3676459, assetId: 118196 
2026-01-19 03:42:03.3478 AlertProcessor    ProcessorAlertData-8: recordTable: VoidAlert, alertTypeId: 49 
2026-01-19 03:42:03.7079 AlertProcessor    ProcessorAlertData-9: recordTable: VoidAlert, alertTypeId: 49, AlertDefinitionCount: 2 
2026-01-19 03:42:03.7079 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.ProcessAlertData.Execute() in D:\Spraxa\CoolR-Portal\CoolR.Tasks\ProcessAlertData.cs:line 42
   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-19 03:42:03.7079 AlertProcessor    ProcessorAlertData-10: table: VoidAlert, currentRecordId: 3676459 
2026-01-19 03:42:03.7704 DFramework.Database.NullableDataReader    Data reader open for 417
   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 D:\Spraxa\CoolR-Portal\CoolR.Tasks\ProcessAlertData.cs:line 42
   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-19 03:42:04.1142 AlertProcessor    ProcessorAlertData-7: table: OpportunityOutOfStock, maxRecordId: 3676459, assetId: 118196 
2026-01-19 03:42:04.1142 AlertProcessor    ProcessorAlertData-8: recordTable: OpportunityOutOfStock, alertTypeId: 28 
2026-01-19 03:42:04.3491 AlertProcessor    ProcessorAlertData-9: recordTable: OpportunityOutOfStock, alertTypeId: 28, AlertDefinitionCount: 2 
2026-01-19 03:42:04.3491 DFramework.Database.NullableDataReader    Data reader open for 207
   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 D:\Spraxa\CoolR-Portal\CoolR.Tasks\ProcessAlertData.cs:line 42
   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-19 03:42:04.3491 AlertProcessor    ProcessorAlertData-10: table: OpportunityOutOfStock, currentRecordId: 3676459 
2026-01-19 03:42:04.4116 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.ProcessAlertData.Execute() in D:\Spraxa\CoolR-Portal\CoolR.Tasks\ProcessAlertData.cs:line 42
   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-19 03:42:04.7401 AlertProcessor    ProcessorAlertData-7: table: PlanogramComplianceConsolidate, maxRecordId: 3676459, assetId: 118196 
2026-01-19 03:42:04.7401 AlertProcessor    ProcessorAlertData-8: recordTable: PlanogramComplianceConsolidate, alertTypeId: 64 
2026-01-19 03:42:05.0058 AlertProcessor    ProcessorAlertData-9: recordTable: PlanogramComplianceConsolidate, alertTypeId: 64, AlertDefinitionCount: 2 
2026-01-19 03:42:05.0058 DFramework.Database.NullableDataReader    Data reader open for 236
   at System.Environment.GetStackTrace(Exception e, Boolean needFileInfo)
   at System.Environment.get_StackTrace()
   at DFramework.Database.NullableDataReader.Dispose(Boolean disposing) in 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 D:\Spraxa\CoolR-Portal\CoolR.Tasks\ProcessAlertData.cs:line 42
   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-19 03:42:05.0058 AlertProcessor    ProcessorAlertData-10: table: PlanogramComplianceConsolidate, currentRecordId: 3676459 
2026-01-19 03:42:05.0683 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.ProcessAlertData.Execute() in D:\Spraxa\CoolR-Portal\CoolR.Tasks\ProcessAlertData.cs:line 42
   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-19 03:42:05.5326 AlertProcessor    ProcessorAlertData-7: table: OpportunityOutOfStockConsolidate, maxRecordId: 3676459, assetId: 118196 
2026-01-19 03:42:05.5326 AlertProcessor    ProcessorAlertData-8: recordTable: OpportunityOutOfStockConsolidate, alertTypeId: 44 
2026-01-19 03:42:05.9010 AlertProcessor    ProcessorAlertData-9: recordTable: OpportunityOutOfStockConsolidate, alertTypeId: 44, AlertDefinitionCount: 2 
2026-01-19 03:42:05.9010 DFramework.Database.NullableDataReader    Data reader open for 349
   at System.Environment.GetStackTrace(Exception e, Boolean needFileInfo)
   at System.Environment.get_StackTrace()
   at DFramework.Database.NullableDataReader.Dispose(Boolean disposing) in 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 D:\Spraxa\CoolR-Portal\CoolR.Tasks\ProcessAlertData.cs:line 42
   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-19 03:42:05.9010 AlertProcessor    ProcessorAlertData-10: table: OpportunityOutOfStockConsolidate, currentRecordId: 3676459 
2026-01-19 03:42:05.9635 DFramework.Database.NullableDataReader    Data reader open for 434
   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 D:\Spraxa\CoolR-Portal\CoolR.Tasks\ProcessAlertData.cs:line 42
   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-19 03:42:06.5898 DFramework.Database.Query    /* Time Taken: 630*/
DECLARE @TableName AnsiString(8000)
SET @TableName = 'AssetStockProductWiseConsolidate'
DECLARE @CurrentRecordId Int32
SET @CurrentRecordId = '3676459'
dbo.GetValidDeviceForAlertProcessData 
2026-01-19 03:42:06.5898 AlertProcessor    ProcessorAlertData-7: table: AssetStockProductWiseConsolidate, maxRecordId: 3676459, assetId: 118196 
2026-01-19 03:42:06.5898 AlertProcessor    ProcessorAlertData-8: recordTable: AssetStockProductWiseConsolidate, alertTypeId: 41 
2026-01-19 03:42:06.6210 AlertProcessor    ProcessorAlertData-9: recordTable: AssetStockProductWiseConsolidate, alertTypeId: 41, AlertDefinitionCount: 1 
2026-01-19 03:42:06.6210 AlertProcessor    ProcessorAlertData-10: table: AssetStockProductWiseConsolidate, currentRecordId: 3676459 
2026-01-19 03:42:07.2153 DFramework.Database.Query    /* Time Taken: 529*/
DECLARE @TableName AnsiString(8000)
SET @TableName = 'AssetStockProductWise'
DECLARE @CurrentRecordId Int32
SET @CurrentRecordId = '3676459'
dbo.GetValidDeviceForAlertProcessData 
2026-01-19 03:42:07.2153 AlertProcessor    ProcessorAlertData-7: table: AssetStockProductWise, maxRecordId: 3676459, assetId: 118196 
2026-01-19 03:42:07.2153 AlertProcessor    ProcessorAlertData-8: recordTable: AssetStockProductWise, alertTypeId: 21 
2026-01-19 03:42:13.1311 DFramework.Scheduler.TaskBase    /* Time Taken: 11957.9061*/
Opportunity Out Of Stock By Outlet 
2026-01-19 03:43:55.4891 DFramework.Database.NullableDataReader    Data reader open for 108234
   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 D:\Spraxa\CoolR-Portal\CoolR.Tasks\ProcessAlertData.cs:line 301
   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-19 03:43:55.5047 DFramework.Database.NullableDataReader    Data reader open for 108278
   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 D:\Spraxa\CoolR-Portal\CoolR.Tasks\ProcessAlertData.cs:line 301
   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-19 03:43:55.7391 DFramework.Scheduler.TaskBase    /* Time Taken: 114565.8748*/
Process Alert Record 
2026-01-19 03:44:01.6262 AlertProcessor    ProcessorAlertData: started 
2026-01-19 03:44:02.2833 DFramework.Database.Query    /* Time Taken: 650*/
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/19/2026 11:44:01 AM'
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-19 03:44:02.5489 DFramework.Database.Query    /* Time Taken: 845*/
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-19 03:44:02.5958 DFramework.Database.Query    /* Time Taken: 895*/
DECLARE @CreatedOn Date
SET @CreatedOn = '1/19/2026 12:00:00 AM'
DECLARE @EventId Int32
SET @EventId = '-12'
SELECT COUNT(1) FROM EmailQueue
 WHERE [CreatedOn] >= @CreatedOn AND [EventId] = @EventId
 
2026-01-19 03:44:02.9239 DFramework.Database.Query    /* Time Taken: 1274*/
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-19 03:44:02.9937 DFramework.Database.Query    /* Time Taken: 825*/
DECLARE @AssetKPIData Object
SET @AssetKPIData = ''
[dbo].BulkUpsertAssetDayKPI 
2026-01-19 03:44:03.0183 DFramework.Database.Query    /* Time Taken: 816*/
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-19 03:44:03.0496 DFramework.Database.Query    /* Time Taken: 750*/
DECLARE @AlertDefinitionId Int32
SET @AlertDefinitionId = '99'
DECLARE @IsDeleted Boolean
SET @IsDeleted = 'False'
SELECT ProductId FROM AlertDefinitionProduct
 WHERE [AlertDefinitionId] = @AlertDefinitionId AND IsDeleted = @IsDeleted
 
2026-01-19 03:44:03.0808 DFramework.Database.Query    /* Time Taken: 521*/
DECLARE @AppConfigId Int32
SET @AppConfigId = '1'
SELECT * FROM AppConfig

 WHERE [AppConfigId] = @AppConfigId
 ORDER BY [AppConfigId] 
2026-01-19 03:44:03.1121 DFramework.Database.Query    /* Time Taken: 1417*/
[dbo].GenerateSystemAlerts 
2026-01-19 03:44:03.1277 DFramework.Database.Query    /* Time Taken: 1452*/
DECLARE @TableName AnsiString(8000)
SET @TableName = 'TagAlert'
DECLARE @CurrentRecordId Int32
SET @CurrentRecordId = '0'
dbo.GetValidDeviceForAlertProcessData 
2026-01-19 03:44:03.1277 AlertProcessor    ProcessorAlertData-7: table: TagAlert, maxRecordId: 3676459, assetId: 118196 
2026-01-19 03:44:03.1277 AlertProcessor    ProcessorAlertData-8: recordTable: TagAlert, alertTypeId: 48 
2026-01-19 03:44:03.1433 DFramework.Database.Query    /* Time Taken: 1007*/
DECLARE @OrderStatusId Int32
SET @OrderStatusId = '5484'
DECLARE @CurrentUtcDateTime DateTime2
SET @CurrentUtcDateTime = '1/19/2026 11:44:02 AM'
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-19 03:44:03.2851 AlertProcessor    ProcessorAlertData-9: recordTable: TagAlert, alertTypeId: 48, AlertDefinitionCount: 2 
2026-01-19 03:44:03.2851 AlertProcessor    ProcessorAlertData-10: table: TagAlert, currentRecordId: 3676459 
2026-01-19 03:44:03.3477 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.ProcessAlertData.Execute() in D:\Spraxa\CoolR-Portal\CoolR.Tasks\ProcessAlertData.cs:line 42
   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-19 03:44:03.3633 DFramework.Database.NullableDataReader    Data reader open for 1062
   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 D:\Spraxa\CoolR-Portal\CoolR.Tasks\OpportunityOutOfStockByOutlet.cs:line 490
   at CoolR.Tasks.ProcessOutletAlertData.Execute() in D:\Spraxa\CoolR-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-19 03:44:03.7381 AlertProcessor    ProcessorAlertData-7: table: VoidAlert, maxRecordId: 3676459, assetId: 118196 
2026-01-19 03:44:03.7381 AlertProcessor    ProcessorAlertData-8: recordTable: VoidAlert, alertTypeId: 49 
2026-01-19 03:44:04.0975 AlertProcessor    ProcessorAlertData-9: recordTable: VoidAlert, alertTypeId: 49, AlertDefinitionCount: 2 
2026-01-19 03:44:04.0975 DFramework.Database.NullableDataReader    Data reader open for 327
   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 D:\Spraxa\CoolR-Portal\CoolR.Tasks\ProcessAlertData.cs:line 42
   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-19 03:44:04.0975 AlertProcessor    ProcessorAlertData-10: table: VoidAlert, currentRecordId: 3676459 
2026-01-19 03:44:04.1443 DFramework.Database.NullableDataReader    Data reader open for 412
   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 D:\Spraxa\CoolR-Portal\CoolR.Tasks\ProcessAlertData.cs:line 42
   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-19 03:44:04.4735 AlertProcessor    ProcessorAlertData-7: table: OpportunityOutOfStock, maxRecordId: 3676459, assetId: 118196 
2026-01-19 03:44:04.4735 AlertProcessor    ProcessorAlertData-8: recordTable: OpportunityOutOfStock, alertTypeId: 28 
2026-01-19 03:44:04.6924 AlertProcessor    ProcessorAlertData-9: recordTable: OpportunityOutOfStock, alertTypeId: 28, AlertDefinitionCount: 2 
2026-01-19 03:44:04.6924 AlertProcessor    ProcessorAlertData-10: table: OpportunityOutOfStock, currentRecordId: 3676459 
2026-01-19 03:44:04.7549 DFramework.Database.NullableDataReader    Data reader open for 285
   at System.Environment.GetStackTrace(Exception e, Boolean needFileInfo)
   at System.Environment.get_StackTrace()
   at DFramework.Database.NullableDataReader.Dispose(Boolean disposing) in 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 D:\Spraxa\CoolR-Portal\CoolR.Tasks\ProcessAlertData.cs:line 42
   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-19 03:44:05.0674 AlertProcessor    ProcessorAlertData-7: table: PlanogramComplianceConsolidate, maxRecordId: 3676459, assetId: 118196 
2026-01-19 03:44:05.0674 AlertProcessor    ProcessorAlertData-8: recordTable: PlanogramComplianceConsolidate, alertTypeId: 64 
2026-01-19 03:44:05.3355 AlertProcessor    ProcessorAlertData-9: recordTable: PlanogramComplianceConsolidate, alertTypeId: 64, AlertDefinitionCount: 2 
2026-01-19 03:44:05.3355 DFramework.Database.NullableDataReader    Data reader open for 231
   at System.Environment.GetStackTrace(Exception e, Boolean needFileInfo)
   at System.Environment.get_StackTrace()
   at DFramework.Database.NullableDataReader.Dispose(Boolean disposing) in 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 D:\Spraxa\CoolR-Portal\CoolR.Tasks\ProcessAlertData.cs:line 42
   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-19 03:44:05.3355 AlertProcessor    ProcessorAlertData-10: table: PlanogramComplianceConsolidate, currentRecordId: 3676459 
2026-01-19 03:44:05.3824 DFramework.Database.NullableDataReader    Data reader open for 316
   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 D:\Spraxa\CoolR-Portal\CoolR.Tasks\ProcessAlertData.cs:line 42
   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-19 03:44:05.6963 AlertProcessor    ProcessorAlertData-7: table: OpportunityOutOfStockConsolidate, maxRecordId: 3676459, assetId: 118196 
2026-01-19 03:44:05.6963 AlertProcessor    ProcessorAlertData-8: recordTable: OpportunityOutOfStockConsolidate, alertTypeId: 44 
2026-01-19 03:44:06.0557 AlertProcessor    ProcessorAlertData-9: recordTable: OpportunityOutOfStockConsolidate, alertTypeId: 44, AlertDefinitionCount: 2 
2026-01-19 03:44:06.0557 DFramework.Database.NullableDataReader    Data reader open for 328
   at System.Environment.GetStackTrace(Exception e, Boolean needFileInfo)
   at System.Environment.get_StackTrace()
   at DFramework.Database.NullableDataReader.Dispose(Boolean disposing) in 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 D:\Spraxa\CoolR-Portal\CoolR.Tasks\ProcessAlertData.cs:line 42
   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-19 03:44:06.0557 AlertProcessor    ProcessorAlertData-10: table: OpportunityOutOfStockConsolidate, currentRecordId: 3676459 
2026-01-19 03:44:06.1210 DFramework.Database.NullableDataReader    Data reader open for 412
   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 D:\Spraxa\CoolR-Portal\CoolR.Tasks\ProcessAlertData.cs:line 42
   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-19 03:44:06.6814 DFramework.Database.Query    /* Time Taken: 573*/
DECLARE @TableName AnsiString(8000)
SET @TableName = 'AssetStockProductWiseConsolidate'
DECLARE @CurrentRecordId Int32
SET @CurrentRecordId = '3676459'
dbo.GetValidDeviceForAlertProcessData 
2026-01-19 03:44:06.6814 AlertProcessor    ProcessorAlertData-7: table: AssetStockProductWiseConsolidate, maxRecordId: 3676459, assetId: 118196 
2026-01-19 03:44:06.6814 AlertProcessor    ProcessorAlertData-8: recordTable: AssetStockProductWiseConsolidate, alertTypeId: 41 
2026-01-19 03:44:06.7127 AlertProcessor    ProcessorAlertData-9: recordTable: AssetStockProductWiseConsolidate, alertTypeId: 41, AlertDefinitionCount: 1 
2026-01-19 03:44:06.7127 AlertProcessor    ProcessorAlertData-10: table: AssetStockProductWiseConsolidate, currentRecordId: 3676459 
2026-01-19 03:44:07.1190 AlertProcessor    ProcessorAlertData-7: table: AssetStockProductWise, maxRecordId: 3676459, assetId: 118196 
2026-01-19 03:44:07.1347 AlertProcessor    ProcessorAlertData-8: recordTable: AssetStockProductWise, alertTypeId: 21 
2026-01-19 03:44:13.9318 DFramework.Scheduler.TaskBase    /* Time Taken: 12305.5737*/
Opportunity Out Of Stock By Outlet 
2026-01-19 03:47:22.7530 DFramework.Database.NullableDataReader    Data reader open for 195592
   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 D:\Spraxa\CoolR-Portal\CoolR.Tasks\ProcessAlertData.cs:line 301
   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-19 03:47:22.7530 DFramework.Database.NullableDataReader    Data reader open for 195622
   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 D:\Spraxa\CoolR-Portal\CoolR.Tasks\ProcessAlertData.cs:line 301
   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-19 03:47:23.0037 DFramework.Scheduler.TaskBase    /* Time Taken: 201377.5276*/
Process Alert Record