An error has occurred that prevents the data displaying when viewing software filters

Products

• IT Management Suite
• Software Management Solution

Issue/Introduction

Browsing the Manage > Software page and you see the following error after clicking on a software filter:

An error has occurred that prevents the data displaying. Check server logs for details. 

Furthermore you see the same error in the right pane of the Console:

Entry in the SMP Logs:

Failed to run filter.

IsHierarchy

   [System.IndexOutOfRangeException @ System.Data]

   at System.Data.ProviderBase.FieldNameLookup.GetOrdinal(String fieldName)

   at System.Data.SqlClient.SqlDataReader.GetOrdinal(String name)

   at System.Data.SqlClient.SqlDataReader.get_Item(String name)

   at Altiris.NS.Services.CoreServices.DAL.SoftwareComponentFilterDataProcessor.Read(List`1 re, IDataReader reader)

   at Altiris.NS.DataAccessLayer.Implementation.Altiris_NS_Services_CoreServices_DataAccessLayerCoreServicesDAL.spAC_FilterAndGetSoftwareResourcesDataWithTrustee__F(String resourceGuidList, String typeGuidList, String trusteeList, Int32 sortOrder, Boolean isAdmin, Boolean& hasMixedResources, Int32 _outerBatchSize)

   at Altiris.NS.DataAccessLayer.Implementation.Altiris_NS_Services_CoreServices_DataAccessLayerCoreServicesDAL.spAC_FilterAndGetSoftwareResourcesDataWithTrustee__F(String resourceGuidList, ICollection`1 typeGuidList, String trusteeList, Int32 sortOrder, Boolean isAdmin, Boolean& hasMixedResources, Int32 _outerBatchSize)

   at Altiris.NS.DataAccessLayer.Implementation.Altiris_NS_Services_CoreServices_DataAccessLayerCoreServicesDAL.spAC_FilterAndGetSoftwareResourcesDataWithTrustee(ICollection`1 resourceGuidList, ICollection`1 typeGuidList, String trusteeList, Int32 sortOrder, Boolean isAdmin, Boolean& hasMixedResources)

   at Altiris.NS.Services.CoreServices.Providers.SoftwareFilterDataProvider.GetDataWithScoping(Boolean& bHasMixedResources)

   at Altiris.NS.Services.CoreServices.Providers.FilterDataView.GetData(IFilterDataProvider dataProvider)

   at Altiris.NS.Services.CoreServices.ResourceService.EvaluateFilter(RunFilterData runData)

   at Altiris.NS.Services.CoreServices.ResourceService.RunFilter(RunFilterData runData)

Environment

SMP 8.1 RU7

Cause

Unknown.

Resolution

Reconfigure the ITMS Management Views using the Symantec Installation Manager (SIM)

1. Open SIM
2. Click Repair installed products
3. Reconfigure installed products
4. Check ITMS Management Views (Note: Dependent solutions will automatically be checked as well)
5. Click Next and proceed through the configuration