Contract Product Duplicate Handling #886
Description
26/08/2025 08:43:54.9229 | Error |Correlation ID: e7ac91a2-8441-42d0-91f4-acb9039004ae| Shared.EventStore.SubscriptionWorker.PersistentSubscription.EventAppeared | Failed to process the event type VariableValueProductAddedToContractEvent {"contractId":"b5c73a70-d5ca-4592-afc6-477eff11f310","estateId":"435613ac-a468-47a3-ac4f-649d89764c22","productId":"c50eaa83-7045-4ede-a813-a2596e314c73","productName":"Post Pay Bill Pay","displayText":"Bill Pay (Post)"} Result was One or more event handlers have failed. Error Messages [Unique constraint violation
Cannot insert duplicate key row in object 'dbo.contractproduct' with unique index 'IX_contractproduct_ContractProductId_ContractId'. The duplicate key value is (c50eaa83-7045-4ede-a813-a2596e314c73, b5c73a70-d5ca-4592-afc6-477eff11f310).] | System.Exception