RRDI 1.0.2 failed installation, CM-CFG-5034, could not load driver "oracle.jdbc.OracleDriver"

Kris Rovell-Rixx (36●1●6●8) | asked Mar 06 '13, 6:22 p.m.
edited Mar 07 '13, 9:36 a.m. by Joseph Pesot (6●1)

How do I find which driver needs to be installed and where do I find it? Or is the error message misleading?

Problem:

http://localhost:9080/reporting/servlet

displays:

IBM Cognos 8

Content Manager

Build: 8.4.6023.0

Start time: Wednesday, March 6, 2013 4:12:46 PM EST

Current time: Wednesday, March 6, 2013 4:12:58 PM EST

State: Not running. See logs.

cogserver.log:

10.135.82.20:9080 2208 2013-03-06 17:05:00.935 -5 Initialization_SESS Initialization_REQ Thread-45 CM 6023 1 Audit.cms.CM StartService Warning CM-CFG-5063 A Content Manager configuration error was detected while connecting to the content store. CM-CFG-5034 Content Manager failed to start because it could not load driver "oracle.jdbc.OracleDriver".

10.135.82.20:9080 2208 2013-03-06 17:05:01.450 -5 pogoStartup na na 0 Thread-45 DISP 6017 1 Audit.Other.dispatcher.DISP.com.cognos.pogo.contentmanager.coordinator.CMBootstrap getActiveContentManager ContentManager Failure <messages><message><messageString>DPR-CMI-4006 Unable to determine the active Content Manager. Will retry periodically.</messageString></message></messages>

Server details:

RRDI 1.0.2 installation

Windows Server 2008 R2 Enterprise SP1 64 bit, 4.00 GB (server is a VM)

Oracle 11g

Content store is on a separate system.

Installation anomalies:

During the step that says :

1. Copy the following Oracle drivers (ojdbc5.jar and ojdbc14.jar) from the [Oracle_installation_directory]/jdbc/lib/ directory to the [Rational_Reporting_installation_directory]/cognos/webapps/p2pd/WEB-INF/lib directory.

only ojdbc5.jar was found. (the same is true for another installation of RRDI 1)

Another installation instruction step says to delete classes12.jar (at two different paths) and the file was not found to delete in either location.

Cognos configuration says it can connect to the content store:

IBM Cognos Configuration -> Data Access -> Content Manager -> RICM -> Test -> (two green checkmarks)

Thanks,

Kris

One answer

Most liked answers ↑|Newest answers|Oldest answers

permanent link

Anthony Kesterton (7.5k●7●178●136) | answered Mar 06 '13, 6:26 p.m.
JAZZ DEVELOPER

In general - you need to use a ojdbc.jar that is compatible with the version of Oracle you are using. You should be able to get the right jar file from Oracle.com.

You also need to make sure the system can always find the right jar file - there is an Oracle environment variable you should set (I don't have that info in front of me - apologies).

Comments

Kris Rovell-Rixx commented Mar 06 '13, 8:21 p.m. | edited Mar 06 '13, 8:23 p.m.

Hi Anthony,

Thanks for the quick response.

From the error message, I can't tell where Cognos expects to find oracle.jdbc.OracleDriver. I think you're saying the same thing. If I knew where the driver belongs, I could probably find the right one. I have another RRDI installation that works.

The instructions don't say to load another driver or to set an environment variable.

For the Oracle thin client, the instructions said to set Path to the client's installation directory. I downloaded the client from Oracle.

The Cognos Configuration tool connected with its test. It didn't at first until I found a driver for it. So Cognos knows about at least one driver.

However, I can't find any info to give me a clue how to proceed.

Thanks,

Kris

Kris Rovell-Rixx commented Mar 07 '13, 9:42 a.m.

I'm working with IBM through a different channel. I'm sure the fix will be easy once I find the spot that's missing a driver.

Thanks again for your response.

Kris

It's all about the answers!

Related questions

RRDI 1.0.2 failed installation, CM-CFG-5034, could not load driver "oracle.jdbc.OracleDriver"

One answer

Your answer