My Oracle Support Banner

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

Last updated on OCTOBER 28, 2019

Applies to:

Oracle Financial Services Data Integration Hub - Version 8.0.7 and later
Information in this document applies to any platform.
Oracle Financial Services Analytical Applications (OFSAA)

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

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


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