cancel
Showing results for 
Search instead for 
Did you mean: 

4.0a Linux : Preview OpenOffice not working

dranakan
Champ on-the-rise
Champ on-the-rise
Hello,

I get problem to show the preview from docx with Alfresco 4.0a /Rhel 5.6 64 bits / Mysql 5.0.77. The preview with PDF is working.
When I upload a document.docx the preview does not work…

alfresco-global.properties
ooo.exe=/opt/alfresco-4.0.a/openoffice/program/soffice.bin
ooo.enabled=true
ooo.port=8100
ooo.port=8100
img.root=/opt/alfresco-4.0.a/common
img.dyn=${img.root}/lib
img.exe=${img.root}/bin/convert
swf.exe=/opt/alfresco-4.0.a/common/bin/pdf2swf
jodconverter.enabled=false
jodconverter.officeHome=/opt/alfresco-4.0.a/openoffice
jodconverter.portNumbers=8100

soffice is started (top)
alfresco  6810 43.1 25.8 1764968 799772 ?      Sl   14:52   1:39 /opt/alfresco-4.0.a/java/bin/java -Djava.util.logging.config.file=/opt/alfresco-4.0.a/tomcat/conf/logging.properties -XX:MaxPermSize=512m -Xms128m -Xmx768m -Dalfresco.home=/opt/alfresco-4.0.a -Dcom.sun.management.jmxremote -Dsun.security.ssl.allowUnsafeRenegotiation=true -Djava.util.logging.manager=org.apache.juli.ClassLoaderLogManager -Djava.endorsed.dirs=/opt/alfresco-4.0.a/tomcat/endorsed -classpath /opt/alfresco-4.0.a/tomcat/bin/bootstrap.jar -Dcatalina.base=/opt/alfresco-4.0.a/tomcat -Dcatalina.home=/opt/alfresco-4.0.a/tomcat -Djava.io.tmpdir=/opt/alfresco-4.0.a/tomcat/temp org.apache.catalina.startup.Bootstrap start

alfresco  6911  0.0  1.3 350504 40916 ?        Sl   14:52   0:00 /opt/alfresco-4.0.a/openoffice/program/soffice.bin -accept=socket,host=127.0.0.1,port=8100;urp;StarOffice.ServiceManager -env:UserInstallation=file:///opt/alfresco-4.0.a/alf_data/oouser -nologo -headless -nofirststartwizard -nocrashrep -norestore

