Knowledge Base

The VMware Knowledge Base provides support solutions, error messages and troubleshooting guides
 
Search the VMware Knowledge Base (KB)   View by Article ID
 

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.

This issue is resolved in vCenter Server 5.0 Update 1. You can download the latest update from the vSphere Download Center.

If you are unable to upgrade vCenter Server to 5.0 Update 1, you can replace the existing stored procedure with the one provided in the attachments section. Choose the file that corresponds to your database type.
Note: This work around 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 on replacing the statistics rollup stored procedure in Microsoft SQL Server or Oracle manually, see Replacing the Existing Statistics Rollup Stored Procedure (1001420).

See Also

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.

Feedback

  • 4 Ratings

Did this article help you?
This article resolved my issue.
This article did not resolve my issue.
This article helped but additional information was required to resolve my issue.
What can we do to improve this information? (4000 or fewer characters)
  • 4 Ratings
Actions
KB: