java.sql.SQLException

There are no available Samebug tips for this exception. Do you have an idea how to solve this issue? A short tip would help users who saw this issue last week.

  • 2007-10-01 09:33:19,423 [ajp-10.0.111.44-18009-1] ERROR edu.iu.uis.eden.web.WorkflowAction :: Error processing action /DocumentSearch edu.iu.uis.eden.WorkflowServiceErrorException: Error received trying to execute search: OJB operation; uncategorized SQLException for SQL []; SQL state [72000]; error code [1000]; ORA-01000: maximum open cursors ex ceeded ; nested exception is java.sql.SQLException: ORA-01000: maximum open cursors exceeded [[WorkflowServiceErrorImpl: type=docsearch.DocumentSearchService.generalError, message=Error received trying to execute search: OJB operation; uncategorized SQLException for SQL []; SQL state [72000]; error code [ 1000]; ORA-01000: maximum open cursors exceeded ; nested exception is java.sql.SQLException: ORA-01000: maximum open cursors exceeded , arg1=Error received trying to execute search: OJB operation; uncategorized SQLException for SQL []; SQL state [72000]; error code [1000]; ORA-01000: maximum open cursors exceeded ; nested exception is java.sql.SQLException: ORA-01000: maximum open cursors exceeded , arg2=null, children=[]]] at edu.iu.uis.eden.docsearch.DocumentSearchServiceImpl.getList(DocumentSearchServiceImpl.java:112) at sun.reflect.GeneratedMethodAccessor709.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:585) at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:304) at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:172) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:139) at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:107) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:161) at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:203) at $Proxy717.getList(Unknown Source) at sun.reflect.GeneratedMethodAccessor709.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:585) at org.kuali.rice.resourceloader.ContextClassLoaderProxy.invokeInternal(ContextClassLoaderProxy.java:132) at org.kuali.rice.proxy.BaseInvocationHandler.invoke(BaseInvocationHandler.java:59) at $Proxy718.getList(Unknown Source) at edu.iu.uis.eden.docsearch.web.DocumentSearchAction.doDocSearch(DocumentSearchAction.java:197) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:585) at org.apache.struts.actions.DispatchAction.dispatchMethod(DispatchAction.java:270) at edu.iu.uis.eden.web.WorkflowAction.execute(WorkflowAction.java:97) at org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:431) at org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:236) at edu.iu.uis.eden.web.StrutsRequestProcessor.process(StrutsRequestProcessor.java:55) at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1196) at org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:432) at javax.servlet.http.HttpServlet.service(HttpServlet.java:709) at javax.servlet.http.HttpServlet.service(HttpServlet.java:802) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:252) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173) at edu.iu.uis.eden.web.UserAccessFilter.doFilter(UserAccessFilter.java:66) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173) at edu.iu.uis.eden.web.UserLoginFilter.doFilter(UserLoginFilter.java:114) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173) at edu.iu.uis.eden.core.BootstrapFilterChain.doFilter(BootstrapFilter.java:306) at edu.iu.uis.cas.filter.CASFilter.doFilter(CASFilter.java:328) at sun.reflect.GeneratedMethodAccessor435.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:585) at org.kuali.rice.resourceloader.ContextClassLoaderProxy.invokeInternal(ContextClassLoaderProxy.java:132) at org.kuali.rice.proxy.BaseInvocationHandler.invoke(BaseInvocationHandler.java:59) at $Proxy690.doFilter(Unknown Source) at edu.iu.uis.eden.core.BootstrapFilterChain.doFilter(BootstrapFilter.java:299) at edu.iu.uis.eden.core.BootstrapFilter.doFilter(BootstrapFilter.java:167) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173) at org.displaytag.filter.ResponseOverrideFilter.doFilter(ResponseOverrideFilter.java:125) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:178) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:126) at org.apache.catalina.cluster.tcp.ReplicationValve.invoke(ReplicationValve.java:346) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:105) at org.apache.catalina.valves.FastCommonAccessLogValve.invoke(FastCommonAccessLogValve.java:495) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:107) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:148) at org.apache.coyote.ajp.AjpAprProcessor.process(AjpAprProcessor.java:425) at org.apache.coyote.ajp.AjpAprProtocol$AjpConnectionHandler.process(AjpAprProtocol.java:452) at org.apache.tomcat.util.net.AprEndpoint$Worker.run(AprEndpoint.java:1196) at java.lang.Thread.run(Thread.java:595) 2007-10-01 09:33:23,710 [ajp-10.0.111.44-18009-3] ERROR edu.iu.uis.eden.actionlist.web.ActionListAction :: Error loading action list. org.springframework.jdbc.UncategorizedSQLException: OJB operation; uncategorized SQLException for SQL []; SQL state [99999]; error code [12096]; ORA-12096: error in materialized view log on "EN"."EN_USR_OPTN_T" ORA-01000: maximum open cursors exceeded
    via by Eric Westfall,
  • 2007-10-01 09:33:19,423 [ajp-10.0.111.44-18009-1] ERROR edu.iu.uis.eden.web.WorkflowAction :: Error processing action /DocumentSearch edu.iu.uis.eden.WorkflowServiceErrorException: Error received trying to execute search: OJB operation; uncategorized SQLException for SQL []; SQL state [72000]; error code [1000]; ORA-01000: maximum open cursors ex ceeded ; nested exception is java.sql.SQLException: ORA-01000: maximum open cursors exceeded [[WorkflowServiceErrorImpl: type=docsearch.DocumentSearchService.generalError, message=Error received trying to execute search: OJB operation; uncategorized SQLException for SQL []; SQL state [72000]; error code [ 1000]; ORA-01000: maximum open cursors exceeded ; nested exception is java.sql.SQLException: ORA-01000: maximum open cursors exceeded , arg1=Error received trying to execute search: OJB operation; uncategorized SQLException for SQL []; SQL state [72000]; error code [1000]; ORA-01000: maximum open cursors exceeded ; nested exception is java.sql.SQLException: ORA-01000: maximum open cursors exceeded , arg2=null, children=[]]] at edu.iu.uis.eden.docsearch.DocumentSearchServiceImpl.getList(DocumentSearchServiceImpl.java:112) at sun.reflect.GeneratedMethodAccessor709.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:585) at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:304) at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:172) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:139) at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:107) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:161) at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:203) at $Proxy717.getList(Unknown Source) at sun.reflect.GeneratedMethodAccessor709.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:585) at org.kuali.rice.resourceloader.ContextClassLoaderProxy.invokeInternal(ContextClassLoaderProxy.java:132) at org.kuali.rice.proxy.BaseInvocationHandler.invoke(BaseInvocationHandler.java:59) at $Proxy718.getList(Unknown Source) at edu.iu.uis.eden.docsearch.web.DocumentSearchAction.doDocSearch(DocumentSearchAction.java:197) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:585) at org.apache.struts.actions.DispatchAction.dispatchMethod(DispatchAction.java:270) at edu.iu.uis.eden.web.WorkflowAction.execute(WorkflowAction.java:97) at org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:431) at org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:236) at edu.iu.uis.eden.web.StrutsRequestProcessor.process(StrutsRequestProcessor.java:55) at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1196) at org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:432) at javax.servlet.http.HttpServlet.service(HttpServlet.java:709) at javax.servlet.http.HttpServlet.service(HttpServlet.java:802) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:252) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173) at edu.iu.uis.eden.web.UserAccessFilter.doFilter(UserAccessFilter.java:66) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173) at edu.iu.uis.eden.web.UserLoginFilter.doFilter(UserLoginFilter.java:114) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173) at edu.iu.uis.eden.core.BootstrapFilterChain.doFilter(BootstrapFilter.java:306) at edu.iu.uis.cas.filter.CASFilter.doFilter(CASFilter.java:328) at sun.reflect.GeneratedMethodAccessor435.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:585) at org.kuali.rice.resourceloader.ContextClassLoaderProxy.invokeInternal(ContextClassLoaderProxy.java:132) at org.kuali.rice.proxy.BaseInvocationHandler.invoke(BaseInvocationHandler.java:59) at $Proxy690.doFilter(Unknown Source) at edu.iu.uis.eden.core.BootstrapFilterChain.doFilter(BootstrapFilter.java:299) at edu.iu.uis.eden.core.BootstrapFilter.doFilter(BootstrapFilter.java:167) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173) at org.displaytag.filter.ResponseOverrideFilter.doFilter(ResponseOverrideFilter.java:125) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:178) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:126) at org.apache.catalina.cluster.tcp.ReplicationValve.invoke(ReplicationValve.java:346) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:105) at org.apache.catalina.valves.FastCommonAccessLogValve.invoke(FastCommonAccessLogValve.java:495) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:107) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:148) at org.apache.coyote.ajp.AjpAprProcessor.process(AjpAprProcessor.java:425) at org.apache.coyote.ajp.AjpAprProtocol$AjpConnectionHandler.process(AjpAprProtocol.java:452) at org.apache.tomcat.util.net.AprEndpoint$Worker.run(AprEndpoint.java:1196) at java.lang.Thread.run(Thread.java:595) 2007-10-01 09:33:23,710 [ajp-10.0.111.44-18009-3] ERROR edu.iu.uis.eden.actionlist.web.ActionListAction :: Error loading action list. org.springframework.jdbc.UncategorizedSQLException: OJB operation; uncategorized SQLException for SQL []; SQL state [99999]; error code [12096]; ORA-12096: error in materialized view log on "EN"."EN_USR_OPTN_T" ORA-01000: maximum open cursors exceeded
    via by Eric Westfall,
    • java.sql.SQLException: ORA-01000: maximum open cursors exceeded , arg2=null, children=[]]] at edu.iu.uis.eden.docsearch.DocumentSearchServiceImpl.getList(DocumentSearchServiceImpl.java:112) at sun.reflect.GeneratedMethodAccessor709.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:585) at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:304) at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:172) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:139) at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:107) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:161) at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:203) at $Proxy717.getList(Unknown Source) at sun.reflect.GeneratedMethodAccessor709.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:585) at org.kuali.rice.resourceloader.ContextClassLoaderProxy.invokeInternal(ContextClassLoaderProxy.java:132) at org.kuali.rice.proxy.BaseInvocationHandler.invoke(BaseInvocationHandler.java:59) at $Proxy718.getList(Unknown Source) at edu.iu.uis.eden.docsearch.web.DocumentSearchAction.doDocSearch(DocumentSearchAction.java:197) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:585) at org.apache.struts.actions.DispatchAction.dispatchMethod(DispatchAction.java:270) at edu.iu.uis.eden.web.WorkflowAction.execute(WorkflowAction.java:97) at org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:431) at org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:236) at edu.iu.uis.eden.web.StrutsRequestProcessor.process(StrutsRequestProcessor.java:55) at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1196) at org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:432) at javax.servlet.http.HttpServlet.service(HttpServlet.java:709) at javax.servlet.http.HttpServlet.service(HttpServlet.java:802) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:252) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173) at edu.iu.uis.eden.web.UserAccessFilter.doFilter(UserAccessFilter.java:66) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173) at edu.iu.uis.eden.web.UserLoginFilter.doFilter(UserLoginFilter.java:114) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173) at edu.iu.uis.eden.core.BootstrapFilterChain.doFilter(BootstrapFilter.java:306) at edu.iu.uis.cas.filter.CASFilter.doFilter(CASFilter.java:328) at sun.reflect.GeneratedMethodAccessor435.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:585) at org.kuali.rice.resourceloader.ContextClassLoaderProxy.invokeInternal(ContextClassLoaderProxy.java:132) at org.kuali.rice.proxy.BaseInvocationHandler.invoke(BaseInvocationHandler.java:59) at $Proxy690.doFilter(Unknown Source) at edu.iu.uis.eden.core.BootstrapFilterChain.doFilter(BootstrapFilter.java:299) at edu.iu.uis.eden.core.BootstrapFilter.doFilter(BootstrapFilter.java:167) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173) at org.displaytag.filter.ResponseOverrideFilter.doFilter(ResponseOverrideFilter.java:125) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:178) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:126) at org.apache.catalina.cluster.tcp.ReplicationValve.invoke(ReplicationValve.java:346) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:105) at org.apache.catalina.valves.FastCommonAccessLogValve.invoke(FastCommonAccessLogValve.java:495) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:107) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:148) at org.apache.coyote.ajp.AjpAprProcessor.process(AjpAprProcessor.java:425) at org.apache.coyote.ajp.AjpAprProtocol$AjpConnectionHandler.process(AjpAprProtocol.java:452) at org.apache.tomcat.util.net.AprEndpoint$Worker.run(AprEndpoint.java:1196) at java.lang.Thread.run(Thread.java:595)
    No Bugmate found.