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

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

book

Article ID: KB0083154

calendar_today

Updated On:

Products Versions
Spotfire Server All Versions

Description

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

Catalina.log file located under [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)
    ....
==========================  
 

Issue/Introduction

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

Resolution

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