Updated on 2024-07-11 GMT+08:00

Checking the Synchronization Objects

Check whether the source database objects meet the migration or synchronization requirements.

Failure Cause

  • The source database does not contain the objects to be synchronized.
  • The source database is temporarily unavailable.
  • For a task with Oracle serving as the source database, a schema name, table name, or column name of the selected table exceed 30 characters.
  • For a task with Microsoft SQL Server serving as the source database, the number of tables to be synchronized in a single task exceeds 1000.
  • An internal error occurred.

Handling Suggestion

  • Return to the object selection page, select the objects to be synchronized again, and then perform the pre-check.
  • In the pre-check phase, if the source database is disconnected and the pre-check fails, ensure that the source database is properly connected and perform the pre-check again.
  • Due to the restrictions of Oracle Logminer, a schema name, table name, or column name of the selected table in the source Oracle database in the incremental synchronization phase cannot exceed 30 characters. Change the schema name, table name, and column name that do not meet requirements to ensure that the length does not exceed 30 characters. Then, perform the precheck again.
  • For a task with Microsoft SQL Server serving as the source database, the number of tables to be synchronized in a single task cannot exceed 1000. Reduce the number of tables to be synchronized in a single task, deselect the tables that do not need to be synchronized, or split the task into multiple synchronization tasks for data synchronization, and perform the pre-check again.
  • Check whether the source or destination DB engine is of a special version. The special version may not support some syntax. As a result, the pre-check fails. Change the source or destination database and perform the pre-check again.