-
Re: Cisco WiSM - APs appearing twice
aLTeReGoJan 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-
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?
-
Re: Cisco WiSM - APs appearing twice
aLTeReGoJan 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.
-
-
-
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.
-
Re: Cisco WiSM - APs appearing twice
aLTeReGoMar 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
-
Re: Cisco WiSM - APs appearing twice
bshoppMar 5, 2010 8:21 AM (in response to aLTeReGo)
Can you both tell me what versions and SP you are currently on?
-
Re: Cisco WiSM - APs appearing twice
aLTeReGoMar 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
-
Re: Cisco WiSM - APs appearing twice
bshoppMar 5, 2010 9:31 AM (in response to aLTeReGo)
Hmm ok, can you send me your diags so we can look into
-
Re: Cisco WiSM - APs appearing twice
aLTeReGoMar 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!
-
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.
-
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.
-
Re: Cisco WiSM - APs appearing twice
bshoppJul 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.
-
-
-
-
-
-
-
-