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)
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.
Component : NQRPTA - REPORTERANALYZER
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.