Failed to create MView NH_GROUP_CONTENT_TYPES

Products

• CA eHealth

Issue/Introduction

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