topic Open Office Preview in Share not working in Alfresco Archive

Open Office Preview in Share not working

newmember — Mon, 14 Sep 2009 16:48:09 GMT

The problem is an error/malfunction with or in OO that is causing me all the grief. When starting up Alfresco everything seems to work fine. Alfresco manages to start a headless instance of OO and itself starts up without problems.For the communication between OO and Alfresco, OO opens a socket at p

Re: Open Office Preview in Share not working

carry2web — Mon, 21 Sep 2009 14:47:08 GMT

We have the very same problem with OO being instable and causing all kind of trouble in the preview area but also with uploading content.
We've seen 100% CPU usage due to OO daemon looping not behaving.
Alfresco has filed a report at Sun.

Re: Open Office Preview in Share not working

unknown-user — Tue, 22 Sep 2009 12:19:59 GMT

did you install from the openoffice package from the site? I have nearly the same setup, and all is working fine.

Check your java version? I'm running JDK/JRE 1.6u13 from sun. check your java_home var to make sure the sun one is running. I had troubles till I completely wiped openJDK.

RHEL 5.4
OOo 3.1
Alfreso 3.2 CE

Re: Open Office Preview in Share not working

newmember — Wed, 23 Sep 2009 07:30:52 GMT

I removed all jre and jdk etc from any rpms.
I know have one install left.

I have this:

[root@localhost Alfresco]# alternatives –config java

There is 1 program that provides 'java'.

Selection Command
———————————————–
*+ 1 /opt/jdk1.6.0_07/bin/java

How did you install your jdk and/or jre?
I am on centos so there are no direct rpms.

I have downloaded:
jdk-6u16-linux-i586-rpm.bin
jre-6u16-linux-i586-rpm.bin

Re: Open Office Preview in Share not working

tgmweb — Wed, 23 Sep 2009 19:04:31 GMT

I have exactly the same problem. OpenOffice starts fine when alfresco is starting up - no errors and debugging says it all works.

