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