nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

As we transition to the new Hyland Community, some post links may be temporarily disrupted as we finalize redirects. We apologize for the inconvenience and are working to resolve this as quickly as possible. Details.

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?

Find more posts tagged with

Comments

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?

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?

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

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

carnold

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

ddraper

Have you raised an issue yet as Mark previously suggested?