This is occuured when upgrade VCSA6.0 to VCSA 6.5 if vpostgress have customize DB

 

connect with VCDB

 

VMware Knowledge Base

 

run command

 

VCDB=# \dv

 

Check how many view item there , then cascade it.

 

Test to manually suppress VPXV_VMS view in VCDB

VCDB=#

VCDB=# DROP VIEW IF EXISTS VPXV_VMS;

ERROR:  cannot drop view vpxv_vms because other objects depend on it

DETAIL:  view "DCS_BV_VIEW3" depends on view vpxv_vms

HINT:  Use DROP ... CASCADE to drop the dependent objects too.

VCDB=# DROP VIEW IF EXISTS VPXV_VMS CASCADE;

NOTICE:  drop cascades to view "DCS_BV_VIEW3"

DROP VIEW

VCDB=# DROP VIEW VPXV_VMS;

ERROR:  view "vpxv_vms" does not exist

VCDB=# \q

root@VC [ /var/log/vmware/vpxd ]#