Author Topic: DataBase Server regional language configuration  (Read 2498 times)

Offline cavagnaro

  • Administrator
  • Hero Member
  • *****
  • Posts: 7526
  • Karma: 56330
DataBase Server regional language configuration
« on: February 05, 2014, 09: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!

Offline Kubig

  • Hero Member
  • *****
  • Posts: 2708
  • Karma: 41
Re: DataBase Server regional language configuration
« Reply #1 on: February 05, 2014, 10:13:21 PM »
I think that it depends on regional configuration of your Oracle client on Windows server. It is configurable on registry level.
Genesys certified professional consultant (GVP, SIP, GIR and Troubleshooting)

Offline cavagnaro

  • Administrator
  • Hero Member
  • *****
  • Posts: 7526
  • Karma: 56330
Re: DataBase Server regional language configuration
« Reply #2 on: February 05, 2014, 10:15:24 PM »
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

Offline Kubig

  • Hero Member
  • *****
  • Posts: 2708
  • Karma: 41
Re: DataBase Server regional language configuration
« Reply #3 on: February 05, 2014, 10:23:44 PM »
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
« Last Edit: February 05, 2014, 10:26:56 PM by Kubig »
Genesys certified professional consultant (GVP, SIP, GIR and Troubleshooting)

Offline cavagnaro

  • Administrator
  • Hero Member
  • *****
  • Posts: 7526
  • Karma: 56330
Re: DataBase Server regional language configuration
« Reply #4 on: February 05, 2014, 10:51:40 PM »
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     

Offline Kubig

  • Hero Member
  • *****
  • Posts: 2708
  • Karma: 41
Re: DataBase Server regional language configuration
« Reply #5 on: February 05, 2014, 11:56:26 PM »
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.
Genesys certified professional consultant (GVP, SIP, GIR and Troubleshooting)

Offline cavagnaro

  • Administrator
  • Hero Member
  • *****
  • Posts: 7526
  • Karma: 56330
Re: DataBase Server regional language configuration
« Reply #6 on: February 06, 2014, 02:04:33 AM »
How could I check that?

Offline Kubig

  • Hero Member
  • *****
  • Posts: 2708
  • Karma: 41
Re: DataBase Server regional language configuration
« Reply #7 on: February 06, 2014, 05:29:48 PM »
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
Genesys certified professional consultant (GVP, SIP, GIR and Troubleshooting)