Estate Security User Duplicate Handling #891
Description
26/08/2025 08:43:55.0295 | Error |Correlation ID: 868549d6-89ba-4bcb-88e5-bb62ffaca4a0| Shared.EventStore.SubscriptionWorker.PersistentSubscription.EventAppeared | Failed to process the event type SecurityUserAddedToEstateEvent {"estateId":"435613ac-a468-47a3-ac4f-649d89764c22","securityUserId":"75e19f2e-2ce9-4296-930a-3bb4416375f4","emailAddress":"estateuser@stagingestate1.co.uk"} Result was One or more event handlers have failed. Error Messages [Unique constraint violation
Violation of PRIMARY KEY constraint 'PK_estatesecurityuser'. Cannot insert duplicate key in object 'dbo.estatesecurityuser'. The duplicate key value is (75e19f2e-2ce9-4296-930a-3bb4416375f4, 435613ac-a468-47a3-ac4f-649d89764c22).
The statement has been terminated.] | System.Exception