You need to sign in to do that
Don't have an account?
SFORCE Error Generated during Update Call
I received the following error mesage when I attempted to run a batch update for a custom field on 130 opportunity records. Updates were successful for records 1-89, but 90-130 failed with the following message. Any help would be greatly appreciated!
Andrew
java.sql.SQLException: ORA-01000: maximum open cursors exceeded
ORA-06512: at "BUILD136R3A.CDOCUMENT", line 1024
ORA-06512: at line 1
SQLException while executing plsql statement: cDocument.get_related_file_list(00X30000000dhh8)
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:125)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:305)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:272)
at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:623)
at oracle.jdbc.driver.T4CCallableStatement.doOall8(T4CCallableStatement.java:180)
at oracle.jdbc.driver.T4CCallableStatement.execute_for_rows(T4CCallableStatement.java:783)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1028)
at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:2888)
at oracle.jdbc.driver.OraclePreparedStatement.execute(OraclePreparedStatement.java:2979)
at oracle.jdbc.driver.OracleCallableStatement.execute(OracleCallableStatement.java:4103)
at common.util.ProtectedConnection$ProtectedCallableStatementImpl.execute(ProtectedConnection.java:883)
at sun.reflect.GeneratedMethodAccessor18.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:324)
at common.util.ProtectedConnection$ProtectedCallableStatementImpl.invoke(ProtectedConnection.java:743)
at $Proxy0.execute(Unknown Source)
at system.plsql.CDocument.getRelatedFileList(CDocument.java:659)
at core.email.tools.TemplateReplace.updateBodyWithTemplate(TemplateReplace.java:387)
at common.cache.data.ActionEmailInfo.invoke(ActionEmailInfo.java:182)
at common.udd.object.WorkFlowController.executeWorkFlowImpl(WorkFlowController.java:494)
at common.udd.object.WorkFlowController.executeWorkFlow(WorkFlowController.java:433)
at common.udd.object.WorkFlowController.executeWorkFlow(WorkFlowController.java:422)
at common.udd.object.EntityObject.executeWorkflowInternal(EntityObject.java:1486)
at common.udd.object.EntityObject.postCommit(EntityObject.java:1260)
at common.udd.object.EntityObject.save(EntityObject.java:1071)
at common.udd.object.ApiEntityObject.apiSave(ApiEntityObject.java:875)
at common.udd.object.EntityObject.apiSave(EntityObject.java:2383)
at common.api.soap.Soap.save(Soap.java:304)
at common.api.soap.Soap.update(Soap.java:221)
at sun.reflect.GeneratedMethodAccessor133.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:324)
at org.apache.axis.providers.java.RPCProvider.invokeMethod(RPCProvider.java:402)
at org.apache.axis.providers.java.RPCProvider.processMessage(RPCProvider.java:309)
at common.api.soap.SProvider.processMessage(SProvider.java:81)
at org.apache.axis.providers.java.JavaProvider.invoke(JavaProvider.java:333)
at org.apache.axis.strategies.InvocationStrategy.visit(InvocationStrategy.java:71)
at org.apache.axis.SimpleChain.doVisiting(SimpleChain.java:150)
at org.apache.axis.SimpleChain.invoke(SimpleChain.java:120)
at org.apache.axis.handlers.soap.SOAPService.invoke(SOAPService.java:481)
at org.apache.axis.server.AxisServer.invoke(AxisServer.java:323)
at org.apache.axis.transport.http.AxisServlet.doPost(AxisServlet.java:854)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:165)
at org.apache.axis.transport.http.AxisServletBase.service(AxisServletBase.java:339)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:103)
at com.caucho.server.dispatch.ServletFilterChain.doFilter(ServletFilterChain.java:113)
at shared.filter.SoapPostGzipFilter.doFilter(SoapPostGzipFilter.java:25)
at com.caucho.server.dispatch.FilterFilterChain.doFilter(FilterFilterChain.java:84)
at com.caucho.filters.GzipFilter.doFilter(GzipFilter.java:176)
at com.caucho.server.dispatch.FilterFilterChain.doFilter(FilterFilterChain.java:84)
at system.filter.SoapPreGzipFilter.doFilter(SoapPreGzipFilter.java:46)
at com.caucho.server.dispatch.FilterFilterChain.doFilter(FilterFilterChain.java:84)
at system.filter.PreGzipFilter.doFilter(PreGzipFilter.java:75)
at com.caucho.server.dispatch.FilterFilterChain.doFilter(FilterFilterChain.java:84)
at com.caucho.server.cache.CacheFilterChain.doFilter(CacheFilterChain.java:190)
at com.caucho.server.webapp.WebAppFilterChain.doFilter(WebAppFilterChain.java:177)
at com.caucho.server.dispatch.ServletInvocation.service(ServletInvocation.java:221)
at com.caucho.server.http.HttpRequest.handleRequest(HttpRequest.java:263)
at com.caucho.server.port.TcpConnection.run(TcpConnection.java:323)
at com.caucho.util.ThreadPool.runTasks(ThreadPool.java:430)
at com.caucho.util.ThreadPool.run(ThreadPool.java:377)
at java.lang.Thread.run(Thread.java:534)
Do you still get this error?
Just received it again. It happened on the same record count as the previous. See below for error this round.
java.sql.SQLException: ORA-01000: maximum open cursors exceeded
ORA-06512: at "BUILD136R3B.CDOCUMENT", line 1024
ORA-06512: at line 1
SQLException while executing plsql statement: cDocument.get_related_file_list(00X30000000dhh8)
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:125)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:305)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:272)
at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:623)
at oracle.jdbc.driver.T4CCallableStatement.doOall8(T4CCallableStatement.java:180)
at oracle.jdbc.driver.T4CCallableStatement.execute_for_rows(T4CCallableStatement.java:783)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1028)
at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:2888)
at oracle.jdbc.driver.OraclePreparedStatement.execute(OraclePreparedStatement.java:2979)
at oracle.jdbc.driver.OracleCallableStatement.execute(OracleCallableStatement.java:4103)
at common.util.ProtectedConnection$ProtectedCallableStatementImpl.execute(ProtectedConnection.java:883)
at sun.reflect.GeneratedMethodAccessor21.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:324)
at common.util.ProtectedConnection$ProtectedCallableStatementImpl.invoke(ProtectedConnection.java:743)
at $Proxy0.execute(Unknown Source)
at system.plsql.CDocument.getRelatedFileList(CDocument.java:659)
at core.email.tools.TemplateReplace.updateBodyWithTemplate(TemplateReplace.java:387)
at common.cache.data.ActionEmailInfo.invoke(ActionEmailInfo.java:182)
at common.udd.object.WorkFlowController.executeWorkFlowImpl(WorkFlowController.java:494)
at common.udd.object.WorkFlowController.executeWorkFlow(WorkFlowController.java:433)
at common.udd.object.WorkFlowController.executeWorkFlow(WorkFlowController.java:422)
at common.udd.object.EntityObject.executeWorkflowInternal(EntityObject.java:1486)
at common.udd.object.EntityObject.postCommit(EntityObject.java:1260)
at common.udd.object.EntityObject.save(EntityObject.java:1071)
at common.udd.object.ApiEntityObject.apiSave(ApiEntityObject.java:875)
at common.udd.object.EntityObject.apiSave(EntityObject.java:2383)
at common.api.soap.Soap.save(Soap.java:304)
at common.api.soap.Soap.update(Soap.java:221)
at sun.reflect.GeneratedMethodAccessor148.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:324)
at org.apache.axis.providers.java.RPCProvider.invokeMethod(RPCProvider.java:402)
at org.apache.axis.providers.java.RPCProvider.processMessage(RPCProvider.java:309)
at common.api.soap.SProvider.processMessage(SProvider.java:81)
at org.apache.axis.providers.java.JavaProvider.invoke(JavaProvider.java:333)
at org.apache.axis.strategies.InvocationStrategy.visit(InvocationStrategy.java:71)
at org.apache.axis.SimpleChain.doVisiting(SimpleChain.java:150)
at org.apache.axis.SimpleChain.invoke(SimpleChain.java:120)
at org.apache.axis.handlers.soap.SOAPService.invoke(SOAPService.java:481)
at org.apache.axis.server.AxisServer.invoke(AxisServer.java:323)
at org.apache.axis.transport.http.AxisServlet.doPost(AxisServlet.java:854)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:165)
at org.apache.axis.transport.http.AxisServletBase.service(AxisServletBase.java:339)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:103)
at com.caucho.server.dispatch.ServletFilterChain.doFilter(ServletFilterChain.java:113)
at shared.filter.SoapPostGzipFilter.doFilter(SoapPostGzipFilter.java:25)
at com.caucho.server.dispatch.FilterFilterChain.doFilter(FilterFilterChain.java:84)
at com.caucho.filters.GzipFilter.doFilter(GzipFilter.java:176)
at com.caucho.server.dispatch.FilterFilterChain.doFilter(FilterFilterChain.java:84)
at system.filter.SoapPreGzipFilter.doFilter(SoapPreGzipFilter.java:46)
at com.caucho.server.dispatch.FilterFilterChain.doFilter(FilterFilterChain.java:84)
at system.filter.PreGzipFilter.doFilter(PreGzipFilter.java:75)
at com.caucho.server.dispatch.FilterFilterChain.doFilter(FilterFilterChain.java:84)
at com.caucho.server.cache.CacheFilterChain.doFilter(CacheFilterChain.java:190)
at com.caucho.server.webapp.WebAppFilterChain.doFilter(WebAppFilterChain.java:177)
at com.caucho.server.dispatch.ServletInvocation.service(ServletInvocation.java:221)
at com.caucho.server.http.HttpRequest.handleRequest(HttpRequest.java:263)
at com.caucho.server.port.TcpConnection.run(TcpConnection.java:323)
at com.caucho.util.ThreadPool.runTasks(ThreadPool.java:430)
at com.caucho.util.ThreadPool.run(ThreadPool.java:377)
at java.lang.Thread.run(Thread.java:534)
I think you are hitting a bug related to bulk updates firing workflow.
I've filed a bug, we'll work on fixing this asap.