Date Posted:
Product: TIBCO Spotfire®
Product: TIBCO Spotfire®
Problem:
TIBCO Spotfire Server fails to start with an error "java.sqI.SQLException: ORA-00604: error occurred at recursive SQL level 1 ORA-01882: timezone region not found"
Solution:
TIBCO Spotfire Server fails to start after configuring the Oracle Thin driver in the bootstrap file. Below error returned in the <Spotfire Server Install>\tomcat\logs\catalina.log
=====================
"java.sqI.SQLException: ORA-00604: error occurred at recursive SQL level 1 ORA-01882: timezone region not found"
======================
The workaround is to set the connection property oracle.jdbc.timezoneAsRegion to "false". This reverts to the old style of session timezone behavior.
In that case set the Java parameter when starting the server.
- Open a command prompt and cd to “<spotfire installation>\tomcat\bin” -
- Run the command e.g “tomcat8w //MS//Tss7112” for 7.11.2 service or "tomcat9w //MS//Tss1030" for 10.3.0 service. This will show the little red/green/white Apache icon in the taskbar or open the GUI application for monitoring and configuring Tomcat services.
- Right click the icon and choose “configure”
- Go to the Java tab
- Enter the -Doracle.jdbc.timezoneAsRegion=false in the Java options
- Click “Ok” - Restart the Spotfire server
https://blogs.oracle.com/imc/jdeveloper-12c-ora-01882:-timezone-region-not-found
Comments
0 comments
Article is closed for comments.