All Products
Search

This Product

    Data Transmission Service:View data verification details

    Document Center

    Data Transmission Service:View data verification details

    Last Updated:Jun 18, 2025

    This topic describes how to view the details of a data verification task in Data Transmission Service (DTS).

    Prerequisites

    A data verification task is created and configured. For more information, see Configure a data verification task.

    Usage notes

    • If you configure a data verification task in a DTS synchronization or migration instance, go to the instance details page or the Data Verification page to view the details. If you configure a verification task in the verification task list, go to the Data Verification page to view the details.

    • For full data verification and schema verification, we recommend that you view the details of data verification when the value of the Status parameter is Completed. For incremental data verification, we recommend that you view the details of data verification when the Current Offset parameter indicates a point in time later than the point in time when incremental data is changed.

    • During incremental data verification, the changes of the same data record within a certain period of time are merged. Therefore, the number of data records displayed in the results of incremental data verification may be less than that of incremental data changes.

    • By default, the information about data inconsistency that is detected by full data verification tasks and incremental data verification tasks are retained for 30 days. We recommend that you view the information and handle the data inconsistency issues in a timely manner.

    • If a full data verification task detects inconsistent data, after you manually correct the data, you must manually verify or execute the task again to authenticate data consistency.

    • If a incremental data verification task detects inconsistent data, DTS re-verifies the inconsistent data approximately every 10 minutes. If a large amount of inconsistent data exists, this time interval is accordingly extended.

    View a verification task on the Data Verification page

    1. Use one of the following methods to go to the Data Verification page

      DTS console (quick start)

      1. Go to Data Verification page.

      2. Optional: In the top navigation bar, select the region in which the data verification instance resides.

      DTS console (regular)

      1. Log on to DTS console.

      2. In the left-side navigation pane, click Data Verification.

      3. Optional: In the top navigation bar, select the region in which the data verification instance resides.

      DMS console

      Note

      The actual operations may vary based on the mode and layout of the Data Management (DMS) console. For more information, see Simple mode and Customize the layout and style of the DMS console.

      1. Log on to DMS console.

      2. In the top navigation bar, choose Data + AI > DTS (DTS) > Data Verification.

      3. Optional: On the right side of Verification Task, select the region in which the data verification instance resides.

    2. Click the instance ID to go to the instance details page.

    3. Optional. In the left-side pane, click Task Management.

    4. In the Progress section, click the Full Data Verification, Incremental Data Verification, or Schema Verification module to view the details of data verification.

      • Basic information

        On the Basic Information tab, you can view the information about data verification, such as the start time, verification time rules, status, actions, and error messages. The actual information displayed in the console prevails.

        After data verification starts, you can restart, pause, stop, or Delete based on your business requirements. For more information, see What to do next.

        Important

        On the Basic Information tab, the Status parameter indicates the state of data verification. You can view the results of data verification on the Check Details tab.

      • Check Details

        On the Check Details tab, you can filter and view the results of data verification, such as the source and destination database names, table names in the source and destination databases, the state of data verification, and the point in time of data verification.

        Note

        • On the Check Details tab, the results of data verification are displayed in descending order based on the values in the Number of Inconsistent Records column.

        • You can download revised SQL statements only from the results of full data verification. If full data verification was started before 14:04:52 on November 20, 2023, you must restart full data verification before you can download revised SQL statements.

        • The value in the Total Number of Records column specifies the estimated number of records to be verified. The value in the Number of records completed by verification column specifies the number of records that are verified. Therefore, the value in the Number of records completed by verification column may be larger than that in the Total Number of Records column.

        • If the value in the Number of Inconsistent Records column is 0, data is consistent between the source and destination objects. In this case, you do not need to view or download the data verification report because the report does not contain data.

        • If the value in the Number of Inconsistent Records column is not 0, data or schema inconsistency is detected between the source and destination objects. In the Actions column, you can click View Report, Download Report, or Download Revised SQL Statements based on your business requirements. Then, you can manually modify the inconsistent data or schemas based on the data verification report or revised SQL statements.

          Important

          Execute the DELETE statement in the revised SQL statements with caution.

    View a verification task in a DTS synchronization or migration instance

    1. Use one of the following methods to go to the Data Synchronization or Data Migration page.

      DTS console

      1. Log on to DTS console.

      2. In the left-side navigation pane, click Data Synchronization or Data Migration.

      3. Optional: In the top navigation bar, select the region in which the data synchronization or the data migration instance resides.

      DMS console

      Note

      The actual operations may vary based on the mode and layout of the Data Management (DMS) console. For more information, see Simple mode and Customize the layout and style of the DMS console.

      1. Log on to DMS console.

      2. In the top navigation bar, choose Data + AI > DTS (DTS) > Data Synchronization or Data + AI + DTS (DTS) > Data Migration.

      3. Optional: On the right side of Data Synchronization or Data Migration, select the region in which the data synchronization or the data migration instance resides.

    2. Click the ID of the data synchronization or migration task to go to the task details page.

    3. Optional. In the left-side pane, click Task Management.

    4. Clear Hide Completed Modules next to Progress.

    5. In the Progress section, click the Full Data Verification, Incremental Data Verification, or Schema Verification module to view the details of data verification.

      • Basic information

        On the Basic Information tab, you can view the information about data verification, such as the start time, verification time rules, status, actions, and error messages. The actual information displayed in the console prevails.

        After data verification starts, you can restart, pause, stop, or Delete based on your business requirements. For more information, see What to do next.

        Important

        On the Basic Information tab, the Status parameter indicates the state of data verification. You can view the results of data verification on the Check Details tab.

      • Check Details

        On the Check Details tab, you can filter and view the results of data verification, such as the source and destination database names, table names in the source and destination databases, the state of data verification, and the point in time of data verification.

        Note

        • On the Check Details tab, the results of data verification are displayed in descending order based on the values in the Number of Inconsistent Records column.

        • You can download revised SQL statements only from the results of full data verification. If full data verification was started before 14:04:52 on November 20, 2023, you must restart full data verification before you can download revised SQL statements.

        • The value in the Total Number of Records column specifies the estimated number of records to be verified. The value in the Number of records completed by verification column specifies the number of records that are verified. Therefore, the value in the Number of records completed by verification column may be larger than that in the Total Number of Records column.

        • If the value in the Number of Inconsistent Records column is 0, data is consistent between the source and destination objects. In this case, you do not need to view or download the data verification report because the report does not contain data.

        • If the value in the Number of Inconsistent Records column is not 0, data or schema inconsistency is detected between the source and destination objects. In the Actions column, you can click View Report, Download Report, or Download Revised SQL Statements based on your business requirements. Then, you can manually modify the inconsistent data or schemas based on the data verification report or revised SQL statements.

          Important

          Execute the DELETE statement in the revised SQL statements with caution.

    What to do next

    If you need to verify data consistency between the source and destination objects again after you modify the inconsistent data, you can perform the following operations in the Progress section to manage data verification.

    Important

    • The following operations do not apply to schema verification.

    • If a button is dimmed, the corresponding operation is not supported in the current state of data verification.

    • In the verification task list, if you perform an operation, such as releasing a verification task that is configured on a data synchronization or migration instance, the task is also released on the corresponding data synchronization or migration instance.

    1. Go to the Task Management page of your DTS task.

    2. Clear Hide Completed Modules next to Progress.

    3. Click the Full Data Verification or Incremental Data Verification module.

    4. Optional. Click the Basic Information tab.

    5. Manage data verification.

      • Pause data verification

        Important

        • You can pause data verification only after data verification starts.

        • After full data verification is paused, the value of the Status parameter changes to Completed. Full data verification does not support resumable verification.

        Click Pause to the right of Actions. In the Note message, click OK. After the data verification task is paused, the Status of the task changes to Pausing.

      • Restart data verification

        Note

        • You can restart full data verification only when the value of the Status parameter is Pausing or Completed. After full data verification is restarted, DTS verifies the existing data in the source and destination databases

        • You can restart incremental data verification only when the value of the Status parameter is Pausing or Completed.

        Click Restart to the right of Actions. In the Note message, click OK.

      • Stop data verification

        Note

        You can stop only incremental data verification. After incremental data verification is stopped, the value of the Status parameter changes to Completed.

        Click Stopped to the right of Actions. In the Note message, click OK.

      • Delete data verification

        Important

        A data verification task cannot be recovered after it is deleted. You must configure another data verification task.

        Click Delete to the right of Actions. In the Note message, click OK.

    Related API operations

    Operation

    Description

    DescribeDataCheckTableDiffDetails

    Queries the information about inconsistent data detected in a table in a data verification task.

    DescribeDataCheckReportUrl

    Queries the download URL of a data verification report.

    DescribeDataCheckTableDetails

    Queries the information about a full or incremental data verification task.

    FAQ

    • How to create a full data verification or incremental data verification task?

      You can use one of the following methods:

      • Go to the Data Verification page, and create a data verification task.

        Note

        You cannot create an incremental data verification task on this page.

      • Go to the Data Synchronization or Data Migration page. Select a data synchronization or data migration instance you want to manage, and click the Full Data Verification or Incremental Data Verification module. Click Delete on the Basic Information tab, and then click Create Verification Task in the upper part of the page.

        Note

        Data verification is not supported for DTS instances whose Status is Completed.

    • Why does not full data verification or incremental data verification start?

      The cause varies based on whether the task contains the incremental data synchronization or migration stage.

      • For the tasks that does not contain the incremental data synchronization or migration stage:

        Full data verification starts after full data is written to the destination database.

      • For the tasks that contain the incremental data synchronization or migration stage:

        Note

        Full data verification and incremental data verification do not affect each other.

        • If incremental data migration or synchronization is a single task, data verification starts when incremental data is written to the destination database without latency for the first time.

        • If incremental data migration or synchronization consists of multiple subtasks, data verification starts when the latency of all subtasks is less than 2 seconds. For example, incremental data migration between MongoDB databases consists of multiple subtasks.

    • Why is the result of incremental data verification empty?

      Incremental data verification only records information about databases and tables that contain inconsistent data. DTS performs incremental data verification after incremental data is synchronized or migrated from the source database to the destination database. If no inconsistent data is detected, the result is empty.

    • Why is the offset in the incremental verification module not updated?

      The Current Offset in the incremental verification module is the time at which the latest incremental data verification is performed. If no new incremental data is generated in the source database, the Current Offset is not updated, or no offset information exists.

    • Why is no inconsistent data detected during incremental data verification after incremental data is written to the destination database?

      Incremental data verification checks the data consistency between the source and destination databases based on the source database. Inconsistent data is detected only if the incremental data that is generated in the source database is not written to the destination database or the written data is inconsistent with the source data.