2025-12-28 00:04:44.9111 AlertProcessor ProcessorAlertData: started 2025-12-28 00:04:50.5205 AlertProcessor ProcessorAlertData: Stopped 2025-12-28 00:09:44.9133 AlertProcessor ProcessorAlertData: started 2025-12-28 00:09:50.4915 AlertProcessor ProcessorAlertData: Stopped 2025-12-28 00:09:56.4603 DFramework.Scheduler.TaskBase /* Time Taken: 15734.4958*/ Opportunity Out Of Stock By Outlet 2025-12-28 00:14:44.9311 AlertProcessor ProcessorAlertData: started 2025-12-28 00:14:50.5249 AlertProcessor ProcessorAlertData: Stopped 2025-12-28 00:19:44.9490 AlertProcessor ProcessorAlertData: started 2025-12-28 00:19:50.5271 AlertProcessor ProcessorAlertData: Stopped 2025-12-28 00:24:44.9668 AlertProcessor ProcessorAlertData: started 2025-12-28 00:24:50.5450 AlertProcessor ProcessorAlertData: Stopped 2025-12-28 00:24:56.4982 DFramework.Scheduler.TaskBase /* Time Taken: 15750.1202*/ Opportunity Out Of Stock By Outlet 2025-12-28 00:29:44.9691 AlertProcessor ProcessorAlertData: started 2025-12-28 00:29:50.5160 AlertProcessor ProcessorAlertData: Stopped 2025-12-28 00:34:44.9713 AlertProcessor ProcessorAlertData: started 2025-12-28 00:34:48.0026 DFramework.Database.Query /* Time Taken: 537*/ DECLARE @TableName AnsiString(8000) SET @TableName = 'AssetStockProductWiseConsolidate' DECLARE @CurrentRecordId Int32 SET @CurrentRecordId = '3675192' dbo.GetValidDeviceForAlertProcessData 2025-12-28 00:34:50.5651 AlertProcessor ProcessorAlertData: Stopped 2025-12-28 00:39:44.9735 AlertProcessor ProcessorAlertData: started 2025-12-28 00:39:50.5048 AlertProcessor ProcessorAlertData: Stopped 2025-12-28 00:39:56.4892 DFramework.Scheduler.TaskBase /* Time Taken: 15718.8647*/ Opportunity Out Of Stock By Outlet 2025-12-28 00:44:44.9914 AlertProcessor ProcessorAlertData: started 2025-12-28 00:44:50.5852 AlertProcessor ProcessorAlertData: Stopped 2025-12-28 00:49:45.0093 AlertProcessor ProcessorAlertData: started 2025-12-28 00:49:50.6656 AlertProcessor ProcessorAlertData: Stopped 2025-12-28 00:54:45.0272 AlertProcessor ProcessorAlertData: started 2025-12-28 00:54:47.5584 DFramework.Database.NullableDataReader Data reader open for 282 at System.Environment.GetStackTrace(Exception e, Boolean needFileInfo) at System.Environment.get_StackTrace() at DFramework.Database.NullableDataReader.Dispose(Boolean disposing) in D:\Spraxa\Framework\DFramework\Database\NullableDataReader.cs:line 33 at DFramework.Database.NullableDataReader.Dispose() in D:\Spraxa\Framework\DFramework\Database\NullableDataReader.cs:line 44 at CoolR.Tasks.ProcessAlertData.Execute() in D:\Spraxa\CoolR-Group\portal\CoolR.Tasks\ProcessAlertData.cs:line 47 at DFramework.Scheduler.TaskBase.Run() in D:\Spraxa\Framework\DFramework.Scheduler\TaskBase.cs:line 176 at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx) at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx) at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state) at System.Threading.ThreadHelper.ThreadStart() 2025-12-28 00:54:50.9022 AlertProcessor ProcessorAlertData: Stopped 2025-12-28 00:54:56.5429 DFramework.Scheduler.TaskBase /* Time Taken: 15750.117*/ Opportunity Out Of Stock By Outlet 2025-12-28 00:59:45.0450 AlertProcessor ProcessorAlertData: started 2025-12-28 00:59:50.5919 AlertProcessor ProcessorAlertData: Stopped 2025-12-28 01:04:45.0629 AlertProcessor ProcessorAlertData: started 2025-12-28 01:04:50.7191 AlertProcessor ProcessorAlertData: Stopped 2025-12-28 01:09:45.0807 AlertProcessor ProcessorAlertData: started 2025-12-28 01:09:50.6901 AlertProcessor ProcessorAlertData: Stopped 2025-12-28 01:09:56.5808 DFramework.Scheduler.TaskBase /* Time Taken: 15765.7397*/ Opportunity Out Of Stock By Outlet 2025-12-28 01:14:45.0985 AlertProcessor ProcessorAlertData: started 2025-12-28 01:14:50.5986 AlertProcessor ProcessorAlertData: Stopped 2025-12-28 01:19:45.1164 AlertProcessor ProcessorAlertData: started 2025-12-28 01:19:50.6477 AlertProcessor ProcessorAlertData: Stopped 2025-12-28 01:24:45.1343 AlertProcessor ProcessorAlertData: started 2025-12-28 01:24:50.6812 AlertProcessor ProcessorAlertData: Stopped 2025-12-28 01:24:56.6187 DFramework.Scheduler.TaskBase /* Time Taken: 15781.37*/ Opportunity Out Of Stock By Outlet 2025-12-28 01:29:45.1521 AlertProcessor ProcessorAlertData: started 2025-12-28 01:29:50.7459 AlertProcessor ProcessorAlertData: Stopped 2025-12-28 01:34:45.1700 AlertProcessor ProcessorAlertData: started 2025-12-28 01:34:50.7481 AlertProcessor ProcessorAlertData: Stopped 2025-12-28 01:39:45.1878 AlertProcessor ProcessorAlertData: started 2025-12-28 01:39:50.8285 AlertProcessor ProcessorAlertData: Stopped 2025-12-28 01:39:56.6723 DFramework.Scheduler.TaskBase /* Time Taken: 15812.6166*/ Opportunity Out Of Stock By Outlet 2025-12-28 01:44:45.2057 AlertProcessor ProcessorAlertData: started 2025-12-28 01:44:50.7838 AlertProcessor ProcessorAlertData: Stopped 2025-12-28 01:49:45.2235 AlertProcessor ProcessorAlertData: started 2025-12-28 01:49:50.5517 AlertProcessor ProcessorAlertData: Stopped 2025-12-28 01:54:45.2414 AlertProcessor ProcessorAlertData: started 2025-12-28 01:54:47.4445 DFramework.Database.NullableDataReader Data reader open for 276 at System.Environment.GetStackTrace(Exception e, Boolean needFileInfo) at System.Environment.get_StackTrace() at DFramework.Database.NullableDataReader.Dispose(Boolean disposing) in D:\Spraxa\Framework\DFramework\Database\NullableDataReader.cs:line 33 at DFramework.Database.NullableDataReader.Dispose() in D:\Spraxa\Framework\DFramework\Database\NullableDataReader.cs:line 44 at CoolR.Tasks.ProcessAlertData.Execute() in D:\Spraxa\CoolR-Group\portal\CoolR.Tasks\ProcessAlertData.cs:line 47 at DFramework.Scheduler.TaskBase.Run() in D:\Spraxa\Framework\DFramework.Scheduler\TaskBase.cs:line 176 at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx) at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx) at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state) at System.Threading.ThreadHelper.ThreadStart() 2025-12-28 01:54:51.0383 AlertProcessor ProcessorAlertData: Stopped 2025-12-28 01:54:56.6789 DFramework.Scheduler.TaskBase /* Time Taken: 15796.9893*/ Opportunity Out Of Stock By Outlet 2025-12-28 01:59:45.2592 AlertProcessor ProcessorAlertData: started 2025-12-28 01:59:50.7749 AlertProcessor ProcessorAlertData: Stopped 2025-12-28 02:04:45.2770 AlertProcessor ProcessorAlertData: started 2025-12-28 02:04:50.9177 AlertProcessor ProcessorAlertData: Stopped 2025-12-28 02:09:45.2950 AlertProcessor ProcessorAlertData: started 2025-12-28 02:09:50.9669 AlertProcessor ProcessorAlertData: Stopped 2025-12-28 02:09:56.6857 DFramework.Scheduler.TaskBase /* Time Taken: 15781.3722*/ Opportunity Out Of Stock By Outlet 2025-12-28 02:14:45.2972 AlertProcessor ProcessorAlertData: started 2025-12-28 02:14:50.9066 AlertProcessor ProcessorAlertData: Stopped 2025-12-28 02:19:45.2995 AlertProcessor ProcessorAlertData: started 2025-12-28 02:19:50.8776 AlertProcessor ProcessorAlertData: Stopped 2025-12-28 02:24:45.3017 AlertProcessor ProcessorAlertData: started 2025-12-28 02:24:50.9111 AlertProcessor ProcessorAlertData: Stopped 2025-12-28 02:24:56.7237 DFramework.Scheduler.TaskBase /* Time Taken: 15796.9931*/ Opportunity Out Of Stock By Outlet 2025-12-28 02:29:45.3039 AlertProcessor ProcessorAlertData: started 2025-12-28 02:29:50.8665 AlertProcessor ProcessorAlertData: Stopped 2025-12-28 02:34:45.3218 AlertProcessor ProcessorAlertData: started 2025-12-28 02:34:50.8843 AlertProcessor ProcessorAlertData: Stopped 2025-12-28 02:39:45.3396 AlertProcessor ProcessorAlertData: started 2025-12-28 02:39:50.9491 AlertProcessor ProcessorAlertData: Stopped 2025-12-28 02:39:56.7616 DFramework.Scheduler.TaskBase /* Time Taken: 15812.6346*/ Opportunity Out Of Stock By Outlet 2025-12-28 02:44:45.3575 AlertProcessor ProcessorAlertData: started 2025-12-28 02:44:50.8888 AlertProcessor ProcessorAlertData: Stopped 2025-12-28 02:49:45.3597 AlertProcessor ProcessorAlertData: started 2025-12-28 02:49:50.7191 AlertProcessor ProcessorAlertData: Stopped 2025-12-28 02:54:45.3775 AlertProcessor ProcessorAlertData: started 2025-12-28 02:54:50.5963 AlertProcessor ProcessorAlertData: Stopped 2025-12-28 02:54:56.7526 DFramework.Scheduler.TaskBase /* Time Taken: 15781.3664*/ Opportunity Out Of Stock By Outlet 2025-12-28 02:59:45.3954 AlertProcessor ProcessorAlertData: started 2025-12-28 02:59:50.8329 AlertProcessor ProcessorAlertData: Stopped 2025-12-28 03:04:45.4132 AlertProcessor ProcessorAlertData: started 2025-12-28 03:04:51.1164 AlertProcessor ProcessorAlertData: Stopped 2025-12-28 03:09:45.4311 AlertProcessor ProcessorAlertData: started 2025-12-28 03:09:50.8217 AlertProcessor ProcessorAlertData: Stopped 2025-12-28 03:09:56.7749 DFramework.Scheduler.TaskBase /* Time Taken: 15781.3665*/ Opportunity Out Of Stock By Outlet 2025-12-28 03:14:45.4489 AlertProcessor ProcessorAlertData: started 2025-12-28 03:14:50.8708 AlertProcessor ProcessorAlertData: Stopped 2025-12-28 03:19:45.4511 AlertProcessor ProcessorAlertData: started 2025-12-28 03:19:50.9356 AlertProcessor ProcessorAlertData: Stopped 2025-12-28 03:24:45.4690 AlertProcessor ProcessorAlertData: started 2025-12-28 03:24:50.7659 AlertProcessor ProcessorAlertData: Stopped 2025-12-28 03:24:56.7972 DFramework.Scheduler.TaskBase /* Time Taken: 15781.364*/ Opportunity Out Of Stock By Outlet 2025-12-28 03:29:45.4868 AlertProcessor ProcessorAlertData: started 2025-12-28 03:29:50.9087 AlertProcessor ProcessorAlertData: Stopped 2025-12-28 03:34:45.5048 AlertProcessor ProcessorAlertData: started 2025-12-28 03:34:51.1611 AlertProcessor ProcessorAlertData: Stopped 2025-12-28 03:39:45.5071 AlertProcessor ProcessorAlertData: started 2025-12-28 03:39:50.8977 AlertProcessor ProcessorAlertData: Stopped 2025-12-28 03:39:56.8353 DFramework.Scheduler.TaskBase /* Time Taken: 15796.9941*/ Opportunity Out Of Stock By Outlet 2025-12-28 03:44:45.5249 AlertProcessor ProcessorAlertData: started 2025-12-28 03:44:50.5562 AlertProcessor ProcessorAlertData: Stopped 2025-12-28 03:49:45.5272 AlertProcessor ProcessorAlertData: started 2025-12-28 03:49:50.6209 AlertProcessor ProcessorAlertData: Stopped 2025-12-28 03:54:45.5448 AlertProcessor ProcessorAlertData: started 2025-12-28 03:54:50.8886 AlertProcessor ProcessorAlertData: Stopped 2025-12-28 03:54:56.8730 DFramework.Scheduler.TaskBase /* Time Taken: 15812.6085*/ Opportunity Out Of Stock By Outlet 2025-12-28 03:59:45.5626 AlertProcessor ProcessorAlertData: started 2025-12-28 03:59:48.5470 DFramework.Database.Query /* Time Taken: 532*/ DECLARE @TableName AnsiString(8000) SET @TableName = 'AssetStockProductWiseConsolidate' DECLARE @CurrentRecordId Int32 SET @CurrentRecordId = '3675192' dbo.GetValidDeviceForAlertProcessData 2025-12-28 03:59:51.0627 AlertProcessor ProcessorAlertData: Stopped 2025-12-28 04:04:45.5805 AlertProcessor ProcessorAlertData: started 2025-12-28 04:04:50.7212 AlertProcessor ProcessorAlertData: Stopped 2025-12-28 04:09:45.5984 AlertProcessor ProcessorAlertData: started 2025-12-28 04:09:50.7546 AlertProcessor ProcessorAlertData: Stopped 2025-12-28 04:09:56.8641 DFramework.Scheduler.TaskBase /* Time Taken: 15781.3564*/ Opportunity Out Of Stock By Outlet 2025-12-28 04:14:45.6162 AlertProcessor ProcessorAlertData: started 2025-12-28 04:14:50.8975 AlertProcessor ProcessorAlertData: Stopped 2025-12-28 04:19:45.6341 AlertProcessor ProcessorAlertData: started 2025-12-28 04:19:50.9310 AlertProcessor ProcessorAlertData: Stopped 2025-12-28 04:24:45.6519 AlertProcessor ProcessorAlertData: started 2025-12-28 04:24:50.9019 AlertProcessor ProcessorAlertData: Stopped 2025-12-28 04:24:56.9645 DFramework.Scheduler.TaskBase /* Time Taken: 15859.491*/ Opportunity Out Of Stock By Outlet 2025-12-28 04:29:45.6697 AlertProcessor ProcessorAlertData: started 2025-12-28 04:29:50.8260 AlertProcessor ProcessorAlertData: Stopped 2025-12-28 04:34:45.6876 AlertProcessor ProcessorAlertData: started 2025-12-28 04:34:50.9532 AlertProcessor ProcessorAlertData: Stopped 2025-12-28 04:39:45.7054 AlertProcessor ProcessorAlertData: started 2025-12-28 04:39:50.8930 AlertProcessor ProcessorAlertData: Stopped 2025-12-28 04:39:56.8305 DFramework.Scheduler.TaskBase /* Time Taken: 15703.2333*/ Opportunity Out Of Stock By Outlet 2025-12-28 04:44:45.7233 AlertProcessor ProcessorAlertData: started 2025-12-28 04:44:50.9108 AlertProcessor ProcessorAlertData: Stopped 2025-12-28 04:49:45.7411 AlertProcessor ProcessorAlertData: started 2025-12-28 04:49:50.9287 AlertProcessor ProcessorAlertData: Stopped 2025-12-28 04:54:45.7590 AlertProcessor ProcessorAlertData: started 2025-12-28 04:54:50.9153 AlertProcessor ProcessorAlertData: Stopped 2025-12-28 04:54:56.8528 DFramework.Scheduler.TaskBase /* Time Taken: 15703.2446*/ Opportunity Out Of Stock By Outlet 2025-12-28 04:59:45.7768 AlertProcessor ProcessorAlertData: started 2025-12-28 04:59:50.9956 AlertProcessor ProcessorAlertData: Stopped 2025-12-28 05:04:45.7947 AlertProcessor ProcessorAlertData: started 2025-12-28 05:04:50.8885 AlertProcessor ProcessorAlertData: Stopped 2025-12-28 05:09:45.7969 AlertProcessor ProcessorAlertData: started 2025-12-28 05:09:50.9688 AlertProcessor ProcessorAlertData: Stopped 2025-12-28 05:09:56.8595 DFramework.Scheduler.TaskBase /* Time Taken: 15687.6162*/ Opportunity Out Of Stock By Outlet 2025-12-28 05:14:45.8148 AlertProcessor ProcessorAlertData: started 2025-12-28 05:14:50.8929 AlertProcessor ProcessorAlertData: Stopped 2025-12-28 05:19:45.8171 AlertProcessor ProcessorAlertData: started 2025-12-28 05:19:50.9109 AlertProcessor ProcessorAlertData: Stopped 2025-12-28 05:24:45.8350 AlertProcessor ProcessorAlertData: started 2025-12-28 05:24:50.9132 AlertProcessor ProcessorAlertData: Stopped 2025-12-28 05:24:56.8663 DFramework.Scheduler.TaskBase /* Time Taken: 15687.6171*/ Opportunity Out Of Stock By Outlet 2025-12-28 05:29:45.8529 AlertProcessor ProcessorAlertData: started 2025-12-28 05:29:50.9623 AlertProcessor ProcessorAlertData: Stopped 2025-12-28 05:34:45.8551 AlertProcessor ProcessorAlertData: started 2025-12-28 05:34:51.0895 AlertProcessor ProcessorAlertData: Stopped 2025-12-28 05:39:45.8573 AlertProcessor ProcessorAlertData: started 2025-12-28 05:39:50.9355 AlertProcessor ProcessorAlertData: Stopped 2025-12-28 05:39:56.8574 DFramework.Scheduler.TaskBase /* Time Taken: 15672.018*/ Opportunity Out Of Stock By Outlet 2025-12-28 05:44:45.8752 AlertProcessor ProcessorAlertData: started 2025-12-28 05:44:50.9377 AlertProcessor ProcessorAlertData: Stopped 2025-12-28 05:49:45.8930 AlertProcessor ProcessorAlertData: started 2025-12-28 05:49:51.1587 AlertProcessor ProcessorAlertData: Stopped 2025-12-28 05:54:45.8953 AlertProcessor ProcessorAlertData: started 2025-12-28 05:54:51.0828 AlertProcessor ProcessorAlertData: Stopped 2025-12-28 05:54:56.8953 DFramework.Scheduler.TaskBase /* Time Taken: 15687.6058*/ Opportunity Out Of Stock By Outlet 2025-12-28 05:59:45.9131 AlertProcessor ProcessorAlertData: started 2025-12-28 05:59:51.2256 AlertProcessor ProcessorAlertData: Stopped 2025-12-28 06:04:45.9310 AlertProcessor ProcessorAlertData: started 2025-12-28 06:04:51.1185 AlertProcessor ProcessorAlertData: Stopped 2025-12-28 06:09:45.9489 AlertProcessor ProcessorAlertData: started 2025-12-28 06:09:51.0739 AlertProcessor ProcessorAlertData: Stopped 2025-12-28 06:09:56.9490 DFramework.Scheduler.TaskBase /* Time Taken: 15718.8753*/ Opportunity Out Of Stock By Outlet 2025-12-28 06:14:45.9668 AlertProcessor ProcessorAlertData: started 2025-12-28 06:14:51.3262 AlertProcessor ProcessorAlertData: Stopped 2025-12-28 06:19:45.9846 AlertProcessor ProcessorAlertData: started 2025-12-28 06:19:51.0472 AlertProcessor ProcessorAlertData: Stopped 2025-12-28 06:24:46.0025 AlertProcessor ProcessorAlertData: started 2025-12-28 06:24:51.3932 AlertProcessor ProcessorAlertData: Stopped 2025-12-28 06:24:57.0339 DFramework.Scheduler.TaskBase /* Time Taken: 15781.3728*/ Opportunity Out Of Stock By Outlet 2025-12-28 06:29:46.0204 AlertProcessor ProcessorAlertData: started 2025-12-28 06:29:51.1455 AlertProcessor ProcessorAlertData: Stopped 2025-12-28 06:34:46.0383 AlertProcessor ProcessorAlertData: started 2025-12-28 06:34:51.2102 AlertProcessor ProcessorAlertData: Stopped 2025-12-28 06:39:46.0561 AlertProcessor ProcessorAlertData: started 2025-12-28 06:39:47.1186 DFramework.Database.Query /* Time Taken: 612*/ DECLARE @ClientId Int32 SET @ClientId = '286' DECLARE @MarketId Int32 SET @MarketId = '0' DECLARE @ClassificationId Int32 SET @ClassificationId = '0' DECLARE @LocationId Int32 SET @LocationId = '0' DECLARE @LocationTypeId Int32 SET @LocationTypeId = '0' DECLARE @StartDate DateTime2 SET @StartDate = '11/1/2025 12:00:00 AM' dbo.GetOpportunityOutOfStockDataByOutlet 2025-12-28 06:39:51.2597 AlertProcessor ProcessorAlertData: Stopped 2025-12-28 06:39:57.4781 DFramework.Scheduler.TaskBase /* Time Taken: 16203.2414*/ Opportunity Out Of Stock By Outlet 2025-12-28 06:44:46.0740 AlertProcessor ProcessorAlertData: started 2025-12-28 06:44:51.1522 AlertProcessor ProcessorAlertData: Stopped 2025-12-28 06:49:46.0919 AlertProcessor ProcessorAlertData: started 2025-12-28 06:49:51.2169 AlertProcessor ProcessorAlertData: Stopped 2025-12-28 06:54:46.1098 AlertProcessor ProcessorAlertData: started 2025-12-28 06:54:51.1879 AlertProcessor ProcessorAlertData: Stopped 2025-12-28 06:54:57.0630 DFramework.Scheduler.TaskBase /* Time Taken: 15765.74*/ Opportunity Out Of Stock By Outlet 2025-12-28 06:59:46.1277 AlertProcessor ProcessorAlertData: started 2025-12-28 06:59:51.2058 AlertProcessor ProcessorAlertData: Stopped 2025-12-28 07:04:46.1456 AlertProcessor ProcessorAlertData: started 2025-12-28 07:04:51.1612 AlertProcessor ProcessorAlertData: Stopped 2025-12-28 07:09:46.1634 AlertProcessor ProcessorAlertData: started 2025-12-28 07:09:51.3353 AlertProcessor ProcessorAlertData: Stopped 2025-12-28 07:09:57.1010 DFramework.Scheduler.TaskBase /* Time Taken: 15796.989*/ Opportunity Out Of Stock By Outlet 2025-12-28 07:14:46.1813 AlertProcessor ProcessorAlertData: started 2025-12-28 07:14:51.2438 AlertProcessor ProcessorAlertData: Stopped 2025-12-28 07:19:46.1835 AlertProcessor ProcessorAlertData: started 2025-12-28 07:19:51.2304 AlertProcessor ProcessorAlertData: Stopped 2025-12-28 07:24:46.1857 AlertProcessor ProcessorAlertData: started 2025-12-28 07:24:51.2639 AlertProcessor ProcessorAlertData: Stopped 2025-12-28 07:24:57.1077 DFramework.Scheduler.TaskBase /* Time Taken: 15781.3554*/ Opportunity Out Of Stock By Outlet 2025-12-28 07:29:46.1879 AlertProcessor ProcessorAlertData: started 2025-12-28 07:29:51.1880 AlertProcessor ProcessorAlertData: Stopped 2025-12-28 07:34:46.2057 AlertProcessor ProcessorAlertData: started 2025-12-28 07:34:51.2214 AlertProcessor ProcessorAlertData: Stopped 2025-12-28 07:39:46.2235 AlertProcessor ProcessorAlertData: started 2025-12-28 07:39:51.4423 AlertProcessor ProcessorAlertData: Stopped 2025-12-28 07:39:57.1143 DFramework.Scheduler.TaskBase /* Time Taken: 15765.7418*/ Opportunity Out Of Stock By Outlet 2025-12-28 07:44:46.2414 AlertProcessor ProcessorAlertData: started 2025-12-28 07:44:51.3196 AlertProcessor ProcessorAlertData: Stopped 2025-12-28 07:49:46.2437 AlertProcessor ProcessorAlertData: started 2025-12-28 07:49:51.3531 AlertProcessor ProcessorAlertData: Stopped 2025-12-28 07:54:46.2616 AlertProcessor ProcessorAlertData: started 2025-12-28 07:54:51.3710 AlertProcessor ProcessorAlertData: Stopped 2025-12-28 07:54:57.1055 DFramework.Scheduler.TaskBase /* Time Taken: 15734.4963*/ Opportunity Out Of Stock By Outlet 2025-12-28 07:59:46.2795 AlertProcessor ProcessorAlertData: started 2025-12-28 07:59:51.3576 AlertProcessor ProcessorAlertData: Stopped 2025-12-28 08:04:46.2974 AlertProcessor ProcessorAlertData: started 2025-12-28 08:04:51.3755 AlertProcessor ProcessorAlertData: Stopped 2025-12-28 08:09:46.3154 AlertProcessor ProcessorAlertData: started 2025-12-28 08:09:51.5029 AlertProcessor ProcessorAlertData: Stopped 2025-12-28 08:09:57.1280 DFramework.Scheduler.TaskBase /* Time Taken: 15734.5054*/ Opportunity Out Of Stock By Outlet 2025-12-28 08:14:46.3333 AlertProcessor ProcessorAlertData: started 2025-12-28 08:14:51.4114 AlertProcessor ProcessorAlertData: Stopped 2025-12-28 08:19:46.3355 AlertProcessor ProcessorAlertData: started 2025-12-28 08:19:51.3512 AlertProcessor ProcessorAlertData: Stopped 2025-12-28 08:24:46.3533 AlertProcessor ProcessorAlertData: started 2025-12-28 08:24:51.7127 AlertProcessor ProcessorAlertData: Stopped 2025-12-28 08:24:57.2752 DFramework.Scheduler.TaskBase /* Time Taken: 15859.4853*/ Opportunity Out Of Stock By Outlet 2025-12-28 08:29:46.3711 AlertProcessor ProcessorAlertData: started 2025-12-28 08:29:51.8555 AlertProcessor ProcessorAlertData: Stopped 2025-12-28 08:34:46.3889 AlertProcessor ProcessorAlertData: started 2025-12-28 08:34:51.8264 AlertProcessor ProcessorAlertData: Stopped 2025-12-28 08:39:46.4067 AlertProcessor ProcessorAlertData: started 2025-12-28 08:39:52.1099 AlertProcessor ProcessorAlertData: Stopped 2025-12-28 08:39:57.2193 DFramework.Scheduler.TaskBase /* Time Taken: 15781.3648*/ Opportunity Out Of Stock By Outlet 2025-12-28 08:44:46.4246 AlertProcessor ProcessorAlertData: started 2025-12-28 08:44:52.1434 AlertProcessor ProcessorAlertData: Stopped 2025-12-28 08:49:46.4425 AlertProcessor ProcessorAlertData: started 2025-12-28 08:49:52.0363 AlertProcessor ProcessorAlertData: Stopped 2025-12-28 08:54:46.4447 AlertProcessor ProcessorAlertData: started 2025-12-28 08:54:52.1166 DFramework.Database.Query /* Time Taken: 593*/ DECLARE @TableName AnsiString(8000) SET @TableName = 'ProductStockLevel' DECLARE @CurrentRecordId Int32 SET @CurrentRecordId = '3675192' dbo.GetValidDeviceForAlertProcessData 2025-12-28 08:54:52.1791 AlertProcessor ProcessorAlertData: Stopped 2025-12-28 08:54:57.2416 DFramework.Scheduler.TaskBase /* Time Taken: 15781.3662*/ Opportunity Out Of Stock By Outlet 2025-12-28 08:59:46.4625 AlertProcessor ProcessorAlertData: started 2025-12-28 08:59:52.0251 AlertProcessor ProcessorAlertData: Stopped 2025-12-28 09:04:46.4804 AlertProcessor ProcessorAlertData: started 2025-12-28 09:04:52.0273 AlertProcessor ProcessorAlertData: Stopped 2025-12-28 09:09:46.4982 AlertProcessor ProcessorAlertData: started 2025-12-28 09:09:52.1701 AlertProcessor ProcessorAlertData: Stopped 2025-12-28 09:09:57.2014 DFramework.Scheduler.TaskBase /* Time Taken: 15718.8721*/ Opportunity Out Of Stock By Outlet 2025-12-28 09:14:46.5160 AlertProcessor ProcessorAlertData: started 2025-12-28 09:14:52.0005 AlertProcessor ProcessorAlertData: Stopped 2025-12-28 09:19:46.5339 AlertProcessor ProcessorAlertData: started 2025-12-28 09:19:52.0027 AlertProcessor ProcessorAlertData: Stopped 2025-12-28 09:24:46.5517 AlertProcessor ProcessorAlertData: started 2025-12-28 09:24:51.9424 AlertProcessor ProcessorAlertData: Stopped 2025-12-28 09:24:57.2393 DFramework.Scheduler.TaskBase /* Time Taken: 15734.4896*/ Opportunity Out Of Stock By Outlet 2025-12-28 09:29:46.5696 AlertProcessor ProcessorAlertData: started 2025-12-28 09:29:52.1165 AlertProcessor ProcessorAlertData: Stopped 2025-12-28 09:34:46.5874 AlertProcessor ProcessorAlertData: started 2025-12-28 09:34:47.1031 DFramework.Database.Query /* Time Taken: 519*/ DECLARE @TableName AnsiString(8000) SET @TableName = 'TagAlert' DECLARE @CurrentRecordId Int32 SET @CurrentRecordId = '0' dbo.GetValidDeviceForAlertProcessData 2025-12-28 09:34:52.2907 AlertProcessor ProcessorAlertData: Stopped 2025-12-28 09:39:46.6053 AlertProcessor ProcessorAlertData: started 2025-12-28 09:39:52.1053 DFramework.Database.Query /* Time Taken: 524*/ DECLARE @TableName AnsiString(8000) SET @TableName = 'ProductStockLevel' DECLARE @CurrentRecordId Int32 SET @CurrentRecordId = '3675192' dbo.GetValidDeviceForAlertProcessData 2025-12-28 09:39:52.1522 AlertProcessor ProcessorAlertData: Stopped 2025-12-28 09:39:57.3241 DFramework.Scheduler.TaskBase /* Time Taken: 15796.9972*/ Opportunity Out Of Stock By Outlet 2025-12-28 09:44:46.6231 AlertProcessor ProcessorAlertData: started 2025-12-28 09:44:52.2482 AlertProcessor ProcessorAlertData: Stopped 2025-12-28 09:47:14.6399 DFramework.Database.Query /* Time Taken: 1077*/ DECLARE @IsFileProcessed Int32 SET @IsFileProcessed = '0' DECLARE @TaskNumber Int32 SET @TaskNumber = '2' DECLARE @IsDeleted Int32 SET @IsDeleted = '0' SELECT TOP 1000 IncomingFileId, GatewayId,GatewayMac,RawFileName,AzureContainerName,StartIndex,Tries, CreatedOn FROM IncomingFile WHERE [IsFileProcessed] = @IsFileProcessed AND [TaskNumber] = @TaskNumber AND [IsDeleted] = @IsDeleted 2025-12-28 09:47:18.1555 DFramework.Database.Query /* Time Taken: 4598*/ DECLARE @IsFileProcessed Int32 SET @IsFileProcessed = '0' DECLARE @TaskNumber Int32 SET @TaskNumber = '4' DECLARE @IsDeleted Int32 SET @IsDeleted = '0' SELECT TOP 1000 IncomingFileId, GatewayId,GatewayMac,RawFileName,AzureContainerName,StartIndex,Tries, CreatedOn FROM IncomingFile WHERE [IsFileProcessed] = @IsFileProcessed AND [TaskNumber] = @TaskNumber AND [IsDeleted] = @IsDeleted 2025-12-28 09:47:21.2962 DFramework.Database.Query /* Time Taken: 2717*/ DECLARE @IsFileProcessed Int32 SET @IsFileProcessed = '0' DECLARE @TaskNumber Int32 SET @TaskNumber = '1' DECLARE @IsDeleted Int32 SET @IsDeleted = '0' SELECT TOP 1000 IncomingFileId, GatewayId,GatewayMac,RawFileName,AzureContainerName,StartIndex,Tries, CreatedOn FROM IncomingFile WHERE [IsFileProcessed] = @IsFileProcessed AND [TaskNumber] = @TaskNumber AND [IsDeleted] = @IsDeleted 2025-12-28 09:47:24.0931 DFramework.Database.Query /* Time Taken: 501*/ DECLARE @IsFileProcessed Int32 SET @IsFileProcessed = '0' DECLARE @TaskNumber Int32 SET @TaskNumber = '1' DECLARE @IsDeleted Int32 SET @IsDeleted = '0' SELECT TOP 1000 IncomingFileId, GatewayId,GatewayMac,RawFileName,AzureContainerName,StartIndex,Tries, CreatedOn FROM IncomingFile WHERE [IsFileProcessed] = @IsFileProcessed AND [TaskNumber] = @TaskNumber AND [IsDeleted] = @IsDeleted 2025-12-28 09:47:24.1399 DFramework.Database.Query /* Time Taken: 558*/ DECLARE @IsFileProcessed Int32 SET @IsFileProcessed = '0' DECLARE @TaskNumber Int32 SET @TaskNumber = '4' DECLARE @IsDeleted Int32 SET @IsDeleted = '0' SELECT TOP 1000 IncomingFileId, GatewayId,GatewayMac,RawFileName,AzureContainerName,StartIndex,Tries, CreatedOn FROM IncomingFile WHERE [IsFileProcessed] = @IsFileProcessed AND [TaskNumber] = @TaskNumber AND [IsDeleted] = @IsDeleted 2025-12-28 09:47:24.3274 DFramework.Database.Query /* Time Taken: 741*/ DECLARE @IsFileProcessed Int32 SET @IsFileProcessed = '0' DECLARE @TaskNumber Int32 SET @TaskNumber = '0' DECLARE @IsDeleted Int32 SET @IsDeleted = '0' SELECT TOP 1000 IncomingFileId, GatewayId,GatewayMac,RawFileName,AzureContainerName,StartIndex,Tries, CreatedOn FROM IncomingFile WHERE [IsFileProcessed] = @IsFileProcessed AND [TaskNumber] = @TaskNumber AND [IsDeleted] = @IsDeleted 2025-12-28 09:47:24.4368 DFramework.Database.Query /* Time Taken: 853*/ DECLARE @IsFileProcessed Int32 SET @IsFileProcessed = '0' DECLARE @TaskNumber Int32 SET @TaskNumber = '3' DECLARE @IsDeleted Int32 SET @IsDeleted = '0' SELECT TOP 1000 IncomingFileId, GatewayId,GatewayMac,RawFileName,AzureContainerName,StartIndex,Tries, CreatedOn FROM IncomingFile WHERE [IsFileProcessed] = @IsFileProcessed AND [TaskNumber] = @TaskNumber AND [IsDeleted] = @IsDeleted 2025-12-28 09:47:29.1400 DFramework.Database.Query /* Time Taken: 558*/ DECLARE @IsFileProcessed Int32 SET @IsFileProcessed = '0' DECLARE @TaskNumber Int32 SET @TaskNumber = '4' DECLARE @IsDeleted Int32 SET @IsDeleted = '0' SELECT TOP 1000 IncomingFileId, GatewayId,GatewayMac,RawFileName,AzureContainerName,StartIndex,Tries, CreatedOn FROM IncomingFile WHERE [IsFileProcessed] = @IsFileProcessed AND [TaskNumber] = @TaskNumber AND [IsDeleted] = @IsDeleted 2025-12-28 09:47:30.8275 DFramework.Database.Query /* Time Taken: 2237*/ DECLARE @IsFileProcessed Int32 SET @IsFileProcessed = '0' DECLARE @TaskNumber Int32 SET @TaskNumber = '0' DECLARE @IsDeleted Int32 SET @IsDeleted = '0' SELECT TOP 1000 IncomingFileId, GatewayId,GatewayMac,RawFileName,AzureContainerName,StartIndex,Tries, CreatedOn FROM IncomingFile WHERE [IsFileProcessed] = @IsFileProcessed AND [TaskNumber] = @TaskNumber AND [IsDeleted] = @IsDeleted 2025-12-28 09:47:34.1088 DFramework.Database.Query /* Time Taken: 510*/ DECLARE @IsFileProcessed Int32 SET @IsFileProcessed = '0' DECLARE @TaskNumber Int32 SET @TaskNumber = '1' DECLARE @IsDeleted Int32 SET @IsDeleted = '0' SELECT TOP 1000 IncomingFileId, GatewayId,GatewayMac,RawFileName,AzureContainerName,StartIndex,Tries, CreatedOn FROM IncomingFile WHERE [IsFileProcessed] = @IsFileProcessed AND [TaskNumber] = @TaskNumber AND [IsDeleted] = @IsDeleted 2025-12-28 09:47:35.1088 DFramework.Database.Query /* Time Taken: 1510*/ DECLARE @IsFileProcessed Int32 SET @IsFileProcessed = '0' DECLARE @TaskNumber Int32 SET @TaskNumber = '0' DECLARE @IsDeleted Int32 SET @IsDeleted = '0' SELECT TOP 1000 IncomingFileId, GatewayId,GatewayMac,RawFileName,AzureContainerName,StartIndex,Tries, CreatedOn FROM IncomingFile WHERE [IsFileProcessed] = @IsFileProcessed AND [TaskNumber] = @TaskNumber AND [IsDeleted] = @IsDeleted 2025-12-28 09:47:43.2338 DFramework.Database.Query /* Time Taken: 4623*/ DECLARE @IsFileProcessed Int32 SET @IsFileProcessed = '0' DECLARE @TaskNumber Int32 SET @TaskNumber = '4' DECLARE @IsDeleted Int32 SET @IsDeleted = '0' SELECT TOP 1000 IncomingFileId, GatewayId,GatewayMac,RawFileName,AzureContainerName,StartIndex,Tries, CreatedOn FROM IncomingFile WHERE [IsFileProcessed] = @IsFileProcessed AND [TaskNumber] = @TaskNumber AND [IsDeleted] = @IsDeleted 2025-12-28 09:47:44.1713 DFramework.Database.Query /* Time Taken: 534*/ DECLARE @IsFileProcessed Int32 SET @IsFileProcessed = '0' DECLARE @TaskNumber Int32 SET @TaskNumber = '1' DECLARE @IsDeleted Int32 SET @IsDeleted = '0' SELECT TOP 1000 IncomingFileId, GatewayId,GatewayMac,RawFileName,AzureContainerName,StartIndex,Tries, CreatedOn FROM IncomingFile WHERE [IsFileProcessed] = @IsFileProcessed AND [TaskNumber] = @TaskNumber AND [IsDeleted] = @IsDeleted 2025-12-28 09:47:44.7182 DFramework.Database.Query /* Time Taken: 1078*/ DECLARE @IsFileProcessed Int32 SET @IsFileProcessed = '0' DECLARE @TaskNumber Int32 SET @TaskNumber = '3' DECLARE @IsDeleted Int32 SET @IsDeleted = '0' SELECT TOP 1000 IncomingFileId, GatewayId,GatewayMac,RawFileName,AzureContainerName,StartIndex,Tries, CreatedOn FROM IncomingFile WHERE [IsFileProcessed] = @IsFileProcessed AND [TaskNumber] = @TaskNumber AND [IsDeleted] = @IsDeleted 2025-12-28 09:47:49.5464 DFramework.Database.Query /* Time Taken: 903*/ DECLARE @IsFileProcessed Int32 SET @IsFileProcessed = '0' DECLARE @TaskNumber Int32 SET @TaskNumber = '0' DECLARE @IsDeleted Int32 SET @IsDeleted = '0' SELECT TOP 1000 IncomingFileId, GatewayId,GatewayMac,RawFileName,AzureContainerName,StartIndex,Tries, CreatedOn FROM IncomingFile WHERE [IsFileProcessed] = @IsFileProcessed AND [TaskNumber] = @TaskNumber AND [IsDeleted] = @IsDeleted 2025-12-28 09:48:00.7808 DFramework.Database.Query /* Time Taken: 17143*/ DECLARE @IsFileProcessed Int32 SET @IsFileProcessed = '0' DECLARE @TaskNumber Int32 SET @TaskNumber = '4' DECLARE @IsDeleted Int32 SET @IsDeleted = '0' SELECT TOP 1000 IncomingFileId, GatewayId,GatewayMac,RawFileName,AzureContainerName,StartIndex,Tries, CreatedOn FROM IncomingFile WHERE [IsFileProcessed] = @IsFileProcessed AND [TaskNumber] = @TaskNumber AND [IsDeleted] = @IsDeleted 2025-12-28 09:48:00.7808 DFramework.Scheduler.TaskBase /* Time Taken: 17140.7455*/ ProcessSQLUnprocessedFiles 2025-12-28 09:48:02.1246 DFramework.Database.Query /* Time Taken: 3439*/ DECLARE @IsFileProcessed Int32 SET @IsFileProcessed = '0' DECLARE @TaskNumber Int32 SET @TaskNumber = '1' DECLARE @IsDeleted Int32 SET @IsDeleted = '0' SELECT TOP 1000 IncomingFileId, GatewayId,GatewayMac,RawFileName,AzureContainerName,StartIndex,Tries, CreatedOn FROM IncomingFile WHERE [IsFileProcessed] = @IsFileProcessed AND [TaskNumber] = @TaskNumber AND [IsDeleted] = @IsDeleted 2025-12-28 09:48:03.6090 DFramework.Database.Query /* Time Taken: 35015*/ DECLARE @IsFileProcessed Int32 SET @IsFileProcessed = '0' DECLARE @TaskNumber Int32 SET @TaskNumber = '2' DECLARE @IsDeleted Int32 SET @IsDeleted = '0' SELECT TOP 1000 IncomingFileId, GatewayId,GatewayMac,RawFileName,AzureContainerName,StartIndex,Tries, CreatedOn FROM IncomingFile WHERE [IsFileProcessed] = @IsFileProcessed AND [TaskNumber] = @TaskNumber AND [IsDeleted] = @IsDeleted 2025-12-28 09:48:04.2809 DFramework.Database.Query /* Time Taken: 578*/ DECLARE @IsFileProcessed Int32 SET @IsFileProcessed = '0' DECLARE @TaskNumber Int32 SET @TaskNumber = '4' DECLARE @IsDeleted Int32 SET @IsDeleted = '0' SELECT TOP 1000 IncomingFileId, GatewayId,GatewayMac,RawFileName,AzureContainerName,StartIndex,Tries, CreatedOn FROM IncomingFile WHERE [IsFileProcessed] = @IsFileProcessed AND [TaskNumber] = @TaskNumber AND [IsDeleted] = @IsDeleted 2025-12-28 09:48:04.9527 DFramework.Scheduler.TaskBase /* Time Taken: 36359.6455*/ ProcessSQLUnprocessedFiles 2025-12-28 09:49:46.6254 AlertProcessor ProcessorAlertData: started 2025-12-28 09:49:52.2191 AlertProcessor ProcessorAlertData: Stopped 2025-12-28 09:54:46.6432 AlertProcessor ProcessorAlertData: started 2025-12-28 09:54:52.2526 AlertProcessor ProcessorAlertData: Stopped 2025-12-28 09:54:57.3777 DFramework.Scheduler.TaskBase /* Time Taken: 15828.2451*/ Opportunity Out Of Stock By Outlet 2025-12-28 09:59:46.6611 AlertProcessor ProcessorAlertData: started 2025-12-28 09:59:52.2236 AlertProcessor ProcessorAlertData: Stopped 2025-12-28 10:04:46.6789 AlertProcessor ProcessorAlertData: started 2025-12-28 10:04:52.2258 AlertProcessor ProcessorAlertData: Stopped 2025-12-28 10:09:46.6968 AlertProcessor ProcessorAlertData: started 2025-12-28 10:09:52.3531 AlertProcessor ProcessorAlertData: Stopped 2025-12-28 10:09:57.3843 DFramework.Scheduler.TaskBase /* Time Taken: 15812.6157*/ Opportunity Out Of Stock By Outlet 2025-12-28 10:14:46.7146 AlertProcessor ProcessorAlertData: started 2025-12-28 10:14:52.2303 AlertProcessor ProcessorAlertData: Stopped 2025-12-28 10:19:46.7324 AlertProcessor ProcessorAlertData: started 2025-12-28 10:19:52.3262 AlertProcessor ProcessorAlertData: Stopped 2025-12-28 10:24:46.7503 AlertProcessor ProcessorAlertData: started 2025-12-28 10:24:52.2972 AlertProcessor ProcessorAlertData: Stopped 2025-12-28 10:24:57.3910 DFramework.Scheduler.TaskBase /* Time Taken: 15796.9781*/ Opportunity Out Of Stock By Outlet 2025-12-28 10:29:46.7682 AlertProcessor ProcessorAlertData: started 2025-12-28 10:29:52.3307 AlertProcessor ProcessorAlertData: Stopped 2025-12-28 10:34:46.7860 AlertProcessor ProcessorAlertData: started 2025-12-28 10:34:52.3017 AlertProcessor ProcessorAlertData: Stopped 2025-12-28 10:39:46.8039 AlertProcessor ProcessorAlertData: started 2025-12-28 10:39:52.3664 AlertProcessor ProcessorAlertData: Stopped 2025-12-28 10:39:57.4289 DFramework.Scheduler.TaskBase /* Time Taken: 15812.6179*/ Opportunity Out Of Stock By Outlet 2025-12-28 10:44:46.8217 AlertProcessor ProcessorAlertData: started 2025-12-28 10:44:52.3530 AlertProcessor ProcessorAlertData: Stopped 2025-12-28 10:49:46.8396 AlertProcessor ProcessorAlertData: started 2025-12-28 10:49:48.9646 DFramework.Database.NullableDataReader Data reader open for 277 at System.Environment.GetStackTrace(Exception e, Boolean needFileInfo) at System.Environment.get_StackTrace() at DFramework.Database.NullableDataReader.Dispose(Boolean disposing) in D:\Spraxa\Framework\DFramework\Database\NullableDataReader.cs:line 33 at DFramework.Database.NullableDataReader.Dispose() in D:\Spraxa\Framework\DFramework\Database\NullableDataReader.cs:line 44 at CoolR.Tasks.ProcessAlertData.Execute() in D:\Spraxa\CoolR-Group\portal\CoolR.Tasks\ProcessAlertData.cs:line 47 at DFramework.Scheduler.TaskBase.Run() in D:\Spraxa\Framework\DFramework.Scheduler\TaskBase.cs:line 176 at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx) at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx) at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state) at System.Threading.ThreadHelper.ThreadStart() 2025-12-28 10:49:52.5740 AlertProcessor ProcessorAlertData: Stopped 2025-12-28 10:54:46.8418 AlertProcessor ProcessorAlertData: started 2025-12-28 10:54:52.4043 AlertProcessor ProcessorAlertData: Stopped 2025-12-28 10:54:57.4356 DFramework.Scheduler.TaskBase /* Time Taken: 15796.9902*/ Opportunity Out Of Stock By Outlet 2025-12-28 10:59:46.8597 AlertProcessor ProcessorAlertData: started 2025-12-28 10:59:52.4222 AlertProcessor ProcessorAlertData: Stopped 2025-12-28 11:04:46.8776 AlertProcessor ProcessorAlertData: started 2025-12-28 11:04:51.5964 DFramework.Database.NullableDataReader Data reader open for 278 at System.Environment.GetStackTrace(Exception e, Boolean needFileInfo) at System.Environment.get_StackTrace() at DFramework.Database.NullableDataReader.Dispose(Boolean disposing) in D:\Spraxa\Framework\DFramework\Database\NullableDataReader.cs:line 33 at DFramework.Database.NullableDataReader.Dispose() in D:\Spraxa\Framework\DFramework\Database\NullableDataReader.cs:line 44 at CoolR.Tasks.ProcessAlertData.Execute() in D:\Spraxa\CoolR-Group\portal\CoolR.Tasks\ProcessAlertData.cs:line 47 at DFramework.Scheduler.TaskBase.Run() in D:\Spraxa\Framework\DFramework.Scheduler\TaskBase.cs:line 176 at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx) at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx) at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state) at System.Threading.ThreadHelper.ThreadStart() 2025-12-28 11:04:52.6745 AlertProcessor ProcessorAlertData: Stopped 2025-12-28 11:09:42.4579 DFramework.Database.Query /* Time Taken: 504*/ [dbo].GenerateSystemAlerts 2025-12-28 11:09:46.8954 AlertProcessor ProcessorAlertData: started 2025-12-28 11:09:52.5830 AlertProcessor ProcessorAlertData: Stopped 2025-12-28 11:09:57.4111 DFramework.Scheduler.TaskBase /* Time Taken: 15750.1429*/ Opportunity Out Of Stock By Outlet 2025-12-28 11:14:46.9133 AlertProcessor ProcessorAlertData: started 2025-12-28 11:14:52.5227 AlertProcessor ProcessorAlertData: Stopped 2025-12-28 11:19:46.9311 AlertProcessor ProcessorAlertData: started 2025-12-28 11:19:52.6187 AlertProcessor ProcessorAlertData: Stopped 2025-12-28 11:24:46.9490 AlertProcessor ProcessorAlertData: started 2025-12-28 11:24:49.9959 DFramework.Database.Query /* Time Taken: 509*/ DECLARE @TableName AnsiString(8000) SET @TableName = 'AssetStockProductWiseConsolidate' DECLARE @CurrentRecordId Int32 SET @CurrentRecordId = '3675192' dbo.GetValidDeviceForAlertProcessData 2025-12-28 11:24:52.6522 AlertProcessor ProcessorAlertData: Stopped 2025-12-28 11:24:57.4178 DFramework.Scheduler.TaskBase /* Time Taken: 15750.1062*/ Opportunity Out Of Stock By Outlet 2025-12-28 11:27:40.5597 DFramework.Database.Query /* Time Taken: 703*/ DECLARE @IsFileProcessed Int32 SET @IsFileProcessed = '0' DECLARE @TaskNumber Int32 SET @TaskNumber = '1' DECLARE @IsDeleted Int32 SET @IsDeleted = '0' SELECT TOP 1000 IncomingFileId, GatewayId,GatewayMac,RawFileName,AzureContainerName,StartIndex,Tries, CreatedOn FROM IncomingFile WHERE [IsFileProcessed] = @IsFileProcessed AND [TaskNumber] = @TaskNumber AND [IsDeleted] = @IsDeleted 2025-12-28 11:27:45.6066 DFramework.Database.Query /* Time Taken: 734*/ DECLARE @IsFileProcessed Int32 SET @IsFileProcessed = '0' DECLARE @TaskNumber Int32 SET @TaskNumber = '0' DECLARE @IsDeleted Int32 SET @IsDeleted = '0' SELECT TOP 1000 IncomingFileId, GatewayId,GatewayMac,RawFileName,AzureContainerName,StartIndex,Tries, CreatedOn FROM IncomingFile WHERE [IsFileProcessed] = @IsFileProcessed AND [TaskNumber] = @TaskNumber AND [IsDeleted] = @IsDeleted 2025-12-28 11:28:15.4662 DFramework.Database.Query /* Time Taken: 529*/ DECLARE @IsFileProcessed Int32 SET @IsFileProcessed = '0' DECLARE @TaskNumber Int32 SET @TaskNumber = '2' DECLARE @IsDeleted Int32 SET @IsDeleted = '0' SELECT TOP 1000 IncomingFileId, GatewayId,GatewayMac,RawFileName,AzureContainerName,StartIndex,Tries, CreatedOn FROM IncomingFile WHERE [IsFileProcessed] = @IsFileProcessed AND [TaskNumber] = @TaskNumber AND [IsDeleted] = @IsDeleted 2025-12-28 11:29:46.9668 AlertProcessor ProcessorAlertData: started 2025-12-28 11:29:52.4825 AlertProcessor ProcessorAlertData: Stopped 2025-12-28 11:34:46.9690 AlertProcessor ProcessorAlertData: started 2025-12-28 11:34:52.4847 AlertProcessor ProcessorAlertData: Stopped 2025-12-28 11:39:46.9869 AlertProcessor ProcessorAlertData: started 2025-12-28 11:39:52.5025 AlertProcessor ProcessorAlertData: Stopped 2025-12-28 11:39:57.4088 DFramework.Scheduler.TaskBase /* Time Taken: 15718.8649*/ Opportunity Out Of Stock By Outlet 2025-12-28 11:44:33.2077 DFramework.Database.Query /* Time Taken: 508*/ DECLARE @IsFileProcessed Int32 SET @IsFileProcessed = '0' DECLARE @TaskNumber Int32 SET @TaskNumber = '0' DECLARE @IsDeleted Int32 SET @IsDeleted = '0' SELECT TOP 1000 IncomingFileId, GatewayId,GatewayMac,RawFileName,AzureContainerName,StartIndex,Tries, CreatedOn FROM IncomingFile WHERE [IsFileProcessed] = @IsFileProcessed AND [TaskNumber] = @TaskNumber AND [IsDeleted] = @IsDeleted 2025-12-28 11:44:38.2390 DFramework.Database.Query /* Time Taken: 524*/ DECLARE @IsFileProcessed Int32 SET @IsFileProcessed = '0' DECLARE @TaskNumber Int32 SET @TaskNumber = '2' DECLARE @IsDeleted Int32 SET @IsDeleted = '0' SELECT TOP 1000 IncomingFileId, GatewayId,GatewayMac,RawFileName,AzureContainerName,StartIndex,Tries, CreatedOn FROM IncomingFile WHERE [IsFileProcessed] = @IsFileProcessed AND [TaskNumber] = @TaskNumber AND [IsDeleted] = @IsDeleted 2025-12-28 11:44:43.2547 DFramework.Database.Query /* Time Taken: 527*/ DECLARE @IsFileProcessed Int32 SET @IsFileProcessed = '0' DECLARE @TaskNumber Int32 SET @TaskNumber = '4' DECLARE @IsDeleted Int32 SET @IsDeleted = '0' SELECT TOP 1000 IncomingFileId, GatewayId,GatewayMac,RawFileName,AzureContainerName,StartIndex,Tries, CreatedOn FROM IncomingFile WHERE [IsFileProcessed] = @IsFileProcessed AND [TaskNumber] = @TaskNumber AND [IsDeleted] = @IsDeleted 2025-12-28 11:44:43.8015 DFramework.Database.Query /* Time Taken: 528*/ 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 DateTime2 SET @AlertDefinition_StartDate = '12/28/2025 7:44:43 PM' 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 2025-12-28 11:44:46.9891 AlertProcessor ProcessorAlertData: started 2025-12-28 11:44:47.6610 DFramework.Database.NullableDataReader Data reader open for 289 at System.Environment.GetStackTrace(Exception e, Boolean needFileInfo) at System.Environment.get_StackTrace() at DFramework.Database.NullableDataReader.Dispose(Boolean disposing) in D:\Spraxa\Framework\DFramework\Database\NullableDataReader.cs:line 33 at DFramework.Database.NullableDataReader.Dispose() in D:\Spraxa\Framework\DFramework\Database\NullableDataReader.cs:line 44 at CoolR.Tasks.ProcessAlertData.Execute() in D:\Spraxa\CoolR-Group\portal\CoolR.Tasks\ProcessAlertData.cs:line 47 at DFramework.Scheduler.TaskBase.Run() in D:\Spraxa\Framework\DFramework.Scheduler\TaskBase.cs:line 176 at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx) at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx) at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state) at System.Threading.ThreadHelper.ThreadStart() 2025-12-28 11:44:48.2703 DFramework.Database.Query /* Time Taken: 526*/ DECLARE @IsFileProcessed Int32 SET @IsFileProcessed = '0' DECLARE @TaskNumber Int32 SET @TaskNumber = '4' DECLARE @IsDeleted Int32 SET @IsDeleted = '0' SELECT TOP 1000 IncomingFileId, GatewayId,GatewayMac,RawFileName,AzureContainerName,StartIndex,Tries, CreatedOn FROM IncomingFile WHERE [IsFileProcessed] = @IsFileProcessed AND [TaskNumber] = @TaskNumber AND [IsDeleted] = @IsDeleted 2025-12-28 11:44:48.3485 DFramework.Database.NullableDataReader Data reader open for 305 at System.Environment.GetStackTrace(Exception e, Boolean needFileInfo) at System.Environment.get_StackTrace() at DFramework.Database.NullableDataReader.Dispose(Boolean disposing) in D:\Spraxa\Framework\DFramework\Database\NullableDataReader.cs:line 33 at DFramework.Database.NullableDataReader.Dispose() in D:\Spraxa\Framework\DFramework\Database\NullableDataReader.cs:line 44 at CoolR.Tasks.ProcessAlertData.Execute() in D:\Spraxa\CoolR-Group\portal\CoolR.Tasks\ProcessAlertData.cs:line 47 at DFramework.Scheduler.TaskBase.Run() in D:\Spraxa\Framework\DFramework.Scheduler\TaskBase.cs:line 176 at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx) at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx) at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state) at System.Threading.ThreadHelper.ThreadStart() 2025-12-28 11:44:48.4110 DFramework.Database.Query /* Time Taken: 652*/ DECLARE @IsFileProcessed Int32 SET @IsFileProcessed = '0' DECLARE @IsDeleted Boolean SET @IsDeleted = 'False' SELECT TOP 500 CSVDataId, TDLinx, BeforeAfterImage, ImageUrl, FileName FROM CSVData WHERE [IsFileProcessed] = @IsFileProcessed AND IsDeleted = @IsDeleted ORDER BY [CSVDataId] 2025-12-28 11:44:48.9422 DFramework.Database.Query /* Time Taken: 599*/ DECLARE @TableName AnsiString(8000) SET @TableName = 'MissingShelf' DECLARE @CurrentRecordId Int32 SET @CurrentRecordId = '3675192' dbo.GetValidDeviceForAlertProcessData 2025-12-28 11:44:49.5985 DFramework.Database.Query /* Time Taken: 502*/ DECLARE @TableName AnsiString(8000) SET @TableName = 'MissingShelf' DECLARE @ClientId Int32 SET @ClientId = '0' DECLARE @Table AnsiString(8000) SET @Table = 'MissingShelf' DECLARE @PrimaryKey Int32 SET @PrimaryKey = '3675192' UPDATE dbo.AlertProcessor SET ClientId = @ClientId, TableName = @Table, PrimaryKey = @PrimaryKey WHERE [TableName] = @TableName AND (ClientId <> @ClientId OR TableName <> @Table OR PrimaryKey <> @PrimaryKey) 2025-12-28 11:44:49.5985 DFramework.Database.NullableDataReader Data reader open for 647 at System.Environment.GetStackTrace(Exception e, Boolean needFileInfo) at System.Environment.get_StackTrace() at DFramework.Database.NullableDataReader.Dispose(Boolean disposing) in D:\Spraxa\Framework\DFramework\Database\NullableDataReader.cs:line 33 at DFramework.Database.NullableDataReader.Dispose() in D:\Spraxa\Framework\DFramework\Database\NullableDataReader.cs:line 44 at CoolR.Tasks.ProcessAlertData.Execute() in D:\Spraxa\CoolR-Group\portal\CoolR.Tasks\ProcessAlertData.cs:line 47 at DFramework.Scheduler.TaskBase.Run() in D:\Spraxa\Framework\DFramework.Scheduler\TaskBase.cs:line 176 at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx) at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx) at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state) at System.Threading.ThreadHelper.ThreadStart() 2025-12-28 11:44:50.1297 DFramework.Database.Query /* Time Taken: 532*/ DECLARE @TableName AnsiString(8000) SET @TableName = 'AdditionalShelf' DECLARE @CurrentRecordId Int32 SET @CurrentRecordId = '3675192' dbo.GetValidDeviceForAlertProcessData 2025-12-28 11:44:50.4578 DFramework.Database.Query /* Time Taken: 2708*/ DECLARE @IsFileProcessed Int32 SET @IsFileProcessed = '0' DECLARE @TaskNumber Int32 SET @TaskNumber = '0' DECLARE @IsDeleted Int32 SET @IsDeleted = '0' SELECT TOP 1000 IncomingFileId, GatewayId,GatewayMac,RawFileName,AzureContainerName,StartIndex,Tries, CreatedOn FROM IncomingFile WHERE [IsFileProcessed] = @IsFileProcessed AND [TaskNumber] = @TaskNumber AND [IsDeleted] = @IsDeleted 2025-12-28 11:44:50.6766 DFramework.Database.Query /* Time Taken: 547*/ DECLARE @TableName AnsiString(8000) SET @TableName = 'AdditionalShelf' SELECT TableName FROM AlertProcessor WHERE [TableName] = @TableName 2025-12-28 11:44:50.8172 DFramework.Database.NullableDataReader Data reader open for 693 at System.Environment.GetStackTrace(Exception e, Boolean needFileInfo) at System.Environment.get_StackTrace() at DFramework.Database.NullableDataReader.Dispose(Boolean disposing) in D:\Spraxa\Framework\DFramework\Database\NullableDataReader.cs:line 33 at DFramework.Database.NullableDataReader.Dispose() in D:\Spraxa\Framework\DFramework\Database\NullableDataReader.cs:line 44 at CoolR.Tasks.ProcessAlertData.Execute() in D:\Spraxa\CoolR-Group\portal\CoolR.Tasks\ProcessAlertData.cs:line 47 at DFramework.Scheduler.TaskBase.Run() in D:\Spraxa\Framework\DFramework.Scheduler\TaskBase.cs:line 176 at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx) at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx) at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state) at System.Threading.ThreadHelper.ThreadStart() 2025-12-28 11:44:51.6922 DFramework.Database.Query /* Time Taken: 510*/ DECLARE @TableName AnsiString(8000) SET @TableName = 'OpportunityOutOfStock' SELECT TableName FROM AlertProcessor WHERE [TableName] = @TableName 2025-12-28 11:44:51.8329 DFramework.Database.NullableDataReader Data reader open for 655 at System.Environment.GetStackTrace(Exception e, Boolean needFileInfo) at System.Environment.get_StackTrace() at DFramework.Database.NullableDataReader.Dispose(Boolean disposing) in D:\Spraxa\Framework\DFramework\Database\NullableDataReader.cs:line 33 at DFramework.Database.NullableDataReader.Dispose() in D:\Spraxa\Framework\DFramework\Database\NullableDataReader.cs:line 44 at CoolR.Tasks.ProcessAlertData.Execute() in D:\Spraxa\CoolR-Group\portal\CoolR.Tasks\ProcessAlertData.cs:line 47 at DFramework.Scheduler.TaskBase.Run() in D:\Spraxa\Framework\DFramework.Scheduler\TaskBase.cs:line 176 at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx) at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx) at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state) at System.Threading.ThreadHelper.ThreadStart() 2025-12-28 11:44:52.4735 DFramework.Database.NullableDataReader Data reader open for 287 at System.Environment.GetStackTrace(Exception e, Boolean needFileInfo) at System.Environment.get_StackTrace() at DFramework.Database.NullableDataReader.Dispose(Boolean disposing) in D:\Spraxa\Framework\DFramework\Database\NullableDataReader.cs:line 33 at DFramework.Database.NullableDataReader.Dispose() in D:\Spraxa\Framework\DFramework\Database\NullableDataReader.cs:line 44 at CoolR.Tasks.ProcessAlertData.Execute() in D:\Spraxa\CoolR-Group\portal\CoolR.Tasks\ProcessAlertData.cs:line 47 at DFramework.Scheduler.TaskBase.Run() in D:\Spraxa\Framework\DFramework.Scheduler\TaskBase.cs:line 176 at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx) at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx) at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state) at System.Threading.ThreadHelper.ThreadStart() 2025-12-28 11:44:54.1610 DFramework.Database.Query /* Time Taken: 1335*/ DECLARE @TableName AnsiString(8000) SET @TableName = 'OpportunityOutOfStockConsolidate' SELECT TableName FROM AlertProcessor WHERE [TableName] = @TableName 2025-12-28 11:44:54.3016 DFramework.Database.NullableDataReader Data reader open for 1479 at System.Environment.GetStackTrace(Exception e, Boolean needFileInfo) at System.Environment.get_StackTrace() at DFramework.Database.NullableDataReader.Dispose(Boolean disposing) in D:\Spraxa\Framework\DFramework\Database\NullableDataReader.cs:line 33 at DFramework.Database.NullableDataReader.Dispose() in D:\Spraxa\Framework\DFramework\Database\NullableDataReader.cs:line 44 at CoolR.Tasks.ProcessAlertData.Execute() in D:\Spraxa\CoolR-Group\portal\CoolR.Tasks\ProcessAlertData.cs:line 47 at DFramework.Scheduler.TaskBase.Run() in D:\Spraxa\Framework\DFramework.Scheduler\TaskBase.cs:line 176 at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx) at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx) at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state) at System.Threading.ThreadHelper.ThreadStart() 2025-12-28 11:44:54.8641 DFramework.Database.Query /* Time Taken: 557*/ DECLARE @TableName AnsiString(8000) SET @TableName = 'AssetStockProductWiseConsolidate' DECLARE @CurrentRecordId Int32 SET @CurrentRecordId = '3675192' dbo.GetValidDeviceForAlertProcessData 2025-12-28 11:44:55.1610 DFramework.Database.NullableDataReader Data reader open for 289 at System.Environment.GetStackTrace(Exception e, Boolean needFileInfo) at System.Environment.get_StackTrace() at DFramework.Database.NullableDataReader.Dispose(Boolean disposing) in D:\Spraxa\Framework\DFramework\Database\NullableDataReader.cs:line 33 at DFramework.Database.NullableDataReader.Dispose() in D:\Spraxa\Framework\DFramework\Database\NullableDataReader.cs:line 44 at CoolR.Tasks.ProcessAlertData.Execute() in D:\Spraxa\CoolR-Group\portal\CoolR.Tasks\ProcessAlertData.cs:line 47 at DFramework.Scheduler.TaskBase.Run() in D:\Spraxa\Framework\DFramework.Scheduler\TaskBase.cs:line 176 at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx) at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx) at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state) at System.Threading.ThreadHelper.ThreadStart() 2025-12-28 11:44:56.0204 DFramework.Database.Query /* Time Taken: 515*/ DECLARE @TableName AnsiString(8000) SET @TableName = 'AssetStockProductWise' SELECT TableName FROM AlertProcessor WHERE [TableName] = @TableName 2025-12-28 11:44:57.3017 DFramework.Database.Query /* Time Taken: 1270*/ DECLARE @TableName AnsiString(8000) SET @TableName = 'AssetStockProductWise' DECLARE @ClientId Int32 SET @ClientId = '0' DECLARE @Table AnsiString(8000) SET @Table = 'AssetStockProductWise' DECLARE @PrimaryKey Int32 SET @PrimaryKey = '3675192' UPDATE dbo.AlertProcessor SET ClientId = @ClientId, TableName = @Table, PrimaryKey = @PrimaryKey WHERE [TableName] = @TableName AND (ClientId <> @ClientId OR TableName <> @Table OR PrimaryKey <> @PrimaryKey) 2025-12-28 11:44:57.3017 DFramework.Database.NullableDataReader Data reader open for 1788 at System.Environment.GetStackTrace(Exception e, Boolean needFileInfo) at System.Environment.get_StackTrace() at DFramework.Database.NullableDataReader.Dispose(Boolean disposing) in D:\Spraxa\Framework\DFramework\Database\NullableDataReader.cs:line 33 at DFramework.Database.NullableDataReader.Dispose() in D:\Spraxa\Framework\DFramework\Database\NullableDataReader.cs:line 44 at CoolR.Tasks.ProcessAlertData.Execute() in D:\Spraxa\CoolR-Group\portal\CoolR.Tasks\ProcessAlertData.cs:line 47 at DFramework.Scheduler.TaskBase.Run() in D:\Spraxa\Framework\DFramework.Scheduler\TaskBase.cs:line 176 at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx) at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx) at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state) at System.Threading.ThreadHelper.ThreadStart() 2025-12-28 11:44:57.9423 DFramework.Database.NullableDataReader Data reader open for 288 at System.Environment.GetStackTrace(Exception e, Boolean needFileInfo) at System.Environment.get_StackTrace() at DFramework.Database.NullableDataReader.Dispose(Boolean disposing) in D:\Spraxa\Framework\DFramework\Database\NullableDataReader.cs:line 33 at DFramework.Database.NullableDataReader.Dispose() in D:\Spraxa\Framework\DFramework\Database\NullableDataReader.cs:line 44 at CoolR.Tasks.ProcessAlertData.Execute() in D:\Spraxa\CoolR-Group\portal\CoolR.Tasks\ProcessAlertData.cs:line 47 at DFramework.Scheduler.TaskBase.Run() in D:\Spraxa\Framework\DFramework.Scheduler\TaskBase.cs:line 176 at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx) at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx) at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state) at System.Threading.ThreadHelper.ThreadStart() 2025-12-28 11:44:58.5829 DFramework.Database.NullableDataReader Data reader open for 288 at System.Environment.GetStackTrace(Exception e, Boolean needFileInfo) at System.Environment.get_StackTrace() at DFramework.Database.NullableDataReader.Dispose(Boolean disposing) in D:\Spraxa\Framework\DFramework\Database\NullableDataReader.cs:line 33 at DFramework.Database.NullableDataReader.Dispose() in D:\Spraxa\Framework\DFramework\Database\NullableDataReader.cs:line 44 at CoolR.Tasks.ProcessAlertData.Execute() in D:\Spraxa\CoolR-Group\portal\CoolR.Tasks\ProcessAlertData.cs:line 47 at DFramework.Scheduler.TaskBase.Run() in D:\Spraxa\Framework\DFramework.Scheduler\TaskBase.cs:line 176 at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx) at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx) at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state) at System.Threading.ThreadHelper.ThreadStart() 2025-12-28 11:44:59.2392 DFramework.Database.NullableDataReader Data reader open for 288 at System.Environment.GetStackTrace(Exception e, Boolean needFileInfo) at System.Environment.get_StackTrace() at DFramework.Database.NullableDataReader.Dispose(Boolean disposing) in D:\Spraxa\Framework\DFramework\Database\NullableDataReader.cs:line 33 at DFramework.Database.NullableDataReader.Dispose() in D:\Spraxa\Framework\DFramework\Database\NullableDataReader.cs:line 44 at CoolR.Tasks.ProcessAlertData.Execute() in D:\Spraxa\CoolR-Group\portal\CoolR.Tasks\ProcessAlertData.cs:line 47 at DFramework.Scheduler.TaskBase.Run() in D:\Spraxa\Framework\DFramework.Scheduler\TaskBase.cs:line 176 at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx) at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx) at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state) at System.Threading.ThreadHelper.ThreadStart() 2025-12-28 11:44:59.8798 DFramework.Database.NullableDataReader Data reader open for 288 at System.Environment.GetStackTrace(Exception e, Boolean needFileInfo) at System.Environment.get_StackTrace() at DFramework.Database.NullableDataReader.Dispose(Boolean disposing) in D:\Spraxa\Framework\DFramework\Database\NullableDataReader.cs:line 33 at DFramework.Database.NullableDataReader.Dispose() in D:\Spraxa\Framework\DFramework\Database\NullableDataReader.cs:line 44 at CoolR.Tasks.ProcessAlertData.Execute() in D:\Spraxa\CoolR-Group\portal\CoolR.Tasks\ProcessAlertData.cs:line 47 at DFramework.Scheduler.TaskBase.Run() in D:\Spraxa\Framework\DFramework.Scheduler\TaskBase.cs:line 176 at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx) at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx) at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state) at System.Threading.ThreadHelper.ThreadStart() 2025-12-28 11:45:00.8954 DFramework.Database.Query /* Time Taken: 513*/ DECLARE @TableName AnsiString(8000) SET @TableName = 'LowInventoryConsolidate' DECLARE @ClientId Int32 SET @ClientId = '0' DECLARE @Table AnsiString(8000) SET @Table = 'LowInventoryConsolidate' DECLARE @PrimaryKey Int32 SET @PrimaryKey = '3675192' UPDATE dbo.AlertProcessor SET ClientId = @ClientId, TableName = @Table, PrimaryKey = @PrimaryKey WHERE [TableName] = @TableName AND (ClientId <> @ClientId OR TableName <> @Table OR PrimaryKey <> @PrimaryKey) 2025-12-28 11:45:00.8954 DFramework.Database.NullableDataReader Data reader open for 658 at System.Environment.GetStackTrace(Exception e, Boolean needFileInfo) at System.Environment.get_StackTrace() at DFramework.Database.NullableDataReader.Dispose(Boolean disposing) in D:\Spraxa\Framework\DFramework\Database\NullableDataReader.cs:line 33 at DFramework.Database.NullableDataReader.Dispose() in D:\Spraxa\Framework\DFramework\Database\NullableDataReader.cs:line 44 at CoolR.Tasks.ProcessAlertData.Execute() in D:\Spraxa\CoolR-Group\portal\CoolR.Tasks\ProcessAlertData.cs:line 47 at DFramework.Scheduler.TaskBase.Run() in D:\Spraxa\Framework\DFramework.Scheduler\TaskBase.cs:line 176 at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx) at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx) at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state) at System.Threading.ThreadHelper.ThreadStart() 2025-12-28 11:45:01.7704 DFramework.Database.Query /* Time Taken: 513*/ DECLARE @TableName AnsiString(8000) SET @TableName = 'TargetPortfolioComplianceConsolidate' SELECT TableName FROM AlertProcessor WHERE [TableName] = @TableName 2025-12-28 11:45:02.4892 DFramework.Database.Query /* Time Taken: 717*/ DECLARE @TableName AnsiString(8000) SET @TableName = 'TargetPortfolioComplianceConsolidate' DECLARE @ClientId Int32 SET @ClientId = '0' DECLARE @Table AnsiString(8000) SET @Table = 'TargetPortfolioComplianceConsolidate' DECLARE @PrimaryKey Int32 SET @PrimaryKey = '3675192' UPDATE dbo.AlertProcessor SET ClientId = @ClientId, TableName = @Table, PrimaryKey = @PrimaryKey WHERE [TableName] = @TableName AND (ClientId <> @ClientId OR TableName <> @Table OR PrimaryKey <> @PrimaryKey) 2025-12-28 11:45:02.4892 DFramework.Database.NullableDataReader Data reader open for 1231 at System.Environment.GetStackTrace(Exception e, Boolean needFileInfo) at System.Environment.get_StackTrace() at DFramework.Database.NullableDataReader.Dispose(Boolean disposing) in D:\Spraxa\Framework\DFramework\Database\NullableDataReader.cs:line 33 at DFramework.Database.NullableDataReader.Dispose() in D:\Spraxa\Framework\DFramework\Database\NullableDataReader.cs:line 44 at CoolR.Tasks.ProcessAlertData.Execute() in D:\Spraxa\CoolR-Group\portal\CoolR.Tasks\ProcessAlertData.cs:line 47 at DFramework.Scheduler.TaskBase.Run() in D:\Spraxa\Framework\DFramework.Scheduler\TaskBase.cs:line 176 at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx) at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx) at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state) at System.Threading.ThreadHelper.ThreadStart() 2025-12-28 11:45:03.0048 AlertProcessor ProcessorAlertData: Stopped 2025-12-28 11:45:03.0048 DFramework.Scheduler.TaskBase /* Time Taken: 16015.7405*/ Process Alert Record 2025-12-28 11:49:47.0069 AlertProcessor ProcessorAlertData: started 2025-12-28 11:49:52.5851 AlertProcessor ProcessorAlertData: Stopped 2025-12-28 11:54:47.0248 AlertProcessor ProcessorAlertData: started 2025-12-28 11:54:52.6811 AlertProcessor ProcessorAlertData: Stopped 2025-12-28 11:54:57.4311 DFramework.Scheduler.TaskBase /* Time Taken: 15718.8748*/ Opportunity Out Of Stock By Outlet 2025-12-28 11:59:47.0426 AlertProcessor ProcessorAlertData: started 2025-12-28 11:59:52.6052 AlertProcessor ProcessorAlertData: Stopped 2025-12-28 12:04:47.0605 AlertProcessor ProcessorAlertData: started 2025-12-28 12:04:52.7480 AlertProcessor ProcessorAlertData: Stopped 2025-12-28 12:09:47.0784 AlertProcessor ProcessorAlertData: started 2025-12-28 12:09:52.5940 DFramework.Database.Query /* Time Taken: 505*/ DECLARE @TableName AnsiString(8000) SET @TableName = 'ProductStockLevel' DECLARE @CurrentRecordId Int32 SET @CurrentRecordId = '3675192' dbo.GetValidDeviceForAlertProcessData 2025-12-28 12:09:52.6565 AlertProcessor ProcessorAlertData: Stopped 2025-12-28 12:09:57.5316 DFramework.Scheduler.TaskBase /* Time Taken: 15796.9937*/ Opportunity Out Of Stock By Outlet 2025-12-28 12:14:47.0962 AlertProcessor ProcessorAlertData: started 2025-12-28 12:14:52.6900 AlertProcessor ProcessorAlertData: Stopped 2025-12-28 12:19:47.1141 AlertProcessor ProcessorAlertData: started 2025-12-28 12:19:52.7235 AlertProcessor ProcessorAlertData: Stopped 2025-12-28 12:24:47.1320 AlertProcessor ProcessorAlertData: started 2025-12-28 12:24:52.7883 AlertProcessor ProcessorAlertData: Stopped 2025-12-28 12:24:57.4914 DFramework.Scheduler.TaskBase /* Time Taken: 15750.1193*/ Opportunity Out Of Stock By Outlet 2025-12-28 12:29:47.1498 AlertProcessor ProcessorAlertData: started 2025-12-28 12:29:52.7749 AlertProcessor ProcessorAlertData: Stopped 2025-12-28 12:34:47.1677 AlertProcessor ProcessorAlertData: started 2025-12-28 12:34:52.7459 AlertProcessor ProcessorAlertData: Stopped 2025-12-28 12:39:47.1855 AlertProcessor ProcessorAlertData: started 2025-12-28 12:39:52.7012 AlertProcessor ProcessorAlertData: Stopped 2025-12-28 12:39:57.6075 DFramework.Scheduler.TaskBase /* Time Taken: 15843.8627*/ Opportunity Out Of Stock By Outlet 2025-12-28 12:44:47.2034 AlertProcessor ProcessorAlertData: started 2025-12-28 12:44:52.9534 DFramework.Database.NullableDataReader Data reader open for 273 at System.Environment.GetStackTrace(Exception e, Boolean needFileInfo) at System.Environment.get_StackTrace() at DFramework.Database.NullableDataReader.Dispose(Boolean disposing) in D:\Spraxa\Framework\DFramework\Database\NullableDataReader.cs:line 33 at DFramework.Database.NullableDataReader.Dispose() in D:\Spraxa\Framework\DFramework\Database\NullableDataReader.cs:line 44 at CoolR.Tasks.ProcessAlertData.Execute() in D:\Spraxa\CoolR-Group\portal\CoolR.Tasks\ProcessAlertData.cs:line 47 at DFramework.Scheduler.TaskBase.Run() in D:\Spraxa\Framework\DFramework.Scheduler\TaskBase.cs:line 176 at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx) at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx) at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state) at System.Threading.ThreadHelper.ThreadStart() 2025-12-28 12:44:52.9534 AlertProcessor ProcessorAlertData: Stopped 2025-12-28 12:49:47.2056 AlertProcessor ProcessorAlertData: started 2025-12-28 12:49:52.2994 AlertProcessor ProcessorAlertData: Stopped 2025-12-28 12:54:47.2235 AlertProcessor ProcessorAlertData: started 2025-12-28 12:54:52.9423 AlertProcessor ProcessorAlertData: Stopped 2025-12-28 12:54:57.5517 DFramework.Scheduler.TaskBase /* Time Taken: 15765.7404*/ Opportunity Out Of Stock By Outlet 2025-12-28 12:59:47.2413 AlertProcessor ProcessorAlertData: started 2025-12-28 12:59:52.8039 AlertProcessor ProcessorAlertData: Stopped 2025-12-28 13:04:47.2592 AlertProcessor ProcessorAlertData: started 2025-12-28 13:04:52.7123 AlertProcessor ProcessorAlertData: Stopped 2025-12-28 13:09:47.2770 AlertProcessor ProcessorAlertData: started 2025-12-28 13:09:52.1677 DFramework.Database.NullableDataReader Data reader open for 280 at System.Environment.GetStackTrace(Exception e, Boolean needFileInfo) at System.Environment.get_StackTrace() at DFramework.Database.NullableDataReader.Dispose(Boolean disposing) in D:\Spraxa\Framework\DFramework\Database\NullableDataReader.cs:line 33 at DFramework.Database.NullableDataReader.Dispose() in D:\Spraxa\Framework\DFramework\Database\NullableDataReader.cs:line 44 at CoolR.Tasks.ProcessAlertData.Execute() in D:\Spraxa\CoolR-Group\portal\CoolR.Tasks\ProcessAlertData.cs:line 47 at DFramework.Scheduler.TaskBase.Run() in D:\Spraxa\Framework\DFramework.Scheduler\TaskBase.cs:line 176 at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx) at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx) at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state) at System.Threading.ThreadHelper.ThreadStart() 2025-12-28 13:09:53.0114 AlertProcessor ProcessorAlertData: Stopped 2025-12-28 13:09:57.6677 DFramework.Scheduler.TaskBase /* Time Taken: 15859.4918*/ Opportunity Out Of Stock By Outlet 2025-12-28 13:14:47.2949 AlertProcessor ProcessorAlertData: started 2025-12-28 13:14:52.7793 AlertProcessor ProcessorAlertData: Stopped 2025-12-28 13:19:47.3127 AlertProcessor ProcessorAlertData: started 2025-12-28 13:19:52.8909 AlertProcessor ProcessorAlertData: Stopped 2025-12-28 13:24:42.7368 DFramework.Database.Query /* Time Taken: 618*/ [dbo].GenerateSystemAlerts 2025-12-28 13:24:47.3306 AlertProcessor ProcessorAlertData: started 2025-12-28 13:24:52.7837 AlertProcessor ProcessorAlertData: Stopped 2025-12-28 13:24:57.7838 DFramework.Scheduler.TaskBase /* Time Taken: 15953.2416*/ Opportunity Out Of Stock By Outlet 2025-12-28 13:29:47.3484 AlertProcessor ProcessorAlertData: started 2025-12-28 13:29:52.6609 AlertProcessor ProcessorAlertData: Stopped 2025-12-28 13:34:47.3663 AlertProcessor ProcessorAlertData: started 2025-12-28 13:34:49.0381 DFramework.Database.Query /* Time Taken: 521*/ DECLARE @TableName AnsiString(8000) SET @TableName = 'AdditionalShelf' DECLARE @CurrentRecordId Int32 SET @CurrentRecordId = '3675192' dbo.GetValidDeviceForAlertProcessData 2025-12-28 13:34:53.0225 AlertProcessor ProcessorAlertData: Stopped 2025-12-28 13:39:47.3841 AlertProcessor ProcessorAlertData: started 2025-12-28 13:39:53.0560 AlertProcessor ProcessorAlertData: Stopped 2025-12-28 13:39:57.6186 DFramework.Scheduler.TaskBase /* Time Taken: 15765.7414*/ Opportunity Out Of Stock By Outlet 2025-12-28 13:44:47.4020 AlertProcessor ProcessorAlertData: started 2025-12-28 13:44:53.1208 AlertProcessor ProcessorAlertData: Stopped 2025-12-28 13:49:47.4198 AlertProcessor ProcessorAlertData: started 2025-12-28 13:49:53.0136 AlertProcessor ProcessorAlertData: Stopped 2025-12-28 13:54:47.4377 AlertProcessor ProcessorAlertData: started 2025-12-28 13:54:52.9377 AlertProcessor ProcessorAlertData: Stopped 2025-12-28 13:54:57.6409 DFramework.Scheduler.TaskBase /* Time Taken: 15765.7463*/ Opportunity Out Of Stock By Outlet 2025-12-28 13:59:47.4555 AlertProcessor ProcessorAlertData: started 2025-12-28 13:59:52.9243 AlertProcessor ProcessorAlertData: Stopped 2025-12-28 14:04:47.4734 AlertProcessor ProcessorAlertData: started 2025-12-28 14:04:52.9422 AlertProcessor ProcessorAlertData: Stopped 2025-12-28 14:09:42.7256 DFramework.Database.Query /* Time Taken: 540*/ [dbo].GenerateSystemAlerts 2025-12-28 14:09:47.4913 AlertProcessor ProcessorAlertData: started 2025-12-28 14:09:52.8351 AlertProcessor ProcessorAlertData: Stopped 2025-12-28 14:09:57.8664 DFramework.Scheduler.TaskBase /* Time Taken: 15968.8786*/ Opportunity Out Of Stock By Outlet 2025-12-28 14:14:47.4935 AlertProcessor ProcessorAlertData: started 2025-12-28 14:14:53.0092 AlertProcessor ProcessorAlertData: Stopped 2025-12-28 14:19:47.4958 AlertProcessor ProcessorAlertData: started 2025-12-28 14:19:53.0427 AlertProcessor ProcessorAlertData: Stopped 2025-12-28 14:24:47.5137 AlertProcessor ProcessorAlertData: started 2025-12-28 14:24:53.0762 AlertProcessor ProcessorAlertData: Stopped 2025-12-28 14:24:57.6856 DFramework.Scheduler.TaskBase /* Time Taken: 15765.7421*/ Opportunity Out Of Stock By Outlet 2025-12-28 14:29:47.5159 AlertProcessor ProcessorAlertData: started 2025-12-28 14:29:52.9847 AlertProcessor ProcessorAlertData: Stopped 2025-12-28 14:34:47.5338 AlertProcessor ProcessorAlertData: started 2025-12-28 14:34:52.9869 AlertProcessor ProcessorAlertData: Stopped 2025-12-28 14:39:47.5516 AlertProcessor ProcessorAlertData: started 2025-12-28 14:39:53.0985 AlertProcessor ProcessorAlertData: Stopped 2025-12-28 14:39:57.7079 DFramework.Scheduler.TaskBase /* Time Taken: 15765.7425*/ Opportunity Out Of Stock By Outlet 2025-12-28 14:44:47.5538 AlertProcessor ProcessorAlertData: started 2025-12-28 14:44:53.0851 AlertProcessor ProcessorAlertData: Stopped 2025-12-28 14:49:47.5561 AlertProcessor ProcessorAlertData: started 2025-12-28 14:49:53.0717 AlertProcessor ProcessorAlertData: Stopped 2025-12-28 14:54:47.5739 AlertProcessor ProcessorAlertData: started 2025-12-28 14:54:53.2146 AlertProcessor ProcessorAlertData: Stopped 2025-12-28 14:54:57.6833 DFramework.Scheduler.TaskBase /* Time Taken: 15718.8663*/ Opportunity Out Of Stock By Outlet 2025-12-28 14:59:47.5761 AlertProcessor ProcessorAlertData: started 2025-12-28 14:59:53.1074 AlertProcessor ProcessorAlertData: Stopped 2025-12-28 15:04:47.5940 AlertProcessor ProcessorAlertData: started 2025-12-28 15:04:53.0940 AlertProcessor ProcessorAlertData: Stopped 2025-12-28 15:09:47.6118 AlertProcessor ProcessorAlertData: started 2025-12-28 15:09:53.2056 AlertProcessor ProcessorAlertData: Stopped 2025-12-28 15:09:57.7056 DFramework.Scheduler.TaskBase /* Time Taken: 15718.8627*/ Opportunity Out Of Stock By Outlet 2025-12-28 15:14:47.6296 AlertProcessor ProcessorAlertData: started 2025-12-28 15:14:53.1453 AlertProcessor ProcessorAlertData: Stopped 2025-12-28 15:19:47.6475 AlertProcessor ProcessorAlertData: started 2025-12-28 15:19:53.2413 AlertProcessor ProcessorAlertData: Stopped 2025-12-28 15:24:47.6497 AlertProcessor ProcessorAlertData: started 2025-12-28 15:24:53.2591 AlertProcessor ProcessorAlertData: Stopped 2025-12-28 15:24:57.7123 DFramework.Scheduler.TaskBase /* Time Taken: 15703.2451*/ Opportunity Out Of Stock By Outlet 2025-12-28 15:29:47.6676 AlertProcessor ProcessorAlertData: started 2025-12-28 15:29:50.7301 DFramework.Database.Query /* Time Taken: 531*/ DECLARE @TableName AnsiString(8000) SET @TableName = 'AssetStockProductWiseConsolidate' DECLARE @CurrentRecordId Int32 SET @CurrentRecordId = '3675192' dbo.GetValidDeviceForAlertProcessData 2025-12-28 15:29:53.3395 AlertProcessor ProcessorAlertData: Stopped 2025-12-28 15:34:47.6854 AlertProcessor ProcessorAlertData: started 2025-12-28 15:34:53.1854 AlertProcessor ProcessorAlertData: Stopped 2025-12-28 15:39:47.7033 AlertProcessor ProcessorAlertData: started 2025-12-28 15:39:53.3752 AlertProcessor ProcessorAlertData: Stopped 2025-12-28 15:39:57.7814 DFramework.Scheduler.TaskBase /* Time Taken: 15750.1161*/ Opportunity Out Of Stock By Outlet 2025-12-28 15:44:47.7055 AlertProcessor ProcessorAlertData: started 2025-12-28 15:44:48.2367 DFramework.Database.Query /* Time Taken: 535*/ DECLARE @TableName AnsiString(8000) SET @TableName = 'TagAlert' DECLARE @CurrentRecordId Int32 SET @CurrentRecordId = '0' dbo.GetValidDeviceForAlertProcessData 2025-12-28 15:44:53.4399 AlertProcessor ProcessorAlertData: Stopped 2025-12-28 15:49:47.7078 AlertProcessor ProcessorAlertData: started 2025-12-28 15:49:53.2391 AlertProcessor ProcessorAlertData: Stopped 2025-12-28 15:54:47.7256 AlertProcessor ProcessorAlertData: started 2025-12-28 15:54:53.3976 AlertProcessor ProcessorAlertData: Stopped 2025-12-28 15:54:57.8038 DFramework.Scheduler.TaskBase /* Time Taken: 15750.1161*/ Opportunity Out Of Stock By Outlet 2025-12-28 15:59:47.7279 AlertProcessor ProcessorAlertData: started 2025-12-28 15:59:53.2435 AlertProcessor ProcessorAlertData: Stopped 2025-12-28 16:04:47.7457 AlertProcessor ProcessorAlertData: started 2025-12-28 16:04:53.4333 DFramework.Database.Query /* Time Taken: 555*/ DECLARE @TableName AnsiString(8000) SET @TableName = 'ProductStockLevel' DECLARE @CurrentRecordId Int32 SET @CurrentRecordId = '3675192' dbo.GetValidDeviceForAlertProcessData 2025-12-28 16:04:53.4802 AlertProcessor ProcessorAlertData: Stopped 2025-12-28 16:09:47.7636 AlertProcessor ProcessorAlertData: started 2025-12-28 16:09:53.3886 AlertProcessor ProcessorAlertData: Stopped 2025-12-28 16:09:57.8105 DFramework.Scheduler.TaskBase /* Time Taken: 15734.4897*/ Opportunity Out Of Stock By Outlet 2025-12-28 16:14:47.7814 AlertProcessor ProcessorAlertData: started 2025-12-28 16:14:53.3127 AlertProcessor ProcessorAlertData: Stopped 2025-12-28 16:19:47.7993 AlertProcessor ProcessorAlertData: started 2025-12-28 16:19:53.3150 AlertProcessor ProcessorAlertData: Stopped 2025-12-28 16:24:47.8015 AlertProcessor ProcessorAlertData: started 2025-12-28 16:24:53.4422 AlertProcessor ProcessorAlertData: Stopped 2025-12-28 16:24:57.8641 DFramework.Scheduler.TaskBase /* Time Taken: 15765.7443*/ Opportunity Out Of Stock By Outlet 2025-12-28 16:29:47.8038 AlertProcessor ProcessorAlertData: started 2025-12-28 16:29:53.3663 AlertProcessor ProcessorAlertData: Stopped 2025-12-28 16:34:47.8060 AlertProcessor ProcessorAlertData: started 2025-12-28 16:34:53.3686 DFramework.Database.Query /* Time Taken: 590*/ DECLARE @TableName AnsiString(8000) SET @TableName = 'TargetPortfolioComplianceConsolidate' SELECT TableName FROM AlertProcessor WHERE [TableName] = @TableName 2025-12-28 16:34:54.5404 DFramework.Database.Query /* Time Taken: 1171*/ DECLARE @TableName AnsiString(8000) SET @TableName = 'TargetPortfolioComplianceConsolidate' DECLARE @ClientId Int32 SET @ClientId = '0' DECLARE @Table AnsiString(8000) SET @Table = 'TargetPortfolioComplianceConsolidate' DECLARE @PrimaryKey Int32 SET @PrimaryKey = '3675192' UPDATE dbo.AlertProcessor SET ClientId = @ClientId, TableName = @Table, PrimaryKey = @PrimaryKey WHERE [TableName] = @TableName AND (ClientId <> @ClientId OR TableName <> @Table OR PrimaryKey <> @PrimaryKey) 2025-12-28 16:34:54.5404 DFramework.Database.NullableDataReader Data reader open for 1763 at System.Environment.GetStackTrace(Exception e, Boolean needFileInfo) at System.Environment.get_StackTrace() at DFramework.Database.NullableDataReader.Dispose(Boolean disposing) in D:\Spraxa\Framework\DFramework\Database\NullableDataReader.cs:line 33 at DFramework.Database.NullableDataReader.Dispose() in D:\Spraxa\Framework\DFramework\Database\NullableDataReader.cs:line 44 at CoolR.Tasks.ProcessAlertData.Execute() in D:\Spraxa\CoolR-Group\portal\CoolR.Tasks\ProcessAlertData.cs:line 47 at DFramework.Scheduler.TaskBase.Run() in D:\Spraxa\Framework\DFramework.Scheduler\TaskBase.cs:line 176 at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx) at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx) at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state) at System.Threading.ThreadHelper.ThreadStart() 2025-12-28 16:34:55.0404 AlertProcessor ProcessorAlertData: Stopped 2025-12-28 16:39:47.8083 AlertProcessor ProcessorAlertData: started 2025-12-28 16:39:53.3396 AlertProcessor ProcessorAlertData: Stopped 2025-12-28 16:39:57.8865 DFramework.Scheduler.TaskBase /* Time Taken: 15765.7384*/ Opportunity Out Of Stock By Outlet 2025-12-28 16:44:47.8105 AlertProcessor ProcessorAlertData: started 2025-12-28 16:44:53.3887 AlertProcessor ProcessorAlertData: Stopped 2025-12-28 16:49:47.8127 AlertProcessor ProcessorAlertData: started 2025-12-28 16:49:53.4377 AlertProcessor ProcessorAlertData: Stopped 2025-12-28 16:54:47.8149 AlertProcessor ProcessorAlertData: started 2025-12-28 16:54:53.4243 AlertProcessor ProcessorAlertData: Stopped 2025-12-28 16:54:57.8306 DFramework.Scheduler.TaskBase /* Time Taken: 15687.6204*/ Opportunity Out Of Stock By Outlet 2025-12-28 16:59:47.8328 AlertProcessor ProcessorAlertData: started 2025-12-28 16:59:53.4266 AlertProcessor ProcessorAlertData: Stopped 2025-12-28 17:04:47.8350 AlertProcessor ProcessorAlertData: started 2025-12-28 17:04:53.4288 AlertProcessor ProcessorAlertData: Stopped 2025-12-28 17:09:47.8529 AlertProcessor ProcessorAlertData: started 2025-12-28 17:09:53.4935 AlertProcessor ProcessorAlertData: Stopped 2025-12-28 17:09:57.9779 DFramework.Scheduler.TaskBase /* Time Taken: 15812.6154*/ Opportunity Out Of Stock By Outlet 2025-12-28 17:14:47.8707 AlertProcessor ProcessorAlertData: started 2025-12-28 17:14:53.5426 AlertProcessor ProcessorAlertData: Stopped 2025-12-28 17:19:47.8886 AlertProcessor ProcessorAlertData: started 2025-12-28 17:19:53.5761 AlertProcessor ProcessorAlertData: Stopped 2025-12-28 17:24:47.9064 AlertProcessor ProcessorAlertData: started 2025-12-28 17:24:53.4846 AlertProcessor ProcessorAlertData: Stopped 2025-12-28 17:24:57.9221 DFramework.Scheduler.TaskBase /* Time Taken: 15734.5002*/ Opportunity Out Of Stock By Outlet 2025-12-28 17:29:47.9243 AlertProcessor ProcessorAlertData: started 2025-12-28 17:29:53.4712 AlertProcessor ProcessorAlertData: Stopped 2025-12-28 17:34:47.9265 AlertProcessor ProcessorAlertData: started 2025-12-28 17:34:53.5047 AlertProcessor ProcessorAlertData: Stopped 2025-12-28 17:39:47.9287 AlertProcessor ProcessorAlertData: started 2025-12-28 17:39:53.4131 AlertProcessor ProcessorAlertData: Stopped 2025-12-28 17:39:57.9132 DFramework.Scheduler.TaskBase /* Time Taken: 15703.242*/ Opportunity Out Of Stock By Outlet 2025-12-28 17:44:47.9465 AlertProcessor ProcessorAlertData: started 2025-12-28 17:44:51.0247 DFramework.Database.Query /* Time Taken: 560*/ DECLARE @TableName AnsiString(8000) SET @TableName = 'AssetStockProductWiseConsolidate' DECLARE @CurrentRecordId Int32 SET @CurrentRecordId = '3675192' dbo.GetValidDeviceForAlertProcessData 2025-12-28 17:44:53.6810 AlertProcessor ProcessorAlertData: Stopped 2025-12-28 17:49:47.9644 AlertProcessor ProcessorAlertData: started 2025-12-28 17:49:53.5894 AlertProcessor ProcessorAlertData: Stopped 2025-12-28 17:54:47.9822 AlertProcessor ProcessorAlertData: started 2025-12-28 17:54:53.6073 AlertProcessor ProcessorAlertData: Stopped 2025-12-28 17:54:57.9979 DFramework.Scheduler.TaskBase /* Time Taken: 15765.7415*/ Opportunity Out Of Stock By Outlet 2025-12-28 17:59:48.0001 AlertProcessor ProcessorAlertData: started 2025-12-28 17:59:53.5001 AlertProcessor ProcessorAlertData: Stopped 2025-12-28 18:04:48.0180 AlertProcessor ProcessorAlertData: started 2025-12-28 18:04:53.4867 AlertProcessor ProcessorAlertData: Stopped 2025-12-28 18:09:43.1451 DFramework.Database.Query /* Time Taken: 636*/ [dbo].GenerateSystemAlerts 2025-12-28 18:09:48.0202 AlertProcessor ProcessorAlertData: started 2025-12-28 18:09:53.4421 AlertProcessor ProcessorAlertData: Stopped 2025-12-28 18:09:58.1453 DFramework.Scheduler.TaskBase /* Time Taken: 15890.7463*/ Opportunity Out Of Stock By Outlet 2025-12-28 18:14:48.0380 AlertProcessor ProcessorAlertData: started 2025-12-28 18:14:53.4287 AlertProcessor ProcessorAlertData: Stopped 2025-12-28 18:19:48.0559 AlertProcessor ProcessorAlertData: started 2025-12-28 18:19:53.4778 AlertProcessor ProcessorAlertData: Stopped 2025-12-28 18:24:48.0737 AlertProcessor ProcessorAlertData: started 2025-12-28 18:24:53.4644 AlertProcessor ProcessorAlertData: Stopped 2025-12-28 18:24:57.9957 DFramework.Scheduler.TaskBase /* Time Taken: 15718.867*/ Opportunity Out Of Stock By Outlet 2025-12-28 18:29:48.0916 AlertProcessor ProcessorAlertData: started 2025-12-28 18:29:53.6072 AlertProcessor ProcessorAlertData: Stopped 2025-12-28 18:34:44.1563 MoveToReorder Running task for ClientId : 286 and ClientName = India Office QA and Slot: 12/29/2025 8:00:00 AM And LastExecutedOn: 12/27/2025 10:04:40 PM 2025-12-28 18:34:44.9063 DFramework.Database.Query /* Time Taken: 696*/ DECLARE @OrderStatusId Int32 SET @OrderStatusId = '0' DECLARE @ClientId Int32 SET @ClientId = '286' dbo.GetOrderDetailsByClientId 2025-12-28 18:34:48.1094 AlertProcessor ProcessorAlertData: started 2025-12-28 18:34:49.3282 DFramework.Database.Query /* Time Taken: 522*/ DECLARE @TableName AnsiString(8000) SET @TableName = 'MissingShelf' DECLARE @CurrentRecordId Int32 SET @CurrentRecordId = '3675192' dbo.GetValidDeviceForAlertProcessData 2025-12-28 18:34:51.3126 DFramework.Database.Query /* Time Taken: 1926*/ DECLARE @TableName AnsiString(8000) SET @TableName = 'AdditionalShelf' DECLARE @CurrentRecordId Int32 SET @CurrentRecordId = '3675192' dbo.GetValidDeviceForAlertProcessData 2025-12-28 18:34:55.1563 AlertProcessor ProcessorAlertData: Stopped 2025-12-28 18:35:28.4066 DFramework.Database.NullableDataReader Data reader open for 43283 at System.Environment.GetStackTrace(Exception e, Boolean needFileInfo) at System.Environment.get_StackTrace() at DFramework.Database.NullableDataReader.Dispose(Boolean disposing) in D:\Spraxa\Framework\DFramework\Database\NullableDataReader.cs:line 33 at DFramework.Database.NullableDataReader.Dispose() in D:\Spraxa\Framework\DFramework\Database\NullableDataReader.cs:line 44 at CoolR.Tasks.MoveToReorder.Execute() in D:\Spraxa\CoolR-Group\portal\CoolR.Tasks\MoveToReorder.cs:line 44 at DFramework.Scheduler.TaskBase.Run() in D:\Spraxa\Framework\DFramework.Scheduler\TaskBase.cs:line 176 at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx) at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx) at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state) at System.Threading.ThreadHelper.ThreadStart() 2025-12-28 18:35:28.4378 MoveToReorder Task executed successfully for ClientId : 286 Client Name:India Office QA, Slot: 12/29/2025 8:00:00 AM and Total Order Suggested: 129 Out Of: 129 2025-12-28 18:35:29.0941 DFramework.Database.Query /* Time Taken: 657*/ DECLARE @ClientId Int32 SET @ClientId = '286' dbo.GetMoveToReOrderList 2025-12-28 18:35:30.1410 DFramework.Scheduler.TaskBase /* Time Taken: 46297.2147*/ Move To Re-Order 2025-12-28 18:39:48.1114 AlertProcessor ProcessorAlertData: started 2025-12-28 18:39:53.4864 AlertProcessor ProcessorAlertData: Stopped 2025-12-28 18:39:58.0021 DFramework.Scheduler.TaskBase /* Time Taken: 15703.2281*/ Opportunity Out Of Stock By Outlet 2025-12-28 18:44:48.1135 AlertProcessor ProcessorAlertData: started 2025-12-28 18:44:53.5979 AlertProcessor ProcessorAlertData: Stopped 2025-12-28 18:49:48.1157 AlertProcessor ProcessorAlertData: started 2025-12-28 18:49:53.5376 AlertProcessor ProcessorAlertData: Stopped 2025-12-28 18:54:48.1335 AlertProcessor ProcessorAlertData: started 2025-12-28 18:54:53.5554 AlertProcessor ProcessorAlertData: Stopped 2025-12-28 18:54:58.0242 DFramework.Scheduler.TaskBase /* Time Taken: 15703.2111*/ Opportunity Out Of Stock By Outlet 2025-12-28 18:59:48.1355 AlertProcessor ProcessorAlertData: started 2025-12-28 18:59:49.9481 DFramework.Database.NullableDataReader Data reader open for 276 at System.Environment.GetStackTrace(Exception e, Boolean needFileInfo) at System.Environment.get_StackTrace() at DFramework.Database.NullableDataReader.Dispose(Boolean disposing) in D:\Spraxa\Framework\DFramework\Database\NullableDataReader.cs:line 33 at DFramework.Database.NullableDataReader.Dispose() in D:\Spraxa\Framework\DFramework\Database\NullableDataReader.cs:line 44 at CoolR.Tasks.ProcessAlertData.Execute() in D:\Spraxa\CoolR-Group\portal\CoolR.Tasks\ProcessAlertData.cs:line 47 at DFramework.Scheduler.TaskBase.Run() in D:\Spraxa\Framework\DFramework.Scheduler\TaskBase.cs:line 176 at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx) at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx) at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state) at System.Threading.ThreadHelper.ThreadStart() 2025-12-28 18:59:53.7762 AlertProcessor ProcessorAlertData: Stopped 2025-12-28 19:04:48.1534 AlertProcessor ProcessorAlertData: started 2025-12-28 19:04:53.8097 AlertProcessor ProcessorAlertData: Stopped 2025-12-28 19:09:43.1087 DFramework.Database.Query /* Time Taken: 503*/ [dbo].GenerateSystemAlerts 2025-12-28 19:09:48.1712 AlertProcessor ProcessorAlertData: started 2025-12-28 19:09:53.7494 AlertProcessor ProcessorAlertData: Stopped 2025-12-28 19:09:58.0932 DFramework.Scheduler.TaskBase /* Time Taken: 15750.1351*/ Opportunity Out Of Stock By Outlet 2025-12-28 19:14:48.1888 AlertProcessor ProcessorAlertData: started 2025-12-28 19:14:53.7045 AlertProcessor ProcessorAlertData: Stopped 2025-12-28 19:19:48.2066 AlertProcessor ProcessorAlertData: started 2025-12-28 19:19:53.8941 AlertProcessor ProcessorAlertData: Stopped 2025-12-28 19:24:48.2244 AlertProcessor ProcessorAlertData: started 2025-12-28 19:24:53.7870 AlertProcessor ProcessorAlertData: Stopped 2025-12-28 19:24:58.0682 DFramework.Scheduler.TaskBase /* Time Taken: 15703.2412*/ Opportunity Out Of Stock By Outlet 2025-12-28 19:29:48.2422 AlertProcessor ProcessorAlertData: started 2025-12-28 19:29:53.7891 AlertProcessor ProcessorAlertData: Stopped 2025-12-28 19:34:44.2598 MoveToReorder Running task for ClientId : 286 and ClientName = India Office QA and Slot: 12/29/2025 9:00:00 AM And LastExecutedOn: 12/29/2025 8:04:44 AM 2025-12-28 19:34:44.4786 MoveToReorder Task executed successfully for ClientId : 286 Client Name:India Office QA, Slot: 12/29/2025 9:00:00 AM But No Order found to suggest 2025-12-28 19:34:48.2598 AlertProcessor ProcessorAlertData: started 2025-12-28 19:34:53.7911 AlertProcessor ProcessorAlertData: Stopped 2025-12-28 19:39:48.2777 AlertProcessor ProcessorAlertData: started 2025-12-28 19:39:53.7621 AlertProcessor ProcessorAlertData: Stopped 2025-12-28 19:39:58.0902 DFramework.Scheduler.TaskBase /* Time Taken: 15703.2443*/ Opportunity Out Of Stock By Outlet 2025-12-28 19:44:48.2955 AlertProcessor ProcessorAlertData: started 2025-12-28 19:44:53.7956 AlertProcessor ProcessorAlertData: Stopped 2025-12-28 19:49:48.3133 AlertProcessor ProcessorAlertData: started 2025-12-28 19:49:53.8289 AlertProcessor ProcessorAlertData: Stopped 2025-12-28 19:54:48.3310 AlertProcessor ProcessorAlertData: started 2025-12-28 19:54:53.9405 DFramework.Database.Query /* Time Taken: 526*/ DECLARE @TableName AnsiString(8000) SET @TableName = 'ProductStockLevel' DECLARE @CurrentRecordId Int32 SET @CurrentRecordId = '3675192' dbo.GetValidDeviceForAlertProcessData 2025-12-28 19:54:54.0030 AlertProcessor ProcessorAlertData: Stopped 2025-12-28 19:54:58.1124 DFramework.Scheduler.TaskBase /* Time Taken: 15703.2414*/ Opportunity Out Of Stock By Outlet 2025-12-28 19:59:48.3489 AlertProcessor ProcessorAlertData: started 2025-12-28 19:59:53.8646 AlertProcessor ProcessorAlertData: Stopped 2025-12-28 20:04:48.3667 AlertProcessor ProcessorAlertData: started 2025-12-28 20:04:53.9917 AlertProcessor ProcessorAlertData: Stopped 2025-12-28 20:09:48.3845 AlertProcessor ProcessorAlertData: started 2025-12-28 20:09:53.9314 AlertProcessor ProcessorAlertData: Stopped 2025-12-28 20:09:58.1971 DFramework.Scheduler.TaskBase /* Time Taken: 15765.743*/ Opportunity Out Of Stock By Outlet 2025-12-28 20:14:48.4023 AlertProcessor ProcessorAlertData: started 2025-12-28 20:14:53.9649 AlertProcessor ProcessorAlertData: Stopped 2025-12-28 20:19:48.4170 AlertProcessor ProcessorAlertData: started 2025-12-28 20:19:54.1514 AlertProcessor ProcessorAlertData: Stopped 2025-12-28 20:24:48.4348 AlertProcessor ProcessorAlertData: started 2025-12-28 20:24:53.9661 AlertProcessor ProcessorAlertData: Stopped 2025-12-28 20:24:58.1380 DFramework.Scheduler.TaskBase /* Time Taken: 15687.6145*/ Opportunity Out Of Stock By Outlet 2025-12-28 20:29:48.4370 AlertProcessor ProcessorAlertData: started 2025-12-28 20:29:49.6558 DFramework.Database.Query /* Time Taken: 530*/ DECLARE @TableName AnsiString(8000) SET @TableName = 'MissingShelf' DECLARE @CurrentRecordId Int32 SET @CurrentRecordId = '3675192' dbo.GetValidDeviceForAlertProcessData 2025-12-28 20:29:54.0933 AlertProcessor ProcessorAlertData: Stopped 2025-12-28 20:34:44.3775 MoveToReorder Running task for ClientId : 286 and ClientName = India Office QA and Slot: 12/29/2025 10:00:00 AM And LastExecutedOn: 12/29/2025 9:04:44 AM 2025-12-28 20:34:44.5806 MoveToReorder Task executed successfully for ClientId : 286 Client Name:India Office QA, Slot: 12/29/2025 10:00:00 AM But No Order found to suggest 2025-12-28 20:34:48.4400 AlertProcessor ProcessorAlertData: started 2025-12-28 20:34:50.2213 DFramework.Database.Query /* Time Taken: 551*/ DECLARE @TableName AnsiString(8000) SET @TableName = 'AdditionalShelf' DECLARE @CurrentRecordId Int32 SET @CurrentRecordId = '3675192' dbo.GetValidDeviceForAlertProcessData 2025-12-28 20:34:52.5963 DFramework.Database.Query /* Time Taken: 864*/ DECLARE @TableName AnsiString(8000) SET @TableName = 'AssetStockProductWiseConsolidate' DECLARE @CurrentRecordId Int32 SET @CurrentRecordId = '3675192' dbo.GetValidDeviceForAlertProcessData 2025-12-28 20:34:54.6276 DFramework.Database.Query /* Time Taken: 5161*/ DECLARE @AlertTypeIds AnsiString(8000) SET @AlertTypeIds = '42,31,44,18,58,52,64,61,46,73,59,65,69,72,60,74,68,39,51,56,32,55,38,63,77,76' DECLARE @ClientIds AnsiString(8000) SET @ClientIds = '360,213,286,395,1494,70,291,452,335' DECLARE @StatusId Int32 SET @StatusId = '1' SELECT ClientName, AlertType, AlertText, Location.Name AS [Location], Location.Code AS LocationCode, Asset.SerialNumber AS AssetSerialNumber, COALESCE(SmartDevice.SerialNumber, SD.SerialNumber) AS SmartDeviceSerial, AlertAt, AccountCoordinators.PrimaryEmail AS AccountCoordinator, AccountDirectors.PrimaryEmail AS AccountDirector, Alert.ClientId FROM Alert LEFT OUTER JOIN Client ON Client.ClientId = Alert.ClientId LEFT OUTER JOIN AlertType ON AlertType.AlertTypeId = Alert.AlertTypeId LEFT OUTER JOIN Location ON Location.LocationId = Alert.LocationId LEFT OUTER JOIN Asset ON Asset.AssetId = Alert.AssetId LEFT OUTER JOIN SmartDevice ON SmartDevice.SmartDeviceId = Alert.SmartDeviceId AND SmartDevice.IsGatewayDevice = 0 LEFT OUTER JOIN vwSmartDeviceExceptSmartHubList AS SD ON dbo.Alert.AssetId = SD.LinkedAssetId AND SD.LinkedAssetId <> 0 LEFT OUTER JOIN dbo.Security_User AS AccountDirectors ON Client.AccountDirectorId = AccountDirectors.UserId AND AccountDirectors.IsDeleted = 0 LEFT OUTER JOIN dbo.Security_User AS AccountCoordinators ON Client.AccountCoordinatorId = AccountCoordinators.UserId AND AccountCoordinators.IsDeleted = 0 WHERE Alert.IsDeleted = 0 AND Alert.AlertTypeId IN (SELECT * FROM CsvToInt(@AlertTypeIds)) AND Alert.ClientId IN (SELECT * FROM CsvToInt(@ClientIds)) AND Alert.StatusId = @StatusId ORDER BY Alert.ClientId 2025-12-28 20:34:56.1276 AlertProcessor ProcessorAlertData: Stopped 2025-12-28 20:34:59.3620 DFramework.Database.Query /* Time Taken: 4178*/ DECLARE @AlertTypeIds AnsiString(8000) SET @AlertTypeIds = '73,59,57,66,65,70,9,72,60,74,68,56,55,61,67,64,44,18,58,69,52,38,31,51,49,12,46,28,41,19,76' DECLARE @ClientIds AnsiString(8000) SET @ClientIds = '430,471,286,395,349,414,1494,360,213,70,295,320,336,338,134,188,227,296,301,303,305,328,335,337,385,421,469,1480,1496,114,180,183,299,300,314,316,331,332,333,415,451,207,224,291,306,308,325,342,229,221,355,1481,124,222,289,322,1476,452' DECLARE @StatusId Int32 SET @StatusId = '1' SELECT ClientName, AlertType, AlertText, Location.Name AS [Location], Location.Code AS LocationCode, Asset.SerialNumber AS AssetSerialNumber, COALESCE(SmartDevice.SerialNumber, SD.SerialNumber) AS SmartDeviceSerial, AlertAt, AccountCoordinators.PrimaryEmail AS AccountCoordinator, AccountDirectors.PrimaryEmail AS AccountDirector, Alert.ClientId FROM Alert LEFT OUTER JOIN Client ON Client.ClientId = Alert.ClientId LEFT OUTER JOIN AlertType ON AlertType.AlertTypeId = Alert.AlertTypeId LEFT OUTER JOIN Location ON Location.LocationId = Alert.LocationId LEFT OUTER JOIN Asset ON Asset.AssetId = Alert.AssetId LEFT OUTER JOIN SmartDevice ON SmartDevice.SmartDeviceId = Alert.SmartDeviceId AND SmartDevice.IsGatewayDevice = 0 LEFT OUTER JOIN vwSmartDeviceExceptSmartHubList AS SD ON dbo.Alert.AssetId = SD.LinkedAssetId AND SD.LinkedAssetId <> 0 LEFT OUTER JOIN dbo.Security_User AS AccountDirectors ON Client.AccountDirectorId = AccountDirectors.UserId AND AccountDirectors.IsDeleted = 0 LEFT OUTER JOIN dbo.Security_User AS AccountCoordinators ON Client.AccountCoordinatorId = AccountCoordinators.UserId AND AccountCoordinators.IsDeleted = 0 WHERE Alert.IsDeleted = 0 AND Alert.AlertTypeId IN (SELECT * FROM CsvToInt(@AlertTypeIds)) AND Alert.ClientId IN (SELECT * FROM CsvToInt(@ClientIds)) AND Alert.StatusId = @StatusId ORDER BY Alert.ClientId 2025-12-28 20:34:59.8932 DFramework.Scheduler.TaskBase /* Time Taken: 10937.5803*/ Alert Summary Mail 2025-12-28 20:39:48.4422 AlertProcessor ProcessorAlertData: started 2025-12-28 20:39:53.9735 AlertProcessor ProcessorAlertData: Stopped 2025-12-28 20:39:58.1611 DFramework.Scheduler.TaskBase /* Time Taken: 15703.2433*/ Opportunity Out Of Stock By Outlet 2025-12-28 20:44:48.4601 AlertProcessor ProcessorAlertData: started 2025-12-28 20:44:51.4289 DFramework.Database.Query /* Time Taken: 503*/ DECLARE @TableName AnsiString(8000) SET @TableName = 'AssetStockProductWiseConsolidate' DECLARE @CurrentRecordId Int32 SET @CurrentRecordId = '3675192' dbo.GetValidDeviceForAlertProcessData 2025-12-28 20:44:54.0383 AlertProcessor ProcessorAlertData: Stopped 2025-12-28 20:49:48.4779 AlertProcessor ProcessorAlertData: started 2025-12-28 20:49:54.0873 AlertProcessor ProcessorAlertData: Stopped 2025-12-28 20:54:48.4958 AlertProcessor ProcessorAlertData: started 2025-12-28 20:54:54.0583 AlertProcessor ProcessorAlertData: Stopped 2025-12-28 20:54:58.1834 DFramework.Scheduler.TaskBase /* Time Taken: 15703.2422*/ Opportunity Out Of Stock By Outlet 2025-12-28 20:59:48.5137 AlertProcessor ProcessorAlertData: started 2025-12-28 20:59:54.1231 AlertProcessor ProcessorAlertData: Stopped 2025-12-28 21:04:48.5315 AlertProcessor ProcessorAlertData: started 2025-12-28 21:04:54.2034 AlertProcessor ProcessorAlertData: Stopped 2025-12-28 21:09:48.5337 AlertProcessor ProcessorAlertData: started 2025-12-28 21:09:54.2369 AlertProcessor ProcessorAlertData: Stopped 2025-12-28 21:09:58.2526 DFramework.Scheduler.TaskBase /* Time Taken: 15765.7446*/ Opportunity Out Of Stock By Outlet 2025-12-28 21:14:48.5516 AlertProcessor ProcessorAlertData: started 2025-12-28 21:14:54.2860 AlertProcessor ProcessorAlertData: Stopped 2025-12-28 21:19:48.5694 AlertProcessor ProcessorAlertData: started 2025-12-28 21:19:54.2101 DFramework.Database.Query /* Time Taken: 521*/ DECLARE @TableName AnsiString(8000) SET @TableName = 'ProductStockLevel' DECLARE @CurrentRecordId Int32 SET @CurrentRecordId = '3675192' dbo.GetValidDeviceForAlertProcessData 2025-12-28 21:19:54.2726 AlertProcessor ProcessorAlertData: Stopped 2025-12-28 21:24:48.5873 AlertProcessor ProcessorAlertData: started 2025-12-28 21:24:54.3530 AlertProcessor ProcessorAlertData: Stopped 2025-12-28 21:24:58.3217 DFramework.Scheduler.TaskBase /* Time Taken: 15828.2412*/ Opportunity Out Of Stock By Outlet 2025-12-28 21:29:48.6051 AlertProcessor ProcessorAlertData: started 2025-12-28 21:29:54.4489 AlertProcessor ProcessorAlertData: Stopped 2025-12-28 21:34:44.4511 MoveToReorder Running task for ClientId : 286 and ClientName = India Office QA and Slot: 12/29/2025 11:00:00 AM And LastExecutedOn: 12/29/2025 10:04:44 AM 2025-12-28 21:34:48.6230 AlertProcessor ProcessorAlertData: started 2025-12-28 21:34:53.2168 DFramework.Database.Query /* Time Taken: 965*/ DECLARE @TableName AnsiString(8000) SET @TableName = 'AssetPurity' DECLARE @CurrentRecordId Int32 SET @CurrentRecordId = '3675192' dbo.GetValidDeviceForAlertProcessData 2025-12-28 21:34:53.9199 DFramework.Database.Query /* Time Taken: 623*/ DECLARE @TableName AnsiString(8000) SET @TableName = 'OpportunityLowStock' DECLARE @CurrentRecordId Int32 SET @CurrentRecordId = '3675192' dbo.GetValidDeviceForAlertProcessData 2025-12-28 21:34:55.4199 DFramework.Database.Query /* Time Taken: 519*/ DECLARE @TableName AnsiString(8000) SET @TableName = 'ProductStockLevel' DECLARE @CurrentRecordId Int32 SET @CurrentRecordId = '3675192' dbo.GetValidDeviceForAlertProcessData 2025-12-28 21:34:55.4668 AlertProcessor ProcessorAlertData: Stopped 2025-12-28 21:35:26.6233 DFramework.Database.NullableDataReader Data reader open for 41922 at System.Environment.GetStackTrace(Exception e, Boolean needFileInfo) at System.Environment.get_StackTrace() at DFramework.Database.NullableDataReader.Dispose(Boolean disposing) in D:\Spraxa\Framework\DFramework\Database\NullableDataReader.cs:line 33 at DFramework.Database.NullableDataReader.Dispose() in D:\Spraxa\Framework\DFramework\Database\NullableDataReader.cs:line 44 at CoolR.Tasks.MoveToReorder.Execute() in D:\Spraxa\CoolR-Group\portal\CoolR.Tasks\MoveToReorder.cs:line 44 at DFramework.Scheduler.TaskBase.Run() in D:\Spraxa\Framework\DFramework.Scheduler\TaskBase.cs:line 176 at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx) at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx) at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state) at System.Threading.ThreadHelper.ThreadStart() 2025-12-28 21:35:26.6545 MoveToReorder Task executed successfully for ClientId : 286 Client Name:India Office QA, Slot: 12/29/2025 11:00:00 AM and Total Order Suggested: 129 Out Of: 129 2025-12-28 21:35:27.5139 DFramework.Scheduler.TaskBase /* Time Taken: 43375.3246*/ Move To Re-Order 2025-12-28 21:39:48.6252 AlertProcessor ProcessorAlertData: started 2025-12-28 21:39:54.3284 AlertProcessor ProcessorAlertData: Stopped 2025-12-28 21:39:58.2659 DFramework.Scheduler.TaskBase /* Time Taken: 15750.1187*/ Opportunity Out Of Stock By Outlet 2025-12-28 21:44:48.6431 AlertProcessor ProcessorAlertData: started 2025-12-28 21:44:54.2369 AlertProcessor ProcessorAlertData: Stopped 2025-12-28 21:49:48.6609 AlertProcessor ProcessorAlertData: started 2025-12-28 21:49:51.8485 DFramework.Database.Query /* Time Taken: 672*/ DECLARE @TableName AnsiString(8000) SET @TableName = 'AssetStockProductWiseConsolidate' DECLARE @CurrentRecordId Int32 SET @CurrentRecordId = '3675192' dbo.GetValidDeviceForAlertProcessData 2025-12-28 21:49:54.9266 AlertProcessor ProcessorAlertData: Stopped 2025-12-28 21:54:48.6788 AlertProcessor ProcessorAlertData: started 2025-12-28 21:54:50.0538 DFramework.Database.Query /* Time Taken: 684*/ DECLARE @TableName AnsiString(8000) SET @TableName = 'MissingShelf' DECLARE @CurrentRecordId Int32 SET @CurrentRecordId = '3675229' dbo.GetValidDeviceForAlertProcessData 2025-12-28 21:54:50.2726 DFramework.Database.NullableDataReader Data reader open for 220 at System.Environment.GetStackTrace(Exception e, Boolean needFileInfo) at System.Environment.get_StackTrace() at DFramework.Database.NullableDataReader.Dispose(Boolean disposing) in D:\Spraxa\Framework\DFramework\Database\NullableDataReader.cs:line 33 at DFramework.Database.NullableDataReader.Dispose() in D:\Spraxa\Framework\DFramework\Database\NullableDataReader.cs:line 44 at CoolR.Tasks.ProcessAlertData.Execute() in D:\Spraxa\CoolR-Group\portal\CoolR.Tasks\ProcessAlertData.cs:line 47 at DFramework.Scheduler.TaskBase.Run() in D:\Spraxa\Framework\DFramework.Scheduler\TaskBase.cs:line 176 at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx) at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx) at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state) at System.Threading.ThreadHelper.ThreadStart() 2025-12-28 21:54:51.3819 DFramework.Database.NullableDataReader Data reader open for 253 at System.Environment.GetStackTrace(Exception e, Boolean needFileInfo) at System.Environment.get_StackTrace() at DFramework.Database.NullableDataReader.Dispose(Boolean disposing) in D:\Spraxa\Framework\DFramework\Database\NullableDataReader.cs:line 33 at DFramework.Database.NullableDataReader.Dispose() in D:\Spraxa\Framework\DFramework\Database\NullableDataReader.cs:line 44 at CoolR.Tasks.ProcessAlertData.Execute() in D:\Spraxa\CoolR-Group\portal\CoolR.Tasks\ProcessAlertData.cs:line 47 at DFramework.Scheduler.TaskBase.Run() in D:\Spraxa\Framework\DFramework.Scheduler\TaskBase.cs:line 176 at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx) at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx) at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state) at System.Threading.ThreadHelper.ThreadStart() 2025-12-28 21:54:51.4288 DFramework.Database.NullableDataReader Data reader open for 343 at System.Environment.GetStackTrace(Exception e, Boolean needFileInfo) at System.Environment.get_StackTrace() at DFramework.Database.NullableDataReader.Dispose(Boolean disposing) in D:\Spraxa\Framework\DFramework\Database\NullableDataReader.cs:line 33 at DFramework.Database.NullableDataReader.Dispose() in D:\Spraxa\Framework\DFramework\Database\NullableDataReader.cs:line 44 at CoolR.Tasks.ProcessAlertData.Execute() in D:\Spraxa\CoolR-Group\portal\CoolR.Tasks\ProcessAlertData.cs:line 47 at DFramework.Scheduler.TaskBase.Run() in D:\Spraxa\Framework\DFramework.Scheduler\TaskBase.cs:line 176 at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx) at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx) at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state) at System.Threading.ThreadHelper.ThreadStart() 2025-12-28 21:54:51.9445 DFramework.Database.NullableDataReader Data reader open for 262 at System.Environment.GetStackTrace(Exception e, Boolean needFileInfo) at System.Environment.get_StackTrace() at DFramework.Database.NullableDataReader.Dispose(Boolean disposing) in D:\Spraxa\Framework\DFramework\Database\NullableDataReader.cs:line 33 at DFramework.Database.NullableDataReader.Dispose() in D:\Spraxa\Framework\DFramework\Database\NullableDataReader.cs:line 44 at CoolR.Tasks.ProcessAlertData.Execute() in D:\Spraxa\CoolR-Group\portal\CoolR.Tasks\ProcessAlertData.cs:line 47 at DFramework.Scheduler.TaskBase.Run() in D:\Spraxa\Framework\DFramework.Scheduler\TaskBase.cs:line 176 at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx) at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx) at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state) at System.Threading.ThreadHelper.ThreadStart() 2025-12-28 21:54:52.9445 DFramework.Database.NullableDataReader Data reader open for 727 at System.Environment.GetStackTrace(Exception e, Boolean needFileInfo) at System.Environment.get_StackTrace() at DFramework.Database.NullableDataReader.Dispose(Boolean disposing) in D:\Spraxa\Framework\DFramework\Database\NullableDataReader.cs:line 33 at DFramework.Database.NullableDataReader.Dispose() in D:\Spraxa\Framework\DFramework\Database\NullableDataReader.cs:line 44 at CoolR.Tasks.ProcessAlertData.Execute() in D:\Spraxa\CoolR-Group\portal\CoolR.Tasks\ProcessAlertData.cs:line 47 at DFramework.Scheduler.TaskBase.Run() in D:\Spraxa\Framework\DFramework.Scheduler\TaskBase.cs:line 176 at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx) at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx) at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state) at System.Threading.ThreadHelper.ThreadStart() 2025-12-28 21:54:53.0070 DFramework.Database.NullableDataReader Data reader open for 810 at System.Environment.GetStackTrace(Exception e, Boolean needFileInfo) at System.Environment.get_StackTrace() at DFramework.Database.NullableDataReader.Dispose(Boolean disposing) in D:\Spraxa\Framework\DFramework\Database\NullableDataReader.cs:line 33 at DFramework.Database.NullableDataReader.Dispose() in D:\Spraxa\Framework\DFramework\Database\NullableDataReader.cs:line 44 at CoolR.Tasks.ProcessAlertData.Execute() in D:\Spraxa\CoolR-Group\portal\CoolR.Tasks\ProcessAlertData.cs:line 47 at DFramework.Scheduler.TaskBase.Run() in D:\Spraxa\Framework\DFramework.Scheduler\TaskBase.cs:line 176 at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx) at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx) at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state) at System.Threading.ThreadHelper.ThreadStart() 2025-12-28 21:54:54.0695 DFramework.Database.NullableDataReader Data reader open for 218 at System.Environment.GetStackTrace(Exception e, Boolean needFileInfo) at System.Environment.get_StackTrace() at DFramework.Database.NullableDataReader.Dispose(Boolean disposing) in D:\Spraxa\Framework\DFramework\Database\NullableDataReader.cs:line 33 at DFramework.Database.NullableDataReader.Dispose() in D:\Spraxa\Framework\DFramework\Database\NullableDataReader.cs:line 44 at CoolR.Tasks.ProcessAlertData.Execute() in D:\Spraxa\CoolR-Group\portal\CoolR.Tasks\ProcessAlertData.cs:line 47 at DFramework.Scheduler.TaskBase.Run() in D:\Spraxa\Framework\DFramework.Scheduler\TaskBase.cs:line 176 at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx) at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx) at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state) at System.Threading.ThreadHelper.ThreadStart() 2025-12-28 21:54:54.1163 DFramework.Database.NullableDataReader Data reader open for 306 at System.Environment.GetStackTrace(Exception e, Boolean needFileInfo) at System.Environment.get_StackTrace() at DFramework.Database.NullableDataReader.Dispose(Boolean disposing) in D:\Spraxa\Framework\DFramework\Database\NullableDataReader.cs:line 33 at DFramework.Database.NullableDataReader.Dispose() in D:\Spraxa\Framework\DFramework\Database\NullableDataReader.cs:line 44 at CoolR.Tasks.ProcessAlertData.Execute() in D:\Spraxa\CoolR-Group\portal\CoolR.Tasks\ProcessAlertData.cs:line 47 at DFramework.Scheduler.TaskBase.Run() in D:\Spraxa\Framework\DFramework.Scheduler\TaskBase.cs:line 176 at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx) at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx) at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state) at System.Threading.ThreadHelper.ThreadStart() 2025-12-28 21:54:54.4601 AlertProcessor Replace Tags updated for the Image Id: 3675229 2025-12-28 21:54:54.6007 DFramework.Database.NullableDataReader Data reader open for 238 at System.Environment.GetStackTrace(Exception e, Boolean needFileInfo) at System.Environment.get_StackTrace() at DFramework.Database.NullableDataReader.Dispose(Boolean disposing) in D:\Spraxa\Framework\DFramework\Database\NullableDataReader.cs:line 33 at DFramework.Database.NullableDataReader.Dispose() in D:\Spraxa\Framework\DFramework\Database\NullableDataReader.cs:line 44 at CoolR.Tasks.ProcessAlertData.Execute() in D:\Spraxa\CoolR-Group\portal\CoolR.Tasks\ProcessAlertData.cs:line 47 at DFramework.Scheduler.TaskBase.Run() in D:\Spraxa\Framework\DFramework.Scheduler\TaskBase.cs:line 176 at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx) at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx) at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state) at System.Threading.ThreadHelper.ThreadStart() 2025-12-28 21:54:56.1164 DFramework.Database.NullableDataReader Data reader open for 356 at System.Environment.GetStackTrace(Exception e, Boolean needFileInfo) at System.Environment.get_StackTrace() at DFramework.Database.NullableDataReader.Dispose(Boolean disposing) in D:\Spraxa\Framework\DFramework\Database\NullableDataReader.cs:line 33 at DFramework.Database.NullableDataReader.Dispose() in D:\Spraxa\Framework\DFramework\Database\NullableDataReader.cs:line 44 at CoolR.Tasks.ProcessAlertData.Execute() in D:\Spraxa\CoolR-Group\portal\CoolR.Tasks\ProcessAlertData.cs:line 47 at DFramework.Scheduler.TaskBase.Run() in D:\Spraxa\Framework\DFramework.Scheduler\TaskBase.cs:line 176 at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx) at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx) at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state) at System.Threading.ThreadHelper.ThreadStart() 2025-12-28 21:54:56.1632 DFramework.Database.NullableDataReader Data reader open for 439 at System.Environment.GetStackTrace(Exception e, Boolean needFileInfo) at System.Environment.get_StackTrace() at DFramework.Database.NullableDataReader.Dispose(Boolean disposing) in D:\Spraxa\Framework\DFramework\Database\NullableDataReader.cs:line 33 at DFramework.Database.NullableDataReader.Dispose() in D:\Spraxa\Framework\DFramework\Database\NullableDataReader.cs:line 44 at CoolR.Tasks.ProcessAlertData.Execute() in D:\Spraxa\CoolR-Group\portal\CoolR.Tasks\ProcessAlertData.cs:line 47 at DFramework.Scheduler.TaskBase.Run() in D:\Spraxa\Framework\DFramework.Scheduler\TaskBase.cs:line 176 at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx) at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx) at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state) at System.Threading.ThreadHelper.ThreadStart() 2025-12-28 21:54:56.9757 DFramework.Database.NullableDataReader Data reader open for 217 at System.Environment.GetStackTrace(Exception e, Boolean needFileInfo) at System.Environment.get_StackTrace() at DFramework.Database.NullableDataReader.Dispose(Boolean disposing) in D:\Spraxa\Framework\DFramework\Database\NullableDataReader.cs:line 33 at DFramework.Database.NullableDataReader.Dispose() in D:\Spraxa\Framework\DFramework\Database\NullableDataReader.cs:line 44 at CoolR.Tasks.ProcessAlertData.Execute() in D:\Spraxa\CoolR-Group\portal\CoolR.Tasks\ProcessAlertData.cs:line 47 at DFramework.Scheduler.TaskBase.Run() in D:\Spraxa\Framework\DFramework.Scheduler\TaskBase.cs:line 176 at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx) at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx) at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state) at System.Threading.ThreadHelper.ThreadStart() 2025-12-28 21:54:57.5383 AlertProcessor ProcessorAlertData: Stopped 2025-12-28 21:54:58.3976 DFramework.Scheduler.TaskBase /* Time Taken: 15859.4921*/ Opportunity Out Of Stock By Outlet 2025-12-28 21:59:48.6966 AlertProcessor ProcessorAlertData: started 2025-12-28 21:59:54.7436 AlertProcessor ProcessorAlertData: Stopped 2025-12-28 22:04:48.7145 AlertProcessor ProcessorAlertData: started 2025-12-28 22:04:54.3083 AlertProcessor ProcessorAlertData: Stopped 2025-12-28 22:09:48.7323 AlertProcessor ProcessorAlertData: started 2025-12-28 22:09:54.2793 AlertProcessor ProcessorAlertData: Stopped 2025-12-28 22:09:58.2637 DFramework.Scheduler.TaskBase /* Time Taken: 15703.2378*/ Opportunity Out Of Stock By Outlet 2025-12-28 22:14:48.7502 AlertProcessor ProcessorAlertData: started 2025-12-28 22:14:54.4690 AlertProcessor ProcessorAlertData: Stopped 2025-12-28 22:19:48.7680 AlertProcessor ProcessorAlertData: started 2025-12-28 22:19:50.8931 DFramework.Database.NullableDataReader Data reader open for 211 at System.Environment.GetStackTrace(Exception e, Boolean needFileInfo) at System.Environment.get_StackTrace() at DFramework.Database.NullableDataReader.Dispose(Boolean disposing) in D:\Spraxa\Framework\DFramework\Database\NullableDataReader.cs:line 33 at DFramework.Database.NullableDataReader.Dispose() in D:\Spraxa\Framework\DFramework\Database\NullableDataReader.cs:line 44 at CoolR.Tasks.ProcessAlertData.Execute() in D:\Spraxa\CoolR-Group\portal\CoolR.Tasks\ProcessAlertData.cs:line 47 at DFramework.Scheduler.TaskBase.Run() in D:\Spraxa\Framework\DFramework.Scheduler\TaskBase.cs:line 176 at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx) at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx) at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state) at System.Threading.ThreadHelper.ThreadStart() 2025-12-28 22:19:50.9399 DFramework.Database.NullableDataReader Data reader open for 294 at System.Environment.GetStackTrace(Exception e, Boolean needFileInfo) at System.Environment.get_StackTrace() at DFramework.Database.NullableDataReader.Dispose(Boolean disposing) in D:\Spraxa\Framework\DFramework\Database\NullableDataReader.cs:line 33 at DFramework.Database.NullableDataReader.Dispose() in D:\Spraxa\Framework\DFramework\Database\NullableDataReader.cs:line 44 at CoolR.Tasks.ProcessAlertData.Execute() in D:\Spraxa\CoolR-Group\portal\CoolR.Tasks\ProcessAlertData.cs:line 47 at DFramework.Scheduler.TaskBase.Run() in D:\Spraxa\Framework\DFramework.Scheduler\TaskBase.cs:line 176 at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx) at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx) at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state) at System.Threading.ThreadHelper.ThreadStart() 2025-12-28 22:19:51.4243 DFramework.Database.NullableDataReader Data reader open for 223 at System.Environment.GetStackTrace(Exception e, Boolean needFileInfo) at System.Environment.get_StackTrace() at DFramework.Database.NullableDataReader.Dispose(Boolean disposing) in D:\Spraxa\Framework\DFramework\Database\NullableDataReader.cs:line 33 at DFramework.Database.NullableDataReader.Dispose() in D:\Spraxa\Framework\DFramework\Database\NullableDataReader.cs:line 44 at CoolR.Tasks.ProcessAlertData.Execute() in D:\Spraxa\CoolR-Group\portal\CoolR.Tasks\ProcessAlertData.cs:line 47 at DFramework.Scheduler.TaskBase.Run() in D:\Spraxa\Framework\DFramework.Scheduler\TaskBase.cs:line 176 at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx) at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx) at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state) at System.Threading.ThreadHelper.ThreadStart() 2025-12-28 22:19:52.1431 DFramework.Database.NullableDataReader Data reader open for 439 at System.Environment.GetStackTrace(Exception e, Boolean needFileInfo) at System.Environment.get_StackTrace() at DFramework.Database.NullableDataReader.Dispose(Boolean disposing) in D:\Spraxa\Framework\DFramework\Database\NullableDataReader.cs:line 33 at DFramework.Database.NullableDataReader.Dispose() in D:\Spraxa\Framework\DFramework\Database\NullableDataReader.cs:line 44 at CoolR.Tasks.ProcessAlertData.Execute() in D:\Spraxa\CoolR-Group\portal\CoolR.Tasks\ProcessAlertData.cs:line 47 at DFramework.Scheduler.TaskBase.Run() in D:\Spraxa\Framework\DFramework.Scheduler\TaskBase.cs:line 176 at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx) at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx) at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state) at System.Threading.ThreadHelper.ThreadStart() 2025-12-28 22:19:52.2056 DFramework.Database.NullableDataReader Data reader open for 523 at System.Environment.GetStackTrace(Exception e, Boolean needFileInfo) at System.Environment.get_StackTrace() at DFramework.Database.NullableDataReader.Dispose(Boolean disposing) in D:\Spraxa\Framework\DFramework\Database\NullableDataReader.cs:line 33 at DFramework.Database.NullableDataReader.Dispose() in D:\Spraxa\Framework\DFramework\Database\NullableDataReader.cs:line 44 at CoolR.Tasks.ProcessAlertData.Execute() in D:\Spraxa\CoolR-Group\portal\CoolR.Tasks\ProcessAlertData.cs:line 47 at DFramework.Scheduler.TaskBase.Run() in D:\Spraxa\Framework\DFramework.Scheduler\TaskBase.cs:line 176 at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx) at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx) at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state) at System.Threading.ThreadHelper.ThreadStart() 2025-12-28 22:19:53.1900 DFramework.Database.NullableDataReader Data reader open for 221 at System.Environment.GetStackTrace(Exception e, Boolean needFileInfo) at System.Environment.get_StackTrace() at DFramework.Database.NullableDataReader.Dispose(Boolean disposing) in D:\Spraxa\Framework\DFramework\Database\NullableDataReader.cs:line 33 at DFramework.Database.NullableDataReader.Dispose() in D:\Spraxa\Framework\DFramework\Database\NullableDataReader.cs:line 44 at CoolR.Tasks.ProcessAlertData.Execute() in D:\Spraxa\CoolR-Group\portal\CoolR.Tasks\ProcessAlertData.cs:line 47 at DFramework.Scheduler.TaskBase.Run() in D:\Spraxa\Framework\DFramework.Scheduler\TaskBase.cs:line 176 at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx) at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx) at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state) at System.Threading.ThreadHelper.ThreadStart() 2025-12-28 22:19:53.5181 AlertProcessor Replace Tags updated for the Image Id: 3675231 2025-12-28 22:19:53.7212 DFramework.Database.NullableDataReader Data reader open for 273 at System.Environment.GetStackTrace(Exception e, Boolean needFileInfo) at System.Environment.get_StackTrace() at DFramework.Database.NullableDataReader.Dispose(Boolean disposing) in D:\Spraxa\Framework\DFramework\Database\NullableDataReader.cs:line 33 at DFramework.Database.NullableDataReader.Dispose() in D:\Spraxa\Framework\DFramework\Database\NullableDataReader.cs:line 44 at CoolR.Tasks.ProcessAlertData.Execute() in D:\Spraxa\CoolR-Group\portal\CoolR.Tasks\ProcessAlertData.cs:line 47 at DFramework.Scheduler.TaskBase.Run() in D:\Spraxa\Framework\DFramework.Scheduler\TaskBase.cs:line 176 at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx) at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx) at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state) at System.Threading.ThreadHelper.ThreadStart() 2025-12-28 22:19:54.5962 DFramework.Database.Query /* Time Taken: 506*/ DECLARE @TableName AnsiString(8000) SET @TableName = 'OpportunityLowStock' DECLARE @CurrentRecordId Int32 SET @CurrentRecordId = '3675231' dbo.GetValidDeviceForAlertProcessData 2025-12-28 22:19:55.1587 DFramework.Database.NullableDataReader Data reader open for 221 at System.Environment.GetStackTrace(Exception e, Boolean needFileInfo) at System.Environment.get_StackTrace() at DFramework.Database.NullableDataReader.Dispose(Boolean disposing) in D:\Spraxa\Framework\DFramework\Database\NullableDataReader.cs:line 33 at DFramework.Database.NullableDataReader.Dispose() in D:\Spraxa\Framework\DFramework\Database\NullableDataReader.cs:line 44 at CoolR.Tasks.ProcessAlertData.Execute() in D:\Spraxa\CoolR-Group\portal\CoolR.Tasks\ProcessAlertData.cs:line 47 at DFramework.Scheduler.TaskBase.Run() in D:\Spraxa\Framework\DFramework.Scheduler\TaskBase.cs:line 176 at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx) at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx) at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state) at System.Threading.ThreadHelper.ThreadStart() 2025-12-28 22:19:55.9556 DFramework.Database.NullableDataReader Data reader open for 219 at System.Environment.GetStackTrace(Exception e, Boolean needFileInfo) at System.Environment.get_StackTrace() at DFramework.Database.NullableDataReader.Dispose(Boolean disposing) in D:\Spraxa\Framework\DFramework\Database\NullableDataReader.cs:line 33 at DFramework.Database.NullableDataReader.Dispose() in D:\Spraxa\Framework\DFramework\Database\NullableDataReader.cs:line 44 at CoolR.Tasks.ProcessAlertData.Execute() in D:\Spraxa\CoolR-Group\portal\CoolR.Tasks\ProcessAlertData.cs:line 47 at DFramework.Scheduler.TaskBase.Run() in D:\Spraxa\Framework\DFramework.Scheduler\TaskBase.cs:line 176 at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx) at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx) at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state) at System.Threading.ThreadHelper.ThreadStart() 2025-12-28 22:19:56.4869 AlertProcessor ProcessorAlertData: Stopped 2025-12-28 22:24:48.7859 AlertProcessor ProcessorAlertData: started 2025-12-28 22:24:54.1766 AlertProcessor ProcessorAlertData: Stopped 2025-12-28 22:24:58.2860 DFramework.Scheduler.TaskBase /* Time Taken: 15718.8634*/ Opportunity Out Of Stock By Outlet 2025-12-28 22:29:48.7881 AlertProcessor ProcessorAlertData: started 2025-12-28 22:29:52.4131 DFramework.Database.Query /* Time Taken: 885*/ DECLARE @TableName AnsiString(8000) SET @TableName = 'AssetStockProductWiseConsolidate' DECLARE @CurrentRecordId Int32 SET @CurrentRecordId = '3675231' dbo.GetValidDeviceForAlertProcessData 2025-12-28 22:29:55.7569 AlertProcessor ProcessorAlertData: Stopped 2025-12-28 22:34:44.6653 MoveToReorder Running task for ClientId : 286 and ClientName = India Office QA and Slot: 12/29/2025 12:00:00 PM And LastExecutedOn: 12/29/2025 11:04:44 AM 2025-12-28 22:34:45.1809 MoveToReorder Task executed successfully for ClientId : 286 Client Name:India Office QA, Slot: 12/29/2025 12:00:00 PM and Total Order Suggested: 1 Out Of: 1 2025-12-28 22:34:48.8060 AlertProcessor ProcessorAlertData: started 2025-12-28 22:34:54.4310 AlertProcessor ProcessorAlertData: Stopped 2025-12-28 22:39:43.4800 DFramework.Database.Query /* Time Taken: 592*/ [dbo].GenerateSystemAlerts 2025-12-28 22:39:48.8238 AlertProcessor ProcessorAlertData: started 2025-12-28 22:39:49.9801 DFramework.Database.Query /* Time Taken: 651*/ DECLARE @TableName AnsiString(8000) SET @TableName = 'VoidAlert' DECLARE @CurrentRecordId Int32 SET @CurrentRecordId = '3675231' dbo.GetValidDeviceForAlertProcessData 2025-12-28 22:39:50.1364 DFramework.Database.Query /* Time Taken: 796*/ DECLARE @StatusId Int32 SET @StatusId = '1' DECLARE @AlertId Int32 SET @AlertId = '7571914' SELECT TOP 10000 Alert.AlertId, Alert.LocationId, Alert.RecordId, ISNULL(AlertDefinition.Name, Alert.AlertText) Name, Alert.AlertTypeId, Alert.AlertText, ISNULL(Location.Name, '') AS LocationName, AlertDefinition.ClientId, AlertRecipient.RoleId, CASE WHEN Alert.AlertTypeId IN (6,7) THEN CONVERT(VARCHAR(10), CAST(AlertAt AS DATE), 101) ELSE AlertAt END AS AlertAt, AlertType, Asset.SerialNumber, ISNULL(LocationAttribute.FirstRepId, 0) RepId, ClientUser.PrimaryPhone AS SalesRepPhone, ClientUser.PrimaryEmail AS SalesRepEmail, FirstName, LastName, PreferedNotificationTypeIds, AlertRecipientId, AlertRecipientAddress, AlertRecipientText, Alert.Tags, AlertRecipientTypeId, NotificationContactTypeId, TemplateId, AlertDefinition.AlertAgeThreshold, LastUpdatedOn, AlertRecipient.AlertAge, CASE WHEN Location.TimeZoneId IS NOT NULL AND Location.TimeZoneId > 0 THEN Location.TimeZoneId ELSE Client.TimeZoneId END AS TimeZoneId, AlertDefinition.IsSummarize, Alert.ClosedOn, AssetType.IsChestCooler, AlertDefinition.SnoozeForHours, Alert.SnoozeDateTime FROM Alert LEFT OUTER JOIN Asset ON Alert.AssetId = Asset.AssetId LEFT OUTER JOIN AlertType ON Alert.AlertTypeId = AlertType.AlertTypeId LEFT OUTER JOIN AlertDefinition ON Alert.AlertDefinitionId = AlertDefinition.AlertDefinitionId LEFT OUTER JOIN Location ON Location.LocationId = Alert.LocationId LEFT OUTER JOIN LocationAttribute ON LocationAttribute.LocationId = dbo.Location.LocationId LEFT OUTER JOIN ClientUser ON LocationAttribute.FirstRepId = ClientUser.ClientUserId AND ClientUser.IsDeleted = 0 LEFT OUTER JOIN AlertRecipient ON Alert.AlertDefinitionId = AlertRecipient.AlertDefinitionId AND AlertRecipient.IsDeleted= 0 LEFT OUTER JOIN Client ON Client.ClientId = Alert.ClientId LEFT OUTER JOIN AssetType ON dbo.Asset.AssetTypeId = dbo.AssetType.AssetTypeId WHERE (NOT EXISTS(SELECT 1 FROM dbo.EmailQueue INNER JOIN dbo.EmailRecipient ON EmailRecipient.EmailQueueId = EmailQueue.EmailQueueId WHERE AlertId = Alert.AlertId AND EmailRecipient.RecipientId = AlertRecipient.AlertRecipientId) OR (Alert.SnoozeDateTime IS NOT NULL AND Alert.SnoozeDateTime <= GETUTCDATE() AND AlertDefinition.SnoozeForHours > 0 AND Alert.StatusId = @StatusId)) AND Alert.AlertId > @AlertId AND Alert.AlertAt >= DATEADD(DAY, -120, GETDATE()) AND AlertRecipient.IsDeleted = 0 AND Alert.IsActive = 1 AND Alert.IsDeleted = 0 AND AlertRecipient.IsActive = 1 AND AlertRecipient.IsDeleted = 0 AND AlertRecipient.StartDate <= Alert.CreatedOn AND Alert.CreatedOn < DATEADD(hh, 23, AlertRecipient.EndDate) AND (Alert.LocationId != 0 OR NotificationWithoutLocation = 1) AND AlertType.IsSystemAlert = 0 AND Alert.EmailQueuedOn IS NULL AND AlertDefinition.IsActive = 1 2025-12-28 22:39:50.7926 DFramework.Database.Query /* Time Taken: 683*/ DECLARE @TableName AnsiString(8000) SET @TableName = 'MissingShelf' DECLARE @CurrentRecordId Int32 SET @CurrentRecordId = '3675231' dbo.GetValidDeviceForAlertProcessData 2025-12-28 22:39:51.4488 DFramework.Database.Query /* Time Taken: 592*/ DECLARE @TableName AnsiString(8000) SET @TableName = 'AdditionalShelf' DECLARE @CurrentRecordId Int32 SET @CurrentRecordId = '3675231' dbo.GetValidDeviceForAlertProcessData 2025-12-28 22:39:55.6364 AlertProcessor ProcessorAlertData: Stopped 2025-12-28 22:39:58.6051 DFramework.Scheduler.TaskBase /* Time Taken: 16031.3668*/ Opportunity Out Of Stock By Outlet 2025-12-28 22:44:48.8417 AlertProcessor ProcessorAlertData: started 2025-12-28 22:44:51.0292 DFramework.Database.Query /* Time Taken: 568*/ DECLARE @TableName AnsiString(8000) SET @TableName = 'OpportunityOutOfStock' DECLARE @CurrentRecordId Int32 SET @CurrentRecordId = '3675231' dbo.GetValidDeviceForAlertProcessData 2025-12-28 22:44:54.7167 AlertProcessor ProcessorAlertData: Stopped 2025-12-28 22:49:48.8595 AlertProcessor ProcessorAlertData: started 2025-12-28 22:49:51.0470 DFramework.Database.Query /* Time Taken: 1686*/ DECLARE @StatusId Int32 SET @StatusId = '1' DECLARE @AlertId Int32 SET @AlertId = '7571914' SELECT TOP 10000 Alert.AlertId, Alert.LocationId, Alert.RecordId, ISNULL(AlertDefinition.Name, Alert.AlertText) Name, Alert.AlertTypeId, Alert.AlertText, ISNULL(Location.Name, '') AS LocationName, AlertDefinition.ClientId, AlertRecipient.RoleId, CASE WHEN Alert.AlertTypeId IN (6,7) THEN CONVERT(VARCHAR(10), CAST(AlertAt AS DATE), 101) ELSE AlertAt END AS AlertAt, AlertType, Asset.SerialNumber, ISNULL(LocationAttribute.FirstRepId, 0) RepId, ClientUser.PrimaryPhone AS SalesRepPhone, ClientUser.PrimaryEmail AS SalesRepEmail, FirstName, LastName, PreferedNotificationTypeIds, AlertRecipientId, AlertRecipientAddress, AlertRecipientText, Alert.Tags, AlertRecipientTypeId, NotificationContactTypeId, TemplateId, AlertDefinition.AlertAgeThreshold, LastUpdatedOn, AlertRecipient.AlertAge, CASE WHEN Location.TimeZoneId IS NOT NULL AND Location.TimeZoneId > 0 THEN Location.TimeZoneId ELSE Client.TimeZoneId END AS TimeZoneId, AlertDefinition.IsSummarize, Alert.ClosedOn, AssetType.IsChestCooler, AlertDefinition.SnoozeForHours, Alert.SnoozeDateTime FROM Alert LEFT OUTER JOIN Asset ON Alert.AssetId = Asset.AssetId LEFT OUTER JOIN AlertType ON Alert.AlertTypeId = AlertType.AlertTypeId LEFT OUTER JOIN AlertDefinition ON Alert.AlertDefinitionId = AlertDefinition.AlertDefinitionId LEFT OUTER JOIN Location ON Location.LocationId = Alert.LocationId LEFT OUTER JOIN LocationAttribute ON LocationAttribute.LocationId = dbo.Location.LocationId LEFT OUTER JOIN ClientUser ON LocationAttribute.FirstRepId = ClientUser.ClientUserId AND ClientUser.IsDeleted = 0 LEFT OUTER JOIN AlertRecipient ON Alert.AlertDefinitionId = AlertRecipient.AlertDefinitionId AND AlertRecipient.IsDeleted= 0 LEFT OUTER JOIN Client ON Client.ClientId = Alert.ClientId LEFT OUTER JOIN AssetType ON dbo.Asset.AssetTypeId = dbo.AssetType.AssetTypeId WHERE (NOT EXISTS(SELECT 1 FROM dbo.EmailQueue INNER JOIN dbo.EmailRecipient ON EmailRecipient.EmailQueueId = EmailQueue.EmailQueueId WHERE AlertId = Alert.AlertId AND EmailRecipient.RecipientId = AlertRecipient.AlertRecipientId) OR (Alert.SnoozeDateTime IS NOT NULL AND Alert.SnoozeDateTime <= GETUTCDATE() AND AlertDefinition.SnoozeForHours > 0 AND Alert.StatusId = @StatusId)) AND Alert.AlertId > @AlertId AND Alert.AlertAt >= DATEADD(DAY, -120, GETDATE()) AND AlertRecipient.IsDeleted = 0 AND Alert.IsActive = 1 AND Alert.IsDeleted = 0 AND AlertRecipient.IsActive = 1 AND AlertRecipient.IsDeleted = 0 AND AlertRecipient.StartDate <= Alert.CreatedOn AND Alert.CreatedOn < DATEADD(hh, 23, AlertRecipient.EndDate) AND (Alert.LocationId != 0 OR NotificationWithoutLocation = 1) AND AlertType.IsSystemAlert = 0 AND Alert.EmailQueuedOn IS NULL AND AlertDefinition.IsActive = 1 2025-12-28 22:49:52.4064 DFramework.Database.Query /* Time Taken: 3560*/ DECLARE @TableName AnsiString(8000) SET @TableName = 'TagAlert' DECLARE @CurrentRecordId Int32 SET @CurrentRecordId = '0' dbo.GetValidDeviceForAlertProcessData 2025-12-28 22:49:54.7502 DFramework.Database.Query /* Time Taken: 1827*/ DECLARE @TableName AnsiString(8000) SET @TableName = 'MissingShelf' DECLARE @CurrentRecordId Int32 SET @CurrentRecordId = '3675239' dbo.GetValidDeviceForAlertProcessData 2025-12-28 22:49:56.4689 DFramework.Database.NullableDataReader Data reader open for 646 at System.Environment.GetStackTrace(Exception e, Boolean needFileInfo) at System.Environment.get_StackTrace() at DFramework.Database.NullableDataReader.Dispose(Boolean disposing) in D:\Spraxa\Framework\DFramework\Database\NullableDataReader.cs:line 33 at DFramework.Database.NullableDataReader.Dispose() in D:\Spraxa\Framework\DFramework\Database\NullableDataReader.cs:line 44 at CoolR.Tasks.ProcessAlertData.Execute() in D:\Spraxa\CoolR-Group\portal\CoolR.Tasks\ProcessAlertData.cs:line 47 at DFramework.Scheduler.TaskBase.Run() in D:\Spraxa\Framework\DFramework.Scheduler\TaskBase.cs:line 176 at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx) at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx) at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state) at System.Threading.ThreadHelper.ThreadStart() 2025-12-28 22:49:56.5158 DFramework.Database.NullableDataReader Data reader open for 787 at System.Environment.GetStackTrace(Exception e, Boolean needFileInfo) at System.Environment.get_StackTrace() at DFramework.Database.NullableDataReader.Dispose(Boolean disposing) in D:\Spraxa\Framework\DFramework\Database\NullableDataReader.cs:line 33 at DFramework.Database.NullableDataReader.Dispose() in D:\Spraxa\Framework\DFramework\Database\NullableDataReader.cs:line 44 at CoolR.Tasks.ProcessAlertData.Execute() in D:\Spraxa\CoolR-Group\portal\CoolR.Tasks\ProcessAlertData.cs:line 47 at DFramework.Scheduler.TaskBase.Run() in D:\Spraxa\Framework\DFramework.Scheduler\TaskBase.cs:line 176 at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx) at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx) at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state) at System.Threading.ThreadHelper.ThreadStart() 2025-12-28 22:49:57.2190 DFramework.Database.NullableDataReader Data reader open for 349 at System.Environment.GetStackTrace(Exception e, Boolean needFileInfo) at System.Environment.get_StackTrace() at DFramework.Database.NullableDataReader.Dispose(Boolean disposing) in D:\Spraxa\Framework\DFramework\Database\NullableDataReader.cs:line 33 at DFramework.Database.NullableDataReader.Dispose() in D:\Spraxa\Framework\DFramework\Database\NullableDataReader.cs:line 44 at CoolR.Tasks.ProcessAlertData.Execute() in D:\Spraxa\CoolR-Group\portal\CoolR.Tasks\ProcessAlertData.cs:line 47 at DFramework.Scheduler.TaskBase.Run() in D:\Spraxa\Framework\DFramework.Scheduler\TaskBase.cs:line 176 at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx) at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx) at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state) at System.Threading.ThreadHelper.ThreadStart() 2025-12-28 22:49:58.2190 DFramework.Database.NullableDataReader Data reader open for 710 at System.Environment.GetStackTrace(Exception e, Boolean needFileInfo) at System.Environment.get_StackTrace() at DFramework.Database.NullableDataReader.Dispose(Boolean disposing) in D:\Spraxa\Framework\DFramework\Database\NullableDataReader.cs:line 33 at DFramework.Database.NullableDataReader.Dispose() in D:\Spraxa\Framework\DFramework\Database\NullableDataReader.cs:line 44 at CoolR.Tasks.ProcessAlertData.Execute() in D:\Spraxa\CoolR-Group\portal\CoolR.Tasks\ProcessAlertData.cs:line 47 at DFramework.Scheduler.TaskBase.Run() in D:\Spraxa\Framework\DFramework.Scheduler\TaskBase.cs:line 176 at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx) at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx) at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state) at System.Threading.ThreadHelper.ThreadStart() 2025-12-28 22:49:58.2815 DFramework.Database.NullableDataReader Data reader open for 794 at System.Environment.GetStackTrace(Exception e, Boolean needFileInfo) at System.Environment.get_StackTrace() at DFramework.Database.NullableDataReader.Dispose(Boolean disposing) in D:\Spraxa\Framework\DFramework\Database\NullableDataReader.cs:line 33 at DFramework.Database.NullableDataReader.Dispose() in D:\Spraxa\Framework\DFramework\Database\NullableDataReader.cs:line 44 at CoolR.Tasks.ProcessAlertData.Execute() in D:\Spraxa\CoolR-Group\portal\CoolR.Tasks\ProcessAlertData.cs:line 47 at DFramework.Scheduler.TaskBase.Run() in D:\Spraxa\Framework\DFramework.Scheduler\TaskBase.cs:line 176 at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx) at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx) at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state) at System.Threading.ThreadHelper.ThreadStart() 2025-12-28 22:50:00.2033 DFramework.Database.Query /* Time Taken: 1930*/ DECLARE @TableName AnsiString(8000) SET @TableName = 'AssetStockProductWiseConsolidate' DECLARE @CurrentRecordId Int32 SET @CurrentRecordId = '3675239' dbo.GetValidDeviceForAlertProcessData 2025-12-28 22:50:01.3127 DFramework.Database.NullableDataReader Data reader open for 401 at System.Environment.GetStackTrace(Exception e, Boolean needFileInfo) at System.Environment.get_StackTrace() at DFramework.Database.NullableDataReader.Dispose(Boolean disposing) in D:\Spraxa\Framework\DFramework\Database\NullableDataReader.cs:line 33 at DFramework.Database.NullableDataReader.Dispose() in D:\Spraxa\Framework\DFramework\Database\NullableDataReader.cs:line 44 at CoolR.Tasks.ProcessAlertData.Execute() in D:\Spraxa\CoolR-Group\portal\CoolR.Tasks\ProcessAlertData.cs:line 47 at DFramework.Scheduler.TaskBase.Run() in D:\Spraxa\Framework\DFramework.Scheduler\TaskBase.cs:line 176 at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx) at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx) at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state) at System.Threading.ThreadHelper.ThreadStart() 2025-12-28 22:50:01.3752 DFramework.Database.NullableDataReader Data reader open for 709 at System.Environment.GetStackTrace(Exception e, Boolean needFileInfo) at System.Environment.get_StackTrace() at DFramework.Database.NullableDataReader.Dispose(Boolean disposing) in D:\Spraxa\Framework\DFramework\Database\NullableDataReader.cs:line 33 at DFramework.Database.NullableDataReader.Dispose() in D:\Spraxa\Framework\DFramework\Database\NullableDataReader.cs:line 44 at CoolR.Tasks.ProcessAlertData.Execute() in D:\Spraxa\CoolR-Group\portal\CoolR.Tasks\ProcessAlertData.cs:line 47 at DFramework.Scheduler.TaskBase.Run() in D:\Spraxa\Framework\DFramework.Scheduler\TaskBase.cs:line 176 at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx) at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx) at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state) at System.Threading.ThreadHelper.ThreadStart() 2025-12-28 22:50:01.7190 AlertProcessor Replace Tags updated for the Image Id: 3675239 2025-12-28 22:50:01.9221 DFramework.Database.NullableDataReader Data reader open for 262 at System.Environment.GetStackTrace(Exception e, Boolean needFileInfo) at System.Environment.get_StackTrace() at DFramework.Database.NullableDataReader.Dispose(Boolean disposing) in D:\Spraxa\Framework\DFramework\Database\NullableDataReader.cs:line 33 at DFramework.Database.NullableDataReader.Dispose() in D:\Spraxa\Framework\DFramework\Database\NullableDataReader.cs:line 44 at CoolR.Tasks.ProcessAlertData.Execute() in D:\Spraxa\CoolR-Group\portal\CoolR.Tasks\ProcessAlertData.cs:line 47 at DFramework.Scheduler.TaskBase.Run() in D:\Spraxa\Framework\DFramework.Scheduler\TaskBase.cs:line 176 at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx) at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx) at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state) at System.Threading.ThreadHelper.ThreadStart() 2025-12-28 22:50:01.9846 DFramework.Database.NullableDataReader Data reader open for 345 at System.Environment.GetStackTrace(Exception e, Boolean needFileInfo) at System.Environment.get_StackTrace() at DFramework.Database.NullableDataReader.Dispose(Boolean disposing) in D:\Spraxa\Framework\DFramework\Database\NullableDataReader.cs:line 33 at DFramework.Database.NullableDataReader.Dispose() in D:\Spraxa\Framework\DFramework\Database\NullableDataReader.cs:line 44 at CoolR.Tasks.ProcessAlertData.Execute() in D:\Spraxa\CoolR-Group\portal\CoolR.Tasks\ProcessAlertData.cs:line 47 at DFramework.Scheduler.TaskBase.Run() in D:\Spraxa\Framework\DFramework.Scheduler\TaskBase.cs:line 176 at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx) at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx) at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state) at System.Threading.ThreadHelper.ThreadStart() 2025-12-28 22:50:04.5003 DFramework.Database.NullableDataReader Data reader open for 1292 at System.Environment.GetStackTrace(Exception e, Boolean needFileInfo) at System.Environment.get_StackTrace() at DFramework.Database.NullableDataReader.Dispose(Boolean disposing) in D:\Spraxa\Framework\DFramework\Database\NullableDataReader.cs:line 33 at DFramework.Database.NullableDataReader.Dispose() in D:\Spraxa\Framework\DFramework\Database\NullableDataReader.cs:line 44 at CoolR.Tasks.ProcessAlertData.Execute() in D:\Spraxa\CoolR-Group\portal\CoolR.Tasks\ProcessAlertData.cs:line 47 at DFramework.Scheduler.TaskBase.Run() in D:\Spraxa\Framework\DFramework.Scheduler\TaskBase.cs:line 176 at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx) at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx) at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state) at System.Threading.ThreadHelper.ThreadStart() 2025-12-28 22:50:04.5784 DFramework.Database.NullableDataReader Data reader open for 1396 at System.Environment.GetStackTrace(Exception e, Boolean needFileInfo) at System.Environment.get_StackTrace() at DFramework.Database.NullableDataReader.Dispose(Boolean disposing) in D:\Spraxa\Framework\DFramework\Database\NullableDataReader.cs:line 33 at DFramework.Database.NullableDataReader.Dispose() in D:\Spraxa\Framework\DFramework\Database\NullableDataReader.cs:line 44 at CoolR.Tasks.ProcessAlertData.Execute() in D:\Spraxa\CoolR-Group\portal\CoolR.Tasks\ProcessAlertData.cs:line 47 at DFramework.Scheduler.TaskBase.Run() in D:\Spraxa\Framework\DFramework.Scheduler\TaskBase.cs:line 176 at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx) at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx) at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state) at System.Threading.ThreadHelper.ThreadStart() 2025-12-28 22:50:05.4534 DFramework.Database.Query /* Time Taken: 878*/ DECLARE @TableName AnsiString(8000) SET @TableName = 'LowInventoryConsolidate' DECLARE @CurrentRecordId Int32 SET @CurrentRecordId = '3675239' dbo.GetValidDeviceForAlertProcessData 2025-12-28 22:50:06.5003 DFramework.Database.Query /* Time Taken: 946*/ DECLARE @TableName AnsiString(8000) SET @TableName = 'TargetPortfolioComplianceConsolidate' DECLARE @CurrentRecordId Int32 SET @CurrentRecordId = '3675239' dbo.GetValidDeviceForAlertProcessData 2025-12-28 22:50:06.7659 DFramework.Database.NullableDataReader Data reader open for 256 at System.Environment.GetStackTrace(Exception e, Boolean needFileInfo) at System.Environment.get_StackTrace() at DFramework.Database.NullableDataReader.Dispose(Boolean disposing) in D:\Spraxa\Framework\DFramework\Database\NullableDataReader.cs:line 33 at DFramework.Database.NullableDataReader.Dispose() in D:\Spraxa\Framework\DFramework\Database\NullableDataReader.cs:line 44 at CoolR.Tasks.ProcessAlertData.Execute() in D:\Spraxa\CoolR-Group\portal\CoolR.Tasks\ProcessAlertData.cs:line 47 at DFramework.Scheduler.TaskBase.Run() in D:\Spraxa\Framework\DFramework.Scheduler\TaskBase.cs:line 176 at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx) at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx) at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state) at System.Threading.ThreadHelper.ThreadStart() 2025-12-28 22:50:15.3753 DFramework.Database.Query /* Time Taken: 8620*/ DECLARE @TableName AnsiString(8000) SET @TableName = 'ProductStockLevel' DECLARE @CurrentRecordId Int32 SET @CurrentRecordId = '3675239' dbo.GetValidDeviceForAlertProcessData 2025-12-28 22:50:15.5003 AlertProcessor ProcessorAlertData: Stopped 2025-12-28 22:50:15.5003 DFramework.Scheduler.TaskBase /* Time Taken: 26640.8249*/ Process Alert Record 2025-12-28 22:54:43.4711 DFramework.Database.Query /* Time Taken: 575*/ [dbo].GenerateSystemAlerts 2025-12-28 22:54:48.8774 AlertProcessor ProcessorAlertData: started 2025-12-28 22:54:49.3617 DFramework.Database.NullableDataReader Data reader open for 213 at System.Environment.GetStackTrace(Exception e, Boolean needFileInfo) at System.Environment.get_StackTrace() at DFramework.Database.NullableDataReader.Dispose(Boolean disposing) in D:\Spraxa\Framework\DFramework\Database\NullableDataReader.cs:line 33 at DFramework.Database.NullableDataReader.Dispose() in D:\Spraxa\Framework\DFramework\Database\NullableDataReader.cs:line 44 at CoolR.Tasks.ProcessAlertData.Execute() in D:\Spraxa\CoolR-Group\portal\CoolR.Tasks\ProcessAlertData.cs:line 47 at DFramework.Scheduler.TaskBase.Run() in D:\Spraxa\Framework\DFramework.Scheduler\TaskBase.cs:line 176 at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx) at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx) at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state) at System.Threading.ThreadHelper.ThreadStart() 2025-12-28 22:54:50.0492 DFramework.Database.NullableDataReader Data reader open for 339 at System.Environment.GetStackTrace(Exception e, Boolean needFileInfo) at System.Environment.get_StackTrace() at DFramework.Database.NullableDataReader.Dispose(Boolean disposing) in D:\Spraxa\Framework\DFramework\Database\NullableDataReader.cs:line 33 at DFramework.Database.NullableDataReader.Dispose() in D:\Spraxa\Framework\DFramework\Database\NullableDataReader.cs:line 44 at CoolR.Tasks.ProcessAlertData.Execute() in D:\Spraxa\CoolR-Group\portal\CoolR.Tasks\ProcessAlertData.cs:line 47 at DFramework.Scheduler.TaskBase.Run() in D:\Spraxa\Framework\DFramework.Scheduler\TaskBase.cs:line 176 at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx) at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx) at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state) at System.Threading.ThreadHelper.ThreadStart() 2025-12-28 22:54:50.1117 DFramework.Database.NullableDataReader Data reader open for 424 at System.Environment.GetStackTrace(Exception e, Boolean needFileInfo) at System.Environment.get_StackTrace() at DFramework.Database.NullableDataReader.Dispose(Boolean disposing) in D:\Spraxa\Framework\DFramework\Database\NullableDataReader.cs:line 33 at DFramework.Database.NullableDataReader.Dispose() in D:\Spraxa\Framework\DFramework\Database\NullableDataReader.cs:line 44 at CoolR.Tasks.ProcessAlertData.Execute() in D:\Spraxa\CoolR-Group\portal\CoolR.Tasks\ProcessAlertData.cs:line 47 at DFramework.Scheduler.TaskBase.Run() in D:\Spraxa\Framework\DFramework.Scheduler\TaskBase.cs:line 176 at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx) at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx) at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state) at System.Threading.ThreadHelper.ThreadStart() 2025-12-28 22:54:51.8149 DFramework.Database.NullableDataReader Data reader open for 239 at System.Environment.GetStackTrace(Exception e, Boolean needFileInfo) at System.Environment.get_StackTrace() at DFramework.Database.NullableDataReader.Dispose(Boolean disposing) in D:\Spraxa\Framework\DFramework\Database\NullableDataReader.cs:line 33 at DFramework.Database.NullableDataReader.Dispose() in D:\Spraxa\Framework\DFramework\Database\NullableDataReader.cs:line 44 at CoolR.Tasks.ProcessAlertData.Execute() in D:\Spraxa\CoolR-Group\portal\CoolR.Tasks\ProcessAlertData.cs:line 47 at DFramework.Scheduler.TaskBase.Run() in D:\Spraxa\Framework\DFramework.Scheduler\TaskBase.cs:line 176 at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx) at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx) at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state) at System.Threading.ThreadHelper.ThreadStart() 2025-12-28 22:54:51.8618 DFramework.Database.NullableDataReader Data reader open for 322 at System.Environment.GetStackTrace(Exception e, Boolean needFileInfo) at System.Environment.get_StackTrace() at DFramework.Database.NullableDataReader.Dispose(Boolean disposing) in D:\Spraxa\Framework\DFramework\Database\NullableDataReader.cs:line 33 at DFramework.Database.NullableDataReader.Dispose() in D:\Spraxa\Framework\DFramework\Database\NullableDataReader.cs:line 44 at CoolR.Tasks.ProcessAlertData.Execute() in D:\Spraxa\CoolR-Group\portal\CoolR.Tasks\ProcessAlertData.cs:line 47 at DFramework.Scheduler.TaskBase.Run() in D:\Spraxa\Framework\DFramework.Scheduler\TaskBase.cs:line 176 at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx) at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx) at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state) at System.Threading.ThreadHelper.ThreadStart() 2025-12-28 22:54:52.5649 DFramework.Database.NullableDataReader Data reader open for 226 at System.Environment.GetStackTrace(Exception e, Boolean needFileInfo) at System.Environment.get_StackTrace() at DFramework.Database.NullableDataReader.Dispose(Boolean disposing) in D:\Spraxa\Framework\DFramework\Database\NullableDataReader.cs:line 33 at DFramework.Database.NullableDataReader.Dispose() in D:\Spraxa\Framework\DFramework\Database\NullableDataReader.cs:line 44 at CoolR.Tasks.ProcessAlertData.Execute() in D:\Spraxa\CoolR-Group\portal\CoolR.Tasks\ProcessAlertData.cs:line 47 at DFramework.Scheduler.TaskBase.Run() in D:\Spraxa\Framework\DFramework.Scheduler\TaskBase.cs:line 176 at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx) at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx) at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state) at System.Threading.ThreadHelper.ThreadStart() 2025-12-28 22:54:53.1586 DFramework.Database.NullableDataReader Data reader open for 305 at System.Environment.GetStackTrace(Exception e, Boolean needFileInfo) at System.Environment.get_StackTrace() at DFramework.Database.NullableDataReader.Dispose(Boolean disposing) in D:\Spraxa\Framework\DFramework\Database\NullableDataReader.cs:line 33 at DFramework.Database.NullableDataReader.Dispose() in D:\Spraxa\Framework\DFramework\Database\NullableDataReader.cs:line 44 at CoolR.Tasks.ProcessAlertData.Execute() in D:\Spraxa\CoolR-Group\portal\CoolR.Tasks\ProcessAlertData.cs:line 47 at DFramework.Scheduler.TaskBase.Run() in D:\Spraxa\Framework\DFramework.Scheduler\TaskBase.cs:line 176 at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx) at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx) at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state) at System.Threading.ThreadHelper.ThreadStart() 2025-12-28 22:54:53.2055 DFramework.Database.NullableDataReader Data reader open for 388 at System.Environment.GetStackTrace(Exception e, Boolean needFileInfo) at System.Environment.get_StackTrace() at DFramework.Database.NullableDataReader.Dispose(Boolean disposing) in D:\Spraxa\Framework\DFramework\Database\NullableDataReader.cs:line 33 at DFramework.Database.NullableDataReader.Dispose() in D:\Spraxa\Framework\DFramework\Database\NullableDataReader.cs:line 44 at CoolR.Tasks.ProcessAlertData.Execute() in D:\Spraxa\CoolR-Group\portal\CoolR.Tasks\ProcessAlertData.cs:line 47 at DFramework.Scheduler.TaskBase.Run() in D:\Spraxa\Framework\DFramework.Scheduler\TaskBase.cs:line 176 at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx) at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx) at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state) at System.Threading.ThreadHelper.ThreadStart() 2025-12-28 22:54:54.2055 DFramework.Database.NullableDataReader Data reader open for 221 at System.Environment.GetStackTrace(Exception e, Boolean needFileInfo) at System.Environment.get_StackTrace() at DFramework.Database.NullableDataReader.Dispose(Boolean disposing) in D:\Spraxa\Framework\DFramework\Database\NullableDataReader.cs:line 33 at DFramework.Database.NullableDataReader.Dispose() in D:\Spraxa\Framework\DFramework\Database\NullableDataReader.cs:line 44 at CoolR.Tasks.ProcessAlertData.Execute() in D:\Spraxa\CoolR-Group\portal\CoolR.Tasks\ProcessAlertData.cs:line 47 at DFramework.Scheduler.TaskBase.Run() in D:\Spraxa\Framework\DFramework.Scheduler\TaskBase.cs:line 176 at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx) at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx) at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state) at System.Threading.ThreadHelper.ThreadStart() 2025-12-28 22:54:54.5336 AlertProcessor Replace Tags updated for the Image Id: 3675240 2025-12-28 22:54:54.6899 DFramework.Database.NullableDataReader Data reader open for 225 at System.Environment.GetStackTrace(Exception e, Boolean needFileInfo) at System.Environment.get_StackTrace() at DFramework.Database.NullableDataReader.Dispose(Boolean disposing) in D:\Spraxa\Framework\DFramework\Database\NullableDataReader.cs:line 33 at DFramework.Database.NullableDataReader.Dispose() in D:\Spraxa\Framework\DFramework\Database\NullableDataReader.cs:line 44 at CoolR.Tasks.ProcessAlertData.Execute() in D:\Spraxa\CoolR-Group\portal\CoolR.Tasks\ProcessAlertData.cs:line 47 at DFramework.Scheduler.TaskBase.Run() in D:\Spraxa\Framework\DFramework.Scheduler\TaskBase.cs:line 176 at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx) at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx) at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state) at System.Threading.ThreadHelper.ThreadStart() 2025-12-28 22:54:55.8462 DFramework.Database.NullableDataReader Data reader open for 220 at System.Environment.GetStackTrace(Exception e, Boolean needFileInfo) at System.Environment.get_StackTrace() at DFramework.Database.NullableDataReader.Dispose(Boolean disposing) in D:\Spraxa\Framework\DFramework\Database\NullableDataReader.cs:line 33 at DFramework.Database.NullableDataReader.Dispose() in D:\Spraxa\Framework\DFramework\Database\NullableDataReader.cs:line 44 at CoolR.Tasks.ProcessAlertData.Execute() in D:\Spraxa\CoolR-Group\portal\CoolR.Tasks\ProcessAlertData.cs:line 47 at DFramework.Scheduler.TaskBase.Run() in D:\Spraxa\Framework\DFramework.Scheduler\TaskBase.cs:line 176 at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx) at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx) at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state) at System.Threading.ThreadHelper.ThreadStart() 2025-12-28 22:54:56.6430 DFramework.Database.NullableDataReader Data reader open for 218 at System.Environment.GetStackTrace(Exception e, Boolean needFileInfo) at System.Environment.get_StackTrace() at DFramework.Database.NullableDataReader.Dispose(Boolean disposing) in D:\Spraxa\Framework\DFramework\Database\NullableDataReader.cs:line 33 at DFramework.Database.NullableDataReader.Dispose() in D:\Spraxa\Framework\DFramework\Database\NullableDataReader.cs:line 44 at CoolR.Tasks.ProcessAlertData.Execute() in D:\Spraxa\CoolR-Group\portal\CoolR.Tasks\ProcessAlertData.cs:line 47 at DFramework.Scheduler.TaskBase.Run() in D:\Spraxa\Framework\DFramework.Scheduler\TaskBase.cs:line 176 at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx) at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx) at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state) at System.Threading.ThreadHelper.ThreadStart() 2025-12-28 22:54:57.2368 DFramework.Database.Query /* Time Taken: 590*/ DECLARE @TableName AnsiString(8000) SET @TableName = 'ProductStockLevel' DECLARE @CurrentRecordId Int32 SET @CurrentRecordId = '3675240' dbo.GetValidDeviceForAlertProcessData 2025-12-28 22:54:57.4243 AlertProcessor ProcessorAlertData: Stopped 2025-12-28 22:54:58.5337 DFramework.Scheduler.TaskBase /* Time Taken: 15937.6181*/ Opportunity Out Of Stock By Outlet 2025-12-28 22:59:48.8796 AlertProcessor ProcessorAlertData: started 2025-12-28 22:59:54.7234 AlertProcessor ProcessorAlertData: Stopped 2025-12-28 23:04:48.8818 AlertProcessor ProcessorAlertData: started 2025-12-28 23:04:49.5224 DFramework.Database.Query /* Time Taken: 645*/ DECLARE @TableName AnsiString(8000) SET @TableName = 'TagAlert' DECLARE @CurrentRecordId Int32 SET @CurrentRecordId = '0' dbo.GetValidDeviceForAlertProcessData 2025-12-28 23:04:51.8506 DFramework.Database.NullableDataReader Data reader open for 283 at System.Environment.GetStackTrace(Exception e, Boolean needFileInfo) at System.Environment.get_StackTrace() at DFramework.Database.NullableDataReader.Dispose(Boolean disposing) in D:\Spraxa\Framework\DFramework\Database\NullableDataReader.cs:line 33 at DFramework.Database.NullableDataReader.Dispose() in D:\Spraxa\Framework\DFramework\Database\NullableDataReader.cs:line 44 at CoolR.Tasks.ProcessAlertData.Execute() in D:\Spraxa\CoolR-Group\portal\CoolR.Tasks\ProcessAlertData.cs:line 47 at DFramework.Scheduler.TaskBase.Run() in D:\Spraxa\Framework\DFramework.Scheduler\TaskBase.cs:line 176 at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx) at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx) at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state) at System.Threading.ThreadHelper.ThreadStart() 2025-12-28 23:04:52.3350 DFramework.Database.NullableDataReader Data reader open for 225 at System.Environment.GetStackTrace(Exception e, Boolean needFileInfo) at System.Environment.get_StackTrace() at DFramework.Database.NullableDataReader.Dispose(Boolean disposing) in D:\Spraxa\Framework\DFramework\Database\NullableDataReader.cs:line 33 at DFramework.Database.NullableDataReader.Dispose() in D:\Spraxa\Framework\DFramework\Database\NullableDataReader.cs:line 44 at CoolR.Tasks.ProcessAlertData.Execute() in D:\Spraxa\CoolR-Group\portal\CoolR.Tasks\ProcessAlertData.cs:line 47 at DFramework.Scheduler.TaskBase.Run() in D:\Spraxa\Framework\DFramework.Scheduler\TaskBase.cs:line 176 at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx) at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx) at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state) at System.Threading.ThreadHelper.ThreadStart() 2025-12-28 23:04:52.9600 DFramework.Database.NullableDataReader Data reader open for 344 at System.Environment.GetStackTrace(Exception e, Boolean needFileInfo) at System.Environment.get_StackTrace() at DFramework.Database.NullableDataReader.Dispose(Boolean disposing) in D:\Spraxa\Framework\DFramework\Database\NullableDataReader.cs:line 33 at DFramework.Database.NullableDataReader.Dispose() in D:\Spraxa\Framework\DFramework\Database\NullableDataReader.cs:line 44 at CoolR.Tasks.ProcessAlertData.Execute() in D:\Spraxa\CoolR-Group\portal\CoolR.Tasks\ProcessAlertData.cs:line 47 at DFramework.Scheduler.TaskBase.Run() in D:\Spraxa\Framework\DFramework.Scheduler\TaskBase.cs:line 176 at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx) at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx) at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state) at System.Threading.ThreadHelper.ThreadStart() 2025-12-28 23:04:53.0225 DFramework.Database.NullableDataReader Data reader open for 427 at System.Environment.GetStackTrace(Exception e, Boolean needFileInfo) at System.Environment.get_StackTrace() at DFramework.Database.NullableDataReader.Dispose(Boolean disposing) in D:\Spraxa\Framework\DFramework\Database\NullableDataReader.cs:line 33 at DFramework.Database.NullableDataReader.Dispose() in D:\Spraxa\Framework\DFramework\Database\NullableDataReader.cs:line 44 at CoolR.Tasks.ProcessAlertData.Execute() in D:\Spraxa\CoolR-Group\portal\CoolR.Tasks\ProcessAlertData.cs:line 47 at DFramework.Scheduler.TaskBase.Run() in D:\Spraxa\Framework\DFramework.Scheduler\TaskBase.cs:line 176 at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx) at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx) at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state) at System.Threading.ThreadHelper.ThreadStart() 2025-12-28 23:04:54.0537 DFramework.Database.NullableDataReader Data reader open for 205 at System.Environment.GetStackTrace(Exception e, Boolean needFileInfo) at System.Environment.get_StackTrace() at DFramework.Database.NullableDataReader.Dispose(Boolean disposing) in D:\Spraxa\Framework\DFramework\Database\NullableDataReader.cs:line 33 at DFramework.Database.NullableDataReader.Dispose() in D:\Spraxa\Framework\DFramework\Database\NullableDataReader.cs:line 44 at CoolR.Tasks.ProcessAlertData.Execute() in D:\Spraxa\CoolR-Group\portal\CoolR.Tasks\ProcessAlertData.cs:line 47 at DFramework.Scheduler.TaskBase.Run() in D:\Spraxa\Framework\DFramework.Scheduler\TaskBase.cs:line 176 at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx) at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx) at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state) at System.Threading.ThreadHelper.ThreadStart() 2025-12-28 23:04:54.1006 DFramework.Database.NullableDataReader Data reader open for 288 at System.Environment.GetStackTrace(Exception e, Boolean needFileInfo) at System.Environment.get_StackTrace() at DFramework.Database.NullableDataReader.Dispose(Boolean disposing) in D:\Spraxa\Framework\DFramework\Database\NullableDataReader.cs:line 33 at DFramework.Database.NullableDataReader.Dispose() in D:\Spraxa\Framework\DFramework\Database\NullableDataReader.cs:line 44 at CoolR.Tasks.ProcessAlertData.Execute() in D:\Spraxa\CoolR-Group\portal\CoolR.Tasks\ProcessAlertData.cs:line 47 at DFramework.Scheduler.TaskBase.Run() in D:\Spraxa\Framework\DFramework.Scheduler\TaskBase.cs:line 176 at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx) at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx) at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state) at System.Threading.ThreadHelper.ThreadStart() 2025-12-28 23:04:54.5537 AlertProcessor Replace Tags updated for the Image Id: 3675242 2025-12-28 23:04:54.7256 DFramework.Database.NullableDataReader Data reader open for 254 at System.Environment.GetStackTrace(Exception e, Boolean needFileInfo) at System.Environment.get_StackTrace() at DFramework.Database.NullableDataReader.Dispose(Boolean disposing) in D:\Spraxa\Framework\DFramework\Database\NullableDataReader.cs:line 33 at DFramework.Database.NullableDataReader.Dispose() in D:\Spraxa\Framework\DFramework\Database\NullableDataReader.cs:line 44 at CoolR.Tasks.ProcessAlertData.Execute() in D:\Spraxa\CoolR-Group\portal\CoolR.Tasks\ProcessAlertData.cs:line 47 at DFramework.Scheduler.TaskBase.Run() in D:\Spraxa\Framework\DFramework.Scheduler\TaskBase.cs:line 176 at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx) at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx) at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state) at System.Threading.ThreadHelper.ThreadStart() 2025-12-28 23:04:56.0694 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 D:\Spraxa\Framework\DFramework\Database\NullableDataReader.cs:line 33 at DFramework.Database.NullableDataReader.Dispose() in D:\Spraxa\Framework\DFramework\Database\NullableDataReader.cs:line 44 at CoolR.Tasks.ProcessAlertData.Execute() in D:\Spraxa\CoolR-Group\portal\CoolR.Tasks\ProcessAlertData.cs:line 47 at DFramework.Scheduler.TaskBase.Run() in D:\Spraxa\Framework\DFramework.Scheduler\TaskBase.cs:line 176 at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx) at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx) at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state) at System.Threading.ThreadHelper.ThreadStart() 2025-12-28 23:04:56.1162 DFramework.Database.NullableDataReader Data reader open for 477 at System.Environment.GetStackTrace(Exception e, Boolean needFileInfo) at System.Environment.get_StackTrace() at DFramework.Database.NullableDataReader.Dispose(Boolean disposing) in D:\Spraxa\Framework\DFramework\Database\NullableDataReader.cs:line 33 at DFramework.Database.NullableDataReader.Dispose() in D:\Spraxa\Framework\DFramework\Database\NullableDataReader.cs:line 44 at CoolR.Tasks.ProcessAlertData.Execute() in D:\Spraxa\CoolR-Group\portal\CoolR.Tasks\ProcessAlertData.cs:line 47 at DFramework.Scheduler.TaskBase.Run() in D:\Spraxa\Framework\DFramework.Scheduler\TaskBase.cs:line 176 at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx) at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx) at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state) at System.Threading.ThreadHelper.ThreadStart() 2025-12-28 23:04:56.9131 DFramework.Database.NullableDataReader Data reader open for 223 at System.Environment.GetStackTrace(Exception e, Boolean needFileInfo) at System.Environment.get_StackTrace() at DFramework.Database.NullableDataReader.Dispose(Boolean disposing) in D:\Spraxa\Framework\DFramework\Database\NullableDataReader.cs:line 33 at DFramework.Database.NullableDataReader.Dispose() in D:\Spraxa\Framework\DFramework\Database\NullableDataReader.cs:line 44 at CoolR.Tasks.ProcessAlertData.Execute() in D:\Spraxa\CoolR-Group\portal\CoolR.Tasks\ProcessAlertData.cs:line 47 at DFramework.Scheduler.TaskBase.Run() in D:\Spraxa\Framework\DFramework.Scheduler\TaskBase.cs:line 176 at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx) at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx) at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state) at System.Threading.ThreadHelper.ThreadStart() 2025-12-28 23:04:57.5225 AlertProcessor ProcessorAlertData: Stopped 2025-12-28 23:09:44.3684 DFramework.Database.Query /* Time Taken: 1643*/ DECLARE @ClientId Int32 SET @ClientId = '213' DECLARE @MarketId Int32 SET @MarketId = '0' DECLARE @ClassificationId Int32 SET @ClassificationId = '0' DECLARE @LocationId Int32 SET @LocationId = '0' DECLARE @LocationTypeId Int32 SET @LocationTypeId = '0' DECLARE @StartDate DateTime2 SET @StartDate = '8/28/2025 12:00:00 AM' dbo.GetOpportunityOutOfStockDataByOutlet 2025-12-28 23:09:46.2746 DFramework.Database.Query /* Time Taken: 3359*/ [dbo].GenerateSystemAlerts 2025-12-28 23:09:48.8840 AlertProcessor ProcessorAlertData: started 2025-12-28 23:09:50.2747 DFramework.Database.Query /* Time Taken: 827*/ DECLARE @CreatedOn DateTime2 SET @CreatedOn = '12/29/2025 12:00:00 AM' DECLARE @EventId Int32 SET @EventId = '-12' SELECT COUNT(1) FROM EmailQueue WHERE [CreatedOn] >= @CreatedOn AND [EventId] = @EventId 2025-12-28 23:09:50.3372 DFramework.Database.Query /* Time Taken: 1455*/ DECLARE @TableName AnsiString(8000) SET @TableName = 'TagAlert' DECLARE @CurrentRecordId Int32 SET @CurrentRecordId = '0' dbo.GetValidDeviceForAlertProcessData 2025-12-28 23:09:50.6809 DFramework.Database.Query /* Time Taken: 1303*/ DECLARE @ClientId Int32 SET @ClientId = '286' DECLARE @MarketId Int32 SET @MarketId = '0' DECLARE @ClassificationId Int32 SET @ClassificationId = '0' DECLARE @LocationId Int32 SET @LocationId = '0' DECLARE @LocationTypeId Int32 SET @LocationTypeId = '0' DECLARE @StartDate DateTime2 SET @StartDate = '11/1/2025 12:00:00 AM' dbo.GetOpportunityOutOfStockDataByOutlet 2025-12-28 23:09:51.1028 DFramework.Database.Query /* Time Taken: 1667*/ DECLARE @StatusId Int32 SET @StatusId = '1' DECLARE @AlertId Int32 SET @AlertId = '7571914' SELECT TOP 10000 Alert.AlertId, Alert.LocationId, Alert.RecordId, ISNULL(AlertDefinition.Name, Alert.AlertText) Name, Alert.AlertTypeId, Alert.AlertText, ISNULL(Location.Name, '') AS LocationName, AlertDefinition.ClientId, AlertRecipient.RoleId, CASE WHEN Alert.AlertTypeId IN (6,7) THEN CONVERT(VARCHAR(10), CAST(AlertAt AS DATE), 101) ELSE AlertAt END AS AlertAt, AlertType, Asset.SerialNumber, ISNULL(LocationAttribute.FirstRepId, 0) RepId, ClientUser.PrimaryPhone AS SalesRepPhone, ClientUser.PrimaryEmail AS SalesRepEmail, FirstName, LastName, PreferedNotificationTypeIds, AlertRecipientId, AlertRecipientAddress, AlertRecipientText, Alert.Tags, AlertRecipientTypeId, NotificationContactTypeId, TemplateId, AlertDefinition.AlertAgeThreshold, LastUpdatedOn, AlertRecipient.AlertAge, CASE WHEN Location.TimeZoneId IS NOT NULL AND Location.TimeZoneId > 0 THEN Location.TimeZoneId ELSE Client.TimeZoneId END AS TimeZoneId, AlertDefinition.IsSummarize, Alert.ClosedOn, AssetType.IsChestCooler, AlertDefinition.SnoozeForHours, Alert.SnoozeDateTime FROM Alert LEFT OUTER JOIN Asset ON Alert.AssetId = Asset.AssetId LEFT OUTER JOIN AlertType ON Alert.AlertTypeId = AlertType.AlertTypeId LEFT OUTER JOIN AlertDefinition ON Alert.AlertDefinitionId = AlertDefinition.AlertDefinitionId LEFT OUTER JOIN Location ON Location.LocationId = Alert.LocationId LEFT OUTER JOIN LocationAttribute ON LocationAttribute.LocationId = dbo.Location.LocationId LEFT OUTER JOIN ClientUser ON LocationAttribute.FirstRepId = ClientUser.ClientUserId AND ClientUser.IsDeleted = 0 LEFT OUTER JOIN AlertRecipient ON Alert.AlertDefinitionId = AlertRecipient.AlertDefinitionId AND AlertRecipient.IsDeleted= 0 LEFT OUTER JOIN Client ON Client.ClientId = Alert.ClientId LEFT OUTER JOIN AssetType ON dbo.Asset.AssetTypeId = dbo.AssetType.AssetTypeId WHERE (NOT EXISTS(SELECT 1 FROM dbo.EmailQueue INNER JOIN dbo.EmailRecipient ON EmailRecipient.EmailQueueId = EmailQueue.EmailQueueId WHERE AlertId = Alert.AlertId AND EmailRecipient.RecipientId = AlertRecipient.AlertRecipientId) OR (Alert.SnoozeDateTime IS NOT NULL AND Alert.SnoozeDateTime <= GETUTCDATE() AND AlertDefinition.SnoozeForHours > 0 AND Alert.StatusId = @StatusId)) AND Alert.AlertId > @AlertId AND Alert.AlertAt >= DATEADD(DAY, -120, GETDATE()) AND AlertRecipient.IsDeleted = 0 AND Alert.IsActive = 1 AND Alert.IsDeleted = 0 AND AlertRecipient.IsActive = 1 AND AlertRecipient.IsDeleted = 0 AND AlertRecipient.StartDate <= Alert.CreatedOn AND Alert.CreatedOn < DATEADD(hh, 23, AlertRecipient.EndDate) AND (Alert.LocationId != 0 OR NotificationWithoutLocation = 1) AND AlertType.IsSystemAlert = 0 AND Alert.EmailQueuedOn IS NULL AND AlertDefinition.IsActive = 1 2025-12-28 23:09:51.1497 DFramework.Database.Query /* Time Taken: 763*/ DECLARE @TableName AnsiString(8000) SET @TableName = 'VoidAlert' DECLARE @CurrentRecordId Int32 SET @CurrentRecordId = '3675242' dbo.GetValidDeviceForAlertProcessData 2025-12-28 23:09:52.5715 DFramework.Database.Query /* Time Taken: 906*/ DECLARE @TemplateId Int32 SET @TemplateId = '76' DECLARE @EventId Int32 SET @EventId = '19' DECLARE @IsHtml Boolean SET @IsHtml = 'False' DECLARE @Subject AnsiString(8000) SET @Subject = '' DECLARE @Body AnsiString(8000) SET @Body = '' DECLARE @FromName AnsiString(8000) SET @FromName = '' DECLARE @FromEmailAddress AnsiString(8000) SET @FromEmailAddress = '' DECLARE @AddlTo AnsiString(8000) SET @AddlTo = '' DECLARE @AddlCc AnsiString(8000) SET @AddlCc = '' DECLARE @AddlBcc AnsiString(8000) SET @AddlBcc = '' DECLARE @Tags String(-1) SET @Tags = '{"Threshold":"40","AlertId":"13785421","productInformation":"\u003ctable style =\u0027border:1px solid #999999;border-collapse: collapse\u0027\u003e\u003ctr\u003e\u003cth style =\u0027border:1px solid #999999;border-collapse: collapse\u0027\u003eProductSKU\u003c/th\u003e\u003cth style =\u0027border:1px solid #999999;border-collapse: collapse\u0027\u003eProduct UPC\u003c/th\u003e\u003cth style =\u0027border:1px solid #999999;border-collapse: collapse\u0027\u003eProduct Name\u003c/th\u003e\u003cth style =\u0027border:1px solid #999999;border-collapse: collapse\u0027\u003eFacings In Store\u003c/th\u003e\u003cth style =\u0027border:1px solid #999999;border-collapse: collapse\u0027\u003eFacing In Planogram\u003c/th\u003e\u003cth style =\u0027border:1px solid #999999;border-collapse: collapse\u0027\u003e% Of Product\u003c/th\u003e\u003cth style =\u0027border:1px solid #999999;border-collapse: collapse\u0027\u003eIsForeign\u003c/th\u003e\u003cth style =\u0027border:1px solid #999999;border-collapse: collapse\u0027\u003eIsEmpty\u003c/th\u003e\u003cth style =\u0027border:1px solid #999999;border-collapse: collapse\u0027\u003estockValue\u003c/th\u003e\u003cth style =\u0027border:1px solid #999999;border-collapse: collapse\u0027\u003eIsActive\u003c/th\u003e\u003c/tr\u003e\u003ctr\u003e\u003ctd style =\u0027border:1px solid #999999;border-collapse: collapse\u0027\u003eEmpty\u003c/td\u003e\u003ctd style =\u0027border:1px solid #999999;border-collapse: collapse\u0027\u003e\u003c/td\u003e\u003ctd style =\u0027border:1px solid #999999;border-collapse: collapse;text-align: right\u0027\u003eEmpty\u003c/td\u003e\u003ctd style =\u0027border:1px solid #999999;border-collapse: collapse;text-align: right\u0027\u003e7\u003c/td\u003e\u003ctd style =\u0027border:1px solid #999999;border-collapse: collapse;text-align: right\u0027\u003e0\u003c/td\u003e\u003ctd style =\u0027border:1px solid #999999;border-collapse: collapse;text-align: right\u0027\u003e175.00\u003c/td\u003e\u003c/tr\u003e\u003ctr\u003e\u003ctd style =\u0027border:1px solid #999999;border-collapse: collapse\u0027\u003e85073\u003c/td\u003e\u003ctd style =\u0027border:1px solid #999999;border-collapse: collapse\u0027\u003e85073\u003c/td\u003e\u003ctd style =\u0027border:1px solid #999999;border-collapse: collapse;text-align: right\u0027\u003eFeast Chocolate 70ml(MYTHOS ?????)\u003c/td\u003e\u003ctd style =\u0027border:1px solid #999999;border-collapse: collapse;text-align: right\u0027\u003e0\u003c/td\u003e\u003ctd style =\u0027border:1px solid #999999;border-collapse: collapse;text-align: right\u0027\u003e2\u003c/td\u003e\u003ctd style =\u0027border:1px solid #999999;border-collapse: collapse;text-align: right\u0027\u003e0.00\u003c/td\u003e\u003c/tr\u003e\u003ctr\u003e\u003ctd style =\u0027border:1px solid #999999;border-collapse: collapse\u0027\u003e85597\u003c/td\u003e\u003ctd style =\u0027border:1px solid #999999;border-collapse: collapse\u0027\u003e85597\u003c/td\u003e\u003ctd style =\u0027border:1px solid #999999;border-collapse: collapse;text-align: right\u0027\u003eOrange Maha Bar 65ml\u003c/td\u003e\u003ctd style =\u0027border:1px solid #999999;border-collapse: collapse;text-align: right\u0027\u003e0\u003c/td\u003e\u003ctd style =\u0027border:1px solid #999999;border-collapse: collapse;text-align: right\u0027\u003e2\u003c/td\u003e\u003ctd style =\u0027border:1px solid #999999;border-collapse: collapse;text-align: right\u0027\u003e0.00\u003c/td\u003e\u003c/tr\u003e\u003c/table\u003e","getImageForPurityAlert":"true","firstImage":"https://dev.coolrgroup.com/Thumbnail.ashx?Guid=psnbrxwlsmowo\u0026ImageType=Cam1\u0026maxWidth=300","secondImage":"https://dev.coolrgroup.com/Thumbnail.ashx?Guid=psnbrxwlsmowo\u0026ImageType=Cam2\u0026maxWidth=300","stitchedImage":"https://dev.coolrgroup.com/Thumbnail.ashx?Guid=psnbrxwlsmowo\u0026maxWidth=300\u0026ImageType=Stitched","inStock":"https://dev.coolrgroup.com/Thumbnail.ashx?Guid=psnbrxwlsmowo\u0026maxWidth=300\u0026ImageType=InStore","inStockWithTag":"https://dev.coolrgroup.com/Thumbnail.ashx?Guid=psnbrxwlsmowo\u0026maxWidth=300\u0026ImageType=InStore\u0026IssueType=1","inStockWithVoid":"https://dev.coolrgroup.com/Thumbnail.ashx?Guid=psnbrxwlsmowo\u0026maxWidth=300\u0026ImageType=InStore\u0026IssueType=2","inStockWithTagVoid":"https://dev.coolrgroup.com/Thumbnail.ashx?Guid=psnbrxwlsmowo\u0026maxWidth=300\u0026ImageType=InStore\u0026IssueType=3","planogram":"https://dev.coolrgroup.com/Thumbnail.ashx?Guid=psnbrxwlsmowo\u0026maxWidth=300\u0026ImageType=Planogram","imageName":"8l6ajxnro2bk9.jpg"}' DECLARE @StatusId Byte SET @StatusId = '0' DECLARE @CreatedByUserId AnsiString(8000) SET @CreatedByUserId = '0' DECLARE @CreatedOn DateTime2 SET @CreatedOn = '12/29/2025 7:09:51 AM' DECLARE @ModifiedByUserId AnsiString(8000) SET @ModifiedByUserId = '0' DECLARE @ModifiedOn DateTime2 SET @ModifiedOn = '12/29/2025 7:09:51 AM' INSERT INTO EmailQueue (TemplateId,EventId,IsHtml,Subject,Body,FromName,FromEmailAddress,AddlTo,AddlCc,AddlBcc,Tags,StatusId,CreatedByUserId,CreatedOn,ModifiedByUserId,ModifiedOn) VALUES (@TemplateId,@EventId,@IsHtml,@Subject,@Body,@FromName,@FromEmailAddress,@AddlTo,@AddlCc,@AddlBcc,@Tags,@StatusId,@CreatedByUserId,@CreatedOn,@ModifiedByUserId,@ModifiedOn) ; SELECT NewId = SCOPE_IDENTITY() 2025-12-28 23:09:55.2747 DFramework.Database.Query /* Time Taken: 4023*/ DECLARE @TableName AnsiString(8000) SET @TableName = 'MissingShelf' DECLARE @CurrentRecordId Int32 SET @CurrentRecordId = '3675242' dbo.GetValidDeviceForAlertProcessData 2025-12-28 23:09:56.4309 DFramework.Database.Query /* Time Taken: 565*/ DECLARE @TableName AnsiString(8000) SET @TableName = 'OpportunityOutOfStock' DECLARE @CurrentRecordId Int32 SET @CurrentRecordId = '3675242' dbo.GetValidDeviceForAlertProcessData 2025-12-28 23:09:56.4934 DFramework.Database.Query /* Time Taken: 677*/ DECLARE @ClientId Int32 SET @ClientId = '1494' 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 = '6/14/2025 12:00:00 AM' dbo.GetOpportunityOutOfStockDataByOutlet 2025-12-28 23:09:58.8841 DFramework.Database.Query /* Time Taken: 624*/ DECLARE @TableName AnsiString(8000) SET @TableName = 'AssetPurity' DECLARE @CurrentRecordId Int32 SET @CurrentRecordId = '3675242' dbo.GetValidDeviceForAlertProcessData 2025-12-28 23:09:59.5560 DFramework.Database.Query /* Time Taken: 598*/ DECLARE @TableName AnsiString(8000) SET @TableName = 'OpportunityLowStock' DECLARE @CurrentRecordId Int32 SET @CurrentRecordId = '3675242' dbo.GetValidDeviceForAlertProcessData 2025-12-28 23:10:00.2435 DFramework.Database.Query /* Time Taken: 630*/ DECLARE @TableName AnsiString(8000) SET @TableName = 'AssetStockProductCategoryWise' DECLARE @CurrentRecordId Int32 SET @CurrentRecordId = '3675242' dbo.GetValidDeviceForAlertProcessData 2025-12-28 23:10:00.9154 DFramework.Database.Query /* Time Taken: 609*/ DECLARE @TableName AnsiString(8000) SET @TableName = 'LowInventoryConsolidate' DECLARE @CurrentRecordId Int32 SET @CurrentRecordId = '3675242' dbo.GetValidDeviceForAlertProcessData 2025-12-28 23:10:01.7279 DFramework.Database.Query /* Time Taken: 752*/ DECLARE @TableName AnsiString(8000) SET @TableName = 'TargetPortfolioComplianceConsolidate' DECLARE @CurrentRecordId Int32 SET @CurrentRecordId = '3675242' dbo.GetValidDeviceForAlertProcessData 2025-12-28 23:10:02.1497 DFramework.Scheduler.TaskBase /* Time Taken: 19531.3939*/ Opportunity Out Of Stock By Outlet 2025-12-28 23:10:03.0873 DFramework.Database.Query /* Time Taken: 1284*/ DECLARE @TableName AnsiString(8000) SET @TableName = 'ProductStockLevel' DECLARE @CurrentRecordId Int32 SET @CurrentRecordId = '3675242' dbo.GetValidDeviceForAlertProcessData 2025-12-28 23:10:03.1654 AlertProcessor ProcessorAlertData: Stopped 2025-12-28 23:10:03.1654 DFramework.Scheduler.TaskBase /* Time Taken: 14281.3529*/ Process Alert Record 2025-12-28 23:14:48.9019 AlertProcessor ProcessorAlertData: started 2025-12-28 23:14:54.3550 AlertProcessor ProcessorAlertData: Stopped 2025-12-28 23:19:48.9197 AlertProcessor ProcessorAlertData: started 2025-12-28 23:19:54.5760 AlertProcessor ProcessorAlertData: Stopped 2025-12-28 23:24:43.4844 DFramework.Database.Query /* Time Taken: 555*/ [dbo].GenerateSystemAlerts 2025-12-28 23:24:48.9376 AlertProcessor ProcessorAlertData: started 2025-12-28 23:24:54.3439 AlertProcessor ProcessorAlertData: Stopped 2025-12-28 23:24:58.4532 DFramework.Scheduler.TaskBase /* Time Taken: 15812.6168*/ Opportunity Out Of Stock By Outlet 2025-12-28 23:29:48.9554 AlertProcessor ProcessorAlertData: started 2025-12-28 23:29:54.7836 AlertProcessor ProcessorAlertData: Stopped 2025-12-28 23:34:44.7857 MoveToReorder Running task for ClientId : 286 and ClientName = India Office QA and Slot: 12/29/2025 1:00:00 PM And LastExecutedOn: 12/29/2025 12:04:44 PM 2025-12-28 23:34:45.1139 MoveToReorder Task executed successfully for ClientId : 286 Client Name:India Office QA, Slot: 12/29/2025 1:00:00 PM But No Order found to suggest 2025-12-28 23:34:48.9733 AlertProcessor ProcessorAlertData: started 2025-12-28 23:34:49.8483 DFramework.Database.Query /* Time Taken: 551*/ DECLARE @TableName AnsiString(8000) SET @TableName = 'VoidAlert' DECLARE @CurrentRecordId Int32 SET @CurrentRecordId = '3675242' dbo.GetValidDeviceForAlertProcessData 2025-12-28 23:34:54.8639 AlertProcessor ProcessorAlertData: Stopped 2025-12-28 23:39:48.9911 AlertProcessor ProcessorAlertData: started 2025-12-28 23:39:50.1786 DFramework.Database.Query /* Time Taken: 522*/ DECLARE @TableName AnsiString(8000) SET @TableName = 'MissingShelf' DECLARE @CurrentRecordId Int32 SET @CurrentRecordId = '3675242' dbo.GetValidDeviceForAlertProcessData 2025-12-28 23:39:50.8974 DFramework.Database.Query /* Time Taken: 654*/ DECLARE @TableName AnsiString(8000) SET @TableName = 'AdditionalShelf' DECLARE @CurrentRecordId Int32 SET @CurrentRecordId = '3675242' dbo.GetValidDeviceForAlertProcessData 2025-12-28 23:39:54.8818 AlertProcessor ProcessorAlertData: Stopped 2025-12-28 23:39:58.4599 DFramework.Scheduler.TaskBase /* Time Taken: 15796.9972*/ Opportunity Out Of Stock By Outlet 2025-12-28 23:44:49.0089 AlertProcessor ProcessorAlertData: started 2025-12-28 23:44:52.2277 DFramework.Database.Query /* Time Taken: 723*/ DECLARE @TableName AnsiString(8000) SET @TableName = 'AssetStockProductWiseConsolidate' DECLARE @CurrentRecordId Int32 SET @CurrentRecordId = '3675242' dbo.GetValidDeviceForAlertProcessData 2025-12-28 23:44:54.8215 AlertProcessor ProcessorAlertData: Stopped 2025-12-28 23:49:49.0268 AlertProcessor ProcessorAlertData: started 2025-12-28 23:49:52.0893 DFramework.Database.Query /* Time Taken: 527*/ DECLARE @TableName AnsiString(8000) SET @TableName = 'AssetStockProductWiseConsolidate' DECLARE @CurrentRecordId Int32 SET @CurrentRecordId = '3675242' dbo.GetValidDeviceForAlertProcessData 2025-12-28 23:49:54.7300 AlertProcessor ProcessorAlertData: Stopped 2025-12-28 23:54:43.4977 DFramework.Database.Query /* Time Taken: 518*/ [dbo].GenerateSystemAlerts 2025-12-28 23:54:49.0446 AlertProcessor ProcessorAlertData: started 2025-12-28 23:54:54.7166 AlertProcessor ProcessorAlertData: Stopped 2025-12-28 23:54:58.6228 DFramework.Scheduler.TaskBase /* Time Taken: 15937.6207*/ Opportunity Out Of Stock By Outlet 2025-12-28 23:59:49.0625 AlertProcessor ProcessorAlertData: started 2025-12-28 23:59:54.9844 DFramework.Database.Query /* Time Taken: 708*/ DECLARE @TableName AnsiString(8000) SET @TableName = 'ProductStockLevel' DECLARE @CurrentRecordId Int32 SET @CurrentRecordId = '3675242' dbo.GetValidDeviceForAlertProcessData 2025-12-28 23:59:55.0469 AlertProcessor ProcessorAlertData: Stopped