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


Where to see query execution error detail — Vertica Forum

Where to see query execution error detail

AnandAnand
in General Discussion

Hello,

I was trying to create tables from MC - Query Execution (Vertica 9.x). I imported a DDL sql to create multiple tables in one shot and clicked execute. It shows executing error. If I execute them one by one, it is getting executed without any error. Can I know where to find the log of this error ? Thanks.

Comments

  • Jim_KnicelyJim_Knicely - Select Field - Administrator
    edited June 2018

    Hi,

    Which version of Vertica MC are you running? I did a quick test on Vertica MC 9.1.0-1 of running multiple DDL statements and did not have a problem.

    You can check the MC log for errors:

    See:
    https://my.vertica.com/docs/9.1.x/HTML/index.htm#Authoring/ManagementConsole/TroubleshootingMC/ViewingTheMCLog.htm

    I'm not sure if "Execution Errors" from MC show up in the DC_ERRORS Data Collector table, but maybe take a peek there too.

    If you want, you can email your code and I can test it locally to see if I figure out the issue :)

    My email: james.knicely@microfocus.com

  • AnandAnand

    Hi Jim,

    It's vertica_community_edition-9.0.1_vmx.zip

    Later I used vsql to run the sql commands successfully like this -

    vsql -U dbadmin -w password -f ddl_file.sql

    Thanks.

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