Description:This article describes the error "Could not decrypt the bootstrap file with given tool password" when opening the TIBCO Spotfire Server Configuration Tool, after copying the Hive JDBC jar files into Spotfire Server's tomcat\lib folder.
Symptoms:While creating a custom data source template for Hive Database, we need to copy the a series of JAR files that are required for the Hive JDBC driver. After copying all of the JAR files, when opening the TIBCO Spotfire Server Configuration tool to create a custom Data Source template, it throws the error "Could not decrypt the bootstrap file with given tool password" and does not open. It does not prompt for the Tool password.
Refer to the attached screenshot (Filename: Config_Tool_Error.JPG).
Cause:
Apache and other Hive vendors provide JAR files to connect to Hive using JDBC. A JAR file named "hive-jdbc-[version]-standalone.jar" also comes with those JAR files. The file "hive-jdbc-[version]-standalone.jar" is not required by the TIBCO Spotfire Server. This issue occurs when that JAR file is copied into Spotfire Server's tomcat\lib folder along with the other JAR files. Note: The name of this JAR file varies with different versions, but all should end with "standalone.jar": e.g., hive-jdbc-0.14.0-standalone.jar, hive-jdbc-0.14.0.3.0.0.0-249-standalone.jar. See the attachment (Filename: hive_standalone_jar.JPG).