|Pivotal Greenplum (GPDB)||Below 18.104.22.168|
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 22.214.171.124, where only one schema gets created and the remaining relations under different schema errors out.
Refer to the release notes of Pivotal Greenplum version 126.96.36.199 for more details on the bug.
Upgrade the database to 188.8.131.52 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.