Issue
The Power Monitoring Expert (PME) system had device types added to the system that now need to be removed, i.e., so they do not show up in the device selection list any longer.

Product line

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

Power Monitoring Expert 2024

Environment
Power Monitoring Expert (PME)

SQL Server Management Studio (SSMS)

Cause

To remove a device type from PME, changes need to be made to the PME databases.

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. All references to the device type need to be removed from PME. To delete any devices referencing the device type follow the steps for your PME version in https://www.se.com/us/en/faqs/FA210105/

   1. Note If the data needs to be re-assigned to a different source follow https://www.se.com/us/en/faqs/FA271539/
      
      

1. Using SQL Server Management Studio (SSMS), connect to the PME instance and execute the below query (select "new query", in the empty window, paste the code sample below, and select "execute query").
   1. Replace the text "devicetype display name" with the device type name as it appears in the management console selection list. Do not delete the percentage symbols. Leave the last two lines commented. Select "execute" to execute the query.
   2. In the results window, confirm the device type that appears is the type you would like to delete. If there are driver files, confirm they are the expected files in the TreeFile and MapFile columns. Make note of the ID in the "ID" column.
   3. Replace the text "<DEVICETYPEID>" with the ID found in the previous step.
   4. Uncomment the last two lines of the query by deleting the '--' symbols, and re-execute the query. This will remove the device type from the databases and it will no longer be an option in the device type selection list.

      Select * FROM [ION_Network].[dbo].[DeviceType] where DisplayName LIKE '%devicetype display name%'
      
      -- DELETE FROM [ION_Network].[dbo].[DeviceType]
      -- WHERE ID = <DEVICETYPEID>

2. Delete the registries for the device type manually. Using windows search, search "regedit" and locate the key for your device type in the location Computer\HKEY_LOCAL_MACHINE\SOFTWARE\WOW6432Node\Schneider Electric\Power Monitoring Expert\[PME version number]\DeviceInfo\[devicetype]
   
   
3. Optionally, the drivers can be removed from the Power Monitoring Expert folder

Publicerad för:Schneider Electric Sverige