NPC Syncronization fails with reserved column message

Products

• CA Network Flow Analysis (NetQos / NFA)

Issue/Introduction

NPC synchronization with the NFA console  is failing with the error :

  "Data source is providing data for a reserved column: itemID"

customer followed the TEC1157776 but when he tries to add the public snmp profile from the NFA console , he is

redirected to the NPC snmp profile panel where all profiles are well displayed .

 

Environment

Win2008R2 .NFA 9.3.3NPC 6.2

Cause

the reporter.snmpprofile table is empty ;

So , the connection NPC to NFA console fails ;

but the connection NFA console to NPC is still runnning .

Resolution

Manually add an snmp profile in the reporter.snmpprofile table using the sql cmd :

mysql reporter

INSERT INTO `snmpprofiles` VALUES (4,145,'public',2,161,'...................','','NoAuthNoPriv','None',NULL,'None',NULL,'Y',1431025738,1431025767,3,8);

quit

 

then resynchronize the NFA console from the datasources panel of the NPC console