2025-12-31 00:04:17.2181 AlertProcessor ProcessorAlertData: started 2025-12-31 00:04:22.9369 AlertProcessor ProcessorAlertData: Stopped 2025-12-31 00:09:17.2355 AlertProcessor ProcessorAlertData: started 2025-12-31 00:09:23.0949 DFramework.Database.Query /* Time Taken: 521*/ DECLARE @TableName AnsiString(8000) SET @TableName = 'ProductStockLevel' DECLARE @CurrentRecordId Int32 SET @CurrentRecordId = '3675360' dbo.GetValidDeviceForAlertProcessData 2025-12-31 00:09:23.1574 AlertProcessor ProcessorAlertData: Stopped 2025-12-31 00:14:15.7373 DFramework.Database.Query /* Time Taken: 1146*/ [dbo].GenerateSystemAlerts 2025-12-31 00:14:17.2530 AlertProcessor ProcessorAlertData: started 2025-12-31 00:14:18.5498 DFramework.Database.Query /* Time Taken: 516*/ DECLARE @TableName AnsiString(8000) SET @TableName = 'MissingShelf' DECLARE @CurrentRecordId Int32 SET @CurrentRecordId = '3675360' dbo.GetValidDeviceForAlertProcessData 2025-12-31 00:14:22.9874 AlertProcessor ProcessorAlertData: Stopped 2025-12-31 00:14:30.6905 DFramework.Scheduler.TaskBase /* Time Taken: 16140.7329*/ Opportunity Out Of Stock By Outlet 2025-12-31 00:19:17.2705 AlertProcessor ProcessorAlertData: started 2025-12-31 00:19:18.6768 DFramework.Database.Query /* Time Taken: 523*/ DECLARE @TableName AnsiString(8000) SET @TableName = 'MissingShelf' DECLARE @CurrentRecordId Int32 SET @CurrentRecordId = '3675360' dbo.GetValidDeviceForAlertProcessData 2025-12-31 00:19:23.1143 AlertProcessor ProcessorAlertData: Stopped 2025-12-31 00:24:17.2880 AlertProcessor ProcessorAlertData: started 2025-12-31 00:24:22.8974 AlertProcessor ProcessorAlertData: Stopped 2025-12-31 00:29:15.2585 DFramework.Database.Query /* Time Taken: 645*/ [dbo].GenerateSystemAlerts 2025-12-31 00:29:17.3054 AlertProcessor ProcessorAlertData: started 2025-12-31 00:29:22.8992 AlertProcessor ProcessorAlertData: Stopped 2025-12-31 00:29:30.4773 DFramework.Scheduler.TaskBase /* Time Taken: 15906.359*/ Opportunity Out Of Stock By Outlet 2025-12-31 00:34:15.3854 MoveToReorder Running task for ClientId : 286 and ClientName = India Office QA and Slot: 12/31/2025 2:00:00 PM And LastExecutedOn: 12/31/2025 1:04:15 PM 2025-12-31 00:34:17.3229 AlertProcessor ProcessorAlertData: started 2025-12-31 00:34:23.1823 AlertProcessor ProcessorAlertData: Stopped 2025-12-31 00:34:56.1982 DFramework.Database.NullableDataReader Data reader open for 40538 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-31 00:34:56.2294 MoveToReorder Task executed successfully for ClientId : 286 Client Name:India Office QA, Slot: 12/31/2025 2:00:00 PM and Total Order Suggested: 125 Out Of: 125 2025-12-31 00:34:57.4326 DFramework.Scheduler.TaskBase /* Time Taken: 42469.0144*/ Move To Re-Order 2025-12-31 00:39:17.3405 AlertProcessor ProcessorAlertData: started 2025-12-31 00:39:23.2937 DFramework.Database.Query /* Time Taken: 527*/ DECLARE @TableName AnsiString(8000) SET @TableName = 'ProductStockLevel' DECLARE @CurrentRecordId Int32 SET @CurrentRecordId = '3675360' dbo.GetValidDeviceForAlertProcessData 2025-12-31 00:39:23.3405 AlertProcessor ProcessorAlertData: Stopped 2025-12-31 00:44:15.2796 DFramework.Database.Query /* Time Taken: 651*/ [dbo].GenerateSystemAlerts 2025-12-31 00:44:17.3577 AlertProcessor ProcessorAlertData: started 2025-12-31 00:44:18.5765 DFramework.Database.Query /* Time Taken: 524*/ DECLARE @TableName AnsiString(8000) SET @TableName = 'MissingShelf' DECLARE @CurrentRecordId Int32 SET @CurrentRecordId = '3675360' dbo.GetValidDeviceForAlertProcessData 2025-12-31 00:44:19.2015 DFramework.Database.Query /* Time Taken: 568*/ DECLARE @TableName AnsiString(8000) SET @TableName = 'AdditionalShelf' DECLARE @CurrentRecordId Int32 SET @CurrentRecordId = '3675360' dbo.GetValidDeviceForAlertProcessData 2025-12-31 00:44:23.3265 AlertProcessor ProcessorAlertData: Stopped 2025-12-31 00:44:30.7641 DFramework.Scheduler.TaskBase /* Time Taken: 16171.9693*/ Opportunity Out Of Stock By Outlet 2025-12-31 00:49:17.3752 AlertProcessor ProcessorAlertData: started 2025-12-31 00:49:23.0159 AlertProcessor ProcessorAlertData: Stopped 2025-12-31 00:54:17.3928 AlertProcessor ProcessorAlertData: started 2025-12-31 00:54:22.9865 AlertProcessor ProcessorAlertData: Stopped 2025-12-31 00:59:15.1758 DFramework.Database.Query /* Time Taken: 514*/ [dbo].GenerateSystemAlerts 2025-12-31 00:59:17.4102 AlertProcessor ProcessorAlertData: started 2025-12-31 00:59:23.0039 AlertProcessor ProcessorAlertData: Stopped 2025-12-31 00:59:30.5352 DFramework.Scheduler.TaskBase /* Time Taken: 15921.9619*/ Opportunity Out Of Stock By Outlet 2025-12-31 01:04:17.4119 AlertProcessor ProcessorAlertData: started 2025-12-31 01:04:22.9901 AlertProcessor ProcessorAlertData: Stopped 2025-12-31 01:09:17.4139 AlertProcessor ProcessorAlertData: started 2025-12-31 01:09:22.8670 AlertProcessor ProcessorAlertData: Stopped 2025-12-31 01:14:15.2439 DFramework.Database.Query /* Time Taken: 576*/ [dbo].GenerateSystemAlerts 2025-12-31 01:14:17.4158 AlertProcessor ProcessorAlertData: started 2025-12-31 01:14:23.0721 AlertProcessor ProcessorAlertData: Stopped 2025-12-31 01:14:30.4159 DFramework.Scheduler.TaskBase /* Time Taken: 15796.9447*/ Opportunity Out Of Stock By Outlet 2025-12-31 01:19:17.4330 AlertProcessor ProcessorAlertData: started 2025-12-31 01:19:23.1049 AlertProcessor ProcessorAlertData: Stopped 2025-12-31 01:24:17.4504 AlertProcessor ProcessorAlertData: started 2025-12-31 01:24:23.0286 AlertProcessor ProcessorAlertData: Stopped 2025-12-31 01:29:15.2024 DFramework.Database.Query /* Time Taken: 507*/ [dbo].GenerateSystemAlerts 2025-12-31 01:29:17.4680 AlertProcessor ProcessorAlertData: started 2025-12-31 01:29:22.8430 AlertProcessor ProcessorAlertData: Stopped 2025-12-31 01:29:30.4212 DFramework.Scheduler.TaskBase /* Time Taken: 15781.333*/ Opportunity Out Of Stock By Outlet 2025-12-31 01:34:15.4853 MoveToReorder Running task for ClientId : 286 and ClientName = India Office QA and Slot: 12/31/2025 3:00:00 PM And LastExecutedOn: 12/31/2025 2:04:15 PM 2025-12-31 01:34:16.0165 DFramework.Database.NullableDataReader Data reader open for 240 at System.Environment.GetStackTrace(Exception e, Boolean needFileInfo) at System.Environment.get_StackTrace() at DFramework.Database.NullableDataReader.Dispose(Boolean disposing) in D:\Spraxa\Framework\DFramework\Database\NullableDataReader.cs:line 33 at DFramework.Database.NullableDataReader.Dispose() in D:\Spraxa\Framework\DFramework\Database\NullableDataReader.cs:line 44 at CoolR.Tasks.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-31 01:34:16.0634 MoveToReorder Task executed successfully for ClientId : 286 Client Name:India Office QA, Slot: 12/31/2025 3:00:00 PM and Total Order Suggested: 1 Out Of: 1 2025-12-31 01:34:17.4696 AlertProcessor ProcessorAlertData: started 2025-12-31 01:34:23.1728 AlertProcessor ProcessorAlertData: Stopped 2025-12-31 01:39:17.4870 AlertProcessor ProcessorAlertData: started 2025-12-31 01:39:23.1433 AlertProcessor ProcessorAlertData: Stopped 2025-12-31 01:44:15.2233 DFramework.Database.Query /* Time Taken: 513*/ [dbo].GenerateSystemAlerts 2025-12-31 01:44:17.5046 AlertProcessor ProcessorAlertData: started 2025-12-31 01:44:22.6296 AlertProcessor ProcessorAlertData: Stopped 2025-12-31 01:44:30.4422 DFramework.Scheduler.TaskBase /* Time Taken: 15781.3592*/ Opportunity Out Of Stock By Outlet 2025-12-31 01:49:17.5221 AlertProcessor ProcessorAlertData: started 2025-12-31 01:49:22.7096 AlertProcessor ProcessorAlertData: Stopped 2025-12-31 01:54:17.5394 AlertProcessor ProcessorAlertData: started 2025-12-31 01:54:23.0238 AlertProcessor ProcessorAlertData: Stopped 2025-12-31 01:59:15.2600 DFramework.Database.Query /* Time Taken: 523*/ [dbo].GenerateSystemAlerts 2025-12-31 01:59:17.5569 AlertProcessor ProcessorAlertData: started 2025-12-31 01:59:22.9007 AlertProcessor ProcessorAlertData: Stopped 2025-12-31 01:59:30.4476 DFramework.Scheduler.TaskBase /* Time Taken: 15765.7258*/ Opportunity Out Of Stock By Outlet 2025-12-31 02:04:17.5744 AlertProcessor ProcessorAlertData: started 2025-12-31 02:04:23.4182 AlertProcessor ProcessorAlertData: Stopped 2025-12-31 02:09:17.5907 AlertProcessor ProcessorAlertData: started 2025-12-31 02:09:19.7626 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-31 02:09:23.4970 AlertProcessor ProcessorAlertData: Stopped 2025-12-31 02:14:15.2796 DFramework.Database.Query /* Time Taken: 525*/ [dbo].GenerateSystemAlerts 2025-12-31 02:14:15.3733 DFramework.Database.Query /* Time Taken: 562*/ DECLARE @ClientId Int32 SET @ClientId = '213' DECLARE @MarketId Int32 SET @MarketId = '0' DECLARE @ClassificationId Int32 SET @ClassificationId = '0' DECLARE @LocationId Int32 SET @LocationId = '0' DECLARE @LocationTypeId Int32 SET @LocationTypeId = '0' DECLARE @StartDate DateTime2 SET @StartDate = '8/28/2025 12:00:00 AM' dbo.GetOpportunityOutOfStockDataByOutlet 2025-12-31 02:14:17.6077 AlertProcessor ProcessorAlertData: started 2025-12-31 02:14:20.6546 DFramework.Database.Query /* Time Taken: 522*/ DECLARE @TableName AnsiString(8000) SET @TableName = 'AssetStockProductWiseConsolidate' DECLARE @CurrentRecordId Int32 SET @CurrentRecordId = '3675360' dbo.GetValidDeviceForAlertProcessData 2025-12-31 02:14:23.3109 AlertProcessor ProcessorAlertData: Stopped 2025-12-31 02:14:30.9672 DFramework.Scheduler.TaskBase /* Time Taken: 16265.7263*/ Opportunity Out Of Stock By Outlet 2025-12-31 02:19:17.6095 AlertProcessor ProcessorAlertData: started 2025-12-31 02:19:23.1564 AlertProcessor ProcessorAlertData: Stopped 2025-12-31 02:24:17.6172 AlertProcessor ProcessorAlertData: started 2025-12-31 02:24:23.3516 AlertProcessor ProcessorAlertData: Stopped 2025-12-31 02:29:15.6072 DFramework.Database.Query /* Time Taken: 839*/ [dbo].GenerateSystemAlerts 2025-12-31 02:29:17.6228 AlertProcessor ProcessorAlertData: started 2025-12-31 02:29:23.5604 AlertProcessor ProcessorAlertData: Stopped 2025-12-31 02:29:30.7167 DFramework.Scheduler.TaskBase /* Time Taken: 16000.1162*/ Opportunity Out Of Stock By Outlet 2025-12-31 02:34:15.5155 MoveToReorder Running task for ClientId : 286 and ClientName = India Office QA and Slot: 12/31/2025 4:00:00 PM And LastExecutedOn: 12/31/2025 3:04:15 PM 2025-12-31 02:34:15.9843 MoveToReorder Task executed successfully for ClientId : 286 Client Name:India Office QA, Slot: 12/31/2025 4:00:00 PM and Total Order Suggested: 1 Out Of: 1 2025-12-31 02:34:17.6405 AlertProcessor ProcessorAlertData: started 2025-12-31 02:34:20.8593 DFramework.Database.Query /* Time Taken: 562*/ DECLARE @TableName AnsiString(8000) SET @TableName = 'AssetStockProductWiseConsolidate' DECLARE @CurrentRecordId Int32 SET @CurrentRecordId = '3675360' dbo.GetValidDeviceForAlertProcessData 2025-12-31 02:34:23.5781 AlertProcessor ProcessorAlertData: Stopped 2025-12-31 02:39:17.6581 AlertProcessor ProcessorAlertData: started 2025-12-31 02:39:20.8613 DFramework.Database.Query /* Time Taken: 611*/ DECLARE @TableName AnsiString(8000) SET @TableName = 'AssetStockProductWiseConsolidate' DECLARE @CurrentRecordId Int32 SET @CurrentRecordId = '3675360' dbo.GetValidDeviceForAlertProcessData 2025-12-31 02:39:22.0644 DFramework.Database.Query /* Time Taken: 541*/ DECLARE @TableName AnsiString(8000) SET @TableName = 'AssetPurity' DECLARE @CurrentRecordId Int32 SET @CurrentRecordId = '3675360' dbo.GetValidDeviceForAlertProcessData 2025-12-31 02:39:23.7519 AlertProcessor ProcessorAlertData: Stopped 2025-12-31 02:44:15.5348 DFramework.Database.Query /* Time Taken: 742*/ [dbo].GenerateSystemAlerts 2025-12-31 02:44:17.6754 AlertProcessor ProcessorAlertData: started 2025-12-31 02:44:18.2535 DFramework.Database.Query /* Time Taken: 583*/ DECLARE @TableName AnsiString(8000) SET @TableName = 'TagAlert' DECLARE @CurrentRecordId Int32 SET @CurrentRecordId = '0' dbo.GetValidDeviceForAlertProcessData 2025-12-31 02:44:19.1285 DFramework.Database.NullableDataReader Data reader open for 395 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-31 02:44:19.1910 DFramework.Database.NullableDataReader Data reader open for 479 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-31 02:44:20.8004 DFramework.Database.NullableDataReader Data reader open for 222 at System.Environment.GetStackTrace(Exception e, Boolean needFileInfo) at System.Environment.get_StackTrace() at DFramework.Database.NullableDataReader.Dispose(Boolean disposing) in D:\Spraxa\Framework\DFramework\Database\NullableDataReader.cs:line 33 at DFramework.Database.NullableDataReader.Dispose() in D:\Spraxa\Framework\DFramework\Database\NullableDataReader.cs:line 44 at CoolR.Tasks.ProcessAlertData.Execute() in D:\Spraxa\CoolR-Group\portal\CoolR.Tasks\ProcessAlertData.cs:line 47 at DFramework.Scheduler.TaskBase.Run() in D:\Spraxa\Framework\DFramework.Scheduler\TaskBase.cs:line 176 at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx) at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx) at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state) at System.Threading.ThreadHelper.ThreadStart() 2025-12-31 02:44:20.8473 DFramework.Database.NullableDataReader Data reader open for 306 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-31 02:44:21.4879 DFramework.Database.NullableDataReader Data reader open for 353 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-31 02:44:21.5348 DFramework.Database.NullableDataReader Data reader open for 437 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-31 02:44:22.0973 DFramework.Database.NullableDataReader Data reader open for 304 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-31 02:44:22.1598 DFramework.Database.NullableDataReader Data reader open for 387 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-31 02:44:23.4254 DFramework.Database.NullableDataReader Data reader open for 239 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-31 02:44:23.4879 DFramework.Database.NullableDataReader Data reader open for 322 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-31 02:44:23.8005 AlertProcessor Replace Tags updated for the Image Id: 3675362 2025-12-31 02:44:24.4411 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.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-31 02:44:24.5036 DFramework.Database.NullableDataReader Data reader open for 335 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-31 02:44:25.3473 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-31 02:44:26.2067 DFramework.Database.NullableDataReader Data reader open for 220 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-31 02:44:26.2536 DFramework.Database.NullableDataReader Data reader open for 303 at System.Environment.GetStackTrace(Exception e, Boolean needFileInfo) at System.Environment.get_StackTrace() at DFramework.Database.NullableDataReader.Dispose(Boolean disposing) in D:\Spraxa\Framework\DFramework\Database\NullableDataReader.cs:line 33 at DFramework.Database.NullableDataReader.Dispose() in D:\Spraxa\Framework\DFramework\Database\NullableDataReader.cs:line 44 at CoolR.Tasks.ProcessAlertData.Execute() in D:\Spraxa\CoolR-Group\portal\CoolR.Tasks\ProcessAlertData.cs:line 47 at DFramework.Scheduler.TaskBase.Run() in D:\Spraxa\Framework\DFramework.Scheduler\TaskBase.cs:line 176 at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx) at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx) at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state) at System.Threading.ThreadHelper.ThreadStart() 2025-12-31 02:44:26.8786 AlertProcessor ProcessorAlertData: Stopped 2025-12-31 02:44:30.8005 DFramework.Scheduler.TaskBase /* Time Taken: 16062.5889*/ Opportunity Out Of Stock By Outlet 2025-12-31 02:49:17.6929 AlertProcessor ProcessorAlertData: started 2025-12-31 02:49:19.0679 DFramework.Database.Query /* Time Taken: 690*/ DECLARE @TableName AnsiString(8000) SET @TableName = 'MissingShelf' DECLARE @CurrentRecordId Int32 SET @CurrentRecordId = '3675362' dbo.GetValidDeviceForAlertProcessData 2025-12-31 02:49:23.3179 AlertProcessor ProcessorAlertData: Stopped 2025-12-31 02:54:17.6948 AlertProcessor ProcessorAlertData: started 2025-12-31 02:54:22.8042 AlertProcessor ProcessorAlertData: Stopped 2025-12-31 02:59:15.5559 DFramework.Database.Query /* Time Taken: 745*/ [dbo].GenerateSystemAlerts 2025-12-31 02:59:17.7121 AlertProcessor ProcessorAlertData: started 2025-12-31 02:59:22.8528 AlertProcessor ProcessorAlertData: Stopped 2025-12-31 02:59:30.8685 DFramework.Scheduler.TaskBase /* Time Taken: 16109.453*/ Opportunity Out Of Stock By Outlet 2025-12-31 03:04:17.7295 AlertProcessor ProcessorAlertData: started 2025-12-31 03:04:18.2451 DFramework.Database.Query /* Time Taken: 524*/ DECLARE @TableName AnsiString(8000) SET @TableName = 'TagAlert' DECLARE @CurrentRecordId Int32 SET @CurrentRecordId = '0' dbo.GetValidDeviceForAlertProcessData 2025-12-31 03:04:23.2295 AlertProcessor ProcessorAlertData: Stopped 2025-12-31 03:09:17.7470 AlertProcessor ProcessorAlertData: started 2025-12-31 03:09:23.0596 AlertProcessor ProcessorAlertData: Stopped 2025-12-31 03:14:15.6083 DFramework.Database.Query /* Time Taken: 785*/ [dbo].GenerateSystemAlerts 2025-12-31 03:14:17.7645 AlertProcessor ProcessorAlertData: started 2025-12-31 03:14:22.9833 AlertProcessor ProcessorAlertData: Stopped 2025-12-31 03:14:30.8271 DFramework.Scheduler.TaskBase /* Time Taken: 16046.9669*/ Opportunity Out Of Stock By Outlet 2025-12-31 03:19:17.7818 AlertProcessor ProcessorAlertData: started 2025-12-31 03:19:23.2506 AlertProcessor ProcessorAlertData: Stopped 2025-12-31 03:24:17.7993 AlertProcessor ProcessorAlertData: started 2025-12-31 03:24:22.9556 AlertProcessor ProcessorAlertData: Stopped 2025-12-31 03:29:15.5044 DFramework.Database.Query /* Time Taken: 670*/ [dbo].GenerateSystemAlerts 2025-12-31 03:29:16.7231 DFramework.Database.Query /* Time Taken: 1814*/ DECLARE @ClientId Int32 SET @ClientId = '213' DECLARE @MarketId Int32 SET @MarketId = '0' DECLARE @ClassificationId Int32 SET @ClassificationId = '0' DECLARE @LocationId Int32 SET @LocationId = '0' DECLARE @LocationTypeId Int32 SET @LocationTypeId = '0' DECLARE @StartDate DateTime2 SET @StartDate = '8/28/2025 12:00:00 AM' dbo.GetOpportunityOutOfStockDataByOutlet 2025-12-31 03:29:17.8169 AlertProcessor ProcessorAlertData: started 2025-12-31 03:29:21.0513 DFramework.Database.Query /* Time Taken: 521*/ DECLARE @TableName AnsiString(8000) SET @TableName = 'AssetStockProductWiseConsolidate' DECLARE @CurrentRecordId Int32 SET @CurrentRecordId = '3675362' dbo.GetValidDeviceForAlertProcessData 2025-12-31 03:29:23.8951 AlertProcessor ProcessorAlertData: Stopped 2025-12-31 03:29:32.2545 DFramework.Scheduler.TaskBase /* Time Taken: 17453.2388*/ Opportunity Out Of Stock By Outlet 2025-12-31 03:34:15.7091 MoveToReorder Running task for ClientId : 286 and ClientName = India Office QA and Slot: 12/31/2025 5:00:00 PM And LastExecutedOn: 12/31/2025 4:04:15 PM 2025-12-31 03:34:17.8341 AlertProcessor ProcessorAlertData: started 2025-12-31 03:34:23.3185 AlertProcessor ProcessorAlertData: Stopped 2025-12-31 03:34:54.7093 DFramework.Database.NullableDataReader Data reader open for 38744 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-31 03:34:54.7406 MoveToReorder Task executed successfully for ClientId : 286 Client Name:India Office QA, Slot: 12/31/2025 5:00:00 PM and Total Order Suggested: 125 Out Of: 125 2025-12-31 03:34:55.8499 DFramework.Scheduler.TaskBase /* Time Taken: 40562.7258*/ Move To Re-Order 2025-12-31 03:39:17.8359 AlertProcessor ProcessorAlertData: started 2025-12-31 03:39:22.9453 AlertProcessor ProcessorAlertData: Stopped 2025-12-31 03:44:15.6034 DFramework.Database.Query /* Time Taken: 744*/ [dbo].GenerateSystemAlerts 2025-12-31 03:44:17.8534 AlertProcessor ProcessorAlertData: started 2025-12-31 03:44:23.2909 AlertProcessor ProcessorAlertData: Stopped 2025-12-31 03:44:30.9316 DFramework.Scheduler.TaskBase /* Time Taken: 16125.1105*/ Opportunity Out Of Stock By Outlet 2025-12-31 03:49:17.8708 AlertProcessor ProcessorAlertData: started 2025-12-31 03:49:18.3864 DFramework.Database.Query /* Time Taken: 515*/ DECLARE @TableName AnsiString(8000) SET @TableName = 'TagAlert' DECLARE @CurrentRecordId Int32 SET @CurrentRecordId = '0' dbo.GetValidDeviceForAlertProcessData 2025-12-31 03:49:23.2146 AlertProcessor ProcessorAlertData: Stopped 2025-12-31 03:54:17.8882 AlertProcessor ProcessorAlertData: started 2025-12-31 03:54:23.0913 AlertProcessor ProcessorAlertData: Stopped 2025-12-31 03:59:15.4334 DFramework.Database.Query /* Time Taken: 509*/ DECLARE @ClientId Int32 SET @ClientId = '213' DECLARE @MarketId Int32 SET @MarketId = '0' DECLARE @ClassificationId Int32 SET @ClassificationId = '0' DECLARE @LocationId Int32 SET @LocationId = '0' DECLARE @LocationTypeId Int32 SET @LocationTypeId = '0' DECLARE @StartDate DateTime2 SET @StartDate = '8/28/2025 12:00:00 AM' dbo.GetOpportunityOutOfStockDataByOutlet 2025-12-31 03:59:15.9803 DFramework.Database.Query /* Time Taken: 1094*/ [dbo].GenerateSystemAlerts 2025-12-31 03:59:17.9022 AlertProcessor ProcessorAlertData: started 2025-12-31 03:59:23.2616 AlertProcessor ProcessorAlertData: Stopped 2025-12-31 03:59:31.1210 DFramework.Scheduler.TaskBase /* Time Taken: 16296.9784*/ Opportunity Out Of Stock By Outlet 2025-12-31 04:04:17.9061 AlertProcessor ProcessorAlertData: started 2025-12-31 04:04:23.2030 AlertProcessor ProcessorAlertData: Stopped 2025-12-31 04:09:17.9235 AlertProcessor ProcessorAlertData: started 2025-12-31 04:09:23.0797 AlertProcessor ProcessorAlertData: Stopped 2025-12-31 04:14:15.6314 DFramework.Database.Query /* Time Taken: 746*/ [dbo].GenerateSystemAlerts 2025-12-31 04:14:17.9283 AlertProcessor ProcessorAlertData: started 2025-12-31 04:14:23.0846 AlertProcessor ProcessorAlertData: Stopped 2025-12-31 04:14:30.9440 DFramework.Scheduler.TaskBase /* Time Taken: 16109.4801*/ Opportunity Out Of Stock By Outlet 2025-12-31 04:19:17.9459 AlertProcessor ProcessorAlertData: started 2025-12-31 04:19:22.9928 AlertProcessor ProcessorAlertData: Stopped 2025-12-31 04:24:17.9631 AlertProcessor ProcessorAlertData: started 2025-12-31 04:24:22.9945 AlertProcessor ProcessorAlertData: Stopped 2025-12-31 04:29:15.4492 DFramework.Database.Query /* Time Taken: 543*/ [dbo].GenerateSystemAlerts 2025-12-31 04:29:17.9805 AlertProcessor ProcessorAlertData: started 2025-12-31 04:29:20.9024 DFramework.Database.Query /* Time Taken: 556*/ DECLARE @TableName AnsiString(8000) SET @TableName = 'AssetStockProductWiseConsolidate' DECLARE @CurrentRecordId Int32 SET @CurrentRecordId = '3675362' dbo.GetValidDeviceForAlertProcessData 2025-12-31 04:29:23.3399 AlertProcessor ProcessorAlertData: Stopped 2025-12-31 04:29:30.9337 DFramework.Scheduler.TaskBase /* Time Taken: 16078.2188*/ Opportunity Out Of Stock By Outlet 2025-12-31 04:34:15.7480 MoveToReorder Running task for ClientId : 286 and ClientName = India Office QA and Slot: 12/31/2025 6:00:00 PM And LastExecutedOn: 12/31/2025 5:04:15 PM 2025-12-31 04:34:17.2949 DFramework.Database.NullableDataReader Data reader open for 1212 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-31 04:34:17.3261 MoveToReorder Task executed successfully for ClientId : 286 Client Name:India Office QA, Slot: 12/31/2025 6:00:00 PM and Total Order Suggested: 3 Out Of: 3 2025-12-31 04:34:17.9980 AlertProcessor ProcessorAlertData: started 2025-12-31 04:34:23.2637 AlertProcessor ProcessorAlertData: Stopped 2025-12-31 04:39:18.0155 AlertProcessor ProcessorAlertData: started 2025-12-31 04:39:23.0780 AlertProcessor ProcessorAlertData: Stopped 2025-12-31 04:44:15.4234 DFramework.Database.Query /* Time Taken: 503*/ [dbo].GenerateSystemAlerts 2025-12-31 04:44:18.0327 AlertProcessor ProcessorAlertData: started 2025-12-31 04:44:23.3765 AlertProcessor ProcessorAlertData: Stopped 2025-12-31 04:44:30.6891 DFramework.Scheduler.TaskBase /* Time Taken: 15812.6577*/ Opportunity Out Of Stock By Outlet 2025-12-31 04:49:18.0377 AlertProcessor ProcessorAlertData: started 2025-12-31 04:49:23.2252 AlertProcessor ProcessorAlertData: Stopped 2025-12-31 04:54:18.0552 AlertProcessor ProcessorAlertData: started 2025-12-31 04:54:23.2272 AlertProcessor ProcessorAlertData: Stopped 2025-12-31 04:59:18.0726 AlertProcessor ProcessorAlertData: started 2025-12-31 04:59:23.1195 AlertProcessor ProcessorAlertData: Stopped 2025-12-31 04:59:30.6976 DFramework.Scheduler.TaskBase /* Time Taken: 15812.5984*/ Opportunity Out Of Stock By Outlet 2025-12-31 05:04:18.0889 AlertProcessor ProcessorAlertData: started 2025-12-31 05:04:23.2764 AlertProcessor ProcessorAlertData: Stopped 2025-12-31 05:09:18.1064 AlertProcessor ProcessorAlertData: started 2025-12-31 05:09:23.4502 AlertProcessor ProcessorAlertData: Stopped 2025-12-31 05:14:15.5614 DFramework.Database.Query /* Time Taken: 622*/ [dbo].GenerateSystemAlerts 2025-12-31 05:14:18.1239 AlertProcessor ProcessorAlertData: started 2025-12-31 05:14:20.5926 DFramework.Database.NullableDataReader Data reader open for 289 at System.Environment.GetStackTrace(Exception e, Boolean needFileInfo) at System.Environment.get_StackTrace() at DFramework.Database.NullableDataReader.Dispose(Boolean disposing) in D:\Spraxa\Framework\DFramework\Database\NullableDataReader.cs:line 33 at DFramework.Database.NullableDataReader.Dispose() in D:\Spraxa\Framework\DFramework\Database\NullableDataReader.cs:line 44 at CoolR.Tasks.ProcessAlertData.Execute() in D:\Spraxa\CoolR-Group\portal\CoolR.Tasks\ProcessAlertData.cs:line 47 at DFramework.Scheduler.TaskBase.Run() in D:\Spraxa\Framework\DFramework.Scheduler\TaskBase.cs:line 176 at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx) at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx) at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state) at System.Threading.ThreadHelper.ThreadStart() 2025-12-31 05:14:24.4520 AlertProcessor ProcessorAlertData: Stopped 2025-12-31 05:14:30.9052 DFramework.Scheduler.TaskBase /* Time Taken: 16000.0936*/ Opportunity Out Of Stock By Outlet 2025-12-31 05:19:18.1413 AlertProcessor ProcessorAlertData: started 2025-12-31 05:19:19.3288 DFramework.Database.Query /* Time Taken: 547*/ DECLARE @TableName AnsiString(8000) SET @TableName = 'MissingShelf' DECLARE @CurrentRecordId Int32 SET @CurrentRecordId = '3675362' dbo.GetValidDeviceForAlertProcessData 2025-12-31 05:19:23.4070 AlertProcessor ProcessorAlertData: Stopped 2025-12-31 05:24:18.1452 AlertProcessor ProcessorAlertData: started 2025-12-31 05:24:22.1452 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-31 05:24:23.6609 AlertProcessor ProcessorAlertData: Stopped 2025-12-31 05:28:54.7479 DFramework.Database.Query /* Time Taken: 7161*/ 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-31 05:28:54.7479 DFramework.Database.Query /* Time Taken: 7163*/ 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-31 05:28:54.7479 DFramework.Database.Query /* Time Taken: 7163*/ 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-31 05:28:54.7479 DFramework.Database.Query /* Time Taken: 7163*/ 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-31 05:28:54.7479 DFramework.Database.Query /* Time Taken: 7164*/ DECLARE @IsFileProcessed Int32 SET @IsFileProcessed = '0' DECLARE @TaskNumber Int32 SET @TaskNumber = '2' DECLARE @IsDeleted Int32 SET @IsDeleted = '0' SELECT TOP 1000 IncomingFileId, GatewayId,GatewayMac,RawFileName,AzureContainerName,StartIndex,Tries, CreatedOn FROM IncomingFile WHERE [IsFileProcessed] = @IsFileProcessed AND [TaskNumber] = @TaskNumber AND [IsDeleted] = @IsDeleted 2025-12-31 05:29:16.1387 DFramework.Database.Query /* Time Taken: 752*/ DECLARE @ClientId Int32 SET @ClientId = '213' DECLARE @MarketId Int32 SET @MarketId = '0' DECLARE @ClassificationId Int32 SET @ClassificationId = '0' DECLARE @LocationId Int32 SET @LocationId = '0' DECLARE @LocationTypeId Int32 SET @LocationTypeId = '0' DECLARE @StartDate DateTime2 SET @StartDate = '8/28/2025 12:00:00 AM' dbo.GetOpportunityOutOfStockDataByOutlet 2025-12-31 05:29:16.9355 DFramework.Database.Query /* Time Taken: 1971*/ [dbo].GenerateSystemAlerts 2025-12-31 05:29:18.1543 AlertProcessor ProcessorAlertData: started 2025-12-31 05:29:19.5293 DFramework.Database.Query /* Time Taken: 646*/ DECLARE @TableName AnsiString(8000) SET @TableName = 'MissingShelf' DECLARE @CurrentRecordId Int32 SET @CurrentRecordId = '3675362' dbo.GetValidDeviceForAlertProcessData 2025-12-31 05:29:23.5293 AlertProcessor ProcessorAlertData: Stopped 2025-12-31 05:29:31.6856 DFramework.Scheduler.TaskBase /* Time Taken: 16765.7312*/ Opportunity Out Of Stock By Outlet 2025-12-31 05:34:15.9528 MoveToReorder Running task for ClientId : 286 and ClientName = India Office QA and Slot: 12/31/2025 7:00:00 PM And LastExecutedOn: 12/31/2025 6:04:15 PM 2025-12-31 05:34:16.2028 MoveToReorder Task executed successfully for ClientId : 286 Client Name:India Office QA, Slot: 12/31/2025 7:00:00 PM But No Order found to suggest 2025-12-31 05:34:18.1716 AlertProcessor ProcessorAlertData: started 2025-12-31 05:34:23.5310 AlertProcessor ProcessorAlertData: Stopped 2025-12-31 05:39:18.1734 AlertProcessor ProcessorAlertData: started 2025-12-31 05:39:23.2828 AlertProcessor ProcessorAlertData: Stopped 2025-12-31 05:44:18.1753 AlertProcessor ProcessorAlertData: started 2025-12-31 05:44:23.3316 AlertProcessor ProcessorAlertData: Stopped 2025-12-31 05:44:30.7222 DFramework.Scheduler.TaskBase /* Time Taken: 15781.3557*/ Opportunity Out Of Stock By Outlet 2025-12-31 05:49:18.1927 AlertProcessor ProcessorAlertData: started 2025-12-31 05:49:23.8333 AlertProcessor ProcessorAlertData: Stopped 2025-12-31 05:54:18.1945 AlertProcessor ProcessorAlertData: started 2025-12-31 05:54:23.2726 AlertProcessor ProcessorAlertData: Stopped 2025-12-31 05:59:16.1495 DFramework.Database.Query /* Time Taken: 1144*/ [dbo].GenerateSystemAlerts 2025-12-31 05:59:18.2120 AlertProcessor ProcessorAlertData: started 2025-12-31 05:59:19.6964 DFramework.Database.Query /* Time Taken: 554*/ DECLARE @TableName AnsiString(8000) SET @TableName = 'MissingShelf' DECLARE @CurrentRecordId Int32 SET @CurrentRecordId = '3675362' dbo.GetValidDeviceForAlertProcessData 2025-12-31 05:59:20.3057 DFramework.Database.Query /* Time Taken: 560*/ DECLARE @TableName AnsiString(8000) SET @TableName = 'AdditionalShelf' DECLARE @CurrentRecordId Int32 SET @CurrentRecordId = '3675362' dbo.GetValidDeviceForAlertProcessData 2025-12-31 05:59:22.5245 DFramework.Database.Query /* Time Taken: 815*/ DECLARE @TableName AnsiString(8000) SET @TableName = 'AssetStockProductWiseConsolidate' DECLARE @CurrentRecordId Int32 SET @CurrentRecordId = '3675362' dbo.GetValidDeviceForAlertProcessData 2025-12-31 05:59:26.5558 DFramework.Database.Query /* Time Taken: 760*/ DECLARE @TableName AnsiString(8000) SET @TableName = 'ProductStockLevel' DECLARE @CurrentRecordId Int32 SET @CurrentRecordId = '3675362' dbo.GetValidDeviceForAlertProcessData 2025-12-31 05:59:26.6183 AlertProcessor ProcessorAlertData: Stopped 2025-12-31 05:59:30.9308 DFramework.Scheduler.TaskBase /* Time Taken: 15968.8494*/ Opportunity Out Of Stock By Outlet 2025-12-31 06:04:18.2295 AlertProcessor ProcessorAlertData: started 2025-12-31 06:04:23.3545 AlertProcessor ProcessorAlertData: Stopped 2025-12-31 06:09:18.2469 AlertProcessor ProcessorAlertData: started 2025-12-31 06:09:23.3407 AlertProcessor ProcessorAlertData: Stopped 2025-12-31 06:14:15.7176 DFramework.Database.Query /* Time Taken: 627*/ DECLARE @ClientId Int32 SET @ClientId = '213' DECLARE @MarketId Int32 SET @MarketId = '0' DECLARE @ClassificationId Int32 SET @ClassificationId = '0' DECLARE @LocationId Int32 SET @LocationId = '0' DECLARE @LocationTypeId Int32 SET @LocationTypeId = '0' DECLARE @StartDate DateTime2 SET @StartDate = '8/28/2025 12:00:00 AM' dbo.GetOpportunityOutOfStockDataByOutlet 2025-12-31 06:14:18.2644 AlertProcessor ProcessorAlertData: started 2025-12-31 06:14:23.4051 AlertProcessor ProcessorAlertData: Stopped 2025-12-31 06:14:31.3114 DFramework.Scheduler.TaskBase /* Time Taken: 16328.2286*/ Opportunity Out Of Stock By Outlet 2025-12-31 06:19:18.2820 AlertProcessor ProcessorAlertData: started 2025-12-31 06:19:23.4851 AlertProcessor ProcessorAlertData: Stopped 2025-12-31 06:24:18.2993 AlertProcessor ProcessorAlertData: started 2025-12-31 06:24:19.4243 DFramework.Database.NullableDataReader Data reader open for 365 at System.Environment.GetStackTrace(Exception e, Boolean needFileInfo) at System.Environment.get_StackTrace() at DFramework.Database.NullableDataReader.Dispose(Boolean disposing) in D:\Spraxa\Framework\DFramework\Database\NullableDataReader.cs:line 33 at DFramework.Database.NullableDataReader.Dispose() in D:\Spraxa\Framework\DFramework\Database\NullableDataReader.cs:line 44 at CoolR.Tasks.ProcessAlertData.Execute() in D:\Spraxa\CoolR-Group\portal\CoolR.Tasks\ProcessAlertData.cs:line 47 at DFramework.Scheduler.TaskBase.Run() in D:\Spraxa\Framework\DFramework.Scheduler\TaskBase.cs:line 176 at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx) at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx) at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state) at System.Threading.ThreadHelper.ThreadStart() 2025-12-31 06:24:19.4868 DFramework.Database.NullableDataReader Data reader open for 450 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-31 06:24:21.0024 DFramework.Database.NullableDataReader Data reader open for 220 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-31 06:24:21.0649 DFramework.Database.NullableDataReader Data reader open for 303 at System.Environment.GetStackTrace(Exception e, Boolean needFileInfo) at System.Environment.get_StackTrace() at DFramework.Database.NullableDataReader.Dispose(Boolean disposing) in D:\Spraxa\Framework\DFramework\Database\NullableDataReader.cs:line 33 at DFramework.Database.NullableDataReader.Dispose() in D:\Spraxa\Framework\DFramework\Database\NullableDataReader.cs:line 44 at CoolR.Tasks.ProcessAlertData.Execute() in D:\Spraxa\CoolR-Group\portal\CoolR.Tasks\ProcessAlertData.cs:line 47 at DFramework.Scheduler.TaskBase.Run() in D:\Spraxa\Framework\DFramework.Scheduler\TaskBase.cs:line 176 at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx) at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx) at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state) at System.Threading.ThreadHelper.ThreadStart() 2025-12-31 06:24:21.6586 DFramework.Database.NullableDataReader Data reader open for 337 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-31 06:24:21.7212 DFramework.Database.NullableDataReader Data reader open for 420 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-31 06:24:22.3618 DFramework.Database.NullableDataReader Data reader open for 378 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-31 06:24:22.4086 DFramework.Database.NullableDataReader Data reader open for 460 at System.Environment.GetStackTrace(Exception e, Boolean needFileInfo) at System.Environment.get_StackTrace() at DFramework.Database.NullableDataReader.Dispose(Boolean disposing) in 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-31 06:24:23.4087 DFramework.Database.NullableDataReader Data reader open for 248 at System.Environment.GetStackTrace(Exception e, Boolean needFileInfo) at System.Environment.get_StackTrace() at DFramework.Database.NullableDataReader.Dispose(Boolean disposing) in D:\Spraxa\Framework\DFramework\Database\NullableDataReader.cs:line 33 at DFramework.Database.NullableDataReader.Dispose() in D:\Spraxa\Framework\DFramework\Database\NullableDataReader.cs:line 44 at CoolR.Tasks.ProcessAlertData.Execute() in D:\Spraxa\CoolR-Group\portal\CoolR.Tasks\ProcessAlertData.cs:line 47 at DFramework.Scheduler.TaskBase.Run() in D:\Spraxa\Framework\DFramework.Scheduler\TaskBase.cs:line 176 at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx) at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx) at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state) at System.Threading.ThreadHelper.ThreadStart() 2025-12-31 06:24:23.7993 AlertProcessor Replace Tags updated for the Image Id: 3675440 2025-12-31 06:24:24.4243 DFramework.Database.NullableDataReader Data reader open for 253 at System.Environment.GetStackTrace(Exception e, Boolean needFileInfo) at System.Environment.get_StackTrace() at DFramework.Database.NullableDataReader.Dispose(Boolean disposing) in 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-31 06:24:24.4712 DFramework.Database.NullableDataReader Data reader open for 337 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-31 06:24:25.2368 DFramework.Database.NullableDataReader Data reader open for 225 at System.Environment.GetStackTrace(Exception e, Boolean needFileInfo) at System.Environment.get_StackTrace() at DFramework.Database.NullableDataReader.Dispose(Boolean disposing) in 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-31 06:24:26.0337 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-31 06:24:26.6743 AlertProcessor ProcessorAlertData: Stopped 2025-12-31 06:29:15.6135 DFramework.Database.Query /* Time Taken: 572*/ [dbo].GenerateSystemAlerts 2025-12-31 06:29:18.3166 AlertProcessor ProcessorAlertData: started 2025-12-31 06:29:23.6917 AlertProcessor ProcessorAlertData: Stopped 2025-12-31 06:29:30.9261 DFramework.Scheduler.TaskBase /* Time Taken: 15921.9591*/ Opportunity Out Of Stock By Outlet 2025-12-31 06:34:15.9747 MoveToReorder Running task for ClientId : 286 and ClientName = India Office QA and Slot: 12/31/2025 8:00:00 PM And LastExecutedOn: 12/31/2025 7:04:15 PM 2025-12-31 06:34:18.3341 AlertProcessor ProcessorAlertData: started 2025-12-31 06:34:20.9591 DFramework.Database.Query /* Time Taken: 1420*/ DECLARE @TableName AnsiString(8000) SET @TableName = 'AdditionalShelf' DECLARE @CurrentRecordId Int32 SET @CurrentRecordId = '3675440' dbo.GetValidDeviceForAlertProcessData 2025-12-31 06:34:24.8810 AlertProcessor ProcessorAlertData: Stopped 2025-12-31 06:34:56.0375 DFramework.Database.NullableDataReader Data reader open for 39686 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-31 06:34:56.0687 MoveToReorder Task executed successfully for ClientId : 286 Client Name:India Office QA, Slot: 12/31/2025 8:00:00 PM and Total Order Suggested: 123 Out Of: 123 2025-12-31 06:34:57.5063 DFramework.Database.Query /* Time Taken: 699*/ DECLARE @ClientId Int32 SET @ClientId = '286' DECLARE @OrderStatusId Int32 SET @OrderStatusId = '5485' SELECT * FROM vwScheduledOrderExportInfoList WHERE [ClientId] = @ClientId AND [OrderStatusId] = @OrderStatusId ORDER BY [LocationId] 2025-12-31 06:34:58.0688 DFramework.Scheduler.TaskBase /* Time Taken: 42500.2985*/ Move To Re-Order 2025-12-31 06:39:18.3516 AlertProcessor ProcessorAlertData: started 2025-12-31 06:39:23.4766 AlertProcessor ProcessorAlertData: Stopped 2025-12-31 06:44:15.8377 DFramework.Database.Query /* Time Taken: 771*/ [dbo].GenerateSystemAlerts 2025-12-31 06:44:18.3690 AlertProcessor ProcessorAlertData: started 2025-12-31 06:44:20.2127 DFramework.Database.Query /* Time Taken: 509*/ DECLARE @TableName AnsiString(8000) SET @TableName = 'AdditionalShelf' DECLARE @CurrentRecordId Int32 SET @CurrentRecordId = '3675440' dbo.GetValidDeviceForAlertProcessData 2025-12-31 06:44:21.6659 DFramework.Database.Query /* Time Taken: 583*/ DECLARE @TableName AnsiString(8000) SET @TableName = 'AssetStockProductWiseConsolidate' DECLARE @CurrentRecordId Int32 SET @CurrentRecordId = '3675440' dbo.GetValidDeviceForAlertProcessData 2025-12-31 06:44:24.2596 DFramework.Database.Query /* Time Taken: 663*/ DECLARE @TableName AnsiString(8000) SET @TableName = 'ProductStockLevel' DECLARE @CurrentRecordId Int32 SET @CurrentRecordId = '3675440' dbo.GetValidDeviceForAlertProcessData 2025-12-31 06:44:24.3222 AlertProcessor ProcessorAlertData: Stopped 2025-12-31 06:44:31.0409 DFramework.Scheduler.TaskBase /* Time Taken: 16015.7079*/ Opportunity Out Of Stock By Outlet 2025-12-31 06:49:18.3865 AlertProcessor ProcessorAlertData: started 2025-12-31 06:49:23.4334 AlertProcessor ProcessorAlertData: Stopped 2025-12-31 06:54:18.4040 AlertProcessor ProcessorAlertData: started 2025-12-31 06:54:23.5916 AlertProcessor ProcessorAlertData: Stopped 2025-12-31 06:59:15.7808 DFramework.Database.Query /* Time Taken: 702*/ [dbo].GenerateSystemAlerts 2025-12-31 06:59:18.4214 AlertProcessor ProcessorAlertData: started 2025-12-31 06:59:24.1089 AlertProcessor ProcessorAlertData: Stopped 2025-12-31 06:59:31.0465 DFramework.Scheduler.TaskBase /* Time Taken: 16000.0996*/ Opportunity Out Of Stock By Outlet 2025-12-31 07:04:18.4389 AlertProcessor ProcessorAlertData: started 2025-12-31 07:04:23.4389 AlertProcessor ProcessorAlertData: Stopped 2025-12-31 07:09:18.4564 AlertProcessor ProcessorAlertData: started 2025-12-31 07:09:23.4721 AlertProcessor ProcessorAlertData: Stopped 2025-12-31 07:10:20.5037 DFramework.Database.Query /* Time Taken: 758*/ 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-31 07:10:20.5037 DFramework.Database.Query /* Time Taken: 759*/ DECLARE @IsFileProcessed Int32 SET @IsFileProcessed = '0' DECLARE @TaskNumber Int32 SET @TaskNumber = '0' DECLARE @IsDeleted Int32 SET @IsDeleted = '0' SELECT TOP 1000 IncomingFileId, GatewayId,GatewayMac,RawFileName,AzureContainerName,StartIndex,Tries, CreatedOn FROM IncomingFile WHERE [IsFileProcessed] = @IsFileProcessed AND [TaskNumber] = @TaskNumber AND [IsDeleted] = @IsDeleted 2025-12-31 07:10:25.5350 DFramework.Database.Query /* Time Taken: 777*/ 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-31 07:10:25.5350 DFramework.Database.Query /* Time Taken: 777*/ 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-31 07:14:16.0676 DFramework.Database.Query /* Time Taken: 965*/ [dbo].GenerateSystemAlerts 2025-12-31 07:14:18.4739 AlertProcessor ProcessorAlertData: started 2025-12-31 07:14:23.7396 AlertProcessor ProcessorAlertData: Stopped 2025-12-31 07:14:31.2084 DFramework.Scheduler.TaskBase /* Time Taken: 16140.7236*/ Opportunity Out Of Stock By Outlet 2025-12-31 07:19:18.4914 AlertProcessor ProcessorAlertData: started 2025-12-31 07:19:23.9289 AlertProcessor ProcessorAlertData: Stopped 2025-12-31 07:21:07.5702 DFramework.Database.Query /* Time Taken: 1077*/ 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-31 07:21:07.5858 DFramework.Database.Query /* Time Taken: 1093*/ DECLARE @IsFileProcessed Int32 SET @IsFileProcessed = '0' DECLARE @TaskNumber Int32 SET @TaskNumber = '2' DECLARE @IsDeleted Int32 SET @IsDeleted = '0' SELECT TOP 1000 IncomingFileId, GatewayId,GatewayMac,RawFileName,AzureContainerName,StartIndex,Tries, CreatedOn FROM IncomingFile WHERE [IsFileProcessed] = @IsFileProcessed AND [TaskNumber] = @TaskNumber AND [IsDeleted] = @IsDeleted 2025-12-31 07:23:07.3834 DFramework.Database.Query /* Time Taken: 560*/ DECLARE @IsFileProcessed Int32 SET @IsFileProcessed = '0' DECLARE @TaskNumber Int32 SET @TaskNumber = '2' DECLARE @IsDeleted Int32 SET @IsDeleted = '0' SELECT TOP 1000 IncomingFileId, GatewayId,GatewayMac,RawFileName,AzureContainerName,StartIndex,Tries, CreatedOn FROM IncomingFile WHERE [IsFileProcessed] = @IsFileProcessed AND [TaskNumber] = @TaskNumber AND [IsDeleted] = @IsDeleted 2025-12-31 07:23:07.3834 DFramework.Database.Query /* Time Taken: 562*/ 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-31 07:23:07.3834 DFramework.Database.Query /* Time Taken: 562*/ 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-31 07:24:18.5089 AlertProcessor ProcessorAlertData: started 2025-12-31 07:24:20.3683 DFramework.Database.Query /* Time Taken: 589*/ DECLARE @TableName AnsiString(8000) SET @TableName = 'AdditionalShelf' DECLARE @CurrentRecordId Int32 SET @CurrentRecordId = '3675440' dbo.GetValidDeviceForAlertProcessData 2025-12-31 07:24:21.1027 DFramework.Database.NullableDataReader Data reader open for 323 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-31 07:24:21.1496 DFramework.Database.NullableDataReader Data reader open for 408 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-31 07:24:21.9621 DFramework.Database.NullableDataReader Data reader open for 436 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-31 07:24:22.0246 DFramework.Database.NullableDataReader Data reader open for 524 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-31 07:24:22.7433 DFramework.Database.NullableDataReader Data reader open for 445 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-31 07:24:22.7902 DFramework.Database.NullableDataReader Data reader open for 529 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-31 07:24:23.3214 DFramework.Database.Query /* Time Taken: 523*/ DECLARE @TableName AnsiString(8000) SET @TableName = 'AssetStockProductWiseConsolidate' DECLARE @CurrentRecordId Int32 SET @CurrentRecordId = '3675440' dbo.GetValidDeviceForAlertProcessData 2025-12-31 07:24:23.8371 DFramework.Database.NullableDataReader Data reader open for 228 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-31 07:24:24.1652 AlertProcessor Replace Tags updated for the Image Id: 3675343 2025-12-31 07:24:24.3371 DFramework.Database.NullableDataReader Data reader open for 259 at System.Environment.GetStackTrace(Exception e, Boolean needFileInfo) at System.Environment.get_StackTrace() at DFramework.Database.NullableDataReader.Dispose(Boolean disposing) in 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-31 07:24:24.9152 DFramework.Database.NullableDataReader Data reader open for 328 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-31 07:24:24.9777 DFramework.Database.NullableDataReader Data reader open for 417 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-31 07:24:25.8527 DFramework.Database.NullableDataReader Data reader open for 227 at System.Environment.GetStackTrace(Exception e, Boolean needFileInfo) at System.Environment.get_StackTrace() at DFramework.Database.NullableDataReader.Dispose(Boolean disposing) in D:\Spraxa\Framework\DFramework\Database\NullableDataReader.cs:line 33 at DFramework.Database.NullableDataReader.Dispose() in D:\Spraxa\Framework\DFramework\Database\NullableDataReader.cs:line 44 at CoolR.Tasks.ProcessAlertData.Execute() in D:\Spraxa\CoolR-Group\portal\CoolR.Tasks\ProcessAlertData.cs:line 47 at DFramework.Scheduler.TaskBase.Run() in D:\Spraxa\Framework\DFramework.Scheduler\TaskBase.cs:line 176 at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx) at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx) at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state) at System.Threading.ThreadHelper.ThreadStart() 2025-12-31 07:24:26.7121 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-31 07:24:27.2277 AlertProcessor ProcessorAlertData: Stopped 2025-12-31 07:29:15.9327 DFramework.Database.Query /* Time Taken: 806*/ [dbo].GenerateSystemAlerts 2025-12-31 07:29:18.5264 AlertProcessor ProcessorAlertData: started 2025-12-31 07:29:23.5890 AlertProcessor ProcessorAlertData: Stopped 2025-12-31 07:29:31.2453 DFramework.Scheduler.TaskBase /* Time Taken: 16156.3544*/ Opportunity Out Of Stock By Outlet 2025-12-31 07:34:16.0908 MoveToReorder Running task for ClientId : 286 and ClientName = India Office QA and Slot: 12/31/2025 9:00:00 PM And LastExecutedOn: 12/31/2025 8:04:15 PM 2025-12-31 07:34:17.6845 DFramework.Database.NullableDataReader Data reader open for 1201 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-31 07:34:17.7158 MoveToReorder Task executed successfully for ClientId : 286 Client Name:India Office QA, Slot: 12/31/2025 9:00:00 PM and Total Order Suggested: 3 Out Of: 3 2025-12-31 07:34:18.5439 AlertProcessor ProcessorAlertData: started 2025-12-31 07:34:24.0752 AlertProcessor ProcessorAlertData: Stopped 2025-12-31 07:39:18.5458 AlertProcessor ProcessorAlertData: started 2025-12-31 07:39:23.5458 AlertProcessor ProcessorAlertData: Stopped 2025-12-31 07:39:50.6241 DFramework.Database.Query /* Time Taken: 858*/ DECLARE @IsFileProcessed Int32 SET @IsFileProcessed = '0' DECLARE @TaskNumber Int32 SET @TaskNumber = '2' DECLARE @IsDeleted Int32 SET @IsDeleted = '0' SELECT TOP 1000 IncomingFileId, GatewayId,GatewayMac,RawFileName,AzureContainerName,StartIndex,Tries, CreatedOn FROM IncomingFile WHERE [IsFileProcessed] = @IsFileProcessed AND [TaskNumber] = @TaskNumber AND [IsDeleted] = @IsDeleted 2025-12-31 07:44:15.9696 DFramework.Database.Query /* Time Taken: 812*/ [dbo].GenerateSystemAlerts 2025-12-31 07:44:18.5477 AlertProcessor ProcessorAlertData: started 2025-12-31 07:44:24.0165 AlertProcessor ProcessorAlertData: Stopped 2025-12-31 07:44:31.1884 DFramework.Scheduler.TaskBase /* Time Taken: 16078.2331*/ Opportunity Out Of Stock By Outlet 2025-12-31 07:49:18.5495 AlertProcessor ProcessorAlertData: started 2025-12-31 07:49:23.5652 AlertProcessor ProcessorAlertData: Stopped 2025-12-31 07:54:18.5670 AlertProcessor ProcessorAlertData: started 2025-12-31 07:54:23.5983 AlertProcessor ProcessorAlertData: Stopped 2025-12-31 07:57:13.2556 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-31 07:57:18.3806 DFramework.Database.Query /* Time Taken: 698*/ 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-31 07:59:13.8657 DFramework.Database.Query /* Time Taken: 850*/ DECLARE @IsFileProcessed Int32 SET @IsFileProcessed = '0' DECLARE @TaskNumber Int32 SET @TaskNumber = '2' DECLARE @IsDeleted Int32 SET @IsDeleted = '0' SELECT TOP 1000 IncomingFileId, GatewayId,GatewayMac,RawFileName,AzureContainerName,StartIndex,Tries, CreatedOn FROM IncomingFile WHERE [IsFileProcessed] = @IsFileProcessed AND [TaskNumber] = @TaskNumber AND [IsDeleted] = @IsDeleted 2025-12-31 07:59:13.8657 DFramework.Database.Query /* Time Taken: 851*/ 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-31 07:59:13.8657 DFramework.Database.Query /* Time Taken: 851*/ 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-31 07:59:13.8657 DFramework.Database.Query /* Time Taken: 851*/ 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-31 07:59:15.6626 DFramework.Database.NullableDataReader Data reader open for 429 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.ProcessOutletAlertData.GetAlertDefinitions() in D:\Spraxa\CoolR-Group\portal\CoolR.Tasks\OpportunityOutOfStockByOutlet.cs:line 490 at CoolR.Tasks.ProcessOutletAlertData.Execute() in D:\Spraxa\CoolR-Group\portal\CoolR.Tasks\OpportunityOutOfStockByOutlet.cs:line 72 at DFramework.Scheduler.TaskBase.Run() in D:\Spraxa\Framework\DFramework.Scheduler\TaskBase.cs:line 176 at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx) at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx) at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state) at System.Threading.ThreadHelper.ThreadStart() 2025-12-31 07:59:17.2407 DFramework.Database.Query /* Time Taken: 2075*/ [dbo].GenerateSystemAlerts 2025-12-31 07:59:17.7251 DFramework.Database.Query /* Time Taken: 2072*/ DECLARE @ClientId Int32 SET @ClientId = '213' DECLARE @MarketId Int32 SET @MarketId = '0' DECLARE @ClassificationId Int32 SET @ClassificationId = '0' DECLARE @LocationId Int32 SET @LocationId = '0' DECLARE @LocationTypeId Int32 SET @LocationTypeId = '0' DECLARE @StartDate DateTime2 SET @StartDate = '8/28/2025 12:00:00 AM' dbo.GetOpportunityOutOfStockDataByOutlet 2025-12-31 07:59:18.5845 AlertProcessor ProcessorAlertData: started 2025-12-31 07:59:20.4282 DFramework.Database.Query /* Time Taken: 534*/ DECLARE @TableName AnsiString(8000) SET @TableName = 'AdditionalShelf' DECLARE @CurrentRecordId Int32 SET @CurrentRecordId = '3675440' dbo.GetValidDeviceForAlertProcessData 2025-12-31 07:59:24.3033 AlertProcessor ProcessorAlertData: Stopped 2025-12-31 07:59:33.4283 DFramework.Scheduler.TaskBase /* Time Taken: 18296.9948*/ Opportunity Out Of Stock By Outlet 2025-12-31 08:02:13.9918 DFramework.Database.Query /* Time Taken: 528*/ 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-31 08:02:14.1012 DFramework.Database.Query /* Time Taken: 633*/ 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-31 08:04:18.6020 AlertProcessor ProcessorAlertData: started 2025-12-31 08:04:21.6489 DFramework.Database.Query /* Time Taken: 539*/ DECLARE @TableName AnsiString(8000) SET @TableName = 'AssetStockProductWiseConsolidate' DECLARE @CurrentRecordId Int32 SET @CurrentRecordId = '3675440' dbo.GetValidDeviceForAlertProcessData 2025-12-31 08:04:24.1958 AlertProcessor ProcessorAlertData: Stopped 2025-12-31 08:09:18.6038 AlertProcessor ProcessorAlertData: started 2025-12-31 08:09:20.7913 DFramework.Database.NullableDataReader Data reader open for 203 at System.Environment.GetStackTrace(Exception e, Boolean needFileInfo) at System.Environment.get_StackTrace() at DFramework.Database.NullableDataReader.Dispose(Boolean disposing) in D:\Spraxa\Framework\DFramework\Database\NullableDataReader.cs:line 33 at DFramework.Database.NullableDataReader.Dispose() in D:\Spraxa\Framework\DFramework\Database\NullableDataReader.cs:line 44 at CoolR.Tasks.ProcessAlertData.Execute() in D:\Spraxa\CoolR-Group\portal\CoolR.Tasks\ProcessAlertData.cs:line 47 at DFramework.Scheduler.TaskBase.Run() in D:\Spraxa\Framework\DFramework.Scheduler\TaskBase.cs:line 176 at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx) at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx) at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state) at System.Threading.ThreadHelper.ThreadStart() 2025-12-31 08:09:20.8538 DFramework.Database.NullableDataReader Data reader open for 287 at System.Environment.GetStackTrace(Exception e, Boolean needFileInfo) at System.Environment.get_StackTrace() at DFramework.Database.NullableDataReader.Dispose(Boolean disposing) in 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-31 08:09:21.3694 DFramework.Database.NullableDataReader Data reader open for 265 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-31 08:09:21.4163 DFramework.Database.NullableDataReader Data reader open for 351 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-31 08:09:21.9944 DFramework.Database.NullableDataReader Data reader open for 325 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-31 08:09:22.0413 DFramework.Database.NullableDataReader Data reader open for 409 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-31 08:09:22.9319 DFramework.Database.NullableDataReader Data reader open for 222 at System.Environment.GetStackTrace(Exception e, Boolean needFileInfo) at System.Environment.get_StackTrace() at DFramework.Database.NullableDataReader.Dispose(Boolean disposing) in D:\Spraxa\Framework\DFramework\Database\NullableDataReader.cs:line 33 at DFramework.Database.NullableDataReader.Dispose() in D:\Spraxa\Framework\DFramework\Database\NullableDataReader.cs:line 44 at CoolR.Tasks.ProcessAlertData.Execute() in D:\Spraxa\CoolR-Group\portal\CoolR.Tasks\ProcessAlertData.cs:line 47 at DFramework.Scheduler.TaskBase.Run() in D:\Spraxa\Framework\DFramework.Scheduler\TaskBase.cs:line 176 at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx) at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx) at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state) at System.Threading.ThreadHelper.ThreadStart() 2025-12-31 08:09:23.2288 AlertProcessor Replace Tags updated for the Image Id: 3675443 2025-12-31 08:09:23.3694 DFramework.Database.NullableDataReader Data reader open for 237 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-31 08:09:23.9007 DFramework.Database.NullableDataReader Data reader open for 277 at System.Environment.GetStackTrace(Exception e, Boolean needFileInfo) at System.Environment.get_StackTrace() at DFramework.Database.NullableDataReader.Dispose(Boolean disposing) in D:\Spraxa\Framework\DFramework\Database\NullableDataReader.cs:line 33 at DFramework.Database.NullableDataReader.Dispose() in D:\Spraxa\Framework\DFramework\Database\NullableDataReader.cs:line 44 at CoolR.Tasks.ProcessAlertData.Execute() in D:\Spraxa\CoolR-Group\portal\CoolR.Tasks\ProcessAlertData.cs:line 47 at DFramework.Scheduler.TaskBase.Run() in D:\Spraxa\Framework\DFramework.Scheduler\TaskBase.cs:line 176 at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx) at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx) at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state) at System.Threading.ThreadHelper.ThreadStart() 2025-12-31 08:09:23.9632 DFramework.Database.NullableDataReader Data reader open for 360 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-31 08:09:24.6976 DFramework.Database.NullableDataReader Data reader open for 222 at System.Environment.GetStackTrace(Exception e, Boolean needFileInfo) at System.Environment.get_StackTrace() at DFramework.Database.NullableDataReader.Dispose(Boolean disposing) in D:\Spraxa\Framework\DFramework\Database\NullableDataReader.cs:line 33 at DFramework.Database.NullableDataReader.Dispose() in D:\Spraxa\Framework\DFramework\Database\NullableDataReader.cs:line 44 at CoolR.Tasks.ProcessAlertData.Execute() in D:\Spraxa\CoolR-Group\portal\CoolR.Tasks\ProcessAlertData.cs:line 47 at DFramework.Scheduler.TaskBase.Run() in D:\Spraxa\Framework\DFramework.Scheduler\TaskBase.cs:line 176 at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx) at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx) at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state) at System.Threading.ThreadHelper.ThreadStart() 2025-12-31 08:09:25.5101 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-31 08:09:26.0101 AlertProcessor ProcessorAlertData: Stopped 2025-12-31 08:14:15.9494 DFramework.Database.Query /* Time Taken: 769*/ [dbo].GenerateSystemAlerts 2025-12-31 08:14:18.6056 AlertProcessor ProcessorAlertData: started 2025-12-31 08:14:20.8557 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-31 08:14:23.8557 AlertProcessor ProcessorAlertData: Stopped 2025-12-31 08:14:31.2464 DFramework.Scheduler.TaskBase /* Time Taken: 16093.8538*/ Opportunity Out Of Stock By Outlet 2025-12-31 08:19:18.6075 AlertProcessor ProcessorAlertData: started 2025-12-31 08:19:23.5294 AlertProcessor ProcessorAlertData: Stopped 2025-12-31 08:24:18.6256 AlertProcessor ProcessorAlertData: started 2025-12-31 08:24:23.7819 AlertProcessor ProcessorAlertData: Stopped 2025-12-31 08:29:15.7683 DFramework.Database.Query /* Time Taken: 581*/ [dbo].GenerateSystemAlerts 2025-12-31 08:29:18.6433 AlertProcessor ProcessorAlertData: started 2025-12-31 08:29:23.6902 AlertProcessor ProcessorAlertData: Stopped 2025-12-31 08:29:31.2372 DFramework.Scheduler.TaskBase /* Time Taken: 16062.6103*/ Opportunity Out Of Stock By Outlet 2025-12-31 08:34:16.1140 MoveToReorder Running task for ClientId : 286 and ClientName = India Office QA and Slot: 12/31/2025 10:00:00 PM And LastExecutedOn: 12/31/2025 9:04:16 PM 2025-12-31 08:34:16.4578 MoveToReorder Task executed successfully for ClientId : 286 Client Name:India Office QA, Slot: 12/31/2025 10:00:00 PM But No Order found to suggest 2025-12-31 08:34:18.6609 AlertProcessor ProcessorAlertData: started 2025-12-31 08:34:24.1922 AlertProcessor ProcessorAlertData: Stopped 2025-12-31 08:39:18.6788 AlertProcessor ProcessorAlertData: started 2025-12-31 08:39:24.3039 AlertProcessor ProcessorAlertData: Stopped 2025-12-31 08:44:15.7438 DFramework.Database.Query /* Time Taken: 559*/ [dbo].GenerateSystemAlerts 2025-12-31 08:44:18.6969 AlertProcessor ProcessorAlertData: started 2025-12-31 08:44:24.2282 AlertProcessor ProcessorAlertData: Stopped 2025-12-31 08:44:31.0095 DFramework.Scheduler.TaskBase /* Time Taken: 15812.5952*/ Opportunity Out Of Stock By Outlet 2025-12-31 08:49:18.7146 AlertProcessor ProcessorAlertData: started 2025-12-31 08:49:21.7303 DFramework.Database.Query /* Time Taken: 530*/ DECLARE @TableName AnsiString(8000) SET @TableName = 'AssetStockProductWiseConsolidate' DECLARE @CurrentRecordId Int32 SET @CurrentRecordId = '3675443' dbo.GetValidDeviceForAlertProcessData 2025-12-31 08:49:24.2772 AlertProcessor ProcessorAlertData: Stopped 2025-12-31 08:54:18.7166 AlertProcessor ProcessorAlertData: started 2025-12-31 08:54:24.2322 AlertProcessor ProcessorAlertData: Stopped 2025-12-31 08:59:18.7190 AlertProcessor ProcessorAlertData: started 2025-12-31 08:59:24.2816 AlertProcessor ProcessorAlertData: Stopped 2025-12-31 08:59:31.0160 DFramework.Scheduler.TaskBase /* Time Taken: 15796.9943*/ Opportunity Out Of Stock By Outlet 2025-12-31 09:04:18.7368 AlertProcessor ProcessorAlertData: started 2025-12-31 09:04:24.3149 AlertProcessor ProcessorAlertData: Stopped 2025-12-31 09:09:18.7543 AlertProcessor ProcessorAlertData: started 2025-12-31 09:09:24.2231 AlertProcessor ProcessorAlertData: Stopped 2025-12-31 09:14:15.8036 DFramework.Database.Query /* Time Taken: 565*/ [dbo].GenerateSystemAlerts 2025-12-31 09:14:18.7723 AlertProcessor ProcessorAlertData: started 2025-12-31 09:14:20.6317 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-31 09:14:24.4286 AlertProcessor ProcessorAlertData: Stopped 2025-12-31 09:14:31.0693 DFramework.Scheduler.TaskBase /* Time Taken: 15828.2648*/ Opportunity Out Of Stock By Outlet 2025-12-31 09:19:18.7903 AlertProcessor ProcessorAlertData: started 2025-12-31 09:19:24.3216 AlertProcessor ProcessorAlertData: Stopped 2025-12-31 09:24:18.8079 AlertProcessor ProcessorAlertData: started 2025-12-31 09:24:24.2923 AlertProcessor ProcessorAlertData: Stopped 2025-12-31 09:29:15.9349 DFramework.Database.Query /* Time Taken: 685*/ [dbo].GenerateSystemAlerts 2025-12-31 09:29:18.8099 AlertProcessor ProcessorAlertData: started 2025-12-31 09:29:24.4037 AlertProcessor ProcessorAlertData: Stopped 2025-12-31 09:29:31.1850 DFramework.Scheduler.TaskBase /* Time Taken: 15922.0237*/ Opportunity Out Of Stock By Outlet 2025-12-31 09:34:18.8280 AlertProcessor ProcessorAlertData: started 2025-12-31 09:34:24.3749 AlertProcessor ProcessorAlertData: Stopped 2025-12-31 09:39:18.8457 AlertProcessor ProcessorAlertData: started 2025-12-31 09:39:24.2988 AlertProcessor ProcessorAlertData: Stopped 2025-12-31 09:44:15.8789 DFramework.Database.Query /* Time Taken: 612*/ [dbo].GenerateSystemAlerts 2025-12-31 09:44:18.8476 AlertProcessor ProcessorAlertData: started 2025-12-31 09:44:24.3633 AlertProcessor ProcessorAlertData: Stopped 2025-12-31 09:44:31.4102 DFramework.Scheduler.TaskBase /* Time Taken: 16140.7276*/ Opportunity Out Of Stock By Outlet 2025-12-31 09:49:18.8657 AlertProcessor ProcessorAlertData: started 2025-12-31 09:49:24.4126 DFramework.Database.Query /* Time Taken: 501*/ DECLARE @TableName AnsiString(8000) SET @TableName = 'ProductStockLevel' DECLARE @CurrentRecordId Int32 SET @CurrentRecordId = '3675443' dbo.GetValidDeviceForAlertProcessData 2025-12-31 09:49:24.4751 AlertProcessor ProcessorAlertData: Stopped 2025-12-31 09:54:16.5086 DFramework.Database.Query /* Time Taken: 565*/ DECLARE @OrderStatusId Int32 SET @OrderStatusId = '5486' UPDATE Location SET ScheduledOrderId = 0, OrderStatusId = 0 from ScheduledOrder INNER JOIN Location ON Location.ScheduledOrderId = ScheduledOrder.ScheduledOrderId AND Location.OrderStatusId = @OrderStatusId INNER JOIN CLient On Client.ClientId = Location.ClientId AND Client.HoursToMoveIgnored > 0 WHERE DATEADD(HOUR, Client.HoursToMoveIgnored, ScheduledOrder.ModifiedOn) < GETUTCDATE() AND ScheduledOrder.StatusId = @OrderStatusId ANd Location.IsDeleted = 0 AND ScheduledOrder.IsDeleted = 0 2025-12-31 09:54:18.8836 AlertProcessor ProcessorAlertData: started 2025-12-31 09:54:24.4461 AlertProcessor ProcessorAlertData: Stopped 2025-12-31 09:59:15.8231 DFramework.Database.Query /* Time Taken: 550*/ [dbo].GenerateSystemAlerts 2025-12-31 09:59:18.9012 AlertProcessor ProcessorAlertData: started 2025-12-31 09:59:24.4637 AlertProcessor ProcessorAlertData: Stopped 2025-12-31 09:59:31.1513 DFramework.Scheduler.TaskBase /* Time Taken: 15875.1022*/ Opportunity Out Of Stock By Outlet 2025-12-31 10:04:18.9190 AlertProcessor ProcessorAlertData: started 2025-12-31 10:04:24.5909 AlertProcessor ProcessorAlertData: Stopped 2025-12-31 10:09:18.9370 AlertProcessor ProcessorAlertData: started 2025-12-31 10:09:21.9682 DFramework.Database.Query /* Time Taken: 579*/ DECLARE @TableName AnsiString(8000) SET @TableName = 'AssetStockProductWiseConsolidate' DECLARE @CurrentRecordId Int32 SET @CurrentRecordId = '3675443' dbo.GetValidDeviceForAlertProcessData 2025-12-31 10:09:24.5620 AlertProcessor ProcessorAlertData: Stopped 2025-12-31 10:14:15.7984 DFramework.Database.Query /* Time Taken: 509*/ [dbo].GenerateSystemAlerts 2025-12-31 10:14:18.9546 AlertProcessor ProcessorAlertData: started 2025-12-31 10:14:24.5797 AlertProcessor ProcessorAlertData: Stopped 2025-12-31 10:14:31.1110 DFramework.Scheduler.TaskBase /* Time Taken: 15812.5961*/ Opportunity Out Of Stock By Outlet 2025-12-31 10:19:18.9566 AlertProcessor ProcessorAlertData: started 2025-12-31 10:19:24.4410 AlertProcessor ProcessorAlertData: Stopped 2025-12-31 10:24:18.9747 AlertProcessor ProcessorAlertData: started 2025-12-31 10:24:20.5997 DFramework.Database.Query /* Time Taken: 631*/ DECLARE @TableName AnsiString(8000) SET @TableName = 'MissingShelf' DECLARE @CurrentRecordId Int32 SET @CurrentRecordId = '3675443' dbo.GetValidDeviceForAlertProcessData 2025-12-31 10:24:25.3966 AlertProcessor ProcessorAlertData: Stopped 2025-12-31 10:29:18.9925 AlertProcessor ProcessorAlertData: started 2025-12-31 10:29:24.6175 AlertProcessor ProcessorAlertData: Stopped 2025-12-31 10:29:31.1644 DFramework.Scheduler.TaskBase /* Time Taken: 15843.8572*/ Opportunity Out Of Stock By Outlet 2025-12-31 10:34:19.0101 AlertProcessor ProcessorAlertData: started 2025-12-31 10:34:24.5414 AlertProcessor ProcessorAlertData: Stopped 2025-12-31 10:39:19.0279 AlertProcessor ProcessorAlertData: started 2025-12-31 10:39:24.5905 AlertProcessor ProcessorAlertData: Stopped 2025-12-31 10:44:15.8582 DFramework.Database.Query /* Time Taken: 525*/ [dbo].GenerateSystemAlerts 2025-12-31 10:44:19.0457 AlertProcessor ProcessorAlertData: started 2025-12-31 10:44:24.5458 AlertProcessor ProcessorAlertData: Stopped 2025-12-31 10:44:31.2489 DFramework.Scheduler.TaskBase /* Time Taken: 15906.3567*/ Opportunity Out Of Stock By Outlet 2025-12-31 10:49:19.0477 AlertProcessor ProcessorAlertData: started 2025-12-31 10:49:24.5165 AlertProcessor ProcessorAlertData: Stopped 2025-12-31 10:54:19.0653 AlertProcessor ProcessorAlertData: started 2025-12-31 10:54:24.5654 AlertProcessor ProcessorAlertData: Stopped 2025-12-31 10:59:19.0836 AlertProcessor ProcessorAlertData: started 2025-12-31 10:59:24.6462 AlertProcessor ProcessorAlertData: Stopped 2025-12-31 10:59:31.1462 DFramework.Scheduler.TaskBase /* Time Taken: 15781.3665*/ Opportunity Out Of Stock By Outlet 2025-12-31 11:04:19.1014 AlertProcessor ProcessorAlertData: started 2025-12-31 11:04:24.6640 AlertProcessor ProcessorAlertData: Stopped 2025-12-31 11:09:19.1191 AlertProcessor ProcessorAlertData: started 2025-12-31 11:09:24.5722 DFramework.Database.Query /* Time Taken: 523*/ DECLARE @TableName AnsiString(8000) SET @TableName = 'ProductStockLevel' DECLARE @CurrentRecordId Int32 SET @CurrentRecordId = '3675443' dbo.GetValidDeviceForAlertProcessData 2025-12-31 11:09:24.6191 AlertProcessor ProcessorAlertData: Stopped 2025-12-31 11:14:15.9183 DFramework.Database.Query /* Time Taken: 540*/ [dbo].GenerateSystemAlerts 2025-12-31 11:14:19.1370 AlertProcessor ProcessorAlertData: started 2025-12-31 11:14:24.6840 AlertProcessor ProcessorAlertData: Stopped 2025-12-31 11:14:31.2465 DFramework.Scheduler.TaskBase /* Time Taken: 15859.5078*/ Opportunity Out Of Stock By Outlet 2025-12-31 11:19:19.1393 AlertProcessor ProcessorAlertData: started 2025-12-31 11:19:20.9830 DFramework.Database.NullableDataReader Data reader open for 278 at System.Environment.GetStackTrace(Exception e, Boolean needFileInfo) at System.Environment.get_StackTrace() at DFramework.Database.NullableDataReader.Dispose(Boolean disposing) in D:\Spraxa\Framework\DFramework\Database\NullableDataReader.cs:line 33 at DFramework.Database.NullableDataReader.Dispose() in D:\Spraxa\Framework\DFramework\Database\NullableDataReader.cs:line 44 at CoolR.Tasks.ProcessAlertData.Execute() in D:\Spraxa\CoolR-Group\portal\CoolR.Tasks\ProcessAlertData.cs:line 47 at DFramework.Scheduler.TaskBase.Run() in D:\Spraxa\Framework\DFramework.Scheduler\TaskBase.cs:line 176 at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx) at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx) at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state) at System.Threading.ThreadHelper.ThreadStart() 2025-12-31 11:19:24.8581 AlertProcessor ProcessorAlertData: Stopped 2025-12-31 11:24:19.1569 AlertProcessor ProcessorAlertData: started 2025-12-31 11:24:24.7351 AlertProcessor ProcessorAlertData: Stopped 2025-12-31 11:29:15.9402 DFramework.Database.Query /* Time Taken: 535*/ [dbo].GenerateSystemAlerts 2025-12-31 11:29:19.1746 AlertProcessor ProcessorAlertData: started 2025-12-31 11:29:24.6121 AlertProcessor ProcessorAlertData: Stopped 2025-12-31 11:29:31.2528 DFramework.Scheduler.TaskBase /* Time Taken: 15843.8779*/ Opportunity Out Of Stock By Outlet 2025-12-31 11:34:19.1925 AlertProcessor ProcessorAlertData: started 2025-12-31 11:34:24.7081 AlertProcessor ProcessorAlertData: Stopped 2025-12-31 11:39:19.2101 AlertProcessor ProcessorAlertData: started 2025-12-31 11:39:24.6633 AlertProcessor ProcessorAlertData: Stopped 2025-12-31 11:44:15.9621 DFramework.Database.Query /* Time Taken: 540*/ [dbo].GenerateSystemAlerts 2025-12-31 11:44:19.2277 AlertProcessor ProcessorAlertData: started 2025-12-31 11:44:24.7746 AlertProcessor ProcessorAlertData: Stopped 2025-12-31 11:44:31.2903 DFramework.Scheduler.TaskBase /* Time Taken: 15859.4729*/ Opportunity Out Of Stock By Outlet 2025-12-31 11:49:19.2457 AlertProcessor ProcessorAlertData: started 2025-12-31 11:49:24.7145 AlertProcessor ProcessorAlertData: Stopped 2025-12-31 11:54:19.2635 AlertProcessor ProcessorAlertData: started 2025-12-31 11:54:24.6854 AlertProcessor ProcessorAlertData: Stopped 2025-12-31 11:59:15.9842 DFramework.Database.Query /* Time Taken: 539*/ [dbo].GenerateSystemAlerts 2025-12-31 11:59:19.2811 AlertProcessor ProcessorAlertData: started 2025-12-31 11:59:24.9061 AlertProcessor ProcessorAlertData: Stopped 2025-12-31 11:59:31.3280 DFramework.Scheduler.TaskBase /* Time Taken: 15875.0957*/ Opportunity Out Of Stock By Outlet 2025-12-31 12:04:19.2989 AlertProcessor ProcessorAlertData: started 2025-12-31 12:04:24.7833 AlertProcessor ProcessorAlertData: Stopped 2025-12-31 12:09:19.3168 AlertProcessor ProcessorAlertData: started 2025-12-31 12:09:24.9419 AlertProcessor ProcessorAlertData: Stopped 2025-12-31 12:14:19.3345 AlertProcessor ProcessorAlertData: started 2025-12-31 12:14:25.0377 AlertProcessor ProcessorAlertData: Stopped 2025-12-31 12:14:31.3815 DFramework.Scheduler.TaskBase /* Time Taken: 15906.3474*/ Opportunity Out Of Stock By Outlet 2025-12-31 12:19:19.3365 AlertProcessor ProcessorAlertData: started 2025-12-31 12:19:24.8053 AlertProcessor ProcessorAlertData: Stopped 2025-12-31 12:24:19.3545 AlertProcessor ProcessorAlertData: started 2025-12-31 12:24:21.4795 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-31 12:24:25.0420 AlertProcessor ProcessorAlertData: Stopped 2025-12-31 12:29:19.3722 AlertProcessor ProcessorAlertData: started 2025-12-31 12:29:24.8566 AlertProcessor ProcessorAlertData: Stopped 2025-12-31 12:29:31.3879 DFramework.Scheduler.TaskBase /* Time Taken: 15890.7293*/ Opportunity Out Of Stock By Outlet 2025-12-31 12:34:19.3898 AlertProcessor ProcessorAlertData: started 2025-12-31 12:34:24.8117 AlertProcessor ProcessorAlertData: Stopped 2025-12-31 12:39:19.4078 AlertProcessor ProcessorAlertData: started 2025-12-31 12:39:24.7516 AlertProcessor ProcessorAlertData: Stopped 2025-12-31 12:44:19.4258 AlertProcessor ProcessorAlertData: started 2025-12-31 12:44:24.9883 AlertProcessor ProcessorAlertData: Stopped 2025-12-31 12:44:31.3946 DFramework.Scheduler.TaskBase /* Time Taken: 15875.1144*/ Opportunity Out Of Stock By Outlet 2025-12-31 12:49:19.4435 AlertProcessor ProcessorAlertData: started 2025-12-31 12:49:24.8966 AlertProcessor ProcessorAlertData: Stopped 2025-12-31 12:54:19.4612 AlertProcessor ProcessorAlertData: started 2025-12-31 12:54:24.8987 AlertProcessor ProcessorAlertData: Stopped 2025-12-31 12:59:19.4793 AlertProcessor ProcessorAlertData: started 2025-12-31 12:59:24.9481 AlertProcessor ProcessorAlertData: Stopped 2025-12-31 12:59:31.4013 DFramework.Scheduler.TaskBase /* Time Taken: 15859.4938*/ Opportunity Out Of Stock By Outlet 2025-12-31 13:04:19.4971 AlertProcessor ProcessorAlertData: started 2025-12-31 13:04:25.0127 AlertProcessor ProcessorAlertData: Stopped 2025-12-31 13:09:19.5147 AlertProcessor ProcessorAlertData: started 2025-12-31 13:09:25.2022 AlertProcessor ProcessorAlertData: Stopped 2025-12-31 13:14:19.5329 AlertProcessor ProcessorAlertData: started 2025-12-31 13:14:25.1579 AlertProcessor ProcessorAlertData: Stopped 2025-12-31 13:14:31.4549 DFramework.Scheduler.TaskBase /* Time Taken: 15890.7595*/ Opportunity Out Of Stock By Outlet 2025-12-31 13:19:19.5508 AlertProcessor ProcessorAlertData: started 2025-12-31 13:19:25.0665 AlertProcessor ProcessorAlertData: Stopped 2025-12-31 13:24:19.5685 AlertProcessor ProcessorAlertData: started 2025-12-31 13:24:25.1467 AlertProcessor ProcessorAlertData: Stopped 2025-12-31 13:29:16.1020 DFramework.Database.Query /* Time Taken: 539*/ [dbo].GenerateSystemAlerts 2025-12-31 13:29:19.5707 AlertProcessor ProcessorAlertData: started 2025-12-31 13:29:25.0239 AlertProcessor ProcessorAlertData: Stopped 2025-12-31 13:29:31.5240 DFramework.Scheduler.TaskBase /* Time Taken: 15953.2801*/ Opportunity Out Of Stock By Outlet 2025-12-31 13:34:19.5889 AlertProcessor ProcessorAlertData: started 2025-12-31 13:34:22.6358 DFramework.Database.Query /* Time Taken: 512*/ DECLARE @TableName AnsiString(8000) SET @TableName = 'AssetStockProductWiseConsolidate' DECLARE @CurrentRecordId Int32 SET @CurrentRecordId = '3675443' dbo.GetValidDeviceForAlertProcessData 2025-12-31 13:34:25.1827 AlertProcessor ProcessorAlertData: Stopped 2025-12-31 13:39:19.6067 AlertProcessor ProcessorAlertData: started 2025-12-31 13:39:25.0911 AlertProcessor ProcessorAlertData: Stopped 2025-12-31 13:44:16.0930 DFramework.Database.Query /* Time Taken: 509*/ [dbo].GenerateSystemAlerts 2025-12-31 13:44:19.6243 AlertProcessor ProcessorAlertData: started 2025-12-31 13:44:25.1556 AlertProcessor ProcessorAlertData: Stopped 2025-12-31 13:44:31.4994 DFramework.Scheduler.TaskBase /* Time Taken: 15906.352*/ Opportunity Out Of Stock By Outlet 2025-12-31 13:49:19.6426 AlertProcessor ProcessorAlertData: started 2025-12-31 13:49:25.1114 AlertProcessor ProcessorAlertData: Stopped 2025-12-31 13:54:19.6605 AlertProcessor ProcessorAlertData: started 2025-12-31 13:54:25.1292 AlertProcessor ProcessorAlertData: Stopped 2025-12-31 13:59:19.6781 AlertProcessor ProcessorAlertData: started 2025-12-31 13:59:25.3188 AlertProcessor ProcessorAlertData: Stopped 2025-12-31 13:59:31.4126 DFramework.Scheduler.TaskBase /* Time Taken: 15812.6129*/ Opportunity Out Of Stock By Outlet 2025-12-31 14:04:19.6960 AlertProcessor ProcessorAlertData: started 2025-12-31 14:04:22.4148 DFramework.Database.NullableDataReader Data reader open for 274 at System.Environment.GetStackTrace(Exception e, Boolean needFileInfo) at System.Environment.get_StackTrace() at DFramework.Database.NullableDataReader.Dispose(Boolean disposing) in D:\Spraxa\Framework\DFramework\Database\NullableDataReader.cs:line 33 at DFramework.Database.NullableDataReader.Dispose() in D:\Spraxa\Framework\DFramework\Database\NullableDataReader.cs:line 44 at CoolR.Tasks.ProcessAlertData.Execute() in D:\Spraxa\CoolR-Group\portal\CoolR.Tasks\ProcessAlertData.cs:line 47 at DFramework.Scheduler.TaskBase.Run() in D:\Spraxa\Framework\DFramework.Scheduler\TaskBase.cs:line 176 at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx) at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx) at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state) at System.Threading.ThreadHelper.ThreadStart() 2025-12-31 14:04:25.3992 AlertProcessor ProcessorAlertData: Stopped 2025-12-31 14:09:19.7140 AlertProcessor ProcessorAlertData: started 2025-12-31 14:09:25.2921 AlertProcessor ProcessorAlertData: Stopped 2025-12-31 14:14:16.1379 DFramework.Database.Query /* Time Taken: 542*/ [dbo].GenerateSystemAlerts 2025-12-31 14:14:19.7160 AlertProcessor ProcessorAlertData: started 2025-12-31 14:14:25.2473 AlertProcessor ProcessorAlertData: Stopped 2025-12-31 14:14:31.5755 DFramework.Scheduler.TaskBase /* Time Taken: 15968.8525*/ Opportunity Out Of Stock By Outlet 2025-12-31 14:19:19.7180 AlertProcessor ProcessorAlertData: started 2025-12-31 14:19:25.2806 AlertProcessor ProcessorAlertData: Stopped 2025-12-31 14:24:19.7207 AlertProcessor ProcessorAlertData: started 2025-12-31 14:24:25.3145 AlertProcessor ProcessorAlertData: Stopped 2025-12-31 14:29:19.7229 AlertProcessor ProcessorAlertData: started 2025-12-31 14:29:25.2230 AlertProcessor ProcessorAlertData: Stopped 2025-12-31 14:29:31.5511 DFramework.Scheduler.TaskBase /* Time Taken: 15921.9863*/ Opportunity Out Of Stock By Outlet 2025-12-31 14:34:19.7406 AlertProcessor ProcessorAlertData: started 2025-12-31 14:34:25.2406 AlertProcessor ProcessorAlertData: Stopped 2025-12-31 14:39:19.7587 AlertProcessor ProcessorAlertData: started 2025-12-31 14:39:25.2275 AlertProcessor ProcessorAlertData: Stopped 2025-12-31 14:44:16.1985 DFramework.Database.Query /* Time Taken: 557*/ [dbo].GenerateSystemAlerts 2025-12-31 14:44:19.7766 AlertProcessor ProcessorAlertData: started 2025-12-31 14:44:25.4016 AlertProcessor ProcessorAlertData: Stopped 2025-12-31 14:44:31.6204 DFramework.Scheduler.TaskBase /* Time Taken: 15968.8614*/ Opportunity Out Of Stock By Outlet 2025-12-31 14:49:19.7943 AlertProcessor ProcessorAlertData: started 2025-12-31 14:49:25.3412 AlertProcessor ProcessorAlertData: Stopped 2025-12-31 14:54:19.8121 AlertProcessor ProcessorAlertData: started 2025-12-31 14:54:25.2809 AlertProcessor ProcessorAlertData: Stopped 2025-12-31 14:59:16.2834 DFramework.Database.Query /* Time Taken: 624*/ [dbo].GenerateSystemAlerts 2025-12-31 14:59:19.8303 AlertProcessor ProcessorAlertData: started 2025-12-31 14:59:25.3616 AlertProcessor ProcessorAlertData: Stopped 2025-12-31 14:59:31.6273 DFramework.Scheduler.TaskBase /* Time Taken: 15953.247*/ Opportunity Out Of Stock By Outlet 2025-12-31 15:04:19.8481 AlertProcessor ProcessorAlertData: started 2025-12-31 15:04:25.3325 AlertProcessor ProcessorAlertData: Stopped 2025-12-31 15:09:19.8657 AlertProcessor ProcessorAlertData: started 2025-12-31 15:09:25.3345 AlertProcessor ProcessorAlertData: Stopped 2025-12-31 15:14:16.2120 DFramework.Database.Query /* Time Taken: 525*/ [dbo].GenerateSystemAlerts 2025-12-31 15:14:19.8839 AlertProcessor ProcessorAlertData: started 2025-12-31 15:14:25.3527 AlertProcessor ProcessorAlertData: Stopped 2025-12-31 15:14:31.5559 DFramework.Scheduler.TaskBase /* Time Taken: 15859.4986*/ Opportunity Out Of Stock By Outlet 2025-12-31 15:19:19.9018 AlertProcessor ProcessorAlertData: started 2025-12-31 15:19:25.4331 AlertProcessor ProcessorAlertData: Stopped 2025-12-31 15:24:19.9195 AlertProcessor ProcessorAlertData: started 2025-12-31 15:24:25.5758 DFramework.Database.Query /* Time Taken: 548*/ DECLARE @TableName AnsiString(8000) SET @TableName = 'ProductStockLevel' DECLARE @CurrentRecordId Int32 SET @CurrentRecordId = '3675443' dbo.GetValidDeviceForAlertProcessData 2025-12-31 15:24:25.6383 AlertProcessor ProcessorAlertData: Stopped 2025-12-31 15:29:19.9218 AlertProcessor ProcessorAlertData: started 2025-12-31 15:29:25.4374 AlertProcessor ProcessorAlertData: Stopped 2025-12-31 15:29:31.5156 DFramework.Scheduler.TaskBase /* Time Taken: 15797.0109*/ Opportunity Out Of Stock By Outlet 2025-12-31 15:34:19.9242 AlertProcessor ProcessorAlertData: started 2025-12-31 15:34:25.3930 AlertProcessor ProcessorAlertData: Stopped 2025-12-31 15:39:19.9419 AlertProcessor ProcessorAlertData: started 2025-12-31 15:39:25.4420 AlertProcessor ProcessorAlertData: Stopped 2025-12-31 15:44:16.2408 DFramework.Database.Query /* Time Taken: 507*/ [dbo].GenerateSystemAlerts 2025-12-31 15:44:19.9439 AlertProcessor ProcessorAlertData: started 2025-12-31 15:44:25.5846 AlertProcessor ProcessorAlertData: Stopped 2025-12-31 15:44:31.5534 DFramework.Scheduler.TaskBase /* Time Taken: 15812.6067*/ Opportunity Out Of Stock By Outlet 2025-12-31 15:49:19.9622 AlertProcessor ProcessorAlertData: started 2025-12-31 15:49:25.3060 AlertProcessor ProcessorAlertData: Stopped 2025-12-31 15:54:19.9800 AlertProcessor ProcessorAlertData: started 2025-12-31 15:54:25.4488 AlertProcessor ProcessorAlertData: Stopped 2025-12-31 15:59:16.3727 DFramework.Database.Query /* Time Taken: 613*/ [dbo].GenerateSystemAlerts 2025-12-31 15:59:19.9977 AlertProcessor ProcessorAlertData: started 2025-12-31 15:59:21.7321 DFramework.Database.Query /* Time Taken: 582*/ DECLARE @TableName AnsiString(8000) SET @TableName = 'AdditionalShelf' DECLARE @CurrentRecordId Int32 SET @CurrentRecordId = '3675443' dbo.GetValidDeviceForAlertProcessData 2025-12-31 15:59:25.5915 AlertProcessor ProcessorAlertData: Stopped 2025-12-31 15:59:31.6228 DFramework.Scheduler.TaskBase /* Time Taken: 15859.4831*/ Opportunity Out Of Stock By Outlet 2025-12-31 16:04:20.0158 AlertProcessor ProcessorAlertData: started 2025-12-31 16:04:25.5471 AlertProcessor ProcessorAlertData: Stopped 2025-12-31 16:09:20.0338 AlertProcessor ProcessorAlertData: started 2025-12-31 16:09:25.5025 AlertProcessor ProcessorAlertData: Stopped 2025-12-31 16:14:16.3015 DFramework.Database.Query /* Time Taken: 519*/ [dbo].GenerateSystemAlerts 2025-12-31 16:14:20.0358 AlertProcessor ProcessorAlertData: started 2025-12-31 16:14:25.4890 AlertProcessor ProcessorAlertData: Stopped 2025-12-31 16:14:31.6297 DFramework.Scheduler.TaskBase /* Time Taken: 15843.853*/ Opportunity Out Of Stock By Outlet 2025-12-31 16:19:20.0536 AlertProcessor ProcessorAlertData: started 2025-12-31 16:19:25.5380 AlertProcessor ProcessorAlertData: Stopped 2025-12-31 16:24:20.0717 AlertProcessor ProcessorAlertData: started 2025-12-31 16:24:25.4936 AlertProcessor ProcessorAlertData: Stopped 2025-12-31 16:29:16.3551 DFramework.Database.Query /* Time Taken: 558*/ [dbo].GenerateSystemAlerts 2025-12-31 16:29:20.0895 AlertProcessor ProcessorAlertData: started 2025-12-31 16:29:25.5114 AlertProcessor ProcessorAlertData: Stopped 2025-12-31 16:29:31.6365 DFramework.Scheduler.TaskBase /* Time Taken: 15828.229*/ Opportunity Out Of Stock By Outlet 2025-12-31 16:34:20.1072 AlertProcessor ProcessorAlertData: started 2025-12-31 16:34:22.1853 DFramework.Database.NullableDataReader Data reader open for 278 at System.Environment.GetStackTrace(Exception e, Boolean needFileInfo) at System.Environment.get_StackTrace() at DFramework.Database.NullableDataReader.Dispose(Boolean disposing) in D:\Spraxa\Framework\DFramework\Database\NullableDataReader.cs:line 33 at DFramework.Database.NullableDataReader.Dispose() in D:\Spraxa\Framework\DFramework\Database\NullableDataReader.cs:line 44 at CoolR.Tasks.ProcessAlertData.Execute() in D:\Spraxa\CoolR-Group\portal\CoolR.Tasks\ProcessAlertData.cs:line 47 at DFramework.Scheduler.TaskBase.Run() in D:\Spraxa\Framework\DFramework.Scheduler\TaskBase.cs:line 176 at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx) at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx) at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state) at System.Threading.ThreadHelper.ThreadStart() 2025-12-31 16:34:25.6385 AlertProcessor ProcessorAlertData: Stopped 2025-12-31 16:39:20.1254 AlertProcessor ProcessorAlertData: started 2025-12-31 16:39:25.5317 AlertProcessor ProcessorAlertData: Stopped 2025-12-31 16:44:20.1277 AlertProcessor ProcessorAlertData: started 2025-12-31 16:44:25.7371 AlertProcessor ProcessorAlertData: Stopped 2025-12-31 16:44:31.6903 DFramework.Scheduler.TaskBase /* Time Taken: 15859.4884*/ Opportunity Out Of Stock By Outlet 2025-12-31 16:49:20.1455 AlertProcessor ProcessorAlertData: started 2025-12-31 16:49:25.5830 AlertProcessor ProcessorAlertData: Stopped 2025-12-31 16:54:20.1634 AlertProcessor ProcessorAlertData: started 2025-12-31 16:54:25.6634 AlertProcessor ProcessorAlertData: Stopped 2025-12-31 16:59:16.4314 DFramework.Database.Query /* Time Taken: 580*/ [dbo].GenerateSystemAlerts 2025-12-31 16:59:20.1815 AlertProcessor ProcessorAlertData: started 2025-12-31 16:59:25.6815 AlertProcessor ProcessorAlertData: Stopped 2025-12-31 16:59:31.7440 DFramework.Scheduler.TaskBase /* Time Taken: 15890.7425*/ Opportunity Out Of Stock By Outlet 2025-12-31 17:04:20.1992 AlertProcessor ProcessorAlertData: started 2025-12-31 17:04:25.5899 AlertProcessor ProcessorAlertData: Stopped 2025-12-31 17:09:20.2169 AlertProcessor ProcessorAlertData: started 2025-12-31 17:09:25.6388 AlertProcessor ProcessorAlertData: Stopped 2025-12-31 17:14:20.2195 AlertProcessor ProcessorAlertData: started 2025-12-31 17:14:25.7351 AlertProcessor ProcessorAlertData: Stopped 2025-12-31 17:14:31.7664 DFramework.Scheduler.TaskBase /* Time Taken: 15890.7519*/ Opportunity Out Of Stock By Outlet 2025-12-31 17:19:20.2373 AlertProcessor ProcessorAlertData: started 2025-12-31 17:19:25.7530 AlertProcessor ProcessorAlertData: Stopped 2025-12-31 17:24:20.2550 AlertProcessor ProcessorAlertData: started 2025-12-31 17:24:25.7707 AlertProcessor ProcessorAlertData: Stopped 2025-12-31 17:29:16.4292 DFramework.Database.Query /* Time Taken: 543*/ [dbo].GenerateSystemAlerts 2025-12-31 17:29:20.2730 AlertProcessor ProcessorAlertData: started 2025-12-31 17:29:25.6012 AlertProcessor ProcessorAlertData: Stopped 2025-12-31 17:29:31.7731 DFramework.Scheduler.TaskBase /* Time Taken: 15875.1391*/ Opportunity Out Of Stock By Outlet 2025-12-31 17:34:20.2910 AlertProcessor ProcessorAlertData: started 2025-12-31 17:34:22.1348 DFramework.Database.NullableDataReader Data reader open for 274 at System.Environment.GetStackTrace(Exception e, Boolean needFileInfo) at System.Environment.get_StackTrace() at DFramework.Database.NullableDataReader.Dispose(Boolean disposing) in D:\Spraxa\Framework\DFramework\Database\NullableDataReader.cs:line 33 at DFramework.Database.NullableDataReader.Dispose() in D:\Spraxa\Framework\DFramework\Database\NullableDataReader.cs:line 44 at CoolR.Tasks.ProcessAlertData.Execute() in D:\Spraxa\CoolR-Group\portal\CoolR.Tasks\ProcessAlertData.cs:line 47 at DFramework.Scheduler.TaskBase.Run() in D:\Spraxa\Framework\DFramework.Scheduler\TaskBase.cs:line 176 at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx) at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx) at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state) at System.Threading.ThreadHelper.ThreadStart() 2025-12-31 17:34:25.9942 AlertProcessor ProcessorAlertData: Stopped 2025-12-31 17:39:20.3088 AlertProcessor ProcessorAlertData: started 2025-12-31 17:39:25.6994 AlertProcessor ProcessorAlertData: Stopped 2025-12-31 17:44:20.3109 AlertProcessor ProcessorAlertData: started 2025-12-31 17:44:25.7328 AlertProcessor ProcessorAlertData: Stopped 2025-12-31 17:44:31.8110 DFramework.Scheduler.TaskBase /* Time Taken: 15890.7767*/ Opportunity Out Of Stock By Outlet 2025-12-31 17:49:20.3133 AlertProcessor ProcessorAlertData: started 2025-12-31 17:49:25.7352 AlertProcessor ProcessorAlertData: Stopped 2025-12-31 17:54:20.3155 AlertProcessor ProcessorAlertData: started 2025-12-31 17:54:25.7530 AlertProcessor ProcessorAlertData: Stopped 2025-12-31 17:59:16.4894 DFramework.Database.Query /* Time Taken: 549*/ [dbo].GenerateSystemAlerts 2025-12-31 17:59:20.3175 AlertProcessor ProcessorAlertData: started 2025-12-31 17:59:25.7082 AlertProcessor ProcessorAlertData: Stopped 2025-12-31 17:59:31.8020 DFramework.Scheduler.TaskBase /* Time Taken: 15859.4955*/ Opportunity Out Of Stock By Outlet 2025-12-31 18:04:20.3358 AlertProcessor ProcessorAlertData: started 2025-12-31 18:04:25.7264 AlertProcessor ProcessorAlertData: Stopped 2025-12-31 18:09:20.3538 AlertProcessor ProcessorAlertData: started 2025-12-31 18:09:23.3069 DFramework.Database.Query /* Time Taken: 513*/ DECLARE @TableName AnsiString(8000) SET @TableName = 'AssetStockProductWiseConsolidate' DECLARE @CurrentRecordId Int32 SET @CurrentRecordId = '3675443' dbo.GetValidDeviceForAlertProcessData 2025-12-31 18:09:25.8226 AlertProcessor ProcessorAlertData: Stopped 2025-12-31 18:14:20.3715 AlertProcessor ProcessorAlertData: started 2025-12-31 18:14:25.6997 AlertProcessor ProcessorAlertData: Stopped 2025-12-31 18:14:31.8404 DFramework.Scheduler.TaskBase /* Time Taken: 15875.0974*/ Opportunity Out Of Stock By Outlet 2025-12-31 18:19:20.3893 AlertProcessor ProcessorAlertData: started 2025-12-31 18:19:21.7330 DFramework.Database.Query /* Time Taken: 653*/ DECLARE @TableName AnsiString(8000) SET @TableName = 'MissingShelf' DECLARE @CurrentRecordId Int32 SET @CurrentRecordId = '3675443' dbo.GetValidDeviceForAlertProcessData 2025-12-31 18:19:26.1550 AlertProcessor ProcessorAlertData: Stopped 2025-12-31 18:24:20.4071 AlertProcessor ProcessorAlertData: started 2025-12-31 18:24:25.9540 AlertProcessor ProcessorAlertData: Stopped 2025-12-31 18:29:16.5342 DFramework.Database.Query /* Time Taken: 550*/ [dbo].GenerateSystemAlerts 2025-12-31 18:29:20.4248 AlertProcessor ProcessorAlertData: started 2025-12-31 18:29:26.0655 AlertProcessor ProcessorAlertData: Stopped 2025-12-31 18:29:31.8468 DFramework.Scheduler.TaskBase /* Time Taken: 15859.4837*/ Opportunity Out Of Stock By Outlet 2025-12-31 18:34:17.0675 MoveToReorder Running task for ClientId : 286 and ClientName = India Office QA and Slot: 1/1/2026 8:00:00 AM And LastExecutedOn: 12/31/2025 10:04:16 PM 2025-12-31 18:34:20.4425 AlertProcessor ProcessorAlertData: started 2025-12-31 18:34:26.0363 AlertProcessor ProcessorAlertData: Stopped 2025-12-31 18:34:56.5209 DFramework.Database.NullableDataReader Data reader open for 39087 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-31 18:34:56.5521 MoveToReorder Task executed successfully for ClientId : 286 Client Name:India Office QA, Slot: 1/1/2026 8:00:00 AM and Total Order Suggested: 125 Out Of: 125 2025-12-31 18:34:58.0052 DFramework.Scheduler.TaskBase /* Time Taken: 41250.2755*/ Move To Re-Order 2025-12-31 18:39:20.4606 AlertProcessor ProcessorAlertData: started 2025-12-31 18:39:25.8200 AlertProcessor ProcessorAlertData: Stopped 2025-12-31 18:44:16.5409 DFramework.Database.Query /* Time Taken: 536*/ [dbo].GenerateSystemAlerts 2025-12-31 18:44:20.4784 AlertProcessor ProcessorAlertData: started 2025-12-31 18:44:26.0097 AlertProcessor ProcessorAlertData: Stopped 2025-12-31 18:44:32.0254 DFramework.Scheduler.TaskBase /* Time Taken: 16015.7354*/ Opportunity Out Of Stock By Outlet 2025-12-31 18:49:20.4962 AlertProcessor ProcessorAlertData: started 2025-12-31 18:49:24.9649 DFramework.Database.NullableDataReader Data reader open for 273 at System.Environment.GetStackTrace(Exception e, Boolean needFileInfo) at System.Environment.get_StackTrace() at DFramework.Database.NullableDataReader.Dispose(Boolean disposing) in D:\Spraxa\Framework\DFramework\Database\NullableDataReader.cs:line 33 at DFramework.Database.NullableDataReader.Dispose() in D:\Spraxa\Framework\DFramework\Database\NullableDataReader.cs:line 44 at CoolR.Tasks.ProcessAlertData.Execute() in D:\Spraxa\CoolR-Group\portal\CoolR.Tasks\ProcessAlertData.cs:line 47 at DFramework.Scheduler.TaskBase.Run() in D:\Spraxa\Framework\DFramework.Scheduler\TaskBase.cs:line 176 at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx) at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx) at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state) at System.Threading.ThreadHelper.ThreadStart() 2025-12-31 18:49:25.9962 AlertProcessor ProcessorAlertData: Stopped 2025-12-31 18:54:20.5141 AlertProcessor ProcessorAlertData: started 2025-12-31 18:54:25.8891 DFramework.Database.Query /* Time Taken: 503*/ DECLARE @TableName AnsiString(8000) SET @TableName = 'ProductStockLevel' DECLARE @CurrentRecordId Int32 SET @CurrentRecordId = '3675443' dbo.GetValidDeviceForAlertProcessData 2025-12-31 18:54:25.9360 AlertProcessor ProcessorAlertData: Stopped 2025-12-31 18:59:16.5945 DFramework.Database.Query /* Time Taken: 576*/ [dbo].GenerateSystemAlerts 2025-12-31 18:59:20.5320 AlertProcessor ProcessorAlertData: started 2025-12-31 18:59:25.9539 AlertProcessor ProcessorAlertData: Stopped 2025-12-31 18:59:31.9227 DFramework.Scheduler.TaskBase /* Time Taken: 15890.7423*/ Opportunity Out Of Stock By Outlet 2025-12-31 19:04:20.5497 AlertProcessor ProcessorAlertData: started 2025-12-31 19:04:25.9248 AlertProcessor ProcessorAlertData: Stopped 2025-12-31 19:09:20.5674 AlertProcessor ProcessorAlertData: started 2025-12-31 19:09:25.9894 AlertProcessor ProcessorAlertData: Stopped 2025-12-31 19:14:20.5855 AlertProcessor ProcessorAlertData: started 2025-12-31 19:14:26.1168 AlertProcessor ProcessorAlertData: Stopped 2025-12-31 19:14:31.9606 DFramework.Scheduler.TaskBase /* Time Taken: 15906.3647*/ Opportunity Out Of Stock By Outlet 2025-12-31 19:19:20.6033 AlertProcessor ProcessorAlertData: started 2025-12-31 19:19:26.1190 AlertProcessor ProcessorAlertData: Stopped 2025-12-31 19:24:20.6210 AlertProcessor ProcessorAlertData: started 2025-12-31 19:24:25.7773 DFramework.Database.NullableDataReader Data reader open for 278 at System.Environment.GetStackTrace(Exception e, Boolean needFileInfo) at System.Environment.get_StackTrace() at DFramework.Database.NullableDataReader.Dispose(Boolean disposing) in D:\Spraxa\Framework\DFramework\Database\NullableDataReader.cs:line 33 at DFramework.Database.NullableDataReader.Dispose() in D:\Spraxa\Framework\DFramework\Database\NullableDataReader.cs:line 44 at CoolR.Tasks.ProcessAlertData.Execute() in D:\Spraxa\CoolR-Group\portal\CoolR.Tasks\ProcessAlertData.cs:line 47 at DFramework.Scheduler.TaskBase.Run() in D:\Spraxa\Framework\DFramework.Scheduler\TaskBase.cs:line 176 at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx) at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx) at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state) at System.Threading.ThreadHelper.ThreadStart() 2025-12-31 19:24:26.2617 AlertProcessor ProcessorAlertData: Stopped 2025-12-31 19:29:16.6389 DFramework.Database.Query /* Time Taken: 572*/ [dbo].GenerateSystemAlerts 2025-12-31 19:29:20.6390 AlertProcessor ProcessorAlertData: started 2025-12-31 19:29:25.9828 AlertProcessor ProcessorAlertData: Stopped 2025-12-31 19:29:32.0141 DFramework.Scheduler.TaskBase /* Time Taken: 15937.6192*/ Opportunity Out Of Stock By Outlet 2025-12-31 19:34:17.1724 MoveToReorder Running task for ClientId : 286 and ClientName = India Office QA and Slot: 1/1/2026 9:00:00 AM And LastExecutedOn: 1/1/2026 8:04:17 AM 2025-12-31 19:34:17.3912 MoveToReorder Task executed successfully for ClientId : 286 Client Name:India Office QA, Slot: 1/1/2026 9:00:00 AM But No Order found to suggest 2025-12-31 19:34:20.6568 AlertProcessor ProcessorAlertData: started 2025-12-31 19:34:26.0631 AlertProcessor ProcessorAlertData: Stopped 2025-12-31 19:39:20.6745 AlertProcessor ProcessorAlertData: started 2025-12-31 19:39:26.0496 AlertProcessor ProcessorAlertData: Stopped 2025-12-31 19:44:16.5986 DFramework.Database.Query /* Time Taken: 501*/ [dbo].GenerateSystemAlerts 2025-12-31 19:44:20.6923 AlertProcessor ProcessorAlertData: started 2025-12-31 19:44:26.2549 AlertProcessor ProcessorAlertData: Stopped 2025-12-31 19:44:31.9268 DFramework.Scheduler.TaskBase /* Time Taken: 15828.2793*/ Opportunity Out Of Stock By Outlet 2025-12-31 19:49:20.7104 AlertProcessor ProcessorAlertData: started 2025-12-31 19:49:25.0229 DFramework.Database.NullableDataReader Data reader open for 271 at System.Environment.GetStackTrace(Exception e, Boolean needFileInfo) at System.Environment.get_StackTrace() at DFramework.Database.NullableDataReader.Dispose(Boolean disposing) in 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-31 19:49:26.3823 AlertProcessor ProcessorAlertData: Stopped 2025-12-31 19:54:20.7282 AlertProcessor ProcessorAlertData: started 2025-12-31 19:54:26.1501 AlertProcessor ProcessorAlertData: Stopped 2025-12-31 19:59:16.6990 DFramework.Database.Query /* Time Taken: 579*/ [dbo].GenerateSystemAlerts 2025-12-31 19:59:20.7459 AlertProcessor ProcessorAlertData: started 2025-12-31 19:59:26.3397 AlertProcessor ProcessorAlertData: Stopped 2025-12-31 19:59:31.9647 DFramework.Scheduler.TaskBase /* Time Taken: 15843.8584*/ Opportunity Out Of Stock By Outlet 2025-12-31 20:04:20.7640 AlertProcessor ProcessorAlertData: started 2025-12-31 20:04:26.2484 AlertProcessor ProcessorAlertData: Stopped 2025-12-31 20:09:20.7819 AlertProcessor ProcessorAlertData: started 2025-12-31 20:09:26.3444 AlertProcessor ProcessorAlertData: Stopped 2025-12-31 20:14:16.6590 DFramework.Database.Query /* Time Taken: 524*/ [dbo].GenerateSystemAlerts 2025-12-31 20:14:20.7996 AlertProcessor ProcessorAlertData: started 2025-12-31 20:14:26.2528 AlertProcessor ProcessorAlertData: Stopped 2025-12-31 20:14:32.0028 DFramework.Scheduler.TaskBase /* Time Taken: 15859.4847*/ Opportunity Out Of Stock By Outlet 2025-12-31 20:19:20.8174 AlertProcessor ProcessorAlertData: started 2025-12-31 20:19:26.3487 AlertProcessor ProcessorAlertData: Stopped 2025-12-31 20:24:20.8353 AlertProcessor ProcessorAlertData: started 2025-12-31 20:24:26.2572 AlertProcessor ProcessorAlertData: Stopped 2025-12-31 20:29:16.7123 DFramework.Database.Query /* Time Taken: 561*/ [dbo].GenerateSystemAlerts 2025-12-31 20:29:20.8530 AlertProcessor ProcessorAlertData: started 2025-12-31 20:29:26.2905 AlertProcessor ProcessorAlertData: Stopped 2025-12-31 20:29:31.9624 DFramework.Scheduler.TaskBase /* Time Taken: 15796.9826*/ Opportunity Out Of Stock By Outlet 2025-12-31 20:34:17.2613 MoveToReorder Running task for ClientId : 286 and ClientName = India Office QA and Slot: 1/1/2026 10:00:00 AM And LastExecutedOn: 1/1/2026 9:04:17 AM 2025-12-31 20:34:17.4801 MoveToReorder Task executed successfully for ClientId : 286 Client Name:India Office QA, Slot: 1/1/2026 10:00:00 AM But No Order found to suggest 2025-12-31 20:34:20.8707 AlertProcessor ProcessorAlertData: started 2025-12-31 20:34:21.5113 DFramework.Database.Query /* Time Taken: 583*/ DECLARE AlertTypeIds Object SET AlertTypeIds = 'DFramework.Database.Adapters.SQL+d__24' [dbo].GetAlertSummaryData 2025-12-31 20:34:26.4176 DFramework.Database.Query /* Time Taken: 579*/ DECLARE @TableName AnsiString(8000) SET @TableName = 'ProductStockLevel' DECLARE @CurrentRecordId Int32 SET @CurrentRecordId = '3675443' dbo.GetValidDeviceForAlertProcessData 2025-12-31 20:34:26.4333 DFramework.Database.Query /* Time Taken: 4915*/ DECLARE @AlertTypeIds AnsiString(8000) SET @AlertTypeIds = '46,37,59,73,57' DECLARE @ClientIds AnsiString(8000) SET @ClientIds = '213,286,1494,114,180,183,299,300,314,316,331,332,333,349,415,451,296,301,303,305,328,335,337,360,385,421,469,471,1480,1496,207,224,291,306,308,325,342,70,134,188,227,295,320,336,338,395,452' DECLARE @StatusId Int32 SET @StatusId = '1' SELECT ClientName, AlertType, AlertText, Location.Name AS [Location], Location.Code AS LocationCode, Asset.SerialNumber AS AssetSerialNumber, COALESCE(SmartDevice.SerialNumber, SD.SerialNumber) AS SmartDeviceSerial, AlertAt, AccountCoordinators.PrimaryEmail AS AccountCoordinator, AccountDirectors.PrimaryEmail AS AccountDirector, Alert.ClientId FROM Alert LEFT OUTER JOIN Client ON Client.ClientId = Alert.ClientId LEFT OUTER JOIN AlertType ON AlertType.AlertTypeId = Alert.AlertTypeId LEFT OUTER JOIN Location ON Location.LocationId = Alert.LocationId LEFT OUTER JOIN Asset ON Asset.AssetId = Alert.AssetId LEFT OUTER JOIN SmartDevice ON SmartDevice.SmartDeviceId = Alert.SmartDeviceId AND SmartDevice.IsGatewayDevice = 0 LEFT OUTER JOIN vwSmartDeviceExceptSmartHubList AS SD ON dbo.Alert.AssetId = SD.LinkedAssetId AND SD.LinkedAssetId <> 0 LEFT OUTER JOIN dbo.Security_User AS AccountDirectors ON Client.AccountDirectorId = AccountDirectors.UserId AND AccountDirectors.IsDeleted = 0 LEFT OUTER JOIN dbo.Security_User AS AccountCoordinators ON Client.AccountCoordinatorId = AccountCoordinators.UserId AND AccountCoordinators.IsDeleted = 0 WHERE Alert.IsDeleted = 0 AND Alert.AlertTypeId IN (SELECT * FROM CsvToInt(@AlertTypeIds)) AND Alert.ClientId IN (SELECT * FROM CsvToInt(@ClientIds)) AND Alert.StatusId = @StatusId ORDER BY Alert.ClientId 2025-12-31 20:34:26.4801 AlertProcessor ProcessorAlertData: Stopped 2025-12-31 20:39:20.8890 AlertProcessor ProcessorAlertData: started 2025-12-31 20:39:26.3734 AlertProcessor ProcessorAlertData: Stopped 2025-12-31 20:44:20.9069 AlertProcessor ProcessorAlertData: started 2025-12-31 20:44:26.4226 AlertProcessor ProcessorAlertData: Stopped 2025-12-31 20:44:31.9851 DFramework.Scheduler.TaskBase /* Time Taken: 15796.9886*/ Opportunity Out Of Stock By Outlet 2025-12-31 20:49:20.9247 AlertProcessor ProcessorAlertData: started 2025-12-31 20:49:26.3310 AlertProcessor ProcessorAlertData: Stopped 2025-12-31 20:54:20.9426 AlertProcessor ProcessorAlertData: started 2025-12-31 20:54:26.3802 AlertProcessor ProcessorAlertData: Stopped 2025-12-31 20:59:20.9450 AlertProcessor ProcessorAlertData: started 2025-12-31 20:59:26.5388 AlertProcessor ProcessorAlertData: Stopped 2025-12-31 20:59:32.0544 DFramework.Scheduler.TaskBase /* Time Taken: 15843.8658*/ Opportunity Out Of Stock By Outlet 2025-12-31 21:04:20.9471 AlertProcessor ProcessorAlertData: started 2025-12-31 21:04:26.3846 AlertProcessor ProcessorAlertData: Stopped 2025-12-31 21:09:20.9649 AlertProcessor ProcessorAlertData: started 2025-12-31 21:09:26.3399 AlertProcessor ProcessorAlertData: Stopped 2025-12-31 21:14:16.7486 DFramework.Database.Query /* Time Taken: 528*/ [dbo].GenerateSystemAlerts 2025-12-31 21:14:20.9830 AlertProcessor ProcessorAlertData: started 2025-12-31 21:14:26.5768 AlertProcessor ProcessorAlertData: Stopped 2025-12-31 21:14:32.1393 DFramework.Scheduler.TaskBase /* Time Taken: 15906.364*/ Opportunity Out Of Stock By Outlet 2025-12-31 21:19:21.0008 AlertProcessor ProcessorAlertData: started 2025-12-31 21:19:26.5165 AlertProcessor ProcessorAlertData: Stopped 2025-12-31 21:24:21.0185 AlertProcessor ProcessorAlertData: started 2025-12-31 21:24:26.4092 AlertProcessor ProcessorAlertData: Stopped 2025-12-31 21:29:16.7553 DFramework.Database.Query /* Time Taken: 501*/ [dbo].GenerateSystemAlerts 2025-12-31 21:29:21.0366 AlertProcessor ProcessorAlertData: started 2025-12-31 21:29:26.5367 AlertProcessor ProcessorAlertData: Stopped 2025-12-31 21:29:32.1148 DFramework.Scheduler.TaskBase /* Time Taken: 15859.5044*/ Opportunity Out Of Stock By Outlet 2025-12-31 21:34:17.3201 MoveToReorder Running task for ClientId : 286 and ClientName = India Office QA and Slot: 1/1/2026 11:00:00 AM And LastExecutedOn: 1/1/2026 10:04:17 AM 2025-12-31 21:34:21.0545 AlertProcessor ProcessorAlertData: started 2025-12-31 21:34:26.6640 DFramework.Database.Query /* Time Taken: 511*/ DECLARE @TableName AnsiString(8000) SET @TableName = 'ProductStockLevel' DECLARE @CurrentRecordId Int32 SET @CurrentRecordId = '3675443' dbo.GetValidDeviceForAlertProcessData 2025-12-31 21:34:26.7264 AlertProcessor ProcessorAlertData: Stopped 2025-12-31 21:34:56.4767 DFramework.Database.NullableDataReader Data reader open for 38917 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-31 21:34:56.5079 MoveToReorder Task executed successfully for ClientId : 286 Client Name:India Office QA, Slot: 1/1/2026 11:00:00 AM and Total Order Suggested: 124 Out Of: 124 2025-12-31 21:34:57.5704 DFramework.Scheduler.TaskBase /* Time Taken: 40562.7984*/ Move To Re-Order 2025-12-31 21:39:21.0723 AlertProcessor ProcessorAlertData: started 2025-12-31 21:39:26.6192 AlertProcessor ProcessorAlertData: Stopped 2025-12-31 21:44:21.0902 AlertProcessor ProcessorAlertData: started 2025-12-31 21:44:26.7153 AlertProcessor ProcessorAlertData: Stopped 2025-12-31 21:44:32.1528 DFramework.Scheduler.TaskBase /* Time Taken: 15875.1606*/ Opportunity Out Of Stock By Outlet 2025-12-31 21:49:21.1082 AlertProcessor ProcessorAlertData: started 2025-12-31 21:49:26.5927 AlertProcessor ProcessorAlertData: Stopped 2025-12-31 21:54:21.1260 AlertProcessor ProcessorAlertData: started 2025-12-31 21:54:26.6261 AlertProcessor ProcessorAlertData: Stopped 2025-12-31 21:59:16.8313 DFramework.Database.Query /* Time Taken: 541*/ [dbo].GenerateSystemAlerts 2025-12-31 21:59:21.1438 AlertProcessor ProcessorAlertData: started 2025-12-31 21:59:26.7220 AlertProcessor ProcessorAlertData: Stopped 2025-12-31 21:59:32.2220 DFramework.Scheduler.TaskBase /* Time Taken: 15921.9818*/ Opportunity Out Of Stock By Outlet 2025-12-31 22:04:21.1620 AlertProcessor ProcessorAlertData: started 2025-12-31 22:04:26.7089 AlertProcessor ProcessorAlertData: Stopped 2025-12-31 22:09:21.1799 AlertProcessor ProcessorAlertData: started 2025-12-31 22:09:26.6330 DFramework.Database.Query /* Time Taken: 574*/ DECLARE @TableName AnsiString(8000) SET @TableName = 'ProductStockLevel' DECLARE @CurrentRecordId Int32 SET @CurrentRecordId = '3675443' dbo.GetValidDeviceForAlertProcessData 2025-12-31 22:09:26.6955 AlertProcessor ProcessorAlertData: Stopped 2025-12-31 22:14:21.1977 AlertProcessor ProcessorAlertData: started 2025-12-31 22:14:26.7133 AlertProcessor ProcessorAlertData: Stopped 2025-12-31 22:14:32.2289 DFramework.Scheduler.TaskBase /* Time Taken: 15921.9882*/ Opportunity Out Of Stock By Outlet 2025-12-31 22:19:21.1999 AlertProcessor ProcessorAlertData: started 2025-12-31 22:19:24.1843 DFramework.Database.Query /* Time Taken: 515*/ DECLARE @TableName AnsiString(8000) SET @TableName = 'AssetStockProductWiseConsolidate' DECLARE @CurrentRecordId Int32 SET @CurrentRecordId = '3675443' dbo.GetValidDeviceForAlertProcessData 2025-12-31 22:19:26.7312 AlertProcessor ProcessorAlertData: Stopped 2025-12-31 22:24:21.2022 AlertProcessor ProcessorAlertData: started 2025-12-31 22:24:26.6085 AlertProcessor ProcessorAlertData: Stopped 2025-12-31 22:29:21.2199 AlertProcessor ProcessorAlertData: started 2025-12-31 22:29:26.7043 AlertProcessor ProcessorAlertData: Stopped 2025-12-31 22:29:32.1263 DFramework.Scheduler.TaskBase /* Time Taken: 15812.6107*/ Opportunity Out Of Stock By Outlet 2025-12-31 22:34:17.4252 MoveToReorder Running task for ClientId : 286 and ClientName = India Office QA and Slot: 1/1/2026 12:00:00 PM And LastExecutedOn: 1/1/2026 11:04:17 AM 2025-12-31 22:34:17.6283 MoveToReorder Task executed successfully for ClientId : 286 Client Name:India Office QA, Slot: 1/1/2026 12:00:00 PM But No Order found to suggest 2025-12-31 22:34:21.2377 AlertProcessor ProcessorAlertData: started 2025-12-31 22:34:26.8627 AlertProcessor ProcessorAlertData: Stopped 2025-12-31 22:39:21.2559 AlertProcessor ProcessorAlertData: started 2025-12-31 22:39:26.9122 AlertProcessor ProcessorAlertData: Stopped 2025-12-31 22:44:21.2738 AlertProcessor ProcessorAlertData: started 2025-12-31 22:44:26.7582 AlertProcessor ProcessorAlertData: Stopped 2025-12-31 22:44:32.1333 DFramework.Scheduler.TaskBase /* Time Taken: 15812.6121*/ Opportunity Out Of Stock By Outlet 2025-12-31 22:49:21.2916 AlertProcessor ProcessorAlertData: started 2025-12-31 22:49:26.7135 AlertProcessor ProcessorAlertData: Stopped 2025-12-31 22:54:21.2939 AlertProcessor ProcessorAlertData: started 2025-12-31 22:54:26.7315 AlertProcessor ProcessorAlertData: Stopped 2025-12-31 22:59:21.2962 AlertProcessor ProcessorAlertData: started 2025-12-31 22:59:23.3743 DFramework.Database.NullableDataReader Data reader open for 203 at System.Environment.GetStackTrace(Exception e, Boolean needFileInfo) at System.Environment.get_StackTrace() at DFramework.Database.NullableDataReader.Dispose(Boolean disposing) in D:\Spraxa\Framework\DFramework\Database\NullableDataReader.cs:line 33 at DFramework.Database.NullableDataReader.Dispose() in D:\Spraxa\Framework\DFramework\Database\NullableDataReader.cs:line 44 at CoolR.Tasks.ProcessAlertData.Execute() in D:\Spraxa\CoolR-Group\portal\CoolR.Tasks\ProcessAlertData.cs:line 47 at DFramework.Scheduler.TaskBase.Run() in D:\Spraxa\Framework\DFramework.Scheduler\TaskBase.cs:line 176 at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx) at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx) at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state) at System.Threading.ThreadHelper.ThreadStart() 2025-12-31 22:59:23.4368 DFramework.Database.NullableDataReader Data reader open for 288 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-31 22:59:23.9837 DFramework.Database.NullableDataReader Data reader open for 272 at System.Environment.GetStackTrace(Exception e, Boolean needFileInfo) at System.Environment.get_StackTrace() at DFramework.Database.NullableDataReader.Dispose(Boolean disposing) in 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-31 22:59:24.0306 DFramework.Database.NullableDataReader Data reader open for 355 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-31 22:59:24.7025 DFramework.Database.NullableDataReader Data reader open for 392 at System.Environment.GetStackTrace(Exception e, Boolean needFileInfo) at System.Environment.get_StackTrace() at DFramework.Database.NullableDataReader.Dispose(Boolean disposing) in D:\Spraxa\Framework\DFramework\Database\NullableDataReader.cs:line 33 at DFramework.Database.NullableDataReader.Dispose() in D:\Spraxa\Framework\DFramework\Database\NullableDataReader.cs:line 44 at CoolR.Tasks.ProcessAlertData.Execute() in D:\Spraxa\CoolR-Group\portal\CoolR.Tasks\ProcessAlertData.cs:line 47 at DFramework.Scheduler.TaskBase.Run() in D:\Spraxa\Framework\DFramework.Scheduler\TaskBase.cs:line 176 at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx) at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx) at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state) at System.Threading.ThreadHelper.ThreadStart() 2025-12-31 22:59:24.7494 DFramework.Database.NullableDataReader Data reader open for 476 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-31 22:59:25.7025 DFramework.Database.NullableDataReader Data reader open for 225 at System.Environment.GetStackTrace(Exception e, Boolean needFileInfo) at System.Environment.get_StackTrace() at DFramework.Database.NullableDataReader.Dispose(Boolean disposing) in 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-31 22:59:26.0306 AlertProcessor Replace Tags updated for the Image Id: 3675457 2025-12-31 22:59:26.1713 DFramework.Database.NullableDataReader Data reader open for 232 at System.Environment.GetStackTrace(Exception e, Boolean needFileInfo) at System.Environment.get_StackTrace() at DFramework.Database.NullableDataReader.Dispose(Boolean disposing) in 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-31 22:59:26.7963 DFramework.Database.NullableDataReader Data reader open for 364 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-31 22:59:26.8587 DFramework.Database.NullableDataReader Data reader open for 449 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-31 22:59:27.6400 DFramework.Database.NullableDataReader Data reader open for 222 at System.Environment.GetStackTrace(Exception e, Boolean needFileInfo) at System.Environment.get_StackTrace() at DFramework.Database.NullableDataReader.Dispose(Boolean disposing) in D:\Spraxa\Framework\DFramework\Database\NullableDataReader.cs:line 33 at DFramework.Database.NullableDataReader.Dispose() in D:\Spraxa\Framework\DFramework\Database\NullableDataReader.cs:line 44 at CoolR.Tasks.ProcessAlertData.Execute() in D:\Spraxa\CoolR-Group\portal\CoolR.Tasks\ProcessAlertData.cs:line 47 at DFramework.Scheduler.TaskBase.Run() in D:\Spraxa\Framework\DFramework.Scheduler\TaskBase.cs:line 176 at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx) at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx) at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state) at System.Threading.ThreadHelper.ThreadStart() 2025-12-31 22:59:28.4838 DFramework.Database.NullableDataReader Data reader open for 237 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-31 22:59:28.5306 DFramework.Database.NullableDataReader Data reader open for 322 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-31 22:59:29.0619 AlertProcessor ProcessorAlertData: Stopped 2025-12-31 22:59:32.1869 DFramework.Scheduler.TaskBase /* Time Taken: 15843.8645*/ Opportunity Out Of Stock By Outlet 2025-12-31 23:04:21.3140 AlertProcessor ProcessorAlertData: started 2025-12-31 23:04:26.8140 AlertProcessor ProcessorAlertData: Stopped 2025-12-31 23:09:21.3318 AlertProcessor ProcessorAlertData: started 2025-12-31 23:09:23.5194 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-31 23:09:24.1131 DFramework.Database.NullableDataReader Data reader open for 322 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-31 23:09:24.1600 DFramework.Database.NullableDataReader Data reader open for 405 at System.Environment.GetStackTrace(Exception e, Boolean needFileInfo) at System.Environment.get_StackTrace() at DFramework.Database.NullableDataReader.Dispose(Boolean disposing) in 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-31 23:09:24.8475 DFramework.Database.NullableDataReader Data reader open for 412 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-31 23:09:24.9100 DFramework.Database.NullableDataReader Data reader open for 495 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-31 23:09:25.8475 DFramework.Database.NullableDataReader Data reader open for 222 at System.Environment.GetStackTrace(Exception e, Boolean needFileInfo) at System.Environment.get_StackTrace() at DFramework.Database.NullableDataReader.Dispose(Boolean disposing) in D:\Spraxa\Framework\DFramework\Database\NullableDataReader.cs:line 33 at DFramework.Database.NullableDataReader.Dispose() in D:\Spraxa\Framework\DFramework\Database\NullableDataReader.cs:line 44 at CoolR.Tasks.ProcessAlertData.Execute() in D:\Spraxa\CoolR-Group\portal\CoolR.Tasks\ProcessAlertData.cs:line 47 at DFramework.Scheduler.TaskBase.Run() in D:\Spraxa\Framework\DFramework.Scheduler\TaskBase.cs:line 176 at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx) at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx) at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state) at System.Threading.ThreadHelper.ThreadStart() 2025-12-31 23:09:26.1600 AlertProcessor Replace Tags updated for the Image Id: 3675459 2025-12-31 23:09:26.3475 DFramework.Database.NullableDataReader Data reader open for 259 at System.Environment.GetStackTrace(Exception e, Boolean needFileInfo) at System.Environment.get_StackTrace() at DFramework.Database.NullableDataReader.Dispose(Boolean disposing) in 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-31 23:09:26.9569 DFramework.Database.NullableDataReader Data reader open for 353 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-31 23:09:27.0038 DFramework.Database.NullableDataReader Data reader open for 435 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-31 23:09:27.8006 DFramework.Database.NullableDataReader Data reader open for 221 at System.Environment.GetStackTrace(Exception e, Boolean needFileInfo) at System.Environment.get_StackTrace() at DFramework.Database.NullableDataReader.Dispose(Boolean disposing) in D:\Spraxa\Framework\DFramework\Database\NullableDataReader.cs:line 33 at DFramework.Database.NullableDataReader.Dispose() in D:\Spraxa\Framework\DFramework\Database\NullableDataReader.cs:line 44 at CoolR.Tasks.ProcessAlertData.Execute() in D:\Spraxa\CoolR-Group\portal\CoolR.Tasks\ProcessAlertData.cs:line 47 at DFramework.Scheduler.TaskBase.Run() in D:\Spraxa\Framework\DFramework.Scheduler\TaskBase.cs:line 176 at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx) at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx) at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state) at System.Threading.ThreadHelper.ThreadStart() 2025-12-31 23:09:28.6756 DFramework.Database.NullableDataReader Data reader open for 292 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-31 23:09:28.7225 DFramework.Database.NullableDataReader Data reader open for 376 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-31 23:09:29.2538 AlertProcessor ProcessorAlertData: Stopped 2025-12-31 23:14:21.3499 AlertProcessor ProcessorAlertData: started 2025-12-31 23:14:23.5843 DFramework.Database.NullableDataReader Data reader open for 278 at System.Environment.GetStackTrace(Exception e, Boolean needFileInfo) at System.Environment.get_StackTrace() at DFramework.Database.NullableDataReader.Dispose(Boolean disposing) in D:\Spraxa\Framework\DFramework\Database\NullableDataReader.cs:line 33 at DFramework.Database.NullableDataReader.Dispose() in D:\Spraxa\Framework\DFramework\Database\NullableDataReader.cs:line 44 at CoolR.Tasks.ProcessAlertData.Execute() in D:\Spraxa\CoolR-Group\portal\CoolR.Tasks\ProcessAlertData.cs:line 47 at DFramework.Scheduler.TaskBase.Run() in D:\Spraxa\Framework\DFramework.Scheduler\TaskBase.cs:line 176 at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx) at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx) at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state) at System.Threading.ThreadHelper.ThreadStart() 2025-12-31 23:14:24.0999 DFramework.Database.NullableDataReader Data reader open for 255 at System.Environment.GetStackTrace(Exception e, Boolean needFileInfo) at System.Environment.get_StackTrace() at DFramework.Database.NullableDataReader.Dispose(Boolean disposing) in D:\Spraxa\Framework\DFramework\Database\NullableDataReader.cs:line 33 at DFramework.Database.NullableDataReader.Dispose() in D:\Spraxa\Framework\DFramework\Database\NullableDataReader.cs:line 44 at CoolR.Tasks.ProcessAlertData.Execute() in D:\Spraxa\CoolR-Group\portal\CoolR.Tasks\ProcessAlertData.cs:line 47 at DFramework.Scheduler.TaskBase.Run() in D:\Spraxa\Framework\DFramework.Scheduler\TaskBase.cs:line 176 at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx) at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx) at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state) at System.Threading.ThreadHelper.ThreadStart() 2025-12-31 23:14:24.1624 DFramework.Database.NullableDataReader Data reader open for 337 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-31 23:14:24.7718 DFramework.Database.NullableDataReader Data reader open for 341 at System.Environment.GetStackTrace(Exception e, Boolean needFileInfo) at System.Environment.get_StackTrace() at DFramework.Database.NullableDataReader.Dispose(Boolean disposing) in 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-31 23:14:24.8187 DFramework.Database.NullableDataReader Data reader open for 424 at System.Environment.GetStackTrace(Exception e, Boolean needFileInfo) at System.Environment.get_StackTrace() at DFramework.Database.NullableDataReader.Dispose(Boolean disposing) in D:\Spraxa\Framework\DFramework\Database\NullableDataReader.cs:line 33 at DFramework.Database.NullableDataReader.Dispose() in D:\Spraxa\Framework\DFramework\Database\NullableDataReader.cs:line 44 at CoolR.Tasks.ProcessAlertData.Execute() in D:\Spraxa\CoolR-Group\portal\CoolR.Tasks\ProcessAlertData.cs:line 47 at DFramework.Scheduler.TaskBase.Run() in D:\Spraxa\Framework\DFramework.Scheduler\TaskBase.cs:line 176 at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx) at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx) at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state) at System.Threading.ThreadHelper.ThreadStart() 2025-12-31 23:14:25.7874 DFramework.Database.NullableDataReader Data reader open for 201 at System.Environment.GetStackTrace(Exception e, Boolean needFileInfo) at System.Environment.get_StackTrace() at DFramework.Database.NullableDataReader.Dispose(Boolean disposing) in 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-31 23:14:25.8499 DFramework.Database.NullableDataReader Data reader open for 285 at System.Environment.GetStackTrace(Exception e, Boolean needFileInfo) at System.Environment.get_StackTrace() at DFramework.Database.NullableDataReader.Dispose(Boolean disposing) in D:\Spraxa\Framework\DFramework\Database\NullableDataReader.cs:line 33 at DFramework.Database.NullableDataReader.Dispose() in D:\Spraxa\Framework\DFramework\Database\NullableDataReader.cs:line 44 at CoolR.Tasks.ProcessAlertData.Execute() in D:\Spraxa\CoolR-Group\portal\CoolR.Tasks\ProcessAlertData.cs:line 47 at DFramework.Scheduler.TaskBase.Run() in D:\Spraxa\Framework\DFramework.Scheduler\TaskBase.cs:line 176 at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx) at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx) at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state) at System.Threading.ThreadHelper.ThreadStart() 2025-12-31 23:14:26.1780 AlertProcessor Replace Tags updated for the Image Id: 3675460 2025-12-31 23:14:26.3655 DFramework.Database.NullableDataReader Data reader open for 277 at System.Environment.GetStackTrace(Exception e, Boolean needFileInfo) at System.Environment.get_StackTrace() at DFramework.Database.NullableDataReader.Dispose(Boolean disposing) in D:\Spraxa\Framework\DFramework\Database\NullableDataReader.cs:line 33 at DFramework.Database.NullableDataReader.Dispose() in D:\Spraxa\Framework\DFramework\Database\NullableDataReader.cs:line 44 at CoolR.Tasks.ProcessAlertData.Execute() in D:\Spraxa\CoolR-Group\portal\CoolR.Tasks\ProcessAlertData.cs:line 47 at DFramework.Scheduler.TaskBase.Run() in D:\Spraxa\Framework\DFramework.Scheduler\TaskBase.cs:line 176 at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx) at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx) at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state) at System.Threading.ThreadHelper.ThreadStart() 2025-12-31 23:14:26.8812 DFramework.Database.NullableDataReader Data reader open for 249 at System.Environment.GetStackTrace(Exception e, Boolean needFileInfo) at System.Environment.get_StackTrace() at DFramework.Database.NullableDataReader.Dispose(Boolean disposing) in D:\Spraxa\Framework\DFramework\Database\NullableDataReader.cs:line 33 at DFramework.Database.NullableDataReader.Dispose() in D:\Spraxa\Framework\DFramework\Database\NullableDataReader.cs:line 44 at CoolR.Tasks.ProcessAlertData.Execute() in D:\Spraxa\CoolR-Group\portal\CoolR.Tasks\ProcessAlertData.cs:line 47 at DFramework.Scheduler.TaskBase.Run() in D:\Spraxa\Framework\DFramework.Scheduler\TaskBase.cs:line 176 at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx) at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx) at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state) at System.Threading.ThreadHelper.ThreadStart() 2025-12-31 23:14:26.9437 DFramework.Database.NullableDataReader Data reader open for 331 at System.Environment.GetStackTrace(Exception e, Boolean needFileInfo) at System.Environment.get_StackTrace() at DFramework.Database.NullableDataReader.Dispose(Boolean disposing) in D:\Spraxa\Framework\DFramework\Database\NullableDataReader.cs:line 33 at DFramework.Database.NullableDataReader.Dispose() in D:\Spraxa\Framework\DFramework\Database\NullableDataReader.cs:line 44 at CoolR.Tasks.ProcessAlertData.Execute() in D:\Spraxa\CoolR-Group\portal\CoolR.Tasks\ProcessAlertData.cs:line 47 at DFramework.Scheduler.TaskBase.Run() in D:\Spraxa\Framework\DFramework.Scheduler\TaskBase.cs:line 176 at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx) at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx) at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state) at System.Threading.ThreadHelper.ThreadStart() 2025-12-31 23:14:28.1781 DFramework.Database.NullableDataReader Data reader open for 646 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-31 23:14:28.2406 DFramework.Database.NullableDataReader Data reader open for 728 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-31 23:14:29.0687 DFramework.Database.NullableDataReader Data reader open for 227 at System.Environment.GetStackTrace(Exception e, Boolean needFileInfo) at System.Environment.get_StackTrace() at DFramework.Database.NullableDataReader.Dispose(Boolean disposing) in D:\Spraxa\Framework\DFramework\Database\NullableDataReader.cs:line 33 at DFramework.Database.NullableDataReader.Dispose() in D:\Spraxa\Framework\DFramework\Database\NullableDataReader.cs:line 44 at CoolR.Tasks.ProcessAlertData.Execute() in D:\Spraxa\CoolR-Group\portal\CoolR.Tasks\ProcessAlertData.cs:line 47 at DFramework.Scheduler.TaskBase.Run() in D:\Spraxa\Framework\DFramework.Scheduler\TaskBase.cs:line 176 at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx) at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx) at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state) at System.Threading.ThreadHelper.ThreadStart() 2025-12-31 23:14:29.1156 DFramework.Database.NullableDataReader Data reader open for 310 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-31 23:14:29.6312 AlertProcessor ProcessorAlertData: Stopped 2025-12-31 23:14:32.0844 DFramework.Scheduler.TaskBase /* Time Taken: 15734.5174*/ Opportunity Out Of Stock By Outlet 2025-12-31 23:19:21.3521 AlertProcessor ProcessorAlertData: started 2025-12-31 23:19:23.4615 DFramework.Database.NullableDataReader Data reader open for 214 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-31 23:19:23.5083 DFramework.Database.NullableDataReader Data reader open for 297 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-31 23:19:24.0396 DFramework.Database.NullableDataReader Data reader open for 254 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-31 23:19:24.1021 DFramework.Database.NullableDataReader Data reader open for 337 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-31 23:19:24.6802 DFramework.Database.NullableDataReader Data reader open for 337 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-31 23:19:24.7427 DFramework.Database.NullableDataReader Data reader open for 420 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-31 23:19:25.7427 DFramework.Database.NullableDataReader Data reader open for 277 at System.Environment.GetStackTrace(Exception e, Boolean needFileInfo) at System.Environment.get_StackTrace() at DFramework.Database.NullableDataReader.Dispose(Boolean disposing) in D:\Spraxa\Framework\DFramework\Database\NullableDataReader.cs:line 33 at DFramework.Database.NullableDataReader.Dispose() in D:\Spraxa\Framework\DFramework\Database\NullableDataReader.cs:line 44 at CoolR.Tasks.ProcessAlertData.Execute() in D:\Spraxa\CoolR-Group\portal\CoolR.Tasks\ProcessAlertData.cs:line 47 at DFramework.Scheduler.TaskBase.Run() in D:\Spraxa\Framework\DFramework.Scheduler\TaskBase.cs:line 176 at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx) at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx) at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state) at System.Threading.ThreadHelper.ThreadStart() 2025-12-31 23:19:26.0709 AlertProcessor Replace Tags updated for the Image Id: 3675462 2025-12-31 23:19:26.2115 DFramework.Database.NullableDataReader Data reader open for 223 at System.Environment.GetStackTrace(Exception e, Boolean needFileInfo) at System.Environment.get_StackTrace() at DFramework.Database.NullableDataReader.Dispose(Boolean disposing) in 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-31 23:19:26.7271 DFramework.Database.NullableDataReader Data reader open for 248 at System.Environment.GetStackTrace(Exception e, Boolean needFileInfo) at System.Environment.get_StackTrace() at DFramework.Database.NullableDataReader.Dispose(Boolean disposing) in D:\Spraxa\Framework\DFramework\Database\NullableDataReader.cs:line 33 at DFramework.Database.NullableDataReader.Dispose() in D:\Spraxa\Framework\DFramework\Database\NullableDataReader.cs:line 44 at CoolR.Tasks.ProcessAlertData.Execute() in D:\Spraxa\CoolR-Group\portal\CoolR.Tasks\ProcessAlertData.cs:line 47 at DFramework.Scheduler.TaskBase.Run() in D:\Spraxa\Framework\DFramework.Scheduler\TaskBase.cs:line 176 at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx) at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx) at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state) at System.Threading.ThreadHelper.ThreadStart() 2025-12-31 23:19:26.7896 DFramework.Database.NullableDataReader Data reader open for 331 at System.Environment.GetStackTrace(Exception e, Boolean needFileInfo) at System.Environment.get_StackTrace() at DFramework.Database.NullableDataReader.Dispose(Boolean disposing) in D:\Spraxa\Framework\DFramework\Database\NullableDataReader.cs:line 33 at DFramework.Database.NullableDataReader.Dispose() in D:\Spraxa\Framework\DFramework\Database\NullableDataReader.cs:line 44 at CoolR.Tasks.ProcessAlertData.Execute() in D:\Spraxa\CoolR-Group\portal\CoolR.Tasks\ProcessAlertData.cs:line 47 at DFramework.Scheduler.TaskBase.Run() in D:\Spraxa\Framework\DFramework.Scheduler\TaskBase.cs:line 176 at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx) at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx) at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state) at System.Threading.ThreadHelper.ThreadStart() 2025-12-31 23:19:27.7271 DFramework.Database.NullableDataReader Data reader open for 338 at System.Environment.GetStackTrace(Exception e, Boolean needFileInfo) at System.Environment.get_StackTrace() at DFramework.Database.NullableDataReader.Dispose(Boolean disposing) in D:\Spraxa\Framework\DFramework\Database\NullableDataReader.cs:line 33 at DFramework.Database.NullableDataReader.Dispose() in D:\Spraxa\Framework\DFramework\Database\NullableDataReader.cs:line 44 at CoolR.Tasks.ProcessAlertData.Execute() in D:\Spraxa\CoolR-Group\portal\CoolR.Tasks\ProcessAlertData.cs:line 47 at DFramework.Scheduler.TaskBase.Run() in D:\Spraxa\Framework\DFramework.Scheduler\TaskBase.cs:line 176 at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx) at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx) at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state) at System.Threading.ThreadHelper.ThreadStart() 2025-12-31 23:19:27.7740 DFramework.Database.NullableDataReader Data reader open for 421 at System.Environment.GetStackTrace(Exception e, Boolean needFileInfo) at System.Environment.get_StackTrace() at DFramework.Database.NullableDataReader.Dispose(Boolean disposing) in 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-31 23:19:28.5865 DFramework.Database.NullableDataReader Data reader open for 223 at System.Environment.GetStackTrace(Exception e, Boolean needFileInfo) at System.Environment.get_StackTrace() at DFramework.Database.NullableDataReader.Dispose(Boolean disposing) in 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-31 23:19:28.6490 DFramework.Database.NullableDataReader Data reader open for 306 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-31 23:19:29.1646 AlertProcessor ProcessorAlertData: Stopped 2025-12-31 23:24:21.3698 AlertProcessor ProcessorAlertData: started 2025-12-31 23:24:26.6823 AlertProcessor ProcessorAlertData: Stopped 2025-12-31 23:29:16.9034 DFramework.Database.Query /* Time Taken: 534*/ [dbo].GenerateSystemAlerts 2025-12-31 23:29:21.3878 AlertProcessor ProcessorAlertData: started 2025-12-31 23:29:26.8410 AlertProcessor ProcessorAlertData: Stopped 2025-12-31 23:29:32.1691 DFramework.Scheduler.TaskBase /* Time Taken: 15797.006*/ Opportunity Out Of Stock By Outlet 2025-12-31 23:34:17.6087 MoveToReorder Running task for ClientId : 286 and ClientName = India Office QA and Slot: 1/1/2026 1:00:00 PM And LastExecutedOn: 1/1/2026 12:04:17 PM 2025-12-31 23:34:18.2494 DFramework.Database.NullableDataReader Data reader open for 292 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-31 23:34:18.2806 MoveToReorder Task executed successfully for ClientId : 286 Client Name:India Office QA, Slot: 1/1/2026 1:00:00 PM and Total Order Suggested: 1 Out Of: 1 2025-12-31 23:34:21.4057 AlertProcessor ProcessorAlertData: started 2025-12-31 23:34:26.8276 AlertProcessor ProcessorAlertData: Stopped 2025-12-31 23:39:21.4234 AlertProcessor ProcessorAlertData: started 2025-12-31 23:39:26.9234 AlertProcessor ProcessorAlertData: Stopped 2025-12-31 23:44:16.9101 DFramework.Database.Query /* Time Taken: 516*/ [dbo].GenerateSystemAlerts 2025-12-31 23:44:21.4414 AlertProcessor ProcessorAlertData: started 2025-12-31 23:44:26.7071 AlertProcessor ProcessorAlertData: Stopped 2025-12-31 23:44:32.1759 DFramework.Scheduler.TaskBase /* Time Taken: 15781.3872*/ Opportunity Out Of Stock By Outlet 2025-12-31 23:49:21.4595 AlertProcessor ProcessorAlertData: started 2025-12-31 23:49:26.9439 AlertProcessor ProcessorAlertData: Stopped 2025-12-31 23:54:21.4773 AlertProcessor ProcessorAlertData: started 2025-12-31 23:54:26.9617 AlertProcessor ProcessorAlertData: Stopped 2025-12-31 23:59:16.9169 DFramework.Database.Query /* Time Taken: 524*/ [dbo].GenerateSystemAlerts 2025-12-31 23:59:21.4951 AlertProcessor ProcessorAlertData: started 2025-12-31 23:59:26.9639 AlertProcessor ProcessorAlertData: Stopped 2025-12-31 23:59:32.2295 DFramework.Scheduler.TaskBase /* Time Taken: 15828.2328*/ Opportunity Out Of Stock By Outlet