When trying to do an upgrade of vcenter appliance from 5.5 to 6.0 I get a number of errors
Failed to get server certificate for validation
Make sure that the sso service is started before continuing
Source vCenter Server schema validation found an issue.
Read the vcdb_req.err log file and address the issues found.
vCenterServer FQDN vCenter.XXXXX.XXXXX does not match DNS servers "" and ip addresses "" from SSO certificate
Examine the SSO certificate and make sure it is valid and point to vCenterServer FQDN.
At the end of /var/log/vmware/upgrade/vcdb_req.err it says :
ERROR ! Missing indexes: VPX_EVENT_ARG.PK_VPX_EVENT_ARG; Missing constraints: VPX_EVENT_ARG.PK_VPX_EVENT_ARG;;
Hi,
I had the same issue right now.
In our case, the following tables/indexed were affected:
1 [42000](50000) [Microsoft][SQL Server Native Client 10.0][SQL Server]ERROR ! Missing indexes: VPX_HIST_STAT1_96.IX_VPX_HIST_STAT1_96_TIME_ID; VPX_HIST_STAT1_96.PK_VPX_HIST_STAT1_96;
After some troubleshooting, we've found a solution.
Open the SQL Management Studio, navigate to the affected table and click Indexes.
Create a new Index, name it "PK_VPX_EVENT_ARG" and set the type to "Clustered"
Click "Add" and select EVENT_ID and ARG_ID
Click OK and repeat this procedure to all missing indexed.
Try to run the setup again.
Greetings
Falk
not sure about the other errors, but the DB one can be resolved with:
ALTER TABLE VPX_EVENT_ARG WITH NOCHECK ADD CONSTRAINT PK_VPX_EVENT_ARG PRIMARY KEY (EVENT_ID, ARG_ID);