alarms missing from Operator Console - ORA-00904 error in nas.log

Products

• DX Unified Infrastructure Management (Nimsoft / UIM)

Issue/Introduction

Some alerts which are present in the Infrastructure Manager alarm console are missing from Operator Console.

The nas.log shows an error for these alarms:

 [ndbOracleExecuteInternal]- Error: ndbOracleExecuteInternal  OCI_ERROR - ORA-00904: "EXTERNALID": invalid identifier

 

Environment

DX UIM 23.4.3 running NAS 23.4.4.1
Oracle Database 

 

Cause

This error occurs if the NAS backend tables do not get upgraded successfully when deploying NAS 23.4.4 or higher to a DX UIM 23.4.3 system.

Normally these tables are upgraded when a new NAS version is deployed but in some cases this may not succeed.

Resolution

1. deactivate the alarm_enrichment probe, followed by the nas probe.
2. issue the following queries on the Oracle database:
      DROP TABLE NAS_VERSION;
      DROP TABLE NAS_ALARMS;
      DROP TABLE NAS_TRANSACTION_SUMMARY;
      DROP TABLE NAS_TRANSACTION_LOG;
      DROP TABLE NAS_NOTES;
      DROP TABLE NAS_ALARM_NOTE;
3. activate alarm_enrichment, followed by nas

 

This will force the tables to be re-created with the correct columns.

Additional Information

NOTE: Always ensure you have taken a backup of the database before making any manual alterations such as dropping or altering tables!