Where to see query execution error detail


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.


  • Options
    Jim_KnicelyJim_Knicely - Select Field - Administrator
    edited June 2018


    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:


    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

  • Options

    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


Leave a Comment

BoldItalicStrikethroughOrdered listUnordered list
Align leftAlign centerAlign rightToggle HTML viewToggle full pageToggle lights
Drop image/file