Timezone error when connecting Dremio to Oracle

Tutorials
1

Hello,

Some users are running into an error similar to below when connecting Dremio to an Oracle source

com.dremio.common.exceptions.UserException: Failure while configuring source [source_name]. Info: Unavailable: 
ORA-00604: error occurred at recursive SQL level 1
ORA-01882: timezone region not found

Adding one or both of the following Java system properties to dremio-env under DREMIO_JAVA_EXTRA_OPTS will likely help:

-Doracle.jdbc.timezoneAsRegion=false
-Duser.timezone=GMT

such as DREMIO_JAVA_EXTRA_OPTS='-Doracle.jdbc.timezoneAsRegion=false -Duser.timezone=GMT'

1 Like