2026-01-17 00:12:58.5657 DFramework.Database.NullableDataReader    Data reader open for 324
   at System.Environment.GetStackTrace(Exception e, Boolean needFileInfo)
   at System.Environment.get_StackTrace()
   at DFramework.Database.NullableDataReader.Dispose(Boolean disposing) in C:\CoolR-Group\Framework\DFramework\Database\NullableDataReader.cs:line 33
   at DFramework.Database.NullableDataReader.Dispose() in C:\CoolR-Group\Framework\DFramework\Database\NullableDataReader.cs:line 44
   at CoolR.Tasks.ProcessOutletAlertData.GetAlertDefinitions() in C:\CoolR-Group\portal\CoolR.Tasks\OpportunityOutOfStockByOutlet.cs:line 490
   at CoolR.Tasks.ProcessOutletAlertData.Execute() in C:\CoolR-Group\portal\CoolR.Tasks\OpportunityOutOfStockByOutlet.cs:line 72
   at DFramework.Scheduler.TaskBase.Run() in E:\Forked\Framework\DFramework.Scheduler\TaskBase.cs:line 176
   at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)
   at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)
   at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state)
   at System.Threading.ThreadHelper.ThreadStart() 
2026-01-17 00:13:14.1646 DFramework.Scheduler.TaskBase    /* Time Taken: 16177.7765*/
Opportunity Out Of Stock By Outlet 
2026-01-17 00:27:58.5024 DFramework.Database.Query    /* Time Taken: 510*/
[dbo].GenerateSystemAlerts 
2026-01-17 00:27:58.6126 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 C:\CoolR-Group\Framework\DFramework\Database\NullableDataReader.cs:line 33
   at DFramework.Database.NullableDataReader.Dispose() in C:\CoolR-Group\Framework\DFramework\Database\NullableDataReader.cs:line 44
   at CoolR.Tasks.ProcessOutletAlertData.GetAlertDefinitions() in C:\CoolR-Group\portal\CoolR.Tasks\OpportunityOutOfStockByOutlet.cs:line 490
   at CoolR.Tasks.ProcessOutletAlertData.Execute() in C:\CoolR-Group\portal\CoolR.Tasks\OpportunityOutOfStockByOutlet.cs:line 72
   at DFramework.Scheduler.TaskBase.Run() in E:\Forked\Framework\DFramework.Scheduler\TaskBase.cs:line 176
   at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)
   at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)
   at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state)
   at System.Threading.ThreadHelper.ThreadStart() 
2026-01-17 00:28:14.1377 DFramework.Scheduler.TaskBase    /* Time Taken: 16135.469*/
Opportunity Out Of Stock By Outlet 
2026-01-17 00:32:58.6920 MoveToReorder    Running task for ClientId : 286 and ClientName = India Office QA and Slot: 1/17/2026 2:00:00 PM And LastExecutedOn: 1/17/2026 1:02:58 PM 
2026-01-17 00:33:37.9909 DFramework.Database.NullableDataReader    Data reader open for 38982
   at System.Environment.GetStackTrace(Exception e, Boolean needFileInfo)
   at System.Environment.get_StackTrace()
   at DFramework.Database.NullableDataReader.Dispose(Boolean disposing) in C:\CoolR-Group\Framework\DFramework\Database\NullableDataReader.cs:line 33
   at DFramework.Database.NullableDataReader.Dispose() in C:\CoolR-Group\Framework\DFramework\Database\NullableDataReader.cs:line 44
   at CoolR.Tasks.MoveToReorder.Execute() in C:\CoolR-Group\portal\CoolR.Tasks\MoveToReorder.cs:line 44
   at DFramework.Scheduler.TaskBase.Run() in E:\Forked\Framework\DFramework.Scheduler\TaskBase.cs:line 176
   at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)
   at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)
   at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state)
   at System.Threading.ThreadHelper.ThreadStart() 
2026-01-17 00:33:38.0221 MoveToReorder    Task executed successfully for ClientId : 286 Client Name:India Office QA, Slot: 1/17/2026 2:00:00 PM and Total Order Suggested: 126 Out Of: 126 
2026-01-17 00:33:38.7282 DFramework.Database.Query    /* Time Taken: 696*/
DECLARE @ClientId Int32
SET @ClientId = '286'
dbo.GetMoveToReOrderList 
2026-01-17 00:33:40.0148 DFramework.Scheduler.TaskBase    /* Time Taken: 41636.4179*/
Move To Re-Order 
2026-01-17 00:42:58.3483 DFramework.Database.NullableDataReader    Data reader open for 308
   at System.Environment.GetStackTrace(Exception e, Boolean needFileInfo)
   at System.Environment.get_StackTrace()
   at DFramework.Database.NullableDataReader.Dispose(Boolean disposing) in C:\CoolR-Group\Framework\DFramework\Database\NullableDataReader.cs:line 33
   at DFramework.Database.NullableDataReader.Dispose() in C:\CoolR-Group\Framework\DFramework\Database\NullableDataReader.cs:line 44
   at CoolR.Tasks.ProcessOutletAlertData.GetAlertDefinitions() in C:\CoolR-Group\portal\CoolR.Tasks\OpportunityOutOfStockByOutlet.cs:line 490
   at CoolR.Tasks.ProcessOutletAlertData.Execute() in C:\CoolR-Group\portal\CoolR.Tasks\OpportunityOutOfStockByOutlet.cs:line 72
   at DFramework.Scheduler.TaskBase.Run() in E:\Forked\Framework\DFramework.Scheduler\TaskBase.cs:line 176
   at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)
   at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)
   at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state)
   at System.Threading.ThreadHelper.ThreadStart() 
2026-01-17 00:42:58.5671 DFramework.Database.Query    /* Time Taken: 556*/
[dbo].GenerateSystemAlerts 
2026-01-17 00:43:13.9773 DFramework.Scheduler.TaskBase    /* Time Taken: 15957.2208*/
Opportunity Out Of Stock By Outlet 
2026-01-17 00:57:58.6751 DFramework.Database.Query    /* Time Taken: 634*/
[dbo].GenerateSystemAlerts 
2026-01-17 00:58:13.8152 DFramework.Scheduler.TaskBase    /* Time Taken: 15765.4766*/
Opportunity Out Of Stock By Outlet 
2026-01-17 01:12:58.6853 DFramework.Database.Query    /* Time Taken: 613*/
[dbo].GenerateSystemAlerts 
2026-01-17 01:12:58.6853 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 C:\CoolR-Group\Framework\DFramework\Database\NullableDataReader.cs:line 33
   at DFramework.Database.NullableDataReader.Dispose() in C:\CoolR-Group\Framework\DFramework\Database\NullableDataReader.cs:line 44
   at CoolR.Tasks.ProcessOutletAlertData.GetAlertDefinitions() in C:\CoolR-Group\portal\CoolR.Tasks\OpportunityOutOfStockByOutlet.cs:line 490
   at CoolR.Tasks.ProcessOutletAlertData.Execute() in C:\CoolR-Group\portal\CoolR.Tasks\OpportunityOutOfStockByOutlet.cs:line 72
   at DFramework.Scheduler.TaskBase.Run() in E:\Forked\Framework\DFramework.Scheduler\TaskBase.cs:line 176
   at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)
   at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)
   at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state)
   at System.Threading.ThreadHelper.ThreadStart() 
2026-01-17 01:13:14.1941 DFramework.Scheduler.TaskBase    /* Time Taken: 16120.5949*/
Opportunity Out Of Stock By Outlet 
2026-01-17 01:27:58.6684 DFramework.Database.NullableDataReader    Data reader open for 324
   at System.Environment.GetStackTrace(Exception e, Boolean needFileInfo)
   at System.Environment.get_StackTrace()
   at DFramework.Database.NullableDataReader.Dispose(Boolean disposing) in C:\CoolR-Group\Framework\DFramework\Database\NullableDataReader.cs:line 33
   at DFramework.Database.NullableDataReader.Dispose() in C:\CoolR-Group\Framework\DFramework\Database\NullableDataReader.cs:line 44
   at CoolR.Tasks.ProcessOutletAlertData.GetAlertDefinitions() in C:\CoolR-Group\portal\CoolR.Tasks\OpportunityOutOfStockByOutlet.cs:line 490
   at CoolR.Tasks.ProcessOutletAlertData.Execute() in C:\CoolR-Group\portal\CoolR.Tasks\OpportunityOutOfStockByOutlet.cs:line 72
   at DFramework.Scheduler.TaskBase.Run() in E:\Forked\Framework\DFramework.Scheduler\TaskBase.cs:line 176
   at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)
   at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)
   at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state)
   at System.Threading.ThreadHelper.ThreadStart() 
2026-01-17 01:27:58.6840 DFramework.Database.Query    /* Time Taken: 595*/
[dbo].GenerateSystemAlerts 
2026-01-17 01:28:14.1854 DFramework.Scheduler.TaskBase    /* Time Taken: 16094.4809*/
Opportunity Out Of Stock By Outlet 
2026-01-17 01:32:58.7906 MoveToReorder    Running task for ClientId : 286 and ClientName = India Office QA and Slot: 1/17/2026 3:00:00 PM And LastExecutedOn: 1/17/2026 2:02:58 PM 
2026-01-17 01:32:59.0365 MoveToReorder    Task executed successfully for ClientId : 286 Client Name:India Office QA, Slot: 1/17/2026 3:00:00 PM But No Order found to suggest 
2026-01-17 01:42:58.4285 DFramework.Database.NullableDataReader    Data reader open for 312
   at System.Environment.GetStackTrace(Exception e, Boolean needFileInfo)
   at System.Environment.get_StackTrace()
   at DFramework.Database.NullableDataReader.Dispose(Boolean disposing) in C:\CoolR-Group\Framework\DFramework\Database\NullableDataReader.cs:line 33
   at DFramework.Database.NullableDataReader.Dispose() in C:\CoolR-Group\Framework\DFramework\Database\NullableDataReader.cs:line 44
   at CoolR.Tasks.ProcessOutletAlertData.GetAlertDefinitions() in C:\CoolR-Group\portal\CoolR.Tasks\OpportunityOutOfStockByOutlet.cs:line 490
   at CoolR.Tasks.ProcessOutletAlertData.Execute() in C:\CoolR-Group\portal\CoolR.Tasks\OpportunityOutOfStockByOutlet.cs:line 72
   at DFramework.Scheduler.TaskBase.Run() in E:\Forked\Framework\DFramework.Scheduler\TaskBase.cs:line 176
   at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)
   at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)
   at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state)
   at System.Threading.ThreadHelper.ThreadStart() 
2026-01-17 01:42:58.6327 DFramework.Database.Query    /* Time Taken: 531*/
[dbo].GenerateSystemAlerts 
2026-01-17 01:43:14.0394 DFramework.Scheduler.TaskBase    /* Time Taken: 15936.3008*/
Opportunity Out Of Stock By Outlet 
2026-01-17 01:57:58.4871 DFramework.Database.NullableDataReader    Data reader open for 332
   at System.Environment.GetStackTrace(Exception e, Boolean needFileInfo)
   at System.Environment.get_StackTrace()
   at DFramework.Database.NullableDataReader.Dispose(Boolean disposing) in C:\CoolR-Group\Framework\DFramework\Database\NullableDataReader.cs:line 33
   at DFramework.Database.NullableDataReader.Dispose() in C:\CoolR-Group\Framework\DFramework\Database\NullableDataReader.cs:line 44
   at CoolR.Tasks.ProcessOutletAlertData.GetAlertDefinitions() in C:\CoolR-Group\portal\CoolR.Tasks\OpportunityOutOfStockByOutlet.cs:line 490
   at CoolR.Tasks.ProcessOutletAlertData.Execute() in C:\CoolR-Group\portal\CoolR.Tasks\OpportunityOutOfStockByOutlet.cs:line 72
   at DFramework.Scheduler.TaskBase.Run() in E:\Forked\Framework\DFramework.Scheduler\TaskBase.cs:line 176
   at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)
   at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)
   at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state)
   at System.Threading.ThreadHelper.ThreadStart() 
2026-01-17 01:57:58.7532 DFramework.Database.Query    /* Time Taken: 625*/
[dbo].GenerateSystemAlerts 
2026-01-17 01:58:14.0659 DFramework.Scheduler.TaskBase    /* Time Taken: 15938.2687*/
Opportunity Out Of Stock By Outlet 
2026-01-17 02:12:58.7428 DFramework.Database.NullableDataReader    Data reader open for 333
   at System.Environment.GetStackTrace(Exception e, Boolean needFileInfo)
   at System.Environment.get_StackTrace()
   at DFramework.Database.NullableDataReader.Dispose(Boolean disposing) in C:\CoolR-Group\Framework\DFramework\Database\NullableDataReader.cs:line 33
   at DFramework.Database.NullableDataReader.Dispose() in C:\CoolR-Group\Framework\DFramework\Database\NullableDataReader.cs:line 44
   at CoolR.Tasks.ProcessOutletAlertData.GetAlertDefinitions() in C:\CoolR-Group\portal\CoolR.Tasks\OpportunityOutOfStockByOutlet.cs:line 490
   at CoolR.Tasks.ProcessOutletAlertData.Execute() in C:\CoolR-Group\portal\CoolR.Tasks\OpportunityOutOfStockByOutlet.cs:line 72
   at DFramework.Scheduler.TaskBase.Run() in E:\Forked\Framework\DFramework.Scheduler\TaskBase.cs:line 176
   at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)
   at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)
   at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state)
   at System.Threading.ThreadHelper.ThreadStart() 
2026-01-17 02:12:58.7584 DFramework.Database.Query    /* Time Taken: 609*/
[dbo].GenerateSystemAlerts 
2026-01-17 02:13:14.2789 DFramework.Scheduler.TaskBase    /* Time Taken: 16130.7733*/
Opportunity Out Of Stock By Outlet 
2026-01-17 02:27:58.7321 DFramework.Database.NullableDataReader    Data reader open for 313
   at System.Environment.GetStackTrace(Exception e, Boolean needFileInfo)
   at System.Environment.get_StackTrace()
   at DFramework.Database.NullableDataReader.Dispose(Boolean disposing) in C:\CoolR-Group\Framework\DFramework\Database\NullableDataReader.cs:line 33
   at DFramework.Database.NullableDataReader.Dispose() in C:\CoolR-Group\Framework\DFramework\Database\NullableDataReader.cs:line 44
   at CoolR.Tasks.ProcessOutletAlertData.GetAlertDefinitions() in C:\CoolR-Group\portal\CoolR.Tasks\OpportunityOutOfStockByOutlet.cs:line 490
   at CoolR.Tasks.ProcessOutletAlertData.Execute() in C:\CoolR-Group\portal\CoolR.Tasks\OpportunityOutOfStockByOutlet.cs:line 72
   at DFramework.Scheduler.TaskBase.Run() in E:\Forked\Framework\DFramework.Scheduler\TaskBase.cs:line 176
   at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)
   at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)
   at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state)
   at System.Threading.ThreadHelper.ThreadStart() 
2026-01-17 02:28:14.2481 DFramework.Scheduler.TaskBase    /* Time Taken: 16079.8774*/
Opportunity Out Of Stock By Outlet 
2026-01-17 02:32:58.8992 MoveToReorder    Running task for ClientId : 286 and ClientName = India Office QA and Slot: 1/17/2026 4:00:00 PM And LastExecutedOn: 1/17/2026 3:02:58 PM 
2026-01-17 02:32:59.1368 MoveToReorder    Task executed successfully for ClientId : 286 Client Name:India Office QA, Slot: 1/17/2026 4:00:00 PM But No Order found to suggest 
2026-01-17 02:42:58.5043 DFramework.Database.NullableDataReader    Data reader open for 313
   at System.Environment.GetStackTrace(Exception e, Boolean needFileInfo)
   at System.Environment.get_StackTrace()
   at DFramework.Database.NullableDataReader.Dispose(Boolean disposing) in C:\CoolR-Group\Framework\DFramework\Database\NullableDataReader.cs:line 33
   at DFramework.Database.NullableDataReader.Dispose() in C:\CoolR-Group\Framework\DFramework\Database\NullableDataReader.cs:line 44
   at CoolR.Tasks.ProcessOutletAlertData.GetAlertDefinitions() in C:\CoolR-Group\portal\CoolR.Tasks\OpportunityOutOfStockByOutlet.cs:line 490
   at CoolR.Tasks.ProcessOutletAlertData.Execute() in C:\CoolR-Group\portal\CoolR.Tasks\OpportunityOutOfStockByOutlet.cs:line 72
   at DFramework.Scheduler.TaskBase.Run() in E:\Forked\Framework\DFramework.Scheduler\TaskBase.cs:line 176
   at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)
   at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)
   at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state)
   at System.Threading.ThreadHelper.ThreadStart() 
2026-01-17 02:42:58.7239 DFramework.Database.Query    /* Time Taken: 548*/
[dbo].GenerateSystemAlerts 
2026-01-17 02:43:14.2446 DFramework.Scheduler.TaskBase    /* Time Taken: 16068.5573*/
Opportunity Out Of Stock By Outlet 
2026-01-17 02:57:58.5262 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 C:\CoolR-Group\Framework\DFramework\Database\NullableDataReader.cs:line 33
   at DFramework.Database.NullableDataReader.Dispose() in C:\CoolR-Group\Framework\DFramework\Database\NullableDataReader.cs:line 44
   at CoolR.Tasks.ProcessOutletAlertData.GetAlertDefinitions() in C:\CoolR-Group\portal\CoolR.Tasks\OpportunityOutOfStockByOutlet.cs:line 490
   at CoolR.Tasks.ProcessOutletAlertData.Execute() in C:\CoolR-Group\portal\CoolR.Tasks\OpportunityOutOfStockByOutlet.cs:line 72
   at DFramework.Scheduler.TaskBase.Run() in E:\Forked\Framework\DFramework.Scheduler\TaskBase.cs:line 176
   at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)
   at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)
   at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state)
   at System.Threading.ThreadHelper.ThreadStart() 
2026-01-17 02:57:58.7459 DFramework.Database.Query    /* Time Taken: 548*/
[dbo].GenerateSystemAlerts 
2026-01-17 02:58:14.1349 DFramework.Scheduler.TaskBase    /* Time Taken: 15936.7254*/
Opportunity Out Of Stock By Outlet 
2026-01-17 03:12:58.7471 DFramework.Database.NullableDataReader    Data reader open for 299
   at System.Environment.GetStackTrace(Exception e, Boolean needFileInfo)
   at System.Environment.get_StackTrace()
   at DFramework.Database.NullableDataReader.Dispose(Boolean disposing) in C:\CoolR-Group\Framework\DFramework\Database\NullableDataReader.cs:line 33
   at DFramework.Database.NullableDataReader.Dispose() in C:\CoolR-Group\Framework\DFramework\Database\NullableDataReader.cs:line 44
   at CoolR.Tasks.ProcessOutletAlertData.GetAlertDefinitions() in C:\CoolR-Group\portal\CoolR.Tasks\OpportunityOutOfStockByOutlet.cs:line 490
   at CoolR.Tasks.ProcessOutletAlertData.Execute() in C:\CoolR-Group\portal\CoolR.Tasks\OpportunityOutOfStockByOutlet.cs:line 72
   at DFramework.Scheduler.TaskBase.Run() in E:\Forked\Framework\DFramework.Scheduler\TaskBase.cs:line 176
   at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)
   at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)
   at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state)
   at System.Threading.ThreadHelper.ThreadStart() 
2026-01-17 03:13:15.0372 DFramework.Scheduler.TaskBase    /* Time Taken: 16821.2514*/
Opportunity Out Of Stock By Outlet 
2026-01-17 03:27:58.7661 DFramework.Database.NullableDataReader    Data reader open for 300
   at System.Environment.GetStackTrace(Exception e, Boolean needFileInfo)
   at System.Environment.get_StackTrace()
   at DFramework.Database.NullableDataReader.Dispose(Boolean disposing) in C:\CoolR-Group\Framework\DFramework\Database\NullableDataReader.cs:line 33
   at DFramework.Database.NullableDataReader.Dispose() in C:\CoolR-Group\Framework\DFramework\Database\NullableDataReader.cs:line 44
   at CoolR.Tasks.ProcessOutletAlertData.GetAlertDefinitions() in C:\CoolR-Group\portal\CoolR.Tasks\OpportunityOutOfStockByOutlet.cs:line 490
   at CoolR.Tasks.ProcessOutletAlertData.Execute() in C:\CoolR-Group\portal\CoolR.Tasks\OpportunityOutOfStockByOutlet.cs:line 72
   at DFramework.Scheduler.TaskBase.Run() in E:\Forked\Framework\DFramework.Scheduler\TaskBase.cs:line 176
   at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)
   at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)
   at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state)
   at System.Threading.ThreadHelper.ThreadStart() 
2026-01-17 03:28:14.8265 DFramework.Scheduler.TaskBase    /* Time Taken: 16592.5863*/
Opportunity Out Of Stock By Outlet 
2026-01-17 03:32:58.9681 MoveToReorder    Running task for ClientId : 286 and ClientName = India Office QA and Slot: 1/17/2026 5:00:00 PM And LastExecutedOn: 1/17/2026 4:02:58 PM 
2026-01-17 03:33:38.7640 DFramework.Database.NullableDataReader    Data reader open for 39517
   at System.Environment.GetStackTrace(Exception e, Boolean needFileInfo)
   at System.Environment.get_StackTrace()
   at DFramework.Database.NullableDataReader.Dispose(Boolean disposing) in C:\CoolR-Group\Framework\DFramework\Database\NullableDataReader.cs:line 33
   at DFramework.Database.NullableDataReader.Dispose() in C:\CoolR-Group\Framework\DFramework\Database\NullableDataReader.cs:line 44
   at CoolR.Tasks.MoveToReorder.Execute() in C:\CoolR-Group\portal\CoolR.Tasks\MoveToReorder.cs:line 44
   at DFramework.Scheduler.TaskBase.Run() in E:\Forked\Framework\DFramework.Scheduler\TaskBase.cs:line 176
   at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)
   at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)
   at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state)
   at System.Threading.ThreadHelper.ThreadStart() 
2026-01-17 03:33:38.7796 MoveToReorder    Task executed successfully for ClientId : 286 Client Name:India Office QA, Slot: 1/17/2026 5:00:00 PM and Total Order Suggested: 127 Out Of: 127 
2026-01-17 03:33:40.0502 DFramework.Scheduler.TaskBase    /* Time Taken: 41397.2796*/
Move To Re-Order 
2026-01-17 03:42:58.5636 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 C:\CoolR-Group\Framework\DFramework\Database\NullableDataReader.cs:line 33
   at DFramework.Database.NullableDataReader.Dispose() in C:\CoolR-Group\Framework\DFramework\Database\NullableDataReader.cs:line 44
   at CoolR.Tasks.ProcessOutletAlertData.GetAlertDefinitions() in C:\CoolR-Group\portal\CoolR.Tasks\OpportunityOutOfStockByOutlet.cs:line 490
   at CoolR.Tasks.ProcessOutletAlertData.Execute() in C:\CoolR-Group\portal\CoolR.Tasks\OpportunityOutOfStockByOutlet.cs:line 72
   at DFramework.Scheduler.TaskBase.Run() in E:\Forked\Framework\DFramework.Scheduler\TaskBase.cs:line 176
   at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)
   at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)
   at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state)
   at System.Threading.ThreadHelper.ThreadStart() 
