Genesys CTI User Forum
Genesys CTI User Forum => Genesys CTI Technical Discussion => Topic started by: cavagnaro on February 05, 2014, 12:33:03 PM
-
Hi guys,
Facing a kinda not easy customer. He configures his Oracle DB with Brazilian regional settings, which makes sense. But when I install ODS (Windows server in English or Brasilian regional settings, tried both) complains that can't write on the DB because of a invalid number. By my experience that means that there is a conflict with the regional settings. So my question is, does ODS/ETL/OCS, etc, support only English regional or is there a way to make them work in other languages?
PS: Basically would be that in English a decimal is 1.0 but in other sides of the world is 1,0
Thanks!
-
I think that it depends on regional configuration of your Oracle client on Windows server. It is configurable on registry level.
-
Yes, already tried in Brazilian and in English, and in both fails. So wonder who has an Oracle with regional settings for the Genesys instance different than English
-
I have configured it few weeks ago - I think that I have changed NLS_LANG parameter - and all worked fine.
In general was always the root cause in different character for separators (comma, dot, semicolon, etc.). So, in some scenarion was the issue solved by reconfiguration of these parameters instead NLS_LANG.
Doing restart of course :-)
I know and remember that each deployment with differents regional settings within platform was not easy.
May be one question - your Windows OS is 2008 or 2003? I remember that on 2008 I had to set overwriting on all existing users by new regional setting. Without it , it does not work
-
It is a 2008. What do you mean by overwritting??
This is the output for my user on Genesys:
[quote]
PARAMETER VALUE
------------------------------ ----------------------------------------
NLS_LANGUAGE AMERICAN
NLS_TERRITORY AMERICA
NLS_CURRENCY $
NLS_ISO_CURRENCY AMERICA
NLS_NUMERIC_CHARACTERS .,
NLS_CALENDAR GREGORIAN
NLS_DATE_FORMAT DD-MON-RR
NLS_DATE_LANGUAGE AMERICAN
NLS_SORT BINARY
NLS_TIME_FORMAT HH.MI.SSXFF AM
NLS_TIMESTAMP_FORMAT DD-MON-RR HH.MI.SSXFF AM
NLS_TIME_TZ_FORMAT HH.MI.SSXFF AM TZR
NLS_TIMESTAMP_TZ_FORMAT DD-MON-RR HH.MI.SSXFF AM TZR
NLS_DUAL_CURRENCY $
NLS_COMP BINARY
NLS_LENGTH_SEMANTICS BYTE
NLS_NCHAR_CONV_EXCP FALSE
[/quote]
-
I mean that the regional settings could be still in "default" for existing users although you have changed region for the server, it is just a personal experience. Last similiar issue what I have registered take me almost 3 days of solving.
-
How could I check that?
-
If you open a settings for "region and language", within the windows is a tab "Administrative" where you can find magic button "copy settings" - through this you can copy current settings to system users (under these accounts windows services are running) and new users on that server. So, try this and let us know