2026-01-16 05:42:58.8281 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.<ExecuteScalar>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:24d37a1b-cbc6-4598-a8f8-7cfbd1ce1bbf
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-16 05:52:57.2449 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.<ExecuteScalar>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:4e78391e-2868-472e-8ee1-acd1deafcfa0
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-16 06:02:57.2561 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.<ExecuteScalar>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:dc66106b-16d9-4ff5-9943-f9d7ebb54ec9
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-16 06:12:57.6765 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.<ExecuteScalar>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:b16f405a-20e8-43b4-b150-b4caabae4584
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-16 06:22:57.2575 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.<ExecuteScalar>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:e89fe018-d42e-4bc3-8a62-bcb00058454a
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-16 06:32:57.2965 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.<ExecuteScalar>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:60acc99e-5ea2-4a2f-9c28-2a60fb64af2b
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-16 06:42:57.6078 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.<ExecuteScalar>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:841ddf50-1bb9-4b9a-b945-82b32a0ae8de
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-16 06:52:57.3629 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.<ExecuteScalar>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:6a0aae3b-cd9a-41db-bfbe-8bbadb7d272b
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-16 07:02:57.3388 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.<ExecuteScalar>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:94376307-ea37-4124-a4c2-2a8ad8221af9
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-16 07:12:58.3548 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.<ExecuteScalar>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:ed00ccd7-3ff4-42e2-99cd-e6f2e27c3c14
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-16 07:22:57.3782 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.<ExecuteScalar>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:53808f2b-5f85-4a9a-ab40-60d47be3b469
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-16 07:28:02.6967 AlertProcessor    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.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.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry)
   at Microsoft.Data.SqlClient.SqlCommand.ExecuteNonQuery()
   at DFramework.Database.Query.<>c.<ExecuteNonQuery>b__107_0(DbCommandParameters parameters) in C:\CoolR-Group\Framework\DFramework\Database\Query.cs:line 653
   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.ExecuteNonQuery(IDbCommand cm, IDbTransaction tr) in C:\CoolR-Group\Framework\DFramework\Database\Query.cs:line 651
   at CoolR.Tasks.ProcessOutletAlertData.CloseUnmatchProductAlerts(Int32 locationId, List`1 productIds, DateTime closedOn, Int32 recordId) in C:\CoolR-Group\portal\CoolR.Tasks\OpportunityOutOfStockByOutlet.cs:line 619
   at CoolR.Tasks.ProcessOutletAlertData.OpportunityOutOfStockAlertConsolidate(String alertText, Int32 alertDefinitionId, Int32 clientId, Int32 locationId, Int32 priorityId, Int32 timeZoneId, Int32 lastImageThreshold, Int32 productCount, List`1 alertDefinitionProductIds, DateTime lastImageVerifiedOn, Dictionary`2 locationAttribute) in C:\CoolR-Group\portal\CoolR.Tasks\OpportunityOutOfStockByOutlet.cs:line 166
ClientConnectionId:ebc3bde6-5468-4b9b-82c4-78dca7a6f7c1
Error Number:207,State:1,Class:16 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.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.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry)
   at Microsoft.Data.SqlClient.SqlCommand.ExecuteNonQuery()
   at DFramework.Database.Query.<>c.<ExecuteNonQuery>b__107_0(DbCommandParameters parameters) in C:\CoolR-Group\Framework\DFramework\Database\Query.cs:line 653
   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.ExecuteNonQuery(IDbCommand cm, IDbTransaction tr) in C:\CoolR-Group\Framework\DFramework\Database\Query.cs:line 651
   at CoolR.Tasks.ProcessOutletAlertData.CloseUnmatchProductAlerts(Int32 locationId, List`1 productIds, DateTime closedOn, Int32 recordId) in C:\CoolR-Group\portal\CoolR.Tasks\OpportunityOutOfStockByOutlet.cs:line 619
   at CoolR.Tasks.ProcessOutletAlertData.OpportunityOutOfStockAlertConsolidate(String alertText, Int32 alertDefinitionId, Int32 clientId, Int32 locationId, Int32 priorityId, Int32 timeZoneId, Int32 lastImageThreshold, Int32 productCount, List`1 alertDefinitionProductIds, DateTime lastImageVerifiedOn, Dictionary`2 locationAttribute) in C:\CoolR-Group\portal\CoolR.Tasks\OpportunityOutOfStockByOutlet.cs:line 166
