Data Management: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?

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?

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?