How to change a device connection type from serial to ethernet or ethernet to serial while retaining data in PME

Issue
The device connection was connected using a serial/ethernet connection and now it's connected using the opposite method. The user would like to change the connection type while retaining the historical data in PME.

Production Line
Struxureware Power Monitoring
ION Enterprise
Power Monitoring Expert 7.2
Power Monitoring Expert 8.x
Power Monitoring Expert 9.x
Power Monitoring Expert 2020
Power Monitoring Expert 2021
Power Monitoring Expert 2022
Power Monitoring Expert 2023


Environment
Management Console

Resolution
To change the connection type:

1. Back up the ION_Network, ION_Data, and ApplicationModules databases as a precaution.
2. Stop all the ION and Application Module services
3. Accurately note down the exact device name as it shows in PME "Group. Name" (ie: MainBuilding.Feeder1)

NOTE: There is a chance that the display name is not the same as the actual source name if the device was "Renamed" after it was added. To confirm the source name, please navigate into SSMS and go to the ION Network - "dbo.SRC_Source" table. In this table will be a "Name" and "Display Name" column. The "Name" column is what you will want to be sure you record for when you read the device later on to ensure proper historical data transfer. It can be renamed again afterward.

4. Delete the serial/ethernet device from the management console by right-clicking on the device in the device list.

5. Re-add the device as an ethernet/serial device making sure that the group and name are exactly the same. In this example: MainBuilding.Feeder1.

6. Restart the ION and ApplicationModules services.

The Log Inserter will use the existing entries in the Source table (ION_Data), SRC_Source table (ION_Network), and DataSourceBus.DataSourceDevice/DataSourceBus.LogicalDevice tables (ApplicationModules) so that the historical data will be continuous and everything referencing this device will carry on as it did before.

Released for:Schneider Electric Canada