topic hibernate operation:could not execute query using scroll? in Alfresco Archive https://connect.hyland.com/t5/alfresco-archive/hibernate-operation-could-not-execute-query-using-scroll/m-p/229792#M182922 <HTML><HEAD></HEAD><BODY><SPAN>Hi,</SPAN><BR /><BR /><SPAN>I am using alfresco 3.2r on windows 2003 server with Tomcat 6 &amp; jdk 1.6.At odd times, i am getting this strange error on my explorer web client:</SPAN><BR /><BR /><BLOCKQUOTE class="jive-quote">A system error happened during the operation: Hibernate operation: could not execute query using scroll; uncategorized SQLException for SQL [select childassoc0_.id as col_0_0_, childassoc0_.type_qname_id as col_1_0_, childassoc0_.qname_ns_id as col_2_0_, childassoc0_.qname_localname as col_3_0_, childassoc0_.qname_crc as col_4_0_, childassoc0_.child_node_name as col_5_0_, childassoc0_.child_node_name_crc as col_6_0_, childassoc0_.is_primary as col_7_0_, childassoc0_.assoc_index as col_8_0_, nodeimpl1_.id as col_9_0_, storeimpl2_.protocol as col_10_0_, storeimpl2_.identifier as col_11_0_, nodeimpl1_.uuid as col_12_0_ from alf_child_assoc childassoc0_ inner join alf_node nodeimpl1_ on childassoc0_.child_node_id=nodeimpl1_.id inner join alf_store storeimpl2_ on nodeimpl1_.store_id=storeimpl2_.id where childassoc0_.parent_node_id=? and (nodeimpl1_.type_qname_id in (? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ?)) order by childassoc0_.assoc_index, childassoc0_.id]; SQL state [HY000]; error code [3]; Error writing file 'C:\WINDOWS\TEMP\MY9546.tmp' (Errcode: 28); nested exception is java.sql.SQLException: Error writing file 'C:\WINDOWS\TEMP\MY9546.tmp' (Errcode: 28)</BLOCKQUOTE><BR /><SPAN>While checking on server console, i can see error as below.</SPAN><BR /><BR /><PRE class="language-none line-numbers"><CODE><BR />02:53:01,108 ERROR [org.alfresco.web.ui.common.Utils] A system error happened during the operation: Hibernate operation: could not execute query using scroll; uncategorized SQLException for SQL [select childassoc0_.id as col_0_0_, childassoc0_.type_qname_id as col_1_0_, childassoc0_.qname_ns_id as col_2_0_, childassoc0_.qname_localname as col_3_0_, childassoc0_.qname_crc as col_4_0_, childassoc0_.child_node_name as col_5_0_, childassoc0_.child_node_name_crc as col_6_0_, childassoc0_.is_primary as col_7_0_, childassoc0_.assoc_index as col_8_0_, nodeimpl1_.id as col_9_0_, storeimpl2_.protocol as col_10_0_, storeimpl2_.identifier as col_11_0_, nodeimpl1_.uuid as col_12_0_ from alf_child_assoc childassoc0_ inner join alf_node nodeimpl1_ on childassoc0_.child_node_id=nodeimpl1_.id inner join alf_store storeimpl2_ on nodeimpl1_.store_id=storeimpl2_.id where childassoc0_.parent_node_id=? and (nodeimpl1_.type_qname_id in (? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ?)) order by childassoc0_.assoc_index, childassoc0_.id]; SQL state [HY000]; error code [3]; Error writing file 'C:\WINDOWS\TEMP\MY9546.tmp' (Errcode: 28); nested exception is java.sql.SQLException: Error writing file 'C:\WINDOWS\TEMP\MY9546.tmp' (Errcode: 28)<BR />org.springframework.jdbc.UncategorizedSQLException: Hibernate operation: could not execute query using scroll; uncategorized SQLException for SQL [select childassoc0_.id as col_0_0_, childassoc0_.type_qname_id as col_1_0_, childassoc0_.qname_ns_id as col_2_0_, childassoc0_.qname_localname as col_3_0_, childassoc0_.qname_crc as col_4_0_, childassoc0_.child_node_name as col_5_0_, childassoc0_.child_node_name_crc as col_6_0_, childassoc0_.is_primary as col_7_0_, childassoc0_.assoc_index as col_8_0_, nodeimpl1_.id as col_9_0_, storeimpl2_.protocol as col_10_0_, storeimpl2_.identifier as col_11_0_, nodeimpl1_.uuid as col_12_0_ from alf_child_assoc childassoc0_ inner join alf_node nodeimpl1_ on childassoc0_.child_node_id=nodeimpl1_.id inner join alf_store storeimpl2_ on nodeimpl1_.store_id=storeimpl2_.id where childassoc0_.parent_node_id=? and (nodeimpl1_.type_qname_id in (? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ?)) order by childassoc0_.assoc_index, childassoc0_.id]; SQL state [HY000]; error code [3]; Error writing file 'C:\WINDOWS\TEMP\MY9546.tmp' (Errcode: 28); nested exception is java.sql.SQLException: Error writing file 'C:\WINDOWS\TEMP\MY9546.tmp' (Errcode: 28)<BR />Caused by: java.sql.SQLException: Error writing file 'C:\WINDOWS\TEMP\MY9546.tmp' (Errcode: 28)<BR />&nbsp;&nbsp;&nbsp;at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1055)<BR />&nbsp;&nbsp;&nbsp;at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:956)<BR />&nbsp;&nbsp;&nbsp;at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3515)<BR />&nbsp;&nbsp;&nbsp;at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3447)<BR />&nbsp;&nbsp;&nbsp;at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1951)<BR />&nbsp;&nbsp;&nbsp;at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2101)<BR />&nbsp;&nbsp;&nbsp;at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2554)<BR />&nbsp;&nbsp;&nbsp;at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1761)<BR />&nbsp;&nbsp;&nbsp;at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:1912)<BR />&nbsp;&nbsp;&nbsp;at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:93)<BR />&nbsp;&nbsp;&nbsp;at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:93)<BR />&nbsp;&nbsp;&nbsp;at org.hibernate.jdbc.AbstractBatcher.getResultSet(AbstractBatcher.java:186)<BR />&nbsp;&nbsp;&nbsp;at org.hibernate.loader.Loader.getResultSet(Loader.java:1787)<BR />&nbsp;&nbsp;&nbsp;at org.hibernate.loader.Loader.scroll(Loader.java:2286)<BR />&nbsp;&nbsp;&nbsp;at org.hibernate.loader.hql.QueryLoader.scroll(QueryLoader.java:441)<BR />&nbsp;&nbsp;&nbsp;at org.hibernate.hql.ast.QueryTranslatorImpl.scroll(QueryTranslatorImpl.java:390)<BR />&nbsp;&nbsp;&nbsp;at org.hibernate.engine.query.HQLQueryPlan.performScroll(HQLQueryPlan.java:245)<BR />&nbsp;&nbsp;&nbsp;at org.hibernate.impl.SessionImpl.scroll(SessionImpl.java:1206)<BR />&nbsp;&nbsp;&nbsp;at org.hibernate.impl.QueryImpl.scroll(QueryImpl.java:67)<BR />&nbsp;&nbsp;&nbsp;at org.alfresco.repo.node.db.hibernate.HibernateNodeDaoServiceImpl$23.doInHibernate(HibernateNodeDaoServiceImpl.java:2745)<BR />&nbsp;&nbsp;&nbsp;at org.springframework.orm.hibernate3.HibernateTemplate.execute(HibernateTemplate.java:372)<BR />&nbsp;&nbsp;&nbsp;at org.springframework.orm.hibernate3.HibernateTemplate.execute(HibernateTemplate.java:338)<BR />&nbsp;&nbsp;&nbsp;at org.alfresco.repo.node.db.hibernate.HibernateNodeDaoServiceImpl.getChildAssocsByChildTypes(HibernateNodeDaoServiceImpl.java:2751)<BR />&nbsp;&nbsp;&nbsp;at sun.reflect.GeneratedMethodAccessor1051.invoke(Unknown Source)<BR />&nbsp;&nbsp;&nbsp;at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)<BR />&nbsp;&nbsp;&nbsp;at java.lang.reflect.Method.invoke(Method.java:597)<BR />&nbsp;&nbsp;&nbsp;at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:304)<BR />&nbsp;&nbsp;&nbsp;at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:182)<BR />&nbsp;&nbsp;&nbsp;at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:149)<BR />&nbsp;&nbsp;&nbsp;at org.alfresco.repo.transaction.TransactionalDaoInterceptor.invoke(TransactionalDaoInterceptor.java:68)<BR />&nbsp;&nbsp;&nbsp;at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)<BR />&nbsp;&nbsp;&nbsp;at org.alfresco.repo.domain.hibernate.DirtySessionMethodInterceptor.invoke(DirtySessionMethodInterceptor.java:419)<BR />&nbsp;&nbsp;&nbsp;at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)<BR />&nbsp;&nbsp;&nbsp;at org.alfresco.repo.transaction.SingleEntryTransactionResourceInterceptor.invokeInternal(SingleEntryTransactionResourceInterceptor.java:163)<BR />&nbsp;&nbsp;&nbsp;at org.alfresco.repo.transaction.SingleEntryTransactionResourceInterceptor.invoke(SingleEntryTransactionResourceInterceptor.java:138)<BR />&nbsp;&nbsp;&nbsp;at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)<BR />&nbsp;&nbsp;&nbsp;at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204)<BR />&nbsp;&nbsp;&nbsp;at $Proxy9.getChildAssocsByChildTypes(Unknown Source)<BR />&nbsp;&nbsp;&nbsp;at org.alfresco.repo.node.db.DbNodeServiceImpl.getChildAssocs(DbNodeServiceImpl.java:1814)<BR />&nbsp;&nbsp;&nbsp;at sun.reflect.GeneratedMethodAccessor389.invoke(Unknown Source)<BR />&nbsp;&nbsp;&nbsp;at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)<BR />&nbsp;&nbsp;&nbsp;at java.lang.reflect.Method.invoke(Method.java:597)<BR />&nbsp;&nbsp;&nbsp;at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:304)<BR />&nbsp;&nbsp;&nbsp;at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:182)<BR />&nbsp;&nbsp;&nbsp;at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:149)<BR />&nbsp;&nbsp;&nbsp;at org.alfresco.repo.tenant.MultiTNodeServiceInterceptor.invoke(MultiTNodeServiceInterceptor.java:110)<BR />&nbsp;&nbsp;&nbsp;at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)<BR />&nbsp;&nbsp;&nbsp;at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204)<BR />&nbsp;&nbsp;&nbsp;at $Proxy11.getChildAssocs(Unknown Source)<BR />&nbsp;&nbsp;&nbsp;at sun.reflect.GeneratedMethodAccessor389.invoke(Unknown Source)<BR />&nbsp;&nbsp;&nbsp;at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)<BR />&nbsp;&nbsp;&nbsp;at java.lang.reflect.Method.invoke(Method.java:597)<BR />&nbsp;&nbsp;&nbsp;at org.alfresco.repo.service.StoreRedirectorProxyFactory$RedirectorInvocationHandler.invoke(StoreRedirectorProxyFactory.java:221)<BR />&nbsp;&nbsp;&nbsp;at $Proxy12.getChildAssocs(Unknown Source)<BR />&nbsp;&nbsp;&nbsp;at sun.reflect.GeneratedMethodAccessor389.invoke(Unknown Source)<BR />&nbsp;&nbsp;&nbsp;at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)<BR />&nbsp;&nbsp;&nbsp;at java.lang.reflect.Method.invoke(Method.java:597)<BR />&nbsp;&nbsp;&nbsp;at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:304)<BR />&nbsp;&nbsp;&nbsp;at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:182)<BR />&nbsp;&nbsp;&nbsp;at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:149)<BR />&nbsp;&nbsp;&nbsp;at org.alfresco.repo.node.MLPropertyInterceptor.invoke(MLPropertyInterceptor.java:309)<BR />&nbsp;&nbsp;&nbsp;at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)<BR />&nbsp;&nbsp;&nbsp;at org.alfresco.repo.node.MLPropertyInterceptor.invoke(MLPropertyInterceptor.java:309)<BR />&nbsp;&nbsp;&nbsp;at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)<BR />&nbsp;&nbsp;&nbsp;at org.alfresco.repo.node.NodeRefPropertyMethodInterceptor.invoke(NodeRefPropertyMethodInterceptor.java:275)<BR />&nbsp;&nbsp;&nbsp;at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)<BR />&nbsp;&nbsp;&nbsp;at org.alfresco.repo.node.NodeRefPropertyMethodInterceptor.invoke(NodeRefPropertyMethodInterceptor.java:275)<BR />&nbsp;&nbsp;&nbsp;at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)<BR />&nbsp;&nbsp;&nbsp;at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204)<BR />&nbsp;&nbsp;&nbsp;at $Proxy11.getChildAssocs(Unknown Source)<BR />&nbsp;&nbsp;&nbsp;at org.alfresco.repo.model.filefolder.FileFolderServiceImpl.listSimple(FileFolderServiceImpl.java:509)<BR />&nbsp;&nbsp;&nbsp;at org.alfresco.repo.model.filefolder.FileFolderServiceImpl.list(FileFolderServiceImpl.java:295)<BR />&nbsp;&nbsp;&nbsp;at sun.reflect.GeneratedMethodAccessor1071.invoke(Unknown Source)<BR />&nbsp;&nbsp;&nbsp;at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)<BR />&nbsp;&nbsp;&nbsp;at java.lang.reflect.Method.invoke(Method.java:597)<BR />&nbsp;&nbsp;&nbsp;at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:304)<BR />&nbsp;&nbsp;&nbsp;at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:182)<BR />&nbsp;&nbsp;&nbsp;at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:149)<BR />&nbsp;&nbsp;&nbsp;at org.alfresco.repo.model.filefolder.TempFileMarkerInterceptor.invoke(TempFileMarkerInterceptor.java:83)<BR />&nbsp;&nbsp;&nbsp;at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)<BR />&nbsp;&nbsp;&nbsp;at org.alfresco.repo.model.ml.MLContentInterceptor.invoke(MLContentInterceptor.java:131)<BR />&nbsp;&nbsp;&nbsp;at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)<BR />&nbsp;&nbsp;&nbsp;at org.alfresco.repo.model.filefolder.MLTranslationInterceptor.invoke(MLTranslationInterceptor.java:211)<BR />&nbsp;&nbsp;&nbsp;at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)<BR />&nbsp;&nbsp;&nbsp;at net.sf.acegisecurity.intercept.method.aopalliance.MethodSecurityInterceptor.invoke(MethodSecurityInterceptor.java:80)<BR />&nbsp;&nbsp;&nbsp;at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)<BR />&nbsp;&nbsp;&nbsp;at org.alfresco.repo.security.permissions.impl.ExceptionTranslatorMethodInterceptor.invoke(ExceptionTranslatorMethodInterceptor.java:49)<BR />&nbsp;&nbsp;&nbsp;at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)<BR />&nbsp;&nbsp;&nbsp;at org.alfresco.repo.audit.AuditMethodInterceptor.proceedWithAudit(AuditMethodInterceptor.java:238)<BR />&nbsp;&nbsp;&nbsp;at org.alfresco.repo.audit.AuditMethodInterceptor.proceed(AuditMethodInterceptor.java:205)<BR />&nbsp;&nbsp;&nbsp;at org.alfresco.repo.audit.AuditMethodInterceptor.invoke(AuditMethodInterceptor.java:153)<BR />&nbsp;&nbsp;&nbsp;at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)<BR />&nbsp;&nbsp;&nbsp;at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:106)<BR />&nbsp;&nbsp;&nbsp;at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)<BR />&nbsp;&nbsp;&nbsp;at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204)<BR />&nbsp;&nbsp;&nbsp;at $Proxy68.list(Unknown Source)<BR />&nbsp;&nbsp;&nbsp;at org.alfresco.web.bean.BrowseBean.queryBrowseNodes(BrowseBean.java:905)<BR />&nbsp;&nbsp;&nbsp;at org.alfresco.web.bean.BrowseBean.getNodes(BrowseBean.java:511)<BR />&nbsp;&nbsp;&nbsp;at sun.reflect.GeneratedMethodAccessor1070.invoke(Unknown Source)<BR />&nbsp;&nbsp;&nbsp;at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)<BR />&nbsp;&nbsp;&nbsp;at java.lang.reflect.Method.invoke(Method.java:597)<BR />&nbsp;&nbsp;&nbsp;at org.apache.myfaces.el.PropertyResolverImpl.getProperty(PropertyResolverImpl.java:457)<BR />&nbsp;&nbsp;&nbsp;at org.apache.myfaces.el.PropertyResolverImpl.getValue(PropertyResolverImpl.java:85)<BR />&nbsp;&nbsp;&nbsp;at org.apache.myfaces.el.ELParserHelper$MyPropertySuffix.evaluate(ELParserHelper.java:535)<BR />&nbsp;&nbsp;&nbsp;at org.apache.commons.el.ComplexValue.evaluate(ComplexValue.java:145)<BR />&nbsp;&nbsp;&nbsp;at org.apache.myfaces.el.ValueBindingImpl.getValue(ValueBindingImpl.java:386)<BR />&nbsp;&nbsp;&nbsp;at org.alfresco.web.ui.common.component.data.UIRichList.getValue(UIRichList.java:157)<BR />&nbsp;&nbsp;&nbsp;at org.alfresco.web.ui.common.component.data.UIRichList.getDataModel(UIRichList.java:518)<BR />&nbsp;&nbsp;&nbsp;at org.alfresco.web.ui.common.component.data.UIRichList.bind(UIRichList.java:454)<BR />&nbsp;&nbsp;&nbsp;at org.alfresco.web.ui.common.renderer.data.RichListRenderer.encodeChildren(RichListRenderer.java:83)<BR />&nbsp;&nbsp;&nbsp;at javax.faces.component.UIComponentBase.encodeChildren(UIComponentBase.java:527)<BR />&nbsp;&nbsp;&nbsp;at javax.faces.webapp.UIComponentTag.encodeChildren(UIComponentTag.java:483)<BR />&nbsp;&nbsp;&nbsp;at javax.faces.webapp.UIComponentTag.doEndTag(UIComponentTag.java:364)<BR />&nbsp;&nbsp;&nbsp;at org.apache.jsp.jsp.browse.browse_jsp._jspx_meth_a_005frichList_005f0(browse_jsp.java:2697)<BR />&nbsp;&nbsp;&nbsp;at org.apache.jsp.jsp.browse.browse_jsp._jspx_meth_a_005fpanel_005f5(browse_jsp.java:2585)<BR />&nbsp;&nbsp;&nbsp;at org.apache.jsp.jsp.browse.browse_jsp._jspService(browse_jsp.java:849)<BR />&nbsp;&nbsp;&nbsp;at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70)<BR />&nbsp;&nbsp;&nbsp;at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)<BR />&nbsp;&nbsp;&nbsp;at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:374)<BR />&nbsp;&nbsp;&nbsp;at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:342)<BR />&nbsp;&nbsp;&nbsp;at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:267)<BR />&nbsp;&nbsp;&nbsp;at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)<BR />&nbsp;&nbsp;&nbsp;at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)<BR />&nbsp;&nbsp;&nbsp;at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)<BR />&nbsp;&nbsp;&nbsp;at org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.java:630)<BR />&nbsp;&nbsp;&nbsp;at org.apache.catalina.core.ApplicationDispatcher.processRequest(ApplicationDispatcher.java:436)<BR />&nbsp;&nbsp;&nbsp;at org.apache.catalina.core.ApplicationDispatcher.doForward(ApplicationDispatcher.java:374)<BR />&nbsp;&nbsp;&nbsp;at org.apache.catalina.core.ApplicationDispatcher.forward(ApplicationDispatcher.java:302)<BR />&nbsp;&nbsp;&nbsp;at org.apache.myfaces.context.servlet.ServletExternalContextImpl.dispatch(ServletExternalContextImpl.java:419)<BR />&nbsp;&nbsp;&nbsp;at org.apache.myfaces.application.jsp.JspViewHandlerImpl.renderView(JspViewHandlerImpl.java:211)<BR />&nbsp;&nbsp;&nbsp;at org.apache.myfaces.lifecycle.RenderResponseExecutor.execute(RenderResponseExecutor.java:41)<BR />&nbsp;&nbsp;&nbsp;at org.apache.myfaces.lifecycle.LifecycleImpl.render(LifecycleImpl.java:132)<BR />&nbsp;&nbsp;&nbsp;at javax.faces.webapp.FacesServlet.service(FacesServlet.java:140)<BR />&nbsp;&nbsp;&nbsp;at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)<BR />&nbsp;&nbsp;&nbsp;at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)<BR />&nbsp;&nbsp;&nbsp;at com.keembay.alfresco.web.app.servlet.CASAuthenticationFilter.doFilter(CASAuthenticationFilter.java:149)<BR />&nbsp;&nbsp;&nbsp;at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)<BR />&nbsp;&nbsp;&nbsp;at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)<BR />&nbsp;&nbsp;&nbsp;at org.alfresco.repo.web.filter.beans.NullFilter.doFilter(NullFilter.java:74)<BR />&nbsp;&nbsp;&nbsp;at sun.reflect.GeneratedMethodAccessor720.invoke(Unknown Source)<BR />&nbsp;&nbsp;&nbsp;at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)<BR />&nbsp;&nbsp;&nbsp;at java.lang.reflect.Method.invoke(Method.java:597)<BR />&nbsp;&nbsp;&nbsp;at org.alfresco.repo.management.subsystems.ChainingSubsystemProxyFactory$1.invoke(ChainingSubsystemProxyFactory.java:122)<BR />&nbsp;&nbsp;&nbsp;at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)<BR />&nbsp;&nbsp;&nbsp;at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204)<BR />&nbsp;&nbsp;&nbsp;at $Proxy220.doFilter(Unknown Source)<BR />&nbsp;&nbsp;&nbsp;at org.alfresco.repo.web.filter.beans.BeanProxyFilter.doFilter(BeanProxyFilter.java:88)<BR />&nbsp;&nbsp;&nbsp;at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)<BR />&nbsp;&nbsp;&nbsp;at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)<BR />&nbsp;&nbsp;&nbsp;at edu.yale.its.tp.cas.client.filter.CASFilter.doFilter(CASFilter.java:317)<BR />&nbsp;&nbsp;&nbsp;at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)<BR />&nbsp;&nbsp;&nbsp;at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)<BR />&nbsp;&nbsp;&nbsp;at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)<BR />&nbsp;&nbsp;&nbsp;at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)<BR />&nbsp;&nbsp;&nbsp;at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:128)<BR />&nbsp;&nbsp;&nbsp;at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)<BR />&nbsp;&nbsp;&nbsp;at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)<BR />&nbsp;&nbsp;&nbsp;at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:286)<BR />&nbsp;&nbsp;&nbsp;at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:845)<BR />&nbsp;&nbsp;&nbsp;at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:583)<BR />&nbsp;&nbsp;&nbsp;at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:447)<BR />&nbsp;&nbsp;&nbsp;at java.lang.Thread.run(Thread.java:619)<BR /><SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN></CODE></PRE><BR /><SPAN>Can anybody help!</SPAN></BODY></HTML> Thu, 07 Oct 2010 05:45:21 GMT dynamolalit 2010-10-07T05:45:21Z hibernate operation:could not execute query using scroll? https://connect.hyland.com/t5/alfresco-archive/hibernate-operation-could-not-execute-query-using-scroll/m-p/229792#M182922 Hi,I am using alfresco 3.2r on windows 2003 server with Tomcat 6 &amp; jdk 1.6.At odd times, i am getting this strange error on my explorer web client:A system error happened during the operation: Hibernate operation: could not execute query using scroll; uncategorized SQLException for SQL [select c Thu, 07 Oct 2010 05:45:21 GMT https://connect.hyland.com/t5/alfresco-archive/hibernate-operation-could-not-execute-query-using-scroll/m-p/229792#M182922 dynamolalit 2010-10-07T05:45:21Z Re: hibernate operation:could not execute query using scroll? https://connect.hyland.com/t5/alfresco-archive/hibernate-operation-could-not-execute-query-using-scroll/m-p/229793#M182923 <HTML><HEAD></HEAD><BODY><SPAN>exception is java.sql.SQLException: Error writing file 'C:\WINDOWS\TEMP\MY9546.tmp' (Errcode: 28)</SPAN><BR /><SPAN>Caused by: java.sql.SQLException: Error writing file 'C:\WINDOWS\TEMP\MY9546.tmp' (Errcode: 28)</SPAN><BR /><BR /><SPAN>Has your temp folder run out of space?</SPAN></BODY></HTML> Thu, 07 Oct 2010 08:32:42 GMT https://connect.hyland.com/t5/alfresco-archive/hibernate-operation-could-not-execute-query-using-scroll/m-p/229793#M182923 mrogers 2010-10-07T08:32:42Z Re: hibernate operation:could not execute query using scroll? https://connect.hyland.com/t5/alfresco-archive/hibernate-operation-could-not-execute-query-using-scroll/m-p/229794#M182924 <HTML><HEAD></HEAD><BODY><SPAN>Hi Mrogers,</SPAN><BR /><BR /><SPAN>Thanks for your reply.'C:\WINDOWS\TEMP' folder occupies only 60 MB but my C drive is almost full leaving only ~40 MB free out of ~50 GB of space.</SPAN><BR /><BR /><SPAN>Can this be an issue?</SPAN></BODY></HTML> Thu, 07 Oct 2010 09:33:10 GMT https://connect.hyland.com/t5/alfresco-archive/hibernate-operation-could-not-execute-query-using-scroll/m-p/229794#M182924 dynamolalit 2010-10-07T09:33:10Z Re: hibernate operation:could not execute query using scroll? https://connect.hyland.com/t5/alfresco-archive/hibernate-operation-could-not-execute-query-using-scroll/m-p/229795#M182925 <HTML><HEAD></HEAD><BODY><SPAN>Yes that will be an issue for lots of software, including windows, mysql and alfresco.</SPAN><BR /><BR /><SPAN>The "rule of thumb" I use is to keep 10 to 20% of disk free.</SPAN></BODY></HTML> Thu, 07 Oct 2010 10:47:28 GMT https://connect.hyland.com/t5/alfresco-archive/hibernate-operation-could-not-execute-query-using-scroll/m-p/229795#M182925 mrogers 2010-10-07T10:47:28Z