When I try to view a thumbnail however, it doesn't work - indexing doesn't work either and neither do transformations. Thumbnails for text files, images work - but not for doc/xls/pdf files.

        19:58:23,103 User:tom.miller@ebiz.co.uk DEBUG [repo.thumbnail.ThumbnailServiceImpl] Getting thumbnail by name (nodeRef=workspace://SpacesStore/c4f009c4-3827-4029-aa93-22872bf1f5a3; contentProperty={http://www.alfresco.org/model/content/1.0}content; thumbnailName=imgpreview)
        19:58:23,105 User:tom.miller@ebiz.co.uk DEBUG [repo.thumbnail.ThumbnailServiceImpl] Creating thumbnail (node=workspace://SpacesStore/c4f009c4-3827-4029-aa93-22872bf1f5a3; contentProperty={http://www.alfresco.org/model/content/1.0}content; mimetype=image/png
        19:58:23,105 User:tom.miller@ebiz.co.uk DEBUG [repo.thumbnail.ThumbnailServiceImpl] Getting thumbnail by name (nodeRef=workspace://SpacesStore/c4f009c4-3827-4029-aa93-22872bf1f5a3; contentProperty={http://www.alfresco.org/model/content/1.0}content; thumbnailName=imgpreview)
        19:58:23,120 User:tom.miller@ebiz.co.uk DEBUG [content.transform.ContentTransformerRegistry] Searched for transformer:
           source mimetype: application/vnd.ms-word
           target mimetype: image/png
           transformers: []
        19:58:23,120 User:tom.miller@ebiz.co.uk DEBUG [repo.thumbnail.ThumbnailServiceImpl] Creating thumbnail: There is no transformer to generate the thumbnail required (node=workspace://SpacesStore/c4f009c4-3827-4029-aa93-22872bf1f5a3; contentProperty={http://www.alfresco.org/model/content/1.0}content; mimetype=image/png)
        19:58:23,121 User:tom.miller@ebiz.co.uk DEBUG [repo.jscript.RhinoScriptProcessor] Time to execute script: 20.380495ms
        19:58:23,237 User:tom.miller@ebiz.co.uk ERROR [web.scripts.AbstractRuntime] Exception from executeScript - redirecting to status template error: 08170038 Wrapped Exception (with status template): 08170037 Failed to execute script '/org/alfresco/repository/thumbnail/thumbnail.get.js (in classpath store file:/opt/alfresco/tomcat/webapps/alfresco/WEB-INF/classes/alfresco/templates/webscripts)': 08170036 Thumbnail could not be created as required transformation is not supported from application/vnd.ms-word to image/png
        org.alfresco.web.scripts.WebScriptException: 08170038 Wrapped Exception (with status template): 08170037 Failed to execute script '/org/alfresco/repository/thumbnail/thumbnail.get.js (in classpath store file:/opt/alfresco/tomcat/webapps/alfresco/WEB-INF/classes/alfresco/templates/webscripts)': 08170036 Thumbnail could not be created as required transformation is not supported from application/vnd.ms-word to image/png
                at org.alfresco.web.scripts.AbstractWebScript.createStatusException(AbstractWebScript.java:613)
                at org.alfresco.repo.web.scripts.content.StreamContent.execute(StreamContent.java:212)
                at org.alfresco.repo.web.scripts.RepositoryContainer$2.execute(RepositoryContainer.java:357)
                at org.alfresco.repo.transaction.RetryingTransactionHelper.doInTransaction(RetryingTransactionHelper.java:326)
                at org.alfresco.repo.web.scripts.RepositoryContainer.transactionedExecute(RepositoryContainer.java:407)
                at org.alfresco.repo.web.scripts.RepositoryContainer.transactionedExecuteAs(RepositoryContainer.java:424)
                at org.alfresco.repo.web.scripts.RepositoryContainer.executeScript(RepositoryContainer.java:288)
                at org.alfresco.web.scripts.AbstractRuntime.executeScript(AbstractRuntime.java:262)
                at org.alfresco.web.scripts.AbstractRuntime.executeScript(AbstractRuntime.java:139)
                at org.alfresco.web.scripts.servlet.WebScriptServlet.service(WebScriptServlet.java:122)
                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.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
                at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
                at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:128)
                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:286)
                at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:845)
                at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:583)
                at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:447)
                at java.lang.Thread.run(Thread.java:619)
        Caused by: org.alfresco.scripts.ScriptException: 08170037 Failed to execute script '/org/alfresco/repository/thumbnail/thumbnail.get.js (in classpath store file:/opt/alfresco/tomcat/webapps/alfresco/WEB-INF/classes/alfresco/templates/webscripts)': 08170036 Thumbnail could not be created as required transformation is not supported from application/vnd.ms-word to image/png
                at org.alfresco.repo.jscript.RhinoScriptProcessor.execute(RhinoScriptProcessor.java:178)
                at org.alfresco.repo.processor.ScriptServiceImpl.executeScript(ScriptServiceImpl.java:274)
                at org.alfresco.repo.web.scripts.RepositoryScriptProcessor.executeScript(RepositoryScriptProcessor.java:108)
                at org.alfresco.web.scripts.AbstractWebScript.executeScript(AbstractWebScript.java:819)
                at org.alfresco.repo.web.scripts.content.StreamContent.execute(StreamContent.java:158)
                … 21 more
        Caused by: org.alfresco.service.cmr.thumbnail.ThumbnailException: 08170036 Thumbnail could not be created as required transformation is not supported from application/vnd.ms-word to image/png
                at org.alfresco.repo.thumbnail.ThumbnailServiceImpl$1.doWork(ThumbnailServiceImpl.java:279)
                at org.alfresco.repo.thumbnail.ThumbnailServiceImpl$1.doWork(ThumbnailServiceImpl.java:199)
                at org.alfresco.repo.security.authentication.AuthenticationUtil.runAs(AuthenticationUtil.java:489)
                at org.alfresco.repo.thumbnail.ThumbnailServiceImpl.createThumbnail(ThumbnailServiceImpl.java:197)
                at org.alfresco.repo.thumbnail.ThumbnailServiceImpl.createThumbnail(ThumbnailServiceImpl.java:160)
                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:304)
                at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:182)
                at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:149)
                at org.alfresco.repo.security.permissions.impl.AlwaysProceedMethodInterceptor.invoke(AlwaysProceedMethodInterceptor.java:40)
                at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)
                at org.alfresco.repo.security.permissions.impl.ExceptionTranslatorMethodInterceptor.invoke(ExceptionTranslatorMethodInterceptor.java:49)
                at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)
                at org.alfresco.repo.audit.AuditComponentImpl.audit(AuditComponentImpl.java:275)
                at org.alfresco.repo.audit.AuditMethodInterceptor.invoke(AuditMethodInterceptor.java:69)
                at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)
                at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:106)
                at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)
                at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204)
                at $Proxy95.createThumbnail(Unknown Source)
                at org.alfresco.repo.jscript.ScriptNode.createThumbnail(ScriptNode.java:2075)
                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.c5._c1(file:/opt/alfresco/tomcat/webapps/alfresco/WEB-INF/classes/alfresco/templates/webscripts/org/alfresco/repository/thumbnail/thumbnail.get.js:61)
                at org.mozilla.javascript.gen.c5.call(file:/opt/alfresco/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.c5._c0(file:/opt/alfresco/tomcat/webapps/alfresco/WEB-INF/classes/alfresco/templates/webscripts/org/alfresco/repository/thumbnail/thumbnail.get.js:101)
                at org.mozilla.javascript.gen.c5.call(file:/opt/alfresco/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.c5.call(file:/opt/alfresco/tomcat/webapps/alfresco/WEB-INF/classes/alfresco/templates/webscripts/org/alfresco/repository/thumbnail/thumbnail.get.js)
                at org.mozilla.javascript.gen.c5.exec(file:/opt/alfresco/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:449)
                at org.alfresco.repo.jscript.RhinoScriptProcessor.execute(RhinoScriptProcessor.java:174)
                … 25 more‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍

That's my debug error log

Re: Open Office Preview in Share not working

glongobardi — Fri, 02 Oct 2009 10:12:43 GMT

I have a similar problem (OO 3.1 crash after previewing or uploading Word docs) and an issue it has been opened at the OpenOffice qa site
http://qa.openoffice.org/issues/show_bug.cgi?id=104862

In the meantime you could uninstall OpenOffice 3.1 and install OpenOffice 2.4.3
http://download.openoffice.org/2.4.3/index.html

After some tests, it seems to work with Alfresco CE 3.2

Giampiero

Re: Open Office Preview in Share not working

mrabaey — Thu, 05 Nov 2009 15:46:33 GMT

I had the same problems on different versions of ubuntu 64-bit servers. Finally I got it work on
- ubuntu 09.10
- 000 3.1
- Alfresco CE 3.2

Apparently it was due to some "dos"-format files on a linux server. You can detect them with the file command, and then convert with dos2unix command:
example:

root@dsadt1:/opt/Alfresco# file ./tomcat/webapps/share/WEB-INF/classes/alfresco/site-webscripts/org/alfresco/components/form/form.get.js
./tomcat/webapps/share/WEB-INF/classes/alfresco/site-webscripts/org/alfresco/components/form/form.get.js: ASCII C program text, with CRLF line terminators
root@dsadt1:/opt/Alfresco# cp ./tomcat/webapps/share/WEB-INF/classes/alfresco/site-webscripts/org/alfresco/components/form/form.get.js ./tomcat/webapps/share/WEB-INF/classes/alfresco/site-webscripts/org/alfresco/components/form/form.get.js.mr
root@dsadt1:/opt/Alfresco# dos2unix ./tomcat/webapps/share/WEB-INF/classes/alfresco/site-webscripts/org/alfresco/components/form/form.get.js

By looking up in the logging files, I could determine which files were causing problems.

After "linuxing" those files, everything worked great.

I must say, that it is not the first time I have met this kind of problems.
Since I will upgrade our servers to ubuntu 9.10, I will not continue to test for the other versions.

Good luck
Marc

Re: Open Office Preview in Share not working

savic_prvoslav — Mon, 01 Apr 2013 13:31:53 GMT

start your openoffice with this command:
soffice -accept="socket,host=localhost,port=8100;urp" -headless -nologo -nofirststartwizard >/var/run/soffice.bin.pid &>/dev/null &