Open Office Preview in Share not working

[newmember]

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 port 8100 which is listening for requests coming from Alfresco. Such a request is the file handling of documents when you are browsing the document library.

When you try to preview a file in Alfresco, it initiates a connection with the OO socket and at that moment the socket closes due to some kind of exception and any kind of connection attempt from Alfresco to OO fails.

As a result, no preview can be seen in the web browser and the flash plugin idles forever seeming to load the page.

Now, I've been trying to find any reference in the web regarding problems with the socket, tried to verify the start parameters when running OO headless, etc. but did not come across any information that would give me a hint.

I have used the rpms from the OO website to install OO.

Does anyone have any thoughts regarding this trouble I am having?
CENTOS OS
OO   ver3.1
Alfresco 3.2Community


Thanks

[carry2web]

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.

[unknown-user]

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

[newmember]

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

[tgmweb]

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

[glongobardi]

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

[mrabaey]

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

[savic_prvoslav]

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