Affects: Release Notes project_key: SOA 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.
The attachments mentioned in the bug description.
Attachment: Added: DiscountDT.xls Attachment: Added: dt.png
To clarify - the Eclipse used isn't actually JBDS. It's Eclipse 3.6 w. latest JBoss Tools milestone. (aka. the future JBDS 4.)
Link: Added: This issue related BRMS-388
See the linked BRMS issue for resolution. This is now a release notes issue.
Updated for documentation release note requirement for 5.1
Affects: Added: [Release Notes]
Writer: Added: Darrin
Release Notes Docs Status: Added: Documented as Known Issue Release Notes Text: Added: 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.
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 ?
Link: Added: This issue relates to SOA-3409