IT Analytics cubes are missing - "A connection to a CMDB that includes the following solutions must be configured: Inventory Solution"

book

Article ID: 206227

calendar_today

Updated On:

Products

Client Management Suite

Issue/Introduction

What caused the message "A connection to a CMDB that includes the following solutions must be configured: Inventory Solution"?

Cause

This message means that the Cube Names listed are available to add but the pre-requisites to add them have not been met. When IT Analytics (ITA) is installed there are 23 SQL Views created that are required for cubes to be created and for ITA to function.

Environment

Release : IT Analytics 8.5 RU4

Component :

Resolution

The solution is to:

1) Verify that the Solutions specified in the message above are installed and working

2) The following SQL query can be used to verify that the 23 required SQL Views were created properly:

--Application Metering, Computers, Installed Files, & Installed Software Cubes pre-req Returns 23
select count(*) from sysobjects where (type = 'V' or type = 'U') and name in ( 'vITAnalytics_CMDB_AddRemoveProgramsDim','vITAnalytics_CMDB_ApplicationMeteringFact','vITAnalytics_CMDB_CollectionDim','vITAnalytics_CMDB_CollectionMembershipFact','vITAnalytics_CMDB_ComputerDim','vITAnalytics_CMDB_ComputerFact','vITAnalytics_CMDB_DateDim','vITAnalytics_CMDB_InstalledFileFact','vITAnalytics_CMDB_InstalledSoftwareFact','vITAnalytics_CMDB_LogicalDiskDim','vITAnalytics_CMDB_LogicalDiskFact','vITAnalytics_CMDB_OrganizationalGroupDim','vITAnalytics_CMDB_OrganizationalGroupFact','vITAnalytics_CMDB_PhysicalMemoryArrayFact','vITAnalytics_CMDB_PhysicalMemoryFact','vITAnalytics_CMDB_ProcessorDim','vITAnalytics_CMDB_ProcessorFact','vITAnalytics_CMDB_SoftwareComponentDim','vITAnalytics_CMDB_SoftwareComponentFileFact','vITAnalytics_CMDB_SoftwareProductComponentFact','vITAnalytics_CMDB_SoftwareProductDim','vITAnalytics_CMDB_UserDim','vITAnalytics_CMDB_WindowsFileDim' )

3) The follow stored procedure is what is used to create the Views during installation and can be used to create/recreate the missing views and all views

exec spITAnalytics_CSMP_CreateViews