hosted-engine restore fails: Failed to fetch value of DisableFenceAtStartupInSec from DB.

Issue

When testing the restore of the hosted-engine with the command:

# hosted-engine --deploy --restore-from-file=engine-backup-201910111604.tar.gz

the restore constantly fails with the error below:

2019-10-11 15:24:03,667+0200 ERROR otopi.ovirt_hosted_engine_setup.ansible_utils ansible_utils._process_output:98 fatal: [host.example.com]: FAILED! => {"changed": true, "cmd": ["engine-config", "-s", "DisableFenceAtStartupInSec=86400"], "delta": "0:00:00.854120", "end": "2019-10-11 15:24:02.509858", "msg": "non-zero return code", "rc": 1, "start": "2019-10-11 15:24:01.655738", "stderr": "", "stderr_lines": [], "stdout": "Failed to fetch value of DisableFenceAtStartupInSec from DB. The column name default_value was not found in this ResultSet.", "stdout_lines": ["Failed to fetch value of DisableFenceAtStartupInSec from DB. The column name default_value was not found in this ResultSet."]}
2019-10-11 15:24:12,142+0200 ERROR otopi.ovirt_hosted_engine_setup.ansible_utils ansible_utils._process_output:98 fatal: [host.example.com]: FAILED! => {"msg": "The task includes an option with an undefined variable. The error was: 'LOCAL_VM_DIR' is undefined\n\nThe error appears to have been in '/usr/share/ovirt-hosted-engine-setup/ansible/get_local_vm_disk_path.yml': line 2, column 3, but may\nbe elsewhere in the file depending on the exact syntax problem.\n\nThe offending line appears to be:\n\n---\n- name: Find the local appliance image\n  ^ here\n"}
2019-10-11 15:24:13,050+0200 ERROR otopi.context context._executeMethod:152 Failed to execute stage 'Closing up': Failed executing ansible-playbook
2019-10-11 15:24:54,813+0200 ERROR otopi.plugins.gr_he_common.core.misc misc._terminate:248 Hosted Engine deployment failed: please check the logs for the issue, fix accordingly or re-deploy from scratch.