I suspect it is caused by the spreadsheet validations you have enabled for rows 19 onwards, columns E and F.<br><br>Try removing these - as they look to be a hang-over from (presumably) basing the workbook on an existing example somewhere.<br>
<br><div class="gmail_quote">On 29 May 2012 11:31, zeeshan <span dir="ltr"><<a href="mailto:zeeshan.spring@gmail.com" target="_blank">zeeshan.spring@gmail.com</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
Hi !<br>
<br>
Please find my attached Decision Table. I am getting following error...<br>
<br>
<br>
log4j:WARN No appenders could be found for logger (com.sample.RuleRunner).<br>
log4j:WARN Please initialize the log4j system properly.<br>
Warning: Cell at E20 not present - adding a blank<br>
Warning: Cannot read name ranges for Excel_BuiltIn__FilterDatabase_1 -<br>
setting to empty<br>
Warning: Cannot read name ranges for Excel_BuiltIn__FilterDatabase_1 -<br>
setting to empty<br>
Warning: Cannot read name ranges for Excel_BuiltIn__FilterDatabase_1 -<br>
setting to empty<br>
Exception in thread "main" org.drools.rule.InvalidRulePackage: [10,9]: [ERR<br>
102] Line 10:9 mismatched input '==' in rule "Distribution Cost Rules_11"<br>
[23,9]: [ERR 102] Line 23:9 mismatched input '==' in rule "Distribution Cost<br>
Rules_12"<br>
[36,9]: [ERR 102] Line 36:9 mismatched input '==' in rule "Distribution Cost<br>
Rules_13"<br>
[49,9]: [ERR 102] Line 49:9 mismatched input '==' in rule "Distribution Cost<br>
Rules_14"<br>
[62,9]: [ERR 102] Line 62:9 mismatched input '==' in rule "Distribution Cost<br>
Rules_15"<br>
[75,9]: [ERR 102] Line 75:9 mismatched input '==' in rule "Distribution Cost<br>
Rules_16"<br>
[88,9]: [ERR 102] Line 88:9 mismatched input '==' in rule "Distribution Cost<br>
Rules_17"<br>
[101,9]: [ERR 102] Line 101:9 mismatched input '==' in rule "Distribution<br>
Cost Rules_18"<br>
[114,9]: [ERR 102] Line 114:9 mismatched input '==' in rule "Distribution<br>
Cost Rules_19"<br>
[127,9]: [ERR 102] Line 127:9 mismatched input '==' in rule "Distribution<br>
Cost Rules_20"<br>
[140,9]: [ERR 102] Line 140:9 mismatched input '==' in rule "Distribution<br>
Cost Rules_21"<br>
[153,9]: [ERR 102] Line 153:9 mismatched input '==' in rule "Distribution<br>
Cost Rules_22"<br>
[166,9]: [ERR 102] Line 166:9 mismatched input '==' in rule "Distribution<br>
Cost Rules_23"<br>
[179,9]: [ERR 102] Line 179:9 mismatched input '==' in rule "Distribution<br>
Cost Rules_24"<br>
[192,9]: [ERR 102] Line 192:9 mismatched input '==' in rule "Distribution<br>
Cost Rules_25"<br>
[205,9]: [ERR 102] Line 205:9 mismatched input '==' in rule "Distribution<br>
Cost Rules_26"<br>
[218,9]: [ERR 102] Line 218:9 mismatched input '==' in rule "Distribution<br>
Cost Rules_27"<br>
[231,9]: [ERR 102] Line 231:9 mismatched input '==' in rule "Distribution<br>
Cost Rules_28"<br>
[244,9]: [ERR 102] Line 244:9 mismatched input '==' in rule "Distribution<br>
Cost Rules_29"<br>
[257,9]: [ERR 102] Line 257:9 mismatched input '==' in rule "Distribution<br>
Cost Rules_30"<br>
[270,9]: [ERR 102] Line 270:9 mismatched input '==' in rule "Distribution<br>
Cost Rules_31"<br>
[283,9]: [ERR 102] Line 283:9 mismatched input '==' in rule "Distribution<br>
Cost Rules_32"<br>
[296,9]: [ERR 102] Line 296:9 mismatched input '==' in rule "Distribution<br>
Cost Rules_33"<br>
[309,9]: [ERR 102] Line 309:9 mismatched input '==' in rule "Distribution<br>
Cost Rules_34"<br>
[0,0]: Parser returned a null Package<br>
<br>
at org.drools.rule.Package.checkValidity(Package.java:471)<br>
at<br>
org.drools.common.AbstractRuleBase.addPackages(AbstractRuleBase.java:481)<br>
at org.drools.reteoo.ReteooRuleBase.addPackages(ReteooRuleBase.java:436)<br>
at org.drools.reteoo.ReteooRuleBase.addPackage(ReteooRuleBase.java:443)<br>
at com.sample.RuleRunner.loadRules(RuleRunner.java:70)<br>
at com.sample.RuleRunner.runStatelessRules(RuleRunner.java:185)<br>
at com.sample.RuleMain.main(RuleMain.java:132)<br>
<a href="http://drools.46999.n3.nabble.com/file/n4017627/Distribution_Factor.xls" target="_blank">http://drools.46999.n3.nabble.com/file/n4017627/Distribution_Factor.xls</a><br>
Distribution_Factor.xls<br>
<br>
--<br>
View this message in context: <a href="http://drools.46999.n3.nabble.com/getting-mismatched-error-tp4017627.html" target="_blank">http://drools.46999.n3.nabble.com/getting-mismatched-error-tp4017627.html</a><br>
Sent from the Drools: User forum mailing list archive at Nabble.com.<br>
_______________________________________________<br>
rules-users mailing list<br>
<a href="mailto:rules-users@lists.jboss.org">rules-users@lists.jboss.org</a><br>
<a href="https://lists.jboss.org/mailman/listinfo/rules-users" target="_blank">https://lists.jboss.org/mailman/listinfo/rules-users</a><br>
</blockquote></div><br>