cancel
Showing results for 
Search instead for 
Did you mean: 
Create Post
Level 8

Compliance Policy Reports do not run in NPM

All,

I have a problem were any policy reports that I have in NCM can not be run in the NPM browser. If I try to update the reports from NPM, I consistently get a compliance cache generation error / failure. (The policy reports run fine under NCM Policy Reporter)

 

I am running on the same server:

NPM version 10.1.2

NCM version 6.1

 

Does anyone have any ideas as to what I need to do to get the policy report outputs to show up in the NPM WEB browser?

0 Kudos
12 Replies

Second option:

Yes, I know that happens from time to time and it would be nice if there was a timeout feature or fail out feature associated with it.  Here is how I clear it.

1.  Log on to Solarwinds Server locally.

2.  Start > Solarwinds Orion > Advanced Features > Database Manager

3.  Add Server >> your Solarwinds Server

4.  Expand the Database and scroll down to > NCMPolicyCache

5.  Double click and "Execute Query"

6.  Click the "Edit Table" button next to Execute Query

7.  Right click on line entry and delete.

8.  Run Configuration Wizard and select only the "Database Option"

9.  You may need to bounce the server from time to time but should not be often.

Or, if some smart programmer can come up with a script to do all this that would be great.

Thanks,

Courtesyit

0 Kudos

Mark this date in the books.  I actually found a solution for an issue I had in Thwack.

Thanks for the step by step guide for those of us who are not comfortable doing anything in SQL.

0 Kudos
Level 13

Do you keep your NCM reports in the same reports folder as your NPM reports?  If they don't go to the same place, then you will have to specify the folder in the account management settings.  The last option in account management settings is for reports, and you would have to have the NCM reports sent to that same folder in order for them to be viewed in the reports section of your web browser.


Chrystal Taylor | Head Geek
0 Kudos

Crystal,


I have searched my server but I do not find where Policy Reports from Orion Network Configuration Manager Policy Reporter are actual files that are saved on the server. I have created reports, policies and rules and searched for each item I have created and do not find them as a stored file on the server.


 


I am familiar with NCM reports, located in


 \Program Files\SolarWinds\Configuration Management\Reports


These reports are all  .ConfigMgmtReport


 


I am also familiar with the NPM reports located in


\Program Files\SolarWinds\Orion\Reports


And these reports are all  .OrionReport


 


Unless I am way off, I do not think the Policy Reporter saves the compliance reports the same way that Orion does the standard reports. The tools for creating compliance reports, policies and rules from the Orion WEB interface are in place and work, it is just when you run the report the results are supposed to be displayed from some sort of  policy cache that the system fails to create or update.


 


If you have any additional information please respond back.


 


Thanks

0 Kudos

I have searched my server but I do not find where Policy Reports from Orion Network Configuration Manager Policy Reporter are actual files that are saved on the server. I have created reports, policies and rules and searched for each item I have created and do not find them as a stored file on the server.

Unless I am way off, I do not think the Policy Reporter saves the compliance reports the same way that Orion does the standard reports.

Anyone figure out where these darn policy reports are stored?  I'm thinking they are created internally by Policy Reporter.  I would like to be able to create this report (Advanced SQL report) in NPM Report Writer.

0 Kudos

Hi Greg,

 

We have same issue here....have you resolved it already? and have you found the folder where the policy reports are?

0 Kudos

Working throught eh NPM web interface does not give a very informative error. What i found is if you log directly into the NCM console. Launch the Policy Reporter from the Reports menu and execute the report that is erroring, I got an error that directed me to a badly configured rule. I fixed the rule and the error issue went away in NPM web. hope this helps.

0 Kudos

Everyone, thank you for all the suggestions.

My issue was resolved by Solarwinds Techsupport. This is what was done.


I advise you to truncate the following 2 tables on the NCM database.

PolicyCache
PolicyCacheResults


- Please take a full fresh backup of your NCM database (just to be on a safe side)

- Navigate to Orion Database Manager and access the following
- And select the following 2 tables (one by one)

PolicyCache
PolicyCacheResults


- And run the following queries.

- Truncate Table PolicyCache
- Truncate Table PolicyCacheResults

Once you have truncate them successfully please restart the NCM Caching & Polling services.

- And then try to do an update again.

Please let me know with the feedback.

Adrian Cook
Solarwinds Tech Support

What are these...NCM Caching & Polling services? Can't see these in Orion service manager on my NCM server? TIA

0 Kudos

Thanks for posting back. I had the same issue and this worked like a charm.

0 Kudos

I have the same issue ("error occured during compliance cache generation" when accessing compliance reports through web interface), but that solution did not do the trick for me (tables are empty). I can see compliance reports correctly from Policy Reporter. 

Anyone have any other ideas?

0 Kudos

Had the same problem and this solution worked for me. Thanks!

0 Kudos