No Data in eHealth Reports

Document ID : KB000045236
Last Modified Date : 14/02/2018
Show Technical Document Details
Issue:
 
eHealth is not collecting data for the elements.
Pgm nhiPoller[Net]: Unable to add 'network element' data to the database, dropping this poll
 
Environment:
  
eHealth 6.3.2.12 on Windows 2008
 
 
Cause:
 
Message Pgm nhiPoller[Net]: Sql Error occurred during operation: 'ORA-03149: Invalid Oracle error code '; possible problem data is: element id: 1122548, sampleTime: 1469081173 for table nh_stats0_1469082599. 
 
Resolution/Workaround:
 
Need to verify the elements related to ID and all other elements which are throwing these errors in system.log file .We have to delete these elements of the devices. They will send very large data than the Database can actually insert and mostly these are bad values.