Avamar: Upgrade to 19.10 Fails with Restore Postgres Databases After Upgrade

• Avamar upgrade fails with Restore Postgres databases after upgrade.
• In the workflow.log, we have messages:

Some Xml values in mcserver.xml is empty - operation failed.

# get necessary values from mcserver.xml for restore scripts.
hfsportValue = get_mc_preference('hfsport')
hfsaddrValue = get_mc_preference('hfsaddr')
$hfsaddrFQDN = get_mc_preference('local_hfsaddr')

1. Log in to the Avamar server using SSH as admin.
2. Switch to the root user:

su -

3. Go to the upgrade's workflow directory:

cd /data01/avamar/repo/temp/<<Upgrade Package Name>>/tmp/

4. Confirm that the sample errors below are found in the workflow.log (use less or tail to browse the log):

2024-09-03 14:13:58 (+0200) 47012260182700 INFO: ---------- BEGIN system.avamar.database.restore::do ----------
2024-09-03 14:13:58 (+0200) 47012260182700 INFO: mccipher_key_need_upgrade = false
2024-09-03 14:13:58 (+0200) 47012260182700 INFO: mccipher_key_need_upgrade was set already! Can't re-set it.
2024-09-03 14:13:58 (+0200) 47012260182700 INFO: system_avamar_database_restoreskip=
2024-09-03 14:13:59 (+0200) 47012260182700 INFO: >>> [make_temp_script] 222 very_current_user=root, as_user=, ssh command is: (rpm -q dpnserver --last | head -1) >/usr/local/avamar/var/run_command-sysout.12721.47012260182700 2>&1
2024-09-03 14:13:59 (+0200) 47012260182700 INFO: >>> [make_temp_script] 222 very_current_user=root, as_user=admin, ssh command is: (/usr/local/avamar/bin/avhostname -f) >/usr/local/avamar/var/run_command-sysout.12721.47012260182700 2>/usr/local/avamar/var/run_command-syserr.12721.47012260182700
2024-09-03 14:13:59 (+0200) 47012260182700 INFO: - - - - - - - BEGIN(output) - - - - - - -
2024-09-03 14:13:59 (+0200) 47012260182700 INFO: <<Hostname of Avamar server>>
2024-09-03 14:13:59 (+0200) 47012260182700 INFO: - - - - - - - END
2024-09-03 14:13:59 (+0200) 47012260182700 INFO: "/usr/local/avamar/bin/avhostname -f", exit status=0 (success)
2024-09-03 14:13:59 (+0200) 47012260182700 INFO: Report home message: 2024-09-03 14:13:59 +0200|<<Hostname of Avamar server>>|19.10.0-166|AvamarUpgrade|19.10.0.166|/space/avamar/repo/temp/AvamarUpgrade-19.10.0-166.avp_1725353008519/tmp|system.avamar.database.restore|Restore Postgres databases after upgrade. (109 of 161)|ERROR: System::Avamar::Database::Restore::Task::get_mc_preference  Some Xml values in mcserver.xml is empty - operation failed
2024-09-03 14:13:59 (+0200) 47012260182700 ERROR: Some Xml values in mcserver.xml is empty - operation failed
2024-09-03 14:14:00 (+0200) 47012260182700 INFO: post: Some Xml values in mcserver.xml is empty - operation failed
<<Some output is omitted>>
2024-09-03 14:14:00 (+0200) 47012260182700 INFO: ---------- END System::Avamar::Database::Restore::Task::get_mc_preference ------------

5. Go to the mcserver.xml file directory:

cd /usr/local/avamar/var/mc/server_data/prefs/

6. Grep or check the below values as one or more is blank:

<entry key="hfsport" value="27000" />
<entry key="local_hfsaddr" value="<<<Avamar shortname>>>" />
<entry key="hfsaddr" value="<<<Avamar FQDN>>>" />

7. Take a copy of the mcserver.xml file for backup:

cp -p mcserver.xml x-mcserver.xml-bkup

8. Edit the mcserver.xml using vi or other methods to add the missing values.
9. Go back to the AVI and retry the failed task.