EGRC 8.6.5.x: Can Not Access Individual Incident Results. (Doc ID 2031350.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, AACG reports and Dashboards

When attempting to click on the Pending Results Count, Outcome was always message "No rows yet".
the following error occurs.

ERROR
-----------------------
2015-07-13 12:08:45,466 ERROR [el.Default (self-tuning)'] AbstractDaoSpr:502 SQL: CREATE OR REPLACE VIEW GRC_INC_CTRL_V1436803725407 AS SELECT a.*, b.NAME, b.UPDATED_BY_NAME, b.ENFORCEMENT_TYPE FROM (SELECT * FROM GRC_INC_CTRL_750 UNION ALL SELECT * FROM GRC_INC_CTRL_744 UNION ALL SELECT * FROM GRC_INC_CTRL_739 UNION ALL SELECT * FROM GRC_INC_CTRL_734 UNION ALL SELECT * FROM GRC_INC_CTRL_729 UNION ALL SELECT * FROM GRC_INC_CTRL_724 UNION ALL SELECT * FROM GRC_INC_CTRL_714 UNION ALL SELECT * FROM GRC_INC_CTRL_709 UNION ALL SELECT * FROM GRC_INC_CTRL_704 UNION ALL SELECT * FROM GRC_INC_CTRL_699 UNION ALL SELECT * FROM GRC_INC_CTRL_694 UNION ALL SELECT * FROM GRC_INC_CTRL_689 UNION ALL SELECT * FROM GRC_INC_CTRL_684 UNION ALL SELECT * FROM GRC_INC_CTRL_679 UNION ALL SELECT * FROM GRC_INC_CTRL_674 UNION ALL SELECT * FROM GRC_INC_CTRL_669 UNION ALL SELECT * FROM GRC_INC_CTRL_664 UNION ALL SELECT * FROM GRC_INC_CTRL_659 UNION ALL SELECT * FROM GRC_INC_CTRL_654 UNION ALL SELECT * FROM GRC_INC_CTRL_649 UNION ALL SELECT * FROM GRC_INC_CTRL_644 UNION ALL SELECT * FROM GRC_INC_CTRL_639 UNION ALL SELECT * FROM GRC_INC_CTRL_634 UNION ALL SELECT * FROM GRC_INC_CTRL_629 UNION ALL SELECT * FROM GRC_INC_CTRL_624 UNION ALL SELECT * FROM GRC_INC_CTRL_619 UNION ALL SELECT * FROM GRC_INC_CTRL_614 UNION ALL SELECT * FROM GRC_INC_CTRL_609 UNION ALL SELECT * FROM GRC_INC_CTRL_604 UNION ALL SELECT * FROM GRC_INC_CTRL_599 UNION ALL SELECT * FROM GRC_INC_CTRL_594 UNION ALL SELECT * FROM GRC_INC_CTRL_589 UNION ALL SELECT * FROM GRC_INC_CTRL_584 UNION ALL SELECT * FROM GRC_INC_CTRL_579 UNION ALL SELECT * FROM GRC_INC_CTRL_574 UNION ALL SELECT * FROM GRC_INC_CTRL_569 UNION ALL SELECT * FROM GRC_INC_CTRL_564 UNION ALL SELECT * FROM GRC_INC_CTRL_559 UNION ALL SELECT * FROM GRC_INC_CTRL_554 UNION ALL SELECT * FROM GRC_INC_CTRL_549 UNION ALL SELECT * FROM GRC_INC_CTRL_544 UNION ALL SELECT * FROM GRC_INC_CTRL_534 UNION ALL SELECT * FROM GRC_INC_CTRL_529 UNION ALL SELECT * FROM GRC_INC_CTRL_524 UNION ALL SELECT * FROM GRC_INC_CTRL_519 UNION ALL SELECT * FROM GRC_INC_CTRL_514 UNION ALL SELECT * FROM GRC_INC_CTRL_509 UNION ALL SELECT * FROM GRC_INC_CTRL_504 UNION ALL SELECT * FROM GRC_INC_CTRL_499 UNION ALL SELECT * FROM GRC_INC_CTRL_494 UNION ALL SELECT * FROM GRC_INC_CTRL_489 UNION ALL SELECT * FROM GRC_INC_CTRL_484 UNION ALL SELECT * FROM GRC_INC_CTRL_479 UNION ALL SELECT * FROM GRC_INC_CTRL_474 UNION ALL SELECT * FROM GRC_INC_CTRL_469 UNION ALL SELECT * FROM GRC_INC_CTRL_464 UNION ALL SELECT * FROM GRC_INC_CTRL_459 UNION ALL SELECT * FROM GRC_INC_CTRL_454 UNION ALL SELECT * FROM GRC_INC_CTRL_449 UNION ALL SELECT * FROM GRC_INC_CTRL_444 UNION ALL SELECT * FROM GRC_INC_CTRL_439 UNION ALL SELECT * FROM GRC_INC_CTRL_434 UNION ALL SELECT * FROM GRC_INC_CTRL_429 UNION ALL SELECT * FROM GRC_INC_CTRL_424 UNION ALL SELECT * FROM GRC_INC_CTRL_419 UNION ALL SELECT * FROM GRC_INC_CTRL_414 UNION ALL SELECT * FROM GRC_INC_CTRL_409 UNION ALL SELECT * FROM GRC_INC_CTRL_404) a, GRC_CTRL_CCM_CONTROL_VL b WHERE a.GRCC_CONTROL_ID = b.ID
java.sql.BatchUpdateException: error occurred during batching: ORA-00604: error occurred at recursive SQL level 1
ORA-01654: unable to extend index SYS.I_DEPENDENCY2 by 8192 in tablespace SYSTEM


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Login to Application.
2. Navigate to Manage Incident page.
3. Click on Pending Incidents link against Control Name.
4. Outcome was always message "No rows yet".

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot review the incidents.

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