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