Verifying and Resetting Audit Tables

This section explains how to check the configuration for a given table across all environments and databases within the pathcode and explains how to reset the auditing state for the selected audit table if a conflict is detected. Perform this task when the JDE.log or JAS.log file indicates conflicts with audited tables between environments.

Enter P9500003 in the Fast Path, or enter GH9091 and then select the Audit Table Configuration menu.

1. On the Work with Audit Table Configurations form, select the audit table that you want to verify.

2. From the Row menu, select Verify.

3. On the Validate and Reset Database Audit Components form, enter a database password in the Password field, and then click OK.

   If the audit configuration is valid, the system displays the Work with Audit Table Configurations with an informational message, "Database Audit Components valid."

4. If the audit configuration is not valid, the following error is returned on the Validate and Reset Database Audit Components form: Error: Database Audit Component States Differ. From the Form menu, select Reset Audit Flag to reset database audit components.

5. Click OK on the message box reminding you to bounce servers and clients.

6. Click Find to refresh the Work with Audit Table Configurations form. Verify that the Audit table shows the correct state: Enabled or Disabled.