2026-01-15 05:03:59.0905 AlertProcessor    ProcessorAlertData: started 
2026-01-15 05:03:59.9030 DFramework.Database.Query    /* Time Taken: 759*/
DECLARE @IsComplete Int32
SET @IsComplete = '0'
SELECT TOP 1 ProductMergeTempId, PrimaryProductId, SecondaryProductId, dbo.Product.ClientId, dbo.ProductMergeTemp.UserId, [Product] AS ProductName FROM dbo.ProductMergeTemp 
				INNER JOIN dbo.Product ON dbo.Product.ProductId = dbo.ProductMergeTemp.PrimaryProductId AND dbo.Product.ClientId = dbo.ProductMergeTemp.ClientId AND dbo.Product.IsDeleted = 0
 WHERE [IsComplete] = @IsComplete
 
2026-01-15 05:03:59.9499 DFramework.Database.Query    /* Time Taken: 822*/
DECLARE @TableName AnsiString(8000)
SET @TableName = 'TagAlert'
DECLARE @CurrentRecordId Int32
SET @CurrentRecordId = '0'
dbo.GetValidDeviceForAlertProcessData 
2026-01-15 05:03:59.9967 DFramework.Database.Query    /* Time Taken: 861*/
DECLARE @OrderStatusId Int32
SET @OrderStatusId = '5486'
DECLARE @CurrentUtcDateTime DateTime2
SET @CurrentUtcDateTime = '1/15/2026 1:03:59 PM'
UPDATE Location SET ScheduledOrderId = 0, OrderStatusId = 0 FROM dbo.ScheduledOrder 
										INNER JOIN dbo.Location ON Location.ScheduledOrderId = ScheduledOrder.ScheduledOrderId AND Location.OrderStatusId = @OrderStatusId
										INNER JOIN dbo.Client On Client.ClientId = Location.ClientId
										WHERE ScheduledOrder.ModifiedOn < DATEADD(HOUR, -Client.HoursToMoveIgnored, @CurrentUtcDateTime) AND ScheduledOrder.StatusId = @OrderStatusId AND Client.HoursToMoveIgnored > 0
 
2026-01-15 05:04:00.0124 DFramework.Database.Query    /* Time Taken: 833*/
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-15 05:04:00.1374 DFramework.Database.Query    /* Time Taken: 1034*/
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/15/2026 1:03:59 PM'
DECLARE @ClientTypeId0 Int32
SET @ClientTypeId0 = '5512'
DECLARE @ClientTypeId1 Int32
SET @ClientTypeId1 = '5515'
DECLARE @AlertDefinition_AlertTypeId Int32
SET @AlertDefinition_AlertTypeId = '75'
SELECT AlertDefinitionId, AlertDefinition.AlertTypeId, Name, AlertBody, AlertDefinition.ClientId, MarketId, ClassificationId, LocationTypeId, LocationId,
														StartDate, PriorityId, LastImageThreshold, ProductCount
														FROM dbo.AlertDefinition
														INNER JOIN dbo.AlertType ON dbo.AlertType.AlertTypeId = dbo.AlertDefinition.AlertTypeId
														INNER JOIN dbo.Client ON dbo.Client.ClientId = dbo.AlertDefinition.ClientId
 WHERE Client.IsDeleted = @Client_IsDeleted AND AlertType.IsActive = @AlertType_IsActive AND AlertType.IsDeleted = @AlertType_IsDeleted AND AlertDefinition.IsActive = @AlertDefinition_IsActive AND AlertDefinition.IsDeleted = @AlertDefinition_IsDeleted AND AlertDefinition.StartDate <= @AlertDefinition_StartDate AND dbo.Client.ClientTypeId IN ( @ClientTypeId0, @ClientTypeId1 ) AND AlertDefinition.AlertTypeId = @AlertDefinition_AlertTypeId
 
2026-01-15 05:04:00.3874 DFramework.Database.Query    /* Time Taken: 1258*/
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-15 05:04:00.4186 DFramework.Database.Query    /* Time Taken: 1229*/
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/15/2026 1:03:59 PM'
SELECT TOP 1 AlertDefinitionId, PriorityId FROM AlertDefinition
 WHERE AlertDefinition.IsActive = @AlertDefinition_IsActive AND AlertDefinition.ClientId = @AlertDefinition_ClientId AND AlertDefinition.AlertTypeId = @AlertDefinition_AlertTypeId AND AlertDefinition.IsDeleted = @AlertDefinition_IsDeleted AND AlertDefinition.StartDate <= @AlertDefinition_StartDate
 
2026-01-15 05:04:00.4811 DFramework.Database.Query    /* Time Taken: 686*/
DECLARE @AssetKPIData Object
SET @AssetKPIData = ''
[dbo].BulkUpsertAssetDayKPI 
2026-01-15 05:04:00.5124 DFramework.Database.Query    /* Time Taken: 538*/
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 = '43388'
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 = '2451'
DECLARE @MarketId0 Int32
SET @MarketId0 = '0'
DECLARE @MarketId1 Int32
SET @MarketId1 = '1001'
DECLARE @ClassificationId0 Int32
SET @ClassificationId0 = '0'
DECLARE @ClassificationId1 Int32
SET @ClassificationId1 = '115'
DECLARE @LocationTypeId0 Int32
SET @LocationTypeId0 = '0'
DECLARE @LocationTypeId1 Int32
SET @LocationTypeId1 = '462'
DECLARE @LocationId0 Int32
SET @LocationId0 = '0'
DECLARE @LocationId1 Int32
SET @LocationId1 = '330335'
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-15 05:04:00.5749 DFramework.Database.Query    /* Time Taken: 1380*/
[dbo].GenerateSystemAlerts 
2026-01-15 05:04:00.6061 DFramework.Database.Query    /* Time Taken: 1428*/
DECLARE @CreatedOn Date
SET @CreatedOn = '1/15/2026 12:00:00 AM'
DECLARE @EventId Int32
SET @EventId = '-12'
SELECT COUNT(1) FROM EmailQueue
 WHERE [CreatedOn] >= @CreatedOn AND [EventId] = @EventId
 
2026-01-15 05:04:00.6374 DFramework.Database.Query    /* Time Taken: 643*/
DECLARE @OrderStatusId Int32
SET @OrderStatusId = '5484'
DECLARE @CurrentUtcDateTime DateTime2
SET @CurrentUtcDateTime = '1/15/2026 1:03:59 PM'
UPDATE Location SET ScheduledOrderId = 0, OrderStatusId = 0 FROM dbo.ScheduledOrder 
										INNER JOIN dbo.Location ON Location.ScheduledOrderId = ScheduledOrder.ScheduledOrderId AND Location.OrderStatusId = @OrderStatusId
										INNER JOIN dbo.Client On Client.ClientId = Location.ClientId
										WHERE ScheduledOrder.ModifiedOn < DATEADD(HOUR, -Client.HoursToMoveInTransit, @CurrentUtcDateTime) AND ScheduledOrder.StatusId = @OrderStatusId AND Client.HoursToMoveInTransit > 0
 
2026-01-15 05:04:00.6374 DFramework.Database.Query    /* Time Taken: 502*/
DECLARE @AlertDefinitionId Int32
SET @AlertDefinitionId = '99'
DECLARE @IsDeleted Boolean
SET @IsDeleted = 'False'
SELECT ProductId FROM AlertDefinitionProduct
 WHERE [AlertDefinitionId] = @AlertDefinitionId AND IsDeleted = @IsDeleted
 
2026-01-15 05:04:00.8405 DFramework.Database.Query    /* Time Taken: 798*/
DECLARE @AppConfigId Int32
SET @AppConfigId = '1'
SELECT * FROM AppConfig

 WHERE [AppConfigId] = @AppConfigId
 ORDER BY [AppConfigId] 
2026-01-15 05:04:00.8405 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.ProcessOutletAlertData.GetAlertDefinitions() in D:\Spraxa\CoolR-Group\portal\CoolR.Tasks\OpportunityOutOfStockByOutlet.cs:line 490
   at CoolR.Tasks.ProcessOutletAlertData.Execute() in D:\Spraxa\CoolR-Group\portal\CoolR.Tasks\OpportunityOutOfStockByOutlet.cs:line 72
   at DFramework.Scheduler.TaskBase.Run() in 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-15 05:04:01.1061 DFramework.Database.NullableDataReader    Data reader open for 356
   at System.Environment.GetStackTrace(Exception e, Boolean needFileInfo)
   at System.Environment.get_StackTrace()
   at DFramework.Database.NullableDataReader.Dispose(Boolean disposing) in 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.TagAlert(Int32 alertId, Int32 currentRecordId, DateTime latestEventTime, Int32 stockThreshold, Boolean latestAlertClosed, Int32 assetId, String alertText, Int32 alertDefinitionId, DateTime startDate, DateTime endDate, Int32 alertAgeThreshold, Int32 clientId, Int32 locationId, Int32 priorityId, List`1 alerts) in D:\Spraxa\CoolR-Group\portal\CoolR.Tasks\ProcessAlertData.cs:line 2430
   at CoolR.Tasks.ProcessAlertData.Execute() in D:\Spraxa\CoolR-Group\portal\CoolR.Tasks\ProcessAlertData.cs:line 367
   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-15 05:04:01.1061 DFramework.Database.NullableDataReader    Data reader open for 594
   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-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-15 05:04:01.6217 DFramework.Database.NullableDataReader    Data reader open for 1667
   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-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-15 05:04:02.2936 DFramework.Database.NullableDataReader    Data reader open for 356
   at System.Environment.GetStackTrace(Exception e, Boolean needFileInfo)
   at System.Environment.get_StackTrace()
   at DFramework.Database.NullableDataReader.Dispose(Boolean disposing) in 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-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-15 05:04:02.9030 DFramework.Database.NullableDataReader    Data reader open for 342
   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-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-15 05:04:03.1686 DFramework.Database.NullableDataReader    Data reader open for 1256
   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-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-15 05:04:04.1374 DFramework.Database.NullableDataReader    Data reader open for 610
   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-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-15 05:04:05.2624 DFramework.Database.NullableDataReader    Data reader open for 657
   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-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-15 05:04:05.8249 DFramework.Database.NullableDataReader    Data reader open for 204
   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-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-15 05:04:07.0124 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-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-15 05:04:07.1374 DFramework.Database.NullableDataReader    Data reader open for 1537
   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-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-15 05:04:07.7780 DFramework.Database.NullableDataReader    Data reader open for 302
   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-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-15 05:04:08.0280 DFramework.Database.NullableDataReader    Data reader open for 221
   at System.Environment.GetStackTrace(Exception e, Boolean needFileInfo)
   at System.Environment.get_StackTrace()
   at DFramework.Database.NullableDataReader.Dispose(Boolean disposing) in 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-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-15 05:04:08.5437 DFramework.Database.NullableDataReader    Data reader open for 252
   at System.Environment.GetStackTrace(Exception e, Boolean needFileInfo)
   at System.Environment.get_StackTrace()
   at DFramework.Database.NullableDataReader.Dispose(Boolean disposing) in 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-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-15 05:04:08.8405 DFramework.Database.NullableDataReader    Data reader open for 250
   at System.Environment.GetStackTrace(Exception e, Boolean needFileInfo)
   at System.Environment.get_StackTrace()
   at DFramework.Database.NullableDataReader.Dispose(Boolean disposing) in C:\CoolR-Group\Framework\DFramework\Database\NullableDataReader.cs:line 33
   at DFramework.Database.NullableDataReader.Dispose() in C:\CoolR-Group\Framework\DFramework\Database\NullableDataReader.cs:line 44
   at CoolR.Tasks.ProcessAlertData.Execute() in D:\Spraxa\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-15 05:04:08.9499 DFramework.Database.NullableDataReader    Data reader open for 1501
   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-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-15 05:04:09.6530 DFramework.Database.NullableDataReader    Data reader open for 311
   at System.Environment.GetStackTrace(Exception e, Boolean needFileInfo)
   at System.Environment.get_StackTrace()
   at DFramework.Database.NullableDataReader.Dispose(Boolean disposing) in C:\CoolR-Group\Framework\DFramework\Database\NullableDataReader.cs:line 33
   at DFramework.Database.NullableDataReader.Dispose() in C:\CoolR-Group\Framework\DFramework\Database\NullableDataReader.cs:line 44
   at CoolR.Tasks.ProcessAlertData.Execute() in D:\Spraxa\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-15 05:04:10.1843 DFramework.Database.NullableDataReader    Data reader open for 281
   at System.Environment.GetStackTrace(Exception e, Boolean needFileInfo)
   at System.Environment.get_StackTrace()
   at DFramework.Database.NullableDataReader.Dispose(Boolean disposing) in 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-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-15 05:04:10.5281 DFramework.Database.NullableDataReader    Data reader open for 282
   at System.Environment.GetStackTrace(Exception e, Boolean needFileInfo)
   at System.Environment.get_StackTrace()
   at DFramework.Database.NullableDataReader.Dispose(Boolean disposing) in C:\CoolR-Group\Framework\DFramework\Database\NullableDataReader.cs:line 33
   at DFramework.Database.NullableDataReader.Dispose() in C:\CoolR-Group\Framework\DFramework\Database\NullableDataReader.cs:line 44
   at CoolR.Tasks.ProcessAlertData.Execute() in D:\Spraxa\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-15 05:04:10.6374 DFramework.Database.NullableDataReader    Data reader open for 1355
   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-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-15 05:04:11.2312 DFramework.Database.Query    /* Time Taken: 585*/
DECLARE @TableName AnsiString(8000)
SET @TableName = 'AssetStockProductWiseConsolidate'
DECLARE @CurrentRecordId Int32
SET @CurrentRecordId = '3676187'
dbo.GetValidDeviceForAlertProcessData 
2026-01-15 05:04:16.3250 DFramework.Scheduler.TaskBase    /* Time Taken: 17234.5015*/
Opportunity Out Of Stock By Outlet 
2026-01-15 05:06:23.2320 DFramework.Database.NullableDataReader    Data reader open for 131425
   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-Group\portal\CoolR.Tasks\ProcessAlertData.cs:line 343
   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-15 05:06:23.2320 DFramework.Database.NullableDataReader    Data reader open for 131482
   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-Group\portal\CoolR.Tasks\ProcessAlertData.cs:line 343
   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-15 05:06:23.4977 DFramework.Scheduler.TaskBase    /* Time Taken: 144407.1994*/
Process Alert Record 
2026-01-15 05:09:01.6861 AlertProcessor    ProcessorAlertData: started 
2026-01-15 05:09:02.3424 DFramework.Database.Query    /* Time Taken: 572*/
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-15 05:09:02.4049 DFramework.Database.Query    /* Time Taken: 628*/
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/15/2026 1:09:01 PM'
SELECT TOP 1 AlertDefinitionId, PriorityId FROM AlertDefinition
 WHERE AlertDefinition.IsActive = @AlertDefinition_IsActive AND AlertDefinition.ClientId = @AlertDefinition_ClientId AND AlertDefinition.AlertTypeId = @AlertDefinition_AlertTypeId AND AlertDefinition.IsDeleted = @AlertDefinition_IsDeleted AND AlertDefinition.StartDate <= @AlertDefinition_StartDate
 
2026-01-15 05:09:02.4518 DFramework.Database.Query    /* Time Taken: 704*/
DECLARE @OrderStatusId Int32
SET @OrderStatusId = '5486'
DECLARE @CurrentUtcDateTime DateTime2
SET @CurrentUtcDateTime = '1/15/2026 1:09:01 PM'
UPDATE Location SET ScheduledOrderId = 0, OrderStatusId = 0 FROM dbo.ScheduledOrder 
										INNER JOIN dbo.Location ON Location.ScheduledOrderId = ScheduledOrder.ScheduledOrderId AND Location.OrderStatusId = @OrderStatusId
										INNER JOIN dbo.Client On Client.ClientId = Location.ClientId
										WHERE ScheduledOrder.ModifiedOn < DATEADD(HOUR, -Client.HoursToMoveIgnored, @CurrentUtcDateTime) AND ScheduledOrder.StatusId = @OrderStatusId AND Client.HoursToMoveIgnored > 0
 
2026-01-15 05:09:02.6549 DFramework.Database.Query    /* Time Taken: 935*/
DECLARE @TableName AnsiString(8000)
SET @TableName = 'TagAlert'
DECLARE @CurrentRecordId Int32
SET @CurrentRecordId = '0'
dbo.GetValidDeviceForAlertProcessData 
2026-01-15 05:09:02.7330 DFramework.Database.Query    /* Time Taken: 1017*/
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-15 05:09:02.7643 DFramework.Database.Query    /* Time Taken: 1070*/
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/15/2026 1:09:01 PM'
DECLARE @ClientTypeId0 Int32
SET @ClientTypeId0 = '5512'
DECLARE @ClientTypeId1 Int32
SET @ClientTypeId1 = '5515'
DECLARE @AlertDefinition_AlertTypeId Int32
SET @AlertDefinition_AlertTypeId = '75'
SELECT AlertDefinitionId, AlertDefinition.AlertTypeId, Name, AlertBody, AlertDefinition.ClientId, MarketId, ClassificationId, LocationTypeId, LocationId,
														StartDate, PriorityId, LastImageThreshold, ProductCount
														FROM dbo.AlertDefinition
														INNER JOIN dbo.AlertType ON dbo.AlertType.AlertTypeId = dbo.AlertDefinition.AlertTypeId
														INNER JOIN dbo.Client ON dbo.Client.ClientId = dbo.AlertDefinition.ClientId
 WHERE Client.IsDeleted = @Client_IsDeleted AND AlertType.IsActive = @AlertType_IsActive AND AlertType.IsDeleted = @AlertType_IsDeleted AND AlertDefinition.IsActive = @AlertDefinition_IsActive AND AlertDefinition.IsDeleted = @AlertDefinition_IsDeleted AND AlertDefinition.StartDate <= @AlertDefinition_StartDate AND dbo.Client.ClientTypeId IN ( @ClientTypeId0, @ClientTypeId1 ) AND AlertDefinition.AlertTypeId = @AlertDefinition_AlertTypeId
 
2026-01-15 05:09:02.8893 DFramework.Database.Query    /* Time Taken: 1119*/
DECLARE @CreatedOn Date
SET @CreatedOn = '1/15/2026 12:00:00 AM'
DECLARE @EventId Int32
SET @EventId = '-12'
SELECT COUNT(1) FROM EmailQueue
 WHERE [CreatedOn] >= @CreatedOn AND [EventId] = @EventId
 
2026-01-15 05:09:02.9205 DFramework.Database.Query    /* Time Taken: 545*/
DECLARE @AppConfigId Int32
SET @AppConfigId = '1'
SELECT * FROM AppConfig

 WHERE [AppConfigId] = @AppConfigId
 ORDER BY [AppConfigId] 
2026-01-15 05:09:02.9674 DFramework.Database.Query    /* Time Taken: 559*/
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-15 05:09:03.0299 DFramework.Database.Query    /* Time Taken: 578*/
DECLARE @OrderStatusId Int32
SET @OrderStatusId = '5484'
DECLARE @CurrentUtcDateTime DateTime2
SET @CurrentUtcDateTime = '1/15/2026 1:09:02 PM'
UPDATE Location SET ScheduledOrderId = 0, OrderStatusId = 0 FROM dbo.ScheduledOrder 
										INNER JOIN dbo.Location ON Location.ScheduledOrderId = ScheduledOrder.ScheduledOrderId AND Location.OrderStatusId = @OrderStatusId
										INNER JOIN dbo.Client On Client.ClientId = Location.ClientId
										WHERE ScheduledOrder.ModifiedOn < DATEADD(HOUR, -Client.HoursToMoveInTransit, @CurrentUtcDateTime) AND ScheduledOrder.StatusId = @OrderStatusId AND Client.HoursToMoveInTransit > 0
 
2026-01-15 05:09:03.0768 DFramework.Database.Query    /* Time Taken: 1290*/
[dbo].GenerateSystemAlerts 
2026-01-15 05:09:03.1549 DFramework.Database.Query    /* Time Taken: 832*/
DECLARE @AssetKPIData Object
SET @AssetKPIData = ''
[dbo].BulkUpsertAssetDayKPI 
2026-01-15 05:09:03.2799 DFramework.Database.NullableDataReader    Data reader open for 500
   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-15 05:09:03.3112 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-15 05:09:03.8424 DFramework.Database.NullableDataReader    Data reader open for 1190
   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-15 05:09:04.4987 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 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-15 05:09:04.7330 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 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-15 05:09:04.9830 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-15 05:09:05.2330 DFramework.Database.NullableDataReader    Data reader open for 222
   at System.Environment.GetStackTrace(Exception e, Boolean needFileInfo)
   at System.Environment.get_StackTrace()
   at DFramework.Database.NullableDataReader.Dispose(Boolean disposing) in 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-15 05:09:05.2955 DFramework.Database.NullableDataReader    Data reader open for 1163
   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-15 05:09:05.6862 AlertProcessor    Adding alert for MissingShelf 
2026-01-15 05:09:05.7487 AlertProcessor    Added missing shelf alert for asset: 43388, alerts count: 21 
2026-01-15 05:09:05.7487 AlertProcessor    Adding alert for MissingShelf 
2026-01-15 05:09:05.8737 AlertProcessor    Added missing shelf alert for asset: 56019, alerts count: 21 
2026-01-15 05:09:05.8737 AlertProcessor    Adding alert for MissingShelf 
2026-01-15 05:09:05.9362 AlertProcessor    Added missing shelf alert for asset: 118115, alerts count: 21 
2026-01-15 05:09:05.9362 AlertProcessor    Adding alert for MissingShelf 
2026-01-15 05:09:06.0299 AlertProcessor    Added missing shelf alert for asset: 118434, alerts count: 21 
2026-01-15 05:09:06.0299 AlertProcessor    Adding alert for MissingShelf 
2026-01-15 05:09:06.1237 AlertProcessor    Added missing shelf alert for asset: 118445, alerts count: 22 
2026-01-15 05:09:06.1237 AlertProcessor    Adding alert for MissingShelf 
2026-01-15 05:09:06.2018 AlertProcessor    Added missing shelf alert for asset: 118448, alerts count: 22 
2026-01-15 05:09:06.2018 AlertProcessor    Adding alert for MissingShelf 
2026-01-15 05:09:06.2955 AlertProcessor    Added missing shelf alert for asset: 118471, alerts count: 22 
2026-01-15 05:09:06.3580 DFramework.Database.NullableDataReader    Data reader open for 663
   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-15 05:09:06.7174 AlertProcessor    Adding alert for AdditionalShelf 
2026-01-15 05:09:06.7955 AlertProcessor    Added additional shelf alert for asset: 43388, alerts count: 23 
2026-01-15 05:09:06.8112 AlertProcessor    Adding alert for AdditionalShelf 
2026-01-15 05:09:06.9205 AlertProcessor    Added additional shelf alert for asset: 56019, alerts count: 23 
2026-01-15 05:09:06.9205 AlertProcessor    Adding alert for AdditionalShelf 
2026-01-15 05:09:07.0143 AlertProcessor    Added additional shelf alert for asset: 118115, alerts count: 24 
2026-01-15 05:09:07.0143 AlertProcessor    Adding alert for AdditionalShelf 
2026-01-15 05:09:07.1080 AlertProcessor    Added additional shelf alert for asset: 118434, alerts count: 24 
2026-01-15 05:09:07.1080 AlertProcessor    Adding alert for AdditionalShelf 
2026-01-15 05:09:07.1706 AlertProcessor    Added additional shelf alert for asset: 118445, alerts count: 24 
2026-01-15 05:09:07.1706 AlertProcessor    Adding alert for AdditionalShelf 
2026-01-15 05:09:07.2487 AlertProcessor    Added additional shelf alert for asset: 118448, alerts count: 24 
2026-01-15 05:09:07.2487 AlertProcessor    Adding alert for AdditionalShelf 
2026-01-15 05:09:07.3424 AlertProcessor    Added additional shelf alert for asset: 118471, alerts count: 24 
2026-01-15 05:09:07.4049 DFramework.Database.NullableDataReader    Data reader open for 691
   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-15 05:09:07.9674 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 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-15 05:09:08.2018 DFramework.Database.NullableDataReader    Data reader open for 201
   at System.Environment.GetStackTrace(Exception e, Boolean needFileInfo)
   at System.Environment.get_StackTrace()
   at DFramework.Database.NullableDataReader.Dispose(Boolean disposing) in 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-15 05:09:08.4206 DFramework.Database.NullableDataReader    Data reader open for 201
   at System.Environment.GetStackTrace(Exception e, Boolean needFileInfo)
   at System.Environment.get_StackTrace()
   at DFramework.Database.NullableDataReader.Dispose(Boolean disposing) in 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-15 05:09:08.6706 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 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-15 05:09:09.1862 DFramework.Database.NullableDataReader    Data reader open for 228
   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-15 05:09:09.3112 DFramework.Database.NullableDataReader    Data reader open for 1579
   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-15 05:09:09.9518 DFramework.Database.NullableDataReader    Data reader open for 294
   at System.Environment.GetStackTrace(Exception e, Boolean needFileInfo)
   at System.Environment.get_StackTrace()
   at DFramework.Database.NullableDataReader.Dispose(Boolean disposing) in 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-15 05:09:10.2174 DFramework.Database.NullableDataReader    Data reader open for 229
   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-15 05:09:10.7331 DFramework.Database.NullableDataReader    Data reader open for 253
   at System.Environment.GetStackTrace(Exception e, Boolean needFileInfo)
   at System.Environment.get_StackTrace()
   at DFramework.Database.NullableDataReader.Dispose(Boolean disposing) in 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-15 05:09:11.0456 DFramework.Database.NullableDataReader    Data reader open for 254
   at System.Environment.GetStackTrace(Exception e, Boolean needFileInfo)
   at System.Environment.get_StackTrace()
   at DFramework.Database.NullableDataReader.Dispose(Boolean disposing) in 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-15 05:09:11.1706 DFramework.Database.NullableDataReader    Data reader open for 1548
   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-15 05:09:11.8581 DFramework.Database.NullableDataReader    Data reader open for 305
   at System.Environment.GetStackTrace(Exception e, Boolean needFileInfo)
   at System.Environment.get_StackTrace()
   at DFramework.Database.NullableDataReader.Dispose(Boolean disposing) in C:\CoolR-Group\Framework\DFramework\Database\NullableDataReader.cs:line 33
   at DFramework.Database.NullableDataReader.Dispose() in C:\CoolR-Group\Framework\DFramework\Database\NullableDataReader.cs:line 44
   at CoolR.Tasks.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-15 05:09:12.4050 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 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-15 05:09:12.7487 DFramework.Database.NullableDataReader    Data reader open for 284
   at System.Environment.GetStackTrace(Exception e, Boolean needFileInfo)
   at System.Environment.get_StackTrace()
   at DFramework.Database.NullableDataReader.Dispose(Boolean disposing) in 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-15 05:09:12.8737 DFramework.Database.NullableDataReader    Data reader open for 1375
   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-15 05:09:13.4362 DFramework.Database.Query    /* Time Taken: 567*/
DECLARE @TableName AnsiString(8000)
SET @TableName = 'AssetStockProductWiseConsolidate'
DECLARE @CurrentRecordId Int32
SET @CurrentRecordId = '3676187'
dbo.GetValidDeviceForAlertProcessData 
2026-01-15 05:09:18.7487 DFramework.Scheduler.TaskBase    /* Time Taken: 17078.233*/
Opportunity Out Of Stock By Outlet 
2026-01-15 05:24:02.0199 DFramework.Database.NullableDataReader    Data reader open for 305
   at System.Environment.GetStackTrace(Exception e, Boolean needFileInfo)
   at System.Environment.get_StackTrace()
   at DFramework.Database.NullableDataReader.Dispose(Boolean disposing) in C:\CoolR-Group\Framework\DFramework\Database\NullableDataReader.cs:line 33
   at DFramework.Database.NullableDataReader.Dispose() in C:\CoolR-Group\Framework\DFramework\Database\NullableDataReader.cs:line 44
   at CoolR.Tasks.ProcessOutletAlertData.GetAlertDefinitions() in C:\CoolR-Group\portal\CoolR.Tasks\OpportunityOutOfStockByOutlet.cs:line 490
   at CoolR.Tasks.ProcessOutletAlertData.Execute() in C:\CoolR-Group\portal\CoolR.Tasks\OpportunityOutOfStockByOutlet.cs:line 72
   at DFramework.Scheduler.TaskBase.Run() in E:\Forked\Framework\DFramework.Scheduler\TaskBase.cs:line 176
   at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)
   at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)
   at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state)
   at System.Threading.ThreadHelper.ThreadStart() 
2026-01-15 05:24:02.3792 DFramework.Database.Query    /* Time Taken: 577*/
[dbo].GenerateSystemAlerts 
2026-01-15 05:24:17.4418 DFramework.Scheduler.TaskBase    /* Time Taken: 15750.0887*/
Opportunity Out Of Stock By Outlet 
2026-01-15 05:35:36.7897 DFramework.Database.NullableDataReader    Data reader open for 1582746
   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 346
   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-15 05:35:36.7897 DFramework.Database.NullableDataReader    Data reader open for 1582808
   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 346
   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-15 05:35:37.1022 DFramework.Scheduler.TaskBase    /* Time Taken: 1595431.6965*/
Process Alert Record 
2026-01-15 06:24:27.2299 AlertProcessor    ProcessorAlertData: started 
2026-01-15 06:24:27.8080 DFramework.Database.Query    /* Time Taken: 555*/
DECLARE @IsComplete Int32
SET @IsComplete = '0'
SELECT TOP 1 ProductMergeTempId, PrimaryProductId, SecondaryProductId, dbo.Product.ClientId, dbo.ProductMergeTemp.UserId, [Product] AS ProductName FROM dbo.ProductMergeTemp 
				INNER JOIN dbo.Product ON dbo.Product.ProductId = dbo.ProductMergeTemp.PrimaryProductId AND dbo.Product.ClientId = dbo.ProductMergeTemp.ClientId AND dbo.Product.IsDeleted = 0
 WHERE [IsComplete] = @IsComplete
 
2026-01-15 06:24:27.8549 DFramework.Database.Query    /* Time Taken: 554*/
DECLARE @CreatedOn Date
SET @CreatedOn = '1/15/2026 12:00:00 AM'
DECLARE @EventId Int32
SET @EventId = '-12'
SELECT COUNT(1) FROM EmailQueue
 WHERE [CreatedOn] >= @CreatedOn AND [EventId] = @EventId
 
2026-01-15 06:24:27.9330 DFramework.Database.Query    /* Time Taken: 638*/
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-15 06:24:28.1206 DFramework.Database.Query    /* Time Taken: 874*/
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-15 06:24:28.2143 DFramework.Database.Query    /* Time Taken: 948*/
DECLARE @OrderStatusId Int32
SET @OrderStatusId = '5486'
DECLARE @CurrentUtcDateTime DateTime2
SET @CurrentUtcDateTime = '1/15/2026 2:24:27 PM'
UPDATE Location SET ScheduledOrderId = 0, OrderStatusId = 0 FROM dbo.ScheduledOrder 
										INNER JOIN dbo.Location ON Location.ScheduledOrderId = ScheduledOrder.ScheduledOrderId AND Location.OrderStatusId = @OrderStatusId
										INNER JOIN dbo.Client On Client.ClientId = Location.ClientId
										WHERE ScheduledOrder.ModifiedOn < DATEADD(HOUR, -Client.HoursToMoveIgnored, @CurrentUtcDateTime) AND ScheduledOrder.StatusId = @OrderStatusId AND Client.HoursToMoveIgnored > 0
 
2026-01-15 06:24:28.5268 DFramework.Database.Query    /* Time Taken: 1275*/
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/15/2026 2:24:27 PM'
DECLARE @ClientTypeId0 Int32
SET @ClientTypeId0 = '5512'
DECLARE @ClientTypeId1 Int32
SET @ClientTypeId1 = '5515'
DECLARE @AlertDefinition_AlertTypeId Int32
SET @AlertDefinition_AlertTypeId = '75'
SELECT AlertDefinitionId, AlertDefinition.AlertTypeId, Name, AlertBody, AlertDefinition.ClientId, MarketId, ClassificationId, LocationTypeId, LocationId,
														StartDate, PriorityId, LastImageThreshold, ProductCount
														FROM dbo.AlertDefinition
														INNER JOIN dbo.AlertType ON dbo.AlertType.AlertTypeId = dbo.AlertDefinition.AlertTypeId
														INNER JOIN dbo.Client ON dbo.Client.ClientId = dbo.AlertDefinition.ClientId
 WHERE Client.IsDeleted = @Client_IsDeleted AND AlertType.IsActive = @AlertType_IsActive AND AlertType.IsDeleted = @AlertType_IsDeleted AND AlertDefinition.IsActive = @AlertDefinition_IsActive AND AlertDefinition.IsDeleted = @AlertDefinition_IsDeleted AND AlertDefinition.StartDate <= @AlertDefinition_StartDate AND dbo.Client.ClientTypeId IN ( @ClientTypeId0, @ClientTypeId1 ) AND AlertDefinition.AlertTypeId = @AlertDefinition_AlertTypeId
 
2026-01-15 06:24:28.9174 DFramework.Database.NullableDataReader    Data reader open for 389
   at System.Environment.GetStackTrace(Exception e, Boolean needFileInfo)
   at System.Environment.get_StackTrace()
   at DFramework.Database.NullableDataReader.Dispose(Boolean disposing) in 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-15 06:24:28.9487 DFramework.Database.Query    /* Time Taken: 1657*/
DECLARE @TableName AnsiString(8000)
SET @TableName = 'TagAlert'
DECLARE @CurrentRecordId Int32
SET @CurrentRecordId = '0'
dbo.GetValidDeviceForAlertProcessData 
2026-01-15 06:24:29.3706 MoveToReorder    Running task for ClientId : 286 and ClientName = India Office QA and Slot: 1/15/2026 7:00:00 PM And LastExecutedOn: 1/15/2026 6:04:02 PM 
2026-01-15 06:24:29.3862 DFramework.Database.Query    /* Time Taken: 2079*/
[dbo].GenerateSystemAlerts 
2026-01-15 06:24:29.4487 DFramework.Database.NullableDataReader    Data reader open for 456
   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-15 06:24:30.3237 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.TagAlert(Int32 alertId, Int32 currentRecordId, DateTime latestEventTime, Int32 stockThreshold, Boolean latestAlertClosed, Int32 assetId, String alertText, Int32 alertDefinitionId, DateTime startDate, DateTime endDate, Int32 alertAgeThreshold, Int32 clientId, Int32 locationId, Int32 priorityId, List`1 alerts) in C:\CoolR-Group\portal\CoolR.Tasks\ProcessAlertData.cs:line 2435
   at CoolR.Tasks.ProcessAlertData.Execute() in C:\CoolR-Group\portal\CoolR.Tasks\ProcessAlertData.cs:line 370
   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-15 06:24:30.3237 DFramework.Database.NullableDataReader    Data reader open for 311
   at System.Environment.GetStackTrace(Exception e, Boolean needFileInfo)
   at System.Environment.get_StackTrace()
   at DFramework.Database.NullableDataReader.Dispose(Boolean disposing) in C:\CoolR-Group\Framework\DFramework\Database\NullableDataReader.cs:line 33
   at DFramework.Database.NullableDataReader.Dispose() in C:\CoolR-Group\Framework\DFramework\Database\NullableDataReader.cs:line 44
   at CoolR.Tasks.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-15 06:24:30.4174 DFramework.Database.NullableDataReader    Data reader open for 1477
   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-15 06:24:31.1362 DFramework.Database.NullableDataReader    Data reader open for 356
   at System.Environment.GetStackTrace(Exception e, Boolean needFileInfo)
   at System.Environment.get_StackTrace()
   at DFramework.Database.NullableDataReader.Dispose(Boolean disposing) in 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-15 06:24:31.3862 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 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-15 06:24:31.6674 DFramework.Database.NullableDataReader    Data reader open for 237
   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-15 06:24:31.9018 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 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-15 06:24:32.1518 DFramework.Database.NullableDataReader    Data reader open for 218
   at System.Environment.GetStackTrace(Exception e, Boolean needFileInfo)
   at System.Environment.get_StackTrace()
   at DFramework.Database.NullableDataReader.Dispose(Boolean disposing) in 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-15 06:24:32.2612 DFramework.Database.NullableDataReader    Data reader open for 1516
   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-15 06:24:32.6518 AlertProcessor    Adding alert for MissingShelf 
2026-01-15 06:24:32.7143 AlertProcessor    Added missing shelf alert for asset: 43388, alerts count: 22 
2026-01-15 06:24:32.7143 AlertProcessor    Adding alert for MissingShelf 
2026-01-15 06:24:32.8393 AlertProcessor    Added missing shelf alert for asset: 56019, alerts count: 22 
2026-01-15 06:24:32.8393 AlertProcessor    Adding alert for MissingShelf 
2026-01-15 06:24:32.9018 AlertProcessor    Added missing shelf alert for asset: 118115, alerts count: 22 
2026-01-15 06:24:32.9018 AlertProcessor    Adding alert for MissingShelf 
2026-01-15 06:24:32.9956 AlertProcessor    Added missing shelf alert for asset: 118196, alerts count: 22 
2026-01-15 06:24:32.9956 AlertProcessor    Adding alert for MissingShelf 
2026-01-15 06:24:33.0893 AlertProcessor    Added missing shelf alert for asset: 118434, alerts count: 22 
2026-01-15 06:24:33.0893 AlertProcessor    Adding alert for MissingShelf 
2026-01-15 06:24:33.1831 AlertProcessor    Added missing shelf alert for asset: 118445, alerts count: 22 
2026-01-15 06:24:33.1831 AlertProcessor    Adding alert for MissingShelf 
2026-01-15 06:24:33.2612 AlertProcessor    Added missing shelf alert for asset: 118448, alerts count: 22 
2026-01-15 06:24:33.2612 AlertProcessor    Adding alert for MissingShelf 
2026-01-15 06:24:33.3550 AlertProcessor    Added missing shelf alert for asset: 118471, alerts count: 22 
2026-01-15 06:24:33.3550 AlertProcessor    Adding alert for MissingShelf 
2026-01-15 06:24:33.4487 AlertProcessor    Added missing shelf alert for asset: 118560, alerts count: 22 
2026-01-15 06:24:33.5112 DFramework.Database.NullableDataReader    Data reader open for 858
   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-15 06:24:34.0737 DFramework.Database.Query    /* Time Taken: 564*/
DECLARE @TableName AnsiString(8000)
SET @TableName = 'AdditionalShelf'
DECLARE @CurrentRecordId Int32
SET @CurrentRecordId = '3676207'
dbo.GetValidDeviceForAlertProcessData 
2026-01-15 06:24:34.0737 AlertProcessor    Adding alert for AdditionalShelf 
2026-01-15 06:24:34.1675 AlertProcessor    Added additional shelf alert for asset: 43388, alerts count: 23 
2026-01-15 06:24:34.1675 AlertProcessor    Adding alert for AdditionalShelf 
2026-01-15 06:24:34.2925 AlertProcessor    Added additional shelf alert for asset: 56019, alerts count: 23 
2026-01-15 06:24:34.2925 AlertProcessor    Adding alert for AdditionalShelf 
2026-01-15 06:24:34.3862 AlertProcessor    Added additional shelf alert for asset: 118115, alerts count: 24 
2026-01-15 06:24:34.3862 AlertProcessor    Adding alert for AdditionalShelf 
2026-01-15 06:24:34.4800 AlertProcessor    Added additional shelf alert for asset: 118196, alerts count: 24 
2026-01-15 06:24:34.4800 AlertProcessor    Adding alert for AdditionalShelf 
2026-01-15 06:24:34.5737 AlertProcessor    Added additional shelf alert for asset: 118434, alerts count: 24 
2026-01-15 06:24:34.5737 AlertProcessor    Adding alert for AdditionalShelf 
2026-01-15 06:24:34.6675 AlertProcessor    Added additional shelf alert for asset: 118445, alerts count: 24 
2026-01-15 06:24:34.6675 AlertProcessor    Adding alert for AdditionalShelf 
2026-01-15 06:24:34.7456 AlertProcessor    Added additional shelf alert for asset: 118448, alerts count: 24 
2026-01-15 06:24:34.7612 AlertProcessor    Adding alert for AdditionalShelf 
2026-01-15 06:24:34.8393 AlertProcessor    Added additional shelf alert for asset: 118471, alerts count: 24 
2026-01-15 06:24:34.8393 AlertProcessor    Adding alert for AdditionalShelf 
2026-01-15 06:24:34.9331 AlertProcessor    Added additional shelf alert for asset: 118560, alerts count: 24 
2026-01-15 06:24:34.9956 DFramework.Database.NullableDataReader    Data reader open for 917
   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-15 06:24:35.5893 DFramework.Database.NullableDataReader    Data reader open for 228
   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-15 06:24:35.8706 DFramework.Database.NullableDataReader    Data reader open for 243
   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-15 06:24:36.1050 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 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-15 06:24:36.3550 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 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-15 06:24:36.6362 DFramework.Database.NullableDataReader    Data reader open for 217
   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-15 06:24:36.8862 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 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-15 06:24:37.1987 DFramework.Database.NullableDataReader    Data reader open for 251
   at System.Environment.GetStackTrace(Exception e, Boolean needFileInfo)
   at System.Environment.get_StackTrace()
   at DFramework.Database.NullableDataReader.Dispose(Boolean disposing) in 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-15 06:24:37.3237 DFramework.Database.NullableDataReader    Data reader open for 1995
   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-15 06:24:38.0112 DFramework.Database.NullableDataReader    Data reader open for 309
   at System.Environment.GetStackTrace(Exception e, Boolean needFileInfo)
   at System.Environment.get_StackTrace()
   at DFramework.Database.NullableDataReader.Dispose(Boolean disposing) in C:\CoolR-Group\Framework\DFramework\Database\NullableDataReader.cs:line 33
   at DFramework.Database.NullableDataReader.Dispose() in C:\CoolR-Group\Framework\DFramework\Database\NullableDataReader.cs:line 44
   at CoolR.Tasks.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-15 06:24:38.2769 DFramework.Database.NullableDataReader    Data reader open for 243
   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-15 06:24:38.5581 DFramework.Database.NullableDataReader    Data reader open for 244
   at System.Environment.GetStackTrace(Exception e, Boolean needFileInfo)
   at System.Environment.get_StackTrace()
   at DFramework.Database.NullableDataReader.Dispose(Boolean disposing) in 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-15 06:24:38.8394 DFramework.Database.NullableDataReader    Data reader open for 246
   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-15 06:24:39.3237 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 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-15 06:24:39.6675 DFramework.Database.NullableDataReader    Data reader open for 286
   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-15 06:24:39.7925 DFramework.Database.NullableDataReader    Data reader open for 2125
   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-15 06:24:40.5737 DFramework.Database.NullableDataReader    Data reader open for 394
   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-15 06:24:41.1363 DFramework.Database.NullableDataReader    Data reader open for 516
   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-15 06:24:41.4644 DFramework.Database.NullableDataReader    Data reader open for 306
   at System.Environment.GetStackTrace(Exception e, Boolean needFileInfo)
   at System.Environment.get_StackTrace()
   at DFramework.Database.NullableDataReader.Dispose(Boolean disposing) in C:\CoolR-Group\Framework\DFramework\Database\NullableDataReader.cs:line 33
   at DFramework.Database.NullableDataReader.Dispose() in C:\CoolR-Group\Framework\DFramework\Database\NullableDataReader.cs:line 44
   at CoolR.Tasks.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-15 06:24:41.9488 DFramework.Database.NullableDataReader    Data reader open for 306
   at System.Environment.GetStackTrace(Exception e, Boolean needFileInfo)
   at System.Environment.get_StackTrace()
   at DFramework.Database.NullableDataReader.Dispose(Boolean disposing) in C:\CoolR-Group\Framework\DFramework\Database\NullableDataReader.cs:line 33
   at DFramework.Database.NullableDataReader.Dispose() in C:\CoolR-Group\Framework\DFramework\Database\NullableDataReader.cs:line 44
   at CoolR.Tasks.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-15 06:24:42.3238 DFramework.Database.NullableDataReader    Data reader open for 306
   at System.Environment.GetStackTrace(Exception e, Boolean needFileInfo)
   at System.Environment.get_StackTrace()
   at DFramework.Database.NullableDataReader.Dispose(Boolean disposing) in C:\CoolR-Group\Framework\DFramework\Database\NullableDataReader.cs:line 33
   at DFramework.Database.NullableDataReader.Dispose() in C:\CoolR-Group\Framework\DFramework\Database\NullableDataReader.cs:line 44
   at CoolR.Tasks.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-15 06:24:42.4488 DFramework.Database.NullableDataReader    Data reader open for 2324
   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-15 06:24:43.0425 DFramework.Database.Query    /* Time Taken: 593*/
DECLARE @TableName AnsiString(8000)
SET @TableName = 'AssetStockProductWiseConsolidate'
DECLARE @CurrentRecordId Int32
SET @CurrentRecordId = '3676207'
dbo.GetValidDeviceForAlertProcessData 
2026-01-15 06:24:43.2925 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-15 06:24:45.5113 DFramework.Scheduler.TaskBase    /* Time Taken: 18281.3556*/
Opportunity Out Of Stock By Outlet 
2026-01-15 06:25:14.8865 DFramework.Database.NullableDataReader    Data reader open for 45012
   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-15 06:25:14.9177 MoveToReorder    Task executed successfully for ClientId : 286 Client Name:India Office QA, Slot: 1/15/2026 7:00:00 PM and Total Order Suggested: 126 Out Of: 126 
2026-01-15 06:25:16.2302 DFramework.Scheduler.TaskBase    /* Time Taken: 49000.2974*/
Move To Re-Order 
2026-01-15 06:34:27.8903 MoveToReorder    Running task for ClientId : 286 and ClientName = India Office QA and Slot: 1/15/2026 8:00:00 PM And LastExecutedOn: 1/15/2026 7:54:29 PM 
2026-01-15 06:34:28.1246 MoveToReorder    Task executed successfully for ClientId : 286 Client Name:India Office QA, Slot: 1/15/2026 8:00:00 PM But No Order found to suggest 
2026-01-15 06:39:42.8765 DFramework.Scheduler.TaskBase    /* Time Taken: 15640.7445*/
Opportunity Out Of Stock By Outlet 
2026-01-15 06:54:27.7883 DFramework.Database.NullableDataReader    Data reader open for 506
   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-15 06:54:27.8508 DFramework.Database.Query    /* Time Taken: 533*/
[dbo].GenerateSystemAlerts 
2026-01-15 06:54:43.2728 DFramework.Scheduler.TaskBase    /* Time Taken: 16015.7209*/
Opportunity Out Of Stock By Outlet 
2026-01-15 07:09:27.8722 DFramework.Database.Query    /* Time Taken: 545*/
[dbo].GenerateSystemAlerts 
2026-01-15 07:09:27.9972 DFramework.Database.NullableDataReader    Data reader open for 699
   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-15 07:09:43.4660 DFramework.Scheduler.TaskBase    /* Time Taken: 16187.5989*/
Opportunity Out Of Stock By Outlet 
2026-01-15 07:24:27.8935 DFramework.Database.Query    /* Time Taken: 553*/
[dbo].GenerateSystemAlerts 
2026-01-15 07:24:43.2999 DFramework.Scheduler.TaskBase    /* Time Taken: 16000.0934*/
Opportunity Out Of Stock By Outlet 
2026-01-15 07:34:27.9128 MoveToReorder    Running task for ClientId : 286 and ClientName = India Office QA and Slot: 1/15/2026 9:00:00 PM And LastExecutedOn: 1/15/2026 8:04:27 PM 
2026-01-15 07:34:28.1472 MoveToReorder    Task executed successfully for ClientId : 286 Client Name:India Office QA, Slot: 1/15/2026 9:00:00 PM But No Order found to suggest 
2026-01-15 07:39:28.0867 DFramework.Database.Query    /* Time Taken: 724*/
[dbo].GenerateSystemAlerts 
2026-01-15 07:39:42.9149 DFramework.Scheduler.TaskBase    /* Time Taken: 15593.855*/
Opportunity Out Of Stock By Outlet 
2026-01-15 07:54:27.9204 DFramework.Database.Query    /* Time Taken: 537*/
[dbo].GenerateSystemAlerts 
2026-01-15 07:54:27.9360 DFramework.Database.NullableDataReader    Data reader open for 556
   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-15 07:54:43.3736 DFramework.Scheduler.TaskBase    /* Time Taken: 16031.352*/
Opportunity Out Of Stock By Outlet 
2026-01-15 08:09:27.9417 DFramework.Database.Query    /* Time Taken: 531*/
[dbo].GenerateSystemAlerts 
2026-01-15 08:09:28.0823 DFramework.Database.NullableDataReader    Data reader open for 704
   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-15 08:09:43.5355 DFramework.Scheduler.TaskBase    /* Time Taken: 16171.9969*/
Opportunity Out Of Stock By Outlet 
2026-01-15 08:14:30.4124 CoolR.Tasks.MergeProductsTask    AssetPurity related Tables are updated for primaryProductid: 24456 
2026-01-15 08:14:30.5531 CoolR.Tasks.MergeProductsTask    Planogram updated with Primary ProductId: 24456, POG Counts: 1 
2026-01-15 08:14:31.2874 CoolR.Tasks.MergeProductsTask    Other tables are updated for primaryProductid: 24456 
2026-01-15 08:14:31.4124 CoolR.Tasks.MergeProductsTask    MergeProduct SP executed with Primary ProductId: 24456 
2026-01-15 08:14:31.4906 CoolR.Tasks.MergeProductsTask    Secondary Product marked Deleted for Primary ProductId: 24456 
2026-01-15 08:24:27.5098 CoolR.Tasks.MergeProductsTask    AssetPurity related Tables are updated for primaryProductid: 24456 
2026-01-15 08:24:27.7754 CoolR.Tasks.MergeProductsTask    Planogram updated with Primary ProductId: 24456, POG Counts: 0 
2026-01-15 08:24:27.9317 DFramework.Database.NullableDataReader    Data reader open for 542
   at System.Environment.GetStackTrace(Exception e, Boolean needFileInfo)
   at System.Environment.get_StackTrace()
   at DFramework.Database.NullableDataReader.Dispose(Boolean disposing) in 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-15 08:24:27.9942 DFramework.Database.Query    /* Time Taken: 571*/
[dbo].GenerateSystemAlerts 
2026-01-15 08:24:28.1973 CoolR.Tasks.MergeProductsTask    Other tables are updated for primaryProductid: 24456 
2026-01-15 08:24:28.2910 CoolR.Tasks.MergeProductsTask    MergeProduct SP executed with Primary ProductId: 24456 
2026-01-15 08:24:28.3692 CoolR.Tasks.MergeProductsTask    Secondary Product marked Deleted for Primary ProductId: 24456 
2026-01-15 08:24:43.5255 DFramework.Scheduler.TaskBase    /* Time Taken: 16156.3474*/
Opportunity Out Of Stock By Outlet 
2026-01-15 08:34:27.4512 CoolR.Tasks.MergeProductsTask    AssetPurity related Tables are updated for primaryProductid: 24456 
2026-01-15 08:34:27.5293 CoolR.Tasks.MergeProductsTask    Planogram updated with Primary ProductId: 24456, POG Counts: 0 
2026-01-15 08:34:27.9981 CoolR.Tasks.MergeProductsTask    Other tables are updated for primaryProductid: 24456 
2026-01-15 08:34:28.1074 CoolR.Tasks.MergeProductsTask    MergeProduct SP executed with Primary ProductId: 24456 
2026-01-15 08:34:28.1699 CoolR.Tasks.MergeProductsTask    Secondary Product marked Deleted for Primary ProductId: 24456 
2026-01-15 08:34:28.2950 MoveToReorder    Running task for ClientId : 286 and ClientName = India Office QA and Slot: 1/15/2026 10:00:00 PM And LastExecutedOn: 1/15/2026 9:04:27 PM 
2026-01-15 08:35:07.6077 DFramework.Database.NullableDataReader    Data reader open for 38896
   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-15 08:35:07.6389 MoveToReorder    Task executed successfully for ClientId : 286 Client Name:India Office QA, Slot: 1/15/2026 10:00:00 PM and Total Order Suggested: 125 Out Of: 125 
2026-01-15 08:35:08.8264 DFramework.Scheduler.TaskBase    /* Time Taken: 41422.116*/
Move To Re-Order 
2026-01-15 08:37:55.2962 DFramework.Database.NullableDataReader    Data reader open for 7991548
   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 346
   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-15 08:37:55.2962 DFramework.Database.NullableDataReader    Data reader open for 7991614
   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 346
   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-15 08:37:55.5618 DFramework.Scheduler.TaskBase    /* Time Taken: 8008331.8589*/
Process Alert Record 
2026-01-15 08:42:56.7824 AlertProcessor    ProcessorAlertData: started 
2026-01-15 08:42:57.0012 DFramework.Database.Query    /* Time Taken: 542*/
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/15/2026 4:42:56 PM'
DECLARE @ClientTypeId0 Int32
SET @ClientTypeId0 = '5512'
DECLARE @ClientTypeId1 Int32
SET @ClientTypeId1 = '5515'
DECLARE @AlertDefinition_AlertTypeId Int32
SET @AlertDefinition_AlertTypeId = '75'
SELECT AlertDefinitionId, AlertDefinition.AlertTypeId, Name, AlertBody, AlertDefinition.ClientId, MarketId, ClassificationId, LocationTypeId, LocationId,
														StartDate, PriorityId, LastImageThreshold, ProductCount
														FROM dbo.AlertDefinition
														INNER JOIN dbo.AlertType ON dbo.AlertType.AlertTypeId = dbo.AlertDefinition.AlertTypeId
														INNER JOIN dbo.Client ON dbo.Client.ClientId = dbo.AlertDefinition.ClientId
 WHERE Client.IsDeleted = @Client_IsDeleted AND AlertType.IsActive = @AlertType_IsActive AND AlertType.IsDeleted = @AlertType_IsDeleted AND AlertDefinition.IsActive = @AlertDefinition_IsActive AND AlertDefinition.IsDeleted = @AlertDefinition_IsDeleted AND AlertDefinition.StartDate <= @AlertDefinition_StartDate AND dbo.Client.ClientTypeId IN ( @ClientTypeId0, @ClientTypeId1 ) AND AlertDefinition.AlertTypeId = @AlertDefinition_AlertTypeId
 
2026-01-15 08:42:57.3918 DFramework.Database.Query    /* Time Taken: 604*/
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/15/2026 4:42:56 PM'
SELECT TOP 1 AlertDefinitionId, PriorityId FROM AlertDefinition
 WHERE AlertDefinition.IsActive = @AlertDefinition_IsActive AND AlertDefinition.ClientId = @AlertDefinition_ClientId AND AlertDefinition.AlertTypeId = @AlertDefinition_AlertTypeId AND AlertDefinition.IsDeleted = @AlertDefinition_IsDeleted AND AlertDefinition.StartDate <= @AlertDefinition_StartDate
 
2026-01-15 08:42:57.5324 DFramework.Database.Query    /* Time Taken: 726*/
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-15 08:42:57.6418 DFramework.Database.Query    /* Time Taken: 837*/
DECLARE @OrderStatusId Int32
SET @OrderStatusId = '5486'
DECLARE @CurrentUtcDateTime DateTime2
SET @CurrentUtcDateTime = '1/15/2026 4:42:56 PM'
UPDATE Location SET ScheduledOrderId = 0, OrderStatusId = 0 FROM dbo.ScheduledOrder 
										INNER JOIN dbo.Location ON Location.ScheduledOrderId = ScheduledOrder.ScheduledOrderId AND Location.OrderStatusId = @OrderStatusId
										INNER JOIN dbo.Client On Client.ClientId = Location.ClientId
										WHERE ScheduledOrder.ModifiedOn < DATEADD(HOUR, -Client.HoursToMoveIgnored, @CurrentUtcDateTime) AND ScheduledOrder.StatusId = @OrderStatusId AND Client.HoursToMoveIgnored > 0
 
2026-01-15 08:42:57.6731 DFramework.Database.Query    /* Time Taken: 866*/
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-15 08:42:57.6731 DFramework.Database.Query    /* Time Taken: 884*/
DECLARE @IsComplete Int32
SET @IsComplete = '0'
SELECT TOP 1 ProductMergeTempId, PrimaryProductId, SecondaryProductId, dbo.Product.ClientId, dbo.ProductMergeTemp.UserId, [Product] AS ProductName FROM dbo.ProductMergeTemp 
				INNER JOIN dbo.Product ON dbo.Product.ProductId = dbo.ProductMergeTemp.PrimaryProductId AND dbo.Product.ClientId = dbo.ProductMergeTemp.ClientId AND dbo.Product.IsDeleted = 0
 WHERE [IsComplete] = @IsComplete
 
2026-01-15 08:42:57.7043 DFramework.Database.Query    /* Time Taken: 685*/
DECLARE @AlertDefinitionId Int32
SET @AlertDefinitionId = '99'
DECLARE @IsDeleted Boolean
SET @IsDeleted = 'False'
SELECT ProductId FROM AlertDefinitionProduct
 WHERE [AlertDefinitionId] = @AlertDefinitionId AND IsDeleted = @IsDeleted
 
2026-01-15 08:42:57.7512 DFramework.Database.Query    /* Time Taken: 1127*/
[dbo].GenerateSystemAlerts 
2026-01-15 08:42:57.8762 CoolR.Tasks.MergeProductsTask    AssetPurity related Tables are updated for primaryProductid: 24456 
2026-01-15 08:42:57.9856 DFramework.Database.Query    /* Time Taken: 1176*/
DECLARE @CreatedOn Date
SET @CreatedOn = '1/15/2026 12:00:00 AM'
DECLARE @EventId Int32
SET @EventId = '-12'
SELECT COUNT(1) FROM EmailQueue
 WHERE [CreatedOn] >= @CreatedOn AND [EventId] = @EventId
 
2026-01-15 08:42:58.0481 DFramework.Database.NullableDataReader    Data reader open for 1014
   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-15 08:42:58.0637 CoolR.Tasks.MergeProductsTask    Planogram updated with Primary ProductId: 24456, POG Counts: 0 
2026-01-15 08:42:58.1731 DFramework.Database.Query    /* Time Taken: 1334*/
DECLARE @TableName AnsiString(8000)
SET @TableName = 'TagAlert'
DECLARE @CurrentRecordId Int32
SET @CurrentRecordId = '0'
dbo.GetValidDeviceForAlertProcessData 
2026-01-15 08:42:58.3918 CoolR.Tasks.MergeProductsTask    Other tables are updated for primaryProductid: 24456 
2026-01-15 08:42:58.5012 CoolR.Tasks.MergeProductsTask    MergeProduct SP executed with Primary ProductId: 24456 
2026-01-15 08:42:58.5637 CoolR.Tasks.MergeProductsTask    Secondary Product marked Deleted for Primary ProductId: 24456 
2026-01-15 08:42:59.0481 DFramework.Database.NullableDataReader    Data reader open for 884
   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-15 08:42:59.7824 DFramework.Database.NullableDataReader    Data reader open for 325
   at System.Environment.GetStackTrace(Exception e, Boolean needFileInfo)
   at System.Environment.get_StackTrace()
   at DFramework.Database.NullableDataReader.Dispose(Boolean disposing) in C:\CoolR-Group\Framework\DFramework\Database\NullableDataReader.cs:line 33
   at DFramework.Database.NullableDataReader.Dispose() in C:\CoolR-Group\Framework\DFramework\Database\NullableDataReader.cs:line 44
   at CoolR.Tasks.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-15 08:43:00.0168 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 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-15 08:43:00.2668 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-15 08:43:00.7981 DFramework.Database.NullableDataReader    Data reader open for 1382
   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-15 08:43:02.0793 DFramework.Database.NullableDataReader    Data reader open for 864
   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-15 08:43:03.4231 DFramework.Database.NullableDataReader    Data reader open for 928
   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-15 08:43:04.0638 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 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-15 08:43:04.3137 DFramework.Database.NullableDataReader    Data reader open for 225
   at System.Environment.GetStackTrace(Exception e, Boolean needFileInfo)
   at System.Environment.get_StackTrace()
   at DFramework.Database.NullableDataReader.Dispose(Boolean disposing) in 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-15 08:43:04.5794 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 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-15 08:43:04.8606 DFramework.Database.NullableDataReader    Data reader open for 253
   at System.Environment.GetStackTrace(Exception e, Boolean needFileInfo)
   at System.Environment.get_StackTrace()
   at DFramework.Database.NullableDataReader.Dispose(Boolean disposing) in 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-15 08:43:05.1419 DFramework.Database.NullableDataReader    Data reader open for 223
   at System.Environment.GetStackTrace(Exception e, Boolean needFileInfo)
   at System.Environment.get_StackTrace()
   at DFramework.Database.NullableDataReader.Dispose(Boolean disposing) in 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-15 08:43:05.3919 DFramework.Database.NullableDataReader    Data reader open for 222
   at System.Environment.GetStackTrace(Exception e, Boolean needFileInfo)
   at System.Environment.get_StackTrace()
   at DFramework.Database.NullableDataReader.Dispose(Boolean disposing) in 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-15 08:43:05.7044 DFramework.Database.NullableDataReader    Data reader open for 252
   at System.Environment.GetStackTrace(Exception e, Boolean needFileInfo)
   at System.Environment.get_StackTrace()
   at DFramework.Database.NullableDataReader.Dispose(Boolean disposing) in 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-15 08:43:05.8137 DFramework.Database.NullableDataReader    Data reader open for 2007
   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-15 08:43:06.5481 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 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-15 08:43:06.8138 DFramework.Database.NullableDataReader    Data reader open for 248
   at System.Environment.GetStackTrace(Exception e, Boolean needFileInfo)
   at System.Environment.get_StackTrace()
   at DFramework.Database.NullableDataReader.Dispose(Boolean disposing) in 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-15 08:43:07.0950 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-15 08:43:07.3763 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-15 08:43:07.8294 DFramework.Database.NullableDataReader    Data reader open for 281
   at System.Environment.GetStackTrace(Exception e, Boolean needFileInfo)
   at System.Environment.get_StackTrace()
   at DFramework.Database.NullableDataReader.Dispose(Boolean disposing) in 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-15 08:43:08.1263 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-15 08:43:08.2513 DFramework.Database.NullableDataReader    Data reader open for 2044
   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-15 08:43:09.0325 DFramework.Database.NullableDataReader    Data reader open for 372
   at System.Environment.GetStackTrace(Exception e, Boolean needFileInfo)
   at System.Environment.get_StackTrace()
   at DFramework.Database.NullableDataReader.Dispose(Boolean disposing) in 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-15 08:43:09.4388 DFramework.Database.NullableDataReader    Data reader open for 384
   at System.Environment.GetStackTrace(Exception e, Boolean needFileInfo)
   at System.Environment.get_StackTrace()
   at DFramework.Database.NullableDataReader.Dispose(Boolean disposing) in C:\CoolR-Group\Framework\DFramework\Database\NullableDataReader.cs:line 33
   at DFramework.Database.NullableDataReader.Dispose() in C:\CoolR-Group\Framework\DFramework\Database\NullableDataReader.cs:line 44
   at CoolR.Tasks.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-15 08:43:09.8138 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 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-15 08:43:10.3138 DFramework.Database.NullableDataReader    Data reader open for 315
   at System.Environment.GetStackTrace(Exception e, Boolean needFileInfo)
   at System.Environment.get_StackTrace()
   at DFramework.Database.NullableDataReader.Dispose(Boolean disposing) in C:\CoolR-Group\Framework\DFramework\Database\NullableDataReader.cs:line 33
   at DFramework.Database.NullableDataReader.Dispose() in C:\CoolR-Group\Framework\DFramework\Database\NullableDataReader.cs:line 44
   at CoolR.Tasks.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-15 08:43:10.6888 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 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-15 08:43:10.7982 DFramework.Database.NullableDataReader    Data reader open for 2189
   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-15 08:43:11.4544 DFramework.Database.Query    /* Time Taken: 653*/
DECLARE @TableName AnsiString(8000)
SET @TableName = 'AssetStockProductWiseConsolidate'
DECLARE @CurrentRecordId Int32
SET @CurrentRecordId = '3676207'
dbo.GetValidDeviceForAlertProcessData 
2026-01-15 08:43:11.6732 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-15 08:43:13.5951 DFramework.Scheduler.TaskBase    /* Time Taken: 17187.6307*/
Opportunity Out Of Stock By Outlet 
2026-01-15 08:52:20.8954 DFramework.Database.NullableDataReader    Data reader open for 548799
   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 343
   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-15 08:52:20.8954 DFramework.Database.NullableDataReader    Data reader open for 548856
   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 343
   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-15 08:52:21.1923 DFramework.Scheduler.TaskBase    /* Time Taken: 564784.8665*/
Process Alert Record