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 of over 48,000 articles and solutions.

Current Customers and Partners

Log in for full access

Log In
Close

Welcome! Check out the Getting Started with Red Hat page for quick tours and guides for common tasks.