Is password protected XLS file supported?

Solution Unverified - Updated -

Issue

When uploading XLS file in business central, it fails with the following exception if it's protected by password.

12:19:11,603 INFO  [org.drools.workbench.screens.dtablexls.backend.server.DecisionTableXLSServiceImpl] (http-localhost.localdomain/127.0.0.1:8080-11) USER:bpmsAdmin CREATING asset [Sample-pwprotected.xls]
12:19:11,610 ERROR [org.drools.workbench.screens.dtablexls.backend.server.DecisionTableXLSServiceImpl] (http-localhost.localdomain/127.0.0.1:8080-11) DecisionTableParseException: Default password is invalid for salt/verifier/verifierHash: org.drools.template.parser.DecisionTableParseException: DecisionTableParseException: Default password is invalid for salt/verifier/verifierHash
    at org.drools.workbench.screens.dtablexls.backend.server.DecisionTableXLSServiceImpl.create(DecisionTableXLSServiceImpl.java:173) [drools-wb-dtable-xls-editor-backend-6.3.0.Final-redhat-7.jar:6.3.0.Final-redhat-7]
    at org.drools.workbench.screens.dtablexls.backend.server.DecisionTableXLSServiceImpl$Proxy$_$$_WeldClientProxy.create(DecisionTableXLSServiceImpl$Proxy$_$$_WeldClientProxy.java) [drools-wb-dtable-xls-editor-backend-6.3.0.Final-redhat-7.jar:6.3.0.Final-redhat-7]
    at org.drools.workbench.screens.dtablexls.backend.server.DecisionTableXLSFileServlet.doCreate(DecisionTableXLSFileServlet.java:57) [drools-wb-dtable-xls-editor-backend-6.3.0.Final-redhat-7.jar:6.3.0.Final-redhat-7]
    at org.guvnor.common.services.backend.file.upload.AbstractFileServlet.uploadFile(AbstractFileServlet.java:225) [guvnor-services-backend-6.3.0.Final-redhat-7.jar:6.3.0.Final-redhat-7]
    at org.guvnor.common.services.backend.file.upload.AbstractFileServlet.processUpload(AbstractFileServlet.java:205) [guvnor-services-backend-6.3.0.Final-redhat-7.jar:6.3.0.Final-redhat-7]
    at org.guvnor.common.services.backend.file.upload.AbstractFileServlet.doPost(AbstractFileServlet.java:114) [guvnor-services-backend-6.3.0.Final-redhat-7.jar:6.3.0.Final-redhat-7]
    at javax.servlet.http.HttpServlet.service(HttpServlet.java:754) [jboss-servlet-api_3.0_spec-1.0.2.Final-redhat-2.jar:1.0.2.Final-redhat-2]
    at javax.servlet.http.HttpServlet.service(HttpServlet.java:847) [jboss-servlet-api_3.0_spec-1.0.2.Final-redhat-2.jar:1.0.2.Final-redhat-2]
    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:295) [jbossweb-7.5.11.Final-redhat-1.jar:7.5.11.Final-redhat-1]
    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:214) [jbossweb-7.5.11.Final-redhat-1.jar:7.5.11.Final-redhat-1]
    at org.uberfire.ext.security.server.SecureHeadersFilter.doFilter(SecureHeadersFilter.java:53) [uberfire-servlet-security-0.7.5.Final-redhat-2.jar:0.7.5.Final-redhat-2]
    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:246) [jbossweb-7.5.11.Final-redhat-1.jar:7.5.11.Final-redhat-1]
    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:214) [jbossweb-7.5.11.Final-redhat-1.jar:7.5.11.Final-redhat-1]
    at org.uberfire.ext.security.server.SecurityIntegrationFilter.doFilter(SecurityIntegrationFilter.java:45) [uberfire-servlet-security-0.7.5.Final-redhat-2.jar:0.7.5.Final-redhat-2]
    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:246) [jbossweb-7.5.11.Final-redhat-1.jar:7.5.11.Final-redhat-1]
    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:214) [jbossweb-7.5.11.Final-redhat-1.jar:7.5.11.Final-redhat-1]
    at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:231) [jbossweb-7.5.11.Final-redhat-1.jar:7.5.11.Final-redhat-1]
    at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:149) [jbossweb-7.5.11.Final-redhat-1.jar:7.5.11.Final-redhat-1]
    at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:512) [jbossweb-7.5.11.Final-redhat-1.jar:7.5.11.Final-redhat-1]
    at org.jboss.as.jpa.interceptor.WebNonTxEmCloserValve.invoke(WebNonTxEmCloserValve.java:50) [jboss-as-jpa-7.5.4.Final-redhat-4.jar:7.5.4.Final-redhat-4]
    at org.jboss.as.jpa.interceptor.WebNonTxEmCloserValve.invoke(WebNonTxEmCloserValve.java:50) [jboss-as-jpa-7.5.4.Final-redhat-4.jar:7.5.4.Final-redhat-4]
    at org.jboss.as.web.security.SecurityContextAssociationValve.invoke(SecurityContextAssociationValve.java:169) [jboss-as-web-7.5.4.Final-redhat-4.jar:7.5.4.Final-redhat-4]
    at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:150) [jbossweb-7.5.11.Final-redhat-1.jar:7.5.11.Final-redhat-1]
    at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:97) [jbossweb-7.5.11.Final-redhat-1.jar:7.5.11.Final-redhat-1]
    at org.apache.catalina.authenticator.SingleSignOn.invoke(SingleSignOn.java:419) [jbossweb-7.5.11.Final-redhat-1.jar:7.5.11.Final-redhat-1]
    at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:102) [jbossweb-7.5.11.Final-redhat-1.jar:7.5.11.Final-redhat-1]
    at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:344) [jbossweb-7.5.11.Final-redhat-1.jar:7.5.11.Final-redhat-1]
    at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:854) [jbossweb-7.5.11.Final-redhat-1.jar:7.5.11.Final-redhat-1]
    at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:653) [jbossweb-7.5.11.Final-redhat-1.jar:7.5.11.Final-redhat-1]
    at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:926) [jbossweb-7.5.11.Final-redhat-1.jar:7.5.11.Final-redhat-1]
    at java.lang.Thread.run(Thread.java:745) [rt.jar:1.7.0_79]
