Viewing and Exporting Verification Results

Prerequisites

You have created and executed verification tasks.

Precautions

• When sum operations (like sum or allsum) are performed, if the results exceed the valid digit limit of the Double type, the precision is lost. Additionally, when very large floating-point numbers are verified, the actual differences may not be detected if they exceed the significant digits that the Double type can represent. In such cases, the calculated differences may erroneously appear as 0.
• Task execution batches are named based on the time zone of the MgC Agent currently in use.

Viewing Verification Results

1. Sign in to the MgC console. In the navigation pane, under Project, select your big data migration project from the drop-down list.
2. In the navigation pane, choose Migrate > Big Data Verification.
3. In the Features area, click Verification Results.
4. Select a task batch (date). Batches are named based on the time zone of the MgC Agent currently in use.

   

5. In the list, perform the following operations on a table:
   • View the verification details of table partitions by clicking the View in the Partitions column. Then click View Details to view the verification results of a table partition.
   • View the historical verification results by clicking View History in the Operation column.

Recording Inconsistency Causes

On the Verification Results page, you can specify the types of inconsistency causes and record specific causes for tables that fail verification. The system pre-defines 10 types of common inconsistency causes.

1. On the Verification Results page, you can filter the execution results for each verification batch (date).
2. Locate the table that fails the verification and click Analyze Cause under Fail in the Verification Result column.

   

3. Select a cause type from the Cause Type drop-down list. If the pre-defined types cannot meet your requirements, you can select Custom and enter a cause type in the text box.
4. In the Processing Status drop-down list, specify whether the inconsistencies have been addressed. This setting affects the calculation of post-processing verification pass rate. The rules are as follows:
   • If you select Processed or Processing not required, the table will be counted toward the post-processing pass rate. If you select Processing not required and enable Propagate processing status, the table's processing status will be inherited in future verification results.
   • If you select Not processed, the table will be considered a failed table in the post-processing statistics.

5. Record the inconsistency cause and click Confirm. You can view the inconsistency cause in the Cause Type column.

   Then you can perform the following operations:

   • Click View History in the Operation column to view the historical execution batches, verification results, and inconsistency causes of each table.
   • Export the verification results and inconsistency causes for further analysis. For details, see Exporting Data. Select Verification result summary for Content to Export.

     

     

     In the exported file:

     • For each table, the same cause types are combined and displayed, and different cause types are separated by semicolons (;).
     • The cause descriptions are displayed based on execution batches and are separated by semicolons (;).

Exporting Verification Results

1. On the Verification Results page, choose Export > Export Verification Results.
2. Select a batch and table group, and then click Confirm.
3. After the export is complete, click Manage Exports.
4. Click Download in the Operation column to download the verification results.

Exporting Data

1. On the Verification Results page, choose Export > Export Data.
   Figure 1 Export Data
   

2. Select the date range and content to be exported, and click OK. The system starts to export the data.
   Figure 2 Selecting the scope of data to be exported
   

3. After the export is complete, click Manage Exports.
4. Click Download in the Operation column to download the verification results.