UIM 9.0.2 error during import snmp credential with xml file

Products

• 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