2026-01-03 00:04:29.7303 AlertProcessor    ProcessorAlertData: started 
2026-01-03 00:04:35.1835 AlertProcessor    ProcessorAlertData: Stopped 
2026-01-03 00:09:29.7327 AlertProcessor    ProcessorAlertData: started 
2026-01-03 00:09:35.2640 AlertProcessor    ProcessorAlertData: Stopped 
2026-01-03 00:14:29.7505 AlertProcessor    ProcessorAlertData: started 
2026-01-03 00:14:31.1256 DFramework.Database.NullableDataReader    Data reader open for 274
   at System.Environment.GetStackTrace(Exception e, Boolean needFileInfo)
   at System.Environment.get_StackTrace()
   at DFramework.Database.NullableDataReader.Dispose(Boolean disposing) in D:\Spraxa\Framework\DFramework\Database\NullableDataReader.cs:line 33
   at DFramework.Database.NullableDataReader.Dispose() in D:\Spraxa\Framework\DFramework\Database\NullableDataReader.cs:line 44
   at CoolR.Tasks.ProcessAlertData.Execute() in D:\Spraxa\CoolR-Group\portal\CoolR.Tasks\ProcessAlertData.cs:line 47
   at DFramework.Scheduler.TaskBase.Run() in D:\Spraxa\Framework\DFramework.Scheduler\TaskBase.cs:line 176
   at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)
   at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)
   at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state)
   at System.Threading.ThreadHelper.ThreadStart() 
2026-01-03 00:14:35.4225 AlertProcessor    ProcessorAlertData: Stopped 
2026-01-03 00:14:35.8600 DFramework.Scheduler.TaskBase    /* Time Taken: 15671.9914*/
Opportunity Out Of Stock By Outlet 
2026-01-03 00:19:29.7684 AlertProcessor    ProcessorAlertData: started 
2026-01-03 00:19:35.2841 AlertProcessor    ProcessorAlertData: Stopped 
2026-01-03 00:24:29.7863 AlertProcessor    ProcessorAlertData: started 
2026-01-03 00:24:35.1770 AlertProcessor    ProcessorAlertData: Stopped 
2026-01-03 00:29:29.7885 AlertProcessor    ProcessorAlertData: started 
2026-01-03 00:29:35.1011 AlertProcessor    ProcessorAlertData: Stopped 
2026-01-03 00:29:35.8511 DFramework.Scheduler.TaskBase    /* Time Taken: 15640.7505*/
Opportunity Out Of Stock By Outlet 
2026-01-03 00:34:22.5251 MoveToReorder    Running task for ClientId : 286 and ClientName = India Office QA and Slot: 1/3/2026 2:00:00 PM And LastExecutedOn: 1/3/2026 1:04:22 PM 
2026-01-03 00:34:29.8064 AlertProcessor    ProcessorAlertData: started 
2026-01-03 00:34:35.0408 AlertProcessor    ProcessorAlertData: Stopped 
2026-01-03 00:35:02.1816 DFramework.Database.NullableDataReader    Data reader open for 39416
   at System.Environment.GetStackTrace(Exception e, Boolean needFileInfo)
   at System.Environment.get_StackTrace()
   at DFramework.Database.NullableDataReader.Dispose(Boolean disposing) in D:\Spraxa\Framework\DFramework\Database\NullableDataReader.cs:line 33
   at DFramework.Database.NullableDataReader.Dispose() in D:\Spraxa\Framework\DFramework\Database\NullableDataReader.cs:line 44
   at CoolR.Tasks.MoveToReorder.Execute() in D:\Spraxa\CoolR-Group\portal\CoolR.Tasks\MoveToReorder.cs:line 44
   at DFramework.Scheduler.TaskBase.Run() in D:\Spraxa\Framework\DFramework.Scheduler\TaskBase.cs:line 176
   at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)
   at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)
   at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state)
   at System.Threading.ThreadHelper.ThreadStart() 
2026-01-03 00:35:02.2129 MoveToReorder    Task executed successfully for ClientId : 286 Client Name:India Office QA, Slot: 1/3/2026 2:00:00 PM and Total Order Suggested: 126 Out Of: 126 
2026-01-03 00:35:03.2754 DFramework.Scheduler.TaskBase    /* Time Taken: 41062.796*/
Move To Re-Order 
2026-01-03 00:39:29.8243 AlertProcessor    ProcessorAlertData: started 
2026-01-03 00:39:35.3244 AlertProcessor    ProcessorAlertData: Stopped 
2026-01-03 00:44:29.8423 AlertProcessor    ProcessorAlertData: started 
2026-01-03 00:44:35.1392 AlertProcessor    ProcessorAlertData: Stopped 
2026-01-03 00:44:35.8892 DFramework.Scheduler.TaskBase    /* Time Taken: 15656.3536*/
Opportunity Out Of Stock By Outlet 
2026-01-03 00:49:29.8601 AlertProcessor    ProcessorAlertData: started 
2026-01-03 00:49:35.0945 AlertProcessor    ProcessorAlertData: Stopped 
2026-01-03 00:54:29.8780 AlertProcessor    ProcessorAlertData: started 
2026-01-03 00:54:35.0655 AlertProcessor    ProcessorAlertData: Stopped 
2026-01-03 00:59:20.7865 DFramework.Database.Query    /* Time Taken: 531*/
[dbo].GenerateSystemAlerts 
2026-01-03 00:59:29.8803 AlertProcessor    ProcessorAlertData: started 
2026-01-03 00:59:35.3647 AlertProcessor    ProcessorAlertData: Stopped 
2026-01-03 00:59:35.9585 DFramework.Scheduler.TaskBase    /* Time Taken: 15703.2429*/
Opportunity Out Of Stock By Outlet 
2026-01-03 01:04:29.8982 AlertProcessor    ProcessorAlertData: started 
2026-01-03 01:04:35.2263 AlertProcessor    ProcessorAlertData: Stopped 
2026-01-03 01:09:29.9161 AlertProcessor    ProcessorAlertData: started 
2026-01-03 01:09:35.3380 AlertProcessor    ProcessorAlertData: Stopped 
2026-01-03 01:14:29.9339 AlertProcessor    ProcessorAlertData: started 
2026-01-03 01:14:35.4027 AlertProcessor    ProcessorAlertData: Stopped 
2026-01-03 01:14:35.9652 DFramework.Scheduler.TaskBase    /* Time Taken: 15687.6128*/
Opportunity Out Of Stock By Outlet 
2026-01-03 01:19:29.9361 AlertProcessor    ProcessorAlertData: started 
2026-01-03 01:19:35.2331 AlertProcessor    ProcessorAlertData: Stopped 
2026-01-03 01:24:29.9540 AlertProcessor    ProcessorAlertData: started 
2026-01-03 01:24:35.4228 AlertProcessor    ProcessorAlertData: Stopped 
2026-01-03 01:29:20.7999 DFramework.Database.Query    /* Time Taken: 526*/
[dbo].GenerateSystemAlerts 
2026-01-03 01:29:29.9718 AlertProcessor    ProcessorAlertData: started 
2026-01-03 01:29:35.3781 AlertProcessor    ProcessorAlertData: Stopped 
2026-01-03 01:29:36.0031 DFramework.Scheduler.TaskBase    /* Time Taken: 15718.8621*/
Opportunity Out Of Stock By Outlet 
2026-01-03 01:34:22.6303 MoveToReorder    Running task for ClientId : 286 and ClientName = India Office QA and Slot: 1/3/2026 3:00:00 PM And LastExecutedOn: 1/3/2026 2:04:22 PM 
2026-01-03 01:34:22.8647 MoveToReorder    Task executed successfully for ClientId : 286 Client Name:India Office QA, Slot: 1/3/2026 3:00:00 PM But No Order found to suggest 
2026-01-03 01:34:29.9898 AlertProcessor    ProcessorAlertData: started 
2026-01-03 01:34:35.4273 AlertProcessor    ProcessorAlertData: Stopped 
2026-01-03 01:39:30.0076 AlertProcessor    ProcessorAlertData: started 
2026-01-03 01:39:35.4452 AlertProcessor    ProcessorAlertData: Stopped 
2026-01-03 01:44:20.7910 DFramework.Database.Query    /* Time Taken: 513*/
[dbo].GenerateSystemAlerts 
2026-01-03 01:44:30.0255 AlertProcessor    ProcessorAlertData: started 
2026-01-03 01:44:35.2443 AlertProcessor    ProcessorAlertData: Stopped 
2026-01-03 01:44:35.9943 DFramework.Scheduler.TaskBase    /* Time Taken: 15703.2329*/
Opportunity Out Of Stock By Outlet 
2026-01-03 01:49:30.0435 AlertProcessor    ProcessorAlertData: started 
2026-01-03 01:49:35.0904 AlertProcessor    ProcessorAlertData: Stopped 
2026-01-03 01:54:30.0614 AlertProcessor    ProcessorAlertData: started 
2026-01-03 01:54:35.0927 AlertProcessor    ProcessorAlertData: Stopped 
2026-01-03 01:59:30.0792 AlertProcessor    ProcessorAlertData: started 
2026-01-03 01:59:35.5324 AlertProcessor    ProcessorAlertData: Stopped 
2026-01-03 01:59:35.8762 DFramework.Scheduler.TaskBase    /* Time Taken: 15578.2494*/
Opportunity Out Of Stock By Outlet 
2026-01-03 02:04:30.0972 AlertProcessor    ProcessorAlertData: started 
2026-01-03 02:04:35.5034 AlertProcessor    ProcessorAlertData: Stopped 
2026-01-03 02:09:30.0995 AlertProcessor    ProcessorAlertData: started 
2026-01-03 02:09:35.3964 DFramework.Database.NullableDataReader    Data reader open for 276
   at System.Environment.GetStackTrace(Exception e, Boolean needFileInfo)
   at System.Environment.get_StackTrace()
   at DFramework.Database.NullableDataReader.Dispose(Boolean disposing) in D:\Spraxa\Framework\DFramework\Database\NullableDataReader.cs:line 33
   at DFramework.Database.NullableDataReader.Dispose() in D:\Spraxa\Framework\DFramework\Database\NullableDataReader.cs:line 44
   at CoolR.Tasks.ProcessAlertData.Execute() in D:\Spraxa\CoolR-Group\portal\CoolR.Tasks\ProcessAlertData.cs:line 47
   at DFramework.Scheduler.TaskBase.Run() in D:\Spraxa\Framework\DFramework.Scheduler\TaskBase.cs:line 176
   at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)
   at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)
   at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state)
   at System.Threading.ThreadHelper.ThreadStart() 
2026-01-03 02:09:35.8808 AlertProcessor    ProcessorAlertData: Stopped 
2026-01-03 02:14:20.8516 DFramework.Database.Query    /* Time Taken: 539*/
[dbo].GenerateSystemAlerts 
2026-01-03 02:14:30.1173 AlertProcessor    ProcessorAlertData: started 
2026-01-03 02:14:35.6486 AlertProcessor    ProcessorAlertData: Stopped 
2026-01-03 02:14:35.9299 DFramework.Scheduler.TaskBase    /* Time Taken: 15609.488*/
Opportunity Out Of Stock By Outlet 
2026-01-03 02:19:30.1352 AlertProcessor    ProcessorAlertData: started 
2026-01-03 02:19:35.6821 AlertProcessor    ProcessorAlertData: Stopped 
2026-01-03 02:24:30.1360 AlertProcessor    ProcessorAlertData: started 
2026-01-03 02:24:35.5891 AlertProcessor    ProcessorAlertData: Stopped 
2026-01-03 02:29:30.1533 AlertProcessor    ProcessorAlertData: started 
2026-01-03 02:29:35.5908 AlertProcessor    ProcessorAlertData: Stopped 
2026-01-03 02:29:35.9502 DFramework.Scheduler.TaskBase    /* Time Taken: 15609.4759*/
Opportunity Out Of Stock By Outlet 
2026-01-03 02:30:09.1379 DFramework.Database.Query    /* Time Taken: 638*/
DECLARE @IsFileProcessed Int32
SET @IsFileProcessed = '0'
DECLARE @TaskNumber Int32
SET @TaskNumber = '2'
DECLARE @IsDeleted Int32
SET @IsDeleted = '0'
SELECT TOP 1000 IncomingFileId, GatewayId,GatewayMac,RawFileName,AzureContainerName,StartIndex,Tries, CreatedOn FROM IncomingFile
 WHERE [IsFileProcessed] = @IsFileProcessed AND [TaskNumber] = @TaskNumber AND [IsDeleted] = @IsDeleted
 
2026-01-03 02:30:24.5286 DFramework.Database.Query    /* Time Taken: 991*/
DECLARE @IsFileProcessed Int32
SET @IsFileProcessed = '0'
DECLARE @TaskNumber Int32
SET @TaskNumber = '3'
DECLARE @IsDeleted Int32
SET @IsDeleted = '0'
SELECT TOP 1000 IncomingFileId, GatewayId,GatewayMac,RawFileName,AzureContainerName,StartIndex,Tries, CreatedOn FROM IncomingFile
 WHERE [IsFileProcessed] = @IsFileProcessed AND [TaskNumber] = @TaskNumber AND [IsDeleted] = @IsDeleted
 
2026-01-03 02:30:30.1536 DFramework.Database.Query    /* Time Taken: 1608*/
DECLARE @IsFileProcessed Int32
SET @IsFileProcessed = '0'
DECLARE @TaskNumber Int32
SET @TaskNumber = '3'
DECLARE @IsDeleted Int32
SET @IsDeleted = '0'
SELECT TOP 1000 IncomingFileId, GatewayId,GatewayMac,RawFileName,AzureContainerName,StartIndex,Tries, CreatedOn FROM IncomingFile
 WHERE [IsFileProcessed] = @IsFileProcessed AND [TaskNumber] = @TaskNumber AND [IsDeleted] = @IsDeleted
 
2026-01-03 02:30:32.0130 DFramework.Database.Query    /* Time Taken: 18493*/
DECLARE @IsFileProcessed Int32
SET @IsFileProcessed = '0'
DECLARE @TaskNumber Int32
SET @TaskNumber = '0'
DECLARE @IsDeleted Int32
SET @IsDeleted = '0'
SELECT TOP 1000 IncomingFileId, GatewayId,GatewayMac,RawFileName,AzureContainerName,StartIndex,Tries, CreatedOn FROM IncomingFile
 WHERE [IsFileProcessed] = @IsFileProcessed AND [TaskNumber] = @TaskNumber AND [IsDeleted] = @IsDeleted
 
2026-01-03 02:30:32.0130 DFramework.Scheduler.TaskBase    /* Time Taken: 18484.4982*/
ProcessSQLUnprocessedFiles 
2026-01-03 02:30:32.0130 DFramework.Database.Query    /* Time Taken: 18495*/
DECLARE @IsFileProcessed Int32
SET @IsFileProcessed = '0'
DECLARE @TaskNumber Int32
SET @TaskNumber = '1'
DECLARE @IsDeleted Int32
SET @IsDeleted = '0'
SELECT TOP 1000 IncomingFileId, GatewayId,GatewayMac,RawFileName,AzureContainerName,StartIndex,Tries, CreatedOn FROM IncomingFile
 WHERE [IsFileProcessed] = @IsFileProcessed AND [TaskNumber] = @TaskNumber AND [IsDeleted] = @IsDeleted
 
2026-01-03 02:30:32.0130 DFramework.Scheduler.TaskBase    /* Time Taken: 18484.4982*/
ProcessSQLUnprocessedFiles 
2026-01-03 02:30:39.8256 DFramework.Database.Query    /* Time Taken: 1240*/
DECLARE @IsFileProcessed Int32
SET @IsFileProcessed = '0'
DECLARE @TaskNumber Int32
SET @TaskNumber = '0'
DECLARE @IsDeleted Int32
SET @IsDeleted = '0'
SELECT TOP 1000 IncomingFileId, GatewayId,GatewayMac,RawFileName,AzureContainerName,StartIndex,Tries, CreatedOn FROM IncomingFile
 WHERE [IsFileProcessed] = @IsFileProcessed AND [TaskNumber] = @TaskNumber AND [IsDeleted] = @IsDeleted
 
2026-01-03 02:30:40.7787 DFramework.Database.Query    /* Time Taken: 2200*/
DECLARE @IsFileProcessed Int32
SET @IsFileProcessed = '0'
DECLARE @TaskNumber Int32
SET @TaskNumber = '1'
DECLARE @IsDeleted Int32
SET @IsDeleted = '0'
SELECT TOP 1000 IncomingFileId, GatewayId,GatewayMac,RawFileName,AzureContainerName,StartIndex,Tries, CreatedOn FROM IncomingFile
 WHERE [IsFileProcessed] = @IsFileProcessed AND [TaskNumber] = @TaskNumber AND [IsDeleted] = @IsDeleted
 
2026-01-03 02:30:44.8881 DFramework.Database.Query    /* Time Taken: 1280*/
DECLARE @IsFileProcessed Int32
SET @IsFileProcessed = '0'
DECLARE @TaskNumber Int32
SET @TaskNumber = '0'
DECLARE @IsDeleted Int32
SET @IsDeleted = '0'
SELECT TOP 1000 IncomingFileId, GatewayId,GatewayMac,RawFileName,AzureContainerName,StartIndex,Tries, CreatedOn FROM IncomingFile
 WHERE [IsFileProcessed] = @IsFileProcessed AND [TaskNumber] = @TaskNumber AND [IsDeleted] = @IsDeleted
 
