Unless someone here in Thwack has the answer, I'd suggest you open a Support Case with Solar Winds. You can always close it, or compare answers if someone provides some ideas here. At worst you've got multiple experts working for you, with one team guaranteed to get the answer you need, and with the other team potentially working faster for you.
I did as you advised and opened a case too.
Thanks for the input.
Was your case resolved? I have the same problem.
2 of 2 people found this helpful
you could try change the default automatic heat map generation time to different hour. You can find it in web console on settings page under "Threshold & Polling" -> Polling Settings and in that page should be section for Wireless HeatMap with the setting "Map Generation Start Time".
This worked. Thank you.
What version of NPM are you running? Have you installed any available hotfixes? If you're not running the most recent version (11.5.3 as of the time of writing), I suggest you patch your install, and see if the issue persists
I called support and they were able to resolve the issue.
Just to let everyone know.
Thanks for the help.
I had the same issue with a Cisco 5520 WLC. What resolved the issue was executing the following query against the NPM database:
DELETE FROM PendingNotifications
DELETE FROM Subscriptions
Once these queries were executed, the heat map was able to generate properly.
can you share what the SW techs did to assist you please? I'm having the same issue. I've also logged a ticket now - but if you can help sooner that would be great.
Below, I listed steps that were provided in an email when I recently opened a case with SW Support:
- Stop all SW services.
- Browse to the directory C:\ProgramData\Solarwinds\JobEngine\Data
- Rename "JobEngine35.sdf" to "JobEngine35.bak".
- Right-click "JobEngine35 - Blank.sdf" and select Copy.
- Paste in the same folder.
- Rename "Copy of JobEngine35 - Blank.sdf" to "JobEngine35.sdf", ensuring you remove the read-only checkbox in properties.
- Launch the Database Manager on the server (All Programs > Solarwinds Orion > Advanced Features > Database Manager).
- Add the default server to the view.
- Connect to the database.
- Expand the NetPerfMon database.
- Scroll down to the table: NPM_NV_WL_APS.
- Right-click the NPM_NV_WL_APS table and select "Query Table".
- At the top of the Query window, select "Read-Write" (results can be edited).
- Modify the query to do the following (NOTE: do these one at a time; also, your database may not have all 5 tables listed below, which is OK):
- DELETE FROM NPM_NV_EW_DEVICE (hit refresh)
- DELETE FROM NPM_NV_WL_CONTROLLERS (hit refresh)
- DELETE FROM NPM_NV_WL_APS (hit refresh)
- DELETE FROM NPM_NV_WL_INTERFACES (hit refresh)
- DELETE FROM NPM_NV_WL_CLIENTS (hit refresh)
- Execute the following two queries against the ENTIRE NPM database:
- DELETE FROM PendingNotifications
- DELETE FROM Subscriptions
- Restart all SW services.
- Execute a rediscovery against all Wireless Controllers in your environment.
After all of the steps above have been performed, your heat map should generate as desired. I hope this helps!!
Thank you Michael, I will try this as soon as possible and let you know if it worked.
You're very welcome, my friend. Did the steps work for you?
I have a downtime window on Saturday when I'm upgrading the platform. Will
see if the upgrade fixes it. If not then I'll follow these steps and let
you know after.
On Tue, Jan 24, 2017 at 2:40 PM, michael malendoski <