Hyland Connect

Alfred2 · ‎08-11-2021

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 · ‎08-13-2021

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 answer in original post

cristinamr · ‎08-11-2021

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

Alfred2 · ‎08-11-2021

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 · ‎08-11-2021

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

Alfred2 · ‎08-12-2021

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 · ‎08-12-2021

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

Alfred2 · ‎08-12-2021

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 · ‎08-12-2021

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

Alfred2 · ‎08-12-2021

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

Alfred2 · ‎08-12-2021

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

Hyland Connect

Solr Migration