Unable to access one click and web console

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

When trying to access one click console, getting below error.

Database error: ora-04063:package body "EHEALTH.NH_USER_ACCESS" has errors

call nh_user_access.set_current_user

Environment:
eHealth version: 6.3.2.12 D0 on windows 2008 R21 Console server 4 Remote Pollers
Cause:
The eHealth  database conversion failed.
 
According to Server_Process.log the lot of eHealth processes are crashed.
 
02/07/2017 17:42:43 Program exited: "E:/ehealth/bin/sys/nhiMsgServer", pid = 1348, started = 02/07/2017 17:41:43.
02/07/2017 17:44:47 Program exited: "E:/ehealth/bin/sys/nhiRmtOut", pid = 2640, started = 02/07/2017 17:43:55.
02/07/2017 17:44:48 Program exited: "E:/ehealth/bin/sys/nhiMsgProxySvr -Djava.util.logging.config.file=sys/msgProxy.logging", pid = 4184, started = 02/07/2017 17:44:41.
02/07/2017 17:44:48 Program exited: "E:/ehealth/bin/sys/nhiRftOut", pid = 4328, started = 02/07/2017 17:43:55.
02/07/2017 17:44:48 Program exited: "E:/ehealth/bin/sys/nhiRftIn", pid = 4740, started = 02/07/2017 17:43:55.
02/07/2017 17:44:49 Program exited: "E:/ehealth/bin/sys/nhiCtlVoice -start ALL_EH", pid = 5308, started = 02/07/2017 17:44:46.
02/07/2017 17:44:49 Program exited: "E:/ehealth/bin/sys/nhiRmtIn", pid = 7172, started = 02/07/2017 17:43:55.
02/07/2017 17:44:49 Program exited: "E:/ehealth/bin/sys/nhiArControl", pid = 7416, started = 02/07/2017 17:44:11.
02/07/2017 17:44:50 Program exited: "E:/ehealth/bin/sys/nhiDbServer", pid = 7988, started = 02/07/2017 17:43:50.
02/07/2017 17:46:54 Program exited: "E:/ehealth/bin/sys/nhiMsgServer", pid = 964, started = 02/07/2017 17:45:55.
02/07/2017 17:50:21 Program exited: "E:/ehealth/bin/sys/nhiCfgServer", pid = 7324, started = 02/07/2017 17:48:04.
02/07/2017 17:52:20 Program exited: "E:/ehealth/bin/sys/nhiCfgServer", pid = 9444, started = 02/07/2017 17:50:59.
02/07/2017 17:54:02 Program exited: "E:/ehealth/bin/sys/nhiCfgServer", pid = 5860, started = 02/07/2017 17:52:43.
 
According to system.log the eHealth Server crushed. 
 
---------------------Starting eHealth @ 02/08/2017 13:43:00---------------------
Wednesday, February 08, 2017 01:43:08 PM System Event nhiCfgServer Server started successfully.
Wednesday, February 08, 2017 01:43:25 PM  Host frampd22: Pgm nhiArControl: Controller has started on system "frampd22". Product version is 6.3.2.12.2205..
Wednesday, February 08, 2017 01:43:59 PM  Host frampd22: Pgm nhiArControl: AR License information received from Response Server: AgentLicenses: 1000000   AgentLicenseExpire: 12/31/2035 18:29:59   TSAgentLicenses: 1000000   TSAgentLicenseExpire: 12/31/2035 18:29:59..
Wednesday, February 08, 2017 01:44:02 PM  Pgm nhiLiveExSvr: Live Exceptions server initialization complete (LiveExceptions Server).
Wednesday, February 08, 2017 01:44:03 PM  Pgm nhiLiveExSvr[Traps]: Live Exceptions server initialization complete (LiveExceptions Trap Handler).
Wednesday, February 08, 2017 01:44:03 PM Warning nhiCfgServer Pgm nhiCfgServer: Error reading (possibly missing) MTF 'mib2-nu-v2c-hs-IF-20.mtf', corresponding elements will not be polled.
Wednesday, February 08, 2017 01:44:03 PM Warning nhiCfgServer Pgm nhiCfgServer: Error reading (possibly missing) MTF 'mib2-nu-v2c-hs-IF-20.mtf', corresponding elements will not be polled.
Wednesday, February 08, 2017 01:44:04 PM Warning nhiCfgServer Pgm nhiCfgServer: Error reading (possibly missing) MTF 'mib2-nu-v2c-hs-IF-20.mtf', corresponding elements will not be polled.
Wednesday, February 08, 2017 01:44:04 PM Warning nhiCfgServer Pgm nhiCfgServer: Error reading (possibly missing) MTF 'mib2-enet-fd-nu-v2c-hs-IF-20.mtf', corresponding elements will not be polled.
Wednesday, February 08, 2017 01:44:04 PM Warning nhiCfgServer Pgm nhiCfgServer: Error reading (possibly missing) MTF 'mib2-lan-fd-nu-v2c-IF-640.mtf', corresponding elements will not be polled.
Wednesday, February 08, 2017 01:44:06 PM Warning nhiCfgServer Pgm nhiCfgServer: Call 'cdbBeginTrans' to database API failed.
Wednesday, February 08, 2017 01:44:06 PM Error nhiCfgServer Pgm nhiCfgServer: Ok.
Wednesday, February 08, 2017 01:44:06 PM Internal Error nhiCfgServer Pgm nhiCfgServer: Expectation for 'No' failed (Unable to complete transaction.  Configuration rolled back in file ../CfgServer.C, line 1715). (cu/cuAssert)
Wednesday, February 08, 2017 01:44:10 PM Error nhiCfgServer Pgm nhiCfgServer: Unable to open dci file 'E:/ehealth/tmp/Sync3' (errno = 2).
 
According the query below: 
E:\ehealth\bin\sys>nhisql "select table_name from user_tables where table_name like '%USER%'" 
BK_NH_VC_CONTAINERUSER 
NH_USER_GROUP_PERMISSIONS 
NH_USER_PASSWD_BACKUP 
NH_VC_CONTAINERUSER 
 
the tables like
NH_USER 
NH_USER_CFG_GROUPLIST 
NH_USER_CFG_GROUP 
NH_USER_ROLE 
NH_USER_CFG 
 
are not created during installation.
Resolution:

Destroy and Re-create Database by using below commands

 

1. Logon to the eHealth system as $NH_USER.

2. cd to the $NH_HOME directory

3. If on Unix, source the nethealthrc.csh

4. Stop the eHealth server:

    nhServer stop

5. Unix users, switch to the 'root' user

6. Make a backup copy of the LCF file, which is located in $NH_HOME/oracle/database/ and has the naming format "<HOSTNAME>_<ORACLE_SID>.lcf" 

For example, run this command:
   cp /opt/eHealth/myServer_EHEALTH.lcf /opt/eHealth/myServer_EHEALTH.lcf.ORIG

7. Run the following command: 

     nhDestroyDb -s EHEALTH

8. (Still as the Root user) Run the following command: 

     nhCreateDb -i <LCF file>

where <LCF file> is the file saved in step 6.

 

=>Now load the successful latest backup by using below command.

 

nhLoadDb -p $NH_HOME/db/save/myDb.tdb

 Restart the eHealth server: nhServer start

Additional Information:

Refer Tech Doc:TEC518871

Defect DE277498