Old tasks records prior to the retention policy days are not being purged from VCDB

Products

• VMware vCenter Server

Issue/Introduction

Prevents pile up of task records in VCDB due to insufficient cleanup method.

Symptoms:
In the table VPX_TASK in vcdb, you will see task records prior to the retention policy days.

Environment

VMware vCenter Server 6.7.x

Cause

Insufficient cleanup method.

Resolution

This is a known issue. VMware is working on a solution.

Workaround:

1. Putty session to vCenter.
2. Download the attached file to /tmp/cleanup_tasks_PostgreSQL.sql available in the attached file. 
3. Run below command:

/opt/vmware/vpostgres/current/bin/psql -U postgres -d VCDB -f /tmp/cleanup_tasks_PostgreSQL.sql