Custom reports generate NetQoS.ReporterAnalyzer.LegacyInterop error '80131500' after upgrade to NFA.

Article Id: 18983
Status: Published
Updated On: 14-02-2018 07:50
Legacy Id: TEC607001
Products:
APPLICATION DELIVERY ANALYSIS , SUPERAGENT , CA Infrastructure Performance
Issue/Introduction:

Description:

After upgrading to NFA from RA custom reports are generating the following error:

NetQoS.ReporterAnalyzer.LegacyInterop error '80131500'

NetQoS.Business.i18nEntityInitializationException: An entity could not be initialized because exactly one row was not returned from the underlying query. at NetQoS.Business.DatabaseEntity.InitializeFromQueryResults(DatabaseEntity databaseEntity, DataTable table) at NetQoS.ReporterAnalyzer.Business.User.GetByName(String name) at NetQoS.ReporterAnalyzer.Business.ReportScheduleItem.Set(DataRow dr) at NetQoS.ReporterAnalyzer.Business.ReportScheduleItem..ctor(ReportSchedule reportSchedule, DataRow dr) at NetQoS.ReporterAnalyzer.Business.ReportSchedule.GetScheduleItem(UInt32 reportId) at NetQoS.ReporterAnalyzer.LegacyInterop.LegacyInterop.CustomReportSetScheduleStartTime(UInt32 reportId)

/common/filterClasses.asp, line 1305

Solution:

This is specific to NFA being tied to NPC instead of CAPC. To resolve this problem perform the following steps:

  1. In NPC create a user called 'admin' and give the user the same permissions as nqadmin.

  2. Perform a full synchronization with the NFA data source via Admin > Data Sources > select NFA > Resync > select check box 'Perform a full resynchronization' > Resync

Environment:

Release:
Component: NQRPTA