Constraint Violation Report Structure
The constraint violation report contains a number of sections, each of which covers a different area that is being checked for violations. These areas in the report, and the reported items are described below.
List of violating rows per constraint:
For each constraint a list of violating rows is displayed. The report shows the rows of the driving table and the primary-key information. This information can then be used to locate the violating rows and fix them.
Number of violations per table that has violations:
The number of violations is displayed for each table that is a driving table in a constraint and also contains violations.
Number of violations per constraint that has violations:
For each active constraint that has been checked and which contains one or more violations, the total number of violations for the constraint are displayed.
Total number of tables:
Total number of tables in the repository.
Number of tables with violations:
The number of tables that contain one or more violations.
Total number of active constraints:
The total number of active and correct constraints.
Total number of active constraints not checked:
The total number of active and correct constraints that are not checked by the report. These are, for example, transitional constraints or constraints which cannot be checked.
Total number of active constraints checked:
The total number of active and correct constraints that have been checked by the report.
Number of constraints with violations:
The number of constraints that contain one or more violations.
Total number of violations:
The total number of violations found in all checked constraints.
Constraints manually excluded from report:
Contains a list of constraints that have explicitly been manually excluded from the report. You can exclude specific constraints from the report by creating a report configuration. For more information, see "How to Exclude a Constraint from a Violation Report".
Constraints manually excluded from report but not found in repository:
Contains a list of constraints that have been explicitly manually excluded from the report by means of a report configuration, but the constraints were not found in the repository. This can happen, for example, if the report configuration is old and contains an excluded constraint which no longer exists in the active repository.