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"
Article ID: KB0076965
Updated On:
| Products | Versions |
|---|---|
| Spotfire Server | All Versions |
Description
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"
======================
=====================
"java.sqI.SQLException: ORA-00604: error occurred at recursive SQL level 1 ORA-01882: timezone region not found"
======================
Issue/Introduction
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"
Resolution
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
Additional Information
Feedback
Yes
No
Powered by