2026-01-03 02:30:48.5288 DFramework.Database.Query    /* Time Taken: 34999*/
DECLARE @IsFileProcessed Int32
SET @IsFileProcessed = '0'
DECLARE @TaskNumber Int32
SET @TaskNumber = '4'
DECLARE @IsDeleted Int32
SET @IsDeleted = '0'
SELECT TOP 1000 IncomingFileId, GatewayId,GatewayMac,RawFileName,AzureContainerName,StartIndex,Tries, CreatedOn FROM IncomingFile
 WHERE [IsFileProcessed] = @IsFileProcessed AND [TaskNumber] = @TaskNumber AND [IsDeleted] = @IsDeleted
 
2026-01-03 02:30:48.6069 DFramework.Scheduler.TaskBase    /* Time Taken: 35078.3553*/
ProcessSQLUnprocessedFiles 
2026-01-03 02:30:50.2631 DFramework.Database.Query    /* Time Taken: 1641*/
DECLARE @IsFileProcessed Int32
SET @IsFileProcessed = '0'
DECLARE @TaskNumber Int32
SET @TaskNumber = '0'
DECLARE @IsDeleted Int32
SET @IsDeleted = '0'
SELECT TOP 1000 IncomingFileId, GatewayId,GatewayMac,RawFileName,AzureContainerName,StartIndex,Tries, CreatedOn FROM IncomingFile
 WHERE [IsFileProcessed] = @IsFileProcessed AND [TaskNumber] = @TaskNumber AND [IsDeleted] = @IsDeleted
 
2026-01-03 02:30:51.0288 DFramework.Database.Query    /* Time Taken: 2409*/
DECLARE @IsFileProcessed Int32
SET @IsFileProcessed = '0'
DECLARE @TaskNumber Int32
SET @TaskNumber = '2'
DECLARE @IsDeleted Int32
SET @IsDeleted = '0'
SELECT TOP 1000 IncomingFileId, GatewayId,GatewayMac,RawFileName,AzureContainerName,StartIndex,Tries, CreatedOn FROM IncomingFile
 WHERE [IsFileProcessed] = @IsFileProcessed AND [TaskNumber] = @TaskNumber AND [IsDeleted] = @IsDeleted
 
2026-01-03 02:30:51.9819 DFramework.Database.Query    /* Time Taken: 18416*/
DECLARE @IsFileProcessed Int32
SET @IsFileProcessed = '0'
DECLARE @TaskNumber Int32
SET @TaskNumber = '3'
DECLARE @IsDeleted Int32
SET @IsDeleted = '0'
SELECT TOP 1000 IncomingFileId, GatewayId,GatewayMac,RawFileName,AzureContainerName,StartIndex,Tries, CreatedOn FROM IncomingFile
 WHERE [IsFileProcessed] = @IsFileProcessed AND [TaskNumber] = @TaskNumber AND [IsDeleted] = @IsDeleted
 
2026-01-03 02:30:51.9819 DFramework.Scheduler.TaskBase    /* Time Taken: 18406.374*/
ProcessSQLUnprocessedFiles 
2026-01-03 02:31:01.6538 DFramework.Database.Query    /* Time Taken: 18059*/
DECLARE @IsFileProcessed Int32
SET @IsFileProcessed = '0'
DECLARE @TaskNumber Int32
SET @TaskNumber = '1'
DECLARE @IsDeleted Int32
SET @IsDeleted = '0'
SELECT TOP 1000 IncomingFileId, GatewayId,GatewayMac,RawFileName,AzureContainerName,StartIndex,Tries, CreatedOn FROM IncomingFile
 WHERE [IsFileProcessed] = @IsFileProcessed AND [TaskNumber] = @TaskNumber AND [IsDeleted] = @IsDeleted
 
2026-01-03 02:31:01.6538 DFramework.Scheduler.TaskBase    /* Time Taken: 18046.9873*/
ProcessSQLUnprocessedFiles 
2026-01-03 02:34:22.7490 MoveToReorder    Running task for ClientId : 286 and ClientName = India Office QA and Slot: 1/3/2026 4:00:00 PM And LastExecutedOn: 1/3/2026 3:04:22 PM 
2026-01-03 02:34:22.9990 MoveToReorder    Task executed successfully for ClientId : 286 Client Name:India Office QA, Slot: 1/3/2026 4:00:00 PM But No Order found to suggest 
2026-01-03 02:34:30.1709 AlertProcessor    ProcessorAlertData: started 
2026-01-03 02:34:35.6241 AlertProcessor    ProcessorAlertData: Stopped 
2026-01-03 02:39:30.1896 AlertProcessor    ProcessorAlertData: started 
2026-01-03 02:39:35.5490 AlertProcessor    ProcessorAlertData: Stopped 
2026-01-03 02:44:20.8802 DFramework.Database.Query    /* Time Taken: 528*/
[dbo].GenerateSystemAlerts 
2026-01-03 02:44:30.2084 AlertProcessor    ProcessorAlertData: started 
2026-01-03 02:44:35.6615 AlertProcessor    ProcessorAlertData: Stopped 
2026-01-03 02:44:35.9897 DFramework.Scheduler.TaskBase    /* Time Taken: 15625.148*/
Opportunity Out Of Stock By Outlet 
2026-01-03 02:49:30.2265 AlertProcessor    ProcessorAlertData: started 
2026-01-03 02:49:35.2890 AlertProcessor    ProcessorAlertData: Stopped 
2026-01-03 02:54:30.2444 AlertProcessor    ProcessorAlertData: started 
2026-01-03 02:54:35.2913 AlertProcessor    ProcessorAlertData: Stopped 
2026-01-03 02:59:20.9186 DFramework.Database.Query    /* Time Taken: 539*/
[dbo].GenerateSystemAlerts 
2026-01-03 02:59:30.2624 AlertProcessor    ProcessorAlertData: started 
2026-01-03 02:59:33.6843 DFramework.Database.NullableDataReader    Data reader open for 277
   at System.Environment.GetStackTrace(Exception e, Boolean needFileInfo)
   at System.Environment.get_StackTrace()
   at DFramework.Database.NullableDataReader.Dispose(Boolean disposing) in D:\Spraxa\Framework\DFramework\Database\NullableDataReader.cs:line 33
   at DFramework.Database.NullableDataReader.Dispose() in D:\Spraxa\Framework\DFramework\Database\NullableDataReader.cs:line 44
   at CoolR.Tasks.ProcessAlertData.Execute() in D:\Spraxa\CoolR-Group\portal\CoolR.Tasks\ProcessAlertData.cs:line 47
   at DFramework.Scheduler.TaskBase.Run() in D:\Spraxa\Framework\DFramework.Scheduler\TaskBase.cs:line 176
   at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)
   at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)
   at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state)
   at System.Threading.ThreadHelper.ThreadStart() 
2026-01-03 02:59:35.8250 AlertProcessor    ProcessorAlertData: Stopped 
2026-01-03 02:59:36.0125 DFramework.Scheduler.TaskBase    /* Time Taken: 15625.1167*/
Opportunity Out Of Stock By Outlet 
2026-01-03 03:04:30.2803 AlertProcessor    ProcessorAlertData: started 
2026-01-03 03:04:35.5460 AlertProcessor    ProcessorAlertData: Stopped 
2026-01-03 03:09:30.2982 AlertProcessor    ProcessorAlertData: started 
2026-01-03 03:09:35.5482 AlertProcessor    ProcessorAlertData: Stopped 
2026-01-03 03:14:30.3161 AlertProcessor    ProcessorAlertData: started 
2026-01-03 03:14:35.5974 AlertProcessor    ProcessorAlertData: Stopped 
2026-01-03 03:14:36.0349 DFramework.Scheduler.TaskBase    /* Time Taken: 15625.1218*/
Opportunity Out Of Stock By Outlet 
2026-01-03 03:19:30.3340 AlertProcessor    ProcessorAlertData: started 
2026-01-03 03:19:35.5372 AlertProcessor    ProcessorAlertData: Stopped 
2026-01-03 03:24:30.3362 AlertProcessor    ProcessorAlertData: started 
2026-01-03 03:24:35.5238 AlertProcessor    ProcessorAlertData: Stopped 
2026-01-03 03:29:30.3541 AlertProcessor    ProcessorAlertData: started 
2026-01-03 03:29:35.4166 AlertProcessor    ProcessorAlertData: Stopped 
2026-01-03 03:29:36.0416 DFramework.Scheduler.TaskBase    /* Time Taken: 15609.4754*/
Opportunity Out Of Stock By Outlet 
2026-01-03 03:34:22.8250 MoveToReorder    Running task for ClientId : 286 and ClientName = India Office QA and Slot: 1/3/2026 5:00:00 PM And LastExecutedOn: 1/3/2026 4:04:22 PM 
2026-01-03 03:34:30.3563 AlertProcessor    ProcessorAlertData: started 
2026-01-03 03:34:35.4814 AlertProcessor    ProcessorAlertData: Stopped 
2026-01-03 03:35:02.8566 DFramework.Database.NullableDataReader    Data reader open for 39791
   at System.Environment.GetStackTrace(Exception e, Boolean needFileInfo)
   at System.Environment.get_StackTrace()
   at DFramework.Database.NullableDataReader.Dispose(Boolean disposing) in D:\Spraxa\Framework\DFramework\Database\NullableDataReader.cs:line 33
   at DFramework.Database.NullableDataReader.Dispose() in D:\Spraxa\Framework\DFramework\Database\NullableDataReader.cs:line 44
   at CoolR.Tasks.MoveToReorder.Execute() in D:\Spraxa\CoolR-Group\portal\CoolR.Tasks\MoveToReorder.cs:line 44
   at DFramework.Scheduler.TaskBase.Run() in D:\Spraxa\Framework\DFramework.Scheduler\TaskBase.cs:line 176
   at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)
   at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)
   at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state)
   at System.Threading.ThreadHelper.ThreadStart() 
2026-01-03 03:35:02.8878 MoveToReorder    Task executed successfully for ClientId : 286 Client Name:India Office QA, Slot: 1/3/2026 5:00:00 PM and Total Order Suggested: 126 Out Of: 126 
2026-01-03 03:35:03.7316 DFramework.Scheduler.TaskBase    /* Time Taken: 41203.4328*/
Move To Re-Order 
2026-01-03 03:39:30.3742 AlertProcessor    ProcessorAlertData: started 
2026-01-03 03:39:35.4211 DFramework.Database.Query    /* Time Taken: 562*/
DECLARE @TableName AnsiString(8000)
SET @TableName = 'ProductStockLevel'
DECLARE @CurrentRecordId Int32
SET @CurrentRecordId = '3675525'
dbo.GetValidDeviceForAlertProcessData 
2026-01-03 03:39:35.4680 AlertProcessor    ProcessorAlertData: Stopped 
2026-01-03 03:44:30.3920 AlertProcessor    ProcessorAlertData: started 
2026-01-03 03:44:35.2983 AlertProcessor    ProcessorAlertData: Stopped 
2026-01-03 03:44:36.0639 DFramework.Scheduler.TaskBase    /* Time Taken: 15609.4907*/
Opportunity Out Of Stock By Outlet 
2026-01-03 03:49:30.4101 AlertProcessor    ProcessorAlertData: started 
2026-01-03 03:49:35.4101 AlertProcessor    ProcessorAlertData: Stopped 
2026-01-03 03:54:30.4280 AlertProcessor    ProcessorAlertData: started 
2026-01-03 03:54:35.5218 AlertProcessor    ProcessorAlertData: Stopped 
2026-01-03 03:59:30.4459 AlertProcessor    ProcessorAlertData: started 
2026-01-03 03:59:35.4772 AlertProcessor    ProcessorAlertData: Stopped 
2026-01-03 03:59:36.1022 DFramework.Scheduler.TaskBase    /* Time Taken: 15640.7386*/
Opportunity Out Of Stock By Outlet 
2026-01-03 04:04:30.4638 AlertProcessor    ProcessorAlertData: started 
2026-01-03 04:04:35.4951 AlertProcessor    ProcessorAlertData: Stopped 
2026-01-03 04:09:30.4818 AlertProcessor    ProcessorAlertData: started 
2026-01-03 04:09:35.5443 AlertProcessor    ProcessorAlertData: Stopped 
2026-01-03 04:14:30.4840 AlertProcessor    ProcessorAlertData: started 
2026-01-03 04:14:35.5622 AlertProcessor    ProcessorAlertData: Stopped 
2026-01-03 04:14:36.0465 DFramework.Scheduler.TaskBase    /* Time Taken: 15562.6142*/
Opportunity Out Of Stock By Outlet 
2026-01-03 04:19:30.4863 AlertProcessor    ProcessorAlertData: started 
2026-01-03 04:19:35.4863 AlertProcessor    ProcessorAlertData: Stopped 
2026-01-03 04:24:30.5042 AlertProcessor    ProcessorAlertData: started 
2026-01-03 04:24:35.5668 AlertProcessor    ProcessorAlertData: Stopped 
2026-01-03 04:29:30.5221 AlertProcessor    ProcessorAlertData: started 
2026-01-03 04:29:35.4909 AlertProcessor    ProcessorAlertData: Stopped 
2026-01-03 04:29:36.1784 DFramework.Scheduler.TaskBase    /* Time Taken: 15671.9911*/
Opportunity Out Of Stock By Outlet 
2026-01-03 04:34:22.9462 MoveToReorder    Running task for ClientId : 286 and ClientName = India Office QA and Slot: 1/3/2026 6:00:00 PM And LastExecutedOn: 1/3/2026 5:04:22 PM 
2026-01-03 04:34:23.1493 MoveToReorder    Task executed successfully for ClientId : 286 Client Name:India Office QA, Slot: 1/3/2026 6:00:00 PM But No Order found to suggest 
2026-01-03 04:34:30.5400 AlertProcessor    ProcessorAlertData: started 
2026-01-03 04:34:35.4306 AlertProcessor    ProcessorAlertData: Stopped 
2026-01-03 04:39:30.5579 AlertProcessor    ProcessorAlertData: started 
2026-01-03 04:39:35.5110 AlertProcessor    ProcessorAlertData: Stopped 
2026-01-03 04:44:30.5757 AlertProcessor    ProcessorAlertData: started 
2026-01-03 04:44:35.5758 AlertProcessor    ProcessorAlertData: Stopped 
2026-01-03 04:44:36.0601 DFramework.Scheduler.TaskBase    /* Time Taken: 15531.3634*/
Opportunity Out Of Stock By Outlet 
2026-01-03 04:49:30.5936 AlertProcessor    ProcessorAlertData: started 
2026-01-03 04:49:35.6249 AlertProcessor    ProcessorAlertData: Stopped 
2026-01-03 04:54:30.6115 AlertProcessor    ProcessorAlertData: started 
2026-01-03 04:54:35.7365 AlertProcessor    ProcessorAlertData: Stopped 
2026-01-03 04:59:30.6294 AlertProcessor    ProcessorAlertData: started 
2026-01-03 04:59:35.5982 AlertProcessor    ProcessorAlertData: Stopped 
2026-01-03 04:59:36.2232 DFramework.Scheduler.TaskBase    /* Time Taken: 15671.9952*/
Opportunity Out Of Stock By Outlet 
2026-01-03 05:04:30.6316 AlertProcessor    ProcessorAlertData: started 
2026-01-03 05:04:35.6473 AlertProcessor    ProcessorAlertData: Stopped 
2026-01-03 05:09:30.6495 AlertProcessor    ProcessorAlertData: started 
2026-01-03 05:09:35.7589 AlertProcessor    ProcessorAlertData: Stopped 
2026-01-03 05:14:21.0735 DFramework.Database.Query    /* Time Taken: 505*/
[dbo].GenerateSystemAlerts 
2026-01-03 05:14:30.6673 AlertProcessor    ProcessorAlertData: started 
2026-01-03 05:14:35.6205 AlertProcessor    ProcessorAlertData: Stopped 
2026-01-03 05:14:36.2299 DFramework.Scheduler.TaskBase    /* Time Taken: 15656.3645*/
Opportunity Out Of Stock By Outlet 
2026-01-03 05:19:30.6852 AlertProcessor    ProcessorAlertData: started 
2026-01-03 05:19:35.6696 AlertProcessor    ProcessorAlertData: Stopped 
2026-01-03 05:24:30.7031 AlertProcessor    ProcessorAlertData: started 
2026-01-03 05:24:35.6406 AlertProcessor    ProcessorAlertData: Stopped 
2026-01-03 05:29:30.7210 AlertProcessor    ProcessorAlertData: started 
2026-01-03 05:29:35.6898 AlertProcessor    ProcessorAlertData: Stopped 
2026-01-03 05:29:36.1273 DFramework.Scheduler.TaskBase    /* Time Taken: 15531.381*/
Opportunity Out Of Stock By Outlet 
2026-01-03 05:34:23.0670 MoveToReorder    Running task for ClientId : 286 and ClientName = India Office QA and Slot: 1/3/2026 7:00:00 PM And LastExecutedOn: 1/3/2026 6:04:22 PM 
2026-01-03 05:34:23.2545 MoveToReorder    Task executed successfully for ClientId : 286 Client Name:India Office QA, Slot: 1/3/2026 7:00:00 PM But No Order found to suggest 
2026-01-03 05:34:30.7389 AlertProcessor    ProcessorAlertData: started 
2026-01-03 05:34:34.1764 DFramework.Database.NullableDataReader    Data reader open for 266
   at System.Environment.GetStackTrace(Exception e, Boolean needFileInfo)
   at System.Environment.get_StackTrace()
   at DFramework.Database.NullableDataReader.Dispose(Boolean disposing) in D:\Spraxa\Framework\DFramework\Database\NullableDataReader.cs:line 33
   at DFramework.Database.NullableDataReader.Dispose() in D:\Spraxa\Framework\DFramework\Database\NullableDataReader.cs:line 44
   at CoolR.Tasks.ProcessAlertData.Execute() in D:\Spraxa\CoolR-Group\portal\CoolR.Tasks\ProcessAlertData.cs:line 47
   at DFramework.Scheduler.TaskBase.Run() in D:\Spraxa\Framework\DFramework.Scheduler\TaskBase.cs:line 176
   at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)
   at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)
   at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state)
   at System.Threading.ThreadHelper.ThreadStart() 
2026-01-03 05:34:35.9421 AlertProcessor    ProcessorAlertData: Stopped 
2026-01-03 05:39:30.7568 AlertProcessor    ProcessorAlertData: started 
2026-01-03 05:39:35.7568 AlertProcessor    ProcessorAlertData: Stopped 
2026-01-03 05:44:30.7590 AlertProcessor    ProcessorAlertData: started 
2026-01-03 05:44:35.7434 AlertProcessor    ProcessorAlertData: Stopped 
2026-01-03 05:44:36.1340 DFramework.Scheduler.TaskBase    /* Time Taken: 15531.3655*/
Opportunity Out Of Stock By Outlet 
2026-01-03 05:49:30.7614 AlertProcessor    ProcessorAlertData: started 
2026-01-03 05:49:35.7302 AlertProcessor    ProcessorAlertData: Stopped 
2026-01-03 05:54:30.7637 AlertProcessor    ProcessorAlertData: started 
2026-01-03 05:54:35.8731 AlertProcessor    ProcessorAlertData: Stopped 
2026-01-03 05:59:30.7659 AlertProcessor    ProcessorAlertData: started 
2026-01-03 05:59:35.7503 AlertProcessor    ProcessorAlertData: Stopped 
2026-01-03 05:59:36.2035 DFramework.Scheduler.TaskBase    /* Time Taken: 15578.2317*/
Opportunity Out Of Stock By Outlet 
2026-01-03 06:04:30.7838 AlertProcessor    ProcessorAlertData: started 
2026-01-03 06:04:35.7370 AlertProcessor    ProcessorAlertData: Stopped 
2026-01-03 06:09:30.8017 AlertProcessor    ProcessorAlertData: started 
2026-01-03 06:09:35.7705 AlertProcessor    ProcessorAlertData: Stopped 
2026-01-03 06:14:30.8196 AlertProcessor    ProcessorAlertData: started 
2026-01-03 06:14:35.8978 AlertProcessor    ProcessorAlertData: Stopped 
2026-01-03 06:14:36.2415 DFramework.Scheduler.TaskBase    /* Time Taken: 15593.869*/
Opportunity Out Of Stock By Outlet 
2026-01-03 06:19:30.8375 AlertProcessor    ProcessorAlertData: started 
2026-01-03 06:19:35.8531 AlertProcessor    ProcessorAlertData: Stopped 
2026-01-03 06:24:30.8554 AlertProcessor    ProcessorAlertData: started 
2026-01-03 06:24:35.9336 AlertProcessor    ProcessorAlertData: Stopped 
2026-01-03 06:29:30.8733 AlertProcessor    ProcessorAlertData: started 
2026-01-03 06:29:35.7952 AlertProcessor    ProcessorAlertData: Stopped 
2026-01-03 06:29:36.2483 DFramework.Scheduler.TaskBase    /* Time Taken: 15593.8653*/
Opportunity Out Of Stock By Outlet 
2026-01-03 06:34:23.1880 MoveToReorder    Running task for ClientId : 286 and ClientName = India Office QA and Slot: 1/3/2026 8:00:00 PM And LastExecutedOn: 1/3/2026 7:04:23 PM 
2026-01-03 06:34:30.8912 AlertProcessor    ProcessorAlertData: started 
2026-01-03 06:34:35.9694 AlertProcessor    ProcessorAlertData: Stopped 
2026-01-03 06:35:01.8914 DFramework.Database.NullableDataReader    Data reader open for 38487
   at System.Environment.GetStackTrace(Exception e, Boolean needFileInfo)
   at System.Environment.get_StackTrace()
   at DFramework.Database.NullableDataReader.Dispose(Boolean disposing) in D:\Spraxa\Framework\DFramework\Database\NullableDataReader.cs:line 33
   at DFramework.Database.NullableDataReader.Dispose() in D:\Spraxa\Framework\DFramework\Database\NullableDataReader.cs:line 44
   at CoolR.Tasks.MoveToReorder.Execute() in D:\Spraxa\CoolR-Group\portal\CoolR.Tasks\MoveToReorder.cs:line 44
   at DFramework.Scheduler.TaskBase.Run() in D:\Spraxa\Framework\DFramework.Scheduler\TaskBase.cs:line 176
   at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)
   at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)
   at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state)
   at System.Threading.ThreadHelper.ThreadStart() 
2026-01-03 06:35:01.9227 MoveToReorder    Task executed successfully for ClientId : 286 Client Name:India Office QA, Slot: 1/3/2026 8:00:00 PM and Total Order Suggested: 126 Out Of: 126 
2026-01-03 06:35:02.7352 DFramework.Scheduler.TaskBase    /* Time Taken: 39859.6755*/
Move To Re-Order 
2026-01-03 06:39:30.9091 AlertProcessor    ProcessorAlertData: started 
2026-01-03 06:39:31.9872 DFramework.Database.Query    /* Time Taken: 1084*/
DECLARE @StatusId Int32
SET @StatusId = '1'
DECLARE @AlertId Int32
SET @AlertId = '7571914'
SELECT TOP 10000 Alert.AlertId, Alert.LocationId, Alert.RecordId, ISNULL(AlertDefinition.Name, Alert.AlertText) Name, Alert.AlertTypeId, Alert.AlertText, ISNULL(Location.Name, '') AS LocationName, AlertDefinition.ClientId, AlertRecipient.RoleId,
									CASE WHEN Alert.AlertTypeId IN (6,7) THEN CONVERT(VARCHAR(10), CAST(AlertAt AS DATE), 101) ELSE AlertAt END AS AlertAt, AlertType, Asset.SerialNumber, ISNULL(LocationAttribute.FirstRepId, 0) RepId, ClientUser.PrimaryPhone AS SalesRepPhone, ClientUser.PrimaryEmail AS SalesRepEmail, FirstName, LastName,
									PreferedNotificationTypeIds, AlertRecipientId, AlertRecipientAddress, AlertRecipientText, Alert.Tags, AlertRecipientTypeId, NotificationContactTypeId, TemplateId, AlertDefinition.AlertAgeThreshold, LastUpdatedOn, AlertRecipient.AlertAge, CASE WHEN Location.TimeZoneId IS NOT NULL AND Location.TimeZoneId > 0 THEN  Location.TimeZoneId ELSE Client.TimeZoneId END AS TimeZoneId,
									AlertDefinition.IsSummarize, Alert.ClosedOn, AssetType.IsChestCooler, AlertDefinition.SnoozeForHours, Alert.SnoozeDateTime
									FROM Alert
											LEFT OUTER JOIN Asset ON Alert.AssetId = Asset.AssetId
											LEFT OUTER JOIN AlertType ON Alert.AlertTypeId = AlertType.AlertTypeId
											LEFT OUTER JOIN AlertDefinition ON Alert.AlertDefinitionId = AlertDefinition.AlertDefinitionId
											LEFT OUTER JOIN Location ON Location.LocationId = Alert.LocationId
											LEFT OUTER JOIN LocationAttribute ON LocationAttribute.LocationId = dbo.Location.LocationId
											LEFT OUTER JOIN ClientUser ON LocationAttribute.FirstRepId = ClientUser.ClientUserId AND ClientUser.IsDeleted = 0
											LEFT OUTER JOIN AlertRecipient ON Alert.AlertDefinitionId = AlertRecipient.AlertDefinitionId AND AlertRecipient.IsDeleted= 0
											LEFT OUTER JOIN Client ON Client.ClientId = Alert.ClientId
											LEFT OUTER JOIN AssetType ON dbo.Asset.AssetTypeId = dbo.AssetType.AssetTypeId
 WHERE (NOT EXISTS(SELECT 1 FROM dbo.EmailQueue INNER JOIN dbo.EmailRecipient  ON EmailRecipient.EmailQueueId = EmailQueue.EmailQueueId WHERE AlertId = Alert.AlertId AND EmailRecipient.RecipientId = AlertRecipient.AlertRecipientId) 
					OR (Alert.SnoozeDateTime IS NOT NULL AND Alert.SnoozeDateTime <= GETUTCDATE() AND AlertDefinition.SnoozeForHours > 0 AND Alert.StatusId = @StatusId)) 
					AND Alert.AlertId > @AlertId AND Alert.AlertAt >= DATEADD(DAY, -120, GETDATE())
					AND AlertRecipient.IsDeleted = 0 AND Alert.IsActive = 1 AND Alert.IsDeleted = 0 AND AlertRecipient.IsActive = 1 AND AlertRecipient.IsDeleted = 0 AND AlertRecipient.StartDate <= Alert.CreatedOn AND Alert.CreatedOn < DATEADD(hh, 23, AlertRecipient.EndDate) AND (Alert.LocationId != 0 OR NotificationWithoutLocation = 1) AND AlertType.IsSystemAlert = 0 AND Alert.EmailQueuedOn IS NULL AND AlertDefinition.IsActive = 1
 
2026-01-03 06:39:36.2685 AlertProcessor    ProcessorAlertData: Stopped 
2026-01-03 06:44:30.9114 AlertProcessor    ProcessorAlertData: started 
2026-01-03 06:44:35.8645 AlertProcessor    ProcessorAlertData: Stopped 
2026-01-03 06:44:36.2708 DFramework.Scheduler.TaskBase    /* Time Taken: 15593.8782*/
Opportunity Out Of Stock By Outlet 
2026-01-03 06:49:30.9136 AlertProcessor    ProcessorAlertData: started 
2026-01-03 06:49:35.8199 AlertProcessor    ProcessorAlertData: Stopped 
2026-01-03 06:54:30.9159 AlertProcessor    ProcessorAlertData: started 
2026-01-03 06:54:35.9003 AlertProcessor    ProcessorAlertData: Stopped 
2026-01-03 06:59:30.9338 AlertProcessor    ProcessorAlertData: started 
2026-01-03 06:59:35.9182 AlertProcessor    ProcessorAlertData: Stopped 
2026-01-03 06:59:36.2932 DFramework.Scheduler.TaskBase    /* Time Taken: 15593.8657*/
Opportunity Out Of Stock By Outlet 
2026-01-03 07:04:30.9517 AlertProcessor    ProcessorAlertData: started 
2026-01-03 07:04:35.8736 AlertProcessor    ProcessorAlertData: Stopped 
2026-01-03 07:09:30.9696 AlertProcessor    ProcessorAlertData: started 
2026-01-03 07:09:35.9540 AlertProcessor    ProcessorAlertData: Stopped 
2026-01-03 07:14:30.9876 AlertProcessor    ProcessorAlertData: started 
2026-01-03 07:14:36.0657 AlertProcessor    ProcessorAlertData: Stopped 
2026-01-03 07:14:36.3157 DFramework.Scheduler.TaskBase    /* Time Taken: 15593.8707*/
Opportunity Out Of Stock By Outlet 
2026-01-03 07:19:31.0054 AlertProcessor    ProcessorAlertData: started 
2026-01-03 07:19:35.9430 AlertProcessor    ProcessorAlertData: Stopped 
2026-01-03 07:24:31.0233 AlertProcessor    ProcessorAlertData: started 
2026-01-03 07:24:35.9765 AlertProcessor    ProcessorAlertData: Stopped 
2026-01-03 07:29:31.0412 AlertProcessor    ProcessorAlertData: started 
2026-01-03 07:29:36.0569 AlertProcessor    ProcessorAlertData: Stopped 
2026-01-03 07:29:36.3538 DFramework.Scheduler.TaskBase    /* Time Taken: 15625.1161*/
Opportunity Out Of Stock By Outlet 
2026-01-03 07:34:23.2934 MoveToReorder    Running task for ClientId : 286 and ClientName = India Office QA and Slot: 1/3/2026 9:00:00 PM And LastExecutedOn: 1/3/2026 8:04:23 PM 
2026-01-03 07:34:23.8559 MoveToReorder    Task executed successfully for ClientId : 286 Client Name:India Office QA, Slot: 1/3/2026 9:00:00 PM But No Order found to suggest 
2026-01-03 07:34:31.0591 AlertProcessor    ProcessorAlertData: started 
2026-01-03 07:34:35.9966 AlertProcessor    ProcessorAlertData: Stopped 
2026-01-03 07:39:31.0770 AlertProcessor    ProcessorAlertData: started 
2026-01-03 07:39:36.0614 AlertProcessor    ProcessorAlertData: Stopped 
2026-01-03 07:44:31.0949 AlertProcessor    ProcessorAlertData: started 
2026-01-03 07:44:36.0480 AlertProcessor    ProcessorAlertData: Stopped 
2026-01-03 07:44:36.3918 DFramework.Scheduler.TaskBase    /* Time Taken: 15656.3731*/
Opportunity Out Of Stock By Outlet 
2026-01-03 07:49:31.1128 AlertProcessor    ProcessorAlertData: started 
2026-01-03 07:49:36.1284 AlertProcessor    ProcessorAlertData: Stopped 
2026-01-03 07:54:31.1307 AlertProcessor    ProcessorAlertData: started 
2026-01-03 07:54:36.0838 AlertProcessor    ProcessorAlertData: Stopped 
2026-01-03 07:59:31.1329 AlertProcessor    ProcessorAlertData: started 
2026-01-03 07:59:36.0548 AlertProcessor    ProcessorAlertData: Stopped 
2026-01-03 07:59:36.3048 DFramework.Scheduler.TaskBase    /* Time Taken: 15562.6157*/
Opportunity Out Of Stock By Outlet 
2026-01-03 08:04:31.1352 AlertProcessor    ProcessorAlertData: started 
2026-01-03 08:04:36.0415 AlertProcessor    ProcessorAlertData: Stopped 
2026-01-03 08:09:31.1531 AlertProcessor    ProcessorAlertData: started 
2026-01-03 08:09:36.1063 AlertProcessor    ProcessorAlertData: Stopped 
2026-01-03 08:14:31.1710 AlertProcessor    ProcessorAlertData: started 
2026-01-03 08:14:36.1554 AlertProcessor    ProcessorAlertData: Stopped 
2026-01-03 08:14:36.3429 DFramework.Scheduler.TaskBase    /* Time Taken: 15578.2327*/
Opportunity Out Of Stock By Outlet 
2026-01-03 08:19:31.1889 AlertProcessor    ProcessorAlertData: started 
2026-01-03 08:19:36.2358 AlertProcessor    ProcessorAlertData: Stopped 
2026-01-03 08:24:31.2068 AlertProcessor    ProcessorAlertData: started 
2026-01-03 08:24:36.2693 AlertProcessor    ProcessorAlertData: Stopped 
2026-01-03 08:29:31.2090 AlertProcessor    ProcessorAlertData: started 
2026-01-03 08:29:36.3653 DFramework.Scheduler.TaskBase    /* Time Taken: 15578.2433*/
Opportunity Out Of Stock By Outlet 
2026-01-03 08:29:36.4434 AlertProcessor    ProcessorAlertData: Stopped 
2026-01-03 08:34:23.3987 MoveToReorder    Running task for ClientId : 286 and ClientName = India Office QA and Slot: 1/3/2026 10:00:00 PM And LastExecutedOn: 1/3/2026 9:04:23 PM 
2026-01-03 08:34:23.6487 MoveToReorder    Task executed successfully for ClientId : 286 Client Name:India Office QA, Slot: 1/3/2026 10:00:00 PM But No Order found to suggest 
2026-01-03 08:34:31.2269 AlertProcessor    ProcessorAlertData: started 
2026-01-03 08:34:36.5238 AlertProcessor    ProcessorAlertData: Stopped 
2026-01-03 08:39:31.2449 AlertProcessor    ProcessorAlertData: started 
2026-01-03 08:39:36.6824 AlertProcessor    ProcessorAlertData: Stopped 
2026-01-03 08:44:21.3408 DFramework.Database.Query    /* Time Taken: 540*/
[dbo].GenerateSystemAlerts 
2026-01-03 08:44:31.2628 AlertProcessor    ProcessorAlertData: started 
2026-01-03 08:44:36.4815 DFramework.Scheduler.TaskBase    /* Time Taken: 15671.9928*/
Opportunity Out Of Stock By Outlet 
2026-01-03 08:44:36.7472 AlertProcessor    ProcessorAlertData: Stopped 
2026-01-03 08:49:31.2650 AlertProcessor    ProcessorAlertData: started 
2026-01-03 08:49:36.7026 AlertProcessor    ProcessorAlertData: Stopped 
2026-01-03 08:54:31.2829 AlertProcessor    ProcessorAlertData: started 
2026-01-03 08:54:36.7986 AlertProcessor    ProcessorAlertData: Stopped 
2026-01-03 08:59:21.3476 DFramework.Database.Query    /* Time Taken: 530*/
[dbo].GenerateSystemAlerts 
2026-01-03 08:59:31.2852 AlertProcessor    ProcessorAlertData: started 
2026-01-03 08:59:36.4727 DFramework.Scheduler.TaskBase    /* Time Taken: 15640.7517*/
Opportunity Out Of Stock By Outlet 
2026-01-03 08:59:36.7227 AlertProcessor    ProcessorAlertData: Stopped 
2026-01-03 09:04:31.3031 AlertProcessor    ProcessorAlertData: started 
2026-01-03 09:04:36.8500 AlertProcessor    ProcessorAlertData: Stopped 
2026-01-03 09:09:31.3209 AlertProcessor    ProcessorAlertData: started 
2026-01-03 09:09:34.3210 DFramework.Database.Query    /* Time Taken: 546*/
DECLARE @TableName AnsiString(8000)
SET @TableName = 'AssetStockProductWiseConsolidate'
DECLARE @CurrentRecordId Int32
SET @CurrentRecordId = '3675525'
dbo.GetValidDeviceForAlertProcessData 
2026-01-03 09:09:36.8210 AlertProcessor    ProcessorAlertData: Stopped 
2026-01-03 09:14:21.3856 DFramework.Database.Query    /* Time Taken: 540*/
[dbo].GenerateSystemAlerts 
2026-01-03 09:14:31.3232 AlertProcessor    ProcessorAlertData: started 
2026-01-03 09:14:36.5264 DFramework.Scheduler.TaskBase    /* Time Taken: 15671.9885*/
Opportunity Out Of Stock By Outlet 
2026-01-03 09:14:36.8389 AlertProcessor    ProcessorAlertData: Stopped 
2026-01-03 09:19:31.3255 AlertProcessor    ProcessorAlertData: started 
2026-01-03 09:19:36.7318 AlertProcessor    ProcessorAlertData: Stopped 
2026-01-03 09:24:31.3433 AlertProcessor    ProcessorAlertData: started 
2026-01-03 09:24:36.7653 AlertProcessor    ProcessorAlertData: Stopped 
2026-01-03 09:29:31.3613 AlertProcessor    ProcessorAlertData: started 
2026-01-03 09:29:36.4238 DFramework.Scheduler.TaskBase    /* Time Taken: 15562.6173*/
Opportunity Out Of Stock By Outlet 
2026-01-03 09:29:36.7832 AlertProcessor    ProcessorAlertData: Stopped 
2026-01-03 09:34:31.3792 AlertProcessor    ProcessorAlertData: started 
2026-01-03 09:34:36.8011 AlertProcessor    ProcessorAlertData: Stopped 
2026-01-03 09:39:31.3971 AlertProcessor    ProcessorAlertData: started 
2026-01-03 09:39:36.7877 AlertProcessor    ProcessorAlertData: Stopped 
2026-01-03 09:44:21.3992 DFramework.Database.Query    /* Time Taken: 524*/
[dbo].GenerateSystemAlerts 
2026-01-03 09:44:31.4149 AlertProcessor    ProcessorAlertData: started 
2026-01-03 09:44:34.0712 DFramework.Database.NullableDataReader    Data reader open for 279
   at System.Environment.GetStackTrace(Exception e, Boolean needFileInfo)
   at System.Environment.get_StackTrace()
   at DFramework.Database.NullableDataReader.Dispose(Boolean disposing) in D:\Spraxa\Framework\DFramework\Database\NullableDataReader.cs:line 33
   at DFramework.Database.NullableDataReader.Dispose() in D:\Spraxa\Framework\DFramework\Database\NullableDataReader.cs:line 44
   at CoolR.Tasks.ProcessAlertData.Execute() in D:\Spraxa\CoolR-Group\portal\CoolR.Tasks\ProcessAlertData.cs:line 47
   at DFramework.Scheduler.TaskBase.Run() in D:\Spraxa\Framework\DFramework.Scheduler\TaskBase.cs:line 176
   at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)
   at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)
   at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state)
   at System.Threading.ThreadHelper.ThreadStart() 
2026-01-03 09:44:36.4931 DFramework.Scheduler.TaskBase    /* Time Taken: 15609.4986*/
Opportunity Out Of Stock By Outlet 
2026-01-03 09:44:37.0244 AlertProcessor    ProcessorAlertData: Stopped 
2026-01-03 09:49:31.4172 AlertProcessor    ProcessorAlertData: started 
2026-01-03 09:49:36.8860 AlertProcessor    ProcessorAlertData: Stopped 
2026-01-03 09:54:31.4351 AlertProcessor    ProcessorAlertData: started 
2026-01-03 09:54:36.9352 AlertProcessor    ProcessorAlertData: Stopped 
2026-01-03 09:59:21.4686 DFramework.Database.Query    /* Time Taken: 576*/
[dbo].GenerateSystemAlerts 
2026-01-03 09:59:31.4530 AlertProcessor    ProcessorAlertData: started 
2026-01-03 09:59:36.4999 DFramework.Scheduler.TaskBase    /* Time Taken: 15593.8706*/
Opportunity Out Of Stock By Outlet 
2026-01-03 09:59:36.9062 AlertProcessor    ProcessorAlertData: Stopped 
2026-01-03 10:03:57.7207 DFramework.Database.Query    /* Time Taken: 858*/
DECLARE @IsFileProcessed Int32
SET @IsFileProcessed = '0'
DECLARE @TaskNumber Int32
SET @TaskNumber = '3'
DECLARE @IsDeleted Int32
SET @IsDeleted = '0'
SELECT TOP 1000 IncomingFileId, GatewayId,GatewayMac,RawFileName,AzureContainerName,StartIndex,Tries, CreatedOn FROM IncomingFile
 WHERE [IsFileProcessed] = @IsFileProcessed AND [TaskNumber] = @TaskNumber AND [IsDeleted] = @IsDeleted
 
2026-01-03 10:03:57.8926 DFramework.Database.Query    /* Time Taken: 1043*/
DECLARE @IsFileProcessed Int32
SET @IsFileProcessed = '0'
DECLARE @TaskNumber Int32
SET @TaskNumber = '1'
DECLARE @IsDeleted Int32
SET @IsDeleted = '0'
SELECT TOP 1000 IncomingFileId, GatewayId,GatewayMac,RawFileName,AzureContainerName,StartIndex,Tries, CreatedOn FROM IncomingFile
 WHERE [IsFileProcessed] = @IsFileProcessed AND [TaskNumber] = @TaskNumber AND [IsDeleted] = @IsDeleted
 
2026-01-03 10:04:04.2833 DFramework.Database.Query    /* Time Taken: 2413*/
DECLARE @IsFileProcessed Int32
SET @IsFileProcessed = '0'
DECLARE @TaskNumber Int32
SET @TaskNumber = '1'
DECLARE @IsDeleted Int32
SET @IsDeleted = '0'
SELECT TOP 1000 IncomingFileId, GatewayId,GatewayMac,RawFileName,AzureContainerName,StartIndex,Tries, CreatedOn FROM IncomingFile
 WHERE [IsFileProcessed] = @IsFileProcessed AND [TaskNumber] = @TaskNumber AND [IsDeleted] = @IsDeleted
 
2026-01-03 10:04:05.1114 DFramework.Database.Query    /* Time Taken: 3241*/
DECLARE @IsFileProcessed Int32
SET @IsFileProcessed = '0'
DECLARE @TaskNumber Int32
SET @TaskNumber = '3'
DECLARE @IsDeleted Int32
SET @IsDeleted = '0'
SELECT TOP 1000 IncomingFileId, GatewayId,GatewayMac,RawFileName,AzureContainerName,StartIndex,Tries, CreatedOn FROM IncomingFile
 WHERE [IsFileProcessed] = @IsFileProcessed AND [TaskNumber] = @TaskNumber AND [IsDeleted] = @IsDeleted
 
2026-01-03 10:04:07.7208 DFramework.Database.Query    /* Time Taken: 852*/
DECLARE @IsFileProcessed Int32
SET @IsFileProcessed = '0'
DECLARE @TaskNumber Int32
SET @TaskNumber = '1'
DECLARE @IsDeleted Int32
SET @IsDeleted = '0'
SELECT TOP 1000 IncomingFileId, GatewayId,GatewayMac,RawFileName,AzureContainerName,StartIndex,Tries, CreatedOn FROM IncomingFile
 WHERE [IsFileProcessed] = @IsFileProcessed AND [TaskNumber] = @TaskNumber AND [IsDeleted] = @IsDeleted
 
2026-01-03 10:04:10.3146 DFramework.Database.Query    /* Time Taken: 3448*/
DECLARE @IsFileProcessed Int32
SET @IsFileProcessed = '0'
DECLARE @TaskNumber Int32
SET @TaskNumber = '3'
DECLARE @IsDeleted Int32
SET @IsDeleted = '0'
SELECT TOP 1000 IncomingFileId, GatewayId,GatewayMac,RawFileName,AzureContainerName,StartIndex,Tries, CreatedOn FROM IncomingFile
 WHERE [IsFileProcessed] = @IsFileProcessed AND [TaskNumber] = @TaskNumber AND [IsDeleted] = @IsDeleted
 
2026-01-03 10:04:10.3146 DFramework.Database.Query    /* Time Taken: 3449*/
DECLARE @IsFileProcessed Int32
SET @IsFileProcessed = '0'
DECLARE @TaskNumber Int32
SET @TaskNumber = '4'
DECLARE @IsDeleted Int32
SET @IsDeleted = '0'
SELECT TOP 1000 IncomingFileId, GatewayId,GatewayMac,RawFileName,AzureContainerName,StartIndex,Tries, CreatedOn FROM IncomingFile
 WHERE [IsFileProcessed] = @IsFileProcessed AND [TaskNumber] = @TaskNumber AND [IsDeleted] = @IsDeleted
 
2026-01-03 10:04:15.5178 DFramework.Database.Query    /* Time Taken: 18663*/
DECLARE @IsFileProcessed Int32
SET @IsFileProcessed = '0'
DECLARE @TaskNumber Int32
SET @TaskNumber = '2'
DECLARE @IsDeleted Int32
SET @IsDeleted = '0'
SELECT TOP 1000 IncomingFileId, GatewayId,GatewayMac,RawFileName,AzureContainerName,StartIndex,Tries, CreatedOn FROM IncomingFile
 WHERE [IsFileProcessed] = @IsFileProcessed AND [TaskNumber] = @TaskNumber AND [IsDeleted] = @IsDeleted
 
2026-01-03 10:04:15.5178 DFramework.Scheduler.TaskBase    /* Time Taken: 18656.3949*/
ProcessSQLUnprocessedFiles 
2026-01-03 10:04:15.5178 DFramework.Database.Query    /* Time Taken: 18663*/
DECLARE @IsFileProcessed Int32
SET @IsFileProcessed = '0'
DECLARE @TaskNumber Int32
SET @TaskNumber = '0'
DECLARE @IsDeleted Int32
SET @IsDeleted = '0'
SELECT TOP 1000 IncomingFileId, GatewayId,GatewayMac,RawFileName,AzureContainerName,StartIndex,Tries, CreatedOn FROM IncomingFile
 WHERE [IsFileProcessed] = @IsFileProcessed AND [TaskNumber] = @TaskNumber AND [IsDeleted] = @IsDeleted
 
2026-01-03 10:04:15.5178 DFramework.Scheduler.TaskBase    /* Time Taken: 18656.3949*/
ProcessSQLUnprocessedFiles 
2026-01-03 10:04:31.4710 AlertProcessor    ProcessorAlertData: started 
2026-01-03 10:04:36.8773 AlertProcessor    ProcessorAlertData: Stopped 
2026-01-03 10:06:03.6905 DFramework.Database.Query    /* Time Taken: 1495*/
DECLARE @IsFileProcessed Int32
SET @IsFileProcessed = '0'
DECLARE @TaskNumber Int32
SET @TaskNumber = '3'
DECLARE @IsDeleted Int32
SET @IsDeleted = '0'
SELECT TOP 1000 IncomingFileId, GatewayId,GatewayMac,RawFileName,AzureContainerName,StartIndex,Tries, CreatedOn FROM IncomingFile
 WHERE [IsFileProcessed] = @IsFileProcessed AND [TaskNumber] = @TaskNumber AND [IsDeleted] = @IsDeleted
 
2026-01-03 10:06:08.1905 DFramework.Database.Query    /* Time Taken: 970*/
DECLARE @IsFileProcessed Int32
SET @IsFileProcessed = '0'
DECLARE @TaskNumber Int32
SET @TaskNumber = '4'
DECLARE @IsDeleted Int32
SET @IsDeleted = '0'
SELECT TOP 1000 IncomingFileId, GatewayId,GatewayMac,RawFileName,AzureContainerName,StartIndex,Tries, CreatedOn FROM IncomingFile
 WHERE [IsFileProcessed] = @IsFileProcessed AND [TaskNumber] = @TaskNumber AND [IsDeleted] = @IsDeleted
 
2026-01-03 10:09:31.4733 AlertProcessor    ProcessorAlertData: started 
2026-01-03 10:09:36.9108 AlertProcessor    ProcessorAlertData: Stopped 
2026-01-03 10:14:21.4442 DFramework.Database.Query    /* Time Taken: 530*/
[dbo].GenerateSystemAlerts 
2026-01-03 10:14:31.4912 AlertProcessor    ProcessorAlertData: started 
2026-01-03 10:14:36.5537 DFramework.Scheduler.TaskBase    /* Time Taken: 15625.1199*/
Opportunity Out Of Stock By Outlet 
2026-01-03 10:14:37.0225 AlertProcessor    ProcessorAlertData: Stopped 
2026-01-03 10:19:31.5091 AlertProcessor    ProcessorAlertData: started 
2026-01-03 10:19:34.6810 DFramework.Database.NullableDataReader    Data reader open for 273
   at System.Environment.GetStackTrace(Exception e, Boolean needFileInfo)
   at System.Environment.get_StackTrace()
   at DFramework.Database.NullableDataReader.Dispose(Boolean disposing) in D:\Spraxa\Framework\DFramework\Database\NullableDataReader.cs:line 33
   at DFramework.Database.NullableDataReader.Dispose() in D:\Spraxa\Framework\DFramework\Database\NullableDataReader.cs:line 44
   at CoolR.Tasks.ProcessAlertData.Execute() in D:\Spraxa\CoolR-Group\portal\CoolR.Tasks\ProcessAlertData.cs:line 47
   at DFramework.Scheduler.TaskBase.Run() in D:\Spraxa\Framework\DFramework.Scheduler\TaskBase.cs:line 176
   at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)
   at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)
   at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state)
   at System.Threading.ThreadHelper.ThreadStart() 
2026-01-03 10:19:37.1341 AlertProcessor    ProcessorAlertData: Stopped 
2026-01-03 10:24:31.5113 AlertProcessor    ProcessorAlertData: started 
2026-01-03 10:24:36.9644 AlertProcessor    ProcessorAlertData: Stopped 
2026-01-03 10:29:21.5291 DFramework.Database.Query    /* Time Taken: 592*/
[dbo].GenerateSystemAlerts 
2026-01-03 10:29:31.5292 AlertProcessor    ProcessorAlertData: started 
2026-01-03 10:29:36.8261 DFramework.Scheduler.TaskBase    /* Time Taken: 15875.1191*/
Opportunity Out Of Stock By Outlet 
2026-01-03 10:29:37.0136 AlertProcessor    ProcessorAlertData: Stopped 
2026-01-03 10:34:31.5470 AlertProcessor    ProcessorAlertData: started 
2026-01-03 10:34:36.9689 AlertProcessor    ProcessorAlertData: Stopped 
2026-01-03 10:39:31.5650 AlertProcessor    ProcessorAlertData: started 
2026-01-03 10:39:37.0807 AlertProcessor    ProcessorAlertData: Stopped 
2026-01-03 10:44:21.5048 DFramework.Database.Query    /* Time Taken: 532*/
[dbo].GenerateSystemAlerts 
2026-01-03 10:44:31.5830 AlertProcessor    ProcessorAlertData: started 
2026-01-03 10:44:36.5830 DFramework.Scheduler.TaskBase    /* Time Taken: 15609.4948*/
Opportunity Out Of Stock By Outlet 
2026-01-03 10:44:37.0049 AlertProcessor    ProcessorAlertData: Stopped 
2026-01-03 10:49:31.6009 AlertProcessor    ProcessorAlertData: started 
2026-01-03 10:49:34.5384 DFramework.Database.Query    /* Time Taken: 509*/
DECLARE @TableName AnsiString(8000)
SET @TableName = 'AssetStockProductWiseConsolidate'
DECLARE @CurrentRecordId Int32
SET @CurrentRecordId = '3675525'
dbo.GetValidDeviceForAlertProcessData 
2026-01-03 10:49:37.0853 AlertProcessor    ProcessorAlertData: Stopped 
2026-01-03 10:51:45.6331 DFramework.Database.Query    /* Time Taken: 1217*/
DECLARE @IsFileProcessed Int32
SET @IsFileProcessed = '0'
DECLARE @TaskNumber Int32
SET @TaskNumber = '4'
DECLARE @IsDeleted Int32
SET @IsDeleted = '0'
SELECT TOP 1000 IncomingFileId, GatewayId,GatewayMac,RawFileName,AzureContainerName,StartIndex,Tries, CreatedOn FROM IncomingFile
 WHERE [IsFileProcessed] = @IsFileProcessed AND [TaskNumber] = @TaskNumber AND [IsDeleted] = @IsDeleted
 
2026-01-03 10:51:49.2113 DFramework.Database.Query    /* Time Taken: 4789*/
DECLARE @IsFileProcessed Int32
SET @IsFileProcessed = '0'
DECLARE @TaskNumber Int32
SET @TaskNumber = '0'
DECLARE @IsDeleted Int32
SET @IsDeleted = '0'
SELECT TOP 1000 IncomingFileId, GatewayId,GatewayMac,RawFileName,AzureContainerName,StartIndex,Tries, CreatedOn FROM IncomingFile
 WHERE [IsFileProcessed] = @IsFileProcessed AND [TaskNumber] = @TaskNumber AND [IsDeleted] = @IsDeleted
 
2026-01-03 10:54:31.6188 AlertProcessor    ProcessorAlertData: started 
2026-01-03 10:54:36.9938 AlertProcessor    ProcessorAlertData: Stopped 
2026-01-03 10:59:21.5272 DFramework.Database.Query    /* Time Taken: 531*/
[dbo].GenerateSystemAlerts 
2026-01-03 10:59:31.6367 AlertProcessor    ProcessorAlertData: started 
2026-01-03 10:59:36.6211 DFramework.Scheduler.TaskBase    /* Time Taken: 15625.12*/
Opportunity Out Of Stock By Outlet 
2026-01-03 10:59:36.9961 DFramework.Database.Query    /* Time Taken: 544*/
DECLARE @TableName AnsiString(8000)
SET @TableName = 'ProductStockLevel'
DECLARE @CurrentRecordId Int32
SET @CurrentRecordId = '3675525'
dbo.GetValidDeviceForAlertProcessData 
2026-01-03 10:59:37.0430 AlertProcessor    ProcessorAlertData: Stopped 
2026-01-03 11:04:31.6546 AlertProcessor    ProcessorAlertData: started 
2026-01-03 11:04:37.0765 AlertProcessor    ProcessorAlertData: Stopped 
2026-01-03 11:05:17.6237 DFramework.Database.Query    /* Time Taken: 891*/
DECLARE @IsFileProcessed Int32
SET @IsFileProcessed = '0'
DECLARE @TaskNumber Int32
SET @TaskNumber = '4'
DECLARE @IsDeleted Int32
SET @IsDeleted = '0'
SELECT TOP 1000 IncomingFileId, GatewayId,GatewayMac,RawFileName,AzureContainerName,StartIndex,Tries, CreatedOn FROM IncomingFile
 WHERE [IsFileProcessed] = @IsFileProcessed AND [TaskNumber] = @TaskNumber AND [IsDeleted] = @IsDeleted
 
2026-01-03 11:05:17.6237 DFramework.Database.Query    /* Time Taken: 903*/
DECLARE @IsFileProcessed Int32
SET @IsFileProcessed = '0'
DECLARE @TaskNumber Int32
SET @TaskNumber = '3'
DECLARE @IsDeleted Int32
SET @IsDeleted = '0'
SELECT TOP 1000 IncomingFileId, GatewayId,GatewayMac,RawFileName,AzureContainerName,StartIndex,Tries, CreatedOn FROM IncomingFile
 WHERE [IsFileProcessed] = @IsFileProcessed AND [TaskNumber] = @TaskNumber AND [IsDeleted] = @IsDeleted
 
2026-01-03 11:05:22.5768 DFramework.Database.Query    /* Time Taken: 829*/
DECLARE @IsFileProcessed Int32
SET @IsFileProcessed = '0'
DECLARE @TaskNumber Int32
SET @TaskNumber = '4'
DECLARE @IsDeleted Int32
SET @IsDeleted = '0'
SELECT TOP 1000 IncomingFileId, GatewayId,GatewayMac,RawFileName,AzureContainerName,StartIndex,Tries, CreatedOn FROM IncomingFile
 WHERE [IsFileProcessed] = @IsFileProcessed AND [TaskNumber] = @TaskNumber AND [IsDeleted] = @IsDeleted
 
2026-01-03 11:05:27.6706 DFramework.Database.Query    /* Time Taken: 909*/
DECLARE @IsFileProcessed Int32
SET @IsFileProcessed = '0'
DECLARE @TaskNumber Int32
SET @TaskNumber = '4'
DECLARE @IsDeleted Int32
SET @IsDeleted = '0'
SELECT TOP 1000 IncomingFileId, GatewayId,GatewayMac,RawFileName,AzureContainerName,StartIndex,Tries, CreatedOn FROM IncomingFile
 WHERE [IsFileProcessed] = @IsFileProcessed AND [TaskNumber] = @TaskNumber AND [IsDeleted] = @IsDeleted
 
2026-01-03 11:05:32.6394 DFramework.Database.Query    /* Time Taken: 873*/
DECLARE @IsFileProcessed Int32
SET @IsFileProcessed = '0'
DECLARE @TaskNumber Int32
SET @TaskNumber = '4'
DECLARE @IsDeleted Int32
SET @IsDeleted = '0'
SELECT TOP 1000 IncomingFileId, GatewayId,GatewayMac,RawFileName,AzureContainerName,StartIndex,Tries, CreatedOn FROM IncomingFile
 WHERE [IsFileProcessed] = @IsFileProcessed AND [TaskNumber] = @TaskNumber AND [IsDeleted] = @IsDeleted
 
2026-01-03 11:05:37.6240 DFramework.Database.Query    /* Time Taken: 827*/
DECLARE @IsFileProcessed Int32
SET @IsFileProcessed = '0'
DECLARE @TaskNumber Int32
SET @TaskNumber = '3'
DECLARE @IsDeleted Int32
SET @IsDeleted = '0'
SELECT TOP 1000 IncomingFileId, GatewayId,GatewayMac,RawFileName,AzureContainerName,StartIndex,Tries, CreatedOn FROM IncomingFile
 WHERE [IsFileProcessed] = @IsFileProcessed AND [TaskNumber] = @TaskNumber AND [IsDeleted] = @IsDeleted
 
2026-01-03 11:05:37.6240 DFramework.Database.Query    /* Time Taken: 839*/
DECLARE @IsFileProcessed Int32
SET @IsFileProcessed = '0'
DECLARE @TaskNumber Int32
SET @TaskNumber = '4'
DECLARE @IsDeleted Int32
SET @IsDeleted = '0'
SELECT TOP 1000 IncomingFileId, GatewayId,GatewayMac,RawFileName,AzureContainerName,StartIndex,Tries, CreatedOn FROM IncomingFile
 WHERE [IsFileProcessed] = @IsFileProcessed AND [TaskNumber] = @TaskNumber AND [IsDeleted] = @IsDeleted
 
2026-01-03 11:05:42.6082 DFramework.Database.Query    /* Time Taken: 809*/
DECLARE @IsFileProcessed Int32
SET @IsFileProcessed = '0'
DECLARE @TaskNumber Int32
SET @TaskNumber = '4'
DECLARE @IsDeleted Int32
SET @IsDeleted = '0'
SELECT TOP 1000 IncomingFileId, GatewayId,GatewayMac,RawFileName,AzureContainerName,StartIndex,Tries, CreatedOn FROM IncomingFile
 WHERE [IsFileProcessed] = @IsFileProcessed AND [TaskNumber] = @TaskNumber AND [IsDeleted] = @IsDeleted
 
2026-01-03 11:05:48.2177 DFramework.Database.Query    /* Time Taken: 1395*/
DECLARE @IsFileProcessed Int32
SET @IsFileProcessed = '0'
DECLARE @TaskNumber Int32
SET @TaskNumber = '4'
DECLARE @IsDeleted Int32
SET @IsDeleted = '0'
SELECT TOP 1000 IncomingFileId, GatewayId,GatewayMac,RawFileName,AzureContainerName,StartIndex,Tries, CreatedOn FROM IncomingFile
 WHERE [IsFileProcessed] = @IsFileProcessed AND [TaskNumber] = @TaskNumber AND [IsDeleted] = @IsDeleted
 
2026-01-03 11:05:52.6864 DFramework.Database.Query    /* Time Taken: 864*/
DECLARE @IsFileProcessed Int32
SET @IsFileProcessed = '0'
DECLARE @TaskNumber Int32
SET @TaskNumber = '0'
DECLARE @IsDeleted Int32
SET @IsDeleted = '0'
SELECT TOP 1000 IncomingFileId, GatewayId,GatewayMac,RawFileName,AzureContainerName,StartIndex,Tries, CreatedOn FROM IncomingFile
 WHERE [IsFileProcessed] = @IsFileProcessed AND [TaskNumber] = @TaskNumber AND [IsDeleted] = @IsDeleted
 
2026-01-03 11:05:57.4365 DFramework.Database.Query    /* Time Taken: 592*/
DECLARE @IsFileProcessed Int32
SET @IsFileProcessed = '0'
DECLARE @TaskNumber Int32
SET @TaskNumber = '0'
DECLARE @IsDeleted Int32
SET @IsDeleted = '0'
SELECT TOP 1000 IncomingFileId, GatewayId,GatewayMac,RawFileName,AzureContainerName,StartIndex,Tries, CreatedOn FROM IncomingFile
 WHERE [IsFileProcessed] = @IsFileProcessed AND [TaskNumber] = @TaskNumber AND [IsDeleted] = @IsDeleted
 
2026-01-03 11:05:57.6865 DFramework.Database.Query    /* Time Taken: 848*/
DECLARE @IsFileProcessed Int32
SET @IsFileProcessed = '0'
DECLARE @TaskNumber Int32
SET @TaskNumber = '4'
DECLARE @IsDeleted Int32
SET @IsDeleted = '0'
SELECT TOP 1000 IncomingFileId, GatewayId,GatewayMac,RawFileName,AzureContainerName,StartIndex,Tries, CreatedOn FROM IncomingFile
 WHERE [IsFileProcessed] = @IsFileProcessed AND [TaskNumber] = @TaskNumber AND [IsDeleted] = @IsDeleted
 
2026-01-03 11:06:02.6865 DFramework.Database.Query    /* Time Taken: 835*/
DECLARE @IsFileProcessed Int32
SET @IsFileProcessed = '0'
DECLARE @TaskNumber Int32
SET @TaskNumber = '3'
DECLARE @IsDeleted Int32
SET @IsDeleted = '0'
SELECT TOP 1000 IncomingFileId, GatewayId,GatewayMac,RawFileName,AzureContainerName,StartIndex,Tries, CreatedOn FROM IncomingFile
 WHERE [IsFileProcessed] = @IsFileProcessed AND [TaskNumber] = @TaskNumber AND [IsDeleted] = @IsDeleted
 
2026-01-03 11:06:02.7021 DFramework.Database.Query    /* Time Taken: 845*/
DECLARE @IsFileProcessed Int32
SET @IsFileProcessed = '0'
DECLARE @TaskNumber Int32
SET @TaskNumber = '4'
DECLARE @IsDeleted Int32
SET @IsDeleted = '0'
SELECT TOP 1000 IncomingFileId, GatewayId,GatewayMac,RawFileName,AzureContainerName,StartIndex,Tries, CreatedOn FROM IncomingFile
 WHERE [IsFileProcessed] = @IsFileProcessed AND [TaskNumber] = @TaskNumber AND [IsDeleted] = @IsDeleted
 
2026-01-03 11:06:07.7022 DFramework.Database.Query    /* Time Taken: 835*/
DECLARE @IsFileProcessed Int32
SET @IsFileProcessed = '0'
DECLARE @TaskNumber Int32
SET @TaskNumber = '3'
DECLARE @IsDeleted Int32
SET @IsDeleted = '0'
SELECT TOP 1000 IncomingFileId, GatewayId,GatewayMac,RawFileName,AzureContainerName,StartIndex,Tries, CreatedOn FROM IncomingFile
 WHERE [IsFileProcessed] = @IsFileProcessed AND [TaskNumber] = @TaskNumber AND [IsDeleted] = @IsDeleted
 
2026-01-03 11:06:15.0304 DFramework.Database.Query    /* Time Taken: 3145*/
DECLARE @IsFileProcessed Int32
SET @IsFileProcessed = '0'
DECLARE @TaskNumber Int32
SET @TaskNumber = '0'
DECLARE @IsDeleted Int32
SET @IsDeleted = '0'
SELECT TOP 1000 IncomingFileId, GatewayId,GatewayMac,RawFileName,AzureContainerName,StartIndex,Tries, CreatedOn FROM IncomingFile
 WHERE [IsFileProcessed] = @IsFileProcessed AND [TaskNumber] = @TaskNumber AND [IsDeleted] = @IsDeleted
 
2026-01-03 11:06:17.6710 DFramework.Database.Query    /* Time Taken: 770*/
DECLARE @IsFileProcessed Int32
SET @IsFileProcessed = '0'
DECLARE @TaskNumber Int32
SET @TaskNumber = '3'
DECLARE @IsDeleted Int32
SET @IsDeleted = '0'
SELECT TOP 1000 IncomingFileId, GatewayId,GatewayMac,RawFileName,AzureContainerName,StartIndex,Tries, CreatedOn FROM IncomingFile
 WHERE [IsFileProcessed] = @IsFileProcessed AND [TaskNumber] = @TaskNumber AND [IsDeleted] = @IsDeleted
 
2026-01-03 11:06:17.7647 DFramework.Database.Query    /* Time Taken: 859*/
DECLARE @IsFileProcessed Int32
SET @IsFileProcessed = '0'
DECLARE @TaskNumber Int32
SET @TaskNumber = '4'
DECLARE @IsDeleted Int32
SET @IsDeleted = '0'
SELECT TOP 1000 IncomingFileId, GatewayId,GatewayMac,RawFileName,AzureContainerName,StartIndex,Tries, CreatedOn FROM IncomingFile
 WHERE [IsFileProcessed] = @IsFileProcessed AND [TaskNumber] = @TaskNumber AND [IsDeleted] = @IsDeleted
 
2026-01-03 11:06:22.7804 DFramework.Database.Query    /* Time Taken: 871*/
DECLARE @IsFileProcessed Int32
SET @IsFileProcessed = '0'
DECLARE @TaskNumber Int32
SET @TaskNumber = '4'
DECLARE @IsDeleted Int32
SET @IsDeleted = '0'
SELECT TOP 1000 IncomingFileId, GatewayId,GatewayMac,RawFileName,AzureContainerName,StartIndex,Tries, CreatedOn FROM IncomingFile
 WHERE [IsFileProcessed] = @IsFileProcessed AND [TaskNumber] = @TaskNumber AND [IsDeleted] = @IsDeleted
 
2026-01-03 11:06:22.8117 DFramework.Database.Query    /* Time Taken: 890*/
DECLARE @IsFileProcessed Int32
SET @IsFileProcessed = '0'
DECLARE @TaskNumber Int32
SET @TaskNumber = '3'
DECLARE @IsDeleted Int32
SET @IsDeleted = '0'
SELECT TOP 1000 IncomingFileId, GatewayId,GatewayMac,RawFileName,AzureContainerName,StartIndex,Tries, CreatedOn FROM IncomingFile
 WHERE [IsFileProcessed] = @IsFileProcessed AND [TaskNumber] = @TaskNumber AND [IsDeleted] = @IsDeleted
 
2026-01-03 11:06:27.7648 DFramework.Database.Query    /* Time Taken: 842*/
DECLARE @IsFileProcessed Int32
SET @IsFileProcessed = '0'
DECLARE @TaskNumber Int32
SET @TaskNumber = '3'
DECLARE @IsDeleted Int32
SET @IsDeleted = '0'
SELECT TOP 1000 IncomingFileId, GatewayId,GatewayMac,RawFileName,AzureContainerName,StartIndex,Tries, CreatedOn FROM IncomingFile
 WHERE [IsFileProcessed] = @IsFileProcessed AND [TaskNumber] = @TaskNumber AND [IsDeleted] = @IsDeleted
 
2026-01-03 11:06:32.7024 DFramework.Database.Query    /* Time Taken: 752*/
DECLARE @IsFileProcessed Int32
SET @IsFileProcessed = '0'
DECLARE @TaskNumber Int32
SET @TaskNumber = '4'
DECLARE @IsDeleted Int32
SET @IsDeleted = '0'
SELECT TOP 1000 IncomingFileId, GatewayId,GatewayMac,RawFileName,AzureContainerName,StartIndex,Tries, CreatedOn FROM IncomingFile
 WHERE [IsFileProcessed] = @IsFileProcessed AND [TaskNumber] = @TaskNumber AND [IsDeleted] = @IsDeleted
 
2026-01-03 11:09:31.6568 AlertProcessor    ProcessorAlertData: started 
2026-01-03 11:09:37.0006 AlertProcessor    ProcessorAlertData: Stopped 
2026-01-03 11:14:31.6591 AlertProcessor    ProcessorAlertData: started 
2026-01-03 11:14:36.5810 DFramework.Scheduler.TaskBase    /* Time Taken: 15562.6192*/
Opportunity Out Of Stock By Outlet 
2026-01-03 11:14:37.0966 AlertProcessor    ProcessorAlertData: Stopped 
2026-01-03 11:19:31.6614 AlertProcessor    ProcessorAlertData: started 
2026-01-03 11:19:34.5833 DFramework.Database.Query    /* Time Taken: 514*/
DECLARE @TableName AnsiString(8000)
SET @TableName = 'AssetStockProductWiseConsolidate'
DECLARE @CurrentRecordId Int32
SET @CurrentRecordId = '3675525'
dbo.GetValidDeviceForAlertProcessData 
2026-01-03 11:19:37.1145 AlertProcessor    ProcessorAlertData: Stopped 
2026-01-03 11:24:31.6792 AlertProcessor    ProcessorAlertData: started 
2026-01-03 11:24:37.0386 AlertProcessor    ProcessorAlertData: Stopped 
2026-01-03 11:29:31.6971 AlertProcessor    ProcessorAlertData: started 
2026-01-03 11:29:36.6034 DFramework.Scheduler.TaskBase    /* Time Taken: 15562.6168*/
Opportunity Out Of Stock By Outlet 
2026-01-03 11:29:37.1503 AlertProcessor    ProcessorAlertData: Stopped 
2026-01-03 11:34:31.7150 AlertProcessor    ProcessorAlertData: started 
2026-01-03 11:34:36.9963 AlertProcessor    ProcessorAlertData: Stopped 
2026-01-03 11:39:31.7329 AlertProcessor    ProcessorAlertData: started 
2026-01-03 11:39:37.1705 AlertProcessor    ProcessorAlertData: Stopped 
2026-01-03 11:44:31.7508 AlertProcessor    ProcessorAlertData: started 
2026-01-03 11:44:36.6102 DFramework.Scheduler.TaskBase    /* Time Taken: 15562.6133*/
Opportunity Out Of Stock By Outlet 
2026-01-03 11:44:37.1415 AlertProcessor    ProcessorAlertData: Stopped 
2026-01-03 11:49:31.7687 AlertProcessor    ProcessorAlertData: started 
2026-01-03 11:49:37.1750 AlertProcessor    ProcessorAlertData: Stopped 
2026-01-03 11:54:31.7866 AlertProcessor    ProcessorAlertData: started 
2026-01-03 11:54:37.1304 AlertProcessor    ProcessorAlertData: Stopped 
2026-01-03 11:59:31.8045 AlertProcessor    ProcessorAlertData: started 
2026-01-03 11:59:36.6326 DFramework.Scheduler.TaskBase    /* Time Taken: 15562.619*/
Opportunity Out Of Stock By Outlet 
2026-01-03 11:59:37.2733 AlertProcessor    ProcessorAlertData: Stopped 
2026-01-03 12:04:31.8223 AlertProcessor    ProcessorAlertData: started 
2026-01-03 12:04:37.2130 AlertProcessor    ProcessorAlertData: Stopped 
2026-01-03 12:09:31.8402 AlertProcessor    ProcessorAlertData: started 
2026-01-03 12:09:37.3246 AlertProcessor    ProcessorAlertData: Stopped 
2026-01-03 12:14:31.8581 AlertProcessor    ProcessorAlertData: started 
2026-01-03 12:14:36.6706 DFramework.Scheduler.TaskBase    /* Time Taken: 15578.2299*/
Opportunity Out Of Stock By Outlet 
2026-01-03 12:14:37.3113 AlertProcessor    ProcessorAlertData: Stopped 
2026-01-03 12:19:31.8604 AlertProcessor    ProcessorAlertData: started 
2026-01-03 12:19:37.2355 AlertProcessor    ProcessorAlertData: Stopped 
2026-01-03 12:24:31.8628 AlertProcessor    ProcessorAlertData: started 
2026-01-03 12:24:37.3785 AlertProcessor    ProcessorAlertData: Stopped 
2026-01-03 12:29:21.6463 DFramework.Database.Query    /* Time Taken: 544*/
[dbo].GenerateSystemAlerts 
2026-01-03 12:29:31.8651 AlertProcessor    ProcessorAlertData: started 
2026-01-03 12:29:36.7401 DFramework.Scheduler.TaskBase    /* Time Taken: 15625.1177*/
Opportunity Out Of Stock By Outlet 
2026-01-03 12:29:37.1620 AlertProcessor    ProcessorAlertData: Stopped 
2026-01-03 12:34:31.8674 AlertProcessor    ProcessorAlertData: started 
2026-01-03 12:34:34.8049 DFramework.Database.Query    /* Time Taken: 512*/
DECLARE @TableName AnsiString(8000)
SET @TableName = 'AssetStockProductWiseConsolidate'
DECLARE @CurrentRecordId Int32
SET @CurrentRecordId = '3675525'
dbo.GetValidDeviceForAlertProcessData 
2026-01-03 12:34:37.3830 AlertProcessor    ProcessorAlertData: Stopped 
2026-01-03 12:39:31.8853 AlertProcessor    ProcessorAlertData: started 
2026-01-03 12:39:37.3228 AlertProcessor    ProcessorAlertData: Stopped 
2026-01-03 12:44:31.9031 AlertProcessor    ProcessorAlertData: started 
2026-01-03 12:44:36.7000 DFramework.Scheduler.TaskBase    /* Time Taken: 15562.6202*/
Opportunity Out Of Stock By Outlet 
2026-01-03 12:44:37.2782 AlertProcessor    ProcessorAlertData: Stopped 
2026-01-03 12:49:31.9210 AlertProcessor    ProcessorAlertData: started 
2026-01-03 12:49:37.4679 AlertProcessor    ProcessorAlertData: Stopped 
2026-01-03 12:54:31.9389 AlertProcessor    ProcessorAlertData: started 
2026-01-03 12:54:37.2983 AlertProcessor    ProcessorAlertData: Stopped 
2026-01-03 12:59:21.6598 DFramework.Database.Query    /* Time Taken: 529*/
[dbo].GenerateSystemAlerts 
2026-01-03 12:59:31.9568 AlertProcessor    ProcessorAlertData: started 
2026-01-03 12:59:36.7537 DFramework.Scheduler.TaskBase    /* Time Taken: 15609.4948*/
Opportunity Out Of Stock By Outlet 
2026-01-03 12:59:37.4256 AlertProcessor    ProcessorAlertData: Stopped 
2026-01-03 13:04:31.9747 AlertProcessor    ProcessorAlertData: started 
2026-01-03 13:04:37.2872 AlertProcessor    ProcessorAlertData: Stopped 
2026-01-03 13:09:31.9925 AlertProcessor    ProcessorAlertData: started 
2026-01-03 13:09:37.4770 AlertProcessor    ProcessorAlertData: Stopped 
2026-01-03 13:14:21.6979 DFramework.Database.Query    /* Time Taken: 532*/
[dbo].GenerateSystemAlerts 
2026-01-03 13:14:32.0105 AlertProcessor    ProcessorAlertData: started 
2026-01-03 13:14:36.7761 DFramework.Scheduler.TaskBase    /* Time Taken: 15609.4927*/
Opportunity Out Of Stock By Outlet 
2026-01-03 13:14:37.4480 AlertProcessor    ProcessorAlertData: Stopped 
2026-01-03 13:19:32.0284 AlertProcessor    ProcessorAlertData: started 
2026-01-03 13:19:37.3878 AlertProcessor    ProcessorAlertData: Stopped 
2026-01-03 13:24:32.0462 AlertProcessor    ProcessorAlertData: started 
2026-01-03 13:24:37.4213 AlertProcessor    ProcessorAlertData: Stopped 
2026-01-03 13:29:21.7203 DFramework.Database.Query    /* Time Taken: 531*/
[dbo].GenerateSystemAlerts 
2026-01-03 13:29:32.0642 AlertProcessor    ProcessorAlertData: started 
2026-01-03 13:29:36.7986 DFramework.Scheduler.TaskBase    /* Time Taken: 15609.4947*/
Opportunity Out Of Stock By Outlet 
2026-01-03 13:29:37.4704 AlertProcessor    ProcessorAlertData: Stopped 
2026-01-03 13:34:32.0820 AlertProcessor    ProcessorAlertData: started 
2026-01-03 13:34:37.5977 AlertProcessor    ProcessorAlertData: Stopped 
2026-01-03 13:39:32.0999 AlertProcessor    ProcessorAlertData: started 
2026-01-03 13:39:37.5843 AlertProcessor    ProcessorAlertData: Stopped 
2026-01-03 13:44:21.7115 DFramework.Database.Query    /* Time Taken: 502*/
[dbo].GenerateSystemAlerts 
2026-01-03 13:44:32.1178 AlertProcessor    ProcessorAlertData: started 
2026-01-03 13:44:36.7741 DFramework.Scheduler.TaskBase    /* Time Taken: 15562.6127*/
Opportunity Out Of Stock By Outlet 
2026-01-03 13:44:37.5710 AlertProcessor    ProcessorAlertData: Stopped 
2026-01-03 13:49:32.1357 AlertProcessor    ProcessorAlertData: started 
2026-01-03 13:49:37.6827 AlertProcessor    ProcessorAlertData: Stopped 
2026-01-03 13:54:32.1536 AlertProcessor    ProcessorAlertData: started 
2026-01-03 13:54:37.6693 AlertProcessor    ProcessorAlertData: Stopped 
2026-01-03 13:59:21.7339 DFramework.Database.Query    /* Time Taken: 511*/
[dbo].GenerateSystemAlerts 
2026-01-03 13:59:32.1715 AlertProcessor    ProcessorAlertData: started 
2026-01-03 13:59:36.8122 DFramework.Scheduler.TaskBase    /* Time Taken: 15578.2406*/
Opportunity Out Of Stock By Outlet 
2026-01-03 13:59:37.7809 AlertProcessor    ProcessorAlertData: Stopped 
2026-01-03 14:04:32.1894 AlertProcessor    ProcessorAlertData: started 
2026-01-03 14:04:37.6113 AlertProcessor    ProcessorAlertData: Stopped 
2026-01-03 14:09:32.2073 AlertProcessor    ProcessorAlertData: started 
2026-01-03 14:09:37.5667 AlertProcessor    ProcessorAlertData: Stopped 
2026-01-03 14:14:32.2252 AlertProcessor    ProcessorAlertData: started 
2026-01-03 14:14:36.8034 DFramework.Scheduler.TaskBase    /* Time Taken: 15562.6229*/
Opportunity Out Of Stock By Outlet 
2026-01-03 14:14:37.6940 AlertProcessor    ProcessorAlertData: Stopped 
2026-01-03 14:19:32.2431 AlertProcessor    ProcessorAlertData: started 
2026-01-03 14:19:37.7587 AlertProcessor    ProcessorAlertData: Stopped 
2026-01-03 14:24:32.2454 AlertProcessor    ProcessorAlertData: started 
2026-01-03 14:24:37.6360 AlertProcessor    ProcessorAlertData: Stopped 
2026-01-03 14:29:32.2632 AlertProcessor    ProcessorAlertData: started 
2026-01-03 14:29:36.8258 DFramework.Scheduler.TaskBase    /* Time Taken: 15562.6147*/
Opportunity Out Of Stock By Outlet 
2026-01-03 14:29:37.7008 AlertProcessor    ProcessorAlertData: Stopped 
2026-01-03 14:34:32.2811 AlertProcessor    ProcessorAlertData: started 
2026-01-03 14:34:37.7187 AlertProcessor    ProcessorAlertData: Stopped 
2026-01-03 14:39:32.2991 AlertProcessor    ProcessorAlertData: started 
2026-01-03 14:39:37.6585 AlertProcessor    ProcessorAlertData: Stopped 
2026-01-03 14:44:21.8169 DFramework.Database.Query    /* Time Taken: 532*/
[dbo].GenerateSystemAlerts 
2026-01-03 14:44:32.3013 AlertProcessor    ProcessorAlertData: started 
2026-01-03 14:44:36.9108 DFramework.Scheduler.TaskBase    /* Time Taken: 15625.1153*/
Opportunity Out Of Stock By Outlet 
2026-01-03 14:44:37.6451 AlertProcessor    ProcessorAlertData: Stopped 
2026-01-03 14:49:32.3193 AlertProcessor    ProcessorAlertData: started 
2026-01-03 14:49:37.6474 AlertProcessor    ProcessorAlertData: Stopped 
2026-01-03 14:54:32.3401 AlertProcessor    ProcessorAlertData: started 
2026-01-03 14:54:37.7620 AlertProcessor    ProcessorAlertData: Stopped 
2026-01-03 14:59:32.3598 AlertProcessor    ProcessorAlertData: started 
2026-01-03 14:59:36.8754 DFramework.Scheduler.TaskBase    /* Time Taken: 15562.6678*/
Opportunity Out Of Stock By Outlet 
2026-01-03 14:59:37.6879 AlertProcessor    ProcessorAlertData: Stopped 
2026-01-03 15:04:32.3782 AlertProcessor    ProcessorAlertData: started 
2026-01-03 15:04:37.5814 AlertProcessor    ProcessorAlertData: Stopped 
2026-01-03 15:09:32.3950 AlertProcessor    ProcessorAlertData: started 
2026-01-03 15:09:37.7856 AlertProcessor    ProcessorAlertData: Stopped 
2026-01-03 15:14:21.8320 DFramework.Database.Query    /* Time Taken: 504*/
[dbo].GenerateSystemAlerts 
2026-01-03 15:14:32.3945 AlertProcessor    ProcessorAlertData: started 
2026-01-03 15:14:36.8945 DFramework.Scheduler.TaskBase    /* Time Taken: 15562.5457*/
Opportunity Out Of Stock By Outlet 
2026-01-03 15:14:37.8476 AlertProcessor    ProcessorAlertData: Stopped 
2026-01-03 15:19:32.4115 AlertProcessor    ProcessorAlertData: started 
2026-01-03 15:19:37.8178 AlertProcessor    ProcessorAlertData: Stopped 
2026-01-03 15:24:32.4291 AlertProcessor    ProcessorAlertData: started 
2026-01-03 15:24:34.5542 DFramework.Database.NullableDataReader    Data reader open for 279
   at System.Environment.GetStackTrace(Exception e, Boolean needFileInfo)
   at System.Environment.get_StackTrace()
   at DFramework.Database.NullableDataReader.Dispose(Boolean disposing) in D:\Spraxa\Framework\DFramework\Database\NullableDataReader.cs:line 33
   at DFramework.Database.NullableDataReader.Dispose() in D:\Spraxa\Framework\DFramework\Database\NullableDataReader.cs:line 44
   at CoolR.Tasks.ProcessAlertData.Execute() in D:\Spraxa\CoolR-Group\portal\CoolR.Tasks\ProcessAlertData.cs:line 47
   at DFramework.Scheduler.TaskBase.Run() in D:\Spraxa\Framework\DFramework.Scheduler\TaskBase.cs:line 176
   at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)
   at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)
   at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state)
   at System.Threading.ThreadHelper.ThreadStart() 
2026-01-03 15:24:38.0698 AlertProcessor    ProcessorAlertData: Stopped 
2026-01-03 15:29:32.4470 AlertProcessor    ProcessorAlertData: started 
2026-01-03 15:29:36.9158 DFramework.Scheduler.TaskBase    /* Time Taken: 15562.615*/
Opportunity Out Of Stock By Outlet 
2026-01-03 15:29:37.8689 AlertProcessor    ProcessorAlertData: Stopped 
2026-01-03 15:34:32.4493 AlertProcessor    ProcessorAlertData: started 
2026-01-03 15:34:37.9649 AlertProcessor    ProcessorAlertData: Stopped 
2026-01-03 15:39:32.4671 AlertProcessor    ProcessorAlertData: started 
2026-01-03 15:39:37.8265 AlertProcessor    ProcessorAlertData: Stopped 
2026-01-03 15:44:21.8915 DFramework.Database.Query    /* Time Taken: 517*/
[dbo].GenerateSystemAlerts 
2026-01-03 15:44:32.4853 AlertProcessor    ProcessorAlertData: started 
2026-01-03 15:44:36.9385 DFramework.Scheduler.TaskBase    /* Time Taken: 15562.6497*/
Opportunity Out Of Stock By Outlet 
2026-01-03 15:44:38.0479 DFramework.Database.Query    /* Time Taken: 507*/
DECLARE @TableName AnsiString(8000)
SET @TableName = 'ProductStockLevel'
DECLARE @CurrentRecordId Int32
SET @CurrentRecordId = '3675525'
dbo.GetValidDeviceForAlertProcessData 
2026-01-03 15:44:38.1104 AlertProcessor    ProcessorAlertData: Stopped 
2026-01-03 15:49:32.5036 AlertProcessor    ProcessorAlertData: started 
2026-01-03 15:49:37.9880 AlertProcessor    ProcessorAlertData: Stopped 
2026-01-03 15:54:32.5215 AlertProcessor    ProcessorAlertData: started 
2026-01-03 15:54:37.8810 AlertProcessor    ProcessorAlertData: Stopped 
2026-01-03 15:59:21.9143 DFramework.Database.Query    /* Time Taken: 525*/
[dbo].GenerateSystemAlerts 
2026-01-03 15:59:32.5238 AlertProcessor    ProcessorAlertData: started 
2026-01-03 15:59:35.5238 DFramework.Database.Query    /* Time Taken: 515*/
DECLARE @TableName AnsiString(8000)
SET @TableName = 'AssetStockProductWiseConsolidate'
DECLARE @CurrentRecordId Int32
SET @CurrentRecordId = '3675525'
dbo.GetValidDeviceForAlertProcessData 
2026-01-03 15:59:37.0082 DFramework.Scheduler.TaskBase    /* Time Taken: 15609.4945*/
Opportunity Out Of Stock By Outlet 
2026-01-03 15:59:38.0238 AlertProcessor    ProcessorAlertData: Stopped 
2026-01-03 16:04:32.5413 AlertProcessor    ProcessorAlertData: started 
2026-01-03 16:04:38.0413 AlertProcessor    ProcessorAlertData: Stopped 
2026-01-03 16:09:32.5590 AlertProcessor    ProcessorAlertData: started 
2026-01-03 16:09:37.9966 AlertProcessor    ProcessorAlertData: Stopped 
2026-01-03 16:14:21.9362 DFramework.Database.Query    /* Time Taken: 527*/
[dbo].GenerateSystemAlerts 
2026-01-03 16:14:32.5769 AlertProcessor    ProcessorAlertData: started 
2026-01-03 16:14:37.0457 DFramework.Scheduler.TaskBase    /* Time Taken: 15625.1144*/
Opportunity Out Of Stock By Outlet 
2026-01-03 16:14:37.9676 AlertProcessor    ProcessorAlertData: Stopped 
2026-01-03 16:19:32.5947 AlertProcessor    ProcessorAlertData: started 
2026-01-03 16:19:38.0010 AlertProcessor    ProcessorAlertData: Stopped 
2026-01-03 16:24:32.6126 AlertProcessor    ProcessorAlertData: started 
2026-01-03 16:24:38.0345 AlertProcessor    ProcessorAlertData: Stopped 
2026-01-03 16:29:32.6149 AlertProcessor    ProcessorAlertData: started 
2026-01-03 16:29:37.0055 DFramework.Scheduler.TaskBase    /* Time Taken: 15562.6142*/
Opportunity Out Of Stock By Outlet 
2026-01-03 16:29:38.0212 AlertProcessor    ProcessorAlertData: Stopped 
2026-01-03 16:34:32.6328 AlertProcessor    ProcessorAlertData: started 
2026-01-03 16:34:38.0859 AlertProcessor    ProcessorAlertData: Stopped 
2026-01-03 16:39:32.6507 AlertProcessor    ProcessorAlertData: started 
2026-01-03 16:39:38.0882 AlertProcessor    ProcessorAlertData: Stopped 
2026-01-03 16:44:21.9966 DFramework.Database.Query    /* Time Taken: 530*/
[dbo].GenerateSystemAlerts 
2026-01-03 16:44:32.6686 AlertProcessor    ProcessorAlertData: started 
2026-01-03 16:44:37.0905 DFramework.Scheduler.TaskBase    /* Time Taken: 15625.1159*/
Opportunity Out Of Stock By Outlet 
2026-01-03 16:44:38.0905 AlertProcessor    ProcessorAlertData: Stopped 
2026-01-03 16:49:32.6864 AlertProcessor    ProcessorAlertData: started 
2026-01-03 16:49:38.1709 AlertProcessor    ProcessorAlertData: Stopped 
2026-01-03 16:54:32.7043 AlertProcessor    ProcessorAlertData: started 
2026-01-03 16:54:34.0481 DFramework.Database.NullableDataReader    Data reader open for 273
   at System.Environment.GetStackTrace(Exception e, Boolean needFileInfo)
   at System.Environment.get_StackTrace()
   at DFramework.Database.NullableDataReader.Dispose(Boolean disposing) in D:\Spraxa\Framework\DFramework\Database\NullableDataReader.cs:line 33
   at DFramework.Database.NullableDataReader.Dispose() in D:\Spraxa\Framework\DFramework\Database\NullableDataReader.cs:line 44
   at CoolR.Tasks.ProcessAlertData.Execute() in D:\Spraxa\CoolR-Group\portal\CoolR.Tasks\ProcessAlertData.cs:line 47
   at DFramework.Scheduler.TaskBase.Run() in D:\Spraxa\Framework\DFramework.Scheduler\TaskBase.cs:line 176
   at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)
   at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)
   at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state)
   at System.Threading.ThreadHelper.ThreadStart() 
2026-01-03 16:54:38.2044 AlertProcessor    ProcessorAlertData: Stopped 
2026-01-03 16:59:22.0034 DFramework.Database.Query    /* Time Taken: 523*/
[dbo].GenerateSystemAlerts 
2026-01-03 16:59:32.7222 AlertProcessor    ProcessorAlertData: started 
2026-01-03 16:59:37.1128 DFramework.Scheduler.TaskBase    /* Time Taken: 15625.1142*/
Opportunity Out Of Stock By Outlet 
2026-01-03 16:59:38.1285 AlertProcessor    ProcessorAlertData: Stopped 
2026-01-03 17:04:32.7401 AlertProcessor    ProcessorAlertData: started 
2026-01-03 17:04:38.1620 AlertProcessor    ProcessorAlertData: Stopped 
2026-01-03 17:09:32.7424 AlertProcessor    ProcessorAlertData: started 
2026-01-03 17:09:38.1799 AlertProcessor    ProcessorAlertData: Stopped 
2026-01-03 17:14:22.0258 DFramework.Database.Query    /* Time Taken: 539*/
[dbo].GenerateSystemAlerts 
2026-01-03 17:14:32.7603 AlertProcessor    ProcessorAlertData: started 
2026-01-03 17:14:37.1197 DFramework.Scheduler.TaskBase    /* Time Taken: 15625.1121*/
Opportunity Out Of Stock By Outlet 
2026-01-03 17:14:38.1353 AlertProcessor    ProcessorAlertData: Stopped 
2026-01-03 17:19:32.7782 AlertProcessor    ProcessorAlertData: started 
2026-01-03 17:19:38.2626 AlertProcessor    ProcessorAlertData: Stopped 
2026-01-03 17:24:32.7961 AlertProcessor    ProcessorAlertData: started 
2026-01-03 17:24:38.2180 AlertProcessor    ProcessorAlertData: Stopped 
2026-01-03 17:29:22.0169 DFramework.Database.Query    /* Time Taken: 528*/
[dbo].GenerateSystemAlerts 
2026-01-03 17:29:32.8139 AlertProcessor    ProcessorAlertData: started 
2026-01-03 17:29:34.6733 DFramework.Database.NullableDataReader    Data reader open for 277
   at System.Environment.GetStackTrace(Exception e, Boolean needFileInfo)
   at System.Environment.get_StackTrace()
   at DFramework.Database.NullableDataReader.Dispose(Boolean disposing) in D:\Spraxa\Framework\DFramework\Database\NullableDataReader.cs:line 33
   at DFramework.Database.NullableDataReader.Dispose() in D:\Spraxa\Framework\DFramework\Database\NullableDataReader.cs:line 44
   at CoolR.Tasks.ProcessAlertData.Execute() in D:\Spraxa\CoolR-Group\portal\CoolR.Tasks\ProcessAlertData.cs:line 47
   at DFramework.Scheduler.TaskBase.Run() in D:\Spraxa\Framework\DFramework.Scheduler\TaskBase.cs:line 176
   at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)
   at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)
   at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state)
   at System.Threading.ThreadHelper.ThreadStart() 
2026-01-03 17:29:37.1108 DFramework.Scheduler.TaskBase    /* Time Taken: 15609.4905*/
Opportunity Out Of Stock By Outlet 
2026-01-03 17:29:38.5796 AlertProcessor    ProcessorAlertData: Stopped 
2026-01-03 17:34:32.8318 AlertProcessor    ProcessorAlertData: started 
2026-01-03 17:34:35.9099 DFramework.Database.Query    /* Time Taken: 609*/
DECLARE @TableName AnsiString(8000)
SET @TableName = 'AssetStockProductWiseConsolidate'
DECLARE @CurrentRecordId Int32
SET @CurrentRecordId = '3675525'
dbo.GetValidDeviceForAlertProcessData 
2026-01-03 17:34:38.4099 AlertProcessor    ProcessorAlertData: Stopped 
2026-01-03 17:39:32.8497 AlertProcessor    ProcessorAlertData: started 
2026-01-03 17:39:38.2716 AlertProcessor    ProcessorAlertData: Stopped 
2026-01-03 17:44:22.0551 DFramework.Database.Query    /* Time Taken: 543*/
[dbo].GenerateSystemAlerts 
2026-01-03 17:44:32.8677 AlertProcessor    ProcessorAlertData: started 
2026-01-03 17:44:37.1021 DFramework.Scheduler.TaskBase    /* Time Taken: 15578.251*/
Opportunity Out Of Stock By Outlet 
2026-01-03 17:44:38.2427 AlertProcessor    ProcessorAlertData: Stopped 
2026-01-03 17:49:32.8856 AlertProcessor    ProcessorAlertData: started 
2026-01-03 17:49:38.3232 AlertProcessor    ProcessorAlertData: Stopped 
2026-01-03 17:54:32.9035 AlertProcessor    ProcessorAlertData: started 
2026-01-03 17:54:38.2161 AlertProcessor    ProcessorAlertData: Stopped 
2026-01-03 17:59:22.0463 DFramework.Database.Query    /* Time Taken: 503*/
[dbo].GenerateSystemAlerts 
2026-01-03 17:59:32.9214 AlertProcessor    ProcessorAlertData: started 
2026-01-03 17:59:37.1558 DFramework.Scheduler.TaskBase    /* Time Taken: 15609.493*/
Opportunity Out Of Stock By Outlet 
2026-01-03 17:59:38.3277 AlertProcessor    ProcessorAlertData: Stopped 
2026-01-03 18:04:32.9393 AlertProcessor    ProcessorAlertData: started 
2026-01-03 18:04:38.2519 AlertProcessor    ProcessorAlertData: Stopped 
2026-01-03 18:09:32.9416 AlertProcessor    ProcessorAlertData: started 
2026-01-03 18:09:38.2229 AlertProcessor    ProcessorAlertData: Stopped 
2026-01-03 18:14:22.0844 DFramework.Database.Query    /* Time Taken: 519*/
[dbo].GenerateSystemAlerts 
2026-01-03 18:14:32.9595 AlertProcessor    ProcessorAlertData: started 
2026-01-03 18:14:37.1782 DFramework.Scheduler.TaskBase    /* Time Taken: 15609.4894*/
Opportunity Out Of Stock By Outlet 
2026-01-03 18:14:38.3345 AlertProcessor    ProcessorAlertData: Stopped 
2026-01-03 18:19:32.9774 AlertProcessor    ProcessorAlertData: started 
2026-01-03 18:19:38.3524 AlertProcessor    ProcessorAlertData: Stopped 
2026-01-03 18:24:32.9953 AlertProcessor    ProcessorAlertData: started 
2026-01-03 18:24:38.3860 AlertProcessor    ProcessorAlertData: Stopped 
2026-01-03 18:29:22.1069 DFramework.Database.Query    /* Time Taken: 527*/
[dbo].GenerateSystemAlerts 
2026-01-03 18:29:33.0132 AlertProcessor    ProcessorAlertData: started 
2026-01-03 18:29:37.2164 DFramework.Scheduler.TaskBase    /* Time Taken: 15625.1207*/
Opportunity Out Of Stock By Outlet 
2026-01-03 18:29:38.3570 AlertProcessor    ProcessorAlertData: Stopped 
2026-01-03 18:34:33.0310 AlertProcessor    ProcessorAlertData: started 
2026-01-03 18:34:38.4842 AlertProcessor    ProcessorAlertData: Stopped 
2026-01-03 18:39:33.0332 AlertProcessor    ProcessorAlertData: started 
2026-01-03 18:39:38.3927 AlertProcessor    ProcessorAlertData: Stopped 
2026-01-03 18:44:33.0511 AlertProcessor    ProcessorAlertData: started 
2026-01-03 18:44:37.1761 DFramework.Scheduler.TaskBase    /* Time Taken: 15562.6092*/
Opportunity Out Of Stock By Outlet 
2026-01-03 18:44:38.5512 AlertProcessor    ProcessorAlertData: Stopped 
2026-01-03 18:49:33.0690 AlertProcessor    ProcessorAlertData: started 
2026-01-03 18:49:38.3659 AlertProcessor    ProcessorAlertData: Stopped 
2026-01-03 18:54:33.0869 AlertProcessor    ProcessorAlertData: started 
2026-01-03 18:54:38.4619 AlertProcessor    ProcessorAlertData: Stopped 
2026-01-03 18:59:22.1516 DFramework.Database.Query    /* Time Taken: 516*/
[dbo].GenerateSystemAlerts 
2026-01-03 18:59:33.0891 AlertProcessor    ProcessorAlertData: started 
2026-01-03 18:59:37.2454 DFramework.Scheduler.TaskBase    /* Time Taken: 15609.5033*/
Opportunity Out Of Stock By Outlet 
2026-01-03 18:59:38.5111 AlertProcessor    ProcessorAlertData: Stopped 
2026-01-03 19:04:33.0914 AlertProcessor    ProcessorAlertData: started 
2026-01-03 19:04:38.4508 AlertProcessor    ProcessorAlertData: Stopped 
2026-01-03 19:09:33.0935 AlertProcessor    ProcessorAlertData: started 
2026-01-03 19:09:38.4842 AlertProcessor    ProcessorAlertData: Stopped 
2026-01-03 19:14:22.2050 DFramework.Database.Query    /* Time Taken: 550*/
[dbo].GenerateSystemAlerts 
2026-01-03 19:14:33.1113 AlertProcessor    ProcessorAlertData: started 
2026-01-03 19:14:37.2832 DFramework.Scheduler.TaskBase    /* Time Taken: 15625.117*/
Opportunity Out Of Stock By Outlet 
2026-01-03 19:14:38.5958 AlertProcessor    ProcessorAlertData: Stopped 
2026-01-03 19:16:52.9718 DFramework.Database.Query    /* Time Taken: 1477*/
DECLARE @IsFileProcessed Int32
SET @IsFileProcessed = '0'
DECLARE @TaskNumber Int32
SET @TaskNumber = '4'
DECLARE @IsDeleted Int32
SET @IsDeleted = '0'
SELECT TOP 1000 IncomingFileId, GatewayId,GatewayMac,RawFileName,AzureContainerName,StartIndex,Tries, CreatedOn FROM IncomingFile
 WHERE [IsFileProcessed] = @IsFileProcessed AND [TaskNumber] = @TaskNumber AND [IsDeleted] = @IsDeleted
 
2026-01-03 19:16:57.7062 DFramework.Database.Query    /* Time Taken: 1198*/
DECLARE @IsFileProcessed Int32
SET @IsFileProcessed = '0'
DECLARE @TaskNumber Int32
SET @TaskNumber = '3'
DECLARE @IsDeleted Int32
SET @IsDeleted = '0'
SELECT TOP 1000 IncomingFileId, GatewayId,GatewayMac,RawFileName,AzureContainerName,StartIndex,Tries, CreatedOn FROM IncomingFile
 WHERE [IsFileProcessed] = @IsFileProcessed AND [TaskNumber] = @TaskNumber AND [IsDeleted] = @IsDeleted
 
2026-01-03 19:16:58.8781 DFramework.Database.Query    /* Time Taken: 2371*/
DECLARE @IsFileProcessed Int32
SET @IsFileProcessed = '0'
DECLARE @TaskNumber Int32
SET @TaskNumber = '4'
DECLARE @IsDeleted Int32
SET @IsDeleted = '0'
SELECT TOP 1000 IncomingFileId, GatewayId,GatewayMac,RawFileName,AzureContainerName,StartIndex,Tries, CreatedOn FROM IncomingFile
 WHERE [IsFileProcessed] = @IsFileProcessed AND [TaskNumber] = @TaskNumber AND [IsDeleted] = @IsDeleted
 
2026-01-03 19:19:33.1292 AlertProcessor    ProcessorAlertData: started 
2026-01-03 19:19:38.5199 AlertProcessor    ProcessorAlertData: Stopped 
2026-01-03 19:24:33.1315 AlertProcessor    ProcessorAlertData: started 
2026-01-03 19:24:38.5846 AlertProcessor    ProcessorAlertData: Stopped 
2026-01-03 19:29:33.1493 AlertProcessor    ProcessorAlertData: started 
2026-01-03 19:29:37.2430 DFramework.Scheduler.TaskBase    /* Time Taken: 15562.6126*/
Opportunity Out Of Stock By Outlet 
2026-01-03 19:29:38.6181 AlertProcessor    ProcessorAlertData: Stopped 
2026-01-03 19:34:33.1671 AlertProcessor    ProcessorAlertData: started 
2026-01-03 19:34:38.5109 AlertProcessor    ProcessorAlertData: Stopped 
2026-01-03 19:39:33.1850 AlertProcessor    ProcessorAlertData: started 
2026-01-03 19:39:38.5444 AlertProcessor    ProcessorAlertData: Stopped 
2026-01-03 19:44:22.2340 DFramework.Database.Query    /* Time Taken: 542*/
[dbo].GenerateSystemAlerts 
2026-01-03 19:44:33.2029 AlertProcessor    ProcessorAlertData: started 
2026-01-03 19:44:37.3123 DFramework.Scheduler.TaskBase    /* Time Taken: 15609.4873*/
Opportunity Out Of Stock By Outlet 
2026-01-03 19:44:38.5623 AlertProcessor    ProcessorAlertData: Stopped 
2026-01-03 19:49:33.2207 AlertProcessor    ProcessorAlertData: started 
2026-01-03 19:49:38.6426 AlertProcessor    ProcessorAlertData: Stopped 
2026-01-03 19:54:33.2386 AlertProcessor    ProcessorAlertData: started 
2026-01-03 19:54:38.7230 AlertProcessor    ProcessorAlertData: Stopped 
2026-01-03 19:59:33.2408 AlertProcessor    ProcessorAlertData: started 
2026-01-03 19:59:37.2877 DFramework.Scheduler.TaskBase    /* Time Taken: 15562.6093*/
Opportunity Out Of Stock By Outlet 
2026-01-03 19:59:38.8190 AlertProcessor    ProcessorAlertData: Stopped 
2026-01-03 20:04:33.2587 AlertProcessor    ProcessorAlertData: started 
2026-01-03 20:04:38.6181 AlertProcessor    ProcessorAlertData: Stopped 
2026-01-03 20:09:33.2765 AlertProcessor    ProcessorAlertData: started 
2026-01-03 20:09:38.8078 AlertProcessor    ProcessorAlertData: Stopped 
2026-01-03 20:14:22.2631 DFramework.Database.Query    /* Time Taken: 528*/
[dbo].GenerateSystemAlerts 
2026-01-03 20:14:33.2788 AlertProcessor    ProcessorAlertData: started 
2026-01-03 20:14:37.3569 DFramework.Scheduler.TaskBase    /* Time Taken: 15609.4911*/
Opportunity Out Of Stock By Outlet 
2026-01-03 20:14:38.7632 AlertProcessor    ProcessorAlertData: Stopped 
2026-01-03 20:19:33.2967 AlertProcessor    ProcessorAlertData: started 
2026-01-03 20:19:38.7655 AlertProcessor    ProcessorAlertData: Stopped 
2026-01-03 20:24:33.2990 AlertProcessor    ProcessorAlertData: started 
2026-01-03 20:24:38.7209 AlertProcessor    ProcessorAlertData: Stopped 
2026-01-03 20:29:22.3012 DFramework.Database.Query    /* Time Taken: 537*/
[dbo].GenerateSystemAlerts 
2026-01-03 20:29:33.3013 AlertProcessor    ProcessorAlertData: started 
2026-01-03 20:29:37.3950 DFramework.Scheduler.TaskBase    /* Time Taken: 15625.1152*/
Opportunity Out Of Stock By Outlet 
2026-01-03 20:29:39.0669 AlertProcessor    ProcessorAlertData: Stopped 
2026-01-03 20:34:33.3192 AlertProcessor    ProcessorAlertData: started 
2026-01-03 20:34:36.2098 DFramework.Database.Query    /* Time Taken: 2481*/
DECLARE @AlertTypeIds AnsiString(8000)
SET @AlertTypeIds = '46,37,59,73,57'
DECLARE @ClientIds AnsiString(8000)
SET @ClientIds = '1494,213,286,114,180,183,299,300,314,316,331,332,333,349,415,451,296,301,303,305,328,335,337,360,385,421,469,471,1480,207,224,291,306,308,325,342,70,134,188,227,295,320,336,338,395,452'
DECLARE @StatusId Int32
SET @StatusId = '1'
SELECT ClientName, AlertType, AlertText, Location.Name AS [Location], Location.Code AS LocationCode, Asset.SerialNumber AS AssetSerialNumber, COALESCE(SmartDevice.SerialNumber, SD.SerialNumber) AS SmartDeviceSerial, AlertAt, AccountCoordinators.PrimaryEmail AS AccountCoordinator, AccountDirectors.PrimaryEmail AS AccountDirector, Alert.ClientId FROM Alert
											LEFT OUTER JOIN Client ON Client.ClientId = Alert.ClientId
											LEFT OUTER JOIN AlertType ON AlertType.AlertTypeId = Alert.AlertTypeId
											LEFT OUTER JOIN Location ON Location.LocationId = Alert.LocationId
											LEFT OUTER JOIN Asset ON Asset.AssetId = Alert.AssetId
											LEFT OUTER JOIN SmartDevice ON SmartDevice.SmartDeviceId = Alert.SmartDeviceId AND SmartDevice.IsGatewayDevice = 0
											LEFT OUTER JOIN vwSmartDeviceExceptSmartHubList AS SD ON dbo.Alert.AssetId = SD.LinkedAssetId AND SD.LinkedAssetId <> 0
											LEFT OUTER JOIN dbo.Security_User AS AccountDirectors ON Client.AccountDirectorId = AccountDirectors.UserId AND AccountDirectors.IsDeleted = 0 
											LEFT OUTER JOIN dbo.Security_User AS AccountCoordinators ON Client.AccountCoordinatorId = AccountCoordinators.UserId AND AccountCoordinators.IsDeleted = 0
										WHERE Alert.IsDeleted = 0 AND Alert.AlertTypeId IN (SELECT * FROM CsvToInt(@AlertTypeIds)) AND Alert.ClientId IN (SELECT * FROM CsvToInt(@ClientIds)) AND Alert.StatusId = @StatusId ORDER BY Alert.ClientId
 
2026-01-03 20:34:39.0223 AlertProcessor    ProcessorAlertData: Stopped 
2026-01-03 20:39:33.3370 AlertProcessor    ProcessorAlertData: started 
2026-01-03 20:39:38.8058 AlertProcessor    ProcessorAlertData: Stopped 
2026-01-03 20:44:33.3549 AlertProcessor    ProcessorAlertData: started 
2026-01-03 20:44:37.3706 DFramework.Scheduler.TaskBase    /* Time Taken: 15578.2383*/
Opportunity Out Of Stock By Outlet 
2026-01-03 20:44:38.8081 AlertProcessor    ProcessorAlertData: Stopped 
2026-01-03 20:49:33.3728 AlertProcessor    ProcessorAlertData: started 
2026-01-03 20:49:38.7947 AlertProcessor    ProcessorAlertData: Stopped 
2026-01-03 20:54:33.3908 AlertProcessor    ProcessorAlertData: started 
2026-01-03 20:54:38.8908 AlertProcessor    ProcessorAlertData: Stopped 
2026-01-03 20:59:33.4087 AlertProcessor    ProcessorAlertData: started 
2026-01-03 20:59:37.3774 DFramework.Scheduler.TaskBase    /* Time Taken: 15578.2289*/
Opportunity Out Of Stock By Outlet 
2026-01-03 20:59:38.8931 AlertProcessor    ProcessorAlertData: Stopped 
2026-01-03 21:04:33.4266 AlertProcessor    ProcessorAlertData: started 
2026-01-03 21:04:38.9266 AlertProcessor    ProcessorAlertData: Stopped 
2026-01-03 21:09:33.4444 AlertProcessor    ProcessorAlertData: started 
2026-01-03 21:09:38.9132 AlertProcessor    ProcessorAlertData: Stopped 
2026-01-03 21:14:22.3372 DFramework.Database.Query    /* Time Taken: 519*/
[dbo].GenerateSystemAlerts 
2026-01-03 21:14:33.4623 AlertProcessor    ProcessorAlertData: started 
2026-01-03 21:14:37.3842 DFramework.Scheduler.TaskBase    /* Time Taken: 15562.6168*/
Opportunity Out Of Stock By Outlet 
2026-01-03 21:14:38.8998 AlertProcessor    ProcessorAlertData: Stopped 
2026-01-03 21:19:33.4802 AlertProcessor    ProcessorAlertData: started 
2026-01-03 21:19:36.4333 DFramework.Database.Query    /* Time Taken: 509*/
DECLARE @TableName AnsiString(8000)
SET @TableName = 'AssetStockProductWiseConsolidate'
DECLARE @CurrentRecordId Int32
SET @CurrentRecordId = '3675525'
dbo.GetValidDeviceForAlertProcessData 
2026-01-03 21:19:38.9646 AlertProcessor    ProcessorAlertData: Stopped 
2026-01-03 21:24:33.4825 AlertProcessor    ProcessorAlertData: started 
2026-01-03 21:24:38.9356 AlertProcessor    ProcessorAlertData: Stopped 
2026-01-03 21:29:22.3598 DFramework.Database.Query    /* Time Taken: 528*/
[dbo].GenerateSystemAlerts 
2026-01-03 21:29:33.4849 AlertProcessor    ProcessorAlertData: started 
2026-01-03 21:29:37.4693 DFramework.Scheduler.TaskBase    /* Time Taken: 15625.1165*/
Opportunity Out Of Stock By Outlet 
2026-01-03 21:29:38.8912 AlertProcessor    ProcessorAlertData: Stopped 
2026-01-03 21:34:33.5028 AlertProcessor    ProcessorAlertData: started 
2026-01-03 21:34:38.8778 AlertProcessor    ProcessorAlertData: Stopped 
2026-01-03 21:39:33.5207 AlertProcessor    ProcessorAlertData: started 
2026-01-03 21:39:38.9426 AlertProcessor    ProcessorAlertData: Stopped 
2026-01-03 21:44:22.3822 DFramework.Database.Query    /* Time Taken: 527*/
[dbo].GenerateSystemAlerts 
2026-01-03 21:44:33.5386 AlertProcessor    ProcessorAlertData: started 
2026-01-03 21:44:37.4761 DFramework.Scheduler.TaskBase    /* Time Taken: 15609.4922*/
Opportunity Out Of Stock By Outlet 
2026-01-03 21:44:39.0073 AlertProcessor    ProcessorAlertData: Stopped 
2026-01-03 21:49:33.5564 AlertProcessor    ProcessorAlertData: started 
2026-01-03 21:49:38.9471 AlertProcessor    ProcessorAlertData: Stopped 
2026-01-03 21:54:33.5587 AlertProcessor    ProcessorAlertData: started 
2026-01-03 21:54:39.0587 AlertProcessor    ProcessorAlertData: Stopped 
2026-01-03 21:59:22.4046 DFramework.Database.Query    /* Time Taken: 529*/
[dbo].GenerateSystemAlerts 
2026-01-03 21:59:33.5766 AlertProcessor    ProcessorAlertData: started 
2026-01-03 21:59:37.5141 DFramework.Scheduler.TaskBase    /* Time Taken: 15625.1208*/
Opportunity Out Of Stock By Outlet 
2026-01-03 21:59:38.8735 AlertProcessor    ProcessorAlertData: Stopped 
2026-01-03 22:04:33.5789 AlertProcessor    ProcessorAlertData: started 
2026-01-03 22:04:39.0477 AlertProcessor    ProcessorAlertData: Stopped 
2026-01-03 22:09:33.5968 AlertProcessor    ProcessorAlertData: started 
2026-01-03 22:09:39.0656 AlertProcessor    ProcessorAlertData: Stopped 
2026-01-03 22:14:22.4271 DFramework.Database.Query    /* Time Taken: 520*/
[dbo].GenerateSystemAlerts 
2026-01-03 22:14:33.6147 AlertProcessor    ProcessorAlertData: started 
2026-01-03 22:14:37.4741 DFramework.Scheduler.TaskBase    /* Time Taken: 15562.6176*/
Opportunity Out Of Stock By Outlet 
2026-01-03 22:14:39.1772 AlertProcessor    ProcessorAlertData: Stopped 
2026-01-03 22:19:33.6326 AlertProcessor    ProcessorAlertData: started 
2026-01-03 22:19:39.1170 AlertProcessor    ProcessorAlertData: Stopped 
2026-01-03 22:24:33.6349 AlertProcessor    ProcessorAlertData: started 
2026-01-03 22:24:39.0255 AlertProcessor    ProcessorAlertData: Stopped 
2026-01-03 22:29:33.6528 AlertProcessor    ProcessorAlertData: started 
2026-01-03 22:29:37.4965 DFramework.Scheduler.TaskBase    /* Time Taken: 15562.6057*/
Opportunity Out Of Stock By Outlet 
2026-01-03 22:29:39.0903 AlertProcessor    ProcessorAlertData: Stopped 
2026-01-03 22:34:33.6706 AlertProcessor    ProcessorAlertData: started 
2026-01-03 22:34:39.1707 AlertProcessor    ProcessorAlertData: Stopped 
2026-01-03 22:39:33.6885 AlertProcessor    ProcessorAlertData: started 
2026-01-03 22:39:39.0323 AlertProcessor    ProcessorAlertData: Stopped 
2026-01-03 22:44:22.4719 DFramework.Database.Query    /* Time Taken: 536*/
[dbo].GenerateSystemAlerts 
2026-01-03 22:44:33.7064 AlertProcessor    ProcessorAlertData: started 
2026-01-03 22:44:37.5658 DFramework.Scheduler.TaskBase    /* Time Taken: 15625.1169*/
Opportunity Out Of Stock By Outlet 
2026-01-03 22:44:39.0814 AlertProcessor    ProcessorAlertData: Stopped 
2026-01-03 22:49:33.7243 AlertProcessor    ProcessorAlertData: started 
2026-01-03 22:49:39.1618 AlertProcessor    ProcessorAlertData: Stopped 
2026-01-03 22:54:33.7266 AlertProcessor    ProcessorAlertData: started 
2026-01-03 22:54:39.2110 AlertProcessor    ProcessorAlertData: Stopped 
2026-01-03 22:59:22.4944 DFramework.Database.Query    /* Time Taken: 541*/
[dbo].GenerateSystemAlerts 
2026-01-03 22:59:33.7289 AlertProcessor    ProcessorAlertData: started 
2026-01-03 22:59:37.5883 DFramework.Scheduler.TaskBase    /* Time Taken: 15625.1176*/
Opportunity Out Of Stock By Outlet 
2026-01-03 22:59:39.1351 AlertProcessor    ProcessorAlertData: Stopped 
2026-01-03 23:04:33.7311 AlertProcessor    ProcessorAlertData: started 
2026-01-03 23:04:39.2468 AlertProcessor    ProcessorAlertData: Stopped 
2026-01-03 23:09:33.7335 AlertProcessor    ProcessorAlertData: started 
2026-01-03 23:09:39.3585 DFramework.Database.NullableDataReader    Data reader open for 279
   at System.Environment.GetStackTrace(Exception e, Boolean needFileInfo)
   at System.Environment.get_StackTrace()
   at DFramework.Database.NullableDataReader.Dispose(Boolean disposing) in D:\Spraxa\Framework\DFramework\Database\NullableDataReader.cs:line 33
   at DFramework.Database.NullableDataReader.Dispose() in D:\Spraxa\Framework\DFramework\Database\NullableDataReader.cs:line 44
   at CoolR.Tasks.ProcessAlertData.Execute() in D:\Spraxa\CoolR-Group\portal\CoolR.Tasks\ProcessAlertData.cs:line 47
   at DFramework.Scheduler.TaskBase.Run() in D:\Spraxa\Framework\DFramework.Scheduler\TaskBase.cs:line 176
   at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)
   at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)
   at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state)
   at System.Threading.ThreadHelper.ThreadStart() 
2026-01-03 23:09:39.3585 AlertProcessor    ProcessorAlertData: Stopped 
2026-01-03 23:14:22.5013 DFramework.Database.Query    /* Time Taken: 521*/
[dbo].GenerateSystemAlerts 
2026-01-03 23:14:33.7358 AlertProcessor    ProcessorAlertData: started 
2026-01-03 23:14:37.6108 DFramework.Scheduler.TaskBase    /* Time Taken: 15625.1201*/
Opportunity Out Of Stock By Outlet 
2026-01-03 23:14:39.1421 AlertProcessor    ProcessorAlertData: Stopped 
2026-01-03 23:19:33.7537 AlertProcessor    ProcessorAlertData: started 
2026-01-03 23:19:39.1287 AlertProcessor    ProcessorAlertData: Stopped 
2026-01-03 23:24:33.7559 AlertProcessor    ProcessorAlertData: started 
2026-01-03 23:24:36.8653 DFramework.Database.NullableDataReader    Data reader open for 274
   at System.Environment.GetStackTrace(Exception e, Boolean needFileInfo)
   at System.Environment.get_StackTrace()
   at DFramework.Database.NullableDataReader.Dispose(Boolean disposing) in D:\Spraxa\Framework\DFramework\Database\NullableDataReader.cs:line 33
   at DFramework.Database.NullableDataReader.Dispose() in D:\Spraxa\Framework\DFramework\Database\NullableDataReader.cs:line 44
   at CoolR.Tasks.ProcessAlertData.Execute() in D:\Spraxa\CoolR-Group\portal\CoolR.Tasks\ProcessAlertData.cs:line 47
   at DFramework.Scheduler.TaskBase.Run() in D:\Spraxa\Framework\DFramework.Scheduler\TaskBase.cs:line 176
   at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)
   at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)
   at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state)
   at System.Threading.ThreadHelper.ThreadStart() 
2026-01-03 23:24:39.2872 AlertProcessor    ProcessorAlertData: Stopped 
2026-01-03 23:29:22.5394 DFramework.Database.Query    /* Time Taken: 531*/
[dbo].GenerateSystemAlerts 
2026-01-03 23:29:33.7738 AlertProcessor    ProcessorAlertData: started 
2026-01-03 23:29:37.6176 DFramework.Scheduler.TaskBase    /* Time Taken: 15609.495*/
Opportunity Out Of Stock By Outlet 
2026-01-03 23:29:39.1176 AlertProcessor    ProcessorAlertData: Stopped 
2026-01-03 23:34:33.7917 AlertProcessor    ProcessorAlertData: started 
2026-01-03 23:34:39.1199 AlertProcessor    ProcessorAlertData: Stopped 
2026-01-03 23:39:33.8096 AlertProcessor    ProcessorAlertData: started 
2026-01-03 23:39:39.3565 AlertProcessor    ProcessorAlertData: Stopped 
2026-01-03 23:44:33.8275 AlertProcessor    ProcessorAlertData: started 
2026-01-03 23:44:37.5932 DFramework.Scheduler.TaskBase    /* Time Taken: 15562.6193*/
Opportunity Out Of Stock By Outlet 
2026-01-03 23:44:39.1869 AlertProcessor    ProcessorAlertData: Stopped 
2026-01-03 23:49:33.8454 AlertProcessor    ProcessorAlertData: started 
2026-01-03 23:49:39.2048 AlertProcessor    ProcessorAlertData: Stopped 
2026-01-03 23:54:33.8633 AlertProcessor    ProcessorAlertData: started 
2026-01-03 23:54:39.2540 AlertProcessor    ProcessorAlertData: Stopped 
2026-01-03 23:59:22.5998 DFramework.Database.Query    /* Time Taken: 559*/
[dbo].GenerateSystemAlerts 
2026-01-03 23:59:33.8812 AlertProcessor    ProcessorAlertData: started 
2026-01-03 23:59:37.6156 DFramework.Scheduler.TaskBase    /* Time Taken: 15562.618*/
Opportunity Out Of Stock By Outlet 
2026-01-03 23:59:39.2562 AlertProcessor    ProcessorAlertData: Stopped