4.0.e to 4.2.b upgrade failure

[michaelk]

I am attempting to upgrade from 4.0.e to 4.2.b but are having problems.

I am copying over my alf_data and adjusting the paths as I usually do in upgrading. I see the repository and documents in share but the search returns nothing and the "My Documents" shows "Error loading items".  The log shows errors below…

Does anyone know what is causing this and how to correct it ?
I tried deleting the indexes, but without any sucess.

thanks,
   Michael

11:18:33,433 ERROR [org.springframework.extensions.webscripts.AbstractRuntime] Exception from executeScript - redirecting to status template error: 09290001 Wrapped Exception (with status template): 09290008 Failed to execute script 'classpath*:alfresco/templates/webscripts/org/alfresco/slingshot/documentlibrary/doclist.get.js': 09290007 Failed to execute search: +(ID:"workspace://SpacesStore/ab65c511-91be-41cc-8bb5-f320f3b784c1" OR ID:"workspace://SpacesStore/1fa777a0-b17f-406d-bd10-30f2de1b9250" OR ID:"workspace://SpacesStore/5b90d5c8-019a-42ec-bc30-9aa9a6b9c4ad" OR ID:"workspace://SpacesStore/e36d6198-14fb-49c4-ac0b-2b950f951436" OR ID:"workspace://SpacesStore/7f2bde01-d2f7-481a-b57f-dbae514fabd9" OR ID:"workspace://SpacesStore/1440c5ef-cedc-458a-baaa-e6265a41f8e8") +(TYPE:"content" OR TYPE:"app:filelink" OR TYPE:"folder")
org.springframework.extensions.webscripts.WebScriptException: 09290001 Wrapped Exception (with status template): 09290008 Failed to execute script 'classpath*:alfresco/templates/webscripts/org/alfresco/slingshot/documentlibrary/doclist.get.js': 09290007 Failed to execute search: +(ID:"workspace://SpacesStore/ab65c511-91be-41cc-8bb5-f320f3b784c1" OR ID:"workspace://SpacesStore/1fa777a0-b17f-406d-bd10-30f2de1b9250" OR ID:"workspace://SpacesStore/5b90d5c8-019a-42ec-bc30-9aa9a6b9c4ad" OR ID:"workspace://SpacesStore/e36d6198-14fb-49c4-ac0b-2b950f951436" OR ID:"workspace://SpacesStore/7f2bde01-d2f7-481a-b57f-dbae514fabd9" OR ID:"workspace://SpacesStore/1440c5ef-cedc-458a-baaa-e6265a41f8e8") +(TYPE:"content" OR TYPE:"app:filelink" OR TYPE:"folder")
        at org.springframework.extensions.webscripts.AbstractWebScript.createStatusException(AbstractWebScript.java:1067)
        at org.springframework.extensions.webscripts.DeclarativeWebScript.execute(DeclarativeWebScript.java:171)
        at org.alfresco.repo.web.scripts.RepositoryContainer$3.execute(RepositoryContainer.java:422)
        at org.alfresco.repo.transaction.RetryingTransactionHelper.doInTransaction(RetryingTransactionHelper.java:433)
        at org.alfresco.repo.web.scripts.RepositoryContainer.transactionedExecute(RepositoryContainer.java:491)
        at org.alfresco.repo.web.scripts.RepositoryContainer.transactionedExecuteAs(RepositoryContainer.java:529)
        at org.alfresco.repo.web.scripts.RepositoryContainer.executeScript(RepositoryContainer.java:345)
        at org.springframework.extensions.webscripts.AbstractRuntime.executeScript(AbstractRuntime.java:377)
        at org.springframework.extensions.webscripts.AbstractRuntime.executeScript(AbstractRuntime.java:209)
        at org.springframework.extensions.webscripts.servlet.WebScriptServlet.service(WebScriptServlet.java:118)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:722)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:305)
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
        at org.alfresco.web.app.servlet.GlobalLocalizationFilter.doFilter(GlobalLocalizationFilter.java:61)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243)
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
        at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:222)
        at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:123)
        at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:472)
        at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:168)
        at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:99)
        at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:929)
        at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:118)
        at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:407)
        at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1002)
        at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:585)
        at org.apache.tomcat.util.net.AprEndpoint$SocketWithOptionsProcessor.run(AprEndpoint.java:1771)
        at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1110)
        at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:603)
        at java.lang.Thread.run(Thread.java:722)
Caused by: org.alfresco.scripts.ScriptException: 09290008 Failed to execute script 'classpath*:alfresco/templates/webscripts/org/alfresco/slingshot/documentlibrary/doclist.get.js': 09290007 Failed to execute search: +(ID:"workspace://
SpacesStore/ab65c511-91be-41cc-8bb5-f320f3b784c1" OR ID:"workspace://SpacesStore/1fa777a0-b17f-406d-bd10-30f2de1b9250" OR ID:"workspace://SpacesStore/5b90d5c8-019a-42ec-bc30-9aa9a6b9c4ad" OR ID:"workspace://SpacesStore/e36d6198-14fb-4
9c4-ac0b-2b950f951436" OR ID:"workspace://SpacesStore/7f2bde01-d2f7-481a-b57f-dbae514fabd9" OR ID:"workspace://SpacesStore/1440c5ef-cedc-458a-baaa-e6265a41f8e8") +(TYPE:"content" OR TYPE:"app:filelink" OR TYPE:"folder")
        at org.alfresco.repo.jscript.RhinoScriptProcessor.execute(RhinoScriptProcessor.java:202)
        at org.alfresco.repo.processor.ScriptServiceImpl.execute(ScriptServiceImpl.java:212)
        at org.alfresco.repo.processor.ScriptServiceImpl.executeScript(ScriptServiceImpl.java:174)
        at org.alfresco.repo.web.scripts.RepositoryScriptProcessor.executeScript(RepositoryScriptProcessor.java:102)
        at org.springframework.extensions.webscripts.AbstractWebScript.executeScript(AbstractWebScript.java:1305)
        at org.springframework.extensions.webscripts.DeclarativeWebScript.execute(DeclarativeWebScript.java:86)
        … 28 more
Caused by: org.alfresco.error.AlfrescoRuntimeException: 09290007 Failed to execute search: +(ID:"workspace://SpacesStore/ab65c511-91be-41cc-8bb5-f320f3b784c1" OR ID:"workspace://SpacesStore/1fa777a0-b17f-406d-bd10-30f2de1b9250" OR ID:"workspace://SpacesStore/5b90d5c8-019a-42ec-bc30-9aa9a6b9c4ad" OR ID:"workspace://SpacesStore/e36d6198-14fb-49c4-ac0b-2b950f951436" OR ID:"workspace://SpacesStore/7f2bde01-d2f7-481a-b57f-dbae514fabd9" OR ID:"workspace://SpacesStore/1440c5ef-cedc-458a-baaa-e6265a41f8e8") +(TYPE:"content" OR TYPE:"app:filelink" OR TYPE:"folder")
        at org.alfresco.repo.jscript.Search.query(Search.java:823)
        at org.alfresco.repo.jscript.Search.query(Search.java:686)
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
        at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
        at java.lang.reflect.Method.invoke(Method.java:601)
        at org.mozilla.javascript.MemberBox.invoke(MemberBox.java:155)
        at org.mozilla.javascript.NativeJavaMethod.call(NativeJavaMethod.java:243)
        at org.mozilla.javascript.optimizer.OptRuntime.call1(OptRuntime.java:66)
        at org.mozilla.javascript.gen.c6._c20(file:/var/home/loc/alfresco-4.2.b/tomcat/webapps/alfresco/WEB-INF/classes/alfresco/templates/webscripts/org/alfresco/slingshot/documentlibrary/doclist.get.js:1219)
        at org.mozilla.javascript.gen.c6.call(file:/var/home/loc/alfresco-4.2.b/tomcat/webapps/alfresco/WEB-INF/classes/alfresco/templates/webscripts/org/alfresco/slingshot/documentlibrary/doclist.get.js)
        at org.mozilla.javascript.optimizer.OptRuntime.callName0(OptRuntime.java:108)
        at org.mozilla.javascript.gen.c6._c0(file:/var/home/loc/alfresco-4.2.b/tomcat/webapps/alfresco/WEB-INF/classes/alfresco/templates/webscripts/org/alfresco/slingshot/documentlibrary/doclist.get.js:1456)
        at org.mozilla.javascript.gen.c6.call(file:/var/home/loc/alfresco-4.2.b/tomcat/webapps/alfresco/WEB-INF/classes/alfresco/templates/webscripts/org/alfresco/slingshot/documentlibrary/doclist.get.js)
        at org.mozilla.javascript.ContextFactory.doTopCall(ContextFactory.java:393)
        at org.mozilla.javascript.ScriptRuntime.doTopCall(ScriptRuntime.java:2834)
        at org.mozilla.javascript.gen.c6.call(file:/var/home/loc/alfresco-4.2.b/tomcat/webapps/alfresco/WEB-INF/classes/alfresco/templates/webscripts/org/alfresco/slingshot/documentlibrary/doclist.get.js)
        at org.mozilla.javascript.gen.c6.exec(file:/var/home/loc/alfresco-4.2.b/tomcat/webapps/alfresco/WEB-INF/classes/alfresco/templates/webscripts/org/alfresco/slingshot/documentlibrary/doclist.get.js)
        at org.alfresco.repo.jscript.RhinoScriptProcessor.executeScriptImpl(RhinoScriptProcessor.java:492)
        at org.alfresco.repo.jscript.RhinoScriptProcessor.execute(RhinoScriptProcessor.java:198)
        … 33 more
Caused by: org.alfresco.repo.search.impl.lucene.LuceneQueryParserException: 09290006 Request failed 500 /solr/alfresco/alfresco?wt=json&fl=DBID%2Cscore&rows=500&df=TEXT&start=0&locale=en_US&sort=%40cm%3Aname+asc&fq=%7B%21afts%7DAUTHORITY_FILTER_FROM_JSON&fq=%7B%21afts%7DTENANT_FILTER_FROM_JSON
        at org.alfresco.repo.search.impl.solr.SolrQueryHTTPClient.executeQuery(SolrQueryHTTPClient.java:398)
        at org.alfresco.repo.search.impl.solr.SolrQueryLanguage.executeQuery(SolrQueryLanguage.java:49)
        at org.alfresco.repo.search.impl.solr.SolrSearchService.query(SolrSearchService.java:348)
        at org.alfresco.repo.search.SearcherComponent.query(SearcherComponent.java:78)
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
        at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
        at java.lang.reflect.Method.invoke(Method.java:601)
        at org.alfresco.repo.management.subsystems.SubsystemProxyFactory$1.invoke(SubsystemProxyFactory.java:72)
        at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
        at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:202)
        at $Proxy10.query(Unknown Source)
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
        at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
        at java.lang.reflect.Method.invoke(Method.java:601)
        at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:309)
        at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:183)
        at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:150)
        at net.sf.acegisecurity.intercept.method.aopalliance.MethodSecurityInterceptor.invoke(MethodSecurityInterceptor.java:80)
        at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
        at org.alfresco.repo.security.permissions.impl.ExceptionTranslatorMethodInterceptor.invoke(ExceptionTranslatorMethodInterceptor.java:46)
        at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
        at org.alfresco.repo.audit.AuditMethodInterceptor.invoke(AuditMethodInterceptor.java:159)
        at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
        at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:110)
        at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
        at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:202)
        at $Proxy10.query(Unknown Source)
        at org.alfresco.repo.jscript.Search.query(Search.java:803)
        … 52 more
‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍

[michaelk]

I managed to figure out a fix …

1. Stop Alfresco
2. Delete the alf_data/solr directory
3. Copy the alf_data/solr directory from the virgin installation (the directory state straight after the install script is run)
4. Delete the  alf_data/solr/workspace/SpacesStore/index and alf_data/solr/archive/SpacesStore/index to initiate the rebuilding of the indexes
5. Generate new keys alf_data/keystore/generate_keystores.sh  <===  I don't know if this is necessary
6. Restart.  The reindexing takes some time (on my repository) but there are now no errors in the log and after a time the search returns results.

Michael

[deivin]

Great!!!

I had this problem and thanks to this post I haveve solved

Best regards.