Pivotal Knowledge Base

Follow

GPTRANSFER fails with message: "[ERROR]:-Found unsupported identifiers"

Environment

Pivotal Greenplum: 4.3.x

OS: RHEL 6.x

Symptom

When attempting a database migration with gptransfer, it fails with the error message “Found unsupported identifiers.”

Error Message:

20170615:22:30:22:261818 gptransfer:mdw:gpadmin-[INFO]:-Starting gptransfer with args: -d analyticsdb --source-port=5432 --source-host 172.17.196.11 --source-user gpadmin --dest-database=analyticsdb2 --dest-user gpadmin --dest-host=172.17.196.30 --dest-port=5432 --source-map-file=/home/gpadmin/host_map_file 
20170615:22:30:22:261818 gptransfer:mdw:gpadmin-[INFO]:-Validating options...
20170615:22:30:22:261818 gptransfer:mdw:gpadmin-[INFO]:-Retrieving configuration of source Greenplum Database...
20170615:22:30:29:261818 gptransfer:mdw:gpadmin-[INFO]:-Retrieving configuration of destination Greenplum Database...
20170615:22:30:33:261818 gptransfer:mdw:gpadmin-[INFO]:-Retrieving source tables...
20170615:22:30:33:261818 gptransfer:mdw:gpadmin-[INFO]:-Checking for gptransfer schemas...
20170615:22:30:34:261818 gptransfer:mdw:gpadmin-[INFO]:-Retrieving list of destination tables...
20170615:22:30:34:261818 gptransfer:mdw:gpadmin-[INFO]:-Reading source host map file...
20170615:22:30:34:261818 gptransfer:mdw:gpadmin-[INFO]:-Building list of source tables to transfer...
20170615:22:30:34:261818 gptransfer:mdw:gpadmin-[INFO]:-Number of tables to transfer: 9032
20170615:22:30:34:261818 gptransfer:mdw:gpadmin-[INFO]:-gptransfer will use "standard" mode for transfer.
20170615:22:30:34:261818 gptransfer:mdw:gpadmin-[INFO]:-Validating source host map...
20170615:22:30:34:261818 gptransfer:mdw:gpadmin-[INFO]:-Validating transfer table set...
20170615:22:30:34:261818 gptransfer:mdw:gpadmin-[ERROR]:-Found unsupported identifiers
20170615:22:30:34:261818 gptransfer:mdw:gpadmin-[ERROR]:-Valid identifiers must start with a-z, or A-Z or underscore followed by a-z, or A-Z, or 0-9, or underscore
20170615:22:30:34:261818 gptransfer:mdw:gpadmin-[ERROR]:-A list of these tables has been written to the file failed_transfer_tables_20170615_223022.txt

Cause

It's by design that gptransfer can only accept object name which starts with a-z, or A-Z, or underscores, followed by lower or upper case (a-z, A-Z), or digits (0-9), or underscore (_). 

In this case character '$' is contained in the name of some tables, as shown below.

[PROD-gpadmin@mdw ~]$ head failed_transfer_tables_20170615_223022.txt 
analyticsdb.cube_test.t$ur_document_data
analyticsdb2.cube_test.t$ur_document_data
analyticsdb.cube_test.t$documents

Resolution

Since gptransfer doesn't recognize object name which includes character '$', those objects should be renamed first to meet the criteria as mentioned above before starting gptransfer. Then rename those objects back to original one after gptransfer completes if necessary.

 

 

 

Comments

Powered by Zendesk