GRC 8.6.4.5000 DataSource Synchronization Jobs Error Out With "ORA-01653: unable to extend table GRC.SNP_EXP_TXT by 128 in tablespace GRC"
(Doc ID 1947179.1)
Last updated on OCTOBER 10, 2023
Applies to:
Oracle Application Access Controls Governor - Version 8.6.4 and laterInformation in this document applies to any platform.
Symptoms
On : 8.6.4 version, Setup & Administration
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.
When attempting to run ETL Sync, the following error occurs.
ERROR
-----------------------
Caused by: oracle.odi.core.exception.OdiRuntimeException: com.sunopsis.dwg.SQLWorkReposException: ORA-01653: unable to extend table GRC.SNP_EXP_TXT by 128 in tablespace GRC
at oracle.odi.impexp.support.ImportServiceImpl$7.doAction(ImportServiceImpl.java:497)
at oracle.odi.core.persistence.dwgobject.DwgObjectTemplate.execute(DwgObjectTemplate.java:224)
STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Login to the AACG
2. Navigate to navigator > Setup and Administration
3. Click on Manage Application Data Source
4. Select a DataSource and Run Access Sync
BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot perform the successful ETL Sync and use the data for the business purpose.
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 |
References |