JDBC/OCI connection failed with error: XQE-GEN-0002 An unexpected exception occurred: ocijdbc11 (Not found in java.library.path)

Technote (troubleshooting)


Problem(Abstract)

Testing an Oracle data source defined within IBM Cognos Server Administration results in the following error for the Dynamic Query Mode(DQM) connection test:

JDBC/OCI connection failed with error: XQE-GEN-0002 An unexpected exception occurred: ocijdbc11 Not found in java.library.path.

Symptom

Testing an Oracle data source defined within IBM Cognos Server Administration results in the following error for the Dynamic Query Mode(DQM) connection test:

JDBC/OCI connection failed with error: XQE-GEN-0002 An unexpected exception occurred: ocijdbc11 Not found in java.library.path.


Cause

This error occurs on any 64-bit IBM Cognos 10 install that uses both the 32-bit Compatible Query Mode(CQM) and the 64 bit DQM against an Oracle data source, where the DQM data source connection type is set to TNS Names Alias. The cause of the problem is that the TNS Names Alias DQM connection type setting requires the 64 bit Oracle client libraries whereas CQM requires the 32 bit Oracle client libraries. The OS library loader will automatically pick up the first one defined on the PATH statement. .

Resolving the problem

The following steps resolve the error and allow both CQM and DQM to connect to the Oracle data source. These steps need to be performed on every IBM Cognos Application Server component within a single Environment that performs Oracle data access.

Locate the cognos_install/configuration/xqe.config.xml file and make a back up copy.

Open the xqe.config.xml file using a text editor.

Add the envar tags below for the appropriate operating system.

For AIX, search for os name="AIX". then add a new line:
<envvar name="LIBPATH" value="your LIBPATH which include the Oracle 64 bit libraries"/>

For Solaris, search for os name="SunOS", then add a new line:
<envvar name="LD_LIBRARY_PATH" value="your LD_LIBRARY_PATH which include the Oracle 64bit libraries"/>

Save the changes and close the file.

Locate the databaseDriverLocations.properties.sample file located within the cognos_install\v5dataserver folder.

Rename this file to databaseDriverLocations.properties.

Open this file using a text editor.

Update the databaseJNIPATH to point to the Oracle 64 bit libraries.
databseJNIPATH=Oracle\\product\\11.1.0\\client_1\\BIN

Save the changes and close the file.

Stop and re-start the IBM Cognos Service.






.


Rate this page:

(0 users)Average rating

Add comments

Document information


More support for:

Cognos Business Intelligence
Cognos Connection

Software version:

10.1, 10.1.1, 10.2

Operating system(s):

AIX, HP-UX, Linux, Solaris

Software edition:

All Editions

Reference #:

1574953

Modified date:

2013-11-11

Translate my page

Machine Translation

Content navigation