12 Replies Latest reply on Jul 28, 2011 4:07 PM by bshopp

Cisco WiSM - APs appearing twice

Pau1WH Jan 26, 2010 4:54 AM

I will probably need a support ticket for this, but though I would ask here first.

We have got a Cisco WiSM, which Solarwinds sees as two separate Wireless LAN Controllers. When our Lightweight APs boot they connect to one of the two controllers, not necessarily the same one each time.

So, the scenario is:

Access Point is associated with Controller 1 - shows in Solarwinds as up
Access Point reboots and associates with Controller 2. Solarwinds now shows two entries for the AP - the one associated with Controller 1 shows as down, the one associated with Controller 2 shows as up.

I can remove the duplicate APs manually, but this is a pain and was wondering if it would be possible for Solarwinds to realise that the two APs are in fact the same device (Serial Number? MAC Address?)

Thanks

Paul

Re: Cisco WiSM - APs appearing twice

aLTeReGo Jan 26, 2010 9:07 AM (in response to Pau1WH)

Run the following SQL query against the Orion database. It will clear out all the APs from the database and Orion will rediscover them. This procedure resolved the same issue you are experiencing when I stumbled upon it in early December. It's been working great ever since.
UPDATE NPM_Nodes SET RowStatus=2 WHERE OrionNodeID NOT IN (SELECT NodeID FROM Nodes)
DELETE FROM NPM_NV_EW_DEVICE
DELETE FROM NPM_NV_WL_CONTROLLERS
DELETE FROM NPM_NV_WL_APS
DELETE FROM NPM_NV_WL_INTERFACES
DELETE FROM NPM_NV_WL_CLIENTS
Like Show 0 Likes(0)

Actions
- Re: Cisco WiSM - APs appearing twice
  
  Pau1WH Jan 26, 2010 9:58 AM (in response to aLTeReGo)
  
  This works, but it would be useful if the duplicate entries didn't appear in the first place?
  
  Like Show 0 Likes(0)
  
  Actions
  - Re: Cisco WiSM - APs appearing twice
    
    aLTeReGo Jan 26, 2010 10:04 AM (in response to Pau1WH)
    
    agreed, but whatever the root cause of the duplicate APs showing up the SQL query above resolved the issue for me. Now APs move between controllers and Orion is able to properly track them. So this appears to be a fix and not a work around. Your mileage may vary so post a follow-up and let us know how it worked for you.
    
    Like Show 0 Likes(0)
    
    Actions
Re: Cisco WiSM - APs appearing twice

CSilvernail Mar 4, 2010 7:42 AM (in response to Pau1WH)

I have experienced this same issue twice in the last several weeks. The posted solution has worked both times, but it seems to be a short term fix.
Like Show 0 Likes(0)

Actions
- Re: Cisco WiSM - APs appearing twice
  
  aLTeReGo Mar 4, 2010 1:05 PM (in response to CSilvernail)
  
  The posted solution has worked both times, but it seems to be a short term fix.
  
  Agreed. I'm also finding that the solution that I posted only resolves the issues short term. If anyone has a permanent fix please update this thread. Thanks.
  
  UpDown.png 11.7 KB
  
  Like Show 0 Likes(0)
  
  Actions
  - Re: Cisco WiSM - APs appearing twice
    
    bshopp Mar 5, 2010 8:21 AM (in response to aLTeReGo)
    
    Can you both tell me what versions and SP you are currently on?
    
    Like Show 0 Likes(0)
    
    Actions
    - Re: Cisco WiSM - APs appearing twice
      
      aLTeReGo Mar 5, 2010 9:04 AM (in response to bshopp)
      
      Can you both tell me what versions and SP you are currently on?
      I'm running NPM SLX v9.5.1
      
      Like Show 0 Likes(0)
      
      Actions
      - Re: Cisco WiSM - APs appearing twice
        
        bshopp Mar 5, 2010 9:31 AM (in response to aLTeReGo)
        
        Hmm ok, can you send me your diags so we can look into
        
        Like Show 0 Likes(0)
        
        Actions
        
        Re: Cisco WiSM - APs appearing twice
        
        aLTeReGo Mar 5, 2010 1:06 PM (in response to bshopp)
        
        Hmm ok, can you send me your diags so we can look into
        
        I just uploaded my Solarwinds Diagnostic via LeapFile. If you need anything else you know how to reach me. Thanks for looking into this!
        
        Like Show 0 Likes(0)
        
        Actions
        
        Re: Cisco WiSM - APs appearing twice
        
        ge0ff73 Mar 10, 2010 12:10 PM (in response to aLTeReGo)
        
        I don't know if I'm adding much to this conversation or not. But I just wanted to add that we too have been experiencing this problem with NPM 9.5.1.
        
        Like Show 0 Likes(0)
        
        Actions
        
        Re: Cisco WiSM - APs appearing twice
        
        mgibson Jul 27, 2011 9:41 AM (in response to ge0ff73)
        
        It appears that I may be having the same issue on v10.1.3. Does anyone know what the process is for updating the AP's in ORION.
        I know ORION Reads the controller, so would the following be true? If I am seeing AP's in ORION that no longer exist, then one would have to flush the controller to accomplish the removal of the non-existant Ap's?
        The temporary workaround mentioned above just truncates the AP's from the ORION Tables, on the next discovery the active AP's are found. If we are reading the Controller, then won't the non-existant Ap's be put back in ORION?
        If the answer is NO, then there is an issue with the Logic in how ORION communicates with the Controller in that ORION does not purge the non-existant Ap's..
        If the answer is YES, then Solarwinds should fix the code to allow for removal of these vs. a non-documented DB Change. It should be facilitated from the Web Console perhaps.
        
        Like Show 0 Likes(0)
        
        Actions
        
        Re: Cisco WiSM - APs appearing twice
        
        bshopp Jul 28, 2011 4:07 PM (in response to mgibson)
        
        Please open a support ticket so we can investigate further and see what is going on.
        
        Like Show 0 Likes(0)
        
        Actions

Go to original post