NFA Fails to sync with PC due SNMP profiles
Article ID: 216181
Updated On:
Products
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
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
Feedback
