Error Message

Error shown below from Clearwell Utility > 2. Restore Appliance console. (***Taken from an internal Enterprise Vault Lab***):
[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 3845 in file: 'RESTORE_dbdump_lds_case_aznakqhi4n_23094.sql': Duplicate entry 'Test???SpecialCharacterGroup' for key 't_group.TITLE'
[dbbackuprestoreprop]
[dbbackuprestoreprop] 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 3845 in file: 'RESTORE_dbdump_lds_case_aznakqhi4n_23094.sql': Duplicate entry 'Test???SpecialCharacterGroup' for key 't_group.TITLE'
[dbbackuprestoreprop]
[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] Caused by: Runtime error: mysql: [Warning] Using a password on the command line interface can be insecure.
[dbbackuprestoreprop] ERROR 1062 (23000) at line 3845 in file: 'RESTORE_dbdump_lds_case_aznakqhi4n_23094.sql': Duplicate entry 'Test???SpecialCharacterGroup' for key 't_group.TITLE'
•••
[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: D:\CW\V102\backups\repro
[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_case_3_70038.sql
[dbbackuprestoreprop] Cleaning up the temp file: D:\CW\V102\scratch\temp\RESTORE_dbdump_lds_case_aznakqhi4v_79469.sql
[dbbackuprestoreprop] Cleaning up the temp file: D:\CW\V102\scratch\temp\RESTORE_dbdump_lds_email_locator_aznakqhi50_68484.sql
[dbbackuprestoreprop] Cleaning up the temp file: D:\CW\V102\scratch\temp\RESTORE_dbdump_lds_index_aznakqhi53_29761.sql
[dbbackuprestoreprop]
[dbbackuprestoreprop] Total time taken to restore DB data stores: 1 Mins

BUILD FAILED

There is more than one group name being added to a table called t_group with similar names.  For example, Test&Group and Test Group.  The restore replaces the special character with a space, making it now Test Group which is the same as the other group name and therefore a duplicate entry.

Enterprise Vault has acknowledged that the above-mentioned issue is present in the current version(s) of the product(s). Enterprise Vault is committed to product quality and satisfying customers. The issue is currently scheduled to be addressed in the next CHF v10.2.6 of the product which is tentatively planned for the end of March 2024. Please note that Enterprise Vault Technologies LLC reserves the right to remove any fix  from the targeted release if it does not pass quality assurance tests.  Enterprise Vault’ plans are subject to change and any action taken by you based on the above information or your reliance upon the above information is taken at your own risk.

Any customer on eDiscovery Platform versions on and between 10.2 through 10.2.3 and requires a solution before CHF v10.2.6, would first need to upgrade to eDiscovery Platform version 10.2.4 or 10.2.5, create a new Enterprise Vault support case, reference this technote, and request the patch. The patch can be applied to v10.2.4 or v10.2.5.

Node restore fails with an error pointing to a duplicate entry in a database table. This issue is similar to 100059404 where case restores failed for the same reason. This issue was reported later for appliance restores (commonly referred to also as node restores) and requires a different solution.

JIRA: CFT-5965