GRC 8.x : ETL Sync Failing - Terminating Synchronization: file not found: %%SCEN_LOADACCESSDATA Version 001.xml (Doc ID 2321926.1)

Last updated on SEPTEMBER 26, 2023

Applies to:

Symptoms

On :  8.6.6.7 version, Install, Migration, Upgrade

When attempting run the ETL Sync
the following error occurs.

ERROR
-----------------------
2017-10-26 19:34:04,370 ERROR [Thread-89] OdiSettings:1082 Terminating Synchronization: file not found: /WEB-INF/classes/META-INF/etl/etlsrc/ebs/jobs/SCEN_LOADACCESSDATA Version 001.xml
2017-10-26 19:34:04,370 DEBUG [Thread-90] EtlService:739 ETL progress monitor thread started.
2017-10-26 19:34:04,371 ERROR [Thread-89] EtlService:705 Exception in AsyncOdiTransformationService
oracle.apps.grc.dataservices.exception.DataServiceException: Terminating Synchronization: scenario not found
at oracle.apps.grc.dataaccessfacade.etl.OdiTransaction.execute(OdiTransaction.java:166)
at oracle.apps.grc.dataaccessfacade.EtlService$EtlExecutionThread.run(EtlService.java:702)
2017-10-26 19:34:04,870 INFO  [ExecutorThread-7] OdiSyncConnector:71 OdiSyncConnector().synchronize(): setting progress handler to finished.
2017-10-26 19:34:04,874 DEBUG [ExecutorThread-7] EtlSubJob:287 END OF AACG ETL
2017-10-26 19:34:04,874 ERROR [ExecutorThread-7] EtlSubJob:290 Access Sync Failed - Tcg Etl will be skipped
oracle.apps.grc.dataservices.exception.DataServiceException: Terminating Synchronization: scenario not found
at oracle.apps.grc.dataaccessfacade.etl.OdiTransaction.execute(OdiTransaction.java:166)
at oracle.apps.grc.dataaccessfacade.EtlService$EtlExecutionThread.run(EtlService.java:702)
2017-10-26 19:34:04,875 ERROR [ExecutorThread-7] EtlSubJob:322 Error occured in EtlJob
oracle.apps.odin.domain.job.JobExecutionException: oracle.apps.grc.dataservices.exception.DataServiceException: Terminating Synchronization: scenario not found
at oracle.apps.grc.appservices.EtlSubJob.runSubJob(EtlSubJob.java:314)



STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Upgrade the GRC to 8.6.6.700
2. Upgrade the Weblogic to 12.1.3
3. Start the Application Server
4. Run the ETL Sync Access ( Setup and Administration > Manage Application Datasource > select the Datasource  > Action)

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot  run the ETL Sync Access sucessfully

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.