Uploaded image for project: 'Drools'
  1. Drools
  2. DROOLS-5494

Uploading Excel Spreadsheets using OpenJDK 11

    XMLWordPrintable

    Details

    • Sprint:
      2020 Week 28-30 (from Jul 6)
    • Steps to Reproduce:
      Hide
      • 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.

       

      Show
      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
    • QE Status:
      NEW

      Description

      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.

        Attachments

          Activity

            People

            Assignee:
            mfusco Mario Fusco
            Reporter:
            bvanderwalt Ben-Johan van der Walt (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

              Dates

              Created:
              Updated:
              Resolved: