How to remove interfaces with a NULL / 4294967295 value for ifIndex.

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

Due to an issue with NFA 9.3.2 and prior you may notice interfaces in the database with a NULL or 4294967295 value for ifIndex, which may cause interface mapping problems.

NFA 9.3.3+ has improvements made to minimize the occurrence of these issues.

Environment:
NFA 9.3.3 - 9.3.6
Resolution:

If you see these values please upgrade to NFA 9.3.3 or NFA 9.3.6, following the steps in the 9.3.3 Upgrade Guide or 9.3.6 Upgrade Guide

Then you may have to do some additional cleanup to correct the existing values in the database by following the steps below.

**Note**  As always, please backup each affected databases before making any direct database updates,

For NFA 9.3.3 **ONLY**:

1. From the NFA Harvester Server(s) run the following commands one at a time:

Mysql -P3308 -D poller -t -e "delete from persistent_map where ifindex=4294967295;"

Mysql -P3308 -D poller -t -e  "delete from persistent_map where ifindex is null;"

Mysql -P3308 -D harvester -t -e "truncate table routers;"

Mysql -P3308 -D harvester -t -e "truncate table interfaces;

2. From the NFA Console Server run the following commands one at a time:

Mysql -P3308 -D reporter -t -e "delete from interfaces where ifindex=4294967295;"

Mysql -P3308 -D reporter -t -e "delete from interfaces where ifindex is null;"

3. Restart the "CA NFA Harvester Service"

4. Restart the "CA NFA Collection and Poller Web Service".


For NFA 9.3.6 
**ONLY**:

1. From the NFA Harvester Server(s) run the following commands one at a time:

Mysql -P3308 -D harvester -t -e "delete from persistent_map where ifindex=4294967295;"

Mysql -P3308 -D harvester -t -e  "delete from persistent_map where ifindex is null;"

Mysql -P3308 -D harvester -t -e "delete from interfaces;

2. From the NFA Console Server run the following commands one at a time:

Mysql -P3308 -D reporter -t -e "delete from interfaces where ifindex=4294967295;"

Mysql -P3308 -D reporter -t -e "delete from interfaces where ifindex is null;"

3. Restart the "CA NFA Harvester Service"