ClientConnectionId:ebc3bde6-5468-4b9b-82c4-78dca7a6f7c1
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 @CloseStatusId Int32 = 255,
@ClosedOn DateTime2 = 1/16/2026 8:52:23 PM,
@LastUpdatedOn DateTime2 = 1/16/2026 8:52:23 PM,
@RecordId Int32 = 3676288,
@ProductIds AnsiString = 9669,19185,
@LocationId Int32 = 330335,
@AlertTypeId Int32 = 75,
@NewStatusId Int32 = 1
UPDATE Alert SET StatusId = @CloseStatusId, ClosedOn = @ClosedOn, LastUpdatedOn = @LastUpdatedOn, RecordId = @RecordId 
			WHERE LocationId = @LocationId AND ProductId NOT IN (SELECT IntValue FROM dbo.CsvToInt(@ProductIds)) AND IsDeleted = 0 AND StatusId = @NewStatusId AND AlertTypeId = @AlertTypeId AND LastUpdatedOn < @LastUpdatedOn


2026-01-16 07:28:02.8843 AlertProcessor    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.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.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry)
   at Microsoft.Data.SqlClient.SqlCommand.ExecuteNonQuery()
   at DFramework.Database.Query.<>c.<ExecuteNonQuery>b__107_0(DbCommandParameters parameters) in C:\CoolR-Group\Framework\DFramework\Database\Query.cs:line 653
   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.ExecuteNonQuery(IDbCommand cm, IDbTransaction tr) in C:\CoolR-Group\Framework\DFramework\Database\Query.cs:line 651
   at CoolR.Tasks.ProcessOutletAlertData.CloseUnmatchProductAlerts(Int32 locationId, List`1 productIds, DateTime closedOn, Int32 recordId) in C:\CoolR-Group\portal\CoolR.Tasks\OpportunityOutOfStockByOutlet.cs:line 619
   at CoolR.Tasks.ProcessOutletAlertData.OpportunityOutOfStockAlertConsolidate(String alertText, Int32 alertDefinitionId, Int32 clientId, Int32 locationId, Int32 priorityId, Int32 timeZoneId, Int32 lastImageThreshold, Int32 productCount, List`1 alertDefinitionProductIds, DateTime lastImageVerifiedOn, Dictionary`2 locationAttribute) in C:\CoolR-Group\portal\CoolR.Tasks\OpportunityOutOfStockByOutlet.cs:line 166
ClientConnectionId:ebc3bde6-5468-4b9b-82c4-78dca7a6f7c1
Error Number:207,State:1,Class:16 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.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.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry)
   at Microsoft.Data.SqlClient.SqlCommand.ExecuteNonQuery()
   at DFramework.Database.Query.<>c.<ExecuteNonQuery>b__107_0(DbCommandParameters parameters) in C:\CoolR-Group\Framework\DFramework\Database\Query.cs:line 653
   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.ExecuteNonQuery(IDbCommand cm, IDbTransaction tr) in C:\CoolR-Group\Framework\DFramework\Database\Query.cs:line 651
   at CoolR.Tasks.ProcessOutletAlertData.CloseUnmatchProductAlerts(Int32 locationId, List`1 productIds, DateTime closedOn, Int32 recordId) in C:\CoolR-Group\portal\CoolR.Tasks\OpportunityOutOfStockByOutlet.cs:line 619
   at CoolR.Tasks.ProcessOutletAlertData.OpportunityOutOfStockAlertConsolidate(String alertText, Int32 alertDefinitionId, Int32 clientId, Int32 locationId, Int32 priorityId, Int32 timeZoneId, Int32 lastImageThreshold, Int32 productCount, List`1 alertDefinitionProductIds, DateTime lastImageVerifiedOn, Dictionary`2 locationAttribute) in C:\CoolR-Group\portal\CoolR.Tasks\OpportunityOutOfStockByOutlet.cs:line 166
ClientConnectionId:ebc3bde6-5468-4b9b-82c4-78dca7a6f7c1
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 @CloseStatusId Int32 = 255,
@ClosedOn DateTime2 = 1/16/2026 8:55:29 PM,
@LastUpdatedOn DateTime2 = 1/16/2026 8:55:29 PM,
@RecordId Int32 = 3676290,
@ProductIds AnsiString = 24549,37725,24571,24535,24577,24536,23489,23468,
@LocationId Int32 = 433674,
@AlertTypeId Int32 = 75,
@NewStatusId Int32 = 1
UPDATE Alert SET StatusId = @CloseStatusId, ClosedOn = @ClosedOn, LastUpdatedOn = @LastUpdatedOn, RecordId = @RecordId 
			WHERE LocationId = @LocationId AND ProductId NOT IN (SELECT IntValue FROM dbo.CsvToInt(@ProductIds)) AND IsDeleted = 0 AND StatusId = @NewStatusId AND AlertTypeId = @AlertTypeId AND LastUpdatedOn < @LastUpdatedOn


2026-01-16 07:32:57.2550 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.<ExecuteScalar>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:4f18dad1-0d73-4ef2-801a-27eaf0804bb3
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-16 07:42:57.7074 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.<ExecuteScalar>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:ebc3bde6-5468-4b9b-82c4-78dca7a6f7c1
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-16 07:52:57.5829 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.<ExecuteScalar>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:97c38923-4e5b-4c89-8c7e-f6fb7c53c27e
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-16 07:58:07.4217 AlertProcessor    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.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.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry)
   at Microsoft.Data.SqlClient.SqlCommand.ExecuteNonQuery()
   at DFramework.Database.Query.<>c.<ExecuteNonQuery>b__107_0(DbCommandParameters parameters) in C:\CoolR-Group\Framework\DFramework\Database\Query.cs:line 653
   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.ExecuteNonQuery(IDbCommand cm, IDbTransaction tr) in C:\CoolR-Group\Framework\DFramework\Database\Query.cs:line 651
   at CoolR.Tasks.ProcessOutletAlertData.CloseUnmatchProductAlerts(Int32 locationId, List`1 productIds, DateTime closedOn, Int32 recordId) in C:\CoolR-Group\portal\CoolR.Tasks\OpportunityOutOfStockByOutlet.cs:line 619
   at CoolR.Tasks.ProcessOutletAlertData.OpportunityOutOfStockAlertConsolidate(String alertText, Int32 alertDefinitionId, Int32 clientId, Int32 locationId, Int32 priorityId, Int32 timeZoneId, Int32 lastImageThreshold, Int32 productCount, List`1 alertDefinitionProductIds, DateTime lastImageVerifiedOn, Dictionary`2 locationAttribute) in C:\CoolR-Group\portal\CoolR.Tasks\OpportunityOutOfStockByOutlet.cs:line 166
ClientConnectionId:16a703b7-f7d7-404d-894b-8106b4d78b86
Error Number:207,State:1,Class:16 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.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.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry)
   at Microsoft.Data.SqlClient.SqlCommand.ExecuteNonQuery()
   at DFramework.Database.Query.<>c.<ExecuteNonQuery>b__107_0(DbCommandParameters parameters) in C:\CoolR-Group\Framework\DFramework\Database\Query.cs:line 653
   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.ExecuteNonQuery(IDbCommand cm, IDbTransaction tr) in C:\CoolR-Group\Framework\DFramework\Database\Query.cs:line 651
   at CoolR.Tasks.ProcessOutletAlertData.CloseUnmatchProductAlerts(Int32 locationId, List`1 productIds, DateTime closedOn, Int32 recordId) in C:\CoolR-Group\portal\CoolR.Tasks\OpportunityOutOfStockByOutlet.cs:line 619
   at CoolR.Tasks.ProcessOutletAlertData.OpportunityOutOfStockAlertConsolidate(String alertText, Int32 alertDefinitionId, Int32 clientId, Int32 locationId, Int32 priorityId, Int32 timeZoneId, Int32 lastImageThreshold, Int32 productCount, List`1 alertDefinitionProductIds, DateTime lastImageVerifiedOn, Dictionary`2 locationAttribute) in C:\CoolR-Group\portal\CoolR.Tasks\OpportunityOutOfStockByOutlet.cs:line 166
ClientConnectionId:16a703b7-f7d7-404d-894b-8106b4d78b86
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 @CloseStatusId Int32 = 255,
@ClosedOn DateTime2 = 1/16/2026 9:15:12 PM,
@LastUpdatedOn DateTime2 = 1/16/2026 9:15:12 PM,
@RecordId Int32 = 3676296,
@ProductIds AnsiString = 37770,37768,37766,
@LocationId Int32 = 433681,
@AlertTypeId Int32 = 75,
@NewStatusId Int32 = 1
UPDATE Alert SET StatusId = @CloseStatusId, ClosedOn = @ClosedOn, LastUpdatedOn = @LastUpdatedOn, RecordId = @RecordId 
			WHERE LocationId = @LocationId AND ProductId NOT IN (SELECT IntValue FROM dbo.CsvToInt(@ProductIds)) AND IsDeleted = 0 AND StatusId = @NewStatusId AND AlertTypeId = @AlertTypeId AND LastUpdatedOn < @LastUpdatedOn


2026-01-16 08:02:57.3792 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.<ExecuteScalar>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:f53c0a42-bb4b-4e85-bf5d-fe6e39051574
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-16 08:12:57.9070 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.<ExecuteScalar>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:356fcdda-d83f-4971-b0f3-3d594eaead48
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-16 08:22:57.4488 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.<ExecuteScalar>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:ce4a0ff3-9d1c-46fa-a4b0-bc44c6d77d9c
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