Error: "The job completed with failure" when trying to process an IT Analytics cube

Article:TECH41800  |  Created: 2009-04-07  |  Updated: 2012-12-18  |  Article URL http://www.symantec.com/docs/TECH41800
Article Type
Technical Solution


Issue



When processing IT Analytics cubes manually, the error "The job completed with failure" appears in the IT Analytics Event Viewer.


Cause



This has been found to occur when the Altiris IT Analytics Symantec report pack failed to install 100% correctly.

This may also occur if the SQL cubes and dimensions fail to be able to be processed directly in the SQL Server.


Solution



On the Microsoft SQL Server used for IT Analytics, verify if the cube that has issues can be manually processed. If not, then remove the cube in the IT Analytics user interface, verify it is removed in SQL, then reinstall it in IT Analytics. Refer to the following article for more information on how to do this:

How to uninstall and reinstall an IT Analytics report pack cube
http://www.symantec.com/business/support/index?page=content&id=HOWTO40189

Additional Troubleshooting

  • Determine which cubes specifically are failing. Do not run large jobs where many if not all cubes are attempting to be processed, so narrow down the scope of what is failing, where.
  • The IT Analytics database may be corrupted and fail to work successful. Uninstall IT Analytics entirely, including any report packs and documentation, or drop the IT Analytics database in SQL and have IT Analytics run and re-create it. Also, try removing the IT Analytics SQL Reporting Services folder. This would then need to be recreated by IT Analytics as well, in the configuration settings. In addition, repairing the CMDB database can help resolve this as well. This is found in the SMP Console under Settings > Notification Server > Database Settings > Repair Database button. It is recommended that a full database backup be made first in SQL before performing this latter step, however.
  • If a custom cube has been created that is one of those attempting to be processed, the Cube Name and the Cube ID may have became mismatched during development of the cube. Re-sync these and then re-try processing the cubes.


Related Articles


IT Analytics cubes fail to process
http://www.symantec.com/business/support/index?page=content&id=TECH200974

How to troubleshoot errors and failures in the IT Analytics Event Viewer window
http://www.symantec.com/business/support/index?page=content&id=TECH147807

How to install and use IT Analytics and its report packs
http://www.symantec.com/business/support/index?page=content&id=HOWTO39470



Legacy ID



46478


Article URL http://www.symantec.com/docs/TECH41800


Terms of use for this information are found in Legal Notices