EGRC 8.6.5.x: All Jobs Are Being Queued And Not Run (Doc ID 2086414.1)

Last updated on MARCH 08, 2017

Applies to:

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

Symptoms

On : 8.6.5 version, Application Access Contr. Gov.

When attempting to run any job, all jobs going in queue including ETL and User Provisioning jobs,
the following error occurs noticed in grc.log file.

ERROR
-----------------------
2015-11-26 05:58:48,290 ERROR [_CLUSTERED_MisfireHandler] JobStoreTX:3892 MisfireHandler: Error handling misfires: Failed to obtain DB connection

from data source 'myDS': org.apache.commons.dbcp.SQLNestedException: Could not retrieve connection info from pool
org.quartz.JobPersistenceException: Failed to obtain DB connection from data source 'myDS': org.apache.commons.dbcp.SQLNestedException: Could not

retrieve connection info from pool [See nested exception: org.apache.commons.dbcp.SQLNestedException: Could not retrieve connection info from pool]
at org.quartz.impl.jdbcjobstore.JobStoreSupport.getConnection(JobStoreSupport.java:689)
at org.quartz.impl.jdbcjobstore.JobStoreTX.getNonManagedTXConnection(JobStoreTX.java:72)
at org.quartz.impl.jdbcjobstore.JobStoreSupport.doRecoverMisfires(JobStoreSupport.java:3108)
at org.quartz.impl.jdbcjobstore.JobStoreSupport$MisfireHandler.manage(JobStoreSupport.java:3887)
at org.quartz.impl.jdbcjobstore.JobStoreSupport$MisfireHandler.run(JobStoreSupport.java:3907)
Caused by: org.apache.commons.dbcp.SQLNestedException: Could not retrieve connection info from pool
at org.apache.commons.dbcp.datasources.SharedPoolDataSource.getPooledConnectionAndInfo(SharedPoolDataSource.java:169)
at org.apache.commons.dbcp.datasources.InstanceKeyDataSource.getConnection(InstanceKeyDataSource.java:631)
at org.apache.commons.dbcp.datasources.InstanceKeyDataSource.getConnection(InstanceKeyDataSource.java:615)
at oracle.apps.grc.scheduler.quartz.QuartzConnectionProvider.getConnection(SourceFile:56)
at org.quartz.utils.DBConnectionManager.getConnection(DBConnectionManager.java:112)
at org.quartz.impl.jdbcjobstore.JobStoreSupport.getConnection(JobStoreSupport.java:686)
... 4 more
Caused by: java.sql.SQLException: ORA-00257: archiver error. Connect internal only, until freed.


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Login to GRC.
2. Submit any job like ETL or initiate User Provisioning from EBS.
3. Monitor the job under manage jobs.

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot run any job in GRC.

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