My Oracle Support Banner

ODI Studio Fails to Start After Changing the Timezone to CEST when Using MySQL Database for Repository (Doc ID 2659624.1)

Last updated on APRIL 12, 2021

Applies to:

Oracle Data Integrator on Marketplace - Version 12.2.1.4.200304 and later
Information in this document applies to any platform.

Symptoms

On an Oracle Data Integrator (ODI) on Marketplace instance, created to use a repository on the MySQL Database, setting the time zone to the Central European Summer Time (CEST) region results in Studio failing to start on this instance. 

The time zone was changed using timedatectlcommand.

Logging into Studio fails with the following error message: 

oracle.odi.core.config.MasterRepositoryResourceFailureException: ODI-10182: Uncategorized exception during repository access.
Failed to obtain JDBC Connection; nested exception is java.sql.SQLException: Unable to start the Universal Connection Pool: oracle.ucp.UniversalConnectionPoolException: Cannot get Connection from Datasource: java.sql.SQLException: The server time zone value 'CEST' is unrecognized or represents more than one time zone. You must configure either the server or JDBC driver (via the serverTimezone configuration property) to use a more specifc time zone value if you want to utilize time zone support.
  at oracle.odi.core.repository.Repository.getMasterRepository(Repository.java:117)
  at oracle.odi.core.OdiInstance.createMasterRepository(OdiInstance.java:617)
  at oracle.odi.core.OdiInstance.(OdiInstance.java:868)
  at oracle.odi.core.OdiInstance.createInstance(OdiInstance.java:735)
  at oracle.odi.ui.docking.panes.OdiCnxFactory$2.run(OdiCnxFactory.java:247)
  at oracle.ide.dialogs.ProgressBar.run(ProgressBar.java:961)
  at java.lang.Thread.run(Thread.java:748)
Caused by: org.springframework.jdbc.CannotGetJdbcConnectionException: Failed to obtain JDBC Connection; nested exception is java.sql.SQLException: Unable to start the Universal Connection Pool: oracle.ucp.UniversalConnectionPoolException: Cannot get Connection from Datasource: java.sql.SQLException: The server time zone value 'CEST' is unrecognized or represents more than one time zone. You must configure either the server or JDBC driver (via the serverTimezone configuration property) to use a more specifc time zone value if you want to utilize time zone support.

Changes

 This can occur when setting the instance time zone to something other than Coordinated Universal Time (UTC).

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
Changes
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.