java.sql.SQLDataException: ORA-01882: Timezone Region Not Found (Doc ID 2190198.1)

Last updated on AUGUST 03, 2017

Applies to:

Oracle WebLogic Server - Version 10.3.6 and later
Information in this document applies to any platform.

Symptoms

With an application module deployed on WebLogic Server 10.3.6 and HotSpot JDK 1.7.0_10, fails with the following exception:

[2016-09-16T20:50:28.563+00:00] [ascpt3_server1] [TRACE:32] [] [] [tid: [ACTIVE].ExecuteThread: '0' for queue: 'weblogic.kernel.Default (self-tuning)'] [userId: ] [ecid: f763622554fe56fe:6211125c:15734bc7c5e:-8000-00000000000005b7,0] [SRC_CLASS: oracle.adf.model.binding.DCBindingContainer] [APP: PlanningUI] [SRC_METHOD: cacheException] [559] java.sql.SQLDataException: ORA-01882: timezone region not found[[

at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:462)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:405)
at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:931)
at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:481)
at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:205)
at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:548)
at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:202)
at oracle.jdbc.driver.T4CStatement.executeForRows(T4CStatement.java:1110)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1488)
at oracle.jdbc.driver.OracleStatement.executeUpdateInternal(OracleStatement.java:2147)
at oracle.jdbc.driver.OracleStatement.executeUpdate(OracleStatement.java:2091)
at oracle.jdbc.driver.OracleStatementWrapper.executeUpdate(OracleStatementWrapper.java:320)
at oracle.jdbc.driver.PhysicalConnection.setSessionTimeZone(PhysicalConnection.java:13052)
at weblogic.jdbc.wrapper.PoolConnection_oracle_jdbc_driver_T4CConnection.setSessionTimeZone(Unknown Source)
at oracle.jbo.server.OracleSQLBuilderImpl.setSessionTimeZone(OracleSQLBuilderImpl.java:5533)
at oracle.jbo.server.DBTransactionImpl.refreshConnectionMetadata(DBTransactionImpl.java:5311)
at oracle.jbo.server.DBTransactionImpl.initTransaction(DBTransactionImpl.java:1194)
at oracle.jbo.server.DBTransactionImpl.initTxn(DBTransactionImpl.java:6826)
at oracle.jbo.server.DBTransactionImpl2.connectToDataSource(DBTransactionImpl2.java:304)
at oracle.jbo.server.DBTransactionImpl2.connectToDataSource(DBTransactionImpl2.java:335)
at oracle.jbo.common.ampool.DefaultConnectionStrategy.connect(DefaultConnectionStrategy.java:203)

 

Changes

 

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