GRCC 8.6: Datasource Sync Errors On 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***


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

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(
at com.sunopsis.dwg.dbobj.SnpSessStep.treatStepTaskError(
at com.sunopsis.dwg.dbobj.SnpSessStep.treatAttachedTasks(
at com.sunopsis.dwg.dbobj.SnpSessStep.treatSessStep(
at com.sunopsis.dwg.dbobj.SnpSession.treatSession(
at com.sunopsis.dwg.dbobj.SnpSession.treatSession(
at oracle.odi.runtime.agent.processor.impl.StartScenRequestProcessor$2.doAction(
at oracle.odi.core.persistence.dwgobject.DwgObjectTemplate.execute(
at oracle.odi.runtime.agent.processor.impl.StartScenRequestProcessor.doProcessStartScenTask(
at oracle.odi.runtime.agent.processor.impl.StartScenRequestProcessor$StartScenTask.doExecute(
at oracle.odi.runtime.agent.processor.task.AgentTask.execute(

The issue can be reproduced at will with the following steps:
1. Login to GRCC 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

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


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