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.
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.