My Oracle Support Banner

ORA-01000: Maximum Open Cursors Exceeded when trying to get a list of Partner Contacts (Doc ID 399714.1)

Last updated on JULY 26, 2019

Applies to:

Oracle Partner Management - Version 11.5.10.0 to 11.5.10.2 [Release 11.5.10]
Information in this document applies to any platform.

Symptoms

When trying to get a list of Partner Contacts the following error is encountered:

java.sql.SQLException: ORA-01000: maximum open cursors exceeded
java.sql.SQLException: ORA-01000: maximum open cursors exceeded at
oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:134) at
oracle.jdbc.ttc7.TTIoer.processError(TTIoer.java:289) at
oracle.jdbc.ttc7.Oopen.receive(Oopen.java:120) at
oracle.jdbc.ttc7.TTC7Proto .open(TTC7Protocol.java:614) at
oracle.jdbc.driver.OracleStatement.open(OracleStatement.java:582) at
oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:2888) at oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:650) at
oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:578) at
oracle.apps.pv.partner.PrtnrCntSumryVO.load(PrtnrCntSumryVO.java:312) at
oracle.apps.asf.webbean.TableWebBean.retrieveData(TableWebBean.java:743) at
oracle.apps.asf.webbean.WebBeanHandler.retrieveData(WebBeanHandler.java:306) at
_oa__html._pvxPrtnrCntSumryMain._jspService(_pvxPrtnrCntSumryMain.java:1288) at
oracle.jsp.runtime.HttpJsp.service(HttpJsp.java:119) at
oracle.jsp.app.JspApplication.dispatchRequest(JspApplication.java:417) at
oracle.jsp.JspServlet.doDispatch(JspServlet.java:267) at
oracle.jsp.JspServlet.internalService(JspServlet.java:186) at
oracle.jsp.JspServlet.service(JspServlet.java:156) at
javax.servlet.http.HttpServlet.service(HttpServlet.java:588) at
oracle.jsp.provider.Jsp20RequestDispatcher.forward(Jsp20RequestDispatcher.java:162) at oracle.jsp.runtime.OraclePageContext.forward(OraclePageContext.java:187)at _oa__html._pvxPrtnrCntSumryMain._jspService(_pvxPrtnrCntSumryMain.java:830) at oracle.jsp.runtime.HttpJsp.service(HttpJsp.java:119) at
oracle.jsp.app.JspApplication.dispatchRequest(JspApplication.java:417) at
oracle.jsp.JspServlet.doDispatch(JspServlet.java:267) at
oracle.jsp.JspServlet.internalService(JspServlet.java:186) at
oracle.jsp.JspServlet.service(JspServlet.java:156) at
javax.servlet.http.HttpServlet.service(HttpServlet.java:588) at
org.apache.jserv.JServConnection.processRequest(JServConnection.java:456) at
org.apache.jserv.JServConnection.run(JServConnection.java:294) at
java.lang.Thread.run(Thread.java:534)



Steps to reproduce the problem are:

the above error is encountered

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

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