NPC Syncronization fails with reserved column message

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

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