Autosys to VSQL execution: issue unsupported locale character encoding

Hi,

I have the vsql command in shell script file. While running the shell script, vsql command has exexuted successfully. Then I run the same shell script from autosys job. It is giving the below error

 

vsql: unsupported locale character encoding
use a utf8 locale, not a ISO-8859-1 locale

 

Please provide the solution

Comments

  • SruthiASruthiA Vertica Employee Administrator

    Hi,

     

       From the error it seems to be there is a problem with locale settings. Please find the locale configuration file in your Autosys configuration files and set the locale to utf8 and then, try executing the autosys job.

     

    -Regards,

     Sruthi

  • Hi Sruthi,

     

    Autosys configuration files owned by autosys admin. It can't be edited. But autosys configuration file using local profiles. The local profiles and linux environment have the LANG=en_US.UTF-8 only. It seems like all set with utf8 only. But still the issue is there. Can you provide more solution to open the mystery.

     

    Thanks,

    Ram

     

  • Hi

     

    Just to let you know that in addition to the LANG variable being set, AutoSys jobs additionaly require LC_ALL to be set.
     
    I would suggest you to add the following to /etc/auto.profile(where en_US.UTF8 is your LANG):
     
    export LC_ALL="en_US.UTF-8"
     
    I beleive that this will resolve this issue.
     
    Let us know if you still faces any issues after performing this change.
     
    Regards
    Rahul Choudhary
  • Resolved by adding the below in script file. Thanks to all.
    export LC_ALL="en_US.UTF-8"
     
  • Hi 

     

    Glad to know that issue is resolved :-)

     

     

    Cheers

    Rahul Choudhary

Leave a Comment

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