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

cuthbeorhtcuthbeorht
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.

Comments

  • Jim_KnicelyJim_Knicely - Select Field - Administrator

    Hi,

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

  • 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
Format
SpoilerCodeQuote
Heading 2Heading 1
Emoji
:):D:(;):/:o:s:p:'(:|B):#:*<3o:)>:)
Url
Image
Align leftAlign centerAlign rightToggle HTML viewToggle full pageToggle lights
Drop image/file
Home • General DiscussionComment As ...