To resolve this issue when there is a schema mismatch, restore the correct version of the vCenter Server database associated with the current build of vCenter Server.
To verify if there is a vCenter Server database schema mistmatch:
- Connect to the vCenter Server database using the SQL management tool.
- Run this query to list the rows in the VPX_Version table in the vCenter Server database:
Select * from VPX_Version
- Note the value in the the VERSION_VALUE field.
- Open the vpxd.log file and locate the initial header of the file. The header shows the current version of vCenter Server.
For example, the header appears similar to:
Section for VMware VirtualCenter, pid=4472, version=5.1.0, build=1235232, option=Release
- Compare the vCenter Server versions noted in Step 3 and Step 4. If the versions do not match, the the vCenter Server database is running an incorrect schema.
To upgrade the database schema to the correct version:
- Uninstall vCenter Server.
- Restore the vCenter Server database from a backup.
- Reinstall vCenter Server using the Use existing database option.