NFA 503 error and/or NetQoS ReporterAnalyzer Manager and Watchdog Service won't stay started

Products

• CA Network Flow Analysis (NetQos / NFA)

Issue/Introduction

After an upgrade you may notice when trying to get to the Network Flow Analysis web site directly you receive a 503 error. Also the NetQoS ReporterAnalyzer Manager and NetQoS ReporterAnalyzer Watchdog Service won't stay started. If you look in Windows Event Manager Application logs, you may see errors like the below:

Application: ReporterManagerService.exe
Framework Version: v4.0.30319
Description: The process was terminated due to an unhandled exception.
Exception Info: System.IO.IOException

Exception Info: System.AggregateException
  at MySql.Data.Common.Ssl.<StartSSLAsync>b__9_1()
  at System.Threading.CancellationToken.ActionToActionObjShunt(System.Object)
  at System.Threading.CancellationCallbackInfo.ExecutionContextCallback(System.Object)
  at System.Threading.ExecutionContext.RunInternal(System.Threading.ExecutionContext, System.Threading.ContextCallback, System.Object, Boolean)
  at System.Threading.ExecutionContext.Run(System.Threading.ExecutionContext, System.Threading.ContextCallback, System.Object, Boolean)
  at System.Threading.ExecutionContext.Run(System.Threading.ExecutionContext, System.Threading.ContextCallback, System.Object)
  at System.Threading.CancellationCallbackInfo.ExecuteCallback()
  at System.Threading.CancellationTokenSource.CancellationCallbackCoreWork(System.Threading.CancellationCallbackCoreWorkArguments)
  at System.Threading.CancellationTokenSource.ExecuteCallbackHandlers(Boolean)

Exception Info: System.AggregateException
  at System.Threading.CancellationTokenSource.ExecuteCallbackHandlers(Boolean)
  at System.Threading.CancellationTokenSource.NotifyCancellation(Boolean)
  at System.Threading.CancellationTokenSource.TimerCallbackLogic(System.Object)
  at System.Threading.TimerQueueTimer.CallCallbackInContext(System.Object)
  at System.Threading.ExecutionContext.RunInternal(System.Threading.ExecutionContext, System.Threading.ContextCallback, System.Object, Boolean)
  at System.Threading.ExecutionContext.Run(System.Threading.ExecutionContext, System.Threading.ContextCallback, System.Object, Boolean)
  at System.Threading.TimerQueueTimer.CallCallback()
  at System.Threading.TimerQueueTimer.Fire()
  at System.Threading.TimerQueue.FireNextTimers()
  at System.Threading.TimerQueue.AppDomainTimerCallback(Int32)

Faulting application name: ReporterManagerService.exe, version: 1.0.8685.11251, time stamp: 0x6527c726
Faulting module name: KERNELBASE.dll, version: 10.0.17763.4974, time stamp: 0xa8cf83fa
Exception code: 0xe0434352
Fault offset: 0x00125aa2
Faulting process id: 0x2038
Faulting application start time: 0x01da3072e9fdef04
Faulting application path: E:\CA\NFA\Reporter\NetQoS.ReporterAnalyzer.ManagerService\bin\ReporterManagerService.exe
Faulting module path: C:\Windows\System32\KERNELBASE.dll
Report Id: 6ff8e9c1-3164-409e-8f20-428a8a061c00
Faulting package full name: 
Faulting package-relative application ID: 

 

Environment

NFA 23.3.3+

Resolution

To resolve this we need to follow the bellow instructions:

1. Open PowerShell ISE on the NFA Console (enter PowerShell_ISE.exe from cmd line).
2. Paste the below content into the PowerShell ISE:
   • $installdir = (Get-ItemProperty -Path HKLM:\SOFTWARE\WOW6432Node\NetQoS).RAInstallDir + "/Mysql/data/ca.pem"
     Set-Location -Path Cert:\LocalMachine\Root
     Import-Certificate -Filepath $installdir
3. The results should look similar to the below:
   • 
4. The services should now all start.
5. You may have to run IISRESET from an administrative command line.