Generate error reports

Data Integrity error reports allow you to check the results of your row by row comparisons. You can create an HTML report, a CSV file, or both. If you create an HTML report, Data Integrity saves all data in an SQLite database that you can view in the Data Integrity Report Viewer. This means that large amounts of data don't affect your disk space.

Create an error report

To create a report, you must first specify the format and content in the Complete Row by Row Comparison Module under General Options -> Error Reporting.

To generate error reports, specify the XTestStepValues as described in the table below:

Value

Description

Optional

Max Errors

Specify the maximum number of errors before Data Integrity cancels the execution.

The default value is 100.

X

Report Filename

Specify the full path and file name for your error report.

For example: C:\Tosca_Projects\DataIntegrityReports\Report.html.

The directory must exist before you start the test execution.

 

Format

Select one of the following output format options:

  • HTML

  • CSV

  • HTML & CSV

The default format is HTML. This saves all data in an SQLite database that you can view in the Data Integrity Report Viewer.

X

Report Unmatched Target Rows

Specify if you also want to include the following information in the error report:

  • Unmatched target rows

  • Differences between source and target rows

This can affect comparison speed if you have a high number of rows.

This setting is enabled by default. To disable it, set its value to False.

X

File Column Separator

Specify the character that separates new columns in CSV report files.

Data Integrity uses a comma , by default.

X

Example: create a CSV error report

In this example, you create a CSV error report with the following specifications:

  • Data Integrity allows a maximum of 100 errors before it cancels the execution.

  • Data Integrity saves the report in C:\Test\ResultsFile.csv.

  • The error report format is CSV.

  • The character that separates new columns in the CSV report is |.

Create a TestCase with error reporting.

TestCase that creates a CSV error report

Example: create an HTML error report

In this example, you create an HTML error report with the following specifications:

  • Data Integrity allows a maximum of 100 errors before it cancels the execution.

  • Data Integrity saves the report in C:\Test\ResultsFile.html.

  • The error report format is HTML. This means that the data is stored in an SQLite database.

  • Error reporting includes unmatched target rows.

TestCase that creates an HTML error report. Data Integrity stores the data in an SQLite database.

Next steps

Once you've run your TestCase, you can check your error report in one of the following ways: