четверг, 16 апреля 2015 г.

Transformation problems in Alfresco 5.0.d and Ubuntu 14.04

Problem:

After uploading Microsoft documents you can't preview it in Alfresco and in catalina.out you see the following error:

  
ERROR [extensions.webscripts.AbstractRuntime] [http-apr-8080-exec-7] Exception from executeScript - redirecting to status template error: 03160000 The content node was not specified so the content cannot be stre
amed to the client: classpath*:alfresco/templates/webscripts/org/alfresco/repository/thumbnail/thumbnail.get.js
 org.springframework.extensions.webscripts.WebScriptException: 03160000 The content node was not specified so the content cannot be streamed to the client: classpath*:alfresco/templates/webscripts/org/alfresco/repository/thumbnail/thumbn
ail.get.js
        at org.alfresco.repo.web.scripts.content.StreamContent.execute(StreamContent.java:169)
        at org.alfresco.repo.web.scripts.RepositoryContainer$3.execute(RepositoryContainer.java:482)
        at org.alfresco.repo.transaction.RetryingTransactionHelper.doInTransaction(RetryingTransactionHelper.java:457)
        at org.alfresco.repo.web.scripts.RepositoryContainer.transactionedExecute(RepositoryContainer.java:551)
        at org.alfresco.repo.web.scripts.RepositoryContainer.transactionedExecuteAs(RepositoryContainer.java:619)
        at org.alfresco.repo.web.scripts.RepositoryContainer.executeScriptInternal(RepositoryContainer.java:399)
        at org.alfresco.repo.web.scripts.RepositoryContainer.executeScript(RepositoryContainer.java:280)
        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:504)
        at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:170)
        at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:103)
        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:421)
        at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1074)
        at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:611)
        at org.apache.tomcat.util.net.AprEndpoint$SocketWithOptionsProcessor.run(AprEndpoint.java:2403)
        at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
        at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
        at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
        at java.lang.Thread.run(Thread.java:745)
2015-04-16 12:43:00,357  WARN  [alfresco.util.OpenOfficeConnectionTester] [DefaultScheduler_Worker-5] Error trying to query Open Office version information. OpenOffice.org's ConfigurationRegistry not implemented in this version of OOo. T
his should not affect the operation of OOo.

Solution:

First of all install required libraries for libreoffice:

sudo apt-get install libice6 libsm6 libxt6 libxrender1 libxinerama libfontconfig1 libcups2

If you got error during installation like:

E: Unable to locate package libxinerama

then try to install the following packages instead of libxinerama:

apt-get install libxinerama-dev libxft-dev libxi-dev

After checking dependencies you need to do next:

1) Go to alfresco->libreoffice->scripts folder

cd {patrh_to_alfresco}/libreoffice/scripts

2) Open file libreoffice_ctl.sh by using some text editor (I prefer mceditor)

sudo mcedit libreoffice_ctl.sh

3) Find the following line:

SOFFICE="$SOFFICEWRAPPER --nofirststartwizard --nologo --headless --accept=socket,host=localhost,port=$SOFFICE_PORT\;urp\;StarOffice.ServiceManager"

4) Remove backslashes (this characters "\") from this line and save. After your changes it should looks like the following string:

SOFFICE="$SOFFICEWRAPPER --nofirststartwizard --nologo --headless --accept=socket,host=localhost,port=$SOFFICE_PORT;urp;StarOffice.ServiceManager"

5) Start soffice
sudo libreoffice_ctl.sh start

7 комментариев :

  1. Maybe you didn't install required libs for libreoffice, check the following link http://docs.alfresco.com/4.2/concepts/install-lolibfiles.html

    ОтветитьУдалить
  2. Hi Sergey - I am getting this issue with Alfresco 5.2 community, running on Ubuntu 16.04 and 18.04. I have followed your steps above, but same problem. I only get this on some Excel files -- other excel files preview fine. Any ideas?

    ОтветитьУдалить
    Ответы
    1. Try to run the following commands:

      sudo apt-get install libice6 libsm6 libxt6 libxrender1 libfontconfig1 libcups2 libglu1-mesa libcairo2 libgl1-mesa-glx
      cd /usr/lib/x86_64-linux-gnu
      ln -s mesa/libGL.so.1 ./libGL.so.1

      Удалить
  3. No luck! Same issue.
    2018-12-28 16:12:50,718 INFO [web.scripts.MimetypesQuery] [http-apr-8080-exec-9] Successfully retrieved mimetypes information from Alfresco.
    2018-12-28 16:12:55,331 ERROR [extensions.webscripts.AbstractRuntime] [http-apr-8080-exec-11] Exception from executeScript: 11280001 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: 11280001 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)

    ОтветитьУдалить
    Ответы
    1. Also - the last step had failed.
      ln -s mesa/libGL.so.1 ./libGL.so.1

      folder called "mesa" doesn't exist
      And libGL.so.1 already links to libGL.so.1.7.0

      Удалить
    2. It seems you missed something. It requires research of the problem and, it is impossible to help without access to the server. Our company provides Alfresco Consulting and Administration services, so if need help - contact us via the site - www.flex-solution.com

      Удалить