GRCC 8.6: Datasource Sync Errors On 11.5.10.2 Datasource (Doc ID 1293758.1)

Last updated on MARCH 08, 2017

Applies to:

Oracle Application Access Controls Governor - Version 8.6 and later
Information in this document applies to any platform.
***Checked for relevance on 29-MAY-2013***

Symptoms

After fresh install of AACG 8.6, When attempting to synchronize an EBS 11.5.10.2 data source it is failing after 7%, the following error occurs.

ERROR
-----------------------
2011-01-25 05:37:52,365 DEBUG [Thread-33] OdiSessionMonitor:100 *** step #: 13
2011-01-25 05:37:52,366 DEBUG [Thread-33] OdiSessionMonitor:102 *** start time: Tue Jan 25 05:37:39 IST 2011
2011-01-25 05:37:52,366 DEBUG [Thread-33] OdiSessionMonitor:104 *** end time: Tue Jan 25 05:37:51 IST 2011
2011-01-25 05:37:52,366 DEBUG [Thread-33] OdiSessionMonitor:106 *** duration: 12
2011-01-25 05:37:52,366 DEBUG [Thread-33] OdiSessionMonitor:108 *** status: ERROR
2011-01-25 05:37:52,367 DEBUG [Thread-33] OdiSessionMonitor:110 *** insert count: 0
2011-01-25 05:37:52,367 DEBUG [Thread-33] OdiSessionMonitor:112 *** record count: 0
2011-01-25 05:37:52,367 DEBUG [Thread-33] OdiSessionMonitor:114 *** error count: 0
2011-01-25 05:37:52,388 DEBUG [Thread-33] OdiSessionMonitor:116 *** error message: ODI-1226: Step Execution of the Scenario LOADACCESSDATACORE version 001 fails after 1 attempt(s).
ODI-1241: Oracle Data Integrator tool execution fails.
at com.sunopsis.dwg.dbobj.SnpSessTaskSqlS.getExceptionOnStepTaskFailure(SnpSessTaskSqlS.java:53)
at com.sunopsis.dwg.dbobj.SnpSessStep.treatStepTaskError(SnpSessStep.java:995)
at com.sunopsis.dwg.dbobj.SnpSessStep.treatAttachedTasks(SnpSessStep.java:546)
at com.sunopsis.dwg.dbobj.SnpSessStep.treatSessStep(SnpSessStep.java:449)
at com.sunopsis.dwg.dbobj.SnpSession.treatSession(SnpSession.java:1954)
at com.sunopsis.dwg.dbobj.SnpSession.treatSession(SnpSession.java:1818)
at oracle.odi.runtime.agent.processor.impl.StartScenRequestProcessor$2.doAction(StartScenRequestProcessor.java:559)
at oracle.odi.core.persistence.dwgobject.DwgObjectTemplate.execute(DwgObjectTemplate.java:224)
at oracle.odi.runtime.agent.processor.impl.StartScenRequestProcessor.doProcessStartScenTask(StartScenRequestProcessor.java:481)
at oracle.odi.runtime.agent.processor.impl.StartScenRequestProcessor$StartScenTask.doExecute(StartScenRequestProcessor.java:1040)
at oracle.odi.runtime.agent.processor.task.AgentTask.execute(AgentTask.java:114)
at oracle.odi.runtime.agent.support.DefaultAgentTaskExecutor$2.run(DefaultAgentTaskExecutor.java:82)
at java.lang.Thread.run(Thread.java:662)


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Login to GRCC 8.6.0.203 Application
2. Navigate to Manage Application Data
3. Select the Datasource and submit ETL/Sync
4. Monitor the progress and check the grcc.log file

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Can not proceed with implementation.

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