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

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