After adding node via SNMP, duplicate nodes displayed under Manage Nodes in SolarWinds Platform

If you see duplicate entries of nodes in  Manage Nodes, with the same Node Name, same IP Address and Node ID, it could either be because:

1. There are actual duplicate Nodes in the Nodes tables
   • If this is the case, see article "Duplicate nodes seen in Manage Nodes that are reflected in the SolarWinds Database"
2. Duplicate Community Strings in the WebCommunityStrings table, with unique GUIDs. 
   • If this is the case, follow the steps in the Resolution

• Orion uses Community Strings as medium to communicate in every SNMP request to your Nodes. This Community String is uniquely identified by an ID so the SNMP responses will route to the right node that initiated the request and saved in the correct row in Nodes table.
• Although the cause is indefinite, there are probably instances wherein nodes are using different community strings which causes duplicate entries of Web Community GUI ID.

To resolve this issue, please upgrade to SolarWinds Platform 2024.2.1 and above. If upgrade is not possible, perform the workaround below:

Part 1 - Locate the Duplicate Community String

1. Go to Nodes or NodesData table and identify the Community strings of the node in question.
2. Check the WebCommunityString table and look for the community string that is being used by the Node. Then check if it has duplicate entries.

See the example below:

After you Identify the Community String, proceed to step two, and remove the duplicate entry. (In the example below, we'll remove "jk_pub_can")

* This can also occur with ICMP entries as shown below highlighted yellow.


*** NOTE ***
If you do not find Duplicate Community Strings in the table, try to identify if there are duplicate IP Addresses in Nodes table by following article "Locate duplicate nodes in SolarWinds Database"

Part 2 - Remove the Duplicate Community String

1. Backup your Orion Database (VERY IMPORTANT)
2. Stop all SW services using the Orion service manager located at start > All programs > Solarwinds Orion > Advanced features.
3. Go to Start > All Programs > SolarWinds Orion > Advanced Features > Database Manager
4. Add your DB server or click Add Default server to access your Database server
5. Right-click WebCommunityStrings table and select Query Table
6. Click Enable table editing to Edit the column
7. Find the first entry CommunityString entry (See example below)
   • 5e8962be-0a30-4b53-9782-6e13bf0099fc           solarwinds1
8. Right click and select Delete selected row
9. Click Execute Query for the change to take effect
10. Start all SW services using the Orion service manager