EGRC 8.6.x: Access Sychronization Fails with 'ODI-10182: Uncategorized exception during repository access.' Error.
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.
On : 22.214.171.12450 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.
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
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.
The issue has the following business impact:
Due to this issue, users cannot run Access Synchronization.
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