Search FAQs
Power Monitoring Expert 7.2.2 - Measurement Selector is blank when creating reports
Issue:
When creating a report in Power Monitoring Expert 7.2.2, the measurement selector is blank and contains no measurements to select. The ION System Log contains the following error every time the Measurement Selector is brought up:
ID: 3775564
Timestamp: 7/7/2014 3:42:42.813 PM
Priority: ERROR
Source: ReportView_MeasurementHierarchy
Target: /reporter/Core/PopupFramework/GenericPopupInputFramework.aspx
Category: Reporting View
Computer: BRACKETTVILLEIO
Description: Violation of UNIQUE KEY constraint 'UQ__#61F1515__D64A412663D999CC'. Cannot insert duplicate key in object 'dbo.@MeasurementUnits'. The duplicate key value is (http://rddl.xmlinside.net/PowerMeasurement/configuration/measurement/1/#Average%20Voltage%20Line-to-Line%20High).
Product Line:
Power Monitoring Expert 7.2.2
Environment:
Power Monitoring Expert 7.2.2 Web Applications - Reporting
Cause:
There is a known issue when upgrading from PME 7.2.1 to PME 7.2.2 that causes duplicate entries in the dbo.TS_Triplets table in the ION_Network database. These duplicate entries prevent the measurement selector from querying the necessary measurements.
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.*
1. Backup the ION_Network Database
2. Run the following query against the ION_Network database.
When creating a report in Power Monitoring Expert 7.2.2, the measurement selector is blank and contains no measurements to select. The ION System Log contains the following error every time the Measurement Selector is brought up:
ID: 3775564
Timestamp: 7/7/2014 3:42:42.813 PM
Priority: ERROR
Source: ReportView_MeasurementHierarchy
Target: /reporter/Core/PopupFramework/GenericPopupInputFramework.aspx
Category: Reporting View
Computer: BRACKETTVILLEIO
Description: Violation of UNIQUE KEY constraint 'UQ__#61F1515__D64A412663D999CC'. Cannot insert duplicate key in object 'dbo.@MeasurementUnits'. The duplicate key value is (http://rddl.xmlinside.net/PowerMeasurement/configuration/measurement/1/#Average%20Voltage%20Line-to-Line%20High).
Product Line:
Power Monitoring Expert 7.2.2
Environment:
Power Monitoring Expert 7.2.2 Web Applications - Reporting
Cause:
There is a known issue when upgrading from PME 7.2.1 to PME 7.2.2 that causes duplicate entries in the dbo.TS_Triplets table in the ION_Network database. These duplicate entries prevent the measurement selector from querying the necessary measurements.
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.*
1. Backup the ION_Network Database
2. Run the following query against the ION_Network database.
USE ION_Network
DELETE FROM TS_Triples
DELETE FROM TS_Triples
WHERE ID IN
(
SELECT
MAX(ID)
FROM [ION_Network].[dbo].TS_Triples
Group By
[Subject]
,[Predicate]
,[Object]
,[IsLiteral]
HAVING COUNT(*) > 1)
Released for:Schneider Electric United Arab Emirates
Explore more
Explore more
