Unable to generate report on groups

Products

• EHEALTH
• CA eHealth

Issue/Introduction

Unable to generate report on groups. Getting below error while selecting groups.

ORA-00942: table or view does not exist error 

Environment

eHealth 6.3.2.11 on Rhel 6.1( Distributed)

Resolution

 Run the below command to fix the issue. 

=>$NH_HOME/bin/sys/nhiDbTasks -recreateMViews 
 

  Now we can able to report on groups