topic Re: 5.0b & 5.0c- Previewing Microsoft Office documents doesn't work in Alfresco Archive

5.0b & 5.0c- Previewing Microsoft Office documents doesn't work

legaulois — Tue, 14 Oct 2014 13:49:35 GMT

Hello,a problem on a fresh installation of Community 5.0b on Centos 6.5 x64,the Office documents (Word, Excel, …) are not previewable. PDF works but only this format. The thumbnails are not generated also.Regards,

Re: 5.0b & 5.0c- Previewing Microsoft Office documents doesn't work

douglascrp — Fri, 07 Nov 2014 18:31:51 GMT

Have you configured LibreOffice and ImageMagick?

Re: 5.0b & 5.0c- Previewing Microsoft Office documents doesn't work

legaulois — Sun, 09 Nov 2014 16:33:27 GMT

Yes they are configured by the default installation.

The path seem to be good.

Re: 5.0b & 5.0c- Previewing Microsoft Office documents doesn't work

douglascrp — Mon, 10 Nov 2014 16:54:44 GMT

Don't you see any error messages when you start Alfresco?

Take a look at alfresco.log and catalina.out

Re: 5.0b & 5.0c- Previewing Microsoft Office documents doesn't work

hgindl — Thu, 13 Nov 2014 09:03:50 GMT

did you install the prerequisites?

http://docs.alfresco.com/4.2/concepts/install-lolibfiles.html

Kind regards,
Hannes

Re: 5.0b & 5.0c- Previewing Microsoft Office documents doesn't work

ruimota — Thu, 13 Nov 2014 14:39:37 GMT

Hello,

I am having the same problem with Alfresco Community 5.0.b and Linux CentOS 6.6 (done a fresh install), but my issue is related with the file size upload (Microsoft Office Word any version). When i upload a doc or docx with more that 1MB file size the preview doesn't work.
From previous posts i found that no limitations exist on file size upload, so i tried to open the files directly with libreoffice and it didn´t open either. Next i tried to replace Libreoffice with Openoffice on the server that has Alfresco, and i can open the files with openoffice but still no preview with alfresco.

Also checked Alfresco requirements and everything is installed.

Am i the only one having this problem?

Regards,

Re: 5.0b & 5.0c- Previewing Microsoft Office documents doesn't work

legaulois — Tue, 25 Nov 2014 12:42:33 GMT

Hello,

this problem always occurs.

I need some help to have a previewing operationnal.

Thx

Re: 5.0b & 5.0c- Previewing Microsoft Office documents doesn't work

hgindl — Thu, 27 Nov 2014 15:22:00 GMT

ever tried to start soffice service from command line or transform a document using soffice from the command line?

just a educated guess that you are missing some libraries, i guess it is libxinerama

Re: 5.0b & 5.0c- Previewing Microsoft Office documents doesn't work

markrwells — Fri, 05 Dec 2014 20:15:05 GMT

As someone who has faced this problem multiple time. (QUITE ANNOYING). Yes the libxinerama file was a gotcha for me. Two things I have found: when Alfresco is started, it does not always load the environment settings from setenv.sh or Alfresco.sh in linux. you are trying to figure out why a transform doesn't work only to find out it cannot find soffice. You fix all the environment variable and it still doesn't work on DOCX. Until the Libxinerama and all other associated files get loaded, then it works.

But I would check to make sure the environment variables are actually set. I have noticed that the variables will be set, then you stop the Alfresco server, start it again and suddenly your path is set to the OS default again and not path statements for Alfresco. uugh…

Re: 5.0b & 5.0c- Previewing Microsoft Office documents doesn't work

legaulois — Mon, 08 Dec 2014 14:33:53 GMT

Hello,

the problem occurs always. I've try it on a fresh installation of Alfresco 5.0.C.

The log when i open a document for previewing :


 2014-12-08 15:30:48,346  ERROR [extensions.webscripts.AbstractRuntime] [http-apr-80-exec-10] Exception from executeScript - redirecting to status template error: 11080001 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: 11080001 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:167)
        at org.alfresco.repo.web.scripts.RepositoryContainer$3.execute(RepositoryContainer.java:463)
        at org.alfresco.repo.transaction.RetryingTransactionHelper.doInTransaction(RetryingTransactionHelper.java:454)
        at org.alfresco.repo.web.scripts.RepositoryContainer.transactionedExecute(RepositoryContainer.java:532)
        at org.alfresco.repo.web.scripts.RepositoryContainer.transactionedExecuteAs(RepositoryContainer.java:600)
        at org.alfresco.repo.web.scripts.RepositoryContainer.executeScriptInternal(RepositoryContainer.java:380)
        at org.alfresco.repo.web.scripts.RepositoryContainer.executeScript(RepositoryContainer.java:261)
        at org.springframework.extensions.webscripts.AbstractRuntime.executeScript(AbstractRuntime.java:378)
        at org.springframework.extensions.webscripts.AbstractRuntime.executeScript(AbstractRuntime.java:209)
        at org.springframework.extensions.webscripts.servlet.WebScriptServlet.service(WebScriptServlet.java:132)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:727)
        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.web.app.servlet.GlobalLocalizationFilter.doFilter(GlobalLocalizationFilter.java:61)
        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:220)
        at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:122)
        at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:501)
        at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:170)
        at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:98)
        at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:950)
        at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:116)
        at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:408)
        at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1040)
        at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:607)
        at org.apache.tomcat.util.net.AprEndpoint$SocketWithOptionsProcessor.run(AprEndpoint.java:2378)
        at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
        at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
        at java.lang.Thread.run(Unknown Source)
‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍

Thx for your help.

Re: 5.0b & 5.0c- Previewing Microsoft Office documents doesn't work

hgindl — Tue, 09 Dec 2014 09:16:00 GMT

which operating system, prerequisit libraries installed?

Re: 5.0b & 5.0c- Previewing Microsoft Office documents doesn't work

legaulois — Tue, 09 Dec 2014 09:28:00 GMT

Hi,

The OS is CentOS 6.5.

All the libraries are installed :

[root@vslalfpro001 ~]# yum install libXrender libSM libICE libXext fontconfig cups-libs
Loaded plugins: fastestmirror
Loading mirror speeds from cached hostfile
* base: mirror.myip.be
* extras: mirror-fr2.bbln.org
* updates: mirror-fr2.bbln.org
Setting up Install Process
Package libXrender-0.9.8-2.1.el6.x86_64 already installed and latest version
Package libSM-1.2.1-2.el6.x86_64 already installed and latest version
Package libICE-1.0.6-1.el6.x86_64 already installed and latest version
Package libXext-1.3.2-2.1.el6.x86_64 already installed and latest version
Package fontconfig-2.8.0-5.el6.x86_64 already installed and latest version
Package 1:cups-libs-1.4.2-67.el6.x86_64 already installed and latest version
Nothing to do
[root@vslalfpro001 ~]#

With the default engine ooo.enabled=true when i want to display a Microsoft Office Doc, the field of preview of this document is blank

When I switch to the jodconverter, I get the message "this document can't be previewed".

Thx for your help.

Regards,

Re: 5.0b & 5.0c- Previewing Microsoft Office documents doesn't work

legaulois — Tue, 09 Dec 2014 10:25:29 GMT


2014-12-09 11:23:38,251  INFO  [web.scripts.MimetypesQuery] [http-apr-80-exec-4] Successfully retrieved mimetypes information from Alfresco.
 2014-12-09 11:23:45,453  ERROR [extensions.webscripts.AbstractRuntime] [http-apr-80-exec-9] Exception from executeScript - redirecting to status template error: 11090002 Wrapped Exception (with status templ
ate): connection failed: socket,host=localhost,port=8100,tcpNoDelay=1; com.sun.star.lang.IllegalArgumentException
 org.springframework.extensions.webscripts.WebScriptException: 11090002 Wrapped Exception (with status template): connection failed: socket,host=localhost,port=8100,tcpNoDelay=1; com.sun.star.lang.IllegalArg
umentException
        at org.springframework.extensions.webscripts.AbstractWebScript.createStatusException(AbstractWebScript.java:1126)
        at org.springframework.extensions.webscripts.DeclarativeWebScript.execute(DeclarativeWebScript.java:171)
        at org.alfresco.repo.web.scripts.RepositoryContainer$3.execute(RepositoryContainer.java:463)
        at org.alfresco.repo.transaction.RetryingTransactionHelper.doInTransaction(RetryingTransactionHelper.java:454)
        at org.alfresco.repo.web.scripts.RepositoryContainer.transactionedExecute(RepositoryContainer.java:532)
        at org.alfresco.repo.web.scripts.RepositoryContainer.transactionedExecuteAs(RepositoryContainer.java:600)
        at org.alfresco.repo.web.scripts.RepositoryContainer.executeScriptInternal(RepositoryContainer.java:380)
        at org.alfresco.repo.web.scripts.RepositoryContainer.executeScript(RepositoryContainer.java:261)
        at org.springframework.extensions.webscripts.AbstractRuntime.executeScript(AbstractRuntime.java:378)
        at org.springframework.extensions.webscripts.AbstractRuntime.executeScript(AbstractRuntime.java:209)
        at org.springframework.extensions.webscripts.servlet.WebScriptServlet.service(WebScriptServlet.java:132)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:727)
        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.web.app.servlet.GlobalLocalizationFilter.doFilter(GlobalLocalizationFilter.java:61)
        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:220)
        at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:122)
        at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:501)
        at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:170)
        at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:98)
        at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:950)
        at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:116)
        at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:408)
        at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1040)
        at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:607)
        at org.apache.tomcat.util.net.AprEndpoint$SocketProcessor.doRun(AprEndpoint.java:2441)
        at org.apache.tomcat.util.net.AprEndpoint$SocketProcessor.run(AprEndpoint.java:2430)
        at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
        at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
        at java.lang.Thread.run(Unknown Source)
