Getting NullPointerException while uploading excel content

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.

vasantry

Hi All

i am using alfresco community edition of version 5.0.d. I am trying to upload the excel sheet of size 450 KB.

Some times the files getting uploaded silently without any errors but most of the time i am seeing the following error

2016-10-24 07:29:29,348 ERROR [org.alfresco.repo.action.AsynchronousActionExecutionQueueImpl] [defaultAsyncAction6] Failed to execute asynchronous action: Action[ id=7015ab7a-eef5-4bb5-a4c0-b0b831f35a52, node=null ]

org.alfresco.error.AlfrescoRuntimeException: 09240041 Creation of thumbnail 'doclib' failed

  at org.alfresco.repo.thumbnail.CreateThumbnailActionExecuter.executeImpl(CreateThumbnailActionExecuter.java:206)

  at org.alfresco.repo.action.executer.ActionExecuterAbstractBase.execute(ActionExecuterAbstractBase.java:265)

  at org.alfresco.repo.action.ActionServiceImpl.directActionExecution(ActionServiceImpl.java:839)

  at org.alfresco.repo.action.ActionServiceImpl.executeActionImpl(ActionServiceImpl.java:739)

  at org.alfresco.repo.action.AsynchronousActionExecutionQueueImpl$ActionExecutionWrapper$1$1.execute(AsynchronousActionExecutionQueueImpl.java:428)

  at org.alfresco.repo.transaction.RetryingTransactionHelper.doInTransaction(RetryingTransactionHelper.java:457)

  at org.alfresco.repo.transaction.RetryingTransactionHelper.doInTransaction(RetryingTransactionHelper.java:326)

  at org.alfresco.repo.action.AsynchronousActionExecutionQueueImpl$ActionExecutionWrapper$1.doWork(AsynchronousActionExecutionQueueImpl.java:437)

  at org.alfresco.repo.tenant.TenantUtil.runAsWork(TenantUtil.java:119)

  at org.alfresco.repo.tenant.TenantUtil.runAsTenant(TenantUtil.java:88)

  at org.alfresco.repo.tenant.TenantUtil$1.doWork(TenantUtil.java:62)

  at org.alfresco.repo.security.authentication.AuthenticationUtil.runAs(AuthenticationUtil.java:548)

  at org.alfresco.repo.tenant.TenantUtil.runAsUserTenant(TenantUtil.java:58)

  at org.alfresco.repo.action.AsynchronousActionExecutionQueueImpl$ActionExecutionWrapper.run(AsynchronousActionExecutionQueueImpl.java:440)

  at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)

  at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)

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

Caused by: org.alfresco.service.cmr.repository.ContentIOException: 09240033 Content conversion failed:

   reader: ContentAccessor[ contentUrl=store://2016/10/21/5/25/fb414f68-b1d0-4828-9388-0d19db80154b.bin, mimetype=application/vnd.openxmlformats-officedocument.spreadsheetml.sheet, size=158309, encoding=UTF-8, locale=en_US]

   writer: ContentAccessor[ contentUrl=store://2016/10/24/7/29/36151f12-70c9-49a6-95be-5adf913c6811.bin, mimetype=image/png, size=0, encoding=UTF-8, locale=en_HK]

   options: {use=doclib, contentReaderNodeRef=workspace://SpacesStore/c9e20324-4fb3-4d5c-8d80-41af55f02596, contentWriterNodeRef=null, sourceContentProperty=null, imageAutoOrient=true, targetContentProperty=null, commandOptions=, imageResizeOptions=ImageResizeOptions [width=100, height=100, maintainAspectRatio=true, percentResize=false, resizeToThumbnail=false, allowEnlargement=false], includeEmbedded=false}

   limits: {timeoutMs=120000}

  at org.alfresco.repo.content.transform.AbstractContentTransformer2.transform(AbstractContentTransformer2.java:332)

  at org.alfresco.repo.content.ContentServiceImpl.transform(ContentServiceImpl.java:631)

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

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

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

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

  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:129)

  at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)

  at org.alfresco.repo.security.permissions.impl.ExceptionTranslatorMethodInterceptor.invoke(ExceptionTranslatorMethodInterceptor.java:46)

  at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)

  at org.alfresco.repo.audit.AuditMethodInterceptor.invoke(AuditMethodInterceptor.java:159)

  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.$Proxy38.transform(Unknown Source)

  at org.alfresco.repo.rendition.executer.AbstractTransformationRenderingEngine$TransformationCallable$1.doWork(AbstractTransformationRenderingEngine.java:439)

  at org.alfresco.repo.rendition.executer.AbstractTransformationRenderingEngine$TransformationCallable$1.doWork(AbstractTransformationRenderingEngine.java:430)

  at org.alfresco.repo.security.authentication.AuthenticationUtil.runAs(AuthenticationUtil.java:548)

  at org.alfresco.repo.rendition.executer.AbstractTransformationRenderingEngine$TransformationCallable.call(AbstractTransformationRenderingEngine.java:429)

  at org.alfresco.repo.rendition.executer.AbstractTransformationRenderingEngine$TransformationCallable.call(AbstractTransformationRenderingEngine.java:404)

  at java.util.concurrent.FutureTask.run(FutureTask.java:266)

  ... 3 more

