Where to see query execution error detail

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

  • 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
Emoji
Image
Align leftAlign centerAlign rightToggle HTML viewToggle full pageToggle lights
Drop image/file