Issue with character sets in planned jobs config
search cancel

Issue with character sets in planned jobs config

book

Article ID: 206492

calendar_today

Updated On:

Products

CA Workload Automation AE - Scheduler (AutoSys)

Issue/Introduction

We have a new configured autosys ae server (waae server) running on RHEL 7.4 and details of jobs are displayed in a special characters. As an example this is below a detail of one of our planned jobs.

notification_msg: "Bonjour, Le travail XPB3208VD est en erreur, voir le log sur \\\\SHR01\\D\\PR1\\dat\\02_fonc\\liv01\\log . Ce travail sera suspendu apr???s 5 jours en erreur. Merci de v???rifier cela et bonne journ???e"

We are located in Quebec city (Quebec), which is a French territory of Canada, so any letter for instance 'é' or 'ê' ou 'è' get displayed in '???' which is not normal for us. So we are looking for the right character set to solve this issue.

Environment

Release : 11.3.6

Component : CA Workload Automation AE (AutoSys)

Resolution

Add "NLS_LANG=CANADIAN FRENCH_CANADA.WE8MSWIN1252" to autosys.sh.`hostname`
When AutoSys Application Server starts up it loads the Oracle OCI libraries and while Oracle OCI client starts up it uses NLS_LANG to override any default settings. The user who starts Application Server(task name as_server) must need this NLS_LANG environment variable set for Oracle client to translate OS input to DB storage string.