Cannot see resource "NewgGoup" when creating Trend Reports

Document ID : KB000101491
Last Modified Date : 26/06/2018
Show Technical Document Details
Issue:

1) From the CA-ehealth console create a new "Groups" (testAddGroup)
2) Assign several elements to this new “Groups”


 ehealth Consol

3) From the CA-ehealth Web Interface , select the tab “Run Report” and Try to define a "Top N"
    or "Trend Reports" by selecting the subject type “Group” and the adequate technology with the
    elements of the group.

eHealth Web Interface

=> The new “Group” (testAddGroup) doesn’t appear in the “Groups” listbox .

Environment:

CA-ehealth Version 6.3.x
All platform 

 

Cause:

Ehealth Web Interface uses materialized views to build the help screens for creating reports.
 A materialized view is a database object that contains the results of a query, and sometimes
 that view is corrupted.

Resolution:

Recreate the materialized views allows to fix the issue
  - $NH_HOME/bin/sys/nhiDbTasks -recreateMViews (Unix)
  - %NH_HOME%/bin/sys/nhiDbTasks -recreateMViews (Windows)