Statistics Index job failing

Products

• CA eHealth

Issue/Introduction

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

 

<Please see attached file for image>

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

Statistic Error.JPG