Power Monitoring Expert (PME) "There was an error attempting to load the Source Measurement list from the server." No real-time data available in Dashboard's Table Gadget.

Issue
PME web applications give an error in alarms, dashboards, and diagrams when the Web app is opened/when the user tries to add sources or measurements: "There was an error attempting to load the Source Measurement list from the server. The application is usable, but no selections can be added or edited. If this problem persists contact your system administrator. "

PME web and other PME applications have the most functionality, but source data is not accessible.

Concurrently, In the PME web application "Dashboards" tab, the Table gadget does not have real-time data. "Error: cannot retrieve data. Ensure that all required services are running on the server."

In the SQL server log, the following error can be found:

"Login failed for user "ionedsd". Reason: Failed to open the explicitly specified database 'ION_Network'."

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 2022
Power Monitoring Expert 2023
Power Monitoring Expert 2024

Environment
Power Monitoring Expert (PME) Web
SQL Server Management Studio (SSMS)

Cause
PME relies on SQL databases that contain meter data, device information, and additional settings. When PME is started, the three primary logins should have database related permissions applied. Otherwise, PME applications will thus not have device information such as the source and measurement names. Corresponding data may also not be available.

For more information on the SQL account permissions, please see the PME system guide https://product-help.schneider-electric.com/EcoStruxure/Power-Monitoring-Expert-2024/content/8_reference/planning/ref_sqlaccounts.htm?Highlight=ionedsd

Resolution

1. Open SQL Server Management Studio (SSMS).
2. In the "Object Explorer" pane, expand the folder "security" then "logins"
3. Select the ionedsd by clicking, or by right-clicking and selecting "Properties" to open
   the login Properties window
4. In the "select a page" pane, select "User Mapping"
5. Ensure the box in the Map column is checked for the databases ION_Network and ION_Data
6. Select ION_Network to highlight it. In the Database role membership box, ensure the roles "public" and "NOM_DSD_Reader" is checked.
7. Select ION_Data to highlight it, and ensure the roles "public" and "ION_DSD_Reader" are checked in the database role membership box

發佈於: 施耐德電機Taiwan