topic Re: Preview of Word/Excel/PowerPoint files doesn't work in Alfresco Forum

Preview of Word/Excel/PowerPoint files doesn't work

marius_dumitrac — Tue, 24 Oct 2017 09:59:02 GMT

Hi,I have installed Alfresco Community 5.2 on a CentOS 7, with Tomcat 7, PostgreSQL 9.6, LibreOffice 5.4, ImageMagick 7 and GhostScript 9.07 and it's working fine with one exception - the preview of MS Office files.In the Web Interface I get the message "The document can't be previewed. Click here t

Re: Preview of Word/Excel/PowerPoint files doesn't work

afaust — Tue, 24 Oct 2017 10:57:33 GMT

The error message states that one transformer fails because it cannot find a prepared thumbnail already present in the Office file. This is an "optimisation" transformer which aims to avoid generating a (potentially inaccurate) thumbnail when the file contains one. The question in your case is, why is this transformer picked instead of the OpenOffice one, when no thumbnail is embedded. Looking at the implementation, I can see no logic that actually does any checks if a thumbnail exists before chosing this transformer, which at the look of it might be a bug in Alfresco., though I have not noticed it in current customer systems.

One option you have is to de-prioritise the OOXML transformer, so that the OpenOffice one is always tried first (as long as it supports the transformation). You should be able to do this by setting

content.transformer.OOXMLThumbnail.priority=500‍

in alfresco-global.properties. With this setting, only specific transformations that have been prioritised explicitly (by default only dotx=>jpg and potx=>jpg) should be transformed via this transformer first.

Re: Preview of Word/Excel/PowerPoint files doesn't work

marius_dumitrac — Tue, 24 Oct 2017 11:38:51 GMT

Hi Axel,

I've done the modification you send me and restart Tomcat (also I've erased the alfresco and share folders from webapps tomcat folder) and the problems is still there.

Also, I've managed to isolate the error when preview the office docs. Here it is:

2017-10-24 14:15:27,277 ERROR [extensions.webscripts.AbstractRuntime] [http-bio-8080-exec-6] Exception from executeScript: 09240002 The content node was not specified so the content cannot be streamed to the client: classpath*:alfresco/templates/webscripts/org/alfresco/repository/thumbnail/thumbnail.get.js
org.springframework.extensions.webscripts.WebScriptException: 09240002 The content node was not specified so the content cannot be streamed to the client: classpath*:alfresco/templates/webscripts/org/alfresco/repository/thumbnail/thumbnail.get.js
at org.alfresco.repo.web.scripts.content.StreamContent.execute(StreamContent.java:176)
at org.alfresco.repo.web.scripts.RepositoryContainer$3.execute(RepositoryContainer.java:512)
at org.alfresco.repo.transaction.RetryingTransactionHelper.doInTransaction(RetryingTransactionHelper.java:464)
at org.alfresco.repo.web.scripts.RepositoryContainer.transactionedExecute(RepositoryContainer.java:587)
at org.alfresco.repo.web.scripts.RepositoryContainer.transactionedExecuteAs(RepositoryContainer.java:656)
at org.alfresco.repo.web.scripts.RepositoryContainer.executeScriptInternal(RepositoryContainer.java:428)
at org.alfresco.repo.web.scripts.RepositoryContainer.executeScript(RepositoryContainer.java:308)
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 javax.servlet.http.HttpServlet.service(HttpServlet.java:731)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:303)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
at org.alfresco.module.aosmodule.service.ContextRootFilter.doFilter(ContextRootFilter.java:93)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
at org.alfresco.web.app.servlet.GlobalLocalizationFilter.doFilter(GlobalLocalizationFilter.java:68)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:219)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:110)
at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:506)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:169)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:103)
at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:962)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:116)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:445)
at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1115)
at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:637)
at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:316)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
at java.lang.Thread.run(Thread.java:748)

Thanks,

Marius

Re: Preview of Word/Excel/PowerPoint files doesn't work

marius_dumitrac — Tue, 24 Oct 2017 19:16:18 GMT

Hi,

I've solved the problem. Here is a short tutorial on how to fix this problem.

First a small typo in my alfresco-global.properties file:

jodconverter.portNumbers=8101 should be jodconverter.portNumbers=8100

The root cause was the absence of libcairo.so.2 library and because of this, the openoffice could not be started.

I found out by executing the ./soffice command in the folder where LibreOffice is installed (in my case this was in /opt/libreoffice5.4)

If the response is something like:

/path/to/libreoffice/program/soffice.bin: Error while loading shared libraries: libcairo.so.2 ....

Then you have to install the missing library.

In my case (CentOS 7) I've executed the following command:

yum install cairo -y

After that, running ./soffice the result was: Failed to open display

After that, I've restarted tomcat, and that was it.

Now the MS Office files are opened in preview.