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.