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
use Symantec_CMDB exec spITAnalytics_CSMP_CreateViews
IT Analytics for Symantec Endpoint Protection 7.1 SP2
IT Analytics Client management pack 7.1 SP2
Subscribing will provide email updates when this Article is updated. Login is required to Subscribe
Thanks for your feedback. Let us know if you have additional comments below. (requires login)
This will clear the history and restart the chat.