Silent upgrade of TIBCO Spotfire Server fails with error "Database drivers are not on the Java classpath. For silent upgrade to work all drivers must be on the path" when Spotfire application database is on Oracle

Silent upgrade of TIBCO Spotfire Server fails with error "Database drivers are not on the Java classpath. For silent upgrade to work all drivers must be on the path" when Spotfire application database is on Oracle

book

Article ID: KB0078784

calendar_today

Updated On:

Products Versions
Spotfire Server 7.5 and higher

Description

When upgrading the TIBCO Spotfire Server silently with the Spotfire application database on an Oracle database server, the upgrade process completes with following message: 
The silent upgrade completed with 1 error(s)

Database drivers are not on the Java classpath. For silent upgrade to work all drivers must be on the path
In this scenario, it will not upgrade the database and you will see the following error in the details.log: 
DEBUG 2019-03-12T20:30:14,175 tools.upgrade.UpgradeUtilities: Found incompatible JDBC drivers in <installation directory>/tibco/tss-x.x.x/tomcat/lib
ERROR 2019-03-12T20:30:14,178 upgrade.steps.ManualDatabaseDriverInstallStep: Database drivers are not on the Java classpath. For silent upgrade to work all drivers must be on the path

 

Issue/Introduction

Silent upgrade of TIBCO Spotfire Server fails with error "upgrade.steps.ManualDatabaseDriverInstallStep: Database drivers are not on the Java classpath. For silent upgrade to work all drivers must be on the path" when Spotfire application database is on Oracle

Resolution

If the above error is seen in the details.log during a silent upgrade, this means that there is an issue with the driver/database. To resolve, please check the following points:
  1. The database version that you are using may not be compatible with the upgraded TIBCO Spotfire Server version. Verify the database version is supported per the System Requirements
  2. The driver class specified in the bootstrap.xml file is 'oracle.jdbc.driver.OracleDriver' which Oracle deprecated with Oracle 9i and completely removed support for with Oracle 11g (see reference https://www.oracle.com/technetwork/database/enterprise-edition/111070-readme-083278.html). In this case, change the driver class to 'oracle.jdbc.OracleDriver'
  3. Ensure that the latest available Oracle JDBC driver is used. Download latest Oracle JDBC driver and paste it in <TIBCO Spotfire Server installation directory>/tomcat/lib/ folder, and then upgrade

Additional Information

Doc: Running Spotfire Server upgrade tool silently Doc: System requirements for TIBCO Spotfire Server External: Oracle JDBC Drivers release 11.1.0.7.0 - What Is New In This Release?
Powered by Wolken Software