topic Re: Document preview broken in 4.2.b? in Alfresco Archive

Document preview broken in 4.2.b?

ttownsend — Thu, 01 Nov 2012 18:01:43 GMT

Hi all,I have a new 4.2.b/Ubuntu 12.04 install up and running, and have successfully migrated my previous 4.0.e db and alf_data to it.However, whenever I select a document from the Document Library it does not display. Per-MS filetype, here is what I see:1. The symbol from a broken image link in a

Re: Document preview broken in 4.2.b?

ttownsend — Mon, 05 Nov 2012 01:17:44 GMT

I solved it.

It seems that there needed to be some basic configuration changes made to the 4.2.x releases relating to the use of libreoffice.

The following all happened on dark and stormy night in an Alfresco 4.2.b/Ubuntu 12.04_64 server environment.

I could not find openoffice/libreoffice in 'top' or 'service –status-all' so I learned that openoffice server wasn't running.
So I looked in alfresco-4.2.b/alfresco.sh and found the entry for starting openoffice, which is OPENOFFICE_SCRIPT=$INSTALLDIR/libreoffice/scripts/ctl.sh
But since there is no file of this name (ctl.sh); it really refers to openoffice_ctl.sh, so I changed ctl.sh to openoffice_ctl.sh
Then I looked in alfresco-4.2.b/libreoffice/scripts and found openoffice_ctl.sh and did './openoffice_stl.sh status', which returned "open office not running".

Doing

'./alfresco.sh restart'‍

returned a

openoffice did not start‍

, so I found this link: http://wiki.alfresco.com/wiki/Running_OpenOffice_From_Terminal

From that link, I did

./soffice -nofirststartwizard -nologo -headless -accept=socket,host=localhost,port=8100;urp;StarOffice.ServiceManager‍

, which returned this:


/opt/alfresco-4.2.b/libreoffice/program/soffice.bin: error while loading shared libraries: libxineramag.so.1: cannot open shared object file: No such file or directory
No command 'urp' found, did you mean:
 Command 'arp' from package 'net-tools' (main)
 Command 'burp' from package 'burp' (universe)
 Command 'rup' from package 'rstat-client' (universe)
 Command 'unp' from package 'unp' (universe)
urp: command not found
StarOffice.ServiceManager: command not found
‍‍‍‍‍‍‍‍‍‍

So I went hunting for the missing shared library libxinerama.so.1

Further reading found a handy linux utility in Ubuntu called 'apt-file'.
When used as 'apt-file search <name of missing shared library>' returns the package that I needed to install to get that library.

I got it and used it to find the missing libraries, one-by-one.


apt-get install apt-file
apt-file update
apt-file search "missing library name"
‍‍‍‍‍

'apt-file search "missing library name"' returns the package name that includes the missing shared library, which in my case were these:

Missing Library:        ->      Package Name:
libxinerama.so.1        ->      libxinerama1
libfontconfig.so.1      ->      libfontconfig1
libXrender.so.1         ->      libxrender1
libSM.so6               ->      libsm6

Note that doing './soffice -nofirststartwizard -nologo -headless -accept=socket,host=localhost,port=8100;urp;StarOffice.ServiceManager' will throw an error each time a shared library is missing, naming that library.

After this, I again did './alfresco.sh restart', which returned
tomcat started
openoffice started
postgresql started

I went to a test site I created and selected .doc/.docx, .ppt/pptx, and .xls/.xlsx files and EACH ONE PREVIEWED CORRECTLY.

Since I kept notes on this as I went along I wrote up this post, took a snapshot of my VM, and had a beer. Okay, two beers.

Life is good - I hope this can help anyone with the same problem.

Cheers!

Re: Document preview broken in 4.2.b?

benlawrence — Fri, 07 Dec 2012 04:07:56 GMT

Really appreciate your post. Fixed the problem ok. Many thanks!

Re: Document preview broken in 4.2.b?

davik5 — Mon, 17 Dec 2012 16:04:01 GMT

Thanks for the fix, now the preview is working.
But this solution introduced another problem, the sboffice.bin process takes 99% of CPU costantly.

4220 root      20   0 483m 46m 30m S    99 1.2   1:27.86 soffice.bin
4124 root      20   0 3421m 1.0g 30m S   17 26.7   2:29.52 java
4165 postgres 20   0 59684 30m 25m S    3 0.8   0:09.90 postgres

Investigating about this problem, I have noticed that the sboffice.bin process start more than once.
One process is started by java process and the other one is started by the ./libreoffice/scripts/openoffice_ctl.sh script.

$ pstree -a
init
|-acpid -c /etc/acpi/events -s /var/run/acpid.socket
|-atd
|-cron
|-dbus-daemon –system –fork –activation=upstart
|-getty -8 38400 tty4
|-getty -8 38400 tty5
|-getty -8 38400 tty2
|-getty -8 38400 tty3
|-getty -8 38400 tty6
|-getty -8 38400 tty1
|-irqbalance
|-java -Djava.util.logging.config.file=/opt/alfresco-4.2.b/tomcat/conf/logging.properties -XX:MaxPermSize=512m -Xms128m -Xmx1024m-XX:-DisableExplicitG
|   |-soffice.bin –accept=socket,host=127.0.0.1,port=8100;urp;StarOffice.ServiceManager-env:UserInstallation=file:///opt/alfresco-4.2.b/alf_da
|   |   `-3*[{soffice.bin}]
|   `-128*[{java}]
|-postgres -D /opt/alfresco-4.2.b/alf_data/postgresql
|   |-postgres
|   |-postgres
|   |-postgres
|   |-postgres
|   |-postgres
|   |-postgres
|   |-postgres
|   |-postgres
|   |-postgres
|   |-postgres
|   |-postgres
|   |-postgres
|   `-postgres
|-rsyslogd -c5
|   `-3*[{rsyslogd}]
|-soffice.bin –nofirststartwizard –nologo –headless –accept=socket,host=localhost,port=8100;urp;StarOffice.ServiceManager
|   `-5*[{soffice.bin}]

To solve this problem I commented out the line in the script alfresco.sh that starts the sboffice process:
#OPENOFFICE_SCRIPT=$INSTALLDIR/libreoffice/scripts/openoffice_ctl.sh
and restarted Alfresco:
$ sudo service alfresco restart

Now the CPU utilization is coming back to normality, and only one process of sboffice is started under Java.
I think we have to satisfy the dependencies of the various packages to activate the sboffice, but do not enable the startup script sboffice.

Bye

Re: Document preview broken in 4.2.b?

michaelk — Thu, 24 Jan 2013 16:07:33 GMT

I get this after libreoffice tries to run…

terminate called after throwing an instance of 'com::sun::star::uno::RuntimeException'

I've installed all the required libraries. This is truely a 'headless' server (with no X display).

Does anyone have any clue as to what might be happening. Googling suggests removing some files in ~/.openoffice or ~/.config but I don't have these directories.

Re: Document preview broken in 4.2.b?

reva_12 — Wed, 13 Feb 2013 21:58:48 GMT

I just got StarOffice.ServiceManager - command not found, without any details on missing shared library.
Any other problem that you see?

Re: Document preview broken in 4.2.b?

profmikebroyles — Fri, 31 May 2013 20:13:59 GMT

For anyone running Alfresco 4.2.c and CentOS / RHEL 6.x:

- correct line 23 of alfresco.sh (as already indicated above)
- 'yum install' the following packages: libX11, fontconfig, libpng, libXrender, libXext, libSM

Then you can either restart alfresco entirely, or try to kick off the script manually (assuming you took the default install path):

]# /opt/alfresco-4.2.c/libreoffice/scripts/openoffice_ctl.sh start

Check to see if it's running:

]# netstat -tupln | grep office

Re: Document preview broken in 4.2.b?

hont_vn — Fri, 26 Jul 2013 05:03:47 GMT

My installation of 4.2.c on CentOS 6 worked perfectly with msoffice docs, but not with the MS Outlook file (.msg). Posted here: http://forums.alfresco.com/forum/end-user-discussions/alfresco-share/unable-preview-outlook-message-file-msg-alfresco-share

Anyone got the similar issue?

Re: Document preview broken in 4.2.b?

bch_firas — Thu, 29 Aug 2013 15:33:34 GMT

thanks for the solution it really helped me

Re: Document preview broken in 4.2.b?

flheide — Tue, 08 Oct 2013 07:31:46 GMT

From Alfresco 4.2 onwards, LibreOffice requires the following libraries to be installed on your system:

    libfontconfig.so
    libSM.so
    libICE.so
    libXrender.so
    libXext.so

http://docs.alfresco.com/community/index.jsp?topic=%2Fcom.alfresco.community.doc%2Fconcepts%2Finstall-lolibfiles.html

Re: Document preview broken in 4.2.b?

infsy — Fri, 11 Oct 2013 17:01:00 GMT

I confirm that on a 4.2.d community libXinerama1 is also required and also libdbus-glib-1-2 (Debian 7 x64). I didn't have this problem with 4.2.c, it appears after my alfresco server upgrade..

Thank's to this post, it's solved !

Re: Document preview broken in 4.2.b?

gangadharjwala — Tue, 29 Apr 2014 08:02:44 GMT

Hi all i have deployed alfresco.war and share.war files on JBOSS-EAP-6 successfully.but after uploading any doc,pdf,xls were not Previewing in share.And iam getting following ERROR in jboss server logs.

ERROR [org.springframework.extensions.webscripts.AbstractRuntime] (http-/10.0.0.98:8080-4) Exception from executeScript - redirecting to status template error: 03280001 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: 03280001 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.

And here i have installed OPENOFFICCE in my Linux and i am giving the path in repository.properties file as follows.

/WEB-INF/classes/alfresco/
repository.properties

ooo.exe=/opt/openoffice.org3/program/soffice
ooo.enabled=true
ooo.port=8100
ooo.user=${dir.root}/oouser
img.root=./ImageMagick
img.dyn=${img.root}/lib
img.exe=${img.root}/bin/convert
swf.exe=./bin/pdf2swf
swf.languagedir=.

jodconverter.enabled=true
jodconverter.officeHome=/opt/openoffice.org3/
jodconverter.portNumbers=8100

after this changes i am starting jboss server and i am able to sees the connection for alfresco and OpenOffice.

[root@localhost Alfresco]# ps aux | grep soffice
root      6829 0.2 2.8 752052 55244 pts/0    Sl+ 18:43   0:01 /opt/openoffice.org3/program/soffice.bin -accept=socket,host=127.0.0.1,port=8100;urp; -env:UserInstallation=file:///tmp/.jodconverter_socket_host-127.0.0.1_port-8100 -headless -nocrashreport -nodefault -nofirststartwizard -nolockcheck -nologo -norestore
root      6919 0.0 0.0 103244   812 pts/1    D+   18:51   0:00 grep soffice

[root@localhost alfresco]# netstat -alntp | grep 8100
tcp        0      0 127.0.0.1:8100              0.0.0.0:*                   LISTEN      6829/soffice.bin
tcp        0      0 127.0.0.1:8100              127.0.0.1:47483             ESTABLISHED 6829/soffice.bin
tcp        0      0 127.0.0.1:47483             127.0.0.1:8100              ESTABLISHED 6651/java

And after this i am logged in as a admin and iam uploading a doc,pdf,xls but when i previewed the doc is not previewing.

Please help me out on this for further.

Re: Document preview broken in 4.2.b?

gangadharjwala — Sat, 03 May 2014 08:19:20 GMT

Ya now it is working file for me …i configured the ImageMagik and swftools with alfresco. and i have removed the jodconverter line on repository.properties file

Re: Document preview broken in 4.2.b?

kino — Thu, 22 Jan 2015 08:50:59 GMT

Mr. <strong>TTownsend</strong>, thank you. Your post is very good and total answer for how-to-start-libreoffice question.
It's helpfull even for 5.0.c Community version.

Re: Document preview broken in 4.2.b?

dvieira — Mon, 26 Jan 2015 19:56:40 GMT

I tested the above, but nothing seems to work on Alfresco 5.0c.

I done and easy install on a headless server Ubuntu 14. At the begining I had no preview other that of images and pdfs.

I tested the above with the libreoffice inside the folder , with the jave included, with Java 8 and i get the same error "Failure: Unexpected error occurred during upload of new co…" whenever I upload a file.

I even installed the new libreoffice and pointefd the old script to the new install folder, but the result was the same….

I dont knwo where to search more

Thanks

Re: Document preview broken in 4.2.b?

a_uchi — Thu, 05 Mar 2015 00:56:15 GMT

Hello,

I got same things on Alfresco 5.0.c.
Still not working.

Whenever i tried to preview, i got ERROR like below.
ERROR [org.springframework.extensions.webscripts.AbstractRuntime] [http-apr-8080-exec-7] Exception from executeScript - redirecting to status template error: 02040005 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: 02040005 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$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)

i have no idea more.
Any idea?

Thank you,

Re: Document preview broken in 4.2.b?

ttownsend — Mon, 21 Mar 2016 12:52:03 GMT

Hi folks,

That was a good fix for 4.2.x, but it seems that previews are now broken in 5.0.c CE also (Ubuntu 14.04).

Does anyone have a fix, or suggest one?

Here's the error I'm getting now…


2016-03-17 22:48:37,954  ERROR [extensions.webscripts.AbstractRuntime] [http-apr-8080-exec-3] Exception from executeScript - redirecting to status template error: 02170004 The content node was not specified o the content cannot be streamed to the client: classpath*:alfresco/templates/webscripts/org/alfresco/repository/thumbnail/thumbnail.get.js
 org.springframework.extensions.webscripts.WebScriptException: 02170004 The content node was not specified so the content cannot be streamed to the client: classpath*:alfresco/templates/webscripts/org/alfreso/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)
‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍

Re: Document preview broken in 4.2.b?

novajim — Thu, 23 Jun 2016 17:03:46 GMT

Did you ever find a solution to this issue? I'm having the same problem.