StruxureWare PowerMonitoring / Power Monitoring Expert (SPM/PME) - Problems editing/adding Data Series and with measurement groups in Dashboards

Issue
Attempting to Edit or Add to the Data Series for an existing gadget will present and 'Error loading measurements' message. When attempting to edit or create a new gadget that is restricted to Energy measurements, all measurements will be grouped in the 'Custom' section.

Product Line
StruxureWare Power Monitoring Expert

Environment
StruxureWare Power Monitoring 7, Power Monitoring Expert 7.2, Power Monitoring Expert 8, SQL Server 2008 R2, SQL Server 2012, SQL Server 2014

Cause
In a healthy system, this query will return no rows. If the metadata has not been entered correctly, the above query will return many rows. At this point the system will appear to function normally. It will be possible to create and modify the various Dashboard gadgets. However, if the StruxureWare Power Monitoring Expert installer is run a second time, perhaps to correct some other issue, the ApplicationsModules database will become corrupted.

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.

This article describes how to resolve a specific problem with the Dashboards part of StruxureWare Power Monitoring Expert. The problem is introduced at install time when the ApplicationModules database is created and populated. Under some circumstances, as yet unknown, some of the metadata associated with the various Topics gets duplicated. This condition can be detected by running the following query:

SELECT TargetId, MetadataName from Metadata.MetadataView
WHERE TargetType = 'Topic'
GROUP BY TargetId, MetadataName
HAVING COUNT(TargetId) > 1

It is possible to patch the ApplicationModules database by following the procedure below. This will allow the Dashboards that have already been created to be preserved. You will need to have the PME install disk available.

1. Take a backup of the Applications Modules database.
2. Shut down all ION and Schneider Windows services.
3. Execute the queries contained in the attached file 'fix_appmods_metadata.sql' by opening this file in SQL Server Management Studio and executing it against the ApplicationsModules database. (this clears out a number of tables in the database, but preserves the Dashboards configuration information).
4. Run the StruxureWare Power Monitoring Expert Installer, choosing 'Configure' from the list of options. Be sure to place the PME media in the same location as it was for the original install.

Once the above steps are complete, it will take some time for the dynamic ApplicationModules database tables, i.e. the ones populated at run time, to be repopulated to allow the Dashboards to become functional.