I am seeing the error "PROCEDURE reporter.SyncRouterInterfaceAndAgentCounts does not exist" in my NFA logs.

Document ID : KB000032430
Last Modified Date : 14/02/2018
Show Technical Document Details

Problem:

NFA console is missing the Stored Procedure 'SyncRouterInterfaceAndAgentCounts' after an install or upgrade to NFA 9.3.2.

I am seeing the error below in my ManagerService*.log file on my NFA Console server:

 

 PROCEDURE reporter.SyncRouterInterfaceAndAgentCounts does not exist

MySql.Data.MySqlClient.MySqlException: PROCEDURE reporter.SyncRouterInterfaceAndAgentCounts does not exist

   at MySql.Data.MySqlClient.MySqlStream.ReadPacket()

   at MySql.Data.MySqlClient.NativeDriver.GetResult(Int32& affectedRow, Int32& insertedId)

   at MySql.Data.MySqlClient.Driver.GetResult(Int32 statementId, Int32& affectedRows, Int32& insertedId)

   at MySql.Data.MySqlClient.Driver.NextResult(Int32 statementId, Boolean force)

   at MySql.Data.MySqlClient.MySqlDataReader.NextResult()

   at MySql.Data.MySqlClient.MySqlCommand.ExecuteReader(CommandBehavior behavior)

   at MySql.Data.MySqlClient.MySqlCommand.ExecuteNonQuery()

   at NetQoS.Data.MySqlDataComponentBase.ExecuteNonQuery(MySqlConnection connection, String sql, DataParameter[] dataParameters)

   at NetQoS.Data.MySqlDataComponentBase.ExecuteNonQuery(String sql)

   at NetQoS.ReporterAnalyzer.Data.ReporterAnalyzer.RouterDc.SyncInterfaceAndAgentCounts()

   at NetQoS.ReporterAnalyzer.Business.SystemMaintenance.SyncRouterInterfaceAndAgentCounts()

   at NetQoS.ReporterAnalyzer.Business.SystemMaintenance.MaintenanceTask.Run()

   at NetQoS.ReporterAnalyzer.Business.SystemMaintenance.Run()

   at NetQoS.ReporterAnalyzer.Business.SystemMaintenanceThread.ThreadHandler()

 

Environment:

NFA 9.3.2

 

Resolution:

Install the stored procedure by following the steps below on the NFA Console server:

1. Open a command prompt to the <Install Directory>\CA\NFA\REPORTER\SQL\install directory.

2. Run the following two commands, one at a time:

mysql reporter < routerInterfacesTriggers.sql 

mysql reporter < SyncRouterInterfaceAndAgentCountsExecute.sql

3. Recycle the 'NetQoS Reporter Manager Service'.

4. Check the <Install Directory>\CA\NFA\REPORTER\logs\ManagerService*.log to see if the error clears.