File Import Log File Duplicate Handling #888
Description
26/08/2025 08:43:54.9273 | Error |Correlation ID: 4fbd9cea-136a-4b7b-b134-8bde3e710889| Shared.EventStore.SubscriptionWorker.PersistentSubscription.EventAppeared | Failed to process the event type FileAddedToImportLogEvent {"estateId":"435613ac-a468-47a3-ac4f-649d89764c22","fileId":"87e33f50-4120-9182-2ebe-98d048036715","fileImportLogId":"7b4c13ac-5c9a-4f80-ac4f-649d89764c22","filePath":"/home/txnproc/bulkfiles/safaricom//435613aca46847a3ac4f649d89764c22-87e33f50412091822ebe98d048036715","fileProfileId":"b2a59abf-293d-4a6b-b81b-7007503c3476","fileUploadedDateTime":"2025-07-01T00:00:00","merchantId":"ab1c99fb-1c6c-4694-9a32-b71be5d1da33","originalFileName":"bulkfile2025-07-01","userId":"75e19f2e-2ce9-4296-930a-3bb4416375f4"} Result was One or more event handlers have failed. Error Messages [Unique constraint violation
Violation of PRIMARY KEY constraint 'PK_fileimportlogfile'. Cannot insert duplicate key in object 'dbo.fileimportlogfile'. The duplicate key value is (7b4c13ac-5c9a-4f80-ac4f-649d89764c22, 87e33f50-4120-9182-2ebe-98d048036715).
The statement has been terminated.] | System.Exception