If reports on polled data contain null values, you might need to clear the polling
data.
About this task
Over time, with the addition and removal of entities,
the ncmonitor.monitoredInstance table can contain instances of entityIds
that have since been removed from the ncim.entity table. This can
result in polled data reports containing null information. Complete
the following steps to fix this problem:
Procedure
- Run the following queries to determine whether your database
contains null values:
select count(*) from ncpolldata.monitoredInstance
where instanceType = 'ifIndex' and entityId is null;
select
count(*) from ncpolldata.monitoredInstance where instanceType = 'ifIndex'
and entityId not in (select entityId from ncim.interface);
- If any values are returned from the above query, use
itnm_stop to stop
the domain and run the following script to delete the polled data for a domain:
$NCHOME/precision/bin/ncp_perl $NCHOME/precision/scripts/perl/scripts/domain_drop.pl -domain domain -clearPollData
Where domain is the domain for which you want to delete polled data.