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

    Why isn't historic data showing up in reports or gadgets?

    Issue
    Data is not getting logged even though real time values show up in tables or diagrams. 

    Product Line
    PME7.x.x

    Environment
    Reports, Dashboards, 

    Cause
    Vista diagrams were linked to a device before it was enabled in Management Console. Vista uses an offline device configuration that builds a tree file which in turn causes default measurements to be mapped as custom quantities. 

    Resolution
    In order to resolve the incorrect configuration data stored in the database one can remove the data, and the system will automatically recreate the correct configuration data. 
    The following SQL commands consists of select statements which can be used to verify configuration data before making modifications to the database. Additionally, there are statements that will remove configuration data from the following tables: ION_Data.dbo.channel, ION_Data.dbo.RecorderState, ION_Data.dbo.Recorder,and ION_Network.dbo.IAS_MeasurementAddress. 

    *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. Stop ION Network Router Service
    2. Enter the following SQL commands

    (After each SQL statement click on Execute to run the command)

    With ION_Data as the source

    Use ION_Data

    SELECT * from source

    - make a note of the source id of the meter in this database and replace all istances of [SourceID]

    SELECT * from recorder WHERE SourceID=[SourceID]
    - make a note of the recorder id

    SELECT * from RecorderState WHERE RecorderId In (Select ID From Recorder where SourceId = [SourceID])

    SELECT * from Channel WHERE RecorderID In (Select ID From Recorder where SourceId = [SourceID])

    Users can remove the old data recorders using the following SQL statements entered inside the edit box in SQL Editor.

    DELETE from Channel WHERE RecorderID In (select ID from Recorder where SourceId=[SourceID])

    DELETE from RecorderState WHERE RecorderId In (Select ID From Recorder where SourceId = [SourceID]

    DELETE from Recorder WHERE SourceId= [SourceID]

    NOTE: one MUST remove the Channel and RecorderState before removing the Recorder due to how the database tables are structured. Do not delete the source.
     

    With ION_Network as the source
     
    USE ION_Network
     
    SELECT * from SRC_Source
    - make a note of the source id of the meter in this database

    DELETE from IAS_MeasurementAddress WHERE SourceId=[SourceID]
     
    1. Delete the associated tree file in /Power Monitoring Expert/config/trees
    2. Restart ION Network Router Service

    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