nhJoinCluster fails with ORA-00942, table or view does not exist

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

Description:

Issue: nhJoinCluster fails with ORA-00942, table or view does not exist

During the subsequent join, the following errors occurred:

04/25/10 21:24:21.374 [d,clc ] Calling refreshGroupPermissions 
04/25/10 21:24:22.280 [d,clc ] Enable fast refresh and trigger a complete refresh
Error: Database error: BEGIN nh_usercfg.enableFastRefresh; END; (database error: ORA-00942: table or view does not exist
ORA-06512: at "NHUSER.NH_USERC).
04/25/10 21:24:22.983 [d,clc ] ClcJoinClusterApp::exitCleanup called 
04/25/10 21:24:22.983 [d,clc ] ClcJoinClusterApp exited 
c ..... OK

Problem Ticket: PRD00049127

Solution:

  1. nhiDbTasks -recreateMViews capability.
    If at any point during upgrade or troubleshooting the fast refresh mviews need to recreated, then the following command can be used. It will drop and create, NH_GROUP_ALL_MEMBERS_AS1, NH_GROUP_ALL_MEMBERS_GM, NH_GROUP_CONTENT_TYPE nhiDbTasks -recreateMViews
    If ALL mviews need to be recreated, run the following, it will drop and create NH_USER_GROUP_PERMISSIONS in addition to the ones listed above.
    nhiDbTasks -recreateMViews all
    -------------------------------------------------------------------------------------------------------------------------------
    -------------------------------------------------------------------------------------
  2. While running nhConvertDb -undoConvert in releases 6.2.1 and higher, if you get a warning message as follows, "dropFastRefreshGroupMViews, failed to drop one or more fast refresh mview or mlog" Then, you need to check the associated error message and troubleshoot before retrying the convert. sql in the db, and check for following mview logs:
    MLOG$_NH_GROUP_MEMBERS, MLOG$_NH_GROUP, MLOG$_NH_ELEMENT, MLOG$_NH_ELEM_ASSOC using the following query,
    select log_table from user_mview_logs;
    If any of them exist, use the following sql to drop them.
    drop materialized view log on nh_Group_members;
    drop materialized view log on nh_group;
    drop materialized view log on nh_element;
    drop materialized view log on nh_elem_assoc
    Now check for mviews, using
    select mview_name from user_mviews;
    If any of, NH_GROUP_ALL_MEMBERS_GM, NH_GROUP_ALL_MEMBERS_AS1, NH_GROUP_CONTENT_TYPES exist, they must be dropped using,
    drop materialized view nh_group_all_members_gm;
    drop materialized view nh_group_all_members_as1;
    drop materialized view nh_group_content_types;

The issue documented above has been resolved in the following release(s):

     eHealth 6.2.1

eHealth Service Packs are available for download at: support.ca.com. Please review the README file for each Service Pack prior to installing. CA recommends that users always keep eHealth current by installing the latest Service Pack available.