FAQs

Frequently Asked Questions - ArrayIndexOutOfBounds

FAQs - ArrayIndexOutOfBounds

If you are getting the following or similar exception, then you are hitting a bug in the Oracle JDBC driver documented here (requires access to Oracle Metalink site): https://metalink.oracle.com/metalink/plsql/ml2_documents.showDocument?p_database_id=BUG&p_id=7112447

[2015-12-21 17:35:14,984] E [QuartzScheduler_Worker-1] [com.quartzdesk.agent.scheduler.common.a:140] - Error processing job execution event: QuartzJobExecutionEvent[...]
com.quartzdesk.agent.api.AgentException: Error creating instance of: class com.quartzdesk.agent.api.domain.model.scheduler.quartz.QuartzExecHistory
...
Caused by: java.lang.ArrayIndexOutOfBoundsException: 35 at oracle.jdbc.driver.OracleSql.computeBasicInfo(OracleSql.java:1005) ~[ojdbc6dms.jar:Oracle JDBC Driver version - "11.1.0.7.0-Production"] at oracle.jdbc.driver.OracleSql.getSqlKind(OracleSql.java:655) ~[ojdbc6dms.jar:Oracle JDBC Driver version - "11.1.0.7.0-Production"] at oracle.jdbc.driver.OraclePreparedStatement.(OraclePreparedStatement.java:1225) ~[ojdbc6dms.jar:Oracle JDBC Driver version - "11.1.0.7.0-Production"] at oracle.jdbc.driver.T4CPreparedStatement.(T4CPreparedStatement.java:30) ~[ojdbc6dms.jar:Oracle JDBC Driver version - "11.1.0.7.0-Production"] at oracle.jdbc.driver.T4CDriverExtension.allocatePreparedStatement(T4CDriverExtension.java:70) ~[ojdbc6dms.jar:Oracle JDBC Driver version - "11.1.0.7.0-Production"] at oracle.jdbc.driver.PhysicalConnection.prepareStatement(PhysicalConnection.java:3906) ~[ojdbc6dms.jar:Oracle JDBC Driver version - "11.1.0.7.0-Production"] at oracle.jdbc.driver.PhysicalConnection.prepareStatement(PhysicalConnection.java:3688) ~[ojdbc6dms.jar:Oracle JDBC Driver version - "11.1.0.7.0-Production"] at oracle.jdbc.driver.PhysicalConnection.prepareStatement(PhysicalConnection.java:9655) ~[ojdbc6dms.jar:Oracle JDBC Driver version - "11.1.0.7.0-Production"] at ext.org.apache.commons.dbcp.DelegatingConnection.prepareStatement(SourceFile:532) ~[quartzdesk-agent-2.3.0.jar:2.3.0] at ext.org.apache.commons.dbcp.PoolingDataSource$PoolGuardConnectionWrapper.prepareStatement(SourceFile:415) ~[quartzdesk-agent-2.3.0.jar:2.3.0] at com.quartzdesk.agent.scheduler.quartz.a.b.e.a(SourceFile:778) ~[quartzdesk-agent-2.3.0.jar:2.3.0] at com.quartzdesk.agent.scheduler.quartz.b.a(SourceFile:189) ~[quartzdesk-agent-2.3.0.jar:2.3.0] at com.quartzdesk.agent.scheduler.quartz.b.a(SourceFile:52) ~[quartzdesk-agent-2.3.0.jar:2.3.0] at com.quartzdesk.agent.scheduler.common.a.a(SourceFile:446) ~[quartzdesk-agent-2.3.0.jar:2.3.0] ... 8 common frames omitted

To resolve this issue, you must upgrade the Oracle JDBC driver that is used by the agent.

Oracle 11g and 12c JDBC drivers can be downloaded from here: http://www.oracle.com/technetwork/database/features/jdbc/index-091264.html