Description:
After upgrading from RA 9.0.161 to NFA 9.1.2 or 9.1.3 custom reports fail to run with an error like below:
insert into report_definitions (name, description, reportType, duration, resolution, subnetResolution, timeStamp, endTime, startTime, timeFilter, selectedMeasurements, selectedTotalMeasurements, status, error, thresholdType, thresholdDirection, thresholdSetting, threshold, schedule_type, schedule_days, schedule_time, schedule_timezone, schedule_next, schedule_last, schedule_period_type, email_address, folderID, reportTypeMask, xmlDefinition, updatedOn) values ('lab 852 & 854','','Interface','1d',900,32, unix_timestamp(), 0, 0, 0,'','', 'Defined', '','None', 'Either', 'Above','0', 0, 0, '0:00','GMT',0, 0, 'AsDefined', '', 1,15, '', unix_timestamp()) 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.CustomReportSetScheduleSta rtTime(UInt32 reportId) /common/filterClasses.asp, line 1305
This happens because the "admin" user is not created during an upgrade.
Solution:
To correct this, run the query below on the NFA Console server: