Please take this survey to help us learn more about how you use third party tools. Your input is greatly appreciated!

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

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

Tagged:

Answers

  • Bryan_HBryan_H Administrator

    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

  • edited April 7

    @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?

Leave a Comment

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

Can't find what you're looking for? Search the Vertica Documentation, Knowledge Base, or Blog for more information.