This issue is resolved when the source vCenter version is 8.0.2.0, also available as a part of VCF 5.1 BoM.
To recover from this issue, vCenter needs to be recovered from the backup. Please refer to Restore vCenter Server from a File-Based Backup for more information on how to restore vCenter from backup.
As a workaround, follow the below steps.
Check if vCenter is already upgraded to the target by logging into the vCenter VAMI page:
https://<VC_FQDN>:5480
Retry the upgrade from SDDC Manager. The upgrade should skip the stages after pre-validation until installed, resume from post-validation, and complete successfully.
If we continue to run into the same error, proceed with the following steps:
Download the relevant vCenter Patch ISO from customer connect: https://my.vmware.com/group/vmware/patch
Note: Alternatively, you can acquire the ISO from the NFS Mount on the SDDC Manager.
Upload the ISO to a non-vSAN datastore that the ESXi host (where the vCenter VM resides) can access.
Login to the vCenter vSphere UI > Navigate to the vCenter VM > Edit Settings > CD/DVD Drive > Datastore ISO > Click on the datastore and select the ISO > Then hit the connect checkbox.
Once the ISO has been mounted onto the vCenter VM, SSH into the vCenter with the root user.
In the appliance shell (not Bash Shell) run the following commands:
software-packages unstage
software-packages stage --iso --acceptEulas
software-packages install --staged --acceptEulas
Note: Do not reboot the vCenter after the update completes.
Once the patch completes successfully, go back into the SDDC manager and re-try the upgrade, which should complete successfully.