Knowledge Base

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

Purging stats data fails in Oracle Database with a bind variable error (1012451)

Details

The purgeStatsData_oracle.sql script file, which is used for purging stats data, fails with the following error:

Bind Variable "01" is NOT DECLARED

Solution

You must replace the current stats data purging script with the new purging script. The new script is attached with this knowledge base article. Download the attached script file and save it in the following path:

<Installation_Directory>/vCenter-CB-Scripts/v0.0.0-v1.0.0/oracle/db-management

where <Installation_Directory> is the path of the folder in which the contents of the vCenter-CB-Scripts-1.0.0-175384.zip file are extracted.
You can now run this new script and provide the necessary inputs to purge the stats data. You do not have to restart any service after replacing this script.  

Keywords

stats data purging, purgeStatsData_oracle.sql

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

  • 1 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)
  • 1 Ratings
Actions
KB: