Remote Execution job fails with error "no such identity: .ssh/id_rsa_foreman_proxy" in Red Hat Satellite 6

Issue

• When executing an ansible-based remote execution job, It fails with the following error:

  fatal: [hostname.example.com]: UNREACHABLE! => {"changed": false, "msg": "Failed to connect to the host via ssh: no such identity: .ssh/id_rsa_foreman_proxy: 
  No such file or directory\r\nPermission denied (publickey,gssapi-keyex,gssapi-with-mic,password,keyboard-interactive).", "unreachable": true}