Technical FAQs

Ask a Question

Why do any changes made in Management Console take a while to update in the PME Web Applications?

Issue:
When changes are made in Management Console (New Devices, Device Renames, Changed Device Type, Logical Device changes, etc), a user has to wait in order to see these changes in PME Web Applications (Dashboards, Trends, Realtime Tables, AAV, Alarm Configuration and Hierarchy Manager). 

Product Line:
Power Monitoring Expert 7.2.x
Power Monitoring Expert 8.x

Environment:
Power Monitoring Expert Software Configuration

Cause:

In a normal working PME, the following rules apply to how data is "propagated" through the system:

  • Any change in Management Console (Device changes OR new Custom Measurement detection) will be applied to AppMods every 5 minutes (or when the AppMods services are restarted)
  • Any UI application that shows a list of Sources/Measurements (not counting Reporter) will cache their the list results for 15 minutes.
  • This implies a worst case delay of 20 minutes (15+5) before you see your changes in PME. 
  • The steps below simply short circuit the logic to instantly have AppMods updated and all application cache values purged.

Resolution:

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.*

 1. In SQL Management Studio, run the following script (this is a safe script to run):

USE [ApplicationModules]
-- This script will clear the ApplicationModules provider cache.  It is
-- safe to run as often as you like! 
DELETE FROM [ApplicationModules].DataStore.TicketResultReference
DELETE FROM [ApplicationModules].DataStore.TicketResult
GO

 2. Restart service "ApplicationHost CoreServices"

 3. Wait 10 seconds, then refresh the PME Web application in the browser that you want updated.

Was this helpful?
What can we do to improve the information ?