Details

    • Type: Bug Bug
    • Status: Closed Closed (View Workflow)
    • Priority: Major Major
    • Resolution: Out of Date Out of Date
    • Affects Version/s: 5.1.0.ER2
    • Fix Version/s: 5.2.0 GA
    • Component/s: Documentation, JBoss Rules
    • Security Level: Public (Everyone can see)
    • Labels:
      None
    • 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
    • Similar Issues:
      Show 10 results 

      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.

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

        Issue Links

          Activity

          Hide
          Lukáš Petrovický
          added a comment -

          The attachments mentioned in the bug description.

          Show
          Lukáš Petrovický
          added a comment - The attachments mentioned in the bug description.
          Hide
          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
          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
          Lukáš Petrovický
          added a comment -

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

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

          Updated for documentation release note requirement for 5.1

          Show
          John Graham
          added a comment - Updated for documentation release note requirement for 5.1
          Hide
          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 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
          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
          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:
              Jervis Liu
              Reporter:
              Lukáš Petrovický
              Writer:
              Darrin Mison
            • Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: