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 are configuring a Kafka data synchronization or migration task where the destination instance 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 associated instance is in the Reselect Objects state.

• Solution: Wait until the object modification completes and the instance state changes to Running. Then, 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 navigation bar, select Instances, and click the Instance Name of the instance you created.

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

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

  5. Click OK. The left side of the dialog box displays the Database List and the right side displays the Authorized Databases list. Use the Authorize and Remove buttons to move databases between the two lists. Select a permission type (Read/Write, Read-only, DDL Only, or DML Only) for each authorized database. After completing the configuration, 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 is a PolarDB-X instance for which the Task Type is Read-only Instance. This instance type is not supported.

• Solution: Change the source database to a PolarDB-X instance for which the Task Type is Primary Instance.

DTS.Msg.DbTypeNotSupport.PolarDBRDS

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

• Cause: The source database is a PolarDB-X instance for which the Storage Type is PolarDB. This storage type is not supported.

• Solution: Change the source database to a PolarDB-X instance for which the Storage Type is RDS 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 is running and configured correctly.

  • 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 are configuring a task where the source or destination is a sharded MongoDB instance.

• Cause: You cannot obtain the information about shards.

• Solution: Check the configuration parameters to confirm that the database is a sharded MongoDB instance.

DTS.Msg.GetMongoDbShardInfo.NoShardAddress

You are configuring a task where the source or destination is a sharded MongoDB instance.

• Cause: You cannot obtain the information about shards.

• Solution: Check the configuration parameters to confirm that the database is a sharded MongoDB instance and that you have enabled shard endpoints by following the instructions in Apply for an endpoint for a shard node.

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 cannot retry payment for a failed order. You must cancel the order in the Expenses and Costs console.

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 cannot retry payment for a failed order. You must cancel the order in the Expenses and Costs console.

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 when configuring a task.

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

• Solution: Enable SSL for the database instance or select Non-encrypted.

DTS.Msg.ModifyDynamicConfig.InvalidStatus

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

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

• Solution: Make sure that the task is in the Running state before you proceed with the operation.

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 selected Instance Mode does not match the actual instance architecture.

• Solution: Select an Instance Mode that matches the 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: Pass the correct region information by referring to the Region ID column in 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: Pass the correct region information by referring to the Region ID column in 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 specified DtsInstanceId parameter is the ID of a 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: To release the instance, see Release a DTS instance.

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 Action (API operation name) and ResourceId (DTS instance ID) from the error message.

DTS.Msg.EcsJoinSecurityGroupLimitExceeded

You are configuring a task where the data source is a Self-managed Database on ECS.

• 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 DTS instance is in a state that does not support the RPS limit upgrade feature. This feature is supported only when the instance is Running, Paused, or has failed.

• 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 are configuring a DTS task for a database instance for which the Access Method is set to Public IP Address, Express Connect, VPN Gateway, or Smart Access Gateway, or Cloud Enterprise Network (CEN).

• 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 you want to pause is not in the Running state. For example, it may have failed, be paused, or be initializing.

• Solution: Fix the task or wait for it to enter the Running state, then pause it.

DTS.Msg.CheckpointOutOfAdjustableRange

You modify the checkpoint of the Incremental Write phase for an 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 modify the Retry Time for Failed Connections.

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

• Solution: Set the Retry Time for Failed Connections to a value within the valid range. A setting of 30 minutes or more is recommended.