Caused by: org.apache.poi.EncryptedDocumentException: Default password is invalid for salt/verifier/verifierHash
    at org.apache.poi.hssf.record.RecordFactoryInputStream$StreamEncryptionInfo.createDecryptingStream(RecordFactoryInputStream.java:127) [poi-3.13.jar:3.13]
    at org.apache.poi.hssf.record.RecordFactoryInputStream.<init>(RecordFactoryInputStream.java:209) [poi-3.13.jar:3.13]
    at org.apache.poi.hssf.record.RecordFactory.createRecords(RecordFactory.java:475) [poi-3.13.jar:3.13]
    at org.apache.poi.hssf.usermodel.HSSFWorkbook.<init>(HSSFWorkbook.java:343) [poi-3.13.jar:3.13]
    at org.apache.poi.ss.usermodel.WorkbookFactory.create(WorkbookFactory.java:124) [poi-ooxml-3.13.jar:3.13]
    at org.apache.poi.ss.usermodel.WorkbookFactory.create(WorkbookFactory.java:206) [poi-ooxml-3.13.jar:3.13]
    at org.apache.poi.ss.usermodel.WorkbookFactory.create(WorkbookFactory.java:168) [poi-ooxml-3.13.jar:3.13]
    at org.drools.workbench.screens.dtablexls.backend.server.DecisionTableXLSServiceImpl.create(DecisionTableXLSServiceImpl.java:165) [drools-wb-dtable-xls-editor-backend-6.3.0.Final-redhat-7.jar:6.3.0.Final-redhat-7]
    ... 30 more

Is password protected XLS file supported?

Environment

Red Hat JBoss BRMS
- 6.x

Subscriber exclusive content

A Red Hat subscription provides unlimited access to our knowledgebase, tools, and much more.

Current Customers and Partners

Log in for full access

Log In

New to Red Hat?

Learn more about Red Hat subscriptions

Using a Red Hat product through a public cloud?

How to access this content