ALERT: Some images may not load properly within the Knowledge Base Article. If you see a broken image, please right-click and select 'Open image in a new tab'. We apologize for this inconvenience.
How to fix a Oracle error ORA-20108 load_nh_date_time_dim
Article ID: 49756
Updated On:
Products
CA eHealth
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:
- Log into sqlplus
sqlplus $NH_USER/$NH_USER - Run the following commands from theSQL> prompt
set serveroutput on
Exec nh_reg_process.load_nh_date_time_dim; - 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:
Component:
Feedback
Yes
No
Powered by