Caused by: org.alfresco.service.cmr.repository.ContentIOException: 09240030 Content conversion failed:

   reader: ContentAccessor[ contentUrl=store://2016/10/21/5/25/fb414f68-b1d0-4828-9388-0d19db80154b.bin, mimetype=application/vnd.openxmlformats-officedocument.spreadsheetml.sheet, size=158309, encoding=UTF-8, locale=en_US]

   writer: ContentAccessor[ contentUrl=store:///opt/alfresco/alfresco-5.0.d/tomcat/temp/Alfresco/ComplextTransformer_intermediate_xlsx_6514649641552694396.jpg, mimetype=image/jpeg, size=0, encoding=UTF-8, locale=en_HK]

   options: {use=doclib, contentReaderNodeRef=workspace://SpacesStore/c9e20324-4fb3-4d5c-8d80-41af55f02596, contentWriterNodeRef=null, sourceContentProperty=null, imageAutoOrient=true, targetContentProperty=null, commandOptions=, imageResizeOptions=ImageResizeOptions [width=100, height=100, maintainAspectRatio=true, percentResize=false, resizeToThumbnail=false, allowEnlargement=false], includeEmbedded=false}

   limits: {timeoutMs=120000}

  at org.alfresco.repo.content.transform.AbstractContentTransformer2.transform(AbstractContentTransformer2.java:332)

  at org.alfresco.repo.content.ContentServiceImpl.transform(ContentServiceImpl.java:631)

  at org.alfresco.repo.content.transform.ComplexContentTransformer.transformInternal(ComplexContentTransformer.java:477)

  at org.alfresco.repo.content.transform.AbstractContentTransformer2.transform(AbstractContentTransformer2.java:250)

  ... 31 more

Caused by: org.apache.poi.openxml4j.exceptions.OpenXML4JRuntimeException: Fail to save: an error occurs while saving the package : null

  at org.apache.poi.openxml4j.opc.ZipPackage.saveImpl(ZipPackage.java:500)

  at org.apache.poi.openxml4j.opc.OPCPackage.save(OPCPackage.java:1417)

  at org.apache.poi.openxml4j.opc.OPCPackage.save(OPCPackage.java:1404)

  at org.apache.poi.openxml4j.opc.ZipPackage.closeImpl(ZipPackage.java:349)

  at org.apache.poi.openxml4j.opc.OPCPackage.close(OPCPackage.java:420)

  at org.alfresco.repo.content.transform.OOXMLThumbnailContentTransformer.transformInternal(OOXMLThumbnailContentTransformer.java:150)

  at org.alfresco.repo.content.transform.AbstractContentTransformer2.transform(AbstractContentTransformer2.java:250)

  ... 34 more

Caused by: java.lang.NullPointerException

  at org.apache.poi.openxml4j.opc.internal.marshallers.ZipPackagePropertiesMarshaller.marshall(ZipPackagePropertiesMarshaller.java:46)

  at org.apache.poi.openxml4j.opc.ZipPackage.saveImpl(ZipPackage.java:444)

  ... 40 more

2016-10-24 07:30:35,919 DEBUG [org.alfresco.repo.content.metadata.MetadataExtracterRegistry] [http-apr-8080-exec-1] Get extractors for application/vnd.openxmlformats-officedocument.spreadsheetml.sheet

Any help appreciated.

Thanks

Srinivas

kaynezhang

This error occurs when alfresco try to generate thumbnails for this Office documents.for xlsx it will use apache poi library to extract thumbnail from OOXML file，if you upload it as an xlsx file but in fact it is not an xlsx file(for example xls file),poi can't handle it.

Exception like following will be thrown

Caused by: org.apache.poi.openxml4j.exceptions.OpenXML4JRuntimeException: Fail to save: an error occurs while saving the package : null