Symptom
FMC Restore is stuck in mysql restore completed stage.
Conditions
Issue is seen with new vFMC as well with same backup file
Stuck this point while restore
Fri Jul 28 08:07:11 2023 Restoring all MySQL user credentials.
Fri Jul 28 08:07:11 2023 Restoring all MySQL user credentials completed.
Workaround
++Edit /var/sf/lib/perl/5.24.4/SF/System.pm script in FMC.
we need to comment out this line SF::System::Privileged::rm(filename => $file_path); from SF::System::restoreVaultSecrets()
(line 13380, may vary based on builds)
++ Save the file and exit and Restore using backup
++After restore completed, we need to delete the json files from /etc/sf/vault/backup
rm -rf /etc/sf/vault/backup/*.json
++Revert the changes in script. We may have to perform same WA until upgrading device to fixed version to restore FMC
