Table of Contents

Search

  1. Preface
  2. Introduction to Data Validation Option
  3. Repositories
  4. XML Data Source
  5. Tests for XML Data Sources
  6. Connections
  7. Expressions
  8. Table Pairs
  9. Tests for Table Pairs
  10. Single-Table Constraints
  11. Tests for Single-Table Constraints
  12. Examples of Tests from Spreadsheets
  13. SQL Views
  14. Lookup Views
  15. Join Views
  16. Aggregate Views
  17. Business Intelligence and Reporting Tools Reports
  18. Dashboards
  19. DVOCmd Command Line Program
  20. Troubleshooting
  21. Appendix A: Datatype Reference
  22. Appendix B: Reporting Views
  23. Appendix C: Metadata Import Syntax
  24. Appendix D: Jasper Reports
  25. Appendix E: Glossary

Data Validation Option User Guide

Data Validation Option User Guide

Bad Records in Database Schema Mode

Bad Records in Database Schema Mode

If you choose to save detail bad records in the Data Validation Option schema, the bad records are written into the detail tables.
The following table describes the tables to which Data Validation Option writes the bad records based on the type of test:
Test Type
Table
Columns
Value, Outer Value, Value Constraint
ALL_VALUE_RESULT_DETAIL
TEST_RUN_ID, TEST_CASE_INDEX, KEY_A, VALUE_A, KEY_B, VALUE_B
Unique Constraint
ALL_UNIQUE_RESULT_DETAIL
TEST_RUN_ID, TEST_CASE_INDEX, VALUE
Set
ALL_SET_RESULT_DETAIL
TEST_RUN_ID, TEST_CASE_INDEX, VALUE_A, VALUE_B
You must ensure that the database table has enough table space to hold all the bad records.
The test details of all the tests that you ran in Data Validation Option is available in the TEST_CASE table. The test installation details of the tests are available in the TEST_INSTALLATION table. You can obtain the TEST_ID of a test from the TEST_INSTALLATION table. You need TEST_ID of a test to query the complete details of a test from the TEST_CASE table.
You can get the Test Case Index from the Properties tab and the Test Run ID from the results summary of the test in the detail area. You can get the Table Pair ID/Table ID from the Table Pair or Single Table properties.
For example, you ran a table pair with a value test and outer value test.
The following SQL query is a sample query to retrieve the information of bad records of a test with Test Case Index as 5.
select ALL_VALUE_RESULT_DETAIL.*,TEST_CASE.* from ALL_VALUE_RESULT_DETAIL , TEST_RUN, TEST_INSTALLATION, TEST_CASE where ALL_VALUE_RESULT_DETAIL.TEST_RUN_ID=TEST_RUN.TEST_RUN_ID and TEST_RUN.TEST_INSTALLATION_ID=TEST_INSTALLATION.TEST_INSTALLATION_ID and TEST_INSTALLATION.TABLE_PAIR_ID=TEST_CASE.TEST_ID and ALL_VALUE_RESULT_DETAIL.TEST_CASE_INDEX=TEST_CASE.TEST_CASE_INDEX and ALL_VALUE_RESULT_DETAIL.TEST_RUN_ID=220

0 COMMENTS

We’d like to hear from you!