Compliance Report getting Error or not getting Cached.
1. Make a note of Cache Status at DB Level:
CacheStatus: notCached = 0, Waiting = 1, Caching = 2, Cached = 3, Error = 4, Queued = 5
2. On DB run below Query to check the Status:
SELECT * FROM [dbo].[NCM_PolicyReports]
you can check the Status of Cache under Status Column.
If the status is other than 3 the compliance Report is not getting cached.
Change the status to 0, which will run the caching from start once services restarts.
3. Run below Query to DB
Truncate NCM_policycache
Truncate NCM_PolicyCacheResults
Restart the NCM Caching or services.
