2026-01-02 00:04:25.5873 AlertProcessor ProcessorAlertData: started 2026-01-02 00:04:30.7123 AlertProcessor ProcessorAlertData: Stopped 2026-01-02 00:05:44.3691 DFramework.Database.Query /* Time Taken: 593*/ 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-02 00:05:44.3691 DFramework.Database.Query /* Time Taken: 594*/ 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-02 00:05:44.3691 DFramework.Database.Query /* Time Taken: 595*/ 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-02 00:09:25.6051 AlertProcessor ProcessorAlertData: started 2026-01-02 00:09:30.9801 AlertProcessor ProcessorAlertData: Stopped 2026-01-02 00:14:19.9667 DFramework.Database.Query /* Time Taken: 1487*/ 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-02 00:14:25.6230 AlertProcessor ProcessorAlertData: started 2026-01-02 00:14:31.2168 AlertProcessor ProcessorAlertData: Stopped 2026-01-02 00:14:35.3730 DFramework.Scheduler.TaskBase /* Time Taken: 17015.7415*/ Opportunity Out Of Stock By Outlet 2026-01-02 00:19:25.6252 AlertProcessor ProcessorAlertData: started 2026-01-02 00:19:31.0315 AlertProcessor ProcessorAlertData: Stopped 2026-01-02 00:24:25.6430 AlertProcessor ProcessorAlertData: started 2026-01-02 00:24:31.2368 AlertProcessor ProcessorAlertData: Stopped 2026-01-02 00:29:18.8639 DFramework.Database.Query /* Time Taken: 506*/ [dbo].GenerateSystemAlerts 2026-01-02 00:29:25.6609 AlertProcessor ProcessorAlertData: started 2026-01-02 00:29:31.3015 AlertProcessor ProcessorAlertData: Stopped 2026-01-02 00:29:33.9578 DFramework.Scheduler.TaskBase /* Time Taken: 15593.8738*/ Opportunity Out Of Stock By Outlet 2026-01-02 00:34:20.2255 MoveToReorder Running task for ClientId : 286 and ClientName = India Office QA and Slot: 1/2/2026 2:00:00 PM And LastExecutedOn: 1/2/2026 1:04:19 PM 2026-01-02 00:34:25.6787 AlertProcessor ProcessorAlertData: started 2026-01-02 00:34:31.4444 AlertProcessor ProcessorAlertData: Stopped 2026-01-02 00:35:06.7102 DFramework.Database.NullableDataReader Data reader open for 46113 at System.Environment.GetStackTrace(Exception e, Boolean needFileInfo) at System.Environment.get_StackTrace() at DFramework.Database.NullableDataReader.Dispose(Boolean disposing) in D:\Spraxa\Framework\DFramework\Database\NullableDataReader.cs:line 33 at DFramework.Database.NullableDataReader.Dispose() in D:\Spraxa\Framework\DFramework\Database\NullableDataReader.cs:line 44 at CoolR.Tasks.MoveToReorder.Execute() in D:\Spraxa\CoolR-Group\portal\CoolR.Tasks\MoveToReorder.cs:line 44 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-02 00:35:06.7571 MoveToReorder Task executed successfully for ClientId : 286 Client Name:India Office QA, Slot: 1/2/2026 2:00:00 PM and Total Order Suggested: 126 Out Of: 126 2026-01-02 00:35:07.7415 DFramework.Scheduler.TaskBase /* Time Taken: 48000.3571*/ Move To Re-Order 2026-01-02 00:39:25.6965 AlertProcessor ProcessorAlertData: started 2026-01-02 00:39:31.2435 AlertProcessor ProcessorAlertData: Stopped 2026-01-02 00:44:18.8862 DFramework.Database.Query /* Time Taken: 507*/ [dbo].GenerateSystemAlerts 2026-01-02 00:44:25.7144 AlertProcessor ProcessorAlertData: started 2026-01-02 00:44:30.7926 AlertProcessor ProcessorAlertData: Stopped 2026-01-02 00:44:33.9644 DFramework.Scheduler.TaskBase /* Time Taken: 15578.2336*/ Opportunity Out Of Stock By Outlet 2026-01-02 00:49:25.7323 AlertProcessor ProcessorAlertData: started 2026-01-02 00:49:30.9198 AlertProcessor ProcessorAlertData: Stopped 2026-01-02 00:54:25.7501 AlertProcessor ProcessorAlertData: started 2026-01-02 00:54:27.0783 DFramework.Database.NullableDataReader Data reader open for 293 at System.Environment.GetStackTrace(Exception e, Boolean needFileInfo) at System.Environment.get_StackTrace() at DFramework.Database.NullableDataReader.Dispose(Boolean disposing) in D:\Spraxa\Framework\DFramework\Database\NullableDataReader.cs:line 33 at DFramework.Database.NullableDataReader.Dispose() in D:\Spraxa\Framework\DFramework\Database\NullableDataReader.cs:line 44 at CoolR.Tasks.ProcessAlertData.Execute() in D:\Spraxa\CoolR-Group\portal\CoolR.Tasks\ProcessAlertData.cs:line 47 at DFramework.Scheduler.TaskBase.Run() in 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-02 00:54:31.1252 AlertProcessor ProcessorAlertData: Stopped 2026-01-02 00:59:19.2836 DFramework.Database.Query /* Time Taken: 885*/ [dbo].GenerateSystemAlerts 2026-01-02 00:59:25.7524 AlertProcessor ProcessorAlertData: started 2026-01-02 00:59:30.9086 AlertProcessor ProcessorAlertData: Stopped 2026-01-02 00:59:33.9555 DFramework.Scheduler.TaskBase /* Time Taken: 15546.9857*/ Opportunity Out Of Stock By Outlet 2026-01-02 01:04:25.7702 AlertProcessor ProcessorAlertData: started 2026-01-02 01:04:30.8796 AlertProcessor ProcessorAlertData: Stopped 2026-01-02 01:09:25.7724 AlertProcessor ProcessorAlertData: started 2026-01-02 01:09:31.1162 AlertProcessor ProcessorAlertData: Stopped 2026-01-02 01:14:18.9355 DFramework.Database.Query /* Time Taken: 515*/ [dbo].GenerateSystemAlerts 2026-01-02 01:14:25.7793 AlertProcessor ProcessorAlertData: started 2026-01-02 01:14:31.0606 AlertProcessor ProcessorAlertData: Stopped 2026-01-02 01:14:34.0763 DFramework.Scheduler.TaskBase /* Time Taken: 15656.3874*/ Opportunity Out Of Stock By Outlet 2026-01-02 01:19:25.7972 AlertProcessor ProcessorAlertData: started 2026-01-02 01:19:31.3129 AlertProcessor ProcessorAlertData: Stopped 2026-01-02 01:24:25.8151 AlertProcessor ProcessorAlertData: started 2026-01-02 01:24:30.9870 AlertProcessor ProcessorAlertData: Stopped 2026-01-02 01:29:25.8173 AlertProcessor ProcessorAlertData: started 2026-01-02 01:29:31.3486 AlertProcessor ProcessorAlertData: Stopped 2026-01-02 01:29:33.9580 DFramework.Scheduler.TaskBase /* Time Taken: 15515.7397*/ Opportunity Out Of Stock By Outlet 2026-01-02 01:34:20.3038 MoveToReorder Running task for ClientId : 286 and ClientName = India Office QA and Slot: 1/2/2026 3:00:00 PM And LastExecutedOn: 1/2/2026 2:04:20 PM 2026-01-02 01:34:20.6007 MoveToReorder Task executed successfully for ClientId : 286 Client Name:India Office QA, Slot: 1/2/2026 3:00:00 PM But No Order found to suggest 2026-01-02 01:34:25.8351 AlertProcessor ProcessorAlertData: started 2026-01-02 01:34:28.9914 DFramework.Database.Query /* Time Taken: 553*/ DECLARE @TableName AnsiString(8000) SET @TableName = 'AssetStockProductWiseConsolidate' DECLARE @CurrentRecordId Int32 SET @CurrentRecordId = '3675469' dbo.GetValidDeviceForAlertProcessData 2026-01-02 01:34:31.5851 AlertProcessor ProcessorAlertData: Stopped 2026-01-02 01:39:25.8529 AlertProcessor ProcessorAlertData: started 2026-01-02 01:39:31.0717 AlertProcessor ProcessorAlertData: Stopped 2026-01-02 01:44:19.0582 DFramework.Database.Query /* Time Taken: 604*/ [dbo].GenerateSystemAlerts 2026-01-02 01:44:25.8708 AlertProcessor ProcessorAlertData: started 2026-01-02 01:44:31.0427 AlertProcessor ProcessorAlertData: Stopped 2026-01-02 01:44:33.9802 DFramework.Scheduler.TaskBase /* Time Taken: 15515.7447*/ Opportunity Out Of Stock By Outlet 2026-01-02 01:49:25.8886 AlertProcessor ProcessorAlertData: started 2026-01-02 01:49:31.0918 AlertProcessor ProcessorAlertData: Stopped 2026-01-02 01:54:25.9065 AlertProcessor ProcessorAlertData: started 2026-01-02 01:54:31.0003 AlertProcessor ProcessorAlertData: Stopped 2026-01-02 01:59:19.2524 DFramework.Database.Query /* Time Taken: 653*/ 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-02 01:59:25.9243 AlertProcessor ProcessorAlertData: started 2026-01-02 01:59:31.3931 AlertProcessor ProcessorAlertData: Stopped 2026-01-02 01:59:34.5338 DFramework.Scheduler.TaskBase /* Time Taken: 16047.011*/ Opportunity Out Of Stock By Outlet 2026-01-02 02:04:25.9421 AlertProcessor ProcessorAlertData: started 2026-01-02 02:04:26.4890 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 D:\Spraxa\Framework\DFramework\Database\NullableDataReader.cs:line 33 at DFramework.Database.NullableDataReader.Dispose() in D:\Spraxa\Framework\DFramework\Database\NullableDataReader.cs:line 44 at CoolR.Tasks.ProcessAlertData.Execute() in D:\Spraxa\CoolR-Group\portal\CoolR.Tasks\ProcessAlertData.cs:line 47 at DFramework.Scheduler.TaskBase.Run() in 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-02 02:04:27.1296 DFramework.Database.NullableDataReader Data reader open for 339 at System.Environment.GetStackTrace(Exception e, Boolean needFileInfo) at System.Environment.get_StackTrace() at DFramework.Database.NullableDataReader.Dispose(Boolean disposing) in D:\Spraxa\Framework\DFramework\Database\NullableDataReader.cs:line 33 at DFramework.Database.NullableDataReader.Dispose() in D:\Spraxa\Framework\DFramework\Database\NullableDataReader.cs:line 44 at CoolR.Tasks.ProcessAlertData.Execute() in D:\Spraxa\CoolR-Group\portal\CoolR.Tasks\ProcessAlertData.cs:line 47 at DFramework.Scheduler.TaskBase.Run() in 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-02 02:04:27.1765 DFramework.Database.NullableDataReader Data reader open for 424 at System.Environment.GetStackTrace(Exception e, Boolean needFileInfo) at System.Environment.get_StackTrace() at DFramework.Database.NullableDataReader.Dispose(Boolean disposing) in D:\Spraxa\Framework\DFramework\Database\NullableDataReader.cs:line 33 at DFramework.Database.NullableDataReader.Dispose() in D:\Spraxa\Framework\DFramework\Database\NullableDataReader.cs:line 44 at CoolR.Tasks.ProcessAlertData.Execute() in D:\Spraxa\CoolR-Group\portal\CoolR.Tasks\ProcessAlertData.cs:line 47 at DFramework.Scheduler.TaskBase.Run() in 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-02 02:04:28.8172 DFramework.Database.NullableDataReader Data reader open for 207 at System.Environment.GetStackTrace(Exception e, Boolean needFileInfo) at System.Environment.get_StackTrace() at DFramework.Database.NullableDataReader.Dispose(Boolean disposing) in D:\Spraxa\Framework\DFramework\Database\NullableDataReader.cs:line 33 at DFramework.Database.NullableDataReader.Dispose() in D:\Spraxa\Framework\DFramework\Database\NullableDataReader.cs:line 44 at CoolR.Tasks.ProcessAlertData.Execute() in D:\Spraxa\CoolR-Group\portal\CoolR.Tasks\ProcessAlertData.cs:line 47 at DFramework.Scheduler.TaskBase.Run() in 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-02 02:04:28.8640 DFramework.Database.NullableDataReader Data reader open for 289 at System.Environment.GetStackTrace(Exception e, Boolean needFileInfo) at System.Environment.get_StackTrace() at DFramework.Database.NullableDataReader.Dispose(Boolean disposing) in D:\Spraxa\Framework\DFramework\Database\NullableDataReader.cs:line 33 at DFramework.Database.NullableDataReader.Dispose() in D:\Spraxa\Framework\DFramework\Database\NullableDataReader.cs:line 44 at CoolR.Tasks.ProcessAlertData.Execute() in D:\Spraxa\CoolR-Group\portal\CoolR.Tasks\ProcessAlertData.cs:line 47 at DFramework.Scheduler.TaskBase.Run() in 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-02 02:04:29.4422 DFramework.Database.NullableDataReader Data reader open for 316 at System.Environment.GetStackTrace(Exception e, Boolean needFileInfo) at System.Environment.get_StackTrace() at DFramework.Database.NullableDataReader.Dispose(Boolean disposing) in D:\Spraxa\Framework\DFramework\Database\NullableDataReader.cs:line 33 at DFramework.Database.NullableDataReader.Dispose() in D:\Spraxa\Framework\DFramework\Database\NullableDataReader.cs:line 44 at CoolR.Tasks.ProcessAlertData.Execute() in D:\Spraxa\CoolR-Group\portal\CoolR.Tasks\ProcessAlertData.cs:line 47 at DFramework.Scheduler.TaskBase.Run() in 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-02 02:04:29.5047 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 D:\Spraxa\Framework\DFramework\Database\NullableDataReader.cs:line 33 at DFramework.Database.NullableDataReader.Dispose() in D:\Spraxa\Framework\DFramework\Database\NullableDataReader.cs:line 44 at CoolR.Tasks.ProcessAlertData.Execute() in D:\Spraxa\CoolR-Group\portal\CoolR.Tasks\ProcessAlertData.cs:line 47 at DFramework.Scheduler.TaskBase.Run() in 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-02 02:04:30.1609 DFramework.Database.NullableDataReader Data reader open for 391 at System.Environment.GetStackTrace(Exception e, Boolean needFileInfo) at System.Environment.get_StackTrace() at DFramework.Database.NullableDataReader.Dispose(Boolean disposing) in D:\Spraxa\Framework\DFramework\Database\NullableDataReader.cs:line 33 at DFramework.Database.NullableDataReader.Dispose() in D:\Spraxa\Framework\DFramework\Database\NullableDataReader.cs:line 44 at CoolR.Tasks.ProcessAlertData.Execute() in D:\Spraxa\CoolR-Group\portal\CoolR.Tasks\ProcessAlertData.cs:line 47 at DFramework.Scheduler.TaskBase.Run() in 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-02 02:04:30.2078 DFramework.Database.NullableDataReader Data reader open for 473 at System.Environment.GetStackTrace(Exception e, Boolean needFileInfo) at System.Environment.get_StackTrace() at DFramework.Database.NullableDataReader.Dispose(Boolean disposing) in D:\Spraxa\Framework\DFramework\Database\NullableDataReader.cs:line 33 at DFramework.Database.NullableDataReader.Dispose() in D:\Spraxa\Framework\DFramework\Database\NullableDataReader.cs:line 44 at CoolR.Tasks.ProcessAlertData.Execute() in D:\Spraxa\CoolR-Group\portal\CoolR.Tasks\ProcessAlertData.cs:line 47 at DFramework.Scheduler.TaskBase.Run() in 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-02 02:04:31.2078 DFramework.Database.NullableDataReader Data reader open for 236 at System.Environment.GetStackTrace(Exception e, Boolean needFileInfo) at System.Environment.get_StackTrace() at DFramework.Database.NullableDataReader.Dispose(Boolean disposing) in D:\Spraxa\Framework\DFramework\Database\NullableDataReader.cs:line 33 at DFramework.Database.NullableDataReader.Dispose() in D:\Spraxa\Framework\DFramework\Database\NullableDataReader.cs:line 44 at CoolR.Tasks.ProcessAlertData.Execute() in D:\Spraxa\CoolR-Group\portal\CoolR.Tasks\ProcessAlertData.cs:line 47 at DFramework.Scheduler.TaskBase.Run() in 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-02 02:04:31.5204 AlertProcessor Replace Tags updated for the Image Id: 3675504 2026-01-02 02:04:31.6766 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 D:\Spraxa\Framework\DFramework\Database\NullableDataReader.cs:line 33 at DFramework.Database.NullableDataReader.Dispose() in D:\Spraxa\Framework\DFramework\Database\NullableDataReader.cs:line 44 at CoolR.Tasks.ProcessAlertData.Execute() in D:\Spraxa\CoolR-Group\portal\CoolR.Tasks\ProcessAlertData.cs:line 47 at DFramework.Scheduler.TaskBase.Run() in 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-02 02:04:32.1922 DFramework.Database.NullableDataReader Data reader open for 255 at System.Environment.GetStackTrace(Exception e, Boolean needFileInfo) at System.Environment.get_StackTrace() at DFramework.Database.NullableDataReader.Dispose(Boolean disposing) in D:\Spraxa\Framework\DFramework\Database\NullableDataReader.cs:line 33 at DFramework.Database.NullableDataReader.Dispose() in D:\Spraxa\Framework\DFramework\Database\NullableDataReader.cs:line 44 at CoolR.Tasks.ProcessAlertData.Execute() in D:\Spraxa\CoolR-Group\portal\CoolR.Tasks\ProcessAlertData.cs:line 47 at DFramework.Scheduler.TaskBase.Run() in 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-02 02:04:32.2547 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 D:\Spraxa\Framework\DFramework\Database\NullableDataReader.cs:line 33 at DFramework.Database.NullableDataReader.Dispose() in D:\Spraxa\Framework\DFramework\Database\NullableDataReader.cs:line 44 at CoolR.Tasks.ProcessAlertData.Execute() in D:\Spraxa\CoolR-Group\portal\CoolR.Tasks\ProcessAlertData.cs:line 47 at DFramework.Scheduler.TaskBase.Run() in 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-02 02:04:33.0516 DFramework.Database.NullableDataReader Data reader open for 227 at System.Environment.GetStackTrace(Exception e, Boolean needFileInfo) at System.Environment.get_StackTrace() at DFramework.Database.NullableDataReader.Dispose(Boolean disposing) in D:\Spraxa\Framework\DFramework\Database\NullableDataReader.cs:line 33 at DFramework.Database.NullableDataReader.Dispose() in D:\Spraxa\Framework\DFramework\Database\NullableDataReader.cs:line 44 at CoolR.Tasks.ProcessAlertData.Execute() in D:\Spraxa\CoolR-Group\portal\CoolR.Tasks\ProcessAlertData.cs:line 47 at DFramework.Scheduler.TaskBase.Run() in 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-02 02:04:33.9110 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 D:\Spraxa\Framework\DFramework\Database\NullableDataReader.cs:line 33 at DFramework.Database.NullableDataReader.Dispose() in D:\Spraxa\Framework\DFramework\Database\NullableDataReader.cs:line 44 at CoolR.Tasks.ProcessAlertData.Execute() in D:\Spraxa\CoolR-Group\portal\CoolR.Tasks\ProcessAlertData.cs:line 47 at DFramework.Scheduler.TaskBase.Run() in 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-02 02:04:34.5828 AlertProcessor ProcessorAlertData: Stopped 2026-01-02 02:09:25.9444 AlertProcessor ProcessorAlertData: started 2026-01-02 02:09:26.4756 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 D:\Spraxa\Framework\DFramework\Database\NullableDataReader.cs:line 33 at DFramework.Database.NullableDataReader.Dispose() in D:\Spraxa\Framework\DFramework\Database\NullableDataReader.cs:line 44 at CoolR.Tasks.ProcessAlertData.Execute() in D:\Spraxa\CoolR-Group\portal\CoolR.Tasks\ProcessAlertData.cs:line 47 at DFramework.Scheduler.TaskBase.Run() in 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-02 02:09:27.0850 DFramework.Database.NullableDataReader Data reader open for 312 at System.Environment.GetStackTrace(Exception e, Boolean needFileInfo) at System.Environment.get_StackTrace() at DFramework.Database.NullableDataReader.Dispose(Boolean disposing) in D:\Spraxa\Framework\DFramework\Database\NullableDataReader.cs:line 33 at DFramework.Database.NullableDataReader.Dispose() in D:\Spraxa\Framework\DFramework\Database\NullableDataReader.cs:line 44 at CoolR.Tasks.ProcessAlertData.Execute() in D:\Spraxa\CoolR-Group\portal\CoolR.Tasks\ProcessAlertData.cs:line 47 at DFramework.Scheduler.TaskBase.Run() in 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-02 02:09:27.1475 DFramework.Database.NullableDataReader Data reader open for 396 at System.Environment.GetStackTrace(Exception e, Boolean needFileInfo) at System.Environment.get_StackTrace() at DFramework.Database.NullableDataReader.Dispose(Boolean disposing) in D:\Spraxa\Framework\DFramework\Database\NullableDataReader.cs:line 33 at DFramework.Database.NullableDataReader.Dispose() in D:\Spraxa\Framework\DFramework\Database\NullableDataReader.cs:line 44 at CoolR.Tasks.ProcessAlertData.Execute() in D:\Spraxa\CoolR-Group\portal\CoolR.Tasks\ProcessAlertData.cs:line 47 at DFramework.Scheduler.TaskBase.Run() in 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-02 02:09:28.7413 DFramework.Database.NullableDataReader Data reader open for 278 at System.Environment.GetStackTrace(Exception e, Boolean needFileInfo) at System.Environment.get_StackTrace() at DFramework.Database.NullableDataReader.Dispose(Boolean disposing) in D:\Spraxa\Framework\DFramework\Database\NullableDataReader.cs:line 33 at DFramework.Database.NullableDataReader.Dispose() in D:\Spraxa\Framework\DFramework\Database\NullableDataReader.cs:line 44 at CoolR.Tasks.ProcessAlertData.Execute() in D:\Spraxa\CoolR-Group\portal\CoolR.Tasks\ProcessAlertData.cs:line 47 at DFramework.Scheduler.TaskBase.Run() in 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-02 02:09:29.2569 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 D:\Spraxa\Framework\DFramework\Database\NullableDataReader.cs:line 33 at DFramework.Database.NullableDataReader.Dispose() in D:\Spraxa\Framework\DFramework\Database\NullableDataReader.cs:line 44 at CoolR.Tasks.ProcessAlertData.Execute() in D:\Spraxa\CoolR-Group\portal\CoolR.Tasks\ProcessAlertData.cs:line 47 at DFramework.Scheduler.TaskBase.Run() in 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-02 02:09:29.3194 DFramework.Database.NullableDataReader Data reader open for 309 at System.Environment.GetStackTrace(Exception e, Boolean needFileInfo) at System.Environment.get_StackTrace() at DFramework.Database.NullableDataReader.Dispose(Boolean disposing) in D:\Spraxa\Framework\DFramework\Database\NullableDataReader.cs:line 33 at DFramework.Database.NullableDataReader.Dispose() in D:\Spraxa\Framework\DFramework\Database\NullableDataReader.cs:line 44 at CoolR.Tasks.ProcessAlertData.Execute() in D:\Spraxa\CoolR-Group\portal\CoolR.Tasks\ProcessAlertData.cs:line 47 at DFramework.Scheduler.TaskBase.Run() in 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-02 02:09:29.9756 DFramework.Database.NullableDataReader Data reader open for 308 at System.Environment.GetStackTrace(Exception e, Boolean needFileInfo) at System.Environment.get_StackTrace() at DFramework.Database.NullableDataReader.Dispose(Boolean disposing) in D:\Spraxa\Framework\DFramework\Database\NullableDataReader.cs:line 33 at DFramework.Database.NullableDataReader.Dispose() in D:\Spraxa\Framework\DFramework\Database\NullableDataReader.cs:line 44 at CoolR.Tasks.ProcessAlertData.Execute() in D:\Spraxa\CoolR-Group\portal\CoolR.Tasks\ProcessAlertData.cs:line 47 at DFramework.Scheduler.TaskBase.Run() in 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-02 02:09:30.0381 DFramework.Database.NullableDataReader Data reader open for 392 at System.Environment.GetStackTrace(Exception e, Boolean needFileInfo) at System.Environment.get_StackTrace() at DFramework.Database.NullableDataReader.Dispose(Boolean disposing) in D:\Spraxa\Framework\DFramework\Database\NullableDataReader.cs:line 33 at DFramework.Database.NullableDataReader.Dispose() in D:\Spraxa\Framework\DFramework\Database\NullableDataReader.cs:line 44 at CoolR.Tasks.ProcessAlertData.Execute() in D:\Spraxa\CoolR-Group\portal\CoolR.Tasks\ProcessAlertData.cs:line 47 at DFramework.Scheduler.TaskBase.Run() in 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-02 02:09:31.0225 DFramework.Database.NullableDataReader Data reader open for 202 at System.Environment.GetStackTrace(Exception e, Boolean needFileInfo) at System.Environment.get_StackTrace() at DFramework.Database.NullableDataReader.Dispose(Boolean disposing) in D:\Spraxa\Framework\DFramework\Database\NullableDataReader.cs:line 33 at DFramework.Database.NullableDataReader.Dispose() in D:\Spraxa\Framework\DFramework\Database\NullableDataReader.cs:line 44 at CoolR.Tasks.ProcessAlertData.Execute() in D:\Spraxa\CoolR-Group\portal\CoolR.Tasks\ProcessAlertData.cs:line 47 at DFramework.Scheduler.TaskBase.Run() in 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-02 02:09:31.0694 DFramework.Database.NullableDataReader Data reader open for 285 at System.Environment.GetStackTrace(Exception e, Boolean needFileInfo) at System.Environment.get_StackTrace() at DFramework.Database.NullableDataReader.Dispose(Boolean disposing) in D:\Spraxa\Framework\DFramework\Database\NullableDataReader.cs:line 33 at DFramework.Database.NullableDataReader.Dispose() in D:\Spraxa\Framework\DFramework\Database\NullableDataReader.cs:line 44 at CoolR.Tasks.ProcessAlertData.Execute() in D:\Spraxa\CoolR-Group\portal\CoolR.Tasks\ProcessAlertData.cs:line 47 at DFramework.Scheduler.TaskBase.Run() in 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-02 02:09:31.3975 AlertProcessor Replace Tags updated for the Image Id: 3675506 2026-01-02 02:09:31.5382 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 D:\Spraxa\Framework\DFramework\Database\NullableDataReader.cs:line 33 at DFramework.Database.NullableDataReader.Dispose() in D:\Spraxa\Framework\DFramework\Database\NullableDataReader.cs:line 44 at CoolR.Tasks.ProcessAlertData.Execute() in D:\Spraxa\CoolR-Group\portal\CoolR.Tasks\ProcessAlertData.cs:line 47 at DFramework.Scheduler.TaskBase.Run() in 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-02 02:09:32.0694 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 D:\Spraxa\Framework\DFramework\Database\NullableDataReader.cs:line 33 at DFramework.Database.NullableDataReader.Dispose() in D:\Spraxa\Framework\DFramework\Database\NullableDataReader.cs:line 44 at CoolR.Tasks.ProcessAlertData.Execute() in D:\Spraxa\CoolR-Group\portal\CoolR.Tasks\ProcessAlertData.cs:line 47 at DFramework.Scheduler.TaskBase.Run() in 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-02 02:09:32.1163 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 D:\Spraxa\Framework\DFramework\Database\NullableDataReader.cs:line 33 at DFramework.Database.NullableDataReader.Dispose() in D:\Spraxa\Framework\DFramework\Database\NullableDataReader.cs:line 44 at CoolR.Tasks.ProcessAlertData.Execute() in D:\Spraxa\CoolR-Group\portal\CoolR.Tasks\ProcessAlertData.cs:line 47 at DFramework.Scheduler.TaskBase.Run() in 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-02 02:09:33.0069 DFramework.Database.NullableDataReader Data reader open for 281 at System.Environment.GetStackTrace(Exception e, Boolean needFileInfo) at System.Environment.get_StackTrace() at DFramework.Database.NullableDataReader.Dispose(Boolean disposing) in D:\Spraxa\Framework\DFramework\Database\NullableDataReader.cs:line 33 at DFramework.Database.NullableDataReader.Dispose() in D:\Spraxa\Framework\DFramework\Database\NullableDataReader.cs:line 44 at CoolR.Tasks.ProcessAlertData.Execute() in D:\Spraxa\CoolR-Group\portal\CoolR.Tasks\ProcessAlertData.cs:line 47 at DFramework.Scheduler.TaskBase.Run() in 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-02 02:09:33.0538 DFramework.Database.NullableDataReader Data reader open for 365 at System.Environment.GetStackTrace(Exception e, Boolean needFileInfo) at System.Environment.get_StackTrace() at DFramework.Database.NullableDataReader.Dispose(Boolean disposing) in D:\Spraxa\Framework\DFramework\Database\NullableDataReader.cs:line 33 at DFramework.Database.NullableDataReader.Dispose() in D:\Spraxa\Framework\DFramework\Database\NullableDataReader.cs:line 44 at CoolR.Tasks.ProcessAlertData.Execute() in D:\Spraxa\CoolR-Group\portal\CoolR.Tasks\ProcessAlertData.cs:line 47 at DFramework.Scheduler.TaskBase.Run() in 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-02 02:09:33.8975 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 D:\Spraxa\Framework\DFramework\Database\NullableDataReader.cs:line 33 at DFramework.Database.NullableDataReader.Dispose() in D:\Spraxa\Framework\DFramework\Database\NullableDataReader.cs:line 44 at CoolR.Tasks.ProcessAlertData.Execute() in D:\Spraxa\CoolR-Group\portal\CoolR.Tasks\ProcessAlertData.cs:line 47 at DFramework.Scheduler.TaskBase.Run() in 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-02 02:09:34.7257 DFramework.Database.NullableDataReader Data reader open for 392 at System.Environment.GetStackTrace(Exception e, Boolean needFileInfo) at System.Environment.get_StackTrace() at DFramework.Database.NullableDataReader.Dispose(Boolean disposing) in D:\Spraxa\Framework\DFramework\Database\NullableDataReader.cs:line 33 at DFramework.Database.NullableDataReader.Dispose() in D:\Spraxa\Framework\DFramework\Database\NullableDataReader.cs:line 44 at CoolR.Tasks.ProcessAlertData.Execute() in D:\Spraxa\CoolR-Group\portal\CoolR.Tasks\ProcessAlertData.cs:line 389 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-02 02:09:34.7882 AlertProcessor ProcessorAlertData: Stopped 2026-01-02 02:14:25.9622 AlertProcessor ProcessorAlertData: started 2026-01-02 02:14:31.4935 AlertProcessor ProcessorAlertData: Stopped 2026-01-02 02:14:34.0560 DFramework.Scheduler.TaskBase /* Time Taken: 15562.6148*/ Opportunity Out Of Stock By Outlet 2026-01-02 02:19:25.9801 AlertProcessor ProcessorAlertData: started 2026-01-02 02:19:31.4020 AlertProcessor ProcessorAlertData: Stopped 2026-01-02 02:24:25.9980 AlertProcessor ProcessorAlertData: started 2026-01-02 02:24:29.0292 DFramework.Database.Query /* Time Taken: 522*/ DECLARE @TableName AnsiString(8000) SET @TableName = 'AssetStockProductWiseConsolidate' DECLARE @CurrentRecordId Int32 SET @CurrentRecordId = '3675506' dbo.GetValidDeviceForAlertProcessData 2026-01-02 02:24:31.5917 AlertProcessor ProcessorAlertData: Stopped 2026-01-02 02:29:26.0158 AlertProcessor ProcessorAlertData: started 2026-01-02 02:29:31.4221 AlertProcessor ProcessorAlertData: Stopped 2026-01-02 02:29:34.1408 DFramework.Scheduler.TaskBase /* Time Taken: 15625.1145*/ Opportunity Out Of Stock By Outlet 2026-01-02 02:34:20.2680 MoveToReorder Running task for ClientId : 286 and ClientName = India Office QA and Slot: 1/2/2026 4:00:00 PM And LastExecutedOn: 1/2/2026 3:04:20 PM 2026-01-02 02:34:20.7211 MoveToReorder Task executed successfully for ClientId : 286 Client Name:India Office QA, Slot: 1/2/2026 4:00:00 PM and Total Order Suggested: 1 Out Of: 1 2026-01-02 02:34:26.0336 AlertProcessor ProcessorAlertData: started 2026-01-02 02:34:31.5337 AlertProcessor ProcessorAlertData: Stopped 2026-01-02 02:39:26.0359 AlertProcessor ProcessorAlertData: started 2026-01-02 02:39:31.2390 AlertProcessor ProcessorAlertData: Stopped 2026-01-02 02:44:26.0537 AlertProcessor ProcessorAlertData: started 2026-01-02 02:44:31.2569 AlertProcessor ProcessorAlertData: Stopped 2026-01-02 02:44:34.1631 DFramework.Scheduler.TaskBase /* Time Taken: 15625.1165*/ Opportunity Out Of Stock By Outlet 2026-01-02 02:49:26.0715 AlertProcessor ProcessorAlertData: started 2026-01-02 02:49:30.9934 AlertProcessor ProcessorAlertData: Stopped 2026-01-02 02:54:26.0894 AlertProcessor ProcessorAlertData: started 2026-01-02 02:54:30.9800 AlertProcessor ProcessorAlertData: Stopped 2026-01-02 02:59:26.0916 AlertProcessor ProcessorAlertData: started 2026-01-02 02:59:31.1229 AlertProcessor ProcessorAlertData: Stopped 2026-01-02 02:59:34.1385 DFramework.Scheduler.TaskBase /* Time Taken: 15578.2455*/ Opportunity Out Of Stock By Outlet 2026-01-02 03:04:26.1093 AlertProcessor ProcessorAlertData: started 2026-01-02 03:04:31.0625 AlertProcessor ProcessorAlertData: Stopped 2026-01-02 03:09:26.1271 AlertProcessor ProcessorAlertData: started 2026-01-02 03:09:31.1271 AlertProcessor ProcessorAlertData: Stopped 2026-01-02 03:14:19.0824 DFramework.Database.Query /* Time Taken: 509*/ [dbo].GenerateSystemAlerts 2026-01-02 03:14:26.1449 AlertProcessor ProcessorAlertData: started 2026-01-02 03:14:31.4262 AlertProcessor ProcessorAlertData: Stopped 2026-01-02 03:14:34.2231 DFramework.Scheduler.TaskBase /* Time Taken: 15640.7295*/ Opportunity Out Of Stock By Outlet 2026-01-02 03:19:26.1471 AlertProcessor ProcessorAlertData: started 2026-01-02 03:19:31.1471 AlertProcessor ProcessorAlertData: Stopped 2026-01-02 03:24:26.1649 AlertProcessor ProcessorAlertData: started 2026-01-02 03:24:31.4149 AlertProcessor ProcessorAlertData: Stopped 2026-01-02 03:29:20.5889 DFramework.Database.Query /* Time Taken: 1877*/ 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-02 03:29:26.1827 AlertProcessor ProcessorAlertData: started 2026-01-02 03:29:31.3078 AlertProcessor ProcessorAlertData: Stopped 2026-01-02 03:29:35.8547 DFramework.Scheduler.TaskBase /* Time Taken: 17250.1287*/ Opportunity Out Of Stock By Outlet 2026-01-02 03:34:20.3411 MoveToReorder Running task for ClientId : 286 and ClientName = India Office QA and Slot: 1/2/2026 5:00:00 PM And LastExecutedOn: 1/2/2026 4:04:20 PM 2026-01-02 03:34:26.2005 AlertProcessor ProcessorAlertData: started 2026-01-02 03:34:26.7162 DFramework.Database.NullableDataReader Data reader open for 235 at System.Environment.GetStackTrace(Exception e, Boolean needFileInfo) at System.Environment.get_StackTrace() at DFramework.Database.NullableDataReader.Dispose(Boolean disposing) in D:\Spraxa\Framework\DFramework\Database\NullableDataReader.cs:line 33 at DFramework.Database.NullableDataReader.Dispose() in D:\Spraxa\Framework\DFramework\Database\NullableDataReader.cs:line 44 at CoolR.Tasks.ProcessAlertData.Execute() in D:\Spraxa\CoolR-Group\portal\CoolR.Tasks\ProcessAlertData.cs:line 47 at DFramework.Scheduler.TaskBase.Run() in 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-02 03:34:27.3099 DFramework.Database.NullableDataReader Data reader open for 330 at System.Environment.GetStackTrace(Exception e, Boolean needFileInfo) at System.Environment.get_StackTrace() at DFramework.Database.NullableDataReader.Dispose(Boolean disposing) in D:\Spraxa\Framework\DFramework\Database\NullableDataReader.cs:line 33 at DFramework.Database.NullableDataReader.Dispose() in D:\Spraxa\Framework\DFramework\Database\NullableDataReader.cs:line 44 at CoolR.Tasks.ProcessAlertData.Execute() in D:\Spraxa\CoolR-Group\portal\CoolR.Tasks\ProcessAlertData.cs:line 47 at DFramework.Scheduler.TaskBase.Run() in 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-02 03:34:27.3568 DFramework.Database.NullableDataReader Data reader open for 416 at System.Environment.GetStackTrace(Exception e, Boolean needFileInfo) at System.Environment.get_StackTrace() at DFramework.Database.NullableDataReader.Dispose(Boolean disposing) in D:\Spraxa\Framework\DFramework\Database\NullableDataReader.cs:line 33 at DFramework.Database.NullableDataReader.Dispose() in D:\Spraxa\Framework\DFramework\Database\NullableDataReader.cs:line 44 at CoolR.Tasks.ProcessAlertData.Execute() in D:\Spraxa\CoolR-Group\portal\CoolR.Tasks\ProcessAlertData.cs:line 47 at DFramework.Scheduler.TaskBase.Run() in 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-02 03:34:28.8724 DFramework.Database.NullableDataReader Data reader open for 213 at System.Environment.GetStackTrace(Exception e, Boolean needFileInfo) at System.Environment.get_StackTrace() at DFramework.Database.NullableDataReader.Dispose(Boolean disposing) in D:\Spraxa\Framework\DFramework\Database\NullableDataReader.cs:line 33 at DFramework.Database.NullableDataReader.Dispose() in D:\Spraxa\Framework\DFramework\Database\NullableDataReader.cs:line 44 at CoolR.Tasks.ProcessAlertData.Execute() in D:\Spraxa\CoolR-Group\portal\CoolR.Tasks\ProcessAlertData.cs:line 47 at DFramework.Scheduler.TaskBase.Run() in 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-02 03:34:28.9193 DFramework.Database.NullableDataReader Data reader open for 339 at System.Environment.GetStackTrace(Exception e, Boolean needFileInfo) at System.Environment.get_StackTrace() at DFramework.Database.NullableDataReader.Dispose(Boolean disposing) in D:\Spraxa\Framework\DFramework\Database\NullableDataReader.cs:line 33 at DFramework.Database.NullableDataReader.Dispose() in D:\Spraxa\Framework\DFramework\Database\NullableDataReader.cs:line 44 at CoolR.Tasks.ProcessAlertData.Execute() in D:\Spraxa\CoolR-Group\portal\CoolR.Tasks\ProcessAlertData.cs:line 47 at DFramework.Scheduler.TaskBase.Run() in 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-02 03:34:29.4193 DFramework.Database.NullableDataReader Data reader open for 255 at System.Environment.GetStackTrace(Exception e, Boolean needFileInfo) at System.Environment.get_StackTrace() at DFramework.Database.NullableDataReader.Dispose(Boolean disposing) in D:\Spraxa\Framework\DFramework\Database\NullableDataReader.cs:line 33 at DFramework.Database.NullableDataReader.Dispose() in D:\Spraxa\Framework\DFramework\Database\NullableDataReader.cs:line 44 at CoolR.Tasks.ProcessAlertData.Execute() in D:\Spraxa\CoolR-Group\portal\CoolR.Tasks\ProcessAlertData.cs:line 47 at DFramework.Scheduler.TaskBase.Run() in 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-02 03:34:29.4818 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 D:\Spraxa\Framework\DFramework\Database\NullableDataReader.cs:line 33 at DFramework.Database.NullableDataReader.Dispose() in D:\Spraxa\Framework\DFramework\Database\NullableDataReader.cs:line 44 at CoolR.Tasks.ProcessAlertData.Execute() in D:\Spraxa\CoolR-Group\portal\CoolR.Tasks\ProcessAlertData.cs:line 47 at DFramework.Scheduler.TaskBase.Run() in 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-02 03:34:30.0131 DFramework.Database.NullableDataReader Data reader open for 294 at System.Environment.GetStackTrace(Exception e, Boolean needFileInfo) at System.Environment.get_StackTrace() at DFramework.Database.NullableDataReader.Dispose(Boolean disposing) in D:\Spraxa\Framework\DFramework\Database\NullableDataReader.cs:line 33 at DFramework.Database.NullableDataReader.Dispose() in D:\Spraxa\Framework\DFramework\Database\NullableDataReader.cs:line 44 at CoolR.Tasks.ProcessAlertData.Execute() in D:\Spraxa\CoolR-Group\portal\CoolR.Tasks\ProcessAlertData.cs:line 47 at DFramework.Scheduler.TaskBase.Run() in 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-02 03:34:30.0756 DFramework.Database.NullableDataReader Data reader open for 377 at System.Environment.GetStackTrace(Exception e, Boolean needFileInfo) at System.Environment.get_StackTrace() at DFramework.Database.NullableDataReader.Dispose(Boolean disposing) in D:\Spraxa\Framework\DFramework\Database\NullableDataReader.cs:line 33 at DFramework.Database.NullableDataReader.Dispose() in D:\Spraxa\Framework\DFramework\Database\NullableDataReader.cs:line 44 at CoolR.Tasks.ProcessAlertData.Execute() in D:\Spraxa\CoolR-Group\portal\CoolR.Tasks\ProcessAlertData.cs:line 47 at DFramework.Scheduler.TaskBase.Run() in 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-02 03:34:31.0287 DFramework.Database.NullableDataReader Data reader open for 227 at System.Environment.GetStackTrace(Exception e, Boolean needFileInfo) at System.Environment.get_StackTrace() at DFramework.Database.NullableDataReader.Dispose(Boolean disposing) in D:\Spraxa\Framework\DFramework\Database\NullableDataReader.cs:line 33 at DFramework.Database.NullableDataReader.Dispose() in D:\Spraxa\Framework\DFramework\Database\NullableDataReader.cs:line 44 at CoolR.Tasks.ProcessAlertData.Execute() in D:\Spraxa\CoolR-Group\portal\CoolR.Tasks\ProcessAlertData.cs:line 47 at DFramework.Scheduler.TaskBase.Run() in 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-02 03:34:31.0912 DFramework.Database.NullableDataReader Data reader open for 309 at System.Environment.GetStackTrace(Exception e, Boolean needFileInfo) at System.Environment.get_StackTrace() at DFramework.Database.NullableDataReader.Dispose(Boolean disposing) in D:\Spraxa\Framework\DFramework\Database\NullableDataReader.cs:line 33 at DFramework.Database.NullableDataReader.Dispose() in D:\Spraxa\Framework\DFramework\Database\NullableDataReader.cs:line 44 at CoolR.Tasks.ProcessAlertData.Execute() in D:\Spraxa\CoolR-Group\portal\CoolR.Tasks\ProcessAlertData.cs:line 47 at DFramework.Scheduler.TaskBase.Run() in 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-02 03:34:31.4037 AlertProcessor Replace Tags updated for the Image Id: 3675525 2026-01-02 03:34:31.5443 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 D:\Spraxa\Framework\DFramework\Database\NullableDataReader.cs:line 33 at DFramework.Database.NullableDataReader.Dispose() in D:\Spraxa\Framework\DFramework\Database\NullableDataReader.cs:line 44 at CoolR.Tasks.ProcessAlertData.Execute() in D:\Spraxa\CoolR-Group\portal\CoolR.Tasks\ProcessAlertData.cs:line 47 at DFramework.Scheduler.TaskBase.Run() in 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-02 03:34:31.6068 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 D:\Spraxa\Framework\DFramework\Database\NullableDataReader.cs:line 33 at DFramework.Database.NullableDataReader.Dispose() in D:\Spraxa\Framework\DFramework\Database\NullableDataReader.cs:line 44 at CoolR.Tasks.ProcessAlertData.Execute() in D:\Spraxa\CoolR-Group\portal\CoolR.Tasks\ProcessAlertData.cs:line 47 at DFramework.Scheduler.TaskBase.Run() in 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-02 03:34:32.1068 DFramework.Database.NullableDataReader Data reader open for 251 at System.Environment.GetStackTrace(Exception e, Boolean needFileInfo) at System.Environment.get_StackTrace() at DFramework.Database.NullableDataReader.Dispose(Boolean disposing) in D:\Spraxa\Framework\DFramework\Database\NullableDataReader.cs:line 33 at DFramework.Database.NullableDataReader.Dispose() in D:\Spraxa\Framework\DFramework\Database\NullableDataReader.cs:line 44 at CoolR.Tasks.ProcessAlertData.Execute() in D:\Spraxa\CoolR-Group\portal\CoolR.Tasks\ProcessAlertData.cs:line 47 at DFramework.Scheduler.TaskBase.Run() in 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-02 03:34:32.1537 DFramework.Database.NullableDataReader Data reader open for 333 at System.Environment.GetStackTrace(Exception e, Boolean needFileInfo) at System.Environment.get_StackTrace() at DFramework.Database.NullableDataReader.Dispose(Boolean disposing) in D:\Spraxa\Framework\DFramework\Database\NullableDataReader.cs:line 33 at DFramework.Database.NullableDataReader.Dispose() in D:\Spraxa\Framework\DFramework\Database\NullableDataReader.cs:line 44 at CoolR.Tasks.ProcessAlertData.Execute() in D:\Spraxa\CoolR-Group\portal\CoolR.Tasks\ProcessAlertData.cs:line 47 at DFramework.Scheduler.TaskBase.Run() in 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-02 03:34:32.9350 DFramework.Database.NullableDataReader Data reader open for 276 at System.Environment.GetStackTrace(Exception e, Boolean needFileInfo) at System.Environment.get_StackTrace() at DFramework.Database.NullableDataReader.Dispose(Boolean disposing) in D:\Spraxa\Framework\DFramework\Database\NullableDataReader.cs:line 33 at DFramework.Database.NullableDataReader.Dispose() in D:\Spraxa\Framework\DFramework\Database\NullableDataReader.cs:line 44 at CoolR.Tasks.ProcessAlertData.Execute() in D:\Spraxa\CoolR-Group\portal\CoolR.Tasks\ProcessAlertData.cs:line 47 at DFramework.Scheduler.TaskBase.Run() in 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-02 03:34:33.7631 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 D:\Spraxa\Framework\DFramework\Database\NullableDataReader.cs:line 33 at DFramework.Database.NullableDataReader.Dispose() in D:\Spraxa\Framework\DFramework\Database\NullableDataReader.cs:line 44 at CoolR.Tasks.ProcessAlertData.Execute() in D:\Spraxa\CoolR-Group\portal\CoolR.Tasks\ProcessAlertData.cs:line 47 at DFramework.Scheduler.TaskBase.Run() in 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-02 03:34:33.8100 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 D:\Spraxa\Framework\DFramework\Database\NullableDataReader.cs:line 33 at DFramework.Database.NullableDataReader.Dispose() in D:\Spraxa\Framework\DFramework\Database\NullableDataReader.cs:line 44 at CoolR.Tasks.ProcessAlertData.Execute() in D:\Spraxa\CoolR-Group\portal\CoolR.Tasks\ProcessAlertData.cs:line 47 at DFramework.Scheduler.TaskBase.Run() in 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-02 03:34:34.7006 DFramework.Database.NullableDataReader Data reader open for 477 at System.Environment.GetStackTrace(Exception e, Boolean needFileInfo) at System.Environment.get_StackTrace() at DFramework.Database.NullableDataReader.Dispose(Boolean disposing) in D:\Spraxa\Framework\DFramework\Database\NullableDataReader.cs:line 33 at DFramework.Database.NullableDataReader.Dispose() in D:\Spraxa\Framework\DFramework\Database\NullableDataReader.cs:line 44 at CoolR.Tasks.ProcessAlertData.Execute() in D:\Spraxa\CoolR-Group\portal\CoolR.Tasks\ProcessAlertData.cs:line 47 at DFramework.Scheduler.TaskBase.Run() in 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-02 03:34:34.7631 DFramework.Database.NullableDataReader Data reader open for 561 at System.Environment.GetStackTrace(Exception e, Boolean needFileInfo) at System.Environment.get_StackTrace() at DFramework.Database.NullableDataReader.Dispose(Boolean disposing) in D:\Spraxa\Framework\DFramework\Database\NullableDataReader.cs:line 33 at DFramework.Database.NullableDataReader.Dispose() in D:\Spraxa\Framework\DFramework\Database\NullableDataReader.cs:line 44 at CoolR.Tasks.ProcessAlertData.Execute() in D:\Spraxa\CoolR-Group\portal\CoolR.Tasks\ProcessAlertData.cs:line 47 at DFramework.Scheduler.TaskBase.Run() in 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-02 03:34:34.7944 AlertProcessor ProcessorAlertData: Stopped 2026-01-02 03:34:59.3414 DFramework.Database.NullableDataReader Data reader open for 38733 at System.Environment.GetStackTrace(Exception e, Boolean needFileInfo) at System.Environment.get_StackTrace() at DFramework.Database.NullableDataReader.Dispose(Boolean disposing) in D:\Spraxa\Framework\DFramework\Database\NullableDataReader.cs:line 33 at DFramework.Database.NullableDataReader.Dispose() in D:\Spraxa\Framework\DFramework\Database\NullableDataReader.cs:line 44 at CoolR.Tasks.MoveToReorder.Execute() in D:\Spraxa\CoolR-Group\portal\CoolR.Tasks\MoveToReorder.cs:line 44 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-02 03:34:59.3727 MoveToReorder Task executed successfully for ClientId : 286 Client Name:India Office QA, Slot: 1/2/2026 5:00:00 PM and Total Order Suggested: 126 Out Of: 126 2026-01-02 03:35:00.4508 DFramework.Scheduler.TaskBase /* Time Taken: 40406.5493*/ Move To Re-Order 2026-01-02 03:39:26.2027 AlertProcessor ProcessorAlertData: started 2026-01-02 03:39:31.2653 AlertProcessor ProcessorAlertData: Stopped 2026-01-02 03:44:26.2206 AlertProcessor ProcessorAlertData: started 2026-01-02 03:44:31.1894 AlertProcessor ProcessorAlertData: Stopped 2026-01-02 03:44:34.1894 DFramework.Scheduler.TaskBase /* Time Taken: 15562.6175*/ Opportunity Out Of Stock By Outlet 2026-01-02 03:49:26.2384 AlertProcessor ProcessorAlertData: started 2026-01-02 03:49:31.2541 AlertProcessor ProcessorAlertData: Stopped 2026-01-02 03:54:26.2562 AlertProcessor ProcessorAlertData: started 2026-01-02 03:54:27.0999 DFramework.Database.NullableDataReader Data reader open for 273 at System.Environment.GetStackTrace(Exception e, Boolean needFileInfo) at System.Environment.get_StackTrace() at DFramework.Database.NullableDataReader.Dispose(Boolean disposing) in D:\Spraxa\Framework\DFramework\Database\NullableDataReader.cs:line 33 at DFramework.Database.NullableDataReader.Dispose() in D:\Spraxa\Framework\DFramework\Database\NullableDataReader.cs:line 44 at CoolR.Tasks.ProcessAlertData.Execute() in D:\Spraxa\CoolR-Group\portal\CoolR.Tasks\ProcessAlertData.cs:line 47 at DFramework.Scheduler.TaskBase.Run() in 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-02 03:54:31.4594 AlertProcessor ProcessorAlertData: Stopped 2026-01-02 03:59:26.2740 AlertProcessor ProcessorAlertData: started 2026-01-02 03:59:31.3834 AlertProcessor ProcessorAlertData: Stopped 2026-01-02 03:59:34.2740 DFramework.Scheduler.TaskBase /* Time Taken: 15625.142*/ Opportunity Out Of Stock By Outlet 2026-01-02 04:04:26.2918 AlertProcessor ProcessorAlertData: started 2026-01-02 04:04:31.3387 AlertProcessor ProcessorAlertData: Stopped 2026-01-02 04:09:26.2940 AlertProcessor ProcessorAlertData: started 2026-01-02 04:09:31.3097 AlertProcessor ProcessorAlertData: Stopped 2026-01-02 04:14:26.2960 AlertProcessor ProcessorAlertData: started 2026-01-02 04:14:31.2492 AlertProcessor ProcessorAlertData: Stopped 2026-01-02 04:14:34.2492 DFramework.Scheduler.TaskBase /* Time Taken: 15578.2387*/ Opportunity Out Of Stock By Outlet 2026-01-02 04:19:26.3139 AlertProcessor ProcessorAlertData: started 2026-01-02 04:19:31.2826 AlertProcessor ProcessorAlertData: Stopped 2026-01-02 04:24:26.3161 AlertProcessor ProcessorAlertData: started 2026-01-02 04:24:31.3005 AlertProcessor ProcessorAlertData: Stopped 2026-01-02 04:29:26.3337 AlertProcessor ProcessorAlertData: started 2026-01-02 04:29:31.3025 AlertProcessor ProcessorAlertData: Stopped 2026-01-02 04:29:34.2244 DFramework.Scheduler.TaskBase /* Time Taken: 15546.9794*/ Opportunity Out Of Stock By Outlet 2026-01-02 04:34:20.4607 MoveToReorder Running task for ClientId : 286 and ClientName = India Office QA and Slot: 1/2/2026 6:00:00 PM And LastExecutedOn: 1/2/2026 5:04:20 PM 2026-01-02 04:34:20.6795 MoveToReorder Task executed successfully for ClientId : 286 Client Name:India Office QA, Slot: 1/2/2026 6:00:00 PM But No Order found to suggest 2026-01-02 04:34:26.3514 AlertProcessor ProcessorAlertData: started 2026-01-02 04:34:31.3358 AlertProcessor ProcessorAlertData: Stopped 2026-01-02 04:39:26.3692 AlertProcessor ProcessorAlertData: started 2026-01-02 04:39:31.4474 AlertProcessor ProcessorAlertData: Stopped 2026-01-02 04:44:26.3870 AlertProcessor ProcessorAlertData: started 2026-01-02 04:44:31.4183 AlertProcessor ProcessorAlertData: Stopped 2026-01-02 04:44:34.2621 DFramework.Scheduler.TaskBase /* Time Taken: 15562.6139*/ Opportunity Out Of Stock By Outlet 2026-01-02 04:49:26.4049 AlertProcessor ProcessorAlertData: started 2026-01-02 04:49:31.3580 AlertProcessor ProcessorAlertData: Stopped 2026-01-02 04:54:26.4227 AlertProcessor ProcessorAlertData: started 2026-01-02 04:54:31.4071 AlertProcessor ProcessorAlertData: Stopped 2026-01-02 04:59:26.4406 AlertProcessor ProcessorAlertData: started 2026-01-02 04:59:31.3937 AlertProcessor ProcessorAlertData: Stopped 2026-01-02 04:59:34.2844 DFramework.Scheduler.TaskBase /* Time Taken: 15562.6103*/ Opportunity Out Of Stock By Outlet 2026-01-02 05:04:26.4583 AlertProcessor ProcessorAlertData: started 2026-01-02 05:04:31.4115 AlertProcessor ProcessorAlertData: Stopped 2026-01-02 05:09:26.4762 AlertProcessor ProcessorAlertData: started 2026-01-02 05:09:31.5231 AlertProcessor ProcessorAlertData: Stopped 2026-01-02 05:14:26.4784 AlertProcessor ProcessorAlertData: started 2026-01-02 05:14:31.4316 AlertProcessor ProcessorAlertData: Stopped 2026-01-02 05:14:34.2441 DFramework.Scheduler.TaskBase /* Time Taken: 15515.7294*/ Opportunity Out Of Stock By Outlet 2026-01-02 05:19:26.4962 AlertProcessor ProcessorAlertData: started 2026-01-02 05:19:31.5900 AlertProcessor ProcessorAlertData: Stopped 2026-01-02 05:24:26.5140 AlertProcessor ProcessorAlertData: started 2026-01-02 05:24:31.4984 AlertProcessor ProcessorAlertData: Stopped 2026-01-02 05:29:26.5319 AlertProcessor ProcessorAlertData: started 2026-01-02 05:29:31.5475 AlertProcessor ProcessorAlertData: Stopped 2026-01-02 05:29:34.3600 DFramework.Scheduler.TaskBase /* Time Taken: 15609.4933*/ Opportunity Out Of Stock By Outlet 2026-01-02 05:34:20.5497 MoveToReorder Running task for ClientId : 286 and ClientName = India Office QA and Slot: 1/2/2026 7:00:00 PM And LastExecutedOn: 1/2/2026 6:04:20 PM 2026-01-02 05:34:20.7528 MoveToReorder Task executed successfully for ClientId : 286 Client Name:India Office QA, Slot: 1/2/2026 7:00:00 PM But No Order found to suggest 2026-01-02 05:34:26.5497 AlertProcessor ProcessorAlertData: started 2026-01-02 05:34:31.5654 AlertProcessor ProcessorAlertData: Stopped 2026-01-02 05:39:26.5674 AlertProcessor ProcessorAlertData: started 2026-01-02 05:39:31.5987 AlertProcessor ProcessorAlertData: Stopped 2026-01-02 05:44:26.5853 AlertProcessor ProcessorAlertData: started 2026-01-02 05:44:31.5384 AlertProcessor ProcessorAlertData: Stopped 2026-01-02 05:44:34.3509 DFramework.Scheduler.TaskBase /* Time Taken: 15593.8622*/ Opportunity Out Of Stock By Outlet 2026-01-02 05:49:26.6031 AlertProcessor ProcessorAlertData: started 2026-01-02 05:49:31.5250 AlertProcessor ProcessorAlertData: Stopped 2026-01-02 05:54:26.6209 AlertProcessor ProcessorAlertData: started 2026-01-02 05:54:31.5584 AlertProcessor ProcessorAlertData: Stopped 2026-01-02 05:59:26.6387 AlertProcessor ProcessorAlertData: started 2026-01-02 05:59:31.6075 AlertProcessor ProcessorAlertData: Stopped 2026-01-02 05:59:34.3262 DFramework.Scheduler.TaskBase /* Time Taken: 15546.9893*/ Opportunity Out Of Stock By Outlet 2026-01-02 06:04:26.6565 AlertProcessor ProcessorAlertData: started 2026-01-02 06:04:28.5940 DFramework.Database.NullableDataReader Data reader open for 269 at System.Environment.GetStackTrace(Exception e, Boolean needFileInfo) at System.Environment.get_StackTrace() at DFramework.Database.NullableDataReader.Dispose(Boolean disposing) in D:\Spraxa\Framework\DFramework\Database\NullableDataReader.cs:line 33 at DFramework.Database.NullableDataReader.Dispose() in D:\Spraxa\Framework\DFramework\Database\NullableDataReader.cs:line 44 at CoolR.Tasks.ProcessAlertData.Execute() in D:\Spraxa\CoolR-Group\portal\CoolR.Tasks\ProcessAlertData.cs:line 47 at DFramework.Scheduler.TaskBase.Run() in 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-02 06:04:31.7972 AlertProcessor ProcessorAlertData: Stopped 2026-01-02 06:09:26.6743 AlertProcessor ProcessorAlertData: started 2026-01-02 06:09:31.6588 AlertProcessor ProcessorAlertData: Stopped 2026-01-02 06:14:26.6921 AlertProcessor ProcessorAlertData: started 2026-01-02 06:14:31.6297 AlertProcessor ProcessorAlertData: Stopped 2026-01-02 06:14:34.3484 DFramework.Scheduler.TaskBase /* Time Taken: 15546.9759*/ Opportunity Out Of Stock By Outlet 2026-01-02 06:19:26.7100 AlertProcessor ProcessorAlertData: started 2026-01-02 06:19:31.7413 AlertProcessor ProcessorAlertData: Stopped 2026-01-02 06:24:26.7278 AlertProcessor ProcessorAlertData: started 2026-01-02 06:24:31.6966 AlertProcessor ProcessorAlertData: Stopped 2026-01-02 06:29:26.7297 AlertProcessor ProcessorAlertData: started 2026-01-02 06:29:31.7454 AlertProcessor ProcessorAlertData: Stopped 2026-01-02 06:29:34.4017 DFramework.Scheduler.TaskBase /* Time Taken: 15578.23*/ Opportunity Out Of Stock By Outlet 2026-01-02 06:34:20.6693 MoveToReorder Running task for ClientId : 286 and ClientName = India Office QA and Slot: 1/2/2026 8:00:00 PM And LastExecutedOn: 1/2/2026 7:04:20 PM 2026-01-02 06:34:26.7318 AlertProcessor ProcessorAlertData: started 2026-01-02 06:34:31.8256 AlertProcessor ProcessorAlertData: Stopped 2026-01-02 06:35:00.9352 DFramework.Database.NullableDataReader Data reader open for 39955 at System.Environment.GetStackTrace(Exception e, Boolean needFileInfo) at System.Environment.get_StackTrace() at DFramework.Database.NullableDataReader.Dispose(Boolean disposing) in D:\Spraxa\Framework\DFramework\Database\NullableDataReader.cs:line 33 at DFramework.Database.NullableDataReader.Dispose() in D:\Spraxa\Framework\DFramework\Database\NullableDataReader.cs:line 44 at CoolR.Tasks.MoveToReorder.Execute() in D:\Spraxa\CoolR-Group\portal\CoolR.Tasks\MoveToReorder.cs:line 44 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-02 06:35:00.9665 MoveToReorder Task executed successfully for ClientId : 286 Client Name:India Office QA, Slot: 1/2/2026 8:00:00 PM and Total Order Suggested: 126 Out Of: 126 2026-01-02 06:35:02.0446 DFramework.Scheduler.TaskBase /* Time Taken: 41687.7902*/ Move To Re-Order 2026-01-02 06:39:26.7340 AlertProcessor ProcessorAlertData: started 2026-01-02 06:39:31.7184 AlertProcessor ProcessorAlertData: Stopped 2026-01-02 06:44:19.4704 DFramework.Database.Query /* Time Taken: 624*/ [dbo].GenerateSystemAlerts 2026-01-02 06:44:26.7517 AlertProcessor ProcessorAlertData: started 2026-01-02 06:44:31.7830 AlertProcessor ProcessorAlertData: Stopped 2026-01-02 06:44:34.6112 DFramework.Scheduler.TaskBase /* Time Taken: 15765.7309*/ Opportunity Out Of Stock By Outlet 2026-01-02 06:49:26.7695 AlertProcessor ProcessorAlertData: started 2026-01-02 06:49:31.7070 AlertProcessor ProcessorAlertData: Stopped 2026-01-02 06:54:26.7873 AlertProcessor ProcessorAlertData: started 2026-01-02 06:54:31.7717 AlertProcessor ProcessorAlertData: Stopped 2026-01-02 06:59:19.5706 DFramework.Database.Query /* Time Taken: 702*/ [dbo].GenerateSystemAlerts 2026-01-02 06:59:26.8051 AlertProcessor ProcessorAlertData: started 2026-01-02 06:59:31.9614 AlertProcessor ProcessorAlertData: Stopped 2026-01-02 06:59:34.6489 DFramework.Scheduler.TaskBase /* Time Taken: 15781.3739*/ Opportunity Out Of Stock By Outlet 2026-01-02 07:04:26.8229 AlertProcessor ProcessorAlertData: started 2026-01-02 07:04:31.8542 AlertProcessor ProcessorAlertData: Stopped 2026-01-02 07:09:26.8407 AlertProcessor ProcessorAlertData: started 2026-01-02 07:09:31.9970 AlertProcessor ProcessorAlertData: Stopped 2026-01-02 07:14:26.8585 AlertProcessor ProcessorAlertData: started 2026-01-02 07:14:31.8898 AlertProcessor ProcessorAlertData: Stopped 2026-01-02 07:14:34.4680 DFramework.Scheduler.TaskBase /* Time Taken: 15578.2516*/ Opportunity Out Of Stock By Outlet 2026-01-02 07:19:26.8763 AlertProcessor ProcessorAlertData: started 2026-01-02 07:19:31.8608 AlertProcessor ProcessorAlertData: Stopped 2026-01-02 07:24:26.8942 AlertProcessor ProcessorAlertData: started 2026-01-02 07:24:31.7848 AlertProcessor ProcessorAlertData: Stopped 2026-01-02 07:29:26.9120 AlertProcessor ProcessorAlertData: started 2026-01-02 07:29:31.8495 AlertProcessor ProcessorAlertData: Stopped 2026-01-02 07:29:34.5058 DFramework.Scheduler.TaskBase /* Time Taken: 15593.8666*/ Opportunity Out Of Stock By Outlet 2026-01-02 07:34:20.7736 MoveToReorder Running task for ClientId : 286 and ClientName = India Office QA and Slot: 1/2/2026 9:00:00 PM And LastExecutedOn: 1/2/2026 8:04:20 PM 2026-01-02 07:34:21.4612 DFramework.Database.Query /* Time Taken: 630*/ DECLARE @OrderStatusId Int32 SET @OrderStatusId = '0' DECLARE @ClientId Int32 SET @ClientId = '286' dbo.GetOrderDetailsByClientId 2026-01-02 07:34:21.4924 MoveToReorder Task executed successfully for ClientId : 286 Client Name:India Office QA, Slot: 1/2/2026 9:00:00 PM But No Order found to suggest 2026-01-02 07:34:26.9300 AlertProcessor ProcessorAlertData: started 2026-01-02 07:34:31.9769 AlertProcessor ProcessorAlertData: Stopped 2026-01-02 07:39:26.9490 AlertProcessor ProcessorAlertData: started 2026-01-02 07:39:31.8240 AlertProcessor ProcessorAlertData: Stopped 2026-01-02 07:44:26.9672 AlertProcessor ProcessorAlertData: started 2026-01-02 07:44:31.8735 AlertProcessor ProcessorAlertData: Stopped 2026-01-02 07:44:34.5297 DFramework.Scheduler.TaskBase /* Time Taken: 15593.8841*/ Opportunity Out Of Stock By Outlet 2026-01-02 07:49:26.9851 AlertProcessor ProcessorAlertData: started 2026-01-02 07:49:30.8914 DFramework.Database.NullableDataReader Data reader open for 269 at System.Environment.GetStackTrace(Exception e, Boolean needFileInfo) at System.Environment.get_StackTrace() at DFramework.Database.NullableDataReader.Dispose(Boolean disposing) in D:\Spraxa\Framework\DFramework\Database\NullableDataReader.cs:line 33 at DFramework.Database.NullableDataReader.Dispose() in D:\Spraxa\Framework\DFramework\Database\NullableDataReader.cs:line 44 at CoolR.Tasks.ProcessAlertData.Execute() in D:\Spraxa\CoolR-Group\portal\CoolR.Tasks\ProcessAlertData.cs:line 47 at DFramework.Scheduler.TaskBase.Run() in 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-02 07:49:32.1258 AlertProcessor ProcessorAlertData: Stopped 2026-01-02 07:54:27.0018 AlertProcessor ProcessorAlertData: started 2026-01-02 07:54:32.5487 AlertProcessor ProcessorAlertData: Stopped 2026-01-02 07:59:27.0190 AlertProcessor ProcessorAlertData: started 2026-01-02 07:59:32.0660 AlertProcessor ProcessorAlertData: Stopped 2026-01-02 07:59:34.5191 DFramework.Scheduler.TaskBase /* Time Taken: 15562.5993*/ Opportunity Out Of Stock By Outlet 2026-01-02 08:04:27.0367 AlertProcessor ProcessorAlertData: started 2026-01-02 08:04:32.0055 AlertProcessor ProcessorAlertData: Stopped 2026-01-02 08:09:27.0545 AlertProcessor ProcessorAlertData: started 2026-01-02 08:09:32.0702 AlertProcessor ProcessorAlertData: Stopped 2026-01-02 08:14:27.0567 AlertProcessor ProcessorAlertData: started 2026-01-02 08:14:32.1661 AlertProcessor ProcessorAlertData: Stopped 2026-01-02 08:14:34.6192 DFramework.Scheduler.TaskBase /* Time Taken: 15640.7422*/ Opportunity Out Of Stock By Outlet 2026-01-02 08:19:27.0589 AlertProcessor ProcessorAlertData: started 2026-01-02 08:19:32.0746 AlertProcessor ProcessorAlertData: Stopped 2026-01-02 08:24:27.0767 AlertProcessor ProcessorAlertData: started 2026-01-02 08:24:32.1861 AlertProcessor ProcessorAlertData: Stopped 2026-01-02 08:29:27.0790 AlertProcessor ProcessorAlertData: started 2026-01-02 08:29:32.0790 AlertProcessor ProcessorAlertData: Stopped 2026-01-02 08:29:34.5321 DFramework.Scheduler.TaskBase /* Time Taken: 15531.364*/ Opportunity Out Of Stock By Outlet 2026-01-02 08:34:20.8936 MoveToReorder Running task for ClientId : 286 and ClientName = India Office QA and Slot: 1/2/2026 10:00:00 PM And LastExecutedOn: 1/2/2026 9:04:20 PM 2026-01-02 08:34:21.1124 MoveToReorder Task executed successfully for ClientId : 286 Client Name:India Office QA, Slot: 1/2/2026 10:00:00 PM But No Order found to suggest 2026-01-02 08:34:27.0968 AlertProcessor ProcessorAlertData: started 2026-01-02 08:34:32.5499 AlertProcessor ProcessorAlertData: Stopped 2026-01-02 08:39:27.1146 AlertProcessor ProcessorAlertData: started 2026-01-02 08:39:32.5834 AlertProcessor ProcessorAlertData: Stopped 2026-01-02 08:44:19.5387 DFramework.Database.Query /* Time Taken: 542*/ [dbo].GenerateSystemAlerts 2026-01-02 08:44:27.1325 AlertProcessor ProcessorAlertData: started 2026-01-02 08:44:32.3982 AlertProcessor ProcessorAlertData: Stopped 2026-01-02 08:44:34.6482 DFramework.Scheduler.TaskBase /* Time Taken: 15640.7478*/ Opportunity Out Of Stock By Outlet 2026-01-02 08:49:27.1504 AlertProcessor ProcessorAlertData: started 2026-01-02 08:49:32.5723 AlertProcessor ProcessorAlertData: Stopped 2026-01-02 08:54:27.1683 AlertProcessor ProcessorAlertData: started 2026-01-02 08:54:32.6683 AlertProcessor ProcessorAlertData: Stopped 2026-01-02 08:59:19.5610 DFramework.Database.Query /* Time Taken: 533*/ [dbo].GenerateSystemAlerts 2026-01-02 08:59:27.1705 AlertProcessor ProcessorAlertData: started 2026-01-02 08:59:32.5611 AlertProcessor ProcessorAlertData: Stopped 2026-01-02 08:59:34.6393 DFramework.Scheduler.TaskBase /* Time Taken: 15609.538*/ Opportunity Out Of Stock By Outlet 2026-01-02 09:04:27.1884 AlertProcessor ProcessorAlertData: started 2026-01-02 09:04:32.6728 AlertProcessor ProcessorAlertData: Stopped 2026-01-02 09:09:27.2063 AlertProcessor ProcessorAlertData: started 2026-01-02 09:09:32.6594 AlertProcessor ProcessorAlertData: Stopped 2026-01-02 09:14:19.6615 DFramework.Database.Query /* Time Taken: 611*/ [dbo].GenerateSystemAlerts 2026-01-02 09:14:27.2084 AlertProcessor ProcessorAlertData: started 2026-01-02 09:14:32.6772 AlertProcessor ProcessorAlertData: Stopped 2026-01-02 09:14:34.7241 DFramework.Scheduler.TaskBase /* Time Taken: 15671.9891*/ Opportunity Out Of Stock By Outlet 2026-01-02 09:19:27.2263 AlertProcessor ProcessorAlertData: started 2026-01-02 09:19:32.6639 AlertProcessor ProcessorAlertData: Stopped 2026-01-02 09:24:27.2441 AlertProcessor ProcessorAlertData: started 2026-01-02 09:24:32.6973 AlertProcessor ProcessorAlertData: Stopped 2026-01-02 09:29:27.2619 AlertProcessor ProcessorAlertData: started 2026-01-02 09:29:32.7932 AlertProcessor ProcessorAlertData: Stopped 2026-01-02 09:29:34.6214 DFramework.Scheduler.TaskBase /* Time Taken: 15562.6147*/ Opportunity Out Of Stock By Outlet 2026-01-02 09:34:27.2798 AlertProcessor ProcessorAlertData: started 2026-01-02 09:34:32.7799 AlertProcessor ProcessorAlertData: Stopped 2026-01-02 09:39:27.2978 AlertProcessor ProcessorAlertData: started 2026-01-02 09:39:32.8447 AlertProcessor ProcessorAlertData: Stopped 2026-01-02 09:44:19.6125 DFramework.Database.Query /* Time Taken: 548*/ [dbo].GenerateSystemAlerts 2026-01-02 09:44:27.3157 AlertProcessor ProcessorAlertData: started 2026-01-02 09:44:32.7376 AlertProcessor ProcessorAlertData: Stopped 2026-01-02 09:44:34.6595 DFramework.Scheduler.TaskBase /* Time Taken: 15593.8895*/ Opportunity Out Of Stock By Outlet 2026-01-02 09:49:27.3335 AlertProcessor ProcessorAlertData: started 2026-01-02 09:49:32.7242 AlertProcessor ProcessorAlertData: Stopped 2026-01-02 09:54:27.3514 AlertProcessor ProcessorAlertData: started 2026-01-02 09:54:31.1014 DFramework.Database.NullableDataReader Data reader open for 281 at System.Environment.GetStackTrace(Exception e, Boolean needFileInfo) at System.Environment.get_StackTrace() at DFramework.Database.NullableDataReader.Dispose(Boolean disposing) in D:\Spraxa\Framework\DFramework\Database\NullableDataReader.cs:line 33 at DFramework.Database.NullableDataReader.Dispose() in D:\Spraxa\Framework\DFramework\Database\NullableDataReader.cs:line 44 at CoolR.Tasks.ProcessAlertData.Execute() in D:\Spraxa\CoolR-Group\portal\CoolR.Tasks\ProcessAlertData.cs:line 47 at DFramework.Scheduler.TaskBase.Run() in 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-02 09:54:32.9764 AlertProcessor ProcessorAlertData: Stopped 2026-01-02 09:59:27.3693 AlertProcessor ProcessorAlertData: started 2026-01-02 09:59:32.8068 AlertProcessor ProcessorAlertData: Stopped 2026-01-02 09:59:34.6662 DFramework.Scheduler.TaskBase /* Time Taken: 15593.8557*/ Opportunity Out Of Stock By Outlet 2026-01-02 10:04:27.3871 AlertProcessor ProcessorAlertData: started 2026-01-02 10:04:32.8559 AlertProcessor ProcessorAlertData: Stopped 2026-01-02 10:09:27.4050 AlertProcessor ProcessorAlertData: started 2026-01-02 10:09:32.8738 AlertProcessor ProcessorAlertData: Stopped 2026-01-02 10:14:19.6260 DFramework.Database.Query /* Time Taken: 538*/ [dbo].GenerateSystemAlerts 2026-01-02 10:14:27.4229 AlertProcessor ProcessorAlertData: started 2026-01-02 10:14:32.9855 AlertProcessor ProcessorAlertData: Stopped 2026-01-02 10:14:34.7667 DFramework.Scheduler.TaskBase /* Time Taken: 15671.9912*/ Opportunity Out Of Stock By Outlet 2026-01-02 10:19:27.4408 AlertProcessor ProcessorAlertData: started 2026-01-02 10:19:32.9096 AlertProcessor ProcessorAlertData: Stopped 2026-01-02 10:24:27.4586 AlertProcessor ProcessorAlertData: started 2026-01-02 10:24:32.8805 AlertProcessor ProcessorAlertData: Stopped 2026-01-02 10:29:19.6327 DFramework.Database.Query /* Time Taken: 522*/ [dbo].GenerateSystemAlerts 2026-01-02 10:29:27.4609 AlertProcessor ProcessorAlertData: started 2026-01-02 10:29:32.8984 AlertProcessor ProcessorAlertData: Stopped 2026-01-02 10:29:34.7265 DFramework.Scheduler.TaskBase /* Time Taken: 15609.5019*/ Opportunity Out Of Stock By Outlet 2026-01-02 10:34:27.4631 AlertProcessor ProcessorAlertData: started 2026-01-02 10:34:32.8850 AlertProcessor ProcessorAlertData: Stopped 2026-01-02 10:39:27.4809 AlertProcessor ProcessorAlertData: started 2026-01-02 10:39:33.2153 DFramework.Database.NullableDataReader Data reader open for 283 at System.Environment.GetStackTrace(Exception e, Boolean needFileInfo) at System.Environment.get_StackTrace() at DFramework.Database.NullableDataReader.Dispose(Boolean disposing) in D:\Spraxa\Framework\DFramework\Database\NullableDataReader.cs:line 33 at DFramework.Database.NullableDataReader.Dispose() in D:\Spraxa\Framework\DFramework\Database\NullableDataReader.cs:line 44 at CoolR.Tasks.ProcessAlertData.Execute() in D:\Spraxa\CoolR-Group\portal\CoolR.Tasks\ProcessAlertData.cs:line 47 at DFramework.Scheduler.TaskBase.Run() in 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-02 10:39:33.2153 AlertProcessor ProcessorAlertData: Stopped 2026-01-02 10:44:19.6550 DFramework.Database.Query /* Time Taken: 527*/ [dbo].GenerateSystemAlerts 2026-01-02 10:44:27.4988 AlertProcessor ProcessorAlertData: started 2026-01-02 10:44:33.0457 AlertProcessor ProcessorAlertData: Stopped 2026-01-02 10:44:34.7957 DFramework.Scheduler.TaskBase /* Time Taken: 15656.3659*/ Opportunity Out Of Stock By Outlet 2026-01-02 10:49:27.5166 AlertProcessor ProcessorAlertData: started 2026-01-02 10:49:32.9385 AlertProcessor ProcessorAlertData: Stopped 2026-01-02 10:54:27.5189 AlertProcessor ProcessorAlertData: started 2026-01-02 10:54:32.9564 AlertProcessor ProcessorAlertData: Stopped 2026-01-02 10:59:27.5367 AlertProcessor ProcessorAlertData: started 2026-01-02 10:59:32.9587 AlertProcessor ProcessorAlertData: Stopped 2026-01-02 10:59:34.7399 DFramework.Scheduler.TaskBase /* Time Taken: 15578.2689*/ Opportunity Out Of Stock By Outlet 2026-01-02 11:04:27.5548 AlertProcessor ProcessorAlertData: started 2026-01-02 11:04:30.6173 DFramework.Database.Query /* Time Taken: 546*/ DECLARE @TableName AnsiString(8000) SET @TableName = 'AssetStockProductWiseConsolidate' DECLARE @CurrentRecordId Int32 SET @CurrentRecordId = '3675525' dbo.GetValidDeviceForAlertProcessData 2026-01-02 11:04:33.2735 AlertProcessor ProcessorAlertData: Stopped 2026-01-02 11:09:27.5570 AlertProcessor ProcessorAlertData: started 2026-01-02 11:09:32.9320 AlertProcessor ProcessorAlertData: Stopped 2026-01-02 11:14:27.5749 AlertProcessor ProcessorAlertData: started 2026-01-02 11:14:33.0905 AlertProcessor ProcessorAlertData: Stopped 2026-01-02 11:14:34.7468 DFramework.Scheduler.TaskBase /* Time Taken: 15562.6148*/ Opportunity Out Of Stock By Outlet 2026-01-02 11:19:27.5771 AlertProcessor ProcessorAlertData: started 2026-01-02 11:19:33.0615 AlertProcessor ProcessorAlertData: Stopped 2026-01-02 11:20:25.6869 DFramework.Database.Query /* Time Taken: 1176*/ 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-02 11:20:31.0619 DFramework.Database.Query /* Time Taken: 1537*/ 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-02 11:20:41.8120 DFramework.Database.Query /* Time Taken: 2257*/ 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-02 11:20:49.2965 DFramework.Database.Query /* Time Taken: 4729*/ 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-02 11:21:04.5466 DFramework.Database.Query /* Time Taken: 35015*/ 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-02 11:21:04.6403 DFramework.Scheduler.TaskBase /* Time Taken: 35109.6283*/ ProcessSQLUnprocessedFiles 2026-01-02 11:21:09.5466 DFramework.Database.Query /* Time Taken: 34999*/ 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-02 11:21:09.5466 DFramework.Scheduler.TaskBase /* Time Taken: 35000.2607*/ ProcessSQLUnprocessedFiles 2026-01-02 11:21:15.8748 DFramework.Database.Query /* Time Taken: 31307*/ 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-02 11:21:15.9060 DFramework.Scheduler.TaskBase /* Time Taken: 31328.3623*/ ProcessSQLUnprocessedFiles 2026-01-02 11:24:27.5949 AlertProcessor ProcessorAlertData: started 2026-01-02 11:24:30.5481 DFramework.Database.Query /* Time Taken: 514*/ DECLARE @TableName AnsiString(8000) SET @TableName = 'AssetStockProductWiseConsolidate' DECLARE @CurrentRecordId Int32 SET @CurrentRecordId = '3675525' dbo.GetValidDeviceForAlertProcessData 2026-01-02 11:24:33.0950 AlertProcessor ProcessorAlertData: Stopped 2026-01-02 11:29:27.6128 AlertProcessor ProcessorAlertData: started 2026-01-02 11:29:32.9722 AlertProcessor ProcessorAlertData: Stopped 2026-01-02 11:29:34.7691 DFramework.Scheduler.TaskBase /* Time Taken: 15562.6151*/ Opportunity Out Of Stock By Outlet 2026-01-02 11:34:27.6306 AlertProcessor ProcessorAlertData: started 2026-01-02 11:34:33.0369 AlertProcessor ProcessorAlertData: Stopped 2026-01-02 11:39:27.6485 AlertProcessor ProcessorAlertData: started 2026-01-02 11:39:33.1017 AlertProcessor ProcessorAlertData: Stopped 2026-01-02 11:44:19.7444 DFramework.Database.Query /* Time Taken: 529*/ [dbo].GenerateSystemAlerts 2026-01-02 11:44:27.6663 AlertProcessor ProcessorAlertData: started 2026-01-02 11:44:33.1351 AlertProcessor ProcessorAlertData: Stopped 2026-01-02 11:44:34.8851 DFramework.Scheduler.TaskBase /* Time Taken: 15656.3668*/ Opportunity Out Of Stock By Outlet 2026-01-02 11:49:27.6842 AlertProcessor ProcessorAlertData: started 2026-01-02 11:49:33.0280 AlertProcessor ProcessorAlertData: Stopped 2026-01-02 11:54:27.7020 AlertProcessor ProcessorAlertData: started 2026-01-02 11:54:33.0927 AlertProcessor ProcessorAlertData: Stopped 2026-01-02 11:59:27.7043 AlertProcessor ProcessorAlertData: started 2026-01-02 11:59:31.1261 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 D:\Spraxa\Framework\DFramework\Database\NullableDataReader.cs:line 33 at DFramework.Database.NullableDataReader.Dispose() in D:\Spraxa\Framework\DFramework\Database\NullableDataReader.cs:line 44 at CoolR.Tasks.ProcessAlertData.Execute() in D:\Spraxa\CoolR-Group\portal\CoolR.Tasks\ProcessAlertData.cs:line 47 at DFramework.Scheduler.TaskBase.Run() in 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-02 11:59:33.2980 AlertProcessor ProcessorAlertData: Stopped 2026-01-02 11:59:34.8137 DFramework.Scheduler.TaskBase /* Time Taken: 15562.6169*/ Opportunity Out Of Stock By Outlet 2026-01-02 12:04:27.7065 AlertProcessor ProcessorAlertData: started 2026-01-02 12:04:33.1440 AlertProcessor ProcessorAlertData: Stopped 2026-01-02 12:09:27.7087 AlertProcessor ProcessorAlertData: started 2026-01-02 12:09:33.1150 AlertProcessor ProcessorAlertData: Stopped 2026-01-02 12:14:19.7890 DFramework.Database.Query /* Time Taken: 530*/ [dbo].GenerateSystemAlerts 2026-01-02 12:14:27.7109 AlertProcessor ProcessorAlertData: started 2026-01-02 12:14:33.1953 AlertProcessor ProcessorAlertData: Stopped 2026-01-02 12:14:34.8828 DFramework.Scheduler.TaskBase /* Time Taken: 15609.489*/ Opportunity Out Of Stock By Outlet 2026-01-02 12:19:27.7131 AlertProcessor ProcessorAlertData: started 2026-01-02 12:19:33.2132 AlertProcessor ProcessorAlertData: Stopped 2026-01-02 12:24:27.7154 AlertProcessor ProcessorAlertData: started 2026-01-02 12:24:33.1685 AlertProcessor ProcessorAlertData: Stopped 2026-01-02 12:29:27.7333 AlertProcessor ProcessorAlertData: started 2026-01-02 12:29:33.1864 AlertProcessor ProcessorAlertData: Stopped 2026-01-02 12:29:34.8427 DFramework.Scheduler.TaskBase /* Time Taken: 15546.9977*/ Opportunity Out Of Stock By Outlet 2026-01-02 12:34:27.7511 AlertProcessor ProcessorAlertData: started 2026-01-02 12:34:33.1574 AlertProcessor ProcessorAlertData: Stopped 2026-01-02 12:39:27.7690 AlertProcessor ProcessorAlertData: started 2026-01-02 12:39:33.3940 AlertProcessor ProcessorAlertData: Stopped 2026-01-02 12:44:19.8039 DFramework.Database.Query /* Time Taken: 502*/ [dbo].GenerateSystemAlerts 2026-01-02 12:44:27.7883 AlertProcessor ProcessorAlertData: started 2026-01-02 12:44:33.3509 AlertProcessor ProcessorAlertData: Stopped 2026-01-02 12:44:34.8822 DFramework.Scheduler.TaskBase /* Time Taken: 15578.3167*/ Opportunity Out Of Stock By Outlet 2026-01-02 12:49:27.8071 AlertProcessor ProcessorAlertData: started 2026-01-02 12:49:33.2446 AlertProcessor ProcessorAlertData: Stopped 2026-01-02 12:54:27.8252 AlertProcessor ProcessorAlertData: started 2026-01-02 12:54:33.4034 AlertProcessor ProcessorAlertData: Stopped 2026-01-02 12:59:27.8426 AlertProcessor ProcessorAlertData: started 2026-01-02 12:59:33.3582 AlertProcessor ProcessorAlertData: Stopped 2026-01-02 12:59:34.8738 DFramework.Scheduler.TaskBase /* Time Taken: 15562.5211*/ Opportunity Out Of Stock By Outlet 2026-01-02 13:04:27.8592 AlertProcessor ProcessorAlertData: started 2026-01-02 13:04:33.2499 AlertProcessor ProcessorAlertData: Stopped 2026-01-02 13:09:27.8767 AlertProcessor ProcessorAlertData: started 2026-01-02 13:09:33.3768 AlertProcessor ProcessorAlertData: Stopped 2026-01-02 13:14:27.8945 AlertProcessor ProcessorAlertData: started 2026-01-02 13:14:33.3008 AlertProcessor ProcessorAlertData: Stopped 2026-01-02 13:14:34.8945 DFramework.Scheduler.TaskBase /* Time Taken: 15562.6117*/ Opportunity Out Of Stock By Outlet 2026-01-02 13:16:39.0681 DFramework.Database.Query /* Time Taken: 639*/ 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-02 13:16:39.6306 DFramework.Database.Query /* Time Taken: 1216*/ 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-02 13:16:42.8963 DFramework.Database.Query /* Time Taken: 4481*/ 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-02 13:16:47.8338 DFramework.Database.Query /* Time Taken: 4393*/ 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-02 13:16:49.6932 DFramework.Database.Query /* Time Taken: 1248*/ 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-02 13:17:07.9279 DFramework.Database.Query /* Time Taken: 4442*/ 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-02 13:17:13.4436 DFramework.Database.Query /* Time Taken: 35015*/ 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-02 13:17:13.5217 DFramework.Scheduler.TaskBase /* Time Taken: 35094.2845*/ ProcessSQLUnprocessedFiles 2026-01-02 13:17:13.8811 DFramework.Database.Query /* Time Taken: 5389*/ 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-02 13:17:14.4749 DFramework.Database.Query /* Time Taken: 31042*/ 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-02 13:17:14.5061 DFramework.Scheduler.TaskBase /* Time Taken: 31062.9706*/ ProcessSQLUnprocessedFiles 2026-01-02 13:17:20.6156 DFramework.Database.Query /* Time Taken: 32182*/ 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-02 13:17:20.6468 DFramework.Scheduler.TaskBase /* Time Taken: 32203.6062*/ ProcessSQLUnprocessedFiles 2026-01-02 13:19:27.9141 AlertProcessor ProcessorAlertData: started 2026-01-02 13:19:33.3986 AlertProcessor ProcessorAlertData: Stopped 2026-01-02 13:24:27.9171 AlertProcessor ProcessorAlertData: started 2026-01-02 13:24:33.3859 AlertProcessor ProcessorAlertData: Stopped 2026-01-02 13:29:27.9351 AlertProcessor ProcessorAlertData: started 2026-01-02 13:29:33.4039 AlertProcessor ProcessorAlertData: Stopped 2026-01-02 13:29:34.9196 DFramework.Scheduler.TaskBase /* Time Taken: 15562.6236*/ Opportunity Out Of Stock By Outlet 2026-01-02 13:34:27.9530 AlertProcessor ProcessorAlertData: started 2026-01-02 13:34:33.3437 AlertProcessor ProcessorAlertData: Stopped 2026-01-02 13:39:27.9709 AlertProcessor ProcessorAlertData: started 2026-01-02 13:39:33.3615 AlertProcessor ProcessorAlertData: Stopped 2026-01-02 13:44:19.9105 DFramework.Database.Query /* Time Taken: 542*/ [dbo].GenerateSystemAlerts 2026-01-02 13:44:27.9887 AlertProcessor ProcessorAlertData: started 2026-01-02 13:44:33.4419 AlertProcessor ProcessorAlertData: Stopped 2026-01-02 13:44:34.9888 DFramework.Scheduler.TaskBase /* Time Taken: 15609.4818*/ Opportunity Out Of Stock By Outlet 2026-01-02 13:49:28.0066 AlertProcessor ProcessorAlertData: started 2026-01-02 13:49:33.4909 AlertProcessor ProcessorAlertData: Stopped 2026-01-02 13:54:28.0223 AlertProcessor ProcessorAlertData: started 2026-01-02 13:54:33.3660 AlertProcessor ProcessorAlertData: Stopped 2026-01-02 13:59:19.9300 DFramework.Database.Query /* Time Taken: 551*/ [dbo].GenerateSystemAlerts 2026-01-02 13:59:28.0238 AlertProcessor ProcessorAlertData: started 2026-01-02 13:59:33.4458 AlertProcessor ProcessorAlertData: Stopped 2026-01-02 13:59:34.9926 DFramework.Scheduler.TaskBase /* Time Taken: 15609.475*/ Opportunity Out Of Stock By Outlet 2026-01-02 14:04:28.0415 AlertProcessor ProcessorAlertData: started 2026-01-02 14:04:33.3540 AlertProcessor ProcessorAlertData: Stopped 2026-01-02 14:09:28.0593 AlertProcessor ProcessorAlertData: started 2026-01-02 14:09:33.4969 AlertProcessor ProcessorAlertData: Stopped 2026-01-02 14:14:28.0772 AlertProcessor ProcessorAlertData: started 2026-01-02 14:14:33.5147 AlertProcessor ProcessorAlertData: Stopped 2026-01-02 14:14:35.0147 DFramework.Scheduler.TaskBase /* Time Taken: 15609.4858*/ Opportunity Out Of Stock By Outlet 2026-01-02 14:19:28.0950 AlertProcessor ProcessorAlertData: started 2026-01-02 14:19:33.5482 AlertProcessor ProcessorAlertData: Stopped 2026-01-02 14:24:28.1128 AlertProcessor ProcessorAlertData: started 2026-01-02 14:24:33.5660 AlertProcessor ProcessorAlertData: Stopped 2026-01-02 14:29:19.9430 DFramework.Database.Query /* Time Taken: 530*/ [dbo].GenerateSystemAlerts 2026-01-02 14:29:28.1305 AlertProcessor ProcessorAlertData: started 2026-01-02 14:29:33.5368 AlertProcessor ProcessorAlertData: Stopped 2026-01-02 14:29:35.0525 DFramework.Scheduler.TaskBase /* Time Taken: 15625.108*/ Opportunity Out Of Stock By Outlet 2026-01-02 14:34:28.1484 AlertProcessor ProcessorAlertData: started 2026-01-02 14:34:33.6797 AlertProcessor ProcessorAlertData: Stopped 2026-01-02 14:39:28.1506 AlertProcessor ProcessorAlertData: started 2026-01-02 14:39:33.6506 AlertProcessor ProcessorAlertData: Stopped 2026-01-02 14:44:28.1528 AlertProcessor ProcessorAlertData: started 2026-01-02 14:44:33.7154 AlertProcessor ProcessorAlertData: Stopped 2026-01-02 14:44:34.9966 DFramework.Scheduler.TaskBase /* Time Taken: 15546.991*/ Opportunity Out Of Stock By Outlet 2026-01-02 14:49:28.1707 AlertProcessor ProcessorAlertData: started 2026-01-02 14:49:31.2332 DFramework.Database.Query /* Time Taken: 576*/ DECLARE @TableName AnsiString(8000) SET @TableName = 'AssetStockProductWiseConsolidate' DECLARE @CurrentRecordId Int32 SET @CurrentRecordId = '3675525' dbo.GetValidDeviceForAlertProcessData 2026-01-02 14:49:33.7645 AlertProcessor ProcessorAlertData: Stopped 2026-01-02 14:54:28.1885 AlertProcessor ProcessorAlertData: started 2026-01-02 14:54:33.6886 AlertProcessor ProcessorAlertData: Stopped 2026-01-02 14:59:28.2056 AlertProcessor ProcessorAlertData: started 2026-01-02 14:59:33.8775 AlertProcessor ProcessorAlertData: Stopped 2026-01-02 14:59:35.0337 DFramework.Scheduler.TaskBase /* Time Taken: 15562.5191*/ Opportunity Out Of Stock By Outlet 2026-01-02 15:04:28.2223 AlertProcessor ProcessorAlertData: started 2026-01-02 15:04:33.6911 AlertProcessor ProcessorAlertData: Stopped 2026-01-02 15:09:28.2398 AlertProcessor ProcessorAlertData: started 2026-01-02 15:09:33.6930 AlertProcessor ProcessorAlertData: Stopped 2026-01-02 15:14:28.2419 AlertProcessor ProcessorAlertData: started 2026-01-02 15:14:33.7420 AlertProcessor ProcessorAlertData: Stopped 2026-01-02 15:14:35.0701 DFramework.Scheduler.TaskBase /* Time Taken: 15578.2383*/ Opportunity Out Of Stock By Outlet 2026-01-02 15:19:28.2458 AlertProcessor ProcessorAlertData: started 2026-01-02 15:19:33.6678 AlertProcessor ProcessorAlertData: Stopped 2026-01-02 15:24:28.2643 AlertProcessor ProcessorAlertData: started 2026-01-02 15:24:33.7018 AlertProcessor ProcessorAlertData: Stopped 2026-01-02 15:29:20.0166 DFramework.Database.Query /* Time Taken: 504*/ [dbo].GenerateSystemAlerts 2026-01-02 15:29:28.2823 AlertProcessor ProcessorAlertData: started 2026-01-02 15:29:33.7667 AlertProcessor ProcessorAlertData: Stopped 2026-01-02 15:29:35.1417 DFramework.Scheduler.TaskBase /* Time Taken: 15625.1195*/ Opportunity Out Of Stock By Outlet 2026-01-02 15:34:28.3004 AlertProcessor ProcessorAlertData: started 2026-01-02 15:34:33.6442 AlertProcessor ProcessorAlertData: Stopped 2026-01-02 15:39:28.3028 AlertProcessor ProcessorAlertData: started 2026-01-02 15:39:33.7091 AlertProcessor ProcessorAlertData: Stopped 2026-01-02 15:44:28.3206 AlertProcessor ProcessorAlertData: started 2026-01-02 15:44:33.4769 DFramework.Database.NullableDataReader Data reader open for 278 at System.Environment.GetStackTrace(Exception e, Boolean needFileInfo) at System.Environment.get_StackTrace() at DFramework.Database.NullableDataReader.Dispose(Boolean disposing) in D:\Spraxa\Framework\DFramework\Database\NullableDataReader.cs:line 33 at DFramework.Database.NullableDataReader.Dispose() in D:\Spraxa\Framework\DFramework\Database\NullableDataReader.cs:line 44 at CoolR.Tasks.ProcessAlertData.Execute() in D:\Spraxa\CoolR-Group\portal\CoolR.Tasks\ProcessAlertData.cs:line 47 at DFramework.Scheduler.TaskBase.Run() in 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-02 15:44:33.9457 AlertProcessor ProcessorAlertData: Stopped 2026-01-02 15:44:35.1019 DFramework.Scheduler.TaskBase /* Time Taken: 15562.6209*/ Opportunity Out Of Stock By Outlet 2026-01-02 15:49:28.3385 AlertProcessor ProcessorAlertData: started 2026-01-02 15:49:33.7448 AlertProcessor ProcessorAlertData: Stopped 2026-01-02 15:54:28.3564 AlertProcessor ProcessorAlertData: started 2026-01-02 15:54:30.1689 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 D:\Spraxa\Framework\DFramework\Database\NullableDataReader.cs:line 33 at DFramework.Database.NullableDataReader.Dispose() in D:\Spraxa\Framework\DFramework\Database\NullableDataReader.cs:line 44 at CoolR.Tasks.ProcessAlertData.Execute() in D:\Spraxa\CoolR-Group\portal\CoolR.Tasks\ProcessAlertData.cs:line 47 at DFramework.Scheduler.TaskBase.Run() in 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-02 15:54:33.9502 AlertProcessor ProcessorAlertData: Stopped 2026-01-02 15:59:20.0773 DFramework.Database.Query /* Time Taken: 529*/ [dbo].GenerateSystemAlerts 2026-01-02 15:59:28.3743 AlertProcessor ProcessorAlertData: started 2026-01-02 15:59:33.9368 AlertProcessor ProcessorAlertData: Stopped 2026-01-02 15:59:35.2493 DFramework.Scheduler.TaskBase /* Time Taken: 15687.6142*/ Opportunity Out Of Stock By Outlet 2026-01-02 16:04:28.3921 AlertProcessor ProcessorAlertData: started 2026-01-02 16:04:31.8140 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 D:\Spraxa\Framework\DFramework\Database\NullableDataReader.cs:line 33 at DFramework.Database.NullableDataReader.Dispose() in D:\Spraxa\Framework\DFramework\Database\NullableDataReader.cs:line 44 at CoolR.Tasks.ProcessAlertData.Execute() in D:\Spraxa\CoolR-Group\portal\CoolR.Tasks\ProcessAlertData.cs:line 47 at DFramework.Scheduler.TaskBase.Run() in 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-02 16:04:34.0172 AlertProcessor ProcessorAlertData: Stopped 2026-01-02 16:09:28.4100 AlertProcessor ProcessorAlertData: started 2026-01-02 16:09:33.8007 AlertProcessor ProcessorAlertData: Stopped 2026-01-02 16:14:28.4279 AlertProcessor ProcessorAlertData: started 2026-01-02 16:14:33.8654 AlertProcessor ProcessorAlertData: Stopped 2026-01-02 16:14:35.1311 DFramework.Scheduler.TaskBase /* Time Taken: 15562.6182*/ Opportunity Out Of Stock By Outlet 2026-01-02 16:19:28.4457 AlertProcessor ProcessorAlertData: started 2026-01-02 16:19:33.8520 AlertProcessor ProcessorAlertData: Stopped 2026-01-02 16:24:28.4480 AlertProcessor ProcessorAlertData: started 2026-01-02 16:24:33.9324 AlertProcessor ProcessorAlertData: Stopped 2026-01-02 16:29:20.0909 DFramework.Database.Query /* Time Taken: 521*/ [dbo].GenerateSystemAlerts 2026-01-02 16:29:28.4659 AlertProcessor ProcessorAlertData: started 2026-01-02 16:29:33.8722 AlertProcessor ProcessorAlertData: Stopped 2026-01-02 16:29:35.1847 DFramework.Scheduler.TaskBase /* Time Taken: 15609.4863*/ Opportunity Out Of Stock By Outlet 2026-01-02 16:34:28.4838 AlertProcessor ProcessorAlertData: started 2026-01-02 16:34:33.8120 AlertProcessor ProcessorAlertData: Stopped 2026-01-02 16:39:28.5016 AlertProcessor ProcessorAlertData: started 2026-01-02 16:39:33.9548 AlertProcessor ProcessorAlertData: Stopped 2026-01-02 16:44:20.0977 DFramework.Database.Query /* Time Taken: 513*/ [dbo].GenerateSystemAlerts 2026-01-02 16:44:28.5197 AlertProcessor ProcessorAlertData: started 2026-01-02 16:44:33.8166 AlertProcessor ProcessorAlertData: Stopped 2026-01-02 16:44:35.1916 DFramework.Scheduler.TaskBase /* Time Taken: 15593.8766*/ Opportunity Out Of Stock By Outlet 2026-01-02 16:49:28.5376 AlertProcessor ProcessorAlertData: started 2026-01-02 16:49:34.1782 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 D:\Spraxa\Framework\DFramework\Database\NullableDataReader.cs:line 33 at DFramework.Database.NullableDataReader.Dispose() in D:\Spraxa\Framework\DFramework\Database\NullableDataReader.cs:line 44 at CoolR.Tasks.ProcessAlertData.Execute() in D:\Spraxa\CoolR-Group\portal\CoolR.Tasks\ProcessAlertData.cs:line 47 at DFramework.Scheduler.TaskBase.Run() in 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-02 16:49:34.1782 AlertProcessor ProcessorAlertData: Stopped 2026-01-02 16:54:28.5398 AlertProcessor ProcessorAlertData: started 2026-01-02 16:54:33.9305 AlertProcessor ProcessorAlertData: Stopped 2026-01-02 16:59:20.1358 DFramework.Database.Query /* Time Taken: 524*/ [dbo].GenerateSystemAlerts 2026-01-02 16:59:28.5577 AlertProcessor ProcessorAlertData: started 2026-01-02 16:59:33.9953 AlertProcessor ProcessorAlertData: Stopped 2026-01-02 16:59:35.2453 DFramework.Scheduler.TaskBase /* Time Taken: 15625.1108*/ Opportunity Out Of Stock By Outlet 2026-01-02 17:04:28.5756 AlertProcessor ProcessorAlertData: started 2026-01-02 17:04:33.9975 AlertProcessor ProcessorAlertData: Stopped 2026-01-02 17:09:28.5935 AlertProcessor ProcessorAlertData: started 2026-01-02 17:09:33.9841 AlertProcessor ProcessorAlertData: Stopped 2026-01-02 17:14:28.6113 AlertProcessor ProcessorAlertData: started 2026-01-02 17:14:34.1582 AlertProcessor ProcessorAlertData: Stopped 2026-01-02 17:14:35.2676 DFramework.Scheduler.TaskBase /* Time Taken: 15625.1164*/ Opportunity Out Of Stock By Outlet 2026-01-02 17:19:28.6291 AlertProcessor ProcessorAlertData: started 2026-01-02 17:19:34.1292 AlertProcessor ProcessorAlertData: Stopped 2026-01-02 17:24:28.6470 AlertProcessor ProcessorAlertData: started 2026-01-02 17:24:34.1158 AlertProcessor ProcessorAlertData: Stopped 2026-01-02 17:29:28.6492 AlertProcessor ProcessorAlertData: started 2026-01-02 17:29:34.1336 AlertProcessor ProcessorAlertData: Stopped 2026-01-02 17:29:35.3055 DFramework.Scheduler.TaskBase /* Time Taken: 15640.7445*/ Opportunity Out Of Stock By Outlet 2026-01-02 17:34:28.6516 AlertProcessor ProcessorAlertData: started 2026-01-02 17:34:34.0579 AlertProcessor ProcessorAlertData: Stopped 2026-01-02 17:39:28.6695 AlertProcessor ProcessorAlertData: started 2026-01-02 17:39:34.0914 AlertProcessor ProcessorAlertData: Stopped 2026-01-02 17:44:20.2029 DFramework.Database.Query /* Time Taken: 527*/ [dbo].GenerateSystemAlerts 2026-01-02 17:44:28.6874 AlertProcessor ProcessorAlertData: started 2026-01-02 17:44:34.1249 AlertProcessor ProcessorAlertData: Stopped 2026-01-02 17:44:35.3593 DFramework.Scheduler.TaskBase /* Time Taken: 15671.9886*/ Opportunity Out Of Stock By Outlet 2026-01-02 17:49:28.6896 AlertProcessor ProcessorAlertData: started 2026-01-02 17:49:34.1428 AlertProcessor ProcessorAlertData: Stopped 2026-01-02 17:54:28.6918 AlertProcessor ProcessorAlertData: started 2026-01-02 17:54:34.0513 AlertProcessor ProcessorAlertData: Stopped 2026-01-02 17:59:20.2409 DFramework.Database.Query /* Time Taken: 535*/ [dbo].GenerateSystemAlerts 2026-01-02 17:59:28.6941 AlertProcessor ProcessorAlertData: started 2026-01-02 17:59:34.1942 AlertProcessor ProcessorAlertData: Stopped 2026-01-02 17:59:35.3504 DFramework.Scheduler.TaskBase /* Time Taken: 15640.7429*/ Opportunity Out Of Stock By Outlet 2026-01-02 18:04:28.6963 AlertProcessor ProcessorAlertData: started 2026-01-02 18:04:31.6807 DFramework.Database.Query /* Time Taken: 519*/ DECLARE @TableName AnsiString(8000) SET @TableName = 'AssetStockProductWiseConsolidate' DECLARE @CurrentRecordId Int32 SET @CurrentRecordId = '3675525' dbo.GetValidDeviceForAlertProcessData 2026-01-02 18:04:34.2120 AlertProcessor ProcessorAlertData: Stopped 2026-01-02 18:09:28.7143 AlertProcessor ProcessorAlertData: started 2026-01-02 18:09:34.0737 AlertProcessor ProcessorAlertData: Stopped 2026-01-02 18:14:20.2477 DFramework.Database.Query /* Time Taken: 519*/ [dbo].GenerateSystemAlerts 2026-01-02 18:14:28.7322 AlertProcessor ProcessorAlertData: started 2026-01-02 18:14:34.1072 AlertProcessor ProcessorAlertData: Stopped 2026-01-02 18:14:35.3728 DFramework.Scheduler.TaskBase /* Time Taken: 15640.7393*/ Opportunity Out Of Stock By Outlet 2026-01-02 18:19:28.7500 AlertProcessor ProcessorAlertData: started 2026-01-02 18:19:34.0782 AlertProcessor ProcessorAlertData: Stopped 2026-01-02 18:24:28.7680 AlertProcessor ProcessorAlertData: started 2026-01-02 18:24:34.1430 AlertProcessor ProcessorAlertData: Stopped 2026-01-02 18:29:20.3014 DFramework.Database.Query /* Time Taken: 555*/ [dbo].GenerateSystemAlerts 2026-01-02 18:29:28.7859 AlertProcessor ProcessorAlertData: started 2026-01-02 18:29:34.2390 AlertProcessor ProcessorAlertData: Stopped 2026-01-02 18:29:35.3953 DFramework.Scheduler.TaskBase /* Time Taken: 15640.7416*/ Opportunity Out Of Stock By Outlet 2026-01-02 18:34:21.8974 MoveToReorder Running task for ClientId : 286 and ClientName = India Office QA and Slot: 1/3/2026 8:00:00 AM And LastExecutedOn: 1/2/2026 10:04:20 PM 2026-01-02 18:34:28.8037 AlertProcessor ProcessorAlertData: started 2026-01-02 18:34:34.2413 AlertProcessor ProcessorAlertData: Stopped 2026-01-02 18:35:02.1634 DFramework.Database.NullableDataReader Data reader open for 39977 at System.Environment.GetStackTrace(Exception e, Boolean needFileInfo) at System.Environment.get_StackTrace() at DFramework.Database.NullableDataReader.Dispose(Boolean disposing) in D:\Spraxa\Framework\DFramework\Database\NullableDataReader.cs:line 33 at DFramework.Database.NullableDataReader.Dispose() in D:\Spraxa\Framework\DFramework\Database\NullableDataReader.cs:line 44 at CoolR.Tasks.MoveToReorder.Execute() in D:\Spraxa\CoolR-Group\portal\CoolR.Tasks\MoveToReorder.cs:line 44 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-02 18:35:02.1946 MoveToReorder Task executed successfully for ClientId : 286 Client Name:India Office QA, Slot: 1/3/2026 8:00:00 AM and Total Order Suggested: 126 Out Of: 126 2026-01-02 18:35:03.8509 DFramework.Scheduler.TaskBase /* Time Taken: 42265.9611*/ Move To Re-Order 2026-01-02 18:39:28.8060 AlertProcessor ProcessorAlertData: started 2026-01-02 18:39:34.2435 AlertProcessor ProcessorAlertData: Stopped 2026-01-02 18:44:28.8238 AlertProcessor ProcessorAlertData: started 2026-01-02 18:44:34.2301 AlertProcessor ProcessorAlertData: Stopped 2026-01-02 18:44:35.4176 DFramework.Scheduler.TaskBase /* Time Taken: 15640.7426*/ Opportunity Out Of Stock By Outlet 2026-01-02 18:49:28.8417 AlertProcessor ProcessorAlertData: started 2026-01-02 18:49:34.2479 AlertProcessor ProcessorAlertData: Stopped 2026-01-02 18:54:28.8595 AlertProcessor ProcessorAlertData: started 2026-01-02 18:54:34.2502 AlertProcessor ProcessorAlertData: Stopped 2026-01-02 18:59:28.8617 AlertProcessor ProcessorAlertData: started 2026-01-02 18:59:34.1587 AlertProcessor ProcessorAlertData: Stopped 2026-01-02 18:59:35.3774 DFramework.Scheduler.TaskBase /* Time Taken: 15593.8612*/ Opportunity Out Of Stock By Outlet 2026-01-02 19:04:28.8796 AlertProcessor ProcessorAlertData: started 2026-01-02 19:04:34.2546 AlertProcessor ProcessorAlertData: Stopped 2026-01-02 19:09:28.8975 AlertProcessor ProcessorAlertData: started 2026-01-02 19:09:34.2256 AlertProcessor ProcessorAlertData: Stopped 2026-01-02 19:14:20.2902 DFramework.Database.Query /* Time Taken: 508*/ [dbo].GenerateSystemAlerts 2026-01-02 19:14:28.9153 AlertProcessor ProcessorAlertData: started 2026-01-02 19:14:34.3684 AlertProcessor ProcessorAlertData: Stopped 2026-01-02 19:14:35.4310 DFramework.Scheduler.TaskBase /* Time Taken: 15640.7333*/ Opportunity Out Of Stock By Outlet 2026-01-02 19:19:28.9331 AlertProcessor ProcessorAlertData: started 2026-01-02 19:19:34.3550 AlertProcessor ProcessorAlertData: Stopped 2026-01-02 19:24:28.9509 AlertProcessor ProcessorAlertData: started 2026-01-02 19:24:34.3572 AlertProcessor ProcessorAlertData: Stopped 2026-01-02 19:29:28.9687 AlertProcessor ProcessorAlertData: started 2026-01-02 19:29:34.3907 AlertProcessor ProcessorAlertData: Stopped 2026-01-02 19:29:35.4532 DFramework.Scheduler.TaskBase /* Time Taken: 15640.7472*/ Opportunity Out Of Stock By Outlet 2026-01-02 19:34:21.9865 MoveToReorder Running task for ClientId : 286 and ClientName = India Office QA and Slot: 1/3/2026 9:00:00 AM And LastExecutedOn: 1/3/2026 8:04:21 AM 2026-01-02 19:34:22.1897 MoveToReorder Task executed successfully for ClientId : 286 Client Name:India Office QA, Slot: 1/3/2026 9:00:00 AM But No Order found to suggest 2026-01-02 19:34:28.9866 AlertProcessor ProcessorAlertData: started 2026-01-02 19:34:34.3148 AlertProcessor ProcessorAlertData: Stopped 2026-01-02 19:39:28.9888 AlertProcessor ProcessorAlertData: started 2026-01-02 19:39:34.4263 AlertProcessor ProcessorAlertData: Stopped 2026-01-02 19:44:29.0067 AlertProcessor ProcessorAlertData: started 2026-01-02 19:44:34.3661 AlertProcessor ProcessorAlertData: Stopped 2026-01-02 19:44:35.4598 DFramework.Scheduler.TaskBase /* Time Taken: 15625.1151*/ Opportunity Out Of Stock By Outlet 2026-01-02 19:49:29.0245 AlertProcessor ProcessorAlertData: started 2026-01-02 19:49:34.4152 AlertProcessor ProcessorAlertData: Stopped 2026-01-02 19:54:29.0424 AlertProcessor ProcessorAlertData: started 2026-01-02 19:54:34.4799 AlertProcessor ProcessorAlertData: Stopped 2026-01-02 19:59:29.0446 AlertProcessor ProcessorAlertData: started 2026-01-02 19:59:34.5447 AlertProcessor ProcessorAlertData: Stopped 2026-01-02 19:59:35.4509 DFramework.Scheduler.TaskBase /* Time Taken: 15593.8653*/ Opportunity Out Of Stock By Outlet 2026-01-02 20:04:29.0468 AlertProcessor ProcessorAlertData: started 2026-01-02 20:04:34.5000 AlertProcessor ProcessorAlertData: Stopped 2026-01-02 20:09:29.0491 AlertProcessor ProcessorAlertData: started 2026-01-02 20:09:34.6116 AlertProcessor ProcessorAlertData: Stopped 2026-01-02 20:14:29.0513 AlertProcessor ProcessorAlertData: started 2026-01-02 20:14:34.6295 AlertProcessor ProcessorAlertData: Stopped 2026-01-02 20:14:35.5514 DFramework.Scheduler.TaskBase /* Time Taken: 15671.9901*/ Opportunity Out Of Stock By Outlet 2026-01-02 20:19:29.0692 AlertProcessor ProcessorAlertData: started 2026-01-02 20:19:34.4286 AlertProcessor ProcessorAlertData: Stopped 2026-01-02 20:24:29.0871 AlertProcessor ProcessorAlertData: started 2026-01-02 20:24:34.6027 AlertProcessor ProcessorAlertData: Stopped 2026-01-02 20:29:20.3861 DFramework.Database.Query /* Time Taken: 505*/ [dbo].GenerateSystemAlerts 2026-01-02 20:29:29.1050 AlertProcessor ProcessorAlertData: started 2026-01-02 20:29:29.6831 DFramework.Database.NullableDataReader Data reader open for 278 at System.Environment.GetStackTrace(Exception e, Boolean needFileInfo) at System.Environment.get_StackTrace() at DFramework.Database.NullableDataReader.Dispose(Boolean disposing) in D:\Spraxa\Framework\DFramework\Database\NullableDataReader.cs:line 33 at DFramework.Database.NullableDataReader.Dispose() in D:\Spraxa\Framework\DFramework\Database\NullableDataReader.cs:line 44 at CoolR.Tasks.ProcessAlertData.Execute() in D:\Spraxa\CoolR-Group\portal\CoolR.Tasks\ProcessAlertData.cs:line 47 at DFramework.Scheduler.TaskBase.Run() in 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-02 20:29:34.7613 AlertProcessor ProcessorAlertData: Stopped 2026-01-02 20:29:35.5113 DFramework.Scheduler.TaskBase /* Time Taken: 15625.1219*/ Opportunity Out Of Stock By Outlet 2026-01-02 20:34:22.0915 MoveToReorder Running task for ClientId : 286 and ClientName = India Office QA and Slot: 1/3/2026 10:00:00 AM And LastExecutedOn: 1/3/2026 9:04:21 AM 2026-01-02 20:34:22.3103 MoveToReorder Task executed successfully for ClientId : 286 Client Name:India Office QA, Slot: 1/3/2026 10:00:00 AM But No Order found to suggest 2026-01-02 20:34:29.1228 AlertProcessor ProcessorAlertData: started 2026-01-02 20:34:29.8103 DFramework.Database.Query /* Time Taken: 607*/ DECLARE AlertTypeIds Object SET AlertTypeIds = 'DFramework.Database.Adapters.SQL+d__24' [dbo].GetAlertSummaryData 2026-01-02 20:34:34.8260 DFramework.Database.Query /* Time Taken: 567*/ DECLARE @TableName AnsiString(8000) SET @TableName = 'ProductStockLevel' DECLARE @CurrentRecordId Int32 SET @CurrentRecordId = '3675525' dbo.GetValidDeviceForAlertProcessData 2026-01-02 20:34:34.8416 DFramework.Database.Query /* Time Taken: 5042*/ DECLARE @AlertTypeIds AnsiString(8000) SET @AlertTypeIds = '46,37,59,73,57' DECLARE @ClientIds AnsiString(8000) SET @ClientIds = '213,286,1494,114,180,183,299,300,314,316,331,332,333,349,415,451,296,301,303,305,328,335,70,134,188,227,295,320,336,338,395,337,360,385,421,469,471,1480,207,224,291,306,308,325,342,452' DECLARE @StatusId Int32 SET @StatusId = '1' SELECT ClientName, AlertType, AlertText, Location.Name AS [Location], Location.Code AS LocationCode, Asset.SerialNumber AS AssetSerialNumber, COALESCE(SmartDevice.SerialNumber, SD.SerialNumber) AS SmartDeviceSerial, AlertAt, AccountCoordinators.PrimaryEmail AS AccountCoordinator, AccountDirectors.PrimaryEmail AS AccountDirector, Alert.ClientId FROM Alert LEFT OUTER JOIN Client ON Client.ClientId = Alert.ClientId LEFT OUTER JOIN AlertType ON AlertType.AlertTypeId = Alert.AlertTypeId LEFT OUTER JOIN Location ON Location.LocationId = Alert.LocationId LEFT OUTER JOIN Asset ON Asset.AssetId = Alert.AssetId LEFT OUTER JOIN SmartDevice ON SmartDevice.SmartDeviceId = Alert.SmartDeviceId AND SmartDevice.IsGatewayDevice = 0 LEFT OUTER JOIN vwSmartDeviceExceptSmartHubList AS SD ON dbo.Alert.AssetId = SD.LinkedAssetId AND SD.LinkedAssetId <> 0 LEFT OUTER JOIN dbo.Security_User AS AccountDirectors ON Client.AccountDirectorId = AccountDirectors.UserId AND AccountDirectors.IsDeleted = 0 LEFT OUTER JOIN dbo.Security_User AS AccountCoordinators ON Client.AccountCoordinatorId = AccountCoordinators.UserId AND AccountCoordinators.IsDeleted = 0 WHERE Alert.IsDeleted = 0 AND Alert.AlertTypeId IN (SELECT * FROM CsvToInt(@AlertTypeIds)) AND Alert.ClientId IN (SELECT * FROM CsvToInt(@ClientIds)) AND Alert.StatusId = @StatusId ORDER BY Alert.ClientId 2026-01-02 20:34:34.8885 AlertProcessor ProcessorAlertData: Stopped 2026-01-02 20:39:29.1407 AlertProcessor ProcessorAlertData: started 2026-01-02 20:39:34.6095 AlertProcessor ProcessorAlertData: Stopped 2026-01-02 20:44:29.1429 AlertProcessor ProcessorAlertData: started 2026-01-02 20:44:34.6273 AlertProcessor ProcessorAlertData: Stopped 2026-01-02 20:44:35.5961 DFramework.Scheduler.TaskBase /* Time Taken: 15687.6078*/ Opportunity Out Of Stock By Outlet 2026-01-02 20:49:29.1451 AlertProcessor ProcessorAlertData: started 2026-01-02 20:49:34.4889 AlertProcessor ProcessorAlertData: Stopped 2026-01-02 20:54:29.1630 AlertProcessor ProcessorAlertData: started 2026-01-02 20:54:34.6005 AlertProcessor ProcessorAlertData: Stopped 2026-01-02 20:59:20.4464 DFramework.Database.Query /* Time Taken: 524*/ [dbo].GenerateSystemAlerts 2026-01-02 20:59:29.1652 AlertProcessor ProcessorAlertData: started 2026-01-02 20:59:34.8528 AlertProcessor ProcessorAlertData: Stopped 2026-01-02 20:59:35.5559 DFramework.Scheduler.TaskBase /* Time Taken: 15625.1302*/ Opportunity Out Of Stock By Outlet 2026-01-02 21:04:29.1831 AlertProcessor ProcessorAlertData: started 2026-01-02 21:04:34.6988 AlertProcessor ProcessorAlertData: Stopped 2026-01-02 21:09:29.2010 AlertProcessor ProcessorAlertData: started 2026-01-02 21:09:32.0604 DFramework.Database.Query /* Time Taken: 1326*/ 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-02 21:09:32.2635 DFramework.Database.Query /* Time Taken: 511*/ DECLARE @TableName AnsiString(8000) SET @TableName = 'AssetStockProductWiseConsolidate' DECLARE @CurrentRecordId Int32 SET @CurrentRecordId = '3675525' dbo.GetValidDeviceForAlertProcessData 2026-01-02 21:09:33.7947 DFramework.Database.Query /* Time Taken: 1211*/ DECLARE @TableName AnsiString(8000) SET @TableName = 'AssetStockProductWise' DECLARE @ClientId Int32 SET @ClientId = '0' DECLARE @Table AnsiString(8000) SET @Table = 'AssetStockProductWise' DECLARE @PrimaryKey Int32 SET @PrimaryKey = '3675525' UPDATE dbo.AlertProcessor SET ClientId = @ClientId, TableName = @Table, PrimaryKey = @PrimaryKey WHERE [TableName] = @TableName AND (ClientId <> @ClientId OR TableName <> @Table OR PrimaryKey <> @PrimaryKey) 2026-01-02 21:09:33.7947 DFramework.Database.NullableDataReader Data reader open for 1239 at System.Environment.GetStackTrace(Exception e, Boolean needFileInfo) at System.Environment.get_StackTrace() at DFramework.Database.NullableDataReader.Dispose(Boolean disposing) in D:\Spraxa\Framework\DFramework\Database\NullableDataReader.cs:line 33 at DFramework.Database.NullableDataReader.Dispose() in D:\Spraxa\Framework\DFramework\Database\NullableDataReader.cs:line 44 at CoolR.Tasks.ProcessAlertData.Execute() in D:\Spraxa\CoolR-Group\portal\CoolR.Tasks\ProcessAlertData.cs:line 47 at DFramework.Scheduler.TaskBase.Run() in 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-02 21:09:38.5448 DFramework.Database.Query /* Time Taken: 2789*/ 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-02 21:09:41.0917 DFramework.Database.Query /* Time Taken: 7078*/ DECLARE @TableName AnsiString(8000) SET @TableName = 'AssetStock' SELECT TableName FROM AlertProcessor WHERE [TableName] = @TableName 2026-01-02 21:09:41.1229 DFramework.Database.NullableDataReader Data reader open for 7106 at System.Environment.GetStackTrace(Exception e, Boolean needFileInfo) at System.Environment.get_StackTrace() at DFramework.Database.NullableDataReader.Dispose(Boolean disposing) in D:\Spraxa\Framework\DFramework\Database\NullableDataReader.cs:line 33 at DFramework.Database.NullableDataReader.Dispose() in D:\Spraxa\Framework\DFramework\Database\NullableDataReader.cs:line 44 at CoolR.Tasks.ProcessAlertData.Execute() in D:\Spraxa\CoolR-Group\portal\CoolR.Tasks\ProcessAlertData.cs:line 47 at DFramework.Scheduler.TaskBase.Run() in 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-02 21:09:43.0136 AlertProcessor ProcessorAlertData: Stopped 2026-01-02 21:09:43.0136 DFramework.Scheduler.TaskBase /* Time Taken: 13812.6015*/ Process Alert Record 2026-01-02 21:14:20.5156 DFramework.Database.Query /* Time Taken: 564*/ [dbo].GenerateSystemAlerts 2026-01-02 21:14:29.2188 AlertProcessor ProcessorAlertData: started 2026-01-02 21:14:34.9688 AlertProcessor ProcessorAlertData: Stopped 2026-01-02 21:14:35.6407 DFramework.Scheduler.TaskBase /* Time Taken: 15687.6197*/ Opportunity Out Of Stock By Outlet 2026-01-02 21:19:29.2367 AlertProcessor ProcessorAlertData: started 2026-01-02 21:19:34.7054 AlertProcessor ProcessorAlertData: Stopped 2026-01-02 21:24:29.2545 AlertProcessor ProcessorAlertData: started 2026-01-02 21:24:35.0045 AlertProcessor ProcessorAlertData: Stopped 2026-01-02 21:29:29.2723 AlertProcessor ProcessorAlertData: started 2026-01-02 21:29:34.8974 AlertProcessor ProcessorAlertData: Stopped 2026-01-02 21:29:35.5380 DFramework.Scheduler.TaskBase /* Time Taken: 15578.2396*/ Opportunity Out Of Stock By Outlet 2026-01-02 21:34:22.2121 MoveToReorder Running task for ClientId : 286 and ClientName = India Office QA and Slot: 1/3/2026 11:00:00 AM And LastExecutedOn: 1/3/2026 10:04:22 AM 2026-01-02 21:34:29.2903 AlertProcessor ProcessorAlertData: started 2026-01-02 21:34:34.7903 AlertProcessor ProcessorAlertData: Stopped 2026-01-02 21:35:01.1499 DFramework.Database.NullableDataReader Data reader open for 38693 at System.Environment.GetStackTrace(Exception e, Boolean needFileInfo) at System.Environment.get_StackTrace() at DFramework.Database.NullableDataReader.Dispose(Boolean disposing) in D:\Spraxa\Framework\DFramework\Database\NullableDataReader.cs:line 33 at DFramework.Database.NullableDataReader.Dispose() in D:\Spraxa\Framework\DFramework\Database\NullableDataReader.cs:line 44 at CoolR.Tasks.MoveToReorder.Execute() in D:\Spraxa\CoolR-Group\portal\CoolR.Tasks\MoveToReorder.cs:line 44 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-02 21:35:01.1812 MoveToReorder Task executed successfully for ClientId : 286 Client Name:India Office QA, Slot: 1/3/2026 11:00:00 AM and Total Order Suggested: 127 Out Of: 127 2026-01-02 21:35:02.3374 DFramework.Scheduler.TaskBase /* Time Taken: 40437.8094*/ Move To Re-Order 2026-01-02 21:39:29.3082 AlertProcessor ProcessorAlertData: started 2026-01-02 21:39:34.7769 AlertProcessor ProcessorAlertData: Stopped 2026-01-02 21:44:29.3104 AlertProcessor ProcessorAlertData: started 2026-01-02 21:44:34.9354 AlertProcessor ProcessorAlertData: Stopped 2026-01-02 21:44:35.5448 DFramework.Scheduler.TaskBase /* Time Taken: 15562.6149*/ Opportunity Out Of Stock By Outlet 2026-01-02 21:49:29.3283 AlertProcessor ProcessorAlertData: started 2026-01-02 21:49:34.7659 AlertProcessor ProcessorAlertData: Stopped 2026-01-02 21:54:29.3463 AlertProcessor ProcessorAlertData: started 2026-01-02 21:54:34.7839 AlertProcessor ProcessorAlertData: Stopped 2026-01-02 21:59:20.5360 DFramework.Database.Query /* Time Taken: 543*/ [dbo].GenerateSystemAlerts 2026-01-02 21:59:29.3642 AlertProcessor ProcessorAlertData: started 2026-01-02 21:59:34.8486 AlertProcessor ProcessorAlertData: Stopped 2026-01-02 21:59:35.6298 DFramework.Scheduler.TaskBase /* Time Taken: 15625.103*/ Opportunity Out Of Stock By Outlet 2026-01-02 22:04:29.3820 AlertProcessor ProcessorAlertData: started 2026-01-02 22:04:34.8821 AlertProcessor ProcessorAlertData: Stopped 2026-01-02 22:09:29.3995 AlertProcessor ProcessorAlertData: started 2026-01-02 22:09:34.9464 AlertProcessor ProcessorAlertData: Stopped 2026-01-02 22:14:20.5266 DFramework.Database.Query /* Time Taken: 512*/ [dbo].GenerateSystemAlerts 2026-01-02 22:14:29.4173 AlertProcessor ProcessorAlertData: started 2026-01-02 22:14:34.9642 AlertProcessor ProcessorAlertData: Stopped 2026-01-02 22:14:35.6205 DFramework.Scheduler.TaskBase /* Time Taken: 15593.8636*/ Opportunity Out Of Stock By Outlet 2026-01-02 22:19:29.4351 AlertProcessor ProcessorAlertData: started 2026-01-02 22:19:32.4039 DFramework.Database.Query /* Time Taken: 523*/ DECLARE @TableName AnsiString(8000) SET @TableName = 'AssetStockProductWiseConsolidate' DECLARE @CurrentRecordId Int32 SET @CurrentRecordId = '3675525' dbo.GetValidDeviceForAlertProcessData 2026-01-02 22:19:34.9977 AlertProcessor ProcessorAlertData: Stopped 2026-01-02 22:24:29.4366 AlertProcessor ProcessorAlertData: started 2026-01-02 22:24:34.9210 AlertProcessor ProcessorAlertData: Stopped 2026-01-02 22:29:20.5945 DFramework.Database.Query /* Time Taken: 549*/ [dbo].GenerateSystemAlerts 2026-01-02 22:29:29.4384 AlertProcessor ProcessorAlertData: started 2026-01-02 22:29:34.8915 AlertProcessor ProcessorAlertData: Stopped 2026-01-02 22:29:35.6728 DFramework.Scheduler.TaskBase /* Time Taken: 15625.1039*/ Opportunity Out Of Stock By Outlet 2026-01-02 22:34:22.3310 MoveToReorder Running task for ClientId : 286 and ClientName = India Office QA and Slot: 1/3/2026 12:00:00 PM And LastExecutedOn: 1/3/2026 11:04:22 AM 2026-01-02 22:34:22.5498 MoveToReorder Task executed successfully for ClientId : 286 Client Name:India Office QA, Slot: 1/3/2026 12:00:00 PM But No Order found to suggest 2026-01-02 22:34:29.4404 AlertProcessor ProcessorAlertData: started 2026-01-02 22:34:34.9561 AlertProcessor ProcessorAlertData: Stopped 2026-01-02 22:39:29.4582 AlertProcessor ProcessorAlertData: started 2026-01-02 22:39:34.9113 AlertProcessor ProcessorAlertData: Stopped 2026-01-02 22:44:20.5851 DFramework.Database.Query /* Time Taken: 520*/ [dbo].GenerateSystemAlerts 2026-01-02 22:44:29.4757 AlertProcessor ProcessorAlertData: started 2026-01-02 22:44:34.9758 AlertProcessor ProcessorAlertData: Stopped 2026-01-02 22:44:35.6789 DFramework.Scheduler.TaskBase /* Time Taken: 15609.4752*/ Opportunity Out Of Stock By Outlet 2026-01-02 22:49:29.4935 AlertProcessor ProcessorAlertData: started 2026-01-02 22:49:34.9779 AlertProcessor ProcessorAlertData: Stopped 2026-01-02 22:54:29.5114 AlertProcessor ProcessorAlertData: started 2026-01-02 22:54:34.9489 AlertProcessor ProcessorAlertData: Stopped 2026-01-02 22:59:29.5291 AlertProcessor ProcessorAlertData: started 2026-01-02 22:59:35.1229 AlertProcessor ProcessorAlertData: Stopped 2026-01-02 22:59:35.7323 DFramework.Scheduler.TaskBase /* Time Taken: 15640.7414*/ Opportunity Out Of Stock By Outlet 2026-01-02 23:04:29.5470 AlertProcessor ProcessorAlertData: started 2026-01-02 23:04:35.0001 AlertProcessor ProcessorAlertData: Stopped 2026-01-02 23:09:29.5648 AlertProcessor ProcessorAlertData: started 2026-01-02 23:09:34.9711 AlertProcessor ProcessorAlertData: Stopped 2026-01-02 23:14:20.6295 DFramework.Database.Query /* Time Taken: 530*/ [dbo].GenerateSystemAlerts 2026-01-02 23:14:29.5827 AlertProcessor ProcessorAlertData: started 2026-01-02 23:14:35.0047 AlertProcessor ProcessorAlertData: Stopped 2026-01-02 23:14:35.7547 DFramework.Scheduler.TaskBase /* Time Taken: 15640.7502*/ Opportunity Out Of Stock By Outlet 2026-01-02 23:19:29.6007 AlertProcessor ProcessorAlertData: started 2026-01-02 23:19:35.2413 AlertProcessor ProcessorAlertData: Stopped 2026-01-02 23:24:29.6029 AlertProcessor ProcessorAlertData: started 2026-01-02 23:24:35.0404 AlertProcessor ProcessorAlertData: Stopped 2026-01-02 23:29:20.6676 DFramework.Database.Query /* Time Taken: 534*/ [dbo].GenerateSystemAlerts 2026-01-02 23:29:29.6207 AlertProcessor ProcessorAlertData: started 2026-01-02 23:29:35.3239 AlertProcessor ProcessorAlertData: Stopped 2026-01-02 23:29:35.8239 DFramework.Scheduler.TaskBase /* Time Taken: 15687.6146*/ Opportunity Out Of Stock By Outlet 2026-01-02 23:34:22.4511 MoveToReorder Running task for ClientId : 286 and ClientName = India Office QA and Slot: 1/3/2026 1:00:00 PM And LastExecutedOn: 1/3/2026 12:04:22 PM 2026-01-02 23:34:22.6543 MoveToReorder Task executed successfully for ClientId : 286 Client Name:India Office QA, Slot: 1/3/2026 1:00:00 PM But No Order found to suggest 2026-01-02 23:34:29.6387 AlertProcessor ProcessorAlertData: started 2026-01-02 23:34:35.1387 AlertProcessor ProcessorAlertData: Stopped 2026-01-02 23:39:29.6565 AlertProcessor ProcessorAlertData: started 2026-01-02 23:39:35.0003 AlertProcessor ProcessorAlertData: Stopped 2026-01-02 23:44:29.6744 AlertProcessor ProcessorAlertData: started 2026-01-02 23:44:35.0338 AlertProcessor ProcessorAlertData: Stopped 2026-01-02 23:44:35.7838 DFramework.Scheduler.TaskBase /* Time Taken: 15640.7407*/ Opportunity Out Of Stock By Outlet 2026-01-02 23:49:29.6923 AlertProcessor ProcessorAlertData: started 2026-01-02 23:49:35.1299 AlertProcessor ProcessorAlertData: Stopped 2026-01-02 23:54:29.6946 AlertProcessor ProcessorAlertData: started 2026-01-02 23:54:35.1009 AlertProcessor ProcessorAlertData: Stopped 2026-01-02 23:59:29.7125 AlertProcessor ProcessorAlertData: started 2026-01-02 23:59:35.2438 AlertProcessor ProcessorAlertData: Stopped 2026-01-02 23:59:35.8063 DFramework.Scheduler.TaskBase /* Time Taken: 15640.7348*/ Opportunity Out Of Stock By Outlet