Adding a secondary hosted-engine host fails with error "Failed to fetch hosted engine configuration file"

Issue

• Adding a secondary hosted-engine host fails with the error Failed to fetch hosted engine configuration file and the Ansible logs have the below messages:

2023-03-13 10:03:08 GST - fatal: [myfirsthost.example.com]: UNREACHABLE! => {"changed": false, "msg": "Data could not be sent to remote host \"myfirsthost.example.com\". Make sure this host can be reached over ssh: ssh: Could not resolve hostname myfirsthost.example.com: Name or service not known\r\n", "unreachable": true}