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, the error “An error has occurred that prevents the data displaying. Check server logs for details.” is seen after clicking on a software filter.

Error displaying in the console:

"An error has occurred that prevents the data displaying. Check server logs for details." will be displayed in the middle pane.

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