ADI Refresh Gets 'Error occured while creating ADI Repo' and 'ORA-01000: maximum open cursors exceeded' (Doc ID 2531909.1)

Last updated on JANUARY 31, 2025

Applies to:

Symptoms

In Oracle Financial Services Data Integration Hub (DIH) 8.0.7, when attempting to run 'Refresh ADI', you get the error below in the ADI_xxx.log:

[12-04-19 19:58:01.647][ERROR] [ADIRefresh][trigger]Error occured while creating ADI Repo
java.lang.Exception: Error occured while creating ADI Repo
       at com.ofss.fsgbu.dihref.impl.ADIRefresh.createADIRepoForInfodom(ADIRefresh.java:64) ~[dih-adiref.jar:8.0.7.0.0_10175164299212]
       at com.ofss.fsgbu.dihref.impl.ADIRefresh.trigger(ADIRefresh.java:122) [dih-adiref.jar:8.0.7.0.0_10175164299212]
       at com.ofs.reveleus.DIH.rest.service.Refresh$ADIRefreshPooling.run(Refresh.java:226) [dih.jar:8.0.7.0.0_10175164299212]
       at com.ofs.reveleus.DIH.rest.service.Refresh$1.run(Refresh.java:77) [dih.jar:8.0.7.0.0_10175164299212]
       at com.ibm.ws.asynchbeans.J2EEContext$RunProxy.run(J2EEContext.java:267) [com.ibm.ws.runtime.jar:?]
       at java.security.AccessController.doPrivileged(AccessController.java:594) [?:1.8.0-internal]
       at com.ibm.ws.asynchbeans.J2EEContext.run(J2EEContext.java:1165) [com.ibm.ws.runtime.jar:?]
       at com.ibm.ws.asynchbeans.WorkWithExecutionContextImpl.go(WorkWithExecutionContextImpl.java:199) [com.ibm.ws.runtime.jar:?]
       at com.ibm.ws.asynchbeans.CJWorkItemImpl.run(CJWorkItemImpl.java:236) [com.ibm.ws.runtime.jar:?]
       at java.lang.Thread.run(Thread.java:785) [?:1.8.0-internal]
Caused by: java.lang.Exception: Error occured while creating Attributes
       at com.ofss.fsgbu.dihref.util.ColumnsAttrUtils.createAttr(ColumnsAttrUtils.java:195) ~[dih-adiref.jar:8.0.7.0.0_10175164299212]
       at com.ofss.fsgbu.dihref.impl.ADIRefresh.createADIRepoForInfodom(ADIRefresh.java:60) ~[dih-adiref.jar:8.0.7.0.0_10175164299212]
       ... 9 more
Caused by: java.lang.Exception: Error occured while executing batch
       at com.ofss.fsgbu.dihcore.utils.QueryRunnerUtils.executeBatchUpdate(QueryRunnerUtils.java:135) ~[dih-core.jar:8.0.7.0.0_10175164299212]
       at com.ofss.fsgbu.dihref.util.ColumnsAttrUtils.createAttr(ColumnsAttrUtils.java:188) ~[dih-adiref.jar:8.0.7.0.0_10175164299212]
       at com.ofss.fsgbu.dihref.impl.ADIRefresh.createADIRepoForInfodom(ADIRefresh.java:60) ~[dih-adiref.jar:8.0.7.0.0_10175164299212]
       ... 9 more
Caused by: java.sql.BatchUpdateException: ORA-01000: maximum open cursors exceeded

Cause

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