ERROR 5211: Unknown or unsupported object:
All,
I'm new to vertica.
I'm on vertica-7.1.1-7 on linux red hat.
Trying to backup a schema called JASPER_DEV
Here's my ini file with the objects parameter.
I've tried using the actual schema name "JASPER_DEV", "yes", and "no". All produce the error in the title. What am i doing wrong?
snapshotName = demo_export
restorePointLimit = 1
objects = yes
passwordFile = demo_export.pwd
tempDir = /tmp/vbr
retryCount = 2
retryDelay = 1
0
Comments
Could you please paste the exact error that you see on the terminal when you start running backup
-Regards,
Sruthi
i tried 3 different things in the objects =
1. objects = JASPER_DEV
[vertica@den2-d-vrt01a tmp]$ vbr.py --task backup --config-file demo_export.ini
Preparing...
Found Database port: 5433
ERROR 5211: Unknown or unsupported object: JASPER_DEMO
When communicating with vertica, the process failed with code 1
backup failed!
2. objects = SCHEMA
[vertica@den2-d-vrt01a tmp]$ vbr.py --task backup --config-file demo_export.ini
Preparing...
Found Database port: 5433
ERROR 5211: Unknown or unsupported object: SCHEMA
When communicating with vertica, the process failed with code 1
backup failed!
3. objects = yes
[vertica@den2-d-vrt01a tmp]$ vbr.py --task backup --config-file demo_export.ini
Preparing...
Found Database port: 5433
ERROR 5211: Unknown or unsupported object: yes
When communicating with vertica, the process failed with code 1
backup failed!
Hi,
1)Did you intend to have an object called objects =yes in demo_export.ini?
Check the schema names in the db, run: select * from v_catalog.schemata;
2) Remove 'objects =yes' from demo_export.ini
OR
Change 'objects =yes' in demo_export.ini to point to an object / schema that exists.
-Regards,
Sruthi
Hi,
If you intend to specify objects, you should specify it in the format schemaname.objectname. For example, finance.customers where finance is schema and customers is object name in that schema. If you intend to backup schema, just specify the schema name. if you intend to backup more than one object, then Separate each name with a comma (,)
-Regards,
Sruthi
Embarrased to say that I had the schema name incorrect.
So, to backup a schema, list the name of the schema in objects parameter:
objects = INVOICE
Good to know that my resolution steps worked!!
-Regards,
Sruthi