Problems to sync NPC 6.2.103 with NFA 9.3.3

Document ID : KB000005414
Last Modified Date : 14/02/2018
Show Technical Document Details
Issue:

DeviceManagerServiceLog:

=================

Reporter@srvmon09(2): 0 snmp_profiles, full update [name=profiles] First Update
Reporter@srvmon09(2) - Polling Phase :
Data source is providing data for a reserved column: ItemID
System.ArgumentException: Data source is providing data for a reserved column: ItemID
at NetQoS.Services.DataSources2.DataSource2.ProcessStandardTableUpdate(IDBConnection db, DataSourcePoller dsp, SyncUpdateTable sut, UInt32 utcUpdateTime, UInt32 lastSyncTime, Int64 clockDrift, Boolean checkNulls, Boolean checkChanges)
at NetQoS.Services.DataSources2.DataSource2.ProcessItemTables(IDBConnection db, DataSourcePoller dsp, SyncUpdateTable sut, UInt32 utcUpdateTime, UInt32 lastSyncTime, Int64 clockDrift, SyncTime syncTime, Boolean shouldPrepareTables)
at NetQoS.Services.DataSources2.DataSource2.PullSynchronize(IDBConnection db, DataSourcePoller dsp, UInt32 utcUpdateTime, UInt32 lastSyncTime)
at NetQoS.Services.DataSources2.DataSourcePoller.ThreadProc()

Environment:
NFA 9.3.3NPC 6.2.103
Cause:

This is generally an indication that there is a problem with the SNMP profiles table on the NFA Console machine.

Resolution:

It is important to have one valid profile in NFA to allow the sync with PC.


1  - TRUNCATE reporter.snmpprofiles

2  - INSERT INTO `snmpprofiles` (`id`, `itemId`, ame`, `version`, `port`, `userName`, `context`, `security`, `authProtocol`, `authPassword`, `privProtocol`, `privPassword`, `enabled`, `updatedOn`, `modifiedOn`, `rank`, `tenantId`) VALUES (4, 10, 'public', 2, 161, 0x03CCDDC667DC214461DBC6BEB3C1C23C, '', 'NoAuthNoPriv', 'None', 0x2225B4D8E7C03D5C503601A8E534FC5C, 'None', 0x2225B4D8E7C03D5C503601A8E534FC5C, 'Y', 0, NULL, 100, 8);