Error log. After click to show the document.docx
2011-10-20 14:57:18,093  ERROR [extensions.webscripts.AbstractRuntime] [http-8080-3] Exception from executeScript - redirecting to status template error: 09200002 Wrapped Exception (with status template): 09200014 Failed to execute script 'classpath*:alfresco/templates/webscripts/org/alfresco/repository/thumbnail/thumbnail.get.js': 09200013 Content conversion failed:
   reader: ContentAccessor[ contentUrl=store://2011/10/20/14/11/ffb8aaa9-a312-4f00-922c-3d1694f37df0.bin, mimetype=application/vnd.openxmlformats-officedocument.wordprocessingml.document, size=344415, encoding=UTF-8, locale=fr_CH]
   writer: ContentAccessor[ contentUrl=store://2011/10/20/14/57/c269aeda-d02c-483d-8b18-6f1cd0f7fc25.bin, mimetype=application/x-shockwave-flash, size=0, encoding=UTF-8, locale=fr_CH]
   options: org.alfresco.service.cmr.repository.TransformationOptions@63de91c5
org.springframework.extensions.webscripts.WebScriptException: 09200002 Wrapped Exception (with status template): 09200014 Failed to execute script 'classpath*:alfresco/templates/webscripts/org/alfresco/repository/thumbnail/thumbnail.get.js': 09200013 Content conversion failed:
   reader: ContentAccessor[ contentUrl=store://2011/10/20/14/11/ffb8aaa9-a312-4f00-922c-3d1694f37df0.bin, mimetype=application/vnd.openxmlformats-officedocument.wordprocessingml.document, size=344415, encoding=UTF-8, locale=fr_CH]
   writer: ContentAccessor[ contentUrl=store://2011/10/20/14/57/c269aeda-d02c-483d-8b18-6f1cd0f7fc25.bin, mimetype=application/x-shockwave-flash, size=0, encoding=UTF-8, locale=fr_CH]
   options: org.alfresco.service.cmr.repository.TransformationOptions@63de91c5
        at org.springframework.extensions.webscripts.AbstractWebScript.createStatusException(AbstractWebScript.java:884)
        at org.alfresco.repo.web.scripts.content.StreamContent.execute(StreamContent.java:211)
        at org.alfresco.repo.web.scripts.RepositoryContainer$2.execute(RepositoryContainer.java:400)
        at org.alfresco.repo.transaction.RetryingTransactionHelper.doInTransaction(RetryingTransactionHelper.java:388)
        at org.alfresco.repo.web.scripts.RepositoryContainer.transactionedExecute(RepositoryContainer.java:462)
        at org.alfresco.repo.web.scripts.RepositoryContainer.transactionedExecuteAs(RepositoryContainer.java:500)
        at org.alfresco.repo.web.scripts.RepositoryContainer.executeScript(RepositoryContainer.java:316)
        at org.springframework.extensions.webscripts.AbstractRuntime.executeScript(AbstractRuntime.java:352)
        at org.springframework.extensions.webscripts.AbstractRuntime.executeScript(AbstractRuntime.java:189)
        at org.springframework.extensions.webscripts.servlet.WebScriptServlet.service(WebScriptServlet.java:118)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
        at org.alfresco.web.app.servlet.GlobalLocalizationFilter.doFilter(GlobalLocalizationFilter.java:58)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
        at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
        at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
        at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:465)
        at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
        at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
        at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
        at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:298)
        at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:852)
        at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:588)
        at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489)
        at java.lang.Thread.run(Thread.java:619)
