Is password protected XLS file supported?
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.