Error on merging Interfaces

Products

• CA Network Flow Analysis (NetQos / NFA)

Issue/Introduction

I am getting an error attempting to merge interfaces and want to know if there is a solution / work around to this issue:

 

- Start and End time are not available for the interfaces.

at NetQoS.ReporterAnalyzer.Business.Agent.MergeValidation(UInt32 agentId1, UInt32 agentId2, Agent& srcAgent, Agent& dstAgent, Nullable`1& srcStart, Nullable`1& srcEnd, Nullable`1& dstStart, Nullable`1& dstEnd, Boolean& overlap)

   at NetQoS.ReporterAnalyzer.AuthorizationWebservices.RouterInterfaceWS.GetMergeInterfaces(String interfacesIds, Boolean& overlap)

 

 

 

Cause

This can occur if there were previous failed Merge attempts. These can leave null "resultcode" entries in the database_servers_scheduler table in the Reporter database in MySQL.

Environment

Component : NQRPTA - REPORTERANALYZER

Resolution

Run mysql queries to clear out the MERGE entries that did not contain a resultcode.

These commands are run on the NFA Console machine from a Command Prompt:

mysql -unetqos -pnetqos reporter

delete from database_servers_scheduler where resultcode not like '%SUCCEEDED%';

 

(Note that the above command is run on one line at the mysql prompt and ends with a ";" character. )


After, this, exit from the mysql window and recycle the ReporterAnalyzer Manager service (or reboot) before the next merge attempt.