Deleting Corrupted KPI Definitions

Edit online

About this task

In rare cases, when you have initiated a deletion process of one or more KPI definitions using the Business Data or System Data pages and that process did not complete successfully, you might have some corrupted assets in the database. You can use the KPI definition deletion script to delete those corrupted KPI definitions and related KPI instances. The KPI definition deletion script uses the database configuration specified during the installation of the Analytic Engine, and cleans up any corrupted KPI assets found in the database.

Note: Please note that any KPI instances related to the corrupted KPI definitions will be deleted as well. Also, keep in mind that the KPI definition deletion script is not aware of cache, so it must not be used in a Terracotta cluster environment.

To run the KPI definition deletion script

Procedure

Enter one of the following at the command line:
  • (Windows) Optimize_directory \analysis\bin\cleanupKPIs.bat
  • (UNIX) Optimize_directory /analysis/bin/cleanupKPIs.sh
Important: UNIX users who receive a Java security exception when they run the cleanupKPIs.sh script must modify the script as follows: Delete the following line (-Djava.security.manager=''\) at this location in the script: 
$JAVA_HOME/bin/java\ $GLUE_OPTS\   
com.webmethods.optimize.cleanup.KPICleanup$