We're Moving!

The Vertica Forum is moving to a new OpenText Analytics Database (Vertica) Community.

Join us there to post discussion topics, learn about

product releases, share tips, access the blog, and much more.

Create My New Community Account Now

Why query_request 'SET' is giving error in error_messages table. — Vertica Forum

Why query_request 'SET' is giving error in error_messages table.

hsaxena20

hsaxena20 Community Edition User

November 2019 in General Discussion

Why this error is coming many times?
set session autocommit to off 0 ERROR Syntax error at or near ")"
Anyone, please suggest.

0

Answers

mosheg

mosheg Vertica Employee Administrator

November 2019 edited November 2019

Given that the SET command syntax is accurate, try to track the command with the syntax error before.

    cat find_error.sql 
    \! rm -f suspected_queries.txt
    \o suspected_queries.txt
    select distinct(request) from dc_requests_issued
    where transaction_id in ( SELECT transaction_id  FROM error_messages WHERE message ilike '%Syntax error%' );

0

Leave a Comment