-
Type:
Service Pack Request
-
Status: Closed
-
Resolution: Deferred
-
Affects Version/s: 5.2.3
-
Fix Version/s: None
-
Component/s: Tika, POI, and Metadata Extraction, Transformations
-
Labels:None
-
Bug Priority:
Category 3
-
ACT Numbers:
00966182
Excessive ERROR level logging is written to alfresco.log whenever a password protected Excel document is uploaded to Alfresco, or when a Share user browses to the document.
Steps to Reproduce
1. On Alfresco 5.2.3 out of the box, upload the attached password protected Excel document to Alfresco Share. The document password is "password".
2. Monitor the alfresco.log for two actions, uploading the document when the Tika extraction fails and browsing to the document in Alfresco Share.
Expectation
The detected mimetype for the document
application/x-tika-ooxml-protected
should trigger a WARN log as there is no interface for supplying the password to Alfresco, therefore the document cannot be opened for indexing or transformation. However the subsequent ERROR logs should not occur as the use case is not triggering a code error.
Observation
The WARN is logged but there are several ERROR logs and associated stack traces that fill the alfresco.log. For example:
Upload the password protected document:
<snip> 2018-07-03 10:44:05,487 WARN [org.alfresco.repo.content.metadata.AbstractMappingMetadataExtracter] Metadata extraction failed (turn on DEBUG for full error): Extracter: org.alfresco.repo.content.metadata.PoiMetadataExtracter@4647a1e7 Content: ContentAccessor[ contentUrl=store://2018/7/3/10/44/1cb3d700-944a-4ef2-9a42-bef82bf55d37.bin, mimetype=application/vnd.openxmlformats-officedocument.spreadsheetml.sheet, size=14336, encoding=UTF-8, locale=en_GB] Failure: Error creating OOXML extractor claimed mime type: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet detected mime type: application/x-tika-ooxml-protected .... 2018-07-03 10:44:08,225 ERROR [org.alfresco.repo.action.AsynchronousActionExecutionQueueImpl] Failed to execute asynchronous action: Action[ id=19c6d13c-b779-468e-aee7-895ad68fac4d, node=null ]: Unsupported URL <file:///home/alfresco/alfresco-5.2.3/tomcat/temp/Alfresco/JodContentTransformer-source-7625464285135052911.xlsx>: "type detection aborted" org.alfresco.error.AlfrescoRuntimeException: 06030032 Creation of thumbnail 'doclib' failed .... Caused by: org.alfresco.service.cmr.repository.ContentIOException: 06030025 Content conversion failed: reader: ContentAccessor[ contentUrl=store://2018/7/3/10/44/1cb3d700-944a-4ef2-9a42-bef82bf55d37.bin, mimetype=application/x-tika-ooxml-protected, size=14336, encoding=UTF-8, locale=en_GB] writer: ContentAccessor[ contentUrl=store:///home/alfresco/alfresco-5.2.3/tomcat/temp/Alfresco/FailoverTransformer_intermediate__5285989211988172718.png, mimetype=image/png, size=0, encoding=UTF-8, locale=en_GB] </snip>
Navigate in Share to the password protected document:
<snip> 2018-07-03 10:50:21,199 ERROR [org.alfresco.repo.web.scripts.RepositoryContainer] Server error (06030038) org.springframework.extensions.webscripts.WebScriptException: 06030006 Wrapped Exception (with status template): 06030037 Failed to execute script 'classpath*:alfresco/templates/webscripts/org/alfresco/repository/thumbnail/thumbnail.get.js': 06030036 Content conversion failed: reader: ContentAccessor[ contentUrl=store://2018/7/3/10/44/1cb3d700-944a-4ef2-9a42-bef82bf55d37.bin, mimetype=application/x-tika-ooxml-protected, size=14336, encoding=UTF-8, locale=en_GB] writer: ContentAccessor[ contentUrl=store://2018/7/3/10/50/a16d6c7e-2db0-4c82-a0f9-fb9b9106d13a.bin, mimetype=application/pdf, size=0, encoding=UTF-8, locale=en_GB] options: {use=pdf, contentReaderNodeRef=workspace://SpacesStore/35888833-4c39-4b4e-97e6-23c491695054, sourceContentProperty=null, contentWriterNodeRef=workspace://SpacesStore/2b7aa391-b677-4108-b0be-f86d781d106a, targetContentProperty=null, includeEmbedded=null} limits: {timeoutMs=120000} claimed mime type: application/x-tika-ooxml-protected detected mime type: application/x-tika-ooxml-protected transformer not found .... 2018-07-03 10:50:21,201 ERROR [org.springframework.extensions.webscripts.AbstractRuntime] Exception from executeScript: Server error (06030038). Details can be found in the server logs. java.lang.RuntimeException: Server error (06030038). Details can be found in the server logs. at org.alfresco.repo.web.scripts.RepositoryContainer.executeScript(RepositoryContainer.java:328) </snip>
