Error while processing cube due to invalid object name

Products

• IT Analytics

Issue/Introduction

Some of the CSMP or SEP cubes fail to process. In this case the dimensions fail to process due to invalid object. (missing stored procedures and functions)

- dbo.fnITAnalytics_SEP_AdministratorDim
- vITAnalytics_SEP_AlertDim

Errors in the high-level relational engine. The following exception occurred while the managed IDbCommand interface was being used: Invalid object name 'dbo.fnITAnalytics_SEP_AdministratorDim'

 

Cause

Either the referenced object became corrupted or never installed correctly.

Resolution

Recreate the missing objects by running the below SQL query against the Symantec_CMDB

use Symantec_CMDB
exec spITAnalytics_SEP_CreateViews

or

use Symantec_CMDB
exec spITAnalytics_CSMP_CreateViews

 

Applies To

IT Analytics for Symantec Endpoint Protection 7.1 SP2

IT Analytics Client management pack 7.1 SP2