8.1.3 Logs

The Data Analysis Tool writes status and error messages to the configured log file.

The default location for this log file is:

<OFSAAI Installed Directory>/database/db_tools/logs/data_analysis_tool.log 

The system writes any system-type errors that prevent the tool from connecting to or operating this log file. It also writes data errors to the log and includes them in the data analysis report output. The following section describes the report output.

Understanding the Data Analysis Report

The tool generates a data analysis report, which resides in the location you specified in the install.cfg file or with the command line -o argument.

Note:

Oracle recommends that you view the output report using Microsoft Excel because this HTML file has specific HTML formatting for Excel.

The following table describes sections of the output report.

Table 8-5 Data Analysis Report Output

Section	Description
Table Count Summary	Contains the row count of each table in the configured database excluding the KDD, archive, and temp tables.
Field Distribution Summary Table	Groups by table the unique values for the identified fields and number of times each value occurs in the table. This summary table appears only in the report if the analysis for Distinct Values for Fields of Interest and Its Count was configured in the XML file. In addition, quotes enclose any values with padded spaces to identify spaces in the value.
Null Summary Count Table	Groups by table the number of nulls present and values with padded spaces for the identified fields in each table. This summary table only appears in the report if the analysis for Null and Padded Space Count has been configured in the XML file.
Referential Integrity Table Summary	Displays the join analysis, the number of rows returned between the joined tables, and the table count for each table being joined. This summary only appears in the report if the analysis for Join Counts has been configured in the XML file.
Query Results	Displays the results of queries specified in the QUERIES section of the analysis file.
SQL Report	Lists all of the SQL run to produce the other sections of the report.
Error Report	Displays any errors that occurred when any of the queries were performed.