Skip to main content

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

  • August 30, 2017
  • 2 replies
  • 11 views

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.

2 replies

Jim_Knicely
Forum|alt.badge.img+2
  • Participating Frequently
  • September 6, 2017

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
Forum|alt.badge.img+2
  • Participating Frequently
  • October 20, 2017

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.