GRC 8.6.5 7000 Oracle.apps.grc.common.job.JobExecutionException: Error Occured During Analysis (Doc ID 2076100.1)

Last updated on MAY 17, 2017

Applies to:

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

Symptoms

On : In Application Access Controls Governor (AACG) GRC-all-8.6.5.7119 version,

AACG is used to report segregation of duties(SOD) in the business applications. When attempting to run control analysis,
the following error occurs.

ERROR
-----------------------
015-10-26 16:45:35,205 DEBUG [pool-2-thread-29] PeriodicCheckMonitorStrategy:89 SCHDR Job ID 6411 is ERRORED
2015-10-26 16:45:35,206 DEBUG [pool-1-thread-1] JobStatusMonitor:192 SCHDR notify listeners for job subjob [jobName=GrccModelReasoningJob_243, jobId=6411, jobRunId=16376, jobStatus=ERRORED, jobType=MODEL_REASONING_JOB] with status ERRORED
2015-10-26 16:45:35,206 DEBUG [pool-1-thread-1] JobExecutionMaster:264 SCHDR Job is removed from constraints: subjob [jobName=GrccModelReasoningJob_243, jobId=6411, jobRunId=16376, jobStatus=ERRORED, jobType=MODEL_REASONING_JOB] with status ERRORED
2015-10-26 16:45:35,206 ERROR [GrcExecutorThread-35] ControlAnalysisJob:504 Error occured during Analysis
oracle.apps.grc.domain.exception.ReasonerException: Error occured while persisting into berkeley db.
at a.a.a.g.e.n.run(SourceFile:178)
at a.a.a.e.a.executeSimply(SourceFile:132)
at a.a.a.e.c.a.a(SourceFile:394)
at a.a.a.e.c.a.runSubJob(SourceFile:273)
at oracle.apps.grc.scheduler.job.AbstractSubJob.run(SourceFile:163)
at oracle.apps.grc.common.executor.GrcExecutor$GrcRunnable.run(GrcExecutor.java:185)
at java.lang.Thread.run(Thread.java:722)
 

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Run scheduled control analysis
2. The job fails and the logs show the above error

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot complete control analysis.

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