2026-01-12 00:09:40.6390 DFramework.Database.Query /* Time Taken: 523*/ [dbo].GenerateSystemAlerts 2026-01-12 00:09:55.4360 DFramework.Scheduler.TaskBase /* Time Taken: 15609.4932*/ Opportunity Out Of Stock By Outlet 2026-01-12 00:24:40.6460 DFramework.Database.Query /* Time Taken: 522*/ [dbo].GenerateSystemAlerts 2026-01-12 00:24:55.4274 DFramework.Scheduler.TaskBase /* Time Taken: 15578.2455*/ Opportunity Out Of Stock By Outlet 2026-01-12 00:39:40.6841 DFramework.Database.Query /* Time Taken: 534*/ [dbo].GenerateSystemAlerts 2026-01-12 00:39:55.4811 DFramework.Scheduler.TaskBase /* Time Taken: 15609.4949*/ Opportunity Out Of Stock By Outlet 2026-01-12 00:54:40.8318 DFramework.Database.Query /* Time Taken: 660*/ [dbo].GenerateSystemAlerts 2026-01-12 00:54:55.8006 DFramework.Scheduler.TaskBase /* Time Taken: 15922.0007*/ Opportunity Out Of Stock By Outlet 2026-01-12 01:09:40.7136 DFramework.Database.Query /* Time Taken: 518*/ [dbo].GenerateSystemAlerts 2026-01-12 01:09:55.4481 DFramework.Scheduler.TaskBase /* Time Taken: 15562.6149*/ Opportunity Out Of Stock By Outlet 2026-01-12 01:24:40.8141 DFramework.Database.Query /* Time Taken: 593*/ [dbo].GenerateSystemAlerts 2026-01-12 01:24:55.7049 DFramework.Scheduler.TaskBase /* Time Taken: 15796.998*/ Opportunity Out Of Stock By Outlet 2026-01-12 01:39:40.7273 DFramework.Database.Query /* Time Taken: 506*/ [dbo].GenerateSystemAlerts 2026-01-12 01:39:55.4774 DFramework.Scheduler.TaskBase /* Time Taken: 15546.9936*/ Opportunity Out Of Stock By Outlet 2026-01-12 01:54:40.7341 DFramework.Database.Query /* Time Taken: 504*/ [dbo].GenerateSystemAlerts 2026-01-12 01:54:55.4998 DFramework.Scheduler.TaskBase /* Time Taken: 15546.9936*/ Opportunity Out Of Stock By Outlet 2026-01-12 02:09:40.7878 DFramework.Database.Query /* Time Taken: 547*/ [dbo].GenerateSystemAlerts 2026-01-12 02:09:55.5536 DFramework.Scheduler.TaskBase /* Time Taken: 15578.2478*/ Opportunity Out Of Stock By Outlet 2026-01-12 02:24:40.7634 DFramework.Database.Query /* Time Taken: 510*/ [dbo].GenerateSystemAlerts 2026-01-12 02:24:55.5604 DFramework.Scheduler.TaskBase /* Time Taken: 15562.6203*/ Opportunity Out Of Stock By Outlet 2026-01-12 02:39:40.8329 DFramework.Database.Query /* Time Taken: 557*/ [dbo].GenerateSystemAlerts 2026-01-12 02:39:55.5674 DFramework.Scheduler.TaskBase /* Time Taken: 15562.6191*/ Opportunity Out Of Stock By Outlet 2026-01-12 02:54:55.5429 DFramework.Scheduler.TaskBase /* Time Taken: 15531.354*/ Opportunity Out Of Stock By Outlet 2026-01-12 03:09:40.8619 DFramework.Database.Query /* Time Taken: 544*/ [dbo].GenerateSystemAlerts 2026-01-12 03:09:55.6589 DFramework.Scheduler.TaskBase /* Time Taken: 15625.113*/ Opportunity Out Of Stock By Outlet 2026-01-12 03:24:55.5718 DFramework.Scheduler.TaskBase /* Time Taken: 15531.3561*/ Opportunity Out Of Stock By Outlet 2026-01-12 03:39:55.5629 DFramework.Scheduler.TaskBase /* Time Taken: 15515.7329*/ Opportunity Out Of Stock By Outlet 2026-01-12 03:54:41.1944 DFramework.Database.Query /* Time Taken: 797*/ [dbo].GenerateSystemAlerts 2026-01-12 03:54:55.7570 DFramework.Scheduler.TaskBase /* Time Taken: 15687.6161*/ Opportunity Out Of Stock By Outlet 2026-01-12 04:09:55.6386 DFramework.Scheduler.TaskBase /* Time Taken: 15546.9972*/ Opportunity Out Of Stock By Outlet 2026-01-12 04:24:40.9577 DFramework.Database.Query /* Time Taken: 515*/ [dbo].GenerateSystemAlerts 2026-01-12 04:24:55.6765 DFramework.Scheduler.TaskBase /* Time Taken: 15578.2411*/ Opportunity Out Of Stock By Outlet 2026-01-12 04:39:55.6520 DFramework.Scheduler.TaskBase /* Time Taken: 15531.3683*/ Opportunity Out Of Stock By Outlet 2026-01-12 04:54:26.3459 DFramework.Database.NullableDataReader Data reader open for 21576161 at System.Environment.GetStackTrace(Exception e, Boolean needFileInfo) at System.Environment.get_StackTrace() at DFramework.Database.NullableDataReader.Dispose(Boolean disposing) in C:\CoolR-Group\Framework\DFramework\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 343 at DFramework.Scheduler.TaskBase.Run() in D:\Spraxa\Framework\DFramework.Scheduler\TaskBase.cs:line 176 at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx) at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx) at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state) at System.Threading.ThreadHelper.ThreadStart() 2026-01-12 04:54:26.3459 DFramework.Database.NullableDataReader Data reader open for 21576245 at System.Environment.GetStackTrace(Exception e, Boolean needFileInfo) at System.Environment.get_StackTrace() at DFramework.Database.NullableDataReader.Dispose(Boolean disposing) in C:\CoolR-Group\Framework\DFramework\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 343 at DFramework.Scheduler.TaskBase.Run() in D:\Spraxa\Framework\DFramework.Scheduler\TaskBase.cs:line 176 at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx) at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx) at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state) at System.Threading.ThreadHelper.ThreadStart() 2026-01-12 04:54:26.6428 DFramework.Scheduler.TaskBase /* Time Taken: 21586913.0736*/ Process Alert Record 2026-01-12 04:54:37.3460 AlertProcessor ProcessorAlertData: started 2026-01-12 04:54:37.8772 DFramework.Database.Query /* Time Taken: 505*/ 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-12 04:54:37.9241 DFramework.Database.Query /* Time Taken: 572*/ 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-12 04:54:38.0022 DFramework.Database.Query /* Time Taken: 655*/ 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/12/2026 12:54:37 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-12 04:54:38.6585 DFramework.Database.Query /* Time Taken: 1251*/ 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-12 04:54:38.6897 DFramework.Database.Query /* Time Taken: 1269*/ 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-12 04:54:38.7054 DFramework.Database.Query /* Time Taken: 1292*/ [dbo].GenerateSystemAlerts 2026-01-12 04:54:38.7210 DFramework.Database.Query /* Time Taken: 1361*/ 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-12 04:54:38.7366 DFramework.Database.Query /* Time Taken: 1326*/ DECLARE @CreatedOn Date SET @CreatedOn = '1/12/2026 12:00:00 AM' DECLARE @EventId Int32 SET @EventId = '-12' SELECT COUNT(1) FROM EmailQueue WHERE [CreatedOn] >= @CreatedOn AND [EventId] = @EventId 2026-01-12 04:54:38.7522 DFramework.Database.Query /* Time Taken: 1330*/ 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/12/2026 12:54:37 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-12 04:54:38.7522 DFramework.Database.Query /* Time Taken: 1373*/ DECLARE @TableName AnsiString(8000) SET @TableName = 'TagAlert' DECLARE @CurrentRecordId Int32 SET @CurrentRecordId = '0' dbo.GetValidDeviceForAlertProcessData 2026-01-12 04:54:38.7679 DFramework.Database.Query /* Time Taken: 752*/ DECLARE @AlertDefinitionId Int32 SET @AlertDefinitionId = '99' DECLARE @IsDeleted Boolean SET @IsDeleted = 'False' SELECT ProductId FROM AlertDefinitionProduct WHERE [AlertDefinitionId] = @AlertDefinitionId AND IsDeleted = @IsDeleted 2026-01-12 04:54:38.7835 DFramework.Database.Query /* Time Taken: 1412*/ 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-12 04:54:38.7991 DFramework.Database.Query /* Time Taken: 822*/ DECLARE @AssetKPIData Object SET @AssetKPIData = '' [dbo].BulkUpsertAssetDayKPI 2026-01-12 04:54:38.8616 DFramework.Database.NullableDataReader Data reader open for 850 at System.Environment.GetStackTrace(Exception e, Boolean needFileInfo) at System.Environment.get_StackTrace() at DFramework.Database.NullableDataReader.Dispose(Boolean disposing) in C:\CoolR-Group\Framework\DFramework\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 D:\Spraxa\Framework\DFramework.Scheduler\TaskBase.cs:line 176 at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx) at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx) at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state) at System.Threading.ThreadHelper.ThreadStart() 2026-01-12 04:54:39.2522 DFramework.Database.NullableDataReader Data reader open for 487 at System.Environment.GetStackTrace(Exception e, Boolean needFileInfo) at System.Environment.get_StackTrace() at DFramework.Database.NullableDataReader.Dispose(Boolean disposing) in C:\CoolR-Group\Framework\DFramework\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 D:\Spraxa\Framework\DFramework.Scheduler\TaskBase.cs:line 176 at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx) at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx) at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state) at System.Threading.ThreadHelper.ThreadStart() 2026-01-12 04:54:39.9554 DFramework.Database.NullableDataReader Data reader open for 399 at System.Environment.GetStackTrace(Exception e, Boolean needFileInfo) at System.Environment.get_StackTrace() at DFramework.Database.NullableDataReader.Dispose(Boolean disposing) in C:\CoolR-Group\Framework\DFramework\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 D:\Spraxa\Framework\DFramework.Scheduler\TaskBase.cs:line 176 at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx) at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx) at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state) at System.Threading.ThreadHelper.ThreadStart() 2026-01-12 04:54:40.2835 DFramework.Database.NullableDataReader Data reader open for 755 at System.Environment.GetStackTrace(Exception e, Boolean needFileInfo) at System.Environment.get_StackTrace() at DFramework.Database.NullableDataReader.Dispose(Boolean disposing) in C:\CoolR-Group\Framework\DFramework\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 D:\Spraxa\Framework\DFramework.Scheduler\TaskBase.cs:line 176 at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx) at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx) at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state) at System.Threading.ThreadHelper.ThreadStart() 2026-01-12 04:54:41.0804 DFramework.Database.NullableDataReader Data reader open for 388 at System.Environment.GetStackTrace(Exception e, Boolean needFileInfo) at System.Environment.get_StackTrace() at DFramework.Database.NullableDataReader.Dispose(Boolean disposing) in C:\CoolR-Group\Framework\DFramework\Database\NullableDataReader.cs:line 33 at DFramework.Database.NullableDataReader.Dispose() in C:\CoolR-Group\Framework\DFramework\Database\NullableDataReader.cs:line 44 at CoolR.Tasks.ProcessAlertData.Execute() in 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 D:\Spraxa\Framework\DFramework.Scheduler\TaskBase.cs:line 176 at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx) at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx) at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state) at System.Threading.ThreadHelper.ThreadStart() 2026-01-12 04:54:41.8148 DFramework.Database.NullableDataReader Data reader open for 357 at System.Environment.GetStackTrace(Exception e, Boolean needFileInfo) at System.Environment.get_StackTrace() at DFramework.Database.NullableDataReader.Dispose(Boolean disposing) in C:\CoolR-Group\Framework\DFramework\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 D:\Spraxa\Framework\DFramework.Scheduler\TaskBase.cs:line 176 at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx) at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx) at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state) at System.Threading.ThreadHelper.ThreadStart() 2026-01-12 04:54:42.3773 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 D:\Spraxa\Framework\DFramework.Scheduler\TaskBase.cs:line 176 at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx) at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx) at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state) at System.Threading.ThreadHelper.ThreadStart() 2026-01-12 04:54:42.6898 DFramework.Database.NullableDataReader Data reader open for 290 at System.Environment.GetStackTrace(Exception e, Boolean needFileInfo) at System.Environment.get_StackTrace() at DFramework.Database.NullableDataReader.Dispose(Boolean disposing) in C:\CoolR-Group\Framework\DFramework\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 D:\Spraxa\Framework\DFramework.Scheduler\TaskBase.cs:line 176 at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx) at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx) at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state) at System.Threading.ThreadHelper.ThreadStart() 2026-01-12 04:54:42.9241 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 D:\Spraxa\Framework\DFramework.Scheduler\TaskBase.cs:line 176 at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx) at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx) at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state) at System.Threading.ThreadHelper.ThreadStart() 2026-01-12 04:54:43.4710 DFramework.Database.NullableDataReader Data reader open for 233 at System.Environment.GetStackTrace(Exception e, Boolean needFileInfo) at System.Environment.get_StackTrace() at DFramework.Database.NullableDataReader.Dispose(Boolean disposing) in C:\CoolR-Group\Framework\DFramework\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 D:\Spraxa\Framework\DFramework.Scheduler\TaskBase.cs:line 176 at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx) at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx) at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state) at System.Threading.ThreadHelper.ThreadStart() 2026-01-12 04:54:43.5492 DFramework.Database.NullableDataReader Data reader open for 1419 at System.Environment.GetStackTrace(Exception e, Boolean needFileInfo) at System.Environment.get_StackTrace() at DFramework.Database.NullableDataReader.Dispose(Boolean disposing) in C:\CoolR-Group\Framework\DFramework\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 D:\Spraxa\Framework\DFramework.Scheduler\TaskBase.cs:line 176 at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx) at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx) at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state) at System.Threading.ThreadHelper.ThreadStart() 2026-01-12 04:54:44.7523 DFramework.Database.NullableDataReader Data reader open for 275 at System.Environment.GetStackTrace(Exception e, Boolean needFileInfo) at System.Environment.get_StackTrace() at DFramework.Database.NullableDataReader.Dispose(Boolean disposing) in C:\CoolR-Group\Framework\DFramework\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 D:\Spraxa\Framework\DFramework.Scheduler\TaskBase.cs:line 176 at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx) at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx) at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state) at System.Threading.ThreadHelper.ThreadStart() 2026-01-12 04:54:44.8304 DFramework.Database.NullableDataReader Data reader open for 948 at System.Environment.GetStackTrace(Exception e, Boolean needFileInfo) at System.Environment.get_StackTrace() at DFramework.Database.NullableDataReader.Dispose(Boolean disposing) in C:\CoolR-Group\Framework\DFramework\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 D:\Spraxa\Framework\DFramework.Scheduler\TaskBase.cs:line 176 at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx) at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx) at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state) at System.Threading.ThreadHelper.ThreadStart() 2026-01-12 04:54:45.8304 DFramework.Database.NullableDataReader Data reader open for 301 at System.Environment.GetStackTrace(Exception e, Boolean needFileInfo) at System.Environment.get_StackTrace() at DFramework.Database.NullableDataReader.Dispose(Boolean disposing) in C:\CoolR-Group\Framework\DFramework\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 D:\Spraxa\Framework\DFramework.Scheduler\TaskBase.cs:line 176 at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx) at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx) at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state) at System.Threading.ThreadHelper.ThreadStart() 2026-01-12 04:54:45.9085 DFramework.Database.NullableDataReader Data reader open for 753 at System.Environment.GetStackTrace(Exception e, Boolean needFileInfo) at System.Environment.get_StackTrace() at DFramework.Database.NullableDataReader.Dispose(Boolean disposing) in C:\CoolR-Group\Framework\DFramework\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 D:\Spraxa\Framework\DFramework.Scheduler\TaskBase.cs:line 176 at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx) at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx) at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state) at System.Threading.ThreadHelper.ThreadStart() 2026-01-12 04:54:46.4867 DFramework.Database.Query /* Time Taken: 572*/ DECLARE @TableName AnsiString(8000) SET @TableName = 'AssetStockProductWiseConsolidate' DECLARE @CurrentRecordId Int32 SET @CurrentRecordId = '3675979' dbo.GetValidDeviceForAlertProcessData 2026-01-12 04:54:54.3774 DFramework.Scheduler.TaskBase /* Time Taken: 17046.9967*/ Opportunity Out Of Stock By Outlet 2026-01-12 05:00:01.9266 DFramework.Database.NullableDataReader Data reader open for 314867 at System.Environment.GetStackTrace(Exception e, Boolean needFileInfo) at System.Environment.get_StackTrace() at DFramework.Database.NullableDataReader.Dispose(Boolean disposing) in C:\CoolR-Group\Framework\DFramework\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 343 at DFramework.Scheduler.TaskBase.Run() in D:\Spraxa\Framework\DFramework.Scheduler\TaskBase.cs:line 176 at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx) at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx) at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state) at System.Threading.ThreadHelper.ThreadStart() 2026-01-12 05:00:01.9266 DFramework.Database.NullableDataReader Data reader open for 314951 at System.Environment.GetStackTrace(Exception e, Boolean needFileInfo) at System.Environment.get_StackTrace() at DFramework.Database.NullableDataReader.Dispose(Boolean disposing) in C:\CoolR-Group\Framework\DFramework\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 343 at DFramework.Scheduler.TaskBase.Run() in D:\Spraxa\Framework\DFramework.Scheduler\TaskBase.cs:line 176 at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx) at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx) at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state) at System.Threading.ThreadHelper.ThreadStart() 2026-01-12 05:00:02.1766 DFramework.Scheduler.TaskBase /* Time Taken: 324846.1918*/ Process Alert Record 2026-01-12 05:00:12.2860 AlertProcessor ProcessorAlertData: started 2026-01-12 05:00:12.9891 DFramework.Database.Query /* Time Taken: 634*/ 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-12 05:00:13.0360 DFramework.Database.Query /* Time Taken: 748*/ 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-12 05:00:13.0673 DFramework.Database.Query /* Time Taken: 715*/ DECLARE @CreatedOn Date SET @CreatedOn = '1/12/2026 12:00:00 AM' DECLARE @EventId Int32 SET @EventId = '-12' SELECT COUNT(1) FROM EmailQueue WHERE [CreatedOn] >= @CreatedOn AND [EventId] = @EventId 2026-01-12 05:00:13.0985 DFramework.Database.Query /* Time Taken: 811*/ 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-12 05:00:13.2391 DFramework.Database.Query /* Time Taken: 935*/ 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-12 05:00:13.3954 DFramework.Database.Query /* Time Taken: 1052*/ 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-12 05:00:13.4266 DFramework.Database.Query /* Time Taken: 1087*/ 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-12 05:00:13.4579 DFramework.Database.Query /* Time Taken: 1169*/ 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/12/2026 1:00:12 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-12 05:00:13.5516 DFramework.Database.Query /* Time Taken: 1255*/ 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-12 05:00:13.5829 DFramework.Database.Query /* Time Taken: 1232*/ 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/12/2026 1:00:12 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-12 05:00:13.6610 DFramework.Database.Query /* Time Taken: 860*/ DECLARE @AssetKPIData Object SET @AssetKPIData = '' [dbo].BulkUpsertAssetDayKPI 2026-01-12 05:00:13.7860 DFramework.Database.Query /* Time Taken: 961*/ DECLARE @OrderStatusId Int32 SET @OrderStatusId = '5484' DECLARE @CurrentUtcDateTime DateTime2 SET @CurrentUtcDateTime = '1/12/2026 1:00:12 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-12 05:00:13.8173 DFramework.Database.Query /* Time Taken: 794*/ DECLARE @AppConfigId Int32 SET @AppConfigId = '1' SELECT * FROM AppConfig WHERE [AppConfigId] = @AppConfigId ORDER BY [AppConfigId] 2026-01-12 05:00:13.8329 DFramework.Database.Query /* Time Taken: 1473*/ [dbo].GenerateSystemAlerts 2026-01-12 05:00:13.8329 DFramework.Database.Query /* Time Taken: 1519*/ DECLARE @TableName AnsiString(8000) SET @TableName = 'TagAlert' DECLARE @CurrentRecordId Int32 SET @CurrentRecordId = '0' dbo.GetValidDeviceForAlertProcessData 2026-01-12 05:00:13.8485 DFramework.Database.Query /* Time Taken: 1546*/ 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-12 05:00:14.0517 DFramework.Database.Query /* Time Taken: 597*/ DECLARE @AlertDefinitionId Int32 SET @AlertDefinitionId = '99' DECLARE @IsDeleted Boolean SET @IsDeleted = 'False' SELECT ProductId FROM AlertDefinitionProduct WHERE [AlertDefinitionId] = @AlertDefinitionId AND IsDeleted = @IsDeleted 2026-01-12 05:00:14.1141 DFramework.Database.NullableDataReader Data reader open for 656 at System.Environment.GetStackTrace(Exception e, Boolean needFileInfo) at System.Environment.get_StackTrace() at DFramework.Database.NullableDataReader.Dispose(Boolean disposing) in C:\CoolR-Group\Framework\DFramework\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 D:\Spraxa\Framework\DFramework.Scheduler\TaskBase.cs:line 176 at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx) at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx) at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state) at System.Threading.ThreadHelper.ThreadStart() 2026-01-12 05:00:14.3017 DFramework.Database.NullableDataReader Data reader open for 460 at System.Environment.GetStackTrace(Exception e, Boolean needFileInfo) at System.Environment.get_StackTrace() at DFramework.Database.NullableDataReader.Dispose(Boolean disposing) in C:\CoolR-Group\Framework\DFramework\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 D:\Spraxa\Framework\DFramework.Scheduler\TaskBase.cs:line 176 at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx) at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx) at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state) at System.Threading.ThreadHelper.ThreadStart() 2026-01-12 05:00:14.9892 DFramework.Database.NullableDataReader Data reader open for 381 at System.Environment.GetStackTrace(Exception e, Boolean needFileInfo) at System.Environment.get_StackTrace() at DFramework.Database.NullableDataReader.Dispose(Boolean disposing) in C:\CoolR-Group\Framework\DFramework\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 D:\Spraxa\Framework\DFramework.Scheduler\TaskBase.cs:line 176 at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx) at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx) at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state) at System.Threading.ThreadHelper.ThreadStart() 2026-01-12 05:00:15.3173 DFramework.Database.NullableDataReader Data reader open for 733 at System.Environment.GetStackTrace(Exception e, Boolean needFileInfo) at System.Environment.get_StackTrace() at DFramework.Database.NullableDataReader.Dispose(Boolean disposing) in C:\CoolR-Group\Framework\DFramework\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 D:\Spraxa\Framework\DFramework.Scheduler\TaskBase.cs:line 176 at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx) at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx) at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state) at System.Threading.ThreadHelper.ThreadStart() 2026-01-12 05:00:16.0673 DFramework.Database.NullableDataReader Data reader open for 386 at System.Environment.GetStackTrace(Exception e, Boolean needFileInfo) at System.Environment.get_StackTrace() at DFramework.Database.NullableDataReader.Dispose(Boolean disposing) in C:\CoolR-Group\Framework\DFramework\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 D:\Spraxa\Framework\DFramework.Scheduler\TaskBase.cs:line 176 at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx) at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx) at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state) at System.Threading.ThreadHelper.ThreadStart() 2026-01-12 05:00:16.7860 DFramework.Database.NullableDataReader Data reader open for 359 at System.Environment.GetStackTrace(Exception e, Boolean needFileInfo) at System.Environment.get_StackTrace() at DFramework.Database.NullableDataReader.Dispose(Boolean disposing) in C:\CoolR-Group\Framework\DFramework\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 D:\Spraxa\Framework\DFramework.Scheduler\TaskBase.cs:line 176 at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx) at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx) at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state) at System.Threading.ThreadHelper.ThreadStart() 2026-01-12 05:00:17.3485 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 D:\Spraxa\Framework\DFramework.Scheduler\TaskBase.cs:line 176 at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx) at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx) at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state) at System.Threading.ThreadHelper.ThreadStart() 2026-01-12 05:00:17.6611 DFramework.Database.NullableDataReader Data reader open for 259 at System.Environment.GetStackTrace(Exception e, Boolean needFileInfo) at System.Environment.get_StackTrace() at DFramework.Database.NullableDataReader.Dispose(Boolean disposing) in C:\CoolR-Group\Framework\DFramework\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 D:\Spraxa\Framework\DFramework.Scheduler\TaskBase.cs:line 176 at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx) at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx) at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state) at System.Threading.ThreadHelper.ThreadStart() 2026-01-12 05:00:17.8798 DFramework.Database.NullableDataReader Data reader open for 203 at System.Environment.GetStackTrace(Exception e, Boolean needFileInfo) at System.Environment.get_StackTrace() at DFramework.Database.NullableDataReader.Dispose(Boolean disposing) in C:\CoolR-Group\Framework\DFramework\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 D:\Spraxa\Framework\DFramework.Scheduler\TaskBase.cs:line 176 at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx) at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx) at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state) at System.Threading.ThreadHelper.ThreadStart() 2026-01-12 05:00:18.1767 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:\Program Files (x86)\Go Agent\pipelines\coolr-portal-dev-task-service-new\CoolR.Tasks\ProcessAlertData.cs:line 48 at DFramework.Scheduler.TaskBase.Run() in D:\Spraxa\Framework\DFramework.Scheduler\TaskBase.cs:line 176 at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx) at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx) at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state) at System.Threading.ThreadHelper.ThreadStart() 2026-01-12 05:00:18.4111 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:\Program Files (x86)\Go Agent\pipelines\coolr-portal-dev-task-service-new\CoolR.Tasks\ProcessAlertData.cs:line 48 at DFramework.Scheduler.TaskBase.Run() in D:\Spraxa\Framework\DFramework.Scheduler\TaskBase.cs:line 176 at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx) at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx) at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state) at System.Threading.ThreadHelper.ThreadStart() 2026-01-12 05:00:18.5048 DFramework.Database.NullableDataReader Data reader open for 1387 at System.Environment.GetStackTrace(Exception e, Boolean needFileInfo) at System.Environment.get_StackTrace() at DFramework.Database.NullableDataReader.Dispose(Boolean disposing) in C:\CoolR-Group\Framework\DFramework\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 D:\Spraxa\Framework\DFramework.Scheduler\TaskBase.cs:line 176 at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx) at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx) at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state) at System.Threading.ThreadHelper.ThreadStart() 2026-01-12 05:00:19.6767 DFramework.Database.NullableDataReader Data reader open for 261 at System.Environment.GetStackTrace(Exception e, Boolean needFileInfo) at System.Environment.get_StackTrace() at DFramework.Database.NullableDataReader.Dispose(Boolean disposing) in C:\CoolR-Group\Framework\DFramework\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 D:\Spraxa\Framework\DFramework.Scheduler\TaskBase.cs:line 176 at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx) at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx) at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state) at System.Threading.ThreadHelper.ThreadStart() 2026-01-12 05:00:19.7548 DFramework.Database.NullableDataReader Data reader open for 938 at System.Environment.GetStackTrace(Exception e, Boolean needFileInfo) at System.Environment.get_StackTrace() at DFramework.Database.NullableDataReader.Dispose(Boolean disposing) in C:\CoolR-Group\Framework\DFramework\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 D:\Spraxa\Framework\DFramework.Scheduler\TaskBase.cs:line 176 at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx) at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx) at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state) at System.Threading.ThreadHelper.ThreadStart() 2026-01-12 05:00:20.7548 DFramework.Database.NullableDataReader Data reader open for 296 at System.Environment.GetStackTrace(Exception e, Boolean needFileInfo) at System.Environment.get_StackTrace() at DFramework.Database.NullableDataReader.Dispose(Boolean disposing) in C:\CoolR-Group\Framework\DFramework\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 D:\Spraxa\Framework\DFramework.Scheduler\TaskBase.cs:line 176 at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx) at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx) at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state) at System.Threading.ThreadHelper.ThreadStart() 2026-01-12 05:00:20.8329 DFramework.Database.NullableDataReader Data reader open for 748 at System.Environment.GetStackTrace(Exception e, Boolean needFileInfo) at System.Environment.get_StackTrace() at DFramework.Database.NullableDataReader.Dispose(Boolean disposing) in C:\CoolR-Group\Framework\DFramework\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 D:\Spraxa\Framework\DFramework.Scheduler\TaskBase.cs:line 176 at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx) at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx) at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state) at System.Threading.ThreadHelper.ThreadStart() 2026-01-12 05:00:21.4111 DFramework.Database.Query /* Time Taken: 570*/ DECLARE @TableName AnsiString(8000) SET @TableName = 'AssetStockProductWiseConsolidate' DECLARE @CurrentRecordId Int32 SET @CurrentRecordId = '3675979' dbo.GetValidDeviceForAlertProcessData 2026-01-12 05:00:29.6143 DFramework.Scheduler.TaskBase /* Time Taken: 17343.8795*/ Opportunity Out Of Stock By Outlet 2026-01-12 05:15:12.9804 DFramework.Database.Query /* Time Taken: 605*/ [dbo].GenerateSystemAlerts 2026-01-12 05:15:27.9805 DFramework.Scheduler.TaskBase /* Time Taken: 15687.621*/ Opportunity Out Of Stock By Outlet 2026-01-12 05:30:12.6590 DFramework.Database.NullableDataReader Data reader open for 327 at System.Environment.GetStackTrace(Exception e, Boolean needFileInfo) at System.Environment.get_StackTrace() at DFramework.Database.NullableDataReader.Dispose(Boolean disposing) in C:\CoolR-Group\Framework\DFramework\Database\NullableDataReader.cs:line 33 at DFramework.Database.NullableDataReader.Dispose() in C:\CoolR-Group\Framework\DFramework\Database\NullableDataReader.cs:line 44 at CoolR.Tasks.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 D:\Spraxa\Framework\DFramework.Scheduler\TaskBase.cs:line 176 at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx) at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx) at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state) at System.Threading.ThreadHelper.ThreadStart() 2026-01-12 05:30:13.0340 DFramework.Database.Query /* Time Taken: 635*/ [dbo].GenerateSystemAlerts 2026-01-12 05:30:28.2372 DFramework.Scheduler.TaskBase /* Time Taken: 15921.9945*/ Opportunity Out Of Stock By Outlet 2026-01-12 05:38:25.7877 DFramework.Database.NullableDataReader Data reader open for 2283796 at System.Environment.GetStackTrace(Exception e, Boolean needFileInfo) at System.Environment.get_StackTrace() at DFramework.Database.NullableDataReader.Dispose(Boolean disposing) in C:\CoolR-Group\Framework\DFramework\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 343 at DFramework.Scheduler.TaskBase.Run() in D:\Spraxa\Framework\DFramework.Scheduler\TaskBase.cs:line 176 at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx) at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx) at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state) at System.Threading.ThreadHelper.ThreadStart() 2026-01-12 05:38:25.7877 DFramework.Database.NullableDataReader Data reader open for 2283880 at System.Environment.GetStackTrace(Exception e, Boolean needFileInfo) at System.Environment.get_StackTrace() at DFramework.Database.NullableDataReader.Dispose(Boolean disposing) in C:\CoolR-Group\Framework\DFramework\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 343 at DFramework.Scheduler.TaskBase.Run() in D:\Spraxa\Framework\DFramework.Scheduler\TaskBase.cs:line 176 at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx) at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx) at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state) at System.Threading.ThreadHelper.ThreadStart() 2026-01-12 05:38:26.0377 DFramework.Scheduler.TaskBase /* Time Taken: 2293767.3334*/ Process Alert Record 2026-01-12 05:38:37.3816 AlertProcessor ProcessorAlertData: started 2026-01-12 05:38:38.0691 DFramework.Database.Query /* Time Taken: 655*/ DECLARE @TableName AnsiString(8000) SET @TableName = 'TagAlert' DECLARE @CurrentRecordId Int32 SET @CurrentRecordId = '0' dbo.GetValidDeviceForAlertProcessData 2026-01-12 05:38:38.1316 DFramework.Database.Query /* Time Taken: 706*/ 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-12 05:38:38.1784 DFramework.Database.Query /* Time Taken: 743*/ 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-12 05:38:38.2097 DFramework.Database.Query /* Time Taken: 773*/ 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-12 05:38:38.2409 DFramework.Database.Query /* Time Taken: 803*/ 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-12 05:38:38.2722 DFramework.Database.Query /* Time Taken: 833*/ 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-12 05:38:38.3034 DFramework.Database.Query /* Time Taken: 866*/ 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-12 05:38:38.3191 DFramework.Database.Query /* Time Taken: 877*/ DECLARE @OrderStatusId Int32 SET @OrderStatusId = '5486' DECLARE @CurrentUtcDateTime DateTime2 SET @CurrentUtcDateTime = '1/12/2026 1:38:37 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-12 05:38:38.3347 DFramework.Database.Query /* Time Taken: 891*/ 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/12/2026 1:38:37 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-12 05:38:38.3659 DFramework.Database.Query /* Time Taken: 921*/ 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-12 05:38:38.3972 DFramework.Database.Query /* Time Taken: 954*/ DECLARE @CreatedOn Date SET @CreatedOn = '1/12/2026 12:00:00 AM' DECLARE @EventId Int32 SET @EventId = '-12' SELECT COUNT(1) FROM EmailQueue WHERE [CreatedOn] >= @CreatedOn AND [EventId] = @EventId 2026-01-12 05:38:38.4284 DFramework.Database.Query /* Time Taken: 813*/ DECLARE @AlertDefinitionId Int32 SET @AlertDefinitionId = '99' DECLARE @IsDeleted Boolean SET @IsDeleted = 'False' SELECT ProductId FROM AlertDefinitionProduct WHERE [AlertDefinitionId] = @AlertDefinitionId AND IsDeleted = @IsDeleted 2026-01-12 05:38:38.5378 DFramework.Database.Query /* Time Taken: 1102*/ 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-12 05:38:38.6941 DFramework.Database.NullableDataReader Data reader open for 1081 at System.Environment.GetStackTrace(Exception e, Boolean needFileInfo) at System.Environment.get_StackTrace() at DFramework.Database.NullableDataReader.Dispose(Boolean disposing) in C:\CoolR-Group\Framework\DFramework\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 D:\Spraxa\Framework\DFramework.Scheduler\TaskBase.cs:line 176 at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx) at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx) at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state) at System.Threading.ThreadHelper.ThreadStart() 2026-01-12 05:38:38.8034 DFramework.Database.Query /* Time Taken: 729*/ 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 = '56019' DECLARE @AlertDefinition_ClientId0 Int32 SET @AlertDefinition_ClientId0 = '0' DECLARE @AlertDefinition_ClientId1 Int32 SET @AlertDefinition_ClientId1 = '213' DECLARE @AssetModelId0 Int32 SET @AssetModelId0 = '0' DECLARE @AssetModelId1 Int32 SET @AssetModelId1 = '1001' DECLARE @MarketId0 Int32 SET @MarketId0 = '0' DECLARE @MarketId1 Int32 SET @MarketId1 = '754' DECLARE @ClassificationId0 Int32 SET @ClassificationId0 = '0' DECLARE @ClassificationId1 Int32 SET @ClassificationId1 = '0' DECLARE @LocationTypeId0 Int32 SET @LocationTypeId0 = '0' DECLARE @LocationTypeId1 Int32 SET @LocationTypeId1 = '0' DECLARE @LocationId0 Int32 SET @LocationId0 = '0' DECLARE @LocationId1 Int32 SET @LocationId1 = '340875' 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-12 05:38:38.8659 DFramework.Database.Query /* Time Taken: 1432*/ [dbo].GenerateSystemAlerts 2026-01-12 05:38:39.1784 MoveToReorder Running task for ClientId : 286 and ClientName = India Office QA and Slot: 1/12/2026 8:00:00 AM And LastExecutedOn: 1/7/2026 9:24:32 AM 2026-01-12 05:38:39.2409 DFramework.Database.NullableDataReader Data reader open for 1176 at System.Environment.GetStackTrace(Exception e, Boolean needFileInfo) at System.Environment.get_StackTrace() at DFramework.Database.NullableDataReader.Dispose(Boolean disposing) in C:\CoolR-Group\Framework\DFramework\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 D:\Spraxa\Framework\DFramework.Scheduler\TaskBase.cs:line 176 at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx) at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx) at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state) at System.Threading.ThreadHelper.ThreadStart() 2026-01-12 05:38:39.8503 DFramework.Database.Query /* Time Taken: 600*/ DECLARE @TableName AnsiString(8000) SET @TableName = 'VoidAlert' DECLARE @CurrentRecordId Int32 SET @CurrentRecordId = '3675979' dbo.GetValidDeviceForAlertProcessData 2026-01-12 05:38:39.8659 DFramework.Database.Query /* Time Taken: 630*/ DECLARE @OrderStatusId Int32 SET @OrderStatusId = '0' DECLARE @ClientId Int32 SET @ClientId = '286' dbo.GetOrderDetailsByClientId 2026-01-12 05:38:40.2878 DFramework.Database.NullableDataReader Data reader open for 413 at System.Environment.GetStackTrace(Exception e, Boolean needFileInfo) at System.Environment.get_StackTrace() at DFramework.Database.NullableDataReader.Dispose(Boolean disposing) in C:\CoolR-Group\Framework\DFramework\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 D:\Spraxa\Framework\DFramework.Scheduler\TaskBase.cs:line 176 at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx) at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx) at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state) at System.Threading.ThreadHelper.ThreadStart() 2026-01-12 05:38:40.5847 DFramework.Database.NullableDataReader Data reader open for 203 at System.Environment.GetStackTrace(Exception e, Boolean needFileInfo) at System.Environment.get_StackTrace() at DFramework.Database.NullableDataReader.Dispose(Boolean disposing) in C:\CoolR-Group\Framework\DFramework\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 D:\Spraxa\Framework\DFramework.Scheduler\TaskBase.cs:line 176 at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx) at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx) at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state) at System.Threading.ThreadHelper.ThreadStart() 2026-01-12 05:38:40.6472 DFramework.Database.NullableDataReader Data reader open for 799 at System.Environment.GetStackTrace(Exception e, Boolean needFileInfo) at System.Environment.get_StackTrace() at DFramework.Database.NullableDataReader.Dispose(Boolean disposing) in C:\CoolR-Group\Framework\DFramework\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 D:\Spraxa\Framework\DFramework.Scheduler\TaskBase.cs:line 176 at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx) at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx) at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state) at System.Threading.ThreadHelper.ThreadStart() 2026-01-12 05:38:41.4441 DFramework.Database.NullableDataReader Data reader open for 421 at System.Environment.GetStackTrace(Exception e, Boolean needFileInfo) at System.Environment.get_StackTrace() at DFramework.Database.NullableDataReader.Dispose(Boolean disposing) in C:\CoolR-Group\Framework\DFramework\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 D:\Spraxa\Framework\DFramework.Scheduler\TaskBase.cs:line 176 at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx) at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx) at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state) at System.Threading.ThreadHelper.ThreadStart() 2026-01-12 05:38:42.2097 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.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 D:\Spraxa\Framework\DFramework.Scheduler\TaskBase.cs:line 176 at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx) at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx) at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state) at System.Threading.ThreadHelper.ThreadStart() 2026-01-12 05:38:42.7878 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 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 D:\Spraxa\Framework\DFramework.Scheduler\TaskBase.cs:line 176 at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx) at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx) at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state) at System.Threading.ThreadHelper.ThreadStart() 2026-01-12 05:38:43.0535 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 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 D:\Spraxa\Framework\DFramework.Scheduler\TaskBase.cs:line 176 at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx) at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx) at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state) at System.Threading.ThreadHelper.ThreadStart() 2026-01-12 05:38:43.3035 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 D:\Spraxa\Framework\DFramework.Scheduler\TaskBase.cs:line 176 at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx) at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx) at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state) at System.Threading.ThreadHelper.ThreadStart() 2026-01-12 05:38:43.6160 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:\Program Files (x86)\Go Agent\pipelines\coolr-portal-dev-task-service-new\CoolR.Tasks\ProcessAlertData.cs:line 48 at DFramework.Scheduler.TaskBase.Run() in D:\Spraxa\Framework\DFramework.Scheduler\TaskBase.cs:line 176 at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx) at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx) at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state) at System.Threading.ThreadHelper.ThreadStart() 2026-01-12 05:38:43.8504 DFramework.Database.NullableDataReader Data reader open for 212 at System.Environment.GetStackTrace(Exception e, Boolean needFileInfo) at System.Environment.get_StackTrace() at DFramework.Database.NullableDataReader.Dispose(Boolean disposing) in C:\CoolR-Group\Framework\DFramework\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 D:\Spraxa\Framework\DFramework.Scheduler\TaskBase.cs:line 176 at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx) at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx) at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state) at System.Threading.ThreadHelper.ThreadStart() 2026-01-12 05:38:43.9441 DFramework.Database.NullableDataReader Data reader open for 1407 at System.Environment.GetStackTrace(Exception e, Boolean needFileInfo) at System.Environment.get_StackTrace() at DFramework.Database.NullableDataReader.Dispose(Boolean disposing) in C:\CoolR-Group\Framework\DFramework\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 D:\Spraxa\Framework\DFramework.Scheduler\TaskBase.cs:line 176 at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx) at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx) at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state) at System.Threading.ThreadHelper.ThreadStart() 2026-01-12 05:38:45.2254 DFramework.Database.NullableDataReader Data reader open for 274 at System.Environment.GetStackTrace(Exception e, Boolean needFileInfo) at System.Environment.get_StackTrace() at DFramework.Database.NullableDataReader.Dispose(Boolean disposing) in C:\CoolR-Group\Framework\DFramework\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 D:\Spraxa\Framework\DFramework.Scheduler\TaskBase.cs:line 176 at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx) at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx) at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state) at System.Threading.ThreadHelper.ThreadStart() 2026-01-12 05:38:45.3035 DFramework.Database.NullableDataReader Data reader open for 998 at System.Environment.GetStackTrace(Exception e, Boolean needFileInfo) at System.Environment.get_StackTrace() at DFramework.Database.NullableDataReader.Dispose(Boolean disposing) in C:\CoolR-Group\Framework\DFramework\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 D:\Spraxa\Framework\DFramework.Scheduler\TaskBase.cs:line 176 at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx) at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx) at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state) at System.Threading.ThreadHelper.ThreadStart() 2026-01-12 05:38:46.3191 DFramework.Database.NullableDataReader Data reader open for 321 at System.Environment.GetStackTrace(Exception e, Boolean needFileInfo) at System.Environment.get_StackTrace() at DFramework.Database.NullableDataReader.Dispose(Boolean disposing) in C:\CoolR-Group\Framework\DFramework\Database\NullableDataReader.cs:line 33 at DFramework.Database.NullableDataReader.Dispose() in C:\CoolR-Group\Framework\DFramework\Database\NullableDataReader.cs:line 44 at CoolR.Tasks.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 D:\Spraxa\Framework\DFramework.Scheduler\TaskBase.cs:line 176 at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx) at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx) at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state) at System.Threading.ThreadHelper.ThreadStart() 2026-01-12 05:38:46.4129 DFramework.Database.NullableDataReader Data reader open for 811 at System.Environment.GetStackTrace(Exception e, Boolean needFileInfo) at System.Environment.get_StackTrace() at DFramework.Database.NullableDataReader.Dispose(Boolean disposing) in C:\CoolR-Group\Framework\DFramework\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 D:\Spraxa\Framework\DFramework.Scheduler\TaskBase.cs:line 176 at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx) at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx) at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state) at System.Threading.ThreadHelper.ThreadStart() 2026-01-12 05:38:46.9910 DFramework.Database.Query /* Time Taken: 580*/ DECLARE @TableName AnsiString(8000) SET @TableName = 'AssetStockProductWiseConsolidate' DECLARE @CurrentRecordId Int32 SET @CurrentRecordId = '3675979' dbo.GetValidDeviceForAlertProcessData 2026-01-12 05:38:54.2567 DFramework.Scheduler.TaskBase /* Time Taken: 17156.3936*/ Opportunity Out Of Stock By Outlet 2026-01-12 05:39:17.5694 DFramework.Database.NullableDataReader Data reader open for 37596 at System.Environment.GetStackTrace(Exception e, Boolean needFileInfo) at System.Environment.get_StackTrace() at DFramework.Database.NullableDataReader.Dispose(Boolean disposing) in C:\CoolR-Group\Framework\DFramework\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:\Program Files (x86)\Go Agent\pipelines\coolr-portal-dev-task-service-new\CoolR.Tasks\MoveToReorder.cs:line 50 at DFramework.Scheduler.TaskBase.Run() in D:\Spraxa\Framework\DFramework.Scheduler\TaskBase.cs:line 176 at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx) at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx) at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state) at System.Threading.ThreadHelper.ThreadStart() 2026-01-12 05:39:17.6006 MoveToReorder Task executed successfully for ClientId : 286 Client Name:India Office QA, Slot: 1/12/2026 8:00:00 AM and Total Order Suggested: 123 Out Of: 123 2026-01-12 05:39:18.1319 DFramework.Scheduler.TaskBase /* Time Taken: 40719.058*/ Move To Re-Order 2026-01-12 05:53:52.6694 DFramework.Scheduler.TaskBase /* Time Taken: 15562.6252*/ Opportunity Out Of Stock By Outlet 2026-01-12 06:08:38.0509 DFramework.Database.Query /* Time Taken: 587*/ [dbo].GenerateSystemAlerts 2026-01-12 06:08:52.6917 DFramework.Scheduler.TaskBase /* Time Taken: 15562.6123*/ Opportunity Out Of Stock By Outlet 2026-01-12 06:23:38.1359 DFramework.Database.Query /* Time Taken: 666*/ [dbo].GenerateSystemAlerts 2026-01-12 06:23:52.7454 DFramework.Scheduler.TaskBase /* Time Taken: 15593.87*/ Opportunity Out Of Stock By Outlet 2026-01-12 06:38:37.9083 MoveToReorder Running task for ClientId : 286 and ClientName = India Office QA and Slot: 1/12/2026 8:00:00 PM And LastExecutedOn: 1/12/2026 7:08:39 PM 2026-01-12 06:38:38.0177 DFramework.Database.Query /* Time Taken: 539*/ [dbo].GenerateSystemAlerts 2026-01-12 06:38:38.1583 MoveToReorder Task executed successfully for ClientId : 286 Client Name:India Office QA, Slot: 1/12/2026 8:00:00 PM But No Order found to suggest 2026-01-12 06:38:52.7053 DFramework.Scheduler.TaskBase /* Time Taken: 15546.9961*/ Opportunity Out Of Stock By Outlet 2026-01-12 06:53:38.0090 DFramework.Database.Query /* Time Taken: 521*/ [dbo].GenerateSystemAlerts 2026-01-12 06:53:52.7435 DFramework.Scheduler.TaskBase /* Time Taken: 15562.6239*/ Opportunity Out Of Stock By Outlet 2026-01-12 07:08:38.3596 DFramework.Database.Query /* Time Taken: 850*/ [dbo].GenerateSystemAlerts 2026-01-12 07:08:52.7659 DFramework.Scheduler.TaskBase /* Time Taken: 15562.6163*/ Opportunity Out Of Stock By Outlet 2026-01-12 07:23:52.7884 DFramework.Scheduler.TaskBase /* Time Taken: 15562.6263*/ Opportunity Out Of Stock By Outlet 2026-01-12 07:38:38.1545 DFramework.Database.Query /* Time Taken: 604*/ [dbo].GenerateSystemAlerts 2026-01-12 07:38:38.2326 MoveToReorder Running task for ClientId : 286 and ClientName = India Office QA and Slot: 1/12/2026 9:00:00 PM And LastExecutedOn: 1/12/2026 8:08:37 PM 2026-01-12 07:38:38.5763 MoveToReorder Task executed successfully for ClientId : 286 Client Name:India Office QA, Slot: 1/12/2026 9:00:00 PM and Total Order Suggested: 1 Out Of: 1 2026-01-12 07:38:53.0764 DFramework.Scheduler.TaskBase /* Time Taken: 15843.859*/ Opportunity Out Of Stock By Outlet 2026-01-12 07:53:52.7551 DFramework.Scheduler.TaskBase /* Time Taken: 15500.1315*/ Opportunity Out Of Stock By Outlet 2026-01-12 08:08:38.1211 DFramework.Database.Query /* Time Taken: 529*/ [dbo].GenerateSystemAlerts 2026-01-12 08:08:52.7618 DFramework.Scheduler.TaskBase /* Time Taken: 15484.4868*/ Opportunity Out Of Stock By Outlet 2026-01-12 08:23:38.2372 DFramework.Database.Query /* Time Taken: 622*/ [dbo].GenerateSystemAlerts 2026-01-12 08:23:52.7998 DFramework.Scheduler.TaskBase /* Time Taken: 15515.7414*/ Opportunity Out Of Stock By Outlet 2026-01-12 08:38:38.0566 MoveToReorder Running task for ClientId : 286 and ClientName = India Office QA and Slot: 1/12/2026 10:00:00 PM And LastExecutedOn: 1/12/2026 9:08:38 PM 2026-01-12 08:38:38.3691 DFramework.Database.Query /* Time Taken: 725*/ [dbo].GenerateSystemAlerts 2026-01-12 08:38:52.8536 DFramework.Scheduler.TaskBase /* Time Taken: 15562.6206*/ Opportunity Out Of Stock By Outlet 2026-01-12 08:39:15.2443 DFramework.Database.NullableDataReader Data reader open for 36762 at System.Environment.GetStackTrace(Exception e, Boolean needFileInfo) at System.Environment.get_StackTrace() at DFramework.Database.NullableDataReader.Dispose(Boolean disposing) in C:\CoolR-Group\Framework\DFramework\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:\Program Files (x86)\Go Agent\pipelines\coolr-portal-dev-task-service-new\CoolR.Tasks\MoveToReorder.cs:line 50 at DFramework.Scheduler.TaskBase.Run() in D:\Spraxa\Framework\DFramework.Scheduler\TaskBase.cs:line 176 at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx) at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx) at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state) at System.Threading.ThreadHelper.ThreadStart() 2026-01-12 08:39:15.2756 MoveToReorder Task executed successfully for ClientId : 286 Client Name:India Office QA, Slot: 1/12/2026 10:00:00 PM and Total Order Suggested: 123 Out Of: 123 2026-01-12 08:39:15.6350 DFramework.Scheduler.TaskBase /* Time Taken: 37984.6648*/ Move To Re-Order 2026-01-12 08:53:38.2036 DFramework.Database.Query /* Time Taken: 536*/ [dbo].GenerateSystemAlerts 2026-01-12 08:53:52.8131 DFramework.Scheduler.TaskBase /* Time Taken: 15515.732*/ Opportunity Out Of Stock By Outlet 2026-01-12 09:08:38.2260 DFramework.Database.Query /* Time Taken: 551*/ [dbo].GenerateSystemAlerts 2026-01-12 09:08:52.8512 DFramework.Scheduler.TaskBase /* Time Taken: 15531.3666*/ Opportunity Out Of Stock By Outlet 2026-01-12 09:23:38.2172 DFramework.Database.Query /* Time Taken: 533*/ [dbo].GenerateSystemAlerts 2026-01-12 09:23:52.8579 DFramework.Scheduler.TaskBase /* Time Taken: 15515.7357*/ Opportunity Out Of Stock By Outlet 2026-01-12 09:38:38.2552 DFramework.Database.Query /* Time Taken: 568*/ [dbo].GenerateSystemAlerts 2026-01-12 09:38:52.8959 DFramework.Scheduler.TaskBase /* Time Taken: 15531.372*/ Opportunity Out Of Stock By Outlet 2026-01-12 09:53:38.2464 DFramework.Database.Query /* Time Taken: 535*/ [dbo].GenerateSystemAlerts 2026-01-12 09:53:52.9027 DFramework.Scheduler.TaskBase /* Time Taken: 15531.3676*/ Opportunity Out Of Stock By Outlet 2026-01-12 10:08:38.3939 DFramework.Database.Query /* Time Taken: 669*/ [dbo].GenerateSystemAlerts 2026-01-12 10:08:52.9096 DFramework.Scheduler.TaskBase /* Time Taken: 15515.7369*/ Opportunity Out Of Stock By Outlet 2026-01-12 10:23:38.2911 DFramework.Database.Query /* Time Taken: 531*/ [dbo].GenerateSystemAlerts 2026-01-12 10:23:52.9319 DFramework.Scheduler.TaskBase /* Time Taken: 15515.7394*/ Opportunity Out Of Stock By Outlet 2026-01-12 10:38:38.3292 DFramework.Database.Query /* Time Taken: 557*/ [dbo].GenerateSystemAlerts 2026-01-12 10:38:53.0168 DFramework.Scheduler.TaskBase /* Time Taken: 15578.2423*/ Opportunity Out Of Stock By Outlet 2026-01-12 10:53:38.3829 DFramework.Database.Query /* Time Taken: 596*/ [dbo].GenerateSystemAlerts 2026-01-12 10:53:52.9767 DFramework.Scheduler.TaskBase /* Time Taken: 15515.7443*/ Opportunity Out Of Stock By Outlet 2026-01-12 11:08:38.3272 DFramework.Database.Query /* Time Taken: 526*/ [dbo].GenerateSystemAlerts 2026-01-12 11:08:53.0149 DFramework.Scheduler.TaskBase /* Time Taken: 15515.745*/ Opportunity Out Of Stock By Outlet 2026-01-12 11:23:38.4278 DFramework.Database.Query /* Time Taken: 600*/ [dbo].GenerateSystemAlerts 2026-01-12 11:23:53.0373 DFramework.Scheduler.TaskBase /* Time Taken: 15531.3756*/ Opportunity Out Of Stock By Outlet 2026-01-12 11:38:38.4033 DFramework.Database.Query /* Time Taken: 548*/ [dbo].GenerateSystemAlerts 2026-01-12 11:38:53.0752 DFramework.Scheduler.TaskBase /* Time Taken: 15531.3666*/ Opportunity Out Of Stock By Outlet 2026-01-12 11:53:38.3944 DFramework.Database.Query /* Time Taken: 519*/ [dbo].GenerateSystemAlerts 2026-01-12 11:53:53.0820 DFramework.Scheduler.TaskBase /* Time Taken: 15515.7413*/ Opportunity Out Of Stock By Outlet 2026-01-12 12:08:38.4480 DFramework.Database.Query /* Time Taken: 566*/ [dbo].GenerateSystemAlerts 2026-01-12 12:08:53.1356 DFramework.Scheduler.TaskBase /* Time Taken: 15546.9913*/ Opportunity Out Of Stock By Outlet 2026-01-12 12:23:38.4238 DFramework.Database.Query /* Time Taken: 524*/ [dbo].GenerateSystemAlerts 2026-01-12 12:23:53.1426 DFramework.Scheduler.TaskBase /* Time Taken: 15531.3677*/ Opportunity Out Of Stock By Outlet 2026-01-12 12:38:38.5868 DFramework.Database.Query /* Time Taken: 681*/ [dbo].GenerateSystemAlerts 2026-01-12 12:38:53.1495 DFramework.Scheduler.TaskBase /* Time Taken: 15515.7527*/ Opportunity Out Of Stock By Outlet 2026-01-12 12:53:38.4531 DFramework.Database.Query /* Time Taken: 520*/ [dbo].GenerateSystemAlerts 2026-01-12 12:53:53.1563 DFramework.Scheduler.TaskBase /* Time Taken: 15500.1287*/ Opportunity Out Of Stock By Outlet 2026-01-12 13:08:38.6162 DFramework.Database.Query /* Time Taken: 660*/ [dbo].GenerateSystemAlerts 2026-01-12 13:08:53.1632 DFramework.Scheduler.TaskBase /* Time Taken: 15500.121*/ Opportunity Out Of Stock By Outlet 2026-01-12 13:23:38.4823 DFramework.Database.Query /* Time Taken: 505*/ [dbo].GenerateSystemAlerts 2026-01-12 13:23:53.1699 DFramework.Scheduler.TaskBase /* Time Taken: 15500.1099*/ Opportunity Out Of Stock By Outlet 2026-01-12 13:38:38.5672 DFramework.Database.Query /* Time Taken: 575*/ [dbo].GenerateSystemAlerts 2026-01-12 13:38:53.1923 DFramework.Scheduler.TaskBase /* Time Taken: 15500.1036*/ Opportunity Out Of Stock By Outlet 2026-01-12 13:53:38.5582 DFramework.Database.Query /* Time Taken: 532*/ [dbo].GenerateSystemAlerts 2026-01-12 13:53:53.3239 DFramework.Scheduler.TaskBase /* Time Taken: 15593.8871*/ Opportunity Out Of Stock By Outlet 2026-01-12 14:08:38.5645 DFramework.Database.Query /* Time Taken: 518*/ [dbo].GenerateSystemAlerts 2026-01-12 14:08:53.2365 DFramework.Scheduler.TaskBase /* Time Taken: 15500.1046*/ Opportunity Out Of Stock By Outlet 2026-01-12 14:23:38.5708 DFramework.Database.Query /* Time Taken: 511*/ [dbo].GenerateSystemAlerts 2026-01-12 14:23:53.2584 DFramework.Scheduler.TaskBase /* Time Taken: 15500.1174*/ Opportunity Out Of Stock By Outlet 2026-01-12 14:38:38.6239 DFramework.Database.Query /* Time Taken: 532*/ [dbo].GenerateSystemAlerts 2026-01-12 14:38:53.2959 DFramework.Scheduler.TaskBase /* Time Taken: 15515.7361*/ Opportunity Out Of Stock By Outlet 2026-01-12 14:53:38.6460 DFramework.Database.Query /* Time Taken: 532*/ [dbo].GenerateSystemAlerts 2026-01-12 14:53:53.3180 DFramework.Scheduler.TaskBase /* Time Taken: 15515.7352*/ Opportunity Out Of Stock By Outlet 2026-01-12 15:08:38.6523 DFramework.Database.Query /* Time Taken: 517*/ [dbo].GenerateSystemAlerts 2026-01-12 15:08:53.3243 DFramework.Scheduler.TaskBase /* Time Taken: 15500.1076*/ Opportunity Out Of Stock By Outlet 2026-01-12 15:23:38.6743 DFramework.Database.Query /* Time Taken: 526*/ [dbo].GenerateSystemAlerts 2026-01-12 15:23:53.3619 DFramework.Scheduler.TaskBase /* Time Taken: 15515.7325*/ Opportunity Out Of Stock By Outlet 2026-01-12 15:38:38.8059 DFramework.Database.Query /* Time Taken: 630*/ [dbo].GenerateSystemAlerts 2026-01-12 15:38:53.4466 DFramework.Scheduler.TaskBase /* Time Taken: 15578.2358*/ Opportunity Out Of Stock By Outlet 2026-01-12 15:41:06.4007 DFramework.Database.NullableDataReader Data reader open for 36138537 at System.Environment.GetStackTrace(Exception e, Boolean needFileInfo) at System.Environment.get_StackTrace() at DFramework.Database.NullableDataReader.Dispose(Boolean disposing) in C:\CoolR-Group\Framework\DFramework\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 343 at DFramework.Scheduler.TaskBase.Run() in D:\Spraxa\Framework\DFramework.Scheduler\TaskBase.cs:line 176 at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx) at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx) at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state) at System.Threading.ThreadHelper.ThreadStart() 2026-01-12 15:41:06.4007 DFramework.Database.NullableDataReader Data reader open for 36138629 at System.Environment.GetStackTrace(Exception e, Boolean needFileInfo) at System.Environment.get_StackTrace() at DFramework.Database.NullableDataReader.Dispose(Boolean disposing) in C:\CoolR-Group\Framework\DFramework\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 343 at DFramework.Scheduler.TaskBase.Run() in D:\Spraxa\Framework\DFramework.Scheduler\TaskBase.cs:line 176 at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx) at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx) at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state) at System.Threading.ThreadHelper.ThreadStart() 2026-01-12 15:41:06.6820 DFramework.Scheduler.TaskBase /* Time Taken: 36149581.6572*/ Process Alert Record 2026-01-12 15:41:19.2133 AlertProcessor ProcessorAlertData: started 2026-01-12 15:41:19.9946 DFramework.Database.Query /* Time Taken: 743*/ 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-12 15:41:20.0102 DFramework.Database.Query /* Time Taken: 769*/ DECLARE @TableName AnsiString(8000) SET @TableName = 'TagAlert' DECLARE @CurrentRecordId Int32 SET @CurrentRecordId = '0' dbo.GetValidDeviceForAlertProcessData 2026-01-12 15:41:20.0571 DFramework.Database.Query /* Time Taken: 799*/ DECLARE @OrderStatusId Int32 SET @OrderStatusId = '5486' DECLARE @CurrentUtcDateTime DateTime2 SET @CurrentUtcDateTime = '1/12/2026 11:41:19 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-12 15:41:20.0883 DFramework.Database.Query /* Time Taken: 828*/ 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-12 15:41:20.1352 DFramework.Database.Query /* Time Taken: 867*/ 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/12/2026 11:41:19 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-12 15:41:20.1352 DFramework.Database.Query /* Time Taken: 881*/ 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-12 15:41:20.1664 DFramework.Database.Query /* Time Taken: 897*/ 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-12 15:41:20.1664 DFramework.Database.Query /* Time Taken: 897*/ 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-12 15:41:20.1977 DFramework.Database.Query /* Time Taken: 927*/ 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-12 15:41:20.1977 DFramework.Database.Query /* Time Taken: 927*/ 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-12 15:41:20.2133 DFramework.Database.Query /* Time Taken: 954*/ 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-12 15:41:20.2289 DFramework.Database.Query /* Time Taken: 957*/ DECLARE @CreatedOn Date SET @CreatedOn = '1/12/2026 12:00:00 AM' DECLARE @EventId Int32 SET @EventId = '-12' SELECT COUNT(1) FROM EmailQueue WHERE [CreatedOn] >= @CreatedOn AND [EventId] = @EventId 2026-01-12 15:41:20.2446 DFramework.Database.Query /* Time Taken: 795*/ DECLARE @AlertDefinitionId Int32 SET @AlertDefinitionId = '99' DECLARE @IsDeleted Boolean SET @IsDeleted = 'False' SELECT ProductId FROM AlertDefinitionProduct WHERE [AlertDefinitionId] = @AlertDefinitionId AND IsDeleted = @IsDeleted 2026-01-12 15:41:20.7758 DFramework.Database.NullableDataReader Data reader open for 474 at System.Environment.GetStackTrace(Exception e, Boolean needFileInfo) at System.Environment.get_StackTrace() at DFramework.Database.NullableDataReader.Dispose(Boolean disposing) in C:\CoolR-Group\Framework\DFramework\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 D:\Spraxa\Framework\DFramework.Scheduler\TaskBase.cs:line 176 at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx) at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx) at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state) at System.Threading.ThreadHelper.ThreadStart() 2026-01-12 15:41:20.9008 DFramework.Database.NullableDataReader Data reader open for 1468 at System.Environment.GetStackTrace(Exception e, Boolean needFileInfo) at System.Environment.get_StackTrace() at DFramework.Database.NullableDataReader.Dispose(Boolean disposing) in C:\CoolR-Group\Framework\DFramework\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 D:\Spraxa\Framework\DFramework.Scheduler\TaskBase.cs:line 176 at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx) at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx) at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state) at System.Threading.ThreadHelper.ThreadStart() 2026-01-12 15:41:20.9164 DFramework.Database.Query /* Time Taken: 1648*/ [dbo].GenerateSystemAlerts 2026-01-12 15:41:21.1821 DFramework.Database.NullableDataReader Data reader open for 319 at System.Environment.GetStackTrace(Exception e, Boolean needFileInfo) at System.Environment.get_StackTrace() at DFramework.Database.NullableDataReader.Dispose(Boolean disposing) in C:\CoolR-Group\Framework\DFramework\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:\Program Files (x86)\Go Agent\pipelines\coolr-portal-dev-task-service-new\CoolR.Tasks\ProcessAlertData.cs:line 2431 at CoolR.Tasks.ProcessAlertData.Execute() in C:\Program Files (x86)\Go Agent\pipelines\coolr-portal-dev-task-service-new\CoolR.Tasks\ProcessAlertData.cs:line 367 at DFramework.Scheduler.TaskBase.Run() in D:\Spraxa\Framework\DFramework.Scheduler\TaskBase.cs:line 176 at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx) at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx) at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state) at System.Threading.ThreadHelper.ThreadStart() 2026-01-12 15:41:21.2133 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 D:\Spraxa\Framework\DFramework.Scheduler\TaskBase.cs:line 176 at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx) at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx) at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state) at System.Threading.ThreadHelper.ThreadStart() 2026-01-12 15:41:21.2602 DFramework.Database.NullableDataReader Data reader open for 1258 at System.Environment.GetStackTrace(Exception e, Boolean needFileInfo) at System.Environment.get_StackTrace() at DFramework.Database.NullableDataReader.Dispose(Boolean disposing) in C:\CoolR-Group\Framework\DFramework\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 D:\Spraxa\Framework\DFramework.Scheduler\TaskBase.cs:line 176 at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx) at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx) at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state) at System.Threading.ThreadHelper.ThreadStart() 2026-01-12 15:41:21.9946 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:\Program Files (x86)\Go Agent\pipelines\coolr-portal-dev-task-service-new\CoolR.Tasks\ProcessAlertData.cs:line 48 at DFramework.Scheduler.TaskBase.Run() in D:\Spraxa\Framework\DFramework.Scheduler\TaskBase.cs:line 176 at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx) at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx) at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state) at System.Threading.ThreadHelper.ThreadStart() 2026-01-12 15:41:22.2602 DFramework.Database.NullableDataReader Data reader open for 681 at System.Environment.GetStackTrace(Exception e, Boolean needFileInfo) at System.Environment.get_StackTrace() at DFramework.Database.NullableDataReader.Dispose(Boolean disposing) in C:\CoolR-Group\Framework\DFramework\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 D:\Spraxa\Framework\DFramework.Scheduler\TaskBase.cs:line 176 at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx) at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx) at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state) at System.Threading.ThreadHelper.ThreadStart() 2026-01-12 15:41:22.9008 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:\Program Files (x86)\Go Agent\pipelines\coolr-portal-dev-task-service-new\CoolR.Tasks\ProcessAlertData.cs:line 48 at DFramework.Scheduler.TaskBase.Run() in D:\Spraxa\Framework\DFramework.Scheduler\TaskBase.cs:line 176 at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx) at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx) at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state) at System.Threading.ThreadHelper.ThreadStart() 2026-01-12 15:41:23.5571 DFramework.Database.NullableDataReader Data reader open for 250 at System.Environment.GetStackTrace(Exception e, Boolean needFileInfo) at System.Environment.get_StackTrace() at DFramework.Database.NullableDataReader.Dispose(Boolean disposing) in C:\CoolR-Group\Framework\DFramework\Database\NullableDataReader.cs:line 33 at DFramework.Database.NullableDataReader.Dispose() in C:\CoolR-Group\Framework\DFramework\Database\NullableDataReader.cs:line 44 at CoolR.Tasks.ProcessAlertData.Execute() in C:\Program Files (x86)\Go Agent\pipelines\coolr-portal-dev-task-service-new\CoolR.Tasks\ProcessAlertData.cs:line 48 at DFramework.Scheduler.TaskBase.Run() in D:\Spraxa\Framework\DFramework.Scheduler\TaskBase.cs:line 176 at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx) at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx) at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state) at System.Threading.ThreadHelper.ThreadStart() 2026-01-12 15:41:24.1821 DFramework.Database.NullableDataReader Data reader open for 230 at System.Environment.GetStackTrace(Exception e, Boolean needFileInfo) at System.Environment.get_StackTrace() at DFramework.Database.NullableDataReader.Dispose(Boolean disposing) in C:\CoolR-Group\Framework\DFramework\Database\NullableDataReader.cs:line 33 at DFramework.Database.NullableDataReader.Dispose() in C:\CoolR-Group\Framework\DFramework\Database\NullableDataReader.cs:line 44 at CoolR.Tasks.ProcessAlertData.Execute() in 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 D:\Spraxa\Framework\DFramework.Scheduler\TaskBase.cs:line 176 at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx) at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx) at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state) at System.Threading.ThreadHelper.ThreadStart() 2026-01-12 15:41:24.4165 DFramework.Database.NullableDataReader Data reader open for 212 at System.Environment.GetStackTrace(Exception e, Boolean needFileInfo) at System.Environment.get_StackTrace() at DFramework.Database.NullableDataReader.Dispose(Boolean disposing) in C:\CoolR-Group\Framework\DFramework\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 D:\Spraxa\Framework\DFramework.Scheduler\TaskBase.cs:line 176 at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx) at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx) at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state) at System.Threading.ThreadHelper.ThreadStart() 2026-01-12 15:41:24.6508 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:\Program Files (x86)\Go Agent\pipelines\coolr-portal-dev-task-service-new\CoolR.Tasks\ProcessAlertData.cs:line 48 at DFramework.Scheduler.TaskBase.Run() in D:\Spraxa\Framework\DFramework.Scheduler\TaskBase.cs:line 176 at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx) at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx) at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state) at System.Threading.ThreadHelper.ThreadStart() 2026-01-12 15:41:25.1040 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 D:\Spraxa\Framework\DFramework.Scheduler\TaskBase.cs:line 176 at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx) at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx) at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state) at System.Threading.ThreadHelper.ThreadStart() 2026-01-12 15:41:25.1977 DFramework.Database.NullableDataReader Data reader open for 1282 at System.Environment.GetStackTrace(Exception e, Boolean needFileInfo) at System.Environment.get_StackTrace() at DFramework.Database.NullableDataReader.Dispose(Boolean disposing) in C:\CoolR-Group\Framework\DFramework\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 D:\Spraxa\Framework\DFramework.Scheduler\TaskBase.cs:line 176 at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx) at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx) at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state) at System.Threading.ThreadHelper.ThreadStart() 2026-01-12 15:41:26.3540 DFramework.Database.NullableDataReader Data reader open for 271 at System.Environment.GetStackTrace(Exception e, Boolean needFileInfo) at System.Environment.get_StackTrace() at DFramework.Database.NullableDataReader.Dispose(Boolean disposing) in C:\CoolR-Group\Framework\DFramework\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 D:\Spraxa\Framework\DFramework.Scheduler\TaskBase.cs:line 176 at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx) at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx) at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state) at System.Threading.ThreadHelper.ThreadStart() 2026-01-12 15:41:26.4477 DFramework.Database.NullableDataReader Data reader open for 889 at System.Environment.GetStackTrace(Exception e, Boolean needFileInfo) at System.Environment.get_StackTrace() at DFramework.Database.NullableDataReader.Dispose(Boolean disposing) in C:\CoolR-Group\Framework\DFramework\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 D:\Spraxa\Framework\DFramework.Scheduler\TaskBase.cs:line 176 at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx) at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx) at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state) at System.Threading.ThreadHelper.ThreadStart() 2026-01-12 15:41:27.4321 DFramework.Database.NullableDataReader Data reader open for 303 at System.Environment.GetStackTrace(Exception e, Boolean needFileInfo) at System.Environment.get_StackTrace() at DFramework.Database.NullableDataReader.Dispose(Boolean disposing) in C:\CoolR-Group\Framework\DFramework\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 D:\Spraxa\Framework\DFramework.Scheduler\TaskBase.cs:line 176 at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx) at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx) at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state) at System.Threading.ThreadHelper.ThreadStart() 2026-01-12 15:41:27.5102 DFramework.Database.NullableDataReader Data reader open for 706 at System.Environment.GetStackTrace(Exception e, Boolean needFileInfo) at System.Environment.get_StackTrace() at DFramework.Database.NullableDataReader.Dispose(Boolean disposing) in C:\CoolR-Group\Framework\DFramework\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 D:\Spraxa\Framework\DFramework.Scheduler\TaskBase.cs:line 176 at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx) at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx) at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state) at System.Threading.ThreadHelper.ThreadStart() 2026-01-12 15:41:28.1665 DFramework.Database.Query /* Time Taken: 658*/ DECLARE @TableName AnsiString(8000) SET @TableName = 'AssetStockProductWiseConsolidate' DECLARE @CurrentRecordId Int32 SET @CurrentRecordId = '3675979' dbo.GetValidDeviceForAlertProcessData 2026-01-12 15:41:36.4009 DFramework.Scheduler.TaskBase /* Time Taken: 17515.7571*/ Opportunity Out Of Stock By Outlet 2026-01-12 15:56:19.7822 DFramework.Database.Query /* Time Taken: 509*/ [dbo].GenerateSystemAlerts 2026-01-12 15:56:34.4072 DFramework.Scheduler.TaskBase /* Time Taken: 15500.0907*/ Opportunity Out Of Stock By Outlet 2026-01-12 16:11:19.8510 DFramework.Database.Query /* Time Taken: 575*/ [dbo].GenerateSystemAlerts 2026-01-12 16:11:34.4292 DFramework.Scheduler.TaskBase /* Time Taken: 15500.0996*/ Opportunity Out Of Stock By Outlet 2026-01-12 16:26:19.8106 DFramework.Database.Query /* Time Taken: 525*/ [dbo].GenerateSystemAlerts 2026-01-12 16:26:34.4514 DFramework.Scheduler.TaskBase /* Time Taken: 15500.117*/ Opportunity Out Of Stock By Outlet 2026-01-12 16:41:19.8748 DFramework.Database.Query /* Time Taken: 587*/ [dbo].GenerateSystemAlerts 2026-01-12 16:41:34.4843 DFramework.Scheduler.TaskBase /* Time Taken: 15515.7212*/ Opportunity Out Of Stock By Outlet 2026-01-12 16:56:19.8542 DFramework.Database.Query /* Time Taken: 535*/ [dbo].GenerateSystemAlerts 2026-01-12 16:56:34.5106 DFramework.Scheduler.TaskBase /* Time Taken: 15515.7338*/ Opportunity Out Of Stock By Outlet 2026-01-12 17:11:19.8924 DFramework.Database.Query /* Time Taken: 557*/ [dbo].GenerateSystemAlerts 2026-01-12 17:11:34.6425 DFramework.Scheduler.TaskBase /* Time Taken: 15625.117*/ Opportunity Out Of Stock By Outlet 2026-01-12 17:26:19.9144 DFramework.Database.Query /* Time Taken: 557*/ [dbo].GenerateSystemAlerts 2026-01-12 17:26:34.5395 DFramework.Scheduler.TaskBase /* Time Taken: 15500.1217*/ Opportunity Out Of Stock By Outlet 2026-01-12 17:41:19.9818 DFramework.Database.Query /* Time Taken: 600*/ [dbo].GenerateSystemAlerts 2026-01-12 17:41:34.6850 DFramework.Scheduler.TaskBase /* Time Taken: 15625.0717*/ Opportunity Out Of Stock By Outlet 2026-01-12 17:56:19.9263 DFramework.Database.Query /* Time Taken: 521*/ [dbo].GenerateSystemAlerts 2026-01-12 17:56:34.5983 DFramework.Scheduler.TaskBase /* Time Taken: 15515.7798*/ Opportunity Out Of Stock By Outlet 2026-01-12 18:11:20.0274 DFramework.Database.Query /* Time Taken: 607*/ [dbo].GenerateSystemAlerts 2026-01-12 18:11:34.9025 DFramework.Scheduler.TaskBase /* Time Taken: 15796.9767*/ Opportunity Out Of Stock By Outlet 2026-01-12 18:26:19.9870 DFramework.Database.Query /* Time Taken: 540*/ [dbo].GenerateSystemAlerts 2026-01-12 18:26:34.6277 DFramework.Scheduler.TaskBase /* Time Taken: 15500.1256*/ Opportunity Out Of Stock By Outlet 2026-01-12 18:31:19.8638 MoveToReorder Running task for ClientId : 286 and ClientName = India Office QA and Slot: 1/13/2026 8:00:00 AM And LastExecutedOn: 1/12/2026 10:08:38 PM 2026-01-12 18:31:57.0359 DFramework.Database.NullableDataReader Data reader open for 36874 at System.Environment.GetStackTrace(Exception e, Boolean needFileInfo) at System.Environment.get_StackTrace() at DFramework.Database.NullableDataReader.Dispose(Boolean disposing) in C:\CoolR-Group\Framework\DFramework\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:\Program Files (x86)\Go Agent\pipelines\coolr-portal-dev-task-service-new\CoolR.Tasks\MoveToReorder.cs:line 50 at DFramework.Scheduler.TaskBase.Run() in D:\Spraxa\Framework\DFramework.Scheduler\TaskBase.cs:line 176 at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx) at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx) at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state) at System.Threading.ThreadHelper.ThreadStart() 2026-01-12 18:31:57.0672 MoveToReorder Task executed successfully for ClientId : 286 Client Name:India Office QA, Slot: 1/13/2026 8:00:00 AM and Total Order Suggested: 124 Out Of: 124 2026-01-12 18:31:57.4734 DFramework.Scheduler.TaskBase /* Time Taken: 38000.2433*/ Move To Re-Order 2026-01-12 18:41:20.2431 DFramework.Database.Query /* Time Taken: 777*/ [dbo].GenerateSystemAlerts 2026-01-12 18:41:34.9932 DFramework.Scheduler.TaskBase /* Time Taken: 15843.8561*/ Opportunity Out Of Stock By Outlet 2026-01-12 18:56:20.0147 DFramework.Database.Query /* Time Taken: 543*/ [dbo].GenerateSystemAlerts 2026-01-12 18:56:34.6710 DFramework.Scheduler.TaskBase /* Time Taken: 15515.7423*/ Opportunity Out Of Stock By Outlet 2026-01-12 19:11:20.2084 DFramework.Database.Query /* Time Taken: 703*/ [dbo].GenerateSystemAlerts 2026-01-12 19:11:34.6616 DFramework.Scheduler.TaskBase /* Time Taken: 15500.1159*/ Opportunity Out Of Stock By Outlet 2026-01-12 19:26:20.0422 DFramework.Database.Query /* Time Taken: 522*/ [dbo].GenerateSystemAlerts 2026-01-12 19:26:34.6673 DFramework.Scheduler.TaskBase /* Time Taken: 15500.1035*/ Opportunity Out Of Stock By Outlet 2026-01-12 19:31:19.9349 MoveToReorder Running task for ClientId : 286 and ClientName = India Office QA and Slot: 1/13/2026 9:00:00 AM And LastExecutedOn: 1/13/2026 8:01:19 AM 2026-01-12 19:31:20.1849 MoveToReorder Task executed successfully for ClientId : 286 Client Name:India Office QA, Slot: 1/13/2026 9:00:00 AM But No Order found to suggest 2026-01-12 19:41:20.0484 DFramework.Database.Query /* Time Taken: 515*/ [dbo].GenerateSystemAlerts 2026-01-12 19:41:34.6891 DFramework.Scheduler.TaskBase /* Time Taken: 15500.1189*/ Opportunity Out Of Stock By Outlet 2026-01-12 19:56:20.0857 DFramework.Database.Query /* Time Taken: 523*/ [dbo].GenerateSystemAlerts 2026-01-12 19:56:34.7108 DFramework.Scheduler.TaskBase /* Time Taken: 15500.1087*/ Opportunity Out Of Stock By Outlet 2026-01-12 20:11:20.2950 DFramework.Database.Query /* Time Taken: 707*/ [dbo].GenerateSystemAlerts 2026-01-12 20:11:34.7483 DFramework.Scheduler.TaskBase /* Time Taken: 15515.7238*/ Opportunity Out Of Stock By Outlet 2026-01-12 20:26:20.1296 DFramework.Database.Query /* Time Taken: 526*/ [dbo].GenerateSystemAlerts 2026-01-12 20:26:34.7391 DFramework.Scheduler.TaskBase /* Time Taken: 15500.1146*/ Opportunity Out Of Stock By Outlet 2026-01-12 20:31:20.0066 MoveToReorder Running task for ClientId : 286 and ClientName = India Office QA and Slot: 1/13/2026 10:00:00 AM And LastExecutedOn: 1/13/2026 9:01:19 AM 2026-01-12 20:31:20.5379 DFramework.Database.NullableDataReader Data reader open for 275 at System.Environment.GetStackTrace(Exception e, Boolean needFileInfo) at System.Environment.get_StackTrace() at DFramework.Database.NullableDataReader.Dispose(Boolean disposing) in C:\CoolR-Group\Framework\DFramework\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:\Program Files (x86)\Go Agent\pipelines\coolr-portal-dev-task-service-new\CoolR.Tasks\MoveToReorder.cs:line 50 at DFramework.Scheduler.TaskBase.Run() in D:\Spraxa\Framework\DFramework.Scheduler\TaskBase.cs:line 176 at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx) at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx) at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state) at System.Threading.ThreadHelper.ThreadStart() 2026-01-12 20:31:20.5535 MoveToReorder Task executed successfully for ClientId : 286 Client Name:India Office QA, Slot: 1/13/2026 10:00:00 AM and Total Order Suggested: 1 Out Of: 1 2026-01-12 20:41:20.1673 DFramework.Database.Query /* Time Taken: 543*/ [dbo].GenerateSystemAlerts 2026-01-12 20:41:34.7767 DFramework.Scheduler.TaskBase /* Time Taken: 15515.7339*/ Opportunity Out Of Stock By Outlet 2026-01-12 20:56:20.1581 DFramework.Database.Query /* Time Taken: 506*/ [dbo].GenerateSystemAlerts 2026-01-12 20:56:34.7989 DFramework.Scheduler.TaskBase /* Time Taken: 15515.7294*/ Opportunity Out Of Stock By Outlet 2026-01-12 21:11:20.2426 DFramework.Database.Query /* Time Taken: 564*/ [dbo].GenerateSystemAlerts 2026-01-12 21:11:34.8052 DFramework.Scheduler.TaskBase /* Time Taken: 15515.7359*/ Opportunity Out Of Stock By Outlet 2026-01-12 21:26:20.2491 DFramework.Database.Query /* Time Taken: 556*/ [dbo].GenerateSystemAlerts 2026-01-12 21:26:34.7960 DFramework.Scheduler.TaskBase /* Time Taken: 15500.1113*/ Opportunity Out Of Stock By Outlet 2026-01-12 21:31:20.0950 MoveToReorder Running task for ClientId : 286 and ClientName = India Office QA and Slot: 1/13/2026 11:00:00 AM And LastExecutedOn: 1/13/2026 10:01:19 AM 2026-01-12 21:31:57.7671 DFramework.Database.NullableDataReader Data reader open for 37385 at System.Environment.GetStackTrace(Exception e, Boolean needFileInfo) at System.Environment.get_StackTrace() at DFramework.Database.NullableDataReader.Dispose(Boolean disposing) in C:\CoolR-Group\Framework\DFramework\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:\Program Files (x86)\Go Agent\pipelines\coolr-portal-dev-task-service-new\CoolR.Tasks\MoveToReorder.cs:line 50 at DFramework.Scheduler.TaskBase.Run() in D:\Spraxa\Framework\DFramework.Scheduler\TaskBase.cs:line 176 at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx) at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx) at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state) at System.Threading.ThreadHelper.ThreadStart() 2026-01-12 21:31:57.7984 MoveToReorder Task executed successfully for ClientId : 286 Client Name:India Office QA, Slot: 1/13/2026 11:00:00 AM and Total Order Suggested: 124 Out Of: 124 2026-01-12 21:31:58.1734 DFramework.Scheduler.TaskBase /* Time Taken: 38453.4043*/ Move To Re-Order 2026-01-12 21:40:59.6930 DFramework.Database.Query /* Time Taken: 1223*/ DECLARE @AssetPurityId Int32 SET @AssetPurityId = '3675808' DECLARE @AssetId Int32 SET @AssetId = '118415' DECLARE @StatusId Int32 SET @StatusId = '2' DECLARE @PurityDateTime Date SET @PurityDateTime = '1/8/2026 6:14:11 PM' SELECT TOP 1 PurityDateTime, AssetPurityId, PlanogramId, Shelves, PurityStatus, AssetId, ImageReceivedFrom FROM AssetPurity WHERE [AssetPurityId] <= @AssetPurityId AND [AssetId] = @AssetId AND [StatusId] = @StatusId AND [PurityDateTime] > @PurityDateTime ORDER BY [PurityDateTime] DESC 2026-01-12 21:41:20.2400 DFramework.Database.Query /* Time Taken: 524*/ DECLARE @OrderStatusId Int32 SET @OrderStatusId = '5486' DECLARE @CurrentUtcDateTime DateTime2 SET @CurrentUtcDateTime = '1/13/2026 5:41:19 AM' UPDATE Location SET ScheduledOrderId = 0, OrderStatusId = 0 FROM dbo.ScheduledOrder INNER JOIN dbo.Location ON Location.ScheduledOrderId = ScheduledOrder.ScheduledOrderId AND Location.OrderStatusId = @OrderStatusId INNER JOIN dbo.Client On Client.ClientId = Location.ClientId WHERE ScheduledOrder.ModifiedOn < DATEADD(HOUR, -Client.HoursToMoveIgnored, @CurrentUtcDateTime) AND ScheduledOrder.StatusId = @OrderStatusId AND Client.HoursToMoveIgnored > 0 2026-01-12 21:41:20.3494 DFramework.Database.Query /* Time Taken: 630*/ [dbo].GenerateSystemAlerts 2026-01-12 21:41:35.3026 DFramework.Scheduler.TaskBase /* Time Taken: 16000.1156*/ Opportunity Out Of Stock By Outlet 2026-01-12 21:54:15.9332 DFramework.Database.NullableDataReader Data reader open for 22367057 at System.Environment.GetStackTrace(Exception e, Boolean needFileInfo) at System.Environment.get_StackTrace() at DFramework.Database.NullableDataReader.Dispose(Boolean disposing) in C:\CoolR-Group\Framework\DFramework\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 343 at DFramework.Scheduler.TaskBase.Run() in D:\Spraxa\Framework\DFramework.Scheduler\TaskBase.cs:line 176 at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx) at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx) at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state) at System.Threading.ThreadHelper.ThreadStart() 2026-01-12 21:54:15.9332 DFramework.Database.NullableDataReader Data reader open for 22367142 at System.Environment.GetStackTrace(Exception e, Boolean needFileInfo) at System.Environment.get_StackTrace() at DFramework.Database.NullableDataReader.Dispose(Boolean disposing) in C:\CoolR-Group\Framework\DFramework\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 343 at DFramework.Scheduler.TaskBase.Run() in D:\Spraxa\Framework\DFramework.Scheduler\TaskBase.cs:line 176 at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx) at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx) at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state) at System.Threading.ThreadHelper.ThreadStart() 2026-01-12 21:54:16.1832 DFramework.Scheduler.TaskBase /* Time Taken: 22377298.0425*/ Process Alert Record 2026-01-12 21:54:28.2770 AlertProcessor ProcessorAlertData: started 2026-01-12 21:54:28.8396 DFramework.Database.Query /* Time Taken: 509*/ 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-12 21:54:28.8708 DFramework.Database.Query /* Time Taken: 544*/ 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-12 21:54:29.2146 DFramework.Database.Query /* Time Taken: 881*/ 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/13/2026 5:54:28 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-12 21:54:29.2614 DFramework.Database.Query /* Time Taken: 909*/ 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-12 21:54:29.3083 DFramework.Database.Query /* Time Taken: 966*/ 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-12 21:54:29.3396 DFramework.Database.Query /* Time Taken: 1000*/ 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-12 21:54:29.3708 DFramework.Database.Query /* Time Taken: 1032*/ 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-12 21:54:29.4489 DFramework.Database.Query /* Time Taken: 1104*/ 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-12 21:54:29.4802 DFramework.Database.Query /* Time Taken: 1146*/ DECLARE @CreatedOn Date SET @CreatedOn = '1/13/2026 12:00:00 AM' DECLARE @EventId Int32 SET @EventId = '-12' SELECT COUNT(1) FROM EmailQueue WHERE [CreatedOn] >= @CreatedOn AND [EventId] = @EventId 2026-01-12 21:54:29.4802 DFramework.Database.Query /* Time Taken: 1017*/ DECLARE @AlertDefinitionId Int32 SET @AlertDefinitionId = '99' DECLARE @IsDeleted Boolean SET @IsDeleted = 'False' SELECT ProductId FROM AlertDefinitionProduct WHERE [AlertDefinitionId] = @AlertDefinitionId AND IsDeleted = @IsDeleted 2026-01-12 21:54:29.5114 DFramework.Database.Query /* Time Taken: 1200*/ DECLARE @TableName AnsiString(8000) SET @TableName = 'TagAlert' DECLARE @CurrentRecordId Int32 SET @CurrentRecordId = '0' dbo.GetValidDeviceForAlertProcessData 2026-01-12 21:54:29.5583 DFramework.Database.Query /* Time Taken: 703*/ DECLARE @AssetKPIData Object SET @AssetKPIData = '' [dbo].BulkUpsertAssetDayKPI 2026-01-12 21:54:29.5739 DFramework.Database.Query /* Time Taken: 767*/ DECLARE @OrderStatusId Int32 SET @OrderStatusId = '5484' DECLARE @CurrentUtcDateTime DateTime2 SET @CurrentUtcDateTime = '1/13/2026 5:54:28 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-12 21:54:29.5896 DFramework.Database.Query /* Time Taken: 581*/ DECLARE @AppConfigId Int32 SET @AppConfigId = '1' SELECT * FROM AppConfig WHERE [AppConfigId] = @AppConfigId ORDER BY [AppConfigId] 2026-01-12 21:54:29.6989 DFramework.Database.Query /* Time Taken: 1367*/ [dbo].GenerateSystemAlerts 2026-01-12 21:54:29.7614 DFramework.Database.Query /* Time Taken: 1002*/ DECLARE @TemplateId Int32 SET @TemplateId = '71' DECLARE @EventId Int32 SET @EventId = '32' DECLARE @IsHtml Boolean SET @IsHtml = 'False' DECLARE @Subject AnsiString(8000) SET @Subject = '' DECLARE @Body AnsiString(8000) SET @Body = '' DECLARE @FromName AnsiString(8000) SET @FromName = '' DECLARE @FromEmailAddress AnsiString(8000) SET @FromEmailAddress = '' DECLARE @AddlTo AnsiString(8000) SET @AddlTo = '' DECLARE @AddlCc AnsiString(8000) SET @AddlCc = '' DECLARE @AddlBcc AnsiString(8000) SET @AddlBcc = '' DECLARE @Tags String(4000) SET @Tags = '{"EventTime":"01/13/2026 05:18:11","Asset":"Test KPI","ImageId":"3676016","Location":"SH test outlet 2","AlertType":"New Stitched Image Alert","imageName":"7wgvvzarlrwwh.jpg","UniqueGuid":"r5vixfnrbiq46","AlertId":"13785679"}' DECLARE @StatusId Byte SET @StatusId = '0' INSERT INTO EmailQueue (TemplateId,EventId,IsHtml,Subject,Body,FromName,FromEmailAddress,AddlTo,AddlCc,AddlBcc,Tags,StatusId) VALUES (@TemplateId,@EventId,@IsHtml,@Subject,@Body,@FromName,@FromEmailAddress,@AddlTo,@AddlCc,@AddlBcc,@Tags,@StatusId) ; SELECT NewId = SCOPE_IDENTITY() 2026-01-12 21:54:29.7927 DFramework.Database.NullableDataReader Data reader open for 1312 at System.Environment.GetStackTrace(Exception e, Boolean needFileInfo) at System.Environment.get_StackTrace() at DFramework.Database.NullableDataReader.Dispose(Boolean disposing) in C:\CoolR-Group\Framework\DFramework\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 D:\Spraxa\Framework\DFramework.Scheduler\TaskBase.cs:line 176 at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx) at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx) at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state) at System.Threading.ThreadHelper.ThreadStart() 2026-01-12 21:54:30.1677 DFramework.Database.NullableDataReader Data reader open for 530 at System.Environment.GetStackTrace(Exception e, Boolean needFileInfo) at System.Environment.get_StackTrace() at DFramework.Database.NullableDataReader.Dispose(Boolean disposing) in C:\CoolR-Group\Framework\DFramework\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 D:\Spraxa\Framework\DFramework.Scheduler\TaskBase.cs:line 176 at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx) at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx) at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state) at System.Threading.ThreadHelper.ThreadStart() 2026-01-12 21:54:30.4021 DFramework.Database.NullableDataReader Data reader open for 889 at System.Environment.GetStackTrace(Exception e, Boolean needFileInfo) at System.Environment.get_StackTrace() at DFramework.Database.NullableDataReader.Dispose(Boolean disposing) in C:\CoolR-Group\Framework\DFramework\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 D:\Spraxa\Framework\DFramework.Scheduler\TaskBase.cs:line 176 at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx) at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx) at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state) at System.Threading.ThreadHelper.ThreadStart() 2026-01-12 21:54:31.0115 DFramework.Database.Query /* Time Taken: 610*/ DECLARE @TableName AnsiString(8000) SET @TableName = 'VoidAlert' DECLARE @CurrentRecordId Int32 SET @CurrentRecordId = '3675979' dbo.GetValidDeviceForAlertProcessData 2026-01-12 21:54:31.4802 DFramework.Database.NullableDataReader Data reader open for 438 at System.Environment.GetStackTrace(Exception e, Boolean needFileInfo) at System.Environment.get_StackTrace() at DFramework.Database.NullableDataReader.Dispose(Boolean disposing) in C:\CoolR-Group\Framework\DFramework\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 D:\Spraxa\Framework\DFramework.Scheduler\TaskBase.cs:line 176 at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx) at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx) at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state) at System.Threading.ThreadHelper.ThreadStart() 2026-01-12 21:54:31.7302 DFramework.Database.NullableDataReader Data reader open for 209 at System.Environment.GetStackTrace(Exception e, Boolean needFileInfo) at System.Environment.get_StackTrace() at DFramework.Database.NullableDataReader.Dispose(Boolean disposing) in C:\CoolR-Group\Framework\DFramework\Database\NullableDataReader.cs:line 33 at DFramework.Database.NullableDataReader.Dispose() in C:\CoolR-Group\Framework\DFramework\Database\NullableDataReader.cs:line 44 at CoolR.Tasks.ProcessAlertData.Execute() in C:\Program Files (x86)\Go Agent\pipelines\coolr-portal-dev-task-service-new\CoolR.Tasks\ProcessAlertData.cs:line 48 at DFramework.Scheduler.TaskBase.Run() in D:\Spraxa\Framework\DFramework.Scheduler\TaskBase.cs:line 176 at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx) at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx) at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state) at System.Threading.ThreadHelper.ThreadStart() 2026-01-12 21:54:31.7927 DFramework.Database.NullableDataReader Data reader open for 777 at System.Environment.GetStackTrace(Exception e, Boolean needFileInfo) at System.Environment.get_StackTrace() at DFramework.Database.NullableDataReader.Dispose(Boolean disposing) in C:\CoolR-Group\Framework\DFramework\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 D:\Spraxa\Framework\DFramework.Scheduler\TaskBase.cs:line 176 at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx) at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx) at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state) at System.Threading.ThreadHelper.ThreadStart() 2026-01-12 21:54:32.4802 DFramework.Database.NullableDataReader Data reader open for 258 at System.Environment.GetStackTrace(Exception e, Boolean needFileInfo) at System.Environment.get_StackTrace() at DFramework.Database.NullableDataReader.Dispose(Boolean disposing) in C:\CoolR-Group\Framework\DFramework\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 D:\Spraxa\Framework\DFramework.Scheduler\TaskBase.cs:line 176 at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx) at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx) at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state) at System.Threading.ThreadHelper.ThreadStart() 2026-01-12 21:54:33.1833 DFramework.Database.NullableDataReader Data reader open for 287 at System.Environment.GetStackTrace(Exception e, Boolean needFileInfo) at System.Environment.get_StackTrace() at DFramework.Database.NullableDataReader.Dispose(Boolean disposing) in C:\CoolR-Group\Framework\DFramework\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 D:\Spraxa\Framework\DFramework.Scheduler\TaskBase.cs:line 176 at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx) at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx) at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state) at System.Threading.ThreadHelper.ThreadStart() 2026-01-12 21:54:33.8396 DFramework.Database.NullableDataReader Data reader open for 242 at System.Environment.GetStackTrace(Exception e, Boolean needFileInfo) at System.Environment.get_StackTrace() at DFramework.Database.NullableDataReader.Dispose(Boolean disposing) in C:\CoolR-Group\Framework\DFramework\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 D:\Spraxa\Framework\DFramework.Scheduler\TaskBase.cs:line 176 at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx) at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx) at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state) at System.Threading.ThreadHelper.ThreadStart() 2026-01-12 21:54:34.0896 DFramework.Database.NullableDataReader Data reader open for 230 at System.Environment.GetStackTrace(Exception e, Boolean needFileInfo) at System.Environment.get_StackTrace() at DFramework.Database.NullableDataReader.Dispose(Boolean disposing) in C:\CoolR-Group\Framework\DFramework\Database\NullableDataReader.cs:line 33 at DFramework.Database.NullableDataReader.Dispose() in C:\CoolR-Group\Framework\DFramework\Database\NullableDataReader.cs:line 44 at CoolR.Tasks.ProcessAlertData.Execute() in 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 D:\Spraxa\Framework\DFramework.Scheduler\TaskBase.cs:line 176 at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx) at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx) at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state) at System.Threading.ThreadHelper.ThreadStart() 2026-01-12 21:54:34.3552 DFramework.Database.NullableDataReader Data reader open for 232 at System.Environment.GetStackTrace(Exception e, Boolean needFileInfo) at System.Environment.get_StackTrace() at DFramework.Database.NullableDataReader.Dispose(Boolean disposing) in C:\CoolR-Group\Framework\DFramework\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 D:\Spraxa\Framework\DFramework.Scheduler\TaskBase.cs:line 176 at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx) at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx) at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state) at System.Threading.ThreadHelper.ThreadStart() 2026-01-12 21:54:34.6208 DFramework.Database.NullableDataReader Data reader open for 233 at System.Environment.GetStackTrace(Exception e, Boolean needFileInfo) at System.Environment.get_StackTrace() at DFramework.Database.NullableDataReader.Dispose(Boolean disposing) in C:\CoolR-Group\Framework\DFramework\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 D:\Spraxa\Framework\DFramework.Scheduler\TaskBase.cs:line 176 at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx) at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx) at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state) at System.Threading.ThreadHelper.ThreadStart() 2026-01-12 21:54:34.8865 DFramework.Database.NullableDataReader Data reader open for 230 at System.Environment.GetStackTrace(Exception e, Boolean needFileInfo) at System.Environment.get_StackTrace() at DFramework.Database.NullableDataReader.Dispose(Boolean disposing) in C:\CoolR-Group\Framework\DFramework\Database\NullableDataReader.cs:line 33 at DFramework.Database.NullableDataReader.Dispose() in C:\CoolR-Group\Framework\DFramework\Database\NullableDataReader.cs:line 44 at CoolR.Tasks.ProcessAlertData.Execute() in 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 D:\Spraxa\Framework\DFramework.Scheduler\TaskBase.cs:line 176 at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx) at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx) at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state) at System.Threading.ThreadHelper.ThreadStart() 2026-01-12 21:54:34.9802 DFramework.Database.NullableDataReader Data reader open for 1429 at System.Environment.GetStackTrace(Exception e, Boolean needFileInfo) at System.Environment.get_StackTrace() at DFramework.Database.NullableDataReader.Dispose(Boolean disposing) in C:\CoolR-Group\Framework\DFramework\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 D:\Spraxa\Framework\DFramework.Scheduler\TaskBase.cs:line 176 at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx) at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx) at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state) at System.Threading.ThreadHelper.ThreadStart() 2026-01-12 21:54:36.3240 DFramework.Database.NullableDataReader Data reader open for 291 at System.Environment.GetStackTrace(Exception e, Boolean needFileInfo) at System.Environment.get_StackTrace() at DFramework.Database.NullableDataReader.Dispose(Boolean disposing) in C:\CoolR-Group\Framework\DFramework\Database\NullableDataReader.cs:line 33 at DFramework.Database.NullableDataReader.Dispose() in C:\CoolR-Group\Framework\DFramework\Database\NullableDataReader.cs:line 44 at CoolR.Tasks.ProcessAlertData.Execute() in 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 D:\Spraxa\Framework\DFramework.Scheduler\TaskBase.cs:line 176 at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx) at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx) at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state) at System.Threading.ThreadHelper.ThreadStart() 2026-01-12 21:54:36.4334 DFramework.Database.NullableDataReader Data reader open for 1011 at System.Environment.GetStackTrace(Exception e, Boolean needFileInfo) at System.Environment.get_StackTrace() at DFramework.Database.NullableDataReader.Dispose(Boolean disposing) in C:\CoolR-Group\Framework\DFramework\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 D:\Spraxa\Framework\DFramework.Scheduler\TaskBase.cs:line 176 at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx) at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx) at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state) at System.Threading.ThreadHelper.ThreadStart() 2026-01-12 21:54:37.4959 DFramework.Database.NullableDataReader Data reader open for 341 at System.Environment.GetStackTrace(Exception e, Boolean needFileInfo) at System.Environment.get_StackTrace() at DFramework.Database.NullableDataReader.Dispose(Boolean disposing) in C:\CoolR-Group\Framework\DFramework\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 D:\Spraxa\Framework\DFramework.Scheduler\TaskBase.cs:line 176 at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx) at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx) at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state) at System.Threading.ThreadHelper.ThreadStart() 2026-01-12 21:54:37.5896 DFramework.Database.NullableDataReader Data reader open for 797 at System.Environment.GetStackTrace(Exception e, Boolean needFileInfo) at System.Environment.get_StackTrace() at DFramework.Database.NullableDataReader.Dispose(Boolean disposing) in C:\CoolR-Group\Framework\DFramework\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 D:\Spraxa\Framework\DFramework.Scheduler\TaskBase.cs:line 176 at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx) at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx) at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state) at System.Threading.ThreadHelper.ThreadStart() 2026-01-12 21:54:38.2771 DFramework.Database.Query /* Time Taken: 688*/ DECLARE @TableName AnsiString(8000) SET @TableName = 'AssetStockProductWiseConsolidate' DECLARE @CurrentRecordId Int32 SET @CurrentRecordId = '3675979' dbo.GetValidDeviceForAlertProcessData 2026-01-12 21:54:45.3553 DFramework.Scheduler.TaskBase /* Time Taken: 17390.7546*/ Opportunity Out Of Stock By Outlet 2026-01-12 22:09:28.8775 DFramework.Database.Query /* Time Taken: 518*/ [dbo].GenerateSystemAlerts 2026-01-12 22:09:43.5338 DFramework.Scheduler.TaskBase /* Time Taken: 15547.0153*/ Opportunity Out Of Stock By Outlet 2026-01-12 22:23:09.5243 DFramework.Database.NullableDataReader Data reader open for 1710640 at System.Environment.GetStackTrace(Exception e, Boolean needFileInfo) at System.Environment.get_StackTrace() at DFramework.Database.NullableDataReader.Dispose(Boolean disposing) in C:\CoolR-Group\Framework\DFramework\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 343 at DFramework.Scheduler.TaskBase.Run() in D:\Spraxa\Framework\DFramework.Scheduler\TaskBase.cs:line 176 at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx) at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx) at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state) at System.Threading.ThreadHelper.ThreadStart() 2026-01-12 22:23:09.5243 DFramework.Database.NullableDataReader Data reader open for 1710735 at System.Environment.GetStackTrace(Exception e, Boolean needFileInfo) at System.Environment.get_StackTrace() at DFramework.Database.NullableDataReader.Dispose(Boolean disposing) in C:\CoolR-Group\Framework\DFramework\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 343 at DFramework.Scheduler.TaskBase.Run() in D:\Spraxa\Framework\DFramework.Scheduler\TaskBase.cs:line 176 at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx) at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx) at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state) at System.Threading.ThreadHelper.ThreadStart() 2026-01-12 22:23:10.2586 DFramework.Scheduler.TaskBase /* Time Taken: 1722294.089*/ Process Alert Record 2026-01-12 22:23:32.8057 DFramework.Database.Query /* Time Taken: 14734*/ 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-12 22:23:32.8057 DFramework.Database.Query /* Time Taken: 14734*/ 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-12 22:23:32.8057 DFramework.Database.Query /* Time Taken: 14735*/ 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-12 22:23:32.8057 DFramework.Database.Query /* Time Taken: 14737*/ 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-12 22:23:32.8057 DFramework.Database.Query /* Time Taken: 14738*/ 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-12 22:23:32.8213 DFramework.Scheduler.TaskBase /* Time Taken: 14750.104*/ ProcessSQLUnprocessedFiles 2026-01-12 22:23:32.8369 DFramework.Scheduler.TaskBase /* Time Taken: 14765.7285*/ ProcessSQLUnprocessedFiles 2026-01-12 22:23:32.8526 DFramework.Scheduler.TaskBase /* Time Taken: 14781.3564*/ ProcessSQLUnprocessedFiles 2026-01-12 22:23:32.8526 DFramework.Scheduler.TaskBase /* Time Taken: 14781.3564*/ ProcessSQLUnprocessedFiles 2026-01-12 22:23:32.8526 DFramework.Scheduler.TaskBase /* Time Taken: 14781.3564*/ ProcessSQLUnprocessedFiles 2026-01-12 22:23:37.9151 DFramework.Database.Query /* Time Taken: 4801*/ 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-12 22:23:37.9620 DFramework.Database.Query /* Time Taken: 4849*/ 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-12 22:23:38.0088 DFramework.Database.Query /* Time Taken: 4901*/ 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-12 22:23:38.0401 DFramework.Database.Query /* Time Taken: 4925*/ 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-12 22:23:38.3838 DFramework.Database.Query /* Time Taken: 5269*/ 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-12 22:24:28.0092 AlertProcessor ProcessorAlertData: started 2026-01-12 22:24:28.7592 DFramework.Database.Query /* Time Taken: 597*/ DECLARE @ClientId Int32 SET @ClientId = '213' DECLARE @MarketId Int32 SET @MarketId = '0' DECLARE @ClassificationId Int32 SET @ClassificationId = '0' DECLARE @LocationId Int32 SET @LocationId = '0' DECLARE @LocationTypeId Int32 SET @LocationTypeId = '0' DECLARE @StartDate DateTime2 SET @StartDate = '8/28/2025 12:00:00 AM' dbo.GetOpportunityOutOfStockDataByOutlet 2026-01-12 22:24:29.0248 DFramework.Database.Query /* Time Taken: 681*/ 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-12 22:24:29.6498 DFramework.Database.Query /* Time Taken: 1640*/ DECLARE @TableName AnsiString(8000) SET @TableName = 'TagAlert' DECLARE @CurrentRecordId Int32 SET @CurrentRecordId = '0' dbo.GetValidDeviceForAlertProcessData 2026-01-12 22:24:30.1342 DFramework.Database.NullableDataReader Data reader open for 482 at System.Environment.GetStackTrace(Exception e, Boolean needFileInfo) at System.Environment.get_StackTrace() at DFramework.Database.NullableDataReader.Dispose(Boolean disposing) in C:\CoolR-Group\Framework\DFramework\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 D:\Spraxa\Framework\DFramework.Scheduler\TaskBase.cs:line 176 at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx) at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx) at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state) at System.Threading.ThreadHelper.ThreadStart() 2026-01-12 22:24:30.3998 DFramework.Database.Query /* Time Taken: 2040*/ [dbo].GenerateSystemAlerts 2026-01-12 22:24:31.0717 DFramework.Database.NullableDataReader Data reader open for 487 at System.Environment.GetStackTrace(Exception e, Boolean needFileInfo) at System.Environment.get_StackTrace() at DFramework.Database.NullableDataReader.Dispose(Boolean disposing) in C:\CoolR-Group\Framework\DFramework\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 D:\Spraxa\Framework\DFramework.Scheduler\TaskBase.cs:line 176 at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx) at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx) at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state) at System.Threading.ThreadHelper.ThreadStart() 2026-01-12 22:24:31.3061 DFramework.Database.NullableDataReader Data reader open for 209 at System.Environment.GetStackTrace(Exception e, Boolean needFileInfo) at System.Environment.get_StackTrace() at DFramework.Database.NullableDataReader.Dispose(Boolean disposing) in C:\CoolR-Group\Framework\DFramework\Database\NullableDataReader.cs:line 33 at DFramework.Database.NullableDataReader.Dispose() in C:\CoolR-Group\Framework\DFramework\Database\NullableDataReader.cs:line 44 at CoolR.Tasks.ProcessAlertData.Execute() in C:\Program Files (x86)\Go Agent\pipelines\coolr-portal-dev-task-service-new\CoolR.Tasks\ProcessAlertData.cs:line 48 at DFramework.Scheduler.TaskBase.Run() in D:\Spraxa\Framework\DFramework.Scheduler\TaskBase.cs:line 176 at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx) at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx) at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state) at System.Threading.ThreadHelper.ThreadStart() 2026-01-12 22:24:31.3686 DFramework.Database.NullableDataReader Data reader open for 821 at System.Environment.GetStackTrace(Exception e, Boolean needFileInfo) at System.Environment.get_StackTrace() at DFramework.Database.NullableDataReader.Dispose(Boolean disposing) in C:\CoolR-Group\Framework\DFramework\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 D:\Spraxa\Framework\DFramework.Scheduler\TaskBase.cs:line 176 at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx) at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx) at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state) at System.Threading.ThreadHelper.ThreadStart() 2026-01-12 22:24:32.1499 DFramework.Database.Query /* Time Taken: 782*/ DECLARE @TableName AnsiString(8000) SET @TableName = 'MissingShelf' DECLARE @CurrentRecordId Int32 SET @CurrentRecordId = '3675979' dbo.GetValidDeviceForAlertProcessData 2026-01-12 22:24:32.4155 DFramework.Database.NullableDataReader Data reader open for 272 at System.Environment.GetStackTrace(Exception e, Boolean needFileInfo) at System.Environment.get_StackTrace() at DFramework.Database.NullableDataReader.Dispose(Boolean disposing) in C:\CoolR-Group\Framework\DFramework\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 D:\Spraxa\Framework\DFramework.Scheduler\TaskBase.cs:line 176 at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx) at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx) at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state) at System.Threading.ThreadHelper.ThreadStart() 2026-01-12 22:24:33.1030 DFramework.Database.NullableDataReader Data reader open for 277 at System.Environment.GetStackTrace(Exception e, Boolean needFileInfo) at System.Environment.get_StackTrace() at DFramework.Database.NullableDataReader.Dispose(Boolean disposing) in C:\CoolR-Group\Framework\DFramework\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 D:\Spraxa\Framework\DFramework.Scheduler\TaskBase.cs:line 176 at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx) at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx) at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state) at System.Threading.ThreadHelper.ThreadStart() 2026-01-12 22:24:33.7436 DFramework.Database.NullableDataReader Data reader open for 260 at System.Environment.GetStackTrace(Exception e, Boolean needFileInfo) at System.Environment.get_StackTrace() at DFramework.Database.NullableDataReader.Dispose(Boolean disposing) in C:\CoolR-Group\Framework\DFramework\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 D:\Spraxa\Framework\DFramework.Scheduler\TaskBase.cs:line 176 at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx) at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx) at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state) at System.Threading.ThreadHelper.ThreadStart() 2026-01-12 22:24:34.0093 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 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 D:\Spraxa\Framework\DFramework.Scheduler\TaskBase.cs:line 176 at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx) at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx) at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state) at System.Threading.ThreadHelper.ThreadStart() 2026-01-12 22:24:34.2905 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 D:\Spraxa\Framework\DFramework.Scheduler\TaskBase.cs:line 176 at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx) at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx) at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state) at System.Threading.ThreadHelper.ThreadStart() 2026-01-12 22:24:34.5718 DFramework.Database.NullableDataReader Data reader open for 245 at System.Environment.GetStackTrace(Exception e, Boolean needFileInfo) at System.Environment.get_StackTrace() at DFramework.Database.NullableDataReader.Dispose(Boolean disposing) in C:\CoolR-Group\Framework\DFramework\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 D:\Spraxa\Framework\DFramework.Scheduler\TaskBase.cs:line 176 at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx) at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx) at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state) at System.Threading.ThreadHelper.ThreadStart() 2026-01-12 22:24:34.8530 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:\Program Files (x86)\Go Agent\pipelines\coolr-portal-dev-task-service-new\CoolR.Tasks\ProcessAlertData.cs:line 48 at DFramework.Scheduler.TaskBase.Run() in D:\Spraxa\Framework\DFramework.Scheduler\TaskBase.cs:line 176 at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx) at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx) at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state) at System.Threading.ThreadHelper.ThreadStart() 2026-01-12 22:24:34.9468 DFramework.Database.NullableDataReader Data reader open for 1487 at System.Environment.GetStackTrace(Exception e, Boolean needFileInfo) at System.Environment.get_StackTrace() at DFramework.Database.NullableDataReader.Dispose(Boolean disposing) in C:\CoolR-Group\Framework\DFramework\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 D:\Spraxa\Framework\DFramework.Scheduler\TaskBase.cs:line 176 at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx) at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx) at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state) at System.Threading.ThreadHelper.ThreadStart() 2026-01-12 22:24:36.3218 DFramework.Database.NullableDataReader Data reader open for 370 at System.Environment.GetStackTrace(Exception e, Boolean needFileInfo) at System.Environment.get_StackTrace() at DFramework.Database.NullableDataReader.Dispose(Boolean disposing) in C:\CoolR-Group\Framework\DFramework\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 D:\Spraxa\Framework\DFramework.Scheduler\TaskBase.cs:line 176 at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx) at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx) at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state) at System.Threading.ThreadHelper.ThreadStart() 2026-01-12 22:24:36.4155 DFramework.Database.NullableDataReader Data reader open for 1087 at System.Environment.GetStackTrace(Exception e, Boolean needFileInfo) at System.Environment.get_StackTrace() at DFramework.Database.NullableDataReader.Dispose(Boolean disposing) in C:\CoolR-Group\Framework\DFramework\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 D:\Spraxa\Framework\DFramework.Scheduler\TaskBase.cs:line 176 at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx) at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx) at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state) at System.Threading.ThreadHelper.ThreadStart() 2026-01-12 22:24:37.5561 DFramework.Database.NullableDataReader Data reader open for 438 at System.Environment.GetStackTrace(Exception e, Boolean needFileInfo) at System.Environment.get_StackTrace() at DFramework.Database.NullableDataReader.Dispose(Boolean disposing) in C:\CoolR-Group\Framework\DFramework\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 D:\Spraxa\Framework\DFramework.Scheduler\TaskBase.cs:line 176 at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx) at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx) at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state) at System.Threading.ThreadHelper.ThreadStart() 2026-01-12 22:24:37.6499 DFramework.Database.NullableDataReader Data reader open for 888 at System.Environment.GetStackTrace(Exception e, Boolean needFileInfo) at System.Environment.get_StackTrace() at DFramework.Database.NullableDataReader.Dispose(Boolean disposing) in C:\CoolR-Group\Framework\DFramework\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 D:\Spraxa\Framework\DFramework.Scheduler\TaskBase.cs:line 176 at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx) at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx) at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state) at System.Threading.ThreadHelper.ThreadStart() 2026-01-12 22:24:38.5405 DFramework.Database.Query /* Time Taken: 886*/ DECLARE @TableName AnsiString(8000) SET @TableName = 'AssetStockProductWiseConsolidate' DECLARE @CurrentRecordId Int32 SET @CurrentRecordId = '3675979' dbo.GetValidDeviceForAlertProcessData 2026-01-12 22:24:44.0562 DFramework.Scheduler.TaskBase /* Time Taken: 16046.9827*/ Opportunity Out Of Stock By Outlet 2026-01-12 22:34:28.8107 MoveToReorder Running task for ClientId : 286 and ClientName = India Office QA and Slot: 1/13/2026 12:00:00 PM And LastExecutedOn: 1/13/2026 11:01:20 AM 2026-01-12 22:34:29.7951 DFramework.Database.NullableDataReader Data reader open for 349 at System.Environment.GetStackTrace(Exception e, Boolean needFileInfo) at System.Environment.get_StackTrace() at DFramework.Database.NullableDataReader.Dispose(Boolean disposing) in C:\CoolR-Group\Framework\DFramework\Database\NullableDataReader.cs:line 33 at DFramework.Database.NullableDataReader.Dispose() in C:\CoolR-Group\Framework\DFramework\Database\NullableDataReader.cs:line 44 at CoolR.Tasks.MoveToReorder.Execute() in C:\Program Files (x86)\Go Agent\pipelines\coolr-portal-dev-task-service-new\CoolR.Tasks\MoveToReorder.cs:line 50 at DFramework.Scheduler.TaskBase.Run() in D:\Spraxa\Framework\DFramework.Scheduler\TaskBase.cs:line 176 at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx) at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx) at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state) at System.Threading.ThreadHelper.ThreadStart() 2026-01-12 22:34:29.8263 MoveToReorder Task executed successfully for ClientId : 286 Client Name:India Office QA, Slot: 1/13/2026 12:00:00 PM and Total Order Suggested: 1 Out Of: 1 2026-01-12 22:36:50.6086 DFramework.Database.NullableDataReader Data reader open for 731505 at System.Environment.GetStackTrace(Exception e, Boolean needFileInfo) at System.Environment.get_StackTrace() at DFramework.Database.NullableDataReader.Dispose(Boolean disposing) in C:\CoolR-Group\Framework\DFramework\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 343 at DFramework.Scheduler.TaskBase.Run() in D:\Spraxa\Framework\DFramework.Scheduler\TaskBase.cs:line 176 at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx) at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx) at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state) at System.Threading.ThreadHelper.ThreadStart() 2026-01-12 22:36:50.6086 DFramework.Database.NullableDataReader Data reader open for 731600 at System.Environment.GetStackTrace(Exception e, Boolean needFileInfo) at System.Environment.get_StackTrace() at DFramework.Database.NullableDataReader.Dispose(Boolean disposing) in C:\CoolR-Group\Framework\DFramework\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 343 at DFramework.Scheduler.TaskBase.Run() in D:\Spraxa\Framework\DFramework.Scheduler\TaskBase.cs:line 176 at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx) at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx) at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state) at System.Threading.ThreadHelper.ThreadStart() 2026-01-12 22:36:50.8899 DFramework.Scheduler.TaskBase /* Time Taken: 742880.6477*/ Process Alert Record 2026-01-12 22:59:59.5098 AlertProcessor ProcessorAlertData: started 2026-01-12 23:00:00.2442 DFramework.Database.Query /* Time Taken: 695*/ 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-12 23:00:00.2910 DFramework.Database.Query /* Time Taken: 704*/ DECLARE @CreatedOn Date SET @CreatedOn = '1/13/2026 12:00:00 AM' DECLARE @EventId Int32 SET @EventId = '-12' SELECT COUNT(1) FROM EmailQueue WHERE [CreatedOn] >= @CreatedOn AND [EventId] = @EventId 2026-01-12 23:00:00.3379 DFramework.Database.Query /* Time Taken: 750*/ 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-12 23:00:00.3692 DFramework.Database.Query /* Time Taken: 812*/ 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-12 23:00:00.4004 DFramework.Database.Query /* Time Taken: 847*/ 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-12 23:00:00.5098 DFramework.Database.Query /* Time Taken: 920*/ 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-12 23:00:00.6348 DFramework.Database.Query /* Time Taken: 1044*/ 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-12 23:00:00.6973 DFramework.Database.Query /* Time Taken: 1084*/ DECLARE @OrderStatusId Int32 SET @OrderStatusId = '5486' DECLARE @CurrentUtcDateTime DateTime2 SET @CurrentUtcDateTime = '1/13/2026 6:59:59 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-12 23:00:00.7285 DFramework.Database.Query /* Time Taken: 1142*/ 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/13/2026 6:59:59 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-12 23:00:00.7598 DFramework.Database.Query /* Time Taken: 1194*/ 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-12 23:00:00.7910 DFramework.Database.Query /* Time Taken: 762*/ DECLARE @AlertDefinitionId Int32 SET @AlertDefinitionId = '99' DECLARE @IsDeleted Boolean SET @IsDeleted = 'False' SELECT ProductId FROM AlertDefinitionProduct WHERE [AlertDefinitionId] = @AlertDefinitionId AND IsDeleted = @IsDeleted 2026-01-12 23:00:00.8848 DFramework.Database.Query /* Time Taken: 811*/ DECLARE @AssetKPIData Object SET @AssetKPIData = '' [dbo].BulkUpsertAssetDayKPI 2026-01-12 23:00:01.1035 DFramework.Database.Query /* Time Taken: 1567*/ 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-12 23:00:01.2442 DFramework.Database.NullableDataReader Data reader open for 1224 at System.Environment.GetStackTrace(Exception e, Boolean needFileInfo) at System.Environment.get_StackTrace() at DFramework.Database.NullableDataReader.Dispose(Boolean disposing) in C:\CoolR-Group\Framework\DFramework\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 D:\Spraxa\Framework\DFramework.Scheduler\TaskBase.cs:line 176 at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx) at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx) at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state) at System.Threading.ThreadHelper.ThreadStart() 2026-01-12 23:00:01.4160 DFramework.Database.Query /* Time Taken: 684*/ 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-12 23:00:01.4317 DFramework.Database.Query /* Time Taken: 1894*/ DECLARE @TableName AnsiString(8000) SET @TableName = 'TagAlert' DECLARE @CurrentRecordId Int32 SET @CurrentRecordId = '0' dbo.GetValidDeviceForAlertProcessData 2026-01-12 23:00:01.4473 DFramework.Database.Query /* Time Taken: 1856*/ [dbo].GenerateSystemAlerts 2026-01-12 23:00:01.8692 DFramework.Database.NullableDataReader Data reader open for 430 at System.Environment.GetStackTrace(Exception e, Boolean needFileInfo) at System.Environment.get_StackTrace() at DFramework.Database.NullableDataReader.Dispose(Boolean disposing) in C:\CoolR-Group\Framework\DFramework\Database\NullableDataReader.cs:line 33 at DFramework.Database.NullableDataReader.Dispose() in C:\CoolR-Group\Framework\DFramework\Database\NullableDataReader.cs:line 44 at CoolR.Tasks.ProcessAlertData.Execute() in C:\Program Files (x86)\Go Agent\pipelines\coolr-portal-dev-task-service-new\CoolR.Tasks\ProcessAlertData.cs:line 48 at DFramework.Scheduler.TaskBase.Run() in D:\Spraxa\Framework\DFramework.Scheduler\TaskBase.cs:line 176 at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx) at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx) at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state) at System.Threading.ThreadHelper.ThreadStart() 2026-01-12 23:00:02.7442 DFramework.Database.NullableDataReader Data reader open for 448 at System.Environment.GetStackTrace(Exception e, Boolean needFileInfo) at System.Environment.get_StackTrace() at DFramework.Database.NullableDataReader.Dispose(Boolean disposing) in C:\CoolR-Group\Framework\DFramework\Database\NullableDataReader.cs:line 33 at DFramework.Database.NullableDataReader.Dispose() in C:\CoolR-Group\Framework\DFramework\Database\NullableDataReader.cs:line 44 at CoolR.Tasks.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 D:\Spraxa\Framework\DFramework.Scheduler\TaskBase.cs:line 176 at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx) at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx) at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state) at System.Threading.ThreadHelper.ThreadStart() 2026-01-12 23:00:02.9942 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:\Program Files (x86)\Go Agent\pipelines\coolr-portal-dev-task-service-new\CoolR.Tasks\ProcessAlertData.cs:line 48 at DFramework.Scheduler.TaskBase.Run() in D:\Spraxa\Framework\DFramework.Scheduler\TaskBase.cs:line 176 at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx) at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx) at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state) at System.Threading.ThreadHelper.ThreadStart() 2026-01-12 23:00:03.0567 DFramework.Database.NullableDataReader Data reader open for 797 at System.Environment.GetStackTrace(Exception e, Boolean needFileInfo) at System.Environment.get_StackTrace() at DFramework.Database.NullableDataReader.Dispose(Boolean disposing) in C:\CoolR-Group\Framework\DFramework\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 D:\Spraxa\Framework\DFramework.Scheduler\TaskBase.cs:line 176 at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx) at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx) at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state) at System.Threading.ThreadHelper.ThreadStart() 2026-01-12 23:00:03.7911 DFramework.Database.NullableDataReader Data reader open for 249 at System.Environment.GetStackTrace(Exception e, Boolean needFileInfo) at System.Environment.get_StackTrace() at DFramework.Database.NullableDataReader.Dispose(Boolean disposing) in C:\CoolR-Group\Framework\DFramework\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 D:\Spraxa\Framework\DFramework.Scheduler\TaskBase.cs:line 176 at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx) at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx) at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state) at System.Threading.ThreadHelper.ThreadStart() 2026-01-12 23:00:04.4786 DFramework.Database.NullableDataReader Data reader open for 280 at System.Environment.GetStackTrace(Exception e, Boolean needFileInfo) at System.Environment.get_StackTrace() at DFramework.Database.NullableDataReader.Dispose(Boolean disposing) in C:\CoolR-Group\Framework\DFramework\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 D:\Spraxa\Framework\DFramework.Scheduler\TaskBase.cs:line 176 at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx) at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx) at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state) at System.Threading.ThreadHelper.ThreadStart() 2026-01-12 23:00:05.1036 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:\Program Files (x86)\Go Agent\pipelines\coolr-portal-dev-task-service-new\CoolR.Tasks\ProcessAlertData.cs:line 48 at DFramework.Scheduler.TaskBase.Run() in D:\Spraxa\Framework\DFramework.Scheduler\TaskBase.cs:line 176 at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx) at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx) at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state) at System.Threading.ThreadHelper.ThreadStart() 2026-01-12 23:00:05.3536 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 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 D:\Spraxa\Framework\DFramework.Scheduler\TaskBase.cs:line 176 at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx) at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx) at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state) at System.Threading.ThreadHelper.ThreadStart() 2026-01-12 23:00:05.6192 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 D:\Spraxa\Framework\DFramework.Scheduler\TaskBase.cs:line 176 at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx) at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx) at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state) at System.Threading.ThreadHelper.ThreadStart() 2026-01-12 23:00:05.8692 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:\Program Files (x86)\Go Agent\pipelines\coolr-portal-dev-task-service-new\CoolR.Tasks\ProcessAlertData.cs:line 48 at DFramework.Scheduler.TaskBase.Run() in D:\Spraxa\Framework\DFramework.Scheduler\TaskBase.cs:line 176 at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx) at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx) at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state) at System.Threading.ThreadHelper.ThreadStart() 2026-01-12 23:00:06.1192 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 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 D:\Spraxa\Framework\DFramework.Scheduler\TaskBase.cs:line 176 at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx) at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx) at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state) at System.Threading.ThreadHelper.ThreadStart() 2026-01-12 23:00:06.2286 DFramework.Database.NullableDataReader Data reader open for 1388 at System.Environment.GetStackTrace(Exception e, Boolean needFileInfo) at System.Environment.get_StackTrace() at DFramework.Database.NullableDataReader.Dispose(Boolean disposing) in C:\CoolR-Group\Framework\DFramework\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 D:\Spraxa\Framework\DFramework.Scheduler\TaskBase.cs:line 176 at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx) at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx) at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state) at System.Threading.ThreadHelper.ThreadStart() 2026-01-12 23:00:07.5411 DFramework.Database.NullableDataReader Data reader open for 332 at System.Environment.GetStackTrace(Exception e, Boolean needFileInfo) at System.Environment.get_StackTrace() at DFramework.Database.NullableDataReader.Dispose(Boolean disposing) in C:\CoolR-Group\Framework\DFramework\Database\NullableDataReader.cs:line 33 at DFramework.Database.NullableDataReader.Dispose() in C:\CoolR-Group\Framework\DFramework\Database\NullableDataReader.cs:line 44 at CoolR.Tasks.ProcessAlertData.Execute() in C:\Program Files (x86)\Go Agent\pipelines\coolr-portal-dev-task-service-new\CoolR.Tasks\ProcessAlertData.cs:line 48 at DFramework.Scheduler.TaskBase.Run() in D:\Spraxa\Framework\DFramework.Scheduler\TaskBase.cs:line 176 at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx) at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx) at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state) at System.Threading.ThreadHelper.ThreadStart() 2026-01-12 23:00:07.6661 DFramework.Database.NullableDataReader Data reader open for 1063 at System.Environment.GetStackTrace(Exception e, Boolean needFileInfo) at System.Environment.get_StackTrace() at DFramework.Database.NullableDataReader.Dispose(Boolean disposing) in C:\CoolR-Group\Framework\DFramework\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 D:\Spraxa\Framework\DFramework.Scheduler\TaskBase.cs:line 176 at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx) at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx) at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state) at System.Threading.ThreadHelper.ThreadStart() 2026-01-12 23:00:08.7286 DFramework.Database.NullableDataReader Data reader open for 338 at System.Environment.GetStackTrace(Exception e, Boolean needFileInfo) at System.Environment.get_StackTrace() at DFramework.Database.NullableDataReader.Dispose(Boolean disposing) in C:\CoolR-Group\Framework\DFramework\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 D:\Spraxa\Framework\DFramework.Scheduler\TaskBase.cs:line 176 at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx) at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx) at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state) at System.Threading.ThreadHelper.ThreadStart() 2026-01-12 23:00:08.8223 DFramework.Database.NullableDataReader Data reader open for 784 at System.Environment.GetStackTrace(Exception e, Boolean needFileInfo) at System.Environment.get_StackTrace() at DFramework.Database.NullableDataReader.Dispose(Boolean disposing) in C:\CoolR-Group\Framework\DFramework\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 D:\Spraxa\Framework\DFramework.Scheduler\TaskBase.cs:line 176 at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx) at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx) at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state) at System.Threading.ThreadHelper.ThreadStart() 2026-01-12 23:00:09.4473 DFramework.Database.Query /* Time Taken: 624*/ DECLARE @TableName AnsiString(8000) SET @TableName = 'AssetStockProductWiseConsolidate' DECLARE @CurrentRecordId Int32 SET @CurrentRecordId = '3675979' dbo.GetValidDeviceForAlertProcessData 2026-01-12 23:00:16.8068 DFramework.Scheduler.TaskBase /* Time Taken: 17312.6291*/ Opportunity Out Of Stock By Outlet 2026-01-12 23:15:00.3282 DFramework.Database.Query /* Time Taken: 744*/ [dbo].GenerateSystemAlerts 2026-01-12 23:15:15.0314 DFramework.Scheduler.TaskBase /* Time Taken: 15515.7392*/ Opportunity Out Of Stock By Outlet 2026-01-12 23:30:00.1640 DFramework.Database.Query /* Time Taken: 567*/ [dbo].GenerateSystemAlerts 2026-01-12 23:30:00.3202 MoveToReorder Running task for ClientId : 286 and ClientName = India Office QA and Slot: 1/13/2026 1:00:00 PM And LastExecutedOn: 1/13/2026 12:04:28 PM 2026-01-12 23:30:01.4452 DFramework.Database.NullableDataReader Data reader open for 846 at System.Environment.GetStackTrace(Exception e, Boolean needFileInfo) at System.Environment.get_StackTrace() at DFramework.Database.NullableDataReader.Dispose(Boolean disposing) in C:\CoolR-Group\Framework\DFramework\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:\Program Files (x86)\Go Agent\pipelines\coolr-portal-dev-task-service-new\CoolR.Tasks\MoveToReorder.cs:line 50 at DFramework.Scheduler.TaskBase.Run() in D:\Spraxa\Framework\DFramework.Scheduler\TaskBase.cs:line 176 at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx) at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx) at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state) at System.Threading.ThreadHelper.ThreadStart() 2026-01-12 23:30:01.4765 MoveToReorder Task executed successfully for ClientId : 286 Client Name:India Office QA, Slot: 1/13/2026 1:00:00 PM and Total Order Suggested: 1 Out Of: 1 2026-01-12 23:30:15.1797 DFramework.Scheduler.TaskBase /* Time Taken: 15656.3604*/ Opportunity Out Of Stock By Outlet 2026-01-12 23:45:00.2021 DFramework.Database.Query /* Time Taken: 587*/ [dbo].GenerateSystemAlerts 2026-01-12 23:45:15.3897 DFramework.Scheduler.TaskBase /* Time Taken: 15859.4939*/ Opportunity Out Of Stock By Outlet