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

cuthbeorht

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.

Jim_Knicely

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_Knicely

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.