Statistics Index job failing

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

Frequently getting Statistics Index job failing alerts in Front end one click console.

 

Statistic Error.JPG

Environment:
eHealth 6.3.0.04 D0 - Service Pack: 0 on windows 2008 (Distributed setup)4 pollers and 1 console
Resolution:

Statistic Error.JPG

 

=>Running the below command might fix the issue.

     %NH_HOME%/bin/sys/nhiDbTasks -recreateMViews 


=>Then review the Stats Index and Analyze database job logs

 

Additional Information: