My Oracle Support Banner

DEBUG BatchReportJob caught exception - JDBC Connection Pool Frequently Going In Suspended State (Doc ID 2039337.1)

Last updated on OCTOBER 17, 2018

Applies to:

Oracle WebLogic Server - Version 10.3 and later
Information in this document applies to any platform.

Symptoms

JDBC data sources frequently gets suspended all of a sudden.

You get to see a lot of the below messages:

<Jul 23, 2015 1:25:09 PM EST> <Notice> <Stdout> <BEA-000000> <132509 DEBUG BatchReportJob             caught exception
<Jul 23, 2015 1:25:09 PM EST> <Notice> <Stdout> <BEA-000000> <132509 DEBUG BatchReportJob             caught exception
<Jul 23, 2015 1:25:10 PM EST> <Notice> <Stdout> <BEA-000000> <132510 DEBUG BatchReportJob             caught exception
<Jul 23, 2015 1:25:10 PM EST> <Notice> <Stdout> <BEA-000000> <132510 DEBUG BatchReportJob             caught exception

 
Sample trace from the log file:

<Jul 23, 2015 1:25:09 PM EST> <Notice> <Stdout> <BEA-000000> <132509 DEBUG BatchReportJob             caught exception
org.quartz.JobPersistenceException: Failed to obtain DB connection from data source 'quartzDS': java.sql.SQLException: Could not retrieve datasource via JNDI url 'com.commoss.panda.quartz' weblogic.jdbc.extensions.PoolDisabledSQLException: weblogic.common.resourcepool.ResourceDisabledException: Pool QUARTZ1P is disabled, cannot allocate resources to applications.. [See nested exception: java.sql.SQLException: Could not retrieve datasource via JNDI url 'com.commoss.panda.quartz' weblogic.jdbc.extensions.PoolDisabledSQLException: weblogic.common.resourcepool.ResourceDisabledException: Pool QUARTZ1P is disabled, cannot allocate resources to applications..]
at org.quartz.impl.jdbcjobstore.JobStoreSupport.getConnection(JobStoreSupport.java:570)
at org.quartz.impl.jdbcjobstore.JobStoreTX.storeJobAndTrigger(JobStoreTX.java:146)
at org.quartz.core.QuartzScheduler.scheduleJob(QuartzScheduler.java:613)
at org.quartz.impl.StdScheduler.scheduleJob(StdScheduler.java:238)
at com.commoss.panda.optus.ui.BatchReportJob.sendJobCompletedEmail(BatchReportJob.java:452)
at com.commoss.panda.optus.ui.BatchReportJob.execute(BatchReportJob.java:273)
at org.quartz.core.JobRunShell.run(JobRunShell.java:195)
at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:520)
* Nested Exception (Underlying Cause) ---------------
java.sql.SQLException: Could not retrieve datasource via JNDI url 'com.commoss.panda.quartz' weblogic.jdbc.extensions.PoolDisabledSQLException: weblogic.common.resourcepool.ResourceDisabledException: Pool QUARTZ1P is disabled, cannot allocate resources to applications..
at org.quartz.utils.JNDIConnectionProvider.getConnection(JNDIConnectionProvider.java:166)
at org.quartz.utils.DBConnectionManager.getConnection(DBConnectionManager.java:111)
at org.quartz.impl.jdbcjobstore.JobStoreSupport.getConnection(JobStoreSupport.java:553)
at org.quartz.impl.jdbcjobstore.JobStoreTX.storeJobAndTrigger(JobStoreTX.java:146)
at org.quartz.core.QuartzScheduler.scheduleJob(QuartzScheduler.java:613)
at org.quartz.impl.StdScheduler.scheduleJob(StdScheduler.java:238)
at com.commoss.panda.optus.ui.BatchReportJob.sendJobCompletedEmail(BatchReportJob.java:452)
at com.commoss.panda.optus.ui.BatchReportJob.execute(BatchReportJob.java:273)
at org.quartz.core.JobRunShell.run(JobRunShell.java:195)
at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:520)>
org.quartz.JobPersistenceException: Failed to obtain DB connection from data source 'quartzDS': java.sql.SQLException: Could not retrieve datasource via JNDI url 'com.commoss.panda.quartz' weblogic.jdbc.extensions.PoolDisabledSQLException: weblogic.common.resourcepool.ResourceDisabledException: Pool QUARTZ1P is disabled, cannot allocate resources to applications.. [See nested exception: java.sql.SQLException: Could not retrieve datasource via JNDI url 'com.commoss.panda.quartz' weblogic.jdbc.extensions.PoolDisabledSQLException: weblogic.common.resourcepool.ResourceDisabledException: Pool QUARTZ1P is disabled, cannot allocate resources to applications..]
at org.quartz.impl.jdbcjobstore.JobStoreSupport.getConnection(JobStoreSupport.java:570)
at org.quartz.impl.jdbcjobstore.JobStoreTX.storeJobAndTrigger(JobStoreTX.java:146)
at org.quartz.core.QuartzScheduler.scheduleJob(QuartzScheduler.java:613)
at org.quartz.impl.StdScheduler.scheduleJob(StdScheduler.java:238)
at com.commoss.panda.optus.ui.BatchReportJob.sendJobCompletedEmail(BatchReportJob.java:452)
at com.commoss.panda.optus.ui.BatchReportJob.execute(BatchReportJob.java:273)
at org.quartz.core.JobRunShell.run(JobRunShell.java:195)
at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:520)
* Nested Exception (Underlying Cause) ---------------
java.sql.SQLException: Could not retrieve datasource via JNDI url 'com.commoss.panda.quartz' weblogic.jdbc.extensions.PoolDisabledSQLException: weblogic.common.resourcepool.ResourceDisabledException: Pool QUARTZ1P is disabled, cannot allocate resources to applications..
at org.quartz.utils.JNDIConnectionProvider.getConnection(JNDIConnectionProvider.java:166)
at org.quartz.utils.DBConnectionManager.getConnection(DBConnectionManager.java:111)
at org.quartz.impl.jdbcjobstore.JobStoreSupport.getConnection(JobStoreSupport.java:553)
at org.quartz.impl.jdbcjobstore.JobStoreTX.storeJobAndTrigger(JobStoreTX.java:146)
at org.quartz.core.QuartzScheduler.scheduleJob(QuartzScheduler.java:613)
at org.quartz.impl.StdScheduler.scheduleJob(StdScheduler.java:238)
at com.commoss.panda.optus.ui.BatchReportJob.sendJobCompletedEmail(BatchReportJob.java:452)
at com.commoss.panda.optus.ui.BatchReportJob.execute(BatchReportJob.java:273)
at org.quartz.core.JobRunShell.run(JobRunShell.java:195)
at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:520)
<Jul 23, 2015 1:25:09 PM EST> <Notice> <Stdout> <BEA-000000> <132509 DEBUG BatchReportJob             ++sendEmailFailed>
<Jul 23, 2015 1:25:09 PM EST> <Notice> <Stdout> <BEA-000000> <132509  INFO QuartzScheduler              Scheduler QuartzScheduler_$_NON_CLUSTERED started.>
<Jul 23, 2015 1:25:09 PM EST> <Debug> <JDBCConn> <BEA-000000> <JTS/JDBC Connect: url = jdbc:weblogic:jts:QUARTZ1P, tx = null, props = {EmulateTwoPhaseCommit=false, connectionPoolID=QUARTZ1P, jdbcTxDataSource=true, LoggingLastResource=false, dataSourceName=QUARTZ1P}>
<Jul 23, 2015 1:25:09 PM EST> <Debug> <JDBCConn> <BEA-000000> <Transaction = null. Returning an ordinary JDBC conn>
<Jul 23, 2015 1:25:09 PM EST> <Debug> <JDBCConn> <BEA-000000> <Exception:
weblogic.jdbc.extensions.PoolDisabledSQLException: weblogic.common.resourcepool.ResourceDisabledException: Pool QUARTZ1P is disabled, cannot allocate resources to applications..
at weblogic.jdbc.common.internal.JDBCUtil.wrapAndThrowResourceException(JDBCUtil.java:250)
at weblogic.jdbc.pool.Driver.connect(Driver.java:160)
at weblogic.jdbc.jts.Driver.getNonTxConnection(Driver.java:642)
at weblogic.jdbc.jts.Driver.connect(Driver.java:124)
at weblogic.jdbc.common.internal.RmiDataSource.getConnection(RmiDataSource.java:338)
at org.quartz.utils.JNDIConnectionProvider.getConnection(JNDIConnectionProvider.java:159)
at org.quartz.utils.DBConnectionManager.getConnection(DBConnectionManager.java:111)
at org.quartz.impl.jdbcjobstore.JobStoreSupport.getConnection(JobStoreSupport.java:553)
at org.quartz.impl.jdbcjobstore.JobStoreTX.storeJobAndTrigger(JobStoreTX.java:146)
at org.quartz.core.QuartzScheduler.scheduleJob(QuartzScheduler.java:613)
at org.quartz.impl.StdScheduler.scheduleJob(StdScheduler.java:238)
at com.commoss.panda.optus.ui.BatchReportJob.sendEmailFailed(BatchReportJob.java:506)
at com.commoss.panda.optus.ui.BatchReportJob.sendJobCompletedEmail(BatchReportJob.java:463)
at com.commoss.panda.optus.ui.BatchReportJob.execute(BatchReportJob.java:273)
at org.quartz.core.JobRunShell.run(JobRunShell.java:195)
at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:520)

 

Changes

Firewall changes.

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Changes
Cause
Solution


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