VMware Cloud Community
PhilMSW
Contributor
Contributor

Upgrade from vcenter appliance 5.5.0 to 6.0 database error

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;;

Reply
0 Kudos
2 Replies
photofalk
Enthusiast
Enthusiast

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

Reply
0 Kudos
admin
Immortal
Immortal

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);

Reply
0 Kudos