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

        1. DiscountDT.xls
          122 kB
          Lukáš Petrovický
        1. dt.png
          90 kB

          Issue Links

            Activity

            Hide
            lpetrovicky Lukáš Petrovický added a comment -

            The attachments mentioned in the bug description.

            Show
            lpetrovicky Lukáš Petrovický added a comment - The attachments mentioned in the bug description.
            Hide
            lpetrovicky Lukáš Petrovický added a comment -

            To clarify - the Eclipse used isn't actually JBDS. It's Eclipse 3.6 w. latest JBoss Tools milestone. (aka. the future JBDS 4.)

            Show
            lpetrovicky Lukáš Petrovický added a comment - To clarify - the Eclipse used isn't actually JBDS. It's Eclipse 3.6 w. latest JBoss Tools milestone. (aka. the future JBDS 4.)
            Hide
            lpetrovicky Lukáš Petrovický added a comment -

            See the linked BRMS issue for resolution. This is now a release notes issue.

            Show
            lpetrovicky Lukáš Petrovický added a comment - See the linked BRMS issue for resolution. This is now a release notes issue.
            Hide
            john.graham John Graham added a comment -

            Updated for documentation release note requirement for 5.1

            Show
            john.graham John Graham added a comment - Updated for documentation release note requirement for 5.1
            Hide
            Darrin Darrin Mison added a comment -

            Hi Jervis, I've added this to the Known Issues for SOA 5.1 - is this all that is required to be done for this issue does it need to be kept open for a future fix ?

            Show
            Darrin Darrin Mison added a comment - Hi Jervis, I've added this to the Known Issues for SOA 5.1 - is this all that is required to be done for this issue does it need to be kept open for a future fix ?
            Hide
            jira-bugzilla-migration RH Bugzilla Integration added a comment -

            This issue has been migrated to Bugzilla bug 780061. Please note that this JIRA issue has been closed as part of the migration and therefore you will need to check the Bugzilla issue to find the current status.

            Show
            jira-bugzilla-migration RH Bugzilla Integration added a comment - This issue has been migrated to Bugzilla bug 780061 . Please note that this JIRA issue has been closed as part of the migration and therefore you will need to check the Bugzilla issue to find the current status.

              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:

                  Development