2026-01-14 01:36:30.2456 AlertProcessor    ProcessorAlertData: started 
2026-01-14 01:36:30.2613 AlertProcessor    ProcessorAlertData: started 
2026-01-14 01:36:30.9488 DFramework.Database.Query    /* Time Taken: 575*/
DECLARE @IsFileProcessed Int32
SET @IsFileProcessed = '0'
DECLARE @TaskNumber Int32
SET @TaskNumber = '3'
DECLARE @IsDeleted Int32
SET @IsDeleted = '0'
SELECT TOP 1000 IncomingFileId, GatewayId,GatewayMac,RawFileName,AzureContainerName,StartIndex,Tries, CreatedOn FROM IncomingFile
 WHERE [IsFileProcessed] = @IsFileProcessed AND [TaskNumber] = @TaskNumber AND [IsDeleted] = @IsDeleted
 
2026-01-14 01:36:31.0269 DFramework.Database.Query    /* Time Taken: 673*/
DECLARE @IsFileProcessed Int32
SET @IsFileProcessed = '0'
DECLARE @TaskNumber Int32
SET @TaskNumber = '2'
DECLARE @IsDeleted Int32
SET @IsDeleted = '0'
SELECT TOP 1000 IncomingFileId, GatewayId,GatewayMac,RawFileName,AzureContainerName,StartIndex,Tries, CreatedOn FROM IncomingFile
 WHERE [IsFileProcessed] = @IsFileProcessed AND [TaskNumber] = @TaskNumber AND [IsDeleted] = @IsDeleted
 
2026-01-14 01:36:31.0581 DFramework.Database.Query    /* Time Taken: 730*/
DECLARE @IsFileProcessed Int32
SET @IsFileProcessed = '0'
DECLARE @TaskNumber Int32
SET @TaskNumber = '1'
DECLARE @IsDeleted Int32
SET @IsDeleted = '0'
SELECT TOP 1000 IncomingFileId, GatewayId,GatewayMac,RawFileName,AzureContainerName,StartIndex,Tries, CreatedOn FROM IncomingFile
 WHERE [IsFileProcessed] = @IsFileProcessed AND [TaskNumber] = @TaskNumber AND [IsDeleted] = @IsDeleted
 
2026-01-14 01:36:31.0894 DFramework.Database.Query    /* Time Taken: 759*/
DECLARE @IsFileProcessed Int32
SET @IsFileProcessed = '0'
DECLARE @TaskNumber Int32
SET @TaskNumber = '0'
DECLARE @IsDeleted Int32
SET @IsDeleted = '0'
SELECT TOP 1000 IncomingFileId, GatewayId,GatewayMac,RawFileName,AzureContainerName,StartIndex,Tries, CreatedOn FROM IncomingFile
 WHERE [IsFileProcessed] = @IsFileProcessed AND [TaskNumber] = @TaskNumber AND [IsDeleted] = @IsDeleted
 
2026-01-14 01:36:31.1050 DFramework.Database.Query    /* Time Taken: 696*/
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-14 01:36:31.1206 DFramework.Database.Query    /* Time Taken: 841*/
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/14/2026 9:36:30 AM'
DECLARE @ClientTypeId0 Int32
SET @ClientTypeId0 = '5512'
DECLARE @ClientTypeId1 Int32
SET @ClientTypeId1 = '5515'
DECLARE @AlertDefinition_AlertTypeId Int32
SET @AlertDefinition_AlertTypeId = '75'
SELECT AlertDefinitionId, AlertDefinition.AlertTypeId, Name, AlertBody, AlertDefinition.ClientId, MarketId, ClassificationId, LocationTypeId, LocationId,
														StartDate, PriorityId, LastImageThreshold, ProductCount
														FROM dbo.AlertDefinition
														INNER JOIN dbo.AlertType ON dbo.AlertType.AlertTypeId = dbo.AlertDefinition.AlertTypeId
														INNER JOIN dbo.Client ON dbo.Client.ClientId = dbo.AlertDefinition.ClientId
 WHERE Client.IsDeleted = @Client_IsDeleted AND AlertType.IsActive = @AlertType_IsActive AND AlertType.IsDeleted = @AlertType_IsDeleted AND AlertDefinition.IsActive = @AlertDefinition_IsActive AND AlertDefinition.IsDeleted = @AlertDefinition_IsDeleted AND AlertDefinition.StartDate <= @AlertDefinition_StartDate AND dbo.Client.ClientTypeId IN ( @ClientTypeId0, @ClientTypeId1 ) AND AlertDefinition.AlertTypeId = @AlertDefinition_AlertTypeId
 
2026-01-14 01:36:31.1519 DFramework.Database.Query    /* Time Taken: 685*/
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-14 01:36:31.1994 DFramework.Database.Query    /* Time Taken: 737*/
DECLARE @OrderStatusId Int32
SET @OrderStatusId = '5486'
DECLARE @CurrentUtcDateTime DateTime2
SET @CurrentUtcDateTime = '1/14/2026 9:36:30 AM'
UPDATE Location SET ScheduledOrderId = 0, OrderStatusId = 0 FROM dbo.ScheduledOrder 
										INNER JOIN dbo.Location ON Location.ScheduledOrderId = ScheduledOrder.ScheduledOrderId AND Location.OrderStatusId = @OrderStatusId
										INNER JOIN dbo.Client On Client.ClientId = Location.ClientId
										WHERE ScheduledOrder.ModifiedOn < DATEADD(HOUR, -Client.HoursToMoveIgnored, @CurrentUtcDateTime) AND ScheduledOrder.StatusId = @OrderStatusId AND Client.HoursToMoveIgnored > 0
 
2026-01-14 01:36:31.2925 DFramework.Database.Query    /* Time Taken: 926*/
DECLARE @IsFileProcessed Int32
SET @IsFileProcessed = '0'
DECLARE @TaskNumber Int32
SET @TaskNumber = '4'
DECLARE @IsDeleted Int32
SET @IsDeleted = '0'
SELECT TOP 1000 IncomingFileId, GatewayId,GatewayMac,RawFileName,AzureContainerName,StartIndex,Tries, CreatedOn FROM IncomingFile
 WHERE [IsFileProcessed] = @IsFileProcessed AND [TaskNumber] = @TaskNumber AND [IsDeleted] = @IsDeleted
 
2026-01-14 01:36:31.3238 DFramework.Database.Query    /* Time Taken: 884*/
DECLARE @IsFileProcessed Int32
SET @IsFileProcessed = '0'
DECLARE @TaskNumber Int32
SET @TaskNumber = '4'
DECLARE @IsDeleted Int32
SET @IsDeleted = '0'
SELECT TOP 1000 IncomingFileId, GatewayId,GatewayMac,RawFileName,AzureContainerName,StartIndex,Tries, CreatedOn FROM IncomingFile
 WHERE [IsFileProcessed] = @IsFileProcessed AND [TaskNumber] = @TaskNumber AND [IsDeleted] = @IsDeleted
 
2026-01-14 01:36:31.3394 DFramework.Database.Query    /* Time Taken: 852*/
DECLARE @CreatedOn Date
SET @CreatedOn = '1/14/2026 12:00:00 AM'
DECLARE @EventId Int32
SET @EventId = '-12'
SELECT COUNT(1) FROM EmailQueue
 WHERE [CreatedOn] >= @CreatedOn AND [EventId] = @EventId
 
2026-01-14 01:36:31.3550 DFramework.Database.Query    /* Time Taken: 1072*/
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/14/2026 9:36:30 AM'
DECLARE @ClientTypeId0 Int32
SET @ClientTypeId0 = '5512'
DECLARE @ClientTypeId1 Int32
SET @ClientTypeId1 = '5515'
DECLARE @AlertDefinition_AlertTypeId Int32
SET @AlertDefinition_AlertTypeId = '75'
SELECT AlertDefinitionId, AlertDefinition.AlertTypeId, Name, AlertBody, AlertDefinition.ClientId, MarketId, ClassificationId, LocationTypeId, LocationId,
														StartDate, PriorityId, LastImageThreshold, ProductCount
														FROM dbo.AlertDefinition
														INNER JOIN dbo.AlertType ON dbo.AlertType.AlertTypeId = dbo.AlertDefinition.AlertTypeId
														INNER JOIN dbo.Client ON dbo.Client.ClientId = dbo.AlertDefinition.ClientId
 WHERE Client.IsDeleted = @Client_IsDeleted AND AlertType.IsActive = @AlertType_IsActive AND AlertType.IsDeleted = @AlertType_IsDeleted AND AlertDefinition.IsActive = @AlertDefinition_IsActive AND AlertDefinition.IsDeleted = @AlertDefinition_IsDeleted AND AlertDefinition.StartDate <= @AlertDefinition_StartDate AND dbo.Client.ClientTypeId IN ( @ClientTypeId0, @ClientTypeId1 ) AND AlertDefinition.AlertTypeId = @AlertDefinition_AlertTypeId
 
2026-01-14 01:36:31.3706 DFramework.Database.Query    /* Time Taken: 869*/
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/14/2026 9:36:30 AM'
SELECT TOP 1 AlertDefinitionId, PriorityId FROM AlertDefinition
 WHERE AlertDefinition.IsActive = @AlertDefinition_IsActive AND AlertDefinition.ClientId = @AlertDefinition_ClientId AND AlertDefinition.AlertTypeId = @AlertDefinition_AlertTypeId AND AlertDefinition.IsDeleted = @AlertDefinition_IsDeleted AND AlertDefinition.StartDate <= @AlertDefinition_StartDate
 
2026-01-14 01:36:31.6519 DFramework.Database.Query    /* Time Taken: 1186*/
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-14 01:36:31.7456 DFramework.Database.Query    /* Time Taken: 587*/
DECLARE @AssetKPIData Object
SET @AssetKPIData = ''
[dbo].BulkUpsertAssetDayKPI 
2026-01-14 01:36:31.8081 DFramework.Database.Query    /* Time Taken: 1459*/
DECLARE @IsFileProcessed Int32
SET @IsFileProcessed = '0'
DECLARE @TaskNumber Int32
SET @TaskNumber = '0'
DECLARE @IsDeleted Int32
SET @IsDeleted = '0'
SELECT TOP 1000 IncomingFileId, GatewayId,GatewayMac,RawFileName,AzureContainerName,StartIndex,Tries, CreatedOn FROM IncomingFile
 WHERE [IsFileProcessed] = @IsFileProcessed AND [TaskNumber] = @TaskNumber AND [IsDeleted] = @IsDeleted
 
2026-01-14 01:36:31.8394 DFramework.Database.Query    /* Time Taken: 1470*/
DECLARE @IsFileProcessed Int32
SET @IsFileProcessed = '0'
DECLARE @TaskNumber Int32
SET @TaskNumber = '1'
DECLARE @IsDeleted Int32
SET @IsDeleted = '0'
SELECT TOP 1000 IncomingFileId, GatewayId,GatewayMac,RawFileName,AzureContainerName,StartIndex,Tries, CreatedOn FROM IncomingFile
 WHERE [IsFileProcessed] = @IsFileProcessed AND [TaskNumber] = @TaskNumber AND [IsDeleted] = @IsDeleted
 
2026-01-14 01:36:31.8706 DFramework.Database.Query    /* Time Taken: 1450*/
DECLARE @IsFileProcessed Int32
SET @IsFileProcessed = '0'
DECLARE @TaskNumber Int32
SET @TaskNumber = '3'
DECLARE @IsDeleted Int32
SET @IsDeleted = '0'
SELECT TOP 1000 IncomingFileId, GatewayId,GatewayMac,RawFileName,AzureContainerName,StartIndex,Tries, CreatedOn FROM IncomingFile
 WHERE [IsFileProcessed] = @IsFileProcessed AND [TaskNumber] = @TaskNumber AND [IsDeleted] = @IsDeleted
 
2026-01-14 01:36:31.9800 DFramework.Database.Query    /* Time Taken: 835*/
DECLARE @AlertDefinitionId Int32
SET @AlertDefinitionId = '99'
DECLARE @IsDeleted Boolean
SET @IsDeleted = 'False'
SELECT ProductId FROM AlertDefinitionProduct
 WHERE [AlertDefinitionId] = @AlertDefinitionId AND IsDeleted = @IsDeleted
 
2026-01-14 01:36:31.9800 DFramework.Database.Query    /* Time Taken: 1676*/
DECLARE @TableName AnsiString(8000)
SET @TableName = 'TagAlert'
DECLARE @CurrentRecordId Int32
SET @CurrentRecordId = '0'
dbo.GetValidDeviceForAlertProcessData 
2026-01-14 01:36:32.0113 DFramework.Database.Query    /* Time Taken: 809*/
DECLARE @OrderStatusId Int32
SET @OrderStatusId = '5484'
DECLARE @CurrentUtcDateTime DateTime2
SET @CurrentUtcDateTime = '1/14/2026 9:36:31 AM'
UPDATE Location SET ScheduledOrderId = 0, OrderStatusId = 0 FROM dbo.ScheduledOrder 
										INNER JOIN dbo.Location ON Location.ScheduledOrderId = ScheduledOrder.ScheduledOrderId AND Location.OrderStatusId = @OrderStatusId
										INNER JOIN dbo.Client On Client.ClientId = Location.ClientId
										WHERE ScheduledOrder.ModifiedOn < DATEADD(HOUR, -Client.HoursToMoveInTransit, @CurrentUtcDateTime) AND ScheduledOrder.StatusId = @OrderStatusId AND Client.HoursToMoveInTransit > 0
 
2026-01-14 01:36:32.0113 DFramework.Database.Query    /* Time Taken: 1497*/
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-14 01:36:32.0581 DFramework.Database.Query    /* Time Taken: 1565*/
DECLARE @OrderStatusId Int32
SET @OrderStatusId = '5486'
DECLARE @CurrentUtcDateTime DateTime2
SET @CurrentUtcDateTime = '1/14/2026 9:36:30 AM'
UPDATE Location SET ScheduledOrderId = 0, OrderStatusId = 0 FROM dbo.ScheduledOrder 
										INNER JOIN dbo.Location ON Location.ScheduledOrderId = ScheduledOrder.ScheduledOrderId AND Location.OrderStatusId = @OrderStatusId
										INNER JOIN dbo.Client On Client.ClientId = Location.ClientId
										WHERE ScheduledOrder.ModifiedOn < DATEADD(HOUR, -Client.HoursToMoveIgnored, @CurrentUtcDateTime) AND ScheduledOrder.StatusId = @OrderStatusId AND Client.HoursToMoveIgnored > 0
 
2026-01-14 01:36:32.0894 DFramework.Database.Query    /* Time Taken: 1605*/
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-14 01:36:32.1050 DFramework.Database.Query    /* Time Taken: 1722*/
DECLARE @IsFileProcessed Int32
SET @IsFileProcessed = '0'
DECLARE @TaskNumber Int32
SET @TaskNumber = '2'
DECLARE @IsDeleted Int32
SET @IsDeleted = '0'
SELECT TOP 1000 IncomingFileId, GatewayId,GatewayMac,RawFileName,AzureContainerName,StartIndex,Tries, CreatedOn FROM IncomingFile
 WHERE [IsFileProcessed] = @IsFileProcessed AND [TaskNumber] = @TaskNumber AND [IsDeleted] = @IsDeleted
 
2026-01-14 01:36:32.1206 DFramework.Database.Query    /* Time Taken: 1599*/
DECLARE @CreatedOn Date
SET @CreatedOn = '1/14/2026 12:00:00 AM'
DECLARE @EventId Int32
SET @EventId = '-12'
SELECT COUNT(1) FROM EmailQueue
 WHERE [CreatedOn] >= @CreatedOn AND [EventId] = @EventId
 
2026-01-14 01:36:32.1363 DFramework.Database.Query    /* Time Taken: 1622*/
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/14/2026 9:36:30 AM'
SELECT TOP 1 AlertDefinitionId, PriorityId FROM AlertDefinition
 WHERE AlertDefinition.IsActive = @AlertDefinition_IsActive AND AlertDefinition.ClientId = @AlertDefinition_ClientId AND AlertDefinition.AlertTypeId = @AlertDefinition_AlertTypeId AND AlertDefinition.IsDeleted = @AlertDefinition_IsDeleted AND AlertDefinition.StartDate <= @AlertDefinition_StartDate
 
2026-01-14 01:36:32.1988 DFramework.Database.Query    /* Time Taken: 816*/
DECLARE @AlertDefinitionId Int32
SET @AlertDefinitionId = '99'
DECLARE @IsDeleted Boolean
SET @IsDeleted = 'False'
SELECT ProductId FROM AlertDefinitionProduct
 WHERE [AlertDefinitionId] = @AlertDefinitionId AND IsDeleted = @IsDeleted
 
2026-01-14 01:36:32.2144 DFramework.Database.NullableDataReader    Data reader open for 1070
   at System.Environment.GetStackTrace(Exception e, Boolean needFileInfo)
   at System.Environment.get_StackTrace()
   at DFramework.Database.NullableDataReader.Dispose(Boolean disposing) in C:\CoolR-Group\Framework\DFramework\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:\Program Files (x86)\Go Agent\pipelines\coolr-portal-dev-task-service-new\CoolR.Tasks\OpportunityOutOfStockByOutlet.cs:line 492
   at CoolR.Tasks.ProcessOutletAlertData.Execute() in C:\Program Files (x86)\Go Agent\pipelines\coolr-portal-dev-task-service-new\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-14 01:36:32.3706 DFramework.Database.Query    /* Time Taken: 999*/
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-14 01:36:32.6050 DFramework.Database.Query    /* Time Taken: 2104*/
[dbo].GenerateSystemAlerts 
2026-01-14 01:36:32.7300 DFramework.Database.NullableDataReader    Data reader open for 666
   at System.Environment.GetStackTrace(Exception e, Boolean needFileInfo)
   at System.Environment.get_StackTrace()
   at DFramework.Database.NullableDataReader.Dispose(Boolean disposing) in C:\CoolR-Group\Framework\DFramework\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:\Program Files (x86)\Go Agent\pipelines\coolr-portal-dev-task-service-new\CoolR.Tasks\ProcessAlertData.cs:line 48
   at DFramework.Scheduler.TaskBase.Run() in E:\Forked\Framework\DFramework.Scheduler\TaskBase.cs:line 176
   at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)
   at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)
   at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state)
   at System.Threading.ThreadHelper.ThreadStart() 
2026-01-14 01:36:32.7456 MoveToReorder    Running task for ClientId : 286 and ClientName = India Office QA and Slot: 1/14/2026 12:00:00 PM And LastExecutedOn: 1/14/2026 11:40:52 AM 
2026-01-14 01:36:32.7616 DFramework.Database.Query    /* Time Taken: 2406*/
DECLARE @TableName AnsiString(8000)
SET @TableName = 'TagAlert'
DECLARE @CurrentRecordId Int32
SET @CurrentRecordId = '0'
dbo.GetValidDeviceForAlertProcessData 
2026-01-14 01:36:32.7616 DFramework.Database.Query    /* Time Taken: 1179*/
DECLARE @AssetKPIData Object
SET @AssetKPIData = ''
[dbo].BulkUpsertAssetDayKPI 
2026-01-14 01:36:32.9644 DFramework.Database.NullableDataReader    Data reader open for 990
   at System.Environment.GetStackTrace(Exception e, Boolean needFileInfo)
   at System.Environment.get_StackTrace()
   at DFramework.Database.NullableDataReader.Dispose(Boolean disposing) in C:\CoolR-Group\Framework\DFramework\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:\Program Files (x86)\Go Agent\pipelines\coolr-portal-dev-task-service-new\CoolR.Tasks\ProcessAlertData.cs:line 48
   at DFramework.Scheduler.TaskBase.Run() in E:\Forked\Framework\DFramework.Scheduler\TaskBase.cs:line 176
   at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)
   at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)
   at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state)
   at System.Threading.ThreadHelper.ThreadStart() 
2026-01-14 01:36:33.7769 DFramework.Database.NullableDataReader    Data reader open for 405
   at System.Environment.GetStackTrace(Exception e, Boolean needFileInfo)
   at System.Environment.get_StackTrace()
   at DFramework.Database.NullableDataReader.Dispose(Boolean disposing) in C:\CoolR-Group\Framework\DFramework\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:\Program Files (x86)\Go Agent\pipelines\coolr-portal-dev-task-service-new\CoolR.Tasks\ProcessAlertData.cs:line 48
   at DFramework.Scheduler.TaskBase.Run() in E:\Forked\Framework\DFramework.Scheduler\TaskBase.cs:line 176
   at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)
   at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)
   at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state)
   at System.Threading.ThreadHelper.ThreadStart() 
2026-01-14 01:36:34.0581 DFramework.Database.NullableDataReader    Data reader open for 711
   at System.Environment.GetStackTrace(Exception e, Boolean needFileInfo)
   at System.Environment.get_StackTrace()
   at DFramework.Database.NullableDataReader.Dispose(Boolean disposing) in C:\CoolR-Group\Framework\DFramework\Database\NullableDataReader.cs:line 33
   at DFramework.Database.NullableDataReader.Dispose() in C:\CoolR-Group\Framework\DFramework\Database\NullableDataReader.cs:line 44
   at CoolR.Tasks.ProcessAlertData.Execute() in C:\Program Files (x86)\Go Agent\pipelines\coolr-portal-dev-task-service-new\CoolR.Tasks\ProcessAlertData.cs:line 48
   at DFramework.Scheduler.TaskBase.Run() in E:\Forked\Framework\DFramework.Scheduler\TaskBase.cs:line 176
   at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)
   at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)
   at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state)
   at System.Threading.ThreadHelper.ThreadStart() 
2026-01-14 01:36:34.7304 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:\Program Files (x86)\Go Agent\pipelines\coolr-portal-dev-task-service-new\CoolR.Tasks\ProcessAlertData.cs:line 48
   at DFramework.Scheduler.TaskBase.Run() in E:\Forked\Framework\DFramework.Scheduler\TaskBase.cs:line 176
   at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)
   at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)
   at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state)
   at System.Threading.ThreadHelper.ThreadStart() 
2026-01-14 01:36:35.4492 DFramework.Database.Query    /* Time Taken: 711*/
DECLARE @TableName AnsiString(8000)
SET @TableName = 'AdditionalShelf'
DECLARE @CurrentRecordId Int32
SET @CurrentRecordId = '3676076'
dbo.GetValidDeviceForAlertProcessData 
2026-01-14 01:36:35.6679 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:\Program Files (x86)\Go Agent\pipelines\coolr-portal-dev-task-service-new\CoolR.Tasks\ProcessAlertData.cs:line 48
   at DFramework.Scheduler.TaskBase.Run() in E:\Forked\Framework\DFramework.Scheduler\TaskBase.cs:line 176
   at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)
   at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)
   at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state)
   at System.Threading.ThreadHelper.ThreadStart() 
2026-01-14 01:36:36.2617 DFramework.Database.NullableDataReader    Data reader open for 211
   at System.Environment.GetStackTrace(Exception e, Boolean needFileInfo)
   at System.Environment.get_StackTrace()
   at DFramework.Database.NullableDataReader.Dispose(Boolean disposing) in C:\CoolR-Group\Framework\DFramework\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:\Program Files (x86)\Go Agent\pipelines\coolr-portal-dev-task-service-new\CoolR.Tasks\ProcessAlertData.cs:line 48
   at DFramework.Scheduler.TaskBase.Run() in E:\Forked\Framework\DFramework.Scheduler\TaskBase.cs:line 176
   at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)
   at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)
   at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state)
   at System.Threading.ThreadHelper.ThreadStart() 
2026-01-14 01:36:36.4961 DFramework.Database.NullableDataReader    Data reader open for 208
   at System.Environment.GetStackTrace(Exception e, Boolean needFileInfo)
   at System.Environment.get_StackTrace()
   at DFramework.Database.NullableDataReader.Dispose(Boolean disposing) in C:\CoolR-Group\Framework\DFramework\Database\NullableDataReader.cs:line 33
   at DFramework.Database.NullableDataReader.Dispose() in C:\CoolR-Group\Framework\DFramework\Database\NullableDataReader.cs:line 44
   at CoolR.Tasks.ProcessAlertData.Execute() in C:\Program Files (x86)\Go Agent\pipelines\coolr-portal-dev-task-service-new\CoolR.Tasks\ProcessAlertData.cs:line 48
   at DFramework.Scheduler.TaskBase.Run() in E:\Forked\Framework\DFramework.Scheduler\TaskBase.cs:line 176
   at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)
   at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)
   at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state)
   at System.Threading.ThreadHelper.ThreadStart() 
2026-01-14 01:36:36.7304 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 C:\Program Files (x86)\Go Agent\pipelines\coolr-portal-dev-task-service-new\CoolR.Tasks\ProcessAlertData.cs:line 48
   at DFramework.Scheduler.TaskBase.Run() in E:\Forked\Framework\DFramework.Scheduler\TaskBase.cs:line 176
   at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)
   at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)
   at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state)
   at System.Threading.ThreadHelper.ThreadStart() 
2026-01-14 01:36:36.9648 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 C:\Program Files (x86)\Go Agent\pipelines\coolr-portal-dev-task-service-new\CoolR.Tasks\ProcessAlertData.cs:line 48
   at DFramework.Scheduler.TaskBase.Run() in E:\Forked\Framework\DFramework.Scheduler\TaskBase.cs:line 176
   at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)
   at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)
   at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state)
   at System.Threading.ThreadHelper.ThreadStart() 
2026-01-14 01:36:37.3711 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:\Program Files (x86)\Go Agent\pipelines\coolr-portal-dev-task-service-new\CoolR.Tasks\ProcessAlertData.cs:line 48
   at DFramework.Scheduler.TaskBase.Run() in E:\Forked\Framework\DFramework.Scheduler\TaskBase.cs:line 176
   at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)
   at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)
   at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state)
   at System.Threading.ThreadHelper.ThreadStart() 
2026-01-14 01:36:37.4492 DFramework.Database.NullableDataReader    Data reader open for 1427
   at System.Environment.GetStackTrace(Exception e, Boolean needFileInfo)
   at System.Environment.get_StackTrace()
   at DFramework.Database.NullableDataReader.Dispose(Boolean disposing) in C:\CoolR-Group\Framework\DFramework\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:\Program Files (x86)\Go Agent\pipelines\coolr-portal-dev-task-service-new\CoolR.Tasks\ProcessAlertData.cs:line 48
   at DFramework.Scheduler.TaskBase.Run() in E:\Forked\Framework\DFramework.Scheduler\TaskBase.cs:line 176
   at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)
   at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)
   at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state)
   at System.Threading.ThreadHelper.ThreadStart() 
2026-01-14 01:36:38.5898 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:\Program Files (x86)\Go Agent\pipelines\coolr-portal-dev-task-service-new\CoolR.Tasks\ProcessAlertData.cs:line 48
   at DFramework.Scheduler.TaskBase.Run() in E:\Forked\Framework\DFramework.Scheduler\TaskBase.cs:line 176
   at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)
   at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)
   at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state)
   at System.Threading.ThreadHelper.ThreadStart() 
2026-01-14 01:36:38.6836 DFramework.Database.NullableDataReader    Data reader open for 872
   at System.Environment.GetStackTrace(Exception e, Boolean needFileInfo)
   at System.Environment.get_StackTrace()
   at DFramework.Database.NullableDataReader.Dispose(Boolean disposing) in C:\CoolR-Group\Framework\DFramework\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:\Program Files (x86)\Go Agent\pipelines\coolr-portal-dev-task-service-new\CoolR.Tasks\ProcessAlertData.cs:line 48
   at DFramework.Scheduler.TaskBase.Run() in E:\Forked\Framework\DFramework.Scheduler\TaskBase.cs:line 176
   at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)
   at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)
   at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state)
   at System.Threading.ThreadHelper.ThreadStart() 
2026-01-14 01:36:39.6523 DFramework.Database.NullableDataReader    Data reader open for 300
   at System.Environment.GetStackTrace(Exception e, Boolean needFileInfo)
   at System.Environment.get_StackTrace()
   at DFramework.Database.NullableDataReader.Dispose(Boolean disposing) in C:\CoolR-Group\Framework\DFramework\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:\Program Files (x86)\Go Agent\pipelines\coolr-portal-dev-task-service-new\CoolR.Tasks\ProcessAlertData.cs:line 48
   at DFramework.Scheduler.TaskBase.Run() in E:\Forked\Framework\DFramework.Scheduler\TaskBase.cs:line 176
   at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)
   at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)
   at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state)
   at System.Threading.ThreadHelper.ThreadStart() 
2026-01-14 01:36:39.7461 DFramework.Database.NullableDataReader    Data reader open for 700
   at System.Environment.GetStackTrace(Exception e, Boolean needFileInfo)
   at System.Environment.get_StackTrace()
   at DFramework.Database.NullableDataReader.Dispose(Boolean disposing) in C:\CoolR-Group\Framework\DFramework\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:\Program Files (x86)\Go Agent\pipelines\coolr-portal-dev-task-service-new\CoolR.Tasks\ProcessAlertData.cs:line 48
   at DFramework.Scheduler.TaskBase.Run() in E:\Forked\Framework\DFramework.Scheduler\TaskBase.cs:line 176
   at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)
   at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)
   at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state)
   at System.Threading.ThreadHelper.ThreadStart() 
2026-01-14 01:36:40.7773 DFramework.Database.Query    /* Time Taken: 1026*/
DECLARE @TableName AnsiString(8000)
SET @TableName = 'AssetStockProductWiseConsolidate'
DECLARE @CurrentRecordId Int32
SET @CurrentRecordId = '3676076'
dbo.GetValidDeviceForAlertProcessData