How to Resolve Timezone Region Not Found Error in Bold BI with Oracle Database
When using Bold BI with an Oracle Database in a Linux environment, you may encounter an error stating “timezone region not found.” This issue occurs when the timezone is not configured in the Linux machine where Bold BI is installed. To resolve this issue, follow the steps below to configure the timezone in the Linux machine.
Steps to Configure Timezone in Linux Machine
-
Check the current timezone by running the following command:
timedatectl
-
List available timezones by running the following command:
timedatectl list-timezones
-
Set the desired timezone by running the following command:
sudo timedatectl set-timezone <your_desired_timezone>
Replace
<your_desired_timezone>
with the appropriate timezone from the list generated in step 2. -
Verify the new timezone by running the
timedatectl
command again. -
Restart the Bold BI application.
After completing these steps, the “timezone region not found” error should be resolved. If the issue persists, ensure that the oracle.jdbc.timezoneAsRegion
property is set to false
in your Bold BI configuration.