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.
UIM 9.0.2 error during import snmp credential with xml file
Article ID: 145317
Updated On:
Products
NIMSOFT PROBES
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`))
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.
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
Feedback
Yes
No
Powered by