Caused by: org.alfresco.scripts.ScriptException: 09200014 Failed to execute script 'classpath*:alfresco/templates/webscripts/org/alfresco/repository/thumbnail/thumbnail.get.js': 09200013 Content conversion failed:
   reader: ContentAccessor[ contentUrl=store://2011/10/20/14/11/ffb8aaa9-a312-4f00-922c-3d1694f37df0.bin, mimetype=application/vnd.openxmlformats-officedocument.wordprocessingml.document, size=344415, encoding=UTF-8, locale=fr_CH]
   writer: ContentAccessor[ contentUrl=store://2011/10/20/14/57/c269aeda-d02c-483d-8b18-6f1cd0f7fc25.bin, mimetype=application/x-shockwave-flash, size=0, encoding=UTF-8, locale=fr_CH]
   options: org.alfresco.service.cmr.repository.TransformationOptions@63de91c5
        at org.alfresco.repo.jscript.RhinoScriptProcessor.execute(RhinoScriptProcessor.java:195)
        at org.alfresco.repo.processor.ScriptServiceImpl.executeScript(ScriptServiceImpl.java:282)
        at org.alfresco.repo.web.scripts.RepositoryScriptProcessor.executeScript(RepositoryScriptProcessor.java:102)
        at org.springframework.extensions.webscripts.AbstractWebScript.executeScript(AbstractWebScript.java:1107)
        at org.alfresco.repo.web.scripts.content.StreamContent.execute(StreamContent.java:155)
        … 25 more
Caused by: org.alfresco.service.cmr.repository.ContentIOException: 09200013 Content conversion failed:
   reader: ContentAccessor[ contentUrl=store://2011/10/20/14/11/ffb8aaa9-a312-4f00-922c-3d1694f37df0.bin, mimetype=application/vnd.openxmlformats-officedocument.wordprocessingml.document, size=344415, encoding=UTF-8, locale=fr_CH]
   writer: ContentAccessor[ contentUrl=store://2011/10/20/14/57/c269aeda-d02c-483d-8b18-6f1cd0f7fc25.bin, mimetype=application/x-shockwave-flash, size=0, encoding=UTF-8, locale=fr_CH]
   options: org.alfresco.service.cmr.repository.TransformationOptions@63de91c5
        at org.alfresco.repo.content.transform.AbstractContentTransformer2.transform(AbstractContentTransformer2.java:177)
        at org.alfresco.repo.content.ContentServiceImpl.transform(ContentServiceImpl.java:569)
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
        at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
        at java.lang.reflect.Method.invoke(Method.java:597)
        at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:309)
        at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:183)
        at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:150)
        at net.sf.acegisecurity.intercept.method.aopalliance.MethodSecurityInterceptor.invoke(MethodSecurityInterceptor.java:80)
        at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
        at org.alfresco.repo.model.ml.MLContentInterceptor.invoke(MLContentInterceptor.java:125)
        at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
        at org.alfresco.repo.security.permissions.impl.ExceptionTranslatorMethodInterceptor.invoke(ExceptionTranslatorMethodInterceptor.java:44)
        at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
        at org.alfresco.repo.audit.AuditMethodInterceptor.invoke(AuditMethodInterceptor.java:146)
        at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
        at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:110)
        at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
        at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:202)
        at $Proxy51.transform(Unknown Source)
        at org.alfresco.repo.rendition.executer.AbstractTransformationRenderingEngine.render(AbstractTransformationRenderingEngine.java:71)
        at org.alfresco.repo.rendition.executer.AbstractRenderingEngine.executeRenditionImpl(AbstractRenderingEngine.java:494)
        at org.alfresco.repo.rendition.executer.AbstractRenderingEngine$1.doWork(AbstractRenderingEngine.java:426)
        at org.alfresco.repo.rendition.executer.AbstractRenderingEngine$1.doWork(AbstractRenderingEngine.java:406)
        at org.alfresco.repo.security.authentication.AuthenticationUtil.runAs(AuthenticationUtil.java:519)
        at org.alfresco.repo.rendition.executer.AbstractRenderingEngine.executeImpl(AbstractRenderingEngine.java:405)
        at org.alfresco.repo.rendition.executer.AbstractRenderingEngine.executeImpl(AbstractRenderingEngine.java:369)
        at org.alfresco.repo.action.executer.ActionExecuterAbstractBase.execute(ActionExecuterAbstractBase.java:196)
        at org.alfresco.repo.action.ActionServiceImpl.directActionExecution(ActionServiceImpl.java:780)
        at org.alfresco.repo.action.ActionServiceImpl.executeActionImpl(ActionServiceImpl.java:700)
        at org.alfresco.repo.action.ActionServiceImpl.executeAction(ActionServiceImpl.java:538)
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
        at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
        at java.lang.reflect.Method.invoke(Method.java:597)
        at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:309)
        at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:183)
        at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:150)
        at org.alfresco.repo.security.permissions.impl.AlwaysProceedMethodInterceptor.invoke(AlwaysProceedMethodInterceptor.java:34)
        at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
        at org.alfresco.repo.security.permissions.impl.ExceptionTranslatorMethodInterceptor.invoke(ExceptionTranslatorMethodInterceptor.java:44)
        at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
        at org.alfresco.repo.audit.AuditMethodInterceptor.invoke(AuditMethodInterceptor.java:146)
        at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
        at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:110)
        at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
        at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:202)
        at $Proxy37.executeAction(Unknown Source)
        at org.alfresco.repo.rendition.RenditionServiceImpl.executeRenditionAction(RenditionServiceImpl.java:281)
        at org.alfresco.repo.rendition.RenditionServiceImpl.render(RenditionServiceImpl.java:183)
        at org.alfresco.repo.thumbnail.ThumbnailServiceImpl.createThumbnailNode(ThumbnailServiceImpl.java:592)
        at org.alfresco.repo.thumbnail.ThumbnailServiceImpl.access$000(ThumbnailServiceImpl.java:67)
        at org.alfresco.repo.thumbnail.ThumbnailServiceImpl$1.doWork(ThumbnailServiceImpl.java:248)
        at org.alfresco.repo.thumbnail.ThumbnailServiceImpl$1.doWork(ThumbnailServiceImpl.java:245)
        at org.alfresco.repo.security.authentication.AuthenticationUtil.runAs(AuthenticationUtil.java:519)
        at org.alfresco.repo.thumbnail.ThumbnailServiceImpl.createThumbnail(ThumbnailServiceImpl.java:243)
        at org.alfresco.repo.thumbnail.ThumbnailServiceImpl.createThumbnail(ThumbnailServiceImpl.java:222)
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
        at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
        at java.lang.reflect.Method.invoke(Method.java:597)
        at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:309)
        at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:183)
        at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:150)
        at org.alfresco.repo.security.permissions.impl.AlwaysProceedMethodInterceptor.invoke(AlwaysProceedMethodInterceptor.java:34)
        at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
        at org.alfresco.repo.security.permissions.impl.ExceptionTranslatorMethodInterceptor.invoke(ExceptionTranslatorMethodInterceptor.java:44)
        at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
        at org.alfresco.repo.audit.AuditMethodInterceptor.invoke(AuditMethodInterceptor.java:146)
        at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
        at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:110)
        at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
        at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:202)
        at $Proxy122.createThumbnail(Unknown Source)
        at org.alfresco.repo.jscript.ScriptNode.createThumbnail(ScriptNode.java:2682)
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
        at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
        at java.lang.reflect.Method.invoke(Method.java:597)
        at org.mozilla.javascript.MemberBox.invoke(MemberBox.java:155)
        at org.mozilla.javascript.NativeJavaMethod.call(NativeJavaMethod.java:243)
        at org.mozilla.javascript.optimizer.OptRuntime.call2(OptRuntime.java:76)
        at org.mozilla.javascript.gen.c8._c1(file:/opt/alfresco-4.0.a/tomcat/webapps/alfresco/WEB-INF/classes/alfresco/templates/webscripts/org/alfresco/repository/thumbnail/thumbnail.get.js:68)
        at org.mozilla.javascript.gen.c8.call(file:/opt/alfresco-4.0.a/tomcat/webapps/alfresco/WEB-INF/classes/alfresco/templates/webscripts/org/alfresco/repository/thumbnail/thumbnail.get.js)
        at org.mozilla.javascript.optimizer.OptRuntime.callName0(OptRuntime.java:108)
        at org.mozilla.javascript.gen.c8._c0(file:/opt/alfresco-4.0.a/tomcat/webapps/alfresco/WEB-INF/classes/alfresco/templates/webscripts/org/alfresco/repository/thumbnail/thumbnail.get.js:109)
        at org.mozilla.javascript.gen.c8.call(file:/opt/alfresco-4.0.a/tomcat/webapps/alfresco/WEB-INF/classes/alfresco/templates/webscripts/org/alfresco/repository/thumbnail/thumbnail.get.js)
        at org.mozilla.javascript.ContextFactory.doTopCall(ContextFactory.java:393)
        at org.mozilla.javascript.ScriptRuntime.doTopCall(ScriptRuntime.java:2834)
        at org.mozilla.javascript.gen.c8.call(file:/opt/alfresco-4.0.a/tomcat/webapps/alfresco/WEB-INF/classes/alfresco/templates/webscripts/org/alfresco/repository/thumbnail/thumbnail.get.js)
        at org.mozilla.javascript.gen.c8.exec(file:/opt/alfresco-4.0.a/tomcat/webapps/alfresco/WEB-INF/classes/alfresco/templates/webscripts/org/alfresco/repository/thumbnail/thumbnail.get.js)
        at org.alfresco.repo.jscript.RhinoScriptProcessor.executeScriptImpl(RhinoScriptProcessor.java:483)
        at org.alfresco.repo.jscript.RhinoScriptProcessor.execute(RhinoScriptProcessor.java:191)
        … 29 more
