ADI Refresh Failed With Error: ORA-01000: Maximum Open Cursors Exceeded (Doc ID 3000330.1)

Last updated on JANUARY 31, 2024

Applies to:

Symptoms

Steps to reproduce :

Step 1 : Perform data model adi refresh

Step 2 : Check if it is working without issue.

Issue Encountered :

Adi refresh is failing and we can see the below errors in the log file.

[03-01-24 21:54:41.046][ERROR] [ADIRefresh][trigger]Error occurred while creating Attribute & UDPValue
java.lang.Exception: Error occurred while creating Attribute & UDPValue
at com.ofss.fsgbu.dihref.util.ADIRefreshUtils.createAttrUdpVal(ADIRefreshUtils.java:1220) ~[dih-adiref.jar:8.0.7.1.0_10176179166060]
at com.ofss.fsgbu.dihref.impl.ADIRefresh.trigger(ADIRefresh.java:125) [dih-adiref.jar:8.0.7.1.0_10176179166060]
at com.ofs.reveleus.DIH.rest.service.Refresh$2.run(Refresh.java:87) [dih.jar:8.0.7.1.0_10176179166060]
at java.lang.Thread.run(Thread.java:750) [?:1.8.0_361]
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.1.0_10176179166060]
at com.ofss.fsgbu.dihref.util.ADIRefreshUtils.createAttrUdpVal(ADIRefreshUtils.java:1217) ~[dih-adiref.jar:8.0.7.1.0_10176179166060]
... 3 more
Caused by: java.sql.BatchUpdateException: ORA-01000: maximum open cursors exceeded

Changes

NA

Cause

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