ERROR 5211: Unknown or unsupported object:

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