No puedo abrir otros Documentos tipo: Doc, xls, powerpoint o cualquier tipo de imagen.

[Alfred2]

Hola,

Recientemente hemos instalado Manualmente mediante zip alfresco share version 6.2 y alfresco conten app con angular, hasta aqui todo funciona bien, puedo conectarme, crear, subir y descargar hasta visualizar documentos. 

Tengo installado el libreoffice 6.3 mediante zip. 

El problema aqui es que solo puedo visualizar archivos pdf. Caulquier otro tipo de archivo o imagenes no puedo visualizarlos en alfresco ya sea tanto share o content App. 

Me gustaria saber si alguien tiene alguna guia que yo pueda entender para solucionar este problema.

Muchas Gracias. 

[cristinamr]

Buenos días, @Alfred2 .

Lo primero antes de nada ¿algún error en el log al intentar visualizar esos archivos que fallan? ¿Ocurre en ambas apps (share y ACA) ? ¿Si crear un archivo txt plano no se previsualiza, por ejemplo desde Share?

Antes de nada, mirando tu versión he encontrado este post, ojealo por si pudieran venir por ahí los tiros (timeouts disparados por el volumen de los documentos).

Ve contándonos.

Un saludo,

Cristina.

[Alfred2]

Hola Cristina,

Muchas Gracias por contestar, pues mediante Content App puedo abrir jpg, png, pdf y algunos documentos text.

Acabo de subir ahora dos documentos uno es: pptx de powerpoint otro es xlsx de excel. y el error en los dos es: error Couldn't load preview. Unknown format.

En cambio con share solo puedo pdf nada mas.

[Alfred2]

este es el estado de los servicios con su puerto.

Libreoffice

Postgres

Solr

Activemq

Tomcat

Content App 

Proto Recv-Q Send-Q Local Address           Foreign Address         State       User       Inode      PID/Program name    

tcp        0      0 127.0.0.1:8100          0.0.0.0:*               LISTEN      0          38458      3293/soffice.bin    

tcp        0      0 0.0.0.0:4200            0.0.0.0:*               LISTEN      1000       32678      3057/ng serve --ope       

tcp        0      0 127.0.0.1:5432          0.0.0.0:*               LISTEN      111        22579      1320/postgres       

tcp6       0      0 :::5672                 :::*                    LISTEN      0          26964      2447/java           

tcp6       0      0 :::8009                 :::*                    LISTEN      0          34383      3205/java           

tcp6       0      0 :::8080                 :::*                    LISTEN      0          34379      3205/java           

[Alfred2]

catalina.out Log

INFORMATION: ProcessManager implementation is LinuxProcessManager

Aug 06, 2021 9:43:24 AM org.artofsolving.jodconverter.office.OfficeProcess start

INFORMATION: Using original OpenOffice command: [/opt/libreoffice6.3/program/soffice.bin, -accept=socket,host=127.0.0.1,port=2022;urp;, -env:UserInstallation=file:///opt/alfresco/tomcat/temp/.jodconverter_socket_host-127.0.0.1_port-2022, -headless, -nocrashreport, -nodefault, -nofirststartwizard, -nolockcheck, -nologo, -norestore]

Aug 06, 2021 9:43:24 AM org.artofsolving.jodconverter.office.OfficeProcess start

INFORMATION: starting process with acceptString 'socket,host=127.0.0.1,port=2022,tcpNoDelay=1' and profileDir '/opt/alfresco/tomcat/temp/.jodconverter_socket_host-127.0.0.1_port-2022'

Aug 06, 2021 9:43:24 AM org.artofsolving.jodconverter.office.OfficeProcess start

INFORMATION: started process; pid = 25648

Aug 06, 2021 9:43:24 AM org.artofsolving.jodconverter.office.ManagedOfficeProcess$6 attempt

WARNUNG: office process died with exit code 81; restarting it

Aug 06, 2021 9:43:24 AM org.artofsolving.jodconverter.office.OfficeProcess start

INFORMATION: Using original OpenOffice command: [/opt/libreoffice6.3/program/soffice.bin, -accept=socket,host=127.0.0.1,port=2022;urp;, -env:UserInstallation=file:///opt/alfresco/tomcat/temp/.jodconverter_socket_host-127.0.0.1_port-2022, -headless, -nocrashreport, -nodefault, -nofirststartwizard, -nolockcheck, -nologo, -norestore]

Aug 06, 2021 9:43:24 AM org.artofsolving.jodconverter.office.OfficeProcess start

INFORMATION: starting process with acceptString 'socket,host=127.0.0.1,port=2022,tcpNoDelay=1' and profileDir '/opt/alfresco/tomcat/temp/.jodconverter_socket_host-127.0.0.1_port-2022'

Aug 06, 2021 9:43:24 AM org.artofsolving.jodconverter.office.OfficeProcess start

INFORMATION: started process; pid = 25657

Aug 06, 2021 9:43:25 AM org.artofsolving.jodconverter.office.OfficeConnection connect

se conecta perfectamente, pero todo lo que sea Windows: excel, powerpoint, word no lo abre, tampoco imagenes jpg, lo unico png si se abre en share y en content app. no se que tengo que hacer. 

[cristinamr]

---

@Alfred2 wrote:

Acabo de subir ahora dos documentos uno es: pptx de powerpoint otro es xlsx de excel. y el error en los dos es: error Couldn't load preview. Unknown format.

En cambio con share solo puedo pdf nada mas.

---

Mira a ver los logs de Alfresco y de Share y dime qué te está poniendo.

sudo docker-compose logs -f --tail 500 alfresco

donde alfresco es el nombre del contenedor en docker (puedes hacer un sudo docker-compose ps para saber los nombres).

Importante: Intenta por favor pasarme los logs de la misma franja cuando hagas las pruebas, así podremos ver si hay algún error técnico por detrás. También a veces es muy útil parar alfresco, arrancarlo y reproducir los errores porque a veces el problema es a la hora de arrancar que falle algo.

Para facilitar la lectura de los dos logs, podrías utilizar https://pastebin.com por ejemplo para colgarlos completos allí.

Ve comentandome.

[Alfred2]

Hice una instalacion con Docker y esa funciona de maravilla.

Pero la instlacion manual mediante zip tiene este problema con documentos que venga den Microsoft Office.

[cristinamr]

Por favor, facilita los logs como te he indicado en mi anterior mensaje.

Aunque sé que es muy frustante no te preocupes que daremos con el problema pero es indispensable saber qué error técnico te está dando por detrás.

[Alfred2]

/opt/alfresco/tomcat/logs# tail -f catalina.out 

06-Aug-2021 09:56:26.067 INFORMATION [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -Djava.io.tmpdir=/opt/alfresco/tomcat/temp

06-Aug-2021 09:56:26.067 INFORMATION [main] org.apache.catalina.core.AprLifecycleListener.lifecycleEvent The APR based Apache Tomcat Native library which allows optimal performance in production environments was not found on the java.library.path: [/usr/java/packages/lib:/usr/lib/x86_64-linux-gnu/jni:/lib/x86_64-linux-gnu:/usr/lib/x86_64-linux-gnu:/usr/lib/jni:/lib:/usr/lib]

06-Aug-2021 09:56:26.112 INFORMATION [main] org.apache.coyote.AbstractProtocol.init Initializing ProtocolHandler ["http-nio-8080"]

06-Aug-2021 09:56:26.125 INFORMATION [main] org.apache.tomcat.util.net.NioSelectorPool.getSharedSelector Using a shared selector for servlet write/read

06-Aug-2021 09:56:26.145 INFORMATION [main] org.apache.coyote.AbstractProtocol.init Initializing ProtocolHandler ["ajp-nio-8009"]

06-Aug-2021 09:56:26.147 INFORMATION [main] org.apache.tomcat.util.net.NioSelectorPool.getSharedSelector Using a shared selector for servlet write/read

06-Aug-2021 09:56:26.147 INFORMATION [main] org.apache.catalina.startup.Catalina.load Initialization processed in 643 ms

06-Aug-2021 09:56:26.233 INFORMATION [main] org.apache.catalina.core.StandardService.startInternal Starting service [Catalina]

06-Aug-2021 09:56:26.234 INFORMATION [main] org.apache.catalina.core.StandardEngine.startInternal Starting Servlet Engine: Apache Tomcat/8.5.43

06-Aug-2021 09:56:26.246 INFORMATION [localhost-startStop-1] org.apache.catalina.startup.HostConfig.deployDescriptor Deploying configuration descriptor [/opt/alfresco/apache-tomcat-8.5.43/conf/Catalina/localhost/alfresco.xml]

Aug 06, 2021 9:56:37 AM org.apache.catalina.core.ApplicationContext log

INFORMATION: No Spring WebApplicationInitializer types detected on classpath

Aug 06, 2021 9:56:37 AM org.apache.jasper.servlet.TldScanner scanJars

INFORMATION: At least one JAR was scanned for TLDs yet contained no TLDs. Enable debug logging for this logger for a complete list of JARs that were scanned but no TLDs were found in them. Skipping unneeded JARs during scanning can improve startup time and JSP compilation time.

Aug 06, 2021 9:56:37 AM org.apache.catalina.core.ApplicationContext log

INFORMATION: Initializing Spring root WebApplicationContext

2021-08-06 09:56:48,603  WARN  [heartbeat.datasender.HBDataSenderServiceBuilder] [localhost-startStop-1] Setting the Heartbeat sender cron with property 'heartbeat.sender.cronExpression' is no longer supported.

2021-08-06 09:56:48,782  INFO  [domain.schema.SchemaBootstrap] [localhost-startStop-1] Ignoring script patch (post-Hibernate): patch.db-V4.2-metadata-query-indexes

2021-08-06 09:56:48,782  INFO  [domain.schema.SchemaBootstrap] [localhost-startStop-1] Ignoring script patch (post-Hibernate): patch.db-V5.1-metadata-query-indexes

2021-08-06 09:56:48,783  INFO  [domain.schema.SchemaBootstrap] [localhost-startStop-1] Ignoring script patch (post-Hibernate): patch.db-V5.2-remove-jbpm-tables-from-db

2021-08-06 09:56:49,020  INFO  [alfresco.repo.admin] [localhost-startStop-1] Using database URL 'jdbcostgresql://localhost:5432/alfresco' with user 'alfresco'.

2021-08-06 09:56:49,022  INFO  [alfresco.repo.admin] [localhost-startStop-1] Connected to database PostgreSQL version 11.12 (Ubuntu 11.12-1.pgdg18.04+1)

2021-08-06 09:56:57,181  INFO  [extensions.webscripts.TemplateProcessorRegistry] [localhost-startStop-1] Registered template processor Repository Template Processor for extension ftl

2021-08-06 09:56:57,186  INFO  [extensions.webscripts.ScriptProcessorRegistry] [localhost-startStop-1] Registered script processor Repository Script Processor for extension js

2021-08-06 09:56:59,187  INFO  [management.subsystems.ChildApplicationContextFactory] [localhost-startStop-1] Starting 'ContentStore' subsystem, ID: [ContentStore, managed, unencrypted]

2021-08-06 09:56:59,223  INFO  [management.subsystems.ChildApplicationContextFactory] [localhost-startStop-1] Startup of 'ContentStore' subsystem, ID: [ContentStore, managed, unencrypted] complete

2021-08-06 09:56:59,288  INFO  [domain.schema.SchemaBootstrap] [localhost-startStop-1] Connecting to database: jdbcostgresql://localhost:5432/alfresco, UserName=alfresco, PostgreSQL JDBC Driver

2021-08-06 09:56:59,288  INFO  [domain.schema.SchemaBootstrap] [localhost-startStop-1] Schema managed by database dialect org.alfresco.repo.domain.dialect.PostgreSQLDialect.

2021-08-06 09:56:59,313  INFO  [domain.schema.SchemaBootstrap] [localhost-startStop-1] Applied patches detected: 223

2021-08-06 09:56:59,483  INFO  [domain.schema.SchemaBootstrap] [localhost-startStop-1] Checking and patching Alfresco tables took 169 ms

2021-08-06 09:56:59,485  INFO  [domain.schema.SchemaBootstrap] [localhost-startStop-1] Activiti tables need to be checked for patches

2021-08-06 09:56:59,593  INFO  [domain.schema.SchemaBootstrap] [localhost-startStop-1] Checking and patching Activiti tables took 108 ms

2021-08-06 09:56:59,691  INFO  [domain.schema.SchemaBootstrap] [localhost-startStop-1] Checking that all patches have been applied took 98 ms

2021-08-06 09:56:59,691  INFO  [domain.schema.SchemaBootstrap] [localhost-startStop-1] Updating the DB schema took 402 ms

2021-08-06 09:56:59,692  INFO  [domain.schema.SchemaBootstrap] [localhost-startStop-1] No changes were made to the schema.

2021-08-06 09:57:00,615  INFO  [management.subsystems.ChildApplicationContextFactory] [localhost-startStop-1] Starting 'thirdparty' subsystem, ID: [thirdparty, default]

2021-08-06 09:57:00,705  INFO  [management.subsystems.ChildApplicationContextFactory] [localhost-startStop-1] Startup of 'thirdparty' subsystem, ID: [thirdparty, default] complete

2021-08-06 09:57:00,705  INFO  [management.subsystems.ChildApplicationContextFactory] [localhost-startStop-1] Starting 'OOoJodconverter' subsystem, ID: [OOoJodconverter, default]

Aug 06, 2021 9:57:00 AM org.artofsolving.jodconverter.office.ProcessPoolOfficeManager <init>

INFORMATION: ProcessManager implementation is LinuxProcessManager

Aug 06, 2021 9:57:00 AM org.artofsolving.jodconverter.office.OfficeProcess start

INFORMATION: Using original OpenOffice command: [/opt/libreoffice6.3/program/soffice.bin, -accept=socket,host=127.0.0.1,port=2022;urp;, -env:UserInstallation=file:///opt/alfresco/tomcat/temp/.jodconverter_socket_host-127.0.0.1_port-2022, -headless, -nocrashreport, -nodefault, -nofirststartwizard, -nolockcheck, -nologo, -norestore]

Aug 06, 2021 9:57:00 AM org.artofsolving.jodconverter.office.OfficeProcess start

INFORMATION: starting process with acceptString 'socket,host=127.0.0.1,port=2022,tcpNoDelay=1' and profileDir '/opt/alfresco/tomcat/temp/.jodconverter_socket_host-127.0.0.1_port-2022'

Aug 06, 2021 9:57:00 AM org.artofsolving.jodconverter.office.OfficeProcess start

INFORMATION: started process; pid = 25957

Aug 06, 2021 9:57:01 AM org.artofsolving.jodconverter.office.ManagedOfficeProcess$6 attempt

WARNUNG: office process died with exit code 81; restarting it

Aug 06, 2021 9:57:01 AM org.artofsolving.jodconverter.office.OfficeProcess start

INFORMATION: Using original OpenOffice command: [/opt/libreoffice6.3/program/soffice.bin, -accept=socket,host=127.0.0.1,port=2022;urp;, -env:UserInstallation=file:///opt/alfresco/tomcat/temp/.jodconverter_socket_host-127.0.0.1_port-2022, -headless, -nocrashreport, -nodefault, -nofirststartwizard, -nolockcheck, -nologo, -norestore]

Aug 06, 2021 9:57:01 AM org.artofsolving.jodconverter.office.OfficeProcess start

INFORMATION: starting process with acceptString 'socket,host=127.0.0.1,port=2022,tcpNoDelay=1' and profileDir '/opt/alfresco/tomcat/temp/.jodconverter_socket_host-127.0.0.1_port-2022'

Aug 06, 2021 9:57:01 AM org.artofsolving.jodconverter.office.OfficeProcess start

INFORMATION: started process; pid = 25966

Aug 06, 2021 9:57:02 AM org.artofsolving.jodconverter.office.OfficeConnection connect

INFORMATION: connected: 'socket,host=127.0.0.1,port=2022,tcpNoDelay=1'

2021-08-06 09:57:02,064  INFO  [management.subsystems.ChildApplicationContextFactory] [localhost-startStop-1] Startup of 'OOoJodconverter' subsystem, ID: [OOoJodconverter, default] complete

2021-08-06 09:57:02,070  INFO  [repo.admin.ConfigurationChecker] [localhost-startStop-1] The root data directory ('dir.root') is: /opt/alfresco/alf_data

[Alfred2]

2021-08-06 09:57:02,118  INFO  [admin.patch.PatchExecuter] [localhost-startStop-1] Checking for patches to apply ...

2021-08-06 09:57:02,489  INFO  [admin.patch.PatchExecuter] [localhost-startStop-1] No patches were required.

2021-08-06 09:57:02,505  INFO  [repo.module.ModuleServiceImpl] [localhost-startStop-1] Found 2 module package(s).

2021-08-06 09:57:02,541  INFO  [repo.module.ModuleServiceImpl] [localhost-startStop-1] Starting module 'alfresco-share-services' version 6.2.0.

2021-08-06 09:57:02,567  INFO  [repo.module.ModuleServiceImpl] [localhost-startStop-1] Starting module 'alfresco-trashcan-cleaner' version 2.3.

2021-08-06 09:57:02,579  INFO  [management.subsystems.ChildApplicationContextFactory] [localhost-startStop-1] Starting 'fileServers' subsystem, ID: [fileServers, default]

2021-08-06 09:57:03,031  INFO  [management.subsystems.ChildApplicationContextFactory] [localhost-startStop-1] Startup of 'fileServers' subsystem, ID: [fileServers, default] complete

2021-08-06 09:57:03,031  INFO  [management.subsystems.ChildApplicationContextFactory] [localhost-startStop-1] Starting 'imap' subsystem, ID: [imap, default]

2021-08-06 09:57:03,126  INFO  [management.subsystems.ChildApplicationContextFactory] [localhost-startStop-1] Startup of 'imap' subsystem, ID: [imap, default] complete

2021-08-06 09:57:03,126  INFO  [management.subsystems.ChildApplicationContextFactory] [localhost-startStop-1] Starting 'email' subsystem, ID: [email, outbound]

2021-08-06 09:57:03,492  INFO  [management.subsystems.ChildApplicationContextFactory] [localhost-startStop-1] Startup of 'email' subsystem, ID: [email, outbound] complete

2021-08-06 09:57:03,493  INFO  [management.subsystems.ChildApplicationContextFactory] [localhost-startStop-1] Starting 'email' subsystem, ID: [email, inbound]

---

@cristinamr wrote:

---

@Alfred2 wrote:

Acabo de subir ahora dos documentos uno es: pptx de powerpoint otro es xlsx de excel. y el error en los dos es: error Couldn't load preview. Unknown format.

En cambio con share solo puedo pdf nada mas.

---

Mira a ver los logs de Alfresco y de Share y dime qué te está poniendo.

sudo docker-compose logs -f --tail 500 alfresco

donde alfresco es el nombre del contenedor en docker (puedes hacer un sudo docker-compose ps para saber los nombres).

Intenta por favor pasarme los logs de la misma franja cuando hagas las pruebas, así podremos ver si hay algún error técnico por detrás. También a veces es muy útil parar alfresco, arrancarlo y reproducir los errores porque a veces el problema es a la hora de arrancar que falle algo.

Ve comentandome.

---

2021-08-06 09:57:03,544  INFO  [management.subsystems.ChildApplicationContextFactory] [localhost-startStop-1] Startup of 'email' subsystem, ID: [email, inbound] complete

2021-08-06 09:57:03,544  INFO  [management.subsystems.ChildApplicationContextFactory] [localhost-startStop-1] Starting 'Subscriptions' subsystem, ID: [Subscriptions, default]

2021-08-06 09:57:03,562  INFO  [management.subsystems.ChildApplicationContextFactory] [localhost-startStop-1] Startup of 'Subscriptions' subsystem, ID: [Subscriptions, default] complete

2021-08-06 09:57:03,585  INFO  [management.subsystems.ChildApplicationContextFactory] [localhost-startStop-1] Starting 'Synchronization' subsystem, ID: [Synchronization, default]

2021-08-06 09:57:03,635  INFO  [management.subsystems.ChildApplicationContextFactory] [localhost-startStop-1] Starting 'sysAdmin' subsystem, ID: [sysAdmin, default]

2021-08-06 09:57:04,386  INFO  [service.descriptor.DescriptorService] [localhost-startStop-1] Alfresco JVM - v11.0.11+9-Ubuntu-0ubuntu2.18.04; maximum heap size 4516,000MB

2021-08-06 09:57:04,386  INFO  [service.descriptor.DescriptorService] [localhost-startStop-1] Server Mode :UNKNOWN

2021-08-06 09:57:04,387  INFO  [service.descriptor.DescriptorService] [localhost-startStop-1] Alfresco Content Services gestartet (Community). Aktuelle Version: 6.2.0 (r05dbaf43-b368) Schema 13.001. Ursprünglich installierte Version: 6.2.0 (r05dbaf43-b368) Schema 13.001.

2021-08-06 09:57:04,397  INFO  [management.subsystems.ChildApplicationContextFactory] [localhost-startStop-1] Starting 'ActivitiesFeed' subsystem, ID: [ActivitiesFeed, default]

2021-08-06 09:57:04,671  INFO  [management.subsystems.ChildApplicationContextFactory] [localhost-startStop-1] Startup of 'ActivitiesFeed' subsystem, ID: [ActivitiesFeed, default] complete

2021-08-06 09:57:04,672  INFO  [management.subsystems.ChildApplicationContextFactory] [localhost-startStop-1] Starting 'Replication' subsystem, ID: [Replication, default]

2021-08-06 09:57:04,686  INFO  [management.subsystems.ChildApplicationContextFactory] [localhost-startStop-1] Startup of 'Replication' subsystem, ID: [Replication, default] complete

2021-08-06 09:57:05,762  INFO  [management.subsystems.ChildApplicationContextFactory] [localhost-startStop-1] Starting 'Messaging' subsystem, ID: [Messaging, default]

2021-08-06 09:57:08,512  INFO  [management.subsystems.ChildApplicationContextFactory] [localhost-startStop-1] Startup of 'Messaging' subsystem, ID: [Messaging, default] complete

2021-08-06 09:57:12,214  INFO  [extensions.webscripts.DeclarativeRegistry] [asynchronouslyRefreshedCacheThreadPool1] Registered 374 Web Scripts (+0 failed), 518 URLs

2021-08-06 09:57:12,222  INFO  [extensions.webscripts.DeclarativeRegistry] [asynchronouslyRefreshedCacheThreadPool1] Registered 1 Package Description Documents (+0 failed)