ETCG 8.6.4.600: TCG ETL (Transaction Synchronization) fails for Model Using Supplier Site Location Business Object with Error 'Error occured in TcgEtlJob oracle.apps.grc.domain.exception.GraphException: Verification failed' (Doc ID 1557037.1)

Last updated on AUGUST 10, 2015

Applies to:

Oracle Transaction Controls Governor - Version 8.6.4 and later
Information in this document applies to any platform.

Symptoms

On : 8.6.4.6169 version, Application Access Contr. Gov.

When attempting to Run TCG ETL for Model having Supplier Site Location BO
the following error occurs.

ERROR in grc.log file
-----------------------
187 duplicated rows for attribute: [Attribute : http://www.oracle.com/grcc/map/ebs_r12/ONTOLOGY/payables.owl/NODE/SupplierSiteLocation_vs_864500_864600/ATTRIBUTE/lastUpdatedByName].
Attribute: [Attribute : http://www.oracle.com/grcc/map/ebs_r12/ONTOLOGY/payables.owl/NODE/SupplierSiteLocation_vs_864500_864600/ATTRIBUTE/lastUpdatedByName] has 7255 rows in raw, which is greater than the total row count from Berkeley: 7069.
187 duplicated rows for attribute: [Attribute : http://www.oracle.com/grcc/map/ebs_r12/ONTOLOGY/payables.owl/NODE/SupplierSiteLocation_vs_864500_864600/ATTRIBUTE/lastUpdatedOn].
Attribute: [Attribute : http://www.oracle.com/grcc/map/ebs_r12/ONTOLOGY/payables.owl/NODE/SupplierSiteLocation_vs_864500_864600/ATTRIBUTE/lastUpdatedOn] has 7255 rows in raw, which is greater than the total row count from Berkeley: 7069.

2013-03-24 09:25:52,303 DEBUG [GrcExecutorThread-7] TcgEtlSortingService:336 Verification Finished.
2013-03-24 09:25:52,303 DEBUG [GrcExecutorThread-7] TcgEtlSortingService:337 Verification Time taken:5543
2013-03-24 09:25:52,303 DEBUG [GrcExecutorThread-7] BBTGraphWriter:108 Closing BBTGraphWriter.
2013-03-24 09:25:52,305 DEBUG [GrcExecutorThread-7] PagingGrccChannelManager:329 Closed the ChannelManager for the directory: /u01/app/oracle/product/Middleware/TCG_ETL/raw/en_US
2013-03-24 09:25:52,305 DEBUG [GrcExecutorThread-7] BerkeleyService:131 Flushing Berkeley DB...
2013-03-24 09:25:52,343 DEBUG [GrcExecutorThread-7] BerkeleyBOTableService:263 Flushing Berkeley BO Table DB...
2013-03-24 09:25:52,374 ERROR [GrcExecutorThread-7] TcgEtlJob:421 Error occured in TcgEtlJob
oracle.apps.grc.domain.exception.GraphException: Verification failed.
    at oracle.apps.grc.reasonerio.berkeley.TcgEtlSortingService.sort(TcgEtlSortingService.java:339)
      
STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Login to Application.

2. Create a TCG Model using Supplier Site Location BO.

3. Action->Synchronize.
 

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Not able to build model using Supplier Site Location BO.

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