[jboss-jira] [JBoss JIRA] (DROOLS-1382) "No RuleTable cells in spreadsheet"

[John Dunning (JIRA)]

    [ https://issues.jboss.org/browse/DROOLS-1382?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13339817#comment-13339817 ] 

John Dunning commented on DROOLS-1382:
--------------------------------------

created a completely new project with non-commercial code, that I could publish on GitHub to demonstrate the problem.  Ironically, this new project created from scratch worked first time and every time :(

Am currently migrating the commercial code to that project to see at what point it breaks if indeed it does.  Should have that done by cop today (GMT)

> "No RuleTable cells in spreadsheet"
> -----------------------------------
>
>                 Key: DROOLS-1382
>                 URL: https://issues.jboss.org/browse/DROOLS-1382
>             Project: Drools
>          Issue Type: Bug
>          Components: decision tables
>    Affects Versions: 6.3.0.Final, 6.5.0.Final
>         Environment: OSX 10.12
> Excel for Mac
> Drools 6.3.0.Final and Drools 6.5.0.Final
> Intellij IDEA  Ultimate 2016.1
> second machine  Intellij IDEA CE 2016.2
>            Reporter: John Dunning
>            Assignee: Mario Fusco
>            Priority: Blocker
>
> Mac OSX Drools 6.3.0.Final and recreated in Drools 6.5.0.Final
> Checked out the Drools6.3.0 example code, and also example code from Mastering Drools 6 book for RuleTemplates using spreadsheets as template data.
> Both projects compile and work in their own environment.
> Replicated similar for a Government Project and KnowledgeBase compilation fails with "No Ruletable cells in Spreadsheet".
> This ruleset is one ruleset in a multi-ruleset project that is configured using kmodule.xml.  Other rulesets include DRL and Decision Tables.
> The rules for this ruleset are in the same package in src/main/resources of a project that also includes all the executable code.  The fact model is also included in the executable code. Created an excel spreadsheet using Excel for Mac, and created the DRT file. The rules also include a DRL file.  Got the "No Ruletable cells in Spreadsheet" error when building the knowledge base. 
> Removed the DRL file and the KnowledgeBase built.  Put the DRL file back and the KnowledgeBase still built.
> Copied the project and the problem recurred.
> Created separate projects for each ruleset - each with its own kmodule.xml.  Each ruleset is a Maven Module in a Maven Project.  This ruleset contains only one DRT, one DRL and and XLS with data only.  It also contains java code for one fact.
> Cannot create a KnowledgeBase from this ruleset even when dependencies for all other rulesets are commented out.  None of the other rulesets use templates but they do use decision tables, DRL files and have facts specific to the ruleset.
> Moved the RuleSet from a Maven Module to a separate Maven Project.  Problem still recurred.  Separated the Fact Model (single fact) into a separate Maven Project.  Problem still recurred.
> Wondered if it may be a issue with Excel for Mac so copied the xls and DRT files from both Drools 6.3 examples and Mastering Drools examples and neither compiles when copied and pasted into a new project - same error  "No Ruletable cells in Spreadsheet".
> Moved Drools to 6.5.0.final and problem recurred
> IDE - Intellij IDEA Ultimate 2016.1 
> second machine
> Mac OSX Drools 6.3.0.Final and recreated in Drools 6.5.0.Final
> I can be contacted for more information and/or an example project that replicates the problem.



--
This message was sent by Atlassian JIRA
(v7.2.3#72005)