Failed to create MView NH_GROUP_CONTENT_TYPES

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

Error: Unable to execute 'create materialized view NH_GROUP_CONTENT_TYPES'. 

Environment:
eHealth Version : 6.3.2.11 Operating System: windows 2008
Resolution:

Please follow below steps:

1. Copy below files in the mentioned location

(nh_group_all_members_fix.sql, 
nh_group_content_types_fix.sql, 
nh_group_content_types_undo.sql) into %NH_HOME%/oracle/sql

2. login to sqlplus
%NH_ORACLE_HOME%\bin\sqlplus %NH_USER%/%NH_USER%

3. Run script
@%NH_HOME%/oracle/sql/nh_group_all_members_fix.sql 
@%NH_HOME%/oracle/sql/nh_group_content_types_fix.sql


Additional Information:

Please refer to DE309187 for files location