Error nhiPoller[Net] Pgm nhiPoller[Net]: Error reading elements from database.

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

Problem:

eHealth poller stops after the MTF file name is changed for an element via One Click Console.

Following errors can be seen in eHealth system.log file.

Monday, July 22, 2015 19:17:57 Error nhiPoller[Net] Pgm nhiPoller[Net]: Error reading elements from database.
Monday, July 22, 2015 19:17:58 Error nhiPoller[Live] Pgm nhiPoller[Live]: Error reading elements from database.

 

Environment:
The issue has been reported in different versions from eHealth 6.3.0.0 through to 6.3.1.02 installed on Windows, Unix or Linux systems.

 

Cause:
This poller crash is due to an issue in MTF update feature in eHealth One Click Console, which does not update the change in database.
 
Run the following command to verify the cause:
$NH_HOME/bin/sys/nhisql "select name, mtf_name, element_id from nh_element Where mtf_name not in (select name from nh_mtf)";
It should list elements for which MTF file name was changed.

 

Resolution:
The general solution is to find these elements and the changes made from from pollerAudit logs and then revert the changes.
 
Following is the command to revert MTF filename:
$NH_HOME/bin/sys/nhisql "update nh_element set mtf_name='ORIGINAL_MTF_NAME where name='CURRENT_MTF_NAME'";
 
Restart eHealth services, once the above commands are run successfully.
 
This issue is resolved in eHealth 6.3.1.03 release, and to avoid poller to crash again in future, please make the MTF file name changes via eHealth command line interface until you upgrade eHealth.