How to fix ORA-20000: index "EHEALTH"."NH_GROUP_ALL_MEMBERS_AS1_IX5" or partition

Products

• CA eHealth

Issue/Introduction

Description:

This article explains how to fix the error ORA-20000: index "EHEALTH"."NH_GROUP_ALL_MEMBERS_AS1_IX5" or partition.

This error can appear in the Statistics Index log like in this example:

Begin processing 11/20/2012 12:20:01 PM.
Error: Sql Error occurred during operation dbuAnalyzeSchemaStats
(ORA-20000: index "EHEALTH"."NH_GROUP_ALL_MEMBERS_AS1_IX5" or partitio).
End processing 11/20/2012 12:20:13 PM.
Scheduled Job ended at '11/20/2012 12:20:13 PM'.

Solution:

The solution is to run a query to rebuild the index.

1. Sign on to sql session as $NHUSER
   
   sqlplus $NH_USER/$NH_USER
   
   
2. Run the sql below to confirm the existence of NH_GROUP_ALL_MEMBERS_AS1_IX5
   
   SELECT index_name,partition_name,status
   FROM dba_ind_partitions
   WHERE index_name = NH_GROUP_ALL_MEMBERS_AS1_IX5 ;
   
   
3. Run the sql below to rebuild the index
   
   ALTER INDEX NH_GROUP_ALL_MEMBERS_AS1_IX5 REBUILD;
   
   
4. Exit from sqlplus
   
   exit
   
   
5. Rerun the stats index job to see if the error disappears

Environment

Release: LHDEVC99000-6.3-eHealth-Live Health Upgrade Elements
Component: