Computer info tab is showing "Computer resource failed to load" on the SMP Console's manage computer screen

Products

• Client Management Suite
• IT Management Suite

Issue/Introduction

When I click on a computer in the SMP Console I get the below error in the Altiris log viewer on the NS:

MainController failure.

Invalid object name 'vInv_SepAgentHealth'.
   [System.Data.SqlClient.SqlException @ .Net SqlClient Data Provider]

Environment

ITMS 8.6 RU1

 

 

Cause

There Table Views and Data Classes for SEP Agent Health were missing from the database.

Views:

vInv_SepAgentHealth
vInv_SepAgentHealthInternal
vInv_SepAgentHealth

Tables / Data Classes:

Inv_SW_SEPagent

Resolution

A repair needed to be run in Symantec Installation Manager (SIM) to put the SEP Agent health pieces back into the database.  We did a full repair, however, SEP Agent should be part of Inventory, so a repair (or maybe reconfig) of Inventory should be sufficient.