Description:
Summary: This article explains how to address a corrupt APM database index issue in Oracle (with the error message 'index <index name>' or partitionof such index is in unusable state'.)
Solution:
Enterprise Manager logs for the Tim Collection or Stats Aggregation Service show that update or insert statements are failing with the error message:
The error occurs in an Oracle database and appears in the logs as:
[ERROR] [Thread-36][Manager.com.timestock.tess.services.processors.StatsAggregator]
[DailyStatsPool.Thread5] [com.timestock.tess.util.TessLogger] Insert/updates failed for table
com.timestock.tess.data.objects.StatsTranSetUserGroupDaily java.sql.SQLException: ORA-01502: index '<index name>' or partition of such index is in unusable state
Take the following steps to correct this error:
Enterprise Manager logs should no longer contain this error. If errors persist, contact CA APM Support for further assistance.