EGRC 8.6.5.x: Unable To Create Transaction Controls, Controls are not Getting Saved. (Doc ID 1986483.1)

Last updated on MARCH 08, 2017

Applies to:

Oracle Transaction Controls Governor - Version 8.6.5 and later
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, Business Objects

In Oracle Enterprise Transaction Controls Governor (ETCG), models and controls specify circumstances under which individual transactions display evidence of error, fraud, or other risk

ACTUAL BEHAVIOR
---------------
Not able to see created TCG Controls.

EXPECTED BEHAVIOR
-----------------------
Should be able to see created TCG Controls.

Error in grc.log file:
--------------------------
2015-02-25 11:39:10,430 ERROR [http-bio-8080-exec-3] AbstractDaoSpr:393 Batch insert failed for table GRC_CTRL_CCM_CONTROL_B
org.springframework.jdbc.UncategorizedSQLException: PreparedStatementCallback; uncategorized SQLException for SQL [ insert into GRC_CTRL_CCM_CONTROL_B ( CREATED_BY, CREATION_DATE, PRIORITY, TYPE, ENFORCEMENT_TYPE, REVISION_NUMBER, ID, LAST_RUN_DATE, LATEST_JOB_ID, STATUS, QUERY, QUERY_NAME, UPDATED_BY_NAME,LAST_UPDATED_BY,LAST_UPDATE_LOGIN, LAST_UPDATE_DATE,ONTOLOGY_VERSION,INVESTIGATOR_IDS,DATASOURCE_IDS, RESULT_TYPE) values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)]; SQL state [72000]; error code [1691]; ORA-01691: unable to extend lob segment AACGTCG.SYS_LOB0000081973C00022$$ by 128 in tablespace GRC_DATA
; nested exception is java.sql.BatchUpdateException: ORA-01691: unable to extend lob segment AACGTCG.SYS_LOB0000081973C00022$$ by 128 in tablespace GRC_DATA

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Navigator > Continuous Control Management > Manage Controls
2. Actions > Create Transaction Control
3. Highlight TCG Model from list.
4. Click Next.
5. Priority = 1, Status = Active, Datasource = , Result Type = Incident
6. Submit
7. Manage Controls page reappears
8. Query for controls with Type = Transaction
9. Control created not shown in list of controls

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot create TCG controls.

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