Skip to main content
Question

How to trigger the error messages in ODBCMessages.xml and VerticaMessages.xml

  • April 6, 2022
  • 2 replies
  • 11 views

CharlieCai

Hi Team,
Could you please help to give example which can easily trigger the error message in ODBCMessages.xml or VerticaMessages.xml?
I'd like to test and confirm if relative path works for ErrorMessagesPath in vertica.ini
Thanks & Regards,
Jinlei

2 replies

Bryan_H
Forum|alt.badge.img+2
  • Participating Frequently
  • April 6, 2022

On Linux, you can test with "isql" client in verbose mode:
$ isql -v vertica
SQL> select count(distinct x), listagg(y) from myTable;
[42703]ERROR 2624: Column "x" does not exist


CharlieCai
  • Author
  • New Participant
  • April 7, 2022

@Bryan_H said:
On Linux, you can test with "isql" client in verbose mode:
$ isql -v vertica
SQL> select count(distinct x), listagg(y) from myTable;
[42703]ERROR 2624: Column "x" does not exist

Thanks for your reply.
Yes, I will get the same error, but this error template could not be found in ODBCMessages.xml or VerticaMessages.xml.
Instead, I can find one similar error in ODBCMessages.xml
<!-- Error thrown when a specified column name is invalid or not found. -->
<Error Key="InvalidColumnName" Params="1" NativeErrorCode="20021">Invalid column name: %1%</Error>

Could you please help to provide more information on how to make error messages in these two xml files take effort?