ListProjectFullVerifyResult-阿里云帮助中心

This API queries the full validation results of a data migration task.

Try it now

Try this API in OpenAPI Explorer, no manual signing needed. Successful calls auto-generate SDK code matching your parameters. Download it with built-in credential security for local usage.

Test

RAM authorization

The table below describes the authorization required to call this API. You can define it in a Resource Access Management (RAM) policy. The table's columns are detailed below:

Action: The actions can be used in the Action element of RAM permission policy statements to grant permissions to perform the operation.
API: The API that you can call to perform the action.
Access level: The predefined level of access granted for each API. Valid values: create, list, get, update, and delete.
Resource type: The type of the resource that supports authorization to perform the action. It indicates if the action supports resource-level permission. The specified resource must be compatible with the action. Otherwise, the policy will be ineffective.
- For APIs with resource-level permissions, required resource types are marked with an asterisk (*). Specify the corresponding Alibaba Cloud Resource Name (ARN) in the Resource element of the policy.
- For APIs without resource-level permissions, it is shown as All Resources. Use an asterisk (*) in the Resource element of the policy.
Condition key: The condition keys defined by the service. The key allows for granular control, applying to either actions alone or actions associated with specific resources. In addition to service-specific condition keys, Alibaba Cloud provides a set of common condition keys applicable across all RAM-supported services.
Dependent action: The dependent actions required to run the action. To complete the action, the RAM user or the RAM role must have the permissions to perform all dependent actions.

Action

Access level

Resource type

Condition key

Dependent action

oceanbase:ListProjectFullVerifyResult

list

*All Resource

*

None

Request parameters

Parameter	Type	Required	Description	Example
ProjectId	string	Yes	The ID of the data migration task.	np_4w5abs****
SourceSchemas	array	No	A list of source databases.
	string	No	The name of the source database.	source_schema
DestSchemas	array	No	A list of target databases.
	string	No	The name of the target database.	dest_schema
Status	string	No	The status of the data migration task.	FINISHED
PageNumber	integer	No	The page number.	1
PageSize	integer	No	The number of entries per page.	页大小，分页查询时生效。

Response elements

Element	Type	Description	Example
	object	The response data.
Success	boolean	Indicates whether the request was successful.	true
ErrorDetail	object	Details about the error that occurred.
Code	string	The error code (new).	CM-RESOAT1111
Level	string	The error level. Valid values include `FATAL`, `ERROR`, `WARNING`, and `CRITICAL`.	ERROR
Message	string	The error message (new).	A system error occurred.
ExtraContext	object	Provides values for the placeholders in the `Message` field.
	any	The value of a placeholder.	null
MessageMcmsKey	string	The key of the error message.	null
MessageMcmsContext	object	Provides values for the placeholders in the template identified by `MessageMcmsKey`.
	string	The value of a placeholder.	null
Reason	string	The reason for the error.	null
ReasonMcmsKey	string	The key of the error reason.	null
ReasonMcmsContext	object	Provides values for the placeholders in the template identified by `ReasonMcmsKey`.
	string	The value of a placeholder.	null
Proposal	string	The recommended action (new).	null
ProposalMcmsKey	string	The key for the recommended action.	null
ProposalMcmsContext	object	Provides values for the placeholders in the template identified by `ProposalMcmsKey`.
	string	The value of a placeholder.	null
UpstreamErrorDetail	any	The detailed error information from an upstream service.	null
Code	string	The error code (legacy).	INNER_ERROR
Message	string	The error message (legacy).	A system error occurred.
Advice	string	The recommended action (legacy).	Contact the administrator.
RequestId	string	The request ID.	EE205C00-30E4-XXXX-XXXX-87E3A8A2AA0C
PageNumber	integer	The page number.	1
PageSize	integer	The number of entries per page.	10
TotalCount	integer	The total number of entries that match the query.	1
Cost	string	The request duration, in seconds.	1
Data	object	The full verification results for the data migration project.
DifferentNumber	integer	The total number of rows with mismatched data.	11
FullVerifyTableStatistics	array<object>	A list of full verification results for each table.
	array<object>
SourceTableName	string	The name of the source table.	source_table
SourceSchemaName	string	The name of the source database schema.	source_db
DestSchemaName	string	The name of the destination database schema.	dest_db
SourceOnlyCount	integer	The number of rows that exist only in the source.	0
DestOnlyCount	integer	The number of rows that exist only in the destination.	0
MismatchedCount	integer	The number of rows with mismatched data.	0
ConsistentCount	integer	The number of rows with consistent data.	200
Progress	string	The full verification progress, represented as a percentage.	80
Message	string	A message that provides details about the full verification status for the table.	null
Status	string	The full verification status for the table. Valid values include `RUNNING`, `ERROR`, `FINISHED`, and `SUSPEND`.	RUNNING
ResultType	string	The type of the full verification result. Valid values: RUNNING, SCHEMA_MISMATCH, INDEX_CONFLICT, TARGET_TABLE_NOT_EXIST, RUNTIME_EXCEPTION, BOTH_EMPTY, CONSISTENT, INCONSISTENT, SOURCE_EMPTY, TARGET_EMPTY, MISMATCH_LIMIT, MISMATCH_LIMIT_NO_PK, and NOT_CATEGORIZED.	RUNNING
ResultDesc	string	A description of the full verification result type.	desc
ErrorDetails	array<object>	A list of error details for the table if the verification failed.
	array<object>	Details about a specific error.
Code	string	The error code (new).	CM-RESOAT1111
Level	string	The error level. Valid values include `FATAL`, `ERROR`, `WARNING`, and `CRITICAL`.	ERROR
Message	string	The error message (new).	null
ExtraContext	object	Provides values for the placeholders in the `Message` field.
	any	The value of a placeholder.	null
MessageMcmsKey	string	The key of the error message.	null
MessageMcmsContext	object	Provides values for the placeholders in the template identified by `MessageMcmsKey`.
	string	The value of a placeholder.	null
Reason	string	The reason for the error.	null
ReasonMcmsKey	string	The key of the error reason.	null
ReasonMcmsContext	object	Provides values for the placeholders in the template identified by `ReasonMcmsKey`.
	string	The value of a placeholder.	null
Proposal	string	The recommended action (new).	null
ProposalMcmsKey	string	The key for the recommended action.	null
ProposalMcmsContext	object	Provides values for the placeholders in the template identified by `ProposalMcmsKey`.
	string	The value of a placeholder.	null
UpstreamErrorDetail	any	The detailed error information from an upstream service.	null

Examples

Success response

JSON format

{
  "Success": true,
  "ErrorDetail": {
    "Code": "CM-RESOAT1111\n",
    "Level": "ERROR",
    "Message": "A system error occurred.",
    "ExtraContext": {
      "key": "null"
    },
    "MessageMcmsKey": "null",
    "MessageMcmsContext": {
      "key": "null"
    },
    "Reason": "null",
    "ReasonMcmsKey": "null",
    "ReasonMcmsContext": {
      "key": "null"
    },
    "Proposal": "null",
    "ProposalMcmsKey": "null",
    "ProposalMcmsContext": {
      "key": "null"
    },
    "UpstreamErrorDetail": "null"
  },
  "Code": "INNER_ERROR",
  "Message": "A system error occurred.\n",
  "Advice": "Contact the administrator.",
  "RequestId": "EE205C00-30E4-XXXX-XXXX-87E3A8A2AA0C",
  "PageNumber": 1,
  "PageSize": 10,
  "TotalCount": 1,
  "Cost": "1",
  "Data": {
    "DifferentNumber": 11,
    "FullVerifyTableStatistics": [
      {
        "SourceTableName": "source_table",
        "SourceSchemaName": "source_db",
        "DestSchemaName": "dest_db",
        "SourceOnlyCount": 0,
        "DestOnlyCount": 0,
        "MismatchedCount": 0,
        "ConsistentCount": 200,
        "Progress": "80",
        "Message": "null",
        "Status": "RUNNING",
        "ResultType": "RUNNING",
        "ResultDesc": "desc",
        "ErrorDetails": [
          {
            "Code": "CM-RESOAT1111\n",
            "Level": "ERROR",
            "Message": "null",
            "ExtraContext": {
              "key": "null"
            },
            "MessageMcmsKey": "null",
            "MessageMcmsContext": {
              "key": "null"
            },
            "Reason": "null",
            "ReasonMcmsKey": "null",
            "ReasonMcmsContext": {
              "key": "null"
            },
            "Proposal": "null",
            "ProposalMcmsKey": "null",
            "ProposalMcmsContext": {
              "key": "null"
            },
            "UpstreamErrorDetail": "null"
          }
        ]
      }
    ]
  }
}

Error codes

See Error Codes for a complete list.

Release notes

See Release Notes for a complete list.