Where to see query execution error detail

Anand

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.

Jim_Knicely

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

Anand

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.