How to fix a Oracle error ORA-20108 load_nh_date_time_dim

Article Id: 49756
Status: Published
Updated On: 14-02-2018 08:04
Legacy Id: TEC567141
Products:
EHEALTH - MISC , CA eHealth Performance Management - Data Polling , CA eHealth Performance Management - Usage and Administration , DEVELOPER PROG , REMOTE POLLER
Issue/Introduction:

Description:

This error is seen in the system.log file, and also in the System Messages in OneClick for eHealth (OCE). A typical example is as follows.

Error: "Error Pgm plsql: File REGDATA load_nh_dt_tm_dim:Sql Error occurred during operation "ORA 20108:load_nh_date_time_dim ORA 20108:ORA 06512: at "EHEALTH NH_UTL" line 1"

Solution:

Error can be removed by running sql below:

  1. Log into sqlplus

    sqlplus $NH_USER/$NH_USER

  2. Run the following commands from theSQL> prompt

    set serveroutput on
    Exec nh_reg_process.load_nh_date_time_dim;

  3. Exit from sqlplus

    exit

If the statements above do not resolve the problem, please run the following two commands from command line.

nhTimeZoneConfig -action loadMappings
nhTimeZoneConfig -action addTimeZonesInUse

Environment:

Release: LHDEVC99000-6.3-eHealth-Live Health Upgrade Elements
Component: