Status: Resolved (View Workflow)
Affects Version/s: 7.33.0.Final
Fix Version/s: 7.35.0.Final
Component/s: decision tables
Sprint:2020 Week 28-30 (from Jul 6)
Steps to Reproduce:
Make sure that you are running your drools server using OpenJDK 11 Open the workbench and click on the "Add Asset" button. Then select Decision Table (Spreadsheet) Select file type .xlsx Enter a name for the asset and select a .xlsx file (Excel) to be uploaded When you click on the Ok button you will get the error.
- Make sure that you are running your drools server using OpenJDK 11
- Open the workbench and click on the "Add Asset" button.
- Then select Decision Table (Spreadsheet)
- Select file type .xlsx
- Enter a name for the asset and select a .xlsx file (Excel) to be uploaded
- When you click on the Ok button you will get the error.
Docs QE Status:NEW
Using Drools version 7.33.0.Final as well as 7.33.0.Final-redhat-00002.
When trying to upload an Excel Spreadsheet of type .xlsx I am getting a lot of error trying to upload the file. I am able to import the Excel file via the import Asset button, but not by using the "Add Asset" button and adding a new Spreadsheet asset and then uploading the Excel file.
So I am using OpenJDK 11.0.7 and I think that is the reason for the errors.
There are a lot of issues with the libraries from org.apache.poi version 3.17 (e.g. poi-3.17.jar, poi-ooxml-3.17.jar and poi-ooxml-schemas-3.17.jar) which are all part of the drools or decision-central war file. Using OpenJDK you have to use at least version 4.1.1 and update a few other dependancies like commons-compress-1.19.jar and xmlbeans-3.1.0.jar to get it to work.
I do not have a specific excel spreadsheet, but any spreadsheet of type .xlsx will cause the error when trying to upload it.