Running an ADF BC Application Fails With ORA-01882 (Doc ID 756075.1)

Last updated on JANUARY 09, 2017

Applies to:

Oracle JDeveloper - Version 11.1.1.0.0 and later
Oracle WebLogic Server - Version 10.3 and later
Information in this document applies to any platform.
***Checked for relevance on 31-Oct-2012***


Symptoms

In JDeveloper 11g or 12c, when attempting to run a web application or testing an Application Module, an error similar to this occurs:

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:5490)
at oracle.jbo.server.DBTransactionImpl.refreshConnectionMetadata(DBTransactionImpl.java:5020)
at oracle.jbo.server.DBTransactionImpl.initTransaction(DBTransactionImpl.java:1132)
at oracle.jbo.server.DBTransactionImpl.initTxn(DBTransactionImpl.java:6372)
at oracle.jbo.server.DBTransactionImpl2.connectToDataSource(DBTransactionImpl2.java:286)
Truncated. see log file for complete stacktrace

Caused By: java.sql.SQLDataException: ORA-01882: timezone region not found

at oracle.jdbc.driver.SQLStateMapping.newSQLException(SQLStateMapping.java:83)
at oracle.jdbc.driver.DatabaseError.newSQLException(DatabaseError.java:135)
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:210)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:473)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:423)
Truncated. see log file for complete stacktrace
Another possible error might be:
javax.faces.FacesException: oracle.adf.controller.ControllerException: ADFC-10001: cannot instantiate class 'com.some.class'
  at oracle.adfinternal.controller.util.Utils.createAndLogFacesException(Utils.java:196)
  at oracle.adfinternal.controller.beans.ManagedBeanFactory.newInstance(ManagedBeanFactory.java:189)
  at oracle.adfinternal.controller.beans.ManagedBeanFactory.instantiateBean(ManagedBeanFactory.java:896)
  at oracle.adfinternal.controller.state.ScopeMap.get(ScopeMap.java:82)
  at javax.el.MapELResolver.getValue(MapELResolver.java:199)
  ... 181 more
Caused by: 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:5523)

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