Updated on 2022-09-21 GMT+08:00

Full Synchronization Error: Table %s.%s not found in database

Scenarios

During full synchronization, an error is reported, and the log information is as follows: service DATAMOVE failed, cause by: apply event=[type=table_data, batch_index_in_shard=1, table_schema= %s, table_name= %s, record_num= %s] occur error, msg=Table %s. %s not found in database. Unable to generate a valid statement.

Possible Causes

The possible causes are as follows:

  • The destination database table is not created. As a result, the synchronization statement reports an error.

Solution

Contact destination database O&M engineers to create the corresponding table in the destination database.