IBM Support

InfoSphere Optim Performance Manager shows error: Unexpected Throwable caught: Array index out of range: 1. ERRORCODE=-4228, SQLSTATE=null

Troubleshooting


Problem

When trying to configure a new monitored database in OPM, you receive the error: Unexpected Throwable caught: Array index out of range: 1. ERRORCODE=-4228, SQLSTATE=null

Symptom

When adding a new DB2 V9.8 PureScale as the monitored database and the OPM version is V5.2 or lower, OPM shows an error like this:
Caused by: com.ibm.db2.jcc.am.SqlException:
[jcc][t4][10262][11223][3.63.138] Unexpected Throwable caught: Array index out of range: 1. ERRORCODE=-4228, SQLSTATE=null
at com.ibm.db2.jcc.am.fd.a(fd.java:663)
at com.ibm.db2.jcc.am.fd.a(fd.java:60)
at com.ibm.db2.jcc.am.fd.a(fd.java:85)
at com.ibm.db2.jcc.t4.b.b(b.java:893)
at com.ibm.db2.jcc.t4.b.b(b.java:758)
at com.ibm.db2.jcc.t4.b.a(b.java:419)
at com.ibm.db2.jcc.t4.b.a(b.java:394)
at com.ibm.db2.jcc.t4.b.<init>(b.java:332)
at com.ibm.db2.jcc.DB2SimpleDataSource.getConnection(DB2SimpleDataSource.java:231) at com.ibm.db2.jcc.DB2SimpleDataSource.getConnection(DB2SimpleDataSource.java:197) at com.ibm.db2.jcc.DB2Driver.connect(DB2Driver.java:472)
at com.ibm.db2.jcc.DB2Driver.connect(DB2Driver.java:113)
at com.ibm.datatools.common.db.connmgt.impl.DBConnection.createConnectionInternal(DBConnection.java:298)
at com.ibm.datatools.common.db.connmgt.impl.DBConnection.createConnection(DBConnection.java:221) at com.ibm.datatools.common.db.connmgt.impl.DBConnectionManagementService.makeNewConnection(DBConnectionManagementService.java:294)

[{"Product":{"code":"SSBH2R","label":"InfoSphere Optim Performance Manager for Db2 for Linux, UNIX, and Windows"},"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Component":"--","Platform":[{"code":"PF002","label":"AIX"},{"code":"PF010","label":"HP-UX"},{"code":"PF016","label":"Linux"},{"code":"PF027","label":"Solaris"},{"code":"PF033","label":"Windows"}],"Version":"5.1;5.1.1;5.1.1.1;5.2","Edition":"Enterprise;Workgroup;Content Manager;Extended","Line of Business":{"code":"","label":""}}]

Log InLog in to view more of this document

This document has the abstract of a technical article that is available to authorized users once you have logged on. Please use Log in button above to access the full document. After log in, if you do not have the right authorization for this document, there will be instructions on what to do next.

Document Information

More support for:
InfoSphere Optim Performance Manager for Db2 for Linux, UNIX, and Windows

Software version:
5.1, 5.1.1, 5.1.1.1, 5.2

Operating system(s):
AIX, HP-UX, Linux, Solaris, Windows

Document number:
494159

Modified date:
01 May 2025

UID

swg21638576