Statistics Index Failure in eHealth system log

Document ID : KB000029201
Last Modified Date : 14/02/2018
Show Technical Document Details

Issue:

There are a couple of reasons why you would get Statistics Index failure. In this knowledge base document we will focus only on one cause and its solution. The error looks like this and can be found in the system.log:

Warning: Failed to uniquely index nh_stats0_123456789. 
Error: Failed to uniquely index nh_stats0_123456789. 
Sql Error occurred during operation dbuRebuildIndexes0123 (ORA-01418: specified index does not exist). 
End processing 01/27/2015 08:24:30 AM. 

Environment: 

6.3.xx
All platforms

Cause:

The datafiles that make up the NH_INDEX01 tablespace have reached their maximum size (32 GB) and can no longer autoextend.

Resolution/Workaround:

Add an additional data file to the tablespace. To add an additional datafile, run the following command:

nhManageDbSpace -add -newPath [PATH] -tablespace NH_INDEX01 -size 2000M

where [Path] is the first portion of the location of the database. For example, if your database is saved to /oradata/oradata/EHEALTH, the command you would use to add a datafile to NH_INDEX01 would be:

nhManageDbSpace -add -newPath /oradata -tablespace NH_INDEX01 -size 2000M

The nhManageDbSpace command is hard coded to add /oradata/{Oracle SID} to any [PATH] you provide.