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.
How can I run the Power Quality Event Aggregator in archive mode so I can run a Power Quality report on pre-existing data?
Meter Power Quality Events do not show up in Power Quality Report.
ION Enterprise 6.0
Windows XP (32-bit), Windows Vista (32-bit), Windows Server 2003 (32-bit), Windows Server 2003 R2 (32-Bit), Windows Server 2008 (32-bit), Windows 7 (64-bit), Windows Server 2008 (64-bit), Windows Server 2008 R2 (64-bit)
The PQ Aggregator aggregates power quality data from the waveform log, event log and certain quantities from the datalog/datalogstamp tables and inserts it into the PQ_ group of tables in ION_Data. The ION Power Quality Aggregation service performs this task going forward, but if a user wishes to run a Power Quality report against pre-existing data, or data contained in archived databases, the PQ Aggregator must be run in archive mode.
1. Start a command prompt in the ION Enterprise\system\bin directory
2. Run EventCollector.Cli.exe /a
Running this command will aggregate all data in ION_Data and any archive that is called ION_Data_Archive. If an archived database is not called something that starts with ION_Data_Archive, PQ data in this database will not be archived. It is necessary to detach the archive, and then reattach it as ION_Data_Archive, where means any subsequent characters.
Important: Note that this utility must be run from the ION Enterprise\system\bin directory for it to run correctly. Also be aware that on a large database that contains a lot of Power Quality data, this utility could run for some time. It will not interfere with ION Enterprise while it is running.
This information is included in ION Enterprise On-Line Help in a section called 'Running the ION Power Quality Aggregation Service Manually'