topic Re: Certain Xls(x) Files Not Previewing in Alfresco Archive

Certain Xls(x) Files Not Previewing

carnold — Mon, 26 Aug 2013 16:31:42 GMT

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?

Re: Certain Xls(x) Files Not Previewing

carnold — Tue, 27 Aug 2013 17:31:00 GMT

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

Re: Certain Xls(x) Files Not Previewing

carnold — Fri, 30 Aug 2013 10:41:47 GMT

Hard to believe no one can help with this issue?

Re: Certain Xls(x) Files Not Previewing

ddraper — Fri, 30 Aug 2013 11:24:22 GMT

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

Re: Certain Xls(x) Files Not Previewing

carnold — Fri, 30 Aug 2013 12:10:05 GMT

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?

Re: Certain Xls(x) Files Not Previewing

mrogers — Fri, 30 Aug 2013 12:49:56 GMT

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.

Re: Certain Xls(x) Files Not Previewing

carnold — Sat, 31 Aug 2013 22:23:19 GMT

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?

Re: Certain Xls(x) Files Not Previewing

carnold — Sat, 31 Aug 2013 22:49:46 GMT

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").‍‍‍‍‍‍

Re: Certain Xls(x) Files Not Previewing

ddraper — Wed, 04 Sep 2013 09:15:26 GMT

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

Re: Certain Xls(x) Files Not Previewing

carnold — Thu, 05 Sep 2013 12:25:00 GMT

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‍‍

Re: Certain Xls(x) Files Not Previewing

carnold — Thu, 05 Sep 2013 12:40:00 GMT

Well, i made the global.properties look like this:

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

and the xls file still does not preview.
I do see some new stuff in the alfresco.log:

08:27:09,690 INFO  [org.alfresco.repo.management.subsystems.ChildApplicationContextFactory] Starting 'Transformers' subsystem, ID: [Transformers, default]
08:27:09,750 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").
08:27:09,751 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").
08:27:09,751 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").
08:27:09,751 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").
08:27:09,751 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").
08:27:09,859 INFO  [org.alfresco.repo.management.subsystems.ChildApplicationContextFactory] Startup of 'Transformers' subsystem, ID: [Transformers, default] complete
08:27:12,141 ERROR [org.springframework.extensions.webscripts.AbstractRuntime] Exception from executeScript - redirecting to status template error: 08050002 Wrapped Exception (with status template): 08050053 Failed to execute script 'classpath*:alfresco/templates/webscripts/org/alfresco/repository/thumbnail/thumbnail.get.js': 08050050 Unsupported transformation: transformer.OpenOffice.2Pdf application/vnd.ms-excel to application/pdf 
org.springframework.extensions.webscripts.WebScriptException: 08050002 Wrapped Exception (with status template): 08050053 Failed to execute script 'classpath*:alfresco/templates/webscripts/org/alfresco/repository/thumbnail/thumbnail.get.js': 08050050 Unsupported transformation: transformer.OpenOffice.2Pdf application/vnd.ms-excel to application/pdf 
   at org.springframework.extensions.webscripts.AbstractWebScript.createStatusException(AbstractWebScript.java:1067)‍‍‍‍‍‍‍‍‍‍

Re: Certain Xls(x) Files Not Previewing

ddraper — Thu, 05 Sep 2013 13:03:42 GMT

Have you raised an issue yet as Mark previously suggested?