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

Document ID : KB000018983
Last Modified Date : 14/02/2018
Show Technical Document Details

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