Data source is providing data for a reserved column: ItemID

Products

• CA Network Flow Analysis (NetQos / NFA)

Issue/Introduction

Problem:

Failure to synchronize a newly added NFA Console to NPC with the following error in the DeviceManagerServiceLog####-##-##.log:

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

Environment: 

NFA 9.3.3

NPC 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:

On the NFA Console Server:

1. Open a command prompt to a command line and run the following

 mysqldump reporter snmpprofiles > snmpprofiles.sql

2. Then run:

 mysql reporter
 truncate table snmpprofiles;

3. Then while still in the mysql command prompt run:

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

4. Open NPC > Admin >  Data Sources >  click the NFA radio button > Resync > Resync

 

 

Environment

Release:
Component: NQRPTA