User Provisioning Job Fails CAN_NOT_RUN_ANALYSIS_DUE_TO_ETL_FAILURE (Doc ID 1539290.1)

Last updated on APRIL 01, 2016

Applies to:

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

Symptoms

On :   8.6.4.4220 version, Application Access Contr. Gov.

When attempting to run user provisioning job
the following error occurs.

ERROR
-----------------------
AsyncOdiTransformationService:220 getProgressPercentage :0.0%
2012-12-07 16:41:30,000 DEBUG [SimpleAsyncTaskExecutor-1] Log4jPrintStream:70 STDOUT (oracle.core.ojdl.logging.ConsoleHandler:118) ODI-1226: Step WF_LOCAL_ROLES_table_exists fails after 1 attempt(s).
Caused by: ODI-1228: Task WF_LOCAL_ROLES_table_exists (Variable) fails on the target connection physical_schema_src.
Caused by: java.sql.SQLRecoverableException: IO Error: The Network Adapter could not establish the connection
at com.sunopsis.dwg.dbobj.SnpSessStep.treatStepTaskError(SnpSessStep.java:1005)

............................................................


ProvisioningJob:417 Starting the provisioning analysis for prevent controls
2012-12-07 17:09:10,657 DEBUG [Thread-63] ProvisioningJob:423 Starting the provisioning analysis for approval required controls
2012-12-07 17:09:10,661 WARN  [Thread-63] DataSourceDaoSpr:221 Locale Key was null in UserPreferences will set to default
2012-12-07 17:09:10,664 DEBUG [Thread-63] DataSourceDaoSpr:250 Loaded 4 from the cache.
PreAnalysisJobValidationService:290 Pre-Analysis data validation failed with following errors:
2012-12-07 17:09:10,675 ERROR [Thread-63] PreAnalysisJobValidationService:296 Error Code: CAN_NOT_RUN_ANALYSIS_DUE_TO_ETL_FAILURE Karsan Test
2012-12-07 17:09:10,676 ERROR [Thread-63] ProvisioningJob:453 Error occured during Analysis
oracle.apps.grc.domain.exception.ReasonerException: Cannot run ProvisioningJob because of an Error.

 JobTerminationMonitor:59 set status for oracle.apps.grc.appservices.job.analysis.ProvisioningJob@eba5807 id 953 ERRORED
2012-12-07 17:09:11,351 ERROR [ProvRequestAnalysisRunner] ProvisioningRequestAnalyzer:342 Error occured during analysis
java.lang.RuntimeException: Error occured during analysis:
at oracle.apps.grc.appservices.provisioning.ProvisioningRequestAnalyzer.analyzeProvisionedTriples(SourceFile:334)


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. create a user, assign a resp in EBS and start initiate conflict analysis.
 

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Cannot define users and test control rules.

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