Common error codes that may be returned when you configure DTS tasks and solutions

Error code

Scenario

Cause and solution

DTS.Msg.LXCreateOrderError

When you purchase a DTS instance, the order fails to be created.

• Cause: You cannot purchase a cross-border data synchronization instance because the unique ID (UID) of your account is not added to the whitelist.

• Solution: Apply for the permissions to synchronize data across borders and try again. For more information, see Apply for permissions to synchronize data across borders.

DTS.Msg.InvalidParameter.KafkaHostInvalid

You configure a data synchronization or migration task to replicate data to a Kafka cluster that is connected over Express Connect, VPN Gateway, or Smart Access Gateway.

• Cause: You enter a domain name in the IP Address field.

• Solution: You can enter only an IP address in the IP address field. Enter a valid private IP address and try again.

DTS.Msg.InvalidParameter.KafkaBrokerInvalid

You configure a DTS task to replicate data to a self-managed Kafka cluster that is hosted on Elastic Compute Service (ECS).

• Cause: A Kafka node is configured by using a domain name.

• Solution: Configure the Kafka node. based on the following format:

  listeners=Protocol://Private IP address:Port number
  advertised_listeners=Protocol://Private IP address:Port number

DTS.Msg.OperationDenied.JobStatusModifying

You call the ModifyDtsJob operation to modify the configurations of a data synchronization task.

• Cause: The DTS instance to which the task belongs is in the Modifying Objects state.

• Solution: Wait until the state of the instance changes to Running and try again.

DTS.Msg.InvalidParameter.AliyunUidFormat

When you configure a DTS task to replicate data across Alibaba Cloud accounts, you attempt to select a database instance from the drop-down list.

• Cause: The specified Alibaba Cloud account of the source database instance is invalid.

• Solution: Specify a valid Alibaba Cloud account.

DTS.Msg.DuplicateAccount.RDSSqlServer

You specify an SQL Server database as the source or destination database of a DTS task.

• Cause: The database instance is already involved in another DTS task or the database instance is a cloned instance.

• Solution: Contact technical support.

DTS.Msg.SrcLink.InternetAddressNotFound

You configure a cross-region data migration task.

• Cause: The source database instance does not have a public endpoint.

• Solution: Configure a public endpoint for the source database instance or configure a data synchronization task.

DTS.Msg.UpdateJob.OperationDenied.InitStatus

You configure an existing task.

• Cause: The data synchronization task is already configured and started.

• Solution: Reconfigure the data synchronization task or modify the objects to be synchronized.

  Warning

  After you reset a task, the original configurations of the task are overwritten. Proceed with caution.

DTS.Msg.Throttling.User

This error may occur when you use any DTS feature.

• Cause: The maximum number of API requests is reached.

• Solution: Wait 15 to 30 seconds and try again.

DTS.Msg.LXCreateOrder.NotFoundPricePlan

When you purchase a DTS instance, the order fails to be created.

• Cause: You specify an invalid parameter when you call an API operation to create a DTS instance or you cannot purchase a DTS instance of the specified type.

• Solution: Check whether the specified parameters are valid. If the parameters are valid, contact technical support.

DTS.Msg.LXPayOrder.InsufficientBalance

When you purchase a DTS instance, your payment fails.

• Cause: You cannot make the payment due to insufficient account balance.

• Solution: Top up your account and try again.

DTS.Msg.CheckStatus.InvalidInitStatus

You attempt to modify the objects to be synchronized.

• Cause: The data synchronization task is not configured.

• Solution: Complete the configurations of the data synchronization task before you modify the task.

DTS.Msg.DRDSInvokeFail.DatabaseAuthorizationFailed

When you configure a data synchronization task for a PolarDB-X database, an error message similar to the following example appears.

can not getTableTopology (drds****,ib_ibos****)
Could not connect to address=(host=100.100.XX.XX)(port=****)(type=master) : (conn=****) [10.0.1.1:3306]
Access denied for user 'ib_ibos****'@'100.104.XX.XX' to database 'ib_ibos****')

• Cause: The specified database account does not have the required permissions on a specific database.

• Solution: Manually grant or modify the permissions on the database to the specified database account. To do so, perform the following steps:

  1. Log on to the PolarDB-X console.

  2. In the left-side navigation pane, click Instances. On the Instances page, click the name of the instance that you created.

  3. In the left-side navigation pane, choose Configuration and Management > Accounts.

  4. Find the created database account and click Modify Permission in the Actions column. In the dialog box that appears, add or modify the permissions on the database.

  5. Click OK.

DTS.Msg.DescribeColumns.TimeOut

You attempt to obtain the information about columns in the source database, especially for a DTS task whose destination database is an AnalyticDB for MySQL cluster.

• Cause: The source database has a large number of columns or is read at an excessively slow speed. As a result, the process of obtaining the schema of the source database times out.

• Solution:

  • Call the relevant API operation to obtain the source database schema.

  • Check the speed at which the source database is read.

DTS.Msg.DescribeStruct.TimeOut

You attempt to obtain the information about the source database and tables in the source database after the connectivity test is passed.

• Cause: The source database has a large number of columns or is read at an excessively slow speed. As a result, the process of obtaining the schemas of the source database times out.

• Solution:

  • Specify the schema of the source database as the object to be synchronized or migrated. Do not synchronize or migrate the schemas of tables in the source database.

  • Call the relevant API operation to obtain the source database schema.

  • Check the speed at which the source database is read.

DTS.Msg.DRDSErrExecuteOnMySQL.ClientVersionTooLow

You configure a DTS task to replicate data from a PolarDB-X database.

• Cause: The version of the PolarDB-X instance is earlier than required.

• Solution: Update the PolarDB-X instance to a version that meets the requirements.

DTS.Msg.DbTypeNotSupport.OnlyReadRDS

You configure a DTS task to replicate data from a PolarDB-X database.

• Cause: The source database instance is a read-only PolarDB-X instance. DTS does not support this instance type.

• Solution: Change the source database instance to a PolarDB-X instance of the primary type.

DTS.Msg.DbTypeNotSupport.PolarDBRDS

You configure a DTS task to replicate data from a PolarDB-X database.

• Cause: The source database instance is a PolarDB-X instance whose storage type is PolarDB. DTS does not support this instance type.

• Solution: Change the source database instance to a PolarDB-X instance whose storage type is ApsaraDB RDS for MySQL.

DTS.Msg.OperationDenied.NotPurchased

You fail to start a DTS task by calling an API operation.

• Cause: No DTS instance is purchased for the DTS task that you attempt to start.

• Solution: Purchase a DTS instance and then start the DTS task.

DTS.Msg.CheckJobFailed.ServerUnAvailable

You configure a DTS task.

• Cause: The system cannot connect to the server on which the DTS task runs. As a result, you cannot perform a connectivity test on the source or destination database.

• Solution: Contact technical support.

DTS.Msg.StopJobFailed.ServerUnAvailable

You configure a DTS task.

• Cause: The system cannot connect to the server on which the DTS task runs. As a result, the DTS task cannot be paused as required.

• Solution: Contact technical support.

DTS.Msg.SQLExecuteError.JDBC4CommunicationsException

You attempt to obtain the information about the source database and tables in the source database after the connectivity test is passed.

• Cause: An error occurs during data communication. A packet is sent from the Java Database Connectivity (JDBC) driver to the source database server, but no packet is received from the source database server.

• Solution:

  • Check whether the database has a large number of connections.

  • Refer to the solutions in Solving a "communications link failure" with JDBC and MySQL.

  • Contact technical support.

DTS.Msg.SQLExecuteError.ConnectionRefused

You attempt to obtain the information about the source database and tables in the source database after the connectivity test is passed.

• Cause: Your request to connect to the source database is denied.

• Solution:

  • Check whether the listener process properly runs. If not, check whether the listener process is properly configured.

  • Check whether the load is high.

  • Contact technical support.

DTS.Msg.GetKafkaMetaInfo.NoAvailableBroker

You set the Kafka Version parameter to Later Than 1.0 for the destination Kafka cluster.

• Cause:

  • You enter an invalid username or password of the database account.

  • You cannot obtain MetaInfo from the Kafka broker.

• Solution:

  • Enter the valid username and password. If authentication is disabled for the Kafka cluster, you do not need to enter the username or password.

  • Check whether the bootstrap.servers parameter of the Kafka broker is properly specified.

  • Check whether the version of the destination Kafka cluster meets the requirements.

  • Check whether the network connection is established.

DTS.Msg.GetMongoDbShardInfo.EmptyInstances

You configure a DTS task whose source or destination database is an ApsaraDB for MongoDB sharded cluster instance.

• Cause: You cannot obtain the information about shards.

• Solution: Check the configured parameters to ensure that the database is an ApsaraDB for MongoDB sharded cluster instance.

DTS.Msg.GetMongoDbShardInfo.NoShardAddress

You configure a DTS task whose source or destination database is an ApsaraDB for MongoDB sharded cluster instance.

• Cause: You cannot obtain the information about shards.

• Solution: Check the configured parameters. Make sure that the database is an ApsaraDB for MongoDB sharded cluster instance and that endpoints are applied for the shards. For more information, see Apply for an endpoint for a shard node or the ConfigServer node in a sharded cluster instance.

DTS.Msg.SuspendDenied.JobStatusModifying

You attempt to pause one or more DTS tasks at a time.

• Cause: One or more DTS tasks are in the Modifying Objects state. To prevent data inconsistency, DTS does not allow you to pause DTS tasks in the Modifying Objects state.

• Solution:

  • Pause a task: Wait until the Modifying Objects state ends.

  • Pause multiple tasks at a time: Remove tasks in the Modifying Objects state or wait until the state ends.

DTS.Msg.ModifyDenied.JobStatusNotRunning

You attempt to modify the objects to be synchronized in a DTS task that is paused.

• Cause: To prevent data inconsistency, DTS does not allow you to modify the objects to be synchronized in a paused DTS task.

• Solution: Start the task, wait until the state of the task changes to Running, and then try again.

  Note

  If the latency of the task exceeds 10 minutes, do not modify the objects to be synchronized.

DTS.Msg.LXPayOrder.AmountLimitExceeded

Payment cannot be made after you configure a DTS task.

• Cause: The order amount for an account that has the Proof of Concept (POC) tag can only be 0. Payment cannot be made for an order whose amount is greater than 0.

• Solution:

  • Use a voucher to pay for your order so that the payment amount changes to 0.

  • Use another account to purchase the DTS task.

  Note

  You must cancel orders that failed to be paid in the Expenses and Costs console instead of trying to pay for them again.

DTS.Msg.LXPayOrder.AccountBookNotExists

Payment cannot be made after you configure a DTS task.

• Cause: You did not top up your Alibaba Cloud account or your account balance is insufficient.

• Solution: Top up your account, make sure that your account balance is sufficient, and try again.

  Note

  You must cancel orders that failed to be paid in the Expenses and Costs console instead of trying to pay for them again.

DTS.Msg.ConfigJob.NoneSelectedStep

You call an API operation to configure a DTS task.

• Cause: The task steps are not configured. The StructureInitialization, DataInitialization, and DataSynchronization parameters are all set to false.

• Solution: Set these parameters to valid values to configure the task steps.

DTS.Msg.ConfigJob.InvalidDbListFormat

You call an API operation to configure a DTS task.

• Cause: The DbList parameter value is not a valid JSON string.

• Solution: Set this parameter to a valid JSON string.

DTS.Msg.ConfigJob.InvalidReserveFormat

You call an API operation to configure a DTS task.

• Cause: The Reserve parameter value is not a valid JSON string.

• Solution: Set this parameter to a valid JSON string.

DTS.Msg.DistributedDatabaseNodesError

You purchase a data synchronization instance and specify a distributed database as the source database.

• Cause: The specified number of nodes of the source distributed database is different from the actual number.

• Solution: When you purchase a DTS instance, specify the actual number of nodes of the source distributed database.

DTS.Msg.LXQueryOrder.NotFoundNormalOrder

You attempt to upgrade or downgrade a DTS instance or change the billing method of a DTS instance.

• Cause:

  • The instance is in the Completed state but is not released.

  • The instance has been released but is still displayed in the console.

• Solution:

  • Release the instance that is in the Completed state.

  • If the instance has been released but is still displayed in the console, contact technical support.

DTS.Msg.GetSSLInfo.NoSSLConn

You select SSL-encrypted for the Encryption parameter when you configure a DTS task.

• Cause: SSL encryption is disabled for the database instance that you configure.

• Solution: Enable SSL encryption for the instance or set the Encryption parameter to Non-encrypted.

DTS.Msg.ModifyDynamicConfig.InvalidStatus

You attempt to modify the configurations of a purchased data synchronization or migration instance.

• Cause: The task is not in the Running state.

• Solution: Make sure that the task is in the Running state and try again.

DTS.Msg.TransferInstanceClass.NoPermission

You attempt to downgrade a DTS instance.

• Cause: The Resource Access Management (RAM) user that you use does not have the permissions to downgrade a DTS instance.

• Solution: Contact technical support to grant the permission to downgrade a DTS instance to the RAM user and the Alibaba Cloud account to which the RAM user belongs.

DTS.Msg.OperationDenied.ConsumerGroupOutOfUsage

You attempt to create a consumer group for a change tracking instance.

• Cause: The change tracking instance already has more than 20 consumer groups.

• Solution: Delete the consumer groups that you no longer require and try again.

DTS.Msg.GrantAccessAlreadyExists

You configure a DTS task.

• Cause: An occasional error occurs.

• Solution: Try again. If the error persists, contact technical support.

DTS.Msg.DbListIsEmpty

You call an API operation to configure a DTS task.

• Cause: The DbList parameter is set to null or the specified value of the parameter is equivalent to null.

• Solution: Set the parameter to a valid value. For more information, see Objects of DTS tasks.

DTS.Msg.GetRedisNodes.NotCluster

You configure a DTS task whose source or destination database is a Redis instance.

• Cause: The Instance Mode parameter is not configured based on the architecture of the Redis instance.

• Solution: Configure the Instance Mode parameter based on the architecture of the Redis instance.

DTS.Msg.InvalidDestinationEndPointRegion

You call an API operation to configure a DTS task.

• Cause: The specified region of the destination instance is invalid or not supported.

• Solution: Specify a valid Region ID. For more information, see Supported regions.

DTS.Msg.InvalidSourceEndPointRegion

You call an API operation to configure a DTS task.

• Cause: The specified region of the source instance is invalid or not supported.

• Solution: Specify a valid Region ID. For more information, see Supported regions.

DTS.Msg.AdminAccountExists

You configure a DTS task.

• Cause: DTS creates a privileged account for some types of source databases. If an account with the same name already exists in the source database, an error is returned.

• Solution: Contact technical support.

DTS.Msg.NotSupportModify

You call the ModifyDtsJob operation to modify the configurations of a DTS task.

• Cause: The DtsInstanceId parameter is set to the ID of a data migration instance.

• Solution: You can modify only the extract, transform, and load (ETL) configurations of a data migration task in the DTS console. If you want to modify other configurations, you can create another task.

DTS.Msg.PrePayNotAllowDelete

You call an API operation to release a DTS task.

• Cause: You cannot release a subscription DTS task.

• Solution: Do not release a subscription DTS task.

DTS.Msg.Forbidden.AliyunUIDNotFound

You configure a DTS task in the DTS console. This error often occurs if the task replicates data across Alibaba Cloud accounts or you log on to the DTS console as a RAM user.

• Cause: The information about the Alibaba Cloud account used to log on to the DTS console is not initialized.

  • For a DTS task in which data is replicated across Alibaba Cloud accounts, the Alibaba Cloud account to which the source database belongs has never been used to log on to the DTS console.

  • If you log on to the DTS console as a RAM user, the Alibaba Cloud account to which the RAM user belongs has never been used to log on to the DTS console.

• Solution: View the UID in the error message, log on to the DTS console by using the corresponding Alibaba Cloud account, and then try again.

DTS.Msg.RamPermissionDenied

You log on to the DTS console as a RAM user to perform operations.

• Cause: The RAM user does not have the required permissions.

• Solution: Grant the required permissions to the RAM user and try again. For more information, see Use a system policy to authorize a RAM user to manage DTS instances or Custom policies for DTS.

  Note

  When you create a custom policy, you must use the values of the Action and ResourceId parameters displayed in the error message.

  

DTS.Msg.EcsJoinSecurityGroupLimitExceeded

You configure a DTS task in which the Access Method parameter is set to Self-managed Database on ECS for a database instance.

• Cause: The ECS instance has been added to five security groups.

• Solution: Remove the ECS instance from unnecessary security groups based on your business requirements and try again. For more information, see Remove an instance from a security group.

  Note

  If the ECS instance cannot be removed from some security groups due to business requirements, adjust the security groups of the ECS instance to make sure that the number of security groups does not exceed five.

DTS.Msg.UpgradeTrialTimesLimit

You experience a new feature provided by DTS to increase the maximum number of requests per second (RPS) for a DTS instance.

• Cause: The trial quota for increasing the RPS upper limit has been used up. DTS provides each Alibaba Cloud account with three free trials. Each free trial remains valid for 24 hours.

• Solution: None.

DTS.Msg.HasRunningTrial

You experience a new feature provided by DTS to increase the maximum number of RPS for a DTS instance.

• Cause: The feature has been enabled for the DTS instance. You cannot start a new free trial before the previous free trial ends.

• Solution: None.

DTS.Msg.DtsInstanceHasNoLimit

You experience a new feature provided by DTS to increase the maximum number of RPS for a DTS instance.

• Cause: The DTS instance does not have an RPS upper limit. You cannot enable the feature for the DTS instance.

• Solution: None.

DTS.Msg.UpgradeTrialInvalidJobStatus

You experience a new feature provided by DTS to increase the maximum number of RPS for a DTS instance.

• Cause: The feature is not supported for the DTS instance in the current state. This feature is supported only when the instance is in the Running, Paused, or Failed state.

• Solution: None.

DTS.Msg.InvalidMigrationJobId

You call an API operation to configure a DTS task.

• Cause: The specified task ID is invalid or the task has been deleted.

• Solution: Specify a valid task ID and try again.

DTS.Msg.InvalidIpAddress

You configure a DTS task in which the Access Method parameter is set to Public IP Address, Express Connect, VPN Gateway, or Smart Access Gateway, or Cloud Enterprise Network (CEN) for a database instance.

• Cause: The specified IP address is in an invalid format and cannot be resolved.

• Solution: Specify a valid IP address and try again.

DTS.Msg.PauseDenied.JobStatusNotRunning

You pause a DTS task.

• Cause: The task that you want to pause is not in the Running state. The task may be in the Failed, Paused, or Initializing state.

• Solution: Wait until the state of the task changes to Running and try again.

DTS.Msg.CheckpointOutOfAdjustableRange

You modify the consumption checkpoint of the Incremental Write phase for a DTS instance.

• Cause: The specified consumption checkpoint falls out of the adjustable range.

• Solution: Specify a consumption checkpoint within the adjustable range.

DTS.Msg.MaxRetryTime.Invalid

You change the value of the Retry Time for Failed Connections parameter.

• Cause: The specified value is not within the valid value range. Valid values: 10 to 1440. Unit: minutes.

• Solution: Specify a valid value for Retry Time for Failed Connections. We recommend that you set this parameter to a value greater than 30.