IBM Support

Dynamic Query Mode Oracle JDBC connection fails: XQE-GEN-0002 ocijdbc11

Troubleshooting


Problem

When testing a oracle connection that has Dynamic Query Mode (JDBC) enabled, the connection fails with the error: XQE-GEN-0002 An unexpected exception occurred: ocijdbc11 (Not found in java.library.path)

Symptom

Dynamic Query Mode (JDBC) connection fails

Cause

ocijdbc11.dll file was not accessible to IBM Cognos.

Environment

IBM Cognos 64-bit Windows with 64-bit Report Server enabled

Oracle 11g reporting database

Resolving The Problem

1) Copy the ocijdbc11.dll from the Oracle 64 bit directory to the c10_64/bin64 folder. You can also choose to add the Oracle 64 bit client directory to the beginning of the windows PATH variable.
2) Open IBM Cognos Configuration
3) Under the Environment section ensure the "Report Server Execution Mode" is set to 64 bit.
4) Save the configuration
5) Restart the services.

Another possible solution:
Change connection type to ServiceID rather than TNSNAMES-Alias

[{"Product":{"code":"SSEP7J","label":"Cognos Business Intelligence"},"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Component":"Install and Config","Platform":[{"code":"PF033","label":"Windows"}],"Version":"10.2.2;10.2.1;10.2","Edition":"All Editions","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
15 June 2018

UID

swg21573898

Page Feedback