"Missing indexes: VPX_EVENT_ARG,VPX_EVENT_ARG_EVENT_ID" migrating windows vCenter Server 5.5 to VCSA 6.x

Products

• VMware vCenter Server

Issue/Introduction

Symptoms:

• From the migration assistant logs, you see the below errors.

2019-03-19 09:43:28.500Z| migration-assistant-10964411| I: ParseErrorsWarningsFromPreUpgradeOutput: Error messages: Error: Source vCenter Server schema validation found an issue.
Resolution: Read the vcdb_req.err log file and address the issues found.

• In the vcdb_req.err.log,  you see similar to:

Error while executing .\Upgrade-v2013-to-v2015\mssql\validate_mssql.sql:202, reason: Cannot execute statement(rc=-1).
BEGIN
 DECLARE @err_msg VARCHAR(2000)
 DECLARE @err_msg_full VARCHAR(4000)
 DECLARE @verid INT

1 [42000](50000) [Microsoft][SQL Server Native Client 10.0][SQL Server]ERROR ! Missing indexes: VPX_EVENT_ARG.VPX_EVENT_ARG_F1; VPX_EVENT_ARG.VPX_EVENT_ARG_F2; VPX_EVENT_ARG.VPX_EVENT_ARG_F3; VPX_EVENT_ARG.VPXI_EVENT_ARG_EVENT_ID;

Environment

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

Resolution

To resolve this issue create the missing index values. 
 

1. Backup the vCenter Database, for more information, see 2091961.
2. Stop the vCenter Services.
3. Login to SQL Management Studio and select VCDB database
4. Right click on 'VCDB' database and click on 'New Query'
5. In the query field paste the below queries

 

CREATE INDEX VPX_EVENT_ARG_F1 ON VPX_EVENT_ARG(OBJ_TYPE);
GO
create index VPX_EVENT_ARG_F2 on VPX_EVENT_ARG (ALARM_ID);
GO
create index VPX_EVENT_ARG_F3 on VPX_EVENT_ARG (SCHEDULEDTASK_ID);
GO
create index VPXI_EVENT_ARG_EVENT_ID on VPX_EVENT_ARG (EVENT_ID);
GO

 

5. Press F5 or click Execute from the Menu bar, check whether the query is executed successfully.

Note: The execution will take sometime

6. Once the query is executed start the vCenter services
7. Proceed with vCenter Server upgrade/migration.