Consultor Eletrônico

Status: Unverified

SYMPTOM(s):

No data recorded in _aud-audit-data when updating records.

FACT(s) (Environment):

Auditing enabled.
Auditing policy has been defined and committed.
All Supported Operating Systems
OpenEdge 10.x

CAUSE:

The auditing event level was not set to "On" on the Audit Events tab within the Auditing Policy Maintenance Tool.

FIX:

All events that have been defined within an auditing policy must be turned On before they will be actively recording changes.
Many of the default event ID may be quickly turned on by using the Import option within the Auditing Policy Maintenance Tool and loading the $DLC/auditing/policies.xml.

Otherwise, each auditing event must be set to "On" in the Auditing Policy Maintenance Tool.

Example follows based on audit enabled sports2000 database:
1) Connect to the audit enabled database with the Auditing Policy Maintenance Tool
2) Create a new policy, give the policy a name and save the policy.
3) Define a table to be audited on the Audit Tables tab such as the "benefits" table.
4) Select "Audit create level" and choose the Min option
5) Save this table auditing definition.
6) Audit Create Level has an Event ID of 5100
7) Select the Audit Events Tab
8) Add a new audit event
9) Type in 5100 in the Event ID and click on the save button.
10) In the File menu, choose Commit.

Creates for the Table Benefits will now be audited.