performance dash board not populating values

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

Issue/Problem/Symptoms: 

The performance dash board not populating values under eHealth Reports & Live Reports.

Environment:  

eHealth 6.3.2.07

Os Windows, Linux, Solaris

Cause: 

This issue is cause when in fact there are multiple problems with the database and Element count for each Os:

Windows 50,000

Linux 75,000

Solaris 100,000

When the element is over the limit eHealth will use more resources that what it originally was intend to use there for it will start having memory error under the system.log for example:

ORA-04031: unable to allocate 65560 bytes of shared memory ("large pool","unknown object","large pool","PX msg pool")

Which it will eventually start causing problems with the database by disconnecting:

Error nhiRegStats[Active] Pgm nhiRegStats[Active]: DuAPI Oracle error: ORA-03114: not connected to ORACLE

Resolution/Workaround:

1. Reduce the element count under the supported range depending what Os eHealth is running with.

2. Run the command:

nhDbApi -createViews  and restart the server 

Additional Information:

 

None