This topic describes the ListProjectFullVerifyResult API provided by OceanBase Migration Service (OMS) Community Edition.
Purpose
You can call this operation to query the full verification result of a data migration project.
Call description
Limitations
This operation is applicable to OMS Community Edition V4.1.1 and later versions.
Request path
POST /api/v2?Action=ListProjectFullVerifyResult
Request parameters
| Parameter | Type | Description |
|---|---|---|
| projectId | string | The project ID. |
| sourceSchemas | string | The name of the source database. |
| destSchemas | string | The name of the destination database. |
| status | string | The status of the project. |
| pageNumber | integer | The number of the page to return. |
| pageSize | integer | The number of entries to return on each page. |
Return result
| Parameter | Type | Description |
|---|---|---|
| success | boolean | Indicates whether the call is successful. |
| errorDetail | object | The error details. |
| code | string | The error code. |
| message | string | The error description. |
| advice | string | The suggestions about how to resolve the error. |
| requestId | string | The request ID. |
| pageNumber | integer | The number of the page to return. |
| pageSize | integer | The number of entries to return on each page. |
| totalCount | integer | The total number of entries returned. |
| cost | string | The time spent in processing the request, in seconds. |
| data | string | The full verification result of the project. For more information, see the "Parameters in data" section of this topic. |
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 destination 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 destination database. ├─ mismatchedCount integer The total number of inconsistent data entries in the source and destination databases. ├─ consistentCount integer The total number of consistent data entries in the source and destination databases. ├─ progress string The full verification progress. ├─ message string The full verification information. ├─ status string The migration status. Valid values: RUNNING,ERROR,FINISHED, andSUSPEND.├─ 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
Sample request
{
"projectId":"np_4w5abs****",
"sourceSchemas":null,
"destSchemas":null,
"status":"RUNNING",
"pageNumber":1,
"pageSize":10
}
Sample response
{
"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
}
]
}
}