Certain Xls(x) Files Not Previewing

[carnold]

community 4.2c used installer to install on sled 11. Certain xls will not preview. I thought i found xls files will preview but xlsx files would not but that is wrong. The spreadsheets in question that do not preview will open when downloaded and excel used to open them. Anyone seen this?

[carnold]

Here is the alfresco log file when accessing the xlsx file:

13:17:12,069 ERROR [org.springframework.extensions.webscripts.AbstractRuntime] Exception from executeScript - redirecting to status template error: 07270200 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: 07270200 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:184)
   at org.alfresco.repo.web.scripts.RepositoryContainer$3.execute(RepositoryContainer.java:433)
   at org.alfresco.repo.transaction.RetryingTransactionHelper.doInTransaction(RetryingTransactionHelper.java:433)
   at org.alfresco.repo.web.scripts.RepositoryContainer.transactionedExecute(RepositoryContainer.java:495)
   at org.alfresco.repo.web.scripts.RepositoryContainer.transactionedExecuteAs(RepositoryContainer.java:533)
   at org.alfresco.repo.web.scripts.RepositoryContainer.executeScript(RepositoryContainer.java:349)
   at org.springframework.extensions.webscripts.AbstractRuntime.executeScript(AbstractRuntime.java:377)
   at org.springframework.extensions.webscripts.AbstractRuntime.executeScript(AbstractRuntime.java:209)
   at org.springframework.extensions.webscripts.servlet.WebScriptServlet.service(WebScriptServlet.java:118)
   at javax.servlet.http.HttpServlet.service(HttpServlet.java:722)
   at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:305)
   at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
   at org.alfresco.web.app.servlet.GlobalLocalizationFilter.doFilter(GlobalLocalizationFilter.java:61)
   at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243)
   at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
   at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:222)
   at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:123)
   at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:472)
   at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:168)
   at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:99)
   at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:929)
   at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:118)
   at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:407)
   at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1002)
   at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:585)
   at org.apache.tomcat.util.net.AprEndpoint$SocketProcessor.run(AprEndpoint.java:1813)
   at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1110)
   at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:603)
   at java.lang.Thread.run(Thread.java:722)‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍

I can not post the catalina.out file because it is 2.8gig in size!?!?
I have restarted the server. Netstat -tulpn | grep office does not return anything but certain office files do preview

[carnold]

Hard to believe no one can help with this issue?

[ddraper]

Have you tried any of the recent nightly builds? A new version of 4.2 Community is due to be released soon. Also, maybe no-one else has experienced this problem - are you sure there is nothing unusual about the file. If it works for other .xls(x) files then that suggests that there is something unique about these files that the previewer can't cope with. You haven't really provided much information about the files that you're having trouble with

[carnold]

Have not tried any nightly builds. With a google search, i see others have experienced this problem, mostly office/libreoffice related. Not much more to provide about the files than what has already been provided:
- xls and xlsx
- formatted with highlights, bold etc
- workbooks and single "sheet" spreadsheets

What other info do you need?

[carnold]

Here are some more log entries:

17:53:31,712 INFO  [org.alfresco.repo.management.subsystems.ChildApplicationContextFactory] Starting 'Transformers' subsystem, ID: [Transformers, default]
17:53:31,773 ERROR [org.alfresco.repo.content.transform.TransformerConfigDynamicTransformers] Cannot create dynamic transformer transformer.complex.JodConverter.Image as sub transformers could not be found or created ("JodConverter.2Pdf|pdf|complex.PDF.Image").
17:53:31,774 ERROR [org.alfresco.repo.content.transform.TransformerConfigDynamicTransformers] Cannot create dynamic transformer transformer.complex.JodConverter.Pdf2swf as sub transformers could not be found or created ("JodConverter.2Pdf|pdf|Pdf2swf").
17:53:31,774 ERROR [org.alfresco.repo.content.transform.TransformerConfigDynamicTransformers] Cannot create dynamic transformer transformer.JodConverter.Html2Pdf as sub transformers could not be found or created ("JodConverter|odt|JodConverter").
17:53:31,774 ERROR [org.alfresco.repo.content.transform.TransformerConfigDynamicTransformers] Cannot create dynamic transformer transformer.JodConverter.2Pdf as sub transformers could not be found or created ("JodConverter|JodConverter.Html2Pdf").
17:53:31,774 ERROR [org.alfresco.repo.content.transform.TransformerConfigDynamicTransformers] Cannot create dynamic transformer transformer.complex.JodConverter.PdfBox as sub transformers could not be found or created ("JodConverter.2Pdf|pdf|PdfBox").‍‍‍‍‍‍

[mrogers]

Please raise A JIRA ticket (issues.alfresco.com) with an example of a file that does not preview.    Also if you can narrow down what is "odd" about your files that don't preview then that may get investigation stated.

[carnold]

Is there config that needs to be done on a fresh alfresco install to get the previewer to work with office files? Should it work out of the box?

[ddraper]

I did see this issue, which might be related (unfortunately I don't know much about the transformers): https://issues.alfresco.com/jira/browse/ALF-19904

[carnold]

I am not convinced this is a bug as other office files preview fine. I tend to think this is a config problem or a file problem. We have uploaded the original 11meg xlsx file with alfresco upgraded to 4.2.d. Still will not preview. Here is a section of the global.properties file:

#
# External locations
#————-
#ooo.exe=soffice
#ooo.enabled=false
#jodconverter.officeHome=./OpenOffice.org
#jodconverter.portNumbers=8101
#jodconverter.enabled=true
#img.root=./ImageMagick
#swf.exe=./bin/pdf2swf‍‍‍‍‍‍‍‍‍‍

Notice this is commented out. Also, 4.2.d does not use openoffice but libreoffice. Could this be the issue? Seems like all office files would not preview if it were so.

Here is a snippet of the alfresco.log:

07:47:18,705 ERROR [org.springframework.extensions.webscripts.AbstractRuntime] Exception from executeScript - redirecting to status template error: 08050003 Wrapped Exception (with status template): 08050221 Failed to execute script 'classpath*:alfresco/templates/webscripts/org/alfresco/repository/thumbnail/thumbnail.get.js': 08050218 Unsupported transformation: transformer.OpenOffice.2Pdf application/vnd.ms-excel to application/pdf 
org.springframework.extensions.webscripts.WebScriptException: 08050003 Wrapped Exception (with status template): 08050221 Failed to execute script 'classpath*:alfresco/templates/webscripts/org/alfresco/repository/thumbnail/thumbnail.get.js': 08050218 Unsupported transformation: transformer.OpenOffice.2Pdf application/vnd.ms-excel to application/pdf‍‍