GRC Datasource Synchronization Failed with Error: oracle.apps.grc.sdm.odi.ODIManagerRuntimeException: Scenario with id: 259154 failed - will set the job to failed. (Doc ID 2244409.1)

Last updated on MAY 02, 2017

Applies to:

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

Symptoms

On : In Application Access Controls Governor (AACG) version 8.6.6.X, Access Synchronization

AACG is used to report segregation of duties(SOD) in the business applications. Access Synchronization program ends with the following error:

ERROR
-----------------------

grc.log:

2017-03-10 14:09:15,148 DEBUG [ExecutorThread-7] DataSourceDaoSpr:1231 updateSyncState(oracle.apps.grc.domain.datasource.SourceSyncState@5d0be7bc)
2017-03-10 14:09:15,156 ERROR [ExecutorThread-7] TcgEtlJobUtil:497 Access Sync Failed
oracle.apps.grc.sdm.odi.ODIManagerRuntimeException: Scenario with id: 259154 failed - will set the job to failed.
at oracle.apps.grc.sdm.odi.OdiDataAdapter$8.sessionStatusChanged(OdiDataAdapter.java:1814)
at oracle.apps.grc.sdm.odi.TcgOdiSessionMonitor.run(TcgOdiSessionMonitor.java:290)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)
at java.lang.Thread.run(Thread.java:745)
2017-03-10 14:09:15,157 DEBUG [ExecutorThread-7] TcgEtlJobUtil:505 Removing User Model: [Model: id:559, name:Internal User Access Model (DO NOT USE) 039e5cfc-b9e6-4e12-9898-1f67d45caf13, ModelQuery [Graph=
digraph g{
Node[shape=rectangle]
subgraph cluster_0{
Source0
Sink0
1[ label = "U1:NOT_NULL(Users.userID)"]
label = "Group 0";
}
Source0->1
1->Sink0
}

017-03-10 14:09:12,124 DEBUG [ExecutorThread-7] TcgOdiSessionMonitor:53 *** Monitoring started for session with id: 259154
2017-03-10 14:09:12,332 DEBUG [SimpleAsyncTaskExecutor-1] GrcLogPrintStream:73 STDOUT (oracle.core.ojdl.logging.ConsoleHandler:118)



STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Navigate to Setup and Administration > Manage Data sources
2. Select datasource and run Synchronization Program for Access
4. The program ends with the error mentioned above

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot run data synchronization from their business 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