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
This is specific to NFA being tied to NPC instead of CAPC. To resolve this problem perform the following steps:
- In NPC create a user called 'admin' and give the user the same permissions as nqadmin.
- Perform a full synchronization with the NFA data source via Admin > Data Sources > select NFA > Resync > select check box 'Perform a full resynchronization' > Resync