"ORA-01000 Maximum Open Cursors Exceeded" While Trying to Calculate Allocations
(Doc ID 2092333.1)
Last updated on JUNE 06, 2017
Applies to:
Oracle Retail Allocation - Version 13.2 and laterInformation in this document applies to any platform.
Symptoms
Allocation calculation fails with the following exception:
2015-06-18 11:24:17,252 ERROR com.retek.alloc.utils.AllocException (?:?) -
java.sql.SQLException: ORA-01000: maximum open cursors exceeded
at oracle.jdbc.driver.OracleStatementWrapper.executeQuery(OracleStatementWrapper.java:389)
at com.retek.alloc.db.alc.AlcQueueProcessExtDao.selectAllocIdFromQueue(AlcQueueProcessExtDao.java:144)
at com.retek.alloc.service.QueueProcessService.findAndRemoveNextQueueEntry(QueueProcessService.java:75)
at com.retek.alloc.queue.QueueProcess.run(QueueProcess.java:49)
at java.lang.Thread.run(Thread.java:662)
java.sql.SQLException: ORA-01000: maximum open cursors exceeded
at oracle.jdbc.driver.OracleStatementWrapper.executeQuery(OracleStatementWrapper.java:389)
at com.retek.alloc.db.alc.AlcQueueProcessExtDao.selectAllocIdFromQueue(AlcQueueProcessExtDao.java:144)
at com.retek.alloc.service.QueueProcessService.findAndRemoveNextQueueEntry(QueueProcessService.java:75)
at com.retek.alloc.queue.QueueProcess.run(QueueProcess.java:49)
at java.lang.Thread.run(Thread.java:662)
Steps to Reproduce:
- Create and calculate Allocations using multiple users.
- Over a period the number of open cursors in database accumulates.
- Once the open cursors reach the maximum open cursor count set, the allocation calculation fails.
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 |
| References |