Skip to main content

Autosys to VSQL execution: issue unsupported locale character encoding

  • May 11, 2015
  • 5 replies
  • 16 views

Ramailango

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

5 replies

SruthiA
Forum|alt.badge.img+1
  • Participating Frequently
  • May 11, 2015

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


Ramailango
  • Author
  • New Participant
  • May 12, 2015

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

 


Rahul_Choudhary
Forum|alt.badge.img
  • Participating Frequently
  • May 13, 2015

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

Ramailango
  • Author
  • New Participant
  • May 13, 2015
Resolved by adding the below in script file. Thanks to all.
export LC_ALL="en_US.UTF-8"
 

Rahul_Choudhary
Forum|alt.badge.img
  • Participating Frequently
  • May 13, 2015

Hi 

 

Glad to know that issue is resolved :-)

 

 

Cheers

Rahul Choudhary