function readOnly(count){ }
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
+ Start a Discussion
ASmithASmith 

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)

benjasikbenjasik
It looks like this was a temporary problem on our database server.

Do you still get this error?
ASmithASmith

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)

benjasikbenjasik
Thanks,

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.