Timezone Region Not Found Error during AIA Foundation Pack install (Doc ID 1108724.1)

Last updated on MARCH 08, 2017

Applies to:

Oracle Application Integration Architecture Foundation Pack - Version 11gR1 and later
Information in this document applies to any platform.
***Checked for relevance on 05-Jan-2014***

Symptoms

Whilst performing the AIA install for 11gR1 (3.0) the installation will error with ORA-01882: timezone region not found.

This can be seen on the screen or via the logs.

Extract from install log file:

...
[echo] === Executing Deployments ===
[echo]
[echo]
[xslt] Processing /app/oracle/AIAFP30/config/FPInstallDP.xml to /app/oracle/AIAFP30/aia_instances/AIAFP30/tmp/AIDExecuteDP_temp_1412319589.xml
[xslt] Loading stylesheet /app/oracle/AIAFP30/aia_instances/AIAFP30/tmp/AIDExtractxsl_temp_1656963358.xsl

executeDP:
[exec] INFO: AIA_INSTANCE is found, configuration will load from instance folder.
[exec] Apr 30, 2010 9:19:41 AM oracle.adf.share.config.ADFConfigFactory getInstance
[exec] INFO: ADF Config instance implementation in use is : oracle.adf.share.config.MDSConfigFactory
[exec] Exception in thread "main" oracle.jbo.JboException: JBO-29000: Unexpected exception caught: java.sql.SQLDataException, msg=ORA-01882: timezone region not found
[exec]
[exec] at oracle.jbo.server.OracleSQLBuilderImpl.setSessionTimeZone(OracleSQLBuilderImpl.java:5049)
[exec] at oracle.jbo.server.DBTransactionImpl.refreshConnectionMetadata(DBTransactionImpl.java:4923)
[exec] at oracle.jbo.server.DBTransactionImpl.initTransaction(DBTransactionImpl.java:1123)
[exec] at oracle.jbo.server.DBTransactionImpl.initTxn(DBTransactionImpl.java:6275)
[exec] at oracle.jbo.server.DBTransactionImpl2.connect(DBTransactionImpl2.java:113)
[exec] Result: 1
[exec] at com.oracle.aia.AIAOERWriter.main(Unknown Source)
[exec] Caused by: java.sql.SQLDataException: ORA-01882: timezone region not found
...


Or in SOA server log file:

...
####<May 20, 2010 9:47:47 AM IST> <Error> <HTTP> <hydhtc70560d> <soa_server1> <[ACTIVE] ExecuteThread: '0' for queue: 'weblogic.kernel.Default (self-tuning)'> <> <> <> <1274329067056> <BEA-101216> <Servlet: "HttpSoapService" failed to preload on startup in Web application: "AIAValidationSystemServlet".
oracle.jbo.JboException: JBO-29000: Unexpected exception caught: java.sql.SQLDataException, msg=ORA-01882: timezone region not found

at oracle.jbo.server.OracleSQLBuilderImpl.setSessionTimeZone(OracleSQLBuilderImpl.java:5128)
at oracle.jbo.server.DBTransactionImpl.refreshConnectionMetadata(DBTransactionImpl.java:5016)
at oracle.jbo.server.DBTransactionImpl.initTransaction(DBTransactionImpl.java:1128)
at oracle.jbo.server.DBTransactionImpl.initTxn(DBTransactionImpl.java:6368)
at oracle.jbo.server.DBTransactionImpl2.connectToDataSource(DBTransactionImpl2.java:286)
at oracle.jbo.server.DBTransactionImpl2.connectToDataSource(DBTransactionImpl2.java:309)
at oracle.jbo.common.ampool.DefaultConnectionStrategy.connect(DefaultConnectionStrategy.java:203)
at oracle.jbo.server.ApplicationPoolMessageHandler.doPoolConnect(ApplicationPoolMessageHandler.java:553)
at oracle.jbo.server.ApplicationPoolMessageHandler.doPoolMessage(ApplicationPoolMessageHandler.java:409)
at oracle.jbo.server.ApplicationModuleImpl.doPoolMessage(ApplicationModuleImpl.java:8534)
at oracle.jbo.common.ampool.ApplicationPoolImpl.sendPoolMessage(ApplicationPoolImpl.java:4392)
...

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms