2026-01-18 22:54:14.4927 AlertProcessor    System.Threading.ThreadAbortException: Thread was being aborted.
   at Interop.Windows.Sni.SniNativeMethodsX64.SNIReadSyncOverAsync(SNIHandle pConn, IntPtr& ppNewPacket, Int32 timeout)
   at Microsoft.Data.SqlClient.TdsParserStateObjectNative.ReadSyncOverAsync(Int32 timeoutRemaining, UInt32& error)
   at Microsoft.Data.SqlClient.TdsParserStateObject.ReadSniSyncOverAsync()
   at Microsoft.Data.SqlClient.TdsParserStateObject.TryReadNetworkPacket()
   at Microsoft.Data.SqlClient.TdsParserStateObject.TryPrepareBuffer()
   at Microsoft.Data.SqlClient.TdsParserStateObject.TryReadByte(Byte& value)
   at Microsoft.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)
   at Microsoft.Data.SqlClient.SqlDataReader.TryConsumeMetaData()
   at Microsoft.Data.SqlClient.SqlDataReader.get_MetaData()
   at Microsoft.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString, Boolean isInternal, Boolean forDescribeParameterEncryption, Boolean shouldCacheForAlwaysEncrypted)
   at Microsoft.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, Boolean inRetry, SqlDataReader ds, Boolean describeParameterEncryptionRequest)
   at Microsoft.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry)
   at Microsoft.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method)
   at Microsoft.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method)
   at Microsoft.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior)
   at Microsoft.Data.SqlClient.SqlCommand.ExecuteDbDataReader(CommandBehavior behavior)
   at DFramework.Database.Query.<ExecuteReader>b__106_0(DbCommandParameters parameters) in C:\CoolR-Group\Framework\DFramework\Database\Query.cs:line 643
   at DFramework.Database.Query.ExecuteCommand[ReturnType](Func`2 method, IDbCommand cm, IDbTransaction tr) in C:\CoolR-Group\Framework\DFramework\Database\Query.cs:line 613
   at DFramework.Database.Query.ExecuteReader(IDbCommand cm, IDbTransaction tr) in C:\CoolR-Group\Framework\DFramework\Database\Query.cs:line 641
   at CoolR.Tasks.ProcessAlertData.StockAlertProductWise(Int32 alertId, Int32 currentRecordId, DateTime latestEventTime, Boolean isForAllProduct, Int32 stockThreshold, Int32 assetId, String alertText, Int32 alertDefinitionId, DateTime startDate, DateTime endDate, Int32 clientId, Int32 locationId, Int32 priorityId) in C:\CoolR-Group\portal\CoolR.Tasks\ProcessAlertData.cs:line 1455
   at CoolR.Tasks.ProcessAlertData.Execute() in C:\CoolR-Group\portal\CoolR.Tasks\ProcessAlertData.cs:line 343 System.Threading.ThreadAbortException: Thread was being aborted.
   at Interop.Windows.Sni.SniNativeMethodsX64.SNIReadSyncOverAsync(SNIHandle pConn, IntPtr& ppNewPacket, Int32 timeout)
   at Microsoft.Data.SqlClient.TdsParserStateObjectNative.ReadSyncOverAsync(Int32 timeoutRemaining, UInt32& error)
   at Microsoft.Data.SqlClient.TdsParserStateObject.ReadSniSyncOverAsync()
   at Microsoft.Data.SqlClient.TdsParserStateObject.TryReadNetworkPacket()
   at Microsoft.Data.SqlClient.TdsParserStateObject.TryPrepareBuffer()
   at Microsoft.Data.SqlClient.TdsParserStateObject.TryReadByte(Byte& value)
   at Microsoft.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)
   at Microsoft.Data.SqlClient.SqlDataReader.TryConsumeMetaData()
   at Microsoft.Data.SqlClient.SqlDataReader.get_MetaData()
   at Microsoft.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString, Boolean isInternal, Boolean forDescribeParameterEncryption, Boolean shouldCacheForAlwaysEncrypted)
   at Microsoft.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, Boolean inRetry, SqlDataReader ds, Boolean describeParameterEncryptionRequest)
   at Microsoft.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry)
   at Microsoft.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method)
   at Microsoft.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method)
   at Microsoft.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior)
   at Microsoft.Data.SqlClient.SqlCommand.ExecuteDbDataReader(CommandBehavior behavior)
   at DFramework.Database.Query.<ExecuteReader>b__106_0(DbCommandParameters parameters) in C:\CoolR-Group\Framework\DFramework\Database\Query.cs:line 643
   at DFramework.Database.Query.ExecuteCommand[ReturnType](Func`2 method, IDbCommand cm, IDbTransaction tr) in C:\CoolR-Group\Framework\DFramework\Database\Query.cs:line 613
   at DFramework.Database.Query.ExecuteReader(IDbCommand cm, IDbTransaction tr) in C:\CoolR-Group\Framework\DFramework\Database\Query.cs:line 641
   at CoolR.Tasks.ProcessAlertData.StockAlertProductWise(Int32 alertId, Int32 currentRecordId, DateTime latestEventTime, Boolean isForAllProduct, Int32 stockThreshold, Int32 assetId, String alertText, Int32 alertDefinitionId, DateTime startDate, DateTime endDate, Int32 clientId, Int32 locationId, Int32 priorityId) in C:\CoolR-Group\portal\CoolR.Tasks\ProcessAlertData.cs:line 1455
   at CoolR.Tasks.ProcessAlertData.Execute() in C:\CoolR-Group\portal\CoolR.Tasks\ProcessAlertData.cs:line 343 Query: DECLARE @AssetPurityId Int32 = 3676247,
@ProductId0 Int32 = 23607,
@ProductId1 Int32 = 36216,
@ProductId2 Int32 = 36217,
@ProductId3 Int32 = 36218,
@ProductId4 Int32 = 80,
@ProductId5 Int32 = 23468,
@ProductId6 Int32 = 23489,
@ProductId7 Int32 = 23494,
@ProductId8 Int32 = 22185,
@ProductId9 Int32 = 23463,
@ProductId10 Int32 = 23470,
@ProductId11 Int32 = 23479
SELECT ProductId, COUNT(1) ProductCount FROM AssetPurityProduct
 WHERE [AssetPurityId] = @AssetPurityId AND ProductId IN ( @ProductId0, @ProductId1, @ProductId2, @ProductId3, @ProductId4, @ProductId5, @ProductId6, @ProductId7, @ProductId8, @ProductId9, @ProductId10, @ProductId11 )
 GROUP BY [ProductId]


2026-01-18 22:54:14.6636 AlertProcessor    System.Threading.ThreadAbortException: Thread was being aborted.
   at CoolR.Tasks.ProcessAlertData.Execute() in C:\CoolR-Group\portal\CoolR.Tasks\ProcessAlertData.cs:line 399 System.Threading.ThreadAbortException: Thread was being aborted.
   at CoolR.Tasks.ProcessAlertData.Execute() in C:\CoolR-Group\portal\CoolR.Tasks\ProcessAlertData.cs:line 399
2026-01-18 22:54:14.7583 DFramework.Scheduler.TaskBase    Error in task: Process Alert Record System.Threading.ThreadAbortException: Thread was being aborted.
   at CoolR.Tasks.ProcessAlertData.Execute() in C:\CoolR-Group\portal\CoolR.Tasks\ProcessAlertData.cs:line 412
   at DFramework.Scheduler.TaskBase.Run() in E:\Forked\Framework\DFramework.Scheduler\TaskBase.cs:line 176
2026-01-18 22:54:14.8364 TaskExecution    Task Execution Error: Process Alert Record System.Threading.ThreadAbortException: Thread was being aborted.
   at CoolR.Tasks.ProcessAlertData.Execute() in C:\CoolR-Group\portal\CoolR.Tasks\ProcessAlertData.cs:line 412
   at DFramework.Scheduler.TaskBase.Run() in E:\Forked\Framework\DFramework.Scheduler\TaskBase.cs:line 176
2026-01-18 23:48:16.7907 AlertProcessor    System.Threading.ThreadAbortException: Thread was being aborted.
   at Interop.Windows.Sni.SniNativeMethodsX64.SNIReadSyncOverAsync(SNIHandle pConn, IntPtr& ppNewPacket, Int32 timeout)
   at Microsoft.Data.SqlClient.TdsParserStateObjectNative.ReadSyncOverAsync(Int32 timeoutRemaining, UInt32& error)
   at Microsoft.Data.SqlClient.TdsParserStateObject.ReadSniSyncOverAsync()
   at Microsoft.Data.SqlClient.TdsParserStateObject.TryReadNetworkPacket()
   at Microsoft.Data.SqlClient.TdsParserStateObject.TryPrepareBuffer()
   at Microsoft.Data.SqlClient.TdsParserStateObject.TryReadByte(Byte& value)
   at Microsoft.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)
   at Microsoft.Data.SqlClient.SqlDataReader.TryConsumeMetaData()
   at Microsoft.Data.SqlClient.SqlDataReader.get_MetaData()
   at Microsoft.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString, Boolean isInternal, Boolean forDescribeParameterEncryption, Boolean shouldCacheForAlwaysEncrypted)
   at Microsoft.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, Boolean inRetry, SqlDataReader ds, Boolean describeParameterEncryptionRequest)
   at Microsoft.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry)
   at Microsoft.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method)
   at Microsoft.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method)
   at Microsoft.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior)
   at Microsoft.Data.SqlClient.SqlCommand.ExecuteDbDataReader(CommandBehavior behavior)
   at DFramework.Database.Query.<ExecuteReader>b__106_0(DbCommandParameters parameters) in C:\CoolR-Group\Framework\DFramework\Database\Query.cs:line 643
   at DFramework.Database.Query.ExecuteCommand[ReturnType](Func`2 method, IDbCommand cm, IDbTransaction tr) in C:\CoolR-Group\Framework\DFramework\Database\Query.cs:line 613
   at DFramework.Database.Query.ExecuteReader(IDbCommand cm, IDbTransaction tr) in C:\CoolR-Group\Framework\DFramework\Database\Query.cs:line 641
   at DFramework.Business.BusinessBase.Fetch(Query query) in C:\CoolR-Group\Framework\DFramework\Business\BusinessBase.cs:line 798
   at CoolR.Business.BusinessBase`1.Fetch(Query query) in C:\CoolR-Group\portal\CoolR.Business\BusinessBase.cs:line 188
   at DFramework.Business.BusinessBase.Fetch(Int32 id) in C:\CoolR-Group\Framework\DFramework\Business\BusinessBase.cs:line 781
   at DFramework.Business.BusinessBase.Load(Int32 id) in C:\CoolR-Group\Framework\DFramework\Business\BusinessBase.cs:line 307
   at CoolR.Tasks.ProcessAlertData.StockAlertProductWise(Int32 alertId, Int32 currentRecordId, DateTime latestEventTime, Boolean isForAllProduct, Int32 stockThreshold, Int32 assetId, String alertText, Int32 alertDefinitionId, DateTime startDate, DateTime endDate, Int32 clientId, Int32 locationId, Int32 priorityId) in C:\CoolR-Group\portal\CoolR.Tasks\ProcessAlertData.cs:line 1399
   at CoolR.Tasks.ProcessAlertData.Execute() in C:\CoolR-Group\portal\CoolR.Tasks\ProcessAlertData.cs:line 343 System.Threading.ThreadAbortException: Thread was being aborted.
   at Interop.Windows.Sni.SniNativeMethodsX64.SNIReadSyncOverAsync(SNIHandle pConn, IntPtr& ppNewPacket, Int32 timeout)
   at Microsoft.Data.SqlClient.TdsParserStateObjectNative.ReadSyncOverAsync(Int32 timeoutRemaining, UInt32& error)
   at Microsoft.Data.SqlClient.TdsParserStateObject.ReadSniSyncOverAsync()
   at Microsoft.Data.SqlClient.TdsParserStateObject.TryReadNetworkPacket()
   at Microsoft.Data.SqlClient.TdsParserStateObject.TryPrepareBuffer()
   at Microsoft.Data.SqlClient.TdsParserStateObject.TryReadByte(Byte& value)
   at Microsoft.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)
   at Microsoft.Data.SqlClient.SqlDataReader.TryConsumeMetaData()
   at Microsoft.Data.SqlClient.SqlDataReader.get_MetaData()
   at Microsoft.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString, Boolean isInternal, Boolean forDescribeParameterEncryption, Boolean shouldCacheForAlwaysEncrypted)
   at Microsoft.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, Boolean inRetry, SqlDataReader ds, Boolean describeParameterEncryptionRequest)
   at Microsoft.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry)
   at Microsoft.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method)
   at Microsoft.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method)
   at Microsoft.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior)
   at Microsoft.Data.SqlClient.SqlCommand.ExecuteDbDataReader(CommandBehavior behavior)
   at DFramework.Database.Query.<ExecuteReader>b__106_0(DbCommandParameters parameters) in C:\CoolR-Group\Framework\DFramework\Database\Query.cs:line 643
   at DFramework.Database.Query.ExecuteCommand[ReturnType](Func`2 method, IDbCommand cm, IDbTransaction tr) in C:\CoolR-Group\Framework\DFramework\Database\Query.cs:line 613
   at DFramework.Database.Query.ExecuteReader(IDbCommand cm, IDbTransaction tr) in C:\CoolR-Group\Framework\DFramework\Database\Query.cs:line 641
   at DFramework.Business.BusinessBase.Fetch(Query query) in C:\CoolR-Group\Framework\DFramework\Business\BusinessBase.cs:line 798
   at CoolR.Business.BusinessBase`1.Fetch(Query query) in C:\CoolR-Group\portal\CoolR.Business\BusinessBase.cs:line 188
   at DFramework.Business.BusinessBase.Fetch(Int32 id) in C:\CoolR-Group\Framework\DFramework\Business\BusinessBase.cs:line 781
   at DFramework.Business.BusinessBase.Load(Int32 id) in C:\CoolR-Group\Framework\DFramework\Business\BusinessBase.cs:line 307
   at CoolR.Tasks.ProcessAlertData.StockAlertProductWise(Int32 alertId, Int32 currentRecordId, DateTime latestEventTime, Boolean isForAllProduct, Int32 stockThreshold, Int32 assetId, String alertText, Int32 alertDefinitionId, DateTime startDate, DateTime endDate, Int32 clientId, Int32 locationId, Int32 priorityId) in C:\CoolR-Group\portal\CoolR.Tasks\ProcessAlertData.cs:line 1399
   at CoolR.Tasks.ProcessAlertData.Execute() in C:\CoolR-Group\portal\CoolR.Tasks\ProcessAlertData.cs:line 343 Query: DECLARE @PlanogramId Int32 = 5948
SELECT * FROM dbo.[vwPlanogramInfo]

 WHERE [PlanogramId] = @PlanogramId
 ORDER BY [PlanogramId]

2026-01-18 23:48:17.0719 AlertProcessor    System.Threading.ThreadAbortException: Thread was being aborted.
   at CoolR.Tasks.ProcessAlertData.Execute() in C:\CoolR-Group\portal\CoolR.Tasks\ProcessAlertData.cs:line 399 System.Threading.ThreadAbortException: Thread was being aborted.
   at CoolR.Tasks.ProcessAlertData.Execute() in C:\CoolR-Group\portal\CoolR.Tasks\ProcessAlertData.cs:line 399
2026-01-18 23:48:17.1657 DFramework.Scheduler.TaskBase    Error in task: Process Alert Record System.Threading.ThreadAbortException: Thread was being aborted.
   at CoolR.Tasks.ProcessAlertData.Execute() in C:\CoolR-Group\portal\CoolR.Tasks\ProcessAlertData.cs:line 412
   at DFramework.Scheduler.TaskBase.Run() in E:\Forked\Framework\DFramework.Scheduler\TaskBase.cs:line 176
2026-01-18 23:48:17.2127 TaskExecution    Task Execution Error: Process Alert Record System.Threading.ThreadAbortException: Thread was being aborted.
   at CoolR.Tasks.ProcessAlertData.Execute() in C:\CoolR-Group\portal\CoolR.Tasks\ProcessAlertData.cs:line 412
   at DFramework.Scheduler.TaskBase.Run() in E:\Forked\Framework\DFramework.Scheduler\TaskBase.cs:line 176