Outsystems 9.1.300.0  Installing Fails with ORA-01882: timezone region not found

Outsystems 9.1.300.0  Installing Fails with ORA-01882: timezone region not found

  
Installing Outsystems 9.1.300.0 on RHEL 6.7 Box with Java 8..

The DB connection fails during configuration, Any thoughts?

 
Index Tablespace [OSIDX]:
Cannot get Connection from Datasource: java.sql.SQLException: ORA-00604: error occurred at recursive SQL level 1
ORA-01882: timezone region not found
 With errorcode : 45257

Debug steps :

https://access.redhat.com/solutions/44248

Alos tried syncing the clock but still same issue.
 
Hi Rakesh,

Thank you for your feedback!

In order for us to be able to help you in the better way possible, could you provide us with more information such as

  1. Database version you're using to install the Platform
  2. Output of running the following query against your database: "select dbtimezone from dual";

Thank you,

Neto
Hi Rakesh

I got word from my team that you have already submitted this problem to Technical Support and that they are working with you directly. I can say it's a bizarre error though!

Acácio

I'm getting the same issue when setting up and testing a Database Connection in Service Center that I want to integrate via Integration Studio.

What was the cause in this case?

Stuart Towers wrote:

I'm getting the same issue when setting up and testing a Database Connection in Service Center that I want to integrate via Integration Studio.

What was the cause in this case?

Hi Stuart

I did not find the original case, but Google shows me the following:
- http://stackoverflow.com/questions/9156379/ora-01882-timezone-region-not-found

The platform does not explicitly set the timezone in a new connection, so the value from the driver is inherited. At Java level, either it is specifically set in the run parameters, or is inherited from the operating system. I suspect your case is the latter.

The error is actually self-explanatory: the timezone region defined is not known to Oracle.

According to the post above, timezone is read from /etc/sysconfig/clock. In my case, it reads:

# cat /etc/sysconfig/clock
# The time zone of the system is defined by the contents of /etc/localtime.
# This file is only for evaluation by system-config-date, do not rely on its
# contents elsewhere.
ZONE="Europe/Lisbon"


Which is one that exists in Oracle:

select * from v$timezone_names
where (tzname) like 'Europe/Lisbon'

TZNAME             TZABBREV
------------------ ---------
Europe/Lisbon      LMT      
Europe/Lisbon      WET      
Europe/Lisbon      WEST    
Europe/Lisbon      WEMT    
Europe/Lisbon      CET      
Europe/Lisbon      CEST

I would suggest you consult with the sysadmin that gave you the machine; you probably need to change the timezone of the server. If you have other machines already installed, try using the same timezone as others use. Note that a full reboot should be needed to change the timezone.

Hope this helps!
Acácio