When trying to run an IT Analytics (ITA) cube processing job, errors occur in the Event Viewer window or otherwise the cubes fail to process.
Various.
Various.
Various solutions are available depending on the cause or symptom. It is recommended to verify each of the following as often there are multiple causes.
Cause: The ITA credentials that the user has specified are for a SQL account not domain account or the domain account has insufficient SQL rights.
Solution: Change or refresh (by going through these instructions even if it is felt that this is not the cause) ITAs credentials to those of a domain account that has appropriate SQL rights (Public and Sysadmin).
Cause: The linked server object used by ITA contains corrupted/invalid configuration data. Or, the schema for a secondary database has changed, such as upgrading from ServiceDesk 7.1 SP1 to ServiceDesk 7.1 SP2.
Solution: Delete and then recreate the linked server object and then refresh the secondary database's ITA configuration. Note: This solution is only applicable troubleshooting if the cubes that fail to process are accessing a secondary database, such as for ServiceDesk, Symantec Endpoint Protection or DLP databases. For normal cubes that directly access the Symantec_CMDB database, such as for the Client Server Report Pack, this solution is not applicable as linked server objects are not created or used for the Symantec_CMDB database.
Error: The error "The job completed with failure." occurs in the Event Viewer while processing cubes.
Solution: Various. The following article provides solutions for this error:
Error The job completed with failure when trying to process an IT Analytics cube
https://knowledge.broadcom.com/external/article?legacyId=TECH41800
Error: The error "Object reference set to an instance of an object." occurs when trying to process cubes.
Solution: Various. The following article provides solutions for this error:
Error "Object reference not set to an instance of an object." occurs when clicking on Processing in IT Analytics
https://knowledge.broadcom.com/external/article?legacyId=TECH163197
Symptom: ITA cubes take too long to process.
Solution: This is likely working as designed. Depending on the amount of data to process, it may take some time to process cubes, especially if the processing job is set to process many or all cubes. If this is taking hours or times out, however, this is likely an issue that should be more thoroughly investigated. Additional information on this can be found here:
IT Analytics cubes take too long to process
https://knowledge.broadcom.com/external/article?legacyId=TECH174994
Symptom: A timeout occurs while processing cubes.
Solution: Various. The following article provides solutions for this issue:
Error "Unable to process cubes. Timeout Period elapsed prior to completion of the operation or the server is not responding." occurs when trying to process IT Analytics cubes
https://knowledge.broadcom.com/external/article?legacyId=TECH170977
Issue: Patch Management cubes fail to process, are too slow, or cause huge transaction log growth
Solution: Various. Depending on which issue is occurring, refer to the following articles for more information:
Processing Patch Management ITA cubes fails or is very slow to process 7.1 sp2
https://knowledge.broadcom.com/external/article?legacyId=TECH178615
Processing Patch Management ITA cubes causes excessive transaction log growth
https://knowledge.broadcom.com/external/article?legacyId=TECH172598
Additional Troubleshooting
Related Articles
Unable to install any IT Analytics cubes
https://knowledge.broadcom.com/external/article?legacyId=TECH198183
Error Installing/Adding/Configuring Asset Cubes
https://knowledge.broadcom.com/external/article?legacyId=TECH165715
Warning "The authenticated user cannot access the requested cube." occurs when trying to access an IT Analytics cube or report
https://knowledge.broadcom.com/external/article?legacyId=TECH174986