topic Re: Someone can help me, I'm trying to view a 500k xlsx in the browser in Alfresco Forum

Someone can help me, I'm trying to view a 500k xlsx in the browser

thiago_andretta — Wed, 04 Nov 2020 14:35:17 GMT

Caused by: org.alfresco.service.cmr.repository.ContentIOException: 10040288 Content conversion failed:
reader: ContentAccessor[ contentUrl=store://2020/11/3/17/10/b2177f54-f8b1-4e89-be1b-b4b88c4cecd2.bin, mimetype=application/vnd.openxmlformats-officedocument.spreadsheetml.sheet, size=555953, encoding=UTF-8, locale=pt_BR]
writer: ContentAccessor[ contentUrl=store://2020/11/4/12/20/f48a2fa2-bba4-468f-a9a3-8becfb1a18c8.bin, mimetype=application/pdf, size=0, encoding=UTF-8, locale=pt_BR]
options: {use=pdf, contentReaderNodeRef=workspace://SpacesStore/8c56a5dc-de34-41ea-8d47-12cb6399ac88, sourceContentProperty=null, contentWriterNodeRef=workspace://SpacesStore/08285b7c-6044-4189-be4d-43edf0a2df8f, targetContentProperty=null, includeEmbedded=null}
limits: {timeoutMs=180000, maxSourceSizeKBytes=10240}
at org.alfresco.repo.content.transform.AbstractContentTransformer2.transform(AbstractContentTransformer2.java:341)
at org.alfresco.repo.content.ContentServiceImpl.transform(ContentServiceImpl.java:613)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
at java.lang.reflect.Method.invoke(Unknown Source)
at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:317)
at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:183)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:150)
at net.sf.acegisecurity.intercept.method.aopalliance.MethodSecurityInterceptor.invoke(MethodSecurityInterceptor.java:80)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
at org.alfresco.repo.model.ml.MLContentInterceptor.invoke(MLContentInterceptor.java:136)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
at org.alfresco.repo.security.permissions.impl.ExceptionTranslatorMethodInterceptor.invoke(ExceptionTranslatorMethodInterceptor.java:53)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
at org.alfresco.repo.audit.AuditMethodInterceptor.invoke(AuditMethodInterceptor.java:166)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
at org.springframework.transaction.interceptor.TransactionInterceptor$1.proceedWithInvocation(TransactionInterceptor.java:96)
at org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:260)
at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:94)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204)
at com.sun.proxy.$Proxy49.transform(Unknown Source)
at org.alfresco.repo.rendition.executer.AbstractTransformationRenderingEngine$TransformationCallable$1.doWork(AbstractTransformationRenderingEngine.java:447)
at org.alfresco.repo.rendition.executer.AbstractTransformationRenderingEngine$TransformationCallable$1.doWork(AbstractTransformationRenderingEngine.java:1)
at org.alfresco.repo.security.authentication.AuthenticationUtil.runAs(AuthenticationUtil.java:555)
at org.alfresco.repo.rendition.executer.AbstractTransformationRenderingEngine$TransformationCallable.call(AbstractTransformationRenderingEngine.java:437)
at org.alfresco.repo.rendition.executer.AbstractTransformationRenderingEngine$TransformationCallable.call(AbstractTransformationRenderingEngine.java:1)
at java.util.concurrent.FutureTask.run(Unknown Source)
at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
... 1 more

Re: Someone can help me, I'm trying to view a 500k xlsx in the browser

sp2 — Thu, 05 Nov 2020 11:31:04 GMT

https://hub.alfresco.com/t5/alfresco-content-services-forum/preview-large-docx-and-xlsx/td-p/244481

Above thread will help.

Re: Someone can help me, I'm trying to view a 500k xlsx in the browser

thiago_andretta — Thu, 05 Nov 2020 12:30:48 GMT

I inserted the information below in the alfresco-global.properties

transformer.OpenOffice=3600000
transformer.complex.OpenOffice.Image.time=3600000
transformer.complex.OpenOffice.Pdf2swf.time=3600000
transformer.complex.OpenOffice.PdfBox.time=3600000

transformer.JodConverter.time=3600000
transformer.complex.JodConverter.Image.time=3600000
transformer.complex.JodConverter.Pdf2swf.time=3600000
transformer.complex.JodConverter.PdfBox.time=3600000
transformer.OpenOffice.count=1000000
transformer.complex.OpenOffice.Image.count=1000000
transformer.complex.OpenOffice.Pdf2swf.count=1000000
transformer.complex.OpenOffice.PdfBox.count=1000000

transformer.JodConverter.count=1000000
transformer.complex.JodConverter.Image.count=1000000
transformer.complex.JodConverter.Pdf2swf.count=1000000
transformer.complex.JodConverter.PdfBox.count=1000000

but I continue with the error below

2020-11-05 10:27:22,944 ERROR [org.springframework.extensions.webscripts.AbstractRuntime] [http-apr-8080-exec-8] Exception from executeScript: 10050003 Wrapped Exception (with status template): 10050029 Failed to execute script 'classpath*:alfresco/templates/webscripts/org/alfresco/repository/thumbnail/thumbnail.get.js': 10050028 10050027 Transformation failed to obey timeout limit
org.springframework.extensions.webscripts.WebScriptException: 10050003 Wrapped Exception (with status template): 10050029 Failed to execute script 'classpath*:alfresco/templates/webscripts/org/alfresco/repository/thumbnail/thumbnail.get.js': 10050028 10050027 Transformation failed to obey timeout limit
at org.springframework.extensions.webscripts.AbstractWebScript.createStatusException(AbstractWebScript.java:1138)

Re: Someone can help me, I'm trying to view a 500k xlsx in the browser

EddieMay — Mon, 09 Nov 2020 12:53:07 GMT

Hi @thiago_andretta

Can I just confirm that you restarted after editing alfresco-global.properties?

Thanks

Re: Someone can help me, I'm trying to view a 500k xlsx in the browser

thiago_andretta — Tue, 10 Nov 2020 16:19:34 GMT

yes, i reboot

Re: Someone can help me, I'm trying to view a 500k xlsx in the browser

kaynezhang — Tue, 10 Nov 2020 17:04:22 GMT

Please try to add following lines in alfresco-global.properties

content.transformer.default.timeoutMs=120000

content.transformer.OpenOffice.timeoutMs=120000

content.transformer.OpenOffice.extensions.docx.pdf.maxSourceSizeKBytes=-1
content.transformer.OpenOffice.extensions.doc.pdf.maxSourceSizeKBytes=-1
content.transformer.OpenOffice.extensions.xlsx.pdf.maxSourceSizeKBytes=-1
content.transformer.OpenOffice.extensions.xlsm.pdf.maxSourceSizeKBytes=-1
content.transformer.OpenOffice.extensions.xls.pdf.maxSourceSizeKBytes=-1
content.transformer.OpenOffice.extensions.pptx.pdf.maxSourceSizeKBytes=-1
content.transformer.OpenOffice.extensions.ppt.pdf.maxSourceSizeKBytes=-1
content.transformer.OpenOffice.extensions.ppsx.pdf.maxSourceSizeKBytes=-1

content.transformer.OpenOffice.extensions.*.xlsm.supported=true
content.transformer.OpenOffice.extensions.*.pptm.supported=true
content.transformer.OpenOffice.extensions.*.sldm.supported=true
content.transformer.OpenOffice.extensions.*.xltx.supported=true
content.transformer.OpenOffice.extensions.*.docx.supported=true
content.transformer.OpenOffice.extensions.*.potx.supported=true
content.transformer.OpenOffice.extensions.*.xlsx.supported=true
content.transformer.OpenOffice.extensions.*.pptx.supported=true
content.transformer.OpenOffice.extensions.*.xlam.supported=true
content.transformer.OpenOffice.extensions.*.docm.supported=true
content.transformer.OpenOffice.extensions.*.xltm.supported=true
content.transformer.OpenOffice.extensions.*.dotx.supported=true
content.transformer.OpenOffice.extensions.*.xlsb.supported=true
content.transformer.OpenOffice.extensions.*.sldx.supported=true
content.transformer.OpenOffice.extensions.*.ppsm.supported=true
content.transformer.OpenOffice.extensions.*.txt.supported=true
content.transformer.OpenOffice.extensions.*.potm.supported=true
content.transformer.OpenOffice.extensions.*.ppam.supported=true
content.transformer.OpenOffice.extensions.*.dotm.supported=true
content.transformer.OpenOffice.extensions.*.ppsx.supported=true