Caused by: org.alfresco.service.cmr.repository.ContentIOException: 09200012 Content conversion failed:
   reader: ContentAccessor[ contentUrl=store://2011/10/20/14/11/ffb8aaa9-a312-4f00-922c-3d1694f37df0.bin, mimetype=application/vnd.openxmlformats-officedocument.wordprocessingml.document, size=344415, encoding=UTF-8, locale=fr_CH]
   writer: ContentAccessor[ contentUrl=store:///opt/alfresco-4.0.a/tomcat/temp/Alfresco/ComplextTransformer_intermediate_docx_3927811950814126241.pdf, mimetype=application/pdf, size=0, encoding=UTF-8, locale=fr_CH]
   options: org.alfresco.service.cmr.repository.TransformationOptions@63de91c5
        at org.alfresco.repo.content.transform.AbstractContentTransformer2.transform(AbstractContentTransformer2.java:177)
        at org.alfresco.repo.content.transform.ComplexContentTransformer.transformInternal(ComplexContentTransformer.java:247)
        at org.alfresco.repo.content.transform.AbstractContentTransformer2.transform(AbstractContentTransformer2.java:161)
        … 122 more
Caused by: org.alfresco.service.cmr.repository.ContentIOException: 09200011 OpenOffice server conversion failed:
   reader: ContentAccessor[ contentUrl=store://2011/10/20/14/11/ffb8aaa9-a312-4f00-922c-3d1694f37df0.bin, mimetype=application/vnd.openxmlformats-officedocument.wordprocessingml.document, size=344415, encoding=UTF-8, locale=fr_CH]
   writer: ContentAccessor[ contentUrl=store:///opt/alfresco-4.0.a/tomcat/temp/Alfresco/ComplextTransformer_intermediate_docx_3927811950814126241.pdf, mimetype=application/pdf, size=0, encoding=UTF-8, locale=fr_CH]
   from file: /opt/alfresco-4.0.a/tomcat/temp/Alfresco/OpenOfficeContentTransformer-source-5573145954784265268.docx
   to file: /opt/alfresco-4.0.a/tomcat/temp/Alfresco/OpenOfficeContentTransformer-target-5300881624445144960.pdf
        at org.alfresco.repo.content.transform.OpenOfficeContentTransformerWorker.transform(OpenOfficeContentTransformerWorker.java:249)
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
        at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
        at java.lang.reflect.Method.invoke(Method.java:597)
        at org.alfresco.repo.management.subsystems.SubsystemProxyFactory$1.invoke(SubsystemProxyFactory.java:65)
        at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
        at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:202)
        at $Proxy11.transform(Unknown Source)
        at org.alfresco.repo.content.transform.ProxyContentTransformer.transformInternal(ProxyContentTransformer.java:68)
        at org.alfresco.repo.content.transform.AbstractContentTransformer2.transform(AbstractContentTransformer2.java:161)
        … 124 more
Caused by: net.sf.jooreports.openoffice.connection.OpenOfficeException: conversion failed; com.sun.star.lang.DisposedException: java.io.IOException: com.sun.star.io.IOException: EOF reached - socket,host=localhost,port=8100,tcpNoDelay=1,localHost=localhost.localdomain,localPort=38983,peerHost=localhost,peerPort=8100
        at net.sf.jooreports.openoffice.converter.OpenOfficeDocumentConverter.convertInternal(OpenOfficeDocumentConverter.java:114)
        at net.sf.jooreports.openoffice.converter.AbstractOpenOfficeDocumentConverter.convert(AbstractOpenOfficeDocumentConverter.java:75)
        at org.alfresco.repo.content.transform.OpenOfficeContentTransformerWorker.transform(OpenOfficeContentTransformerWorker.java:244)
        … 134 more
2011-10-20 14:57:18,533  WARN  [webscripts.connector.RemoteClient] [http-8080-1] Exception during close() of HTTP API connection
ClientAbortException:  java.net.SocketException: Broken pipe
        at org.apache.catalina.connector.OutputBuffer.realWriteBytes(OutputBuffer.java:358)
        at org.apache.tomcat.util.buf.ByteChunk.flushBuffer(ByteChunk.java:434)
        at org.apache.catalina.connector.OutputBuffer.doFlush(OutputBuffer.java:309)
        at org.apache.catalina.connector.OutputBuffer.close(OutputBuffer.java:273)
        at org.apache.catalina.connector.CoyoteOutputStream.close(CoyoteOutputStream.java:104)
        at org.springframework.extensions.webscripts.connector.RemoteClient.service(RemoteClient.java:956)
        at org.springframework.extensions.webscripts.connector.RemoteClient.call(RemoteClient.java:498)
        at org.springframework.extensions.webscripts.connector.HttpConnector.call(HttpConnector.java:136)
        at org.springframework.extensions.webscripts.connector.AuthenticatingConnector.call(AuthenticatingConnector.java:289)
        at org.springframework.extensions.webscripts.servlet.mvc.EndPointProxyController.handleRequestInternal(EndPointProxyController.java:273)
        at org.springframework.web.servlet.mvc.AbstractController.handleRequest(AbstractController.java:153)
        at org.springframework.web.servlet.mvc.SimpleControllerHandlerAdapter.handle(SimpleControllerHandlerAdapter.java:48)
        at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:790)
        at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:719)
        at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:644)
        at org.springframework.web.servlet.FrameworkServlet.doGet(FrameworkServlet.java:549)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:617)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
        at org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.java:646)
        at org.apache.catalina.core.ApplicationDispatcher.processRequest(ApplicationDispatcher.java:436)
        at org.apache.catalina.core.ApplicationDispatcher.doForward(ApplicationDispatcher.java:374)
        at org.apache.catalina.core.ApplicationDispatcher.forward(ApplicationDispatcher.java:302)
        at org.tuckey.web.filters.urlrewrite.NormalRewrittenUrl.doRewrite(NormalRewrittenUrl.java:195)
        at org.tuckey.web.filters.urlrewrite.RuleChain.handleRewrite(RuleChain.java:159)
        at org.tuckey.web.filters.urlrewrite.RuleChain.doRules(RuleChain.java:141)
        at org.tuckey.web.filters.urlrewrite.UrlRewriter.processRequest(UrlRewriter.java:90)
        at org.tuckey.web.filters.urlrewrite.UrlRewriteFilter.doFilter(UrlRewriteFilter.java:417)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
        at org.alfresco.web.site.servlet.SSOAuthenticationFilter.doFilter(SSOAuthenticationFilter.java:303)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
        at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
        at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
        at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
        at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
        at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
        at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:298)
        at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:852)
        at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:588)
        at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489)
        at java.lang.Thread.run(Thread.java:619)
