When I update a compliance policy report that report seems to get stuck in a caching loop.
Yes, I have found that doing the following have resolved this issue.
1. Log into your solarwinds server via RDP or locally.
2. Navigate to All Programs > Solarwinds Orion > Advanced Features > Database Manager
3. Add the SQL server for your solarwinds
4. Expand SQL structure looking for the database you named for your solarwinds solution. Default is SolarwindsOrion
5. Once database is expanded scroll down to "NCMPolicyCache"
6. Query the database
7. Enable Database Editting
8. Right Click on the Row where you the process ID. There should only be one but if not delete all entries.
9. Subit/Ok, then close.
10. Run the Configuration Wizard and select Database and Services.
11. This should clear up the issue. If you know which rule was stuck in caching then it is wise to disable that rule until the error can be found.
Thanks,
Hope this helps.
Seems this issue has many causes, I went through several days of troubleshooting, cleaning tables, etc.. turns out for me, adding an additional poller caused the issue and restarting IIS corrected the issue, just in case you experience this again, something to think about.
Interesting, you added a poller..... can you provide more information on your poller and core setup. You can find me on the mail.mil domain.
NCM should really have a way to break the stuck caching loop... I've been editing the database to free it but that's kinda a hack.
