Cubes do not install after upgrade

Article:TECH177397  |  Created: 2011-12-20  |  Updated: 2012-10-24  |  Article URL
Article Type
Technical Solution


After upgrading from ITMS v7.1 SP 1 to v7.1 SP2, Not all cubes install, showing three as unavailable, or available but not installed.


 The three following cubes fail to install and either display as unavailable, or available but not installed.

  • Asset
  • Software Compliance
  • Software Puchases


ITMS v7.1 SP2 (post upgrade)


At this time, it appears this is caused by a missing function, fnAssetHierarchyTree, in the CMDB database


Run the attached script against the CMDB Database in question. This should resolve this issue..

Please be aware that the following messages may appear durring the execution of the script. This does not indicate that the script has failed to execute properly. A successful execution will contain "Query Executed Successfully" in the Bottom left portion of the SQL Server Management Studio window.

The important thing to note is if the Query executed successfully or not. If so, reset IIS and the Altiris Service on the Symantec Management Platform, the go back to IT Analytics > Cubes > Available. The three Asset cubes should now be available to install. If not, a repair of ITA, then the ITA packs appear to correct the issue.

Related Article

Unable to install any IT Analytics cubes


Script to resolve issue described in this KB--Updated as of 8/8/2012
Alter CSMP CreateViews script for 7_1_SP2_ONLY.txt (360 kBytes)

Article URL

Terms of use for this information are found in Legal Notices