Statistics Index job failing

book

Article ID: 5753

calendar_today

Updated On:

Products

EHEALTH CA eHealth

Issue/Introduction

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

 

<Please see attached file for image>

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

Statistic Error.JPG

 

 

Attachments

1558707715102000005753_sktwi1f5rjvs16qt0.jpeg get_app