Discover our Clipsal Smart Home packages as seen on The Block 2018

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

    New data for some measurements is not being uploaded in PME, after replacing a meter with a different device type,

    Issue
    Data for any measurements logged by the PM8000 that had also been logged by the CM4000 are not being processed properly. The follow errors are seen in the ION_SystemLog: Timestamp: 9/9/2016 1:57:37.387 PM
    Priority: WARNING
    Source: LOGINSERTER.STANDALONE
    Target:
    Category: Computer Configuration
    Computer: STANDALONE
    Description: Unable to process records for Recorder 0x809@TEST.SWAPOUT. Class ID has not been retrieved for 0x9c01301@TEST.SWAPOUT.


    Product Line
    Power Monitoring Expert 7.2.2, 8.0, 8.1
    CM4000
    PM8000

    Environment
    Meter Replacement

    Cause
    In this particular example, 0x9c01301 is an ION handle from the old CM4000 and does not exist on the new PM8000. This error prevents the log inserter from processing any inputs to the Data Recorder on the PM8000 with ION handle 0x809.


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

    It is possible to physically replace a meter with a meter of a different device type, such as replacing a CM4000 with a PM8000. In order to stop the error above and allow the Log Inserter to properly process the PM8000 data, entries in the IAS_MeasurementAddress table in ION_Network that reference this SourceID must be deleted.


    Recommended procedure for meter swap outs:
    After the device has been physically swapped out, prior to changing the device type in the Management Console.

    Note: This example will use an ION7650 and all red text will need to be replaced by the given scenario's information.
    1. Stop all the ION Services
    2. Run the following queries to remove IAS_MeasurementAddress entries for the device(s) in question. 
      1. Find the SourceID. Fill in the device name in the Group.Name format for the device you have swapped out as displayed in the Management Console (NOT the System Name).
    USE ION_Network
    SELECT SourceID FROM SRC_Source WHERE DisplayName = 'Group1.ION7650'

    For Example:

    The following queries will use 6 as an example SourceID, but it needs to be replaced the device's SourceID.
    1. It is recommended that a SELECT query be run prior to running the DELETE query to verify that the rows being deleted are the ones that should be deleted. Use the SourceID from the previous step
    USE ION_Network
    SELECT * FROM IAS_MeasurementAddress WHERE SourceID = 6
    1. Run the delete query using the SourceID from Step 2.a.
    USE ION_Network
    DELETE FROM IAS_MeasurementAddress WHERE SourceID = 6
    1. Change the device type in the Management Console.
    2. Start the ION services.

    Note: When configuring a Data Log viewer in Vista, you will still see all the old data recorders associated with the old device. This may be OK if you want to see old data that was logged by the old device and is not being logged by the new device.

    This problem has been addressed in the PME 8.2 release such that no manual database manipulation is required.

    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