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 MARCH 03, 2017

Applies to:

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

Symptoms

On all-8.6.5.4045

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

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(DataSourceUtils.java:82)


Caused by: java.util.NoSuchElementException: Timeout waiting for idle object
at org.apache.commons.pool.impl.GenericKeyedObjectPool.borrowObject(GenericKeyedObjectPool.java:827)
at org.apache.commons.dbcp.datasources.SharedPoolDataSource.getPooledConnectionAndInfo(SharedPoolDataSource.java:165)
... 33 more
2016-08-10 21:03:31,736 ERROR [GrcExecutorThread-11115] ControlAnalysisJob:521 Error occured during analysis
java.lang.NullPointerException
at oracle.apps.grc.dataservices.dao.impl.spring.access.AccessDaoSpr.findAccessByIdAsNode(AccessDaoSpr.java:194)
at oracle.apps.grc.dataservices.util.ReasonerFilterUtil.convertToModifiersId(ReasonerFilterUtil.java:518)
at oracle.apps.grc.dataservices.util.ReasonerFilterUtil.convertToModifiers(ReasonerFilterUtil.java:233)
at oracle.apps.grc.dataservices.util.ReasonerFilterUtil.convertToModifiers(ReasonerFilterUtil.java:188)
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.scheduler.job.AbstractJob.run(SourceFile:391)
at oracle.apps.grc.common.executor.GrcExecutor$GrcRunnable.run(GrcExecutor.java:185)
at java.lang.Thread.run(Thread.java:745)
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.

Cause

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms