Solr Migration

[Alfred2]

Hola Comunidad,

Estoy intentando Migrar alfresco 6.2 de Docker a una instalacion manual alfresco 6.2 ya tengo la pase de datos restaurada, los Contenstore y Contenstore.delete copiados, Solr backup de Docker copiados pero no encuentro donde restaurar las copias de Solr al alfresco sin Docker. 

Gracias.

[cristinamr]

Buenas.

Asumiendo que es una instalación nueva, normalmente se encuentra en <ALFRESCO_HOME>\alf_data\contentstore

Puedes también verificar en tu alfresco-global.properties por si lo tuvieras en otra ubicación (la propiedad dir.root).

Aquí te dejo más info.

Un saludo.

[Alfred2]

Hola Cristina,

Hice todo lo que dice aqui:

https://docs.alfresco.com/search-services/latest/admin/monitor/ para reindexzar Solr.

Pero recibo algunos Warning en ciertos ficheros:

Por ejmeplo: 

Caused by: org.alfresco.scripts.ScriptException: 07110178 Failed to execute script 'classpath*:alfresco/templates/webscripts/org/alfresco/repository/thumbnail/thumbnail.get.js': 07110177 07110176 Some error occurred during document transforming. Error message: 07110175 Transformation of (themedata.xml) has not taken place because the declared mimetype (text/xml) does not match the detected mimetype (application/vnd.openxmlformats-officedocument).

2021-08-11 10:28:09,726  WARN  [content.transform.AbstractContentTransformer2] [http-nio-8080-exec-12] Transformation of (nung.key) has not taken place because the declared mimetype (application/vnd.apple.keynote) does not match the detected mimetype (application/vnd.apple.keynote.13).

y asi sin parar. 

[cristinamr]

Pero el problema de los warns que comentas no tiene que ver con localizar el contentstore ¿verdad? ¿lo has localizado? ¿pudiste reindexar correctamente?

He estado viendo y los WARNs te los da porque hay un cambio en los archivos a la hora de subirlos, o bien porque al renombrarlos dentro de alfresco les quitamos la extensión. Parecido a lo que se describe en este hilo.

Sube un archivo que tengas problemas, mira desde windows o tu sistema operativo qué extensión te reonoce, una vez subido en Alfresco y mira con el inspector del Node Browser a ver qué extensión te reconoce.

[Alfred2]

Pude Reindexar Solr sin problemas y en cuanto a los archvios la base de datos venia de un postgres instalado en un Windows Server y un alfresco 5.2, despues lo migre a alfresco 6.2 + postgres + Docker y ahora, hice una copa de la base de datos de postgres con docker a una installacion sin Docker.

Al iniciar al fresco no tengo este error: alfresco error loading the elements pero si cierro la sesion y vuelvo a iniciar sesion me aparece ese error:  alfresco error loading the elements. 

¿Hay alguna forma de evitar eso ?

Gracias por todo Cristina.

[cristinamr]

Al iniciar al fresco no tengo este error: alfresco error loading the elements.

---

He visto que has puesto en otro post que el error te da en la consola de usuarios. Si es así es un error reconocido de Alfresco 6.2 . Ahi tienes explicado cómo aplicar un workaround para que funcione.

¡Un saludo!

P.D.: Un consejo: para la próxima adjunta capturas del error, o logs... ¡cualquier evidencia nos sirve muchísimo de ayuda!

[Alfred2]

Hola Cristina, 

Muchas gracias por responder siempre, lo que pasa es que ayer restaure la base de datos a la nueva instalacion de alfresco y reindexe Solr, pero Solr al crear de nuevo los index pocos minutos despues se desconecta solo y alli es cuando me parece ese error en Alfresco Share, si elimino todos los index, reinicio los servicios todo vuelve a funcionar perfectamente, pero pocos minutos mas tarde Solr se desconecta de nuevo. 

No se que hacer. 

[cristinamr]

Necesitamos los logs.

restaure la base de datos a la nueva instalacion de alfresco y reindexe Solr,

Imagino que además de la base de datos has restaurado el content store ¿verdad? Ten en cuenta que deben ir sincronizados, es decir, no sirve que hagas un backup del día 7 a las 19:00 de la base de datos y que hagas un backup de tu content store del día 10 a las 17:00. Ambos backups deben ser a la misma hora y, si puedes parar alfresco, mejor que mejor. A la hora de restaurar no deberías tener problema.

Por cierto para el tema de backup y restore te recomiendo esta utilidad.