2026-01-17 03:42:58.7832 DFramework.Database.Query    /* Time Taken: 545*/
[dbo].GenerateSystemAlerts 
2026-01-17 03:43:08.9472 DFramework.Scheduler.TaskBase    /* Time Taken: 10696.2747*/
Opportunity Out Of Stock By Outlet 
2026-01-17 03:50:03.4327 DFramework.Database.Query    /* Time Taken: 1961*/
DECLARE @AssetPurityId Int32
SET @AssetPurityId = '3676247'
DECLARE @AssetId Int32
SET @AssetId = '118196'
DECLARE @StatusId Int32
SET @StatusId = '2'
DECLARE @PurityDateTime Date
SET @PurityDateTime = '1/16/2026 6:44:56 PM'
SELECT TOP 1 PurityDateTime, AssetPurityId, PlanogramId, Shelves, PurityStatus, AssetId, ImageReceivedFrom FROM AssetPurity
 WHERE [AssetPurityId] <= @AssetPurityId AND [AssetId] = @AssetId AND [StatusId] = @StatusId AND [PurityDateTime] > @PurityDateTime
 ORDER BY [PurityDateTime] DESC 
2026-01-17 03:57:58.7915 DFramework.Database.NullableDataReader    Data reader open for 271
   at System.Environment.GetStackTrace(Exception e, Boolean needFileInfo)
   at System.Environment.get_StackTrace()
   at DFramework.Database.NullableDataReader.Dispose(Boolean disposing) in C:\CoolR-Group\Framework\DFramework\Database\NullableDataReader.cs:line 33
   at DFramework.Database.NullableDataReader.Dispose() in C:\CoolR-Group\Framework\DFramework\Database\NullableDataReader.cs:line 44
   at CoolR.Tasks.ProcessOutletAlertData.GetAlertDefinitions() in C:\CoolR-Group\portal\CoolR.Tasks\OpportunityOutOfStockByOutlet.cs:line 490
   at CoolR.Tasks.ProcessOutletAlertData.Execute() in C:\CoolR-Group\portal\CoolR.Tasks\OpportunityOutOfStockByOutlet.cs:line 72
   at DFramework.Scheduler.TaskBase.Run() in E:\Forked\Framework\DFramework.Scheduler\TaskBase.cs:line 176
   at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)
   at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)
   at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state)
   at System.Threading.ThreadHelper.ThreadStart() 
2026-01-17 03:58:09.0973 DFramework.Scheduler.TaskBase    /* Time Taken: 10823.9885*/
Opportunity Out Of Stock By Outlet 
2026-01-17 04:12:58.7961 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 C:\CoolR-Group\Framework\DFramework\Database\NullableDataReader.cs:line 33
   at DFramework.Database.NullableDataReader.Dispose() in C:\CoolR-Group\Framework\DFramework\Database\NullableDataReader.cs:line 44
   at CoolR.Tasks.ProcessOutletAlertData.GetAlertDefinitions() in C:\CoolR-Group\portal\CoolR.Tasks\OpportunityOutOfStockByOutlet.cs:line 490
   at CoolR.Tasks.ProcessOutletAlertData.Execute() in C:\CoolR-Group\portal\CoolR.Tasks\OpportunityOutOfStockByOutlet.cs:line 72
   at DFramework.Scheduler.TaskBase.Run() in E:\Forked\Framework\DFramework.Scheduler\TaskBase.cs:line 176
   at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)
   at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)
   at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state)
   at System.Threading.ThreadHelper.ThreadStart() 
2026-01-17 04:13:09.1136 DFramework.Scheduler.TaskBase    /* Time Taken: 10832.8232*/
Opportunity Out Of Stock By Outlet 
2026-01-17 04:27:58.8175 DFramework.Database.NullableDataReader    Data reader open for 272
   at System.Environment.GetStackTrace(Exception e, Boolean needFileInfo)
   at System.Environment.get_StackTrace()
   at DFramework.Database.NullableDataReader.Dispose(Boolean disposing) in C:\CoolR-Group\Framework\DFramework\Database\NullableDataReader.cs:line 33
   at DFramework.Database.NullableDataReader.Dispose() in C:\CoolR-Group\Framework\DFramework\Database\NullableDataReader.cs:line 44
   at CoolR.Tasks.ProcessOutletAlertData.GetAlertDefinitions() in C:\CoolR-Group\portal\CoolR.Tasks\OpportunityOutOfStockByOutlet.cs:line 490
   at CoolR.Tasks.ProcessOutletAlertData.Execute() in C:\CoolR-Group\portal\CoolR.Tasks\OpportunityOutOfStockByOutlet.cs:line 72
   at DFramework.Scheduler.TaskBase.Run() in E:\Forked\Framework\DFramework.Scheduler\TaskBase.cs:line 176
   at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)
   at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)
   at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state)
   at System.Threading.ThreadHelper.ThreadStart() 
2026-01-17 04:28:09.1065 DFramework.Scheduler.TaskBase    /* Time Taken: 10805.6953*/
Opportunity Out Of Stock By Outlet 
2026-01-17 04:32:59.0808 MoveToReorder    Running task for ClientId : 286 and ClientName = India Office QA and Slot: 1/17/2026 6:00:00 PM And LastExecutedOn: 1/17/2026 5:02:58 PM 
2026-01-17 04:32:59.3014 MoveToReorder    Task executed successfully for ClientId : 286 Client Name:India Office QA, Slot: 1/17/2026 6:00:00 PM But No Order found to suggest 
2026-01-17 04:42:58.6187 DFramework.Database.NullableDataReader    Data reader open for 270
   at System.Environment.GetStackTrace(Exception e, Boolean needFileInfo)
   at System.Environment.get_StackTrace()
   at DFramework.Database.NullableDataReader.Dispose(Boolean disposing) in C:\CoolR-Group\Framework\DFramework\Database\NullableDataReader.cs:line 33
   at DFramework.Database.NullableDataReader.Dispose() in C:\CoolR-Group\Framework\DFramework\Database\NullableDataReader.cs:line 44
   at CoolR.Tasks.ProcessOutletAlertData.GetAlertDefinitions() in C:\CoolR-Group\portal\CoolR.Tasks\OpportunityOutOfStockByOutlet.cs:line 490
   at CoolR.Tasks.ProcessOutletAlertData.Execute() in C:\CoolR-Group\portal\CoolR.Tasks\OpportunityOutOfStockByOutlet.cs:line 72
   at DFramework.Scheduler.TaskBase.Run() in E:\Forked\Framework\DFramework.Scheduler\TaskBase.cs:line 176
   at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)
   at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)
   at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state)
   at System.Threading.ThreadHelper.ThreadStart() 
2026-01-17 04:43:08.9525 DFramework.Scheduler.TaskBase    /* Time Taken: 10630.6704*/
Opportunity Out Of Stock By Outlet 
2026-01-17 04:57:58.8503 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 C:\CoolR-Group\Framework\DFramework\Database\NullableDataReader.cs:line 33
   at DFramework.Database.NullableDataReader.Dispose() in C:\CoolR-Group\Framework\DFramework\Database\NullableDataReader.cs:line 44
   at CoolR.Tasks.ProcessOutletAlertData.GetAlertDefinitions() in C:\CoolR-Group\portal\CoolR.Tasks\OpportunityOutOfStockByOutlet.cs:line 490
   at CoolR.Tasks.ProcessOutletAlertData.Execute() in C:\CoolR-Group\portal\CoolR.Tasks\OpportunityOutOfStockByOutlet.cs:line 72
   at DFramework.Scheduler.TaskBase.Run() in E:\Forked\Framework\DFramework.Scheduler\TaskBase.cs:line 176
   at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)
   at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)
   at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state)
   at System.Threading.ThreadHelper.ThreadStart() 
2026-01-17 04:58:09.1566 DFramework.Scheduler.TaskBase    /* Time Taken: 10824.1155*/
Opportunity Out Of Stock By Outlet 
2026-01-17 05:12:58.8894 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 C:\CoolR-Group\Framework\DFramework\Database\NullableDataReader.cs:line 33
   at DFramework.Database.NullableDataReader.Dispose() in C:\CoolR-Group\Framework\DFramework\Database\NullableDataReader.cs:line 44
   at CoolR.Tasks.ProcessOutletAlertData.GetAlertDefinitions() in C:\CoolR-Group\portal\CoolR.Tasks\OpportunityOutOfStockByOutlet.cs:line 490
   at CoolR.Tasks.ProcessOutletAlertData.Execute() in C:\CoolR-Group\portal\CoolR.Tasks\OpportunityOutOfStockByOutlet.cs:line 72
   at DFramework.Scheduler.TaskBase.Run() in E:\Forked\Framework\DFramework.Scheduler\TaskBase.cs:line 176
   at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)
   at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)
   at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state)
   at System.Threading.ThreadHelper.ThreadStart() 
2026-01-17 05:13:09.1931 DFramework.Scheduler.TaskBase    /* Time Taken: 10852.9278*/
Opportunity Out Of Stock By Outlet 
2026-01-17 05:27:58.6619 DFramework.Database.NullableDataReader    Data reader open for 284
   at System.Environment.GetStackTrace(Exception e, Boolean needFileInfo)
   at System.Environment.get_StackTrace()
   at DFramework.Database.NullableDataReader.Dispose(Boolean disposing) in C:\CoolR-Group\Framework\DFramework\Database\NullableDataReader.cs:line 33
   at DFramework.Database.NullableDataReader.Dispose() in C:\CoolR-Group\Framework\DFramework\Database\NullableDataReader.cs:line 44
   at CoolR.Tasks.ProcessOutletAlertData.GetAlertDefinitions() in C:\CoolR-Group\portal\CoolR.Tasks\OpportunityOutOfStockByOutlet.cs:line 490
   at CoolR.Tasks.ProcessOutletAlertData.Execute() in C:\CoolR-Group\portal\CoolR.Tasks\OpportunityOutOfStockByOutlet.cs:line 72
   at DFramework.Scheduler.TaskBase.Run() in E:\Forked\Framework\DFramework.Scheduler\TaskBase.cs:line 176
   at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)
   at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)
   at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state)
   at System.Threading.ThreadHelper.ThreadStart() 
2026-01-17 05:28:08.9984 DFramework.Scheduler.TaskBase    /* Time Taken: 10649.3434*/
Opportunity Out Of Stock By Outlet 
2026-01-17 05:32:59.2119 MoveToReorder    Running task for ClientId : 286 and ClientName = India Office QA and Slot: 1/17/2026 7:00:00 PM And LastExecutedOn: 1/17/2026 6:02:59 PM 
2026-01-17 05:32:59.4311 MoveToReorder    Task executed successfully for ClientId : 286 Client Name:India Office QA, Slot: 1/17/2026 7:00:00 PM But No Order found to suggest 
2026-01-17 05:42:58.6555 DFramework.Database.NullableDataReader    Data reader open for 270
   at System.Environment.GetStackTrace(Exception e, Boolean needFileInfo)
   at System.Environment.get_StackTrace()
   at DFramework.Database.NullableDataReader.Dispose(Boolean disposing) in C:\CoolR-Group\Framework\DFramework\Database\NullableDataReader.cs:line 33
   at DFramework.Database.NullableDataReader.Dispose() in C:\CoolR-Group\Framework\DFramework\Database\NullableDataReader.cs:line 44
   at CoolR.Tasks.ProcessOutletAlertData.GetAlertDefinitions() in C:\CoolR-Group\portal\CoolR.Tasks\OpportunityOutOfStockByOutlet.cs:line 490
   at CoolR.Tasks.ProcessOutletAlertData.Execute() in C:\CoolR-Group\portal\CoolR.Tasks\OpportunityOutOfStockByOutlet.cs:line 72
   at DFramework.Scheduler.TaskBase.Run() in E:\Forked\Framework\DFramework.Scheduler\TaskBase.cs:line 176
   at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)
   at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)
   at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state)
   at System.Threading.ThreadHelper.ThreadStart() 
2026-01-17 05:42:59.0199 DFramework.Database.Query    /* Time Taken: 661*/
[dbo].GenerateSystemAlerts 
2026-01-17 05:43:09.1483 DFramework.Scheduler.TaskBase    /* Time Taken: 10789.6373*/
Opportunity Out Of Stock By Outlet 
2026-01-17 05:57:58.9409 DFramework.Database.NullableDataReader    Data reader open for 276
   at System.Environment.GetStackTrace(Exception e, Boolean needFileInfo)
   at System.Environment.get_StackTrace()
   at DFramework.Database.NullableDataReader.Dispose(Boolean disposing) in C:\CoolR-Group\Framework\DFramework\Database\NullableDataReader.cs:line 33
   at DFramework.Database.NullableDataReader.Dispose() in C:\CoolR-Group\Framework\DFramework\Database\NullableDataReader.cs:line 44
   at CoolR.Tasks.ProcessOutletAlertData.GetAlertDefinitions() in C:\CoolR-Group\portal\CoolR.Tasks\OpportunityOutOfStockByOutlet.cs:line 490
   at CoolR.Tasks.ProcessOutletAlertData.Execute() in C:\CoolR-Group\portal\CoolR.Tasks\OpportunityOutOfStockByOutlet.cs:line 72
   at DFramework.Scheduler.TaskBase.Run() in E:\Forked\Framework\DFramework.Scheduler\TaskBase.cs:line 176
   at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)
   at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)
   at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state)
   at System.Threading.ThreadHelper.ThreadStart() 
2026-01-17 05:58:09.2371 DFramework.Scheduler.TaskBase    /* Time Taken: 10870.8256*/
Opportunity Out Of Stock By Outlet 
2026-01-17 06:12:58.8825 DFramework.Database.NullableDataReader    Data reader open for 272
   at System.Environment.GetStackTrace(Exception e, Boolean needFileInfo)
   at System.Environment.get_StackTrace()
   at DFramework.Database.NullableDataReader.Dispose(Boolean disposing) in C:\CoolR-Group\Framework\DFramework\Database\NullableDataReader.cs:line 33
   at DFramework.Database.NullableDataReader.Dispose() in C:\CoolR-Group\Framework\DFramework\Database\NullableDataReader.cs:line 44
   at CoolR.Tasks.ProcessOutletAlertData.GetAlertDefinitions() in C:\CoolR-Group\portal\CoolR.Tasks\OpportunityOutOfStockByOutlet.cs:line 490
   at CoolR.Tasks.ProcessOutletAlertData.Execute() in C:\CoolR-Group\portal\CoolR.Tasks\OpportunityOutOfStockByOutlet.cs:line 72
   at DFramework.Scheduler.TaskBase.Run() in E:\Forked\Framework\DFramework.Scheduler\TaskBase.cs:line 176
   at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)
   at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)
   at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state)
   at System.Threading.ThreadHelper.ThreadStart() 
2026-01-17 06:13:09.1869 DFramework.Scheduler.TaskBase    /* Time Taken: 10806.0389*/
Opportunity Out Of Stock By Outlet 
2026-01-17 06:28:08.7987 DFramework.Scheduler.TaskBase    /* Time Taken: 10400.2191*/
Opportunity Out Of Stock By Outlet 
2026-01-17 06:32:59.2869 MoveToReorder    Running task for ClientId : 286 and ClientName = India Office QA and Slot: 1/17/2026 8:00:00 PM And LastExecutedOn: 1/17/2026 7:02:59 PM 
2026-01-17 06:33:38.7626 DFramework.Database.NullableDataReader    Data reader open for 39181
   at System.Environment.GetStackTrace(Exception e, Boolean needFileInfo)
   at System.Environment.get_StackTrace()
   at DFramework.Database.NullableDataReader.Dispose(Boolean disposing) in C:\CoolR-Group\Framework\DFramework\Database\NullableDataReader.cs:line 33
   at DFramework.Database.NullableDataReader.Dispose() in C:\CoolR-Group\Framework\DFramework\Database\NullableDataReader.cs:line 44
   at CoolR.Tasks.MoveToReorder.Execute() in C:\CoolR-Group\portal\CoolR.Tasks\MoveToReorder.cs:line 44
   at DFramework.Scheduler.TaskBase.Run() in E:\Forked\Framework\DFramework.Scheduler\TaskBase.cs:line 176
   at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)
   at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)
   at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state)
   at System.Threading.ThreadHelper.ThreadStart() 
2026-01-17 06:33:38.7938 MoveToReorder    Task executed successfully for ClientId : 286 Client Name:India Office QA, Slot: 1/17/2026 8:00:00 PM and Total Order Suggested: 126 Out Of: 126 
2026-01-17 06:33:39.9869 DFramework.Scheduler.TaskBase    /* Time Taken: 41064.316*/
Move To Re-Order 
2026-01-17 06:42:58.7073 DFramework.Database.NullableDataReader    Data reader open for 269
   at System.Environment.GetStackTrace(Exception e, Boolean needFileInfo)
   at System.Environment.get_StackTrace()
   at DFramework.Database.NullableDataReader.Dispose(Boolean disposing) in C:\CoolR-Group\Framework\DFramework\Database\NullableDataReader.cs:line 33
   at DFramework.Database.NullableDataReader.Dispose() in C:\CoolR-Group\Framework\DFramework\Database\NullableDataReader.cs:line 44
   at CoolR.Tasks.ProcessOutletAlertData.GetAlertDefinitions() in C:\CoolR-Group\portal\CoolR.Tasks\OpportunityOutOfStockByOutlet.cs:line 490
   at CoolR.Tasks.ProcessOutletAlertData.Execute() in C:\CoolR-Group\portal\CoolR.Tasks\OpportunityOutOfStockByOutlet.cs:line 72
   at DFramework.Scheduler.TaskBase.Run() in E:\Forked\Framework\DFramework.Scheduler\TaskBase.cs:line 176
   at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)
   at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)
   at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state)
   at System.Threading.ThreadHelper.ThreadStart() 
2026-01-17 06:42:58.9429 DFramework.Database.Query    /* Time Taken: 546*/
[dbo].GenerateSystemAlerts 
2026-01-17 06:43:09.0905 DFramework.Scheduler.TaskBase    /* Time Taken: 10680.4032*/
Opportunity Out Of Stock By Outlet 
2026-01-17 06:57:58.9536 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 C:\CoolR-Group\Framework\DFramework\Database\NullableDataReader.cs:line 33
   at DFramework.Database.NullableDataReader.Dispose() in C:\CoolR-Group\Framework\DFramework\Database\NullableDataReader.cs:line 44
   at CoolR.Tasks.ProcessOutletAlertData.GetAlertDefinitions() in C:\CoolR-Group\portal\CoolR.Tasks\OpportunityOutOfStockByOutlet.cs:line 490
   at CoolR.Tasks.ProcessOutletAlertData.Execute() in C:\CoolR-Group\portal\CoolR.Tasks\OpportunityOutOfStockByOutlet.cs:line 72
   at DFramework.Scheduler.TaskBase.Run() in E:\Forked\Framework\DFramework.Scheduler\TaskBase.cs:line 176
   at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)
   at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)
   at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state)
   at System.Threading.ThreadHelper.ThreadStart() 
2026-01-17 06:58:09.2571 DFramework.Scheduler.TaskBase    /* Time Taken: 10821.804*/
Opportunity Out Of Stock By Outlet 
2026-01-17 07:12:58.9624 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 C:\CoolR-Group\Framework\DFramework\Database\NullableDataReader.cs:line 33
   at DFramework.Database.NullableDataReader.Dispose() in C:\CoolR-Group\Framework\DFramework\Database\NullableDataReader.cs:line 44
   at CoolR.Tasks.ProcessOutletAlertData.GetAlertDefinitions() in C:\CoolR-Group\portal\CoolR.Tasks\OpportunityOutOfStockByOutlet.cs:line 490
   at CoolR.Tasks.ProcessOutletAlertData.Execute() in C:\CoolR-Group\portal\CoolR.Tasks\OpportunityOutOfStockByOutlet.cs:line 72
   at DFramework.Scheduler.TaskBase.Run() in E:\Forked\Framework\DFramework.Scheduler\TaskBase.cs:line 176
   at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)
   at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)
   at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state)
   at System.Threading.ThreadHelper.ThreadStart() 
2026-01-17 07:13:09.2696 DFramework.Scheduler.TaskBase    /* Time Taken: 10825.5768*/
Opportunity Out Of Stock By Outlet 
2026-01-17 07:28:08.8354 DFramework.Scheduler.TaskBase    /* Time Taken: 10383.7747*/
Opportunity Out Of Stock By Outlet 
2026-01-17 07:32:59.4797 MoveToReorder    Running task for ClientId : 286 and ClientName = India Office QA and Slot: 1/17/2026 9:00:00 PM And LastExecutedOn: 1/17/2026 8:02:59 PM 
2026-01-17 07:32:59.7142 MoveToReorder    Task executed successfully for ClientId : 286 Client Name:India Office QA, Slot: 1/17/2026 9:00:00 PM But No Order found to suggest 
2026-01-17 07:42:58.7442 DFramework.Database.NullableDataReader    Data reader open for 267
   at System.Environment.GetStackTrace(Exception e, Boolean needFileInfo)
   at System.Environment.get_StackTrace()
   at DFramework.Database.NullableDataReader.Dispose(Boolean disposing) in C:\CoolR-Group\Framework\DFramework\Database\NullableDataReader.cs:line 33
   at DFramework.Database.NullableDataReader.Dispose() in C:\CoolR-Group\Framework\DFramework\Database\NullableDataReader.cs:line 44
   at CoolR.Tasks.ProcessOutletAlertData.GetAlertDefinitions() in C:\CoolR-Group\portal\CoolR.Tasks\OpportunityOutOfStockByOutlet.cs:line 490
   at CoolR.Tasks.ProcessOutletAlertData.Execute() in C:\CoolR-Group\portal\CoolR.Tasks\OpportunityOutOfStockByOutlet.cs:line 72
   at DFramework.Scheduler.TaskBase.Run() in E:\Forked\Framework\DFramework.Scheduler\TaskBase.cs:line 176
   at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)
   at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)
   at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state)
   at System.Threading.ThreadHelper.ThreadStart() 
2026-01-17 07:43:09.0889 DFramework.Scheduler.TaskBase    /* Time Taken: 10626.0929*/
Opportunity Out Of Stock By Outlet 
2026-01-17 07:57:58.9975 DFramework.Database.NullableDataReader    Data reader open for 272
   at System.Environment.GetStackTrace(Exception e, Boolean needFileInfo)
   at System.Environment.get_StackTrace()
   at DFramework.Database.NullableDataReader.Dispose(Boolean disposing) in C:\CoolR-Group\Framework\DFramework\Database\NullableDataReader.cs:line 33
   at DFramework.Database.NullableDataReader.Dispose() in C:\CoolR-Group\Framework\DFramework\Database\NullableDataReader.cs:line 44
   at CoolR.Tasks.ProcessOutletAlertData.GetAlertDefinitions() in C:\CoolR-Group\portal\CoolR.Tasks\OpportunityOutOfStockByOutlet.cs:line 490
   at CoolR.Tasks.ProcessOutletAlertData.Execute() in C:\CoolR-Group\portal\CoolR.Tasks\OpportunityOutOfStockByOutlet.cs:line 72
   at DFramework.Scheduler.TaskBase.Run() in E:\Forked\Framework\DFramework.Scheduler\TaskBase.cs:line 176
   at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)
   at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)
   at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state)
   at System.Threading.ThreadHelper.ThreadStart() 
2026-01-17 07:58:09.3025 DFramework.Scheduler.TaskBase    /* Time Taken: 10829.0094*/
Opportunity Out Of Stock By Outlet 
2026-01-17 08:12:59.0307 DFramework.Database.Query    /* Time Taken: 542*/
[dbo].GenerateSystemAlerts 
2026-01-17 08:12:59.0589 DFramework.Database.NullableDataReader    Data reader open for 318
   at System.Environment.GetStackTrace(Exception e, Boolean needFileInfo)
   at System.Environment.get_StackTrace()
   at DFramework.Database.NullableDataReader.Dispose(Boolean disposing) in C:\CoolR-Group\Framework\DFramework\Database\NullableDataReader.cs:line 33
   at DFramework.Database.NullableDataReader.Dispose() in C:\CoolR-Group\Framework\DFramework\Database\NullableDataReader.cs:line 44
   at CoolR.Tasks.ProcessOutletAlertData.GetAlertDefinitions() in C:\CoolR-Group\portal\CoolR.Tasks\OpportunityOutOfStockByOutlet.cs:line 490
   at CoolR.Tasks.ProcessOutletAlertData.Execute() in C:\CoolR-Group\portal\CoolR.Tasks\OpportunityOutOfStockByOutlet.cs:line 72
   at DFramework.Scheduler.TaskBase.Run() in E:\Forked\Framework\DFramework.Scheduler\TaskBase.cs:line 176
   at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)
   at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)
   at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state)
   at System.Threading.ThreadHelper.ThreadStart() 
2026-01-17 08:13:09.5151 DFramework.Scheduler.TaskBase    /* Time Taken: 11021.2069*/
Opportunity Out Of Stock By Outlet 
2026-01-17 08:15:56.0059 DFramework.Database.Query    /* Time Taken: 576*/
DECLARE @AssetPurityId Int32
SET @AssetPurityId = '3676247'
DECLARE @AssetId Int32
SET @AssetId = '118196'
DECLARE @StatusId Int32
SET @StatusId = '2'
DECLARE @PurityDateTime Date
SET @PurityDateTime = '1/16/2026 6:44:56 PM'
SELECT TOP 1 PurityDateTime, AssetPurityId, PlanogramId, Shelves, PurityStatus, AssetId, ImageReceivedFrom FROM AssetPurity
 WHERE [AssetPurityId] <= @AssetPurityId AND [AssetId] = @AssetId AND [StatusId] = @StatusId AND [PurityDateTime] > @PurityDateTime
 ORDER BY [PurityDateTime] DESC 
2026-01-17 08:27:58.8224 DFramework.Database.NullableDataReader    Data reader open for 286
   at System.Environment.GetStackTrace(Exception e, Boolean needFileInfo)
   at System.Environment.get_StackTrace()
   at DFramework.Database.NullableDataReader.Dispose(Boolean disposing) in C:\CoolR-Group\Framework\DFramework\Database\NullableDataReader.cs:line 33
   at DFramework.Database.NullableDataReader.Dispose() in C:\CoolR-Group\Framework\DFramework\Database\NullableDataReader.cs:line 44
   at CoolR.Tasks.ProcessOutletAlertData.GetAlertDefinitions() in C:\CoolR-Group\portal\CoolR.Tasks\OpportunityOutOfStockByOutlet.cs:line 490
   at CoolR.Tasks.ProcessOutletAlertData.Execute() in C:\CoolR-Group\portal\CoolR.Tasks\OpportunityOutOfStockByOutlet.cs:line 72
   at DFramework.Scheduler.TaskBase.Run() in E:\Forked\Framework\DFramework.Scheduler\TaskBase.cs:line 176
   at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)
   at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)
   at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state)
   at System.Threading.ThreadHelper.ThreadStart() 
2026-01-17 08:27:59.0122 DFramework.Database.Query    /* Time Taken: 511*/
[dbo].GenerateSystemAlerts 
2026-01-17 08:28:09.1596 DFramework.Scheduler.TaskBase    /* Time Taken: 10650.6274*/
Opportunity Out Of Stock By Outlet 
2026-01-17 08:32:59.5292 MoveToReorder    Running task for ClientId : 286 and ClientName = India Office QA and Slot: 1/17/2026 10:00:00 PM And LastExecutedOn: 1/17/2026 9:02:59 PM 
2026-01-17 08:32:59.7481 MoveToReorder    Task executed successfully for ClientId : 286 Client Name:India Office QA, Slot: 1/17/2026 10:00:00 PM But No Order found to suggest 
2026-01-17 08:42:59.0657 DFramework.Database.NullableDataReader    Data reader open for 305
   at System.Environment.GetStackTrace(Exception e, Boolean needFileInfo)
   at System.Environment.get_StackTrace()
   at DFramework.Database.NullableDataReader.Dispose(Boolean disposing) in C:\CoolR-Group\Framework\DFramework\Database\NullableDataReader.cs:line 33
   at DFramework.Database.NullableDataReader.Dispose() in C:\CoolR-Group\Framework\DFramework\Database\NullableDataReader.cs:line 44
   at CoolR.Tasks.ProcessOutletAlertData.GetAlertDefinitions() in C:\CoolR-Group\portal\CoolR.Tasks\OpportunityOutOfStockByOutlet.cs:line 490
   at CoolR.Tasks.ProcessOutletAlertData.Execute() in C:\CoolR-Group\portal\CoolR.Tasks\OpportunityOutOfStockByOutlet.cs:line 72
   at DFramework.Scheduler.TaskBase.Run() in E:\Forked\Framework\DFramework.Scheduler\TaskBase.cs:line 176
   at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)
   at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)
   at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state)
   at System.Threading.ThreadHelper.ThreadStart() 
2026-01-17 08:43:09.4122 DFramework.Scheduler.TaskBase    /* Time Taken: 10896.0366*/
Opportunity Out Of Stock By Outlet 
2026-01-17 08:57:59.0830 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 C:\CoolR-Group\Framework\DFramework\Database\NullableDataReader.cs:line 33
   at DFramework.Database.NullableDataReader.Dispose() in C:\CoolR-Group\Framework\DFramework\Database\NullableDataReader.cs:line 44
   at CoolR.Tasks.ProcessOutletAlertData.GetAlertDefinitions() in C:\CoolR-Group\portal\CoolR.Tasks\OpportunityOutOfStockByOutlet.cs:line 490
   at CoolR.Tasks.ProcessOutletAlertData.Execute() in C:\CoolR-Group\portal\CoolR.Tasks\OpportunityOutOfStockByOutlet.cs:line 72
   at DFramework.Scheduler.TaskBase.Run() in E:\Forked\Framework\DFramework.Scheduler\TaskBase.cs:line 176
   at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)
   at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)
   at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state)
   at System.Threading.ThreadHelper.ThreadStart() 
2026-01-17 08:57:59.0830 DFramework.Database.Query    /* Time Taken: 559*/
[dbo].GenerateSystemAlerts 
2026-01-17 08:58:09.4152 DFramework.Scheduler.TaskBase    /* Time Taken: 10883.1835*/
Opportunity Out Of Stock By Outlet 
2026-01-17 09:12:59.0962 DFramework.Database.NullableDataReader    Data reader open for 286
   at System.Environment.GetStackTrace(Exception e, Boolean needFileInfo)
   at System.Environment.get_StackTrace()
   at DFramework.Database.NullableDataReader.Dispose(Boolean disposing) in C:\CoolR-Group\Framework\DFramework\Database\NullableDataReader.cs:line 33
   at DFramework.Database.NullableDataReader.Dispose() in C:\CoolR-Group\Framework\DFramework\Database\NullableDataReader.cs:line 44
   at CoolR.Tasks.ProcessOutletAlertData.GetAlertDefinitions() in C:\CoolR-Group\portal\CoolR.Tasks\OpportunityOutOfStockByOutlet.cs:line 490
   at CoolR.Tasks.ProcessOutletAlertData.Execute() in C:\CoolR-Group\portal\CoolR.Tasks\OpportunityOutOfStockByOutlet.cs:line 72
   at DFramework.Scheduler.TaskBase.Run() in E:\Forked\Framework\DFramework.Scheduler\TaskBase.cs:line 176
   at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)
   at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)
   at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state)
   at System.Threading.ThreadHelper.ThreadStart() 
2026-01-17 09:13:09.4170 DFramework.Scheduler.TaskBase    /* Time Taken: 10871.6461*/
Opportunity Out Of Stock By Outlet 
2026-01-17 09:27:58.8732 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 C:\CoolR-Group\Framework\DFramework\Database\NullableDataReader.cs:line 33
   at DFramework.Database.NullableDataReader.Dispose() in C:\CoolR-Group\Framework\DFramework\Database\NullableDataReader.cs:line 44
   at CoolR.Tasks.ProcessOutletAlertData.GetAlertDefinitions() in C:\CoolR-Group\portal\CoolR.Tasks\OpportunityOutOfStockByOutlet.cs:line 490
   at CoolR.Tasks.ProcessOutletAlertData.Execute() in C:\CoolR-Group\portal\CoolR.Tasks\OpportunityOutOfStockByOutlet.cs:line 72
   at DFramework.Scheduler.TaskBase.Run() in E:\Forked\Framework\DFramework.Scheduler\TaskBase.cs:line 176
   at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)
   at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)
   at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state)
   at System.Threading.ThreadHelper.ThreadStart() 
2026-01-17 09:27:59.1623 DFramework.Database.Query    /* Time Taken: 603*/
[dbo].GenerateSystemAlerts 
2026-01-17 09:28:09.2915 DFramework.Scheduler.TaskBase    /* Time Taken: 10731.0713*/
Opportunity Out Of Stock By Outlet 
2026-01-17 09:42:59.4331 DFramework.Database.Query    /* Time Taken: 865*/
[dbo].GenerateSystemAlerts 
2026-01-17 09:43:09.1676 DFramework.Scheduler.TaskBase    /* Time Taken: 10598.2304*/
Opportunity Out Of Stock By Outlet 
2026-01-17 09:57:59.1624 DFramework.Database.NullableDataReader    Data reader open for 302
   at System.Environment.GetStackTrace(Exception e, Boolean needFileInfo)
   at System.Environment.get_StackTrace()
   at DFramework.Database.NullableDataReader.Dispose(Boolean disposing) in C:\CoolR-Group\Framework\DFramework\Database\NullableDataReader.cs:line 33
   at DFramework.Database.NullableDataReader.Dispose() in C:\CoolR-Group\Framework\DFramework\Database\NullableDataReader.cs:line 44
   at CoolR.Tasks.ProcessOutletAlertData.GetAlertDefinitions() in C:\CoolR-Group\portal\CoolR.Tasks\OpportunityOutOfStockByOutlet.cs:line 490
   at CoolR.Tasks.ProcessOutletAlertData.Execute() in C:\CoolR-Group\portal\CoolR.Tasks\OpportunityOutOfStockByOutlet.cs:line 72
   at DFramework.Scheduler.TaskBase.Run() in E:\Forked\Framework\DFramework.Scheduler\TaskBase.cs:line 176
   at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)
   at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)
   at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state)
   at System.Threading.ThreadHelper.ThreadStart() 
2026-01-17 09:58:09.4777 DFramework.Scheduler.TaskBase    /* Time Taken: 10883.3737*/
Opportunity Out Of Stock By Outlet 
2026-01-17 10:12:58.9022 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 C:\CoolR-Group\Framework\DFramework\Database\NullableDataReader.cs:line 33
   at DFramework.Database.NullableDataReader.Dispose() in C:\CoolR-Group\Framework\DFramework\Database\NullableDataReader.cs:line 44
   at CoolR.Tasks.ProcessOutletAlertData.GetAlertDefinitions() in C:\CoolR-Group\portal\CoolR.Tasks\OpportunityOutOfStockByOutlet.cs:line 490
   at CoolR.Tasks.ProcessOutletAlertData.Execute() in C:\CoolR-Group\portal\CoolR.Tasks\OpportunityOutOfStockByOutlet.cs:line 72
   at DFramework.Scheduler.TaskBase.Run() in E:\Forked\Framework\DFramework.Scheduler\TaskBase.cs:line 176
   at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)
   at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)
   at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state)
   at System.Threading.ThreadHelper.ThreadStart() 
2026-01-17 10:12:59.2179 DFramework.Database.Query    /* Time Taken: 620*/
[dbo].GenerateSystemAlerts 
2026-01-17 10:13:09.3296 DFramework.Scheduler.TaskBase    /* Time Taken: 10725.4244*/
Opportunity Out Of Stock By Outlet 
2026-01-17 10:27:58.9389 DFramework.Database.NullableDataReader    Data reader open for 291
   at System.Environment.GetStackTrace(Exception e, Boolean needFileInfo)
   at System.Environment.get_StackTrace()
   at DFramework.Database.NullableDataReader.Dispose(Boolean disposing) in C:\CoolR-Group\Framework\DFramework\Database\NullableDataReader.cs:line 33
   at DFramework.Database.NullableDataReader.Dispose() in C:\CoolR-Group\Framework\DFramework\Database\NullableDataReader.cs:line 44
   at CoolR.Tasks.ProcessOutletAlertData.GetAlertDefinitions() in C:\CoolR-Group\portal\CoolR.Tasks\OpportunityOutOfStockByOutlet.cs:line 490
   at CoolR.Tasks.ProcessOutletAlertData.Execute() in C:\CoolR-Group\portal\CoolR.Tasks\OpportunityOutOfStockByOutlet.cs:line 72
   at DFramework.Scheduler.TaskBase.Run() in E:\Forked\Framework\DFramework.Scheduler\TaskBase.cs:line 176
   at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)
   at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)
   at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state)
   at System.Threading.ThreadHelper.ThreadStart() 
2026-01-17 10:27:59.1629 DFramework.Database.Query    /* Time Taken: 542*/
[dbo].GenerateSystemAlerts 
2026-01-17 10:28:09.2913 DFramework.Scheduler.TaskBase    /* Time Taken: 10665.7663*/
Opportunity Out Of Stock By Outlet 
2026-01-17 10:42:59.1962 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 C:\CoolR-Group\Framework\DFramework\Database\NullableDataReader.cs:line 33
   at DFramework.Database.NullableDataReader.Dispose() in C:\CoolR-Group\Framework\DFramework\Database\NullableDataReader.cs:line 44
   at CoolR.Tasks.ProcessOutletAlertData.GetAlertDefinitions() in C:\CoolR-Group\portal\CoolR.Tasks\OpportunityOutOfStockByOutlet.cs:line 490
   at CoolR.Tasks.ProcessOutletAlertData.Execute() in C:\CoolR-Group\portal\CoolR.Tasks\OpportunityOutOfStockByOutlet.cs:line 72
   at DFramework.Scheduler.TaskBase.Run() in E:\Forked\Framework\DFramework.Scheduler\TaskBase.cs:line 176
   at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)
   at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)
   at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state)
   at System.Threading.ThreadHelper.ThreadStart() 
2026-01-17 10:43:09.5270 DFramework.Scheduler.TaskBase    /* Time Taken: 10886.1986*/
Opportunity Out Of Stock By Outlet 
2026-01-17 10:57:59.2036 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 C:\CoolR-Group\Framework\DFramework\Database\NullableDataReader.cs:line 33
   at DFramework.Database.NullableDataReader.Dispose() in C:\CoolR-Group\Framework\DFramework\Database\NullableDataReader.cs:line 44
   at CoolR.Tasks.ProcessOutletAlertData.GetAlertDefinitions() in C:\CoolR-Group\portal\CoolR.Tasks\OpportunityOutOfStockByOutlet.cs:line 490
   at CoolR.Tasks.ProcessOutletAlertData.Execute() in C:\CoolR-Group\portal\CoolR.Tasks\OpportunityOutOfStockByOutlet.cs:line 72
   at DFramework.Scheduler.TaskBase.Run() in E:\Forked\Framework\DFramework.Scheduler\TaskBase.cs:line 176
   at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)
   at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)
   at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state)
   at System.Threading.ThreadHelper.ThreadStart() 
2026-01-17 10:58:09.5139 DFramework.Scheduler.TaskBase    /* Time Taken: 10857.5471*/
Opportunity Out Of Stock By Outlet 
2026-01-17 11:12:58.9708 DFramework.Database.NullableDataReader    Data reader open for 277
   at System.Environment.GetStackTrace(Exception e, Boolean needFileInfo)
   at System.Environment.get_StackTrace()
   at DFramework.Database.NullableDataReader.Dispose(Boolean disposing) in C:\CoolR-Group\Framework\DFramework\Database\NullableDataReader.cs:line 33
   at DFramework.Database.NullableDataReader.Dispose() in C:\CoolR-Group\Framework\DFramework\Database\NullableDataReader.cs:line 44
   at CoolR.Tasks.ProcessOutletAlertData.GetAlertDefinitions() in C:\CoolR-Group\portal\CoolR.Tasks\OpportunityOutOfStockByOutlet.cs:line 490
   at CoolR.Tasks.ProcessOutletAlertData.Execute() in C:\CoolR-Group\portal\CoolR.Tasks\OpportunityOutOfStockByOutlet.cs:line 72
   at DFramework.Scheduler.TaskBase.Run() in E:\Forked\Framework\DFramework.Scheduler\TaskBase.cs:line 176
   at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)
   at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)
   at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state)
   at System.Threading.ThreadHelper.ThreadStart() 
2026-01-17 11:12:59.2804 DFramework.Database.Query    /* Time Taken: 607*/
[dbo].GenerateSystemAlerts 
2026-01-17 11:13:09.3886 DFramework.Scheduler.TaskBase    /* Time Taken: 10716.0661*/
Opportunity Out Of Stock By Outlet 
2026-01-17 11:27:59.0043 DFramework.Database.NullableDataReader    Data reader open for 291
   at System.Environment.GetStackTrace(Exception e, Boolean needFileInfo)
   at System.Environment.get_StackTrace()
   at DFramework.Database.NullableDataReader.Dispose(Boolean disposing) in C:\CoolR-Group\Framework\DFramework\Database\NullableDataReader.cs:line 33
   at DFramework.Database.NullableDataReader.Dispose() in C:\CoolR-Group\Framework\DFramework\Database\NullableDataReader.cs:line 44
   at CoolR.Tasks.ProcessOutletAlertData.GetAlertDefinitions() in C:\CoolR-Group\portal\CoolR.Tasks\OpportunityOutOfStockByOutlet.cs:line 490
   at CoolR.Tasks.ProcessOutletAlertData.Execute() in C:\CoolR-Group\portal\CoolR.Tasks\OpportunityOutOfStockByOutlet.cs:line 72
   at DFramework.Scheduler.TaskBase.Run() in E:\Forked\Framework\DFramework.Scheduler\TaskBase.cs:line 176
   at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)
   at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)
   at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state)
   at System.Threading.ThreadHelper.ThreadStart() 
2026-01-17 11:27:59.3078 DFramework.Database.Query    /* Time Taken: 624*/
[dbo].GenerateSystemAlerts 
2026-01-17 11:28:09.4191 DFramework.Scheduler.TaskBase    /* Time Taken: 10727.8235*/
Opportunity Out Of Stock By Outlet 
2026-01-17 11:42:59.2585 DFramework.Database.NullableDataReader    Data reader open for 291
   at System.Environment.GetStackTrace(Exception e, Boolean needFileInfo)
   at System.Environment.get_StackTrace()
   at DFramework.Database.NullableDataReader.Dispose(Boolean disposing) in C:\CoolR-Group\Framework\DFramework\Database\NullableDataReader.cs:line 33
   at DFramework.Database.NullableDataReader.Dispose() in C:\CoolR-Group\Framework\DFramework\Database\NullableDataReader.cs:line 44
   at CoolR.Tasks.ProcessOutletAlertData.GetAlertDefinitions() in C:\CoolR-Group\portal\CoolR.Tasks\OpportunityOutOfStockByOutlet.cs:line 490
   at CoolR.Tasks.ProcessOutletAlertData.Execute() in C:\CoolR-Group\portal\CoolR.Tasks\OpportunityOutOfStockByOutlet.cs:line 72
   at DFramework.Scheduler.TaskBase.Run() in E:\Forked\Framework\DFramework.Scheduler\TaskBase.cs:line 176
   at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)
   at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)
   at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state)
   at System.Threading.ThreadHelper.ThreadStart() 
2026-01-17 11:43:09.5890 DFramework.Scheduler.TaskBase    /* Time Taken: 10867.9088*/
Opportunity Out Of Stock By Outlet 
2026-01-17 11:57:59.2518 DFramework.Database.NullableDataReader    Data reader open for 290
   at System.Environment.GetStackTrace(Exception e, Boolean needFileInfo)
   at System.Environment.get_StackTrace()
   at DFramework.Database.NullableDataReader.Dispose(Boolean disposing) in C:\CoolR-Group\Framework\DFramework\Database\NullableDataReader.cs:line 33
   at DFramework.Database.NullableDataReader.Dispose() in C:\CoolR-Group\Framework\DFramework\Database\NullableDataReader.cs:line 44
   at CoolR.Tasks.ProcessOutletAlertData.GetAlertDefinitions() in C:\CoolR-Group\portal\CoolR.Tasks\OpportunityOutOfStockByOutlet.cs:line 490
   at CoolR.Tasks.ProcessOutletAlertData.Execute() in C:\CoolR-Group\portal\CoolR.Tasks\OpportunityOutOfStockByOutlet.cs:line 72
   at DFramework.Scheduler.TaskBase.Run() in E:\Forked\Framework\DFramework.Scheduler\TaskBase.cs:line 176
   at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)
   at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)
   at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state)
   at System.Threading.ThreadHelper.ThreadStart() 
2026-01-17 11:58:09.5867 DFramework.Scheduler.TaskBase    /* Time Taken: 10871.2235*/
Opportunity Out Of Stock By Outlet 
2026-01-17 12:12:59.0471 DFramework.Database.NullableDataReader    Data reader open for 284
   at System.Environment.GetStackTrace(Exception e, Boolean needFileInfo)
   at System.Environment.get_StackTrace()
   at DFramework.Database.NullableDataReader.Dispose(Boolean disposing) in C:\CoolR-Group\Framework\DFramework\Database\NullableDataReader.cs:line 33
   at DFramework.Database.NullableDataReader.Dispose() in C:\CoolR-Group\Framework\DFramework\Database\NullableDataReader.cs:line 44
   at CoolR.Tasks.ProcessOutletAlertData.GetAlertDefinitions() in C:\CoolR-Group\portal\CoolR.Tasks\OpportunityOutOfStockByOutlet.cs:line 490
   at CoolR.Tasks.ProcessOutletAlertData.Execute() in C:\CoolR-Group\portal\CoolR.Tasks\OpportunityOutOfStockByOutlet.cs:line 72
   at DFramework.Scheduler.TaskBase.Run() in E:\Forked\Framework\DFramework.Scheduler\TaskBase.cs:line 176
   at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)
   at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)
   at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state)
   at System.Threading.ThreadHelper.ThreadStart() 
2026-01-17 12:12:59.3316 DFramework.Database.Query    /* Time Taken: 603*/
[dbo].GenerateSystemAlerts 
2026-01-17 12:13:09.4308 DFramework.Scheduler.TaskBase    /* Time Taken: 10697.6522*/
Opportunity Out Of Stock By Outlet 
2026-01-17 12:27:59.0598 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 C:\CoolR-Group\Framework\DFramework\Database\NullableDataReader.cs:line 33
   at DFramework.Database.NullableDataReader.Dispose() in C:\CoolR-Group\Framework\DFramework\Database\NullableDataReader.cs:line 44
   at CoolR.Tasks.ProcessOutletAlertData.GetAlertDefinitions() in C:\CoolR-Group\portal\CoolR.Tasks\OpportunityOutOfStockByOutlet.cs:line 490
   at CoolR.Tasks.ProcessOutletAlertData.Execute() in C:\CoolR-Group\portal\CoolR.Tasks\OpportunityOutOfStockByOutlet.cs:line 72
   at DFramework.Scheduler.TaskBase.Run() in E:\Forked\Framework\DFramework.Scheduler\TaskBase.cs:line 176
   at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)
   at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)
   at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state)
   at System.Threading.ThreadHelper.ThreadStart() 
2026-01-17 12:27:59.3444 DFramework.Database.Query    /* Time Taken: 602*/
[dbo].GenerateSystemAlerts 
2026-01-17 12:28:09.4618 DFramework.Scheduler.TaskBase    /* Time Taken: 10716.3626*/
Opportunity Out Of Stock By Outlet 
2026-01-17 12:42:59.3658 DFramework.Database.NullableDataReader    Data reader open for 319
   at System.Environment.GetStackTrace(Exception e, Boolean needFileInfo)
   at System.Environment.get_StackTrace()
   at DFramework.Database.NullableDataReader.Dispose(Boolean disposing) in C:\CoolR-Group\Framework\DFramework\Database\NullableDataReader.cs:line 33
   at DFramework.Database.NullableDataReader.Dispose() in C:\CoolR-Group\Framework\DFramework\Database\NullableDataReader.cs:line 44
   at CoolR.Tasks.ProcessOutletAlertData.GetAlertDefinitions() in C:\CoolR-Group\portal\CoolR.Tasks\OpportunityOutOfStockByOutlet.cs:line 490
   at CoolR.Tasks.ProcessOutletAlertData.Execute() in C:\CoolR-Group\portal\CoolR.Tasks\OpportunityOutOfStockByOutlet.cs:line 72
   at DFramework.Scheduler.TaskBase.Run() in E:\Forked\Framework\DFramework.Scheduler\TaskBase.cs:line 176
   at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)
   at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)
   at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state)
   at System.Threading.ThreadHelper.ThreadStart() 
2026-01-17 12:42:59.4755 DFramework.Database.Query    /* Time Taken: 712*/
[dbo].GenerateSystemAlerts 
2026-01-17 12:43:09.6848 DFramework.Scheduler.TaskBase    /* Time Taken: 10918.547*/
Opportunity Out Of Stock By Outlet 
2026-01-17 12:57:59.3226 DFramework.Database.NullableDataReader    Data reader open for 286
   at System.Environment.GetStackTrace(Exception e, Boolean needFileInfo)
   at System.Environment.get_StackTrace()
   at DFramework.Database.NullableDataReader.Dispose(Boolean disposing) in C:\CoolR-Group\Framework\DFramework\Database\NullableDataReader.cs:line 33
   at DFramework.Database.NullableDataReader.Dispose() in C:\CoolR-Group\Framework\DFramework\Database\NullableDataReader.cs:line 44
   at CoolR.Tasks.ProcessOutletAlertData.GetAlertDefinitions() in C:\CoolR-Group\portal\CoolR.Tasks\OpportunityOutOfStockByOutlet.cs:line 490
   at CoolR.Tasks.ProcessOutletAlertData.Execute() in C:\CoolR-Group\portal\CoolR.Tasks\OpportunityOutOfStockByOutlet.cs:line 72
   at DFramework.Scheduler.TaskBase.Run() in E:\Forked\Framework\DFramework.Scheduler\TaskBase.cs:line 176
   at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)
   at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)
   at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state)
   at System.Threading.ThreadHelper.ThreadStart() 
2026-01-17 12:58:09.6419 DFramework.Scheduler.TaskBase    /* Time Taken: 10857.9388*/
Opportunity Out Of Stock By Outlet 
2026-01-17 13:12:59.1304 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 C:\CoolR-Group\Framework\DFramework\Database\NullableDataReader.cs:line 33
   at DFramework.Database.NullableDataReader.Dispose() in C:\CoolR-Group\Framework\DFramework\Database\NullableDataReader.cs:line 44
   at CoolR.Tasks.ProcessOutletAlertData.GetAlertDefinitions() in C:\CoolR-Group\portal\CoolR.Tasks\OpportunityOutOfStockByOutlet.cs:line 490
   at CoolR.Tasks.ProcessOutletAlertData.Execute() in C:\CoolR-Group\portal\CoolR.Tasks\OpportunityOutOfStockByOutlet.cs:line 72
   at DFramework.Scheduler.TaskBase.Run() in E:\Forked\Framework\DFramework.Scheduler\TaskBase.cs:line 176
   at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)
   at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)
   at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state)
   at System.Threading.ThreadHelper.ThreadStart() 
2026-01-17 13:12:59.3982 DFramework.Database.Query    /* Time Taken: 609*/
[dbo].GenerateSystemAlerts 
2026-01-17 13:13:09.5295 DFramework.Scheduler.TaskBase    /* Time Taken: 10729.9046*/
Opportunity Out Of Stock By Outlet 
2026-01-17 13:27:59.3441 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 C:\CoolR-Group\Framework\DFramework\Database\NullableDataReader.cs:line 33
   at DFramework.Database.NullableDataReader.Dispose() in C:\CoolR-Group\Framework\DFramework\Database\NullableDataReader.cs:line 44
   at CoolR.Tasks.ProcessOutletAlertData.GetAlertDefinitions() in C:\CoolR-Group\portal\CoolR.Tasks\OpportunityOutOfStockByOutlet.cs:line 490
   at CoolR.Tasks.ProcessOutletAlertData.Execute() in C:\CoolR-Group\portal\CoolR.Tasks\OpportunityOutOfStockByOutlet.cs:line 72
   at DFramework.Scheduler.TaskBase.Run() in E:\Forked\Framework\DFramework.Scheduler\TaskBase.cs:line 176
   at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)
   at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)
   at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state)
   at System.Threading.ThreadHelper.ThreadStart() 
2026-01-17 13:28:09.6610 DFramework.Scheduler.TaskBase    /* Time Taken: 10853.8719*/
Opportunity Out Of Stock By Outlet 
2026-01-17 13:42:59.3800 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 C:\CoolR-Group\Framework\DFramework\Database\NullableDataReader.cs:line 33
   at DFramework.Database.NullableDataReader.Dispose() in C:\CoolR-Group\Framework\DFramework\Database\NullableDataReader.cs:line 44
   at CoolR.Tasks.ProcessOutletAlertData.GetAlertDefinitions() in C:\CoolR-Group\portal\CoolR.Tasks\OpportunityOutOfStockByOutlet.cs:line 490
   at CoolR.Tasks.ProcessOutletAlertData.Execute() in C:\CoolR-Group\portal\CoolR.Tasks\OpportunityOutOfStockByOutlet.cs:line 72
   at DFramework.Scheduler.TaskBase.Run() in E:\Forked\Framework\DFramework.Scheduler\TaskBase.cs:line 176
   at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)
   at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)
   at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state)
   at System.Threading.ThreadHelper.ThreadStart() 
2026-01-17 13:43:09.7192 DFramework.Scheduler.TaskBase    /* Time Taken: 10899.2517*/
Opportunity Out Of Stock By Outlet 
2026-01-17 13:46:52.8616 DFramework.Database.NullableDataReader    Data reader open for 3869
   at System.Environment.GetStackTrace(Exception e, Boolean needFileInfo)
   at System.Environment.get_StackTrace()
   at DFramework.Database.NullableDataReader.Dispose(Boolean disposing) in C:\CoolR-Group\Framework\DFramework\Database\NullableDataReader.cs:line 33
   at DFramework.Database.NullableDataReader.Dispose() in C:\CoolR-Group\Framework\DFramework\Database\NullableDataReader.cs:line 44
   at CoolR.Tasks.ProcessAlertData.LoadStockData(Int32 currentRecordId, DateTime startDate, DateTime latestEventTime, Int32 assetId, Boolean isComingFromStockLow) in C:\CoolR-Group\portal\CoolR.Tasks\ProcessAlertData.cs:line 1612
   at CoolR.Tasks.ProcessAlertData.StockAlertProductWise(Int32 alertId, Int32 currentRecordId, DateTime latestEventTime, Boolean isForAllProduct, Int32 stockThreshold, Int32 assetId, String alertText, Int32 alertDefinitionId, DateTime startDate, DateTime endDate, Int32 clientId, Int32 locationId, Int32 priorityId) in C:\CoolR-Group\portal\CoolR.Tasks\ProcessAlertData.cs:line 1379
   at CoolR.Tasks.ProcessAlertData.Execute() in C:\CoolR-Group\portal\CoolR.Tasks\ProcessAlertData.cs:line 343
   at DFramework.Scheduler.TaskBase.Run() in E:\Forked\Framework\DFramework.Scheduler\TaskBase.cs:line 176
   at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)
   at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)
   at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state)
   at System.Threading.ThreadHelper.ThreadStart() 
2026-01-17 13:57:59.3905 DFramework.Database.NullableDataReader    Data reader open for 286
   at System.Environment.GetStackTrace(Exception e, Boolean needFileInfo)
   at System.Environment.get_StackTrace()
   at DFramework.Database.NullableDataReader.Dispose(Boolean disposing) in C:\CoolR-Group\Framework\DFramework\Database\NullableDataReader.cs:line 33
   at DFramework.Database.NullableDataReader.Dispose() in C:\CoolR-Group\Framework\DFramework\Database\NullableDataReader.cs:line 44
   at CoolR.Tasks.ProcessOutletAlertData.GetAlertDefinitions() in C:\CoolR-Group\portal\CoolR.Tasks\OpportunityOutOfStockByOutlet.cs:line 490
   at CoolR.Tasks.ProcessOutletAlertData.Execute() in C:\CoolR-Group\portal\CoolR.Tasks\OpportunityOutOfStockByOutlet.cs:line 72
   at DFramework.Scheduler.TaskBase.Run() in E:\Forked\Framework\DFramework.Scheduler\TaskBase.cs:line 176
   at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)
   at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)
   at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state)
   at System.Threading.ThreadHelper.ThreadStart() 
2026-01-17 13:58:09.7106 DFramework.Scheduler.TaskBase    /* Time Taken: 10871.9043*/
Opportunity Out Of Stock By Outlet 
2026-01-17 14:12:59.1649 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 C:\CoolR-Group\Framework\DFramework\Database\NullableDataReader.cs:line 33
   at DFramework.Database.NullableDataReader.Dispose() in C:\CoolR-Group\Framework\DFramework\Database\NullableDataReader.cs:line 44
   at CoolR.Tasks.ProcessOutletAlertData.GetAlertDefinitions() in C:\CoolR-Group\portal\CoolR.Tasks\OpportunityOutOfStockByOutlet.cs:line 490
   at CoolR.Tasks.ProcessOutletAlertData.Execute() in C:\CoolR-Group\portal\CoolR.Tasks\OpportunityOutOfStockByOutlet.cs:line 72
   at DFramework.Scheduler.TaskBase.Run() in E:\Forked\Framework\DFramework.Scheduler\TaskBase.cs:line 176
   at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)
   at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)
   at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state)
   at System.Threading.ThreadHelper.ThreadStart() 
2026-01-17 14:12:59.4572 DFramework.Database.Query    /* Time Taken: 607*/
[dbo].GenerateSystemAlerts 
2026-01-17 14:13:09.5722 DFramework.Scheduler.TaskBase    /* Time Taken: 10719.1233*/
Opportunity Out Of Stock By Outlet 
2026-01-17 14:27:59.4033 DFramework.Database.NullableDataReader    Data reader open for 290
   at System.Environment.GetStackTrace(Exception e, Boolean needFileInfo)
   at System.Environment.get_StackTrace()
   at DFramework.Database.NullableDataReader.Dispose(Boolean disposing) in C:\CoolR-Group\Framework\DFramework\Database\NullableDataReader.cs:line 33
   at DFramework.Database.NullableDataReader.Dispose() in C:\CoolR-Group\Framework\DFramework\Database\NullableDataReader.cs:line 44
   at CoolR.Tasks.ProcessOutletAlertData.GetAlertDefinitions() in C:\CoolR-Group\portal\CoolR.Tasks\OpportunityOutOfStockByOutlet.cs:line 490
   at CoolR.Tasks.ProcessOutletAlertData.Execute() in C:\CoolR-Group\portal\CoolR.Tasks\OpportunityOutOfStockByOutlet.cs:line 72
   at DFramework.Scheduler.TaskBase.Run() in E:\Forked\Framework\DFramework.Scheduler\TaskBase.cs:line 176
   at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)
   at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)
   at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state)
   at System.Threading.ThreadHelper.ThreadStart() 
2026-01-17 14:28:09.7199 DFramework.Scheduler.TaskBase    /* Time Taken: 10853.1821*/
Opportunity Out Of Stock By Outlet 
2026-01-17 14:39:03.0040 DFramework.Database.Query    /* Time Taken: 583*/
DECLARE @AssetPurityId Int32
SET @AssetPurityId = '3676247'
DECLARE @AssetId Int32
SET @AssetId = '118196'
DECLARE @StatusId Int32
SET @StatusId = '2'
DECLARE @PurityDateTime Date
SET @PurityDateTime = '1/16/2026 6:44:56 PM'
SELECT TOP 1 PurityDateTime, AssetPurityId, PlanogramId, Shelves, PurityStatus, AssetId, ImageReceivedFrom FROM AssetPurity
 WHERE [AssetPurityId] <= @AssetPurityId AND [AssetId] = @AssetId AND [StatusId] = @StatusId AND [PurityDateTime] > @PurityDateTime
 ORDER BY [PurityDateTime] DESC 
2026-01-17 14:42:59.4613 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 C:\CoolR-Group\Framework\DFramework\Database\NullableDataReader.cs:line 33
   at DFramework.Database.NullableDataReader.Dispose() in C:\CoolR-Group\Framework\DFramework\Database\NullableDataReader.cs:line 44
   at CoolR.Tasks.ProcessOutletAlertData.GetAlertDefinitions() in C:\CoolR-Group\portal\CoolR.Tasks\OpportunityOutOfStockByOutlet.cs:line 490
   at CoolR.Tasks.ProcessOutletAlertData.Execute() in C:\CoolR-Group\portal\CoolR.Tasks\OpportunityOutOfStockByOutlet.cs:line 72
   at DFramework.Scheduler.TaskBase.Run() in E:\Forked\Framework\DFramework.Scheduler\TaskBase.cs:line 176
   at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)
   at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)
   at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state)
   at System.Threading.ThreadHelper.ThreadStart() 
2026-01-17 14:42:59.4613 DFramework.Database.Query    /* Time Taken: 588*/
[dbo].GenerateSystemAlerts 
2026-01-17 14:43:09.7682 DFramework.Scheduler.TaskBase    /* Time Taken: 10882.1908*/
Opportunity Out Of Stock By Outlet 
2026-01-17 14:57:59.1943 DFramework.Database.NullableDataReader    Data reader open for 277
   at System.Environment.GetStackTrace(Exception e, Boolean needFileInfo)
   at System.Environment.get_StackTrace()
   at DFramework.Database.NullableDataReader.Dispose(Boolean disposing) in C:\CoolR-Group\Framework\DFramework\Database\NullableDataReader.cs:line 33
   at DFramework.Database.NullableDataReader.Dispose() in C:\CoolR-Group\Framework\DFramework\Database\NullableDataReader.cs:line 44
   at CoolR.Tasks.ProcessOutletAlertData.GetAlertDefinitions() in C:\CoolR-Group\portal\CoolR.Tasks\OpportunityOutOfStockByOutlet.cs:line 490
   at CoolR.Tasks.ProcessOutletAlertData.Execute() in C:\CoolR-Group\portal\CoolR.Tasks\OpportunityOutOfStockByOutlet.cs:line 72
   at DFramework.Scheduler.TaskBase.Run() in E:\Forked\Framework\DFramework.Scheduler\TaskBase.cs:line 176
   at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)
   at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)
   at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state)
   at System.Threading.ThreadHelper.ThreadStart() 
2026-01-17 14:57:59.4943 DFramework.Database.Query    /* Time Taken: 600*/
[dbo].GenerateSystemAlerts 
2026-01-17 14:58:09.6076 DFramework.Scheduler.TaskBase    /* Time Taken: 10713.8336*/
Opportunity Out Of Stock By Outlet 
2026-01-17 15:12:59.2225 DFramework.Database.NullableDataReader    Data reader open for 291
   at System.Environment.GetStackTrace(Exception e, Boolean needFileInfo)
   at System.Environment.get_StackTrace()
   at DFramework.Database.NullableDataReader.Dispose(Boolean disposing) in C:\CoolR-Group\Framework\DFramework\Database\NullableDataReader.cs:line 33
   at DFramework.Database.NullableDataReader.Dispose() in C:\CoolR-Group\Framework\DFramework\Database\NullableDataReader.cs:line 44
   at CoolR.Tasks.ProcessOutletAlertData.GetAlertDefinitions() in C:\CoolR-Group\portal\CoolR.Tasks\OpportunityOutOfStockByOutlet.cs:line 490
   at CoolR.Tasks.ProcessOutletAlertData.Execute() in C:\CoolR-Group\portal\CoolR.Tasks\OpportunityOutOfStockByOutlet.cs:line 72
   at DFramework.Scheduler.TaskBase.Run() in E:\Forked\Framework\DFramework.Scheduler\TaskBase.cs:line 176
   at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)
   at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)
   at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state)
   at System.Threading.ThreadHelper.ThreadStart() 
2026-01-17 15:12:59.5224 DFramework.Database.Query    /* Time Taken: 614*/
[dbo].GenerateSystemAlerts 
2026-01-17 15:13:09.6315 DFramework.Scheduler.TaskBase    /* Time Taken: 10724.3233*/
Opportunity Out Of Stock By Outlet 
2026-01-17 15:27:59.4547 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 C:\CoolR-Group\Framework\DFramework\Database\NullableDataReader.cs:line 33
   at DFramework.Database.NullableDataReader.Dispose() in C:\CoolR-Group\Framework\DFramework\Database\NullableDataReader.cs:line 44
   at CoolR.Tasks.ProcessOutletAlertData.GetAlertDefinitions() in C:\CoolR-Group\portal\CoolR.Tasks\OpportunityOutOfStockByOutlet.cs:line 490
   at CoolR.Tasks.ProcessOutletAlertData.Execute() in C:\CoolR-Group\portal\CoolR.Tasks\OpportunityOutOfStockByOutlet.cs:line 72
   at DFramework.Scheduler.TaskBase.Run() in E:\Forked\Framework\DFramework.Scheduler\TaskBase.cs:line 176
   at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)
   at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)
   at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state)
   at System.Threading.ThreadHelper.ThreadStart() 
2026-01-17 15:28:09.7590 DFramework.Scheduler.TaskBase    /* Time Taken: 10841.2639*/
Opportunity Out Of Stock By Outlet 
2026-01-17 15:42:59.4881 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 C:\CoolR-Group\Framework\DFramework\Database\NullableDataReader.cs:line 33
   at DFramework.Database.NullableDataReader.Dispose() in C:\CoolR-Group\Framework\DFramework\Database\NullableDataReader.cs:line 44
   at CoolR.Tasks.ProcessOutletAlertData.GetAlertDefinitions() in C:\CoolR-Group\portal\CoolR.Tasks\OpportunityOutOfStockByOutlet.cs:line 490
   at CoolR.Tasks.ProcessOutletAlertData.Execute() in C:\CoolR-Group\portal\CoolR.Tasks\OpportunityOutOfStockByOutlet.cs:line 72
   at DFramework.Scheduler.TaskBase.Run() in E:\Forked\Framework\DFramework.Scheduler\TaskBase.cs:line 176
   at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)
   at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)
   at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state)
   at System.Threading.ThreadHelper.ThreadStart() 
2026-01-17 15:43:09.8228 DFramework.Scheduler.TaskBase    /* Time Taken: 10887.185*/
Opportunity Out Of Stock By Outlet 
2026-01-17 15:57:59.2483 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 C:\CoolR-Group\Framework\DFramework\Database\NullableDataReader.cs:line 33
   at DFramework.Database.NullableDataReader.Dispose() in C:\CoolR-Group\Framework\DFramework\Database\NullableDataReader.cs:line 44
   at CoolR.Tasks.ProcessOutletAlertData.GetAlertDefinitions() in C:\CoolR-Group\portal\CoolR.Tasks\OpportunityOutOfStockByOutlet.cs:line 490
   at CoolR.Tasks.ProcessOutletAlertData.Execute() in C:\CoolR-Group\portal\CoolR.Tasks\OpportunityOutOfStockByOutlet.cs:line 72
   at DFramework.Scheduler.TaskBase.Run() in E:\Forked\Framework\DFramework.Scheduler\TaskBase.cs:line 176
   at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)
   at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)
   at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state)
   at System.Threading.ThreadHelper.ThreadStart() 
2026-01-17 15:57:59.4961 DFramework.Database.Query    /* Time Taken: 546*/
[dbo].GenerateSystemAlerts 
2026-01-17 15:58:09.6017 DFramework.Scheduler.TaskBase    /* Time Taken: 10653.5824*/
Opportunity Out Of Stock By Outlet 
2026-01-17 16:12:59.2868 DFramework.Database.NullableDataReader    Data reader open for 294
   at System.Environment.GetStackTrace(Exception e, Boolean needFileInfo)
   at System.Environment.get_StackTrace()
   at DFramework.Database.NullableDataReader.Dispose(Boolean disposing) in C:\CoolR-Group\Framework\DFramework\Database\NullableDataReader.cs:line 33
   at DFramework.Database.NullableDataReader.Dispose() in C:\CoolR-Group\Framework\DFramework\Database\NullableDataReader.cs:line 44
   at CoolR.Tasks.ProcessOutletAlertData.GetAlertDefinitions() in C:\CoolR-Group\portal\CoolR.Tasks\OpportunityOutOfStockByOutlet.cs:line 490
   at CoolR.Tasks.ProcessOutletAlertData.Execute() in C:\CoolR-Group\portal\CoolR.Tasks\OpportunityOutOfStockByOutlet.cs:line 72
   at DFramework.Scheduler.TaskBase.Run() in E:\Forked\Framework\DFramework.Scheduler\TaskBase.cs:line 176
   at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)
   at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)
   at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state)
   at System.Threading.ThreadHelper.ThreadStart() 
