My Oracle Support Banner

Scheduled Conflict Analysis Fails with Error 'Could not get JDBC Connection; nested exception is org.apache.commons.dbcp.SQLNestedException: Could not retrieve connection info from pool' (Doc ID 2238895.1)

Last updated on AUGUST 06, 2018

Applies to:

Oracle Application Access Controls Governor - Version 8.6.5 and later
Information in this document applies to any platform.


On all-

Some of the Scheduled Conflict analysis sometime fails with the following error. 


2016-08-10 21:03:31,695 ERROR [GrcExecutorThread-11115] DataSourceDaoSpr:2670 Could not load DataSource(id=23)
org.springframework.jdbc.CannotGetJdbcConnectionException: Could not get JDBC Connection; nested exception is org.apache.commons.dbcp.SQLNestedException: Could not retrieve connection info from pool
at org.springframework.jdbc.datasource.DataSourceUtils.getConnection(

Caused by: java.util.NoSuchElementException: Timeout waiting for idle object
at org.apache.commons.pool.impl.GenericKeyedObjectPool.borrowObject(
at org.apache.commons.dbcp.datasources.SharedPoolDataSource.getPooledConnectionAndInfo(
... 33 more
2016-08-10 21:03:31,736 ERROR [GrcExecutorThread-11115] ControlAnalysisJob:521 Error occured during analysis
at oracle.apps.grc.dataservices.dao.impl.spring.access.AccessDaoSpr.findAccessByIdAsNode(
at oracle.apps.grc.dataservices.util.ReasonerFilterUtil.convertToModifiersId(
at oracle.apps.grc.dataservices.util.ReasonerFilterUtil.convertToModifiers(
at oracle.apps.grc.dataservices.util.ReasonerFilterUtil.convertToModifiers(
at a.a.a.a.a.a(SourceFile:161)
at oracle.apps.grc.appservices.job.analysis.ControlAnalysisJob.runGrccControls(SourceFile:653)
at oracle.apps.grc.appservices.job.analysis.ControlAnalysisJob.runJob(SourceFile:477)
at oracle.apps.grc.common.executor.GrcExecutor$
2016-08-10 21:03:31,736 ERROR [GrcExecutorThread-11115] AbstractJob:436 JobExecutionException for job [jobName=ID_94, jobId=77253, jobRunId=31799, jobStatus=STARTED, jobType=CONTROL_ANALYSIS]
2016-08-10 21:03:31,736 ERROR [GrcExecutorThread-11115] AbstractJob:437 SCHDR Error occurred in concrete job implementation
oracle.apps.grc.common.job.JobExecutionException: Error occured during analysis

We brought down the application, restarted the database, and brought the application back up. After application initialization the jobs started running successfully again. I will be attaching related log files shortly.

Steps to reproduce:

Schedule batches of controls to run daily. There are around 132 scheduled CA jobs.

Business Impact:
Due to this issue, users cannot rely on the scheduled CA jobs.


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

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