search cancel

UIM 9.0.2 error during import snmp credential with xml file

book

Article ID: 145317

calendar_today

Updated On:

Products

DX Unified Infrastructure Management (Nimsoft / UIM)

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

 

Environment

Release : 9.0.2

Component : UIM - DISCOVERY_SERVER

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.

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