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

[John Dunning (JIRA)]

John Dunning created DROOLS-1382:
------------------------------------

             Summary: "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.5.0.Final, 6.3.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 is 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 knowledgeable 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.

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

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 is 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 knowledgeable 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.

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  Intellij IDEA CE 2016.2

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)