2026-01-05 00:04:37.8504 AlertProcessor ProcessorAlertData: started 2026-01-05 00:04:43.3973 AlertProcessor ProcessorAlertData: Stopped 2026-01-05 00:09:37.8527 AlertProcessor ProcessorAlertData: started 2026-01-05 00:09:43.2121 AlertProcessor ProcessorAlertData: Stopped 2026-01-05 00:14:24.9643 DFramework.Database.Query /* Time Taken: 1073*/ 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-05 00:14:37.8706 AlertProcessor ProcessorAlertData: started 2026-01-05 00:14:39.5425 DFramework.Database.Query /* Time Taken: 543*/ DECLARE @TableName AnsiString(8000) SET @TableName = 'AdditionalShelf' DECLARE @CurrentRecordId Int32 SET @CurrentRecordId = '3675619' dbo.GetValidDeviceForAlertProcessData 2026-01-05 00:14:40.2613 DFramework.Scheduler.TaskBase /* Time Taken: 16484.5017*/ Opportunity Out Of Stock By Outlet 2026-01-05 00:14:43.3238 AlertProcessor ProcessorAlertData: Stopped 2026-01-05 00:19:37.8885 AlertProcessor ProcessorAlertData: started 2026-01-05 00:19:43.1698 AlertProcessor ProcessorAlertData: Stopped 2026-01-05 00:24:37.9064 AlertProcessor ProcessorAlertData: started 2026-01-05 00:24:43.3596 AlertProcessor ProcessorAlertData: Stopped 2026-01-05 00:29:37.9244 AlertProcessor ProcessorAlertData: started 2026-01-05 00:29:39.3619 DFramework.Scheduler.TaskBase /* Time Taken: 15562.6158*/ Opportunity Out Of Stock By Outlet 2026-01-05 00:29:43.5182 AlertProcessor ProcessorAlertData: Stopped 2026-01-05 00:34:27.5516 MoveToReorder Running task for ClientId : 286 and ClientName = India Office QA and Slot: 1/5/2026 2:00:00 PM And LastExecutedOn: 1/5/2026 1:04:27 PM 2026-01-05 00:34:37.9423 AlertProcessor ProcessorAlertData: started 2026-01-05 00:34:39.7548 DFramework.Database.Query /* Time Taken: 584*/ DECLARE @TableName AnsiString(8000) SET @TableName = 'AdditionalShelf' DECLARE @CurrentRecordId Int32 SET @CurrentRecordId = '3675619' dbo.GetValidDeviceForAlertProcessData 2026-01-05 00:34:41.2861 DFramework.Database.Query /* Time Taken: 567*/ DECLARE @TableName AnsiString(8000) SET @TableName = 'AssetStockProductWiseConsolidate' DECLARE @CurrentRecordId Int32 SET @CurrentRecordId = '3675619' dbo.GetValidDeviceForAlertProcessData 2026-01-05 00:34:43.8642 AlertProcessor ProcessorAlertData: Stopped 2026-01-05 00:35:06.5050 DFramework.Database.NullableDataReader Data reader open for 38633 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-05 00:35:06.5363 MoveToReorder Task executed successfully for ClientId : 286 Client Name:India Office QA, Slot: 1/5/2026 2:00:00 PM and Total Order Suggested: 127 Out Of: 127 2026-01-05 00:35:07.3800 DFramework.Database.Query /* Time Taken: 832*/ DECLARE @ClientId Int32 SET @ClientId = '286' dbo.GetMoveToReOrderList 2026-01-05 00:35:08.6144 DFramework.Scheduler.TaskBase /* Time Taken: 41375.3099*/ Move To Re-Order 2026-01-05 00:39:37.9602 AlertProcessor ProcessorAlertData: started 2026-01-05 00:39:43.4290 AlertProcessor ProcessorAlertData: Stopped 2026-01-05 00:44:24.3218 DFramework.Database.Query /* Time Taken: 502*/ [dbo].GenerateSystemAlerts 2026-01-05 00:44:37.9781 AlertProcessor ProcessorAlertData: started 2026-01-05 00:44:39.4469 DFramework.Scheduler.TaskBase /* Time Taken: 15625.122*/ Opportunity Out Of Stock By Outlet 2026-01-05 00:44:43.5094 AlertProcessor ProcessorAlertData: Stopped 2026-01-05 00:49:37.9960 AlertProcessor ProcessorAlertData: started 2026-01-05 00:49:43.4648 AlertProcessor ProcessorAlertData: Stopped 2026-01-05 00:54:38.0139 AlertProcessor ProcessorAlertData: started 2026-01-05 00:54:43.2640 AlertProcessor ProcessorAlertData: Stopped 2026-01-05 00:59:24.4380 DFramework.Database.Query /* Time Taken: 602*/ [dbo].GenerateSystemAlerts 2026-01-05 00:59:38.0318 AlertProcessor ProcessorAlertData: started 2026-01-05 00:59:39.5005 DFramework.Scheduler.TaskBase /* Time Taken: 15656.3392*/ Opportunity Out Of Stock By Outlet 2026-01-05 00:59:43.4537 AlertProcessor ProcessorAlertData: Stopped 2026-01-05 01:04:38.0494 AlertProcessor ProcessorAlertData: started 2026-01-05 01:04:43.5025 AlertProcessor ProcessorAlertData: Stopped 2026-01-05 01:09:38.0672 AlertProcessor ProcessorAlertData: started 2026-01-05 01:09:43.6610 AlertProcessor ProcessorAlertData: Stopped 2026-01-05 01:14:38.0804 AlertProcessor ProcessorAlertData: started 2026-01-05 01:14:39.4710 DFramework.Scheduler.TaskBase /* Time Taken: 15609.4891*/ Opportunity Out Of Stock By Outlet 2026-01-05 01:14:43.6273 AlertProcessor ProcessorAlertData: Stopped 2026-01-05 01:19:38.0982 AlertProcessor ProcessorAlertData: started 2026-01-05 01:19:43.5670 AlertProcessor ProcessorAlertData: Stopped 2026-01-05 01:24:38.1161 AlertProcessor ProcessorAlertData: started 2026-01-05 01:24:43.6162 AlertProcessor ProcessorAlertData: Stopped 2026-01-05 01:29:24.3995 DFramework.Database.Query /* Time Taken: 530*/ [dbo].GenerateSystemAlerts 2026-01-05 01:29:38.1340 AlertProcessor ProcessorAlertData: started 2026-01-05 01:29:39.4934 DFramework.Scheduler.TaskBase /* Time Taken: 15609.4987*/ Opportunity Out Of Stock By Outlet 2026-01-05 01:29:43.6809 AlertProcessor ProcessorAlertData: Stopped 2026-01-05 01:34:27.6205 MoveToReorder Running task for ClientId : 286 and ClientName = India Office QA and Slot: 1/5/2026 3:00:00 PM And LastExecutedOn: 1/5/2026 2:04:27 PM 2026-01-05 01:34:27.8549 MoveToReorder Task executed successfully for ClientId : 286 Client Name:India Office QA, Slot: 1/5/2026 3:00:00 PM But No Order found to suggest 2026-01-05 01:34:38.1518 AlertProcessor ProcessorAlertData: started 2026-01-05 01:34:43.6519 AlertProcessor ProcessorAlertData: Stopped 2026-01-05 01:39:38.1696 AlertProcessor ProcessorAlertData: started 2026-01-05 01:39:43.7009 AlertProcessor ProcessorAlertData: Stopped 2026-01-05 01:44:24.4217 DFramework.Database.Query /* Time Taken: 524*/ [dbo].GenerateSystemAlerts 2026-01-05 01:44:38.1875 AlertProcessor ProcessorAlertData: started 2026-01-05 01:44:39.5312 DFramework.Scheduler.TaskBase /* Time Taken: 15625.1194*/ Opportunity Out Of Stock By Outlet 2026-01-05 01:44:43.6719 AlertProcessor ProcessorAlertData: Stopped 2026-01-05 01:49:38.2053 AlertProcessor ProcessorAlertData: started 2026-01-05 01:49:43.6273 AlertProcessor ProcessorAlertData: Stopped 2026-01-05 01:54:38.2232 AlertProcessor ProcessorAlertData: started 2026-01-05 01:54:43.7233 AlertProcessor ProcessorAlertData: Stopped 2026-01-05 01:59:24.4441 DFramework.Database.Query /* Time Taken: 534*/ [dbo].GenerateSystemAlerts 2026-01-05 01:59:38.2255 AlertProcessor ProcessorAlertData: started 2026-01-05 01:59:39.5380 DFramework.Scheduler.TaskBase /* Time Taken: 15625.1188*/ Opportunity Out Of Stock By Outlet 2026-01-05 01:59:43.6161 AlertProcessor ProcessorAlertData: Stopped 2026-01-05 02:04:38.2434 AlertProcessor ProcessorAlertData: started 2026-01-05 02:04:43.7590 AlertProcessor ProcessorAlertData: Stopped 2026-01-05 02:09:38.2612 AlertProcessor ProcessorAlertData: started 2026-01-05 02:09:43.7769 AlertProcessor ProcessorAlertData: Stopped 2026-01-05 02:14:38.2635 AlertProcessor ProcessorAlertData: started 2026-01-05 02:14:39.4978 DFramework.Scheduler.TaskBase /* Time Taken: 15562.6166*/ Opportunity Out Of Stock By Outlet 2026-01-05 02:14:43.8260 AlertProcessor ProcessorAlertData: Stopped 2026-01-05 02:19:38.2813 AlertProcessor ProcessorAlertData: started 2026-01-05 02:19:43.7814 AlertProcessor ProcessorAlertData: Stopped 2026-01-05 02:24:38.2992 AlertProcessor ProcessorAlertData: started 2026-01-05 02:24:43.8617 AlertProcessor ProcessorAlertData: Stopped 2026-01-05 02:29:38.3013 AlertProcessor ProcessorAlertData: started 2026-01-05 02:29:39.5670 DFramework.Scheduler.TaskBase /* Time Taken: 15609.4896*/ Opportunity Out Of Stock By Outlet 2026-01-05 02:29:43.7233 AlertProcessor ProcessorAlertData: Stopped 2026-01-05 02:34:27.8191 MoveToReorder Running task for ClientId : 286 and ClientName = India Office QA and Slot: 1/5/2026 4:00:00 PM And LastExecutedOn: 1/5/2026 3:04:27 PM 2026-01-05 02:34:28.1629 MoveToReorder Task executed successfully for ClientId : 286 Client Name:India Office QA, Slot: 1/5/2026 4:00:00 PM But No Order found to suggest 2026-01-05 02:34:38.3192 AlertProcessor ProcessorAlertData: started 2026-01-05 02:34:43.9130 AlertProcessor ProcessorAlertData: Stopped 2026-01-05 02:39:38.3215 AlertProcessor ProcessorAlertData: started 2026-01-05 02:39:43.9153 AlertProcessor ProcessorAlertData: Stopped 2026-01-05 02:44:24.4798 DFramework.Database.Query /* Time Taken: 511*/ [dbo].GenerateSystemAlerts 2026-01-05 02:44:38.3393 AlertProcessor ProcessorAlertData: started 2026-01-05 02:44:39.6674 DFramework.Scheduler.TaskBase /* Time Taken: 15687.6183*/ Opportunity Out Of Stock By Outlet 2026-01-05 02:44:43.8237 AlertProcessor ProcessorAlertData: Stopped 2026-01-05 02:49:38.3572 AlertProcessor ProcessorAlertData: started 2026-01-05 02:49:44.1072 AlertProcessor ProcessorAlertData: Stopped 2026-01-05 02:54:38.3750 AlertProcessor ProcessorAlertData: started 2026-01-05 02:54:43.8907 AlertProcessor ProcessorAlertData: Stopped 2026-01-05 02:59:24.6897 DFramework.Database.Query /* Time Taken: 706*/ [dbo].GenerateSystemAlerts 2026-01-05 02:59:38.3929 AlertProcessor ProcessorAlertData: started 2026-01-05 02:59:39.7523 DFramework.Scheduler.TaskBase /* Time Taken: 15765.7381*/ Opportunity Out Of Stock By Outlet 2026-01-05 02:59:43.8617 AlertProcessor ProcessorAlertData: Stopped 2026-01-05 03:04:38.4106 AlertProcessor ProcessorAlertData: started 2026-01-05 03:04:43.6450 AlertProcessor ProcessorAlertData: Stopped 2026-01-05 03:09:38.4285 AlertProcessor ProcessorAlertData: started 2026-01-05 03:09:43.8504 AlertProcessor ProcessorAlertData: Stopped 2026-01-05 03:14:25.2119 DFramework.Database.Query /* Time Taken: 1224*/ [dbo].GenerateSystemAlerts 2026-01-05 03:14:38.4464 AlertProcessor ProcessorAlertData: started 2026-01-05 03:14:39.6495 DFramework.Scheduler.TaskBase /* Time Taken: 15656.3671*/ Opportunity Out Of Stock By Outlet 2026-01-05 03:14:43.8995 AlertProcessor ProcessorAlertData: Stopped 2026-01-05 03:19:38.4485 AlertProcessor ProcessorAlertData: started 2026-01-05 03:19:44.0266 AlertProcessor ProcessorAlertData: Stopped 2026-01-05 03:24:38.4507 AlertProcessor ProcessorAlertData: started 2026-01-05 03:24:43.7476 AlertProcessor ProcessorAlertData: Stopped 2026-01-05 03:29:38.4529 AlertProcessor ProcessorAlertData: started 2026-01-05 03:29:39.5779 DFramework.Scheduler.TaskBase /* Time Taken: 15578.2379*/ Opportunity Out Of Stock By Outlet 2026-01-05 03:29:43.6404 AlertProcessor ProcessorAlertData: Stopped 2026-01-05 03:34:27.9238 MoveToReorder Running task for ClientId : 286 and ClientName = India Office QA and Slot: 1/5/2026 5:00:00 PM And LastExecutedOn: 1/5/2026 4:04:27 PM 2026-01-05 03:34:38.4551 AlertProcessor ProcessorAlertData: started 2026-01-05 03:34:43.9708 AlertProcessor ProcessorAlertData: Stopped 2026-01-05 03:35:07.1428 DFramework.Database.NullableDataReader Data reader open for 38874 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-05 03:35:07.1741 MoveToReorder Task executed successfully for ClientId : 286 Client Name:India Office QA, Slot: 1/5/2026 5:00:00 PM and Total Order Suggested: 127 Out Of: 127 2026-01-05 03:35:08.4085 DFramework.Scheduler.TaskBase /* Time Taken: 40906.5549*/ Move To Re-Order 2026-01-05 03:39:38.4574 AlertProcessor ProcessorAlertData: started 2026-01-05 03:39:43.9105 AlertProcessor ProcessorAlertData: Stopped 2026-01-05 03:44:24.5533 DFramework.Database.Query /* Time Taken: 532*/ [dbo].GenerateSystemAlerts 2026-01-05 03:44:26.1783 DFramework.Database.Query /* Time Taken: 2048*/ 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-05 03:44:38.4596 AlertProcessor ProcessorAlertData: started 2026-01-05 03:44:41.5534 DFramework.Scheduler.TaskBase /* Time Taken: 17531.3883*/ Opportunity Out Of Stock By Outlet 2026-01-05 03:44:43.8346 AlertProcessor ProcessorAlertData: Stopped 2026-01-05 03:49:38.4775 AlertProcessor ProcessorAlertData: started 2026-01-05 03:49:43.6650 AlertProcessor ProcessorAlertData: Stopped 2026-01-05 03:54:38.4952 AlertProcessor ProcessorAlertData: started 2026-01-05 03:54:39.9952 DFramework.Database.NullableDataReader Data reader open for 270 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-05 03:54:43.9952 AlertProcessor ProcessorAlertData: Stopped 2026-01-05 03:59:24.6692 DFramework.Database.Query /* Time Taken: 633*/ [dbo].GenerateSystemAlerts 2026-01-05 03:59:38.5130 AlertProcessor ProcessorAlertData: started 2026-01-05 03:59:39.7162 DFramework.Scheduler.TaskBase /* Time Taken: 15671.99*/ Opportunity Out Of Stock By Outlet 2026-01-05 03:59:43.6849 AlertProcessor ProcessorAlertData: Stopped 2026-01-05 04:04:38.5309 AlertProcessor ProcessorAlertData: started 2026-01-05 04:04:43.6716 AlertProcessor ProcessorAlertData: Stopped 2026-01-05 04:09:38.5488 AlertProcessor ProcessorAlertData: started 2026-01-05 04:09:43.5644 AlertProcessor ProcessorAlertData: Stopped 2026-01-05 04:14:24.8165 DFramework.Database.Query /* Time Taken: 763*/ [dbo].GenerateSystemAlerts 2026-01-05 04:14:38.5666 AlertProcessor ProcessorAlertData: started 2026-01-05 04:14:39.0666 DFramework.Database.Query /* Time Taken: 510*/ DECLARE @TableName AnsiString(8000) SET @TableName = 'TagAlert' DECLARE @CurrentRecordId Int32 SET @CurrentRecordId = '0' dbo.GetValidDeviceForAlertProcessData 2026-01-05 04:14:39.8635 DFramework.Scheduler.TaskBase /* Time Taken: 15796.9983*/ Opportunity Out Of Stock By Outlet 2026-01-05 04:14:44.2229 AlertProcessor ProcessorAlertData: Stopped 2026-01-05 04:19:38.5845 AlertProcessor ProcessorAlertData: started 2026-01-05 04:19:43.8345 AlertProcessor ProcessorAlertData: Stopped 2026-01-05 04:24:38.5867 AlertProcessor ProcessorAlertData: started 2026-01-05 04:24:44.1336 AlertProcessor ProcessorAlertData: Stopped 2026-01-05 04:29:24.8074 DFramework.Database.Query /* Time Taken: 720*/ [dbo].GenerateSystemAlerts 2026-01-05 04:29:38.6044 AlertProcessor ProcessorAlertData: started 2026-01-05 04:29:39.8544 DFramework.Scheduler.TaskBase /* Time Taken: 15765.7393*/ Opportunity Out Of Stock By Outlet 2026-01-05 04:29:44.1982 AlertProcessor ProcessorAlertData: Stopped 2026-01-05 04:34:27.9190 MoveToReorder Running task for ClientId : 286 and ClientName = India Office QA and Slot: 1/5/2026 6:00:00 PM And LastExecutedOn: 1/5/2026 5:04:27 PM 2026-01-05 04:34:28.1690 MoveToReorder Task executed successfully for ClientId : 286 Client Name:India Office QA, Slot: 1/5/2026 6:00:00 PM But No Order found to suggest 2026-01-05 04:34:38.6222 AlertProcessor ProcessorAlertData: started 2026-01-05 04:34:43.6222 AlertProcessor ProcessorAlertData: Stopped 2026-01-05 04:39:38.6401 AlertProcessor ProcessorAlertData: started 2026-01-05 04:39:43.7339 AlertProcessor ProcessorAlertData: Stopped 2026-01-05 04:44:38.6579 AlertProcessor ProcessorAlertData: started 2026-01-05 04:44:39.7360 DFramework.Scheduler.TaskBase /* Time Taken: 15625.1181*/ Opportunity Out Of Stock By Outlet 2026-01-05 04:44:43.7205 AlertProcessor ProcessorAlertData: Stopped 2026-01-05 04:49:38.6758 AlertProcessor ProcessorAlertData: started 2026-01-05 04:49:39.1758 DFramework.Database.NullableDataReader Data reader open for 240 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-05 04:49:39.8164 DFramework.Database.NullableDataReader Data reader open for 380 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-05 04:49:39.8789 DFramework.Database.NullableDataReader Data reader open for 465 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-05 04:49:40.5664 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-05 04:49:41.2383 DFramework.Database.NullableDataReader Data reader open for 303 at System.Environment.GetStackTrace(Exception e, Boolean needFileInfo) at System.Environment.get_StackTrace() at DFramework.Database.NullableDataReader.Dispose(Boolean disposing) in 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-05 04:49:41.7227 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-05 04:49:41.7852 DFramework.Database.NullableDataReader Data reader open for 331 at System.Environment.GetStackTrace(Exception e, Boolean needFileInfo) at System.Environment.get_StackTrace() at DFramework.Database.NullableDataReader.Dispose(Boolean disposing) in 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-05 04:49:42.3164 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-05 04:49:42.3789 DFramework.Database.NullableDataReader Data reader open for 372 at System.Environment.GetStackTrace(Exception e, Boolean needFileInfo) at System.Environment.get_StackTrace() at DFramework.Database.NullableDataReader.Dispose(Boolean disposing) in 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-05 04:49:42.9727 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-05 04:49:43.0196 DFramework.Database.NullableDataReader Data reader open for 440 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-05 04:49:44.0977 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-05 04:49:44.1446 DFramework.Database.NullableDataReader Data reader open for 359 at System.Environment.GetStackTrace(Exception e, Boolean needFileInfo) at System.Environment.get_StackTrace() at DFramework.Database.NullableDataReader.Dispose(Boolean disposing) in 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-05 04:49:44.4415 AlertProcessor Replace Tags updated for the Image Id: 3675635 2026-01-05 04:49:44.5977 DFramework.Database.NullableDataReader Data reader open for 249 at System.Environment.GetStackTrace(Exception e, Boolean needFileInfo) at System.Environment.get_StackTrace() at DFramework.Database.NullableDataReader.Dispose(Boolean disposing) in 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-05 04:49:45.1133 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-05 04:49:45.1758 DFramework.Database.NullableDataReader Data reader open for 368 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-05 04:49:45.9102 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-05 04:49:45.9727 DFramework.Database.NullableDataReader Data reader open for 303 at System.Environment.GetStackTrace(Exception e, Boolean needFileInfo) at System.Environment.get_StackTrace() at DFramework.Database.NullableDataReader.Dispose(Boolean disposing) in 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-05 04:49:46.7383 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-05 04:49:47.3790 AlertProcessor ProcessorAlertData: Stopped 2026-01-05 04:54:38.6937 AlertProcessor ProcessorAlertData: started 2026-01-05 04:54:43.7562 AlertProcessor ProcessorAlertData: Stopped 2026-01-05 04:59:24.8052 DFramework.Database.Query /* Time Taken: 687*/ [dbo].GenerateSystemAlerts 2026-01-05 04:59:38.7115 AlertProcessor ProcessorAlertData: started 2026-01-05 04:59:40.0865 DFramework.Scheduler.TaskBase /* Time Taken: 15968.8737*/ Opportunity Out Of Stock By Outlet 2026-01-05 04:59:43.8678 AlertProcessor ProcessorAlertData: Stopped 2026-01-05 05:04:38.7137 AlertProcessor ProcessorAlertData: started 2026-01-05 05:04:43.9325 AlertProcessor ProcessorAlertData: Stopped 2026-01-05 05:09:38.7316 AlertProcessor ProcessorAlertData: started 2026-01-05 05:09:43.7004 AlertProcessor ProcessorAlertData: Stopped 2026-01-05 05:14:38.7495 AlertProcessor ProcessorAlertData: started 2026-01-05 05:14:39.7495 DFramework.Scheduler.TaskBase /* Time Taken: 15625.1205*/ Opportunity Out Of Stock By Outlet 2026-01-05 05:14:44.0308 AlertProcessor ProcessorAlertData: Stopped 2026-01-05 05:19:38.7517 AlertProcessor ProcessorAlertData: started 2026-01-05 05:19:44.0643 AlertProcessor ProcessorAlertData: Stopped 2026-01-05 05:24:38.7696 AlertProcessor ProcessorAlertData: started 2026-01-05 05:24:43.8478 AlertProcessor ProcessorAlertData: Stopped 2026-01-05 05:29:38.7875 AlertProcessor ProcessorAlertData: started 2026-01-05 05:29:39.6781 DFramework.Scheduler.TaskBase /* Time Taken: 15531.3633*/ Opportunity Out Of Stock By Outlet 2026-01-05 05:29:43.7250 AlertProcessor ProcessorAlertData: Stopped 2026-01-05 05:34:28.0395 MoveToReorder Running task for ClientId : 286 and ClientName = India Office QA and Slot: 1/5/2026 7:00:00 PM And LastExecutedOn: 1/5/2026 6:04:27 PM 2026-01-05 05:34:28.4927 MoveToReorder Task executed successfully for ClientId : 286 Client Name:India Office QA, Slot: 1/5/2026 7:00:00 PM and Total Order Suggested: 1 Out Of: 1 2026-01-05 05:34:38.8052 AlertProcessor ProcessorAlertData: started 2026-01-05 05:34:43.8834 AlertProcessor ProcessorAlertData: Stopped 2026-01-05 05:39:38.8230 AlertProcessor ProcessorAlertData: started 2026-01-05 05:39:43.8699 AlertProcessor ProcessorAlertData: Stopped 2026-01-05 05:44:24.7939 DFramework.Database.Query /* Time Taken: 632*/ [dbo].GenerateSystemAlerts 2026-01-05 05:44:38.8409 AlertProcessor ProcessorAlertData: started 2026-01-05 05:44:39.9346 DFramework.Scheduler.TaskBase /* Time Taken: 15765.7424*/ Opportunity Out Of Stock By Outlet 2026-01-05 05:44:43.9034 AlertProcessor ProcessorAlertData: Stopped 2026-01-05 05:49:38.8587 AlertProcessor ProcessorAlertData: started 2026-01-05 05:49:42.2963 DFramework.Database.Query /* Time Taken: 748*/ DECLARE @TableName AnsiString(8000) SET @TableName = 'AssetStockProductWiseConsolidate' DECLARE @CurrentRecordId Int32 SET @CurrentRecordId = '3675635' dbo.GetValidDeviceForAlertProcessData 2026-01-05 05:49:44.7338 AlertProcessor ProcessorAlertData: Stopped 2026-01-05 05:54:38.8766 AlertProcessor ProcessorAlertData: started 2026-01-05 05:54:43.8610 AlertProcessor ProcessorAlertData: Stopped 2026-01-05 05:59:24.7693 DFramework.Database.Query /* Time Taken: 586*/ [dbo].GenerateSystemAlerts 2026-01-05 05:59:38.8944 AlertProcessor ProcessorAlertData: started 2026-01-05 05:59:39.8632 DFramework.Scheduler.TaskBase /* Time Taken: 15671.9948*/ Opportunity Out Of Stock By Outlet 2026-01-05 05:59:43.9257 AlertProcessor ProcessorAlertData: Stopped 2026-01-05 06:04:38.8967 AlertProcessor ProcessorAlertData: started 2026-01-05 06:04:43.8655 AlertProcessor ProcessorAlertData: Stopped 2026-01-05 06:09:38.8987 AlertProcessor ProcessorAlertData: started 2026-01-05 06:09:43.9613 AlertProcessor ProcessorAlertData: Stopped 2026-01-05 06:14:24.7445 DFramework.Database.Query /* Time Taken: 534*/ [dbo].GenerateSystemAlerts 2026-01-05 06:14:38.9009 AlertProcessor ProcessorAlertData: started 2026-01-05 06:14:39.9634 DFramework.Scheduler.TaskBase /* Time Taken: 15750.1197*/ Opportunity Out Of Stock By Outlet 2026-01-05 06:14:43.8384 AlertProcessor ProcessorAlertData: Stopped 2026-01-05 06:19:38.9187 AlertProcessor ProcessorAlertData: started 2026-01-05 06:19:44.1219 AlertProcessor ProcessorAlertData: Stopped 2026-01-05 06:24:38.9364 AlertProcessor ProcessorAlertData: started 2026-01-05 06:24:44.1864 AlertProcessor ProcessorAlertData: Stopped 2026-01-05 06:29:24.8599 DFramework.Database.Query /* Time Taken: 653*/ [dbo].GenerateSystemAlerts 2026-01-05 06:29:38.9537 AlertProcessor ProcessorAlertData: started 2026-01-05 06:29:39.9381 DFramework.Scheduler.TaskBase /* Time Taken: 15718.8433*/ Opportunity Out Of Stock By Outlet 2026-01-05 06:29:44.0632 AlertProcessor ProcessorAlertData: Stopped 2026-01-05 06:34:28.1901 MoveToReorder Running task for ClientId : 286 and ClientName = India Office QA and Slot: 1/5/2026 8:00:00 PM And LastExecutedOn: 1/5/2026 7:04:27 PM 2026-01-05 06:34:38.9715 AlertProcessor ProcessorAlertData: started 2026-01-05 06:34:44.1746 AlertProcessor ProcessorAlertData: Stopped 2026-01-05 06:35:07.4404 DFramework.Database.NullableDataReader Data reader open for 38900 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-05 06:35:07.4717 MoveToReorder Task executed successfully for ClientId : 286 Client Name:India Office QA, Slot: 1/5/2026 8:00:00 PM and Total Order Suggested: 126 Out Of: 126 2026-01-05 06:35:08.5967 DFramework.Scheduler.TaskBase /* Time Taken: 40812.8403*/ Move To Re-Order 2026-01-05 06:39:38.9893 AlertProcessor ProcessorAlertData: started 2026-01-05 06:39:44.2394 AlertProcessor ProcessorAlertData: Stopped 2026-01-05 06:44:25.4602 DFramework.Database.Query /* Time Taken: 1228*/ [dbo].GenerateSystemAlerts 2026-01-05 06:44:39.0072 AlertProcessor ProcessorAlertData: started 2026-01-05 06:44:39.9447 DFramework.Scheduler.TaskBase /* Time Taken: 15703.2395*/ Opportunity Out Of Stock By Outlet 2026-01-05 06:44:44.3979 AlertProcessor ProcessorAlertData: Stopped 2026-01-05 06:49:39.0251 AlertProcessor ProcessorAlertData: started 2026-01-05 06:49:44.1032 AlertProcessor ProcessorAlertData: Stopped 2026-01-05 06:54:39.0429 AlertProcessor ProcessorAlertData: started 2026-01-05 06:54:43.9649 AlertProcessor ProcessorAlertData: Stopped 2026-01-05 06:59:24.8263 DFramework.Database.Query /* Time Taken: 562*/ [dbo].GenerateSystemAlerts 2026-01-05 06:59:39.0608 AlertProcessor ProcessorAlertData: started 2026-01-05 06:59:39.8889 DFramework.Scheduler.TaskBase /* Time Taken: 15625.1091*/ Opportunity Out Of Stock By Outlet 2026-01-05 06:59:44.0452 AlertProcessor ProcessorAlertData: Stopped 2026-01-05 07:04:39.0786 AlertProcessor ProcessorAlertData: started 2026-01-05 07:04:44.0474 AlertProcessor ProcessorAlertData: Stopped 2026-01-05 07:09:39.0965 AlertProcessor ProcessorAlertData: started 2026-01-05 07:09:44.0809 AlertProcessor ProcessorAlertData: Stopped 2026-01-05 07:14:24.8642 DFramework.Database.Query /* Time Taken: 593*/ [dbo].GenerateSystemAlerts 2026-01-05 07:14:39.0987 AlertProcessor ProcessorAlertData: started 2026-01-05 07:14:39.8018 DFramework.Scheduler.TaskBase /* Time Taken: 15531.3716*/ Opportunity Out Of Stock By Outlet 2026-01-05 07:14:44.0362 AlertProcessor ProcessorAlertData: Stopped 2026-01-05 07:19:39.1159 AlertProcessor ProcessorAlertData: started 2026-01-05 07:19:44.1472 AlertProcessor ProcessorAlertData: Stopped 2026-01-05 07:24:39.1335 AlertProcessor ProcessorAlertData: started 2026-01-05 07:24:44.1336 AlertProcessor ProcessorAlertData: Stopped 2026-01-05 07:29:24.7763 DFramework.Database.Query /* Time Taken: 501*/ [dbo].GenerateSystemAlerts 2026-01-05 07:29:39.1514 AlertProcessor ProcessorAlertData: started 2026-01-05 07:29:39.9639 DFramework.Scheduler.TaskBase /* Time Taken: 15687.6281*/ Opportunity Out Of Stock By Outlet 2026-01-05 07:29:44.1358 AlertProcessor ProcessorAlertData: Stopped 2026-01-05 07:34:28.2948 MoveToReorder Running task for ClientId : 286 and ClientName = India Office QA and Slot: 1/5/2026 9:00:00 PM And LastExecutedOn: 1/5/2026 8:04:28 PM 2026-01-05 07:34:28.5917 MoveToReorder Task executed successfully for ClientId : 286 Client Name:India Office QA, Slot: 1/5/2026 9:00:00 PM But No Order found to suggest 2026-01-05 07:34:39.1543 AlertProcessor ProcessorAlertData: started 2026-01-05 07:34:44.2169 AlertProcessor ProcessorAlertData: Stopped 2026-01-05 07:39:39.1727 AlertProcessor ProcessorAlertData: started 2026-01-05 07:39:40.8446 DFramework.Database.NullableDataReader Data reader open for 280 at System.Environment.GetStackTrace(Exception e, Boolean needFileInfo) at System.Environment.get_StackTrace() at DFramework.Database.NullableDataReader.Dispose(Boolean disposing) in 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-05 07:39:44.3446 AlertProcessor ProcessorAlertData: Stopped 2026-01-05 07:44:39.1907 AlertProcessor ProcessorAlertData: started 2026-01-05 07:44:39.8938 DFramework.Scheduler.TaskBase /* Time Taken: 15609.4864*/ Opportunity Out Of Stock By Outlet 2026-01-05 07:44:44.2688 AlertProcessor ProcessorAlertData: Stopped 2026-01-05 07:49:39.2082 AlertProcessor ProcessorAlertData: started 2026-01-05 07:49:44.2239 AlertProcessor ProcessorAlertData: Stopped 2026-01-05 07:54:39.2248 AlertProcessor ProcessorAlertData: started 2026-01-05 07:54:44.2874 AlertProcessor ProcessorAlertData: Stopped 2026-01-05 07:59:39.2423 AlertProcessor ProcessorAlertData: started 2026-01-05 07:59:39.8986 DFramework.Scheduler.TaskBase /* Time Taken: 15593.8446*/ Opportunity Out Of Stock By Outlet 2026-01-05 07:59:44.1799 AlertProcessor ProcessorAlertData: Stopped 2026-01-05 08:04:39.2601 AlertProcessor ProcessorAlertData: started 2026-01-05 08:04:44.2758 AlertProcessor ProcessorAlertData: Stopped 2026-01-05 08:09:39.2775 AlertProcessor ProcessorAlertData: started 2026-01-05 08:09:44.3088 AlertProcessor ProcessorAlertData: Stopped 2026-01-05 08:14:24.9201 DFramework.Database.Query /* Time Taken: 608*/ [dbo].GenerateSystemAlerts 2026-01-05 08:14:39.2952 AlertProcessor ProcessorAlertData: started 2026-01-05 08:14:40.0921 DFramework.Scheduler.TaskBase /* Time Taken: 15765.7372*/ Opportunity Out Of Stock By Outlet 2026-01-05 08:14:41.4827 DFramework.Database.NullableDataReader Data reader open for 270 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-05 08:14:44.4984 AlertProcessor ProcessorAlertData: Stopped 2026-01-05 08:19:39.3130 AlertProcessor ProcessorAlertData: started 2026-01-05 08:19:44.2662 AlertProcessor ProcessorAlertData: Stopped 2026-01-05 08:24:39.3309 AlertProcessor ProcessorAlertData: started 2026-01-05 08:24:44.3622 AlertProcessor ProcessorAlertData: Stopped 2026-01-05 08:29:24.8331 DFramework.Database.Query /* Time Taken: 506*/ [dbo].GenerateSystemAlerts 2026-01-05 08:29:39.3332 AlertProcessor ProcessorAlertData: started 2026-01-05 08:29:40.0364 DFramework.Scheduler.TaskBase /* Time Taken: 15703.2422*/ Opportunity Out Of Stock By Outlet 2026-01-05 08:29:44.6770 AlertProcessor ProcessorAlertData: Stopped 2026-01-05 08:34:28.3041 MoveToReorder Running task for ClientId : 286 and ClientName = India Office QA and Slot: 1/5/2026 10:00:00 PM And LastExecutedOn: 1/5/2026 9:04:28 PM 2026-01-05 08:34:28.6635 MoveToReorder Task executed successfully for ClientId : 286 Client Name:India Office QA, Slot: 1/5/2026 10:00:00 PM But No Order found to suggest 2026-01-05 08:34:39.3511 AlertProcessor ProcessorAlertData: started 2026-01-05 08:34:44.4136 AlertProcessor ProcessorAlertData: Stopped 2026-01-05 08:39:39.3533 AlertProcessor ProcessorAlertData: started 2026-01-05 08:39:44.8534 AlertProcessor ProcessorAlertData: Stopped 2026-01-05 08:44:25.1367 DFramework.Database.Query /* Time Taken: 674*/ 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-05 08:44:39.3712 AlertProcessor ProcessorAlertData: started 2026-01-05 08:44:40.4337 DFramework.Scheduler.TaskBase /* Time Taken: 16078.2419*/ Opportunity Out Of Stock By Outlet 2026-01-05 08:44:44.8556 AlertProcessor ProcessorAlertData: Stopped 2026-01-05 08:49:39.3890 AlertProcessor ProcessorAlertData: started 2026-01-05 08:49:42.3734 DFramework.Database.Query /* Time Taken: 512*/ DECLARE @TableName AnsiString(8000) SET @TableName = 'AssetStockProductWiseConsolidate' DECLARE @CurrentRecordId Int32 SET @CurrentRecordId = '3675635' dbo.GetValidDeviceForAlertProcessData 2026-01-05 08:49:44.8578 AlertProcessor ProcessorAlertData: Stopped 2026-01-05 08:54:39.3912 AlertProcessor ProcessorAlertData: started 2026-01-05 08:54:44.9225 AlertProcessor ProcessorAlertData: Stopped 2026-01-05 08:59:24.9090 DFramework.Database.Query /* Time Taken: 543*/ [dbo].GenerateSystemAlerts 2026-01-05 08:59:39.3935 AlertProcessor ProcessorAlertData: started 2026-01-05 08:59:39.9873 DFramework.Scheduler.TaskBase /* Time Taken: 15609.4914*/ Opportunity Out Of Stock By Outlet 2026-01-05 08:59:44.9248 AlertProcessor ProcessorAlertData: Stopped 2026-01-05 09:04:39.4114 AlertProcessor ProcessorAlertData: started 2026-01-05 09:04:44.9583 AlertProcessor ProcessorAlertData: Stopped 2026-01-05 09:09:39.4292 AlertProcessor ProcessorAlertData: started 2026-01-05 09:09:44.9293 AlertProcessor ProcessorAlertData: Stopped 2026-01-05 09:14:24.9157 DFramework.Database.Query /* Time Taken: 522*/ [dbo].GenerateSystemAlerts 2026-01-05 09:14:39.4471 AlertProcessor ProcessorAlertData: started 2026-01-05 09:14:40.0252 DFramework.Scheduler.TaskBase /* Time Taken: 15625.1139*/ Opportunity Out Of Stock By Outlet 2026-01-05 09:14:44.9784 AlertProcessor ProcessorAlertData: Stopped 2026-01-05 09:19:39.4493 AlertProcessor ProcessorAlertData: started 2026-01-05 09:19:44.9962 AlertProcessor ProcessorAlertData: Stopped 2026-01-05 09:24:39.4516 AlertProcessor ProcessorAlertData: started 2026-01-05 09:24:44.8735 AlertProcessor ProcessorAlertData: Stopped 2026-01-05 09:29:24.9224 DFramework.Database.Query /* Time Taken: 513*/ [dbo].GenerateSystemAlerts 2026-01-05 09:29:39.4538 AlertProcessor ProcessorAlertData: started 2026-01-05 09:29:40.0007 DFramework.Scheduler.TaskBase /* Time Taken: 15578.2415*/ Opportunity Out Of Stock By Outlet 2026-01-05 09:29:44.9694 AlertProcessor ProcessorAlertData: Stopped 2026-01-05 09:34:39.4717 AlertProcessor ProcessorAlertData: started 2026-01-05 09:34:44.7842 AlertProcessor ProcessorAlertData: Stopped 2026-01-05 09:39:39.4896 AlertProcessor ProcessorAlertData: started 2026-01-05 09:39:44.8959 AlertProcessor ProcessorAlertData: Stopped 2026-01-05 09:44:24.9761 DFramework.Database.Query /* Time Taken: 538*/ [dbo].GenerateSystemAlerts 2026-01-05 09:44:39.4918 AlertProcessor ProcessorAlertData: started 2026-01-05 09:44:40.0543 DFramework.Scheduler.TaskBase /* Time Taken: 15609.4932*/ Opportunity Out Of Stock By Outlet 2026-01-05 09:44:45.0075 AlertProcessor ProcessorAlertData: Stopped 2026-01-05 09:49:39.4941 AlertProcessor ProcessorAlertData: started 2026-01-05 09:49:44.9629 AlertProcessor ProcessorAlertData: Stopped 2026-01-05 09:54:39.5119 AlertProcessor ProcessorAlertData: started 2026-01-05 09:54:45.0745 AlertProcessor ProcessorAlertData: Stopped 2026-01-05 09:59:24.9828 DFramework.Database.Query /* Time Taken: 527*/ [dbo].GenerateSystemAlerts 2026-01-05 09:59:39.5298 AlertProcessor ProcessorAlertData: started 2026-01-05 09:59:40.0767 DFramework.Scheduler.TaskBase /* Time Taken: 15609.4894*/ Opportunity Out Of Stock By Outlet 2026-01-05 09:59:45.0142 AlertProcessor ProcessorAlertData: Stopped 2026-01-05 10:04:39.5476 AlertProcessor ProcessorAlertData: started 2026-01-05 10:04:44.9852 AlertProcessor ProcessorAlertData: Stopped 2026-01-05 10:09:39.5655 AlertProcessor ProcessorAlertData: started 2026-01-05 10:09:45.0499 AlertProcessor ProcessorAlertData: Stopped 2026-01-05 10:14:24.9895 DFramework.Database.Query /* Time Taken: 505*/ [dbo].GenerateSystemAlerts 2026-01-05 10:14:39.5834 AlertProcessor ProcessorAlertData: started 2026-01-05 10:14:40.0521 DFramework.Scheduler.TaskBase /* Time Taken: 15562.6389*/ Opportunity Out Of Stock By Outlet 2026-01-05 10:14:45.0209 AlertProcessor ProcessorAlertData: Stopped 2026-01-05 10:19:39.6012 AlertProcessor ProcessorAlertData: started 2026-01-05 10:19:45.1169 AlertProcessor ProcessorAlertData: Stopped 2026-01-05 10:24:39.6191 AlertProcessor ProcessorAlertData: started 2026-01-05 10:24:45.0723 AlertProcessor ProcessorAlertData: Stopped 2026-01-05 10:29:39.6370 AlertProcessor ProcessorAlertData: started 2026-01-05 10:29:40.0745 DFramework.Scheduler.TaskBase /* Time Taken: 15562.6159*/ Opportunity Out Of Stock By Outlet 2026-01-05 10:29:45.1215 AlertProcessor ProcessorAlertData: Stopped 2026-01-05 10:34:39.6393 AlertProcessor ProcessorAlertData: started 2026-01-05 10:34:45.1237 AlertProcessor ProcessorAlertData: Stopped 2026-01-05 10:39:39.6415 AlertProcessor ProcessorAlertData: started 2026-01-05 10:39:45.0478 DFramework.Database.Query /* Time Taken: 509*/ DECLARE @TableName AnsiString(8000) SET @TableName = 'ProductStockLevel' DECLARE @CurrentRecordId Int32 SET @CurrentRecordId = '3675635' dbo.GetValidDeviceForAlertProcessData 2026-01-05 10:39:45.0947 AlertProcessor ProcessorAlertData: Stopped 2026-01-05 10:44:39.6594 AlertProcessor ProcessorAlertData: started 2026-01-05 10:44:40.0969 DFramework.Scheduler.TaskBase /* Time Taken: 15562.613*/ Opportunity Out Of Stock By Outlet 2026-01-05 10:44:45.1439 AlertProcessor ProcessorAlertData: Stopped 2026-01-05 10:49:39.6773 AlertProcessor ProcessorAlertData: started 2026-01-05 10:49:45.1305 AlertProcessor ProcessorAlertData: Stopped 2026-01-05 10:54:39.6951 AlertProcessor ProcessorAlertData: started 2026-01-05 10:54:45.2733 AlertProcessor ProcessorAlertData: Stopped 2026-01-05 10:59:25.0566 DFramework.Database.Query /* Time Taken: 502*/ [dbo].GenerateSystemAlerts 2026-01-05 10:59:39.7130 AlertProcessor ProcessorAlertData: started 2026-01-05 10:59:40.1349 DFramework.Scheduler.TaskBase /* Time Taken: 15578.2417*/ Opportunity Out Of Stock By Outlet 2026-01-05 10:59:45.2443 AlertProcessor ProcessorAlertData: Stopped 2026-01-05 11:04:39.7308 AlertProcessor ProcessorAlertData: started 2026-01-05 11:04:45.2621 AlertProcessor ProcessorAlertData: Stopped 2026-01-05 11:09:39.7487 AlertProcessor ProcessorAlertData: started 2026-01-05 11:09:45.2956 AlertProcessor ProcessorAlertData: Stopped 2026-01-05 11:14:25.1258 DFramework.Database.Query /* Time Taken: 547*/ [dbo].GenerateSystemAlerts 2026-01-05 11:14:39.7665 AlertProcessor ProcessorAlertData: started 2026-01-05 11:14:40.1259 DFramework.Scheduler.TaskBase /* Time Taken: 15546.9974*/ Opportunity Out Of Stock By Outlet 2026-01-05 11:14:45.3135 AlertProcessor ProcessorAlertData: Stopped 2026-01-05 11:19:39.7845 AlertProcessor ProcessorAlertData: started 2026-01-05 11:19:45.2533 AlertProcessor ProcessorAlertData: Stopped 2026-01-05 11:24:39.7867 AlertProcessor ProcessorAlertData: started 2026-01-05 11:24:45.2243 AlertProcessor ProcessorAlertData: Stopped 2026-01-05 11:29:39.7889 AlertProcessor ProcessorAlertData: started 2026-01-05 11:29:40.1639 DFramework.Scheduler.TaskBase /* Time Taken: 15562.6202*/ Opportunity Out Of Stock By Outlet 2026-01-05 11:29:45.3202 AlertProcessor ProcessorAlertData: Stopped 2026-01-05 11:34:39.8068 AlertProcessor ProcessorAlertData: started 2026-01-05 11:34:45.2287 AlertProcessor ProcessorAlertData: Stopped 2026-01-05 11:39:39.8090 AlertProcessor ProcessorAlertData: started 2026-01-05 11:39:45.2466 AlertProcessor ProcessorAlertData: Stopped 2026-01-05 11:44:25.1393 DFramework.Database.Query /* Time Taken: 522*/ [dbo].GenerateSystemAlerts 2026-01-05 11:44:39.8269 AlertProcessor ProcessorAlertData: started 2026-01-05 11:44:40.2019 DFramework.Scheduler.TaskBase /* Time Taken: 15578.2452*/ Opportunity Out Of Stock By Outlet 2026-01-05 11:44:45.3269 AlertProcessor ProcessorAlertData: Stopped 2026-01-05 11:49:39.8448 AlertProcessor ProcessorAlertData: started 2026-01-05 11:49:45.1729 AlertProcessor ProcessorAlertData: Stopped 2026-01-05 11:54:39.8471 AlertProcessor ProcessorAlertData: started 2026-01-05 11:54:45.3315 AlertProcessor ProcessorAlertData: Stopped 2026-01-05 11:59:25.1617 DFramework.Database.Query /* Time Taken: 528*/ [dbo].GenerateSystemAlerts 2026-01-05 11:59:39.8650 AlertProcessor ProcessorAlertData: started 2026-01-05 11:59:40.2712 DFramework.Scheduler.TaskBase /* Time Taken: 15625.1236*/ Opportunity Out Of Stock By Outlet 2026-01-05 11:59:45.2556 AlertProcessor ProcessorAlertData: Stopped 2026-01-05 12:04:39.8828 AlertProcessor ProcessorAlertData: started 2026-01-05 12:04:45.3985 AlertProcessor ProcessorAlertData: Stopped 2026-01-05 12:09:39.9007 AlertProcessor ProcessorAlertData: started 2026-01-05 12:09:45.3226 AlertProcessor ProcessorAlertData: Stopped 2026-01-05 12:14:25.2466 DFramework.Database.Query /* Time Taken: 590*/ [dbo].GenerateSystemAlerts 2026-01-05 12:14:39.9186 AlertProcessor ProcessorAlertData: started 2026-01-05 12:14:40.2779 DFramework.Scheduler.TaskBase /* Time Taken: 15609.4949*/ Opportunity Out Of Stock By Outlet 2026-01-05 12:14:45.3092 AlertProcessor ProcessorAlertData: Stopped 2026-01-05 12:19:39.9364 AlertProcessor ProcessorAlertData: started 2026-01-05 12:19:45.2802 AlertProcessor ProcessorAlertData: Stopped 2026-01-05 12:24:39.9542 AlertProcessor ProcessorAlertData: started 2026-01-05 12:24:45.3761 AlertProcessor ProcessorAlertData: Stopped 2026-01-05 12:29:25.2063 DFramework.Database.Query /* Time Taken: 516*/ [dbo].GenerateSystemAlerts 2026-01-05 12:29:39.9720 AlertProcessor ProcessorAlertData: started 2026-01-05 12:29:40.2689 DFramework.Scheduler.TaskBase /* Time Taken: 15578.2409*/ Opportunity Out Of Stock By Outlet 2026-01-05 12:29:45.5033 AlertProcessor ProcessorAlertData: Stopped 2026-01-05 12:34:39.9898 AlertProcessor ProcessorAlertData: started 2026-01-05 12:34:45.3493 AlertProcessor ProcessorAlertData: Stopped 2026-01-05 12:39:40.0077 AlertProcessor ProcessorAlertData: started 2026-01-05 12:39:45.4921 AlertProcessor ProcessorAlertData: Stopped 2026-01-05 12:44:25.2754 DFramework.Database.Query /* Time Taken: 571*/ [dbo].GenerateSystemAlerts 2026-01-05 12:44:40.0256 AlertProcessor ProcessorAlertData: started 2026-01-05 12:44:40.2755 DFramework.Scheduler.TaskBase /* Time Taken: 15562.6135*/ Opportunity Out Of Stock By Outlet 2026-01-05 12:44:45.4162 DFramework.Database.Query /* Time Taken: 504*/ DECLARE @TableName AnsiString(8000) SET @TableName = 'ProductStockLevel' DECLARE @CurrentRecordId Int32 SET @CurrentRecordId = '3675635' dbo.GetValidDeviceForAlertProcessData 2026-01-05 12:44:45.4631 AlertProcessor ProcessorAlertData: Stopped 2026-01-05 12:49:40.0434 AlertProcessor ProcessorAlertData: started 2026-01-05 12:49:45.4497 AlertProcessor ProcessorAlertData: Stopped 2026-01-05 12:54:40.0612 AlertProcessor ProcessorAlertData: started 2026-01-05 12:54:45.4988 AlertProcessor ProcessorAlertData: Stopped 2026-01-05 12:59:25.2665 DFramework.Database.Query /* Time Taken: 531*/ [dbo].GenerateSystemAlerts 2026-01-05 12:59:40.0791 AlertProcessor ProcessorAlertData: started 2026-01-05 12:59:40.3291 DFramework.Scheduler.TaskBase /* Time Taken: 15593.8647*/ Opportunity Out Of Stock By Outlet 2026-01-05 12:59:45.4542 AlertProcessor ProcessorAlertData: Stopped 2026-01-05 13:04:40.0970 AlertProcessor ProcessorAlertData: started 2026-01-05 13:04:45.5970 AlertProcessor ProcessorAlertData: Stopped 2026-01-05 13:09:40.1148 AlertProcessor ProcessorAlertData: started 2026-01-05 13:09:45.5680 AlertProcessor ProcessorAlertData: Stopped 2026-01-05 13:14:25.3671 DFramework.Database.Query /* Time Taken: 623*/ [dbo].GenerateSystemAlerts 2026-01-05 13:14:40.1329 AlertProcessor ProcessorAlertData: started 2026-01-05 13:14:40.6329 DFramework.Scheduler.TaskBase /* Time Taken: 15875.1604*/ Opportunity Out Of Stock By Outlet 2026-01-05 13:14:45.5705 AlertProcessor ProcessorAlertData: Stopped 2026-01-05 13:19:40.1356 AlertProcessor ProcessorAlertData: started 2026-01-05 13:19:45.6513 AlertProcessor ProcessorAlertData: Stopped 2026-01-05 13:24:40.1380 AlertProcessor ProcessorAlertData: started 2026-01-05 13:24:45.5443 AlertProcessor ProcessorAlertData: Stopped 2026-01-05 13:29:40.1559 AlertProcessor ProcessorAlertData: started 2026-01-05 13:29:40.3434 DFramework.Scheduler.TaskBase /* Time Taken: 15562.6404*/ Opportunity Out Of Stock By Outlet 2026-01-05 13:29:45.5309 AlertProcessor ProcessorAlertData: Stopped 2026-01-05 13:34:40.1730 AlertProcessor ProcessorAlertData: started 2026-01-05 13:34:45.5324 AlertProcessor ProcessorAlertData: Stopped 2026-01-05 13:39:40.1905 AlertProcessor ProcessorAlertData: started 2026-01-05 13:39:45.8624 AlertProcessor ProcessorAlertData: Stopped 2026-01-05 13:44:40.1927 AlertProcessor ProcessorAlertData: started 2026-01-05 13:44:40.4114 DFramework.Scheduler.TaskBase /* Time Taken: 15609.4872*/ Opportunity Out Of Stock By Outlet 2026-01-05 13:44:45.6458 AlertProcessor ProcessorAlertData: Stopped 2026-01-05 13:49:40.2105 AlertProcessor ProcessorAlertData: started 2026-01-05 13:49:45.6324 AlertProcessor ProcessorAlertData: Stopped 2026-01-05 13:54:40.2284 AlertProcessor ProcessorAlertData: started 2026-01-05 13:54:45.6034 AlertProcessor ProcessorAlertData: Stopped 2026-01-05 13:55:22.3068 DFramework.Database.Query /* Time Taken: 627*/ 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-05 13:55:22.3224 DFramework.Database.Query /* Time Taken: 639*/ 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-05 13:55:22.3224 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-05 13:55:22.3224 DFramework.Database.Query /* Time Taken: 640*/ 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-05 13:55:42.2913 DFramework.Database.Query /* Time Taken: 573*/ 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-05 13:55:42.2913 DFramework.Database.Query /* Time Taken: 574*/ 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-05 13:55:42.2913 DFramework.Database.Query /* Time Taken: 574*/ 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-05 13:58:27.9019 DFramework.Database.Query /* Time Taken: 707*/ 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-05 13:58:27.9019 DFramework.Database.Query /* Time Taken: 708*/ 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-05 13:58:36.2770 DFramework.Database.Query /* Time Taken: 4062*/ 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-05 13:58:38.7458 DFramework.Database.Query /* Time Taken: 1523*/ 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-05 13:58:38.7926 DFramework.Database.Query /* Time Taken: 6582*/ 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-05 13:58:38.7926 DFramework.Database.Query /* Time Taken: 6582*/ 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-05 13:59:25.5117 DFramework.Database.Query /* Time Taken: 700*/ [dbo].GenerateSystemAlerts 2026-01-05 13:59:40.2462 AlertProcessor ProcessorAlertData: started 2026-01-05 13:59:40.5275 DFramework.Scheduler.TaskBase /* Time Taken: 15703.2403*/ Opportunity Out Of Stock By Outlet 2026-01-05 13:59:45.7775 AlertProcessor ProcessorAlertData: Stopped 2026-01-05 14:00:40.2779 DFramework.Database.Query /* Time Taken: 2693*/ 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-05 14:00:42.1373 DFramework.Database.Query /* Time Taken: 4557*/ 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-05 14:00:43.7936 DFramework.Database.Query /* Time Taken: 1198*/ 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-05 14:00:45.8561 DFramework.Database.Query /* Time Taken: 8268*/ 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-05 14:00:56.7937 DFramework.Database.Query /* Time Taken: 19202*/ 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-05 14:01:03.7781 DFramework.Database.Query /* Time Taken: 11143*/ 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-05 14:01:03.7781 DFramework.Scheduler.TaskBase /* Time Taken: 11140.7075*/ ProcessSQLUnprocessedFiles 2026-01-05 14:01:17.6376 DFramework.Database.Query /* Time Taken: 35031*/ 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-05 14:01:17.6376 DFramework.Database.Query /* Time Taken: 35032*/ 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-05 14:01:21.5438 DFramework.Scheduler.TaskBase /* Time Taken: 43953.4521*/ ProcessSQLUnprocessedFiles 2026-01-05 14:01:21.5751 DFramework.Scheduler.TaskBase /* Time Taken: 38969.038*/ ProcessSQLUnprocessedFiles 2026-01-05 14:01:21.5751 DFramework.Scheduler.TaskBase /* Time Taken: 38969.038*/ ProcessSQLUnprocessedFiles 2026-01-05 14:01:22.6532 DFramework.Database.Query /* Time Taken: 35031*/ 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-05 14:01:22.6688 DFramework.Scheduler.TaskBase /* Time Taken: 35047.1336*/ ProcessSQLUnprocessedFiles 2026-01-05 14:01:26.8407 DFramework.Database.Query /* Time Taken: 19167*/ 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-05 14:01:26.8407 DFramework.Scheduler.TaskBase /* Time Taken: 19156.3913*/ ProcessSQLUnprocessedFiles 2026-01-05 14:01:29.1689 DFramework.Database.Query /* Time Taken: 1437*/ 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-05 14:01:33.7002 DFramework.Database.Query /* Time Taken: 952*/ 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-05 14:04:40.2484 AlertProcessor ProcessorAlertData: started 2026-01-05 14:04:45.7485 AlertProcessor ProcessorAlertData: Stopped 2026-01-05 14:09:40.2663 AlertProcessor ProcessorAlertData: started 2026-01-05 14:09:45.7820 AlertProcessor ProcessorAlertData: Stopped 2026-01-05 14:14:25.3934 DFramework.Database.Query /* Time Taken: 549*/ [dbo].GenerateSystemAlerts 2026-01-05 14:14:40.2842 AlertProcessor ProcessorAlertData: started 2026-01-05 14:14:40.4248 DFramework.Scheduler.TaskBase /* Time Taken: 15578.2404*/ Opportunity Out Of Stock By Outlet 2026-01-05 14:14:45.1592 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-05 14:14:45.9248 AlertProcessor ProcessorAlertData: Stopped 2026-01-05 14:19:40.3020 AlertProcessor ProcessorAlertData: started 2026-01-05 14:19:45.7552 AlertProcessor ProcessorAlertData: Stopped 2026-01-05 14:24:40.3199 AlertProcessor ProcessorAlertData: started 2026-01-05 14:24:45.7574 AlertProcessor ProcessorAlertData: Stopped 2026-01-05 14:29:25.4001 DFramework.Database.Query /* Time Taken: 538*/ [dbo].GenerateSystemAlerts 2026-01-05 14:29:40.3377 AlertProcessor ProcessorAlertData: started 2026-01-05 14:29:40.4940 DFramework.Scheduler.TaskBase /* Time Taken: 15625.1181*/ Opportunity Out Of Stock By Outlet 2026-01-05 14:29:45.8221 AlertProcessor ProcessorAlertData: Stopped 2026-01-05 14:34:40.3399 AlertProcessor ProcessorAlertData: started 2026-01-05 14:34:45.7150 AlertProcessor ProcessorAlertData: Stopped 2026-01-05 14:39:40.3422 AlertProcessor ProcessorAlertData: started 2026-01-05 14:39:45.7485 AlertProcessor ProcessorAlertData: Stopped 2026-01-05 14:44:25.4693 DFramework.Database.Query /* Time Taken: 599*/ [dbo].GenerateSystemAlerts 2026-01-05 14:44:40.3444 AlertProcessor ProcessorAlertData: started 2026-01-05 14:44:40.5631 DFramework.Scheduler.TaskBase /* Time Taken: 15687.6157*/ Opportunity Out Of Stock By Outlet 2026-01-05 14:44:45.8132 AlertProcessor ProcessorAlertData: Stopped 2026-01-05 14:49:40.3622 AlertProcessor ProcessorAlertData: started 2026-01-05 14:49:45.7841 AlertProcessor ProcessorAlertData: Stopped 2026-01-05 14:54:40.3801 AlertProcessor ProcessorAlertData: started 2026-01-05 14:54:45.8020 AlertProcessor ProcessorAlertData: Stopped 2026-01-05 14:59:25.3978 DFramework.Database.Query /* Time Taken: 524*/ [dbo].GenerateSystemAlerts 2026-01-05 14:59:40.3979 AlertProcessor ProcessorAlertData: started 2026-01-05 14:59:40.5073 DFramework.Scheduler.TaskBase /* Time Taken: 15625.117*/ Opportunity Out Of Stock By Outlet 2026-01-05 14:59:45.8198 AlertProcessor ProcessorAlertData: Stopped 2026-01-05 15:04:40.4158 AlertProcessor ProcessorAlertData: started 2026-01-05 15:04:45.9471 AlertProcessor ProcessorAlertData: Stopped 2026-01-05 15:09:40.4336 AlertProcessor ProcessorAlertData: started 2026-01-05 15:09:44.5118 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-05 15:09:46.1524 AlertProcessor ProcessorAlertData: Stopped 2026-01-05 15:14:25.4357 DFramework.Database.Query /* Time Taken: 561*/ [dbo].GenerateSystemAlerts 2026-01-05 15:14:40.4358 AlertProcessor ProcessorAlertData: started 2026-01-05 15:14:40.4671 DFramework.Scheduler.TaskBase /* Time Taken: 15578.2431*/ Opportunity Out Of Stock By Outlet 2026-01-05 15:14:45.8421 AlertProcessor ProcessorAlertData: Stopped 2026-01-05 15:19:40.4381 AlertProcessor ProcessorAlertData: started 2026-01-05 15:19:45.7662 AlertProcessor ProcessorAlertData: Stopped 2026-01-05 15:24:40.4559 AlertProcessor ProcessorAlertData: started 2026-01-05 15:24:45.8466 AlertProcessor ProcessorAlertData: Stopped 2026-01-05 15:29:25.3955 DFramework.Database.Query /* Time Taken: 501*/ [dbo].GenerateSystemAlerts 2026-01-05 15:29:40.4581 DFramework.Scheduler.TaskBase /* Time Taken: 15562.6155*/ Opportunity Out Of Stock By Outlet 2026-01-05 15:29:40.4581 AlertProcessor ProcessorAlertData: started 2026-01-05 15:29:45.9113 AlertProcessor ProcessorAlertData: Stopped 2026-01-05 15:34:40.4761 AlertProcessor ProcessorAlertData: started 2026-01-05 15:34:45.8824 AlertProcessor ProcessorAlertData: Stopped 2026-01-05 15:39:40.4940 AlertProcessor ProcessorAlertData: started 2026-01-05 15:39:45.9003 AlertProcessor ProcessorAlertData: Stopped 2026-01-05 15:44:25.4492 DFramework.Database.Query /* Time Taken: 551*/ [dbo].GenerateSystemAlerts 2026-01-05 15:44:40.5118 AlertProcessor ProcessorAlertData: started 2026-01-05 15:44:40.5587 DFramework.Scheduler.TaskBase /* Time Taken: 15656.3676*/ Opportunity Out Of Stock By Outlet 2026-01-05 15:44:45.9025 AlertProcessor ProcessorAlertData: Stopped 2026-01-05 15:49:40.5297 AlertProcessor ProcessorAlertData: started 2026-01-05 15:49:46.0922 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-05 15:49:46.0922 AlertProcessor ProcessorAlertData: Stopped 2026-01-05 15:54:40.5319 AlertProcessor ProcessorAlertData: started 2026-01-05 15:54:43.7038 DFramework.Database.Query /* Time Taken: 648*/ DECLARE @TableName AnsiString(8000) SET @TableName = 'AssetStockProductWiseConsolidate' DECLARE @CurrentRecordId Int32 SET @CurrentRecordId = '3675635' dbo.GetValidDeviceForAlertProcessData 2026-01-05 15:54:46.2038 AlertProcessor ProcessorAlertData: Stopped 2026-01-05 15:59:25.4403 DFramework.Database.Query /* Time Taken: 517*/ [dbo].GenerateSystemAlerts 2026-01-05 15:59:40.5341 DFramework.Scheduler.TaskBase /* Time Taken: 15609.4963*/ Opportunity Out Of Stock By Outlet 2026-01-05 15:59:40.5498 AlertProcessor ProcessorAlertData: started 2026-01-05 15:59:45.9404 AlertProcessor ProcessorAlertData: Stopped 2026-01-05 16:04:40.5677 AlertProcessor ProcessorAlertData: started 2026-01-05 16:04:43.5677 DFramework.Database.Query /* Time Taken: 522*/ DECLARE @TableName AnsiString(8000) SET @TableName = 'AssetStockProductWiseConsolidate' DECLARE @CurrentRecordId Int32 SET @CurrentRecordId = '3675635' dbo.GetValidDeviceForAlertProcessData 2026-01-05 16:04:46.0677 AlertProcessor ProcessorAlertData: Stopped 2026-01-05 16:09:40.5856 AlertProcessor ProcessorAlertData: started 2026-01-05 16:09:44.3200 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-05 16:09:46.2263 AlertProcessor ProcessorAlertData: Stopped 2026-01-05 16:14:40.5098 DFramework.Scheduler.TaskBase /* Time Taken: 15562.6203*/ Opportunity Out Of Stock By Outlet 2026-01-05 16:14:40.6035 AlertProcessor ProcessorAlertData: started 2026-01-05 16:14:46.0254 AlertProcessor ProcessorAlertData: Stopped 2026-01-05 16:19:40.6214 AlertProcessor ProcessorAlertData: started 2026-01-05 16:19:46.0277 AlertProcessor ProcessorAlertData: Stopped 2026-01-05 16:24:40.6393 AlertProcessor ProcessorAlertData: started 2026-01-05 16:24:46.2331 AlertProcessor ProcessorAlertData: Stopped 2026-01-05 16:29:40.5322 DFramework.Scheduler.TaskBase /* Time Taken: 15562.6188*/ Opportunity Out Of Stock By Outlet 2026-01-05 16:29:40.6415 AlertProcessor ProcessorAlertData: started 2026-01-05 16:29:46.1416 AlertProcessor ProcessorAlertData: Stopped 2026-01-05 16:34:40.6438 AlertProcessor ProcessorAlertData: started 2026-01-05 16:34:45.9407 AlertProcessor ProcessorAlertData: Stopped 2026-01-05 16:39:40.6460 AlertProcessor ProcessorAlertData: started 2026-01-05 16:39:46.0523 AlertProcessor ProcessorAlertData: Stopped 2026-01-05 16:44:40.5545 DFramework.Scheduler.TaskBase /* Time Taken: 15562.6145*/ Opportunity Out Of Stock By Outlet 2026-01-05 16:44:40.6639 AlertProcessor ProcessorAlertData: started 2026-01-05 16:44:46.0077 AlertProcessor ProcessorAlertData: Stopped 2026-01-05 16:49:40.6818 AlertProcessor ProcessorAlertData: started 2026-01-05 16:49:46.4474 AlertProcessor ProcessorAlertData: Stopped 2026-01-05 16:54:40.6997 AlertProcessor ProcessorAlertData: started 2026-01-05 16:54:46.2466 AlertProcessor ProcessorAlertData: Stopped 2026-01-05 16:59:25.5299 DFramework.Database.Query /* Time Taken: 515*/ [dbo].GenerateSystemAlerts 2026-01-05 16:59:40.6238 DFramework.Scheduler.TaskBase /* Time Taken: 15609.4924*/ Opportunity Out Of Stock By Outlet 2026-01-05 16:59:40.7176 AlertProcessor ProcessorAlertData: started 2026-01-05 16:59:46.0457 AlertProcessor ProcessorAlertData: Stopped 2026-01-05 17:04:40.7355 AlertProcessor ProcessorAlertData: started 2026-01-05 17:04:46.1574 AlertProcessor ProcessorAlertData: Stopped 2026-01-05 17:09:40.7377 AlertProcessor ProcessorAlertData: started 2026-01-05 17:09:46.1596 AlertProcessor ProcessorAlertData: Stopped 2026-01-05 17:14:40.5993 DFramework.Scheduler.TaskBase /* Time Taken: 15562.6086*/ Opportunity Out Of Stock By Outlet 2026-01-05 17:14:40.7399 AlertProcessor ProcessorAlertData: started 2026-01-05 17:14:46.0837 AlertProcessor ProcessorAlertData: Stopped 2026-01-05 17:19:40.7577 AlertProcessor ProcessorAlertData: started 2026-01-05 17:19:46.1640 AlertProcessor ProcessorAlertData: Stopped 2026-01-05 17:21:26.2897 DFramework.Database.Query /* Time Taken: 589*/ 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-05 17:21:26.2897 DFramework.Database.Query /* Time Taken: 589*/ 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-05 17:21:26.2897 DFramework.Database.Query /* Time Taken: 590*/ 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-05 17:21:26.5397 DFramework.Database.Query /* Time Taken: 839*/ 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-05 17:21:26.5710 DFramework.Database.Query /* Time Taken: 870*/ 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-05 17:24:40.7756 AlertProcessor ProcessorAlertData: started 2026-01-05 17:24:46.2131 AlertProcessor ProcessorAlertData: Stopped 2026-01-05 17:29:40.6215 DFramework.Scheduler.TaskBase /* Time Taken: 15562.6128*/ Opportunity Out Of Stock By Outlet 2026-01-05 17:29:40.7934 AlertProcessor ProcessorAlertData: started 2026-01-05 17:29:46.1997 AlertProcessor ProcessorAlertData: Stopped 2026-01-05 17:34:40.8114 AlertProcessor ProcessorAlertData: started 2026-01-05 17:34:43.1864 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-05 17:34:46.3739 AlertProcessor ProcessorAlertData: Stopped 2026-01-05 17:39:40.8293 AlertProcessor ProcessorAlertData: started 2026-01-05 17:39:46.3137 AlertProcessor ProcessorAlertData: Stopped 2026-01-05 17:44:40.6440 DFramework.Scheduler.TaskBase /* Time Taken: 15562.6159*/ Opportunity Out Of Stock By Outlet 2026-01-05 17:44:40.8315 AlertProcessor ProcessorAlertData: started 2026-01-05 17:44:46.0034 AlertProcessor ProcessorAlertData: Stopped 2026-01-05 17:49:40.8494 AlertProcessor ProcessorAlertData: started 2026-01-05 17:49:46.2869 AlertProcessor ProcessorAlertData: Stopped 2026-01-05 17:54:40.8673 AlertProcessor ProcessorAlertData: started 2026-01-05 17:54:46.3673 AlertProcessor ProcessorAlertData: Stopped 2026-01-05 17:59:25.6351 DFramework.Database.Query /* Time Taken: 539*/ [dbo].GenerateSystemAlerts 2026-01-05 17:59:40.7289 DFramework.Scheduler.TaskBase /* Time Taken: 15625.1157*/ Opportunity Out Of Stock By Outlet 2026-01-05 17:59:40.8851 AlertProcessor ProcessorAlertData: started 2026-01-05 17:59:46.2758 AlertProcessor ProcessorAlertData: Stopped 2026-01-05 18:04:40.9031 AlertProcessor ProcessorAlertData: started 2026-01-05 18:04:46.4187 AlertProcessor ProcessorAlertData: Stopped 2026-01-05 18:09:40.9210 AlertProcessor ProcessorAlertData: started 2026-01-05 18:09:46.1867 AlertProcessor ProcessorAlertData: Stopped 2026-01-05 18:14:40.6889 DFramework.Scheduler.TaskBase /* Time Taken: 15562.6164*/ Opportunity Out Of Stock By Outlet 2026-01-05 18:14:40.9389 AlertProcessor ProcessorAlertData: started 2026-01-05 18:14:44.6733 DFramework.Database.NullableDataReader Data reader open for 280 at System.Environment.GetStackTrace(Exception e, Boolean needFileInfo) at System.Environment.get_StackTrace() at DFramework.Database.NullableDataReader.Dispose(Boolean disposing) in 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-05 18:14:46.5796 AlertProcessor ProcessorAlertData: Stopped 2026-01-05 18:19:40.9412 AlertProcessor ProcessorAlertData: started 2026-01-05 18:19:46.3631 AlertProcessor ProcessorAlertData: Stopped 2026-01-05 18:24:40.9433 AlertProcessor ProcessorAlertData: started 2026-01-05 18:24:46.5058 AlertProcessor ProcessorAlertData: Stopped 2026-01-05 18:29:40.7111 DFramework.Scheduler.TaskBase /* Time Taken: 15562.6145*/ Opportunity Out Of Stock By Outlet 2026-01-05 18:29:40.9611 AlertProcessor ProcessorAlertData: started 2026-01-05 18:29:46.4299 AlertProcessor ProcessorAlertData: Stopped 2026-01-05 18:34:29.3383 MoveToReorder Running task for ClientId : 286 and ClientName = India Office QA and Slot: 1/6/2026 8:00:00 AM And LastExecutedOn: 1/5/2026 10:04:28 PM 2026-01-05 18:34:40.9790 AlertProcessor ProcessorAlertData: started 2026-01-05 18:34:46.5884 AlertProcessor ProcessorAlertData: Stopped 2026-01-05 18:35:10.0886 DFramework.Database.NullableDataReader Data reader open for 40281 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-05 18:35:10.1198 MoveToReorder Task executed successfully for ClientId : 286 Client Name:India Office QA, Slot: 1/6/2026 8:00:00 AM and Total Order Suggested: 126 Out Of: 126 2026-01-05 18:35:10.6511 DFramework.Database.Query /* Time Taken: 524*/ DECLARE @ClientId Int32 SET @ClientId = '286' dbo.GetMoveToReOrderList 2026-01-05 18:35:11.2917 DFramework.Scheduler.TaskBase /* Time Taken: 42281.5692*/ Move To Re-Order 2026-01-05 18:39:40.9969 AlertProcessor ProcessorAlertData: started 2026-01-05 18:39:46.5438 AlertProcessor ProcessorAlertData: Stopped 2026-01-05 18:44:40.7492 DFramework.Scheduler.TaskBase /* Time Taken: 15578.2445*/ Opportunity Out Of Stock By Outlet 2026-01-05 18:44:40.9992 AlertProcessor ProcessorAlertData: started 2026-01-05 18:44:46.4055 AlertProcessor ProcessorAlertData: Stopped 2026-01-05 18:49:41.0171 AlertProcessor ProcessorAlertData: started 2026-01-05 18:49:46.5015 AlertProcessor ProcessorAlertData: Stopped 2026-01-05 18:54:41.0350 AlertProcessor ProcessorAlertData: started 2026-01-05 18:54:46.4881 AlertProcessor ProcessorAlertData: Stopped 2026-01-05 18:59:25.7090 DFramework.Database.Query /* Time Taken: 535*/ [dbo].GenerateSystemAlerts 2026-01-05 18:59:40.8029 DFramework.Scheduler.TaskBase /* Time Taken: 15625.1149*/ Opportunity Out Of Stock By Outlet 2026-01-05 18:59:41.0529 AlertProcessor ProcessorAlertData: started 2026-01-05 18:59:46.8185 DFramework.Database.NullableDataReader Data reader open for 279 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-05 18:59:46.8185 AlertProcessor ProcessorAlertData: Stopped 2026-01-05 19:04:41.0707 AlertProcessor ProcessorAlertData: started 2026-01-05 19:04:46.6333 AlertProcessor ProcessorAlertData: Stopped 2026-01-05 19:09:41.0886 AlertProcessor ProcessorAlertData: started 2026-01-05 19:09:46.4949 AlertProcessor ProcessorAlertData: Stopped 2026-01-05 19:14:40.7626 DFramework.Scheduler.TaskBase /* Time Taken: 15562.6088*/ Opportunity Out Of Stock By Outlet 2026-01-05 19:14:41.1063 AlertProcessor ProcessorAlertData: started 2026-01-05 19:14:46.5595 AlertProcessor ProcessorAlertData: Stopped 2026-01-05 19:19:41.1241 AlertProcessor ProcessorAlertData: started 2026-01-05 19:19:46.5304 AlertProcessor ProcessorAlertData: Stopped 2026-01-05 19:24:41.1419 AlertProcessor ProcessorAlertData: started 2026-01-05 19:24:46.6576 AlertProcessor ProcessorAlertData: Stopped 2026-01-05 19:29:25.7378 DFramework.Database.Query /* Time Taken: 520*/ [dbo].GenerateSystemAlerts 2026-01-05 19:29:40.8316 DFramework.Scheduler.TaskBase /* Time Taken: 15609.4833*/ Opportunity Out Of Stock By Outlet 2026-01-05 19:29:41.1597 AlertProcessor ProcessorAlertData: started 2026-01-05 19:29:46.6285 AlertProcessor ProcessorAlertData: Stopped 2026-01-05 19:30:12.6130 DFramework.Database.Query /* Time Taken: 1205*/ 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-05 19:30:12.6130 DFramework.Database.Query /* Time Taken: 1206*/ 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-05 19:30:13.2693 DFramework.Database.Query /* Time Taken: 1862*/ 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-05 19:30:14.4724 DFramework.Database.Query /* Time Taken: 3064*/ 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-05 19:30:19.0975 DFramework.Database.Query /* Time Taken: 2677*/ 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-05 19:30:21.0975 DFramework.Database.Query /* Time Taken: 4683*/ 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-05 19:30:21.1912 DFramework.Database.Query /* Time Taken: 4776*/ 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-05 19:30:22.6444 DFramework.Database.Query /* Time Taken: 6220*/ 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-05 19:34:29.4429 MoveToReorder Running task for ClientId : 286 and ClientName = India Office QA and Slot: 1/6/2026 9:00:00 AM And LastExecutedOn: 1/6/2026 8:04:29 AM 2026-01-05 19:34:29.6460 MoveToReorder Task executed successfully for ClientId : 286 Client Name:India Office QA, Slot: 1/6/2026 9:00:00 AM But No Order found to suggest 2026-01-05 19:34:41.1774 AlertProcessor ProcessorAlertData: started 2026-01-05 19:34:46.5211 AlertProcessor ProcessorAlertData: Stopped 2026-01-05 19:39:41.1795 AlertProcessor ProcessorAlertData: started 2026-01-05 19:39:46.4608 AlertProcessor ProcessorAlertData: Stopped 2026-01-05 19:40:53.7113 DFramework.Database.Query /* Time Taken: 588*/ 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-05 19:40:54.3207 DFramework.Database.Query /* Time Taken: 1196*/ 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-05 19:40:54.3207 DFramework.Database.Query /* Time Taken: 1196*/ 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-05 19:40:58.7114 DFramework.Database.Query /* Time Taken: 588*/ 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-05 19:41:00.5239 DFramework.Database.Query /* Time Taken: 2401*/ 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-05 19:44:25.7754 DFramework.Database.Query /* Time Taken: 543*/ [dbo].GenerateSystemAlerts 2026-01-05 19:44:40.8380 DFramework.Scheduler.TaskBase /* Time Taken: 15593.8659*/ Opportunity Out Of Stock By Outlet 2026-01-05 19:44:41.1818 AlertProcessor ProcessorAlertData: started 2026-01-05 19:44:46.5724 AlertProcessor ProcessorAlertData: Stopped 2026-01-05 19:49:41.1996 AlertProcessor ProcessorAlertData: started 2026-01-05 19:49:46.5747 AlertProcessor ProcessorAlertData: Stopped 2026-01-05 19:54:41.2175 AlertProcessor ProcessorAlertData: started 2026-01-05 19:54:46.6394 DFramework.Database.Query /* Time Taken: 537*/ DECLARE @TableName AnsiString(8000) SET @TableName = 'ProductStockLevel' DECLARE @CurrentRecordId Int32 SET @CurrentRecordId = '3675635' dbo.GetValidDeviceForAlertProcessData 2026-01-05 19:54:46.7019 AlertProcessor ProcessorAlertData: Stopped 2026-01-05 19:59:40.8290 DFramework.Scheduler.TaskBase /* Time Taken: 15562.6149*/ Opportunity Out Of Stock By Outlet 2026-01-05 19:59:41.2353 AlertProcessor ProcessorAlertData: started 2026-01-05 19:59:46.5635 AlertProcessor ProcessorAlertData: Stopped 2026-01-05 20:04:41.2531 AlertProcessor ProcessorAlertData: started 2026-01-05 20:04:46.7376 AlertProcessor ProcessorAlertData: Stopped 2026-01-05 20:09:41.2710 AlertProcessor ProcessorAlertData: started 2026-01-05 20:09:46.6148 AlertProcessor ProcessorAlertData: Stopped 2026-01-05 20:14:25.8043 DFramework.Database.Query /* Time Taken: 526*/ [dbo].GenerateSystemAlerts 2026-01-05 20:14:40.9138 DFramework.Scheduler.TaskBase /* Time Taken: 15625.1158*/ Opportunity Out Of Stock By Outlet 2026-01-05 20:14:41.2888 AlertProcessor ProcessorAlertData: started 2026-01-05 20:14:46.6951 AlertProcessor ProcessorAlertData: Stopped 2026-01-05 20:19:41.3067 AlertProcessor ProcessorAlertData: started 2026-01-05 20:19:46.7911 AlertProcessor ProcessorAlertData: Stopped 2026-01-05 20:24:41.3246 AlertProcessor ProcessorAlertData: started 2026-01-05 20:24:46.7621 AlertProcessor ProcessorAlertData: Stopped 2026-01-05 20:29:25.8267 DFramework.Database.Query /* Time Taken: 516*/ [dbo].GenerateSystemAlerts 2026-01-05 20:29:40.9362 DFramework.Scheduler.TaskBase /* Time Taken: 15625.1167*/ Opportunity Out Of Stock By Outlet 2026-01-05 20:29:41.3268 AlertProcessor ProcessorAlertData: started 2026-01-05 20:29:46.7956 AlertProcessor ProcessorAlertData: Stopped 2026-01-05 20:34:29.5633 MoveToReorder Running task for ClientId : 286 and ClientName = India Office QA and Slot: 1/6/2026 10:00:00 AM And LastExecutedOn: 1/6/2026 9:04:29 AM 2026-01-05 20:34:29.7665 MoveToReorder Task executed successfully for ClientId : 286 Client Name:India Office QA, Slot: 1/6/2026 10:00:00 AM But No Order found to suggest 2026-01-05 20:34:41.3447 AlertProcessor ProcessorAlertData: started 2026-01-05 20:34:42.0634 DFramework.Database.Query /* Time Taken: 657*/ DECLARE AlertTypeIds Object SET AlertTypeIds = 'DFramework.Database.Adapters.SQL+d__24' [dbo].GetAlertSummaryData 2026-01-05 20:34:45.5009 DFramework.Database.Query /* Time Taken: 3432*/ DECLARE @AlertTypeIds AnsiString(8000) SET @AlertTypeIds = '46,37,59,73,57' DECLARE @ClientIds AnsiString(8000) SET @ClientIds = '1494,213,286,114,180,183,299,300,314,316,331,332,333,349,415,451,296,301,303,305,328,335,337,360,385,421,469,471,1480,207,224,291,306,308,325,342,70,134,188,227,295,320,336,338,395,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-05 20:34:47.1103 AlertProcessor ProcessorAlertData: Stopped 2026-01-05 20:39:41.3625 AlertProcessor ProcessorAlertData: started 2026-01-05 20:39:46.7688 AlertProcessor ProcessorAlertData: Stopped 2026-01-05 20:44:40.8960 DFramework.Scheduler.TaskBase /* Time Taken: 15562.606*/ Opportunity Out Of Stock By Outlet 2026-01-05 20:44:41.3804 AlertProcessor ProcessorAlertData: started 2026-01-05 20:44:49.0836 AlertProcessor ProcessorAlertData: Stopped 2026-01-05 20:49:41.3982 AlertProcessor ProcessorAlertData: started 2026-01-05 20:49:44.3670 DFramework.Database.Query /* Time Taken: 512*/ DECLARE @TableName AnsiString(8000) SET @TableName = 'AssetStockProductWiseConsolidate' DECLARE @CurrentRecordId Int32 SET @CurrentRecordId = '3675635' dbo.GetValidDeviceForAlertProcessData 2026-01-05 20:49:46.8983 AlertProcessor ProcessorAlertData: Stopped 2026-01-05 20:54:41.4161 AlertProcessor ProcessorAlertData: started 2026-01-05 20:54:46.9162 AlertProcessor ProcessorAlertData: Stopped 2026-01-05 20:59:25.9341 DFramework.Database.Query /* Time Taken: 585*/ [dbo].GenerateSystemAlerts 2026-01-05 20:59:40.9343 DFramework.Scheduler.TaskBase /* Time Taken: 15578.2397*/ Opportunity Out Of Stock By Outlet 2026-01-05 20:59:41.4343 AlertProcessor ProcessorAlertData: started 2026-01-05 20:59:46.8562 AlertProcessor ProcessorAlertData: Stopped 2026-01-05 21:04:41.4522 AlertProcessor ProcessorAlertData: started 2026-01-05 21:04:46.9054 AlertProcessor ProcessorAlertData: Stopped 2026-01-05 21:09:41.4701 AlertProcessor ProcessorAlertData: started 2026-01-05 21:09:46.9545 AlertProcessor ProcessorAlertData: Stopped 2026-01-05 21:14:40.9567 DFramework.Scheduler.TaskBase /* Time Taken: 15578.2432*/ Opportunity Out Of Stock By Outlet 2026-01-05 21:14:41.4879 AlertProcessor ProcessorAlertData: started 2026-01-05 21:14:46.9880 AlertProcessor ProcessorAlertData: Stopped 2026-01-05 21:19:41.5058 AlertProcessor ProcessorAlertData: started 2026-01-05 21:19:46.9433 AlertProcessor ProcessorAlertData: Stopped 2026-01-05 21:24:41.5236 AlertProcessor ProcessorAlertData: started 2026-01-05 21:24:46.9612 AlertProcessor ProcessorAlertData: Stopped 2026-01-05 21:29:25.9476 DFramework.Database.Query /* Time Taken: 561*/ [dbo].GenerateSystemAlerts 2026-01-05 21:29:41.0415 DFramework.Scheduler.TaskBase /* Time Taken: 15640.7403*/ Opportunity Out Of Stock By Outlet 2026-01-05 21:29:41.5415 AlertProcessor ProcessorAlertData: started 2026-01-05 21:29:47.0572 AlertProcessor ProcessorAlertData: Stopped 2026-01-05 21:34:29.6374 MoveToReorder Running task for ClientId : 286 and ClientName = India Office QA and Slot: 1/6/2026 11:00:00 AM And LastExecutedOn: 1/6/2026 10:04:29 AM 2026-01-05 21:34:41.5594 AlertProcessor ProcessorAlertData: started 2026-01-05 21:34:47.0438 AlertProcessor ProcessorAlertData: Stopped 2026-01-05 21:35:08.0908 DFramework.Database.NullableDataReader Data reader open for 38114 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-05 21:35:08.1221 MoveToReorder Task executed successfully for ClientId : 286 Client Name:India Office QA, Slot: 1/6/2026 11:00:00 AM and Total Order Suggested: 126 Out Of: 126 2026-01-05 21:35:09.0283 DFramework.Scheduler.TaskBase /* Time Taken: 39703.4193*/ Move To Re-Order 2026-01-05 21:39:41.5616 AlertProcessor ProcessorAlertData: started 2026-01-05 21:39:47.0148 AlertProcessor ProcessorAlertData: Stopped 2026-01-05 21:44:40.9858 DFramework.Scheduler.TaskBase /* Time Taken: 15562.6044*/ Opportunity Out Of Stock By Outlet 2026-01-05 21:44:41.5639 AlertProcessor ProcessorAlertData: started 2026-01-05 21:44:46.9546 AlertProcessor ProcessorAlertData: Stopped 2026-01-05 21:49:41.5661 AlertProcessor ProcessorAlertData: started 2026-01-05 21:49:47.1443 AlertProcessor ProcessorAlertData: Stopped 2026-01-05 21:54:41.5840 AlertProcessor ProcessorAlertData: started 2026-01-05 21:54:47.0527 AlertProcessor ProcessorAlertData: Stopped 2026-01-05 21:59:41.0081 DFramework.Scheduler.TaskBase /* Time Taken: 15562.6186*/ Opportunity Out Of Stock By Outlet 2026-01-05 21:59:41.6018 AlertProcessor ProcessorAlertData: started 2026-01-05 21:59:47.0237 AlertProcessor ProcessorAlertData: Stopped 2026-01-05 22:04:41.6197 AlertProcessor ProcessorAlertData: started 2026-01-05 22:04:47.0572 AlertProcessor ProcessorAlertData: Stopped 2026-01-05 22:09:41.6376 AlertProcessor ProcessorAlertData: started 2026-01-05 22:09:47.1220 AlertProcessor ProcessorAlertData: Stopped 2026-01-05 22:14:25.9991 DFramework.Database.Query /* Time Taken: 537*/ [dbo].GenerateSystemAlerts 2026-01-05 22:14:41.0930 DFramework.Scheduler.TaskBase /* Time Taken: 15625.1132*/ Opportunity Out Of Stock By Outlet 2026-01-05 22:14:41.6555 AlertProcessor ProcessorAlertData: started 2026-01-05 22:14:44.7336 DFramework.Database.Query /* Time Taken: 554*/ DECLARE @TableName AnsiString(8000) SET @TableName = 'AssetStockProductWiseConsolidate' DECLARE @CurrentRecordId Int32 SET @CurrentRecordId = '3675635' dbo.GetValidDeviceForAlertProcessData 2026-01-05 22:14:47.2805 AlertProcessor ProcessorAlertData: Stopped 2026-01-05 22:19:41.6734 AlertProcessor ProcessorAlertData: started 2026-01-05 22:19:47.1734 AlertProcessor ProcessorAlertData: Stopped 2026-01-05 22:24:41.6807 AlertProcessor ProcessorAlertData: started 2026-01-05 22:24:44.6183 DFramework.Database.Query /* Time Taken: 503*/ DECLARE @TableName AnsiString(8000) SET @TableName = 'AssetStockProductWiseConsolidate' DECLARE @CurrentRecordId Int32 SET @CurrentRecordId = '3675635' dbo.GetValidDeviceForAlertProcessData 2026-01-05 22:24:47.1808 AlertProcessor ProcessorAlertData: Stopped 2026-01-05 22:29:41.0424 DFramework.Scheduler.TaskBase /* Time Taken: 15562.6245*/ Opportunity Out Of Stock By Outlet 2026-01-05 22:29:41.6987 AlertProcessor ProcessorAlertData: started 2026-01-05 22:29:47.1987 AlertProcessor ProcessorAlertData: Stopped 2026-01-05 22:34:29.7180 MoveToReorder Running task for ClientId : 286 and ClientName = India Office QA and Slot: 1/6/2026 12:00:00 PM And LastExecutedOn: 1/6/2026 11:04:29 AM 2026-01-05 22:34:29.9367 MoveToReorder Task executed successfully for ClientId : 286 Client Name:India Office QA, Slot: 1/6/2026 12:00:00 PM But No Order found to suggest 2026-01-05 22:34:41.7025 AlertProcessor ProcessorAlertData: started 2026-01-05 22:34:47.0931 AlertProcessor ProcessorAlertData: Stopped 2026-01-05 22:39:41.7203 AlertProcessor ProcessorAlertData: started 2026-01-05 22:39:47.1578 AlertProcessor ProcessorAlertData: Stopped 2026-01-05 22:44:41.0506 DFramework.Scheduler.TaskBase /* Time Taken: 15562.6261*/ Opportunity Out Of Stock By Outlet 2026-01-05 22:44:41.7381 AlertProcessor ProcessorAlertData: started 2026-01-05 22:44:47.1131 AlertProcessor ProcessorAlertData: Stopped 2026-01-05 22:49:41.7559 AlertProcessor ProcessorAlertData: started 2026-01-05 22:49:47.1778 AlertProcessor ProcessorAlertData: Stopped 2026-01-05 22:54:41.7581 AlertProcessor ProcessorAlertData: started 2026-01-05 22:54:47.1019 AlertProcessor ProcessorAlertData: Stopped 2026-01-05 22:59:41.0570 DFramework.Scheduler.TaskBase /* Time Taken: 15546.9817*/ Opportunity Out Of Stock By Outlet 2026-01-05 22:59:41.7602 AlertProcessor ProcessorAlertData: started 2026-01-05 22:59:46.9477 AlertProcessor ProcessorAlertData: Stopped 2026-01-05 23:04:41.7780 AlertProcessor ProcessorAlertData: started 2026-01-05 23:04:47.2624 AlertProcessor ProcessorAlertData: Stopped 2026-01-05 23:09:41.7958 AlertProcessor ProcessorAlertData: started 2026-01-05 23:09:47.3271 AlertProcessor ProcessorAlertData: Stopped 2026-01-05 23:14:26.3603 DFramework.Database.Query /* Time Taken: 830*/ [dbo].GenerateSystemAlerts 2026-01-05 23:14:41.1416 DFramework.Scheduler.TaskBase /* Time Taken: 15609.4859*/ Opportunity Out Of Stock By Outlet 2026-01-05 23:14:41.8135 AlertProcessor ProcessorAlertData: started 2026-01-05 23:14:47.3448 AlertProcessor ProcessorAlertData: Stopped 2026-01-05 23:19:41.8313 AlertProcessor ProcessorAlertData: started 2026-01-05 23:19:47.2376 AlertProcessor ProcessorAlertData: Stopped 2026-01-05 23:24:41.8490 AlertProcessor ProcessorAlertData: started 2026-01-05 23:24:47.3803 AlertProcessor ProcessorAlertData: Stopped 2026-01-05 23:29:26.0685 DFramework.Database.Query /* Time Taken: 518*/ [dbo].GenerateSystemAlerts 2026-01-05 23:29:41.1623 DFramework.Scheduler.TaskBase /* Time Taken: 15609.4958*/ Opportunity Out Of Stock By Outlet 2026-01-05 23:29:41.8654 AlertProcessor ProcessorAlertData: started 2026-01-05 23:29:47.2874 AlertProcessor ProcessorAlertData: Stopped 2026-01-05 23:34:29.8050 MoveToReorder Running task for ClientId : 286 and ClientName = India Office QA and Slot: 1/6/2026 1:00:00 PM And LastExecutedOn: 1/6/2026 12:04:29 PM 2026-01-05 23:34:30.2738 MoveToReorder Task executed successfully for ClientId : 286 Client Name:India Office QA, Slot: 1/6/2026 1:00:00 PM and Total Order Suggested: 1 Out Of: 1 2026-01-05 23:34:41.8832 AlertProcessor ProcessorAlertData: started 2026-01-05 23:34:47.3677 AlertProcessor ProcessorAlertData: Stopped 2026-01-05 23:39:41.8855 AlertProcessor ProcessorAlertData: started 2026-01-05 23:39:47.1511 AlertProcessor ProcessorAlertData: Stopped 2026-01-05 23:44:26.0927 DFramework.Database.Query /* Time Taken: 523*/ [dbo].GenerateSystemAlerts 2026-01-05 23:44:41.1865 DFramework.Scheduler.TaskBase /* Time Taken: 15609.4892*/ Opportunity Out Of Stock By Outlet 2026-01-05 23:44:41.8896 AlertProcessor ProcessorAlertData: started 2026-01-05 23:44:47.2178 AlertProcessor ProcessorAlertData: Stopped 2026-01-05 23:49:41.9074 AlertProcessor ProcessorAlertData: started 2026-01-05 23:49:47.3762 AlertProcessor ProcessorAlertData: Stopped 2026-01-05 23:54:41.9233 AlertProcessor ProcessorAlertData: started 2026-01-05 23:54:47.2984 AlertProcessor ProcessorAlertData: Stopped 2026-01-05 23:59:41.1443 DFramework.Scheduler.TaskBase /* Time Taken: 15546.9853*/ Opportunity Out Of Stock By Outlet 2026-01-05 23:59:41.9412 AlertProcessor ProcessorAlertData: started 2026-01-05 23:59:47.3631 AlertProcessor ProcessorAlertData: Stopped