2026-01-15 05:06:23.2320 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.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 D:\Spraxa\CoolR-Group\portal\CoolR.Tasks\ProcessAlertData.cs:line 1492 at CoolR.Tasks.ProcessAlertData.Execute() in D:\Spraxa\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.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 D:\Spraxa\CoolR-Group\portal\CoolR.Tasks\ProcessAlertData.cs:line 1492 at CoolR.Tasks.ProcessAlertData.Execute() in D:\Spraxa\CoolR-Group\portal\CoolR.Tasks\ProcessAlertData.cs:line 343 Query: DECLARE @AssetId Int32 = 118115, @AlertDefinitionId Int32 = 293, @AlertDefinitionProductStockId Int32 = 207, @AlertTypeId Int32 = 21 SELECT TOP 1 AlertId, ClosedOn FROM Alert WHERE [AssetId] = @AssetId AND [AlertDefinitionId] = @AlertDefinitionId AND [AlertDefinitionProductStockId] = @AlertDefinitionProductStockId AND [AlertTypeId] = @AlertTypeId ORDER BY [AlertAt] DESC 2026-01-15 05:06:23.2789 AlertProcessor System.Threading.ThreadAbortException: Thread was being aborted. at CoolR.Tasks.ProcessAlertData.Execute() in D:\Spraxa\CoolR-Group\portal\CoolR.Tasks\ProcessAlertData.cs:line 399 System.Threading.ThreadAbortException: Thread was being aborted. at CoolR.Tasks.ProcessAlertData.Execute() in D:\Spraxa\CoolR-Group\portal\CoolR.Tasks\ProcessAlertData.cs:line 399 2026-01-15 05:06:23.3883 DFramework.Scheduler.TaskBase Error in task: Process Alert Record System.Threading.ThreadAbortException: Thread was being aborted. at CoolR.Tasks.ProcessAlertData.Execute() in D:\Spraxa\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-15 05:06:23.4508 TaskExecution Task Execution Error: Process Alert Record System.Threading.ThreadAbortException: Thread was being aborted. at CoolR.Tasks.ProcessAlertData.Execute() in D:\Spraxa\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-15 05:35:36.8053 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.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 1497 at CoolR.Tasks.ProcessAlertData.Execute() in C:\CoolR-Group\portal\CoolR.Tasks\ProcessAlertData.cs:line 346 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.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 1497 at CoolR.Tasks.ProcessAlertData.Execute() in C:\CoolR-Group\portal\CoolR.Tasks\ProcessAlertData.cs:line 346 Query: DECLARE @AssetId Int32 = 118115, @AlertDefinitionId Int32 = 293, @AlertDefinitionProductStockId Int32 = 208, @AlertTypeId Int32 = 21 SELECT TOP 1 AlertId, ClosedOn FROM Alert WHERE [AssetId] = @AssetId AND [AlertDefinitionId] = @AlertDefinitionId AND [AlertDefinitionProductStockId] = @AlertDefinitionProductStockId AND [AlertTypeId] = @AlertTypeId ORDER BY [AlertAt] DESC 2026-01-15 05:35:36.8678 AlertProcessor System.Threading.ThreadAbortException: Thread was being aborted. at CoolR.Tasks.ProcessAlertData.Execute() in C:\CoolR-Group\portal\CoolR.Tasks\ProcessAlertData.cs:line 402 System.Threading.ThreadAbortException: Thread was being aborted. at CoolR.Tasks.ProcessAlertData.Execute() in C:\CoolR-Group\portal\CoolR.Tasks\ProcessAlertData.cs:line 402 2026-01-15 05:35:36.9772 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 415 at DFramework.Scheduler.TaskBase.Run() in E:\Forked\Framework\DFramework.Scheduler\TaskBase.cs:line 176 2026-01-15 05:35:37.0397 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 415 at DFramework.Scheduler.TaskBase.Run() in E:\Forked\Framework\DFramework.Scheduler\TaskBase.cs:line 176 2026-01-15 06:29:27.4041 DFramework.Scheduler.TaskBase Error in task: Email AlertNotification Microsoft.Data.SqlClient.SqlException (0x80131904): Invalid column name 'IsDeleted'. at Microsoft.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at Microsoft.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, SqlCommand command, Boolean callerHasConnectionLock, Boolean asyncClose) 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.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.SendAlertNotification.Execute() in C:\CoolR-Group\portal\CoolR.Tasks\SendAlertNotification.cs:line 317 at DFramework.Scheduler.TaskBase.Run() in E:\Forked\Framework\DFramework.Scheduler\TaskBase.cs:line 176 ClientConnectionId:b76ab45c-c47b-40de-afcc-769fd759d2d6 Error Number:207,State:1,Class:16 HelpLink.ProdName: Microsoft SQL Server;HelpLink.ProdVer: 17.00.0925;HelpLink.EvtSrc: MSSQLServer;HelpLink.EvtID: 207;HelpLink.BaseHelpUrl: https://go.microsoft.com/fwlink;HelpLink.LinkId: 20476;Query: DECLARE @AssetPurityId0 Int32 = 3676205, @AssetPurityId1 Int32 = 3676205, @IsDeleted Boolean = False Select UniqueGuid, AssetPurityId from AssetPurity WHERE AssetPurity.AssetPurityId IN ( @AssetPurityId0, @AssetPurityId1 ) AND IsDeleted = @IsDeleted 2026-01-15 06:29:27.4352 TaskExecution Task Execution Error: Email AlertNotification Microsoft.Data.SqlClient.SqlException (0x80131904): Invalid column name 'IsDeleted'. at Microsoft.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at Microsoft.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, SqlCommand command, Boolean callerHasConnectionLock, Boolean asyncClose) 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.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.SendAlertNotification.Execute() in C:\CoolR-Group\portal\CoolR.Tasks\SendAlertNotification.cs:line 317 at DFramework.Scheduler.TaskBase.Run() in E:\Forked\Framework\DFramework.Scheduler\TaskBase.cs:line 176 ClientConnectionId:b76ab45c-c47b-40de-afcc-769fd759d2d6 Error Number:207,State:1,Class:16 HelpLink.ProdName: Microsoft SQL Server;HelpLink.ProdVer: 17.00.0925;HelpLink.EvtSrc: MSSQLServer;HelpLink.EvtID: 207;HelpLink.BaseHelpUrl: https://go.microsoft.com/fwlink;HelpLink.LinkId: 20476;Query: DECLARE @AssetPurityId0 Int32 = 3676205, @AssetPurityId1 Int32 = 3676205, @IsDeleted Boolean = False Select UniqueGuid, AssetPurityId from AssetPurity WHERE AssetPurity.AssetPurityId IN ( @AssetPurityId0, @AssetPurityId1 ) AND IsDeleted = @IsDeleted 2026-01-15 06:34:27.4528 DFramework.Scheduler.TaskBase Error in task: Email AlertNotification Microsoft.Data.SqlClient.SqlException (0x80131904): Invalid column name 'IsDeleted'. at Microsoft.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at Microsoft.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, SqlCommand command, Boolean callerHasConnectionLock, Boolean asyncClose) 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.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.SendAlertNotification.Execute() in C:\CoolR-Group\portal\CoolR.Tasks\SendAlertNotification.cs:line 317 at DFramework.Scheduler.TaskBase.Run() in E:\Forked\Framework\DFramework.Scheduler\TaskBase.cs:line 176 ClientConnectionId:d306c082-e932-4b51-a3f8-3a73ef11d888 Error Number:207,State:1,Class:16 HelpLink.ProdName: Microsoft SQL Server;HelpLink.ProdVer: 17.00.0925;HelpLink.EvtSrc: MSSQLServer;HelpLink.EvtID: 207;HelpLink.BaseHelpUrl: https://go.microsoft.com/fwlink;HelpLink.LinkId: 20476;Query: DECLARE @AssetPurityId0 Int32 = 3676205, @AssetPurityId1 Int32 = 3676205, @IsDeleted Boolean = False Select UniqueGuid, AssetPurityId from AssetPurity WHERE AssetPurity.AssetPurityId IN ( @AssetPurityId0, @AssetPurityId1 ) AND IsDeleted = @IsDeleted 2026-01-15 06:34:27.4684 TaskExecution Task Execution Error: Email AlertNotification Microsoft.Data.SqlClient.SqlException (0x80131904): Invalid column name 'IsDeleted'. at Microsoft.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at Microsoft.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, SqlCommand command, Boolean callerHasConnectionLock, Boolean asyncClose) 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.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.SendAlertNotification.Execute() in C:\CoolR-Group\portal\CoolR.Tasks\SendAlertNotification.cs:line 317 at DFramework.Scheduler.TaskBase.Run() in E:\Forked\Framework\DFramework.Scheduler\TaskBase.cs:line 176 ClientConnectionId:d306c082-e932-4b51-a3f8-3a73ef11d888 Error Number:207,State:1,Class:16 HelpLink.ProdName: Microsoft SQL Server;HelpLink.ProdVer: 17.00.0925;HelpLink.EvtSrc: MSSQLServer;HelpLink.EvtID: 207;HelpLink.BaseHelpUrl: https://go.microsoft.com/fwlink;HelpLink.LinkId: 20476;Query: DECLARE @AssetPurityId0 Int32 = 3676205, @AssetPurityId1 Int32 = 3676205, @IsDeleted Boolean = False Select UniqueGuid, AssetPurityId from AssetPurity WHERE AssetPurity.AssetPurityId IN ( @AssetPurityId0, @AssetPurityId1 ) AND IsDeleted = @IsDeleted 2026-01-15 06:39:27.7046 DFramework.Scheduler.TaskBase Error in task: Email AlertNotification Microsoft.Data.SqlClient.SqlException (0x80131904): Invalid column name 'IsDeleted'. at Microsoft.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at Microsoft.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, SqlCommand command, Boolean callerHasConnectionLock, Boolean asyncClose) 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.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.SendAlertNotification.Execute() in C:\CoolR-Group\portal\CoolR.Tasks\SendAlertNotification.cs:line 317 at DFramework.Scheduler.TaskBase.Run() in E:\Forked\Framework\DFramework.Scheduler\TaskBase.cs:line 176 ClientConnectionId:f655b390-a70b-45af-8f95-9aadf10cb136 Error Number:207,State:1,Class:16 HelpLink.ProdName: Microsoft SQL Server;HelpLink.ProdVer: 17.00.0925;HelpLink.EvtSrc: MSSQLServer;HelpLink.EvtID: 207;HelpLink.BaseHelpUrl: https://go.microsoft.com/fwlink;HelpLink.LinkId: 20476;Query: DECLARE @AssetPurityId0 Int32 = 3676205, @AssetPurityId1 Int32 = 3676205, @IsDeleted Boolean = False Select UniqueGuid, AssetPurityId from AssetPurity WHERE AssetPurity.AssetPurityId IN ( @AssetPurityId0, @AssetPurityId1 ) AND IsDeleted = @IsDeleted 2026-01-15 06:39:27.7358 TaskExecution Task Execution Error: Email AlertNotification Microsoft.Data.SqlClient.SqlException (0x80131904): Invalid column name 'IsDeleted'. at Microsoft.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at Microsoft.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, SqlCommand command, Boolean callerHasConnectionLock, Boolean asyncClose) 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.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.SendAlertNotification.Execute() in C:\CoolR-Group\portal\CoolR.Tasks\SendAlertNotification.cs:line 317 at DFramework.Scheduler.TaskBase.Run() in E:\Forked\Framework\DFramework.Scheduler\TaskBase.cs:line 176 ClientConnectionId:f655b390-a70b-45af-8f95-9aadf10cb136 Error Number:207,State:1,Class:16 HelpLink.ProdName: Microsoft SQL Server;HelpLink.ProdVer: 17.00.0925;HelpLink.EvtSrc: MSSQLServer;HelpLink.EvtID: 207;HelpLink.BaseHelpUrl: https://go.microsoft.com/fwlink;HelpLink.LinkId: 20476;Query: DECLARE @AssetPurityId0 Int32 = 3676205, @AssetPurityId1 Int32 = 3676205, @IsDeleted Boolean = False Select UniqueGuid, AssetPurityId from AssetPurity WHERE AssetPurity.AssetPurityId IN ( @AssetPurityId0, @AssetPurityId1 ) AND IsDeleted = @IsDeleted 2026-01-15 06:44:27.5190 DFramework.Scheduler.TaskBase Error in task: Email AlertNotification Microsoft.Data.SqlClient.SqlException (0x80131904): Invalid column name 'IsDeleted'. at Microsoft.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at Microsoft.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, SqlCommand command, Boolean callerHasConnectionLock, Boolean asyncClose) 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.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.SendAlertNotification.Execute() in C:\CoolR-Group\portal\CoolR.Tasks\SendAlertNotification.cs:line 317 at DFramework.Scheduler.TaskBase.Run() in E:\Forked\Framework\DFramework.Scheduler\TaskBase.cs:line 176 ClientConnectionId:ad384371-73e5-4227-9b55-85fb92e0a3a4 Error Number:207,State:1,Class:16 HelpLink.ProdName: Microsoft SQL Server;HelpLink.ProdVer: 17.00.0925;HelpLink.EvtSrc: MSSQLServer;HelpLink.EvtID: 207;HelpLink.BaseHelpUrl: https://go.microsoft.com/fwlink;HelpLink.LinkId: 20476;Query: DECLARE @AssetPurityId0 Int32 = 3676205, @AssetPurityId1 Int32 = 3676205, @IsDeleted Boolean = False Select UniqueGuid, AssetPurityId from AssetPurity WHERE AssetPurity.AssetPurityId IN ( @AssetPurityId0, @AssetPurityId1 ) AND IsDeleted = @IsDeleted 2026-01-15 06:44:27.5502 TaskExecution Task Execution Error: Email AlertNotification Microsoft.Data.SqlClient.SqlException (0x80131904): Invalid column name 'IsDeleted'. at Microsoft.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at Microsoft.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, SqlCommand command, Boolean callerHasConnectionLock, Boolean asyncClose) 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.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.SendAlertNotification.Execute() in C:\CoolR-Group\portal\CoolR.Tasks\SendAlertNotification.cs:line 317 at DFramework.Scheduler.TaskBase.Run() in E:\Forked\Framework\DFramework.Scheduler\TaskBase.cs:line 176 ClientConnectionId:ad384371-73e5-4227-9b55-85fb92e0a3a4 Error Number:207,State:1,Class:16 HelpLink.ProdName: Microsoft SQL Server;HelpLink.ProdVer: 17.00.0925;HelpLink.EvtSrc: MSSQLServer;HelpLink.EvtID: 207;HelpLink.BaseHelpUrl: https://go.microsoft.com/fwlink;HelpLink.LinkId: 20476;Query: DECLARE @AssetPurityId0 Int32 = 3676205, @AssetPurityId1 Int32 = 3676205, @IsDeleted Boolean = False Select UniqueGuid, AssetPurityId from AssetPurity WHERE AssetPurity.AssetPurityId IN ( @AssetPurityId0, @AssetPurityId1 ) AND IsDeleted = @IsDeleted 2026-01-15 06:49:27.4584 DFramework.Scheduler.TaskBase Error in task: Email AlertNotification Microsoft.Data.SqlClient.SqlException (0x80131904): Invalid column name 'IsDeleted'. at Microsoft.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at Microsoft.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, SqlCommand command, Boolean callerHasConnectionLock, Boolean asyncClose) 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.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.SendAlertNotification.Execute() in C:\CoolR-Group\portal\CoolR.Tasks\SendAlertNotification.cs:line 317 at DFramework.Scheduler.TaskBase.Run() in E:\Forked\Framework\DFramework.Scheduler\TaskBase.cs:line 176 ClientConnectionId:ad384371-73e5-4227-9b55-85fb92e0a3a4 Error Number:207,State:1,Class:16 HelpLink.ProdName: Microsoft SQL Server;HelpLink.ProdVer: 17.00.0925;HelpLink.EvtSrc: MSSQLServer;HelpLink.EvtID: 207;HelpLink.BaseHelpUrl: https://go.microsoft.com/fwlink;HelpLink.LinkId: 20476;Query: DECLARE @AssetPurityId0 Int32 = 3676205, @AssetPurityId1 Int32 = 3676205, @IsDeleted Boolean = False Select UniqueGuid, AssetPurityId from AssetPurity WHERE AssetPurity.AssetPurityId IN ( @AssetPurityId0, @AssetPurityId1 ) AND IsDeleted = @IsDeleted 2026-01-15 06:49:27.4740 TaskExecution Task Execution Error: Email AlertNotification Microsoft.Data.SqlClient.SqlException (0x80131904): Invalid column name 'IsDeleted'. at Microsoft.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at Microsoft.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, SqlCommand command, Boolean callerHasConnectionLock, Boolean asyncClose) 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.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.SendAlertNotification.Execute() in C:\CoolR-Group\portal\CoolR.Tasks\SendAlertNotification.cs:line 317 at DFramework.Scheduler.TaskBase.Run() in E:\Forked\Framework\DFramework.Scheduler\TaskBase.cs:line 176 ClientConnectionId:ad384371-73e5-4227-9b55-85fb92e0a3a4 Error Number:207,State:1,Class:16 HelpLink.ProdName: Microsoft SQL Server;HelpLink.ProdVer: 17.00.0925;HelpLink.EvtSrc: MSSQLServer;HelpLink.EvtID: 207;HelpLink.BaseHelpUrl: https://go.microsoft.com/fwlink;HelpLink.LinkId: 20476;Query: DECLARE @AssetPurityId0 Int32 = 3676205, @AssetPurityId1 Int32 = 3676205, @IsDeleted Boolean = False Select UniqueGuid, AssetPurityId from AssetPurity WHERE AssetPurity.AssetPurityId IN ( @AssetPurityId0, @AssetPurityId1 ) AND IsDeleted = @IsDeleted 2026-01-15 06:54:28.0227 DFramework.Scheduler.TaskBase Error in task: Email AlertNotification Microsoft.Data.SqlClient.SqlException (0x80131904): Invalid column name 'IsDeleted'. at Microsoft.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at Microsoft.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, SqlCommand command, Boolean callerHasConnectionLock, Boolean asyncClose) 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.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.SendAlertNotification.Execute() in C:\CoolR-Group\portal\CoolR.Tasks\SendAlertNotification.cs:line 317 at DFramework.Scheduler.TaskBase.Run() in E:\Forked\Framework\DFramework.Scheduler\TaskBase.cs:line 176 ClientConnectionId:6f2520ba-2c8c-4b9b-8d96-fd757132b67f Error Number:207,State:1,Class:16 HelpLink.ProdName: Microsoft SQL Server;HelpLink.ProdVer: 17.00.0925;HelpLink.EvtSrc: MSSQLServer;HelpLink.EvtID: 207;HelpLink.BaseHelpUrl: https://go.microsoft.com/fwlink;HelpLink.LinkId: 20476;Query: DECLARE @AssetPurityId0 Int32 = 3676205, @AssetPurityId1 Int32 = 3676205, @IsDeleted Boolean = False Select UniqueGuid, AssetPurityId from AssetPurity WHERE AssetPurity.AssetPurityId IN ( @AssetPurityId0, @AssetPurityId1 ) AND IsDeleted = @IsDeleted 2026-01-15 06:54:28.0539 TaskExecution Task Execution Error: Email AlertNotification Microsoft.Data.SqlClient.SqlException (0x80131904): Invalid column name 'IsDeleted'. at Microsoft.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at Microsoft.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, SqlCommand command, Boolean callerHasConnectionLock, Boolean asyncClose) 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.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.SendAlertNotification.Execute() in C:\CoolR-Group\portal\CoolR.Tasks\SendAlertNotification.cs:line 317 at DFramework.Scheduler.TaskBase.Run() in E:\Forked\Framework\DFramework.Scheduler\TaskBase.cs:line 176 ClientConnectionId:6f2520ba-2c8c-4b9b-8d96-fd757132b67f Error Number:207,State:1,Class:16 HelpLink.ProdName: Microsoft SQL Server;HelpLink.ProdVer: 17.00.0925;HelpLink.EvtSrc: MSSQLServer;HelpLink.EvtID: 207;HelpLink.BaseHelpUrl: https://go.microsoft.com/fwlink;HelpLink.LinkId: 20476;Query: DECLARE @AssetPurityId0 Int32 = 3676205, @AssetPurityId1 Int32 = 3676205, @IsDeleted Boolean = False Select UniqueGuid, AssetPurityId from AssetPurity WHERE AssetPurity.AssetPurityId IN ( @AssetPurityId0, @AssetPurityId1 ) AND IsDeleted = @IsDeleted 2026-01-15 06:59:27.7120 DFramework.Scheduler.TaskBase Error in task: Email AlertNotification Microsoft.Data.SqlClient.SqlException (0x80131904): Invalid column name 'IsDeleted'. at Microsoft.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at Microsoft.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, SqlCommand command, Boolean callerHasConnectionLock, Boolean asyncClose) 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.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.SendAlertNotification.Execute() in C:\CoolR-Group\portal\CoolR.Tasks\SendAlertNotification.cs:line 317 at DFramework.Scheduler.TaskBase.Run() in E:\Forked\Framework\DFramework.Scheduler\TaskBase.cs:line 176 ClientConnectionId:302f3a17-fd00-4150-8784-aab599337c21 Error Number:207,State:1,Class:16 HelpLink.ProdName: Microsoft SQL Server;HelpLink.ProdVer: 17.00.0925;HelpLink.EvtSrc: MSSQLServer;HelpLink.EvtID: 207;HelpLink.BaseHelpUrl: https://go.microsoft.com/fwlink;HelpLink.LinkId: 20476;Query: DECLARE @AssetPurityId0 Int32 = 3676205, @AssetPurityId1 Int32 = 3676205, @IsDeleted Boolean = False Select UniqueGuid, AssetPurityId from AssetPurity WHERE AssetPurity.AssetPurityId IN ( @AssetPurityId0, @AssetPurityId1 ) AND IsDeleted = @IsDeleted 2026-01-15 06:59:27.7432 TaskExecution Task Execution Error: Email AlertNotification Microsoft.Data.SqlClient.SqlException (0x80131904): Invalid column name 'IsDeleted'. at Microsoft.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at Microsoft.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, SqlCommand command, Boolean callerHasConnectionLock, Boolean asyncClose) 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.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.SendAlertNotification.Execute() in C:\CoolR-Group\portal\CoolR.Tasks\SendAlertNotification.cs:line 317 at DFramework.Scheduler.TaskBase.Run() in E:\Forked\Framework\DFramework.Scheduler\TaskBase.cs:line 176 ClientConnectionId:302f3a17-fd00-4150-8784-aab599337c21 Error Number:207,State:1,Class:16 HelpLink.ProdName: Microsoft SQL Server;HelpLink.ProdVer: 17.00.0925;HelpLink.EvtSrc: MSSQLServer;HelpLink.EvtID: 207;HelpLink.BaseHelpUrl: https://go.microsoft.com/fwlink;HelpLink.LinkId: 20476;Query: DECLARE @AssetPurityId0 Int32 = 3676205, @AssetPurityId1 Int32 = 3676205, @IsDeleted Boolean = False Select UniqueGuid, AssetPurityId from AssetPurity WHERE AssetPurity.AssetPurityId IN ( @AssetPurityId0, @AssetPurityId1 ) AND IsDeleted = @IsDeleted 2026-01-15 07:04:27.4953 DFramework.Scheduler.TaskBase Error in task: Email AlertNotification Microsoft.Data.SqlClient.SqlException (0x80131904): Invalid column name 'IsDeleted'. at Microsoft.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at Microsoft.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, SqlCommand command, Boolean callerHasConnectionLock, Boolean asyncClose) 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.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.SendAlertNotification.Execute() in C:\CoolR-Group\portal\CoolR.Tasks\SendAlertNotification.cs:line 317 at DFramework.Scheduler.TaskBase.Run() in E:\Forked\Framework\DFramework.Scheduler\TaskBase.cs:line 176 ClientConnectionId:f6f52255-812c-4a4b-865a-36b6a08ceb20 Error Number:207,State:1,Class:16 HelpLink.ProdName: Microsoft SQL Server;HelpLink.ProdVer: 17.00.0925;HelpLink.EvtSrc: MSSQLServer;HelpLink.EvtID: 207;HelpLink.BaseHelpUrl: https://go.microsoft.com/fwlink;HelpLink.LinkId: 20476;Query: DECLARE @AssetPurityId0 Int32 = 3676205, @AssetPurityId1 Int32 = 3676205, @IsDeleted Boolean = False Select UniqueGuid, AssetPurityId from AssetPurity WHERE AssetPurity.AssetPurityId IN ( @AssetPurityId0, @AssetPurityId1 ) AND IsDeleted = @IsDeleted 2026-01-15 07:04:27.5266 TaskExecution Task Execution Error: Email AlertNotification Microsoft.Data.SqlClient.SqlException (0x80131904): Invalid column name 'IsDeleted'. at Microsoft.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at Microsoft.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, SqlCommand command, Boolean callerHasConnectionLock, Boolean asyncClose) 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.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.SendAlertNotification.Execute() in C:\CoolR-Group\portal\CoolR.Tasks\SendAlertNotification.cs:line 317 at DFramework.Scheduler.TaskBase.Run() in E:\Forked\Framework\DFramework.Scheduler\TaskBase.cs:line 176 ClientConnectionId:f6f52255-812c-4a4b-865a-36b6a08ceb20 Error Number:207,State:1,Class:16 HelpLink.ProdName: Microsoft SQL Server;HelpLink.ProdVer: 17.00.0925;HelpLink.EvtSrc: MSSQLServer;HelpLink.EvtID: 207;HelpLink.BaseHelpUrl: https://go.microsoft.com/fwlink;HelpLink.LinkId: 20476;Query: DECLARE @AssetPurityId0 Int32 = 3676205, @AssetPurityId1 Int32 = 3676205, @IsDeleted Boolean = False Select UniqueGuid, AssetPurityId from AssetPurity WHERE AssetPurity.AssetPurityId IN ( @AssetPurityId0, @AssetPurityId1 ) AND IsDeleted = @IsDeleted 2026-01-15 07:09:27.7941 DFramework.Scheduler.TaskBase Error in task: Email AlertNotification Microsoft.Data.SqlClient.SqlException (0x80131904): Invalid column name 'IsDeleted'. at Microsoft.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at Microsoft.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, SqlCommand command, Boolean callerHasConnectionLock, Boolean asyncClose) 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.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.SendAlertNotification.Execute() in C:\CoolR-Group\portal\CoolR.Tasks\SendAlertNotification.cs:line 317 at DFramework.Scheduler.TaskBase.Run() in E:\Forked\Framework\DFramework.Scheduler\TaskBase.cs:line 176 ClientConnectionId:3af9e753-f285-4cf2-8d00-84d748cff9bf Error Number:207,State:1,Class:16 HelpLink.ProdName: Microsoft SQL Server;HelpLink.ProdVer: 17.00.0925;HelpLink.EvtSrc: MSSQLServer;HelpLink.EvtID: 207;HelpLink.BaseHelpUrl: https://go.microsoft.com/fwlink;HelpLink.LinkId: 20476;Query: DECLARE @AssetPurityId0 Int32 = 3676205, @AssetPurityId1 Int32 = 3676205, @IsDeleted Boolean = False Select UniqueGuid, AssetPurityId from AssetPurity WHERE AssetPurity.AssetPurityId IN ( @AssetPurityId0, @AssetPurityId1 ) AND IsDeleted = @IsDeleted 2026-01-15 07:09:27.8097 TaskExecution Task Execution Error: Email AlertNotification Microsoft.Data.SqlClient.SqlException (0x80131904): Invalid column name 'IsDeleted'. at Microsoft.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at Microsoft.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, SqlCommand command, Boolean callerHasConnectionLock, Boolean asyncClose) 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.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.SendAlertNotification.Execute() in C:\CoolR-Group\portal\CoolR.Tasks\SendAlertNotification.cs:line 317 at DFramework.Scheduler.TaskBase.Run() in E:\Forked\Framework\DFramework.Scheduler\TaskBase.cs:line 176 ClientConnectionId:3af9e753-f285-4cf2-8d00-84d748cff9bf Error Number:207,State:1,Class:16 HelpLink.ProdName: Microsoft SQL Server;HelpLink.ProdVer: 17.00.0925;HelpLink.EvtSrc: MSSQLServer;HelpLink.EvtID: 207;HelpLink.BaseHelpUrl: https://go.microsoft.com/fwlink;HelpLink.LinkId: 20476;Query: DECLARE @AssetPurityId0 Int32 = 3676205, @AssetPurityId1 Int32 = 3676205, @IsDeleted Boolean = False Select UniqueGuid, AssetPurityId from AssetPurity WHERE AssetPurity.AssetPurityId IN ( @AssetPurityId0, @AssetPurityId1 ) AND IsDeleted = @IsDeleted 2026-01-15 07:14:27.5146 DFramework.Scheduler.TaskBase Error in task: Email AlertNotification Microsoft.Data.SqlClient.SqlException (0x80131904): Invalid column name 'IsDeleted'. at Microsoft.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at Microsoft.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, SqlCommand command, Boolean callerHasConnectionLock, Boolean asyncClose) 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.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.SendAlertNotification.Execute() in C:\CoolR-Group\portal\CoolR.Tasks\SendAlertNotification.cs:line 317 at DFramework.Scheduler.TaskBase.Run() in E:\Forked\Framework\DFramework.Scheduler\TaskBase.cs:line 176 ClientConnectionId:8afe50e1-0871-4b4c-9e74-431be6ed1e02 Error Number:207,State:1,Class:16 HelpLink.ProdName: Microsoft SQL Server;HelpLink.ProdVer: 17.00.0925;HelpLink.EvtSrc: MSSQLServer;HelpLink.EvtID: 207;HelpLink.BaseHelpUrl: https://go.microsoft.com/fwlink;HelpLink.LinkId: 20476;Query: DECLARE @AssetPurityId0 Int32 = 3676205, @AssetPurityId1 Int32 = 3676205, @IsDeleted Boolean = False Select UniqueGuid, AssetPurityId from AssetPurity WHERE AssetPurity.AssetPurityId IN ( @AssetPurityId0, @AssetPurityId1 ) AND IsDeleted = @IsDeleted 2026-01-15 07:14:27.5459 TaskExecution Task Execution Error: Email AlertNotification Microsoft.Data.SqlClient.SqlException (0x80131904): Invalid column name 'IsDeleted'. at Microsoft.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at Microsoft.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, SqlCommand command, Boolean callerHasConnectionLock, Boolean asyncClose) 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.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.SendAlertNotification.Execute() in C:\CoolR-Group\portal\CoolR.Tasks\SendAlertNotification.cs:line 317 at DFramework.Scheduler.TaskBase.Run() in E:\Forked\Framework\DFramework.Scheduler\TaskBase.cs:line 176 ClientConnectionId:8afe50e1-0871-4b4c-9e74-431be6ed1e02 Error Number:207,State:1,Class:16 HelpLink.ProdName: Microsoft SQL Server;HelpLink.ProdVer: 17.00.0925;HelpLink.EvtSrc: MSSQLServer;HelpLink.EvtID: 207;HelpLink.BaseHelpUrl: https://go.microsoft.com/fwlink;HelpLink.LinkId: 20476;Query: DECLARE @AssetPurityId0 Int32 = 3676205, @AssetPurityId1 Int32 = 3676205, @IsDeleted Boolean = False Select UniqueGuid, AssetPurityId from AssetPurity WHERE AssetPurity.AssetPurityId IN ( @AssetPurityId0, @AssetPurityId1 ) AND IsDeleted = @IsDeleted 2026-01-15 07:19:27.7354 DFramework.Scheduler.TaskBase Error in task: Email AlertNotification Microsoft.Data.SqlClient.SqlException (0x80131904): Invalid column name 'IsDeleted'. at Microsoft.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at Microsoft.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, SqlCommand command, Boolean callerHasConnectionLock, Boolean asyncClose) 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.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.SendAlertNotification.Execute() in C:\CoolR-Group\portal\CoolR.Tasks\SendAlertNotification.cs:line 317 at DFramework.Scheduler.TaskBase.Run() in E:\Forked\Framework\DFramework.Scheduler\TaskBase.cs:line 176 ClientConnectionId:0b6d7c5a-0765-4856-8c46-4514b64d705d Error Number:207,State:1,Class:16 HelpLink.ProdName: Microsoft SQL Server;HelpLink.ProdVer: 17.00.0925;HelpLink.EvtSrc: MSSQLServer;HelpLink.EvtID: 207;HelpLink.BaseHelpUrl: https://go.microsoft.com/fwlink;HelpLink.LinkId: 20476;Query: DECLARE @AssetPurityId0 Int32 = 3676205, @AssetPurityId1 Int32 = 3676205, @IsDeleted Boolean = False Select UniqueGuid, AssetPurityId from AssetPurity WHERE AssetPurity.AssetPurityId IN ( @AssetPurityId0, @AssetPurityId1 ) AND IsDeleted = @IsDeleted 2026-01-15 07:19:27.7510 TaskExecution Task Execution Error: Email AlertNotification Microsoft.Data.SqlClient.SqlException (0x80131904): Invalid column name 'IsDeleted'. at Microsoft.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at Microsoft.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, SqlCommand command, Boolean callerHasConnectionLock, Boolean asyncClose) 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.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.SendAlertNotification.Execute() in C:\CoolR-Group\portal\CoolR.Tasks\SendAlertNotification.cs:line 317 at DFramework.Scheduler.TaskBase.Run() in E:\Forked\Framework\DFramework.Scheduler\TaskBase.cs:line 176 ClientConnectionId:0b6d7c5a-0765-4856-8c46-4514b64d705d Error Number:207,State:1,Class:16 HelpLink.ProdName: Microsoft SQL Server;HelpLink.ProdVer: 17.00.0925;HelpLink.EvtSrc: MSSQLServer;HelpLink.EvtID: 207;HelpLink.BaseHelpUrl: https://go.microsoft.com/fwlink;HelpLink.LinkId: 20476;Query: DECLARE @AssetPurityId0 Int32 = 3676205, @AssetPurityId1 Int32 = 3676205, @IsDeleted Boolean = False Select UniqueGuid, AssetPurityId from AssetPurity WHERE AssetPurity.AssetPurityId IN ( @AssetPurityId0, @AssetPurityId1 ) AND IsDeleted = @IsDeleted 2026-01-15 07:24:27.6591 DFramework.Scheduler.TaskBase Error in task: Email AlertNotification Microsoft.Data.SqlClient.SqlException (0x80131904): Invalid column name 'IsDeleted'. at Microsoft.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at Microsoft.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, SqlCommand command, Boolean callerHasConnectionLock, Boolean asyncClose) 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.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.SendAlertNotification.Execute() in C:\CoolR-Group\portal\CoolR.Tasks\SendAlertNotification.cs:line 317 at DFramework.Scheduler.TaskBase.Run() in E:\Forked\Framework\DFramework.Scheduler\TaskBase.cs:line 176 ClientConnectionId:eb94cfea-26ff-47cd-a2f1-8bb0c95e91e3 Error Number:207,State:1,Class:16 HelpLink.ProdName: Microsoft SQL Server;HelpLink.ProdVer: 17.00.0925;HelpLink.EvtSrc: MSSQLServer;HelpLink.EvtID: 207;HelpLink.BaseHelpUrl: https://go.microsoft.com/fwlink;HelpLink.LinkId: 20476;Query: DECLARE @AssetPurityId0 Int32 = 3676205, @AssetPurityId1 Int32 = 3676205, @IsDeleted Boolean = False Select UniqueGuid, AssetPurityId from AssetPurity WHERE AssetPurity.AssetPurityId IN ( @AssetPurityId0, @AssetPurityId1 ) AND IsDeleted = @IsDeleted 2026-01-15 07:24:27.6748 TaskExecution Task Execution Error: Email AlertNotification Microsoft.Data.SqlClient.SqlException (0x80131904): Invalid column name 'IsDeleted'. at Microsoft.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at Microsoft.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, SqlCommand command, Boolean callerHasConnectionLock, Boolean asyncClose) 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.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.SendAlertNotification.Execute() in C:\CoolR-Group\portal\CoolR.Tasks\SendAlertNotification.cs:line 317 at DFramework.Scheduler.TaskBase.Run() in E:\Forked\Framework\DFramework.Scheduler\TaskBase.cs:line 176 ClientConnectionId:eb94cfea-26ff-47cd-a2f1-8bb0c95e91e3 Error Number:207,State:1,Class:16 HelpLink.ProdName: Microsoft SQL Server;HelpLink.ProdVer: 17.00.0925;HelpLink.EvtSrc: MSSQLServer;HelpLink.EvtID: 207;HelpLink.BaseHelpUrl: https://go.microsoft.com/fwlink;HelpLink.LinkId: 20476;Query: DECLARE @AssetPurityId0 Int32 = 3676205, @AssetPurityId1 Int32 = 3676205, @IsDeleted Boolean = False Select UniqueGuid, AssetPurityId from AssetPurity WHERE AssetPurity.AssetPurityId IN ( @AssetPurityId0, @AssetPurityId1 ) AND IsDeleted = @IsDeleted 2026-01-15 07:29:27.7391 DFramework.Scheduler.TaskBase Error in task: Email AlertNotification Microsoft.Data.SqlClient.SqlException (0x80131904): Invalid column name 'IsDeleted'. at Microsoft.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at Microsoft.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, SqlCommand command, Boolean callerHasConnectionLock, Boolean asyncClose) 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.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.SendAlertNotification.Execute() in C:\CoolR-Group\portal\CoolR.Tasks\SendAlertNotification.cs:line 317 at DFramework.Scheduler.TaskBase.Run() in E:\Forked\Framework\DFramework.Scheduler\TaskBase.cs:line 176 ClientConnectionId:b29455fa-4eb5-451e-bb43-faa8425d96c5 Error Number:207,State:1,Class:16 HelpLink.ProdName: Microsoft SQL Server;HelpLink.ProdVer: 17.00.0925;HelpLink.EvtSrc: MSSQLServer;HelpLink.EvtID: 207;HelpLink.BaseHelpUrl: https://go.microsoft.com/fwlink;HelpLink.LinkId: 20476;Query: DECLARE @AssetPurityId0 Int32 = 3676205, @AssetPurityId1 Int32 = 3676205, @IsDeleted Boolean = False Select UniqueGuid, AssetPurityId from AssetPurity WHERE AssetPurity.AssetPurityId IN ( @AssetPurityId0, @AssetPurityId1 ) AND IsDeleted = @IsDeleted 2026-01-15 07:29:27.7703 TaskExecution Task Execution Error: Email AlertNotification Microsoft.Data.SqlClient.SqlException (0x80131904): Invalid column name 'IsDeleted'. at Microsoft.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at Microsoft.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, SqlCommand command, Boolean callerHasConnectionLock, Boolean asyncClose) 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.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.SendAlertNotification.Execute() in C:\CoolR-Group\portal\CoolR.Tasks\SendAlertNotification.cs:line 317 at DFramework.Scheduler.TaskBase.Run() in E:\Forked\Framework\DFramework.Scheduler\TaskBase.cs:line 176 ClientConnectionId:b29455fa-4eb5-451e-bb43-faa8425d96c5 Error Number:207,State:1,Class:16 HelpLink.ProdName: Microsoft SQL Server;HelpLink.ProdVer: 17.00.0925;HelpLink.EvtSrc: MSSQLServer;HelpLink.EvtID: 207;HelpLink.BaseHelpUrl: https://go.microsoft.com/fwlink;HelpLink.LinkId: 20476;Query: DECLARE @AssetPurityId0 Int32 = 3676205, @AssetPurityId1 Int32 = 3676205, @IsDeleted Boolean = False Select UniqueGuid, AssetPurityId from AssetPurity WHERE AssetPurity.AssetPurityId IN ( @AssetPurityId0, @AssetPurityId1 ) AND IsDeleted = @IsDeleted 2026-01-15 07:34:27.6316 DFramework.Scheduler.TaskBase Error in task: Email AlertNotification Microsoft.Data.SqlClient.SqlException (0x80131904): Invalid column name 'IsDeleted'. at Microsoft.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at Microsoft.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, SqlCommand command, Boolean callerHasConnectionLock, Boolean asyncClose) 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.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.SendAlertNotification.Execute() in C:\CoolR-Group\portal\CoolR.Tasks\SendAlertNotification.cs:line 317 at DFramework.Scheduler.TaskBase.Run() in E:\Forked\Framework\DFramework.Scheduler\TaskBase.cs:line 176 ClientConnectionId:0008f16b-7e3e-4dca-8543-7edf3dde0695 Error Number:207,State:1,Class:16 HelpLink.ProdName: Microsoft SQL Server;HelpLink.ProdVer: 17.00.0925;HelpLink.EvtSrc: MSSQLServer;HelpLink.EvtID: 207;HelpLink.BaseHelpUrl: https://go.microsoft.com/fwlink;HelpLink.LinkId: 20476;Query: DECLARE @AssetPurityId0 Int32 = 3676205, @AssetPurityId1 Int32 = 3676205, @IsDeleted Boolean = False Select UniqueGuid, AssetPurityId from AssetPurity WHERE AssetPurity.AssetPurityId IN ( @AssetPurityId0, @AssetPurityId1 ) AND IsDeleted = @IsDeleted 2026-01-15 07:34:27.6472 TaskExecution Task Execution Error: Email AlertNotification Microsoft.Data.SqlClient.SqlException (0x80131904): Invalid column name 'IsDeleted'. at Microsoft.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at Microsoft.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, SqlCommand command, Boolean callerHasConnectionLock, Boolean asyncClose) 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.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.SendAlertNotification.Execute() in C:\CoolR-Group\portal\CoolR.Tasks\SendAlertNotification.cs:line 317 at DFramework.Scheduler.TaskBase.Run() in E:\Forked\Framework\DFramework.Scheduler\TaskBase.cs:line 176 ClientConnectionId:0008f16b-7e3e-4dca-8543-7edf3dde0695 Error Number:207,State:1,Class:16 HelpLink.ProdName: Microsoft SQL Server;HelpLink.ProdVer: 17.00.0925;HelpLink.EvtSrc: MSSQLServer;HelpLink.EvtID: 207;HelpLink.BaseHelpUrl: https://go.microsoft.com/fwlink;HelpLink.LinkId: 20476;Query: DECLARE @AssetPurityId0 Int32 = 3676205, @AssetPurityId1 Int32 = 3676205, @IsDeleted Boolean = False Select UniqueGuid, AssetPurityId from AssetPurity WHERE AssetPurity.AssetPurityId IN ( @AssetPurityId0, @AssetPurityId1 ) AND IsDeleted = @IsDeleted 2026-01-15 07:39:27.6179 DFramework.Scheduler.TaskBase Error in task: Email AlertNotification Microsoft.Data.SqlClient.SqlException (0x80131904): Invalid column name 'IsDeleted'. at Microsoft.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at Microsoft.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, SqlCommand command, Boolean callerHasConnectionLock, Boolean asyncClose) 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.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.SendAlertNotification.Execute() in C:\CoolR-Group\portal\CoolR.Tasks\SendAlertNotification.cs:line 317 at DFramework.Scheduler.TaskBase.Run() in E:\Forked\Framework\DFramework.Scheduler\TaskBase.cs:line 176 ClientConnectionId:6e3bbfd6-066c-471f-9fc2-b3ef6c1d93af Error Number:207,State:1,Class:16 HelpLink.ProdName: Microsoft SQL Server;HelpLink.ProdVer: 17.00.0925;HelpLink.EvtSrc: MSSQLServer;HelpLink.EvtID: 207;HelpLink.BaseHelpUrl: https://go.microsoft.com/fwlink;HelpLink.LinkId: 20476;Query: DECLARE @AssetPurityId0 Int32 = 3676205, @AssetPurityId1 Int32 = 3676205, @IsDeleted Boolean = False Select UniqueGuid, AssetPurityId from AssetPurity WHERE AssetPurity.AssetPurityId IN ( @AssetPurityId0, @AssetPurityId1 ) AND IsDeleted = @IsDeleted 2026-01-15 07:39:27.6492 TaskExecution Task Execution Error: Email AlertNotification Microsoft.Data.SqlClient.SqlException (0x80131904): Invalid column name 'IsDeleted'. at Microsoft.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at Microsoft.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, SqlCommand command, Boolean callerHasConnectionLock, Boolean asyncClose) 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.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.SendAlertNotification.Execute() in C:\CoolR-Group\portal\CoolR.Tasks\SendAlertNotification.cs:line 317 at DFramework.Scheduler.TaskBase.Run() in E:\Forked\Framework\DFramework.Scheduler\TaskBase.cs:line 176 ClientConnectionId:6e3bbfd6-066c-471f-9fc2-b3ef6c1d93af Error Number:207,State:1,Class:16 HelpLink.ProdName: Microsoft SQL Server;HelpLink.ProdVer: 17.00.0925;HelpLink.EvtSrc: MSSQLServer;HelpLink.EvtID: 207;HelpLink.BaseHelpUrl: https://go.microsoft.com/fwlink;HelpLink.LinkId: 20476;Query: DECLARE @AssetPurityId0 Int32 = 3676205, @AssetPurityId1 Int32 = 3676205, @IsDeleted Boolean = False Select UniqueGuid, AssetPurityId from AssetPurity WHERE AssetPurity.AssetPurityId IN ( @AssetPurityId0, @AssetPurityId1 ) AND IsDeleted = @IsDeleted 2026-01-15 07:44:27.6353 DFramework.Scheduler.TaskBase Error in task: Email AlertNotification Microsoft.Data.SqlClient.SqlException (0x80131904): Invalid column name 'IsDeleted'. at Microsoft.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at Microsoft.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, SqlCommand command, Boolean callerHasConnectionLock, Boolean asyncClose) 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.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.SendAlertNotification.Execute() in C:\CoolR-Group\portal\CoolR.Tasks\SendAlertNotification.cs:line 317 at DFramework.Scheduler.TaskBase.Run() in E:\Forked\Framework\DFramework.Scheduler\TaskBase.cs:line 176 ClientConnectionId:43aa2fc6-93d8-4d22-bd80-6891ff1686ef Error Number:207,State:1,Class:16 HelpLink.ProdName: Microsoft SQL Server;HelpLink.ProdVer: 17.00.0925;HelpLink.EvtSrc: MSSQLServer;HelpLink.EvtID: 207;HelpLink.BaseHelpUrl: https://go.microsoft.com/fwlink;HelpLink.LinkId: 20476;Query: DECLARE @AssetPurityId0 Int32 = 3676205, @AssetPurityId1 Int32 = 3676205, @IsDeleted Boolean = False Select UniqueGuid, AssetPurityId from AssetPurity WHERE AssetPurity.AssetPurityId IN ( @AssetPurityId0, @AssetPurityId1 ) AND IsDeleted = @IsDeleted 2026-01-15 07:44:27.6666 TaskExecution Task Execution Error: Email AlertNotification Microsoft.Data.SqlClient.SqlException (0x80131904): Invalid column name 'IsDeleted'. at Microsoft.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at Microsoft.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, SqlCommand command, Boolean callerHasConnectionLock, Boolean asyncClose) 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.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.SendAlertNotification.Execute() in C:\CoolR-Group\portal\CoolR.Tasks\SendAlertNotification.cs:line 317 at DFramework.Scheduler.TaskBase.Run() in E:\Forked\Framework\DFramework.Scheduler\TaskBase.cs:line 176 ClientConnectionId:43aa2fc6-93d8-4d22-bd80-6891ff1686ef Error Number:207,State:1,Class:16 HelpLink.ProdName: Microsoft SQL Server;HelpLink.ProdVer: 17.00.0925;HelpLink.EvtSrc: MSSQLServer;HelpLink.EvtID: 207;HelpLink.BaseHelpUrl: https://go.microsoft.com/fwlink;HelpLink.LinkId: 20476;Query: DECLARE @AssetPurityId0 Int32 = 3676205, @AssetPurityId1 Int32 = 3676205, @IsDeleted Boolean = False Select UniqueGuid, AssetPurityId from AssetPurity WHERE AssetPurity.AssetPurityId IN ( @AssetPurityId0, @AssetPurityId1 ) AND IsDeleted = @IsDeleted 2026-01-15 07:49:27.5746 DFramework.Scheduler.TaskBase Error in task: Email AlertNotification Microsoft.Data.SqlClient.SqlException (0x80131904): Invalid column name 'IsDeleted'. at Microsoft.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at Microsoft.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, SqlCommand command, Boolean callerHasConnectionLock, Boolean asyncClose) 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.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.SendAlertNotification.Execute() in C:\CoolR-Group\portal\CoolR.Tasks\SendAlertNotification.cs:line 317 at DFramework.Scheduler.TaskBase.Run() in E:\Forked\Framework\DFramework.Scheduler\TaskBase.cs:line 176 ClientConnectionId:b1bb878a-a006-4e25-bb60-12284224763a Error Number:207,State:1,Class:16 HelpLink.ProdName: Microsoft SQL Server;HelpLink.ProdVer: 17.00.0925;HelpLink.EvtSrc: MSSQLServer;HelpLink.EvtID: 207;HelpLink.BaseHelpUrl: https://go.microsoft.com/fwlink;HelpLink.LinkId: 20476;Query: DECLARE @AssetPurityId0 Int32 = 3676205, @AssetPurityId1 Int32 = 3676205, @IsDeleted Boolean = False Select UniqueGuid, AssetPurityId from AssetPurity WHERE AssetPurity.AssetPurityId IN ( @AssetPurityId0, @AssetPurityId1 ) AND IsDeleted = @IsDeleted 2026-01-15 07:49:27.6528 TaskExecution Task Execution Error: Email AlertNotification Microsoft.Data.SqlClient.SqlException (0x80131904): Invalid column name 'IsDeleted'. at Microsoft.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at Microsoft.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, SqlCommand command, Boolean callerHasConnectionLock, Boolean asyncClose) 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.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.SendAlertNotification.Execute() in C:\CoolR-Group\portal\CoolR.Tasks\SendAlertNotification.cs:line 317 at DFramework.Scheduler.TaskBase.Run() in E:\Forked\Framework\DFramework.Scheduler\TaskBase.cs:line 176 ClientConnectionId:b1bb878a-a006-4e25-bb60-12284224763a Error Number:207,State:1,Class:16 HelpLink.ProdName: Microsoft SQL Server;HelpLink.ProdVer: 17.00.0925;HelpLink.EvtSrc: MSSQLServer;HelpLink.EvtID: 207;HelpLink.BaseHelpUrl: https://go.microsoft.com/fwlink;HelpLink.LinkId: 20476;Query: DECLARE @AssetPurityId0 Int32 = 3676205, @AssetPurityId1 Int32 = 3676205, @IsDeleted Boolean = False Select UniqueGuid, AssetPurityId from AssetPurity WHERE AssetPurity.AssetPurityId IN ( @AssetPurityId0, @AssetPurityId1 ) AND IsDeleted = @IsDeleted 2026-01-15 07:54:27.9048 DFramework.Scheduler.TaskBase Error in task: Email AlertNotification Microsoft.Data.SqlClient.SqlException (0x80131904): Invalid column name 'IsDeleted'. at Microsoft.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at Microsoft.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, SqlCommand command, Boolean callerHasConnectionLock, Boolean asyncClose) 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.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.SendAlertNotification.Execute() in C:\CoolR-Group\portal\CoolR.Tasks\SendAlertNotification.cs:line 317 at DFramework.Scheduler.TaskBase.Run() in E:\Forked\Framework\DFramework.Scheduler\TaskBase.cs:line 176 ClientConnectionId:daf6e1df-8001-4ab2-963d-a50bee9f9465 Error Number:207,State:1,Class:16 HelpLink.ProdName: Microsoft SQL Server;HelpLink.ProdVer: 17.00.0925;HelpLink.EvtSrc: MSSQLServer;HelpLink.EvtID: 207;HelpLink.BaseHelpUrl: https://go.microsoft.com/fwlink;HelpLink.LinkId: 20476;Query: DECLARE @AssetPurityId0 Int32 = 3676205, @AssetPurityId1 Int32 = 3676205, @IsDeleted Boolean = False Select UniqueGuid, AssetPurityId from AssetPurity WHERE AssetPurity.AssetPurityId IN ( @AssetPurityId0, @AssetPurityId1 ) AND IsDeleted = @IsDeleted 2026-01-15 07:54:27.9360 TaskExecution Task Execution Error: Email AlertNotification Microsoft.Data.SqlClient.SqlException (0x80131904): Invalid column name 'IsDeleted'. at Microsoft.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at Microsoft.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, SqlCommand command, Boolean callerHasConnectionLock, Boolean asyncClose) 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.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.SendAlertNotification.Execute() in C:\CoolR-Group\portal\CoolR.Tasks\SendAlertNotification.cs:line 317 at DFramework.Scheduler.TaskBase.Run() in E:\Forked\Framework\DFramework.Scheduler\TaskBase.cs:line 176 ClientConnectionId:daf6e1df-8001-4ab2-963d-a50bee9f9465 Error Number:207,State:1,Class:16 HelpLink.ProdName: Microsoft SQL Server;HelpLink.ProdVer: 17.00.0925;HelpLink.EvtSrc: MSSQLServer;HelpLink.EvtID: 207;HelpLink.BaseHelpUrl: https://go.microsoft.com/fwlink;HelpLink.LinkId: 20476;Query: DECLARE @AssetPurityId0 Int32 = 3676205, @AssetPurityId1 Int32 = 3676205, @IsDeleted Boolean = False Select UniqueGuid, AssetPurityId from AssetPurity WHERE AssetPurity.AssetPurityId IN ( @AssetPurityId0, @AssetPurityId1 ) AND IsDeleted = @IsDeleted 2026-01-15 07:59:27.5785 DFramework.Scheduler.TaskBase Error in task: Email AlertNotification Microsoft.Data.SqlClient.SqlException (0x80131904): Invalid column name 'IsDeleted'. at Microsoft.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at Microsoft.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, SqlCommand command, Boolean callerHasConnectionLock, Boolean asyncClose) 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.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.SendAlertNotification.Execute() in C:\CoolR-Group\portal\CoolR.Tasks\SendAlertNotification.cs:line 317 at DFramework.Scheduler.TaskBase.Run() in E:\Forked\Framework\DFramework.Scheduler\TaskBase.cs:line 176 ClientConnectionId:daf6e1df-8001-4ab2-963d-a50bee9f9465 Error Number:207,State:1,Class:16 HelpLink.ProdName: Microsoft SQL Server;HelpLink.ProdVer: 17.00.0925;HelpLink.EvtSrc: MSSQLServer;HelpLink.EvtID: 207;HelpLink.BaseHelpUrl: https://go.microsoft.com/fwlink;HelpLink.LinkId: 20476;Query: DECLARE @AssetPurityId0 Int32 = 3676205, @AssetPurityId1 Int32 = 3676205, @IsDeleted Boolean = False Select UniqueGuid, AssetPurityId from AssetPurity WHERE AssetPurity.AssetPurityId IN ( @AssetPurityId0, @AssetPurityId1 ) AND IsDeleted = @IsDeleted 2026-01-15 07:59:27.5942 TaskExecution Task Execution Error: Email AlertNotification Microsoft.Data.SqlClient.SqlException (0x80131904): Invalid column name 'IsDeleted'. at Microsoft.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at Microsoft.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, SqlCommand command, Boolean callerHasConnectionLock, Boolean asyncClose) 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.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.SendAlertNotification.Execute() in C:\CoolR-Group\portal\CoolR.Tasks\SendAlertNotification.cs:line 317 at DFramework.Scheduler.TaskBase.Run() in E:\Forked\Framework\DFramework.Scheduler\TaskBase.cs:line 176 ClientConnectionId:daf6e1df-8001-4ab2-963d-a50bee9f9465 Error Number:207,State:1,Class:16 HelpLink.ProdName: Microsoft SQL Server;HelpLink.ProdVer: 17.00.0925;HelpLink.EvtSrc: MSSQLServer;HelpLink.EvtID: 207;HelpLink.BaseHelpUrl: https://go.microsoft.com/fwlink;HelpLink.LinkId: 20476;Query: DECLARE @AssetPurityId0 Int32 = 3676205, @AssetPurityId1 Int32 = 3676205, @IsDeleted Boolean = False Select UniqueGuid, AssetPurityId from AssetPurity WHERE AssetPurity.AssetPurityId IN ( @AssetPurityId0, @AssetPurityId1 ) AND IsDeleted = @IsDeleted 2026-01-15 08:04:27.6116 DFramework.Scheduler.TaskBase Error in task: Email AlertNotification Microsoft.Data.SqlClient.SqlException (0x80131904): Invalid column name 'IsDeleted'. at Microsoft.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at Microsoft.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, SqlCommand command, Boolean callerHasConnectionLock, Boolean asyncClose) 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.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.SendAlertNotification.Execute() in C:\CoolR-Group\portal\CoolR.Tasks\SendAlertNotification.cs:line 317 at DFramework.Scheduler.TaskBase.Run() in E:\Forked\Framework\DFramework.Scheduler\TaskBase.cs:line 176 ClientConnectionId:a61fd300-a263-452a-934a-c0fe6bd730fa Error Number:207,State:1,Class:16 HelpLink.ProdName: Microsoft SQL Server;HelpLink.ProdVer: 17.00.0925;HelpLink.EvtSrc: MSSQLServer;HelpLink.EvtID: 207;HelpLink.BaseHelpUrl: https://go.microsoft.com/fwlink;HelpLink.LinkId: 20476;Query: DECLARE @AssetPurityId0 Int32 = 3676205, @AssetPurityId1 Int32 = 3676205, @IsDeleted Boolean = False Select UniqueGuid, AssetPurityId from AssetPurity WHERE AssetPurity.AssetPurityId IN ( @AssetPurityId0, @AssetPurityId1 ) AND IsDeleted = @IsDeleted 2026-01-15 08:04:27.6428 TaskExecution Task Execution Error: Email AlertNotification Microsoft.Data.SqlClient.SqlException (0x80131904): Invalid column name 'IsDeleted'. at Microsoft.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at Microsoft.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, SqlCommand command, Boolean callerHasConnectionLock, Boolean asyncClose) 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.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.SendAlertNotification.Execute() in C:\CoolR-Group\portal\CoolR.Tasks\SendAlertNotification.cs:line 317 at DFramework.Scheduler.TaskBase.Run() in E:\Forked\Framework\DFramework.Scheduler\TaskBase.cs:line 176 ClientConnectionId:a61fd300-a263-452a-934a-c0fe6bd730fa Error Number:207,State:1,Class:16 HelpLink.ProdName: Microsoft SQL Server;HelpLink.ProdVer: 17.00.0925;HelpLink.EvtSrc: MSSQLServer;HelpLink.EvtID: 207;HelpLink.BaseHelpUrl: https://go.microsoft.com/fwlink;HelpLink.LinkId: 20476;Query: DECLARE @AssetPurityId0 Int32 = 3676205, @AssetPurityId1 Int32 = 3676205, @IsDeleted Boolean = False Select UniqueGuid, AssetPurityId from AssetPurity WHERE AssetPurity.AssetPurityId IN ( @AssetPurityId0, @AssetPurityId1 ) AND IsDeleted = @IsDeleted 2026-01-15 08:09:27.8948 DFramework.Scheduler.TaskBase Error in task: Email AlertNotification Microsoft.Data.SqlClient.SqlException (0x80131904): Invalid column name 'IsDeleted'. at Microsoft.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at Microsoft.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, SqlCommand command, Boolean callerHasConnectionLock, Boolean asyncClose) 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.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.SendAlertNotification.Execute() in C:\CoolR-Group\portal\CoolR.Tasks\SendAlertNotification.cs:line 317 at DFramework.Scheduler.TaskBase.Run() in E:\Forked\Framework\DFramework.Scheduler\TaskBase.cs:line 176 ClientConnectionId:4d4f6641-91c0-4bdb-803b-a00764f07574 Error Number:207,State:1,Class:16 HelpLink.ProdName: Microsoft SQL Server;HelpLink.ProdVer: 17.00.0925;HelpLink.EvtSrc: MSSQLServer;HelpLink.EvtID: 207;HelpLink.BaseHelpUrl: https://go.microsoft.com/fwlink;HelpLink.LinkId: 20476;Query: DECLARE @AssetPurityId0 Int32 = 3676205, @AssetPurityId1 Int32 = 3676205, @IsDeleted Boolean = False Select UniqueGuid, AssetPurityId from AssetPurity WHERE AssetPurity.AssetPurityId IN ( @AssetPurityId0, @AssetPurityId1 ) AND IsDeleted = @IsDeleted 2026-01-15 08:09:27.9104 TaskExecution Task Execution Error: Email AlertNotification Microsoft.Data.SqlClient.SqlException (0x80131904): Invalid column name 'IsDeleted'. at Microsoft.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at Microsoft.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, SqlCommand command, Boolean callerHasConnectionLock, Boolean asyncClose) 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.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.SendAlertNotification.Execute() in C:\CoolR-Group\portal\CoolR.Tasks\SendAlertNotification.cs:line 317 at DFramework.Scheduler.TaskBase.Run() in E:\Forked\Framework\DFramework.Scheduler\TaskBase.cs:line 176 ClientConnectionId:4d4f6641-91c0-4bdb-803b-a00764f07574 Error Number:207,State:1,Class:16 HelpLink.ProdName: Microsoft SQL Server;HelpLink.ProdVer: 17.00.0925;HelpLink.EvtSrc: MSSQLServer;HelpLink.EvtID: 207;HelpLink.BaseHelpUrl: https://go.microsoft.com/fwlink;HelpLink.LinkId: 20476;Query: DECLARE @AssetPurityId0 Int32 = 3676205, @AssetPurityId1 Int32 = 3676205, @IsDeleted Boolean = False Select UniqueGuid, AssetPurityId from AssetPurity WHERE AssetPurity.AssetPurityId IN ( @AssetPurityId0, @AssetPurityId1 ) AND IsDeleted = @IsDeleted 2026-01-15 08:14:27.8499 DFramework.Scheduler.TaskBase Error in task: Email AlertNotification Microsoft.Data.SqlClient.SqlException (0x80131904): Invalid column name 'IsDeleted'. at Microsoft.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at Microsoft.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, SqlCommand command, Boolean callerHasConnectionLock, Boolean asyncClose) 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.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.SendAlertNotification.Execute() in C:\CoolR-Group\portal\CoolR.Tasks\SendAlertNotification.cs:line 317 at DFramework.Scheduler.TaskBase.Run() in E:\Forked\Framework\DFramework.Scheduler\TaskBase.cs:line 176 ClientConnectionId:461663dd-3eee-43b9-9549-1c8539306630 Error Number:207,State:1,Class:16 HelpLink.ProdName: Microsoft SQL Server;HelpLink.ProdVer: 17.00.0925;HelpLink.EvtSrc: MSSQLServer;HelpLink.EvtID: 207;HelpLink.BaseHelpUrl: https://go.microsoft.com/fwlink;HelpLink.LinkId: 20476;Query: DECLARE @AssetPurityId0 Int32 = 3676205, @AssetPurityId1 Int32 = 3676205, @IsDeleted Boolean = False Select UniqueGuid, AssetPurityId from AssetPurity WHERE AssetPurity.AssetPurityId IN ( @AssetPurityId0, @AssetPurityId1 ) AND IsDeleted = @IsDeleted 2026-01-15 08:14:27.8655 TaskExecution Task Execution Error: Email AlertNotification Microsoft.Data.SqlClient.SqlException (0x80131904): Invalid column name 'IsDeleted'. at Microsoft.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at Microsoft.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, SqlCommand command, Boolean callerHasConnectionLock, Boolean asyncClose) 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.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.SendAlertNotification.Execute() in C:\CoolR-Group\portal\CoolR.Tasks\SendAlertNotification.cs:line 317 at DFramework.Scheduler.TaskBase.Run() in E:\Forked\Framework\DFramework.Scheduler\TaskBase.cs:line 176 ClientConnectionId:461663dd-3eee-43b9-9549-1c8539306630 Error Number:207,State:1,Class:16 HelpLink.ProdName: Microsoft SQL Server;HelpLink.ProdVer: 17.00.0925;HelpLink.EvtSrc: MSSQLServer;HelpLink.EvtID: 207;HelpLink.BaseHelpUrl: https://go.microsoft.com/fwlink;HelpLink.LinkId: 20476;Query: DECLARE @AssetPurityId0 Int32 = 3676205, @AssetPurityId1 Int32 = 3676205, @IsDeleted Boolean = False Select UniqueGuid, AssetPurityId from AssetPurity WHERE AssetPurity.AssetPurityId IN ( @AssetPurityId0, @AssetPurityId1 ) AND IsDeleted = @IsDeleted 2026-01-15 08:14:31.5374 CoolR.Tasks.MergeProductsTask Error Occured while merging products with PrimaryProductId - 24456, SecondaryProductId - 39415, ClientId - 286, UserId - 3151 Microsoft.Data.SqlClient.SqlException (0x80131904): Cannot insert duplicate key row in object 'dbo.ProductPricing' with unique index 'UX_ProductPricing_ProductId_Size_CaseOptionId'. The duplicate key value is (24456, 1, 5470). The statement has been terminated. at Microsoft.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at Microsoft.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, SqlCommand command, Boolean callerHasConnectionLock, Boolean asyncClose) 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.ExecuteScalar() at DFramework.Database.Query.<>c.b__103_0(DbCommandParameters parameters) in C:\CoolR-Group\Framework\DFramework\Database\Query.cs:line 554 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.ExecuteScalar(IDbCommand cm, IDbTransaction tr) in C:\CoolR-Group\Framework\DFramework\Database\Query.cs:line 552 at CoolR.Tasks.MergeProductsTask.Execute() in C:\CoolR-Group\portal\CoolR.Tasks\MergeProductsTask.cs:line 296 ClientConnectionId:b7006b56-dfe3-49f4-bd88-de64ac8b8476 Error Number:2601,State:1,Class:14 HelpLink.ProdName: Microsoft SQL Server;HelpLink.ProdVer: 17.00.0925;HelpLink.EvtSrc: MSSQLServer;HelpLink.EvtID: 2601;HelpLink.BaseHelpUrl: https://go.microsoft.com/fwlink;HelpLink.LinkId: 20476;Query: DECLARE @PrimaryProductId Int32 = 24456, @SecondaryProductId Int32 = 39415 UPDATE ProductPricing SET ProductId = @PrimaryProductId WHERE ProductId = @SecondaryProductId 2026-01-15 08:19:27.8517 DFramework.Scheduler.TaskBase Error in task: Email AlertNotification Microsoft.Data.SqlClient.SqlException (0x80131904): Invalid column name 'IsDeleted'. at Microsoft.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at Microsoft.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, SqlCommand command, Boolean callerHasConnectionLock, Boolean asyncClose) 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.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.SendAlertNotification.Execute() in C:\CoolR-Group\portal\CoolR.Tasks\SendAlertNotification.cs:line 317 at DFramework.Scheduler.TaskBase.Run() in E:\Forked\Framework\DFramework.Scheduler\TaskBase.cs:line 176 ClientConnectionId:374a28a3-f6a5-4f70-8206-83e1f5f8db6c Error Number:207,State:1,Class:16 HelpLink.ProdName: Microsoft SQL Server;HelpLink.ProdVer: 17.00.0925;HelpLink.EvtSrc: MSSQLServer;HelpLink.EvtID: 207;HelpLink.BaseHelpUrl: https://go.microsoft.com/fwlink;HelpLink.LinkId: 20476;Query: DECLARE @AssetPurityId0 Int32 = 3676205, @AssetPurityId1 Int32 = 3676205, @IsDeleted Boolean = False Select UniqueGuid, AssetPurityId from AssetPurity WHERE AssetPurity.AssetPurityId IN ( @AssetPurityId0, @AssetPurityId1 ) AND IsDeleted = @IsDeleted 2026-01-15 08:19:27.8674 TaskExecution Task Execution Error: Email AlertNotification Microsoft.Data.SqlClient.SqlException (0x80131904): Invalid column name 'IsDeleted'. at Microsoft.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at Microsoft.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, SqlCommand command, Boolean callerHasConnectionLock, Boolean asyncClose) 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.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.SendAlertNotification.Execute() in C:\CoolR-Group\portal\CoolR.Tasks\SendAlertNotification.cs:line 317 at DFramework.Scheduler.TaskBase.Run() in E:\Forked\Framework\DFramework.Scheduler\TaskBase.cs:line 176 ClientConnectionId:374a28a3-f6a5-4f70-8206-83e1f5f8db6c Error Number:207,State:1,Class:16 HelpLink.ProdName: Microsoft SQL Server;HelpLink.ProdVer: 17.00.0925;HelpLink.EvtSrc: MSSQLServer;HelpLink.EvtID: 207;HelpLink.BaseHelpUrl: https://go.microsoft.com/fwlink;HelpLink.LinkId: 20476;Query: DECLARE @AssetPurityId0 Int32 = 3676205, @AssetPurityId1 Int32 = 3676205, @IsDeleted Boolean = False Select UniqueGuid, AssetPurityId from AssetPurity WHERE AssetPurity.AssetPurityId IN ( @AssetPurityId0, @AssetPurityId1 ) AND IsDeleted = @IsDeleted 2026-01-15 08:24:27.9629 DFramework.Scheduler.TaskBase Error in task: Email AlertNotification Microsoft.Data.SqlClient.SqlException (0x80131904): Invalid column name 'IsDeleted'. at Microsoft.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at Microsoft.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, SqlCommand command, Boolean callerHasConnectionLock, Boolean asyncClose) 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.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.SendAlertNotification.Execute() in C:\CoolR-Group\portal\CoolR.Tasks\SendAlertNotification.cs:line 317 at DFramework.Scheduler.TaskBase.Run() in E:\Forked\Framework\DFramework.Scheduler\TaskBase.cs:line 176 ClientConnectionId:f7af2b12-e577-45db-8026-b6d979c9de7f Error Number:207,State:1,Class:16 HelpLink.ProdName: Microsoft SQL Server;HelpLink.ProdVer: 17.00.0925;HelpLink.EvtSrc: MSSQLServer;HelpLink.EvtID: 207;HelpLink.BaseHelpUrl: https://go.microsoft.com/fwlink;HelpLink.LinkId: 20476;Query: DECLARE @AssetPurityId0 Int32 = 3676205, @AssetPurityId1 Int32 = 3676205, @IsDeleted Boolean = False Select UniqueGuid, AssetPurityId from AssetPurity WHERE AssetPurity.AssetPurityId IN ( @AssetPurityId0, @AssetPurityId1 ) AND IsDeleted = @IsDeleted 2026-01-15 08:24:27.9942 TaskExecution Task Execution Error: Email AlertNotification Microsoft.Data.SqlClient.SqlException (0x80131904): Invalid column name 'IsDeleted'. at Microsoft.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at Microsoft.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, SqlCommand command, Boolean callerHasConnectionLock, Boolean asyncClose) 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.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.SendAlertNotification.Execute() in C:\CoolR-Group\portal\CoolR.Tasks\SendAlertNotification.cs:line 317 at DFramework.Scheduler.TaskBase.Run() in E:\Forked\Framework\DFramework.Scheduler\TaskBase.cs:line 176 ClientConnectionId:f7af2b12-e577-45db-8026-b6d979c9de7f Error Number:207,State:1,Class:16 HelpLink.ProdName: Microsoft SQL Server;HelpLink.ProdVer: 17.00.0925;HelpLink.EvtSrc: MSSQLServer;HelpLink.EvtID: 207;HelpLink.BaseHelpUrl: https://go.microsoft.com/fwlink;HelpLink.LinkId: 20476;Query: DECLARE @AssetPurityId0 Int32 = 3676205, @AssetPurityId1 Int32 = 3676205, @IsDeleted Boolean = False Select UniqueGuid, AssetPurityId from AssetPurity WHERE AssetPurity.AssetPurityId IN ( @AssetPurityId0, @AssetPurityId1 ) AND IsDeleted = @IsDeleted 2026-01-15 08:24:28.4160 CoolR.Tasks.MergeProductsTask Error Occured while merging products with PrimaryProductId - 24456, SecondaryProductId - 39415, ClientId - 286, UserId - 3151 Microsoft.Data.SqlClient.SqlException (0x80131904): Cannot insert duplicate key row in object 'dbo.ProductPricing' with unique index 'UX_ProductPricing_ProductId_Size_CaseOptionId'. The duplicate key value is (24456, 1, 5470). The statement has been terminated. at Microsoft.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at Microsoft.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, SqlCommand command, Boolean callerHasConnectionLock, Boolean asyncClose) 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.ExecuteScalar() at DFramework.Database.Query.<>c.b__103_0(DbCommandParameters parameters) in C:\CoolR-Group\Framework\DFramework\Database\Query.cs:line 554 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.ExecuteScalar(IDbCommand cm, IDbTransaction tr) in C:\CoolR-Group\Framework\DFramework\Database\Query.cs:line 552 at CoolR.Tasks.MergeProductsTask.Execute() in C:\CoolR-Group\portal\CoolR.Tasks\MergeProductsTask.cs:line 296 ClientConnectionId:374a28a3-f6a5-4f70-8206-83e1f5f8db6c Error Number:2601,State:1,Class:14 HelpLink.ProdName: Microsoft SQL Server;HelpLink.ProdVer: 17.00.0925;HelpLink.EvtSrc: MSSQLServer;HelpLink.EvtID: 2601;HelpLink.BaseHelpUrl: https://go.microsoft.com/fwlink;HelpLink.LinkId: 20476;Query: DECLARE @PrimaryProductId Int32 = 24456, @SecondaryProductId Int32 = 39415 UPDATE ProductPricing SET ProductId = @PrimaryProductId WHERE ProductId = @SecondaryProductId 2026-01-15 08:29:27.8556 DFramework.Scheduler.TaskBase Error in task: Email AlertNotification Microsoft.Data.SqlClient.SqlException (0x80131904): Invalid column name 'IsDeleted'. at Microsoft.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at Microsoft.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, SqlCommand command, Boolean callerHasConnectionLock, Boolean asyncClose) 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.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.SendAlertNotification.Execute() in C:\CoolR-Group\portal\CoolR.Tasks\SendAlertNotification.cs:line 317 at DFramework.Scheduler.TaskBase.Run() in E:\Forked\Framework\DFramework.Scheduler\TaskBase.cs:line 176 ClientConnectionId:c84315a2-01f5-409b-b80f-2a0120de7448 Error Number:207,State:1,Class:16 HelpLink.ProdName: Microsoft SQL Server;HelpLink.ProdVer: 17.00.0925;HelpLink.EvtSrc: MSSQLServer;HelpLink.EvtID: 207;HelpLink.BaseHelpUrl: https://go.microsoft.com/fwlink;HelpLink.LinkId: 20476;Query: DECLARE @AssetPurityId0 Int32 = 3676205, @AssetPurityId1 Int32 = 3676205, @IsDeleted Boolean = False Select UniqueGuid, AssetPurityId from AssetPurity WHERE AssetPurity.AssetPurityId IN ( @AssetPurityId0, @AssetPurityId1 ) AND IsDeleted = @IsDeleted 2026-01-15 08:29:27.8712 TaskExecution Task Execution Error: Email AlertNotification Microsoft.Data.SqlClient.SqlException (0x80131904): Invalid column name 'IsDeleted'. at Microsoft.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at Microsoft.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, SqlCommand command, Boolean callerHasConnectionLock, Boolean asyncClose) 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.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.SendAlertNotification.Execute() in C:\CoolR-Group\portal\CoolR.Tasks\SendAlertNotification.cs:line 317 at DFramework.Scheduler.TaskBase.Run() in E:\Forked\Framework\DFramework.Scheduler\TaskBase.cs:line 176 ClientConnectionId:c84315a2-01f5-409b-b80f-2a0120de7448 Error Number:207,State:1,Class:16 HelpLink.ProdName: Microsoft SQL Server;HelpLink.ProdVer: 17.00.0925;HelpLink.EvtSrc: MSSQLServer;HelpLink.EvtID: 207;HelpLink.BaseHelpUrl: https://go.microsoft.com/fwlink;HelpLink.LinkId: 20476;Query: DECLARE @AssetPurityId0 Int32 = 3676205, @AssetPurityId1 Int32 = 3676205, @IsDeleted Boolean = False Select UniqueGuid, AssetPurityId from AssetPurity WHERE AssetPurity.AssetPurityId IN ( @AssetPurityId0, @AssetPurityId1 ) AND IsDeleted = @IsDeleted 2026-01-15 08:34:27.7481 DFramework.Scheduler.TaskBase Error in task: Email AlertNotification Microsoft.Data.SqlClient.SqlException (0x80131904): Invalid column name 'IsDeleted'. at Microsoft.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at Microsoft.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, SqlCommand command, Boolean callerHasConnectionLock, Boolean asyncClose) 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.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.SendAlertNotification.Execute() in C:\CoolR-Group\portal\CoolR.Tasks\SendAlertNotification.cs:line 317 at DFramework.Scheduler.TaskBase.Run() in E:\Forked\Framework\DFramework.Scheduler\TaskBase.cs:line 176 ClientConnectionId:82198ab9-2382-4a2e-9af6-016e806f99ee Error Number:207,State:1,Class:16 HelpLink.ProdName: Microsoft SQL Server;HelpLink.ProdVer: 17.00.0925;HelpLink.EvtSrc: MSSQLServer;HelpLink.EvtID: 207;HelpLink.BaseHelpUrl: https://go.microsoft.com/fwlink;HelpLink.LinkId: 20476;Query: DECLARE @AssetPurityId0 Int32 = 3676205, @AssetPurityId1 Int32 = 3676205, @IsDeleted Boolean = False Select UniqueGuid, AssetPurityId from AssetPurity WHERE AssetPurity.AssetPurityId IN ( @AssetPurityId0, @AssetPurityId1 ) AND IsDeleted = @IsDeleted 2026-01-15 08:34:27.7793 TaskExecution Task Execution Error: Email AlertNotification Microsoft.Data.SqlClient.SqlException (0x80131904): Invalid column name 'IsDeleted'. at Microsoft.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at Microsoft.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, SqlCommand command, Boolean callerHasConnectionLock, Boolean asyncClose) 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.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.SendAlertNotification.Execute() in C:\CoolR-Group\portal\CoolR.Tasks\SendAlertNotification.cs:line 317 at DFramework.Scheduler.TaskBase.Run() in E:\Forked\Framework\DFramework.Scheduler\TaskBase.cs:line 176 ClientConnectionId:82198ab9-2382-4a2e-9af6-016e806f99ee Error Number:207,State:1,Class:16 HelpLink.ProdName: Microsoft SQL Server;HelpLink.ProdVer: 17.00.0925;HelpLink.EvtSrc: MSSQLServer;HelpLink.EvtID: 207;HelpLink.BaseHelpUrl: https://go.microsoft.com/fwlink;HelpLink.LinkId: 20476;Query: DECLARE @AssetPurityId0 Int32 = 3676205, @AssetPurityId1 Int32 = 3676205, @IsDeleted Boolean = False Select UniqueGuid, AssetPurityId from AssetPurity WHERE AssetPurity.AssetPurityId IN ( @AssetPurityId0, @AssetPurityId1 ) AND IsDeleted = @IsDeleted 2026-01-15 08:34:28.2012 CoolR.Tasks.MergeProductsTask Error Occured while merging products with PrimaryProductId - 24456, SecondaryProductId - 39415, ClientId - 286, UserId - 3151 Microsoft.Data.SqlClient.SqlException (0x80131904): Cannot insert duplicate key row in object 'dbo.ProductPricing' with unique index 'UX_ProductPricing_ProductId_Size_CaseOptionId'. The duplicate key value is (24456, 1, 5470). The statement has been terminated. at Microsoft.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at Microsoft.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, SqlCommand command, Boolean callerHasConnectionLock, Boolean asyncClose) 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.ExecuteScalar() at DFramework.Database.Query.<>c.b__103_0(DbCommandParameters parameters) in C:\CoolR-Group\Framework\DFramework\Database\Query.cs:line 554 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.ExecuteScalar(IDbCommand cm, IDbTransaction tr) in C:\CoolR-Group\Framework\DFramework\Database\Query.cs:line 552 at CoolR.Tasks.MergeProductsTask.Execute() in C:\CoolR-Group\portal\CoolR.Tasks\MergeProductsTask.cs:line 296 ClientConnectionId:9a18471b-ff48-4c29-9533-6ef70b0ce07b Error Number:2601,State:1,Class:14 HelpLink.ProdName: Microsoft SQL Server;HelpLink.ProdVer: 17.00.0925;HelpLink.EvtSrc: MSSQLServer;HelpLink.EvtID: 2601;HelpLink.BaseHelpUrl: https://go.microsoft.com/fwlink;HelpLink.LinkId: 20476;Query: DECLARE @PrimaryProductId Int32 = 24456, @SecondaryProductId Int32 = 39415 UPDATE ProductPricing SET ProductId = @PrimaryProductId WHERE ProductId = @SecondaryProductId 2026-01-15 08:37:55.2962 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.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 1460 at CoolR.Tasks.ProcessAlertData.Execute() in C:\CoolR-Group\portal\CoolR.Tasks\ProcessAlertData.cs:line 346 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.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 1460 at CoolR.Tasks.ProcessAlertData.Execute() in C:\CoolR-Group\portal\CoolR.Tasks\ProcessAlertData.cs:line 346 Query: DECLARE @AssetPurityId Int32 = 3676204, @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-15 08:37:55.3430 AlertProcessor System.Threading.ThreadAbortException: Thread was being aborted. at CoolR.Tasks.ProcessAlertData.Execute() in C:\CoolR-Group\portal\CoolR.Tasks\ProcessAlertData.cs:line 402 System.Threading.ThreadAbortException: Thread was being aborted. at CoolR.Tasks.ProcessAlertData.Execute() in C:\CoolR-Group\portal\CoolR.Tasks\ProcessAlertData.cs:line 402 2026-01-15 08:37:55.4524 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 415 at DFramework.Scheduler.TaskBase.Run() in E:\Forked\Framework\DFramework.Scheduler\TaskBase.cs:line 176 2026-01-15 08:37:55.4993 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 415 at DFramework.Scheduler.TaskBase.Run() in E:\Forked\Framework\DFramework.Scheduler\TaskBase.cs:line 176 2026-01-15 08:42:58.5950 CoolR.Tasks.MergeProductsTask Error Occured while merging products with PrimaryProductId - 24456, SecondaryProductId - 39415, ClientId - 286, UserId - 3151 Microsoft.Data.SqlClient.SqlException (0x80131904): Cannot insert duplicate key row in object 'dbo.ProductPricing' with unique index 'UX_ProductPricing_ProductId_Size_CaseOptionId'. The duplicate key value is (24456, 1, 5470). The statement has been terminated. at Microsoft.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at Microsoft.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, SqlCommand command, Boolean callerHasConnectionLock, Boolean asyncClose) 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.ExecuteScalar() at DFramework.Database.Query.<>c.b__103_0(DbCommandParameters parameters) in C:\CoolR-Group\Framework\DFramework\Database\Query.cs:line 554 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.ExecuteScalar(IDbCommand cm, IDbTransaction tr) in C:\CoolR-Group\Framework\DFramework\Database\Query.cs:line 552 at CoolR.Tasks.MergeProductsTask.Execute() in C:\CoolR-Group\portal\CoolR.Tasks\MergeProductsTask.cs:line 296 ClientConnectionId:facef365-e7ff-4140-8a0f-a21c1a0b5a42 Error Number:2601,State:1,Class:14 HelpLink.ProdName: Microsoft SQL Server;HelpLink.ProdVer: 17.00.0925;HelpLink.EvtSrc: MSSQLServer;HelpLink.EvtID: 2601;HelpLink.BaseHelpUrl: https://go.microsoft.com/fwlink;HelpLink.LinkId: 20476;Query: DECLARE @PrimaryProductId Int32 = 24456, @SecondaryProductId Int32 = 39415 UPDATE ProductPricing SET ProductId = @PrimaryProductId WHERE ProductId = @SecondaryProductId 2026-01-15 08:52:20.8954 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.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 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.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 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-15 08:52:20.9735 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-15 08:52:21.0673 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-15 08:52:21.1298 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