After downgrading from nas 9.x to nas 8.x cannot open nas Configure GUI and the Alarm Window is empty

Document ID : KB000115629
Last Modified Date : 11/10/2018
Show Technical Document Details
Issue:
After downgrading from nas 9.x to nas 8.x, cannot open nas Configure GUI from Infrastructure Manager (IM) and the Alarm Window in IM is empty.

The ems probe version is 9.01 and not 10.17.
Environment:
UIM 8.51
ems 9.x
nas downgraded from 9.x to 8.x
Cause:
Change in schema used in local sqlite tables (in database.db and transactionlog.db) do not match those used in the tables in the UIM database
Resolution:
Full UIM alarm reset:

1.  Deactivate nas and alarm_enrichment probes
2.  Delete/Rename the local sqlite database files (database.db and transactionlog.db)
3.  Drop NAS tables in the UIM database:

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;

4.  Activate the alarm_enrichment and then the nas probe.