ADI Refresh Failed
(Doc ID 2903011.1)
Last updated on OCTOBER 20, 2022
Applies to:
Oracle Financial Services Data Integration Hub - Version 8.1.1.1 and laterInformation in this document applies to any platform.
Symptoms
On DIH 8.1.1.1 version, ADI refresh failed
ADI_131.log
Relevant Information Collection
---------------------------------------
[04-10-22 18:58:19.805][INFO ] [ADIRefresh][trigger]Create Revisions
[04-10-22 18:58:28.001][ERROR] [ADIRefresh][trigger]Error occurred while creating revisions
java.lang.Exception: Error occurred while creating revisions
at com.ofss.fsgbu.dihref.util.ADIRefreshUtils.createRevisions(ADIRefreshUtils.java:957) ~[dih-adiref.jar:8.1.1.1.0_10401241287277]
at com.ofss.fsgbu.dihref.impl.ADIRefresh.trigger(ADIRefresh.java:142) [dih-adiref.jar:8.1.1.1.0_10401241287277]
at com.ofs.reveleus.DIH.rest.service.Refresh$2.run(Refresh.java:88) [dih.jar:8.1.1.1.0_10401241287277]
at java.lang.Thread.run(Thread.java:748) [?:1.8.0_202]
Caused by: java.sql.SQLException: java.sql.SQLException: ORA-04063: view "INFODF.INFODOM_NAME_V" has errors
at com.ofs.reveleus.global.db.utils.QueryRunner.executeUpdate(QueryRunner.java:295) ~[CommonPlatform.jar:?]
at com.ofss.fsgbu.dihcore.utils.QueryRunnerUtils.excuteUpdate(QueryRunnerUtils.java:36) ~[dih-core.jar:8.1.1.1.0_10401241287277]
at com.ofss.fsgbu.dihref.util.ADIRefreshUtils.createRevisions(ADIRefreshUtils.java:952) ~[dih-adiref.jar:8.1.1.1.0_10401241287277]
... 3 more
Caused by: java.sql.SQLException: ORA-04063: view "INFODF.INFODOM_NAME_V" has errors
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 |