Ansible Automation Platform 2.5 Installer fails at TASK [ansible.automation_platform_installer.automationgateway : Migrate data]

Issue

• Ansible Automation Platform installer fails at installer.automationgateway while configuring Gateway Node with the following error :

  TASK [ansible.automation_platform_installer.automationgateway : Migrate data] ***
  fatal: [controller.example.com -> gateway.example.com]: FAILED! => {"changed": false, "cmd": ["aap-gateway-manage", "migrate_service_data", "--username", "admin", "--merge-organizations", "true", "--api-slug", "controller"], "delta": "0:00:01.7xx9", "end": "2025-01-17 08:16:52.4xx3", "msg": "non-zero return code", "rc": 1, "start": "2025-01-17 08:16:50.6xx4", "stderr": "2025-01-17 08:16:52,091 INFO      ansible_base.lib.redis.client Removing setting cluster_error_retry_attempts from connection settings because its invalid for standalone mode
  2025-01-17 08:16:52,125 INFO      ansible_base.resources_api.rest_client Making get request to https://gateway.example.com:443/api/controller/v2/service-index/metadata/.
  Traceback (most recent call last):
  File \"/usr/lib/python3.11/site-packages/urllib3/connection.py\", line 174, in _new_conn
  conn = connection.create_connection(
  File \"/usr/lib/python3.11/site-packages/urllib3/util/connection.py\", line 95, in create_connection
  raise err
  File \"/usr/lib/python3.11/site-packages/urllib3/util/connection.py\", line 85, in create_connection
  sock.connect(sa)
  ConnectionRefusedError: [Errno 111] Connection refused
  
  During handling of the above exception, another exception occurred:
  
  Traceback (most recent call last):
   File \"/usr/lib/python3.11/site-packages/urllib3/connectionpool.py\", line 716, in urlopen
  httplib_response = self._make_request(
   File \"/usr/lib/python3.11/site-packages/urllib3/connectionpool.py\", line 404, in _make_request
  self._validate_conn(conn)
   File \"/usr/lib/python3.11/site-packages/urllib3/connectionpool.py\", line 1061, in _validate_conn
  conn.connect()
   File \"/usr/lib/python3.11/site-packages/urllib3/connection.py\", line 363, in connect
  self.sock = conn = self._new_conn()
   File \"/usr/lib/python3.11/site-packages/urllib3/connection.py\", line 186, in _new_conn
  raise NewConnectionError(
  urllib3.exceptions.NewConnectionError: <urllib3.connection.HTTPSConnection object at 0x7efxxxxe50>: Failed to establish a new connection: [Errno 111] Connection refused
  
  NO MORE HOSTS LEFT *************************************************************