EGRC 8.6.x: Access Sychronization Fails with 'ODI-10182: Uncategorized exception during repository access.' Error. (Doc ID 2010889.1)

Last updated on MARCH 08, 2017

Applies to:

Oracle Application Access Controls Governor - Version 8.6.3 and later
Information in this document applies to any platform.

Symptoms

On : 8.6.5.6050 version, Application Access Contr. Gov.

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 Access ETL,
the following error occurs.

ERROR
-----------------------
2015-04-24 11:15:03,958 DEBUG [Thread-86] RepositoryUtils$WorkRepositoryInfoQuery:342 RdbmsOperation with SQL [select REP_SHORT_ID, REP_NAME, REP_TYPE, REP_TIMESTAMP, REP_VERSION, MIN_EXE_VERSION, IND_INSTALL_OK from SNP_LOC_REPW] compiled
2015-04-24 11:15:04,013 ERROR [Thread-86] OdiInstanceManager:206 Caught exception while connecting to ODI Repositories
oracle.odi.core.config.WorkRepositoryResourceFailureException: ODI-10182: Uncategorized exception during repository access.
Could not get JDBC Connection; nested exception is java.sql.SQLException: Exception occurred while getting connection: oracle.ucp.UniversalConnectionPoolException: Cannot get Connection from Datasource: java.sql.SQLRecoverableException: IO Error: The Network Adapter could not establish the connection
at oracle.odi.core.repository.Repository.getWorkRepository(Repository.java:195)
at oracle.odi.core.OdiInstance.createWorkRepository(OdiInstance.java:531)
at oracle.odi.core.OdiInstance.(OdiInstance.java:678)


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Login in Application.
2. Navigate to Manage Application Datasource page, select the datasource and run Access Synchronization.
3. Check the Job under Manage Job page.

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot run Access Synchronization.

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