GRC 188.8.131.5200 DataSource Synchronization Jobs Error Out With "ORA-01653: unable to extend table GRC.SNP_EXP_TXT by 128 in tablespace GRC"
Last updated on FEBRUARY 01, 2018
Applies to:Oracle Application Access Controls Governor - Version 8.6.4 and later
Information in this document applies to any platform.
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.
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
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
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.
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