This article will provide a method to remove the stale entries for the stale tag associations for the obsolete/deleted objects from vCenter database (vPostgres)
yyyy-mm-ddThh:mm:ss error vpxd[51116] [Originator@6876 sub=Authorize opID=########-####-####-####-########3595 Authz-4e] MoRef: vim. VirtualMachine:vm -< id> not found. Error: N5Vmomi5Fault21ManagedObjectNotFound9ExceptionE(Fault cause: vmodl. fault.ManagedObjectNotFound
yyyy-mm-ddThh:mm:ss error vpxd[60251] [Originator@6876 sub=Authorize opID=########-####-####-####-########7956 Authz-7f] MoRef: vim.dvs.DistributedVirtualPortgroup:dvportgroup -< id> not found. Error: N5Vmomi5Fault21ManagedObjectNotFound9ExceptionE(Fault cause: vmodl.fault.ManagedObjectNotFound
yyyy-mm-ddThh:mm:ss error vpxd[60251] [Originator@6876 sub=Authorize opID=########-####-####-####-########7956 Authz-7f] MoRef: vim. StoragePod:group-p<id> not found. Error: N5Vmomi5Fault21ManagedObjectNotFound9ExceptionE(Fault cause: vmodl. fault.ManagedobjectNotFound
yyyy-mm-ddThh:mm: ss error vpxd[60251] [Originator@6876 sub=Authorize opID=########-####-####-####-########7956 Authz-7f] MoRef: vim.ClusterComputeResource:domain-c<id> not found. Error: N5Vmomi5Fault21ManagedObjectNotFound9ExceptionE(Fault cause: vmodl. fault.ManagedObjectNotFound
yyyy-mm-ddThh:mm:ss error vpxd[7FB3F3AF6700] [Originator@6876 sub=Authorize opID=########-####-####-####-########976d Authz-4] MoRef: vim. HostSystem:host -< id> not found. Error: N5Vmomi5Fault21ManagedobjectNotFound9ExceptionE(vmodl. fault.ManagedObjectNotFound)
yyyy-mm-ddThh:mm: ss error vpxd[48210] [Originator@6876 sub=Authorize opID=########] MoRef: vim.Datastore:datastore -< id> not found. Error: N5Vmomi5Fault21ManagedObjectNotFound9ExceptionE(Fault cause: vmodl. fault.ManagedobjectNotFound
yyyy-mm-ddThh:mm:ss error vpxd[11809] [Originator@6876 sub=Authorize opID=########-####-####-####-########ecb4 Authz-4f] MoRef: vim.Datacenter:datacenter -< id> not found. Error: N5Vmomi5Fault21ManagedobjectNotFound9ExceptionE(Fault cause: vmodl. fault.ManagedObjectNotFound
Note: The preceding log excerpts are only examples. Date, time, and environmental variables may vary depending on the environment.
VMware vCenter Server 8.0.x
VMware vCenter Server 7.0.x
VMware vCenter Server Appliance 6.7.x
VMware vCenter Server Appliance 6.5.x
chmod +x tags_delete_job_all.sh
./<directory>/tags_delete_job_all.sh
The deleted information can be found under /var/log/vmware/vpxd-svcs/tagging_cron.log