ListProjectFullVerifyResult

This topic describes the ListProjectFullVerifyResult API provided by OceanBase Migration Service (OMS).

Purpose

You can call this operation to query the full verification result of a data migration task.

Call description

Limitations

This operation is supported in OMS V4.1.0 and later.

Request path

POST /api/v2?Action=ListProjectFullVerifyResult

Request parameters

Response parameters

• Parameters in data

  Parameter	Type	Description
  differentNumber	integer	The total number of inconsistent data entries.
  fullVerifyTableStatistics	array	The list of tables for full verification.
  ├─ sourceTableName	string	The name of the table in the source database.
  ├─ sourceSchemaName	string	The name of the schema in the source database.
  ├─ destSchemaName	string	The name of the schema in the target database.
  ├─ sourceOnlyCount	integer	The number of data entries that exist only in the source database.
  ├─ destOnlyCount	integer	The number of data entries that exist only in the target database.
  ├─ mismatchedCount	integer	The total number of inconsistent data entries in the source and target databases.
  ├─ consistentCount	integer	The total number of consistent data entries in the source and target databases.
  ├─ progress	string	The full verification progress.
  ├─ message	string	The full verification information.
  ├─ status	string	The migration status. Valid values: RUNNING, ERROR, FINISHED, and SUSPEND.
  ├─ resultType	string	The type of the full verification result.
  ├─ resultDesc	string	The description of the full verification result.
  ├─ errorDetails	string	The error message and cause.

Examples

Request example

{
    "projectId":"np_4w5abs****",
    "sourceSchemas":null,
    "destSchemas":null,
    "status":"RUNNING",
    "pageNumber":1,
    "pageSize":10
}

Response example

{
    "success":true,
    "errorDetail":null,
    "code":null,
    "message":null,
    "advice":null,
    "requestId":"95b4e**a-4e***",
    "pageNumber":1,
    "pageSize":10,
    "totalCount":415,
    "cost":"36 ms",
    "data":{
        "differentNumber":0,
        "fullVerifyTableStatistics":[
            {
                "sourceTableName":"E****Y0RU",
                "sourceSchemaName":"TION1295***RACLE3",
                "destSchemaName":"IGRAT****OR19ADG",
                "sourceOnlyCount":0,
                "destOnlyCount":0,
                "mismatchedCount":0,
                "consistentCount":200,
                "progress":"1.0",
                "message":"Consistent",
                "status":"FINISHED",
                "resultType":"CONSISTENT",
                "resultDesc":"Consistent",
                "errorDetails":null
            }
        ]
    }
}