Configure NLS_NUMERIC_CHARACTERS ??

dataservices administration
1

Hi all,

I work with DS 12.2 and here his my question :
Got a simple job with an SQL, a query and target table. In my SQL I use a package which need an NLS_NUMERIC_CHARACTERS= ‘.,’ (when I launch the SQL directly into the database it’s Ok)

But when I run the job, DS send first this to Oracle :

ALTER SESSION SET NLS_LANGUAGE= ‘FRENCH’ NLS_TERRITORY= ‘FRANCE’ NLS_CURRENCY=
‘¤’ NLS_ISO_CURRENCY= ‘FRANCE’ NLS_NUMERIC_CHARACTERS= ', ’ NLS_CALENDAR=
‘GREGORIAN’ NLS_DATE_FORMAT= ‘DD/MM/RR’ NLS_DATE_LANGUAGE= ‘FRENCH’
NLS_SORT= ‘FRENCH’ TIME_ZONE= ‘+01:00’ NLS_COMP= ‘BINARY’ NLS_DUAL_CURRENCY=
‘¤’ NLS_TIME_FORMAT= ‘HH24:MI:SSXFF’ NLS_TIMESTAMP_FORMAT= ‘DD/MM/RR
HH24:MI:SSXFF’ NLS_TIME_TZ_FORMAT= ‘HH24:MI:SSXFF TZR’
NLS_TIMESTAMP_TZ_FORMAT= ‘DD/MM/RR HH24:MI:SSXFF TZR’

So the job run with a bad NLS_NUMERIC_CHARACTERS (', ’ instead of ‘.,’) :nonod:

So where can I configure that in DS?

Thank you !!

liegeus (BOB member since 2008-01-07)

2

That is set on the job server. It’s an Oracle configuration setting.

eganjp :us: (BOB member since 2007-09-12)

3

Yes it’s an oracle configuration setting and i’m sure it is set as ‘.,’ on my database… Why DS change it to ', ’ when a job is launch ?

I see nothing in the options of the datastore or on the job server configuration… (the server ix on linux but i don’t think it’s important here ?)

thanks.

liegeus (BOB member since 2008-01-07)

4

Check the setting on the Linux machine, for the user that owns the job server.

eganjp :us: (BOB member since 2007-09-12)

5

ok…

I tried to change the datastore language to Eng (English) put we still trap in Oracle an "ALTER SESSION SET NLS_LANGUAGE= ‘FRENCH’ NLS_TERRITORY= ‘FRANCE’ NLS_CURRENCY=
‘¤’ NLS_ISO_CURRENCY= ‘FRANCE’ NLS_NUMERIC_CHARACTERS= ', ’ NLS_CALENDAR=
‘GREGORIAN’ NLS_DATE_FORMAT= ‘DD/MM/RR’ NLS_DATE_LANGUAGE= ‘FRENCH’ "

I’ll try to change the file al_env.sh :

#!/bin/sh

LINK_DIR=/opt/dataservices/businessobjects/dataservices
export LINK_DIR

if [ ! -f $LINK_DIR/bin/al_engine ]; then
    echo "Could not file $LINK_DIR/bin/al_engine. Not a valid installation."
    exit 1
fi

JAVA_HOME=$LINK_DIR/../bobje/jdk
export JAVA_HOME

BOE_REGISTRYHOME=$LINK_DIR/registry
export BOE_REGISTRYHOME

PATH=$JAVA_HOME/bin:$LINK_DIR/bin:$PATH
export PATH

LD_LIBRARY_PATH=$LINK_DIR/bin:$LINK_DIR/ext/webservice-c/lib:$LD_LIBRARY_PATH
export LD_LIBRARY_PATH

NLS_NUMERIC_CHARACTERS=.,
NLS_LANG=FRENCH_FRANCE.WE8ISO8859P15
export NLS_LANG NLS_NUMERIC_CHARACTERS

. $LINK_DIR/bin/ebf_patch.sh
. $LINK_DIR/bin/db_env.sh

but here too the NLS_NUMERIC_CHARACTER is ok and = to ‘.,’ today i can’t stop/start the job server, jobs are running, i’ll test it tomorrow… first try to put an other language into the al_env.sh to see if the ALTER SESSION will be modify…

thanks for the answers…

liegeus (BOB member since 2008-01-07)