Spotfire Server fails to start after copying Hive JDBC drivers into its \tomcat\lib folder.

Spotfire Server fails to start after copying Hive JDBC drivers into its \tomcat\lib folder.

Product: TIBCO Spotfire Server Version: 6.5.x, 7.0.x, 7.5.x OS: All Supported Operating Systems

--------------------

After JAR files that contain Hive JDBC drivers are copied into Spotfire Server folders (\tomcat\lib) to enable connection to Hive as a JDBC data source, Spotfire Server fails to start.

Symptomps: Spotfire Server fails to start after copying Hive JDBC drivers into its \tomcat\lib folder. The catalina.log file located in the [Spotfire Server installation folder]\tomcat\logs folder has errors like the following:

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

SEVERE: The required Server component failed to start so Tomcat is unable to start. org.apache.catalina.LifecycleException: Failed to start component [StandardServer[9005]]

....

Caused by: org.apache.catalina.LifecycleException: Failed to start component [StandardService[Spotfire]] .. Caused by: org.apache.catalina.LifecycleException: Failed to start component [StandardEngine[Spotfire]] .... Caused by: org.apache.catalina.LifecycleException: A child container failed during start at org.apache.catalina.core.ContainerBase.startInternal(ContainerBase.java:1130) ....

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

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 Tmcat 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.