Technical FAQs

Ask a Question

How to Enable Duplicate Data Collection in Power Monitoring Expert

Issue
Meters at modem sites are synchronized each time they are connected. The longer the duration between connections, the larger the error in time synchronization. In the extreme case, this can result in missing or duplicated logs.  As a result the user wants to track duplicate records by logging them in the database.

Product Line
Power Monitoring Expert (PME)

Environment
SQL Server Management Studio

Cause
Duplicate data collection is disabled in Power Monitoring Expert by default.

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

To enable duplicate data collection, the parameter SaveDuplicates must be set to 1 in the dbo.Registry table in the ION_Data database, to do this:
  • Open Microsoft SQl Management Studio and expand the ION_Data database
  • Expand the Tables folder and right click on the dbo.Registry table and select Select Top 200 Rows (to edit the contents of the table) from the drop down menu
  • On the table that opens, change the Value of SaveDuplicates to 1.
Was this helpful?
What can we do to improve the information ?