Getting NullPointerException while uploading excel content

[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

[vasantry]

Thanks Zhang for your reply, We asked the content editor to edit the excel in their common platform (eg. google sheets) which will avoid this error and we tested it works perfectly.

[openpj]

As kayne zhang​ said, have you tried to change the Mimetype for this content after the upload?