Error message "DRIVER MISSING IS A PROBLEM" while installing a JDBC resource instance

Error message "DRIVER MISSING IS A PROBLEM" while installing a JDBC resource instance

book

Article ID: KB0135588

calendar_today

Updated On:

Products Versions
TIBCO ActiveMatrix Service Grid 3.4.1, 3.4.2, 3.4.3, 3.4.4
TIBCO BPM Enterprise (formerly TIBCO ActiveMatrix BPM) 4.3.2, 4.3.3, 4.3.4, 4.3.5

Description

When installing the JDBC resource instance (RI) from the TIBCO ActiveMatrix administrator we may see the Missing Driver error like below -

image.png

Due to this issue, the user can't install the JDBC RI and the dependent application couldn't start properly.

 

Cause:-

This issue occurs when the existing JDBC driver entry is removed from the machine.xmi of the TIBCO_HOME.

The file machine.xmi can be found inside the directory:

$TIBCO_HOME/tools/machinemodel/shared/1.0.0/

The directory may contain files with bkp or 1, which denotes the backup file of the machine.xmi taken by the TIBCO_HOME installer. Look for the file with the exact name as 'machine.xmi' for the original file.

When configuring the JDBC driver, the TIBCO Configuration Tool (TCT) added the entry in the machine.xmi driver with the componentID as below:

com.tibco.tpcl.gen.<database-name>.jdbc.feature

For each of the supported database types, the feature names are - 

com.tibco.tpcl.gen.oracle.jdbc.feature

com.tibco.tpcl.gen.sqlserver.jdbc.feature

com.tibco.tpcl.gen.db2.jdbc.feature

Environment

ALL

Resolution

Run TCT for the third-party driver of the desired database to add the missing driver to the environment again. This needs to be performed on the machine where SystemNode is hosted. 

Steps:

  1. Stop tibcohost and nodes.
  2. Run the TCT on the SystemNode machine to create the Third-party JDBC Driver.
  3. Check if the machine.xmi file has the entry of the JDBC driver. search for the componentID:

    com.tibco.tpcl.gen.<database-name>.jdbc.feature

 

Issue/Introduction

Error message "DRIVER MISSING IS A PROBLEM" while installing a JDBC resource instance