Troubleshooting
Problem
User logs onto Controller application server, and launches "Controller Configuration". User opens "Database Connections" and selects connection. User clicks green 'play' button to launch 'Database Conversion Utility'. User clicks 'Connect'. After a few seconds delay, an error appears.
Symptom
** ERROR: java.lang.ArrayIndexOutOfBoundsException: Array index out of range: 176
or sometimes simply:
** ERROR: java.lang.ArrayIndexOutOfBoundsException
Cause
Incompatible Oracle JDBC driver in use by system.
More Information
Oracle has produced several different JDBC drivers.
- There are several different possible file names/versions (for example ojdbc5.jar). For full details, see separate IBM Technote #1988891.
Environment
The problem does not affect all environments - for most environments other JAR files (for example the older OJDBC14.JAR file) work OK.
Resolving The Problem
Reconfigure your Controller application server to use a different OJDBC files (for example OJDBC6.JAR).
Steps:
Before continuing, you need to obtain the OJDBC6.JAR file. Either:
- Download it from the Oracle website (link below)
- Or it can be found inside the Oracle 11Grel2 client installation (default path = C:\app\<username>\product\11.2.0\client_1\jdbc\lib).
- Logon to the Controller application server
- Open the C10 folder (default location = C:\Program Files\ibm\cognos\c10)
- Delete any existing JAR file (for example Classes12.jar or ojdbc14.jar)
- Copy the file ojdbc6.jar into this folder
- For other (different) functionality to work correctly, repeat the above steps for the folder ...\c10\server\integration
- For other (different) functionality to work correctly, repeat the above steps for the folder ...\c10\server\FAP\lib
Related Information
Was this topic helpful?
Document Information
Modified date:
15 June 2018
UID
swg21572498