- Pivotal Greenplum (GPDB) Below 220.127.116.11
- OS RHEL 6.x
Transferring the full source database (which has multiple database schemas) to a destination database via gptransfer results in the below error in the gptransfer logs found under gpAdminLogs.
[ERROR]:-Failed to transfer table source.schema1.test
[WARNING]:-Some tables failed to transfer.
The cause of the issue has been identified as a bug (25569) in the database version below 18.104.22.168, where only one schema gets created and the remaining relations under different schema errors out.
Refer to the release notes of Pivotal Greenplum version 22.214.171.124 for more details on the bug.
Upgrade the database to 126.96.36.199 or later to overcome the issue.
Follow the steps:
1. Before executing the gptransfer command, create all the schema from the source to the target database using.
CREATE SCHEMA <SCHEMA_NAME>
2. Execute the gptransfer command again.