Check Details
1. Check whether the user has permission to operate the database. In migration/synchronization/subscription processes, each database type has detailed permission requirements. See corresponding guidance.
2. For the target end being MySQL versions 8.0.26 and later, DTS will check the innodb_strict_mode parameter. It is recommended that innodb_strict_mode be set to OFF during migration/synchronization tasks. If it is not set to OFF, DTS will give a prompt during the pre-verification. For MySQL versions earlier than 8.0.26 or other database types, DTS will modify this parameter at the session level to OFF.
Parameter Description: innodb_strict_mode controls whether the InnoDB storage engine enables strict mode for improper data.
innodb_strict_mode=ON: The InnoDB storage engine will perform strict data validation. If there are syntax errors during operations like CREATE TABLE, ALTER TABLE, and CREATE INDEX, it will throw an error directly.
innodb_strict_mode=OFF: The InnoDB storage engine relaxes data validation. The above syntax errors will not trigger an error, and default syntax will be used instead.
Setting recommendation: If the source database contains improper data, it is recommended that the innodb_strict_mode parameter be set to OFF during migration/synchronization tasks. This will allow data to be synchronized normally to the target.
Fixing Solution
If the user does not have the required permissions, grant the corresponding permissions as specified in the check requirements, then re-run the verification task.