Rockwell Automation Energy Management Accelerator Toolkit Quick Start - Manual (Page 204)

204 Rockwell Automation Publication IASIMP-QS016C-EN-P - October 2014
Chapter 10 FactoryTalk EnergyMetrix Software and PowerMonitor Device Maintenance
Emergency Transaction Log Backup and Shrink Procedure
If routine database maintenance is not performed or fails, the transaction log can become very large and in the extreme can
fill the hard drive. Executing this query will back up and shrink the transaction log to correct the situation.
Use EMMA
DBCC SHRINKFILE (EMMA_Log, 0)
BACKUP LOG EMMA WITH TRUNCATE_ONLY
DBCC SHRINKFILE (EMMA_Log, 0)
GO
Run this query from Microsoft SQL Management Studio.
Automatic Data Repopulation
ADR, a standard Manager function, gathers selected data from device data logs to repopulate database gaps caused by
network or server outages. ADR will not repopulate gaps in the database that are caused by loss of power to or failure of the
metering devices.
ADR periodically reads data logs from the device and, inserts records in the database where no corresponding data exists. It
will not overwrite existing database records.
Devices that Support ADR
The following devices support Automatic Data Repopulation.
Allen-Bradley PowerMonitor 5000 Unit
The PowerMonitor energy and data logs provide the source for ADR. The energy log collects a fixed collection of energy
and demand parameters at a user-settable logging rate. The data log content and logging rate are user-configurable.
Allen-Bradley PowerMonitor 1000 Unit
The PowerMonitor 1000 energy log contains a predefined collection of energy, status input and demand parameters
(depending on the model) logged at a user-configurable interval.
IMPORTANT ADR is designed to help assure the integrity of data for billing, cost allocation, demand analysis and consumption
reporting, such as real energy, reactive energy and demand real power. Data not contained in the device snapshot,
energy or trend logs is not available for data repopulation.