Hello,
we are testing 12.1.3 with Oracle and run in ORA-01882: timezone region not found error for assets.
We already modified the file xqe.config.xml with -Duser.timezone=Europe/Berlin so the reports are running, but when we go to Assets for an Oracle database we directly get the ORA-01882 error.
Does someone has version 12.1.3 running with Oracle and without this error? What changes needs to be done?
Thanks
Michael
Hi Michael,
You can try to add -Doracle.jdbc.timezoneAsRegion=false in the xqe.config.xml file.
Source: https://forums.oracle.com/ords/apexds/post/ora-01882-timezone-region-not-found-9452
Best regards,
Patrick Neveu
Solution:
Add the line
<param>-Duser.timezone=Europe/Berlin</param>
in file
bin64/bootstrap_wlp_*.xml
(Behind line <param>-Xmx${dispatcherMaxMemory}m</param>)