[Alfred2]

Todo eso lo hice el mismo dia y la misma hora. pero por lo visto Solr se desconecta solo. 

[Alfred2]

catalina.out

2021-08-12 11:05:58,986  INFO  [web.site.EditionInterceptor] [http-nio-8080-exec-4] Successfully retrieved license information from Alfresco.

 2021-08-12 11:06:26,743  INFO  [web.scripts.ImapServerStatus] [http-nio-8080-exec-10] Successfully retrieved IMAP server status from Alfresco: disabled

 2021-08-12 11:06:39,977  ERROR [extensions.webscripts.AbstractRuntime] [http-nio-8080-exec-2] Exception from executeScript: 07120001 Wrapped Exception (with status template): 07120033 Failed to execute script 'classpath*:alfresco/templates/webscripts/org/alfresco/slingshot/documentlibrary/doclist.get.js': 07120032 Failed to execute search:  +@cm\:modified:[2021\-8\-5T00\:00\:00.000 TO 2021\-8\-12T23\:59\:59.999] +@cm\:modifier:"and" +TYPE:"cm:content" -TYPE:"cm:systemfolder" -TYPE:"fm:forums" -TYPE:"fm:forum" -TYPE:"fm:topic" -TYPE:"fmost" +(TYPE:"content" OR TYPE:"app:filelink" OR TYPE:"folder")

org.springframework.extensions.webscripts.WebScriptException: 07120001 Wrapped Exception (with status template): 07120033 Failed to execute script 'classpath*:alfresco/templates/webscripts/org/alfresco/slingshot/documentlibrary/doclist.get.js': 07120032 Failed to execute search:  +@cm\:modified:[2021\-8\-5T00\:00\:00.000 TO 2021\-8\-12T23\:59\:59.999] +@cm\:modifier:"and" +TYPE:"cm:content" -TYPE:"cm:systemfolder" -TYPE:"fm:forums" -TYPE:"fm:forum" -TYPE:"fm:topic" -TYPE:"fmost" +(TYPE:"content" OR TYPE:"app:filelink" OR TYPE:"folder")

at org.springframework.extensions.webscripts.AbstractWebScript.createStatusException(AbstractWebScript.java:1139)

at org.springframework.extensions.webscripts.DeclarativeWebScript.execute(DeclarativeWebScript.java:171)

at org.alfresco.repo.web.scripts.RepositoryContainer$3.execute(RepositoryContainer.java:519)

at org.alfresco.repo.transaction.RetryingTransactionHelper.doInTransaction(RetryingTransactionHelper.java:450)

at org.alfresco.repo.web.scripts.RepositoryContainer.transactionedExecute(RepositoryContainer.java:595)

at org.alfresco.repo.web.scripts.RepositoryContainer.transactionedExecuteAs(RepositoryContainer.java:664)

at org.alfresco.repo.web.scripts.RepositoryContainer.executeScriptInternal(RepositoryContainer.java:435)

at org.alfresco.repo.web.scripts.RepositoryContainer.executeScript(RepositoryContainer.java:315)

at org.springframework.extensions.webscripts.AbstractRuntime.executeScript(AbstractRuntime.java:399)

at org.springframework.extensions.webscripts.AbstractRuntime.executeScript(AbstractRuntime.java:210)

at org.springframework.extensions.webscripts.servlet.WebScriptServlet.service(WebScriptServlet.java:132)

at org.alfresco.repo.web.scripts.AlfrescoWebScriptServlet.service(AlfrescoWebScriptServlet.java:43)

at javax.servlet.http.HttpServlet.service(HttpServlet.java:741)

at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:231)

at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)

at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)

at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)

at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)

at org.alfresco.web.app.servlet.GlobalLocalizationFilter.doFilter(GlobalLocalizationFilter.java:68)

at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)

at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)

at org.alfresco.web.app.servlet.ClearSecurityContextFilter.doFilter(ClearSecurityContextFilter.java:53)

at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)

at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)

at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:199)

at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:96)

at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:493)

at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:137)

at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:81)

at org.apache.catalina.valves.AbstractAccessLogValve.invoke(AbstractAccessLogValve.java:660)

at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:87)

at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:343)

at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:798)

at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:66)

at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:808)

at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1498)

at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49)

at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1128)

at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:628)

at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)

at java.base/java.lang.Thread.run(Thread.java:829)

Caused by: org.alfresco.scripts.ScriptException: 07120033 Failed to execute script 'classpath*:alfresco/templates/webscripts/org/alfresco/slingshot/documentlibrary/doclist.get.js': 07120032 Failed to execute search:  +@cm\:modified:[2021\-8\-5T00\:00\:00.000 TO 2021\-8\-12T23\:59\:59.999] +@cm\:modifier:"and" +TYPE:"cm:content" -TYPE:"cm:systemfolder" -TYPE:"fm:forums" -TYPE:"fm:forum" -TYPE:"fm:topic" -TYPE:"fmost" +(TYPE:"content" OR TYPE:"app:filelink" OR TYPE:"folder")

at org.alfresco.repo.jscript.RhinoScriptProcessor.execute(RhinoScriptProcessor.java:211)

at org.alfresco.repo.processor.ScriptServiceImpl.execute(ScriptServiceImpl.java:219)

at org.alfresco.repo.processor.ScriptServiceImpl.executeScript(ScriptServiceImpl.java:181)

at org.alfresco.repo.web.scripts.RepositoryScriptProcessor.executeScript(RepositoryScriptProcessor.java:109)

at org.springframework.extensions.webscripts.AbstractWebScript.executeScript(AbstractWebScript.java:1376)

at org.springframework.extensions.webscripts.DeclarativeWebScript.execute(DeclarativeWebScript.java:86)

... 39 more

Caused by: org.alfresco.error.AlfrescoRuntimeException: 07120032 Failed to execute search:  +@cm\:modified:[2021\-8\-5T00\:00\:00.000 TO 2021\-8\-12T23\:59\:59.999] +@cm\:modifier:"and" +TYPE:"cm:content" -TYPE:"cm:systemfolder" -TYPE:"fm:forums" -TYPE:"fm:forum" -TYPE:"fm:topic" -TYPE:"fmost" +(TYPE:"content" OR TYPE:"app:filelink" OR TYPE:"folder")

at org.alfresco.repo.jscript.Search.queryResultMeta(Search.java:1127)

at org.alfresco.repo.jscript.Search.queryResultSet(Search.java:819)

at org.alfresco.repo.jscript.Search.query(Search.java:560)

at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)

at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)

at java.base/java.lang.reflect.Method.invoke(Method.java:566)

at org.mozilla.javascript.MemberBox.invoke(MemberBox.java:138)

at org.mozilla.javascript.NativeJavaMethod.call(NativeJavaMethod.java:226)

at org.mozilla.javascript.optimizer.OptRuntime.call1(OptRuntime.java:45)

at org.mozilla.javascript.gen.classpath__alfresco_templates_webscripts_org_alfresco_slingshot_documentlibrary_doclist_get_js_5._c_getDoclist_20(classpath*:alfresco/templates/webscripts/org/alfresco/slingshot/documentlibrary/doclist.get.js:1127)

at org.mozilla.javascript.gen.classpath__alfresco_templates_webscripts_org_alfresco_slingshot_documentlibrary_doclist_get_js_5.call(classpath*:alfresco/templates/webscripts/org/alfresco/slingshot/documentlibrary/doclist.get.js)

at org.mozilla.javascript.optimizer.OptRuntime.callName0(OptRuntime.java:87)

at org.mozilla.javascript.gen.classpath__alfresco_templates_webscripts_org_alfresco_slingshot_documentlibrary_doclist_get_js_5._c_script_0(classpath*:alfresco/templates/webscripts/org/alfresco/slingshot/documentlibrary/doclist.get.js:1352)

at org.mozilla.javascript.gen.classpath__alfresco_templates_webscripts_org_alfresco_slingshot_documentlibrary_doclist_get_js_5.call(classpath*:alfresco/templates/webscripts/org/alfresco/slingshot/documentlibrary/doclist.get.js)

at org.mozilla.javascript.ContextFactory.doTopCall(ContextFactory.java:409)

at org.mozilla.javascript.ScriptRuntime.doTopCall(ScriptRuntime.java:3566)

at org.mozilla.javascript.gen.classpath__alfresco_templates_webscripts_org_alfresco_slingshot_documentlibrary_doclist_get_js_5.call(classpath*:alfresco/templates/webscripts/org/alfresco/slingshot/documentlibrary/doclist.get.js)

at org.mozilla.javascript.gen.classpath__alfresco_templates_webscripts_org_alfresco_slingshot_documentlibrary_doclist_get_js_5.exec(classpath*:alfresco/templates/webscripts/org/alfresco/slingshot/documentlibrary/doclist.get.js)

