Problems to sync NPC 6.2.103 with NFA 9.3.3

book

Article ID: 5414

calendar_today

Updated On:

Products

CA Network Flow Analysis (NetQos / NFA)

Issue/Introduction

DeviceManagerServiceLog:

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

[email protected](2): 0 snmp_profiles, full update [name=profiles] First Update
[email protected](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()

Cause

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

Environment

NFA 9.3.3NPC 6.2.103

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);