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

    Alarms tab in PME Web stopped showing alarms

    Issue
    The 'Alarms' tab in PME web component does not show any alarms whether they have been acknowledged or not. Prioritizing on alarm date or priority does not have any effect either.
    All other components function as normal.

    Product Line
    Power Monitoring Expert Data Center 7.2.2 (PMEDC 7.2.2)
    This problem may not appear on most recent versions due to performance improvements as a result of changes for retrieving alarms.

    Environment
    PME Web

    Cause
    Too many events getting generated in the system. While the alarms tab may be able to display alarms for large number of events, at some point in time it may fail.

    Resolution
    *Warning: Irreparable database damage can occur. This procedure should only be performed by users familiar with SQL Server Management Studio and proficient in writing SQL statements. Databases should be backed up prior to performing this procedure.*

    Trim EventLog2 table (in ION_Data database) to less than 50,000 records.

    Recommendation is to delete the events prior to a specific date in batches, then test to see if it has fixed the problem. If not, change the date to more recent and remove more events. Repeat the process until the problem is fixed.
    Here is a couple queries to count and delete the events.

    This query returns the number of events prior to a specific date:
    select count(*) from EventLog2 where TimestampUTC < '2010-01-01'

    This query removes the events prior to a specific date:
    delete from EventLog2 where TimestampUTC < '2010-01-01'

    *Warning: The date in the above queries need to be adjusted.*

    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