My Oracle Support Banner

DIH ADI Refresh is failing in 8.1.0.1.0 (Doc ID 2777006.1)

Last updated on MAY 23, 2021

Applies to:

Oracle Financial Services Data Integration Hub - Version 8.1.0.1.0 and later
Information in this document applies to any platform.

Symptoms

ADI refresh is failing and we can see the below error in the ADI.log file.

[08-04-21 16:49:02.347][INFO ] [ADIRefreshUtils][generateADIList]Retrieving the column list for Table - [STG_WRITEOFF_REASON_MASTER]
[08-04-21 16:49:02.375][INFO ] [ADIRefreshUtils][generateADIList]Retrieving the column list for Table - [STG_WRITEOFF_REASON_MASTER_MLS]
[08-04-21 16:49:02.400][INFO ] [ADIRefresh][trigger]Retrieving application mapping for ADI
[08-04-21 16:49:18.551][INFO ] [ADIRefresh][trigger]Generating new references for ADI
[08-04-21 16:49:18.562][ERROR] [ADIRefresh][trigger]Error occurred while generating id's for ADI list
java.lang.Exception: Error occurred while generating id's for ADI list
at com.ofss.fsgbu.dihref.util.ADIRefreshUtils.geneRateNewReferences(ADIRefreshUtils.java:645) ~[dih-adiref.jar:8.1.0.1.1_10376223977845]
at com.ofss.fsgbu.dihref.impl.ADIRefresh.trigger(ADIRefresh.java:131) [dih-adiref.jar:8.1.0.1.1_10376223977845]
at com.ofs.reveleus.DIH.rest.service.Refresh$2.run(Refresh.java:88) [dih.jar:8.1.0.1.0_10376220982968]
at java.lang.Thread.run(Thread.java:748) [?:1.8.0_281]
Caused by: java.lang.Exception: Error occurred while getting DBsequence
at com.ofss.fsgbu.dihref.util.ADIRefreshUtils.getDBSequence(ADIRefreshUtils.java:689) ~[dih-adiref.jar:8.1.0.1.1_10376223977845]
at com.ofss.fsgbu.dihref.util.ADIRefreshUtils.geneRateNewReferences(ADIRefreshUtils.java:604) ~[dih-adiref.jar:8.1.0.1.1_10376223977845]
... 3 more
Caused by: java.sql.SQLException: Could not rollback with auto-commit set on
at oracle.jdbc.driver.PhysicalConnection.rollback(PhysicalConnection.java:2219) ~[ojdbc8.jar:19.3.0.0.0]
at org.apache.tomcat.dbcp.dbcp2.DelegatingConnection.rollback(DelegatingConnection.java:477) ~[tomcat-dbcp.jar:9.0.43]
at org.apache.tomcat.dbcp.dbcp2.DelegatingConnection.rollback(DelegatingConnection.java:477) ~[tomcat-dbcp.jar:9.0.43]
at com.ofss.fsgbu.dihcore.utils.QueryRunnerUtils.executeBatchUpdate(QueryRunnerUtils.java:89) ~[dih-core.jar:8.1.0.1.1_10376223977845]
at com.ofss.fsgbu.dihref.util.ADIRefreshUtils.getDBSequence(ADIRefreshUtils.java:687) ~[dih-adiref.jar:8.1.0.1.1_10376223977845]
at com.ofss.fsgbu.dihref.util.ADIRefreshUtils.geneRateNewReferences(ADIRefreshUtils.java:604) ~[dih-adiref.jar:8.1.0.1.1_10376223977845]
... 3 more
[08-04-21 16:49:18.566][INFO ] [ADIRefreshUtils][getVersionId]Version ID [0]
[08-04-21 16:49:18.566][INFO ] [ADIRefreshUtils][updateAuditLog]Update audit log

Changes

 

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
Changes
Cause
Solution
References


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