Technical FAQs

Ask a Question

''Error loading measurements'' when adding/editing data series in an existing gadget in SPM/PME dashboards.

Issue
Attempting to edit or add to the data series in an existing gadget results in ''Error loading measurements'' message. The diagnostic tool fails to archive any of the ION_Data, ION_Network and application modules databases. The error below is seen in the windows application event log.
Source = MSSQL$STXPWRMON
General tab = The description for Event ID 17053 from source MSSQL$STXPWRMON cannot be found. Either the component that raises this event is not installed on your local computer or the installation is corrupted. You can install or repair the component on the local computer.

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
The 'tempdb' (temporary database) is running out of disk space and this interferes with PME operations such as retrieving topics for dashboards. The databases archive fails as the diagnostic tool attempts to use 'tempdb' as part of the process.

The following information is included in the event.


D:\Program Files\Microsoft SQL Server\MSSQL10_50.STXPWRMON\MSSQL\DATA\templog.ldf
112(There is not enough space on the disk.)


Resolution
- Run the Windows Disk Cleanup tool to free disk space and delete temporary files.

Because tempdb is re-created each time the instance of SQL Server is started, there is no need to manually move the data and log files. The files are created in the new location when the service is restarted. Move the 'tempdb' database and log files to another location by following the steps in KB FA219030.
 
Was this helpful?
What can we do to improve the information ?