"ERROR: must be owner of relation vpx_sn_vdevice_backing_rel_seq" error vCenter Server Appliance 6.x

Products

• VMware vCenter Server

Issue/Introduction

Symptoms:

• The upgrade/migration fails with the error:

VMware VirtualCenter failed firstboot. Database in-place upgrade failed. Please see vcdb_inplace.err and vcdb_inplace.out for details.
Resolution
Please search for these symptoms in the VMware Knowledge Base for any known issues and possible resolutions. If none can be found, collect a support bundle and open a support request.

• In firstbootStatus.json, you see entry similar to:

 

"failedSteps": "vpxd_firstboot"

• In vpxd_firstboot.py_####_stdout.log and vcdb_inplace.err you see entry similar to:

ERROR: must be owner of relation vpx_sn_vdevice_backing_rel_seq

 

Note: 

• vCenter Server Appliance - Firstboot logs are located in the /var/log/firstboot directory.
• vCenter Server on Windows - Firstboot logs are located in the VMware-VCS-logs-<year><month><day><hour><minute><second>.zip/vcs_logs/uninstall directory or the VMware-VCS-logs-<year><month><day><hour><minute><second>/vcs_logs/uninstall/<vCenter Hostname><year><month><day><hour><minute><second>.zip/ProgramData/VMware/vCenterServer/logs/firstboot directory.

Environment

VMware vCenter Server 7.0.x
VMware vCenter Server Appliance 6.0.x
VMware vCenter Server Appliance 6.5.x
VMware vCenter Server Appliance 6.7.x

Cause

The issue occurs when the db schema is not owned by the vCenter database user (vc).

Resolution

To resolve this issue, the db schema owner must be changed to the default vCenter Server Appliance database user (vc).

1. Connect to the vCenter Server Appliance using an SSH session or into the Bash shell
2. Using WinSCP, copy the attached fix_sequence_owners.sh to the /tmp/ directory. 
3. Run this command: 

chmod +x /tmp/fix_sequence_owners.sh

4. To apply the required database permissions changes, run this command:

sh /tmp/fix_sequence_owners.sh

Additional Information

• To learn more about firstboot issues see: Understanding and Troubleshooting vCenter Server and vCenter Server Appliance 6.7 Firstboot Install/Deployment, Upgrade, or Migration Failures​.
• To collect a log bundle or review log files for a vCenter Server Appliance install, upgrade, or migration issues reference Triaging a vCenter Server Appliance 6.0 installation, upgrade, or migration (6.0 U2m) failure.  The relevant logs will be on the newly deployed appliance.  
• To collect a log bundle or review log files for a vCenter Server on Windows install or upgrade issues reference Triaging a vCenter Server 6.0 installation or upgrade failure.