Autosys to VSQL execution: issue unsupported locale character encoding


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


  • SruthiASruthiA Vertica Employee Employee



       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.




  • 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.





  • 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.
    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 :-)




    Rahul Choudhary

Leave a Comment

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