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'
Either the referenced object became corrupted or never installed correctly.
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