Issue
The "Demand Log" log viewer on the "Summary" tab of the default diagram for HDPM6000 series devices will not open or does not display logged data.
In Vista it returns an error similar to "Invalid object name"
In the web application it returns an error "There was a problem loading the application. See the diagnostic log for details"
Product Line
Power Monitoring Expert 2022
Power Monitoring Expert 2023
Resolution
- Open Vista software on the PME server
- Open the affected diagram
- Navigate to the "Summary" tab
- Check Options > Show Toolbox to ensure toolbox is open and diagram can be edited
- Right-click "Demand Log" log viewer to open the Data log Viewer Configuration window
- Navigate to Query > "Edit SQL"
- Edit the SQL query to remove any reference to a specific data recorder (usually directly before the "@ PanelName" portion of the script)
- Select File > Save > OK
- Open the Demand Log to test the new query and if everything works, save the Vista diagram
- If the issue is not resolved, review the sample query below and adjust the one on your system as necessary
Once edited, the SQL query should look similar to below:
Released for:Schneider Electric Canada
