Issue:
A device is renamed in PME and subsequently renamed in EEM. However, after running the DatabaseLoader -Pairs job, the old device name reappears in the EEM system.
Product Line:
ION EEM 4.0 R2, 5.0
Power Monitoring Expert 7.2.x, 8.x
Environment:
Device Names
Cause:
In Power Monitoring Expert 7.2, a more user friendly renaming feature was added to allow a device to be renamed in Management Console without having to stop services and run queries to modify the database. In order to maintain continuity with existing Vista and Designer diagram links, an addition column was added to the Source table where this new meter name was stored. Therefore when looking at the Source table for a meter that has been renamed, it will actually have two names. The "Name" column has the original name when the device was first added, and the "DisplayName" which is what the device has been renamed to.
The Stored Procedures that ION EEM uses to query the PME database reference the "Name" column rather than the "DisplayName". Therefore the DatabaseLoader thinks the original device name is a new source, because that name does not exist in the EEM database anymore due to it having been renamed.
Resolution:
The attached .sql queries will update the two stored procedures in the PME database so that the "DisplayName" column is queried rather than the "Name" column. This will prevent EEM from importing the original name of a device that has been renamed in PME. *NOTE: If a device has been renamed in PME, but not yet renamed in EEM, it is recommended to rename the device in EEM prior to running these queries.
*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) On the SQL server that contains the PME ION_Data database, open SQL Server Management Studio.
2) Open one of the attached .sql files and execute it.
3) When the query completes, repeat the process for the second .sql file.
Once both queries have run, EEM will now query the ION_Data database for the device name as it appears in Management Console, rather than the name it was originally given when added to PME.
A device is renamed in PME and subsequently renamed in EEM. However, after running the DatabaseLoader -Pairs job, the old device name reappears in the EEM system.
Product Line:
ION EEM 4.0 R2, 5.0
Power Monitoring Expert 7.2.x, 8.x
Environment:
Device Names
Cause:
In Power Monitoring Expert 7.2, a more user friendly renaming feature was added to allow a device to be renamed in Management Console without having to stop services and run queries to modify the database. In order to maintain continuity with existing Vista and Designer diagram links, an addition column was added to the Source table where this new meter name was stored. Therefore when looking at the Source table for a meter that has been renamed, it will actually have two names. The "Name" column has the original name when the device was first added, and the "DisplayName" which is what the device has been renamed to.
The Stored Procedures that ION EEM uses to query the PME database reference the "Name" column rather than the "DisplayName". Therefore the DatabaseLoader thinks the original device name is a new source, because that name does not exist in the EEM database anymore due to it having been renamed.
Resolution:
The attached .sql queries will update the two stored procedures in the PME database so that the "DisplayName" column is queried rather than the "Name" column. This will prevent EEM from importing the original name of a device that has been renamed in PME. *NOTE: If a device has been renamed in PME, but not yet renamed in EEM, it is recommended to rename the device in EEM prior to running these queries.
*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) On the SQL server that contains the PME ION_Data database, open SQL Server Management Studio.
2) Open one of the attached .sql files and execute it.
3) When the query completes, repeat the process for the second .sql file.
Once both queries have run, EEM will now query the ION_Data database for the device name as it appears in Management Console, rather than the name it was originally given when added to PME.
Released for:Schneider Electric USA
