Anomaly Detector not working after upgrade

book

Article ID: 131295

calendar_today

Updated On:

Products

CA Network Flow Analysis (NetQos / NFA)

Issue/Introduction

Anomaly Detector is throwing an error after upgrade:

System.Web.Services.Protocols.SoapException: Server was unable to process request. ---> NetQoS.Core.Database.i18nDBException: Failed to create a connection string! Unable to load a valid .ini file from the following location or locations: D:\CA\NFA\NQAD\NQADWebService\\..\..\DBUsers\AnomalyDetector.ini at NetQoS.Core.Database.ConnectString.Initialize(String prefix, String server) at ADUtilities.GeneralTools.getADDBConnString() at ADUtilities.ReporterTools.GetNQADParameters() at NQADWebService.AdminUIServiceV2.GetEHealthIP() at NQADWebService.AdminUIServiceV2.GetDataMaster(String whichHostType) --- End of inner exception stack trace --- at NetQoS.ReporterAnalyzer.Business.AnomalyDetector.ADAdministration.ADWSCall(String wsName, String[] wsParams) at NetQoS.ReporterAnalyzer.Business.AnomalyDetector.ADAdministration.GetDataMasters(DataTable dataTable, String type) at NetQoS.ReporterAnalyzer.Business.AnomalyDetector.ADAdministration.GetMonitoredProducts() at NetQoS.ReporterAnalyzer.Business.AnomalyDetector.ADAdministration.GetMonitoredProductsByWSCriterias(String sortColumns, String sortDirections, Nullable`1 limit, Nullable`1 offset, String filter, UInt32& recordCount) at NetQoS.ReporterAnalyzer.AuthorizationWebservices.AnomalyDetectorWS.GetMonitoredProducts(String orderBy, String sortOrder, Int32 limit, Int32 offset, String filter, Int32& recordCount)

Cause

There is no AnomalyDetector.ini file in x:\CA\NFA\DBUsers\.

Environment

Release:
Component: NQRPTA

Resolution

1. Open notebad on the NFA console server and paste these contents:

nsas.dbUser=nsas
nsas.dbPassword=nqnsas
nsas.dbPort=3308
nsas.dbName=nsas
nsas.dbHost=localhost
nsas.dbPooling=True
nsas.dbMaxPoolSize=20
nsas.dbCompress=false
nsas.dbCommandTimeout=90
nsas.dbRetryLostConnection=true

2. Save the file as "AnomalyDetector.ini" to the x:\CA\NFA\DBUsers\ directory.

3. Restart the CA NFA Host Resolver Service and the CA NFA Hunter Tracker Service.

4. Open a CMD prompt (as an administrator) and type: "IISRESET"