Here’s what more than 2,500 business decision-makers around the world say.Download the report
...with the Facility Hero app in hand! Discover how you can optimize your maintenance efforts today.Learn more
Access tailored services, 24/7 self-service and expert help. Anywhere, anytime, any project.Discover now
Everything you need to know about our IoT technology backbone.Learn more
Explore our global offerings or select your country from one of our five regions.Global
Découvrez nos offres globales ou sélectionnez votre pays dans l’une de nos cinq régions.
The Energy Cost Report does not show any data for a source that is known to have the required data. Running another report, such as a Trend Report, shows the desired energy data.
ION Enterprise 6.0
Struxureware Power Monitoring 7.0.x
Power Monitoring Expert 7.2.x
Power Monitoring Expert 8.x
Web Application Reports
The Energy Cost report looks for specific measurements in a specific order, as defined in the CFG_ItemValue table in the ION_Network database (see FA214149 for a full listing of measurements). It uses the Channel table entries in the ION_Data database to determine which measurement to use for a given source. If a device has had configuration changes such that more than one measurement from the CFG_ItemValue list appears in the Channel table, the Energy Cost report will automatically choose the measurement from the Channel table that appears first in the CFG_ItemValue list, even if this measurement is not the one that has data for the device in the chosen time range.
So if the Energy Cost report is run for a device, but returns no data, and you are sure there is energy data for the device, check the Channel table in ION_Data. You can use this query:
SELECT * FROM channel WHERE recorderID IN (SELECT ID FROM Recorder WHERE SourceID IN (SELECT ID FROM source WHERE name = '<your device name>'))
This query will produce a column for the device called "IsCurrentConfiguration".
*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.*
There are a couple of workarounds:
1. Delete the old entries from the Channel table - this is the approach to take if there is no data in the database for this measurement for this source.
DELETE FROM channel WHERE recorderID IN (SELECT ID FROM Recorder WHERE SourceID IN (SELECT ID FROM source WHERE name = '<your device name>')) AND IsCurrentConfiguration = 0
2. Edit the CFG_ItemValue table to modify the order that the measurements are listed. Note that doing this effects all Energy Cost reports run against all devices.
Sign up for all the latest solutions, offers and best practices straight to your inbox.
We are excited that you have joined the group. You will receive your welcome email soon describing the program and what to expect in the upcoming weeks. Enjoy!