ETCG 8.6.3.x: Transaction Synchronization TCGETL Fails After Upgrade To 8.6.3.4000 with Error 'Error occured in TcgEtlJob oracle.apps.grc.domain.exception.GraphException: Verification failed' (Doc ID 1390377.1)

Last updated on AUGUST 10, 2015

Applies to:

Oracle Transaction Controls Governor - Version 8.6.3 to 8.6.3 [Release 8]
Information in this document applies to any platform.

Symptoms


=== ODM Issue Clarification ===
On : Oracle Enterprise Transaction Controls Governor (ETCG) version 8.6.3.4000: Oracle Enterprise Transaction Controls Governor (ETCG) evaluates transaction risk in Oracle E-Business Suite and PeopleSoft Enterprise.
Unable to synchronize TCG from the data source page. The Access data synchronization works without issue. TCG sync fails after upgrade to 8.6.3.4000

When attempting to run global ETCG synch, the following error occurs.

ERROR
-----------------------
oracle.apps.grc.common.job.JobExecutionException:Error occured during
analysis

Error in grc.log

Triple:
http://www.oracle.com/grcc/ONTOLOGY/CrossOntology/TRIPLE/Customer_map-common.owl#mapAttributeToColumn_COL_HZ_ORGANIZATION_PROFILES.MISSION_STATEMENT_76885_vs_863_8632000 is EMPTY.
2011-11-09 14:47:43,927 ERROR [http-8080-6] JobServiceImpl:374
ProgressManager error: java.lang.NullPointerException
2011-11-09 14:47:53,560 ERROR [pool-3-thread-1] TcgEtlSortingService:298
2011-11-09 14:47:53,560 DEBUG [pool-3-thread-1] TcgEtlSortingService:149
Verification Finished.
2011-11-09 14:47:53,561 DEBUG [pool-3-thread-1] TcgEtlSortingService:150
Verification Time taken:161005
2011-11-09 14:47:53,561 ERROR [pool-3-thread-1] TcgEtlJob:562 Error occured
in TcgEtlJob
oracle.apps.grc.domain.exception.GraphException: Verification failed.
at
oracle.apps.grc.appservices.TcgEtlSortingService.sort(SourceFile:152)
at oracle.apps.grc.appservices.TcgEtlJob.runJob(SourceFile:528)
at
oracle.apps.grc.scheduler.job.AbstractJob.run(AbstractJob.java:349)
at
java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.jav
a:886)
at
java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:90
8)
at java.lang.Thread.run(Thread.java:662)
2011-11-09 14:47:53,562 DEBUG [pool-3-thread-1] PagingGrccChannelManager:329
Closed the ChannelManager for the directory:
/u01/oracle/grc_transaction_ETL/raw/en_US
2011-11-09 14:48:11,088 ERROR [http-8080-6] JobServiceImpl:374
ProgressManager error: java.lang.NullPointerException
2011-11-09 14:48:11,180 ERROR [pool-3-thread-1] AbstractJob:370 Error
occurred in concrete job implementation
oracle.apps.grc.common.job.JobExecutionException: Error occured during
analysis
at oracle.apps.grc.appservices.TcgEtlJob.runJob(SourceFile:565)
at
oracle.apps.grc.scheduler.job.AbstractJob.run(AbstractJob.java:349)
at
java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.jav
a:886)
at
java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:90
8)
at java.lang.Thread.run(Thread.java:662)
Caused by: oracle.apps.grc.domain.exception.GraphException: Verification
failed.
at
oracle.apps.grc.appservices.TcgEtlSortingService.sort(SourceFile:152)

Steps to Reproduce
--------------------
1. Login to GRCC as admin user.
2. Navigate to Administration Management --> Manage Application Data
3. Select and highlight the datasource : eg: R12.1.3
4. Click Synchronize --> Run Now --> Transaction
5. Go to Navigator --> Jobs and Scheduling --> Manage Jobs
6. Job Name = TCGETL, Status = Errored, Message:
oracle.apps.grc.common.job.JobExecutionException:Error occured suring
analysis


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