search cancel

NFA Fails to sync with PC due SNMP profiles

book

Article ID: 216181

calendar_today

Updated On:

Products

CA Network Flow Analysis (NetQos / NFA)

Issue/Introduction

CAPC message:
 ERROR | pool-2-thread-4         | 2021-05-19 12:32:35,104 | com.ca.im.portal.dm.productsync.DataSourcePoller                
 Data source Network Flow [email protected] encountered an error while processing a sync request. The problem is in the data source, not CAPC. Check the logs for the data source to determine the cause of the problem. The following stack trace shows the context of the sync request:
 javax.xml.ws.soap.SOAPFaultException: System.Web.Services.Protocols.SoapException: Server was unable to process request. ---> System.Reflection.TargetInvocationException: Exception has been thrown by the target of an invocation. ---> NetQoS.ReporterAnalyzer.i18n.i18nException: Exception has been thrown by the target of an invocation. ---> System.Reflection.TargetInvocationException: Exception has been thrown by the target of an invocation. ---> System.ArgumentException: Must specify valid information for parsing in the string.

NFA message error:
ProductSyncWsLog*.log
8:20:12 5 - Pull: Checking for updated profiles...
8:20:12 3 - Pull - :
Must specify valid information for parsing in the string.
System.ArgumentException: Must specify valid information for parsing in the string.
  at System.Enum.TryParseEnum(Type enumType, String value, Boolean ignoreCase, EnumResult& parseResult)
  at System.Enum.Parse(Type enumType, String value, Boolean ignoreCase)
  at NetQoS.ReporterAnalyzer.Business.SnmpProfile.InitializeFromDataRow(DataRow r)
  at NetQoS.ReporterAnalyzer.Business.SnmpProfile.GetAllFromDT(DataTable dt)
  at NetQoS.ReporterAnalyzer.Business.SnmpProfile.GetByUpdatedOn(DateTime startTime, DateTime endTime)
  at NetQoS.ReporterAnalyzer.Business.ProductSync.Sync.Pull_Item_Profiles(PullDataHandlerState state, SyncTime syncTime, SyncUpdateState sus)
  at NetQoS.ReporterAnalyzer.Business.ProductSync.Sync.PullRequest(SyncTime syncTime, SyncUpdateState syncUpdateState)

PollerSyncLog*.log:
8:20:20 5 - PollerSync: [email protected]: Pushing profiles because profiles updated
8:20:20 3 - PollerSync: Failed to sync profiles with [email protected] because Must specify valid information for parsing in the string.. Enable debug logging for details.

Environment

Release : 10.0

Component : NQRPTA - REPORTERANALYZER

Cause

NFA is not understanding either the auth or priv protocol PC is sending.

Resolution

On NFA Console Server, open the Command Prompt, call the mysql and run:

1) This will show the number of auth/priv combos
mysql> select authprotocol, privprotocol, count(*) from snmpprofiles group by 1,2;


+--------------+--------------+----------+
| authprotocol | privprotocol | count(*) |
+--------------+--------------+----------+
|              | None         |     1130 |
| None         | None         |    34825 |
| MD5          | DES          |    15504 |
| SHA          | DES          |    31553 |
| SHA2_512     | DES          |       14 |
+--------------+--------------+----------+
5 rows in set (0.00 sec)

2) Remove authprotocol in black
mysql> delete from snmpprofiles where authprotocol = "";
Query OK, 1130 row affected (0.00 sec)

mysql> select id, name, authprotocol from snmpprofiles where authprotocol = "";
Empty set (0.00 sec)

mysql> select authprotocol, privprotocol, count(*) from snmpprofiles group by 1,2;
+--------------+--------------+----------+
| None         | None         |    34825 |
| MD5          | DES          |    15504 |
| SHA          | DES          |    31553 |
| SHA2_512     | DES          |       14 |
+--------------+--------------+----------+
4 rows in set (0.00 sec)
mysql>

Perform Full resync and the problem was fixed

Resolution:
=========

delete from snmpprofiles where authprotocol = "";

Perform the NFA Full Resynchronization

 

Additional Information

Pay Attention: BACKUP before:

C:\>mysqldump -P 3308 harvester > C:\CA\NFA\backup\harvester_backup.sql

C:\>mysqldump -P 3308 reporter > C:\CA\NFA\backup\reporter_backup.sql