Duplicate Data logging

Data records are considered duplicates if more than one record exists for the same measurement on the same source at the same time. There are different possible causes for duplicate data in a system, such as faulty devices, incorrect device configuration, or incorrect device time synchronization.

By default, PME does not log duplicate data records in the historical database. It logs one of the duplicate records in the database, and removes the other records.

Under certain circumstances, for example for audit reasons, or billing applications, it might be desirable to log all duplicate records. For these applications, PME provides the option to enable duplicate data logging.

notice

LOSS of data

Back up the database before making manual database edits.

Failure to follow these instructions can result in permanent loss of data.

To enable duplicate data collection, set the SaveDuplicates parameter, in the dbo.Registry table in the ION_Data database, to 1.

NOTE: The duplicate entries are stored in the DataLog2Duplicate table in the ION_Data database. You can access this data through the following reports, or through direct database access: Trend Report, Tabular Report, Data Export - Standard, and Data Export - Extended.