After upgrading UIM to a new version, we noticed 2 alarms in Operator Console (OC) that are not appearing in IM.
We are also unable to delete them / acknowledge them:
The EMS database schema contains a failed migration: Error while retrieving the list of applied migrations from metadata table [dbo].[ems_database_migrations]
The NAS database schema contains a failed migration: Error while retrieving the list of applied migrations from metadata table [dbo].[nas_database_migrations]
The nas and the EMS logs did not show any sign of any issue.
What do these alarms mean?
Should we worry?
Release : UIM 20.4
As long as these messages are not reappearing and as long the NAS and EMS are up and running and not showing any failures, these alarms do not indicate any real failure. If after having the NAS to rebuild the tables from a restart (after dropping them) the alarms are gone it can be safely assumed the alarms were temporary alarms that were possibly hung during the patching. If any issues related to alarms let Broadcom support know.
Follow the steps below to resolve this issue:
1. Stop nas, alarm_enrichment, and ems
2. Using MS Management Studio or a similar DB Editor DROP the following tables from the DB:
DROP TABLE NAS_ALARMS;
DROP TABLE NAS_TRANSACTION_SUMMARY;
DROP TABLE NAS_TRANSACTION_LOG;
DROP TABLE NAS_ALARM_NOTE;
DROP TABLE NAS_NOTES;
DROP TABLE NAS_VERSION;
3. Start alarm_enrichment, nas and ems (in this order) and immediately the alarms should now show correctly in OC.
the EMS and NAS "failed Migration" alarms should no longer be visible and you should be able to aknowledge alarms correctly.