My Oracle Support Banner

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 FEBRUARY 01, 2018

Applies to:

Oracle Application Access Controls Governor - Version 8.6.4 and later
Information 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!


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.