NFA 9.1.3
NPC 6.1.205
No more emails for scheduled reports after system time change to DST on NFA server in EMEA.
Manual email notifications work but not scheduled ones.
======================= SOLUTION =========================
This problem could be related to these 4 known issues:
1) | When selecting the time zone for a scheduled report under “Recurrence”, use an actual location eg “Europe/London” instead of GMT. |
2) | NFA log: ManagerService_MaintenanceLogxxx.log |
14:02:20 2 - - Error Updating Interface Name :
NQS_BUS_02100: Interface object is not valid: Name cannot be empty or null.
NetQoS.Business.i18nEntityPropertyValidationException: NQS_BUS_02100: Interface object is not valid: Name cannot be empty or null.
at NetQoS.ReporterAnalyzer.Business.Interface.Persist()
at NetQoS.ReporterAnalyzer.Business.Router.ApplyInterfaceTemplates()
at NetQoS.ReporterAnalyzer.Business.SystemMaintenance.ApplyTemplates()
14:02:20 2 - - Error Updating Interface Name :
NQS_BUS_02100: Interface object is not valid: Name cannot be empty or null.
NetQoS.Business.i18nEntityPropertyValidationException: NQS_BUS_02100: Interface object is not valid: Name cannot be empty or null.
at NetQoS.ReporterAnalyzer.Business.Interface.Persist()
at NetQoS.ReporterAnalyzer.Business.Router.ApplyInterfaceTemplates()
at NetQoS.ReporterAnalyzer.Business.SystemMaintenance.ApplyTemplates()
--> Clear this error by running the following query:
mysqldump reporter > rep.sql
mysql reporter
update interfaces set ifDescr=name where ifDescr='';
UPDATE interface_name_templates
SET nameTemplate = '[ifName|ifDescr]'
WHERE nameTemplate = '[ifName]';
quit ;
Then recycle the Netqos services
3) (only applicable if NPC is being used) Verify on NPC server the netqosportal .user_definitions table to see if the 'admin' user has a 'userlevel' value of '1' . If not, set it to 1.
4) | (only applicable if NPC is being used) NFA log: Manager Service Log2015-03-23.log |
14:03:23 1 - Report Scheduler - :
An entity could not be initialized because exactly one row was not returned from the underlying query.
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.ReportSchedule.GetScheduled(DateTime utcNow, Double minutesOverdue)
at NetQoS.ReporterAnalyzer.Business.ReportSchedulerThread.Run(IEmailSchedule schedules)
at NetQoS.ReporterAnalyzer.Business.ReportSchedulerThread.ThreadHandler()
| --> Add "admin" user to reporter.user_definitions on NFA and add "admin" user manually to NPC. |
1. | RDP to NFA console server |
2. | Open command line |
3. | type: mysql reporter |
4. | type: INSERT INTO user_definitions (UserLevel, Name, Description, Password, Algorithm, AuthType, Enabled, Removable, ExportURLs, FirstRun, RoleID, PermissionID, EmailAddress, Timezone, UpdatedOn) VALUES (1, 'admin','ReporterAnalyzer Administrator', '21232f297a57a5a743894a0e4a801fc3' ,0, 1, 'Y', 'N', 'N', 'Y', 1, 1, '', 'GMT', 0); |
5. | restart the RA console server |
6. | go to NPC UI and add the missing "admin" user manually (if this is not done, a full re-sync will delete the user from reporter.user_definitions again) |