Bad polls and All errors

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

Description:

In OCE, I have a different value for bad polls and All errors.

Solution:

Bad polls --> the number that shows on the graph is themaximum number of bad polls during that period.

There is no query to run to get this.

When we point the mouse pointer to the last bar on bad polls we get a number. This is the number of bad polls in the last poll. This can be queried using the following command

select bad_polls
from NH_STATS_POLL_HISTORY
where poll_type IN ('f', 'n', 'i') and rownum = 1 order by poll_end_utc
DESC ;

All Errors --> The all errors count the number of parent elements which have bad polls.

This can be calculated using the following query select count(distinct BP.machine_id || BP.element_id || error_type) as

All_Errors
from NHV_STATS_POLL_ERROR_ELEMENT BP, NH_ELEMENT E
where error_utc >=(nh_utl.dtn(sysdate)-400)
and (BP.machine_id=E.machine_id and BP.element_id=E.element_id );