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