Why does the BusinessWorks ProcessMonitor (BWPM) Server keep requestingdatabase configurations to create BWPM database instance?

Why does the BusinessWorks ProcessMonitor (BWPM) Server keep requestingdatabase configurations to create BWPM database instance?

book

Article ID: KB0090971

calendar_today

Updated On:

Products Versions
TIBCO BusinessWorks ProcessMonitor -
Not Applicable -

Description

Resolution:
Description:
============
Why does the BusinessWorks ProcessMonitor (BWPM) Server keep requesting  database configurations to create BWPM database instance?

Environment:
===========
BWPM: ALL
JDBC Driver(s): ALL

Symptoms:
========
After successfully installing the BWPM Server and creating a BPWM database I try to log into the BWPM Server HTTP interface and am asked to keep re-entering the database configuration to create a new BWPM database instance.

Cause:
=====
Two potential causes.

1). An unsupported JDBC driver version is being used by BWPM server, as such the database is not being created correctly.

2). Database and driver version does not match. This could happen (such as Database version 11.2.0.3 and Driver version 11.2.0.1) . SQL database and driver version mismatch can also lead to this.

You can confirm which JDBC driver and database version being used by reviewing the tomcat/logs/server.log.

Look for entries such as :

=====  Database info =====

DatabaseProductName: Oracle
DatabaseProductVersion: Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production With the Partitioning option
DatabaseMajorVersion: 11
DatabaseMinorVersion: 2
=====  Driver info =====
DriverName: Oracle JDBC driver
DriverVersion: 11.2.0.1.0
DriverMajorVersion: 11
DriverMinorVersion: 2


Resolution:
==========
Remove the incorrect driver from the Tomcat classpath and replace it with a supported version or the correct version. You will need to check the following locations. Tomcat will typically load classes in this order and locations:

1). Bootstrap: classes from your JVM  ($JAVA_HOME/jre/lib/ext)

2). System:  classes defined in the System environment variable 'CLASSPATH'

3). Common: classes found in $CATALINA_BASE/lib and $CATALINA_HOME/lib

4). &ltWEB APP>/WEB-INF/lib/ and &ltWEB APP>/WEB-INF/classes/

Issue/Introduction

Why does the BusinessWorks ProcessMonitor (BWPM) Server keep requestingdatabase configurations to create BWPM database instance?