The customer noticed that "Applicable Patches" and "Patch Vulnerabilities" measure groups failed to process for the "Patch Management" Cube in ITA (IT Analytics). Those have been timing out. The other measure groups ran just fine.
The customer tried increasing the default time outs (as suggested under "Cube processing timeout error prior to job completion" KB 162315 ) but still not improvements.
The customer tried running the following query for example against the main view used by "Applicable Patches" measure group:
SELECT TOP (1000) [ResourceId]
,[ResourceGuid]
,[SWUGuid]
,[ReleaseDate]
FROM [Symantec_CMDB].[dbo].[vITAnalytics_CMDB_ApplicablePatchFact]
As far as he can see, this query took more than 12 minutes to return top 1000 from "vITAnalytics_CMDB_ApplicablePatchFact" in his environment.
ITA 8.7
Known Issue. There were some functions and views used by Patch Management cube that needed optimization:
Fixed Performance Issues for SQL-functions:
- fnITAnalytics_CMDB_VulnerablePatches
- fnITAnalytics_CMDB_ApplicablePatches
and some views
This issue has been fixed in our ITA 8.7.1 release.
In the meantime, you can try the following workaround: