My Oracle Support Banner

EGRC 8.6.5.x: All Control Analysis Jobs Going To Queued Status, Log Shows "ORA-00001: unique constraint (GRC.GRC_INC_CTRL_2526_PK) violated" Error (Doc ID 2098549.1)

Last updated on MARCH 08, 2017

Applies to:

Oracle Application Access Controls Governor - Version 8.6.5 to 8.6.5 [Release 8]
Information in this document applies to any platform.

Symptoms

On : 8.6.5 version, Application Access Contr. Gov.

In Oracle Application Access Controls Governor (AACG), models and controls define conflicts among duties that can be assigned in a company’s applications, and identify users who have access to those conflicting duties.
AACG can also implement “preventive analysis” — it can evaluate controls as duties are assigned to users of the company’s applications, preventing them from gaining risky access.

ACTUAL BEHAVIOR
---------------
All control Analysis job are going in queue.

EXPECTED BEHAVIOR
-----------------------
If no other job is running next job submitted should go in started state.

Error in grc.log:
--------------
2015-12-29 11:54:41,319 ERROR [GrcExecutorThread-70] AbstractDaoSpr:537 Error while executing SQL statement.
org.springframework.dao.DataIntegrityViolationException: PreparedStatementCallback; SQL [UPDATE GRC_INC_CTRL_2526 SET LAST_RUN_DATE = (SELECT LAST_RUN_DATE FROM GRC_CTRL_CCM_CONTROL_VL WHERE ID = 2526)]; ORA-00001: unique constraint (GRC.GRC_INC_CTRL_2526_PK) violated
; nested exception is java.sql.SQLIntegrityConstraintViolationException: ORA-00001: unique constraint (GRC.GRC_INC_CTRL_2526_PK) violated

at org.springframework.jdbc.support.SQLErrorCodeSQLExceptionTranslator.doTranslate(SQLErrorCodeSQLExceptionTranslator.java:228)
at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:72)

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Submit CA job.
2. Check the Job status.

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

Cause

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
Symptoms
Cause
Solution


This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process and therefore has not been subject to an independent technical review.
My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.