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

 

Comments

  • SruthiASruthiA Vertica Employee Administrator

    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!

  • SruthiASruthiA Vertica Employee Administrator

    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 =yesin demo_export.ini   to point to an object / schema  that exists.

     

    -Regards,

     Sruthi

     

  • SruthiASruthiA Vertica Employee Administrator

    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

     

     

  • SruthiASruthiA Vertica Employee Administrator

    Good to know that my resolution steps worked!!

     

    -Regards,

     Sruthi

Leave a Comment

BoldItalicStrikethroughOrdered listUnordered list
Emoji
Image
Align leftAlign centerAlign rightToggle HTML viewToggle full pageToggle lights
Drop image/file