Operator Console - viewing alarm history doesn't finish loading, gets stuck on Loading screen

Products

• DX Unified Infrastructure Management (Nimsoft / UIM)

Issue/Introduction

In Operator Console, when viewing an alarm and selecting history, the history will never load, but just get stuck on Loading..

Environment

Release : 20.3

Component : UIM NAS

Cause

missing table

Resolution

The alarmviewer-api logs (located at /nimsoft/probes/service/wasp/logs/ on the OC machine) showed an error, ORA-00942 for missing table on query for NAS_TRANSACTION_LOG.

Run the following process to rebuild the tables:

- stop NAS probe

- issue these queries on the SQL database:

DROP TABLE NAS_ALARMS;

DROP TABLE NAS_TRANSACTION_LOG;

DROP TABLE NAS_TRANSACTION_SUMMARY;

If using Oracle, also issue:

COMMIT;

- activate NAS

Once NAS is activated it will rebuild and repopulate these three tables and the issue will be resolved.