Issue
When viewing the Alarms tab in Power Monitoring Expert (PME), some alarms are stuck in an active state even though they no longer have active conditions. These alarms also do not show up in in Management Console's Deactivate Alarms tool.
Product Line
Power Monitoring Expert 9.0
Power Monitoring Expert 2020
Environment
Web Applications "Alarms" tab
Cause
The Alarm is still showing as active because the dropout condition for the alarm was never logged.
Resolution
First double-check to make sure the alarms you want to deactivate meet inactive conditions. After checking, go into Management Console -> Tools -> Deactivate Alarms -> Load Active Alarms. If the alarm shows up then deactivate it here. If not, determine the exact alarms that need to be deactivated from Alarm Viewer in the Web Applications. Note the Name, Type, Category, and Priority of the alarm. Then connect to SQL Server Management Studio.
*Warning: Irreparable database damage can occur. This procedure should only be performed by users familiar with SQL Server Management Studio. Databases should be backed up prior to performing this procedure.* Be sure to back up the ION_DATA database before running any SQL queries
SELECT * FROM vAlarmDefinition
UPDATE AlarmDefinition SET isActive = 0 WHERE (isActive = 1 AND Category = 'ALM_GENERIC_SETPOINT' AND Priority = 192 AND SourceID = 7);
When viewing the Alarms tab in Power Monitoring Expert (PME), some alarms are stuck in an active state even though they no longer have active conditions. These alarms also do not show up in in Management Console's Deactivate Alarms tool.
Product Line
Power Monitoring Expert 9.0
Power Monitoring Expert 2020
Environment
Web Applications "Alarms" tab
Cause
The Alarm is still showing as active because the dropout condition for the alarm was never logged.
Resolution
First double-check to make sure the alarms you want to deactivate meet inactive conditions. After checking, go into Management Console -> Tools -> Deactivate Alarms -> Load Active Alarms. If the alarm shows up then deactivate it here. If not, determine the exact alarms that need to be deactivated from Alarm Viewer in the Web Applications. Note the Name, Type, Category, and Priority of the alarm. Then connect to SQL Server Management Studio.
*Warning: Irreparable database damage can occur. This procedure should only be performed by users familiar with SQL Server Management Studio. Databases should be backed up prior to performing this procedure.* Be sure to back up the ION_DATA database before running any SQL queries
- In SQL expand Databases, ION_Data, and views.
- Right-click on dbo.vAlarmDefinition and click Select Top 1000 Rows.
- Locate the alarm the needs to be deactivated.
- Note the SourceID, Category, Priority, and that isActive is equal to 1.
- Open a new query by: File -> New -> Query with Current Connection.
- In the new query past the script below and change the SourceID, Category, and Priority to match the desired alarm parameters.
- Execute this query by pressing the green triangle next to the word Execute.
- Back in the Web Application refresh the alarms page and the alarm will have switch to not being active.
- Repeat these steps for all the alarms desired for deactivation
SELECT * FROM vAlarmDefinition
UPDATE AlarmDefinition SET isActive = 0 WHERE (isActive = 1 AND Category = 'ALM_GENERIC_SETPOINT' AND Priority = 192 AND SourceID = 7);
Released for:Schneider Electric Thailand
