2025-12-27 00:04:40.7198 AlertProcessor ProcessorAlertData: started 2025-12-27 00:04:46.3761 AlertProcessor ProcessorAlertData: Stopped 2025-12-27 00:09:39.7532 DFramework.Database.Query /* Time Taken: 574*/ [dbo].GenerateSystemAlerts 2025-12-27 00:09:40.7220 AlertProcessor ProcessorAlertData: started 2025-12-27 00:09:44.9252 DFramework.Database.NullableDataReader Data reader open for 281 at System.Environment.GetStackTrace(Exception e, Boolean needFileInfo) at System.Environment.get_StackTrace() at DFramework.Database.NullableDataReader.Dispose(Boolean disposing) in D:\Spraxa\Framework\DFramework\Database\NullableDataReader.cs:line 33 at DFramework.Database.NullableDataReader.Dispose() in D:\Spraxa\Framework\DFramework\Database\NullableDataReader.cs:line 44 at CoolR.Tasks.ProcessAlertData.Execute() in D:\Spraxa\CoolR-Group\portal\CoolR.Tasks\ProcessAlertData.cs:line 47 at DFramework.Scheduler.TaskBase.Run() in D:\Spraxa\Framework\DFramework.Scheduler\TaskBase.cs:line 176 at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx) at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx) at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state) at System.Threading.ThreadHelper.ThreadStart() 2025-12-27 00:09:46.5970 AlertProcessor ProcessorAlertData: Stopped 2025-12-27 00:09:54.6908 DFramework.Scheduler.TaskBase /* Time Taken: 15796.9878*/ Opportunity Out Of Stock By Outlet 2025-12-27 00:14:40.7398 AlertProcessor ProcessorAlertData: started 2025-12-27 00:14:46.3493 AlertProcessor ProcessorAlertData: Stopped 2025-12-27 00:19:40.7578 AlertProcessor ProcessorAlertData: started 2025-12-27 00:19:46.3516 AlertProcessor ProcessorAlertData: Stopped 2025-12-27 00:24:39.7600 DFramework.Database.Query /* Time Taken: 562*/ [dbo].GenerateSystemAlerts 2025-12-27 00:24:40.7757 AlertProcessor ProcessorAlertData: started 2025-12-27 00:24:42.6194 DFramework.Database.Query /* Time Taken: 642*/ DECLARE @TableName AnsiString(8000) SET @TableName = 'AdditionalShelf' DECLARE @CurrentRecordId Int32 SET @CurrentRecordId = '3675192' dbo.GetValidDeviceForAlertProcessData 2025-12-27 00:24:46.6351 AlertProcessor ProcessorAlertData: Stopped 2025-12-27 00:24:54.6977 DFramework.Scheduler.TaskBase /* Time Taken: 15781.3664*/ Opportunity Out Of Stock By Outlet 2025-12-27 00:29:40.7935 AlertProcessor ProcessorAlertData: started 2025-12-27 00:29:46.3561 AlertProcessor ProcessorAlertData: Stopped 2025-12-27 00:34:39.9678 MoveToReorder Running task for ClientId : 286 and ClientName = India Office QA and Slot: 12/27/2025 2:00:00 PM And LastExecutedOn: 12/27/2025 1:04:39 PM 2025-12-27 00:34:40.8115 AlertProcessor ProcessorAlertData: started 2025-12-27 00:34:46.6866 AlertProcessor ProcessorAlertData: Stopped 2025-12-27 00:35:20.8119 DFramework.Database.NullableDataReader Data reader open for 40599 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() 2025-12-27 00:35:20.8431 MoveToReorder Task executed successfully for ClientId : 286 Client Name:India Office QA, Slot: 12/27/2025 2:00:00 PM and Total Order Suggested: 127 Out Of: 127 2025-12-27 00:35:22.3900 DFramework.Scheduler.TaskBase /* Time Taken: 42734.7108*/ Move To Re-Order 2025-12-27 00:39:39.7201 DFramework.Database.Query /* Time Taken: 530*/ [dbo].GenerateSystemAlerts 2025-12-27 00:39:40.8295 AlertProcessor ProcessorAlertData: started 2025-12-27 00:39:46.3451 AlertProcessor ProcessorAlertData: Stopped 2025-12-27 00:39:54.6577 DFramework.Scheduler.TaskBase /* Time Taken: 15718.8675*/ Opportunity Out Of Stock By Outlet 2025-12-27 00:44:40.8473 AlertProcessor ProcessorAlertData: started 2025-12-27 00:44:46.6442 AlertProcessor ProcessorAlertData: Stopped 2025-12-27 00:49:40.8652 AlertProcessor ProcessorAlertData: started 2025-12-27 00:49:46.4277 AlertProcessor ProcessorAlertData: Stopped 2025-12-27 00:54:39.8361 DFramework.Database.Query /* Time Taken: 609*/ [dbo].GenerateSystemAlerts 2025-12-27 00:54:40.8830 AlertProcessor ProcessorAlertData: started 2025-12-27 00:54:46.4299 AlertProcessor ProcessorAlertData: Stopped 2025-12-27 00:54:54.7581 DFramework.Scheduler.TaskBase /* Time Taken: 15796.9713*/ Opportunity Out Of Stock By Outlet 2025-12-27 00:59:40.9008 AlertProcessor ProcessorAlertData: started 2025-12-27 00:59:46.5259 AlertProcessor ProcessorAlertData: Stopped 2025-12-27 01:04:40.9187 AlertProcessor ProcessorAlertData: started 2025-12-27 01:04:46.5749 AlertProcessor ProcessorAlertData: Stopped 2025-12-27 01:09:40.9349 AlertProcessor ProcessorAlertData: started 2025-12-27 01:09:46.2630 AlertProcessor ProcessorAlertData: Stopped 2025-12-27 01:09:54.6849 DFramework.Scheduler.TaskBase /* Time Taken: 15703.1799*/ Opportunity Out Of Stock By Outlet 2025-12-27 01:14:40.9520 AlertProcessor ProcessorAlertData: started 2025-12-27 01:14:46.3895 AlertProcessor ProcessorAlertData: Stopped 2025-12-27 01:19:40.9696 AlertProcessor ProcessorAlertData: started 2025-12-27 01:19:46.3134 AlertProcessor ProcessorAlertData: Stopped 2025-12-27 01:24:40.9886 AlertProcessor ProcessorAlertData: started 2025-12-27 01:24:46.1762 AlertProcessor ProcessorAlertData: Stopped 2025-12-27 01:24:54.7075 DFramework.Scheduler.TaskBase /* Time Taken: 15703.3586*/ Opportunity Out Of Stock By Outlet 2025-12-27 01:29:41.0077 AlertProcessor ProcessorAlertData: started 2025-12-27 01:29:42.1952 DFramework.Database.Query /* Time Taken: 503*/ DECLARE @TableName AnsiString(8000) SET @TableName = 'MissingShelf' DECLARE @CurrentRecordId Int32 SET @CurrentRecordId = '3675192' dbo.GetValidDeviceForAlertProcessData 2025-12-27 01:29:46.4453 DFramework.Database.Query /* Time Taken: 505*/ DECLARE @TableName AnsiString(8000) SET @TableName = 'ProductStockLevel' DECLARE @CurrentRecordId Int32 SET @CurrentRecordId = '3675192' dbo.GetValidDeviceForAlertProcessData 2025-12-27 01:29:46.4921 AlertProcessor ProcessorAlertData: Stopped 2025-12-27 01:34:40.0415 MoveToReorder Running task for ClientId : 286 and ClientName = India Office QA and Slot: 12/27/2025 3:00:00 PM And LastExecutedOn: 12/27/2025 2:04:39 PM 2025-12-27 01:34:40.4947 DFramework.Database.NullableDataReader Data reader open for 236 at System.Environment.GetStackTrace(Exception e, Boolean needFileInfo) at System.Environment.get_StackTrace() at DFramework.Database.NullableDataReader.Dispose(Boolean disposing) in D:\Spraxa\Framework\DFramework\Database\NullableDataReader.cs:line 33 at DFramework.Database.NullableDataReader.Dispose() in D:\Spraxa\Framework\DFramework\Database\NullableDataReader.cs:line 44 at CoolR.Tasks.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() 2025-12-27 01:34:40.5259 MoveToReorder Task executed successfully for ClientId : 286 Client Name:India Office QA, Slot: 12/27/2025 3:00:00 PM and Total Order Suggested: 1 Out Of: 1 2025-12-27 01:34:41.0103 AlertProcessor ProcessorAlertData: started 2025-12-27 01:34:46.7760 AlertProcessor ProcessorAlertData: Stopped 2025-12-27 01:39:39.8094 DFramework.Database.Query /* Time Taken: 526*/ [dbo].GenerateSystemAlerts 2025-12-27 01:39:41.0282 AlertProcessor ProcessorAlertData: started 2025-12-27 01:39:44.8251 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() 2025-12-27 01:39:46.7626 AlertProcessor ProcessorAlertData: Stopped 2025-12-27 01:39:54.7939 DFramework.Scheduler.TaskBase /* Time Taken: 15765.7611*/ Opportunity Out Of Stock By Outlet 2025-12-27 01:44:41.0307 AlertProcessor ProcessorAlertData: started 2025-12-27 01:44:46.5620 AlertProcessor ProcessorAlertData: Stopped 2025-12-27 01:49:41.0485 AlertProcessor ProcessorAlertData: started 2025-12-27 01:49:46.1267 AlertProcessor ProcessorAlertData: Stopped 2025-12-27 01:54:39.8320 DFramework.Database.Query /* Time Taken: 518*/ [dbo].GenerateSystemAlerts 2025-12-27 01:54:41.0664 AlertProcessor ProcessorAlertData: started 2025-12-27 01:54:46.4258 AlertProcessor ProcessorAlertData: Stopped 2025-12-27 01:54:54.8009 DFramework.Scheduler.TaskBase /* Time Taken: 15750.1408*/ Opportunity Out Of Stock By Outlet 2025-12-27 01:59:41.0844 AlertProcessor ProcessorAlertData: started 2025-12-27 01:59:46.1625 AlertProcessor ProcessorAlertData: Stopped 2025-12-27 02:04:41.1023 AlertProcessor ProcessorAlertData: started 2025-12-27 02:04:46.2898 AlertProcessor ProcessorAlertData: Stopped 2025-12-27 02:09:39.9326 DFramework.Database.Query /* Time Taken: 596*/ [dbo].GenerateSystemAlerts 2025-12-27 02:09:41.1201 AlertProcessor ProcessorAlertData: started 2025-12-27 02:09:46.5576 AlertProcessor ProcessorAlertData: Stopped 2025-12-27 02:09:54.8077 DFramework.Scheduler.TaskBase /* Time Taken: 15734.4938*/ Opportunity Out Of Stock By Outlet 2025-12-27 02:14:41.1224 AlertProcessor ProcessorAlertData: started 2025-12-27 02:14:46.7787 AlertProcessor ProcessorAlertData: Stopped 2025-12-27 02:19:41.1403 AlertProcessor ProcessorAlertData: started 2025-12-27 02:19:46.6403 AlertProcessor ProcessorAlertData: Stopped 2025-12-27 02:24:41.1581 AlertProcessor ProcessorAlertData: started 2025-12-27 02:24:42.3456 DFramework.Database.Query /* Time Taken: 537*/ DECLARE @TableName AnsiString(8000) SET @TableName = 'MissingShelf' DECLARE @CurrentRecordId Int32 SET @CurrentRecordId = '3675192' dbo.GetValidDeviceForAlertProcessData 2025-12-27 02:24:46.4082 AlertProcessor ProcessorAlertData: Stopped 2025-12-27 02:24:54.7676 DFramework.Scheduler.TaskBase /* Time Taken: 15671.9847*/ Opportunity Out Of Stock By Outlet 2025-12-27 02:29:41.1760 AlertProcessor ProcessorAlertData: started 2025-12-27 02:29:46.3010 AlertProcessor ProcessorAlertData: Stopped 2025-12-27 02:34:40.1313 MoveToReorder Running task for ClientId : 286 and ClientName = India Office QA and Slot: 12/27/2025 4:00:00 PM And LastExecutedOn: 12/27/2025 3:04:39 PM 2025-12-27 02:34:40.3344 MoveToReorder Task executed successfully for ClientId : 286 Client Name:India Office QA, Slot: 12/27/2025 4:00:00 PM But No Order found to suggest 2025-12-27 02:34:41.1938 AlertProcessor ProcessorAlertData: started 2025-12-27 02:34:42.8501 DFramework.Database.Query /* Time Taken: 596*/ DECLARE @TableName AnsiString(8000) SET @TableName = 'AdditionalShelf' DECLARE @CurrentRecordId Int32 SET @CurrentRecordId = '3675192' dbo.GetValidDeviceForAlertProcessData 2025-12-27 02:34:46.4438 AlertProcessor ProcessorAlertData: Stopped 2025-12-27 02:39:39.9147 DFramework.Database.Query /* Time Taken: 531*/ [dbo].GenerateSystemAlerts 2025-12-27 02:39:41.2116 AlertProcessor ProcessorAlertData: started 2025-12-27 02:39:46.2585 AlertProcessor ProcessorAlertData: Stopped 2025-12-27 02:39:54.8211 DFramework.Scheduler.TaskBase /* Time Taken: 15703.2388*/ Opportunity Out Of Stock By Outlet 2025-12-27 02:44:41.2138 AlertProcessor ProcessorAlertData: started 2025-12-27 02:44:46.4951 AlertProcessor ProcessorAlertData: Stopped 2025-12-27 02:49:41.2162 AlertProcessor ProcessorAlertData: started 2025-12-27 02:49:46.1850 AlertProcessor ProcessorAlertData: Stopped 2025-12-27 02:54:41.2343 AlertProcessor ProcessorAlertData: started 2025-12-27 02:54:46.4062 AlertProcessor ProcessorAlertData: Stopped 2025-12-27 02:54:54.8125 DFramework.Scheduler.TaskBase /* Time Taken: 15671.9883*/ Opportunity Out Of Stock By Outlet 2025-12-27 02:59:41.2522 AlertProcessor ProcessorAlertData: started 2025-12-27 02:59:46.2522 AlertProcessor ProcessorAlertData: Stopped 2025-12-27 03:04:41.2700 AlertProcessor ProcessorAlertData: started 2025-12-27 03:04:46.3325 AlertProcessor ProcessorAlertData: Stopped 2025-12-27 03:09:41.2723 AlertProcessor ProcessorAlertData: started 2025-12-27 03:09:46.3348 AlertProcessor ProcessorAlertData: Stopped 2025-12-27 03:09:54.8349 DFramework.Scheduler.TaskBase /* Time Taken: 15671.9911*/ Opportunity Out Of Stock By Outlet 2025-12-27 03:14:41.2901 AlertProcessor ProcessorAlertData: started 2025-12-27 03:14:46.6808 AlertProcessor ProcessorAlertData: Stopped 2025-12-27 03:19:41.3079 AlertProcessor ProcessorAlertData: started 2025-12-27 03:19:46.3705 AlertProcessor ProcessorAlertData: Stopped 2025-12-27 03:24:41.3259 AlertProcessor ProcessorAlertData: started 2025-12-27 03:24:46.4978 AlertProcessor ProcessorAlertData: Stopped 2025-12-27 03:24:54.8729 DFramework.Scheduler.TaskBase /* Time Taken: 15687.6225*/ Opportunity Out Of Stock By Outlet 2025-12-27 03:29:41.3438 AlertProcessor ProcessorAlertData: started 2025-12-27 03:29:46.4219 AlertProcessor ProcessorAlertData: Stopped 2025-12-27 03:34:40.2366 MoveToReorder Running task for ClientId : 286 and ClientName = India Office QA and Slot: 12/27/2025 5:00:00 PM And LastExecutedOn: 12/27/2025 4:04:40 PM 2025-12-27 03:34:41.3616 AlertProcessor ProcessorAlertData: started 2025-12-27 03:34:41.9397 DFramework.Database.Query /* Time Taken: 572*/ DECLARE @TableName AnsiString(8000) SET @TableName = 'TagAlert' DECLARE @CurrentRecordId Int32 SET @CurrentRecordId = '0' dbo.GetValidDeviceForAlertProcessData 2025-12-27 03:34:46.8616 DFramework.Database.Query /* Time Taken: 601*/ DECLARE @TableName AnsiString(8000) SET @TableName = 'ProductStockLevel' DECLARE @CurrentRecordId Int32 SET @CurrentRecordId = '3675192' dbo.GetValidDeviceForAlertProcessData 2025-12-27 03:34:46.9085 AlertProcessor ProcessorAlertData: Stopped 2025-12-27 03:35:19.6900 DFramework.Database.NullableDataReader Data reader open for 39240 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() 2025-12-27 03:35:19.7213 MoveToReorder Task executed successfully for ClientId : 286 Client Name:India Office QA, Slot: 12/27/2025 5:00:00 PM and Total Order Suggested: 127 Out Of: 127 2025-12-27 03:35:20.6900 DFramework.Scheduler.TaskBase /* Time Taken: 40765.9166*/ Move To Re-Order 2025-12-27 03:39:41.3795 AlertProcessor ProcessorAlertData: started 2025-12-27 03:39:46.5358 AlertProcessor ProcessorAlertData: Stopped 2025-12-27 03:39:54.9421 DFramework.Scheduler.TaskBase /* Time Taken: 15734.5143*/ Opportunity Out Of Stock By Outlet 2025-12-27 03:44:41.3976 AlertProcessor ProcessorAlertData: started 2025-12-27 03:44:43.0539 DFramework.Database.Query /* Time Taken: 588*/ DECLARE @TableName AnsiString(8000) SET @TableName = 'AdditionalShelf' DECLARE @CurrentRecordId Int32 SET @CurrentRecordId = '3675192' dbo.GetValidDeviceForAlertProcessData 2025-12-27 03:44:46.7258 AlertProcessor ProcessorAlertData: Stopped 2025-12-27 03:49:41.4155 AlertProcessor ProcessorAlertData: started 2025-12-27 03:49:46.5093 AlertProcessor ProcessorAlertData: Stopped 2025-12-27 03:54:41.4333 AlertProcessor ProcessorAlertData: started 2025-12-27 03:54:46.5896 AlertProcessor ProcessorAlertData: Stopped 2025-12-27 03:54:54.9022 DFramework.Scheduler.TaskBase /* Time Taken: 15671.9913*/ Opportunity Out Of Stock By Outlet 2025-12-27 03:59:41.4512 AlertProcessor ProcessorAlertData: started 2025-12-27 03:59:46.4981 AlertProcessor ProcessorAlertData: Stopped 2025-12-27 04:04:41.4535 AlertProcessor ProcessorAlertData: started 2025-12-27 04:04:46.7191 AlertProcessor ProcessorAlertData: Stopped 2025-12-27 04:09:41.4713 AlertProcessor ProcessorAlertData: started 2025-12-27 04:09:46.5963 AlertProcessor ProcessorAlertData: Stopped 2025-12-27 04:09:54.9714 DFramework.Scheduler.TaskBase /* Time Taken: 15718.8644*/ Opportunity Out Of Stock By Outlet 2025-12-27 04:14:41.4891 AlertProcessor ProcessorAlertData: started 2025-12-27 04:14:46.7548 AlertProcessor ProcessorAlertData: Stopped 2025-12-27 04:19:41.5070 AlertProcessor ProcessorAlertData: started 2025-12-27 04:19:46.5851 AlertProcessor ProcessorAlertData: Stopped 2025-12-27 04:24:40.0091 DFramework.Database.Query /* Time Taken: 509*/ [dbo].GenerateSystemAlerts 2025-12-27 04:24:41.5248 AlertProcessor ProcessorAlertData: started 2025-12-27 04:24:46.6342 AlertProcessor ProcessorAlertData: Stopped 2025-12-27 04:24:54.9467 DFramework.Scheduler.TaskBase /* Time Taken: 15671.9897*/ Opportunity Out Of Stock By Outlet 2025-12-27 04:29:41.5426 AlertProcessor ProcessorAlertData: started 2025-12-27 04:29:46.5895 AlertProcessor ProcessorAlertData: Stopped 2025-12-27 04:34:40.3419 MoveToReorder Running task for ClientId : 286 and ClientName = India Office QA and Slot: 12/27/2025 6:00:00 PM And LastExecutedOn: 12/27/2025 5:04:40 PM 2025-12-27 04:34:40.8106 DFramework.Database.NullableDataReader Data reader open for 268 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() 2025-12-27 04:34:40.8419 MoveToReorder Task executed successfully for ClientId : 286 Client Name:India Office QA, Slot: 12/27/2025 6:00:00 PM and Total Order Suggested: 1 Out Of: 1 2025-12-27 04:34:41.5606 AlertProcessor ProcessorAlertData: started 2025-12-27 04:34:46.8576 AlertProcessor ProcessorAlertData: Stopped 2025-12-27 04:39:40.0316 DFramework.Database.Query /* Time Taken: 515*/ [dbo].GenerateSystemAlerts 2025-12-27 04:39:41.5785 AlertProcessor ProcessorAlertData: started 2025-12-27 04:39:46.6098 AlertProcessor ProcessorAlertData: Stopped 2025-12-27 04:39:54.9693 DFramework.Scheduler.TaskBase /* Time Taken: 15671.9893*/ Opportunity Out Of Stock By Outlet 2025-12-27 04:44:41.5964 AlertProcessor ProcessorAlertData: started 2025-12-27 04:44:45.6277 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() 2025-12-27 04:44:46.8933 AlertProcessor ProcessorAlertData: Stopped 2025-12-27 04:49:41.5987 AlertProcessor ProcessorAlertData: started 2025-12-27 04:49:46.6768 AlertProcessor ProcessorAlertData: Stopped 2025-12-27 04:54:41.6165 AlertProcessor ProcessorAlertData: started 2025-12-27 04:54:46.7416 AlertProcessor ProcessorAlertData: Stopped 2025-12-27 04:54:54.9916 DFramework.Scheduler.TaskBase /* Time Taken: 15671.9906*/ Opportunity Out Of Stock By Outlet 2025-12-27 04:59:41.6344 AlertProcessor ProcessorAlertData: started 2025-12-27 04:59:46.7438 AlertProcessor ProcessorAlertData: Stopped 2025-12-27 05:04:41.6523 AlertProcessor ProcessorAlertData: started 2025-12-27 05:04:46.7461 AlertProcessor ProcessorAlertData: Stopped 2025-12-27 05:09:41.6545 AlertProcessor ProcessorAlertData: started 2025-12-27 05:09:46.8576 AlertProcessor ProcessorAlertData: Stopped 2025-12-27 05:09:55.0608 DFramework.Scheduler.TaskBase /* Time Taken: 15718.8636*/ Opportunity Out Of Stock By Outlet 2025-12-27 05:14:41.6723 AlertProcessor ProcessorAlertData: started 2025-12-27 05:14:46.7505 AlertProcessor ProcessorAlertData: Stopped 2025-12-27 05:19:41.6902 AlertProcessor ProcessorAlertData: started 2025-12-27 05:19:46.8308 AlertProcessor ProcessorAlertData: Stopped 2025-12-27 05:24:41.7081 AlertProcessor ProcessorAlertData: started 2025-12-27 05:24:46.8019 AlertProcessor ProcessorAlertData: Stopped 2025-12-27 05:24:55.0989 DFramework.Scheduler.TaskBase /* Time Taken: 15734.4955*/ Opportunity Out Of Stock By Outlet 2025-12-27 05:29:41.7260 AlertProcessor ProcessorAlertData: started 2025-12-27 05:29:46.8198 AlertProcessor ProcessorAlertData: Stopped 2025-12-27 05:34:40.4627 MoveToReorder Running task for ClientId : 286 and ClientName = India Office QA and Slot: 12/27/2025 7:00:00 PM And LastExecutedOn: 12/27/2025 6:04:40 PM 2025-12-27 05:34:40.6658 MoveToReorder Task executed successfully for ClientId : 286 Client Name:India Office QA, Slot: 12/27/2025 7:00:00 PM But No Order found to suggest 2025-12-27 05:34:41.7439 AlertProcessor ProcessorAlertData: started 2025-12-27 05:34:43.7283 DFramework.Database.NullableDataReader Data reader open for 268 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() 2025-12-27 05:34:47.2127 AlertProcessor ProcessorAlertData: Stopped 2025-12-27 05:39:41.7461 AlertProcessor ProcessorAlertData: started 2025-12-27 05:39:46.9181 AlertProcessor ProcessorAlertData: Stopped 2025-12-27 05:39:55.1056 DFramework.Scheduler.TaskBase /* Time Taken: 15718.8703*/ Opportunity Out Of Stock By Outlet 2025-12-27 05:44:41.7640 AlertProcessor ProcessorAlertData: started 2025-12-27 05:44:46.8734 AlertProcessor ProcessorAlertData: Stopped 2025-12-27 05:49:41.7819 AlertProcessor ProcessorAlertData: started 2025-12-27 05:49:46.8444 AlertProcessor ProcessorAlertData: Stopped 2025-12-27 05:54:41.7997 AlertProcessor ProcessorAlertData: started 2025-12-27 05:54:46.9404 AlertProcessor ProcessorAlertData: Stopped 2025-12-27 05:54:55.1279 DFramework.Scheduler.TaskBase /* Time Taken: 15734.4923*/ Opportunity Out Of Stock By Outlet 2025-12-27 05:59:41.8021 AlertProcessor ProcessorAlertData: started 2025-12-27 05:59:46.8802 AlertProcessor ProcessorAlertData: Stopped 2025-12-27 06:04:41.8043 AlertProcessor ProcessorAlertData: started 2025-12-27 06:04:46.9137 AlertProcessor ProcessorAlertData: Stopped 2025-12-27 06:09:41.8222 AlertProcessor ProcessorAlertData: started 2025-12-27 06:09:46.9160 AlertProcessor ProcessorAlertData: Stopped 2025-12-27 06:09:55.0879 DFramework.Scheduler.TaskBase /* Time Taken: 15671.9908*/ Opportunity Out Of Stock By Outlet 2025-12-27 06:14:41.8401 AlertProcessor ProcessorAlertData: started 2025-12-27 06:14:47.0745 AlertProcessor ProcessorAlertData: Stopped 2025-12-27 06:19:41.8579 AlertProcessor ProcessorAlertData: started 2025-12-27 06:19:47.0611 AlertProcessor ProcessorAlertData: Stopped 2025-12-27 06:24:41.8758 AlertProcessor ProcessorAlertData: started 2025-12-27 06:24:43.5320 DFramework.Database.Query /* Time Taken: 598*/ DECLARE @TableName AnsiString(8000) SET @TableName = 'AdditionalShelf' DECLARE @CurrentRecordId Int32 SET @CurrentRecordId = '3675192' dbo.GetValidDeviceForAlertProcessData 2025-12-27 06:24:47.2196 AlertProcessor ProcessorAlertData: Stopped 2025-12-27 06:24:55.1415 DFramework.Scheduler.TaskBase /* Time Taken: 15718.8678*/ Opportunity Out Of Stock By Outlet 2025-12-27 06:29:41.8936 AlertProcessor ProcessorAlertData: started 2025-12-27 06:29:46.9249 AlertProcessor ProcessorAlertData: Stopped 2025-12-27 06:34:40.5834 MoveToReorder Running task for ClientId : 286 and ClientName = India Office QA and Slot: 12/27/2025 8:00:00 PM And LastExecutedOn: 12/27/2025 7:04:40 PM 2025-12-27 06:34:41.9115 AlertProcessor ProcessorAlertData: started 2025-12-27 06:34:47.3490 AlertProcessor ProcessorAlertData: Stopped 2025-12-27 06:35:20.1618 DFramework.Database.NullableDataReader Data reader open for 39343 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() 2025-12-27 06:35:20.1774 MoveToReorder Task executed successfully for ClientId : 286 Client Name:India Office QA, Slot: 12/27/2025 8:00:00 PM and Total Order Suggested: 127 Out Of: 127 2025-12-27 06:35:20.9743 DFramework.Scheduler.TaskBase /* Time Taken: 40703.4256*/ Move To Re-Order 2025-12-27 06:39:40.2419 DFramework.Database.Query /* Time Taken: 586*/ [dbo].GenerateSystemAlerts 2025-12-27 06:39:41.9138 AlertProcessor ProcessorAlertData: started 2025-12-27 06:39:46.9919 AlertProcessor ProcessorAlertData: Stopped 2025-12-27 06:39:55.2732 DFramework.Scheduler.TaskBase /* Time Taken: 15828.2517*/ Opportunity Out Of Stock By Outlet 2025-12-27 06:44:41.9316 AlertProcessor ProcessorAlertData: started 2025-12-27 06:44:45.1504 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() 2025-12-27 06:44:47.3535 AlertProcessor ProcessorAlertData: Stopped 2025-12-27 06:49:41.9495 AlertProcessor ProcessorAlertData: started 2025-12-27 06:49:47.0277 AlertProcessor ProcessorAlertData: Stopped 2025-12-27 06:54:41.9674 AlertProcessor ProcessorAlertData: started 2025-12-27 06:54:47.0925 AlertProcessor ProcessorAlertData: Stopped 2025-12-27 06:54:55.1394 DFramework.Scheduler.TaskBase /* Time Taken: 15687.6159*/ Opportunity Out Of Stock By Outlet 2025-12-27 06:59:41.9853 AlertProcessor ProcessorAlertData: started 2025-12-27 06:59:47.0947 AlertProcessor ProcessorAlertData: Stopped 2025-12-27 07:04:42.0032 AlertProcessor ProcessorAlertData: started 2025-12-27 07:04:47.1282 AlertProcessor ProcessorAlertData: Stopped 2025-12-27 07:09:42.0054 AlertProcessor ProcessorAlertData: started 2025-12-27 07:09:47.1148 AlertProcessor ProcessorAlertData: Stopped 2025-12-27 07:09:55.1461 DFramework.Scheduler.TaskBase /* Time Taken: 15671.9854*/ Opportunity Out Of Stock By Outlet 2025-12-27 07:14:42.0233 AlertProcessor ProcessorAlertData: started 2025-12-27 07:14:47.1952 AlertProcessor ProcessorAlertData: Stopped 2025-12-27 07:19:42.0411 AlertProcessor ProcessorAlertData: started 2025-12-27 07:19:47.1818 AlertProcessor ProcessorAlertData: Stopped 2025-12-27 07:24:42.0591 AlertProcessor ProcessorAlertData: started 2025-12-27 07:24:43.3091 DFramework.Database.Query /* Time Taken: 585*/ DECLARE @TableName AnsiString(8000) SET @TableName = 'MissingShelf' DECLARE @CurrentRecordId Int32 SET @CurrentRecordId = '3675192' dbo.GetValidDeviceForAlertProcessData 2025-12-27 07:24:47.3717 AlertProcessor ProcessorAlertData: Stopped 2025-12-27 07:24:55.1686 DFramework.Scheduler.TaskBase /* Time Taken: 15671.9965*/ Opportunity Out Of Stock By Outlet 2025-12-27 07:29:42.0770 AlertProcessor ProcessorAlertData: started 2025-12-27 07:29:47.4364 AlertProcessor ProcessorAlertData: Stopped 2025-12-27 07:34:40.6418 MoveToReorder Running task for ClientId : 286 and ClientName = India Office QA and Slot: 12/27/2025 9:00:00 PM And LastExecutedOn: 12/27/2025 8:04:40 PM 2025-12-27 07:34:41.1261 DFramework.Database.NullableDataReader Data reader open for 252 at System.Environment.GetStackTrace(Exception e, Boolean needFileInfo) at System.Environment.get_StackTrace() at DFramework.Database.NullableDataReader.Dispose(Boolean disposing) in 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() 2025-12-27 07:34:41.1418 MoveToReorder Task executed successfully for ClientId : 286 Client Name:India Office QA, Slot: 12/27/2025 9:00:00 PM and Total Order Suggested: 1 Out Of: 1 2025-12-27 07:34:42.0949 AlertProcessor ProcessorAlertData: started 2025-12-27 07:34:43.6887 DFramework.Database.Query /* Time Taken: 525*/ DECLARE @TableName AnsiString(8000) SET @TableName = 'AdditionalShelf' DECLARE @CurrentRecordId Int32 SET @CurrentRecordId = '3675192' dbo.GetValidDeviceForAlertProcessData 2025-12-27 07:34:47.3918 AlertProcessor ProcessorAlertData: Stopped 2025-12-27 07:39:42.1128 AlertProcessor ProcessorAlertData: started 2025-12-27 07:39:47.1753 AlertProcessor ProcessorAlertData: Stopped 2025-12-27 07:39:55.1910 DFramework.Scheduler.TaskBase /* Time Taken: 15671.9971*/ Opportunity Out Of Stock By Outlet 2025-12-27 07:44:42.1306 AlertProcessor ProcessorAlertData: started 2025-12-27 07:44:47.1775 AlertProcessor ProcessorAlertData: Stopped 2025-12-27 07:49:42.1485 AlertProcessor ProcessorAlertData: started 2025-12-27 07:49:47.2110 AlertProcessor ProcessorAlertData: Stopped 2025-12-27 07:54:40.3850 DFramework.Database.Query /* Time Taken: 627*/ [dbo].GenerateSystemAlerts 2025-12-27 07:54:42.1663 AlertProcessor ProcessorAlertData: started 2025-12-27 07:54:47.2445 AlertProcessor ProcessorAlertData: Stopped 2025-12-27 07:54:55.2445 DFramework.Scheduler.TaskBase /* Time Taken: 15718.8663*/ Opportunity Out Of Stock By Outlet 2025-12-27 07:59:42.1842 AlertProcessor ProcessorAlertData: started 2025-12-27 07:59:47.2468 AlertProcessor ProcessorAlertData: Stopped 2025-12-27 08:04:42.2021 AlertProcessor ProcessorAlertData: started 2025-12-27 08:04:47.2803 AlertProcessor ProcessorAlertData: Stopped 2025-12-27 08:09:42.2200 AlertProcessor ProcessorAlertData: started 2025-12-27 08:09:47.3137 AlertProcessor ProcessorAlertData: Stopped 2025-12-27 08:09:55.2044 DFramework.Scheduler.TaskBase /* Time Taken: 15671.9885*/ Opportunity Out Of Stock By Outlet 2025-12-27 08:14:42.2378 AlertProcessor ProcessorAlertData: started 2025-12-27 08:14:43.4097 DFramework.Database.Query /* Time Taken: 539*/ DECLARE @TableName AnsiString(8000) SET @TableName = 'MissingShelf' DECLARE @CurrentRecordId Int32 SET @CurrentRecordId = '3675192' dbo.GetValidDeviceForAlertProcessData 2025-12-27 08:14:47.4097 AlertProcessor ProcessorAlertData: Stopped 2025-12-27 08:19:42.2557 AlertProcessor ProcessorAlertData: started 2025-12-27 08:19:47.3651 AlertProcessor ProcessorAlertData: Stopped 2025-12-27 08:24:42.2736 AlertProcessor ProcessorAlertData: started 2025-12-27 08:24:47.4298 AlertProcessor ProcessorAlertData: Stopped 2025-12-27 08:24:55.2268 DFramework.Scheduler.TaskBase /* Time Taken: 15672.0009*/ Opportunity Out Of Stock By Outlet 2025-12-27 08:29:42.2914 AlertProcessor ProcessorAlertData: started 2025-12-27 08:29:47.5883 AlertProcessor ProcessorAlertData: Stopped 2025-12-27 08:34:40.7468 MoveToReorder Running task for ClientId : 286 and ClientName = India Office QA and Slot: 12/27/2025 10:00:00 PM And LastExecutedOn: 12/27/2025 9:04:40 PM 2025-12-27 08:34:40.9500 MoveToReorder Task executed successfully for ClientId : 286 Client Name:India Office QA, Slot: 12/27/2025 10:00:00 PM But No Order found to suggest 2025-12-27 08:34:42.3093 AlertProcessor ProcessorAlertData: started 2025-12-27 08:34:42.8718 DFramework.Database.Query /* Time Taken: 572*/ DECLARE @TableName AnsiString(8000) SET @TableName = 'TagAlert' DECLARE @CurrentRecordId Int32 SET @CurrentRecordId = '0' dbo.GetValidDeviceForAlertProcessData 2025-12-27 08:34:48.1688 AlertProcessor ProcessorAlertData: Stopped 2025-12-27 08:39:40.3585 DFramework.Database.Query /* Time Taken: 546*/ [dbo].GenerateSystemAlerts 2025-12-27 08:39:42.3272 AlertProcessor ProcessorAlertData: started 2025-12-27 08:39:47.9991 AlertProcessor ProcessorAlertData: Stopped 2025-12-27 08:39:55.3273 DFramework.Scheduler.TaskBase /* Time Taken: 15750.1173*/ Opportunity Out Of Stock By Outlet 2025-12-27 08:44:42.3294 AlertProcessor ProcessorAlertData: started 2025-12-27 08:44:43.6888 DFramework.Database.Query /* Time Taken: 684*/ DECLARE @TableName AnsiString(8000) SET @TableName = 'MissingShelf' DECLARE @CurrentRecordId Int32 SET @CurrentRecordId = '3675192' dbo.GetValidDeviceForAlertProcessData 2025-12-27 08:44:48.2045 AlertProcessor ProcessorAlertData: Stopped 2025-12-27 08:49:42.3473 AlertProcessor ProcessorAlertData: started 2025-12-27 08:49:47.9723 AlertProcessor ProcessorAlertData: Stopped 2025-12-27 08:54:40.3651 DFramework.Database.Query /* Time Taken: 543*/ [dbo].GenerateSystemAlerts 2025-12-27 08:54:42.3651 AlertProcessor ProcessorAlertData: started 2025-12-27 08:54:47.9589 AlertProcessor ProcessorAlertData: Stopped 2025-12-27 08:54:55.3027 DFramework.Scheduler.TaskBase /* Time Taken: 15718.8655*/ Opportunity Out Of Stock By Outlet 2025-12-27 08:59:42.3830 AlertProcessor ProcessorAlertData: started 2025-12-27 08:59:48.0549 DFramework.Database.Query /* Time Taken: 509*/ DECLARE @TableName AnsiString(8000) SET @TableName = 'ProductStockLevel' DECLARE @CurrentRecordId Int32 SET @CurrentRecordId = '3675192' dbo.GetValidDeviceForAlertProcessData 2025-12-27 08:59:48.1018 AlertProcessor ProcessorAlertData: Stopped 2025-12-27 09:04:42.4008 AlertProcessor ProcessorAlertData: started 2025-12-27 09:04:47.9477 AlertProcessor ProcessorAlertData: Stopped 2025-12-27 09:09:40.4030 DFramework.Database.Query /* Time Taken: 553*/ [dbo].GenerateSystemAlerts 2025-12-27 09:09:42.4187 AlertProcessor ProcessorAlertData: started 2025-12-27 09:09:48.0437 AlertProcessor ProcessorAlertData: Stopped 2025-12-27 09:09:55.3250 DFramework.Scheduler.TaskBase /* Time Taken: 15734.4939*/ Opportunity Out Of Stock By Outlet 2025-12-27 09:14:42.4365 AlertProcessor ProcessorAlertData: started 2025-12-27 09:14:48.0147 AlertProcessor ProcessorAlertData: Stopped 2025-12-27 09:19:42.4544 AlertProcessor ProcessorAlertData: started 2025-12-27 09:19:48.1106 AlertProcessor ProcessorAlertData: Stopped 2025-12-27 09:24:40.4097 DFramework.Database.Query /* Time Taken: 535*/ [dbo].GenerateSystemAlerts 2025-12-27 09:24:42.4722 AlertProcessor ProcessorAlertData: started 2025-12-27 09:24:48.0816 AlertProcessor ProcessorAlertData: Stopped 2025-12-27 09:24:55.3786 DFramework.Scheduler.TaskBase /* Time Taken: 15765.7408*/ Opportunity Out Of Stock By Outlet 2025-12-27 09:29:42.4901 AlertProcessor ProcessorAlertData: started 2025-12-27 09:29:48.0214 AlertProcessor ProcessorAlertData: Stopped 2025-12-27 09:34:42.4923 AlertProcessor ProcessorAlertData: started 2025-12-27 09:34:48.0548 AlertProcessor ProcessorAlertData: Stopped 2025-12-27 09:39:40.4321 DFramework.Database.Query /* Time Taken: 545*/ [dbo].GenerateSystemAlerts 2025-12-27 09:39:42.5102 AlertProcessor ProcessorAlertData: started 2025-12-27 09:39:48.1040 AlertProcessor ProcessorAlertData: Stopped 2025-12-27 09:39:55.3384 DFramework.Scheduler.TaskBase /* Time Taken: 15703.2452*/ Opportunity Out Of Stock By Outlet 2025-12-27 09:44:42.5281 AlertProcessor ProcessorAlertData: started 2025-12-27 09:44:48.2469 AlertProcessor ProcessorAlertData: Stopped 2025-12-27 09:49:42.5460 AlertProcessor ProcessorAlertData: started 2025-12-27 09:49:48.0773 AlertProcessor ProcessorAlertData: Stopped 2025-12-27 09:54:40.4544 DFramework.Database.Query /* Time Taken: 542*/ [dbo].GenerateSystemAlerts 2025-12-27 09:54:42.5638 AlertProcessor ProcessorAlertData: started 2025-12-27 09:54:48.2357 AlertProcessor ProcessorAlertData: Stopped 2025-12-27 09:54:55.4077 DFramework.Scheduler.TaskBase /* Time Taken: 15750.1252*/ Opportunity Out Of Stock By Outlet 2025-12-27 09:59:42.5817 AlertProcessor ProcessorAlertData: started 2025-12-27 09:59:48.1443 AlertProcessor ProcessorAlertData: Stopped 2025-12-27 10:04:42.5996 AlertProcessor ProcessorAlertData: started 2025-12-27 10:04:48.1465 AlertProcessor ProcessorAlertData: Stopped 2025-12-27 10:09:40.4924 DFramework.Database.Query /* Time Taken: 551*/ [dbo].GenerateSystemAlerts 2025-12-27 10:09:42.6174 AlertProcessor ProcessorAlertData: started 2025-12-27 10:09:48.2737 AlertProcessor ProcessorAlertData: Stopped 2025-12-27 10:09:55.3988 DFramework.Scheduler.TaskBase /* Time Taken: 15718.8689*/ Opportunity Out Of Stock By Outlet 2025-12-27 10:14:42.6354 AlertProcessor ProcessorAlertData: started 2025-12-27 10:14:45.7604 DFramework.Database.Query /* Time Taken: 503*/ DECLARE @TableName AnsiString(8000) SET @TableName = 'AssetStockProductWiseConsolidate' DECLARE @CurrentRecordId Int32 SET @CurrentRecordId = '3675192' dbo.GetValidDeviceForAlertProcessData 2025-12-27 10:14:48.3542 AlertProcessor ProcessorAlertData: Stopped 2025-12-27 10:19:42.6532 AlertProcessor ProcessorAlertData: started 2025-12-27 10:19:48.3564 AlertProcessor ProcessorAlertData: Stopped 2025-12-27 10:24:40.8586 DFramework.Database.Query /* Time Taken: 900*/ [dbo].GenerateSystemAlerts 2025-12-27 10:24:42.6711 AlertProcessor ProcessorAlertData: started 2025-12-27 10:24:48.2649 AlertProcessor ProcessorAlertData: Stopped 2025-12-27 10:24:55.4056 DFramework.Scheduler.TaskBase /* Time Taken: 15703.2402*/ Opportunity Out Of Stock By Outlet 2025-12-27 10:29:42.6885 AlertProcessor ProcessorAlertData: started 2025-12-27 10:29:48.2666 AlertProcessor ProcessorAlertData: Stopped 2025-12-27 10:34:42.7050 AlertProcessor ProcessorAlertData: started 2025-12-27 10:34:48.1894 AlertProcessor ProcessorAlertData: Stopped 2025-12-27 10:39:40.5974 DFramework.Database.Query /* Time Taken: 610*/ [dbo].GenerateSystemAlerts 2025-12-27 10:39:42.7224 AlertProcessor ProcessorAlertData: started 2025-12-27 10:39:48.4256 AlertProcessor ProcessorAlertData: Stopped 2025-12-27 10:39:55.4725 DFramework.Scheduler.TaskBase /* Time Taken: 15750.0936*/ Opportunity Out Of Stock By Outlet 2025-12-27 10:44:42.7402 AlertProcessor ProcessorAlertData: started 2025-12-27 10:44:48.3965 DFramework.Database.Query /* Time Taken: 562*/ DECLARE @TableName AnsiString(8000) SET @TableName = 'ProductStockLevel' DECLARE @CurrentRecordId Int32 SET @CurrentRecordId = '3675192' dbo.GetValidDeviceForAlertProcessData 2025-12-27 10:44:48.4433 AlertProcessor ProcessorAlertData: Stopped 2025-12-27 10:49:42.7595 AlertProcessor ProcessorAlertData: started 2025-12-27 10:49:48.3846 AlertProcessor ProcessorAlertData: Stopped 2025-12-27 10:54:40.5593 DFramework.Database.Query /* Time Taken: 561*/ [dbo].GenerateSystemAlerts 2025-12-27 10:54:42.7625 AlertProcessor ProcessorAlertData: started 2025-12-27 10:54:48.2156 AlertProcessor ProcessorAlertData: Stopped 2025-12-27 10:54:55.4501 DFramework.Scheduler.TaskBase /* Time Taken: 15703.26*/ Opportunity Out Of Stock By Outlet 2025-12-27 10:59:42.7649 AlertProcessor ProcessorAlertData: started 2025-12-27 10:59:48.3430 AlertProcessor ProcessorAlertData: Stopped 2025-12-27 11:04:42.7828 AlertProcessor ProcessorAlertData: started 2025-12-27 11:04:48.2984 AlertProcessor ProcessorAlertData: Stopped 2025-12-27 11:09:40.5663 DFramework.Database.Query /* Time Taken: 542*/ [dbo].GenerateSystemAlerts 2025-12-27 11:09:42.8006 AlertProcessor ProcessorAlertData: started 2025-12-27 11:09:48.3632 AlertProcessor ProcessorAlertData: Stopped 2025-12-27 11:09:55.5351 DFramework.Scheduler.TaskBase /* Time Taken: 15765.74*/ Opportunity Out Of Stock By Outlet 2025-12-27 11:14:42.8185 AlertProcessor ProcessorAlertData: started 2025-12-27 11:14:45.9592 DFramework.Database.Query /* Time Taken: 559*/ DECLARE @TableName AnsiString(8000) SET @TableName = 'AssetStockProductWiseConsolidate' DECLARE @CurrentRecordId Int32 SET @CurrentRecordId = '3675192' dbo.GetValidDeviceForAlertProcessData 2025-12-27 11:14:48.5529 AlertProcessor ProcessorAlertData: Stopped 2025-12-27 11:19:42.8364 AlertProcessor ProcessorAlertData: started 2025-12-27 11:19:48.3676 AlertProcessor ProcessorAlertData: Stopped 2025-12-27 11:24:40.5887 DFramework.Database.Query /* Time Taken: 537*/ [dbo].GenerateSystemAlerts 2025-12-27 11:24:42.8544 AlertProcessor ProcessorAlertData: started 2025-12-27 11:24:48.4013 AlertProcessor ProcessorAlertData: Stopped 2025-12-27 11:24:55.5576 DFramework.Scheduler.TaskBase /* Time Taken: 15781.3742*/ Opportunity Out Of Stock By Outlet 2025-12-27 11:29:42.8722 AlertProcessor ProcessorAlertData: started 2025-12-27 11:29:48.3567 AlertProcessor ProcessorAlertData: Stopped 2025-12-27 11:34:42.8745 AlertProcessor ProcessorAlertData: started 2025-12-27 11:34:48.4995 AlertProcessor ProcessorAlertData: Stopped 2025-12-27 11:39:40.6424 DFramework.Database.Query /* Time Taken: 566*/ [dbo].GenerateSystemAlerts 2025-12-27 11:39:42.8924 AlertProcessor ProcessorAlertData: started 2025-12-27 11:39:48.4705 AlertProcessor ProcessorAlertData: Stopped 2025-12-27 11:39:55.4862 DFramework.Scheduler.TaskBase /* Time Taken: 15687.6192*/ Opportunity Out Of Stock By Outlet 2025-12-27 11:44:42.9102 AlertProcessor ProcessorAlertData: started 2025-12-27 11:44:48.3321 AlertProcessor ProcessorAlertData: Stopped 2025-12-27 11:49:42.9125 AlertProcessor ProcessorAlertData: started 2025-12-27 11:49:48.5063 AlertProcessor ProcessorAlertData: Stopped 2025-12-27 11:54:40.6178 DFramework.Database.Query /* Time Taken: 531*/ [dbo].GenerateSystemAlerts 2025-12-27 11:54:42.9147 AlertProcessor ProcessorAlertData: started 2025-12-27 11:54:48.4929 AlertProcessor ProcessorAlertData: Stopped 2025-12-27 11:54:55.4929 DFramework.Scheduler.TaskBase /* Time Taken: 15687.617*/ Opportunity Out Of Stock By Outlet 2025-12-27 11:59:42.9169 AlertProcessor ProcessorAlertData: started 2025-12-27 11:59:48.3076 AlertProcessor ProcessorAlertData: Stopped 2025-12-27 12:04:42.9348 AlertProcessor ProcessorAlertData: started 2025-12-27 12:04:48.4817 AlertProcessor ProcessorAlertData: Stopped 2025-12-27 12:09:40.6089 DFramework.Database.Query /* Time Taken: 528*/ [dbo].GenerateSystemAlerts 2025-12-27 12:09:42.9526 AlertProcessor ProcessorAlertData: started 2025-12-27 12:09:48.5308 AlertProcessor ProcessorAlertData: Stopped 2025-12-27 12:09:55.5465 DFramework.Scheduler.TaskBase /* Time Taken: 15718.8659*/ Opportunity Out Of Stock By Outlet 2025-12-27 12:14:42.9706 AlertProcessor ProcessorAlertData: started 2025-12-27 12:14:43.4862 DFramework.Database.Query /* Time Taken: 516*/ DECLARE @TableName AnsiString(8000) SET @TableName = 'TagAlert' DECLARE @CurrentRecordId Int32 SET @CurrentRecordId = '0' dbo.GetValidDeviceForAlertProcessData 2025-12-27 12:14:48.6738 AlertProcessor ProcessorAlertData: Stopped 2025-12-27 12:19:42.9885 AlertProcessor ProcessorAlertData: started 2025-12-27 12:19:48.5510 AlertProcessor ProcessorAlertData: Stopped 2025-12-27 12:24:40.6313 DFramework.Database.Query /* Time Taken: 528*/ [dbo].GenerateSystemAlerts 2025-12-27 12:24:43.0063 AlertProcessor ProcessorAlertData: started 2025-12-27 12:24:44.3501 DFramework.Database.Query /* Time Taken: 679*/ DECLARE @TableName AnsiString(8000) SET @TableName = 'MissingShelf' DECLARE @CurrentRecordId Int32 SET @CurrentRecordId = '3675192' dbo.GetValidDeviceForAlertProcessData 2025-12-27 12:24:48.8658 AlertProcessor ProcessorAlertData: Stopped 2025-12-27 12:24:55.6002 DFramework.Scheduler.TaskBase /* Time Taken: 15750.1148*/ Opportunity Out Of Stock By Outlet 2025-12-27 12:29:43.0242 AlertProcessor ProcessorAlertData: started 2025-12-27 12:29:48.6024 AlertProcessor ProcessorAlertData: Stopped 2025-12-27 12:34:43.0266 AlertProcessor ProcessorAlertData: started 2025-12-27 12:34:48.5735 AlertProcessor ProcessorAlertData: Stopped 2025-12-27 12:39:40.6694 DFramework.Database.Query /* Time Taken: 531*/ [dbo].GenerateSystemAlerts 2025-12-27 12:39:43.0444 AlertProcessor ProcessorAlertData: started 2025-12-27 12:39:48.5445 AlertProcessor ProcessorAlertData: Stopped 2025-12-27 12:39:55.5757 DFramework.Scheduler.TaskBase /* Time Taken: 15703.2425*/ Opportunity Out Of Stock By Outlet 2025-12-27 12:44:43.0623 AlertProcessor ProcessorAlertData: started 2025-12-27 12:44:48.6248 AlertProcessor ProcessorAlertData: Stopped 2025-12-27 12:49:43.0646 AlertProcessor ProcessorAlertData: started 2025-12-27 12:49:48.6740 AlertProcessor ProcessorAlertData: Stopped 2025-12-27 12:54:40.6762 DFramework.Database.Query /* Time Taken: 529*/ [dbo].GenerateSystemAlerts 2025-12-27 12:54:43.0824 AlertProcessor ProcessorAlertData: started 2025-12-27 12:54:48.5981 AlertProcessor ProcessorAlertData: Stopped 2025-12-27 12:54:55.6294 DFramework.Scheduler.TaskBase /* Time Taken: 15734.4747*/ Opportunity Out Of Stock By Outlet 2025-12-27 12:59:43.0847 AlertProcessor ProcessorAlertData: started 2025-12-27 12:59:48.6316 AlertProcessor ProcessorAlertData: Stopped 2025-12-27 13:04:43.1025 AlertProcessor ProcessorAlertData: started 2025-12-27 13:04:48.6338 AlertProcessor ProcessorAlertData: Stopped 2025-12-27 13:09:40.7141 DFramework.Database.Query /* Time Taken: 536*/ [dbo].GenerateSystemAlerts 2025-12-27 13:09:43.1048 AlertProcessor ProcessorAlertData: started 2025-12-27 13:09:48.6985 AlertProcessor ProcessorAlertData: Stopped 2025-12-27 13:09:55.6205 DFramework.Scheduler.TaskBase /* Time Taken: 15703.2412*/ Opportunity Out Of Stock By Outlet 2025-12-27 13:14:43.1226 AlertProcessor ProcessorAlertData: started 2025-12-27 13:14:48.6383 AlertProcessor ProcessorAlertData: Stopped 2025-12-27 13:19:43.1405 AlertProcessor ProcessorAlertData: started 2025-12-27 13:19:48.7030 AlertProcessor ProcessorAlertData: Stopped 2025-12-27 13:24:40.7364 DFramework.Database.Query /* Time Taken: 539*/ [dbo].GenerateSystemAlerts 2025-12-27 13:24:43.1427 AlertProcessor ProcessorAlertData: started 2025-12-27 13:24:48.7209 AlertProcessor ProcessorAlertData: Stopped 2025-12-27 13:24:55.6272 DFramework.Scheduler.TaskBase /* Time Taken: 15687.6163*/ Opportunity Out Of Stock By Outlet 2025-12-27 13:29:43.1606 AlertProcessor ProcessorAlertData: started 2025-12-27 13:29:48.6606 AlertProcessor ProcessorAlertData: Stopped 2025-12-27 13:34:43.1784 AlertProcessor ProcessorAlertData: started 2025-12-27 13:34:48.7097 AlertProcessor ProcessorAlertData: Stopped 2025-12-27 13:39:40.7588 DFramework.Database.Query /* Time Taken: 535*/ [dbo].GenerateSystemAlerts 2025-12-27 13:39:43.1963 AlertProcessor ProcessorAlertData: started 2025-12-27 13:39:47.3526 DFramework.Database.NullableDataReader Data reader open for 282 at System.Environment.GetStackTrace(Exception e, Boolean needFileInfo) at System.Environment.get_StackTrace() at DFramework.Database.NullableDataReader.Dispose(Boolean disposing) in 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() 2025-12-27 13:39:49.0089 AlertProcessor ProcessorAlertData: Stopped 2025-12-27 13:39:55.7121 DFramework.Scheduler.TaskBase /* Time Taken: 15750.1225*/ Opportunity Out Of Stock By Outlet 2025-12-27 13:44:43.2142 AlertProcessor ProcessorAlertData: started 2025-12-27 13:44:48.8861 AlertProcessor ProcessorAlertData: Stopped 2025-12-27 13:49:43.2165 AlertProcessor ProcessorAlertData: started 2025-12-27 13:49:48.7478 AlertProcessor ProcessorAlertData: Stopped 2025-12-27 13:54:40.7812 DFramework.Database.Query /* Time Taken: 534*/ [dbo].GenerateSystemAlerts 2025-12-27 13:54:43.2343 AlertProcessor ProcessorAlertData: started 2025-12-27 13:54:48.7969 AlertProcessor ProcessorAlertData: Stopped 2025-12-27 13:54:55.7500 DFramework.Scheduler.TaskBase /* Time Taken: 15765.7394*/ Opportunity Out Of Stock By Outlet 2025-12-27 13:59:43.2522 AlertProcessor ProcessorAlertData: started 2025-12-27 13:59:48.8616 AlertProcessor ProcessorAlertData: Stopped 2025-12-27 14:04:43.2700 AlertProcessor ProcessorAlertData: started 2025-12-27 14:04:48.8795 AlertProcessor ProcessorAlertData: Stopped 2025-12-27 14:09:40.8191 DFramework.Database.Query /* Time Taken: 546*/ [dbo].GenerateSystemAlerts 2025-12-27 14:09:43.2723 AlertProcessor ProcessorAlertData: started 2025-12-27 14:09:48.8661 AlertProcessor ProcessorAlertData: Stopped 2025-12-27 14:09:55.7724 DFramework.Scheduler.TaskBase /* Time Taken: 15765.7405*/ Opportunity Out Of Stock By Outlet 2025-12-27 14:14:43.2746 AlertProcessor ProcessorAlertData: started 2025-12-27 14:14:48.8059 AlertProcessor ProcessorAlertData: Stopped 2025-12-27 14:19:43.2768 AlertProcessor ProcessorAlertData: started 2025-12-27 14:19:48.8237 AlertProcessor ProcessorAlertData: Stopped 2025-12-27 14:24:40.8259 DFramework.Database.Query /* Time Taken: 538*/ [dbo].GenerateSystemAlerts 2025-12-27 14:24:43.2947 AlertProcessor ProcessorAlertData: started 2025-12-27 14:24:48.9197 AlertProcessor ProcessorAlertData: Stopped 2025-12-27 14:24:55.7948 DFramework.Scheduler.TaskBase /* Time Taken: 15765.7394*/ Opportunity Out Of Stock By Outlet 2025-12-27 14:29:43.3126 AlertProcessor ProcessorAlertData: started 2025-12-27 14:29:45.7345 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() 2025-12-27 14:29:49.0314 AlertProcessor ProcessorAlertData: Stopped 2025-12-27 14:32:31.8296 DFramework.Database.Query /* Time Taken: 921*/ 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 2025-12-27 14:34:43.3306 AlertProcessor ProcessorAlertData: started 2025-12-27 14:34:46.5962 DFramework.Database.NullableDataReader Data reader open for 283 at System.Environment.GetStackTrace(Exception e, Boolean needFileInfo) at System.Environment.get_StackTrace() at DFramework.Database.NullableDataReader.Dispose(Boolean disposing) in D:\Spraxa\Framework\DFramework\Database\NullableDataReader.cs:line 33 at DFramework.Database.NullableDataReader.Dispose() in D:\Spraxa\Framework\DFramework\Database\NullableDataReader.cs:line 44 at CoolR.Tasks.ProcessAlertData.Execute() in D:\Spraxa\CoolR-Group\portal\CoolR.Tasks\ProcessAlertData.cs:line 47 at DFramework.Scheduler.TaskBase.Run() in D:\Spraxa\Framework\DFramework.Scheduler\TaskBase.cs:line 176 at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx) at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx) at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state) at System.Threading.ThreadHelper.ThreadStart() 2025-12-27 14:34:49.1744 AlertProcessor ProcessorAlertData: Stopped 2025-12-27 14:39:40.8328 DFramework.Database.Query /* Time Taken: 527*/ [dbo].GenerateSystemAlerts 2025-12-27 14:39:43.3484 AlertProcessor ProcessorAlertData: started 2025-12-27 14:39:48.8172 AlertProcessor ProcessorAlertData: Stopped 2025-12-27 14:39:55.7548 DFramework.Scheduler.TaskBase /* Time Taken: 15703.2429*/ Opportunity Out Of Stock By Outlet 2025-12-27 14:44:43.3663 AlertProcessor ProcessorAlertData: started 2025-12-27 14:44:48.9445 AlertProcessor ProcessorAlertData: Stopped 2025-12-27 14:49:43.3842 AlertProcessor ProcessorAlertData: started 2025-12-27 14:49:48.9624 AlertProcessor ProcessorAlertData: Stopped 2025-12-27 14:54:40.8552 DFramework.Database.Query /* Time Taken: 527*/ [dbo].GenerateSystemAlerts 2025-12-27 14:54:43.4021 AlertProcessor ProcessorAlertData: started 2025-12-27 14:54:48.9021 AlertProcessor ProcessorAlertData: Stopped 2025-12-27 14:54:55.7772 DFramework.Scheduler.TaskBase /* Time Taken: 15703.2412*/ Opportunity Out Of Stock By Outlet 2025-12-27 14:59:43.4200 AlertProcessor ProcessorAlertData: started 2025-12-27 14:59:48.9825 AlertProcessor ProcessorAlertData: Stopped 2025-12-27 15:04:43.4378 AlertProcessor ProcessorAlertData: started 2025-12-27 15:04:48.9222 AlertProcessor ProcessorAlertData: Stopped 2025-12-27 15:09:40.8931 DFramework.Database.Query /* Time Taken: 537*/ [dbo].GenerateSystemAlerts 2025-12-27 15:09:43.4556 AlertProcessor ProcessorAlertData: started 2025-12-27 15:09:49.0338 AlertProcessor ProcessorAlertData: Stopped 2025-12-27 15:09:55.7994 DFramework.Scheduler.TaskBase /* Time Taken: 15703.2424*/ Opportunity Out Of Stock By Outlet 2025-12-27 15:14:43.4734 AlertProcessor ProcessorAlertData: started 2025-12-27 15:14:49.0204 AlertProcessor ProcessorAlertData: Stopped 2025-12-27 15:19:43.4913 AlertProcessor ProcessorAlertData: started 2025-12-27 15:19:49.1007 AlertProcessor ProcessorAlertData: Stopped 2025-12-27 15:24:40.9154 DFramework.Database.Query /* Time Taken: 535*/ [dbo].GenerateSystemAlerts 2025-12-27 15:24:43.5092 AlertProcessor ProcessorAlertData: started 2025-12-27 15:24:49.1342 AlertProcessor ProcessorAlertData: Stopped 2025-12-27 15:24:55.8061 DFramework.Scheduler.TaskBase /* Time Taken: 15687.6142*/ Opportunity Out Of Stock By Outlet 2025-12-27 15:29:43.5114 AlertProcessor ProcessorAlertData: started 2025-12-27 15:29:49.0739 AlertProcessor ProcessorAlertData: Stopped 2025-12-27 15:34:43.5292 AlertProcessor ProcessorAlertData: started 2025-12-27 15:34:49.0761 AlertProcessor ProcessorAlertData: Stopped 2025-12-27 15:39:40.9533 DFramework.Database.Query /* Time Taken: 547*/ [dbo].GenerateSystemAlerts 2025-12-27 15:39:43.5471 AlertProcessor ProcessorAlertData: started 2025-12-27 15:39:49.2659 AlertProcessor ProcessorAlertData: Stopped 2025-12-27 15:39:55.9065 DFramework.Scheduler.TaskBase /* Time Taken: 15765.7392*/ Opportunity Out Of Stock By Outlet 2025-12-27 15:44:43.5649 AlertProcessor ProcessorAlertData: started 2025-12-27 15:44:49.1274 AlertProcessor ProcessorAlertData: Stopped 2025-12-27 15:49:43.5828 AlertProcessor ProcessorAlertData: started 2025-12-27 15:49:49.1140 AlertProcessor ProcessorAlertData: Stopped 2025-12-27 15:54:40.9587 DFramework.Database.Query /* Time Taken: 543*/ [dbo].GenerateSystemAlerts 2025-12-27 15:54:43.5995 AlertProcessor ProcessorAlertData: started 2025-12-27 15:54:49.1775 AlertProcessor ProcessorAlertData: Stopped 2025-12-27 15:54:55.8493 DFramework.Scheduler.TaskBase /* Time Taken: 15687.4629*/ Opportunity Out Of Stock By Outlet 2025-12-27 15:59:43.6155 AlertProcessor ProcessorAlertData: started 2025-12-27 15:59:49.3967 AlertProcessor ProcessorAlertData: Stopped 2025-12-27 16:04:43.6328 AlertProcessor ProcessorAlertData: started 2025-12-27 16:04:49.2578 AlertProcessor ProcessorAlertData: Stopped 2025-12-27 16:09:43.6505 AlertProcessor ProcessorAlertData: started 2025-12-27 16:09:49.3849 AlertProcessor ProcessorAlertData: Stopped 2025-12-27 16:09:55.9318 DFramework.Scheduler.TaskBase /* Time Taken: 15765.7357*/ Opportunity Out Of Stock By Outlet 2025-12-27 16:14:43.6708 AlertProcessor ProcessorAlertData: started 2025-12-27 16:14:49.2490 AlertProcessor ProcessorAlertData: Stopped 2025-12-27 16:19:43.6895 AlertProcessor ProcessorAlertData: started 2025-12-27 16:19:49.2208 DFramework.Database.Query /* Time Taken: 514*/ DECLARE @TableName AnsiString(8000) SET @TableName = 'ProductStockLevel' DECLARE @CurrentRecordId Int32 SET @CurrentRecordId = '3675192' dbo.GetValidDeviceForAlertProcessData 2025-12-27 16:19:49.2833 AlertProcessor ProcessorAlertData: Stopped 2025-12-27 16:24:41.0045 DFramework.Database.Query /* Time Taken: 558*/ [dbo].GenerateSystemAlerts 2025-12-27 16:24:43.7076 AlertProcessor ProcessorAlertData: started 2025-12-27 16:24:49.2389 AlertProcessor ProcessorAlertData: Stopped 2025-12-27 16:24:55.9733 DFramework.Scheduler.TaskBase /* Time Taken: 15781.3729*/ Opportunity Out Of Stock By Outlet 2025-12-27 16:29:43.7255 AlertProcessor ProcessorAlertData: started 2025-12-27 16:29:49.2881 AlertProcessor ProcessorAlertData: Stopped 2025-12-27 16:32:31.3205 DFramework.Database.Query /* Time Taken: 587*/ 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 2025-12-27 16:32:31.3205 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 2025-12-27 16:32:39.1955 DFramework.Database.Query /* Time Taken: 3448*/ 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 2025-12-27 16:32:39.1955 DFramework.Database.Query /* Time Taken: 3448*/ 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 2025-12-27 16:32:46.9612 DFramework.Database.Query /* Time Taken: 1196*/ 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 2025-12-27 16:32:46.9612 DFramework.Database.Query /* Time Taken: 1197*/ 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 2025-12-27 16:34:43.7433 AlertProcessor ProcessorAlertData: started 2025-12-27 16:34:49.2746 AlertProcessor ProcessorAlertData: Stopped 2025-12-27 16:35:06.7435 DFramework.Database.Query /* Time Taken: 581*/ 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 2025-12-27 16:39:43.7612 AlertProcessor ProcessorAlertData: started 2025-12-27 16:39:49.2144 AlertProcessor ProcessorAlertData: Stopped 2025-12-27 16:39:55.9019 DFramework.Scheduler.TaskBase /* Time Taken: 15687.6099*/ Opportunity Out Of Stock By Outlet 2025-12-27 16:44:43.7790 AlertProcessor ProcessorAlertData: started 2025-12-27 16:44:49.2791 AlertProcessor ProcessorAlertData: Stopped 2025-12-27 16:49:43.7969 AlertProcessor ProcessorAlertData: started 2025-12-27 16:49:49.2814 AlertProcessor ProcessorAlertData: Stopped 2025-12-27 16:54:43.8148 AlertProcessor ProcessorAlertData: started 2025-12-27 16:54:49.4242 AlertProcessor ProcessorAlertData: Stopped 2025-12-27 16:54:55.9555 DFramework.Scheduler.TaskBase /* Time Taken: 15718.8719*/ Opportunity Out Of Stock By Outlet 2025-12-27 16:59:43.8327 AlertProcessor ProcessorAlertData: started 2025-12-27 16:59:49.4108 AlertProcessor ProcessorAlertData: Stopped 2025-12-27 17:04:43.8505 AlertProcessor ProcessorAlertData: started 2025-12-27 17:04:49.4131 AlertProcessor ProcessorAlertData: Stopped 2025-12-27 17:09:43.8684 AlertProcessor ProcessorAlertData: started 2025-12-27 17:09:49.4622 AlertProcessor ProcessorAlertData: Stopped 2025-12-27 17:09:55.9778 DFramework.Scheduler.TaskBase /* Time Taken: 15718.863*/ Opportunity Out Of Stock By Outlet 2025-12-27 17:14:43.8863 AlertProcessor ProcessorAlertData: started 2025-12-27 17:14:49.4019 AlertProcessor ProcessorAlertData: Stopped 2025-12-27 17:19:43.9041 AlertProcessor ProcessorAlertData: started 2025-12-27 17:19:49.4510 AlertProcessor ProcessorAlertData: Stopped 2025-12-27 17:24:43.9219 AlertProcessor ProcessorAlertData: started 2025-12-27 17:24:49.5939 AlertProcessor ProcessorAlertData: Stopped 2025-12-27 17:24:55.9689 DFramework.Scheduler.TaskBase /* Time Taken: 15687.6215*/ Opportunity Out Of Stock By Outlet 2025-12-27 17:29:43.9398 AlertProcessor ProcessorAlertData: started 2025-12-27 17:29:45.3148 DFramework.Database.NullableDataReader Data reader open for 281 at System.Environment.GetStackTrace(Exception e, Boolean needFileInfo) at System.Environment.get_StackTrace() at DFramework.Database.NullableDataReader.Dispose(Boolean disposing) in D:\Spraxa\Framework\DFramework\Database\NullableDataReader.cs:line 33 at DFramework.Database.NullableDataReader.Dispose() in D:\Spraxa\Framework\DFramework\Database\NullableDataReader.cs:line 44 at CoolR.Tasks.ProcessAlertData.Execute() in D:\Spraxa\CoolR-Group\portal\CoolR.Tasks\ProcessAlertData.cs:line 47 at DFramework.Scheduler.TaskBase.Run() in D:\Spraxa\Framework\DFramework.Scheduler\TaskBase.cs:line 176 at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx) at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx) at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state) at System.Threading.ThreadHelper.ThreadStart() 2025-12-27 17:29:49.6898 AlertProcessor ProcessorAlertData: Stopped 2025-12-27 17:34:43.9576 AlertProcessor ProcessorAlertData: started 2025-12-27 17:34:49.4889 AlertProcessor ProcessorAlertData: Stopped 2025-12-27 17:39:43.9755 AlertProcessor ProcessorAlertData: started 2025-12-27 17:39:49.4912 AlertProcessor ProcessorAlertData: Stopped 2025-12-27 17:39:56.0068 DFramework.Scheduler.TaskBase /* Time Taken: 15718.8628*/ Opportunity Out Of Stock By Outlet 2025-12-27 17:44:43.9933 AlertProcessor ProcessorAlertData: started 2025-12-27 17:44:49.6496 AlertProcessor ProcessorAlertData: Stopped 2025-12-27 17:49:44.0112 AlertProcessor ProcessorAlertData: started 2025-12-27 17:49:49.5425 AlertProcessor ProcessorAlertData: Stopped 2025-12-27 17:54:44.0290 AlertProcessor ProcessorAlertData: started 2025-12-27 17:54:49.3728 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() 2025-12-27 17:54:49.8572 AlertProcessor ProcessorAlertData: Stopped 2025-12-27 17:54:56.0604 DFramework.Scheduler.TaskBase /* Time Taken: 15750.1223*/ Opportunity Out Of Stock By Outlet 2025-12-27 17:59:44.0469 AlertProcessor ProcessorAlertData: started 2025-12-27 17:59:49.4844 AlertProcessor ProcessorAlertData: Stopped 2025-12-27 18:04:44.0648 AlertProcessor ProcessorAlertData: started 2025-12-27 18:04:44.8616 DFramework.Database.Query /* Time Taken: 542*/ DECLARE @StatusId Int32 SET @StatusId = '1' DECLARE @AlertId Int32 SET @AlertId = '7571914' SELECT TOP 10000 Alert.AlertId, Alert.LocationId, Alert.RecordId, ISNULL(AlertDefinition.Name, Alert.AlertText) Name, Alert.AlertTypeId, Alert.AlertText, ISNULL(Location.Name, '') AS LocationName, AlertDefinition.ClientId, AlertRecipient.RoleId, CASE WHEN Alert.AlertTypeId IN (6,7) THEN CONVERT(VARCHAR(10), CAST(AlertAt AS DATE), 101) ELSE AlertAt END AS AlertAt, AlertType, Asset.SerialNumber, ISNULL(LocationAttribute.FirstRepId, 0) RepId, ClientUser.PrimaryPhone AS SalesRepPhone, ClientUser.PrimaryEmail AS SalesRepEmail, FirstName, LastName, PreferedNotificationTypeIds, AlertRecipientId, AlertRecipientAddress, AlertRecipientText, Alert.Tags, AlertRecipientTypeId, NotificationContactTypeId, TemplateId, AlertDefinition.AlertAgeThreshold, LastUpdatedOn, AlertRecipient.AlertAge, CASE WHEN Location.TimeZoneId IS NOT NULL AND Location.TimeZoneId > 0 THEN Location.TimeZoneId ELSE Client.TimeZoneId END AS TimeZoneId, AlertDefinition.IsSummarize, Alert.ClosedOn, AssetType.IsChestCooler, AlertDefinition.SnoozeForHours, Alert.SnoozeDateTime FROM Alert LEFT OUTER JOIN Asset ON Alert.AssetId = Asset.AssetId LEFT OUTER JOIN AlertType ON Alert.AlertTypeId = AlertType.AlertTypeId LEFT OUTER JOIN AlertDefinition ON Alert.AlertDefinitionId = AlertDefinition.AlertDefinitionId LEFT OUTER JOIN Location ON Location.LocationId = Alert.LocationId LEFT OUTER JOIN LocationAttribute ON LocationAttribute.LocationId = dbo.Location.LocationId LEFT OUTER JOIN ClientUser ON LocationAttribute.FirstRepId = ClientUser.ClientUserId AND ClientUser.IsDeleted = 0 LEFT OUTER JOIN AlertRecipient ON Alert.AlertDefinitionId = AlertRecipient.AlertDefinitionId AND AlertRecipient.IsDeleted= 0 LEFT OUTER JOIN Client ON Client.ClientId = Alert.ClientId LEFT OUTER JOIN AssetType ON dbo.Asset.AssetTypeId = dbo.AssetType.AssetTypeId WHERE (NOT EXISTS(SELECT 1 FROM dbo.EmailQueue INNER JOIN dbo.EmailRecipient ON EmailRecipient.EmailQueueId = EmailQueue.EmailQueueId WHERE AlertId = Alert.AlertId AND EmailRecipient.RecipientId = AlertRecipient.AlertRecipientId) OR (Alert.SnoozeDateTime IS NOT NULL AND Alert.SnoozeDateTime <= GETUTCDATE() AND AlertDefinition.SnoozeForHours > 0 AND Alert.StatusId = @StatusId)) AND Alert.AlertId > @AlertId AND Alert.AlertAt >= DATEADD(DAY, -120, GETDATE()) AND AlertRecipient.IsDeleted = 0 AND Alert.IsActive = 1 AND Alert.IsDeleted = 0 AND AlertRecipient.IsActive = 1 AND AlertRecipient.IsDeleted = 0 AND AlertRecipient.StartDate <= Alert.CreatedOn AND Alert.CreatedOn < DATEADD(hh, 23, AlertRecipient.EndDate) AND (Alert.LocationId != 0 OR NotificationWithoutLocation = 1) AND AlertType.IsSystemAlert = 0 AND Alert.EmailQueuedOn IS NULL AND AlertDefinition.IsActive = 1 2025-12-27 18:04:49.7679 AlertProcessor ProcessorAlertData: Stopped 2025-12-27 18:09:41.6763 DFramework.Database.Query /* Time Taken: 1087*/ [dbo].GenerateSystemAlerts 2025-12-27 18:09:44.0826 AlertProcessor ProcessorAlertData: started 2025-12-27 18:09:47.1764 DFramework.Database.Query /* Time Taken: 529*/ DECLARE @TableName AnsiString(8000) SET @TableName = 'AssetStockProductWiseConsolidate' DECLARE @CurrentRecordId Int32 SET @CurrentRecordId = '3675192' dbo.GetValidDeviceForAlertProcessData 2025-12-27 18:09:49.7701 AlertProcessor ProcessorAlertData: Stopped 2025-12-27 18:09:56.3952 DFramework.Scheduler.TaskBase /* Time Taken: 16062.6287*/ Opportunity Out Of Stock By Outlet 2025-12-27 18:14:44.1005 AlertProcessor ProcessorAlertData: started 2025-12-27 18:14:49.6942 AlertProcessor ProcessorAlertData: Stopped 2025-12-27 18:19:44.1183 AlertProcessor ProcessorAlertData: started 2025-12-27 18:19:49.6340 AlertProcessor ProcessorAlertData: Stopped 2025-12-27 18:24:44.1361 AlertProcessor ProcessorAlertData: started 2025-12-27 18:24:49.8081 AlertProcessor ProcessorAlertData: Stopped 2025-12-27 18:24:56.1675 DFramework.Scheduler.TaskBase /* Time Taken: 15828.272*/ Opportunity Out Of Stock By Outlet 2025-12-27 18:29:44.1538 AlertProcessor ProcessorAlertData: started 2025-12-27 18:29:49.6851 AlertProcessor ProcessorAlertData: Stopped 2025-12-27 18:34:44.1716 AlertProcessor ProcessorAlertData: started 2025-12-27 18:34:49.7029 AlertProcessor ProcessorAlertData: Stopped 2025-12-27 18:39:44.1894 AlertProcessor ProcessorAlertData: started 2025-12-27 18:39:49.8145 AlertProcessor ProcessorAlertData: Stopped 2025-12-27 18:39:56.1739 DFramework.Scheduler.TaskBase /* Time Taken: 15828.2464*/ Opportunity Out Of Stock By Outlet 2025-12-27 18:44:44.2072 AlertProcessor ProcessorAlertData: started 2025-12-27 18:44:49.7228 AlertProcessor ProcessorAlertData: Stopped 2025-12-27 18:49:44.2248 AlertProcessor ProcessorAlertData: started 2025-12-27 18:49:49.6623 AlertProcessor ProcessorAlertData: Stopped 2025-12-27 18:54:41.1644 DFramework.Database.Query /* Time Taken: 503*/ [dbo].GenerateSystemAlerts 2025-12-27 18:54:44.2426 AlertProcessor ProcessorAlertData: started 2025-12-27 18:54:49.8520 AlertProcessor ProcessorAlertData: Stopped 2025-12-27 18:54:56.2114 DFramework.Scheduler.TaskBase /* Time Taken: 15843.8602*/ Opportunity Out Of Stock By Outlet 2025-12-27 18:59:44.2604 AlertProcessor ProcessorAlertData: started 2025-12-27 18:59:49.8386 AlertProcessor ProcessorAlertData: Stopped 2025-12-27 19:04:44.2783 AlertProcessor ProcessorAlertData: started 2025-12-27 19:04:49.9033 AlertProcessor ProcessorAlertData: Stopped 2025-12-27 19:09:44.2961 AlertProcessor ProcessorAlertData: started 2025-12-27 19:09:49.9837 DFramework.Database.Query /* Time Taken: 550*/ DECLARE @TableName AnsiString(8000) SET @TableName = 'ProductStockLevel' DECLARE @CurrentRecordId Int32 SET @CurrentRecordId = '3675192' dbo.GetValidDeviceForAlertProcessData 2025-12-27 19:09:50.0305 AlertProcessor ProcessorAlertData: Stopped 2025-12-27 19:09:56.1868 DFramework.Scheduler.TaskBase /* Time Taken: 15796.9924*/ Opportunity Out Of Stock By Outlet 2025-12-27 19:14:44.3140 AlertProcessor ProcessorAlertData: started 2025-12-27 19:14:49.9078 AlertProcessor ProcessorAlertData: Stopped 2025-12-27 19:19:44.3316 AlertProcessor ProcessorAlertData: started 2025-12-27 19:19:49.9410 AlertProcessor ProcessorAlertData: Stopped 2025-12-27 19:24:44.3491 AlertProcessor ProcessorAlertData: started 2025-12-27 19:24:49.9429 AlertProcessor ProcessorAlertData: Stopped 2025-12-27 19:24:56.2242 DFramework.Scheduler.TaskBase /* Time Taken: 15812.5963*/ Opportunity Out Of Stock By Outlet 2025-12-27 19:29:44.3669 AlertProcessor ProcessorAlertData: started 2025-12-27 19:29:50.3982 AlertProcessor ProcessorAlertData: Stopped 2025-12-27 19:34:44.3691 AlertProcessor ProcessorAlertData: started 2025-12-27 19:34:50.0254 AlertProcessor ProcessorAlertData: Stopped 2025-12-27 19:39:44.3713 AlertProcessor ProcessorAlertData: started 2025-12-27 19:39:46.5119 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() 2025-12-27 19:39:50.1213 AlertProcessor ProcessorAlertData: Stopped 2025-12-27 19:39:56.2307 DFramework.Scheduler.TaskBase /* Time Taken: 15812.6187*/ Opportunity Out Of Stock By Outlet 2025-12-27 19:44:44.3891 AlertProcessor ProcessorAlertData: started 2025-12-27 19:44:49.9048 AlertProcessor ProcessorAlertData: Stopped 2025-12-27 19:49:44.4070 AlertProcessor ProcessorAlertData: started 2025-12-27 19:49:49.9383 AlertProcessor ProcessorAlertData: Stopped 2025-12-27 19:54:44.4246 AlertProcessor ProcessorAlertData: started 2025-12-27 19:54:50.0497 AlertProcessor ProcessorAlertData: Stopped 2025-12-27 19:54:56.2685 DFramework.Scheduler.TaskBase /* Time Taken: 15843.865*/ Opportunity Out Of Stock By Outlet 2025-12-27 19:59:44.4424 AlertProcessor ProcessorAlertData: started 2025-12-27 19:59:50.0206 AlertProcessor ProcessorAlertData: Stopped 2025-12-27 20:04:44.4602 AlertProcessor ProcessorAlertData: started 2025-12-27 20:04:50.0696 AlertProcessor ProcessorAlertData: Stopped 2025-12-27 20:09:41.2906 DFramework.Database.Query /* Time Taken: 535*/ [dbo].GenerateSystemAlerts 2025-12-27 20:09:44.4781 AlertProcessor ProcessorAlertData: started 2025-12-27 20:09:50.0719 AlertProcessor ProcessorAlertData: Stopped 2025-12-27 20:09:56.2594 DFramework.Scheduler.TaskBase /* Time Taken: 15828.2391*/ Opportunity Out Of Stock By Outlet 2025-12-27 20:14:44.4960 AlertProcessor ProcessorAlertData: started 2025-12-27 20:14:50.0741 AlertProcessor ProcessorAlertData: Stopped 2025-12-27 20:19:44.4982 AlertProcessor ProcessorAlertData: started 2025-12-27 20:19:50.0295 AlertProcessor ProcessorAlertData: Stopped 2025-12-27 20:24:44.5160 AlertProcessor ProcessorAlertData: started 2025-12-27 20:24:48.6411 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() 2025-12-27 20:24:50.2661 AlertProcessor ProcessorAlertData: Stopped 2025-12-27 20:24:56.1880 DFramework.Scheduler.TaskBase /* Time Taken: 15750.119*/ Opportunity Out Of Stock By Outlet 2025-12-27 20:29:44.5183 AlertProcessor ProcessorAlertData: started 2025-12-27 20:29:50.0965 AlertProcessor ProcessorAlertData: Stopped 2025-12-27 20:34:44.5205 AlertProcessor ProcessorAlertData: started 2025-12-27 20:34:48.3799 DFramework.Database.Query /* Time Taken: 3127*/ DECLARE @AlertTypeIds AnsiString(8000) SET @AlertTypeIds = '42,31,44,18,58,52,64,61,46,73,59,65,69,72,60,74,68,39,51,56,32,55,38,63,77,76' DECLARE @ClientIds AnsiString(8000) SET @ClientIds = '360,213,286,395,1494,70,291,452,335' 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 2025-12-27 20:34:50.3330 AlertProcessor ProcessorAlertData: Stopped 2025-12-27 20:34:52.2393 DFramework.Database.Query /* Time Taken: 3440*/ DECLARE @AlertTypeIds AnsiString(8000) SET @AlertTypeIds = '73,59,57,66,65,70,9,72,60,74,68,56,55,61,67,64,44,18,58,69,52,38,31,51,49,12,46,28,41,19,76' DECLARE @ClientIds AnsiString(8000) SET @ClientIds = '349,414,430,471,286,395,1494,213,360,70,207,224,291,306,308,325,342,295,320,336,338,134,188,227,337,385,421,469,1480,1496,114,180,183,299,300,314,316,331,332,333,415,451,296,301,303,305,328,335,229,221,355,1481,124,222,289,322,1476,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 2025-12-27 20:39:41.3821 DFramework.Database.Query /* Time Taken: 585*/ [dbo].GenerateSystemAlerts 2025-12-27 20:39:44.5227 AlertProcessor ProcessorAlertData: started 2025-12-27 20:39:50.1165 AlertProcessor ProcessorAlertData: Stopped 2025-12-27 20:39:56.2259 DFramework.Scheduler.TaskBase /* Time Taken: 15765.7435*/ Opportunity Out Of Stock By Outlet 2025-12-27 20:44:44.5249 AlertProcessor ProcessorAlertData: started 2025-12-27 20:44:50.0875 AlertProcessor ProcessorAlertData: Stopped 2025-12-27 20:49:44.5272 AlertProcessor ProcessorAlertData: started 2025-12-27 20:49:50.0585 AlertProcessor ProcessorAlertData: Stopped 2025-12-27 20:54:44.5450 AlertProcessor ProcessorAlertData: started 2025-12-27 20:54:50.1544 AlertProcessor ProcessorAlertData: Stopped 2025-12-27 20:54:56.2951 DFramework.Scheduler.TaskBase /* Time Taken: 15812.6163*/ Opportunity Out Of Stock By Outlet 2025-12-27 20:59:44.5472 AlertProcessor ProcessorAlertData: started 2025-12-27 20:59:50.0785 AlertProcessor ProcessorAlertData: Stopped 2025-12-27 21:04:44.5494 AlertProcessor ProcessorAlertData: started 2025-12-27 21:04:50.0651 AlertProcessor ProcessorAlertData: Stopped 2025-12-27 21:09:44.5673 AlertProcessor ProcessorAlertData: started 2025-12-27 21:09:50.2080 AlertProcessor ProcessorAlertData: Stopped 2025-12-27 21:09:56.2393 DFramework.Scheduler.TaskBase /* Time Taken: 15734.4942*/ Opportunity Out Of Stock By Outlet 2025-12-27 21:14:44.5851 AlertProcessor ProcessorAlertData: started 2025-12-27 21:14:50.2102 AlertProcessor ProcessorAlertData: Stopped 2025-12-27 21:19:44.5873 AlertProcessor ProcessorAlertData: started 2025-12-27 21:19:47.5874 DFramework.Database.Query /* Time Taken: 503*/ DECLARE @TableName AnsiString(8000) SET @TableName = 'AssetStockProductWiseConsolidate' DECLARE @CurrentRecordId Int32 SET @CurrentRecordId = '3675192' dbo.GetValidDeviceForAlertProcessData 2025-12-27 21:19:50.1811 AlertProcessor ProcessorAlertData: Stopped 2025-12-27 21:24:44.6052 AlertProcessor ProcessorAlertData: started 2025-12-27 21:24:50.0896 AlertProcessor ProcessorAlertData: Stopped 2025-12-27 21:24:56.3084 DFramework.Scheduler.TaskBase /* Time Taken: 15781.3676*/ Opportunity Out Of Stock By Outlet 2025-12-27 21:29:44.6074 AlertProcessor ProcessorAlertData: started 2025-12-27 21:29:50.2324 AlertProcessor ProcessorAlertData: Stopped 2025-12-27 21:34:44.6253 AlertProcessor ProcessorAlertData: started 2025-12-27 21:34:49.9066 AlertProcessor ProcessorAlertData: Stopped 2025-12-27 21:39:44.6277 AlertProcessor ProcessorAlertData: started 2025-12-27 21:39:50.2371 AlertProcessor ProcessorAlertData: Stopped 2025-12-27 21:39:56.2996 DFramework.Scheduler.TaskBase /* Time Taken: 15750.1212*/ Opportunity Out Of Stock By Outlet 2025-12-27 21:44:44.6455 AlertProcessor ProcessorAlertData: started 2025-12-27 21:44:46.2862 DFramework.Database.Query /* Time Taken: 504*/ DECLARE @TableName AnsiString(8000) SET @TableName = 'AdditionalShelf' DECLARE @CurrentRecordId Int32 SET @CurrentRecordId = '3675192' dbo.GetValidDeviceForAlertProcessData 2025-12-27 21:44:50.3018 AlertProcessor ProcessorAlertData: Stopped 2025-12-27 21:49:44.6478 AlertProcessor ProcessorAlertData: started 2025-12-27 21:49:47.0853 DFramework.Database.NullableDataReader Data reader open for 284 at System.Environment.GetStackTrace(Exception e, Boolean needFileInfo) at System.Environment.get_StackTrace() at DFramework.Database.NullableDataReader.Dispose(Boolean disposing) in 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() 2025-12-27 21:49:50.4916 AlertProcessor ProcessorAlertData: Stopped 2025-12-27 21:54:41.4467 DFramework.Database.Query /* Time Taken: 535*/ [dbo].GenerateSystemAlerts 2025-12-27 21:54:44.6499 AlertProcessor ProcessorAlertData: started 2025-12-27 21:54:50.3374 AlertProcessor ProcessorAlertData: Stopped 2025-12-27 21:54:56.3375 DFramework.Scheduler.TaskBase /* Time Taken: 15765.7371*/ Opportunity Out Of Stock By Outlet 2025-12-27 21:59:44.6521 AlertProcessor ProcessorAlertData: started 2025-12-27 21:59:50.3708 AlertProcessor ProcessorAlertData: Stopped 2025-12-27 22:04:44.6699 AlertProcessor ProcessorAlertData: started 2025-12-27 22:04:47.7949 DFramework.Database.Query /* Time Taken: 587*/ DECLARE @TableName AnsiString(8000) SET @TableName = 'AssetStockProductWiseConsolidate' DECLARE @CurrentRecordId Int32 SET @CurrentRecordId = '3675192' dbo.GetValidDeviceForAlertProcessData 2025-12-27 22:04:50.5137 AlertProcessor ProcessorAlertData: Stopped 2025-12-27 22:09:44.6721 AlertProcessor ProcessorAlertData: started 2025-12-27 22:09:50.3128 AlertProcessor ProcessorAlertData: Stopped 2025-12-27 22:09:56.3284 DFramework.Scheduler.TaskBase /* Time Taken: 15734.489*/ Opportunity Out Of Stock By Outlet 2025-12-27 22:14:44.6899 AlertProcessor ProcessorAlertData: started 2025-12-27 22:14:50.3306 AlertProcessor ProcessorAlertData: Stopped 2025-12-27 22:19:44.6922 AlertProcessor ProcessorAlertData: started 2025-12-27 22:19:50.4266 AlertProcessor ProcessorAlertData: Stopped 2025-12-27 22:24:41.7256 DFramework.Database.Query /* Time Taken: 775*/ [dbo].GenerateSystemAlerts 2025-12-27 22:24:44.6944 AlertProcessor ProcessorAlertData: started 2025-12-27 22:24:50.3351 AlertProcessor ProcessorAlertData: Stopped 2025-12-27 22:24:56.3663 DFramework.Scheduler.TaskBase /* Time Taken: 15750.1148*/ Opportunity Out Of Stock By Outlet 2025-12-27 22:29:44.7123 AlertProcessor ProcessorAlertData: started 2025-12-27 22:29:50.3373 AlertProcessor ProcessorAlertData: Stopped 2025-12-27 22:34:44.7301 AlertProcessor ProcessorAlertData: started 2025-12-27 22:34:49.5114 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() 2025-12-27 22:34:50.6208 AlertProcessor ProcessorAlertData: Stopped 2025-12-27 22:39:44.7324 AlertProcessor ProcessorAlertData: started 2025-12-27 22:39:50.4824 AlertProcessor ProcessorAlertData: Stopped 2025-12-27 22:39:56.4043 DFramework.Scheduler.TaskBase /* Time Taken: 15781.3675*/ Opportunity Out Of Stock By Outlet 2025-12-27 22:44:44.7502 AlertProcessor ProcessorAlertData: started 2025-12-27 22:44:50.4221 AlertProcessor ProcessorAlertData: Stopped 2025-12-27 22:49:44.7525 AlertProcessor ProcessorAlertData: started 2025-12-27 22:49:50.4244 AlertProcessor ProcessorAlertData: Stopped 2025-12-27 22:54:44.7703 AlertProcessor ProcessorAlertData: started 2025-12-27 22:54:47.9110 DFramework.Database.Query /* Time Taken: 537*/ DECLARE @TableName AnsiString(8000) SET @TableName = 'AssetStockProductWiseConsolidate' DECLARE @CurrentRecordId Int32 SET @CurrentRecordId = '3675192' dbo.GetValidDeviceForAlertProcessData 2025-12-27 22:54:50.5203 AlertProcessor ProcessorAlertData: Stopped 2025-12-27 22:54:56.3329 DFramework.Scheduler.TaskBase /* Time Taken: 15703.2392*/ Opportunity Out Of Stock By Outlet 2025-12-27 22:59:44.7725 AlertProcessor ProcessorAlertData: started 2025-12-27 22:59:50.4132 AlertProcessor ProcessorAlertData: Stopped 2025-12-27 23:04:44.7905 AlertProcessor ProcessorAlertData: started 2025-12-27 23:04:50.6655 AlertProcessor ProcessorAlertData: Stopped 2025-12-27 23:09:44.7927 AlertProcessor ProcessorAlertData: started 2025-12-27 23:09:50.4490 AlertProcessor ProcessorAlertData: Stopped 2025-12-27 23:09:56.3709 DFramework.Scheduler.TaskBase /* Time Taken: 15718.8686*/ Opportunity Out Of Stock By Outlet 2025-12-27 23:14:44.8106 AlertProcessor ProcessorAlertData: started 2025-12-27 23:14:50.5606 AlertProcessor ProcessorAlertData: Stopped 2025-12-27 23:19:44.8128 AlertProcessor ProcessorAlertData: started 2025-12-27 23:19:50.3128 AlertProcessor ProcessorAlertData: Stopped 2025-12-27 23:24:44.8150 AlertProcessor ProcessorAlertData: started 2025-12-27 23:24:50.3932 AlertProcessor ProcessorAlertData: Stopped 2025-12-27 23:24:56.3932 DFramework.Scheduler.TaskBase /* Time Taken: 15718.8712*/ Opportunity Out Of Stock By Outlet 2025-12-27 23:29:44.8328 AlertProcessor ProcessorAlertData: started 2025-12-27 23:29:50.4422 AlertProcessor ProcessorAlertData: Stopped 2025-12-27 23:34:44.8507 AlertProcessor ProcessorAlertData: started 2025-12-27 23:34:50.3664 AlertProcessor ProcessorAlertData: Stopped 2025-12-27 23:39:44.8530 AlertProcessor ProcessorAlertData: started 2025-12-27 23:39:50.3687 AlertProcessor ProcessorAlertData: Stopped 2025-12-27 23:39:56.4156 DFramework.Scheduler.TaskBase /* Time Taken: 15718.8695*/ Opportunity Out Of Stock By Outlet 2025-12-27 23:44:44.8552 AlertProcessor ProcessorAlertData: started 2025-12-27 23:44:50.3397 AlertProcessor ProcessorAlertData: Stopped 2025-12-27 23:49:44.8731 AlertProcessor ProcessorAlertData: started 2025-12-27 23:49:50.4357 AlertProcessor ProcessorAlertData: Stopped 2025-12-27 23:54:44.8910 AlertProcessor ProcessorAlertData: started 2025-12-27 23:54:50.4379 AlertProcessor ProcessorAlertData: Stopped 2025-12-27 23:54:56.4067 DFramework.Scheduler.TaskBase /* Time Taken: 15703.2396*/ Opportunity Out Of Stock By Outlet 2025-12-27 23:59:44.8932 AlertProcessor ProcessorAlertData: started 2025-12-27 23:59:50.3464 AlertProcessor ProcessorAlertData: Stopped