ETCG 8.6.4.7000 (8.6.4.7181) : Transaction Synchronization Fails with 'Nodes with duplicate errors' and 'Node Failed twice' (Doc ID 2030606.1)

Last updated on AUGUST 10, 2015

Applies to:

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

Symptoms

On : 8.6.4.7000 (8.6.4.7181)  version, 

When attempting to run Transaction Symchronization,
the following error occurs.

ERROR
-----------------------
* Error Report For Locale - en_US
************************************
547 duplicated rows for attribute: [Attribute : http://www.oracle.com/grcc/map/ebs_r12/ONTOLOGY/accessprovisioning.owl/NODE/User_vs_864500_864600/ATTRIBUTE/ebsResAssAppID].
1421 duplicated rows for attribute: [Attribute : http://www.oracle.com/grcc/map/ebs_r12/ONTOLOGY/accessprovisioning.owl/NODE/User_vs_864500_864600/ATTRIBUTE/ebsResAssRspID].
Attribute: [Attribute : http://www.oracle.com/grcc/map/ebs_r12/ONTOLOGY/accessprovisioning.owl/NODE/User_vs_864500_864600/ATTRIBUTE/ebsResAssRspID] has 2503 rows in raw, which is greater than the total row count from Berkeley: 1807.

2015-07-02 13:41:27,204 DEBUG [GrcExecutorThread-25] TcgEtlSortingService:374 Verification time taken: 150587ms
2015-07-02 13:41:27,204 ERROR [GrcExecutorThread-25] TcgEtlSortingService:376 Verification failed.
2015-07-02 13:41:27,205 DEBUG [GrcExecutorThread-25] TcgEtlJobUtil:1154 Nodes with duplicate errors: {[DataSource:id=41, name=PROD,type=R12,version=R12]=[[Node:http://www.oracle.com/grcc/business/ONTOLOGY/accessprovisioning.owl/NODE/User_vs_864500_864600, Type: DEFAULT ]]}
2015-07-02 13:41:27,205 DEBUG [GrcExecutorThread-25] BerkeleyService:131 Flushing Berkeley DB...
2015-07-02 13:41:27,392 ERROR [GrcExecutorThread-25] TcgEtlJob:421 Error occured in TcgEtlJob
oracle.apps.grc.common.job.JobExecutionException: Node Failed twice: [Node:http://www.oracle.com/grcc/business/ONTOLOGY/accessprovisioning.owl/NODE/User_vs_864500_864600, Type: DEFAULT ] for Datasource: [DataSource:id=41, name=PROD,type=R12,version=R12]
at oracle.apps.grc.appservices.TcgEtlJob.runETLService(SourceFile:730)
at oracle.apps.grc.appservices.TcgEtlJob.runJob(SourceFile:410)
at oracle.apps.grc.scheduler.job.AbstractJob.run(SourceFile:381)
at oracle.apps.grc.common.executor.GrcExecutor$GrcRunnable.run(GrcExecutor.java:185)
at java.lang.Thread.run(Thread.java:722)

2015-07-02 13:41:27,877 DEBUG [GrcExecutorThread-25] DataSourceDaoSpr:2208 Updating datasource with id: 41 Access Sync Status: 3847: COMPLETED
2015-07-02 13:41:27,878 DEBUG [GrcExecutorThread-25] DataSourceDaoSpr:2226 Updating datasource with id: 41 Tcg Sync Status: 3849: ERRORED


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1.Navigate to Setup and Administration > Manage Application Datasources.
2. Select the datasource.
3. Click on Actions > Synchronize Transaction.
4. Review job in Manage Jobs.

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot complete Transaction Synchronization.

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