Help Center/ Data Replication Service/ Troubleshooting/ Solutions to Failed Check Items/ Database Parameters/ Checking Whether the Databases and Tables Exist
Updated on 2023-06-28 GMT+08:00
View PDF
Share

Checking Whether the Databases and Tables Exist

All Scenarios

Table 1 Checking whether the databases and tables exist

Check Item

Whether the databases and tables exist

Description

There are databases and tables in the uploaded file that do not exist in the source database. The synchronization fails.

Failure Cause and Handling Suggestion

Failure cause: Objects imported from files do not exist in the source database.

Handling suggestion: Remove these objects that do not exist and import the file again.

Synchronization from PostgreSQL to GaussDB(DWS) and from PostgreSQL to GaussDB

Table 2 Checking whether the databases and tables exist

Check Item

Whether the databases and tables exist

Description

The selected tables contain identifier columns, but the destination database does not support identifier columns. As a result, data synchronization fails.

Failure Cause and Handling Suggestion

Failure cause: The selected tables contain identifier columns.

Handling suggestion: Deselect tables containing identifier columns.
Parent topic: Database Parameters