EGRC 8.6.5.1616: On Weblogic, Access ETL/Synchronization Is Failing With "ODI-1240: Flow TCG_INTR_Users_21 fails" OR "ODI-1240: Flow TCG_INTR_Users_22 fails" Error. (Doc ID 1643404.1)

Last updated on MARCH 08, 2017

Applies to:

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

Symptoms

On : 8.6.5.1616 version, Application Access Control Governor: Synchronization

AACG is used to report segregation of duties(SOD) in the business applications. When attempting to run Access ETL for R12.2 Datasource the following error occurs.

ERROR
-----------------------
2014-04-02 16:51:05,100 DEBUG [GrcExecutorThread-7] TcgOdiSessionMonitor:53 *** Monitoring started for session with id: 7154
2014-04-02 16:51:05,278 DEBUG [SimpleAsyncTaskExecutor-1] Log4jPrintStream:71 STDOUT (oracle.core.ojdl.logging.ConsoleHandler:118)

2014-04-02 16:51:05,280 DEBUG [SimpleAsyncTaskExecutor-1] Log4jPrintStream:71 STDOUT (oracle.core.ojdl.logging.ConsoleHandler:118) ODI-1226: Step TCG_INTR_Users_21 fails after 1 attempt(s).
Caused by: ODI-1240: Flow TCG_INTR_Users_21 fails while performing a Integration operation. This flow loads target table Users.
Caused by: org.apache.bsf.BSFException: exception from Jython:
Traceback (innermost last):
  File "", line 3, in ?
ImportError: cannot import name EtlExtractorFactory

OR

2015-05-12 16:34:06,987 DEBUG [SimpleAsyncTaskExecutor-1] Log4jPrintStream:71 STDOUT (oracle.core.ojdl.logging.ConsoleHandler:118) <May 12, 2015 4:34:06 PM CDT> <Warning> <Default> <ODI-1134> <Agent Internal encountered an error: ODI-1226: Step TCG_INTR_Users_22 fails after 1 attempt(s).>

2015-05-12 16:34:07,029 DEBUG [SimpleAsyncTaskExecutor-1] Log4jPrintStream:71 STDOUT (oracle.core.ojdl.logging.ConsoleHandler:118) <May 12, 2015 4:34:06 PM CDT> <Error> <Default> <ODI-1217> <Session TCG_SCEN_USERS_22 (28154) fails with return code 7000.
ODI-1226: Step TCG_INTR_Users_22 fails after 1 attempt(s).
Caused by: ODI-1240: Flow TCG_INTR_Users_22 fails while performing a Integration operation. This flow loads target table Users.
Caused by: org.apache.bsf.BSFException: exception from Jython:
Traceback (innermost last):
File "<string>", line 3, in ?
ImportError: cannot import name EtlExtractorFactory



STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Install EGRC 8.6.5 using WLS 12.1.2.
2. Define R12.2 Datasource in EGRC Application.
3. Action->Access Synchronization.
4. Wait for Job to complete, Job errors at very end when it does User BO sync.

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot run Access Synchronization and subsequent control analysis. As Synchronization is first step to use application, users are not able to proceed with Application.

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