** ERROR: java.lang.ArrayIndexOutOfBoundsException: Array index out of range: 50

Product:

Cognos Contoller 10.1.1

Windows 2008 R2 Server

Oracle 11g

Symptom:

New installation of Cognos controller 10, to be used with Oracle database.

When click connect in Cognos Controller DBCONV program you get a error message.

Error message:

** ERROR: java.lang.ArrayIndexOutOfBoundsException: Array index out of range: 50

** ERROR: java.sql.SQLRecoverableException: IO-Fel: could not resolve the connect identifier

Solution:

Change the tnsnames.ora file for the oracle client on the Cognos Controller server.

Ensure the tnsnames.ora file only contain the values for the cognos controller database, not reference to other oracle schema or databases.

Ensure the information is written in several lines, as shown below, and not in a single line in the tnsnames.ora file.

FRANGO= (DESCRIPTION= (ADDRESS=(PROTOCOL=TCP)(HOST= SERVERNAME.DOMAIN.COM)(PORT=1521) ) (CONNECT_DATA= (SERVICE_NAME=service_name)))

Replace italic above with the schema/oracle server name.

More information

CogKnowHow