Caused by: java.net.SocketException: Broken pipe
        at java.net.SocketOutputStream.socketWrite0(Native Method)
        at java.net.SocketOutputStream.socketWrite(SocketOutputStream.java:92)
        at java.net.SocketOutputStream.write(SocketOutputStream.java:136)
        at org.apache.coyote.http11.InternalOutputBuffer.realWriteBytes(InternalOutputBuffer.java:741)
        at org.apache.tomcat.util.buf.ByteChunk.flushBuffer(ByteChunk.java:434)
        at org.apache.tomcat.util.buf.ByteChunk.append(ByteChunk.java:349)
        at org.apache.coyote.http11.InternalOutputBuffer$OutputStreamOutputBuffer.doWrite(InternalOutputBuffer.java:765)
        at org.apache.coyote.http11.filters.ChunkedOutputFilter.doWrite(ChunkedOutputFilter.java:124)
        at org.apache.coyote.http11.InternalOutputBuffer.doWrite(InternalOutputBuffer.java:574)
        at org.apache.coyote.Response.doWrite(Response.java:560)
        at org.apache.catalina.connector.OutputBuffer.realWriteBytes(OutputBuffer.java:353)
        … 43 more

After that the process soffice is not working on the system… (no visible with "top")

Does someone have the same problem ?

