If you are receiving an error when you are merging clients, type talk to a person and the Digital Assistant will put you through to a live support agent. Please include the following information:
The client IDs you are merging.
The error message you are receiving.
List of potential error messages when merging clients.
The Microsoft Distributed Transaction Coordinator (MS DTC) has cancelled the distributed transaction.
The DELETE statement conflicted with the REFERENCE constraint "FK_DTSQueueArchive_ClientID". The conflict occurred in database "RIO_LIVE", table "dbo.DTSQueueArchive", column 'ClientID'.
The DELETE statement conflicted with the REFERENCE constraint "FK_AmsAppointmentOutcomeProgressNote_AmsAppointmentContact". The conflict occurred in database "LIVE", table "dbo.AmsAppointmentOutcomeProgressNote", column 'ContactID'.
Cannot insert the value NULL into column 'SignificantEvent', table 'RIO7_DB_V7100.dbo.EPClientMedicationEvent'; column does not allow nulls. INSERT fails.
The UPDATE statement conflicted with the FOREIGN KEY constraint "FK_ChdClientImmunisation_GenChdAdminMethod. The conflict occurred in database "LIVE", table "dbo.GenChdAdminMethod", column 'Code'.
The DELETE statement conflicted with the REFERENCE constraint "FK_AuditTrailExternalSystem_ClientIndex". The conflict occurred in database "LIVE", table "dbo.AuditTrailExternalSystem", column 'ClientID'.
The DELETE statement conflicted with the REFERENCE constraint "FK_ClientContact_Client". The conflict occurred in database "LIVE", table "dbo.ClientContact", column 'ClientID'