nas alarms are not 'in sync' between UMP (USM) and Infrastructure Manager (IM)

book

Article ID: 142778

calendar_today

Updated On:

Products

DX Infrastructure Management NIMSOFT PROBES

Issue/Introduction

In UMP USM, it may appear that nas alarms/total alarm counts are out of sync with the Infrastructure Manager alarm subconsole.  Sometimes the local NAS database becomes 'out of sync' with the backend UIM database.

Cause

- various including the size/integrity of the nas db files/nas tables

Environment

- UIM v8.x or higher

- nas 8.x or higher

Resolution

In the Infrastructure Manager, the alarm subconsole shows one set of alarms and USM is displaying another set of alarms and the total alarm Count is NOT the same or close.

Please note that USM only shows alarms for those systems that belong to a group. If you have systems that are not in a GROUP then these alarms will not show and this Article may not apply.

First, to verify all systems are present in a group, in USM create a Dynamic group containing all systems with the following filter:

create a Group with a filter of:

'not ip address is null'

Save it, then select the top-level ‘Groups’ icon and click on the Alarms tab to see if the alarm counts are now closer between the nas and IM alarm subconsole.
 
If the alarm count is not the same or at least close, then take the following steps.

1. Deactivate the alarm_enrichment and nas probe
2. Drop the nas tables listed below from database using SQL Management studio 
 
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 the alarm_enrichment and nas probe

When you activate the nas, it should recreate all of the tables and sync them properly with the existing alarms that appear in IM.

If this does not resolve the issue, it is possible that the local NAS database files have become corrupted.   If that is the case, you can take the following steps:

1. Deactivate the alarm_enrichment and nas probe
2. Drop the nas tables listed below.
 
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. Rename the following files in the <nimsoft>\probes\service\nas directory to something like .db.old in order to preserve them while setting them aside.
 
    transactionlog.db
    database.db
    nisQueue.db (if it exists)
 

4. Activate the alarm_enrichment and nas probe

When you activate the nas, it should recreate those two files, and all of the tables and sync them properly.

NOTE: Renaming the .db files above will cause the complete "reset" of all alarms in the environment.  If you have integrated your NAS with external systems/ticketing systems/etc please be aware that on the next polling cycle, all of the previously alarms which are still active will come in again, which could cause new/duplicate tickets to be created.  Please be aware of this and take steps to mitigate (such as temporarily disabling such integrations until the alarms regenerate.)

Additional Information

Where are the alarms stored in UIM?

What do the time related fields mean in the Alarm Tables in UIM?

nas Transaction Logging/Transaction Summary and compression

What is the meaning of the of nas alarm Subjects?

Nas alarm counts are not in sync between UMP USM and the Infrastructure Manager alarm subconsole

Why do some alarms' "count" increase immediately in the alarm console while others don't show the count increasing even when the alarms are suppressed?
Nas (alarm server) documentation