GRC Control Analysis Job Failing Or Stuck (Doc ID 2101398.1)

Last updated on FEBRUARY 04, 2016

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) 8.6.5.9500

AACG is used to report segregation of duties(SOD) in the business applications. Control Analysis is failing for all controls with the following error in the grc.log file.

ERROR
-----------------------
2016-01-26 19:17:23,197 ERROR [GrcExecutorThread-9] PreAnalysisJobValidationService:376 Error Code: CAN_NOT_RUN_ANALYSIS_DUE_TO_ETL_FAILURE_USER_BO -
2016-01-26 19:17:23,198 ERROR [GrcExecutorThread-9] ControlAnalysisJob:504 Error occured during Analysis
oracle.apps.grc.domain.exception.ReasonerException: Cannot run ControlAnalysisJob because of an Error.
  at oracle.apps.grc.appservices.job.analysis.ControlAnalysisJob.runJob(SourceFile:480)
  at oracle.apps.grc.scheduler.job.AbstractJob.run(SourceFile:390)
  at oracle.apps.grc.common.executor.GrcExecutor$GrcRunnable.run(GrcExecutor.java:185)
  at java.lang.Thread.run(Thread.java:745)
2016-01-26 19:17:23,198 ERROR [GrcExecutorThread-9] ControlAnalysisJob:511 Error Codes :
2016-01-26 19:17:23,198 ERROR [GrcExecutorThread-9] ControlAnalysisJob:515 Error Code: CAN_NOT_RUN_ANALYSIS_DUE_TO_ETL_FAILURE_USER_BO
2016-01-26 19:17:23,201 ERROR [GrcExecutorThread-9] AbstractJob:435 JobExecutionException for job [jobName=Customer Bank Details v Write-Offs, jobId=1073, jobRunId=433, jobStatus=STARTED, jobType=CONTROL_ANALYSIS]
2016-01-26 19:17:23,201 ERROR [GrcExecutorThread-9] AbstractJob:436 SCHDR Error occurred in concrete job implementation

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Login to GRC
2. CCM > manage Controls
3. Select a control
4. Run
5. The control analysis job fails and the error reported above is seen in the log


BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot run synchronization or control analysis job

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