Caused by: net.sf.jooreports.openoffice.connection.OpenOfficeException: connection failed: socket,host=localhost,port=8100,tcpNoDelay=1; com.sun.star.lang.IllegalArgumentException
        at net.sf.jooreports.openoffice.connection.AbstractOpenOfficeConnection.connect(AbstractOpenOfficeConnection.java:77)
        at org.alfresco.util.OpenOfficeConnectionTester.testAndConnect(OpenOfficeConnectionTester.java:183)
        at org.alfresco.util.OpenOfficeConnectionTester.checkConnection(OpenOfficeConnectionTester.java:129)
        at org.alfresco.util.OpenOfficeConnectionTester.onBootstrap(OpenOfficeConnectionTester.java:101)
        at org.springframework.extensions.surf.util.AbstractLifecycleBean.onApplicationEvent(AbstractLifecycleBean.java:56)
        at org.springframework.context.event.SimpleApplicationEventMulticaster.multicastEvent(SimpleApplicationEventMulticaster.java:96)
        at org.alfresco.repo.management.subsystems.ChildApplicationContextFactory$ChildApplicationContext.publishEvent(ChildApplicationContextFactory.java:554)
        at org.springframework.context.support.AbstractApplicationContext.finishRefresh(AbstractApplicationContext.java:948)
        at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:482)
        at org.alfresco.repo.management.subsystems.ChildApplicationContextFactory$ApplicationContextState.start(ChildApplicationContextFactory.java:809)
        at org.alfresco.repo.management.subsystems.AbstractPropertyBackedBean.start(AbstractPropertyBackedBean.java:1018)
        at org.alfresco.repo.management.subsystems.AbstractPropertyBackedBean.onApplicationEvent(AbstractPropertyBackedBean.java:557)
        at org.alfresco.repo.management.SafeApplicationEventMulticaster.multicastEventInternal(SafeApplicationEventMulticaster.java:209)
        at org.alfresco.repo.management.SafeApplicationEventMulticaster.multicastEvent(SafeApplicationEventMulticaster.java:180)
        at org.springframework.context.support.AbstractApplicationContext.publishEvent(AbstractApplicationContext.java:334)
        at org.springframework.context.support.AbstractApplicationContext.finishRefresh(AbstractApplicationContext.java:948)
        at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:482)
        at org.springframework.web.context.ContextLoader.configureAndRefreshWebApplicationContext(ContextLoader.java:410)
        at org.springframework.web.context.ContextLoader.initWebApplicationContext(ContextLoader.java:306)
        at org.springframework.web.context.ContextLoaderListener.contextInitialized(ContextLoaderListener.java:112)
        at org.alfresco.web.app.ContextLoaderListener.contextInitialized(ContextLoaderListener.java:63)
        at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:4973)
        at org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5467)
        at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:150)
        at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:901)
        at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:877)
        at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:632)
        at org.apache.catalina.startup.HostConfig.deployWAR(HostConfig.java:1073)
        at org.apache.catalina.startup.HostConfig$DeployWar.run(HostConfig.java:1857)
        at java.util.concurrent.Executors$RunnableAdapter.call(Unknown Source)
        at java.util.concurrent.FutureTask.run(Unknown Source)

‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍

Re: 5.0b & 5.0c- Previewing Microsoft Office documents doesn't work

hgindl — Tue, 09 Dec 2014 10:34:00 GMT

hows about libxinerama? Tried it using a fresh uploaded document?

Re: 5.0b & 5.0c- Previewing Microsoft Office documents doesn't work

legaulois — Thu, 11 Dec 2014 07:44:14 GMT

Yes, Libxinerama is installed

Re: 5.0b & 5.0c- Previewing Microsoft Office documents doesn't work

legaulois — Mon, 22 Dec 2014 13:44:36 GMT

Hello everybody,

my problem of preview is now solved with the information of this post :

http://forums.alfresco.com/forum/installation-upgrades-configuration-integration/configuration/libreoffice-extension-not

I've added a double quote into the libreoffice_ctl.sh

Regards,

Re: 5.0b & 5.0c- Previewing Microsoft Office documents doesn't work

axel_baudin — Mon, 09 Feb 2015 15:54:19 GMT

Hi,
can you past your libreoffice/scripts/ctl.sh (only "SOFFICE=" line) ?

I've got the same problem and i don't find why the connection failed…

Thanks