Details

    • Affects:
      Release Notes
    • Affects Testing:
      Regression
    • Release Notes Text:
      Hide
      Importing an Microsoft Excel spreadsheet into in a Knowledge Base will cause an exception to be thrown ( StringIndexOutOfBoundsException ) if the spreadsheet was created in Excel 95 or earlier. This is because of an issue in the JXL library which is used to handle these files. This can be worked around by opening and saving the spreadsheet in Microsoft Excel 97 or greater or with OpenOffice.org Calc.

      This will be fixed in a future release.
      Show
      Importing an Microsoft Excel spreadsheet into in a Knowledge Base will cause an exception to be thrown ( StringIndexOutOfBoundsException ) if the spreadsheet was created in Excel 95 or earlier. This is because of an issue in the JXL library which is used to handle these files. This can be worked around by opening and saving the spreadsheet in Microsoft Excel 97 or greater or with OpenOffice.org Calc. This will be fixed in a future release.
    • Release Notes Docs Status:
      Documented as Known Issue

      Description

      The attached XLS decision table, when used in a knowledge base, produces the following exception:

      java.lang.StringIndexOutOfBoundsException: String index out of range: 78
      at java.lang.String.checkBounds(String.java:409)
      at java.lang.String.<init>(String.java:450)
      at jxl.biff.StringHelper.getString(StringHelper.java:164)
      at jxl.read.biff.WriteAccessRecord.<init>(WriteAccessRecord.java:56)
      at jxl.read.biff.WorkbookParser.parse(WorkbookParser.java:821)
      at jxl.Workbook.getWorkbook(Workbook.java:271)
      at jxl.Workbook.getWorkbook(Workbook.java:253)
      at org.drools.decisiontable.parser.xls.ExcelParser.parseFile(ExcelParser.java:74)
      at org.drools.decisiontable.SpreadsheetCompiler.compile(SpreadsheetCompiler.java:90)
      at org.drools.decisiontable.SpreadsheetCompiler.compile(SpreadsheetCompiler.java:69)
      at org.drools.decisiontable.DecisionTableProviderImpl.compileStream(DecisionTableProviderImpl.java:29)
      at org.drools.decisiontable.DecisionTableProviderImpl.loadFromInputStream(DecisionTableProviderImpl.java:19)
      at org.drools.compiler.DecisionTableFactory.loadFromInputStream(DecisionTableFactory.java:18)
      at org.drools.compiler.PackageBuilder.addKnowledgeResource(PackageBuilder.java:482)
      at org.drools.builder.impl.KnowledgeBuilderImpl.add(KnowledgeBuilderImpl.java:34)
      ... (Rest of the stack trace omitted, because it originally came from the ESB BRP action.)

      I intended to create a reproducer for the issue, but then I found out that simply putting the XLS in a Drools project in JBDS results in the very same error. (See attached screenshot.)

      This is a regression compared to SOA 5.0.

        Gliffy Diagrams

          Attachments

            Issue Links

              Activity

                People

                • Assignee:
                  jervisliu Jervis Liu
                  Reporter:
                  lpetrovicky Lukáš Petrovický
                  Writer:
                  Darrin Mison
                • Votes:
                  0 Vote for this issue
                  Watchers:
                  2 Start watching this issue

                  Dates

                  • Created:
                    Updated:
                    Resolved: