FAQ

Order

• How do I view and manage orders in DMS?

• Are my orders for DMS resources bound to database instances?

• Are the available features in DMS different when I use a subscription resource or use a pay-as-you-go resource?

• Why do I still receive the bill message after I have unsubscribed from a pay-as-you-go DMS resource?

• Am I still charged in DMS if an RDS instance managed in DMS has been released in the RDS console but has not been removed from DMS?

• How do I unsubscribe from or downgrade a subscription resource?

• Customers without group cloud migration product tags，why do the following error messages appear when purchasing pay-as-you-go products within the group？

Database logon

• How do I enter the valid database account and password?

• What do I do if I fail to log on to the database in DMS and the message indicating that the database access is denied appears?

• What do I do if the SSL certificate expires?

• What do I do if I am prompted a whitelist issue when I register an ApsaraDB instance in DMS?

• What do I do if I fail to log on to an ApsaraDB for Redis instance in DMS and the system prompts "SSL connection must be used" or "Unexpected end of stream" after I enable TLS or SSL encryption for the instance?

• What do I do if I fail to log on to a database in DMS and the message indicating that the access source is invalid appears?

• What do I do if the following error message occurs when I log on to an ApsaraDB RDS instance?

• What do I do if I fail to log on to an ApsaraDB RDS for MySQL instance and the system prompts that the instance does not exist?

• What do I do if the system prompts that I temporarily cannot access the instance by using DMS?

• What do I do if the "Communications link failure" message appears and the time consumed for connection is displayed when DMS connects to a MySQL database?

Connection

• Why can't I retrieve database information when opening the SQL Console?

• How do I fix a "Too many connections" error when connecting to a MySQL database?

• How do I resolve a whitelist error when registering a self-managed database on an ECS instance with DMS?

Account or permission

• How do I find the database administrator (DBA) for a database in DMS?

• How do I fix a DingTalk notification configuration failure in DMS?

• How do I request permissions for a database with no assigned data owner?

Data change

• How do I fix SQL execution timeouts in the SQL Console?

• How do I resolve a "Duplicate column name" error when changing data in DMS?

• How do I resolve a "Duplicate entry" error when changing data in DMS?

• How do I fix a "Row size too large" error?

• How do I fix index creation errors in a MySQL database?

• How do I fix a "Data too long" error when running DML statements?

• How do I fix an "Incorrect string value" error when executing SQL statements?

• How do I fix a "Data truncated for column" error when running DDL statements in DMS?

• How do I fix an "Incorrect prefix key" error when executing SQL statements in DMS?

• How do I fix a "max_binlog_cache_size" error when running large transactions?

• How do I fix an approval template that doesn't work as expected for data changes?

• How do I resolve a security rule error that blocks a statement when submitting a data change ticket?

• How do I fix a "Failed to check the number of affected rows. Syntax check failed." error when submitting a data change ticket?

• Hologres: Data change failures with BEGIN and END

Synchronize data dictionary (metadata)

Common questions about refreshing or synchronizing the data dictionary (metadata synchronization) in DMS, including troubleshooting for missing databases, sync timeouts, permission issues, and engine-specific topics for Redis and Oracle.

For more information, see Synchronize data dictionary FAQ.

Secure hosting

• What are the functional differences between security hosting and Security Collaboration?

• What changes are brought by enabling security hosting?

• How do I use password-free logon without permission management?

• Do I need to grant logon permissions to users after enabling security hosting?

• What permissions can I apply for an instance with security hosting enabled?

• Who are the permission request approvers?

• How do I view permission operation records?

• Can I configure expiration dates for permissions?

• How do I perform access control for sensitive data using column permissions?

• Can I use domain accounts for fine-grained permission management?