Upgrade to Red Hat Satellite 6.10 fails at db:seed step with error "ActiveRecord::RecordInvalid: Validation failed"

Issue

• While upgrading to Red Hat Satellite 6.10, It fails at the following step.

  2021-12-28 03:33:48 [NOTICE] [configure] 1250 configuration steps out of 2203 steps complete.
  2021-12-28 03:34:08 [NOTICE] [configure] 1500 configuration steps out of 2209 steps complete.
  2021-12-28 03:37:22 [ERROR ] [configure] /Stage[main]/Foreman::Database/Foreman::Rake[db:seed]/Exec[foreman-rake-db:seed]: Failed to call refresh: '/usr/sbin/foreman-rake db:seed' returned 1 instead of one of [0]
  2021-12-28 03:37:22 [ERROR ] [configure] /Stage[main]/Foreman::Database/Foreman::Rake[db:seed]/Exec[foreman-rake-db:seed]: '/usr/sbin/foreman-rake db:seed' returned 1 instead of one of [0]
  2021-12-28 03:37:22 [NOTICE] [configure] 1750 configuration steps out of 2209 steps complete.
  2021-12-28 03:37:23 [NOTICE] [configure] 2000 configuration steps out of 3013 steps complete.
  

• Running the foreman-rake db:seed --trace command manually would result in reporting the following types of error messages.

  ActiveRecord::RecordInvalid: Validation failed: Domains expecting domains used by hosts or inherited (check mismatches report)
  
  ActiveRecord::RecordInvalid: Validation failed: Locations expecting locations used by hosts or inherited (check mismatches report)
  
  ActiveRecord::RecordInvalid: Validation failed: Environments expecting environments used by hosts or inherited (check mismatches report)
  
  ActiveRecord::RecordInvalid: Validation failed: Taxonomy|Capsules expecting capsules used by hosts or inherited (check mismatches report)
  
  ActiveRecord::RecordInvalid: Validation failed: Ptables expecting ptables used by hosts or inherited (check mismatches report).