AquilaCRS Audit Trail Rebuild

This is a Technical (IT) AquilaCRS topic

Overview

AquilaCRS records all database actions in an audit trail that can be used to rebuild the database. The rebuild program is available in two editions:

• svcAqRebl: Windows service for continual rebuild processing; for replication purposes.
• AqReblWin: Windows desktop app for ad-hoc database rebuilding.

Both apps use the same internal rebuild engine.

Installation

The service and the desktop app are installed using a single wizard installer. The service is installed by default as "manual" start up & requires correct configuration before starting.

Configuration

The service and desktop apps use their own INI files for configuration. The INI files contain the following configuration items:

Key Name	Values	Description
AuditURL	url	Specifies the location of the server containing the audit trail records to use as a basis for rebuilding.
TargetURL	url	Specifies the location of the server that is to be used as the rebuild target database. Can be the same as the AuditURL if the same server is used for both source and target.
BatchSize	Number	Defaults to 200. This is the number of audit trail records to retrieve from the audit trail table at a time for processing. The higher the number the longer the delay in retrieving records initially.
UnitID	Blank or a specific unit id.	Defaults to blank. If specified, then the rebuild process will only rebuild data for the unit specified.
IncPrivateDeltas	1 or 0	Defaults to 0. If this setting is on, the patient identifiable audit data is also rebuilt. Defaults to off, which does not rebuild patient identifiable data.
UseTargetDateTime	1 or 0	Defaults to 0. If set to 1, then the rebuild process stops at the date/time specified by TargetDateTime setting. This is ideal for rebuilding a database to a specific date point.
TargetDateTime	Date in format: DD/MM/YYYY HH:MM:SS	If UseTargetDateTime is on, then this date specifies the point at which to stop rebuilding the database.
MatchOldValues	1 or 0	Default is 1. When rebuilding the audit trail, the rebuild app will ensure that the existing value in the database matches the old value in the audit trail (where available). If the old value doesn't match the audit trail record is flagged as having failed and the next audit trail record is processed. Only turn this setting off if there have been manual alterations to the database contents that were not included in the audit trail.
Verbose	1 or 0	If 1 the level of logging is increased. To be used for debugging/problem solving only. Default is 0.

Logging

The service app (svcAqRebl) sends its output to the Windows Application Event Log. The desktop app (AqReblWin) logs its output the application directly.