Uploaded image for project: 'JBoss Enterprise SOA Platform'
  1. JBoss Enterprise SOA Platform
  2. SOA-2426

Decision Table: String Index Out Of Range

    XMLWordPrintable

    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

          1. DiscountDT.xls
            122 kB
          2. dt.png
            dt.png
            90 kB

            Issue Links

            relates to

            Bug - A problem which impairs or prevents the functions of the product. SOA-3409 StringIndexOutOfBounds while parsing XLS based decision table

            • Blocker - An issue (bug, feature, task) that blocks development and/or testing work, production could not run. An upcoming version that is affected by this issue cannot be released until it's addressed.
            • Closed

            Bug - A problem which impairs or prevents the functions of the product. BRMS-388 Decision Table: String Index Out Of Range

            • Major - A request that should be considered seriously but is not a show stopper.
            • Closed

              Activity

                People

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

                  Dates

                  • Created:
                    Updated:
                    Resolved: