Case or Appliance Restore in eDiscovery Platform 10.2.x Fails With Error Duplicate Entry for key t_participantemailaddress.EMAILADDRESS

Problem

An error occurs while trying to restore a case backup or appliance backup to eDiscovery Platform (eDP) v10.2.x.  The error states Duplicate Entry <SomeEmailAddress> for key t_participantemailaddress.EMAILADDRESS.

Error Message

Below is an example seen from Clearwell Utility option 2. Restore Appliance.  Similar errors occur with case backups:
[dbbackuprestoreprop] Restore exception thrown: java.util.concurrent.ExecutionException: Runtime error: mysql: [Warning] Using a password on the command line interface can be insecure.
[dbbackuprestoreprop] ERROR 1062 (23000) at line 7169 in file: 'RESTORE_dbdump_lds_case_a52c0h2y19_5849.sql': Duplicate entry 'abigail.smith@edp.lab' for key 't_participantemailaddress.EMAILADDRESS'
[dbbackuprestoreprop] ERROR 1062 (23000) at line 7169 in file: 'RESTORE_dbdump_lds_case_a52c0h2y19_5849.sql': Duplicate entry 'abigail.smith@edp.lab' for key 't_participantemailaddress.EMAILADDRESS'
[dbbackuprestoreprop]   at java.util.concurrent.FutureTask.report(FutureTask.java:122)
[dbbackuprestoreprop]   at java.util.concurrent.FutureTask.get(FutureTask.java:192)
[dbbackuprestoreprop]   at com.teneo.esa.ant.common.DbBackupRestorePropertyTask.executeRestore(DbBackupRestorePropertyTask.java:1056)
[dbbackuprestoreprop]   at com.teneo.esa.ant.common.DbBackupRestorePropertyTask.execute(DbBackupRestorePropertyTask.java:719)
[dbbackuprestoreprop]   at org.apache.tools.ant.UnknownElement.execute(UnknownElement.java:299)
[dbbackuprestoreprop]   at sun.reflect.GeneratedMethodAccessor5.invoke(Unknown Source)
[dbbackuprestoreprop]   at org.apache.tools.ant.UnknownElement.execute(UnknownElement.java:299)
[dbbackuprestoreprop]   at sun.reflect.GeneratedMethodAccessor5.invoke(Unknown Source)
[dbbackuprestoreprop]   at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
[dbbackuprestoreprop]   at java.lang.reflect.Method.invoke(Method.java:498)
[dbbackuprestoreprop]   at org.apache.tools.ant.dispatch.DispatchUtils.execute(DispatchUtils.java:99)
[dbbackuprestoreprop]   at org.apache.tools.ant.Task.perform(Task.java:350)
[dbbackuprestoreprop]   at org.apache.tools.ant.Target.execute(Target.java:449)
[dbbackuprestoreprop]   at org.apache.tools.ant.Target.performTasks(Target.java:470)
[dbbackuprestoreprop]   at org.apache.tools.ant.Project.executeSortedTargets(Project.java:1401)
[dbbackuprestoreprop]   at org.apache.tools.ant.UnknownElement.execute(UnknownElement.java:299)
[dbbackuprestoreprop] ERROR 1062 (23000) at line 7169 in file: 'RESTORE_dbdump_lds_case_a52c0h2y19_5849.sql': Duplicate entry 'abigail.smith@edp.lab' for key 't_participantemailaddress.EMAILADDRESS'

[dbbackuprestoreprop] Begin cancellation of all restore tasks...
[dbbackuprestoreprop] All restore tasks cancelled.
[dbbackuprestoreprop] Attempting to stop all active tasks.
[dbbackuprestoreprop] Waiting for all tasks to complete the execution.
[dbbackuprestoreprop] Cleaning up the temp files from current directory: c:\backups\eDP-App1 09-18-2023
[dbbackuprestoreprop] Cleaning up the temp files from tempDir: D:\CW\V102\scratch\temp
[dbbackuprestoreprop] Cleaning up the temp file: D:\CW\V102\scratch\temp\RESTORE_dbdump_lds_email_locator_a52c0h2y1d_89869.sql
[dbbackuprestoreprop] Cleaning up the temp file: D:\CW\V102\scratch\temp\RESTORE_dbdump_lds_index_a52c0h2y1g_36621.sql
[dbbackuprestoreprop]
[dbbackuprestoreprop] Total time taken to restore DB data stores: 23 Mins

BUILD FAILED
D:\CW\V102\build.xml:2323: The following error occurred while executing this line:
D:\CW\V102\build\build-schema.xml:1711: The following error occurred while executing this line:
D:\CW\V102\build\build-schema.xml:2092: The following error occurred while executing this line:
D:\CW\V102\build\build-schema.xml:2437: Runtime error: mysql: [Warning] Using a password on the command line interface can be insecure.
ERROR 1062 (23000) at line 7169 in file: 'RESTORE_dbdump_lds_case_a52c0h2y19_5849.sql': Duplicate entry 'abigail.smith@edp.lab' for key 't_participantemailaddress.EMAILADDRESS'

Cause

Currently under investigation.

Solution

Many of the restoring of case backups issues have been resolved in eDP v10.2.3 and above. Due to the complexity of this issue, there are different scenarios that eDP v10.2.3 with a patch and new versions may not resolve the issue. The restoring of appliance backups requires eDP v10.2.3 and above, plus a patch.  If the patch is needed or the issue persists in newer versions, please contact support and reference this technote.