2026-01-17 16:12:59.4929 DFramework.Database.Query    /* Time Taken: 536*/
[dbo].GenerateSystemAlerts 
2026-01-17 16:13:09.6547 DFramework.Scheduler.TaskBase    /* Time Taken: 10699.3067*/
Opportunity Out Of Stock By Outlet 
2026-01-17 16:27:59.5576 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 C:\CoolR-Group\Framework\DFramework\Database\NullableDataReader.cs:line 33
   at DFramework.Database.NullableDataReader.Dispose() in C:\CoolR-Group\Framework\DFramework\Database\NullableDataReader.cs:line 44
   at CoolR.Tasks.ProcessOutletAlertData.GetAlertDefinitions() in C:\CoolR-Group\portal\CoolR.Tasks\OpportunityOutOfStockByOutlet.cs:line 490
   at CoolR.Tasks.ProcessOutletAlertData.Execute() in C:\CoolR-Group\portal\CoolR.Tasks\OpportunityOutOfStockByOutlet.cs:line 72
   at DFramework.Scheduler.TaskBase.Run() in E:\Forked\Framework\DFramework.Scheduler\TaskBase.cs:line 176
   at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)
   at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)
   at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state)
   at System.Threading.ThreadHelper.ThreadStart() 
2026-01-17 16:28:09.8733 DFramework.Scheduler.TaskBase    /* Time Taken: 10900.7995*/
Opportunity Out Of Stock By Outlet 
2026-01-17 16:42:59.5643 DFramework.Database.NullableDataReader    Data reader open for 315
   at System.Environment.GetStackTrace(Exception e, Boolean needFileInfo)
   at System.Environment.get_StackTrace()
   at DFramework.Database.NullableDataReader.Dispose(Boolean disposing) in C:\CoolR-Group\Framework\DFramework\Database\NullableDataReader.cs:line 33
   at DFramework.Database.NullableDataReader.Dispose() in C:\CoolR-Group\Framework\DFramework\Database\NullableDataReader.cs:line 44
   at CoolR.Tasks.ProcessOutletAlertData.GetAlertDefinitions() in C:\CoolR-Group\portal\CoolR.Tasks\OpportunityOutOfStockByOutlet.cs:line 490
   at CoolR.Tasks.ProcessOutletAlertData.Execute() in C:\CoolR-Group\portal\CoolR.Tasks\OpportunityOutOfStockByOutlet.cs:line 72
   at DFramework.Scheduler.TaskBase.Run() in E:\Forked\Framework\DFramework.Scheduler\TaskBase.cs:line 176
   at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)
   at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)
   at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state)
   at System.Threading.ThreadHelper.ThreadStart() 
2026-01-17 16:43:10.0588 DFramework.Scheduler.TaskBase    /* Time Taken: 11064.6751*/
Opportunity Out Of Stock By Outlet 
2026-01-17 16:57:59.3347 DFramework.Database.NullableDataReader    Data reader open for 293
   at System.Environment.GetStackTrace(Exception e, Boolean needFileInfo)
   at System.Environment.get_StackTrace()
   at DFramework.Database.NullableDataReader.Dispose(Boolean disposing) in C:\CoolR-Group\Framework\DFramework\Database\NullableDataReader.cs:line 33
   at DFramework.Database.NullableDataReader.Dispose() in C:\CoolR-Group\Framework\DFramework\Database\NullableDataReader.cs:line 44
   at CoolR.Tasks.ProcessOutletAlertData.GetAlertDefinitions() in C:\CoolR-Group\portal\CoolR.Tasks\OpportunityOutOfStockByOutlet.cs:line 490
   at CoolR.Tasks.ProcessOutletAlertData.Execute() in C:\CoolR-Group\portal\CoolR.Tasks\OpportunityOutOfStockByOutlet.cs:line 72
   at DFramework.Scheduler.TaskBase.Run() in E:\Forked\Framework\DFramework.Scheduler\TaskBase.cs:line 176
   at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)
   at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)
   at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state)
   at System.Threading.ThreadHelper.ThreadStart() 
2026-01-17 16:57:59.5384 DFramework.Database.Query    /* Time Taken: 520*/
[dbo].GenerateSystemAlerts 
2026-01-17 16:58:09.6814 DFramework.Scheduler.TaskBase    /* Time Taken: 10663.3921*/
Opportunity Out Of Stock By Outlet 
2026-01-17 17:05:07.4832 DFramework.Database.Query    /* Time Taken: 719*/
DECLARE @AssetPurityId Int32
SET @AssetPurityId = '3676247'
DECLARE @AssetId Int32
SET @AssetId = '118196'
DECLARE @StatusId Int32
SET @StatusId = '2'
DECLARE @PurityDateTime Date
SET @PurityDateTime = '1/16/2026 6:44:56 PM'
SELECT TOP 1 PurityDateTime, AssetPurityId, PlanogramId, Shelves, PurityStatus, AssetId, ImageReceivedFrom FROM AssetPurity
 WHERE [AssetPurityId] <= @AssetPurityId AND [AssetId] = @AssetId AND [StatusId] = @StatusId AND [PurityDateTime] > @PurityDateTime
 ORDER BY [PurityDateTime] DESC 
2026-01-17 17:05:08.7812 DFramework.Database.Query    /* Time Taken: 751*/
DECLARE @AssetPurityId Int32
SET @AssetPurityId = '3676247'
DECLARE @AssetId Int32
SET @AssetId = '118196'
DECLARE @StatusId Int32
SET @StatusId = '2'
DECLARE @PurityDateTime Date
SET @PurityDateTime = '1/16/2026 6:44:56 PM'
SELECT TOP 1 PurityDateTime, AssetPurityId, PlanogramId, Shelves, PurityStatus, AssetId, ImageReceivedFrom FROM AssetPurity
 WHERE [AssetPurityId] <= @AssetPurityId AND [AssetId] = @AssetId AND [StatusId] = @StatusId AND [PurityDateTime] > @PurityDateTime
 ORDER BY [PurityDateTime] DESC 
2026-01-17 17:05:10.1626 DFramework.Database.Query    /* Time Taken: 719*/
DECLARE @AssetPurityId Int32
SET @AssetPurityId = '3676247'
DECLARE @AssetId Int32
SET @AssetId = '118196'
DECLARE @StatusId Int32
SET @StatusId = '2'
DECLARE @PurityDateTime Date
SET @PurityDateTime = '1/16/2026 6:44:56 PM'
SELECT TOP 1 PurityDateTime, AssetPurityId, PlanogramId, Shelves, PurityStatus, AssetId, ImageReceivedFrom FROM AssetPurity
 WHERE [AssetPurityId] <= @AssetPurityId AND [AssetId] = @AssetId AND [StatusId] = @StatusId AND [PurityDateTime] > @PurityDateTime
 ORDER BY [PurityDateTime] DESC 
2026-01-17 17:05:12.2260 DFramework.Database.Query    /* Time Taken: 1655*/
DECLARE @AssetPurityId Int32
SET @AssetPurityId = '3676247'
DECLARE @AssetId Int32
SET @AssetId = '118196'
DECLARE @StatusId Int32
SET @StatusId = '2'
DECLARE @PurityDateTime Date
SET @PurityDateTime = '1/16/2026 6:44:56 PM'
SELECT TOP 1 PurityDateTime, AssetPurityId, PlanogramId, Shelves, PurityStatus, AssetId, ImageReceivedFrom FROM AssetPurity
 WHERE [AssetPurityId] <= @AssetPurityId AND [AssetId] = @AssetId AND [StatusId] = @StatusId AND [PurityDateTime] > @PurityDateTime
 ORDER BY [PurityDateTime] DESC 
2026-01-17 17:05:14.7211 DFramework.Database.Query    /* Time Taken: 1892*/
DECLARE @AssetPurityId Int32
SET @AssetPurityId = '3676247'
DECLARE @AssetId Int32
SET @AssetId = '118196'
DECLARE @StatusId Int32
SET @StatusId = '2'
DECLARE @PurityDateTime Date
SET @PurityDateTime = '1/16/2026 6:44:56 PM'
SELECT TOP 1 PurityDateTime, AssetPurityId, PlanogramId, Shelves, PurityStatus, AssetId, ImageReceivedFrom FROM AssetPurity
 WHERE [AssetPurityId] <= @AssetPurityId AND [AssetId] = @AssetId AND [StatusId] = @StatusId AND [PurityDateTime] > @PurityDateTime
 ORDER BY [PurityDateTime] DESC 
2026-01-17 17:12:59.3758 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 C:\CoolR-Group\Framework\DFramework\Database\NullableDataReader.cs:line 33
   at DFramework.Database.NullableDataReader.Dispose() in C:\CoolR-Group\Framework\DFramework\Database\NullableDataReader.cs:line 44
   at CoolR.Tasks.ProcessOutletAlertData.GetAlertDefinitions() in C:\CoolR-Group\portal\CoolR.Tasks\OpportunityOutOfStockByOutlet.cs:line 490
   at CoolR.Tasks.ProcessOutletAlertData.Execute() in C:\CoolR-Group\portal\CoolR.Tasks\OpportunityOutOfStockByOutlet.cs:line 72
   at DFramework.Scheduler.TaskBase.Run() in E:\Forked\Framework\DFramework.Scheduler\TaskBase.cs:line 176
   at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)
   at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)
   at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state)
   at System.Threading.ThreadHelper.ThreadStart() 
2026-01-17 17:12:59.5942 DFramework.Database.Query    /* Time Taken: 577*/
[dbo].GenerateSystemAlerts 
2026-01-17 17:13:09.7846 DFramework.Scheduler.TaskBase    /* Time Taken: 10757.6392*/
Opportunity Out Of Stock By Outlet 
2026-01-17 17:27:59.5994 DFramework.Database.NullableDataReader    Data reader open for 298
   at System.Environment.GetStackTrace(Exception e, Boolean needFileInfo)
   at System.Environment.get_StackTrace()
   at DFramework.Database.NullableDataReader.Dispose(Boolean disposing) in C:\CoolR-Group\Framework\DFramework\Database\NullableDataReader.cs:line 33
   at DFramework.Database.NullableDataReader.Dispose() in C:\CoolR-Group\Framework\DFramework\Database\NullableDataReader.cs:line 44
   at CoolR.Tasks.ProcessOutletAlertData.GetAlertDefinitions() in C:\CoolR-Group\portal\CoolR.Tasks\OpportunityOutOfStockByOutlet.cs:line 490
   at CoolR.Tasks.ProcessOutletAlertData.Execute() in C:\CoolR-Group\portal\CoolR.Tasks\OpportunityOutOfStockByOutlet.cs:line 72
   at DFramework.Scheduler.TaskBase.Run() in E:\Forked\Framework\DFramework.Scheduler\TaskBase.cs:line 176
   at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)
   at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)
   at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state)
   at System.Threading.ThreadHelper.ThreadStart() 
2026-01-17 17:28:09.9207 DFramework.Scheduler.TaskBase    /* Time Taken: 10872.8149*/
Opportunity Out Of Stock By Outlet 
2026-01-17 17:42:59.6010 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 C:\CoolR-Group\Framework\DFramework\Database\NullableDataReader.cs:line 33
   at DFramework.Database.NullableDataReader.Dispose() in C:\CoolR-Group\Framework\DFramework\Database\NullableDataReader.cs:line 44
   at CoolR.Tasks.ProcessOutletAlertData.GetAlertDefinitions() in C:\CoolR-Group\portal\CoolR.Tasks\OpportunityOutOfStockByOutlet.cs:line 490
   at CoolR.Tasks.ProcessOutletAlertData.Execute() in C:\CoolR-Group\portal\CoolR.Tasks\OpportunityOutOfStockByOutlet.cs:line 72
   at DFramework.Scheduler.TaskBase.Run() in E:\Forked\Framework\DFramework.Scheduler\TaskBase.cs:line 176
   at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)
   at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)
   at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state)
   at System.Threading.ThreadHelper.ThreadStart() 
2026-01-17 17:43:09.9199 DFramework.Scheduler.TaskBase    /* Time Taken: 10855.8554*/
Opportunity Out Of Stock By Outlet 
2026-01-17 17:57:59.4298 DFramework.Database.NullableDataReader    Data reader open for 301
   at System.Environment.GetStackTrace(Exception e, Boolean needFileInfo)
   at System.Environment.get_StackTrace()
   at DFramework.Database.NullableDataReader.Dispose(Boolean disposing) in C:\CoolR-Group\Framework\DFramework\Database\NullableDataReader.cs:line 33
   at DFramework.Database.NullableDataReader.Dispose() in C:\CoolR-Group\Framework\DFramework\Database\NullableDataReader.cs:line 44
   at CoolR.Tasks.ProcessOutletAlertData.GetAlertDefinitions() in C:\CoolR-Group\portal\CoolR.Tasks\OpportunityOutOfStockByOutlet.cs:line 490
   at CoolR.Tasks.ProcessOutletAlertData.Execute() in C:\CoolR-Group\portal\CoolR.Tasks\OpportunityOutOfStockByOutlet.cs:line 72
   at DFramework.Scheduler.TaskBase.Run() in E:\Forked\Framework\DFramework.Scheduler\TaskBase.cs:line 176
   at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)
   at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)
   at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state)
   at System.Threading.ThreadHelper.ThreadStart() 
2026-01-17 17:57:59.6652 DFramework.Database.Query    /* Time Taken: 590*/
[dbo].GenerateSystemAlerts 
2026-01-17 17:58:09.8589 DFramework.Scheduler.TaskBase    /* Time Taken: 10775.3532*/
Opportunity Out Of Stock By Outlet 
2026-01-17 18:12:59.6435 DFramework.Database.NullableDataReader    Data reader open for 290
   at System.Environment.GetStackTrace(Exception e, Boolean needFileInfo)
   at System.Environment.get_StackTrace()
   at DFramework.Database.NullableDataReader.Dispose(Boolean disposing) in C:\CoolR-Group\Framework\DFramework\Database\NullableDataReader.cs:line 33
   at DFramework.Database.NullableDataReader.Dispose() in C:\CoolR-Group\Framework\DFramework\Database\NullableDataReader.cs:line 44
   at CoolR.Tasks.ProcessOutletAlertData.GetAlertDefinitions() in C:\CoolR-Group\portal\CoolR.Tasks\OpportunityOutOfStockByOutlet.cs:line 490
   at CoolR.Tasks.ProcessOutletAlertData.Execute() in C:\CoolR-Group\portal\CoolR.Tasks\OpportunityOutOfStockByOutlet.cs:line 72
   at DFramework.Scheduler.TaskBase.Run() in E:\Forked\Framework\DFramework.Scheduler\TaskBase.cs:line 176
   at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)
   at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)
   at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state)
   at System.Threading.ThreadHelper.ThreadStart() 
2026-01-17 18:13:09.9661 DFramework.Scheduler.TaskBase    /* Time Taken: 10874.1856*/
Opportunity Out Of Stock By Outlet 
2026-01-17 18:27:59.6979 DFramework.Database.NullableDataReader    Data reader open for 291
   at System.Environment.GetStackTrace(Exception e, Boolean needFileInfo)
   at System.Environment.get_StackTrace()
   at DFramework.Database.NullableDataReader.Dispose(Boolean disposing) in C:\CoolR-Group\Framework\DFramework\Database\NullableDataReader.cs:line 33
   at DFramework.Database.NullableDataReader.Dispose() in C:\CoolR-Group\Framework\DFramework\Database\NullableDataReader.cs:line 44
   at CoolR.Tasks.ProcessOutletAlertData.GetAlertDefinitions() in C:\CoolR-Group\portal\CoolR.Tasks\OpportunityOutOfStockByOutlet.cs:line 490
   at CoolR.Tasks.ProcessOutletAlertData.Execute() in C:\CoolR-Group\portal\CoolR.Tasks\OpportunityOutOfStockByOutlet.cs:line 72
   at DFramework.Scheduler.TaskBase.Run() in E:\Forked\Framework\DFramework.Scheduler\TaskBase.cs:line 176
   at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)
   at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)
   at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state)
   at System.Threading.ThreadHelper.ThreadStart() 
2026-01-17 18:28:10.0351 DFramework.Scheduler.TaskBase    /* Time Taken: 10922.8986*/
Opportunity Out Of Stock By Outlet 
2026-01-17 18:42:59.7126 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 C:\CoolR-Group\Framework\DFramework\Database\NullableDataReader.cs:line 33
   at DFramework.Database.NullableDataReader.Dispose() in C:\CoolR-Group\Framework\DFramework\Database\NullableDataReader.cs:line 44
   at CoolR.Tasks.ProcessOutletAlertData.GetAlertDefinitions() in C:\CoolR-Group\portal\CoolR.Tasks\OpportunityOutOfStockByOutlet.cs:line 490
   at CoolR.Tasks.ProcessOutletAlertData.Execute() in C:\CoolR-Group\portal\CoolR.Tasks\OpportunityOutOfStockByOutlet.cs:line 72
   at DFramework.Scheduler.TaskBase.Run() in E:\Forked\Framework\DFramework.Scheduler\TaskBase.cs:line 176
   at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)
   at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)
   at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state)
   at System.Threading.ThreadHelper.ThreadStart() 
2026-01-17 18:43:10.0598 DFramework.Scheduler.TaskBase    /* Time Taken: 10928.9166*/
Opportunity Out Of Stock By Outlet 
2026-01-17 18:50:21.4367 DFramework.Database.Query    /* Time Taken: 533*/
DECLARE @AssetPurityId Int32
SET @AssetPurityId = '3676247'
DECLARE @AssetId Int32
SET @AssetId = '118196'
DECLARE @StatusId Int32
SET @StatusId = '2'
DECLARE @PurityDateTime Date
SET @PurityDateTime = '1/16/2026 6:44:56 PM'
SELECT TOP 1 PurityDateTime, AssetPurityId, PlanogramId, Shelves, PurityStatus, AssetId, ImageReceivedFrom FROM AssetPurity
 WHERE [AssetPurityId] <= @AssetPurityId AND [AssetId] = @AssetId AND [StatusId] = @StatusId AND [PurityDateTime] > @PurityDateTime
 ORDER BY [PurityDateTime] DESC 
2026-01-17 18:57:59.5141 DFramework.Database.NullableDataReader    Data reader open for 287
   at System.Environment.GetStackTrace(Exception e, Boolean needFileInfo)
   at System.Environment.get_StackTrace()
   at DFramework.Database.NullableDataReader.Dispose(Boolean disposing) in C:\CoolR-Group\Framework\DFramework\Database\NullableDataReader.cs:line 33
   at DFramework.Database.NullableDataReader.Dispose() in C:\CoolR-Group\Framework\DFramework\Database\NullableDataReader.cs:line 44
   at CoolR.Tasks.ProcessOutletAlertData.GetAlertDefinitions() in C:\CoolR-Group\portal\CoolR.Tasks\OpportunityOutOfStockByOutlet.cs:line 490
   at CoolR.Tasks.ProcessOutletAlertData.Execute() in C:\CoolR-Group\portal\CoolR.Tasks\OpportunityOutOfStockByOutlet.cs:line 72
   at DFramework.Scheduler.TaskBase.Run() in E:\Forked\Framework\DFramework.Scheduler\TaskBase.cs:line 176
   at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)
   at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)
   at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state)
   at System.Threading.ThreadHelper.ThreadStart() 
2026-01-17 18:57:59.7332 DFramework.Database.Query    /* Time Taken: 582*/
[dbo].GenerateSystemAlerts 
2026-01-17 18:58:09.9223 DFramework.Scheduler.TaskBase    /* Time Taken: 10771.6415*/
Opportunity Out Of Stock By Outlet 
2026-01-17 19:07:30.1888 DFramework.Database.Query    /* Time Taken: 5470*/
DECLARE @AssetPurityId Int32
SET @AssetPurityId = '3676247'
DECLARE @AssetId Int32
SET @AssetId = '118196'
DECLARE @StatusId Int32
SET @StatusId = '2'
DECLARE @PurityDateTime Date
SET @PurityDateTime = '1/16/2026 6:44:56 PM'
SELECT TOP 1 PurityDateTime, AssetPurityId, PlanogramId, Shelves, PurityStatus, AssetId, ImageReceivedFrom FROM AssetPurity
 WHERE [AssetPurityId] <= @AssetPurityId AND [AssetId] = @AssetId AND [StatusId] = @StatusId AND [PurityDateTime] > @PurityDateTime
 ORDER BY [PurityDateTime] DESC 
2026-01-17 19:12:59.8955 DFramework.Database.Query    /* Time Taken: 723*/
[dbo].GenerateSystemAlerts 
2026-01-17 19:13:09.6600 DFramework.Scheduler.TaskBase    /* Time Taken: 10488.3124*/
Opportunity Out Of Stock By Outlet 
2026-01-17 19:27:59.8093 DFramework.Database.NullableDataReader    Data reader open for 296
   at System.Environment.GetStackTrace(Exception e, Boolean needFileInfo)
   at System.Environment.get_StackTrace()
   at DFramework.Database.NullableDataReader.Dispose(Boolean disposing) in C:\CoolR-Group\Framework\DFramework\Database\NullableDataReader.cs:line 33
   at DFramework.Database.NullableDataReader.Dispose() in C:\CoolR-Group\Framework\DFramework\Database\NullableDataReader.cs:line 44
   at CoolR.Tasks.ProcessOutletAlertData.GetAlertDefinitions() in C:\CoolR-Group\portal\CoolR.Tasks\OpportunityOutOfStockByOutlet.cs:line 490
   at CoolR.Tasks.ProcessOutletAlertData.Execute() in C:\CoolR-Group\portal\CoolR.Tasks\OpportunityOutOfStockByOutlet.cs:line 72
   at DFramework.Scheduler.TaskBase.Run() in E:\Forked\Framework\DFramework.Scheduler\TaskBase.cs:line 176
   at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)
   at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)
   at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state)
   at System.Threading.ThreadHelper.ThreadStart() 
2026-01-17 19:28:10.1727 DFramework.Scheduler.TaskBase    /* Time Taken: 10961.166*/
Opportunity Out Of Stock By Outlet 
2026-01-17 19:34:47.8604 DFramework.Database.Query    /* Time Taken: 502*/
DECLARE @AssetPurityId Int32
SET @AssetPurityId = '3676247'
DECLARE @AssetId Int32
SET @AssetId = '118196'
DECLARE @StatusId Int32
SET @StatusId = '2'
DECLARE @PurityDateTime Date
SET @PurityDateTime = '1/16/2026 6:44:56 PM'
SELECT TOP 1 PurityDateTime, AssetPurityId, PlanogramId, Shelves, PurityStatus, AssetId, ImageReceivedFrom FROM AssetPurity
 WHERE [AssetPurityId] <= @AssetPurityId AND [AssetId] = @AssetId AND [StatusId] = @StatusId AND [PurityDateTime] > @PurityDateTime
 ORDER BY [PurityDateTime] DESC 
2026-01-17 19:41:46.1502 DFramework.Database.Query    /* Time Taken: 1119*/
DECLARE @AssetPurityId Int32
SET @AssetPurityId = '3676247'
DECLARE @AssetId Int32
SET @AssetId = '118196'
DECLARE @StatusId Int32
SET @StatusId = '2'
DECLARE @PurityDateTime Date
SET @PurityDateTime = '1/16/2026 6:44:56 PM'
SELECT TOP 1 PurityDateTime, AssetPurityId, PlanogramId, Shelves, PurityStatus, AssetId, ImageReceivedFrom FROM AssetPurity
 WHERE [AssetPurityId] <= @AssetPurityId AND [AssetId] = @AssetId AND [StatusId] = @StatusId AND [PurityDateTime] > @PurityDateTime
 ORDER BY [PurityDateTime] DESC 
2026-01-17 19:42:59.5922 DFramework.Database.NullableDataReader    Data reader open for 302
   at System.Environment.GetStackTrace(Exception e, Boolean needFileInfo)
   at System.Environment.get_StackTrace()
   at DFramework.Database.NullableDataReader.Dispose(Boolean disposing) in C:\CoolR-Group\Framework\DFramework\Database\NullableDataReader.cs:line 33
   at DFramework.Database.NullableDataReader.Dispose() in C:\CoolR-Group\Framework\DFramework\Database\NullableDataReader.cs:line 44
   at CoolR.Tasks.ProcessOutletAlertData.GetAlertDefinitions() in C:\CoolR-Group\portal\CoolR.Tasks\OpportunityOutOfStockByOutlet.cs:line 490
   at CoolR.Tasks.ProcessOutletAlertData.Execute() in C:\CoolR-Group\portal\CoolR.Tasks\OpportunityOutOfStockByOutlet.cs:line 72
   at DFramework.Scheduler.TaskBase.Run() in E:\Forked\Framework\DFramework.Scheduler\TaskBase.cs:line 176
   at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)
   at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)
   at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state)
   at System.Threading.ThreadHelper.ThreadStart() 
2026-01-17 19:42:59.8273 DFramework.Database.Query    /* Time Taken: 614*/
[dbo].GenerateSystemAlerts 
2026-01-17 19:43:10.0185 DFramework.Scheduler.TaskBase    /* Time Taken: 10805.4957*/
Opportunity Out Of Stock By Outlet 
2026-01-17 19:55:28.5084 DFramework.Database.Query    /* Time Taken: 3918*/
DECLARE @AssetPurityId Int32
SET @AssetPurityId = '3676247'
DECLARE @AssetId Int32
SET @AssetId = '118196'
DECLARE @StatusId Int32
SET @StatusId = '2'
DECLARE @PurityDateTime Date
SET @PurityDateTime = '1/16/2026 6:44:56 PM'
SELECT TOP 1 PurityDateTime, AssetPurityId, PlanogramId, Shelves, PurityStatus, AssetId, ImageReceivedFrom FROM AssetPurity
 WHERE [AssetPurityId] <= @AssetPurityId AND [AssetId] = @AssetId AND [StatusId] = @StatusId AND [PurityDateTime] > @PurityDateTime
 ORDER BY [PurityDateTime] DESC 
2026-01-17 19:57:59.6056 DFramework.Database.NullableDataReader    Data reader open for 308
   at System.Environment.GetStackTrace(Exception e, Boolean needFileInfo)
   at System.Environment.get_StackTrace()
   at DFramework.Database.NullableDataReader.Dispose(Boolean disposing) in C:\CoolR-Group\Framework\DFramework\Database\NullableDataReader.cs:line 33
   at DFramework.Database.NullableDataReader.Dispose() in C:\CoolR-Group\Framework\DFramework\Database\NullableDataReader.cs:line 44
   at CoolR.Tasks.ProcessOutletAlertData.GetAlertDefinitions() in C:\CoolR-Group\portal\CoolR.Tasks\OpportunityOutOfStockByOutlet.cs:line 490
   at CoolR.Tasks.ProcessOutletAlertData.Execute() in C:\CoolR-Group\portal\CoolR.Tasks\OpportunityOutOfStockByOutlet.cs:line 72
   at DFramework.Scheduler.TaskBase.Run() in E:\Forked\Framework\DFramework.Scheduler\TaskBase.cs:line 176
   at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)
   at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)
   at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state)
   at System.Threading.ThreadHelper.ThreadStart() 
2026-01-17 19:58:09.9488 DFramework.Scheduler.TaskBase    /* Time Taken: 10721.5206*/
Opportunity Out Of Stock By Outlet 
2026-01-17 20:02:31.1017 DFramework.Database.Query    /* Time Taken: 13482*/
DECLARE @AssetPurityId Int32
SET @AssetPurityId = '3676247'
DECLARE @AssetId Int32
SET @AssetId = '118196'
DECLARE @StatusId Int32
SET @StatusId = '2'
DECLARE @PurityDateTime Date
SET @PurityDateTime = '1/16/2026 6:44:56 PM'
SELECT TOP 1 PurityDateTime, AssetPurityId, PlanogramId, Shelves, PurityStatus, AssetId, ImageReceivedFrom FROM AssetPurity
 WHERE [AssetPurityId] <= @AssetPurityId AND [AssetId] = @AssetId AND [StatusId] = @StatusId AND [PurityDateTime] > @PurityDateTime
 ORDER BY [PurityDateTime] DESC 
2026-01-17 20:09:22.4724 DFramework.Database.Query    /* Time Taken: 588*/
DECLARE @AssetPurityId Int32
SET @AssetPurityId = '3676247'
DECLARE @AssetId Int32
SET @AssetId = '118196'
DECLARE @StatusId Int32
SET @StatusId = '2'
DECLARE @PurityDateTime Date
SET @PurityDateTime = '1/16/2026 6:44:56 PM'
SELECT TOP 1 PurityDateTime, AssetPurityId, PlanogramId, Shelves, PurityStatus, AssetId, ImageReceivedFrom FROM AssetPurity
 WHERE [AssetPurityId] <= @AssetPurityId AND [AssetId] = @AssetId AND [StatusId] = @StatusId AND [PurityDateTime] > @PurityDateTime
 ORDER BY [PurityDateTime] DESC 
2026-01-17 20:13:00.0563 DFramework.Database.Query    /* Time Taken: 814*/
[dbo].GenerateSystemAlerts 
2026-01-17 20:13:09.8065 DFramework.Scheduler.TaskBase    /* Time Taken: 10566.2674*/
Opportunity Out Of Stock By Outlet 
2026-01-17 20:16:20.6733 DFramework.Database.Query    /* Time Taken: 1155*/
DECLARE @AssetPurityId Int32
SET @AssetPurityId = '3676247'
DECLARE @AssetId Int32
SET @AssetId = '118196'
DECLARE @StatusId Int32
SET @StatusId = '2'
DECLARE @PurityDateTime Date
SET @PurityDateTime = '1/16/2026 6:44:56 PM'
SELECT TOP 1 PurityDateTime, AssetPurityId, PlanogramId, Shelves, PurityStatus, AssetId, ImageReceivedFrom FROM AssetPurity
 WHERE [AssetPurityId] <= @AssetPurityId AND [AssetId] = @AssetId AND [StatusId] = @StatusId AND [PurityDateTime] > @PurityDateTime
 ORDER BY [PurityDateTime] DESC 
2026-01-17 20:23:17.6576 DFramework.Database.Query    /* Time Taken: 7880*/
DECLARE @AssetPurityId Int32
SET @AssetPurityId = '3676247'
DECLARE @AssetId Int32
SET @AssetId = '118196'
DECLARE @StatusId Int32
SET @StatusId = '2'
DECLARE @PurityDateTime Date
SET @PurityDateTime = '1/16/2026 6:44:56 PM'
SELECT TOP 1 PurityDateTime, AssetPurityId, PlanogramId, Shelves, PurityStatus, AssetId, ImageReceivedFrom FROM AssetPurity
 WHERE [AssetPurityId] <= @AssetPurityId AND [AssetId] = @AssetId AND [StatusId] = @StatusId AND [PurityDateTime] > @PurityDateTime
 ORDER BY [PurityDateTime] DESC 
2026-01-17 20:27:59.9847 DFramework.Database.Query    /* Time Taken: 725*/
[dbo].GenerateSystemAlerts 
2026-01-17 20:28:09.7222 DFramework.Scheduler.TaskBase    /* Time Taken: 10466.5866*/
Opportunity Out Of Stock By Outlet 
2026-01-17 20:30:21.5569 DFramework.Database.Query    /* Time Taken: 7891*/
DECLARE @AssetPurityId Int32
SET @AssetPurityId = '3676247'
DECLARE @AssetId Int32
SET @AssetId = '118196'
DECLARE @StatusId Int32
SET @StatusId = '2'
DECLARE @PurityDateTime Date
SET @PurityDateTime = '1/16/2026 6:44:56 PM'
SELECT TOP 1 PurityDateTime, AssetPurityId, PlanogramId, Shelves, PurityStatus, AssetId, ImageReceivedFrom FROM AssetPurity
 WHERE [AssetPurityId] <= @AssetPurityId AND [AssetId] = @AssetId AND [StatusId] = @StatusId AND [PurityDateTime] > @PurityDateTime
 ORDER BY [PurityDateTime] DESC 
2026-01-17 20:37:04.6696 DFramework.Database.Query    /* Time Taken: 6251*/
DECLARE @AssetPurityId Int32
SET @AssetPurityId = '3676247'
DECLARE @AssetId Int32
SET @AssetId = '118196'
DECLARE @StatusId Int32
SET @StatusId = '2'
DECLARE @PurityDateTime Date
SET @PurityDateTime = '1/16/2026 6:44:56 PM'
SELECT TOP 1 PurityDateTime, AssetPurityId, PlanogramId, Shelves, PurityStatus, AssetId, ImageReceivedFrom FROM AssetPurity
 WHERE [AssetPurityId] <= @AssetPurityId AND [AssetId] = @AssetId AND [StatusId] = @StatusId AND [PurityDateTime] > @PurityDateTime
 ORDER BY [PurityDateTime] DESC 
2026-01-17 20:42:59.6252 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 C:\CoolR-Group\Framework\DFramework\Database\NullableDataReader.cs:line 33
   at DFramework.Database.NullableDataReader.Dispose() in C:\CoolR-Group\Framework\DFramework\Database\NullableDataReader.cs:line 44
   at CoolR.Tasks.ProcessOutletAlertData.GetAlertDefinitions() in C:\CoolR-Group\portal\CoolR.Tasks\OpportunityOutOfStockByOutlet.cs:line 490
   at CoolR.Tasks.ProcessOutletAlertData.Execute() in C:\CoolR-Group\portal\CoolR.Tasks\OpportunityOutOfStockByOutlet.cs:line 72
   at DFramework.Scheduler.TaskBase.Run() in E:\Forked\Framework\DFramework.Scheduler\TaskBase.cs:line 176
   at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)
   at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)
   at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state)
   at System.Threading.ThreadHelper.ThreadStart() 
2026-01-17 20:43:09.9817 DFramework.Scheduler.TaskBase    /* Time Taken: 10715.2464*/
Opportunity Out Of Stock By Outlet 
2026-01-17 20:44:00.8002 DFramework.Database.Query    /* Time Taken: 7016*/
DECLARE @AssetPurityId Int32
SET @AssetPurityId = '3676247'
DECLARE @AssetId Int32
SET @AssetId = '118196'
DECLARE @StatusId Int32
SET @StatusId = '2'
DECLARE @PurityDateTime Date
SET @PurityDateTime = '1/16/2026 6:44:56 PM'
SELECT TOP 1 PurityDateTime, AssetPurityId, PlanogramId, Shelves, PurityStatus, AssetId, ImageReceivedFrom FROM AssetPurity
 WHERE [AssetPurityId] <= @AssetPurityId AND [AssetId] = @AssetId AND [StatusId] = @StatusId AND [PurityDateTime] > @PurityDateTime
 ORDER BY [PurityDateTime] DESC 
2026-01-17 20:50:51.3169 DFramework.Database.Query    /* Time Taken: 1006*/
DECLARE @AssetPurityId Int32
SET @AssetPurityId = '3676247'
DECLARE @AssetId Int32
SET @AssetId = '118196'
DECLARE @StatusId Int32
SET @StatusId = '2'
DECLARE @PurityDateTime Date
SET @PurityDateTime = '1/16/2026 6:44:56 PM'
SELECT TOP 1 PurityDateTime, AssetPurityId, PlanogramId, Shelves, PurityStatus, AssetId, ImageReceivedFrom FROM AssetPurity
 WHERE [AssetPurityId] <= @AssetPurityId AND [AssetId] = @AssetId AND [StatusId] = @StatusId AND [PurityDateTime] > @PurityDateTime
 ORDER BY [PurityDateTime] DESC 
2026-01-17 20:55:55.2375 DFramework.Database.Query    /* Time Taken: 631*/
DECLARE @AssetPurityId Int32
SET @AssetPurityId = '3676247'
DECLARE @AssetId Int32
SET @AssetId = '118196'
DECLARE @StatusId Int32
SET @StatusId = '2'
DECLARE @PurityDateTime Date
SET @PurityDateTime = '1/16/2026 6:44:56 PM'
SELECT TOP 1 PurityDateTime, AssetPurityId, PlanogramId, Shelves, PurityStatus, AssetId, ImageReceivedFrom FROM AssetPurity
 WHERE [AssetPurityId] <= @AssetPurityId AND [AssetId] = @AssetId AND [StatusId] = @StatusId AND [PurityDateTime] > @PurityDateTime
 ORDER BY [PurityDateTime] DESC 
2026-01-17 20:57:43.8614 DFramework.Database.Query    /* Time Taken: 2307*/
DECLARE @AssetPurityId Int32
SET @AssetPurityId = '3676247'
DECLARE @AssetId Int32
SET @AssetId = '118196'
DECLARE @StatusId Int32
SET @StatusId = '2'
DECLARE @PurityDateTime Date
SET @PurityDateTime = '1/16/2026 6:44:56 PM'
SELECT TOP 1 PurityDateTime, AssetPurityId, PlanogramId, Shelves, PurityStatus, AssetId, ImageReceivedFrom FROM AssetPurity
 WHERE [AssetPurityId] <= @AssetPurityId AND [AssetId] = @AssetId AND [StatusId] = @StatusId AND [PurityDateTime] > @PurityDateTime
 ORDER BY [PurityDateTime] DESC 
2026-01-17 20:58:04.7916 DFramework.Database.Query    /* Time Taken: 4881*/
DECLARE @AssetPurityId Int32
SET @AssetPurityId = '3676247'
DECLARE @AssetId Int32
SET @AssetId = '118196'
DECLARE @StatusId Int32
SET @StatusId = '2'
DECLARE @PurityDateTime Date
SET @PurityDateTime = '1/16/2026 6:44:56 PM'
SELECT TOP 1 PurityDateTime, AssetPurityId, PlanogramId, Shelves, PurityStatus, AssetId, ImageReceivedFrom FROM AssetPurity
 WHERE [AssetPurityId] <= @AssetPurityId AND [AssetId] = @AssetId AND [StatusId] = @StatusId AND [PurityDateTime] > @PurityDateTime
 ORDER BY [PurityDateTime] DESC 
2026-01-17 20:58:05.1964 DFramework.Database.NullableDataReader    Data reader open for 327
   at System.Environment.GetStackTrace(Exception e, Boolean needFileInfo)
   at System.Environment.get_StackTrace()
   at DFramework.Database.NullableDataReader.Dispose(Boolean disposing) in C:\CoolR-Group\Framework\DFramework\Database\NullableDataReader.cs:line 33
   at DFramework.Database.NullableDataReader.Dispose() in C:\CoolR-Group\Framework\DFramework\Database\NullableDataReader.cs:line 44
   at CoolR.Tasks.ProcessOutletAlertData.GetAlertDefinitions() in C:\CoolR-Group\portal\CoolR.Tasks\OpportunityOutOfStockByOutlet.cs:line 490
   at CoolR.Tasks.ProcessOutletAlertData.Execute() in C:\CoolR-Group\portal\CoolR.Tasks\OpportunityOutOfStockByOutlet.cs:line 72
   at DFramework.Scheduler.TaskBase.Run() in E:\Forked\Framework\DFramework.Scheduler\TaskBase.cs:line 176
   at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)
   at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)
   at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state)
   at System.Threading.ThreadHelper.ThreadStart() 
2026-01-17 20:58:05.3529 DFramework.Database.Query    /* Time Taken: 549*/
[dbo].GenerateSystemAlerts 
2026-01-17 20:58:20.1845 DFramework.Database.Query    /* Time Taken: 9427*/
DECLARE @AssetPurityId Int32
SET @AssetPurityId = '3676247'
DECLARE @AssetId Int32
SET @AssetId = '118196'
DECLARE @StatusId Int32
SET @StatusId = '2'
DECLARE @PurityDateTime Date
SET @PurityDateTime = '1/16/2026 6:44:56 PM'
SELECT TOP 1 PurityDateTime, AssetPurityId, PlanogramId, Shelves, PurityStatus, AssetId, ImageReceivedFrom FROM AssetPurity
 WHERE [AssetPurityId] <= @AssetPurityId AND [AssetId] = @AssetId AND [StatusId] = @StatusId AND [PurityDateTime] > @PurityDateTime
 ORDER BY [PurityDateTime] DESC 
2026-01-17 20:58:23.1384 DFramework.Database.NullableDataReader    Data reader open for 9663
   at System.Environment.GetStackTrace(Exception e, Boolean needFileInfo)
   at System.Environment.get_StackTrace()
   at DFramework.Database.NullableDataReader.Dispose(Boolean disposing) in C:\CoolR-Group\Framework\DFramework\Database\NullableDataReader.cs:line 33
   at DFramework.Database.NullableDataReader.Dispose() in C:\CoolR-Group\Framework\DFramework\Database\NullableDataReader.cs:line 44
   at CoolR.Tasks.ProcessOutletAlertData.GetLocations(Int32 clientId, Int32 marketId, Int32 classificationId, Int32 locationId, Int32 locationTypeId, DateTime startDate) in C:\CoolR-Group\portal\CoolR.Tasks\OpportunityOutOfStockByOutlet.cs:line 551
   at CoolR.Tasks.ProcessOutletAlertData.Execute() in C:\CoolR-Group\portal\CoolR.Tasks\OpportunityOutOfStockByOutlet.cs:line 96
   at DFramework.Scheduler.TaskBase.Run() in E:\Forked\Framework\DFramework.Scheduler\TaskBase.cs:line 176
   at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)
   at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)
   at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state)
   at System.Threading.ThreadHelper.ThreadStart() 
2026-01-17 20:58:25.3913 DFramework.Database.NullableDataReader    Data reader open for 2973
   at System.Environment.GetStackTrace(Exception e, Boolean needFileInfo)
   at System.Environment.get_StackTrace()
   at DFramework.Database.NullableDataReader.Dispose(Boolean disposing) in C:\CoolR-Group\Framework\DFramework\Database\NullableDataReader.cs:line 33
   at DFramework.Database.NullableDataReader.Dispose() in C:\CoolR-Group\Framework\DFramework\Database\NullableDataReader.cs:line 44
   at CoolR.Tasks.ProcessAlertData.LoadStockData(Int32 currentRecordId, DateTime startDate, DateTime latestEventTime, Int32 assetId, Boolean isComingFromStockLow) in C:\CoolR-Group\portal\CoolR.Tasks\ProcessAlertData.cs:line 1612
   at CoolR.Tasks.ProcessAlertData.StockAlertProductWise(Int32 alertId, Int32 currentRecordId, DateTime latestEventTime, Boolean isForAllProduct, Int32 stockThreshold, Int32 assetId, String alertText, Int32 alertDefinitionId, DateTime startDate, DateTime endDate, Int32 clientId, Int32 locationId, Int32 priorityId) in C:\CoolR-Group\portal\CoolR.Tasks\ProcessAlertData.cs:line 1379
   at CoolR.Tasks.ProcessAlertData.Execute() in C:\CoolR-Group\portal\CoolR.Tasks\ProcessAlertData.cs:line 343
   at DFramework.Scheduler.TaskBase.Run() in E:\Forked\Framework\DFramework.Scheduler\TaskBase.cs:line 176
   at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)
   at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)
   at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state)
   at System.Threading.ThreadHelper.ThreadStart() 
2026-01-17 20:58:38.0953 DFramework.Scheduler.TaskBase    /* Time Taken: 26960.148*/
Opportunity Out Of Stock By Outlet 
2026-01-17 20:58:38.1426 DFramework.Database.Query    /* Time Taken: 6770*/
DECLARE @AssetPurityId Int32
SET @AssetPurityId = '3676247'
DECLARE @AssetId Int32
SET @AssetId = '118196'
DECLARE @StatusId Int32
SET @StatusId = '2'
DECLARE @PurityDateTime Date
SET @PurityDateTime = '1/16/2026 6:44:56 PM'
SELECT TOP 1 PurityDateTime, AssetPurityId, PlanogramId, Shelves, PurityStatus, AssetId, ImageReceivedFrom FROM AssetPurity
 WHERE [AssetPurityId] <= @AssetPurityId AND [AssetId] = @AssetId AND [StatusId] = @StatusId AND [PurityDateTime] > @PurityDateTime
 ORDER BY [PurityDateTime] DESC 
2026-01-17 21:06:56.7896 DFramework.Database.Query    /* Time Taken: 969*/
DECLARE @AssetPurityId Int32
SET @AssetPurityId = '3676247'
DECLARE @AssetId Int32
SET @AssetId = '118196'
DECLARE @StatusId Int32
SET @StatusId = '2'
DECLARE @PurityDateTime Date
SET @PurityDateTime = '1/16/2026 6:44:56 PM'
SELECT TOP 1 PurityDateTime, AssetPurityId, PlanogramId, Shelves, PurityStatus, AssetId, ImageReceivedFrom FROM AssetPurity
 WHERE [AssetPurityId] <= @AssetPurityId AND [AssetId] = @AssetId AND [StatusId] = @StatusId AND [PurityDateTime] > @PurityDateTime
 ORDER BY [PurityDateTime] DESC 
2026-01-17 21:12:59.9149 DFramework.Database.NullableDataReader    Data reader open for 291
   at System.Environment.GetStackTrace(Exception e, Boolean needFileInfo)
   at System.Environment.get_StackTrace()
   at DFramework.Database.NullableDataReader.Dispose(Boolean disposing) in C:\CoolR-Group\Framework\DFramework\Database\NullableDataReader.cs:line 33
   at DFramework.Database.NullableDataReader.Dispose() in C:\CoolR-Group\Framework\DFramework\Database\NullableDataReader.cs:line 44
   at CoolR.Tasks.ProcessOutletAlertData.GetAlertDefinitions() in C:\CoolR-Group\portal\CoolR.Tasks\OpportunityOutOfStockByOutlet.cs:line 490
   at CoolR.Tasks.ProcessOutletAlertData.Execute() in C:\CoolR-Group\portal\CoolR.Tasks\OpportunityOutOfStockByOutlet.cs:line 72
   at DFramework.Scheduler.TaskBase.Run() in E:\Forked\Framework\DFramework.Scheduler\TaskBase.cs:line 176
   at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)
   at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)
   at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state)
   at System.Threading.ThreadHelper.ThreadStart() 
2026-01-17 21:13:10.2631 DFramework.Scheduler.TaskBase    /* Time Taken: 10947.9822*/
Opportunity Out Of Stock By Outlet 
2026-01-17 21:13:51.6168 DFramework.Database.Query    /* Time Taken: 5568*/
DECLARE @AssetPurityId Int32
SET @AssetPurityId = '3676247'
DECLARE @AssetId Int32
SET @AssetId = '118196'
DECLARE @StatusId Int32
SET @StatusId = '2'
DECLARE @PurityDateTime Date
SET @PurityDateTime = '1/16/2026 6:44:56 PM'
SELECT TOP 1 PurityDateTime, AssetPurityId, PlanogramId, Shelves, PurityStatus, AssetId, ImageReceivedFrom FROM AssetPurity
 WHERE [AssetPurityId] <= @AssetPurityId AND [AssetId] = @AssetId AND [StatusId] = @StatusId AND [PurityDateTime] > @PurityDateTime
 ORDER BY [PurityDateTime] DESC 
2026-01-17 21:17:27.9712 DFramework.Database.Query    /* Time Taken: 1720*/
DECLARE @AssetPurityId Int32
SET @AssetPurityId = '3676247'
DECLARE @AssetId Int32
SET @AssetId = '118196'
DECLARE @StatusId Int32
SET @StatusId = '2'
DECLARE @PurityDateTime Date
SET @PurityDateTime = '1/16/2026 6:44:56 PM'
SELECT TOP 1 PurityDateTime, AssetPurityId, PlanogramId, Shelves, PurityStatus, AssetId, ImageReceivedFrom FROM AssetPurity
 WHERE [AssetPurityId] <= @AssetPurityId AND [AssetId] = @AssetId AND [StatusId] = @StatusId AND [PurityDateTime] > @PurityDateTime
 ORDER BY [PurityDateTime] DESC 
2026-01-17 21:20:58.9625 DFramework.Database.Query    /* Time Taken: 10603*/
DECLARE @AssetPurityId Int32
SET @AssetPurityId = '3676247'
DECLARE @AssetId Int32
SET @AssetId = '118196'
DECLARE @StatusId Int32
SET @StatusId = '2'
DECLARE @PurityDateTime Date
SET @PurityDateTime = '1/16/2026 6:44:56 PM'
SELECT TOP 1 PurityDateTime, AssetPurityId, PlanogramId, Shelves, PurityStatus, AssetId, ImageReceivedFrom FROM AssetPurity
 WHERE [AssetPurityId] <= @AssetPurityId AND [AssetId] = @AssetId AND [StatusId] = @StatusId AND [PurityDateTime] > @PurityDateTime
 ORDER BY [PurityDateTime] DESC 
2026-01-17 21:24:37.5516 DFramework.Database.NullableDataReader    Data reader open for 4246
   at System.Environment.GetStackTrace(Exception e, Boolean needFileInfo)
   at System.Environment.get_StackTrace()
   at DFramework.Database.NullableDataReader.Dispose(Boolean disposing) in C:\CoolR-Group\Framework\DFramework\Database\NullableDataReader.cs:line 33
   at DFramework.Database.NullableDataReader.Dispose() in C:\CoolR-Group\Framework\DFramework\Database\NullableDataReader.cs:line 44
   at CoolR.Tasks.ProcessAlertData.LoadStockData(Int32 currentRecordId, DateTime startDate, DateTime latestEventTime, Int32 assetId, Boolean isComingFromStockLow) in C:\CoolR-Group\portal\CoolR.Tasks\ProcessAlertData.cs:line 1612
   at CoolR.Tasks.ProcessAlertData.StockAlertProductWise(Int32 alertId, Int32 currentRecordId, DateTime latestEventTime, Boolean isForAllProduct, Int32 stockThreshold, Int32 assetId, String alertText, Int32 alertDefinitionId, DateTime startDate, DateTime endDate, Int32 clientId, Int32 locationId, Int32 priorityId) in C:\CoolR-Group\portal\CoolR.Tasks\ProcessAlertData.cs:line 1379
   at CoolR.Tasks.ProcessAlertData.Execute() in C:\CoolR-Group\portal\CoolR.Tasks\ProcessAlertData.cs:line 343
   at DFramework.Scheduler.TaskBase.Run() in E:\Forked\Framework\DFramework.Scheduler\TaskBase.cs:line 176
   at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)
   at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)
   at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state)
   at System.Threading.ThreadHelper.ThreadStart() 
2026-01-17 21:27:59.7874 DFramework.Database.Query    /* Time Taken: 1937*/
DECLARE @AssetPurityId Int32
SET @AssetPurityId = '3676247'
DECLARE @AssetId Int32
SET @AssetId = '118196'
DECLARE @StatusId Int32
SET @StatusId = '2'
DECLARE @PurityDateTime Date
SET @PurityDateTime = '1/16/2026 6:44:56 PM'
SELECT TOP 1 PurityDateTime, AssetPurityId, PlanogramId, Shelves, PurityStatus, AssetId, ImageReceivedFrom FROM AssetPurity
 WHERE [AssetPurityId] <= @AssetPurityId AND [AssetId] = @AssetId AND [StatusId] = @StatusId AND [PurityDateTime] > @PurityDateTime
 ORDER BY [PurityDateTime] DESC 
2026-01-17 21:28:00.3657 DFramework.Database.NullableDataReader    Data reader open for 286
   at System.Environment.GetStackTrace(Exception e, Boolean needFileInfo)
   at System.Environment.get_StackTrace()
   at DFramework.Database.NullableDataReader.Dispose(Boolean disposing) in C:\CoolR-Group\Framework\DFramework\Database\NullableDataReader.cs:line 33
   at DFramework.Database.NullableDataReader.Dispose() in C:\CoolR-Group\Framework\DFramework\Database\NullableDataReader.cs:line 44
   at CoolR.Tasks.ProcessOutletAlertData.GetAlertDefinitions() in C:\CoolR-Group\portal\CoolR.Tasks\OpportunityOutOfStockByOutlet.cs:line 490
   at CoolR.Tasks.ProcessOutletAlertData.Execute() in C:\CoolR-Group\portal\CoolR.Tasks\OpportunityOutOfStockByOutlet.cs:line 72
   at DFramework.Scheduler.TaskBase.Run() in E:\Forked\Framework\DFramework.Scheduler\TaskBase.cs:line 176
   at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)
   at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)
   at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state)
   at System.Threading.ThreadHelper.ThreadStart() 
2026-01-17 21:28:00.3969 DFramework.Database.Query    /* Time Taken: 610*/
[dbo].GenerateSystemAlerts 
2026-01-17 21:28:10.8705 DFramework.Scheduler.TaskBase    /* Time Taken: 11083.0839*/
Opportunity Out Of Stock By Outlet 
2026-01-17 21:31:39.1919 DFramework.Database.Query    /* Time Taken: 5041*/
DECLARE @AssetPurityId Int32
SET @AssetPurityId = '3676247'
DECLARE @AssetId Int32
SET @AssetId = '118196'
DECLARE @StatusId Int32
SET @StatusId = '2'
DECLARE @PurityDateTime Date
SET @PurityDateTime = '1/16/2026 6:44:56 PM'
SELECT TOP 1 PurityDateTime, AssetPurityId, PlanogramId, Shelves, PurityStatus, AssetId, ImageReceivedFrom FROM AssetPurity
 WHERE [AssetPurityId] <= @AssetPurityId AND [AssetId] = @AssetId AND [StatusId] = @StatusId AND [PurityDateTime] > @PurityDateTime
 ORDER BY [PurityDateTime] DESC 
2026-01-17 21:35:12.3295 DFramework.Database.Query    /* Time Taken: 10740*/
DECLARE @AssetPurityId Int32
SET @AssetPurityId = '3676247'
DECLARE @AssetId Int32
SET @AssetId = '118196'
DECLARE @StatusId Int32
SET @StatusId = '2'
DECLARE @PurityDateTime Date
SET @PurityDateTime = '1/16/2026 6:44:56 PM'
SELECT TOP 1 PurityDateTime, AssetPurityId, PlanogramId, Shelves, PurityStatus, AssetId, ImageReceivedFrom FROM AssetPurity
 WHERE [AssetPurityId] <= @AssetPurityId AND [AssetId] = @AssetId AND [StatusId] = @StatusId AND [PurityDateTime] > @PurityDateTime
 ORDER BY [PurityDateTime] DESC 
2026-01-17 21:38:49.2652 DFramework.Database.Query    /* Time Taken: 2669*/
DECLARE @AssetPurityId Int32
SET @AssetPurityId = '3676247'
DECLARE @AssetId Int32
SET @AssetId = '118196'
DECLARE @StatusId Int32
SET @StatusId = '2'
DECLARE @PurityDateTime Date
SET @PurityDateTime = '1/16/2026 6:44:56 PM'
SELECT TOP 1 PurityDateTime, AssetPurityId, PlanogramId, Shelves, PurityStatus, AssetId, ImageReceivedFrom FROM AssetPurity
 WHERE [AssetPurityId] <= @AssetPurityId AND [AssetId] = @AssetId AND [StatusId] = @StatusId AND [PurityDateTime] > @PurityDateTime
 ORDER BY [PurityDateTime] DESC 
2026-01-17 21:42:23.7339 DFramework.Database.Query    /* Time Taken: 14066*/
DECLARE @AssetPurityId Int32
SET @AssetPurityId = '3676247'
DECLARE @AssetId Int32
SET @AssetId = '118196'
DECLARE @StatusId Int32
SET @StatusId = '2'
DECLARE @PurityDateTime Date
SET @PurityDateTime = '1/16/2026 6:44:56 PM'
SELECT TOP 1 PurityDateTime, AssetPurityId, PlanogramId, Shelves, PurityStatus, AssetId, ImageReceivedFrom FROM AssetPurity
 WHERE [AssetPurityId] <= @AssetPurityId AND [AssetId] = @AssetId AND [StatusId] = @StatusId AND [PurityDateTime] > @PurityDateTime
 ORDER BY [PurityDateTime] DESC 
2026-01-17 21:43:00.2869 DFramework.Database.Query    /* Time Taken: 513*/
[dbo].GenerateSystemAlerts 
2026-01-17 21:43:10.3063 DFramework.Scheduler.TaskBase    /* Time Taken: 10519.9793*/
Opportunity Out Of Stock By Outlet 
2026-01-17 21:46:01.6201 DFramework.Database.Query    /* Time Taken: 3492*/
DECLARE @AssetPurityId Int32
SET @AssetPurityId = '3676247'
DECLARE @AssetId Int32
SET @AssetId = '118196'
DECLARE @StatusId Int32
SET @StatusId = '2'
DECLARE @PurityDateTime Date
SET @PurityDateTime = '1/16/2026 6:44:56 PM'
SELECT TOP 1 PurityDateTime, AssetPurityId, PlanogramId, Shelves, PurityStatus, AssetId, ImageReceivedFrom FROM AssetPurity
 WHERE [AssetPurityId] <= @AssetPurityId AND [AssetId] = @AssetId AND [StatusId] = @StatusId AND [PurityDateTime] > @PurityDateTime
 ORDER BY [PurityDateTime] DESC 
2026-01-17 21:49:42.3576 DFramework.Database.Query    /* Time Taken: 20316*/
DECLARE @AssetPurityId Int32
SET @AssetPurityId = '3676247'
DECLARE @AssetId Int32
SET @AssetId = '118196'
DECLARE @StatusId Int32
SET @StatusId = '2'
DECLARE @PurityDateTime Date
SET @PurityDateTime = '1/16/2026 6:44:56 PM'
SELECT TOP 1 PurityDateTime, AssetPurityId, PlanogramId, Shelves, PurityStatus, AssetId, ImageReceivedFrom FROM AssetPurity
 WHERE [AssetPurityId] <= @AssetPurityId AND [AssetId] = @AssetId AND [StatusId] = @StatusId AND [PurityDateTime] > @PurityDateTime
 ORDER BY [PurityDateTime] DESC 
2026-01-17 21:53:21.4577 DFramework.Database.Query    /* Time Taken: 4874*/
DECLARE @AssetPurityId Int32
SET @AssetPurityId = '3676247'
DECLARE @AssetId Int32
SET @AssetId = '118196'
DECLARE @StatusId Int32
SET @StatusId = '2'
DECLARE @PurityDateTime Date
SET @PurityDateTime = '1/16/2026 6:44:56 PM'
SELECT TOP 1 PurityDateTime, AssetPurityId, PlanogramId, Shelves, PurityStatus, AssetId, ImageReceivedFrom FROM AssetPurity
 WHERE [AssetPurityId] <= @AssetPurityId AND [AssetId] = @AssetId AND [StatusId] = @StatusId AND [PurityDateTime] > @PurityDateTime
 ORDER BY [PurityDateTime] DESC 
2026-01-17 21:56:52.9364 DFramework.Database.Query    /* Time Taken: 9152*/
DECLARE @AssetPurityId Int32
SET @AssetPurityId = '3676247'
DECLARE @AssetId Int32
SET @AssetId = '118196'
DECLARE @StatusId Int32
SET @StatusId = '2'
DECLARE @PurityDateTime Date
SET @PurityDateTime = '1/16/2026 6:44:56 PM'
SELECT TOP 1 PurityDateTime, AssetPurityId, PlanogramId, Shelves, PurityStatus, AssetId, ImageReceivedFrom FROM AssetPurity
 WHERE [AssetPurityId] <= @AssetPurityId AND [AssetId] = @AssetId AND [StatusId] = @StatusId AND [PurityDateTime] > @PurityDateTime
 ORDER BY [PurityDateTime] DESC 
2026-01-17 21:58:00.2199 DFramework.Database.NullableDataReader    Data reader open for 321
   at System.Environment.GetStackTrace(Exception e, Boolean needFileInfo)
   at System.Environment.get_StackTrace()
   at DFramework.Database.NullableDataReader.Dispose(Boolean disposing) in C:\CoolR-Group\Framework\DFramework\Database\NullableDataReader.cs:line 33
   at DFramework.Database.NullableDataReader.Dispose() in C:\CoolR-Group\Framework\DFramework\Database\NullableDataReader.cs:line 44
   at CoolR.Tasks.ProcessOutletAlertData.GetAlertDefinitions() in C:\CoolR-Group\portal\CoolR.Tasks\OpportunityOutOfStockByOutlet.cs:line 490
   at CoolR.Tasks.ProcessOutletAlertData.Execute() in C:\CoolR-Group\portal\CoolR.Tasks\OpportunityOutOfStockByOutlet.cs:line 72
   at DFramework.Scheduler.TaskBase.Run() in E:\Forked\Framework\DFramework.Scheduler\TaskBase.cs:line 176
   at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)
   at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)
   at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state)
   at System.Threading.ThreadHelper.ThreadStart() 
2026-01-17 21:58:10.5528 DFramework.Scheduler.TaskBase    /* Time Taken: 10739.8246*/
Opportunity Out Of Stock By Outlet 
2026-01-17 22:00:31.0260 DFramework.Database.Query    /* Time Taken: 3658*/
DECLARE @AssetPurityId Int32
SET @AssetPurityId = '3676247'
DECLARE @AssetId Int32
SET @AssetId = '118196'
DECLARE @StatusId Int32
SET @StatusId = '2'
DECLARE @PurityDateTime Date
SET @PurityDateTime = '1/16/2026 6:44:56 PM'
SELECT TOP 1 PurityDateTime, AssetPurityId, PlanogramId, Shelves, PurityStatus, AssetId, ImageReceivedFrom FROM AssetPurity
 WHERE [AssetPurityId] <= @AssetPurityId AND [AssetId] = @AssetId AND [StatusId] = @StatusId AND [PurityDateTime] > @PurityDateTime
 ORDER BY [PurityDateTime] DESC 
2026-01-17 22:04:10.4605 DFramework.Database.Query    /* Time Taken: 18961*/
DECLARE @AssetPurityId Int32
SET @AssetPurityId = '3676247'
DECLARE @AssetId Int32
SET @AssetId = '118196'
DECLARE @StatusId Int32
SET @StatusId = '2'
DECLARE @PurityDateTime Date
SET @PurityDateTime = '1/16/2026 6:44:56 PM'
SELECT TOP 1 PurityDateTime, AssetPurityId, PlanogramId, Shelves, PurityStatus, AssetId, ImageReceivedFrom FROM AssetPurity
 WHERE [AssetPurityId] <= @AssetPurityId AND [AssetId] = @AssetId AND [StatusId] = @StatusId AND [PurityDateTime] > @PurityDateTime
 ORDER BY [PurityDateTime] DESC 
2026-01-17 22:07:45.8317 DFramework.Database.Query    /* Time Taken: 854*/
DECLARE @AssetPurityId Int32
SET @AssetPurityId = '3676247'
DECLARE @AssetId Int32
SET @AssetId = '118196'
DECLARE @StatusId Int32
SET @StatusId = '2'
DECLARE @PurityDateTime Date
SET @PurityDateTime = '1/16/2026 6:44:56 PM'
SELECT TOP 1 PurityDateTime, AssetPurityId, PlanogramId, Shelves, PurityStatus, AssetId, ImageReceivedFrom FROM AssetPurity
 WHERE [AssetPurityId] <= @AssetPurityId AND [AssetId] = @AssetId AND [StatusId] = @StatusId AND [PurityDateTime] > @PurityDateTime
 ORDER BY [PurityDateTime] DESC 
2026-01-17 22:11:10.1720 DFramework.Database.Query    /* Time Taken: 3966*/
DECLARE @AssetPurityId Int32
SET @AssetPurityId = '3676247'
DECLARE @AssetId Int32
SET @AssetId = '118196'
DECLARE @StatusId Int32
SET @StatusId = '2'
DECLARE @PurityDateTime Date
SET @PurityDateTime = '1/16/2026 6:44:56 PM'
SELECT TOP 1 PurityDateTime, AssetPurityId, PlanogramId, Shelves, PurityStatus, AssetId, ImageReceivedFrom FROM AssetPurity
 WHERE [AssetPurityId] <= @AssetPurityId AND [AssetId] = @AssetId AND [StatusId] = @StatusId AND [PurityDateTime] > @PurityDateTime
 ORDER BY [PurityDateTime] DESC 
2026-01-17 22:13:00.4493 DFramework.Database.NullableDataReader    Data reader open for 299
   at System.Environment.GetStackTrace(Exception e, Boolean needFileInfo)
   at System.Environment.get_StackTrace()
   at DFramework.Database.NullableDataReader.Dispose(Boolean disposing) in C:\CoolR-Group\Framework\DFramework\Database\NullableDataReader.cs:line 33
   at DFramework.Database.NullableDataReader.Dispose() in C:\CoolR-Group\Framework\DFramework\Database\NullableDataReader.cs:line 44
   at CoolR.Tasks.ProcessOutletAlertData.GetAlertDefinitions() in C:\CoolR-Group\portal\CoolR.Tasks\OpportunityOutOfStockByOutlet.cs:line 490
   at CoolR.Tasks.ProcessOutletAlertData.Execute() in C:\CoolR-Group\portal\CoolR.Tasks\OpportunityOutOfStockByOutlet.cs:line 72
   at DFramework.Scheduler.TaskBase.Run() in E:\Forked\Framework\DFramework.Scheduler\TaskBase.cs:line 176
   at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)
   at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)
   at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state)
   at System.Threading.ThreadHelper.ThreadStart() 
2026-01-17 22:13:10.8508 DFramework.Scheduler.TaskBase    /* Time Taken: 11027.3184*/
Opportunity Out Of Stock By Outlet 
2026-01-17 22:14:49.2006 DFramework.Database.Query    /* Time Taken: 4516*/
DECLARE @AssetPurityId Int32
SET @AssetPurityId = '3676247'
DECLARE @AssetId Int32
SET @AssetId = '118196'
DECLARE @StatusId Int32
SET @StatusId = '2'
DECLARE @PurityDateTime Date
SET @PurityDateTime = '1/16/2026 6:44:56 PM'
SELECT TOP 1 PurityDateTime, AssetPurityId, PlanogramId, Shelves, PurityStatus, AssetId, ImageReceivedFrom FROM AssetPurity
 WHERE [AssetPurityId] <= @AssetPurityId AND [AssetId] = @AssetId AND [StatusId] = @StatusId AND [PurityDateTime] > @PurityDateTime
 ORDER BY [PurityDateTime] DESC 
2026-01-17 22:18:22.4027 DFramework.Database.Query    /* Time Taken: 10874*/
DECLARE @AssetPurityId Int32
SET @AssetPurityId = '3676247'
DECLARE @AssetId Int32
SET @AssetId = '118196'
DECLARE @StatusId Int32
SET @StatusId = '2'
DECLARE @PurityDateTime Date
SET @PurityDateTime = '1/16/2026 6:44:56 PM'
SELECT TOP 1 PurityDateTime, AssetPurityId, PlanogramId, Shelves, PurityStatus, AssetId, ImageReceivedFrom FROM AssetPurity
 WHERE [AssetPurityId] <= @AssetPurityId AND [AssetId] = @AssetId AND [StatusId] = @StatusId AND [PurityDateTime] > @PurityDateTime
 ORDER BY [PurityDateTime] DESC 
2026-01-17 22:25:47.8158 DFramework.Database.Query    /* Time Taken: 20297*/
DECLARE @AssetPurityId Int32
SET @AssetPurityId = '3676247'
DECLARE @AssetId Int32
SET @AssetId = '118196'
DECLARE @StatusId Int32
SET @StatusId = '2'
DECLARE @PurityDateTime Date
SET @PurityDateTime = '1/16/2026 6:44:56 PM'
SELECT TOP 1 PurityDateTime, AssetPurityId, PlanogramId, Shelves, PurityStatus, AssetId, ImageReceivedFrom FROM AssetPurity
 WHERE [AssetPurityId] <= @AssetPurityId AND [AssetId] = @AssetId AND [StatusId] = @StatusId AND [PurityDateTime] > @PurityDateTime
 ORDER BY [PurityDateTime] DESC 
2026-01-17 22:28:00.5625 DFramework.Database.Query    /* Time Taken: 712*/
[dbo].GenerateSystemAlerts 
2026-01-17 22:28:10.3018 DFramework.Scheduler.TaskBase    /* Time Taken: 10444.9827*/
Opportunity Out Of Stock By Outlet 
2026-01-17 22:32:50.1767 DFramework.Database.Query    /* Time Taken: 8561*/
DECLARE @AssetPurityId Int32
SET @AssetPurityId = '3676247'
DECLARE @AssetId Int32
SET @AssetId = '118196'
DECLARE @StatusId Int32
SET @StatusId = '2'
DECLARE @PurityDateTime Date
SET @PurityDateTime = '1/16/2026 6:44:56 PM'
SELECT TOP 1 PurityDateTime, AssetPurityId, PlanogramId, Shelves, PurityStatus, AssetId, ImageReceivedFrom FROM AssetPurity
 WHERE [AssetPurityId] <= @AssetPurityId AND [AssetId] = @AssetId AND [StatusId] = @StatusId AND [PurityDateTime] > @PurityDateTime
 ORDER BY [PurityDateTime] DESC 
2026-01-17 22:33:02.8342 DFramework.Database.Query    /* Time Taken: 2332*/
DECLARE @IsActive Int32
SET @IsActive = '1'
DECLARE @FtpTypeId Int32
SET @FtpTypeId = '7766'
DECLARE @ClientId Int32
SET @ClientId = '213'
Select * from vwFTPClientList

 WHERE [IsActive] = @IsActive AND [FtpTypeId] = @FtpTypeId AND [ClientId] = @ClientId
 ORDER BY [ClientFtpId] 
2026-01-17 22:40:12.3042 DFramework.Database.Query    /* Time Taken: 21241*/
DECLARE @AssetPurityId Int32
SET @AssetPurityId = '3676247'
DECLARE @AssetId Int32
SET @AssetId = '118196'
DECLARE @StatusId Int32
SET @StatusId = '2'
DECLARE @PurityDateTime Date
SET @PurityDateTime = '1/16/2026 6:44:56 PM'
SELECT TOP 1 PurityDateTime, AssetPurityId, PlanogramId, Shelves, PurityStatus, AssetId, ImageReceivedFrom FROM AssetPurity
 WHERE [AssetPurityId] <= @AssetPurityId AND [AssetId] = @AssetId AND [StatusId] = @StatusId AND [PurityDateTime] > @PurityDateTime
 ORDER BY [PurityDateTime] DESC 
2026-01-17 22:43:00.2401 DFramework.Database.NullableDataReader    Data reader open for 311
   at System.Environment.GetStackTrace(Exception e, Boolean needFileInfo)
   at System.Environment.get_StackTrace()
   at DFramework.Database.NullableDataReader.Dispose(Boolean disposing) in C:\CoolR-Group\Framework\DFramework\Database\NullableDataReader.cs:line 33
   at DFramework.Database.NullableDataReader.Dispose() in C:\CoolR-Group\Framework\DFramework\Database\NullableDataReader.cs:line 44
   at CoolR.Tasks.ProcessOutletAlertData.GetAlertDefinitions() in C:\CoolR-Group\portal\CoolR.Tasks\OpportunityOutOfStockByOutlet.cs:line 490
   at CoolR.Tasks.ProcessOutletAlertData.Execute() in C:\CoolR-Group\portal\CoolR.Tasks\OpportunityOutOfStockByOutlet.cs:line 72
   at DFramework.Scheduler.TaskBase.Run() in E:\Forked\Framework\DFramework.Scheduler\TaskBase.cs:line 176
   at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)
   at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)
   at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state)
   at System.Threading.ThreadHelper.ThreadStart() 
2026-01-17 22:43:00.4434 DFramework.Database.Query    /* Time Taken: 583*/
[dbo].GenerateSystemAlerts 
2026-01-17 22:43:10.6230 DFramework.Scheduler.TaskBase    /* Time Taken: 10757.9724*/
Opportunity Out Of Stock By Outlet 
2026-01-17 22:43:53.4018 DFramework.Database.Query    /* Time Taken: 6678*/
DECLARE @AssetPurityId Int32
SET @AssetPurityId = '3676247'
DECLARE @AssetId Int32
SET @AssetId = '118196'
DECLARE @StatusId Int32
SET @StatusId = '2'
DECLARE @PurityDateTime Date
SET @PurityDateTime = '1/16/2026 6:44:56 PM'
SELECT TOP 1 PurityDateTime, AssetPurityId, PlanogramId, Shelves, PurityStatus, AssetId, ImageReceivedFrom FROM AssetPurity
 WHERE [AssetPurityId] <= @AssetPurityId AND [AssetId] = @AssetId AND [StatusId] = @StatusId AND [PurityDateTime] > @PurityDateTime
 ORDER BY [PurityDateTime] DESC 
2026-01-17 22:47:33.6921 DFramework.Database.Query    /* Time Taken: 17970*/
DECLARE @AssetPurityId Int32
SET @AssetPurityId = '3676247'
DECLARE @AssetId Int32
SET @AssetId = '118196'
DECLARE @StatusId Int32
SET @StatusId = '2'
DECLARE @PurityDateTime Date
SET @PurityDateTime = '1/16/2026 6:44:56 PM'
SELECT TOP 1 PurityDateTime, AssetPurityId, PlanogramId, Shelves, PurityStatus, AssetId, ImageReceivedFrom FROM AssetPurity
 WHERE [AssetPurityId] <= @AssetPurityId AND [AssetId] = @AssetId AND [StatusId] = @StatusId AND [PurityDateTime] > @PurityDateTime
 ORDER BY [PurityDateTime] DESC 
2026-01-17 22:54:48.4030 DFramework.Database.Query    /* Time Taken: 14635*/
DECLARE @AssetPurityId Int32
SET @AssetPurityId = '3676247'
DECLARE @AssetId Int32
SET @AssetId = '118196'
DECLARE @StatusId Int32
SET @StatusId = '2'
DECLARE @PurityDateTime Date
SET @PurityDateTime = '1/16/2026 6:44:56 PM'
SELECT TOP 1 PurityDateTime, AssetPurityId, PlanogramId, Shelves, PurityStatus, AssetId, ImageReceivedFrom FROM AssetPurity
 WHERE [AssetPurityId] <= @AssetPurityId AND [AssetId] = @AssetId AND [StatusId] = @StatusId AND [PurityDateTime] > @PurityDateTime
 ORDER BY [PurityDateTime] DESC 
2026-01-17 22:58:00.5126 DFramework.Database.NullableDataReader    Data reader open for 299
   at System.Environment.GetStackTrace(Exception e, Boolean needFileInfo)
   at System.Environment.get_StackTrace()
   at DFramework.Database.NullableDataReader.Dispose(Boolean disposing) in C:\CoolR-Group\Framework\DFramework\Database\NullableDataReader.cs:line 33
   at DFramework.Database.NullableDataReader.Dispose() in C:\CoolR-Group\Framework\DFramework\Database\NullableDataReader.cs:line 44
   at CoolR.Tasks.ProcessOutletAlertData.GetAlertDefinitions() in C:\CoolR-Group\portal\CoolR.Tasks\OpportunityOutOfStockByOutlet.cs:line 490
   at CoolR.Tasks.ProcessOutletAlertData.Execute() in C:\CoolR-Group\portal\CoolR.Tasks\OpportunityOutOfStockByOutlet.cs:line 72
   at DFramework.Scheduler.TaskBase.Run() in E:\Forked\Framework\DFramework.Scheduler\TaskBase.cs:line 176
   at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)
   at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)
   at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state)
   at System.Threading.ThreadHelper.ThreadStart() 
2026-01-17 22:58:10.8622 DFramework.Scheduler.TaskBase    /* Time Taken: 10975.663*/
Opportunity Out Of Stock By Outlet 
2026-01-17 22:58:25.1333 DFramework.Database.Query    /* Time Taken: 2312*/
DECLARE @AssetPurityId Int32
SET @AssetPurityId = '3676247'
DECLARE @AssetId Int32
SET @AssetId = '118196'
DECLARE @StatusId Int32
SET @StatusId = '2'
DECLARE @PurityDateTime Date
SET @PurityDateTime = '1/16/2026 6:44:56 PM'
SELECT TOP 1 PurityDateTime, AssetPurityId, PlanogramId, Shelves, PurityStatus, AssetId, ImageReceivedFrom FROM AssetPurity
 WHERE [AssetPurityId] <= @AssetPurityId AND [AssetId] = @AssetId AND [StatusId] = @StatusId AND [PurityDateTime] > @PurityDateTime
 ORDER BY [PurityDateTime] DESC 
2026-01-17 23:02:09.0050 DFramework.Database.Query    /* Time Taken: 21504*/
DECLARE @AssetPurityId Int32
SET @AssetPurityId = '3676247'
DECLARE @AssetId Int32
SET @AssetId = '118196'
DECLARE @StatusId Int32
SET @StatusId = '2'
DECLARE @PurityDateTime Date
SET @PurityDateTime = '1/16/2026 6:44:56 PM'
SELECT TOP 1 PurityDateTime, AssetPurityId, PlanogramId, Shelves, PurityStatus, AssetId, ImageReceivedFrom FROM AssetPurity
 WHERE [AssetPurityId] <= @AssetPurityId AND [AssetId] = @AssetId AND [StatusId] = @StatusId AND [PurityDateTime] > @PurityDateTime
 ORDER BY [PurityDateTime] DESC 
2026-01-17 23:05:51.6894 DFramework.Database.Query    /* Time Taken: 8436*/
DECLARE @AssetPurityId Int32
SET @AssetPurityId = '3676247'
DECLARE @AssetId Int32
SET @AssetId = '118196'
DECLARE @StatusId Int32
SET @StatusId = '2'
DECLARE @PurityDateTime Date
SET @PurityDateTime = '1/16/2026 6:44:56 PM'
SELECT TOP 1 PurityDateTime, AssetPurityId, PlanogramId, Shelves, PurityStatus, AssetId, ImageReceivedFrom FROM AssetPurity
 WHERE [AssetPurityId] <= @AssetPurityId AND [AssetId] = @AssetId AND [StatusId] = @StatusId AND [PurityDateTime] > @PurityDateTime
 ORDER BY [PurityDateTime] DESC 
2026-01-17 23:09:25.9791 DFramework.Database.Query    /* Time Taken: 13884*/
DECLARE @AssetPurityId Int32
SET @AssetPurityId = '3676247'
DECLARE @AssetId Int32
SET @AssetId = '118196'
DECLARE @StatusId Int32
SET @StatusId = '2'
DECLARE @PurityDateTime Date
SET @PurityDateTime = '1/16/2026 6:44:56 PM'
SELECT TOP 1 PurityDateTime, AssetPurityId, PlanogramId, Shelves, PurityStatus, AssetId, ImageReceivedFrom FROM AssetPurity
 WHERE [AssetPurityId] <= @AssetPurityId AND [AssetId] = @AssetId AND [StatusId] = @StatusId AND [PurityDateTime] > @PurityDateTime
 ORDER BY [PurityDateTime] DESC 
2026-01-17 23:13:08.3177 DFramework.Database.Query    /* Time Taken: 8177*/
DECLARE @AssetPurityId Int32
SET @AssetPurityId = '3676247'
DECLARE @AssetId Int32
SET @AssetId = '118196'
DECLARE @StatusId Int32
SET @StatusId = '2'
DECLARE @PurityDateTime Date
SET @PurityDateTime = '1/16/2026 6:44:56 PM'
SELECT TOP 1 PurityDateTime, AssetPurityId, PlanogramId, Shelves, PurityStatus, AssetId, ImageReceivedFrom FROM AssetPurity
 WHERE [AssetPurityId] <= @AssetPurityId AND [AssetId] = @AssetId AND [StatusId] = @StatusId AND [PurityDateTime] > @PurityDateTime
 ORDER BY [PurityDateTime] DESC 
2026-01-17 23:13:08.8180 DFramework.Database.Query    /* Time Taken: 8916*/
[dbo].GenerateSystemAlerts 
2026-01-17 23:13:13.4662 DFramework.Scheduler.TaskBase    /* Time Taken: 13556.7142*/
Opportunity Out Of Stock By Outlet 
2026-01-17 23:16:48.9738 DFramework.Database.Query    /* Time Taken: 20315*/
DECLARE @AssetPurityId Int32
SET @AssetPurityId = '3676247'
DECLARE @AssetId Int32
SET @AssetId = '118196'
DECLARE @StatusId Int32
SET @StatusId = '2'
DECLARE @PurityDateTime Date
SET @PurityDateTime = '1/16/2026 6:44:56 PM'
SELECT TOP 1 PurityDateTime, AssetPurityId, PlanogramId, Shelves, PurityStatus, AssetId, ImageReceivedFrom FROM AssetPurity
 WHERE [AssetPurityId] <= @AssetPurityId AND [AssetId] = @AssetId AND [StatusId] = @StatusId AND [PurityDateTime] > @PurityDateTime
 ORDER BY [PurityDateTime] DESC 
2026-01-17 23:28:00.3353 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 C:\CoolR-Group\Framework\DFramework\Database\NullableDataReader.cs:line 33
   at DFramework.Database.NullableDataReader.Dispose() in C:\CoolR-Group\Framework\DFramework\Database\NullableDataReader.cs:line 44
   at CoolR.Tasks.ProcessOutletAlertData.GetAlertDefinitions() in C:\CoolR-Group\portal\CoolR.Tasks\OpportunityOutOfStockByOutlet.cs:line 490
   at CoolR.Tasks.ProcessOutletAlertData.Execute() in C:\CoolR-Group\portal\CoolR.Tasks\OpportunityOutOfStockByOutlet.cs:line 72
   at DFramework.Scheduler.TaskBase.Run() in E:\Forked\Framework\DFramework.Scheduler\TaskBase.cs:line 176
   at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)
   at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)
   at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state)
   at System.Threading.ThreadHelper.ThreadStart() 
2026-01-17 23:28:00.4447 DFramework.Database.Query    /* Time Taken: 512*/
[dbo].GenerateSystemAlerts 
2026-01-17 23:28:10.7185 DFramework.Scheduler.TaskBase    /* Time Taken: 10791.261*/
Opportunity Out Of Stock By Outlet 
2026-01-17 23:39:34.4254 DFramework.Database.NullableDataReader    Data reader open for 15565
   at System.Environment.GetStackTrace(Exception e, Boolean needFileInfo)
   at System.Environment.get_StackTrace()
   at DFramework.Database.NullableDataReader.Dispose(Boolean disposing) in C:\CoolR-Group\Framework\DFramework\Database\NullableDataReader.cs:line 33
   at DFramework.Database.NullableDataReader.Dispose() in C:\CoolR-Group\Framework\DFramework\Database\NullableDataReader.cs:line 44
   at CoolR.Tasks.ProcessAlertData.LoadStockData(Int32 currentRecordId, DateTime startDate, DateTime latestEventTime, Int32 assetId, Boolean isComingFromStockLow) in C:\CoolR-Group\portal\CoolR.Tasks\ProcessAlertData.cs:line 1612
   at CoolR.Tasks.ProcessAlertData.StockAlertProductWise(Int32 alertId, Int32 currentRecordId, DateTime latestEventTime, Boolean isForAllProduct, Int32 stockThreshold, Int32 assetId, String alertText, Int32 alertDefinitionId, DateTime startDate, DateTime endDate, Int32 clientId, Int32 locationId, Int32 priorityId) in C:\CoolR-Group\portal\CoolR.Tasks\ProcessAlertData.cs:line 1379
   at CoolR.Tasks.ProcessAlertData.Execute() in C:\CoolR-Group\portal\CoolR.Tasks\ProcessAlertData.cs:line 343
   at DFramework.Scheduler.TaskBase.Run() in E:\Forked\Framework\DFramework.Scheduler\TaskBase.cs:line 176
   at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)
   at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)
   at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state)
   at System.Threading.ThreadHelper.ThreadStart() 
2026-01-17 23:43:00.2925 DFramework.Database.NullableDataReader    Data reader open for 315
   at System.Environment.GetStackTrace(Exception e, Boolean needFileInfo)
   at System.Environment.get_StackTrace()
   at DFramework.Database.NullableDataReader.Dispose(Boolean disposing) in C:\CoolR-Group\Framework\DFramework\Database\NullableDataReader.cs:line 33
   at DFramework.Database.NullableDataReader.Dispose() in C:\CoolR-Group\Framework\DFramework\Database\NullableDataReader.cs:line 44
   at CoolR.Tasks.ProcessOutletAlertData.GetAlertDefinitions() in C:\CoolR-Group\portal\CoolR.Tasks\OpportunityOutOfStockByOutlet.cs:line 490
   at CoolR.Tasks.ProcessOutletAlertData.Execute() in C:\CoolR-Group\portal\CoolR.Tasks\OpportunityOutOfStockByOutlet.cs:line 72
   at DFramework.Scheduler.TaskBase.Run() in E:\Forked\Framework\DFramework.Scheduler\TaskBase.cs:line 176
   at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)
   at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)
   at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state)
   at System.Threading.ThreadHelper.ThreadStart() 
2026-01-17 23:43:00.5272 DFramework.Database.Query    /* Time Taken: 585*/
[dbo].GenerateSystemAlerts 
2026-01-17 23:43:17.0308 DFramework.Database.Query    /* Time Taken: 13757*/
DECLARE @AssetPurityId Int32
SET @AssetPurityId = '3676247'
DECLARE @AssetId Int32
SET @AssetId = '118196'
DECLARE @StatusId Int32
SET @StatusId = '2'
DECLARE @PurityDateTime Date
SET @PurityDateTime = '1/16/2026 6:44:56 PM'
SELECT TOP 1 PurityDateTime, AssetPurityId, PlanogramId, Shelves, PurityStatus, AssetId, ImageReceivedFrom FROM AssetPurity
 WHERE [AssetPurityId] <= @AssetPurityId AND [AssetId] = @AssetId AND [StatusId] = @StatusId AND [PurityDateTime] > @PurityDateTime
 ORDER BY [PurityDateTime] DESC 
2026-01-17 23:43:17.1089 DFramework.Database.Query    /* Time Taken: 11593*/
DECLARE @ClientId Int32
SET @ClientId = '286'
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 = '11/1/2025 12:00:00 AM'
dbo.GetOpportunityOutOfStockDataByOutlet 
2026-01-17 23:43:22.1780 DFramework.Scheduler.TaskBase    /* Time Taken: 22229.7934*/
Opportunity Out Of Stock By Outlet 
2026-01-17 23:46:56.1961 DFramework.Database.Query    /* Time Taken: 18749*/
DECLARE @AssetPurityId Int32
SET @AssetPurityId = '3676247'
DECLARE @AssetId Int32
SET @AssetId = '118196'
DECLARE @StatusId Int32
SET @StatusId = '2'
DECLARE @PurityDateTime Date
SET @PurityDateTime = '1/16/2026 6:44:56 PM'
SELECT TOP 1 PurityDateTime, AssetPurityId, PlanogramId, Shelves, PurityStatus, AssetId, ImageReceivedFrom FROM AssetPurity
 WHERE [AssetPurityId] <= @AssetPurityId AND [AssetId] = @AssetId AND [StatusId] = @StatusId AND [PurityDateTime] > @PurityDateTime
 ORDER BY [PurityDateTime] DESC 
2026-01-17 23:50:40.7236 DFramework.Database.Query    /* Time Taken: 10199*/
DECLARE @AssetPurityId Int32
SET @AssetPurityId = '3676247'
DECLARE @AssetId Int32
SET @AssetId = '118196'
DECLARE @StatusId Int32
SET @StatusId = '2'
DECLARE @PurityDateTime Date
SET @PurityDateTime = '1/16/2026 6:44:56 PM'
SELECT TOP 1 PurityDateTime, AssetPurityId, PlanogramId, Shelves, PurityStatus, AssetId, ImageReceivedFrom FROM AssetPurity
 WHERE [AssetPurityId] <= @AssetPurityId AND [AssetId] = @AssetId AND [StatusId] = @StatusId AND [PurityDateTime] > @PurityDateTime
 ORDER BY [PurityDateTime] DESC 
2026-01-17 23:54:15.8498 DFramework.Database.Query    /* Time Taken: 14745*/
DECLARE @AssetPurityId Int32
SET @AssetPurityId = '3676247'
DECLARE @AssetId Int32
SET @AssetId = '118196'
DECLARE @StatusId Int32
SET @StatusId = '2'
DECLARE @PurityDateTime Date
SET @PurityDateTime = '1/16/2026 6:44:56 PM'
SELECT TOP 1 PurityDateTime, AssetPurityId, PlanogramId, Shelves, PurityStatus, AssetId, ImageReceivedFrom FROM AssetPurity
 WHERE [AssetPurityId] <= @AssetPurityId AND [AssetId] = @AssetId AND [StatusId] = @StatusId AND [PurityDateTime] > @PurityDateTime
 ORDER BY [PurityDateTime] DESC 
2026-01-17 23:58:00.3051 DFramework.Database.Query    /* Time Taken: 10171*/
DECLARE @AssetPurityId Int32
SET @AssetPurityId = '3676247'
DECLARE @AssetId Int32
SET @AssetId = '118196'
DECLARE @StatusId Int32
SET @StatusId = '2'
DECLARE @PurityDateTime Date
SET @PurityDateTime = '1/16/2026 6:44:56 PM'
SELECT TOP 1 PurityDateTime, AssetPurityId, PlanogramId, Shelves, PurityStatus, AssetId, ImageReceivedFrom FROM AssetPurity
 WHERE [AssetPurityId] <= @AssetPurityId AND [AssetId] = @AssetId AND [StatusId] = @StatusId AND [PurityDateTime] > @PurityDateTime
 ORDER BY [PurityDateTime] DESC 
2026-01-17 23:58:00.7916 DFramework.Database.Query    /* Time Taken: 503*/
[dbo].GenerateSystemAlerts 
2026-01-17 23:58:00.9167 DFramework.Database.NullableDataReader    Data reader open for 296
   at System.Environment.GetStackTrace(Exception e, Boolean needFileInfo)
   at System.Environment.get_StackTrace()
   at DFramework.Database.NullableDataReader.Dispose(Boolean disposing) in C:\CoolR-Group\Framework\DFramework\Database\NullableDataReader.cs:line 33
   at DFramework.Database.NullableDataReader.Dispose() in C:\CoolR-Group\Framework\DFramework\Database\NullableDataReader.cs:line 44
   at CoolR.Tasks.ProcessOutletAlertData.GetAlertDefinitions() in C:\CoolR-Group\portal\CoolR.Tasks\OpportunityOutOfStockByOutlet.cs:line 490
   at CoolR.Tasks.ProcessOutletAlertData.Execute() in C:\CoolR-Group\portal\CoolR.Tasks\OpportunityOutOfStockByOutlet.cs:line 72
   at DFramework.Scheduler.TaskBase.Run() in E:\Forked\Framework\DFramework.Scheduler\TaskBase.cs:line 176
   at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)
   at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)
   at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state)
   at System.Threading.ThreadHelper.ThreadStart() 
2026-01-17 23:58:11.2325 DFramework.Scheduler.TaskBase    /* Time Taken: 10958.5843*/
Opportunity Out Of Stock By Outlet