Configuring first time Alarms processing

After a system upgrade, the Alarms Web application processes existing Events and Power Quality data the first time it starts up. You can control how much of the existing Power Quality data is processed by defining how far back in time you want the data to be processed.

The setting that controls the historical Power Quality data range to be processed is stored in the database. This setting defines the start date from which on the data is processed. The default start date is set to 1980-01-01 (yyyy-mm-dd).

notice

inoperable database

Back up the database before executing SQL scripts.

Failure to follow these instructions can result in an inoperable database and loss of data.

 

To change the start date for the Alarms data processing:

  1. On the PME server, open the Windows Services panel. Find the ION Log Subsystem Router Service and stop this service.
  2. On the PME database server, open SQL Server Management Studio (SSMS).
  3. Copy the following SQL script into a query window In SSMS:

    SELECT *
    FROM [ApplicationModules].[Configuration].[ConfigurationSettings]
    WHERE [Item] = 'Alarm Service Processing' ORDER BY [Key]

  4. Execute the script on the ApplicationModules database. This returns the settings for the Alarm Service Processing.
  5. Find the OldestConsideredPQEventTimeUtc setting in the Key column and check the date it is set to.
  6. Open a new query window in SSMS and copy in the following SQL script:

    UPDATE [ApplicationModules].[Configuration].[ConfigurationSettings]
    SET Value = 'Enter the start date in the format yyyy-mm-dd'
    WHERE [key]= 'OldestConsideredPQEventTimeUtc'

  7. Replace the Enter the start date in the format yyyy-mm-dd text with the start date for the data processing and then execute the script.
  8. Repeat steps 3-5 to review the updated start date.
  9. Close SSMS.
  10. Open the Windows Services panel. Find the ION Log Subsystem Router Service and start this service.

When you open the Alarms Web application for the first time, it will start processing existing power quality events starting with the date you set above.