Unable to login to Spotfire Server Configuration Tool after copying Hive JDBC drivers into the \tomcat\webapps\spotfire\WEB-INF\lib folder. – Revvity Signals

Date Posted: 2017-11-30
Product: TIBCO Spotfire®

Problem:

Unable to login to Spotfire Server Configuration Tool after copying Hive JDBC drivers into the \tomcat\webapps\spotfire\WEB-INF\lib folder.

Solution:

When Hive JDBC drivers are copied to Spotfire Server folders (\tomcat\webapps\spotfire\WEB-INF\lib), Spotfire administrators cannot login to the Spotfire Server Configuration Tool.

The password prompt for the Spotfire Server Configuration Tool goes into a loop, and the tools.log file has an error similar to the following:

================

tools.confui.BootstrapTab: Could not parse bootstrap file C:\tibco\tss\7.0.0\tomcat\webapps\spotfire\WEB-INF\bootstrap.xml

com.spotfire.server.ServerInitializationException: Error parsing the database configuration descriptor

at com.spotfire.server.util.sql.DataSourceConfigurationUtil.deserialize(DataSourceConfigurationUtil.java:129)

at com.spotfire.server.tools.confui.BootstrapTab.useExistingBootstrap(BootstrapTab.java:321)

at com.spotfire.server.tools.confui.BootstrapTab.tryUsingExistingBootstrap(BootstrapTab.java:411)

at com.spotfire.server.tools.confui.ConfigurationFrame.<init>(ConfigurationFrame.java:194)

at com.spotfire.server.tools.confui.ConfigurationMain$2.run(ConfigurationMain.java:64)

Caused by: javax.xml.bind.JAXBException

- with linked exception:

[java.lang.ClassNotFoundException: com.sun.xml.bind.v2.ContextFactory]

================

Cause:
When copying the Hive JDBC drivers, several Hive JAR files are copied to the \tomcat\lib folder. If this list of files contains the ''hive-jdbc-[version]-standalone.jar" file, it will cause Tomcat to fail. The "standalone" JAR should be only used in an environment that has no other JAR files. If it is placed within the Spotfire Server installation folder tree, it causes a conflict with other JAR files that are already present in the Tomcat (Spotfire Server application server) installation folder tree.

Resolution:
Delete the '''hive-jdbc-[version]-standalone.jar" file from \tomcat\lib and restart the Spotfire Server service.

Note: Use the "hive-jdbc-[version].jar" file instead of using the hive-jdbc-[version]-standalone.jar file to connect to Hive from Spotfire. A Hive JDBC jar file is what is needed just not the one labeled as "standalone".