Unable to start DIP Server Error java.sql.SQLException: java.lang.IndexOutOfBoundsException "No good connections available" (Doc ID 1457895.1)

Last updated on SEPTEMBER 08, 2021

Applies to:

Symptoms

OID 11.1.1.x

Unable to start DIP Server
Following error is shown in the diagnostic log

[2012-03-16T08:28:27.601+01:00] [wls_ods1] [ERROR] [] [org.quartz.impl.jdbcjobstore.JobStoreTX] [tid: QuartzScheduler_DefaultQuartzScheduler-<HOSTNAME>_ClusterManager] [userId: <anonymous>] [ecid: <ECID>] [APP: DIP#11.1.1.2.0] ClusterManager: Error managing cluster: Failed to obtain DB connection from data source 'schedulerDS': java.sql.SQLException: Could not retrieve datasource via JNDI url 'jdbc/schedulerDS' java.sql.SQLException: java.lang.IndexOutOfBoundsException: Index: 0, Size: 0[[
org.quartz.JobPersistenceException: Failed to obtain DB connection from data source 'schedulerDS': java.sql.SQLException: Could not retrieve datasource via JNDI url 'jdbc/schedulerDS' java.sql.SQLException: java.lang.IndexOutOfBoundsException: Index: 0, Size: 0 [See nested exception: java.sql.SQLException: Could not retrieve datasource via JNDI url 'jdbc/schedulerDS' java.sql.SQLException: java.lang.IndexOutOfBoundsException: Index: 0, Size: 0]
       at org.quartz.impl.jdbcjobstore.JobStoreSupport.getConnection(JobStoreSupport.java:636)
       at org.quartz.impl.jdbcjobstore.JobStoreTX.getNonManagedTXConnection(JobStoreTX.java:72)
       at org.quartz.impl.jdbcjobstore.JobStoreSupport.doCheckin(JobStoreSupport.java:3070)
       at org.quartz.impl.jdbcjobstore.JobStoreSupport$ClusterManager.manage(JobStoreSupport.java:3713)
       at org.quartz.impl.jdbcjobstore.JobStoreSupport$ClusterManager.run(JobStoreSupport.java:3749)
Caused by: java.sql.SQLException: Could not retrieve datasource via JNDI url 'jdbc/schedulerDS' java.sql.SQLException: java.lang.IndexOutOfBoundsException: Index: 0, Size: 0
       at org.quartz.utils.JNDIConnectionProvider.getConnection(JNDIConnectionProvider.java:166)
       at org.quartz.utils.DBConnectionManager.getConnection(DBConnectionManager.java:112)
       at org.quartz.impl.jdbcjobstore.JobStoreSupport.getConnection(JobStoreSupport.java:633)
       ... 4 more

]]
[2012-03-16T08:28:27.629+01:00] [wls_ods1] [ERROR] [] [org.quartz.impl.jdbcjobstore.JobStoreTX] [tid: QuartzScheduler_DefaultQuartzScheduler-<HOSTNAME>_MisfireHandler] [userId: <anonymous>] [ecid: <ECID>] [APP: DIP#11.1.1.2.0] MisfireHandler: Error handling misfires: Failed to obtain DB connection from data source 'schedulerDS': java.sql.SQLException: Could not retrieve datasource via JNDI url 'jdbc/schedulerDS' java.sql.SQLException: weblogic.common.ResourceException: No good connections available.[[
org.quartz.JobPersistenceException: Failed to obtain DB connection from data source 'schedulerDS': java.sql.SQLException: Could not retrieve datasource via JNDI url 'jdbc/schedulerDS' java.sql.SQLException: weblogic.common.ResourceException: No good connections available. [See nested exception: java.sql.SQLException: Could not retrieve datasource via JNDI url 'jdbc/schedulerDS' java.sql.SQLException: weblogic.common.ResourceException: No good connections available.]
       at org.quartz.impl.jdbcjobstore.JobStoreSupport.getConnection(JobStoreSupport.java:636)
       at org.quartz.impl.jdbcjobstore.JobStoreTX.getNonManagedTXConnection(JobStoreTX.java:72)
       at org.quartz.impl.jdbcjobstore.JobStoreSupport.doRecoverMisfires(JobStoreSupport.java:3011)
       at org.quartz.impl.jdbcjobstore.JobStoreSupport$MisfireHandler.manage(JobStoreSupport.java:3789)
       at org.quartz.impl.jdbcjobstore.JobStoreSupport$MisfireHandler.run(JobStoreSupport.java:3809)
Caused by: java.sql.SQLException: Could not retrieve datasource via JNDI url 'jdbc/schedulerDS' java.sql.SQLException: weblogic.common.ResourceException: No good connections available.
       at org.quartz.utils.JNDIConnectionProvider.getConnection(JNDIConnectionProvider.java:166)
       at org.quartz.utils.DBConnectionManager.getConnection(DBConnectionManager.java:112)

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.