Red Hat Satellite 6 installation fails with error 'pulpcore-manager migrate --noinput' returned 1 instead of one of [0]'

Issue

• Red Hat Satellite 6.11 installation on a fresh RHEL 8.6 server fails with the following error.

2022-08-12 12:45:41 [ERROR ] [configure] '/usr/sbin/foreman-rake db:migrate' returned 1 instead of one of [0]
2022-08-12 12:45:41 [ERROR ] [configure] /Stage[main]/Foreman::Database/Foreman::Rake[db:migrate]/Exec[foreman-rake-db:migrate]/returns: change from 'notrun' to ['0'] failed: '/usr/sbin/foreman-rake db:migrate' returned 1 instead of one of [0]
2022-08-12 12:45:48 [NOTICE] [configure] 1500 configuration steps out of 1630 steps complete.
2022-08-12 12:45:53 [ERROR ] [configure] 'pulpcore-manager migrate --noinput' returned 1 instead of one of [0]
2022-08-12 12:45:53 [ERROR ] [configure] /Stage[main]/Pulpcore::Database/Pulpcore::Admin[migrate --noinput]/Exec[pulpcore-manager migrate --noinput]/returns: change from 'notrun' to ['0'] failed: 'pulpcore-manager migrate --noinput' returned 1 instead of one of [0]