topic Unable to find files in Alfresco Archive https://connect.hyland.com/t5/alfresco-archive/unable-to-find-files/m-p/181923#M135053 <HTML><HEAD></HEAD><BODY><SPAN>Hi,</SPAN><BR /><BR /><SPAN>I uploaded some files into a folder long back.</SPAN><BR /><SPAN>suddenly a exception occured and im unable to view anyone of the files present in that folder.</SPAN><BR /><BR /><SPAN>The following error occured and no files were visible in that folder ,but we are able to open folder.</SPAN><BR /><BR /><SPAN>ERROR [ui.common.Utils] A system error happened during the operation: Non-root node has no primary parent:</SPAN><BR /><SPAN>&nbsp;&nbsp; child: workspace://SpacesStore/7c0d7864-9ad2-11dd-9914-d3602a71a469</SPAN><BR /><SPAN>org.springframework.dao.DataIntegrityViolationException: Non-root node has no pr</SPAN><BR /><SPAN>imary parent:</SPAN><BR /><SPAN>&nbsp;&nbsp; child: workspace://SpacesStore/7c0d7864-9ad2-11dd-9914-d3602a71a469</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.alfresco.repo.node.db.hibernate.HibernateNodeDaoServiceImpl.getPa</SPAN><BR /><SPAN>rentAssocs(HibernateNodeDaoServiceImpl.java:1079)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.alfresco.repo.node.db.hibernate.HibernateNodeDaoServiceImpl.getPr</SPAN><BR /><SPAN>imaryParentAssoc(HibernateNodeDaoServiceImpl.java:1101)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at sun.reflect.GeneratedMethodAccessor243.invoke(Unknown Source)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAcces</SPAN><BR /><SPAN>sorImpl.java:25)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at java.lang.reflect.Method.invoke(Method.java:585)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflecti</SPAN><BR /><SPAN>on(AopUtils.java:281)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJo</SPAN><BR /><SPAN>inpoint(ReflectiveMethodInvocation.java:187)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(</SPAN><BR /><SPAN>ReflectiveMethodInvocation.java:154)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.alfresco.repo.transaction.TransactionalDaoInterceptor.invoke(Tran</SPAN><BR /><SPAN>sactionalDaoInterceptor.java:68)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(</SPAN><BR /><SPAN>ReflectiveMethodInvocation.java:176)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynami</SPAN><BR /><SPAN>cAopProxy.java:210)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at $Proxy1.getPrimaryParentAssoc(Unknown Source)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.alfresco.repo.node.db.DbNodeServiceImpl.getPrimaryParent(DbNodeSe</SPAN><BR /><SPAN>rviceImpl.java:1244)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at sun.reflect.GeneratedMethodAccessor169.invoke(Unknown Source)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAcces</SPAN><BR /><SPAN>sorImpl.java:25)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at java.lang.reflect.Method.invoke(Method.java:585)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflecti</SPAN><BR /><SPAN>on(AopUtils.java:281)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJo</SPAN><BR /><SPAN>inpoint(ReflectiveMethodInvocation.java:187)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(</SPAN><BR /><SPAN>ReflectiveMethodInvocation.java:154)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.alfresco.repo.transaction.TransactionResourceInterceptor.invoke(T</SPAN><BR /><SPAN>ransactionResourceInterceptor.java:138)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(</SPAN><BR /><SPAN>ReflectiveMethodInvocation.java:176)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynami</SPAN><BR /><SPAN>cAopProxy.java:210)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at $Proxy2.getPrimaryParent(Unknown Source)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at sun.reflect.GeneratedMethodAccessor169.invoke(Unknown Source)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAcces</SPAN><BR /><SPAN>sorImpl.java:25)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at java.lang.reflect.Method.invoke(Method.java:585)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.alfresco.repo.service.StoreRedirectorProxyFactory$RedirectorInvoc</SPAN><BR /><SPAN>ationHandler.invoke(StoreRedirectorProxyFactory.java:221)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at $Proxy3.getPrimaryParent(Unknown Source)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at sun.reflect.GeneratedMethodAccessor169.invoke(Unknown Source)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAcces</SPAN><BR /><SPAN>sorImpl.java:25)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at java.lang.reflect.Method.invoke(Method.java:585)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflecti</SPAN><BR /><SPAN>on(AopUtils.java:281)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJo</SPAN><BR /><SPAN>inpoint(ReflectiveMethodInvocation.java:187)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(</SPAN><BR /><SPAN>ReflectiveMethodInvocation.java:154)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.alfresco.repo.node.MLPropertyInterceptor.invoke(MLPropertyInterce</SPAN><BR /><SPAN>ptor.java:211)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(</SPAN><BR /><SPAN>ReflectiveMethodInvocation.java:176)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynami</SPAN><BR /><SPAN>cAopProxy.java:210)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at $Proxy2.getPrimaryParent(Unknown Source)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.alfresco.repo.security.permissions.impl.PermissionServiceImpl$Nod</SPAN><BR /><SPAN>eTest.evaluate(PermissionServiceImpl.java:744)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.alfresco.repo.security.permissions.impl.PermissionServiceImpl$Nod</SPAN><BR /><SPAN>eTest.evaluate(PermissionServiceImpl.java:733)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.alfresco.repo.security.permissions.impl.PermissionServiceImpl$Nod</SPAN><BR /><SPAN>eTest.evaluate(PermissionServiceImpl.java:670)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.alfresco.repo.security.permissions.impl.PermissionServiceImpl.has</SPAN><BR /><SPAN>Permission(PermissionServiceImpl.java:377)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.alfresco.repo.security.permissions.impl.PermissionServiceImpl.has</SPAN><BR /><SPAN>Permission(PermissionServiceImpl.java:564)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.alfresco.repo.security.permissions.impl.acegi.ACLEntryAfterInvoca</SPAN><BR /><SPAN>tionProvider.decide(ACLEntryAfterInvocationProvider.java:577)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.alfresco.repo.security.permissions.impl.acegi.ACLEntryAfterInvoca</SPAN><BR /><SPAN>tionProvider.decide(ACLEntryAfterInvocationProvider.java:224)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at net.sf.acegisecurity.afterinvocation.AfterInvocationProviderManager.d</SPAN><BR /><SPAN>ecide(AfterInvocationProviderManager.java:107)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at net.sf.acegisecurity.intercept.AbstractSecurityInterceptor.afterInvoc</SPAN><BR /><SPAN>ation(AbstractSecurityInterceptor.java:329)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at net.sf.acegisecurity.intercept.method.aopalliance.MethodSecurityInter</SPAN><BR /><SPAN>ceptor.invoke(MethodSecurityInterceptor.java:82)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(</SPAN><BR /><SPAN>ReflectiveMethodInvocation.java:176)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.alfresco.repo.security.permissions.impl.ExceptionTranslatorMethod</SPAN><BR /><SPAN>Interceptor.invoke(ExceptionTranslatorMethodInterceptor.java:49)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(</SPAN><BR /><SPAN>ReflectiveMethodInvocation.java:176)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.alfresco.repo.audit.AuditComponentImpl.auditImpl(AuditComponentIm</SPAN><BR /><SPAN>pl.java:256)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.alfresco.repo.audit.AuditComponentImpl.audit(AuditComponentImpl.j</SPAN><BR /><SPAN>ava:191)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.alfresco.repo.audit.AuditMethodInterceptor.invoke(AuditMethodInte</SPAN><BR /><SPAN>rceptor.java:69)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(</SPAN><BR /><SPAN>ReflectiveMethodInvocation.java:176)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.springframework.transaction.interceptor.TransactionInterceptor.in</SPAN><BR /><SPAN>voke(TransactionInterceptor.java:107)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(</SPAN><BR /><SPAN>ReflectiveMethodInvocation.java:176)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynami</SPAN><BR /><SPAN>cAopProxy.java:210)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at $Proxy40.list(Unknown Source)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.alfresco.web.bean.BrowseBean.queryBrowseNodes(BrowseBean.java:619</SPAN><BR /><SPAN>)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.alfresco.web.bean.BrowseBean.getNodes(BrowseBean.java:431)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.</SPAN><BR /><SPAN>java:39)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAcces</SPAN><BR /><SPAN>sorImpl.java:25)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at java.lang.reflect.Method.invoke(Method.java:585)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.apache.myfaces.el.PropertyResolverImpl.getProperty(PropertyResolv</SPAN><BR /><SPAN>erImpl.java:457)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.apache.myfaces.el.PropertyResolverImpl.getValue(PropertyResolverI</SPAN><BR /><SPAN>mpl.java:85)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.apache.myfaces.el.ELParserHelper$MyPropertySuffix.evaluate(ELPars</SPAN><BR /><SPAN>erHelper.java:535)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.apache.commons.el.ComplexValue.evaluate(ComplexValue.java:145)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.apache.myfaces.el.ValueBindingImpl.getValue(ValueBindingImpl.java</SPAN><BR /><SPAN>:386)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.alfresco.web.ui.common.component.data.UIRichList.getValue(UIRichL</SPAN><BR /><SPAN>ist.java:154)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.alfresco.web.ui.common.component.data.UIRichList.getDataModel(UIR</SPAN><BR /><SPAN>ichList.java:506)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.alfresco.web.ui.common.component.data.UIRichList.bind(UIRichList.</SPAN><BR /><SPAN>java:449)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.alfresco.web.ui.common.renderer.data.RichListRenderer.encodeChild</SPAN><BR /><SPAN>ren(RichListRenderer.java:83)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at javax.faces.component.UIComponentBase.encodeChildren(UIComponentBase.</SPAN><BR /><SPAN>java:527)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at javax.faces.webapp.UIComponentTag.encodeChildren(UIComponentTag.java:</SPAN><BR /><SPAN>483)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at javax.faces.webapp.UIComponentTag.doEndTag(UIComponentTag.java:364)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.apache.jsp.jsp.browse.browse_jsp._jspx_meth_a_005frichList_005f0(</SPAN><BR /><SPAN>browse_jsp.java:2207)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.apache.jsp.jsp.browse.browse_jsp._jspx_meth_a_005fpanel_005f5(bro</SPAN><BR /><SPAN>wse_jsp.java:2106)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.apache.jsp.jsp.browse.browse_jsp._jspService(browse_jsp.java:831)</SPAN><BR /><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:98)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at javax.servlet.http.HttpServlet.service(HttpServlet.java:803)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper</SPAN><BR /><SPAN>.java:328)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:3</SPAN><BR /><SPAN>15)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:265)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at javax.servlet.http.HttpServlet.service(HttpServlet.java:803)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Appl</SPAN><BR /><SPAN>icationFilterChain.java:269)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationF</SPAN><BR /><SPAN>ilterChain.java:188)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDisp</SPAN><BR /><SPAN>atcher.java:691)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.apache.catalina.core.ApplicationDispatcher.processRequest(Applica</SPAN><BR /><SPAN>tionDispatcher.java:469)</SPAN><BR /><BR /><BR /><SPAN>16:44:25,237 ERROR [ui.common.Utils] A system error happened during the operatio</SPAN><BR /><SPAN>n: Non-root node has no primary parent:</SPAN><BR /><SPAN>&nbsp;&nbsp; child: workspace://SpacesStore/7c0d7864-9ad2-11dd-9914-d3602a71a469</SPAN><BR /><SPAN>org.springframework.dao.DataIntegrityViolationException: Non-root node has no pr</SPAN><BR /><SPAN>imary parent:</SPAN><BR /><SPAN>&nbsp;&nbsp; child: workspace://SpacesStore/7c0d7864-9ad2-11dd-9914-d3602a71a469</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.alfresco.repo.node.db.hibernate.HibernateNodeDaoServiceImpl.getPa</SPAN><BR /><SPAN>rentAssocs(HibernateNodeDaoServiceImpl.java:1079)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.alfresco.repo.node.db.hibernate.HibernateNodeDaoServiceImpl.getPr</SPAN><BR /><SPAN>imaryParentAssoc(HibernateNodeDaoServiceImpl.java:1101)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at sun.reflect.GeneratedMethodAccessor243.invoke(Unknown Source)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAcces</SPAN><BR /><SPAN>sorImpl.java:25)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at java.lang.reflect.Method.invoke(Method.java:585)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflecti</SPAN><BR /><SPAN>on(AopUtils.java:281)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJo</SPAN><BR /><SPAN>inpoint(ReflectiveMethodInvocation.java:187)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(</SPAN><BR /><SPAN>ReflectiveMethodInvocation.java:154)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.alfresco.repo.transaction.TransactionalDaoInterceptor.invoke(Tran</SPAN><BR /><SPAN>sactionalDaoInterceptor.java:68)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(</SPAN><BR /><SPAN>ReflectiveMethodInvocation.java:176)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynami</SPAN><BR /><SPAN>cAopProxy.java:210)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at $Proxy1.getPrimaryParentAssoc(Unknown Source)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.alfresco.repo.node.db.DbNodeServiceImpl.getPrimaryParent(DbNodeSe</SPAN><BR /><SPAN>rviceImpl.java:1244)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at sun.reflect.GeneratedMethodAccessor169.invoke(Unknown Source)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAcces</SPAN><BR /><SPAN>sorImpl.java:25)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at java.lang.reflect.Method.invoke(Method.java:585)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflecti</SPAN><BR /><SPAN>on(AopUtils.java:281)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJo</SPAN><BR /><SPAN>inpoint(ReflectiveMethodInvocation.java:187)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(</SPAN><BR /><SPAN>ReflectiveMethodInvocation.java:154)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.alfresco.repo.transaction.TransactionResourceInterceptor.invoke(T</SPAN><BR /><SPAN>ransactionResourceInterceptor.java:138)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(</SPAN><BR /><SPAN>ReflectiveMethodInvocation.java:176)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynami</SPAN><BR /><SPAN>cAopProxy.java:210)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at $Proxy2.getPrimaryParent(Unknown Source)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at sun.reflect.GeneratedMethodAccessor169.invoke(Unknown Source)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAcces</SPAN><BR /><SPAN>sorImpl.java:25)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at java.lang.reflect.Method.invoke(Method.java:585)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.alfresco.repo.service.StoreRedirectorProxyFactory$RedirectorInvoc</SPAN><BR /><SPAN>ationHandler.invoke(StoreRedirectorProxyFactory.java:221)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at $Proxy3.getPrimaryParent(Unknown Source)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at sun.reflect.GeneratedMethodAccessor169.invoke(Unknown Source)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAcces</SPAN><BR /><SPAN>sorImpl.java:25)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at java.lang.reflect.Method.invoke(Method.java:585)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflecti</SPAN><BR /><SPAN>on(AopUtils.java:281)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJo</SPAN><BR /><SPAN>inpoint(ReflectiveMethodInvocation.java:187)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(</SPAN><BR /><SPAN>ReflectiveMethodInvocation.java:154)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.alfresco.repo.node.MLPropertyInterceptor.invoke(MLPropertyInterce</SPAN><BR /><SPAN>ptor.java:211)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(</SPAN><BR /><SPAN>ReflectiveMethodInvocation.java:176)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynami</SPAN><BR /><SPAN>cAopProxy.java:210)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at $Proxy2.getPrimaryParent(Unknown Source)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.alfresco.repo.security.permissions.impl.PermissionServiceImpl$Nod</SPAN><BR /><SPAN>eTest.evaluate(PermissionServiceImpl.java:744)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.alfresco.repo.security.permissions.impl.PermissionServiceImpl$Nod</SPAN><BR /><SPAN>eTest.evaluate(PermissionServiceImpl.java:733)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.alfresco.repo.security.permissions.impl.PermissionServiceImpl$Nod</SPAN><BR /><SPAN>eTest.evaluate(PermissionServiceImpl.java:670)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.alfresco.repo.security.permissions.impl.PermissionServiceImpl.has</SPAN><BR /><SPAN>Permission(PermissionServiceImpl.java:377)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.alfresco.repo.security.permissions.impl.PermissionServiceImpl.has</SPAN><BR /><SPAN>Permission(PermissionServiceImpl.java:564)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.alfresco.repo.security.permissions.impl.acegi.ACLEntryAfterInvoca</SPAN><BR /><SPAN>tionProvider.decide(ACLEntryAfterInvocationProvider.java:577)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.alfresco.repo.security.permissions.impl.acegi.ACLEntryAfterInvoca</SPAN><BR /><SPAN>tionProvider.decide(ACLEntryAfterInvocationProvider.java:224)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at net.sf.acegisecurity.afterinvocation.AfterInvocationProviderManager.d</SPAN><BR /><SPAN>ecide(AfterInvocationProviderManager.java:107)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at net.sf.acegisecurity.intercept.AbstractSecurityInterceptor.afterInvoc</SPAN><BR /><SPAN>ation(AbstractSecurityInterceptor.java:329)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at net.sf.acegisecurity.intercept.method.aopalliance.MethodSecurityInter</SPAN><BR /><SPAN>ceptor.invoke(MethodSecurityInterceptor.java:82)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(</SPAN><BR /><SPAN>ReflectiveMethodInvocation.java:176)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.alfresco.repo.security.permissions.impl.ExceptionTranslatorMethod</SPAN><BR /><SPAN>Interceptor.invoke(ExceptionTranslatorMethodInterceptor.java:49)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(</SPAN><BR /><SPAN>ReflectiveMethodInvocation.java:176)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.alfresco.repo.audit.AuditComponentImpl.auditImpl(AuditComponentIm</SPAN><BR /><SPAN>pl.java:256)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.alfresco.repo.audit.AuditComponentImpl.audit(AuditComponentImpl.j</SPAN><BR /><SPAN>ava:191)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.alfresco.repo.audit.AuditMethodInterceptor.invoke(AuditMethodInte</SPAN><BR /><SPAN>rceptor.java:69)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(</SPAN><BR /><SPAN>ReflectiveMethodInvocation.java:176)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.springframework.transaction.interceptor.TransactionInterceptor.in</SPAN><BR /><SPAN>voke(TransactionInterceptor.java:107)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(</SPAN><BR /><SPAN>ReflectiveMethodInvocation.java:176)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynami</SPAN><BR /><SPAN>cAopProxy.java:210)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at $Proxy40.list(Unknown Source)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.alfresco.web.bean.BrowseBean.queryBrowseNodes(BrowseBean.java:619</SPAN><BR /><SPAN>)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.alfresco.web.bean.BrowseBean.getNodes(BrowseBean.java:431)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.</SPAN><BR /><SPAN>java:39)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAcces</SPAN><BR /><SPAN>sorImpl.java:25)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at java.lang.reflect.Method.invoke(Method.java:585)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.apache.myfaces.el.PropertyResolverImpl.getProperty(PropertyResolv</SPAN><BR /><SPAN>erImpl.java:457)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.apache.myfaces.el.PropertyResolverImpl.getValue(PropertyResolverI</SPAN><BR /><SPAN>mpl.java:85)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.apache.myfaces.el.ELParserHelper$MyPropertySuffix.evaluate(ELPars</SPAN><BR /><SPAN>erHelper.java:535)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.apache.commons.el.ComplexValue.evaluate(ComplexValue.java:145)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.apache.myfaces.el.ValueBindingImpl.getValue(ValueBindingImpl.java</SPAN><BR /><SPAN>:386)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.alfresco.web.ui.common.component.data.UIRichList.getValue(UIRichL</SPAN><BR /><SPAN>ist.java:154)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.alfresco.web.ui.common.component.data.UIRichList.getDataModel(UIR</SPAN><BR /><SPAN>ichList.java:506)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.alfresco.web.ui.common.component.data.UIRichList.bind(UIRichList.</SPAN><BR /><SPAN>java:449)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.alfresco.web.ui.common.renderer.data.RichListRenderer.encodeChild</SPAN><BR /><SPAN>ren(RichListRenderer.java:83)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at javax.faces.component.UIComponentBase.encodeChildren(UIComponentBase.</SPAN><BR /><SPAN>java:527)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at javax.faces.webapp.UIComponentTag.encodeChildren(UIComponentTag.java:</SPAN><BR /><SPAN>483)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at javax.faces.webapp.UIComponentTag.doEndTag(UIComponentTag.java:364)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.apache.jsp.jsp.browse.browse_jsp._jspx_meth_a_005frichList_005f0(</SPAN><BR /><SPAN>browse_jsp.java:2207)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.apache.jsp.jsp.browse.browse_jsp._jspx_meth_a_005fpanel_005f5(bro</SPAN><BR /><SPAN>wse_jsp.java:2106)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.apache.jsp.jsp.browse.browse_jsp._jspService(browse_jsp.java:831)</SPAN><BR /><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:98)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at javax.servlet.http.HttpServlet.service(HttpServlet.java:803)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper</SPAN><BR /><SPAN>.java:328)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:3</SPAN><BR /><SPAN>15)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:265)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at javax.servlet.http.HttpServlet.service(HttpServlet.java:803)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Appl</SPAN><BR /><SPAN>icationFilterChain.java:269)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationF</SPAN><BR /><SPAN>ilterChain.java:188)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDisp</SPAN><BR /><SPAN>atcher.java:691)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.apache.catalina.core.ApplicationDispatcher.processRequest(Applica</SPAN><BR /><SPAN>tionDispatcher.java:469)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.apache.catalina.core.ApplicationDispatcher.doForward(ApplicationD</SPAN><BR /><SPAN>ispatcher.java:403)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.apache.catalina.core.ApplicationDispatcher.forward(ApplicationDis</SPAN><BR /><SPAN>patcher.java:301)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.apache.myfaces.context.servlet.ServletExternalContextImpl.dispatc</SPAN><BR /><SPAN>h(ServletExternalContextImpl.java:419)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.apache.myfaces.application.jsp.JspViewHandlerImpl.renderView(JspV</SPAN><BR /><SPAN>iewHandlerImpl.java:211)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.apache.myfaces.lifecycle.RenderResponseExecutor.execute(RenderRes</SPAN><BR /><SPAN>ponseExecutor.java:41)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.apache.myfaces.lifecycle.LifecycleImpl.render(LifecycleImpl.java:</SPAN><BR /><SPAN>132)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at javax.faces.webapp.FacesServlet.service(FacesServlet.java:140)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Appl</SPAN><BR /><SPAN>icationFilterChain.java:269)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationF</SPAN><BR /><SPAN>ilterChain.java:188)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.alfresco.web.app.servlet.NTLMAuthenticationFilter.doFilter(NTLMAu</SPAN><BR /><SPAN>thenticationFilter.java:329)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Appl</SPAN><BR /><SPAN>icationFilterChain.java:215)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationF</SPAN><BR /><SPAN>ilterChain.java:188)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperV</SPAN><BR /><SPAN>alve.java:210)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.apache.catalina.core.StandardContextValve.invoke(StandardContextV</SPAN><BR /><SPAN>alve.java:174)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.j</SPAN><BR /><SPAN>ava:127)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.j</SPAN><BR /><SPAN>ava:117)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineVal</SPAN><BR /><SPAN>ve.java:108)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.jav</SPAN><BR /><SPAN>a:151)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java</SPAN><BR /><SPAN>:870)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.p</SPAN><BR /><SPAN>rocessConnection(Http11BaseProtocol.java:665)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpo</SPAN><BR /><SPAN>int.java:528)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFol</SPAN><BR /><SPAN>lowerWorkerThread.java:81)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadP</SPAN><BR /><SPAN>ool.java:685)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at java.lang.Thread.run(Thread.java:595)</SPAN><BR /><BR /><BR /><SPAN>Thanks &amp; Regards,</SPAN><BR /><SPAN>Archana</SPAN></BODY></HTML> Wed, 25 Feb 2009 11:49:36 GMT archana_bonkanp 2009-02-25T11:49:36Z Unable to find files https://connect.hyland.com/t5/alfresco-archive/unable-to-find-files/m-p/181923#M135053 Hi,I uploaded some files into a folder long back.suddenly a exception occured and im unable to view anyone of the files present in that folder.The following error occured and no files were visible in that folder ,but we are able to open folder.ERROR [ui.common.Utils] A system error happened during t Wed, 25 Feb 2009 11:49:36 GMT https://connect.hyland.com/t5/alfresco-archive/unable-to-find-files/m-p/181923#M135053 archana_bonkanp 2009-02-25T11:49:36Z Re: Unable to find files https://connect.hyland.com/t5/alfresco-archive/unable-to-find-files/m-p/181924#M135054 <HTML><HEAD></HEAD><BODY><SPAN>Hi,</SPAN><BR /><SPAN>What version are you running?&nbsp; Can you check that your tables are all InnoDB tables.</SPAN><BR /><SPAN>Regards</SPAN></BODY></HTML> Wed, 25 Feb 2009 17:47:55 GMT https://connect.hyland.com/t5/alfresco-archive/unable-to-find-files/m-p/181924#M135054 derek 2009-02-25T17:47:55Z Re: Unable to find files https://connect.hyland.com/t5/alfresco-archive/unable-to-find-files/m-p/181925#M135055 <HTML><HEAD></HEAD><BODY><SPAN>no there are MYISAM</SPAN></BODY></HTML> Thu, 26 Feb 2009 05:48:46 GMT https://connect.hyland.com/t5/alfresco-archive/unable-to-find-files/m-p/181925#M135055 archana_bonkanp 2009-02-26T05:48:46Z Re: Unable to find files https://connect.hyland.com/t5/alfresco-archive/unable-to-find-files/m-p/181926#M135056 <HTML><HEAD></HEAD><BODY><SPAN>we are using Alfresco 2.1,</SPAN><BR /><SPAN>DB : MYSQL</SPAN><BR /><SPAN>running on&nbsp; windows 2003 enterprise editon</SPAN><BR /><SPAN>the engine type for tables is MYISAM</SPAN></BODY></HTML> Thu, 26 Feb 2009 05:49:50 GMT https://connect.hyland.com/t5/alfresco-archive/unable-to-find-files/m-p/181926#M135056 archana_bonkanp 2009-02-26T05:49:50Z Re: Unable to find files https://connect.hyland.com/t5/alfresco-archive/unable-to-find-files/m-p/181927#M135057 <HTML><HEAD></HEAD><BODY><SPAN>I think you cannot run Alfresco on MYSQL-MYISAM tables, since MYISAM doesn't support DB transactions.</SPAN></BODY></HTML> Thu, 26 Feb 2009 06:41:15 GMT https://connect.hyland.com/t5/alfresco-archive/unable-to-find-files/m-p/181927#M135057 rogier_oudshoor 2009-02-26T06:41:15Z Re: Unable to find files https://connect.hyland.com/t5/alfresco-archive/unable-to-find-files/m-p/181928#M135058 <HTML><HEAD></HEAD><BODY><SPAN>currently we running with MYISAM</SPAN><BR /><SPAN>how to change it to INNODB.</SPAN><BR /><SPAN>Currently w eneed to change it on the production server,does it effect any data if we change it to INNODB.</SPAN><BR /><SPAN>We currently u[plaoded 30 GB of data in production environment</SPAN></BODY></HTML> Thu, 26 Feb 2009 06:47:09 GMT https://connect.hyland.com/t5/alfresco-archive/unable-to-find-files/m-p/181928#M135058 archana_bonkanp 2009-02-26T06:47:09Z Re: Unable to find files https://connect.hyland.com/t5/alfresco-archive/unable-to-find-files/m-p/181929#M135059 <HTML><HEAD></HEAD><BODY><SPAN>Hi,</SPAN><BR /><BR /><SPAN>30GB of data and no support contract?&nbsp; Clearly it's not a valuable 30GB, then.</SPAN><BR /><BR /><SPAN>Run </SPAN><PRE class="language-none line-numbers"><CODE>show table status;<SPAN class="line-numbers-rows"><SPAN>‍</SPAN></SPAN></CODE></PRE><SPAN> against your alfresco database. The Engine column </SPAN><STRONG style=": ; color: #FF0000; text-decoration: underline;">MUST</STRONG><SPAN> be "InnoDB" for all tables.&nbsp; If not, then virtually every rollback (and they can occur for many, many reasons) will be leaving corrupt data lying around.</SPAN><BR /><BR /><SPAN>You will need to:</SPAN><BR /><UL>Shut Alfresco down<BR />Alter the tables (<A href="http://dev.mysql.com/doc/refman/5.1/en/alter-table.html" rel="nofollow noopener noreferrer">http://dev.mysql.com/doc/refman/5.1/en/alter-table.html</A>)<BR />Configure in the correct Hibernate dialect for InnoDB<BR />Restore to a backup that didn't have the (blocking) data corruption</UL><SPAN>Then, plan to:</SPAN><BR /><UL>Upgrade to 2.1 Enterprise<BR />Upgrade to 3.0</UL><SPAN>If data issues exist, it'll take a bit more effort to fix the corruption(s).&nbsp; Usually, the upgrade scripts identify these nicely.</SPAN><BR /><BR /><SPAN>Regards</SPAN></BODY></HTML> Thu, 26 Feb 2009 11:09:41 GMT https://connect.hyland.com/t5/alfresco-archive/unable-to-find-files/m-p/181929#M135059 derek 2009-02-26T11:09:41Z