Error 'Syntax error at or near "null"' when trying to update a scheduler

edited August 2017 in General Discussion

Hello All,

I've been at this for 2 days now and I can't seem to get it to work.
I have a scheduler that is currently set up and working as intended to pull data from a Kafka cluster. I want to change operator to a different user with non-superadmin privileges. This is my command:

vkconfig scheduler --update --add-operator new_user --config-schema vertica_push_sched --username dbadmin --password mypassword

However, it is returning

Caused by: com.vertica.support.exceptions.SyntaxErrorException: [Vertica]VJDBC ERROR: Syntax error at or near "null"

Can someone please shed some light as to what I'm doing wrong?

Thank you.


  • Options
    Jim_KnicelyJim_Knicely - Select Field - Administrator


    What version of Vertica are you using? I think this might be a bug. I opened a JIRA ticket and will keep you posted.

  • Options
    Jim_KnicelyJim_Knicely - Select Field - Administrator

    Fyi ... This issue has been fixed in Vertica 9.0:

    9.0.0-0 (10/16/2017) - VER-51561 - Kafka Integration - Adding an operator to a Kafka scheduler produced a null pointer exception.

Leave a Comment

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