Ansible Automation platform upgrade to 2.3 fails with error column main_project.signature_validation_credential_id does not exist

Issue

• I am currently upgrading our environments from AAP 2.2 to AAP 2.3. In one environment the Database Migration Task fails in the middle of the installation. But I am not able to tell what exactly went wrong.

• Ansible Automation platform upgrade to 2.3 fails with the following error.

  TASK [ansible.automation_platform_installer.automationcontroller : Migrate the database schema (may take awhile when upgrading).] ***
  [0;36mskipping: [d100stulxanst12.d100.intern] => {"changed": false, "skip_reason": "Conditional result was False"}[0m
  [0;36mskipping: [d100stulxanst13.d100.intern] => {"changed": false, "skip_reason": "Conditional result was False"}[0m
  [0;31mfatal: [d100stulxanst11.d100.intern]: FAILED! => {"changed": true, "cmd": ["awx-manage", "migrate", "--noinput"], "delta": "0:00:04.561692", "end": "2023-04-04 10:26:19.561681", "msg": "non-zero return code", "rc": 1, "start": "2023-04-04 10:26:14.999989", "stderr": "Traceback (most recent call last):\n  File \"/var/lib/awx/venv/awx/lib64/python3.9/site-packages/django/db/backends/utils.py\", line 84, in _execute\n    return self.cursor.execute(sql, params)\npsycopg2.errors.UndefinedColumn: column main_project.signature_validation_credential_id does not exist\nLINE 1: ..._cache_timeout\", \"main_project\".\"allow_override\", \"main_proj...\n