Tech Tip – NFA: No more emails for scheduled reports after system time change to DST on NFA server in EMEA.

Document created by Michael_Schoellhorn Employee on Apr 21, 2015Last modified by SamCreek on Dec 17, 2016
Version 2Show Document
  • View in full screen mode

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)

Attachments

    Outcomes