Problem on JIRA : https://issues.alfresco.com/jira/browse/ALF-10993

Thank you
18 REPLIES 18

nickbsd
Champ in-the-making
Champ in-the-making
For all of you who are unable to get the new Microsoft Office 2010 documents to open in Alfresco/Share you'll need to upgrade your Open Office to version 3.3.0.

I was able to do the following which resolved my problem:

OS: CentOS 64bit
Linux ALF 2.6.32-220.7.1.el6.x86_64 #1 SM

Install OpenOffice via console:

  yum install openoffice.org-writer
  yum install openoffice.org-calc
  yum install openoffice.org-draw openoffice.org-impress

Rename the old soffice.bin file.

  mv /opt/alfresco/openoffice/program/soffice.bin /opt/alfresco/openoffice/program/soffice.bin.old

Locate the newly compiled/installed soffice.bin; in my case it was located at: /usr/lib64/openoffice.org3/program/soffice.bin
  To find your soffice.bin use the following command: "find / -name soffice.bin"

Once found, copy it to the Alfresco OpenOffice program folder:
  cp /usr/lib64/openoffice.org3/program/soffice.bin /opt/alfresco/openoffice/program/soffice.bin

Restart Alfresco

./opt/alfresco/alfresco.sh restart

smelis
Champ in-the-making
Champ in-the-making
To anyone trying this. I had to do some extra work to get the above fix to work.

Intall libre office as per the above (yum install openoffice.org-writer etc.)
AND do "yum install openoffice.org-headless" (or your distros equivelant)

Edit the ctl.sh script in /opt/alfresco/openoffice/scripts (where /opt/alfresco is your alfresco install dir)
Change the line at the top that says "SOFFICE="$SOFFICEBIN […]" to

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

Also, it did not work for me to make symbolic link to the soffice.bin executable. Instead I had to make a symbolic link to the libreoffice directory.
So I did "mv /opt/alfresco/openoffice/program /opt/alfresco/openoffice/program.old" and then "ln /usr/lib64/libreoffice/program /opt/alfresco/openoffice/program"

For me the latest libre office works much better than the (alfres)co-installed openoffice.

cbernardi
Champ in-the-making
Champ in-the-making
I'm working on alfresco 4.0.d community with alfresco installer (Centos 64bit) so I prefered to "pack" the new version of openoffice/libreoffice within Alfresco installation folder.
That worked for me:

1) Install 3.2.+ version of libreoffice: (yum install openoffice.org-writer openoffice.org-calc openoffice.org-draw openoffice.org-impress openoffice.org-headless)
2) Locate path of installed version of libreoffice (for me /usr/lib64/libreoffice)
3) Copy libreoffice installation folder into alfresco folder (cp -r /usr/lib64/libreoffice <alfresco_home>)
4) Copy script folder from old installation of openoffice to libreoffice folder (cp -r <alfresco_home>/openoffice/scripts <alfresco_home>/libreoffice)
5) Edit <alfresco_home>/libreoffice/scripts/ctl.sh:
   from
   
SOFFICE_PATH="<alfresco_home>/openoffice/program"
   SOFFICE_PORT="8100"
   SOFFICEBIN=<alfresco_home>/openoffice/program/soffice.bin
   
   to
   
SOFFICE_PATH="<alfresco_home>/libreoffice/program"
   SOFFICE_PORT="8100"
   SOFFICEBIN=<alfresco_home>/libreoffice/program/soffice.bin
