Getting an error when trying to view a report for software installed on a computer
Article ID: 164918
Updated On:
Products
Issue/Introduction
The customer is trying to run a report of installed software for a particular software product. When he is saving this report (Save Result as Report) from Manage > Software > Installed Products for example, in the console, and error is produced saying “unknown error”.
Also, if he tries to save the results as a Filter (Save Result as Filter), the filter is created but he gets an error when trying to display the filter membership.
This is the error when he tries to save the results as a Report:
Failed to resolve resource query from the xml configuration.
This join source does not have a dataField 'ResourceGuid'
[Altiris.NS.Exceptions.AeXException @ Altiris.Reporting.DataSource]
at Altiris.Reporting.DataSource.ResourceDS.RModel.RMoArbitraryJoin.GetSourceDataField(String sourceDataFieldName)
at Altiris.Reporting.DataSource.ResourceDS.RModel.RMoArbitraryJoin.FromXml(XmlNode xml)
at Altiris.Reporting.DataSource.ResourceDS.RModel.RMoResourceTypeItem.ParseJoins(XmlNode xmlResourceType)
at Altiris.Reporting.DataSource.ResourceDS.RModel.RMoResourceTypeItem.FromXml(XmlNode xmlResourceType)
at Altiris.Reporting.DataSource.ResourceDS.RModel.ResourceQuery.FromXml(XmlNode xml)
at Altiris.Reporting.DataSource.ResourceDataSource.ValidateXmlQuery()
Exception logged from:
at Altiris.Reporting.DataSource.ResourceDataSource.ValidateXmlQuery()
at Altiris.Reporting.DataSource.ResourceDataSource.get_SourceResourceQuery()
at Altiris.Reporting.DataSource.ResourceDataSource.get_SqlQuery()
at Altiris.NS.Services.CoreServices.Providers.SavedSearchHelperProvider.GetSearchSql(Altiris.NS.Silverlight.ActivityCenter.Bridge.Filter.SavedSearch)
at Altiris.NS.Services.CoreServices.HelperClasses.SavedSearchHelper.GetReportSql(Altiris.NS.Silverlight.ActivityCenter.Bridge.Filter.SavedSearch, Altiris.NS.Silverlight.ActivityCenter.Bridge.Filter.SavedSearch)
at Altiris.NS.Services.CoreServices.ResourceService.SaveAsLegacyReport(Altiris.NS.Silverlight.ActivityCenter.Bridge.Filter.SavedSearch, Altiris.NS.Silverlight.ActivityCenter.Bridge.Filter.SavedSearch, String, System.Guid)
at
-----------------------------------------------------------------------------------------------------
Date: 3/23/2017 1:08:47 PM, Tick Count: 1282003814 (14.20:06:43.8140000), Size: 1.88 KB
Process: w3wp (8780), Thread ID: 1326, Module: Altiris.Reporting.DataSource.dll
Priority: 1, Source: Altiris.Reporting.DataSource.ResourceDataSource.ValidateXmlQuery
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
This is the error that appears in the NS logs when trying to save results as filter:
Failed to perform a collection membership update on the collection 'TEST New Filter' (e291c870-ba7f-4a30-9aff-2626dee8a32b). An unhandled exception has occurred.
Full membership update failed.
[Altiris.NS.Exceptions.AeXException @ Altiris.NS.StandardItems]
at Altiris.NS.StandardItems.Collection.NSDataSrcBasedResourceCollection.UpdateMembershipCore(ICollectionUpdateMessage updateMessage)
at Altiris.NS.ContextManagement.AdminDatabaseContext.<>c__DisplayClass16`1.<PerformWithDeadlockRetry>b__15(IDatabaseContext ctx)
at Altiris.Database.DatabaseContext`1.RetryAction(Int32 retries, Boolean transacted, Getter`1 getContext, Action`1 action, Action`1 retry, DeadlockRetryArgs& re, Exception& exception, Boolean inTransaction)
at Altiris.Database.DatabaseContext`1.PerformWithDeadlockRetryHelper(Int32 retries, Boolean inTransaction, Getter`1 getContext, Action`1 action, Action`1 retry, Boolean transacted)
at Altiris.Database.DatabaseContext`1.PerformWithDeadlockRetry(Int32 retries, Boolean startNewTransaction, Nullable`1 isolationLevel, Boolean independentContext, Action`1 action, Action`1 retry)
at Altiris.NS.StandardItems.Collection.NSResourceCollectionBase.UpdateMembershipImpl(ICollectionUpdateMessage updateMessage)
The RawSqlDataSource ran but one or more Database objects were not present: 'TEST New Filter' (e291c870-ba7f-4a30-9aff-2626dee8a32b)
[Altiris.DataSource.Exceptions.DataSourceMissingObjectException @ Altiris.Reporting.DataSource]
at Altiris.Reporting.DataSource.RawSqlDataSource.RunTry(IDatabaseContext ctx, String name, String sql)
at Altiris.Database.DatabaseContext`1.RetryAction(Int32 retries, Boolean transacted, Getter`1 getContext, Action`1 action, Action`1 retry, DeadlockRetryArgs& re, Exception& exception, Boolean inTransaction)
at Altiris.Database.DatabaseContext`1.PerformWithDeadlockRetryHelper(Int32 retries, Boolean inTransaction, Getter`1 getContext, Action`1 action, Action`1 retry, Boolean transacted)
at Altiris.Database.DatabaseContext`1.PerformWithDeadlockRetry(Int32 retries, Boolean independentContext, Getter`1 getContext, Action`1 action, Action`1 retry)
at Altiris.Reporting.DataSource.RawSqlDataSource.Run()
at Altiris.NS.StandardItems.Collection.NSDataSrcBasedResourceCollection.FullUpdateMembership()
at Altiris.NS.StandardItems.Collection.NSDataSrcBasedResourceCollection.UpdateMembershipCore(ICollectionUpdateMessage updateMessage)
Invalid object name 'vAC_ComputerLicenseAndUsageByProduct'.
[System.Data.SqlClient.SqlException @ .Net SqlClient Data Provider]
at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)
at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)
at System.Data.SqlClient.SqlDataReader.TryConsumeMetaData()
at System.Data.SqlClient.SqlDataReader.get_MetaData()
at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString, Boolean isInternal, Boolean forDescribeParameterEncryption)
at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, Boolean inRetry, SqlDataReader ds, Boolean describeParameterEncryptionRequest)
at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry)
at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method)
at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method)
at System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior)
at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior)
at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32 startRecord, Int32 maxRecords, String srcTable)
at Altiris.Reporting.DataSource.RawSqlDataSource.RunTry(IDatabaseContext ctx, String name, String sql)
SQL Exception details: code=208, line=1
Exception logged from:
at Altiris.NS.StandardItems.Collection.NSResourceCollectionBase.UpdateMembershipImpl(Altiris.NS.StandardItems.Collection.ICollectionUpdateMessage)
at Altiris.NS.StandardItems.Collection.NSResourceCollectionBase.UpdateMembership(Altiris.NS.StandardItems.Collection.ICollectionUpdateMessage)
at Altiris.NS.StandardItems.Collection.NSResourceCollectionBase.GetMembers(Boolean)
at Altiris.NS.Services.CoreServices.HelperClasses.FilterHelper.GetMembers(Altiris.NS.Services.CoreServices.Contracts.RunFilterData, Boolean)
at Altiris.NS.Services.CoreServices.Providers.ComputerFilterDataProvider.GetDataWithScoping(Boolean&)
at Altiris.NS.Services.CoreServices.Providers.FilterDataView.GetData(Altiris.NS.Services.CoreServices.Providers.IFilterDataProvider)
at Altiris.NS.Services.CoreServices.ResourceService.EvaluateFilter(Altiris.NS.Services.CoreServices.Contracts.RunFilterData)
at Altiris.NS.Services.CoreServices.ResourceService.RunFilter(Altiris.NS.Services.CoreServices.Contracts.RunFilterData)
at
-----------------------------------------------------------------------------------------------------
Date: 3/23/2017 1:18:55 PM, Tick Count: 1282611984 (14.20:16:51.9840000), Size: 6.02 KB
Process: w3wp (8780), Thread ID: 300, Module: Altiris.NS.StandardItems.dll
Priority: 1, Source: Altiris.NS.StandardItems.Collection.NSResourceCollectionBase.UpdateMembershipImpl
Environment
ITMS 8.0 HF6
Cause
There was a missing or out-of-date view that was needed to execute these functions: vAC_ComputerLicenseAndUsageByProduct
Resolution
Run a reconfiguration of the following config files in this order:
1. ActivityCenter.config
2. ActivityCenter_Hotfix.config
Run AexConfig.exe /configure from the command prompt running as Administrator.
Examples:
C:\Program Files\Altiris\Notification Server\Bin\> AeXConfig.exe /configure "C:\Program Files\Altiris\Activity Center\Config\ActivityCenter.config"
C:\Program Files\Altiris\Notification Server\Bin\> AeXConfig.exe /configure "C:\Program Files\Altiris\Activity Center\Config\ActivityCenter_Hotfix.config"
Attachments
Feedback
