Computer info tab is showing "Computer resource failed to load" on the console manage computer screen.

Products

• Client Management Suite
• IT Management Suite

Issue/Introduction

When I click on a computer in the 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

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 was needed to put the SEP Agent health pieces back in 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.