2026-01-11 00:00:21.7419 DFramework.Scheduler.TaskBase /* Time Taken: 15531.367*/ Opportunity Out Of Stock By Outlet 2026-01-11 00:15:06.9830 DFramework.Database.Query /* Time Taken: 534*/ [dbo].GenerateSystemAlerts 2026-01-11 00:15:21.8268 DFramework.Scheduler.TaskBase /* Time Taken: 15593.8641*/ Opportunity Out Of Stock By Outlet 2026-01-11 00:30:07.0056 DFramework.Database.Query /* Time Taken: 543*/ [dbo].GenerateSystemAlerts 2026-01-11 00:30:21.8494 DFramework.Scheduler.TaskBase /* Time Taken: 15593.863*/ Opportunity Out Of Stock By Outlet 2026-01-11 00:45:21.8094 DFramework.Scheduler.TaskBase /* Time Taken: 15531.3703*/ Opportunity Out Of Stock By Outlet 2026-01-11 01:00:21.8163 DFramework.Scheduler.TaskBase /* Time Taken: 15515.7427*/ Opportunity Out Of Stock By Outlet 2026-01-11 01:15:21.8387 DFramework.Scheduler.TaskBase /* Time Taken: 15531.3683*/ Opportunity Out Of Stock By Outlet 2026-01-11 01:30:07.0799 DFramework.Database.Query /* Time Taken: 526*/ [dbo].GenerateSystemAlerts 2026-01-11 01:30:21.8768 DFramework.Scheduler.TaskBase /* Time Taken: 15562.6181*/ Opportunity Out Of Stock By Outlet 2026-01-11 01:45:21.8368 DFramework.Scheduler.TaskBase /* Time Taken: 15515.7454*/ Opportunity Out Of Stock By Outlet 2026-01-11 02:00:21.8750 DFramework.Scheduler.TaskBase /* Time Taken: 15531.3934*/ Opportunity Out Of Stock By Outlet 2026-01-11 02:15:07.1318 DFramework.Database.Query /* Time Taken: 509*/ [dbo].GenerateSystemAlerts 2026-01-11 02:15:21.9288 DFramework.Scheduler.TaskBase /* Time Taken: 15562.62*/ Opportunity Out Of Stock By Outlet 2026-01-11 02:30:21.9200 DFramework.Scheduler.TaskBase /* Time Taken: 15531.3636*/ Opportunity Out Of Stock By Outlet 2026-01-11 02:45:21.9581 DFramework.Scheduler.TaskBase /* Time Taken: 15546.9941*/ Opportunity Out Of Stock By Outlet 2026-01-11 03:00:21.9494 DFramework.Scheduler.TaskBase /* Time Taken: 15515.7451*/ Opportunity Out Of Stock By Outlet 2026-01-11 03:15:07.1749 DFramework.Database.Query /* Time Taken: 503*/ [dbo].GenerateSystemAlerts 2026-01-11 03:15:22.0188 DFramework.Scheduler.TaskBase /* Time Taken: 15562.6206*/ Opportunity Out Of Stock By Outlet 2026-01-11 03:30:07.3693 DFramework.Database.Query /* Time Taken: 673*/ [dbo].GenerateSystemAlerts 2026-01-11 03:30:22.0100 DFramework.Scheduler.TaskBase /* Time Taken: 15531.3692*/ Opportunity Out Of Stock By Outlet 2026-01-11 03:45:22.0325 DFramework.Scheduler.TaskBase /* Time Taken: 15531.3695*/ Opportunity Out Of Stock By Outlet 2026-01-11 04:00:22.0237 DFramework.Scheduler.TaskBase /* Time Taken: 15515.7419*/ Opportunity Out Of Stock By Outlet 2026-01-11 04:15:22.0775 DFramework.Scheduler.TaskBase /* Time Taken: 15546.9943*/ Opportunity Out Of Stock By Outlet 2026-01-11 04:30:22.0687 DFramework.Scheduler.TaskBase /* Time Taken: 15515.7445*/ Opportunity Out Of Stock By Outlet 2026-01-11 04:45:07.3567 DFramework.Database.Query /* Time Taken: 563*/ [dbo].GenerateSystemAlerts 2026-01-11 04:45:22.1537 DFramework.Scheduler.TaskBase /* Time Taken: 15578.2421*/ Opportunity Out Of Stock By Outlet 2026-01-11 05:00:22.1449 DFramework.Scheduler.TaskBase /* Time Taken: 15546.9842*/ Opportunity Out Of Stock By Outlet 2026-01-11 05:15:22.1361 DFramework.Scheduler.TaskBase /* Time Taken: 15515.7388*/ Opportunity Out Of Stock By Outlet 2026-01-11 05:30:22.1741 DFramework.Scheduler.TaskBase /* Time Taken: 15531.3581*/ Opportunity Out Of Stock By Outlet 2026-01-11 05:45:22.2122 DFramework.Scheduler.TaskBase /* Time Taken: 15546.9929*/ Opportunity Out Of Stock By Outlet 2026-01-11 06:00:22.2190 DFramework.Scheduler.TaskBase /* Time Taken: 15531.367*/ Opportunity Out Of Stock By Outlet 2026-01-11 06:15:22.2572 DFramework.Scheduler.TaskBase /* Time Taken: 15546.99*/ Opportunity Out Of Stock By Outlet 2026-01-11 06:30:22.2952 DFramework.Scheduler.TaskBase /* Time Taken: 15562.6133*/ Opportunity Out Of Stock By Outlet 2026-01-11 06:45:22.3177 DFramework.Scheduler.TaskBase /* Time Taken: 15562.6196*/ Opportunity Out Of Stock By Outlet 2026-01-11 07:00:22.3403 DFramework.Scheduler.TaskBase /* Time Taken: 15562.6202*/ Opportunity Out Of Stock By Outlet 2026-01-11 07:15:22.3784 DFramework.Scheduler.TaskBase /* Time Taken: 15578.2402*/ Opportunity Out Of Stock By Outlet 2026-01-11 07:30:07.6039 DFramework.Database.Query /* Time Taken: 572*/ [dbo].GenerateSystemAlerts 2026-01-11 07:30:22.4165 DFramework.Scheduler.TaskBase /* Time Taken: 15593.8733*/ Opportunity Out Of Stock By Outlet 2026-01-11 07:45:22.4077 DFramework.Scheduler.TaskBase /* Time Taken: 15562.6592*/ Opportunity Out Of Stock By Outlet 2026-01-11 08:00:22.4145 DFramework.Scheduler.TaskBase /* Time Taken: 15546.993*/ Opportunity Out Of Stock By Outlet 2026-01-11 08:15:22.4526 DFramework.Scheduler.TaskBase /* Time Taken: 15562.6205*/ Opportunity Out Of Stock By Outlet 2026-01-11 08:30:07.6625 DFramework.Database.Query /* Time Taken: 535*/ [dbo].GenerateSystemAlerts 2026-01-11 08:30:22.5063 DFramework.Scheduler.TaskBase /* Time Taken: 15609.4929*/ Opportunity Out Of Stock By Outlet 2026-01-11 08:45:07.7006 DFramework.Database.Query /* Time Taken: 561*/ [dbo].GenerateSystemAlerts 2026-01-11 08:45:22.4976 DFramework.Scheduler.TaskBase /* Time Taken: 15578.2428*/ Opportunity Out Of Stock By Outlet 2026-01-11 09:00:07.7075 DFramework.Database.Query /* Time Taken: 540*/ [dbo].GenerateSystemAlerts 2026-01-11 09:00:22.5513 DFramework.Scheduler.TaskBase /* Time Taken: 15609.4945*/ Opportunity Out Of Stock By Outlet 2026-01-11 09:15:07.8549 DFramework.Database.Query /* Time Taken: 662*/ [dbo].GenerateSystemAlerts 2026-01-11 09:15:22.5269 DFramework.Scheduler.TaskBase /* Time Taken: 15578.2428*/ Opportunity Out Of Stock By Outlet 2026-01-11 09:30:07.7211 DFramework.Database.Query /* Time Taken: 524*/ [dbo].GenerateSystemAlerts 2026-01-11 09:30:22.5494 DFramework.Scheduler.TaskBase /* Time Taken: 15578.2404*/ Opportunity Out Of Stock By Outlet 2026-01-11 09:45:07.7437 DFramework.Database.Query /* Time Taken: 531*/ [dbo].GenerateSystemAlerts 2026-01-11 09:45:22.5875 DFramework.Scheduler.TaskBase /* Time Taken: 15593.8848*/ Opportunity Out Of Stock By Outlet 2026-01-11 10:00:07.7507 DFramework.Database.Query /* Time Taken: 518*/ [dbo].GenerateSystemAlerts 2026-01-11 10:00:22.6102 DFramework.Scheduler.TaskBase /* Time Taken: 15593.8677*/ Opportunity Out Of Stock By Outlet 2026-01-11 10:15:07.8181 DFramework.Database.Query /* Time Taken: 562*/ [dbo].GenerateSystemAlerts 2026-01-11 10:15:22.6620 DFramework.Scheduler.TaskBase /* Time Taken: 15625.1106*/ Opportunity Out Of Stock By Outlet 2026-01-11 10:30:07.7954 DFramework.Database.Query /* Time Taken: 523*/ [dbo].GenerateSystemAlerts 2026-01-11 10:30:22.6549 DFramework.Scheduler.TaskBase /* Time Taken: 15593.8726*/ Opportunity Out Of Stock By Outlet 2026-01-11 10:45:07.8493 DFramework.Database.Query /* Time Taken: 557*/ [dbo].GenerateSystemAlerts 2026-01-11 10:45:22.6463 DFramework.Scheduler.TaskBase /* Time Taken: 15578.2476*/ Opportunity Out Of Stock By Outlet 2026-01-11 11:00:07.8562 DFramework.Database.Query /* Time Taken: 542*/ [dbo].GenerateSystemAlerts 2026-01-11 11:00:22.6375 DFramework.Scheduler.TaskBase /* Time Taken: 15562.6195*/ Opportunity Out Of Stock By Outlet 2026-01-11 11:15:07.8631 DFramework.Database.Query /* Time Taken: 531*/ [dbo].GenerateSystemAlerts 2026-01-11 11:15:22.6601 DFramework.Scheduler.TaskBase /* Time Taken: 15562.6211*/ Opportunity Out Of Stock By Outlet 2026-01-11 11:30:07.8388 DFramework.Database.Query /* Time Taken: 511*/ [dbo].GenerateSystemAlerts 2026-01-11 11:30:22.6982 DFramework.Scheduler.TaskBase /* Time Taken: 15578.2455*/ Opportunity Out Of Stock By Outlet 2026-01-11 11:45:07.8769 DFramework.Database.Query /* Time Taken: 516*/ [dbo].GenerateSystemAlerts 2026-01-11 11:45:22.7051 DFramework.Scheduler.TaskBase /* Time Taken: 15562.618*/ Opportunity Out Of Stock By Outlet 2026-01-11 12:00:07.8993 DFramework.Database.Query /* Time Taken: 524*/ [dbo].GenerateSystemAlerts 2026-01-11 12:00:22.7276 DFramework.Scheduler.TaskBase /* Time Taken: 15562.6173*/ Opportunity Out Of Stock By Outlet 2026-01-11 12:15:07.9687 DFramework.Database.Query /* Time Taken: 573*/ [dbo].GenerateSystemAlerts 2026-01-11 12:15:22.7813 DFramework.Scheduler.TaskBase /* Time Taken: 15593.8703*/ Opportunity Out Of Stock By Outlet 2026-01-11 12:30:08.0068 DFramework.Database.Query /* Time Taken: 590*/ [dbo].GenerateSystemAlerts 2026-01-11 12:30:22.7882 DFramework.Scheduler.TaskBase /* Time Taken: 15578.2395*/ Opportunity Out Of Stock By Outlet 2026-01-11 12:45:07.9668 DFramework.Database.Query /* Time Taken: 526*/ [dbo].GenerateSystemAlerts 2026-01-11 12:45:22.7950 DFramework.Scheduler.TaskBase /* Time Taken: 15562.6147*/ Opportunity Out Of Stock By Outlet 2026-01-11 13:00:07.9893 DFramework.Database.Query /* Time Taken: 526*/ [dbo].GenerateSystemAlerts 2026-01-11 13:00:22.8175 DFramework.Scheduler.TaskBase /* Time Taken: 15562.6093*/ Opportunity Out Of Stock By Outlet 2026-01-11 13:15:08.0430 DFramework.Database.Query /* Time Taken: 547*/ [dbo].GenerateSystemAlerts 2026-01-11 13:15:22.8400 DFramework.Scheduler.TaskBase /* Time Taken: 15578.2452*/ Opportunity Out Of Stock By Outlet 2026-01-11 13:30:08.0343 DFramework.Database.Query /* Time Taken: 526*/ [dbo].GenerateSystemAlerts 2026-01-11 13:30:22.8625 DFramework.Scheduler.TaskBase /* Time Taken: 15578.2464*/ Opportunity Out Of Stock By Outlet 2026-01-11 13:45:08.0256 DFramework.Database.Query /* Time Taken: 513*/ [dbo].GenerateSystemAlerts 2026-01-11 13:45:22.8695 DFramework.Scheduler.TaskBase /* Time Taken: 15562.6185*/ Opportunity Out Of Stock By Outlet 2026-01-11 14:00:08.1106 DFramework.Database.Query /* Time Taken: 573*/ [dbo].GenerateSystemAlerts 2026-01-11 14:00:22.9388 DFramework.Scheduler.TaskBase /* Time Taken: 15609.4916*/ Opportunity Out Of Stock By Outlet 2026-01-11 14:15:08.0706 DFramework.Database.Query /* Time Taken: 503*/ [dbo].GenerateSystemAlerts 2026-01-11 14:15:22.8988 DFramework.Scheduler.TaskBase /* Time Taken: 15562.6188*/ Opportunity Out Of Stock By Outlet 2026-01-11 14:30:08.1087 DFramework.Database.Query /* Time Taken: 517*/ [dbo].GenerateSystemAlerts 2026-01-11 14:30:22.9369 DFramework.Scheduler.TaskBase /* Time Taken: 15578.2461*/ Opportunity Out Of Stock By Outlet 2026-01-11 14:45:08.1001 DFramework.Database.Query /* Time Taken: 514*/ [dbo].GenerateSystemAlerts 2026-01-11 14:45:22.9596 DFramework.Scheduler.TaskBase /* Time Taken: 15578.2419*/ Opportunity Out Of Stock By Outlet 2026-01-11 15:00:08.1538 DFramework.Database.Query /* Time Taken: 542*/ [dbo].GenerateSystemAlerts 2026-01-11 15:00:22.9664 DFramework.Scheduler.TaskBase /* Time Taken: 15562.6208*/ Opportunity Out Of Stock By Outlet 2026-01-11 15:11:56.9092 DFramework.Database.NullableDataReader Data reader open for 301 at System.Environment.GetStackTrace(Exception e, Boolean needFileInfo) at System.Environment.get_StackTrace() at DFramework.Database.NullableDataReader.Dispose(Boolean disposing) in C:\CoolR-Group\Framework\DFramework\Database\NullableDataReader.cs:line 33 at DFramework.Database.NullableDataReader.Dispose() in C:\CoolR-Group\Framework\DFramework\Database\NullableDataReader.cs:line 44 at CoolR.Tasks.ProcessAlertData.LoadStockData(Int32 currentRecordId, DateTime startDate, DateTime latestEventTime, Int32 assetId, Boolean isComingFromStockLow) in C:\Program Files (x86)\Go Agent\pipelines\coolr-portal-dev-task-service-new\CoolR.Tasks\ProcessAlertData.cs:line 1614 at CoolR.Tasks.ProcessAlertData.StockAlertProductWise(Int32 alertId, Int32 currentRecordId, DateTime latestEventTime, Boolean isForAllProduct, Int32 stockThreshold, Int32 assetId, String alertText, Int32 alertDefinitionId, DateTime startDate, DateTime endDate, Int32 clientId, Int32 locationId, Int32 priorityId) in C:\Program Files (x86)\Go Agent\pipelines\coolr-portal-dev-task-service-new\CoolR.Tasks\ProcessAlertData.cs:line 1379 at CoolR.Tasks.ProcessAlertData.Execute() in C:\Program Files (x86)\Go Agent\pipelines\coolr-portal-dev-task-service-new\CoolR.Tasks\ProcessAlertData.cs:line 343 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-11 15:15:08.1763 DFramework.Database.Query /* Time Taken: 533*/ [dbo].GenerateSystemAlerts 2026-01-11 15:15:23.0046 DFramework.Scheduler.TaskBase /* Time Taken: 15578.2391*/ Opportunity Out Of Stock By Outlet 2026-01-11 15:30:08.1676 DFramework.Database.Query /* Time Taken: 511*/ [dbo].GenerateSystemAlerts 2026-01-11 15:30:23.0114 DFramework.Scheduler.TaskBase /* Time Taken: 15562.6154*/ Opportunity Out Of Stock By Outlet 2026-01-11 15:45:08.2370 DFramework.Database.Query /* Time Taken: 558*/ [dbo].GenerateSystemAlerts 2026-01-11 15:45:23.0652 DFramework.Scheduler.TaskBase /* Time Taken: 15593.8698*/ Opportunity Out Of Stock By Outlet 2026-01-11 16:00:08.2282 DFramework.Database.Query /* Time Taken: 520*/ [dbo].GenerateSystemAlerts 2026-01-11 16:00:23.1189 DFramework.Scheduler.TaskBase /* Time Taken: 15625.1214*/ Opportunity Out Of Stock By Outlet 2026-01-11 16:15:08.3288 DFramework.Database.Query /* Time Taken: 597*/ [dbo].GenerateSystemAlerts 2026-01-11 16:15:23.1883 DFramework.Scheduler.TaskBase /* Time Taken: 15671.9946*/ Opportunity Out Of Stock By Outlet 2026-01-11 16:30:08.3045 DFramework.Database.Query /* Time Taken: 553*/ [dbo].GenerateSystemAlerts 2026-01-11 16:30:23.1014 DFramework.Scheduler.TaskBase /* Time Taken: 15578.2442*/ Opportunity Out Of Stock By Outlet 2026-01-11 16:45:08.2801 DFramework.Database.Query /* Time Taken: 502*/ [dbo].GenerateSystemAlerts 2026-01-11 16:45:23.1240 DFramework.Scheduler.TaskBase /* Time Taken: 15578.2696*/ Opportunity Out Of Stock By Outlet 2026-01-11 17:00:08.3651 DFramework.Database.Query /* Time Taken: 579*/ [dbo].GenerateSystemAlerts 2026-01-11 17:00:23.1933 DFramework.Scheduler.TaskBase /* Time Taken: 15625.1194*/ Opportunity Out Of Stock By Outlet 2026-01-11 17:15:08.6532 DFramework.Database.Query /* Time Taken: 848*/ [dbo].GenerateSystemAlerts 2026-01-11 17:15:23.1846 DFramework.Scheduler.TaskBase /* Time Taken: 15593.8699*/ Opportunity Out Of Stock By Outlet 2026-01-11 17:30:08.3633 DFramework.Database.Query /* Time Taken: 543*/ [dbo].GenerateSystemAlerts 2026-01-11 17:30:23.1760 DFramework.Scheduler.TaskBase /* Time Taken: 15562.6233*/ Opportunity Out Of Stock By Outlet 2026-01-11 17:45:08.3703 DFramework.Database.Query /* Time Taken: 526*/ [dbo].GenerateSystemAlerts 2026-01-11 17:45:23.2766 DFramework.Scheduler.TaskBase /* Time Taken: 15640.7322*/ Opportunity Out Of Stock By Outlet 2026-01-11 18:00:08.3927 DFramework.Database.Query /* Time Taken: 523*/ [dbo].GenerateSystemAlerts 2026-01-11 18:00:23.2054 DFramework.Scheduler.TaskBase /* Time Taken: 15562.6247*/ Opportunity Out Of Stock By Outlet 2026-01-11 18:15:08.3997 DFramework.Database.Query /* Time Taken: 511*/ [dbo].GenerateSystemAlerts 2026-01-11 18:15:23.1967 DFramework.Scheduler.TaskBase /* Time Taken: 15546.9963*/ Opportunity Out Of Stock By Outlet 2026-01-11 18:30:08.5470 DFramework.Database.Query /* Time Taken: 653*/ [dbo].GenerateSystemAlerts 2026-01-11 18:30:23.4065 DFramework.Scheduler.TaskBase /* Time Taken: 15734.4936*/ Opportunity Out Of Stock By Outlet 2026-01-11 18:45:08.4134 DFramework.Database.Query /* Time Taken: 512*/ [dbo].GenerateSystemAlerts 2026-01-11 18:45:23.2416 DFramework.Scheduler.TaskBase /* Time Taken: 15562.6189*/ Opportunity Out Of Stock By Outlet 2026-01-11 19:00:08.4356 DFramework.Database.Query /* Time Taken: 519*/ [dbo].GenerateSystemAlerts 2026-01-11 19:00:23.2639 DFramework.Scheduler.TaskBase /* Time Taken: 15578.2422*/ Opportunity Out Of Stock By Outlet 2026-01-11 19:15:08.4422 DFramework.Database.Query /* Time Taken: 518*/ [dbo].GenerateSystemAlerts 2026-01-11 19:15:23.2860 DFramework.Scheduler.TaskBase /* Time Taken: 15578.2362*/ Opportunity Out Of Stock By Outlet 2026-01-11 19:30:08.4801 DFramework.Database.Query /* Time Taken: 537*/ [dbo].GenerateSystemAlerts 2026-01-11 19:30:23.3084 DFramework.Scheduler.TaskBase /* Time Taken: 15578.2398*/ Opportunity Out Of Stock By Outlet 2026-01-11 19:45:08.4698 DFramework.Database.Query /* Time Taken: 515*/ [dbo].GenerateSystemAlerts 2026-01-11 19:45:23.2980 DFramework.Scheduler.TaskBase /* Time Taken: 15562.5368*/ Opportunity Out Of Stock By Outlet 2026-01-11 20:00:23.3200 DFramework.Scheduler.TaskBase /* Time Taken: 15562.7426*/ Opportunity Out Of Stock By Outlet 2026-01-11 20:15:08.5316 DFramework.Database.Query /* Time Taken: 537*/ [dbo].GenerateSystemAlerts 2026-01-11 20:15:23.3754 DFramework.Scheduler.TaskBase /* Time Taken: 15593.8698*/ Opportunity Out Of Stock By Outlet 2026-01-11 20:30:08.6012 DFramework.Database.Query /* Time Taken: 578*/ [dbo].GenerateSystemAlerts 2026-01-11 20:30:23.3982 DFramework.Scheduler.TaskBase /* Time Taken: 15593.8698*/ Opportunity Out Of Stock By Outlet 2026-01-11 20:45:08.5455 DFramework.Database.Query /* Time Taken: 510*/ [dbo].GenerateSystemAlerts 2026-01-11 20:45:23.4050 DFramework.Scheduler.TaskBase /* Time Taken: 15578.2467*/ Opportunity Out Of Stock By Outlet 2026-01-11 21:00:08.7867 DFramework.Database.Query /* Time Taken: 732*/ [dbo].GenerateSystemAlerts 2026-01-11 21:00:23.7244 DFramework.Scheduler.TaskBase /* Time Taken: 15875.1248*/ Opportunity Out Of Stock By Outlet 2026-01-11 21:15:08.6217 DFramework.Database.Query /* Time Taken: 531*/ [dbo].GenerateSystemAlerts 2026-01-11 21:15:23.4499 DFramework.Scheduler.TaskBase /* Time Taken: 15578.2412*/ Opportunity Out Of Stock By Outlet 2026-01-11 21:30:08.7066 DFramework.Database.Query /* Time Taken: 606*/ [dbo].GenerateSystemAlerts 2026-01-11 21:30:23.4568 DFramework.Scheduler.TaskBase /* Time Taken: 15562.6253*/ Opportunity Out Of Stock By Outlet 2026-01-11 21:45:08.6510 DFramework.Database.Query /* Time Taken: 518*/ [dbo].GenerateSystemAlerts 2026-01-11 21:45:23.4949 DFramework.Scheduler.TaskBase /* Time Taken: 15578.2619*/ Opportunity Out Of Stock By Outlet 2026-01-11 22:00:08.7360 DFramework.Database.Query /* Time Taken: 578*/ [dbo].GenerateSystemAlerts 2026-01-11 22:00:23.5642 DFramework.Scheduler.TaskBase /* Time Taken: 15625.1166*/ Opportunity Out Of Stock By Outlet 2026-01-11 22:15:08.6959 DFramework.Database.Query /* Time Taken: 528*/ [dbo].GenerateSystemAlerts 2026-01-11 22:15:23.5398 DFramework.Scheduler.TaskBase /* Time Taken: 15578.2469*/ Opportunity Out Of Stock By Outlet 2026-01-11 22:30:23.5467 DFramework.Scheduler.TaskBase /* Time Taken: 15562.6165*/ Opportunity Out Of Stock By Outlet 2026-01-11 22:45:08.7410 DFramework.Database.Query /* Time Taken: 520*/ [dbo].GenerateSystemAlerts 2026-01-11 22:45:23.5692 DFramework.Scheduler.TaskBase /* Time Taken: 15562.6179*/ Opportunity Out Of Stock By Outlet 2026-01-11 22:48:17.1799 DFramework.Database.NullableDataReader Data reader open for 227881661 at System.Environment.GetStackTrace(Exception e, Boolean needFileInfo) at System.Environment.get_StackTrace() at DFramework.Database.NullableDataReader.Dispose(Boolean disposing) in C:\CoolR-Group\Framework\DFramework\Database\NullableDataReader.cs:line 33 at DFramework.Database.NullableDataReader.Dispose() in C:\CoolR-Group\Framework\DFramework\Database\NullableDataReader.cs:line 44 at CoolR.Tasks.ProcessAlertData.Execute() in C:\Program Files (x86)\Go Agent\pipelines\coolr-portal-dev-task-service-new\CoolR.Tasks\ProcessAlertData.cs:line 343 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-11 22:48:17.1799 DFramework.Database.NullableDataReader Data reader open for 227881752 at System.Environment.GetStackTrace(Exception e, Boolean needFileInfo) at System.Environment.get_StackTrace() at DFramework.Database.NullableDataReader.Dispose(Boolean disposing) in C:\CoolR-Group\Framework\DFramework\Database\NullableDataReader.cs:line 33 at DFramework.Database.NullableDataReader.Dispose() in C:\CoolR-Group\Framework\DFramework\Database\NullableDataReader.cs:line 44 at CoolR.Tasks.ProcessAlertData.Execute() in C:\Program Files (x86)\Go Agent\pipelines\coolr-portal-dev-task-service-new\CoolR.Tasks\ProcessAlertData.cs:line 343 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-11 22:48:17.4299 DFramework.Scheduler.TaskBase /* Time Taken: 227894356.4807*/ Process Alert Record 2026-01-11 22:48:29.7269 AlertProcessor ProcessorAlertData: started 2026-01-11 22:48:30.6175 DFramework.Database.Query /* Time Taken: 838*/ 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 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-11 22:48:30.6644 DFramework.Database.Query /* Time Taken: 867*/ DECLARE @IsActive Int32 SET @IsActive = '1' DECLARE @FtpTypeId Int32 SET @FtpTypeId = '7766' DECLARE @ClientId Int32 SET @ClientId = '213' Select * from vwFTPClientList WHERE [IsActive] = @IsActive AND [FtpTypeId] = @FtpTypeId AND [ClientId] = @ClientId ORDER BY [ClientFtpId] 2026-01-11 22:48:30.6956 DFramework.Database.Query /* Time Taken: 898*/ DECLARE @AlertDefinition_IsActive Int32 SET @AlertDefinition_IsActive = '1' DECLARE @AlertDefinition_ClientId Int32 SET @AlertDefinition_ClientId = '213' DECLARE @AlertDefinition_AlertTypeId Int32 SET @AlertDefinition_AlertTypeId = '67' DECLARE @AlertDefinition_IsDeleted Int32 SET @AlertDefinition_IsDeleted = '0' DECLARE @AlertDefinition_StartDate Date SET @AlertDefinition_StartDate = '1/12/2026 6:48:29 AM' SELECT TOP 1 AlertDefinitionId, PriorityId FROM AlertDefinition WHERE AlertDefinition.IsActive = @AlertDefinition_IsActive AND AlertDefinition.ClientId = @AlertDefinition_ClientId AND AlertDefinition.AlertTypeId = @AlertDefinition_AlertTypeId AND AlertDefinition.IsDeleted = @AlertDefinition_IsDeleted AND AlertDefinition.StartDate <= @AlertDefinition_StartDate 2026-01-11 22:48:30.7113 DFramework.Database.Query /* Time Taken: 926*/ DECLARE @IsComplete Int32 SET @IsComplete = '0' SELECT TOP 1 ProductMergeTempId, PrimaryProductId, SecondaryProductId, dbo.Product.ClientId, dbo.ProductMergeTemp.UserId, [Product] AS ProductName FROM dbo.ProductMergeTemp INNER JOIN dbo.Product ON dbo.Product.ProductId = dbo.ProductMergeTemp.PrimaryProductId AND dbo.Product.ClientId = dbo.ProductMergeTemp.ClientId AND dbo.Product.IsDeleted = 0 WHERE [IsComplete] = @IsComplete 2026-01-11 22:48:30.7269 DFramework.Database.Query /* Time Taken: 929*/ 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-11 22:48:30.7581 DFramework.Database.Query /* Time Taken: 956*/ 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-11 22:48:30.8050 DFramework.Database.Query /* Time Taken: 1005*/ 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-11 22:48:30.8363 DFramework.Database.Query /* Time Taken: 1034*/ 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-11 22:48:30.9300 DFramework.Database.Query /* Time Taken: 1124*/ DECLARE @CreatedOn Date SET @CreatedOn = '1/12/2026 12:00:00 AM' DECLARE @EventId Int32 SET @EventId = '-12' SELECT COUNT(1) FROM EmailQueue WHERE [CreatedOn] >= @CreatedOn AND [EventId] = @EventId 2026-01-11 22:48:30.9613 DFramework.Database.Query /* Time Taken: 1156*/ 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-11 22:48:30.9613 DFramework.Database.Query /* Time Taken: 953*/ DECLARE @AlertDefinitionId Int32 SET @AlertDefinitionId = '99' DECLARE @IsDeleted Boolean SET @IsDeleted = 'False' SELECT ProductId FROM AlertDefinitionProduct WHERE [AlertDefinitionId] = @AlertDefinitionId AND IsDeleted = @IsDeleted 2026-01-11 22:48:31.0863 DFramework.Database.NullableDataReader Data reader open for 1058 at System.Environment.GetStackTrace(Exception e, Boolean needFileInfo) at System.Environment.get_StackTrace() at DFramework.Database.NullableDataReader.Dispose(Boolean disposing) in C:\CoolR-Group\Framework\DFramework\Database\NullableDataReader.cs:line 33 at DFramework.Database.NullableDataReader.Dispose() in C:\CoolR-Group\Framework\DFramework\Database\NullableDataReader.cs:line 44 at CoolR.Tasks.ProcessOutletAlertData.GetAlertDefinitions() in C:\Program Files (x86)\Go Agent\pipelines\coolr-portal-dev-task-service-new\CoolR.Tasks\OpportunityOutOfStockByOutlet.cs:line 492 at CoolR.Tasks.ProcessOutletAlertData.Execute() in C:\Program Files (x86)\Go Agent\pipelines\coolr-portal-dev-task-service-new\CoolR.Tasks\OpportunityOutOfStockByOutlet.cs:line 72 at DFramework.Scheduler.TaskBase.Run() in D:\Spraxa\Framework\DFramework.Scheduler\TaskBase.cs:line 176 at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx) at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx) at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state) at System.Threading.ThreadHelper.ThreadStart() 2026-01-11 22:48:31.3363 DFramework.Database.Query /* Time Taken: 927*/ DECLARE @AssetKPIData Object SET @AssetKPIData = '' [dbo].BulkUpsertAssetDayKPI 2026-01-11 22:48:31.5863 DFramework.Database.Query /* Time Taken: 502*/ DECLARE @ClientId Int32 SET @ClientId = '213' DECLARE @MarketId Int32 SET @MarketId = '0' DECLARE @ClassificationId Int32 SET @ClassificationId = '0' DECLARE @LocationId Int32 SET @LocationId = '0' DECLARE @LocationTypeId Int32 SET @LocationTypeId = '0' DECLARE @StartDate DateTime2 SET @StartDate = '8/28/2025 12:00:00 AM' dbo.GetOpportunityOutOfStockDataByOutlet 2026-01-11 22:48:31.6644 DFramework.Database.Query /* Time Taken: 1902*/ DECLARE @TableName AnsiString(8000) SET @TableName = 'TagAlert' DECLARE @CurrentRecordId Int32 SET @CurrentRecordId = '0' dbo.GetValidDeviceForAlertProcessData 2026-01-11 22:48:31.7113 DFramework.Database.Query /* Time Taken: 1905*/ [dbo].GenerateSystemAlerts 2026-01-11 22:48:32.1175 DFramework.Database.NullableDataReader Data reader open for 445 at System.Environment.GetStackTrace(Exception e, Boolean needFileInfo) at System.Environment.get_StackTrace() at DFramework.Database.NullableDataReader.Dispose(Boolean disposing) in C:\CoolR-Group\Framework\DFramework\Database\NullableDataReader.cs:line 33 at DFramework.Database.NullableDataReader.Dispose() in C:\CoolR-Group\Framework\DFramework\Database\NullableDataReader.cs:line 44 at CoolR.Tasks.ProcessAlertData.Execute() in C:\Program Files (x86)\Go Agent\pipelines\coolr-portal-dev-task-service-new\CoolR.Tasks\ProcessAlertData.cs:line 48 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-11 22:48:32.9925 DFramework.Database.NullableDataReader Data reader open for 425 at System.Environment.GetStackTrace(Exception e, Boolean needFileInfo) at System.Environment.get_StackTrace() at DFramework.Database.NullableDataReader.Dispose(Boolean disposing) in C:\CoolR-Group\Framework\DFramework\Database\NullableDataReader.cs:line 33 at DFramework.Database.NullableDataReader.Dispose() in C:\CoolR-Group\Framework\DFramework\Database\NullableDataReader.cs:line 44 at CoolR.Tasks.ProcessAlertData.Execute() in C:\Program Files (x86)\Go Agent\pipelines\coolr-portal-dev-task-service-new\CoolR.Tasks\ProcessAlertData.cs:line 48 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-11 22:48:33.3207 DFramework.Database.NullableDataReader Data reader open for 779 at System.Environment.GetStackTrace(Exception e, Boolean needFileInfo) at System.Environment.get_StackTrace() at DFramework.Database.NullableDataReader.Dispose(Boolean disposing) in C:\CoolR-Group\Framework\DFramework\Database\NullableDataReader.cs:line 33 at DFramework.Database.NullableDataReader.Dispose() in C:\CoolR-Group\Framework\DFramework\Database\NullableDataReader.cs:line 44 at CoolR.Tasks.ProcessAlertData.Execute() in C:\Program Files (x86)\Go Agent\pipelines\coolr-portal-dev-task-service-new\CoolR.Tasks\ProcessAlertData.cs:line 48 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-11 22:48:34.1019 DFramework.Database.Query /* Time Taken: 777*/ DECLARE @TableName AnsiString(8000) SET @TableName = 'MissingShelf' DECLARE @CurrentRecordId Int32 SET @CurrentRecordId = '3675964' dbo.GetValidDeviceForAlertProcessData 2026-01-11 22:48:34.4925 DFramework.Database.NullableDataReader Data reader open for 394 at System.Environment.GetStackTrace(Exception e, Boolean needFileInfo) at System.Environment.get_StackTrace() at DFramework.Database.NullableDataReader.Dispose(Boolean disposing) in C:\CoolR-Group\Framework\DFramework\Database\NullableDataReader.cs:line 33 at DFramework.Database.NullableDataReader.Dispose() in C:\CoolR-Group\Framework\DFramework\Database\NullableDataReader.cs:line 44 at CoolR.Tasks.ProcessAlertData.Execute() in C:\Program Files (x86)\Go Agent\pipelines\coolr-portal-dev-task-service-new\CoolR.Tasks\ProcessAlertData.cs:line 48 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-11 22:48:35.2894 DFramework.Database.NullableDataReader Data reader open for 371 at System.Environment.GetStackTrace(Exception e, Boolean needFileInfo) at System.Environment.get_StackTrace() at DFramework.Database.NullableDataReader.Dispose(Boolean disposing) in C:\CoolR-Group\Framework\DFramework\Database\NullableDataReader.cs:line 33 at DFramework.Database.NullableDataReader.Dispose() in C:\CoolR-Group\Framework\DFramework\Database\NullableDataReader.cs:line 44 at CoolR.Tasks.ProcessAlertData.Execute() in C:\Program Files (x86)\Go Agent\pipelines\coolr-portal-dev-task-service-new\CoolR.Tasks\ProcessAlertData.cs:line 48 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-11 22:48:35.8519 DFramework.Database.Query /* Time Taken: 560*/ DECLARE @TableName AnsiString(8000) SET @TableName = 'OpportunityOutOfStock' DECLARE @CurrentRecordId Int32 SET @CurrentRecordId = '3675964' dbo.GetValidDeviceForAlertProcessData 2026-01-11 22:48:36.1332 DFramework.Database.NullableDataReader Data reader open for 240 at System.Environment.GetStackTrace(Exception e, Boolean needFileInfo) at System.Environment.get_StackTrace() at DFramework.Database.NullableDataReader.Dispose(Boolean disposing) in C:\CoolR-Group\Framework\DFramework\Database\NullableDataReader.cs:line 33 at DFramework.Database.NullableDataReader.Dispose() in C:\CoolR-Group\Framework\DFramework\Database\NullableDataReader.cs:line 44 at CoolR.Tasks.ProcessAlertData.Execute() in C:\Program Files (x86)\Go Agent\pipelines\coolr-portal-dev-task-service-new\CoolR.Tasks\ProcessAlertData.cs:line 48 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-11 22:48:36.3676 DFramework.Database.NullableDataReader Data reader open for 204 at System.Environment.GetStackTrace(Exception e, Boolean needFileInfo) at System.Environment.get_StackTrace() at DFramework.Database.NullableDataReader.Dispose(Boolean disposing) in C:\CoolR-Group\Framework\DFramework\Database\NullableDataReader.cs:line 33 at DFramework.Database.NullableDataReader.Dispose() in C:\CoolR-Group\Framework\DFramework\Database\NullableDataReader.cs:line 44 at CoolR.Tasks.ProcessAlertData.Execute() in C:\Program Files (x86)\Go Agent\pipelines\coolr-portal-dev-task-service-new\CoolR.Tasks\ProcessAlertData.cs:line 48 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-11 22:48:36.6176 DFramework.Database.NullableDataReader Data reader open for 227 at System.Environment.GetStackTrace(Exception e, Boolean needFileInfo) at System.Environment.get_StackTrace() at DFramework.Database.NullableDataReader.Dispose(Boolean disposing) in C:\CoolR-Group\Framework\DFramework\Database\NullableDataReader.cs:line 33 at DFramework.Database.NullableDataReader.Dispose() in C:\CoolR-Group\Framework\DFramework\Database\NullableDataReader.cs:line 44 at CoolR.Tasks.ProcessAlertData.Execute() in C:\Program Files (x86)\Go Agent\pipelines\coolr-portal-dev-task-service-new\CoolR.Tasks\ProcessAlertData.cs:line 48 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-11 22:48:36.9301 DFramework.Database.NullableDataReader Data reader open for 231 at System.Environment.GetStackTrace(Exception e, Boolean needFileInfo) at System.Environment.get_StackTrace() at DFramework.Database.NullableDataReader.Dispose(Boolean disposing) in C:\CoolR-Group\Framework\DFramework\Database\NullableDataReader.cs:line 33 at DFramework.Database.NullableDataReader.Dispose() in C:\CoolR-Group\Framework\DFramework\Database\NullableDataReader.cs:line 44 at CoolR.Tasks.ProcessAlertData.Execute() in C:\Program Files (x86)\Go Agent\pipelines\coolr-portal-dev-task-service-new\CoolR.Tasks\ProcessAlertData.cs:line 48 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-11 22:48:37.2269 DFramework.Database.NullableDataReader Data reader open for 257 at System.Environment.GetStackTrace(Exception e, Boolean needFileInfo) at System.Environment.get_StackTrace() at DFramework.Database.NullableDataReader.Dispose(Boolean disposing) in C:\CoolR-Group\Framework\DFramework\Database\NullableDataReader.cs:line 33 at DFramework.Database.NullableDataReader.Dispose() in C:\CoolR-Group\Framework\DFramework\Database\NullableDataReader.cs:line 44 at CoolR.Tasks.ProcessAlertData.Execute() in C:\Program Files (x86)\Go Agent\pipelines\coolr-portal-dev-task-service-new\CoolR.Tasks\ProcessAlertData.cs:line 48 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-11 22:48:37.3051 DFramework.Database.NullableDataReader Data reader open for 1448 at System.Environment.GetStackTrace(Exception e, Boolean needFileInfo) at System.Environment.get_StackTrace() at DFramework.Database.NullableDataReader.Dispose(Boolean disposing) in C:\CoolR-Group\Framework\DFramework\Database\NullableDataReader.cs:line 33 at DFramework.Database.NullableDataReader.Dispose() in C:\CoolR-Group\Framework\DFramework\Database\NullableDataReader.cs:line 44 at CoolR.Tasks.ProcessAlertData.Execute() in C:\Program Files (x86)\Go Agent\pipelines\coolr-portal-dev-task-service-new\CoolR.Tasks\ProcessAlertData.cs:line 48 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-11 22:48:38.5863 DFramework.Database.NullableDataReader Data reader open for 283 at System.Environment.GetStackTrace(Exception e, Boolean needFileInfo) at System.Environment.get_StackTrace() at DFramework.Database.NullableDataReader.Dispose(Boolean disposing) in C:\CoolR-Group\Framework\DFramework\Database\NullableDataReader.cs:line 33 at DFramework.Database.NullableDataReader.Dispose() in C:\CoolR-Group\Framework\DFramework\Database\NullableDataReader.cs:line 44 at CoolR.Tasks.ProcessAlertData.Execute() in C:\Program Files (x86)\Go Agent\pipelines\coolr-portal-dev-task-service-new\CoolR.Tasks\ProcessAlertData.cs:line 48 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-11 22:48:38.6644 DFramework.Database.NullableDataReader Data reader open for 992 at System.Environment.GetStackTrace(Exception e, Boolean needFileInfo) at System.Environment.get_StackTrace() at DFramework.Database.NullableDataReader.Dispose(Boolean disposing) in C:\CoolR-Group\Framework\DFramework\Database\NullableDataReader.cs:line 33 at DFramework.Database.NullableDataReader.Dispose() in C:\CoolR-Group\Framework\DFramework\Database\NullableDataReader.cs:line 44 at CoolR.Tasks.ProcessAlertData.Execute() in C:\Program Files (x86)\Go Agent\pipelines\coolr-portal-dev-task-service-new\CoolR.Tasks\ProcessAlertData.cs:line 48 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-11 22:48:39.7426 DFramework.Database.NullableDataReader Data reader open for 333 at System.Environment.GetStackTrace(Exception e, Boolean needFileInfo) at System.Environment.get_StackTrace() at DFramework.Database.NullableDataReader.Dispose(Boolean disposing) in C:\CoolR-Group\Framework\DFramework\Database\NullableDataReader.cs:line 33 at DFramework.Database.NullableDataReader.Dispose() in C:\CoolR-Group\Framework\DFramework\Database\NullableDataReader.cs:line 44 at CoolR.Tasks.ProcessAlertData.Execute() in C:\Program Files (x86)\Go Agent\pipelines\coolr-portal-dev-task-service-new\CoolR.Tasks\ProcessAlertData.cs:line 48 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-11 22:48:39.8207 DFramework.Database.NullableDataReader Data reader open for 793 at System.Environment.GetStackTrace(Exception e, Boolean needFileInfo) at System.Environment.get_StackTrace() at DFramework.Database.NullableDataReader.Dispose(Boolean disposing) in C:\CoolR-Group\Framework\DFramework\Database\NullableDataReader.cs:line 33 at DFramework.Database.NullableDataReader.Dispose() in C:\CoolR-Group\Framework\DFramework\Database\NullableDataReader.cs:line 44 at CoolR.Tasks.ProcessAlertData.Execute() in C:\Program Files (x86)\Go Agent\pipelines\coolr-portal-dev-task-service-new\CoolR.Tasks\ProcessAlertData.cs:line 48 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-11 22:48:40.9145 DFramework.Database.Query /* Time Taken: 1084*/ DECLARE @TableName AnsiString(8000) SET @TableName = 'AssetStockProductWiseConsolidate' DECLARE @CurrentRecordId Int32 SET @CurrentRecordId = '3675964' dbo.GetValidDeviceForAlertProcessData 2026-01-11 22:48:46.9614 DFramework.Scheduler.TaskBase /* Time Taken: 17500.1332*/ Opportunity Out Of Stock By Outlet 2026-01-11 22:54:28.3546 DFramework.Database.NullableDataReader Data reader open for 346819 at System.Environment.GetStackTrace(Exception e, Boolean needFileInfo) at System.Environment.get_StackTrace() at DFramework.Database.NullableDataReader.Dispose(Boolean disposing) in C:\CoolR-Group\Framework\DFramework\Database\NullableDataReader.cs:line 33 at DFramework.Database.NullableDataReader.Dispose() in C:\CoolR-Group\Framework\DFramework\Database\NullableDataReader.cs:line 44 at CoolR.Tasks.ProcessAlertData.Execute() in C:\Program Files (x86)\Go Agent\pipelines\coolr-portal-dev-task-service-new\CoolR.Tasks\ProcessAlertData.cs:line 343 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-11 22:54:28.3546 DFramework.Database.NullableDataReader Data reader open for 346905 at System.Environment.GetStackTrace(Exception e, Boolean needFileInfo) at System.Environment.get_StackTrace() at DFramework.Database.NullableDataReader.Dispose(Boolean disposing) in C:\CoolR-Group\Framework\DFramework\Database\NullableDataReader.cs:line 33 at DFramework.Database.NullableDataReader.Dispose() in C:\CoolR-Group\Framework\DFramework\Database\NullableDataReader.cs:line 44 at CoolR.Tasks.ProcessAlertData.Execute() in C:\Program Files (x86)\Go Agent\pipelines\coolr-portal-dev-task-service-new\CoolR.Tasks\ProcessAlertData.cs:line 343 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-11 22:54:28.5890 DFramework.Scheduler.TaskBase /* Time Taken: 359143.3587*/ Process Alert Record 2026-01-11 22:54:40.0266 AlertProcessor ProcessorAlertData: started 2026-01-11 22:54:40.6985 DFramework.Database.Query /* Time Taken: 632*/ DECLARE @TableName AnsiString(8000) SET @TableName = 'TagAlert' DECLARE @CurrentRecordId Int32 SET @CurrentRecordId = '0' dbo.GetValidDeviceForAlertProcessData 2026-01-11 22:54:40.7141 DFramework.Database.Query /* Time Taken: 644*/ DECLARE @IsComplete Int32 SET @IsComplete = '0' SELECT TOP 1 ProductMergeTempId, PrimaryProductId, SecondaryProductId, dbo.Product.ClientId, dbo.ProductMergeTemp.UserId, [Product] AS ProductName FROM dbo.ProductMergeTemp INNER JOIN dbo.Product ON dbo.Product.ProductId = dbo.ProductMergeTemp.PrimaryProductId AND dbo.Product.ClientId = dbo.ProductMergeTemp.ClientId AND dbo.Product.IsDeleted = 0 WHERE [IsComplete] = @IsComplete 2026-01-11 22:54:40.8078 DFramework.Database.Query /* Time Taken: 734*/ 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 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-11 22:54:40.8391 DFramework.Database.Query /* Time Taken: 761*/ DECLARE @CreatedOn Date SET @CreatedOn = '1/12/2026 12:00:00 AM' DECLARE @EventId Int32 SET @EventId = '-12' SELECT COUNT(1) FROM EmailQueue WHERE [CreatedOn] >= @CreatedOn AND [EventId] = @EventId 2026-01-11 22:54:40.8703 DFramework.Database.Query /* Time Taken: 789*/ DECLARE @AlertDefinition_IsActive Int32 SET @AlertDefinition_IsActive = '1' DECLARE @AlertDefinition_ClientId Int32 SET @AlertDefinition_ClientId = '213' DECLARE @AlertDefinition_AlertTypeId Int32 SET @AlertDefinition_AlertTypeId = '67' DECLARE @AlertDefinition_IsDeleted Int32 SET @AlertDefinition_IsDeleted = '0' DECLARE @AlertDefinition_StartDate Date SET @AlertDefinition_StartDate = '1/12/2026 6:54:40 AM' SELECT TOP 1 AlertDefinitionId, PriorityId FROM AlertDefinition WHERE AlertDefinition.IsActive = @AlertDefinition_IsActive AND AlertDefinition.ClientId = @AlertDefinition_ClientId AND AlertDefinition.AlertTypeId = @AlertDefinition_AlertTypeId AND AlertDefinition.IsDeleted = @AlertDefinition_IsDeleted AND AlertDefinition.StartDate <= @AlertDefinition_StartDate 2026-01-11 22:54:40.9328 DFramework.Database.Query /* Time Taken: 866*/ DECLARE @IsActive Int32 SET @IsActive = '1' DECLARE @FtpTypeId Int32 SET @FtpTypeId = '7766' DECLARE @ClientId Int32 SET @ClientId = '213' Select * from vwFTPClientList WHERE [IsActive] = @IsActive AND [FtpTypeId] = @FtpTypeId AND [ClientId] = @ClientId ORDER BY [ClientFtpId] 2026-01-11 22:54:40.9797 DFramework.Database.Query /* Time Taken: 889*/ 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-11 22:54:41.0266 DFramework.Database.Query /* Time Taken: 937*/ 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-11 22:54:41.0422 DFramework.Database.Query /* Time Taken: 964*/ 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-11 22:54:41.0735 DFramework.Database.Query /* Time Taken: 992*/ 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-11 22:54:41.1516 DFramework.Database.Query /* Time Taken: 941*/ DECLARE @AlertDefinitionId Int32 SET @AlertDefinitionId = '99' DECLARE @IsDeleted Boolean SET @IsDeleted = 'False' SELECT ProductId FROM AlertDefinitionProduct WHERE [AlertDefinitionId] = @AlertDefinitionId AND IsDeleted = @IsDeleted 2026-01-11 22:54:41.1672 DFramework.Database.Query /* Time Taken: 1088*/ 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-11 22:54:41.4016 DFramework.Database.Query /* Time Taken: 1331*/ [dbo].GenerateSystemAlerts 2026-01-11 22:54:41.4329 DFramework.Database.Query /* Time Taken: 857*/ DECLARE @AssetKPIData Object SET @AssetKPIData = '' [dbo].BulkUpsertAssetDayKPI 2026-01-11 22:54:41.5422 DFramework.Database.NullableDataReader Data reader open for 335 at System.Environment.GetStackTrace(Exception e, Boolean needFileInfo) at System.Environment.get_StackTrace() at DFramework.Database.NullableDataReader.Dispose(Boolean disposing) in C:\CoolR-Group\Framework\DFramework\Database\NullableDataReader.cs:line 33 at DFramework.Database.NullableDataReader.Dispose() in C:\CoolR-Group\Framework\DFramework\Database\NullableDataReader.cs:line 44 at CoolR.Tasks.ProcessAlertData.Execute() in C:\Program Files (x86)\Go Agent\pipelines\coolr-portal-dev-task-service-new\CoolR.Tasks\ProcessAlertData.cs:line 48 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-11 22:54:41.6672 DFramework.Database.NullableDataReader Data reader open for 1483 at System.Environment.GetStackTrace(Exception e, Boolean needFileInfo) at System.Environment.get_StackTrace() at DFramework.Database.NullableDataReader.Dispose(Boolean disposing) in C:\CoolR-Group\Framework\DFramework\Database\NullableDataReader.cs:line 33 at DFramework.Database.NullableDataReader.Dispose() in C:\CoolR-Group\Framework\DFramework\Database\NullableDataReader.cs:line 44 at CoolR.Tasks.ProcessOutletAlertData.GetAlertDefinitions() in C:\Program Files (x86)\Go Agent\pipelines\coolr-portal-dev-task-service-new\CoolR.Tasks\OpportunityOutOfStockByOutlet.cs:line 492 at CoolR.Tasks.ProcessOutletAlertData.Execute() in C:\Program Files (x86)\Go Agent\pipelines\coolr-portal-dev-task-service-new\CoolR.Tasks\OpportunityOutOfStockByOutlet.cs:line 72 at DFramework.Scheduler.TaskBase.Run() in D:\Spraxa\Framework\DFramework.Scheduler\TaskBase.cs:line 176 at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx) at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx) at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state) at System.Threading.ThreadHelper.ThreadStart() 2026-01-11 22:54:41.8547 DFramework.Database.NullableDataReader Data reader open for 1160 at System.Environment.GetStackTrace(Exception e, Boolean needFileInfo) at System.Environment.get_StackTrace() at DFramework.Database.NullableDataReader.Dispose(Boolean disposing) in C:\CoolR-Group\Framework\DFramework\Database\NullableDataReader.cs:line 33 at DFramework.Database.NullableDataReader.Dispose() in C:\CoolR-Group\Framework\DFramework\Database\NullableDataReader.cs:line 44 at CoolR.Tasks.ProcessAlertData.Execute() in C:\Program Files (x86)\Go Agent\pipelines\coolr-portal-dev-task-service-new\CoolR.Tasks\ProcessAlertData.cs:line 48 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-11 22:54:42.6047 DFramework.Database.NullableDataReader Data reader open for 393 at System.Environment.GetStackTrace(Exception e, Boolean needFileInfo) at System.Environment.get_StackTrace() at DFramework.Database.NullableDataReader.Dispose(Boolean disposing) in C:\CoolR-Group\Framework\DFramework\Database\NullableDataReader.cs:line 33 at DFramework.Database.NullableDataReader.Dispose() in C:\CoolR-Group\Framework\DFramework\Database\NullableDataReader.cs:line 44 at CoolR.Tasks.ProcessAlertData.Execute() in C:\Program Files (x86)\Go Agent\pipelines\coolr-portal-dev-task-service-new\CoolR.Tasks\ProcessAlertData.cs:line 48 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-11 22:54:42.9329 DFramework.Database.NullableDataReader Data reader open for 754 at System.Environment.GetStackTrace(Exception e, Boolean needFileInfo) at System.Environment.get_StackTrace() at DFramework.Database.NullableDataReader.Dispose(Boolean disposing) in C:\CoolR-Group\Framework\DFramework\Database\NullableDataReader.cs:line 33 at DFramework.Database.NullableDataReader.Dispose() in C:\CoolR-Group\Framework\DFramework\Database\NullableDataReader.cs:line 44 at CoolR.Tasks.ProcessAlertData.Execute() in C:\Program Files (x86)\Go Agent\pipelines\coolr-portal-dev-task-service-new\CoolR.Tasks\ProcessAlertData.cs:line 48 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-11 22:54:43.7454 DFramework.Database.NullableDataReader Data reader open for 387 at System.Environment.GetStackTrace(Exception e, Boolean needFileInfo) at System.Environment.get_StackTrace() at DFramework.Database.NullableDataReader.Dispose(Boolean disposing) in C:\CoolR-Group\Framework\DFramework\Database\NullableDataReader.cs:line 33 at DFramework.Database.NullableDataReader.Dispose() in C:\CoolR-Group\Framework\DFramework\Database\NullableDataReader.cs:line 44 at CoolR.Tasks.ProcessAlertData.Execute() in C:\Program Files (x86)\Go Agent\pipelines\coolr-portal-dev-task-service-new\CoolR.Tasks\ProcessAlertData.cs:line 48 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-11 22:54:44.5110 DFramework.Database.NullableDataReader Data reader open for 360 at System.Environment.GetStackTrace(Exception e, Boolean needFileInfo) at System.Environment.get_StackTrace() at DFramework.Database.NullableDataReader.Dispose(Boolean disposing) in C:\CoolR-Group\Framework\DFramework\Database\NullableDataReader.cs:line 33 at DFramework.Database.NullableDataReader.Dispose() in C:\CoolR-Group\Framework\DFramework\Database\NullableDataReader.cs:line 44 at CoolR.Tasks.ProcessAlertData.Execute() in C:\Program Files (x86)\Go Agent\pipelines\coolr-portal-dev-task-service-new\CoolR.Tasks\ProcessAlertData.cs:line 48 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-11 22:54:45.1047 DFramework.Database.NullableDataReader Data reader open for 210 at System.Environment.GetStackTrace(Exception e, Boolean needFileInfo) at System.Environment.get_StackTrace() at DFramework.Database.NullableDataReader.Dispose(Boolean disposing) in C:\CoolR-Group\Framework\DFramework\Database\NullableDataReader.cs:line 33 at DFramework.Database.NullableDataReader.Dispose() in C:\CoolR-Group\Framework\DFramework\Database\NullableDataReader.cs:line 44 at CoolR.Tasks.ProcessAlertData.Execute() in C:\Program Files (x86)\Go Agent\pipelines\coolr-portal-dev-task-service-new\CoolR.Tasks\ProcessAlertData.cs:line 48 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-11 22:54:45.3391 DFramework.Database.NullableDataReader Data reader open for 202 at System.Environment.GetStackTrace(Exception e, Boolean needFileInfo) at System.Environment.get_StackTrace() at DFramework.Database.NullableDataReader.Dispose(Boolean disposing) in C:\CoolR-Group\Framework\DFramework\Database\NullableDataReader.cs:line 33 at DFramework.Database.NullableDataReader.Dispose() in C:\CoolR-Group\Framework\DFramework\Database\NullableDataReader.cs:line 44 at CoolR.Tasks.ProcessAlertData.Execute() in C:\Program Files (x86)\Go Agent\pipelines\coolr-portal-dev-task-service-new\CoolR.Tasks\ProcessAlertData.cs:line 48 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-11 22:54:45.5579 DFramework.Database.NullableDataReader Data reader open for 202 at System.Environment.GetStackTrace(Exception e, Boolean needFileInfo) at System.Environment.get_StackTrace() at DFramework.Database.NullableDataReader.Dispose(Boolean disposing) in C:\CoolR-Group\Framework\DFramework\Database\NullableDataReader.cs:line 33 at DFramework.Database.NullableDataReader.Dispose() in C:\CoolR-Group\Framework\DFramework\Database\NullableDataReader.cs:line 44 at CoolR.Tasks.ProcessAlertData.Execute() in C:\Program Files (x86)\Go Agent\pipelines\coolr-portal-dev-task-service-new\CoolR.Tasks\ProcessAlertData.cs:line 48 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-11 22:54:45.8547 DFramework.Database.NullableDataReader Data reader open for 201 at System.Environment.GetStackTrace(Exception e, Boolean needFileInfo) at System.Environment.get_StackTrace() at DFramework.Database.NullableDataReader.Dispose(Boolean disposing) in C:\CoolR-Group\Framework\DFramework\Database\NullableDataReader.cs:line 33 at DFramework.Database.NullableDataReader.Dispose() in C:\CoolR-Group\Framework\DFramework\Database\NullableDataReader.cs:line 44 at CoolR.Tasks.ProcessAlertData.Execute() in C:\Program Files (x86)\Go Agent\pipelines\coolr-portal-dev-task-service-new\CoolR.Tasks\ProcessAlertData.cs:line 48 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-11 22:54:46.1047 DFramework.Database.NullableDataReader Data reader open for 231 at System.Environment.GetStackTrace(Exception e, Boolean needFileInfo) at System.Environment.get_StackTrace() at DFramework.Database.NullableDataReader.Dispose(Boolean disposing) in C:\CoolR-Group\Framework\DFramework\Database\NullableDataReader.cs:line 33 at DFramework.Database.NullableDataReader.Dispose() in C:\CoolR-Group\Framework\DFramework\Database\NullableDataReader.cs:line 44 at CoolR.Tasks.ProcessAlertData.Execute() in C:\Program Files (x86)\Go Agent\pipelines\coolr-portal-dev-task-service-new\CoolR.Tasks\ProcessAlertData.cs:line 48 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-11 22:54:46.1985 DFramework.Database.NullableDataReader Data reader open for 1334 at System.Environment.GetStackTrace(Exception e, Boolean needFileInfo) at System.Environment.get_StackTrace() at DFramework.Database.NullableDataReader.Dispose(Boolean disposing) in C:\CoolR-Group\Framework\DFramework\Database\NullableDataReader.cs:line 33 at DFramework.Database.NullableDataReader.Dispose() in C:\CoolR-Group\Framework\DFramework\Database\NullableDataReader.cs:line 44 at CoolR.Tasks.ProcessAlertData.Execute() in C:\Program Files (x86)\Go Agent\pipelines\coolr-portal-dev-task-service-new\CoolR.Tasks\ProcessAlertData.cs:line 48 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-11 22:54:46.7454 DFramework.Database.Query /* Time Taken: 546*/ DECLARE @TableName AnsiString(8000) SET @TableName = 'PlanogramComplianceConsolidate' DECLARE @CurrentRecordId Int32 SET @CurrentRecordId = '3675964' dbo.GetValidDeviceForAlertProcessData 2026-01-11 22:54:47.6204 DFramework.Database.NullableDataReader Data reader open for 277 at System.Environment.GetStackTrace(Exception e, Boolean needFileInfo) at System.Environment.get_StackTrace() at DFramework.Database.NullableDataReader.Dispose(Boolean disposing) in C:\CoolR-Group\Framework\DFramework\Database\NullableDataReader.cs:line 33 at DFramework.Database.NullableDataReader.Dispose() in C:\CoolR-Group\Framework\DFramework\Database\NullableDataReader.cs:line 44 at CoolR.Tasks.ProcessAlertData.Execute() in C:\Program Files (x86)\Go Agent\pipelines\coolr-portal-dev-task-service-new\CoolR.Tasks\ProcessAlertData.cs:line 48 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-11 22:54:47.6985 DFramework.Database.NullableDataReader Data reader open for 956 at System.Environment.GetStackTrace(Exception e, Boolean needFileInfo) at System.Environment.get_StackTrace() at DFramework.Database.NullableDataReader.Dispose(Boolean disposing) in C:\CoolR-Group\Framework\DFramework\Database\NullableDataReader.cs:line 33 at DFramework.Database.NullableDataReader.Dispose() in C:\CoolR-Group\Framework\DFramework\Database\NullableDataReader.cs:line 44 at CoolR.Tasks.ProcessAlertData.Execute() in C:\Program Files (x86)\Go Agent\pipelines\coolr-portal-dev-task-service-new\CoolR.Tasks\ProcessAlertData.cs:line 48 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-11 22:54:48.6985 DFramework.Database.NullableDataReader Data reader open for 301 at System.Environment.GetStackTrace(Exception e, Boolean needFileInfo) at System.Environment.get_StackTrace() at DFramework.Database.NullableDataReader.Dispose(Boolean disposing) in C:\CoolR-Group\Framework\DFramework\Database\NullableDataReader.cs:line 33 at DFramework.Database.NullableDataReader.Dispose() in C:\CoolR-Group\Framework\DFramework\Database\NullableDataReader.cs:line 44 at CoolR.Tasks.ProcessAlertData.Execute() in C:\Program Files (x86)\Go Agent\pipelines\coolr-portal-dev-task-service-new\CoolR.Tasks\ProcessAlertData.cs:line 48 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-11 22:54:48.7766 DFramework.Database.NullableDataReader Data reader open for 754 at System.Environment.GetStackTrace(Exception e, Boolean needFileInfo) at System.Environment.get_StackTrace() at DFramework.Database.NullableDataReader.Dispose(Boolean disposing) in C:\CoolR-Group\Framework\DFramework\Database\NullableDataReader.cs:line 33 at DFramework.Database.NullableDataReader.Dispose() in C:\CoolR-Group\Framework\DFramework\Database\NullableDataReader.cs:line 44 at CoolR.Tasks.ProcessAlertData.Execute() in C:\Program Files (x86)\Go Agent\pipelines\coolr-portal-dev-task-service-new\CoolR.Tasks\ProcessAlertData.cs:line 48 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-11 22:54:49.4173 DFramework.Database.Query /* Time Taken: 640*/ DECLARE @TableName AnsiString(8000) SET @TableName = 'AssetStockProductWiseConsolidate' DECLARE @CurrentRecordId Int32 SET @CurrentRecordId = '3675964' dbo.GetValidDeviceForAlertProcessData 2026-01-11 22:54:57.1986 DFramework.Scheduler.TaskBase /* Time Taken: 17468.8893*/ Opportunity Out Of Stock By Outlet 2026-01-11 23:09:40.6272 DFramework.Database.Query /* Time Taken: 558*/ [dbo].GenerateSystemAlerts 2026-01-11 23:09:55.3148 DFramework.Scheduler.TaskBase /* Time Taken: 15562.6189*/ Opportunity Out Of Stock By Outlet 2026-01-11 23:24:40.8840 DFramework.Database.Query /* Time Taken: 798*/ [dbo].GenerateSystemAlerts 2026-01-11 23:24:55.3373 DFramework.Scheduler.TaskBase /* Time Taken: 15562.6178*/ Opportunity Out Of Stock By Outlet 2026-01-11 23:39:40.6565 DFramework.Database.Query /* Time Taken: 564*/ [dbo].GenerateSystemAlerts 2026-01-11 23:39:55.3598 DFramework.Scheduler.TaskBase /* Time Taken: 15562.6175*/ Opportunity Out Of Stock By Outlet 2026-01-11 23:54:40.7102 DFramework.Database.Query /* Time Taken: 611*/ [dbo].GenerateSystemAlerts 2026-01-11 23:54:55.3666 DFramework.Scheduler.TaskBase /* Time Taken: 15562.6151*/ Opportunity Out Of Stock By Outlet