at org.alfresco.repo.jscript.RhinoScriptProcessor.executeScriptImpl(RhinoScriptProcessor.java:509)

at org.alfresco.repo.jscript.RhinoScriptProcessor.execute(RhinoScriptProcessor.java:207)

... 44 more

Caused by: org.alfresco.repo.search.impl.lucene.LuceneQueryParserException: 07120031 

at org.alfresco.repo.search.impl.solr.SolrQueryHTTPClient.executeQuery(SolrQueryHTTPClient.java:597)

at org.alfresco.repo.search.impl.solr.SolrQueryLanguage.executeQuery(SolrQueryLanguage.java:52)

at org.alfresco.repo.search.impl.solr.SolrSearchService.query(SolrSearchService.java:354)

at org.alfresco.repo.search.SearcherComponent.query(SearcherComponent.java:84)

at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)

at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)

at java.base/java.lang.reflect.Method.invoke(Method.java:566)

at org.alfresco.repo.management.subsystems.SubsystemProxyFactory$1.invoke(SubsystemProxyFactory.java:79)

at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186)

at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:212)

at com.sun.proxy.$Proxy34.query(Unknown Source)

at org.alfresco.repo.search.impl.SearchServiceSubSystemDelegator.query(SearchServiceSubSystemDelegator.java:133)

at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)

at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)

at java.base/java.lang.reflect.Method.invoke(Method.java:566)

at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:343)

at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:198)

at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:163)

at net.sf.acegisecurity.intercept.method.aopalliance.MethodSecurityInterceptor.invoke(MethodSecurityInterceptor.java:80)

at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186)

at org.alfresco.repo.security.permissions.impl.ExceptionTranslatorMethodInterceptor.invoke(ExceptionTranslatorMethodInterceptor.java:53)

at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186)

at org.alfresco.repo.audit.AuditMethodInterceptor.invoke(AuditMethodInterceptor.java:166)

at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186)

at org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:295)

at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:98)

at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186)

at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:212)

at com.sun.proxy.$Proxy34.query(Unknown Source)

at org.alfresco.repo.jscript.Search.queryResultMeta(Search.java:1016)

... 64 more

Caused by: java.net.ConnectException: Connection refused (Connection refused)

at java.base/java.net.PlainSocketImpl.socketConnect(Native Method)

at java.base/java.net.AbstractPlainSocketImpl.doConnect(AbstractPlainSocketImpl.java:399)

at java.base/java.net.AbstractPlainSocketImpl.connectToAddress(AbstractPlainSocketImpl.java:242)

at java.base/java.net.AbstractPlainSocketImpl.connect(AbstractPlainSocketImpl.java:224)

at java.base/java.net.SocksSocketImpl.connect(SocksSocketImpl.java:392)

at java.base/java.net.Socket.connect(Socket.java:609)

at java.base/java.net.Socket.connect(Socket.java:558)

at java.base/java.net.Socket.<init>(Socket.java:454)

at java.base/java.net.Socket.<init>(Socket.java:306)

at org.apache.commons.httpclient.protocol.DefaultProtocolSocketFactory.createSocket(DefaultProtocolSocketFactory.java:80)

at org.apache.commons.httpclient.protocol.DefaultProtocolSocketFactory.createSocket(DefaultProtocolSocketFactory.java:122)

at org.apache.commons.httpclient.HttpConnection.open(HttpConnection.java:707)

at org.apache.commons.httpclient.MultiThreadedHttpConnectionManager$HttpConnectionAdapter.open(MultiThreadedHttpConnectionManager.java:1361)

at org.apache.commons.httpclient.HttpMethodDirector.executeWithRetry(HttpMethodDirector.java:387)

at org.apache.commons.httpclient.HttpMethodDirector.executeMethod(HttpMethodDirector.java:171)

at org.apache.commons.httpclient.HttpClient.executeMethod(HttpClient.java:397)

at org.apache.commons.httpclient.HttpClient.executeMethod(HttpClient.java:323)

at org.alfresco.repo.search.impl.solr.AbstractSolrQueryHTTPClient.postQuery(AbstractSolrQueryHTTPClient.java:95)

at org.alfresco.repo.search.impl.solr.SolrQueryHTTPClient.postSolrQuery(SolrQueryHTTPClient.java:1115)

at org.alfresco.repo.search.impl.solr.SolrQueryHTTPClient.executeQuery(SolrQueryHTTPClient.java:582)

... 95 more