Pre-upgrade check failed during vCenter server upgrade from 7.0.3.01800 to 8.0.2-23504390 with error "Source vCenter Server schema validation found an issue: 3 [P0001]"

Products

• VMware vCenter Server 8.0

Issue/Introduction

• Pre-upgrade check failed during vCenter server upgrade from 7.0.3.01800 to 8.0.2-23504390:

Source vCenter Server schema validation found an issue: 3 [P0001](1) ime;vpx_new_sample_time3.time_id;vpx_new_sample_time4.partition_index;vpx_new_sample_time4.rollup_counter;vpx_new_sample_time4.sample_interval;vpx_new_sample_time4.sample_time;vpx_new_sample_time4.time_id;vpx_new_task.activation_id;vpx_new_task.alarm_id;vpx_new_task.cancellable;vpx_new_task.cancelled;vpx_new_task.change_tag_id;vpx_new_task.complete_state;vpx_new_task.complete_time;vpx_new_task.computeresource_id;vpx_new_task.datacenter_id;vpx_new_task.description;vpx_new_task.descriptionid;vpx_new_task.entity_id;vpx_new_task.entity_name;vpx_new_task.entity_type;vpx_new_task.error_data;vpx_new_task.event_chain_id;vpx_new_task.folder_id;vpx_new_task.host_id;vpx_new_task.locked_data;vpx_new_task.name;vpx_new_task.parent_task_id;vpx_new_task.progress;vpx_new_task.queue_time;vpx_new_task.reason_data;vpx_new_task.resourcepool_id;vpx_new_task.result_data;vpx_new_task.root_task_id;

Environment

vCenter 7.x

vCenter 8.x

Cause

Error was reported due to extra tables or columns present in VCDB of vCenter server.

Below extra tables might exist in VCDB:

vpx_new_sample

vpx_new_task

vpx_hist_stat

vpx_new_entity

vpx_new_event

Resolution

Drop extra tables using below steps from VCDB and upgrade vCenter server:

1. Take vCenter server Backup and snapshot
2. Stop vpxd service
   
        service-control --stop vmware-vpxd
   
   
3. Connect to VCDB
   
      /opt/vmware/vpostgres/current/bin/psql -d VCDB -U postgres
   
   
4. Drop extra tables from VCDB found in error message:

DROP Table vpx_hist_stat_tmp;

DROP Table vpx_new_entity_last_event;

DROP Table vpx_new_task;

DROP Table vpx_new_event;

DROP Table vpx_new_event_arg;

DROP Table vpx_new_sample_time1;

DROP Table vpx_new_sample_time2;

DROP Table vpx_new_sample_time3;

DROP Table vpx_new_sample_time4;

 

     5. Start vpxd service

            service-control --start vmware-vpxd

     6. Attempt vCenter upgrade