All Products
Search

This Product

    Data Transmission Service:DescribeDtsJobDetail

    Document Center

    Data Transmission Service:DescribeDtsJobDetail

    Last Updated:Oct 25, 2023

    Queries the details of a data migration, data synchronization, or change tracking task.

    Debugging

    OpenAPI Explorer automatically calculates the signature value. For your convenience, we recommend that you call this operation in OpenAPI Explorer. OpenAPI Explorer dynamically generates the sample code of the operation for different SDKs.

    Request parameters

    Parameter

    Type

    Required

    Example

    Description
    Action String Yes DescribeDtsJobDetail

    The operation that you want to perform. Set the value to DescribeDtsJobDetail.

    DtsJobId String Yes ta7w132u12h****

    The ID of the data migration, data synchronization, or change tracking task.

    DtsInstanceID String No dtsta7w132u12h****

    The ID of the data migration, data synchronization, or change tracking instance.

    SynchronizationDirection String No Forward

    The synchronization direction. Valid values:

    • Forward: Data is synchronized from the source database to the destination database.
    • Reverse: Data is synchronized from the destination database to the source database.
    Note
    • Default value: Forward.
    • The value Reverse takes effect only if the topology of the data synchronization instance is two-way synchronization.
    RegionId String No cn-hangzhou

    The region ID of the Data Transmission Service (DTS) instance. For more information, see Supported regions.

    SyncSubJobHistory Boolean No false

    Specifies whether to return the information about all data synchronization subtasks. Default value: false. A value of false indicates that the system returns only the information about a data synchronization subtask that is running or was most recently run.

    Response parameters

    Parameter

    Type

    Example

    Description
    Status String Migrating

    The state of the data migration or data synchronization task.

    Valid values for a data migration task:

    • NotStarted: The task is not started.
    • Migrating: The task is in progress.
    • Failed: The task failed.
    • Finished: The task is complete.

    Valid values for a data synchronization task:

    • NotStarted: The task is not started.
    • Prechecking: The precheck is in progress.
    • PrecheckFailed: The precheck failed.
    • Initializing: The task is being initialized.
    • InitializeFailed: Initialization failed.
    • Synchronizing: The task is in progress.
    • Failed: The task failed.
    • Suspending: The task is paused.
    • Modifying: The objects in the task are being modified.
    • Finished: The task is complete.
    DtsJobName String api_test

    The name of the data migration, data synchronization, or change tracking task.

    FinishTime String 2023-06-16T10:34:17Z

    The time when the task was complete. The time follows the ISO 8601 standard in the yyyy-MM-ddTHH:mm:ssZ format. The time is displayed in UTC.

    ErrorMessage String DTS-070211: Connect Source DB failed. cause by [com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionException:Could not create connection to database server. Attempted reconnect 3 times. Giving up.][com.mysql.jdbc.exceptions.jdbc4.CommunicationsException:Communications link failure\n\nThe last packet sent successfully to the server was 0 milliseconds ago. The driver has not received any packets from the server.][java.net.ConnectException:Connection timed out (Connection timed out)] About more information in [https://yq.aliyun.com/articles/499178].

    The error message returned if the task failed.

    DtsJobId String i03e3zty16i****

    The ID of the data migration, data synchronization, or change tracking task.

    CreateTime String 2022-03-16T08:01:19Z

    The time when the task was created. The time follows the ISO 8601 standard in the yyyy-MM-ddTHH:mm:ssZ format. The time is displayed in UTC.

    PayType String PrePaid

    The billing method of the DTS instance. Valid values:

    • PrePaid: subscription.
    • PostPaid: pay-as-you-go.
    Reserved String {\"srcHostPorts\":\"\",\"whitelist.dms.online.ddl.enable\":false,\"filterDDL\":false,\"sqlparser.dms.original.ddl\":true,\"srcOracleType\":\"sid\",\"maxRetryTime\":43200,\"destSSL\":\"0\",\"destOracleType\":\"sid\",\"srcSSL\":\"0\",\"dbListCaseChangeMode\":\"default\",\"SourceEngineVersion\":\"8.0.18\",\"srcNetType\":\"VPC\",\"destNetType\":\"VPC\",\"srcVpcNetMappingInst\":\"172.16.1**.**:10803\",\"destVpcNetMappingInst\":\"172.16.1**.**:11077\",\"useJobTask\":\"1\"}

    The DTS reserved parameter. The value is a JSON string. You can specify this parameter in the request to meet specific requirements. For example, you can specify whether to automatically start a precheck. For more information, see MigrationReserved.

    DatabaseCount Integer 2

    The number of ApsaraDB RDS for MySQL instances that are attached to the source PolarDB-X 1.0 instance.

    DtsJobClass String xlarge

    The instance class.

    Note For more information about the test performance of each instance class, see Specifications of data migration instances and Specifications of data synchronization channels.
    EndTimestamp String 2022-03-26T14:03:21Z

    The end of the time range for change tracking. The time follows the ISO 8601 standard in the yyyy-MM-ddTHH:mm:ssZ format. The time is displayed in UTC.

    AppName String new

    Indicates whether the change tracking feature of the new version is used.

    Note This parameter is returned only for change tracking instances of the new version.
    DestNetType String VPC

    The network type of the consumer client. Valid values:

    • CLASSIC: classic network.
    • VPC: virtual private cloud (VPC).
    SubscribeTopic String cn_hangzhou_rm_bp1162kryivb8****_dtstest_version2

    The topic of the change tracking instance.

    Note This parameter is returned only if your change tracking instances are of the new version and you have called the CreateConsumerGroup operation to create a consumer group.
    DtsInstanceID String dtsi03e3zty16i****

    The ID of the data migration, data synchronization, or change tracking instance.

    RequestId String 29207299-7C41-493A-BA4F-2FAC5DE4****

    The request ID.

    Code Integer 200

    The error code. This parameter will be removed in the future.

    Checkpoint Long 1616405159

    The start offset of incremental data migration or data synchronization. This value is a UNIX timestamp representing the number of seconds that have elapsed since January 1, 1970, 00:00:00 UTC.

    Delay Long 0

    The latency of incremental data migration or synchronization. Unit: millisecond.

    ExpireTime String 2023-06-16T08:01:19Z

    The time when the instance expires. The time follows the ISO 8601 standard in the yyyy-MM-ddTHH:mm:ssZ format. The time is displayed in UTC.

    Note This parameter is returned only if the return value of PayType is PrePaid.
    ErrCode String InternalError

    The error code returned if the request failed.

    Success Boolean true

    Indicates whether the request was successful.

    ErrMessage String The Value of Input Parameter %s is not valid.

    The error message returned if the request failed.

    ConsumptionClient String 114.***.***.**:dts********

    The downstream client information, in the following format: <IP address of the downstream client>:<Random ID generated by DTS>.

    DbObject String {\"dtstestdata\":{\"all\":true,\"name\":\"dtstestdata\",\"state\":\"normal\"}}

    The objects of the data migration, data synchronization, or change tracking task. For more information, see Objects of DTS tasks.

    DynamicMessage String DtsJobId

    The dynamic part in the error message. This parameter is used to replace the %s variable in the value of ErrMessage.

    Note For example, if the value of ErrMessage is The Value of Input Parameter %s is not valid and the value of DynamicMessage is DtsJobId, the specified value of DtsJobId is invalid.
    ConsumptionCheckpoint String 2022-03-23T07:30:31Z

    The consumption checkpoint of the change tracking instance. The time follows the ISO 8601 standard in the yyyy-MM-ddTHH:mm:ssZ format. The time is displayed in UTC.

    EtlCalculator String { "cells ": [{\"shape\":\"edge\",\"attrs\":{\"line\":{\"stroke\":\"#b1b1b1\",\"strokeWidth\":1,\"targetMarker\":{\"name\":\"block\",\"args\":{\"size\":\"8\"}},\"strokeDasharray\":\"\"}},\"id\":\"cd1ec473-f9b9-4e9b-a742-ac23f442****\",\"source\":{\"cell\":\"8b261182-bfab-4803-ad8e-6bb08e3e****\",\"port\":\"out1\"},\"target\":{\"cell\":\"b36770df-f48c-4d6b-9644-54c5e924****\",\"port\":\"in1\"},\"zIndex\":7 }] }

    The operator information of the extract, transform, and load (ETL) task.

    Note This parameter is returned only when you query the details of an ETL task.
    HttpStatusCode Integer 200

    The HTTP status code.

    BeginTimestamp String 2022-03-15T08:25:34Z

    The start of the time range for change tracking. The time follows the ISO 8601 standard in the yyyy-MM-ddTHH:mm:ssZ format. The time is displayed in UTC.

    GroupId String rg-acfmzawhxxc****

    The ID of the resource group.

    SynchronizationDirection String Forward

    The synchronization direction. Valid values:

    • Forward: Data is synchronized from the source database to the destination database.
    • Reverse: Data is synchronized from the destination database to the source database.
    Note
    • Default value: Forward.
    • The value Reverse takes effect only if the topology of the data synchronization instance is two-way synchronization.
    DtsJobDirection String Forward

    The synchronization direction. Valid values:

    • Forward: Data is synchronized from the source database to the destination database.
    • Reverse: Data is synchronized from the destination database to the source database.
    Note This parameter is returned only if the topology of the data synchronization instance is two-way synchronization.
    DemoJob Boolean false

    Indicates whether the task is a subtask. Valid values:

    • true
    • false
    SourceEndpoint Object

    The connection settings of the source instance.

    OracleSID String testsid

    The system ID (SID) of the Oracle database.

    Note This parameter is returned only if the return value of EngineName of the source instance is Oracle and the Oracle database is not deployed in a Real Application Clusters (RAC) architecture.
    SslSolutionEnum String DISABLE

    Indicates whether SSL encryption is enabled. Valid values:

    • DISABLE: SSL encryption is disabled.
    • ENABLE_WITH_CERTIFICATE: SSL encryption is enabled and the certificate authority (CA) certificate is uploaded.
    • ENABLE_ONLY_4_MONGODB_ALTAS: SSL encryption is enabled for the connection with an AWS MongoDB Altas database.
    • ENABLE_ONLY_4_KAFKA_SCRAM_SHA_256: SCRAM-SHA-256 is used to encrypt the connection with a Kafka cluster.
    Ip String 172.16.88.***

    The endpoint of the source instance.

    InstanceID String rm-bp1162kryivb8****

    The ID of the source instance.

    RoleName String ram-for-dts

    The name of the Resource Access Management (RAM) role configured for the Alibaba Cloud account that owns the source instance.

    InstanceType String RDS

    The type of the source instance.

    Port String 3306

    The port number of the source instance.

    EngineName String MySQL

    The database engine of the source instance.

    Region String cn-hangzhou

    The region ID of the source instance. For more information, see Supported regions.

    DatabaseName String dtstestdata

    The name of the database that contains the objects to be migrated from the source instance.

    AliyunUid String 140692647406****

    The ID of the Alibaba Cloud account to which the source instance belongs.

    UserName String dtstest

    The database account of the source instance.

    CanModifyPassword Boolean false

    Indicates whether the password can be changed. Valid values:

    • true
    • false
    DestinationEndpoint Object

    The connection settings of the destination instance.

    SslSolutionEnum String DISABLE

    Indicates whether SSL encryption is enabled. Valid values:

    • DISABLE: SSL encryption is disabled.
    • ENABLE_WITH_CERTIFICATE: SSL encryption is enabled and the CA certificate is uploaded.
    • ENABLE_ONLY_4_MONGODB_ALTAS: SSL encryption is enabled for the connection with an AWS MongoDB Altas database.
    • ENABLE_ONLY_4_KAFKA_SCRAM_SHA_256: SCRAM-SHA-256 is used to encrypt the connection with a Kafka cluster.
    OracleSID String testsid

    The SID of the Oracle database.

    Note This parameter is returned only if the return value of EngineName of the destination instance is Oracle and the Oracle database is not deployed in an RAC architecture.
    DatabaseName String dtstestdata

    The name of the database that contains the migrated objects in the destination instance.

    Region String cn-hangzhou

    The region ID of the destination instance. For more information, see Supported regions.

    Ip String 172.16.XX.XX

    The endpoint of the destination instance.

    InstanceID String rm-bp1imrtn6fq7h****

    The ID of the destination instance.

    Port String 3306

    The port number of the destination instance.

    InstanceType String RDS

    The type of the destination instance.

    UserName String dtstest

    The database account of the destination instance.

    EngineName String MySQL

    The database engine of the destination instance.

    CanModifyPassword Boolean false

    Indicates whether the password can be changed. Valid values:

    • true
    • false
    MigrationMode Object

    The migration types or initial synchronization types.

    DataExtractTransformLoad Boolean false

    Indicates whether data transformation is performed. Valid values:

    • true
    • false
    DataInitialization Boolean true

    Indicates whether full data migration or initial full data synchronization is performed. Valid values:

    • true
    • false
    DataSynchronization Boolean true

    Indicates whether incremental data migration or synchronization is performed. Valid values:

    • true
    • false
    StructureInitialization Boolean true

    Indicates whether schema migration or initial schema synchronization is performed. Valid values:

    • true
    • false
    SubscriptionHost Object

    The endpoint of the change tracking instance.

    VpcHost String dts-cn-****-vpc.aliyuncs.com:18003

    The VPC endpoint of the change tracking instance in the <Address>:<Port number> format.

    PublicHost String dts-cn-****.aliyuncs.com:18001

    The public endpoint of the change tracking instance in the <Address>:<Port number> format.

    PrivateHost String dts-cn-****-internal.aliyuncs.com:18002

    The private endpoint of the change tracking instance in the <Address>:<Port number> format.

    SubscriptionDataType Object

    The types of operations that are tracked by the task.

    Dml Boolean true

    Indicates whether DML operations are tracked. Valid values:

    • true
    • false
    Ddl Boolean true

    Indicates whether DDL statements are tracked. Valid values:

    • true
    • false
    SubDistributedJob Array of SubDistributedJob

    The information about the subtasks in the current distributed task. If the DTS task is not a distributed task, the value of this parameter is null.

    Note This parameter is available only if the DTS task is a data synchronization task.
    SubSyncJob Array of Any ****

    The information about the subtasks in the current data synchronization task.

    DtsInstanceID String dtsnjuc14kp12u****

    The ID of the DTS instance.

    DtsJobId String m06j1g92124****

    The ID of the DTS task.

    DtsJobName String dtstest****

    The name of the DTS instance.

    GroupId String rg-acfmzawhxxc****

    The ID of the resource group.

    DatabaseCount Integer 2

    The number of ApsaraDB RDS for MySQL instances that are attached to the source PolarDB-X 1.0 instance.

    DtsJobClass String xlarge

    The instance class.

    DtsJobDirection String Forward

    The synchronization direction. Valid values:

    • Forward: Data is synchronized from the source database to the destination database.
    • Reverse: Data is synchronized from the destination database to the source database.
    Note This parameter is returned only if the topology of the data synchronization instance is two-way synchronization.
    SynchronizationDirection String Forward

    The synchronization direction. Valid values:

    • Forward: Data is synchronized from the source database to the destination database.
    • Reverse: Data is synchronized from the destination database to the source database.
    Note
    • Default value: Forward.
    • The value Reverse takes effect only if the topology of the data synchronization instance is two-way synchronization.
    PayType String PrePaid

    The billing method. Valid values:

    • PrePaid: subscription.
    • PostPaid: pay-as-you-go.
    ExpireTime String 2023-06-16T08:01:19Z

    The time when the instance expires. The time follows the ISO 8601 standard in the yyyy-MM-ddTHH:mm:ssZ format. The time is displayed in UTC.

    Note This parameter is returned only if the return value of PayType is PrePaid.
    CreateTime String 2023-01-12T08:34:11Z

    The time when the task was created. The time follows the ISO 8601 standard in the yyyy-MM-ddTHH:mm:ssZ format. The time is displayed in UTC.

    FinishTime String 2023-06-16T10:34:17Z

    The time when the task was complete. The time follows the ISO 8601 standard in the yyyy-MM-ddTHH:mm:ssZ format. The time is displayed in UTC.

    SourceEndpoint Object

    The connection settings of the source instance.

    InstanceID String dtsnjuc14kp12u****

    The ID of the source instance.

    Region String cn-hangzhou

    The region ID of the source instance. For more information, see Supported regions.

    InstanceType String RDS

    The type of the source instance.

    EngineName String MySQL

    The database engine of the source instance.

    Ip String 192.168.XX.XX

    The endpoint of the source instance.

    Port String 3306

    The port number of the source instance.

    DatabaseName String dtstestdata

    The name of the database that contains the objects to be migrated from the source instance.

    OracleSID String testsid

    The SID of the Oracle database.

    Note This parameter is returned only if the return value of EngineName of the destination instance is Oracle and the Oracle database is not deployed in an RAC architecture.
    UserName String dtstest

    The database account of the source instance.

    SslSolutionEnum String DISABLE

    Indicates whether SSL encryption is enabled. Valid values:

    • DISABLE: SSL encryption is disabled.
    • ENABLE_WITH_CERTIFICATE: SSL encryption is enabled and the CA certificate is uploaded.
    • ENABLE_ONLY_4_MONGODB_ALTAS: SSL encryption is enabled for the connection with an AWS MongoDB Altas database.
    • ENABLE_ONLY_4_KAFKA_SCRAM_SHA_256: SCRAM-SHA-256 is used to encrypt the connection with a Kafka cluster.
    RoleName String ram-for-dts

    The name of the RAM role configured for the Alibaba Cloud account that owns the source instance.

    AliyunUid String 140692647406****

    The ID of the Alibaba Cloud account to which the source instance belongs.

    DestinationEndpoint Object

    The connection settings of the destination instance.

    InstanceID String rm-bp1f9guj5rhzq****

    The ID of the destination instance.

    Region String cn-hangzhou

    The region ID of the destination instance. For more information, see Supported regions.

    InstanceType String RDS

    The type of the destination instance.

    EngineName String MySQL

    The database engine of the destination instance.

    Ip String 192.168.XX.XX

    The endpoint of the destination instance.

    Port String 3306

    The port number of the destination instance.

    DatabaseName String dtstestdata

    The name of the database that contains the migrated objects in the destination instance.

    OracleSID String testid

    The SID of the Oracle database.

    Note This parameter is returned only if the return value of EngineName of the destination instance is Oracle and the Oracle database is not deployed in an RAC architecture.
    UserName String dtstest

    The database account of the destination instance.

    SslSolutionEnum String DISABLE

    Indicates whether SSL encryption is enabled. Valid values:

    • DISABLE: SSL encryption is disabled.
    • ENABLE_WITH_CERTIFICATE: SSL encryption is enabled and the CA certificate is uploaded.
    • ENABLE_ONLY_4_MONGODB_ALTAS: SSL encryption is enabled for the connection with an AWS MongoDB Altas database.
    • ENABLE_ONLY_4_KAFKA_SCRAM_SHA_256: SCRAM-SHA-256 is used to encrypt the connection with a Kafka cluster.
    RoleName String ram-for-dts

    The name of the RAM role configured for the Alibaba Cloud account that owns the destination instance.

    AliyunUid String 140692647406****

    The ID of the Alibaba Cloud account to which the destination instance belongs.

    DbObject String {\"dtstestdata\":{\"all\":true,\"name\":\"dtstestdata\",\"state\":\"normal\"}}

    The objects of the data migration, data synchronization, or change tracking task. For more information, see Objects of DTS tasks.

    MigrationMode Object

    The migration types or initial synchronization types.

    StructureInitialization Boolean true

    Indicates whether schema migration or initial schema synchronization is performed. Valid values:

    • true
    • false
    DataInitialization Boolean true

    Indicates whether full data migration or initial full data synchronization is performed. Valid values:

    • true
    • false
    DataSynchronization Boolean true

    Indicates whether incremental data migration or synchronization is performed. Valid values:

    • true
    • false
    DataExtractTransformLoad Boolean false

    Indicates whether data transformation is performed. Valid values:

    • true
    • false
    Status String Finished

    The state of the data migration or data synchronization task.

    Valid values for a data migration task:

    • NotStarted: The task is not started.
    • Migrating: The task is in progress.
    • Failed: The task failed.
    • Finished: The task is complete.

    Valid values for a data synchronization task:

    • NotStarted: The task is not started.
    • Prechecking: The precheck is in progress.
    • PrecheckFailed: The precheck failed.
    • Initializing: The task is being initialized.
    • InitializeFailed: Initialization failed.
    • Synchronizing: The task is in progress.
    • Failed: The task failed.
    • Suspending: The task is paused.
    • Modifying: The objects in the task are being modified.
    • Finished: The task is complete.
    ErrorMessage String DTS-070211: Connect Source DB failed. cause by ****

    The error message returned if the task failed.

    Delay Long 0

    The latency of incremental data migration or synchronization. Unit: millisecond.

    TagList Array of TagList

    The tags of the task.

    Id Long 2

    The tag ID.

    GmtCreate String 2022-03-16T08:01:19Z

    The time when the tag was created.

    GmtModified String 2022-03-16T08:01:19Z

    The time when the tag was modified.

    ResourceId String dtsnjuc14kp12u****

    The ID of the data migration, data synchronization, or change tracking instance.

    ResourceType String ALIYUN::DTS::INSTANCE

    The resource type.

    RegionId String cn-hangzhou

    The region ID of the DTS task. For more information, see Supported regions.

    AliUid Long 191448876515****

    The ID of the Alibaba Cloud account.

    TagKey String key1

    The tag key.
    TagValue String value1

    The tag value.
    TagCategory String System

    The tag type. Valid values:

    • System: The tag was created by the system.
    • Custom: The tag was created by a user.
    Note If the parameter is left empty, public tags are returned by default.
    SrcRegion String cn-hangzhou

    The region ID of the DTS task.

    Note In most cases, the region ID of the destination instance is returned.
    Scope String 0

    Indicates whether the tag is visible. Valid values:

    • 0: The tag is public.
    • 1: The tag is private.
    Creator Long 191448876515****

    The tag operator.

    Checkpoint String 1616405159

    The start offset of incremental data migration or data synchronization. This value is a UNIX timestamp representing the number of seconds that have elapsed since January 1, 1970, 00:00:00 UTC.

    PrecheckStatus Object

    The precheck state.

    Status String Finished

    The precheck state. Valid values:

    • NotStarted: The precheck is not started.
    • Prechecking: The precheck is in progress.
    • PrecheckFailed: The precheck failed.
    • Finished: The precheck is complete.
    Percent String 100

    The precheck progress. Unit: percentage.

    ErrorMessage String DTS-070211: Connect Source DB failed. cause by ****

    The error message returned if the task failed.

    Detail Array of Detail

    The result of each precheck item.

    CheckItem String CHECK_CONN_SRC

    The name of the precheck item.

    CheckItemDescription String CHECK_CONN_SRC_DETAIL

    The description of the precheck item.

    CheckResult String Success

    The precheck result. Valid values:

    • Success
    • Failed
    FailedReason String Original error: Access denied for user 'dtstest'@'100.104.***.**' (using password: YES)

    The error message returned if the task failed to pass the precheck.

    Note This parameter is returned only if the return value of CheckResult is Failed.
    RepairMethod String CHECK_ERROR_DEST_CONN_REPAIR2

    The method to fix a precheck failure.

    Note This parameter is returned only if the return value of CheckResult is Failed.
    StructureInitializationStatus Object

    The state of initial schema synchronization.

    Status String Finished

    The state of initial schema synchronization. Valid values:

    • NotStarted: The task is not started.
    • Migrating: The task is in progress.
    • Failed: The task failed.
    • Finished: The task is complete.
    ErrorMessage String DTS-070211: Connect Source DB failed. cause by ****

    The error message returned if the task failed.

    Percent String 100

    The progress of initial schema synchronization. Unit: percentage.

    Progress String 1

    The number of tables that have been synchronized during initial schema synchronization.

    NeedUpgrade Boolean true

    Indicates whether the instance specifications need to be upgraded. Valid values:

    • true
    • false
    DataInitializationStatus Object

    The state of full data migration or initial full data synchronization.

    Status String Finished

    The state of full data migration or initial full data synchronization. Valid values:

    • NotStarted: The task is not started.
    • Migrating: The task is in progress.
    • Failed: The task failed.
    • Finished: The task is complete.
    ErrorMessage String DTS-070211: Connect Source DB failed. cause by ****

    The error message returned if full data migration or initial full data synchronization failed.

    Percent String 100

    The progress of full data migration or initial full data synchronization. Unit: percentage.

    Progress String 16

    The number of entries that have been migrated or synchronized during full data migration or initial full data synchronization.

    NeedUpgrade Boolean true

    Indicates whether the instance specifications need to be upgraded. Valid values:

    • true
    • false
    DataSynchronizationStatus Object

    The state of incremental data migration or synchronization.

    Status String Catched

    The state of incremental data migration or synchronization. Valid values:

    • NotStarted: The task is not started.
    • Migrating: The task is in progress.
    • Suspending: The task is paused.
    • Checking: The task is in precheck.
    • Failed: The task failed.
    • Finished: The task is complete.
    • Catched: The task is not delayed.
    ErrorMessage String DTS-070211: Connect Source DB failed. cause by ****

    The error message returned if the task failed.

    Percent String 95

    The progress of incremental data migration or synchronization.

    Progress String 0

    The number of entries that have been migrated or synchronized during incremental data migration or synchronization.

    NeedUpgrade Boolean true

    Indicates whether the instance specifications need to be upgraded. Valid values:

    • true
    • false
    DataEtlStatus Object

    The state of the ETL task.

    Note This parameter is returned only if an ETL task is configured.
    Status String Finished

    The state of the ETL task. Valid values:

    • NotStarted: The task is not started.
    • Migrating: The task is in progress.
    • Failed: The task failed.
    • Finished: The task is complete.
    • Catched: The task is not delayed.
    ErrorMessage String DTS-070211: Connect Source DB failed. cause by ****

    The error message returned if the task failed.

    Percent String 100

    The progress of full data migration or initial full data synchronization. Unit: percentage.

    Progress String 16

    The number of entries that have been migrated or synchronized during full data migration or initial full data synchronization.

    NeedUpgrade Boolean true

    Indicates whether the instance specifications need to be upgraded. Valid values:

    • true
    • false
    Performance Object

    The performance of the data migration or synchronization instance.

    Rps String 100

    The number of times that SQL statements are migrated or synchronized per second, including BEGIN, COMMIT, DML, and DDL statements. DML statements include INSERT, DELETE, and UPDATE.

    Flow String 1

    The data traffic that is migrated or synchronized per second. Unit: MB/s.

    ReverseJob Object

    The details of the data synchronization task in the reverse direction.

    Note This parameter is returned only for two-way data synchronization tasks.
    DtsInstanceID String dtsnjuc14kp12u****

    The ID of the DTS instance.

    DtsJobId String m06j1g92124****

    The ID of the DTS task.

    DtsJobName String dtstest****

    The name of the DTS instance.

    GroupId String rg-acfmzawhxxc****

    The ID of the resource group.

    DatabaseCount Integer 2

    The number of ApsaraDB RDS for MySQL instances that are attached to the source PolarDB-X 1.0 instance.

    DtsJobClass String xlarge

    The instance class.

    DtsJobDirection String Forward

    The synchronization direction. Valid values:

    • Forward: Data is synchronized from the source database to the destination database.
    • Reverse: Data is synchronized from the destination database to the source database.
    Note This parameter is returned only if the topology of the data synchronization instance is two-way synchronization.
    SynchronizationDirection String Forward

    The synchronization direction. Valid values:

    • Forward: Data is synchronized from the source database to the destination database.
    • Reverse: Data is synchronized from the destination database to the source database.
    Note
    • Default value: Forward.
    • The value Reverse takes effect only if the topology of the data synchronization instance is two-way synchronization.
    PayType String PrePaid

    The billing method. Valid values:

    • PrePaid: subscription.
    • PostPaid: pay-as-you-go.
    ExpireTime String 2023-06-16T08:01:19Z

    The time when the instance expires. The time follows the ISO 8601 standard in the yyyy-MM-ddTHH:mm:ssZ format. The time is displayed in UTC.

    Note This parameter is returned only if the return value of PayType is PrePaid.
    CreateTime String 2023-01-12T08:34:11Z

    The time when the task was created. The time follows the ISO 8601 standard in the yyyy-MM-ddTHH:mm:ssZ format. The time is displayed in UTC.

    FinishTime String 2023-06-16T10:34:17Z

    The time when the task was complete. The time follows the ISO 8601 standard in the yyyy-MM-ddTHH:mm:ssZ format. The time is displayed in UTC.

    SourceEndpoint Object

    The connection settings of the source instance.

    InstanceID String rm-bp2f3huj5rhzq****

    The ID of the source instance.

    Region String cn-hangzhou

    The region ID of the source instance. For more information, see Supported regions.

    InstanceType String RDS

    The type of the source instance.

    EngineName String MySQL

    The database engine of the source instance.

    Ip String 192.168.XX.XX

    The endpoint of the source instance.

    Port String 3306

    The port number of the source instance.

    DatabaseName String dtstestdata

    The name of the database that contains the objects to be migrated from the source instance.

    OracleSID String testsid

    The SID of the Oracle database.

    Note This parameter is returned only if the return value of EngineName of the destination instance is Oracle and the Oracle database is not deployed in an RAC architecture.
    UserName String dtstest

    The database account of the source instance.

    SslSolutionEnum String DISABLE

    Indicates whether SSL encryption is enabled. Valid values:

    • DISABLE: SSL encryption is disabled.
    • ENABLE_WITH_CERTIFICATE: SSL encryption is enabled and the CA certificate is uploaded.
    • ENABLE_ONLY_4_MONGODB_ALTAS: SSL encryption is enabled for the connection with an AWS MongoDB Altas database.
    • ENABLE_ONLY_4_KAFKA_SCRAM_SHA_256: SCRAM-SHA-256 is used to encrypt the connection with a Kafka cluster.
    RoleName String ram-for-dts

    The name of the RAM role configured for the Alibaba Cloud account that owns the source instance.

    AliyunUid String 140692647406****

    The ID of the Alibaba Cloud account to which the source instance belongs.

    DestinationEndpoint Object

    The connection settings of the destination instance.

    InstanceID String rm-bp1f9guj5rhzq****

    The ID of the destination instance.

    Region String cn-hangzhou

    The region ID of the destination instance. For more information, see Supported regions.

    InstanceType String RDS

    The type of the destination instance.

    EngineName String MySQL

    The database engine of the destination instance.

    Ip String 192.168.XX.XX

    The endpoint of the destination instance.

    Port String 3306

    The port number of the destination instance.

    DatabaseName String dtstestdata

    The name of the database that contains the migrated objects in the destination instance.

    OracleSID String testsid

    The SID of the Oracle database.

    Note This parameter is returned only if the return value of EngineName of the destination instance is Oracle and the Oracle database is not deployed in an RAC architecture.
    UserName String dtstest

    The database account of the destination instance.

    SslSolutionEnum String DISABLE

    Indicates whether SSL encryption is enabled. Valid values:

    • DISABLE: SSL encryption is disabled.
    • ENABLE_WITH_CERTIFICATE: SSL encryption is enabled and the CA certificate is uploaded.
    • ENABLE_ONLY_4_MONGODB_ALTAS: SSL encryption is enabled for the connection with an AWS MongoDB Altas database.
    • ENABLE_ONLY_4_KAFKA_SCRAM_SHA_256: SCRAM-SHA-256 is used to encrypt the connection with a Kafka cluster.
    RoleName String ram-for-dts

    The name of the RAM role configured for the Alibaba Cloud account that owns the destination instance.

    AliyunUid String 140692647406****

    The ID of the Alibaba Cloud account to which the destination instance belongs.

    DbObject String {\"dtstestdata\":{\"all\":true,\"name\":\"dtstestdata\",\"state\":\"normal\"}}

    The objects of the data migration, data synchronization, or change tracking task. For more information, see Objects of DTS tasks.

    MigrationMode Object

    The migration types or initial synchronization types.

    StructureInitialization Boolean true

    Indicates whether schema migration or initial schema synchronization is performed. Valid values:

    • true
    • false
    DataInitialization Boolean true

    Indicates whether full data migration or initial full data synchronization is performed. Valid values:

    • true
    • false
    DataSynchronization Boolean true

    Indicates whether incremental data migration or synchronization is performed. Valid values:

    • true
    • false
    DataExtractTransformLoad Boolean false

    Indicates whether data transformation is performed. Valid values:

    • true
    • false
    Status String Finished

    The state of the data migration or data synchronization task.

    Valid values for a data migration task:

    • NotStarted: The task is not started.
    • Migrating: The task is in progress.
    • Failed: The task failed.
    • Finished: The task is complete.

    Valid values for a data synchronization task:

    • NotStarted: The task is not started.
    • Prechecking: The precheck is in progress.
    • PrecheckFailed: The precheck failed.
    • Initializing: The task is being initialized.
    • InitializeFailed: Initialization failed.
    • Synchronizing: The task is in progress.
    • Failed: The task failed.
    • Suspending: The task is paused.
    • Modifying: The objects in the task are being modified.
    • Finished: The task is complete.
    ErrorMessage String DTS-070211: Connect Source DB failed. cause by ****

    The error message returned if the task failed.

    Delay Long 0

    The latency of incremental data migration or synchronization. Unit: millisecond.

    TagList Array of TagList

    The tags of the task.

    Id Long 2

    The tag ID.

    GmtCreate String 2022-03-16T08:01:19Z

    The time when the tag was created.

    GmtModified String 2022-03-16T08:01:19Z

    The time when the tag was modified.

    ResourceId String dtsnjuc14kp12u****

    The ID of the data migration, data synchronization, or change tracking instance.

    ResourceType String ALIYUN::DTS::INSTANCE

    The resource type.

    RegionId String cn-hangzhou

    The region ID of the DTS instance. For more information, see Supported regions.

    AliUid Long 191448876515****

    The ID of the Alibaba Cloud account.

    TagKey String key1

    The tag key

    TagValue String value1

    The tag value.

    TagCategory String System

    The tag type. Valid values:

    • System: The tag was created by the system.
    • Custom: The tag was created by a user.
    Note If the parameter is left empty, public tags are returned by default.
    SrcRegion String cn-hangzhou

    The region ID of the DTS task.

    Note In most cases, the region ID of the destination instance is returned.
    Scope String 0

    Indicates whether the tag is visible. Valid values:

    • 0: The tag is public.
    • 1: The tag is private.
    Creator Long 191448876515****

    The tag operator.

    Checkpoint String 1616405159

    The start offset of incremental data migration or data synchronization. This value is a UNIX timestamp representing the number of seconds that have elapsed since January 1, 1970, 00:00:00 UTC.

    PrecheckStatus Object

    The precheck state.

    Status String Finished

    The precheck state. Valid values:

    • NotStarted: The precheck is not started.
    • Prechecking: The precheck is in progress.
    • PrecheckFailed: The precheck failed.
    • Finished: The precheck is complete.
    Percent String 100

    The precheck progress. Unit: percentage.

    ErrorMessage String DTS-070211: Connect Source DB failed. cause by ****

    The error message returned if the task failed.

    Detail Array of Detail

    The result of each precheck item.

    CheckItem String CHECK_CONN_SRC

    The name of the precheck item.

    CheckItemDescription String CHECK_CONN_SRC_DETAIL

    The description of the precheck item.

    CheckResult String Success

    The precheck result. Valid values:

    • Success
    • Failed
    FailedReason String Original error: Access denied for user 'dtstest'@'100.104.***.**' (using password: YES)

    The error message returned if the task failed to pass the precheck.

    Note This parameter is returned only if the return value of CheckResult is Failed.
    RepairMethod String CHECK_ERROR_DEST_CONN_REPAIR2

    The method to fix a precheck failure.

    Note This parameter is returned only if the return value of CheckResult is Failed.
    StructureInitializationStatus Object

    The state of initial schema synchronization.

    Status String Finished

    The state of initial schema synchronization. Valid values:

    • NotStarted: The task is not started.
    • Migrating: The task is in progress.
    • Failed: The task failed.
    • Finished: The task is complete.
    ErrorMessage String DTS-070211: Connect Source DB failed. cause by ****

    The error message returned if the task failed.

    Percent String 100

    The progress of initial schema synchronization. Unit: percentage.

    Progress String 1

    The number of tables that have been synchronized during initial schema synchronization.

    NeedUpgrade Boolean true

    Indicates whether the instance specifications need to be upgraded. Valid values:

    • true
    • false
    DataInitializationStatus Object

    The state of full data migration or initial full data synchronization.

    Status String Finished

    The state of full data migration or initial full data synchronization. Valid values:

    • NotStarted: The task is not started.
    • Migrating: The task is in progress.
    • Failed: The task failed.
    • Finished: The task is complete.
    ErrorMessage String DTS-070211: Connect Source DB failed. cause by ****

    The error message returned if full data migration or initial full data synchronization failed.

    Percent String 100

    The progress of full data migration or initial full data synchronization. Unit: percentage.

    Progress String 16

    The number of entries that have been migrated or synchronized during full data migration or initial full data synchronization.

    NeedUpgrade Boolean true

    Indicates whether the instance specifications need to be upgraded. Valid values:

    • true
    • false
    DataSynchronizationStatus Object

    The state of incremental data migration or synchronization.

    Status String Catched

    The state of incremental data migration or synchronization. Valid values:

    • NotStarted: The task is not started.
    • Migrating: The task is in progress.
    • Suspending: The task is paused.
    • Checking: The task is in precheck.
    • Failed: The task failed.
    • Finished: The task is complete.
    • Catched: The task is not delayed.
    ErrorMessage String DTS-070211: Connect Source DB failed. cause by ****

    The error message returned if the task failed.

    Percent String 95

    The progress of incremental data migration or synchronization.

    Progress String 0

    The number of entries that have been migrated or synchronized during incremental data migration or synchronization.

    NeedUpgrade Boolean true

    Indicates whether the instance specifications need to be upgraded. Valid values:

    • true
    • false
    DataEtlStatus Object

    The state of the ETL task.

    Note This parameter is returned only if an ETL task is configured.
    Status String Finished

    The state of the ETL task. Valid values:

    • NotStarted: The task is not started.
    • Migrating: The task is in progress.
    • Failed: The task failed.
    • Finished: The task is complete.
    • Catched: The task is not delayed.
    ErrorMessage String DTS-070211: Connect Source DB failed. cause by ****

    The error message returned if the task failed.

    Percent String 100

    The progress of full data migration or initial full data synchronization. Unit: percentage.

    Progress String 16

    The number of entries that have been migrated or synchronized during full data migration or initial full data synchronization.

    NeedUpgrade Boolean true

    Indicates whether the instance specifications need to be upgraded. Valid values:

    • true
    • false
    Performance Object

    The performance of the data migration or synchronization instance.

    Rps String 100

    The number of times that SQL statements are migrated or synchronized per second, including BEGIN, COMMIT, DML, and DDL statements. DML statements include INSERT, DELETE, and UPDATE.

    Flow String 1

    The data traffic that is migrated or synchronized per second. Unit: MB/s.

    ReverseJob Any ****

    The details of the data synchronization task in the reverse direction.

    Note This parameter is returned only for two-way data synchronization tasks.
    Reserved String {\"srcHostPorts\":\"\",\"whitelist.dms.online.ddl.enable\":false,\"filterDDL\":false,\"sqlparser.dms.original.ddl\":true,\"srcOracleType\":\"sid\",\"maxRetryTime\":43200,\"destSSL\":\"0\",\"destOracleType\":\"sid\",\"srcSSL\":\"0\",\"dbListCaseChangeMode\":\"default\",\"SourceEngineVersion\":\"8.0.18\",\"srcNetType\":\"VPC\",\"destNetType\":\"VPC\",\"srcVpcNetMappingInst\":\"172.16.1**.**:10803\",\"destVpcNetMappingInst\":\"172.16.1**.**:11077\",\"useJobTask\":\"1\"}

    The DTS reserved parameter. The value is a JSON string. You can specify this parameter in the request to meet specific requirements. For example, you can specify whether to automatically start a precheck. For more information, see MigrationReserved.

    SubscriptionHost Object

    The endpoint of the change tracking instance.

    PublicHost String dts-cn-****.aliyuncs.com:18001

    The public endpoint of the change tracking instance in the <Address>:<Port number> format.

    PrivateHost String dts-cn-****-internal.aliyuncs.com:18002

    The private endpoint of the change tracking instance in the <Address>:<Port number> format.

    VpcHost String dts-cn-****.aliyuncs.com:18001

    The VPC endpoint of the change tracking instance in the <Address>:<Port number> format.

    SubscribeTopic String cn_hangzhou_rm_bp1162kryivb8****_dtstest_version2

    The topic of the change tracking instance.

    Note This parameter is returned only if your change tracking instances are of the new version and you have called the CreateConsumerGroup operation to create a consumer group.
    ConsumptionCheckpoint String 2022-03-23T07:30:31Z

    The consumption checkpoint of the change tracking instance. The time follows the ISO 8601 standard in the yyyy-MM-ddTHH:mm:ssZ format. The time is displayed in UTC.

    BeginTimestamp String 2022-03-15T08:25:34Z

    The start of the time range for change tracking. The time follows the ISO 8601 standard in the yyyy-MM-ddTHH:mm:ssZ format. The time is displayed in UTC.

    EndTimestamp String 2022-03-26T14:03:21Z

    The end of the time range for change tracking. The time follows the ISO 8601 standard in the yyyy-MM-ddTHH:mm:ssZ format. The time is displayed in UTC.

    ConsumptionClient String 114.***.***.**:dts********

    The downstream client information, in the following format: <IP address of the downstream client>:<Random ID generated by DTS>.

    DestNetType String VPC

    The network type of the consumer client. Valid values:

    • CLASSIC: classic network.
    • VPC: VPC.
    SubscriptionDataType Object

    The types of operations that are tracked by the task.

    Ddl Boolean true

    Indicates whether DDL statements are tracked. Valid values:

    • true
    • false
    Dml Boolean true

    Indicates whether DML operations are tracked. Valid values:

    • true
    • false
    AppName String new

    Indicates whether the change tracking feature of the new version is used.

    Note This parameter is returned only for change tracking instances of the new version.
    EtlCalculator String { "cells ": [{\"shape\":\"edge\",\"attrs\":{\"line\":{\"stroke\":\"#b1b1b1\",\"strokeWidth\":1,\"targetMarker\":{\"name\":\"block\",\"args\":{\"size\":\"8\"}},\"strokeDasharray\":\"\"}},\"id\":\"cd1ec473-f9b9-4e9b-a742-ac23f442****\",\"source\":{\"cell\":\"8b261182-bfab-4803-ad8e-6bb08e3e****\",\"port\":\"out1\"},\"target\":{\"cell\":\"b36770df-f48c-4d6b-9644-54c5e924****\",\"port\":\"in1\"},\"zIndex\":7 }] }

    The operator information of the ETL task.

    Note This parameter is returned only when you query the details of an ETL task.
    RetryState Object

    The information about the retries performed by DTS due to an exception.

    JobId String ta7w132u12h****

    The task ID.

    MaxRetryTime Integer 7200

    The maximum duration of a retry. Unit: seconds.

    RetryTime Integer 3600

    The time that has elapsed from the time when the first retry starts. Unit: seconds.

    RetryCount Integer 5

    The number of retries that have been performed.

    Retrying Boolean true

    Indicates whether the task is being retried. Valid values:

    • true
    • false
    Module String 03

    The progress of the instance when DTS performs retries.

    RetryTarget String srcDB

    The object on which these retries are performed. Valid values:

    • srcDB: the source database.
    • destDB: the destination database.
    • inner_module: an internal module of DTS.
    ErrMsg String CHECK__ERROR_SAME_OBJ

    The error message returned.

    OriginType String DTS

    The task source. Valid values:

    • PTS: Performance Testing (PTS).
    • DMS: Data Management (DMS).
    • DTS: DTS.
    JobType String SYNC

    The type of the DTS task. Valid values:

    • MIGRATION: data migration task.
    • SYNC: data synchronization task.
    • SUBSCRIBE: change tracking task.
    IsDemoJob Boolean false

    Indicates whether the task is a subtask. Valid values:

    • true
    • false
    TaskType String rds

    The task type.

    Reserved String {\"srcHostPorts\":\"\",\"whitelist.dms.online.ddl.enable\":false,\"filterDDL\":false,\"sqlparser.dms.original.ddl\":true,\"srcOracleType\":\"sid\",\"maxRetryTime\":43200,\"destSSL\":\"0\",\"destOracleType\":\"sid\",\"srcSSL\":\"0\",\"dbListCaseChangeMode\":\"default\",\"SourceEngineVersion\":\"8.0.18\",\"srcNetType\":\"VPC\",\"destNetType\":\"VPC\",\"srcVpcNetMappingInst\":\"172.16.1**.**:10803\",\"destVpcNetMappingInst\":\"172.16.1**.**:11077\",\"useJobTask\":\"1\"}

    The DTS reserved parameter. The value is a JSON string. You can specify this parameter in the request to meet specific requirements. For example, you can specify whether to automatically start a precheck. For more information, see MigrationReserved.

    SubscriptionHost Object

    The endpoint of the change tracking instance.

    PublicHost String dts-cn-****.aliyuncs.com:18001

    The public endpoint of the change tracking instance in the <Address>:<Port number> format.

    PrivateHost String dts-cn-****-internal.aliyuncs.com:18002

    The private endpoint of the change tracking instance in the <Address>:<Port number> format.

    VpcHost String dts-cn-****.aliyuncs.com:18001

    The VPC endpoint of the change tracking instance in the <Address>:<Port number> format.

    SubscribeTopic String cn_hangzhou_rm_bp1162kryivb8****_dtstest_version2

    The topic of the change tracking instance.

    Note This parameter is returned only if your change tracking instances are of the new version and you have called the CreateConsumerGroup operation to create a consumer group.
    ConsumptionCheckpoint String 2022-03-23T07:30:31Z

    The consumption checkpoint of the change tracking instance. The time follows the ISO 8601 standard in the yyyy-MM-ddTHH:mm:ssZ format. The time is displayed in UTC.

    BeginTimestamp String 2022-03-15T08:25:34Z

    The start of the time range for change tracking. The time follows the ISO 8601 standard in the yyyy-MM-ddTHH:mm:ssZ format. The time is displayed in UTC.

    EndTimestamp String 2022-03-26T14:03:21Z

    The end of the time range for change tracking. The time follows the ISO 8601 standard in the yyyy-MM-ddTHH:mm:ssZ format. The time is displayed in UTC.

    ConsumptionClient String 114.***.***.**:dts********

    The downstream client information, in the following format: <IP address of the downstream client>:<Random ID generated by DTS>.

    DestNetType String VPC

    The network type of the consumer client. Valid values:

    • CLASSIC: classic network.
    • VPC: VPC.
    SubscriptionDataType Object

    The types of operations that are tracked by the task.

    Ddl Boolean true

    Indicates whether DDL statements are tracked. Valid values:

    • true
    • false
    Dml Boolean true

    Indicates whether DML operations are tracked. Valid values:

    • true
    • false
    AppName String new

    Indicates whether the change tracking feature of the new version is used.

    Note This parameter is returned only for change tracking instances of the new version.
    EtlCalculator String { "cells ": [{\"shape\":\"edge\",\"attrs\":{\"line\":{\"stroke\":\"#b1b1b1\",\"strokeWidth\":1,\"targetMarker\":{\"name\":\"block\",\"args\":{\"size\":\"8\"}},\"strokeDasharray\":\"\"}},\"id\":\"cd1ec473-f9b9-4e9b-a742-ac23f442****\",\"source\":{\"cell\":\"8b261182-bfab-4803-ad8e-6bb08e3e****\",\"port\":\"out1\"},\"target\":{\"cell\":\"b36770df-f48c-4d6b-9644-54c5e924****\",\"port\":\"in1\"},\"zIndex\":7 }] }

    The operator information of the ETL task.

    Note This parameter is returned only when you query the details of an ETL task.
    RetryState Object

    The information about the retries performed by DTS due to an exception.

    JobId String ta7w132u12h****

    The task ID.

    MaxRetryTime Integer 7200

    The maximum duration of a retry. Unit: seconds.

    RetryTime Integer 3600

    The time that has elapsed from the time when the first retry starts. Unit: seconds.

    RetryCount Integer 5

    The number of retries that have been performed.

    Retrying Boolean true

    Indicates whether the task is being retried. Valid values:

    • true
    • false
    Module String 03

    The progress of the instance when DTS performs retries.

    RetryTarget String srcDB

    The object on which these retries are performed. Valid values:

    • srcDB: the source database.
    • destDB: the destination database.
    • inner_module: an internal module of DTS.
    ErrMsg String CHECK__ERROR_SAME_OBJ

    The error message returned.

    OriginType String DTS

    The task source. Valid values:

    • PTS
    • DMS
    • DTS
    JobType String SYNC

    The type of the DTS task. Valid values:

    • MIGRATION: data migration task.
    • SYNC: data synchronization task.
    • SUBSCRIBE: change tracking task.
    IsDemoJob Boolean false

    Indicates whether the task is a subtask. Valid values:

    • true
    • false
    TaskType String rds

    The task type.

    SubSyncJob Array of SubSyncJob

    The information about the subtasks in the current data synchronization task.

    SubSyncJob Array of Any ****

    The information about the subtask in the current data synchronization task.

    DtsInstanceID String dtsnjuc14kp12u****

    The ID of the DTS instance.

    DtsJobId String m06j1g92124****

    The ID of the DTS task.

    DtsJobName String dtstest****

    The name of the DTS instance.

    GroupId String rg-acfmzawhxxc****

    The ID of the resource group.

    DatabaseCount Integer 2

    The number of ApsaraDB RDS for MySQL instances that are attached to the source PolarDB-X 1.0 instance.

    DtsJobClass String xlarge

    The instance class.

    DtsJobDirection String Forward

    The synchronization direction. Valid values:

    • Forward: Data is synchronized from the source database to the destination database.
    • Reverse: Data is synchronized from the destination database to the source database.
    Note This parameter is returned only if the topology of the data synchronization instance is two-way synchronization.
    SynchronizationDirection String Forward

    The synchronization direction. Valid values:

    • Forward: Data is synchronized from the source database to the destination database.
    • Reverse: Data is synchronized from the destination database to the source database.
    Note
    • Default value: Forward.
    • The value Reverse takes effect only if the topology of the data synchronization instance is two-way synchronization.
    PayType String PrePaid

    The billing method. Valid values:

    • PrePaid: subscription.
    • PostPaid: pay-as-you-go.
    ExpireTime String 2023-06-16T08:01:19Z

    The time when the instance expires. The time follows the ISO 8601 standard in the yyyy-MM-ddTHH:mm:ssZ format. The time is displayed in UTC.

    Note This parameter is returned only if the return value of PayType is PrePaid.
    CreateTime String 2023-01-12T08:34:11Z

    The time when the task was created. The time follows the ISO 8601 standard in the yyyy-MM-ddTHH:mm:ssZ format. The time is displayed in UTC.

    FinishTime String 2023-06-16T10:34:17Z

    The time when the task was complete. The time follows the ISO 8601 standard in the yyyy-MM-ddTHH:mm:ssZ format. The time is displayed in UTC.

    SourceEndpoint Object

    The connection settings of the source instance.

    InstanceID String rm-bp2f3huj5rhzq****

    The ID of the source instance.

    Region String cn-hangzhou

    The region ID of the source instance. For more information, see Supported regions.

    InstanceType String RDS

    The type of the source instance.

    EngineName String MySQL

    The database engine of the source instance.

    Ip String 192.168.XX.XX

    The endpoint of the source instance.

    Port String 3306

    The port number of the source instance.

    DatabaseName String dtstestdata

    The name of the database that contains the objects to be migrated from the source instance.

    OracleSID String testsid

    The SID of the Oracle database.

    Note This parameter is returned only if the return value of EngineName of the destination instance is Oracle and the Oracle database is not deployed in an RAC architecture.
    UserName String dtstest

    The database account of the source instance.

    SslSolutionEnum String DISABLE

    Indicates whether SSL encryption is enabled. Valid values:

    • DISABLE: SSL encryption is disabled.
    • ENABLE_WITH_CERTIFICATE: SSL encryption is enabled and the CA certificate is uploaded.
    • ENABLE_ONLY_4_MONGODB_ALTAS: SSL encryption is enabled for the connection with an AWS MongoDB Altas database.
    • ENABLE_ONLY_4_KAFKA_SCRAM_SHA_256: SCRAM-SHA-256 is used to encrypt the connection with a Kafka cluster.
    RoleName String ram-for-dts

    The name of the RAM role configured for the Alibaba Cloud account that owns the source instance.

    AliyunUid String 140692647406****

    The ID of the Alibaba Cloud account to which the source instance belongs.

    DestinationEndpoint Object

    The connection settings of the destination instance.

    InstanceID String rm-bp1f9guj5rhzq****

    The ID of the destination instance.

    Region String cn-hangzhou

    The region ID of destination instance. For more information, see Supported regions.

    InstanceType String RDS

    The type of the destination instance.

    EngineName String MySQL

    The database engine of the destination instance.

    Ip String 192.168.XX.XX

    The endpoint of the destination instance.

    Port String 3306

    The port number of the destination instance.

    DatabaseName String dtstestdata

    The name of the database that contains the migrated objects in the destination instance.

    OracleSID String testsid

    The SID of the Oracle database.

    Note This parameter is returned only if the return value of EngineName of the destination instance is Oracle and the Oracle database is not deployed in an RAC architecture.
    UserName String dtstest

    The database account of the destination instance.

    SslSolutionEnum String DISABLE

    Indicates whether SSL encryption is enabled. Valid values:

    • DISABLE: SSL encryption is disabled.
    • ENABLE_WITH_CERTIFICATE: SSL encryption is enabled and the CA certificate is uploaded.
    • ENABLE_ONLY_4_MONGODB_ALTAS: SSL encryption is enabled for the connection with an AWS MongoDB Altas database.
    • ENABLE_ONLY_4_KAFKA_SCRAM_SHA_256: SCRAM-SHA-256 is used to encrypt the connection with a Kafka cluster.
    RoleName String ram-for-dts

    The name of the RAM role configured for the Alibaba Cloud account that owns the destination instance.

    AliyunUid String 140692647406****

    The ID of the Alibaba Cloud account to which the destination instance belongs.

    DbObject String {\"dtstestdata\":{\"all\":true,\"name\":\"dtstestdata\",\"state\":\"normal\"}}

    The objects of the data migration, data synchronization, or change tracking task. For more information, see Objects of DTS tasks.

    MigrationMode Object

    The migration types or initial synchronization types.

    StructureInitialization Boolean true

    Indicates whether schema migration or initial schema synchronization is performed. Valid values:

    • true
    • false
    DataInitialization Boolean true

    Indicates whether full data migration or initial full data synchronization is performed. Valid values:

    • true
    • false
    DataSynchronization Boolean true

    Indicates whether incremental data migration or synchronization is performed. Valid values:

    • true
    • false
    DataExtractTransformLoad Boolean false

    Indicates whether data transformation is performed. Valid values:

    • true
    • false
    Status String Finished

    The state of the data migration or data synchronization task.

    Valid values for a data migration task:

    • NotStarted: The task is not started.
    • Migrating: The task is in progress.
    • Failed: The task failed.
    • Finished: The task is complete.

    Valid values for a data synchronization task:

    • NotStarted: The task is not started.
    • Prechecking: The precheck is in progress.
    • PrecheckFailed: The precheck failed.
    • Initializing: The task is being initialized.
    • InitializeFailed: Initialization failed.
    • Synchronizing: The task is in progress.
    • Failed: The task failed.
    • Suspending: The task is paused.
    • Modifying: The objects in the task are being modified.
    • Finished: The task is complete.
    ErrorMessage String DTS-070211: Connect Source DB failed. cause by ****

    The error message returned if the task failed.

    Delay Long 0

    The latency of incremental data migration or synchronization. Unit: millisecond.

    TagList Array of TagList

    The tags of the task.

    Id Long 2

    The tag ID.

    GmtCreate String 2022-03-16T08:01:19Z

    The time when the tag was created.

    GmtModified String 2022-03-16T08:01:19Z

    The time when the tag was modified.

    ResourceId String dtsnjuc14kp12u****

    The ID of the data migration, data synchronization, or change tracking instance.

    ResourceType String ALIYUN::DTS::INSTANCE

    The resource type.

    RegionId String cn-hangzhou

    The region ID of the DTS instance. For more information, see Supported regions.

    AliUid Long 191448876515****

    The ID of the Alibaba Cloud account.

    TagKey String key1

    The tag key

    TagValue String value1

    The tag value.

    TagCategory String System

    The tag type. Valid values:

    • System: The tag was created by the system.
    • Custom: The tag was created by a user.
    Note If the parameter is left empty, public tags are returned by default.
    SrcRegion String cn-hangzhou

    The region ID of the DTS task.

    Note In most cases, the region ID of the destination instance is returned.
    Scope String 0

    Indicates whether the tag is visible. Valid values:

    • 0: The tag is public.
    • 1: The tag is private.
    Creator Long 191448876515****

    The tag operator.

    Checkpoint String 1616405159

    The start offset of incremental data migration or data synchronization. This value is a UNIX timestamp representing the number of seconds that have elapsed since January 1, 1970, 00:00:00 UTC.

    PrecheckStatus Object

    The precheck state.

    Status String Finished

    The precheck state. Valid values:

    • NotStarted: The precheck is not started.
    • Prechecking: The precheck is in progress.
    • PrecheckFailed: The precheck failed.
    • Finished: The precheck is complete.
    Percent String 100

    The precheck progress. Unit: percentage.

    ErrorMessage String DTS-070211: Connect Source DB failed. cause by ****

    The error message returned if the task failed.

    Detail Array of Detail

    The result of each precheck item.

    CheckItem String CHECK_CONN_SRC

    The name of the precheck item.

    CheckItemDescription String CHECK_CONN_SRC_DETAIL

    The description of the precheck item.

    CheckResult String Success

    The precheck result. Valid values:

    • Success
    • Failed
    FailedReason String Original error: Access denied for user 'dtstest'@'100.104.***.**' (using password: YES)

    The error message returned if the task failed to pass the precheck.

    Note This parameter is returned only if the return value of CheckResult is Failed.
    RepairMethod String CHECK_ERROR_DEST_CONN_REPAIR2

    The method to fix a precheck failure.

    Note This parameter is returned only if the return value of CheckResult is Failed.
    StructureInitializationStatus Object

    The state of initial schema synchronization.

    Status String Finished

    The state of initial schema synchronization. Valid values:

    • NotStarted: The task is not started.
    • Migrating: The task is in progress.
    • Failed: The task failed.
    • Finished: The task is complete.
    ErrorMessage String DTS-070211: Connect Source DB failed. cause by ****

    The error message returned if the task failed.

    Percent String 100

    The progress of initial schema synchronization. Unit: percentage.

    Progress String 1

    The number of tables that have been synchronized during initial schema synchronization.

    NeedUpgrade Boolean true

    Indicates whether the instance specifications need to be upgraded. Valid values:

    • true
    • false
    DataInitializationStatus Object

    The state of full data migration or initial full data synchronization.

    Status String Finished

    The state of full data migration or initial full data synchronization. Valid values:

    • NotStarted: The task is not started.
    • Migrating: The task is in progress.
    • Failed: The task failed.
    • Finished: The task is complete.
    ErrorMessage String DTS-070211: Connect Source DB failed. cause by ****

    The error message returned if full data migration or initial full data synchronization failed.

    Percent String 100

    The progress of full data migration or initial full data synchronization. Unit: percentage.

    Progress String 16

    The number of entries that have been migrated or synchronized during full data migration or initial full data synchronization.

    NeedUpgrade Boolean true

    Indicates whether the instance specifications need to be upgraded. Valid values:

    • true
    • false
    DataSynchronizationStatus Object

    The state of incremental data migration or synchronization.

    Status String Catched

    The state of incremental data migration or synchronization. Valid values:

    • NotStarted: The task is not started.
    • Migrating: The task is in progress.
    • Suspending: The task is paused.
    • Checking: The task is in precheck.
    • Failed: The task failed.
    • Finished: The task is complete.
    • Catched: The task is not delayed.
    ErrorMessage String DTS-070211: Connect Source DB failed. cause by ****

    The error message returned if the task failed.

    Percent String 95

    The progress of incremental data migration or synchronization.

    Progress String 0

    The number of entries that have been migrated or synchronized during incremental data migration or synchronization.

    NeedUpgrade Boolean true

    Indicates whether the instance specifications need to be upgraded. Valid values:

    • true
    • false
    DataEtlStatus Object

    The state of the ETL task.

    Note This parameter is returned only if an ETL task is configured.
    Status String Finished

    The state of the ETL task. Valid values:

    • NotStarted: The task is not started.
    • Migrating: The task is in progress.
    • Failed: The task failed.
    • Finished: The task is complete.
    • Catched: The task is not delayed.
    ErrorMessage String DTS-070211: Connect Source DB failed. cause by ****

    The error message returned if the task failed.

    Percent String 100

    The progress of full data migration or initial full data synchronization. Unit: percentage.

    Progress String 16

    The number of entries that have been migrated or synchronized during full data migration or initial full data synchronization.

    NeedUpgrade Boolean true

    Indicates whether the instance specifications need to be upgraded. Valid values:

    • true
    • false
    Performance Object

    The performance of the data migration or synchronization instance.

    Rps String 100

    The number of times that SQL statements are migrated or synchronized per second, including BEGIN, COMMIT, DML, and DDL statements. DML statements include INSERT, DELETE, and UPDATE.

    Flow String 1

    The data traffic that is migrated or synchronized per second. Unit: MB/s.

    ReverseJob Object

    The details of the data synchronization task in the reverse direction.

    Note This parameter is returned only for two-way data synchronization tasks.
    DtsInstanceID String dtsnjuc14kp12u****

    The ID of the DTS instance.

    DtsJobId String m06j1g92124****

    The ID of the DTS task.

    DtsJobName String dtstest****

    The name of the DTS instance.

    GroupId String rg-acfmzawhxxc****

    The ID of the resource group.

    DatabaseCount Integer 2

    The number of ApsaraDB RDS for MySQL instances that are attached to the source PolarDB-X 1.0 instance.

    DtsJobClass String xlarge

    The instance class.

    DtsJobDirection String Forward

    The synchronization direction. Valid values:

    • Forward: Data is synchronized from the source database to the destination database.
    • Reverse: Data is synchronized from the destination database to the source database.
    Note This parameter is returned only if the topology of the data synchronization instance is two-way synchronization.
    SynchronizationDirection String Forward

    The synchronization direction. Valid values:

    • Forward: Data is synchronized from the source database to the destination database.
    • Reverse: Data is synchronized from the destination database to the source database.
    Note
    • Default value: Forward.
    • The value Reverse takes effect only if the topology of the data synchronization instance is two-way synchronization.
    PayType String PrePaid

    The billing method. Valid values:

    • PrePaid: subscription.
    • PostPaid: pay-as-you-go.
    ExpireTime String 2023-06-16T08:01:19Z

    The time when the instance expires. The time follows the ISO 8601 standard in the yyyy-MM-ddTHH:mm:ssZ format. The time is displayed in UTC.

    Note This parameter is returned only if the return value of PayType is PrePaid.
    CreateTime String 2023-01-12T08:34:11Z

    The time when the task was created. The time follows the ISO 8601 standard in the yyyy-MM-ddTHH:mm:ssZ format. The time is displayed in UTC.

    FinishTime String 2023-06-16T10:34:17Z

    The time when the task was complete. The time follows the ISO 8601 standard in the yyyy-MM-ddTHH:mm:ssZ format. The time is displayed in UTC.

    SourceEndpoint Object

    The connection settings of the source instance.

    InstanceID String rm-bp2f3huj5rhzq****

    The ID of the DTS instance.

    Region String cn-hangzhou

    The region ID of the source instance. For more information, see Supported regions.

    InstanceType String RDS

    The type of the source instance.

    EngineName String MySQL

    The database engine of the source instance.

    Ip String 192.168.XX.XX

    The endpoint of the source instance.

    Port String 3306

    The port number of the source instance.

    DatabaseName String dtstestdata

    The name of the database that contains the objects to be migrated from the source instance.

    OracleSID String testsid

    The SID of the Oracle database.

    Note This parameter is returned only if the return value of EngineName of the destination instance is Oracle and the Oracle database is not deployed in an RAC architecture.
    UserName String dtstest

    The database account of the source instance.

    SslSolutionEnum String DISABLE

    Indicates whether SSL encryption is enabled. Valid values:

    • DISABLE: SSL encryption is disabled.
    • ENABLE_WITH_CERTIFICATE: SSL encryption is enabled and the CA certificate is uploaded.
    • ENABLE_ONLY_4_MONGODB_ALTAS: SSL encryption is enabled for the connection with an AWS MongoDB Altas database.
    • ENABLE_ONLY_4_KAFKA_SCRAM_SHA_256: SCRAM-SHA-256 is used to encrypt the connection with a Kafka cluster.
    RoleName String ram-for-dts

    The name of the RAM role configured for the Alibaba Cloud account that owns the source instance.

    AliyunUid String 140692647406****

    The ID of the Alibaba Cloud account to which the source instance belongs.

    DestinationEndpoint Object

    The connection settings of the destination instance.

    InstanceID String rm-bp1f9guj5rhzq****

    The ID of the destination instance.

    Region String cn-hangzhou

    The region ID of the destination instance. For more information, see Supported regions.

    InstanceType String RDS

    The type of the destination instance.

    EngineName String MySQL

    The database engine of the destination instance.

    Ip String 192.168.XX,XX

    The endpoint of the destination instance.

    Port String 3306

    The port number of the destination instance.

    DatabaseName String dtstestdata

    The name of the database that contains the migrated objects in the destination instance.

    OracleSID String testsid

    The SID of the Oracle database.

    Note This parameter is returned only if the return value of EngineName of the destination instance is Oracle and the Oracle database is not deployed in an RAC architecture.
    UserName String dtstest

    The database account of the destination instance.

    SslSolutionEnum String DISABLE

    Indicates whether SSL encryption is enabled. Valid values:

    • DISABLE: SSL encryption is disabled.
    • ENABLE_WITH_CERTIFICATE: SSL encryption is enabled and the CA certificate is uploaded.
    • ENABLE_ONLY_4_MONGODB_ALTAS: SSL encryption is enabled for the connection with an AWS MongoDB Altas database.
    • ENABLE_ONLY_4_KAFKA_SCRAM_SHA_256: SCRAM-SHA-256 is used to encrypt the connection with a Kafka cluster.
    RoleName String ram-for-dts

    The name of the RAM role configured for the Alibaba Cloud account that owns the destination instance.

    AliyunUid String 140692647406****

    The ID of the Alibaba Cloud account to which the destination instance belongs.

    DbObject String {\"dtstestdata\":{\"all\":true,\"name\":\"dtstestdata\",\"state\":\"normal\"}}

    The objects of the data migration, data synchronization, or change tracking task. For more information, see Objects of DTS tasks.

    MigrationMode Object

    The migration types or initial synchronization types.

    StructureInitialization Boolean true

    Indicates whether schema migration or initial schema synchronization is performed. Valid values:

    • true
    • false
    DataInitialization Boolean true

    Indicates whether full data migration or initial full data synchronization is performed. Valid values:

    • true
    • false
    DataSynchronization Boolean true

    Indicates whether incremental data migration or synchronization is performed. Valid values:

    • true
    • false
    DataExtractTransformLoad Boolean false

    Indicates whether data transformation is performed. Valid values:

    • true
    • false
    Status String Finished

    The state of the data migration or data synchronization task.

    Valid values for a data migration task:

    • NotStarted: The task is not started.
    • Migrating: The task is in progress.
    • Failed: The task failed.
    • Finished: The task is complete.

    Valid values for a data synchronization task:

    • NotStarted: The task is not started.
    • Prechecking: The precheck is in progress.
    • PrecheckFailed: The precheck failed.
    • Initializing: The task is being initialized.
    • InitializeFailed: Initialization failed.
    • Synchronizing: The task is in progress.
    • Failed: The task failed.
    • Suspending: The task is paused.
    • Modifying: The objects in the task are being modified.
    • Finished: The task is complete.
    ErrorMessage String DTS-070211: Connect Source DB failed. cause by ****

    The error message returned if the task failed.

    Delay Long 0

    The latency of incremental data migration or synchronization. Unit: millisecond.

    TagList Array of TagList

    The tags of the task.

    Id Long 2

    The tag ID.

    GmtCreate String 2022-03-16T08:01:19Z

    The time when the tag was created.

    GmtModified String 2022-03-16T08:01:19Z

    The time when the tag was modified.

    ResourceId String dtsnjuc14kp12u****

    The ID of the data migration, data synchronization, or change tracking instance.

    ResourceType String ALIYUN::DTS::INSTANCE

    The resource type.

    RegionId String cn-hangzhou

    The region ID of the DTS instance. For more information, see Supported regions.

    AliUid Long 191448876515****

    The ID of the Alibaba Cloud account.

    TagKey String key1

    The tag key

    TagValue String value1

    The tag value.

    TagCategory String System

    The tag type. Valid values:

    • System: The tag was created by the system.
    • Custom: The tag was created by a user.
    Note If the parameter is left empty, public tags are returned by default.
    SrcRegion String cn-hangzhou

    The region ID of the DTS task.

    Note In most cases, the region ID of the destination instance is returned.
    Scope String 0

    Indicates whether the tag is visible. Valid values:

    • 0: The tag is public.
    • 1: The tag is private.
    Creator Long 191448876515****

    The tag operator.

    Checkpoint String 1616405159

    The start offset of incremental data migration or data synchronization. This value is a UNIX timestamp representing the number of seconds that have elapsed since January 1, 1970, 00:00:00 UTC.

    PrecheckStatus Object

    The precheck state.

    Status String Finished

    The precheck state. Valid values:

    • NotStarted: The precheck is not started.
    • Prechecking: The precheck is in progress.
    • PrecheckFailed: The precheck failed.
    • Finished: The precheck is complete.
    Percent String 100

    The precheck progress. Unit: percentage.

    ErrorMessage String DTS-070211: Connect Source DB failed. cause by ****

    The error message returned if the task failed.

    Detail Array of Detail

    The result of each precheck item.

    CheckItem String CHECK_CONN_SRC

    The name of the precheck item.

    CheckItemDescription String CHECK_CONN_SRC_DETAIL

    The description of the precheck item.

    CheckResult String Success

    The precheck result. Valid values:

    • Success
    • Failed
    FailedReason String Original error: Access denied for user 'dtstest'@'100.104.***.**' (using password: YES)

    The error message returned if the task failed to pass the precheck.

    Note This parameter is returned only if the return value of CheckResult is Failed.
    RepairMethod String CHECK_ERROR_DEST_CONN_REPAIR2

    The method to fix a precheck failure.

    Note This parameter is returned only if the return value of CheckResult is Failed.
    StructureInitializationStatus Object

    The state of initial schema synchronization.

    Status String Finished

    The state of initial schema synchronization. Valid values:

    • NotStarted: The task is not started.
    • Migrating: The task is in progress.
    • Failed: The task failed.
    • Finished: The task is complete.
    ErrorMessage String DTS-070211: Connect Source DB failed. cause by ****

    The error message returned if the task failed.

    Percent String 100

    The progress of initial schema synchronization. Unit: percentage.

    Progress String 1

    The number of tables that have been synchronized during initial schema synchronization.

    NeedUpgrade Boolean true

    Indicates whether the instance specifications need to be upgraded. Valid values:

    • true
    • false
    DataInitializationStatus Object

    The state of full data migration or initial full data synchronization.

    Status String Finished

    The state of full data migration or initial full data synchronization. Valid values:

    • NotStarted: The task is not started.
    • Migrating: The task is in progress.
    • Failed: The task failed.
    • Finished: The task is complete.
    ErrorMessage String DTS-070211: Connect Source DB failed. cause by ****

    The error message returned if full data migration or initial full data synchronization failed.

    Percent String 100

    The progress of full data migration or initial full data synchronization. Unit: percentage.

    Progress String 16

    The number of entries that have been migrated or synchronized during full data migration or initial full data synchronization.

    NeedUpgrade Boolean true

    Indicates whether the instance specifications need to be upgraded. Valid values:

    • true
    • false
    DataSynchronizationStatus Object

    The state of incremental data migration or synchronization.

    Status String Finished

    The state of incremental data migration or synchronization. Valid values:

    • NotStarted: The task is not started.
    • Migrating: The task is in progress.
    • Suspending: The task is paused.
    • Checking: The task is in precheck.
    • Failed: The task failed.
    • Finished: The task is complete.
    • Catched: The task is not delayed.
    ErrorMessage String DTS-070211: Connect Source DB failed. cause by ****

    The error message returned if the task failed.

    Percent String 95

    The progress of incremental data migration or synchronization.

    Progress String 0

    The number of entries that have been migrated or synchronized during incremental data migration or synchronization.

    NeedUpgrade Boolean true

    Indicates whether the instance specifications need to be upgraded. Valid values:

    • true
    • false
    DataEtlStatus Object

    The state of the ETL task.

    Note This parameter is returned only if an ETL task is configured.
    Status String Finished

    The state of the ETL task. Valid values:

    • NotStarted: The task is not started.
    • Migrating: The task is in progress.
    • Failed: The task failed.
    • Finished: The task is complete.
    • Catched: The task is not delayed.
    ErrorMessage String DTS-070211: Connect Source DB failed. cause by ****

    The error message returned if the task failed.

    Percent String 100

    The progress of full data migration or initial full data synchronization. Unit: percentage.

    Progress String 16

    The number of entries that have been migrated or synchronized during full data migration or initial full data synchronization.

    NeedUpgrade Boolean true

    Indicates whether the instance specifications need to be upgraded. Valid values:

    • true
    • false
    Performance Object

    The performance of the data migration or synchronization instance.

    Rps String 100

    The number of times that SQL statements are migrated or synchronized per second, including BEGIN, COMMIT, DML, and DDL statements. DML statements include INSERT, DELETE, and UPDATE.

    Flow String 1

    The data traffic that is migrated or synchronized per second. Unit: MB/s.

    ReverseJob Any ****

    The details of the data synchronization task in the reverse direction.

    Note This parameter is returned only for two-way data synchronization tasks.
    Reserved String {\"srcHostPorts\":\"\",\"whitelist.dms.online.ddl.enable\":false,\"filterDDL\":false,\"sqlparser.dms.original.ddl\":true,\"srcOracleType\":\"sid\",\"maxRetryTime\":43200,\"destSSL\":\"0\",\"destOracleType\":\"sid\",\"srcSSL\":\"0\",\"dbListCaseChangeMode\":\"default\",\"SourceEngineVersion\":\"8.0.18\",\"srcNetType\":\"VPC\",\"destNetType\":\"VPC\",\"srcVpcNetMappingInst\":\"172.16.1**.**:10803\",\"destVpcNetMappingInst\":\"172.16.1**.**:11077\",\"useJobTask\":\"1\"}

    The DTS reserved parameter. The value is a JSON string. You can specify this parameter in the request to meet specific requirements. For example, you can specify whether to automatically start a precheck. For more information, see MigrationReserved.

    SubscriptionHost Object

    The endpoint of the change tracking instance.

    PublicHost String dts-cn-****.aliyuncs.com:18001

    The public endpoint of the change tracking instance in the <Address>:<Port number> format.

    PrivateHost String dts-cn-****-internal.aliyuncs.com:18002

    The private endpoint of the change tracking instance in the <Address>:<Port number> format.

    VpcHost String dts-cn-****.aliyuncs.com:18001

    The VPC endpoint of the change tracking instance in the <Address>:<Port number> format.

    SubscribeTopic String cn_hangzhou_rm_bp1162kryivb8****_dtstest_version2

    The topic of the change tracking instance.

    Note This parameter is returned only if your change tracking instances are of the new version and you have called the CreateConsumerGroup operation to create a consumer group.
    ConsumptionCheckpoint String 2022-03-23T07:30:31Z

    The consumption checkpoint of the change tracking instance. The time follows the ISO 8601 standard in the yyyy-MM-ddTHH:mm:ssZ format. The time is displayed in UTC.

    BeginTimestamp String 2022-03-15T08:25:34Z

    The start of the time range for change tracking. The time follows the ISO 8601 standard in the yyyy-MM-ddTHH:mm:ssZ format. The time is displayed in UTC.

    EndTimestamp String 2022-03-26T14:03:21Z

    The end of the time range for change tracking. The time follows the ISO 8601 standard in the yyyy-MM-ddTHH:mm:ssZ format. The time is displayed in UTC.

    ConsumptionClient String 114.***.***.**:dts********

    The downstream client information, in the following format: <IP address of the downstream client>:<Random ID generated by DTS>.

    DestNetType String VPC

    The network type of the consumer client. Valid values:

    • CLASSIC: classic network.
    • VPC: VPC.
    SubscriptionDataType Object

    The types of operations that are tracked by the task.

    Ddl Boolean true

    Indicates whether DDL statements are tracked. Valid values:

    • true
    • false
    Dml Boolean true

    Indicates whether DML operations are tracked. Valid values:

    • true
    • false
    AppName String new

    Indicates whether the change tracking feature of the new version is used.

    Note This parameter is returned only for change tracking instances of the new version.
    EtlCalculator String { "cells ": [{\"shape\":\"edge\",\"attrs\":{\"line\":{\"stroke\":\"#b1b1b1\",\"strokeWidth\":1,\"targetMarker\":{\"name\":\"block\",\"args\":{\"size\":\"8\"}},\"strokeDasharray\":\"\"}},\"id\":\"cd1ec473-f9b9-4e9b-a742-ac23f442****\",\"source\":{\"cell\":\"8b261182-bfab-4803-ad8e-6bb08e3e****\",\"port\":\"out1\"},\"target\":{\"cell\":\"b36770df-f48c-4d6b-9644-54c5e924****\",\"port\":\"in1\"},\"zIndex\":7 }] }

    The operator information of the ETL task.

    Note This parameter is returned only when you query the details of an ETL task.
    RetryState Object

    The information about the retries performed by DTS due to an exception.

    JobId String ta7w132u12h****

    The task ID.

    MaxRetryTime Integer 7200

    The maximum duration of a retry. Unit: seconds.

    RetryTime Integer 3600

    The time that has elapsed from the time when the first retry starts. Unit: seconds.

    RetryCount Integer 5

    The number of retries that have been performed.

    Retrying Boolean true

    Indicates whether the task is being retried. Valid values:

    • true
    • false
    Module String 03

    The progress of the instance when DTS performs retries.

    RetryTarget String srcDB

    The object on which these retries are performed. Valid values:

    • srcDB: the source database.
    • destDB: the destination database.
    • inner_module: an internal module of DTS.
    ErrMsg String CHECK__ERROR_SAME_OBJ

    The error message returned.

    OriginType String DTS

    The task source. Valid values:

    • PTS
    • DMS
    • DTS
    JobType String SYNC

    The type of the DTS task. Valid values:

    • MIGRATION: data migration task.
    • SYNC: data synchronization task.
    • SUBSCRIBE: change tracking task.
    IsDemoJob Boolean false

    Indicates whether the task is a subtask. Valid values:

    • true
    • false
    TaskType String rds

    The task type.

    Reserved String {\"srcHostPorts\":\"\",\"whitelist.dms.online.ddl.enable\":false,\"filterDDL\":false,\"sqlparser.dms.original.ddl\":true,\"srcOracleType\":\"sid\",\"maxRetryTime\":43200,\"destSSL\":\"0\",\"destOracleType\":\"sid\",\"srcSSL\":\"0\",\"dbListCaseChangeMode\":\"default\",\"SourceEngineVersion\":\"8.0.18\",\"srcNetType\":\"VPC\",\"destNetType\":\"VPC\",\"srcVpcNetMappingInst\":\"172.16.1**.**:10803\",\"destVpcNetMappingInst\":\"172.16.1**.**:11077\",\"useJobTask\":\"1\"}

    The DTS reserved parameter. The value is a JSON string. You can specify this parameter in the request to meet specific requirements. For example, you can specify whether to automatically start a precheck. For more information, see MigrationReserved.

    SubscriptionHost Object

    The endpoint of the change tracking instance.

    PublicHost String dts-cn-****.aliyuncs.com:18001

    The public endpoint of the change tracking instance in the <Address>:<Port number> format.

    PrivateHost String dts-cn-****-internal.aliyuncs.com:18002

    The private endpoint of the change tracking instance in the <Address>:<Port number> format.

    VpcHost String dts-cn-****.aliyuncs.com:18001

    The VPC endpoint of the change tracking instance in the <Address>:<Port number> format.

    SubscribeTopic String cn_hangzhou_rm_bp1162kryivb8****_dtstest_version2

    The topic of the change tracking instance.

    Note This parameter is returned only if your change tracking instances are of the new version and you have called the CreateConsumerGroup operation to create a consumer group.
    ConsumptionCheckpoint String 2022-03-23T07:30:31Z

    The consumption checkpoint of the change tracking instance. The time follows the ISO 8601 standard in the yyyy-MM-ddTHH:mm:ssZ format. The time is displayed in UTC.

    BeginTimestamp String 2022-03-15T08:25:34Z

    The start of the time range for change tracking. The time follows the ISO 8601 standard in the yyyy-MM-ddTHH:mm:ssZ format. The time is displayed in UTC.

    EndTimestamp String 2022-03-26T14:03:21Z

    The end of the time range for change tracking. The time follows the ISO 8601 standard in the yyyy-MM-ddTHH:mm:ssZ format. The time is displayed in UTC.

    ConsumptionClient String 114.***.***.**:dts********

    The downstream client information, in the following format: <IP address of the downstream client>:<Random ID generated by DTS>.

    DestNetType String VPC

    The network type of the consumer client. Valid values:

    • CLASSIC: classic network.
    • VPC: VPC.
    SubscriptionDataType Object

    The types of operations that are tracked by the task.

    Ddl Boolean true

    Indicates whether DDL statements are tracked. Valid values:

    • true
    • false
    Dml Boolean true

    Indicates whether DML operations are tracked. Valid values:

    • true
    • false
    AppName String new

    Indicates whether the change tracking feature of the new version is used.

    Note This parameter is returned only for change tracking instances of the new version.
    EtlCalculator String { "cells ": [{\"shape\":\"edge\",\"attrs\":{\"line\":{\"stroke\":\"#b1b1b1\",\"strokeWidth\":1,\"targetMarker\":{\"name\":\"block\",\"args\":{\"size\":\"8\"}},\"strokeDasharray\":\"\"}},\"id\":\"cd1ec473-f9b9-4e9b-a742-ac23f442****\",\"source\":{\"cell\":\"8b261182-bfab-4803-ad8e-6bb08e3e****\",\"port\":\"out1\"},\"target\":{\"cell\":\"b36770df-f48c-4d6b-9644-54c5e924****\",\"port\":\"in1\"},\"zIndex\":7 }] }

    The operator information of the ETL task.

    Note This parameter is returned only when you query the details of an ETL task.
    RetryState Object

    The information about the retries performed by DTS due to an exception.

    JobId String ta7w132u12h****

    The task ID.

    MaxRetryTime Integer 7200

    The maximum duration of a retry. Unit: seconds.

    RetryTime Integer 3600

    The time that has elapsed from the time when the first retry starts. Unit: seconds.

    RetryCount Integer 5

    The number of retries that have been performed.

    Retrying Boolean true

    Indicates whether the task is being retried. Valid values:

    • true
    • false
    Module String 03

    The progress of the instance when DTS performs retries.

    RetryTarget String srcDB

    The object on which these retries are performed. Valid values:

    • srcDB: the source database.
    • destDB: the destination database.
    • inner_module: an internal module of DTS.
    ErrMsg String CHECK__ERROR_SAME_OBJ

    The error message returned.

    OriginType String DTS

    The task source. Valid values:

    • PTS
    • DMS
    • DTS
    JobType String SYNC

    The type of the DTS task. Valid values:

    • MIGRATION: data migration task.
    • SYNC: data synchronization task.
    • SUBSCRIBE: change tracking task.
    IsDemoJob Boolean false

    Indicates whether the task is a subtask. Valid values:

    • true
    • false
    TaskType String rds

    The task type.

    JobType String sync

    The type of the DTS task. Valid values:

    • sync: A data synchronization task.
    • subSync: A subtask generated when the objects to be synchronized are modified.
    Note In most cases, this parameter is returned together with TaskType.
    TaskType String Distributed_xxx

    The task type.

    Note In most cases, this parameter is returned together with JobType.
    DedicatedClusterId String dtsxxxxx

    The ID of the dedicated cluster.

    DataSynchronizationStatus Object

    The state of incremental data migration or synchronization.

    Status String Catched

    The state of incremental data migration or synchronization. Valid values:

    • NotStarted: The task is not started.
    • Migrating: The task is in progress.
    • Suspending: The task is paused.
    • Checking: The task is in precheck.
    • Failed: The task failed.
    • Finished: The task is complete.
    • Catched: The task is not delayed.
    NeedUpgrade Boolean true

    Indicates whether the instance specifications need to be upgraded. Valid values:

    • true
    • false
    Percent String 95

    The progress of incremental data migration or synchronization. Unit: percentage.

    Progress String 0

    The number of entries that have been migrated or synchronized during incremental data migration or synchronization.

    ErrorMessage String The task has failed for a long time and cannot be recovered.

    The error message returned if incremental data migration or synchronization failed.

    BootTime String 2022-03-30T03:36:11.000

    The time when the task was started. The time follows the ISO 8601 standard in the yyyy-MM-ddTHH:mm:ssZ format. The time is displayed in UTC.

    Binlog String ****

    The binary logs.

    BinlogSite String 156629109****

    The current offset.

    BinlogTime String ****

    The offset range.

    LastUpdateTime String 156629109****

    The timestamp when the task was last updated.

    RetryState Object

    The information about the retries performed by DTS due to an exception.

    RetryCount Integer 5

    The number of retries that have been performed.

    MaxRetryTime Integer 7200

    The maximum duration of a retry. Unit: seconds.

    ErrMessage String Unexpected error

    The error message returned if these retries failed.

    RetryTarget String srcDB

    The object on which these retries are performed. Valid values:

    • srcDB: the source database.
    • destDB: the destination database.
    • inner_module: an internal module of DTS.
    RetryTime Integer 3600

    The time that has elapsed from the time when the first retry starts. Unit: seconds.

    Module String 03

    The progress of the instance when DTS performs retries.

    JobId String bi6e22ay243****

    The task ID.

    Retrying Boolean false

    Indicates whether the task is being retried. Valid values:

    • true
    • false
    ResourceGroupId String rg-acfmzawhxxc****

    The ID of the resource group.

    ResourceGroupDisplayName String default resource group

    The name of the resource group.

    DtsBisLabel String normal

    The environment tag of the DTS instance. Valid values:

    • normal
    • online
    DataDeliveryChannelInfo Object

    The information of the data shipping channel.

    PublicDproxyUrl String dts-****.aliyuncs.com:18***

    The public endpoint of the data shipping channel.

    VpcDproxyUrl String dts-****.aliyuncs.com:18***

    The VPC endpoint of the data shipping channel.

    Topic String cn_hangzhou_******_data_delivery_version2

    The destination topic of the shipped data.

    Region String cn-hangzhou

    The region in which the data shipping channel resides.

    PartitionNum Integer 3

    The number of partitions of the destination topic.

    Examples

    Sample requests

    http(s)://dts.aliyuncs.com/?Action=DescribeDtsJobDetail
&DtsJobId=ta7w132u12h****
&<Common request parameters>

    Sample success responses

    XML format

    HTTP/1.1 200 OK
Content-Type:application/xml

<DescribeDtsJobDetailResponse>
    <DtsJobName>API test</DtsJobName>
    <DtsInstanceID>dtsi03e3zty16i****</DtsInstanceID>
    <Success>true</Success>
    <Delay>0</Delay>
    <MigrationMode>
        <DataInitialization>true</DataInitialization>
        <DataSynchronization>true</DataSynchronization>
        <StructureInitialization>true</StructureInitialization>
    </MigrationMode>
    <DtsJobClass>xlarge</DtsJobClass>
    <DtsJobId>i03e3zty16i****</DtsJobId>
    <HttpStatusCode>200</HttpStatusCode>
    <Status>Migrating</Status>
    <RequestId>29207299-7C41-493A-BA4F-2FAC5DE4****</RequestId>
    <DbObject>{"dtstestdata":{"all":true,"name":"dtstestdata","state":"normal"}}</DbObject>
    <CreateTime>2021-03-16T08:01:19Z</CreateTime>
    <PayType>PostPaid</PayType>
    <Checkpoint>1616405159</Checkpoint>
    <DestinationEndpoint>
        <UserName>dtstest</UserName>
        <InstanceID>rm-bp1imrtn6fq7h****</InstanceID>
        <SslSolutionEnum>DISABLE</SslSolutionEnum>
        <Port>3306</Port>
        <DatabaseName>dtstestdata</DatabaseName>
        <Region>cn-hangzhou</Region>
        <InstanceType>RDS</InstanceType>
        <EngineName>MySQL</EngineName>
    </DestinationEndpoint>
    <SourceEndpoint>
        <RoleName/>
        <UserName>dtstest</UserName>
        <InstanceID>rm-bp1162kryivb8****</InstanceID>
        <SslSolutionEnum>DISABLE</SslSolutionEnum>
        <Port>3306</Port>
        <AliyunUid>140692647406****</AliyunUid>
        <Region>cn-hangzhou</Region>
        <InstanceType>RDS</InstanceType>
        <EngineName>MySQL</EngineName>
    </SourceEndpoint>
    <Reserved>{"srcHostPorts":"","whitelist.dms.online.ddl.enable":false,"filterDDL":false,"sqlparser.dms.original.ddl":true,"srcOracleType":"sid","maxRetryTime":43200,"destSSL":"0","destOracleType":"sid","srcSSL":"0","dbListCaseChangeMode":"default","SourceEngineVersion":"8.0.18","srcNetType":"VPC","destNetType":"VPC","srcVpcNetMappingInst":"172.16.1**.**:1****","destVpcNetMappingInst":"172.16.1**.**:1****","useJobTask":"1"}</Reserved>
</DescribeDtsJobDetailResponse>

    JSON format

    HTTP/1.1 200 OK
Content-Type:application/json

{
  "DtsJobName" : "API test",
  "DtsInstanceID" : "dtsi03e3zty16i****",
  "Success" : true,
  "Delay" : 0,
  "MigrationMode" : {
    "DataInitialization" : true,
    "DataSynchronization" : true,
    "StructureInitialization" : true
  },
  "DtsJobClass" : "xlarge",
  "DtsJobId" : "i03e3zty16i****",
  "HttpStatusCode" : 200,
  "Status" : "Migrating",
  "RequestId" : "29207299-7C41-493A-BA4F-2FAC5DE4****",
  "DbObject" : "{\"dtstestdata\":{\"all\":true,\"name\":\"dtstestdata\",\"state\":\"normal\"}}",
  "CreateTime" : "2021-03-16T08:01:19Z",
  "PayType" : "PostPaid",
  "Checkpoint" : "1616405159",
  "DestinationEndpoint" : {
    "UserName" : "dtstest",
    "InstanceID" : "rm-bp1imrtn6fq7h****",
    "SslSolutionEnum" : "DISABLE",
    "Port" : "3306",
    "DatabaseName" : "dtstestdata",
    "Region" : "cn-hangzhou",
    "InstanceType" : "RDS",
    "EngineName" : "MySQL"
  },
  "SourceEndpoint" : {
    "RoleName" : "",
    "UserName" : "dtstest",
    "InstanceID" : "rm-bp1162kryivb8****",
    "SslSolutionEnum" : "DISABLE",
    "Port" : "3306",
    "AliyunUid" : "140692647406****",
    "Region" : "cn-hangzhou",
    "InstanceType" : "RDS",
    "EngineName" : "MySQL"
  },
  "Reserved" : "{\"srcHostPorts\":\"\",\"whitelist.dms.online.ddl.enable\":false,\"filterDDL\":false,\"sqlparser.dms.original.ddl\":true,\"srcOracleType\":\"sid\",\"maxRetryTime\":43200,\"destSSL\":\"0\",\"destOracleType\":\"sid\",\"srcSSL\":\"0\",\"dbListCaseChangeMode\":\"default\",\"SourceEngineVersion\":\"8.0.18\",\"srcNetType\":\"VPC\",\"destNetType\":\"VPC\",\"srcVpcNetMappingInst\":\"172.16.1**.**:1****\",\"destVpcNetMappingInst\":\"172.16.1**.**:1****\",\"useJobTask\":\"1\"}"
}

    Error codes

    HTTP status code

    Error Code

    Error message

    Description
    400 Throttling.User Request was denied due to user flow control. The number of requests exceeded the limit, and the request was rejected. Try again later.
    500 ServiceUnavailable The request has failed due to a temporary failure of the server. The response of the server timed out or the server was unavailable. Try again. If the error persists, contact technical support.
    403 InvalidSecurityToken.Expired Specified SecurityToken is expired. The signature expired. Use a new signature.

    For a list of error codes, see Service error codes.