Preview Failed with Error

[him_ng]

Hi,

We find that we are failed the preview pptx with Size ~>15 MB.

"Sorry, an error has occurred"

We are using Horizon Workspace 1.5 with LibreOffice installed.

Could you help.

Thanks.

[sravuri]

Anything more in the logs in data-va?

/opt/zimbra/log/mailbox.log

[him_ng]

Please find below log when I try to preview the pptx.

Thanks.

2013-09-05 12:53:17,164 INFO  [qtp354233797-14329:https://192.168.113.45:443/data/service/extension/com_zimbra_oo/rest/preview?target=PDF&auth=co&disp...] [] extensions - Checking conversion status for a :com.zimbra.cs.mailbox.Document

2013-09-05 12:53:17,165 INFO  [qtp354233797-14329:https://192.168.113.45:443/data/service/extension/com_zimbra_oo/rest/preview?target=PDF&auth=co&disp...] [] extensions - Attempting to get a converter with key 'PDF:application/vnd.openxmlformats-officedocument.presentationml.presentation'

2013-09-05 12:53:17,165 INFO  [qtp354233797-14329:https://192.168.113.45:443/data/service/extension/com_zimbra_oo/rest/preview?target=PDF&auth=co&disp...] [] extensions - Found an available converter:OOPdfConverter

2013-09-05 12:53:17,165 INFO  [Uno:8103] [] extensions - Running beforeExecute

2013-09-05 12:53:29,417 INFO  [Uno:8103] [] extensions - Before document export

2013-09-05 12:54:17,166 ERROR [UnoTimeoutTimer] [] extensions - Uno call has been timed out. Stopping the instance it was connected to for restart

2013-09-05 12:54:17,167 INFO  [UnoTimeoutTimer] [] extensions - Disposing OO/Libre connection

2013-09-05 12:54:17,170 ERROR [Uno:8103] [] extensions - Error whilst disposing document

2013-09-05 12:54:17,170 ERROR [Uno:8103] [] extensions - Throwable caught while executing OO command:com.sun.star.lang.DisposedException

2013-09-05 12:54:17,170 ERROR [Uno:8103] [] extensions - Uno command was not successful on attempt:1

2013-09-05 12:54:17,170 INFO  [Uno:8103] [] extensions - Running afterexecute

2013-09-05 12:54:17,171 INFO  [Uno:8100] [] extensions - Running beforeExecute

2013-09-05 12:54:17,173 INFO  [Uno:8103] [] extensions - Command timeout. Restarting Libre instance.

2013-09-05 12:54:17,173 INFO  [Uno:8103] [] extensions - Attempting to stop OO/Libre on port:8103

2013-09-05 12:54:17,196 INFO  [Uno:8103] [] extensions - Killing OO/Libre process:16682

2013-09-05 12:54:17,201 INFO  [Uno:8100] [] extensions - Deleting lock file /opt/zimbra/mailboxd/work/.~lock.oo_uno_temp6358778500528717512.pptx#

2013-09-05 12:54:17,209 INFO  [Uno:8103] [] extensions - Killing OO/Libre process:16697

2013-09-05 12:54:29,307 INFO  [Uno:8100] [] extensions - Before document export

2013-09-05 12:55:17,171 ERROR [UnoTimeoutTimer] [] extensions - Uno call has been timed out. Stopping the instance it was connected to for restart

2013-09-05 12:55:17,172 INFO  [UnoTimeoutTimer] [] extensions - Disposing OO/Libre connection

2013-09-05 12:55:17,173 ERROR [Uno:8100] [] extensions - Error whilst disposing document

2013-09-05 12:55:17,173 ERROR [Uno:8100] [] extensions - Throwable caught while executing OO command:com.sun.star.lang.DisposedException

2013-09-05 12:55:17,173 ERROR [Uno:8100] [] extensions - Uno command was not successful on attempt:2

2013-09-05 12:55:17,173 INFO  [Uno:8100] [] extensions - Running afterexecute

2013-09-05 12:55:17,174 INFO  [Uno:8101] [] extensions - Running beforeExecute

2013-09-05 12:55:17,174 INFO  [Uno:8100] [] extensions - Command timeout. Restarting Libre instance.

2013-09-05 12:55:17,174 INFO  [Uno:8100] [] extensions - Attempting to stop OO/Libre on port:8100

2013-09-05 12:55:17,195 INFO  [Uno:8100] [] extensions - Killing OO/Libre process:16819

2013-09-05 12:55:17,198 INFO  [Uno:8100] [] extensions - Killing OO/Libre process:16833

2013-09-05 12:55:17,212 INFO  [Uno:8101] [] extensions - Deleting lock file /opt/zimbra/mailboxd/work/.~lock.oo_uno_temp6358778500528717512.pptx#

2013-09-05 12:55:28,645 INFO  [Uno:8101] [] extensions - Before document export

2013-09-05 12:56:17,174 ERROR [UnoTimeoutTimer] [] extensions - Uno call has been timed out. Stopping the instance it was connected to for restart

2013-09-05 12:56:17,174 INFO  [UnoTimeoutTimer] [] extensions - Disposing OO/Libre connection

2013-09-05 12:56:17,175 ERROR [Uno:8101] [] extensions - Error whilst disposing document

2013-09-05 12:56:17,176 ERROR [Uno:8101] [] extensions - Throwable caught while executing OO command:com.sun.star.lang.DisposedException

2013-09-05 12:56:17,176 ERROR [Uno:8101] [] extensions - Uno command was not successful on attempt:3

2013-09-05 12:56:17,176 INFO  [Uno:8101] [] extensions - Running afterexecute

2013-09-05 12:56:17,176 INFO  [Uno:8101] [] extensions - Command timeout. Restarting Libre instance.

2013-09-05 12:56:17,176 INFO  [Uno:8101] [] extensions - Attempting to stop OO/Libre on port:8101

2013-09-05 12:56:17,176 INFO  [Uno:8102] [] extensions - Running beforeExecute

2013-09-05 12:56:17,201 INFO  [Uno:8101] [] extensions - Killing OO/Libre process:17173

2013-09-05 12:56:17,202 INFO  [Uno:8101] [] extensions - Killing OO/Libre process:17187

2013-09-05 12:56:17,252 INFO  [Uno:8102] [] extensions - Deleting lock file /opt/zimbra/mailboxd/work/.~lock.oo_uno_temp6358778500528717512.pptx#

[griffjames · Accepted solution]

The logs confirm that the Libre Office command timeout is being exceeded. Can you run the following command on your data node(s) to increase the timeout to 120s

sudo -u zimbra zmlocalconfig -e oo_command_timeout=120000

sudo -u zimbra zmlocalconfig -l

The final command forces a reload without you needing to restart the server to pick up the change.

I am hoping that 120s should be enough for Libre to convert the ppt, but you may have to increase the timeout to 180s if 120s does not work.

[elgwhoppo]

Sorry to necro this thread, but I also am getting this error, but only on a select set of office files. If I create a blank word docx file and save it with only text, I can preview it. If I have a larger document (not sure what exactly is different, contains picture, text, 2MB filesize, all apply) it doesn't preview. It looks like the conversion is failing for me with error null. I'm on Horizon Workspace 1.8, upgraded from 1.5. Is there a different version of Libre Office that should be utilized?

2014-03-13 14:33:47,810 INFO  (Uno:8100)  extensions - Command error. Restarting Libre instance.

2014-03-13 14:33:47,811 ERROR (qtp1426646093-239:https://10.106.205.34:443/data/service/extension/com_zimbra_oo/rest/preview?target=PDF&auth=co&disp=...)  extensions - Error while running converter:null

com.zimbra.openoffice.converter.ConversionFailedException

        at com.zimbra.openoffice.converter.OOPdfConverter.convert(OOPdfConverter.java:72)

        at com.zimbra.openoffice.converter.DocumentConverter.fetchOrConvert(DocumentConverter.java:99)

        at com.zimbra.openoffice.rest.Preview.handleDocument(Preview.java:182)

        at com.zimbra.openoffice.rest.Preview.generatePreview(Preview.java:108)

        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

        at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)

        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)

        at java.lang.reflect.Method.invoke(Method.java:606)

        at com.sun.jersey.spi.container.JavaMethodInvokerFactory$1.invoke(JavaMethodInvokerFactory.java:60)

        at com.sun.jersey.server.impl.model.method.dispatch.AbstractResourceMethodDispatchProvider$ResponseOutInvoker._dispatch(AbstractResourceMethodDispatchProvider.java:205)

        at com.sun.jersey.server.impl.model.method.dispatch.ResourceJavaMethodDispatcher.dispatch(ResourceJavaMethodDispatcher.java:75)

        at com.sun.jersey.server.impl.uri.rules.HttpMethodRule.accept(HttpMethodRule.java:302)

        at com.sun.jersey.server.impl.uri.rules.ResourceClassRule.accept(ResourceClassRule.java:108)

        at com.sun.jersey.server.impl.uri.rules.RightHandPathRule.accept(RightHandPathRule.java:147)

        at com.sun.jersey.server.impl.uri.rules.RootResourceClassesRule.accept(RootResourceClassesRule.java:84)

        at com.sun.jersey.server.impl.application.WebApplicationImpl._handleRequest(WebApplicationImpl.java:1511)

        at com.sun.jersey.server.impl.application.WebApplicationImpl._handleRequest(WebApplicationImpl.java:1442)

        at com.sun.jersey.server.impl.application.WebApplicationImpl.handleRequest(WebApplicationImpl.java:1391)

        at com.sun.jersey.server.impl.application.WebApplicationImpl.handleRequest(WebApplicationImpl.java:1381)

        at com.sun.jersey.spi.container.servlet.WebComponent.service(WebComponent.java:416)

        at com.zimbra.openoffice.extension.OpenOfficeRestHandler.service(OpenOfficeRestHandler.java:199)

        at com.zimbra.openoffice.extension.OpenOfficeRestHandler.doGet(OpenOfficeRestHandler.java:105)

        at com.zimbra.cs.extension.ExtensionDispatcherServlet.service(ExtensionDispatcherServlet.java:93)

        at javax.servlet.http.HttpServlet.service(HttpServlet.java:820)

        at org.eclipse.jetty.servlet.ServletHolder.handle(ServletHolder.java:565)

        at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1361)

        at com.zimbra.cs.servlet.SetHeaderFilter.doFilter(SetHeaderFilter.java:52)

        at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1332)

        at org.eclipse.jetty.servlets.UserAgentFilter.doFilter(UserAgentFilter.java:77)

        at org.eclipse.jetty.servlets.GzipFilter.doFilter(GzipFilter.java:181)

        at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1332)

        at org.eclipse.jetty.servlet.ServletHandler.doHandle(ServletHandler.java:477)

        at org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:119)

        at org.eclipse.jetty.security.SecurityHandler.handle(SecurityHandler.java:524)        at org.eclipse.jetty.server.session.SessionHandler.doHandle(SessionHandler.java:227)

        at org.eclipse.jetty.server.handler.ContextHandler.doHandle(ContextHandler.java:1031)

        at org.eclipse.jetty.servlet.ServletHandler.doScope(ServletHandler.java:406)        at org.eclipse.jetty.server.session.SessionHandler.doScope(SessionHandler.java:186)

        at org.eclipse.jetty.server.handler.ContextHandler.doScope(ContextHandler.java:965)        at org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:117)        at org.eclipse.jetty.server.handler.ContextHandlerCollection.handle(ContextHandlerCollection.java:250)

        at org.eclipse.jetty.server.handler.HandlerCollection.handle(HandlerCollection.java:149)        at org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:111)

        at com.sun.jersey.server.impl.application.WebApplicationImpl._handleRequest(WebApplicationImpl.java:1511)

        at com.sun.jersey.server.impl.application.WebApplicationImpl._handleRequest(WebApplicationImpl.java:1442)        at com.sun.jersey.server.impl.application.WebApplicationImpl.handleRequest(WebApplicationImpl.java:1391)

        at com.sun.jersey.server.impl.application.WebApplicationImpl.handleRequest(WebApplicationImpl.java:1381)        at com.sun.jersey.spi.container.servlet.WebComponent.service(WebComponent.java:416)

        at com.zimbra.openoffice.extension.OpenOfficeRestHandler.service(OpenOfficeRestHandler.java:199)        at com.zimbra.openoffice.extension.OpenOfficeRestHandler.doGet(OpenOfficeRestHandler.java:105)

        at com.zimbra.cs.extension.ExtensionDispatcherServlet.service(ExtensionDispatcherServlet.java:93)        at javax.servlet.http.HttpServlet.service(HttpServlet.java:820)

        at org.eclipse.jetty.servlet.ServletHolder.handle(ServletHolder.java:565)        at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1361)

        at com.zimbra.cs.servlet.SetHeaderFilter.doFilter(SetHeaderFilter.java:52)        at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1332)

        at org.eclipse.jetty.servlets.UserAgentFilter.doFilter(UserAgentFilter.java:77)        at org.eclipse.jetty.servlets.GzipFilter.doFilter(GzipFilter.java:181)

        at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1332)        at org.eclipse.jetty.servlet.ServletHandler.doHandle(ServletHandler.java:477)

        at org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:119)        at org.eclipse.jetty.security.SecurityHandler.handle(SecurityHandler.java:524)        at org.eclipse.jetty.server.session.SessionHandler.doHandle(SessionHandler.java:227)

        at org.eclipse.jetty.server.handler.ContextHandler.doHandle(ContextHandler.java:1031)        at org.eclipse.jetty.servlet.ServletHandler.doScope(ServletHandler.java:406)

        at org.eclipse.jetty.server.session.SessionHandler.doScope(SessionHandler.java:186)        at org.eclipse.jetty.server.handler.ContextHandler.doScope(ContextHandler.java:965)

        at org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:117)        at org.eclipse.jetty.server.handler.ContextHandlerCollection.handle(ContextHandlerCollection.java:250)

        at org.eclipse.jetty.server.handler.HandlerCollection.handle(HandlerCollection.java:149)        at org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:111)

        at org.eclipse.jetty.rewrite.handler.RewriteHandler.handle(RewriteHandler.java:312)

        at org.eclipse.jetty.server.handler.DebugHandler.handle(DebugHandler.java:77)

        at org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:111)

        at org.eclipse.jetty.server.Server.handle(Server.java:349)

        at org.eclipse.jetty.server.AbstractHttpConnection.handleRequest(AbstractHttpConnection.java:452)

        at org.eclipse.jetty.server.AbstractHttpConnection.headerComplete(AbstractHttpConnection.java:884)

        at org.eclipse.jetty.server.AbstractHttpConnection$RequestHandler.headerComplete(AbstractHttpConnection.java:938)

        at org.eclipse.jetty.http.HttpParser.parseNext(HttpParser.java:634)

        at org.eclipse.jetty.http.HttpParser.parseAvailable(HttpParser.java:230)

        at org.eclipse.jetty.server.AsyncHttpConnection.handle(AsyncHttpConnection.java:77)

        at org.eclipse.jetty.io.nio.SslConnection.handle(SslConnection.java:191)

        at org.eclipse.jetty.io.nio.SelectChannelEndPoint.handle(SelectChannelEndPoint.java:606)

        at org.eclipse.jetty.io.nio.SelectChannelEndPoint$1.run(SelectChannelEndPoint.java:46)

        at org.eclipse.jetty.util.thread.QueuedThreadPool.runJob(QueuedThreadPool.java:603)

        at org.eclipse.jetty.util.thread.QueuedThreadPool$3.run(QueuedThreadPool.java:538)

        at java.lang.Thread.run(Thread.java:744)

2014-03-13 14:33:47,812 INFO  (Uno:8100)  extensions - Attempting to stop OO/Libre on port:8100

2014-03-13 14:33:47,812 INFO  (qtp1426646093-239:https://10.106.205.34:443/data/service/extension/com_zimbra_oo/rest/preview?target=PDF&auth=co&disp=...)  extensions - Deleting lock file /opt/zimbra/mailboxd/work/.~lock.oo_uno_temp9080623759045448821.docx#

[griffjames]

First of all, can you confirm which version of Libre Office you have installed.

You can take a look at the libre_installer.sh script to confirm the version we expect, which I believe is 4.0.2 from memory.

If necessary, please run the script to upgrade Libre.