How to Create a Violation Report on Relationships or Constraints

Previous Next

To create a violation report:

1.Click the Data button in the USoft BenchMark toolbox.
The Operations on Application Database dialog appears.
2.In the Violation Reports section, click Relationships or Constraints, as appropriate.
The appropriate window appears.
3.Enter the name of a report configuration or click the lookup button to choose a previously defined one from the list that appears.
4.Accept the default filename, enter a new one, or click Browse... to find an existing file.
Note that if you use an existing file name, the file will be overwritten without any further warning.
5.Click OK to create the report and close the window, or Apply to create the report and then create another one.
A record is added to the Reports table, enabling you to view the report later.

 

You can also create constraint violation reports via a USoft action that can for example be called from within batch jobs, the SQL command dialog , or the SqlScript() action:

report-constraint-violations(<path/filename>, [configuration] )

 

This action creates a constraint violation report and writes it to the specified file, based on the (optional) configuration.

report-relationship-violations( <path/filename>, [configuration] )

 

This action creates a relationship violation report and writes it to the specified file, based on the (optional) configuration.

The filename parameter is mandatory. If no configuration is supplied, or the configuration cannot be read from the BenchMark tables properly, all constraints/relationships that violate repository rules will be reported.

NOTE: The filename defined in the configuration is only used by USoft Benchmark. These actions always require a separate filename.