Skip to main content

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

  • Aug 30, 2017 1:45 PM UTC
  • 2 replies
  • 17 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
  • Sep 6, 2017 8:48 PM UTC

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
  • Oct 20, 2017 1:28 PM UTC

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.