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:
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.
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.
SELECT * FROM IAS_MeasurementAddress WHERE SourceID = 6
DELETE FROM IAS_MeasurementAddress WHERE SourceID = 6
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.
- Stop all the ION Services
- Run the following queries to remove IAS_MeasurementAddress entries for the device(s) in question.
- 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).
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.
- 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
SELECT * FROM IAS_MeasurementAddress WHERE SourceID = 6
- Run the delete query using the SourceID from Step 2.a.
DELETE FROM IAS_MeasurementAddress WHERE SourceID = 6
- Change the device type in the Management Console.
- 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.
Released for:Schneider Electric Saudi Arabia
