Uploaded image for project: 'Service Packs and Hot Fixes'
  1. Service Packs and Hot Fixes
  2. MNT-19777

Excessive ERROR level logging triggered by password protected document transformation failure

    Details

    • Bug Priority:
      Category 3
    • ACT Numbers:

      00966182

      Description

      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>
      

        Attachments

          Issue Links

            Structure

              Activity

                People

                • Assignee:
                  closedissues Closed Issues
                  Reporter:
                  gcussen Gerald Cussen [X] (Inactive)
                • Votes:
                  0 Vote for this issue
                  Watchers:
                  2 Start watching this issue

                  Dates

                  • Created:
                    Updated:
                    Resolved:

                    Structure Helper Panel