UIM 9.0.2 error during import snmp credential with xml file

Article Id: 145317

Status: Published

Updated On: 18-02-2020 10:13

Products:

DX Infrastructure Management , NIMSOFT PROBES , DX Infrastructure Management

Issue/Introduction:

following the documented procedure to import SNMP credentials via xml fails

We see a foreign key restrain in the discovery_server at loglevel 3

Cannot add or update a child row: a foreign key constraint fails (`ca_uim`.`cm_snmp_authentication`, CONSTRAINT `FK_CM_SNMP_AUTHENTICATION_CM_ACCOUNT` FOREIGN KEY (`account_id`) REFERENCES `cm_account` (`account_id`))

Cause:

When the Ctdgraph of snmp authentication profiles does not contain the account ID attribute, the discovery server is failing to handle it correctly.
It is trying to insert account 0 which doesn't exist in cm_account table and hence foreign key violation is happening.

Environment:

Release : 9.0.2

Component : UIM - DISCOVERY_SERVER

Resolution:

Discovery_server 9.0.2 HF2 adds a validation on the account ID attribute to verify that it is valid

Additional Information:

Issue not seen in UIM 9.20