ALERT: Some images may not load properly within the Knowledge Base Article. If you see a broken image, please right-click and select 'Open image in a new tab'. We apologize for this inconvenience.

NPC Syncronization fails with reserved column message


Article ID: 4860


Updated On:


CA Network Flow Analysis (NetQos / NFA)


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 .



the reporter.snmpprofile table is empty ;

So , the connection NPC to NFA console fails ;

but the connection NFA console to NPC is still runnning .


Win2008R2 .NFA 9.3.3NPC 6.2


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



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