Table of Contents

Search

  1. Preface
  2. Upgrade Overview
  3. Pre-Upgrade Tasks
  4. Database Tasks
  5. Application Server Tasks
  6. Hub Store Upgrade
  7. Hub Server Upgrade (In-place Upgrade)
  8. Process Server Upgrade (In-place Upgrade)
  9. Resource Kit Upgrade (In-place Upgrade)
  10. Post-Upgrade Tasks
  11. Search Configuration Upgrade
  12. ActiveVOS Post-Installation Tasks for the Application Server
  13. ActiveVOS Post-Upgrade Tasks for Business Entity Adapter
  14. ActiveVOS Post-Upgrade Tasks for Subject Areas Adapter
  15. Troubleshooting the Upgrade Process
  16. Frequently Asked Questions
  17. Processing Existing ActiveVOS Tasks
  18. Configuring Metadata Caching

Upgrading from Version 9.0.1 or 9.1.0 for Oracle

Upgrading from Version 9.0.1 or 9.1.0 for Oracle

About the Data Validation Tool Report

About the Data Validation Tool Report

The data validation tool report identifies the data issues that you must resolve after you upgrade the schema to the new database structure. Run the script to perform a data check and create the DVT_REPORT<report ID>.CSV file.
The report ID consists of the date and time the report was created in the format DVT_REPORT<YYMMDDHHMMSS>. The report ID follows a 24-hour clock format. For example, a DVT report with a file name of DVT_REPORT130723163551.CSV was created on July 23, 2013 at 4:35 p.m.
The data validation tool report contains the following sections of data:
  • Detailed Temporary Data Tables
  • Summary
  • Detailed Report by Table

Detailed Temporary Data Tables

The detailed temporary data tables contain a copy of the records with data issues. The data validation tool uses these tables to track and resolve content metadata issues.

Summary

Lists all issues found during the data check.
The following table describes the information in the summary:
Column
Description
Ref. #
The row number.
Check Code
A code that identifies a specific data issue.
Description
Provides a brief description of the issue that causes the error for that particular check code.
Fix Type
  • Auto: Data issues that can be fixed automatically by the data validation tool.
  • Info: Data issues that you might not need to fix.
Original Count
Displays the number of data issues that the initial data check found.
Current Count
Displays the number of data issues that the most recent data check found.

Detailed Report by Table

The following table describes the information provided in the columns of the detailed report by table:
Column
Description
Ref. #
The row number.
Check Code
A code that identifies a specific data issue.
Description
Provides a brief description of the issue that causes the error for that particular check code.
Fix Type
  • Auto: Data issues that can be fixed automatically by the data validation tool.
  • Info: Data issues that you might not need to fix.
Foreign Key Name
The name of the foreign key in the schema that has data issues.
Original Count
Displays the number of data issues that the initial data check found.
Current Count
Displays the number of data issues that the most recent data check found.
<
base object name
>
Displays the number of data issues for a particular base object for each foreign key with issues. Each base object with a data issue has a column in the details of the auto mandatory fix issues.
Two rows that identify the base object table record count and the cross-reference (XREF) table record count appear in the report below the details of the auto mandatory fix issue. These rows display the total number of base object and XREF tables in the schema to provide some perspective on the percentage of records that have data issues.

0 COMMENTS

We’d like to hear from you!