Network Management

Missing routing neighbors in Routing Neighbor resource view, with the message An item with the same key has already been added in Orion

The Routing Neighbors widget displays the following message: An item with the same key has already been added. The Routing Neighbors interface is selected and monitored under List Resources. The Routing Neighbors table in Orion Database Manager contains 9 neighbors for this router. Running an SNMP walk on the device shows 8 neighbors for this router.

First published date

10/19/2018 6:11 PM

Last published date

6/3/2022 10:57 AM

Overview

The Routing Neighbors widget displays the following message:

An item with the same key has already been added.

The Routing Neighbors interface is selected and monitored under List Resources.
The Routing Neighbors table in Orion Database Manager contains 9 neighbors for this router.
Running an SNMP walk on the device shows 8 neighbors for this router.

The routing table and flapping routes widgets are showing as per below:

Product section

Network Performance Monitor

Cause

This issue may be caused by duplicate nodes affecting the routing table and there are several ones on the system. The cause may be duplicate nodes for NodeID xyz.

Resolution

Execute the following query to help identify the duplicate ones.

SELECT ObjectSubType, IP_Address, IP_Address_Type, Caption, Vendor, EngineID 
FROM Nodes 
WHERE IP_Address IN (SELECT IP_Address FROM Nodes GROUP BY IP_Address HAVING COUNT(*) >1)
ORDER BY IP_Address

If duplicate nodes are found, you can start cleaning the duplicate nodes on the system.

Bad data may exist in one of the tables below. If the issue persists, contact SolarWinds Support after several polling cycles if the routing table for NodeID xyz is showing properly now.

OpenNPM_RoutingTable a CSV file

Select * from NPM_RoutingTable 

Select * from NPM_RoutingTable_Flap

Disclaimer: Please note, any content posted herein is provided as a suggestion or recommendation to you for your internal use. This is not part of the SolarWinds software or documentation that you purchased from SolarWinds, and the information set forth herein may come from third parties. Your organization should internally review and assess to what extent, if any, such custom scripts or recommendations will be incorporated into your environment. You elect to use third party content at your own risk, and you will be solely responsible for the incorporation of the same, if any.

Disclaimer: Please note, any content posted herein is provided as a suggestion or recommendation to you for your internal use. This is not part of the SolarWinds software or documentation that you purchased from SolarWinds, and the information set forth herein may come from third parties. Your organization should internally review and assess to what extent, if any, such custom scripts or recommendations will be incorporated into your environment. You elect to use third-party content at your own risk, and you will be solely responsible for the incorporation of the same if any.