Knowledge Base
VPX_TASK table contains entries older than the vCenter Server database retention policy (2005293)
Symptoms
- VPX_TASK table entries older than [x] amount of days are being retained even after you change the database retention policy in vCenter under Administration > vCenter Server Settings > Database retention policy > Tasks Retained for [x] days.
- All VPX_TASK table entries have a task COMPLETE_TIME set to NULL.
Resolution
This issue occurs when the stored procedure cleanup_events_task_proc does not remove old entries that meet the above criteria. This results in undesired growth of the VPX_TASK table inside the vCenter Server database over time.
To resolve this issue, you must replace the existing stored procedure with the one provided in the attachments section. Choose the file that corresponds to your database type.
Note: This fix must be applied to any vCenter Server that is running a version earlier than 5.0 Update 1 that has not been upgraded following a major release. For example, upgrading from vCenter Server 4.x to 5.0 Update 1 recreates the stored procedure. However, upgrading from vCenter Server 5.0 to 5.0 Update 1 does not replace the stored procedure. It must be replaced manually.
For more information, see 
Replacing the Existing Statistics Rollup Stored Procedure (1001420).
Replacing the Existing Statistics Rollup Stored Procedure (1001420).Attachments
Request a Product Feature
To request a new product feature or to provide feedback on a VMware product, please visit the Request a Product Feature page.
|
|
