My Oracle Support Banner

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

Last updated on FEBRUARY 27, 2018

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)

The error usually is seen when starting the app or when issuing the first command in the database, however, it can also be seen later.

Cause

To view full details, sign in with your My Oracle Support account.

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


In this Document
Symptoms
Cause
Solution
References

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.