Discover our Clipsal Smart Home packages as seen on the Block

in location

OR

I'm looking for

  • Wholesalers
    • Uncheck All Check All
  • EXPERTISE
    • Expand
    • Expand
    • Expand
    • Uncheck All Check All
  • Switchboard Manufacturers
    • Uncheck All Check All
OR

The best way to see what Clipsal electric products can do for your home is seeing them in action at a Clipsal Display Centre.

Product stock may vary according to location. If you're after a specific product range, please check with your chosen location before visiting.

10 Results
    Load More Load Complete
    Change Location

    Power Monitoring Expert Active Alarm count shows 0

    Issue
    Alarm count on the web application page does not update even when a known alarm has been generated

    Product
    Power Monitoring Expert 7.2.x (PME)
    Power Monitoring Expert 8.0

    Environment
    Web Application

    Running the following query against the ION_Data Database takes longer than 30 Seconds:
    exec sp_executesql N'SELECT CAST( ISNULL(MAX([ID]),0) AS INT) AS updateId, getutcdate() AS updateTime FROM [dbo].[EventLog2];select top 1000 * FROM dbo.vAlarmLog  where ((Type = 1 AND EndId IS NULL) OR (AckTimeUTC IS NULL)) and (Priority >= @PriorityLow) and (Priority <= @PriorityHigh) order by ID desc',N'@PriorityLow int,@PriorityHigh int',@PriorityLow=64,@PriorityHigh=255

    Resolution

    Reduce the number of events in the Eventlog2 table. This can be done with an archive and trim of the Events.

    *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) Open the atabase Manager in Management Console

    2) Login with a supervisor level user in PME

    3) Under databases, right click ION_data and select either trim or Archive. If using Archive make sure that "Remove archived data from live database" is checked

    4) Under data types, make sure only Events are selected

    5) Run the archive or trim to remove data from the EventLog2 table

    Note: In later versions of PME, the Active Alarm count is based on a different table in ION_Data called Alarm log

    Didn’t find what you were looking for?

    Try Searching Again View Our Categories

    Need further assistance?

    Our Customer Care department provides total customer service solutions for our residential, industrial and commercial applications.

    Get Assistance