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

Uploading Excel Spreadsheets using OpenJDK 11

XMLWordPrintable

    • Icon: Bug Bug
    • Resolution: Done
    • Icon: Major Major
    • 7.35.0.Final
    • 7.33.0.Final
    • decision tables
    • None
    • 2020 Week 28-30 (from Jul 6)
    • 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.  
    • NEW
    • 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.

              mfusco@redhat.com Mario Fusco
              bvanderwalt@vizuri.com Ben-Johan van der Walt (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

                Created:
                Updated:
                Resolved: