The NAS / EMS database schema contains a failed migration
Article ID: 275254
Updated On:
Products
Issue/Introduction
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?
Environment
Release : UIM 20.4
Cause
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.
Resolution
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:
NOTE:
As the alarms that are visible in the Operator Console are a replica from the alarms stored in the databse.db file (located in the NAS folder locally in the UIM server) by doing these steps no alarms will be lost. As soon as the NAS restarts the tables are re-built immeditatelly with the exact replica from the alarms that are visible in IM.
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.
Additional Information
Feedback