6) Rename old openoffice installation folder (mv <alfresco_home>/openoffice <alfresco_home>/openofficeOLD)
7) Create a symbolic link to libreoffice folder named openoffice (ln -s <alfresco_home>/libreoffice/ <alfresco_home>/openoffice)

Hope this helps

dranakan
Champ on-the-rise
Champ on-the-rise
Thank you for your help. LibreOffice 3.6.1 is working for me.

I try to install from last version :

 
#http://www.libreoffice.org/download/
tar -xvf LibO_3.6.1_Linux_x86-64_install-rpm_en-US.tar.gz
cd LibO_3.6.1.4_Linux_x86-64_install-rpm_en-US/RPMS
rpm -Uvh *.rpm
# Errors with  dict-en, dict-fr… continue…
cp -r /opt/libreoffice3.6 /opt/Alfresco/libreoffice
cp -r /opt/Alfresco/openoffice/scripts /opt/Alfresco/libreoffice/

I don't know how openoffice is started out of box… If I check in alfresco.sh, the path is not good… (.app) :
OPENOFFICE_SCRIPT=$INSTALLDIR/openoffice.app/scripts/ctl.sh

So, to start libreoffice, I change it and adapt the ctl.sh
   
OPENOFFICE_SCRIPT=$INSTALLDIR/libreoffice/scripts/ctl.sh

libreoffice/ctl.sh
# Open Office
SOFFICE_PATH="/opt/Alfresco/libreoffice/program"
SOFFICE_PORT="8100"
SOFFICEBIN=/opt/Alfresco/libreoffice/program/soffice.bin
#SOFFICE="$SOFFICEBIN -nofirststartwizard -nologo -headless -accept=socket,host=localhost,port=$SOFFICE_PORT;urp;StarOffice.ServiceManager"
SOFFICE="$SOFFICEBIN –nofirststartwizard –nologo –headless –accept=socket,host=localhost,port=$SOFFICE_PORT;urp;StarOffice.ServiceManager"
and alfresco-global.properties :

   #ooo.exe=/opt/Alfresco/openoffice/program/soffice.bin
   ooo.exe=/opt/Alfresco/libreoffice/program/soffice.bin

cbernardi
Champ in-the-making
Champ in-the-making
Yes, I faced this too…
Infact as I wrote in my post, instead of modify the launch script I renamed the old OpenOffice folder and made a symbolic link to the new one… so the scripts continued to work with the old paths!

aweber1nj
Champ in-the-making
Champ in-the-making
Thank you all for this good work.

I am testing 4.0e, and it appears that the path in the alfresco.sh script is wrong (again).  In the script, as delivered it is:
OPENOFFICE_SCRIPT=$INSTALLDIR/openoffice.app/scripts/ctl.sh
I am almost certain this should be without the .app extension like:
OPENOFFICE_SCRIPT=$INSTALLDIR/openoffice/scripts/ctl.sh

-AJ

digihorse
Champ in-the-making
Champ in-the-making
Many use macs for development at Alfresco. That would be a mac OS X path…..  Alter to fit your environment.

csmith
Champ in-the-making
Champ in-the-making
This was my fix as well. Thank you.

mkmahmoud
Champ in-the-making
Champ in-the-making

When I click in .docx or any other office type document I got message "cant preview PDF contents". Logically, alfresco will use standard format to display the contents of files. Converting to PDF is more than one process i,e it need to read document, create the uniform format and convert to PDF. when I was installed alfresco I got warning message "RAM and CPU is Not enough". Most probably, it related to max document size and the specification of the HW which is less than minimum requirements. I think you need to install open office or libre office with ooo.exe=/path to/soffice.bin no matter where you install it. installing libre office directly with alfresco installing process is the easiest way to have smooth document viewing and over all system stability. But if you want to install libre office manually without GUI environment you need to install libre office core only. most probably full libre office installing will try to install python 3.x and the GUI contents which is not applicable will cause sever problem.