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 OCTOBER 10, 2023
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
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
Symptoms |
Cause |
Solution |
References |