AIA deployment Exception: ORA-01882: timezone region not found

Scenario:

AIA Foundation Pack installation on top of SOA 11.1.1.5.0 in a Windows server is failing during its deployment phase.

Error:

JBO-29000: Unexpected exception caught: java.sql.SQLDataException, msg=ORA-01882: timezone region not found

     [wlst]   File "D:\Middleware_App\FMW\AIA_App\Infrastructure\Install\AID\lib\py\deployApplication.py", line 49, in ?
     [wlst]   File "<iostream>", line 376, in activate
     [wlst]   File "<iostream>", line 1848, in raiseWLSTException
     [wlst] WLSTException: Error occured while performing activate : Error while Activating changes. : [HTTP:101216]Servlet: "HttpSoapService" failed to preload on startup in Web application: "AIAValidationSystemServlet".
     [wlst] oracle.jbo.JboException: JBO-29000: Unexpected exception caught: java.sql.SQLDataException, msg=ORA-01882: timezone region not found
     [wlst] at oracle.jbo.server.OracleSQLBuilderImpl.setSessionTimeZone(OracleSQLBuilderImpl.java:5541)


Reason: 

The timezone set or picked from AIA host is not valid in the AIA database or is or is not set to blank in the soa managed server.


Troubleshooting:

1. Verified that no Timezone is explicitly set for the SOA managed server

To verify => Navigate to WebLogic console -> Environment, Servers, soa_server1.

Check the Server Start tab, Arguments field.

In my case it was blank

2. Check the AIA database for current settings

Executed following SQL commands from AIA server to the AIA database

SQL> select dbtimezone from dual;

DBTIME
------
+00:00

SQL> select sessiontimezone from dual;

SESSIONTIMEZONE
--------------------------------------------------------
-05:00

3. Check the Timezone set for the server.

It was set to "central Time (US and Canada)"


Solution:

From the database I queried for possible Timezone names with names including Central (Since in O/S level it is set to Central Time, i filtered)

select * from v$timezone_names where tzname like '%entral%';

From the list, I decided to use "Canada/Central" as the data center hosting the server was in Canada


Then in the SOA_SERVER1 Arguments field (WebLogic console -> Environment, Servers, soa_server1 -> Server Start), I included the following line and saved.

-Duser.timezone=Canada/Central

To double confirm I restarted the SOA_SERVER1 managed server.

Re-initiated the AIA installation after cleaning up the previous failed installation. This time it was successful.