Help

Solr Migration

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Alfred2
Active Member II
‎11 Aug 2021 10:16 AM

Solr Migration

Jump to solution

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.

0 Kudos
1 Solution

Accepted Solutions
cristinamr
Advanced
‎13 Aug 2021 10:02 AM

Re: Solr Migration

Jump to solution

Como te comenté anteriormente: muestranos todos los archivos de configuración por favor. Sino será muy complicado saber qué está mal configurado o por qué falla.

Asegurate que en solrcore.properties tienes esto:

# encryption
# none, https
alfresco.secureComms=https

En vez de:

# encryption
# none, https
alfresco.secureComms=none

Un saludo.

 

--
VenziaIT: helping companies since 2005! Our ECM products: AQuA & Seidoc

View solution in original post

17 Replies
cristinamr
Advanced
‎11 Aug 2021 11:14 AM

Re: Solr Migration

Jump to solution

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.

--
VenziaIT: helping companies since 2005! Our ECM products: AQuA & Seidoc
0 Kudos
Alfred2
Active Member II
‎11 Aug 2021 11:32 AM

Re: Solr Migration

Jump to solution

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. 

0 Kudos
cristinamr
Advanced
‎11 Aug 2021 3:37 PM

Re: Solr Migration

Jump to solution

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.

--
VenziaIT: helping companies since 2005! Our ECM products: AQuA & Seidoc
0 Kudos
Alfred2
Active Member II
‎12 Aug 2021 8:51 AM

Re: Solr Migration

Jump to solution

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.

 

0 Kudos
cristinamr
Advanced
‎12 Aug 2021 11:12 AM

Re: Solr Migration

Jump to solution 
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!

--
VenziaIT: helping companies since 2005! Our ECM products: AQuA & Seidoc
0 Kudos
Alfred2
Active Member II
‎12 Aug 2021 11:45 AM

Re: Solr Migration

Jump to solution

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. 

 

0 Kudos
cristinamr
Advanced
‎12 Aug 2021 0:01 PM

Re: Solr Migration

Jump to solution

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.

--
VenziaIT: helping companies since 2005! Our ECM products: AQuA & Seidoc
0 Kudos
Alfred2
Active Member II
‎12 Aug 2021 0:05 PM

Re: Solr Migration

Jump to solution

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

0 Kudos
Alfred2
Active Member II
‎12 Aug 2021 0:07 PM

Re: Solr Migration

Jump to solution

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:"fmSmiley Tongueost" +(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:"fmSmiley Tongueost" +(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:"fmSmiley Tongueost" +(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:"fmSmiley Tongueost" +(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

0 Kudos
Spanish User Group

Discussions about Alfresco Content Services and Alfresco Process Services in Spanish

Related:

We use cookies on this site to enhance your user experience

By using this site, you are agreeing to allow us to collect and use cookies as outlined in Alfresco’s Cookie Statement and Terms of Use (and you have a legitimate interest in Alfresco and our products, authorizing us to contact you in such methods).   If you are not ok with these terms, please do not use this website.